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.OZF_CLAIM_APPROVAL_PVT dependencies on FND_MESSAGE

Line 238: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OFFER_PERF_NTF');

234: OPEN csr_offer_name(l_offer_perf_tbl(j).offer_id);
235: FETCH csr_offer_name INTO l_offer_name;
236: CLOSE csr_offer_name;
237:
238: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OFFER_PERF_NTF');
239: FND_MESSAGE.set_token('OFFER', l_offer_name, false);
240:
241: x_offer_perf_req := x_offer_perf_req || FND_MESSAGE.get;
242: END LOOP;

Line 239: FND_MESSAGE.set_token('OFFER', l_offer_name, false);

235: FETCH csr_offer_name INTO l_offer_name;
236: CLOSE csr_offer_name;
237:
238: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OFFER_PERF_NTF');
239: FND_MESSAGE.set_token('OFFER', l_offer_name, false);
240:
241: x_offer_perf_req := x_offer_perf_req || FND_MESSAGE.get;
242: END LOOP;
243: END IF;

Line 241: x_offer_perf_req := x_offer_perf_req || FND_MESSAGE.get;

237:
238: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OFFER_PERF_NTF');
239: FND_MESSAGE.set_token('OFFER', l_offer_name, false);
240:
241: x_offer_perf_req := x_offer_perf_req || FND_MESSAGE.get;
242: END LOOP;
243: END IF;
244: END get_offer_perf_req;
245:

Line 268: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OFFER_EARN_NTF');

264: );
265:
266: IF l_offer_earn_tbl.count > 0 THEN
267: FOR j IN l_offer_earn_tbl.FIRST..l_offer_earn_tbl.LAST LOOP
268: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OFFER_EARN_NTF');
269: FND_MESSAGE.set_token('AMOUNT', l_offer_earn_tbl(j).acctd_amount_over, false);
270:
271: OPEN csr_offer_name(l_offer_earn_tbl(j).offer_id);
272: FETCH csr_offer_name INTO l_offer_name;

Line 269: FND_MESSAGE.set_token('AMOUNT', l_offer_earn_tbl(j).acctd_amount_over, false);

265:
266: IF l_offer_earn_tbl.count > 0 THEN
267: FOR j IN l_offer_earn_tbl.FIRST..l_offer_earn_tbl.LAST LOOP
268: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OFFER_EARN_NTF');
269: FND_MESSAGE.set_token('AMOUNT', l_offer_earn_tbl(j).acctd_amount_over, false);
270:
271: OPEN csr_offer_name(l_offer_earn_tbl(j).offer_id);
272: FETCH csr_offer_name INTO l_offer_name;
273: CLOSE csr_offer_name;

Line 274: FND_MESSAGE.set_token('OFFER', l_offer_name, false);

270:
271: OPEN csr_offer_name(l_offer_earn_tbl(j).offer_id);
272: FETCH csr_offer_name INTO l_offer_name;
273: CLOSE csr_offer_name;
274: FND_MESSAGE.set_token('OFFER', l_offer_name, false);
275:
276: x_offer_earn_req := x_offer_earn_req || FND_MESSAGE.get;
277: END LOOP;
278: END IF;

Line 276: x_offer_earn_req := x_offer_earn_req || FND_MESSAGE.get;

272: FETCH csr_offer_name INTO l_offer_name;
273: CLOSE csr_offer_name;
274: FND_MESSAGE.set_token('OFFER', l_offer_name, false);
275:
276: x_offer_earn_req := x_offer_earn_req || FND_MESSAGE.get;
277: END LOOP;
278: END IF;
279:
280: END get_offer_earn_req;

Line 449: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');

445: , l_claim_source;
446: CLOSE c_claim_rec;
447:
448: IF l_approval_type = 'PERFORMANCE' THEN
449: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
450: ELSIF l_approval_type = 'EARNING' THEN
451: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
452: ELSE
453: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');

Line 451: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');

447:
448: IF l_approval_type = 'PERFORMANCE' THEN
449: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
450: ELSIF l_approval_type = 'EARNING' THEN
451: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
452: ELSE
453: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
454: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
455: fnd_message.set_token('AMOUNT', l_requested_amt, false);

Line 453: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');

449: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
450: ELSIF l_approval_type = 'EARNING' THEN
451: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
452: ELSE
453: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
454: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
455: fnd_message.set_token('AMOUNT', l_requested_amt, false);
456: END IF;
457: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 454: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

450: ELSIF l_approval_type = 'EARNING' THEN
451: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
452: ELSE
453: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
454: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
455: fnd_message.set_token('AMOUNT', l_requested_amt, false);
456: END IF;
457: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
458: --fnd_message.set_token('APPROVER', l_approver, false);

Line 455: fnd_message.set_token('AMOUNT', l_requested_amt, false);

451: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
452: ELSE
453: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
454: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
455: fnd_message.set_token('AMOUNT', l_requested_amt, false);
456: END IF;
457: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
458: --fnd_message.set_token('APPROVER', l_approver, false);
459: l_subject := fnd_message.get;

Line 457: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

453: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
454: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
455: fnd_message.set_token('AMOUNT', l_requested_amt, false);
456: END IF;
457: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
458: --fnd_message.set_token('APPROVER', l_approver, false);
459: l_subject := fnd_message.get;
460:
461: wf_engine.setitemattrtext(

Line 458: --fnd_message.set_token('APPROVER', l_approver, false);

454: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
455: fnd_message.set_token('AMOUNT', l_requested_amt, false);
456: END IF;
457: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
458: --fnd_message.set_token('APPROVER', l_approver, false);
459: l_subject := fnd_message.get;
460:
461: wf_engine.setitemattrtext(
462: itemtype => l_item_type

Line 459: l_subject := fnd_message.get;

455: fnd_message.set_token('AMOUNT', l_requested_amt, false);
456: END IF;
457: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
458: --fnd_message.set_token('APPROVER', l_approver, false);
459: l_subject := fnd_message.get;
460:
461: wf_engine.setitemattrtext(
462: itemtype => l_item_type
463: ,itemkey => l_item_key

Line 470: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_INFO');

466: );
467:
468: IF l_approval_type = 'PERFORMANCE' THEN
469: get_offer_perf_req(l_claim_id, l_offer_req);
470: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_INFO');
471: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
472: ELSIF l_approval_type = 'EARNING' THEN
473: get_offer_earn_req(l_claim_id, l_offer_req);
474: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');

Line 471: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);

467:
468: IF l_approval_type = 'PERFORMANCE' THEN
469: get_offer_perf_req(l_claim_id, l_offer_req);
470: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_INFO');
471: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
472: ELSIF l_approval_type = 'EARNING' THEN
473: get_offer_earn_req(l_claim_id, l_offer_req);
474: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
475: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

Line 474: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');

470: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_INFO');
471: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
472: ELSIF l_approval_type = 'EARNING' THEN
473: get_offer_earn_req(l_claim_id, l_offer_req);
474: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
475: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
476: ELSE
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
478: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');

Line 475: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

471: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
472: ELSIF l_approval_type = 'EARNING' THEN
473: get_offer_earn_req(l_claim_id, l_offer_req);
474: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
475: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
476: ELSE
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
478: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
479: END IF;

Line 477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');

473: get_offer_earn_req(l_claim_id, l_offer_req);
474: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
475: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
476: ELSE
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
478: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
479: END IF;
480: fnd_message.set_token('APPROVER_NAME', l_approver, false);
481: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);

Line 478: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');

474: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
475: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
476: ELSE
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
478: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
479: END IF;
480: fnd_message.set_token('APPROVER_NAME', l_approver, false);
481: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
482: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);

Line 480: fnd_message.set_token('APPROVER_NAME', l_approver, false);

476: ELSE
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
478: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
479: END IF;
480: fnd_message.set_token('APPROVER_NAME', l_approver, false);
481: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
482: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
483: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);

Line 481: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);

477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
478: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
479: END IF;
480: fnd_message.set_token('APPROVER_NAME', l_approver, false);
481: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
482: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
483: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

Line 482: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);

478: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
479: END IF;
480: fnd_message.set_token('APPROVER_NAME', l_approver, false);
481: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
482: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
483: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
486: fnd_message.set_token('DUE_DATE', l_due_date, false);

Line 483: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

479: END IF;
480: fnd_message.set_token('APPROVER_NAME', l_approver, false);
481: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
482: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
483: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
486: fnd_message.set_token('DUE_DATE', l_due_date, false);
487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

Line 484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);

480: fnd_message.set_token('APPROVER_NAME', l_approver, false);
481: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
482: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
483: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
486: fnd_message.set_token('DUE_DATE', l_due_date, false);
487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

Line 485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

481: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
482: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
483: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
486: fnd_message.set_token('DUE_DATE', l_due_date, false);
487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

Line 486: fnd_message.set_token('DUE_DATE', l_due_date, false);

482: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
483: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
486: fnd_message.set_token('DUE_DATE', l_due_date, false);
487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
490: fnd_message.set_token('CM_REASON', l_cm_reason, false);

Line 487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

483: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
486: fnd_message.set_token('DUE_DATE', l_due_date, false);
487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
490: fnd_message.set_token('CM_REASON', l_cm_reason, false);
491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

Line 488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

484: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
486: fnd_message.set_token('DUE_DATE', l_due_date, false);
487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
490: fnd_message.set_token('CM_REASON', l_cm_reason, false);
491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

485: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
486: fnd_message.set_token('DUE_DATE', l_due_date, false);
487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
490: fnd_message.set_token('CM_REASON', l_cm_reason, false);
491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
493: fnd_message.set_token('AMOUNT', l_requested_amt, false);

Line 490: fnd_message.set_token('CM_REASON', l_cm_reason, false);

486: fnd_message.set_token('DUE_DATE', l_due_date, false);
487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
490: fnd_message.set_token('CM_REASON', l_cm_reason, false);
491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
493: fnd_message.set_token('AMOUNT', l_requested_amt, false);
494: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

Line 491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

487: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
490: fnd_message.set_token('CM_REASON', l_cm_reason, false);
491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
493: fnd_message.set_token('AMOUNT', l_requested_amt, false);
494: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
495: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);

Line 492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

488: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
490: fnd_message.set_token('CM_REASON', l_cm_reason, false);
491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
493: fnd_message.set_token('AMOUNT', l_requested_amt, false);
494: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
495: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
496: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

Line 493: fnd_message.set_token('AMOUNT', l_requested_amt, false);

489: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
490: fnd_message.set_token('CM_REASON', l_cm_reason, false);
491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
493: fnd_message.set_token('AMOUNT', l_requested_amt, false);
494: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
495: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
496: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
497: l_body := fnd_message.get;

Line 494: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

490: fnd_message.set_token('CM_REASON', l_cm_reason, false);
491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
493: fnd_message.set_token('AMOUNT', l_requested_amt, false);
494: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
495: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
496: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
497: l_body := fnd_message.get;
498: /*

Line 495: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);

491: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
493: fnd_message.set_token('AMOUNT', l_requested_amt, false);
494: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
495: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
496: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
497: l_body := fnd_message.get;
498: /*
499: l_note := wf_engine.getitemattrtext(

Line 496: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

492: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
493: fnd_message.set_token('AMOUNT', l_requested_amt, false);
494: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
495: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
496: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
497: l_body := fnd_message.get;
498: /*
499: l_note := wf_engine.getitemattrtext(
500: itemtype => l_item_type

Line 497: l_body := fnd_message.get;

493: fnd_message.set_token('AMOUNT', l_requested_amt, false);
494: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
495: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
496: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
497: l_body := fnd_message.get;
498: /*
499: l_note := wf_engine.getitemattrtext(
500: itemtype => l_item_type
501: ,itemkey => l_item_key

Line 735: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');

731: , l_claim_source;
732: CLOSE c_claim_rec;
733:
734: IF l_approval_type = 'PERFORMANCE' THEN
735: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
736: ELSIF l_approval_type = 'EARNING' THEN
737: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
738: ELSE
739: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');

Line 737: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');

733:
734: IF l_approval_type = 'PERFORMANCE' THEN
735: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
736: ELSIF l_approval_type = 'EARNING' THEN
737: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
738: ELSE
739: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
740: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
741: fnd_message.set_token('AMOUNT', l_requested_amt, false);

Line 739: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');

735: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
736: ELSIF l_approval_type = 'EARNING' THEN
737: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
738: ELSE
739: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
740: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
741: fnd_message.set_token('AMOUNT', l_requested_amt, false);
742: END IF;
743: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 740: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

736: ELSIF l_approval_type = 'EARNING' THEN
737: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
738: ELSE
739: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
740: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
741: fnd_message.set_token('AMOUNT', l_requested_amt, false);
742: END IF;
743: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
744: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 741: fnd_message.set_token('AMOUNT', l_requested_amt, false);

737: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
738: ELSE
739: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
740: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
741: fnd_message.set_token('AMOUNT', l_requested_amt, false);
742: END IF;
743: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
744: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
745: l_subject := fnd_message.get;

Line 743: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

739: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
740: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
741: fnd_message.set_token('AMOUNT', l_requested_amt, false);
742: END IF;
743: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
744: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
745: l_subject := fnd_message.get;
746:
747: wf_engine.setitemattrtext(

Line 744: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

740: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
741: fnd_message.set_token('AMOUNT', l_requested_amt, false);
742: END IF;
743: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
744: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
745: l_subject := fnd_message.get;
746:
747: wf_engine.setitemattrtext(
748: itemtype => l_item_type

Line 745: l_subject := fnd_message.get;

741: fnd_message.set_token('AMOUNT', l_requested_amt, false);
742: END IF;
743: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
744: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
745: l_subject := fnd_message.get;
746:
747: wf_engine.setitemattrtext(
748: itemtype => l_item_type
749: ,itemkey => l_item_key

Line 756: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_INFO');

752: );
753:
754: IF l_approval_type = 'PERFORMANCE' THEN
755: get_offer_perf_req(l_claim_id, l_offer_req);
756: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_INFO');
757: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
758: ELSIF l_approval_type = 'EARNING' THEN
759: get_offer_earn_req(l_claim_id, l_offer_req);
760: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');

Line 757: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);

753:
754: IF l_approval_type = 'PERFORMANCE' THEN
755: get_offer_perf_req(l_claim_id, l_offer_req);
756: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_INFO');
757: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
758: ELSIF l_approval_type = 'EARNING' THEN
759: get_offer_earn_req(l_claim_id, l_offer_req);
760: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');
761: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

Line 760: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');

756: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_INFO');
757: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
758: ELSIF l_approval_type = 'EARNING' THEN
759: get_offer_earn_req(l_claim_id, l_offer_req);
760: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');
761: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
762: ELSE
763: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
764: END IF;

Line 761: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

757: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
758: ELSIF l_approval_type = 'EARNING' THEN
759: get_offer_earn_req(l_claim_id, l_offer_req);
760: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');
761: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
762: ELSE
763: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
764: END IF;
765: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 763: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');

759: get_offer_earn_req(l_claim_id, l_offer_req);
760: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');
761: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
762: ELSE
763: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
764: END IF;
765: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
766: fnd_message.set_token('AMOUNT', l_requested_amt, false);
767: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 765: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

761: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
762: ELSE
763: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
764: END IF;
765: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
766: fnd_message.set_token('AMOUNT', l_requested_amt, false);
767: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
768: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

Line 766: fnd_message.set_token('AMOUNT', l_requested_amt, false);

762: ELSE
763: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
764: END IF;
765: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
766: fnd_message.set_token('AMOUNT', l_requested_amt, false);
767: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
768: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
770: fnd_message.set_token('DUE_DATE', l_due_date, false);

Line 767: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

763: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
764: END IF;
765: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
766: fnd_message.set_token('AMOUNT', l_requested_amt, false);
767: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
768: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
770: fnd_message.set_token('DUE_DATE', l_due_date, false);
771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

Line 768: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);

764: END IF;
765: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
766: fnd_message.set_token('AMOUNT', l_requested_amt, false);
767: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
768: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
770: fnd_message.set_token('DUE_DATE', l_due_date, false);
771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

Line 769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

765: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
766: fnd_message.set_token('AMOUNT', l_requested_amt, false);
767: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
768: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
770: fnd_message.set_token('DUE_DATE', l_due_date, false);
771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
773: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

Line 770: fnd_message.set_token('DUE_DATE', l_due_date, false);

766: fnd_message.set_token('AMOUNT', l_requested_amt, false);
767: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
768: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
770: fnd_message.set_token('DUE_DATE', l_due_date, false);
771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
773: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
774: fnd_message.set_token('CM_REASON', l_cm_reason, false);

Line 771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

767: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
768: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
770: fnd_message.set_token('DUE_DATE', l_due_date, false);
771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
773: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
774: fnd_message.set_token('CM_REASON', l_cm_reason, false);
775: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

Line 772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

768: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
770: fnd_message.set_token('DUE_DATE', l_due_date, false);
771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
773: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
774: fnd_message.set_token('CM_REASON', l_cm_reason, false);
775: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
776: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

Line 773: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

769: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
770: fnd_message.set_token('DUE_DATE', l_due_date, false);
771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
773: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
774: fnd_message.set_token('CM_REASON', l_cm_reason, false);
775: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
776: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
777:

Line 774: fnd_message.set_token('CM_REASON', l_cm_reason, false);

770: fnd_message.set_token('DUE_DATE', l_due_date, false);
771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
773: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
774: fnd_message.set_token('CM_REASON', l_cm_reason, false);
775: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
776: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
777:
778: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments

Line 775: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

771: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
773: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
774: fnd_message.set_token('CM_REASON', l_cm_reason, false);
775: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
776: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
777:
778: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments
779:

Line 776: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

772: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
773: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
774: fnd_message.set_token('CM_REASON', l_cm_reason, false);
775: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
776: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
777:
778: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments
779:
780: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);

Line 780: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);

776: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
777:
778: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments
779:
780: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
781: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
782:
783: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
784: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);

Line 781: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);

777:
778: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments
779:
780: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
781: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
782:
783: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
784: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
785: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

Line 783: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);

779:
780: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
781: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
782:
783: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
784: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
785: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
786:
787: l_body := fnd_message.get;

Line 784: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);

780: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
781: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
782:
783: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
784: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
785: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
786:
787: l_body := fnd_message.get;
788:

Line 785: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

781: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
782:
783: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
784: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
785: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
786:
787: l_body := fnd_message.get;
788:
789: /*

Line 787: l_body := fnd_message.get;

783: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
784: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
785: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
786:
787: l_body := fnd_message.get;
788:
789: /*
790: -- l_note := wf_engine.getitemattrtext(
791: -- itemtype => l_item_type

Line 996: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_SUBJ');

992: , l_claim_source;
993: CLOSE c_claim_rec;
994:
995: IF l_approval_type = 'PERFORMANCE' THEN
996: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_SUBJ');
997: ELSIF l_approval_type = 'EARNING' THEN
998: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
999: ELSE
1000: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');

Line 998: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');

994:
995: IF l_approval_type = 'PERFORMANCE' THEN
996: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_SUBJ');
997: ELSIF l_approval_type = 'EARNING' THEN
998: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
999: ELSE
1000: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1001: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1002: fnd_message.set_token('AMOUNT', l_requested_amt, false);

Line 1000: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');

996: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_SUBJ');
997: ELSIF l_approval_type = 'EARNING' THEN
998: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
999: ELSE
1000: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1001: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1002: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1003: END IF;
1004: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1001: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

997: ELSIF l_approval_type = 'EARNING' THEN
998: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
999: ELSE
1000: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1001: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1002: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1003: END IF;
1004: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1005: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1002: fnd_message.set_token('AMOUNT', l_requested_amt, false);

998: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
999: ELSE
1000: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1001: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1002: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1003: END IF;
1004: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1005: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1006: l_subject := fnd_message.get;

Line 1004: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

1000: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1001: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1002: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1003: END IF;
1004: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1005: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1006: l_subject := fnd_message.get;
1007:
1008: wf_engine.setitemattrtext(

Line 1005: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

1001: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1002: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1003: END IF;
1004: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1005: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1006: l_subject := fnd_message.get;
1007:
1008: wf_engine.setitemattrtext(
1009: itemtype => l_item_type

Line 1006: l_subject := fnd_message.get;

1002: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1003: END IF;
1004: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1005: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1006: l_subject := fnd_message.get;
1007:
1008: wf_engine.setitemattrtext(
1009: itemtype => l_item_type
1010: ,itemkey => l_item_key

Line 1023: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_INFO');

1019: );
1020:
1021: IF l_approval_type = 'PERFORMANCE' THEN
1022: get_offer_perf_req(l_claim_id, l_offer_req);
1023: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_INFO');
1024: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1025: ELSIF l_approval_type = 'EARNING' THEN
1026: get_offer_earn_req(l_claim_id, l_offer_req);
1027: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');

Line 1024: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);

1020:
1021: IF l_approval_type = 'PERFORMANCE' THEN
1022: get_offer_perf_req(l_claim_id, l_offer_req);
1023: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_INFO');
1024: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1025: ELSIF l_approval_type = 'EARNING' THEN
1026: get_offer_earn_req(l_claim_id, l_offer_req);
1027: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');
1028: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

Line 1027: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');

1023: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_INFO');
1024: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1025: ELSIF l_approval_type = 'EARNING' THEN
1026: get_offer_earn_req(l_claim_id, l_offer_req);
1027: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');
1028: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1029: ELSE
1030: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1031: END IF;

Line 1028: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

1024: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1025: ELSIF l_approval_type = 'EARNING' THEN
1026: get_offer_earn_req(l_claim_id, l_offer_req);
1027: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');
1028: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1029: ELSE
1030: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1031: END IF;
1032: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1030: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');

1026: get_offer_earn_req(l_claim_id, l_offer_req);
1027: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');
1028: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1029: ELSE
1030: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1031: END IF;
1032: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1033: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1034: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

Line 1032: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

1028: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1029: ELSE
1030: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1031: END IF;
1032: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1033: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1034: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1035: fnd_message.set_token('DUE_DATE', l_due_date, false);
1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

Line 1033: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);

1029: ELSE
1030: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1031: END IF;
1032: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1033: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1034: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1035: fnd_message.set_token('DUE_DATE', l_due_date, false);
1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

Line 1034: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

1030: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1031: END IF;
1032: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1033: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1034: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1035: fnd_message.set_token('DUE_DATE', l_due_date, false);
1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

Line 1035: fnd_message.set_token('DUE_DATE', l_due_date, false);

1031: END IF;
1032: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1033: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1034: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1035: fnd_message.set_token('DUE_DATE', l_due_date, false);
1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);

Line 1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

1032: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1033: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1034: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1035: fnd_message.set_token('DUE_DATE', l_due_date, false);
1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

Line 1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

1033: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1034: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1035: fnd_message.set_token('DUE_DATE', l_due_date, false);
1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

1034: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1035: fnd_message.set_token('DUE_DATE', l_due_date, false);
1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);

Line 1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);

1035: fnd_message.set_token('DUE_DATE', l_due_date, false);
1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1043: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

Line 1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

1036: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1043: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1044: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);

Line 1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

1037: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1043: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1044: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1045: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

Line 1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);

1038: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1043: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1044: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1045: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1046: l_body := fnd_message.get;

Line 1043: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

1039: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1043: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1044: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1045: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1046: l_body := fnd_message.get;
1047: /*

Line 1044: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);

1040: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1043: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1044: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1045: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1046: l_body := fnd_message.get;
1047: /*
1048: l_note := wf_engine.getitemattrtext(

Line 1045: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

1041: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1043: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1044: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1045: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1046: l_body := fnd_message.get;
1047: /*
1048: l_note := wf_engine.getitemattrtext(
1049: itemtype => l_item_type

Line 1046: l_body := fnd_message.get;

1042: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1043: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1044: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1045: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1046: l_body := fnd_message.get;
1047: /*
1048: l_note := wf_engine.getitemattrtext(
1049: itemtype => l_item_type
1050: ,itemkey => l_item_key

Line 1255: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');

1251: , l_claim_source;
1252: CLOSE c_claim_rec;
1253:
1254: IF l_approval_type = 'PERFORMANCE' THEN
1255: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1256: ELSIF l_approval_type = 'EARNING' THEN
1257: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1258: ELSE
1259: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');

Line 1257: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');

1253:
1254: IF l_approval_type = 'PERFORMANCE' THEN
1255: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1256: ELSIF l_approval_type = 'EARNING' THEN
1257: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1258: ELSE
1259: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1260: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1261: fnd_message.set_token('AMOUNT', l_approved_amt, false);

Line 1259: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');

1255: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1256: ELSIF l_approval_type = 'EARNING' THEN
1257: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1258: ELSE
1259: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1260: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1261: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1262: END IF;
1263: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1260: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

1256: ELSIF l_approval_type = 'EARNING' THEN
1257: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1258: ELSE
1259: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1260: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1261: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1262: END IF;
1263: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1264: --fnd_message.set_token('APPROVER', l_approver, false);

Line 1261: fnd_message.set_token('AMOUNT', l_approved_amt, false);

1257: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1258: ELSE
1259: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1260: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1261: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1262: END IF;
1263: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1264: --fnd_message.set_token('APPROVER', l_approver, false);
1265: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1263: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

1259: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1260: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1261: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1262: END IF;
1263: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1264: --fnd_message.set_token('APPROVER', l_approver, false);
1265: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1266: l_subject := fnd_message.get;
1267:

Line 1264: --fnd_message.set_token('APPROVER', l_approver, false);

1260: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1261: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1262: END IF;
1263: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1264: --fnd_message.set_token('APPROVER', l_approver, false);
1265: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1266: l_subject := fnd_message.get;
1267:
1268: wf_engine.setitemattrtext(

Line 1265: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

1261: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1262: END IF;
1263: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1264: --fnd_message.set_token('APPROVER', l_approver, false);
1265: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1266: l_subject := fnd_message.get;
1267:
1268: wf_engine.setitemattrtext(
1269: itemtype => l_item_type

Line 1266: l_subject := fnd_message.get;

1262: END IF;
1263: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1264: --fnd_message.set_token('APPROVER', l_approver, false);
1265: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1266: l_subject := fnd_message.get;
1267:
1268: wf_engine.setitemattrtext(
1269: itemtype => l_item_type
1270: ,itemkey => l_item_key

Line 1277: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_INFO');

1273: );
1274:
1275: IF l_approval_type = 'PERFORMANCE' THEN
1276: get_offer_perf_req(l_claim_id, l_offer_req);
1277: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_INFO');
1278: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1279: ELSIF l_approval_type = 'EARNING' THEN
1280: get_offer_earn_req(l_claim_id, l_offer_req);
1281: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');

Line 1278: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);

1274:
1275: IF l_approval_type = 'PERFORMANCE' THEN
1276: get_offer_perf_req(l_claim_id, l_offer_req);
1277: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_INFO');
1278: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1279: ELSIF l_approval_type = 'EARNING' THEN
1280: get_offer_earn_req(l_claim_id, l_offer_req);
1281: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');
1282: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

Line 1281: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');

1277: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_INFO');
1278: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1279: ELSIF l_approval_type = 'EARNING' THEN
1280: get_offer_earn_req(l_claim_id, l_offer_req);
1281: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');
1282: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1283: ELSE
1284: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1285: END IF;

Line 1282: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

1278: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1279: ELSIF l_approval_type = 'EARNING' THEN
1280: get_offer_earn_req(l_claim_id, l_offer_req);
1281: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');
1282: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1283: ELSE
1284: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1285: END IF;
1286: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 1284: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');

1280: get_offer_earn_req(l_claim_id, l_offer_req);
1281: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');
1282: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1283: ELSE
1284: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1285: END IF;
1286: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1287: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1288: fnd_message.set_token('APPROVER_NAME', l_approver, false);

Line 1286: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

1282: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1283: ELSE
1284: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1285: END IF;
1286: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1287: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1288: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1289: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);

Line 1287: fnd_message.set_token('AMOUNT', l_approved_amt, false);

1283: ELSE
1284: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1285: END IF;
1286: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1287: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1288: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1289: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1288: fnd_message.set_token('APPROVER_NAME', l_approver, false);

1284: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1285: END IF;
1286: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1287: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1288: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1289: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);

Line 1289: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);

1285: END IF;
1286: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1287: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1288: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1289: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

Line 1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);

1286: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1287: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1288: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1289: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1294: fnd_message.set_token('DUE_DATE', l_due_date, false);

Line 1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

1287: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1288: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1289: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1294: fnd_message.set_token('DUE_DATE', l_due_date, false);
1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

Line 1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);

1288: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1289: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1294: fnd_message.set_token('DUE_DATE', l_due_date, false);
1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

Line 1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

1289: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1294: fnd_message.set_token('DUE_DATE', l_due_date, false);
1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

Line 1294: fnd_message.set_token('DUE_DATE', l_due_date, false);

1290: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1294: fnd_message.set_token('DUE_DATE', l_due_date, false);
1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);

Line 1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

1291: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1294: fnd_message.set_token('DUE_DATE', l_due_date, false);
1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

Line 1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

1292: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1294: fnd_message.set_token('DUE_DATE', l_due_date, false);
1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1300: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

Line 1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

1293: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1294: fnd_message.set_token('DUE_DATE', l_due_date, false);
1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1300: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1301: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

Line 1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);

1294: fnd_message.set_token('DUE_DATE', l_due_date, false);
1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1300: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1301: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1302: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

Line 1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

1295: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1300: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1301: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1302: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1303: l_body := fnd_message.get;

Line 1300: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

1296: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1300: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1301: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1302: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1303: l_body := fnd_message.get;
1304: /*

Line 1301: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

1297: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1300: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1301: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1302: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1303: l_body := fnd_message.get;
1304: /*
1305: l_note := wf_engine.getitemattrtext(

Line 1302: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

1298: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1300: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1301: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1302: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1303: l_body := fnd_message.get;
1304: /*
1305: l_note := wf_engine.getitemattrtext(
1306: itemtype => l_item_type

Line 1303: l_body := fnd_message.get;

1299: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1300: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1301: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1302: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1303: l_body := fnd_message.get;
1304: /*
1305: l_note := wf_engine.getitemattrtext(
1306: itemtype => l_item_type
1307: ,itemkey => l_item_key

Line 1510: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');

1506: , l_claim_source;
1507: CLOSE c_claim_rec;
1508:
1509: IF l_approval_type = 'PERFORMANCE' THEN
1510: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1511: ELSIF l_approval_type = 'EARNING' THEN
1512: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1513: ELSE
1514: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');

Line 1512: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');

1508:
1509: IF l_approval_type = 'PERFORMANCE' THEN
1510: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1511: ELSIF l_approval_type = 'EARNING' THEN
1512: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1513: ELSE
1514: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1515: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1516: fnd_message.set_token('AMOUNT', l_amount_settled, false);

Line 1514: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');

1510: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1511: ELSIF l_approval_type = 'EARNING' THEN
1512: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1513: ELSE
1514: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1515: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1516: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1517: END IF;
1518: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1515: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

1511: ELSIF l_approval_type = 'EARNING' THEN
1512: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1513: ELSE
1514: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1515: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1516: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1517: END IF;
1518: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1519: --fnd_message.set_token('APPROVER', l_approver, false);

Line 1516: fnd_message.set_token('AMOUNT', l_amount_settled, false);

1512: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1513: ELSE
1514: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1515: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1516: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1517: END IF;
1518: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1519: --fnd_message.set_token('APPROVER', l_approver, false);
1520: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1518: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

1514: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1515: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1516: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1517: END IF;
1518: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1519: --fnd_message.set_token('APPROVER', l_approver, false);
1520: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1521: l_subject := fnd_message.get;
1522:

Line 1519: --fnd_message.set_token('APPROVER', l_approver, false);

1515: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1516: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1517: END IF;
1518: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1519: --fnd_message.set_token('APPROVER', l_approver, false);
1520: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1521: l_subject := fnd_message.get;
1522:
1523: wf_engine.setitemattrtext(

Line 1520: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

1516: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1517: END IF;
1518: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1519: --fnd_message.set_token('APPROVER', l_approver, false);
1520: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1521: l_subject := fnd_message.get;
1522:
1523: wf_engine.setitemattrtext(
1524: itemtype => l_item_type

Line 1521: l_subject := fnd_message.get;

1517: END IF;
1518: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1519: --fnd_message.set_token('APPROVER', l_approver, false);
1520: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1521: l_subject := fnd_message.get;
1522:
1523: wf_engine.setitemattrtext(
1524: itemtype => l_item_type
1525: ,itemkey => l_item_key

Line 1532: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_INFO');

1528: );
1529:
1530: IF l_approval_type = 'PERFORMANCE' THEN
1531: get_offer_perf_req(l_claim_id, l_offer_req);
1532: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_INFO');
1533: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1534: ELSIF l_approval_type = 'EARNING' THEN
1535: get_offer_earn_req(l_claim_id, l_offer_req);
1536: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');

Line 1533: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);

1529:
1530: IF l_approval_type = 'PERFORMANCE' THEN
1531: get_offer_perf_req(l_claim_id, l_offer_req);
1532: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_INFO');
1533: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1534: ELSIF l_approval_type = 'EARNING' THEN
1535: get_offer_earn_req(l_claim_id, l_offer_req);
1536: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');
1537: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

Line 1536: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');

1532: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_INFO');
1533: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1534: ELSIF l_approval_type = 'EARNING' THEN
1535: get_offer_earn_req(l_claim_id, l_offer_req);
1536: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');
1537: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1538: ELSE
1539: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1540: END IF;

Line 1537: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);

1533: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1534: ELSIF l_approval_type = 'EARNING' THEN
1535: get_offer_earn_req(l_claim_id, l_offer_req);
1536: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');
1537: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1538: ELSE
1539: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1540: END IF;
1541: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 1539: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');

1535: get_offer_earn_req(l_claim_id, l_offer_req);
1536: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');
1537: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1538: ELSE
1539: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1540: END IF;
1541: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1542: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1543: fnd_message.set_token('APPROVER_NAME', l_approver, false);

Line 1541: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

1537: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1538: ELSE
1539: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1540: END IF;
1541: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1542: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1543: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1544: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);

Line 1542: fnd_message.set_token('AMOUNT', l_amount_settled, false);

1538: ELSE
1539: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1540: END IF;
1541: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1542: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1543: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1544: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1543: fnd_message.set_token('APPROVER_NAME', l_approver, false);

1539: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1540: END IF;
1541: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1542: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1543: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1544: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);

Line 1544: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);

1540: END IF;
1541: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1542: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1543: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1544: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

Line 1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);

1541: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1542: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1543: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1544: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1549: fnd_message.set_token('DUE_DATE', l_due_date, false);

Line 1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);

1542: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1543: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1544: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1549: fnd_message.set_token('DUE_DATE', l_due_date, false);
1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

Line 1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);

1543: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1544: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1549: fnd_message.set_token('DUE_DATE', l_due_date, false);
1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

Line 1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);

1544: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1549: fnd_message.set_token('DUE_DATE', l_due_date, false);
1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

Line 1549: fnd_message.set_token('DUE_DATE', l_due_date, false);

1545: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1549: fnd_message.set_token('DUE_DATE', l_due_date, false);
1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);

Line 1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);

1546: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1549: fnd_message.set_token('DUE_DATE', l_due_date, false);
1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

Line 1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);

1547: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1549: fnd_message.set_token('DUE_DATE', l_due_date, false);
1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

Line 1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);

1548: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1549: fnd_message.set_token('DUE_DATE', l_due_date, false);
1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1556: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);

Line 1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);

1549: fnd_message.set_token('DUE_DATE', l_due_date, false);
1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1556: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1557: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

Line 1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);

1550: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1556: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1557: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1558: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

Line 1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);

1551: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1556: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1557: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1558: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1559: l_body := fnd_message.get;

Line 1556: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);

1552: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1556: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1557: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1558: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1559: l_body := fnd_message.get;
1560: /*

Line 1557: fnd_message.set_token('COMMENTS_NOTES', l_note, false);

1553: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1556: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1557: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1558: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1559: l_body := fnd_message.get;
1560: /*
1561: l_note := wf_engine.getitemattrtext(

Line 1558: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

1554: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1556: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1557: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1558: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1559: l_body := fnd_message.get;
1560: /*
1561: l_note := wf_engine.getitemattrtext(
1562: itemtype => l_item_type

Line 1559: l_body := fnd_message.get;

1555: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1556: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1557: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1558: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1559: l_body := fnd_message.get;
1560: /*
1561: l_note := wf_engine.getitemattrtext(
1562: itemtype => l_item_type
1563: ,itemkey => l_item_key

Line 1785: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');

1781:
1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1785: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
1786: FND_MSG_PUB.add;
1787: END IF;
1788: IF OZF_DEBUG_LOW_ON THEN
1789: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 1789: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

1785: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
1786: FND_MSG_PUB.add;
1787: END IF;
1788: IF OZF_DEBUG_LOW_ON THEN
1789: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1790: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1791: FND_MSG_PUB.Add;
1792: END IF;
1793: RAISE FND_API.g_exc_unexpected_error;

Line 1790: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

1786: FND_MSG_PUB.add;
1787: END IF;
1788: IF OZF_DEBUG_LOW_ON THEN
1789: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1790: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1791: FND_MSG_PUB.Add;
1792: END IF;
1793: RAISE FND_API.g_exc_unexpected_error;
1794: END;

Line 1870: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');

1866: ,avalue => l_comments
1867: );
1868:
1869: IF l_approval_type = 'PERFORMANCE' THEN
1870: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
1871: ELSIF l_approval_type = 'EARNING' THEN
1872: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1873: ELSE
1874: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');

Line 1872: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');

1868:
1869: IF l_approval_type = 'PERFORMANCE' THEN
1870: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
1871: ELSIF l_approval_type = 'EARNING' THEN
1872: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1873: ELSE
1874: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
1875: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1876: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);

Line 1874: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');

1870: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
1871: ELSIF l_approval_type = 'EARNING' THEN
1872: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1873: ELSE
1874: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
1875: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1876: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1877: END IF;
1878: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1875: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);

1871: ELSIF l_approval_type = 'EARNING' THEN
1872: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1873: ELSE
1874: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
1875: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1876: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1877: END IF;
1878: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1879: --fnd_message.set_token('APPROVER', l_approver, false);

Line 1876: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);

1872: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1873: ELSE
1874: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
1875: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1876: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1877: END IF;
1878: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1879: --fnd_message.set_token('APPROVER', l_approver, false);
1880: l_subject := FND_MESSAGE.get;

Line 1878: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);

1874: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
1875: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1876: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1877: END IF;
1878: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1879: --fnd_message.set_token('APPROVER', l_approver, false);
1880: l_subject := FND_MESSAGE.get;
1881:
1882: WF_ENGINE.setitemattrtext(

Line 1879: --fnd_message.set_token('APPROVER', l_approver, false);

1875: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1876: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1877: END IF;
1878: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1879: --fnd_message.set_token('APPROVER', l_approver, false);
1880: l_subject := FND_MESSAGE.get;
1881:
1882: WF_ENGINE.setitemattrtext(
1883: itemtype => itemtype

Line 1880: l_subject := FND_MESSAGE.get;

1876: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1877: END IF;
1878: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1879: --fnd_message.set_token('APPROVER', l_approver, false);
1880: l_subject := FND_MESSAGE.get;
1881:
1882: WF_ENGINE.setitemattrtext(
1883: itemtype => itemtype
1884: ,itemkey => itemkey

Line 1890: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');

1886: ,avalue => l_subject
1887: );
1888:
1889: IF l_approval_type = 'PERFORMANCE' THEN
1890: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
1891: ELSIF l_approval_type = 'EARNING' THEN
1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');

Line 1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');

1888:
1889: IF l_approval_type = 'PERFORMANCE' THEN
1890: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
1891: ELSIF l_approval_type = 'EARNING' THEN
1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
1895: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1896: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);

Line 1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');

1890: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
1891: ELSIF l_approval_type = 'EARNING' THEN
1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
1895: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1896: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1897: END IF;
1898: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1895: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);

1891: ELSIF l_approval_type = 'EARNING' THEN
1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
1895: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1896: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1897: END IF;
1898: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1896: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);

1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
1895: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1896: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1897: END IF;
1898: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_subject := fnd_message.get;

Line 1898: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);

1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
1895: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1896: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1897: END IF;
1898: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_subject := fnd_message.get;
1901:
1902: WF_ENGINE.setitemattrtext(

Line 1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

1895: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1896: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1897: END IF;
1898: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_subject := fnd_message.get;
1901:
1902: WF_ENGINE.setitemattrtext(
1903: itemtype => itemtype

Line 1900: l_subject := fnd_message.get;

1896: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1897: END IF;
1898: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1899: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1900: l_subject := fnd_message.get;
1901:
1902: WF_ENGINE.setitemattrtext(
1903: itemtype => itemtype
1904: ,itemkey => itemkey

Line 1910: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');

1906: ,avalue => l_subject
1907: );
1908:
1909: IF l_approval_type = 'PERFORMANCE' THEN
1910: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1911: ELSIF l_approval_type = 'EARNING' THEN
1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');

Line 1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');

1908:
1909: IF l_approval_type = 'PERFORMANCE' THEN
1910: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1911: ELSIF l_approval_type = 'EARNING' THEN
1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1915: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1916: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);

Line 1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');

1910: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1911: ELSIF l_approval_type = 'EARNING' THEN
1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1915: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1916: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1917: END IF;
1918: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1915: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);

1911: ELSIF l_approval_type = 'EARNING' THEN
1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1915: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1916: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1917: END IF;
1918: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1919: --fnd_message.set_token('APPROVER', l_approver, false);

Line 1916: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);

1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1915: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1916: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1917: END IF;
1918: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1919: --fnd_message.set_token('APPROVER', l_approver, false);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1918: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);

1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1915: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1916: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1917: END IF;
1918: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1919: --fnd_message.set_token('APPROVER', l_approver, false);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_subject := FND_MESSAGE.get;
1922:

Line 1919: --fnd_message.set_token('APPROVER', l_approver, false);

1915: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1916: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1917: END IF;
1918: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1919: --fnd_message.set_token('APPROVER', l_approver, false);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_subject := FND_MESSAGE.get;
1922:
1923: WF_ENGINE.setitemattrtext(

Line 1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

1916: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1917: END IF;
1918: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1919: --fnd_message.set_token('APPROVER', l_approver, false);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_subject := FND_MESSAGE.get;
1922:
1923: WF_ENGINE.setitemattrtext(
1924: itemtype => itemtype

Line 1921: l_subject := FND_MESSAGE.get;

1917: END IF;
1918: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1919: --fnd_message.set_token('APPROVER', l_approver, false);
1920: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1921: l_subject := FND_MESSAGE.get;
1922:
1923: WF_ENGINE.setitemattrtext(
1924: itemtype => itemtype
1925: ,itemkey => itemkey

Line 1931: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');

1927: ,avalue => l_subject
1928: );
1929:
1930: IF l_approval_type = 'PERFORMANCE' THEN
1931: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1932: ELSIF l_approval_type = 'EARNING' THEN
1933: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1934: ELSE
1935: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');

Line 1933: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');

1929:
1930: IF l_approval_type = 'PERFORMANCE' THEN
1931: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1932: ELSIF l_approval_type = 'EARNING' THEN
1933: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1934: ELSE
1935: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1936: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1937: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);

Line 1935: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');

1931: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1932: ELSIF l_approval_type = 'EARNING' THEN
1933: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1934: ELSE
1935: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1936: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1937: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1938: END IF;
1939: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);

Line 1936: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);

1932: ELSIF l_approval_type = 'EARNING' THEN
1933: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1934: ELSE
1935: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1936: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1937: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1938: END IF;
1939: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1940: --fnd_message.set_token('APPROVER', l_approver, false);

Line 1937: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);

1933: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1934: ELSE
1935: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1936: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1937: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1938: END IF;
1939: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1940: --fnd_message.set_token('APPROVER', l_approver, false);
1941: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1939: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);

1935: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1936: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1937: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1938: END IF;
1939: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1940: --fnd_message.set_token('APPROVER', l_approver, false);
1941: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1942: l_subject := FND_MESSAGE.get;
1943:

Line 1940: --fnd_message.set_token('APPROVER', l_approver, false);

1936: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1937: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1938: END IF;
1939: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1940: --fnd_message.set_token('APPROVER', l_approver, false);
1941: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1942: l_subject := FND_MESSAGE.get;
1943:
1944: WF_ENGINE.setitemattrtext(

Line 1941: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

1937: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1938: END IF;
1939: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1940: --fnd_message.set_token('APPROVER', l_approver, false);
1941: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1942: l_subject := FND_MESSAGE.get;
1943:
1944: WF_ENGINE.setitemattrtext(
1945: itemtype => itemtype

Line 1942: l_subject := FND_MESSAGE.get;

1938: END IF;
1939: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1940: --fnd_message.set_token('APPROVER', l_approver, false);
1941: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1942: l_subject := FND_MESSAGE.get;
1943:
1944: WF_ENGINE.setitemattrtext(
1945: itemtype => itemtype
1946: ,itemkey => itemkey

Line 2014: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2010: resultout := 'COMPLETE:ERROR';
2011: RETURN;
2012: --RAISE;
2013: WHEN OTHERS THEN
2014: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2015: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2016: FND_MSG_PUB.Add;
2017:
2018: FND_MSG_PUB.count_and_get (

Line 2015: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

2011: RETURN;
2012: --RAISE;
2013: WHEN OTHERS THEN
2014: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2015: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2016: FND_MSG_PUB.Add;
2017:
2018: FND_MSG_PUB.count_and_get (
2019: p_encoded => fnd_api.g_false

Line 2107: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');

2103: WHERE claim_id = p_claim_id;
2104: EXCEPTION
2105: WHEN OTHERS THEN
2106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2107: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
2108: FND_MSG_PUB.add;
2109: END IF;
2110: IF OZF_DEBUG_LOW_ON THEN
2111: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 2111: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2107: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
2108: FND_MSG_PUB.add;
2109: END IF;
2110: IF OZF_DEBUG_LOW_ON THEN
2111: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2112: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2113: FND_MSG_PUB.Add;
2114: END IF;
2115: RAISE FND_API.g_exc_unexpected_error;

Line 2112: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

2108: FND_MSG_PUB.add;
2109: END IF;
2110: IF OZF_DEBUG_LOW_ON THEN
2111: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2112: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2113: FND_MSG_PUB.Add;
2114: END IF;
2115: RAISE FND_API.g_exc_unexpected_error;
2116: END;

Line 2138: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2134: );
2135:
2136: EXCEPTION
2137: WHEN OTHERS THEN
2138: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2139: FND_MESSAGE.Set_Token('TEXT',l_full_name||' - '||p_approval_type||' : Error');
2140: FND_MSG_PUB.Add;
2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2142:

Line 2139: FND_MESSAGE.Set_Token('TEXT',l_full_name||' - '||p_approval_type||' : Error');

2135:
2136: EXCEPTION
2137: WHEN OTHERS THEN
2138: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2139: FND_MESSAGE.Set_Token('TEXT',l_full_name||' - '||p_approval_type||' : Error');
2140: FND_MSG_PUB.Add;
2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2142:
2143: END Start_Approval_Process;

Line 2442: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');

2438: IF l_approved_amount <> l_claim_amount_settled AND
2439: l_payment_method <> 'MASS_SETTLEMENT' THEN
2440: IF l_update_status IN ('APPROVED', 'REJECTED') THEN
2441: --set message.
2442: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2443: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2444: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2445: FND_MSG_PUB.ADD;
2446: FND_MSG_PUB.count_and_get (

Line 2443: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);

2439: l_payment_method <> 'MASS_SETTLEMENT' THEN
2440: IF l_update_status IN ('APPROVED', 'REJECTED') THEN
2441: --set message.
2442: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2443: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2444: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2445: FND_MSG_PUB.ADD;
2446: FND_MSG_PUB.count_and_get (
2447: p_encoded => fnd_api.g_false

Line 2444: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);

2440: IF l_update_status IN ('APPROVED', 'REJECTED') THEN
2441: --set message.
2442: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2443: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2444: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2445: FND_MSG_PUB.ADD;
2446: FND_MSG_PUB.count_and_get (
2447: p_encoded => fnd_api.g_false
2448: ,p_count => l_msg_count

Line 2633: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

2629: );
2630: RAISE;
2631:
2632: WHEN OTHERS THEN
2633: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2634: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2635: FND_MSG_PUB.Add;
2636:
2637: fnd_msg_pub.count_and_get(

Line 2634: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

2630: RAISE;
2631:
2632: WHEN OTHERS THEN
2633: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2634: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2635: FND_MSG_PUB.Add;
2636:
2637: fnd_msg_pub.count_and_get(
2638: p_encoded => fnd_api.g_false