DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on FND_MSG_PUB

Line 329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

325: exception
326: WHEN OTHERS THEN
327: raise;
328: x_return_status := FND_API.g_ret_sts_unexp_error;
329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
330: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
331: IF g_fnd_debug = 'Y' THEN
332: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
333: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 330: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

326: WHEN OTHERS THEN
327: raise;
328: x_return_status := FND_API.g_ret_sts_unexp_error;
329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
330: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
331: IF g_fnd_debug = 'Y' THEN
332: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
333: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
334: l_api_name || '.others_exception', sqlcode);

Line 426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

422: exception
423: WHEN OTHERS THEN
424: raise;
425: x_return_status := FND_API.g_ret_sts_unexp_error;
426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
427: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
428: IF g_fnd_debug = 'Y' THEN
429: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
430: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 427: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

423: WHEN OTHERS THEN
424: raise;
425: x_return_status := FND_API.g_ret_sts_unexp_error;
426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
427: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
428: IF g_fnd_debug = 'Y' THEN
429: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
430: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
431: l_api_name || '.others_exception', sqlcode);

Line 528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

524: exception
525: WHEN OTHERS THEN
526: raise;
527: x_return_status := FND_API.g_ret_sts_unexp_error;
528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
530: IF g_fnd_debug = 'Y' THEN
531: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
532: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

525: WHEN OTHERS THEN
526: raise;
527: x_return_status := FND_API.g_ret_sts_unexp_error;
528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
529: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
530: IF g_fnd_debug = 'Y' THEN
531: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
532: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
533: l_api_name || '.others_exception', sqlcode);

Line 581: FND_MSG_PUB.initialize;

577:
578: BEGIN
579: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
580: -- initialize message list
581: FND_MSG_PUB.initialize;
582: END IF;
583:
584: -- Standard call to check for call compatibility.
585:

Line 717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

713: x_return_status := FND_API.g_ret_sts_unexp_error;
714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error;
716:
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
719: IF g_fnd_debug = 'Y' THEN
720: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
721: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error;
716:
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
719: IF g_fnd_debug = 'Y' THEN
720: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
721: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
722: l_api_name || '.others exception' ,sqlcode);

Line 908: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

904: l_po_change_requests(1).request_level='HEADER' ) then
905: if (l_po_change_requests.count > 1 ) then
906: x_return_status := FND_API.g_ret_sts_unexp_error;
907:
908: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
909: IF g_fnd_debug = 'Y' THEN
910: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
911: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
912: l_api_name || fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ'), sqlcode);

Line 961: FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');

957: */
958:
959: x_pos_errors.text_line(1) :=
960: fnd_message.get_string('PO', 'POS_SAVE_CANCEL_REQ_ERR') ||
961: FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');
962:
963:
964: end if;
965:

Line 1071: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1067: where line_location_id = l_po_change_requests(i).document_line_location_id;
1068: exception
1069: WHEN OTHERS THEN
1070: x_return_status := FND_API.g_ret_sts_unexp_error;
1071: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1072: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1073: IF g_fnd_debug = 'Y' THEN
1074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1075: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 1072: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1068: exception
1069: WHEN OTHERS THEN
1070: x_return_status := FND_API.g_ret_sts_unexp_error;
1071: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1072: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1073: IF g_fnd_debug = 'Y' THEN
1074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1075: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1076: l_api_name || '.others_exception', sqlcode);

Line 1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1276: end if; -- if call doc check is false
1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: x_return_status := FND_API.g_ret_sts_unexp_error;
1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1282: IF g_fnd_debug = 'Y' THEN
1283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1284: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 1281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: x_return_status := FND_API.g_ret_sts_unexp_error;
1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1282: IF g_fnd_debug = 'Y' THEN
1283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1284: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1285: l_api_name || '.others_exception', sqlcode);

Line 1289: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

