DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on INV_MOBILE_HELPER_FUNCTIONS

Line 14: inv_mobile_helper_functions.tracelog(

10: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER DEFAULT 4) IS
11: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12: BEGIN
13: IF (l_debug = 1) THEN
14: inv_mobile_helper_functions.tracelog(
15: p_err_msg => p_err_msg
16: , p_module => 'INV_RCV_STD_RCPT_APIS'
17: , p_level => p_level);
18: END IF;

Line 2427: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_po_rcpt_intf_rec', l_progress, SQLCODE);

2423: CLOSE l_curs_rcpt_detail;
2424: END IF;
2425:
2426: IF SQLCODE IS NOT NULL THEN
2427: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_po_rcpt_intf_rec', l_progress, SQLCODE);
2428: END IF;
2429:
2430: fnd_msg_pub.count_and_get(
2431: p_encoded => fnd_api.g_false

Line 3122: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_intship_rcpt_intf_rec', l_progress, SQLCODE);

3118: CLOSE l_curs_rcpt_detail;
3119: END IF;
3120:
3121: IF SQLCODE IS NOT NULL THEN
3122: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_intship_rcpt_intf_rec', l_progress, SQLCODE);
3123: END IF;
3124:
3125: fnd_msg_pub.count_and_get(
3126: p_encoded => fnd_api.g_false

Line 3698: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_rma_rcpt_intf_rec', l_progress, SQLCODE);

3694: CLOSE l_curs_rcpt_detail;
3695: END IF;
3696:
3697: IF SQLCODE IS NOT NULL THEN
3698: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_rma_rcpt_intf_rec', l_progress, SQLCODE);
3699: END IF;
3700:
3701: fnd_msg_pub.count_and_get(
3702: p_encoded => fnd_api.g_false

Line 4780: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_con_rcpt_intf_rec', l_progress, SQLCODE);

4776: CLOSE l_curs_rcpt_detail;
4777: END IF;
4778:
4779: IF SQLCODE IS NOT NULL THEN
4780: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_con_rcpt_intf_rec', l_progress, SQLCODE);
4781: END IF;
4782:
4783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4784:

Line 5433: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_exp_rcpt_intf_rec', l_progress, SQLCODE);

5429: CLOSE l_curs_serial_number;
5430: END IF;
5431:
5432: IF SQLCODE IS NOT NULL THEN
5433: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_exp_rcpt_intf_rec', l_progress, SQLCODE);
5434: END IF;
5435:
5436: fnd_msg_pub.count_and_get(
5437: p_encoded => fnd_api.g_false

Line 6143: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_std_rcpt_intf_rec', l_progress, SQLCODE);

6139: IF c_rti_txn_id%ISOPEN THEN
6140: CLOSE c_rti_txn_id;
6141: END IF;
6142: IF SQLCODE IS NOT NULL THEN
6143: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_std_rcpt_intf_rec', l_progress, SQLCODE);
6144: END IF;
6145: fnd_msg_pub.count_and_get(
6146: p_encoded => fnd_api.g_false
6147: , p_count => l_msg_count

Line 6871: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_move_order', l_progress, SQLCODE);

6867: ROLLBACK TO rcv_crt_mo_sp;
6868: x_status := fnd_api.g_ret_sts_unexp_error;
6869:
6870: IF SQLCODE IS NOT NULL THEN
6871: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_move_order', l_progress, SQLCODE);
6872: END IF;
6873:
6874: fnd_msg_pub.count_and_get(
6875: p_encoded => fnd_api.g_false

Line 6990: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_rti_from_header', l_progress, SQLCODE);

6986: WHEN OTHERS THEN
6987: x_return_status := fnd_api.g_ret_sts_unexp_error;
6988:
6989: IF SQLCODE IS NOT NULL THEN
6990: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_rti_from_header', l_progress, SQLCODE);
6991: END IF;
6992:
6993: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6994: END rcv_update_rti_from_header;

Line 7268: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_insert_header_interface', l_progress, SQLCODE);

7264: ROLLBACK TO rcv_insert_ship_header_sp;
7265: x_return_status := fnd_api.g_ret_sts_unexp_error;
7266:
7267: IF SQLCODE IS NOT NULL THEN
7268: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_insert_header_interface', l_progress, SQLCODE);
7269: END IF;
7270:
7271: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7272: END rcv_insert_header_interface;

Line 7481: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_header_interface', l_progress, SQLCODE);

7477: ROLLBACK TO rcv_update_ship_header_sp;
7478: x_return_status := fnd_api.g_ret_sts_unexp_error;
7479:
7480: IF SQLCODE IS NOT NULL THEN
7481: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_header_interface', l_progress, SQLCODE);
7482: END IF;
7483:
7484: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7485: END rcv_update_header_interface;

Line 7751: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_insert_header', l_progress, SQLCODE);

7747: WHEN OTHERS THEN
7748: x_return_status := fnd_api.g_ret_sts_unexp_error;
7749:
7750: IF SQLCODE IS NOT NULL THEN
7751: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_insert_header', l_progress, SQLCODE);
7752: END IF;
7753:
7754: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7755: END rcv_insert_update_header;

Line 8096: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.packunpack_container', l_progress, SQLCODE);

8092: ROLLBACK TO rcv_pack_unpack_sp;
8093: x_return_status := fnd_api.g_ret_sts_unexp_error;
8094:
8095: IF SQLCODE IS NOT NULL THEN
8096: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.packunpack_container', l_progress, SQLCODE);
8097: END IF;
8098:
8099: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8100: END packunpack_container;

Line 8225: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.detect_ASN_discrepancy', l_progress, SQLCODE);

8221:
8222: x_return_status := fnd_api.g_ret_sts_unexp_error;
8223:
8224: IF SQLCODE IS NOT NULL THEN
8225: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.detect_ASN_discrepancy', l_progress, SQLCODE);
8226: END IF;
8227:
8228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8229: END detect_asn_discrepancy;

Line 8279: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.remove_lpn_contents', l_progress, SQLCODE);

8275: ROLLBACK TO rcv_remove_lpn_cont_sp;
8276: x_return_status := fnd_api.g_ret_sts_unexp_error;
8277:
8278: IF SQLCODE IS NOT NULL THEN
8279: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.remove_lpn_contents', l_progress, SQLCODE);
8280: END IF;
8281:
8282: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8283: END remove_lpn_contents;

Line 8535: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.clear_LPN_for_ship', l_progress, SQLCODE);

8531:
8532: x_return_status := fnd_api.g_ret_sts_unexp_error;
8533:
8534: IF SQLCODE IS NOT NULL THEN
8535: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.clear_LPN_for_ship', l_progress, SQLCODE);
8536: END IF;
8537:
8538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8539: END clear_lpn_for_ship;

Line 8633: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_shipment', l_progress, SQLCODE);

8629: WHEN OTHERS THEN
8630: x_return_status := fnd_api.g_ret_sts_unexp_error;
8631:
8632: IF SQLCODE IS NOT NULL THEN
8633: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_shipment', l_progress, SQLCODE);
8634: END IF;
8635:
8636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8637: END check_lpn_on_shipment;

Line 8725: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_ASN', l_progress, SQLCODE);

8721: WHEN OTHERS THEN
8722: x_return_status := fnd_api.g_ret_sts_unexp_error;
8723:
8724: IF SQLCODE IS NOT NULL THEN
8725: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_ASN', l_progress, SQLCODE);
8726: END IF;
8727:
8728: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8729: END check_lpn_on_asn;

Line 8940: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_REQ', l_progress, SQLCODE);

8936:
8937: x_return_status := fnd_api.g_ret_sts_unexp_error;
8938:
8939: IF SQLCODE IS NOT NULL THEN
8940: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_REQ', l_progress, SQLCODE);
8941: END IF;
8942:
8943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8944: END;

Line 9077: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.update_LPN_Org', l_progress, SQLCODE);

9073: ROLLBACK TO rcv_update_lpn_org_sp;
9074: x_return_status := fnd_api.g_ret_sts_unexp_error;
9075:
9076: IF SQLCODE IS NOT NULL THEN
9077: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.update_LPN_Org', l_progress, SQLCODE);
9078: END IF;
9079:
9080: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
9081: END update_lpn_org;