DBA Data[Home] [Help]

APPS.GME_BATCH_STEP_CHG_PVT dependencies on FND_API

Line 521: x_return_status := fnd_api.g_ret_sts_success;

517: l_cur_is_charge_associated cur_is_charge_associated%ROWTYPE;
518: l_return_status VARCHAR2 (1);
519: BEGIN
520: /* Set the return status to success initially */
521: x_return_status := fnd_api.g_ret_sts_success;
522:
523: IF p_batchstep_id IS NOT NULL THEN
524: --clear the dates of only charges associated with the step.
525: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 594: x_return_status := fnd_api.g_ret_sts_unexp_error;

590: END LOOP;
591: END IF;
592: EXCEPTION
593: WHEN OTHERS THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
596: gme_debug.put_line ( g_pkg_name
597: || '.'
598: || l_api_name

Line 643: x_return_status := fnd_api.g_ret_sts_success;

639: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;
640: clear_chg_error EXCEPTION;
641: BEGIN
642: /* Set the return status to success initially */
643: x_return_status := fnd_api.g_ret_sts_success;
644:
645: IF p_batchstep_id IS NOT NULL THEN
646: --clear only charges associated with the step.
647: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 717: x_return_status := fnd_api.g_ret_sts_error;

713: END LOOP;
714: END IF;
715: EXCEPTION
716: WHEN clear_chg_error THEN
717: x_return_status := fnd_api.g_ret_sts_error;
718: WHEN OTHERS THEN
719: x_return_status := fnd_api.g_ret_sts_unexp_error;
720: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
721: gme_debug.put_line ( g_pkg_name

Line 719: x_return_status := fnd_api.g_ret_sts_unexp_error;

715: EXCEPTION
716: WHEN clear_chg_error THEN
717: x_return_status := fnd_api.g_ret_sts_error;
718: WHEN OTHERS THEN
719: x_return_status := fnd_api.g_ret_sts_unexp_error;
720: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
721: gme_debug.put_line ( g_pkg_name
722: || '.'
723: || l_api_name

Line 774: x_return_status := fnd_api.g_ret_sts_success;

770: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ' Entering');
771: END IF;
772:
773: /* Initialise the return status to success*/
774: x_return_status := fnd_api.g_ret_sts_success;
775:
776: OPEN cur_get_seq_dep_ind (p_resources, p_batchstep_id);
777:
778: FETCH cur_get_seq_dep_ind

Line 796: x_return_status := fnd_api.g_ret_sts_error;

792: || x_act_seq_num);
793: END IF;
794:
795: IF x_act_seq_num IS NULL THEN
796: x_return_status := fnd_api.g_ret_sts_error;
797: END IF;
798: END calc_activity_sequence_number;
799:
800: /*===========================================================================================

Line 833: x_return_status := fnd_api.g_ret_sts_success;

829: l_return_status VARCHAR2 (1);
830: error_act_seq_num_calc EXCEPTION;
831: error_charge_insert EXCEPTION;
832: BEGIN
833: x_return_status := fnd_api.g_ret_sts_success;
834: l_batchstep_charges_in := p_batchstep_charges_in;
835: /*Calculating the activity sequence_number*/
836: gme_batch_step_chg_pvt.calc_activity_sequence_number
837: (p_batchstep_id => l_batchstep_charges_in.batchstep_id

Line 842: IF x_return_status <> fnd_api.g_ret_sts_success THEN

838: ,p_resources => l_batchstep_charges_in.resources
839: ,x_act_seq_num => l_activity_sequence_number
840: ,x_return_status => l_return_status);
841:
842: IF x_return_status <> fnd_api.g_ret_sts_success THEN
843: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
844: gme_debug.put_line
845: ('Error in calculating activity sequence number');
846: END IF;

Line 887: x_return_status := fnd_api.g_ret_sts_error;

883: RAISE error_charge_insert;
884: END IF;
885: EXCEPTION
886: WHEN error_charge_insert OR error_act_seq_num_calc THEN
887: x_return_status := fnd_api.g_ret_sts_error;
888: WHEN OTHERS THEN
889: x_return_status := fnd_api.g_ret_sts_unexp_error;
890: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
891: gme_debug.put_line ( g_pkg_name

Line 889: x_return_status := fnd_api.g_ret_sts_unexp_error;

885: EXCEPTION
886: WHEN error_charge_insert OR error_act_seq_num_calc THEN
887: x_return_status := fnd_api.g_ret_sts_error;
888: WHEN OTHERS THEN
889: x_return_status := fnd_api.g_ret_sts_unexp_error;
890: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
891: gme_debug.put_line ( g_pkg_name
892: || '.'
893: || l_api_name