eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_POOL_WF dependencies on FND_MESSAGE

Line 109: fnd_message.set_name(G_APP_NAME,p_msg_name);

105: ,p_msg_token IN VARCHAR2
106: ,p_token_value IN VARCHAR2
107: ) RETURN VARCHAR2 IS
108: BEGIN
109: fnd_message.set_name(G_APP_NAME,p_msg_name);
110: IF(p_msg_token IS NOT NULL)THEN
111: fnd_message.set_token(p_msg_token,p_token_value);
112: END IF;
113: RETURN fnd_message.get;

Line 111: fnd_message.set_token(p_msg_token,p_token_value);

107: ) RETURN VARCHAR2 IS
108: BEGIN
109: fnd_message.set_name(G_APP_NAME,p_msg_name);
110: IF(p_msg_token IS NOT NULL)THEN
111: fnd_message.set_token(p_msg_token,p_token_value);
112: END IF;
113: RETURN fnd_message.get;
114: END get_message;
115:

Line 113: RETURN fnd_message.get;

109: fnd_message.set_name(G_APP_NAME,p_msg_name);
110: IF(p_msg_token IS NOT NULL)THEN
111: fnd_message.set_token(p_msg_token,p_token_value);
112: END IF;
113: RETURN fnd_message.get;
114: END get_message;
115:
116: FUNCTION get_pool_msg_body(itemtype IN VARCHAR2
117: ,itemkey IN VARCHAR2) RETURN VARCHAR2 IS

Line 242: fnd_message.set_name(G_APP_NAME,message);

238: END IF;
239: -- format this amount
240: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
241:
242: fnd_message.set_name(G_APP_NAME,message);
243: fnd_message.set_token('NAME', lv_pool_name);
244:
245: IF('POOL' = pool_or_line)THEN
246: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);

Line 243: fnd_message.set_token('NAME', lv_pool_name);

239: -- format this amount
240: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
241:
242: fnd_message.set_name(G_APP_NAME,message);
243: fnd_message.set_token('NAME', lv_pool_name);
244:
245: IF('POOL' = pool_or_line)THEN
246: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
247: ELSIF('BUDGET' = pool_or_line)THEN

Line 246: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);

242: fnd_message.set_name(G_APP_NAME,message);
243: fnd_message.set_token('NAME', lv_pool_name);
244:
245: IF('POOL' = pool_or_line)THEN
246: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
247: ELSIF('BUDGET' = pool_or_line)THEN
248: fnd_message.set_token('BUDGET', lv_total_budget);
249: END IF;
250:

Line 248: fnd_message.set_token('BUDGET', lv_total_budget);

244:
245: IF('POOL' = pool_or_line)THEN
246: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
247: ELSIF('BUDGET' = pool_or_line)THEN
248: fnd_message.set_token('BUDGET', lv_total_budget);
249: END IF;
250:
251: fnd_message.set_token('CURR', lv_currency_code);
252: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 251: fnd_message.set_token('CURR', lv_currency_code);

247: ELSIF('BUDGET' = pool_or_line)THEN
248: fnd_message.set_token('BUDGET', lv_total_budget);
249: END IF;
250:
251: fnd_message.set_token('CURR', lv_currency_code);
252: wf_engine.SetItemAttrText(itemtype => itemtype,
253: itemkey => itemkey,
254: aname => attrib,
255: avalue => fnd_message.get

Line 255: avalue => fnd_message.get

251: fnd_message.set_token('CURR', lv_currency_code);
252: wf_engine.SetItemAttrText(itemtype => itemtype,
253: itemkey => itemkey,
254: aname => attrib,
255: avalue => fnd_message.get
256: );
257:
258: END set_attrib_message;
259:

Line 951: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVAL_SUB');

947: aname => G_WF_ITM_TOTAL_BUDGETS);
948: -- format this amount
949: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
950:
951: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVAL_SUB');
952: fnd_message.set_token('NAME', lv_pool_name);
953: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
954: fnd_message.set_token('CURR', lv_currency_code);
955:

Line 952: fnd_message.set_token('NAME', lv_pool_name);

948: -- format this amount
949: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
950:
951: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVAL_SUB');
952: fnd_message.set_token('NAME', lv_pool_name);
953: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
954: fnd_message.set_token('CURR', lv_currency_code);
955:
956: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 953: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);

949: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
950:
951: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVAL_SUB');
952: fnd_message.set_token('NAME', lv_pool_name);
953: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
954: fnd_message.set_token('CURR', lv_currency_code);
955:
956: wf_engine.SetItemAttrText (itemtype => itemtype,
957: itemkey => itemkey,

Line 954: fnd_message.set_token('CURR', lv_currency_code);

950:
951: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVAL_SUB');
952: fnd_message.set_token('NAME', lv_pool_name);
953: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
954: fnd_message.set_token('CURR', lv_currency_code);
955:
956: wf_engine.SetItemAttrText (itemtype => itemtype,
957: itemkey => itemkey,
958: aname => G_WF_ITM_MESSAGE_SUBJECT,

Line 959: avalue => fnd_message.get);

955:
956: wf_engine.SetItemAttrText (itemtype => itemtype,
957: itemkey => itemkey,
958: aname => G_WF_ITM_MESSAGE_SUBJECT,
959: avalue => fnd_message.get);
960:
961: -- OKL_SUB_POOL_REQ_APPROVAL_BOD (TOTAL_BUDGET, CURR, FROM_DATE, TO_DATE, POOL_DESCR, REQUESTOR) G_WF_ITM_MESSAGE_BODY
962: wf_engine.SetItemAttrText (itemtype => itemtype,
963: itemkey => itemkey,

Line 981: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVAL_SUB');

977: itemkey => itemkey,
978: aname => G_WF_ITM_BUDGET_TYPE);
979: lv_budget_type := okl_accounting_util.get_lookup_meaning('OKL_SUB_POOL_LINE_TYPE',lv_budget_type);
980:
981: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVAL_SUB');
982: fnd_message.set_token('NAME', lv_pool_name);
983: fnd_message.set_token('BUDGET', lv_total_budget);
984: fnd_message.set_token('CURR', lv_currency_code);
985:

Line 982: fnd_message.set_token('NAME', lv_pool_name);

978: aname => G_WF_ITM_BUDGET_TYPE);
979: lv_budget_type := okl_accounting_util.get_lookup_meaning('OKL_SUB_POOL_LINE_TYPE',lv_budget_type);
980:
981: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVAL_SUB');
982: fnd_message.set_token('NAME', lv_pool_name);
983: fnd_message.set_token('BUDGET', lv_total_budget);
984: fnd_message.set_token('CURR', lv_currency_code);
985:
986: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 983: fnd_message.set_token('BUDGET', lv_total_budget);

979: lv_budget_type := okl_accounting_util.get_lookup_meaning('OKL_SUB_POOL_LINE_TYPE',lv_budget_type);
980:
981: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVAL_SUB');
982: fnd_message.set_token('NAME', lv_pool_name);
983: fnd_message.set_token('BUDGET', lv_total_budget);
984: fnd_message.set_token('CURR', lv_currency_code);
985:
986: wf_engine.SetItemAttrText (itemtype => itemtype,
987: itemkey => itemkey,

Line 984: fnd_message.set_token('CURR', lv_currency_code);

980:
981: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVAL_SUB');
982: fnd_message.set_token('NAME', lv_pool_name);
983: fnd_message.set_token('BUDGET', lv_total_budget);
984: fnd_message.set_token('CURR', lv_currency_code);
985:
986: wf_engine.SetItemAttrText (itemtype => itemtype,
987: itemkey => itemkey,
988: aname => G_WF_ITM_MESSAGE_SUBJECT,

Line 989: avalue => fnd_message.get);

985:
986: wf_engine.SetItemAttrText (itemtype => itemtype,
987: itemkey => itemkey,
988: aname => G_WF_ITM_MESSAGE_SUBJECT,
989: avalue => fnd_message.get);
990:
991: -- OKL_SUB_LINE_REQ_APPROVAL_BOD (BUDGET, FROM_DATE, NAME, REQUESTOR)
992: wf_engine.SetItemAttrText (itemtype => itemtype,
993: itemkey => itemkey,

Line 1082: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_SUB');

1078: aname => G_WF_ITM_TOTAL_BUDGETS);
1079: -- format this amount
1080: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
1081:
1082: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_SUB');
1083: fnd_message.set_token('NAME', lv_pool_name);
1084: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
1085: fnd_message.set_token('CURR', lv_currency_code);
1086:

Line 1083: fnd_message.set_token('NAME', lv_pool_name);

1079: -- format this amount
1080: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
1081:
1082: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_SUB');
1083: fnd_message.set_token('NAME', lv_pool_name);
1084: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
1085: fnd_message.set_token('CURR', lv_currency_code);
1086:
1087: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1084: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);

1080: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
1081:
1082: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_SUB');
1083: fnd_message.set_token('NAME', lv_pool_name);
1084: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
1085: fnd_message.set_token('CURR', lv_currency_code);
1086:
1087: wf_engine.SetItemAttrText (itemtype => itemtype,
1088: itemkey => itemkey,

Line 1085: fnd_message.set_token('CURR', lv_currency_code);

1081:
1082: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_SUB');
1083: fnd_message.set_token('NAME', lv_pool_name);
1084: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
1085: fnd_message.set_token('CURR', lv_currency_code);
1086:
1087: wf_engine.SetItemAttrText (itemtype => itemtype,
1088: itemkey => itemkey,
1089: aname => G_WF_ITM_MESSAGE_SUBJECT,

Line 1090: avalue => fnd_message.get);

1086:
1087: wf_engine.SetItemAttrText (itemtype => itemtype,
1088: itemkey => itemkey,
1089: aname => G_WF_ITM_MESSAGE_SUBJECT,
1090: avalue => fnd_message.get);
1091:
1092: -- OKL_SUB_POOL_REQ_APPROVED_BOD (TOTAL_BUDGET, CURR, FROM_DATE, TO_DATE, POOL_DESCR, REQUESTOR) G_WF_ITM_MESSAGE_BODY
1093: lv_from_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
1094: itemkey => itemkey,

Line 1103: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_BOD');

1099: lv_pool_description := wf_engine.GetItemAttrText(itemtype => itemtype,
1100: itemkey => itemkey,
1101: aname => G_WF_ITM_POOL_DESCR);
1102:
1103: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_BOD');
1104: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1105: fnd_message.set_token('CURR',lv_currency_code);
1106: fnd_message.set_token('FROM_DATE',lv_from_date);
1107: fnd_message.set_token('TO_DATE',lv_to_date);

Line 1104: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);

1100: itemkey => itemkey,
1101: aname => G_WF_ITM_POOL_DESCR);
1102:
1103: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_BOD');
1104: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1105: fnd_message.set_token('CURR',lv_currency_code);
1106: fnd_message.set_token('FROM_DATE',lv_from_date);
1107: fnd_message.set_token('TO_DATE',lv_to_date);
1108: fnd_message.set_token('POOL_DESCR',lv_pool_description);

Line 1105: fnd_message.set_token('CURR',lv_currency_code);

1101: aname => G_WF_ITM_POOL_DESCR);
1102:
1103: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_BOD');
1104: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1105: fnd_message.set_token('CURR',lv_currency_code);
1106: fnd_message.set_token('FROM_DATE',lv_from_date);
1107: fnd_message.set_token('TO_DATE',lv_to_date);
1108: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1109: fnd_message.set_token('APPROVER',lv_approver);*/

Line 1106: fnd_message.set_token('FROM_DATE',lv_from_date);

1102:
1103: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_BOD');
1104: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1105: fnd_message.set_token('CURR',lv_currency_code);
1106: fnd_message.set_token('FROM_DATE',lv_from_date);
1107: fnd_message.set_token('TO_DATE',lv_to_date);
1108: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1109: fnd_message.set_token('APPROVER',lv_approver);*/
1110:

Line 1107: fnd_message.set_token('TO_DATE',lv_to_date);

1103: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_APPROVED_BOD');
1104: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1105: fnd_message.set_token('CURR',lv_currency_code);
1106: fnd_message.set_token('FROM_DATE',lv_from_date);
1107: fnd_message.set_token('TO_DATE',lv_to_date);
1108: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1109: fnd_message.set_token('APPROVER',lv_approver);*/
1110:
1111: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1108: fnd_message.set_token('POOL_DESCR',lv_pool_description);

1104: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1105: fnd_message.set_token('CURR',lv_currency_code);
1106: fnd_message.set_token('FROM_DATE',lv_from_date);
1107: fnd_message.set_token('TO_DATE',lv_to_date);
1108: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1109: fnd_message.set_token('APPROVER',lv_approver);*/
1110:
1111: wf_engine.SetItemAttrText (itemtype => itemtype,
1112: itemkey => itemkey,

Line 1109: fnd_message.set_token('APPROVER',lv_approver);*/

1105: fnd_message.set_token('CURR',lv_currency_code);
1106: fnd_message.set_token('FROM_DATE',lv_from_date);
1107: fnd_message.set_token('TO_DATE',lv_to_date);
1108: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1109: fnd_message.set_token('APPROVER',lv_approver);*/
1110:
1111: wf_engine.SetItemAttrText (itemtype => itemtype,
1112: itemkey => itemkey,
1113: aname => G_WF_ITM_MESSAGE_BODY,

Line 1129: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVED_SUB');

1125: itemkey => itemkey,
1126: aname => G_WF_ITM_BUDGET_TYPE);
1127: lv_budget_type := okl_accounting_util.get_lookup_meaning('OKL_SUB_POOL_LINE_TYPE',lv_budget_type);
1128:
1129: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVED_SUB');
1130: fnd_message.set_token('NAME', lv_pool_name);
1131: fnd_message.set_token('BUDGET', lv_total_budget);
1132: fnd_message.set_token('CURR', lv_currency_code);
1133:

Line 1130: fnd_message.set_token('NAME', lv_pool_name);

1126: aname => G_WF_ITM_BUDGET_TYPE);
1127: lv_budget_type := okl_accounting_util.get_lookup_meaning('OKL_SUB_POOL_LINE_TYPE',lv_budget_type);
1128:
1129: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVED_SUB');
1130: fnd_message.set_token('NAME', lv_pool_name);
1131: fnd_message.set_token('BUDGET', lv_total_budget);
1132: fnd_message.set_token('CURR', lv_currency_code);
1133:
1134: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1131: fnd_message.set_token('BUDGET', lv_total_budget);

1127: lv_budget_type := okl_accounting_util.get_lookup_meaning('OKL_SUB_POOL_LINE_TYPE',lv_budget_type);
1128:
1129: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVED_SUB');
1130: fnd_message.set_token('NAME', lv_pool_name);
1131: fnd_message.set_token('BUDGET', lv_total_budget);
1132: fnd_message.set_token('CURR', lv_currency_code);
1133:
1134: wf_engine.SetItemAttrText (itemtype => itemtype,
1135: itemkey => itemkey,

Line 1132: fnd_message.set_token('CURR', lv_currency_code);

1128:
1129: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_APPROVED_SUB');
1130: fnd_message.set_token('NAME', lv_pool_name);
1131: fnd_message.set_token('BUDGET', lv_total_budget);
1132: fnd_message.set_token('CURR', lv_currency_code);
1133:
1134: wf_engine.SetItemAttrText (itemtype => itemtype,
1135: itemkey => itemkey,
1136: aname => G_WF_ITM_MESSAGE_SUBJECT,

Line 1137: avalue => fnd_message.get);

1133:
1134: wf_engine.SetItemAttrText (itemtype => itemtype,
1135: itemkey => itemkey,
1136: aname => G_WF_ITM_MESSAGE_SUBJECT,
1137: avalue => fnd_message.get);
1138:
1139: -- OKL_SUB_LINE_REQ_APPROVED_BOD (BUDGET, FROM_DATE, NAME, REQUESTOR)
1140: lv_from_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
1141: itemkey => itemkey,

Line 1146: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_APPROVED_BOD');

1142: aname => G_WF_ITM_BUDGET_FROM_DATE);
1143:
1144: lv_from_date := to_date(lv_from_date,'DD/MM/RRRR');
1145:
1146: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_APPROVED_BOD');
1147: fnd_message.set_token('BUDGET', lv_total_budget);
1148: fnd_message.set_token('CURR', lv_currency_code);
1149: fnd_message.set_token('FROM_DATE', lv_from_date);
1150: fnd_message.set_token('TYPE', lv_budget_type);

Line 1147: fnd_message.set_token('BUDGET', lv_total_budget);

1143:
1144: lv_from_date := to_date(lv_from_date,'DD/MM/RRRR');
1145:
1146: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_APPROVED_BOD');
1147: fnd_message.set_token('BUDGET', lv_total_budget);
1148: fnd_message.set_token('CURR', lv_currency_code);
1149: fnd_message.set_token('FROM_DATE', lv_from_date);
1150: fnd_message.set_token('TYPE', lv_budget_type);
1151: fnd_message.set_token('NAME', lv_pool_name);

Line 1148: fnd_message.set_token('CURR', lv_currency_code);

1144: lv_from_date := to_date(lv_from_date,'DD/MM/RRRR');
1145:
1146: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_APPROVED_BOD');
1147: fnd_message.set_token('BUDGET', lv_total_budget);
1148: fnd_message.set_token('CURR', lv_currency_code);
1149: fnd_message.set_token('FROM_DATE', lv_from_date);
1150: fnd_message.set_token('TYPE', lv_budget_type);
1151: fnd_message.set_token('NAME', lv_pool_name);
1152: fnd_message.set_token('APPROVER', lv_approver);*/

Line 1149: fnd_message.set_token('FROM_DATE', lv_from_date);

1145:
1146: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_APPROVED_BOD');
1147: fnd_message.set_token('BUDGET', lv_total_budget);
1148: fnd_message.set_token('CURR', lv_currency_code);
1149: fnd_message.set_token('FROM_DATE', lv_from_date);
1150: fnd_message.set_token('TYPE', lv_budget_type);
1151: fnd_message.set_token('NAME', lv_pool_name);
1152: fnd_message.set_token('APPROVER', lv_approver);*/
1153:

Line 1150: fnd_message.set_token('TYPE', lv_budget_type);

1146: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_APPROVED_BOD');
1147: fnd_message.set_token('BUDGET', lv_total_budget);
1148: fnd_message.set_token('CURR', lv_currency_code);
1149: fnd_message.set_token('FROM_DATE', lv_from_date);
1150: fnd_message.set_token('TYPE', lv_budget_type);
1151: fnd_message.set_token('NAME', lv_pool_name);
1152: fnd_message.set_token('APPROVER', lv_approver);*/
1153:
1154: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1151: fnd_message.set_token('NAME', lv_pool_name);

1147: fnd_message.set_token('BUDGET', lv_total_budget);
1148: fnd_message.set_token('CURR', lv_currency_code);
1149: fnd_message.set_token('FROM_DATE', lv_from_date);
1150: fnd_message.set_token('TYPE', lv_budget_type);
1151: fnd_message.set_token('NAME', lv_pool_name);
1152: fnd_message.set_token('APPROVER', lv_approver);*/
1153:
1154: wf_engine.SetItemAttrText (itemtype => itemtype,
1155: itemkey => itemkey,

Line 1152: fnd_message.set_token('APPROVER', lv_approver);*/

1148: fnd_message.set_token('CURR', lv_currency_code);
1149: fnd_message.set_token('FROM_DATE', lv_from_date);
1150: fnd_message.set_token('TYPE', lv_budget_type);
1151: fnd_message.set_token('NAME', lv_pool_name);
1152: fnd_message.set_token('APPROVER', lv_approver);*/
1153:
1154: wf_engine.SetItemAttrText (itemtype => itemtype,
1155: itemkey => itemkey,
1156: aname => G_WF_ITM_MESSAGE_BODY,

Line 1170: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_SUB');

1166: aname => G_WF_ITM_TOTAL_BUDGETS);
1167: -- format this amount
1168: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
1169:
1170: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_SUB');
1171: fnd_message.set_token('NAME', lv_pool_name);
1172: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
1173: fnd_message.set_token('CURR', lv_currency_code);
1174:

Line 1171: fnd_message.set_token('NAME', lv_pool_name);

1167: -- format this amount
1168: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
1169:
1170: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_SUB');
1171: fnd_message.set_token('NAME', lv_pool_name);
1172: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
1173: fnd_message.set_token('CURR', lv_currency_code);
1174:
1175: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1172: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);

1168: lv_total_budget := okl_accounting_util.format_amount(lv_total_budget,lv_currency_code);
1169:
1170: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_SUB');
1171: fnd_message.set_token('NAME', lv_pool_name);
1172: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
1173: fnd_message.set_token('CURR', lv_currency_code);
1174:
1175: wf_engine.SetItemAttrText (itemtype => itemtype,
1176: itemkey => itemkey,

Line 1173: fnd_message.set_token('CURR', lv_currency_code);

1169:
1170: fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_SUB');
1171: fnd_message.set_token('NAME', lv_pool_name);
1172: fnd_message.set_token('TOTAL_BUDGET', lv_total_budget);
1173: fnd_message.set_token('CURR', lv_currency_code);
1174:
1175: wf_engine.SetItemAttrText (itemtype => itemtype,
1176: itemkey => itemkey,
1177: aname => G_WF_ITM_MESSAGE_SUBJECT,

Line 1178: avalue => fnd_message.get);

1174:
1175: wf_engine.SetItemAttrText (itemtype => itemtype,
1176: itemkey => itemkey,
1177: aname => G_WF_ITM_MESSAGE_SUBJECT,
1178: avalue => fnd_message.get);
1179:
1180: -- OKL_SUB_POOL_REQ_REJECT_BOD (TOTAL_BUDGET, CURR, FROM_DATE, TO_DATE, POOL_DESCR, REQUESTOR) G_WF_ITM_MESSAGE_BODY
1181: lv_from_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
1182: itemkey => itemkey,

Line 1191: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_BOD');

1187: lv_pool_description := wf_engine.GetItemAttrText(itemtype => itemtype,
1188: itemkey => itemkey,
1189: aname => G_WF_ITM_POOL_DESCR);
1190:
1191: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_BOD');
1192: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1193: fnd_message.set_token('CURR',lv_currency_code);
1194: fnd_message.set_token('FROM_DATE',lv_from_date);
1195: fnd_message.set_token('TO_DATE',lv_to_date);

Line 1192: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);

1188: itemkey => itemkey,
1189: aname => G_WF_ITM_POOL_DESCR);
1190:
1191: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_BOD');
1192: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1193: fnd_message.set_token('CURR',lv_currency_code);
1194: fnd_message.set_token('FROM_DATE',lv_from_date);
1195: fnd_message.set_token('TO_DATE',lv_to_date);
1196: fnd_message.set_token('POOL_DESCR',lv_pool_description);

Line 1193: fnd_message.set_token('CURR',lv_currency_code);

1189: aname => G_WF_ITM_POOL_DESCR);
1190:
1191: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_BOD');
1192: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1193: fnd_message.set_token('CURR',lv_currency_code);
1194: fnd_message.set_token('FROM_DATE',lv_from_date);
1195: fnd_message.set_token('TO_DATE',lv_to_date);
1196: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1197: fnd_message.set_token('APPROVER',lv_approver);*/

Line 1194: fnd_message.set_token('FROM_DATE',lv_from_date);

1190:
1191: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_BOD');
1192: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1193: fnd_message.set_token('CURR',lv_currency_code);
1194: fnd_message.set_token('FROM_DATE',lv_from_date);
1195: fnd_message.set_token('TO_DATE',lv_to_date);
1196: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1197: fnd_message.set_token('APPROVER',lv_approver);*/
1198:

Line 1195: fnd_message.set_token('TO_DATE',lv_to_date);

1191: /*fnd_message.set_name(G_APP_NAME,'OKL_SUB_POOL_REQ_REJECT_BOD');
1192: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1193: fnd_message.set_token('CURR',lv_currency_code);
1194: fnd_message.set_token('FROM_DATE',lv_from_date);
1195: fnd_message.set_token('TO_DATE',lv_to_date);
1196: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1197: fnd_message.set_token('APPROVER',lv_approver);*/
1198:
1199: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1196: fnd_message.set_token('POOL_DESCR',lv_pool_description);

1192: fnd_message.set_token('TOTAL_BUDGET',lv_total_budget);
1193: fnd_message.set_token('CURR',lv_currency_code);
1194: fnd_message.set_token('FROM_DATE',lv_from_date);
1195: fnd_message.set_token('TO_DATE',lv_to_date);
1196: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1197: fnd_message.set_token('APPROVER',lv_approver);*/
1198:
1199: wf_engine.SetItemAttrText (itemtype => itemtype,
1200: itemkey => itemkey,

Line 1197: fnd_message.set_token('APPROVER',lv_approver);*/

1193: fnd_message.set_token('CURR',lv_currency_code);
1194: fnd_message.set_token('FROM_DATE',lv_from_date);
1195: fnd_message.set_token('TO_DATE',lv_to_date);
1196: fnd_message.set_token('POOL_DESCR',lv_pool_description);
1197: fnd_message.set_token('APPROVER',lv_approver);*/
1198:
1199: wf_engine.SetItemAttrText (itemtype => itemtype,
1200: itemkey => itemkey,
1201: aname => G_WF_ITM_MESSAGE_BODY,

Line 1217: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_REJECT_SUB');

1213: itemkey => itemkey,
1214: aname => G_WF_ITM_BUDGET_TYPE);
1215: lv_budget_type := okl_accounting_util.get_lookup_meaning('OKL_SUB_POOL_LINE_TYPE',lv_budget_type);
1216:
1217: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_REJECT_SUB');
1218: fnd_message.set_token('NAME', lv_pool_name);
1219: fnd_message.set_token('BUDGET', lv_total_budget);
1220: fnd_message.set_token('CURR', lv_currency_code);
1221:

Line 1218: fnd_message.set_token('NAME', lv_pool_name);

1214: aname => G_WF_ITM_BUDGET_TYPE);
1215: lv_budget_type := okl_accounting_util.get_lookup_meaning('OKL_SUB_POOL_LINE_TYPE',lv_budget_type);
1216:
1217: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_REJECT_SUB');
1218: fnd_message.set_token('NAME', lv_pool_name);
1219: fnd_message.set_token('BUDGET', lv_total_budget);
1220: fnd_message.set_token('CURR', lv_currency_code);
1221:
1222: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1219: fnd_message.set_token('BUDGET', lv_total_budget);

1215: lv_budget_type := okl_accounting_util.get_lookup_meaning('OKL_SUB_POOL_LINE_TYPE',lv_budget_type);
1216:
1217: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_REJECT_SUB');
1218: fnd_message.set_token('NAME', lv_pool_name);
1219: fnd_message.set_token('BUDGET', lv_total_budget);
1220: fnd_message.set_token('CURR', lv_currency_code);
1221:
1222: wf_engine.SetItemAttrText (itemtype => itemtype,
1223: itemkey => itemkey,

Line 1220: fnd_message.set_token('CURR', lv_currency_code);

1216:
1217: fnd_message.set_name(G_APP_NAME,'OKL_SUB_LINE_REQ_REJECT_SUB');
1218: fnd_message.set_token('NAME', lv_pool_name);
1219: fnd_message.set_token('BUDGET', lv_total_budget);
1220: fnd_message.set_token('CURR', lv_currency_code);
1221:
1222: wf_engine.SetItemAttrText (itemtype => itemtype,
1223: itemkey => itemkey,
1224: aname => G_WF_ITM_MESSAGE_SUBJECT,

Line 1225: avalue => fnd_message.get);

1221:
1222: wf_engine.SetItemAttrText (itemtype => itemtype,
1223: itemkey => itemkey,
1224: aname => G_WF_ITM_MESSAGE_SUBJECT,
1225: avalue => fnd_message.get);
1226:
1227: -- OKL_SUB_LINE_REQ_REJECT_BOD (BUDGET, FROM_DATE, NAME, REQUESTOR)
1228: lv_from_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
1229: itemkey => itemkey,

Line 1234: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_REJECT_BOD');

1230: aname => G_WF_ITM_BUDGET_FROM_DATE);
1231:
1232: lv_from_date := to_date(lv_from_date,'DD/MM/RRRR');
1233:
1234: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_REJECT_BOD');
1235: fnd_message.set_token('BUDGET', lv_total_budget);
1236: fnd_message.set_token('CURR', lv_currency_code);
1237: fnd_message.set_token('FROM_DATE', lv_from_date);
1238: fnd_message.set_token('TYPE', lv_budget_type);

Line 1235: fnd_message.set_token('BUDGET', lv_total_budget);

1231:
1232: lv_from_date := to_date(lv_from_date,'DD/MM/RRRR');
1233:
1234: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_REJECT_BOD');
1235: fnd_message.set_token('BUDGET', lv_total_budget);
1236: fnd_message.set_token('CURR', lv_currency_code);
1237: fnd_message.set_token('FROM_DATE', lv_from_date);
1238: fnd_message.set_token('TYPE', lv_budget_type);
1239: fnd_message.set_token('NAME', lv_pool_name);

Line 1236: fnd_message.set_token('CURR', lv_currency_code);

1232: lv_from_date := to_date(lv_from_date,'DD/MM/RRRR');
1233:
1234: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_REJECT_BOD');
1235: fnd_message.set_token('BUDGET', lv_total_budget);
1236: fnd_message.set_token('CURR', lv_currency_code);
1237: fnd_message.set_token('FROM_DATE', lv_from_date);
1238: fnd_message.set_token('TYPE', lv_budget_type);
1239: fnd_message.set_token('NAME', lv_pool_name);
1240: fnd_message.set_token('APPROVER', lv_approver);*/

Line 1237: fnd_message.set_token('FROM_DATE', lv_from_date);

1233:
1234: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_REJECT_BOD');
1235: fnd_message.set_token('BUDGET', lv_total_budget);
1236: fnd_message.set_token('CURR', lv_currency_code);
1237: fnd_message.set_token('FROM_DATE', lv_from_date);
1238: fnd_message.set_token('TYPE', lv_budget_type);
1239: fnd_message.set_token('NAME', lv_pool_name);
1240: fnd_message.set_token('APPROVER', lv_approver);*/
1241:

Line 1238: fnd_message.set_token('TYPE', lv_budget_type);

1234: /*fnd_message.set_name(G_APP_NAME, 'OKL_SUB_LINE_REQ_REJECT_BOD');
1235: fnd_message.set_token('BUDGET', lv_total_budget);
1236: fnd_message.set_token('CURR', lv_currency_code);
1237: fnd_message.set_token('FROM_DATE', lv_from_date);
1238: fnd_message.set_token('TYPE', lv_budget_type);
1239: fnd_message.set_token('NAME', lv_pool_name);
1240: fnd_message.set_token('APPROVER', lv_approver);*/
1241:
1242: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1239: fnd_message.set_token('NAME', lv_pool_name);

1235: fnd_message.set_token('BUDGET', lv_total_budget);
1236: fnd_message.set_token('CURR', lv_currency_code);
1237: fnd_message.set_token('FROM_DATE', lv_from_date);
1238: fnd_message.set_token('TYPE', lv_budget_type);
1239: fnd_message.set_token('NAME', lv_pool_name);
1240: fnd_message.set_token('APPROVER', lv_approver);*/
1241:
1242: wf_engine.SetItemAttrText (itemtype => itemtype,
1243: itemkey => itemkey,

Line 1240: fnd_message.set_token('APPROVER', lv_approver);*/

1236: fnd_message.set_token('CURR', lv_currency_code);
1237: fnd_message.set_token('FROM_DATE', lv_from_date);
1238: fnd_message.set_token('TYPE', lv_budget_type);
1239: fnd_message.set_token('NAME', lv_pool_name);
1240: fnd_message.set_token('APPROVER', lv_approver);*/
1241:
1242: wf_engine.SetItemAttrText (itemtype => itemtype,
1243: itemkey => itemkey,
1244: aname => G_WF_ITM_MESSAGE_BODY,