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.6.12010000.1 2008/07/24 01:45:00 appldev 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.6.12010000.1 2008/07/24 01:45:00 appldev 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 626: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_process_receive_txn', l_progress, SQLCODE);

622:
623: x_return_status := fnd_api.g_ret_sts_unexp_error ;
624:
625: IF SQLCODE IS NOT NULL THEN
626: inv_mobile_helper_functions.sql_error('INV_RCV_MOBILE_PROCESS_TXN.rcv_process_receive_txn', l_progress, SQLCODE);
627: END IF;
628: fnd_msg_pub.count_and_get
629: (p_encoded => FND_API.g_false,
630: p_count => l_msg_count,

Line 636: END INV_RCV_MOBILE_PROCESS_TXN;

632: );
633:
634: END rcv_process_receive_txn;
635:
636: END INV_RCV_MOBILE_PROCESS_TXN;
637: