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.PO_DOCUMENT_CONTROL_PVT dependencies on FND_MSG_PUB

Line 85: FND_MSG_PUB.add;

81: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name
82: || '.invalid_doc_type', FALSE);
83: END IF;
84: END IF;
85: FND_MSG_PUB.add;
86: RAISE FND_API.g_exc_error;
87: END IF; --
88:
89: EXCEPTION

Line 95: FND_MSG_PUB.add;

91: --Handling deadlock with proper error message
92: WHEN RESOURCE_BUSY THEN
93: x_return_status := FND_API.g_ret_sts_error;
94: FND_MESSAGE.set_name('PO','PO_ALL_CANNOT_RESERVE_RECORD');
95: FND_MSG_PUB.add;
96: --
97: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
98: x_return_status := FND_API.g_ret_sts_error;
99: FND_MESSAGE.set_name('PO','PO_CONTROL_LOCK_FAILED');

Line 106: FND_MSG_PUB.add;

102: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
103: '.lock_failed', FALSE);
104: END IF;
105: END IF;
106: FND_MSG_PUB.add;
107: WHEN FND_API.g_exc_error THEN
108: x_return_status := FND_API.g_ret_sts_error;
109: WHEN FND_API.g_exc_unexpected_error THEN
110: x_return_status := FND_API.g_ret_sts_unexp_error;

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

109: WHEN FND_API.g_exc_unexpected_error THEN
110: x_return_status := FND_API.g_ret_sts_unexp_error;
111: WHEN OTHERS THEN
112: x_return_status := FND_API.g_ret_sts_unexp_error;
113: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
114: IF (g_debug_unexp) THEN
115: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
116: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
117: l_api_name || '.others_exception', 'Exception');

Line 344: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

340:
341:
342: EXCEPTION
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346:
347:
348: WHEN FND_API.G_EXC_ERROR THEN

Line 350: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

346:
347:
348: WHEN FND_API.G_EXC_ERROR THEN
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
351:
352:
353: WHEN OTHERS THEN
354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

350: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
351:
352:
353: WHEN OTHERS THEN
354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356:
357:
358: END do_approve_on_cancel;

Line 364: -- FND_MSG_PUB has been initialized if p_init_msg_list is false.

360: ---------------------------------------------------------------------------
361: --Start of Comments
362: --Name: control_document
363: --Pre-reqs:
364: -- FND_MSG_PUB has been initialized if p_init_msg_list is false.
365: --Modifies:
366: -- All columns related to the control action, and WHO columns.
367: -- PO_ONLINE_REPORT_TEXT.
368: -- FND_MSG_PUB.

Line 368: -- FND_MSG_PUB.

364: -- FND_MSG_PUB has been initialized if p_init_msg_list is false.
365: --Modifies:
366: -- All columns related to the control action, and WHO columns.
367: -- PO_ONLINE_REPORT_TEXT.
368: -- FND_MSG_PUB.
369: --Locks:
370: -- Document at header level, and at entity level(s) specified.
371: --Function:
372: -- Performs the control action p_action on the specified document. Currently,

Line 380: -- p_commit is FND_API.G_TRUE. Appends to FND_MSG_PUB message list on error

376: -- p_doc_line_loc_id are not NULL. Executes at line level if only p_doc_id
377: -- and p_doc_line_id are not NULL. Executes at header level if only p_doc_id
378: -- is not NULL. The document will be printed if it is a PO, PA, or RELEASE,
379: -- and the p_print_flag is 'Y'. All changes will be committed upon success if
380: -- p_commit is FND_API.G_TRUE. Appends to FND_MSG_PUB message list on error
381: --Parameters:
382: --IN:
383: --p_api_version
384: --p_init_msg_list

Line 464: FND_MSG_PUB.initialize;

460: BEGIN
461: -- Start standard API initialization
462: SAVEPOINT control_document_PVT;
463: IF FND_API.to_boolean(p_init_msg_list) THEN
464: FND_MSG_PUB.initialize;
465: END IF;
466: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
467: l_api_name, g_pkg_name)
468: THEN

Line 683: FND_MSG_PUB.add;

679: PO_DEBUG.debug_stmt(d_module,l_progress,'invalid_action');
680: END IF;
681: END IF;
682:
683: FND_MSG_PUB.add;
684: RAISE FND_API.g_exc_error;
685:
686: END IF; --
687:

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

732: x_return_status := FND_API.g_ret_sts_unexp_error;
733: WHEN OTHERS THEN
734: ROLLBACK TO control_document_PVT;
735: x_return_status := FND_API.g_ret_sts_unexp_error;
736: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
737: IF (g_debug_unexp) THEN
738: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
739: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
740: l_api_name || '.others_exception', 'Exception');

Line 780: FND_MSG_PUB.initialize;

776:
777: BEGIN
778: -- Start standard API initialization
779: IF FND_API.to_boolean(p_init_msg_list) THEN
780: FND_MSG_PUB.initialize;
781: END IF;
782: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
783: l_api_name, g_pkg_name)
784: THEN

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

847: WHEN FND_API.g_exc_unexpected_error THEN
848: x_return_status := FND_API.g_ret_sts_unexp_error;
849: WHEN OTHERS THEN
850: x_return_status := FND_API.g_ret_sts_unexp_error;
851: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
852: IF (g_debug_unexp) THEN
853: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
854: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
855: l_api_name || '.others_exception', 'Exception');

Line 894: FND_MSG_PUB.initialize;

890:
891: BEGIN
892: -- Start standard API initialization
893: IF FND_API.to_boolean(p_init_msg_list) THEN
894: FND_MSG_PUB.initialize;
895: END IF;
896: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
897: l_api_name, g_pkg_name)
898: THEN

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

956: x_return_status := FND_API.g_ret_sts_unexp_error;
957: x_action_date := TRUNC(SYSDATE);
958: WHEN OTHERS THEN
959: x_return_status := FND_API.g_ret_sts_unexp_error;
960: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
961: IF (g_debug_unexp) THEN
962: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
963: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
964: l_api_name || '.others_exception', 'Exception');

Line 1006: FND_MSG_PUB.initialize;

1002:
1003: BEGIN
1004: -- Start standard API initialization
1005: IF FND_API.to_boolean(p_init_msg_list) THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
1009: l_api_name, g_pkg_name)
1010: THEN

Line 1050: FND_MSG_PUB.add;

1046: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
1047: l_api_name || '.gl_period', FALSE);
1048: END IF;
1049: END IF;
1050: FND_MSG_PUB.add;
1051: RAISE FND_API.g_exc_error;
1052: END IF; -- if not in_open_gl_period ...
1053:
1054: END IF; -- if p_doc_type ...

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

1100: WHEN FND_API.g_exc_unexpected_error THEN
1101: x_return_status := FND_API.g_ret_sts_unexp_error;
1102: WHEN OTHERS THEN
1103: x_return_status := FND_API.g_ret_sts_unexp_error;
1104: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1105: IF (g_debug_unexp) THEN
1106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1107: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1108: l_api_name || '.others_exception', 'Exception');

Line 1120: -- FND_MSG_PUB

1116: --Name: get_header_actions
1117: --Pre-reqs:
1118: -- None.
1119: --Modifies:
1120: -- FND_MSG_PUB
1121: --Locks:
1122: -- None.
1123: --Function:
1124: -- Retrieves all allowable control actions that p_agent_id can perform on the

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

1321: x_return_status := FND_API.g_ret_sts_unexp_error;
1322: IF l_get_actions_csr%ISOPEN THEN
1323: CLOSE l_get_actions_csr;
1324: END IF;
1325: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1326: IF (g_debug_unexp) THEN
1327: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1328: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1329: l_api_name || '.others_exception', 'Exception');

Line 1342: -- FND_MSG_PUB

1338: --Name: get_line_actions
1339: --Pre-reqs:
1340: -- None.
1341: --Modifies:
1342: -- FND_MSG_PUB
1343: --Locks:
1344: -- None.
1345: --Function:
1346: -- Retrieves all allowable control actions that p_agent_id can perform on the

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

1520: x_return_status := FND_API.g_ret_sts_unexp_error;
1521: IF l_get_actions_csr%ISOPEN THEN
1522: CLOSE l_get_actions_csr;
1523: END IF;
1524: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1525: IF (g_debug_unexp) THEN
1526: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1527: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1528: l_api_name || '.others_exception', 'Exception');

Line 1541: -- FND_MSG_PUB

1537: --Name: get_shipment_actions
1538: --Pre-reqs:
1539: -- None.
1540: --Modifies:
1541: -- FND_MSG_PUB
1542: --Locks:
1543: -- None.
1544: --Function:
1545: -- Retrieves all allowable control actions that p_agent_id can perform on the

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

1741: x_return_status := FND_API.g_ret_sts_unexp_error;
1742: IF l_get_actions_csr%ISOPEN THEN
1743: CLOSE l_get_actions_csr;
1744: END IF;
1745: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1746: IF (g_debug_unexp) THEN
1747: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1748: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1749: l_api_name || '.others_exception', 'Exception');

Line 1762: -- FND_MSG_PUB

1758: --Name: get_rel_header_actions
1759: --Pre-reqs:
1760: -- None.
1761: --Modifies:
1762: -- FND_MSG_PUB
1763: --Locks:
1764: -- None.
1765: --Function:
1766: -- Retrieves all allowable control actions that p_agent_id can perform on the

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

1941: x_return_status := FND_API.g_ret_sts_unexp_error;
1942: IF l_get_actions_csr%ISOPEN THEN
1943: CLOSE l_get_actions_csr;
1944: END IF;
1945: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1946: IF (g_debug_unexp) THEN
1947: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1948: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1949: l_api_name || '.others_exception', 'Exception');

Line 1962: -- FND_MSG_PUB

1958: --Name: get_rel_shipment_actions
1959: --Pre-reqs:
1960: -- None.
1961: --Modifies:
1962: -- FND_MSG_PUB
1963: --Locks:
1964: -- None.
1965: --Function:
1966: -- Retrieves all allowable control actions that p_agent_id can perform on the

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

2111: x_return_status := FND_API.g_ret_sts_unexp_error;
2112: IF l_get_actions_csr%ISOPEN THEN
2113: CLOSE l_get_actions_csr;
2114: END IF;
2115: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2116: IF (g_debug_unexp) THEN
2117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2118: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2119: l_api_name || '.others_exception', 'Exception');

Line 2178: FND_MSG_PUB.initialize;

2174:
2175: BEGIN
2176: -- Start standard API initialization
2177: IF FND_API.to_boolean(p_init_msg_list) THEN
2178: FND_MSG_PUB.initialize;
2179: END IF;
2180: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2181: l_api_name, g_pkg_name)
2182: THEN

Line 2217: FND_MSG_PUB.add;

2213:
2214: -- If the current entity: Header/Line/Shipent changed, return error
2215: IF l_current_entity_changed = 'Y' THEN
2216: FND_MESSAGE.set_name('PO','PO_CHANGED_CANT_CANCEL');
2217: FND_MSG_PUB.add;
2218: RAISE FND_API.g_exc_error;
2219: END IF;
2220: --
2221:

Line 2262: FND_MSG_PUB.add;

2258: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2259: l_api_name || '.invalid_doc_ids', FALSE);
2260: END IF;
2261: END IF;
2262: FND_MSG_PUB.add;
2263: RAISE FND_API.g_exc_error;
2264: END IF; --
2265:
2266: ELSIF (p_doc_type IN ('PO','PA')) THEN

Line 2322: FND_MSG_PUB.add;

2318: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
2319: l_api_name || '.invalid_doc_ids', FALSE);
2320: END IF;
2321: END IF;
2322: FND_MSG_PUB.add;
2323: RAISE FND_API.g_exc_error;
2324: END IF; --
2325:
2326: ELSE

Line 2336: FND_MSG_PUB.add;

2332: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2333: '.invalid_doc_type', FALSE);
2334: END IF;
2335: END IF;
2336: FND_MSG_PUB.add;
2337: RAISE FND_API.g_exc_error;
2338: END IF; --
2339:
2340: -- Check if the get action procedure had an error

Line 2350: FND_MSG_PUB.add;

2346: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2347: '.get_action_failed', FALSE);
2348: END IF;
2349: END IF;
2350: FND_MSG_PUB.add;
2351: RAISE FND_API.g_exc_error;
2352: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
2353: RAISE FND_API.g_exc_unexpected_error;
2354: END IF;

Line 2376: FND_MSG_PUB.add;

2372: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2373: '.status_failed', FALSE);
2374: END IF;
2375: END IF;
2376: FND_MSG_PUB.add;
2377: RAISE FND_API.g_exc_error;
2378: END IF;
2379:
2380: --

Line 2411: FND_MSG_PUB.add;

2407: END IF;
2408:
2409: IF (l_timecard_exists) THEN
2410: FND_MESSAGE.set_name('PO','PO_CONTROL_OTL_INVALID_ACTION');
2411: FND_MSG_PUB.add;
2412: RAISE FND_API.g_exc_error;
2413: END IF;
2414:
2415: END IF; -- p_doc_type = 'PO'

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

2421: WHEN FND_API.g_exc_unexpected_error THEN
2422: x_return_status := FND_API.g_ret_sts_unexp_error;
2423: WHEN OTHERS THEN
2424: x_return_status := FND_API.g_ret_sts_unexp_error;
2425: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2426: IF (g_debug_unexp) THEN
2427: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2428: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2429: l_api_name || '.others_exception', 'Exception');

Line 2498: FND_MSG_PUB.initialize;

2494:
2495: BEGIN
2496: -- Start standard API initialization
2497: IF FND_API.to_boolean(p_init_msg_list) THEN
2498: FND_MSG_PUB.initialize;
2499: END IF;
2500: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2501: l_api_name, g_pkg_name)
2502: THEN

Line 2526: FND_MSG_PUB.add;

2522: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2523: '.invalid_doc_ids', FALSE);
2524: END IF;
2525: END IF;
2526: FND_MSG_PUB.add;
2527: RAISE FND_API.g_exc_error;
2528: END IF;
2529: CLOSE l_po_wf_csr;
2530:

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

2595: END IF;
2596: IF l_unapproved_releases_csr%ISOPEN THEN
2597: CLOSE l_unapproved_releases_csr;
2598: END IF;
2599: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2600: IF (g_debug_unexp) THEN
2601: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2602: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2603: l_api_name || '.others_exception', 'Exception');

Line 2641: FND_MSG_PUB.initialize;

2637:
2638: BEGIN
2639: -- Start standard API initialization
2640: IF FND_API.to_boolean(p_init_msg_list) THEN
2641: FND_MSG_PUB.initialize;
2642: END IF;
2643: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
2644: l_api_name, g_pkg_name)
2645: THEN

Line 2669: FND_MSG_PUB.add;

2665: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2666: '.invalid_doc_ids', FALSE);
2667: END IF;
2668: END IF;
2669: FND_MSG_PUB.add;
2670: RAISE FND_API.g_exc_error;
2671: END IF;
2672: CLOSE l_rel_wf_csr;
2673:

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

2694: x_return_status := FND_API.g_ret_sts_unexp_error;
2695: IF l_rel_wf_csr%ISOPEN THEN
2696: CLOSE l_rel_wf_csr;
2697: END IF;
2698: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2699: IF (g_debug_unexp) THEN
2700: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2701: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2702: l_api_name || '.others_exception', 'Exception');

Line 2794: FND_MSG_PUB.add;

2790: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2791: '.request_failed', FALSE);
2792: END IF;
2793: END IF;
2794: FND_MSG_PUB.add;
2795: RAISE FND_API.g_exc_error;
2796: END IF;
2797:
2798: EXCEPTION

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

2801: WHEN FND_API.g_exc_unexpected_error THEN
2802: x_return_status := FND_API.g_ret_sts_unexp_error;
2803: WHEN OTHERS THEN
2804: x_return_status := FND_API.g_ret_sts_unexp_error;
2805: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2806: IF (g_debug_unexp) THEN
2807: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2808: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2809: l_api_name || '.others_exception', 'Exception');

Line 2904: FND_MSG_PUB.add;

2900: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
2901: '.request_failed', FALSE);
2902: END IF;
2903: END IF;
2904: FND_MSG_PUB.add;
2905: RAISE FND_API.g_exc_error;
2906: END IF;
2907:
2908: EXCEPTION

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

2911: WHEN FND_API.g_exc_unexpected_error THEN
2912: x_return_status := FND_API.g_ret_sts_unexp_error;
2913: WHEN OTHERS THEN
2914: x_return_status := FND_API.g_ret_sts_unexp_error;
2915: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2916: IF (g_debug_unexp) THEN
2917: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
2918: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
2919: l_api_name || '.others_exception', 'Exception');

Line 3008: FND_MSG_PUB.add;

3004: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3005: '.request_failed', FALSE);
3006: END IF;
3007: END IF;
3008: FND_MSG_PUB.add;
3009: RAISE FND_API.g_exc_error;
3010: END IF;
3011:
3012: EXCEPTION

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

3015: WHEN FND_API.g_exc_unexpected_error THEN
3016: x_return_status := FND_API.g_ret_sts_unexp_error;
3017: WHEN OTHERS THEN
3018: x_return_status := FND_API.g_ret_sts_unexp_error;
3019: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3020: IF (g_debug_unexp) THEN
3021: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3022: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3023: l_api_name || '.others_exception', 'Exception');

Line 3059: FND_MSG_PUB.initialize;

3055:
3056: BEGIN
3057: -- Start standard API initialization
3058: IF FND_API.to_boolean(p_init_msg_list) THEN
3059: FND_MSG_PUB.initialize;
3060: END IF;
3061: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
3062: l_api_name, g_pkg_name)
3063: THEN

Line 3119: FND_MSG_PUB.add;

3115: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3116: '.invalid_doc_type', FALSE);
3117: END IF;
3118: END IF;
3119: FND_MSG_PUB.add;
3120: RAISE FND_API.g_exc_error;
3121: END IF;
3122:
3123: EXCEPTION

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

3126: WHEN FND_API.g_exc_unexpected_error THEN
3127: x_return_status := FND_API.g_ret_sts_unexp_error;
3128: WHEN OTHERS THEN
3129: x_return_status := FND_API.g_ret_sts_unexp_error;
3130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3131: IF (g_debug_unexp) THEN
3132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3133: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3134: l_api_name || '.others_exception', 'Exception');

Line 3173: FND_MSG_PUB.initialize;

3169: BEGIN
3170: -- Start standard API initialization
3171: SAVEPOINT update_note_to_vendor_PVT;
3172: IF FND_API.to_boolean(p_init_msg_list) THEN
3173: FND_MSG_PUB.initialize;
3174: END IF;
3175: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
3176: l_api_name, g_pkg_name)
3177: THEN

Line 3210: FND_MSG_PUB.add;

3206: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3207: '.invalid_document', FALSE);
3208: END IF;
3209: END IF;
3210: FND_MSG_PUB.add;
3211: RAISE FND_API.g_exc_error;
3212: END IF;
3213: --
3214:

Line 3242: FND_MSG_PUB.add;

3238: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3239: '.invalid_document', FALSE);
3240: END IF;
3241: END IF;
3242: FND_MSG_PUB.add;
3243: RAISE FND_API.g_exc_error;
3244: END IF;
3245: --
3246:

Line 3274: FND_MSG_PUB.add;

3270: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3271: '.invalid_document', FALSE);
3272: END IF;
3273: END IF;
3274: FND_MSG_PUB.add;
3275: RAISE FND_API.g_exc_error;
3276: END IF;
3277: --
3278:

Line 3298: FND_MSG_PUB.add;

3294: FND_LOG.message(FND_LOG.level_error, g_module_prefix||l_api_name||
3295: '.invalid_doc_type', FALSE);
3296: END IF;
3297: END IF;
3298: FND_MSG_PUB.add;
3299: RAISE FND_API.g_exc_error;
3300:
3301: END IF; --
3302:

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

3313: x_return_status := FND_API.g_ret_sts_unexp_error;
3314: WHEN OTHERS THEN
3315: ROLLBACK TO update_note_to_vendor_PVT;
3316: x_return_status := FND_API.g_ret_sts_unexp_error;
3317: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3318: IF (g_debug_unexp) THEN
3319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3320: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3321: l_api_name || '.others_exception', 'Exception');

Line 3358: FND_MSG_PUB.initialize;

3354:
3355: BEGIN
3356: -- Start standard API initialization
3357: IF FND_API.to_boolean(p_init_msg_list) THEN
3358: FND_MSG_PUB.initialize;
3359: END IF;
3360: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
3361: l_api_name, g_pkg_name)
3362: THEN

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

3402: x_return_status := FND_API.g_ret_sts_unexp_error;
3403: RETURN FALSE;
3404: WHEN OTHERS THEN
3405: x_return_status := FND_API.g_ret_sts_unexp_error;
3406: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3407: IF (g_debug_unexp) THEN
3408: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3409: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3410: l_api_name || '.others_exception', 'Exception');

Line 3467: FND_MSG_PUB.initialize;

3463:
3464: BEGIN
3465: -- Start standard API initialization
3466: IF FND_API.to_boolean(p_init_msg_list) THEN
3467: FND_MSG_PUB.initialize;
3468: END IF;
3469: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
3470: l_api_name, g_pkg_name)
3471: THEN

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

3518: END IF;
3519: IF l_has_rel_ship_csr%ISOPEN THEN
3520: CLOSE l_has_rel_ship_csr;
3521: END IF;
3522: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3523: IF (g_debug_unexp) THEN
3524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3525: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3526: l_api_name || '.others_exception', 'Exception');

Line 3563: FND_MSG_PUB.initialize;

3559:
3560: BEGIN
3561: -- Start standard API initialization
3562: IF FND_API.to_boolean(p_init_msg_list) THEN
3563: FND_MSG_PUB.initialize;
3564: END IF;
3565: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
3566: l_api_name, g_pkg_name)
3567: THEN

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

3600: x_return_status := FND_API.g_ret_sts_unexp_error;
3601: RETURN FALSE;
3602: WHEN OTHERS THEN
3603: x_return_status := FND_API.g_ret_sts_unexp_error;
3604: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3605: IF (g_debug_unexp) THEN
3606: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3607: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3608: l_api_name || '.others_exception', 'Exception');

Line 3671: FND_MSG_PUB.initialize;

3667:
3668: BEGIN
3669: -- Start standard API initialization
3670: IF FND_API.to_boolean(p_init_msg_list) THEN
3671: FND_MSG_PUB.initialize;
3672: END IF;
3673: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
3674: l_api_name, g_pkg_name)
3675: THEN

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

3710: x_return_status := FND_API.g_ret_sts_unexp_error;
3711: IF l_gl_period_csr%ISOPEN THEN
3712: CLOSE l_gl_period_csr;
3713: END IF;
3714: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3715: IF (g_debug_unexp) THEN
3716: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3717: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3718: l_api_name || '.others_exception', 'Exception');

Line 3757: FND_MSG_PUB.initialize;

3753:
3754: BEGIN
3755: -- Start standard API initialization
3756: IF FND_API.to_boolean(p_init_msg_list) THEN
3757: FND_MSG_PUB.initialize;
3758: END IF;
3759: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
3760: l_api_name, g_pkg_name)
3761: THEN

Line 3789: FND_MSG_PUB.add;

3785: FND_LOG.message(FND_LOG.level_error, g_module_prefix ||
3786: l_api_name || '.msg', FALSE);
3787: END IF;
3788: END IF;
3789: FND_MSG_PUB.add;
3790: END LOOP; --
3791:
3792: EXIT WHEN l_get_online_report_csr%NOTFOUND;
3793: END LOOP;

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

3801: WHEN FND_API.g_exc_unexpected_error THEN
3802: x_return_status := FND_API.g_ret_sts_unexp_error;
3803: WHEN OTHERS THEN
3804: x_return_status := FND_API.g_ret_sts_unexp_error;
3805: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3806: IF (g_debug_unexp) THEN
3807: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3808: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
3809: l_api_name || '.others_exception', 'Exception');

Line 3820: -- FND_MSG_PUB.

3816: --Name: Val_Cancel_FinalClose_Action
3817: --Pre-reqs:
3818: -- None.
3819: --Modifies:
3820: -- FND_MSG_PUB.
3821: --Locks:
3822: -- None.
3823: --Function:
3824: -- This procedure would be responsible for validating the control action

Line 3914: FND_MSG_PUB.add;

3910: END IF;
3911: d_pos := 80;
3912: IF (l_timecard_exists) THEN
3913: FND_MESSAGE.set_name('PO','PO_CONTROL_OTL_INVALID_ACTION');
3914: FND_MSG_PUB.add;
3915: IF PO_LOG.d_exc THEN
3916: PO_LOG.exc(d_module,d_pos,'Document with timecard cannot be Cancelled or Finally Closed');
3917: END IF;
3918: RAISE FND_API.G_EXC_ERROR;

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

3926: WHEN FND_API.g_exc_error THEN
3927: x_return_status := FND_API.g_ret_sts_error;
3928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3930: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3931: IF PO_LOG.d_exc THEN
3932: PO_LOG.exc(d_module,d_pos,'Unexpected Error in ' || d_module);
3933: END IF;
3934: WHEN OTHERS THEN

Line 3936: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

3932: PO_LOG.exc(d_module,d_pos,'Unexpected Error in ' || d_module);
3933: END IF;
3934: WHEN OTHERS THEN
3935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3936: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
3937: IF PO_LOG.d_exc THEN
3938: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
3939: END IF;
3940: END Val_Cancel_FinalClose_Action;

Line 4323: FND_MSG_PUB.add;

4319: IF (l_return_code = 'STATE_FAILED') THEN
4320: d_pos := 210;
4321: -- The document state was not valid for this control action
4322: FND_MESSAGE.set_name('PO','PO_APP_APP_FAILED');
4323: FND_MSG_PUB.add;
4324: RAISE FND_API.g_exc_error;
4325: ELSIF (l_return_code = 'SUBMISSION_FAILED') THEN
4326: d_pos := 220;
4327: -- Submission check failed for final close action

Line 4332: FND_MSG_PUB.add;

4328: IF l_online_report_id IS NULL THEN
4329: FND_MESSAGE.set_name('PO','PO_CONTROL_USER_EXIT_FAILED');
4330: FND_MESSAGE.set_token('USER_EXIT', l_control_action_disp_name);
4331: FND_MESSAGE.set_token('RETURN_CODE',NVL(l_return_code, fnd_message.get_string('PO','PO_ERROR')));
4332: FND_MSG_PUB.add;
4333: ELSE
4334: d_pos := 230;
4335: --Add all the messages to the message list
4336: PO_Document_Control_PVT.add_online_report_msgs(

Line 4383: IF FND_MSG_PUB.count_msg = 0 THEN

4379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4380: x_return_status := FND_API.g_ret_sts_unexp_error;
4381: IF PO_LOG.d_exc THEN
4382: PO_LOG.exc(d_module,d_pos,'Unexpected Error in ' || d_module);
4383: IF FND_MSG_PUB.count_msg = 0 THEN
4384: FND_MESSAGE.set_name('PO','PO_DOC_CONTROL_ACTION_FAILED');
4385: FND_MESSAGE.set_token('CONTROL_ACTION_NAME', l_control_action_disp_name);
4386: FND_MESSAGE.set_token('ERROR_TEXT',l_exc_msg);
4387: FND_MSG_PUB.add;

Line 4387: FND_MSG_PUB.add;

4383: IF FND_MSG_PUB.count_msg = 0 THEN
4384: FND_MESSAGE.set_name('PO','PO_DOC_CONTROL_ACTION_FAILED');
4385: FND_MESSAGE.set_token('CONTROL_ACTION_NAME', l_control_action_disp_name);
4386: FND_MESSAGE.set_token('ERROR_TEXT',l_exc_msg);
4387: FND_MSG_PUB.add;
4388: END IF;
4389: END IF;
4390: WHEN OTHERS THEN
4391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4392: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

4388: END IF;
4389: END IF;
4390: WHEN OTHERS THEN
4391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4392: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4393: IF PO_LOG.d_exc THEN
4394: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4395: END IF;
4396: END do_control_action;

Line 4630: FOR i IN 1..FND_MSG_PUB.count_msg LOOP

4626: ROLLBACK TO SAVEPOINT PROCESS_DOC_CONTROL_ACTION;
4627: x_return_status := FND_API.g_ret_sts_error;
4628: x_error_msg_tbl := PO_TBL_VARCHAR2000();
4629: --Copy the messages on the list to the out parameter
4630: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
4631: FND_MESSAGE.set_encoded(encoded_message => FND_MSG_PUB.get(p_msg_index => i));
4632: x_error_msg_tbl.extend;
4633: x_error_msg_tbl(i) := FND_MESSAGE.get;
4634: END LOOP;

Line 4631: FND_MESSAGE.set_encoded(encoded_message => FND_MSG_PUB.get(p_msg_index => i));

4627: x_return_status := FND_API.g_ret_sts_error;
4628: x_error_msg_tbl := PO_TBL_VARCHAR2000();
4629: --Copy the messages on the list to the out parameter
4630: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
4631: FND_MESSAGE.set_encoded(encoded_message => FND_MSG_PUB.get(p_msg_index => i));
4632: x_error_msg_tbl.extend;
4633: x_error_msg_tbl(i) := FND_MESSAGE.get;
4634: END LOOP;
4635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4644: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

4640: END IF;
4641: WHEN OTHERS THEN
4642: ROLLBACK TO SAVEPOINT PROCESS_DOC_CONTROL_ACTION;
4643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4644: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4645: IF PO_LOG.d_exc THEN
4646: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4647: END IF;
4648: END process_doc_control_action;

Line 4766: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

4762:
4763: return (l_has_labor_expense_req);
4764: EXCEPTION
4765: WHEN OTHERS THEN
4766: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4767: IF PO_LOG.d_exc THEN
4768: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4769: END IF;
4770: RAISE;

Line 4905: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

4901: PO_LOG.stmt(d_module,d_pos,'Early exit from ' || d_module);
4902: END IF;
4903: WHEN OTHERS THEN
4904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4905: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
4906: IF PO_LOG.d_exc THEN
4907: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
4908: END IF;
4909: END get_cancel_req_chkbox_attr;

Line 5176: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

5172: END IF;
5173: EXCEPTION
5174: WHEN OTHERS THEN
5175: x_return_status := FND_API.g_ret_sts_unexp_error;
5176: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
5177: IF PO_LOG.d_exc THEN
5178: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
5179: END IF;
5180: END get_valid_control_actions;

Line 5354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5350: END IF;
5351:
5352: EXCEPTION
5353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5354: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5356:
5357:
5358: WHEN FND_API.G_EXC_ERROR THEN

Line 5360: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5356:
5357:
5358: WHEN FND_API.G_EXC_ERROR THEN
5359: x_return_status := FND_API.G_RET_STS_ERROR;
5360: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5361:
5362:
5363: WHEN OTHERS THEN
5364: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5364: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5360: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5361:
5362:
5363: WHEN OTHERS THEN
5364: FND_MSG_PUB.add_exc_msg(g_module_prefix, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5366:
5367:
5368: END doc_communicate_oncancel;