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

APPS.AP_WEB_CREDIT_CARD_WF dependencies on FND_MESSAGE

Line 284: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

280:
281: EXCEPTION
282: WHEN OTHERS THEN
283: IF (SQLCODE <> -20001) THEN
284: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
285: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
286: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendPaymentNotification');
287: FND_MESSAGE.SET_TOKEN('PARAMETERS',
288: 'p_checkNumber = ' || to_char(p_checkNumber) ||

Line 285: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

281: EXCEPTION
282: WHEN OTHERS THEN
283: IF (SQLCODE <> -20001) THEN
284: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
285: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
286: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendPaymentNotification');
287: FND_MESSAGE.SET_TOKEN('PARAMETERS',
288: 'p_checkNumber = ' || to_char(p_checkNumber) ||
289: ', p_employeeId = '|| to_char(p_employeeId) ||

Line 286: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendPaymentNotification');

282: WHEN OTHERS THEN
283: IF (SQLCODE <> -20001) THEN
284: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
285: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
286: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendPaymentNotification');
287: FND_MESSAGE.SET_TOKEN('PARAMETERS',
288: 'p_checkNumber = ' || to_char(p_checkNumber) ||
289: ', p_employeeId = '|| to_char(p_employeeId) ||
290: ', p_paymentCurrency = ' || p_paymentCurrency ||

Line 287: FND_MESSAGE.SET_TOKEN('PARAMETERS',

283: IF (SQLCODE <> -20001) THEN
284: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
285: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
286: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendPaymentNotification');
287: FND_MESSAGE.SET_TOKEN('PARAMETERS',
288: 'p_checkNumber = ' || to_char(p_checkNumber) ||
289: ', p_employeeId = '|| to_char(p_employeeId) ||
290: ', p_paymentCurrency = ' || p_paymentCurrency ||
291: ', p_invoiceNumber = ' || p_invoiceNumber ||

Line 298: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);

294: ', p_account = ' || l_account ||
295: ', p_bankName = ' || p_bankName ||
296: ', p_cardIssuer = ' || p_cardIssuer ||
297: ', p_paymentDate = ' || p_paymentDate);
298: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
299: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
300: ELSE
301: -- Do not need to set the token since it has been done in the
302: -- child process

Line 299: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);

295: ', p_bankName = ' || p_bankName ||
296: ', p_cardIssuer = ' || p_cardIssuer ||
297: ', p_paymentDate = ' || p_paymentDate);
298: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
299: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
300: ELSE
301: -- Do not need to set the token since it has been done in the
302: -- child process
303: RAISE;

Line 450: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');

446: ------------------------------------------------------
447: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications); -- Bug 6026927
448:
449:
450: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
451: l_instructions := FND_MESSAGE.GET;
452:
453: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
454: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);

Line 451: l_instructions := FND_MESSAGE.GET;

447: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications); -- Bug 6026927
448:
449:
450: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
451: l_instructions := FND_MESSAGE.GET;
452:
453: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
454: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
455: l_mgr_instructions := FND_MESSAGE.GET;

Line 453: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');

449:
450: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
451: l_instructions := FND_MESSAGE.GET;
452:
453: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
454: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
455: l_mgr_instructions := FND_MESSAGE.GET;
456:
457: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);

Line 454: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);

450: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
451: l_instructions := FND_MESSAGE.GET;
452:
453: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
454: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
455: l_mgr_instructions := FND_MESSAGE.GET;
456:
457: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);
458: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);

Line 455: l_mgr_instructions := FND_MESSAGE.GET;

451: l_instructions := FND_MESSAGE.GET;
452:
453: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
454: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
455: l_mgr_instructions := FND_MESSAGE.GET;
456:
457: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);
458: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);
459:

Line 503: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: IF (SQLCODE <> -20001) THEN
503: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
504: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
505: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnsubmittedChargesNote');
506: FND_MESSAGE.SET_TOKEN('PARAMETERS',
507: 'p_employeeId = ' || to_char(p_employeeId) ||

Line 504: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

500: EXCEPTION
501: WHEN OTHERS THEN
502: IF (SQLCODE <> -20001) THEN
503: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
504: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
505: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnsubmittedChargesNote');
506: FND_MESSAGE.SET_TOKEN('PARAMETERS',
507: 'p_employeeId = ' || to_char(p_employeeId) ||
508: ', p_Amount = ' || to_char(p_Amount) ||

Line 505: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnsubmittedChargesNote');

501: WHEN OTHERS THEN
502: IF (SQLCODE <> -20001) THEN
503: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
504: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
505: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnsubmittedChargesNote');
506: FND_MESSAGE.SET_TOKEN('PARAMETERS',
507: 'p_employeeId = ' || to_char(p_employeeId) ||
508: ', p_Amount = ' || to_char(p_Amount) ||
509: ', p_currency = ' || p_currency ||

Line 506: FND_MESSAGE.SET_TOKEN('PARAMETERS',

502: IF (SQLCODE <> -20001) THEN
503: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
504: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
505: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnsubmittedChargesNote');
506: FND_MESSAGE.SET_TOKEN('PARAMETERS',
507: 'p_employeeId = ' || to_char(p_employeeId) ||
508: ', p_Amount = ' || to_char(p_Amount) ||
509: ', p_currency = ' || p_currency ||
510: ', p_cardIssuer = ' || p_cardIssuer ||

Line 513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);

509: ', p_currency = ' || p_currency ||
510: ', p_cardIssuer = ' || p_cardIssuer ||
511: ', p_date1 = ' || p_date1 ||
512: ', p_date2 = ' || p_date2);
513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
514: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
515: ELSE
516: -- Do not need to set the token since it has been done in the
517: -- child process

Line 514: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);

510: ', p_cardIssuer = ' || p_cardIssuer ||
511: ', p_date1 = ' || p_date1 ||
512: ', p_date2 = ' || p_date2);
513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
514: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
515: ELSE
516: -- Do not need to set the token since it has been done in the
517: -- child process
518: RAISE;

Line 642: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');

638: ----------------------------------------------------------
639: l_debugInfo := 'Set the Subject';
640: ----------------------------------------------------------
641: if(p_dunning_number = 1) then
642: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
643: l_instructions := FND_MESSAGE.GET;
644: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
645: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
646: l_mgr_instructions := FND_MESSAGE.GET;

Line 643: l_instructions := FND_MESSAGE.GET;

639: l_debugInfo := 'Set the Subject';
640: ----------------------------------------------------------
641: if(p_dunning_number = 1) then
642: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
643: l_instructions := FND_MESSAGE.GET;
644: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
645: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
646: l_mgr_instructions := FND_MESSAGE.GET;
647:

Line 644: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');

640: ----------------------------------------------------------
641: if(p_dunning_number = 1) then
642: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
643: l_instructions := FND_MESSAGE.GET;
644: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
645: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
646: l_mgr_instructions := FND_MESSAGE.GET;
647:
648:

Line 645: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);

641: if(p_dunning_number = 1) then
642: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
643: l_instructions := FND_MESSAGE.GET;
644: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
645: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
646: l_mgr_instructions := FND_MESSAGE.GET;
647:
648:
649: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING1');

Line 646: l_mgr_instructions := FND_MESSAGE.GET;

642: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
643: l_instructions := FND_MESSAGE.GET;
644: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
645: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
646: l_mgr_instructions := FND_MESSAGE.GET;
647:
648:
649: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING1');
650: l_mgr_esc_instructions := FND_MESSAGE.GET;

Line 649: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING1');

645: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
646: l_mgr_instructions := FND_MESSAGE.GET;
647:
648:
649: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING1');
650: l_mgr_esc_instructions := FND_MESSAGE.GET;
651:
652:
653: elsif(p_dunning_number = 2) then

Line 650: l_mgr_esc_instructions := FND_MESSAGE.GET;

646: l_mgr_instructions := FND_MESSAGE.GET;
647:
648:
649: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING1');
650: l_mgr_esc_instructions := FND_MESSAGE.GET;
651:
652:
653: elsif(p_dunning_number = 2) then
654: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');

Line 654: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');

650: l_mgr_esc_instructions := FND_MESSAGE.GET;
651:
652:
653: elsif(p_dunning_number = 2) then
654: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
655: l_instructions := FND_MESSAGE.GET;
656: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
657: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
658: l_mgr_instructions := FND_MESSAGE.GET;

Line 655: l_instructions := FND_MESSAGE.GET;

651:
652:
653: elsif(p_dunning_number = 2) then
654: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
655: l_instructions := FND_MESSAGE.GET;
656: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
657: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
658: l_mgr_instructions := FND_MESSAGE.GET;
659:

Line 656: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');

652:
653: elsif(p_dunning_number = 2) then
654: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
655: l_instructions := FND_MESSAGE.GET;
656: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
657: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
658: l_mgr_instructions := FND_MESSAGE.GET;
659:
660:

Line 657: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);

653: elsif(p_dunning_number = 2) then
654: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
655: l_instructions := FND_MESSAGE.GET;
656: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
657: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
658: l_mgr_instructions := FND_MESSAGE.GET;
659:
660:
661: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');

Line 658: l_mgr_instructions := FND_MESSAGE.GET;

654: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
655: l_instructions := FND_MESSAGE.GET;
656: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
657: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
658: l_mgr_instructions := FND_MESSAGE.GET;
659:
660:
661: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');
662: l_mgr_esc_instructions := FND_MESSAGE.GET;

Line 661: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');

657: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
658: l_mgr_instructions := FND_MESSAGE.GET;
659:
660:
661: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');
662: l_mgr_esc_instructions := FND_MESSAGE.GET;
663:
664: elsif(p_dunning_number = 3) then
665: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');

Line 662: l_mgr_esc_instructions := FND_MESSAGE.GET;

658: l_mgr_instructions := FND_MESSAGE.GET;
659:
660:
661: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');
662: l_mgr_esc_instructions := FND_MESSAGE.GET;
663:
664: elsif(p_dunning_number = 3) then
665: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
666: l_instructions := FND_MESSAGE.GET;

Line 665: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');

661: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');
662: l_mgr_esc_instructions := FND_MESSAGE.GET;
663:
664: elsif(p_dunning_number = 3) then
665: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
666: l_instructions := FND_MESSAGE.GET;
667: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
668: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
669: l_mgr_instructions := FND_MESSAGE.GET;

Line 666: l_instructions := FND_MESSAGE.GET;

662: l_mgr_esc_instructions := FND_MESSAGE.GET;
663:
664: elsif(p_dunning_number = 3) then
665: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
666: l_instructions := FND_MESSAGE.GET;
667: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
668: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
669: l_mgr_instructions := FND_MESSAGE.GET;
670:

Line 667: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');

663:
664: elsif(p_dunning_number = 3) then
665: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
666: l_instructions := FND_MESSAGE.GET;
667: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
668: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
669: l_mgr_instructions := FND_MESSAGE.GET;
670:
671:

Line 668: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);

664: elsif(p_dunning_number = 3) then
665: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
666: l_instructions := FND_MESSAGE.GET;
667: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
668: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
669: l_mgr_instructions := FND_MESSAGE.GET;
670:
671:
672: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');

Line 669: l_mgr_instructions := FND_MESSAGE.GET;

665: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
666: l_instructions := FND_MESSAGE.GET;
667: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
668: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
669: l_mgr_instructions := FND_MESSAGE.GET;
670:
671:
672: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');
673: l_mgr_esc_instructions := FND_MESSAGE.GET;

Line 672: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');

668: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
669: l_mgr_instructions := FND_MESSAGE.GET;
670:
671:
672: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');
673: l_mgr_esc_instructions := FND_MESSAGE.GET;
674:
675: elsif(p_dunning_number = 4) then
676: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');

Line 673: l_mgr_esc_instructions := FND_MESSAGE.GET;

669: l_mgr_instructions := FND_MESSAGE.GET;
670:
671:
672: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');
673: l_mgr_esc_instructions := FND_MESSAGE.GET;
674:
675: elsif(p_dunning_number = 4) then
676: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
677: l_instructions := FND_MESSAGE.GET;

Line 676: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');

672: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');
673: l_mgr_esc_instructions := FND_MESSAGE.GET;
674:
675: elsif(p_dunning_number = 4) then
676: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
677: l_instructions := FND_MESSAGE.GET;
678: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
679: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
680: l_mgr_instructions := FND_MESSAGE.GET;

Line 677: l_instructions := FND_MESSAGE.GET;

673: l_mgr_esc_instructions := FND_MESSAGE.GET;
674:
675: elsif(p_dunning_number = 4) then
676: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
677: l_instructions := FND_MESSAGE.GET;
678: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
679: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
680: l_mgr_instructions := FND_MESSAGE.GET;
681:

Line 678: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');

674:
675: elsif(p_dunning_number = 4) then
676: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
677: l_instructions := FND_MESSAGE.GET;
678: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
679: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
680: l_mgr_instructions := FND_MESSAGE.GET;
681:
682:

Line 679: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);

675: elsif(p_dunning_number = 4) then
676: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
677: l_instructions := FND_MESSAGE.GET;
678: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
679: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
680: l_mgr_instructions := FND_MESSAGE.GET;
681:
682:
683: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING4');

Line 680: l_mgr_instructions := FND_MESSAGE.GET;

676: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
677: l_instructions := FND_MESSAGE.GET;
678: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
679: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
680: l_mgr_instructions := FND_MESSAGE.GET;
681:
682:
683: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING4');
684: l_mgr_esc_instructions := FND_MESSAGE.GET;

Line 683: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING4');

679: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
680: l_mgr_instructions := FND_MESSAGE.GET;
681:
682:
683: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING4');
684: l_mgr_esc_instructions := FND_MESSAGE.GET;
685:
686: end if;
687:

Line 684: l_mgr_esc_instructions := FND_MESSAGE.GET;

680: l_mgr_instructions := FND_MESSAGE.GET;
681:
682:
683: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING4');
684: l_mgr_esc_instructions := FND_MESSAGE.GET;
685:
686: end if;
687:
688: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);

Line 700: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_ADD_INSTR');

696: ELSE
697: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'N');
698: END IF;
699:
700: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_ADD_INSTR');
701: l_mgr_esc_add_instructions := FND_MESSAGE.GET;
702:
703:
704: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_INSTR', l_mgr_esc_instructions);

Line 701: l_mgr_esc_add_instructions := FND_MESSAGE.GET;

697: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'N');
698: END IF;
699:
700: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_ADD_INSTR');
701: l_mgr_esc_add_instructions := FND_MESSAGE.GET;
702:
703:
704: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_INSTR', l_mgr_esc_instructions);
705: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_ADD_INSTR', l_mgr_esc_add_instructions);

Line 708: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_INSTR');

704: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_INSTR', l_mgr_esc_instructions);
705: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
706:
707:
708: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_INSTR');
709: l_next_mgr_esc_instr := FND_MESSAGE.GET;
710: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_INSTR', l_next_mgr_esc_instr);
711:
712: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_ADD_INSTR', l_mgr_esc_add_instructions);

Line 709: l_next_mgr_esc_instr := FND_MESSAGE.GET;

705: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
706:
707:
708: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_INSTR');
709: l_next_mgr_esc_instr := FND_MESSAGE.GET;
710: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_INSTR', l_next_mgr_esc_instr);
711:
712: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
713:

Line 717: FND_MESSAGE.SET_NAME('SQLAP','OIE_ADD_INFO_DUNNING');

713:
714:
715: --Amulya Mishra : Notification Esc Project
716:
717: FND_MESSAGE.SET_NAME('SQLAP','OIE_ADD_INFO_DUNNING');
718: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));
719: l_add_instructions := FND_MESSAGE.GET;
720: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
721:

Line 718: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));

714:
715: --Amulya Mishra : Notification Esc Project
716:
717: FND_MESSAGE.SET_NAME('SQLAP','OIE_ADD_INFO_DUNNING');
718: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));
719: l_add_instructions := FND_MESSAGE.GET;
720: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
721:
722: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');

Line 719: l_add_instructions := FND_MESSAGE.GET;

715: --Amulya Mishra : Notification Esc Project
716:
717: FND_MESSAGE.SET_NAME('SQLAP','OIE_ADD_INFO_DUNNING');
718: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));
719: l_add_instructions := FND_MESSAGE.GET;
720: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
721:
722: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');
723: l_notes := FND_MESSAGE.GET;

Line 722: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');

718: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));
719: l_add_instructions := FND_MESSAGE.GET;
720: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
721:
722: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');
723: l_notes := FND_MESSAGE.GET;
724: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NOTES', l_notes);
725:
726: --determining SUP1 and SUP2

Line 723: l_notes := FND_MESSAGE.GET;

719: l_add_instructions := FND_MESSAGE.GET;
720: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
721:
722: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');
723: l_notes := FND_MESSAGE.GET;
724: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NOTES', l_notes);
725:
726: --determining SUP1 and SUP2
727:

Line 794: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');

790:
791: IF(p_dunning_number < 4 AND l_sup2_manager_display_name IS NOT NULL) THEN
792:
793:
794: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');
795: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
796: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
797: l_mgmt_instructions := FND_MESSAGE.GET;
798: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);

Line 795: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);

791: IF(p_dunning_number < 4 AND l_sup2_manager_display_name IS NOT NULL) THEN
792:
793:
794: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');
795: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
796: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
797: l_mgmt_instructions := FND_MESSAGE.GET;
798: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
799:

Line 796: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);

792:
793:
794: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');
795: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
796: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
797: l_mgmt_instructions := FND_MESSAGE.GET;
798: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
799:
800: IF (p_dunning_number = 1) THEN

Line 797: l_mgmt_instructions := FND_MESSAGE.GET;

793:
794: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');
795: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
796: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
797: l_mgmt_instructions := FND_MESSAGE.GET;
798: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
799:
800: IF (p_dunning_number = 1) THEN
801:

Line 802: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING1');

798: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
799:
800: IF (p_dunning_number = 1) THEN
801:
802: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING1');
803: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
804: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
805:
806: ELSE

Line 803: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);

799:
800: IF (p_dunning_number = 1) THEN
801:
802: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING1');
803: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
804: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
805:
806: ELSE
807:

Line 804: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;

800: IF (p_dunning_number = 1) THEN
801:
802: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING1');
803: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
804: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
805:
806: ELSE
807:
808: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');

Line 808: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');

804: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
805:
806: ELSE
807:
808: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');
809: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
810: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
811: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
812:

Line 809: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);

805:
806: ELSE
807:
808: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');
809: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
810: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
811: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
812:
813: END IF;

Line 810: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);

806: ELSE
807:
808: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');
809: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
810: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
811: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
812:
813: END IF;
814: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);

Line 811: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;

807:
808: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');
809: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
810: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
811: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
812:
813: END IF;
814: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
815:

Line 816: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_NTF');

812:
813: END IF;
814: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
815:
816: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_NTF');
817: FND_MESSAGE.SET_TOKEN('SUP1', l_sup2_manager_display_name);
818: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
819: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
820:

Line 817: FND_MESSAGE.SET_TOKEN('SUP1', l_sup2_manager_display_name);

813: END IF;
814: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
815:
816: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_NTF');
817: FND_MESSAGE.SET_TOKEN('SUP1', l_sup2_manager_display_name);
818: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
819: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
820:
821:

Line 818: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;

814: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
815:
816: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_NTF');
817: FND_MESSAGE.SET_TOKEN('SUP1', l_sup2_manager_display_name);
818: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
819: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
820:
821:
822: ELSIF (p_dunning_number = 4 OR l_sup2_manager_display_name IS NULL OR l_managerDisplayName = l_sup2_manager_display_name) THEN

Line 824: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_LAST_MGR_NTF_DUNNING');

820:
821:
822: ELSIF (p_dunning_number = 4 OR l_sup2_manager_display_name IS NULL OR l_managerDisplayName = l_sup2_manager_display_name) THEN
823:
824: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_LAST_MGR_NTF_DUNNING');
825: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
826: l_mgmt_instructions := FND_MESSAGE.GET;
827: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
828:

Line 825: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);

821:
822: ELSIF (p_dunning_number = 4 OR l_sup2_manager_display_name IS NULL OR l_managerDisplayName = l_sup2_manager_display_name) THEN
823:
824: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_LAST_MGR_NTF_DUNNING');
825: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
826: l_mgmt_instructions := FND_MESSAGE.GET;
827: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
828:
829: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');

Line 826: l_mgmt_instructions := FND_MESSAGE.GET;

822: ELSIF (p_dunning_number = 4 OR l_sup2_manager_display_name IS NULL OR l_managerDisplayName = l_sup2_manager_display_name) THEN
823:
824: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_LAST_MGR_NTF_DUNNING');
825: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
826: l_mgmt_instructions := FND_MESSAGE.GET;
827: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
828:
829: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
830: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);

Line 829: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');

825: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
826: l_mgmt_instructions := FND_MESSAGE.GET;
827: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
828:
829: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
830: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
831: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
832: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
833:

Line 830: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);

826: l_mgmt_instructions := FND_MESSAGE.GET;
827: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
828:
829: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
830: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
831: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
832: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
833:
834: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');

Line 831: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;

827: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
828:
829: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
830: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
831: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
832: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
833:
834: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');
835: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;

Line 834: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');

830: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
831: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
832: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
833:
834: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');
835: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
836: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
837:
838:

Line 835: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;

831: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
832: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
833:
834: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');
835: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
836: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
837:
838:
839: END IF;

Line 1081: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1077: END;
1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: IF (SQLCODE <> -20001) THEN
1081: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1082: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1083: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SendDunningNotifications');
1084: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1085: ' p_employeeId = ' || to_char(p_employeeId) ||

Line 1082: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: IF (SQLCODE <> -20001) THEN
1081: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1082: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1083: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SendDunningNotifications');
1084: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1085: ' p_employeeId = ' || to_char(p_employeeId) ||
1086: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||

Line 1083: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SendDunningNotifications');

1079: WHEN OTHERS THEN
1080: IF (SQLCODE <> -20001) THEN
1081: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1082: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1083: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SendDunningNotifications');
1084: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1085: ' p_employeeId = ' || to_char(p_employeeId) ||
1086: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1087: ', p_bucket1 = ' || to_char(p_min_bucket) ||

Line 1084: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1080: IF (SQLCODE <> -20001) THEN
1081: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1082: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1083: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SendDunningNotifications');
1084: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1085: ' p_employeeId = ' || to_char(p_employeeId) ||
1086: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1087: ', p_bucket1 = ' || to_char(p_min_bucket) ||
1088: ', p_bucket2 = ' || to_char(p_max_bucket));

