840: EXCEPTION
841: WHEN OTHERS THEN
842: --add message to the stack and log a debug msg if necessary
843: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
844: fnd_msg_pub.add;
845: RAISE;
846:
847: END get_all_distributions;
848:
941: END IF;
942: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
943: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
944: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
945: fnd_msg_pub.add;
946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947:
948: WHEN OTHERS THEN
949: --add message to the stack and log a debug msg if necessary
947:
948: WHEN OTHERS THEN
949: --add message to the stack and log a debug msg if necessary
950: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
951: fnd_msg_pub.add;
952: RAISE;
953:
954: END initialize_encumbrance_gt;
955:
1309: END IF;
1310: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
1311: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
1312: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
1313: fnd_msg_pub.add;
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315:
1316: WHEN OTHERS THEN
1317: --add message to the stack and log a debug msg if necessary
1315:
1316: WHEN OTHERS THEN
1317: --add message to the stack and log a debug msg if necessary
1318: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
1319: fnd_msg_pub.add;
1320: RAISE;
1321:
1322: END get_distributions;
1323:
1515:
1516: WHEN OTHERS THEN
1517: --add message to the stack and log a debug msg if necessary
1518: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
1519: fnd_msg_pub.add;
1520: RAISE;
1521:
1522: END remove_unnecessary_dists;
1523:
1836:
1837: WHEN OTHERS THEN
1838: --add message to the stack and log a debug msg if necessary
1839: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
1840: fnd_msg_pub.add;
1841: RAISE;
1842:
1843: END update_encumbrance_gt;
1844:
1982: END IF;
1983: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
1984: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
1985: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
1986: fnd_msg_pub.add;
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988:
1989: WHEN OTHERS THEN
1990: --add message to the stack and log a debug msg if necessary
1988:
1989: WHEN OTHERS THEN
1990: --add message to the stack and log a debug msg if necessary
1991: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
1992: fnd_msg_pub.add;
1993: RAISE;
1994:
1995: END lock_backing_distributions;
1996:
2315: END IF;
2316: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
2317: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
2318: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
2319: fnd_msg_pub.add;
2320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2321:
2322: WHEN OTHERS THEN
2323: --add message to the stack and log a debug msg if necessary
2321:
2322: WHEN OTHERS THEN
2323: --add message to the stack and log a debug msg if necessary
2324: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
2325: fnd_msg_pub.add;
2326: RAISE;
2327:
2328: END filter_backing_distributions;
2329:
2428: END IF;
2429: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
2430: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
2431: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
2432: fnd_msg_pub.add;
2433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2434:
2435: WHEN OTHERS THEN
2436: --add message to the stack and log a debug msg if necessary
2434:
2435: WHEN OTHERS THEN
2436: --add message to the stack and log a debug msg if necessary
2437: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
2438: fnd_msg_pub.add;
2439: RAISE;
2440:
2441: END derive_doc_types_from_dist;
2442:
2520:
2521: WHEN OTHERS THEN
2522: --add message to the stack and log a debug msg if necessary
2523: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
2524: fnd_msg_pub.add;
2525: RAISE;
2526:
2527: END derive_dist_from_doc_types;
2528:
3438: po_message_s.sql_error(g_pkg_name,l_api_name,l_progress,SQLCODE,SQLERRM);
3439: END IF;
3440:
3441: -- Add the message that was set to the API message list.
3442: FND_MSG_PUB.add;
3443:
3444: -- RAISE the exception, if necessary.
3445: IF (NVL(l_exc_code,g_INVALID_CALL_EXC_CODE) <> g_SUBMISSION_CHECK_EXC_CODE) THEN
3446: RAISE;
3782: EXCEPTION
3783: WHEN OTHERS THEN
3784: --add message to the stack and log a debug msg if necessary
3785: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
3786: fnd_msg_pub.add;
3787: x_valid_state_flag := g_doc_state_valid_NO;
3788: RAISE;
3789:
3790: END check_doc_state;
3979: --
3980: WHEN OTHERS THEN
3981: --add message to the stack and log a debug msg if necessary
3982: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
3983: fnd_msg_pub.add;
3984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3985:
3986: END derive_packet_values;
3987:
4300:
4301: WHEN OTHERS THEN
4302: --add message to the stack and log a debug msg if necessary
4303: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
4304: fnd_msg_pub.add;
4305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4306:
4307: END get_period_info;
4308:
4842:
4843: WHEN OTHERS THEN
4844: --add message to the stack and log a debug msg if necessary
4845: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);
4846: fnd_msg_pub.add;
4847: RAISE;
4848:
4849: END find_open_period;
4850:
5084:
5085: WHEN OTHERS THEN
5086: --add message to the stack and log a debug msg if necessary
5087: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
5088: fnd_msg_pub.add;
5089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5090:
5091: END get_amounts;
5092:
5258:
5259: WHEN OTHERS THEN
5260: --add message to the stack and log a debug msg if necessary
5261: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
5262: fnd_msg_pub.add;
5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5264:
5265: END get_initial_amounts;
5266:
5590:
5591: WHEN OTHERS THEN
5592: --add message to the stack and log a debug msg if necessary
5593: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
5594: fnd_msg_pub.add;
5595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5596:
5597: END get_main_doc_amts;
5598:
6071:
6072: WHEN OTHERS THEN
6073: --add message to the stack and log a debug msg if necessary
6074: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6075: fnd_msg_pub.add;
6076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6077:
6078: END get_backing_doc_amts;
6079:
6476:
6477: WHEN OTHERS THEN
6478: --add message to the stack and log a debug msg if necessary
6479: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6480: fnd_msg_pub.add;
6481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6482:
6483: END get_final_amounts;
6484:
6730:
6731: WHEN OTHERS THEN
6732: --add message to the stack and log a debug msg if necessary
6733: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6734: fnd_msg_pub.add;
6735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6736:
6737: END round_and_convert_amounts;
6738:
6983:
6984: WHEN OTHERS THEN
6985: --add message to the stack and log a debug msg if necessary
6986: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6987: fnd_msg_pub.add;
6988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6989:
6990: END check_backing_pa_amounts;
6991:
7151:
7152: WHEN OTHERS THEN
7153: --add message to the stack and log a debug msg if necessary
7154: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);
7155: fnd_msg_pub.add;
7156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7157:
7158: END correct_backing_pa_amounts;
7159:
7313:
7314: WHEN OTHERS THEN
7315: --add message to the stack and log a debug msg if necessary
7316: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
7317: fnd_msg_pub.add;
7318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7319:
7320: END set_complex_work_req_amounts;
7321:
7480: EXCEPTION
7481: WHEN OTHERS THEN
7482: --add message to the stack and log a debug msg if necessary
7483: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);
7484: fnd_msg_pub.add;
7485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7486: END correct_backing_req_amounts;
7487: --
7488:
7880:
7881: WHEN OTHERS THEN
7882: --add message to the stack and log a debug msg if necessary
7883: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
7884: fnd_msg_pub.add;
7885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7886:
7887: END get_gl_references;
7888:
8041:
8042: EXCEPTION
8043: WHEN OTHERS THEN
8044: po_message_s.sql_error(g_pkg_name,l_proc_name,l_progress,SQLCODE,SQLERRM);
8045: fnd_msg_pub.add;
8046: RAISE;
8047:
8048: END delete_encumbrance_gt;
8049:
8204: --
8205: ELSE
8206: l_progress := '050';
8207: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, '000', 'Invalid Action');
8208: fnd_msg_pub.add;
8209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8210: END IF; -- check on p_action
8211: l_progress:= '060';
8212: --
8368:
8369: WHEN OTHERS THEN
8370: --add message to the stack and log a debug msg if necessary
8371: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
8372: fnd_msg_pub.add;
8373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8374:
8375: END update_amounts;
8376: --
8406: END IF;
8407: EXCEPTION
8408: WHEN OTHERS THEN
8409: po_message_s.sql_error(g_pkg_name,l_proc_name,l_progress,SQLCODE,SQLERRM);
8410: fnd_msg_pub.add;
8411: RAISE;
8412: END UPDATE_CLM_INTIAL_AMOUNTS;
8413:
8414:
8591: RAISE;
8592: WHEN OTHERS THEN
8593: --add message to the stack and log a debug msg if necessary
8594: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
8595: fnd_msg_pub.add;
8596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8597: END UPDATE_CLM_FINAL_AMOUNTS;
8598: /* <
8599: