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;
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;
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:
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;
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;
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;
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;
448: , l_claim_source;
449: CLOSE c_claim_rec;
450:
451: IF l_approval_type = 'PERFORMANCE' THEN
452: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
453: ELSIF l_approval_type = 'EARNING' THEN
454: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
455: ELSE
456: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
450:
451: IF l_approval_type = 'PERFORMANCE' THEN
452: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
453: ELSIF l_approval_type = 'EARNING' THEN
454: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
455: ELSE
456: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
457: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
458: fnd_message.set_token('AMOUNT', l_requested_amt, false);
452: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
453: ELSIF l_approval_type = 'EARNING' THEN
454: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
455: ELSE
456: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
457: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
458: fnd_message.set_token('AMOUNT', l_requested_amt, false);
459: END IF;
460: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
453: ELSIF l_approval_type = 'EARNING' THEN
454: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
455: ELSE
456: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
457: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
458: fnd_message.set_token('AMOUNT', l_requested_amt, false);
459: END IF;
460: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
461: --fnd_message.set_token('APPROVER', l_approver, false);
454: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
455: ELSE
456: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
457: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
458: fnd_message.set_token('AMOUNT', l_requested_amt, false);
459: END IF;
460: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
461: --fnd_message.set_token('APPROVER', l_approver, false);
462: l_subject := fnd_message.get;
456: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
457: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
458: fnd_message.set_token('AMOUNT', l_requested_amt, false);
459: END IF;
460: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
461: --fnd_message.set_token('APPROVER', l_approver, false);
462: l_subject := fnd_message.get;
463:
464: wf_engine.setitemattrtext(
457: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
458: fnd_message.set_token('AMOUNT', l_requested_amt, false);
459: END IF;
460: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
461: --fnd_message.set_token('APPROVER', l_approver, false);
462: l_subject := fnd_message.get;
463:
464: wf_engine.setitemattrtext(
465: itemtype => l_item_type
458: fnd_message.set_token('AMOUNT', l_requested_amt, false);
459: END IF;
460: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
461: --fnd_message.set_token('APPROVER', l_approver, false);
462: l_subject := fnd_message.get;
463:
464: wf_engine.setitemattrtext(
465: itemtype => l_item_type
466: ,itemkey => l_item_key
469: );
470:
471: IF l_approval_type = 'PERFORMANCE' THEN
472: get_offer_perf_req(l_claim_id, l_offer_req);
473: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_INFO');
474: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
475: ELSIF l_approval_type = 'EARNING' THEN
476: get_offer_earn_req(l_claim_id, l_offer_req);
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
470:
471: IF l_approval_type = 'PERFORMANCE' THEN
472: get_offer_perf_req(l_claim_id, l_offer_req);
473: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_INFO');
474: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
475: ELSIF l_approval_type = 'EARNING' THEN
476: get_offer_earn_req(l_claim_id, l_offer_req);
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
478: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
473: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_INFO');
474: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
475: ELSIF l_approval_type = 'EARNING' THEN
476: get_offer_earn_req(l_claim_id, l_offer_req);
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
478: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
479: ELSE
480: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
481: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
474: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
475: ELSIF l_approval_type = 'EARNING' THEN
476: get_offer_earn_req(l_claim_id, l_offer_req);
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
478: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
479: ELSE
480: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
481: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
482: END IF;
476: get_offer_earn_req(l_claim_id, l_offer_req);
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
478: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
479: ELSE
480: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
481: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
482: END IF;
483: fnd_message.set_token('APPROVER_NAME', l_approver, false);
484: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
477: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_INFO');
478: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
479: ELSE
480: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
481: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
482: END IF;
483: fnd_message.set_token('APPROVER_NAME', l_approver, false);
484: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
485: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
479: ELSE
480: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
481: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
482: END IF;
483: fnd_message.set_token('APPROVER_NAME', l_approver, false);
484: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
485: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
486: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
487: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
480: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
481: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
482: END IF;
483: fnd_message.set_token('APPROVER_NAME', l_approver, false);
484: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
485: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
486: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
487: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
488: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
481: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_INFO');
482: END IF;
483: fnd_message.set_token('APPROVER_NAME', l_approver, false);
484: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
485: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
486: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
487: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
488: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
489: fnd_message.set_token('DUE_DATE', l_due_date, false);
482: END IF;
483: fnd_message.set_token('APPROVER_NAME', l_approver, false);
484: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
485: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
486: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
487: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
488: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
489: fnd_message.set_token('DUE_DATE', l_due_date, false);
490: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
483: fnd_message.set_token('APPROVER_NAME', l_approver, false);
484: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
485: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
486: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
487: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
488: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
489: fnd_message.set_token('DUE_DATE', l_due_date, false);
490: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
491: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
484: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
485: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
486: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
487: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
488: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
489: fnd_message.set_token('DUE_DATE', l_due_date, false);
490: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
491: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
492: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
485: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
486: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
487: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
488: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
489: fnd_message.set_token('DUE_DATE', l_due_date, false);
490: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
491: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
492: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
493: fnd_message.set_token('CM_REASON', l_cm_reason, false);
486: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
487: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
488: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
489: fnd_message.set_token('DUE_DATE', l_due_date, false);
490: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
491: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
492: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
493: fnd_message.set_token('CM_REASON', l_cm_reason, false);
494: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
487: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
488: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
489: fnd_message.set_token('DUE_DATE', l_due_date, false);
490: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
491: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
492: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
493: fnd_message.set_token('CM_REASON', l_cm_reason, false);
494: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
495: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
488: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
489: fnd_message.set_token('DUE_DATE', l_due_date, false);
490: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
491: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
492: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
493: fnd_message.set_token('CM_REASON', l_cm_reason, false);
494: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
495: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
496: fnd_message.set_token('AMOUNT', l_requested_amt, false);
489: fnd_message.set_token('DUE_DATE', l_due_date, false);
490: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
491: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
492: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
493: fnd_message.set_token('CM_REASON', l_cm_reason, false);
494: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
495: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
496: fnd_message.set_token('AMOUNT', l_requested_amt, false);
497: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
490: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
491: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
492: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
493: fnd_message.set_token('CM_REASON', l_cm_reason, false);
494: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
495: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
496: fnd_message.set_token('AMOUNT', l_requested_amt, false);
497: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
498: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
491: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
492: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
493: fnd_message.set_token('CM_REASON', l_cm_reason, false);
494: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
495: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
496: fnd_message.set_token('AMOUNT', l_requested_amt, false);
497: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
498: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
499: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
492: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
493: fnd_message.set_token('CM_REASON', l_cm_reason, false);
494: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
495: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
496: fnd_message.set_token('AMOUNT', l_requested_amt, false);
497: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
498: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
499: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
500: l_body := fnd_message.get;
493: fnd_message.set_token('CM_REASON', l_cm_reason, false);
494: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
495: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
496: fnd_message.set_token('AMOUNT', l_requested_amt, false);
497: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
498: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
499: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
500: l_body := fnd_message.get;
501: /*
494: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
495: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
496: fnd_message.set_token('AMOUNT', l_requested_amt, false);
497: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
498: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
499: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
500: l_body := fnd_message.get;
501: /*
502: l_note := wf_engine.getitemattrtext(
495: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
496: fnd_message.set_token('AMOUNT', l_requested_amt, false);
497: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
498: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
499: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
500: l_body := fnd_message.get;
501: /*
502: l_note := wf_engine.getitemattrtext(
503: itemtype => l_item_type
496: fnd_message.set_token('AMOUNT', l_requested_amt, false);
497: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
498: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
499: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
500: l_body := fnd_message.get;
501: /*
502: l_note := wf_engine.getitemattrtext(
503: itemtype => l_item_type
504: ,itemkey => l_item_key
742: , l_claim_source;
743: CLOSE c_claim_rec;
744:
745: IF l_approval_type = 'PERFORMANCE' THEN
746: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
747: ELSIF l_approval_type = 'EARNING' THEN
748: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
749: ELSE
750: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
744:
745: IF l_approval_type = 'PERFORMANCE' THEN
746: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
747: ELSIF l_approval_type = 'EARNING' THEN
748: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
749: ELSE
750: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
751: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
752: fnd_message.set_token('AMOUNT', l_requested_amt, false);
746: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
747: ELSIF l_approval_type = 'EARNING' THEN
748: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
749: ELSE
750: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
751: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
752: fnd_message.set_token('AMOUNT', l_requested_amt, false);
753: END IF;
754: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
747: ELSIF l_approval_type = 'EARNING' THEN
748: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
749: ELSE
750: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
751: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
752: fnd_message.set_token('AMOUNT', l_requested_amt, false);
753: END IF;
754: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
755: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
748: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
749: ELSE
750: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
751: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
752: fnd_message.set_token('AMOUNT', l_requested_amt, false);
753: END IF;
754: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
755: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
756: l_subject := fnd_message.get;
750: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
751: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
752: fnd_message.set_token('AMOUNT', l_requested_amt, false);
753: END IF;
754: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
755: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
756: l_subject := fnd_message.get;
757:
758: wf_engine.setitemattrtext(
751: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
752: fnd_message.set_token('AMOUNT', l_requested_amt, false);
753: END IF;
754: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
755: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
756: l_subject := fnd_message.get;
757:
758: wf_engine.setitemattrtext(
759: itemtype => l_item_type
752: fnd_message.set_token('AMOUNT', l_requested_amt, false);
753: END IF;
754: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
755: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
756: l_subject := fnd_message.get;
757:
758: wf_engine.setitemattrtext(
759: itemtype => l_item_type
760: ,itemkey => l_item_key
763: );
764:
765: IF l_approval_type = 'PERFORMANCE' THEN
766: get_offer_perf_req(l_claim_id, l_offer_req);
767: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_INFO');
768: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
769: ELSIF l_approval_type = 'EARNING' THEN
770: get_offer_earn_req(l_claim_id, l_offer_req);
771: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');
764:
765: IF l_approval_type = 'PERFORMANCE' THEN
766: get_offer_perf_req(l_claim_id, l_offer_req);
767: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_INFO');
768: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
769: ELSIF l_approval_type = 'EARNING' THEN
770: get_offer_earn_req(l_claim_id, l_offer_req);
771: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');
772: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
767: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_INFO');
768: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
769: ELSIF l_approval_type = 'EARNING' THEN
770: get_offer_earn_req(l_claim_id, l_offer_req);
771: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');
772: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
773: ELSE
774: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
775: END IF;
768: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
769: ELSIF l_approval_type = 'EARNING' THEN
770: get_offer_earn_req(l_claim_id, l_offer_req);
771: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');
772: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
773: ELSE
774: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
775: END IF;
776: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
770: get_offer_earn_req(l_claim_id, l_offer_req);
771: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_INFO');
772: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
773: ELSE
774: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
775: END IF;
776: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
777: fnd_message.set_token('AMOUNT', l_requested_amt, false);
778: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
772: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
773: ELSE
774: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
775: END IF;
776: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
777: fnd_message.set_token('AMOUNT', l_requested_amt, false);
778: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
779: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
780: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
773: ELSE
774: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
775: END IF;
776: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
777: fnd_message.set_token('AMOUNT', l_requested_amt, false);
778: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
779: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
780: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
781: fnd_message.set_token('DUE_DATE', l_due_date, false);
774: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_INFO');
775: END IF;
776: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
777: fnd_message.set_token('AMOUNT', l_requested_amt, false);
778: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
779: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
780: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
781: fnd_message.set_token('DUE_DATE', l_due_date, false);
782: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
775: END IF;
776: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
777: fnd_message.set_token('AMOUNT', l_requested_amt, false);
778: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
779: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
780: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
781: fnd_message.set_token('DUE_DATE', l_due_date, false);
782: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
783: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
776: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
777: fnd_message.set_token('AMOUNT', l_requested_amt, false);
778: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
779: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
780: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
781: fnd_message.set_token('DUE_DATE', l_due_date, false);
782: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
783: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
784: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
777: fnd_message.set_token('AMOUNT', l_requested_amt, false);
778: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
779: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
780: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
781: fnd_message.set_token('DUE_DATE', l_due_date, false);
782: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
783: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
784: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
785: fnd_message.set_token('CM_REASON', l_cm_reason, false);
778: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
779: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
780: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
781: fnd_message.set_token('DUE_DATE', l_due_date, false);
782: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
783: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
784: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
785: fnd_message.set_token('CM_REASON', l_cm_reason, false);
786: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
779: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
780: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
781: fnd_message.set_token('DUE_DATE', l_due_date, false);
782: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
783: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
784: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
785: fnd_message.set_token('CM_REASON', l_cm_reason, false);
786: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
787: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
780: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
781: fnd_message.set_token('DUE_DATE', l_due_date, false);
782: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
783: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
784: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
785: fnd_message.set_token('CM_REASON', l_cm_reason, false);
786: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
787: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
788:
781: fnd_message.set_token('DUE_DATE', l_due_date, false);
782: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
783: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
784: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
785: fnd_message.set_token('CM_REASON', l_cm_reason, false);
786: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
787: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
788:
789: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments
782: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
783: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
784: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
785: fnd_message.set_token('CM_REASON', l_cm_reason, false);
786: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
787: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
788:
789: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments
790:
783: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
784: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
785: fnd_message.set_token('CM_REASON', l_cm_reason, false);
786: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
787: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
788:
789: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments
790:
791: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
787: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
788:
789: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments
790:
791: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
792: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
793:
794: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
795: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
788:
789: -- Lable for the token JUSTIFICATION_NOTES now reads as Comments
790:
791: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
792: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
793:
794: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
795: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
796: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
790:
791: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
792: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
793:
794: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
795: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
796: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
797:
798: l_body := fnd_message.get;
791: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
792: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
793:
794: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
795: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
796: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
797:
798: l_body := fnd_message.get;
799:
792: fnd_message.set_token('APPROVER_NAME', l_pre_approver, false);
793:
794: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
795: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
796: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
797:
798: l_body := fnd_message.get;
799:
800: /*
794: -- fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
795: -- fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
796: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
797:
798: l_body := fnd_message.get;
799:
800: /*
801: -- l_note := wf_engine.getitemattrtext(
802: -- itemtype => l_item_type
1003: , l_claim_source;
1004: CLOSE c_claim_rec;
1005:
1006: IF l_approval_type = 'PERFORMANCE' THEN
1007: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_SUBJ');
1008: ELSIF l_approval_type = 'EARNING' THEN
1009: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
1010: ELSE
1011: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1005:
1006: IF l_approval_type = 'PERFORMANCE' THEN
1007: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_SUBJ');
1008: ELSIF l_approval_type = 'EARNING' THEN
1009: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
1010: ELSE
1011: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1012: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1013: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1007: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_SUBJ');
1008: ELSIF l_approval_type = 'EARNING' THEN
1009: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
1010: ELSE
1011: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1012: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1013: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1014: END IF;
1015: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1008: ELSIF l_approval_type = 'EARNING' THEN
1009: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
1010: ELSE
1011: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1012: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1013: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1014: END IF;
1015: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1016: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1009: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_SUBJ');
1010: ELSE
1011: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1012: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1013: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1014: END IF;
1015: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1016: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1017: l_subject := fnd_message.get;
1011: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_SUBJ');
1012: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1013: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1014: END IF;
1015: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1016: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1017: l_subject := fnd_message.get;
1018:
1019: wf_engine.setitemattrtext(
1012: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1013: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1014: END IF;
1015: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1016: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1017: l_subject := fnd_message.get;
1018:
1019: wf_engine.setitemattrtext(
1020: itemtype => l_item_type
1013: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1014: END IF;
1015: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1016: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1017: l_subject := fnd_message.get;
1018:
1019: wf_engine.setitemattrtext(
1020: itemtype => l_item_type
1021: ,itemkey => l_item_key
1030: );
1031:
1032: IF l_approval_type = 'PERFORMANCE' THEN
1033: get_offer_perf_req(l_claim_id, l_offer_req);
1034: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_INFO');
1035: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1036: ELSIF l_approval_type = 'EARNING' THEN
1037: get_offer_earn_req(l_claim_id, l_offer_req);
1038: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');
1031:
1032: IF l_approval_type = 'PERFORMANCE' THEN
1033: get_offer_perf_req(l_claim_id, l_offer_req);
1034: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_INFO');
1035: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1036: ELSIF l_approval_type = 'EARNING' THEN
1037: get_offer_earn_req(l_claim_id, l_offer_req);
1038: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');
1039: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1034: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REM_INFO');
1035: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1036: ELSIF l_approval_type = 'EARNING' THEN
1037: get_offer_earn_req(l_claim_id, l_offer_req);
1038: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');
1039: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1040: ELSE
1041: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1042: END IF;
1035: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1036: ELSIF l_approval_type = 'EARNING' THEN
1037: get_offer_earn_req(l_claim_id, l_offer_req);
1038: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');
1039: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1040: ELSE
1041: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1042: END IF;
1043: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1037: get_offer_earn_req(l_claim_id, l_offer_req);
1038: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REM_INFO');
1039: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1040: ELSE
1041: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1042: END IF;
1043: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1044: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1045: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1039: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1040: ELSE
1041: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1042: END IF;
1043: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1044: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1045: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1046: fnd_message.set_token('DUE_DATE', l_due_date, false);
1047: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1040: ELSE
1041: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1042: END IF;
1043: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1044: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1045: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1046: fnd_message.set_token('DUE_DATE', l_due_date, false);
1047: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1048: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1041: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPR_REM_INFO');
1042: END IF;
1043: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1044: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1045: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1046: fnd_message.set_token('DUE_DATE', l_due_date, false);
1047: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1048: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1049: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1042: END IF;
1043: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1044: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1045: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1046: fnd_message.set_token('DUE_DATE', l_due_date, false);
1047: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1048: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1049: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1050: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1043: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1044: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1045: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1046: fnd_message.set_token('DUE_DATE', l_due_date, false);
1047: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1048: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1049: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1050: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1051: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1044: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1045: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1046: fnd_message.set_token('DUE_DATE', l_due_date, false);
1047: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1048: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1049: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1050: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1051: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1052: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1045: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1046: fnd_message.set_token('DUE_DATE', l_due_date, false);
1047: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1048: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1049: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1050: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1051: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1052: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1053: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1046: fnd_message.set_token('DUE_DATE', l_due_date, false);
1047: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1048: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1049: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1050: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1051: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1052: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1053: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1054: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1047: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1048: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1049: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1050: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1051: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1052: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1053: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1054: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1055: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1048: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1049: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1050: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1051: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1052: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1053: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1054: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1055: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1056: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1049: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1050: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1051: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1052: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1053: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1054: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1055: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1056: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1057: l_body := fnd_message.get;
1050: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1051: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1052: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1053: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1054: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1055: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1056: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1057: l_body := fnd_message.get;
1058: /*
1051: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1052: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1053: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1054: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1055: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1056: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1057: l_body := fnd_message.get;
1058: /*
1059: l_note := wf_engine.getitemattrtext(
1052: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1053: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1054: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1055: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1056: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1057: l_body := fnd_message.get;
1058: /*
1059: l_note := wf_engine.getitemattrtext(
1060: itemtype => l_item_type
1053: fnd_message.set_token('AMOUNT', l_requested_amt, false);
1054: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1055: fnd_message.set_token('JUSTIFICATION_NOTES', l_note, false);
1056: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1057: l_body := fnd_message.get;
1058: /*
1059: l_note := wf_engine.getitemattrtext(
1060: itemtype => l_item_type
1061: ,itemkey => l_item_key
1262: , l_claim_source;
1263: CLOSE c_claim_rec;
1264:
1265: IF l_approval_type = 'PERFORMANCE' THEN
1266: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1267: ELSIF l_approval_type = 'EARNING' THEN
1268: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1269: ELSE
1270: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1264:
1265: IF l_approval_type = 'PERFORMANCE' THEN
1266: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1267: ELSIF l_approval_type = 'EARNING' THEN
1268: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1269: ELSE
1270: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1271: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1272: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1266: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1267: ELSIF l_approval_type = 'EARNING' THEN
1268: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1269: ELSE
1270: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1271: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1272: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1273: END IF;
1274: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1267: ELSIF l_approval_type = 'EARNING' THEN
1268: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1269: ELSE
1270: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1271: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1272: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1273: END IF;
1274: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1275: --fnd_message.set_token('APPROVER', l_approver, false);
1268: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1269: ELSE
1270: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1271: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1272: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1273: END IF;
1274: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1275: --fnd_message.set_token('APPROVER', l_approver, false);
1276: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1270: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1271: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1272: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1273: END IF;
1274: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1275: --fnd_message.set_token('APPROVER', l_approver, false);
1276: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1277: l_subject := fnd_message.get;
1278:
1271: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1272: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1273: END IF;
1274: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1275: --fnd_message.set_token('APPROVER', l_approver, false);
1276: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1277: l_subject := fnd_message.get;
1278:
1279: wf_engine.setitemattrtext(
1272: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1273: END IF;
1274: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1275: --fnd_message.set_token('APPROVER', l_approver, false);
1276: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1277: l_subject := fnd_message.get;
1278:
1279: wf_engine.setitemattrtext(
1280: itemtype => l_item_type
1273: END IF;
1274: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1275: --fnd_message.set_token('APPROVER', l_approver, false);
1276: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1277: l_subject := fnd_message.get;
1278:
1279: wf_engine.setitemattrtext(
1280: itemtype => l_item_type
1281: ,itemkey => l_item_key
1284: );
1285:
1286: IF l_approval_type = 'PERFORMANCE' THEN
1287: get_offer_perf_req(l_claim_id, l_offer_req);
1288: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_INFO');
1289: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1290: ELSIF l_approval_type = 'EARNING' THEN
1291: get_offer_earn_req(l_claim_id, l_offer_req);
1292: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');
1285:
1286: IF l_approval_type = 'PERFORMANCE' THEN
1287: get_offer_perf_req(l_claim_id, l_offer_req);
1288: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_INFO');
1289: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1290: ELSIF l_approval_type = 'EARNING' THEN
1291: get_offer_earn_req(l_claim_id, l_offer_req);
1292: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');
1293: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1288: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_INFO');
1289: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1290: ELSIF l_approval_type = 'EARNING' THEN
1291: get_offer_earn_req(l_claim_id, l_offer_req);
1292: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');
1293: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1294: ELSE
1295: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1296: END IF;
1289: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1290: ELSIF l_approval_type = 'EARNING' THEN
1291: get_offer_earn_req(l_claim_id, l_offer_req);
1292: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');
1293: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1294: ELSE
1295: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1296: END IF;
1297: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1291: get_offer_earn_req(l_claim_id, l_offer_req);
1292: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_INFO');
1293: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1294: ELSE
1295: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1296: END IF;
1297: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1298: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1299: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1293: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1294: ELSE
1295: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1296: END IF;
1297: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1298: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1299: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1300: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1301: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1294: ELSE
1295: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1296: END IF;
1297: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1298: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1299: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1300: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1301: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1302: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1295: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_INFO');
1296: END IF;
1297: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1298: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1299: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1300: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1301: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1302: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1303: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1296: END IF;
1297: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1298: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1299: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1300: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1301: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1302: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1303: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1304: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1297: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1298: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1299: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1300: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1301: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1302: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1303: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1304: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1305: fnd_message.set_token('DUE_DATE', l_due_date, false);
1298: fnd_message.set_token('AMOUNT', l_approved_amt, false);
1299: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1300: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1301: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1302: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1303: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1304: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1305: fnd_message.set_token('DUE_DATE', l_due_date, false);
1306: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1299: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1300: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1301: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1302: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1303: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1304: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1305: fnd_message.set_token('DUE_DATE', l_due_date, false);
1306: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1307: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1300: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1301: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1302: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1303: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1304: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1305: fnd_message.set_token('DUE_DATE', l_due_date, false);
1306: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1307: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1308: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1301: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1302: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1303: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1304: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1305: fnd_message.set_token('DUE_DATE', l_due_date, false);
1306: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1307: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1308: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1309: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1302: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1303: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1304: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1305: fnd_message.set_token('DUE_DATE', l_due_date, false);
1306: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1307: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1308: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1309: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1310: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1303: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1304: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1305: fnd_message.set_token('DUE_DATE', l_due_date, false);
1306: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1307: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1308: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1309: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1310: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1311: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1304: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1305: fnd_message.set_token('DUE_DATE', l_due_date, false);
1306: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1307: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1308: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1309: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1310: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1311: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1312: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1305: fnd_message.set_token('DUE_DATE', l_due_date, false);
1306: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1307: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1308: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1309: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1310: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1311: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1312: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1313: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1306: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1307: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1308: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1309: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1310: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1311: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1312: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1313: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1314: l_body := fnd_message.get;
1307: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1308: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1309: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1310: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1311: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1312: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1313: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1314: l_body := fnd_message.get;
1315: /*
1308: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1309: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1310: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1311: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1312: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1313: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1314: l_body := fnd_message.get;
1315: /*
1316: l_note := wf_engine.getitemattrtext(
1309: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1310: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1311: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1312: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1313: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1314: l_body := fnd_message.get;
1315: /*
1316: l_note := wf_engine.getitemattrtext(
1317: itemtype => l_item_type
1310: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1311: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1312: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1313: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1314: l_body := fnd_message.get;
1315: /*
1316: l_note := wf_engine.getitemattrtext(
1317: itemtype => l_item_type
1318: ,itemkey => l_item_key
1517: , l_claim_source;
1518: CLOSE c_claim_rec;
1519:
1520: IF l_approval_type = 'PERFORMANCE' THEN
1521: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1522: ELSIF l_approval_type = 'EARNING' THEN
1523: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1524: ELSE
1525: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1519:
1520: IF l_approval_type = 'PERFORMANCE' THEN
1521: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1522: ELSIF l_approval_type = 'EARNING' THEN
1523: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1524: ELSE
1525: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1526: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1527: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1521: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1522: ELSIF l_approval_type = 'EARNING' THEN
1523: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1524: ELSE
1525: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1526: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1527: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1528: END IF;
1529: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1522: ELSIF l_approval_type = 'EARNING' THEN
1523: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1524: ELSE
1525: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1526: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1527: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1528: END IF;
1529: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1530: --fnd_message.set_token('APPROVER', l_approver, false);
1523: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1524: ELSE
1525: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1526: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1527: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1528: END IF;
1529: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1530: --fnd_message.set_token('APPROVER', l_approver, false);
1531: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1525: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1526: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1527: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1528: END IF;
1529: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1530: --fnd_message.set_token('APPROVER', l_approver, false);
1531: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1532: l_subject := fnd_message.get;
1533:
1526: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1527: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1528: END IF;
1529: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1530: --fnd_message.set_token('APPROVER', l_approver, false);
1531: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1532: l_subject := fnd_message.get;
1533:
1534: wf_engine.setitemattrtext(
1527: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1528: END IF;
1529: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1530: --fnd_message.set_token('APPROVER', l_approver, false);
1531: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1532: l_subject := fnd_message.get;
1533:
1534: wf_engine.setitemattrtext(
1535: itemtype => l_item_type
1528: END IF;
1529: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1530: --fnd_message.set_token('APPROVER', l_approver, false);
1531: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1532: l_subject := fnd_message.get;
1533:
1534: wf_engine.setitemattrtext(
1535: itemtype => l_item_type
1536: ,itemkey => l_item_key
1539: );
1540:
1541: IF l_approval_type = 'PERFORMANCE' THEN
1542: get_offer_perf_req(l_claim_id, l_offer_req);
1543: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_INFO');
1544: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1545: ELSIF l_approval_type = 'EARNING' THEN
1546: get_offer_earn_req(l_claim_id, l_offer_req);
1547: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');
1540:
1541: IF l_approval_type = 'PERFORMANCE' THEN
1542: get_offer_perf_req(l_claim_id, l_offer_req);
1543: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_INFO');
1544: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1545: ELSIF l_approval_type = 'EARNING' THEN
1546: get_offer_earn_req(l_claim_id, l_offer_req);
1547: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');
1548: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1543: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_INFO');
1544: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1545: ELSIF l_approval_type = 'EARNING' THEN
1546: get_offer_earn_req(l_claim_id, l_offer_req);
1547: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');
1548: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1549: ELSE
1550: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1551: END IF;
1544: fnd_message.set_token('OFFR_PERF_REQ', l_offer_req, false);
1545: ELSIF l_approval_type = 'EARNING' THEN
1546: get_offer_earn_req(l_claim_id, l_offer_req);
1547: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');
1548: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1549: ELSE
1550: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1551: END IF;
1552: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1546: get_offer_earn_req(l_claim_id, l_offer_req);
1547: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_INFO');
1548: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1549: ELSE
1550: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1551: END IF;
1552: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1553: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1554: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1548: fnd_message.set_token('OFFR_EARN_REQ', l_offer_req, false);
1549: ELSE
1550: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1551: END IF;
1552: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1553: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1554: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1555: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1556: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1549: ELSE
1550: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1551: END IF;
1552: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1553: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1554: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1555: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1556: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1557: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1550: fnd_message.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_INFO');
1551: END IF;
1552: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1553: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1554: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1555: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1556: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1557: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1558: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1551: END IF;
1552: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1553: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1554: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1555: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1556: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1557: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1558: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1559: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1552: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
1553: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1554: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1555: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1556: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1557: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1558: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1559: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1560: fnd_message.set_token('DUE_DATE', l_due_date, false);
1553: fnd_message.set_token('AMOUNT', l_amount_settled, false);
1554: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1555: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1556: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1557: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1558: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1559: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1560: fnd_message.set_token('DUE_DATE', l_due_date, false);
1561: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1554: fnd_message.set_token('APPROVER_NAME', l_approver, false);
1555: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1556: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1557: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1558: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1559: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1560: fnd_message.set_token('DUE_DATE', l_due_date, false);
1561: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1562: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1555: fnd_message.set_token('DATE', TO_CHAR(SYSDATE, 'MM-DD-YYYY'), false);
1556: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1557: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1558: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1559: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1560: fnd_message.set_token('DUE_DATE', l_due_date, false);
1561: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1562: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1563: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1556: fnd_message.set_token('TIME', TO_CHAR(SYSDATE, 'HH24:MI'), false);
1557: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1558: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1559: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1560: fnd_message.set_token('DUE_DATE', l_due_date, false);
1561: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1562: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1563: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1564: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1557: fnd_message.set_token('CLAIM_NUMBER', l_claim_number, false);
1558: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1559: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1560: fnd_message.set_token('DUE_DATE', l_due_date, false);
1561: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1562: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1563: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1564: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1565: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1558: fnd_message.set_token('CLAIM_TYPE', l_claim_type, false);
1559: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1560: fnd_message.set_token('DUE_DATE', l_due_date, false);
1561: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1562: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1563: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1564: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1565: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1566: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1559: fnd_message.set_token('CLAIM_DATE', l_claim_date, false);
1560: fnd_message.set_token('DUE_DATE', l_due_date, false);
1561: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1562: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1563: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1564: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1565: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1566: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1567: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1560: fnd_message.set_token('DUE_DATE', l_due_date, false);
1561: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1562: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1563: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1564: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1565: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1566: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1567: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1568: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1561: fnd_message.set_token('CUSTOMER_NAME', l_account_name, false);
1562: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1563: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1564: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1565: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1566: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1567: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1568: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1569: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1562: fnd_message.set_token('CUST_ACCT_NUMBER', l_account_number, false);
1563: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1564: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1565: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1566: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1567: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1568: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1569: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1570: l_body := fnd_message.get;
1563: fnd_message.set_token('BILL_TO_SITE', l_billto_site, false);
1564: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1565: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1566: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1567: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1568: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1569: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1570: l_body := fnd_message.get;
1571: /*
1564: fnd_message.set_token('CM_REASON', l_cm_reason, false);
1565: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1566: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1567: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1568: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1569: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1570: l_body := fnd_message.get;
1571: /*
1572: l_note := wf_engine.getitemattrtext(
1565: fnd_message.set_token('ADJ_REASON', l_adj_reason, false);
1566: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1567: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1568: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1569: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1570: l_body := fnd_message.get;
1571: /*
1572: l_note := wf_engine.getitemattrtext(
1573: itemtype => l_item_type
1566: fnd_message.set_token('SETTLEMENT_METHOD', l_payment_method, false);
1567: fnd_message.set_token('JUSTIFICATION_NOTES', '', false);
1568: fnd_message.set_token('COMMENTS_NOTES', l_note, false);
1569: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1570: l_body := fnd_message.get;
1571: /*
1572: l_note := wf_engine.getitemattrtext(
1573: itemtype => l_item_type
1574: ,itemkey => l_item_key
1792:
1793: EXCEPTION
1794: WHEN OTHERS THEN
1795: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1796: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
1797: FND_MSG_PUB.add;
1798: END IF;
1799: IF OZF_DEBUG_LOW_ON THEN
1800: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1796: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
1797: FND_MSG_PUB.add;
1798: END IF;
1799: IF OZF_DEBUG_LOW_ON THEN
1800: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1801: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1802: FND_MSG_PUB.Add;
1803: END IF;
1804: RAISE FND_API.g_exc_unexpected_error;
1797: FND_MSG_PUB.add;
1798: END IF;
1799: IF OZF_DEBUG_LOW_ON THEN
1800: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1801: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1802: FND_MSG_PUB.Add;
1803: END IF;
1804: RAISE FND_API.g_exc_unexpected_error;
1805: END;
1886: );
1887: -- End Bug fix for 8656583
1888:
1889: IF l_approval_type = 'PERFORMANCE' THEN
1890: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
1891: ELSIF l_approval_type = 'EARNING' THEN
1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
1888:
1889: IF l_approval_type = 'PERFORMANCE' THEN
1890: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
1891: ELSIF l_approval_type = 'EARNING' THEN
1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_SUBJ');
1895: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1896: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1890: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_FORD_SUBJ');
1891: ELSIF l_approval_type = 'EARNING' THEN
1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_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);
1891: ELSIF l_approval_type = 'EARNING' THEN
1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_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: --fnd_message.set_token('APPROVER', l_approver, false);
1892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_FORD_SUBJ');
1893: ELSE
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_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: --fnd_message.set_token('APPROVER', l_approver, false);
1900: l_subject := FND_MESSAGE.get;
1894: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_FORWARD_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: --fnd_message.set_token('APPROVER', l_approver, false);
1900: l_subject := FND_MESSAGE.get;
1901:
1902: WF_ENGINE.setitemattrtext(
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: --fnd_message.set_token('APPROVER', l_approver, false);
1900: l_subject := FND_MESSAGE.get;
1901:
1902: WF_ENGINE.setitemattrtext(
1903: itemtype => itemtype
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: --fnd_message.set_token('APPROVER', l_approver, false);
1900: l_subject := FND_MESSAGE.get;
1901:
1902: WF_ENGINE.setitemattrtext(
1903: itemtype => itemtype
1904: ,itemkey => itemkey
1906: ,avalue => l_subject
1907: );
1908:
1909: IF l_approval_type = 'PERFORMANCE' THEN
1910: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
1911: ELSIF l_approval_type = 'EARNING' THEN
1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
1908:
1909: IF l_approval_type = 'PERFORMANCE' THEN
1910: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
1911: ELSIF l_approval_type = 'EARNING' THEN
1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_SUBJ');
1915: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1916: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1910: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPR_SUBJ');
1911: ELSIF l_approval_type = 'EARNING' THEN
1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_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);
1911: ELSIF l_approval_type = 'EARNING' THEN
1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_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: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1912: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPR_SUBJ');
1913: ELSE
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_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: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1920: l_subject := fnd_message.get;
1914: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVAL_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: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1920: l_subject := fnd_message.get;
1921:
1922: WF_ENGINE.setitemattrtext(
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: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1920: l_subject := fnd_message.get;
1921:
1922: WF_ENGINE.setitemattrtext(
1923: itemtype => itemtype
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: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1920: l_subject := fnd_message.get;
1921:
1922: WF_ENGINE.setitemattrtext(
1923: itemtype => itemtype
1924: ,itemkey => itemkey
1926: ,avalue => l_subject
1927: );
1928:
1929: IF l_approval_type = 'PERFORMANCE' THEN
1930: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1931: ELSIF l_approval_type = 'EARNING' THEN
1932: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1933: ELSE
1934: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1928:
1929: IF l_approval_type = 'PERFORMANCE' THEN
1930: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1931: ELSIF l_approval_type = 'EARNING' THEN
1932: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1933: ELSE
1934: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1935: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1936: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1930: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_APPRD_SUBJ');
1931: ELSIF l_approval_type = 'EARNING' THEN
1932: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1933: ELSE
1934: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1935: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1936: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1937: END IF;
1938: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1931: ELSIF l_approval_type = 'EARNING' THEN
1932: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1933: ELSE
1934: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1935: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1936: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1937: END IF;
1938: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1939: --fnd_message.set_token('APPROVER', l_approver, false);
1932: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_APPRD_SUBJ');
1933: ELSE
1934: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1935: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1936: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1937: END IF;
1938: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1939: --fnd_message.set_token('APPROVER', l_approver, false);
1940: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1934: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_APPROVED_SUBJ');
1935: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1936: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1937: END IF;
1938: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1939: --fnd_message.set_token('APPROVER', l_approver, false);
1940: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1941: l_subject := FND_MESSAGE.get;
1942:
1935: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1936: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1937: END IF;
1938: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1939: --fnd_message.set_token('APPROVER', l_approver, false);
1940: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1941: l_subject := FND_MESSAGE.get;
1942:
1943: WF_ENGINE.setitemattrtext(
1936: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1937: END IF;
1938: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1939: --fnd_message.set_token('APPROVER', l_approver, false);
1940: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1941: l_subject := FND_MESSAGE.get;
1942:
1943: WF_ENGINE.setitemattrtext(
1944: itemtype => itemtype
1937: END IF;
1938: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1939: --fnd_message.set_token('APPROVER', l_approver, false);
1940: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1941: l_subject := FND_MESSAGE.get;
1942:
1943: WF_ENGINE.setitemattrtext(
1944: itemtype => itemtype
1945: ,itemkey => itemkey
1947: ,avalue => l_subject
1948: );
1949:
1950: IF l_approval_type = 'PERFORMANCE' THEN
1951: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1952: ELSIF l_approval_type = 'EARNING' THEN
1953: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1954: ELSE
1955: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1949:
1950: IF l_approval_type = 'PERFORMANCE' THEN
1951: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1952: ELSIF l_approval_type = 'EARNING' THEN
1953: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1954: ELSE
1955: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1956: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1957: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1951: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_PERF_REJ_SUBJ');
1952: ELSIF l_approval_type = 'EARNING' THEN
1953: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1954: ELSE
1955: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1956: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1957: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1958: END IF;
1959: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1952: ELSIF l_approval_type = 'EARNING' THEN
1953: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1954: ELSE
1955: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1956: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1957: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1958: END IF;
1959: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1960: --fnd_message.set_token('APPROVER', l_approver, false);
1953: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_EARN_REJ_SUBJ');
1954: ELSE
1955: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1956: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1957: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1958: END IF;
1959: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1960: --fnd_message.set_token('APPROVER', l_approver, false);
1961: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1955: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NTF_REJECTED_SUBJ');
1956: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1957: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1958: END IF;
1959: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1960: --fnd_message.set_token('APPROVER', l_approver, false);
1961: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1962: l_subject := FND_MESSAGE.get;
1963:
1956: FND_MESSAGE.set_token('CURRENCY_CODE', l_currency, false);
1957: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1958: END IF;
1959: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1960: --fnd_message.set_token('APPROVER', l_approver, false);
1961: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1962: l_subject := FND_MESSAGE.get;
1963:
1964: WF_ENGINE.setitemattrtext(
1957: FND_MESSAGE.set_token('AMOUNT', l_amount_settled, false);
1958: END IF;
1959: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1960: --fnd_message.set_token('APPROVER', l_approver, false);
1961: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1962: l_subject := FND_MESSAGE.get;
1963:
1964: WF_ENGINE.setitemattrtext(
1965: itemtype => itemtype
1958: END IF;
1959: FND_MESSAGE.set_token('CLAIM_NUMBER', l_claim_number, false);
1960: --fnd_message.set_token('APPROVER', l_approver, false);
1961: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1962: l_subject := FND_MESSAGE.get;
1963:
1964: WF_ENGINE.setitemattrtext(
1965: itemtype => itemtype
1966: ,itemkey => itemkey
2030: resultout := 'COMPLETE:ERROR';
2031: RETURN;
2032: --RAISE;
2033: WHEN OTHERS THEN
2034: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2035: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2036: FND_MSG_PUB.Add;
2037:
2038: FND_MSG_PUB.count_and_get (
2031: RETURN;
2032: --RAISE;
2033: WHEN OTHERS THEN
2034: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2035: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2036: FND_MSG_PUB.Add;
2037:
2038: FND_MSG_PUB.count_and_get (
2039: p_encoded => fnd_api.g_false
2123: WHERE claim_id = p_claim_id;
2124: EXCEPTION
2125: WHEN OTHERS THEN
2126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2127: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
2128: FND_MSG_PUB.add;
2129: END IF;
2130: IF OZF_DEBUG_LOW_ON THEN
2131: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2127: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_UPD_CLAM_ERR');
2128: FND_MSG_PUB.add;
2129: END IF;
2130: IF OZF_DEBUG_LOW_ON THEN
2131: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2132: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2133: FND_MSG_PUB.Add;
2134: END IF;
2135: RAISE FND_API.g_exc_unexpected_error;
2128: FND_MSG_PUB.add;
2129: END IF;
2130: IF OZF_DEBUG_LOW_ON THEN
2131: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2132: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2133: FND_MSG_PUB.Add;
2134: END IF;
2135: RAISE FND_API.g_exc_unexpected_error;
2136: END;
2154: );
2155:
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2159: FND_MESSAGE.Set_Token('TEXT',l_full_name||' - '||p_approval_type||' : Error');
2160: FND_MSG_PUB.Add;
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2162:
2155:
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2159: FND_MESSAGE.Set_Token('TEXT',l_full_name||' - '||p_approval_type||' : Error');
2160: FND_MSG_PUB.Add;
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2162:
2163: END Start_Approval_Process;
2475: IF l_approved_amount <> l_claim_amount_settled AND
2476: l_payment_method <> 'MASS_SETTLEMENT' THEN
2477: IF l_update_status IN ('APPROVED', 'REJECTED') THEN
2478: --set message.
2479: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2480: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2481: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2482: FND_MSG_PUB.ADD;
2483: FND_MSG_PUB.count_and_get (
2476: l_payment_method <> 'MASS_SETTLEMENT' THEN
2477: IF l_update_status IN ('APPROVED', 'REJECTED') THEN
2478: --set message.
2479: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2480: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2481: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2482: FND_MSG_PUB.ADD;
2483: FND_MSG_PUB.count_and_get (
2484: p_encoded => fnd_api.g_false
2477: IF l_update_status IN ('APPROVED', 'REJECTED') THEN
2478: --set message.
2479: FND_MESSAGE.Set_Name('AMS','AMS_WF_NTF_AMOUNT_CHANGE_FYI');
2480: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2481: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2482: FND_MSG_PUB.ADD;
2483: FND_MSG_PUB.count_and_get (
2484: p_encoded => fnd_api.g_false
2485: ,p_count => l_msg_count
2697: );
2698: RAISE;
2699:
2700: WHEN OTHERS THEN
2701: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2702: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2703: FND_MSG_PUB.Add;
2704:
2705: fnd_msg_pub.count_and_get(
2698: RAISE;
2699:
2700: WHEN OTHERS THEN
2701: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2702: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2703: FND_MSG_PUB.Add;
2704:
2705: fnd_msg_pub.count_and_get(
2706: p_encoded => fnd_api.g_false