Line 1089: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);

1085: ' p_employeeId = ' || to_char(p_employeeId) ||
1086: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1087: ', p_bucket1 = ' || to_char(p_min_bucket) ||
1088: ', p_bucket2 = ' || to_char(p_max_bucket));
1089: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1090: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1091: ELSE
1092: -- Do not need to set the token since it has been done in the
1093: -- child process

Line 1090: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);

1086: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1087: ', p_bucket1 = ' || to_char(p_min_bucket) ||
1088: ', p_bucket2 = ' || to_char(p_max_bucket));
1089: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1090: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1091: ELSE
1092: -- Do not need to set the token since it has been done in the
1093: -- child process
1094: RAISE;

Line 1197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1193:
1194: EXCEPTION
1195: WHEN OTHERS THEN
1196: IF (SQLCODE <> -20001) THEN
1197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1201: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);

Line 1198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1194: EXCEPTION
1195: WHEN OTHERS THEN
1196: IF (SQLCODE <> -20001) THEN
1197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1201: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1202: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);

Line 1199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');

1195: WHEN OTHERS THEN
1196: IF (SQLCODE <> -20001) THEN
1197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1201: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1202: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1203: ELSE

Line 1200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));

1196: IF (SQLCODE <> -20001) THEN
1197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1201: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1202: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1203: ELSE
1204: -- Do not need to set the token since it has been done in the

Line 1201: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);

1197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1201: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1202: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1203: ELSE
1204: -- Do not need to set the token since it has been done in the
1205: -- child process

Line 1202: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);

1198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1201: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1202: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1203: ELSE
1204: -- Do not need to set the token since it has been done in the
1205: -- child process
1206: RAISE;

Line 1349: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1345:
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: IF (SQLCODE <> -20001) THEN
1349: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1350: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1351: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendDisputedChargesNote');
1352: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1353: ' p_employeeId = ' || to_char(p_employeeId) ||

Line 1350: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: IF (SQLCODE <> -20001) THEN
1349: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1350: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1351: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendDisputedChargesNote');
1352: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1353: ' p_employeeId = ' || to_char(p_employeeId) ||
1354: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||

Line 1351: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendDisputedChargesNote');

1347: WHEN OTHERS THEN
1348: IF (SQLCODE <> -20001) THEN
1349: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1350: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1351: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendDisputedChargesNote');
1352: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1353: ' p_employeeId = ' || to_char(p_employeeId) ||
1354: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1355: ', p_billedStartDate = ' || to_char(p_billedStartDate) ||

Line 1352: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1348: IF (SQLCODE <> -20001) THEN
1349: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1350: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1351: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendDisputedChargesNote');
1352: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1353: ' p_employeeId = ' || to_char(p_employeeId) ||
1354: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1355: ', p_billedStartDate = ' || to_char(p_billedStartDate) ||
1356: ', p_billedEndDate = ' || to_char(p_billedEndDate) ||

Line 1358: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);

1354: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1355: ', p_billedStartDate = ' || to_char(p_billedStartDate) ||
1356: ', p_billedEndDate = ' || to_char(p_billedEndDate) ||
1357: ', p_minimumAmount = ' || to_char(p_minimumAmount));
1358: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1359: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1360: ELSE
1361: -- Do not need to set the token since it has been done in the
1362: -- child process

Line 1359: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);

1355: ', p_billedStartDate = ' || to_char(p_billedStartDate) ||
1356: ', p_billedEndDate = ' || to_char(p_billedEndDate) ||
1357: ', p_minimumAmount = ' || to_char(p_minimumAmount));
1358: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1359: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1360: ELSE
1361: -- Do not need to set the token since it has been done in the
1362: -- child process
1363: RAISE;

Line 1430: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');

1426: l_debugInfo := 'Generate header';
1427: if (display_type = 'text/plain') then
1428: document := '';
1429: else -- html
1430: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');
1431: l_dispute_header_prompt := FND_MESSAGE.GET;
1432: document := indent_start||table_title_start|| l_dispute_header_prompt||table_title_end;
1433: document := document|| table_start;
1434: document := document|| tr_start;

Line 1431: l_dispute_header_prompt := FND_MESSAGE.GET;

1427: if (display_type = 'text/plain') then
1428: document := '';
1429: else -- html
1430: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');
1431: l_dispute_header_prompt := FND_MESSAGE.GET;
1432: document := indent_start||table_title_start|| l_dispute_header_prompt||table_title_end;
1433: document := document|| table_start;
1434: document := document|| tr_start;
1435:

Line 1545: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');

1541: l_colon := instr(document, '',-1);
1542: document := substr(document,1,l_colon+4);
1543: document := document || '
';
1544:
1545: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
1546: l_message := FND_MESSAGE.GET;
1547: document := document || '';
1548: document := document || '' || '&' || 'nbsp;';
1549: document := document || '' || '&' || 'nbsp;';
Line 1546: l_message := FND_MESSAGE.GET;

1542: document := substr(document,1,l_colon+4);
1543: document := document || '

';
1544:
1545: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
1546: l_message := FND_MESSAGE.GET;
1547: document := document || '';
1548: document := document || '' || '&' || 'nbsp;';
1549: document := document || '' || '&' || 'nbsp;';
1550: document := document || '' ||td_text|| l_message || '';
Line 1627: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');

1623: l_debugInfo := 'Generate header';
1624: if (display_type = 'text/plain') then
1625: l_document := '';
1626: else -- html
1627: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');
1628: l_detail_header_prompt := FND_MESSAGE.GET;
1629:
1630: l_document := indent_start||table_title_start|| l_detail_header_prompt||table_title_end;
1631:

Line 1628: l_detail_header_prompt := FND_MESSAGE.GET;

1624: if (display_type = 'text/plain') then
1625: l_document := '';
1626: else -- html
1627: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');
1628: l_detail_header_prompt := FND_MESSAGE.GET;
1629:
1630: l_document := indent_start||table_title_start|| l_detail_header_prompt||table_title_end;
1631:
1632: l_document := l_document||table_start;

Line 1791: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');

1787: l_colon := instr(document, '',-1);
1788: document := substr(document,1,l_colon+4);
1789: document := document || '

';
1790:
1791: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
1792: l_message := FND_MESSAGE.GET;
1793: document := document || '';
1794: document := document || '' || '&' || 'nbsp;';
1795: document := document || '' || '&' || 'nbsp;';
Line 1792: l_message := FND_MESSAGE.GET;

1788: document := substr(document,1,l_colon+4);
1789: document := document || '

';
1790:
1791: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
1792: l_message := FND_MESSAGE.GET;
1793: document := document || '';
1794: document := document || '' || '&' || 'nbsp;';
1795: document := document || '' || '&' || 'nbsp;';
1796: document := document || '' ||td_text|| l_message || '';
Line 1918: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');

1914: if (display_type = 'text/plain') then
1915: l_document := '';
1916: else -- html
1917: --Notification Esc : SET HEADER
1918: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');
1919: l_detail_header_prompt := FND_MESSAGE.GET;
1920:
1921: l_document := indent_start||table_title_start || l_detail_header_prompt || table_title_end;
1922:

Line 1919: l_detail_header_prompt := FND_MESSAGE.GET;

1915: l_document := '';
1916: else -- html
1917: --Notification Esc : SET HEADER
1918: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');
1919: l_detail_header_prompt := FND_MESSAGE.GET;
1920:
1921: l_document := indent_start||table_title_start || l_detail_header_prompt || table_title_end;
1922:
1923: l_document := l_document||table_start;

Line 2064: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');

2060: IF l_total_dispute > 0 THEN --Bug 3326035
2061: if (display_type = 'text/plain') then
2062: l_document := '';
2063: else -- html
2064: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');
2065: l_dispute_header_prompt := FND_MESSAGE.GET;
2066: l_document := indent_start||table_title_start|| l_dispute_header_prompt ||table_title_end;
2067: l_document := l_document|| table_start;
2068: l_document := l_document|| tr_start;

Line 2065: l_dispute_header_prompt := FND_MESSAGE.GET;

2061: if (display_type = 'text/plain') then
2062: l_document := '';
2063: else -- html
2064: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');
2065: l_dispute_header_prompt := FND_MESSAGE.GET;
2066: l_document := indent_start||table_title_start|| l_dispute_header_prompt ||table_title_end;
2067: l_document := l_document|| table_start;
2068: l_document := l_document|| tr_start;
2069:

Line 2275: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');

2271:
2272: EXIT WHEN l_Total_cursor%NOTFOUND;
2273: END LOOP;
2274: if(l_Total_cursor%ROWCOUNT>= 40) then
2275: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2276: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2277: l_instructions := FND_MESSAGE.GET;
2278: document := document || '

';
2279: document := document || '' || '&' || 'nbsp;';
Line 2276: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);

2272: EXIT WHEN l_Total_cursor%NOTFOUND;
2273: END LOOP;
2274: if(l_Total_cursor%ROWCOUNT>= 40) then
2275: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2276: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2277: l_instructions := FND_MESSAGE.GET;
2278: document := document || '

';
2279: document := document || '' || '&' || 'nbsp;';
2280: document := document || '' || '&' || 'nbsp;';
Line 2277: l_instructions := FND_MESSAGE.GET;

2273: END LOOP;
2274: if(l_Total_cursor%ROWCOUNT>= 40) then
2275: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2276: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2277: l_instructions := FND_MESSAGE.GET;
2278: document := document || '

';
2279: document := document || '' || '&' || 'nbsp;';
2280: document := document || '' || '&' || 'nbsp;';
2281: document := document || '' ||td_text|| l_instructions || '';
Line 2396: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');

2392:
2393: EXIT WHEN l_Total_cursor%NOTFOUND;
2394: END LOOP;
2395: if(l_Total_cursor%ROWCOUNT>= 40) then
2396: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2398: l_instructions := FND_MESSAGE.GET;
2399: document := document || '

';
2400: document := document || '' || '&' || 'nbsp;';
Line 2397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);

2393: EXIT WHEN l_Total_cursor%NOTFOUND;
2394: END LOOP;
2395: if(l_Total_cursor%ROWCOUNT>= 40) then
2396: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2398: l_instructions := FND_MESSAGE.GET;
2399: document := document || '

';
2400: document := document || '' || '&' || 'nbsp;';
2401: document := document || '' || '&' || 'nbsp;';
Line 2398: l_instructions := FND_MESSAGE.GET;

2394: END LOOP;
2395: if(l_Total_cursor%ROWCOUNT>= 40) then
2396: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2397: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2398: l_instructions := FND_MESSAGE.GET;
2399: document := document || '

';
2400: document := document || '' || '&' || 'nbsp;';
2401: document := document || '' || '&' || 'nbsp;';
2402: document := document || '' ||td_text|| l_instructions || '';
Line 2523: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_OUTSTANDING_MSG');

2519: if (display_type = 'text/plain') then
2520: l_document := '';
2521: else -- html
2522:
2523: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_OUTSTANDING_MSG');
2524: l_detail_header_prompt := FND_MESSAGE.GET;
2525:
2526: l_document := indent_start||table_title_start || l_detail_header_prompt ||table_title_end;
2527:

Line 2524: l_detail_header_prompt := FND_MESSAGE.GET;

2520: l_document := '';
2521: else -- html
2522:
2523: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_OUTSTANDING_MSG');
2524: l_detail_header_prompt := FND_MESSAGE.GET;
2525:
2526: l_document := indent_start||table_title_start || l_detail_header_prompt ||table_title_end;
2527:
2528: l_document := l_document || table_start||tr_start;

Line 2789: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_BY_EMPLOYEE'); --Direct Reports

2785: if (display_type = 'text/plain') then
2786: l_document := '';
2787: else -- html
2788:
2789: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_BY_EMPLOYEE'); --Direct Reports
2790: l_detail_header_prompt := FND_MESSAGE.GET;
2791:
2792: l_document := indent_start||table_title_start || l_detail_header_prompt || table_title_end;
2793:

Line 2790: l_detail_header_prompt := FND_MESSAGE.GET;

2786: l_document := '';
2787: else -- html
2788:
2789: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_BY_EMPLOYEE'); --Direct Reports
2790: l_detail_header_prompt := FND_MESSAGE.GET;
2791:
2792: l_document := indent_start||table_title_start || l_detail_header_prompt || table_title_end;
2793:
2794: l_document := l_document||table_start;

Line 3186: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

3182: WHEN OTHERS THEN
3183: BEGIN
3184: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GetHierarchialEmployeeCursor Exception p_supervisor_id='||to_char(p_supervisor_id));
3185:
3186: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3189: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3190: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');

Line 3187: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

3183: BEGIN
3184: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GetHierarchialEmployeeCursor Exception p_supervisor_id='||to_char(p_supervisor_id));
3185:
3186: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3189: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3190: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3191: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);

Line 3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');

3184: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GetHierarchialEmployeeCursor Exception p_supervisor_id='||to_char(p_supervisor_id));
3185:
3186: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3189: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3190: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3191: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3192: END;

Line 3189: FND_MESSAGE.SET_TOKEN('PARAMETERS','');

3185:
3186: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3189: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3190: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3191: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3192: END;
3193: END GetHierarchialEmployeeCursor;

Line 3190: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');

3186: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3189: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3190: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3191: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3192: END;
3193: END GetHierarchialEmployeeCursor;
3194: -----------------------------------------------

Line 3191: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);

3187: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3189: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3190: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3191: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3192: END;
3193: END GetHierarchialEmployeeCursor;
3194: -----------------------------------------------
3195: