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.AHL_OPERATIONS_APPROVAL_PVT dependencies on FND_MESSAGE

Line 88: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

84: IF GetOperationDet%FOUND
85: THEN
86: l_check_flag:='Y';
87:
88: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
89: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
90: l_subject := fnd_message.get;
91:
92: fnd_message.set_name('AHL','AHL_RM_OPERNTF_FORWARD_SUBJECT');

Line 89: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

85: THEN
86: l_check_flag:='Y';
87:
88: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
89: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
90: l_subject := fnd_message.get;
91:
92: fnd_message.set_name('AHL','AHL_RM_OPERNTF_FORWARD_SUBJECT');
93: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 90: l_subject := fnd_message.get;

86: l_check_flag:='Y';
87:
88: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
89: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
90: l_subject := fnd_message.get;
91:
92: fnd_message.set_name('AHL','AHL_RM_OPERNTF_FORWARD_SUBJECT');
93: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
94: l_subject_apr:= fnd_message.get;

Line 92: fnd_message.set_name('AHL','AHL_RM_OPERNTF_FORWARD_SUBJECT');

88: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
89: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
90: l_subject := fnd_message.get;
91:
92: fnd_message.set_name('AHL','AHL_RM_OPERNTF_FORWARD_SUBJECT');
93: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
94: l_subject_apr:= fnd_message.get;
95:
96: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_REJTS_SUB');

Line 93: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

89: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
90: l_subject := fnd_message.get;
91:
92: fnd_message.set_name('AHL','AHL_RM_OPERNTF_FORWARD_SUBJECT');
93: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
94: l_subject_apr:= fnd_message.get;
95:
96: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_REJTS_SUB');
97: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 94: l_subject_apr:= fnd_message.get;

90: l_subject := fnd_message.get;
91:
92: fnd_message.set_name('AHL','AHL_RM_OPERNTF_FORWARD_SUBJECT');
93: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
94: l_subject_apr:= fnd_message.get;
95:
96: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_REJTS_SUB');
97: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
98: l_subject_rej:= fnd_message.get;

Line 96: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_REJTS_SUB');

92: fnd_message.set_name('AHL','AHL_RM_OPERNTF_FORWARD_SUBJECT');
93: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
94: l_subject_apr:= fnd_message.get;
95:
96: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_REJTS_SUB');
97: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
98: l_subject_rej:= fnd_message.get;
99:
100: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_APRVS_SUB');

Line 97: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

93: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
94: l_subject_apr:= fnd_message.get;
95:
96: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_REJTS_SUB');
97: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
98: l_subject_rej:= fnd_message.get;
99:
100: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_APRVS_SUB');
101: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 98: l_subject_rej:= fnd_message.get;

94: l_subject_apr:= fnd_message.get;
95:
96: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_REJTS_SUB');
97: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
98: l_subject_rej:= fnd_message.get;
99:
100: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_APRVS_SUB');
101: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
102: l_subject_aprvd:= fnd_message.get;

Line 100: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_APRVS_SUB');

96: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_REJTS_SUB');
97: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
98: l_subject_rej:= fnd_message.get;
99:
100: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_APRVS_SUB');
101: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
102: l_subject_aprvd:= fnd_message.get;
103:
104: fnd_message.set_name('AHL', 'AHL_RM_OPER_ERROR_SUB');

Line 101: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

97: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
98: l_subject_rej:= fnd_message.get;
99:
100: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_APRVS_SUB');
101: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
102: l_subject_aprvd:= fnd_message.get;
103:
104: fnd_message.set_name('AHL', 'AHL_RM_OPER_ERROR_SUB');
105: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 102: l_subject_aprvd:= fnd_message.get;

98: l_subject_rej:= fnd_message.get;
99:
100: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_APRVS_SUB');
101: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
102: l_subject_aprvd:= fnd_message.get;
103:
104: fnd_message.set_name('AHL', 'AHL_RM_OPER_ERROR_SUB');
105: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
106: l_subject_err:= fnd_message.get;

Line 104: fnd_message.set_name('AHL', 'AHL_RM_OPER_ERROR_SUB');

100: fnd_message.set_name('AHL', 'AHL_RM_OPER_AFT_APPR_APRVS_SUB');
101: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
102: l_subject_aprvd:= fnd_message.get;
103:
104: fnd_message.set_name('AHL', 'AHL_RM_OPER_ERROR_SUB');
105: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
106: l_subject_err:= fnd_message.get;
107: ELSE
108: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

Line 105: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

