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_ITEMGROUPS_APPROVAL_PVT dependencies on FND_MESSAGE

Line 94: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');

90: FETCH GetItemGroupDet into l_item_group_rec;
91:
92: IF GetItemGroupDet%NOTFOUND
93: THEN
94: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
95: fnd_message.set_token('ItemGroup_id',l_object_id,false);
96: l_subject := fnd_message.get;
97: ELSE
98: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

Line 95: fnd_message.set_token('ItemGroup_id',l_object_id,false);

91:
92: IF GetItemGroupDet%NOTFOUND
93: THEN
94: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
95: fnd_message.set_token('ItemGroup_id',l_object_id,false);
96: l_subject := fnd_message.get;
97: ELSE
98: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
99: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

Line 96: l_subject := fnd_message.get;

92: IF GetItemGroupDet%NOTFOUND
93: THEN
94: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
95: fnd_message.set_token('ItemGroup_id',l_object_id,false);
96: l_subject := fnd_message.get;
97: ELSE
98: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
99: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
100: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

Line 98: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

94: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
95: fnd_message.set_token('ItemGroup_id',l_object_id,false);
96: l_subject := fnd_message.get;
97: ELSE
98: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
99: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
100: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
101: l_subject := fnd_message.get;
102: END IF;

Line 99: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

95: fnd_message.set_token('ItemGroup_id',l_object_id,false);
96: l_subject := fnd_message.get;
97: ELSE
98: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
99: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
100: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
101: l_subject := fnd_message.get;
102: END IF;
103: CLOSE GetItemGroupDet;

Line 100: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

96: l_subject := fnd_message.get;
97: ELSE
98: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
99: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
100: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
101: l_subject := fnd_message.get;
102: END IF;
103: CLOSE GetItemGroupDet;
104:

Line 101: l_subject := fnd_message.get;

97: ELSE
98: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
99: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
100: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
101: l_subject := fnd_message.get;
102: END IF;
103: CLOSE GetItemGroupDet;
104:
105: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 367: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');

363: FETCH GetItemGroupDet into l_item_group_rec;
364:
365: IF GetItemGroupDet%NOTFOUND
366: THEN
367: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
368: fnd_message.set_token('GROUP_ID',l_object_id,false);
369: l_body := fnd_message.get;
370: ELSE
371: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

Line 368: fnd_message.set_token('GROUP_ID',l_object_id,false);

364:
365: IF GetItemGroupDet%NOTFOUND
366: THEN
367: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
368: fnd_message.set_token('GROUP_ID',l_object_id,false);
369: l_body := fnd_message.get;
370: ELSE
371: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
372: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

Line 369: l_body := fnd_message.get;

365: IF GetItemGroupDet%NOTFOUND
366: THEN
367: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
368: fnd_message.set_token('GROUP_ID',l_object_id,false);
369: l_body := fnd_message.get;
370: ELSE
371: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
372: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
373: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

Line 371: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

367: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
368: fnd_message.set_token('GROUP_ID',l_object_id,false);
369: l_body := fnd_message.get;
370: ELSE
371: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
372: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
373: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
374: l_body := fnd_message.get;
375: END IF;

Line 372: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

368: fnd_message.set_token('GROUP_ID',l_object_id,false);
369: l_body := fnd_message.get;
370: ELSE
371: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
372: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
373: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
374: l_body := fnd_message.get;
375: END IF;
376: CLOSE GetItemGroupDet;

Line 373: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

369: l_body := fnd_message.get;
370: ELSE
371: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
372: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
373: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
374: l_body := fnd_message.get;
375: END IF;
376: CLOSE GetItemGroupDet;
377:

Line 374: l_body := fnd_message.get;

370: ELSE
371: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
372: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
373: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
374: l_body := fnd_message.get;
375: END IF;
376: CLOSE GetItemGroupDet;
377:
378:

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

377:
378:
379: /*--------------------------------------------------------------------------
380: -- Query approval object table for any detail information of this object
381: -- that will be used to replace tokens defined in FND Messages.
382: -- Here to simplify, we are using hard-coded messages.
383: ----------------------------------------------------------------------------*/
384:
385: l_body := l_body||'.'||'Your request has been forwarded to ' ||l_approver||' for approval' ;

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

484: );
485:
486: /*--------------------------------------------------------------------------
487: -- Query approval object table for any detail information of this object
488: -- that will be used to replace tokens defined in FND Messages.
489: -- Here to simplify, we are using hard-coded messages.
490: ----------------------------------------------------------------------------*/
491: OPEN GetItemGroupDet(l_object_id);
492: FETCH GetItemGroupDet into l_item_group_rec;

Line 496: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');

492: FETCH GetItemGroupDet into l_item_group_rec;
493:
494: IF GetItemGroupDet%NOTFOUND
495: THEN
496: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
497: fnd_message.set_token('GROUP_ID',l_object_id,false);
498: l_body := fnd_message.get;
499: ELSE
500: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

Line 497: fnd_message.set_token('GROUP_ID',l_object_id,false);

493:
494: IF GetItemGroupDet%NOTFOUND
495: THEN
496: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
497: fnd_message.set_token('GROUP_ID',l_object_id,false);
498: l_body := fnd_message.get;
499: ELSE
500: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
501: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

Line 498: l_body := fnd_message.get;

494: IF GetItemGroupDet%NOTFOUND
495: THEN
496: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
497: fnd_message.set_token('GROUP_ID',l_object_id,false);
498: l_body := fnd_message.get;
499: ELSE
500: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
501: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
502: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

Line 500: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

496: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
497: fnd_message.set_token('GROUP_ID',l_object_id,false);
498: l_body := fnd_message.get;
499: ELSE
500: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
501: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
502: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
503: l_body := fnd_message.get;
504: END IF;

Line 501: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

497: fnd_message.set_token('GROUP_ID',l_object_id,false);
498: l_body := fnd_message.get;
499: ELSE
500: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
501: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
502: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
503: l_body := fnd_message.get;
504: END IF;
505: CLOSE GetItemGroupDet;

Line 502: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

498: l_body := fnd_message.get;
499: ELSE
500: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
501: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
502: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
503: l_body := fnd_message.get;
504: END IF;
505: CLOSE GetItemGroupDet;
506:

Line 503: l_body := fnd_message.get;

499: ELSE
500: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
501: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
502: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
503: l_body := fnd_message.get;
504: END IF;
505: CLOSE GetItemGroupDet;
506:
507:

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

635:
636:
637: /*--------------------------------------------------------------------------
638: -- Query approval object table for any detail information of this object
639: -- that will be used to replace tokens defined in FND Messages.
640: -- Here to simplify, we are using hard-coded messages.
641: ----------------------------------------------------------------------------*/
642:
643: OPEN GetItemGroupDet(l_object_id);

Line 648: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');

644: FETCH GetItemGroupDet into l_item_group_rec;
645:
646: IF GetItemGroupDet%NOTFOUND
647: THEN
648: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
649: fnd_message.set_token('GROUP_ID',l_object_id,false);
650: l_body := fnd_message.get;
651: ELSE
652: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

Line 649: fnd_message.set_token('GROUP_ID',l_object_id,false);

645:
646: IF GetItemGroupDet%NOTFOUND
647: THEN
648: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
649: fnd_message.set_token('GROUP_ID',l_object_id,false);
650: l_body := fnd_message.get;
651: ELSE
652: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
653: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

Line 650: l_body := fnd_message.get;

646: IF GetItemGroupDet%NOTFOUND
647: THEN
648: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
649: fnd_message.set_token('GROUP_ID',l_object_id,false);
650: l_body := fnd_message.get;
651: ELSE
652: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
653: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
654: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

Line 652: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

648: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
649: fnd_message.set_token('GROUP_ID',l_object_id,false);
650: l_body := fnd_message.get;
651: ELSE
652: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
653: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
654: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
655: l_body := fnd_message.get;
656: END IF;

Line 653: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

649: fnd_message.set_token('GROUP_ID',l_object_id,false);
650: l_body := fnd_message.get;
651: ELSE
652: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
653: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
654: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
655: l_body := fnd_message.get;
656: END IF;
657: CLOSE GetItemGroupDet;

Line 654: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

650: l_body := fnd_message.get;
651: ELSE
652: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
653: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
654: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
655: l_body := fnd_message.get;
656: END IF;
657: CLOSE GetItemGroupDet;
658:

Line 655: l_body := fnd_message.get;

651: ELSE
652: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
653: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
654: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
655: l_body := fnd_message.get;
656: END IF;
657: CLOSE GetItemGroupDet;
658:
659:

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

783: );
784:
785: /*--------------------------------------------------------------------------
786: -- Query approval object table for any detail information of this object
787: -- that will be used to replace tokens defined in FND Messages.
788: -- Here to simplify, we are using hard-coded messages.
789: ----------------------------------------------------------------------------*/
790: OPEN GetItemGroupDet(l_object_id);
791: FETCH GetItemGroupDet into l_item_group_rec;

Line 795: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');

791: FETCH GetItemGroupDet into l_item_group_rec;
792:
793: IF GetItemGroupDet%NOTFOUND
794: THEN
795: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
796: fnd_message.set_token('GROUP_ID',l_object_id,false);
797: l_body := fnd_message.get;
798: ELSE
799: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

Line 796: fnd_message.set_token('GROUP_ID',l_object_id,false);

792:
793: IF GetItemGroupDet%NOTFOUND
794: THEN
795: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
796: fnd_message.set_token('GROUP_ID',l_object_id,false);
797: l_body := fnd_message.get;
798: ELSE
799: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
800: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

Line 797: l_body := fnd_message.get;

793: IF GetItemGroupDet%NOTFOUND
794: THEN
795: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
796: fnd_message.set_token('GROUP_ID',l_object_id,false);
797: l_body := fnd_message.get;
798: ELSE
799: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
800: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
801: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

Line 799: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

795: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
796: fnd_message.set_token('GROUP_ID',l_object_id,false);
797: l_body := fnd_message.get;
798: ELSE
799: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
800: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
801: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
802: l_body := fnd_message.get;
803: END IF;

Line 800: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

796: fnd_message.set_token('GROUP_ID',l_object_id,false);
797: l_body := fnd_message.get;
798: ELSE
799: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
800: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
801: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
802: l_body := fnd_message.get;
803: END IF;
804: CLOSE GetItemGroupDet;

Line 801: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

797: l_body := fnd_message.get;
798: ELSE
799: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
800: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
801: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
802: l_body := fnd_message.get;
803: END IF;
804: CLOSE GetItemGroupDet;
805:

Line 802: l_body := fnd_message.get;

798: ELSE
799: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
800: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
801: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
802: l_body := fnd_message.get;
803: END IF;
804: CLOSE GetItemGroupDet;
805:
806:

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

937:
938: commit;
939: /*--------------------------------------------------------------------------
940: -- Query approval object table for any detail information of this object
941: -- that will be used to replace tokens defined in FND Messages.
942: -- Here to simplify, we are using hard-coded messages.
943: ----------------------------------------------------------------------------*/
944:
945: OPEN GetItemGroupDet(l_object_id);

Line 950: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');

946: FETCH GetItemGroupDet into l_item_group_rec;
947:
948: IF GetItemGroupDet%NOTFOUND
949: THEN
950: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
951: fnd_message.set_token('GROUP_ID',l_object_id,false);
952: l_body := fnd_message.get;
953: ELSE
954: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

Line 951: fnd_message.set_token('GROUP_ID',l_object_id,false);

947:
948: IF GetItemGroupDet%NOTFOUND
949: THEN
950: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
951: fnd_message.set_token('GROUP_ID',l_object_id,false);
952: l_body := fnd_message.get;
953: ELSE
954: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
955: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

Line 952: l_body := fnd_message.get;

948: IF GetItemGroupDet%NOTFOUND
949: THEN
950: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
951: fnd_message.set_token('GROUP_ID',l_object_id,false);
952: l_body := fnd_message.get;
953: ELSE
954: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
955: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
956: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

Line 954: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

950: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
951: fnd_message.set_token('GROUP_ID',l_object_id,false);
952: l_body := fnd_message.get;
953: ELSE
954: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
955: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
956: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
957: l_body := fnd_message.get;
958: END IF;

Line 955: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

951: fnd_message.set_token('GROUP_ID',l_object_id,false);
952: l_body := fnd_message.get;
953: ELSE
954: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
955: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
956: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
957: l_body := fnd_message.get;
958: END IF;
959: CLOSE GetItemGroupDet;

Line 956: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

952: l_body := fnd_message.get;
953: ELSE
954: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
955: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
956: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
957: l_body := fnd_message.get;
958: END IF;
959: CLOSE GetItemGroupDet;
960:

Line 957: l_body := fnd_message.get;

953: ELSE
954: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
955: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
956: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
957: l_body := fnd_message.get;
958: END IF;
959: CLOSE GetItemGroupDet;
960:
961:

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

1094:
1095:
1096: /*--------------------------------------------------------------------------
1097: -- Query approval object table for any detail information of this object
1098: -- that will be used to replace tokens defined in FND Messages.
1099: -- Here to simplify, we are using hard-coded messages.
1100: ----------------------------------------------------------------------------*/
1101: OPEN GetItemGroupDet(l_object_id);
1102: FETCH GetItemGroupDet into l_item_group_rec;

Line 1106: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');

1102: FETCH GetItemGroupDet into l_item_group_rec;
1103:
1104: IF GetItemGroupDet%NOTFOUND
1105: THEN
1106: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
1107: fnd_message.set_token('GROUP_ID',l_object_id,false);
1108: l_body := fnd_message.get;
1109: ELSE
1110: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

Line 1107: fnd_message.set_token('GROUP_ID',l_object_id,false);

1103:
1104: IF GetItemGroupDet%NOTFOUND
1105: THEN
1106: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
1107: fnd_message.set_token('GROUP_ID',l_object_id,false);
1108: l_body := fnd_message.get;
1109: ELSE
1110: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1111: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

Line 1108: l_body := fnd_message.get;

1104: IF GetItemGroupDet%NOTFOUND
1105: THEN
1106: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
1107: fnd_message.set_token('GROUP_ID',l_object_id,false);
1108: l_body := fnd_message.get;
1109: ELSE
1110: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1111: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1112: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

Line 1110: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

1106: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
1107: fnd_message.set_token('GROUP_ID',l_object_id,false);
1108: l_body := fnd_message.get;
1109: ELSE
1110: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1111: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1112: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
1113: l_body := fnd_message.get;
1114: END IF;

Line 1111: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

1107: fnd_message.set_token('GROUP_ID',l_object_id,false);
1108: l_body := fnd_message.get;
1109: ELSE
1110: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1111: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1112: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
1113: l_body := fnd_message.get;
1114: END IF;
1115: CLOSE GetItemGroupDet;

Line 1112: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

1108: l_body := fnd_message.get;
1109: ELSE
1110: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1111: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1112: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
1113: l_body := fnd_message.get;
1114: END IF;
1115: CLOSE GetItemGroupDet;
1116:

Line 1113: l_body := fnd_message.get;

1109: ELSE
1110: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1111: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1112: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
1113: l_body := fnd_message.get;
1114: END IF;
1115: CLOSE GetItemGroupDet;
1116:
1117:

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

1244: );
1245:
1246: /*--------------------------------------------------------------------------
1247: -- Query approval object table for any detail information of this object
1248: -- that will be used to replace tokens defined in FND Messages.
1249: -- Here to simplify, we are using hard-coded messages.
1250: ----------------------------------------------------------------------------*/
1251:
1252: OPEN GetItemGroupDet(l_object_id);

Line 1257: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');

1253: FETCH GetItemGroupDet into l_item_group_rec;
1254:
1255: IF GetItemGroupDet%NOTFOUND
1256: THEN
1257: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
1258: fnd_message.set_token('GROUP_ID',l_object_id,false);
1259: l_body := fnd_message.get;
1260: ELSE
1261: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

Line 1258: fnd_message.set_token('GROUP_ID',l_object_id,false);

1254:
1255: IF GetItemGroupDet%NOTFOUND
1256: THEN
1257: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
1258: fnd_message.set_token('GROUP_ID',l_object_id,false);
1259: l_body := fnd_message.get;
1260: ELSE
1261: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1262: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

Line 1259: l_body := fnd_message.get;

1255: IF GetItemGroupDet%NOTFOUND
1256: THEN
1257: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
1258: fnd_message.set_token('GROUP_ID',l_object_id,false);
1259: l_body := fnd_message.get;
1260: ELSE
1261: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1262: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1263: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

Line 1261: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');

1257: fnd_message.set_name('AHL', 'AHL_ITEMGROUPS_ID_INVALID');
1258: fnd_message.set_token('GROUP_ID',l_object_id,false);
1259: l_body := fnd_message.get;
1260: ELSE
1261: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1262: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1263: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
1264: l_body := fnd_message.get;
1265: END IF;

Line 1262: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);

1258: fnd_message.set_token('GROUP_ID',l_object_id,false);
1259: l_body := fnd_message.get;
1260: ELSE
1261: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1262: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1263: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
1264: l_body := fnd_message.get;
1265: END IF;
1266: CLOSE GetItemGroupDet;

Line 1263: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);

1259: l_body := fnd_message.get;
1260: ELSE
1261: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1262: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1263: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
1264: l_body := fnd_message.get;
1265: END IF;
1266: CLOSE GetItemGroupDet;
1267:

Line 1264: l_body := fnd_message.get;

1260: ELSE
1261: fnd_message.set_name('AHL', 'AHL_MC_NTF_ALT_PRT_FWD_SUB');
1262: fnd_message.set_token('GROUPNAME',l_item_group_rec.name ,false);
1263: fnd_message.set_token('GROUP_ID',l_item_group_rec.item_group_id, false);
1264: l_body := fnd_message.get;
1265: END IF;
1266: CLOSE GetItemGroupDet;
1267:
1268:

Line 1459: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');

1455: END IF;
1456:
1457: if (sql%notfound)
1458: then
1459: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1460: FND_MSG_PUB.Add;
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462: End if;
1463:

Line 1638: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');

1634:
1635:
1636: if (sql%notfound)
1637: then
1638: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1639: FND_MSG_PUB.Add;
1640:
1641: l_return_status := FND_API.G_RET_STS_ERROR;
1642: return;