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 668: l_rsv_rec.demand_source_type_id := gme_common_pvt.g_txn_source_type;

664: --Bug#4604943 End
665: l_rsv_rec.requirement_date := p_matl_dtl_rec.material_requirement_date;
666: l_rsv_rec.organization_id := p_matl_dtl_rec.organization_id;
667: l_rsv_rec.inventory_item_id := p_matl_dtl_rec.inventory_item_id;
668: l_rsv_rec.demand_source_type_id := gme_common_pvt.g_txn_source_type;
669: l_rsv_rec.demand_source_header_id := p_matl_dtl_rec.batch_id;
670: l_rsv_rec.demand_source_line_id := p_matl_dtl_rec.material_detail_id;
671: l_rsv_rec.reservation_uom_code := NVL (p_resv_um, p_matl_dtl_rec.dtl_um);
672: l_rsv_rec.reservation_quantity :=

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

804: l_batch_header_rec.batch_id := p_material_detail_rec.batch_id;
805: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
806: RAISE fetch_failure;
807: END IF;
808: IF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending THEN
809: --pending batch just return
810: /* IF g_debug <= gme_debug.g_log_statement THEN
811: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is Pending status');
812: END IF;*/

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

810: /* IF g_debug <= gme_debug.g_log_statement THEN
811: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is Pending status');
812: END IF;*/
813: RETURN;
814: ELSIF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
815: /* In WIP Bathes, do not create reservations for automatic and automatic by step if assoc step is not released*/
816: IF p_material_detail_rec.release_type IN (gme_common_pvt.g_mtl_manual_release,gme_common_pvt.g_mtl_incremental_release) THEN
817: /* IF g_debug <= gme_debug.g_log_statement THEN
818: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is manual/incremental');

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

812: END IF;*/
813: RETURN;
814: ELSIF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
815: /* In WIP Bathes, do not create reservations for automatic and automatic by step if assoc step is not released*/
816: IF p_material_detail_rec.release_type IN (gme_common_pvt.g_mtl_manual_release,gme_common_pvt.g_mtl_incremental_release) THEN
817: /* IF g_debug <= gme_debug.g_log_statement THEN
818: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is manual/incremental');
819: END IF;*/
820: RETURN;

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

817: /* IF g_debug <= gme_debug.g_log_statement THEN
818: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is manual/incremental');
819: END IF;*/
820: RETURN;
821: ELSIF p_material_detail_rec.release_type = gme_common_pvt.g_mtl_autobystep_release THEN
822: /* if automatic by step then check step status */
823: /* IF g_debug <= gme_debug.g_log_statement THEN
824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is Autoby step');
825: END IF;*/

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

822: /* if automatic by step then check step status */
823: /* IF g_debug <= gme_debug.g_log_statement THEN
824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is Autoby step');
825: END IF;*/
826: IF NOT gme_common_pvt.get_assoc_step(p_material_detail_rec.material_detail_id,l_step_id,l_step_status) THEN
827: RAISE demand_line_error;
828: ELSIF l_step_id IS NOT NULL AND NVL(l_step_status,-1) <> gme_common_pvt.g_step_pending THEN
829: RAISE demand_line_error;
830: END IF;

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

824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch is in WIP and material line is Autoby step');
825: END IF;*/
826: IF NOT gme_common_pvt.get_assoc_step(p_material_detail_rec.material_detail_id,l_step_id,l_step_status) THEN
827: RAISE demand_line_error;
828: ELSIF l_step_id IS NOT NULL AND NVL(l_step_status,-1) <> gme_common_pvt.g_step_pending THEN
829: RAISE demand_line_error;
830: END IF;
831: ELSE
832: /* IF g_debug <= gme_debug.g_log_statement THEN

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

841: EXCEPTION
842: WHEN fetch_failure THEN
843: x_return_status := fnd_api.g_ret_sts_error;
844: WHEN demand_line_error THEN
845: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
846: x_msg_data:='GME_INVALID_DEMAND_LINE';
847: x_return_status := fnd_api.g_ret_sts_error;
848: WHEN batch_status_error THEN
849: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');

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

845: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
846: x_msg_data:='GME_INVALID_DEMAND_LINE';
847: x_return_status := fnd_api.g_ret_sts_error;
848: WHEN batch_status_error THEN
849: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');
850: x_msg_data:='GME_INVALID_BATCH_STATUS';
851: x_return_status := fnd_api.g_ret_sts_error;
852: WHEN OTHERS THEN
853: /* IF g_debug <= gme_debug.g_log_unexpected THEN