eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_BUDGETARY_CTRL_PKG dependencies on FND_MSG_PUB

Line 124: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

120: /*WHEN FND_API.G_EXC_ERROR THEN
121: RETURN;*/
122:
123: WHEN OTHERS THEN
124: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
125: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
126: END IF;
127: NULL;
128: RETURN;

Line 125: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

121: RETURN;*/
122:
123: WHEN OTHERS THEN
124: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
125: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
126: END IF;
127: NULL;
128: RETURN;
129:

Line 237: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

233:
234: WHEN OTHERS THEN
235:
236: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
238: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
239: l_api_name);
240: END if;
241:

Line 238: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

234: WHEN OTHERS THEN
235:
236: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
238: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
239: l_api_name);
240: END if;
241:
242: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 242: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

238: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
239: l_api_name);
240: END if;
241:
242: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
243: p_data => X_msg_data );
244:
245: IF ( g_unexp_level >= g_debug_level ) THEN
246: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

343:
344: WHEN OTHERS THEN
345:
346: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
348: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
349: l_api_name);
350: END if;
351:

Line 348: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

344: WHEN OTHERS THEN
345:
346: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
348: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
349: l_api_name);
350: END if;
351:
352: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 352: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

348: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
349: l_api_name);
350: END if;
351:
352: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
353: p_data => X_msg_data );
354:
355: IF ( g_unexp_level >= g_debug_level ) THEN
356: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 473: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

469:
470: WHEN OTHERS THEN
471:
472: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
475: l_api_name);
476: END if;
477:

Line 474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

470: WHEN OTHERS THEN
471:
472: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
475: l_api_name);
476: END if;
477:
478: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 478: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
475: l_api_name);
476: END if;
477:
478: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
479: p_data => X_msg_data );
480:
481: IF ( g_unexp_level >= g_debug_level ) THEN
482: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 696: FND_MSG_PUB.initialize;

692: SAVEPOINT Execute_Rel_Budgetary_Ctrl;
693:
694: IF FND_API.to_Boolean(p_init_msg_list)
695: THEN
696: FND_MSG_PUB.initialize;
697: END IF;
698:
699: IF NOT FND_API.Compatible_API_Call(l_api_version,
700: p_api_version,

Line 874: fnd_msg_pub.add;

870: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
871: IF(g_error_level >= g_debug_level) THEN
872: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
873: END IF;
874: fnd_msg_pub.add;
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
876:
877: END IF;
878:

Line 1083: fnd_msg_pub.add;

1079: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
1080: IF(g_error_level >= g_debug_level) THEN
1081: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
1082: END IF;
1083: fnd_msg_pub.add;
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085:
1086: END IF;
1087:

Line 1153: fnd_msg_pub.add;

1149: fnd_message.set_token('CC_NUM_VAL', l_cc_headers_rec.cc_num);
1150: IF(g_error_level >= g_debug_level) THEN
1151: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
1152: END IF;
1153: fnd_msg_pub.add;
1154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1155:
1156: END IF;
1157:

Line 1227: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1223: IF (c_det_pf_line%ISOPEN) THEN
1224: CLOSE c_det_pf_line;
1225: END IF;
1226:
1227: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1228: p_data => x_msg_data );
1229: IF (g_excep_level >= g_debug_level ) THEN
1230: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
1231: END IF;

Line 1250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1246: END IF;
1247: IF (c_det_pf_line%ISOPEN) THEN
1248: CLOSE c_det_pf_line;
1249: END IF;
1250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1251: p_data => x_msg_data );
1252: IF (g_excep_level >= g_debug_level ) THEN
1253: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
1254: END IF;

Line 1274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1270: IF (c_det_pf_line%ISOPEN) THEN
1271: CLOSE c_det_pf_line;
1272: END IF;
1273:
1274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1275: THEN
1276: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1277: l_api_name);
1278: END IF;

Line 1276: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1272: END IF;
1273:
1274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1275: THEN
1276: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1277: l_api_name);
1278: END IF;
1279:
1280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1276: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1277: l_api_name);
1278: END IF;
1279:
1280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1281: p_data => x_msg_data );
1282: IF ( g_unexp_level >= g_debug_level ) THEN
1283: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1284: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 1409: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1405: WHEN OTHERS
1406: THEN
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408:
1409: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1410: THEN
1411: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1412: l_api_name);
1413: END IF;

Line 1411: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408:
1409: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1410: THEN
1411: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1412: l_api_name);
1413: END IF;
1414:
1415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1411: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1412: l_api_name);
1413: END IF;
1414:
1415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1416: p_data => x_msg_data );
1417: IF ( g_unexp_level >= g_debug_level ) THEN
1418: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1419: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 2034: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2030: WHEN FND_API.G_EXC_ERROR
2031: THEN
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033:
2034: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2035: p_data => x_msg_data );
2036:
2037: RETURN;
2038: IF (g_excep_level >= g_debug_level ) THEN

Line 2046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2042: WHEN OTHERS
2043: THEN
2044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2045:
2046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2047: THEN
2048: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2049: l_api_name);
2050: END IF;

Line 2048: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2045:
2046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2047: THEN
2048: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2049: l_api_name);
2050: END IF;
2051:
2052: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2052: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2048: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2049: l_api_name);
2050: END IF;
2051:
2052: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2053: p_data => x_msg_data );
2054:
2055: IF ( g_unexp_level >= g_debug_level ) THEN
2056: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 2355: FND_MSG_PUB.initialize;

2351: SAVEPOINT Execute_Budgetary_Ctrl1;
2352:
2353: IF FND_API.to_Boolean(p_init_msg_list)
2354: THEN
2355: FND_MSG_PUB.initialize;
2356: END IF;
2357:
2358: IF NOT FND_API.Compatible_API_Call(l_api_version,
2359: p_api_version,

Line 2388: fnd_msg_pub.add;

2384: fnd_message.set_token('MODE', p_mode,TRUE);
2385: IF(g_error_level >= g_debug_level) THEN
2386: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2387: END IF;
2388: fnd_msg_pub.add;
2389: RAISE E_INVALID_MODE;
2390: END IF;
2391:
2392: BEGIN

Line 2408: fnd_msg_pub.add;

2404: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2405: IF(g_error_level >= g_debug_level) THEN
2406: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2407: END IF;
2408: fnd_msg_pub.add;
2409: RAISE E_CC_NOT_FOUND;
2410:
2411: END;
2412:

Line 2441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2437:
2438: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2439: x_msg_data := l_msg_data;
2440: x_msg_count := l_msg_count;
2441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2442: THEN
2443: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2444: l_api_name);
2445: END IF;

Line 2443: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2439: x_msg_data := l_msg_data;
2440: x_msg_count := l_msg_count;
2441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2442: THEN
2443: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2444: l_api_name);
2445: END IF;
2446: RAISE E_UPDATE;
2447: END IF;

Line 2459: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2455: WHERE cc_header_id = p_cc_header_id AND
2456: actual_flag = 'E';
2457: EXCEPTION
2458: WHEN OTHERS THEN
2459: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2460: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2461: l_api_name);
2462: END IF;
2463: IF ( g_unexp_level >= g_debug_level ) THEN

Line 2460: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2456: actual_flag = 'E';
2457: EXCEPTION
2458: WHEN OTHERS THEN
2459: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2460: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2461: l_api_name);
2462: END IF;
2463: IF ( g_unexp_level >= g_debug_level ) THEN
2464: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 2504: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2500: x_bc_status := FND_API.G_TRUE;
2501: RETURN;
2502: END IF;
2503: ELSE
2504: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2505: THEN
2506: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2507: l_api_name);
2508: END IF;

Line 2506: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2502: END IF;
2503: ELSE
2504: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2505: THEN
2506: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2507: l_api_name);
2508: END IF;
2509: RAISE E_CHECK_BUDG_CTRL;
2510: END IF;

Line 2524: fnd_msg_pub.add;

2520: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
2521: IF(g_error_level >= g_debug_level) THEN
2522: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2523: END IF;
2524: fnd_msg_pub.add;
2525: RAISE E_CC_INVALID_SET_UP;
2526: END;
2527:
2528: /* Check whether CBC is turned on */

Line 2607: fnd_msg_pub.add;

2603: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2604: IF(g_error_level >= g_debug_level) THEN
2605: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2606: END IF;
2607: fnd_msg_pub.add;
2608: RAISE E_CC_NOT_FOUND;
2609: END;
2610:
2611: /* end fix for bug 1567120 */

Line 2638: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2634:
2635: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2636: x_msg_data := l_msg_data;
2637: x_msg_count := l_msg_count;
2638: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2639: THEN
2640: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2641: l_api_name);
2642: END IF;

Line 2640: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2636: x_msg_data := l_msg_data;
2637: x_msg_count := l_msg_count;
2638: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2639: THEN
2640: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2641: l_api_name);
2642: END IF;
2643: RAISE E_UPDATE;
2644: END IF;

Line 2696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2692: x_msg_count,
2693: x_msg_data,
2694: l_return_status);
2695: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2697: THEN
2698: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2699: l_api_name);
2700: END IF;

Line 2698: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2694: l_return_status);
2695: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2697: THEN
2698: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2699: l_api_name);
2700: END IF;
2701: RAISE E_PROCESS_ROW;
2702: END IF;

Line 2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2742: x_msg_data,
2743: l_return_status);
2744:
2745: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2747: THEN
2748: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2749: l_api_name);
2750: END IF;

Line 2748: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2744:
2745: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2747: THEN
2748: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2749: l_api_name);
2750: END IF;
2751: RAISE E_PROCESS_ROW;
2752: END IF;

Line 3053: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3049: IF (g_debug_mode = 'Y') THEN
3050: g_debug_msg := ' FAILED Updated Acct Line ..... 1 ';
3051: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3052: END IF;
3053: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3054: THEN
3055: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3056: l_api_name);
3057: END IF;

Line 3055: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3051: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3052: END IF;
3053: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3054: THEN
3055: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3056: l_api_name);
3057: END IF;
3058: RAISE E_UPDATE_CC_TABLES;
3059: END IF;

Line 3245: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3241: g_debug_msg := ' FAILURE updating DET PF line ...... 1 ';
3242: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3243: END IF;
3244:
3245: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3246: THEN
3247: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3248: l_api_name);
3249: END IF;

Line 3247: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3243: END IF;
3244:
3245: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3246: THEN
3247: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3248: l_api_name);
3249: END IF;
3250: RAISE E_UPDATE_CC_TABLES;
3251: END IF;

Line 3345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3341: IF (g_debug_mode = 'Y') THEN
3342: g_debug_msg := ' Failure UPDATING Header record..... 1';
3343: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3344: END IF;
3345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3346: THEN
3347: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3348: l_api_name);
3349: END IF;

Line 3347: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3343: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3344: END IF;
3345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3346: THEN
3347: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3348: l_api_name);
3349: END IF;
3350: RAISE E_UPDATE_CC_TABLES;
3351: END IF;

Line 3392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3388: g_debug_msg := ' Falure Inserting Actions Row..... 1 ';
3389: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3390: END IF;
3391:
3392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3393: THEN
3394: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3395: l_api_name);
3396: END IF;

Line 3394: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3390: END IF;
3391:
3392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3393: THEN
3394: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3395: l_api_name);
3396: END IF;
3397: RAISE E_UPDATE_CC_TABLES;
3398: END IF;

Line 3405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3401:
3402: EXCEPTION
3403: WHEN OTHERS
3404: THEN
3405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3406: THEN
3407: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3408: l_api_name);
3409: END IF;

Line 3407: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3403: WHEN OTHERS
3404: THEN
3405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3406: THEN
3407: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3408: l_api_name);
3409: END IF;
3410: IF ( g_unexp_level >= g_debug_level ) THEN
3411: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 3499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3495: g_debug_msg := ' FAILED update accout line ........ 2';
3496: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3497: END IF;
3498:
3499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3500: THEN
3501: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3502: l_api_name);
3503: END IF;

Line 3501: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3497: END IF;
3498:
3499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3500: THEN
3501: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3502: l_api_name);
3503: END IF;
3504: RAISE E_UPDATE_CC_TABLES;
3505: END IF;

Line 3573: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3569: g_debug_msg := ' FAILED Updating DET PF Line INFO ...... 2 ';
3570: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3571: END IF;
3572:
3573: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3574: THEN
3575: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3576: l_api_name);
3577: END IF;

Line 3575: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3571: END IF;
3572:
3573: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3574: THEN
3575: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3576: l_api_name);
3577: END IF;
3578: RAISE E_UPDATE_CC_TABLES;
3579: END IF;

Line 3640: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3636: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3637: END IF;
3638:
3639: l_cc_headers_rec.cc_encmbrnc_status := l_encumbrance_status_old;
3640: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3641: THEN
3642: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3643: l_api_name);
3644: END IF;

Line 3642: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3638:
3639: l_cc_headers_rec.cc_encmbrnc_status := l_encumbrance_status_old;
3640: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3641: THEN
3642: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3643: l_api_name);
3644: END IF;
3645: RAISE E_UPDATE_CC_TABLES;
3646: END IF;

Line 3686: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3682: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3683: END IF;
3684:
3685: l_cc_headers_rec.cc_encmbrnc_status := l_encumbrance_status_old;
3686: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3687: THEN
3688: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3689: l_api_name);
3690: END IF;

Line 3688: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3684:
3685: l_cc_headers_rec.cc_encmbrnc_status := l_encumbrance_status_old;
3686: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3687: THEN
3688: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3689: l_api_name);
3690: END IF;
3691: RAISE E_UPDATE_CC_TABLES;
3692: END IF;

Line 3704: fnd_msg_pub.add;

3700: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_INVALID');
3701: IF(g_state_level >= g_debug_level) THEN
3702: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3703: END IF;
3704: fnd_msg_pub.add;
3705: ELSE
3706: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_'||l_batch_result_code);
3707: IF(g_state_level >= g_debug_level) THEN
3708: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);

Line 3710: fnd_msg_pub.add;

3706: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_'||l_batch_result_code);
3707: IF(g_state_level >= g_debug_level) THEN
3708: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3709: END IF;
3710: fnd_msg_pub.add;
3711: END IF;
3712:
3713: END IF;
3714:

Line 3720: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3716: THEN
3717: COMMIT WORK;
3718: END IF;
3719:
3720: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3721: p_data => x_msg_data );
3722:
3723: RETURN;
3724:

Line 3751: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3747: IF (c_det_pf_line_rec_input%ISOPEN) THEN
3748: CLOSE c_det_pf_line_rec_input;
3749: END IF;
3750:
3751: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3752: p_data => x_msg_data );
3753: IF (g_excep_level >= g_debug_level ) THEN
3754: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR OR E_CC_NOT_FOUND OR E_INVALID_MODE OR E_UPDATE OR E_DELETE Exception Raised');
3755: END IF;

Line 3814: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3810: IF (c_det_pf_line_rec_input%ISOPEN) THEN
3811: CLOSE c_det_pf_line_rec_input;
3812: END IF;
3813:
3814: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3815: p_data => x_msg_data );
3816: IF (g_excep_level >= g_debug_level ) THEN
3817: FND_LOG.STRING (g_excep_level,l_full_path,'E_PROCESS_ROW Exception Raised');
3818: END IF;

