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_EXPENSE_WF dependencies on FND_MESSAGE

Line 465: FND_MESSAGE.SET_NAME('SQLAP','OIE_WITHDRAW_WARNING');

461: l_debug_info := 'Update Withdraw Message';
462: -------------------------------------------------
463: --ER 1552747 - withdraw expense report
464: if p_workflow_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW then
465: FND_MESSAGE.SET_NAME('SQLAP','OIE_WITHDRAW_WARNING');
466: l_mess := FND_MESSAGE.GET;
467: WF_ENGINE.SetItemAttrText(l_item_type,
468: l_item_key,
469: 'WITHDRAW_WARNING',

Line 466: l_mess := FND_MESSAGE.GET;

462: -------------------------------------------------
463: --ER 1552747 - withdraw expense report
464: if p_workflow_flag = AP_WEB_DB_EXPRPT_PKG.C_WORKFLOW_APPROVED_WITHDRAW then
465: FND_MESSAGE.SET_NAME('SQLAP','OIE_WITHDRAW_WARNING');
466: l_mess := FND_MESSAGE.GET;
467: WF_ENGINE.SetItemAttrText(l_item_type,
468: l_item_key,
469: 'WITHDRAW_WARNING',
470: l_mess);

Line 786: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VIOLATION_NOTE');

782: l_debug_info := 'Do NOT set EMP_VIOLATION_NOTE when policy profile is Approver Only';
783: ------------------------------------------------------------
784: IF (l_violation_count > 0) THEN
785: IF (l_policy_violation_value <> C_ALLOW_NO_WARNINGS) THEN
786: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VIOLATION_NOTE');
787: l_mess := FND_MESSAGE.GET;
788: iText := iText + 1;
789: l_textNameArr(iText) := 'EMP_VIOLATION_NOTE';
790: l_textValArr(iText) := l_mess;

Line 787: l_mess := FND_MESSAGE.GET;

783: ------------------------------------------------------------
784: IF (l_violation_count > 0) THEN
785: IF (l_policy_violation_value <> C_ALLOW_NO_WARNINGS) THEN
786: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VIOLATION_NOTE');
787: l_mess := FND_MESSAGE.GET;
788: iText := iText + 1;
789: l_textNameArr(iText) := 'EMP_VIOLATION_NOTE';
790: l_textValArr(iText) := l_mess;
791: END IF;

Line 793: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VIOLATION_NOTE');

789: l_textNameArr(iText) := 'EMP_VIOLATION_NOTE';
790: l_textValArr(iText) := l_mess;
791: END IF;
792:
793: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VIOLATION_NOTE');
794: l_mess := FND_MESSAGE.GET;
795: iText := iText + 1;
796: l_textNameArr(iText) := 'VIOLATION_NOTE';
797: l_textValArr(iText) := l_mess;

Line 794: l_mess := FND_MESSAGE.GET;

790: l_textValArr(iText) := l_mess;
791: END IF;
792:
793: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VIOLATION_NOTE');
794: l_mess := FND_MESSAGE.GET;
795: iText := iText + 1;
796: l_textNameArr(iText) := 'VIOLATION_NOTE';
797: l_textValArr(iText) := l_mess;
798:

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

903: COMMIT;
904:
905:
906: IF (SQLCODE <> -20001) THEN
907: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
908: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
909: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'StartExpenseReportProcess');
910: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
911: END IF;

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

904:
905:
906: IF (SQLCODE <> -20001) THEN
907: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
908: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
909: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'StartExpenseReportProcess');
910: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
911: END IF;
912:

Line 909: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'StartExpenseReportProcess');

905:
906: IF (SQLCODE <> -20001) THEN
907: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
908: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
909: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'StartExpenseReportProcess');
910: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
911: END IF;
912:
913: -- always raise exceptions regardless it from StartExpenseReportProcess

Line 910: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

906: IF (SQLCODE <> -20001) THEN
907: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
908: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
909: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'StartExpenseReportProcess');
910: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
911: END IF;
912:
913: -- always raise exceptions regardless it from StartExpenseReportProcess
914: -- or other callees

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

990:
991: EXCEPTION
992: WHEN OTHERS THEN
993: IF (SQLCODE <> -20001) THEN
994: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
995: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
996: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GenTableHeader');
997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
998: END IF;

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

991: EXCEPTION
992: WHEN OTHERS THEN
993: IF (SQLCODE <> -20001) THEN
994: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
995: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
996: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GenTableHeader');
997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
998: END IF;
999: APP_EXCEPTION.RAISE_EXCEPTION;

Line 996: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GenTableHeader');

992: WHEN OTHERS THEN
993: IF (SQLCODE <> -20001) THEN
994: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
995: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
996: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GenTableHeader');
997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
998: END IF;
999: APP_EXCEPTION.RAISE_EXCEPTION;
1000:

Line 997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

993: IF (SQLCODE <> -20001) THEN
994: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
995: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
996: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GenTableHeader');
997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
998: END IF;
999: APP_EXCEPTION.RAISE_EXCEPTION;
1000:
1001: END GenTableHeader;

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

1145:
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', 'GenTableRows');
1152: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1153: END IF;

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', 'GenTableRows');
1152: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1153: END IF;
1154: APP_EXCEPTION.RAISE_EXCEPTION;

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

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', 'GenTableRows');
1152: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1153: END IF;
1154: APP_EXCEPTION.RAISE_EXCEPTION;
1155:

Line 1152: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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', 'GenTableRows');
1152: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1153: END IF;
1154: APP_EXCEPTION.RAISE_EXCEPTION;
1155:
1156: END GenTableRows;

Line 1708: p_item_type, p_item_key, to_char(0), l_debug_info || FND_MESSAGE.GET);

1704:
1705: EXCEPTION
1706: WHEN OTHERS THEN
1707: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'APValidateExpenseReport',
1708: p_item_type, p_item_key, to_char(0), l_debug_info || FND_MESSAGE.GET);
1709: raise;
1710: END APValidateExpenseReport;
1711:
1712: ------------------------------------------------------------------------

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

1725: end if;
1726: EXCEPTION
1727: WHEN OTHERS THEN
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToWFSSError');
1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_exceed_error_msg);
1733: END IF;

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

1726: EXCEPTION
1727: WHEN OTHERS THEN
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToWFSSError');
1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_exceed_error_msg);
1733: END IF;
1734: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToWFSSError');

1727: WHEN OTHERS THEN
1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToWFSSError');
1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_exceed_error_msg);
1733: END IF;
1734: APP_EXCEPTION.RAISE_EXCEPTION;
1735:

Line 1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_exceed_error_msg);

1728: IF (SQLCODE <> -20001) THEN
1729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToWFSSError');
1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_exceed_error_msg);
1733: END IF;
1734: APP_EXCEPTION.RAISE_EXCEPTION;
1735:
1736: END AddToWFSSError;

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

1783:
1784: EXCEPTION
1785: WHEN OTHERS THEN
1786: IF (SQLCODE <> -20001) THEN
1787: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToHeaderErrors');
1790: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1791: END IF;

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

1784: EXCEPTION
1785: WHEN OTHERS THEN
1786: IF (SQLCODE <> -20001) THEN
1787: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToHeaderErrors');
1790: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1791: END IF;
1792: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToHeaderErrors');

1785: WHEN OTHERS THEN
1786: IF (SQLCODE <> -20001) THEN
1787: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToHeaderErrors');
1790: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1791: END IF;
1792: APP_EXCEPTION.RAISE_EXCEPTION;
1793:

Line 1790: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1786: IF (SQLCODE <> -20001) THEN
1787: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToHeaderErrors');
1790: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1791: END IF;
1792: APP_EXCEPTION.RAISE_EXCEPTION;
1793:
1794: END AddToHeaderErrors;

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

1852:
1853: EXCEPTION
1854: WHEN OTHERS THEN
1855: IF (SQLCODE <> -20001) THEN
1856: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1857: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HandleInvalidDistCCID');
1859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1860: END IF;

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

1853: EXCEPTION
1854: WHEN OTHERS THEN
1855: IF (SQLCODE <> -20001) THEN
1856: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1857: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HandleInvalidDistCCID');
1859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1860: END IF;
1861: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HandleInvalidDistCCID');

1854: WHEN OTHERS THEN
1855: IF (SQLCODE <> -20001) THEN
1856: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1857: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HandleInvalidDistCCID');
1859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1860: END IF;
1861: APP_EXCEPTION.RAISE_EXCEPTION;
1862: END HandleInvalidDistCCID;

Line 1859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1855: IF (SQLCODE <> -20001) THEN
1856: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1857: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'HandleInvalidDistCCID');
1859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1860: END IF;
1861: APP_EXCEPTION.RAISE_EXCEPTION;
1862: END HandleInvalidDistCCID;
1863:

Line 2073: l_header_error_message := FND_MESSAGE.Get;

2069: p_concatenated_segments => l_concatenated_segments);
2070:
2071: exception
2072: when AP_WEB_OA_MAINFLOW_PKG.G_EXC_ERROR then
2073: l_header_error_message := FND_MESSAGE.Get;
2074: end;
2075:
2076: if (l_header_error_message is not null) then
2077:

Line 2134: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_PERSONAL_EXP_TYPE');

2130: ------------------------------------------------------------------------
2131: l_debug_info := 'calling AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID';
2132: ------------------------------------------------------------------------
2133: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
2134: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_PERSONAL_EXP_TYPE');
2135: AddToHeaderErrors(p_item_type,
2136: p_item_key,
2137: FND_MESSAGE.GET);
2138: l_header_error_occurred := true;

Line 2137: FND_MESSAGE.GET);

2133: IF (NOT AP_WEB_DB_EXPTEMPLATE_PKG.GetPersonalParamID(l_personalParameterId)) THEN
2134: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_PERSONAL_EXP_TYPE');
2135: AddToHeaderErrors(p_item_type,
2136: p_item_key,
2137: FND_MESSAGE.GET);
2138: l_header_error_occurred := true;
2139: END IF; /* GetPersonalParamID */
2140:
2141: END IF; /* C_CompanyPay */

Line 2270: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_ROUNDING_CCID');

2266: IF (l_rounding_error_ccid IS NULL) THEN
2267: --------------------------------------------
2268: l_debug_info := 'Rounding Error CCID is NULL';
2269: --------------------------------------------
2270: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_ROUNDING_CCID');
2271: l_other_error_message := FND_MESSAGE.GET;
2272: AddToOtherErrors(p_item_type,
2273: p_item_key,
2274: l_concatenated_segments||': '||l_other_error_message);

Line 2271: l_other_error_message := FND_MESSAGE.GET;

2267: --------------------------------------------
2268: l_debug_info := 'Rounding Error CCID is NULL';
2269: --------------------------------------------
2270: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_ROUNDING_CCID');
2271: l_other_error_message := FND_MESSAGE.GET;
2272: AddToOtherErrors(p_item_type,
2273: p_item_key,
2274: l_concatenated_segments||': '||l_other_error_message);
2275: l_other_error_occurred := true;

Line 2357: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_ROUNDING_CCID');

2353: --------------------------------------------
2354: l_debug_info := 'Rounding Error CCID is NULL';
2355: --------------------------------------------
2356: IF ( l_rounding_error_ccid IS NULL) THEN
2357: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_ROUNDING_CCID');
2358: l_other_error_message := FND_MESSAGE.GET;
2359: AddToOtherErrors(p_item_type,
2360: p_item_key,
2361: l_concatenated_segments||': '||l_other_error_message);

Line 2358: l_other_error_message := FND_MESSAGE.GET;

2354: l_debug_info := 'Rounding Error CCID is NULL';
2355: --------------------------------------------
2356: IF ( l_rounding_error_ccid IS NULL) THEN
2357: FND_MESSAGE.SET_NAME('SQLAP','OIE_NO_ROUNDING_CCID');
2358: l_other_error_message := FND_MESSAGE.GET;
2359: AddToOtherErrors(p_item_type,
2360: p_item_key,
2361: l_concatenated_segments||': '||l_other_error_message);
2362: l_other_error_occurred := true;

Line 2577: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_USER_EXCH_RATE_REQD');

2573: IF (NOT AP_WEB_DB_EXPRPT_PKG.SetDefaultExchRateType(p_report_header_id, l_sys_default_xrate_type)) THEN
2574: NULL;
2575: END IF; /* SetDefaultExchRateType */
2576:
2577: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_USER_EXCH_RATE_REQD');
2578: l_return_error_message := FND_MESSAGE.GET;
2579: AddToHeaderErrors(p_item_type,
2580: p_item_key,
2581: l_return_error_message);

Line 2578: l_return_error_message := FND_MESSAGE.GET;

2574: NULL;
2575: END IF; /* SetDefaultExchRateType */
2576:
2577: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_USER_EXCH_RATE_REQD');
2578: l_return_error_message := FND_MESSAGE.GET;
2579: AddToHeaderErrors(p_item_type,
2580: p_item_key,
2581: l_return_error_message);
2582: l_header_error_occurred := true;

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

2649:
2650: EXCEPTION
2651: WHEN OTHERS THEN
2652: IF (SQLCODE <> -20001) THEN
2653: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2654: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2655: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DoAPValidation');
2656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2657: END IF;

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

2650: EXCEPTION
2651: WHEN OTHERS THEN
2652: IF (SQLCODE <> -20001) THEN
2653: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2654: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2655: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DoAPValidation');
2656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2657: END IF;
2658: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2655: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DoAPValidation');

2651: WHEN OTHERS THEN
2652: IF (SQLCODE <> -20001) THEN
2653: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2654: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2655: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DoAPValidation');
2656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2657: END IF;
2658: APP_EXCEPTION.RAISE_EXCEPTION;
2659: END DoAPValidation;

Line 2656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

2652: IF (SQLCODE <> -20001) THEN
2653: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2654: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2655: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DoAPValidation');
2656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2657: END IF;
2658: APP_EXCEPTION.RAISE_EXCEPTION;
2659: END DoAPValidation;
2660:

Line 2712: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_NOTIF_LOGON_ERROR');

2708: select HOME_URL
2709: into l_url
2710: from ICX_PARAMETERS;
2711:
2712: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_NOTIF_LOGON_ERROR');
2713: FND_MESSAGE.SET_TOKEN('URL', l_url);
2714:
2715: htp.p('' || FND_MESSAGE.GET || '');
2716:

Line 2713: FND_MESSAGE.SET_TOKEN('URL', l_url);

2709: into l_url
2710: from ICX_PARAMETERS;
2711:
2712: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_NOTIF_LOGON_ERROR');
2713: FND_MESSAGE.SET_TOKEN('URL', l_url);
2714:
2715: htp.p('' || FND_MESSAGE.GET || '');
2716:
2717: END IF;

Line 2715: htp.p('' || FND_MESSAGE.GET || '');

2711:
2712: FND_MESSAGE.SET_NAME('SQLAP', 'AP_WEB_NOTIF_LOGON_ERROR');
2713: FND_MESSAGE.SET_TOKEN('URL', l_url);
2714:
2715: htp.p('' || FND_MESSAGE.GET || '');
2716:
2717: END IF;
2718:
2719: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end OpenExp');

Line 2777: fnd_message.set_name('SQLAP', 'OIE_WF_APPROVAL_POLICY_NOTE');

2773: */
2774:
2775: IF AP_WEB_DB_EXPLINE_PKG.GetShortpaidFlag(l_report_header_id, l_shortpaid_flag) THEN
2776: IF (l_shortpaid_flag = 'Y' ) THEN
2777: fnd_message.set_name('SQLAP', 'OIE_WF_APPROVAL_POLICY_NOTE');
2778: l_warning_msg := FND_MESSAGE.Get;
2779:
2780: WF_ENGINE.SetItemAttrText(
2781: p_item_type,

Line 2778: l_warning_msg := FND_MESSAGE.Get;

2774:
2775: IF AP_WEB_DB_EXPLINE_PKG.GetShortpaidFlag(l_report_header_id, l_shortpaid_flag) THEN
2776: IF (l_shortpaid_flag = 'Y' ) THEN
2777: fnd_message.set_name('SQLAP', 'OIE_WF_APPROVAL_POLICY_NOTE');
2778: l_warning_msg := FND_MESSAGE.Get;
2779:
2780: WF_ENGINE.SetItemAttrText(
2781: p_item_type,
2782: p_item_key,

Line 2791: fnd_message.set_name('SQLAP', 'AP_WEB_EXP_APRVL_RECPTS_MISSIN');

2787: END IF;
2788: END IF;
2789: /* jrautiai ADJ Fix end */
2790:
2791: fnd_message.set_name('SQLAP', 'AP_WEB_EXP_APRVL_RECPTS_MISSIN');
2792: l_warning_msg := FND_MESSAGE.Get;
2793:
2794: WF_ENGINE.SetItemAttrText(
2795: p_item_type,

Line 2792: l_warning_msg := FND_MESSAGE.Get;

2788: END IF;
2789: /* jrautiai ADJ Fix end */
2790:
2791: fnd_message.set_name('SQLAP', 'AP_WEB_EXP_APRVL_RECPTS_MISSIN');
2792: l_warning_msg := FND_MESSAGE.Get;
2793:
2794: WF_ENGINE.SetItemAttrText(
2795: p_item_type,
2796: p_item_key,

Line 2806: fnd_message.set_name('SQLAP', 'AP_WEB_EXP_APRVL_RULES_VIOLATE');

2802: END IF;
2803: END IF;
2804:
2805: IF (AP_WEB_DB_EXPLINE_PKG.AnyPolicyViolation(l_report_header_id)) THEN
2806: fnd_message.set_name('SQLAP', 'AP_WEB_EXP_APRVL_RULES_VIOLATE');
2807: l_warning_msg := FND_MESSAGE.Get;
2808:
2809: WF_ENGINE.SetItemAttrText(
2810: p_item_type,

Line 2807: l_warning_msg := FND_MESSAGE.Get;

2803: END IF;
2804:
2805: IF (AP_WEB_DB_EXPLINE_PKG.AnyPolicyViolation(l_report_header_id)) THEN
2806: fnd_message.set_name('SQLAP', 'AP_WEB_EXP_APRVL_RULES_VIOLATE');
2807: l_warning_msg := FND_MESSAGE.Get;
2808:
2809: WF_ENGINE.SetItemAttrText(
2810: p_item_type,
2811: p_item_key,

Line 2998: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VERIFY_MISSING_NOTE');

2994: p_item_key,
2995: 'MISSING_RECEIPT_TOTAL',
2996: l_sum_missing_display_total);
2997:
2998: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VERIFY_MISSING_NOTE');
2999: FND_MESSAGE.SET_TOKEN('MISSING_TOTAL',l_sum_missing_display_total);
3000:
3001: WF_ENGINE.SetItemAttrText(p_item_type,
3002: p_item_key,

Line 2999: FND_MESSAGE.SET_TOKEN('MISSING_TOTAL',l_sum_missing_display_total);

2995: 'MISSING_RECEIPT_TOTAL',
2996: l_sum_missing_display_total);
2997:
2998: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VERIFY_MISSING_NOTE');
2999: FND_MESSAGE.SET_TOKEN('MISSING_TOTAL',l_sum_missing_display_total);
3000:
3001: WF_ENGINE.SetItemAttrText(p_item_type,
3002: p_item_key,
3003: 'VERIFY_NOTE',

Line 3004: FND_MESSAGE.GET);

3000:
3001: WF_ENGINE.SetItemAttrText(p_item_type,
3002: p_item_key,
3003: 'VERIFY_NOTE',
3004: FND_MESSAGE.GET);
3005:
3006:
3007:
3008: p_result := 'COMPLETE:Y';

Line 3119: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_JUST_REQUIRED_MSG');

3115: ------------------------------------------------------------
3116: l_debug_info := 'Construction the Note';
3117: ------------------------------------------------------------
3118: IF (l_num_req_receipt > 0 ) THEN
3119: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_JUST_REQUIRED_MSG');
3120: END IF;
3121:
3122: IF (AP_WEB_DB_EXPLINE_PKG.AnyPolicyViolation(l_report_header_id)) THEN
3123: -- Bug# 13082536

Line 3125: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VIOLATION_MSG');

3121:
3122: IF (AP_WEB_DB_EXPLINE_PKG.AnyPolicyViolation(l_report_header_id)) THEN
3123: -- Bug# 13082536
3124: l_violation := 'Y';
3125: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VIOLATION_MSG');
3126: END IF;
3127:
3128: IF (l_num_req_receipt > 0 ) AND (l_violation = 'Y' ) THEN
3129: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_JUST_AND_VIOLATION_MSG');

Line 3129: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_JUST_AND_VIOLATION_MSG');

3125: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_VIOLATION_MSG');
3126: END IF;
3127:
3128: IF (l_num_req_receipt > 0 ) AND (l_violation = 'Y' ) THEN
3129: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_JUST_AND_VIOLATION_MSG');
3130: END IF;
3131:
3132:
3133: l_mess := FND_MESSAGE.GET;

Line 3133: l_mess := FND_MESSAGE.GET;

3129: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_JUST_AND_VIOLATION_MSG');
3130: END IF;
3131:
3132:
3133: l_mess := FND_MESSAGE.GET;
3134: WF_ENGINE.SetItemAttrText(p_item_type,
3135: p_item_key,
3136: 'REVIEW_NOTE',
3137: l_mess);

Line 3144: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_REVIEW_INSTRUCTION');

3140: l_debug_info := 'Construction the Instruction';
3141: ------------------------------------------------------------
3142: IF (l_num_req_receipt > 0 OR l_violation = 'Y' ) THEN
3143:
3144: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_REVIEW_INSTRUCTION');
3145: l_mess := FND_MESSAGE.GET;
3146:
3147: WF_ENGINE.SetItemAttrText(p_item_type,
3148: p_item_key,

Line 3145: l_mess := FND_MESSAGE.GET;

3141: ------------------------------------------------------------
3142: IF (l_num_req_receipt > 0 OR l_violation = 'Y' ) THEN
3143:
3144: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_REVIEW_INSTRUCTION');
3145: l_mess := FND_MESSAGE.GET;
3146:
3147: WF_ENGINE.SetItemAttrText(p_item_type,
3148: p_item_key,
3149: 'INSTRUCTION',

Line 3555: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST2');

3551: l_crd_card_count := 0;
3552: END IF;
3553:
3554: IF l_payment_due = C_BothPay AND nvl(l_crd_card_count,0) > 0 THEN
3555: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST2');
3556: l_mess := FND_MESSAGE.GET;
3557: ELSE
3558: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST1');
3559: l_mess := FND_MESSAGE.GET;

Line 3556: l_mess := FND_MESSAGE.GET;

3552: END IF;
3553:
3554: IF l_payment_due = C_BothPay AND nvl(l_crd_card_count,0) > 0 THEN
3555: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST2');
3556: l_mess := FND_MESSAGE.GET;
3557: ELSE
3558: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST1');
3559: l_mess := FND_MESSAGE.GET;
3560: END IF;

Line 3558: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST1');

3554: IF l_payment_due = C_BothPay AND nvl(l_crd_card_count,0) > 0 THEN
3555: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST2');
3556: l_mess := FND_MESSAGE.GET;
3557: ELSE
3558: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST1');
3559: l_mess := FND_MESSAGE.GET;
3560: END IF;
3561:
3562: WF_ENGINE.SetItemAttrText(p_item_type,

Line 3559: l_mess := FND_MESSAGE.GET;

3555: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST2');
3556: l_mess := FND_MESSAGE.GET;
3557: ELSE
3558: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJ_REIMBURSEMENT_INST1');
3559: l_mess := FND_MESSAGE.GET;
3560: END IF;
3561:
3562: WF_ENGINE.SetItemAttrText(p_item_type,
3563: p_item_key,

Line 3567: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJUSTMENT_NOTE');

3563: p_item_key,
3564: 'INSTRUCTION',
3565: l_mess);
3566:
3567: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJUSTMENT_NOTE');
3568: l_mess := FND_MESSAGE.GET;
3569:
3570: WF_ENGINE.SetItemAttrText(p_item_type,
3571: p_item_key,

Line 3568: l_mess := FND_MESSAGE.GET;

3564: 'INSTRUCTION',
3565: l_mess);
3566:
3567: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_ADJUSTMENT_NOTE');
3568: l_mess := FND_MESSAGE.GET;
3569:
3570: WF_ENGINE.SetItemAttrText(p_item_type,
3571: p_item_key,
3572: 'WF_NOTE',

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

4230:
4231: EXCEPTION
4232: WHEN OTHERS THEN
4233: IF (SQLCODE <> -20001) THEN
4234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MissingReceiptShortPay');
4237: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4238: END IF;

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

4231: EXCEPTION
4232: WHEN OTHERS THEN
4233: IF (SQLCODE <> -20001) THEN
4234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MissingReceiptShortPay');
4237: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4238: END IF;
4239: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MissingReceiptShortPay');

4232: WHEN OTHERS THEN
4233: IF (SQLCODE <> -20001) THEN
4234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MissingReceiptShortPay');
4237: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4238: END IF;
4239: APP_EXCEPTION.RAISE_EXCEPTION;
4240: END MissingReceiptShortPay;

Line 4237: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

4233: IF (SQLCODE <> -20001) THEN
4234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'MissingReceiptShortPay');
4237: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4238: END IF;
4239: APP_EXCEPTION.RAISE_EXCEPTION;
4240: END MissingReceiptShortPay;
4241:

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

4279:
4280: EXCEPTION
4281: WHEN OTHERS THEN
4282: IF (SQLCODE <> -20001) THEN
4283: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4284: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4285: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PolicyViolationShortPay');
4286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4287: END IF;

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

4280: EXCEPTION
4281: WHEN OTHERS THEN
4282: IF (SQLCODE <> -20001) THEN
4283: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4284: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4285: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PolicyViolationShortPay');
4286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4287: END IF;
4288: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4285: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PolicyViolationShortPay');

4281: WHEN OTHERS THEN
4282: IF (SQLCODE <> -20001) THEN
4283: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4284: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4285: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PolicyViolationShortPay');
4286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4287: END IF;
4288: APP_EXCEPTION.RAISE_EXCEPTION;
4289: END PolicyViolationShortPay;

Line 4286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

4282: IF (SQLCODE <> -20001) THEN
4283: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4284: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4285: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'PolicyViolationShortPay');
4286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4287: END IF;
4288: APP_EXCEPTION.RAISE_EXCEPTION;
4289: END PolicyViolationShortPay;
4290:

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

5032:
5033: EXCEPTION
5034: WHEN OTHERS THEN
5035: IF (SQLCODE <> -20001) THEN
5036: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5037: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5038: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DeleteExpReportFromAPTables');
5039: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5040: END IF;

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

5033: EXCEPTION
5034: WHEN OTHERS THEN
5035: IF (SQLCODE <> -20001) THEN
5036: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5037: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5038: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DeleteExpReportFromAPTables');
5039: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5040: END IF;
5041: APP_EXCEPTION.RAISE_EXCEPTION;

Line 5038: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DeleteExpReportFromAPTables');

5034: WHEN OTHERS THEN
5035: IF (SQLCODE <> -20001) THEN
5036: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5037: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5038: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DeleteExpReportFromAPTables');
5039: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5040: END IF;
5041: APP_EXCEPTION.RAISE_EXCEPTION;
5042: END DeleteExpReportFromAPTables;

Line 5039: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

5035: IF (SQLCODE <> -20001) THEN
5036: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5037: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5038: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'DeleteExpReportFromAPTables');
5039: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5040: END IF;
5041: APP_EXCEPTION.RAISE_EXCEPTION;
5042: END DeleteExpReportFromAPTables;
5043:

Line 6434: l_debug_info := 'Get the FND message for this missing vendor';

6430:
6431: IF ( (l_vendor_id IS NULL OR l_vendor_site_id IS NULL)
6432: AND nvl(l_crd_card_count,0) >0 ) THEN
6433: ----------------------------------------------------------------
6434: l_debug_info := 'Get the FND message for this missing vendor';
6435: ----------------------------------------------------------------
6436: FND_MESSAGE.Set_Name('SQLAP','AP_WEB_CCARD_NO_VENDOR_INFO');
6437:
6438: ----------------------------------------------------------------

Line 6436: FND_MESSAGE.Set_Name('SQLAP','AP_WEB_CCARD_NO_VENDOR_INFO');

6432: AND nvl(l_crd_card_count,0) >0 ) THEN
6433: ----------------------------------------------------------------
6434: l_debug_info := 'Get the FND message for this missing vendor';
6435: ----------------------------------------------------------------
6436: FND_MESSAGE.Set_Name('SQLAP','AP_WEB_CCARD_NO_VENDOR_INFO');
6437:
6438: ----------------------------------------------------------------
6439: l_debug_info := 'Set the Error Message Attribute';
6440: ----------------------------------------------------------------

Line 6444: FND_MESSAGE.Get);

6440: ----------------------------------------------------------------
6441: WF_ENGINE.SetItemAttrText(p_item_type,
6442: p_item_key,
6443: 'ERROR_MESSAGE',
6444: FND_MESSAGE.Get);
6445: p_result := 'COMPLETE:N';
6446: ELSE
6447: p_result := 'COMPLETE:Y';
6448: END IF;

Line 7041: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_POLICY_NC_NOTE');

7037: l_debug_info := 'Set #FROM_ROLE to AP';
7038: ----------------------------------------------------------------
7039: SetFromRoleAP(p_item_type, l_item_key, p_actid, p_funmode, p_result);
7040:
7041: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_POLICY_NC_NOTE');
7042:
7043: FND_MESSAGE.Set_Token('ORIG_REPORT_NUMBER', l_orig_expense_report_num);
7044: l_mess := FND_MESSAGE.GET;
7045:

Line 7043: FND_MESSAGE.Set_Token('ORIG_REPORT_NUMBER', l_orig_expense_report_num);

7039: SetFromRoleAP(p_item_type, l_item_key, p_actid, p_funmode, p_result);
7040:
7041: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_POLICY_NC_NOTE');
7042:
7043: FND_MESSAGE.Set_Token('ORIG_REPORT_NUMBER', l_orig_expense_report_num);
7044: l_mess := FND_MESSAGE.GET;
7045:
7046: ----------------------------------------------------------------
7047: l_debug_info := 'Set Policy Non-Compliance note';

Line 7044: l_mess := FND_MESSAGE.GET;

7040:
7041: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_POLICY_NC_NOTE');
7042:
7043: FND_MESSAGE.Set_Token('ORIG_REPORT_NUMBER', l_orig_expense_report_num);
7044: l_mess := FND_MESSAGE.GET;
7045:
7046: ----------------------------------------------------------------
7047: l_debug_info := 'Set Policy Non-Compliance note';
7048: ----------------------------------------------------------------

Line 7174: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_POLICY_MR_NOTE');

7170: l_total := WF_ENGINE.GetItemAttrNumber(p_item_type,
7171: p_item_key,
7172: 'NO_RECEIPTS_SHORTPAY_TOTAL');
7173:
7174: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_POLICY_MR_NOTE');
7175:
7176: FND_MESSAGE.Set_Token('ORIG_REPORT_NUMBER', l_orig_expense_report_num);
7177: l_mess := FND_MESSAGE.GET;
7178:

Line 7176: FND_MESSAGE.Set_Token('ORIG_REPORT_NUMBER', l_orig_expense_report_num);

7172: 'NO_RECEIPTS_SHORTPAY_TOTAL');
7173:
7174: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_POLICY_MR_NOTE');
7175:
7176: FND_MESSAGE.Set_Token('ORIG_REPORT_NUMBER', l_orig_expense_report_num);
7177: l_mess := FND_MESSAGE.GET;
7178:
7179: ELSIF (l_missing_receipt_type = 'IMAGE') THEN
7180:

Line 7177: l_mess := FND_MESSAGE.GET;

7173:
7174: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_POLICY_MR_NOTE');
7175:
7176: FND_MESSAGE.Set_Token('ORIG_REPORT_NUMBER', l_orig_expense_report_num);
7177: l_mess := FND_MESSAGE.GET;
7178:
7179: ELSIF (l_missing_receipt_type = 'IMAGE') THEN
7180:
7181: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 7196: FND_MESSAGE.SET_NAME('SQLAP','OIE_MISSING_RECPT_NOTIF_INSTR');

7192: l_total := WF_ENGINE.GetItemAttrNumber(p_item_type,
7193: p_item_key,
7194: 'NO_IMG_RECPT_SHORTPAY_TOTAL');
7195:
7196: FND_MESSAGE.SET_NAME('SQLAP','OIE_MISSING_RECPT_NOTIF_INSTR');
7197:
7198: FND_MESSAGE.Set_Token('RPT_ID', l_orig_expense_report_num);
7199: l_mess := FND_MESSAGE.GET;
7200:

Line 7198: FND_MESSAGE.Set_Token('RPT_ID', l_orig_expense_report_num);

7194: 'NO_IMG_RECPT_SHORTPAY_TOTAL');
7195:
7196: FND_MESSAGE.SET_NAME('SQLAP','OIE_MISSING_RECPT_NOTIF_INSTR');
7197:
7198: FND_MESSAGE.Set_Token('RPT_ID', l_orig_expense_report_num);
7199: l_mess := FND_MESSAGE.GET;
7200:
7201: ELSE
7202: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 7199: l_mess := FND_MESSAGE.GET;

7195:
7196: FND_MESSAGE.SET_NAME('SQLAP','OIE_MISSING_RECPT_NOTIF_INSTR');
7197:
7198: FND_MESSAGE.Set_Token('RPT_ID', l_orig_expense_report_num);
7199: l_mess := FND_MESSAGE.GET;
7200:
7201: ELSE
7202: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
7203: p_item_key,

Line 7217: FND_MESSAGE.SET_NAME('SQLAP','OIE_MISSING_RECPT_NOTIF_INSTR');

7213: l_total := WF_ENGINE.GetItemAttrNumber(p_item_type,
7214: p_item_key,
7215: 'NO_BOTH_RECPT_SHORTPAY_TOTAL');
7216:
7217: FND_MESSAGE.SET_NAME('SQLAP','OIE_MISSING_RECPT_NOTIF_INSTR');
7218:
7219: FND_MESSAGE.Set_Token('RPT_ID', l_orig_expense_report_num);
7220: l_mess := FND_MESSAGE.GET;
7221: END IF;

Line 7219: FND_MESSAGE.Set_Token('RPT_ID', l_orig_expense_report_num);

7215: 'NO_BOTH_RECPT_SHORTPAY_TOTAL');
7216:
7217: FND_MESSAGE.SET_NAME('SQLAP','OIE_MISSING_RECPT_NOTIF_INSTR');
7218:
7219: FND_MESSAGE.Set_Token('RPT_ID', l_orig_expense_report_num);
7220: l_mess := FND_MESSAGE.GET;
7221: END IF;
7222:
7223:

Line 7220: l_mess := FND_MESSAGE.GET;

7216:
7217: FND_MESSAGE.SET_NAME('SQLAP','OIE_MISSING_RECPT_NOTIF_INSTR');
7218:
7219: FND_MESSAGE.Set_Token('RPT_ID', l_orig_expense_report_num);
7220: l_mess := FND_MESSAGE.GET;
7221: END IF;
7222:
7223:
7224:

Line 8267: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');

8263: ---------------------------------------------
8264: l_debug_info := 'Loop in Approval Hierarchy';
8265: ---------------------------------------------
8266: -- 3257576
8267: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
8268: p_error_message := FND_MESSAGE.Get;
8269: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8270: p_instructions := FND_MESSAGE.Get;
8271: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

Line 8268: p_error_message := FND_MESSAGE.Get;

8264: l_debug_info := 'Loop in Approval Hierarchy';
8265: ---------------------------------------------
8266: -- 3257576
8267: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
8268: p_error_message := FND_MESSAGE.Get;
8269: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8270: p_instructions := FND_MESSAGE.Get;
8271: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8272: p_special_instr := FND_MESSAGE.Get;

Line 8269: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');

8265: ---------------------------------------------
8266: -- 3257576
8267: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
8268: p_error_message := FND_MESSAGE.Get;
8269: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8270: p_instructions := FND_MESSAGE.Get;
8271: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8272: p_special_instr := FND_MESSAGE.Get;
8273: return;

Line 8270: p_instructions := FND_MESSAGE.Get;

8266: -- 3257576
8267: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
8268: p_error_message := FND_MESSAGE.Get;
8269: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8270: p_instructions := FND_MESSAGE.Get;
8271: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8272: p_special_instr := FND_MESSAGE.Get;
8273: return;
8274: END IF;

Line 8271: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

8267: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
8268: p_error_message := FND_MESSAGE.Get;
8269: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8270: p_instructions := FND_MESSAGE.Get;
8271: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8272: p_special_instr := FND_MESSAGE.Get;
8273: return;
8274: END IF;
8275:

Line 8272: p_special_instr := FND_MESSAGE.Get;

8268: p_error_message := FND_MESSAGE.Get;
8269: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8270: p_instructions := FND_MESSAGE.Get;
8271: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8272: p_special_instr := FND_MESSAGE.Get;
8273: return;
8274: END IF;
8275:
8276: /*Bug 2492342 : Adding the manager to the table and checking whether

Line 8289: FND_MESSAGE.Set_Name('SQLAP', 'OIE_CIRCULAR_REF_APRVL_CHAIN');

8285: ---------------------------------------------
8286: l_debug_info := 'Loop in Approval Hierarchy';
8287: ---------------------------------------------
8288: -- 3257576
8289: FND_MESSAGE.Set_Name('SQLAP', 'OIE_CIRCULAR_REF_APRVL_CHAIN');
8290: p_error_message := FND_MESSAGE.Get;
8291: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8292: p_instructions := FND_MESSAGE.Get;
8293: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

Line 8290: p_error_message := FND_MESSAGE.Get;

8286: l_debug_info := 'Loop in Approval Hierarchy';
8287: ---------------------------------------------
8288: -- 3257576
8289: FND_MESSAGE.Set_Name('SQLAP', 'OIE_CIRCULAR_REF_APRVL_CHAIN');
8290: p_error_message := FND_MESSAGE.Get;
8291: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8292: p_instructions := FND_MESSAGE.Get;
8293: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8294: p_special_instr := FND_MESSAGE.Get;

Line 8291: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');

8287: ---------------------------------------------
8288: -- 3257576
8289: FND_MESSAGE.Set_Name('SQLAP', 'OIE_CIRCULAR_REF_APRVL_CHAIN');
8290: p_error_message := FND_MESSAGE.Get;
8291: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8292: p_instructions := FND_MESSAGE.Get;
8293: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8294: p_special_instr := FND_MESSAGE.Get;
8295: return;

Line 8292: p_instructions := FND_MESSAGE.Get;

8288: -- 3257576
8289: FND_MESSAGE.Set_Name('SQLAP', 'OIE_CIRCULAR_REF_APRVL_CHAIN');
8290: p_error_message := FND_MESSAGE.Get;
8291: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8292: p_instructions := FND_MESSAGE.Get;
8293: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8294: p_special_instr := FND_MESSAGE.Get;
8295: return;
8296: END IF;

Line 8293: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

8289: FND_MESSAGE.Set_Name('SQLAP', 'OIE_CIRCULAR_REF_APRVL_CHAIN');
8290: p_error_message := FND_MESSAGE.Get;
8291: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8292: p_instructions := FND_MESSAGE.Get;
8293: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8294: p_special_instr := FND_MESSAGE.Get;
8295: return;
8296: END IF;
8297:

Line 8294: p_special_instr := FND_MESSAGE.Get;

8290: p_error_message := FND_MESSAGE.Get;
8291: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
8292: p_instructions := FND_MESSAGE.Get;
8293: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
8294: p_special_instr := FND_MESSAGE.Get;
8295: return;
8296: END IF;
8297:
8298: END LOOP;

Line 9068: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_REASON_PROVIDED');

9064: 'WF_NOTE');
9065:
9066: IF (l_rejection_reason IS NULL OR
9067: replace(l_rejection_reason, ' ', '') = '') THEN
9068: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_REASON_PROVIDED');
9069: WF_ENGINE.SetItemAttrText(p_item_type,
9070: p_item_key,
9071: 'WF_NOTE',
9072: FND_MESSAGE.Get);

Line 9072: FND_MESSAGE.Get);

9068: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_REASON_PROVIDED');
9069: WF_ENGINE.SetItemAttrText(p_item_type,
9070: p_item_key,
9071: 'WF_NOTE',
9072: FND_MESSAGE.Get);
9073:
9074: END IF;
9075:
9076:

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

9461: l_colon := instr(document, tr_end,-1);
9462: document := substr(document,1,l_colon+4);
9463: document := document || table_end || indent_end;
9464:
9465: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
9466: l_message := FND_MESSAGE.GET;
9467: document := document || table_start;
9468: document := document || tr_start || '&' || 'nbsp;' || tr_end;
9469: document := document || tr_start || '&' || 'nbsp;' || tr_end;

Line 9466: l_message := FND_MESSAGE.GET;

9462: document := substr(document,1,l_colon+4);
9463: document := document || table_end || indent_end;
9464:
9465: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
9466: l_message := FND_MESSAGE.GET;
9467: document := document || table_start;
9468: document := document || tr_start || '&' || 'nbsp;' || tr_end;
9469: document := document || tr_start || '&' || 'nbsp;' || tr_end;
9470: document := document || tr_start || td_start || l_message || td_end || tr_end;

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

9724: l_colon := instr(document, '',-1);
9725: document := substr(document,1,l_colon+4);
9726: document := document || '
';
9727:
9728: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
9729: l_message := FND_MESSAGE.GET;
9730: document := document || '';
9731: document := document || ' ';
9732: document := document || ' ';
Line 9729: l_message := FND_MESSAGE.GET;

9725: document := substr(document,1,l_colon+4);
9726: document := document || '

';
9727:
9728: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
9729: l_message := FND_MESSAGE.GET;
9730: document := document || '';
9731: document := document || ' ';
9732: document := document || ' ';
9733: document := document || '';
Line 10806: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_PREPARER');

10802:
10803: --Bug 2742114:raise exception when preparer id and trasferee is same.
10804:
10805: IF l_preparer_id = l_TransferToID THEN
10806: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_PREPARER');
10807: app_exception.raise_exception;
10808:
10809: ELSIF ((l_preparer_id <> l_employee_id) and (l_employee_id = l_TransferToID)) THEN
10810: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_EMPLOYEE');

Line 10810: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_EMPLOYEE');

10806: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_PREPARER');
10807: app_exception.raise_exception;
10808:
10809: ELSIF ((l_preparer_id <> l_employee_id) and (l_employee_id = l_TransferToID)) THEN
10810: FND_MESSAGE.SET_NAME('SQLAP','OIE_TRANSFEREE_CANTBE_EMPLOYEE');
10811: app_exception.raise_exception;
10812: END IF;
10813:
10814:

Line 11905: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES

11901: fnd_global.set_nls_context(p_nls_language => l_new_language);
11902:
11903: begin
11904: -------------------------------------------------------------------
11905: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES
11906: -------------------------------------------------------------------
11907: select message_text
11908: into l_note
11909: from fnd_new_messages

Line 11916: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);

11912: and language_code = l_new_language_code;
11913:
11914: exception
11915: when no_data_found then
11916: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
11917: l_note := FND_MESSAGE.GET;
11918: end;
11919:
11920: ------------------------------------------------------------

Line 11917: l_note := FND_MESSAGE.GET;

11913:
11914: exception
11915: when no_data_found then
11916: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
11917: l_note := FND_MESSAGE.GET;
11918: end;
11919:
11920: ------------------------------------------------------------
11921: l_debug_info := 'store the withdrawn note';

Line 12232: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_REPORT_SHORTPAID');

12228:
12229: IF (l_payment = 'BOTH' and l_num_both_personal_lines > 0) THEN
12230: NULL;
12231: ELSE
12232: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_REPORT_SHORTPAID');
12233: WF_NOTIFICATION.WriteToClob(document,fnd_message.get);
12234: document_type := display_type;
12235: return;
12236: END IF;

Line 12233: WF_NOTIFICATION.WriteToClob(document,fnd_message.get);

12229: IF (l_payment = 'BOTH' and l_num_both_personal_lines > 0) THEN
12230: NULL;
12231: ELSE
12232: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_REPORT_SHORTPAID');
12233: WF_NOTIFICATION.WriteToClob(document,fnd_message.get);
12234: document_type := display_type;
12235: return;
12236: END IF;
12237: --Bug 2944363 End here.

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

12932: --------------------------------------------
12933: l_debug_info := 'Unable to show more lines';
12934: --------------------------------------------
12935: IF l_show_message = 'Y' THEN
12936: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
12937: FND_MESSAGE.SET_TOKEN('NO_OF_LINES',to_char(l_num_lines));
12938: l_message := FND_MESSAGE.GET;
12939: l_document := l_document || table_start;
12940: l_document := l_document || tr_start || '&' || 'nbsp;' || tr_end;

Line 12937: FND_MESSAGE.SET_TOKEN('NO_OF_LINES',to_char(l_num_lines));

12933: l_debug_info := 'Unable to show more lines';
12934: --------------------------------------------
12935: IF l_show_message = 'Y' THEN
12936: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
12937: FND_MESSAGE.SET_TOKEN('NO_OF_LINES',to_char(l_num_lines));
12938: l_message := FND_MESSAGE.GET;
12939: l_document := l_document || table_start;
12940: l_document := l_document || tr_start || '&' || 'nbsp;' || tr_end;
12941: l_document := l_document || tr_start || '&' || 'nbsp;' || tr_end;

Line 12938: l_message := FND_MESSAGE.GET;

12934: --------------------------------------------
12935: IF l_show_message = 'Y' THEN
12936: FND_MESSAGE.SET_NAME('SQLAP','AP_WEB_EXP_UNABLE_TO_SHOWLINES');
12937: FND_MESSAGE.SET_TOKEN('NO_OF_LINES',to_char(l_num_lines));
12938: l_message := FND_MESSAGE.GET;
12939: l_document := l_document || table_start;
12940: l_document := l_document || tr_start || '&' || 'nbsp;' || tr_end;
12941: l_document := l_document || tr_start || '&' || 'nbsp;' || tr_end;
12942: l_document := l_document || tr_start || td_start || l_message || td_end || tr_end;

Line 13008: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_MRATE_MODIFIED_NOTE');

13004: and changing the rate in the same report, the notes on the
13005: notification will only display the modified message. Only
13006: one notification will be send to the preparer and AP. */
13007: IF (l_modified_count > 0) THEN
13008: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_MRATE_MODIFIED_NOTE');
13009: ELSE
13010: SELECT count(*)
13011: INTO l_new_count
13012: FROM ap_expense_report_lines xl

Line 13018: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_MRATE_SPLIT_NOTE');

13014: AND (xl.mileage_rate_adjusted_flag = AP_WEB_DB_EXPLINE_PKG.C_New
13015: OR xl.mileage_rate_adjusted_flag = AP_WEB_DB_EXPLINE_PKG.C_Split);
13016:
13017: IF (l_new_count > 0 ) THEN
13018: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_MRATE_SPLIT_NOTE');
13019: END IF;
13020: END IF;
13021:
13022: l_mess := FND_MESSAGE.GET;

Line 13022: l_mess := FND_MESSAGE.GET;

13018: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_MRATE_SPLIT_NOTE');
13019: END IF;
13020: END IF;
13021:
13022: l_mess := FND_MESSAGE.GET;
13023:
13024: WF_ENGINE.SetItemAttrText(p_item_type,
13025: p_item_key,
13026: 'MILEAGE_NOTE',

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

14658:
14659: EXCEPTION
14660: WHEN OTHERS THEN
14661: IF (SQLCODE <> -20001) THEN
14662: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14664: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToOtherErrors');
14665: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14666: END IF;

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

14659: EXCEPTION
14660: WHEN OTHERS THEN
14661: IF (SQLCODE <> -20001) THEN
14662: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14664: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToOtherErrors');
14665: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14666: END IF;
14667: APP_EXCEPTION.RAISE_EXCEPTION;

Line 14664: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToOtherErrors');

14660: WHEN OTHERS THEN
14661: IF (SQLCODE <> -20001) THEN
14662: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14664: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToOtherErrors');
14665: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14666: END IF;
14667: APP_EXCEPTION.RAISE_EXCEPTION;
14668:

Line 14665: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

14661: IF (SQLCODE <> -20001) THEN
14662: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14663: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14664: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'AddToOtherErrors');
14665: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14666: END IF;
14667: APP_EXCEPTION.RAISE_EXCEPTION;
14668:
14669: END AddToOtherErrors;

Line 14866: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_PROVIDE_MISSING_NOTE');

14862: l_preparer_name := WF_ENGINE.GetItemAttrText(p_item_type,
14863: p_item_key,
14864: 'PREPARER_DISPLAY_NAME');
14865:
14866: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_PROVIDE_MISSING_NOTE');
14867: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', l_preparer_name);
14868: FND_MESSAGE.Set_Token('REPORT_NUMBER', l_document_number);
14869: l_mess := FND_MESSAGE.GET;
14870:

Line 14867: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', l_preparer_name);

14863: p_item_key,
14864: 'PREPARER_DISPLAY_NAME');
14865:
14866: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_PROVIDE_MISSING_NOTE');
14867: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', l_preparer_name);
14868: FND_MESSAGE.Set_Token('REPORT_NUMBER', l_document_number);
14869: l_mess := FND_MESSAGE.GET;
14870:
14871: WF_ENGINE.SetItemAttrText(p_item_type,

Line 14868: FND_MESSAGE.Set_Token('REPORT_NUMBER', l_document_number);

14864: 'PREPARER_DISPLAY_NAME');
14865:
14866: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_PROVIDE_MISSING_NOTE');
14867: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', l_preparer_name);
14868: FND_MESSAGE.Set_Token('REPORT_NUMBER', l_document_number);
14869: l_mess := FND_MESSAGE.GET;
14870:
14871: WF_ENGINE.SetItemAttrText(p_item_type,
14872: p_item_key,

Line 14869: l_mess := FND_MESSAGE.GET;

14865:
14866: FND_MESSAGE.SET_NAME('SQLAP','OIE_WF_PROVIDE_MISSING_NOTE');
14867: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', l_preparer_name);
14868: FND_MESSAGE.Set_Token('REPORT_NUMBER', l_document_number);
14869: l_mess := FND_MESSAGE.GET;
14870:
14871: WF_ENGINE.SetItemAttrText(p_item_type,
14872: p_item_key,
14873: 'OIENOTES',

Line 15392: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES

15388: end if;
15389:
15390: begin
15391: -------------------------------------------------------------------
15392: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES
15393: -------------------------------------------------------------------
15394: select message_text
15395: into l_note_prefix
15396: from fnd_new_messages

Line 15403: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);

15399: and language_code = l_new_language_code;
15400:
15401: exception
15402: when no_data_found then
15403: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
15404: l_note_prefix := FND_MESSAGE.GET;
15405: end;
15406:
15407: -------------------------------------------------------------------

Line 15404: l_note_prefix := FND_MESSAGE.GET;

15400:
15401: exception
15402: when no_data_found then
15403: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
15404: l_note_prefix := FND_MESSAGE.GET;
15405: end;
15406:
15407: -------------------------------------------------------------------
15408: l_debug_info := 'Retrieve Activity Result Code';

Line 15713: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_SUPERVISOR');

15709: END IF;
15710: --------------------------------
15711: l_debug_info := 'No supervisor';
15712: --------------------------------
15713: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_SUPERVISOR');
15714: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', nvl(p_employee_name,l_employee_name));
15715: p_error_message := FND_MESSAGE.Get;
15716:
15717: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');

Line 15714: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', nvl(p_employee_name,l_employee_name));

15710: --------------------------------
15711: l_debug_info := 'No supervisor';
15712: --------------------------------
15713: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_SUPERVISOR');
15714: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', nvl(p_employee_name,l_employee_name));
15715: p_error_message := FND_MESSAGE.Get;
15716:
15717: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15718: p_instructions := FND_MESSAGE.Get;

Line 15715: p_error_message := FND_MESSAGE.Get;

15711: l_debug_info := 'No supervisor';
15712: --------------------------------
15713: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_SUPERVISOR');
15714: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', nvl(p_employee_name,l_employee_name));
15715: p_error_message := FND_MESSAGE.Get;
15716:
15717: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15718: p_instructions := FND_MESSAGE.Get;
15719:

Line 15717: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');

15713: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_SUPERVISOR');
15714: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', nvl(p_employee_name,l_employee_name));
15715: p_error_message := FND_MESSAGE.Get;
15716:
15717: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15718: p_instructions := FND_MESSAGE.Get;
15719:
15720: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15721: p_special_instr := FND_MESSAGE.Get;

Line 15718: p_instructions := FND_MESSAGE.Get;

15714: FND_MESSAGE.Set_Token('EMPLOYEE_NAME', nvl(p_employee_name,l_employee_name));
15715: p_error_message := FND_MESSAGE.Get;
15716:
15717: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15718: p_instructions := FND_MESSAGE.Get;
15719:
15720: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15721: p_special_instr := FND_MESSAGE.Get;
15722: ELSIF (p_manager_status = 'TERM_ASSIGN') THEN

Line 15720: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

15716:
15717: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15718: p_instructions := FND_MESSAGE.Get;
15719:
15720: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15721: p_special_instr := FND_MESSAGE.Get;
15722: ELSIF (p_manager_status = 'TERM_ASSIGN') THEN
15723: -----------------------------------------
15724: l_debug_info := 'Approver is terminated';

Line 15721: p_special_instr := FND_MESSAGE.Get;

15717: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15718: p_instructions := FND_MESSAGE.Get;
15719:
15720: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15721: p_special_instr := FND_MESSAGE.Get;
15722: ELSIF (p_manager_status = 'TERM_ASSIGN') THEN
15723: -----------------------------------------
15724: l_debug_info := 'Approver is terminated';
15725: -----------------------------------------

Line 15726: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_TERMINATED');

15722: ELSIF (p_manager_status = 'TERM_ASSIGN') THEN
15723: -----------------------------------------
15724: l_debug_info := 'Approver is terminated';
15725: -----------------------------------------
15726: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_TERMINATED');
15727: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15728: p_error_message := FND_MESSAGE.Get;
15729:
15730: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');

Line 15727: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);

15723: -----------------------------------------
15724: l_debug_info := 'Approver is terminated';
15725: -----------------------------------------
15726: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_TERMINATED');
15727: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15728: p_error_message := FND_MESSAGE.Get;
15729:
15730: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15731: p_instructions := FND_MESSAGE.Get;

Line 15728: p_error_message := FND_MESSAGE.Get;

15724: l_debug_info := 'Approver is terminated';
15725: -----------------------------------------
15726: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_TERMINATED');
15727: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15728: p_error_message := FND_MESSAGE.Get;
15729:
15730: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15731: p_instructions := FND_MESSAGE.Get;
15732:

Line 15730: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');

15726: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_TERMINATED');
15727: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15728: p_error_message := FND_MESSAGE.Get;
15729:
15730: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15731: p_instructions := FND_MESSAGE.Get;
15732:
15733: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15734: p_special_instr := FND_MESSAGE.Get;

Line 15731: p_instructions := FND_MESSAGE.Get;

15727: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15728: p_error_message := FND_MESSAGE.Get;
15729:
15730: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15731: p_instructions := FND_MESSAGE.Get;
15732:
15733: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15734: p_special_instr := FND_MESSAGE.Get;
15735: ELSIF ((p_manager_status = 'SUSP_ASSIGN') or

Line 15733: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

15729:
15730: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15731: p_instructions := FND_MESSAGE.Get;
15732:
15733: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15734: p_special_instr := FND_MESSAGE.Get;
15735: ELSIF ((p_manager_status = 'SUSP_ASSIGN') or
15736: (p_manager_status = 'SUSP_CWK_ASG')) THEN
15737: -----------------------------------------------------------

Line 15734: p_special_instr := FND_MESSAGE.Get;

15730: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR1');
15731: p_instructions := FND_MESSAGE.Get;
15732:
15733: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15734: p_special_instr := FND_MESSAGE.Get;
15735: ELSIF ((p_manager_status = 'SUSP_ASSIGN') or
15736: (p_manager_status = 'SUSP_CWK_ASG')) THEN
15737: -----------------------------------------------------------
15738: l_debug_info := 'Approver is suspended/on temporary leave';

Line 15740: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_SUSPENDED');

15736: (p_manager_status = 'SUSP_CWK_ASG')) THEN
15737: -----------------------------------------------------------
15738: l_debug_info := 'Approver is suspended/on temporary leave';
15739: -----------------------------------------------------------
15740: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_SUSPENDED');
15741: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15742: p_error_message := FND_MESSAGE.Get;
15743:
15744: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR2');

Line 15741: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);

15737: -----------------------------------------------------------
15738: l_debug_info := 'Approver is suspended/on temporary leave';
15739: -----------------------------------------------------------
15740: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_SUSPENDED');
15741: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15742: p_error_message := FND_MESSAGE.Get;
15743:
15744: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR2');
15745: p_instructions := FND_MESSAGE.Get;

Line 15742: p_error_message := FND_MESSAGE.Get;

15738: l_debug_info := 'Approver is suspended/on temporary leave';
15739: -----------------------------------------------------------
15740: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_SUSPENDED');
15741: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15742: p_error_message := FND_MESSAGE.Get;
15743:
15744: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR2');
15745: p_instructions := FND_MESSAGE.Get;
15746:

Line 15744: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR2');

15740: FND_MESSAGE.Set_Name('SQLAP', 'OIE_APPROVER_SUSPENDED');
15741: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15742: p_error_message := FND_MESSAGE.Get;
15743:
15744: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR2');
15745: p_instructions := FND_MESSAGE.Get;
15746:
15747: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15748: p_special_instr := FND_MESSAGE.Get;

Line 15745: p_instructions := FND_MESSAGE.Get;

15741: FND_MESSAGE.Set_Token('APPROVER_NAME', p_manager_name);
15742: p_error_message := FND_MESSAGE.Get;
15743:
15744: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR2');
15745: p_instructions := FND_MESSAGE.Get;
15746:
15747: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15748: p_special_instr := FND_MESSAGE.Get;
15749: END IF;

Line 15747: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

15743:
15744: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR2');
15745: p_instructions := FND_MESSAGE.Get;
15746:
15747: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15748: p_special_instr := FND_MESSAGE.Get;
15749: END IF;
15750:
15751: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GetManagerInfoAndCheckStatus');

Line 15748: p_special_instr := FND_MESSAGE.Get;

15744: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR2');
15745: p_instructions := FND_MESSAGE.Get;
15746:
15747: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
15748: p_special_instr := FND_MESSAGE.Get;
15749: END IF;
15750:
15751: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GetManagerInfoAndCheckStatus');
15752:

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

15912: COMMIT;
15913:
15914:
15915: IF (SQLCODE <> -20001) THEN
15916: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
15917: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
15918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RaiseSubmitEvent');
15919: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
15920: END IF;

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

15913:
15914:
15915: IF (SQLCODE <> -20001) THEN
15916: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
15917: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
15918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RaiseSubmitEvent');
15919: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
15920: END IF;
15921:

Line 15918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RaiseSubmitEvent');

15914:
15915: IF (SQLCODE <> -20001) THEN
15916: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
15917: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
15918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RaiseSubmitEvent');
15919: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
15920: END IF;
15921:
15922: -- always raise exceptions regardless it from RaiseSubmitEvent

Line 15919: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

15915: IF (SQLCODE <> -20001) THEN
15916: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
15917: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
15918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'RaiseSubmitEvent');
15919: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
15920: END IF;
15921:
15922: -- always raise exceptions regardless it from RaiseSubmitEvent
15923: -- or other callees

Line 16230: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');

16226: approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut,
16227: nextApproversOut => l_nextApproversOut);
16228: EXCEPTION
16229: when others then
16230: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
16231: l_error_message := FND_MESSAGE.Get;
16232: -- bug 3257576
16233: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
16234: l_instructions := FND_MESSAGE.Get;

Line 16231: l_error_message := FND_MESSAGE.Get;

16227: nextApproversOut => l_nextApproversOut);
16228: EXCEPTION
16229: when others then
16230: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
16231: l_error_message := FND_MESSAGE.Get;
16232: -- bug 3257576
16233: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
16234: l_instructions := FND_MESSAGE.Get;
16235: raise fixable_exception ;

Line 16233: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');

16229: when others then
16230: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
16231: l_error_message := FND_MESSAGE.Get;
16232: -- bug 3257576
16233: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
16234: l_instructions := FND_MESSAGE.Get;
16235: raise fixable_exception ;
16236: END;
16237:

Line 16234: l_instructions := FND_MESSAGE.Get;

16230: FND_MESSAGE.Set_Name('SQLAP', 'OIE_GETNEXTAPPROVER_ERROR');
16231: l_error_message := FND_MESSAGE.Get;
16232: -- bug 3257576
16233: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR4');
16234: l_instructions := FND_MESSAGE.Get;
16235: raise fixable_exception ;
16236: END;
16237:
16238: l_childItemKeySeq := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 16305: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');

16301: ---------------------------------------------
16302: IF(AP_WEB_CUST_DFLEX_PKG.CustomApprovalStatus(p_item_key, l_employee_id,
16303: l_nextApproversOut(i).orig_system_id, l_continue) = FALSE) THEN
16304: IF(l_continue = TRUE) THEN
16305: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
16306: l_error_message := FND_MESSAGE.Get;
16307: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
16308: l_instructions := FND_MESSAGE.Get;
16309: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

Line 16306: l_error_message := FND_MESSAGE.Get;

16302: IF(AP_WEB_CUST_DFLEX_PKG.CustomApprovalStatus(p_item_key, l_employee_id,
16303: l_nextApproversOut(i).orig_system_id, l_continue) = FALSE) THEN
16304: IF(l_continue = TRUE) THEN
16305: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
16306: l_error_message := FND_MESSAGE.Get;
16307: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
16308: l_instructions := FND_MESSAGE.Get;
16309: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
16310: l_special_instr := FND_MESSAGE.Get;

Line 16307: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');

16303: l_nextApproversOut(i).orig_system_id, l_continue) = FALSE) THEN
16304: IF(l_continue = TRUE) THEN
16305: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
16306: l_error_message := FND_MESSAGE.Get;
16307: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
16308: l_instructions := FND_MESSAGE.Get;
16309: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
16310: l_special_instr := FND_MESSAGE.Get;
16311: raise fixable_exception ;

Line 16308: l_instructions := FND_MESSAGE.Get;

16304: IF(l_continue = TRUE) THEN
16305: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
16306: l_error_message := FND_MESSAGE.Get;
16307: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
16308: l_instructions := FND_MESSAGE.Get;
16309: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
16310: l_special_instr := FND_MESSAGE.Get;
16311: raise fixable_exception ;
16312: ELSE

Line 16309: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');

16305: FND_MESSAGE.Set_Name('SQLAP', 'AP_WEB_APRVL_HIERARCHY_LOOP');
16306: l_error_message := FND_MESSAGE.Get;
16307: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
16308: l_instructions := FND_MESSAGE.Get;
16309: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
16310: l_special_instr := FND_MESSAGE.Get;
16311: raise fixable_exception ;
16312: ELSE
16313: raise continue_exception;

Line 16310: l_special_instr := FND_MESSAGE.Get;

16306: l_error_message := FND_MESSAGE.Get;
16307: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_INSTR6');
16308: l_instructions := FND_MESSAGE.Get;
16309: FND_MESSAGE.Set_Name('SQLAP', 'OIE_NO_APPROVER_SPL_INSTR');
16310: l_special_instr := FND_MESSAGE.Get;
16311: raise fixable_exception ;
16312: ELSE
16313: raise continue_exception;
16314: END IF;

' || l_message || '