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.INV_SELECT_INVENTORY_PKG dependencies on GMI_RESERVATION_UTIL

Line 141: gmi_reservation_util.println('PROCEDURE get availabe inventory');

137: l_found NUMBER ; -- Fix for Bu#8910862
138: x_dummy BOOLEAN ; -- Fix for 13920680
139:
140: BEGIN
141: gmi_reservation_util.println('PROCEDURE get availabe inventory');
142: wms_engine_pvt.create_suggestions
143: ( p_api_version => 1.0
144: ,x_return_status => l_return_status
145: ,x_msg_count => l_msg_count

Line 154: gmi_reservation_util.println('Get Avail: Fetching Move Order Details') ;

150: );
151:
152: /* Fix for Bug#10170014 Fetch Move Order Details */
153:
154: gmi_reservation_util.println('Get Avail: Fetching Move Order Details') ;
155:
156: open mtl_org_csr(p_mo_line_id) ;
157: fetch mtl_org_csr into mtl_org_rec ;
158: close mtl_org_csr ;

Line 160: gmi_reservation_util.println('Get Avail: rows back '

156: open mtl_org_csr(p_mo_line_id) ;
157: fetch mtl_org_csr into mtl_org_rec ;
158: close mtl_org_csr ;
159:
160: gmi_reservation_util.println('Get Avail: rows back '
161: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
162: gmi_reservation_util.println('Get Avail: inserting the data into the temp');
163: --FOR ALL i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
164:

Line 162: gmi_reservation_util.println('Get Avail: inserting the data into the temp');

158: close mtl_org_csr ;
159:
160: gmi_reservation_util.println('Get Avail: rows back '
161: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
162: gmi_reservation_util.println('Get Avail: inserting the data into the temp');
163: --FOR ALL i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
164:
165: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
166: LOOP

Line 188: gmi_reservation_util.println(' Suggestion already exists') ;

184: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).serial_number is null )
185: and (grade_code = WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).grade_code or
186: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).grade_code is null) ;
187:
188: gmi_reservation_util.println(' Suggestion already exists') ;
189:
190: EXCEPTION
191:
192: WHEN NO_DATA_FOUND THEN

Line 193: gmi_reservation_util.println(' New Suggestion ') ;

189:
190: EXCEPTION
191:
192: WHEN NO_DATA_FOUND THEN
193: gmi_reservation_util.println(' New Suggestion ') ;
194: gmi_reservation_util.println(' Transaction type id ' || mtl_org_rec.transaction_type_id ) ;
195: gmi_reservation_util.println(' Organization_id ' || mtl_org_rec.organization_id ) ;
196: gmi_reservation_util.println(' Inventory Item Id ' || mtl_org_rec.inventory_item_id ) ;
197: gmi_reservation_util.println(' Subinventory code ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).subinventory_code ) ;

Line 194: gmi_reservation_util.println(' Transaction type id ' || mtl_org_rec.transaction_type_id ) ;

190: EXCEPTION
191:
192: WHEN NO_DATA_FOUND THEN
193: gmi_reservation_util.println(' New Suggestion ') ;
194: gmi_reservation_util.println(' Transaction type id ' || mtl_org_rec.transaction_type_id ) ;
195: gmi_reservation_util.println(' Organization_id ' || mtl_org_rec.organization_id ) ;
196: gmi_reservation_util.println(' Inventory Item Id ' || mtl_org_rec.inventory_item_id ) ;
197: gmi_reservation_util.println(' Subinventory code ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).subinventory_code ) ;
198: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ) ;

Line 195: gmi_reservation_util.println(' Organization_id ' || mtl_org_rec.organization_id ) ;

191:
192: WHEN NO_DATA_FOUND THEN
193: gmi_reservation_util.println(' New Suggestion ') ;
194: gmi_reservation_util.println(' Transaction type id ' || mtl_org_rec.transaction_type_id ) ;
195: gmi_reservation_util.println(' Organization_id ' || mtl_org_rec.organization_id ) ;
196: gmi_reservation_util.println(' Inventory Item Id ' || mtl_org_rec.inventory_item_id ) ;
197: gmi_reservation_util.println(' Subinventory code ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).subinventory_code ) ;
198: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ) ;
199: gmi_reservation_util.println(' Lot Number ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number ) ;

Line 196: gmi_reservation_util.println(' Inventory Item Id ' || mtl_org_rec.inventory_item_id ) ;

192: WHEN NO_DATA_FOUND THEN
193: gmi_reservation_util.println(' New Suggestion ') ;
194: gmi_reservation_util.println(' Transaction type id ' || mtl_org_rec.transaction_type_id ) ;
195: gmi_reservation_util.println(' Organization_id ' || mtl_org_rec.organization_id ) ;
196: gmi_reservation_util.println(' Inventory Item Id ' || mtl_org_rec.inventory_item_id ) ;
197: gmi_reservation_util.println(' Subinventory code ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).subinventory_code ) ;
198: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ) ;
199: gmi_reservation_util.println(' Lot Number ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number ) ;
200: gmi_reservation_util.println(' LPN Id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lpn_id ) ;

Line 197: gmi_reservation_util.println(' Subinventory code ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).subinventory_code ) ;

193: gmi_reservation_util.println(' New Suggestion ') ;
194: gmi_reservation_util.println(' Transaction type id ' || mtl_org_rec.transaction_type_id ) ;
195: gmi_reservation_util.println(' Organization_id ' || mtl_org_rec.organization_id ) ;
196: gmi_reservation_util.println(' Inventory Item Id ' || mtl_org_rec.inventory_item_id ) ;
197: gmi_reservation_util.println(' Subinventory code ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).subinventory_code ) ;
198: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ) ;
199: gmi_reservation_util.println(' Lot Number ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number ) ;
200: gmi_reservation_util.println(' LPN Id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lpn_id ) ;
201:

Line 198: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ) ;

194: gmi_reservation_util.println(' Transaction type id ' || mtl_org_rec.transaction_type_id ) ;
195: gmi_reservation_util.println(' Organization_id ' || mtl_org_rec.organization_id ) ;
196: gmi_reservation_util.println(' Inventory Item Id ' || mtl_org_rec.inventory_item_id ) ;
197: gmi_reservation_util.println(' Subinventory code ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).subinventory_code ) ;
198: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ) ;
199: gmi_reservation_util.println(' Lot Number ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number ) ;
200: gmi_reservation_util.println(' LPN Id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lpn_id ) ;
201:
202: gmi_reservation_util.println('fetch the rows, Secondary qty '

Line 199: gmi_reservation_util.println(' Lot Number ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number ) ;

195: gmi_reservation_util.println(' Organization_id ' || mtl_org_rec.organization_id ) ;
196: gmi_reservation_util.println(' Inventory Item Id ' || mtl_org_rec.inventory_item_id ) ;
197: gmi_reservation_util.println(' Subinventory code ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).subinventory_code ) ;
198: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ) ;
199: gmi_reservation_util.println(' Lot Number ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number ) ;
200: gmi_reservation_util.println(' LPN Id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lpn_id ) ;
201:
202: gmi_reservation_util.println('fetch the rows, Secondary qty '
203: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);

Line 200: gmi_reservation_util.println(' LPN Id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lpn_id ) ;

196: gmi_reservation_util.println(' Inventory Item Id ' || mtl_org_rec.inventory_item_id ) ;
197: gmi_reservation_util.println(' Subinventory code ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).subinventory_code ) ;
198: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ) ;
199: gmi_reservation_util.println(' Lot Number ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number ) ;
200: gmi_reservation_util.println(' LPN Id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lpn_id ) ;
201:
202: gmi_reservation_util.println('fetch the rows, Secondary qty '
203: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
204: gmi_reservation_util.println('fetch the rows, grade_code '

Line 202: gmi_reservation_util.println('fetch the rows, Secondary qty '

198: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ) ;
199: gmi_reservation_util.println(' Lot Number ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lot_number ) ;
200: gmi_reservation_util.println(' LPN Id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lpn_id ) ;
201:
202: gmi_reservation_util.println('fetch the rows, Secondary qty '
203: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
204: gmi_reservation_util.println('fetch the rows, grade_code '
205: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).grade_code);
206: /* Fix for Bug#13920680. Validate locator_id for security */

Line 204: gmi_reservation_util.println('fetch the rows, grade_code '

200: gmi_reservation_util.println(' LPN Id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lpn_id ) ;
201:
202: gmi_reservation_util.println('fetch the rows, Secondary qty '
203: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
204: gmi_reservation_util.println('fetch the rows, grade_code '
205: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).grade_code);
206: /* Fix for Bug#13920680. Validate locator_id for security */
207: x_dummy := TRUE ;
208:

Line 223: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ||

219: END IF;
220:
221:
222: IF (x_dummy = TRUE ) THEN
223: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ||
224: ' okay for security rules ' ) ;
225: l_txn_allowed := 'Y' ; -- 14168651
226:
227: /* start Fix for Bug#10170014. */

Line 236: gmi_reservation_util.println(' Calling INV_MATERIAL_STATUS_GRP.Is_status_applicable ') ;

232: ELSE
233: l_wms_installed := 'FALSE' ;
234: END IF ;
235:
236: gmi_reservation_util.println(' Calling INV_MATERIAL_STATUS_GRP.Is_status_applicable ') ;
237:
238: l_txn_allowed := INV_MATERIAL_STATUS_GRP.is_status_applicable
239: (p_wms_installed =>l_wms_installed,
240: p_trx_status_enabled =>NULL,

Line 253: gmi_reservation_util.println(' INV_MATERIAL_STATUS_GRP.Is_status_applicable returns ' || l_txn_allowed ) ;

249: p_serial_number =>NULL ,
250: p_object_type =>'A' ,
251: p_lpn_id =>WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).lpn_id) ;
252:
253: gmi_reservation_util.println(' INV_MATERIAL_STATUS_GRP.Is_status_applicable returns ' || l_txn_allowed ) ;
254: End for #14168651
255: */
256:
257: IF (l_txn_allowed = 'Y') THEN

Line 267: gmi_reservation_util.println(' Subinventory and Locator matches') ;

263: l_insert_allowed := TRUE ;
264: IF (mtl_org_rec.from_locator_id is not null) THEN
265: IF (WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id = mtl_org_rec.from_locator_id ) THEN
266: l_insert_allowed := TRUE ;
267: gmi_reservation_util.println(' Subinventory and Locator matches') ;
268: ELSE
269: l_insert_allowed := FALSE;
270: gmi_reservation_util.println(' Subinventory and Locator does not matches') ;
271: END IF ;

Line 270: gmi_reservation_util.println(' Subinventory and Locator does not matches') ;

266: l_insert_allowed := TRUE ;
267: gmi_reservation_util.println(' Subinventory and Locator matches') ;
268: ELSE
269: l_insert_allowed := FALSE;
270: gmi_reservation_util.println(' Subinventory and Locator does not matches') ;
271: END IF ;
272: ELSE
273: l_insert_allowed := TRUE ;
274: gmi_reservation_util.println(' Subinventory matches') ;

Line 274: gmi_reservation_util.println(' Subinventory matches') ;

270: gmi_reservation_util.println(' Subinventory and Locator does not matches') ;
271: END IF ;
272: ELSE
273: l_insert_allowed := TRUE ;
274: gmi_reservation_util.println(' Subinventory matches') ;
275: END IF ;
276: ELSE
277: l_insert_allowed := FALSE ;
278: gmi_reservation_util.println(' Subinventory does not matches') ;

Line 278: gmi_reservation_util.println(' Subinventory does not matches') ;

274: gmi_reservation_util.println(' Subinventory matches') ;
275: END IF ;
276: ELSE
277: l_insert_allowed := FALSE ;
278: gmi_reservation_util.println(' Subinventory does not matches') ;
279: END IF ;
280: END IF ;
281:
282: /* END Fix for Bug#10170014. */

Line 323: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ||

319: );
320: END IF ;
321: END IF ;
322: ELSE -- 13920680
323: gmi_reservation_util.println(' Locator id ' || WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).locator_id ||
324: ' failed for security rules ' ) ;
325: END IF ; -- 13920680
326: WHEN OTHERS THEN NULL ;
327: