DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on FND_MESSAGE

Line 26: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');

22:
23: BEGIN
24:
25: IF (NVL(p_param_value,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
26: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
27: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
28: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
29: FND_MSG_PUB.Add;
30: RAISE FND_API.G_EXC_ERROR;

Line 27: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

23: BEGIN
24:
25: IF (NVL(p_param_value,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
26: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
27: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
28: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
29: FND_MSG_PUB.Add;
30: RAISE FND_API.G_EXC_ERROR;
31: END IF;

Line 28: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);

24:
25: IF (NVL(p_param_value,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
26: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
27: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
28: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
29: FND_MSG_PUB.Add;
30: RAISE FND_API.G_EXC_ERROR;
31: END IF;
32:

Line 45: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');

41:
42: BEGIN
43:
44: IF (NVL(p_param_value,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
45: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
46: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
47: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
48: FND_MSG_PUB.Add;
49: RAISE FND_API.G_EXC_ERROR;

Line 46: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

42: BEGIN
43:
44: IF (NVL(p_param_value,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
45: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
46: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
47: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
48: FND_MSG_PUB.Add;
49: RAISE FND_API.G_EXC_ERROR;
50: END IF;

Line 47: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);

43:
44: IF (NVL(p_param_value,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
45: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
46: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
47: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
48: FND_MSG_PUB.Add;
49: RAISE FND_API.G_EXC_ERROR;
50: END IF;
51:

Line 64: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');

60:
61: BEGIN
62:
63: IF (NVL(p_param_value,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
64: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
65: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
66: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
67: FND_MSG_PUB.Add;
68: RAISE FND_API.G_EXC_ERROR;

Line 65: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

61: BEGIN
62:
63: IF (NVL(p_param_value,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
64: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
65: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
66: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
67: FND_MSG_PUB.Add;
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;

Line 66: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);

62:
63: IF (NVL(p_param_value,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
64: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
65: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
66: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
67: FND_MSG_PUB.Add;
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;
70:

Line 89: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

85: and ctbt.txn_billing_type_id = p_txn_billing_type_id;
86: Return l_no_chg_flag;
87: Exception
88: When No_data_found then
89: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
90: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
91: FND_MSG_PUB.Add;
92: RAISE FND_API.G_EXC_ERROR;
93: When Others then

Line 90: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

86: Return l_no_chg_flag;
87: Exception
88: When No_data_found then
89: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
90: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
91: FND_MSG_PUB.Add;
92: RAISE FND_API.G_EXC_ERROR;
93: When Others then
94: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

Line 94: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

90: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
91: FND_MSG_PUB.Add;
92: RAISE FND_API.G_EXC_ERROR;
93: When Others then
94: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
95: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
96: FND_MSG_PUB.Add;
97: RAISE FND_API.G_EXC_ERROR;
98: End;

Line 95: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

91: FND_MSG_PUB.Add;
92: RAISE FND_API.G_EXC_ERROR;
93: When Others then
94: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
95: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
96: FND_MSG_PUB.Add;
97: RAISE FND_API.G_EXC_ERROR;
98: End;
99: END Get_No_Chg_Flag;

Line 113: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');

109: BEGIN
110:
111: IF (p_api_name = 'PROCESS_CHARGE_LINES') THEN
112: IF (p_action not in ('CREATE','UPDATE','DELETE')) THEN
113: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
114: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
115: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
116: FND_MSG_PUB.Add;
117: RETURN FALSE;

Line 114: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

110:
111: IF (p_api_name = 'PROCESS_CHARGE_LINES') THEN
112: IF (p_action not in ('CREATE','UPDATE','DELETE')) THEN
113: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
114: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
115: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
116: FND_MSG_PUB.Add;
117: RETURN FALSE;
118: ELSE

Line 115: FND_MESSAGE.SET_TOKEN('ACTION',p_action);

111: IF (p_api_name = 'PROCESS_CHARGE_LINES') THEN
112: IF (p_action not in ('CREATE','UPDATE','DELETE')) THEN
113: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
114: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
115: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
116: FND_MSG_PUB.Add;
117: RETURN FALSE;
118: ELSE
119: RETURN TRUE;

Line 124: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');

120: END IF;
121:
122: ELSIF (p_api_name = 'PROCESS_SALES_ORDER') THEN
123: IF (p_action not in ('CREATE','BOOK','PICK-RELEASE','SHIP')) THEN
124: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
125: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
126: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
127: FND_MSG_PUB.Add;
128: RETURN FALSE;

Line 125: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

121:
122: ELSIF (p_api_name = 'PROCESS_SALES_ORDER') THEN
123: IF (p_action not in ('CREATE','BOOK','PICK-RELEASE','SHIP')) THEN
124: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
125: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
126: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
127: FND_MSG_PUB.Add;
128: RETURN FALSE;
129: ELSE

Line 126: FND_MESSAGE.SET_TOKEN('ACTION',p_action);

122: ELSIF (p_api_name = 'PROCESS_SALES_ORDER') THEN
123: IF (p_action not in ('CREATE','BOOK','PICK-RELEASE','SHIP')) THEN
124: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION');
125: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
126: FND_MESSAGE.SET_TOKEN('ACTION',p_action);
127: FND_MSG_PUB.Add;
128: RETURN FALSE;
129: ELSE
130: RETURN TRUE;

Line 159: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_SR_ID');

155:
156: RETURN TRUE;
157: EXCEPTION
158: When NO_DATA_FOUND then
159: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_SR_ID');
160: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
161: FND_MSG_PUB.Add;
162: RETURN FALSE;
163: END Validate_incident_id;

Line 160: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);

156: RETURN TRUE;
157: EXCEPTION
158: When NO_DATA_FOUND then
159: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_SR_ID');
160: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
161: FND_MSG_PUB.Add;
162: RETURN FALSE;
163: END Validate_incident_id;
164:

Line 185: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');

181:
182: RETURN TRUE;
183: EXCEPTION
184: When NO_DATA_FOUND then
185: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
186: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',p_repair_type_id);
187: FND_MSG_PUB.Add;
188: RETURN FALSE;
189: END Validate_repair_type_id;

Line 186: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',p_repair_type_id);

182: RETURN TRUE;
183: EXCEPTION
184: When NO_DATA_FOUND then
185: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
186: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',p_repair_type_id);
187: FND_MSG_PUB.Add;
188: RETURN FALSE;
189: END Validate_repair_type_id;
190:

Line 209: FND_MESSAGE.SET_NAME('CSD','CSD_API_WIP_ENTITY_ID');

205:
206: RETURN TRUE;
207: EXCEPTION
208: When NO_DATA_FOUND then
209: FND_MESSAGE.SET_NAME('CSD','CSD_API_WIP_ENTITY_ID');
210: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',p_wip_entity_id);
211: FND_MSG_PUB.Add;
212: RETURN FALSE;
213: END Validate_wip_entity_id;

Line 210: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',p_wip_entity_id);

206: RETURN TRUE;
207: EXCEPTION
208: When NO_DATA_FOUND then
209: FND_MESSAGE.SET_NAME('CSD','CSD_API_WIP_ENTITY_ID');
210: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',p_wip_entity_id);
211: FND_MSG_PUB.Add;
212: RETURN FALSE;
213: END Validate_wip_entity_id;
214:

Line 233: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_GROUP_ID');

229:
230: RETURN TRUE;
231: EXCEPTION
232: When NO_DATA_FOUND then
233: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_GROUP_ID');
234: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);
235: FND_MSG_PUB.Add;
236: RETURN FALSE;
237: END Validate_repair_group_id;

Line 234: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);

230: RETURN TRUE;
231: EXCEPTION
232: When NO_DATA_FOUND then
233: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_GROUP_ID');
234: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_repair_group_id);
235: FND_MSG_PUB.Add;
236: RETURN FALSE;
237: END Validate_repair_group_id;
238:

Line 257: FND_MESSAGE.SET_NAME('CSD','CSD_API_NOT_BOM_DATE');

253:
254: RETURN TRUE;
255: EXCEPTION
256: When NO_DATA_FOUND then
257: FND_MESSAGE.SET_NAME('CSD','CSD_API_NOT_BOM_DATE');
258: FND_MESSAGE.SET_TOKEN('DATE',p_date);
259: FND_MSG_PUB.Add;
260: RETURN FALSE;
261: When TOO_MANY_ROWS then

Line 258: FND_MESSAGE.SET_TOKEN('DATE',p_date);

254: RETURN TRUE;
255: EXCEPTION
256: When NO_DATA_FOUND then
257: FND_MESSAGE.SET_NAME('CSD','CSD_API_NOT_BOM_DATE');
258: FND_MESSAGE.SET_TOKEN('DATE',p_date);
259: FND_MSG_PUB.Add;
260: RETURN FALSE;
261: When TOO_MANY_ROWS then
262: RETURN TRUE;

Line 289: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');

285:
286: RETURN TRUE;
287: EXCEPTION
288: When NO_DATA_FOUND then
289: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
290: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
291: FND_MSG_PUB.Add;
292: RETURN FALSE;
293: END Validate_inventory_item_id;

Line 290: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);

286: RETURN TRUE;
287: EXCEPTION
288: When NO_DATA_FOUND then
289: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
290: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
291: FND_MSG_PUB.Add;
292: RETURN FALSE;
293: END Validate_inventory_item_id;
294:

Line 316: FND_MESSAGE.SET_NAME('CSD','CSD_API_UOM');

312:
313: RETURN TRUE;
314: EXCEPTION
315: When NO_DATA_FOUND then
316: FND_MESSAGE.SET_NAME('CSD','CSD_API_UOM');
317: FND_MESSAGE.SET_TOKEN('UNIT_OF_MEASURE',p_unit_of_measure);
318: FND_MSG_PUB.Add;
319: END Validate_Unit_of_measure;
320:

Line 317: FND_MESSAGE.SET_TOKEN('UNIT_OF_MEASURE',p_unit_of_measure);

313: RETURN TRUE;
314: EXCEPTION
315: When NO_DATA_FOUND then
316: FND_MESSAGE.SET_NAME('CSD','CSD_API_UOM');
317: FND_MESSAGE.SET_TOKEN('UNIT_OF_MEASURE',p_unit_of_measure);
318: FND_MSG_PUB.Add;
319: END Validate_Unit_of_measure;
320:
321:

Line 523: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');

519: and ((date_closed is null) OR (date_closed > sysdate));
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN
522: x_return_status := FND_API.G_RET_STS_ERROR ;
523: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
524: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
525: FND_MSG_PUB.Add;
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 524: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN
522: x_return_status := FND_API.G_RET_STS_ERROR ;
523: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
524: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
525: FND_MSG_PUB.Add;
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_ERROR ;
528: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');

Line 528: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');

524: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
525: FND_MSG_PUB.Add;
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_ERROR ;
528: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
529: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
530: FND_MSG_PUB.Add;
531: END get_incident_id;
532:

Line 529: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

525: FND_MSG_PUB.Add;
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_ERROR ;
528: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
529: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
530: FND_MSG_PUB.Add;
531: END get_incident_id;
532:
533:

Line 663: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');

659: and sysdate between nvl(start_date_active,sysdate)
660: and nvl(end_date_active, sysdate);
661: EXCEPTION
662: When NO_DATA_FOUND then
663: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
664: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
665: FND_MSG_PUB.Add;
666: RAISE FND_API.G_EXC_ERROR;
667: End;

Line 664: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);

660: and nvl(end_date_active, sysdate);
661: EXCEPTION
662: When NO_DATA_FOUND then
663: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
664: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inventory_item_id);
665: FND_MSG_PUB.Add;
666: RAISE FND_API.G_EXC_ERROR;
667: End;
668:

Line 689: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

685: */
686: exception
687: When No_data_found then
688: csd_gen_utility_pvt.add('No record found for p_txn_billing_type_id='||p_txn_billing_type_id);
689: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
690: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
691: FND_MSG_PUB.Add;
692: RAISE FND_API.G_EXC_ERROR;
693: When Others then

Line 690: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

686: exception
687: When No_data_found then
688: csd_gen_utility_pvt.add('No record found for p_txn_billing_type_id='||p_txn_billing_type_id);
689: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
690: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
691: FND_MSG_PUB.Add;
692: RAISE FND_API.G_EXC_ERROR;
693: When Others then
694: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

Line 694: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

690: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
691: FND_MSG_PUB.Add;
692: RAISE FND_API.G_EXC_ERROR;
693: When Others then
694: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
695: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
696: FND_MSG_PUB.Add;
697: RAISE FND_API.G_EXC_ERROR;
698: end;

Line 695: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

691: FND_MSG_PUB.Add;
692: RAISE FND_API.G_EXC_ERROR;
693: When Others then
694: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
695: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
696: FND_MSG_PUB.Add;
697: RAISE FND_API.G_EXC_ERROR;
698: end;
699: END IF; /*end if l_transaction_type_id */

Line 712: FND_MESSAGE.SET_NAME('CSD','CSD_INV_SERVICE_BILLING_TYPE');

708:
709: If l_txn_billing_type_id is not null then
710: x_txn_billing_type_id:= l_txn_billing_type_id;
711: else
712: FND_MESSAGE.SET_NAME('CSD','CSD_INV_SERVICE_BILLING_TYPE');
713: FND_MSG_PUB.Add;
714: RAISE FND_API.G_EXC_ERROR;
715: end if;
716:

Line 961: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');

957: l_third_party_flag;
958:
959:
960: IF repair_line_dtls%notfound then
961: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
962: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
963: FND_MSG_PUB.ADD;
964: IF (g_debug > 0 ) THEN
965: csd_gen_utility_pvt.ADD('repair line Id does not exist');

Line 962: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

958:
959:
960: IF repair_line_dtls%notfound then
961: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
962: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
963: FND_MSG_PUB.ADD;
964: IF (g_debug > 0 ) THEN
965: csd_gen_utility_pvt.ADD('repair line Id does not exist');
966: END IF;

Line 987: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');

983: into
984: l_contract_id;
985:
986: IF cur_contract_det%notfound then
987: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
988: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;

Line 988: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

984: l_contract_id;
985:
986: IF cur_contract_det%notfound then
987: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
988: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992:

Line 3610: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');

3606: RETURN TRUE;
3607:
3608: EXCEPTION
3609: When NO_DATA_FOUND then
3610: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3611: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3612: FND_MSG_PUB.Add;
3613: RETURN FALSE;
3614: END Validate_rep_line_id;

Line 3611: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

3607:
3608: EXCEPTION
3609: When NO_DATA_FOUND then
3610: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3611: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3612: FND_MSG_PUB.Add;
3613: RETURN FALSE;
3614: END Validate_rep_line_id;
3615:

Line 3635: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');

3631: RETURN TRUE;
3632:
3633: EXCEPTION
3634: When NO_DATA_FOUND then
3635: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3636: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',p_estimate_id);
3637: FND_MSG_PUB.Add;
3638: RETURN FALSE;
3639: END Validate_estimate_id;

Line 3636: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',p_estimate_id);

3632:
3633: EXCEPTION
3634: When NO_DATA_FOUND then
3635: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3636: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',p_estimate_id);
3637: FND_MSG_PUB.Add;
3638: RETURN FALSE;
3639: END Validate_estimate_id;
3640:

Line 3660: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');

3656: RETURN TRUE;
3657:
3658: EXCEPTION
3659: When NO_DATA_FOUND then
3660: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3661: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',p_estimate_line_id);
3662: FND_MSG_PUB.Add;
3663: RETURN FALSE;
3664: END Validate_estimate_line_id;

Line 3661: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',p_estimate_line_id);

3657:
3658: EXCEPTION
3659: When NO_DATA_FOUND then
3660: FND_MESSAGE.SET_NAME('CSD','CSD_INV_ESTIMATE_ID');
3661: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',p_estimate_line_id);
3662: FND_MSG_PUB.Add;
3663: RETURN FALSE;
3664: END Validate_estimate_line_id;
3665:

Line 3680: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_TYPE');

3676: and lookup_code = p_action_type;
3677: RETURN TRUE;
3678: EXCEPTION
3679: When NO_DATA_FOUND then
3680: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_TYPE');
3681: FND_MESSAGE.SET_TOKEN('ACTION_TYPE',p_action_type);
3682: FND_MSG_PUB.Add;
3683: RETURN FALSE;
3684: END Validate_action_type;

Line 3681: FND_MESSAGE.SET_TOKEN('ACTION_TYPE',p_action_type);

3677: RETURN TRUE;
3678: EXCEPTION
3679: When NO_DATA_FOUND then
3680: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_TYPE');
3681: FND_MESSAGE.SET_TOKEN('ACTION_TYPE',p_action_type);
3682: FND_MSG_PUB.Add;
3683: RETURN FALSE;
3684: END Validate_action_type;
3685:

Line 3701: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_CODE');

3697: and lookup_code = p_action_code;
3698: RETURN TRUE;
3699: EXCEPTION
3700: When NO_DATA_FOUND then
3701: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_CODE');
3702: FND_MESSAGE.SET_TOKEN('ACTION_CODE',p_action_code);
3703: FND_MSG_PUB.Add;
3704: RETURN FALSE;
3705: END Validate_action_code;

Line 3702: FND_MESSAGE.SET_TOKEN('ACTION_CODE',p_action_code);

3698: RETURN TRUE;
3699: EXCEPTION
3700: When NO_DATA_FOUND then
3701: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ACTION_CODE');
3702: FND_MESSAGE.SET_TOKEN('ACTION_CODE',p_action_code);
3703: FND_MSG_PUB.Add;
3704: RETURN FALSE;
3705: END Validate_action_code;
3706:

Line 3739: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');

3735:
3736: RETURN l_org_id;
3737: EXCEPTION
3738: When NO_DATA_FOUND then
3739: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3740: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3741: FND_MSG_PUB.Add;
3742: RETURN -1;
3743: END get_org_id;

Line 3740: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

3736: RETURN l_org_id;
3737: EXCEPTION
3738: When NO_DATA_FOUND then
3739: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
3740: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3741: FND_MSG_PUB.Add;
3742: RETURN -1;
3743: END get_org_id;
3744: */

Line 3791: FND_MESSAGE.SET_NAME('CSD','CSD_INVALID_INCIDENT_ID');

3787:
3788: EXCEPTION
3789: When NO_DATA_FOUND then
3790:
3791: FND_MESSAGE.SET_NAME('CSD','CSD_INVALID_INCIDENT_ID');
3792: FND_MSG_PUB.Add;
3793: RETURN -1;
3794: END get_org_id;
3795:

Line 3909: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_BUS_PROCESS');

3905: END IF;
3906:
3907: EXCEPTION
3908: When NO_DATA_FOUND then
3909: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_BUS_PROCESS');
3910: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3911: FND_MSG_PUB.Add;
3912: RETURN -1;
3913: END get_bus_process;

Line 3910: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

3906:
3907: EXCEPTION
3908: When NO_DATA_FOUND then
3909: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_BUS_PROCESS');
3910: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
3911: FND_MSG_PUB.Add;
3912: RETURN -1;
3913: END get_bus_process;
3914:

Line 4071: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

4067: and b.org_id = p_org_id;
4068:
4069: EXCEPTION
4070: When NO_DATA_FOUND then
4071: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4072: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4073: FND_MSG_PUB.Add;
4074: x_return_status := FND_API.G_RET_STS_ERROR ;
4075: When OTHERS then

Line 4072: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

4068:
4069: EXCEPTION
4070: When NO_DATA_FOUND then
4071: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4072: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4073: FND_MSG_PUB.Add;
4074: x_return_status := FND_API.G_RET_STS_ERROR ;
4075: When OTHERS then
4076: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

Line 4076: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

4072: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4073: FND_MSG_PUB.Add;
4074: x_return_status := FND_API.G_RET_STS_ERROR ;
4075: When OTHERS then
4076: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4077: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4078: FND_MSG_PUB.Add;
4079: x_return_status := FND_API.G_RET_STS_ERROR ;
4080: END get_line_type;

Line 4077: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);

4073: FND_MSG_PUB.Add;
4074: x_return_status := FND_API.G_RET_STS_ERROR ;
4075: When OTHERS then
4076: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');
4077: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_id);
4078: FND_MSG_PUB.Add;
4079: x_return_status := FND_API.G_RET_STS_ERROR ;
4080: END get_line_type;
4081:

Line 4123: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

4119: where product_transaction_id = p_prod_txn_id;
4120: RETURN TRUE;
4121: EXCEPTION
4122: When NO_DATA_FOUND then
4123: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
4124: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4125: FND_MSG_PUB.Add;
4126: RETURN FALSE;
4127: END Validate_prod_txn_id;

Line 4124: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);

4120: RETURN TRUE;
4121: EXCEPTION
4122: When NO_DATA_FOUND then
4123: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');
4124: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4125: FND_MSG_PUB.Add;
4126: RETURN FALSE;
4127: END Validate_prod_txn_id;
4128:

Line 4190: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV2_PROD_TXN_ID');

4186: and b.product_transaction_id = p_prod_txn_id ;
4187:
4188: EXCEPTION
4189: WHEN NO_DATA_FOUND THEN
4190: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV2_PROD_TXN_ID');
4191: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_ERROR;
4194: END;

Line 4191: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);

4187:
4188: EXCEPTION
4189: WHEN NO_DATA_FOUND THEN
4190: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV2_PROD_TXN_ID');
4191: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_prod_txn_id);
4192: FND_MSG_PUB.ADD;
4193: RAISE FND_API.G_EXC_ERROR;
4194: END;
4195: /*

Line 4240: FND_MESSAGE.SET_NAME('CSD','CSD_API_PROCESS_NOT_ALLOWED');

4236: END IF;
4237:
4238: /************* travi comment on 030703 for Bug # 2830828 **************
4239: If nvl(l_qty_completed,0) < l_prod_txn_qty then
4240: FND_MESSAGE.SET_NAME('CSD','CSD_API_PROCESS_NOT_ALLOWED');
4241: FND_MESSAGE.SET_TOKEN('QTY_COMPLETED',l_qty_completed);
4242: FND_MSG_PUB.ADD;
4243: IF (g_debug > 0 ) THEN
4244: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty completed :'||l_qty_completed);

Line 4241: FND_MESSAGE.SET_TOKEN('QTY_COMPLETED',l_qty_completed);

4237:
4238: /************* travi comment on 030703 for Bug # 2830828 **************
4239: If nvl(l_qty_completed,0) < l_prod_txn_qty then
4240: FND_MESSAGE.SET_NAME('CSD','CSD_API_PROCESS_NOT_ALLOWED');
4241: FND_MESSAGE.SET_TOKEN('QTY_COMPLETED',l_qty_completed);
4242: FND_MSG_PUB.ADD;
4243: IF (g_debug > 0 ) THEN
4244: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty completed :'||l_qty_completed);
4245: END IF;

Line 4265: FND_MESSAGE.SET_NAME('CSD','CSD_API_TASK_NOT_COMPLETE');

4261: csd_gen_utility_pvt.ADD('l_count= '||l_count);
4262: END IF;
4263:
4264: IF l_count > 0 then
4265: FND_MESSAGE.SET_NAME('CSD','CSD_API_TASK_NOT_COMPLETE');
4266: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_repair_line_id);
4267: FND_MSG_PUB.ADD;
4268:
4269: IF (g_debug > 0 ) THEN

Line 4266: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_repair_line_id);

4262: END IF;
4263:
4264: IF l_count > 0 then
4265: FND_MESSAGE.SET_NAME('CSD','CSD_API_TASK_NOT_COMPLETE');
4266: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',l_repair_line_id);
4267: FND_MSG_PUB.ADD;
4268:
4269: IF (g_debug > 0 ) THEN
4270: csd_gen_utility_pvt.ADD('One or more of the tasks for repair line : '||l_repair_line_id||' :is not completed');

Line 4346: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_QUANTITY');

4342: END IF;
4343:
4344:
4345: IF (NVL(l_qty_by_type,0) + NVL(l_prod_txn_qty,0)) > NVL(l_repair_qty,0) THEN
4346: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_QUANTITY');
4347: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
4348: FND_MSG_PUB.ADD;
4349: IF (g_debug > 0 ) THEN
4350: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty in repair Line :'||p_repair_line_id);

Line 4347: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);

4343:
4344:
4345: IF (NVL(l_qty_by_type,0) + NVL(l_prod_txn_qty,0)) > NVL(l_repair_qty,0) THEN
4346: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_QUANTITY');
4347: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
4348: FND_MSG_PUB.ADD;
4349: IF (g_debug > 0 ) THEN
4350: csd_gen_utility_pvt.ADD('Prod txn qty is more than qty in repair Line :'||p_repair_line_id);
4351: END IF;

Line 4388: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');

4384: RETURN TRUE;
4385: End if;
4386: EXCEPTION
4387: When NO_DATA_FOUND then
4388: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
4389: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
4390: FND_MSG_PUB.Add;
4391: RAISE FND_API.G_EXC_ERROR;
4392: END Is_item_serialized;

Line 4389: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);

4385: End if;
4386: EXCEPTION
4387: When NO_DATA_FOUND then
4388: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_ITEM_ID');
4389: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
4390: FND_MSG_PUB.Add;
4391: RAISE FND_API.G_EXC_ERROR;
4392: END Is_item_serialized;
4393:

Line 4890: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');

4886:
4887: EXCEPTION
4888:
4889: WHEN others THEN
4890: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4891: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
4892: FND_MSG_PUB.Add;
4893: RAISE FND_API.G_EXC_ERROR;
4894:

Line 4891: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);

4887: EXCEPTION
4888:
4889: WHEN others THEN
4890: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4891: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID', p_repair_type_id);
4892: FND_MSG_PUB.Add;
4893: RAISE FND_API.G_EXC_ERROR;
4894:
4895: END;

Line 4925: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');

4921:
4922: EXCEPTION
4923:
4924: WHEN no_data_found THEN
4925: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4926: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
4927: FND_MSG_PUB.Add;
4928: RAISE FND_API.G_EXC_ERROR;
4929:

Line 4926: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);

4922: EXCEPTION
4923:
4924: WHEN no_data_found THEN
4925: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4926: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
4927: FND_MSG_PUB.Add;
4928: RAISE FND_API.G_EXC_ERROR;
4929:
4930: WHEN too_many_rows THEN

Line 4931: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');

4927: FND_MSG_PUB.Add;
4928: RAISE FND_API.G_EXC_ERROR;
4929:
4930: WHEN too_many_rows THEN
4931: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4932: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
4933: FND_MSG_PUB.Add;
4934: RAISE FND_API.G_EXC_ERROR;
4935:

Line 4932: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);

4928: RAISE FND_API.G_EXC_ERROR;
4929:
4930: WHEN too_many_rows THEN
4931: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4932: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
4933: FND_MSG_PUB.Add;
4934: RAISE FND_API.G_EXC_ERROR;
4935:
4936: WHEN others THEN

Line 4937: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');

4933: FND_MSG_PUB.Add;
4934: RAISE FND_API.G_EXC_ERROR;
4935:
4936: WHEN others THEN
4937: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4938: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
4939: FND_MSG_PUB.Add;
4940: RAISE FND_API.G_EXC_ERROR;
4941:

Line 4938: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);

4934: RAISE FND_API.G_EXC_ERROR;
4935:
4936: WHEN others THEN
4937: FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_CURR_AND_PL');
4938: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_incident_id);
4939: FND_MSG_PUB.Add;
4940: RAISE FND_API.G_EXC_ERROR;
4941:
4942: END;

Line 5704: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');

5700: return l_currency_code;
5701:
5702: EXCEPTION
5703: WHEN NO_DATA_FOUND THEN
5704: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
5705: -- FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
5706: FND_MSG_PUB.Add;
5707: RAISE FND_API.G_EXC_ERROR;
5708: RETURN NULL;

Line 5705: -- FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);

5701:
5702: EXCEPTION
5703: WHEN NO_DATA_FOUND THEN
5704: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
5705: -- FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_inv_item_id);
5706: FND_MSG_PUB.Add;
5707: RAISE FND_API.G_EXC_ERROR;
5708: RETURN NULL;
5709:

Line 5711: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');

5707: RAISE FND_API.G_EXC_ERROR;
5708: RETURN NULL;
5709:
5710: WHEN TOO_MANY_ROWS THEN
5711: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_CURR_CODE');
5712: FND_MSG_PUB.Add;
5713: RAISE FND_API.G_EXC_ERROR;
5714: RETURN NULL;
5715: