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 294: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: IF (SQLCODE <> -20001) THEN
294: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
295: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
296: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendPaymentNotification');
297: FND_MESSAGE.SET_TOKEN('PARAMETERS',
298: 'p_checkNumber = ' || to_char(p_checkNumber) ||

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

291: EXCEPTION
292: WHEN OTHERS THEN
293: IF (SQLCODE <> -20001) THEN
294: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
295: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
296: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendPaymentNotification');
297: FND_MESSAGE.SET_TOKEN('PARAMETERS',
298: 'p_checkNumber = ' || to_char(p_checkNumber) ||
299: ', p_employeeId = '|| to_char(p_employeeId) ||

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

292: WHEN OTHERS THEN
293: IF (SQLCODE <> -20001) THEN
294: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
295: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
296: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendPaymentNotification');
297: FND_MESSAGE.SET_TOKEN('PARAMETERS',
298: 'p_checkNumber = ' || to_char(p_checkNumber) ||
299: ', p_employeeId = '|| to_char(p_employeeId) ||
300: ', p_paymentCurrency = ' || p_paymentCurrency ||

Line 297: FND_MESSAGE.SET_TOKEN('PARAMETERS',

293: IF (SQLCODE <> -20001) THEN
294: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
295: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
296: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendPaymentNotification');
297: FND_MESSAGE.SET_TOKEN('PARAMETERS',
298: 'p_checkNumber = ' || to_char(p_checkNumber) ||
299: ', p_employeeId = '|| to_char(p_employeeId) ||
300: ', p_paymentCurrency = ' || p_paymentCurrency ||
301: ', p_invoiceNumber = ' || p_invoiceNumber ||

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

304: ', p_account = ' || l_account ||
305: ', p_bankName = ' || p_bankName ||
306: ', p_cardIssuer = ' || p_cardIssuer ||
307: ', p_paymentDate = ' || p_paymentDate);
308: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
309: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
310: ELSE
311: -- Do not need to set the token since it has been done in the
312: -- child process

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

305: ', p_bankName = ' || p_bankName ||
306: ', p_cardIssuer = ' || p_cardIssuer ||
307: ', p_paymentDate = ' || p_paymentDate);
308: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
309: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
310: ELSE
311: -- Do not need to set the token since it has been done in the
312: -- child process
313: RAISE;

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

462: ------------------------------------------------------
463: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications); -- Bug 6026927
464:
465:
466: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
467: l_instructions := FND_MESSAGE.GET;
468:
469: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
470: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);

Line 467: l_instructions := FND_MESSAGE.GET;

463: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications); -- Bug 6026927
464:
465:
466: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
467: l_instructions := FND_MESSAGE.GET;
468:
469: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
470: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
471: l_mgr_instructions := FND_MESSAGE.GET;

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

465:
466: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
467: l_instructions := FND_MESSAGE.GET;
468:
469: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
470: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
471: l_mgr_instructions := FND_MESSAGE.GET;
472:
473: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);

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

466: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
467: l_instructions := FND_MESSAGE.GET;
468:
469: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
470: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
471: l_mgr_instructions := FND_MESSAGE.GET;
472:
473: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);
474: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);

Line 471: l_mgr_instructions := FND_MESSAGE.GET;

467: l_instructions := FND_MESSAGE.GET;
468:
469: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
470: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
471: l_mgr_instructions := FND_MESSAGE.GET;
472:
473: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);
474: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);
475:

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

515:
516: EXCEPTION
517: WHEN OTHERS THEN
518: IF (SQLCODE <> -20001) THEN
519: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
520: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
521: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnsubmittedChargesNote');
522: FND_MESSAGE.SET_TOKEN('PARAMETERS',
523: 'p_employeeId = ' || to_char(p_employeeId) ||

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

516: EXCEPTION
517: WHEN OTHERS THEN
518: IF (SQLCODE <> -20001) THEN
519: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
520: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
521: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnsubmittedChargesNote');
522: FND_MESSAGE.SET_TOKEN('PARAMETERS',
523: 'p_employeeId = ' || to_char(p_employeeId) ||
524: ', p_Amount = ' || to_char(p_Amount) ||

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

517: WHEN OTHERS THEN
518: IF (SQLCODE <> -20001) THEN
519: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
520: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
521: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnsubmittedChargesNote');
522: FND_MESSAGE.SET_TOKEN('PARAMETERS',
523: 'p_employeeId = ' || to_char(p_employeeId) ||
524: ', p_Amount = ' || to_char(p_Amount) ||
525: ', p_currency = ' || p_currency ||

Line 522: FND_MESSAGE.SET_TOKEN('PARAMETERS',

518: IF (SQLCODE <> -20001) THEN
519: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
520: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
521: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnsubmittedChargesNote');
522: FND_MESSAGE.SET_TOKEN('PARAMETERS',
523: 'p_employeeId = ' || to_char(p_employeeId) ||
524: ', p_Amount = ' || to_char(p_Amount) ||
525: ', p_currency = ' || p_currency ||
526: ', p_cardIssuer = ' || p_cardIssuer ||

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

525: ', p_currency = ' || p_currency ||
526: ', p_cardIssuer = ' || p_cardIssuer ||
527: ', p_date1 = ' || p_date1 ||
528: ', p_date2 = ' || p_date2);
529: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
530: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
531: ELSE
532: -- Do not need to set the token since it has been done in the
533: -- child process

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

526: ', p_cardIssuer = ' || p_cardIssuer ||
527: ', p_date1 = ' || p_date1 ||
528: ', p_date2 = ' || p_date2);
529: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
530: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
531: ELSE
532: -- Do not need to set the token since it has been done in the
533: -- child process
534: RAISE;

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

689: ----------------------------------------------------------
690: l_debugInfo := 'Set the Subject';
691: ----------------------------------------------------------
692: if(p_dunning_number = 1) then
693: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
694: l_instructions := FND_MESSAGE.GET;
695: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
696: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
697: l_mgr_instructions := FND_MESSAGE.GET;

Line 694: l_instructions := FND_MESSAGE.GET;

690: l_debugInfo := 'Set the Subject';
691: ----------------------------------------------------------
692: if(p_dunning_number = 1) then
693: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
694: l_instructions := FND_MESSAGE.GET;
695: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
696: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
697: l_mgr_instructions := FND_MESSAGE.GET;
698:

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

691: ----------------------------------------------------------
692: if(p_dunning_number = 1) then
693: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
694: l_instructions := FND_MESSAGE.GET;
695: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
696: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
697: l_mgr_instructions := FND_MESSAGE.GET;
698:
699:

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

692: if(p_dunning_number = 1) then
693: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
694: l_instructions := FND_MESSAGE.GET;
695: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
696: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
697: l_mgr_instructions := FND_MESSAGE.GET;
698:
699:
700: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING1');

Line 697: l_mgr_instructions := FND_MESSAGE.GET;

693: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
694: l_instructions := FND_MESSAGE.GET;
695: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
696: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
697: l_mgr_instructions := FND_MESSAGE.GET;
698:
699:
700: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING1');
701: l_mgr_esc_instructions := FND_MESSAGE.GET;

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

696: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
697: l_mgr_instructions := FND_MESSAGE.GET;
698:
699:
700: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING1');
701: l_mgr_esc_instructions := FND_MESSAGE.GET;
702:
703:
704: elsif(p_dunning_number = 2) then

Line 701: l_mgr_esc_instructions := FND_MESSAGE.GET;

697: l_mgr_instructions := FND_MESSAGE.GET;
698:
699:
700: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING1');
701: l_mgr_esc_instructions := FND_MESSAGE.GET;
702:
703:
704: elsif(p_dunning_number = 2) then
705: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');

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

701: l_mgr_esc_instructions := FND_MESSAGE.GET;
702:
703:
704: elsif(p_dunning_number = 2) then
705: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
706: l_instructions := FND_MESSAGE.GET;
707: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
708: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
709: l_mgr_instructions := FND_MESSAGE.GET;

Line 706: l_instructions := FND_MESSAGE.GET;

702:
703:
704: elsif(p_dunning_number = 2) then
705: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
706: l_instructions := FND_MESSAGE.GET;
707: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
708: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
709: l_mgr_instructions := FND_MESSAGE.GET;
710:

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

703:
704: elsif(p_dunning_number = 2) then
705: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
706: l_instructions := FND_MESSAGE.GET;
707: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
708: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
709: l_mgr_instructions := FND_MESSAGE.GET;
710:
711:

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

704: elsif(p_dunning_number = 2) then
705: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
706: l_instructions := FND_MESSAGE.GET;
707: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
708: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
709: l_mgr_instructions := FND_MESSAGE.GET;
710:
711:
712: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');

Line 709: l_mgr_instructions := FND_MESSAGE.GET;

705: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SECOND_DUNNING');
706: l_instructions := FND_MESSAGE.GET;
707: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_SECOND_INSTR');
708: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
709: l_mgr_instructions := FND_MESSAGE.GET;
710:
711:
712: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');
713: l_mgr_esc_instructions := FND_MESSAGE.GET;

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

708: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
709: l_mgr_instructions := FND_MESSAGE.GET;
710:
711:
712: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');
713: l_mgr_esc_instructions := FND_MESSAGE.GET;
714:
715: elsif(p_dunning_number = 3) then
716: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');

Line 713: l_mgr_esc_instructions := FND_MESSAGE.GET;

709: l_mgr_instructions := FND_MESSAGE.GET;
710:
711:
712: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');
713: l_mgr_esc_instructions := FND_MESSAGE.GET;
714:
715: elsif(p_dunning_number = 3) then
716: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
717: l_instructions := FND_MESSAGE.GET;

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

712: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING2');
713: l_mgr_esc_instructions := FND_MESSAGE.GET;
714:
715: elsif(p_dunning_number = 3) then
716: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
717: l_instructions := FND_MESSAGE.GET;
718: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
719: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
720: l_mgr_instructions := FND_MESSAGE.GET;

Line 717: l_instructions := FND_MESSAGE.GET;

713: l_mgr_esc_instructions := FND_MESSAGE.GET;
714:
715: elsif(p_dunning_number = 3) then
716: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
717: l_instructions := FND_MESSAGE.GET;
718: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
719: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
720: l_mgr_instructions := FND_MESSAGE.GET;
721:

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

714:
715: elsif(p_dunning_number = 3) then
716: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
717: l_instructions := FND_MESSAGE.GET;
718: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
719: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
720: l_mgr_instructions := FND_MESSAGE.GET;
721:
722:

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

715: elsif(p_dunning_number = 3) then
716: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
717: l_instructions := FND_MESSAGE.GET;
718: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
719: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
720: l_mgr_instructions := FND_MESSAGE.GET;
721:
722:
723: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');

Line 720: l_mgr_instructions := FND_MESSAGE.GET;

716: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_THIRD_DUNNING');
717: l_instructions := FND_MESSAGE.GET;
718: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_THIRD_INSTR');
719: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
720: l_mgr_instructions := FND_MESSAGE.GET;
721:
722:
723: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');
724: l_mgr_esc_instructions := FND_MESSAGE.GET;

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

719: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
720: l_mgr_instructions := FND_MESSAGE.GET;
721:
722:
723: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');
724: l_mgr_esc_instructions := FND_MESSAGE.GET;
725:
726: elsif(p_dunning_number = 4) then
727: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');

Line 724: l_mgr_esc_instructions := FND_MESSAGE.GET;

720: l_mgr_instructions := FND_MESSAGE.GET;
721:
722:
723: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');
724: l_mgr_esc_instructions := FND_MESSAGE.GET;
725:
726: elsif(p_dunning_number = 4) then
727: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
728: l_instructions := FND_MESSAGE.GET;

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

723: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING3');
724: l_mgr_esc_instructions := FND_MESSAGE.GET;
725:
726: elsif(p_dunning_number = 4) then
727: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
728: l_instructions := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
730: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
731: l_mgr_instructions := FND_MESSAGE.GET;

Line 728: l_instructions := FND_MESSAGE.GET;

724: l_mgr_esc_instructions := FND_MESSAGE.GET;
725:
726: elsif(p_dunning_number = 4) then
727: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
728: l_instructions := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
730: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
731: l_mgr_instructions := FND_MESSAGE.GET;
732:

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

725:
726: elsif(p_dunning_number = 4) then
727: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
728: l_instructions := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
730: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
731: l_mgr_instructions := FND_MESSAGE.GET;
732:
733:

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

726: elsif(p_dunning_number = 4) then
727: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
728: l_instructions := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
730: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
731: l_mgr_instructions := FND_MESSAGE.GET;
732:
733:
734: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING4');

Line 731: l_mgr_instructions := FND_MESSAGE.GET;

727: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FOURTH_DUNNING');
728: l_instructions := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FOURTH_INSTR');
730: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
731: l_mgr_instructions := FND_MESSAGE.GET;
732:
733:
734: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING4');
735: l_mgr_esc_instructions := FND_MESSAGE.GET;

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

730: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
731: l_mgr_instructions := FND_MESSAGE.GET;
732:
733:
734: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING4');
735: l_mgr_esc_instructions := FND_MESSAGE.GET;
736:
737: end if;
738:

Line 735: l_mgr_esc_instructions := FND_MESSAGE.GET;

731: l_mgr_instructions := FND_MESSAGE.GET;
732:
733:
734: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_INSTR_DUNNING4');
735: l_mgr_esc_instructions := FND_MESSAGE.GET;
736:
737: end if;
738:
739: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);

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

747: ELSE
748: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'N');
749: END IF;
750:
751: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_ADD_INSTR');
752: l_mgr_esc_add_instructions := FND_MESSAGE.GET;
753:
754:
755: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_INSTR', l_mgr_esc_instructions);

Line 752: l_mgr_esc_add_instructions := FND_MESSAGE.GET;

748: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'N');
749: END IF;
750:
751: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_ADD_INSTR');
752: l_mgr_esc_add_instructions := FND_MESSAGE.GET;
753:
754:
755: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_INSTR', l_mgr_esc_instructions);
756: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_ADD_INSTR', l_mgr_esc_add_instructions);

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

755: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_INSTR', l_mgr_esc_instructions);
756: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
757:
758:
759: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_INSTR');
760: l_next_mgr_esc_instr := FND_MESSAGE.GET;
761: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_INSTR', l_next_mgr_esc_instr);
762:
763: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_ADD_INSTR', l_mgr_esc_add_instructions);

Line 760: l_next_mgr_esc_instr := FND_MESSAGE.GET;

756: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
757:
758:
759: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_INSTR');
760: l_next_mgr_esc_instr := FND_MESSAGE.GET;
761: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_INSTR', l_next_mgr_esc_instr);
762:
763: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
764:

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

764:
765:
766: --Amulya Mishra : Notification Esc Project
767:
768: FND_MESSAGE.SET_NAME('SQLAP','OIE_ADD_INFO_DUNNING');
769: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));
770: l_add_instructions := FND_MESSAGE.GET;
771: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
772:

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

765:
766: --Amulya Mishra : Notification Esc Project
767:
768: FND_MESSAGE.SET_NAME('SQLAP','OIE_ADD_INFO_DUNNING');
769: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));
770: l_add_instructions := FND_MESSAGE.GET;
771: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
772:
773: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');

Line 770: l_add_instructions := FND_MESSAGE.GET;

766: --Amulya Mishra : Notification Esc Project
767:
768: FND_MESSAGE.SET_NAME('SQLAP','OIE_ADD_INFO_DUNNING');
769: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));
770: l_add_instructions := FND_MESSAGE.GET;
771: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
772:
773: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');
774: l_notes := FND_MESSAGE.GET;

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

769: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));
770: l_add_instructions := FND_MESSAGE.GET;
771: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
772:
773: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');
774: l_notes := FND_MESSAGE.GET;
775: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NOTES', l_notes);
776:
777: --determining SUP1 and SUP2

Line 774: l_notes := FND_MESSAGE.GET;

770: l_add_instructions := FND_MESSAGE.GET;
771: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
772:
773: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');
774: l_notes := FND_MESSAGE.GET;
775: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NOTES', l_notes);
776:
777: --determining SUP1 and SUP2
778:

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

841:
842: IF(p_dunning_number < 4 AND l_sup2_manager_display_name IS NOT NULL) THEN
843:
844:
845: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');
846: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
847: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
848: l_mgmt_instructions := FND_MESSAGE.GET;
849: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);

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

842: IF(p_dunning_number < 4 AND l_sup2_manager_display_name IS NOT NULL) THEN
843:
844:
845: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');
846: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
847: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
848: l_mgmt_instructions := FND_MESSAGE.GET;
849: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
850:

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

843:
844:
845: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');
846: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
847: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
848: l_mgmt_instructions := FND_MESSAGE.GET;
849: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
850:
851: IF (p_dunning_number = 1) THEN

Line 848: l_mgmt_instructions := FND_MESSAGE.GET;

844:
845: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');
846: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
847: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
848: l_mgmt_instructions := FND_MESSAGE.GET;
849: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
850:
851: IF (p_dunning_number = 1) THEN
852:

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

849: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
850:
851: IF (p_dunning_number = 1) THEN
852:
853: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING1');
854: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
855: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
856:
857: ELSE

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

850:
851: IF (p_dunning_number = 1) THEN
852:
853: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING1');
854: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
855: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
856:
857: ELSE
858:

Line 855: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;

851: IF (p_dunning_number = 1) THEN
852:
853: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING1');
854: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
855: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
856:
857: ELSE
858:
859: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');

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

855: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
856:
857: ELSE
858:
859: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');
860: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
861: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
862: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
863:

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

856:
857: ELSE
858:
859: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');
860: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
861: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
862: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
863:
864: END IF;

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

857: ELSE
858:
859: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');
860: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
861: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
862: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
863:
864: END IF;
865: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);

Line 862: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;

858:
859: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING');
860: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
861: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
862: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
863:
864: END IF;
865: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
866:

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

863:
864: END IF;
865: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
866:
867: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_NTF');
868: FND_MESSAGE.SET_TOKEN('SUP1', l_sup2_manager_display_name);
869: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
870: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
871:

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

864: END IF;
865: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
866:
867: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_NTF');
868: FND_MESSAGE.SET_TOKEN('SUP1', l_sup2_manager_display_name);
869: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
870: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
871:
872:

Line 869: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;

865: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
866:
867: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_NTF');
868: FND_MESSAGE.SET_TOKEN('SUP1', l_sup2_manager_display_name);
869: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
870: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
871:
872:
873: ELSIF (p_dunning_number = 4 OR l_sup2_manager_display_name IS NULL OR l_managerDisplayName = l_sup2_manager_display_name) THEN

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

871:
872:
873: ELSIF (p_dunning_number = 4 OR l_sup2_manager_display_name IS NULL OR l_managerDisplayName = l_sup2_manager_display_name) THEN
874:
875: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_LAST_MGR_NTF_DUNNING');
876: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
877: l_mgmt_instructions := FND_MESSAGE.GET;
878: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
879:

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

872:
873: ELSIF (p_dunning_number = 4 OR l_sup2_manager_display_name IS NULL OR l_managerDisplayName = l_sup2_manager_display_name) THEN
874:
875: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_LAST_MGR_NTF_DUNNING');
876: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
877: l_mgmt_instructions := FND_MESSAGE.GET;
878: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
879:
880: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');

Line 877: l_mgmt_instructions := FND_MESSAGE.GET;

873: ELSIF (p_dunning_number = 4 OR l_sup2_manager_display_name IS NULL OR l_managerDisplayName = l_sup2_manager_display_name) THEN
874:
875: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_LAST_MGR_NTF_DUNNING');
876: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
877: l_mgmt_instructions := FND_MESSAGE.GET;
878: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
879:
880: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
881: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);

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

876: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
877: l_mgmt_instructions := FND_MESSAGE.GET;
878: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
879:
880: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
881: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
882: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
883: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
884:

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

877: l_mgmt_instructions := FND_MESSAGE.GET;
878: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
879:
880: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
881: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
882: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
883: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
884:
885: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');

Line 882: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;

878: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
879:
880: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
881: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
882: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
883: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
884:
885: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');
886: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;

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

881: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
882: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
883: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
884:
885: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');
886: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
887: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
888:
889:

Line 886: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;

882: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
883: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
884:
885: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');
886: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
887: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
888:
889:
890: END IF;

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

1145: END;
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: IF (SQLCODE <> -20001) THEN
1149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1150: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1151: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SendDunningNotifications');
1152: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1153: ' p_employeeId = ' || to_char(p_employeeId) ||

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

1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: IF (SQLCODE <> -20001) THEN
1149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1150: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1151: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SendDunningNotifications');
1152: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1153: ' p_employeeId = ' || to_char(p_employeeId) ||
1154: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||

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

1147: WHEN OTHERS THEN
1148: IF (SQLCODE <> -20001) THEN
1149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1150: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1151: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SendDunningNotifications');
1152: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1153: ' p_employeeId = ' || to_char(p_employeeId) ||
1154: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1155: ', p_bucket1 = ' || to_char(p_min_bucket) ||

Line 1152: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1148: IF (SQLCODE <> -20001) THEN
1149: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1150: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1151: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'SendDunningNotifications');
1152: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1153: ' p_employeeId = ' || to_char(p_employeeId) ||
1154: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1155: ', p_bucket1 = ' || to_char(p_min_bucket) ||
1156: ', p_bucket2 = ' || to_char(p_max_bucket));

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

1153: ' p_employeeId = ' || to_char(p_employeeId) ||
1154: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1155: ', p_bucket1 = ' || to_char(p_min_bucket) ||
1156: ', p_bucket2 = ' || to_char(p_max_bucket));
1157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1158: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1159: ELSE
1160: -- Do not need to set the token since it has been done in the
1161: -- child process

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

1154: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1155: ', p_bucket1 = ' || to_char(p_min_bucket) ||
1156: ', p_bucket2 = ' || to_char(p_max_bucket));
1157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1158: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1159: ELSE
1160: -- Do not need to set the token since it has been done in the
1161: -- child process
1162: RAISE;

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

1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: IF (SQLCODE <> -20001) THEN
1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1268: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);

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

1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: IF (SQLCODE <> -20001) THEN
1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1268: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1270: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);

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

1263: WHEN OTHERS THEN
1264: IF (SQLCODE <> -20001) THEN
1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1268: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1270: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1271: ELSE

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

1264: IF (SQLCODE <> -20001) THEN
1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1268: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1270: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1271: ELSE
1272: -- Do not need to set the token since it has been done in the

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

1265: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1268: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1270: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1271: ELSE
1272: -- Do not need to set the token since it has been done in the
1273: -- child process

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

1266: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1267: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendUnapprovedExpReportNote');
1268: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_expenseReportId = ' || to_char(p_expenseReportId));
1269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1270: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1271: ELSE
1272: -- Do not need to set the token since it has been done in the
1273: -- child process
1274: RAISE;

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

1419:
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: IF (SQLCODE <> -20001) THEN
1423: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1424: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendDisputedChargesNote');
1426: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1427: ' p_employeeId = ' || to_char(p_employeeId) ||

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

1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: IF (SQLCODE <> -20001) THEN
1423: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1424: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendDisputedChargesNote');
1426: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1427: ' p_employeeId = ' || to_char(p_employeeId) ||
1428: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||

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

1421: WHEN OTHERS THEN
1422: IF (SQLCODE <> -20001) THEN
1423: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1424: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendDisputedChargesNote');
1426: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1427: ' p_employeeId = ' || to_char(p_employeeId) ||
1428: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1429: ', p_billedStartDate = ' || to_char(p_billedStartDate) ||

Line 1426: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1422: IF (SQLCODE <> -20001) THEN
1423: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1424: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1425: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'sendDisputedChargesNote');
1426: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1427: ' p_employeeId = ' || to_char(p_employeeId) ||
1428: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1429: ', p_billedStartDate = ' || to_char(p_billedStartDate) ||
1430: ', p_billedEndDate = ' || to_char(p_billedEndDate) ||

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

1428: ', p_cardProgramId = ' || to_char(p_cardProgramId) ||
1429: ', p_billedStartDate = ' || to_char(p_billedStartDate) ||
1430: ', p_billedEndDate = ' || to_char(p_billedEndDate) ||
1431: ', p_minimumAmount = ' || to_char(p_minimumAmount));
1432: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1433: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1434: ELSE
1435: -- Do not need to set the token since it has been done in the
1436: -- child process

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

1429: ', p_billedStartDate = ' || to_char(p_billedStartDate) ||
1430: ', p_billedEndDate = ' || to_char(p_billedEndDate) ||
1431: ', p_minimumAmount = ' || to_char(p_minimumAmount));
1432: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debugInfo);
1433: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
1434: ELSE
1435: -- Do not need to set the token since it has been done in the
1436: -- child process
1437: RAISE;

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

1500: l_debugInfo := 'Generate header';
1501: if (display_type = 'text/plain') then
1502: document := '';
1503: else -- html
1504: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');
1505: l_dispute_header_prompt := FND_MESSAGE.GET;
1506: document := indent_start||table_title_start|| l_dispute_header_prompt||table_title_end;
1507: document := document|| table_start;
1508: document := document|| tr_start;

Line 1505: l_dispute_header_prompt := FND_MESSAGE.GET;

1501: if (display_type = 'text/plain') then
1502: document := '';
1503: else -- html
1504: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');
1505: l_dispute_header_prompt := FND_MESSAGE.GET;
1506: document := indent_start||table_title_start|| l_dispute_header_prompt||table_title_end;
1507: document := document|| table_start;
1508: document := document|| tr_start;
1509:

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

1615: l_colon := instr(document, '',-1);
1616: document := substr(document,1,l_colon+4);
1617: document := document || '
';
1618:
1619: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
1620: l_message := FND_MESSAGE.GET;
1621: document := document || '';
1622: document := document || '' || '&' || 'nbsp;';
1623: document := document || '' || '&' || 'nbsp;';
Line 1620: l_message := FND_MESSAGE.GET;

1616: document := substr(document,1,l_colon+4);
1617: document := document || '

';
1618:
1619: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
1620: l_message := FND_MESSAGE.GET;
1621: document := document || '';
1622: document := document || '' || '&' || 'nbsp;';
1623: document := document || '' || '&' || 'nbsp;';
1624: document := document || '' ||td_text|| l_message || '';
Line 1701: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');

1697: l_debugInfo := 'Generate header';
1698: if (display_type = 'text/plain') then
1699: l_document := '';
1700: else -- html
1701: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');
1702: l_detail_header_prompt := FND_MESSAGE.GET;
1703:
1704: l_document := indent_start||table_title_start|| l_detail_header_prompt||table_title_end;
1705:

Line 1702: l_detail_header_prompt := FND_MESSAGE.GET;

1698: if (display_type = 'text/plain') then
1699: l_document := '';
1700: else -- html
1701: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');
1702: l_detail_header_prompt := FND_MESSAGE.GET;
1703:
1704: l_document := indent_start||table_title_start|| l_detail_header_prompt||table_title_end;
1705:
1706: l_document := l_document||table_start;

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

1861: l_colon := instr(document, '',-1);
1862: document := substr(document,1,l_colon+4);
1863: document := document || '

';
1864:
1865: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
1866: l_message := FND_MESSAGE.GET;
1867: document := document || '';
1868: document := document || '' || '&' || 'nbsp;';
1869: document := document || '' || '&' || 'nbsp;';
Line 1866: l_message := FND_MESSAGE.GET;

1862: document := substr(document,1,l_colon+4);
1863: document := document || '

';
1864:
1865: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
1866: l_message := FND_MESSAGE.GET;
1867: document := document || '';
1868: document := document || '' || '&' || 'nbsp;';
1869: document := document || '' || '&' || 'nbsp;';
1870: document := document || '' ||td_text|| l_message || '';
Line 1992: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');

1988: if (display_type = 'text/plain') then
1989: l_document := '';
1990: else -- html
1991: --Notification Esc : SET HEADER
1992: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');
1993: l_detail_header_prompt := FND_MESSAGE.GET;
1994:
1995: l_document := indent_start||table_title_start || l_detail_header_prompt || table_title_end;
1996:

Line 1993: l_detail_header_prompt := FND_MESSAGE.GET;

1989: l_document := '';
1990: else -- html
1991: --Notification Esc : SET HEADER
1992: FND_MESSAGE.SET_NAME('SQLAP','OIE_DETAIL_HEADER_DUNNING');
1993: l_detail_header_prompt := FND_MESSAGE.GET;
1994:
1995: l_document := indent_start||table_title_start || l_detail_header_prompt || table_title_end;
1996:
1997: l_document := l_document||table_start;

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

2134: IF l_total_dispute > 0 THEN --Bug 3326035
2135: if (display_type = 'text/plain') then
2136: l_document := '';
2137: else -- html
2138: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');
2139: l_dispute_header_prompt := FND_MESSAGE.GET;
2140: l_document := indent_start||table_title_start|| l_dispute_header_prompt ||table_title_end;
2141: l_document := l_document|| table_start;
2142: l_document := l_document|| tr_start;

Line 2139: l_dispute_header_prompt := FND_MESSAGE.GET;

2135: if (display_type = 'text/plain') then
2136: l_document := '';
2137: else -- html
2138: FND_MESSAGE.SET_NAME('SQLAP','OIE_DISPUTED_HEADER_DUNNING');
2139: l_dispute_header_prompt := FND_MESSAGE.GET;
2140: l_document := indent_start||table_title_start|| l_dispute_header_prompt ||table_title_end;
2141: l_document := l_document|| table_start;
2142: l_document := l_document|| tr_start;
2143:

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

2345:
2346: EXIT WHEN l_Total_cursor%NOTFOUND;
2347: END LOOP;
2348: if(l_Total_cursor%ROWCOUNT>= 40) then
2349: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2350: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2351: l_instructions := FND_MESSAGE.GET;
2352: document := document || '

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

2346: EXIT WHEN l_Total_cursor%NOTFOUND;
2347: END LOOP;
2348: if(l_Total_cursor%ROWCOUNT>= 40) then
2349: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2350: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2351: l_instructions := FND_MESSAGE.GET;
2352: document := document || '

';
2353: document := document || '' || '&' || 'nbsp;';
2354: document := document || '' || '&' || 'nbsp;';
Line 2351: l_instructions := FND_MESSAGE.GET;

2347: END LOOP;
2348: if(l_Total_cursor%ROWCOUNT>= 40) then
2349: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2350: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2351: l_instructions := FND_MESSAGE.GET;
2352: document := document || '

';
2353: document := document || '' || '&' || 'nbsp;';
2354: document := document || '' || '&' || 'nbsp;';
2355: document := document || '' ||td_text|| l_instructions || '';
Line 2470: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');

2466:
2467: EXIT WHEN l_Total_cursor%NOTFOUND;
2468: END LOOP;
2469: if(l_Total_cursor%ROWCOUNT>= 40) then
2470: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2471: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2472: l_instructions := FND_MESSAGE.GET;
2473: document := document || '

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

2467: EXIT WHEN l_Total_cursor%NOTFOUND;
2468: END LOOP;
2469: if(l_Total_cursor%ROWCOUNT>= 40) then
2470: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2471: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2472: l_instructions := FND_MESSAGE.GET;
2473: document := document || '

';
2474: document := document || '' || '&' || 'nbsp;';
2475: document := document || '' || '&' || 'nbsp;';
Line 2472: l_instructions := FND_MESSAGE.GET;

2468: END LOOP;
2469: if(l_Total_cursor%ROWCOUNT>= 40) then
2470: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NUM_RECORDS');
2471: FND_MESSAGE.SET_TOKEN('NUMBER_OF_TRANS', l_Total_cursor%ROWCOUNT);
2472: l_instructions := FND_MESSAGE.GET;
2473: document := document || '

';
2474: document := document || '' || '&' || 'nbsp;';
2475: document := document || '' || '&' || 'nbsp;';
2476: document := document || '' ||td_text|| l_instructions || '';
Line 2597: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_OUTSTANDING_MSG');

2593: if (display_type = 'text/plain') then
2594: l_document := '';
2595: else -- html
2596:
2597: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_OUTSTANDING_MSG');
2598: l_detail_header_prompt := FND_MESSAGE.GET;
2599:
2600: l_document := indent_start||table_title_start || l_detail_header_prompt ||table_title_end;
2601:

Line 2598: l_detail_header_prompt := FND_MESSAGE.GET;

2594: l_document := '';
2595: else -- html
2596:
2597: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_OUTSTANDING_MSG');
2598: l_detail_header_prompt := FND_MESSAGE.GET;
2599:
2600: l_document := indent_start||table_title_start || l_detail_header_prompt ||table_title_end;
2601:
2602: l_document := l_document || table_start||tr_start;

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

2859: if (display_type = 'text/plain') then
2860: l_document := '';
2861: else -- html
2862:
2863: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_BY_EMPLOYEE'); --Direct Reports
2864: l_detail_header_prompt := FND_MESSAGE.GET;
2865:
2866: l_document := indent_start||table_title_start || l_detail_header_prompt || table_title_end;
2867:

Line 2864: l_detail_header_prompt := FND_MESSAGE.GET;

2860: l_document := '';
2861: else -- html
2862:
2863: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_SUMMARY_BY_EMPLOYEE'); --Direct Reports
2864: l_detail_header_prompt := FND_MESSAGE.GET;
2865:
2866: l_document := indent_start||table_title_start || l_detail_header_prompt || table_title_end;
2867:
2868: l_document := l_document||table_start;

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

3255: WHEN OTHERS THEN
3256: BEGIN
3257: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GetHierarchialEmployeeCursor Exception p_supervisor_id='||to_char(p_supervisor_id));
3258:
3259: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3260: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3261: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3262: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3263: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');

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

3256: BEGIN
3257: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GetHierarchialEmployeeCursor Exception p_supervisor_id='||to_char(p_supervisor_id));
3258:
3259: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3260: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3261: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3262: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3263: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3264: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);

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

3257: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GetHierarchialEmployeeCursor Exception p_supervisor_id='||to_char(p_supervisor_id));
3258:
3259: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3260: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3261: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3262: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3263: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3264: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3265: END;

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

3258:
3259: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3260: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3261: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3262: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3263: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3264: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3265: END;
3266: END GetHierarchialEmployeeCursor;

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

3259: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3260: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3261: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3262: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3263: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3264: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3265: END;
3266: END GetHierarchialEmployeeCursor;
3267: -----------------------------------------------

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

3260: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3261: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3262: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3263: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3264: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3265: END;
3266: END GetHierarchialEmployeeCursor;
3267: -----------------------------------------------
3268: