30:
31: BEGIN
32:
33: IF (NVL(p_param_value,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
34: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
35: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
36: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
37: FND_MSG_PUB.Add;
38: RAISE FND_API.G_EXC_ERROR;
31: BEGIN
32:
33: IF (NVL(p_param_value,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
34: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
35: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
36: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
37: FND_MSG_PUB.Add;
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
32:
33: IF (NVL(p_param_value,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
34: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
35: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
36: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
37: FND_MSG_PUB.Add;
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
40:
49:
50: BEGIN
51:
52: IF (NVL(p_param_value,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
53: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
54: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
55: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
56: FND_MSG_PUB.Add;
57: RAISE FND_API.G_EXC_ERROR;
50: BEGIN
51:
52: IF (NVL(p_param_value,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
53: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
54: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
55: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
56: FND_MSG_PUB.Add;
57: RAISE FND_API.G_EXC_ERROR;
58: END IF;
51:
52: IF (NVL(p_param_value,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
53: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
54: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
55: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
56: FND_MSG_PUB.Add;
57: RAISE FND_API.G_EXC_ERROR;
58: END IF;
59:
68:
69: BEGIN
70:
71: IF (NVL(p_param_value,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
72: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
73: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
74: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
75: FND_MSG_PUB.Add;
76: RAISE FND_API.G_EXC_ERROR;
69: BEGIN
70:
71: IF (NVL(p_param_value,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
72: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
73: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
74: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
75: FND_MSG_PUB.Add;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
70:
71: IF (NVL(p_param_value,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
72: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
73: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
74: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
75: FND_MSG_PUB.Add;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
78:
93: and ctbt.txn_billing_type_id = p_txn_billing_type_id;
94: Return l_no_chg_flag;
95: Exception
96: When No_data_found then
97: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
98: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: When Others then
94: Return l_no_chg_flag;
95: Exception
96: When No_data_found then
97: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
98: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: When Others then
102: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
98: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: When Others then
102: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
103: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
104: FND_MSG_PUB.Add;
105: RAISE FND_API.G_EXC_ERROR;
106: End;
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: When Others then
102: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
103: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
104: FND_MSG_PUB.Add;
105: RAISE FND_API.G_EXC_ERROR;
106: End;
107: END Get_No_Chg_Flag;
117: BEGIN
118:
119: IF (p_api_name = 'PROCESS_CHARGE_LINES') THEN
120: IF (p_action not in ('CREATE','UPDATE','DELETE')) THEN
121: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
122: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
123: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
124: FND_MSG_PUB.Add;
125: RETURN FALSE;
118:
119: IF (p_api_name = 'PROCESS_CHARGE_LINES') THEN
120: IF (p_action not in ('CREATE','UPDATE','DELETE')) THEN
121: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
122: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
123: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
124: FND_MSG_PUB.Add;
125: RETURN FALSE;
126: ELSE
119: IF (p_api_name = 'PROCESS_CHARGE_LINES') THEN
120: IF (p_action not in ('CREATE','UPDATE','DELETE')) THEN
121: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
122: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
123: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
124: FND_MSG_PUB.Add;
125: RETURN FALSE;
126: ELSE
127: RETURN TRUE;
128: END IF;
129:
130: ELSIF (p_api_name = 'PROCESS_SALES_ORDER') THEN
131: IF (p_action not in ('CREATE','BOOK','PICK-RELEASE','SHIP')) THEN
132: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
133: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
134: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
135: FND_MSG_PUB.Add;
136: RETURN FALSE;
129:
130: ELSIF (p_api_name = 'PROCESS_SALES_ORDER') THEN
131: IF (p_action not in ('CREATE','BOOK','PICK-RELEASE','SHIP')) THEN
132: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
133: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
134: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
135: FND_MSG_PUB.Add;
136: RETURN FALSE;
137: ELSE
130: ELSIF (p_api_name = 'PROCESS_SALES_ORDER') THEN
131: IF (p_action not in ('CREATE','BOOK','PICK-RELEASE','SHIP')) THEN
132: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
133: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
134: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
135: FND_MSG_PUB.Add;
136: RETURN FALSE;
137: ELSE
138: RETURN TRUE;
163:
164: RETURN TRUE;
165: EXCEPTION
166: When NO_DATA_FOUND then
167: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_SR_ID');
168: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
169: FND_MSG_PUB.Add;
170: RETURN FALSE;
171: END Validate_incident_id;
164: RETURN TRUE;
165: EXCEPTION
166: When NO_DATA_FOUND then
167: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_SR_ID');
168: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
169: FND_MSG_PUB.Add;
170: RETURN FALSE;
171: END Validate_incident_id;
172:
189:
190: RETURN TRUE;
191: EXCEPTION
192: When NO_DATA_FOUND then
193: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
194: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',p_repair_type_id);
195: FND_MSG_PUB.Add;
196: RETURN FALSE;
197: END Validate_repair_type_id;
190: RETURN TRUE;
191: EXCEPTION
192: When NO_DATA_FOUND then
193: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
194: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',p_repair_type_id);
195: FND_MSG_PUB.Add;
196: RETURN FALSE;
197: END Validate_repair_type_id;
198:
213:
214: RETURN TRUE;
215: EXCEPTION
216: When NO_DATA_FOUND then
217: FND_MESSAGE.SET_NAME('CSD','CSD_API_WIP_ENTITY_ID');
218: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',p_wip_entity_id);
219: FND_MSG_PUB.Add;
220: RETURN FALSE;
221: END Validate_wip_entity_id;
214: RETURN TRUE;
215: EXCEPTION
216: When NO_DATA_FOUND then
217: FND_MESSAGE.SET_NAME('CSD','CSD_API_WIP_ENTITY_ID');
218: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',p_wip_entity_id);
219: FND_MSG_PUB.Add;
220: RETURN FALSE;
221: END Validate_wip_entity_id;
222:
237:
238: RETURN TRUE;
239: EXCEPTION
240: When NO_DATA_FOUND then
241: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_GROUP_ID');
242: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);
243: FND_MSG_PUB.Add;
244: RETURN FALSE;
245: END Validate_repair_group_id;
238: RETURN TRUE;
239: EXCEPTION
240: When NO_DATA_FOUND then
241: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_GROUP_ID');
242: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);
243: FND_MSG_PUB.Add;
244: RETURN FALSE;
245: END Validate_repair_group_id;
246:
261:
262: RETURN TRUE;
263: EXCEPTION
264: When NO_DATA_FOUND then
265: FND_MESSAGE.SET_NAME('CSD','CSD_API_NOT_BOM_DATE');
266: FND_MESSAGE.SET_TOKEN('DATE',p_date);
267: FND_MSG_PUB.Add;
268: RETURN FALSE;
269: When TOO_MANY_ROWS then
262: RETURN TRUE;
263: EXCEPTION
264: When NO_DATA_FOUND then
265: FND_MESSAGE.SET_NAME('CSD','CSD_API_NOT_BOM_DATE');
266: FND_MESSAGE.SET_TOKEN('DATE',p_date);
267: FND_MSG_PUB.Add;
268: RETURN FALSE;
269: When TOO_MANY_ROWS then
270: RETURN TRUE;
293:
294: RETURN TRUE;
295: EXCEPTION
296: When NO_DATA_FOUND then
297: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
298: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
299: FND_MSG_PUB.Add;
300: RETURN FALSE;
301: END Validate_inventory_item_id;
294: RETURN TRUE;
295: EXCEPTION
296: When NO_DATA_FOUND then
297: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
298: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
299: FND_MSG_PUB.Add;
300: RETURN FALSE;
301: END Validate_inventory_item_id;
302:
320:
321: RETURN TRUE;
322: EXCEPTION
323: When NO_DATA_FOUND then
324: FND_MESSAGE.SET_NAME('CSD','CSD_API_UOM');
325: FND_MESSAGE.SET_TOKEN('UNIT_OF_MEASURE',p_unit_of_measure);
326: FND_MSG_PUB.Add;
327: END Validate_Unit_of_measure;
328:
321: RETURN TRUE;
322: EXCEPTION
323: When NO_DATA_FOUND then
324: FND_MESSAGE.SET_NAME('CSD','CSD_API_UOM');
325: FND_MESSAGE.SET_TOKEN('UNIT_OF_MEASURE',p_unit_of_measure);
326: FND_MSG_PUB.Add;
327: END Validate_Unit_of_measure;
328:
329:
527: and ((date_closed is null) OR (date_closed > sysdate));
528: EXCEPTION
529: WHEN NO_DATA_FOUND THEN
530: x_return_status := FND_API.G_RET_STS_ERROR ;
531: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
532: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
533: FND_MSG_PUB.Add;
534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_ERROR ;
528: EXCEPTION
529: WHEN NO_DATA_FOUND THEN
530: x_return_status := FND_API.G_RET_STS_ERROR ;
531: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
532: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
533: FND_MSG_PUB.Add;
534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_ERROR ;
536: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
532: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
533: FND_MSG_PUB.Add;
534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_ERROR ;
536: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
537: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
538: FND_MSG_PUB.Add;
539: END get_incident_id;
540:
533: FND_MSG_PUB.Add;
534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_ERROR ;
536: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
537: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
538: FND_MSG_PUB.Add;
539: END get_incident_id;
540:
541:
667: and sysdate between nvl(start_date_active,sysdate)
668: and nvl(end_date_active, sysdate);
669: EXCEPTION
670: When NO_DATA_FOUND then
671: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
672: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
673: FND_MSG_PUB.Add;
674: RAISE FND_API.G_EXC_ERROR;
675: End;
668: and nvl(end_date_active, sysdate);
669: EXCEPTION
670: When NO_DATA_FOUND then
671: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
672: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
673: FND_MSG_PUB.Add;
674: RAISE FND_API.G_EXC_ERROR;
675: End;
676:
693: */
694: exception
695: When No_data_found then
696: csd_gen_utility_pvt.add('No record found for p_txn_billing_type_id='||p_txn_billing_type_id);
697: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
698: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
699: FND_MSG_PUB.Add;
700: RAISE FND_API.G_EXC_ERROR;
701: When Others then
694: exception
695: When No_data_found then
696: csd_gen_utility_pvt.add('No record found for p_txn_billing_type_id='||p_txn_billing_type_id);
697: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
698: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
699: FND_MSG_PUB.Add;
700: RAISE FND_API.G_EXC_ERROR;
701: When Others then
702: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
698: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
699: FND_MSG_PUB.Add;
700: RAISE FND_API.G_EXC_ERROR;
701: When Others then
702: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
703: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
704: FND_MSG_PUB.Add;
705: RAISE FND_API.G_EXC_ERROR;
706: end;
699: FND_MSG_PUB.Add;
700: RAISE FND_API.G_EXC_ERROR;
701: When Others then
702: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
703: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
704: FND_MSG_PUB.Add;
705: RAISE FND_API.G_EXC_ERROR;
706: end;
707: END IF; /*end if l_transaction_type_id */
716:
717: If l_txn_billing_type_id is not null then
718: x_txn_billing_type_id:= l_txn_billing_type_id;
719: else
720: FND_MESSAGE.SET_NAME('CSD','CSD_INV_SERVICE_BILLING_TYPE');
721: FND_MSG_PUB.Add;
722: RAISE FND_API.G_EXC_ERROR;
723: end if;
724:
982: l_third_party_flag;
983:
984:
985: IF repair_line_dtls%notfound then
986: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
987: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
988: FND_MSG_PUB.ADD;
989: IF (g_debug > 0 ) THEN
990: csd_gen_utility_pvt.ADD('repair line Id does not exist');
983:
984:
985: IF repair_line_dtls%notfound then
986: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
987: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
988: FND_MSG_PUB.ADD;
989: IF (g_debug > 0 ) THEN
990: csd_gen_utility_pvt.ADD('repair line Id does not exist');
991: END IF;
1008: into
1009: l_contract_id;
1010:
1011: IF cur_contract_det%notfound then
1012: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
1013: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
1014: FND_MSG_PUB.ADD;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1009: l_contract_id;
1010:
1011: IF cur_contract_det%notfound then
1012: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
1013: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
1014: FND_MSG_PUB.ADD;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017:
3837: RETURN TRUE;
3838:
3839: EXCEPTION
3840: When NO_DATA_FOUND then
3841: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3842: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3843: FND_MSG_PUB.Add;
3844: RETURN FALSE;
3845: END Validate_rep_line_id;
3838:
3839: EXCEPTION
3840: When NO_DATA_FOUND then
3841: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3842: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3843: FND_MSG_PUB.Add;
3844: RETURN FALSE;
3845: END Validate_rep_line_id;
3846:
3862: RETURN TRUE;
3863:
3864: EXCEPTION
3865: When NO_DATA_FOUND then
3866: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3867: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',p_estimate_id);
3868: FND_MSG_PUB.Add;
3869: RETURN FALSE;
3870: END Validate_estimate_id;
3863:
3864: EXCEPTION
3865: When NO_DATA_FOUND then
3866: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3867: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',p_estimate_id);
3868: FND_MSG_PUB.Add;
3869: RETURN FALSE;
3870: END Validate_estimate_id;
3871:
3887: RETURN TRUE;
3888:
3889: EXCEPTION
3890: When NO_DATA_FOUND then
3891: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3892: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',p_estimate_line_id);
3893: FND_MSG_PUB.Add;
3894: RETURN FALSE;
3895: END Validate_estimate_line_id;
3888:
3889: EXCEPTION
3890: When NO_DATA_FOUND then
3891: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3892: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',p_estimate_line_id);
3893: FND_MSG_PUB.Add;
3894: RETURN FALSE;
3895: END Validate_estimate_line_id;
3896:
3907: and lookup_code = p_action_type;
3908: RETURN TRUE;
3909: EXCEPTION
3910: When NO_DATA_FOUND then
3911: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_TYPE');
3912: FND_MESSAGE.SET_TOKEN('ACTION_TYPE',p_action_type);
3913: FND_MSG_PUB.Add;
3914: RETURN FALSE;
3915: END Validate_action_type;
3908: RETURN TRUE;
3909: EXCEPTION
3910: When NO_DATA_FOUND then
3911: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_TYPE');
3912: FND_MESSAGE.SET_TOKEN('ACTION_TYPE',p_action_type);
3913: FND_MSG_PUB.Add;
3914: RETURN FALSE;
3915: END Validate_action_type;
3916:
3928: and lookup_code = p_action_code;
3929: RETURN TRUE;
3930: EXCEPTION
3931: When NO_DATA_FOUND then
3932: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_CODE');
3933: FND_MESSAGE.SET_TOKEN('ACTION_CODE',p_action_code);
3934: FND_MSG_PUB.Add;
3935: RETURN FALSE;
3936: END Validate_action_code;
3929: RETURN TRUE;
3930: EXCEPTION
3931: When NO_DATA_FOUND then
3932: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_CODE');
3933: FND_MESSAGE.SET_TOKEN('ACTION_CODE',p_action_code);
3934: FND_MSG_PUB.Add;
3935: RETURN FALSE;
3936: END Validate_action_code;
3937:
3966:
3967: RETURN l_org_id;
3968: EXCEPTION
3969: When NO_DATA_FOUND then
3970: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3971: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3972: FND_MSG_PUB.Add;
3973: RETURN -1;
3974: END get_org_id;
3967: RETURN l_org_id;
3968: EXCEPTION
3969: When NO_DATA_FOUND then
3970: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3971: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3972: FND_MSG_PUB.Add;
3973: RETURN -1;
3974: END get_org_id;
3975: */
4018:
4019: EXCEPTION
4020: When NO_DATA_FOUND then
4021:
4022: FND_MESSAGE.SET_NAME('CSD','CSD_INVALID_INCIDENT_ID');
4023: FND_MSG_PUB.Add;
4024: RETURN -1;
4025: END get_org_id;
4026:
4136: END IF;
4137:
4138: EXCEPTION
4139: When NO_DATA_FOUND then
4140: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_BUS_PROCESS');
4141: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
4142: FND_MSG_PUB.Add;
4143: RETURN -1;
4144: END get_bus_process;
4137:
4138: EXCEPTION
4139: When NO_DATA_FOUND then
4140: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_BUS_PROCESS');
4141: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
4142: FND_MSG_PUB.Add;
4143: RETURN -1;
4144: END get_bus_process;
4145:
4325: and b.org_id = p_org_id;
4326:
4327: EXCEPTION
4328: When NO_DATA_FOUND then
4329: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4330: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4331: FND_MSG_PUB.Add;
4332: x_return_status := FND_API.G_RET_STS_ERROR ;
4333: When OTHERS then
4326:
4327: EXCEPTION
4328: When NO_DATA_FOUND then
4329: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4330: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4331: FND_MSG_PUB.Add;
4332: x_return_status := FND_API.G_RET_STS_ERROR ;
4333: When OTHERS then
4334: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4330: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4331: FND_MSG_PUB.Add;
4332: x_return_status := FND_API.G_RET_STS_ERROR ;
4333: When OTHERS then
4334: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4335: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4336: FND_MSG_PUB.Add;
4337: x_return_status := FND_API.G_RET_STS_ERROR ;
4338: END get_line_type;
4331: FND_MSG_PUB.Add;
4332: x_return_status := FND_API.G_RET_STS_ERROR ;
4333: When OTHERS then
4334: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4335: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4336: FND_MSG_PUB.Add;
4337: x_return_status := FND_API.G_RET_STS_ERROR ;
4338: END get_line_type;
4339:
4377: where product_transaction_id = p_prod_txn_id;
4378: RETURN TRUE;
4379: EXCEPTION
4380: When NO_DATA_FOUND then
4381: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
4382: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4383: FND_MSG_PUB.Add;
4384: RETURN FALSE;
4385: END Validate_prod_txn_id;
4378: RETURN TRUE;
4379: EXCEPTION
4380: When NO_DATA_FOUND then
4381: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
4382: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4383: FND_MSG_PUB.Add;
4384: RETURN FALSE;
4385: END Validate_prod_txn_id;
4386:
4444: and b.product_transaction_id = p_prod_txn_id ;
4445:
4446: EXCEPTION
4447: WHEN NO_DATA_FOUND THEN
4448: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV2_PROD_TXN_ID');
4449: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4450: FND_MSG_PUB.ADD;
4451: RAISE FND_API.G_EXC_ERROR;
4452: END;
4445:
4446: EXCEPTION
4447: WHEN NO_DATA_FOUND THEN
4448: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV2_PROD_TXN_ID');
4449: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4450: FND_MSG_PUB.ADD;
4451: RAISE FND_API.G_EXC_ERROR;
4452: END;
4453: /*
4494: END IF;
4495:
4496: /************* travi comment on 030703 for Bug # 2830828 **************
4497: If nvl(l_qty_completed,0) < l_prod_txn_qty then
4498: FND_MESSAGE.SET_NAME('CSD','CSD_API_PROCESS_NOT_ALLOWED');
4499: FND_MESSAGE.SET_TOKEN('QTY_COMPLETED',l_qty_completed);
4500: FND_MSG_PUB.ADD;
4501: IF (g_debug > 0 ) THEN
4502: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty completed :'||l_qty_completed);
4495:
4496: /************* travi comment on 030703 for Bug # 2830828 **************
4497: If nvl(l_qty_completed,0) < l_prod_txn_qty then
4498: FND_MESSAGE.SET_NAME('CSD','CSD_API_PROCESS_NOT_ALLOWED');
4499: FND_MESSAGE.SET_TOKEN('QTY_COMPLETED',l_qty_completed);
4500: FND_MSG_PUB.ADD;
4501: IF (g_debug > 0 ) THEN
4502: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty completed :'||l_qty_completed);
4503: END IF;
4519: csd_gen_utility_pvt.ADD('l_count= '||l_count);
4520: END IF;
4521:
4522: IF l_count > 0 then
4523: FND_MESSAGE.SET_NAME('CSD','CSD_API_TASK_NOT_COMPLETE');
4524: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_repair_line_id);
4525: FND_MSG_PUB.ADD;
4526:
4527: IF (g_debug > 0 ) THEN
4520: END IF;
4521:
4522: IF l_count > 0 then
4523: FND_MESSAGE.SET_NAME('CSD','CSD_API_TASK_NOT_COMPLETE');
4524: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_repair_line_id);
4525: FND_MSG_PUB.ADD;
4526:
4527: IF (g_debug > 0 ) THEN
4528: csd_gen_utility_pvt.ADD('One or more of the tasks for repair line : '||l_repair_line_id||' :is not completed');
4604: END IF;
4605:
4606:
4607: IF (NVL(l_qty_by_type,0) + NVL(l_prod_txn_qty,0)) > NVL(l_repair_qty,0) THEN
4608: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_QUANTITY');
4609: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
4610: FND_MSG_PUB.ADD;
4611: IF (g_debug > 0 ) THEN
4612: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty in repair Line :'||p_repair_line_id);
4605:
4606:
4607: IF (NVL(l_qty_by_type,0) + NVL(l_prod_txn_qty,0)) > NVL(l_repair_qty,0) THEN
4608: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_QUANTITY');
4609: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
4610: FND_MSG_PUB.ADD;
4611: IF (g_debug > 0 ) THEN
4612: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty in repair Line :'||p_repair_line_id);
4613: END IF;
4650: RETURN TRUE;
4651: End if;
4652: EXCEPTION
4653: When NO_DATA_FOUND then
4654: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
4655: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
4656: FND_MSG_PUB.Add;
4657: RAISE FND_API.G_EXC_ERROR;
4658: END Is_item_serialized;
4651: End if;
4652: EXCEPTION
4653: When NO_DATA_FOUND then
4654: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
4655: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
4656: FND_MSG_PUB.Add;
4657: RAISE FND_API.G_EXC_ERROR;
4658: END Is_item_serialized;
4659:
5152:
5153: EXCEPTION
5154:
5155: WHEN others THEN
5156: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5157: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
5158: FND_MSG_PUB.Add;
5159: RAISE FND_API.G_EXC_ERROR;
5160:
5153: EXCEPTION
5154:
5155: WHEN others THEN
5156: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5157: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
5158: FND_MSG_PUB.Add;
5159: RAISE FND_API.G_EXC_ERROR;
5160:
5161: END;
5187:
5188: EXCEPTION
5189:
5190: WHEN no_data_found THEN
5191: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5192: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
5193: FND_MSG_PUB.Add;
5194: RAISE FND_API.G_EXC_ERROR;
5195:
5188: EXCEPTION
5189:
5190: WHEN no_data_found THEN
5191: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5192: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
5193: FND_MSG_PUB.Add;
5194: RAISE FND_API.G_EXC_ERROR;
5195:
5196: WHEN too_many_rows THEN
5193: FND_MSG_PUB.Add;
5194: RAISE FND_API.G_EXC_ERROR;
5195:
5196: WHEN too_many_rows THEN
5197: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5198: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
5199: FND_MSG_PUB.Add;
5200: RAISE FND_API.G_EXC_ERROR;
5201:
5194: RAISE FND_API.G_EXC_ERROR;
5195:
5196: WHEN too_many_rows THEN
5197: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5198: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
5199: FND_MSG_PUB.Add;
5200: RAISE FND_API.G_EXC_ERROR;
5201:
5202: WHEN others THEN
5199: FND_MSG_PUB.Add;
5200: RAISE FND_API.G_EXC_ERROR;
5201:
5202: WHEN others THEN
5203: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5204: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
5205: FND_MSG_PUB.Add;
5206: RAISE FND_API.G_EXC_ERROR;
5207:
5200: RAISE FND_API.G_EXC_ERROR;
5201:
5202: WHEN others THEN
5203: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
5204: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
5205: FND_MSG_PUB.Add;
5206: RAISE FND_API.G_EXC_ERROR;
5207:
5208: END;
6042: return l_currency_code;
6043:
6044: EXCEPTION
6045: WHEN NO_DATA_FOUND THEN
6046: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
6047: -- FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
6048: FND_MSG_PUB.Add;
6049: RAISE FND_API.G_EXC_ERROR;
6050: RETURN NULL;
6043:
6044: EXCEPTION
6045: WHEN NO_DATA_FOUND THEN
6046: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
6047: -- FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
6048: FND_MSG_PUB.Add;
6049: RAISE FND_API.G_EXC_ERROR;
6050: RETURN NULL;
6051:
6049: RAISE FND_API.G_EXC_ERROR;
6050: RETURN NULL;
6051:
6052: WHEN TOO_MANY_ROWS THEN
6053: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
6054: FND_MSG_PUB.Add;
6055: RAISE FND_API.G_EXC_ERROR;
6056: RETURN NULL;
6057: