APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on FND_MSG_PUB

Line 233: FND_MSG_PUB.Add;

229: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
230: END IF;
231:
232: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_PRTNR_STP_ERR'); -- No trading partner setup found
233: FND_MSG_PUB.Add;
234: RAISE FND_API.G_EXC_ERROR;
235:
236: END IF;
237:

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

1419: l_debug_str := 'Exception in Validate_Issue_Info'||SQLERRM;
1420: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1421: END IF;
1422:
1423: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1424: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1425: END IF;
1426:
1427: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

1420: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1421: END IF;
1422:
1423: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1424: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1425: END IF;
1426:
1427: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
1428:

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_Bio_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: IF c_country_reason%ISOPEN THEN
1821: CLOSE c_country_reason;

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: IF c_country_reason%ISOPEN THEN
1821: CLOSE c_country_reason;
1822: END IF;

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

2038: l_debug_str := 'Exception in Validate_Other_Info.'||SQLERRM;
2039: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2040: END IF;
2041:
2042: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2043: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2044: END IF;
2045:
2046: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

2039: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2040: END IF;
2041:
2042: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2043: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2044: END IF;
2045:
2046: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
2047:

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

2222: l_debug_str := 'Exception in Validate_F_Addr_Info.'||SQLERRM;
2223: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2224: END IF;
2225:
2226: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2227: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
2228: END IF;
2229:
2230: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

2223: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2224: END IF;
2225:
2226: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2227: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
2228: END IF;
2229:
2230: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
2231:

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

2401: l_debug_str := 'Exception in Validate_US_Addr_Info. '||SQLERRM;
2402: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2403: END IF;
2404:
2405: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2406: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
2407: END IF;
2408:
2409: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

2402: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2403: END IF;
2404:
2405: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2406: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
2407: END IF;
2408:
2409: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
2410:

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

2806: l_debug_str := 'Exception in Validate_Site_Info.'||SQLERRM;
2807: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2808: END IF;
2809:
2810: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2811: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2812: END IF;
2813:
2814: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

2807: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2808: END IF;
2809:
2810: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2811: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2812: END IF;
2813:
2814: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
2815:

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

3098: l_debug_str := 'Exception in Validate_Edu_Info.'||SQLERRM;
3099: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3100: END IF;
3101:
3102: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3103: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3104: END IF;
3105:
3106: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

3099: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3100: END IF;
3101:
3102: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3103: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3104: END IF;
3105:
3106: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
3107:

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

3255: l_debug_str := 'Exception in Get_Othr_Prgm_Info.'||SQLERRM;
3256: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3257: END IF;
3258:
3259: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3260: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3261: END IF;
3262: CLOSE c_ev_data;
3263: CLOSE c_nonimg_data;

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

3256: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3257: END IF;
3258:
3259: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3260: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3261: END IF;
3262: CLOSE c_ev_data;
3263: CLOSE c_nonimg_data;
3264: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

3446:
3447: EXCEPTION
3448:
3449: WHEN OTHERS THEN
3450: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3451: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
3452: END IF;
3453:
3454: /* Debug */

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

3447: EXCEPTION
3448:
3449: WHEN OTHERS THEN
3450: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3451: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
3452: END IF;
3453:
3454: /* Debug */
3455: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

4135: l_debug_str := 'Exception in Validate_Prgm_Info.'||SQLERRM;
4136: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4137: END IF;
4138:
4139: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4140: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4141: END IF;
4142:
4143: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

4136: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4137: END IF;
4138:
4139: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4140: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4141: END IF;
4142:
4143: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
4144:

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

4506: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4507: END IF;
4508:
4509:
4510: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4511: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4512: END IF;
4513:
4514: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

4507: END IF;
4508:
4509:
4510: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4511: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4512: END IF;
4513:
4514: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
4515:

Line 4713: FND_MSG_PUB.Add;

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

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

4784: l_debug_str := 'Exception in Validate_Dependent_Info. '||SQLERRM;
4785: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4786: END IF;
4787:
4788: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4789: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4790: END IF;
4791:
4792: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

4785: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4786: END IF;
4787:
4788: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4789: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4790: END IF;
4791:
4792: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
4793:

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

4929: l_debug_str := 'Exception in Validate_Convictions_Info '||SQLERRM;
4930: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4931: END IF;
4932:
4933: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4934: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4935: END IF;
4936:
4937: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

4930: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4931: END IF;
4932:
4933: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4934: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4935: END IF;
4936:
4937: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
4938:

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

5099: l_debug_str := 'Exception in Validate_Legal_Info. '||SQLERRM;
5100: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5101: END IF;
5102:
5103: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5104: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5105: END IF;
5106:
5107: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

5100: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5101: END IF;
5102:
5103: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5104: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5105: END IF;
5106:
5107: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
5108:

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

5245: l_debug_str := 'Exception in Validate_ev_Legal_Info. '||SQLERRM;
5246: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5247: END IF;
5248:
5249: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5250: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5251: END IF;
5252:
5253: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

5246: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5247: END IF;
5248:
5249: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5250: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5251: END IF;
5252:
5253: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
5254:

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

5361: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';
5362: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;
5363: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5364: END IF;
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 ',1);

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

5362: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;
5363: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5364: END IF;
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 ',1);
5370: RETURN 'U';

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

5667: l_debug_str := 'Exception in validate_empl_Info. '||SQLERRM;
5668: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5669: END IF;
5670:
5671: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5672: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5673: END IF;
5674:
5675: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

5668: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5669: END IF;
5670:
5671: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5672: FND_MSg_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
5673: END IF;
5674:
5675: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
5676: RETURN 'U';

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: /* Debug */
5803: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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: /* Debug */
5803: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5804: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';

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

5931: RETURN 'U';
5932:
5933: WHEN OTHERS THEN
5934:
5935: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5936: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5937: END IF;
5938: /* Debug */
5939: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

5932:
5933: WHEN OTHERS THEN
5934:
5935: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5936: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5937: END IF;
5938: /* Debug */
5939: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5940: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';

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

6044: RETURN 'U';
6045:
6046: WHEN OTHERS THEN
6047:
6048: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6049: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6050: END IF;
6051:
6052: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

6045:
6046: WHEN OTHERS THEN
6047:
6048: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6049: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6050: END IF;
6051:
6052: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6053: /* Debug */

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

6182: RETURN 'U';
6183:
6184: WHEN OTHERS THEN
6185:
6186: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6187: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6188: END IF;
6189:
6190: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

6183:
6184: WHEN OTHERS THEN
6185:
6186: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6187: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6188: END IF;
6189:
6190: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6191: /* Debug */

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

6319: RETURN 'U';
6320:
6321: WHEN OTHERS THEN
6322:
6323: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6324: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6325: END IF;
6326:
6327: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

6320:
6321: WHEN OTHERS THEN
6322:
6323: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6324: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6325: END IF;
6326:
6327: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6328: /* Debug */

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

6484: RETURN 'U';
6485:
6486: WHEN OTHERS THEN
6487:
6488: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6489: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6490: END IF;
6491:
6492: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

6485:
6486: WHEN OTHERS THEN
6487:
6488: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6489: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6490: END IF;
6491:
6492: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6493: /* Debug */

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

6624: END IF;
6625: RETURN 'U';
6626:
6627: WHEN OTHERS THEN
6628: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6629: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6630: END IF;
6631:
6632: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

6625: RETURN 'U';
6626:
6627: WHEN OTHERS THEN
6628: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6629: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6630: END IF;
6631:
6632: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6633: /* Debug */

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

6754: RETURN 'U';
6755:
6756: WHEN OTHERS THEN
6757:
6758: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6759: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6760: END IF;
6761:
6762: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

6755:
6756: WHEN OTHERS THEN
6757:
6758: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6759: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6760: END IF;
6761:
6762: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6763: /* Debug */

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

6820: EXCEPTION
6821:
6822: WHEN OTHERS THEN
6823:
6824: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6825: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6826: END IF;
6827: /* Debug */
6828: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

6821:
6822: WHEN OTHERS THEN
6823:
6824: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6825: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6826: END IF;
6827: /* Debug */
6828: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6829: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Issue_Info';

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

6928:
6929: EXCEPTION
6930:
6931: WHEN OTHERS THEN
6932: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6933: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6934: END IF;
6935: /* Debug */
6936: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

6929: EXCEPTION
6930:
6931: WHEN OTHERS THEN
6932: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
6933: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6934: END IF;
6935: /* Debug */
6936: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6937: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Bio_Info';

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

7012:
7013: EXCEPTION
7014:
7015: WHEN OTHERS THEN
7016: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7017: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7018: END IF;
7019:
7020: /* Debug */

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

7013: EXCEPTION
7014:
7015: WHEN OTHERS THEN
7016: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7017: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7018: END IF;
7019:
7020: /* Debug */
7021: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

7168:
7169: EXCEPTION
7170:
7171: WHEN OTHERS THEN
7172: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7173: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7174: END IF;
7175:
7176: /* Debug */

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

7169: EXCEPTION
7170:
7171: WHEN OTHERS THEN
7172: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7173: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7174: END IF;
7175:
7176: /* Debug */
7177: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

7465:
7466: EXCEPTION
7467:
7468: WHEN OTHERS THEN
7469: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7470: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7471: END IF;
7472:
7473: /* Debug */

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

7466: EXCEPTION
7467:
7468: WHEN OTHERS THEN
7469: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7470: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7471: END IF;
7472:
7473: /* Debug */
7474: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

7603:
7604: EXCEPTION
7605:
7606: WHEN OTHERS THEN
7607: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7608: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7609: END IF;
7610:
7611: /* Debug */

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

7604: EXCEPTION
7605:
7606: WHEN OTHERS THEN
7607: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7608: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7609: END IF;
7610:
7611: /* Debug */
7612: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

7754:
7755: EXCEPTION
7756:
7757: WHEN OTHERS THEN
7758: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7759: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7760: END IF;
7761: /* Debug */
7762: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

7755: EXCEPTION
7756:
7757: WHEN OTHERS THEN
7758: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7759: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7760: END IF;
7761: /* Debug */
7762: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7763: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';

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

7886:
7887: EXCEPTION
7888:
7889: WHEN OTHERS THEN
7890: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7891: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7892: END IF;
7893: /* Debug */
7894: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

7887: EXCEPTION
7888:
7889: WHEN OTHERS THEN
7890: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7891: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7892: END IF;
7893: /* Debug */
7894: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7895: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';

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

7966:
7967: EXCEPTION
7968:
7969: WHEN OTHERS THEN
7970: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7971: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7972: END IF;
7973:
7974: /* Debug */

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

7967: EXCEPTION
7968:
7969: WHEN OTHERS THEN
7970: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
7971: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7972: END IF;
7973:
7974: /* Debug */
7975: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

8064:
8065: EXCEPTION
8066:
8067: WHEN OTHERS THEN
8068: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8069: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8070: END IF;
8071:
8072: /* Debug */

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

8065: EXCEPTION
8066:
8067: WHEN OTHERS THEN
8068: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8069: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8070: END IF;
8071:
8072: /* Debug */
8073: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

8202:
8203: EXCEPTION
8204:
8205: WHEN OTHERS THEN
8206: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8207: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8208: END IF;
8209: /* Debug */
8210: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

8203: EXCEPTION
8204:
8205: WHEN OTHERS THEN
8206: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8207: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8208: END IF;
8209: /* Debug */
8210: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8211: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Empl_Info';

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

8518: RETURN 'U';
8519:
8520: WHEN OTHERS THEN
8521:
8522: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8523: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8524: END IF;
8525:
8526: Put_Log_Msg(l_api_name||' OTHERS return U',1);

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

8519:
8520: WHEN OTHERS THEN
8521:
8522: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8523: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8524: END IF;
8525:
8526: Put_Log_Msg(l_api_name||' OTHERS return U',1);
8527: /* Debug */

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

8703: RETURN 'U';
8704:
8705: WHEN OTHERS THEN
8706:
8707: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8708: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8709: END IF;
8710:
8711: Put_Log_Msg(l_api_name||' OTHERS return U',1);

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

8704:
8705: WHEN OTHERS THEN
8706:
8707: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
8708: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8709: END IF;
8710:
8711: Put_Log_Msg(l_api_name||' OTHERS return U',1);
8712: /* Debug */

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

9106: RETURN 'U';
9107:
9108: WHEN OTHERS THEN
9109:
9110: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9111: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9112: END IF;
9113:
9114: Put_Log_Msg(l_api_name||' OTHERS return U',1);

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

9107:
9108: WHEN OTHERS THEN
9109:
9110: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9111: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9112: END IF;
9113:
9114: Put_Log_Msg(l_api_name||' OTHERS return U',1);
9115: /* Debug */

Line 9256: FND_MSG_PUB.Add;

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

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

9547: RETURN 'U';
9548:
9549: WHEN OTHERS THEN
9550:
9551: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9552: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9553: END IF;
9554:
9555: Put_Log_Msg(l_api_name||' OTHERS return U',1);

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

9548:
9549: WHEN OTHERS THEN
9550:
9551: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9552: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9553: END IF;
9554:
9555: Put_Log_Msg(l_api_name||' OTHERS return U',1);
9556: /* Debug */

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

9654: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';
9655: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;
9656: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9657: END IF;
9658: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9659: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9660: END IF;
9661:
9662: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

9655: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;
9656: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9657: END IF;
9658: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9659: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9660: END IF;
9661:
9662: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
9663: RETURN 'U';

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

9754: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';
9755: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;
9756: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9757: END IF;
9758: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9759: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9760: END IF;
9761:
9762: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

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

9755: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;
9756: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9757: END IF;
9758: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
9759: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
9760: END IF;
9761:
9762: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
9763: RETURN 'U';

Line 9851: FND_MSG_PUB.Add;

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

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

10033: RETURN 'U';
10034:
10035: WHEN OTHERS THEN
10036:
10037: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10038: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10039: END IF;
10040:
10041: Put_Log_Msg(l_api_name||' OTHERS return U',1);

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

10034:
10035: WHEN OTHERS THEN
10036:
10037: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10038: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10039: END IF;
10040:
10041: Put_Log_Msg(l_api_name||' OTHERS return U',1);
10042: /* Debug */

Line 10138: FND_MSG_PUB.Add;

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

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

10314: RETURN 'U';
10315:
10316: WHEN OTHERS THEN
10317:
10318: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10319: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10320: END IF;
10321:
10322: Put_Log_Msg(l_api_name||' OTHERS return U',1);

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

10315:
10316: WHEN OTHERS THEN
10317:
10318: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10319: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10320: END IF;
10321:
10322: Put_Log_Msg(l_api_name||' OTHERS return U',1);
10323: /* Debug */

Line 10415: FND_MSG_PUB.Add;

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

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

10534: RETURN 'U';
10535:
10536: WHEN OTHERS THEN
10537:
10538: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10539: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10540: END IF;
10541:
10542: Put_Log_Msg(l_api_name||' OTHERS return U',1);

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

10535:
10536: WHEN OTHERS THEN
10537:
10538: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10539: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10540: END IF;
10541:
10542: Put_Log_Msg(l_api_name||' OTHERS return U',1);
10543: /* Debug */

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

10866: RETURN 'U';
10867:
10868: WHEN OTHERS THEN
10869:
10870: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10871: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10872: END IF;
10873: Put_Log_Msg(l_api_name||' OTHERS return U',1);
10874: /* Debug */

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

10867:
10868: WHEN OTHERS THEN
10869:
10870: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
10871: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
10872: END IF;
10873: Put_Log_Msg(l_api_name||' OTHERS return U',1);
10874: /* Debug */
10875: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

11100: RETURN 'U';
11101:
11102: WHEN OTHERS THEN
11103:
11104: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11105: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11106: END IF;
11107:
11108: Put_Log_Msg(l_api_name||' OTHERS return U',1);

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

