3098: EXCEPTION
3099: WHEN CST_FAIL_GET_NQR THEN
3100: o_err_num := 30005;
3101: o_err_code := SQLCODE;
3102: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_NQR');
3103: o_err_msg := FND_MESSAGE.Get;
3104: WHEN CST_FAIL_GET_CHARGE_ALLOCS THEN
3105: o_err_num := 30007;
3106: o_err_code := SQLCODE;
3099: WHEN CST_FAIL_GET_NQR THEN
3100: o_err_num := 30005;
3101: o_err_code := SQLCODE;
3102: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_NQR');
3103: o_err_msg := FND_MESSAGE.Get;
3104: WHEN CST_FAIL_GET_CHARGE_ALLOCS THEN
3105: o_err_num := 30007;
3106: o_err_code := SQLCODE;
3107: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_CHARGE_ALLOCS');
3103: o_err_msg := FND_MESSAGE.Get;
3104: WHEN CST_FAIL_GET_CHARGE_ALLOCS THEN
3105: o_err_num := 30007;
3106: o_err_code := SQLCODE;
3107: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_CHARGE_ALLOCS');
3108: o_err_msg := FND_MESSAGE.Get;
3109: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3110: WHEN CST_FAIL_COMPUTE_ACQ_COST THEN
3111: o_err_num := 30008;
3104: WHEN CST_FAIL_GET_CHARGE_ALLOCS THEN
3105: o_err_num := 30007;
3106: o_err_code := SQLCODE;
3107: FND_MESSAGE.set_name('BOM', 'CST_FAIL_GET_CHARGE_ALLOCS');
3108: o_err_msg := FND_MESSAGE.Get;
3109: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3110: WHEN CST_FAIL_COMPUTE_ACQ_COST THEN
3111: o_err_num := 30008;
3112: o_err_code := SQLCODE;
3109: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3110: WHEN CST_FAIL_COMPUTE_ACQ_COST THEN
3111: o_err_num := 30008;
3112: o_err_code := SQLCODE;
3113: FND_MESSAGE.set_name('BOM', 'CST_FAIL_COMPUTE_ACQ_COST');
3114: o_err_msg := FND_MESSAGE.Get;
3115: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3116: WHEN CST_FAIL_ACQ_HOOK THEN
3117: o_err_num := 30004;
3110: WHEN CST_FAIL_COMPUTE_ACQ_COST THEN
3111: o_err_num := 30008;
3112: o_err_code := SQLCODE;
3113: FND_MESSAGE.set_name('BOM', 'CST_FAIL_COMPUTE_ACQ_COST');
3114: o_err_msg := FND_MESSAGE.Get;
3115: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3116: WHEN CST_FAIL_ACQ_HOOK THEN
3117: o_err_num := 30004;
3118: o_err_code := SQLCODE;
3115: o_err_msg := l_err_msg||' : ' ||o_err_msg;
3116: WHEN CST_FAIL_ACQ_HOOK THEN
3117: o_err_num := 30004;
3118: o_err_code := SQLCODE;
3119: FND_MESSAGE.set_name('BOM', 'CST_FAIL_ACQ_HOOK');
3120: o_err_msg := FND_MESSAGE.Get;
3121: WHEN CST_FAIL_LCM_HOOK THEN
3122: o_err_num := 30015;
3123: o_err_code := SQLCODE;
3116: WHEN CST_FAIL_ACQ_HOOK THEN
3117: o_err_num := 30004;
3118: o_err_code := SQLCODE;
3119: FND_MESSAGE.set_name('BOM', 'CST_FAIL_ACQ_HOOK');
3120: o_err_msg := FND_MESSAGE.Get;
3121: WHEN CST_FAIL_LCM_HOOK THEN
3122: o_err_num := 30015;
3123: o_err_code := SQLCODE;
3124: FND_MESSAGE.set_name('BOM', 'CST_FAIL_LCM_HOOK');
3120: o_err_msg := FND_MESSAGE.Get;
3121: WHEN CST_FAIL_LCM_HOOK THEN
3122: o_err_num := 30015;
3123: o_err_code := SQLCODE;
3124: FND_MESSAGE.set_name('BOM', 'CST_FAIL_LCM_HOOK');
3125: o_err_msg := FND_MESSAGE.Get;
3126: WHEN CST_ACQ_NULL_RATE THEN
3127: o_err_num := 30010;
3128: o_err_code := SQLCODE;
3121: WHEN CST_FAIL_LCM_HOOK THEN
3122: o_err_num := 30015;
3123: o_err_code := SQLCODE;
3124: FND_MESSAGE.set_name('BOM', 'CST_FAIL_LCM_HOOK');
3125: o_err_msg := FND_MESSAGE.Get;
3126: WHEN CST_ACQ_NULL_RATE THEN
3127: o_err_num := 30010;
3128: o_err_code := SQLCODE;
3129: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_RATE');
3125: o_err_msg := FND_MESSAGE.Get;
3126: WHEN CST_ACQ_NULL_RATE THEN
3127: o_err_num := 30010;
3128: o_err_code := SQLCODE;
3129: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_RATE');
3130: o_err_msg := FND_MESSAGE.Get;
3131: WHEN CST_ACQ_NULL_TAX THEN
3132: o_err_num := 30011;
3133: o_err_code := SQLCODE;
3126: WHEN CST_ACQ_NULL_RATE THEN
3127: o_err_num := 30010;
3128: o_err_code := SQLCODE;
3129: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_RATE');
3130: o_err_msg := FND_MESSAGE.Get;
3131: WHEN CST_ACQ_NULL_TAX THEN
3132: o_err_num := 30011;
3133: o_err_code := SQLCODE;
3134: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_TAX');
3130: o_err_msg := FND_MESSAGE.Get;
3131: WHEN CST_ACQ_NULL_TAX THEN
3132: o_err_num := 30011;
3133: o_err_code := SQLCODE;
3134: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_TAX');
3135: o_err_msg := FND_MESSAGE.Get;
3136: WHEN PROCESS_ERROR THEN
3137: o_err_num := l_err_num;
3138: o_err_code := l_err_code;
3131: WHEN CST_ACQ_NULL_TAX THEN
3132: o_err_num := 30011;
3133: o_err_code := SQLCODE;
3134: FND_MESSAGE.set_name('BOM', 'CST_ACQ_NULL_TAX');
3135: o_err_msg := FND_MESSAGE.Get;
3136: WHEN PROCESS_ERROR THEN
3137: o_err_num := l_err_num;
3138: o_err_code := l_err_code;
3139: o_err_msg := l_err_msg;
4012: EXCEPTION
4013: WHEN CST_NULL_ACQ_COST THEN
4014: o_err_num := 30014;
4015: o_err_code := SQLCODE;
4016: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4017: o_err_msg := FND_MESSAGE.Get;
4018: WHEN OTHERS THEN
4019: o_err_num := 30002;
4020: o_err_code := SQLCODE;
4013: WHEN CST_NULL_ACQ_COST THEN
4014: o_err_num := 30014;
4015: o_err_code := SQLCODE;
4016: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4017: o_err_msg := FND_MESSAGE.Get;
4018: WHEN OTHERS THEN
4019: o_err_num := 30002;
4020: o_err_code := SQLCODE;
4021: o_err_msg := SUBSTR('CSTPPACQ.compute_acq_cost('
4624: EXCEPTION
4625: WHEN CST_NULL_ACQ_COST THEN
4626: o_err_num := 30014;
4627: o_err_code := SQLCODE;
4628: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4629: o_err_msg := FND_MESSAGE.Get;
4630: WHEN PROCESS_ERROR THEN
4631: o_err_num := l_err_num;
4632: o_err_code := l_err_code;
4625: WHEN CST_NULL_ACQ_COST THEN
4626: o_err_num := 30014;
4627: o_err_code := SQLCODE;
4628: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4629: o_err_msg := FND_MESSAGE.Get;
4630: WHEN PROCESS_ERROR THEN
4631: o_err_num := l_err_num;
4632: o_err_code := l_err_code;
4633: o_err_msg := l_err_msg;
4876:
4877: WHEN CST_FAIL_MMT_TXN THEN
4878: o_err_num := 30011;
4879: o_err_code := SQLCODE;
4880: FND_MESSAGE.set_name('BOM', 'CST_FAIL_MMT_TXN');
4881: o_err_msg := FND_MESSAGE.Get;
4882:
4883: WHEN CST_FAIL_WIP_TXN THEN
4884: o_err_num := 30012;
4877: WHEN CST_FAIL_MMT_TXN THEN
4878: o_err_num := 30011;
4879: o_err_code := SQLCODE;
4880: FND_MESSAGE.set_name('BOM', 'CST_FAIL_MMT_TXN');
4881: o_err_msg := FND_MESSAGE.Get;
4882:
4883: WHEN CST_FAIL_WIP_TXN THEN
4884: o_err_num := 30012;
4885: o_err_code := SQLCODE;
4882:
4883: WHEN CST_FAIL_WIP_TXN THEN
4884: o_err_num := 30012;
4885: o_err_code := SQLCODE;
4886: FND_MESSAGE.set_name('BOM', 'CST_FAIL_WIP_TXN');
4887: o_err_msg := FND_MESSAGE.Get;
4888:
4889: WHEN CST_NO_ACQ_COST THEN
4890: o_err_num := 30013;
4883: WHEN CST_FAIL_WIP_TXN THEN
4884: o_err_num := 30012;
4885: o_err_code := SQLCODE;
4886: FND_MESSAGE.set_name('BOM', 'CST_FAIL_WIP_TXN');
4887: o_err_msg := FND_MESSAGE.Get;
4888:
4889: WHEN CST_NO_ACQ_COST THEN
4890: o_err_num := 30013;
4891: o_err_code := SQLCODE;
4888:
4889: WHEN CST_NO_ACQ_COST THEN
4890: o_err_num := 30013;
4891: o_err_code := SQLCODE;
4892: FND_MESSAGE.set_name('BOM', 'CST_NO_ACQ_COST');
4893: o_err_msg := FND_MESSAGE.Get;
4894:
4895: WHEN CST_NULL_ACQ_COST THEN
4896: o_err_num := 30014;
4889: WHEN CST_NO_ACQ_COST THEN
4890: o_err_num := 30013;
4891: o_err_code := SQLCODE;
4892: FND_MESSAGE.set_name('BOM', 'CST_NO_ACQ_COST');
4893: o_err_msg := FND_MESSAGE.Get;
4894:
4895: WHEN CST_NULL_ACQ_COST THEN
4896: o_err_num := 30014;
4897: o_err_code := SQLCODE;
4894:
4895: WHEN CST_NULL_ACQ_COST THEN
4896: o_err_num := 30014;
4897: o_err_code := SQLCODE;
4898: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4899: o_err_msg := FND_MESSAGE.Get;
4900:
4901: WHEN OTHERS THEN
4902: o_err_num := 30003;
4895: WHEN CST_NULL_ACQ_COST THEN
4896: o_err_num := 30014;
4897: o_err_code := SQLCODE;
4898: FND_MESSAGE.set_name('BOM', 'CST_NULL_ACQ_COST');
4899: o_err_msg := FND_MESSAGE.Get;
4900:
4901: WHEN OTHERS THEN
4902: o_err_num := 30003;
4903: o_err_code := SQLCODE;