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 FND_MSG_PUB

Line 175: IF FND_MSG_PUB.Count_Msg < 1 AND l_message_name IS NOT NULL THEN

171: END IF;
172:
173: ELSE
174: --Program import failed, Set the message and return, in calling proc , check for ret_stat , if 'E' set message sent from here
175: IF FND_MSG_PUB.Count_Msg < 1 AND l_message_name IS NOT NULL THEN
176: FND_MESSAGE.SET_NAME('IGS', l_message_name);
177: IGS_GE_MSG_STACK.ADD;
178: END IF;
179: x_message_name := l_message_name;

Line 185: IF FND_MSG_PUB.Count_Msg < 1 AND l_message_name IS NOT NULL THEN

181: RETURN;
182: END IF;
183: ELSE
184: --Application import failed, Set the message and return, in calling proc , check for ret_stat , if 'E' set message sent from here
185: IF FND_MSG_PUB.Count_Msg < 1 AND l_message_name IS NOT NULL THEN
186: FND_MESSAGE.SET_NAME('IGS', l_message_name);
187: IGS_GE_MSG_STACK.ADD;
188: END IF;
189: x_message_name := l_message_name;

Line 212: FND_MSG_PUB.Count_Msg < 1 THEN

208: logDetail('Exception from transfer_data, ' || SQLERRM, 'S');
209: x_return_status := 'E';
210:
211: IF l_message_name <> 'IGS_SC_POLICY_EXCEPTION' AND l_message_name <> 'IGS_GE_UNHANDLED_EXP' AND
212: FND_MSG_PUB.Count_Msg < 1 THEN
213: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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';

Line 330: FND_MSG_PUB.Count_Msg < 1 THEN

326: p_return_status := 'E';
327: logDetail('Exception from create_application, MAIN LOOP: ' || SQLERRM, 'S');
328:
329: IF l_message_name <> 'IGS_SC_POLICY_EXCEPTION' AND l_message_name <> 'IGS_GE_UNHANDLED_EXP' AND
330: FND_MSG_PUB.Count_Msg < 1 THEN
331: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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';

Line 635: FND_MSG_PUB.Count_Msg < 1 THEN

631: p_return_status := 'E';
632: logDetail('Exception from create_program, MAIN LOOP: ' || SQLERRM, 'S');
633:
634: IF l_message_name <> 'IGS_SC_POLICY_EXCEPTION' AND l_message_name <> 'IGS_GE_UNHANDLED_EXP' AND
635: FND_MSG_PUB.Count_Msg < 1 THEN
636: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
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';

Line 722: IF FND_MSG_PUB.Count_Msg < 1 THEN

718: 'Exception from IGS_PE_TYP_INSTANCES_PKG.insert_row ' ||
719: SQLERRM || 'person_id : ' ||
720: IGS_GE_NUMBER.TO_CANN(p_person_id),
721: 'S');
722: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 809: IF FND_MSG_PUB.Count_Msg < 1 THEN

805: 'Exception from IGS_AD_UNIT_SETS_PKG.insert_row ' ||
806: SQLERRM || 'person_id : ' ||
807: IGS_GE_NUMBER.TO_CANN(p_person_id),
808: 'S');
809: IF FND_MSG_PUB.Count_Msg < 1 THEN
810: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
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;

Line 873: IF FND_MSG_PUB.Count_Msg < 1 THEN

869: 'Exception from IGS_AD_ACAD_INTEREST_PKG.insert_row ' ||
870: SQLERRM || 'person_id : ' ||
871: IGS_GE_NUMBER.TO_CANN(p_person_id),
872: 'S');
873: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 952: IF FND_MSG_PUB.Count_Msg < 1 THEN

948: 'Exception from IGS_AD_APP_INTENT_PKG.insert_row ' ||
949: SQLERRM || 'person_id : ' ||
950: IGS_GE_NUMBER.TO_CANN(p_person_id),
951: 'S');
952: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 1011: IF FND_MSG_PUB.Count_Msg < 1 THEN

