296: l_textNameArr(iText) := 'CURRENCY';
297: l_textValArr(iText) := p_billed_currency_code;
298:
299: ------------------------------------------------------------
300: l_debug_info := 'Get Special Instructions from FND_MESSAGE';
301: ------------------------------------------------------------
302:
303: fnd_message.set_name('SQLAP','OIE_INACT_SPEC_INSTRUCTIONS');
304: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);
299: ------------------------------------------------------------
300: l_debug_info := 'Get Special Instructions from FND_MESSAGE';
301: ------------------------------------------------------------
302:
303: fnd_message.set_name('SQLAP','OIE_INACT_SPEC_INSTRUCTIONS');
304: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);
305: fnd_message.set_token('INACT_EMP_ORG_NAME', l_inact_emp_org_name);
306: l_special_instructions := fnd_message.get;
307:
300: l_debug_info := 'Get Special Instructions from FND_MESSAGE';
301: ------------------------------------------------------------
302:
303: fnd_message.set_name('SQLAP','OIE_INACT_SPEC_INSTRUCTIONS');
304: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);
305: fnd_message.set_token('INACT_EMP_ORG_NAME', l_inact_emp_org_name);
306: l_special_instructions := fnd_message.get;
307:
308: -------------------------------------------------------------
301: ------------------------------------------------------------
302:
303: fnd_message.set_name('SQLAP','OIE_INACT_SPEC_INSTRUCTIONS');
304: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);
305: fnd_message.set_token('INACT_EMP_ORG_NAME', l_inact_emp_org_name);
306: l_special_instructions := fnd_message.get;
307:
308: -------------------------------------------------------------
309: l_debug_info := 'Set WF Special Instructions Item Attribute';
302:
303: fnd_message.set_name('SQLAP','OIE_INACT_SPEC_INSTRUCTIONS');
304: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);
305: fnd_message.set_token('INACT_EMP_ORG_NAME', l_inact_emp_org_name);
306: l_special_instructions := fnd_message.get;
307:
308: -------------------------------------------------------------
309: l_debug_info := 'Set WF Special Instructions Item Attribute';
310: -------------------------------------------------------------
312: l_textNameArr(iText) := 'SPECIAL_INSTRUCTIONS';
313: l_textValArr(iText) := l_special_instructions;
314:
315: ------------------------------------------------------------
316: l_debug_info := 'Get Instructions from FND_MESSAGE';
317: ------------------------------------------------------------
318:
319: fnd_message.set_name('SQLAP','OIE_INACT_INSTRUCTIONS');
320: l_instructions := fnd_message.get;
315: ------------------------------------------------------------
316: l_debug_info := 'Get Instructions from FND_MESSAGE';
317: ------------------------------------------------------------
318:
319: fnd_message.set_name('SQLAP','OIE_INACT_INSTRUCTIONS');
320: l_instructions := fnd_message.get;
321:
322:
323: -------------------------------------------------------------
316: l_debug_info := 'Get Instructions from FND_MESSAGE';
317: ------------------------------------------------------------
318:
319: fnd_message.set_name('SQLAP','OIE_INACT_INSTRUCTIONS');
320: l_instructions := fnd_message.get;
321:
322:
323: -------------------------------------------------------------
324: l_debug_info := 'Set WF Instructions Item Attribute';
327: l_textNameArr(iText) := 'INSTRUCTIONS';
328: l_textValArr(iText) := l_instructions;
329:
330: ------------------------------------------------------------
331: l_debug_info := 'Get Note from FND_MESSAGE';
332: ------------------------------------------------------------
333:
334: fnd_message.set_name('SQLAP','OIE_INACT_NOTE');
335: l_note := fnd_message.get;
330: ------------------------------------------------------------
331: l_debug_info := 'Get Note from FND_MESSAGE';
332: ------------------------------------------------------------
333:
334: fnd_message.set_name('SQLAP','OIE_INACT_NOTE');
335: l_note := fnd_message.get;
336:
337: -------------------------------------------------------------
338: l_debug_info := 'Set WF Instructions Note Item Attribute';
331: l_debug_info := 'Get Note from FND_MESSAGE';
332: ------------------------------------------------------------
333:
334: fnd_message.set_name('SQLAP','OIE_INACT_NOTE');
335: l_note := fnd_message.get;
336:
337: -------------------------------------------------------------
338: l_debug_info := 'Set WF Instructions Note Item Attribute';
339: -------------------------------------------------------------
341: l_textNameArr(iText) := 'INSTRUCTION_NOTE';
342: l_textValArr(iText) := l_note;
343:
344: -------------------------------------------------------------------
345: l_debug_info := 'Get Responsibility Instructions from FND_MESSAGE';
346: -------------------------------------------------------------------
347:
348: fnd_message.set_name('SQLAP','OIE_INACT_RESP_INSTRUCTIONS');
349: l_resp_instructions := fnd_message.get;
344: -------------------------------------------------------------------
345: l_debug_info := 'Get Responsibility Instructions from FND_MESSAGE';
346: -------------------------------------------------------------------
347:
348: fnd_message.set_name('SQLAP','OIE_INACT_RESP_INSTRUCTIONS');
349: l_resp_instructions := fnd_message.get;
350:
351: ---------------------------------------------------------------------
352: l_debug_info := 'Set Responsibility Instructions Note Item Attribute';
345: l_debug_info := 'Get Responsibility Instructions from FND_MESSAGE';
346: -------------------------------------------------------------------
347:
348: fnd_message.set_name('SQLAP','OIE_INACT_RESP_INSTRUCTIONS');
349: l_resp_instructions := fnd_message.get;
350:
351: ---------------------------------------------------------------------
352: l_debug_info := 'Set Responsibility Instructions Note Item Attribute';
353: ---------------------------------------------------------------------
355: l_textNameArr(iText) := 'RESP_INSTRUCTIONS';
356: l_textValArr(iText) := l_resp_instructions;
357:
358: -------------------------------------------------------------------
359: l_debug_info := 'Get Responsibility Note from FND_MESSAGE';
360: -------------------------------------------------------------------
361:
362: fnd_message.set_name('SQLAP','OIE_INACT_RESP_NOT_REASON');
363: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);
358: -------------------------------------------------------------------
359: l_debug_info := 'Get Responsibility Note from FND_MESSAGE';
360: -------------------------------------------------------------------
361:
362: fnd_message.set_name('SQLAP','OIE_INACT_RESP_NOT_REASON');
363: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);
364: l_resp_notes := fnd_message.get;
365:
366: ---------------------------------------------------------------------
359: l_debug_info := 'Get Responsibility Note from FND_MESSAGE';
360: -------------------------------------------------------------------
361:
362: fnd_message.set_name('SQLAP','OIE_INACT_RESP_NOT_REASON');
363: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);
364: l_resp_notes := fnd_message.get;
365:
366: ---------------------------------------------------------------------
367: l_debug_info := 'Set Responsibility Instructions Note Item Attribute';
360: -------------------------------------------------------------------
361:
362: fnd_message.set_name('SQLAP','OIE_INACT_RESP_NOT_REASON');
363: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);
364: l_resp_notes := fnd_message.get;
365:
366: ---------------------------------------------------------------------
367: l_debug_info := 'Set Responsibility Instructions Note Item Attribute';
368: ---------------------------------------------------------------------
528:
529: EXCEPTION
530: WHEN NO_DATA_FOUND THEN
531: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetInactEmpCcardTrxnCursor',
532: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);
533: RETURN FALSE;
534:
535: WHEN OTHERS THEN
536:
534:
535: WHEN OTHERS THEN
536:
537: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'GetInactEmpCcardTrxnCursor',
538: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);
539: APP_EXCEPTION.RAISE_EXCEPTION;
540: RETURN FALSE;
541:
542: END GetInactEmpCcardTrxnCursor;
900:
901: EXCEPTION
902: WHEN OTHERS THEN
903: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'FindActiveMAnager',
904: p_item_type, p_item_key, to_char(0), l_debug_info || FND_MESSAGE.GET);
905: raise;
906: END FindActiveMAnager;
907:
908: PROCEDURE SetAPRolePreparer(p_item_type IN VARCHAR2,
997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'SetAPRolePreparer',
1001: p_item_type, p_item_key, to_char(0), l_debug_info || FND_MESSAGE.GET);
1002: raise;
1003: END SetAPRolePreparer;
1004:
1005: PROCEDURE SetFromRoleForwardFrom(p_item_type IN VARCHAR2,
1171: itemkey,
1172: 'PREPARER_DISPLAY_NAME');
1173:
1174: --------------------------------------------------------------------
1175: l_debug_info := 'Get No Response from the Preparer from FND_MESSAGE';
1176: ---------------------------------------------------------------------
1177:
1178: fnd_message.set_name('SQLAP','OIE_INACT_PREPARER_NO_RESP');
1179: fnd_message.set_token('PREPARER_NAME', l_preparer_display_name);
1174: --------------------------------------------------------------------
1175: l_debug_info := 'Get No Response from the Preparer from FND_MESSAGE';
1176: ---------------------------------------------------------------------
1177:
1178: fnd_message.set_name('SQLAP','OIE_INACT_PREPARER_NO_RESP');
1179: fnd_message.set_token('PREPARER_NAME', l_preparer_display_name);
1180: l_note_mang_prep_no_resp := fnd_message.get;
1181:
1182: WF_ENGINE.SetItemAttrText(itemtype,
1175: l_debug_info := 'Get No Response from the Preparer from FND_MESSAGE';
1176: ---------------------------------------------------------------------
1177:
1178: fnd_message.set_name('SQLAP','OIE_INACT_PREPARER_NO_RESP');
1179: fnd_message.set_token('PREPARER_NAME', l_preparer_display_name);
1180: l_note_mang_prep_no_resp := fnd_message.get;
1181:
1182: WF_ENGINE.SetItemAttrText(itemtype,
1183: itemkey,
1176: ---------------------------------------------------------------------
1177:
1178: fnd_message.set_name('SQLAP','OIE_INACT_PREPARER_NO_RESP');
1179: fnd_message.set_token('PREPARER_NAME', l_preparer_display_name);
1180: l_note_mang_prep_no_resp := fnd_message.get;
1181:
1182: WF_ENGINE.SetItemAttrText(itemtype,
1183: itemkey,
1184: 'NOTE_MANG_PREP_NO_RESPONSE',
1483: 'ERROR_PREPARER_NAME',
1484: l_error_preparer_name);
1485:
1486: ------------------------------------------------------------
1487: l_debug_info := 'Get Error Instructions from FND_MESSAGE';
1488: ------------------------------------------------------------
1489:
1490: fnd_message.set_name('SQLAP','OIE_INACT_ERROR_INSTRUCTIONS');
1491: l_error_instructions := fnd_message.get;
1486: ------------------------------------------------------------
1487: l_debug_info := 'Get Error Instructions from FND_MESSAGE';
1488: ------------------------------------------------------------
1489:
1490: fnd_message.set_name('SQLAP','OIE_INACT_ERROR_INSTRUCTIONS');
1491: l_error_instructions := fnd_message.get;
1492:
1493: -------------------------------------------------------------
1494: l_debug_info := 'Set WF Error Instructions Item Attribute';
1487: l_debug_info := 'Get Error Instructions from FND_MESSAGE';
1488: ------------------------------------------------------------
1489:
1490: fnd_message.set_name('SQLAP','OIE_INACT_ERROR_INSTRUCTIONS');
1491: l_error_instructions := fnd_message.get;
1492:
1493: -------------------------------------------------------------
1494: l_debug_info := 'Set WF Error Instructions Item Attribute';
1495: -------------------------------------------------------------
1499: 'ERROR_INSTRUCTIONS',
1500: l_error_instructions);
1501:
1502: ------------------------------------------------------------
1503: l_debug_info := 'Get Error Note from FND_MESSAGE';
1504: ------------------------------------------------------------
1505:
1506: fnd_message.set_name('SQLAP','OIE_INACT_ERROR_NOTE');
1507: l_error_note := fnd_message.get;
1502: ------------------------------------------------------------
1503: l_debug_info := 'Get Error Note from FND_MESSAGE';
1504: ------------------------------------------------------------
1505:
1506: fnd_message.set_name('SQLAP','OIE_INACT_ERROR_NOTE');
1507: l_error_note := fnd_message.get;
1508:
1509: -------------------------------------------------------------
1510: l_debug_info := 'Set WF Error Note Item Attribute';
1503: l_debug_info := 'Get Error Note from FND_MESSAGE';
1504: ------------------------------------------------------------
1505:
1506: fnd_message.set_name('SQLAP','OIE_INACT_ERROR_NOTE');
1507: l_error_note := fnd_message.get;
1508:
1509: -------------------------------------------------------------
1510: l_debug_info := 'Set WF Error Note Item Attribute';
1511: -------------------------------------------------------------
2532:
2533: EXCEPTION
2534: WHEN NO_DATA_FOUND THEN
2535: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetUserIdForEmp',
2536: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);
2537: RETURN FALSE;
2538:
2539: WHEN OTHERS THEN
2540:
2538:
2539: WHEN OTHERS THEN
2540:
2541: Wf_Core.Context('AP_WEB_INACTIVE_EMP_WF_PKG', 'GetUserIdForEmp',
2542: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);
2543: APP_EXCEPTION.RAISE_EXCEPTION;
2544: RETURN FALSE;
2545:
2546: END GetUserIdForEmp;