DBA Data[Home] [Help]

APPS.CSD_ESTIMATE_UTILS_PVT dependencies on FND_MESSAGE

Line 60: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_ESTIMATE');

56:
57: IF l_dummy = 'x' THEN
58: RETURN TRUE;
59: ELSE
60: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_ESTIMATE');
61: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
62: Fnd_Msg_Pub.ADD;
63: RETURN FALSE;
64: END IF;

Line 61: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);

57: IF l_dummy = 'x' THEN
58: RETURN TRUE;
59: ELSE
60: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_ESTIMATE');
61: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
62: Fnd_Msg_Pub.ADD;
63: RETURN FALSE;
64: END IF;
65:

Line 96: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_EST_STATUS');

92:
93: IF l_tmp_count > 0 THEN
94: RETURN TRUE;
95: ELSE
96: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_EST_STATUS');
97: Fnd_Message.SET_TOKEN('STATUS', p_estimate_status);
98: Fnd_Msg_Pub.ADD;
99: RETURN FALSE;
100: END IF;

Line 97: Fnd_Message.SET_TOKEN('STATUS', p_estimate_status);

93: IF l_tmp_count > 0 THEN
94: RETURN TRUE;
95: ELSE
96: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_EST_STATUS');
97: Fnd_Message.SET_TOKEN('STATUS', p_estimate_status);
98: Fnd_Msg_Pub.ADD;
99: RETURN FALSE;
100: END IF;
101:

Line 137: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REJECT_REASON');

133:
134: IF l_tmp_count > 0 THEN
135: RETURN TRUE;
136: ELSE
137: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REJECT_REASON');
138: Fnd_Msg_Pub.ADD;
139: RETURN FALSE;
140: END IF;
141: END VALIDATE_REASON;

Line 171: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_LEAD_TIME_UOM');

167:
168: IF l_tmp_count > 0 THEN
169: RETURN TRUE;
170: ELSE
171: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_LEAD_TIME_UOM');
172: Fnd_Msg_Pub.ADD;
173: RETURN FALSE;
174: END IF;
175: END VALIDATE_LEAD_TIME_UOM;

Line 205: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_UOM');

201: END LOOP;
202: IF l_tmp_count > 0 THEN
203: RETURN TRUE;
204: ELSE
205: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_UOM');
206: Fnd_Msg_Pub.ADD;
207: RETURN FALSE;
208:
209: END IF;

Line 233: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_PRICE_LIST_ID');

229: END LOOP;
230: IF l_tmp_count > 0 THEN
231: RETURN TRUE;
232: ELSE
233: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_PRICE_LIST_ID');
234: Fnd_Message.SET_TOKEN('PRICE_LIST_ID', TO_CHAR(p_price_list_id));
235: Fnd_Msg_Pub.ADD;
236: RETURN FALSE;
237:

Line 234: Fnd_Message.SET_TOKEN('PRICE_LIST_ID', TO_CHAR(p_price_list_id));

230: IF l_tmp_count > 0 THEN
231: RETURN TRUE;
232: ELSE
233: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_PRICE_LIST_ID');
234: Fnd_Message.SET_TOKEN('PRICE_LIST_ID', TO_CHAR(p_price_list_id));
235: Fnd_Msg_Pub.ADD;
236: RETURN FALSE;
237:
238: END IF;

Line 277: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_ORDER_HEADER_ID');

273: END LOOP;
274: IF l_order_number IS NOT NULL THEN
275: RETURN l_order_number;
276: ELSE
277: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_ORDER_HEADER_ID');
278: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID', TO_CHAR(p_order_header_id));
279: Fnd_Msg_Pub.ADD;
280: RETURN NULL;
281:

Line 278: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID', TO_CHAR(p_order_header_id));

274: IF l_order_number IS NOT NULL THEN
275: RETURN l_order_number;
276: ELSE
277: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_ORDER_HEADER_ID');
278: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID', TO_CHAR(p_order_header_id));
279: Fnd_Msg_Pub.ADD;
280: RETURN NULL;
281:
282: END IF;

Line 308: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_INSTANCE');

304: END LOOP;
305: IF l_instance_number IS NOT NULL THEN
306: RETURN l_instance_number;
307: ELSE
308: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_INSTANCE');
309: Fnd_Msg_Pub.ADD;
310: RETURN NULL;
311:
312: END IF;

Line 341: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REVISION');

337: END LOOP;
338: IF l_tmp_count > 0 THEN
339: RETURN TRUE;
340: ELSE
341: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REVISION');
342: Fnd_Message.SET_TOKEN('REVISION', p_revision);
343: Fnd_Msg_Pub.ADD;
344: RETURN FALSE;
345: END IF;

Line 342: Fnd_Message.SET_TOKEN('REVISION', p_revision);

338: IF l_tmp_count > 0 THEN
339: RETURN TRUE;
340: ELSE
341: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REVISION');
342: Fnd_Message.SET_TOKEN('REVISION', p_revision);
343: Fnd_Msg_Pub.ADD;
344: RETURN FALSE;
345: END IF;
346:

Line 373: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_SERIAL_NUMBER');

369: END LOOP;
370: IF l_tmp_count > 0 THEN
371: RETURN TRUE;
372: ELSE
373: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_SERIAL_NUMBER');
374: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', p_serial_number);
375: Fnd_Msg_Pub.ADD;
376: RETURN FALSE;
377: END IF;

Line 374: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', p_serial_number);

370: IF l_tmp_count > 0 THEN
371: RETURN TRUE;
372: ELSE
373: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_SERIAL_NUMBER');
374: Fnd_Message.SET_TOKEN('SERIAL_NUMBER', p_serial_number);
375: Fnd_Msg_Pub.ADD;
376: RETURN FALSE;
377: END IF;
378:

Line 410: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_BILLING_TYPE');

406: END LOOP;
407: IF l_tmp_count > 0 THEN
408: RETURN TRUE;
409: ELSE
410: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_BILLING_TYPE');
411: Fnd_Message.SET_TOKEN('BILLING_TYPE', p_billing_type);
412: Fnd_Msg_Pub.ADD;
413: RETURN FALSE;
414: END IF;

Line 411: Fnd_Message.SET_TOKEN('BILLING_TYPE', p_billing_type);

407: IF l_tmp_count > 0 THEN
408: RETURN TRUE;
409: ELSE
410: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_BILLING_TYPE');
411: Fnd_Message.SET_TOKEN('BILLING_TYPE', p_billing_type);
412: Fnd_Msg_Pub.ADD;
413: RETURN FALSE;
414: END IF;
415:

Line 445: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

441: END LOOP;
442: IF l_dummy = 'x' THEN
443: RETURN TRUE;
444: ELSE
445: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
446: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
447: Fnd_Msg_Pub.ADD;
448: RETURN FALSE;
449: END IF;

Line 446: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);

442: IF l_dummy = 'x' THEN
443: RETURN TRUE;
444: ELSE
445: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
446: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
447: Fnd_Msg_Pub.ADD;
448: RETURN FALSE;
449: END IF;
450:

Line 480: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_INC_STATUS');

476: FOR c1_rec IN c1 LOOP
477: l_dummy := c1_rec.col1;
478: END LOOP;
479: IF l_dummy = 'x' THEN
480: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_INC_STATUS');
481: Fnd_Message.SET_TOKEN('INCIDENT_ID', p_incident_id);
482: Fnd_Msg_Pub.ADD;
483: RETURN FALSE;
484: ELSE

Line 481: Fnd_Message.SET_TOKEN('INCIDENT_ID', p_incident_id);

477: l_dummy := c1_rec.col1;
478: END LOOP;
479: IF l_dummy = 'x' THEN
480: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_INC_STATUS');
481: Fnd_Message.SET_TOKEN('INCIDENT_ID', p_incident_id);
482: Fnd_Msg_Pub.ADD;
483: RETURN FALSE;
484: ELSE
485: RETURN TRUE;

Line 538: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_EXISTS');

534: l_tmp_count := c1_rec.col1;
535: END LOOP;
536:
537: IF l_tmp_count > 0 THEN
538: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_EXISTS');
539: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
540: p_estimate_hdr_rec.repair_line_id);
541: Fnd_Msg_Pub.ADD;
542: Fnd_Msg_Pub.ADD_DETAIL(p_message_type => Fnd_Msg_Pub.G_WARNING_MSG);

Line 539: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

535: END LOOP;
536:
537: IF l_tmp_count > 0 THEN
538: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_EXISTS');
539: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
540: p_estimate_hdr_rec.repair_line_id);
541: Fnd_Msg_Pub.ADD;
542: Fnd_Msg_Pub.ADD_DETAIL(p_message_type => Fnd_Msg_Pub.G_WARNING_MSG);
543: debug('Estimate header already exists');

Line 934: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_OVERRIDE_FLAG');

930:
931: -- Validate override charge flag.
932: IF (p_estimate_line_rec.override_charge_flag = 'Y') THEN
933: IF (NVL(Fnd_Profile.value('CSD_ALLOW_CHARGE_OVERRIDE'), 'N') <> 'Y') THEN
934: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_OVERRIDE_FLAG');
935: Fnd_Msg_Pub.ADD;
936: RAISE Fnd_Api.G_EXC_ERROR;
937: END IF;
938: END IF;

Line 1038: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_TRANSACTION_TYPE');

1034: END LOOP;
1035: debug('txn_type_id is derived from txn_billing type[' ||
1036: px_estimate_line_rec.transaction_Type_id || ']');
1037: IF (px_estimate_line_rec.transaction_Type_id = -1) THEN
1038: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_TRANSACTION_TYPE');
1039: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
1040: px_estimate_line_rec.txn_billing_Type_id);
1041: Fnd_Msg_Pub.ADD;
1042: RAISE Fnd_Api.G_EXC_ERROR;

Line 1039: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',

1035: debug('txn_type_id is derived from txn_billing type[' ||
1036: px_estimate_line_rec.transaction_Type_id || ']');
1037: IF (px_estimate_line_rec.transaction_Type_id = -1) THEN
1038: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_TRANSACTION_TYPE');
1039: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
1040: px_estimate_line_rec.txn_billing_Type_id);
1041: Fnd_Msg_Pub.ADD;
1042: RAISE Fnd_Api.G_EXC_ERROR;
1043: END IF;

Line 1048: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_NOCHARGE_FLAG');

1044:
1045: IF (px_estimate_line_rec.no_charge_flag = 'Y' AND
1046: (px_estimate_line_rec.override_charge_flag IS NULL OR
1047: px_estimate_line_rec.override_charge_flag <> 'Y')) THEN
1048: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_NOCHARGE_FLAG');
1049: Fnd_Msg_Pub.ADD;
1050: RAISE Fnd_Api.G_EXC_ERROR;
1051: ELSIF (px_estimate_line_rec.no_charge_flag IS NULL OR
1052: px_estimate_line_rec.no_charge_flag <> 'Y') THEN

Line 1191: Fnd_Message.set_name('CSD', 'CSD_EST_ESTIMATED_CHARGE_ERR');

1187: x_msg_count => l_msg_count,
1188: x_msg_data => l_msg_data);
1189:
1190: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1191: Fnd_Message.set_name('CSD', 'CSD_EST_ESTIMATED_CHARGE_ERR');
1192: Fnd_Message.set_token('CONTRACT_NUMBER', px_estimate_line_rec.CONTRACT_NUMBER);
1193: Fnd_Msg_Pub.ADD ;
1194: RAISE Fnd_Api.G_EXC_ERROR;
1195: END IF;

Line 1192: Fnd_Message.set_token('CONTRACT_NUMBER', px_estimate_line_rec.CONTRACT_NUMBER);

1188: x_msg_data => l_msg_data);
1189:
1190: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1191: Fnd_Message.set_name('CSD', 'CSD_EST_ESTIMATED_CHARGE_ERR');
1192: Fnd_Message.set_token('CONTRACT_NUMBER', px_estimate_line_rec.CONTRACT_NUMBER);
1193: Fnd_Msg_Pub.ADD ;
1194: RAISE Fnd_Api.G_EXC_ERROR;
1195: END IF;
1196: END IF; END IF;

Line 1222: debug('txn billing_type_id[' || px_estimate_line_rec.txn_billing_type_id || '] is invlaid'); Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_TXN_BILLING_TYPE');

1218: FOR c1_rec IN CUR_TXN_BILLING_TYPE(l_repair_type_id, px_estimate_line_rec.billing_category, l_billing_type) LOOP
1219: px_estimate_line_rec.txn_billing_type_id := c1_rec.txn_billing_type_id;
1220: END LOOP;
1221: IF (px_estimate_line_rec.txn_billing_type_id = -1) THEN
1222: debug('txn billing_type_id[' || px_estimate_line_rec.txn_billing_type_id || '] is invlaid'); Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_TXN_BILLING_TYPE');
1223: Fnd_Msg_Pub.ADD;
1224: RAISE Fnd_Api.G_EXC_ERROR;
1225: END IF;
1226: