APPS.INV_RCV_MOBILE_PROCESS_TXN dependencies on INV_RCV_MOBILE_PROCESS_TXN

Line 1: PACKAGE BODY INV_RCV_MOBILE_PROCESS_TXN AS

1: PACKAGE BODY INV_RCV_MOBILE_PROCESS_TXN AS
2: /* $Header: INVRCVPB.pls 120.8 2009/06/24 07:06:54 aditshar ship $*/
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_RCV_MOBILE_PROCESS_TXN';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_RCV_MOBILE_PROCESS_TXN';

1: PACKAGE BODY INV_RCV_MOBILE_PROCESS_TXN AS
2: /* $Header: INVRCVPB.pls 120.8 2009/06/24 07:06:54 aditshar ship $*/
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_RCV_MOBILE_PROCESS_TXN';
6:
7: PROCEDURE print_debug(p_err_msg VARCHAR2,
8: p_level NUMBER)
9: IS

Line 15: p_module => 'INV_RCV_MOBILE_PROCESS_TXN',

11: BEGIN
12: IF (l_debug = 1) THEN
13: inv_mobile_helper_functions.tracelog
14: (p_err_msg => p_err_msg,
15: p_module => 'INV_RCV_MOBILE_PROCESS_TXN',
16: p_level => p_level);
17: END IF;
18:
19: -- dbms_output.put_line(p_err_msg);

Line 444: print_debug('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request in delete rows for group_id:'

440: --where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
441:
442: /* Bug 4901912 -Deleting the errored RTIs */
443: IF (l_debug = 1) THEN
444: print_debug('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request in delete rows for group_id:'
445: || inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id,4);
446: END IF;
447:
448: delete from rcv_transactions_interface

Line 471: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request', l_progress, SQLCODE);

467: EXCEPTION
468: WHEN OTHERS THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error ;
470: IF SQLCODE IS NOT NULL THEN
471: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request', l_progress, SQLCODE);
472: END IF;
473: IF (l_debug = 1) THEN
474: print_debug('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request exception:'||l_progress,4);
475: END IF;

Line 474: print_debug('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request exception:'||l_progress,4);

470: IF SQLCODE IS NOT NULL THEN
471: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request', l_progress, SQLCODE);
472: END IF;
473: IF (l_debug = 1) THEN
474: print_debug('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request exception:'||l_progress,4);
475: END IF;
476: END rcv_online_request;
477:
478:

Line 635: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_process_receive_txn', l_progress, SQLCODE);

631:
632: x_return_status := fnd_api.g_ret_sts_unexp_error ;
633:
634: IF SQLCODE IS NOT NULL THEN
635: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_process_receive_txn', l_progress, SQLCODE);
636: END IF;
637: fnd_msg_pub.count_and_get
638: (p_encoded => FND_API.g_false,
639: p_count => l_msg_count,

Line 838: END INV_RCV_MOBILE_PROCESS_TXN;

834: END IF;
835: x_return_status := fnd_api.g_ret_sts_success;
836: END check_existing_lot;
837: --end of 8539263 changes
838: END INV_RCV_MOBILE_PROCESS_TXN;
839: