DBA Data[Home] [Help]

APPS.GME_BATCH_STEP_CHG_PVT dependencies on FND_API

Line 451: x_return_status := fnd_api.g_ret_sts_success;

447: l_cur_is_charge_associated cur_is_charge_associated%ROWTYPE;
448: l_return_status VARCHAR2 (1);
449: BEGIN
450: /* Set the return status to success initially */
451: x_return_status := fnd_api.g_ret_sts_success;
452:
453: IF p_batchstep_id IS NOT NULL THEN
454: --clear the dates of only charges associated with the step.
455: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 524: x_return_status := fnd_api.g_ret_sts_unexp_error;

520: END LOOP;
521: END IF;
522: EXCEPTION
523: WHEN OTHERS THEN
524: x_return_status := fnd_api.g_ret_sts_unexp_error;
525: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
526: gme_debug.put_line ( g_pkg_name
527: || '.'
528: || l_api_name

Line 573: x_return_status := fnd_api.g_ret_sts_success;

569: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;
570: clear_chg_error EXCEPTION;
571: BEGIN
572: /* Set the return status to success initially */
573: x_return_status := fnd_api.g_ret_sts_success;
574:
575: IF p_batchstep_id IS NOT NULL THEN
576: --clear only charges associated with the step.
577: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 647: x_return_status := fnd_api.g_ret_sts_error;

643: END LOOP;
644: END IF;
645: EXCEPTION
646: WHEN clear_chg_error THEN
647: x_return_status := fnd_api.g_ret_sts_error;
648: WHEN OTHERS THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
651: gme_debug.put_line ( g_pkg_name

Line 649: x_return_status := fnd_api.g_ret_sts_unexp_error;

645: EXCEPTION
646: WHEN clear_chg_error THEN
647: x_return_status := fnd_api.g_ret_sts_error;
648: WHEN OTHERS THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
651: gme_debug.put_line ( g_pkg_name
652: || '.'
653: || l_api_name

Line 704: x_return_status := fnd_api.g_ret_sts_success;

700: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ' Entering');
701: END IF;
702:
703: /* Initialise the return status to success*/
704: x_return_status := fnd_api.g_ret_sts_success;
705:
706: OPEN cur_get_seq_dep_ind (p_resources, p_batchstep_id);
707:
708: FETCH cur_get_seq_dep_ind

Line 726: x_return_status := fnd_api.g_ret_sts_error;

722: || x_act_seq_num);
723: END IF;
724:
725: IF x_act_seq_num IS NULL THEN
726: x_return_status := fnd_api.g_ret_sts_error;
727: END IF;
728: END calc_activity_sequence_number;
729:
730: /*===========================================================================================

Line 763: x_return_status := fnd_api.g_ret_sts_success;

759: l_return_status VARCHAR2 (1);
760: error_act_seq_num_calc EXCEPTION;
761: error_charge_insert EXCEPTION;
762: BEGIN
763: x_return_status := fnd_api.g_ret_sts_success;
764: l_batchstep_charges_in := p_batchstep_charges_in;
765: /*Calculating the activity sequence_number*/
766: gme_batch_step_chg_pvt.calc_activity_sequence_number
767: (p_batchstep_id => l_batchstep_charges_in.batchstep_id

Line 772: IF x_return_status <> fnd_api.g_ret_sts_success THEN

768: ,p_resources => l_batchstep_charges_in.resources
769: ,x_act_seq_num => l_activity_sequence_number
770: ,x_return_status => l_return_status);
771:
772: IF x_return_status <> fnd_api.g_ret_sts_success THEN
773: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
774: gme_debug.put_line
775: ('Error in calculating activity sequence number');
776: END IF;

Line 817: x_return_status := fnd_api.g_ret_sts_error;

813: RAISE error_charge_insert;
814: END IF;
815: EXCEPTION
816: WHEN error_charge_insert OR error_act_seq_num_calc THEN
817: x_return_status := fnd_api.g_ret_sts_error;
818: WHEN OTHERS THEN
819: x_return_status := fnd_api.g_ret_sts_unexp_error;
820: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
821: gme_debug.put_line ( g_pkg_name

Line 819: x_return_status := fnd_api.g_ret_sts_unexp_error;

815: EXCEPTION
816: WHEN error_charge_insert OR error_act_seq_num_calc THEN
817: x_return_status := fnd_api.g_ret_sts_error;
818: WHEN OTHERS THEN
819: x_return_status := fnd_api.g_ret_sts_unexp_error;
820: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
821: gme_debug.put_line ( g_pkg_name
822: || '.'
823: || l_api_name