101: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
102: l_subject_aprvd:= fnd_message.get;
103:
104: fnd_message.set_name('AHL', 'AHL_RM_OPER_ERROR_SUB');
105: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
106: l_subject_err:= fnd_message.get;
107: ELSE
108: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
109: l_subject_err:= fnd_message.get;

Line 106: l_subject_err:= fnd_message.get;

102: l_subject_aprvd:= fnd_message.get;
103:
104: fnd_message.set_name('AHL', 'AHL_RM_OPER_ERROR_SUB');
105: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
106: l_subject_err:= fnd_message.get;
107: ELSE
108: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
109: l_subject_err:= fnd_message.get;
110: l_subject_err:= l_subject_err||to_char(l_object_id);

Line 108: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

104: fnd_message.set_name('AHL', 'AHL_RM_OPER_ERROR_SUB');
105: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
106: l_subject_err:= fnd_message.get;
107: ELSE
108: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
109: l_subject_err:= fnd_message.get;
110: l_subject_err:= l_subject_err||to_char(l_object_id);
111: END IF;
112: CLOSE GetOperationDet;

Line 109: l_subject_err:= fnd_message.get;

105: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
106: l_subject_err:= fnd_message.get;
107: ELSE
108: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
109: l_subject_err:= fnd_message.get;
110: l_subject_err:= l_subject_err||to_char(l_object_id);
111: END IF;
112: CLOSE GetOperationDet;
113:

Line 311: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

307: FETCH GetOperationDet into l_operation_rec;
308:
309: IF GetOperationDet%NOTFOUND
310: THEN
311: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
312: l_body := fnd_message.get;
313: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
314: ELSE
315: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_CONTENT');

Line 312: l_body := fnd_message.get;

308:
309: IF GetOperationDet%NOTFOUND
310: THEN
311: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
312: l_body := fnd_message.get;
313: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
314: ELSE
315: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_CONTENT');
316: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 315: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_CONTENT');

311: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
312: l_body := fnd_message.get;
313: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
314: ELSE
315: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_CONTENT');
316: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
317: fnd_message.set_token('NAME',l_fullname, false);
318: l_body := fnd_message.get;
319: END IF;

Line 316: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

312: l_body := fnd_message.get;
313: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
314: ELSE
315: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_CONTENT');
316: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
317: fnd_message.set_token('NAME',l_fullname, false);
318: l_body := fnd_message.get;
319: END IF;
320: CLOSE GetOperationDet;

Line 317: fnd_message.set_token('NAME',l_fullname, false);

313: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
314: ELSE
315: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_CONTENT');
316: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
317: fnd_message.set_token('NAME',l_fullname, false);
318: l_body := fnd_message.get;
319: END IF;
320: CLOSE GetOperationDet;
321:

Line 318: l_body := fnd_message.get;

314: ELSE
315: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_CONTENT');
316: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
317: fnd_message.set_token('NAME',l_fullname, false);
318: l_body := fnd_message.get;
319: END IF;
320: CLOSE GetOperationDet;
321:
322: /*--------------------------------------------------------------------------

Line 324: -- that will be used to replace tokens defined in FND Messages.

320: CLOSE GetOperationDet;
321:
322: /*--------------------------------------------------------------------------
323: -- Query approval object table for any detail information of this object
324: -- that will be used to replace tokens defined in FND Messages.
325: -- Here to simplify, we are using hard-coded messages.
326: ----------------------------------------------------------------------------*/
327:
328: -- if nvl(l_fname,l_approver);

Line 424: -- that will be used to replace tokens defined in FND Messages.

420: );
421:
422: /*--------------------------------------------------------------------------
423: -- Query approval object table for any detail information of this object
424: -- that will be used to replace tokens defined in FND Messages.
425: -- Here to simplify, we are using hard-coded messages.
426: ----------------------------------------------------------------------------*/
427: OPEN GetOperationDet(l_object_id);
428: FETCH GetOperationDet into l_operation_rec;

Line 432: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

428: FETCH GetOperationDet into l_operation_rec;
429:
430: IF GetOperationDet%NOTFOUND
431: THEN
432: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
433: l_body := fnd_message.get;
434: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
435: ELSE
436: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

Line 433: l_body := fnd_message.get;

429:
430: IF GetOperationDet%NOTFOUND
431: THEN
432: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
433: l_body := fnd_message.get;
434: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
435: ELSE
436: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
437: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 436: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

432: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
433: l_body := fnd_message.get;
434: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
435: ELSE
436: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
437: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
438: l_body := fnd_message.get;
439: END IF;
440: CLOSE GetOperationDet;

Line 437: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

433: l_body := fnd_message.get;
434: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
435: ELSE
436: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
437: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
438: l_body := fnd_message.get;
439: END IF;
440: CLOSE GetOperationDet;
441:

Line 438: l_body := fnd_message.get;

434: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
435: ELSE
436: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
437: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
438: l_body := fnd_message.get;
439: END IF;
440: CLOSE GetOperationDet;
441:
442: GET_FULLNAME

Line 534: -- that will be used to replace tokens defined in FND Messages.

530:
531:
532: /*--------------------------------------------------------------------------
533: -- Query approval object table for any detail information of this object
534: -- that will be used to replace tokens defined in FND Messages.
535: -- Here to simplify, we are using hard-coded messages.
536: ----------------------------------------------------------------------------*/
537:
538: OPEN GetOperationDet(l_object_id);

Line 543: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

539: FETCH GetOperationDet into l_operation_rec;
540:
541: IF GetOperationDet%NOTFOUND
542: THEN
543: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
544: l_body := fnd_message.get;
545: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
546: ELSE
547: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

Line 544: l_body := fnd_message.get;

540:
541: IF GetOperationDet%NOTFOUND
542: THEN
543: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
544: l_body := fnd_message.get;
545: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
546: ELSE
547: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
548: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 547: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

543: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
544: l_body := fnd_message.get;
545: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
546: ELSE
547: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
548: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
549: l_body := fnd_message.get;
550: END IF;
551: CLOSE GetOperationDet;

Line 548: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

544: l_body := fnd_message.get;
545: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
546: ELSE
547: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
548: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
549: l_body := fnd_message.get;
550: END IF;
551: CLOSE GetOperationDet;
552:

Line 549: l_body := fnd_message.get;

545: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
546: ELSE
547: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
548: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
549: l_body := fnd_message.get;
550: END IF;
551: CLOSE GetOperationDet;
552:
553:

Line 646: -- that will be used to replace tokens defined in FND Messages.

642: );
643:
644: /*--------------------------------------------------------------------------
645: -- Query approval object table for any detail information of this object
646: -- that will be used to replace tokens defined in FND Messages.
647: -- Here to simplify, we are using hard-coded messages.
648: ----------------------------------------------------------------------------*/
649: OPEN GetOperationDet(l_object_id);
650: FETCH GetOperationDet into l_operation_rec;

Line 654: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

650: FETCH GetOperationDet into l_operation_rec;
651:
652: IF GetOperationDet%NOTFOUND
653: THEN
654: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
655: l_body := fnd_message.get;
656: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
657: ELSE
658: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

Line 655: l_body := fnd_message.get;

651:
652: IF GetOperationDet%NOTFOUND
653: THEN
654: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
655: l_body := fnd_message.get;
656: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
657: ELSE
658: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
659: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 658: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

654: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
655: l_body := fnd_message.get;
656: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
657: ELSE
658: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
659: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
660: l_body := fnd_message.get;
661: END IF;
662: CLOSE GetOperationDet;

Line 659: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

655: l_body := fnd_message.get;
656: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
657: ELSE
658: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
659: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
660: l_body := fnd_message.get;
661: END IF;
662: CLOSE GetOperationDet;
663:

Line 660: l_body := fnd_message.get;

656: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
657: ELSE
658: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
659: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
660: l_body := fnd_message.get;
661: END IF;
662: CLOSE GetOperationDet;
663:
664: GET_FULLNAME

Line 772: -- that will be used to replace tokens defined in FND Messages.

768:
769: commit;
770: /*--------------------------------------------------------------------------
771: -- Query approval object table for any detail information of this object
772: -- that will be used to replace tokens defined in FND Messages.
773: -- Here to simplify, we are using hard-coded messages.
774: ----------------------------------------------------------------------------*/
775:
776: OPEN GetOperationDet(l_object_id);

Line 781: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

777: FETCH GetOperationDet into l_operation_rec;
778:
779: IF GetOperationDet%FOUND
780: THEN
781: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
782: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
783: l_body := fnd_message.get;
784: ELSE
785: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

Line 782: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

778:
779: IF GetOperationDet%FOUND
780: THEN
781: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
782: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
783: l_body := fnd_message.get;
784: ELSE
785: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
786: l_body := fnd_message.get;

Line 783: l_body := fnd_message.get;

779: IF GetOperationDet%FOUND
780: THEN
781: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
782: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
783: l_body := fnd_message.get;
784: ELSE
785: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
786: l_body := fnd_message.get;
787: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);

