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 2137: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2133: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2134: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED');
2135: */
2136:
2137: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2138: BEGIN
2139: OPEN po_ll_routing_cur;
2140:
2141: IF (l_debug = 1) THEN

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

2284: OR
2285: (p_lpn_id IS NULL)
2286: );
2287:
2288: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2289: BEGIN
2290: IF (l_debug = 1) THEN
2291: print_debug('Enter get_asn_routing_id 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2292: print_debug('p_shipment_header_id => ' || p_shipment_header_id, 4);

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

2438: AND source_document_code = 'PO')
2439: OR (item_id = NVL(p_item_id, item_id))
2440: );
2441:
2442: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2443: BEGIN
2444: OPEN intshp_rsl_routing_cur;
2445:
2446: IF (l_debug = 1) THEN

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

2535: , p_item_id IN NUMBER
2536: , p_organization_id IN NUMBER
2537: , p_vendor_id IN NUMBER
2538: ) IS
2539: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2540: BEGIN
2541: /* select item level controls that are not specifid at the purchase
2542: ** order level
2543: */

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

2635: l_dummy NUMBER;
2636: l_transaction_type NUMBER := 18; -- defaulted for PO receipt.
2637: l_is_expense VARCHAR2(1) := 'N';
2638: l_lpn_loaded NUMBER := 0;
2639: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2640: l_is_valid_item VARCHAR2(1) := 'Y';
2641: l_project_id NUMBER;
2642: l_task_id NUMBER;
2643: l_pjm_org NUMBER := 2;

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

3099: l_return_status VARCHAR2(1);
3100: l_msg_count NUMBER;
3101: l_msg_data VARCHAR2(400);
3102: l_progress VARCHAR2(10);
3103: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3104: BEGIN
3105: IF (l_debug = 1) THEN
3106: print_debug('create_lpn 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3107: print_debug('Parameters passed : 10.1 p_lpn = ' || p_lpn, 4);

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

3205: ) IS
3206: l_return NUMBER;
3207: l_progress VARCHAR2(10);
3208: l_count NUMBER := 0;
3209: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3210: BEGIN
3211: x_return_status := fnd_api.g_ret_sts_success;
3212: l_progress := '10';
3213:

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

3335: l_msg_count NUMBER;
3336: l_success NUMBER := 0;
3337: l_count NUMBER := 0;
3338: l_temp_qty NUMBER := 0;
3339: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3340: BEGIN
3341: x_return_status := fnd_api.g_ret_sts_success;
3342: l_progress := '10';
3343:

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

3494: , p_item_desc IN VARCHAR2 --BUG 4500676
3495: ) IS
3496: l_progress VARCHAR2(10);
3497: l_class VARCHAR2(10);
3498: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3499: l_count NUMBER;
3500: BEGIN
3501: x_return_status := fnd_api.g_ret_sts_success;
3502: IF (l_debug = 1) THEN

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

3697: l_auto_transact_code VARCHAR2(10);
3698: l_is_pjm_org NUMBER := 2;
3699: l_loc_project_id NUMBER;
3700: l_loc_task_id NUMBER;
3701: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3702: l_kanban_card_id NUMBER := -999; --Bug 4671198
3703: l_count_lpn NUMBER := 0; --Bug 5928199
3704: BEGIN
3705: x_return_status := fnd_api.g_ret_sts_success;

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

4123: p_project_id IN NUMBER DEFAULT NULL,
4124: p_task_id IN NUMBER DEFAULT NULL) IS
4125: l_lpn_context NUMBER;
4126: l_default_source VARCHAR2(10);
4127: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4128: BEGIN
4129: IF (l_debug = 1) THEN
4130: print_debug('Enter get_sub_code: default implementation:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4131: END IF;

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

4167: p_from_lpn_id IN NUMBER DEFAULT NULL)
4168:
4169: IS
4170: l_progress VARCHAR2(10);
4171: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4172:
4173: BEGIN
4174:
4175: x_location_code := '' ;

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

4276:
4277: IS
4278: l_progress VARCHAR2(10);
4279: l_shipment_header_id NUMBER ;
4280: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4281: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4282: l_msg_count NUMBER;
4283: l_msg_data VARCHAR2(4000);
4284: l_rcvreq_use_intship VARCHAR2(1) := 'N' ;

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

4477: p_inventory_item_id IN NUMBER,
4478: p_lot_number IN VARCHAR2,
4479: p_exists IN VARCHAR2)
4480: IS
4481: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4482: BEGIN
4483: IF (l_debug = 1) THEN
4484: print_debug('Updating the lot number attributes',4);
4485: END IF;

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

4702: , x_msg_data OUT NOCOPY VARCHAR2
4703: ) IS
4704: l_exists VARCHAR2(7) := 'FALSE';
4705: v_temp VARCHAR2(50);
4706: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4707: l_stacked_messages VARCHAR2(1000);
4708: l_status_id NUMBER; --Added bug3853202
4709: l_status_enabled VARCHAR2(1); --Added bug3998321
4710: l_dest_status_enabled VARCHAR2(1); --Added bug4035918

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

4886: l_success NUMBER;
4887: l_temp_var NUMBER;
4888: l_progress VARCHAR2(10);
4889: l_serial_packed_in_other_lpn NUMBER;
4890: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4891: l_inv_po_j_higher BOOLEAN := FALSE;
4892: l_rcv_serial_flag VARCHAR2(1) := 'N';
4893: BEGIN
4894: IF (l_debug = 1) THEN

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

5169: l_serial_num_length NUMBER;
5170: l_prefix_length NUMBER;
5171: l_num_suffix VARCHAR2(30);
5172: l_progress VARCHAR2(10);
5173: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5174: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.VALUE('INV_RESTRICT_RCPT_SER'), '0');
5175: l_serial_control_code VARCHAR2(10);
5176: l_txn_cnt VARCHAR2(10);
5177: BEGIN

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

5170: l_prefix_length NUMBER;
5171: l_num_suffix VARCHAR2(30);
5172: l_progress VARCHAR2(10);
5173: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5174: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.VALUE('INV_RESTRICT_RCPT_SER'), '0');
5175: l_serial_control_code VARCHAR2(10);
5176: l_txn_cnt VARCHAR2(10);
5177: BEGIN
5178: IF (l_debug = 1) THEN

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

5453: , p_lot_secondary_qty IN NUMBER --OPM Convergence
5454: , p_secondary_uom_code IN VARCHAR2 --OPM Convergence
5455: ) IS
5456: l_progress VARCHAR2(10);
5457: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5458: BEGIN
5459: IF (l_debug = 1) THEN
5460: print_debug('Enter process_lot: 10:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5461: print_debug('Organization ID = ' || TO_CHAR(p_organization_id), 1);

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

5597: p_data => x_msg_data);
5598: END process_lot;
5599:
5600: PROCEDURE gen_txn_group_id IS
5601: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5602: BEGIN
5603: IF g_rcv_global_var.interface_group_id IS NULL THEN
5604: SELECT rcv_interface_groups_s.NEXTVAL
5605: INTO g_rcv_global_var.interface_group_id

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

5613: , p_sob_id IN NUMBER
5614: , x_return_status OUT NOCOPY VARCHAR2
5615: , x_error_code OUT NOCOPY VARCHAR2
5616: ) IS
5617: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5618: BEGIN
5619: x_return_status := fnd_api.g_ret_sts_success;
5620:
5621: IF (p_trx_date > SYSDATE) THEN

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

5685: , p_rcv_txn_type IN VARCHAR2
5686: , p_lpn_id IN NUMBER DEFAULT NULL
5687: ) IS
5688: l_from_org_id NUMBER;
5689: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5690: BEGIN
5691: get_req_shipment_header_id(
5692: x_shipment_header_id => x_shipment_header_id
5693: , x_from_org_id => l_from_org_id

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

5717: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5718: l_msg_count NUMBER;
5719: l_msg_data VARCHAR2(400);
5720: l_progress VARCHAR2(10);
5721: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5722: BEGIN
5723: x_return_status := fnd_api.g_ret_sts_success;
5724:
5725: IF (l_debug = 1) THEN

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

6003: ) IS
6004: l_progress VARCHAR2(10);
6005: l_check_result VARCHAR2(1);
6006: l_seq_num NUMBER;
6007: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6008: BEGIN
6009: x_return_status := fnd_api.g_ret_sts_success;
6010: l_progress := '10';
6011: --

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

6123: , x_serial_control OUT NOCOPY NUMBER
6124: , p_from_org_id IN NUMBER
6125: , p_item_id IN NUMBER
6126: ) IS
6127: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6128: BEGIN
6129: x_return_status := 'S';
6130:
6131: SELECT serial_number_control_code

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

6156: ) IS
6157: l_project_tasks_count NUMBER := 0;
6158: l_distributions_count NUMBER := 0;
6159: l_progress VARCHAR2(10);
6160: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6161: BEGIN
6162: IF (l_debug = 1) THEN
6163: print_debug('Entered get_document_project_task ' || p_document_type, 4);
6164: END IF;

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

6408: , p_requisition_id IN NUMBER
6409: , p_item_id IN NUMBER
6410: ) IS
6411: l_from_org_id NUMBER := 0;
6412: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6413: BEGIN
6414: x_return_status := 'S';
6415:
6416: /*Get the From Organization for the item using shipment header

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

6455: l_cross_reference VARCHAR2(25);
6456: l_inventory_item_id NUMBER;
6457: l_user_id NUMBER;
6458: l_login_id NUMBER;
6459: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6460: BEGIN
6461: l_progress := '0';
6462:
6463: IF (l_debug = 1) THEN

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

6593: , x_lot_control OUT NOCOPY NUMBER
6594: , p_from_org_id IN NUMBER
6595: , p_item_id IN NUMBER
6596: ) IS
6597: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6598: BEGIN
6599: x_return_status := fnd_api.g_ret_sts_success;
6600:
6601: SELECT lot_control_code

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

6639: , p_requisition_id IN NUMBER
6640: , p_item_id IN NUMBER
6641: ) IS
6642: l_from_org_id NUMBER := 0;
6643: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6644: BEGIN
6645: x_return_status := fnd_api.g_ret_sts_success;
6646:
6647: /*Get the From Organization for the item using shipment header

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

6700: , p_project_id IN NUMBER DEFAULT NULL
6701: ) IS
6702: l_progress VARCHAR2(10);
6703: l_task_id NUMBER;
6704: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6705: l_debug NUMBER := 1;
6706: BEGIN
6707: IF (l_debug = 1) THEN
6708: print_debug('Entered get_document_project_task ' || p_document_type, 4);

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

6889: l_msg_count NUMBER;
6890: l_msg_data VARCHAR2(4000);
6891: l_progress VARCHAR2(10);
6892: l_valid_lpn_flag VARCHAR(1) := 'Y';
6893: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6894: BEGIN
6895: x_lpn_flag := 'N'; -- 'Y -validlpn ' 'N- Invalid lpn'
6896: l_progress := 10;
6897:

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

6999: , p_lpn_id IN NUMBER
7000: , p_organization_id IN NUMBER) IS
7001: l_count NUMBER;
7002: l_progress VARCHAR2(10);
7003: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7004: l_sub_code mtl_secondary_inventories.secondary_inventory_name%TYPE;
7005: l_locator_id NUMBER;
7006: l_location_id NUMBER;
7007: l_auto_transact_code VARCHAR2(10);

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

7211: l_progress VARCHAR2(10);
7212: l_req_num VARCHAR2(10);
7213: l_valid_lpn_flag VARCHAR(1) := 'Y';
7214: l_order_header_id NUMBER;
7215: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7216: BEGIN
7217:
7218: -- Intialize variables
7219: x_lpn_flag := 'Y'; -- 'Y -validlpn ' 'N- Invalid lpn'

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

7547:
7548: EXCEPTION
7549: WHEN NO_DATA_FOUND THEN
7550:
7551: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7552:
7553: IF (l_debug = 1) THEN
7554: print_debug('Error getting org_id in get_operating_unit_id(): '||l_progress, 1);
7555: END IF;

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

7569: x_msg_count OUT NOCOPY NUMBER ,
7570: x_msg_data OUT NOCOPY VARCHAR2,
7571: x_open_shipments OUT NOCOPY NUMBER
7572: )IS
7573: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7574: BEGIN
7575: x_return_status := fnd_api.g_ret_sts_success;
7576: IF (l_debug = 1) THEN
7577: print_debug('Enter check_req_open_shipments 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

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

7617: , p_item_id IN NUMBER
7618: , p_organization_id IN NUMBER
7619: ) IS
7620: l_progress VARCHAR2(10);
7621: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7622: l_uom_code VARCHAR2(3);
7623: BEGIN
7624: x_return_status := fnd_api.g_ret_sts_success;
7625: x_uom_code := NULL;