APPS.WMS_OP_INBOUND_PVT dependencies on FND_PROFILE

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

83: FROM mtl_transaction_lots_temp
84: WHERE transaction_temp_id=p_source_task_id;
85:
86: l_module_name VARCHAR2(30) := 'INIT';
87: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
88: l_progress NUMBER;
89:
90: l_mtlt_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
91: l_item_details_rec c_item_details%ROWTYPE;

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

518: l_sub_type NUMBER := -1;
519: l_orig_sugges c_orig_sugges%ROWTYPE;
520:
521: l_module_name VARCHAR2(30) := 'ACTIVATE';
522: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
523: l_progress NUMBER;
524:
525: l_msg_data fnd_new_messages.message_text%TYPE;
526: l_return_status VARCHAR2(1);

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

708: , p_inventory_item_id IN NUMBER
709: , p_primary_quantity IN NUMBER
710: )
711: IS
712: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
713: l_return_status VARCHAR2(1);
714: l_msg_count NUMBER;
715: l_msg_data VARCHAR2(400);
716: l_progress NUMBER;

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

979: , p_subsequent_op_plan_id IN NUMBER DEFAULT NULL
980: ) IS
981:
982: l_module_name VARCHAR2(30) := 'COMPLETE';
983: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
984: l_progress NUMBER;
985: l_return_status VARCHAR2(1);
986: l_msg_count NUMBER;
987: l_msg_data VARCHAR2(400);

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

2217: )
2218: IS
2219:
2220: l_module_name VARCHAR2(30) := 'CLEANUP';
2221: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
2222: l_progress NUMBER;
2223:
2224: l_msg_count NUMBER;
2225: l_msg_data VARCHAR2(400);

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

2496: , p_mmtt_error_explanation IN VARCHAR2 DEFAULT NULL
2497: )
2498: IS
2499: l_module_name VARCHAR2(30) := 'CANCEL';
2500: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
2501: l_progress NUMBER;
2502: l_return_status VARCHAR2(1);
2503: l_msg_count NUMBER;
2504: l_msg_data VARCHAR2(400);

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

3005: )
3006: IS
3007: l_progress NUMBER;
3008: l_module_name VARCHAR2(30) := 'ABORT';
3009: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
3010: l_return_status VARCHAR2(1);
3011: l_msg_count NUMBER;
3012: l_msg_data VARCHAR2(400);
3013: