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 1976: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1972: WHEN FND_API.G_EXC_ERROR
1973: THEN
1974: x_return_status := FND_API.G_RET_STS_ERROR;
1975:
1976: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1977: p_data => x_msg_data );
1978:
1979: RETURN;
1980: IF (g_excep_level >= g_debug_level ) THEN

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

1984: WHEN OTHERS
1985: THEN
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987:
1988: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1989: THEN
1990: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1991: l_api_name);
1992: END IF;

Line 1990: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987:
1988: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1989: THEN
1990: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1991: l_api_name);
1992: END IF;
1993:
1994: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1990: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1991: l_api_name);
1992: END IF;
1993:
1994: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1995: p_data => x_msg_data );
1996:
1997: IF ( g_unexp_level >= g_debug_level ) THEN
1998: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 2297: FND_MSG_PUB.initialize;

2293: SAVEPOINT Execute_Budgetary_Ctrl1;
2294:
2295: IF FND_API.to_Boolean(p_init_msg_list)
2296: THEN
2297: FND_MSG_PUB.initialize;
2298: END IF;
2299:
2300: IF NOT FND_API.Compatible_API_Call(l_api_version,
2301: p_api_version,

Line 2330: fnd_msg_pub.add;

2326: fnd_message.set_token('MODE', p_mode,TRUE);
2327: IF(g_error_level >= g_debug_level) THEN
2328: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2329: END IF;
2330: fnd_msg_pub.add;
2331: RAISE E_INVALID_MODE;
2332: END IF;
2333:
2334: BEGIN

Line 2350: fnd_msg_pub.add;

2346: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2347: IF(g_error_level >= g_debug_level) THEN
2348: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2349: END IF;
2350: fnd_msg_pub.add;
2351: RAISE E_CC_NOT_FOUND;
2352:
2353: END;
2354:

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

2379:
2380: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2381: x_msg_data := l_msg_data;
2382: x_msg_count := l_msg_count;
2383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2384: THEN
2385: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2386: l_api_name);
2387: END IF;

Line 2385: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2381: x_msg_data := l_msg_data;
2382: x_msg_count := l_msg_count;
2383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2384: THEN
2385: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2386: l_api_name);
2387: END IF;
2388: RAISE E_UPDATE;
2389: END IF;

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

2397: WHERE cc_header_id = p_cc_header_id AND
2398: actual_flag = 'E';
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2402: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2403: l_api_name);
2404: END IF;
2405: IF ( g_unexp_level >= g_debug_level ) THEN

Line 2402: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2398: actual_flag = 'E';
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2402: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2403: l_api_name);
2404: END IF;
2405: IF ( g_unexp_level >= g_debug_level ) THEN
2406: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

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

2442: x_bc_status := FND_API.G_TRUE;
2443: RETURN;
2444: END IF;
2445: ELSE
2446: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2447: THEN
2448: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2449: l_api_name);
2450: END IF;

Line 2448: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2444: END IF;
2445: ELSE
2446: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2447: THEN
2448: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2449: l_api_name);
2450: END IF;
2451: RAISE E_CHECK_BUDG_CTRL;
2452: END IF;

Line 2466: fnd_msg_pub.add;

2462: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
2463: IF(g_error_level >= g_debug_level) THEN
2464: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2465: END IF;
2466: fnd_msg_pub.add;
2467: RAISE E_CC_INVALID_SET_UP;
2468: END;
2469:
2470: /* Check whether CBC is turned on */

Line 2549: fnd_msg_pub.add;

2545: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
2546: IF(g_error_level >= g_debug_level) THEN
2547: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
2548: END IF;
2549: fnd_msg_pub.add;
2550: RAISE E_CC_NOT_FOUND;
2551: END;
2552:
2553: /* end fix for bug 1567120 */

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

2576:
2577: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2578: x_msg_data := l_msg_data;
2579: x_msg_count := l_msg_count;
2580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2581: THEN
2582: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2583: l_api_name);
2584: END IF;

Line 2582: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2578: x_msg_data := l_msg_data;
2579: x_msg_count := l_msg_count;
2580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2581: THEN
2582: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2583: l_api_name);
2584: END IF;
2585: RAISE E_UPDATE;
2586: END IF;

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

2634: x_msg_count,
2635: x_msg_data,
2636: l_return_status);
2637: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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: l_return_status);
2637: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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_PROCESS_ROW;
2644: END IF;

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

2684: x_msg_data,
2685: l_return_status);
2686:
2687: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2688: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2689: THEN
2690: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2691: l_api_name);
2692: END IF;

Line 2690: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2686:
2687: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2688: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2689: THEN
2690: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2691: l_api_name);
2692: END IF;
2693: RAISE E_PROCESS_ROW;
2694: END IF;

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

2991: IF (g_debug_mode = 'Y') THEN
2992: g_debug_msg := ' FAILED Updated Acct Line ..... 1 ';
2993: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2994: END IF;
2995: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2996: THEN
2997: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2998: l_api_name);
2999: END IF;

Line 2997: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

2993: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
2994: END IF;
2995: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2996: THEN
2997: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2998: l_api_name);
2999: END IF;
3000: RAISE E_UPDATE_CC_TABLES;
3001: END IF;

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

3183: g_debug_msg := ' FAILURE updating DET PF line ...... 1 ';
3184: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3185: END IF;
3186:
3187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3188: THEN
3189: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3190: l_api_name);
3191: END IF;

Line 3189: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3185: END IF;
3186:
3187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3188: THEN
3189: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3190: l_api_name);
3191: END IF;
3192: RAISE E_UPDATE_CC_TABLES;
3193: END IF;

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

3283: IF (g_debug_mode = 'Y') THEN
3284: g_debug_msg := ' Failure UPDATING Header record..... 1';
3285: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3286: END IF;
3287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3288: THEN
3289: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3290: l_api_name);
3291: END IF;

Line 3289: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3285: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3286: END IF;
3287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3288: THEN
3289: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3290: l_api_name);
3291: END IF;
3292: RAISE E_UPDATE_CC_TABLES;
3293: END IF;

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

3330: g_debug_msg := ' Falure Inserting Actions Row..... 1 ';
3331: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3332: END IF;
3333:
3334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3335: THEN
3336: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3337: l_api_name);
3338: END IF;

Line 3336: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3332: END IF;
3333:
3334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3335: THEN
3336: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3337: l_api_name);
3338: END IF;
3339: RAISE E_UPDATE_CC_TABLES;
3340: END IF;

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

3343:
3344: EXCEPTION
3345: WHEN OTHERS
3346: THEN
3347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3348: THEN
3349: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3350: l_api_name);
3351: END IF;

Line 3349: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3345: WHEN OTHERS
3346: THEN
3347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3348: THEN
3349: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3350: l_api_name);
3351: END IF;
3352: IF ( g_unexp_level >= g_debug_level ) THEN
3353: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

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

3437: g_debug_msg := ' FAILED update accout line ........ 2';
3438: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3439: END IF;
3440:
3441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3442: THEN
3443: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3444: l_api_name);
3445: END IF;

Line 3443: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3439: END IF;
3440:
3441: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3442: THEN
3443: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3444: l_api_name);
3445: END IF;
3446: RAISE E_UPDATE_CC_TABLES;
3447: END IF;

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

3511: g_debug_msg := ' FAILED Updating DET PF Line INFO ...... 2 ';
3512: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3513: END IF;
3514:
3515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3516: THEN
3517: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3518: l_api_name);
3519: END IF;

Line 3517: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3513: END IF;
3514:
3515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3516: THEN
3517: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3518: l_api_name);
3519: END IF;
3520: RAISE E_UPDATE_CC_TABLES;
3521: END IF;

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

3578: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3579: END IF;
3580:
3581: l_cc_headers_rec.cc_encmbrnc_status := l_encumbrance_status_old;
3582: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3583: THEN
3584: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3585: l_api_name);
3586: END IF;

Line 3584: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3580:
3581: l_cc_headers_rec.cc_encmbrnc_status := l_encumbrance_status_old;
3582: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3583: THEN
3584: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3585: l_api_name);
3586: END IF;
3587: RAISE E_UPDATE_CC_TABLES;
3588: END IF;

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

3624: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
3625: END IF;
3626:
3627: l_cc_headers_rec.cc_encmbrnc_status := l_encumbrance_status_old;
3628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3629: THEN
3630: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3631: l_api_name);
3632: END IF;

Line 3630: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3626:
3627: l_cc_headers_rec.cc_encmbrnc_status := l_encumbrance_status_old;
3628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3629: THEN
3630: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3631: l_api_name);
3632: END IF;
3633: RAISE E_UPDATE_CC_TABLES;
3634: END IF;

Line 3646: fnd_msg_pub.add;

3642: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_INVALID');
3643: IF(g_state_level >= g_debug_level) THEN
3644: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3645: END IF;
3646: fnd_msg_pub.add;
3647: ELSE
3648: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_'||l_batch_result_code);
3649: IF(g_state_level >= g_debug_level) THEN
3650: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);

Line 3652: fnd_msg_pub.add;