Line 785: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

781: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
782: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
783: l_body := fnd_message.get;
784: ELSE
785: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
786: l_body := fnd_message.get;
787: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
788: END IF;
789: CLOSE GetOperationDet;

Line 786: l_body := fnd_message.get;

782: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
783: l_body := fnd_message.get;
784: ELSE
785: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
786: l_body := fnd_message.get;
787: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
788: END IF;
789: CLOSE GetOperationDet;
790:

Line 898: -- that will be used to replace tokens defined in FND Messages.

894:
895:
896: /*--------------------------------------------------------------------------
897: -- Query approval object table for any detail information of this object
898: -- that will be used to replace tokens defined in FND Messages.
899: -- Here to simplify, we are using hard-coded messages.
900: ----------------------------------------------------------------------------*/
901: OPEN GetOperationDet(l_object_id);
902: FETCH GetOperationDet into l_operation_rec;

Line 906: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

902: FETCH GetOperationDet into l_operation_rec;
903:
904: IF GetOperationDet%NOTFOUND
905: THEN
906: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
907: l_body := fnd_message.get;
908: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
909: ELSE
910: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

Line 907: l_body := fnd_message.get;

903:
904: IF GetOperationDet%NOTFOUND
905: THEN
906: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
907: l_body := fnd_message.get;
908: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
909: ELSE
910: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
911: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 910: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

906: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
907: l_body := fnd_message.get;
908: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
909: ELSE
910: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
911: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
912: l_body := fnd_message.get;
913: END IF;
914: CLOSE GetOperationDet;

Line 911: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

907: l_body := fnd_message.get;
908: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
909: ELSE
910: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
911: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
912: l_body := fnd_message.get;
913: END IF;
914: CLOSE GetOperationDet;
915:

Line 912: l_body := fnd_message.get;

908: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
909: ELSE
910: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
911: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
912: l_body := fnd_message.get;
913: END IF;
914: CLOSE GetOperationDet;
915:
916: GET_FULLNAME

Line 1021: -- that will be used to replace tokens defined in FND Messages.

1017: );
1018:
1019: /*--------------------------------------------------------------------------
1020: -- Query approval object table for any detail information of this object
1021: -- that will be used to replace tokens defined in FND Messages.
1022: -- Here to simplify, we are using hard-coded messages.
1023: ----------------------------------------------------------------------------*/
1024:
1025: OPEN GetOperationDet(l_object_id);

Line 1030: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

1026: FETCH GetOperationDet into l_operation_rec;
1027:
1028: IF GetOperationDet%NOTFOUND
1029: THEN
1030: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
1031: l_body := fnd_message.get;
1032: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

Line 1031: l_body := fnd_message.get;

1027:
1028: IF GetOperationDet%NOTFOUND
1029: THEN
1030: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
1031: l_body := fnd_message.get;
1032: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
1035: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

Line 1034: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');

1030: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
1031: l_body := fnd_message.get;
1032: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
1035: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
1036: l_body := fnd_message.get;
1037: END IF;
1038: CLOSE GetOperationDet;

Line 1035: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);

1031: l_body := fnd_message.get;
1032: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
1035: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
1036: l_body := fnd_message.get;
1037: END IF;
1038: CLOSE GetOperationDet;
1039:

Line 1036: l_body := fnd_message.get;

1032: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
1033: ELSE
1034: fnd_message.set_name('AHL', 'AHL_RM_OPERNTF_FORWARD_SUBJECT');
1035: fnd_message.set_token('SEGMENT',l_operation_rec.SEGMENT, false);
1036: l_body := fnd_message.get;
1037: END IF;
1038: CLOSE GetOperationDet;
1039:
1040:

Line 1173: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');

1169: OPEN GetOperationDet(l_object_id);
1170: FETCH GetOperationDet INTO l_operation_rec;
1171: IF GetOperationDet%notfound
1172: then
1173: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
1174: l_body := fnd_message.get;
1175: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
1176: end if;
1177:

Line 1174: l_body := fnd_message.get;

1170: FETCH GetOperationDet INTO l_operation_rec;
1171: IF GetOperationDet%notfound
1172: then
1173: fnd_message.set_name('AHL', 'AHL_RM_INVALID_OPERATION');
1174: l_body := fnd_message.get;
1175: l_body:=l_body||'-'||to_char(l_operation_rec.OPERATION_ID);
1176: end if;
1177:
1178: CLOSE GetOperationDet;