DBA Data[Home] [Help]

APPS.GME_REOPEN_BATCH_PVT dependencies on FND_API

Line 107: x_return_status := fnd_api.g_ret_sts_success;

103: gmf_cost_failure EXCEPTION;
104:
105: BEGIN
106: /* Set the return staus to success inititally*/
107: x_return_status := fnd_api.g_ret_sts_success;
108:
109: /* Initialize output batch header */
110: x_batch_header_rec := p_batch_header_rec ;
111: /* x_batch_header_rec gets the batch_id */

Line 171: ,p_init_msg_list => fnd_api.g_false

167:
168: l_batch_cost :=
169: gmf_cmcommon.is_batch_cost_frozen
170: (p_api_version => 2
171: ,p_init_msg_list => fnd_api.g_false
172: ,p_commit => fnd_api.g_false
173: ,x_return_status => l_return_status
174: ,x_msg_count => l_msg_count
175: ,x_msg_data => l_msg_data

Line 172: ,p_commit => fnd_api.g_false

168: l_batch_cost :=
169: gmf_cmcommon.is_batch_cost_frozen
170: (p_api_version => 2
171: ,p_init_msg_list => fnd_api.g_false
172: ,p_commit => fnd_api.g_false
173: ,x_return_status => l_return_status
174: ,x_msg_count => l_msg_count
175: ,x_msg_data => l_msg_data
176: ,p_batch_id => p_batch_header_rec.batch_id);

Line 190: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

186: (p_batch_row => x_batch_header_rec
187: ,x_rsc_row_count => l_rsrc_cnt
188: ,x_return_status => l_status);
189:
190: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
191: RAISE fnd_api.g_exc_error;
192: END IF;
193:
194: /* Now we have to reopen any existing phantoms which are not

Line 191: RAISE fnd_api.g_exc_error;

187: ,x_rsc_row_count => l_rsrc_cnt
188: ,x_return_status => l_status);
189:
190: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
191: RAISE fnd_api.g_exc_error;
192: END IF;
193:
194: /* Now we have to reopen any existing phantoms which are not
195: associated step and release type of "Automatic by step" */

Line 220: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

216: ,p_reopen_steps => p_reopen_steps
217: ,x_batch_header_rec => l_batch_header
218: ,x_return_status => x_return_status);
219:
220: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
221: RAISE phantom_batch_reopen_err;
222: END IF;
223: END IF; /* if batch_status = 4 */
224: END LOOP;

Line 235: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

231: gme_reopen_step_pvt.reopen_all_steps
232: (p_batch_header_rec => x_batch_header_rec
233: ,x_return_status => x_return_status);
234:
235: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
236: RAISE batch_step_reopen_err;
237: END IF;
238: END IF; --delete only if we have steps in batch
239: END IF; -- reopen steps only if the parameter indicates so

Line 294: p_init_msg_list => FND_API.G_FALSE,

290: -- Bug 5903208 - Make call to GMF to revert finalization layers for this batch
291: --
292: GMF_VIB.Revert_Finalization
293: ( p_api_version => 1.0,
294: p_init_msg_list => FND_API.G_FALSE,
295: p_batch_id => x_batch_header_rec.batch_id,
296: x_return_status => x_return_status,
297: x_msg_count => l_message_count,
298: x_msg_data => l_message_list);

Line 300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

296: x_return_status => x_return_status,
297: x_msg_count => l_message_count,
298: x_msg_data => l_message_list);
299:
300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
301: THEN
302: RAISE gmf_cost_failure;
303: END IF;
304: -- End Bug 5903208

Line 317: x_return_status := FND_API.G_RET_STS_ERROR;

313: END IF;
314: EXCEPTION
315: WHEN gmf_cost_failure THEN
316: -- Bug 5043868
317: x_return_status := FND_API.G_RET_STS_ERROR;
318:
319: WHEN batch_cost_err THEN
320: x_return_status := fnd_api.g_ret_sts_error;
321: /* WHEN batch_header_locked_err THEN

Line 320: x_return_status := fnd_api.g_ret_sts_error;

316: -- Bug 5043868
317: x_return_status := FND_API.G_RET_STS_ERROR;
318:
319: WHEN batch_cost_err THEN
320: x_return_status := fnd_api.g_ret_sts_error;
321: /* WHEN batch_header_locked_err THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: gme_common_pvt.log_message ('GME_BATCH_IN_USE');*/
324: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN

Line 322: x_return_status := fnd_api.g_ret_sts_error;

318:
319: WHEN batch_cost_err THEN
320: x_return_status := fnd_api.g_ret_sts_error;
321: /* WHEN batch_header_locked_err THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: gme_common_pvt.log_message ('GME_BATCH_IN_USE');*/
324: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN
325: x_return_status := fnd_api.g_ret_sts_error;
326: WHEN cant_reopen_migrated_batch THEN

Line 324: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN

320: x_return_status := fnd_api.g_ret_sts_error;
321: /* WHEN batch_header_locked_err THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: gme_common_pvt.log_message ('GME_BATCH_IN_USE');*/
324: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN
325: x_return_status := fnd_api.g_ret_sts_error;
326: WHEN cant_reopen_migrated_batch THEN
327: x_return_status := fnd_api.g_ret_sts_error;
328: gme_common_pvt.log_message ('GME_API_MIG_BATCH_FOR_REOPEN');

Line 325: x_return_status := fnd_api.g_ret_sts_error;

321: /* WHEN batch_header_locked_err THEN
322: x_return_status := fnd_api.g_ret_sts_error;
323: gme_common_pvt.log_message ('GME_BATCH_IN_USE');*/
324: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN
325: x_return_status := fnd_api.g_ret_sts_error;
326: WHEN cant_reopen_migrated_batch THEN
327: x_return_status := fnd_api.g_ret_sts_error;
328: gme_common_pvt.log_message ('GME_API_MIG_BATCH_FOR_REOPEN');
329: WHEN invalid_batch_type THEN

Line 327: x_return_status := fnd_api.g_ret_sts_error;

323: gme_common_pvt.log_message ('GME_BATCH_IN_USE');*/
324: WHEN batch_header_fetch_err OR fnd_api.g_exc_error THEN
325: x_return_status := fnd_api.g_ret_sts_error;
326: WHEN cant_reopen_migrated_batch THEN
327: x_return_status := fnd_api.g_ret_sts_error;
328: gme_common_pvt.log_message ('GME_API_MIG_BATCH_FOR_REOPEN');
329: WHEN invalid_batch_type THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');

Line 330: x_return_status := fnd_api.g_ret_sts_error;

326: WHEN cant_reopen_migrated_batch THEN
327: x_return_status := fnd_api.g_ret_sts_error;
328: gme_common_pvt.log_message ('GME_API_MIG_BATCH_FOR_REOPEN');
329: WHEN invalid_batch_type THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');
332: WHEN invalid_batch_status THEN
333: x_return_status := fnd_api.g_ret_sts_error;
334: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'

Line 333: x_return_status := fnd_api.g_ret_sts_error;

329: WHEN invalid_batch_type THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: gme_common_pvt.log_message ('GME_API_INV_BATCH_TYPE');
332: WHEN invalid_batch_status THEN
333: x_return_status := fnd_api.g_ret_sts_error;
334: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
335: ,'PROCESS'
336: ,'Reopen');
337: /* WHEN batch_already_purged THEN

Line 338: x_return_status := fnd_api.g_ret_sts_error;

334: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
335: ,'PROCESS'
336: ,'Reopen');
337: /* WHEN batch_already_purged THEN
338: x_return_status := fnd_api.g_ret_sts_error;
339: gme_common_pvt.log_message ('GME_API_TRANSACTIONS_PURGED');*/
340: WHEN batch_already_posted THEN
341: x_return_status := fnd_api.g_ret_sts_error;
342: gme_common_pvt.log_message ('GME_API_GL_POSTED');

Line 341: x_return_status := fnd_api.g_ret_sts_error;

337: /* WHEN batch_already_purged THEN
338: x_return_status := fnd_api.g_ret_sts_error;
339: gme_common_pvt.log_message ('GME_API_TRANSACTIONS_PURGED');*/
340: WHEN batch_already_posted THEN
341: x_return_status := fnd_api.g_ret_sts_error;
342: gme_common_pvt.log_message ('GME_API_GL_POSTED');
343: WHEN batch_costed_and_period_closed THEN
344: x_return_status := fnd_api.g_ret_sts_error;
345: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');

Line 344: x_return_status := fnd_api.g_ret_sts_error;

340: WHEN batch_already_posted THEN
341: x_return_status := fnd_api.g_ret_sts_error;
342: gme_common_pvt.log_message ('GME_API_GL_POSTED');
343: WHEN batch_costed_and_period_closed THEN
344: x_return_status := fnd_api.g_ret_sts_error;
345: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');
346: /* WHEN marked_for_deletion THEN
347: x_return_status := fnd_api.g_ret_sts_error;
348: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/

Line 347: x_return_status := fnd_api.g_ret_sts_error;

343: WHEN batch_costed_and_period_closed THEN
344: x_return_status := fnd_api.g_ret_sts_error;
345: gme_common_pvt.log_message ('GME_API_COST_PERIOD_CLOSED');
346: /* WHEN marked_for_deletion THEN
347: x_return_status := fnd_api.g_ret_sts_error;
348: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/
349: WHEN batch_step_reopen_err THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');

Line 350: x_return_status := fnd_api.g_ret_sts_error;

346: /* WHEN marked_for_deletion THEN
347: x_return_status := fnd_api.g_ret_sts_error;
348: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');*/
349: WHEN batch_step_reopen_err THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
352: WHEN batch_header_upd_err THEN
353: x_return_status := fnd_api.g_ret_sts_error;
354: WHEN batch_hist_insert_err THEN

Line 353: x_return_status := fnd_api.g_ret_sts_error;

349: WHEN batch_step_reopen_err THEN
350: x_return_status := fnd_api.g_ret_sts_error;
351: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
352: WHEN batch_header_upd_err THEN
353: x_return_status := fnd_api.g_ret_sts_error;
354: WHEN batch_hist_insert_err THEN
355: x_return_status := fnd_api.g_ret_sts_error;
356: WHEN phantom_batch_reopen_err THEN
357: NULL;

Line 355: x_return_status := fnd_api.g_ret_sts_error;

351: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
352: WHEN batch_header_upd_err THEN
353: x_return_status := fnd_api.g_ret_sts_error;
354: WHEN batch_hist_insert_err THEN
355: x_return_status := fnd_api.g_ret_sts_error;
356: WHEN phantom_batch_reopen_err THEN
357: NULL;
358: WHEN OTHERS THEN
359: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 359: x_return_status := fnd_api.g_ret_sts_unexp_error;

355: x_return_status := fnd_api.g_ret_sts_error;
356: WHEN phantom_batch_reopen_err THEN
357: NULL;
358: WHEN OTHERS THEN
359: x_return_status := fnd_api.g_ret_sts_unexp_error;
360: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
361: END reopen_batch;
362:
363: /*===============================================================================