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 478: FND_MSG_PUB.initialize;

474:
475: BEGIN
476: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
477: -- initialize message list
478: FND_MSG_PUB.initialize;
479: END IF;
480:
481: -- Standard call to check for call compatibility.
482:

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

610: x_return_status := FND_API.g_ret_sts_unexp_error;
611: WHEN OTHERS THEN
612: x_return_status := FND_API.g_ret_sts_unexp_error;
613:
614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
616: IF g_fnd_debug = 'Y' THEN
617: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
618: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

611: WHEN OTHERS THEN
612: x_return_status := FND_API.g_ret_sts_unexp_error;
613:
614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
616: IF g_fnd_debug = 'Y' THEN
617: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
618: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
619: l_api_name || '.others exception' ,sqlcode);

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

800: l_po_change_requests(1).request_level='HEADER' ) then
801: if (l_po_change_requests.count > 1 ) then
802: x_return_status := FND_API.g_ret_sts_unexp_error;
803:
804: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
805: IF g_fnd_debug = 'Y' THEN
806: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
807: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
808: l_api_name || fnd_message.get_string('PO', 'POS_MULT_HDR_CANCEL_REQ'), sqlcode);

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

853: */
854:
855: x_pos_errors.text_line(1) :=
856: fnd_message.get_string('PO', 'POS_SAVE_CANCEL_REQ_ERR') ||
857: FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, p_encoded => 'F');
858:
859:
860: end if;
861:

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

963: where line_location_id = l_po_change_requests(i).document_line_location_id;
964: exception
965: WHEN OTHERS THEN
966: x_return_status := FND_API.g_ret_sts_unexp_error;
967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
968: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
969: IF g_fnd_debug = 'Y' THEN
970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
971: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

964: exception
965: WHEN OTHERS THEN
966: x_return_status := FND_API.g_ret_sts_unexp_error;
967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
968: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
969: IF g_fnd_debug = 'Y' THEN
970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
971: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
972: l_api_name || '.others_exception', sqlcode);

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

1163: end if; -- if call doc check is false
1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: x_return_status := FND_API.g_ret_sts_unexp_error;
1167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1169: IF g_fnd_debug = 'Y' THEN
1170: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1171: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: x_return_status := FND_API.g_ret_sts_unexp_error;
1167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1168: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1169: IF g_fnd_debug = 'Y' THEN
1170: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1171: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1172: l_api_name || '.others_exception', sqlcode);

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

1172: l_api_name || '.others_exception', sqlcode);
1173: END IF;
1174: END IF;
1175: END IF;
1176: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1177: p_encoded => 'F');
1178: END process_supplier_request;
1179: /**
1180: * Private Procedure: update_po_attributes

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

1324: end if;
1325: EXCEPTION
1326: WHEN OTHERS THEN
1327: x_return_status := FND_API.g_ret_sts_unexp_error;
1328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1329: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1330: IF g_fnd_debug = 'Y' THEN
1331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1332: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

1325: EXCEPTION
1326: WHEN OTHERS THEN
1327: x_return_status := FND_API.g_ret_sts_unexp_error;
1328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1329: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1330: IF g_fnd_debug = 'Y' THEN
1331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1332: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1333: l_api_name || '.others_exception', sqlcode);

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

1810: WHEN sub_check_failed THEN
1811: x_return_status := FND_API.g_ret_sts_error;
1812: WHEN OTHERS THEN
1813: x_return_status := FND_API.g_ret_sts_unexp_error;
1814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1815: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1816: IF g_fnd_debug = 'Y' THEN
1817: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1818: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

1811: x_return_status := FND_API.g_ret_sts_error;
1812: WHEN OTHERS THEN
1813: x_return_status := FND_API.g_ret_sts_unexp_error;
1814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1815: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1816: IF g_fnd_debug = 'Y' THEN
1817: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1818: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1819: l_api_name || '.others_exception', sqlcode);

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

1819: l_api_name || '.others_exception', sqlcode);
1820: END IF;
1821: END IF;
1822: END IF;
1823: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1824: p_encoded => 'F');
1825: END validate_change_request;
1826:
1827: /* Overloaded Procedure to return only filtered Errors for supplier changes*/

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

2115: WHEN FND_API.g_exc_unexpected_error THEN
2116: x_return_status := FND_API.g_ret_sts_unexp_error;
2117: WHEN OTHERS THEN
2118: x_return_status := FND_API.g_ret_sts_unexp_error;
2119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2121: IF g_fnd_debug = 'Y' THEN
2122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2123: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

2116: x_return_status := FND_API.g_ret_sts_unexp_error;
2117: WHEN OTHERS THEN
2118: x_return_status := FND_API.g_ret_sts_unexp_error;
2119: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2120: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2121: IF g_fnd_debug = 'Y' THEN
2122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2123: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2124: l_api_name || '.others_exception', sqlcode);

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

2137: WHEN FND_API.g_exc_unexpected_error THEN
2138: x_return_status := FND_API.g_ret_sts_unexp_error;
2139: WHEN OTHERS THEN
2140: x_return_status := FND_API.g_ret_sts_unexp_error;
2141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2143: IF g_fnd_debug = 'Y' THEN
2144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2145: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

2138: x_return_status := FND_API.g_ret_sts_unexp_error;
2139: WHEN OTHERS THEN
2140: x_return_status := FND_API.g_ret_sts_unexp_error;
2141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2143: IF g_fnd_debug = 'Y' THEN
2144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2145: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2146: l_api_name || '.others_exception', sqlcode);

Line 2341: FND_MSG_PUB.initialize;

2337:
2338: BEGIN
2339: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2340: -- initialize message list
2341: FND_MSG_PUB.initialize;
2342: END IF;
2343:
2344: -- Standard call to check for call compatibility.
2345:

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

2384: x_return_status := FND_API.g_ret_sts_unexp_error;
2385: WHEN OTHERS THEN
2386: x_return_status := FND_API.g_ret_sts_unexp_error;
2387:
2388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2389: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2390: IF g_fnd_debug = 'Y' THEN
2391: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2392: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

2385: WHEN OTHERS THEN
2386: x_return_status := FND_API.g_ret_sts_unexp_error;
2387:
2388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2389: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2390: IF g_fnd_debug = 'Y' THEN
2391: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2392: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2393: l_api_name || '.others exception' ,sqlcode);

Line 2514: FND_MSG_PUB.initialize;

2510:
2511: BEGIN
2512: -- Start standard API initialization
2513: IF FND_API.to_boolean(p_init_msg_list) THEN
2514: FND_MSG_PUB.initialize;
2515: END IF;
2516: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2517: l_api_name, g_pkg_name)
2518: THEN

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

2729: WHEN FND_API.g_exc_unexpected_error THEN
2730: x_return_status := FND_API.g_ret_sts_unexp_error;
2731: WHEN OTHERS THEN
2732: x_return_status := FND_API.g_ret_sts_unexp_error;
2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2734: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2735: IF (g_fnd_debug = 'Y') THEN
2736: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2737: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

2730: x_return_status := FND_API.g_ret_sts_unexp_error;
2731: WHEN OTHERS THEN
2732: x_return_status := FND_API.g_ret_sts_unexp_error;
2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2734: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2735: IF (g_fnd_debug = 'Y') THEN
2736: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2737: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2738: l_api_name || '.others_exception', 'Exception');

Line 2774: FND_MSG_PUB.initialize;

2770: BEGIN
2771:
2772: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2773: -- initialize message list
2774: FND_MSG_PUB.initialize;
2775: END IF;
2776:
2777: -- Standard call to check for call compatibility.
2778:

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

2950: END IF;
2951: x_return_status := FND_API.g_ret_sts_error;
2952: WHEN OTHERS THEN
2953: x_return_status := FND_API.g_ret_sts_unexp_error;
2954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2955: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2956: IF g_fnd_debug = 'Y' THEN
2957: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2958: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

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

2951: x_return_status := FND_API.g_ret_sts_error;
2952: WHEN OTHERS THEN
2953: x_return_status := FND_API.g_ret_sts_unexp_error;
2954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2955: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2956: IF g_fnd_debug = 'Y' THEN
2957: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2958: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2959: l_api_name || '.others exception' ,sqlcode);