APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on FND_MESSAGE

Line 254: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ACTION');

250: THEN
251: Csd_Gen_Utility_Pvt.ADD('Invalid action is passed ');
252: END IF;
253:
254: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ACTION');
255: Fnd_Message.SET_TOKEN('ACTION', p_action);
256: Fnd_Msg_Pub.ADD;
257: RAISE Fnd_Api.G_EXC_ERROR;
258:

Line 255: Fnd_Message.SET_TOKEN('ACTION', p_action);

251: Csd_Gen_Utility_Pvt.ADD('Invalid action is passed ');
252: END IF;
253:
254: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ACTION');
255: Fnd_Message.SET_TOKEN('ACTION', p_action);
256: Fnd_Msg_Pub.ADD;
257: RAISE Fnd_Api.G_EXC_ERROR;
258:
259: END IF;

Line 389: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_NO_DATA');

385:
386: EXCEPTION
387: WHEN NO_DATA_FOUND THEN
388: NULL;
389: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_NO_DATA');
390: -- FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
391: -- FND_MSG_PUB.ADD;
392: -- RAISE FND_API.G_EXC_ERROR;
393: WHEN OTHERS THEN

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

386: EXCEPTION
387: WHEN NO_DATA_FOUND THEN
388: NULL;
389: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_NO_DATA');
390: -- FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
391: -- FND_MSG_PUB.ADD;
392: -- RAISE FND_API.G_EXC_ERROR;
393: WHEN OTHERS THEN
394: NULL;

Line 395: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_OTHERS');

391: -- FND_MSG_PUB.ADD;
392: -- RAISE FND_API.G_EXC_ERROR;
393: WHEN OTHERS THEN
394: NULL;
395: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_OTHERS');
396: -- FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
397: -- FND_MSG_PUB.ADD;
398: -- RAISE FND_API.G_EXC_ERROR;
399: END;

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

392: -- RAISE FND_API.G_EXC_ERROR;
393: WHEN OTHERS THEN
394: NULL;
395: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_RO_GRP_UPD_OTHERS');
396: -- FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
397: -- FND_MSG_PUB.ADD;
398: -- RAISE FND_API.G_EXC_ERROR;
399: END;
400:

Line 556: Fnd_Message.SET_NAME('CSD', 'CSD_API_RO_GROUP_EST_FAIL');

552:
553: IF l_return_status <> 'S'
554: THEN
555: x_return_status := Fnd_Api.G_RET_STS_ERROR;
556: Fnd_Message.SET_NAME('CSD', 'CSD_API_RO_GROUP_EST_FAIL');
557: Fnd_Msg_Pub.ADD;
558: RAISE Fnd_Api.G_EXC_ERROR;
559: ELSIF l_return_status = 'S'
560: THEN

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

733: Csd_Gen_Utility_Pvt.ADD('Estimate already exists for the repair line Id: ' ||
734: x_estimate_rec.repair_line_id);
735: END IF;
736:
737: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_EXISTS');
738: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
739: x_estimate_rec.repair_line_id);
740: Fnd_Msg_Pub.ADD;
741: RAISE Fnd_Api.G_EXC_ERROR;

Line 738: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

734: x_estimate_rec.repair_line_id);
735: END IF;
736:
737: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_EXISTS');
738: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
739: x_estimate_rec.repair_line_id);
740: Fnd_Msg_Pub.ADD;
741: RAISE Fnd_Api.G_EXC_ERROR;
742: END IF;

Line 757: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');

753: WHERE lookup_type = 'CSD_ESTIMATE_STATUS'
754: AND lookup_code = x_estimate_rec.estimate_status;
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN
757: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');
758: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',
759: x_estimate_rec.estimate_status);
760: Fnd_Msg_Pub.ADD;
761: RAISE Fnd_Api.G_EXC_ERROR;

Line 758: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',

754: AND lookup_code = x_estimate_rec.estimate_status;
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN
757: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');
758: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',
759: x_estimate_rec.estimate_status);
760: Fnd_Msg_Pub.ADD;
761: RAISE Fnd_Api.G_EXC_ERROR;
762: END;

Line 768: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');

764: IF l_est_status_code in ('ACCEPTED','REJECTED') then
765:
766: IF x_estimate_rec.estimate_reason_code is null then
767:
768: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');
769: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);
770: FND_MSG_PUB.ADD;
771: RAISE FND_API.G_EXC_ERROR;
772:

Line 769: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);

765:
766: IF x_estimate_rec.estimate_reason_code is null then
767:
768: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');
769: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);
770: FND_MSG_PUB.ADD;
771: RAISE FND_API.G_EXC_ERROR;
772:
773: END IF;

Line 969: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');

965: INTO l_estimate_id, l_obj_ver_num, l_approval_status;
966:
967: IF repair_estimate%NOTFOUND
968: THEN
969: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');
970: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);
971: Fnd_Msg_Pub.ADD;
972: RAISE Fnd_Api.G_EXC_ERROR;
973: END IF;

Line 970: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);

966:
967: IF repair_estimate%NOTFOUND
968: THEN
969: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');
970: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);
971: Fnd_Msg_Pub.ADD;
972: RAISE Fnd_Api.G_EXC_ERROR;
973: END IF;
974:

Line 990: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');

986: THEN
987: Csd_Gen_Utility_Pvt.ADD('object version number does not match');
988: END IF;
989:
990: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');
991: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);
992: Fnd_Msg_Pub.ADD;
993: RAISE Fnd_Api.G_EXC_ERROR;
994: END IF;

Line 991: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);

987: Csd_Gen_Utility_Pvt.ADD('object version number does not match');
988: END IF;
989:
990: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');
991: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', l_estimate_id);
992: Fnd_Msg_Pub.ADD;
993: RAISE Fnd_Api.G_EXC_ERROR;
994: END IF;
995:

Line 1009: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');

1005: WHERE lookup_type = 'CSD_ESTIMATE_STATUS'
1006: AND lookup_code = x_estimate_rec.estimate_status;
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN
1009: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');
1010: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',
1011: x_estimate_rec.estimate_status);
1012: Fnd_Msg_Pub.ADD;
1013: RAISE Fnd_Api.G_EXC_ERROR;

Line 1010: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',

1006: AND lookup_code = x_estimate_rec.estimate_status;
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN
1009: Fnd_Message.SET_NAME('CSD', 'CSD_EST_STATUS_MISSING');
1010: Fnd_Message.SET_TOKEN('ESTIMATE_STATUS',
1011: x_estimate_rec.estimate_status);
1012: Fnd_Msg_Pub.ADD;
1013: RAISE Fnd_Api.G_EXC_ERROR;
1014: END;

Line 1020: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');

1016: IF l_est_status_code in ('ACCEPTED','REJECTED') then
1017:
1018: IF x_estimate_rec.estimate_reason_code is null then
1019:
1020: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');
1021: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024:

Line 1021: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);

1017:
1018: IF x_estimate_rec.estimate_reason_code is null then
1019:
1020: FND_MESSAGE.SET_NAME('CSD','CSD_EST_REASON_CODE__MISSING');
1021: FND_MESSAGE.SET_TOKEN('REPAIR_ESTIMATE_ID',x_estimate_rec.repair_estimate_id);
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024:
1025: END IF;

Line 1233: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');

1229: THEN
1230: Csd_Gen_Utility_Pvt.ADD('Estimate ID missing');
1231: END IF;
1232:
1233: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');
1234: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1235: Fnd_Msg_Pub.ADD;
1236: RAISE Fnd_Api.G_EXC_ERROR;
1237: END;

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

1230: Csd_Gen_Utility_Pvt.ADD('Estimate ID missing');
1231: END IF;
1232:
1233: Fnd_Message.SET_NAME('CSD', 'CSD_API_ESTIMATE_MISSING');
1234: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1235: Fnd_Msg_Pub.ADD;
1236: RAISE Fnd_Api.G_EXC_ERROR;
1237: END;
1238:

Line 1256: Fnd_Message.SET_NAME('CSD', 'CSD_ESTIMATE_LINE_EXISTS');

1252: THEN
1253: Csd_Gen_Utility_Pvt.ADD('Estimate Lines exists for this estimate');
1254: END IF;
1255:
1256: Fnd_Message.SET_NAME('CSD', 'CSD_ESTIMATE_LINE_EXISTS');
1257: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1258: Fnd_Msg_Pub.ADD;
1259: RAISE Fnd_Api.G_EXC_ERROR;
1260: END IF;

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

1253: Csd_Gen_Utility_Pvt.ADD('Estimate Lines exists for this estimate');
1254: END IF;
1255:
1256: Fnd_Message.SET_NAME('CSD', 'CSD_ESTIMATE_LINE_EXISTS');
1257: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1258: Fnd_Msg_Pub.ADD;
1259: RAISE Fnd_Api.G_EXC_ERROR;
1260: END IF;
1261:

Line 1271: Fnd_Message.SET_NAME('CSD', 'CSD_EST_DELETE_NOT_ALLOWED');

1267: END IF;
1268:
1269: Csd_Repair_Estimate_Pkg.Delete_Row(p_REPAIR_ESTIMATE_ID => p_estimate_id);
1270: ELSE
1271: Fnd_Message.SET_NAME('CSD', 'CSD_EST_DELETE_NOT_ALLOWED');
1272: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1273: Fnd_Msg_Pub.ADD;
1274: RAISE Fnd_Api.G_EXC_ERROR;
1275: END IF;

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

1268:
1269: Csd_Repair_Estimate_Pkg.Delete_Row(p_REPAIR_ESTIMATE_ID => p_estimate_id);
1270: ELSE
1271: Fnd_Message.SET_NAME('CSD', 'CSD_EST_DELETE_NOT_ALLOWED');
1272: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_ID', p_estimate_id);
1273: Fnd_Msg_Pub.ADD;
1274: RAISE Fnd_Api.G_EXC_ERROR;
1275: END IF;
1276:

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

1550: FROM CSD_REPAIRS
1551: WHERE repair_line_id = x_estimate_line_rec.repair_line_id;
1552: EXCEPTION
1553: WHEN NO_DATA_FOUND THEN
1554: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
1555: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
1556: x_estimate_line_rec.repair_line_id);
1557: Fnd_Msg_Pub.ADD;
1558: RAISE Fnd_Api.G_EXC_ERROR;

Line 1555: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

1551: WHERE repair_line_id = x_estimate_line_rec.repair_line_id;
1552: EXCEPTION
1553: WHEN NO_DATA_FOUND THEN
1554: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
1555: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
1556: x_estimate_line_rec.repair_line_id);
1557: Fnd_Msg_Pub.ADD;
1558: RAISE Fnd_Api.G_EXC_ERROR;
1559: END;

Line 1624: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');

1620: -- WHERE cov.contract_line_id = x_estimate_line_rec.contract_id
1621:
1622: Exception
1623: When no_data_found then
1624: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');
1625: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);
1626: FND_MSG_PUB.ADD;
1627: IF (g_debug > 0 ) THEN
1628: csd_gen_utility_pvt.ADD('Contract Line Id missing');

Line 1625: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);

1621:
1622: Exception
1623: When no_data_found then
1624: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');
1625: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);
1626: FND_MSG_PUB.ADD;
1627: IF (g_debug > 0 ) THEN
1628: csd_gen_utility_pvt.ADD('Contract Line Id missing');
1629: END IF;

Line 1657: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');

1653: INTO l_party_id, l_account_id;
1654:
1655: IF order_rec%NOTFOUND OR l_party_id IS NULL
1656: THEN
1657: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
1658: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
1659: Fnd_Msg_Pub.ADD;
1660: RAISE Fnd_Api.G_EXC_ERROR;
1661: END IF;

Line 1658: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);

1654:
1655: IF order_rec%NOTFOUND OR l_party_id IS NULL
1656: THEN
1657: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
1658: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
1659: Fnd_Msg_Pub.ADD;
1660: RAISE Fnd_Api.G_EXC_ERROR;
1661: END IF;
1662:

Line 1732: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');

1728: -- If line_type_id Or line_category_code is null
1729: -- then raise error
1730: IF l_line_type_id IS NULL OR l_line_category_code IS NULL
1731: THEN
1732: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
1733: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
1734: x_estimate_line_rec.txn_billing_type_id);
1735: Fnd_Msg_Pub.ADD;
1736: RAISE Fnd_Api.G_EXC_ERROR;

Line 1733: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',

1729: -- then raise error
1730: IF l_line_type_id IS NULL OR l_line_category_code IS NULL
1731: THEN
1732: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
1733: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
1734: x_estimate_line_rec.txn_billing_type_id);
1735: Fnd_Msg_Pub.ADD;
1736: RAISE Fnd_Api.G_EXC_ERROR;
1737: END IF;

Line 1750: Fnd_Message.SET_NAME('CSD',

1746: FROM oe_price_lists
1747: WHERE price_list_id = x_estimate_line_rec.price_list_id;
1748: EXCEPTION
1749: WHEN NO_DATA_FOUND THEN
1750: Fnd_Message.SET_NAME('CSD',
1751: 'CSD_API_INV_PRICE_LIST_ID');
1752: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
1753: x_estimate_line_rec.price_list_id);
1754: Fnd_Msg_Pub.ADD;

Line 1752: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',

1748: EXCEPTION
1749: WHEN NO_DATA_FOUND THEN
1750: Fnd_Message.SET_NAME('CSD',
1751: 'CSD_API_INV_PRICE_LIST_ID');
1752: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
1753: x_estimate_line_rec.price_list_id);
1754: Fnd_Msg_Pub.ADD;
1755: RAISE Fnd_Api.G_EXC_ERROR;
1756: END;

Line 1767: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');

1763:
1764: -- If l_curr_code is null then raise error
1765: IF l_curr_code IS NULL
1766: THEN
1767: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
1768: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
1769: x_estimate_line_rec.price_list_id);
1770: Fnd_Msg_Pub.ADD;
1771: RAISE Fnd_Api.G_EXC_ERROR;

Line 1768: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',

1764: -- If l_curr_code is null then raise error
1765: IF l_curr_code IS NULL
1766: THEN
1767: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
1768: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
1769: x_estimate_line_rec.price_list_id);
1770: Fnd_Msg_Pub.ADD;
1771: RAISE Fnd_Api.G_EXC_ERROR;
1772: END IF;

Line 1799: -- FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_COST_MISSING');

1795: --IF (g_debug > 0 ) THEN
1796: -- csd_gen_utility_pvt.ADD('Could not get item cost' );
1797: --END IF;
1798: --
1799: -- FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_COST_MISSING');
1800: -- FND_MSG_PUB.ADD;
1801: -- RAISE FND_API.G_EXC_ERROR;
1802: -- END;
1803: -- END IF;

Line 2072: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');

2068: THEN
2069: Csd_Gen_Utility_Pvt.ADD('object version number does not match');
2070: END IF;
2071:
2072: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');
2073: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',
2074: x_estimate_line_rec.repair_estimate_line_id);
2075: Fnd_Msg_Pub.ADD;
2076: RAISE Fnd_Api.G_EXC_ERROR;

Line 2073: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',

2069: Csd_Gen_Utility_Pvt.ADD('object version number does not match');
2070: END IF;
2071:
2072: Fnd_Message.SET_NAME('CSD', 'CSD_OBJ_VER_MISMATCH');
2073: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',
2074: x_estimate_line_rec.repair_estimate_line_id);
2075: Fnd_Msg_Pub.ADD;
2076: RAISE Fnd_Api.G_EXC_ERROR;
2077: END IF;

Line 2154: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');

2150: AND cov.actual_coverage_id = ent.coverage_id
2151: AND ent.business_process_id = l_bus_process_id;
2152: Exception
2153: When no_data_found then
2154: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');
2155: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);
2156: FND_MSG_PUB.ADD;
2157: IF (g_debug > 0 ) THEN
2158: csd_gen_utility_pvt.ADD('Contract Line Id missing');

Line 2155: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);

2151: AND ent.business_process_id = l_bus_process_id;
2152: Exception
2153: When no_data_found then
2154: FND_MESSAGE.SET_NAME('CSD','CSD_API_CONTRACT_MISSING');
2155: FND_MESSAGE.SET_TOKEN('CONTRACT_LINE_ID',x_estimate_line_rec.contract_id);
2156: FND_MSG_PUB.ADD;
2157: IF (g_debug > 0 ) THEN
2158: csd_gen_utility_pvt.ADD('Contract Line Id missing');
2159: END IF;

Line 2439: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');

2435: THEN
2436: Csd_Gen_Utility_Pvt.ADD('Estimate Line is interfaced,so it cannot be deleted');
2437: END IF;
2438:
2439: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');
2440: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',
2441: p_estimate_line_id);
2442: Fnd_Msg_Pub.ADD;
2443: RAISE Fnd_Api.G_EXC_ERROR;

Line 2440: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',

2436: Csd_Gen_Utility_Pvt.ADD('Estimate Line is interfaced,so it cannot be deleted');
2437: END IF;
2438:
2439: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');
2440: Fnd_Message.SET_TOKEN('REPAIR_ESTIMATE_LINE_ID',
2441: p_estimate_line_id);
2442: Fnd_Msg_Pub.ADD;
2443: RAISE Fnd_Api.G_EXC_ERROR;
2444: END;

Line 2691: Fnd_Message.SET_NAME('CSD', 'CSD_EST_PRINT_OPTION_ERROR');

2687: IF (g_debug > 0)
2688: THEN
2689: Csd_Gen_Utility_Pvt.ADD('Set Print Option Failed');
2690: END IF;
2691: Fnd_Message.SET_NAME('CSD', 'CSD_EST_PRINT_OPTION_ERROR');
2692: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2693: Fnd_Msg_Pub.ADD;
2694: END IF;
2695: ELSIF (l_print_required = 'Y')

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

2688: THEN
2689: Csd_Gen_Utility_Pvt.ADD('Set Print Option Failed');
2690: END IF;
2691: Fnd_Message.SET_NAME('CSD', 'CSD_EST_PRINT_OPTION_ERROR');
2692: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2693: Fnd_Msg_Pub.ADD;
2694: END IF;
2695: ELSIF (l_print_required = 'Y')
2696: THEN

Line 2697: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRINTER_SETUP');

2693: Fnd_Msg_Pub.ADD;
2694: END IF;
2695: ELSIF (l_print_required = 'Y')
2696: THEN
2697: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRINTER_SETUP');
2698: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2699: Fnd_Msg_Pub.ADD;
2700: END IF;
2701: -- valase:6499519, rfieldma: 6532016 below

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

2694: END IF;
2695: ELSIF (l_print_required = 'Y')
2696: THEN
2697: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRINTER_SETUP');
2698: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2699: Fnd_Msg_Pub.ADD;
2700: END IF;
2701: -- valase:6499519, rfieldma: 6532016 below
2702: -- get print mode

Line 2718: Fnd_Message.SET_NAME('CSD', 'CSD_XDO_ESTRT_NO_TEMPLATE');

2714: INTO l_template_code;
2715: CLOSE get_default_template_name;
2716: -- no default tempalte defined, raise error
2717: IF (l_template_code is null) THEN
2718: Fnd_Message.SET_NAME('CSD', 'CSD_XDO_ESTRT_NO_TEMPLATE');
2719: Fnd_Message.SET_TOKEN('PROF_NAME', csd_repairs_util.get_user_profile_option_name('CSD_CUST_ESTRT_CON_NAME'));
2720: x_request_id := l_request_id;
2721: Fnd_Msg_Pub.ADD;
2722: RAISE Fnd_Api.G_EXC_ERROR;

Line 2719: Fnd_Message.SET_TOKEN('PROF_NAME', csd_repairs_util.get_user_profile_option_name('CSD_CUST_ESTRT_CON_NAME'));

2715: CLOSE get_default_template_name;
2716: -- no default tempalte defined, raise error
2717: IF (l_template_code is null) THEN
2718: Fnd_Message.SET_NAME('CSD', 'CSD_XDO_ESTRT_NO_TEMPLATE');
2719: Fnd_Message.SET_TOKEN('PROF_NAME', csd_repairs_util.get_user_profile_option_name('CSD_CUST_ESTRT_CON_NAME'));
2720: x_request_id := l_request_id;
2721: Fnd_Msg_Pub.ADD;
2722: RAISE Fnd_Api.G_EXC_ERROR;
2723: END IF;

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

2862: FROM CSD_REPAIRS
2863: WHERE repair_line_id = p_repair_line_id;
2864: EXCEPTION
2865: WHEN NO_DATA_FOUND THEN
2866: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2867: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2868: Fnd_Msg_Pub.ADD;
2869: RAISE Fnd_Api.G_EXC_ERROR;
2870: END;

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

2863: WHERE repair_line_id = p_repair_line_id;
2864: EXCEPTION
2865: WHEN NO_DATA_FOUND THEN
2866: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2867: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2868: Fnd_Msg_Pub.ADD;
2869: RAISE Fnd_Api.G_EXC_ERROR;
2870: END;
2871:

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

3001: WHERE cia.incident_id = cr.incident_id
3002: AND cr.repair_line_id = p_repair_line_id;
3003: EXCEPTION
3004: WHEN NO_DATA_FOUND THEN
3005: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
3006: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
3007: Fnd_Msg_Pub.ADD;
3008: RAISE Fnd_Api.G_EXC_ERROR;
3009: END;

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

3002: AND cr.repair_line_id = p_repair_line_id;
3003: EXCEPTION
3004: WHEN NO_DATA_FOUND THEN
3005: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
3006: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
3007: Fnd_Msg_Pub.ADD;
3008: RAISE Fnd_Api.G_EXC_ERROR;
3009: END;
3010:

Line 3042: Fnd_Message.SET_NAME('CSD', 'CSD_EST_ORDER_NUMBER');

3038: INTO l_order_number
3039: FROM oe_order_headers_all oe, cs_estimate_details ced
3040: WHERE oe.header_id = ced.order_header_id
3041: AND ced.estimate_detail_id = l_last_est_detail_id;
3042: Fnd_Message.SET_NAME('CSD', 'CSD_EST_ORDER_NUMBER');
3043: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);
3044: Fnd_Msg_Pub.ADD;
3045: EXCEPTION
3046: WHEN NO_DATA_FOUND THEN

Line 3043: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);

3039: FROM oe_order_headers_all oe, cs_estimate_details ced
3040: WHERE oe.header_id = ced.order_header_id
3041: AND ced.estimate_detail_id = l_last_est_detail_id;
3042: Fnd_Message.SET_NAME('CSD', 'CSD_EST_ORDER_NUMBER');
3043: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);
3044: Fnd_Msg_Pub.ADD;
3045: EXCEPTION
3046: WHEN NO_DATA_FOUND THEN
3047: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOT_INTERFACED');

Line 3047: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOT_INTERFACED');

3043: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);
3044: Fnd_Msg_Pub.ADD;
3045: EXCEPTION
3046: WHEN NO_DATA_FOUND THEN
3047: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOT_INTERFACED');
3048: Fnd_Msg_Pub.ADD;
3049: IF (g_debug > 0)
3050: THEN
3051: Csd_Gen_Utility_Pvt.ADD('Estimate not interfaced to OM ');

Line 3724: Fnd_Message.SET_NAME('CSD',

3720: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3721: lc_mod_name,
3722: 'Adding message CSD_EST_SC_APPLIED_ERR to FND_MSG stack');
3723: END IF;
3724: Fnd_Message.SET_NAME('CSD',
3725: 'CSD_EST_SC_APPLIED_ERR');
3726: Fnd_Msg_Pub.ADD;
3727: IF (Fnd_Log.Level_Procedure >=
3728: Fnd_Log.G_Current_Runtime_Level)

Line 3805: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');

3801: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3802: lc_mod_name,
3803: 'Adding message CSD_EST_LINE_CREATED_ERR to FND_MSG stack');
3804: END IF;
3805: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');
3806: Fnd_Message.SET_TOKEN('ITEM', l_item_name);
3807: Fnd_Msg_Pub.ADD;
3808: IF (Fnd_Log.Level_Procedure >=
3809: Fnd_Log.G_Current_Runtime_Level)

Line 3806: Fnd_Message.SET_TOKEN('ITEM', l_item_name);

3802: lc_mod_name,
3803: 'Adding message CSD_EST_LINE_CREATED_ERR to FND_MSG stack');
3804: END IF;
3805: Fnd_Message.SET_NAME('CSD', 'CSD_EST_LINE_CREATED_ERR');
3806: Fnd_Message.SET_TOKEN('ITEM', l_item_name);
3807: Fnd_Msg_Pub.ADD;
3808: IF (Fnd_Log.Level_Procedure >=
3809: Fnd_Log.G_Current_Runtime_Level)
3810: THEN

Line 3893: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SC_NO_APPL');

3889: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3890: lc_mod_name,
3891: 'Adding message CSD_EST_SC_NO_APPL to FND_MSG stack');
3892: END IF;
3893: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SC_NO_APPL');
3894: Fnd_Msg_Pub.ADD;
3895: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3896: p_data => x_msg_data);
3897:

Line 3918: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_DEF_PL');

3914: Fnd_Log.STRING(Fnd_Log.Level_Statement,
3915: lc_mod_name,
3916: 'Adding message CSD_EST_NO_DEF_PL to FND_MSG stack');
3917: END IF;
3918: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_DEF_PL');
3919: Fnd_Msg_Pub.ADD;
3920: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3921: p_data => x_msg_data);
3922:

Line 3952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_INAPPL_MODE');

3948: INTO l_repair_mode_name
3949: FROM fnd_lookups
3950: WHERE lookup_type = 'CSD_REPAIR_MODE'
3951: AND lookup_code = p_repair_mode;
3952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_INAPPL_MODE');
3953: Fnd_Message.SET_TOKEN('MODE', l_repair_mode_name);
3954: Fnd_Msg_Pub.ADD;
3955: EXCEPTION
3956: WHEN NO_DATA_FOUND THEN

Line 3953: Fnd_Message.SET_TOKEN('MODE', l_repair_mode_name);

3949: FROM fnd_lookups
3950: WHERE lookup_type = 'CSD_REPAIR_MODE'
3951: AND lookup_code = p_repair_mode;
3952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_INAPPL_MODE');
3953: Fnd_Message.SET_TOKEN('MODE', l_repair_mode_name);
3954: Fnd_Msg_Pub.ADD;
3955: EXCEPTION
3956: WHEN NO_DATA_FOUND THEN
3957: l_repair_mode_name := p_repair_mode;

Line 3980: FND_MESSAGE.SET_NAME('CSD','err_name');

3976: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
3977: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
3978: 'Adding message err_name to FND_MSG stack');
3979: end if;
3980: FND_MESSAGE.SET_NAME('CSD','err_name');
3981: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
3982: FND_MSG_PUB.ADD;
3983: */
3984: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 3981: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

3977: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
3978: 'Adding message err_name to FND_MSG stack');
3979: end if;
3980: FND_MESSAGE.SET_NAME('CSD','err_name');
3981: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
3982: FND_MSG_PUB.ADD;
3983: */
3984: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
3985: p_data => x_msg_data);

Line 4952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SOL_TASK_NO_PROD');

4948: lc_mod_name,
4949: 'no task template for task group id ' ||
4950: r1.task_group_id);
4951: END IF;
4952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SOL_TASK_NO_PROD');
4953: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);
4954: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);
4955: Fnd_Msg_Pub.ADD;
4956: IF (Fnd_Log.Level_Procedure >=

Line 4953: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);

4949: 'no task template for task group id ' ||
4950: r1.task_group_id);
4951: END IF;
4952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SOL_TASK_NO_PROD');
4953: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);
4954: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);
4955: Fnd_Msg_Pub.ADD;
4956: IF (Fnd_Log.Level_Procedure >=
4957: Fnd_Log.G_Current_Runtime_Level)

Line 4954: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);

4950: r1.task_group_id);
4951: END IF;
4952: Fnd_Message.SET_NAME('CSD', 'CSD_EST_SOL_TASK_NO_PROD');
4953: Fnd_Message.SET_TOKEN('GROUP_ID', r1.task_group_id);
4954: Fnd_Message.SET_TOKEN('GROUP_NAME', r1.task_group_name);
4955: Fnd_Msg_Pub.ADD;
4956: IF (Fnd_Log.Level_Procedure >=
4957: Fnd_Log.G_Current_Runtime_Level)
4958: THEN

Line 5215: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');

5211: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5212: lc_mod_name,
5213: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5214: END IF;
5215: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5216: Fnd_Msg_Pub.ADD;
5217: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5218: p_data => x_msg_data);
5219:

Line 5239: FND_MESSAGE.SET_NAME('CSD','err_name');

5235: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5236: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5237: 'Adding message ERR_NAME to FND_MSG stack');
5238: end if;
5239: FND_MESSAGE.SET_NAME('CSD','err_name');
5240: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5241: FND_MSG_PUB.ADD;
5242: */
5243: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 5240: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

5236: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5237: 'Adding message ERR_NAME to FND_MSG stack');
5238: end if;
5239: FND_MESSAGE.SET_NAME('CSD','err_name');
5240: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5241: FND_MSG_PUB.ADD;
5242: */
5243: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5244: p_data => x_msg_data);

Line 5903: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');

5899: Fnd_Log.STRING(Fnd_Log.Level_Statement,
5900: lc_mod_name,
5901: 'Adding message CSD_EST_NO_AUTOGEN to FND_MSG stack');
5902: END IF;
5903: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_AUTOGEN');
5904: Fnd_Msg_Pub.ADD;
5905: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5906: p_data => x_msg_data);
5907:

Line 5926: FND_MESSAGE.SET_NAME('CSD','err_name');

5922: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
5923: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5924: 'Adding message err_name to FND_MSG stack');
5925: end if;
5926: FND_MESSAGE.SET_NAME('CSD','err_name');
5927: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5928: FND_MSG_PUB.ADD;
5929: */
5930: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 5927: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

5923: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
5924: 'Adding message err_name to FND_MSG stack');
5925: end if;
5926: FND_MESSAGE.SET_NAME('CSD','err_name');
5927: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
5928: FND_MSG_PUB.ADD;
5929: */
5930: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
5931: p_data => x_msg_data);

Line 6246: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRICE_ITEM_UOM');

6242: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6243: lc_mod_name,
6244: 'Adding message CSD_EST_NOPRICE_ITEM_UOM to FND_MSG stack');
6245: END IF;
6246: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NOPRICE_ITEM_UOM');
6247: BEGIN
6248: SELECT name
6249: INTO l_price_list_name
6250: FROM qp_list_headers_tl

Line 6272: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);

6268: lc_mod_name,
6269: 'Exception OTHERS occurred while querying for price list name');
6270: END IF;
6271: END;
6272: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6273: Fnd_Message.SET_TOKEN('PRICELIST', l_price_list_name);
6274: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);
6275: Fnd_Msg_Pub.ADD;
6276: l_error := TRUE;

Line 6273: Fnd_Message.SET_TOKEN('PRICELIST', l_price_list_name);

6269: 'Exception OTHERS occurred while querying for price list name');
6270: END IF;
6271: END;
6272: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6273: Fnd_Message.SET_TOKEN('PRICELIST', l_price_list_name);
6274: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);
6275: Fnd_Msg_Pub.ADD;
6276: l_error := TRUE;
6277: IF (Fnd_Log.Level_Statement >=

Line 6274: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);

6270: END IF;
6271: END;
6272: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6273: Fnd_Message.SET_TOKEN('PRICELIST', l_price_list_name);
6274: Fnd_Message.SET_TOKEN('UOM', p_MLE_lines_tbl(i).uom);
6275: Fnd_Msg_Pub.ADD;
6276: l_error := TRUE;
6277: IF (Fnd_Log.Level_Statement >=
6278: Fnd_Log.G_Current_Runtime_Level)

Line 6303: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_ITEM_SAR');

6299: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6300: lc_mod_name,
6301: 'Adding message CSD_EST_NO_ITEM_SAR to FND_MSG stack');
6302: END IF;
6303: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_ITEM_SAR');
6304: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6305: Fnd_Msg_Pub.ADD;
6306: l_error := TRUE;
6307: IF (Fnd_Log.Level_Statement >=

Line 6304: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);

6300: lc_mod_name,
6301: 'Adding message CSD_EST_NO_ITEM_SAR to FND_MSG stack');
6302: END IF;
6303: Fnd_Message.SET_NAME('CSD', 'CSD_EST_NO_ITEM_SAR');
6304: Fnd_Message.SET_TOKEN('ITEM', p_MLE_lines_tbl(i).item_name);
6305: Fnd_Msg_Pub.ADD;
6306: l_error := TRUE;
6307: IF (Fnd_Log.Level_Statement >=
6308: Fnd_Log.G_Current_Runtime_Level)

Line 6476: Fnd_Message.SET_NAME('CSD',

6472: Fnd_Log.STRING(Fnd_Log.Level_Statement,
6473: lc_mod_name,
6474: 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6475: END IF;
6476: Fnd_Message.SET_NAME('CSD',
6477: 'CSD_EST_ESTIMATED_CHARGE_ERR');
6478: Fnd_Message.SET_TOKEN('CONTRACT_NUMBER',
6479: x_est_lines_tbl(l_curRow)
6480: .contract_number);

Line 6478: Fnd_Message.SET_TOKEN('CONTRACT_NUMBER',

6474: 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6475: END IF;
6476: Fnd_Message.SET_NAME('CSD',
6477: 'CSD_EST_ESTIMATED_CHARGE_ERR');
6478: Fnd_Message.SET_TOKEN('CONTRACT_NUMBER',
6479: x_est_lines_tbl(l_curRow)
6480: .contract_number);
6481: Fnd_Msg_Pub.ADD;
6482: l_error := TRUE;

Line 6561: -- FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');

6557: -- if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6558: -- FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6559: -- 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6560: -- end if;
6561: -- FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
6562: -- FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',x_est_lines_tbl(l_curRow).contract_number);
6563: -- FND_MSG_PUB.ADD;
6564: -- l_error := TRUE;
6565: END IF;

Line 6562: -- FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',x_est_lines_tbl(l_curRow).contract_number);

6558: -- FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6559: -- 'Adding message CSD_EST_ESTIMATED_CHARGE_ERR to FND_MSG stack');
6560: -- end if;
6561: -- FND_MESSAGE.SET_NAME('CSD','CSD_EST_ESTIMATED_CHARGE_ERR');
6562: -- FND_MESSAGE.SET_TOKEN('CONTRACT_NUMBER',x_est_lines_tbl(l_curRow).contract_number);
6563: -- FND_MSG_PUB.ADD;
6564: -- l_error := TRUE;
6565: END IF;
6566:

Line 6738: FND_MESSAGE.SET_NAME('CSD','err_name');

6734: if (Fnd_Log.Level_Statement>= Fnd_Log.G_Current_Runtime_Level) then
6735: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6736: 'Adding message err_name to FND_MSG stack');
6737: end if;
6738: FND_MESSAGE.SET_NAME('CSD','err_name');
6739: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
6740: FND_MSG_PUB.ADD;
6741: */
6742: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 6739: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');

6735: FND_LOG.STRING(Fnd_Log.Level_Statement, lc_mod_name,
6736: 'Adding message err_name to FND_MSG stack');
6737: end if;
6738: FND_MESSAGE.SET_NAME('CSD','err_name');
6739: FND_MESSAGE.SET_TOKEN('toke_name', 'token_value');
6740: FND_MSG_PUB.ADD;
6741: */
6742: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
6743: p_data => x_msg_data);

