eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WMS_RETURN_SV dependencies on FND_PROFILE

Line 5: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1: PACKAGE BODY WMS_RETURN_SV AS
2: /* $Header: WMSRETNB.pls 120.13.12020000.5 2013/03/19 15:00:48 ssingams ship $ */
3:
4: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER default 4) IS
5: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6: BEGIN
7:
8: inv_mobile_helper_functions.tracelog
9: (p_err_msg => p_err_msg,

Line 223: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

219: l_msg_count NUMBER;
220: l_lpn_context NUMBER;--bug3646129
221:
222: l_pregen_putaway_tasks_flag NUMBER;
223: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
224: BEGIN
225:
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227: l_return_status := fnd_api.g_ret_sts_success;

Line 1009: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1005: p_secondary_quantity IN NUMBER :=NULL -- 13399743
1006: )
1007: IS
1008:
1009: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1010: l_transactable_flag VARCHAR2(1) := NULL; --bug 5068433
1011: l_validation_level NUMBER := fnd_api.g_valid_level_full; --bug 5068433
1012: l_sec_qty NUMBER := null; -- 12621897
1013: l_sec_uom_code VARCHAR2(50) := null; -- 12621897

Line 1405: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1401: -- Since both cursors have the same return values, we can use this
1402: -- record type for both.
1403: l_res_csr c_reservation_csr%ROWTYPE;
1404:
1405: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1406: l_wms_po_j_higher BOOLEAN := FALSE;
1407:
1408: -- Bug# 3281512 - Performance Fixes
1409: -- Cursor to get rid of the hash join problem

Line 1851: --FND_PROFILE.GET('WMS_EXPRESS_RETURN', l_express_return);

1847:
1848: END LOOP;
1849: END IF; --IF (l_wms_po_j_higher = FALSE) THEN
1850: --Check the express return profile value
1851: --FND_PROFILE.GET('WMS_EXPRESS_RETURN', l_express_return);
1852: --IF NVL(l_express_return,'Y') = 'N' THEN
1853: BEGIN
1854: -- Bug# 3631611: Performance Fixes
1855: -- Open the appropriate cursor based on p_txn_mode

Line 2235: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2231: /* Returns NONE or PARTIAL or FULL */
2232:
2233: v_dummy VARCHAR2(1);
2234: v_is_marked boolean := FALSE;
2235: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2236: BEGIN
2237:
2238: BEGIN
2239:

Line 2402: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2398: l_msg_data VARCHAR2(2000);
2399:
2400: l_sec_qty NUMBER; -- bug 13399743
2401:
2402: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2403: BEGIN
2404:
2405: l_position := '0010';
2406: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2711: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2707:
2708:
2709: IS
2710:
2711: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2712: l_position VARCHAR2(4) := '0000';
2713:
2714: CURSOR c_unmark_wlc
2715: IS

Line 2812: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2808: AND released_status = 'X'
2809: and rownum <2;
2810:
2811:
2812: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2813: l_position VARCHAR2(4) := '0001';
2814: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
2815: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
2816: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

Line 3062: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3058: ,p_ship_flag IN varchar2)
3059:
3060: IS
3061:
3062: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3063: l_position VARCHAR2(4) := '0000';
3064:
3065: l_lpn_id NUMBER ;
3066: v_dummy NUMBER ;

Line 3157: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3153: p_rtv_order IN NUMBER ,
3154: p_lpn_id IN NUMBER ,
3155: p_trx_header_id NUMBER )
3156: IS
3157: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3158: l_position VARCHAR2(4) := '0000';
3159: l_message VARCHAR2(2000);
3160: l_trx_tmp_id NUMBER;
3161: l_lpn_id NUMBER;

Line 3390: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3386: x_msg_count OUT NOCOPY NUMBER,
3387: x_msg_data OUT NOCOPY VARCHAR2,
3388: p_rtv_order IN NUMBER )
3389: IS
3390: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3391: l_position VARCHAR2(4) := '0000';
3392: l_message VARCHAR2(2000);
3393: l_rti_qty NUMBER ;
3394: l_return_status VARCHAR2(1);

Line 3537: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3533: l_position VARCHAR2(4) := '0000';
3534:
3535: l_wms_po_j_higher BOOLEAN;
3536:
3537: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3538: BEGIN
3539:
3540: l_position := '0010';
3541: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3716: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3712: TYPE c_ref_type IS REF CURSOR;
3713: c_ref c_ref_type;
3714: c_ref_ser c_ref_type;
3715:
3716: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3717: BEGIN
3718:
3719: IF (l_debug = 1) THEN
3720: print_debug('Enter PROCESS_WHOLE_LPN_RETURN');

Line 3889: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3885:
3886: TYPE c_ref_type IS REF CURSOR;
3887: c_ref c_ref_type;
3888:
3889: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3890: BEGIN
3891:
3892: x_return_status := fnd_api.g_ret_sts_success;
3893:

Line 4063: ** Function will be referencing a 'FND_PROFILE.GET' procedure defined

4059: /*
4060: ** Function will return Receiving Transaction Processor Mode (RCV_TP_MODE)
4061: ** If Transaction Processor Mode is NULL then
4062: ** Default the Mode to 'ONLINE'
4063: ** Function will be referencing a 'FND_PROFILE.GET' procedure defined
4064: ** by AOL grp . It will return the value of the PROFILE being asked for,
4065: ** or will return 'ONLINE' if profile 'RCV_TP_MODE' is NULL.
4066: */
4067: transaction_processor_value VARCHAR2(10);

Line 4069: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4065: ** or will return 'ONLINE' if profile 'RCV_TP_MODE' is NULL.
4066: */
4067: transaction_processor_value VARCHAR2(10);
4068:
4069: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4070: BEGIN
4071: fnd_profile.get('RCV_TP_MODE',transaction_processor_value);
4072:
4073: if transaction_processor_value is null then

Line 4071: fnd_profile.get('RCV_TP_MODE',transaction_processor_value);

4067: transaction_processor_value VARCHAR2(10);
4068:
4069: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4070: BEGIN
4071: fnd_profile.get('RCV_TP_MODE',transaction_processor_value);
4072:
4073: if transaction_processor_value is null then
4074: transaction_processor_value := 'ONLINE';
4075: end if;

Line 4100: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4096: PROCEDURE GET_TRX_VALUES(
4097: transaction_processor_value OUT NOCOPY VARCHAR2
4098: , group_id OUT NOCOPY NUMBER) IS
4099: l_groupid NUMBER;
4100: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4101: BEGIN
4102: transaction_processor_value := GET_TRX_PROC_MODE;
4103: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_groupid FROM DUAL;
4104:

Line 4126: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4122: , x_msg_data OUT NOCOPY VARCHAR2
4123: , p_trx_proc_mode IN VARCHAR2
4124: , p_group_id IN NUMBER) IS
4125:
4126: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4127: BEGIN
4128: inv_rcv_common_apis.g_po_startup_value.transaction_mode := p_trx_proc_mode;
4129: inv_rcv_common_apis.g_rcv_global_var.interface_group_id := p_group_id;
4130: INV_RCV_MOBILE_PROCESS_TXN.rcv_process_receive_txn(x_return_status, x_msg_data);

Line 4144: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4140: , p_org_id IN NUMBER
4141: , p_lpn_id IN NUMBER
4142: , p_item_id IN NUMBER
4143: , p_revision IN VARCHAR2) IS
4144: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4145: BEGIN
4146: OPEN x_lpn_lov FOR
4147: select distinct wlpnc.license_plate_number
4148: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti

Line 4212: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4208: WHERE transaction_temp_id = p_intf_txn_id;
4209:
4210: l_wms_po_j_higher BOOLEAN;
4211:
4212: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4213: BEGIN
4214: x_return_status := fnd_api.g_ret_sts_success;
4215:
4216: IF (l_debug = 1) THEN