DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on FND_MESSAGE

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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

Line 98: FND_MESSAGE.SET_TOKEN('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
102: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

Line 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;

Line 103: 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;
107: END Get_No_Chg_Flag;

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

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;

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

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

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

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;

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

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;

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

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

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

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;

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

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;

Line 168: FND_MESSAGE.SET_TOKEN('INCIDENT_ID',p_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:

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

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;

Line 194: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',p_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:

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

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;

Line 218: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_ID',p_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:

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

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;

Line 242: FND_MESSAGE.SET_TOKEN('REPAIR_GROUP_ID',p_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:

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

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

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

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;

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

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;

Line 298: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_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:

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

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:

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

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:

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

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 ;

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

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');

Line 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:

Line 537: 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:
541:

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

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;

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

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:

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

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

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

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');

Line 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;

Line 703: 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;
707: END IF; /*end if l_transaction_type_id */

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

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:

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

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');

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

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;

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

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;

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

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:

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

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;

Line 3842: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_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:

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

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;

Line 3867: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',p_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:

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

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;

Line 3892: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',p_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:

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

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;

Line 3912: FND_MESSAGE.SET_TOKEN('ACTION_TYPE',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;
3916:

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

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;

Line 3933: FND_MESSAGE.SET_TOKEN('ACTION_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;
3937:

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

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;

Line 3971: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_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: */

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

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:

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

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;

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

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:

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

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

Line 4330: FND_MESSAGE.SET_TOKEN('TXN_BILLING_TYPE_ID',p_txn_billing_type_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
4334: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_TXN_BILL_TYPE_ID');

Line 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;

Line 4335: 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;
4339:

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

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;

Line 4382: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_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;
4386:

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

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;

Line 4449: FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_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;
4453: /*

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

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);

Line 4499: FND_MESSAGE.SET_TOKEN('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;

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

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

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

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');

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

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);

Line 4609: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',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;

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

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;

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

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:

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

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:

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

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;

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

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:

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

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

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

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:

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

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

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

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:

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

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;

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

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;

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

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:

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

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: