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

Line 230: RAISE FND_API.G_EXC_ERROR;

226: END IF;
227:
228: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_PRTNR_STP_ERR'); -- No trading partner setup found
229: FND_MSG_PUB.Add;
230: RAISE FND_API.G_EXC_ERROR;
231:
232: END IF;
233:
234: OPEN c_get_user_id;

Line 3762: RAISE FND_API.G_EXC_ERROR;

3758: -- probably a bug
3759: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
3760: FND_MESSAGE.SET_TOKEN('BLOCK_ID',1);
3761: FND_MSG_PUB.Add;
3762: RAISE FND_API.G_EXC_ERROR;
3763:
3764: END IF;
3765:
3766: p_data_rec(l_counter).person_id := p_person_rec.person_id;

Line 4391: WHEN FND_API.G_EXC_ERROR THEN

4387: RETURN 'S';
4388:
4389: EXCEPTION
4390:
4391: WHEN FND_API.G_EXC_ERROR THEN
4392: /* Debug */
4393: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4394: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';
4395: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;

Line 4829: WHEN FND_API.G_EXC_ERROR THEN

4825: RETURN 'S';
4826:
4827: EXCEPTION
4828:
4829: WHEN FND_API.G_EXC_ERROR THEN
4830:
4831: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
4832: /* Debug */
4833: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

4831: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
4832: /* Debug */
4833: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4834: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';
4835: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Issue_Info. '||SQLERRM;
4836: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4837: END IF;
4838:
4839: RETURN 'U';

Line 4965: WHEN FND_API.G_EXC_ERROR THEN

4961: RETURN 'S';
4962:
4963: EXCEPTION
4964:
4965: WHEN FND_API.G_EXC_ERROR THEN
4966: /* Debug */
4967: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4968: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';
4969: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Bio_Info. '||SQLERRM;

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

4965: WHEN FND_API.G_EXC_ERROR THEN
4966: /* Debug */
4967: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4968: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';
4969: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Bio_Info. '||SQLERRM;
4970: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4971: END IF;
4972:
4973: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);

Line 5079: WHEN FND_API.G_EXC_ERROR THEN

5075: RETURN 'S';
5076:
5077: EXCEPTION
5078:
5079: WHEN FND_API.G_EXC_ERROR THEN
5080:
5081: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5082: /* Debug */
5083: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

5081: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5082: /* Debug */
5083: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5084: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';
5085: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Other_Info-- Returning U. '||SQLERRM;
5086: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5087: END IF;
5088: RETURN 'U';
5089:

Line 5214: WHEN FND_API.G_EXC_ERROR THEN

5210: RETURN 'S';
5211:
5212: EXCEPTION
5213:
5214: WHEN FND_API.G_EXC_ERROR THEN
5215:
5216: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5217: /* Debug */
5218: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

5216: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5217: /* Debug */
5218: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5219: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';
5220: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Address_Info. Returning U... '||SQLERRM;
5221: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5222: END IF;
5223:
5224: RETURN 'U';

Line 5351: WHEN FND_API.G_EXC_ERROR THEN

5347: RETURN 'S';
5348:
5349: EXCEPTION
5350:
5351: WHEN FND_API.G_EXC_ERROR THEN
5352:
5353: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5354: /* Debug */
5355: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

5353: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5354: /* Debug */
5355: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5356: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';
5357: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Edu_Info. '||SQLERRM;
5358: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5359: END IF;
5360:
5361: RETURN 'U';

Line 5517: WHEN FND_API.G_EXC_ERROR THEN

5513: RETURN 'S';
5514:
5515: EXCEPTION
5516:
5517: WHEN FND_API.G_EXC_ERROR THEN
5518:
5519: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5520: /* Debug */
5521: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

5519: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5520: /* Debug */
5521: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5522: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';
5523: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Finance_Info. '||SQLERRM;
5524: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5525: END IF;
5526: RETURN 'U';
5527:

Line 5659: WHEN FND_API.G_EXC_ERROR THEN

5655: RETURN 'S';
5656:
5657: EXCEPTION
5658:
5659: WHEN FND_API.G_EXC_ERROR THEN
5660: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5661: /* Debug */
5662: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5663: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';

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

5660: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5661: /* Debug */
5662: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5663: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';
5664: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Dependent_Info. '||SQLERRM;
5665: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5666: END IF;
5667: RETURN 'U';
5668:

Line 5786: WHEN FND_API.G_EXC_ERROR THEN

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

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

5788: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5789: /* Debug */
5790: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5791: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Legal_Info';
5792: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Legal_Info. '||SQLERRM;
5793: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5794: END IF;
5795: RETURN 'U';
5796:

Line 7272: RAISE FND_API.G_EXC_ERROR;

7268: l_debug_str := 'Unexpected error in Update_Registration_Info.';
7269: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7270: END IF;
7271:
7272: RAISE FND_API.G_EXC_ERROR;
7273:
7274: ELSIF p_person_rec.legal_status = 'S' THEN
7275:
7276:

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

7282: IF l_status = 'U' THEN
7283: /* Debug */
7284: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7285: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7286: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Registration_Info.';
7287: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7288: END IF;
7289:
7290: RAISE FND_API.G_EXC_ERROR;

Line 7290: RAISE FND_API.G_EXC_ERROR;

7286: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Registration_Info.';
7287: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7288: END IF;
7289:
7290: RAISE FND_API.G_EXC_ERROR;
7291:
7292: END IF;
7293:
7294: IF l_status = 'N' OR

Line 7403: RAISE FND_API.G_EXC_ERROR;

7399: ELSIF p_person_rec.f_addr_status = 'U' THEN --Unexpected error - terminate execution
7400:
7401: Put_Log_Msg('Unexpected error returned by validation ',0);
7402:
7403: RAISE FND_API.G_EXC_ERROR;
7404:
7405: ELSIF p_person_rec.f_addr_status = 'N' THEN -- Not found
7406:
7407: Put_Log_Msg('F Address block is not found return S',0);

Line 7433: WHEN FND_API.G_EXC_ERROR THEN

7429: RETURN 'S';
7430:
7431: EXCEPTION
7432:
7433: WHEN FND_API.G_EXC_ERROR THEN
7434:
7435: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
7436: /* Debug */
7437: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

7435: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
7436: /* Debug */
7437: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7438: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7439: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Registration_Info. '||SQLERRM;
7440: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7441: END IF;
7442: RETURN 'U';
7443:

Line 7517: RAISE FND_API.G_EXC_ERROR;

7513: l_debug_str := 'Unexpected error in Update_ev_Legal_Info.';
7514: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7515: END IF;
7516:
7517: RAISE FND_API.G_EXC_ERROR;
7518:
7519: ELSIF p_person_rec.legal_status = 'S' THEN
7520:
7521:

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

7526: IF l_status = 'U' THEN
7527: /* Debug */
7528: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7529: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';
7530: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_ev_Legal_Info.';
7531: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7532: END IF;
7533:
7534: RAISE FND_API.G_EXC_ERROR;

Line 7534: RAISE FND_API.G_EXC_ERROR;

7530: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_ev_Legal_Info.';
7531: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7532: END IF;
7533:
7534: RAISE FND_API.G_EXC_ERROR;
7535:
7536: END IF;
7537:
7538: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 7618: WHEN FND_API.G_EXC_ERROR THEN

7614: RETURN 'S';
7615:
7616: EXCEPTION
7617:
7618: WHEN FND_API.G_EXC_ERROR THEN
7619:
7620: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
7621: /* Debug */
7622: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

7620: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
7621: /* Debug */
7622: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7623: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';
7624: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_ev_Legal_Info. '||SQLERRM;
7625: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7626: END IF;
7627: RETURN 'U';
7628:

Line 7740: RAISE FND_API.G_EXC_ERROR;

7736: l_debug_str := 'Unexpected error in Update_EV_Address_Info.';
7737: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7738: END IF;
7739:
7740: RAISE FND_API.G_EXC_ERROR;
7741:
7742: ELSIF p_person_rec.us_addr_status = 'N' THEN -- Not found
7743:
7744: Put_Log_Msg('US Address block is not found return S',0);

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

7808: --Error found l_status = 'U'
7809: /* Debug */
7810: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7811: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7812: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
7813: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7814: END IF;
7815: RAISE FND_API.G_EXC_ERROR;
7816:

Line 7815: RAISE FND_API.G_EXC_ERROR;

7811: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7812: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
7813: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7814: END IF;
7815: RAISE FND_API.G_EXC_ERROR;
7816:
7817: END IF;
7818:
7819: IF p_person_rec.us_addr_status = 'C' AND p_person_rec.person_status <> 'I' THEN

Line 7853: RAISE FND_API.G_EXC_ERROR;

7849: l_debug_str := 'ERROR in Update_EV_Address_Info. us_addr_status is U';
7850: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7851: END IF;
7852:
7853: RAISE FND_API.G_EXC_ERROR;
7854:
7855: ELSIF p_person_rec.us_addr_status = 'N' THEN -- Not found
7856:
7857: Put_Log_Msg('Site of activity Address block is not found return S',0);

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

7939: --Error found l_statsite = 'U'
7940: /* Debug */
7941: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7942: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7943: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
7944: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7945: END IF;
7946:
7947: RAISE FND_API.G_EXC_ERROR;

