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.IGS_AD_WRKFLOW_PKG dependencies on FND_FILE

Line 517: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

513: RETCODE := 0;
514: ERRBUF := NULL;
515:
516: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_APPNTF_PRMS');
517: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
518:
519: OPEN c_per_num;
520: FETCH c_per_num INTO l_per_num;
521: CLOSE c_per_num;

Line 525: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

521: CLOSE c_per_num;
522:
523: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_PNUM');
524: FND_MESSAGE.SET_TOKEN ('PNUM', l_per_num);
525: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
526:
527: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_PID_GRP');
528: FND_MESSAGE.SET_TOKEN ('PGPID', p_person_id_group);
529: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 529: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

525: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
526:
527: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_PID_GRP');
528: FND_MESSAGE.SET_TOKEN ('PGPID', p_person_id_group);
529: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
530:
531: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
532: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
533: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 533: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

529: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
530:
531: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
532: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
533: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
534:
535: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APC');
536: FND_MESSAGE.SET_TOKEN ('APC', p_apc);
537: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 537: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

533: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
534:
535: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APC');
536: FND_MESSAGE.SET_TOKEN ('APC', p_apc);
537: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
538:
539: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_TYPE');
540: FND_MESSAGE.SET_TOKEN ('APPLTYPE', p_appl_type);
541: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 541: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

537: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
538:
539: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_TYPE');
540: FND_MESSAGE.SET_TOKEN ('APPLTYPE', p_appl_type);
541: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
542:
543: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_CRCD');
544: FND_MESSAGE.SET_TOKEN ('CRCD', p_prog_code);
545: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 545: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

541: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
542:
543: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_CRCD');
544: FND_MESSAGE.SET_TOKEN ('CRCD', p_prog_code);
545: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
546:
547: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_LOC');
548: FND_MESSAGE.SET_TOKEN ('LOC', p_location);
549: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 549: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

545: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
546:
547: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_LOC');
548: FND_MESSAGE.SET_TOKEN ('LOC', p_location);
549: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
550:
551: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_TYPE');
552: FND_MESSAGE.SET_TOKEN ('ATTTYPE', p_att_type);
553: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 553: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

549: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
550:
551: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_TYPE');
552: FND_MESSAGE.SET_TOKEN ('ATTTYPE', p_att_type);
553: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
554:
555: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_MODE');
556: FND_MESSAGE.SET_TOKEN ('ATTMODE', p_att_mode);
557: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 557: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

553: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
554:
555: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_MODE');
556: FND_MESSAGE.SET_TOKEN ('ATTMODE', p_att_mode);
557: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
558:
559: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_NC');
560: FND_MESSAGE.SET_TOKEN ('APPLNOCAL', p_appl_no_calendar);
561: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 561: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

557: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
558:
559: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_NC');
560: FND_MESSAGE.SET_TOKEN ('APPLNOCAL', p_appl_no_calendar);
561: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
562:
563: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_RANGE');
564: FND_MESSAGE.SET_TOKEN ('APPLRNGE', p_appl_range);
565: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 565: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

561: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
562:
563: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_RANGE');
564: FND_MESSAGE.SET_TOKEN ('APPLRNGE', p_appl_range);
565: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
566: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
567: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
568:
569: IF (p_person_id IS NOT NULL AND p_person_id_group IS NOT NULL ) THEN

Line 566: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

562:
563: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_RANGE');
564: FND_MESSAGE.SET_TOKEN ('APPLRNGE', p_appl_range);
565: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
566: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
567: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
568:
569: IF (p_person_id IS NOT NULL AND p_person_id_group IS NOT NULL ) THEN
570:

Line 567: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

563: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_RANGE');
564: FND_MESSAGE.SET_TOKEN ('APPLRNGE', p_appl_range);
565: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
566: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
567: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
568:
569: IF (p_person_id IS NOT NULL AND p_person_id_group IS NOT NULL ) THEN
570:
571: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NO_PERID_PERIDGRP');

Line 572: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

568:
569: IF (p_person_id IS NOT NULL AND p_person_id_group IS NOT NULL ) THEN
570:
571: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NO_PERID_PERIDGRP');
572: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
573:
574: ELSIF NVL( p_appl_range, 'CURRENT') = 'CURRFUTURE' THEN
575:
576: IF p_prog_code IS NULL THEN

Line 601: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

597: CLOSE c_per_num1;
598:
599: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF1');
600: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
601: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
602:
603: WF_Inform_Applicant_INAP(l_user_id, l_user_name, l_full_name);
604: ELSE
605: -- write in the log that no user_id exists in the FND_USER table for this person_id

Line 608: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

604: ELSE
605: -- write in the log that no user_id exists in the FND_USER table for this person_id
606: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_USR_PER_INV_COMB');
607: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
608: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
609:
610: END IF;
611:
612: CLOSE cur_user;

Line 621: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

617: IF l_count = 0 THEN
618: -- write in the log file that no record exists
619: -- Invalid parameters entered. Valid combinations for parameters to be entered
620: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
621: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
622: END IF;
623:
624: CLOSE c_incom_appl_nopgm_cnf_anc;
625:

Line 647: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

643: CLOSE c_per_num1;
644:
645: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF1');
646: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
647: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
648:
649: WF_Inform_Applicant_INAP(l_user_id, l_user_name, l_full_name);
650: ELSE
651: -- write in the log that no user_id exists in the FND_USER table for this person_id

Line 654: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

650: ELSE
651: -- write in the log that no user_id exists in the FND_USER table for this person_id
652: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_USR_PER_INV_COMB');
653: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
654: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
655:
656: END IF; /* cur_user */
657:
658: CLOSE cur_user;

Line 667: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

663: IF l_count = 0 THEN
664: -- write in the log file that no record exists
665: -- Invalid parameters entered. Valid combinations for parameters to be entered
666: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
667: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
668: END IF;
669:
670: CLOSE c_incom_appl_nopgm_cnf;
671:

Line 699: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

695: CLOSE c_per_num1;
696:
697: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF1');
698: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
699: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
700:
701: WF_Inform_Applicant_INAP(l_user_id, l_user_name, l_full_name);
702: ELSE
703: -- write in the log that no user_id exists in the FND_USER table for this person_id

Line 706: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

702: ELSE
703: -- write in the log that no user_id exists in the FND_USER table for this person_id
704: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_USR_PER_INV_COMB');
705: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
706: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
707:
708: END IF; /* cur_user */
709:
710: CLOSE cur_user;

Line 719: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

715: IF l_count = 0 THEN
716: -- write in the log file that no record exists
717: -- Invalid parameters entered. Valid combinations for parameters to be entered
718: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
719: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
720: END IF;
721:
722: CLOSE c_incom_appl_pgm_cnf_anc;
723:

Line 748: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

744: CLOSE c_per_num1;
745:
746: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF1');
747: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
748: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
749:
750: WF_Inform_Applicant_INAP(l_user_id, l_user_name, l_full_name);
751: ELSE
752: -- write in the log that no user_id exists in the FND_USER table for this person_id

Line 755: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

751: ELSE
752: -- write in the log that no user_id exists in the FND_USER table for this person_id
753: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_USR_PER_INV_COMB');
754: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
755: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
756:
757: END IF; /* cur_user */
758:
759: CLOSE cur_user;

Line 768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

764: IF l_count = 0 THEN
765: -- write in the log file that no record exists
766: -- Invalid parameters entered. Valid combinations for parameters to be entered
767: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
768: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
769: END IF;
770:
771: CLOSE c_incom_appl_pgm_cnf;
772:

Line 804: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

800: CLOSE c_per_num1;
801:
802: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF1');
803: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
804: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
805:
806: WF_Inform_Applicant_INAP(l_user_id, l_user_name, l_full_name);
807: ELSE
808: -- write in the log that no user_id exists in the FND_USER table for this person_id

Line 811: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

807: ELSE
808: -- write in the log that no user_id exists in the FND_USER table for this person_id
809: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_USR_PER_INV_COMB');
810: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
811: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
812:
813: END IF;
814:
815: CLOSE cur_user;

Line 822: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

818: IF l_count = 0 THEN
819: -- write in the log file that no record exists
820: -- Invalid parameters entered. Valid combinations for parameters to be entered
821: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
822: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
823:
824: END IF;
825:
826:

Line 850: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

846: CLOSE c_per_num1;
847:
848: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF1');
849: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
850: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
851:
852: WF_Inform_Applicant_INAP(l_user_id, l_user_name, l_full_name);
853:
854: ELSE

Line 858: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

854: ELSE
855: -- write in the log that no user_id exists in the FND_USER table for this person_id
856: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_USR_PER_INV_COMB');
857: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
858: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
859:
860: END IF; /* cur_user */
861:
862: CLOSE cur_user;

Line 869: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

865: IF l_count = 0 THEN
866: -- write in the log file that no record exists
867: -- Invalid parameters entered. Valid combinations for parameters to be entered
868: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
869: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
870: END IF;
871:
872: CLOSE c_incom_appl_nopgm_curr;
873:

Line 901: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

897: CLOSE c_per_num1;
898:
899: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF1');
900: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
901: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
902:
903: WF_Inform_Applicant_INAP(l_user_id, l_user_name, l_full_name);
904: ELSE
905: -- write in the log that no user_id exists in the FND_USER table for this person_id

Line 908: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

904: ELSE
905: -- write in the log that no user_id exists in the FND_USER table for this person_id
906: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_USR_PER_INV_COMB');
907: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
908: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
909:
910: END IF; /* cur_user */
911:
912: CLOSE cur_user;

Line 921: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

917: IF l_count = 0 THEN
918: -- write in the log file that no record exists
919: -- Invalid parameters entered. Valid combinations for parameters to be entered
920: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
921: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
922: END IF;
923:
924: CLOSE c_incom_appl_pgm_curr_anc;
925:

Line 949: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

945: CLOSE c_per_num1;
946:
947: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF1');
948: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
949: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
950:
951: WF_Inform_Applicant_INAP(l_user_id, l_user_name, l_full_name);
952: ELSE
953: -- write in the log that no user_id exists in the FND_USER table for this person_id

Line 956: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

952: ELSE
953: -- write in the log that no user_id exists in the FND_USER table for this person_id
954: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_USR_PER_INV_COMB');
955: FND_MESSAGE.SET_TOKEN ('PERSONNUM', l_per_num1);
956: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
957:
958: END IF; /* cur_user */
959:
960: CLOSE cur_user;

Line 968: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

964: IF l_count = 0 THEN
965: -- write in the log file that no record exists
966: -- Invalid parameters entered. Valid combinations for parameters to be entered
967: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
968: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
969: END IF;
970:
971: CLOSE c_incom_appl_pgm_curr;
972:

Line 1239: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1235: RETCODE := 0;
1236: ERRBUF := NULL;
1237:
1238: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_APPNTF_PRMS');
1239: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1240:
1241: OPEN c_per_num;
1242: FETCH c_per_num INTO l_per_num;
1243: CLOSE c_per_num;

Line 1247: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1243: CLOSE c_per_num;
1244:
1245: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_PNUM');
1246: FND_MESSAGE.SET_TOKEN ('PNUM', l_per_num);
1247: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1248:
1249: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_PID_GRP');
1250: FND_MESSAGE.SET_TOKEN ('PGPID', p_person_id_group);
1251: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 1251: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1247: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1248:
1249: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_PID_GRP');
1250: FND_MESSAGE.SET_TOKEN ('PGPID', p_person_id_group);
1251: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1252:
1253: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APPLID');
1254: FND_MESSAGE.SET_TOKEN ('APPLID', p_appl_id);
1255: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 1255: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1251: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1252:
1253: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APPLID');
1254: FND_MESSAGE.SET_TOKEN ('APPLID', p_appl_id);
1255: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1256:
1257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
1258: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
1259: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 1259: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

1255: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1256:
1257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
1258: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
1259: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
1260:
1261: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_TRKTYP');
1262: FND_MESSAGE.SET_TOKEN ('TRKTYP', p_tracking_type);
1263: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 1263: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1259: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
1260:
1261: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_TRKTYP');
1262: FND_MESSAGE.SET_TOKEN ('TRKTYP', p_tracking_type);
1263: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1264:
1265: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APC');
1266: FND_MESSAGE.SET_TOKEN ('APC', p_apc);
1267: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 1267: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1263: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1264:
1265: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APC');
1266: FND_MESSAGE.SET_TOKEN ('APC', p_apc);
1267: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1268:
1269: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_TYPE');
1270: FND_MESSAGE.SET_TOKEN ('APPLTYPE', p_appl_type);
1271: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 1271: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1267: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1268:
1269: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_TYPE');
1270: FND_MESSAGE.SET_TOKEN ('APPLTYPE', p_appl_type);
1271: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1272:
1273: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_CRCD');
1274: FND_MESSAGE.SET_TOKEN ('CRCD', p_prog_code);
1275: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 1275: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1271: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1272:
1273: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_CRCD');
1274: FND_MESSAGE.SET_TOKEN ('CRCD', p_prog_code);
1275: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1276:
1277: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_LOC');
1278: FND_MESSAGE.SET_TOKEN ('LOC', p_location);
1279: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 1279: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1275: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1276:
1277: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_LOC');
1278: FND_MESSAGE.SET_TOKEN ('LOC', p_location);
1279: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1280:
1281: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_TYPE');
1282: FND_MESSAGE.SET_TOKEN ('ATTTYPE', p_att_type);
1283: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 1283: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1279: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1280:
1281: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_TYPE');
1282: FND_MESSAGE.SET_TOKEN ('ATTTYPE', p_att_type);
1283: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1284:
1285: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_MODE');
1286: FND_MESSAGE.SET_TOKEN ('ATTMODE', p_att_mode);
1287: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

Line 1287: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1283: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1284:
1285: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_MODE');
1286: FND_MESSAGE.SET_TOKEN ('ATTMODE', p_att_mode);
1287: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1288:
1289: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1290: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1291:

Line 1289: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

1285: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_MODE');
1286: FND_MESSAGE.SET_TOKEN ('ATTMODE', p_att_mode);
1287: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1288:
1289: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1290: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1291:
1292: IF (p_person_id IS NOT NULL AND p_person_id_group IS NOT NULL ) THEN
1293:

Line 1290: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

1286: FND_MESSAGE.SET_TOKEN ('ATTMODE', p_att_mode);
1287: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1288:
1289: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1290: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1291:
1292: IF (p_person_id IS NOT NULL AND p_person_id_group IS NOT NULL ) THEN
1293:
1294: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NO_PERID_PERIDGRP');

Line 1295: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1291:
1292: IF (p_person_id IS NOT NULL AND p_person_id_group IS NOT NULL ) THEN
1293:
1294: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NO_PERID_PERIDGRP');
1295: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1296:
1297: ELSIF NVL(p_tracking_type, 'ADM_PROCESSING') = 'ADM_PROCESSING' THEN
1298:
1299: l_count := 0;

Line 1320: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1316:
1317: IF l_person_name IS NOT NULL THEN
1318:
1319: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1320: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1321:
1322: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1323: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1324: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);

Line 1322: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

1318:
1319: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1320: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1321:
1322: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1323: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1324: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1325: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1326:

Line 1325: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1321:
1322: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1323: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1324: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1325: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1326:
1327: ELSE
1328: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
1329: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

Line 1329: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1325: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1326:
1327: ELSE
1328: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
1329: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1330: END IF; */
1331: ---------------------------------------------------------------------------------
1332: --Get Alternate Code
1333: ---------------------------------------------------------------------------------

Line 1348: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1344:
1345: IF cur_user%FOUND THEN
1346:
1347: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1348: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1349:
1350: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1351: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1352: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);

Line 1350: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

1346:
1347: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1348: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1349:
1350: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1351: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1352: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1353: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1354:

Line 1353: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1349:
1350: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1351: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1352: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1353: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1354:
1355: Wf_Admission_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1356:
1357: ELSE

Line 1363: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1359:
1360: IF l_person_name IS NOT NULL THEN
1361:
1362: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1363: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1364:
1365: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1366: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1367: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);

Line 1365: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

1361:
1362: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1363: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1364:
1365: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1366: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1367: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1368: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1369:

Line 1368: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1364:
1365: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1366: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1367: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1368: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1369:
1370: Wf_Admission_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1371:
1372: ELSE

Line 1374: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1370: Wf_Admission_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1371:
1372: ELSE
1373: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
1374: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1375:
1376: END IF ; /* l_person_name */
1377:
1378: END IF; /* cur_user */

Line 1389: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

1385: IF l_count = 0 THEN
1386: -- write in the log file that no record exists
1387: -- Invalid parameters entered. Valid combinations for parameters to be entered
1388: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
1389: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
1390: END IF;
1391:
1392: CLOSE c_per_adm_req;
1393:

Line 1419: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1415:
1416: IF l_person_name IS NOT NULL THEN
1417:
1418: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF3');
1419: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1420:
1421: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1422: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1423: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);

Line 1421: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

1417:
1418: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF3');
1419: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1420:
1421: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1422: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1423: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1424: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1425:

Line 1424: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1420:
1421: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1422: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1423: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1424: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1425:
1426: ELSE
1427: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
1428: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

Line 1428: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1424: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1425:
1426: ELSE
1427: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
1428: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1429:
1430: END IF; */
1431:
1432: ---------------------------------------------------------------------------------

Line 1449: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1445:
1446: IF cur_user%FOUND THEN
1447:
1448: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1449: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1450:
1451: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1452: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1453: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);

Line 1451: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

1447:
1448: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1449: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1450:
1451: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1452: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1453: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1454: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1455:

Line 1454: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1450:
1451: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1452: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1453: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1454: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1455:
1456: Wf_Post_Adm_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1457:
1458: ELSE

Line 1464: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1460:
1461: IF l_person_name IS NOT NULL THEN
1462:
1463: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1464: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1465:
1466: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1467: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1468: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);

Line 1466: FND_FILE.PUT_LINE (FND_FILE.LOG, '');

1462:
1463: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF2');
1464: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1465:
1466: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1467: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1468: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1469: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1470:

Line 1469: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1465:
1466: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1467: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF6');
1468: FND_MESSAGE.SET_TOKEN ('PNAME', l_display_name);
1469: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1470:
1471: Wf_Post_Adm_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1472:
1473: ELSE

Line 1475: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());

1471: Wf_Post_Adm_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1472:
1473: ELSE
1474: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
1475: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET());
1476:
1477: END IF ; /* l_person_name */
1478:
1479: END IF; /* cur_user */

Line 1490: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

1486: IF l_count = 0 THEN
1487: -- write in the log file that no record exists
1488: -- Invalid parameters entered. Valid combinations for parameters to be entered
1489: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF_INV_PRM_COMB');
1490: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
1491: END IF;
1492:
1493: CLOSE c_per_post_adm_req;
1494: