DBA Data[Home] [Help]

APPS.GME_DELETE_BATCH_STEP_PVT dependencies on FND_API

Line 85: x_return_status := fnd_api.g_ret_sts_success;

81:
82: /* Set the savepoint before proceeding */
83: SAVEPOINT delete_batch_step;
84: /* Set the return status to success initially */
85: x_return_status := fnd_api.g_ret_sts_success;
86:
87: /* Initialize local batch step array */
88: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec, l_batch_step) ) THEN
89: RAISE batch_step_fetch_error;

Line 222: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );

218:
219: IF l_return_status <> x_return_status THEN
220: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
221: gme_debug.put_line
222: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );
223: END IF;
224:
225: RAISE error_calc_step_qty;
226: END IF;

Line 253: x_return_status := fnd_api.g_ret_sts_error;

249: END IF;
250: EXCEPTION
251: WHEN invalid_step THEN
252: ROLLBACK TO SAVEPOINT delete_batch_step;
253: x_return_status := fnd_api.g_ret_sts_error;
254: gme_common_pvt.log_message ('GME_STEP_NOT_PENDING');
255: /* FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
256: P_data => x_message_list); */
257: WHEN error_calc_step_qty THEN

Line 262: x_return_status := fnd_api.g_ret_sts_error;

258: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
259: gme_debug.put_line ('calc step qty error');
260: END IF;
261:
262: x_return_status := fnd_api.g_ret_sts_error;
263: WHEN one_step_reqd THEN
264: ROLLBACK TO SAVEPOINT delete_batch_step;
265: x_return_status := fnd_api.g_ret_sts_error;
266: gme_common_pvt.log_message ('GME_ONE_STEP_REQD');

Line 265: x_return_status := fnd_api.g_ret_sts_error;

261:
262: x_return_status := fnd_api.g_ret_sts_error;
263: WHEN one_step_reqd THEN
264: ROLLBACK TO SAVEPOINT delete_batch_step;
265: x_return_status := fnd_api.g_ret_sts_error;
266: gme_common_pvt.log_message ('GME_ONE_STEP_REQD');
267: /* FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
268: P_data => x_message_list); */
269: WHEN step_activity_delete_error OR error_load_trans OR batch_step_fetch_error OR batch_header_fetch_error OR step_dependency_delete_error OR step_item_delete_error OR step_delete_error THEN

Line 270: x_return_status := fnd_api.g_ret_sts_error;

266: gme_common_pvt.log_message ('GME_ONE_STEP_REQD');
267: /* FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
268: P_data => x_message_list); */
269: WHEN step_activity_delete_error OR error_load_trans OR batch_step_fetch_error OR batch_header_fetch_error OR step_dependency_delete_error OR step_item_delete_error OR step_delete_error THEN
270: x_return_status := fnd_api.g_ret_sts_error;
271: ROLLBACK TO SAVEPOINT delete_batch_step;
272: /* FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
273: P_data => x_message_list); */
274: WHEN OTHERS THEN

Line 284: x_return_status := fnd_api.g_ret_sts_unexp_error;

280: || ' Error is '
281: || SQLERRM);
282: END IF;
283:
284: x_return_status := fnd_api.g_ret_sts_unexp_error;
285: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
286: END delete_step;
287:
288: /*===========================================================================================

Line 343: x_return_status := fnd_api.g_ret_sts_success;

339: || l_api_name);
340: END IF;
341:
342: /* Set the return status to success initially */
343: x_return_status := fnd_api.g_ret_sts_success;
344:
345: /* Fetch all the resources associated with the activity */
346: OPEN cur_step_resource_ids
347: (p_batch_step_activities_rec.batchstep_activity_id);

Line 378: p_init_msg_list => FND_API.G_FALSE,

374: --
375: IF l_batchstep_resource_ids.COUNT > 0 THEN
376: GMF_VIB.Update_Batch_Requirements
377: ( p_api_version => 1.0,
378: p_init_msg_list => FND_API.G_FALSE,
379: p_batch_id => l_batch_id,
380: x_return_status => l_return_status,
381: x_msg_count => l_message_count,
382: x_msg_data => l_message_list);

Line 384: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

380: x_return_status => l_return_status,
381: x_msg_count => l_message_count,
382: x_msg_data => l_message_list);
383:
384: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
385: THEN
386: RAISE gmf_cost_failure;
387: END IF;
388: END IF;

Line 404: x_return_status := FND_API.G_RET_STS_ERROR;

400: END IF;
401: EXCEPTION
402: WHEN gmf_cost_failure THEN
403: -- Bug 5903208
404: x_return_status := FND_API.G_RET_STS_ERROR;
405:
406: WHEN step_activity_delete_error OR activity_resource_delete_error THEN
407: x_return_status := fnd_api.g_ret_sts_error;
408: WHEN OTHERS THEN

Line 407: x_return_status := fnd_api.g_ret_sts_error;

403: -- Bug 5903208
404: x_return_status := FND_API.G_RET_STS_ERROR;
405:
406: WHEN step_activity_delete_error OR activity_resource_delete_error THEN
407: x_return_status := fnd_api.g_ret_sts_error;
408: WHEN OTHERS THEN
409: IF g_debug <= gme_debug.g_log_unexpected THEN
410: gme_debug.put_line ( 'When others exception in '
411: || g_pkg_name

Line 418: x_return_status := fnd_api.g_ret_sts_unexp_error;

414: || ' Error is '
415: || SQLERRM);
416: END IF;
417:
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
420: END delete_activity;
421:
422: /*===========================================================================================

Line 496: x_return_status := fnd_api.g_ret_sts_success;

492: || l_api_name);
493: END IF;
494:
495: /* Set the return status to success initially */
496: x_return_status := fnd_api.g_ret_sts_success;
497:
498: /* 2841929: populate local variable with the current batchstep record */
499: IF NOT (gme_batch_step_resources_dbl.fetch_row
500: (p_batch_step_resources_rec

Line 600: x_return_status := fnd_api.g_ret_sts_error;

596: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
597: END IF;
598: EXCEPTION
599: WHEN trans_delete_error OR activity_resource_delete_error OR rsrc_param_delete_error OR resource_charge_delete_error THEN
600: x_return_status := fnd_api.g_ret_sts_error;
601: WHEN OTHERS THEN
602: IF g_debug <= gme_debug.g_log_unexpected THEN
603: gme_debug.put_line ( 'When others exception in '
604: || g_pkg_name

Line 611: x_return_status := fnd_api.g_ret_sts_unexp_error;

607: || ' Error is '
608: || SQLERRM);
609: END IF;
610:
611: x_return_status := fnd_api.g_ret_sts_unexp_error;
612: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
613: END delete_resource;
614:
615: /*===========================================================================================

Line 642: x_return_status := fnd_api.g_ret_sts_success;

638: || l_api_name);
639: END IF;
640:
641: /* Set the return status to success initially */
642: x_return_status := fnd_api.g_ret_sts_success;
643: /* Lets fetch all the active resource transactions for the current resource */
644: l_resource_txns.poc_trans_id := NULL;
645: l_resource_txns.doc_id := NULL;
646: l_resource_txns.line_id :=

Line 654: RAISE fnd_api.g_exc_error;

650: ,x_resource_tbl => l_resource_tab
651: ,x_return_status => l_return_status);
652:
653: IF l_return_status <> x_return_status THEN
654: RAISE fnd_api.g_exc_error;
655: END IF; /* IF l_return_status <> x_return_status */
656:
657: FOR i IN 1 .. l_resource_tab.COUNT LOOP
658: l_resource_txns := l_resource_tab (i);

Line 664: RAISE fnd_api.g_exc_error;

660: (p_tran_rec => l_resource_txns
661: ,x_return_status => l_return_status);
662:
663: IF l_return_status <> x_return_status THEN
664: RAISE fnd_api.g_exc_error;
665: END IF;
666: END LOOP; /* FOR i IN 1..l_resource_tab.COUNT */
667:
668: IF g_debug <= gme_debug.g_log_procedure THEN

Line 672: WHEN fnd_api.g_exc_error THEN

668: IF g_debug <= gme_debug.g_log_procedure THEN
669: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
670: END IF;
671: EXCEPTION
672: WHEN fnd_api.g_exc_error THEN
673: x_return_status := fnd_api.g_ret_sts_error;
674: WHEN OTHERS THEN
675: IF g_debug <= gme_debug.g_log_unexpected THEN
676: gme_debug.put_line ( 'When others exception in '

Line 673: x_return_status := fnd_api.g_ret_sts_error;

669: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
670: END IF;
671: EXCEPTION
672: WHEN fnd_api.g_exc_error THEN
673: x_return_status := fnd_api.g_ret_sts_error;
674: WHEN OTHERS THEN
675: IF g_debug <= gme_debug.g_log_unexpected THEN
676: gme_debug.put_line ( 'When others exception in '
677: || g_pkg_name

Line 684: x_return_status := fnd_api.g_ret_sts_unexp_error;

680: || ' Error is '
681: || SQLERRM);
682: END IF;
683:
684: x_return_status := fnd_api.g_ret_sts_unexp_error;
685: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
686: END delete_resource_transactions;
687: END gme_delete_batch_step_pvt;