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');
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);
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;
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');
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);
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;
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');
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);
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;
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');
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);
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;
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');
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;
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);
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;
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:
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');
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);
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;
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;
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:
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: /*--------------------------------------------------------------------------
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);
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;
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');
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);
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;
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:
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
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);
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');
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);
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;
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:
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:
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;
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');
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);
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;
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:
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
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);
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');
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;
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);
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;
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:
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;
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');
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);
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;
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:
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
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);
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');
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);
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;
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:
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:
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:
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;