DBA Data[Home] [Help]

APPS.GME_REOPEN_STEP_PVT dependencies on FND_API

Line 49: x_return_status := fnd_api.g_ret_sts_success;

45: batch_step_upd_err EXCEPTION;
46: reopen_phant_error EXCEPTION;
47: BEGIN
48: /* Set the success staus to success inititally*/
49: x_return_status := fnd_api.g_ret_sts_success;
50: /* Get all the step into the tab */
51: gme_close_batch_pvt.fetch_batch_steps
52: (p_batch_id => p_batch_header_rec.batch_id
53: ,p_batchstep_id => NULL

Line 57: IF x_return_status <> fnd_api.g_ret_sts_success THEN

53: ,p_batchstep_id => NULL
54: ,x_step_tbl => l_batch_steps_tab
55: ,x_return_status => x_return_status);
56:
57: IF x_return_status <> fnd_api.g_ret_sts_success THEN
58: RAISE batch_step_fetch_err;
59: END IF;
60:
61: FOR i IN 1 .. l_batch_steps_tab.COUNT LOOP

Line 106: x_return_status := fnd_api.g_ret_sts_error;

102: END IF; /* step_status = 4 */
103: END LOOP;
104: EXCEPTION
105: WHEN batch_step_fetch_err THEN
106: x_return_status := fnd_api.g_ret_sts_error;
107: WHEN batch_step_upd_err THEN
108: x_return_status := fnd_api.g_ret_sts_error;
109: WHEN batch_step_reopen_err THEN
110: x_return_status := fnd_api.g_ret_sts_error;

Line 108: x_return_status := fnd_api.g_ret_sts_error;

104: EXCEPTION
105: WHEN batch_step_fetch_err THEN
106: x_return_status := fnd_api.g_ret_sts_error;
107: WHEN batch_step_upd_err THEN
108: x_return_status := fnd_api.g_ret_sts_error;
109: WHEN batch_step_reopen_err THEN
110: x_return_status := fnd_api.g_ret_sts_error;
111: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
112: WHEN reopen_phant_error THEN

Line 110: x_return_status := fnd_api.g_ret_sts_error;

106: x_return_status := fnd_api.g_ret_sts_error;
107: WHEN batch_step_upd_err THEN
108: x_return_status := fnd_api.g_ret_sts_error;
109: WHEN batch_step_reopen_err THEN
110: x_return_status := fnd_api.g_ret_sts_error;
111: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
112: WHEN reopen_phant_error THEN
113: x_return_status := l_return_status;
114: WHEN OTHERS THEN

Line 115: x_return_status := fnd_api.g_ret_sts_unexp_error;

111: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
112: WHEN reopen_phant_error THEN
113: x_return_status := l_return_status;
114: WHEN OTHERS THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116: fnd_msg_pub.add_exc_msg ('GME_REOPEN_STEP_PVT', 'REOPEN_ALL_STEPS');
117: END reopen_all_steps;
118:
119: /*======================================================================================

Line 174: x_return_status := fnd_api.g_ret_sts_success;

170: l_return_status VARCHAR2 (1);
171: l_phantom_ids gme_common_pvt.number_tab;
172: BEGIN
173: -- Set the return status to success initially
174: x_return_status := fnd_api.g_ret_sts_success;
175:
176: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step => p_batch_step_rec
177: ,x_batch_step => x_batch_step_rec) ) THEN
178: RAISE batch_step_fetch_err;

Line 254: x_return_status := fnd_api.g_ret_sts_error;

250: END IF;
251: END LOOP;
252: EXCEPTION
253: WHEN batch_step_fetch_err THEN
254: x_return_status := fnd_api.g_ret_sts_error;
255: WHEN invalid_batch_status THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257: gme_common_pvt.log_message ('GME_API_INV_BATCH_STATUS_REOP');
258: WHEN invalid_step_status THEN

Line 256: x_return_status := fnd_api.g_ret_sts_error;

252: EXCEPTION
253: WHEN batch_step_fetch_err THEN
254: x_return_status := fnd_api.g_ret_sts_error;
255: WHEN invalid_batch_status THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257: gme_common_pvt.log_message ('GME_API_INV_BATCH_STATUS_REOP');
258: WHEN invalid_step_status THEN
259: x_return_status := fnd_api.g_ret_sts_error;
260: gme_common_pvt.log_message ('GME_API_INV_STEP_STATUS_REOP');

Line 259: x_return_status := fnd_api.g_ret_sts_error;

255: WHEN invalid_batch_status THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257: gme_common_pvt.log_message ('GME_API_INV_BATCH_STATUS_REOP');
258: WHEN invalid_step_status THEN
259: x_return_status := fnd_api.g_ret_sts_error;
260: gme_common_pvt.log_message ('GME_API_INV_STEP_STATUS_REOP');
261: WHEN batch_depend_step THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263: gme_common_pvt.log_message ('GME_API_DEP_STEP_REOPEN');

Line 262: x_return_status := fnd_api.g_ret_sts_error;

258: WHEN invalid_step_status THEN
259: x_return_status := fnd_api.g_ret_sts_error;
260: gme_common_pvt.log_message ('GME_API_INV_STEP_STATUS_REOP');
261: WHEN batch_depend_step THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263: gme_common_pvt.log_message ('GME_API_DEP_STEP_REOPEN');
264: WHEN batch_step_upd_err THEN
265: x_return_status := fnd_api.g_ret_sts_error;
266: WHEN reopen_phant_error THEN

Line 265: x_return_status := fnd_api.g_ret_sts_error;

261: WHEN batch_depend_step THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263: gme_common_pvt.log_message ('GME_API_DEP_STEP_REOPEN');
264: WHEN batch_step_upd_err THEN
265: x_return_status := fnd_api.g_ret_sts_error;
266: WHEN reopen_phant_error THEN
267: x_return_status := l_return_status;
268: WHEN OTHERS THEN
269: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 269: x_return_status := fnd_api.g_ret_sts_unexp_error;

265: x_return_status := fnd_api.g_ret_sts_error;
266: WHEN reopen_phant_error THEN
267: x_return_status := l_return_status;
268: WHEN OTHERS THEN
269: x_return_status := fnd_api.g_ret_sts_unexp_error;
270: fnd_msg_pub.add_exc_msg ('GME_REOPEN_STEP_PVT', 'REOPEN_STEP');
271: END reopen_step;
272: END gme_reopen_step_pvt;