ITPub博客

首页 > 数据库 > Oracle > how to use fnd message in PL/SQL

how to use fnd message in PL/SQL

原创 Oracle 作者:419088217 时间:2015-12-01 16:15:08 0 删除 编辑
1. Create a message with variable 
Patch: Application Developer/ Message/

Current Message Text:
The Customer Bill To on this Service Request has failed credit check. Please review and respond as appropriate.<br/>
<br/>
Service Request Identifier: SR#&V_SR_NUM<br/>
Customer: &V_CUSTOMER_NAME<br/>
Bill To Customer: &V_BILLTO_CUST_NAME<br/>
Customer Bill To Account Number: &V_BILLTO_ACCT_NUM<br/>
Initiating Business Unit: &V_BUSINESS_UNIT<br/>
Service Rep: &V_SR_CREATED_BY<br/>
<br/>
<br/>
<br/>
Note: This is an auto generated e-mail. Please do not reply.


2. use it in the PL/SQL program

      FND_MESSAGE.CLEAR;  --clear the message
      FND_MESSAGE.SET_NAME ('XXCS', 'XXCS_CREDIT_CHK_NOTIFICATION'); -- set message name
      fnd_message.set_token ('V_SR_NUM', i_sr_num);    --assign value to message variable
      FND_MESSAGE.SET_TOKEN ('V_CUSTOMER_NAME', V_CHR_CUST_NAME);
      FND_MESSAGE.SET_TOKEN ('V_BILLTO_CUST_NAME', V_BILLTO_CUST_NAME);
      FND_MESSAGE.SET_TOKEN ('V_BILLTO_ACCT_NUM', V_ACCOUNT_NUMBER);
      FND_MESSAGE.SET_TOKEN ('V_BUSINESS_UNIT', V_BUSINESS_UNIT);
      fnd_message.set_token ('V_SR_CREATED_BY', v_chr_created_by);
      v_message := FND_MESSAGE.GET; -- fetch the message text


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/13975809/viewspace-1850683/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-12-25

  • 博文量
    63
  • 访问量
    52243