DBA Data[Home] [Help]

APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_MESSAGE_S

Line 843: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

839:
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;

Line 950: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

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
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;

Line 1318: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

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
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;

Line 1518: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

1514: EXCEPTION
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;

Line 1839: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

1835: EXCEPTION
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;

Line 1991: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

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
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;

Line 2324: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

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
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;

Line 2437: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

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
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;

Line 2523: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

2519: EXCEPTION
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;

Line 3438: po_message_s.sql_error(g_pkg_name,l_api_name,l_progress,SQLCODE,SQLERRM);

3434: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
3435: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
3436: ELSE -- no exception code
3437: -- log a debug msg if necessary and set the dictionary message
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;

Line 3785: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

3781:
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:

Line 3982: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

3978: END IF;
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;

Line 4303: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

4299: RAISE;
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;

Line 4845: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);

4841: EXCEPTION
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;

Line 5087: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

5083: RAISE;
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;

Line 5261: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

5257: RAISE;
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;

Line 5593: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

5589: RAISE;
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;

Line 6074: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

6070: RAISE;
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;

Line 6479: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

6475: RAISE;
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;

Line 6733: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

6729: RAISE;
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;

Line 6986: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

6982: RAISE;
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;

Line 7154: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);

7150: EXCEPTION
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;

Line 7316: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

7312: RAISE;
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;

Line 7483: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);

7479:
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: --

Line 7883: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

7879: RAISE;
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;

Line 8044: po_message_s.sql_error(g_pkg_name,l_proc_name,l_progress,SQLCODE,SQLERRM);

8040: END IF;
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;

Line 8207: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, '000', 'Invalid Action');

8203: WHERE DISTS.prevent_encumbrance_flag = 'N';
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';

Line 8371: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

8367: RAISE;
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;

Line 8409: po_message_s.sql_error(g_pkg_name,l_proc_name,l_progress,SQLCODE,SQLERRM);

8405: PO_DEBUG.debug_end(l_log_head);
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:

Line 8594: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

8590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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: /* <> */