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_COMPLETE_BATCH_PVT dependencies on FND_API

Line 96: x_return_status := FND_API.G_RET_STS_SUCCESS;

92: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' actual_cmplt_date='||to_char(p_batch_header_rec.actual_cmplt_date, 'YYYY-MON-DD HH24:MI:SS'));
93: END IF;
94:
95: /* Set the return status to success initially */
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97:
98: -- set output structure
99: x_batch_header_rec := p_batch_header_rec;
100:

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

105: (p_batch_header_rec => p_batch_header_rec
106: ,x_batch_header_rec => x_batch_header_rec
107: ,x_return_status => l_return_status
108: ,x_exception_material_tbl => x_exception_material_tbl);
109: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
110: x_return_status := l_return_status;
111: RAISE error_release_batch;
112: END IF;
113:

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

180: ,p_update_inv_ind => x_batch_header_rec.update_inventory_ind
181: ,x_exception_material_tbl => x_exception_material_tbl
182: ,x_return_status => l_return_status);
183:
184: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
185: x_return_status := l_return_status;
186: RAISE error_process_material;
187: END IF;
188:

Line 201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

197: (p_org_id => l_matl_dtl_rec.organization_id
198: ,p_item_id => l_matl_dtl_rec.inventory_item_id
199: ,x_item_rec => l_item_rec
200: ,x_return_status => l_return_status);
201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
202: x_return_status := l_return_status;
203: RAISE error_get_item;
204: END IF;
205: IF p_batch_header_rec.update_inventory_ind = 'Y' AND l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN

Line 228: ,p_force_unconsumed => fnd_api.g_false

224: ,p_pending_move_order_ind => NULL -- don't know...allow to calculate
225: ,p_pending_rsrv_ind => NULL -- don't know...allow to calculate
226: ,p_transacted_qty => 0 -- only auto rel products are transacted.. this is for ing
227: ,p_exception_qty => l_exception_qty
228: ,p_force_unconsumed => fnd_api.g_false
229: ,x_exception_material_tbl => x_exception_material_tbl
230: ,x_return_status => l_return_status);
231:
232: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

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

228: ,p_force_unconsumed => fnd_api.g_false
229: ,x_exception_material_tbl => x_exception_material_tbl
230: ,x_return_status => l_return_status);
231:
232: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
233: x_return_status := l_return_status;
234: RAISE error_complete_batch;
235: END IF;
236:

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

259: ,x_batch_step_rec => l_batch_step_rec
260: ,x_exception_material_tbl => x_exception_material_tbl
261: ,x_return_status => l_return_status);
262:
263: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
264: x_return_status := l_return_status;
265: RAISE error_complete_step_rec;
266: END IF;
267:

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

284: ,x_exception_material_tbl => x_exception_material_tbl
285: ,x_batch_header_rec => l_btch_hdr
286: ,x_return_status => l_return_status);
287:
288: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
289: x_return_status := l_return_status;
290: RAISE error_complete_batch;
291: END IF;
292:

Line 313: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

309: (p_org_id => l_matl_dtl_rec.organization_id
310: ,p_item_id => l_matl_dtl_rec.inventory_item_id
311: ,x_item_rec => l_item_rec
312: ,x_return_status => l_return_status);
313: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
314: x_return_status := l_return_status;
315: RAISE error_get_item;
316: END IF;
317: IF p_batch_header_rec.update_inventory_ind = 'Y' AND

Line 339: ,p_force_unconsumed => fnd_api.g_false

335: ,p_pending_move_order_ind => NULL -- don't know...allow to calculate
336: ,p_pending_rsrv_ind => NULL -- don't know...allow to calculate
337: ,p_transacted_qty => 0 -- only auto rel products are transacted.. this is for ing
338: ,p_exception_qty => l_exception_qty
339: ,p_force_unconsumed => fnd_api.g_false
340: ,x_exception_material_tbl => x_exception_material_tbl
341: ,x_return_status => l_return_status);
342:
343: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

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

339: ,p_force_unconsumed => fnd_api.g_false
340: ,x_exception_material_tbl => x_exception_material_tbl
341: ,x_return_status => l_return_status);
342:
343: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
344: x_return_status := l_return_status;
345: RAISE error_complete_batch;
346: END IF;
347:

Line 371: x_return_status := FND_API.g_ret_sts_unexp_error;

367:
368: EXCEPTION
369: WHEN error_update_batch THEN
370: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
371: x_return_status := FND_API.g_ret_sts_unexp_error;
372: --Bug#5296812 Handling the raised exception error_get_item.
373: WHEN error_process_material OR error_complete_batch OR
374: error_complete_step_rec OR error_release_batch OR error_get_item THEN
375: NULL;

Line 382: x_return_status := FND_API.G_RET_STS_ERROR;

378: 'GME_RECORD_LOCKED',
379: 'TABLE_NAME',
380: l_table_name
381: );
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: WHEN OTHERS THEN
384: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
385: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
386: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

Line 388: x_return_status := FND_API.g_ret_sts_unexp_error;

384: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
385: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
386: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
387: END IF;
388: x_return_status := FND_API.g_ret_sts_unexp_error;
389: END complete_batch;
390:
391:
392: PROCEDURE process_material

Line 429: x_return_status := FND_API.G_RET_STS_SUCCESS;

425: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Processing material material_detail_id='||p_material_detail_rec.material_detail_id);
426: END IF;
427:
428: /* Set the return status to success initially */
429: x_return_status := FND_API.G_RET_STS_SUCCESS;
430:
431: -- Process the material
432: -- 1) complete product
433: -- 2) complete phantom batch for phantom ingredient

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

459: ,x_exception_material_tbl => x_exception_material_tbl
460: ,x_batch_header_rec => l_phantom_batch_rec
461: ,x_return_status => l_return_status);
462:
463: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
464: x_return_status := l_return_status;
465: RAISE error_complete_batch;
466: END IF;
467:

Line 479: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

475: ,p_item_id => l_matl_dtl_rec.inventory_item_id
476: ,x_item_rec => l_item_rec
477: ,x_return_status => l_return_status);
478:
479: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
480: x_return_status := l_return_status;
481: RAISE error_get_item;
482: END IF;
483:

Line 491: ,p_force_unconsumed => fnd_api.g_false

487: yield_material(p_material_dtl_rec => l_matl_dtl_rec
488: ,p_yield_qty => NULL -- take the entire wip plan qty
489: ,p_trans_date => p_trans_date
490: ,p_item_rec => l_item_rec
491: ,p_force_unconsumed => fnd_api.g_false
492: ,x_exception_material_tbl => x_exception_material_tbl
493: ,x_actual_qty => l_actual_qty
494: ,x_return_status => l_return_status);
495:

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

492: ,x_exception_material_tbl => x_exception_material_tbl
493: ,x_actual_qty => l_actual_qty
494: ,x_return_status => l_return_status);
495:
496: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
497: x_return_status := l_return_status;
498: RAISE error_yield_material;
499: END IF;
500:

Line 523: ,p_force_unconsumed => fnd_api.g_false

519: ,p_pending_move_order_ind => FALSE -- product doesn't have MO
520: ,p_pending_rsrv_ind => NULL -- let proc figure out; for product, looks at pplot
521: ,p_transacted_qty => l_actual_qty - l_start_actual_qty
522: ,p_exception_qty => 0
523: ,p_force_unconsumed => fnd_api.g_false
524: ,x_exception_material_tbl => x_exception_material_tbl
525: ,x_return_status => l_return_status);
526:
527: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

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

523: ,p_force_unconsumed => fnd_api.g_false
524: ,x_exception_material_tbl => x_exception_material_tbl
525: ,x_return_status => l_return_status);
526:
527: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
528: x_return_status := l_return_status;
529: RAISE error_yield_material;
530: END IF;
531:

Line 547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

543: (p_org_id => l_matl_dtl_rec.organization_id
544: ,p_item_id => l_matl_dtl_rec.inventory_item_id
545: ,x_item_rec => l_item_rec
546: ,x_return_status => l_return_status);
547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
548: x_return_status := l_return_status;
549: RAISE error_get_item;
550: END IF;
551: IF p_update_inv_ind = 'Y' AND l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN

Line 572: ,p_force_unconsumed => fnd_api.g_false

568: ,p_pending_move_order_ind => FALSE -- product doesn't have MO
569: ,p_pending_rsrv_ind => NULL -- let proc figure out; for product, looks at pplot
570: ,p_transacted_qty => 0 -- products other than auto yield don't get transacted in complete
571: ,p_exception_qty => l_exception_qty
572: ,p_force_unconsumed => fnd_api.g_false
573: ,x_exception_material_tbl => x_exception_material_tbl
574: ,x_return_status => l_return_status);
575:
576: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

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

572: ,p_force_unconsumed => fnd_api.g_false
573: ,x_exception_material_tbl => x_exception_material_tbl
574: ,x_return_status => l_return_status);
575:
576: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
577: x_return_status := l_return_status;
578: RAISE error_batch_exception;
579: END IF;
580:

Line 601: x_return_status := FND_API.g_ret_sts_unexp_error;

597:
598: EXCEPTION
599: WHEN error_fetch_batch OR error_update_row THEN
600: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
601: x_return_status := FND_API.g_ret_sts_unexp_error;
602: WHEN error_complete_batch OR error_yield_material OR error_get_item OR error_batch_exception THEN
603: NULL;
604: WHEN OTHERS THEN
605: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 609: x_return_status := FND_API.g_ret_sts_unexp_error;

605: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
606: IF g_debug <= gme_debug.g_log_procedure THEN
607: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
608: END IF;
609: x_return_status := FND_API.g_ret_sts_unexp_error;
610: END process_material;
611:
612:
613: -- Note: p_yield_qty is the target actual qty; for incr, it's also the target, not the incr

Line 666: x_return_status := FND_API.G_RET_STS_SUCCESS;

662: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_force_unconsumed='||p_force_unconsumed);
663: END IF;
664:
665: /* Set the return status to success initially */
666: x_return_status := FND_API.G_RET_STS_SUCCESS;
667:
668: x_actual_qty := p_material_dtl_rec.actual_qty;
669:
670: -- following global is set only for migration purposes, where transactions need not be created,

Line 765: IF l_return_status NOT IN (gme_common_pvt.g_not_transactable, FND_API.G_RET_STS_SUCCESS) THEN

761: ,p_sec_uom_code => p_item_rec.secondary_uom_code
762: ,x_actual_qty => x_actual_qty
763: ,x_return_status => l_return_status);
764:
765: IF l_return_status NOT IN (gme_common_pvt.g_not_transactable, FND_API.G_RET_STS_SUCCESS) THEN
766: x_return_status := l_return_status;
767: RAISE error_build_trxn;
768: END IF;
769: ELSE -- lot control... go to pending product lots

Line 774: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

770: gme_pending_product_lots_pvt.get_pending_lot
771: (p_material_detail_id => p_material_dtl_rec.material_detail_id
772: ,x_return_status => l_return_status
773: ,x_pending_product_lot_tbl => l_pending_product_lot_tab);
774: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
775: x_return_status := l_return_status;
776: RAISE error_get_pplot;
777: END IF;
778:

Line 807: IF l_return_status NOT IN (gme_common_pvt.g_not_transactable, FND_API.G_RET_STS_SUCCESS) THEN

803: ,p_revision => l_revision
804: ,p_sec_uom_code => p_item_rec.secondary_uom_code
805: ,x_actual_qty => x_actual_qty
806: ,x_return_status => l_return_status);
807: IF l_return_status NOT IN (gme_common_pvt.g_not_transactable, FND_API.G_RET_STS_SUCCESS) THEN
808: x_return_status := l_return_status;
809: RAISE error_build_trxn;
810: END IF;
811:

Line 857: x_return_status := FND_API.g_ret_sts_unexp_error;

853: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
854: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
855: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
856: END IF;
857: x_return_status := FND_API.g_ret_sts_unexp_error;
858: END yield_material;
859:
860: PROCEDURE build_and_create_transaction
861: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

Line 897: x_return_status := FND_API.G_RET_STS_SUCCESS;

893: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
894: END IF;
895:
896: /* Set the return status to success initially */
897: x_return_status := FND_API.G_RET_STS_SUCCESS;
898:
899: constr_mmti(p_mtl_dtl_rec => p_mtl_dtl_rec
900: ,p_yield_qty => p_yield_qty
901: ,p_subinv => p_subinv

Line 911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

907: ,x_sec_qty => l_sec_qty
908: ,x_dtl_qty => l_dtl_qty
909: ,x_return_status => x_return_status);
910:
911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
912: RAISE error_build_mmti;
913: END IF;
914:
915: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

981: (p_mmti_rec => l_transaction_rec
982: ,p_mmli_tbl => l_lot_tbl
983: ,x_return_status => x_return_status);
984:
985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
986: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
987: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_transactions_pvt.create_transaction returned error');
988: END IF;
989: RAISE error_create_trxn;

Line 1002: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

998: ,p_quantity => l_trxn_qty
999: ,p_secondary_quantity => l_sec_qty
1000: ,x_return_status => x_return_status);
1001:
1002: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1003: RAISE error_relieve_pp_lot;
1004: END IF;
1005: END IF;
1006:

Line 1020: x_return_status := FND_API.g_ret_sts_unexp_error;

1016: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1017: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
1018: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1019: END IF;
1020: x_return_status := FND_API.g_ret_sts_unexp_error;
1021: END build_and_create_transaction;
1022:
1023: PROCEDURE constr_mmti
1024: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

Line 1044: x_return_status := FND_API.g_ret_sts_success;

1040: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1041: END IF;
1042:
1043: /* Initially let us assign the return status to success */
1044: x_return_status := FND_API.g_ret_sts_success;
1045:
1046: -- consturct mtl_transactions_interface
1047: x_mmti_rec.transaction_source_id := p_mtl_dtl_rec.batch_id; -- batch_id
1048: x_mmti_rec.trx_source_line_id := p_mtl_dtl_rec.material_detail_id; -- material_detail_id

Line 1079: x_return_status := FND_API.g_ret_sts_unexp_error;

1075: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1076: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
1077: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1078: END IF;
1079: x_return_status := FND_API.g_ret_sts_unexp_error;
1080: END constr_mmti;
1081:
1082: PROCEDURE validate_batch_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
1083: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 1127: x_return_status := FND_API.g_ret_sts_success;

1123: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1124: || l_api_name);
1125: END IF;
1126:
1127: x_return_status := FND_API.g_ret_sts_success;
1128:
1129: -- set output structure
1130: x_batch_header_rec := p_batch_header_rec;
1131:

Line 1190: x_return_status := fnd_api.g_ret_sts_error;

1186: ,p_start_date => p_batch_header_rec.actual_start_date
1187: ,p_cmplt_date => p_batch_header_rec.actual_cmplt_date
1188: ,p_batch_header_rec => p_batch_header_rec
1189: ,p_validate_plan_dates_ind => 1) THEN
1190: x_return_status := fnd_api.g_ret_sts_error;
1191: RAISE error_vr_dates;
1192: END IF;
1193: -- End Bug 5336007
1194: END IF; -- IF p_batch_header_rec.recipe_validity_rule_id IS NOT NULL

Line 1211: x_return_status := FND_API.G_RET_STS_ERROR;

1207:
1208: EXCEPTION
1209: WHEN error_phantom THEN
1210: gme_common_pvt.log_message ('PM_INVALID_PHANTOM_ACTION');
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: WHEN error_batch_type OR error_batch_status THEN
1213: gme_common_pvt.log_message('GME_API_INVALID_BATCH_COMPL');
1214: x_return_status := fnd_api.g_ret_sts_error;
1215: WHEN error_steps_not_complete THEN

Line 1214: x_return_status := fnd_api.g_ret_sts_error;

1210: gme_common_pvt.log_message ('PM_INVALID_PHANTOM_ACTION');
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: WHEN error_batch_type OR error_batch_status THEN
1213: gme_common_pvt.log_message('GME_API_INVALID_BATCH_COMPL');
1214: x_return_status := fnd_api.g_ret_sts_error;
1215: WHEN error_steps_not_complete THEN
1216: gme_common_pvt.log_message('GME_STEPS_NOT_COMPLETE');
1217: x_return_status := fnd_api.g_ret_sts_error;
1218: WHEN error_cmplt_date THEN

Line 1217: x_return_status := fnd_api.g_ret_sts_error;

1213: gme_common_pvt.log_message('GME_API_INVALID_BATCH_COMPL');
1214: x_return_status := fnd_api.g_ret_sts_error;
1215: WHEN error_steps_not_complete THEN
1216: gme_common_pvt.log_message('GME_STEPS_NOT_COMPLETE');
1217: x_return_status := fnd_api.g_ret_sts_error;
1218: WHEN error_cmplt_date THEN
1219: gme_common_pvt.log_message('GME_INVALID_DATE_RANGE'
1220: ,'DATE1','Completion date'
1221: ,'DATE2','Start date');

Line 1222: x_return_status := fnd_api.g_ret_sts_error;

1218: WHEN error_cmplt_date THEN
1219: gme_common_pvt.log_message('GME_INVALID_DATE_RANGE'
1220: ,'DATE1','Completion date'
1221: ,'DATE2','Start date');
1222: x_return_status := fnd_api.g_ret_sts_error;
1223: WHEN error_future_date THEN
1224: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1225: fnd_msg_pub.ADD;
1226: x_return_status := fnd_api.g_ret_sts_error;

Line 1226: x_return_status := fnd_api.g_ret_sts_error;

1222: x_return_status := fnd_api.g_ret_sts_error;
1223: WHEN error_future_date THEN
1224: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1225: fnd_msg_pub.ADD;
1226: x_return_status := fnd_api.g_ret_sts_error;
1227: WHEN error_vr_dates THEN
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: WHEN OTHERS THEN
1230: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1228: x_return_status := FND_API.G_RET_STS_ERROR;

1224: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1225: fnd_msg_pub.ADD;
1226: x_return_status := fnd_api.g_ret_sts_error;
1227: WHEN error_vr_dates THEN
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: WHEN OTHERS THEN
1230: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1231:
1232: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1241: x_return_status := fnd_api.g_ret_sts_unexp_error;

1237: || ': '
1238: || SQLERRM);
1239: END IF;
1240:
1241: x_return_status := fnd_api.g_ret_sts_unexp_error;
1242: END validate_batch_for_complete;
1243:
1244: END gme_complete_batch_pvt;