Line 3879: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3875: IF (c_det_pf_line_rec_input%ISOPEN) THEN
3876: CLOSE c_det_pf_line_rec_input;
3877: END IF;
3878:
3879: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3880: p_data => x_msg_data );
3881: IF (g_excep_level >= g_debug_level ) THEN
3882: FND_LOG.STRING (g_excep_level,l_full_path,
3883: 'E_CC_INVALID_SET_UP OR E_NO_BUDGETARY_CONTROLOR E_SBC_DATA OR E_SBC_DATA1 OR E_CBC_DATA OR E_CBC_DATA1 OR E_CHECK_BUDG_CTRL');

Line 3948: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3944: IF (c_det_pf_line_rec_input%ISOPEN) THEN
3945: CLOSE c_det_pf_line_rec_input;
3946: END IF;
3947:
3948: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3949: p_data => x_msg_data );
3950: IF (g_excep_level >= g_debug_level ) THEN
3951: FND_LOG.STRING (g_excep_level,l_full_path,'E_BC_EXECUTION Exception Raised');
3952: END IF;

Line 4012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4008: IF (c_det_pf_line_rec_input%ISOPEN) THEN
4009: CLOSE c_det_pf_line_rec_input;
4010: END IF;
4011:
4012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4013: THEN
4014: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4015: l_api_name);
4016: END IF;

Line 4014: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4010: END IF;
4011:
4012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4013: THEN
4014: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4015: l_api_name);
4016: END IF;
4017:
4018: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4018: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

4014: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4015: l_api_name);
4016: END IF;
4017:
4018: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4019: p_data => x_msg_data );
4020: IF ( g_unexp_level >= g_debug_level ) THEN
4021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4022: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 4072: FND_MSG_PUB.initialize;

4068: l_enable_budg_control_flag := 'N';
4069:
4070: IF FND_API.to_Boolean(p_init_msg_list)
4071: THEN
4072: FND_MSG_PUB.initialize;
4073: END IF;
4074:
4075: IF NOT FND_API.Compatible_API_Call(l_api_version,
4076: p_api_version,

Line 4089: fnd_msg_pub.add;

4085: fnd_message.set_name('IGC', 'IGC_CC_NO_ORG_ID');
4086: IF(g_error_level >= g_debug_level) THEN
4087: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4088: END IF;
4089: fnd_msg_pub.add;
4090: RAISE E_NULL_PARAMETER;
4091: END IF;
4092:
4093: IF (p_sob_id IS NULL)

Line 4099: fnd_msg_pub.add;

4095: fnd_message.set_name('IGC', 'IGC_CC_NO_SOB_ID');
4096: IF(g_error_level >= g_debug_level) THEN
4097: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4098: END IF;
4099: fnd_msg_pub.add;
4100: RAISE E_NULL_PARAMETER;
4101: END IF;
4102:
4103: IF (p_cc_state IS NULL)

Line 4109: fnd_msg_pub.add;

4105: fnd_message.set_name('IGC', 'IGC_CC_NO_CC_STATE');
4106: IF(g_error_level >= g_debug_level) THEN
4107: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4108: END IF;
4109: fnd_msg_pub.add;
4110: RAISE E_NULL_PARAMETER;
4111: END IF;
4112:
4113: /* Check whether SBC is turned on */

Line 4130: fnd_msg_pub.add;

4126: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
4127: IF(g_error_level >= g_debug_level) THEN
4128: FND_LOG.MESSAGE(g_error_level, l_full_path || 'Msg4', FALSE);
4129: END IF;
4130: fnd_msg_pub.add;
4131: RAISE E_CC_INVALID_SET_UP;
4132: END;
4133:
4134:

Line 4191: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

4187: WHEN E_CC_NOT_FOUND OR E_CC_INVALID_SET_UP OR E_GL_DATA OR E_NULL_PARAMETER
4188: THEN
4189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4190: x_encumbrance_on := FND_API.G_FALSE;
4191: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4192: p_data => x_msg_data );
4193: IF (g_excep_level >= g_debug_level ) THEN
4194: FND_LOG.STRING (g_excep_level,l_full_path,'E_CC_NOT_FOUND OR E_CC_INVALID_SET_UP OR E_GL_DATA OR E_NULL_PARAMETER Exception Raised');
4195: END IF;

Line 4202: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

4198: THEN
4199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4200: x_encumbrance_on := FND_API.G_FALSE;
4201:
4202: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4203: p_data => x_msg_data );
4204: IF (g_excep_level >= g_debug_level ) THEN
4205: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
4206: END IF;

Line 4213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4209: THEN
4210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4211: x_encumbrance_on := FND_API.G_FALSE;
4212:
4213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4214: THEN
4215: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4216: l_api_name);
4217: END IF;

Line 4215: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4211: x_encumbrance_on := FND_API.G_FALSE;
4212:
4213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4214: THEN
4215: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4216: l_api_name);
4217: END IF;
4218:
4219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

4215: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4216: l_api_name);
4217: END IF;
4218:
4219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4220: p_data => x_msg_data );
4221: IF ( g_unexp_level >= g_debug_level ) THEN
4222: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4223: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 4428: FND_MSG_PUB.initialize;

4424: SAVEPOINT Set_Encumbrance_Status;
4425:
4426: IF FND_API.to_Boolean(p_init_msg_list)
4427: THEN
4428: FND_MSG_PUB.initialize;
4429: END IF;
4430:
4431: IF NOT FND_API.Compatible_API_Call(l_api_version,
4432: p_api_version,

Line 4452: fnd_msg_pub.add;

4448: fnd_message.set_token('CODE', p_encumbrance_status_code,TRUE);
4449: IF(g_error_level >= g_debug_level) THEN
4450: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4451: END IF;
4452: fnd_msg_pub.add;
4453: RAISE E_INVALID_STATUS_CODE;
4454:
4455: END IF;
4456:

Line 4473: fnd_msg_pub.add;

4469: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
4470: IF(g_excep_level >= g_debug_level) THEN
4471: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
4472: END IF;
4473: fnd_msg_pub.add;
4474: RAISE E_CC_NOT_FOUND;
4475:
4476: END;
4477:

Line 4646: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

4642: END IF;
4643: IF (c_cc_acct_line%ISOPEN) THEN
4644: CLOSE c_cc_acct_line;
4645: END IF;
4646: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4647: p_data => x_msg_data );
4648: IF (g_excep_level >= g_debug_level ) THEN
4649: FND_LOG.STRING (g_excep_level,l_full_path,'E_CC_NOT_FOUND OR E_INVALID_STATUS_CODE Exception Raised');
4650: END IF;

Line 4668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

4664: END IF;
4665: IF (c_cc_acct_line%ISOPEN) THEN
4666: CLOSE c_cc_acct_line;
4667: END IF;
4668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4669: p_data => x_msg_data );
4670: IF (g_excep_level >= g_debug_level ) THEN
4671: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
4672: END IF;

Line 4691: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4687: IF (c_cc_acct_line%ISOPEN) THEN
4688: CLOSE c_cc_acct_line;
4689: END IF;
4690:
4691: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4692: THEN
4693: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4694: l_api_name);
4695: END IF;

Line 4693: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4689: END IF;
4690:
4691: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4692: THEN
4693: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4694: l_api_name);
4695: END IF;
4696:
4697: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4697: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

4693: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4694: l_api_name);
4695: END IF;
4696:
4697: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4698: p_data => x_msg_data );
4699: IF ( g_unexp_level >= g_debug_level ) THEN
4700: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4701: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 4912: FND_MSG_PUB.initialize;

4908:
4909: l_full_path := g_path || 'Validate_CC';
4910:
4911: IF FND_API.to_Boolean(p_init_msg_list) THEN
4912: FND_MSG_PUB.initialize;
4913: END IF;
4914:
4915: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version, l_api_name, G_PKG_NAME) THEN
4916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4950: fnd_msg_pub.add;

4946: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
4947: IF(g_error_level >= g_debug_level) THEN
4948: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4949: END IF;
4950: fnd_msg_pub.add;
4951: RAISE E_CC_INVALID_SET_UP;
4952: END;
4953:
4954: -- Commitment Budgetary Control enabled or not

Line 5021: fnd_msg_pub.add;

5017: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5018: IF(g_state_level >= g_debug_level) THEN
5019: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
5020: END IF;
5021: fnd_msg_pub.add;
5022: END IF;
5023: END IF;
5024:
5025: -- Encumbrance turned on or not check begins here.

Line 5058: fnd_msg_pub.add;

5054: fnd_message.set_token('STARTDATE', FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5055: IF(g_state_level >= g_debug_level) THEN
5056: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
5057: END IF;
5058: fnd_msg_pub.add;
5059: END IF;
5060:
5061: ELSIF p_encumbrance_flag = FND_API.G_TRUE AND
5062: ( l_sbc_enable_flag = 'Y' ) AND

Line 5108: fnd_msg_pub.add;

5104: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(p_start_date),FALSE);
5105: IF(g_error_level >= g_debug_level) THEN
5106: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5107: END IF;
5108: fnd_msg_pub.add;
5109: END IF;
5110:
5111: END IF; -- Encumbrance turned on or not condition ends here.
5112:

Line 5136: fnd_msg_pub.add;

5132: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5133: IF(g_error_level >= g_debug_level) THEN
5134: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5135: END IF;
5136: fnd_msg_pub.add;
5137: END IF;
5138: END IF; -- Commitment Type is Cover
5139:
5140:

Line 5162: fnd_msg_pub.add;

5158: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5159: IF(g_error_level >= g_debug_level) THEN
5160: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5161: END IF;
5162: fnd_msg_pub.add;
5163: END IF;
5164: END IF; -- Commitment Type is Release.
5165:
5166: ELSIF ( p_start_date IS NULL) THEN

Line 5173: fnd_msg_pub.add;

5169: fnd_message.set_name('IGC', 'IGC_CC_NO_START_DATE');
5170: IF(g_error_level >= g_debug_level) THEN
5171: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5172: END IF;
5173: fnd_msg_pub.add;
5174:
5175: END IF; -- Start Date is Not Null. Start Date Validations ends here.
5176:
5177: -- End Date Validations begins here.

Line 5190: fnd_msg_pub.add;

5186: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE (P_END_DATE),FALSE);
5187: IF(g_error_level >= g_debug_level) THEN
5188: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5189: END IF;
5190: fnd_msg_pub.add;
5191: END IF;
5192:
5193: IF (p_cc_type_code = 'C') AND (p_cc_header_id IS NOT NULL)
5194: THEN

Line 5214: fnd_msg_pub.add;

5210: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_END_DATE');
5211: IF(g_error_level >= g_debug_level) THEN
5212: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5213: END IF;
5214: fnd_msg_pub.add;
5215: END IF;
5216: END IF; -- Commitment Type is Cover
5217:
5218: IF (p_cc_type_code = 'R') THEN

Line 5238: fnd_msg_pub.add;

5234: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_END_DATE');
5235: IF(g_error_level >= g_debug_level) THEN
5236: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5237: END IF;
5238: fnd_msg_pub.add;
5239: END IF;
5240: END IF; -- Commitment Type is Release
5241:
5242: END IF; -- End Date is NOT NULL. End Date Validations ends here.

Line 5258: fnd_msg_pub.add;

5254: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5255: IF(g_error_level >= g_debug_level) THEN
5256: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5257: END IF;
5258: fnd_msg_pub.add;
5259: END IF;
5260: IF ( (p_cc_det_pf_date > p_end_date) AND
5261: (p_end_date IS NOT NULL)
5262: ) THEN

Line 5270: fnd_msg_pub.add;

5266: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5267: IF(g_error_level >= g_debug_level) THEN
5268: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5269: END IF;
5270: fnd_msg_pub.add;
5271: END IF;
5272:
5273: -- Budgetary Control turned on.
5274:

Line 5311: fnd_msg_pub.add;

5307: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
5308: IF(g_error_level >= g_debug_level) THEN
5309: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5310: END IF;
5311: fnd_msg_pub.add;
5312: END IF;
5313: END IF; -- Budgetary Control turned on.
5314: END IF; -- Payment Forecast Date is NOT NULL. Payment Forecast Date Validations ends here.
5315:

Line 5340: fnd_msg_pub.add;

5336: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5337: IF(g_error_level >= g_debug_level) THEN
5338: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5339: END IF;
5340: fnd_msg_pub.add;
5341: END IF;
5342:
5343: -- Bug # 1678518.
5344:

Line 5359: fnd_msg_pub.add;

5355: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5356: IF(g_error_level >= g_debug_level) THEN
5357: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5358: END IF;
5359: fnd_msg_pub.add;
5360: END IF;
5361: END IF;
5362: END IF;
5363:

Line 5417: fnd_msg_pub.add;

5413: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');
5414: IF(g_error_level >= g_debug_level) THEN
5415: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5416: END IF;
5417: fnd_msg_pub.add;
5418: END IF;
5419:
5420: -- Bug # 1619201.
5421: -- If Previously been encumbered.

Line 5490: fnd_msg_pub.add;

5486: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5487: IF(g_error_level >= g_debug_level) THEN
5488: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5489: END IF;
5490: fnd_msg_pub.add;
5491: END IF; -- Fiscal Year Mismatch valdn ends here.
5492: END IF; -- If Previously been encumbered. Bug # 1619201.
5493:
5494: ELSIF (p_cc_state = 'CM' OR p_cc_state = 'CT')

Line 5531: fnd_msg_pub.add;

5527: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');
5528: IF(g_error_level >= g_debug_level) THEN
5529: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5530: END IF;
5531: fnd_msg_pub.add;
5532: END IF;
5533: END IF;
5534: END IF; -- Encumbrance turned on.
5535: END IF; -- Encumbrance Account Date Validations ends here.

Line 5561: fnd_msg_pub.add;

5557: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5558: IF(g_error_level >= g_debug_level) THEN
5559: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5560: END IF;
5561: fnd_msg_pub.add;
5562: END IF;
5563:
5564: -- Bug # 1678518.
5565:

Line 5580: fnd_msg_pub.add;

5576: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5577: IF(g_error_level >= g_debug_level) THEN
5578: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5579: END IF;
5580: fnd_msg_pub.add;
5581: END IF;
5582: END IF;
5583: END IF;
5584:

Line 5637: fnd_msg_pub.add;

5633: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');
5634: IF(g_error_level >= g_debug_level) THEN
5635: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5636: END IF;
5637: fnd_msg_pub.add;
5638: END IF;
5639:
5640: -- Bug # 1619201.
5641: -- If Previously been encumbered.

Line 5710: fnd_msg_pub.add;

5706: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5707: IF(g_error_level >= g_debug_level) THEN
5708: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5709: END IF;
5710: fnd_msg_pub.add;
5711: END IF; -- Fiscal Year Mismatch valdn ends here.
5712: END IF; -- If Previously been encumbered. Bug # 1619201.
5713:
5714: ELSIF (p_cc_state = 'CM' OR p_cc_state = 'CT')

Line 5751: fnd_msg_pub.add;

5747: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');
5748: IF(g_error_level >= g_debug_level) THEN
5749: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5750: END IF;
5751: fnd_msg_pub.add;
5752: END IF;
5753: END IF;
5754: END IF; -- Encumbrance turned on.
5755: END IF; -- Approval Accounting Date Validations ends here.

Line 5776: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);

5772: IF(g_error_level >= g_debug_level) THEN
5773: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5774: END IF;
5775: l_error_message := fnd_message.get;
5776: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
5777: RAISE E_CC_NOT_FOUND;
5778:
5779: END;
5780:

Line 5832: fnd_msg_pub.add;

5828: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5829: IF(g_error_level >= g_debug_level) THEN
5830: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5831: END IF;
5832: fnd_msg_pub.add;
5833: ELSIF (NVL(l_cc_det_pf_cnt,0) > 0) THEN
5834:
5835: OPEN c_det_pf_lines(l_cc_acct_lines_rec.cc_acct_line_id);
5836: LOOP

Line 5854: fnd_msg_pub.add;

5850: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5851: IF(g_error_level >= g_debug_level) THEN
5852: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5853: END IF;
5854: fnd_msg_pub.add;
5855: END IF;
5856:
5857:
5858: END LOOP; -- Payment Forecast Loop end here.

Line 5876: fnd_msg_pub.add;

5872: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
5873: IF(g_error_level >= g_debug_level) THEN
5874: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5875: END IF;
5876: fnd_msg_pub.add;
5877: END IF;
5878: END IF;
5879:
5880:

Line 5900: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);

5896: IF(g_error_level >= g_debug_level) THEN
5897: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5898: END IF;
5899: l_error_message := fnd_message.get;
5900: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
5901: RAISE E_CC_NOT_FOUND;
5902:
5903: END;
5904:

Line 5949: fnd_msg_pub.add;

5945: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5946: IF(g_error_level >= g_debug_level) THEN
5947: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5948: END IF;
5949: fnd_msg_pub.add;
5950: ELSIF (NVL(l_cc_det_pf_cnt,0) > 0) THEN
5951:
5952: OPEN c_det_pf_lines(l_cc_acct_lines_rec.cc_acct_line_id);
5953: LOOP

Line 5970: fnd_msg_pub.add;

5966: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5967: IF (g_error_level >= g_debug_level) THEN
5968: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5969: END IF;
5970: fnd_msg_pub.add;
5971: END IF;
5972:
5973: -- PF Date vs End Date Validation.
5974:

Line 5985: fnd_msg_pub.add;

5981: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5982: IF(g_error_level >= g_debug_level) THEN
5983: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5984: END IF;
5985: fnd_msg_pub.add;
5986: END IF;
5987:
5988: -- bug 5667529
5989: -- changes done by kasbalas

Line 6036: fnd_msg_pub.add;

6032: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
6033: IF(g_error_level >= g_debug_level) THEN
6034: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6035: END IF;
6036: fnd_msg_pub.add;
6037: END IF;
6038: END IF; -- ending the If Condition added for bug 9366764
6039: -- Encumbrance turned ON.
6040: -- Bug 1623034. Commitment Type should not be a RELEASE.

Line 6099: fnd_msg_pub.add;

6095: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6096: IF(g_error_level >= g_debug_level) THEN
6097: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6098: END IF;
6099: fnd_msg_pub.add;
6100: END IF;
6101: END IF;
6102: END IF ; -- PF Functional and Encumbered Amt are same.
6103:

Line 6174: fnd_msg_pub.add;

6170: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6171: IF(g_error_level >= g_debug_level) THEN
6172: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6173: END IF;
6174: fnd_msg_pub.add;
6175: END IF; -- Fiscal Year Mismatch valdn ends here.
6176: END IF; -- Encumbrance Amt is greater than zero ends here.
6177: END IF; -- Encumbrance turned ON validation ends here.
6178:

Line 6205: fnd_msg_pub.add;

6201: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6202: IF(g_error_level >= g_debug_level) THEN
6203: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6204: END IF;
6205: fnd_msg_pub.add;
6206: END IF;
6207:
6208: END LOOP;
6209:

Line 6220: fnd_msg_pub.add;

6216: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6217: IF(g_error_level >= g_debug_level) THEN
6218: FND_LOG.MESSAGE(g_error_level, g_debug_level, FALSE);
6219: END IF;
6220: fnd_msg_pub.add;
6221: END IF;
6222: END IF;
6223:
6224: ELSIF p_mode = 'A' OR p_mode = 'B' THEN

Line 6247: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);

6243: IF(g_error_level >= g_debug_level) THEN
6244: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6245: END IF;
6246: l_error_message := fnd_message.get;
6247: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
6248: RAISE E_CC_NOT_FOUND;
6249:
6250: END;
6251:

Line 6301: fnd_msg_pub.add;

6297: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6298: IF(g_error_level >= g_debug_level) THEN
6299: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6300: END IF;
6301: fnd_msg_pub.add;
6302: ELSIF (NVL(l_cc_det_pf_cnt,0) > 0) THEN
6303:
6304: OPEN c_det_pf_lines(l_cc_acct_lines_rec.cc_acct_line_id);
6305: LOOP

Line 6322: fnd_msg_pub.add;

6318: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6319: IF(g_error_level >= g_debug_level) THEN
6320: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6321: END IF;
6322: fnd_msg_pub.add;
6323: END IF;
6324:
6325: -- PF Date vs End Date Validation.
6326:

Line 6337: fnd_msg_pub.add;

6333: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6334: IF(g_error_level >= g_debug_level) THEN
6335: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6336: END IF;
6337: fnd_msg_pub.add;
6338: END IF;
6339:
6340: -- bug 5667529
6341: -- changes done by kasbalas

Line 6388: fnd_msg_pub.add;

6384: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
6385: IF(g_error_level >= g_debug_level) THEN
6386: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6387: END IF;
6388: fnd_msg_pub.add;
6389: END IF;
6390: END IF; -- End of the If condition added for bug 9366764
6391: -- Encumbrance turned ON.
6392: -- Bug 1623034. Commitment Type should not be a RELEASE.

Line 6451: fnd_msg_pub.add;

6447: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6448: IF(g_error_level >= g_debug_level) THEN
6449: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6450: END IF;
6451: fnd_msg_pub.add;
6452: END IF;
6453: END IF;
6454: END IF ; -- PF Functional and Encumbered Amt are same.
6455:

Line 6526: fnd_msg_pub.add;

6522: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6523: IF(g_error_level >= g_debug_level) THEN
6524: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6525: END IF;
6526: fnd_msg_pub.add;
6527: END IF; -- Fiscal Year Mismatch valdn ends here.
6528: END IF; -- Encumbrance Amt is greater than zero ends here.
6529: END IF; -- Encumbrance turned ON validation ends here.
6530:

Line 6556: fnd_msg_pub.add;

6552: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6553: IF(g_error_level >= g_debug_level) THEN
6554: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6555: END IF;
6556: fnd_msg_pub.add;
6557: END IF;
6558:
6559: END LOOP;
6560:

Line 6571: fnd_msg_pub.add;

6567: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6568: IF(g_error_level >= g_debug_level) THEN
6569: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6570: END IF;
6571: fnd_msg_pub.add;
6572: END IF;
6573:
6574: END IF;
6575:

Line 6578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

6574: END IF;
6575:
6576: END IF;
6577:
6578: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
6579:
6580: EXCEPTION
6581: WHEN E_CC_NOT_FOUND OR E_CC_INVALID_SET_UP THEN
6582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

6580: EXCEPTION
6581: WHEN E_CC_NOT_FOUND OR E_CC_INVALID_SET_UP THEN
6582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6583: x_valid_cc := FND_API.G_FALSE;
6584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6585: p_data => x_msg_data );
6586: CLOSE c_account_lines;
6587: IF (g_excep_level >= g_debug_level ) THEN
6588: FND_LOG.STRING (g_excep_level,l_full_path,'E_CC_NOT_FOUND OR E_CC_INVALID_SET_UP Exception Raised');

Line 6594: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

6590:
6591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6593: x_valid_cc := FND_API.G_FALSE;
6594: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6595: p_data => x_msg_data );
6596: CLOSE c_account_lines;
6597: IF (g_excep_level >= g_debug_level ) THEN
6598: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');

Line 6605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6601: WHEN OTHERS THEN
6602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6603: x_valid_cc := FND_API.G_FALSE;
6604:
6605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6606: THEN
6607: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6608: END IF;
6609:

Line 6607: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);

6603: x_valid_cc := FND_API.G_FALSE;
6604:
6605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6606: THEN
6607: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6608: END IF;
6609:
6610: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6611: p_data => x_msg_data );

Line 6610: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

6606: THEN
6607: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6608: END IF;
6609:
6610: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6611: p_data => x_msg_data );
6612: CLOSE c_account_lines;
6613:
6614: IF ( g_unexp_level >= g_debug_level ) THEN

Line 6658: FND_MSG_PUB.initialize;

6654: l_full_path := g_path || 'calculate_nonrec_tax';
6655:
6656: IF FND_API.to_Boolean(p_init_msg_list)
6657: THEN
6658: FND_MSG_PUB.initialize;
6659: END IF;
6660:
6661: IF NOT FND_API.Compatible_API_Call(l_api_version,
6662: p_api_version,

Line 6684: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

6680: (l_tax_rate/100) * p_amount;
6681: END IF;
6682:
6683:
6684: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
6685:
6686: EXCEPTION
6687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6689: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

6685:
6686: EXCEPTION
6687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6689: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6690: p_data => x_msg_data );
6691: IF (g_excep_level >= g_debug_level ) THEN
6692: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
6693: END IF;

Line 6698: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6694:
6695: WHEN OTHERS THEN
6696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6697:
6698: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6699: THEN
6700: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6701: END IF;
6702:

Line 6700: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);

6696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6697:
6698: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6699: THEN
6700: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6701: END IF;
6702:
6703: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6704: p_data => x_msg_data );

Line 6703: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

6699: THEN
6700: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6701: END IF;
6702:
6703: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6704: p_data => x_msg_data );
6705:
6706: IF ( g_unexp_level >= g_debug_level ) THEN
6707: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');