DBA Data[Home] [Help]

APPS.AP_WEB_INACTIVE_EMP_WF_PKG dependencies on FND_MESSAGE

Line 300: l_debug_info := 'Get Special Instructions from FND_MESSAGE';

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);

Line 303: fnd_message.set_name('SQLAP','OIE_INACT_SPEC_INSTRUCTIONS');

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:

Line 304: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);

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: -------------------------------------------------------------

Line 305: fnd_message.set_token('INACT_EMP_ORG_NAME', l_inact_emp_org_name);

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';

Line 306: l_special_instructions := fnd_message.get;

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: -------------------------------------------------------------

Line 316: l_debug_info := 'Get Instructions from FND_MESSAGE';

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;

Line 319: fnd_message.set_name('SQLAP','OIE_INACT_INSTRUCTIONS');

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: -------------------------------------------------------------

Line 320: l_instructions := fnd_message.get;

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';

Line 331: l_debug_info := 'Get Note from FND_MESSAGE';

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;

Line 334: fnd_message.set_name('SQLAP','OIE_INACT_NOTE');

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';

Line 335: l_note := fnd_message.get;

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: -------------------------------------------------------------

Line 345: l_debug_info := 'Get Responsibility Instructions from FND_MESSAGE';

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;

Line 348: fnd_message.set_name('SQLAP','OIE_INACT_RESP_INSTRUCTIONS');

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';

Line 349: l_resp_instructions := fnd_message.get;

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: ---------------------------------------------------------------------

Line 359: l_debug_info := 'Get Responsibility Note from FND_MESSAGE';

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);

Line 362: fnd_message.set_name('SQLAP','OIE_INACT_RESP_NOT_REASON');

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: ---------------------------------------------------------------------

Line 363: fnd_message.set_token('INACT_EMP_NAME', l_inact_emp_display_name);

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';

Line 364: l_resp_notes := fnd_message.get;

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: ---------------------------------------------------------------------

Line 532: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);

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:

Line 538: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);

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;

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

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,

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

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,

Line 1175: l_debug_info := 'Get No Response from the Preparer from FND_MESSAGE';

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);

Line 1178: fnd_message.set_name('SQLAP','OIE_INACT_PREPARER_NO_RESP');

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,

Line 1179: fnd_message.set_token('PREPARER_NAME', l_preparer_display_name);

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,

Line 1180: l_note_mang_prep_no_resp := fnd_message.get;

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',

Line 1487: l_debug_info := 'Get Error Instructions from FND_MESSAGE';

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;

Line 1490: fnd_message.set_name('SQLAP','OIE_INACT_ERROR_INSTRUCTIONS');

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';

Line 1491: l_error_instructions := fnd_message.get;

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: -------------------------------------------------------------

Line 1503: l_debug_info := 'Get Error Note from FND_MESSAGE';

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;

Line 1506: fnd_message.set_name('SQLAP','OIE_INACT_ERROR_NOTE');

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';

Line 1507: l_error_note := fnd_message.get;

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: -------------------------------------------------------------

Line 2536: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);

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:

Line 2542: to_char(0), to_char(0), to_char(0), l_debug_info || FND_MESSAGE.GET);

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;