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_REPLENISH_DETAIL_PUB dependencies on FND_PROFILE

Line 8: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');

4: -- Global constant holding the package name
5:
6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Replenish_Detail_PUB';
7: is_debug BOOLEAN := TRUE;
8: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');
9:
10: -- Start of Comments
11: -- API name Line_Details_PUB
12: -- Type Public

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

30: --
31: -- End of Comments
32:
33: PROCEDURE print_debug(p_message IN VARCHAR2) IS
34: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
35: BEGIN
36: IF (l_debug = 1) THEN
37: inv_pick_wave_pick_confirm_pub.tracelog(p_message, 'INV_REPLENISH_DETAIL');
38: END IF;

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

196: IS SELECT transaction_temp_id
197: FROM mtl_material_transactions_temp
198: WHERE move_order_line_id = p_move_order_line_id;
199:
200: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
201:
202: --Bug 6696594
203: l_mmtt number;
204: l_transaction_id INV_LABEL.transaction_id_rec_type;

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

770: l_expenditure_type VARCHAR2(30);
771: l_project_id NUMBER;
772: l_task_id NUMBER;
773: l_organization_id NUMBER;
774: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
775: BEGIN
776: SELECT transaction_type_id
777: , transaction_action_id
778: INTO l_transaction_type_id

Line 794: fnd_profile.get('CSE_PA_EXP_TYPE', l_expenditure_type);

790: IF l_project_related = 'Y' THEN
791: --copy the project and task info to source_project and source_task info in the MMTT table;
792: -- or the corresponding block or pl/sql table that eventually populates into MMTT.
793:
794: fnd_profile.get('CSE_PA_EXP_TYPE', l_expenditure_type);
795:
796: SELECT organization_id
797: INTO l_organization_id
798: FROM mtl_material_transactions_temp

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

866: l_umconvert_trans_quantity NUMBER := 0;
867: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
868: l_primary_uom VARCHAR2(10);
869: l_ato_item NUMBER := 0;
870: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
871: BEGIN
872: --null;
873: --inv_debug.message('l_reservation_id = ' || p_reservation_id);
874: --inv_debug.message('l_transaction_temp_id = ' || p_transaction_temp_id);

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

1056: END delete_details;
1057:
1058: ---------------------------------------------------
1059: PROCEDURE clear_block_cancel(p_trx_header_id IN NUMBER, p_success IN OUT NOCOPY BOOLEAN) IS
1060: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1061: BEGIN
1062: p_success := TRUE;
1063:
1064: -- Delete predefined serial numbers

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

1111:
1112: l_fm_serial_number VARCHAR2(30);
1113: l_to_serial_number VARCHAR2(30);
1114: l_transaction_header_id NUMBER;
1115: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1116:
1117: BEGIN
1118: --inv_debug.message('ssia', 'in clear record');
1119: p_success := TRUE;

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

1241: l_return_status VARCHAR2(1);
1242: l_count NUMBER;
1243: l_primary_quantity NUMBER;
1244: l_primary_uom VARCHAR2(10);
1245: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1246: BEGIN
1247: SELECT mtl_material_transactions_s.NEXTVAL
1248: INTO l_next_id
1249: FROM DUAL;

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

1324: l_count NUMBER;
1325: l_from_serial_number VARCHAR2(30);
1326: l_to_serial_number VARCHAR2(30);
1327: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1328: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1329: BEGIN
1330: --inv_debug.message('auto pick confirm');
1331: --inv_debug.message('get trolin');
1332: l_trolin_tbl := inv_trolin_util.query_rows(p_line_id => l_line_id);

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

1385: ) IS
1386: l_reservation_id NUMBER := p_reservation_id;
1387: l_return_status VARCHAR2(1);
1388: l_missing_quantity NUMBER := p_missing_quantity;
1389: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1390: BEGIN
1391: -- call the reserve unconfirmed quantity
1392: inv_pick_release_pub.reserve_unconfirmed_quantity(
1393: p_api_version => 1.0

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

1465: l_transaction_temp_id NUMBER := p_transaction_temp_id;
1466: l_lot_number VARCHAR2(80);
1467: l_lot_primary_quantity NUMBER;
1468: l_lot_transaction_quantity NUMBER;
1469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1470: BEGIN
1471: --inv_Debug.message('ssia', 'Inside changed_from_subinventory');
1472: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
1473:

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

1757: FOR UPDATE OF quantity NOWAIT;
1758:
1759: record_locked EXCEPTION;
1760: PRAGMA EXCEPTION_INIT(record_locked, -54);
1761: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1762: BEGIN
1763: l_return_status := fnd_api.g_ret_sts_success;
1764:
1765: BEGIN

Line 1777: IF (NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') <> 'Y') THEN

1773: END;
1774:
1775: -- If overpicking is not turned on then the maximum quanitity that is
1776: -- allowed is the move order quantity
1777: IF (NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') <> 'Y') THEN
1778: IF (l_debug = 1) THEN
1779: print_debug('OVPK | Overpicking is not turned on');
1780: END IF;
1781:

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

1942: l_max_quantity_allowed NUMBER;
1943: l_avail_req_quantity NUMBER;
1944: l_return_status VARCHAR2(1);
1945: --For DB log
1946: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1947: BEGIN
1948: x_return_status := fnd_api.g_ret_sts_success;
1949:
1950: --Resolve org_id and move_order_type from the passed transaction_temp_id

Line 2030: print_debug('OVPK: fnd_profile WSH_OVERPICK_ENABLED = ' || fnd_profile.VALUE('WSH_OVERPICK_ENABLED'));

2026: -- For a Pick Wave MO lookup the profile WSH_OVERPICKING_ENABLED
2027: -- MO Type 3
2028:
2029: IF (l_debug = 1) THEN
2030: print_debug('OVPK: fnd_profile WSH_OVERPICK_ENABLED = ' || fnd_profile.VALUE('WSH_OVERPICK_ENABLED'));
2031: END IF;
2032:
2033: IF (l_move_order_type = inv_globals.g_move_order_pick_wave
2034: AND NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') = 'Y') THEN

Line 2034: AND NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') = 'Y') THEN

2030: print_debug('OVPK: fnd_profile WSH_OVERPICK_ENABLED = ' || fnd_profile.VALUE('WSH_OVERPICK_ENABLED'));
2031: END IF;
2032:
2033: IF (l_move_order_type = inv_globals.g_move_order_pick_wave
2034: AND NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') = 'Y') THEN
2035: -- OVPK is allowed
2036: x_ovpk_allowed := 1;
2037:
2038: -- Query the TRX_SOURCE_LINE_ID from MMTT for the given transaction_temp_id

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

2213: l_atr NUMBER;
2214: l_alloc_lpn_id mtl_material_transactions_temp.allocated_lpn_id%TYPE;
2215: --l_txn_qty NUMBER;
2216: --For DB log
2217: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2218: BEGIN
2219: x_return_status := fnd_api.g_ret_sts_success;
2220: x_check_overpick_passed := 'N';
2221:

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

2555: l_qr NUMBER;
2556: l_qs NUMBER;
2557: l_atr NUMBER;
2558: --For DB log
2559: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2560: BEGIN
2561: x_return_status := fnd_api.g_ret_sts_success;
2562: x_check_overpick_passed := 'N';
2563:

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

2824: l_max_quantity_allowed NUMBER;
2825: l_avail_req_quantity NUMBER;
2826: l_return_status VARCHAR2(1);
2827: --For DB log
2828: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2829: BEGIN
2830: x_return_status := fnd_api.g_ret_sts_success;
2831:
2832: --Resolve org_id and move_order_type from the passed transaction_temp_id

Line 2913: print_debug('OVPK: fnd_profile WSH_OVERPICK_ENABLED = ' || fnd_profile.VALUE('WSH_OVERPICK_ENABLED'));

2909: -- For a Pick Wave MO lookup the profile WSH_OVERPICKING_ENABLED
2910: -- MO Type 3
2911:
2912: IF (l_debug = 1) THEN
2913: print_debug('OVPK: fnd_profile WSH_OVERPICK_ENABLED = ' || fnd_profile.VALUE('WSH_OVERPICK_ENABLED'));
2914: END IF;
2915:
2916: IF (l_move_order_type = inv_globals.g_move_order_pick_wave
2917: AND NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') = 'Y') THEN

Line 2917: AND NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') = 'Y') THEN

2913: print_debug('OVPK: fnd_profile WSH_OVERPICK_ENABLED = ' || fnd_profile.VALUE('WSH_OVERPICK_ENABLED'));
2914: END IF;
2915:
2916: IF (l_move_order_type = inv_globals.g_move_order_pick_wave
2917: AND NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') = 'Y') THEN
2918: -- OVPK is allowed
2919: x_ovpk_allowed := 1;
2920:
2921: -- Query the TRX_SOURCE_LINE_ID from MMTT for the given transaction_temp_id

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

3099: l_qr NUMBER;
3100: l_qs NUMBER;
3101: l_atr NUMBER;
3102: --For DB log
3103: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3104: BEGIN
3105: x_return_status := fnd_api.g_ret_sts_success;
3106: x_check_overpick_passed := 'N';
3107: