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_MESSAGE

Line 176: FND_MESSAGE.SET_NAME('IGS', l_message_name);

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;
180: x_return_status := l_return_status;

Line 186: FND_MESSAGE.SET_NAME('IGS', l_message_name);

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;
190: x_return_status := l_return_status;

Line 213: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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';
217: END IF;

Line 214: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_data -'||SQLERRM);

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';
217: END IF;
218: App_Exception.Raise_Exception;

Line 331: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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';
335: END IF;

Line 332: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application -'||SQLERRM);

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';
335: END IF;
336: App_Exception.Raise_Exception;

Line 636: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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';
640: END IF;

Line 637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_program -'||SQLERRM);

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';
640: END IF;
641: App_Exception.Raise_Exception;

Line 723: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
727: App_Exception.Raise_Exception;

Line 724: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_person_type -'||SQLERRM);

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;
727: App_Exception.Raise_Exception;
728: END update_person_type;

Line 810: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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

Line 811: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_unit_set_dtls -'||SQLERRM);

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;
814:
815: App_Exception.Raise_Exception;

Line 874: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
878: App_Exception.Raise_Exception;

Line 875: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_acad_interest -'||SQLERRM);

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;
878: App_Exception.Raise_Exception;
879: END insert_acad_interest;

Line 953: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
957: App_Exception.Raise_Exception;

Line 954: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_applicant_intent -'||SQLERRM);

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;
957: App_Exception.Raise_Exception;
958: END insert_applicant_intent;

Line 1012: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
1016: App_Exception.Raise_Exception;

Line 1013: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_spl_talent -'||SQLERRM);

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;
1016: App_Exception.Raise_Exception;
1017: END insert_spl_talent;

Line 1071: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
1075: App_Exception.Raise_Exception;

Line 1072: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_special_interest -'||SQLERRM);

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;
1075: App_Exception.Raise_Exception;
1076: END insert_special_interest;

Line 1129: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
1133: App_Exception.Raise_Exception;

Line 1130: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_othinst -'||SQLERRM);

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;
1133: App_Exception.Raise_Exception;
1134: END insert_othinst;

Line 1196: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
1200: App_Exception.Raise_Exception;

Line 1197: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_edugoal_details -'||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;
1200: App_Exception.Raise_Exception;
1201: END insert_edugoal_details;

Line 1265: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
1269: App_Exception.Raise_Exception;

Line 1266: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_stg -'||SQLERRM);

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;
1269: App_Exception.Raise_Exception;
1270: END insert_ss_appl_stg;

Line 1351: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
1355: App_Exception.Raise_Exception;

Line 1352: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_ss_appl_perstat_stg -'||SQLERRM);

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;
1355: App_Exception.Raise_Exception;
1356: END insert_ss_appl_perstat_stg;

Line 1448: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
1452: App_Exception.Raise_Exception;

Line 1449: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.delete_ss_appl_stg -'||SQLERRM);

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;
1452: App_Exception.Raise_Exception;
1453:

Line 1588: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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

Line 1589: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.transfer_attachment -'||SQLERRM);

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;
1592:
1593: App_Exception.Raise_Exception;

Line 1645: fnd_message.set_name('IGS', 'IGS_AD_INQ_ADMCAL_SEQ_NOTDFN');

1641: FETCH cur_sequence
1642: INTO sequence_rec;
1643:
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;

Line 1646: fnd_message.set_token('CAL_TYPE', p_adm_cal_type);

1642: INTO sequence_rec;
1643:
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:

Line 1754: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
1758: App_Exception.Raise_Exception;

Line 1755: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_FeeExists -'||SQLERRM);

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;
1758: App_Exception.Raise_Exception;
1759:

Line 1846: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_ONESTOP_NO_DATA_FOUND');

1842: l_debug_str := 'It Not An One Stop Application ';
1843: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1844: END IF;
1845:
1846: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_ONESTOP_NO_DATA_FOUND');
1847: IGS_GE_MSG_STACK.ADD;
1848: x_return_status := 'N'; -- This is used to specify that application is not onestop
1849: x_message_data := 'IGS_AD_ONESTOP_NO_DATA_FOUND';
1850:

Line 1862: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
1866: App_Exception.Raise_Exception;

Line 1863: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Check_OneStop -'||SQLERRM);

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;
1866: App_Exception.Raise_Exception;
1867:

Line 1956: FND_MESSAGE.SET_NAME('IGS', l_msg_data);

1952: IF l_return_status = 'E' THEN ----check_update_aeps_acs return status
1953: IF p_role <> 'ADMIN' THEN
1954: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
1955: END IF;
1956: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
1957: IGS_GE_MSG_STACK.ADD;
1958: x_return_status := 'E';
1959: x_message_data := l_msg_data;
1960: RETURN;

Line 1987: FND_MESSAGE.SET_NAME('IGS', l_msg_data);

1983: IF l_return_status = 'E' THEN --- Update_Appl_Eqdo_Inst return status
1984: IF p_role <> 'ADMIN' THEN
1985: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
1986: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
1987: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
1988: IGS_GE_MSG_STACK.ADD;
1989: END IF;
1990: x_return_status := 'E';
1991: x_message_data := l_msg_data;

Line 2021: FND_MESSAGE.SET_NAME('IGS', l_msg_data);

2017: IF p_role <> 'ADMIN' THEN
2018: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2019: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
2020: END IF;
2021: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
2022: IGS_GE_MSG_STACK.ADD;
2023: x_return_status := 'E';
2024: x_message_data := l_msg_data;
2025: RETURN;

Line 2049: FND_MESSAGE.SET_NAME('IGS', l_message_data);

2045: IF l_return_status = 'E' THEN -- Update_Appl_Ofr_Inst return status
2046: IF p_role <> 'ADMIN' THEN
2047: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
2048: l_message_data := 'IGS_AD_APPL_PRC_FAILED';
2049: FND_MESSAGE.SET_NAME('IGS', l_message_data);
2050: IGS_GE_MSG_STACK.ADD;
2051: END IF;
2052: x_return_status := 'E';
2053: x_message_data := l_message_data;

Line 2064: FND_MESSAGE.SET_NAME('IGS', l_message_data);

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';
2068: x_message_data := l_message_data;

Line 2085: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APPL_PRC_FAILED');

2081: logDetail('Exception from Process_OneStop, ' || SQLERRM, 'S');
2082: x_return_status := 'E';
2083: IF p_role <> 'ADMIN' THEN
2084: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
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

Line 2090: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
2094: END IF;

Line 2091: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop -'||SQLERRM);

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;
2094: END IF;
2095: x_message_data := 'IGS_GE_UNHANDLED_EXP';

Line 2296: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
2300: END update_ad_offer_resp_and_fee;

Line 2297: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_ad_offer_resp_and_fee -'||SQLERRM);

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;
2300: END update_ad_offer_resp_and_fee;
2301:

Line 2410: FND_MESSAGE.SET_NAME('IGS', l_msg_data);

2406: IF l_return_status = 'E' THEN ----check_offer_resp_update return status
2407: IF p_role <> 'ADMIN' THEN
2408: l_msg_data := 'IGS_AD_APPL_PRC_FAILED';
2409: END IF;
2410: FND_MESSAGE.SET_NAME('IGS', l_msg_data);
2411: IGS_GE_MSG_STACK.ADD;
2412: x_return_status := 'E';
2413: x_msg_data := l_msg_data;
2414: RETURN;

Line 2451: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_AUTO_ENR_FAILED');

2447: l_debug_str := 'After igs_ad_upd_initialise.perform_pre_enrol Failed v_message_name ' || v_message_name;
2448: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2449: END IF;
2450:
2451: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_AUTO_ENR_FAILED');
2452: IGS_GE_MSG_STACK.ADD;
2453: x_return_status := 'E';
2454: x_msg_data := 'IGS_AD_AUTO_ENR_FAILED'; --Supressing the error message from the Pre Enr process as per communication on bug2405076
2455: RETURN;

Line 2491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APPL_PRC_FAILED');

2487: logDetail('Exception from Process_OneStop2, ' || SQLERRM, 'S');
2488: x_return_status := 'E';
2489: IF p_role <> 'ADMIN' THEN
2490: IGS_GE_MSG_STACK.INITIALIZE; -- Remove all other messages from stack
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

Line 2496: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
2500: END IF;

Line 2497: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Process_OneStop2 -'||SQLERRM);

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;
2500: END IF;
2501: x_msg_data := 'IGS_GE_UNHANDLED_EXP';

Line 2729: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);

2725: WHEN OTHERS THEN
2726: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;
2727: WHILE l_sc_msg_count <> 0 loop
2728: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
2729: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
2730: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
2731: x_return_status := 'E';
2732: x_message_data := 'IGS_SC_POLICY_EXCEPTION';
2733: RETURN;

Line 2739: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
2743: END IF;

Line 2740: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Eqdo_Inst -'||SQLERRM);

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;
2743: END IF;
2744: x_return_status := 'E';

Line 2952: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);

2948: WHEN OTHERS THEN
2949: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;
2950: WHILE l_sc_msg_count <> 0 loop
2951: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
2952: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
2953: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
2954: x_return_status := 'E';
2955: x_message_data := 'IGS_SC_POLICY_EXCEPTION';
2956: RETURN;

Line 2962: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
2966: END IF;

Line 2963: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.Update_Appl_Ofr_Inst -'||SQLERRM);

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;
2966: END IF;
2967: x_return_status := 'E';

Line 3220: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
3224: x_return_status := 'E';

Line 3221: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_appl_section_stat -'||SQLERRM);

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;
3224: x_return_status := 'E';
3225: x_message_name := 'IGS_GE_UNHANDLED_EXP';

Line 3369: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
3373: App_Exception.Raise_Exception;

Line 3370: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_application_fee -'||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;
3373: App_Exception.Raise_Exception;
3374:

Line 4570: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
4574: END update_appl_section_stat;

Line 4571: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_appl_section_stat -'||SQLERRM);

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;
4574: END update_appl_section_stat;
4575:

Line 4636: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
4640: IF c_NoPgs%ISOPEN THEN

Line 4637: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.sync_appl_section_stat -'||SQLERRM);

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;
4640: IF c_NoPgs%ISOPEN THEN
4641: CLOSE c_NoPgs;

Line 4815: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_PRIVACY_STMT_HDR'); --'Privacy Statement'

4811: lv_rowid := '';
4812: FOR i IN 1 .. 10
4813: LOOP
4814: IF i = 1 then
4815: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_PRIVACY_STMT_HDR'); --'Privacy Statement'
4816: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_PRIVACY_STMT');
4817: lv_incl_flag := 'Y';
4818: ELSIF i = 2 then
4819: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_VERIFY_STMT_HDR'); --'Verification Statement';

Line 4816: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_PRIVACY_STMT');

4812: FOR i IN 1 .. 10
4813: LOOP
4814: IF i = 1 then
4815: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_PRIVACY_STMT_HDR'); --'Privacy Statement'
4816: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_PRIVACY_STMT');
4817: lv_incl_flag := 'Y';
4818: ELSIF i = 2 then
4819: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_VERIFY_STMT_HDR'); --'Verification Statement';
4820: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_VERIFICATION_STMT');

Line 4819: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_VERIFY_STMT_HDR'); --'Verification Statement';

4815: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_PRIVACY_STMT_HDR'); --'Privacy Statement'
4816: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_PRIVACY_STMT');
4817: lv_incl_flag := 'Y';
4818: ELSIF i = 2 then
4819: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_VERIFY_STMT_HDR'); --'Verification Statement';
4820: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_VERIFICATION_STMT');
4821: lv_incl_flag := 'Y';
4822: ELSE
4823: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SS_COND_HDR');

Line 4820: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_VERIFICATION_STMT');

4816: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_PRIVACY_STMT');
4817: lv_incl_flag := 'Y';
4818: ELSIF i = 2 then
4819: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_VERIFY_STMT_HDR'); --'Verification Statement';
4820: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_VERIFICATION_STMT');
4821: lv_incl_flag := 'Y';
4822: ELSE
4823: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SS_COND_HDR');
4824: FND_MESSAGE.SET_TOKEN('COND_ID',i);

Line 4823: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SS_COND_HDR');

4819: lv_cond_disp_name := FND_MESSAGE.GET_STRING('IGS','IGS_AD_SS_VERIFY_STMT_HDR'); --'Verification Statement';
4820: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_VERIFICATION_STMT');
4821: lv_incl_flag := 'Y';
4822: ELSE
4823: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SS_COND_HDR');
4824: FND_MESSAGE.SET_TOKEN('COND_ID',i);
4825: lv_cond_disp_name := FND_MESSAGE.GET;
4826: lv_incl_flag := 'N';
4827: END IF;

Line 4824: FND_MESSAGE.SET_TOKEN('COND_ID',i);

4820: -- lv_cond_disp_txt := FND_MESSAGE.GET_STRING('IGS','IGS_SS_VERIFICATION_STMT');
4821: lv_incl_flag := 'Y';
4822: ELSE
4823: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SS_COND_HDR');
4824: FND_MESSAGE.SET_TOKEN('COND_ID',i);
4825: lv_cond_disp_name := FND_MESSAGE.GET;
4826: lv_incl_flag := 'N';
4827: END IF;
4828: lv_appl_type := p_appl_type;

Line 4825: lv_cond_disp_name := FND_MESSAGE.GET;

4821: lv_incl_flag := 'Y';
4822: ELSE
4823: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SS_COND_HDR');
4824: FND_MESSAGE.SET_TOKEN('COND_ID',i);
4825: lv_cond_disp_name := FND_MESSAGE.GET;
4826: lv_incl_flag := 'N';
4827: END IF;
4828: lv_appl_type := p_appl_type;
4829: lv_cond_disp_txt := NULL;

Line 4853: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
4857: END auto_assign_pgs_comps_terms;

Line 4854: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.auto_assign_pgs_comps_terms -'||SQLERRM);

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;
4857: END auto_assign_pgs_comps_terms;
4858:

Line 5775: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
5779: END get_ss_lookup_desc;

Line 5776: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.get_ss_lookup_desc -'||SQLERRM);

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;
5779: END get_ss_lookup_desc;
5780:

Line 5815: fnd_message.set_name( 'IGS', 'IGS_SC_PRE_CHECK_EXCEP');

5811: x_error_msg := NULL;
5812: ELSE
5813: x_return_status := 'E';
5814: IF l_msg_data IS NOT NULL THEN
5815: fnd_message.set_name( 'IGS', 'IGS_SC_PRE_CHECK_EXCEP');
5816: fnd_message.set_token('ERRM',l_msg_data);
5817: fnd_message.set_token('TABLE','IGS_AD_PS_APPL_INST_SV');
5818: fnd_message.set_token('OPERATION','SELECT');
5819: x_error_msg := 'IGS_SC_PRE_CHECK_EXCEP';

Line 5816: fnd_message.set_token('ERRM',l_msg_data);

5812: ELSE
5813: x_return_status := 'E';
5814: IF l_msg_data IS NOT NULL THEN
5815: fnd_message.set_name( 'IGS', 'IGS_SC_PRE_CHECK_EXCEP');
5816: fnd_message.set_token('ERRM',l_msg_data);
5817: fnd_message.set_token('TABLE','IGS_AD_PS_APPL_INST_SV');
5818: fnd_message.set_token('OPERATION','SELECT');
5819: x_error_msg := 'IGS_SC_PRE_CHECK_EXCEP';
5820: ELSE

Line 5817: fnd_message.set_token('TABLE','IGS_AD_PS_APPL_INST_SV');

5813: x_return_status := 'E';
5814: IF l_msg_data IS NOT NULL THEN
5815: fnd_message.set_name( 'IGS', 'IGS_SC_PRE_CHECK_EXCEP');
5816: fnd_message.set_token('ERRM',l_msg_data);
5817: fnd_message.set_token('TABLE','IGS_AD_PS_APPL_INST_SV');
5818: fnd_message.set_token('OPERATION','SELECT');
5819: x_error_msg := 'IGS_SC_PRE_CHECK_EXCEP';
5820: ELSE
5821: fnd_message.set_name( 'IGS', 'IGS_SC_NO_ACCESS_PRIV');

Line 5818: fnd_message.set_token('OPERATION','SELECT');

5814: IF l_msg_data IS NOT NULL THEN
5815: fnd_message.set_name( 'IGS', 'IGS_SC_PRE_CHECK_EXCEP');
5816: fnd_message.set_token('ERRM',l_msg_data);
5817: fnd_message.set_token('TABLE','IGS_AD_PS_APPL_INST_SV');
5818: fnd_message.set_token('OPERATION','SELECT');
5819: x_error_msg := 'IGS_SC_PRE_CHECK_EXCEP';
5820: ELSE
5821: fnd_message.set_name( 'IGS', 'IGS_SC_NO_ACCESS_PRIV');
5822: x_error_msg := 'IGS_SC_NO_ACCESS_PRIV';

Line 5821: fnd_message.set_name( 'IGS', 'IGS_SC_NO_ACCESS_PRIV');

5817: fnd_message.set_token('TABLE','IGS_AD_PS_APPL_INST_SV');
5818: fnd_message.set_token('OPERATION','SELECT');
5819: x_error_msg := 'IGS_SC_PRE_CHECK_EXCEP';
5820: ELSE
5821: fnd_message.set_name( 'IGS', 'IGS_SC_NO_ACCESS_PRIV');
5822: x_error_msg := 'IGS_SC_NO_ACCESS_PRIV';
5823: END IF;
5824: IGS_GE_MSG_STACK.ADD;
5825: END IF;

Line 5882: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

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;
5886: App_Exception.Raise_Exception;

Line 5883: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.create_application_detail -'||SQLERRM);

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;
5886: App_Exception.Raise_Exception;
5887: