APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on FND_MSG_PUB

Line 229: FND_MSG_PUB.Add;

225: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
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:

Line 1201: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

1197: l_debug_str := 'Exception in Validate_Issue_Info'||SQLERRM;
1198: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1199: END IF;
1200:
1201: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1202: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1203: END IF;
1204:
1205: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 1202: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1198: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1199: END IF;
1200:
1201: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1202: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1203: END IF;
1204:
1205: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
1206:

Line 1592: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

1588: l_debug_str := 'Exception in Validate_Bio_Info.'||SQLERRM;
1589: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1590: END IF;
1591:
1592: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1593: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1594: END IF;
1595: IF c_country_reason%ISOPEN THEN
1596: CLOSE c_country_reason;

Line 1593: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1589: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1590: END IF;
1591:
1592: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1593: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1594: END IF;
1595: IF c_country_reason%ISOPEN THEN
1596: CLOSE c_country_reason;
1597: END IF;

Line 1817: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

1813: l_debug_str := 'Exception in Validate_Other_Info.'||SQLERRM;
1814: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1815: END IF;
1816:
1817: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1818: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1819: END IF;
1820:
1821: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 1818: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1814: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1815: END IF;
1816:
1817: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1818: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1819: END IF;
1820:
1821: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
1822:

Line 1991: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

1987: l_debug_str := 'Exception in Validate_F_Addr_Info.'||SQLERRM;
1988: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1989: END IF;
1990:
1991: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1992: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
1993: END IF;
1994:
1995: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 1992: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

1988: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1989: END IF;
1990:
1991: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1992: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
1993: END IF;
1994:
1995: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
1996:

Line 2163: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

2159: l_debug_str := 'Exception in Validate_US_Addr_Info. '||SQLERRM;
2160: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2161: END IF;
2162:
2163: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2164: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
2165: END IF;
2166:
2167: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 2164: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

2160: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2161: END IF;
2162:
2163: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2164: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
2165: END IF;
2166:
2167: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
2168:

Line 2493: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

2489: l_debug_str := 'Exception in Validate_Edu_Info.'||SQLERRM;
2490: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2491: END IF;
2492:
2493: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2494: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2495: END IF;
2496:
2497: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 2494: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

2490: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2491: END IF;
2492:
2493: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2494: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2495: END IF;
2496:
2497: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
2498:

Line 2650: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

2646: l_debug_str := 'Exception in Get_Othr_Prgm_Info.'||SQLERRM;
2647: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2648: END IF;
2649:
2650: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2651: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2652: END IF;
2653: CLOSE c_ev_data;
2654: CLOSE c_nonimg_data;

Line 2651: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

2647: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2648: END IF;
2649:
2650: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2651: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2652: END IF;
2653: CLOSE c_ev_data;
2654: CLOSE c_nonimg_data;
2655: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 3215: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

3211: l_debug_str := 'Exception in Validate_Prgm_Info.'||SQLERRM;
3212: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3213: END IF;
3214:
3215: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3216: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3217: END IF;
3218:
3219: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 3216: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

3212: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3213: END IF;
3214:
3215: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3216: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3217: END IF;
3218:
3219: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
3220:

Line 3586: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

3582: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3583: END IF;
3584:
3585:
3586: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3587: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3588: END IF;
3589:
3590: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 3587: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

3583: END IF;
3584:
3585:
3586: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3587: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3588: END IF;
3589:
3590: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
3591:

Line 3761: FND_MSG_PUB.Add;

3757:
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:

Line 3836: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

3832: l_debug_str := 'Exception in Validate_Dependent_Info. '||SQLERRM;
3833: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3834: END IF;
3835:
3836: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3837: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3838: END IF;
3839:
3840: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 3837: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

3833: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3834: END IF;
3835:
3836: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3837: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3838: END IF;
3839:
3840: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
3841:

Line 3981: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

3977: l_debug_str := 'Exception in Validate_Convictions_Info '||SQLERRM;
3978: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3979: END IF;
3980:
3981: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3982: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3983: END IF;
3984:
3985: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 3982: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

3978: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3979: END IF;
3980:
3981: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3982: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3983: END IF;
3984:
3985: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
3986:

Line 4147: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

4143: l_debug_str := 'Exception in Validate_Legal_Info. '||SQLERRM;
4144: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4145: END IF;
4146:
4147: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4148: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4149: END IF;
4150:
4151: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 4148: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

4144: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4145: END IF;
4146:
4147: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4148: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4149: END IF;
4150:
4151: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
4152:

Line 4293: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

4289: l_debug_str := 'Exception in Validate_ev_Legal_Info. '||SQLERRM;
4290: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4291: END IF;
4292:
4293: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4294: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4295: END IF;
4296:
4297: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 4294: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

4290: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4291: END IF;
4292:
4293: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4294: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4295: END IF;
4296:
4297: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
4298:

Line 4409: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

4405: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';
4406: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;
4407: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4408: END IF;
4409: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4410: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
4411: END IF;
4412:
4413: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 4410: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

4406: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;
4407: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4408: END IF;
4409: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4410: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
4411: END IF;
4412:
4413: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
4414: RETURN 'U';

Line 4715: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

4711: l_debug_str := 'Exception in validate_empl_Info. '||SQLERRM;
4712: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4713: END IF;
4714:
4715: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4716: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4717: END IF;
4718:
4719: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 4716: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

4712: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4713: END IF;
4714:
4715: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4716: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4717: END IF;
4718:
4719: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
4720: RETURN 'U';

Line 4843: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

4839: RETURN 'U';
4840:
4841: WHEN OTHERS THEN
4842:
4843: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4844: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
4845: END IF;
4846: /* Debug */
4847: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 4844: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

4840:
4841: WHEN OTHERS THEN
4842:
4843: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4844: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
4845: END IF;
4846: /* Debug */
4847: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4848: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';

Line 4979: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

4975: RETURN 'U';
4976:
4977: WHEN OTHERS THEN
4978:
4979: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4980: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
4981: END IF;
4982: /* Debug */
4983: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 4980: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

4976:
4977: WHEN OTHERS THEN
4978:
4979: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4980: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
4981: END IF;
4982: /* Debug */
4983: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4984: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';

Line 5092: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

5088: RETURN 'U';
5089:
5090: WHEN OTHERS THEN
5091:
5092: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5093: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5094: END IF;
5095:
5096: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 5093: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

5089:
5090: WHEN OTHERS THEN
5091:
5092: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5093: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5094: END IF;
5095:
5096: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5097: /* Debug */

Line 5228: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

5224: RETURN 'U';
5225:
5226: WHEN OTHERS THEN
5227:
5228: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5229: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5230: END IF;
5231:
5232: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 5229: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

5225:
5226: WHEN OTHERS THEN
5227:
5228: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5229: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5230: END IF;
5231:
5232: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5233: /* Debug */

Line 5365: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

5361: RETURN 'U';
5362:
5363: WHEN OTHERS THEN
5364:
5365: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5366: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5367: END IF;
5368:
5369: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 5366: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

5362:
5363: WHEN OTHERS THEN
5364:
5365: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5366: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5367: END IF;
5368:
5369: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5370: /* Debug */

Line 5530: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

5526: RETURN 'U';
5527:
5528: WHEN OTHERS THEN
5529:
5530: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5531: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5532: END IF;
5533:
5534: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 5531: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

5527:
5528: WHEN OTHERS THEN
5529:
5530: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5531: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5532: END IF;
5533:
5534: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5535: /* Debug */

Line 5670: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

5666: END IF;
5667: RETURN 'U';
5668:
5669: WHEN OTHERS THEN
5670: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5671: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5672: END IF;
5673:
5674: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 5671: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

5667: RETURN 'U';
5668:
5669: WHEN OTHERS THEN
5670: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5671: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5672: END IF;
5673:
5674: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5675: /* Debug */

Line 5799: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

5795: RETURN 'U';
5796:
5797: WHEN OTHERS THEN
5798:
5799: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5800: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5801: END IF;
5802:
5803: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 5800: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

5796:
5797: WHEN OTHERS THEN
5798:
5799: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5800: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5801: END IF;
5802:
5803: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5804: /* Debug */

Line 5865: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

5861: EXCEPTION
5862:
5863: WHEN OTHERS THEN
5864:
5865: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5866: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5867: END IF;
5868: /* Debug */
5869: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 5866: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

5862:
5863: WHEN OTHERS THEN
5864:
5865: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5866: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5867: END IF;
5868: /* Debug */
5869: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5870: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Issue_Info';

Line 5973: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

5969:
5970: EXCEPTION
5971:
5972: WHEN OTHERS THEN
5973: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5974: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5975: END IF;
5976: /* Debug */
5977: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 5974: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

5970: EXCEPTION
5971:
5972: WHEN OTHERS THEN
5973: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5974: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5975: END IF;
5976: /* Debug */
5977: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5978: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Bio_Info';

Line 6057: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

6053:
6054: EXCEPTION
6055:
6056: WHEN OTHERS THEN
6057: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6058: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6059: END IF;
6060:
6061: /* Debug */

Line 6058: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

6054: EXCEPTION
6055:
6056: WHEN OTHERS THEN
6057: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6058: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6059: END IF;
6060:
6061: /* Debug */
6062: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6213: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

6209:
6210: EXCEPTION
6211:
6212: WHEN OTHERS THEN
6213: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6214: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6215: END IF;
6216:
6217: /* Debug */

Line 6214: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

6210: EXCEPTION
6211:
6212: WHEN OTHERS THEN
6213: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6214: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6215: END IF;
6216:
6217: /* Debug */
6218: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6526: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

6522:
6523: EXCEPTION
6524:
6525: WHEN OTHERS THEN
6526: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6527: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6528: END IF;
6529:
6530: /* Debug */

Line 6527: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

6523: EXCEPTION
6524:
6525: WHEN OTHERS THEN
6526: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6527: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6528: END IF;
6529:
6530: /* Debug */
6531: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6665: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

6661:
6662: EXCEPTION
6663:
6664: WHEN OTHERS THEN
6665: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6666: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6667: END IF;
6668:
6669: /* Debug */

Line 6666: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

6662: EXCEPTION
6663:
6664: WHEN OTHERS THEN
6665: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6666: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6667: END IF;
6668:
6669: /* Debug */
6670: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6814: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

6810:
6811: EXCEPTION
6812:
6813: WHEN OTHERS THEN
6814: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6815: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6816: END IF;
6817: /* Debug */
6818: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6815: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

6811: EXCEPTION
6812:
6813: WHEN OTHERS THEN
6814: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6815: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6816: END IF;
6817: /* Debug */
6818: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6819: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Dependent_Info';

Line 6894: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

6890:
6891: EXCEPTION
6892:
6893: WHEN OTHERS THEN
6894: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6895: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6896: END IF;
6897:
6898: /* Debug */

Line 6895: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

6891: EXCEPTION
6892:
6893: WHEN OTHERS THEN
6894: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6895: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6896: END IF;
6897:
6898: /* Debug */
6899: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 6992: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

6988:
6989: EXCEPTION
6990:
6991: WHEN OTHERS THEN
6992: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6993: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6994: END IF;
6995:
6996: /* Debug */

Line 6993: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

6989: EXCEPTION
6990:
6991: WHEN OTHERS THEN
6992: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6993: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6994: END IF;
6995:
6996: /* Debug */
6997: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 7130: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

7126:
7127: EXCEPTION
7128:
7129: WHEN OTHERS THEN
7130: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7131: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7132: END IF;
7133: /* Debug */
7134: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 7131: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

7127: EXCEPTION
7128:
7129: WHEN OTHERS THEN
7130: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7131: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7132: END IF;
7133: /* Debug */
7134: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7135: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Empl_Info';

Line 7446: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

7442: RETURN 'U';
7443:
7444: WHEN OTHERS THEN
7445:
7446: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7447: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7448: END IF;
7449:
7450: Put_Log_Msg(l_api_name||' OTHERS return U',0);

Line 7447: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

7443:
7444: WHEN OTHERS THEN
7445:
7446: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7447: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7448: END IF;
7449:
7450: Put_Log_Msg(l_api_name||' OTHERS return U',0);
7451: /* Debug */

Line 7631: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

7627: RETURN 'U';
7628:
7629: WHEN OTHERS THEN
7630:
7631: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7632: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7633: END IF;
7634:
7635: Put_Log_Msg(l_api_name||' OTHERS return U',0);

Line 7632: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

7628:
7629: WHEN OTHERS THEN
7630:
7631: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7632: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7633: END IF;
7634:
7635: Put_Log_Msg(l_api_name||' OTHERS return U',0);
7636: /* Debug */

Line 7998: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

7994: RETURN 'U';
7995:
7996: WHEN OTHERS THEN
7997:
7998: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7999: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8000: END IF;
8001:
8002: Put_Log_Msg(l_api_name||' OTHERS return U',0);

Line 7999: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

7995:
7996: WHEN OTHERS THEN
7997:
7998: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7999: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8000: END IF;
8001:
8002: Put_Log_Msg(l_api_name||' OTHERS return U',0);
8003: /* Debug */

Line 8144: FND_MSG_PUB.Add;

8140:
8141:
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;

Line 8439: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

8435: RETURN 'U';
8436:
8437: WHEN OTHERS THEN
8438:
8439: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8440: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8441: END IF;
8442:
8443: Put_Log_Msg(l_api_name||' OTHERS return U',0);

Line 8440: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

8436:
8437: WHEN OTHERS THEN
8438:
8439: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8440: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8441: END IF;
8442:
8443: Put_Log_Msg(l_api_name||' OTHERS return U',0);
8444: /* Debug */

Line 8546: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

8542: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';
8543: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;
8544: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8545: END IF;
8546: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8547: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8548: END IF;
8549:
8550: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 8547: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

8543: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;
8544: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8545: END IF;
8546: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8547: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8548: END IF;
8549:
8550: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
8551: RETURN 'U';

Line 8646: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

8642: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';
8643: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;
8644: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8645: END IF;
8646: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8647: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8648: END IF;
8649:
8650: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 8647: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

8643: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;
8644: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8645: END IF;
8646: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8647: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8648: END IF;
8649:
8650: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
8651: RETURN 'U';

Line 8738: FND_MSG_PUB.Add;

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

Line 8912: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

8908: RETURN 'U';
8909:
8910: WHEN OTHERS THEN
8911:
8912: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8913: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8914: END IF;
8915:
8916: Put_Log_Msg(l_api_name||' OTHERS return U',0);

Line 8913: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

8909:
8910: WHEN OTHERS THEN
8911:
8912: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8913: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8914: END IF;
8915:
8916: Put_Log_Msg(l_api_name||' OTHERS return U',0);
8917: /* Debug */

Line 9013: FND_MSG_PUB.Add;

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

Line 9193: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

9189: RETURN 'U';
9190:
9191: WHEN OTHERS THEN
9192:
9193: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9194: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9195: END IF;
9196:
9197: Put_Log_Msg(l_api_name||' OTHERS return U',0);

Line 9194: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

9190:
9191: WHEN OTHERS THEN
9192:
9193: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9194: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9195: END IF;
9196:
9197: Put_Log_Msg(l_api_name||' OTHERS return U',0);
9198: /* Debug */

Line 9290: FND_MSG_PUB.Add;

9286:
9287:
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;

Line 9413: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

9409: RETURN 'U';
9410:
9411: WHEN OTHERS THEN
9412:
9413: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9414: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9415: END IF;
9416:
9417: Put_Log_Msg(l_api_name||' OTHERS return U',0);

