[Home] [Help]
1186: IF l_return_status <> x_return_status THEN
1187: RAISE FND_API.g_exc_error;
1188: END IF;
1189: */
1190: IF NOT (gme_batch_step_resources_dbl.insert_row
1191: (p_batch_step_resources => x_step_resources_rec
1192: ,x_batch_step_resources => x_step_resources_rec) ) THEN
1193: RAISE fnd_api.g_exc_error;
1194: END IF;
1274: /* Update has to be done after updating the transactions as the adjust actual */
1275: /* usage logic depends on the previous actual usage to deduce the usage to be */
1276: /* deducted from the pending resource transactions */
1277: IF p_action_code = 'UPDATE' THEN
1278: IF NOT (gme_batch_step_resources_dbl.update_row
1279: (p_batch_step_resources => x_step_resources_rec) ) THEN
1280: RAISE fnd_api.g_exc_error;
1281: END IF;
1282:
1825: x_return_status := fnd_api.g_ret_sts_success;
1826: x_step_resources_rec.batchstep_resource_id :=
1827: p_step_resources_rec.batchstep_resource_id;
1828:
1829: IF NOT gme_batch_step_resources_dbl.fetch_row
1830: (p_batch_step_resources => x_step_resources_rec
1831: ,x_batch_step_resources => x_step_resources_rec) THEN
1832: RAISE fnd_api.g_exc_error;
1833: END IF;
2718: ,l_batch_header.batch_id);
2719: END IF;
2720:
2721: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
2722: IF NOT gme_batch_step_resources_dbl.fetch_row
2723: (p_batch_step_resources => l_step_resources
2724: ,x_batch_step_resources => l_step_resources) THEN
2725: RAISE rsrc_fetch_err;
2726: END IF;
2727:
2728: l_step_resources.actual_rsrc_count := 1;
2729: l_step_resources.actual_rsrc_usage := l_rsrc_txn_rec.resource_usage;
2730:
2731: IF NOT gme_batch_step_resources_dbl.update_row
2732: (p_batch_step_resources => l_step_resources) THEN
2733: RAISE rsrc_update_err;
2734: END IF;
2735:
2951: -- update resource actual count and usage
2952: ---- l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
2953: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
2954:
2955: IF NOT gme_batch_step_resources_dbl.fetch_row
2956: (p_batch_step_resources => l_step_resources
2957: ,x_batch_step_resources => l_step_resources) THEN
2958: RAISE rsrc_fetch_err;
2959: END IF;
2981: RAISE reduce_pend_usage_err;
2982: END IF;
2983: END IF;
2984:
2985: IF NOT gme_batch_step_resources_dbl.update_row
2986: (p_batch_step_resources => l_step_resources) THEN
2987: RAISE rsrc_update_err;
2988: END IF;
2989:
3247: -- update resource actual count and usage
3248: --l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
3249: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
3250:
3251: IF NOT gme_batch_step_resources_dbl.fetch_row
3252: (p_batch_step_resources => l_step_resources
3253: ,x_batch_step_resources => l_step_resources) THEN
3254: RAISE rsrc_fetch_err;
3255: END IF;
3277: RAISE reduce_pend_usage_err;
3278: END IF;
3279: END IF;
3280:
3281: IF NOT gme_batch_step_resources_dbl.update_row
3282: (p_batch_step_resources => l_step_resources) THEN
3283: RAISE rsrc_update_err;
3284: END IF;
3285:
3841: -- update resource actual count and usage
3842: ---l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
3843: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
3844:
3845: IF NOT gme_batch_step_resources_dbl.fetch_row
3846: (p_batch_step_resources => l_step_resources
3847: ,x_batch_step_resources => l_step_resources) THEN
3848: RAISE rsrc_fetch_err;
3849: END IF;
3878: RAISE reduce_pend_usage_err;
3879: END IF;
3880: END IF;
3881:
3882: IF NOT gme_batch_step_resources_dbl.update_row
3883: (p_batch_step_resources => l_step_resources) THEN
3884: RAISE rsrc_update_err;
3885: END IF;
3886: