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 267: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

263: ,x_batch_step_rec => l_batch_step_rec
264: ,x_exception_material_tbl => x_exception_material_tbl
265: ,x_return_status => l_return_status);
266:
267: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
268: x_return_status := l_return_status;
269: RAISE error_complete_step_rec;
270: END IF;
271:

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

288: ,x_exception_material_tbl => x_exception_material_tbl
289: ,x_batch_header_rec => l_btch_hdr
290: ,x_return_status => l_return_status);
291:
292: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
293: x_return_status := l_return_status;
294: RAISE error_complete_batch;
295: END IF;
296:

Line 317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 343: ,p_force_unconsumed => fnd_api.g_false

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

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

343: ,p_force_unconsumed => fnd_api.g_false
344: ,x_exception_material_tbl => x_exception_material_tbl
345: ,x_return_status => l_return_status);
346:
347: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
348: x_return_status := l_return_status;
349: RAISE error_complete_batch;
350: END IF;
351:

Line 377: x_return_status := FND_API.g_ret_sts_unexp_error;

373:
374: EXCEPTION
375: WHEN error_update_batch THEN
376: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
377: x_return_status := FND_API.g_ret_sts_unexp_error;
378: --Bug#5296812 Handling the raised exception error_get_item.
379: WHEN error_process_material OR error_complete_batch OR
380: error_complete_step_rec OR error_release_batch OR error_get_item THEN
381: NULL;

Line 388: x_return_status := FND_API.G_RET_STS_ERROR;

384: 'GME_RECORD_LOCKED',
385: 'TABLE_NAME',
386: l_table_name
387: );
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: WHEN OTHERS THEN
390: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
391: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
392: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

Line 394: x_return_status := FND_API.g_ret_sts_unexp_error;

390: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
391: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
392: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
393: END IF;
394: x_return_status := FND_API.g_ret_sts_unexp_error;
395: END complete_batch;
396:
397:
398: PROCEDURE process_material

Line 435: x_return_status := FND_API.G_RET_STS_SUCCESS;

431: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Processing material material_detail_id='||p_material_detail_rec.material_detail_id);
432: END IF;
433:
434: /* Set the return status to success initially */
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
436:
437: -- Process the material
438: -- 1) complete product
439: -- 2) complete phantom batch for phantom ingredient

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

465: ,x_exception_material_tbl => x_exception_material_tbl
466: ,x_batch_header_rec => l_phantom_batch_rec
467: ,x_return_status => l_return_status);
468:
469: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
470: x_return_status := l_return_status;
471: RAISE error_complete_batch;
472: END IF;
473:

Line 485: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

481: ,p_item_id => l_matl_dtl_rec.inventory_item_id
482: ,x_item_rec => l_item_rec
483: ,x_return_status => l_return_status);
484:
485: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
486: x_return_status := l_return_status;
487: RAISE error_get_item;
488: END IF;
489:

Line 497: ,p_force_unconsumed => fnd_api.g_false

493: yield_material(p_material_dtl_rec => l_matl_dtl_rec
494: ,p_yield_qty => NULL -- take the entire wip plan qty
495: ,p_trans_date => p_trans_date
496: ,p_item_rec => l_item_rec
497: ,p_force_unconsumed => fnd_api.g_false
498: ,x_exception_material_tbl => x_exception_material_tbl
499: ,x_actual_qty => l_actual_qty
500: ,x_return_status => l_return_status);
501:

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

498: ,x_exception_material_tbl => x_exception_material_tbl
499: ,x_actual_qty => l_actual_qty
500: ,x_return_status => l_return_status);
501:
502: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
503: x_return_status := l_return_status;
504: RAISE error_yield_material;
505: END IF;
506:

Line 529: ,p_force_unconsumed => fnd_api.g_false

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

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

529: ,p_force_unconsumed => fnd_api.g_false
530: ,x_exception_material_tbl => x_exception_material_tbl
531: ,x_return_status => l_return_status);
532:
533: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
534: x_return_status := l_return_status;
535: RAISE error_yield_material;
536: END IF;
537:

Line 553: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

549: (p_org_id => l_matl_dtl_rec.organization_id
550: ,p_item_id => l_matl_dtl_rec.inventory_item_id
551: ,x_item_rec => l_item_rec
552: ,x_return_status => l_return_status);
553: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
554: x_return_status := l_return_status;
555: RAISE error_get_item;
556: END IF;
557: IF p_update_inv_ind = 'Y' AND l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN

Line 578: ,p_force_unconsumed => fnd_api.g_false

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

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

578: ,p_force_unconsumed => fnd_api.g_false
579: ,x_exception_material_tbl => x_exception_material_tbl
580: ,x_return_status => l_return_status);
581:
582: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
583: x_return_status := l_return_status;
584: RAISE error_batch_exception;
585: END IF;
586:

Line 608: x_return_status := FND_API.g_ret_sts_unexp_error;

604:
605: EXCEPTION
606: WHEN error_fetch_batch OR error_update_row THEN
607: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
608: x_return_status := FND_API.g_ret_sts_unexp_error;
609: WHEN error_complete_batch OR error_yield_material OR error_get_item OR error_batch_exception THEN
610: NULL;
611: WHEN OTHERS THEN
612: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 616: x_return_status := FND_API.g_ret_sts_unexp_error;

612: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
613: IF g_debug <= gme_debug.g_log_procedure THEN
614: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
615: END IF;
616: x_return_status := FND_API.g_ret_sts_unexp_error;
617: END process_material;
618:
619:
620: -- Note: p_yield_qty is the target actual qty; for incr, it's also the target, not the incr

Line 673: x_return_status := FND_API.G_RET_STS_SUCCESS;

669: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_force_unconsumed='||p_force_unconsumed);
670: END IF;
671:
672: /* Set the return status to success initially */
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: x_actual_qty := p_material_dtl_rec.actual_qty;
676:
677: -- following global is set only for migration purposes, where transactions need not be created,

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

768: ,p_sec_uom_code => p_item_rec.secondary_uom_code
769: ,x_actual_qty => x_actual_qty
770: ,x_return_status => l_return_status);
771:
772: IF l_return_status NOT IN (gme_common_pvt.g_not_transactable, FND_API.G_RET_STS_SUCCESS) THEN
773: x_return_status := l_return_status;
774: RAISE error_build_trxn;
775: END IF;
776: ELSE -- lot control... go to pending product lots

Line 781: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

777: gme_pending_product_lots_pvt.get_pending_lot
778: (p_material_detail_id => p_material_dtl_rec.material_detail_id
779: ,x_return_status => l_return_status
780: ,x_pending_product_lot_tbl => l_pending_product_lot_tab);
781: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
782: x_return_status := l_return_status;
783: RAISE error_get_pplot;
784: END IF;
785:

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

810: ,p_revision => l_revision
811: ,p_sec_uom_code => p_item_rec.secondary_uom_code
812: ,x_actual_qty => x_actual_qty
813: ,x_return_status => l_return_status);
814: IF l_return_status NOT IN (gme_common_pvt.g_not_transactable, FND_API.G_RET_STS_SUCCESS) THEN
815: x_return_status := l_return_status;
816: RAISE error_build_trxn;
817: END IF;
818:

Line 864: x_return_status := FND_API.g_ret_sts_unexp_error;

860: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
861: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
862: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
863: END IF;
864: x_return_status := FND_API.g_ret_sts_unexp_error;
865: END yield_material;
866:
867: PROCEDURE build_and_create_transaction
868: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

Line 920: x_return_status := FND_API.G_RET_STS_SUCCESS;

916: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
917: END IF;
918:
919: /* Set the return status to success initially */
920: x_return_status := FND_API.G_RET_STS_SUCCESS;
921:
922: constr_mmti(p_mtl_dtl_rec => p_mtl_dtl_rec
923: ,p_yield_qty => p_yield_qty
924: ,p_subinv => p_subinv

Line 934: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

930: ,x_sec_qty => l_sec_qty
931: ,x_dtl_qty => l_dtl_qty
932: ,x_return_status => x_return_status);
933:
934: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
935: RAISE error_build_mmti;
936: END IF;
937:
938: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1049: (p_mmti_rec => l_transaction_rec
1050: ,p_mmli_tbl => l_lot_tbl
1051: ,x_return_status => x_return_status);
1052:
1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1054: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1055: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_transactions_pvt.create_transaction returned error');
1056: END IF;
1057: RAISE error_create_trxn;

Line 1070: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1066: ,p_quantity => l_trxn_qty
1067: ,p_secondary_quantity => l_sec_qty
1068: ,x_return_status => x_return_status);
1069:
1070: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1071: RAISE error_relieve_pp_lot;
1072: END IF;
1073: END IF;
1074:

Line 1088: x_return_status := FND_API.g_ret_sts_error;

1084: fnd_message.set_token ('ITEM_NO', l_item_no);
1085: fnd_message.set_token ('FROM_UOM',l_from_um);
1086: fnd_message.set_token ('TO_UOM', l_to_um);
1087: fnd_msg_pub.ADD;
1088: x_return_status := FND_API.g_ret_sts_error;
1089: WHEN error_create_trxn OR error_relieve_pp_lot OR error_build_mmti THEN
1090: NULL;
1091: WHEN OTHERS THEN
1092: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1096: x_return_status := FND_API.g_ret_sts_unexp_error;

1092: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1093: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
1094: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1095: END IF;
1096: x_return_status := FND_API.g_ret_sts_unexp_error;
1097: END build_and_create_transaction;
1098:
1099: PROCEDURE constr_mmti
1100: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

Line 1120: x_return_status := FND_API.g_ret_sts_success;

1116: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1117: END IF;
1118:
1119: /* Initially let us assign the return status to success */
1120: x_return_status := FND_API.g_ret_sts_success;
1121:
1122: -- consturct mtl_transactions_interface
1123: x_mmti_rec.transaction_source_id := p_mtl_dtl_rec.batch_id; -- batch_id
1124: x_mmti_rec.trx_source_line_id := p_mtl_dtl_rec.material_detail_id; -- material_detail_id

Line 1155: x_return_status := FND_API.g_ret_sts_unexp_error;

1151: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1152: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
1153: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1154: END IF;
1155: x_return_status := FND_API.g_ret_sts_unexp_error;
1156: END constr_mmti;
1157:
1158: PROCEDURE validate_batch_for_complete (p_batch_header_rec IN gme_batch_header%ROWTYPE
1159: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 1203: x_return_status := FND_API.g_ret_sts_success;

1199: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1200: || l_api_name);
1201: END IF;
1202:
1203: x_return_status := FND_API.g_ret_sts_success;
1204:
1205: -- set output structure
1206: x_batch_header_rec := p_batch_header_rec;
1207:

Line 1274: x_return_status := fnd_api.g_ret_sts_error;

1270: ,p_start_date => p_batch_header_rec.actual_start_date
1271: ,p_cmplt_date => p_batch_header_rec.actual_cmplt_date
1272: ,p_batch_header_rec => p_batch_header_rec
1273: ,p_validate_plan_dates_ind => 1) THEN
1274: x_return_status := fnd_api.g_ret_sts_error;
1275: RAISE error_vr_dates;
1276: END IF;
1277: -- End Bug 5336007
1278: END IF; -- p_batch_header_rec.batch_status = 1

Line 1296: x_return_status := FND_API.G_RET_STS_ERROR;

1292:
1293: EXCEPTION
1294: WHEN error_phantom THEN
1295: gme_common_pvt.log_message ('PM_INVALID_PHANTOM_ACTION');
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: WHEN error_batch_type OR error_batch_status THEN
1298: gme_common_pvt.log_message('GME_API_INVALID_BATCH_COMPL');
1299: x_return_status := fnd_api.g_ret_sts_error;
1300: WHEN error_steps_not_complete THEN

Line 1299: x_return_status := fnd_api.g_ret_sts_error;

1295: gme_common_pvt.log_message ('PM_INVALID_PHANTOM_ACTION');
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: WHEN error_batch_type OR error_batch_status THEN
1298: gme_common_pvt.log_message('GME_API_INVALID_BATCH_COMPL');
1299: x_return_status := fnd_api.g_ret_sts_error;
1300: WHEN error_steps_not_complete THEN
1301: gme_common_pvt.log_message('GME_STEPS_NOT_COMPLETE');
1302: x_return_status := fnd_api.g_ret_sts_error;
1303: WHEN error_cmplt_date THEN

Line 1302: x_return_status := fnd_api.g_ret_sts_error;

1298: gme_common_pvt.log_message('GME_API_INVALID_BATCH_COMPL');
1299: x_return_status := fnd_api.g_ret_sts_error;
1300: WHEN error_steps_not_complete THEN
1301: gme_common_pvt.log_message('GME_STEPS_NOT_COMPLETE');
1302: x_return_status := fnd_api.g_ret_sts_error;
1303: WHEN error_cmplt_date THEN
1304: gme_common_pvt.log_message('GME_INVALID_DATE_RANGE'
1305: ,'DATE1','Completion date'
1306: ,'DATE2','Start date');

Line 1307: x_return_status := fnd_api.g_ret_sts_error;

1303: WHEN error_cmplt_date THEN
1304: gme_common_pvt.log_message('GME_INVALID_DATE_RANGE'
1305: ,'DATE1','Completion date'
1306: ,'DATE2','Start date');
1307: x_return_status := fnd_api.g_ret_sts_error;
1308: WHEN error_future_date THEN
1309: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1310: fnd_msg_pub.ADD;
1311: x_return_status := fnd_api.g_ret_sts_error;

Line 1311: x_return_status := fnd_api.g_ret_sts_error;

1307: x_return_status := fnd_api.g_ret_sts_error;
1308: WHEN error_future_date THEN
1309: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1310: fnd_msg_pub.ADD;
1311: x_return_status := fnd_api.g_ret_sts_error;
1312: WHEN error_vr_dates THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314: WHEN OTHERS THEN
1315: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1313: x_return_status := FND_API.G_RET_STS_ERROR;

1309: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1310: fnd_msg_pub.ADD;
1311: x_return_status := fnd_api.g_ret_sts_error;
1312: WHEN error_vr_dates THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314: WHEN OTHERS THEN
1315: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1316:
1317: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1326: x_return_status := fnd_api.g_ret_sts_unexp_error;

1322: || ': '
1323: || SQLERRM);
1324: END IF;
1325:
1326: x_return_status := fnd_api.g_ret_sts_unexp_error;
1327: END validate_batch_for_complete;
1328:
1329: END gme_complete_batch_pvt;