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_AV_GEN_001 dependencies on FND_MESSAGE

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

227: RAISE;
228: END;
229: EXCEPTION
230: WHEN OTHERS THEN
231: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
232: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_DEL_ADV_STND');
233: Igs_Ge_Msg_Stack.Add;
234: App_Exception.Raise_Exception;
235: END advp_del_adv_stnd;

Line 232: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_DEL_ADV_STND');

228: END;
229: EXCEPTION
230: WHEN OTHERS THEN
231: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
232: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_DEL_ADV_STND');
233: Igs_Ge_Msg_Stack.Add;
234: App_Exception.Raise_Exception;
235: END advp_del_adv_stnd;
236:

Line 418: V_MESSAGE1 := FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_NOT_GRANT')||TO_CHAR(v_adv_stnd_unit.person_id);

414: v_creation_dt,
415: v_message_name) THEN
416: v_ret_false := v_ret_false + 1;
417:
418: V_MESSAGE1 := FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_NOT_GRANT')||TO_CHAR(v_adv_stnd_unit.person_id);
419: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE1));
420: END IF;
421: IF v_message_name IS NOT NULL AND v_message_name NOT IN ('IGS_AV_HAS_UNIT_ATT') THEN
422: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE_NAME));

Line 419: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE1));

415: v_message_name) THEN
416: v_ret_false := v_ret_false + 1;
417:
418: V_MESSAGE1 := FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_NOT_GRANT')||TO_CHAR(v_adv_stnd_unit.person_id);
419: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE1));
420: END IF;
421: IF v_message_name IS NOT NULL AND v_message_name NOT IN ('IGS_AV_HAS_UNIT_ATT') THEN
422: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE_NAME));
423: END IF;

Line 422: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE_NAME));

418: V_MESSAGE1 := FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_NOT_GRANT')||TO_CHAR(v_adv_stnd_unit.person_id);
419: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE1));
420: END IF;
421: IF v_message_name IS NOT NULL AND v_message_name NOT IN ('IGS_AV_HAS_UNIT_ATT') THEN
422: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE_NAME));
423: END IF;
424: tot_rec_process := tot_rec_process + 1;
425: END LOOP;
426: IF tot_rec_process = 0 THEN

Line 427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_NO_AV_STAND_PRS'));

423: END IF;
424: tot_rec_process := tot_rec_process + 1;
425: END LOOP;
426: IF tot_rec_process = 0 THEN
427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_NO_AV_STAND_PRS'));
428: ELSE
429: V_MESSAGE2 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(tot_rec_process) ;
430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;

Line 429: V_MESSAGE2 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(tot_rec_process) ;

425: END LOOP;
426: IF tot_rec_process = 0 THEN
427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_NO_AV_STAND_PRS'));
428: ELSE
429: V_MESSAGE2 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(tot_rec_process) ;
430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;
432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));
433: END IF;

Line 430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));

426: IF tot_rec_process = 0 THEN
427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_NO_AV_STAND_PRS'));
428: ELSE
429: V_MESSAGE2 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(tot_rec_process) ;
430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;
432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));
433: END IF;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_PRS_SUCCESS'));

Line 431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;

427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_NO_AV_STAND_PRS'));
428: ELSE
429: V_MESSAGE2 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(tot_rec_process) ;
430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;
432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));
433: END IF;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_PRS_SUCCESS'));
435: END;

Line 432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));

428: ELSE
429: V_MESSAGE2 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(tot_rec_process) ;
430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;
432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));
433: END IF;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_PRS_SUCCESS'));
435: END;
436: EXCEPTION

Line 434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_PRS_SUCCESS'));

430: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE2));
431: V_MESSAGE3 := FND_MESSAGE.GET_STRING ('IGS','IGS_GE_TOTAL_REC_FAILED')||TO_CHAR(v_ret_false) ;
432: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS',V_MESSAGE3));
433: END IF;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING ('IGS','IGS_AV_STAND_PRS_SUCCESS'));
435: END;
436: EXCEPTION
437: WHEN OTHERS THEN
438: RETCODE:=2;

Line 439: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

435: END;
436: EXCEPTION
437: WHEN OTHERS THEN
438: RETCODE:=2;
439: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
440: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
441: END advp_upd_as_grant;
442:
443: FUNCTION advp_upd_as_inst(

Line 917: fnd_message.set_name( 'IGS', 'IGS_AV_REPEAT_FAIL');

913:
914: OPEN cur_get_person_num;
915: FETCH cur_get_person_num INTO l_cur_get_person_num;
916: CLOSE cur_get_person_num;
917: fnd_message.set_name( 'IGS', 'IGS_AV_REPEAT_FAIL');
918: fnd_message.set_token('UNIT',igs_av_stnd_unit_rec.unit_cd);
919: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
920: fnd_file.put_line(fnd_file.log,fnd_message.get());
921: fnd_file.put_line(FND_FILE.LOG,' ');

Line 918: fnd_message.set_token('UNIT',igs_av_stnd_unit_rec.unit_cd);

914: OPEN cur_get_person_num;
915: FETCH cur_get_person_num INTO l_cur_get_person_num;
916: CLOSE cur_get_person_num;
917: fnd_message.set_name( 'IGS', 'IGS_AV_REPEAT_FAIL');
918: fnd_message.set_token('UNIT',igs_av_stnd_unit_rec.unit_cd);
919: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
920: fnd_file.put_line(fnd_file.log,fnd_message.get());
921: fnd_file.put_line(FND_FILE.LOG,' ');
922: v_message_key := 'UNIT ' || '|' ||

Line 919: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);

915: FETCH cur_get_person_num INTO l_cur_get_person_num;
916: CLOSE cur_get_person_num;
917: fnd_message.set_name( 'IGS', 'IGS_AV_REPEAT_FAIL');
918: fnd_message.set_token('UNIT',igs_av_stnd_unit_rec.unit_cd);
919: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
920: fnd_file.put_line(fnd_file.log,fnd_message.get());
921: fnd_file.put_line(FND_FILE.LOG,' ');
922: v_message_key := 'UNIT ' || '|' ||
923: TO_CHAR(v_asu_rec.person_id) || '|' ||

Line 920: fnd_file.put_line(fnd_file.log,fnd_message.get());

916: CLOSE cur_get_person_num;
917: fnd_message.set_name( 'IGS', 'IGS_AV_REPEAT_FAIL');
918: fnd_message.set_token('UNIT',igs_av_stnd_unit_rec.unit_cd);
919: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
920: fnd_file.put_line(fnd_file.log,fnd_message.get());
921: fnd_file.put_line(FND_FILE.LOG,' ');
922: v_message_key := 'UNIT ' || '|' ||
923: TO_CHAR(v_asu_rec.person_id) || '|' ||
924: v_asu_rec.as_course_cd || '|' ||

Line 984: fnd_message.set_name('IGS','IGS_AV_GRANTED');

980: TO_CHAR(v_asu_rec.version_number) || '|' ||
981: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
982: -- Insert into messages for reporting
983:
984: fnd_message.set_name('IGS','IGS_AV_GRANTED');
985: cst_granted_ge := fnd_message.get;
986:
987: IF (v_message_name is NULL) THEN
988: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 985: cst_granted_ge := fnd_message.get;

981: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
982: -- Insert into messages for reporting
983:
984: fnd_message.set_name('IGS','IGS_AV_GRANTED');
985: cst_granted_ge := fnd_message.get;
986:
987: IF (v_message_name is NULL) THEN
988: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
989: v_s_log_type,

Line 1191: fnd_message.set_name('IGS','IGS_AV_GRANTED');

1187: v_asul_rec.unit_level || '|' ||
1188: v_asul_rec.crs_group_ind || '|' ||
1189: v_asul_rec.exemption_institution_cd ||'|' ||
1190: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
1191: fnd_message.set_name('IGS','IGS_AV_GRANTED');
1192: cst_granted_ge := fnd_message.get;
1193: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1194: v_s_log_type,
1195: v_creation_dt,

Line 1192: cst_granted_ge := fnd_message.get;

1188: v_asul_rec.crs_group_ind || '|' ||
1189: v_asul_rec.exemption_institution_cd ||'|' ||
1190: FND_DATE.DATE_TO_DISPLAYDATE(v_granted_dt);
1191: fnd_message.set_name('IGS','IGS_AV_GRANTED');
1192: cst_granted_ge := fnd_message.get;
1193: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1194: v_s_log_type,
1195: v_creation_dt,
1196: v_message_key,

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

1205: RETURN TRUE;
1206: END;
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1210: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_AS_PE_GRANT');
1211: Igs_Ge_Msg_Stack.Add;
1212:
1213: lv_param_values := To_Char(p_person_id)||p_course_cd||To_Char(p_version_number)||

Line 1210: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_AS_PE_GRANT');

1206: END;
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1210: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_AS_PE_GRANT');
1211: Igs_Ge_Msg_Stack.Add;
1212:
1213: lv_param_values := To_Char(p_person_id)||p_course_cd||To_Char(p_version_number)||
1214: FND_DATE.DATE_TO_DISPLAYDATE(p_granted_dt)||p_process_type||p_s_log_type||

Line 1216: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

1212:
1213: lv_param_values := To_Char(p_person_id)||p_course_cd||To_Char(p_version_number)||
1214: FND_DATE.DATE_TO_DISPLAYDATE(p_granted_dt)||p_process_type||p_s_log_type||
1215: FND_DATE.DATE_TO_DISPLAYDATE(p_creation_dt);
1216: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1217: Fnd_Message.Set_Token('VALUE',lv_param_values);
1218: Igs_Ge_Msg_Stack.Add;
1219:
1220: App_Exception.Raise_Exception;

Line 1217: Fnd_Message.Set_Token('VALUE',lv_param_values);

1213: lv_param_values := To_Char(p_person_id)||p_course_cd||To_Char(p_version_number)||
1214: FND_DATE.DATE_TO_DISPLAYDATE(p_granted_dt)||p_process_type||p_s_log_type||
1215: FND_DATE.DATE_TO_DISPLAYDATE(p_creation_dt);
1216: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1217: Fnd_Message.Set_Token('VALUE',lv_param_values);
1218: Igs_Ge_Msg_Stack.Add;
1219:
1220: App_Exception.Raise_Exception;
1221: END advp_upd_as_pe_grant;

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

1555: END IF;
1556: END IF;
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1560: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ENRPL_DELETE_SUA_RECS');
1561: Igs_Ge_Msg_Stack.Add;
1562: App_Exception.Raise_Exception;
1563: END;

Line 1560: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ENRPL_DELETE_SUA_RECS');

1556: END IF;
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1560: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ENRPL_DELETE_SUA_RECS');
1561: Igs_Ge_Msg_Stack.Add;
1562: App_Exception.Raise_Exception;
1563: END;
1564: END enrpl_delete_sua_recs;

Line 1727: fnd_message.set_name('IGS',p_message_name);

1723: FETCH cur_get_person_num INTO l_cur_get_person_num;
1724: CLOSE cur_get_person_num;
1725:
1726: p_message_name := 'IGS_AV_HAS_UNIT_ATT';
1727: fnd_message.set_name('IGS',p_message_name);
1728: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
1729: fnd_message.set_token('UNIT',p_unit_cd);
1730: fnd_file.put_line(fnd_file.log,fnd_message.get());
1731: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1728: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);

1724: CLOSE cur_get_person_num;
1725:
1726: p_message_name := 'IGS_AV_HAS_UNIT_ATT';
1727: fnd_message.set_name('IGS',p_message_name);
1728: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
1729: fnd_message.set_token('UNIT',p_unit_cd);
1730: fnd_file.put_line(fnd_file.log,fnd_message.get());
1731: fnd_file.put_line(FND_FILE.LOG,' ');
1732: -- End of new code. Added as per the bug# 2382566.

Line 1729: fnd_message.set_token('UNIT',p_unit_cd);

1725:
1726: p_message_name := 'IGS_AV_HAS_UNIT_ATT';
1727: fnd_message.set_name('IGS',p_message_name);
1728: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
1729: fnd_message.set_token('UNIT',p_unit_cd);
1730: fnd_file.put_line(fnd_file.log,fnd_message.get());
1731: fnd_file.put_line(FND_FILE.LOG,' ');
1732: -- End of new code. Added as per the bug# 2382566.
1733: ELSIF (gv_sua_rec.unit_attempt_status NOT IN (cst_duplicate)) THEN

Line 1730: fnd_file.put_line(fnd_file.log,fnd_message.get());

1726: p_message_name := 'IGS_AV_HAS_UNIT_ATT';
1727: fnd_message.set_name('IGS',p_message_name);
1728: fnd_message.set_token('PERSON',l_cur_get_person_num.party_number);
1729: fnd_message.set_token('UNIT',p_unit_cd);
1730: fnd_file.put_line(fnd_file.log,fnd_message.get());
1731: fnd_file.put_line(FND_FILE.LOG,' ');
1732: -- End of new code. Added as per the bug# 2382566.
1733: ELSIF (gv_sua_rec.unit_attempt_status NOT IN (cst_duplicate)) THEN
1734: p_message_name := NULL;

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

1743: -- set the default return type
1744: RETURN TRUE;
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1748: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_SUA_ADVSTND');
1749: Igs_Ge_Msg_Stack.Add;
1750: App_Exception.Raise_Exception;
1751: END;

Line 1748: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_SUA_ADVSTND');

1744: RETURN TRUE;
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1748: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_SUA_ADVSTND');
1749: Igs_Ge_Msg_Stack.Add;
1750: App_Exception.Raise_Exception;
1751: END;
1752: END advp_upd_sua_advstnd;

Line 1855: FND_MESSAGE.GET_STRING('IGS',

1851: IF (c_adv_stnd_unit%ISOPEN) THEN
1852: CLOSE c_adv_stnd_unit;
1853: END IF;
1854: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(v_person_rec.person_id) || ' '||
1855: FND_MESSAGE.GET_STRING('IGS',
1856: 'IGS_AV_UNABLE_EXP_UNIT_UPD'));
1857: RAISE;
1858: WHEN OTHERS THEN
1859: RAISE;

Line 1900: FND_MESSAGE.GET_STRING('IGS','IGS_AV_LVL_UPD_ANOTHER_PRC'));

1896: IF (c_adv_stnd_unit_level%ISOPEN) THEN
1897: CLOSE c_adv_stnd_unit_level;
1898: END IF;
1899: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(v_person_rec.person_id) || ' '||
1900: FND_MESSAGE.GET_STRING('IGS','IGS_AV_LVL_UPD_ANOTHER_PRC'));
1901: RAISE;
1902: WHEN OTHERS THEN
1903: RAISE;
1904: END;

Line 1913: errbuf:=FND_MESSAGE.GET_STRING('IGS', 'IGS_GE_TOTAL_REC_PROCESSED')|| ' ' ||to_char(lv_count) ;

1909: IF RETCODE='0' THEN
1910: lv_count:=lv_count+1;
1911: END IF;
1912: END LOOP; --End of Person Id Loop
1913: errbuf:=FND_MESSAGE.GET_STRING('IGS', 'IGS_GE_TOTAL_REC_PROCESSED')|| ' ' ||to_char(lv_count) ;
1914: retcode:=0;
1915: EXCEPTION
1916: WHEN OTHERS THEN
1917: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 1917: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1913: errbuf:=FND_MESSAGE.GET_STRING('IGS', 'IGS_GE_TOTAL_REC_PROCESSED')|| ' ' ||to_char(lv_count) ;
1914: retcode:=0;
1915: EXCEPTION
1916: WHEN OTHERS THEN
1917: ERRBUF:= FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1918: retcode:=2;
1919: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1920: END;
1921: END advp_upd_as_pe_expry;

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

2017: END IF;
2018: RETURN 'Y';
2019: EXCEPTION
2020: WHEN OTHERS THEN
2021: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2022: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.ADVP_VAL_BASIS_YEAR');
2023: App_Exception.Raise_Exception;
2024: IGS_GE_MSG_STACK.ADD;
2025: END;

Line 2022: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.ADVP_VAL_BASIS_YEAR');

2018: RETURN 'Y';
2019: EXCEPTION
2020: WHEN OTHERS THEN
2021: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2022: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.ADVP_VAL_BASIS_YEAR');
2023: App_Exception.Raise_Exception;
2024: IGS_GE_MSG_STACK.ADD;
2025: END;
2026: END advp_val_basis_year;

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

2140:
2141: RETURN 'Y';
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2145: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.eval_unit_repeat');
2146: App_Exception.Raise_Exception;
2147: IGS_GE_MSG_STACK.ADD;
2148: END eval_unit_repeat;

Line 2145: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.eval_unit_repeat');

2141: RETURN 'Y';
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2145: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.eval_unit_repeat');
2146: App_Exception.Raise_Exception;
2147: IGS_GE_MSG_STACK.ADD;
2148: END eval_unit_repeat;
2149:

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

2234: END LOOP;
2235: EXCEPTION
2236: WHEN OTHERS
2237: THEN
2238: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2239: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.advp_updt_advstnd' || sqlerrm);
2240: App_Exception.Raise_Exception;
2241: IGS_GE_MSG_STACK.ADD;
2242:

Line 2239: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.advp_updt_advstnd' || sqlerrm);

2235: EXCEPTION
2236: WHEN OTHERS
2237: THEN
2238: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2239: Fnd_Message.Set_Token('NAME','IGS_AV_VAL_ASULEB.advp_updt_advstnd' || sqlerrm);
2240: App_Exception.Raise_Exception;
2241: IGS_GE_MSG_STACK.ADD;
2242:
2243: END advp_updt_advstnd;