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 162: gme_common_pvt.count_and_get (x_count => l_msg_count

158: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
159: END IF;
160: EXCEPTION
161: WHEN build_where_err OR pick_material_err THEN
162: gme_common_pvt.count_and_get (x_count => l_msg_count
163: ,x_data => l_msg_data);
164: raise_application_error (-20000, l_msg_data, TRUE);
165: WHEN OTHERS THEN
166: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 177: gme_common_pvt.count_and_get (x_count => l_msg_count

173: || ' Error is '
174: || SQLERRM);
175: END IF;
176:
177: gme_common_pvt.count_and_get (x_count => l_msg_count
178: ,x_data => l_msg_data);
179: raise_application_error (-20001, l_msg_data, TRUE);
180: END conc_picking;
181:

Line 216: gme_common_pvt.get_open_qty (p_mtl_dtl_rec => l_mtl_dtl_rec

212: l_mtl_dtl_rec.wip_plan_qty := p_wip_plan_qty;
213: l_mtl_dtl_rec.actual_qty := p_actual_qty;
214: l_mtl_dtl_rec.backordered_qty := p_backordered_qty;
215: l_mtl_dtl_rec.dtl_um := p_dtl_um;
216: gme_common_pvt.get_open_qty (p_mtl_dtl_rec => l_mtl_dtl_rec
217: ,p_called_by => 'P'
218: ,x_open_qty => l_open_qty
219: ,x_return_status => l_return_status);
220:

Line 258: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;

254: l_conc_req_id NUMBER;
255: l_return_status VARCHAR2 (1);
256: l_msg_data VARCHAR2 (2000);
257: l_plan_tasks BOOLEAN;
258: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
259: l_out_mtl_dtl_tbl gme_common_pvt.material_details_tab;
260: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
261: l_trolin_rec inv_move_order_pub.trolin_rec_type;
262:

Line 259: l_out_mtl_dtl_tbl gme_common_pvt.material_details_tab;

255: l_return_status VARCHAR2 (1);
256: l_msg_data VARCHAR2 (2000);
257: l_plan_tasks BOOLEAN;
258: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
259: l_out_mtl_dtl_tbl gme_common_pvt.material_details_tab;
260: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
261: l_trolin_rec inv_move_order_pub.trolin_rec_type;
262:
263: CURSOR cur_pending_move_orders (

Line 272: gme_common_pvt.g_txn_source_type

268: SELECT l.line_id, l.header_id
269: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
270: WHERE l.organization_id = v_org_id
271: AND transaction_source_type_id =
272: gme_common_pvt.g_txn_source_type
273: AND l.txn_source_id = v_batch_id
274: AND l.txn_source_line_id = v_material_detail_id
275: AND l.line_status NOT IN (5, 6)
276: AND h.header_id = l.header_id

Line 278: (gme_common_pvt.g_invis_move_order_type

274: AND l.txn_source_line_id = v_material_detail_id
275: AND l.line_status NOT IN (5, 6)
276: AND h.header_id = l.header_id
277: AND h.move_order_type NOT IN
278: (gme_common_pvt.g_invis_move_order_type
279: ,inv_globals.g_move_order_put_away)
280: ORDER BY l.header_id, l.line_id;
281:
282: TYPE pend_lines_tab IS TABLE OF cur_pending_move_orders%ROWTYPE

Line 316: IF NOT gme_common_pvt.g_setup_done THEN

312: IF (l_count = 0) THEN
313: RAISE no_materials_picked;
314: END IF;
315:
316: IF NOT gme_common_pvt.g_setup_done THEN
317: gme_common_pvt.g_setup_done :=
318: gme_common_pvt.setup
319: (p_org_id => p_mtl_req_tbl (1).organization_id);
320:

Line 317: gme_common_pvt.g_setup_done :=

313: RAISE no_materials_picked;
314: END IF;
315:
316: IF NOT gme_common_pvt.g_setup_done THEN
317: gme_common_pvt.g_setup_done :=
318: gme_common_pvt.setup
319: (p_org_id => p_mtl_req_tbl (1).organization_id);
320:
321: IF NOT gme_common_pvt.g_setup_done THEN

Line 318: gme_common_pvt.setup

314: END IF;
315:
316: IF NOT gme_common_pvt.g_setup_done THEN
317: gme_common_pvt.g_setup_done :=
318: gme_common_pvt.setup
319: (p_org_id => p_mtl_req_tbl (1).organization_id);
320:
321: IF NOT gme_common_pvt.g_setup_done THEN
322: RAISE setup_failure;

Line 321: IF NOT gme_common_pvt.g_setup_done THEN

317: gme_common_pvt.g_setup_done :=
318: gme_common_pvt.setup
319: (p_org_id => p_mtl_req_tbl (1).organization_id);
320:
321: IF NOT gme_common_pvt.g_setup_done THEN
322: RAISE setup_failure;
323: END IF;
324: END IF;
325:

Line 332: ,p_move_order_type => gme_common_pvt.g_move_order_type

328: END IF;
329:
330: gme_move_orders_pvt.create_move_order_hdr
331: (p_organization_id => p_mtl_req_tbl (1).organization_id
332: ,p_move_order_type => gme_common_pvt.g_move_order_type
333: ,x_move_order_header_id => l_move_order_header_id
334: ,x_return_status => l_return_status);
335:
336: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 363: l_mtl_dtl_tbl (i).line_type := gme_common_pvt.g_line_type_ing;

359: l_mtl_dtl_tbl (i).material_requirement_date :=
360: p_mtl_req_tbl (i).mtl_req_date;
361: l_mtl_dtl_tbl (i).subinventory := p_mtl_req_tbl (i).subinventory;
362: l_mtl_dtl_tbl (i).locator_id := p_mtl_req_tbl (i).locator_id;
363: l_mtl_dtl_tbl (i).line_type := gme_common_pvt.g_line_type_ing;
364: END LOOP;
365:
366: /* Try to allocate any other move order lines that exist and are not allocated
367: These could be move orders created during batch create */

Line 390: ,p_move_order_type => gme_common_pvt.g_move_order_type

386: END IF;
387:
388: gme_move_orders_pvt.create_move_order_lines
389: (p_move_order_header_id => l_move_order_header_id
390: ,p_move_order_type => gme_common_pvt.g_move_order_type
391: ,p_material_details_tbl => l_mtl_dtl_tbl
392: ,x_material_details_tbl => l_out_mtl_dtl_tbl
393: ,x_trolin_tbl => l_trolin_tbl
394: ,x_return_status => l_return_status);

Line 477: gme_common_pvt.log_message

473: END IF;
474:
475: IF (l_conc_req_id IS NOT NULL) THEN
476: IF (NOT (g_partially_allocated) AND NOT (g_not_allocated) ) THEN
477: gme_common_pvt.log_message
478: (p_message_code => 'GME_PICKED_ALL_PRINTED'
479: ,p_token1_name => 'MO_NUMBER'
480: ,p_token1_value => l_move_order_header_id
481: ,p_token2_name => 'CONC_REQUEST_ID'

Line 487: gme_common_pvt.log_message

483: IF g_debug <= gme_debug.g_log_unexpected THEN
484: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
485: END IF;
486: ELSIF (g_partially_allocated OR g_fully_allocated) THEN
487: gme_common_pvt.log_message
488: (p_message_code => 'GME_PICKED_PARTIAL_PRINTED'
489: ,p_token1_name => 'MO_NUMBER'
490: ,p_token1_value => l_move_order_header_id
491: ,p_token2_name => 'CONC_REQUEST_ID'

Line 499: gme_common_pvt.log_message

495: END IF;
496: END IF;
497: ELSE
498: IF (NOT (g_partially_allocated) AND NOT (g_not_allocated) ) THEN
499: gme_common_pvt.log_message
500: (p_message_code => 'GME_PICKED_ALL'
501: ,p_token1_name => 'MO_NUMBER'
502: ,p_token1_value => l_move_order_header_id);
503: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 507: gme_common_pvt.log_message

503: IF g_debug <= gme_debug.g_log_unexpected THEN
504: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
505: END IF;
506: ELSIF (g_partially_allocated OR g_fully_allocated) THEN
507: gme_common_pvt.log_message
508: (p_message_code => 'GME_PICKED_PARTIAL'
509: ,p_token1_name => 'MO_NUMBER'
510: ,p_token1_value => l_move_order_header_id);
511: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 515: gme_common_pvt.log_message

511: IF g_debug <= gme_debug.g_log_unexpected THEN
512: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
513: END IF;
514: ELSIF (NOT (g_partially_allocated) AND NOT (g_fully_allocated) ) THEN
515: gme_common_pvt.log_message
516: (p_message_code => 'GME_PICKED_NO_ALLOC'
517: ,p_token1_name => 'MO_NUMBER'
518: ,p_token1_value => l_move_order_header_id);
519: IF g_debug <= gme_debug.g_log_unexpected THEN

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

529: WHEN no_materials_picked THEN
530: --Bug#5311713
531: FND_MESSAGE.SET_NAME('GME','GME_NO_MATERIALS_SELECTED');
532: FND_FILE.PUT_LINE(FND_FILE.log,FND_MESSAGE.GET);
533: --gme_common_pvt.log_message ('GME_NO_MATERIALS_SELECTED');
534: --x_return_status := fnd_api.g_ret_sts_error;
535: WHEN setup_failure THEN
536: x_return_status := fnd_api.g_ret_sts_error;
537: WHEN create_move_order_err OR process_line_err OR print_pickslip_err THEN

Line 586: l_resv_tbl gme_common_pvt.reservations_tab;

582: l_move_order_header_id NUMBER;
583: l_return_status VARCHAR2 (1);
584: l_plan_tasks BOOLEAN;
585: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
586: l_resv_tbl gme_common_pvt.reservations_tab;
587: l_inv_resv_tbl inv_reservation_global.mtl_reservation_tbl_type;
588: create_suggestions_err EXCEPTION;
589: get_pick_slip_err EXCEPTION;
590: BEGIN

Line 842: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch

838: END IF;
839:
840: UPDATE mtl_material_transactions_temp
841: SET pick_slip_number = l_pick_slip_number,
842: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
843: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
844: ELSE
845: UPDATE mtl_material_transactions_temp
846: SET wip_entity_type = gme_common_pvt.g_wip_entity_type_batch

Line 846: SET wip_entity_type = gme_common_pvt.g_wip_entity_type_batch

842: wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
843: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
844: ELSE
845: UPDATE mtl_material_transactions_temp
846: SET wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
847: WHERE transaction_temp_id = get_mmtt.transaction_temp_id;
848: END IF;
849: END LOOP;
850: