DBA Data[Home] [Help]

APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_MESSAGE_S

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

836:
837: EXCEPTION
838: WHEN OTHERS THEN
839: --add message to the stack and log a debug msg if necessary
840: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
841: fnd_msg_pub.add;
842: RAISE;
843:
844: END get_all_distributions;

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

943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944:
945: WHEN OTHERS THEN
946: --add message to the stack and log a debug msg if necessary
947: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
948: fnd_msg_pub.add;
949: RAISE;
950:
951: END initialize_encumbrance_gt;

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

1311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1312:
1313: WHEN OTHERS THEN
1314: --add message to the stack and log a debug msg if necessary
1315: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
1316: fnd_msg_pub.add;
1317: RAISE;
1318:
1319: END get_distributions;

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

1482: EXCEPTION
1483:
1484: WHEN OTHERS THEN
1485: --add message to the stack and log a debug msg if necessary
1486: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
1487: fnd_msg_pub.add;
1488: RAISE;
1489:
1490: END remove_unnecessary_dists;

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

1797: EXCEPTION
1798:
1799: WHEN OTHERS THEN
1800: --add message to the stack and log a debug msg if necessary
1801: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
1802: fnd_msg_pub.add;
1803: RAISE;
1804:
1805: END update_encumbrance_gt;

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

1949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1950:
1951: WHEN OTHERS THEN
1952: --add message to the stack and log a debug msg if necessary
1953: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
1954: fnd_msg_pub.add;
1955: RAISE;
1956:
1957: END lock_backing_distributions;

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

2282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2283:
2284: WHEN OTHERS THEN
2285: --add message to the stack and log a debug msg if necessary
2286: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
2287: fnd_msg_pub.add;
2288: RAISE;
2289:
2290: END filter_backing_distributions;

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

2395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2396:
2397: WHEN OTHERS THEN
2398: --add message to the stack and log a debug msg if necessary
2399: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
2400: fnd_msg_pub.add;
2401: RAISE;
2402:
2403: END derive_doc_types_from_dist;

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

2481: EXCEPTION
2482:
2483: WHEN OTHERS THEN
2484: --add message to the stack and log a debug msg if necessary
2485: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
2486: fnd_msg_pub.add;
2487: RAISE;
2488:
2489: END derive_dist_from_doc_types;

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

3392: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
3393: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
3394: ELSE -- no exception code
3395: -- log a debug msg if necessary and set the dictionary message
3396: po_message_s.sql_error(g_pkg_name,l_api_name,l_progress,SQLCODE,SQLERRM);
3397: END IF;
3398:
3399: -- Add the message that was set to the API message list.
3400: FND_MSG_PUB.add;

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

3739:
3740: EXCEPTION
3741: WHEN OTHERS THEN
3742: --add message to the stack and log a debug msg if necessary
3743: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
3744: fnd_msg_pub.add;
3745: x_valid_state_flag := g_doc_state_valid_NO;
3746: RAISE;
3747:

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

3901: RAISE;
3902:
3903: WHEN OTHERS THEN
3904: --add message to the stack and log a debug msg if necessary
3905: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
3906: fnd_msg_pub.add;
3907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3908:
3909: END derive_packet_values;

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

4222: RAISE;
4223:
4224: WHEN OTHERS THEN
4225: --add message to the stack and log a debug msg if necessary
4226: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
4227: fnd_msg_pub.add;
4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4229:
4230: END get_period_info;

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

4690: EXCEPTION
4691:
4692: WHEN OTHERS THEN
4693: --add message to the stack and log a debug msg if necessary
4694: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);
4695: fnd_msg_pub.add;
4696: RAISE;
4697:
4698: END find_open_period;

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

4929: RAISE;
4930:
4931: WHEN OTHERS THEN
4932: --add message to the stack and log a debug msg if necessary
4933: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
4934: fnd_msg_pub.add;
4935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4936:
4937: END get_amounts;

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

5103: RAISE;
5104:
5105: WHEN OTHERS THEN
5106: --add message to the stack and log a debug msg if necessary
5107: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
5108: fnd_msg_pub.add;
5109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5110:
5111: END get_initial_amounts;

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

5397: RAISE;
5398:
5399: WHEN OTHERS THEN
5400: --add message to the stack and log a debug msg if necessary
5401: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
5402: fnd_msg_pub.add;
5403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5404:
5405: END get_main_doc_amts;

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

5806: RAISE;
5807:
5808: WHEN OTHERS THEN
5809: --add message to the stack and log a debug msg if necessary
5810: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
5811: fnd_msg_pub.add;
5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5813:
5814: END get_backing_doc_amts;

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

6098: RAISE;
6099:
6100: WHEN OTHERS THEN
6101: --add message to the stack and log a debug msg if necessary
6102: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6103: fnd_msg_pub.add;
6104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6105:
6106: END get_final_amounts;

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

6331: RAISE;
6332:
6333: WHEN OTHERS THEN
6334: --add message to the stack and log a debug msg if necessary
6335: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6336: fnd_msg_pub.add;
6337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6338:
6339: END round_and_convert_amounts;

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

6584: RAISE;
6585:
6586: WHEN OTHERS THEN
6587: --add message to the stack and log a debug msg if necessary
6588: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6589: fnd_msg_pub.add;
6590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6591:
6592: END check_backing_pa_amounts;

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

6752: EXCEPTION
6753:
6754: WHEN OTHERS THEN
6755: --add message to the stack and log a debug msg if necessary
6756: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);
6757: fnd_msg_pub.add;
6758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6759:
6760: END correct_backing_pa_amounts;

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

6914: RAISE;
6915:
6916: WHEN OTHERS THEN
6917: --add message to the stack and log a debug msg if necessary
6918: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6919: fnd_msg_pub.add;
6920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6921:
6922: END set_complex_work_req_amounts;

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

7081:
7082: EXCEPTION
7083: WHEN OTHERS THEN
7084: --add message to the stack and log a debug msg if necessary
7085: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);
7086: fnd_msg_pub.add;
7087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7088: END correct_backing_req_amounts;
7089: --

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

7479: RAISE;
7480:
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_api_name, l_progress, SQLCODE, SQLERRM);
7484: fnd_msg_pub.add;
7485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7486:
7487: END get_gl_references;

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

7640: END IF;
7641:
7642: EXCEPTION
7643: WHEN OTHERS THEN
7644: po_message_s.sql_error(g_pkg_name,l_proc_name,l_progress,SQLCODE,SQLERRM);
7645: fnd_msg_pub.add;
7646: RAISE;
7647:
7648: END delete_encumbrance_gt;

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

7782: WHERE DISTS.prevent_encumbrance_flag = 'N';
7783: --
7784: ELSE
7785: l_progress := '050';
7786: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, '000', 'Invalid Action');
7787: fnd_msg_pub.add;
7788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7789: END IF; -- check on p_action
7790: l_progress:= '060';

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

7921: RAISE;
7922:
7923: WHEN OTHERS THEN
7924: --add message to the stack and log a debug msg if necessary
7925: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
7926: fnd_msg_pub.add;
7927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7928:
7929: END update_amounts;