Line 7947: RAISE FND_API.G_EXC_ERROR;

7943: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
7944: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7945: END IF;
7946:
7947: RAISE FND_API.G_EXC_ERROR;
7948:
7949: END IF;
7950:
7951: /* IF p_person_rec.changes_found = 'Y' THEN

Line 7985: WHEN FND_API.G_EXC_ERROR THEN

7981: RETURN 'S';
7982:
7983: EXCEPTION
7984:
7985: WHEN FND_API.G_EXC_ERROR THEN
7986:
7987: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
7988: /* Debug */
7989: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

7987: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
7988: /* Debug */
7989: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7990: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7991: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Address_Info. '||SQLERRM;
7992: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7993: END IF;
7994: RETURN 'U';
7995:

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

8118: Put_Log_Msg('UPI - unexpected error returned by validation ',0);
8119: /* Debug */
8120: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8121: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8122: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Personal_Info.';
8123: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8124: END IF;
8125:
8126: RAISE FND_API.G_EXC_ERROR;

Line 8126: RAISE FND_API.G_EXC_ERROR;

8122: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Personal_Info.';
8123: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8124: END IF;
8125:
8126: RAISE FND_API.G_EXC_ERROR;
8127:
8128: ELSIF p_person_rec.bio_status = 'N' THEN -- Not found
8129:
8130: -- These are I-20 blocks and should be found. If this happens - its a bug

Line 8146: RAISE FND_API.G_EXC_ERROR;

8142: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
8143: FND_MESSAGE.SET_TOKEN('BLOCK_ID',2);
8144: FND_MSG_PUB.Add;
8145:
8146: RAISE FND_API.G_EXC_ERROR;
8147:
8148: END IF;
8149:
8150: -- Compare BIO

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

8155: IF l_status = 'U' THEN
8156: /* Debug */
8157: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8158: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8159: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. l_status is U';
8160: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8161: END IF;
8162: RAISE FND_API.G_EXC_ERROR;
8163:

Line 8162: RAISE FND_API.G_EXC_ERROR;

8158: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8159: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. l_status is U';
8160: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8161: END IF;
8162: RAISE FND_API.G_EXC_ERROR;
8163:
8164: END IF;
8165:
8166: IF l_prev_bio_rec.birth_date

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

8241: --Error found l_status = 'U'
8242: /* Debug */
8243: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8244: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8245: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info.';
8246: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8247: END IF;
8248:
8249: RAISE FND_API.G_EXC_ERROR;

Line 8249: RAISE FND_API.G_EXC_ERROR;

8245: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info.';
8246: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8247: END IF;
8248:
8249: RAISE FND_API.G_EXC_ERROR;
8250:
8251: END IF;
8252:
8253: END IF; --End of read and compare

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

8304: --Error found l_status = 'U'
8305: /* Debug */
8306: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8307: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8308: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. f_addr_status is S';
8309: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8310: END IF;
8311:
8312: RAISE FND_API.G_EXC_ERROR;

Line 8312: RAISE FND_API.G_EXC_ERROR;

8308: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. f_addr_status is S';
8309: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8310: END IF;
8311:
8312: RAISE FND_API.G_EXC_ERROR;
8313:
8314: END IF;
8315:
8316: END IF; --End of read and compare

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

8365: --Error found l_status = 'U'
8366: /* Debug */
8367: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8368: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8369: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. us_addr_status is S';
8370: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8371: END IF;
8372:
8373: RAISE FND_API.G_EXC_ERROR;

Line 8373: RAISE FND_API.G_EXC_ERROR;

8369: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. us_addr_status is S';
8370: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8371: END IF;
8372:
8373: RAISE FND_API.G_EXC_ERROR;
8374:
8375: END IF;
8376:
8377: END IF; --End of read and compare

Line 8426: WHEN FND_API.G_EXC_ERROR THEN

8422: RETURN 'S';
8423:
8424: EXCEPTION
8425:
8426: WHEN FND_API.G_EXC_ERROR THEN
8427:
8428: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
8429: /* Debug */
8430: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

8428: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
8429: /* Debug */
8430: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8431: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8432: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Personal_Info. '||SQLERRM;
8433: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8434: END IF;
8435: RETURN 'U';
8436:

Line 8528: WHEN FND_API.G_EXC_ERROR THEN

8524: RETURN 'S';
8525:
8526: EXCEPTION
8527:
8528: WHEN FND_API.G_EXC_ERROR THEN
8529: /* Debug */
8530: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8531: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';
8532: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;

Line 8628: WHEN FND_API.G_EXC_ERROR THEN

