512:
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;
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;
519: OPEN c_per_num;
520: FETCH c_per_num INTO l_per_num;
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');
520: FETCH c_per_num INTO l_per_num;
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);
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 ());
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 ());
530:
531: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
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 ());
530:
531: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
532: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
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());
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());
534:
535: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APC');
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());
534:
535: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APC');
536: FND_MESSAGE.SET_TOKEN ('APC', p_apc);
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 ());
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 ());
538:
539: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_TYPE');
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 ());
538:
539: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_TYPE');
540: FND_MESSAGE.SET_TOKEN ('APPLTYPE', p_appl_type);
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 ());
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 ());
542:
543: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_CRCD');
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 ());
542:
543: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_CRCD');
544: FND_MESSAGE.SET_TOKEN ('CRCD', p_prog_code);
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 ());
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 ());
546:
547: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_LOC');
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 ());
546:
547: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_LOC');
548: FND_MESSAGE.SET_TOKEN ('LOC', p_location);
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 ());
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 ());
550:
551: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_TYPE');
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 ());
550:
551: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_TYPE');
552: FND_MESSAGE.SET_TOKEN ('ATTTYPE', p_att_type);
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 ());
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 ());
554:
555: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_MODE');
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 ());
554:
555: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_MODE');
556: FND_MESSAGE.SET_TOKEN ('ATTMODE', p_att_mode);
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 ());
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 ());
558:
559: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_NC');
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 ());
558:
559: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_NC');
560: FND_MESSAGE.SET_TOKEN ('APPLNOCAL', p_appl_no_calendar);
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 ());
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 ());
562:
563: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_RANGE');
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 ());
562:
563: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_RANGE');
564: FND_MESSAGE.SET_TOKEN ('APPLRNGE', p_appl_range);
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 ());
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 ());
566: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
567: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
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 ());
566: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
567: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
568:
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
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');
572: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
573:
574: ELSIF NVL( p_appl_range, 'CURRENT') = 'CURRFUTURE' THEN
575:
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
595: OPEN c_per_num1(l_person_id);
596: FETCH c_per_num1 INTO l_per_num1;
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);
596: FETCH c_per_num1 INTO l_per_num1;
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
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
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
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;
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
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:
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;
616:
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;
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:
641: OPEN c_per_num1(l_person_id);
642: FETCH c_per_num1 INTO l_per_num1;
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);
642: FETCH c_per_num1 INTO l_per_num1;
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
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
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
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 */
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
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:
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;
662:
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;
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:
693: OPEN c_per_num1(l_person_id);
694: FETCH c_per_num1 INTO l_per_num1;
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);
694: FETCH c_per_num1 INTO l_per_num1;
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
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
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
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 */
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
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:
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;
714:
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;
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:
742: OPEN c_per_num1(l_person_id);
743: FETCH c_per_num1 INTO l_per_num1;
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);
743: FETCH c_per_num1 INTO l_per_num1;
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
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
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
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 */
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
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:
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;
763:
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;
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:
798: OPEN c_per_num1(l_person_id);
799: FETCH c_per_num1 INTO l_per_num1;
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);
799: FETCH c_per_num1 INTO l_per_num1;
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
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
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
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;
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
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:
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;
817: END LOOP;
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:
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:
844: OPEN c_per_num1(l_person_id);
845: FETCH c_per_num1 INTO l_per_num1;
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);
845: FETCH c_per_num1 INTO l_per_num1;
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:
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
852: WF_Inform_Applicant_INAP(l_user_id, l_user_name, l_full_name);
853:
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 */
853:
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:
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;
864: END LOOP;
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;
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:
895: OPEN c_per_num1(l_person_id);
896: FETCH c_per_num1 INTO l_per_num1;
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);
896: FETCH c_per_num1 INTO l_per_num1;
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
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
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
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 */
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
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:
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;
916:
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;
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:
943: OPEN c_per_num1(l_person_id);
944: FETCH c_per_num1 INTO l_per_num1;
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);
944: FETCH c_per_num1 INTO l_per_num1;
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
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
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
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 */
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
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:
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;
963: END LOOP;
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;
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:
978:
979: EXCEPTION
980: WHEN OTHERS THEN
981: RETCODE := 2;
982: ERRBUF := fnd_message.get_string( 'IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
983: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
984:
985: IF c_incom_appl_nopgm_curr_anc%ISOPEN THEN
986: CLOSE c_incom_appl_nopgm_curr_anc;
1234:
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;
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;
1241: OPEN c_per_num;
1242: FETCH c_per_num INTO l_per_num;
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');
1242: FETCH c_per_num INTO l_per_num;
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);
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 ());
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 ());
1252:
1253: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APPLID');
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 ());
1252:
1253: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APPLID');
1254: FND_MESSAGE.SET_TOKEN ('APPLID', p_appl_id);
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 ());
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 ());
1256:
1257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
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 ());
1256:
1257: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
1258: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
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());
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());
1260:
1261: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_TRKTYP');
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());
1260:
1261: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_TRKTYP');
1262: FND_MESSAGE.SET_TOKEN ('TRKTYP', p_tracking_type);
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 ());
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 ());
1264:
1265: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APC');
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 ());
1264:
1265: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_APC');
1266: FND_MESSAGE.SET_TOKEN ('APC', p_apc);
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 ());
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 ());
1268:
1269: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_TYPE');
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 ());
1268:
1269: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_APPL_TYPE');
1270: FND_MESSAGE.SET_TOKEN ('APPLTYPE', p_appl_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 ());
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 ());
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 ());
1272:
1273: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_CRCD');
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 ());
1272:
1273: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_APP_LG_CRCD');
1274: FND_MESSAGE.SET_TOKEN ('CRCD', p_prog_code);
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 ());
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 ());
1276:
1277: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_LOC');
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 ());
1276:
1277: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_LOC');
1278: FND_MESSAGE.SET_TOKEN ('LOC', p_location);
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 ());
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 ());
1280:
1281: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_TYPE');
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 ());
1280:
1281: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_TYPE');
1282: FND_MESSAGE.SET_TOKEN ('ATTTYPE', p_att_type);
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 ());
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 ());
1284:
1285: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_MODE');
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 ());
1284:
1285: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_LG_INAP_ATT_MODE');
1286: FND_MESSAGE.SET_TOKEN ('ATTMODE', p_att_mode);
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 ());
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 ());
1288:
1289: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
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 ());
1288:
1289: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
1290: FND_FILE.PUT_LINE (FND_FILE.LOG, '');
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:
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');
1295: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1296:
1297: ELSIF NVL(p_tracking_type, 'ADM_PROCESSING') = 'ADM_PROCESSING' THEN
1298:
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;
1315: /* Wf_Directory.GetRoleName('HZ_PARTY', lv_person_id, l_person_name, l_display_name);
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');
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);
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:
1327: ELSE
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:
1327: ELSE
1328: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
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());
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());
1330: END IF; */
1331: ---------------------------------------------------------------------------------
1332: --Get Alternate Code
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: ---------------------------------------------------------------------------------
1343: FETCH cur_user INTO l_person_name, l_display_name;
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');
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);
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:
1355: Wf_Admission_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
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:
1355: Wf_Admission_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1356:
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
1358: Wf_Directory.GetRoleName('HZ_PARTY', lv_person_id, l_person_name, l_display_name);
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');
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);
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:
1370: Wf_Admission_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
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:
1370: Wf_Admission_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1371:
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
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
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:
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 */
1384:
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;
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:
1414: /* Wf_Directory.GetRoleName('HZ_PARTY', l_person_id, l_person_name, l_display_name);
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');
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);
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:
1426: ELSE
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:
1426: ELSE
1427: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APNTF4');
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());
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());
1429:
1430: END IF; */
1431:
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: ---------------------------------------------------------------------------------
1444: FETCH cur_user INTO l_person_name, l_display_name;
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');
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);
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:
1456: Wf_Post_Adm_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
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:
1456: Wf_Post_Adm_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1457:
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
1459: Wf_Directory.GetRoleName('HZ_PARTY', lv_person_id, l_person_name, l_display_name);
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');
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);
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:
1471: Wf_Post_Adm_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
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:
1471: Wf_Post_Adm_Req (l_person_id, l_person_name, l_display_name, l_alt_code_acad, l_alt_code_adm);
1472:
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
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
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:
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 */
1485:
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;
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:
1496:
1497: EXCEPTION
1498: WHEN OTHERS THEN
1499: RETCODE := 2;
1500: ERRBUF := fnd_message.get_string( 'IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1501: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1502:
1503: IF c_per_adm_req%ISOPEN THEN
1504: CLOSE c_per_adm_req;