329: PROCEDURE mydebug(p_message IN VARCHAR2, p_module IN VARCHAR2)
330: IS
331: BEGIN
332: IF (g_debug = 1) THEN
333: inv_log_util.trace(p_message, p_module, 9);
334: END IF;
335: END mydebug;
336:
337: PROCEDURE update_loaded_part
14932: RAISE fnd_api.g_exc_unexpected_error;
14933: END IF;
14934:
14935: IF(l_debug=1) THEN
14936: inv_log_util.trace( 'Value of p_transaction_type_id : ' ||p_transaction_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
14937: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside check_exp_lot_txn_allowed ', 9);
14938: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
14939: END IF;
14940: --12871057 End Fetching the action and source type from cache for the txn type id
14933: END IF;
14934:
14935: IF(l_debug=1) THEN
14936: inv_log_util.trace( 'Value of p_transaction_type_id : ' ||p_transaction_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
14937: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside check_exp_lot_txn_allowed ', 9);
14938: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
14939: END IF;
14940: --12871057 End Fetching the action and source type from cache for the txn type id
14941:
14934:
14935: IF(l_debug=1) THEN
14936: inv_log_util.trace( 'Value of p_transaction_type_id : ' ||p_transaction_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
14937: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside check_exp_lot_txn_allowed ', 9);
14938: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
14939: END IF;
14940: --12871057 End Fetching the action and source type from cache for the txn type id
14941:
14942: IF (p_transaction_action_id = 28 OR (l_txn_source_type_id =4 AND l_transaction_action_id =1) OR (l_txn_source_type_id =4 AND l_transaction_action_id =2)) --12871057
15928: RAISE fnd_api.g_exc_unexpected_error;
15929: END IF;
15930:
15931: IF(l_debug=1) THEN
15932: inv_log_util.trace( 'Value of p_transaction_type_id : ' ||p_transaction_type_id, 'Inside Update_Tree_Flex_Lot ', 9);
15933: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside Update_Tree_Flex_Lot ', 9);
15934: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside Update_Tree_Flex_Lot ', 9);
15935: END IF;
15936:
15929: END IF;
15930:
15931: IF(l_debug=1) THEN
15932: inv_log_util.trace( 'Value of p_transaction_type_id : ' ||p_transaction_type_id, 'Inside Update_Tree_Flex_Lot ', 9);
15933: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside Update_Tree_Flex_Lot ', 9);
15934: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside Update_Tree_Flex_Lot ', 9);
15935: END IF;
15936:
15937: IF (p_transaction_action_id = 28
15930:
15931: IF(l_debug=1) THEN
15932: inv_log_util.trace( 'Value of p_transaction_type_id : ' ||p_transaction_type_id, 'Inside Update_Tree_Flex_Lot ', 9);
15933: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside Update_Tree_Flex_Lot ', 9);
15934: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside Update_Tree_Flex_Lot ', 9);
15935: END IF;
15936:
15937: IF (p_transaction_action_id = 28
15938: OR (l_txn_source_type_id = 4 AND p_transaction_action_id =1)