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 540: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_EXISTS');

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

Line 541: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

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

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

955:
956: -- Validate override charge flag.
957: IF (p_estimate_line_rec.override_charge_flag = 'Y') THEN
958: IF (NVL(Fnd_Profile.value('CSD_ALLOW_CHARGE_OVERRIDE'), 'N') <> 'Y') THEN
959: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_OVERRIDE_FLAG');
960: Fnd_Msg_Pub.ADD;
961: RAISE Fnd_Api.G_EXC_ERROR;
962: END IF;
963: END IF;

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

1059: END LOOP;
1060: debug('txn_type_id is derived from txn_billing type[' ||
1061: px_estimate_line_rec.transaction_Type_id || ']');
1062: IF (px_estimate_line_rec.transaction_Type_id = -1) THEN
1063: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_TRANSACTION_TYPE');
1064: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
1065: px_estimate_line_rec.txn_billing_Type_id);
1066: Fnd_Msg_Pub.ADD;
1067: RAISE Fnd_Api.G_EXC_ERROR;

Line 1064: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',

1060: debug('txn_type_id is derived from txn_billing type[' ||
1061: px_estimate_line_rec.transaction_Type_id || ']');
1062: IF (px_estimate_line_rec.transaction_Type_id = -1) THEN
1063: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_TRANSACTION_TYPE');
1064: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
1065: px_estimate_line_rec.txn_billing_Type_id);
1066: Fnd_Msg_Pub.ADD;
1067: RAISE Fnd_Api.G_EXC_ERROR;
1068: END IF;

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

1069:
1070: IF (px_estimate_line_rec.no_charge_flag = 'Y' AND
1071: (px_estimate_line_rec.override_charge_flag IS NULL OR
1072: px_estimate_line_rec.override_charge_flag <> 'Y')) THEN
1073: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_NOCHARGE_FLAG');
1074: Fnd_Msg_Pub.ADD;
1075: RAISE Fnd_Api.G_EXC_ERROR;
1076: ELSIF (px_estimate_line_rec.no_charge_flag IS NULL OR
1077: px_estimate_line_rec.no_charge_flag <> 'Y') THEN

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

1212: x_msg_count => l_msg_count,
1213: x_msg_data => l_msg_data);
1214:
1215: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1216: Fnd_Message.set_name('CSD', 'CSD_EST_ESTIMATED_CHARGE_ERR');
1217: Fnd_Message.set_token('CONTRACT_NUMBER', px_estimate_line_rec.CONTRACT_NUMBER);
1218: Fnd_Msg_Pub.ADD ;
1219: RAISE Fnd_Api.G_EXC_ERROR;
1220: END IF;

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

1213: x_msg_data => l_msg_data);
1214:
1215: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
1216: Fnd_Message.set_name('CSD', 'CSD_EST_ESTIMATED_CHARGE_ERR');
1217: Fnd_Message.set_token('CONTRACT_NUMBER', px_estimate_line_rec.CONTRACT_NUMBER);
1218: Fnd_Msg_Pub.ADD ;
1219: RAISE Fnd_Api.G_EXC_ERROR;
1220: END IF;
1221: END IF; END IF;

Line 1247: 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');

1243: FOR c1_rec IN CUR_TXN_BILLING_TYPE(l_repair_type_id, px_estimate_line_rec.billing_category, l_billing_type) LOOP
1244: px_estimate_line_rec.txn_billing_type_id := c1_rec.txn_billing_type_id;
1245: END LOOP;
1246: IF (px_estimate_line_rec.txn_billing_type_id = -1) THEN
1247: 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');
1248: Fnd_Msg_Pub.ADD;
1249: RAISE Fnd_Api.G_EXC_ERROR;
1250: END IF;
1251: