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

Line 554: l_rsv_rec.demand_source_type_id := gme_common_pvt.g_txn_source_type;

550: --Bug#4604943 End
551: l_rsv_rec.requirement_date := p_matl_dtl_rec.material_requirement_date;
552: l_rsv_rec.organization_id := p_matl_dtl_rec.organization_id;
553: l_rsv_rec.inventory_item_id := p_matl_dtl_rec.inventory_item_id;
554: l_rsv_rec.demand_source_type_id := gme_common_pvt.g_txn_source_type;
555: l_rsv_rec.demand_source_header_id := p_matl_dtl_rec.batch_id;
556: l_rsv_rec.demand_source_line_id := p_matl_dtl_rec.material_detail_id;
557: l_rsv_rec.reservation_uom_code := NVL (p_resv_um, p_matl_dtl_rec.dtl_um);
558: l_rsv_rec.reservation_quantity :=

Line 694: IF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending THEN

690: l_batch_header_rec.batch_id := p_material_detail_rec.batch_id;
691: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
692: RAISE fetch_failure;
693: END IF;
694: IF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending THEN
695: --pending batch just return
696: /* IF g_debug <= gme_debug.g_log_statement THEN
697: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is Pending status');
698: END IF;*/

Line 700: ELSIF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN

696: /* IF g_debug <= gme_debug.g_log_statement THEN
697: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is Pending status');
698: END IF;*/
699: RETURN;
700: ELSIF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
701: /* In WIP Bathes, do not create reservations for automatic and automatic by step if assoc step is not released*/
702: IF p_material_detail_rec.release_type IN (gme_common_pvt.g_mtl_manual_release,gme_common_pvt.g_mtl_incremental_release) THEN
703: /* IF g_debug <= gme_debug.g_log_statement THEN
704: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is manual/incremental');

Line 702: IF p_material_detail_rec.release_type IN (gme_common_pvt.g_mtl_manual_release,gme_common_pvt.g_mtl_incremental_release) THEN

698: END IF;*/
699: RETURN;
700: ELSIF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
701: /* In WIP Bathes, do not create reservations for automatic and automatic by step if assoc step is not released*/
702: IF p_material_detail_rec.release_type IN (gme_common_pvt.g_mtl_manual_release,gme_common_pvt.g_mtl_incremental_release) THEN
703: /* IF g_debug <= gme_debug.g_log_statement THEN
704: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is manual/incremental');
705: END IF;*/
706: RETURN;

Line 707: ELSIF p_material_detail_rec.release_type = gme_common_pvt.g_mtl_autobystep_release THEN

703: /* IF g_debug <= gme_debug.g_log_statement THEN
704: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is manual/incremental');
705: END IF;*/
706: RETURN;
707: ELSIF p_material_detail_rec.release_type = gme_common_pvt.g_mtl_autobystep_release THEN
708: /* if automatic by step then check step status */
709: /* IF g_debug <= gme_debug.g_log_statement THEN
710: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is Autoby step');
711: END IF;*/

Line 712: IF NOT gme_common_pvt.get_assoc_step(p_material_detail_rec.material_detail_id,l_step_id,l_step_status) THEN

708: /* if automatic by step then check step status */
709: /* IF g_debug <= gme_debug.g_log_statement THEN
710: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is Autoby step');
711: END IF;*/
712: IF NOT gme_common_pvt.get_assoc_step(p_material_detail_rec.material_detail_id,l_step_id,l_step_status) THEN
713: RAISE demand_line_error;
714: ELSIF l_step_id IS NOT NULL AND NVL(l_step_status,-1) <> gme_common_pvt.g_step_pending THEN
715: RAISE demand_line_error;
716: END IF;

Line 714: ELSIF l_step_id IS NOT NULL AND NVL(l_step_status,-1) <> gme_common_pvt.g_step_pending THEN

710: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is Autoby step');
711: END IF;*/
712: IF NOT gme_common_pvt.get_assoc_step(p_material_detail_rec.material_detail_id,l_step_id,l_step_status) THEN
713: RAISE demand_line_error;
714: ELSIF l_step_id IS NOT NULL AND NVL(l_step_status,-1) <> gme_common_pvt.g_step_pending THEN
715: RAISE demand_line_error;
716: END IF;
717: ELSE
718: /* IF g_debug <= gme_debug.g_log_statement THEN

Line 731: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');

727: EXCEPTION
728: WHEN fetch_failure THEN
729: x_return_status := fnd_api.g_ret_sts_error;
730: WHEN demand_line_error THEN
731: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
732: x_msg_data:='GME_INVALID_DEMAND_LINE';
733: x_return_status := fnd_api.g_ret_sts_error;
734: WHEN batch_status_error THEN
735: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');

Line 735: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');

731: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
732: x_msg_data:='GME_INVALID_DEMAND_LINE';
733: x_return_status := fnd_api.g_ret_sts_error;
734: WHEN batch_status_error THEN
735: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');
736: x_msg_data:='GME_INVALID_BATCH_STATUS';
737: x_return_status := fnd_api.g_ret_sts_error;
738: WHEN OTHERS THEN
739: /* IF g_debug <= gme_debug.g_log_unexpected THEN