DBA Data[Home] [Help]

APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on FND_API

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
54: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step batchstep_id='||p_batch_step_rec.batchstep_id);
55: END IF;
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: l_batch_step_rec := p_batch_step_rec;
60: l_batch_header_rec := p_batch_header_rec;
61:

Line 74: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

70: ,x_batch_step_rec => l_batch_step_rec
71: ,x_exception_material_tbl => x_exception_material_tbl
72: ,x_return_status => l_return_status);
73:
74: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
75: x_return_status := l_return_status;
76: RAISE error_release_batch;
77: END IF;
78:

Line 99: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

95: ,x_batch_step_rec => x_batch_step_rec
96: ,x_exception_material_tbl => x_exception_material_tbl
97: ,x_return_status => l_return_status);
98:
99: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
100: x_return_status := l_return_status;
101: RAISE error_complete_step_rec;
102: END IF;
103:

Line 140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

136: (p_batch_header_rec => l_in_batch_header_rec
137: ,x_batch_header_rec => l_batch_header_rec
138: ,x_return_status => x_return_status);
139:
140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
141: RAISE error_validation;
142: END IF;
143:
144: l_in_batch_header_rec := l_batch_header_rec;

Line 151: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

147: ,x_exception_material_tbl => x_exception_material_tbl
148: ,x_batch_header_rec => l_batch_header_rec
149: ,x_return_status => l_return_status);
150:
151: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
152: x_return_status := l_return_status;
153: RAISE error_complete_batch;
154: END IF;
155:

Line 173: x_return_status := fnd_api.g_ret_sts_unexp_error;

169: NULL;
170: WHEN error_fetch THEN
171: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
172: ,SQLERRM);
173: x_return_status := fnd_api.g_ret_sts_unexp_error;
174: WHEN OTHERS THEN
175: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
176: IF g_debug <= gme_debug.g_log_procedure THEN
177: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

Line 179: x_return_status := FND_API.g_ret_sts_unexp_error;

175: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
176: IF g_debug <= gme_debug.g_log_procedure THEN
177: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
178: END IF;
179: x_return_status := FND_API.g_ret_sts_unexp_error;
180: END complete_step;
181:
182: PROCEDURE complete_step_recursive
183: (p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 214: x_return_status := FND_API.G_RET_STS_SUCCESS;

210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' complete step recursive batch_step_id='||p_batch_step_rec.batchstep_id);
211: END IF;
212:
213: /* Set the return status to success initially */
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: x_batch_step_rec := p_batch_step_rec;
217:
218: /* Exit the recursive loop if the step is already released, completed or closed */

Line 230: P_INIT_MSG_LIST => FND_API.G_FALSE,

226: -- Pawan Kumar added for bug 5034336
227: -- check for batch step lock status from gmo
228: gmo_vbatch_grp.GET_ENTITY_LOCK_STATUS (
229: P_API_VERSION => 1.0,
230: P_INIT_MSG_LIST => FND_API.G_FALSE,
231: P_COMMIT => FND_API.G_FALSE,
232: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
233: X_RETURN_STATUS => x_return_status ,
234: X_MSG_COUNT => l_msg_count,

Line 231: P_COMMIT => FND_API.G_FALSE,

227: -- check for batch step lock status from gmo
228: gmo_vbatch_grp.GET_ENTITY_LOCK_STATUS (
229: P_API_VERSION => 1.0,
230: P_INIT_MSG_LIST => FND_API.G_FALSE,
231: P_COMMIT => FND_API.G_FALSE,
232: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
233: X_RETURN_STATUS => x_return_status ,
234: X_MSG_COUNT => l_msg_count,
235: X_MSG_DATA => l_msg_stack,

Line 232: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

228: gmo_vbatch_grp.GET_ENTITY_LOCK_STATUS (
229: P_API_VERSION => 1.0,
230: P_INIT_MSG_LIST => FND_API.G_FALSE,
231: P_COMMIT => FND_API.G_FALSE,
232: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
233: X_RETURN_STATUS => x_return_status ,
234: X_MSG_COUNT => l_msg_count,
235: X_MSG_DATA => l_msg_stack,
236: P_ENTITY_NAME => 'OPERATION',

Line 248: IF x_return_status <> fnd_api.g_ret_sts_success THEN

244: || l_api_name
245: || ':'
246: || 'from gmo the lock_status='
247: || l_lock_status);
248: IF x_return_status <> fnd_api.g_ret_sts_success THEN
249: RAISE gmo_lock_error;
250: END IF;
251: IF (g_debug <= gme_debug.g_log_procedure) THEN
252: gme_debug.put_line ( g_pkg_name

Line 273: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

269: ,p_batch_header_rec => p_batch_header_rec
270: ,x_exception_material_tbl => x_exception_material_tbl
271: ,x_return_status => l_return_status);
272:
273: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
274: x_return_status := l_return_status;
275: RAISE error_process_dep_steps;
276: END IF;
277:

Line 299: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

295: ,x_batch_step_rec => x_batch_step_rec
296: ,x_exception_material_tbl => x_exception_material_tbl
297: ,x_return_status => l_return_status);
298:
299: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
300: x_return_status := l_return_status;
301: RAISE cmpl_step_line_error;
302: END IF;
303:

Line 310: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

306: ,p_update_inv_ind => p_batch_header_rec.update_inventory_ind
307: ,x_exception_material_tbl => x_exception_material_tbl
308: ,x_return_status => l_return_status);
309:
310: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
311: x_return_status := l_return_status;
312: RAISE cmpl_step_prod_error;
313: END IF;
314:

Line 329: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

325: ,x_message_list => l_msg_stack
326: ,x_return_status => l_return_status
327: ,x_batch_step_rec => x_batch_step_rec);
328:
329: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
330: RAISE update_step_qty_error;
331: END IF;
332:
333: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

Line 351: x_return_status := fnd_api.g_ret_sts_error;

347: || ':'
348: || 'GMO_LOCK_ERROR.');
349:
350: END IF;
351: x_return_status := fnd_api.g_ret_sts_error;
352: WHEN error_quality_status THEN --Bug#6348353
353: gme_common_pvt.log_message('GME_QUALITY_NOT_COMPLETE'
354: ,'STEP_NO', x_batch_step_rec.batchstep_no
355: ,'BATCH_NO', p_batch_header_rec.batch_no);

Line 356: x_return_status := fnd_api.g_ret_sts_error;

352: WHEN error_quality_status THEN --Bug#6348353
353: gme_common_pvt.log_message('GME_QUALITY_NOT_COMPLETE'
354: ,'STEP_NO', x_batch_step_rec.batchstep_no
355: ,'BATCH_NO', p_batch_header_rec.batch_no);
356: x_return_status := fnd_api.g_ret_sts_error;
357: WHEN OTHERS THEN
358: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
359: IF g_debug <= gme_debug.g_log_procedure THEN
360: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

Line 362: x_return_status := FND_API.g_ret_sts_unexp_error;

358: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
359: IF g_debug <= gme_debug.g_log_procedure THEN
360: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
361: END IF;
362: x_return_status := FND_API.g_ret_sts_unexp_error;
363: END complete_step_recursive;
364:
365: /*===========================================================================================
366: Procedure

Line 397: x_return_status := FND_API.G_RET_STS_SUCCESS;

393: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
394: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step line batchstep_id='||p_batch_step_rec.batchstep_id);
395: END IF;
396:
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399: -- Each time this is called, p_batch_step_rec has already been retrieved from DB... has all
400: -- latest data and in addition has the actual completion date calculated and set
401: x_batch_step_rec := p_batch_step_rec;

Line 454: x_return_status := FND_API.g_ret_sts_unexp_error;

450:
451: EXCEPTION
452: WHEN batch_step_upd_err THEN
453: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
454: x_return_status := FND_API.g_ret_sts_unexp_error;
455: WHEN OTHERS THEN
456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
457: IF g_debug <= gme_debug.g_log_procedure THEN
458: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

Line 460: x_return_status := FND_API.g_ret_sts_unexp_error;

456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
457: IF g_debug <= gme_debug.g_log_procedure THEN
458: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
459: END IF;
460: x_return_status := FND_API.g_ret_sts_unexp_error;
461: END complete_step_line;
462:
463: PROCEDURE complete_step_material
464: (p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 495: x_return_status := FND_API.G_RET_STS_SUCCESS;

491: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Completing products/byproducts for step_id='||p_batch_step_rec.batchstep_id);
492: END IF;
493:
494: /* Set the return status to success initially */
495: x_return_status := FND_API.G_RET_STS_SUCCESS;
496:
497: -- retrieve all autobystep products and phantom ingredients associated to the step...
498: OPEN Cur_step_prod_byprod(p_batch_step_rec.batchstep_id);
499: FETCH Cur_step_prod_byprod BULK COLLECT INTO l_matl_dtl_tab;

Line 514: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

510: ,p_update_inv_ind => p_update_inv_ind
511: ,x_exception_material_tbl => x_exception_material_tbl
512: ,x_return_status => l_return_status);
513:
514: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
515: x_return_status := l_return_status;
516: RAISE error_process_prod;
517: END IF;
518:

Line 536: x_return_status := FND_API.g_ret_sts_unexp_error;

532: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
533: IF g_debug <= gme_debug.g_log_procedure THEN
534: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
535: END IF;
536: x_return_status := FND_API.g_ret_sts_unexp_error;
537: END complete_step_material;
538:
539: PROCEDURE validate_dependent_steps (p_batch_id IN NUMBER
540: ,p_step_id IN NUMBER

Line 568: x_return_status := FND_API.g_ret_sts_success;

564: || l_api_name);
565: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_step_id);
566: END IF;
567:
568: x_return_status := FND_API.g_ret_sts_success;
569:
570: FOR l_dep_step_rec IN Cur_get_dep_steps(p_batch_id, p_step_id) LOOP
571: /*
572: If the dependency is Finish To Start then the prior step should be

Line 605: x_return_status := FND_API.G_RET_STS_ERROR;

601:
602: EXCEPTION
603: WHEN INVALID_START_DATE THEN
604: gme_common_pvt.log_message('GME_INVALID_START_DATE');
605: x_return_status := FND_API.G_RET_STS_ERROR;
606: WHEN GME_STEP_DEP_WIP THEN
607: gme_common_pvt.log_message('GME_STEP_DEP_WIP');
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: WHEN GME_STEP_DEP_COMPLETE THEN

Line 608: x_return_status := FND_API.G_RET_STS_ERROR;

604: gme_common_pvt.log_message('GME_INVALID_START_DATE');
605: x_return_status := FND_API.G_RET_STS_ERROR;
606: WHEN GME_STEP_DEP_WIP THEN
607: gme_common_pvt.log_message('GME_STEP_DEP_WIP');
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: WHEN GME_STEP_DEP_COMPLETE THEN
610: gme_common_pvt.log_message('GME_STEP_DEP_COMPLETE');
611: x_return_status := FND_API.G_RET_STS_ERROR ;
612: WHEN OTHERS THEN

Line 611: x_return_status := FND_API.G_RET_STS_ERROR ;

607: gme_common_pvt.log_message('GME_STEP_DEP_WIP');
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: WHEN GME_STEP_DEP_COMPLETE THEN
610: gme_common_pvt.log_message('GME_STEP_DEP_COMPLETE');
611: x_return_status := FND_API.G_RET_STS_ERROR ;
612: WHEN OTHERS THEN
613: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

Line 617: x_return_status := FND_API.g_ret_sts_unexp_error;

613: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
616: END IF;
617: x_return_status := FND_API.g_ret_sts_unexp_error;
618: END validate_dependent_steps;
619:
620: PROCEDURE validate_step_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
621: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 659: x_return_status := fnd_api.g_ret_sts_success;

655: || l_api_name);
656: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);
657: END IF;
658:
659: x_return_status := fnd_api.g_ret_sts_success;
660:
661: -- set output structure
662: x_batch_step_rec := p_batch_step_rec;
663:

Line 697: x_return_status := fnd_api.g_ret_sts_error;

693: ,p_start_date => p_batch_header_rec.actual_start_date
694: ,p_cmplt_date => p_batch_header_rec.actual_cmplt_date
695: ,p_batch_header_rec => p_batch_header_rec
696: ,p_validate_plan_dates_ind => 1) THEN
697: x_return_status := fnd_api.g_ret_sts_error;
698: RAISE error_vr_dates;
699: END IF;
700: -- End Bug 5336007
701: END IF; -- IF p_batch_header_rec.recipe_validity_rule_id IS NOT NULL

Line 747: IF x_return_status <> fnd_api.g_ret_sts_success THEN

743: ,p_step_id => x_batch_step_rec.batchstep_id
744: ,p_step_actual_start_date => x_batch_step_rec.actual_start_date
745: ,x_return_status => x_return_status);
746:
747: IF x_return_status <> fnd_api.g_ret_sts_success THEN
748: RAISE error_validation;
749: END IF;
750: END IF;
751:

Line 754: p_override_quality = fnd_api.g_false) THEN

750: END IF;
751:
752: -- if quality is not complete cannot complete step
753: IF (x_batch_step_rec.quality_status NOT IN (1,4,6) AND
754: p_override_quality = fnd_api.g_false) THEN
755: RAISE error_quality_status;
756: END IF;
757:
758: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 766: x_return_status := FND_API.G_RET_STS_ERROR;

762:
763: EXCEPTION
764: --Bug#5109119 Begin
765: WHEN error_close_period THEN
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: WHEN error_validation THEN
768: NULL;
769: WHEN error_no_direct_compl THEN
770: gme_common_pvt.log_message('NO_DIRECT_CERT_ALLOWED');

Line 771: x_return_status := FND_API.G_RET_STS_ERROR ;

767: WHEN error_validation THEN
768: NULL;
769: WHEN error_no_direct_compl THEN
770: gme_common_pvt.log_message('NO_DIRECT_CERT_ALLOWED');
771: x_return_status := FND_API.G_RET_STS_ERROR ;
772: WHEN error_future_date THEN
773: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
774: fnd_msg_pub.ADD;
775: x_return_status := FND_API.G_RET_STS_ERROR;

Line 775: x_return_status := FND_API.G_RET_STS_ERROR;

771: x_return_status := FND_API.G_RET_STS_ERROR ;
772: WHEN error_future_date THEN
773: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
774: fnd_msg_pub.ADD;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN error_cmplt_date THEN
777: gme_common_pvt.log_message('GME_INVALID_DATE_RANGE'
778: ,'DATE1','Completion date'
779: ,'DATE2','Start date');

Line 780: x_return_status := fnd_api.g_ret_sts_error;

776: WHEN error_cmplt_date THEN
777: gme_common_pvt.log_message('GME_INVALID_DATE_RANGE'
778: ,'DATE1','Completion date'
779: ,'DATE2','Start date');
780: x_return_status := fnd_api.g_ret_sts_error;
781: WHEN error_quality_status THEN
782: gme_common_pvt.log_message('GME_QUALITY_NOT_COMPLETE'
783: ,'STEP_NO', x_batch_step_rec.batchstep_no
784: ,'BATCH_NO', p_batch_header_rec.batch_no);

Line 785: x_return_status := fnd_api.g_ret_sts_error;

781: WHEN error_quality_status THEN
782: gme_common_pvt.log_message('GME_QUALITY_NOT_COMPLETE'
783: ,'STEP_NO', x_batch_step_rec.batchstep_no
784: ,'BATCH_NO', p_batch_header_rec.batch_no);
785: x_return_status := fnd_api.g_ret_sts_error;
786: WHEN error_vr_dates THEN
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: WHEN OTHERS THEN
789: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 787: x_return_status := FND_API.G_RET_STS_ERROR;

783: ,'STEP_NO', x_batch_step_rec.batchstep_no
784: ,'BATCH_NO', p_batch_header_rec.batch_no);
785: x_return_status := fnd_api.g_ret_sts_error;
786: WHEN error_vr_dates THEN
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: WHEN OTHERS THEN
789: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
790:
791: IF g_debug <= gme_debug.g_log_procedure THEN

Line 799: x_return_status := fnd_api.g_ret_sts_unexp_error;

795: || l_api_name
796: || ': '
797: || SQLERRM);
798: END IF;
799: x_return_status := fnd_api.g_ret_sts_unexp_error;
800: END validate_step_for_complete;
801:
802: /*===========================================================================================
803: Procedure

Line 851: x_return_status := FND_API.G_RET_STS_SUCCESS;

847: || l_api_name);
848: END IF;
849:
850: -- Set the return status to success initially *
851: x_return_status := FND_API.G_RET_STS_SUCCESS;
852:
853: -- Check the date of the step being certified with the batch actual start date
854: IF (p_batch_header_rec.actual_start_date IS NOT NULL) THEN
855: IF (p_batch_step_rec.actual_start_date < p_batch_header_rec.actual_start_date) THEN

Line 941: x_return_status := fnd_api.g_ret_sts_unexp_error;

937: EXCEPTION
938: WHEN BATCH_STEP_FETCH_ERROR THEN
939: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
940: ,SQLERRM);
941: x_return_status := fnd_api.g_ret_sts_unexp_error;
942: WHEN INVALID_DATE_ERR THEN
943: x_return_status := FND_API.G_RET_STS_ERROR;
944: WHEN OTHERS THEN
945: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 943: x_return_status := FND_API.G_RET_STS_ERROR;

939: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
940: ,SQLERRM);
941: x_return_status := fnd_api.g_ret_sts_unexp_error;
942: WHEN INVALID_DATE_ERR THEN
943: x_return_status := FND_API.G_RET_STS_ERROR;
944: WHEN OTHERS THEN
945: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
946:
947: IF g_debug <= gme_debug.g_log_procedure THEN

Line 955: x_return_status := fnd_api.g_ret_sts_unexp_error;

951: || l_api_name
952: || ': '
953: || SQLERRM);
954: END IF;
955: x_return_status := fnd_api.g_ret_sts_unexp_error;
956: END validate_step_cmplt_date;
957:
958: END gme_complete_batch_step_pvt;