DBA Data[Home] [Help]

APPS.GME_API_GRP dependencies on GME_BATCH_STEP_RESOURCES_DBL

Line 2741: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources

2737: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2738: RAISE create_txn_fail;
2739: END IF;
2740: l_step_resources.batchstep_resource_id := l_rsrc_txn_gtmp_rec.line_id;
2741: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources
2742: ,x_batch_step_resources => l_step_resources) THEN
2743: RAISE rsrc_fetch_err;
2744: END IF;
2745: l_step_resources.actual_rsrc_usage := NVL (l_step_resources.actual_rsrc_usage, 0) + l_txn_usage;

Line 2759: IF NOT Gme_Batch_Step_Resources_Dbl.update_row(p_batch_step_resources => l_step_resources) THEN

2755: IF l_return_status <> 'S' THEN
2756: RAISE reduce_pend_usage_err;
2757: END IF;
2758: END IF;
2759: IF NOT Gme_Batch_Step_Resources_Dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2760: RAISE rsrc_update_err;
2761: END IF;
2762: IF g_debug <= gme_debug.g_log_procedure THEN
2763: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

Line 2838: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources

2834: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2835: RAISE update_txn_fail;
2836: END IF;
2837: l_step_resources.batchstep_resource_id := p_rsrc_txn_gtmp_rec.line_id;
2838: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources
2839: ,x_batch_step_resources => l_step_resources) THEN
2840: RAISE rsrc_fetch_err;
2841: END IF;
2842: gme_resource_engine_pvt.get_resource_usage(p_step_resources_rec => l_step_resources

Line 2857: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN

2853: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2854: RAISE reduce_pend_usage_err;
2855: END IF;
2856: END IF;
2857: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2858: RAISE upd_rsrc_err;
2859: END IF;
2860: END IF;
2861: IF g_debug <= gme_debug.g_log_procedure THEN

Line 2933: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources

2929: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2930: RAISE delete_txn_fail;
2931: END IF;
2932: l_step_resources.batchstep_resource_id := p_rsrc_txn_gtmp_rec.line_id;
2933: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources
2934: ,x_batch_step_resources => l_step_resources) THEN
2935: RAISE rsrc_fetch_err;
2936: END IF;
2937: gme_resource_engine_pvt.get_resource_usage(p_step_resources_rec => l_step_resources

Line 2952: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN

2948: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2949: RAISE reduce_pend_usage_err;
2950: END IF;
2951: END IF;
2952: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2953: RAISE upd_rsrc_err;
2954: END IF;
2955: END IF;
2956: IF g_debug <= gme_debug.g_log_procedure THEN