11101:
11102: WHEN OTHERS THEN
11103:
11104: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11105: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11106: END IF;
11107:
11108: Put_Log_Msg(l_api_name||' OTHERS return U',1);
11109: /* Debug */

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

11235: RETURN 'U';
11236:
11237: WHEN OTHERS THEN
11238:
11239: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11240: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11241: END IF;
11242:
11243: Put_Log_Msg(l_api_name||' OTHERS return U',1);

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

11236:
11237: WHEN OTHERS THEN
11238:
11239: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11240: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11241: END IF;
11242:
11243: Put_Log_Msg(l_api_name||' OTHERS return U',1);
11244: /* Debug */

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

11387:
11388: ROLLBACK TO EV_Batch_Process;
11389:
11390: retcode := 2;
11391: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11392: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11393: END IF;
11394:
11395: Generate_Message;

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

11388: ROLLBACK TO EV_Batch_Process;
11389:
11390: retcode := 2;
11391: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
11392: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
11393: END IF;
11394:
11395: Generate_Message;
11396:

Line 11678: FND_MSG_PUB.initialize;

11674: l_debug_str := 'Entering Create_Batch. p_batch_type is '||p_batch_type;
11675: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11676: END IF;
11677:
11678: FND_MSG_PUB.initialize;
11679:
11680: SAVEPOINT Create_Batch;
11681: IF fnd_profile.value('IGS_SV_ENABLED') <> 'Y' THEN
11682: /* Debug */

Line 11690: FND_MSG_PUB.Add;

11686: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11687: END IF;
11688:
11689: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_DISABLED'); -- SEVIS disabled
11690: FND_MSG_PUB.Add;
11691: RAISE FND_API.G_EXC_ERROR;
11692:
11693: END IF;
11694:

Line 11730: FND_MSG_PUB.Add;

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

Line 11756: FND_MSG_PUB.Add;

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

Line 12068: FND_MSG_PUB.Add;

12064: -- These are I-20 blocks and should be found. If this happens - its a bug
12065:
12066: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_UNEXP_EXCPT_ERR'); -- I-20 is missing! Unexpected error
12067: FND_MESSAGE.SET_TOKEN('BLOCK_ID',5);
12068: FND_MSG_PUB.Add;
12069: /* Debug */
12070: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12071: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12072: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR in Create_Batch.';

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

12532: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12533: END IF;
12534: ROLLBACK TO Create_Batch;
12535: retcode := 2;
12536: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12537: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12538: END IF;
12539:
12540: dump_current_person(l_student_rec);

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

12533: END IF;
12534: ROLLBACK TO Create_Batch;
12535: retcode := 2;
12536: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12537: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12538: END IF;
12539:
12540: dump_current_person(l_student_rec);
12541: IF C_NI_CUR%ISOPEN THEN

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

12625: ROLLBACK TO NIMG_Batch_Process;
12626:
12627: retcode := 2;
12628: errbuf := SQLERRM;
12629: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12630: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12631: END IF;
12632:
12633: Generate_Message;

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

12626:
12627: retcode := 2;
12628: errbuf := SQLERRM;
12629: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12630: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12631: END IF;
12632:
12633: Generate_Message;
12634:

Line 12680: FND_MSG_PUB.initialize;

12676: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Purge_Batch';
12677: l_debug_str := 'Entering Purge_Batch. p_batch_type is '||p_batch_type;
12678: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12679: END IF;
12680: FND_MSG_PUB.initialize;
12681:
12682: SAVEPOINT Purge_Batch;
12683:
12684: -- Check for active batch

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

12748: ROLLBACK TO Purge_Batch;
12749:
12750: retcode := 2;
12751:
12752: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12753: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12754: END IF;
12755:
12756: Generate_Message;

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

12749:
12750: retcode := 2;
12751:
12752: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12753: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12754: END IF;
12755:
12756: Generate_Message;
12757:

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

12808: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12809: END IF;
12810: retcode := 2;
12811:
12812: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12813: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12814: END IF;
12815:
12816: Generate_Message;

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

12809: END IF;
12810: retcode := 2;
12811:
12812: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12813: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12814: END IF;
12815:
12816: Generate_Message;
12817:

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

12873: ROLLBACK TO NIMG_Purge_Batch;
12874:
12875: retcode := 2;
12876:
12877: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12878: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12879: END IF;
12880:
12881: Generate_Message;

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

12874:
12875: retcode := 2;
12876:
12877: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
12878: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12879: END IF;
12880:
12881: Generate_Message;
12882:

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

12910: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Generate_Message';
12911: l_debug_str := 'Entering Generate_Message.';
12912: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12913: END IF;
12914: FND_MSg_PUB.Count_And_Get ( p_count => l_msg_count,
12915: p_data => l_msg_data );
12916:
12917: IF (l_msg_count > 0) THEN
12918:

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

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

Line 13129: FND_MSG_PUB.Add;

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

Line 13143: FND_MSG_PUB.Add;

13139:
13140: IF l_status <>'S' THEN
13141: FND_MESSAGE.SET_NAME('IGS', 'IGS_SV_INVALID_STATUS'); -- Batch is not in process
13142: FND_MESSAGE.SET_TOKEN('BATCH_ID',p_BatchID);
13143: FND_MSG_PUB.Add;
13144:
13145: RAISE FND_API.G_EXC_ERROR;
13146:
13147: END IF;

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

13174: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13175: END IF;
13176: ROLLBACK TO process_trans_header;
13177:
13178: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13179: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13180: END IF;
13181: END process_trans_header;
13182:

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

13175: END IF;
13176: ROLLBACK TO process_trans_header;
13177:
13178: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13179: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13180: END IF;
13181: END process_trans_header;
13182:
13183: PROCEDURE process_trans_errors (

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

13256: WHEN OTHERS THEN
13257:
13258: ROLLBACK TO process_student_record;
13259:
13260: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13261: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13262: END IF;
13263:
13264: RAISE FND_API.G_EXC_ERROR;

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

13257:
13258: ROLLBACK TO process_student_record;
13259:
13260: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13261: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13262: END IF;
13263:
13264: RAISE FND_API.G_EXC_ERROR;
13265:

Line 13320: FND_MSG_PUB.Add;

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

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

13342: WHEN FND_API.G_EXC_ERROR THEN
13343: ROLLBACK TO process_dep_record;
13344: WHEN OTHERS THEN
13345: ROLLBACK TO process_dep_record;
13346: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13347: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13348: END IF;
13349: END process_dep_record;
13350:

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

13343: ROLLBACK TO process_dep_record;
13344: WHEN OTHERS THEN
13345: ROLLBACK TO process_dep_record;
13346: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13347: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13348: END IF;
13349: END process_dep_record;
13350:
13351: /******************************************************************

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

13425: END IF;
13426: EXCEPTION
13427:
13428: WHEN OTHERS THEN
13429: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13430: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13431: END IF;
13432: /* Debug */
13433: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

13426: EXCEPTION
13427:
13428: WHEN OTHERS THEN
13429: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13430: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13431: END IF;
13432: /* Debug */
13433: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13434: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Summary_Info';

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

13597:
13598: EXCEPTION
13599:
13600: WHEN OTHERS THEN
13601: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13602: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13603: END IF;
13604: /* Debug */
13605: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

13598: EXCEPTION
13599:
13600: WHEN OTHERS THEN
13601: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13602: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13603: END IF;
13604: /* Debug */
13605: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13606: l_label := 'igs.plsql.igs_sv_batch_process_pkg.xml_log_file';

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

13778:
13779: EXCEPTION
13780:
13781: WHEN OTHERS THEN
13782: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13783: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13784: END IF;
13785: /* Debug */
13786: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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

13779: EXCEPTION
13780:
13781: WHEN OTHERS THEN
13782: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
13783: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13784: END IF;
13785: /* Debug */
13786: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13787: l_label := 'igs.plsql.igs_sv_batch_process_pkg.compose_log_file';

Line 13925: FND_MSG_PUB.Add;

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

Line 14082: FND_MSG_PUB.Add;

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

Line 14089: FND_MSG_PUB.Add;

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