DBA Data[Home] [Help]

APPS.GME_API_GRP dependencies on GME_BATCH_STEP_RESOURCES_DBL

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

2822: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2823: RAISE create_txn_fail;
2824: END IF;
2825: l_step_resources.batchstep_resource_id := l_rsrc_txn_gtmp_rec.line_id;
2826: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources
2827: ,x_batch_step_resources => l_step_resources) THEN
2828: RAISE rsrc_fetch_err;
2829: END IF;
2830: l_step_resources.actual_rsrc_usage := NVL (l_step_resources.actual_rsrc_usage, 0) + l_txn_usage;

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

2840: IF l_return_status <> 'S' THEN
2841: RAISE reduce_pend_usage_err;
2842: END IF;
2843: END IF;
2844: IF NOT Gme_Batch_Step_Resources_Dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2845: RAISE rsrc_update_err;
2846: END IF;
2847: IF g_debug <= gme_debug.g_log_procedure THEN
2848: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

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

2919: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2920: RAISE update_txn_fail;
2921: END IF;
2922: l_step_resources.batchstep_resource_id := p_rsrc_txn_gtmp_rec.line_id;
2923: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources
2924: ,x_batch_step_resources => l_step_resources) THEN
2925: RAISE rsrc_fetch_err;
2926: END IF;
2927: gme_resource_engine_pvt.get_resource_usage(p_step_resources_rec => l_step_resources

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

2938: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2939: RAISE reduce_pend_usage_err;
2940: END IF;
2941: END IF;
2942: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2943: RAISE upd_rsrc_err;
2944: END IF;
2945: END IF;
2946: IF g_debug <= gme_debug.g_log_procedure THEN

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

3014: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3015: RAISE delete_txn_fail;
3016: END IF;
3017: l_step_resources.batchstep_resource_id := p_rsrc_txn_gtmp_rec.line_id;
3018: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources
3019: ,x_batch_step_resources => l_step_resources) THEN
3020: RAISE rsrc_fetch_err;
3021: END IF;
3022: gme_resource_engine_pvt.get_resource_usage(p_step_resources_rec => l_step_resources

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

3033: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3034: RAISE reduce_pend_usage_err;
3035: END IF;
3036: END IF;
3037: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
3038: RAISE upd_rsrc_err;
3039: END IF;
3040: END IF;
3041: IF g_debug <= gme_debug.g_log_procedure THEN