eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_RELEASE_BATCH_STEP_PVT dependencies on FND_API

Line 56: x_return_status := fnd_api.g_ret_sts_success;

52: || p_batch_step_rec.batchstep_id);
53: END IF;
54:
55: /* Set the return status to success initially */
56: x_return_status := fnd_api.g_ret_sts_success;
57: l_batch_step_rec := p_batch_step_rec;
58: l_batch_header_rec := p_batch_header_rec;
59:
60: /* Bug#5109119 initialize with NULL and it should be NULL as we are testing

Line 73: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

69: ,x_exception_material_tbl => x_exception_material_tbl
70: ,x_return_status => l_return_status);
71:
72: IF l_return_status NOT IN
73: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
74: x_return_status := l_return_status;
75: RAISE error_release_step_rec;
76: END IF;
77:

Line 102: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

98: ,x_return_status => l_return_status
99: ,x_exception_material_tbl => x_exception_material_tbl);
100:
101: IF l_return_status NOT IN
102: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
103: x_return_status := l_return_status;
104: RAISE error_release_batch;
105: END IF;
106:

Line 132: x_return_status := fnd_api.g_ret_sts_unexp_error;

128: || ': '
129: || SQLERRM);
130: END IF;
131:
132: x_return_status := fnd_api.g_ret_sts_unexp_error;
133: END release_step;
134:
135: /*===========================================================================================
136: Procedure

Line 190: x_return_status := fnd_api.g_ret_sts_success;

186: || to_char(p_batch_step_rec.actual_start_date,'YYYY-MON-DD HH24:MI:SS'));
187: END IF;
188:
189: /* Set the return status to success initially */
190: x_return_status := fnd_api.g_ret_sts_success;
191:
192: /* Exit the recursive loop if the step is already released, completed or closed */
193: IF p_batch_step_rec.step_status IN
194: (gme_common_pvt.g_step_wip

Line 205: IF x_return_status <> fnd_api.g_ret_sts_success THEN

201: (p_batch_step => p_batch_step_rec
202: ,x_batch_step => l_batch_step_rec
203: ,x_return_status => x_return_status);
204:
205: IF x_return_status <> fnd_api.g_ret_sts_success THEN
206: RAISE error_validation;
207: END IF;
208:
209: process_dependent_steps

Line 216: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

212: ,x_exception_material_tbl => x_exception_material_tbl
213: ,x_return_status => l_return_status);
214:
215: IF l_return_status NOT IN
216: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
217: x_return_status := l_return_status;
218: RAISE error_process_dep_steps;
219: END IF;
220:

Line 236: IF l_return_status <> fnd_api.g_ret_sts_success THEN

232: ,x_batch_step_rec => x_batch_step_rec
233: ,x_exception_material_tbl => x_exception_material_tbl
234: ,x_return_status => l_return_status);
235:
236: IF l_return_status <> fnd_api.g_ret_sts_success THEN
237: x_return_status := l_return_status;
238: RAISE rel_step_line_error;
239: END IF;
240:

Line 248: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

244: ,x_exception_material_tbl => x_exception_material_tbl
245: ,x_return_status => l_return_status);
246:
247: IF l_return_status NOT IN
248: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
249: x_return_status := l_return_status;
250: RAISE rel_step_ing_error;
251: END IF;
252:

Line 267: IF l_return_status <> fnd_api.g_ret_sts_success THEN

263: ,x_message_list => l_msg_stack
264: ,x_return_status => l_return_status
265: ,x_batch_step_rec => x_batch_step_rec);
266:
267: IF l_return_status <> fnd_api.g_ret_sts_success THEN
268: RAISE update_step_qty_error;
269: END IF;
270:
271: /* Needs to be done for each step released */

Line 302: x_return_status := fnd_api.g_ret_sts_unexp_error;

298: || ': '
299: || SQLERRM);
300: END IF;
301:
302: x_return_status := fnd_api.g_ret_sts_unexp_error;
303: END release_step_recursive;
304:
305: PROCEDURE process_dependent_steps (
306: p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 348: x_return_status := fnd_api.g_ret_sts_success;

344: || p_batch_step_rec.batchstep_id);
345: END IF;
346:
347: /* Set the return status to success initially */
348: x_return_status := fnd_api.g_ret_sts_success;
349:
350: /* Bug#5109119 Begin check the close period for current step. this check will be done for current step and dependent steps
351: also as process_dependent_steps will be called for each step*/
352:

Line 450: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

446: ,x_exception_material_tbl => x_exception_material_tbl
447: ,x_return_status => l_return_status);
448:
449: IF l_return_status NOT IN
450: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
451: x_return_status := l_return_status;
452: RAISE dep_step_rel_error;
453: END IF;
454:

Line 485: (fnd_api.g_ret_sts_success

481: ,x_batch_step_rec => l_batch_step_rec
482: ,x_exception_material_tbl => x_exception_material_tbl);
483:
484: IF l_return_status NOT IN
485: (fnd_api.g_ret_sts_success
486: ,gme_common_pvt.g_exceptions_err) THEN
487: x_return_status := l_return_status;
488: RAISE dep_step_cmpl_error;
489: END IF;

Line 515: x_return_status := FND_API.G_RET_STS_ERROR;

511: END IF;
512: EXCEPTION
513: --Bug#5109119 Begin
514: WHEN error_close_period THEN
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: WHEN error_future_date THEN
517: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
518: fnd_msg_pub.ADD;
519: x_return_status := FND_API.G_RET_STS_ERROR;

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: x_return_status := FND_API.G_RET_STS_ERROR;
516: WHEN error_future_date THEN
517: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
518: fnd_msg_pub.ADD;
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: --Bug#5109119 End
521: WHEN batch_step_fetch_error THEN
522: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
523: ,SQLERRM);

Line 524: x_return_status := fnd_api.g_ret_sts_unexp_error;

520: --Bug#5109119 End
521: WHEN batch_step_fetch_error THEN
522: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
523: ,SQLERRM);
524: x_return_status := fnd_api.g_ret_sts_unexp_error;
525: WHEN dep_step_rel_error OR dep_step_cmpl_error THEN
526: NULL;
527: WHEN OTHERS THEN
528: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 539: x_return_status := fnd_api.g_ret_sts_unexp_error;

535: || ': '
536: || SQLERRM);
537: END IF;
538:
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: END process_dependent_steps;
541:
542: /*===========================================================================================
543: Procedure

Line 582: x_return_status := fnd_api.g_ret_sts_success;

578: || ' Release step line batchstep_id='
579: || p_batch_step_rec.batchstep_id);
580: END IF;
581:
582: x_return_status := fnd_api.g_ret_sts_success;
583: -- Each time this is called, p_batch_step_rec has already been retrieved from DB... has all
584: -- latest data and in addition has the actual start date calculated and set
585: x_batch_step_rec := p_batch_step_rec;
586: /* Update the Batch Step Status to WIP */

Line 627: x_return_status := fnd_api.g_ret_sts_unexp_error;

623: EXCEPTION
624: WHEN batch_step_upd_err THEN
625: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
626: ,SQLERRM);
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628: WHEN OTHERS THEN
629: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
630:
631: IF g_debug <= gme_debug.g_log_procedure THEN

Line 640: x_return_status := fnd_api.g_ret_sts_unexp_error;

636: || ': '
637: || SQLERRM);
638: END IF;
639:
640: x_return_status := fnd_api.g_ret_sts_unexp_error;
641: END release_step_line;
642:
643: PROCEDURE release_step_ingredients (
644: p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 680: x_return_status := fnd_api.g_ret_sts_success;

676: || p_batch_step_rec.batchstep_id);
677: END IF;
678:
679: /* Set the return status to success initially */
680: x_return_status := fnd_api.g_ret_sts_success;
681:
682: -- retrieve all autobystep ingredients associated to the step...
683: OPEN cur_step_ingredients (p_batch_step_rec.batchstep_id);
684:

Line 715: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

711: ,x_exception_material_tbl => x_exception_material_tbl
712: ,x_return_status => l_return_status);
713:
714: IF l_return_status NOT IN
715: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
716: x_return_status := l_return_status;
717: RAISE error_process_ing;
718: END IF;
719:

Line 745: x_return_status := fnd_api.g_ret_sts_unexp_error;

741: || ': '
742: || SQLERRM);
743: END IF;
744:
745: x_return_status := fnd_api.g_ret_sts_unexp_error;
746: END release_step_ingredients;
747:
748: PROCEDURE validate_step_for_release (p_batch_header_rec IN gme_batch_header%ROWTYPE
749: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 784: x_return_status := fnd_api.g_ret_sts_success;

780: || l_api_name);
781: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);
782: END IF;
783:
784: x_return_status := fnd_api.g_ret_sts_success;
785:
786: -- set output structure
787: x_batch_step_rec := p_batch_step_rec;
788:

Line 840: x_return_status := fnd_api.g_ret_sts_error;

836: ,p_start_date => p_batch_header_rec.actual_start_date
837: ,p_cmplt_date => p_batch_header_rec.actual_cmplt_date
838: ,p_batch_header_rec => p_batch_header_rec
839: ,p_validate_plan_dates_ind => 1) THEN
840: x_return_status := fnd_api.g_ret_sts_error;
841: RAISE error_vr_dates;
842: END IF;
843: -- End Bug 5336007
844: END IF; -- p_batch_header_rec.batch_status = 1

Line 866: IF x_return_status <> fnd_api.g_ret_sts_success THEN

862: ,p_step_id => x_batch_step_rec.batchstep_id
863: ,p_step_actual_start_date => x_batch_step_rec.actual_start_date
864: ,x_return_status => x_return_status);
865:
866: IF x_return_status <> fnd_api.g_ret_sts_success THEN
867: RAISE error_validation;
868: END IF;
869: END IF;
870:

Line 878: IF x_return_status <> fnd_api.g_ret_sts_success THEN

874: ,p_auto_by_step => 1 -- auto by step ingredients
875: ,p_batchstep_id => x_batch_step_rec.batchstep_id -- assoc to this step
876: ,x_return_status => x_return_status);
877:
878: IF x_return_status <> fnd_api.g_ret_sts_success THEN
879: RAISE error_validation;
880: END IF;
881:
882: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 890: x_return_status := FND_API.G_RET_STS_ERROR;

886:
887: EXCEPTION
888: --Bug#5109119
889: WHEN error_close_period THEN
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: -- 7564922 - Add missing exception clause for validity status check.
892: WHEN error_validity_status THEN
893: gme_common_pvt.log_message ('GME_VALIDITY_OBSO_OR_ONHOLD');
894: x_return_status := FND_API.G_RET_STS_ERROR;

Line 894: x_return_status := FND_API.G_RET_STS_ERROR;

890: x_return_status := FND_API.G_RET_STS_ERROR;
891: -- 7564922 - Add missing exception clause for validity status check.
892: WHEN error_validity_status THEN
893: gme_common_pvt.log_message ('GME_VALIDITY_OBSO_OR_ONHOLD');
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: WHEN error_future_date THEN
896: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
897: fnd_msg_pub.ADD;
898: x_return_status := FND_API.G_RET_STS_ERROR;

Line 898: x_return_status := FND_API.G_RET_STS_ERROR;

894: x_return_status := FND_API.G_RET_STS_ERROR;
895: WHEN error_future_date THEN
896: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
897: fnd_msg_pub.ADD;
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: WHEN error_validation THEN
900: NULL;
901: WHEN error_actual_start_date THEN
902: gme_common_pvt.log_message ('GME_STEP_START_BATCH_START_ERR');

Line 903: x_return_status := FND_API.G_RET_STS_ERROR;

899: WHEN error_validation THEN
900: NULL;
901: WHEN error_actual_start_date THEN
902: gme_common_pvt.log_message ('GME_STEP_START_BATCH_START_ERR');
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: WHEN error_vr_dates THEN
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: WHEN OTHERS THEN
907: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 905: x_return_status := FND_API.G_RET_STS_ERROR;

901: WHEN error_actual_start_date THEN
902: gme_common_pvt.log_message ('GME_STEP_START_BATCH_START_ERR');
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: WHEN error_vr_dates THEN
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: WHEN OTHERS THEN
907: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
908:
909: IF g_debug <= gme_debug.g_log_procedure THEN

Line 917: x_return_status := fnd_api.g_ret_sts_unexp_error;

913: || l_api_name
914: || ': '
915: || SQLERRM);
916: END IF;
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918: END validate_step_for_release;
919:
920: END gme_release_batch_step_pvt;