DBA Data[Home] [Help]

APPS.GME_CLOSE_BATCH_PVT dependencies on FND_API

Line 140: x_return_status := fnd_api.g_ret_sts_success;

136: || l_api_name);
137: END IF;
138:
139: /* Set the success staus to success inititally*/
140: x_return_status := fnd_api.g_ret_sts_success;
141:
142: /* Initialize output batch header*/
143: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
144: ,x_batch_header_rec) ) THEN

Line 179: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

175: ,x_msg_count => l_message_count
176: ,x_msg_data => l_message_list
177: ,x_return_status => x_return_status);
178:
179: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
180: RAISE error_processing;
181: END IF;
182: -- 4944024 END
183:

Line 256: IF x_return_status <> fnd_api.g_ret_sts_success THEN

252: (p_batch_header_rec => x_batch_header_rec
253: ,p_delete_reservations => 'T'
254: ,x_return_status => x_return_status);
255:
256: IF x_return_status <> fnd_api.g_ret_sts_success THEN
257: RAISE purge_exception_err;
258: END IF;
259: END IF;
260:

Line 396: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

392: l_total_actual_output,
393: l_uom,
394: l_return_status
395: );
396: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
397: RAISE ERROR_IN_GET_TOTAL_QTY;
398: ELSE
399: -- Pawan Added for bug 5256361
400: IF l_total_actual_output > 0 THEN

Line 435: p_init_msg_list => FND_API.G_FALSE,

431: -- Bug 5903208 - call to GMF
432: --
433: GMF_VIB.Finalize_VIB_Details
434: ( p_api_version => 1.0,
435: p_init_msg_list => FND_API.G_FALSE,
436: p_batch_id => x_batch_header_rec.batch_id,
437: x_return_status => x_return_status,
438: x_msg_count => l_message_count,
439: x_msg_data => l_message_list);

Line 441: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

437: x_return_status => x_return_status,
438: x_msg_count => l_message_count,
439: x_msg_data => l_message_list);
440:
441: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
442: THEN
443: RAISE gmf_cost_failure;
444: END IF;
445:

Line 449: x_return_status := FND_API.G_RET_STS_ERROR;

445:
446: EXCEPTION
447: WHEN gmf_cost_failure THEN
448: -- Bug 5903208
449: x_return_status := FND_API.G_RET_STS_ERROR;
450:
451: WHEN batch_header_fetch_error THEN
452: x_return_status := fnd_api.g_ret_sts_error;
453: WHEN invalid_batch_status THEN

Line 452: x_return_status := fnd_api.g_ret_sts_error;

448: -- Bug 5903208
449: x_return_status := FND_API.G_RET_STS_ERROR;
450:
451: WHEN batch_header_fetch_error THEN
452: x_return_status := fnd_api.g_ret_sts_error;
453: WHEN invalid_batch_status THEN
454: x_return_status := fnd_api.g_ret_sts_error;
455: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
456: ,'PROCESS'

Line 454: x_return_status := fnd_api.g_ret_sts_error;

450:
451: WHEN batch_header_fetch_error THEN
452: x_return_status := fnd_api.g_ret_sts_error;
453: WHEN invalid_batch_status THEN
454: x_return_status := fnd_api.g_ret_sts_error;
455: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
456: ,'PROCESS'
457: ,'Close');
458: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN

Line 459: x_return_status := fnd_api.g_ret_sts_error;

455: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS'
456: ,'PROCESS'
457: ,'Close');
458: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN
459: x_return_status := fnd_api.g_ret_sts_error;
460: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
461: WHEN marked_for_deletion THEN
462: x_return_status := fnd_api.g_ret_sts_error;
463: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');

Line 462: x_return_status := fnd_api.g_ret_sts_error;

458: WHEN batch_lines_locked OR app_exception.record_lock_exception THEN
459: x_return_status := fnd_api.g_ret_sts_error;
460: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
461: WHEN marked_for_deletion THEN
462: x_return_status := fnd_api.g_ret_sts_error;
463: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
464: WHEN steps_not_closed THEN
465: x_return_status := fnd_api.g_ret_sts_error;
466: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');

Line 465: x_return_status := fnd_api.g_ret_sts_error;

461: WHEN marked_for_deletion THEN
462: x_return_status := fnd_api.g_ret_sts_error;
463: gme_common_pvt.log_message ('GME_API_MARKED_FOR_DELETION');
464: WHEN steps_not_closed THEN
465: x_return_status := fnd_api.g_ret_sts_error;
466: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');
467: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception
468: WHEN batch_header_upd_err OR batch_close_date_err OR material_detail_upd_err THEN
469: x_return_status := fnd_api.g_ret_sts_error;

Line 469: x_return_status := fnd_api.g_ret_sts_error;

465: x_return_status := fnd_api.g_ret_sts_error;
466: gme_common_pvt.log_message ('GME_API_STEPS_NOT_CLOSE');
467: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception
468: WHEN batch_header_upd_err OR batch_close_date_err OR material_detail_upd_err THEN
469: x_return_status := fnd_api.g_ret_sts_error;
470: WHEN batch_hist_insert_err THEN
471: x_return_status := fnd_api.g_ret_sts_error;
472: WHEN dep_batch_step_fetch_err THEN
473: x_return_status := fnd_api.g_ret_sts_error;

Line 471: x_return_status := fnd_api.g_ret_sts_error;

467: --FPBug#4684029 added MATERIAL_DETAIL_UPD_ERR exception
468: WHEN batch_header_upd_err OR batch_close_date_err OR material_detail_upd_err THEN
469: x_return_status := fnd_api.g_ret_sts_error;
470: WHEN batch_hist_insert_err THEN
471: x_return_status := fnd_api.g_ret_sts_error;
472: WHEN dep_batch_step_fetch_err THEN
473: x_return_status := fnd_api.g_ret_sts_error;
474: WHEN batch_step_close_error THEN
475: x_return_status := fnd_api.g_ret_sts_error;

Line 473: x_return_status := fnd_api.g_ret_sts_error;

469: x_return_status := fnd_api.g_ret_sts_error;
470: WHEN batch_hist_insert_err THEN
471: x_return_status := fnd_api.g_ret_sts_error;
472: WHEN dep_batch_step_fetch_err THEN
473: x_return_status := fnd_api.g_ret_sts_error;
474: WHEN batch_step_close_error THEN
475: x_return_status := fnd_api.g_ret_sts_error;
476: --FPBug#4684029
477: WHEN error_in_get_total_qty THEN

Line 475: x_return_status := fnd_api.g_ret_sts_error;

471: x_return_status := fnd_api.g_ret_sts_error;
472: WHEN dep_batch_step_fetch_err THEN
473: x_return_status := fnd_api.g_ret_sts_error;
474: WHEN batch_step_close_error THEN
475: x_return_status := fnd_api.g_ret_sts_error;
476: --FPBug#4684029
477: WHEN error_in_get_total_qty THEN
478: x_return_status := l_return_status;
479: WHEN close_phant_fail THEN

Line 495: x_return_status := fnd_api.g_ret_sts_error;

491: || ':'
492: || 'MATERIAL_FETCH_ERROR');
493: END IF;
494:
495: x_return_status := fnd_api.g_ret_sts_error;
496: WHEN purge_exception_err THEN
497: IF (g_debug <= gme_debug.g_log_procedure) THEN
498: gme_debug.put_line ( g_pkg_name
499: || '.'

Line 505: x_return_status := fnd_api.g_ret_sts_unexp_error;

501: || ':'
502: || 'purge_exception_err');
503: END IF;
504: WHEN OTHERS THEN
505: x_return_status := fnd_api.g_ret_sts_unexp_error;
506: fnd_msg_pub.add_exc_msg ('GME_CLOSE_BATCH_PVT', 'CLOSE_BATCH');
507: END close_batch;
508:
509: /*===============================================================================

Line 825: x_return_status := fnd_api.g_ret_sts_success;

821: step_details_missing EXCEPTION;
822: circular_reference EXCEPTION;
823: PRAGMA EXCEPTION_INIT (circular_reference, -01436);
824: BEGIN
825: x_return_status := fnd_api.g_ret_sts_success;
826:
827: /* Fetch the routing for the batch passed in */
828: OPEN cur_get_routing (p_batch_id);
829:

Line 897: x_return_status := fnd_api.g_ret_sts_error;

893: CLOSE cur_get_final_steps;
894: END IF; /* IF p_batchstep_id IS NULL */
895: EXCEPTION
896: WHEN no_routing_associated THEN
897: x_return_status := fnd_api.g_ret_sts_error;
898: fnd_message.set_name ('GMD', 'GMD_NO_ROUTING_ASSOCIATED');
899: fnd_msg_pub.ADD;
900: WHEN step_details_missing THEN
901: x_return_status := fnd_api.g_ret_sts_error;

Line 901: x_return_status := fnd_api.g_ret_sts_error;

897: x_return_status := fnd_api.g_ret_sts_error;
898: fnd_message.set_name ('GMD', 'GMD_NO_ROUTING_ASSOCIATED');
899: fnd_msg_pub.ADD;
900: WHEN step_details_missing THEN
901: x_return_status := fnd_api.g_ret_sts_error;
902: fnd_message.set_name ('GMD', 'GME_STEP_DETAILS_MISSING');
903: fnd_msg_pub.ADD;
904: WHEN circular_reference THEN
905: fnd_message.set_name ('GMD', 'GMD_CIRCULAR_DEPEN_DETECT');

Line 907: x_return_status := fnd_api.g_ret_sts_error;

903: fnd_msg_pub.ADD;
904: WHEN circular_reference THEN
905: fnd_message.set_name ('GMD', 'GMD_CIRCULAR_DEPEN_DETECT');
906: fnd_msg_pub.ADD;
907: x_return_status := fnd_api.g_ret_sts_error;
908: WHEN OTHERS THEN
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
911: fnd_message.set_token ('ERROR', SQLERRM);

Line 909: x_return_status := fnd_api.g_ret_sts_unexp_error;

905: fnd_message.set_name ('GMD', 'GMD_CIRCULAR_DEPEN_DETECT');
906: fnd_msg_pub.ADD;
907: x_return_status := fnd_api.g_ret_sts_error;
908: WHEN OTHERS THEN
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
911: fnd_message.set_token ('ERROR', SQLERRM);
912: fnd_msg_pub.ADD;
913: END fetch_batch_steps;