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_USER

Line 495: FROM FND_USER

491:
492:
493: CURSOR cur_user(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE) IS
494: SELECT user_id, user_name, description
495: FROM FND_USER
496: WHERE person_party_id = cp_person_id ;
497:
498: CURSOR c_per_num IS
499: SELECT party_number

Line 605: -- write in the log that no user_id exists in the FND_USER table for this person_id

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
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:

Line 651: -- write in the log that no user_id exists in the FND_USER table for this person_id

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
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:

Line 703: -- write in the log that no user_id exists in the FND_USER table for this person_id

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
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:

Line 752: -- write in the log that no user_id exists in the FND_USER table for this person_id

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
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:

Line 808: -- write in the log that no user_id exists in the FND_USER table for this person_id

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
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:

Line 855: -- write in the log that no user_id exists in the FND_USER table for this person_id

851:
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:

Line 905: -- write in the log that no user_id exists in the FND_USER table for this person_id

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
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:

Line 953: -- write in the log that no user_id exists in the FND_USER table for this person_id

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
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:

Line 1222: FROM FND_USER

1218: sequence_number = cp_seq_no;
1219:
1220: CURSOR cur_user(cp_person_id igs_ad_appl_all.person_id%TYPE) IS
1221: SELECT user_name, description
1222: FROM FND_USER
1223: WHERE person_party_id = cp_person_id ;
1224:
1225: CURSOR c_per_num IS
1226: SELECT party_number