Line 9414: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

9410:
9411: WHEN OTHERS THEN
9412:
9413: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9414: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9415: END IF;
9416:
9417: Put_Log_Msg(l_api_name||' OTHERS return U',0);
9418: /* Debug */

Line 9756: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

9752: RETURN 'U';
9753:
9754: WHEN OTHERS THEN
9755:
9756: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9757: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9758: END IF;
9759: Put_Log_Msg(l_api_name||' OTHERS return U',0);
9760: /* Debug */

Line 9757: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

9753:
9754: WHEN OTHERS THEN
9755:
9756: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9757: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9758: END IF;
9759: Put_Log_Msg(l_api_name||' OTHERS return U',0);
9760: /* Debug */
9761: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 9955: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

9951: RETURN 'U';
9952:
9953: WHEN OTHERS THEN
9954:
9955: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9956: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9957: END IF;
9958:
9959: Put_Log_Msg(l_api_name||' OTHERS return U',0);

Line 9956: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

9952:
9953: WHEN OTHERS THEN
9954:
9955: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9956: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9957: END IF;
9958:
9959: Put_Log_Msg(l_api_name||' OTHERS return U',0);
9960: /* Debug */

Line 10090: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

10086: RETURN 'U';
10087:
10088: WHEN OTHERS THEN
10089:
10090: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10091: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10092: END IF;
10093:
10094: Put_Log_Msg(l_api_name||' OTHERS return U',0);

Line 10091: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

10087:
10088: WHEN OTHERS THEN
10089:
10090: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10091: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10092: END IF;
10093:
10094: Put_Log_Msg(l_api_name||' OTHERS return U',0);
10095: /* Debug */

Line 10253: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

10249:
10250: ROLLBACK TO EV_Batch_Process;
10251:
10252: retcode := 2;
10253: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10254: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10255: END IF;
10256:
10257: Generate_Message;

Line 10254: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

10250: ROLLBACK TO EV_Batch_Process;
10251:
10252: retcode := 2;
10253: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10254: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10255: END IF;
10256:
10257: Generate_Message;
10258:

Line 10528: FND_MSG_PUB.initialize;

10524: l_debug_str := 'Entering Create_Batch. p_batch_type is '||p_batch_type;
10525: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10526: END IF;
10527:
10528: FND_MSG_PUB.initialize;
10529:
10530: SAVEPOINT Create_Batch;
10531: IF fnd_profile.value('IGS_SV_ENABLED') <> 'Y' THEN
10532: /* Debug */

Line 10540: FND_MSG_PUB.Add;

10536: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
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:

Line 10579: FND_MSG_PUB.Add;

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

Line 10604: FND_MSG_PUB.Add;

10600:
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

Line 10913: FND_MSG_PUB.Add;

10909: -- These are I-20 blocks and should be found. If this happens - its a bug
10910:
10911: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
10912: FND_MESSAGE.SET_TOKEN('BLOCK_ID',5);
10913: FND_MSG_PUB.Add;
10914: /* Debug */
10915: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10916: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10917: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR in Create_Batch.';

Line 11371: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

11367: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11368: END IF;
11369: ROLLBACK TO Create_Batch;
11370: retcode := 2;
11371: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11372: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11373: END IF;
11374:
11375: dump_current_person(l_student_rec);

Line 11372: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

11368: END IF;
11369: ROLLBACK TO Create_Batch;
11370: retcode := 2;
11371: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11372: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11373: END IF;
11374:
11375: dump_current_person(l_student_rec);
11376: IF C_NI_CUR%ISOPEN THEN

Line 11464: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

11460: ROLLBACK TO NIMG_Batch_Process;
11461:
11462: retcode := 2;
11463: errbuf := SQLERRM;
11464: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11465: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11466: END IF;
11467:
11468: Generate_Message;

Line 11465: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

11461:
11462: retcode := 2;
11463: errbuf := SQLERRM;
11464: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11465: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11466: END IF;
11467:
11468: Generate_Message;
11469:

Line 11515: FND_MSG_PUB.initialize;

11511: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Purge_Batch';
11512: l_debug_str := 'Entering Purge_Batch. p_batch_type is '||p_batch_type;
11513: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11514: END IF;
11515: FND_MSG_PUB.initialize;
11516:
11517: SAVEPOINT Purge_Batch;
11518:
11519: -- Check for active batch

Line 11575: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

11571: ROLLBACK TO Purge_Batch;
11572:
11573: retcode := 2;
11574:
11575: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11576: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11577: END IF;
11578:
11579: Generate_Message;

Line 11576: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

11572:
11573: retcode := 2;
11574:
11575: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11576: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11577: END IF;
11578:
11579: Generate_Message;
11580:

Line 11635: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

11631: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11632: END IF;
11633: retcode := 2;
11634:
11635: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11636: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11637: END IF;
11638:
11639: Generate_Message;

Line 11636: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

11632: END IF;
11633: retcode := 2;
11634:
11635: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11636: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11637: END IF;
11638:
11639: Generate_Message;
11640:

Line 11700: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

11696: ROLLBACK TO NIMG_Purge_Batch;
11697:
11698: retcode := 2;
11699:
11700: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11701: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11702: END IF;
11703:
11704: Generate_Message;

Line 11701: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

11697:
11698: retcode := 2;
11699:
11700: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11701: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11702: END IF;
11703:
11704: Generate_Message;
11705:

Line 11737: FND_MSg_PUB.Count_And_Get ( p_count => l_msg_count,

11733: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Generate_Message';
11734: l_debug_str := 'Entering Generate_Message.';
11735: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11736: END IF;
11737: FND_MSg_PUB.Count_And_Get ( p_count => l_msg_count,
11738: p_data => l_msg_data );
11739:
11740: IF (l_msg_count > 0) THEN
11741:

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 11952: FND_MSG_PUB.Add;

11948:
11949: CLOSE c_batch;
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;

Line 11966: FND_MSG_PUB.Add;

11962:
11963: IF l_status <>'S' THEN
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;

Line 12001: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

11997: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11998: END IF;
11999: ROLLBACK TO process_trans_header;
12000:
12001: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12002: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12003: END IF;
12004: END process_trans_header;
12005:

Line 12002: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

11998: END IF;
11999: ROLLBACK TO process_trans_header;
12000:
12001: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12002: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12003: END IF;
12004: END process_trans_header;
12005:
12006: PROCEDURE process_trans_errors (

Line 12083: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

12079: WHEN OTHERS THEN
12080:
12081: ROLLBACK TO process_student_record;
12082:
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;

Line 12084: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

12080:
12081: ROLLBACK TO process_student_record;
12082:
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:

Line 12143: FND_MSG_PUB.Add;

12139: CLOSE c_dep;
12140:
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;

Line 12169: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

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
12170: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12171: END IF;
12172: END process_dep_record;
12173:

Line 12170: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

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
12170: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12171: END IF;
12172: END process_dep_record;
12173:
12174: /******************************************************************

Line 12252: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

12248: END IF;
12249: EXCEPTION
12250:
12251: WHEN OTHERS THEN
12252: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12253: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12254: END IF;
12255: /* Debug */
12256: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 12253: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

12249: EXCEPTION
12250:
12251: WHEN OTHERS THEN
12252: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12253: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12254: END IF;
12255: /* Debug */
12256: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12257: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Summary_Info';

Line 12468: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

12464:
12465: EXCEPTION
12466:
12467: WHEN OTHERS THEN
12468: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12469: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12470: END IF;
12471: /* Debug */
12472: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 12469: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);

12465: EXCEPTION
12466:
12467: WHEN OTHERS THEN
12468: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12469: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12470: END IF;
12471: /* Debug */
12472: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12473: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.compose_log_file';