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.

APPS.INV_RCV_COMMON_APIS dependencies on FND_PROFILE

Line 8: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4: -- Global constant holding the package name
5: g_pkg_name CONSTANT VARCHAR2(30) := 'inv_RCV_COMMON_APIS';
6:
7: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
8: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9: BEGIN
10: IF (l_debug = 1) THEN
11: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => 'inv_RCV_COMMON_APIS', p_level => p_level);
12: END IF;

Line 17: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

13: END print_debug;
14:
15: PROCEDURE init_startup_values(p_organization_id IN NUMBER) IS
16: l_message VARCHAR2(240);
17: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
18: BEGIN
19: IF (l_debug = 1) THEN
20: print_debug('enter init_startup_values : 10', 1);
21: END IF;

Line 101: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

97: RETURN VARCHAR2 IS
98: l_to_ser VARCHAR2(30);
99: l_number NUMBER;
100: l_temp_prefix VARCHAR2(30);
101: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
102: BEGIN
103: inv_validate.number_from_sequence(p_from_ser, l_temp_prefix, l_number);
104: l_number := l_number + p_primary_quantity - 1;
105: l_to_ser := SUBSTR(p_from_ser, 1, LENGTH(p_from_ser) - LENGTH(l_number)) || l_number;

Line 110: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

106: RETURN l_to_ser;
107: END get_to_serial_number;
108:
109: PROCEDURE insert_mtlt(p_mtlt_rec mtl_transaction_lots_temp%ROWTYPE) IS
110: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
111: BEGIN
112: INSERT INTO mtl_transaction_lots_temp
113: (
114: transaction_temp_id

Line 429: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

425: END IF;
426: END check_lot_serial_codes;
427:
428: PROCEDURE insert_msnt(p_msnt_rec mtl_serial_numbers_temp%ROWTYPE) IS
429: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
430: BEGIN
431: INSERT INTO mtl_serial_numbers_temp
432: (
433: transaction_temp_id

Line 606: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

602: l_from_ser_num NUMBER; -- number part of from serial
603: l_to_ser_num NUMBER; -- number part of to serial
604: l_primary_quantity NUMBER; -- the quantity within this serial record
605: l_prefix_temp VARCHAR2(30);
606: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
607: BEGIN
608: FOR i IN 1 .. p_new_transactions_tb.COUNT LOOP -- Loop through all the transaction lines need to be splitted
609: l_new_transaction_temp_id := p_new_transactions_tb(i).transaction_id;
610: l_new_primary_quantity := p_new_transactions_tb(i).primary_quantity;

Line 798: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

794: l_new_secondary_quantity NUMBER; -- the quanity user wants to split
795: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;
796: --BUG 2673970
797: l_rowid ROWID;
798: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
799: BEGIN
800: FOR i IN 1 .. p_new_transactions_tb.COUNT LOOP -- Loop through all the transaction lines need to be splitted
801: l_new_transaction_temp_id := p_new_transactions_tb(i).transaction_id;
802: l_new_primary_quantity := p_new_transactions_tb(i).primary_quantity;

Line 1098: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1094: l_sec_transaction_quantity NUMBER; --invconv kkillams
1095: l_new_secondary_quantity NUMBER; -- the quanity user wants to split
1096: --BUG 2673970
1097: l_rowid ROWID;
1098: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1099:
1100: BEGIN
1101: FOR i IN 1 .. p_new_transactions_tb.COUNT LOOP -- Loop through all the transaction lines need to be splitted
1102: l_new_transaction_temp_id := p_new_transactions_tb(i).transaction_id;

Line 1292: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1288: , p_new_transactions_tb IN trans_rec_tb_tp
1289: , p_lot_control_code IN NUMBER
1290: , p_serial_control_code IN NUMBER
1291: ) IS
1292: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1293: BEGIN
1294: print_debug('Entered BREAK',1);
1295: --lots and not serials -- ?? VERIFY THIS
1296: IF (p_lot_control_code = 2

Line 1335: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1331: l_msg_data VARCHAR2(400);
1332: l_progress VARCHAR2(10);
1333: l_receipt_code VARCHAR2(25);
1334: l_temp_rcpt_num VARCHAR(30); --bug6014386
1335: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1336: BEGIN
1337: x_return_status := fnd_api.g_ret_sts_success;
1338: l_progress := '10';
1339:

Line 1442: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1438: , x_return_status OUT NOCOPY VARCHAR2
1439: , x_msg_count OUT NOCOPY NUMBER
1440: , x_msg_data OUT NOCOPY VARCHAR2
1441: ) IS
1442: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1443: BEGIN
1444: x_return_status := fnd_api.g_ret_sts_success;
1445:
1446: IF (l_debug = 1) THEN

Line 1475: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1471: PROCEDURE rcv_clear_global IS
1472: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1473: l_msg_count NUMBER;
1474: l_msg_data VARCHAR2(400);
1475: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1476: BEGIN
1477: g_po_startup_value := NULL;
1478: g_rcv_global_var := NULL;
1479: g_lot_status_tb.DELETE;

Line 1569: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1565: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1566: l_msg_count NUMBER;
1567: l_msg_data VARCHAR2(400);
1568: l_progress VARCHAR2(10);
1569: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1570: BEGIN
1571: IF (l_debug = 1) THEN
1572: print_debug('enter init_form_values : 10', 1);
1573: END IF;

Line 1676: fnd_profile.get('DISPLAY_INVERSE_RATE', x_display_inverse_rate);

1672: FROM rcv_parameters
1673: WHERE organization_id = p_org_id;
1674:
1675: l_progress := '60';
1676: fnd_profile.get('DISPLAY_INVERSE_RATE', x_display_inverse_rate);
1677:
1678: IF x_display_inverse_rate IS NULL THEN
1679: x_display_inverse_rate := 'N';
1680: END IF;

Line 1796: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1792: , x_wms_patch_level OUT NOCOPY NUMBER
1793: ) IS
1794: l_msg_count NUMBER;
1795: l_progress VARCHAR2(5);
1796: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1797: BEGIN
1798: IF (l_debug = 1) THEN
1799: print_debug('Entering init_rcv_ui_startup_values:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1800: END IF;

Line 2210: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2206: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2207: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED');
2208: */
2209:
2210: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2211: BEGIN
2212: OPEN po_ll_routing_cur;
2213:
2214: IF (l_debug = 1) THEN

Line 2406: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2402: OR
2403: (p_lpn_id IS NULL)
2404: );
2405:
2406: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2407: BEGIN
2408: IF (l_debug = 1) THEN
2409: print_debug('Enter get_asn_routing_id 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2410: print_debug('p_shipment_header_id => ' || p_shipment_header_id, 4);

Line 2583: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2579: AND source_document_code = 'PO')
2580: OR (item_id = NVL(p_item_id, item_id))
2581: );
2582:
2583: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2584: BEGIN
2585: OPEN intshp_rsl_routing_cur;
2586:
2587: IF (l_debug = 1) THEN

Line 2681: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2677: , p_item_id IN NUMBER
2678: , p_organization_id IN NUMBER
2679: , p_vendor_id IN NUMBER
2680: ) IS
2681: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2682: BEGIN
2683: /* select item level controls that are not specifid at the purchase
2684: ** order level
2685: */

Line 2781: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2777: l_dummy NUMBER;
2778: l_transaction_type NUMBER := 18; -- defaulted for PO receipt.
2779: l_is_expense VARCHAR2(1) := 'N';
2780: l_lpn_loaded NUMBER := 0;
2781: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2782: l_is_valid_item VARCHAR2(1) := 'Y';
2783: l_project_id NUMBER;
2784: l_task_id NUMBER;
2785: l_pjm_org NUMBER := 2;

Line 2956: IF (NVL(FND_PROFILE.VALUE('WMS_DEPLOYMENT_MODE'), 1) = 3) THEN

2952: END IF;
2953:
2954: /* Bug 9158529: LSP Changes */
2955:
2956: IF (NVL(FND_PROFILE.VALUE('WMS_DEPLOYMENT_MODE'), 1) = 3) THEN
2957:
2958:
2959: l_client_code := wms_deploy.get_client_code(p_item_id);
2960:

Line 3281: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3277: l_return_status VARCHAR2(1);
3278: l_msg_count NUMBER;
3279: l_msg_data VARCHAR2(400);
3280: l_progress VARCHAR2(10);
3281: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3282: BEGIN
3283: IF (l_debug = 1) THEN
3284: print_debug('create_lpn 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3285: print_debug('Parameters passed : 10.1 p_lpn = ' || p_lpn, 4);

Line 3387: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3383: ) IS
3384: l_return NUMBER;
3385: l_progress VARCHAR2(10);
3386: l_count NUMBER := 0;
3387: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3388: BEGIN
3389: x_return_status := fnd_api.g_ret_sts_success;
3390: l_progress := '10';
3391:

Line 3517: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3513: l_msg_count NUMBER;
3514: l_success NUMBER := 0;
3515: l_count NUMBER := 0;
3516: l_temp_qty NUMBER := 0;
3517: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3518: BEGIN
3519: x_return_status := fnd_api.g_ret_sts_success;
3520: l_progress := '10';
3521:

Line 3673: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

3669: p_item_id IN NUMBER,
3670: p_organization_id IN NUMBER)
3671: IS
3672: l_progress VARCHAR2 (10);
3673: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3674: l_count NUMBER;
3675: BEGIN
3676: x_return_status := fnd_api.g_ret_sts_success;
3677:

Line 3773: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

3769: p_item_id IN NUMBER,
3770: p_organization_id IN NUMBER)
3771: IS
3772: l_progress VARCHAR2 (10);
3773: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3774: l_count NUMBER;
3775: BEGIN
3776: x_return_status := fnd_api.g_ret_sts_success;
3777:

Line 3863: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

3859: P_item_desc IN Varchar2)
3860: IS
3861: l_progress VARCHAR2 (10);
3862: l_class VARCHAR2 (10);
3863: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3864: BEGIN
3865: x_return_status := fnd_api.g_ret_sts_success;
3866:
3867: IF (l_debug = 1)

Line 3981: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3977: , p_item_desc IN VARCHAR2 --BUG 4500676
3978: ) IS
3979: l_progress VARCHAR2(10);
3980: l_class VARCHAR2(10);
3981: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3982: l_count NUMBER;
3983: BEGIN
3984: x_return_status := fnd_api.g_ret_sts_success;
3985: IF (l_debug = 1) THEN

Line 4184: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4180: l_auto_transact_code VARCHAR2(10);
4181: l_is_pjm_org NUMBER := 2;
4182: l_loc_project_id NUMBER;
4183: l_loc_task_id NUMBER;
4184: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4185: l_kanban_card_id NUMBER := -999; --Bug 4671198
4186: l_count_lpn NUMBER := 0; --Bug 5928199
4187: BEGIN
4188: x_return_status := fnd_api.g_ret_sts_success;

Line 4610: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4606: p_project_id IN NUMBER DEFAULT NULL,
4607: p_task_id IN NUMBER DEFAULT NULL) IS
4608: l_lpn_context NUMBER;
4609: l_default_source VARCHAR2(10);
4610: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4611: BEGIN
4612: IF (l_debug = 1) THEN
4613: print_debug('Enter get_sub_code: default implementation:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4614: END IF;

Line 4654: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4650: p_from_lpn_id IN NUMBER DEFAULT NULL)
4651:
4652: IS
4653: l_progress VARCHAR2(10);
4654: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4655:
4656: BEGIN
4657:
4658: x_location_code := '' ;

Line 4803: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

4799:
4800: IS
4801: l_progress VARCHAR2(10);
4802: l_shipment_header_id NUMBER ;
4803: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4804: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4805: l_msg_count NUMBER;
4806: l_msg_data VARCHAR2(4000);
4807: l_rcvreq_use_intship VARCHAR2(1) := 'N' ;

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

5000: p_inventory_item_id IN NUMBER,
5001: p_lot_number IN VARCHAR2,
5002: p_exists IN VARCHAR2)
5003: IS
5004: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5005: BEGIN
5006: IF (l_debug = 1) THEN
5007: print_debug('Updating the lot number attributes',4);
5008: END IF;

Line 5231: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

5227: , p_origination_type IN NUMBER DEFAULT NULL -- bug 15896641 - inserting origination type
5228: ) IS
5229: l_exists VARCHAR2(7) := 'FALSE';
5230: v_temp VARCHAR2(50);
5231: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5232: l_stacked_messages VARCHAR2(1000);
5233: l_status_id NUMBER; --Added bug3853202
5234: l_status_enabled VARCHAR2(1); --Added bug3998321
5235: l_dest_status_enabled VARCHAR2(1); --Added bug4035918

Line 5417: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

5413: l_success NUMBER;
5414: l_temp_var NUMBER;
5415: l_progress VARCHAR2(10);
5416: l_serial_packed_in_other_lpn NUMBER;
5417: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5418: l_inv_po_j_higher BOOLEAN := FALSE;
5419: l_rcv_serial_flag VARCHAR2(1) := 'N';
5420: BEGIN
5421: IF (l_debug = 1) THEN

Line 5700: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

5696: l_serial_num_length NUMBER;
5697: l_prefix_length NUMBER;
5698: l_num_suffix VARCHAR2(30);
5699: l_progress VARCHAR2(10);
5700: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5701: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.VALUE('INV_RESTRICT_RCPT_SER'), '0');
5702: l_serial_control_code VARCHAR2(10);
5703: l_txn_cnt VARCHAR2(10);
5704: BEGIN

Line 5701: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.VALUE('INV_RESTRICT_RCPT_SER'), '0');

5697: l_prefix_length NUMBER;
5698: l_num_suffix VARCHAR2(30);
5699: l_progress VARCHAR2(10);
5700: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5701: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.VALUE('INV_RESTRICT_RCPT_SER'), '0');
5702: l_serial_control_code VARCHAR2(10);
5703: l_txn_cnt VARCHAR2(10);
5704: BEGIN
5705: IF (l_debug = 1) THEN

Line 5986: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

5982: , p_parent_lot_number IN VARCHAR2 DEFAULT NULL --bug 10176719 - inserting parent lot number
5983: , p_origination_type IN NUMBER DEFAULT NULL --bug 15896641 - inserting origination type
5984: ) IS
5985: l_progress VARCHAR2(10);
5986: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5987: BEGIN
5988: IF (l_debug = 1) THEN
5989: print_debug('Enter process_lot: 10:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5990: print_debug('Organization ID = ' || TO_CHAR(p_organization_id), 1);

Line 6133: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6129: p_data => x_msg_data);
6130: END process_lot;
6131:
6132: PROCEDURE gen_txn_group_id IS
6133: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6134: BEGIN
6135: IF g_rcv_global_var.interface_group_id IS NULL THEN
6136: SELECT rcv_interface_groups_s.NEXTVAL
6137: INTO g_rcv_global_var.interface_group_id

Line 6149: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6145: , p_sob_id IN NUMBER
6146: , x_return_status OUT NOCOPY VARCHAR2
6147: , x_error_code OUT NOCOPY VARCHAR2
6148: ) IS
6149: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6150: BEGIN
6151: x_return_status := fnd_api.g_ret_sts_success;
6152:
6153: IF (p_trx_date > SYSDATE) THEN

Line 6221: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6217: , p_rcv_txn_type IN VARCHAR2
6218: , p_lpn_id IN NUMBER DEFAULT NULL
6219: ) IS
6220: l_from_org_id NUMBER;
6221: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6222: BEGIN
6223: get_req_shipment_header_id(
6224: x_shipment_header_id => x_shipment_header_id
6225: , x_from_org_id => l_from_org_id

Line 6253: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6249: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
6250: l_msg_count NUMBER;
6251: l_msg_data VARCHAR2(400);
6252: l_progress VARCHAR2(10);
6253: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6254: BEGIN
6255: x_return_status := fnd_api.g_ret_sts_success;
6256:
6257: IF (l_debug = 1) THEN

Line 6539: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6535: ) IS
6536: l_progress VARCHAR2(10);
6537: l_check_result VARCHAR2(1);
6538: l_seq_num NUMBER;
6539: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6540: BEGIN
6541: x_return_status := fnd_api.g_ret_sts_success;
6542: l_progress := '10';
6543: --

Line 6659: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6655: , x_serial_control OUT NOCOPY NUMBER
6656: , p_from_org_id IN NUMBER
6657: , p_item_id IN NUMBER
6658: ) IS
6659: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6660: BEGIN
6661: x_return_status := 'S';
6662:
6663: SELECT serial_number_control_code

Line 6692: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6688: ) IS
6689: l_project_tasks_count NUMBER := 0;
6690: l_distributions_count NUMBER := 0;
6691: l_progress VARCHAR2(10);
6692: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6693: BEGIN
6694: IF (l_debug = 1) THEN
6695: print_debug('Entered get_document_project_task ' || p_document_type, 4);
6696: END IF;

Line 6944: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6940: , p_requisition_id IN NUMBER
6941: , p_item_id IN NUMBER
6942: ) IS
6943: l_from_org_id NUMBER := 0;
6944: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6945: BEGIN
6946: x_return_status := 'S';
6947:
6948: /*Get the From Organization for the item using shipment header

Line 6991: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

6987: l_cross_reference VARCHAR2(25);
6988: l_inventory_item_id NUMBER;
6989: l_user_id NUMBER;
6990: l_login_id NUMBER;
6991: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6992: BEGIN
6993: l_progress := '0';
6994:
6995: IF (l_debug = 1) THEN

Line 7129: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

7125: , x_lot_control OUT NOCOPY NUMBER
7126: , p_from_org_id IN NUMBER
7127: , p_item_id IN NUMBER
7128: ) IS
7129: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7130: BEGIN
7131: x_return_status := fnd_api.g_ret_sts_success;
7132:
7133: SELECT lot_control_code

Line 7175: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

7171: , p_requisition_id IN NUMBER
7172: , p_item_id IN NUMBER
7173: ) IS
7174: l_from_org_id NUMBER := 0;
7175: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7176: BEGIN
7177: x_return_status := fnd_api.g_ret_sts_success;
7178:
7179: /*Get the From Organization for the item using shipment header

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

7232: , p_project_id IN NUMBER DEFAULT NULL
7233: ) IS
7234: l_progress VARCHAR2(10);
7235: l_task_id NUMBER;
7236: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7237: l_debug NUMBER := 1;
7238: BEGIN
7239: IF (l_debug = 1) THEN
7240: print_debug('Entered get_document_project_task ' || p_document_type, 4);

Line 7425: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

7421: l_msg_count NUMBER;
7422: l_msg_data VARCHAR2(4000);
7423: l_progress VARCHAR2(10);
7424: l_valid_lpn_flag VARCHAR(1) := 'Y';
7425: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7426: BEGIN
7427: x_lpn_flag := 'N'; -- 'Y -validlpn ' 'N- Invalid lpn'
7428: l_progress := 10;
7429:

Line 7535: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

7531: , p_lpn_id IN NUMBER
7532: , p_organization_id IN NUMBER) IS
7533: l_count NUMBER;
7534: l_progress VARCHAR2(10);
7535: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7536: l_sub_code mtl_secondary_inventories.secondary_inventory_name%TYPE;
7537: l_locator_id NUMBER;
7538: l_location_id NUMBER;
7539: l_auto_transact_code VARCHAR2(10);

Line 7747: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

7743: l_progress VARCHAR2(10);
7744: l_req_num VARCHAR2(10);
7745: l_valid_lpn_flag VARCHAR(1) := 'Y';
7746: l_order_header_id NUMBER;
7747: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7748: BEGIN
7749:
7750: -- Intialize variables
7751: x_lpn_flag := 'Y'; -- 'Y -validlpn ' 'N- Invalid lpn'

Line 8083: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

8079:
8080: EXCEPTION
8081: WHEN NO_DATA_FOUND THEN
8082:
8083: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8084:
8085: IF (l_debug = 1) THEN
8086: print_debug('Error getting org_id in get_operating_unit_id(): '||l_progress, 1);
8087: END IF;

Line 8105: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

8101: x_msg_count OUT NOCOPY NUMBER ,
8102: x_msg_data OUT NOCOPY VARCHAR2,
8103: x_open_shipments OUT NOCOPY NUMBER
8104: )IS
8105: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8106: BEGIN
8107: x_return_status := fnd_api.g_ret_sts_success;
8108: IF (l_debug = 1) THEN
8109: print_debug('Enter check_req_open_shipments 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 8153: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

8149: , p_item_id IN NUMBER
8150: , p_organization_id IN NUMBER
8151: ) IS
8152: l_progress VARCHAR2(10);
8153: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8154: l_uom_code VARCHAR2(3);
8155: BEGIN
8156: x_return_status := fnd_api.g_ret_sts_success;
8157: x_uom_code := NULL;