DBA Data[Home] [Help]

APPS.GME_CLOSE_STEP_PVT dependencies on FND_API

Line 25: ,p_delete_pending IN VARCHAR2 DEFAULT fnd_api.g_false

21: U - Unexpected error
22: ======================================================================================*/
23: PROCEDURE close_step (
24: p_batch_step_rec IN gme_batch_steps%ROWTYPE
25: ,p_delete_pending IN VARCHAR2 DEFAULT fnd_api.g_false
26: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS
29: /* Miscellaneous */

Line 78: x_return_status := fnd_api.g_ret_sts_success;

74: --Bug#5109119
75: error_close_period EXCEPTION;
76: BEGIN
77: /* Set the return status to success initially */
78: x_return_status := fnd_api.g_ret_sts_success;
79:
80: /* Initialize output batch step */
81: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
82: ,x_batch_step_rec) ) THEN

Line 223: x_return_status := fnd_api.g_ret_sts_error;

219: END LOOP;
220: END IF; /* l_batch_header.batch_status <> 4 */
221: EXCEPTION
222: WHEN batch_step_fetch_error OR batch_header_fetch_error OR error_close_period THEN
223: x_return_status := fnd_api.g_ret_sts_error;
224: WHEN invalid_batch_status THEN
225: x_return_status := fnd_api.g_ret_sts_error;
226: gme_common_pvt.log_message ('GME_API_INV_BATCH_CLOSE_STEP');
227: WHEN invalid_batch_type THEN

Line 225: x_return_status := fnd_api.g_ret_sts_error;

221: EXCEPTION
222: WHEN batch_step_fetch_error OR batch_header_fetch_error OR error_close_period THEN
223: x_return_status := fnd_api.g_ret_sts_error;
224: WHEN invalid_batch_status THEN
225: x_return_status := fnd_api.g_ret_sts_error;
226: gme_common_pvt.log_message ('GME_API_INV_BATCH_CLOSE_STEP');
227: WHEN invalid_batch_type THEN
228: x_return_status := fnd_api.g_ret_sts_error;
229: gme_common_pvt.log_message ('INVALID_BATCH_TYPE_CLS_STEP');

Line 228: x_return_status := fnd_api.g_ret_sts_error;

224: WHEN invalid_batch_status THEN
225: x_return_status := fnd_api.g_ret_sts_error;
226: gme_common_pvt.log_message ('GME_API_INV_BATCH_CLOSE_STEP');
227: WHEN invalid_batch_type THEN
228: x_return_status := fnd_api.g_ret_sts_error;
229: gme_common_pvt.log_message ('INVALID_BATCH_TYPE_CLS_STEP');
230: WHEN step_status_closed THEN
231: x_return_status := fnd_api.g_ret_sts_error;
232: gme_common_pvt.log_message ('GME_API_CLOSE_STEP_STATUS');

Line 231: x_return_status := fnd_api.g_ret_sts_error;

227: WHEN invalid_batch_type THEN
228: x_return_status := fnd_api.g_ret_sts_error;
229: gme_common_pvt.log_message ('INVALID_BATCH_TYPE_CLS_STEP');
230: WHEN step_status_closed THEN
231: x_return_status := fnd_api.g_ret_sts_error;
232: gme_common_pvt.log_message ('GME_API_CLOSE_STEP_STATUS');
233: WHEN invalid_step_status THEN
234: x_return_status := fnd_api.g_ret_sts_error;
235: gme_common_pvt.log_message ('GME_API_INV_STAT_STEP_CLS');

Line 234: x_return_status := fnd_api.g_ret_sts_error;

230: WHEN step_status_closed THEN
231: x_return_status := fnd_api.g_ret_sts_error;
232: gme_common_pvt.log_message ('GME_API_CLOSE_STEP_STATUS');
233: WHEN invalid_step_status THEN
234: x_return_status := fnd_api.g_ret_sts_error;
235: gme_common_pvt.log_message ('GME_API_INV_STAT_STEP_CLS');
236: WHEN dep_step_closed_error THEN
237: x_return_status := fnd_api.g_ret_sts_error;
238: gme_common_pvt.log_message ('GME_API_DEP_STEP_N_CLS');

Line 237: x_return_status := fnd_api.g_ret_sts_error;

233: WHEN invalid_step_status THEN
234: x_return_status := fnd_api.g_ret_sts_error;
235: gme_common_pvt.log_message ('GME_API_INV_STAT_STEP_CLS');
236: WHEN dep_step_closed_error THEN
237: x_return_status := fnd_api.g_ret_sts_error;
238: gme_common_pvt.log_message ('GME_API_DEP_STEP_N_CLS');
239: WHEN batch_step_upd_err THEN
240: gme_common_pvt.log_message ('GME_API_STEP_UPD_ERROR');
241: WHEN gme_invalid_date_range THEN

Line 242: x_return_status := fnd_api.g_ret_sts_error;

238: gme_common_pvt.log_message ('GME_API_DEP_STEP_N_CLS');
239: WHEN batch_step_upd_err THEN
240: gme_common_pvt.log_message ('GME_API_STEP_UPD_ERROR');
241: WHEN gme_invalid_date_range THEN
242: x_return_status := fnd_api.g_ret_sts_error;
243: WHEN close_phant_error OR trans_update_err OR trans_delete_err OR fetch_trans_err THEN
244: x_return_status := l_return_status;
245: WHEN pend_trans_err THEN
246: x_return_status := fnd_api.g_ret_sts_error;

Line 246: x_return_status := fnd_api.g_ret_sts_error;

242: x_return_status := fnd_api.g_ret_sts_error;
243: WHEN close_phant_error OR trans_update_err OR trans_delete_err OR fetch_trans_err THEN
244: x_return_status := l_return_status;
245: WHEN pend_trans_err THEN
246: x_return_status := fnd_api.g_ret_sts_error;
247: gme_common_pvt.log_message ('GME_PENDING_TRANS_ERROR');
248: WHEN OTHERS THEN
249: x_return_status := fnd_api.g_ret_sts_unexp_error;
250: fnd_msg_pub.add_exc_msg ('GME_API_CLOSE_STEP', 'CLOSE_STEP');

Line 249: x_return_status := fnd_api.g_ret_sts_unexp_error;

245: WHEN pend_trans_err THEN
246: x_return_status := fnd_api.g_ret_sts_error;
247: gme_common_pvt.log_message ('GME_PENDING_TRANS_ERROR');
248: WHEN OTHERS THEN
249: x_return_status := fnd_api.g_ret_sts_unexp_error;
250: fnd_msg_pub.add_exc_msg ('GME_API_CLOSE_STEP', 'CLOSE_STEP');
251: END close_step;
252: END gme_close_step_pvt;