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

Line 171: x_return_status := FND_API.G_RET_STS_SUCCESS;

167: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' gme_common_pvt.g_move_to_temp='||gme_common_pvt.g_move_to_temp);
168: END IF;
169:
170: /* Set the return status to success initially */
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172:
173: -- set local variables for batch and detail...
174: l_batch_header_rec := p_batch_header_rec;
175: l_in_material_detail_rec := p_material_detail_rec;

Line 218: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

214: ,x_pct_plan_res => l_incr_factor_res
215: ,x_return_status => l_return_status);
216: END IF;
217:
218: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219: RAISE error_derive_factor;
220: END IF;
221:
222: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 320: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

316: ,x_scale_rec => l_scale_rec_out
317: ,x_return_status => l_return_status
318: );
319:
320: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
321: RAISE error_cant_go_neg;
322: END IF;
323:
324: l_new_actual := l_scale_rec_out.qty;

Line 349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

345: ,p_item_id => l_material_detail_rec.inventory_item_id
346: ,x_item_rec => l_item_rec
347: ,x_return_status => l_return_status);
348:
349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: x_return_status := l_return_status;
351: RAISE error_get_item;
352: END IF;
353:

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

383: ,p_backflush_rsrc_usg_ind => p_backflush_rsrc_usg_ind
384: ,x_exception_material_tbl => x_exception_material_tbl
385: ,x_return_status => l_return_status);
386:
387: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
388: x_return_status := l_return_status;
389: RAISE error_phantom_backflush;
390: END IF;
391:

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

407: ,x_actual_qty => l_actual_qty
408: ,x_exception_material_tbl => x_exception_material_tbl
409: ,x_return_status => l_return_status);
410:
411: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
412: x_return_status := l_return_status;
413: RAISE error_revert_matl_full;
414: END IF;
415:

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

432: ,p_lot_divisible_flag => l_lot_divisible_flag
433: ,x_actual_qty => l_actual_qty
434: ,x_exception_material_tbl => x_exception_material_tbl
435: ,x_return_status => l_return_status);
436: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
437: x_return_status := l_return_status;
438: RAISE error_revert_matl_part;
439: END IF;
440:

Line 474: ,p_force_unconsumed => fnd_api.g_true

470: (p_material_dtl_rec => l_material_detail_rec
471: ,p_yield_qty => l_new_actual
472: ,p_trans_date => p_trans_date
473: ,p_item_rec => l_item_rec
474: ,p_force_unconsumed => fnd_api.g_true
475: ,x_exception_material_tbl => x_exception_material_tbl
476: ,x_actual_qty => l_actual_qty
477: ,x_return_status => l_return_status);
478: END IF;

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

476: ,x_actual_qty => l_actual_qty
477: ,x_return_status => l_return_status);
478: END IF;
479:
480: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
481: x_return_status := l_return_status;
482: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
483: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' raising exception with x_return_status= '||x_return_status);
484: END IF;

Line 534: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

530: ,x_message_list => l_msg_stack
531: ,x_return_status => l_return_status
532: ,x_batch_step_rec => l_batch_step_rec);
533:
534: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
535: RAISE update_step_qty_error;
536: END IF;
537: END LOOP;
538: ELSIF p_backflush_rsrc_usg_ind = 1 THEN

Line 554: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

550: ,x_message_list => l_msg_stack
551: ,x_return_status => l_return_status
552: ,x_batch_step_rec => l_batch_step_rec);
553:
554: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
555: RAISE update_step_qty_error;
556: END IF;
557:
558: -- Get all previous steps of the product step

Line 564: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

560: (p_batchstep_id => l_in_batch_step_rec.batchstep_id
561: ,p_backflush_factor => l_incr_factor_res/100
562: ,x_return_status => l_return_status);
563:
564: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
565: RAISE ERROR_UPDATING_STEPS;
566: END IF;
567: END IF; -- IF l_in_batch_step_rec.batchstep_id IS NOT NULL THEN
568: END IF; -- IF l_batch_header_rec.automatic_step_calculation = 1 THEN

Line 577: x_return_status := FND_API.g_ret_sts_unexp_error;

573:
574: EXCEPTION
575: WHEN error_fetch_batch OR error_fetch_matl OR error_update_row THEN
576: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
577: x_return_status := FND_API.g_ret_sts_unexp_error;
578: WHEN error_cant_go_neg THEN
579: gme_common_pvt.log_message ('GME_API_ACTUAL_CANT_GO_NEG');
580: x_return_status := FND_API.g_ret_sts_error;
581: WHEN error_derive_factor OR error_get_item OR error_phantom_backflush OR

Line 580: x_return_status := FND_API.g_ret_sts_error;

576: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
577: x_return_status := FND_API.g_ret_sts_unexp_error;
578: WHEN error_cant_go_neg THEN
579: gme_common_pvt.log_message ('GME_API_ACTUAL_CANT_GO_NEG');
580: x_return_status := FND_API.g_ret_sts_error;
581: WHEN error_derive_factor OR error_get_item OR error_phantom_backflush OR
582: error_revert_matl_full OR error_consum_yield OR error_revert_matl_part THEN
583: NULL;
584: WHEN update_step_qty_error OR ERROR_UPDATING_STEPS THEN

Line 591: x_return_status := FND_API.g_ret_sts_unexp_error;

587: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
588: IF g_debug <= gme_debug.g_log_procedure THEN
589: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
590: END IF;
591: x_return_status := FND_API.g_ret_sts_unexp_error;
592: END incremental_backflush;
593:
594:
595: /*FPBug#4667093 Code added to consider new gme parameter for calculating factor */

Line 635: x_return_status := FND_API.G_RET_STS_SUCCESS;

631: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'p_gme_ib_factor ='||p_gme_ib_factor||' line type='||p_material_detail_rec.line_type);
632: END IF;
633:
634: /* Set the return status to success initially */
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636:
637: l_old_actual_qty := p_material_detail_rec.actual_qty;
638:
639: --FPBug#4667093 Begin

Line 653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

649: ,x_total_actual_qty => l_actual_qty
650: ,x_uom => l_uom
651: ,x_return_status => l_return_status );
652:
653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
654: RAISE ERROR_IN_GET_TOTAL_QTY;
655: END IF;
656: ELSE
657: l_required_qty := p_material_detail_rec.wip_plan_qty;

Line 720: x_return_status := FND_API.g_ret_sts_unexp_error;

716: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
717: IF g_debug <= gme_debug.g_log_procedure THEN
718: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
719: END IF;
720: x_return_status := FND_API.g_ret_sts_unexp_error;
721: END derive_factor;
722:
723: PROCEDURE update_dependent_steps(p_batchstep_id IN NUMBER
724: ,p_backflush_factor IN NUMBER

Line 751: x_return_status := FND_API.G_RET_STS_SUCCESS;

747: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batchstep_id='||p_batchstep_id);
748: END IF;
749:
750: -- Set the return status to success initially
751: x_return_status := FND_API.G_RET_STS_SUCCESS;
752:
753: -- Get all previous depenedent steps for current step
754:
755: FOR get_rec IN Cur_prev_steps(p_batchstep_id) LOOP

Line 777: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

773: ,x_batch_step_rec => l_batch_step_rec
774: ,p_backflush_factor => l_backflush_factor
775: ,p_dependency_type => get_rec.dep_type);
776:
777: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
778: RAISE error_updating_steps;
779: END IF;
780: update_dependent_steps
781: (p_batchstep_id => get_rec.dep_step_id

Line 785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

781: (p_batchstep_id => get_rec.dep_step_id
782: ,p_backflush_factor => p_backflush_factor
783: ,x_return_status => x_return_status);
784:
785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
786: RAISE error_updating_steps;
787: END IF;
788: END IF;
789: END LOOP;

Line 803: x_return_status := FND_API.g_ret_sts_unexp_error;

799: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
800: IF g_debug <= gme_debug.g_log_procedure THEN
801: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
802: END IF;
803: x_return_status := FND_API.g_ret_sts_unexp_error;
804: END update_dependent_steps;
805:
806: PROCEDURE revert_material_partial
807: (p_material_detail_rec IN gme_material_details%ROWTYPE

Line 885: x_return_status := FND_API.G_RET_STS_SUCCESS;

881: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
882: END IF;
883:
884: -- Set the return status to success initially
885: x_return_status := FND_API.G_RET_STS_SUCCESS;
886:
887: l_qty := p_qty;
888: l_total_decr_qty := 0;
889:

Line 900: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

896: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
897: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_transactions_pvt.get_mat_trans returned '||l_mmt_tbl.count||' trxns with return_status='||x_return_status);
898: END IF;
899:
900: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
901: RAISE error_get_trans;
902: END IF;
903:
904: -- Make all qties positive for comparison; if updating, the trxn mgr will take care of sign

Line 1008: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1004: -- do nothing... move on to the next, to try to reduce
1005: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1006: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);
1007: END IF;
1008: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1009: x_return_status := l_return_status;
1010: RAISE error_trans;
1011: ELSE -- success
1012: l_total_decr_qty := l_total_decr_qty + l_trxn_qty;

Line 1060: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1056: -- do nothing... move on to the next, to try to reduce
1057: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1058: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);
1059: END IF;
1060: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: x_return_status := l_return_status;
1062: RAISE error_trans;
1063: ELSE -- success
1064: l_total_decr_qty := l_total_decr_qty + l_qty;

Line 1070: l_return_status := FND_API.G_RET_STS_SUCCESS;

1066: -- set the transaction qty back to what was decremented... this record won't be used again
1067: l_mmt_rec.transaction_quantity := l_qty;
1068: l_qty := 0;
1069:
1070: l_return_status := FND_API.G_RET_STS_SUCCESS;
1071: IF l_mmt_rec.secondary_uom_code IS NOT NULL THEN
1072: -- also need to set the secondary_transaction_quantity if applicable
1073: get_converted_qty (
1074: p_org_id => p_material_detail_rec.organization_id

Line 1084: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1080: ,x_conv_qty => l_mmt_rec.secondary_transaction_quantity
1081: ,x_return_status => l_return_status);
1082: END IF;
1083:
1084: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1085: gme_unrelease_batch_pvt.create_resv_pplot
1086: (p_material_detail_rec => p_material_detail_rec
1087: ,p_mmt_rec => l_mmt_rec
1088: ,p_mmln_tbl => l_mmln_tbl

Line 1152: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1148: (p_transaction_id => l_mmt_rec.transaction_id
1149: ,x_mmln_tbl => l_mmln_tbl
1150: ,x_return_status => x_return_status);
1151:
1152: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1153: RAISE error_get_lot;
1154: END IF;
1155:
1156: -- Make all lot qties positive for comparison; if updating, the trxn mgr will take care of sign

Line 1270: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1266: -- do nothing... move on to the next, to try to reduce
1267: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1268: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);
1269: END IF;
1270: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1271: x_return_status := l_return_status;
1272: RAISE error_trans;
1273: ELSE
1274: l_trxn_success := TRUE;

Line 1340: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1336: -- do nothing... move on to the next, to try to reduce
1337: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1338: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);
1339: END IF;
1340: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1341: x_return_status := l_return_status;
1342: RAISE error_trans;
1343: ELSE
1344: l_trxn_success := TRUE;

Line 1348: l_return_status := FND_API.G_RET_STS_SUCCESS;

1344: l_trxn_success := TRUE;
1345: l_mmt_rec.transaction_quantity := l_decr_qty;
1346: -- also need to set the secondary_transaction_quantity if applicable
1347:
1348: l_return_status := FND_API.G_RET_STS_SUCCESS;
1349: IF l_mmt_rec.secondary_uom_code IS NOT NULL THEN
1350: get_converted_qty (
1351: p_org_id => p_material_detail_rec.organization_id
1352: ,p_item_id => p_material_detail_rec.inventory_item_id

Line 1376: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1372: ,x_return_status => l_return_status);
1373: END IF;
1374: END LOOP;
1375:
1376: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1377: gme_unrelease_batch_pvt.create_resv_pplot
1378: (p_material_detail_rec => p_material_detail_rec
1379: ,p_mmt_rec => l_mmt_rec
1380: ,p_mmln_tbl => l_mmln_tbl_orig

Line 1425: ,p_force_unconsumed => fnd_api.g_true

1421: ,p_pending_move_order_ind => NULL
1422: ,p_pending_rsrv_ind => NULL
1423: ,p_transacted_qty => l_total_decr_qty
1424: ,p_exception_qty => l_total_decr_qty - p_qty
1425: ,p_force_unconsumed => fnd_api.g_true
1426: ,x_exception_material_tbl => x_exception_material_tbl
1427: ,x_return_status => x_return_status);
1428: END IF;
1429:

Line 1442: x_return_status := FND_API.g_ret_sts_unexp_error;

1438: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1439: IF g_debug <= gme_debug.g_log_procedure THEN
1440: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1441: END IF;
1442: x_return_status := FND_API.g_ret_sts_unexp_error;
1443: END revert_material_partial;
1444:
1445: PROCEDURE validate_material_for_IB(p_material_detail_rec IN gme_material_details%ROWTYPE
1446: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 1481: x_return_status := FND_API.G_RET_STS_SUCCESS;

1477: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_adjust_cmplt='||p_adjust_cmplt);
1478: END IF;
1479:
1480: -- Set the return status to success initially
1481: x_return_status := FND_API.G_RET_STS_SUCCESS;
1482:
1483: -- IB not allowed for FPO
1484: IF p_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_fpo THEN
1485: RAISE ERROR_INV_ACTION_FPO;

Line 1506: IF p_adjust_cmplt = fnd_api.g_false THEN

1502: END IF;
1503:
1504: -- If batch is complete then proceed only if user wants to adjust qty
1505: IF p_batch_header_rec.batch_status = gme_common_pvt.g_batch_completed THEN
1506: IF p_adjust_cmplt = fnd_api.g_false THEN
1507: RAISE ERROR_ADJ_CMPLT_NOT_ALLOW;
1508: END IF;
1509: END IF;
1510:

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

1535: END IF;
1536:
1537: EXCEPTION
1538: WHEN ERROR_INV_ACTION_FPO THEN
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: gme_common_pvt.log_message('GME_INV_ACTION_FPO');
1541: --Bug#5111078
1542: WHEN error_inv_action_lab THEN
1543: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1543: x_return_status := FND_API.G_RET_STS_ERROR;

1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: gme_common_pvt.log_message('GME_INV_ACTION_FPO');
1541: --Bug#5111078
1542: WHEN error_inv_action_lab THEN
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: gme_common_pvt.log_message('GME_IB_FOR_UPDINV_NT_ALWD');
1545: WHEN ERROR_INV_BATCH_STATUS THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: gme_common_pvt.log_message('GME_API_INV_BATCH_STATUS_PC');

Line 1546: x_return_status := FND_API.G_RET_STS_ERROR;

1542: WHEN error_inv_action_lab THEN
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: gme_common_pvt.log_message('GME_IB_FOR_UPDINV_NT_ALWD');
1545: WHEN ERROR_INV_BATCH_STATUS THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: gme_common_pvt.log_message('GME_API_INV_BATCH_STATUS_PC');
1548: WHEN ERROR_INV_RELEASE_TYPE THEN
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550: gme_common_pvt.log_message('GME_API_INV_RELEASE_TYPE');

Line 1549: x_return_status := FND_API.G_RET_STS_ERROR;

1545: WHEN ERROR_INV_BATCH_STATUS THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: gme_common_pvt.log_message('GME_API_INV_BATCH_STATUS_PC');
1548: WHEN ERROR_INV_RELEASE_TYPE THEN
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550: gme_common_pvt.log_message('GME_API_INV_RELEASE_TYPE');
1551: WHEN ERROR_INV_WIP_PLAN_QTY THEN
1552: x_return_status := FND_API.G_RET_STS_ERROR;
1553: gme_common_pvt.log_message('GME_API_INV_WIP_PLAN_QTY_PC');

Line 1552: x_return_status := FND_API.G_RET_STS_ERROR;

1548: WHEN ERROR_INV_RELEASE_TYPE THEN
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550: gme_common_pvt.log_message('GME_API_INV_RELEASE_TYPE');
1551: WHEN ERROR_INV_WIP_PLAN_QTY THEN
1552: x_return_status := FND_API.G_RET_STS_ERROR;
1553: gme_common_pvt.log_message('GME_API_INV_WIP_PLAN_QTY_PC');
1554: WHEN ERROR_ADJ_CMPLT_NOT_ALLOW THEN
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: gme_common_pvt.log_message('GME_API_ASK_ADJUST_CERTIFY');

Line 1555: x_return_status := FND_API.G_RET_STS_ERROR;

1551: WHEN ERROR_INV_WIP_PLAN_QTY THEN
1552: x_return_status := FND_API.G_RET_STS_ERROR;
1553: gme_common_pvt.log_message('GME_API_INV_WIP_PLAN_QTY_PC');
1554: WHEN ERROR_ADJ_CMPLT_NOT_ALLOW THEN
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: gme_common_pvt.log_message('GME_API_ASK_ADJUST_CERTIFY');
1557: WHEN error_step_closed THEN
1558: x_return_status := FND_API.G_RET_STS_ERROR;
1559: GME_COMMON_PVT.log_message ('GME_STEP_CLOSED_ERR', 'STEP_NO', l_step_no);

Line 1558: x_return_status := FND_API.G_RET_STS_ERROR;

1554: WHEN ERROR_ADJ_CMPLT_NOT_ALLOW THEN
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: gme_common_pvt.log_message('GME_API_ASK_ADJUST_CERTIFY');
1557: WHEN error_step_closed THEN
1558: x_return_status := FND_API.G_RET_STS_ERROR;
1559: GME_COMMON_PVT.log_message ('GME_STEP_CLOSED_ERR', 'STEP_NO', l_step_no);
1560: WHEN error_step_cancelled THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: GME_COMMON_PVT.log_message ('GME_STEP_CANCELLED_ERR', 'STEP_NO', l_step_no);

Line 1561: x_return_status := FND_API.G_RET_STS_ERROR;

1557: WHEN error_step_closed THEN
1558: x_return_status := FND_API.G_RET_STS_ERROR;
1559: GME_COMMON_PVT.log_message ('GME_STEP_CLOSED_ERR', 'STEP_NO', l_step_no);
1560: WHEN error_step_cancelled THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: GME_COMMON_PVT.log_message ('GME_STEP_CANCELLED_ERR', 'STEP_NO', l_step_no);
1563: WHEN error_inv_action_phantom THEN
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: gme_common_pvt.log_message('PM_INVALID_PHANTOM_ACTION');

Line 1564: x_return_status := FND_API.G_RET_STS_ERROR;

1560: WHEN error_step_cancelled THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: GME_COMMON_PVT.log_message ('GME_STEP_CANCELLED_ERR', 'STEP_NO', l_step_no);
1563: WHEN error_inv_action_phantom THEN
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: gme_common_pvt.log_message('PM_INVALID_PHANTOM_ACTION');
1566: WHEN OTHERS THEN
1567: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1568: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1571: x_return_status := FND_API.g_ret_sts_unexp_error;

1567: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1568: IF g_debug <= gme_debug.g_log_procedure THEN
1569: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1570: END IF;
1571: x_return_status := FND_API.g_ret_sts_unexp_error;
1572: END validate_material_for_IB;
1573:
1574: PROCEDURE validate_qty_for_IB (p_qty_type IN NUMBER
1575: ,p_qty IN NUMBER

Line 1592: x_return_status := FND_API.G_RET_STS_SUCCESS;

1588: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_actual_qty='||p_actual_qty);
1589: END IF;
1590:
1591: -- Set the return status to success initially
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593:
1594: -- p_qty_type 0 increment qty
1595: -- p_qty_type 1 new act qty
1596: -- p_qty_type 2 % plan

Line 1629: x_return_status := FND_API.G_RET_STS_ERROR;

1625: END IF;
1626:
1627: EXCEPTION
1628: WHEN ERROR_INV_INCR_TYPE THEN
1629: x_return_status := FND_API.G_RET_STS_ERROR;
1630: gme_common_pvt.log_message( 'GME_API_INVALID_INCR_TYPE');
1631: WHEN ERROR_QTY_CREATE_NEG_ACTUAL THEN
1632: x_return_status := FND_API.G_RET_STS_ERROR;
1633: gme_common_pvt.log_message( 'GME_API_ACTUAL_CANT_GO_NEG');

Line 1632: x_return_status := FND_API.G_RET_STS_ERROR;

1628: WHEN ERROR_INV_INCR_TYPE THEN
1629: x_return_status := FND_API.G_RET_STS_ERROR;
1630: gme_common_pvt.log_message( 'GME_API_INVALID_INCR_TYPE');
1631: WHEN ERROR_QTY_CREATE_NEG_ACTUAL THEN
1632: x_return_status := FND_API.G_RET_STS_ERROR;
1633: gme_common_pvt.log_message( 'GME_API_ACTUAL_CANT_GO_NEG');
1634: WHEN ERROR_QTY_CANT_BE_ZERO THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: gme_common_pvt.log_message( 'GME_API_QTY_CANT_BE_ZERO');

Line 1635: x_return_status := FND_API.G_RET_STS_ERROR;

1631: WHEN ERROR_QTY_CREATE_NEG_ACTUAL THEN
1632: x_return_status := FND_API.G_RET_STS_ERROR;
1633: gme_common_pvt.log_message( 'GME_API_ACTUAL_CANT_GO_NEG');
1634: WHEN ERROR_QTY_CANT_BE_ZERO THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: gme_common_pvt.log_message( 'GME_API_QTY_CANT_BE_ZERO');
1637: WHEN OTHERS THEN
1638: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1639: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1642: x_return_status := FND_API.g_ret_sts_unexp_error;

1638: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1639: IF g_debug <= gme_debug.g_log_procedure THEN
1640: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1641: END IF;
1642: x_return_status := FND_API.g_ret_sts_unexp_error;
1643: END validate_qty_for_IB;
1644:
1645: PROCEDURE get_converted_qty (
1646: p_org_id IN NUMBER

Line 1670: x_return_status := FND_API.G_RET_STS_SUCCESS;

1666: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_to_um='||p_to_um);
1667: END IF;
1668:
1669: /* Set the return status to success initially */
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;
1671:
1672: IF p_to_um = p_from_um THEN
1673: x_conv_qty := p_qty;
1674: ELSE

Line 1724: x_return_status := fnd_api.g_ret_sts_error;

1720: WHEN um_convert_error THEN
1721: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1722: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1723: fnd_msg_pub.ADD;
1724: x_return_status := fnd_api.g_ret_sts_error;
1725: WHEN OTHERS THEN
1726: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1727:
1728: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 1736: x_return_status := fnd_api.g_ret_sts_unexp_error;

1732: || l_api_name
1733: || ': '
1734: || SQLERRM);
1735: END IF;
1736: x_return_status := fnd_api.g_ret_sts_unexp_error;
1737: END get_converted_qty;
1738:
1739:
1740: END gme_incremental_backflush_pvt;