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

Line 65: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');

61: FETCH GetRouteDet into l_route_rec;
62:
63: IF GetRouteDet%NOTFOUND
64: THEN
65: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
66: fnd_message.set_token('route_id',l_route_rec.route_id,false);
67: l_subject := fnd_message.get;
68: ELSE
69: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

Line 66: fnd_message.set_token('route_id',l_route_rec.route_id,false);

62:
63: IF GetRouteDet%NOTFOUND
64: THEN
65: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
66: fnd_message.set_token('route_id',l_route_rec.route_id,false);
67: l_subject := fnd_message.get;
68: ELSE
69: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
70: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

Line 67: l_subject := fnd_message.get;

63: IF GetRouteDet%NOTFOUND
64: THEN
65: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
66: fnd_message.set_token('route_id',l_route_rec.route_id,false);
67: l_subject := fnd_message.get;
68: ELSE
69: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
70: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
71: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

Line 69: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

65: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
66: fnd_message.set_token('route_id',l_route_rec.route_id,false);
67: l_subject := fnd_message.get;
68: ELSE
69: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
70: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
71: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
72: l_subject := fnd_message.get;
73: END IF;

Line 70: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

66: fnd_message.set_token('route_id',l_route_rec.route_id,false);
67: l_subject := fnd_message.get;
68: ELSE
69: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
70: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
71: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
72: l_subject := fnd_message.get;
73: END IF;
74: CLOSE GetRouteDet;

Line 71: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

67: l_subject := fnd_message.get;
68: ELSE
69: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
70: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
71: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
72: l_subject := fnd_message.get;
73: END IF;
74: CLOSE GetRouteDet;
75: IF G_DEBUG='Y' THEN

Line 72: l_subject := fnd_message.get;

68: ELSE
69: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
70: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
71: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
72: l_subject := fnd_message.get;
73: END IF;
74: CLOSE GetRouteDet;
75: IF G_DEBUG='Y' THEN
76: AHL_DEBUG_PUB.debug( 'Route No'||l_route_rec.route_no,'+DebugWfRoute+');

Line 309: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');

305: FETCH GetRouteDet into l_route_rec;
306:
307: IF GetRouteDet%NOTFOUND
308: THEN
309: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
310: fnd_message.set_token('route_id',l_route_rec.route_id,false);
311: l_body := fnd_message.get;
312: ELSE
313: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

Line 310: fnd_message.set_token('route_id',l_route_rec.route_id,false);

306:
307: IF GetRouteDet%NOTFOUND
308: THEN
309: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
310: fnd_message.set_token('route_id',l_route_rec.route_id,false);
311: l_body := fnd_message.get;
312: ELSE
313: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
314: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

Line 311: l_body := fnd_message.get;

307: IF GetRouteDet%NOTFOUND
308: THEN
309: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
310: fnd_message.set_token('route_id',l_route_rec.route_id,false);
311: l_body := fnd_message.get;
312: ELSE
313: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
314: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
315: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

Line 313: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

309: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
310: fnd_message.set_token('route_id',l_route_rec.route_id,false);
311: l_body := fnd_message.get;
312: ELSE
313: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
314: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
315: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
316: l_body := fnd_message.get;
317: END IF;

Line 314: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

310: fnd_message.set_token('route_id',l_route_rec.route_id,false);
311: l_body := fnd_message.get;
312: ELSE
313: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
314: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
315: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
316: l_body := fnd_message.get;
317: END IF;
318: CLOSE GetRouteDet;

Line 315: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

311: l_body := fnd_message.get;
312: ELSE
313: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
314: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
315: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
316: l_body := fnd_message.get;
317: END IF;
318: CLOSE GetRouteDet;
319:

Line 316: l_body := fnd_message.get;

312: ELSE
313: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
314: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
315: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
316: l_body := fnd_message.get;
317: END IF;
318: CLOSE GetRouteDet;
319:
320: /*--------------------------------------------------------------------------

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

318: CLOSE GetRouteDet;
319:
320: /*--------------------------------------------------------------------------
321: -- Query approval object table for any detail information of this object
322: -- that will be used to replace tokens defined in FND Messages.
323: -- Here to simplify, we are using hard-coded messages.
324: ----------------------------------------------------------------------------*/
325:
326: l_body := l_body||'.'||'Your request has been forwarded to ' ||l_approver||' for approval' ;

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

412: );
413:
414: /*--------------------------------------------------------------------------
415: -- Query approval object table for any detail information of this object
416: -- that will be used to replace tokens defined in FND Messages.
417: -- Here to simplify, we are using hard-coded messages.
418: ----------------------------------------------------------------------------*/
419: OPEN GetRouteDet(l_object_id);
420: FETCH GetRouteDet into l_route_rec;

Line 424: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');

420: FETCH GetRouteDet into l_route_rec;
421:
422: IF GetRouteDet%NOTFOUND
423: THEN
424: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
425: fnd_message.set_token('route_id',l_route_rec.route_id,false);
426: l_body := fnd_message.get;
427: ELSE
428: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

Line 425: fnd_message.set_token('route_id',l_route_rec.route_id,false);

421:
422: IF GetRouteDet%NOTFOUND
423: THEN
424: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
425: fnd_message.set_token('route_id',l_route_rec.route_id,false);
426: l_body := fnd_message.get;
427: ELSE
428: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
429: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

Line 426: l_body := fnd_message.get;

422: IF GetRouteDet%NOTFOUND
423: THEN
424: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
425: fnd_message.set_token('route_id',l_route_rec.route_id,false);
426: l_body := fnd_message.get;
427: ELSE
428: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
429: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
430: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

Line 428: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

424: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
425: fnd_message.set_token('route_id',l_route_rec.route_id,false);
426: l_body := fnd_message.get;
427: ELSE
428: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
429: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
430: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
431: l_body := fnd_message.get;
432: END IF;

Line 429: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

425: fnd_message.set_token('route_id',l_route_rec.route_id,false);
426: l_body := fnd_message.get;
427: ELSE
428: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
429: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
430: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
431: l_body := fnd_message.get;
432: END IF;
433: CLOSE GetRouteDet;

Line 430: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

426: l_body := fnd_message.get;
427: ELSE
428: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
429: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
430: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
431: l_body := fnd_message.get;
432: END IF;
433: CLOSE GetRouteDet;
434:

Line 431: l_body := fnd_message.get;

427: ELSE
428: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
429: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
430: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
431: l_body := fnd_message.get;
432: END IF;
433: CLOSE GetRouteDet;
434:
435:

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

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

Line 540: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');

536: FETCH GetRouteDet into l_route_rec;
537:
538: IF GetRouteDet%NOTFOUND
539: THEN
540: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
541: fnd_message.set_token('route_id',l_route_rec.route_id,false);
542: l_body := fnd_message.get;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

Line 541: fnd_message.set_token('route_id',l_route_rec.route_id,false);

537:
538: IF GetRouteDet%NOTFOUND
539: THEN
540: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
541: fnd_message.set_token('route_id',l_route_rec.route_id,false);
542: l_body := fnd_message.get;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
545: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

Line 542: l_body := fnd_message.get;

538: IF GetRouteDet%NOTFOUND
539: THEN
540: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
541: fnd_message.set_token('route_id',l_route_rec.route_id,false);
542: l_body := fnd_message.get;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
545: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
546: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

Line 544: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

540: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
541: fnd_message.set_token('route_id',l_route_rec.route_id,false);
542: l_body := fnd_message.get;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
545: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
546: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
547: l_body := fnd_message.get;
548: END IF;

Line 545: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

541: fnd_message.set_token('route_id',l_route_rec.route_id,false);
542: l_body := fnd_message.get;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
545: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
546: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
547: l_body := fnd_message.get;
548: END IF;
549: CLOSE GetRouteDet;

Line 546: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

542: l_body := fnd_message.get;
543: ELSE
544: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
545: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
546: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
547: l_body := fnd_message.get;
548: END IF;
549: CLOSE GetRouteDet;
550:

Line 547: l_body := fnd_message.get;

543: ELSE
544: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
545: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
546: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
547: l_body := fnd_message.get;
548: END IF;
549: CLOSE GetRouteDet;
550:
551:

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

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

Line 656: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');

652: FETCH GetRouteDet into l_route_rec;
653:
654: IF GetRouteDet%NOTFOUND
655: THEN
656: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
657: fnd_message.set_token('route_id',l_route_rec.route_id,false);
658: l_body := fnd_message.get;
659: ELSE
660: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

Line 657: fnd_message.set_token('route_id',l_route_rec.route_id,false);

653:
654: IF GetRouteDet%NOTFOUND
655: THEN
656: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
657: fnd_message.set_token('route_id',l_route_rec.route_id,false);
658: l_body := fnd_message.get;
659: ELSE
660: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
661: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

Line 658: l_body := fnd_message.get;

654: IF GetRouteDet%NOTFOUND
655: THEN
656: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
657: fnd_message.set_token('route_id',l_route_rec.route_id,false);
658: l_body := fnd_message.get;
659: ELSE
660: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
661: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
662: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

Line 660: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

656: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
657: fnd_message.set_token('route_id',l_route_rec.route_id,false);
658: l_body := fnd_message.get;
659: ELSE
660: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
661: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
662: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
663: l_body := fnd_message.get;
664: END IF;

Line 661: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

657: fnd_message.set_token('route_id',l_route_rec.route_id,false);
658: l_body := fnd_message.get;
659: ELSE
660: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
661: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
662: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
663: l_body := fnd_message.get;
664: END IF;
665: CLOSE GetRouteDet;

Line 662: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

658: l_body := fnd_message.get;
659: ELSE
660: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
661: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
662: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
663: l_body := fnd_message.get;
664: END IF;
665: CLOSE GetRouteDet;
666:

Line 663: l_body := fnd_message.get;

659: ELSE
660: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
661: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
662: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
663: l_body := fnd_message.get;
664: END IF;
665: CLOSE GetRouteDet;
666:
667:

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

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

Line 778: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');

774: FETCH GetRouteDet into l_route_rec;
775:
776: IF GetRouteDet%NOTFOUND
777: THEN
778: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
779: fnd_message.set_token('route_id',l_route_rec.route_id,false);
780: l_body := fnd_message.get;
781: ELSE
782: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

Line 779: fnd_message.set_token('route_id',l_route_rec.route_id,false);

775:
776: IF GetRouteDet%NOTFOUND
777: THEN
778: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
779: fnd_message.set_token('route_id',l_route_rec.route_id,false);
780: l_body := fnd_message.get;
781: ELSE
782: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
783: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

Line 780: l_body := fnd_message.get;

776: IF GetRouteDet%NOTFOUND
777: THEN
778: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
779: fnd_message.set_token('route_id',l_route_rec.route_id,false);
780: l_body := fnd_message.get;
781: ELSE
782: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
783: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
784: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

Line 782: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

778: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
779: fnd_message.set_token('route_id',l_route_rec.route_id,false);
780: l_body := fnd_message.get;
781: ELSE
782: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
783: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
784: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
785: l_body := fnd_message.get;
786: END IF;

Line 783: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

779: fnd_message.set_token('route_id',l_route_rec.route_id,false);
780: l_body := fnd_message.get;
781: ELSE
782: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
783: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
784: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
785: l_body := fnd_message.get;
786: END IF;
787: CLOSE GetRouteDet;

Line 784: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

780: l_body := fnd_message.get;
781: ELSE
782: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
783: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
784: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
785: l_body := fnd_message.get;
786: END IF;
787: CLOSE GetRouteDet;
788:

Line 785: l_body := fnd_message.get;

781: ELSE
782: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
783: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
784: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
785: l_body := fnd_message.get;
786: END IF;
787: CLOSE GetRouteDet;
788:
789:

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

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

Line 903: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');

899: FETCH GetRouteDet into l_route_rec;
900:
901: IF GetRouteDet%NOTFOUND
902: THEN
903: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
904: fnd_message.set_token('route_id',l_route_rec.route_id,false);
905: l_body := fnd_message.get;
906: ELSE
907: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

Line 904: fnd_message.set_token('route_id',l_route_rec.route_id,false);

900:
901: IF GetRouteDet%NOTFOUND
902: THEN
903: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
904: fnd_message.set_token('route_id',l_route_rec.route_id,false);
905: l_body := fnd_message.get;
906: ELSE
907: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
908: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

Line 905: l_body := fnd_message.get;

901: IF GetRouteDet%NOTFOUND
902: THEN
903: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
904: fnd_message.set_token('route_id',l_route_rec.route_id,false);
905: l_body := fnd_message.get;
906: ELSE
907: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
908: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
909: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

Line 907: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

903: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
904: fnd_message.set_token('route_id',l_route_rec.route_id,false);
905: l_body := fnd_message.get;
906: ELSE
907: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
908: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
909: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
910: l_body := fnd_message.get;
911: END IF;

Line 908: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

904: fnd_message.set_token('route_id',l_route_rec.route_id,false);
905: l_body := fnd_message.get;
906: ELSE
907: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
908: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
909: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
910: l_body := fnd_message.get;
911: END IF;
912: CLOSE GetRouteDet;

Line 909: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

905: l_body := fnd_message.get;
906: ELSE
907: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
908: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
909: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
910: l_body := fnd_message.get;
911: END IF;
912: CLOSE GetRouteDet;
913:

Line 910: l_body := fnd_message.get;

906: ELSE
907: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
908: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
909: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
910: l_body := fnd_message.get;
911: END IF;
912: CLOSE GetRouteDet;
913:
914:

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

1010: );
1011:
1012: /*--------------------------------------------------------------------------
1013: -- Query approval object table for any detail information of this object
1014: -- that will be used to replace tokens defined in FND Messages.
1015: -- Here to simplify, we are using hard-coded messages.
1016: ----------------------------------------------------------------------------*/
1017:
1018: OPEN GetRouteDet(l_object_id);

Line 1023: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');

1019: FETCH GetRouteDet into l_route_rec;
1020:
1021: IF GetRouteDet%NOTFOUND
1022: THEN
1023: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
1024: fnd_message.set_token('route_id',l_route_rec.route_id,false);
1025: l_body := fnd_message.get;
1026: ELSE
1027: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

Line 1024: fnd_message.set_token('route_id',l_route_rec.route_id,false);

1020:
1021: IF GetRouteDet%NOTFOUND
1022: THEN
1023: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
1024: fnd_message.set_token('route_id',l_route_rec.route_id,false);
1025: l_body := fnd_message.get;
1026: ELSE
1027: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
1028: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

Line 1025: l_body := fnd_message.get;

1021: IF GetRouteDet%NOTFOUND
1022: THEN
1023: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
1024: fnd_message.set_token('route_id',l_route_rec.route_id,false);
1025: l_body := fnd_message.get;
1026: ELSE
1027: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
1028: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
1029: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

Line 1027: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');

1023: fnd_message.set_name('AHL', 'AHL_route_id_INVALID');
1024: fnd_message.set_token('route_id',l_route_rec.route_id,false);
1025: l_body := fnd_message.get;
1026: ELSE
1027: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
1028: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
1029: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
1030: l_body := fnd_message.get;
1031: END IF;

Line 1028: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);

1024: fnd_message.set_token('route_id',l_route_rec.route_id,false);
1025: l_body := fnd_message.get;
1026: ELSE
1027: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
1028: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
1029: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
1030: l_body := fnd_message.get;
1031: END IF;
1032: CLOSE GetRouteDet;

Line 1029: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);

1025: l_body := fnd_message.get;
1026: ELSE
1027: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
1028: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
1029: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
1030: l_body := fnd_message.get;
1031: END IF;
1032: CLOSE GetRouteDet;
1033:

Line 1030: l_body := fnd_message.get;

1026: ELSE
1027: fnd_message.set_name('AHL', 'AHL_RM_NTF_FORWARD_SUBJECT');
1028: fnd_message.set_token('ROUTE_ID',l_route_rec.route_id ,false);
1029: fnd_message.set_token('ROUTENUM',l_route_rec.route_no, false);
1030: l_body := fnd_message.get;
1031: END IF;
1032: CLOSE GetRouteDet;
1033:
1034:

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

1193: END IF;
1194:
1195: if (sql%notfound)
1196: then
1197: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1198: FND_MSG_PUB.Add;
1199: l_return_status := FND_API.G_RET_STS_ERROR;
1200: End if;
1201:

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

1339:
1340:
1341: if (sql%notfound)
1342: then
1343: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1344: FND_MSG_PUB.Add;
1345:
1346: l_return_status := FND_API.G_RET_STS_ERROR;
1347: return;