Line 7310: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ESTIMATE_HEADER');

7306: l_est_pvt_hdr_Rec.not_to_exceed; -- swai: bug 9462789
7307:
7308: IF (CUR_EST_HDR%NOTFOUND)
7309: THEN
7310: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ESTIMATE_HEADER');
7311: Fnd_Msg_Pub.ADD;
7312: RAISE Fnd_Api.G_EXC_ERROR;
7313: END IF;
7314:

Line 7318: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ESTIMATE_INPUT');

7314:
7315: IF (l_est_pvt_hdr_Rec.repair_line_id <>
7316: p_Estimate_hdr_Rec.repair_line_id)
7317: THEN
7318: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ESTIMATE_INPUT');
7319: Fnd_Msg_Pub.ADD;
7320: RAISE Fnd_Api.G_EXC_ERROR;
7321: END IF;
7322: CLOSE CUR_EST_HDR;

Line 7977: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_DEFAULT_PL_IMPORT');

7973: FND_LOG.STRING(lc_proc_level, lc_mod_name,
7974: 'Unable to determine default price list for the repair order.');
7975: end if;
7976: -- Unable to determine default pricelist
7977: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_DEFAULT_PL_IMPORT');
7978: -- Unable to determine default price list for the repair order.
7979: -- A default price list must be selected for the repair order to import estimate lines.
7980: FND_MSG_PUB.ADD;
7981: RAISE FND_API.G_EXC_ERROR;

Line 7998: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_INELIGIBLE_WIP');

7994: 'The WIP job ' || inelgible_WIP_rec.JOB_NAME || 'is shared across Repair Orders'
7995: || '. It is not imported');
7996: END IF;
7997: -- Add an INFO message indicating whether the job will not be imported.
7998: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_INELIGIBLE_WIP');
7999: -- The WIP job $JOB_NAME is submitted for more than one repair order.
8000: -- The estimate lines, for a WIP job that is shared across repair orders,
8001: -- can not be submitted.
8002: FND_MESSAGE.set_token( 'JOB_NAME', inelgible_WIP_rec.JOB_NAME );

Line 8002: FND_MESSAGE.set_token( 'JOB_NAME', inelgible_WIP_rec.JOB_NAME );

7998: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_INELIGIBLE_WIP');
7999: -- The WIP job $JOB_NAME is submitted for more than one repair order.
8000: -- The estimate lines, for a WIP job that is shared across repair orders,
8001: -- can not be submitted.
8002: FND_MESSAGE.set_token( 'JOB_NAME', inelgible_WIP_rec.JOB_NAME );
8003: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
8004:
8005: END LOOP; -- c_ineligible_WIP_Jobs cursor
8006:

Line 8068: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GEN_EST_STATUS_ERR');

8064: if (lc_proc_level >= lc_debug_level) then
8065: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8066: 'Estimate header status is not NEW. Status =' || l_repair_estimate_status);
8067: end if;
8068: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GEN_EST_STATUS_ERR');
8069: FND_MESSAGE.set_token( 'STATUS', l_repair_estimate_status_name);
8070: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8071: RAISE FND_API.G_EXC_ERROR;
8072: ELSE

Line 8069: FND_MESSAGE.set_token( 'STATUS', l_repair_estimate_status_name);

8065: FND_LOG.STRING(lc_proc_level, lc_mod_name,
8066: 'Estimate header status is not NEW. Status =' || l_repair_estimate_status);
8067: end if;
8068: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_GEN_EST_STATUS_ERR');
8069: FND_MESSAGE.set_token( 'STATUS', l_repair_estimate_status_name);
8070: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8071: RAISE FND_API.G_EXC_ERROR;
8072: ELSE
8073: -- found estimte header, so change status to DRAFT

Line 8459: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_LINE_CREATED_ERR');

8455: -- RAISE FND_API.G_EXC_ERROR;
8456: x_warning_flag := FND_API.G_TRUE;
8457: -- Add an ERROR message.
8458: -- An error encountered while creating an estimate line for item $ITEM
8459: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_LINE_CREATED_ERR');
8460: FND_MESSAGE.set_token( 'ITEM', l_estimate_lines_tbl( i ).inventory_item_id );
8461: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8462: ELSE
8463: l_total_estimates_lines := l_total_estimates_lines +1;

Line 8460: FND_MESSAGE.set_token( 'ITEM', l_estimate_lines_tbl( i ).inventory_item_id );

8456: x_warning_flag := FND_API.G_TRUE;
8457: -- Add an ERROR message.
8458: -- An error encountered while creating an estimate line for item $ITEM
8459: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_LINE_CREATED_ERR');
8460: FND_MESSAGE.set_token( 'ITEM', l_estimate_lines_tbl( i ).inventory_item_id );
8461: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8462: ELSE
8463: l_total_estimates_lines := l_total_estimates_lines +1;
8464: if (lc_proc_level >= lc_debug_level) then

Line 8474: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_LINE_CREATED_ERR');

8470: WHEN FND_API.G_EXC_ERROR THEN
8471: x_warning_flag := FND_API.G_TRUE;
8472: -- Add an ERROR message.
8473: -- An error encountered while creating Estimate line $INDEX for inventory item $INV_ITEM_ID
8474: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_LINE_CREATED_ERR');
8475: FND_MESSAGE.set_token( 'ITEM', l_estimate_lines_tbl( i ).inventory_item_id );
8476: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8477: END;
8478: END LOOP;

Line 8475: FND_MESSAGE.set_token( 'ITEM', l_estimate_lines_tbl( i ).inventory_item_id );

8471: x_warning_flag := FND_API.G_TRUE;
8472: -- Add an ERROR message.
8473: -- An error encountered while creating Estimate line $INDEX for inventory item $INV_ITEM_ID
8474: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_LINE_CREATED_ERR');
8475: FND_MESSAGE.set_token( 'ITEM', l_estimate_lines_tbl( i ).inventory_item_id );
8476: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8477: END;
8478: END LOOP;
8479:

Line 8488: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_W_WARN' );

8484:
8485: IF ( x_warning_flag <> FND_API.G_FALSE ) THEN
8486: -- Import for the WIP Job $JOB_NAME completed with warnings.
8487: -- $ESTIMATE_LINE_COUNT new repair estimate line(s) were created for the job.
8488: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_W_WARN' );
8489: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8490: FND_MESSAGE.set_token( 'ESTIMATE_LINE_COUNT', l_Estimates_count );
8491: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
8492: if (lc_stat_level >= lc_debug_level) then

Line 8489: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );

8485: IF ( x_warning_flag <> FND_API.G_FALSE ) THEN
8486: -- Import for the WIP Job $JOB_NAME completed with warnings.
8487: -- $ESTIMATE_LINE_COUNT new repair estimate line(s) were created for the job.
8488: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_W_WARN' );
8489: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8490: FND_MESSAGE.set_token( 'ESTIMATE_LINE_COUNT', l_Estimates_count );
8491: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
8492: if (lc_stat_level >= lc_debug_level) then
8493: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 8490: FND_MESSAGE.set_token( 'ESTIMATE_LINE_COUNT', l_Estimates_count );

8486: -- Import for the WIP Job $JOB_NAME completed with warnings.
8487: -- $ESTIMATE_LINE_COUNT new repair estimate line(s) were created for the job.
8488: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_W_WARN' );
8489: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8490: FND_MESSAGE.set_token( 'ESTIMATE_LINE_COUNT', l_Estimates_count );
8491: FND_MSG_PUB.add_detail( p_message_type => FND_MSG_PUB.G_INFORMATION_MSG );
8492: if (lc_stat_level >= lc_debug_level) then
8493: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8494: 'Debrief lines import for the WIP Job ' || curr_WIP_job_rec.JOB_NAME

Line 8508: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_ERROR');

8504: WHEN FND_API.G_EXC_ERROR THEN
8505: x_warning_flag := FND_API.G_TRUE;
8506:
8507: -- Add an ERROR message.
8508: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_ERROR');
8509: -- An error encountered while importing WIP lines into Estimates for the WIP entity - $JOB_NAME.
8510: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8511: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8512:

Line 8510: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );

8506:
8507: -- Add an ERROR message.
8508: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_ERROR');
8509: -- An error encountered while importing WIP lines into Estimates for the WIP entity - $JOB_NAME.
8510: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8511: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8512:
8513: WHEN OTHERS THEN
8514: ROLLBACK TO curr_wip_job_sp;

Line 8528: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMP_JOB_ERR');

8524: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
8525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, lc_api_name );
8526: END IF;
8527:
8528: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMP_JOB_ERR');
8529: -- Unknown error encountered while importing WIP debrief lines to Estimates for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
8530: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8531: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8532: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );

Line 8530: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

8526: END IF;
8527:
8528: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMP_JOB_ERR');
8529: -- Unknown error encountered while importing WIP debrief lines to Estimates for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
8530: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8531: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8532: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8533: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8534: END;

Line 8531: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

8527:
8528: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMP_JOB_ERR');
8529: -- Unknown error encountered while importing WIP debrief lines to Estimates for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
8530: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8531: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8532: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8533: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8534: END;
8535: END LOOP; -- for cursor c_eligible_WIP_Jobs

Line 8532: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );

8528: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMP_JOB_ERR');
8529: -- Unknown error encountered while importing WIP debrief lines to Estimates for the WIP entity $JOB_NAME. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM.
8530: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8531: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8532: FND_MESSAGE.set_token( 'JOB_NAME', curr_WIP_job_rec.JOB_NAME );
8533: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8534: END;
8535: END LOOP; -- for cursor c_eligible_WIP_Jobs
8536:

Line 8544: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_NO_INELIGIBLE_WIP');

8540: end if;
8541:
8542: IF( l_wip_count <= 0 ) THEN
8543: x_warning_flag := FND_API.G_TRUE;
8544: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_NO_INELIGIBLE_WIP');
8545: -- No eligible WIP jobs found for import
8546: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_INFORMATION_MSG);
8547: -- FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
8548: FND_MSG_PUB.add;

Line 8557: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_NO_LINES_ELIGIBLE_WIP');

8553: END IF;
8554:
8555: IF( l_total_estimates_lines <= 0 ) THEN
8556: x_warning_flag := FND_API.G_TRUE;
8557: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_NO_LINES_ELIGIBLE_WIP');
8558: FND_MSG_PUB.add;
8559:
8560: -- if no lines were imported, then raise an error so we can rollback and save
8561: -- any pre-existing lines from being deleted/archived.

Line 8619: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_OTHERS');

8615: FND_LOG.STRING(lc_excep_level, lc_mod_name,
8616: 'WHEN OTHERS THEN. SQL Message['||SQLERRM||']');
8617: END IF;
8618:
8619: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_OTHERS');
8620: -- Unknown error encountered while importing WIP lines to Estimates. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
8621: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8622: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8623: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);

Line 8621: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);

8617: END IF;
8618:
8619: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_OTHERS');
8620: -- Unknown error encountered while importing WIP lines to Estimates. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
8621: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8622: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8623: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8624: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8625: p_data => x_msg_data );

Line 8622: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);

8618:
8619: FND_MESSAGE.SET_NAME( 'CSD', 'CSD_EST_WIP_IMPORT_OTHERS');
8620: -- Unknown error encountered while importing WIP lines to Estimates. SQLCODE = $SQLCODE, SQLERRM = $SQLERRM
8621: FND_MESSAGE.SET_TOKEN('SQLCODE', SQLCODE);
8622: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
8623: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_ERROR_MSG);
8624: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8625: p_data => x_msg_data );
8626: END Import_Estimates_From_Wip;