3017: EXCEPTION
3018: WHEN CST_FAIL_GET_NQR THEN
3019: o_err_num := 30005;
3020: o_err_code := SQLCODE;
3021: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_NQR');
3022: o_err_msg := FND_MESSAGE.Get;
3023: WHEN CST_FAIL_GET_CHARGE_ALLOCS THEN
3024: o_err_num := 30007;
3025: o_err_code := SQLCODE;
3018: WHEN CST_FAIL_GET_NQR THEN
3019: o_err_num := 30005;
3020: o_err_code := SQLCODE;
3021: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_NQR');
3022: o_err_msg := FND_MESSAGE.Get;
3023: WHEN CST_FAIL_GET_CHARGE_ALLOCS THEN
3024: o_err_num := 30007;
3025: o_err_code := SQLCODE;
3026: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_CHARGE_ALLOCS');
3022: o_err_msg := FND_MESSAGE.Get;
3023: WHEN CST_FAIL_GET_CHARGE_ALLOCS THEN
3024: o_err_num := 30007;
3025: o_err_code := SQLCODE;
3026: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_CHARGE_ALLOCS');
3027: o_err_msg := FND_MESSAGE.Get;
3028: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3029: WHEN CST_FAIL_COMPUTE_ACQ_COST THEN
3030: o_err_num := 30008;
3023: WHEN CST_FAIL_GET_CHARGE_ALLOCS THEN
3024: o_err_num := 30007;
3025: o_err_code := SQLCODE;
3026: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_CHARGE_ALLOCS');
3027: o_err_msg := FND_MESSAGE.Get;
3028: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3029: WHEN CST_FAIL_COMPUTE_ACQ_COST THEN
3030: o_err_num := 30008;
3031: o_err_code := SQLCODE;
3028: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3029: WHEN CST_FAIL_COMPUTE_ACQ_COST THEN
3030: o_err_num := 30008;
3031: o_err_code := SQLCODE;
3032: FND_MESSAGE.set_name('BOM', 'CST_FAIL_COMPUTE_ACQ_COST');
3033: o_err_msg := FND_MESSAGE.Get;
3034: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3035: WHEN CST_FAIL_ACQ_HOOK THEN
3036: o_err_num := 30004;
3029: WHEN CST_FAIL_COMPUTE_ACQ_COST THEN
3030: o_err_num := 30008;
3031: o_err_code := SQLCODE;
3032: FND_MESSAGE.set_name('BOM', 'CST_FAIL_COMPUTE_ACQ_COST');
3033: o_err_msg := FND_MESSAGE.Get;
3034: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3035: WHEN CST_FAIL_ACQ_HOOK THEN
3036: o_err_num := 30004;
3037: o_err_code := SQLCODE;
3034: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3035: WHEN CST_FAIL_ACQ_HOOK THEN
3036: o_err_num := 30004;
3037: o_err_code := SQLCODE;
3038: FND_MESSAGE.set_name('BOM', 'CST_FAIL_ACQ_HOOK');
3039: o_err_msg := FND_MESSAGE.Get;
3040: WHEN CST_FAIL_LCM_HOOK THEN
3041: o_err_num := 30015;
3042: o_err_code := SQLCODE;
3035: WHEN CST_FAIL_ACQ_HOOK THEN
3036: o_err_num := 30004;
3037: o_err_code := SQLCODE;
3038: FND_MESSAGE.set_name('BOM', 'CST_FAIL_ACQ_HOOK');
3039: o_err_msg := FND_MESSAGE.Get;
3040: WHEN CST_FAIL_LCM_HOOK THEN
3041: o_err_num := 30015;
3042: o_err_code := SQLCODE;
3043: FND_MESSAGE.set_name('BOM', 'CST_FAIL_LCM_HOOK');
3039: o_err_msg := FND_MESSAGE.Get;
3040: WHEN CST_FAIL_LCM_HOOK THEN
3041: o_err_num := 30015;
3042: o_err_code := SQLCODE;
3043: FND_MESSAGE.set_name('BOM', 'CST_FAIL_LCM_HOOK');
3044: o_err_msg := FND_MESSAGE.Get;
3045: WHEN CST_ACQ_NULL_RATE THEN
3046: o_err_num := 30010;
3047: o_err_code := SQLCODE;
3040: WHEN CST_FAIL_LCM_HOOK THEN
3041: o_err_num := 30015;
3042: o_err_code := SQLCODE;
3043: FND_MESSAGE.set_name('BOM', 'CST_FAIL_LCM_HOOK');
3044: o_err_msg := FND_MESSAGE.Get;
3045: WHEN CST_ACQ_NULL_RATE THEN
3046: o_err_num := 30010;
3047: o_err_code := SQLCODE;
3048: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_RATE');
3044: o_err_msg := FND_MESSAGE.Get;
3045: WHEN CST_ACQ_NULL_RATE THEN
3046: o_err_num := 30010;
3047: o_err_code := SQLCODE;
3048: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_RATE');
3049: o_err_msg := FND_MESSAGE.Get;
3050: WHEN CST_ACQ_NULL_TAX THEN
3051: o_err_num := 30011;
3052: o_err_code := SQLCODE;
3045: WHEN CST_ACQ_NULL_RATE THEN
3046: o_err_num := 30010;
3047: o_err_code := SQLCODE;
3048: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_RATE');
3049: o_err_msg := FND_MESSAGE.Get;
3050: WHEN CST_ACQ_NULL_TAX THEN
3051: o_err_num := 30011;
3052: o_err_code := SQLCODE;
3053: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_TAX');
3049: o_err_msg := FND_MESSAGE.Get;
3050: WHEN CST_ACQ_NULL_TAX THEN
3051: o_err_num := 30011;
3052: o_err_code := SQLCODE;
3053: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_TAX');
3054: o_err_msg := FND_MESSAGE.Get;
3055: WHEN PROCESS_ERROR THEN
3056: o_err_num := l_err_num;
3057: o_err_code := l_err_code;
3050: WHEN CST_ACQ_NULL_TAX THEN
3051: o_err_num := 30011;
3052: o_err_code := SQLCODE;
3053: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_TAX');
3054: o_err_msg := FND_MESSAGE.Get;
3055: WHEN PROCESS_ERROR THEN
3056: o_err_num := l_err_num;
3057: o_err_code := l_err_code;
3058: o_err_msg := l_err_msg;
3929: EXCEPTION
3930: WHEN CST_NULL_ACQ_COST THEN
3931: o_err_num := 30014;
3932: o_err_code := SQLCODE;
3933: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
3934: o_err_msg := FND_MESSAGE.Get;
3935: WHEN OTHERS THEN
3936: o_err_num := 30002;
3937: o_err_code := SQLCODE;
3930: WHEN CST_NULL_ACQ_COST THEN
3931: o_err_num := 30014;
3932: o_err_code := SQLCODE;
3933: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
3934: o_err_msg := FND_MESSAGE.Get;
3935: WHEN OTHERS THEN
3936: o_err_num := 30002;
3937: o_err_code := SQLCODE;
3938: o_err_msg := SUBSTR('CSTPPACQ.compute_acq_cost('
4483: EXCEPTION
4484: WHEN CST_NULL_ACQ_COST THEN
4485: o_err_num := 30014;
4486: o_err_code := SQLCODE;
4487: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4488: o_err_msg := FND_MESSAGE.Get;
4489: WHEN OTHERS THEN
4490: o_err_num := 30002;
4491: o_err_code := SQLCODE;
4484: WHEN CST_NULL_ACQ_COST THEN
4485: o_err_num := 30014;
4486: o_err_code := SQLCODE;
4487: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4488: o_err_msg := FND_MESSAGE.Get;
4489: WHEN OTHERS THEN
4490: o_err_num := 30002;
4491: o_err_code := SQLCODE;
4492: o_err_msg := SUBSTR('CSTPPACQ.compute_acq_cost_adj('
4731:
4732: WHEN CST_FAIL_MMT_TXN THEN
4733: o_err_num := 30011;
4734: o_err_code := SQLCODE;
4735: FND_MESSAGE.set_name('BOM', 'CST_FAIL_MMT_TXN');
4736: o_err_msg := FND_MESSAGE.Get;
4737:
4738: WHEN CST_FAIL_WIP_TXN THEN
4739: o_err_num := 30012;
4732: WHEN CST_FAIL_MMT_TXN THEN
4733: o_err_num := 30011;
4734: o_err_code := SQLCODE;
4735: FND_MESSAGE.set_name('BOM', 'CST_FAIL_MMT_TXN');
4736: o_err_msg := FND_MESSAGE.Get;
4737:
4738: WHEN CST_FAIL_WIP_TXN THEN
4739: o_err_num := 30012;
4740: o_err_code := SQLCODE;
4737:
4738: WHEN CST_FAIL_WIP_TXN THEN
4739: o_err_num := 30012;
4740: o_err_code := SQLCODE;
4741: FND_MESSAGE.set_name('BOM', 'CST_FAIL_WIP_TXN');
4742: o_err_msg := FND_MESSAGE.Get;
4743:
4744: WHEN CST_NO_ACQ_COST THEN
4745: o_err_num := 30013;
4738: WHEN CST_FAIL_WIP_TXN THEN
4739: o_err_num := 30012;
4740: o_err_code := SQLCODE;
4741: FND_MESSAGE.set_name('BOM', 'CST_FAIL_WIP_TXN');
4742: o_err_msg := FND_MESSAGE.Get;
4743:
4744: WHEN CST_NO_ACQ_COST THEN
4745: o_err_num := 30013;
4746: o_err_code := SQLCODE;
4743:
4744: WHEN CST_NO_ACQ_COST THEN
4745: o_err_num := 30013;
4746: o_err_code := SQLCODE;
4747: FND_MESSAGE.set_name('BOM', 'CST_NO_ACQ_COST');
4748: o_err_msg := FND_MESSAGE.Get;
4749:
4750: WHEN CST_NULL_ACQ_COST THEN
4751: o_err_num := 30014;
4744: WHEN CST_NO_ACQ_COST THEN
4745: o_err_num := 30013;
4746: o_err_code := SQLCODE;
4747: FND_MESSAGE.set_name('BOM', 'CST_NO_ACQ_COST');
4748: o_err_msg := FND_MESSAGE.Get;
4749:
4750: WHEN CST_NULL_ACQ_COST THEN
4751: o_err_num := 30014;
4752: o_err_code := SQLCODE;
4749:
4750: WHEN CST_NULL_ACQ_COST THEN
4751: o_err_num := 30014;
4752: o_err_code := SQLCODE;
4753: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4754: o_err_msg := FND_MESSAGE.Get;
4755:
4756: WHEN OTHERS THEN
4757: o_err_num := 30003;
4750: WHEN CST_NULL_ACQ_COST THEN
4751: o_err_num := 30014;
4752: o_err_code := SQLCODE;
4753: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4754: o_err_msg := FND_MESSAGE.Get;
4755:
4756: WHEN OTHERS THEN
4757: o_err_num := 30003;
4758: o_err_code := SQLCODE;