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_SS_GEN_001 dependencies on APP_EXCEPTION

Line 218: App_Exception.Raise_Exception;

214: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_data -'||SQLERRM);
215: IGS_GE_MSG_STACK.ADD;
216: x_message_name := 'IGS_GE_UNHANDLED_EXP';
217: END IF;
218: App_Exception.Raise_Exception;
219: -- App_Exception.Raise_Exception; x_return_status is an OUT NOCOPY parameter and will not show the value set, for it if the exception is raised. So commenting out NOCOPY Bug# 2224624
220: END transfer_data;
221:
222: --This Function Creates an Application and Returns TRUE if Application is created.

Line 219: -- App_Exception.Raise_Exception; x_return_status is an OUT NOCOPY parameter and will not show the value set, for it if the exception is raised. So commenting out NOCOPY Bug# 2224624

215: IGS_GE_MSG_STACK.ADD;
216: x_message_name := 'IGS_GE_UNHANDLED_EXP';
217: END IF;
218: App_Exception.Raise_Exception;
219: -- App_Exception.Raise_Exception; x_return_status is an OUT NOCOPY parameter and will not show the value set, for it if the exception is raised. So commenting out NOCOPY Bug# 2224624
220: END transfer_data;
221:
222: --This Function Creates an Application and Returns TRUE if Application is created.
223: FUNCTION create_application(p_appl_rec IN igs_ss_adm_appl_stg%ROWTYPE,

Line 336: App_Exception.Raise_Exception;

332: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application -'||SQLERRM);
333: IGS_GE_MSG_STACK.ADD;
334: p_message_name := 'IGS_GE_UNHANDLED_EXP';
335: END IF;
336: App_Exception.Raise_Exception;
337:
338: END create_application; --Main End
339:
340: --This Function Creates Program Application and Program Application Instance

Line 641: App_Exception.Raise_Exception;

637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_program -'||SQLERRM);
638: IGS_GE_MSG_STACK.ADD;
639: p_message_name := 'IGS_GE_UNHANDLED_EXP';
640: END IF;
641: App_Exception.Raise_Exception;
642:
643: END create_program;
644:
645: PROCEDURE update_person_type(p_sequence_number IN igs_pe_typ_instances_all.sequence_number%TYPE,

Line 727: App_Exception.Raise_Exception;

723: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
724: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_person_type -'||SQLERRM);
725: IGS_GE_MSG_STACK.ADD;
726: END IF;
727: App_Exception.Raise_Exception;
728: END update_person_type;
729:
730: PROCEDURE insert_unit_set_dtls(p_sequence_number IN igs_ad_unit_sets.sequence_number%TYPE,
731: p_nominated_course_cd IN igs_ad_unit_sets.nominated_course_cd%TYPE,

Line 815: App_Exception.Raise_Exception;

811: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_unit_set_dtls -'||SQLERRM);
812: IGS_GE_MSG_STACK.ADD;
813: END IF;
814:
815: App_Exception.Raise_Exception;
816: END insert_unit_set_dtls;
817:
818: --added by nshee during build for Applicant-BOSS SS Bug 2622488
819: PROCEDURE insert_acad_interest(p_person_id IN igs_ad_acad_interest.person_id%TYPE,

Line 878: App_Exception.Raise_Exception;

874: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
875: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_acad_interest -'||SQLERRM);
876: IGS_GE_MSG_STACK.ADD;
877: END IF;
878: App_Exception.Raise_Exception;
879: END insert_acad_interest;
880:
881: PROCEDURE insert_applicant_intent(p_person_id IN igs_ad_app_intent.person_id%TYPE,
882: p_adm_appl_id IN igs_ss_ad_appint_stg.ss_adm_appl_id%TYPE,

Line 957: App_Exception.Raise_Exception;

953: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
954: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_applicant_intent -'||SQLERRM);
955: IGS_GE_MSG_STACK.ADD;
956: END IF;
957: App_Exception.Raise_Exception;
958: END insert_applicant_intent;
959:
960: PROCEDURE insert_spl_talent(p_person_id IN igs_ad_spl_talents.person_id%TYPE,
961: p_adm_appl_id IN igs_ss_ad_spltal_stg.ss_adm_appl_id%TYPE,

Line 1016: App_Exception.Raise_Exception;

1012: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1013: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_spl_talent -'||SQLERRM);
1014: IGS_GE_MSG_STACK.ADD;
1015: END IF;
1016: App_Exception.Raise_Exception;
1017: END insert_spl_talent;
1018:
1019: PROCEDURE insert_special_interest(p_person_id IN igs_ad_spl_interests.person_id%TYPE,
1020: p_adm_appl_id IN igs_ss_ad_splint_stg.ss_adm_appl_id%TYPE,

Line 1075: App_Exception.Raise_Exception;

1071: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1072: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_special_interest -'||SQLERRM);
1073: IGS_GE_MSG_STACK.ADD;
1074: END IF;
1075: App_Exception.Raise_Exception;
1076: END insert_special_interest;
1077: --added by nshee during build for Applicant-BOSS SS Bug 2622488
1078: --dhan
1079: PROCEDURE insert_othinst(p_person_id IN NUMBER,

Line 1133: App_Exception.Raise_Exception;

1129: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1130: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_othinst -'||SQLERRM);
1131: IGS_GE_MSG_STACK.ADD;
1132: END IF;
1133: App_Exception.Raise_Exception;
1134: END insert_othinst;
1135: --dhan
1136: PROCEDURE insert_edugoal_details(p_person_id IN igs_ad_edugoal.person_id%TYPE,
1137: p_adm_appl_number IN igs_ad_edugoal.admission_appl_number%TYPE,

Line 1200: App_Exception.Raise_Exception;

1196: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1197: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_edugoal_details -'||SQLERRM);
1198: IGS_GE_MSG_STACK.ADD;
1199: END IF;
1200: App_Exception.Raise_Exception;
1201: END insert_edugoal_details;
1202:
1203: PROCEDURE insert_ss_appl_stg(x_message_name OUT NOCOPY VARCHAR2,
1204: x_return_status OUT NOCOPY VARCHAR2,

Line 1269: App_Exception.Raise_Exception;

1265: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1266: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_stg -'||SQLERRM);
1267: IGS_GE_MSG_STACK.ADD;
1268: END IF;
1269: App_Exception.Raise_Exception;
1270: END insert_ss_appl_stg;
1271:
1272: PROCEDURE insert_ss_appl_perstat_stg(p_return_status OUT NOCOPY VARCHAR2,
1273: p_message_data OUT NOCOPY VARCHAR2,

Line 1355: App_Exception.Raise_Exception;

1351: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1352: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_perstat_stg -'||SQLERRM);
1353: IGS_GE_MSG_STACK.ADD;
1354: END IF;
1355: App_Exception.Raise_Exception;
1356: END insert_ss_appl_perstat_stg;
1357:
1358: PROCEDURE delete_ss_appl_stg(x_message_name OUT NOCOPY VARCHAR2,
1359: x_return_status OUT NOCOPY VARCHAR2,

Line 1452: App_Exception.Raise_Exception;

1448: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1449: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.delete_ss_appl_stg -'||SQLERRM);
1450: IGS_GE_MSG_STACK.ADD;
1451: END IF;
1452: App_Exception.Raise_Exception;
1453:
1454: END delete_ss_appl_stg;
1455:
1456: --Procedure for transferring Personal Statements/Attachments

Line 1593: App_Exception.Raise_Exception;

1589: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_attachment -'||SQLERRM);
1590: IGS_GE_MSG_STACK.ADD;
1591: END IF;
1592:
1593: App_Exception.Raise_Exception;
1594: END transfer_attachment;
1595:
1596: --Procedure sent from HQ to be added
1597: -----------------------------------

Line 1648: app_exception.raise_exception;

1644: IF cur_sequence%NOTFOUND THEN
1645: fnd_message.set_name('IGS', 'IGS_AD_INQ_ADMCAL_SEQ_NOTDFN');
1646: fnd_message.set_token('CAL_TYPE', p_adm_cal_type);
1647: IGS_GE_MSG_STACK.ADD;
1648: app_exception.raise_exception;
1649: END IF;
1650:
1651: p_adm_seq := sequence_rec.adm_sequence_number;
1652: p_acad_cal_type := sequence_rec.acad_cal_type;

Line 1758: App_Exception.Raise_Exception;

1754: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1755: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_FeeExists -'||SQLERRM);
1756: IGS_GE_MSG_STACK.ADD;
1757: END IF;
1758: App_Exception.Raise_Exception;
1759:
1760: END Check_FeeExists;
1761:
1762: -- Check to see if the application is a one-stop type application

Line 1866: App_Exception.Raise_Exception;

1862: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1863: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_OneStop -'||SQLERRM);
1864: IGS_GE_MSG_STACK.ADD;
1865: END IF;
1866: App_Exception.Raise_Exception;
1867:
1868: END Check_OneStop;
1869:
1870: -- This procedure will only be called if it is a one-stop application

Line 2093: App_Exception.Raise_Exception;

2089: IF FND_MSG_PUB.Count_Msg < 1 THEN
2090: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2091: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop -'||SQLERRM);
2092: IGS_GE_MSG_STACK.ADD;
2093: App_Exception.Raise_Exception;
2094: END IF;
2095: x_message_data := 'IGS_GE_UNHANDLED_EXP';
2096: END IF;
2097: END Process_OneStop;

Line 2499: App_Exception.Raise_Exception;

2495: IF FND_MSG_PUB.Count_Msg < 1 THEN
2496: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2497: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop2 -'||SQLERRM);
2498: IGS_GE_MSG_STACK.ADD;
2499: App_Exception.Raise_Exception;
2500: END IF;
2501: x_msg_data := 'IGS_GE_UNHANDLED_EXP';
2502: END IF;
2503:

Line 2742: App_Exception.Raise_Exception;

2738: IF FND_MSG_PUB.Count_Msg < 1 THEN
2739: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2740: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Eqdo_Inst -'||SQLERRM);
2741: IGS_GE_MSG_STACK.ADD;
2742: App_Exception.Raise_Exception;
2743: END IF;
2744: x_return_status := 'E';
2745: x_message_data := 'IGS_GE_UNHANDLED_EXP';
2746:

Line 2965: App_Exception.Raise_Exception;

2961: IF FND_MSG_PUB.Count_Msg < 1 THEN
2962: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2963: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Ofr_Inst -'||SQLERRM);
2964: IGS_GE_MSG_STACK.ADD;
2965: App_Exception.Raise_Exception;
2966: END IF;
2967: x_return_status := 'E';
2968: x_message_data := 'IGS_GE_UNHANDLED_EXP';
2969:

Line 3226: App_Exception.Raise_Exception;

3222: IGS_GE_MSG_STACK.ADD;
3223: END IF;
3224: x_return_status := 'E';
3225: x_message_name := 'IGS_GE_UNHANDLED_EXP';
3226: App_Exception.Raise_Exception;
3227:
3228: END insert_appl_section_stat;
3229:
3230: -- Procedure added by tray

Line 3373: App_Exception.Raise_Exception;

3369: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3370: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_application_fee -'||SQLERRM);
3371: IGS_GE_MSG_STACK.ADD;
3372: END IF;
3373: App_Exception.Raise_Exception;
3374:
3375: END insert_application_fee;
3376:
3377: /*

Line 5886: App_Exception.Raise_Exception;

5882: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
5883: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application_detail -'||SQLERRM);
5884: IGS_GE_MSG_STACK.ADD;
5885: END IF;
5886: App_Exception.Raise_Exception;
5887:
5888: END create_application_detail;
5889:
5890: FUNCTION wf_submit_application_sub(p_subscription_guid IN RAW,