DBA Data[Home] [Help]

APPS.INV_CONSIGNED_VALIDATIONS_GRP dependencies on INV_LOG_UTIL

Line 136: inv_log_util.trace('****** GET_CONSIGNED_QUANTITIES *******','CONSIGNED_VALIDATIONS_GRP',9);

132: fnd_msg_pub.initialize;
133: END IF;
134:
135: IF (l_debug = 1) THEN
136: inv_log_util.trace('****** GET_CONSIGNED_QUANTITIES *******','CONSIGNED_VALIDATIONS_GRP',9);
137: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','
138: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS_GRP',9);
139: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
140: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS_GRP',9);

Line 137: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','

133: END IF;
134:
135: IF (l_debug = 1) THEN
136: inv_log_util.trace('****** GET_CONSIGNED_QUANTITIES *******','CONSIGNED_VALIDATIONS_GRP',9);
137: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','
138: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS_GRP',9);
139: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
140: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS_GRP',9);
141: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS_GRP',9);

Line 139: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||

135: IF (l_debug = 1) THEN
136: inv_log_util.trace('****** GET_CONSIGNED_QUANTITIES *******','CONSIGNED_VALIDATIONS_GRP',9);
137: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','
138: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS_GRP',9);
139: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
140: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS_GRP',9);
141: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS_GRP',9);
142: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS_GRP',9);
143: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||

Line 141: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS_GRP',9);

137: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','
138: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS_GRP',9);
139: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
140: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS_GRP',9);
141: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS_GRP',9);
142: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS_GRP',9);
143: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||
144: p_source_type_id ||',' ||p_demand_source_line_id || ','||
145: p_demand_source_header_id || ',' || p_demand_source_name,'CONSIGNED_VALIDATIONS_GRP',9);

Line 142: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS_GRP',9);

138: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS_GRP',9);
139: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
140: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS_GRP',9);
141: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS_GRP',9);
142: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS_GRP',9);
143: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||
144: p_source_type_id ||',' ||p_demand_source_line_id || ','||
145: p_demand_source_header_id || ',' || p_demand_source_name,'CONSIGNED_VALIDATIONS_GRP',9);
146: inv_log_util.trace(' OnhandSource, CstGroupID, QueryMode: '|| p_onhand_source || ','||

Line 143: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||

139: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
140: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS_GRP',9);
141: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS_GRP',9);
142: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS_GRP',9);
143: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||
144: p_source_type_id ||',' ||p_demand_source_line_id || ','||
145: p_demand_source_header_id || ',' || p_demand_source_name,'CONSIGNED_VALIDATIONS_GRP',9);
146: inv_log_util.trace(' OnhandSource, CstGroupID, QueryMode: '|| p_onhand_source || ','||
147: p_cost_group_id ||',' ||p_query_mode,'CONSIGNED_VALIDATIONS_GRP',9);

Line 146: inv_log_util.trace(' OnhandSource, CstGroupID, QueryMode: '|| p_onhand_source || ','||

142: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS_GRP',9);
143: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||
144: p_source_type_id ||',' ||p_demand_source_line_id || ','||
145: p_demand_source_header_id || ',' || p_demand_source_name,'CONSIGNED_VALIDATIONS_GRP',9);
146: inv_log_util.trace(' OnhandSource, CstGroupID, QueryMode: '|| p_onhand_source || ','||
147: p_cost_group_id ||',' ||p_query_mode,'CONSIGNED_VALIDATIONS_GRP',9);
148: END IF;
149:
150: INV_CONSIGNED_VALIDATIONS.GET_CONSIGNED_QUANTITY(

Line 192: inv_log_util.trace('Finished calling INV_CONSIGNED_VALIDATIONS.GET_CONSIGNED_QUANTITY','CONSIGNED_VALIDATIONS',9);

188:
189: x_return_status := l_return_status;
190:
191: IF(l_debug=1)THEN
192: inv_log_util.trace('Finished calling INV_CONSIGNED_VALIDATIONS.GET_CONSIGNED_QUANTITY','CONSIGNED_VALIDATIONS',9);
193: END IF;
194:
195: EXCEPTION
196: WHEN fnd_api.g_exc_error THEN

Line 311: inv_log_util.trace('*** GET_PLANNING_QUANTITY ***','CONSIGNED_VALIDATIONS_GRP',9);

307: fnd_msg_pub.initialize;
308: END IF;
309:
310: IF (l_debug=1) THEN
311: inv_log_util.trace('*** GET_PLANNING_QUANTITY ***','CONSIGNED_VALIDATIONS_GRP',9);
312: inv_log_util.trace('p_include_nonnet=' || to_char(p_include_nonnet) ||
313: ', p_level=' || to_char(p_level) ||
314: ', p_org_id=' || to_char(p_org_id) ||
315: ', p_subinv=' || p_subinv ||

Line 312: inv_log_util.trace('p_include_nonnet=' || to_char(p_include_nonnet) ||

308: END IF;
309:
310: IF (l_debug=1) THEN
311: inv_log_util.trace('*** GET_PLANNING_QUANTITY ***','CONSIGNED_VALIDATIONS_GRP',9);
312: inv_log_util.trace('p_include_nonnet=' || to_char(p_include_nonnet) ||
313: ', p_level=' || to_char(p_level) ||
314: ', p_org_id=' || to_char(p_org_id) ||
315: ', p_subinv=' || p_subinv ||
316: ', p_item_id=' || to_char(p_item_id)

Line 420: inv_log_util.trace('*** GET_PLANNING_SD_QUANTITY ***','CONSIGNED_VALIDATIONS_GRP',9);

416: fnd_msg_pub.initialize;
417: END IF;
418:
419: IF (l_debug=1) THEN
420: inv_log_util.trace('*** GET_PLANNING_SD_QUANTITY ***','CONSIGNED_VALIDATIONS_GRP',9);
421: inv_log_util.trace('p_onhand_source=' || to_char(p_onhand_source) ||
422: ', p_org_id=' || to_char(p_org_id) ||
423: ', p_item_id=' || to_char(p_item_id)
424: , 'CONSIGNED_VALIDATIONS_GRP', 9);

Line 421: inv_log_util.trace('p_onhand_source=' || to_char(p_onhand_source) ||

417: END IF;
418:
419: IF (l_debug=1) THEN
420: inv_log_util.trace('*** GET_PLANNING_SD_QUANTITY ***','CONSIGNED_VALIDATIONS_GRP',9);
421: inv_log_util.trace('p_onhand_source=' || to_char(p_onhand_source) ||
422: ', p_org_id=' || to_char(p_org_id) ||
423: ', p_item_id=' || to_char(p_item_id)
424: , 'CONSIGNED_VALIDATIONS_GRP', 9);
425: END IF;