8624: RETURN 'S';
8625:
8626: EXCEPTION
8627:
8628: WHEN FND_API.G_EXC_ERROR THEN
8629: /* Debug */
8630: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8631: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';
8632: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;

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

8714: Put_Log_Msg('Unexpected error returned by validation ',0);
8715: /* Debug */
8716: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8717: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8718: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
8719: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8720: END IF;
8721:
8722: RAISE FND_API.G_EXC_ERROR;

Line 8722: RAISE FND_API.G_EXC_ERROR;

8718: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
8719: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8720: END IF;
8721:
8722: RAISE FND_API.G_EXC_ERROR;
8723:
8724: ELSIF p_person_rec.edu_status = 'N' THEN -- Not found
8725:
8726: -- These are I-20 blocks and should be found. If this happens - its a bug

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

8728: Put_Log_Msg('EDU block is not found ',0);
8729: /* Debug */
8730: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8731: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8732: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';
8733: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8734: END IF;
8735:
8736: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error

Line 8740: RAISE FND_API.G_EXC_ERROR;

8736: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
8737: FND_MESSAGE.SET_TOKEN('BLOCK_ID',3);
8738: FND_MSG_PUB.Add;
8739:
8740: RAISE FND_API.G_EXC_ERROR;
8741:
8742: END IF;
8743:
8744:

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

8750: IF l_status = 'U' OR l_status = 'N' THEN
8751: /* Debug */
8752: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8753: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8754: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
8755: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8756: END IF;
8757: RAISE FND_API.G_EXC_ERROR;
8758:

Line 8757: RAISE FND_API.G_EXC_ERROR;

8753: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8754: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
8755: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8756: END IF;
8757: RAISE FND_API.G_EXC_ERROR;
8758:
8759: END IF;
8760:
8761: IF l_prev_rec.position_code

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

8823: Put_Log_Msg('Unexpected error returned by validation ',0);
8824: /* Debug */
8825: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8826: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8827: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info.';
8828: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8829: END IF;
8830:
8831: RAISE FND_API.G_EXC_ERROR;

Line 8831: RAISE FND_API.G_EXC_ERROR;

8827: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info.';
8828: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8829: END IF;
8830:
8831: RAISE FND_API.G_EXC_ERROR;
8832:
8833: END IF;
8834:
8835: FOR l_current IN 1.. l_count LOOP

Line 8851: RAISE FND_API.G_EXC_ERROR;

8847: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
8848: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
8849: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8850: END IF;
8851: RAISE FND_API.G_EXC_ERROR;
8852: END IF;
8853:
8854: IF l_status = 'S' THEN
8855: IF

Line 8899: WHEN FND_API.G_EXC_ERROR THEN

8895: RETURN 'S';
8896:
8897: EXCEPTION
8898:
8899: WHEN FND_API.G_EXC_ERROR THEN
8900:
8901: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
8902: /* Debug */
8903: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

8901: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
8902: /* Debug */
8903: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8904: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8905: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Program_Info. '||SQLERRM;
8906: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8907: END IF;
8908: RETURN 'U';
8909:

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

8989: Put_Log_Msg('Unexpected error returned by validation ',0);
8990: /* Debug */
8991: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8992: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8993: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
8994: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8995: END IF;
8996:
8997: RAISE FND_API.G_EXC_ERROR;

Line 8997: RAISE FND_API.G_EXC_ERROR;

8993: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
8994: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8995: END IF;
8996:
8997: RAISE FND_API.G_EXC_ERROR;
8998:
8999: ELSIF p_person_rec.edu_status = 'N' THEN -- Not found
9000:
9001: -- These are I-20 blocks and should be found. If this happens - its a bug

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

9003: Put_Log_Msg('EDU block is not found ',0);
9004: /* Debug */
9005: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9006: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
9007: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';
9008: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9009: END IF;
9010:
9011: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error

Line 9015: RAISE FND_API.G_EXC_ERROR;

9011: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
9012: FND_MESSAGE.SET_TOKEN('BLOCK_ID',3);
9013: FND_MSG_PUB.Add;
9014:
9015: RAISE FND_API.G_EXC_ERROR;
9016:
9017: END IF;
9018:
9019:

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

9025: IF l_status = 'U' OR l_status = 'N' THEN
9026: /* Debug */
9027: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9028: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
9029: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
9030: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9031: END IF;
9032: RAISE FND_API.G_EXC_ERROR;
9033:

Line 9032: RAISE FND_API.G_EXC_ERROR;

9028: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
9029: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
9030: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9031: END IF;
9032: RAISE FND_API.G_EXC_ERROR;
9033:
9034: END IF;
9035: /*
9036: IF l_prev_rec.position_code

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

9096: Put_Log_Msg('Unexpected error returned by validation ',0);
9097: /* Debug */
9098: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9099: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';
9100: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Program_Info. p_person_rec.edu_status is U.';
9101: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9102: END IF;
9103:
9104: RAISE FND_API.G_EXC_ERROR;

Line 9104: RAISE FND_API.G_EXC_ERROR;

9100: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Program_Info. p_person_rec.edu_status is U.';
9101: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9102: END IF;
9103:
9104: RAISE FND_API.G_EXC_ERROR;
9105:
9106: END IF;
9107:
9108:

Line 9125: RAISE FND_API.G_EXC_ERROR;

9121: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9122: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
9123: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9124: END IF;
9125: RAISE FND_API.G_EXC_ERROR;
9126: END IF;
9127:
9128: IF l_status = 'S' THEN
9129: IF

Line 9179: WHEN FND_API.G_EXC_ERROR THEN

9175: RETURN 'S';
9176:
9177: EXCEPTION
9178:
9179: WHEN FND_API.G_EXC_ERROR THEN
9180:
9181: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9182: /* Debug */
9183: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

9181: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9182: /* Debug */
9183: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9184: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';
9185: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Program_Info. '||SQLERRM;
9186: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9187: END IF;
9188:
9189: RETURN 'U';

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

9265: Put_Log_Msg('Unexpected error returned by validation ',0);
9266: /* Debug */
9267: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9268: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9269: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is U';
9270: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9271: END IF;
9272:
9273: RAISE FND_API.G_EXC_ERROR;

Line 9273: RAISE FND_API.G_EXC_ERROR;

9269: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is U';
9270: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9271: END IF;
9272:
9273: RAISE FND_API.G_EXC_ERROR;
9274:
9275: ELSIF p_person_rec.fin_status = 'N' THEN -- Not found
9276:
9277: -- These are I-20 blocks and should be found. If this happens - its a bug

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

9279: Put_Log_Msg('Finance block is not found ',0);
9280: /* Debug */
9281: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9282: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9283: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is N';
9284: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9285: END IF;
9286:
9287:

Line 9292: RAISE FND_API.G_EXC_ERROR;

9288: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
9289: FND_MESSAGE.SET_TOKEN('BLOCK_ID',4);
9290: FND_MSG_PUB.Add;
9291:
9292: RAISE FND_API.G_EXC_ERROR;
9293:
9294: END IF;
9295:
9296:

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

9302: IF l_status = 'U' OR l_status = 'N' THEN
9303: /* Debug */
9304: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9305: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9306: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. l_status is U or N';
9307: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9308: END IF;
9309:
9310: RAISE FND_API.G_EXC_ERROR;

Line 9310: RAISE FND_API.G_EXC_ERROR;

9306: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. l_status is U or N';
9307: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9308: END IF;
9309:
9310: RAISE FND_API.G_EXC_ERROR;
9311:
9312: END IF;
9313:
9314: IF l_prev_rec.acad_term_length

Line 9400: WHEN FND_API.G_EXC_ERROR THEN

9396: RETURN 'S';
9397:
9398: EXCEPTION
9399:
9400: WHEN FND_API.G_EXC_ERROR THEN
9401:
9402: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9403: /* Debug */
9404: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

9402: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9403: /* Debug */
9404: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9405: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9406: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Finance_Info. '||SQLERRM;
9407: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9408: END IF;
9409: RETURN 'U';
9410:

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

9498: Put_Log_Msg('Unexpected error returned by validation ',0);
9499: /* Debug */
9500: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9501: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9502: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. dep_status is U.';
9503: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9504: END IF;
9505:
9506: RAISE FND_API.G_EXC_ERROR;

Line 9506: RAISE FND_API.G_EXC_ERROR;

9502: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. dep_status is U.';
9503: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9504: END IF;
9505:
9506: RAISE FND_API.G_EXC_ERROR;
9507:
9508: ELSIF p_person_rec.dep_status = 'N' THEN -- Not found
9509:
9510: Put_Log_Msg('Dependent block is not found ',0);

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

9581: IF l_status = 'U' THEN
9582: /* Debug */
9583: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9584: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9585: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. l_status is U.';
9586: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9587: END IF;
9588: RAISE FND_API.G_EXC_ERROR;
9589:

Line 9588: RAISE FND_API.G_EXC_ERROR;

9584: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9585: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. l_status is U.';
9586: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9587: END IF;
9588: RAISE FND_API.G_EXC_ERROR;
9589:
9590: END IF;
9591:
9592: -- check if dependent sevis id is present

Line 9744: WHEN FND_API.G_EXC_ERROR THEN

9740: RETURN 'S';
9741:
9742: EXCEPTION
9743:
9744: WHEN FND_API.G_EXC_ERROR THEN
9745: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9746: /* Debug */
9747: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9748: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

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

9745: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9746: /* Debug */
9747: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9748: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9749: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Dependent_Info. '||SQLERRM;
9750: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9751: END IF;
9752: RETURN 'U';
9753:

Line 9834: RAISE FND_API.G_EXC_ERROR;

9830: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9831: l_debug_str := 'Unexpected error in Update_Employment_Info. empl_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: RAISE FND_API.G_EXC_ERROR;
9835: ELSIF p_person_rec.empl_status = 'N' THEN -- Not found
9836: Put_Log_Msg('Employment block is not found ',0);
9837: /* Debug */
9838: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 9868: RAISE FND_API.G_EXC_ERROR;

9864: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9865: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
9866: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9867: END IF;
9868: RAISE FND_API.G_EXC_ERROR;
9869: END IF;
9870:
9871: IF l_status = 'N' THEN
9872: -- New employment record status A;

Line 9942: WHEN FND_API.G_EXC_ERROR THEN

9938: RETURN 'S';
9939:
9940: EXCEPTION
9941:
9942: WHEN FND_API.G_EXC_ERROR THEN
9943:
9944: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9945: /* Debug */
9946: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 10037: RAISE FND_API.G_EXC_ERROR;

10033: l_debug_str := 'Unexpected error in Update_Conviction_Info. conv_status is U.';
10034: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10035: END IF;
10036:
10037: RAISE FND_API.G_EXC_ERROR;
10038:
10039: ELSIF p_person_rec.conv_status = 'N' THEN -- Not found
10040:
10041: Put_Log_Msg('Convictions block is not found ',0);

Line 10077: WHEN FND_API.G_EXC_ERROR THEN

10073: RETURN 'S';
10074:
10075: EXCEPTION
10076:
10077: WHEN FND_API.G_EXC_ERROR THEN
10078:
10079: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
10080: /* Debug */
10081: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

10079: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
10080: /* Debug */
10081: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10082: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';
10083: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Conviction_Info. '||SQLERRM;
10084: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10085: END IF;
10086: RETURN 'U';
10087:

Line 10541: RAISE FND_API.G_EXC_ERROR;

10537: END IF;
10538:
10539: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_DISABLED'); -- SEVIS disabled
10540: FND_MSG_PUB.Add;
10541: RAISE FND_API.G_EXC_ERROR;
10542:
10543: END IF;
10544:
10545:

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

10569:
10570: /* Debug */
10571: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10572: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10573: l_debug_str := 'Raise FND_API.G_EXC_ERROR: l_person_sevis_id is null';
10574: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10575: END IF;
10576:
10577: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_SUBMITTER_ID_ERR'); -- SEVIS submitter id not found

Line 10580: RAISE FND_API.G_EXC_ERROR;

10576:
10577: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_SUBMITTER_ID_ERR'); -- SEVIS submitter id not found
10578: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER', l_submiter_number);
10579: FND_MSG_PUB.Add;
10580: RAISE FND_API.G_EXC_ERROR;
10581:
10582: END IF;
10583: l_sevis_user_person_id := l_submiter_id;
10584: ELSE

Line 10605: RAISE FND_API.G_EXC_ERROR;

10601: -- Active batch is found and mode not validate only - terminate current process
10602: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_BATCH_FOUND');
10603: FND_MESSAGE.SET_TOKEN('BATCH_ID', l_batch_id);
10604: FND_MSG_PUB.Add;
10605: RAISE FND_API.G_EXC_ERROR;
10606:
10607: END IF;
10608: -- Create batch record
10609: Put_Log_Msg('Inserting batch record',0);

Line 10864: RAISE FND_API.G_EXC_ERROR;

10860: l_debug_str := 'Returning U from Create_Batch. site_addr_status is U.';
10861: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10862: END IF;
10863:
10864: RAISE FND_API.G_EXC_ERROR;
10865:
10866: END IF;
10867:
10868: END IF;

Line 10902: RAISE FND_API.G_EXC_ERROR;

10898: OR l_student_rec.edu_status = 'U'
10899: OR l_student_rec.fin_status = 'U'
10900: OR l_student_rec.dep_status = 'U' THEN --Unexpected error - terminate execution
10901:
10902: RAISE FND_API.G_EXC_ERROR;
10903:
10904: ELSIF l_student_rec.issue_status = 'N'
10905: OR l_student_rec.bio_status = 'N'
10906: OR l_student_rec.edu_status = 'N'

Line 10921: RAISE FND_API.G_EXC_ERROR;

10917: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR in Create_Batch.';
10918: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10919: END IF;
10920:
10921: RAISE FND_API.G_EXC_ERROR;
10922:
10923: END IF;
10924:
10925: -- Check for required blocks

Line 11018: RAISE FND_API.G_EXC_ERROR;

11014: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11015: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Employment_Info is not S';
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: -- END IF;
11022:

Line 11033: RAISE FND_API.G_EXC_ERROR;

11029: l_debug_str := 'ERROR in Create_Batch. l_status is not S';
11030: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11031: END IF;
11032:
11033: RAISE FND_API.G_EXC_ERROR;
11034: END IF;
11035: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw
11036:
11037: -- Call Update_Personal_Info

Line 11047: RAISE FND_API.G_EXC_ERROR;

11043: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11044: l_debug_str := 'ERROR in Create_Batch. changes_found <> Y and l_status is not S';
11045: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11046: END IF;
11047: RAISE FND_API.G_EXC_ERROR;
11048: END IF;
11049: -- END IF;
11050: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw
11051:

Line 11063: RAISE FND_API.G_EXC_ERROR;

11059: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Program_Info is not S';
11060: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11061: END IF;
11062:
11063: RAISE FND_API.G_EXC_ERROR;
11064: END IF;
11065: -- END IF;
11066:
11067: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 11079: RAISE FND_API.G_EXC_ERROR;

11075: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11076: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Finance_Info is not S';
11077: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11078: END IF;
11079: RAISE FND_API.G_EXC_ERROR;
11080: END IF;
11081: -- END IF;
11082:
11083: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 11095: RAISE FND_API.G_EXC_ERROR;

11091: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11092: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Dependent_Info is not S';
11093: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11094: END IF;
11095: RAISE FND_API.G_EXC_ERROR;
11096: END IF;
11097:
11098: -- END IF;
11099:

Line 11112: RAISE FND_API.G_EXC_ERROR;

11108: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11109: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Conviction_Info is not S';
11110: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11111: END IF;
11112: RAISE FND_API.G_EXC_ERROR;
11113: END IF;
11114:
11115: -- END IF;
11116:

Line 11152: RAISE FND_API.G_EXC_ERROR;

11148: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Personal_Info is not S';
11149: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11150: END IF;
11151:
11152: RAISE FND_API.G_EXC_ERROR;
11153: END IF;
11154: l_status := Update_ev_legal_Info ( p_person_rec => l_student_rec );
11155: IF l_status <> 'S' THEN
11156: /* Debug */

Line 11163: RAISE FND_API.G_EXC_ERROR;

11159: l_debug_str := 'ERROR in Create_Batch. Update_ev_legal_Info status is not S';
11160: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11161: END IF;
11162:
11163: RAISE FND_API.G_EXC_ERROR;
11164: END IF;
11165:
11166: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw
11167: -- Call Update_Finance_Info

Line 11178: RAISE FND_API.G_EXC_ERROR;

11174: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11175: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Finance_Info is not S';
11176: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11177: END IF;
11178: RAISE FND_API.G_EXC_ERROR;
11179: END IF;
11180: -- END IF;
11181:
11182: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 11195: RAISE FND_API.G_EXC_ERROR;

11191: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11192: l_debug_str := 'ERROR in Create_Batch. l_status from Update_EV_Program_Info is not S';
11193: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11194: END IF;
11195: RAISE FND_API.G_EXC_ERROR;
11196: END IF;
11197: -- END IF;
11198:
11199: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 11212: RAISE FND_API.G_EXC_ERROR;

11208: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11209: l_debug_str := 'ERROR in Create_Batch. l_status from Update_EV_Address_Info is not S';
11210: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11211: END IF;
11212: RAISE FND_API.G_EXC_ERROR;
11213: END IF;
11214:
11215: --END IF;
11216: -- IF l_student_rec.changes_found <> 'Y' THEN --- commented by prbhardw

Line 11229: RAISE FND_API.G_EXC_ERROR;

11225: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11226: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Dependent_Info is not S';
11227: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11228: END IF;
11229: RAISE FND_API.G_EXC_ERROR;
11230: END IF;
11231:
11232: -- END IF;
11233: --PRBHARDW

Line 11344: WHEN FND_API.G_EXC_ERROR THEN

11340: retcode := 0;
11341:
11342: EXCEPTION
11343:
11344: WHEN FND_API.G_EXC_ERROR THEN
11345: /* Debug */
11346: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11347: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11348: l_debug_str := 'FND_API.G_EXC_ERROR exception in Create_Batch. '||SQLERRM;

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

11344: WHEN FND_API.G_EXC_ERROR THEN
11345: /* Debug */
11346: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11347: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11348: l_debug_str := 'FND_API.G_EXC_ERROR exception in Create_Batch. '||SQLERRM;
11349: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11350: END IF;
11351: ROLLBACK TO Create_Batch;
11352: retcode := 2;

Line 11549: WHEN FND_API.G_EXC_ERROR THEN

11545: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11546: END IF;
11547: EXCEPTION
11548:
11549: WHEN FND_API.G_EXC_ERROR THEN
11550:
11551: /* Debug */
11552: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11553: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';

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

11550:
11551: /* Debug */
11552: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11553: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';
11554: l_debug_str := 'FND_API.G_EXC_ERROR Exception in NIMG_Batch_Process. '||SQLERRM;
11555: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11556: END IF;
11557: ROLLBACK TO Purge_Batch;
11558:

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

11742: l_msg_data := '';
11743:
11744: FOR l_cur IN 1..l_msg_count LOOP
11745:
11746: l_msg_data := FND_MSg_PUB.GET(l_cur, FND_API.g_FALSE);
11747: Put_Log_Msg(l_msg_data,1);
11748: END LOOP;
11749:
11750: ELSE

Line 11954: RAISE FND_API.G_EXC_ERROR;

11950: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_BATCH_NOT_FOUND'); -- Batch not found
11951: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_BatchID);
11952: FND_MSG_PUB.Add;
11953:
11954: RAISE FND_API.G_EXC_ERROR;
11955:
11956: END IF;
11957:
11958: CLOSE c_batch;

Line 11968: RAISE FND_API.G_EXC_ERROR;

11964: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_INVALID_STATUS'); -- Batch is not in process
11965: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_BatchID);
11966: FND_MSG_PUB.Add;
11967:
11968: RAISE FND_API.G_EXC_ERROR;
11969:
11970: END IF;
11971:
11972: -- Update batch and set success status

Line 11984: WHEN FND_API.G_EXC_ERROR THEN

11980: UPDATE igs_sv_batches SET batch_status = 'E', SEVIS_ERROR_CODE = NVL(p_FileErrorCode,NVL(p_FileValidation,'X')) WHERE batch_id = p_BatchID;
11981:
11982: END IF;
11983: EXCEPTION
11984: WHEN FND_API.G_EXC_ERROR THEN
11985: /* Debug */
11986: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11987: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_trans_header';
11988: l_debug_str := 'FND_API.G_EXC_ERROR in process_trans_header '||SQLERRM;

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

11984: WHEN FND_API.G_EXC_ERROR THEN
11985: /* Debug */
11986: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11987: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_trans_header';
11988: l_debug_str := 'FND_API.G_EXC_ERROR in process_trans_header '||SQLERRM;
11989: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11990: END IF;
11991: ROLLBACK TO process_trans_header;
11992: WHEN OTHERS THEN

Line 12073: WHEN FND_API.G_EXC_ERROR THEN

12069: where person_id = p_PersonID;
12070:
12071: EXCEPTION
12072:
12073: WHEN FND_API.G_EXC_ERROR THEN
12074:
12075: ROLLBACK TO process_student_record;
12076:
12077: RAISE FND_API.G_EXC_ERROR;

Line 12077: RAISE FND_API.G_EXC_ERROR;

12073: WHEN FND_API.G_EXC_ERROR THEN
12074:
12075: ROLLBACK TO process_student_record;
12076:
12077: RAISE FND_API.G_EXC_ERROR;
12078:
12079: WHEN OTHERS THEN
12080:
12081: ROLLBACK TO process_student_record;

Line 12087: RAISE FND_API.G_EXC_ERROR;

12083: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12084: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12085: END IF;
12086:
12087: RAISE FND_API.G_EXC_ERROR;
12088:
12089:
12090: END process_student_record;
12091:

Line 12145: RAISE FND_API.G_EXC_ERROR;

12141: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_DEP_NOT_FOUND'); -- Dependent not found
12142: FND_MESSAGE.SET_TOKEN('PERSON_ID',p_PersonID);
12143: FND_MSG_PUB.Add;
12144:
12145: RAISE FND_API.G_EXC_ERROR;
12146:
12147: END IF;
12148:
12149: CLOSE c_dep;

Line 12165: WHEN FND_API.G_EXC_ERROR THEN

12161: UPDATE IGS_SV_DEPDNT_INFO SET DEPDNT_SEVIS_ID = p_DepSevisID WHERE PERSON_ID = p_PersonID and DEPDNT_ID = p_DepPersonID;
12162:
12163: EXCEPTION
12164:
12165: WHEN FND_API.G_EXC_ERROR THEN
12166: ROLLBACK TO process_dep_record;
12167: WHEN OTHERS THEN
12168: ROLLBACK TO process_dep_record;
12169: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN