DBA Data[Home] [Help]

APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on FND_PROFILE

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

129: , p_lot_control_code NUMBER
130: , p_serial_control_code NUMBER
131: ) IS
132: l_api_name VARCHAR2(30) := 'REMOVE_CONFIRM';
133: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
134: l_updated_count NUMBER := 0;
135: l_deleted_count NUMBER := 0;
136: BEGIN
137: x_return_status := fnd_api.g_ret_sts_success;

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

214: --INVCONV KKILLAMS
215: , p_secondary_quantity NUMBER DEFAULT NULL
216: --END INVCONV KKILLAMS
217: ) IS
218: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
219: l_api_name VARCHAR2(30) := 'BACKORDER_ONLY';
220: l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
221: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

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

383: , p_split_sec_quantity NUMBER DEFAULT NULL
384: --END INVCONV kkillams
385: ) IS
386: l_api_name VARCHAR2(30) := 'SPLIT_ALLOCATE';
387: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
388:
389: l_txn_header_id NUMBER;
390: l_org_id NUMBER;
391: l_item_id NUMBER;

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

618: l_satt NUMBER;
619: l_sqr NUMBER;
620: -- END INVCONV kkilams
621: l_api_name VARCHAR2(30) := 'REPORT_CYC_CNT';
622: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
623: BEGIN
624: inv_quantity_tree_pub.query_quantities(
625: x_return_status => l_return_status
626: , x_msg_count => l_msg_count

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

711: l_msg_data VARCHAR2(2000);
712: l_msg_count NUMBER;
713:
714: l_api_name VARCHAR2(30) := 'REPORT_CYC_CNT';
715: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
716: /*Bug#3869184. Added the below 2 variables to hold the primary and
717: secondary reservation quantities of the existing Cycle Count Reservation*/
718: l_existing_cc_res_pri_qty NUMBER := 0;
719: l_existing_cc_res_sec_qty NUMBER := 0;

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

983: , p_lot_control_code NUMBER
984: , p_sec_missing_quantity NUMBER --INVCONV kkillams
985: ) IS
986: l_api_name VARCHAR2(30) := 'REPORT_CYC_CNT';
987: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
988:
989: CURSOR c_mmtt_info IS
990: SELECT mmtt.organization_id
991: , mmtt.inventory_item_id

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

1091: , p_transaction_temp_id IN NUMBER
1092: , p_mo_line_id NUMBER
1093: ) IS
1094: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1095: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1096: BEGIN
1097: x_return_status := fnd_api.g_ret_sts_success;
1098:
1099: IF l_debug = 1 THEN

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

1147: , p_transaction_temp_id IN NUMBER
1148: , p_mo_line_id NUMBER
1149: ) IS
1150: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1151: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1152: BEGIN
1153: x_return_status := fnd_api.g_ret_sts_success;
1154:
1155: IF l_debug = 1 THEN

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

1188: , p_transaction_temp_id IN NUMBER
1189: , p_mo_line_id NUMBER
1190: ) IS
1191: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1192: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1193: BEGIN
1194: x_return_status := fnd_api.g_ret_sts_success;
1195:
1196: IF l_debug = 1 THEN

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

1245: , p_lot_control_code NUMBER
1246: , p_serial_control_code NUMBER
1247: ) IS
1248: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1249: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1250: l_lot_control_code NUMBER := p_lot_control_code;
1251: l_serial_control_code NUMBER := p_serial_control_code;
1252: BEGIN
1253: x_return_status := fnd_api.g_ret_sts_success;

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

1345: , p_lot_control_code NUMBER
1346: , p_serial_control_code NUMBER
1347: ) AS
1348: l_api_name VARCHAR2(30) := 'PROCESS_ACTION';
1349: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1350: l_lot_control_code NUMBER := p_lot_control_code;
1351: l_serial_control_code NUMBER := p_serial_control_code;
1352: BEGIN
1353: x_return_status := fnd_api.g_ret_sts_success;

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

1473: --INVCONV kkillams
1474: )
1475: IS
1476: l_api_name VARCHAR2(30) := 'UPDATE_ALLOCATION_QTY';
1477: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1478: l_confirmed_quantity_primary NUMBER;
1479: l_primary_uom VARCHAR2(30);
1480: l_inventory_item_id NUMBER;
1481: l_organization_id NUMBER;