DBA Data[Home] [Help]

APPS.GME_CLOSE_BATCH_PVT dependencies on FND_API

Line 119: x_return_status := fnd_api.g_ret_sts_success;

115: || l_api_name);
116: END IF;
117:
118: /* Set the success staus to success inititally*/
119: x_return_status := fnd_api.g_ret_sts_success;
120:
121: /* Initialize output batch header*/
122: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
123: ,x_batch_header_rec) ) THEN

Line 158: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

154: ,x_msg_count => l_message_count
155: ,x_msg_data => l_message_list
156: ,x_return_status => x_return_status);
157:
158: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
159: RAISE error_processing;
160: END IF;
161: -- 4944024 END
162:

Line 311: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

307: l_total_actual_output,
308: l_uom,
309: l_return_status
310: );
311: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
312: RAISE ERROR_IN_GET_TOTAL_QTY;
313: ELSE
314: -- Pawan Added for bug 5256361
315: IF l_total_actual_output > 0 THEN

Line 350: p_init_msg_list => FND_API.G_FALSE,

346: -- Bug 5903208 - call to GMF
347: --
348: GMF_VIB.Finalize_VIB_Details
349: ( p_api_version => 1.0,
350: p_init_msg_list => FND_API.G_FALSE,
351: p_batch_id => x_batch_header_rec.batch_id,
352: x_return_status => x_return_status,
353: x_msg_count => l_message_count,
354: x_msg_data => l_message_list);

Line 356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

352: x_return_status => x_return_status,
353: x_msg_count => l_message_count,
354: x_msg_data => l_message_list);
355:
356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
357: THEN
358: RAISE gmf_cost_failure;
359: END IF;
360:

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360:
361: EXCEPTION
362: WHEN gmf_cost_failure THEN
363: -- Bug 5903208
364: x_return_status := FND_API.G_RET_STS_ERROR;
365:
366: WHEN batch_header_fetch_error THEN
367: x_return_status := fnd_api.g_ret_sts_error;
368: WHEN invalid_batch_status THEN

Line 367: x_return_status := fnd_api.g_ret_sts_error;

363: -- Bug 5903208
364: x_return_status := FND_API.G_RET_STS_ERROR;
365:
366: WHEN batch_header_fetch_error THEN
367: x_return_status := fnd_api.g_ret_sts_error;
368: WHEN invalid_batch_status THEN
369: x_return_status := fnd_api.g_ret_sts_error;
370: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
371: ,'PROCESS'

Line 369: x_return_status := fnd_api.g_ret_sts_error;

365:
366: WHEN batch_header_fetch_error THEN
367: x_return_status := fnd_api.g_ret_sts_error;
368: WHEN invalid_batch_status THEN
369: x_return_status := fnd_api.g_ret_sts_error;
370: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
371: ,'PROCESS'
372: ,'Close');
373: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN

Line 374: x_return_status := fnd_api.g_ret_sts_error;

370: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
371: ,'PROCESS'
372: ,'Close');
373: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN
374: x_return_status := fnd_api.g_ret_sts_error;
375: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
376: WHEN marked_for_deletion THEN
377: x_return_status := fnd_api.g_ret_sts_error;
378: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');

Line 377: x_return_status := fnd_api.g_ret_sts_error;

373: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN
374: x_return_status := fnd_api.g_ret_sts_error;
375: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
376: WHEN marked_for_deletion THEN
377: x_return_status := fnd_api.g_ret_sts_error;
378: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
379: WHEN steps_not_closed THEN
380: x_return_status := fnd_api.g_ret_sts_error;
381: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');

Line 380: x_return_status := fnd_api.g_ret_sts_error;

376: WHEN marked_for_deletion THEN
377: x_return_status := fnd_api.g_ret_sts_error;
378: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
379: WHEN steps_not_closed THEN
380: x_return_status := fnd_api.g_ret_sts_error;
381: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');
382: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception
383: WHEN batch_header_upd_err OR batch_close_date_err OR material_detail_upd_err THEN
384: x_return_status := fnd_api.g_ret_sts_error;

Line 384: x_return_status := fnd_api.g_ret_sts_error;

380: x_return_status := fnd_api.g_ret_sts_error;
381: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');
382: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception
383: WHEN batch_header_upd_err OR batch_close_date_err OR material_detail_upd_err THEN
384: x_return_status := fnd_api.g_ret_sts_error;
385: WHEN batch_hist_insert_err THEN
386: x_return_status := fnd_api.g_ret_sts_error;
387: WHEN dep_batch_step_fetch_err THEN
388: x_return_status := fnd_api.g_ret_sts_error;

Line 386: x_return_status := fnd_api.g_ret_sts_error;

382: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception
383: WHEN batch_header_upd_err OR batch_close_date_err OR material_detail_upd_err THEN
384: x_return_status := fnd_api.g_ret_sts_error;
385: WHEN batch_hist_insert_err THEN
386: x_return_status := fnd_api.g_ret_sts_error;
387: WHEN dep_batch_step_fetch_err THEN
388: x_return_status := fnd_api.g_ret_sts_error;
389: WHEN batch_step_close_error THEN
390: x_return_status := fnd_api.g_ret_sts_error;

Line 388: x_return_status := fnd_api.g_ret_sts_error;

384: x_return_status := fnd_api.g_ret_sts_error;
385: WHEN batch_hist_insert_err THEN
386: x_return_status := fnd_api.g_ret_sts_error;
387: WHEN dep_batch_step_fetch_err THEN
388: x_return_status := fnd_api.g_ret_sts_error;
389: WHEN batch_step_close_error THEN
390: x_return_status := fnd_api.g_ret_sts_error;
391: --FPBug#4684029
392: WHEN error_in_get_total_qty THEN

Line 390: x_return_status := fnd_api.g_ret_sts_error;

386: x_return_status := fnd_api.g_ret_sts_error;
387: WHEN dep_batch_step_fetch_err THEN
388: x_return_status := fnd_api.g_ret_sts_error;
389: WHEN batch_step_close_error THEN
390: x_return_status := fnd_api.g_ret_sts_error;
391: --FPBug#4684029
392: WHEN error_in_get_total_qty THEN
393: x_return_status := l_return_status;
394: WHEN close_phant_fail THEN

Line 401: x_return_status := fnd_api.g_ret_sts_unexp_error;

397: IF g_debug <= gme_debug.g_log_procedure THEN
398: gme_debug.put_line ('Terminating due to error deleteing reservations against this batch supply.');
399: END IF; -- 4944024 END
400: WHEN OTHERS THEN
401: x_return_status := fnd_api.g_ret_sts_unexp_error;
402: fnd_msg_pub.add_exc_msg ('GME_CLOSE_BATCH_PVT', 'CLOSE_BATCH');
403: END close_batch;
404:
405: /*===============================================================================

Line 721: x_return_status := fnd_api.g_ret_sts_success;

717: step_details_missing EXCEPTION;
718: circular_reference EXCEPTION;
719: PRAGMA EXCEPTION_INIT (circular_reference, -01436);
720: BEGIN
721: x_return_status := fnd_api.g_ret_sts_success;
722:
723: /* Fetch the routing for the batch passed in */
724: OPEN cur_get_routing (p_batch_id);
725:

Line 789: x_return_status := fnd_api.g_ret_sts_error;

785: CLOSE cur_get_final_steps;
786: END IF; /* IF p_batchstep_id IS NULL */
787: EXCEPTION
788: WHEN no_routing_associated THEN
789: x_return_status := fnd_api.g_ret_sts_error;
790: fnd_message.set_name ('GMD', 'GMD_NO_ROUTING_ASSOCIATED');
791: fnd_msg_pub.ADD;
792: WHEN step_details_missing THEN
793: x_return_status := fnd_api.g_ret_sts_error;

Line 793: x_return_status := fnd_api.g_ret_sts_error;

789: x_return_status := fnd_api.g_ret_sts_error;
790: fnd_message.set_name ('GMD', 'GMD_NO_ROUTING_ASSOCIATED');
791: fnd_msg_pub.ADD;
792: WHEN step_details_missing THEN
793: x_return_status := fnd_api.g_ret_sts_error;
794: fnd_message.set_name ('GMD', 'GME_STEP_DETAILS_MISSING');
795: fnd_msg_pub.ADD;
796: WHEN circular_reference THEN
797: fnd_message.set_name ('GMD', 'GMD_CIRCULAR_DEPEN_DETECT');

Line 799: x_return_status := fnd_api.g_ret_sts_error;

795: fnd_msg_pub.ADD;
796: WHEN circular_reference THEN
797: fnd_message.set_name ('GMD', 'GMD_CIRCULAR_DEPEN_DETECT');
798: fnd_msg_pub.ADD;
799: x_return_status := fnd_api.g_ret_sts_error;
800: WHEN OTHERS THEN
801: x_return_status := fnd_api.g_ret_sts_unexp_error;
802: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
803: fnd_message.set_token ('ERROR', SQLERRM);

Line 801: x_return_status := fnd_api.g_ret_sts_unexp_error;

797: fnd_message.set_name ('GMD', 'GMD_CIRCULAR_DEPEN_DETECT');
798: fnd_msg_pub.ADD;
799: x_return_status := fnd_api.g_ret_sts_error;
800: WHEN OTHERS THEN
801: x_return_status := fnd_api.g_ret_sts_unexp_error;
802: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
803: fnd_message.set_token ('ERROR', SQLERRM);
804: fnd_msg_pub.ADD;
805: END fetch_batch_steps;