1285: l_api_name || '.others_exception', sqlcode);
1286: END IF;
1287: END IF;
1288: END IF;
1289: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1290: p_encoded => 'F');
1291: END process_supplier_request;
1292: /**
1293: * Private Procedure: update_po_attributes

Line 1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1438: end if;
1439: EXCEPTION
1440: WHEN OTHERS THEN
1441: x_return_status := FND_API.g_ret_sts_unexp_error;
1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1444: IF g_fnd_debug = 'Y' THEN
1445: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1446: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 1443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1439: EXCEPTION
1440: WHEN OTHERS THEN
1441: x_return_status := FND_API.g_ret_sts_unexp_error;
1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1443: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1444: IF g_fnd_debug = 'Y' THEN
1445: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1446: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1447: l_api_name || '.others_exception', sqlcode);

Line 1961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1957: WHEN sub_check_failed THEN
1958: x_return_status := FND_API.g_ret_sts_error;
1959: WHEN OTHERS THEN
1960: x_return_status := FND_API.g_ret_sts_unexp_error;
1961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1962: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1963: IF g_fnd_debug = 'Y' THEN
1964: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1965: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 1962: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1958: x_return_status := FND_API.g_ret_sts_error;
1959: WHEN OTHERS THEN
1960: x_return_status := FND_API.g_ret_sts_unexp_error;
1961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1962: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1963: IF g_fnd_debug = 'Y' THEN
1964: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1965: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1966: l_api_name || '.others_exception', sqlcode);

Line 1970: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

1966: l_api_name || '.others_exception', sqlcode);
1967: END IF;
1968: END IF;
1969: END IF;
1970: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1971: p_encoded => 'F');
1972: END validate_change_request;
1973:
1974: /* Overloaded Procedure to return only filtered Errors for supplier changes*/

Line 2266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2262: WHEN FND_API.g_exc_unexpected_error THEN
2263: x_return_status := FND_API.g_ret_sts_unexp_error;
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.g_ret_sts_unexp_error;
2266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2267: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2268: IF g_fnd_debug = 'Y' THEN
2269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2270: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 2267: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2263: x_return_status := FND_API.g_ret_sts_unexp_error;
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.g_ret_sts_unexp_error;
2266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2267: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2268: IF g_fnd_debug = 'Y' THEN
2269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2270: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2271: l_api_name || '.others_exception', sqlcode);

Line 2288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2284: WHEN FND_API.g_exc_unexpected_error THEN
2285: x_return_status := FND_API.g_ret_sts_unexp_error;
2286: WHEN OTHERS THEN
2287: x_return_status := FND_API.g_ret_sts_unexp_error;
2288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2290: IF g_fnd_debug = 'Y' THEN
2291: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2292: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 2289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2285: x_return_status := FND_API.g_ret_sts_unexp_error;
2286: WHEN OTHERS THEN
2287: x_return_status := FND_API.g_ret_sts_unexp_error;
2288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2289: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2290: IF g_fnd_debug = 'Y' THEN
2291: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2292: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2293: l_api_name || '.others_exception', sqlcode);

Line 2488: FND_MSG_PUB.initialize;

2484:
2485: BEGIN
2486: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2487: -- initialize message list
2488: FND_MSG_PUB.initialize;
2489: END IF;
2490:
2491: -- Standard call to check for call compatibility.
2492:

Line 2535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2531: x_return_status := FND_API.g_ret_sts_unexp_error;
2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.g_ret_sts_unexp_error;
2534:
2535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2536: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2537: IF g_fnd_debug = 'Y' THEN
2538: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2539: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 2536: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.g_ret_sts_unexp_error;
2534:
2535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2536: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2537: IF g_fnd_debug = 'Y' THEN
2538: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2539: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2540: l_api_name || '.others exception' ,sqlcode);

Line 2661: FND_MSG_PUB.initialize;

2657:
2658: BEGIN
2659: -- Start standard API initialization
2660: IF FND_API.to_boolean(p_init_msg_list) THEN
2661: FND_MSG_PUB.initialize;
2662: END IF;
2663: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2664: l_api_name, g_pkg_name)
2665: THEN

Line 2880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2876: WHEN FND_API.g_exc_unexpected_error THEN
2877: x_return_status := FND_API.g_ret_sts_unexp_error;
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.g_ret_sts_unexp_error;
2880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2881: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2882: IF (g_fnd_debug = 'Y') THEN
2883: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2884: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 2881: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2877: x_return_status := FND_API.g_ret_sts_unexp_error;
2878: WHEN OTHERS THEN
2879: x_return_status := FND_API.g_ret_sts_unexp_error;
2880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2881: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2882: IF (g_fnd_debug = 'Y') THEN
2883: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2884: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2885: l_api_name || '.others_exception', 'Exception');

Line 2921: FND_MSG_PUB.initialize;

2917: BEGIN
2918:
2919: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2920: -- initialize message list
2921: FND_MSG_PUB.initialize;
2922: END IF;
2923:
2924: -- Standard call to check for call compatibility.
2925:

Line 3101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3097: END IF;
3098: x_return_status := FND_API.g_ret_sts_error;
3099: WHEN OTHERS THEN
3100: x_return_status := FND_API.g_ret_sts_unexp_error;
3101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3102: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3103: IF g_fnd_debug = 'Y' THEN
3104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3105: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 3102: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3098: x_return_status := FND_API.g_ret_sts_error;
3099: WHEN OTHERS THEN
3100: x_return_status := FND_API.g_ret_sts_unexp_error;
3101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3102: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3103: IF g_fnd_debug = 'Y' THEN
3104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3105: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3106: l_api_name || '.others exception' ,sqlcode);

Line 3144: FND_MSG_PUB.initialize;

3140: BEGIN
3141:
3142: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
3143: -- initialize message list
3144: FND_MSG_PUB.initialize;
3145: END IF;
3146:
3147: -- Standard call to check for call compatibility.
3148:

Line 3327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3323: END IF;
3324: x_return_status := FND_API.g_ret_sts_error;
3325: WHEN OTHERS THEN
3326: x_return_status := FND_API.g_ret_sts_unexp_error;
3327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3329: IF g_fnd_debug = 'Y' THEN
3330: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3331: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 3328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3324: x_return_status := FND_API.g_ret_sts_error;
3325: WHEN OTHERS THEN
3326: x_return_status := FND_API.g_ret_sts_unexp_error;
3327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3329: IF g_fnd_debug = 'Y' THEN
3330: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3331: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3332: l_api_name || '.others exception' ,sqlcode);

Line 3935: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

3931: END IF;
3932: EXCEPTION
3933: WHEN OTHERS THEN RAISE;
3934: x_ret_sts := fnd_api.g_ret_sts_unexp_error;
3935: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3936: THEN
3937: fnd_msg_pub.Add_exc_msg(g_pkg_name, l_api_name);
3938: IF g_fnd_debug = 'Y' THEN
3939: IF ( fnd_log.g_current_runtime_level <=fnd_log.level_unexpected ) THEN

Line 3937: fnd_msg_pub.Add_exc_msg(g_pkg_name, l_api_name);

3933: WHEN OTHERS THEN RAISE;
3934: x_ret_sts := fnd_api.g_ret_sts_unexp_error;
3935: IF fnd_msg_pub.Check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3936: THEN
3937: fnd_msg_pub.Add_exc_msg(g_pkg_name, l_api_name);
3938: IF g_fnd_debug = 'Y' THEN
3939: IF ( fnd_log.g_current_runtime_level <=fnd_log.level_unexpected ) THEN
3940: fnd_log.String(fnd_log.level_unexpected, g_module_prefix|| l_api_name||'.others_exception', SQLCODE);
3941: END IF;