1007: 'Exception from IGS_AD_SPL_TALENTS_PKG.insert_row ' ||
1008: SQLERRM || 'person_id : ' ||
1009: IGS_GE_NUMBER.TO_CANN(p_person_id),
1010: 'S');
1011: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 1070: IF FND_MSG_PUB.Count_Msg < 1 THEN

1066: 'Exception from IGS_AD_SPL_INTERESTS_PKG.insert_row ' ||
1067: SQLERRM || 'person_id : ' ||
1068: IGS_GE_NUMBER.TO_CANN(p_person_id),
1069: 'S');
1070: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 1128: IF FND_MSG_PUB.Count_Msg < 1 THEN

1124: 'Exception from IGS_AD_OTHER_INST_PKG.insert_row ' ||
1125: SQLERRM || 'person_id : ' ||
1126: IGS_GE_NUMBER.TO_CANN(p_person_id),
1127: 'S');
1128: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 1195: IF FND_MSG_PUB.Count_Msg < 1 THEN

1191: logDetail('insert_edugoal_details' ||
1192: 'Exception from IGS_AD_EDUGOAL_PKG.insert_row' || SQLERRM ||
1193: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1194: 'S');
1195: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 1264: IF FND_MSG_PUB.Count_Msg < 1 THEN

1260: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1261: 'S');
1262: x_return_status := 'E';
1263: x_message_name := 'IGS_GE_UNHANDLED_EXP';
1264: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 1350: IF FND_MSG_PUB.Count_Msg < 1 THEN

1346: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1347: 'S');
1348: p_return_status := 'E';
1349: p_message_data := 'IGS_GE_UNHANDLED_EXP';
1350: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 1447: IF FND_MSG_PUB.Count_Msg < 1 THEN

1443: WHEN OTHERS THEN
1444: logDetail('Exception from delete_ss_appl_stg, ' || SQLERRM, 'S');
1445: x_return_status := 'E';
1446: x_message_name := 'IGS_GE_UNHANDLED_EXP';
1447: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 1587: IF FND_MSG_PUB.Count_Msg < 1 THEN

1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: x_return_status := 'E';
1586: logDetail('Exception from transfer_attachment ' || SQLERRM, 'S');
1587: IF FND_MSG_PUB.Count_Msg < 1 THEN
1588: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1589: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_attachment -'||SQLERRM);
1590: IGS_GE_MSG_STACK.ADD;
1591: END IF;

Line 1753: IF FND_MSG_PUB.Count_Msg < 1 THEN

1749: WHEN OTHERS THEN
1750: x_return_status := 'E';
1751: x_message_data := 'IGS_GE_UNHANDLED_EXP';
1752: logDetail('Exception from Check_FeeExists ' || SQLERRM, 'S');
1753: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 1861: IF FND_MSG_PUB.Count_Msg < 1 THEN

1857:
1858: x_return_status := 'E';
1859: x_message_data := 'IGS_GE_UNHANDLED_EXP';
1860: logDetail('Exception from Check_OneStop ' || SQLERRM, 'S');
1861: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 2063: IF FND_MSG_PUB.Count_Msg < 1 AND l_message_data IS NOT NULL THEN

2059: END IF; ----check_update_aeps_acs return status
2060:
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: IF FND_MSG_PUB.Count_Msg < 1 AND l_message_data IS NOT NULL THEN
2064: FND_MESSAGE.SET_NAME('IGS', l_message_data);
2065: IGS_GE_MSG_STACK.ADD;
2066: END IF;
2067: x_return_status := 'E';

Line 2089: IF FND_MSG_PUB.Count_Msg < 1 THEN

2085: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APPL_PRC_FAILED');
2086: IGS_GE_MSG_STACK.ADD;
2087: x_message_data := 'IGS_AD_APPL_PRC_FAILED';
2088: ELSE
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;

Line 2295: IF FND_MSG_PUB.Count_Msg < 1 THEN

2291: EXCEPTION
2292: WHEN OTHERS THEN
2293: x_return_status := 'E';
2294: x_msg_data := 'IGS_GE_UNHANDLED_EXP';
2295: IF FND_MSG_PUB.Count_Msg < 1 THEN
2296: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2297: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_ad_offer_resp_and_fee -'||SQLERRM);
2298: IGS_GE_MSG_STACK.ADD;
2299: END IF;

Line 2495: IF FND_MSG_PUB.Count_Msg < 1 THEN

2491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APPL_PRC_FAILED');
2492: IGS_GE_MSG_STACK.ADD;
2493: x_msg_data := 'IGS_AD_APPL_PRC_FAILED';
2494: ELSE
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;

Line 2738: IF FND_MSG_PUB.Count_Msg < 1 THEN

2734: END IF;
2735: l_sc_msg_count := l_sc_msg_count - 1;
2736: END LOOP;
2737:
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;

Line 2961: IF FND_MSG_PUB.Count_Msg < 1 THEN

2957: END IF;
2958: l_sc_msg_count := l_sc_msg_count - 1;
2959: END LOOP;
2960:
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;

Line 3219: IF FND_MSG_PUB.Count_Msg < 1 THEN

3215: END LOOP;
3216:
3217: EXCEPTION
3218: WHEN OTHERS THEN
3219: IF FND_MSG_PUB.Count_Msg < 1 THEN
3220: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3221: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_appl_section_stat -'||SQLERRM);
3222: IGS_GE_MSG_STACK.ADD;
3223: END IF;

Line 3368: IF FND_MSG_PUB.Count_Msg < 1 THEN

3364: logDetail('Inside insert_application_fee' ||
3365: 'Exception from IGS_AD_APP_REQ_PKG.insert_row ' || SQLERRM ||
3366: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
3367: 'S');
3368: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;

Line 4569: IF FND_MSG_PUB.Count_Msg < 1 THEN

4565: logDetail( 'Exception from update of Application Status, ' || SQLERRM,'S');
4566: x_return_status:='E';
4567: x_message_name := 'IGS_GE_UNHANDLED_EXP';
4568:
4569: IF FND_MSG_PUB.Count_Msg < 1 THEN
4570: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4571: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_appl_section_stat -'||SQLERRM);
4572: IGS_GE_MSG_STACK.ADD;
4573: END IF;

Line 4635: IF FND_MSG_PUB.Count_Msg < 1 THEN

4631: x_return_status := 'E';
4632: x_message_name := 'IGS_GE_UNHANDLED_EXP';
4633: x_max_Sections := 0;
4634: logDetail('Exception from sync_appl_section_stat: ' || SQLERRM, 'S');
4635: IF FND_MSG_PUB.Count_Msg < 1 THEN
4636: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.sync_appl_section_stat -'||SQLERRM);
4638: IGS_GE_MSG_STACK.ADD;
4639: END IF;

Line 4852: IF FND_MSG_PUB.Count_Msg < 1 THEN

4848: EXCEPTION
4849: WHEN OTHERS THEN
4850: x_return_status := 'E';
4851: x_message_name := 'IGS_GE_UNHANDLED_EXP';
4852: IF FND_MSG_PUB.Count_Msg < 1 THEN
4853: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4854: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.auto_assign_pgs_comps_terms -'||SQLERRM);
4855: IGS_GE_MSG_STACK.ADD;
4856: END IF;

Line 5774: IF FND_MSG_PUB.Count_Msg < 1 THEN

5770: WHEN OTHERS THEN
5771: x_return_status := 'E';
5772: x_message_name := 'IGS_GE_UNHANDLED_EXP';
5773: x_concat_desc := NULL;
5774: IF FND_MSG_PUB.Count_Msg < 1 THEN
5775: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5776: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.get_ss_lookup_desc -'||SQLERRM);
5777: IGS_GE_MSG_STACK.ADD;
5778: END IF;

Line 5881: IF FND_MSG_PUB.Count_Msg < 1 THEN

5877: EXCEPTION
5878: --Main Loop Exception
5879: WHEN OTHERS THEN
5880: logDetail('Exception from create_application_detail, MAIN LOOP: ' || SQLERRM, 'S');
5881: IF FND_MSG_PUB.Count_Msg < 1 THEN
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;