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.WMS_ENGINE_PVT dependencies on INV_LOG_UTIL

Line 56: inv_log_util.trace(p_message, l_module, 9);

52:
53: BEGIN
54: --l_progress := l_progress + 10;
55: l_module:= 'wms.plsql.'||g_pkg_name || '.' || p_api_name || '.' || p_label;
56: inv_log_util.trace(p_message, l_module, 9);
57: /*
58: fnd_log.STRING(log_level => fnd_log.level_event,
59: module => l_module, message => p_message);
60: gmi_reservation_util.println(p_message); */

Line 67: inv_log_util.trace(p_message, l_module, 9);

63: PROCEDURE log_error(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
64: l_module VARCHAR2(255);
65: BEGIN
66: l_module:= 'wms.plsql.'||g_pkg_name || '.' || p_api_name || '.' || p_label;
67: inv_log_util.trace(p_message, l_module, 9);
68:
69: /*fnd_log.STRING(log_level => fnd_log.level_error,
70: module => l_module, message => p_message);
71: gmi_reservation_util.println(p_message);*/

Line 78: inv_log_util.trace(p_label, l_module, 9);

74: PROCEDURE log_error_msg(p_api_name VARCHAR2, p_label VARCHAR2) IS
75: l_module VARCHAR2(255);
76: BEGIN
77: l_module:= 'wms.plsql.'|| g_pkg_name ||'.' || p_api_name || '.' || p_label;
78: inv_log_util.trace(p_label, l_module, 9);
79: /*
80: fnd_log.message(log_level => fnd_log.level_error,
81: module => l_module, pop_message => FALSE);
82: inv_log_util.trace(p_label, l_module, 9);

Line 82: inv_log_util.trace(p_label, l_module, 9);

78: inv_log_util.trace(p_label, l_module, 9);
79: /*
80: fnd_log.message(log_level => fnd_log.level_error,
81: module => l_module, pop_message => FALSE);
82: inv_log_util.trace(p_label, l_module, 9);
83: gmi_reservation_util.println(p_label); */
84: END log_error_msg;
85:
86: PROCEDURE log_procedure(p_api_name VARCHAR2

Line 93: inv_log_util.trace(p_message, l_module, 9);

89: l_module VARCHAR2(255);
90: BEGIN
91:
92: l_module:= 'wms.plsql.'||g_pkg_name || '.' || p_api_name || '.' || p_label;
93: inv_log_util.trace(p_message, l_module, 9);
94: /*
95: fnd_log.STRING(log_level => fnd_log.level_procedure,
96: module => l_module, message => p_message);
97: inv_log_util.trace(p_message, l_module, 9);

Line 97: inv_log_util.trace(p_message, l_module, 9);

93: inv_log_util.trace(p_message, l_module, 9);
94: /*
95: fnd_log.STRING(log_level => fnd_log.level_procedure,
96: module => l_module, message => p_message);
97: inv_log_util.trace(p_message, l_module, 9);
98: gmi_reservation_util.println(p_message);*/
99: END log_procedure;
100:
101: PROCEDURE log_statement(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS

Line 105: inv_log_util.trace(p_message, l_module, 9);

101: PROCEDURE log_statement(p_api_name VARCHAR2, p_label VARCHAR2, p_message VARCHAR2) IS
102: l_module VARCHAR2(255);
103: BEGIN
104: l_module := 'wms.plsql.' || g_pkg_name || '.' || p_api_name || '.' || p_label;
105: inv_log_util.trace(p_message, l_module, 9);
106: /*
107: fnd_log.STRING(log_level => fnd_log.level_statement, module => l_module, message => p_message);
108: IF inv_pp_debug.is_debug_mode THEN
109: inv_pp_debug.send_message_to_pipe(p_message);

Line 111: inv_log_util.trace(p_message, l_module, 9);

107: fnd_log.STRING(log_level => fnd_log.level_statement, module => l_module, message => p_message);
108: IF inv_pp_debug.is_debug_mode THEN
109: inv_pp_debug.send_message_to_pipe(p_message);
110: END IF;
111: inv_log_util.trace(p_message, l_module, 9);
112: gmi_reservation_util.println(p_message); */
113: END log_statement;
114:
115:

Line 3040: inv_log_util.trace( 'Value of organization_id is : ' ||l_organization_id, 'Inside check_exp_lot_txn_allowed ' , 9);

3036: RAISE fnd_api.g_exc_unexpected_error;
3037: END IF;
3038:
3039: IF(l_debug=1) THEN
3040: inv_log_util.trace( 'Value of organization_id is : ' ||l_organization_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3041: inv_log_util.trace( 'Value of inventory_item_id is : ' ||l_inventory_item_id, 'Inside check_exp_lot_txn_allowed ', 9);
3042: inv_log_util.trace( 'Value of l_transaction_source_type_id is: ' ||l_transaction_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3043: inv_log_util.trace( 'Value of l_txn_source_line_id is : ' ||l_txn_source_line_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3044: inv_log_util.trace( 'Value of l_is_item_lot_controlled is : ' ||l_is_item_lot_controlled, 'Inside check_exp_lot_txn_allowed ', 9);

Line 3041: inv_log_util.trace( 'Value of inventory_item_id is : ' ||l_inventory_item_id, 'Inside check_exp_lot_txn_allowed ', 9);

3037: END IF;
3038:
3039: IF(l_debug=1) THEN
3040: inv_log_util.trace( 'Value of organization_id is : ' ||l_organization_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3041: inv_log_util.trace( 'Value of inventory_item_id is : ' ||l_inventory_item_id, 'Inside check_exp_lot_txn_allowed ', 9);
3042: inv_log_util.trace( 'Value of l_transaction_source_type_id is: ' ||l_transaction_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3043: inv_log_util.trace( 'Value of l_txn_source_line_id is : ' ||l_txn_source_line_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3044: inv_log_util.trace( 'Value of l_is_item_lot_controlled is : ' ||l_is_item_lot_controlled, 'Inside check_exp_lot_txn_allowed ', 9);
3045: inv_log_util.trace( 'Value of l_allow_expired_lot_txn is : ' ||l_allow_expired_lot_txn, 'Inside check_exp_lot_txn_allowed ' , 9);

Line 3042: inv_log_util.trace( 'Value of l_transaction_source_type_id is: ' ||l_transaction_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);

3038:
3039: IF(l_debug=1) THEN
3040: inv_log_util.trace( 'Value of organization_id is : ' ||l_organization_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3041: inv_log_util.trace( 'Value of inventory_item_id is : ' ||l_inventory_item_id, 'Inside check_exp_lot_txn_allowed ', 9);
3042: inv_log_util.trace( 'Value of l_transaction_source_type_id is: ' ||l_transaction_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3043: inv_log_util.trace( 'Value of l_txn_source_line_id is : ' ||l_txn_source_line_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3044: inv_log_util.trace( 'Value of l_is_item_lot_controlled is : ' ||l_is_item_lot_controlled, 'Inside check_exp_lot_txn_allowed ', 9);
3045: inv_log_util.trace( 'Value of l_allow_expired_lot_txn is : ' ||l_allow_expired_lot_txn, 'Inside check_exp_lot_txn_allowed ' , 9);
3046: END IF;

Line 3043: inv_log_util.trace( 'Value of l_txn_source_line_id is : ' ||l_txn_source_line_id, 'Inside check_exp_lot_txn_allowed ' , 9);

3039: IF(l_debug=1) THEN
3040: inv_log_util.trace( 'Value of organization_id is : ' ||l_organization_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3041: inv_log_util.trace( 'Value of inventory_item_id is : ' ||l_inventory_item_id, 'Inside check_exp_lot_txn_allowed ', 9);
3042: inv_log_util.trace( 'Value of l_transaction_source_type_id is: ' ||l_transaction_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3043: inv_log_util.trace( 'Value of l_txn_source_line_id is : ' ||l_txn_source_line_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3044: inv_log_util.trace( 'Value of l_is_item_lot_controlled is : ' ||l_is_item_lot_controlled, 'Inside check_exp_lot_txn_allowed ', 9);
3045: inv_log_util.trace( 'Value of l_allow_expired_lot_txn is : ' ||l_allow_expired_lot_txn, 'Inside check_exp_lot_txn_allowed ' , 9);
3046: END IF;
3047:

Line 3044: inv_log_util.trace( 'Value of l_is_item_lot_controlled is : ' ||l_is_item_lot_controlled, 'Inside check_exp_lot_txn_allowed ', 9);

3040: inv_log_util.trace( 'Value of organization_id is : ' ||l_organization_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3041: inv_log_util.trace( 'Value of inventory_item_id is : ' ||l_inventory_item_id, 'Inside check_exp_lot_txn_allowed ', 9);
3042: inv_log_util.trace( 'Value of l_transaction_source_type_id is: ' ||l_transaction_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3043: inv_log_util.trace( 'Value of l_txn_source_line_id is : ' ||l_txn_source_line_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3044: inv_log_util.trace( 'Value of l_is_item_lot_controlled is : ' ||l_is_item_lot_controlled, 'Inside check_exp_lot_txn_allowed ', 9);
3045: inv_log_util.trace( 'Value of l_allow_expired_lot_txn is : ' ||l_allow_expired_lot_txn, 'Inside check_exp_lot_txn_allowed ' , 9);
3046: END IF;
3047:
3048:

Line 3045: inv_log_util.trace( 'Value of l_allow_expired_lot_txn is : ' ||l_allow_expired_lot_txn, 'Inside check_exp_lot_txn_allowed ' , 9);

3041: inv_log_util.trace( 'Value of inventory_item_id is : ' ||l_inventory_item_id, 'Inside check_exp_lot_txn_allowed ', 9);
3042: inv_log_util.trace( 'Value of l_transaction_source_type_id is: ' ||l_transaction_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3043: inv_log_util.trace( 'Value of l_txn_source_line_id is : ' ||l_txn_source_line_id, 'Inside check_exp_lot_txn_allowed ' , 9);
3044: inv_log_util.trace( 'Value of l_is_item_lot_controlled is : ' ||l_is_item_lot_controlled, 'Inside check_exp_lot_txn_allowed ', 9);
3045: inv_log_util.trace( 'Value of l_allow_expired_lot_txn is : ' ||l_allow_expired_lot_txn, 'Inside check_exp_lot_txn_allowed ' , 9);
3046: END IF;
3047:
3048:
3049: IF (l_is_item_lot_controlled = 1) THEN --If the item is not lot controlled then we need to allow transaction it does not matter as its not lot item.

Line 3051: inv_log_util.trace('This is not lot controlled item ' ||l_is_item_lot_controlled, 'We dont care as there is no question of lot expiration ' ,9);

3047:
3048:
3049: IF (l_is_item_lot_controlled = 1) THEN --If the item is not lot controlled then we need to allow transaction it does not matter as its not lot item.
3050: IF(l_debug=1) THEN
3051: inv_log_util.trace('This is not lot controlled item ' ||l_is_item_lot_controlled, 'We dont care as there is no question of lot expiration ' ,9);
3052: END IF;
3053: l_allow_expired_lot_txn := 1;
3054: RETURN TRUE;
3055: END IF;

Line 3065: inv_log_util.trace( 'Value of l_transaction_type_id : ' ||l_transaction_type_id, 'Inside check_exp_lot_txn_allowed ', 9);

3061: RAISE fnd_api.g_exc_unexpected_error;
3062: END IF;
3063:
3064: IF(l_debug=1) THEN
3065: inv_log_util.trace( 'Value of l_transaction_type_id : ' ||l_transaction_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3066: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside check_exp_lot_txn_allowed ', 9);
3067: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3068: END IF;
3069:

Line 3066: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside check_exp_lot_txn_allowed ', 9);

3062: END IF;
3063:
3064: IF(l_debug=1) THEN
3065: inv_log_util.trace( 'Value of l_transaction_type_id : ' ||l_transaction_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3066: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside check_exp_lot_txn_allowed ', 9);
3067: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3068: END IF;
3069:
3070: l_value_from_user_pkg_lot := USER_PKG_LOT.use_expired_lots (

Line 3067: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);

3063:
3064: IF(l_debug=1) THEN
3065: inv_log_util.trace( 'Value of l_transaction_type_id : ' ||l_transaction_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3066: inv_log_util.trace( 'Value of l_transaction_action_id : ' ||l_transaction_action_id, 'Inside check_exp_lot_txn_allowed ', 9);
3067: inv_log_util.trace( 'Value of l_txn_source_type_id : ' ||l_txn_source_type_id, 'Inside check_exp_lot_txn_allowed ', 9);
3068: END IF;
3069:
3070: l_value_from_user_pkg_lot := USER_PKG_LOT.use_expired_lots (
3071: p_organization_id => l_organization_id

Line 3081: inv_log_util.trace( 'The USER_PKG_LOT returned TRUE and so we will allow expired lots to be transaced::: ' , 'Coming from USER_PKG_LOT.use_expired_lots ', 9);

3077: --Condition to check user_pkg_lot for expired lot allocation
3078: IF (l_value_from_user_pkg_lot) THEN --IF the use hook returns TRUE means they want expired lots to be allocated
3079:
3080: IF(l_debug = 1) THEN
3081: inv_log_util.trace( 'The USER_PKG_LOT returned TRUE and so we will allow expired lots to be transaced::: ' , 'Coming from USER_PKG_LOT.use_expired_lots ', 9);
3082: END IF;
3083: l_allow_expired_lot_txn := 1;
3084: RETURN TRUE;
3085: END IF;

Line 3091: inv_log_util.trace( 'The transaction being done allows expired lots to be transaced action_id ' ||l_transaction_action_id, 'Coming from seeded txn for which expired lot allocation is allowed ', 9);

3087: --Condition to allow expired lot allocation in certain transctions like Sub Txer or MO Txfer etc
3088: IF ((l_transaction_action_id = 2 AND l_txn_source_type_id = 13 AND l_transaction_type_id <> 51) OR --Allow expired lot allocation in Sub Txfer but do not allow it for Backflush txfer
3089: (l_transaction_action_id = 2 AND l_txn_source_type_id = 4)) THEN --Allow expired lot allocaiton in MO Txfer
3090: IF(l_debug = 1) THEN
3091: inv_log_util.trace( 'The transaction being done allows expired lots to be transaced action_id ' ||l_transaction_action_id, 'Coming from seeded txn for which expired lot allocation is allowed ', 9);
3092: inv_log_util.trace( 'The transaction being done allows expired lots to be transaced txn_source_type_id ' ||l_transaction_action_id, 'Coming from seeded txn for which expired lot allocation is allowed ', 9);
3093: END IF;
3094: l_allow_expired_lot_txn := 1;
3095: RETURN TRUE;

Line 3092: inv_log_util.trace( 'The transaction being done allows expired lots to be transaced txn_source_type_id ' ||l_transaction_action_id, 'Coming from seeded txn for which expired lot allocation is allowed ', 9);

3088: IF ((l_transaction_action_id = 2 AND l_txn_source_type_id = 13 AND l_transaction_type_id <> 51) OR --Allow expired lot allocation in Sub Txfer but do not allow it for Backflush txfer
3089: (l_transaction_action_id = 2 AND l_txn_source_type_id = 4)) THEN --Allow expired lot allocaiton in MO Txfer
3090: IF(l_debug = 1) THEN
3091: inv_log_util.trace( 'The transaction being done allows expired lots to be transaced action_id ' ||l_transaction_action_id, 'Coming from seeded txn for which expired lot allocation is allowed ', 9);
3092: inv_log_util.trace( 'The transaction being done allows expired lots to be transaced txn_source_type_id ' ||l_transaction_action_id, 'Coming from seeded txn for which expired lot allocation is allowed ', 9);
3093: END IF;
3094: l_allow_expired_lot_txn := 1;
3095: RETURN TRUE;
3096: END IF;

Line 3099: inv_log_util.trace('The final value of l_allow_expired_lot_txn' ||l_allow_expired_lot_txn , 'This is a lot controlled item ' , 9);

3095: RETURN TRUE;
3096: END IF;
3097:
3098: IF(l_debug=1) THEN
3099: inv_log_util.trace('The final value of l_allow_expired_lot_txn' ||l_allow_expired_lot_txn , 'This is a lot controlled item ' , 9);
3100: END IF;
3101:
3102:
3103: IF l_allow_expired_lot_txn >= 1 THEN