2652: , 9);
2653: END IF;
2654: SELECT meaning
2655: INTO l_error_message
2656: FROM mfg_lookups
2657: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
2658: AND lookup_code = 7;
2659: RETURN(l_error_message);
2660: ELSIF (p_level = 1 AND p_item_rec.src_type = 3 AND p_item_rec.mbf = 2) THEN
2664: , 9);
2665: END IF;
2666: SELECT meaning
2667: INTO l_error_message
2668: FROM mfg_lookups
2669: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
2670: AND lookup_code = 6;
2671: RETURN(l_error_message);
2672: ELSE
3469: -- get_move_order_header_id.
3470: --
3471: -- the profile value set at the profile "INV: Minmax Reorder Approval"
3472: -- This profile can have 3 values:
3473: -- (Lookup Type 'MTL_REQUISITION_APPROVAL' defined in MFG_LOOKUPS)
3474: -- 1- Pre-approve d
3475: -- 2- Pre-approve move orders only
3476: -- 3- Approval Required
3477: -- Converting these codes to the ones defined in MFG_LOOKUPS under the
3473: -- (Lookup Type 'MTL_REQUISITION_APPROVAL' defined in MFG_LOOKUPS)
3474: -- 1- Pre-approve d
3475: -- 2- Pre-approve move orders only
3476: -- 3- Approval Required
3477: -- Converting these codes to the ones defined in MFG_LOOKUPS under the
3478: -- lookup type'MTL_TXN_REQUEST_STATUS'.
3479: -- IF l_approval = 3 THEN
3480: -- l_approval := 1; -- Incomplete
3481: -- ELSE
3785: WHEN requisition_exc THEN
3786: ROLLBACK TO sp_do_restock;
3787: SELECT meaning
3788: INTO x_ret_mesg
3789: FROM mfg_lookups
3790: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
3791: AND lookup_code = 1;
3792:
3793: x_ret_stat := FND_API.G_RET_STS_ERROR;
3795: WHEN move_ord_exc THEN
3796: ROLLBACK TO sp_do_restock;
3797: SELECT meaning
3798: INTO x_ret_mesg
3799: FROM mfg_lookups
3800: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
3801: AND lookup_code = 5;
3802:
3803: x_ret_stat := FND_API.G_RET_STS_ERROR;
4102: END IF;
4103:
4104: SELECT meaning
4105: INTO x_ret_mesg
4106: FROM mfg_lookups
4107: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4108: AND lookup_code = 1;
4109:
4110: x_ret_stat := FND_API.G_RET_STS_ERROR;
4405: END IF;
4406:
4407: SELECT meaning
4408: INTO x_ret_mesg
4409: FROM mfg_lookups
4410: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4411: AND lookup_code = 2;
4412:
4413: x_ret_stat := FND_API.G_RET_STS_ERROR;
4526: END IF;
4527:
4528: SELECT meaning
4529: INTO x_ret_mesg
4530: FROM mfg_lookups
4531: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4532: AND lookup_code = 2;
4533:
4534: x_ret_stat := FND_API.G_RET_STS_ERROR;