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_SV_BATCH_PROCESS_PKG dependencies on FND_API

Line 234: RAISE FND_API.G_EXC_ERROR;

230: END IF;
231:
232: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_PRTNR_STP_ERR'); -- No trading partner setup found
233: FND_MSG_PUB.Add;
234: RAISE FND_API.G_EXC_ERROR;
235:
236: END IF;
237:
238: OPEN c_get_user_id;

Line 4714: RAISE FND_API.G_EXC_ERROR;

4710: -- probably a bug
4711: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
4712: FND_MESSAGE.SET_TOKEN('BLOCK_ID',1);
4713: FND_MSG_PUB.Add;
4714: RAISE FND_API.G_EXC_ERROR;
4715:
4716: END IF;
4717:
4718: p_data_rec(l_counter).person_id := p_person_rec.person_id;

Line 5347: WHEN FND_API.G_EXC_ERROR THEN

5343: RETURN 'S';
5344:
5345: EXCEPTION
5346:
5347: WHEN FND_API.G_EXC_ERROR THEN
5348: /* Debug */
5349: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5350: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';
5351: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;

Line 5785: WHEN FND_API.G_EXC_ERROR THEN

5781: RETURN 'S';
5782:
5783: EXCEPTION
5784:
5785: WHEN FND_API.G_EXC_ERROR THEN
5786:
5787: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
5788: /* Debug */
5789: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 5791: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Issue_Info. '||SQLERRM;

5787: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
5788: /* Debug */
5789: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5790: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';
5791: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Issue_Info. '||SQLERRM;
5792: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5793: END IF;
5794:
5795: RETURN 'U';

Line 5921: WHEN FND_API.G_EXC_ERROR THEN

5917: RETURN 'S';
5918:
5919: EXCEPTION
5920:
5921: WHEN FND_API.G_EXC_ERROR THEN
5922: /* Debug */
5923: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5924: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';
5925: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Bio_Info. '||SQLERRM;

Line 5925: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Bio_Info. '||SQLERRM;

5921: WHEN FND_API.G_EXC_ERROR THEN
5922: /* Debug */
5923: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5924: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';
5925: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Bio_Info. '||SQLERRM;
5926: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5927: END IF;
5928:
5929: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);

Line 6035: WHEN FND_API.G_EXC_ERROR THEN

6031: RETURN 'S';
6032:
6033: EXCEPTION
6034:
6035: WHEN FND_API.G_EXC_ERROR THEN
6036:
6037: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6038: /* Debug */
6039: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6041: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Other_Info-- Returning U. '||SQLERRM;

6037: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6038: /* Debug */
6039: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6040: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';
6041: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Other_Info-- Returning U. '||SQLERRM;
6042: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6043: END IF;
6044: RETURN 'U';
6045:

Line 6172: WHEN FND_API.G_EXC_ERROR THEN

6168: RETURN 'S';
6169:
6170: EXCEPTION
6171:
6172: WHEN FND_API.G_EXC_ERROR THEN
6173:
6174: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6175: /* Debug */
6176: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6178: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Address_Info. Returning U... '||SQLERRM;

6174: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6175: /* Debug */
6176: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6177: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';
6178: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Address_Info. Returning U... '||SQLERRM;
6179: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6180: END IF;
6181:
6182: RETURN 'U';

Line 6309: WHEN FND_API.G_EXC_ERROR THEN

6305: RETURN 'S';
6306:
6307: EXCEPTION
6308:
6309: WHEN FND_API.G_EXC_ERROR THEN
6310:
6311: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6312: /* Debug */
6313: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6315: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Edu_Info. '||SQLERRM;

6311: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6312: /* Debug */
6313: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6314: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';
6315: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Edu_Info. '||SQLERRM;
6316: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6317: END IF;
6318:
6319: RETURN 'U';

Line 6475: WHEN FND_API.G_EXC_ERROR THEN

6471: RETURN 'S';
6472:
6473: EXCEPTION
6474:
6475: WHEN FND_API.G_EXC_ERROR THEN
6476:
6477: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6478: /* Debug */
6479: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6481: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Finance_Info. '||SQLERRM;

6477: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6478: /* Debug */
6479: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6480: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';
6481: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Finance_Info. '||SQLERRM;
6482: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6483: END IF;
6484: RETURN 'U';
6485:

Line 6617: WHEN FND_API.G_EXC_ERROR THEN

6613: RETURN 'S';
6614:
6615: EXCEPTION
6616:
6617: WHEN FND_API.G_EXC_ERROR THEN
6618: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6619: /* Debug */
6620: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6621: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';

Line 6622: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Dependent_Info. '||SQLERRM;

6618: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6619: /* Debug */
6620: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6621: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';
6622: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Dependent_Info. '||SQLERRM;
6623: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6624: END IF;
6625: RETURN 'U';
6626:

Line 6745: WHEN FND_API.G_EXC_ERROR THEN

6741: RETURN 'S';
6742:
6743: EXCEPTION
6744:
6745: WHEN FND_API.G_EXC_ERROR THEN
6746:
6747: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6748: /* Debug */
6749: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6751: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Legal_Info. '||SQLERRM;

6747: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6748: /* Debug */
6749: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6750: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';
6751: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Legal_Info. '||SQLERRM;
6752: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6753: END IF;
6754: RETURN 'U';
6755:

Line 8348: RAISE FND_API.G_EXC_ERROR;

8344: l_debug_str := 'Unexpected error in Update_Registration_Info.';
8345: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8346: END IF;
8347:
8348: RAISE FND_API.G_EXC_ERROR;
8349:
8350: ELSIF p_person_rec.legal_status = 'S' THEN
8351:
8352:

Line 8362: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Registration_Info.';

8358: IF l_status = 'U' THEN
8359: /* Debug */
8360: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8361: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8362: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Registration_Info.';
8363: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8364: END IF;
8365:
8366: RAISE FND_API.G_EXC_ERROR;

Line 8366: RAISE FND_API.G_EXC_ERROR;

8362: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Registration_Info.';
8363: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8364: END IF;
8365:
8366: RAISE FND_API.G_EXC_ERROR;
8367:
8368: END IF;
8369:
8370: IF l_status = 'N' OR

Line 8479: RAISE FND_API.G_EXC_ERROR;

8475: ELSIF p_person_rec.f_addr_status = 'U' THEN --Unexpected error - terminate execution
8476:
8477: Put_Log_Msg('Unexpected error returned by validation ',1);
8478:
8479: RAISE FND_API.G_EXC_ERROR;
8480:
8481: ELSIF p_person_rec.f_addr_status = 'N' THEN -- Not found
8482:
8483: Put_Log_Msg('F Address block is not found return S',0);

Line 8509: WHEN FND_API.G_EXC_ERROR THEN

8505: RETURN 'S';
8506:
8507: EXCEPTION
8508:
8509: WHEN FND_API.G_EXC_ERROR THEN
8510:
8511: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
8512: /* Debug */
8513: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 8515: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Registration_Info. '||SQLERRM;

8511: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
8512: /* Debug */
8513: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8514: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8515: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Registration_Info. '||SQLERRM;
8516: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8517: END IF;
8518: RETURN 'U';
8519:

Line 8593: RAISE FND_API.G_EXC_ERROR;

8589: l_debug_str := 'Unexpected error in Update_ev_Legal_Info.';
8590: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8591: END IF;
8592:
8593: RAISE FND_API.G_EXC_ERROR;
8594:
8595: ELSIF p_person_rec.legal_status = 'S' THEN
8596:
8597:

Line 8606: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_ev_Legal_Info.';

8602: IF l_status = 'U' THEN
8603: /* Debug */
8604: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8605: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';
8606: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_ev_Legal_Info.';
8607: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8608: END IF;
8609:
8610: RAISE FND_API.G_EXC_ERROR;

Line 8610: RAISE FND_API.G_EXC_ERROR;

8606: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_ev_Legal_Info.';
8607: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8608: END IF;
8609:
8610: RAISE FND_API.G_EXC_ERROR;
8611:
8612: END IF;
8613:
8614: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 8694: WHEN FND_API.G_EXC_ERROR THEN

8690: RETURN 'S';
8691:
8692: EXCEPTION
8693:
8694: WHEN FND_API.G_EXC_ERROR THEN
8695:
8696: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
8697: /* Debug */
8698: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 8700: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_ev_Legal_Info. '||SQLERRM;

8696: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
8697: /* Debug */
8698: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8699: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';
8700: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_ev_Legal_Info. '||SQLERRM;
8701: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8702: END IF;
8703: RETURN 'U';
8704:

Line 8816: RAISE FND_API.G_EXC_ERROR;

8812: l_debug_str := 'Unexpected error in Update_EV_Address_Info.';
8813: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8814: END IF;
8815:
8816: RAISE FND_API.G_EXC_ERROR;
8817:
8818: ELSIF p_person_rec.us_addr_status = 'N' THEN -- Not found
8819:
8820: Put_Log_Msg('US Address block is not found return S',0);

Line 8888: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';

8884: --Error found l_status = 'U'
8885: /* Debug */
8886: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8887: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8888: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
8889: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8890: END IF;
8891: RAISE FND_API.G_EXC_ERROR;
8892:

Line 8891: RAISE FND_API.G_EXC_ERROR;

8887: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8888: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
8889: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8890: END IF;
8891: RAISE FND_API.G_EXC_ERROR;
8892:
8893: END IF;
8894:
8895: IF p_person_rec.us_addr_status = 'C' AND p_person_rec.person_status <> 'I' THEN

Line 8929: RAISE FND_API.G_EXC_ERROR;

8925: l_debug_str := 'ERROR in Update_EV_Address_Info. us_addr_status is U';
8926: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8927: END IF;
8928:
8929: RAISE FND_API.G_EXC_ERROR;
8930:
8931: ELSIF p_person_rec.us_addr_status = 'N' THEN -- Not found
8932:
8933: Put_Log_Msg('Site of activity Address block is not found return S',0);

Line 9055: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';

9051: --Error found l_statsite = 'U'
9052: /* Debug */
9053: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9054: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
9055: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
9056: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9057: END IF;
9058:
9059: RAISE FND_API.G_EXC_ERROR;

Line 9059: RAISE FND_API.G_EXC_ERROR;

9055: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
9056: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9057: END IF;
9058:
9059: RAISE FND_API.G_EXC_ERROR;
9060:
9061: END IF;
9062:
9063: /* IF p_person_rec.changes_found = 'Y' THEN

Line 9097: WHEN FND_API.G_EXC_ERROR THEN

9093: RETURN 'S';
9094:
9095: EXCEPTION
9096:
9097: WHEN FND_API.G_EXC_ERROR THEN
9098:
9099: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
9100: /* Debug */
9101: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 9103: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Address_Info. '||SQLERRM;

9099: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
9100: /* Debug */
9101: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9102: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
9103: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Address_Info. '||SQLERRM;
9104: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9105: END IF;
9106: RETURN 'U';
9107:

Line 9234: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Personal_Info.';

9230: Put_Log_Msg('UPI - unexpected error returned by validation ',1);
9231: /* Debug */
9232: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9233: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9234: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Personal_Info.';
9235: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9236: END IF;
9237:
9238: RAISE FND_API.G_EXC_ERROR;

Line 9238: RAISE FND_API.G_EXC_ERROR;

9234: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Personal_Info.';
9235: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9236: END IF;
9237:
9238: RAISE FND_API.G_EXC_ERROR;
9239:
9240: ELSIF p_person_rec.bio_status = 'N' THEN -- Not found
9241:
9242: -- These are I-20 blocks and should be found. If this happens - its a bug

Line 9258: RAISE FND_API.G_EXC_ERROR;

9254: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
9255: FND_MESSAGE.SET_TOKEN('BLOCK_ID',2);
9256: FND_MSG_PUB.Add;
9257:
9258: RAISE FND_API.G_EXC_ERROR;
9259:
9260: END IF;
9261:
9262: -- Compare BIO

Line 9271: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. l_status is U';

9267: IF l_status = 'U' THEN
9268: /* Debug */
9269: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9270: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9271: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. l_status is U';
9272: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9273: END IF;
9274: RAISE FND_API.G_EXC_ERROR;
9275:

Line 9274: RAISE FND_API.G_EXC_ERROR;

9270: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9271: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. l_status is U';
9272: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9273: END IF;
9274: RAISE FND_API.G_EXC_ERROR;
9275:
9276: END IF;
9277:
9278: IF l_prev_bio_rec.birth_date

Line 9357: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info.';

9353: --Error found l_status = 'U'
9354: /* Debug */
9355: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9356: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9357: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info.';
9358: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9359: END IF;
9360:
9361: RAISE FND_API.G_EXC_ERROR;

Line 9361: RAISE FND_API.G_EXC_ERROR;

9357: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info.';
9358: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9359: END IF;
9360:
9361: RAISE FND_API.G_EXC_ERROR;
9362:
9363: END IF;
9364:
9365: END IF; --End of read and compare

Line 9420: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. f_addr_status is S';

9416: --Error found l_status = 'U'
9417: /* Debug */
9418: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9419: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9420: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. f_addr_status is S';
9421: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9422: END IF;
9423:
9424: RAISE FND_API.G_EXC_ERROR;

Line 9424: RAISE FND_API.G_EXC_ERROR;

9420: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. f_addr_status is S';
9421: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9422: END IF;
9423:
9424: RAISE FND_API.G_EXC_ERROR;
9425:
9426: END IF;
9427:
9428: END IF; --End of read and compare

Line 9481: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. us_addr_status is S';

9477: --Error found l_status = 'U'
9478: /* Debug */
9479: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9480: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9481: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. us_addr_status is S';
9482: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9483: END IF;
9484:
9485: RAISE FND_API.G_EXC_ERROR;

Line 9485: RAISE FND_API.G_EXC_ERROR;

9481: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. us_addr_status is S';
9482: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9483: END IF;
9484:
9485: RAISE FND_API.G_EXC_ERROR;
9486:
9487: END IF;
9488:
9489: END IF; --End of read and compare

Line 9538: WHEN FND_API.G_EXC_ERROR THEN

9534: RETURN 'S';
9535:
9536: EXCEPTION
9537:
9538: WHEN FND_API.G_EXC_ERROR THEN
9539:
9540: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
9541: /* Debug */
9542: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 9544: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Personal_Info. '||SQLERRM;

9540: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
9541: /* Debug */
9542: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9543: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9544: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Personal_Info. '||SQLERRM;
9545: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9546: END IF;
9547: RETURN 'U';
9548:

Line 9640: WHEN FND_API.G_EXC_ERROR THEN

9636: RETURN 'S';
9637:
9638: EXCEPTION
9639:
9640: WHEN FND_API.G_EXC_ERROR THEN
9641: /* Debug */
9642: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9643: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';
9644: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;

Line 9740: WHEN FND_API.G_EXC_ERROR THEN

9736: RETURN 'S';
9737:
9738: EXCEPTION
9739:
9740: WHEN FND_API.G_EXC_ERROR THEN
9741: /* Debug */
9742: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9743: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';
9744: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;

Line 9831: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';

9827: Put_Log_Msg('Unexpected error returned by validation ',1);
9828: /* Debug */
9829: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9830: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9831: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
9832: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9833: END IF;
9834:
9835: RAISE FND_API.G_EXC_ERROR;

Line 9835: RAISE FND_API.G_EXC_ERROR;

9831: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
9832: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9833: END IF;
9834:
9835: RAISE FND_API.G_EXC_ERROR;
9836:
9837: ELSIF p_person_rec.edu_status = 'N' THEN -- Not found
9838:
9839: -- These are I-20 blocks and should be found. If this happens - its a bug

Line 9845: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';

9841: Put_Log_Msg('EDU block is not found ',0);
9842: /* Debug */
9843: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9844: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9845: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';
9846: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9847: END IF;
9848:
9849: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error

Line 9853: RAISE FND_API.G_EXC_ERROR;

9849: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
9850: FND_MESSAGE.SET_TOKEN('BLOCK_ID',3);
9851: FND_MSG_PUB.Add;
9852:
9853: RAISE FND_API.G_EXC_ERROR;
9854:
9855: END IF;
9856:
9857:

Line 9867: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';

9863: IF l_status = 'U' OR l_status = 'N' THEN
9864: /* Debug */
9865: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9866: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9867: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
9868: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9869: END IF;
9870: RAISE FND_API.G_EXC_ERROR;
9871:

Line 9870: RAISE FND_API.G_EXC_ERROR;

9866: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9867: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
9868: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9869: END IF;
9870: RAISE FND_API.G_EXC_ERROR;
9871:
9872: END IF;
9873:
9874: IF l_prev_rec.position_code

Line 9940: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info.';

9936: Put_Log_Msg('Unexpected error returned by validation ',1);
9937: /* Debug */
9938: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9939: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9940: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info.';
9941: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9942: END IF;
9943:
9944: RAISE FND_API.G_EXC_ERROR;

Line 9944: RAISE FND_API.G_EXC_ERROR;

9940: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info.';
9941: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9942: END IF;
9943:
9944: RAISE FND_API.G_EXC_ERROR;
9945:
9946: END IF;
9947:
9948: FOR l_current IN 1.. l_count LOOP

Line 9964: RAISE FND_API.G_EXC_ERROR;

9960: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
9961: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
9962: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9963: END IF;
9964: RAISE FND_API.G_EXC_ERROR;
9965: END IF;
9966:
9967: IF l_status = 'S' THEN
9968: IF

Line 10024: WHEN FND_API.G_EXC_ERROR THEN

10020: RETURN 'S';
10021:
10022: EXCEPTION
10023:
10024: WHEN FND_API.G_EXC_ERROR THEN
10025:
10026: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10027: /* Debug */
10028: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 10030: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Program_Info. '||SQLERRM;

10026: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10027: /* Debug */
10028: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10029: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10030: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Program_Info. '||SQLERRM;
10031: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10032: END IF;
10033: RETURN 'U';
10034:

Line 10118: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';

10114: Put_Log_Msg('Unexpected error returned by validation ',1);
10115: /* Debug */
10116: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10117: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10118: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
10119: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10120: END IF;
10121:
10122: RAISE FND_API.G_EXC_ERROR;

Line 10122: RAISE FND_API.G_EXC_ERROR;

10118: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
10119: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10120: END IF;
10121:
10122: RAISE FND_API.G_EXC_ERROR;
10123:
10124: ELSIF p_person_rec.edu_status = 'N' THEN -- Not found
10125:
10126: -- These are I-20 blocks and should be found. If this happens - its a bug

Line 10132: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';

10128: Put_Log_Msg('EDU block is not found ',0);
10129: /* Debug */
10130: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10131: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10132: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';
10133: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10134: END IF;
10135:
10136: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error

Line 10140: RAISE FND_API.G_EXC_ERROR;

10136: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
10137: FND_MESSAGE.SET_TOKEN('BLOCK_ID',3);
10138: FND_MSG_PUB.Add;
10139:
10140: RAISE FND_API.G_EXC_ERROR;
10141:
10142: END IF;
10143:
10144:

Line 10154: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';

10150: IF l_status = 'U' OR l_status = 'N' THEN
10151: /* Debug */
10152: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10153: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10154: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
10155: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10156: END IF;
10157: RAISE FND_API.G_EXC_ERROR;
10158:

Line 10157: RAISE FND_API.G_EXC_ERROR;

10153: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10154: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
10155: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10156: END IF;
10157: RAISE FND_API.G_EXC_ERROR;
10158:
10159: END IF;
10160: /*
10161: IF l_prev_rec.position_code

Line 10225: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Program_Info. p_person_rec.edu_status is U.';

10221: Put_Log_Msg('Unexpected error returned by validation ',1);
10222: /* Debug */
10223: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10224: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';
10225: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Program_Info. p_person_rec.edu_status is U.';
10226: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10227: END IF;
10228:
10229: RAISE FND_API.G_EXC_ERROR;

Line 10229: RAISE FND_API.G_EXC_ERROR;

10225: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Program_Info. p_person_rec.edu_status is U.';
10226: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10227: END IF;
10228:
10229: RAISE FND_API.G_EXC_ERROR;
10230:
10231: END IF;
10232:
10233:

Line 10250: RAISE FND_API.G_EXC_ERROR;

10246: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
10247: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
10248: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10249: END IF;
10250: RAISE FND_API.G_EXC_ERROR;
10251: END IF;
10252:
10253: IF l_status = 'S' THEN
10254: IF

Line 10304: WHEN FND_API.G_EXC_ERROR THEN

10300: RETURN 'S';
10301:
10302: EXCEPTION
10303:
10304: WHEN FND_API.G_EXC_ERROR THEN
10305:
10306: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10307: /* Debug */
10308: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 10310: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Program_Info. '||SQLERRM;

10306: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10307: /* Debug */
10308: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10309: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';
10310: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Program_Info. '||SQLERRM;
10311: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10312: END IF;
10313:
10314: RETURN 'U';

Line 10394: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is U';

10390: Put_Log_Msg('Unexpected error returned by validation ',1);
10391: /* Debug */
10392: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10393: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10394: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is U';
10395: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10396: END IF;
10397:
10398: RAISE FND_API.G_EXC_ERROR;

Line 10398: RAISE FND_API.G_EXC_ERROR;

10394: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is U';
10395: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10396: END IF;
10397:
10398: RAISE FND_API.G_EXC_ERROR;
10399:
10400: ELSIF p_person_rec.fin_status = 'N' THEN -- Not found
10401:
10402: -- These are I-20 blocks and should be found. If this happens - its a bug

Line 10408: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is N';

10404: Put_Log_Msg('Finance block is not found ',0);
10405: /* Debug */
10406: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10407: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10408: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is N';
10409: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10410: END IF;
10411:
10412:

Line 10417: RAISE FND_API.G_EXC_ERROR;

10413: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
10414: FND_MESSAGE.SET_TOKEN('BLOCK_ID',4);
10415: FND_MSG_PUB.Add;
10416:
10417: RAISE FND_API.G_EXC_ERROR;
10418:
10419: END IF;
10420:
10421:

Line 10431: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. l_status is U or N';

10427: IF l_status = 'U' OR l_status = 'N' THEN
10428: /* Debug */
10429: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10430: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10431: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. l_status is U or N';
10432: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10433: END IF;
10434:
10435: RAISE FND_API.G_EXC_ERROR;

Line 10435: RAISE FND_API.G_EXC_ERROR;

10431: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. l_status is U or N';
10432: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10433: END IF;
10434:
10435: RAISE FND_API.G_EXC_ERROR;
10436:
10437: END IF;
10438:
10439: IF l_prev_rec.acad_term_length

Line 10525: WHEN FND_API.G_EXC_ERROR THEN

10521: RETURN 'S';
10522:
10523: EXCEPTION
10524:
10525: WHEN FND_API.G_EXC_ERROR THEN
10526:
10527: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10528: /* Debug */
10529: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 10531: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Finance_Info. '||SQLERRM;

10527: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10528: /* Debug */
10529: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10530: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10531: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Finance_Info. '||SQLERRM;
10532: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10533: END IF;
10534: RETURN 'U';
10535:

Line 10631: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. dep_status is U.';

10627: Put_Log_Msg('Unexpected error returned by validation ',1);
10628: /* Debug */
10629: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10630: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10631: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. dep_status is U.';
10632: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10633: END IF;
10634:
10635: RAISE FND_API.G_EXC_ERROR;

Line 10635: RAISE FND_API.G_EXC_ERROR;

10631: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. dep_status is U.';
10632: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10633: END IF;
10634:
10635: RAISE FND_API.G_EXC_ERROR;
10636:
10637: ELSIF p_person_rec.dep_status = 'N' THEN -- Not found
10638:
10639: Put_Log_Msg('Dependent block is not found ',0);

Line 10714: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. l_status is U.';

10710: IF l_status = 'U' THEN
10711: /* Debug */
10712: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10713: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10714: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. l_status is U.';
10715: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10716: END IF;
10717: RAISE FND_API.G_EXC_ERROR;
10718:

Line 10717: RAISE FND_API.G_EXC_ERROR;

10713: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10714: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. l_status is U.';
10715: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10716: END IF;
10717: RAISE FND_API.G_EXC_ERROR;
10718:
10719: END IF;
10720:
10721: -- check if dependent sevis id is present

Line 10858: WHEN FND_API.G_EXC_ERROR THEN

10854: RETURN 'S';
10855:
10856: EXCEPTION
10857:
10858: WHEN FND_API.G_EXC_ERROR THEN
10859: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10860: /* Debug */
10861: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10862: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

Line 10863: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Dependent_Info. '||SQLERRM;

10859: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10860: /* Debug */
10861: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10862: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10863: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Dependent_Info. '||SQLERRM;
10864: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10865: END IF;
10866: RETURN 'U';
10867:

Line 10948: RAISE FND_API.G_EXC_ERROR;

10944: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
10945: l_debug_str := 'Unexpected error in Update_Employment_Info. empl_status is U.';
10946: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10947: END IF;
10948: RAISE FND_API.G_EXC_ERROR;
10949: ELSIF p_person_rec.empl_status = 'N' THEN -- Not found
10950: Put_Log_Msg('Employment block is not found ',0);
10951: /* Debug */
10952: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 11018: RAISE FND_API.G_EXC_ERROR;

11014: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
11015: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
11016: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11017: END IF;
11018: RAISE FND_API.G_EXC_ERROR;
11019: END IF;
11020:
11021: IF l_status = 'N' THEN
11022: -- New employment record status A;

Line 11091: WHEN FND_API.G_EXC_ERROR THEN

11087: RETURN 'S';
11088:
11089: EXCEPTION
11090:
11091: WHEN FND_API.G_EXC_ERROR THEN
11092:
11093: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
11094: /* Debug */
11095: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 11186: RAISE FND_API.G_EXC_ERROR;

11182: l_debug_str := 'Unexpected error in Update_Conviction_Info. conv_status is U.';
11183: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11184: END IF;
11185:
11186: RAISE FND_API.G_EXC_ERROR;
11187:
11188: ELSIF p_person_rec.conv_status = 'N' THEN -- Not found
11189:
11190: Put_Log_Msg('Convictions block is not found ',0);

Line 11226: WHEN FND_API.G_EXC_ERROR THEN

11222: RETURN 'S';
11223:
11224: EXCEPTION
11225:
11226: WHEN FND_API.G_EXC_ERROR THEN
11227:
11228: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
11229: /* Debug */
11230: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 11232: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Conviction_Info. '||SQLERRM;

11228: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
11229: /* Debug */
11230: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11231: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';
11232: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Conviction_Info. '||SQLERRM;
11233: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11234: END IF;
11235: RETURN 'U';
11236:

Line 11691: RAISE FND_API.G_EXC_ERROR;

11687: END IF;
11688:
11689: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_DISABLED'); -- SEVIS disabled
11690: FND_MSG_PUB.Add;
11691: RAISE FND_API.G_EXC_ERROR;
11692:
11693: END IF;
11694:
11695:

Line 11724: l_debug_str := 'Raise FND_API.G_EXC_ERROR: l_person_sevis_id is null';

11720:
11721: /* Debug */
11722: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11723: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
11724: l_debug_str := 'Raise FND_API.G_EXC_ERROR: l_person_sevis_id is null';
11725: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11726: END IF;
11727:
11728: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_SUBMITTER_ID_ERR'); -- SEVIS submitter id not found

Line 11731: RAISE FND_API.G_EXC_ERROR;

11727:
11728: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_SUBMITTER_ID_ERR'); -- SEVIS submitter id not found
11729: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER', l_submiter_number);
11730: FND_MSG_PUB.Add;
11731: RAISE FND_API.G_EXC_ERROR;
11732:
11733: END IF;
11734: l_sevis_user_person_id := l_submiter_id;
11735: ELSE

Line 11757: RAISE FND_API.G_EXC_ERROR;

11753: -- Active batch is found and mode not validate only - terminate current process
11754: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_BATCH_FOUND');
11755: FND_MESSAGE.SET_TOKEN('BATCH_ID', l_batch_id);
11756: FND_MSG_PUB.Add;
11757: RAISE FND_API.G_EXC_ERROR;
11758:
11759: END IF;
11760: -- Create batch record
11761: Put_Log_Msg('Inserting batch record',0);

Line 12019: RAISE FND_API.G_EXC_ERROR;

12015: l_debug_str := 'Returning U from Create_Batch. site_addr_status is U.';
12016: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12017: END IF;
12018:
12019: RAISE FND_API.G_EXC_ERROR;
12020:
12021: END IF;
12022:
12023: END IF;

Line 12057: RAISE FND_API.G_EXC_ERROR;

12053: OR l_student_rec.edu_status = 'U'
12054: OR l_student_rec.fin_status = 'U'
12055: OR l_student_rec.dep_status = 'U' THEN --Unexpected error - terminate execution
12056:
12057: RAISE FND_API.G_EXC_ERROR;
12058:
12059: ELSIF l_student_rec.issue_status = 'N'
12060: OR l_student_rec.bio_status = 'N'
12061: OR l_student_rec.edu_status = 'N'

Line 12076: RAISE FND_API.G_EXC_ERROR;

12072: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR in Create_Batch.';
12073: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12074: END IF;
12075:
12076: RAISE FND_API.G_EXC_ERROR;
12077:
12078: END IF;
12079:
12080: -- Check for required blocks

Line 12173: RAISE FND_API.G_EXC_ERROR;

12169: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12170: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Employment_Info is not S';
12171: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12172: END IF;
12173: RAISE FND_API.G_EXC_ERROR;
12174: END IF;
12175:
12176: -- END IF;
12177:

Line 12188: RAISE FND_API.G_EXC_ERROR;

12184: l_debug_str := 'ERROR in Create_Batch. l_status is not S';
12185: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12186: END IF;
12187:
12188: RAISE FND_API.G_EXC_ERROR;
12189: END IF;
12190: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw
12191:
12192: -- Call Update_Personal_Info

Line 12202: RAISE FND_API.G_EXC_ERROR;

12198: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12199: l_debug_str := 'ERROR in Create_Batch. changes_found <> Y and l_status is not S';
12200: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12201: END IF;
12202: RAISE FND_API.G_EXC_ERROR;
12203: END IF;
12204: -- END IF;
12205: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw
12206:

Line 12218: RAISE FND_API.G_EXC_ERROR;

12214: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Program_Info is not S';
12215: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12216: END IF;
12217:
12218: RAISE FND_API.G_EXC_ERROR;
12219: END IF;
12220: -- END IF;
12221:
12222: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 12234: RAISE FND_API.G_EXC_ERROR;

12230: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12231: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Finance_Info is not S';
12232: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12233: END IF;
12234: RAISE FND_API.G_EXC_ERROR;
12235: END IF;
12236: -- END IF;
12237:
12238: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 12250: RAISE FND_API.G_EXC_ERROR;

12246: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12247: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Dependent_Info is not S';
12248: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12249: END IF;
12250: RAISE FND_API.G_EXC_ERROR;
12251: END IF;
12252:
12253: -- END IF;
12254:

Line 12267: RAISE FND_API.G_EXC_ERROR;

12263: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12264: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Conviction_Info is not S';
12265: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12266: END IF;
12267: RAISE FND_API.G_EXC_ERROR;
12268: END IF;
12269:
12270: -- END IF;
12271:

Line 12307: RAISE FND_API.G_EXC_ERROR;

12303: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Personal_Info is not S';
12304: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12305: END IF;
12306:
12307: RAISE FND_API.G_EXC_ERROR;
12308: END IF;
12309: l_status := Update_ev_legal_Info ( p_person_rec => l_student_rec );
12310: IF l_status <> 'S' THEN
12311: /* Debug */

Line 12318: RAISE FND_API.G_EXC_ERROR;

12314: l_debug_str := 'ERROR in Create_Batch. Update_ev_legal_Info status is not S';
12315: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12316: END IF;
12317:
12318: RAISE FND_API.G_EXC_ERROR;
12319: END IF;
12320:
12321: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw
12322: -- Call Update_Finance_Info

Line 12333: RAISE FND_API.G_EXC_ERROR;

12329: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12330: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Finance_Info is not S';
12331: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12332: END IF;
12333: RAISE FND_API.G_EXC_ERROR;
12334: END IF;
12335: -- END IF;
12336:
12337: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 12350: RAISE FND_API.G_EXC_ERROR;

12346: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12347: l_debug_str := 'ERROR in Create_Batch. l_status from Update_EV_Program_Info is not S';
12348: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12349: END IF;
12350: RAISE FND_API.G_EXC_ERROR;
12351: END IF;
12352: -- END IF;
12353:
12354: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 12367: RAISE FND_API.G_EXC_ERROR;

12363: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12364: l_debug_str := 'ERROR in Create_Batch. l_status from Update_EV_Address_Info is not S';
12365: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12366: END IF;
12367: RAISE FND_API.G_EXC_ERROR;
12368: END IF;
12369:
12370: --END IF;
12371: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 12384: RAISE FND_API.G_EXC_ERROR;

12380: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12381: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Dependent_Info is not S';
12382: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12383: END IF;
12384: RAISE FND_API.G_EXC_ERROR;
12385: END IF;
12386:
12387: -- END IF;
12388: --PRBHARDW

Line 12509: WHEN FND_API.G_EXC_ERROR THEN

12505: retcode := 0;
12506:
12507: EXCEPTION
12508:
12509: WHEN FND_API.G_EXC_ERROR THEN
12510: /* Debug */
12511: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12512: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12513: l_debug_str := 'FND_API.G_EXC_ERROR exception in Create_Batch. '||SQLERRM;

Line 12513: l_debug_str := 'FND_API.G_EXC_ERROR exception in Create_Batch. '||SQLERRM;

12509: WHEN FND_API.G_EXC_ERROR THEN
12510: /* Debug */
12511: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12512: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12513: l_debug_str := 'FND_API.G_EXC_ERROR exception in Create_Batch. '||SQLERRM;
12514: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12515: END IF;
12516: ROLLBACK TO Create_Batch;
12517: retcode := 2;

Line 12726: WHEN FND_API.G_EXC_ERROR THEN

12722: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12723: END IF;
12724: EXCEPTION
12725:
12726: WHEN FND_API.G_EXC_ERROR THEN
12727:
12728: /* Debug */
12729: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12730: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';

Line 12731: l_debug_str := 'FND_API.G_EXC_ERROR Exception in NIMG_Batch_Process. '||SQLERRM;

12727:
12728: /* Debug */
12729: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12730: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';
12731: l_debug_str := 'FND_API.G_EXC_ERROR Exception in NIMG_Batch_Process. '||SQLERRM;
12732: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12733: END IF;
12734: ROLLBACK TO Purge_Batch;
12735:

Line 12923: l_msg_data := FND_MSg_PUB.GET(l_cur, FND_API.g_FALSE);

12919: l_msg_data := '';
12920:
12921: FOR l_cur IN 1..l_msg_count LOOP
12922:
12923: l_msg_data := FND_MSg_PUB.GET(l_cur, FND_API.g_FALSE);
12924: Put_Log_Msg(l_msg_data,1);
12925: END LOOP;
12926:
12927: ELSE

Line 13131: RAISE FND_API.G_EXC_ERROR;

13127: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_BATCH_NOT_FOUND'); -- Batch not found
13128: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_BatchID);
13129: FND_MSG_PUB.Add;
13130:
13131: RAISE FND_API.G_EXC_ERROR;
13132:
13133: END IF;
13134:
13135: CLOSE c_batch;

Line 13145: RAISE FND_API.G_EXC_ERROR;

13141: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_INVALID_STATUS'); -- Batch is not in process
13142: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_BatchID);
13143: FND_MSG_PUB.Add;
13144:
13145: RAISE FND_API.G_EXC_ERROR;
13146:
13147: END IF;
13148:
13149: -- Update batch and set success status

Line 13161: WHEN FND_API.G_EXC_ERROR THEN

13157: UPDATE igs_sv_batches SET batch_status = 'E', SEVIS_ERROR_CODE = NVL(p_FileErrorCode,NVL(p_FileValidation,'X')) WHERE batch_id = p_BatchID;
13158:
13159: END IF;
13160: EXCEPTION
13161: WHEN FND_API.G_EXC_ERROR THEN
13162: /* Debug */
13163: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13164: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_trans_header';
13165: l_debug_str := 'FND_API.G_EXC_ERROR in process_trans_header '||SQLERRM;

Line 13165: l_debug_str := 'FND_API.G_EXC_ERROR in process_trans_header '||SQLERRM;

13161: WHEN FND_API.G_EXC_ERROR THEN
13162: /* Debug */
13163: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13164: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_trans_header';
13165: l_debug_str := 'FND_API.G_EXC_ERROR in process_trans_header '||SQLERRM;
13166: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13167: END IF;
13168: ROLLBACK TO process_trans_header;
13169: WHEN OTHERS THEN

Line 13250: WHEN FND_API.G_EXC_ERROR THEN

13246: where person_id = p_PersonID;
13247:
13248: EXCEPTION
13249:
13250: WHEN FND_API.G_EXC_ERROR THEN
13251:
13252: ROLLBACK TO process_student_record;
13253:
13254: RAISE FND_API.G_EXC_ERROR;

Line 13254: RAISE FND_API.G_EXC_ERROR;

13250: WHEN FND_API.G_EXC_ERROR THEN
13251:
13252: ROLLBACK TO process_student_record;
13253:
13254: RAISE FND_API.G_EXC_ERROR;
13255:
13256: WHEN OTHERS THEN
13257:
13258: ROLLBACK TO process_student_record;

Line 13264: RAISE FND_API.G_EXC_ERROR;

13260: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13261: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13262: END IF;
13263:
13264: RAISE FND_API.G_EXC_ERROR;
13265:
13266:
13267: END process_student_record;
13268:

Line 13322: RAISE FND_API.G_EXC_ERROR;

13318: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_DEP_NOT_FOUND'); -- Dependent not found
13319: FND_MESSAGE.SET_TOKEN('PERSON_ID',p_PersonID);
13320: FND_MSG_PUB.Add;
13321:
13322: RAISE FND_API.G_EXC_ERROR;
13323:
13324: END IF;
13325:
13326: CLOSE c_dep;

Line 13342: WHEN FND_API.G_EXC_ERROR THEN

13338: UPDATE IGS_SV_DEPDNT_INFO SET DEPDNT_SEVIS_ID = p_DepSevisID WHERE PERSON_ID = p_PersonID and DEPDNT_ID = p_DepPersonID;
13339:
13340: EXCEPTION
13341:
13342: WHEN FND_API.G_EXC_ERROR THEN
13343: ROLLBACK TO process_dep_record;
13344: WHEN OTHERS THEN
13345: ROLLBACK TO process_dep_record;
13346: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 13926: RAISE FND_API.G_EXC_ERROR;

13922: -- Put_Log_Msg('Group ID cannot be left blank when new DSO is being assigned for a group', 0);
13923: FND_MESSAGE.SET_NAME('IGS','IGS_SV_INV_GRP_ID');
13924: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
13925: FND_MSG_PUB.Add;
13926: RAISE FND_API.G_EXC_ERROR;
13927: END IF;
13928:
13929: l_str := igs_pe_dynamic_persid_group.igs_get_dynamic_sql(p_group_id ,lv_status);
13930: IF lv_status <> 'S' THEN

Line 14083: RAISE FND_API.G_EXC_ERROR;

14079: --Put_Log_Msg('Enter the old DSO ID for which new relationships have to be created.', 0);
14080: FND_MESSAGE.SET_NAME('IGS','IGS_SV_INV_DSO_ID');
14081: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
14082: FND_MSG_PUB.Add;
14083: RAISE FND_API.G_EXC_ERROR;
14084: END IF;
14085: IF p_old_dso_id = p_new_dso_id THEN
14086: --Put_Log_Msg('Old DSO ID and new DSO ID cannot be same. Request Terminated', 0);
14087: FND_MESSAGE.SET_NAME('IGS','IGS_SV_INV_PARAMS');

Line 14090: RAISE FND_API.G_EXC_ERROR;

14086: --Put_Log_Msg('Old DSO ID and new DSO ID cannot be same. Request Terminated', 0);
14087: FND_MESSAGE.SET_NAME('IGS','IGS_SV_INV_PARAMS');
14088: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
14089: FND_MSG_PUB.Add;
14090: RAISE FND_API.G_EXC_ERROR;
14091: END IF;
14092: FOR r_old_dso_rel_rec IN c_old_dso_rel(l_old_dso_partyid) LOOP
14093: l_count := l_count + 1;
14094: l_rel_id := r_old_dso_rel_rec.relationship_id;

Line 14200: WHEN FND_API.G_EXC_ERROR THEN

14196: fnd_file.put_line(fnd_file.log,fnd_message.get());
14197: END IF;
14198:
14199: EXCEPTION
14200: WHEN FND_API.G_EXC_ERROR THEN
14201: ROLLBACK;
14202: retcode := 2;
14203: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
14204: fnd_message.set_token ('NAME', 'igs_sv_batch_process_pkg.Assign_DSO'|| '-' || SQLERRM);