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.GME_PICKING_PVT dependencies on GME_COMMON_PVT

Line 181: gme_common_pvt.count_and_get (x_count => l_msg_count

177: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
178: END IF;
179: EXCEPTION
180: WHEN build_where_err OR pick_material_err THEN
181: gme_common_pvt.count_and_get (x_count => l_msg_count
182: ,x_data => l_msg_data);
183: raise_application_error (-20000, l_msg_data, TRUE);
184: WHEN OTHERS THEN
185: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 196: gme_common_pvt.count_and_get (x_count => l_msg_count

192: || ' Error is '
193: || SQLERRM);
194: END IF;
195:
196: gme_common_pvt.count_and_get (x_count => l_msg_count
197: ,x_data => l_msg_data);
198: raise_application_error (-20001, l_msg_data, TRUE);
199: END conc_picking;
200:

Line 240: gme_common_pvt.get_open_qty (p_mtl_dtl_rec => l_mtl_dtl_rec

236: l_mtl_dtl_rec.dtl_um := p_dtl_um;
237:
238:
239: -- Added p_called_by parameter to be used for Endeca view.
240: gme_common_pvt.get_open_qty (p_mtl_dtl_rec => l_mtl_dtl_rec
241: -- ,p_called_by => 'P'
242: ,p_called_by => p_called_by
243: ,x_open_qty => l_open_qty
244: ,x_return_status => l_return_status);

Line 283: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;

279: l_conc_req_id NUMBER;
280: l_return_status VARCHAR2 (1);
281: l_msg_data VARCHAR2 (2000);
282: l_plan_tasks BOOLEAN;
283: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
284: l_out_mtl_dtl_tbl gme_common_pvt.material_details_tab;
285: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
286: l_trolin_rec inv_move_order_pub.trolin_rec_type;
287:

Line 284: l_out_mtl_dtl_tbl gme_common_pvt.material_details_tab;

280: l_return_status VARCHAR2 (1);
281: l_msg_data VARCHAR2 (2000);
282: l_plan_tasks BOOLEAN;
283: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
284: l_out_mtl_dtl_tbl gme_common_pvt.material_details_tab;
285: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
286: l_trolin_rec inv_move_order_pub.trolin_rec_type;
287:
288: CURSOR cur_pending_move_orders (

Line 297: gme_common_pvt.g_txn_source_type

293: SELECT l.line_id, l.header_id
294: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
295: WHERE l.organization_id = v_org_id
296: AND transaction_source_type_id =
297: gme_common_pvt.g_txn_source_type
298: AND l.txn_source_id = v_batch_id
299: AND l.txn_source_line_id = v_material_detail_id
300: -- Bug 13076579 - exclude those that are already fully detailed.
301: AND l.quantity <> l.quantity_detailed

Line 305: (gme_common_pvt.g_invis_move_order_type

301: AND l.quantity <> l.quantity_detailed
302: AND l.line_status NOT IN (5, 6)
303: AND h.header_id = l.header_id
304: AND h.move_order_type NOT IN
305: (gme_common_pvt.g_invis_move_order_type
306: ,inv_globals.g_move_order_put_away)
307: ORDER BY l.header_id, l.line_id;
308:
309: -- Bug 13076579

Line 324: gme_common_pvt.g_txn_source_type

320: SELECT count(1)
321: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
322: WHERE l.organization_id = v_org_id
323: AND transaction_source_type_id =
324: gme_common_pvt.g_txn_source_type
325: AND l.txn_source_id = v_batch_id
326: AND l.txn_source_line_id = v_material_detail_id
327: AND l.line_status NOT IN (5, 6)
328: AND h.header_id = l.header_id

Line 330: (gme_common_pvt.g_invis_move_order_type

326: AND l.txn_source_line_id = v_material_detail_id
327: AND l.line_status NOT IN (5, 6)
328: AND h.header_id = l.header_id
329: AND h.move_order_type NOT IN
330: (gme_common_pvt.g_invis_move_order_type
331: ,inv_globals.g_move_order_put_away);
332:
333:
334: -- Bug 13076579 - get the sum across all open move orders to see what is still open.

Line 344: gme_common_pvt.g_txn_source_type

340: SELECT NVL(sum(l.quantity - l.quantity_detailed), 0)
341: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
342: WHERE l.organization_id = v_org_id
343: AND transaction_source_type_id =
344: gme_common_pvt.g_txn_source_type
345: AND l.txn_source_id = v_batch_id
346: AND l.txn_source_line_id = v_material_detail_id
347: AND l.line_status NOT IN (5, 6)
348: AND h.header_id = l.header_id

Line 350: (gme_common_pvt.g_invis_move_order_type

346: AND l.txn_source_line_id = v_material_detail_id
347: AND l.line_status NOT IN (5, 6)
348: AND h.header_id = l.header_id
349: AND h.move_order_type NOT IN
350: (gme_common_pvt.g_invis_move_order_type
351: ,inv_globals.g_move_order_put_away)
352: GROUP BY l.txn_source_line_id;
353:
354: TYPE pend_lines_tab IS TABLE OF cur_pending_move_orders%ROWTYPE

Line 388: IF NOT gme_common_pvt.g_setup_done THEN

384: IF (l_count = 0) THEN
385: RAISE no_materials_picked;
386: END IF;
387:
388: IF NOT gme_common_pvt.g_setup_done THEN
389: gme_common_pvt.g_setup_done :=
390: gme_common_pvt.setup
391: (p_org_id => p_mtl_req_tbl (1).organization_id);
392:

Line 389: gme_common_pvt.g_setup_done :=

385: RAISE no_materials_picked;
386: END IF;
387:
388: IF NOT gme_common_pvt.g_setup_done THEN
389: gme_common_pvt.g_setup_done :=
390: gme_common_pvt.setup
391: (p_org_id => p_mtl_req_tbl (1).organization_id);
392:
393: IF NOT gme_common_pvt.g_setup_done THEN

Line 390: gme_common_pvt.setup

386: END IF;
387:
388: IF NOT gme_common_pvt.g_setup_done THEN
389: gme_common_pvt.g_setup_done :=
390: gme_common_pvt.setup
391: (p_org_id => p_mtl_req_tbl (1).organization_id);
392:
393: IF NOT gme_common_pvt.g_setup_done THEN
394: RAISE setup_failure;

Line 393: IF NOT gme_common_pvt.g_setup_done THEN

389: gme_common_pvt.g_setup_done :=
390: gme_common_pvt.setup
391: (p_org_id => p_mtl_req_tbl (1).organization_id);
392:
393: IF NOT gme_common_pvt.g_setup_done THEN
394: RAISE setup_failure;
395: END IF;
396: END IF;
397:

Line 406: ,p_move_order_type => gme_common_pvt.g_move_order_type

402: -- Bug 13076579 - Moved creation of MO hdr inside loop to avoid creating it unnecessarily.
403: /*
404: gme_move_orders_pvt.create_move_order_hdr
405: (p_organization_id => p_mtl_req_tbl (1).organization_id
406: ,p_move_order_type => gme_common_pvt.g_move_order_type
407: ,p_grouping_rule_id => p_task_group_id -- Bug 9941121
408: ,x_move_order_header_id => l_move_order_header_id
409: ,x_return_status => l_return_status);
410:

Line 458: ,p_move_order_type => gme_common_pvt.g_move_order_type

454: -- Bug 13076579 - Do not create a move order hdr if not needed.
455: IF l_hdr_created = 0 THEN
456: gme_move_orders_pvt.create_move_order_hdr
457: (p_organization_id => p_mtl_req_tbl (1).organization_id
458: ,p_move_order_type => gme_common_pvt.g_move_order_type
459: ,p_grouping_rule_id => p_task_group_id -- Bug 9941121
460: ,x_move_order_header_id => l_move_order_header_id
461: ,x_return_status => l_return_status);
462:

Line 492: l_mtl_dtl_tbl (l_index).line_type := gme_common_pvt.g_line_type_ing;

488: l_mtl_dtl_tbl (l_index).material_requirement_date :=
489: p_mtl_req_tbl (i).mtl_req_date;
490: l_mtl_dtl_tbl (l_index).subinventory := p_mtl_req_tbl (i).subinventory;
491: l_mtl_dtl_tbl (l_index).locator_id := p_mtl_req_tbl (i).locator_id;
492: l_mtl_dtl_tbl (l_index).line_type := gme_common_pvt.g_line_type_ing;
493: END IF;
494: END LOOP;
495:
496: -- Try to allocate any other move order lines that exist and are not allocated. These could

Line 520: ,p_move_order_type => gme_common_pvt.g_move_order_type

516: END IF;
517:
518: gme_move_orders_pvt.create_move_order_lines
519: (p_move_order_header_id => l_move_order_header_id
520: ,p_move_order_type => gme_common_pvt.g_move_order_type
521: ,p_material_details_tbl => l_mtl_dtl_tbl
522: ,x_material_details_tbl => l_out_mtl_dtl_tbl
523: ,x_trolin_tbl => l_trolin_tbl
524: ,x_return_status => l_return_status);

Line 608: gme_common_pvt.log_message

604: END IF;
605:
606: IF (l_conc_req_id IS NOT NULL) THEN
607: IF (NOT (g_partially_allocated) AND NOT (g_not_allocated) ) THEN
608: gme_common_pvt.log_message
609: (p_message_code => 'GME_PICKED_ALL_PRINTED'
610: ,p_token1_name => 'MO_NUMBER'
611: ,p_token1_value => l_move_order_header_id
612: ,p_token2_name => 'CONC_REQUEST_ID'

Line 618: gme_common_pvt.log_message

614: IF g_debug <= gme_debug.g_log_unexpected THEN
615: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
616: END IF;
617: ELSIF (g_partially_allocated OR g_fully_allocated) THEN
618: gme_common_pvt.log_message
619: (p_message_code => 'GME_PICKED_PARTIAL_PRINTED'
620: ,p_token1_name => 'MO_NUMBER'
621: ,p_token1_value => l_move_order_header_id
622: ,p_token2_name => 'CONC_REQUEST_ID'

Line 630: gme_common_pvt.log_message

626: END IF;
627: END IF;
628: ELSE
629: IF (NOT (g_partially_allocated) AND NOT (g_not_allocated) ) THEN
630: gme_common_pvt.log_message
631: (p_message_code => 'GME_PICKED_ALL'
632: ,p_token1_name => 'MO_NUMBER'
633: ,p_token1_value => l_move_order_header_id);
634: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 638: gme_common_pvt.log_message

634: IF g_debug <= gme_debug.g_log_unexpected THEN
635: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
636: END IF;
637: ELSIF (g_partially_allocated OR g_fully_allocated) THEN
638: gme_common_pvt.log_message
639: (p_message_code => 'GME_PICKED_PARTIAL'
640: ,p_token1_name => 'MO_NUMBER'
641: ,p_token1_value => l_move_order_header_id);
642: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 646: gme_common_pvt.log_message

642: IF g_debug <= gme_debug.g_log_unexpected THEN
643: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
644: END IF;
645: ELSIF (NOT (g_partially_allocated) AND NOT (g_fully_allocated) ) THEN
646: gme_common_pvt.log_message
647: (p_message_code => 'GME_PICKED_NO_ALLOC'
648: ,p_token1_name => 'MO_NUMBER'
649: ,p_token1_value => l_move_order_header_id);
650: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 664: --gme_common_pvt.log_message ('GME_NO_MATERIALS_SELECTED');

660: WHEN no_materials_picked THEN
661: --Bug#5311713
662: FND_MESSAGE.SET_NAME('GME','GME_NO_MATERIALS_SELECTED');
663: FND_FILE.PUT_LINE(FND_FILE.log,FND_MESSAGE.GET);
664: --gme_common_pvt.log_message ('GME_NO_MATERIALS_SELECTED');
665: --x_return_status := fnd_api.g_ret_sts_error;
666: WHEN setup_failure THEN
667: x_return_status := fnd_api.g_ret_sts_error;
668: WHEN create_move_order_err OR process_line_err OR print_pickslip_err THEN

Line 752: l_resv_tbl gme_common_pvt.reservations_tab;

748: l_move_order_header_id NUMBER;
749: l_return_status VARCHAR2 (1);
750: l_plan_tasks BOOLEAN;
751: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
752: l_resv_tbl gme_common_pvt.reservations_tab;
753: l_inv_resv_tbl inv_reservation_global.mtl_reservation_tbl_type;
754: create_suggestions_err EXCEPTION;
755: get_pick_slip_err EXCEPTION;
756: BEGIN

Line 1144: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch

1140: END IF;
1141:
1142: UPDATE mtl_material_transactions_temp
1143: SET pick_slip_number = l_pick_slip_number,
1144: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
1145: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
1146: ELSE
1147: UPDATE mtl_material_transactions_temp
1148: SET wip_entity_type = gme_common_pvt.g_wip_entity_type_batch

Line 1148: SET wip_entity_type = gme_common_pvt.g_wip_entity_type_batch

1144: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
1145: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
1146: ELSE
1147: UPDATE mtl_material_transactions_temp
1148: SET wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
1149: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
1150: END IF;
1151: END LOOP;
1152: --End of for loop for get_mmtt IN cur_mmtt (p_mo_line_rec.line_id)