DBA Data[Home] [Help]

APPS.AMW_CTRL_APPROVAL_PVT dependencies on FND_MESSAGE

Line 138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');

134: l_start_date,
135: l_requestor_id;
136: CLOSE c_CTRL_rec;
137: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
142: /*

Line 139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);

135: l_requestor_id;
136: CLOSE c_CTRL_rec;
137: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
142: /*
143: wf_engine.setitemattrtext (

Line 140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);

136: CLOSE c_CTRL_rec;
137: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
142: /*
143: wf_engine.setitemattrtext (
144: itemtype=> l_item_type,

Line 141: l_string := SUBSTR(fnd_message.get,1,1000);

137: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
142: /*
143: wf_engine.setitemattrtext (
144: itemtype=> l_item_type,
145: itemkey=> l_item_key,

Line 150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');

146: aname => 'FYI_SUBJECT',
147: avalue=> l_string
148: );
149: */
150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);

147: avalue=> l_string
148: );
149: */
150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
155:

Line 152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

148: );
149: */
150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
155:
156: /*

Line 153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);

149: */
150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
155:
156: /*
157: l_note := wf_engine.getitemattrtext(

Line 154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
155:
156: /*
157: l_note := wf_engine.getitemattrtext(
158: itemtype => l_item_type

Line 315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');

311: l_CTRL_name,
312: l_start_date,
313: l_requestor_id;
314: CLOSE c_CTRL_rec;
315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);

Line 316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);

312: l_start_date,
313: l_requestor_id;
314: CLOSE c_CTRL_rec;
315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');

Line 317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);

313: l_requestor_id;
314: CLOSE c_CTRL_rec;
315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);

Line 318: l_string := Substr(FND_MESSAGE.Get,1,1000);

314: CLOSE c_CTRL_rec;
315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');

316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);

Line 321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);

317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
325:

Line 322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
325:
326: /*

Line 323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);

319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
325:
326: /*
327: l_note := wf_engine.getitemattrtext(

Line 324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);

320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
325:
326: /*
327: l_note := wf_engine.getitemattrtext(
328: itemtype => l_item_type

Line 351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');

347: SELECT SYSDATE
348: INTO l_approval_date
349: FROM DUAL;
350:
351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);

Line 352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);

348: INTO l_approval_date
349: FROM DUAL;
350:
351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);
356:

Line 353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);

349: FROM DUAL;
350:
351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);
356:
357:

Line 354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);

350:
351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);
356:
357:
358: -- IF (display_type = 'text/plain') THEN

Line 355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);

351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);
356:
357:
358: -- IF (display_type = 'text/plain') THEN
359: l_appr_notification := SUBSTR(l_string

Line 510: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');

506: l_CTRL_name,
507: l_start_date,
508: l_requestor_id;
509: CLOSE c_CTRL_rec;
510: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
513: l_string := Substr(FND_MESSAGE.Get,1,1000);
514: /*

Line 511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);

507: l_start_date,
508: l_requestor_id;
509: CLOSE c_CTRL_rec;
510: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
513: l_string := Substr(FND_MESSAGE.Get,1,1000);
514: /*
515: wf_engine.setitemattrtext (

Line 512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);

508: l_requestor_id;
509: CLOSE c_CTRL_rec;
510: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
513: l_string := Substr(FND_MESSAGE.Get,1,1000);
514: /*
515: wf_engine.setitemattrtext (
516: itemtype=> l_item_type,

Line 513: l_string := Substr(FND_MESSAGE.Get,1,1000);

509: CLOSE c_CTRL_rec;
510: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
513: l_string := Substr(FND_MESSAGE.Get,1,1000);
514: /*
515: wf_engine.setitemattrtext (
516: itemtype=> l_item_type,
517: itemkey=> l_item_key,

Line 523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');

519: avalue=> l_string
520: );
521: */
522: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);

Line 524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);

520: );
521: */
522: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);

Line 525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);

521: */
522: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

Line 526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);

522: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);

523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
531: /*

Line 528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);

524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
531: /*
532: l_note := wf_engine.getitemattrtext(

Line 529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
531: /*
532: l_note := wf_engine.getitemattrtext(
533: itemtype => l_item_type

Line 530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
531: /*
532: l_note := wf_engine.getitemattrtext(
533: itemtype => l_item_type
534: ,itemkey => l_item_key

Line 552: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');

548: itemtype=> l_item_type,
549: itemkey=> l_item_key,
550: aname => 'APPROVAL_NOTE'
551: );
552: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');
553: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
554:
555: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
556:

Line 553: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);

549: itemkey=> l_item_key,
550: aname => 'APPROVAL_NOTE'
551: );
552: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');
553: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
554:
555: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
556:
557: l_rej_notification := SUBSTR(l_string

Line 555: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);

551: );
552: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');
553: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
554:
555: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
556:
557: l_rej_notification := SUBSTR(l_string
558: || fnd_global.local_chr (10)
559: || l_string1

Line 692: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');

688: l_CTRL_name,
689: l_start_date,
690: l_requestor_id;
691: CLOSE c_CTRL_rec;
692: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
695: l_string := SUBSTR(fnd_message.get,1,1000);
696: /*

Line 693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);

689: l_start_date,
690: l_requestor_id;
691: CLOSE c_CTRL_rec;
692: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
695: l_string := SUBSTR(fnd_message.get,1,1000);
696: /*
697: wf_engine.setitemattrtext (

Line 694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);

690: l_requestor_id;
691: CLOSE c_CTRL_rec;
692: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
695: l_string := SUBSTR(fnd_message.get,1,1000);
696: /*
697: wf_engine.setitemattrtext (
698: itemtype=> l_item_type,

Line 695: l_string := SUBSTR(fnd_message.get,1,1000);

691: CLOSE c_CTRL_rec;
692: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
695: l_string := SUBSTR(fnd_message.get,1,1000);
696: /*
697: wf_engine.setitemattrtext (
698: itemtype=> l_item_type,
699: itemkey=> l_item_key,

Line 705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');

701: avalue=> l_string
702: );
703: */
704: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

Line 706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);

702: );
703: */
704: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);

703: */
704: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
711: l_note :=

Line 708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

704: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
711: l_note :=
712: NVL(wf_engine.getitemattrtext (

Line 709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
711: l_note :=
712: NVL(wf_engine.getitemattrtext (
713: itemtype=> l_item_type,

Line 710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
711: l_note :=
712: NVL(wf_engine.getitemattrtext (
713: itemtype=> l_item_type,
714: itemkey=> l_item_key,

Line 728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');

724: itemtype => l_item_type,
725: itemkey => l_item_key,
726: aname => 'AMW_APPROVAL_DATE')),'-');
727:
728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);

Line 729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);

725: itemkey => l_item_key,
726: aname => 'AMW_APPROVAL_DATE')),'-');
727:
728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);
733: -- IF (display_type = 'text/plain') THEN

Line 730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);

726: aname => 'AMW_APPROVAL_DATE')),'-');
727:
728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);
733: -- IF (display_type = 'text/plain') THEN
734: l_appreq_notification := l_string

Line 731: fnd_message.set_token ('COMMENTS', l_note, FALSE);

727:
728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);
733: -- IF (display_type = 'text/plain') THEN
734: l_appreq_notification := l_string
735: || fnd_global.local_chr (10)

Line 732: l_string2 := SUBSTR(fnd_message.get,1,2500);

728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);
733: -- IF (display_type = 'text/plain') THEN
734: l_appreq_notification := l_string
735: || fnd_global.local_chr (10)
736: || l_string1

Line 882: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');

878: FETCH c_CTRL_rec INTO l_CTRL_id,
879: l_CTRL_name,
880: l_start_date;
881: CLOSE c_CTRL_rec;
882: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
885: l_string := SUBSTR(fnd_message.get,1,1000);
886: /*

Line 883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);

879: l_CTRL_name,
880: l_start_date;
881: CLOSE c_CTRL_rec;
882: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
885: l_string := SUBSTR(fnd_message.get,1,1000);
886: /*
887: wf_engine.setitemattrtext (

Line 884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);

880: l_start_date;
881: CLOSE c_CTRL_rec;
882: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
885: l_string := SUBSTR(fnd_message.get,1,1000);
886: /*
887: wf_engine.setitemattrtext (
888: itemtype=> l_item_type,

Line 885: l_string := SUBSTR(fnd_message.get,1,1000);

881: CLOSE c_CTRL_rec;
882: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
885: l_string := SUBSTR(fnd_message.get,1,1000);
886: /*
887: wf_engine.setitemattrtext (
888: itemtype=> l_item_type,
889: itemkey=> l_item_key,

Line 894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');

890: aname => 'APP_SUBJECT',
891: avalue=> l_string
892: );
893: */
894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

Line 895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);

891: avalue=> l_string
892: );
893: */
894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
899:

Line 896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

892: );
893: */
894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
899:
900:

Line 897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);

893: */
894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
899:
900:
901: l_note :=

Line 898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
899:
900:
901: l_note :=
902: NVL(wf_engine.getitemattrtext (

Line 918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

914: itemtype => l_item_type,
915: itemkey => l_item_key,
916: aname => 'AMW_APPROVAL_DATE')),'-');
917:
918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);

Line 919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');

915: itemkey => l_item_key,
916: aname => 'AMW_APPROVAL_DATE')),'-');
917:
918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);

Line 920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);

916: aname => 'AMW_APPROVAL_DATE')),'-');
917:
918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
924: /*

Line 921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);

917:
918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
924: /*
925: l_note := wf_engine.getitemattrtext(

Line 922: fnd_message.set_token ('COMMENTS', l_note, FALSE);

918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
924: /*
925: l_note := wf_engine.getitemattrtext(
926: itemtype => l_item_type

Line 923: l_string2 := SUBSTR(fnd_message.get,1,2500);

919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
924: /*
925: l_note := wf_engine.getitemattrtext(
926: itemtype => l_item_type
927: ,itemkey => l_item_key

Line 1042: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');

1038: l_start_date;
1039: CLOSE c_CTRL_rec;
1040: l_lookup_meaning := amw_utility_pvt.get_lookup_meaning('AMW_OBJECT_TYPE','CTRL');
1041: --- set all the subjects here
1042: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
1043: fnd_message.set_token (
1044: 'NAME',
1045: l_CTRL_name,
1046: FALSE

Line 1043: fnd_message.set_token (

1039: CLOSE c_CTRL_rec;
1040: l_lookup_meaning := amw_utility_pvt.get_lookup_meaning('AMW_OBJECT_TYPE','CTRL');
1041: --- set all the subjects here
1042: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
1043: fnd_message.set_token (
1044: 'NAME',
1045: l_CTRL_name,
1046: FALSE
1047: );

Line 1048: fnd_message.set_token (

1044: 'NAME',
1045: l_CTRL_name,
1046: FALSE
1047: );
1048: fnd_message.set_token (
1049: 'OBJECT_TYPE',
1050: l_lookup_meaning,
1051: FALSE
1052: );

Line 1054: l_string := Substr(FND_MESSAGE.Get,1,1000);

1050: l_lookup_meaning,
1051: FALSE
1052: );
1053:
1054: l_string := Substr(FND_MESSAGE.Get,1,1000);
1055: wf_engine.setitemattrtext (
1056: itemtype=> itemtype,
1057: itemkey=> itemkey,
1058: aname => 'FYI_SUBJECT',

Line 1062: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');

1058: aname => 'FYI_SUBJECT',
1059: avalue=> l_string
1060: );
1061:
1062: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
1063: fnd_message.set_token ('NAME', l_CTRL_name, FALSE );
1064: fnd_message.set_token (
1065: 'OBJECT_TYPE',
1066: l_lookup_meaning,

Line 1063: fnd_message.set_token ('NAME', l_CTRL_name, FALSE );

1059: avalue=> l_string
1060: );
1061:
1062: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
1063: fnd_message.set_token ('NAME', l_CTRL_name, FALSE );
1064: fnd_message.set_token (
1065: 'OBJECT_TYPE',
1066: l_lookup_meaning,
1067: FALSE

Line 1064: fnd_message.set_token (

1060: );
1061:
1062: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
1063: fnd_message.set_token ('NAME', l_CTRL_name, FALSE );
1064: fnd_message.set_token (
1065: 'OBJECT_TYPE',
1066: l_lookup_meaning,
1067: FALSE
1068: );

Line 1070: l_string := Substr(FND_MESSAGE.Get,1,1000);

1066: l_lookup_meaning,
1067: FALSE
1068: );
1069:
1070: l_string := Substr(FND_MESSAGE.Get,1,1000);
1071: wf_engine.setitemattrtext (
1072: itemtype=> itemtype,
1073: itemkey=> itemkey,
1074: aname => 'APRV_SUBJECT',

Line 1077: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');

1073: itemkey=> itemkey,
1074: aname => 'APRV_SUBJECT',
1075: avalue=> l_string
1076: );
1077: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
1078: fnd_message.set_token (
1079: 'NAME',
1080: l_CTRL_name,
1081: FALSE

Line 1078: fnd_message.set_token (

1074: aname => 'APRV_SUBJECT',
1075: avalue=> l_string
1076: );
1077: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
1078: fnd_message.set_token (
1079: 'NAME',
1080: l_CTRL_name,
1081: FALSE
1082: );

Line 1083: fnd_message.set_token (

1079: 'NAME',
1080: l_CTRL_name,
1081: FALSE
1082: );
1083: fnd_message.set_token (
1084: 'OBJECT_TYPE',
1085: l_lookup_meaning,
1086: FALSE
1087: );

Line 1089: l_string := Substr(FND_MESSAGE.Get,1,1000);

1085: l_lookup_meaning,
1086: FALSE
1087: );
1088:
1089: l_string := Substr(FND_MESSAGE.Get,1,1000);
1090: wf_engine.setitemattrtext (
1091: itemtype=> itemtype,
1092: itemkey=> itemkey,
1093: aname => 'REJECT_SUBJECT',

Line 1096: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');

1092: itemkey=> itemkey,
1093: aname => 'REJECT_SUBJECT',
1094: avalue=> l_string
1095: );
1096: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
1097: fnd_message.set_token (
1098: 'NAME',
1099: l_CTRL_name,
1100: FALSE

Line 1097: fnd_message.set_token (

1093: aname => 'REJECT_SUBJECT',
1094: avalue=> l_string
1095: );
1096: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
1097: fnd_message.set_token (
1098: 'NAME',
1099: l_CTRL_name,
1100: FALSE
1101: );

Line 1102: fnd_message.set_token (

1098: 'NAME',
1099: l_CTRL_name,
1100: FALSE
1101: );
1102: fnd_message.set_token (
1103: 'OBJECT_TYPE',
1104: l_lookup_meaning,
1105: FALSE
1106: );

Line 1108: l_string := Substr(FND_MESSAGE.Get,1,1000);

1104: l_lookup_meaning,
1105: FALSE
1106: );
1107:
1108: l_string := Substr(FND_MESSAGE.Get,1,1000);
1109: wf_engine.setitemattrtext (
1110: itemtype=> itemtype,
1111: itemkey=> itemkey,
1112: aname => 'APP_SUBJECT',