[Home] [Help]
264: IF G_USER_ID IS NULL
265: THEN
266: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
267: THEN
268: Fnd_Message.Set_Name('CSD', 'CSD_CANNOT_GET_PROFILE_VALUE');
269: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
270: Fnd_Msg_Pub.ADD;
271: END IF;
272: RAISE Fnd_Api.G_EXC_ERROR;
265: THEN
266: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
267: THEN
268: Fnd_Message.Set_Name('CSD', 'CSD_CANNOT_GET_PROFILE_VALUE');
269: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
270: Fnd_Msg_Pub.ADD;
271: END IF;
272: RAISE Fnd_Api.G_EXC_ERROR;
273: END IF;
332:
333: IF l_flow_status_id IS NULL THEN
334: -- Repair Order creation failed.
335: -- Unable to get the draft status details.
336: Fnd_Message.SET_NAME('CSD','CSD_RO_NO_DRAFT_STATUS_DTLS');
337: Fnd_Msg_Pub.ADD;
338: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340:
637:
638: IF x_return_status <> 'S' THEN
639: -- Unable to update repair status. Adding repair activity
640: -- process has failed.
641: Fnd_Message.Set_Name('CSD', 'CSD_CREATE_RO_ACTY_FAIL');
642: Fnd_Msg_Pub.ADD;
643: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645:
683:
684: If x_return_status <> 'S' THEN
685: -- Unable to update repair status. Adding repair activity
686: -- process has failed.
687: Fnd_Message.Set_Name('CSD', 'CSD_CREATE_CHILD_RO_ACTY_FAIL');
688: Fnd_Msg_Pub.ADD;
689: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
690: END IF;
691: END IF;
900: IF G_USER_ID IS NULL
901: THEN
902: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
903: THEN
904: Fnd_Message.Set_Name('CSD', 'CSD_CANNOT_GET_PROFILE_VALUE');
905: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
906: Fnd_Msg_Pub.ADD;
907: END IF;
908: RAISE Fnd_Api.G_EXC_ERROR;
901: THEN
902: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
903: THEN
904: Fnd_Message.Set_Name('CSD', 'CSD_CANNOT_GET_PROFILE_VALUE');
905: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
906: Fnd_Msg_Pub.ADD;
907: END IF;
908: RAISE Fnd_Api.G_EXC_ERROR;
909: END IF;
1009: ;
1010:
1011: IF (C_Get_repairs%NOTFOUND) THEN
1012: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1013: Fnd_Message.Set_Name('CSD', 'CSD_API_MISSING_UPDATE_TARGET');
1014: Fnd_Message.Set_Token ('INFO', 'Repairs', FALSE);
1015: Fnd_Msg_Pub.ADD;
1016: END IF;
1017: CLOSE C_Get_repairs;
1010:
1011: IF (C_Get_repairs%NOTFOUND) THEN
1012: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1013: Fnd_Message.Set_Name('CSD', 'CSD_API_MISSING_UPDATE_TARGET');
1014: Fnd_Message.Set_Token ('INFO', 'Repairs', FALSE);
1015: Fnd_Msg_Pub.ADD;
1016: END IF;
1017: CLOSE C_Get_repairs;
1018: RAISE Fnd_Api.G_EXC_ERROR;
1022: -- bug#12884352
1023: -- should use csd_repairs_pub.update_repair_type to update repair type, not this function
1024: IF P_REPLN_rec.repair_type_id is not NULL and P_REPLN_rec.repair_type_id <> Fnd_Api.G_MISS_NUM and l_OLD_REPLN_rec.repair_type_id <> P_REPLN_Rec.repair_type_id THEN
1025: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1026: Fnd_Message.Set_Name('CSD', 'CSD_UPDATE_REPAIR_TYPE');
1027: Fnd_Msg_Pub.ADD;
1028: END IF;
1029: RAISE Fnd_Api.G_EXC_ERROR;
1030: END IF;
1031:
1032: /*
1033: if l_OLD_REPLN_Rec.status = 'C' then
1034: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1035: FND_MESSAGE.Set_Name('CSD', 'CSD_RO_CLOSED');
1036: FND_MESSAGE.Set_Token ('REP_NUM', l_OLD_REPLN_Rec.repair_number);
1037: FND_MSG_PUB.Add;
1038: END IF;
1039: raise FND_API.G_EXC_ERROR;
1032: /*
1033: if l_OLD_REPLN_Rec.status = 'C' then
1034: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1035: FND_MESSAGE.Set_Name('CSD', 'CSD_RO_CLOSED');
1036: FND_MESSAGE.Set_Token ('REP_NUM', l_OLD_REPLN_Rec.repair_number);
1037: FND_MSG_PUB.Add;
1038: END IF;
1039: raise FND_API.G_EXC_ERROR;
1040: end if;
1369:
1370: IF l_valid = 'N' THEN
1371: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1372: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1373: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_REPLN_ID');
1374: Fnd_Msg_Pub.ADD;
1375: END IF;
1376: END IF;
1377:
1407:
1408: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1409: IF p_repair_number IS NULL THEN
1410: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1411: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1412: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1413: Fnd_Message.SET_TOKEN('NULL_PARAM', 'REPAIR_NUMBER');
1414: Fnd_Msg_Pub.ADD;
1415: RETURN;
1408: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1409: IF p_repair_number IS NULL THEN
1410: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1411: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1412: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1413: Fnd_Message.SET_TOKEN('NULL_PARAM', 'REPAIR_NUMBER');
1414: Fnd_Msg_Pub.ADD;
1415: RETURN;
1416: ELSIF p_repair_number = p_old_repair_number
1409: IF p_repair_number IS NULL THEN
1410: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1411: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1412: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1413: Fnd_Message.SET_TOKEN('NULL_PARAM', 'REPAIR_NUMBER');
1414: Fnd_Msg_Pub.ADD;
1415: RETURN;
1416: ELSIF p_repair_number = p_old_repair_number
1417: OR p_repair_number = Fnd_Api.G_MISS_CHAR THEN
1428:
1429: IF l_valid = 'N' THEN
1430: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1431: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1432: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_REPLN_NUMBER');
1433: Fnd_Msg_Pub.ADD;
1434: END IF;
1435: END IF;
1436:
1460:
1461: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1462: IF p_incident_id IS NULL THEN
1463: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1464: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1465: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1466: Fnd_Message.SET_TOKEN('NULL_PARAM', 'INCIDENT_ID');
1467: Fnd_Msg_Pub.ADD;
1468: RETURN;
1461: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1462: IF p_incident_id IS NULL THEN
1463: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1464: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1465: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1466: Fnd_Message.SET_TOKEN('NULL_PARAM', 'INCIDENT_ID');
1467: Fnd_Msg_Pub.ADD;
1468: RETURN;
1469: ELSIF p_incident_id = p_old_incident_id
1462: IF p_incident_id IS NULL THEN
1463: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1464: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1465: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1466: Fnd_Message.SET_TOKEN('NULL_PARAM', 'INCIDENT_ID');
1467: Fnd_Msg_Pub.ADD;
1468: RETURN;
1469: ELSIF p_incident_id = p_old_incident_id
1470: OR p_incident_id = Fnd_Api.G_MISS_NUM THEN
1481:
1482: IF l_valid = 'N' THEN
1483: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1484: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1485: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_INCIDENT_ID');
1486: Fnd_Msg_Pub.ADD;
1487: END IF;
1488: END IF;
1489:
1516:
1517: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1518: IF p_inventory_item_id IS NULL THEN
1519: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1520: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1521: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1522: Fnd_Message.SET_TOKEN('NULL_PARAM', 'INVENTORY_ITEM_ID');
1523: Fnd_Msg_Pub.ADD;
1524: RETURN;
1517: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1518: IF p_inventory_item_id IS NULL THEN
1519: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1520: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1521: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1522: Fnd_Message.SET_TOKEN('NULL_PARAM', 'INVENTORY_ITEM_ID');
1523: Fnd_Msg_Pub.ADD;
1524: RETURN;
1525: ELSIF p_inventory_item_id = p_old_inventory_item_id
1518: IF p_inventory_item_id IS NULL THEN
1519: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1520: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1521: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1522: Fnd_Message.SET_TOKEN('NULL_PARAM', 'INVENTORY_ITEM_ID');
1523: Fnd_Msg_Pub.ADD;
1524: RETURN;
1525: ELSIF p_inventory_item_id = p_old_inventory_item_id
1526: OR p_inventory_item_id = Fnd_Api.G_MISS_NUM THEN
1537:
1538: IF l_valid = 'N' THEN
1539: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1541: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_INVENTORY_ITEM');
1542: Fnd_Msg_Pub.ADD;
1543: END IF;
1544: END IF;
1545:
1610:
1611: IF l_valid = 'N' THEN
1612: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1613: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1614: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_CUST_PROD');
1615: Fnd_Msg_Pub.ADD;
1616: END IF;
1617: END IF;
1618:
1679:
1680: IF l_valid = 'N' THEN
1681: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1682: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1683: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_CUST_PROD');
1684: Fnd_Msg_Pub.ADD;
1685: END IF;
1686: END IF;
1687:
1713:
1714: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1715: IF p_unit_of_measure IS NULL THEN
1716: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1717: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1718: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1719: Fnd_Message.SET_TOKEN('NULL_PARAM', 'UNIT_OF_MEASURE');
1720: Fnd_Msg_Pub.ADD;
1721: RETURN;
1714: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1715: IF p_unit_of_measure IS NULL THEN
1716: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1717: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1718: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1719: Fnd_Message.SET_TOKEN('NULL_PARAM', 'UNIT_OF_MEASURE');
1720: Fnd_Msg_Pub.ADD;
1721: RETURN;
1722: ELSIF p_unit_of_measure = p_unit_of_measure
1715: IF p_unit_of_measure IS NULL THEN
1716: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1717: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1718: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1719: Fnd_Message.SET_TOKEN('NULL_PARAM', 'UNIT_OF_MEASURE');
1720: Fnd_Msg_Pub.ADD;
1721: RETURN;
1722: ELSIF p_unit_of_measure = p_unit_of_measure
1723: OR p_unit_of_measure = Fnd_Api.G_MISS_CHAR THEN
1734:
1735: IF l_valid = 'N' THEN
1736: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1737: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1738: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_UOM');
1739: Fnd_Msg_Pub.ADD;
1740: END IF;
1741: END IF;
1742:
1768:
1769: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1770: IF p_repair_type_id IS NULL THEN
1771: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1772: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1773: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1774: Fnd_Message.SET_TOKEN('NULL_PARAM', 'REPAIR_TYPE_ID');
1775: Fnd_Msg_Pub.ADD;
1776: RETURN;
1769: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
1770: IF p_repair_type_id IS NULL THEN
1771: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1772: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1773: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1774: Fnd_Message.SET_TOKEN('NULL_PARAM', 'REPAIR_TYPE_ID');
1775: Fnd_Msg_Pub.ADD;
1776: RETURN;
1777: ELSIF p_repair_type_id = p_old_repair_type_id
1770: IF p_repair_type_id IS NULL THEN
1771: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1772: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
1773: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
1774: Fnd_Message.SET_TOKEN('NULL_PARAM', 'REPAIR_TYPE_ID');
1775: Fnd_Msg_Pub.ADD;
1776: RETURN;
1777: ELSIF p_repair_type_id = p_old_repair_type_id
1778: OR p_repair_type_id = Fnd_Api.G_MISS_NUM THEN
1789:
1790: IF l_valid = 'N' THEN
1791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1792: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1793: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_REPAIR_TYPE');
1794: Fnd_Msg_Pub.ADD;
1795: END IF;
1796: END IF;
1797:
1872:
1873: IF l_valid = 'N' THEN
1874: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1875: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1876: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_RESOURCE');
1877: Fnd_Msg_Pub.ADD;
1878: END IF;
1879: END IF;
1880:
1930:
1931: IF l_valid = 'N' THEN
1932: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1933: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1934: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_RS_GROUP');
1935: Fnd_Msg_Pub.ADD;
1936: END IF;
1937: END IF;
1938:
2014:
2015: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2016: IF p_status IS NULL THEN
2017: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2018: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2019: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2020: Fnd_Message.SET_TOKEN('NULL_PARAM', 'STATUS');
2021: Fnd_Msg_Pub.ADD;
2022: RETURN;
2015: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2016: IF p_status IS NULL THEN
2017: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2018: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2019: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2020: Fnd_Message.SET_TOKEN('NULL_PARAM', 'STATUS');
2021: Fnd_Msg_Pub.ADD;
2022: RETURN;
2023: ELSIF p_status = p_old_status
2016: IF p_status IS NULL THEN
2017: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2018: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2019: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2020: Fnd_Message.SET_TOKEN('NULL_PARAM', 'STATUS');
2021: Fnd_Msg_Pub.ADD;
2022: RETURN;
2023: ELSIF p_status = p_old_status
2024: OR p_status = Fnd_Api.G_MISS_CHAR THEN
2035:
2036: IF l_valid = 'N' THEN
2037: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2039: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_STATUS');
2040: Fnd_Msg_Pub.ADD;
2041: END IF;
2042: END IF;
2043:
2070:
2071: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2072: IF p_approval_required_flag IS NULL THEN
2073: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2074: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2075: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2076: Fnd_Message.SET_TOKEN('NULL_PARAM', 'APPROVAL_REQUIRED_FLAG');
2077: Fnd_Msg_Pub.ADD;
2078: RETURN;
2071: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2072: IF p_approval_required_flag IS NULL THEN
2073: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2074: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2075: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2076: Fnd_Message.SET_TOKEN('NULL_PARAM', 'APPROVAL_REQUIRED_FLAG');
2077: Fnd_Msg_Pub.ADD;
2078: RETURN;
2079: ELSIF p_approval_required_flag = p_old_approval_required_flag
2072: IF p_approval_required_flag IS NULL THEN
2073: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2074: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2075: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2076: Fnd_Message.SET_TOKEN('NULL_PARAM', 'APPROVAL_REQUIRED_FLAG');
2077: Fnd_Msg_Pub.ADD;
2078: RETURN;
2079: ELSIF p_approval_required_flag = p_old_approval_required_flag
2080: OR p_approval_required_flag = Fnd_Api.G_MISS_CHAR THEN
2091:
2092: IF l_valid = 'N' THEN
2093: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2094: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2095: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_APRVL_REQD_FLG');
2096: Fnd_Msg_Pub.ADD;
2097: END IF;
2098: END IF;
2099:
2154:
2155: IF l_valid = 'N' THEN
2156: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2157: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2158: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_APRVL_STATUS');
2159: Fnd_Msg_Pub.ADD;
2160: END IF;
2161: END IF;
2162:
2214:
2215: IF l_valid = 'N' THEN
2216: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2217: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2218: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_PROMISE_DATE');
2219: Fnd_Msg_Pub.ADD;
2220: END IF;
2221: END IF;
2222:
2240:
2241: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2242: IF p_quantity IS NULL THEN
2243: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2244: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2245: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2246: Fnd_Message.SET_TOKEN('NULL_PARAM', 'QUANTITY');
2247: Fnd_Msg_Pub.ADD;
2248: RETURN;
2241: IF p_validation_mode = Jtf_Plsql_Api.G_UPDATE THEN
2242: IF p_quantity IS NULL THEN
2243: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2244: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2245: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2246: Fnd_Message.SET_TOKEN('NULL_PARAM', 'QUANTITY');
2247: Fnd_Msg_Pub.ADD;
2248: RETURN;
2249: ELSIF p_quantity = p_old_quantity
2242: IF p_quantity IS NULL THEN
2243: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2244: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2245: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2246: Fnd_Message.SET_TOKEN('NULL_PARAM', 'QUANTITY');
2247: Fnd_Msg_Pub.ADD;
2248: RETURN;
2249: ELSIF p_quantity = p_old_quantity
2250: OR p_quantity = Fnd_Api.G_MISS_NUM THEN
2258:
2259: IF l_valid = 'N' THEN
2260: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2261: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2262: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_QUANTITY');
2263: Fnd_Msg_Pub.ADD;
2264: END IF;
2265: END IF;
2266:
2310:
2311: if l_valid = 'N' then
2312: x_return_status := FND_API.G_RET_STS_ERROR;
2313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2314: FND_MESSAGE.Set_Name('CSD', 'CSD_INVALID_QTY_IN_WIP');
2315: FND_MSG_PUB.ADD;
2316: END IF;
2317: end if;
2318: Commented by saupadhy after JDSU enhancements
2377: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2378: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2379:
2380: -- travi this mesg need to be changed
2381: -- travi FND_MESSAGE.Set_Name('CSD', 'CSD_INVALID_OBJ_VER_NUM');
2382: Fnd_Msg_Pub.ADD;
2383:
2384: END IF;
2385: END IF;
2435: Csd_Gen_Utility_Pvt.ADD('Update_Repair_Order group_id p_validation_mode : '||p_validation_mode);
2436: END IF;
2437:
2438: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2439: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2440: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2441: Fnd_Message.SET_TOKEN('NULL_PARAM', 'RO_GROUP_ID');
2442: Fnd_Msg_Pub.ADD;
2443: RETURN;
2436: END IF;
2437:
2438: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2439: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2440: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2441: Fnd_Message.SET_TOKEN('NULL_PARAM', 'RO_GROUP_ID');
2442: Fnd_Msg_Pub.ADD;
2443: RETURN;
2444: ELSIF p_ro_group_id = p_old_ro_group_id
2437:
2438: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2439: Fnd_Message.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2440: Fnd_Message.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2441: Fnd_Message.SET_TOKEN('NULL_PARAM', 'RO_GROUP_ID');
2442: Fnd_Msg_Pub.ADD;
2443: RETURN;
2444: ELSIF p_ro_group_id = p_old_ro_group_id
2445: OR p_ro_group_id = Fnd_Api.G_MISS_NUM THEN
2458: /* old code
2459: if p_validation_mode = JTF_PLSQL_API.G_UPDATE then
2460: if p_ro_group_id is null then
2461: x_return_status := FND_API.G_RET_STS_ERROR;
2462: FND_MESSAGE.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2463: FND_MESSAGE.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2464: FND_MESSAGE.SET_TOKEN('NULL_PARAM', 'RO_GROUP_ID');
2465: FND_MSG_PUB.Add;
2466: return;
2459: if p_validation_mode = JTF_PLSQL_API.G_UPDATE then
2460: if p_ro_group_id is null then
2461: x_return_status := FND_API.G_RET_STS_ERROR;
2462: FND_MESSAGE.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2463: FND_MESSAGE.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2464: FND_MESSAGE.SET_TOKEN('NULL_PARAM', 'RO_GROUP_ID');
2465: FND_MSG_PUB.Add;
2466: return;
2467: elsif p_ro_group_id = p_old_ro_group_id
2460: if p_ro_group_id is null then
2461: x_return_status := FND_API.G_RET_STS_ERROR;
2462: FND_MESSAGE.SET_NAME('CSD', 'CSD_API_NULL_PARAM');
2463: FND_MESSAGE.SET_TOKEN('API_NAME', 'Update_Repair_Order');
2464: FND_MESSAGE.SET_TOKEN('NULL_PARAM', 'RO_GROUP_ID');
2465: FND_MSG_PUB.Add;
2466: return;
2467: elsif p_ro_group_id = p_old_ro_group_id
2468: or p_ro_group_id = FND_API.G_MISS_NUM then
2490:
2491: IF l_valid = 'N' THEN
2492: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2493: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2494: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_RO_GROUP_ID');
2495: Fnd_Msg_Pub.ADD;
2496: END IF;
2497: END IF;
2498: END IF;
2537:
2538: IF l_valid = 'N' THEN
2539: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2541: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_SOURCE');
2542: Fnd_Message.SET_TOKEN('ORDER_LINE_ID', p_ORIGINAL_SOURCE_LINE_ID);
2543: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID', p_ORIGINAL_SOURCE_HEADER_ID);
2544: Fnd_Msg_Pub.ADD;
2545: END IF;
2538: IF l_valid = 'N' THEN
2539: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2541: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_SOURCE');
2542: Fnd_Message.SET_TOKEN('ORDER_LINE_ID', p_ORIGINAL_SOURCE_LINE_ID);
2543: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID', p_ORIGINAL_SOURCE_HEADER_ID);
2544: Fnd_Msg_Pub.ADD;
2545: END IF;
2546: END IF;
2539: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2540: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2541: Fnd_Message.Set_Name('CSD', 'CSD_INVALID_SOURCE');
2542: Fnd_Message.SET_TOKEN('ORDER_LINE_ID', p_ORIGINAL_SOURCE_LINE_ID);
2543: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID', p_ORIGINAL_SOURCE_HEADER_ID);
2544: Fnd_Msg_Pub.ADD;
2545: END IF;
2546: END IF;
2547:
4168: OPEN ro_details_cur(l_repair_status_rec.repair_line_id);
4169: FETCH ro_Details_cur INTO l_repair_status_rec.from_status_id, l_repair_type_id;
4170: IF(ro_details_cur%NOTFOUND) THEN
4171: CLOSE ro_details_cur;
4172: Fnd_Message.SET_NAME('CSD','CSD_INVALID_REPAIR_ORDER');
4173: Fnd_Msg_Pub.ADD;
4174: RAISE Fnd_Api.G_EXC_ERROR;
4175: END IF;
4176: CLOSE ro_details_cur;
4178: OPEN flow_stat_cur(l_repair_status_Rec.repair_status_id);
4179: FETCH flow_stat_cur INTO l_repair_status_rec.repair_state;
4180: IF(flow_stat_cur%NOTFOUND) THEN
4181: CLOSE flow_stat_cur;
4182: Fnd_Message.SET_NAME('CSD','CSD_INVALID_FLOW_STATUS');
4183: Fnd_Msg_Pub.ADD;
4184: RAISE Fnd_Api.G_EXC_ERROR;
4185: END IF;
4186: CLOSE flow_stat_cur;
4461: -- STEP 2: Validate transition details, if one exists.
4462: -- 5362259, check to_flow_status_id
4463: IF P_TO_FLOW_STATUS_ID IS NULL THEN
4464: -- "Unable to update repair status. A new status is required for the transition."
4465: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_TO_STATUS_REQD');
4466: Fnd_Msg_Pub.ADD;
4467: RAISE Fnd_Api.G_EXC_ERROR;
4468: END IF;
4469:
4496: -- reason is required.
4497: IF l_to_status_code IS NULL THEN
4498: -- "Unable to update repair status. The status transition
4499: -- is not valid for the current repair type."
4500: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_INVALID');
4501: Fnd_Msg_Pub.ADD;
4502: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4503: ELSIF (l_reason_required_flag = 'Y') AND (p_reason_code IS NULL) THEN
4504: -- "Unable to update repair status. A reason is required for the transition."
4501: Fnd_Msg_Pub.ADD;
4502: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4503: ELSIF (l_reason_required_flag = 'Y') AND (p_reason_code IS NULL) THEN
4504: -- "Unable to update repair status. A reason is required for the transition."
4505: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_REASON_REQD');
4506: Fnd_Msg_Pub.ADD;
4507: -- 5362259, chaging exception from G_EXC_UNEXPECTED_ERROR to G_EXC_ERROR
4508: RAISE Fnd_Api.G_EXC_ERROR;
4509: END IF;
4525: p_responsibility_id => Fnd_Global.resp_id
4526: ) THEN
4527: -- Unable to update repair status. The user does not
4528: -- have access to update the repair status.
4529: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_NO_ACCESS');
4530: Fnd_Msg_Pub.ADD;
4531: -- rfieldma, 5494587,
4532: -- changing exception from G_EXC_UNEXPECTED_ERROR
4533: -- to G_EXC_ERROR so that the extra developer's error
4557:
4558: IF l_reason_meaning IS NULL THEN
4559: -- "Unable to update repair status.
4560: -- Invalid reason selected for the transition."
4561: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_INVD_REASON');
4562: Fnd_Msg_Pub.ADD;
4563: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4564: END IF;
4565: END IF;
4599:
4600: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4601: -- "Unable to update repair status.
4602: -- Failed to create the workflow process."
4603: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_WF_FAIL');
4604: Fnd_Msg_Pub.ADD;
4605: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4606: END IF;
4607:
4639: --WHEN NO_DATA_FOUND THEN
4640: -- Unable to update repair status. Another user may have
4641: -- updated the repair order. Please requery the
4642: -- original data and try again.
4643: --Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_OLD_VERSION');
4644: --Fnd_Msg_Pub.ADD;
4645: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4646: --END;
4647:
4652: FETCH c_get_object_version_number INTO x_object_version_number;
4653: CLOSE c_get_object_version_number;
4654: else
4655: --debug('object_Version mismatch');
4656: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_OLD_VERSION');
4657: Fnd_Msg_Pub.ADD;
4658: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4659: end if;
4660:
4715:
4716: IF x_return_status <> 'S' THEN
4717: -- Unable to update repair status. Adding repair activity
4718: -- process has failed.
4719: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_ACTY_FAIL');
4720: Fnd_Msg_Pub.ADD;
4721: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4722: END IF;
4723:
4746:
4747: IF x_return_status <> 'S' THEN
4748: -- Unable to update repair status. Adding repair activity
4749: -- process has failed.
4750: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_SR_FAIL');
4751: Fnd_Msg_Pub.ADD;
4752: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4753: END IF;
4754: END IF;
4773:
4774: IF x_return_status <> 'S' THEN
4775: -- Unable to update repair status. Failed
4776: -- to Initialize the business event.
4777: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_BE_FAIL');
4778: Fnd_Msg_Pub.ADD;
4779: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4780: END IF;
4781:
5116:
5117: -- 5362259, validate p_to_repair_type_id and show error msg
5118: IF (p_to_repair_type_id IS NULL) THEN
5119: -- "Unable to update repair type. A new repair type is required for the transition."
5120: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TO_RT_REQD');
5121: Fnd_Msg_Pub.ADD;
5122: RAISE Fnd_Api.G_EXC_ERROR;
5123: END IF;
5124:
5129: -- reason is required.
5130: IF l_reason_required_flag IS NULL THEN
5131: -- "Unable to update repair type. The repair type transition
5132: -- is not valid for the current status."
5133: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TRANS_INVALID');
5134: Fnd_Msg_Pub.ADD;
5135: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5136: ELSIF (l_reason_required_flag = 'Y') AND (p_reason_code IS NULL) THEN
5137: -- "Unable to update repair type. A reason is required for the transition."
5134: Fnd_Msg_Pub.ADD;
5135: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5136: ELSIF (l_reason_required_flag = 'Y') AND (p_reason_code IS NULL) THEN
5137: -- "Unable to update repair type. A reason is required for the transition."
5138: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_REASON_REQD');
5139: Fnd_Msg_Pub.ADD;
5140: --5362259, changing exeception from G_EXC_UPEXPECTED_ERROR to G_EXC_ERROR
5141: RAISE Fnd_Api.G_EXC_ERROR;
5142: END IF;
5152: p_responsibility_id => Fnd_Global.resp_id
5153: ) THEN
5154: -- Unable to update repair type. The user does not
5155: -- have access to update the repair type.
5156: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TRANS_NO_ACCESS');
5157: Fnd_Msg_Pub.ADD;
5158: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5159: END IF;
5160:
5177:
5178: IF l_dummy IS NULL THEN
5179: -- "Unable to update repair type.
5180: -- Invalid reason selected for the transition."
5181: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_INVD_REASON');
5182: Fnd_Msg_Pub.ADD;
5183: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5184: END IF;
5185: END IF;
5208: WHEN NO_DATA_FOUND THEN
5209: -- Unable to update repair type. Another user may have
5210: -- updated the repair order. Please requery the
5211: -- original data and try again.
5212: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TRANS_OLD_VERSION');
5213: Fnd_Msg_Pub.ADD;
5214: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5215: END;
5216:
5325:
5326: IF x_return_status <> 'S' THEN
5327: -- Unable to update repair type. Adding repair activity
5328: -- process has failed.
5329: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_ACTIVITY_FAILED');
5330: Fnd_Msg_Pub.ADD;
5331: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
5332: END IF;
5333:
5878: p_repair_line_id => p_repair_line_id,
5879: x_return_status => l_return_status);
5880:
5881: IF(l_return_Status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
5882: Fnd_Message.Set_Name('CSD', 'CSD_SECURITY_CHECK_FAILED');
5883: Fnd_Msg_Pub.ADD;
5884: RAISE Fnd_Api.G_EXC_ERROR;
5885: END IF;
5886: