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.29.12020000.3 $)'
15: , p_level => p_level);
16: END IF;
17: -- dbms_output.put_line(p_err_msg);

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

1885: CLOSE l_curs_rcvtxn_detail;
1886: END IF;
1887:
1888: IF SQLCODE IS NOT NULL THEN
1889: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_po_rcvtxn_intf_rec', l_progress, SQLCODE);
1890: END IF;
1891:
1892: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1893: END create_osp_po_rcvtxn_intf_rec;

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

2670: CLOSE l_curs_rcvtxn_detail;
2671: END IF;
2672:
2673: IF SQLCODE IS NOT NULL THEN
2674: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_po_rcvtxn_intf_rec', l_progress, SQLCODE);
2675: END IF;
2676:
2677: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2678: END create_po_rcvtxn_intf_rec;

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

3401: CLOSE l_curs_rcvtxn_detail;
3402: END IF;
3403:
3404: IF SQLCODE IS NOT NULL THEN
3405: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_int_shp_rcvtxn_intf_rec', l_progress, SQLCODE);
3406: END IF;
3407:
3408: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3409: END create_int_shp_rcvtxn_intf_rec;

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

3984: CLOSE l_curs_rcvtxn_detail;
3985: END IF;
3986:
3987: IF SQLCODE IS NOT NULL THEN
3988: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rma_rcvtxn_intf_rec', l_progress, SQLCODE);
3989: END IF;
3990:
3991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3992: END create_rma_rcvtxn_intf_rec;

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

4232: CLOSE l_curs_rcvtxn_detail;
4233: END IF;
4234:
4235: IF SQLCODE IS NOT NULL THEN
4236: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rpt_num_rcvtxn_intf_rec', l_progress, SQLCODE);
4237: END IF;
4238:
4239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4240: END;

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

4417: WHEN OTHERS THEN
4418: x_status := fnd_api.g_ret_sts_unexp_error;
4419:
4420: IF SQLCODE IS NOT NULL THEN
4421: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4422: END IF;
4423:
4424: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4425: END create_osp_std_rcvtxn_intf_rec;

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

4791: WHEN OTHERS THEN
4792: x_status := fnd_api.g_ret_sts_unexp_error;
4793:
4794: IF SQLCODE IS NOT NULL THEN
4795: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4796: END IF;
4797:
4798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4799: END create_std_rcvtxn_intf_rec;

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

5197: print_debug('create_std_rcpt_intf_rec: others exception thrown at progress '||l_progress,4);
5198: END IF;
5199:
5200: IF SQLCODE IS NOT NULL THEN
5201: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
5202: END IF;
5203:
5204: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5205: END create_putaway_rcvtxn_intf_rec;

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

5270: WHEN OTHERS THEN
5271: x_return_status := fnd_api.g_ret_sts_unexp_error;
5272:
5273: IF SQLCODE IS NOT NULL THEN
5274: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.update_rcv_serials_supply', l_progress, SQLCODE);
5275: END IF;
5276:
5277: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5278:

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

6506: rollback to create_rti_ss;
6507: x_return_status := fnd_api.g_ret_sts_unexp_error;
6508:
6509: IF SQLCODE IS NOT NULL THEN
6510: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
6511: END IF;
6512:
6513: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6514: END Match_putaway_rcvtxn_intf_rec ;