3648: fnd_message.set_name('IGC', 'IGC_CC_CBC_RESULT_CODE_'||l_batch_result_code);
3649: IF(g_state_level >= g_debug_level) THEN
3650: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
3651: END IF;
3652: fnd_msg_pub.add;
3653: END IF;
3654:
3655: END IF;
3656:

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

3658: THEN
3659: COMMIT WORK;
3660: END IF;
3661:
3662: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3663: p_data => x_msg_data );
3664:
3665: RETURN;
3666:

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

3689: IF (c_det_pf_line_rec_input%ISOPEN) THEN
3690: CLOSE c_det_pf_line_rec_input;
3691: END IF;
3692:
3693: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3694: p_data => x_msg_data );
3695: IF (g_excep_level >= g_debug_level ) THEN
3696: 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');
3697: END IF;

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

3752: IF (c_det_pf_line_rec_input%ISOPEN) THEN
3753: CLOSE c_det_pf_line_rec_input;
3754: END IF;
3755:
3756: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3757: p_data => x_msg_data );
3758: IF (g_excep_level >= g_debug_level ) THEN
3759: FND_LOG.STRING (g_excep_level,l_full_path,'E_PROCESS_ROW Exception Raised');
3760: END IF;

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

3817: IF (c_det_pf_line_rec_input%ISOPEN) THEN
3818: CLOSE c_det_pf_line_rec_input;
3819: END IF;
3820:
3821: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3822: p_data => x_msg_data );
3823: IF (g_excep_level >= g_debug_level ) THEN
3824: FND_LOG.STRING (g_excep_level,l_full_path,
3825: '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 3890: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

3886: IF (c_det_pf_line_rec_input%ISOPEN) THEN
3887: CLOSE c_det_pf_line_rec_input;
3888: END IF;
3889:
3890: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3891: p_data => x_msg_data );
3892: IF (g_excep_level >= g_debug_level ) THEN
3893: FND_LOG.STRING (g_excep_level,l_full_path,'E_BC_EXECUTION Exception Raised');
3894: END IF;

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

3950: IF (c_det_pf_line_rec_input%ISOPEN) THEN
3951: CLOSE c_det_pf_line_rec_input;
3952: END IF;
3953:
3954: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3955: THEN
3956: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3957: l_api_name);
3958: END IF;

Line 3956: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

3952: END IF;
3953:
3954: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3955: THEN
3956: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3957: l_api_name);
3958: END IF;
3959:
3960: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

3956: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
3957: l_api_name);
3958: END IF;
3959:
3960: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3961: p_data => x_msg_data );
3962: IF ( g_unexp_level >= g_debug_level ) THEN
3963: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3964: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 4014: FND_MSG_PUB.initialize;

4010: l_enable_budg_control_flag := 'N';
4011:
4012: IF FND_API.to_Boolean(p_init_msg_list)
4013: THEN
4014: FND_MSG_PUB.initialize;
4015: END IF;
4016:
4017: IF NOT FND_API.Compatible_API_Call(l_api_version,
4018: p_api_version,

Line 4031: fnd_msg_pub.add;

4027: fnd_message.set_name('IGC', 'IGC_CC_NO_ORG_ID');
4028: IF(g_error_level >= g_debug_level) THEN
4029: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4030: END IF;
4031: fnd_msg_pub.add;
4032: RAISE E_NULL_PARAMETER;
4033: END IF;
4034:
4035: IF (p_sob_id IS NULL)

Line 4041: fnd_msg_pub.add;

4037: fnd_message.set_name('IGC', 'IGC_CC_NO_SOB_ID');
4038: IF(g_error_level >= g_debug_level) THEN
4039: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4040: END IF;
4041: fnd_msg_pub.add;
4042: RAISE E_NULL_PARAMETER;
4043: END IF;
4044:
4045: IF (p_cc_state IS NULL)

Line 4051: fnd_msg_pub.add;

4047: fnd_message.set_name('IGC', 'IGC_CC_NO_CC_STATE');
4048: IF(g_error_level >= g_debug_level) THEN
4049: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4050: END IF;
4051: fnd_msg_pub.add;
4052: RAISE E_NULL_PARAMETER;
4053: END IF;
4054:
4055: /* Check whether SBC is turned on */

Line 4072: fnd_msg_pub.add;

4068: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
4069: IF(g_error_level >= g_debug_level) THEN
4070: FND_LOG.MESSAGE(g_error_level, l_full_path || 'Msg4', FALSE);
4071: END IF;
4072: fnd_msg_pub.add;
4073: RAISE E_CC_INVALID_SET_UP;
4074: END;
4075:
4076:

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

4129: WHEN E_CC_NOT_FOUND OR E_CC_INVALID_SET_UP OR E_GL_DATA OR E_NULL_PARAMETER
4130: THEN
4131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4132: x_encumbrance_on := FND_API.G_FALSE;
4133: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4134: p_data => x_msg_data );
4135: IF (g_excep_level >= g_debug_level ) THEN
4136: 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');
4137: END IF;

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

4140: THEN
4141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4142: x_encumbrance_on := FND_API.G_FALSE;
4143:
4144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4145: p_data => x_msg_data );
4146: IF (g_excep_level >= g_debug_level ) THEN
4147: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
4148: END IF;

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

4151: THEN
4152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4153: x_encumbrance_on := FND_API.G_FALSE;
4154:
4155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4156: THEN
4157: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4158: l_api_name);
4159: END IF;

Line 4157: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4153: x_encumbrance_on := FND_API.G_FALSE;
4154:
4155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4156: THEN
4157: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4158: l_api_name);
4159: END IF;
4160:
4161: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

4157: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4158: l_api_name);
4159: END IF;
4160:
4161: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4162: p_data => x_msg_data );
4163: IF ( g_unexp_level >= g_debug_level ) THEN
4164: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4165: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 4370: FND_MSG_PUB.initialize;

4366: SAVEPOINT Set_Encumbrance_Status;
4367:
4368: IF FND_API.to_Boolean(p_init_msg_list)
4369: THEN
4370: FND_MSG_PUB.initialize;
4371: END IF;
4372:
4373: IF NOT FND_API.Compatible_API_Call(l_api_version,
4374: p_api_version,

Line 4394: fnd_msg_pub.add;

4390: fnd_message.set_token('CODE', p_encumbrance_status_code,TRUE);
4391: IF(g_error_level >= g_debug_level) THEN
4392: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4393: END IF;
4394: fnd_msg_pub.add;
4395: RAISE E_INVALID_STATUS_CODE;
4396:
4397: END IF;
4398:

Line 4415: fnd_msg_pub.add;

4411: fnd_message.set_token('CC_NUM', to_char(p_cc_header_id),TRUE);
4412: IF(g_excep_level >= g_debug_level) THEN
4413: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
4414: END IF;
4415: fnd_msg_pub.add;
4416: RAISE E_CC_NOT_FOUND;
4417:
4418: END;
4419:

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

4584: END IF;
4585: IF (c_cc_acct_line%ISOPEN) THEN
4586: CLOSE c_cc_acct_line;
4587: END IF;
4588: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4589: p_data => x_msg_data );
4590: IF (g_excep_level >= g_debug_level ) THEN
4591: FND_LOG.STRING (g_excep_level,l_full_path,'E_CC_NOT_FOUND OR E_INVALID_STATUS_CODE Exception Raised');
4592: END IF;

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

4606: END IF;
4607: IF (c_cc_acct_line%ISOPEN) THEN
4608: CLOSE c_cc_acct_line;
4609: END IF;
4610: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4611: p_data => x_msg_data );
4612: IF (g_excep_level >= g_debug_level ) THEN
4613: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
4614: END IF;

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

4629: IF (c_cc_acct_line%ISOPEN) THEN
4630: CLOSE c_cc_acct_line;
4631: END IF;
4632:
4633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4634: THEN
4635: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4636: l_api_name);
4637: END IF;

Line 4635: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

4631: END IF;
4632:
4633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4634: THEN
4635: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4636: l_api_name);
4637: END IF;
4638:
4639: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

4635: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
4636: l_api_name);
4637: END IF;
4638:
4639: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4640: p_data => x_msg_data );
4641: IF ( g_unexp_level >= g_debug_level ) THEN
4642: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4643: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 4854: FND_MSG_PUB.initialize;

4850:
4851: l_full_path := g_path || 'Validate_CC';
4852:
4853: IF FND_API.to_Boolean(p_init_msg_list) THEN
4854: FND_MSG_PUB.initialize;
4855: END IF;
4856:
4857: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version, l_api_name, G_PKG_NAME) THEN
4858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4892: fnd_msg_pub.add;

4888: fnd_message.set_name('IGC', 'IGC_CC_INVALID_GL_DATA');
4889: IF(g_error_level >= g_debug_level) THEN
4890: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
4891: END IF;
4892: fnd_msg_pub.add;
4893: RAISE E_CC_INVALID_SET_UP;
4894: END;
4895:
4896: -- Commitment Budgetary Control enabled or not

Line 4963: fnd_msg_pub.add;

4959: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
4960: IF(g_state_level >= g_debug_level) THEN
4961: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
4962: END IF;
4963: fnd_msg_pub.add;
4964: END IF;
4965: END IF;
4966:
4967: -- Encumbrance turned on or not check begins here.

Line 5000: fnd_msg_pub.add;

4996: fnd_message.set_token('STARTDATE', FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
4997: IF(g_state_level >= g_debug_level) THEN
4998: FND_LOG.MESSAGE(g_state_level, l_full_path, FALSE);
4999: END IF;
5000: fnd_msg_pub.add;
5001: END IF;
5002:
5003: ELSIF p_encumbrance_flag = FND_API.G_TRUE AND
5004: ( l_sbc_enable_flag = 'Y' ) AND

Line 5050: fnd_msg_pub.add;

5046: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(p_start_date),FALSE);
5047: IF(g_error_level >= g_debug_level) THEN
5048: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5049: END IF;
5050: fnd_msg_pub.add;
5051: END IF;
5052:
5053: END IF; -- Encumbrance turned on or not condition ends here.
5054:

Line 5078: fnd_msg_pub.add;

5074: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE(P_START_DATE),FALSE);
5075: IF(g_error_level >= g_debug_level) THEN
5076: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5077: END IF;
5078: fnd_msg_pub.add;
5079: END IF;
5080: END IF; -- Commitment Type is Cover
5081:
5082:

Line 5104: fnd_msg_pub.add;

5100: fnd_message.set_token('STARTDATE',FND_DATE.DATE_TO_CHARDATE (P_START_DATE),FALSE);
5101: IF(g_error_level >= g_debug_level) THEN
5102: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5103: END IF;
5104: fnd_msg_pub.add;
5105: END IF;
5106: END IF; -- Commitment Type is Release.
5107:
5108: ELSIF ( p_start_date IS NULL) THEN

Line 5115: fnd_msg_pub.add;

5111: fnd_message.set_name('IGC', 'IGC_CC_NO_START_DATE');
5112: IF(g_error_level >= g_debug_level) THEN
5113: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5114: END IF;
5115: fnd_msg_pub.add;
5116:
5117: END IF; -- Start Date is Not Null. Start Date Validations ends here.
5118:
5119: -- End Date Validations begins here.

Line 5132: fnd_msg_pub.add;

5128: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE (P_END_DATE),FALSE);
5129: IF(g_error_level >= g_debug_level) THEN
5130: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5131: END IF;
5132: fnd_msg_pub.add;
5133: END IF;
5134:
5135: IF (p_cc_type_code = 'C') AND (p_cc_header_id IS NOT NULL)
5136: THEN

Line 5156: fnd_msg_pub.add;

5152: fnd_message.set_name('IGC', 'IGC_CC_EFF_COVER_END_DATE');
5153: IF(g_error_level >= g_debug_level) THEN
5154: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5155: END IF;
5156: fnd_msg_pub.add;
5157: END IF;
5158: END IF; -- Commitment Type is Cover
5159:
5160: IF (p_cc_type_code = 'R') THEN

Line 5180: fnd_msg_pub.add;

5176: fnd_message.set_name('IGC', 'IGC_CC_EFF_REL_END_DATE');
5177: IF(g_error_level >= g_debug_level) THEN
5178: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5179: END IF;
5180: fnd_msg_pub.add;
5181: END IF;
5182: END IF; -- Commitment Type is Release
5183:
5184: END IF; -- End Date is NOT NULL. End Date Validations ends here.

Line 5200: fnd_msg_pub.add;

5196: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5197: IF(g_error_level >= g_debug_level) THEN
5198: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5199: END IF;
5200: fnd_msg_pub.add;
5201: END IF;
5202: IF ( (p_cc_det_pf_date > p_end_date) AND
5203: (p_end_date IS NOT NULL)
5204: ) THEN

Line 5212: fnd_msg_pub.add;

5208: fnd_message.set_token('PFDATE',FND_DATE.DATE_TO_CHARDATE(p_cc_det_pf_date),FALSE);
5209: IF(g_error_level >= g_debug_level) THEN
5210: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5211: END IF;
5212: fnd_msg_pub.add;
5213: END IF;
5214:
5215: -- Budgetary Control turned on.
5216:

Line 5253: fnd_msg_pub.add;

5249: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
5250: IF(g_error_level >= g_debug_level) THEN
5251: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5252: END IF;
5253: fnd_msg_pub.add;
5254: END IF;
5255: END IF; -- Budgetary Control turned on.
5256: END IF; -- Payment Forecast Date is NOT NULL. Payment Forecast Date Validations ends here.
5257:

Line 5282: fnd_msg_pub.add;

5278: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5279: IF(g_error_level >= g_debug_level) THEN
5280: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5281: END IF;
5282: fnd_msg_pub.add;
5283: END IF;
5284:
5285: -- Bug # 1678518.
5286:

Line 5301: fnd_msg_pub.add;

5297: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5298: IF(g_error_level >= g_debug_level) THEN
5299: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5300: END IF;
5301: fnd_msg_pub.add;
5302: END IF;
5303: END IF;
5304: END IF;
5305:

Line 5359: fnd_msg_pub.add;

5355: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');
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:
5362: -- Bug # 1619201.
5363: -- If Previously been encumbered.

Line 5432: fnd_msg_pub.add;

5428: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5429: IF(g_error_level >= g_debug_level) THEN
5430: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5431: END IF;
5432: fnd_msg_pub.add;
5433: END IF; -- Fiscal Year Mismatch valdn ends here.
5434: END IF; -- If Previously been encumbered. Bug # 1619201.
5435:
5436: ELSIF (p_cc_state = 'CM' OR p_cc_state = 'CT')

Line 5473: fnd_msg_pub.add;

5469: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');
5470: IF(g_error_level >= g_debug_level) THEN
5471: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5472: END IF;
5473: fnd_msg_pub.add;
5474: END IF;
5475: END IF;
5476: END IF; -- Encumbrance turned on.
5477: END IF; -- Encumbrance Account Date Validations ends here.

Line 5503: fnd_msg_pub.add;

5499: fnd_message.set_token('ENDDATE',FND_DATE.DATE_TO_CHARDATE(P_END_DATE),FALSE);
5500: IF(g_error_level >= g_debug_level) THEN
5501: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5502: END IF;
5503: fnd_msg_pub.add;
5504: END IF;
5505:
5506: -- Bug # 1678518.
5507:

Line 5522: fnd_msg_pub.add;

5518: fnd_message.set_token('PREV_ACCTDATE',FND_DATE.DATE_TO_CHARDATE(P_PREV_ACCT_DATE),FALSE);
5519: IF(g_error_level >= g_debug_level) THEN
5520: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5521: END IF;
5522: fnd_msg_pub.add;
5523: END IF;
5524: END IF;
5525: END IF;
5526:

Line 5579: fnd_msg_pub.add;

5575: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_OF');
5576: IF(g_error_level >= g_debug_level) THEN
5577: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5578: END IF;
5579: fnd_msg_pub.add;
5580: END IF;
5581:
5582: -- Bug # 1619201.
5583: -- If Previously been encumbered.

Line 5652: fnd_msg_pub.add;

5648: fnd_message.set_TOKEN('PREVACTDATE',FND_DATE.DATE_TO_CHARDATE (p_prev_acct_date),FALSE);
5649: IF(g_error_level >= g_debug_level) THEN
5650: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5651: END IF;
5652: fnd_msg_pub.add;
5653: END IF; -- Fiscal Year Mismatch valdn ends here.
5654: END IF; -- If Previously been encumbered. Bug # 1619201.
5655:
5656: ELSIF (p_cc_state = 'CM' OR p_cc_state = 'CT')

Line 5693: fnd_msg_pub.add;

5689: fnd_message.set_name('IGC', 'IGC_CC_ACCT_DATE_O');
5690: IF(g_error_level >= g_debug_level) THEN
5691: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5692: END IF;
5693: fnd_msg_pub.add;
5694: END IF;
5695: END IF;
5696: END IF; -- Encumbrance turned on.
5697: END IF; -- Approval Accounting Date Validations ends here.

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

5714: IF(g_error_level >= g_debug_level) THEN
5715: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5716: END IF;
5717: l_error_message := fnd_message.get;
5718: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
5719: RAISE E_CC_NOT_FOUND;
5720:
5721: END;
5722:

Line 5774: fnd_msg_pub.add;

5770: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5771: IF(g_error_level >= g_debug_level) THEN
5772: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5773: END IF;
5774: fnd_msg_pub.add;
5775: ELSIF (NVL(l_cc_det_pf_cnt,0) > 0) THEN
5776:
5777: OPEN c_det_pf_lines(l_cc_acct_lines_rec.cc_acct_line_id);
5778: LOOP

Line 5796: fnd_msg_pub.add;

5792: fnd_message.set_TOKEN('ACCTDATE',FND_DATE.DATE_TO_CHARDATE (p_acct_date),FALSE);
5793: IF(g_error_level >= g_debug_level) THEN
5794: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5795: END IF;
5796: fnd_msg_pub.add;
5797: END IF;
5798:
5799:
5800: END LOOP; -- Payment Forecast Loop end here.

Line 5818: fnd_msg_pub.add;

5814: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
5815: IF(g_error_level >= g_debug_level) THEN
5816: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5817: END IF;
5818: fnd_msg_pub.add;
5819: END IF;
5820: END IF;
5821:
5822:

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

5838: IF(g_error_level >= g_debug_level) THEN
5839: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5840: END IF;
5841: l_error_message := fnd_message.get;
5842: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
5843: RAISE E_CC_NOT_FOUND;
5844:
5845: END;
5846:

Line 5891: fnd_msg_pub.add;

5887: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
5888: IF(g_error_level >= g_debug_level) THEN
5889: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5890: END IF;
5891: fnd_msg_pub.add;
5892: ELSIF (NVL(l_cc_det_pf_cnt,0) > 0) THEN
5893:
5894: OPEN c_det_pf_lines(l_cc_acct_lines_rec.cc_acct_line_id);
5895: LOOP

Line 5912: fnd_msg_pub.add;

5908: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5909: IF (g_error_level >= g_debug_level) THEN
5910: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5911: END IF;
5912: fnd_msg_pub.add;
5913: END IF;
5914:
5915: -- PF Date vs End Date Validation.
5916:

Line 5927: fnd_msg_pub.add;

5923: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
5924: IF(g_error_level >= g_debug_level) THEN
5925: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5926: END IF;
5927: fnd_msg_pub.add;
5928: END IF;
5929:
5930: -- bug 5667529
5931: -- changes done by kasbalas

Line 5976: fnd_msg_pub.add;

5972: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
5973: IF(g_error_level >= g_debug_level) THEN
5974: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
5975: END IF;
5976: fnd_msg_pub.add;
5977: END IF;
5978:
5979: -- Encumbrance turned ON.
5980: -- Bug 1623034. Commitment Type should not be a RELEASE.

Line 6039: fnd_msg_pub.add;

6035: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6036: IF(g_error_level >= g_debug_level) THEN
6037: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6038: END IF;
6039: fnd_msg_pub.add;
6040: END IF;
6041: END IF;
6042: END IF ; -- PF Functional and Encumbered Amt are same.
6043:

Line 6114: fnd_msg_pub.add;

6110: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6111: IF(g_error_level >= g_debug_level) THEN
6112: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6113: END IF;
6114: fnd_msg_pub.add;
6115: END IF; -- Fiscal Year Mismatch valdn ends here.
6116: END IF; -- Encumbrance Amt is greater than zero ends here.
6117: END IF; -- Encumbrance turned ON validation ends here.
6118:

Line 6145: fnd_msg_pub.add;

6141: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6142: IF(g_error_level >= g_debug_level) THEN
6143: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6144: END IF;
6145: fnd_msg_pub.add;
6146: END IF;
6147:
6148: END LOOP;
6149:

Line 6160: fnd_msg_pub.add;

6156: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6157: IF(g_error_level >= g_debug_level) THEN
6158: FND_LOG.MESSAGE(g_error_level, g_debug_level, FALSE);
6159: END IF;
6160: fnd_msg_pub.add;
6161: END IF;
6162: END IF;
6163:
6164: ELSIF p_mode = 'A' OR p_mode = 'B' THEN

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

6183: IF(g_error_level >= g_debug_level) THEN
6184: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6185: END IF;
6186: l_error_message := fnd_message.get;
6187: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name, l_error_message);
6188: RAISE E_CC_NOT_FOUND;
6189:
6190: END;
6191:

Line 6241: fnd_msg_pub.add;

6237: fnd_message.set_token('ACCT_NUM', to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6238: IF(g_error_level >= g_debug_level) THEN
6239: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6240: END IF;
6241: fnd_msg_pub.add;
6242: ELSIF (NVL(l_cc_det_pf_cnt,0) > 0) THEN
6243:
6244: OPEN c_det_pf_lines(l_cc_acct_lines_rec.cc_acct_line_id);
6245: LOOP

Line 6262: fnd_msg_pub.add;

6258: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6259: IF(g_error_level >= g_debug_level) THEN
6260: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6261: END IF;
6262: fnd_msg_pub.add;
6263: END IF;
6264:
6265: -- PF Date vs End Date Validation.
6266:

Line 6277: fnd_msg_pub.add;

6273: fnd_message.set_TOKEN('PFDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_date),FALSE);
6274: IF(g_error_level >= g_debug_level) THEN
6275: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6276: END IF;
6277: fnd_msg_pub.add;
6278: END IF;
6279:
6280: -- bug 5667529
6281: -- changes done by kasbalas

Line 6326: fnd_msg_pub.add;

6322: fnd_message.set_name('IGC', 'IGC_CC_DET_PF_DATE');
6323: IF(g_error_level >= g_debug_level) THEN
6324: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6325: END IF;
6326: fnd_msg_pub.add;
6327: END IF;
6328:
6329: -- Encumbrance turned ON.
6330: -- Bug 1623034. Commitment Type should not be a RELEASE.

Line 6389: fnd_msg_pub.add;

6385: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6386: IF(g_error_level >= g_debug_level) THEN
6387: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6388: END IF;
6389: fnd_msg_pub.add;
6390: END IF;
6391: END IF;
6392: END IF ; -- PF Functional and Encumbered Amt are same.
6393:

Line 6464: fnd_msg_pub.add;

6460: fnd_message.set_TOKEN('ENCMBRNCDATE',FND_DATE.DATE_TO_CHARDATE (l_cc_det_pf_lines_rec.cc_det_pf_encmbrnc_date),FALSE);
6461: IF(g_error_level >= g_debug_level) THEN
6462: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6463: END IF;
6464: fnd_msg_pub.add;
6465: END IF; -- Fiscal Year Mismatch valdn ends here.
6466: END IF; -- Encumbrance Amt is greater than zero ends here.
6467: END IF; -- Encumbrance turned ON validation ends here.
6468:

Line 6494: fnd_msg_pub.add;

6490: fnd_message.set_token('ACCT_NUM',to_char(l_cc_acct_lines_rec.cc_acct_line_num),TRUE);
6491: IF(g_error_level >= g_debug_level) THEN
6492: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6493: END IF;
6494: fnd_msg_pub.add;
6495: END IF;
6496:
6497: END LOOP;
6498:

Line 6509: fnd_msg_pub.add;

6505: fnd_message.set_token('CC_NUM', l_cc_headers_rec.cc_num,TRUE);
6506: IF(g_error_level >= g_debug_level) THEN
6507: FND_LOG.MESSAGE(g_error_level, l_full_path, FALSE);
6508: END IF;
6509: fnd_msg_pub.add;
6510: END IF;
6511:
6512: END IF;
6513:

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

6512: END IF;
6513:
6514: END IF;
6515:
6516: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
6517:
6518: EXCEPTION
6519: WHEN E_CC_NOT_FOUND OR E_CC_INVALID_SET_UP THEN
6520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6518: EXCEPTION
6519: WHEN E_CC_NOT_FOUND OR E_CC_INVALID_SET_UP THEN
6520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6521: x_valid_cc := FND_API.G_FALSE;
6522: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6523: p_data => x_msg_data );
6524: CLOSE c_account_lines;
6525: IF (g_excep_level >= g_debug_level ) THEN
6526: FND_LOG.STRING (g_excep_level,l_full_path,'E_CC_NOT_FOUND OR E_CC_INVALID_SET_UP Exception Raised');

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

6528:
6529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6531: x_valid_cc := FND_API.G_FALSE;
6532: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6533: p_data => x_msg_data );
6534: CLOSE c_account_lines;
6535: IF (g_excep_level >= g_debug_level ) THEN
6536: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');

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

6539: WHEN OTHERS THEN
6540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6541: x_valid_cc := FND_API.G_FALSE;
6542:
6543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6544: THEN
6545: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6546: END IF;
6547:

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

6541: x_valid_cc := FND_API.G_FALSE;
6542:
6543: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6544: THEN
6545: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6546: END IF;
6547:
6548: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6549: p_data => x_msg_data );

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

6544: THEN
6545: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6546: END IF;
6547:
6548: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6549: p_data => x_msg_data );
6550: CLOSE c_account_lines;
6551:
6552: IF ( g_unexp_level >= g_debug_level ) THEN

Line 6596: FND_MSG_PUB.initialize;

6592: l_full_path := g_path || 'calculate_nonrec_tax';
6593:
6594: IF FND_API.to_Boolean(p_init_msg_list)
6595: THEN
6596: FND_MSG_PUB.initialize;
6597: END IF;
6598:
6599: IF NOT FND_API.Compatible_API_Call(l_api_version,
6600: p_api_version,

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

6618: (l_tax_rate/100) * p_amount;
6619: END IF;
6620:
6621:
6622: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
6623:
6624: EXCEPTION
6625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6623:
6624: EXCEPTION
6625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6627: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6628: p_data => x_msg_data );
6629: IF (g_excep_level >= g_debug_level ) THEN
6630: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
6631: END IF;

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

6632:
6633: WHEN OTHERS THEN
6634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6635:
6636: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6637: THEN
6638: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6639: END IF;
6640:

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

6634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6635:
6636: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6637: THEN
6638: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6639: END IF;
6640:
6641: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6642: p_data => x_msg_data );

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

6637: THEN
6638: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name);
6639: END IF;
6640:
6641: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6642: p_data => x_msg_data );
6643:
6644: IF ( g_unexp_level >= g_debug_level ) THEN
6645: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');