DBA Data[Home] [Help]

APPS.INV_RCV_STD_DELIVER_APIS dependencies on INV_MOBILE_HELPER_FUNCTIONS

Line 13: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg

9: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
10: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
11: BEGIN
12: IF (l_debug = 1) THEN
13: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg
14: , p_module => g_pkg_name||'($Revision: 120.17.12010000.4 $)'
15: , p_level => p_level);
16: END IF;
17: -- dbms_output.put_line(p_err_msg);

Line 1855: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_po_rcvtxn_intf_rec', l_progress, SQLCODE);

1851: CLOSE l_curs_rcvtxn_detail;
1852: END IF;
1853:
1854: IF SQLCODE IS NOT NULL THEN
1855: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_po_rcvtxn_intf_rec', l_progress, SQLCODE);
1856: END IF;
1857:
1858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1859: END create_osp_po_rcvtxn_intf_rec;

Line 2640: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_po_rcvtxn_intf_rec', l_progress, SQLCODE);

2636: CLOSE l_curs_rcvtxn_detail;
2637: END IF;
2638:
2639: IF SQLCODE IS NOT NULL THEN
2640: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_po_rcvtxn_intf_rec', l_progress, SQLCODE);
2641: END IF;
2642:
2643: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2644: END create_po_rcvtxn_intf_rec;

Line 3309: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_int_shp_rcvtxn_intf_rec', l_progress, SQLCODE);

3305: CLOSE l_curs_rcvtxn_detail;
3306: END IF;
3307:
3308: IF SQLCODE IS NOT NULL THEN
3309: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_int_shp_rcvtxn_intf_rec', l_progress, SQLCODE);
3310: END IF;
3311:
3312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3313: END create_int_shp_rcvtxn_intf_rec;

Line 3874: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rma_rcvtxn_intf_rec', l_progress, SQLCODE);

3870: CLOSE l_curs_rcvtxn_detail;
3871: END IF;
3872:
3873: IF SQLCODE IS NOT NULL THEN
3874: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rma_rcvtxn_intf_rec', l_progress, SQLCODE);
3875: END IF;
3876:
3877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3878: END create_rma_rcvtxn_intf_rec;

Line 4120: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rpt_num_rcvtxn_intf_rec', l_progress, SQLCODE);

4116: CLOSE l_curs_rcvtxn_detail;
4117: END IF;
4118:
4119: IF SQLCODE IS NOT NULL THEN
4120: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rpt_num_rcvtxn_intf_rec', l_progress, SQLCODE);
4121: END IF;
4122:
4123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4124: END;

Line 4305: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_std_rcvtxn_intf_rec', l_progress, SQLCODE);

4301: WHEN OTHERS THEN
4302: x_status := fnd_api.g_ret_sts_unexp_error;
4303:
4304: IF SQLCODE IS NOT NULL THEN
4305: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4306: END IF;
4307:
4308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4309: END create_osp_std_rcvtxn_intf_rec;

Line 4677: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);

4673: WHEN OTHERS THEN
4674: x_status := fnd_api.g_ret_sts_unexp_error;
4675:
4676: IF SQLCODE IS NOT NULL THEN
4677: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4678: END IF;
4679:
4680: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4681: END create_std_rcvtxn_intf_rec;

Line 5079: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);

5075: print_debug('create_std_rcpt_intf_rec: others exception thrown at progress '||l_progress,4);
5076: END IF;
5077:
5078: IF SQLCODE IS NOT NULL THEN
5079: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
5080: END IF;
5081:
5082: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5083: END create_putaway_rcvtxn_intf_rec;

Line 5152: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.update_rcv_serials_supply', l_progress, SQLCODE);

5148: WHEN OTHERS THEN
5149: x_return_status := fnd_api.g_ret_sts_unexp_error;
5150:
5151: IF SQLCODE IS NOT NULL THEN
5152: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.update_rcv_serials_supply', l_progress, SQLCODE);
5153: END IF;
5154:
5155: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5156:

Line 6367: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);

6363: rollback to create_rti_ss;
6364: x_return_status := fnd_api.g_ret_sts_unexp_error;
6365:
6366: IF SQLCODE IS NOT NULL THEN
6367: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
6368: END IF;
6369:
6370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6371: END Match_putaway_rcvtxn_intf_rec ;