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 214: x_return_status := FND_API.G_RET_STS_SUCCESS;

210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' gme_common_pvt.g_move_to_temp='||gme_common_pvt.g_move_to_temp);
211: END IF;
212:
213: /* Set the return status to success initially */
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: -- set local variables for batch and detail...
217: l_batch_header_rec := p_batch_header_rec;
218: l_in_material_detail_rec := p_material_detail_rec;

Line 261: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

257: ,x_pct_plan_res => l_incr_factor_res
258: ,x_return_status => l_return_status);
259: END IF;
260:
261: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
262: RAISE error_derive_factor;
263: END IF;
264:
265: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 363: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

359: ,x_scale_rec => l_scale_rec_out
360: ,x_return_status => l_return_status
361: );
362:
363: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
364: RAISE error_cant_go_neg;
365: END IF;
366:
367: l_new_actual := l_scale_rec_out.qty;

Line 399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

395: ,p_item_id => l_material_detail_rec.inventory_item_id
396: ,x_item_rec => l_item_rec
397: ,x_return_status => l_return_status);
398:
399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
400: x_return_status := l_return_status;
401: RAISE error_get_item;
402: END IF;
403:

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

433: ,p_backflush_rsrc_usg_ind => p_backflush_rsrc_usg_ind
434: ,x_exception_material_tbl => x_exception_material_tbl
435: ,x_return_status => l_return_status);
436:
437: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
438: x_return_status := l_return_status;
439: RAISE error_phantom_backflush;
440: END IF;
441:

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

469: ,x_actual_qty => l_actual_qty
470: ,x_exception_material_tbl => x_exception_material_tbl
471: ,x_return_status => l_return_status);
472:
473: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
474: x_return_status := l_return_status;
475: RAISE error_revert_matl_full;
476: END IF;
477:

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

500: ,p_lot_divisible_flag => l_lot_divisible_flag
501: ,x_actual_qty => l_actual_qty
502: ,x_exception_material_tbl => x_exception_material_tbl
503: ,x_return_status => l_return_status);
504: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
505: x_return_status := l_return_status;
506: RAISE error_revert_matl_part;
507: END IF;
508:

Line 542: ,p_force_unconsumed => fnd_api.g_true

538: (p_material_dtl_rec => l_material_detail_rec
539: ,p_yield_qty => l_new_actual
540: ,p_trans_date => p_trans_date
541: ,p_item_rec => l_item_rec
542: ,p_force_unconsumed => fnd_api.g_true
543: ,x_exception_material_tbl => x_exception_material_tbl
544: ,x_actual_qty => l_actual_qty
545: ,x_return_status => l_return_status);
546: END IF;

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

544: ,x_actual_qty => l_actual_qty
545: ,x_return_status => l_return_status);
546: END IF;
547:
548: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
549: x_return_status := l_return_status;
550: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
551: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' raising exception with x_return_status= '||x_return_status);
552: END IF;

Line 644: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

640: ,x_message_list => l_msg_stack
641: ,x_return_status => l_return_status
642: ,x_batch_step_rec => l_batch_step_rec);
643:
644: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
645: RAISE update_step_qty_error;
646: END IF;
647: END LOOP;
648: ELSIF p_backflush_rsrc_usg_ind = 1 THEN

Line 664: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

660: ,x_message_list => l_msg_stack
661: ,x_return_status => l_return_status
662: ,x_batch_step_rec => l_batch_step_rec);
663:
664: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
665: RAISE update_step_qty_error;
666: END IF;
667:
668: -- Get all previous steps of the product step

Line 674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

670: (p_batchstep_id => l_in_batch_step_rec.batchstep_id
671: ,p_backflush_factor => l_incr_factor_res/100
672: ,x_return_status => l_return_status);
673:
674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
675: RAISE ERROR_UPDATING_STEPS;
676: END IF;
677:
678: IF gme_common_pvt.g_ib_timestamp_set > 0 THEN

Line 727: x_return_status := FND_API.g_ret_sts_unexp_error;

723:
724: EXCEPTION
725: WHEN error_fetch_batch OR error_fetch_matl OR error_update_row THEN
726: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
727: x_return_status := FND_API.g_ret_sts_unexp_error;
728: WHEN error_cant_go_neg THEN
729: gme_common_pvt.log_message ('GME_API_ACTUAL_CANT_GO_NEG');
730: x_return_status := FND_API.g_ret_sts_error;
731: WHEN error_derive_factor OR error_get_item OR error_phantom_backflush OR

Line 730: x_return_status := FND_API.g_ret_sts_error;

726: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
727: x_return_status := FND_API.g_ret_sts_unexp_error;
728: WHEN error_cant_go_neg THEN
729: gme_common_pvt.log_message ('GME_API_ACTUAL_CANT_GO_NEG');
730: x_return_status := FND_API.g_ret_sts_error;
731: WHEN error_derive_factor OR error_get_item OR error_phantom_backflush OR
732: error_revert_matl_full OR error_consum_yield OR error_revert_matl_part THEN
733: NULL;
734: WHEN update_step_qty_error OR ERROR_UPDATING_STEPS THEN

Line 741: x_return_status := FND_API.g_ret_sts_unexp_error;

737: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
738: IF g_debug <= gme_debug.g_log_procedure THEN
739: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
740: END IF;
741: x_return_status := FND_API.g_ret_sts_unexp_error;
742: END incremental_backflush;
743:
744:
745: /*FPBug#4667093 Code added to consider new gme parameter for calculating factor */

Line 787: x_return_status := FND_API.G_RET_STS_SUCCESS;

783: 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);
784: END IF;
785:
786: /* Set the return status to success initially */
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788:
789: l_old_actual_qty := p_material_detail_rec.actual_qty;
790:
791: --FPBug#4667093 Begin

Line 805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

801: ,x_total_actual_qty => l_actual_qty
802: ,x_uom => l_uom
803: ,x_return_status => l_return_status );
804:
805: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
806: RAISE ERROR_IN_GET_TOTAL_QTY;
807: END IF;
808: ELSE
809: l_plan_qty := p_material_detail_rec.plan_qty;

Line 898: x_return_status := FND_API.g_ret_sts_unexp_error;

894: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
895: IF g_debug <= gme_debug.g_log_procedure THEN
896: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
897: END IF;
898: x_return_status := FND_API.g_ret_sts_unexp_error;
899: END derive_factor;
900:
901: PROCEDURE update_dependent_steps(p_batchstep_id IN NUMBER
902: ,p_backflush_factor IN NUMBER

Line 929: x_return_status := FND_API.G_RET_STS_SUCCESS;

925: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batchstep_id='||p_batchstep_id);
926: END IF;
927:
928: -- Set the return status to success initially
929: x_return_status := FND_API.G_RET_STS_SUCCESS;
930:
931: -- Get all previous depenedent steps for current step
932:
933: FOR get_rec IN Cur_prev_steps(p_batchstep_id) LOOP

Line 955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

951: ,x_batch_step_rec => l_batch_step_rec
952: ,p_backflush_factor => l_backflush_factor
953: ,p_dependency_type => get_rec.dep_type);
954:
955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
956: RAISE error_updating_steps;
957: END IF;
958: update_dependent_steps
959: (p_batchstep_id => get_rec.dep_step_id

Line 963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

959: (p_batchstep_id => get_rec.dep_step_id
960: ,p_backflush_factor => p_backflush_factor
961: ,x_return_status => x_return_status);
962:
963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
964: RAISE error_updating_steps;
965: END IF;
966: END IF;
967: END LOOP;

Line 981: x_return_status := FND_API.g_ret_sts_unexp_error;

977: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
978: IF g_debug <= gme_debug.g_log_procedure THEN
979: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
980: END IF;
981: x_return_status := FND_API.g_ret_sts_unexp_error;
982: END update_dependent_steps;
983:
984: PROCEDURE revert_material_partial
985: (p_material_detail_rec IN gme_material_details%ROWTYPE

Line 1071: x_return_status := FND_API.G_RET_STS_SUCCESS;

1067: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
1068: END IF;
1069:
1070: -- Set the return status to success initially
1071: x_return_status := FND_API.G_RET_STS_SUCCESS;
1072:
1073: l_qty := p_qty;
1074: l_total_decr_qty := 0;
1075:

Line 1091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1087: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1088: 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);
1089: END IF;
1090:
1091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1092: RAISE error_get_trans;
1093: END IF;
1094:
1095: -- Make all qties positive for comparison; if updating, the trxn mgr will take care of sign

Line 1204: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1200: -- do nothing... move on to the next, to try to reduce
1201: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1202: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);
1203: END IF;
1204: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1205: x_return_status := l_return_status;
1206: RAISE error_trans;
1207: ELSE -- success
1208: l_total_decr_qty := l_total_decr_qty + l_trxn_qty;

Line 1264: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1260: -- do nothing... move on to the next, to try to reduce
1261: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1262: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);
1263: END IF;
1264: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1265: x_return_status := l_return_status;
1266: RAISE error_trans;
1267: ELSE -- success
1268: l_total_decr_qty := l_total_decr_qty + l_qty;

Line 1274: l_return_status := FND_API.G_RET_STS_SUCCESS;

1270: -- set the transaction qty back to what was decremented... this record won't be used again
1271: l_mmt_rec.transaction_quantity := l_qty;
1272: l_qty := 0;
1273:
1274: l_return_status := FND_API.G_RET_STS_SUCCESS;
1275: IF l_mmt_rec.secondary_uom_code IS NOT NULL THEN
1276: -- also need to set the secondary_transaction_quantity if applicable
1277: get_converted_qty (
1278: p_org_id => p_material_detail_rec.organization_id

Line 1288: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1284: ,x_conv_qty => l_mmt_rec.secondary_transaction_quantity
1285: ,x_return_status => l_return_status);
1286: END IF;
1287:
1288: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1289: gme_unrelease_batch_pvt.create_resv_pplot
1290: (p_material_detail_rec => p_material_detail_rec
1291: ,p_mmt_rec => l_mmt_rec
1292: ,p_mmln_tbl => l_mmln_tbl

Line 1356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1352: (p_transaction_id => l_mmt_rec.transaction_id
1353: ,x_mmln_tbl => l_mmln_tbl
1354: ,x_return_status => x_return_status);
1355:
1356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1357: RAISE error_get_lot;
1358: END IF;
1359:
1360: -- Make all lot qties positive for comparison; if updating, the trxn mgr will take care of sign

Line 1499: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1495: -- do nothing... move on to the next, to try to reduce
1496: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1497: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.delete_material_txn returned '||l_return_status);
1498: END IF;
1499: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1500: x_return_status := l_return_status;
1501: RAISE error_trans;
1502: ELSE
1503: l_trxn_success := TRUE;

Line 1579: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1575: -- do nothing... move on to the next, to try to reduce
1576: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1577: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in trxn loop; gme_transactions_pvt.update_material_txn returned '||l_return_status);
1578: END IF;
1579: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1580: x_return_status := l_return_status;
1581: RAISE error_trans;
1582: ELSE
1583: l_trxn_success := TRUE;

Line 1587: l_return_status := FND_API.G_RET_STS_SUCCESS;

1583: l_trxn_success := TRUE;
1584: l_mmt_rec.transaction_quantity := l_decr_qty;
1585: -- also need to set the secondary_transaction_quantity if applicable
1586:
1587: l_return_status := FND_API.G_RET_STS_SUCCESS;
1588: IF l_mmt_rec.secondary_uom_code IS NOT NULL THEN
1589: get_converted_qty (
1590: p_org_id => p_material_detail_rec.organization_id
1591: ,p_item_id => p_material_detail_rec.inventory_item_id

Line 1615: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1611: ,x_return_status => l_return_status);
1612: END IF;
1613: END LOOP;
1614:
1615: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1616: gme_unrelease_batch_pvt.create_resv_pplot
1617: (p_material_detail_rec => p_material_detail_rec
1618: ,p_mmt_rec => l_mmt_rec
1619: ,p_mmln_tbl => l_mmln_tbl_orig

Line 1665: ,p_force_unconsumed => fnd_api.g_true

1661: ,p_pending_move_order_ind => NULL
1662: ,p_pending_rsrv_ind => NULL
1663: ,p_transacted_qty => l_total_decr_qty
1664: ,p_exception_qty => l_total_decr_qty - p_qty
1665: ,p_force_unconsumed => fnd_api.g_true
1666: ,x_exception_material_tbl => x_exception_material_tbl
1667: ,x_return_status => x_return_status);
1668: END IF;
1669:

Line 1682: x_return_status := FND_API.g_ret_sts_unexp_error;

1678: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1679: IF g_debug <= gme_debug.g_log_procedure THEN
1680: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1681: END IF;
1682: x_return_status := FND_API.g_ret_sts_unexp_error;
1683: END revert_material_partial;
1684:
1685: PROCEDURE validate_material_for_IB(p_material_detail_rec IN gme_material_details%ROWTYPE
1686: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 1721: x_return_status := FND_API.G_RET_STS_SUCCESS;

1717: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_adjust_cmplt='||p_adjust_cmplt);
1718: END IF;
1719:
1720: -- Set the return status to success initially
1721: x_return_status := FND_API.G_RET_STS_SUCCESS;
1722:
1723: -- IB not allowed for FPO
1724: IF p_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_fpo THEN
1725: RAISE ERROR_INV_ACTION_FPO;

Line 1746: IF p_adjust_cmplt = fnd_api.g_false THEN

1742: END IF;
1743:
1744: -- If batch is complete then proceed only if user wants to adjust qty
1745: IF p_batch_header_rec.batch_status = gme_common_pvt.g_batch_completed THEN
1746: IF p_adjust_cmplt = fnd_api.g_false THEN
1747: RAISE ERROR_ADJ_CMPLT_NOT_ALLOW;
1748: END IF;
1749: END IF;
1750:

Line 1779: x_return_status := FND_API.G_RET_STS_ERROR;

1775: END IF;
1776:
1777: EXCEPTION
1778: WHEN ERROR_INV_ACTION_FPO THEN
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: gme_common_pvt.log_message('GME_INV_ACTION_FPO');
1781: --Bug#5111078
1782: WHEN error_inv_action_lab THEN
1783: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1783: x_return_status := FND_API.G_RET_STS_ERROR;

1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: gme_common_pvt.log_message('GME_INV_ACTION_FPO');
1781: --Bug#5111078
1782: WHEN error_inv_action_lab THEN
1783: x_return_status := FND_API.G_RET_STS_ERROR;
1784: gme_common_pvt.log_message('GME_IB_FOR_UPDINV_NT_ALWD');
1785: WHEN ERROR_INV_BATCH_STATUS THEN
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: gme_common_pvt.log_message('GME_API_INV_BATCH_STATUS_PC');

Line 1786: x_return_status := FND_API.G_RET_STS_ERROR;

1782: WHEN error_inv_action_lab THEN
1783: x_return_status := FND_API.G_RET_STS_ERROR;
1784: gme_common_pvt.log_message('GME_IB_FOR_UPDINV_NT_ALWD');
1785: WHEN ERROR_INV_BATCH_STATUS THEN
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: gme_common_pvt.log_message('GME_API_INV_BATCH_STATUS_PC');
1788: WHEN ERROR_INV_RELEASE_TYPE THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: gme_common_pvt.log_message('GME_API_INV_RELEASE_TYPE');

Line 1789: x_return_status := FND_API.G_RET_STS_ERROR;

1785: WHEN ERROR_INV_BATCH_STATUS THEN
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: gme_common_pvt.log_message('GME_API_INV_BATCH_STATUS_PC');
1788: WHEN ERROR_INV_RELEASE_TYPE THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: gme_common_pvt.log_message('GME_API_INV_RELEASE_TYPE');
1791: WHEN ERROR_INV_WIP_PLAN_QTY THEN
1792: x_return_status := FND_API.G_RET_STS_ERROR;
1793: gme_common_pvt.log_message('GME_API_INV_WIP_PLAN_QTY_PC');

Line 1792: x_return_status := FND_API.G_RET_STS_ERROR;

1788: WHEN ERROR_INV_RELEASE_TYPE THEN
1789: x_return_status := FND_API.G_RET_STS_ERROR;
1790: gme_common_pvt.log_message('GME_API_INV_RELEASE_TYPE');
1791: WHEN ERROR_INV_WIP_PLAN_QTY THEN
1792: x_return_status := FND_API.G_RET_STS_ERROR;
1793: gme_common_pvt.log_message('GME_API_INV_WIP_PLAN_QTY_PC');
1794: WHEN ERROR_ADJ_CMPLT_NOT_ALLOW THEN
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: gme_common_pvt.log_message('GME_API_ASK_ADJUST_CERTIFY');

Line 1795: x_return_status := FND_API.G_RET_STS_ERROR;

1791: WHEN ERROR_INV_WIP_PLAN_QTY THEN
1792: x_return_status := FND_API.G_RET_STS_ERROR;
1793: gme_common_pvt.log_message('GME_API_INV_WIP_PLAN_QTY_PC');
1794: WHEN ERROR_ADJ_CMPLT_NOT_ALLOW THEN
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: gme_common_pvt.log_message('GME_API_ASK_ADJUST_CERTIFY');
1797: WHEN error_step_closed THEN
1798: x_return_status := FND_API.G_RET_STS_ERROR;
1799: GME_COMMON_PVT.log_message ('GME_STEP_CLOSED_ERR', 'STEP_NO', l_step_no);

Line 1798: x_return_status := FND_API.G_RET_STS_ERROR;

1794: WHEN ERROR_ADJ_CMPLT_NOT_ALLOW THEN
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: gme_common_pvt.log_message('GME_API_ASK_ADJUST_CERTIFY');
1797: WHEN error_step_closed THEN
1798: x_return_status := FND_API.G_RET_STS_ERROR;
1799: GME_COMMON_PVT.log_message ('GME_STEP_CLOSED_ERR', 'STEP_NO', l_step_no);
1800: WHEN error_step_cancelled THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: GME_COMMON_PVT.log_message ('GME_STEP_CANCELLED_ERR', 'STEP_NO', l_step_no);

Line 1801: x_return_status := FND_API.G_RET_STS_ERROR;

1797: WHEN error_step_closed THEN
1798: x_return_status := FND_API.G_RET_STS_ERROR;
1799: GME_COMMON_PVT.log_message ('GME_STEP_CLOSED_ERR', 'STEP_NO', l_step_no);
1800: WHEN error_step_cancelled THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: GME_COMMON_PVT.log_message ('GME_STEP_CANCELLED_ERR', 'STEP_NO', l_step_no);
1803: WHEN error_inv_action_phantom THEN
1804: x_return_status := FND_API.G_RET_STS_ERROR;
1805: gme_common_pvt.log_message('PM_INVALID_PHANTOM_ACTION');

Line 1804: x_return_status := FND_API.G_RET_STS_ERROR;

1800: WHEN error_step_cancelled THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: GME_COMMON_PVT.log_message ('GME_STEP_CANCELLED_ERR', 'STEP_NO', l_step_no);
1803: WHEN error_inv_action_phantom THEN
1804: x_return_status := FND_API.G_RET_STS_ERROR;
1805: gme_common_pvt.log_message('PM_INVALID_PHANTOM_ACTION');
1806: WHEN OTHERS THEN
1807: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1808: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1811: x_return_status := FND_API.g_ret_sts_unexp_error;

1807: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1808: IF g_debug <= gme_debug.g_log_procedure THEN
1809: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1810: END IF;
1811: x_return_status := FND_API.g_ret_sts_unexp_error;
1812: END validate_material_for_IB;
1813:
1814: PROCEDURE validate_qty_for_IB (p_qty_type IN NUMBER
1815: ,p_qty IN NUMBER

Line 1832: x_return_status := FND_API.G_RET_STS_SUCCESS;

1828: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_actual_qty='||p_actual_qty);
1829: END IF;
1830:
1831: -- Set the return status to success initially
1832: x_return_status := FND_API.G_RET_STS_SUCCESS;
1833:
1834: -- p_qty_type 0 increment qty
1835: -- p_qty_type 1 new act qty
1836: -- p_qty_type 2 % plan

Line 1869: x_return_status := FND_API.G_RET_STS_ERROR;

1865: END IF;
1866:
1867: EXCEPTION
1868: WHEN ERROR_INV_INCR_TYPE THEN
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: gme_common_pvt.log_message( 'GME_API_INVALID_INCR_TYPE');
1871: WHEN ERROR_QTY_CREATE_NEG_ACTUAL THEN
1872: x_return_status := FND_API.G_RET_STS_ERROR;
1873: gme_common_pvt.log_message( 'GME_API_ACTUAL_CANT_GO_NEG');

Line 1872: x_return_status := FND_API.G_RET_STS_ERROR;

1868: WHEN ERROR_INV_INCR_TYPE THEN
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: gme_common_pvt.log_message( 'GME_API_INVALID_INCR_TYPE');
1871: WHEN ERROR_QTY_CREATE_NEG_ACTUAL THEN
1872: x_return_status := FND_API.G_RET_STS_ERROR;
1873: gme_common_pvt.log_message( 'GME_API_ACTUAL_CANT_GO_NEG');
1874: WHEN ERROR_QTY_CANT_BE_ZERO THEN
1875: x_return_status := FND_API.G_RET_STS_ERROR;
1876: gme_common_pvt.log_message( 'GME_API_QTY_CANT_BE_ZERO');

Line 1875: x_return_status := FND_API.G_RET_STS_ERROR;

1871: WHEN ERROR_QTY_CREATE_NEG_ACTUAL THEN
1872: x_return_status := FND_API.G_RET_STS_ERROR;
1873: gme_common_pvt.log_message( 'GME_API_ACTUAL_CANT_GO_NEG');
1874: WHEN ERROR_QTY_CANT_BE_ZERO THEN
1875: x_return_status := FND_API.G_RET_STS_ERROR;
1876: gme_common_pvt.log_message( 'GME_API_QTY_CANT_BE_ZERO');
1877: WHEN OTHERS THEN
1878: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1879: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1882: x_return_status := FND_API.g_ret_sts_unexp_error;

1878: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1879: IF g_debug <= gme_debug.g_log_procedure THEN
1880: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1881: END IF;
1882: x_return_status := FND_API.g_ret_sts_unexp_error;
1883: END validate_qty_for_IB;
1884:
1885: PROCEDURE get_converted_qty (
1886: p_org_id IN NUMBER

Line 1910: x_return_status := FND_API.G_RET_STS_SUCCESS;

1906: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_to_um='||p_to_um);
1907: END IF;
1908:
1909: /* Set the return status to success initially */
1910: x_return_status := FND_API.G_RET_STS_SUCCESS;
1911:
1912: IF p_to_um = p_from_um THEN
1913: x_conv_qty := p_qty;
1914: ELSE

Line 1964: x_return_status := fnd_api.g_ret_sts_error;

1960: WHEN um_convert_error THEN
1961: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1962: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1963: fnd_msg_pub.ADD;
1964: x_return_status := fnd_api.g_ret_sts_error;
1965: WHEN OTHERS THEN
1966: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1967:
1968: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 1976: x_return_status := fnd_api.g_ret_sts_unexp_error;

1972: || l_api_name
1973: || ': '
1974: || SQLERRM);
1975: END IF;
1976: x_return_status := fnd_api.g_ret_sts_unexp_error;
1977: END get_converted_qty;
1978:
1979:
1980: END gme_incremental_backflush_pvt;