[Home] [Help]
52: EXCEPTION
53: WHEN OTHERS THEN
54: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
55: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.get_org_details'||'-'||SQLERRM);
56: FND_MSG_PUB.ADD;
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
58: END get_org_details;
59: -- -----------------------------------------------------------------------------
60: -- Procedure Name : get_status_details
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: WHEN OTHERS THEN
131: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
132: FND_MESSAGE.set_token ('P_TEXT','CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM);
133: FND_MSG_PUB.ADD;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: END get_status_details;
136: -- -----------------------------------------------------------------------------
137: -- Procedure Name : get_customer_product_details
388: p_column_name => 'INCIDENT_NUMBER' );
389: WHEN OTHERS THEN
390: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
391: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
392: fnd_msg_pub.ADD;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: END;
395: END Convert_Request_Number_To_ID;
396: -- --------------------------------------------------------------------------------
440: p_column_name => 'NAME' );
441: WHEN OTHERS THEN
442: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
443: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
444: fnd_msg_pub.ADD;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: END;
447: ELSE
448: -- the subtype is 'ACT' and the user did pass in parent_type_id
467: p_column_name => 'NAME' );
468: WHEN OTHERS THEN
469: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
470: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
471: fnd_msg_pub.ADD;
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: END;
474: END IF;
475: ELSE
492: p_column_name => 'NAME' );
493: WHEN OTHERS THEN
494: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
495: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
496: fnd_msg_pub.ADD;
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498: END;
499: END IF;
500: END Convert_Type_To_ID;
538: p_column_name => 'NAME');
539: WHEN OTHERS THEN
540: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
541: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
542: fnd_msg_pub.ADD;
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: END;
545: END Convert_Status_to_ID;
546: -- --------------------------------------------------------------------------------
582: p_column_name => 'NAME');
583: WHEN OTHERS THEN
584: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
585: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
586: fnd_msg_pub.ADD;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: END;
589: END Convert_Severity_To_ID;
590:
626: p_column_name => 'NAME');
627: WHEN OTHERS THEN
628: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
629: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
630: fnd_msg_pub.ADD;
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: END Convert_Urgency_To_ID;
633:
634: /*
680: p_column_name => 'CUSTOMER_NUMBER');
681: WHEN OTHERS THEN
682: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
683: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
684: fnd_msg_pub.ADD;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: END;
687: -- If the customer name parameter is also passed, generate an
688: -- informational message.
719: p_column_name => 'CUSTOMER_NAME' );
720: WHEN OTHERS THEN
721: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
722: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
723: fnd_msg_pub.ADD;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
725: END;
726: **************************************************************************/
727: END IF;
769: p_column_name => 'EMPLOYEE_NUMBER' );
770: WHEN OTHERS THEN
771: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
772: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
773: fnd_msg_pub.ADD;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775:
776: END;
777: END IF;
818: p_column_name => 'CP_REF_NUMBER' );
819: WHEN OTHERS THEN
820: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
821: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
822: fnd_msg_pub.ADD;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: END Convert_CP_Ref_Number_To_ID;
825:
826: /*
870: p_column_name => 'RMA_NUMBER' );
871: WHEN OTHERS THEN
872: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
873: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
874: fnd_msg_pub.ADD;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: END Convert_RMA_Number_To_ID;
877:
878: -- --------------------------------------------------------------------------------
919: p_column_name => 'CREATED_BY');
920: WHEN OTHERS THEN
921: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
922: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
923: fnd_msg_pub.ADD;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925:
926: RETURN;
927: END;
944:
945: WHEN OTHERS THEN
946: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
947: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
948: fnd_msg_pub.ADD;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: END;
951: END IF;
952: END Validate_Who_Info;
1014: CLOSE val_type_map;
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016: fnd_message.set_name ('CS', 'CS_SR_TYPE_BY_RESP');
1017: fnd_message.set_token ('OPERATION',p_operation);
1018: fnd_msg_pub.ADD;
1019: ELSE
1020: x_return_status := FND_API.G_RET_STS_SUCCESS;
1021: --Fixed bug 2809312, moved this close cursor here from
1022: --after the if.
1049:
1050: WHEN OTHERS THEN
1051: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1052: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1053: fnd_msg_pub.ADD;
1054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1055: END Validate_Type;
1056:
1057: *******************************/
1127: -- new message for 11.5.10
1128: -- You do not have access to the service request type that is
1129: -- being created. Please contact your system administrator.
1130: fnd_message.set_name ('CS', 'CS_SR_WEB_NO_PRIV');
1131: fnd_msg_pub.ADD;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: end if;
1134: else
1135: -- For bug 3474365 - included an if condition while called for validating old sr type
1145: -- Invalid type. Given type is either end dated or does not exist
1146: -- as a valid type.
1147: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1148: fnd_message.set_token('API_NAME', l_api_name_full);
1149: fnd_msg_pub.ADD;
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151:
1152: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1153: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1152: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1153: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1154: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1155: fnd_message.set_token('API_NAME', l_api_name_full);
1156: fnd_msg_pub.ADD;
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: else
1159: l_flags_set := 'Y';
1160: x_return_status := FND_API.G_RET_STS_SUCCESS;
1170: -- Invalid type. Given type is either end dated or does not exist
1171: -- as a valid type.
1172: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1173: fnd_message.set_token('API_NAME', l_api_name_full);
1174: fnd_msg_pub.ADD;
1175: x_return_status := FND_API.G_RET_STS_ERROR;
1176: else
1177: l_flags_set := 'Y';
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1196: -- Current responsibility does not have sufficient priviledges to access
1197: -- service requests of this type. Please contact your system administrator.
1198: fnd_message.set_name ('CS', 'CS_SR_AGENT_NO_PRIV');
1199: fnd_message.set_token('API_NAME', l_api_name_full);
1200: fnd_msg_pub.ADD;
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1203: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1204: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1202: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1203: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1204: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1205: fnd_message.set_token('API_NAME', l_api_name_full);
1206: fnd_msg_pub.ADD;
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: else
1209: l_flags_set := 'Y';
1210: x_return_status := FND_API.G_RET_STS_SUCCESS;
1221: -- For bug 3902711
1222: --fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1223: fnd_message.set_name ('CS', 'CS_SR_AGENT_NO_PRIV');
1224: fnd_message.set_token('API_NAME', l_api_name_full);
1225: fnd_msg_pub.ADD;
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: else
1228: l_flags_set := 'Y';
1229: x_return_status := FND_API.G_RET_STS_SUCCESS;
1252:
1253: WHEN OTHERS THEN
1254: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1255: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1256: fnd_msg_pub.ADD;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: END Validate_Type;
1259: /*
1260: ** Validate_Status
1398: p_column_name => 'INCIDENT_STATUS_ID' );
1399: WHEN OTHERS THEN
1400: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1401: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1402: fnd_msg_pub.ADD;
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: END Validate_Status;
1405:
1406: /*
1629: p_column_name => 'INCIDENT_STATUS_ID' );
1630: WHEN OTHERS THEN
1631: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1632: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1633: fnd_msg_pub.ADD;
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1635: END Validate_Updated_Status;
1636:
1637:
1671: p_column_name => 'SEVERITY_ID' );
1672: WHEN OTHERS THEN
1673: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1674: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1675: fnd_msg_pub.ADD;
1676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1677:
1678: END;
1679: END Validate_Severity ;
1714: p_column_name => 'URGENCY_ID' );
1715: WHEN OTHERS THEN
1716: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1717: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1718: fnd_msg_pub.ADD;
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720:
1721: END;
1722: END Validate_Urgency;
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1759: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1760: fnd_msg_pub.ADD;
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762:
1763: END Validate_Closed_Date;
1764:
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1786: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1787: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1788: FND_MSG_PUB.ADD;
1789: END IF;
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1793: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1794: fnd_msg_pub.ADD;
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1796:
1797: END Validate_Inc_Reported_Date;
1798:
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1816: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1817: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1818: FND_MSG_PUB.ADD;
1819: END IF;
1820: EXCEPTION
1821: WHEN OTHERS THEN
1822: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1820: EXCEPTION
1821: WHEN OTHERS THEN
1822: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1823: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1824: fnd_msg_pub.ADD;
1825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1826:
1827: END Validate_Inc_Occurred_Date;
1828:
1851: EXCEPTION
1852: WHEN OTHERS THEN
1853: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1854: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1855: fnd_msg_pub.ADD;
1856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1857:
1858: END Validate_Inc_Resolved_Date;
1859:
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1885: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1886: fnd_msg_pub.ADD;
1887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1888:
1889: END Validate_Inc_Responded_Date;
1890:
1958: p_column_name => 'INCIDENT_LOCATION_TYPE' );
1959: WHEN OTHERS THEN
1960: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1961: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1962: fnd_msg_pub.ADD;
1963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1964:
1965: END;
1966: END Validate_Inc_Location_Id;
1996: p_column_name => 'INCIDENT_COUNTRY' );
1997: WHEN OTHERS THEN
1998: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1999: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2000: fnd_msg_pub.ADD;
2001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2002:
2003: END;
2004: END Validate_Incident_Country;
2063:
2064: WHEN OTHERS THEN
2065: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2066: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2067: fnd_msg_pub.ADD;
2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2069: END Validate_Employee;
2070:
2071: -- --------------------------------------------------------------------------------
2113: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_CUSTOMER');
2114: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2115: FND_MESSAGE.Set_Token('VALUE',l_token_v);
2116: FND_MESSAGE.Set_Token('P_NAME', p_parameter_name);
2117: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
2118:
2119:
2120: /* Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
2121: p_token_v => TO_CHAR(p_customer_id),
2124: p_column_name => 'CUSTOMER_ID' ); */
2125: WHEN OTHERS THEN
2126: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2127: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2128: fnd_msg_pub.ADD;
2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2130:
2131: END;
2132: --Addition for 3666089 starts
2132: --Addition for 3666089 starts
2133: IF (l_party_type <> p_caller_type) THEN
2134: x_return_status := FND_API.G_RET_STS_ERROR;
2135: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_CUST_TYPE');
2136: FND_MSG_PUB.ADD; --3666089 (Jun 15)
2137: END IF;
2138: --Addition for 3666089 Ends
2139:
2140: END Validate_Customer;
2224:
2225: WHEN OTHERS THEN
2226: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2227: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2228: fnd_msg_pub.ADD;
2229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2230:
2231: END Validate_Bill_To_Ship_To_Ct;
2232:
2306:
2307: WHEN OTHERS THEN
2308: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2309: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2310: fnd_msg_pub.ADD;
2311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2312:
2313: END Validate_Customer_Contact;
2314:
2374: p_column_name => 'CUSTOMER_CONTACT_ID' );
2375: WHEN OTHERS THEN
2376: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2377: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2378: fnd_msg_pub.ADD;
2379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2380:
2381: END Validate_Org_Relationship;
2382:
2441: p_column_name => 'CUSTOMER_CONTACT_ID' );
2442: WHEN OTHERS THEN
2443: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2444: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2445: fnd_msg_pub.ADD;
2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2447:
2448: END Validate_Person_Relationship;
2449:
2543:
2544: WHEN OTHERS THEN
2545: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2546: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2547: fnd_msg_pub.ADD;
2548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2549:
2550: END Validate_Customer_Product;
2551:
2646:
2647: WHEN OTHERS THEN
2648: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2649: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2650: fnd_msg_pub.ADD;
2651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2652:
2653: END Validate_Current_Serial;
2654:
2718: WHEN OTHERS THEN
2719: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2720: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2721: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2722: fnd_msg_pub.ADD;
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2724:
2725: END Validate_Inventory_Org;
2726:
2767:
2768: WHEN OTHERS THEN
2769: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2770: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2771: fnd_msg_pub.ADD;
2772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2773:
2774: END Validate_Owning_Department;
2775:
2883: );
2884: WHEN OTHERS THEN
2885: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2886: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2887: fnd_msg_pub.ADD;
2888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2889: END Validate_Product;
2890:
2891:
2950: -- Problem code is not valid. Please check the values for the following:\
2951: -- Service request type, inventory item and product category.
2952: fnd_message.set_name ('CS', 'CS_SR_PROB_CODE_INVALID');
2953: fnd_message.set_token('API_NAME', l_api_name_full );
2954: fnd_msg_pub.add;
2955: end if;
2956:
2957:
2958: EXCEPTION
2958: EXCEPTION
2959: WHEN OTHERS THEN
2960: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2961: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2962: fnd_msg_pub.ADD;
2963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2964:
2965: END Validate_Problem_Code;
2966:
3000: p_column_name => 'CUST_PERF_LANG_CODE');
3001: WHEN OTHERS THEN
3002: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3003: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3004: fnd_msg_pub.ADD;
3005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3006:
3007: END;
3008: END Validate_Cust_Pref_Lang_Code;
3040: p_column_name => 'COMM_PREF_CODE' );
3041: WHEN OTHERS THEN
3042: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3043: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3044: fnd_msg_pub.ADD;
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3046: END;
3047: END Validate_Comm_Pref_Code;
3048:
3102: x_return_status := FND_API.G_RET_STS_ERROR;
3103: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3104: fnd_message.set_token ('CAT_SET',nvl(l_profile,'NULL'));
3105: fnd_message.set_token ('CAT_ID',p_category_id);
3106: fnd_msg_pub.ADD;
3107: WHEN OTHERS THEN
3108: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3109: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3110: fnd_msg_pub.ADD;
3106: fnd_msg_pub.ADD;
3107: WHEN OTHERS THEN
3108: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3109: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3110: fnd_msg_pub.ADD;
3111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3112:
3113: END;
3114: END Validate_Category_Id;
3169: fnd_message.set_name ('CS', 'CS_SR_CAT_ITEM_COMB_INVALID');
3170: fnd_message.set_token ('CAT_SET',p_category_set_id);
3171: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3172: fnd_message.set_token ('ITEM_ID',nvl(to_char(p_inventory_item_id),'NULL'));
3173: fnd_msg_pub.ADD;
3174: ELSE
3175: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3176: fnd_message.set_token ('CAT_SET',p_category_set_id);
3177: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3174: ELSE
3175: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3176: fnd_message.set_token ('CAT_SET',p_category_set_id);
3177: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3178: fnd_msg_pub.ADD;
3179: END IF;
3180: WHEN OTHERS THEN
3181: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3182: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3179: END IF;
3180: WHEN OTHERS THEN
3181: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3182: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3183: fnd_msg_pub.ADD;
3184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3185:
3186: END Validate_Category_Set_Id;
3187:
3322: p_column_name => 'EXTERNAL_REFERENCE');
3323: WHEN OTHERS THEN
3324: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3325: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3326: fnd_msg_pub.ADD;
3327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3328:
3329: END Validate_External_Reference;
3330:
3361: p_column_name => 'SYSTEM_ID' );
3362: WHEN OTHERS THEN
3363: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3364: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3365: fnd_msg_pub.ADD;
3366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3367:
3368: END Validate_System_Id;
3369:
3402: EXCEPTION
3403: WHEN OTHERS THEN
3404: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3405: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3406: fnd_msg_pub.ADD;
3407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3408:
3409: END Validate_Exp_Resolution_Date;
3410:
3481: p_column_name => 'BILL_TO_CUSTOMER_ID');
3482: WHEN OTHERS THEN
3483: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3484: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3485: fnd_msg_pub.ADD;
3486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3487: END Validate_Bill_To_Ship_To_Party;
3488:
3489: -- --------------------------------------------------------------------------------
3545: p_column_name => 'BILL_TO_SITE_ID' );
3546: WHEN OTHERS THEN
3547: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3548: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3549: fnd_msg_pub.ADD;
3550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3551: END Validate_Bill_To_Ship_To_Site ;
3552:
3553:
3615:
3616: WHEN OTHERS THEN
3617: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3618: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3619: fnd_msg_pub.ADD;
3620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3621:
3622: END;
3623:
3655: p_column_name => 'RESOLUTION_CODE' );
3656: WHEN OTHERS THEN
3657: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3658: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3659: fnd_msg_pub.ADD;
3660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3661:
3662: END Validate_Resolution_Code;
3663:
3692: EXCEPTION
3693: WHEN OTHERS THEN
3694: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3695: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3696: fnd_msg_pub.ADD;
3697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3698:
3699: END Validate_Act_Resolution_Date;
3700:
3760:
3761: WHEN OTHERS THEN
3762: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3763: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3764: fnd_msg_pub.ADD;
3765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3766: END Validate_Contract_Service_Id;
3767: ---------------------------------------------------------------------------
3768:
3798:
3799: WHEN OTHERS THEN
3800: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3801: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3802: fnd_msg_pub.ADD;
3803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3804:
3805:
3806: END Validate_Contract_Id;
3858:
3859: WHEN OTHERS THEN
3860: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3861: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3862: fnd_msg_pub.ADD;
3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3864: END Validate_Support_Site_Id;
3865: ---------------------------------------------------------
3866:
3905:
3906: WHEN OTHERS THEN
3907: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3908: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3909: fnd_msg_pub.ADD;
3910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3911:
3912:
3913: END Validate_Group_Type;
3964:
3965: WHEN OTHERS THEN
3966: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3967: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3968: fnd_msg_pub.ADD;
3969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3970: END Validate_Group_Id;
3971:
3972: ----------------------------------------
4079: END IF;
4080: WHEN OTHERS THEN
4081: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4082: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4083: fnd_msg_pub.ADD;
4084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4085: END Validate_Owner;
4086:
4087: ------------------------------------------------------
4119:
4120: WHEN OTHERS THEN
4121: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4122: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4123: fnd_msg_pub.ADD;
4124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4125: END Validate_Resource_Type;
4126:
4127: ----------------------------------------------------
4178:
4179: WHEN OTHERS THEN
4180: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4181: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4182: fnd_msg_pub.ADD;
4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4184:
4185: END Validate_Platform_Id;
4186:
4220:
4221: WHEN OTHERS THEN
4222: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4223: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4224: fnd_msg_pub.ADD;
4225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4226:
4227: END Validate_CP_Comp_Id;
4228:
4272:
4273: WHEN OTHERS THEN
4274: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4275: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4276: fnd_msg_pub.ADD;
4277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4278: END;
4279: END IF;
4280: EXCEPTION
4371: p_column_name => 'COMPONENT_VERSION' );
4372: WHEN OTHERS THEN
4373: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4374: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4375: fnd_msg_pub.ADD;
4376: x_return_status := fnd_api.g_ret_sts_unexp_error;
4377: END Validate_product_Version;
4378: --
4379: -- Validate Component Version
4443:
4444: WHEN OTHERS THEN
4445: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4446: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4447: fnd_msg_pub.ADD;
4448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4449: END;
4450: END IF;
4451:
4462: p_column_name => 'COMPONENT_VERSION' );
4463: WHEN OTHERS THEN
4464: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4465: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4466: fnd_msg_pub.ADD;
4467: x_return_status := fnd_api.g_ret_sts_unexp_error;
4468: END;
4469: END Validate_Component_Version;
4470:
4534:
4535: WHEN OTHERS THEN
4536: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4537: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4538: fnd_msg_pub.ADD;
4539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4540: END;
4541: END IF;
4542:
4552: p_column_name => 'SUBCOMPONENT_VERSION');
4553: WHEN OTHERS THEN
4554: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4555: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4556: fnd_msg_pub.ADD;
4557: x_return_status := fnd_api.g_ret_sts_unexp_error;
4558: END;
4559: END Validate_Subcomponent_Version;
4560: ----------------------------------------------------------------------------------
4604:
4605: WHEN OTHERS THEN
4606: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4607: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4608: fnd_msg_pub.ADD;
4609: x_return_status := fnd_api.g_ret_sts_unexp_error;
4610:
4611: END Validate_CP_SubComp_Id;
4612:
4657: p_column_name => 'INV_ITEM_REVISION' );
4658: WHEN OTHERS THEN
4659: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4660: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4661: fnd_msg_pub.ADD;
4662: x_return_status := fnd_api.g_ret_sts_unexp_error;
4663:
4664: END;
4665: END IF;
4675:
4676: WHEN OTHERS THEN
4677: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4678: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4679: fnd_msg_pub.ADD;
4680: x_return_status := fnd_api.g_ret_sts_unexp_error;
4681:
4682: END;
4683: END Validate_Inv_Item_Rev;
4740: p_column_name => 'INV_COMPONENT_ID' );
4741: WHEN OTHERS THEN
4742: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4743: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4744: fnd_msg_pub.ADD;
4745: x_return_status := fnd_api.g_ret_sts_unexp_error;
4746:
4747: END Validate_Inv_Comp_Id;
4748: -----------------------------------------
4863:
4864: WHEN OTHERS THEN
4865: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4866: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4867: fnd_msg_pub.ADD;
4868: x_return_status := fnd_api.g_ret_sts_unexp_error;
4869:
4870: END Validate_Inv_SubComp_Id;
4871: -------------------------------------
4914: p_column_name => 'INV_SUBCOMPONENT_VERSION' );
4915: WHEN OTHERS THEN
4916: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4917: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4918: fnd_msg_pub.ADD;
4919: x_return_status := fnd_api.g_ret_sts_unexp_error;
4920:
4921: END Validate_Inv_SubComp_Ver;
4922:
4953: p_column_name => 'SR_CREATION_CHANNEL' );
4954: WHEN OTHERS THEN
4955: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4956: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4957: fnd_msg_pub.ADD;
4958: x_return_status := fnd_api.g_ret_sts_unexp_error;
4959:
4960: END Validate_SR_Channel;
4961: ---------------------------------------------------------------------------------
4992: p_column_name => 'LANGUAGE_ID');
4993: WHEN OTHERS THEN
4994: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4995: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4996: fnd_msg_pub.ADD;
4997: x_return_status := fnd_api.g_ret_sts_unexp_error;
4998:
4999: END Validate_CP_Language_Id;
5000: ---------------------------------------------------------------------------------------------
5031: p_column_name => 'TERRITORY_ID');
5032: WHEN OTHERS THEN
5033: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5034: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5035: fnd_msg_pub.ADD;
5036: x_return_status := fnd_api.g_ret_sts_unexp_error;
5037:
5038: END Validate_Territory_Id;
5039:
5074: -- party ,contact point and contact point type.
5075:
5076: fnd_message.set_name ('CS', 'CS_SR_CONT_POINT_INVALID');
5077: fnd_message.set_token('API_NAME', l_api_name_full );
5078: fnd_msg_pub.add;
5079:
5080: WHEN OTHERS THEN
5081: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5082: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5079:
5080: WHEN OTHERS THEN
5081: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5082: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5083: fnd_msg_pub.ADD;
5084: x_return_status := fnd_api.g_ret_sts_unexp_error;
5085:
5086: END Validate_Per_Contact_Point_Id;
5087: ---------------------------------------
5120: p_column_name => 'CONTACT_POINT_ID');
5121: WHEN OTHERS THEN
5122: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5123: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5124: fnd_msg_pub.ADD;
5125: x_return_status := fnd_api.g_ret_sts_unexp_error;
5126:
5127: END Validate_Emp_Contact_Point_Id;
5128: -----------------------------------------------------------------
5161: p_column_name => 'CONTACT_POINT_TYPE');
5162: WHEN OTHERS THEN
5163: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5164: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5165: fnd_msg_pub.ADD;
5166: x_return_status := fnd_api.g_ret_sts_unexp_error;
5167: END Validate_Contact_Point_Type;
5168:
5169: -- Validate Contact Type
5200: p_column_name => 'CONTACT_TYPE');
5201: WHEN OTHERS THEN
5202: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5203: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5204: fnd_msg_pub.ADD;
5205: x_return_status := fnd_api.g_ret_sts_unexp_error;
5206: END Validate_Contact_Type;
5207: ---------------------------------------
5208:
5241: p_column_name => 'ACCOUNT_ID');
5242: WHEN OTHERS THEN
5243: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5244: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5245: fnd_msg_pub.ADD;
5246: x_return_status := fnd_api.g_ret_sts_unexp_error;
5247:
5248: END Validate_Account_Id;
5249:
5301: p_token_dfm VARCHAR2
5302: )
5303: IS
5304: BEGIN
5305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5306: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5307: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5308: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5309: FND_MSG_PUB.ADD;
5305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5306: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5307: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5308: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5309: FND_MSG_PUB.ADD;
5310: END IF;
5311: END Add_Desc_Flex_Msg;
5312:
5313:
5334: end if;
5335: -- end for bug 2833245
5336:
5337:
5338: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5339: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5340: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5341: --bug 2833245 pass the local variable for setting the token
5342: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5341: --bug 2833245 pass the local variable for setting the token
5342: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5343: -- end for bug 2833245
5344: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5345: FND_MSG_PUB.ADD;
5346: END IF;
5347: END Add_Invalid_Argument_Msg;
5348:
5349:
5362: p_token_kfm VARCHAR2
5363: )
5364: IS
5365: BEGIN
5366: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5367: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5368: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5369: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5370: FND_MSG_PUB.ADD;
5366: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5367: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5368: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5369: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5370: FND_MSG_PUB.ADD;
5371: END IF;
5372: END Add_Key_Flex_Msg;
5373:
5374:
5381: p_token_np VARCHAR2
5382: )
5383: IS
5384: BEGIN
5385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5386: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5387: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5388: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5389: FND_MSG_PUB.ADD;
5385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5386: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5387: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5388: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5389: FND_MSG_PUB.ADD;
5390: END IF;
5391: END Add_Null_Parameter_Msg;
5392:
5393:
5400: p_token_ip VARCHAR2
5401: )
5402: IS
5403: BEGIN
5404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5405: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
5406: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5407: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
5408: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5405: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
5406: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5407: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
5408: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5409: END IF;
5410: END Add_Param_Ignored_Msg;
5411:
5412:
5421: p_token_pv VARCHAR2
5422: )
5423: IS
5424: BEGIN
5425: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5426: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CP_FLAG_IGNORED');
5427: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5428: FND_MESSAGE.Set_Token('VALUE', p_token_ip);
5429: FND_MESSAGE.Set_Token('DEFAULT_VALUE', p_token_pv);
5426: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CP_FLAG_IGNORED');
5427: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5428: FND_MESSAGE.Set_Token('VALUE', p_token_ip);
5429: FND_MESSAGE.Set_Token('DEFAULT_VALUE', p_token_pv);
5430: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5431: END IF;
5432: END Add_Cp_Flag_Ignored_Msg;
5433:
5434:
5439: PROCEDURE Add_Duplicate_Value_Msg( p_token_an IN VARCHAR2,
5440: p_token_p IN VARCHAR2 ) IS
5441:
5442: BEGIN
5443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5444: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
5445: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5446: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
5447: FND_MSG_PUB.ADD;
5443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5444: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
5445: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5446: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
5447: FND_MSG_PUB.ADD;
5448: END IF;
5449: END Add_Duplicate_Value_Msg;
5450:
5451:
5451:
5452: PROCEDURE Add_Same_Val_Update_Msg( p_token_an IN VARCHAR2,
5453: p_token_p IN VARCHAR2 ) IS
5454: BEGIN
5455: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5456: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
5457: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5458: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
5459: FND_MSG_PUB.ADD;
5455: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5456: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
5457: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5458: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
5459: FND_MSG_PUB.ADD;
5460: END IF;
5461: END Add_Same_Val_Update_Msg;
5462:
5463:
5463:
5464: PROCEDURE Add_Missing_Param_Msg( p_token_an IN VARCHAR2,
5465: p_token_mp IN VARCHAR2 ) IS
5466: BEGIN
5467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5468: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5469: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5470: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5471: FND_MSG_PUB.ADD;
5467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5468: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5469: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5470: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5471: FND_MSG_PUB.ADD;
5472: END IF;
5473: END Add_Missing_Param_Msg;
5474:
5475:
5512:
5513: WHEN OTHERS THEN
5514: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5515: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5516: fnd_msg_pub.ADD;
5517: x_return_status := fnd_api.g_ret_sts_unexp_error;
5518:
5519: END call_internal_hook ;
5520:
5564:
5565: WHEN OTHERS THEN
5566: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5567: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5568: fnd_msg_pub.ADD;
5569: x_return_status := fnd_api.g_ret_sts_unexp_error;
5570: END Validate_Bill_To_Ship_To_Acct ;
5571:
5572: -- -----------------------------------------------------------------------
5629:
5630: WHEN OTHERS THEN
5631: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5632: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5633: fnd_msg_pub.ADD;
5634: x_return_status := fnd_api.g_ret_sts_unexp_error;
5635: END Validate_source_program_Code;
5636: -- -----------------------------------------------------------------------
5637: -- Start of Comments
5691:
5692: WHEN OTHERS THEN
5693: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5694: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5695: fnd_msg_pub.ADD;
5696: x_return_status := fnd_api.g_ret_sts_unexp_error;
5697:
5698:
5699: END Validate_INC_DIST_QUAL_UOM;
5758:
5759: WHEN OTHERS THEN
5760: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5761: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5762: fnd_msg_pub.ADD;
5763: x_return_status := fnd_api.g_ret_sts_unexp_error;
5764:
5765:
5766: END Validate_INC_DIRECTION_QUAL;
5785: IS
5786: l_associated_col1 VARCHAR2(240);
5787:
5788: BEGIN
5789: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5790:
5791: IF p_table_name IS NOT NULL THEN
5792: l_associated_col1 := p_table_name ;
5793: IF p_column_name IS NOT NULL THEN
5801:
5802: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5803: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5804: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5805: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5806:
5807: END IF;
5808: END Add_Desc_Flex_Msg;
5809:
5836: --bug 2833245 created a new local variable for assigning the value as NULL
5837: l_token_v VARCHAR2(4000);
5838: --end for bug 2833245
5839: BEGIN
5840: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5841:
5842: IF p_table_name IS NOT NULL THEN
5843: l_associated_col1 := p_table_name ;
5844: IF p_column_name IS NOT NULL THEN
5862: --bug 2833245 pass the local variable for setting the token
5863: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5864: -- end for bug 2833245
5865: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5866: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5867:
5868: --For bug 2885111 - to remove the blank message
5869: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5870: END IF;
5865: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5866: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5867:
5868: --For bug 2885111 - to remove the blank message
5869: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5870: END IF;
5871: END Add_Invalid_Argument_Msg;
5872:
5873:
5892: )
5893: IS
5894: l_associated_col1 VARCHAR2(240);
5895: BEGIN
5896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5897:
5898: IF p_table_name IS NOT NULL THEN
5899: l_associated_col1 := p_table_name ;
5900: IF p_column_name IS NOT NULL THEN
5907: END IF ;
5908: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5909: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5910: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5911: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5912: END IF;
5913: END Add_Key_Flex_Msg;
5914:
5915: --------------------------------------------------------------------------
5934: p_table_name IN VARCHAR2 ,
5935: p_column_name IN VARCHAR2 ) IS
5936: l_associated_col1 VARCHAR2(240);
5937: BEGIN
5938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5939:
5940: IF p_table_name IS NOT NULL THEN
5941: l_associated_col1 := p_table_name ;
5942: IF p_column_name IS NOT NULL THEN
5949: END IF ;
5950: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5951: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5952: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5953: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5954: END IF;
5955: END Add_Missing_Param_Msg;
5956:
5957: --------------------------------------------------------------------------
5978: )
5979: IS
5980: l_associated_col1 VARCHAR2(240);
5981: BEGIN
5982: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5983:
5984: IF p_table_name IS NOT NULL THEN
5985: l_associated_col1 := p_table_name ;
5986: IF p_column_name IS NOT NULL THEN
5993: END IF ;
5994: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5995: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5996: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5997: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5998: END IF;
5999: END Add_Null_Parameter_Msg;
6000:
6001: --------------------------------------------------------------------------
6022: )
6023: IS
6024: l_associated_col1 VARCHAR2(240);
6025: BEGIN
6026: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6027:
6028: IF p_table_name IS NOT NULL THEN
6029: l_associated_col1 := p_table_name ;
6030: IF p_column_name IS NOT NULL THEN
6037: END IF ;
6038: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
6039: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6040: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
6041: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6042: END IF;
6043: END Add_Param_Ignored_Msg;
6044:
6045: --------------------------------------------------------------------------
6065: p_column_name IN VARCHAR2 ) IS
6066: l_associated_col1 VARCHAR2(240);
6067:
6068: BEGIN
6069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6070:
6071: IF p_table_name IS NOT NULL THEN
6072: l_associated_col1 := p_table_name ;
6073: IF p_column_name IS NOT NULL THEN
6080: END IF ;
6081: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
6082: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6083: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
6084: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6085: END IF;
6086: END Add_Duplicate_Value_Msg;
6087:
6088: --------------------------------------------------------------------------
6107: p_table_name IN VARCHAR2 ,
6108: p_column_name IN VARCHAR2 ) IS
6109: l_associated_col1 VARCHAR2(240);
6110: BEGIN
6111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6112:
6113: IF p_table_name IS NOT NULL THEN
6114: l_associated_col1 := p_table_name ;
6115: IF p_column_name IS NOT NULL THEN
6122: END IF ;
6123: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
6124: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6125: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
6126: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1,
6127: p_message_type => FND_MSG_PUB.G_WARNING_MSG);
6128: END IF;
6129: END Add_Same_Val_Update_Msg;
6130:
6123: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
6124: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6125: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
6126: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1,
6127: p_message_type => FND_MSG_PUB.G_WARNING_MSG);
6128: END IF;
6129: END Add_Same_Val_Update_Msg;
6130:
6131: -- -----------------------------------------------------------------------------
6195:
6196: WHEN OTHERS THEN
6197: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6198: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6199: fnd_msg_pub.add;
6200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6201: END Validate_Site_Site_Use ;
6202:
6203: -- -----------------------------------------------------------------------------
6259:
6260: WHEN OTHERS THEN
6261: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6262: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6263: fnd_msg_pub.add;
6264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6265: END Validate_Bill_Ship_Site_Use;
6266:
6267:
6310: -- service request type may invalidate some of the task assignments.
6311: -- Please verify that the task owners are valid for the new service
6312: -- request type.
6313: fnd_message.set_name ('CS', 'CS_SR_TASK_OWNER_INVALID');
6314: fnd_msg_pub.ADD;
6315: end if;
6316: end if;
6317:
6318: EXCEPTION
6319: WHEN OTHERS THEN
6320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6321: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6322: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6323: fnd_msg_pub.add;
6324:
6325: END TASK_OWNER_CROSS_VAL;
6326:
6327: -- KP API Cleanup; added new proc
6353: x_return_status := FND_API.G_RET_STS_ERROR;
6354: fnd_message.set_name ('CS', 'CS_INVALID_INC_LOCATION');
6355: fnd_message.set_token('INCIDENT_LOCATION_ID', p_incident_location_id);
6356: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6357: fnd_msg_pub.add;
6358:
6359: WHEN OTHERS THEN
6360: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6361: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6358:
6359: WHEN OTHERS THEN
6360: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6361: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6362: fnd_msg_pub.add;
6363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6364:
6365: END CP_INCIDENT_SITE_CROSS_VAL;
6366:
6394: x_return_status := FND_API.G_RET_STS_ERROR;
6395: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6396: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
6397: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6398: fnd_msg_pub.add;
6399:
6400: WHEN OTHERS THEN
6401: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6402: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6399:
6400: WHEN OTHERS THEN
6401: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6402: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6403: fnd_msg_pub.add;
6404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6405:
6406: END CP_INSTALL_SITE_CROSS_VAL;
6407:
6457: -- Resolution code is not valid. Please check the values for the following:
6458: -- Service request type, inventory item, product category and problem code.
6459: fnd_message.set_name ('CS', 'CS_SR_RES_CODE_INVALID');
6460: fnd_message.set_token('API_NAME', l_api_name_full );
6461: fnd_msg_pub.add;
6462: end if;
6463:
6464: EXCEPTION
6465: WHEN OTHERS THEN
6464: EXCEPTION
6465: WHEN OTHERS THEN
6466: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6467: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6468: fnd_msg_pub.add;
6469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6470:
6471: END Resolution_Code_Cross_Val;
6472:
6509: x_return_status := FND_API.G_RET_STS_ERROR;
6510: -- This service request has open dependent tasks. Please close these
6511: -- tasks before closing the service request.
6512: fnd_message.set_name ('CS', 'CS_SR_CANNOT_CLOSE_SR');
6513: fnd_msg_pub.add;
6514: end if;
6515:
6516: END IF;
6517:
6518: EXCEPTION
6519: WHEN OTHERS THEN
6520: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6521: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6522: fnd_msg_pub.add;
6523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6524:
6525: END TASK_RESTRICT_CLOSE_CROSS_VAL;
6526:
6683: -- Service request type, inventory item, instance, account and
6684: -- install site.
6685: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6686: --fnd_message.set_token('API_NAME', l_api_name_full );
6687: --fnd_msg_pub.add;
6688: END IF;
6689: ELSE -- For BUG 3665768
6690: x_return_status := FND_API.G_RET_STS_ERROR;
6691: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6689: ELSE -- For BUG 3665768
6690: x_return_status := FND_API.G_RET_STS_ERROR;
6691: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6692: --fnd_message.set_token('API_NAME', l_api_name_full );
6693: --fnd_msg_pub.add;
6694: END IF; -- IF ( lx_return_status = FND_API.G_RET_STS_SUCCESS ) then
6695: *************** when bug 4109990 is fixed, uncomment this part *********/
6696:
6697: EXCEPTION
6697: EXCEPTION
6698: WHEN OTHERS THEN
6699: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6700: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6701: fnd_msg_pub.add;
6702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6703:
6704: END CONTRACTS_CROSS_VAL;
6705:
6739:
6740: WHEN OTHERS THEN
6741: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6742: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6743: fnd_msg_pub.add;
6744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6745:
6746: END INV_COMPONENT_CROSS_VAL;
6747:
6780:
6781: WHEN OTHERS THEN
6782: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6783: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6784: fnd_msg_pub.add;
6785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6786:
6787: END INV_SUBCOMPONENT_CROSS_VAL;
6788:
6884: -- The system could not update the Type. The Type cannot be changed from a
6885: -- Maintenance Type to a non-Maintenance Type.
6886: fnd_message.set_name ('CS', 'CS_SR_DISALLOW_TYPE_UPD_1');
6887: fnd_message.set_token('API_NAME', l_api_name_full );
6888: fnd_msg_pub.add;
6889: else
6890: -- new message for 11.5.10
6891: -- The system could not update the Type. The Type cannot be changed from a
6892: -- non-Maintenance Type to a Maintenance Type.
6891: -- The system could not update the Type. The Type cannot be changed from a
6892: -- non-Maintenance Type to a Maintenance Type.
6893: fnd_message.set_name ('CS', 'CS_SR_DISALLOW_TYPE_UPD_2');
6894: fnd_message.set_token('API_NAME', l_api_name_full );
6895: fnd_msg_pub.add;
6896: end if;
6897: else
6898: x_return_status := FND_API.G_RET_STS_SUCCESS;
6899: end if;
6903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6904:
6905: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6906: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6907: FND_MSG_PUB.ADD;
6908:
6909: END VALIDATE_TYPE_CHANGE;
6910:
6911:
7460: -- Invalid type. Given type is either end dated or does not exist
7461: -- as a valid type.
7462: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
7463: fnd_message.set_token('API_NAME', l_api_name_full);
7464: fnd_msg_pub.ADD;
7465: lx_return_status := FND_API.G_RET_STS_ERROR;
7466: end;
7467:
7468: if ( lx_return_status = FND_API.G_RET_STS_SUCCESS ) then
7735: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
7736: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7737: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
7738: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7739: fnd_msg_pub.ADD;
7740: x_return_status := FND_API.G_RET_STS_ERROR;
7741: RETURN;
7742: END IF;
7743: END IF;
7774: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
7775: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7776: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
7777: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7778: fnd_msg_pub.ADD;
7779: x_return_status := FND_API.G_RET_STS_ERROR;
7780: RETURN;
7781: END IF;
7782: END IF;
7813:
7814: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7815: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
7816: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7817: fnd_msg_pub.ADD;
7818:
7819: x_return_status := FND_API.G_RET_STS_ERROR;
7820: RETURN;
7821: END IF;
7851:
7852: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7853: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
7854: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7855: fnd_msg_pub.ADD;
7856:
7857: x_return_status := FND_API.G_RET_STS_ERROR;
7858: RETURN;
7859: END IF;
8447: l_sto_party_id IS NULL) THEN
8448: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8449: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
8450: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
8451: fnd_msg_pub.ADD;
8452: x_return_status := FND_API.G_RET_STS_ERROR;
8453: RETURN;
8454: END IF;
8455: END IF;
8614: l_bto_party_id IS NULL) THEN
8615: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8616: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
8617: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
8618: fnd_msg_pub.ADD;
8619: x_return_status := FND_API.G_RET_STS_ERROR;
8620: RETURN;
8621: END IF;
8622: END IF;
8712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8713:
8714: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
8715: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
8716: FND_MSG_PUB.ADD;
8717:
8718: END SERVICEREQUEST_CROSS_VAL;
8719:
8720:
9289: x_return_status := FND_API.G_RET_STS_ERROR;
9290: FND_MESSAGE.set_name('CS','CS_SR_PARTY_ROLE_NE');
9291: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9292: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9293: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9294: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
9295: ELSIF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9296: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9297: THEN
9290: FND_MESSAGE.set_name('CS','CS_SR_PARTY_ROLE_NE');
9291: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9292: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9293: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9294: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
9295: ELSIF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9296: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9297: THEN
9298: x_return_status := FND_API.G_RET_STS_ERROR;
9298: x_return_status := FND_API.G_RET_STS_ERROR;
9299: FND_MESSAGE.set_name('CS','CS_SR_PARTYROLE_INACTIVE');
9300: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9301: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9302: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9303: END IF;
9304: CLOSE c_party_role;
9305: END IF;
9306: --
9311: CLOSE c_party_role;
9312: END IF;
9313: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9314: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.validate_party_role_code'||'-'||SQLERRM);
9315: FND_MSG_PUB.ADD;
9316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9317: END validate_party_role_code;
9318: -- -----------------------------------------------------------------------------
9319: -- Procedure Name : validate_org_id
9357: THEN
9358: FND_MESSAGE.set_name ('CS', 'CS_SR_ORG_ID_INACTIVE');
9359: FND_MESSAGE.set_token ('API_NAME', 'CS_SERVICEREQUEST_UTIL.validate_org_id');
9360: FND_MESSAGE.set_token ('ORG_ID', p_org_id);
9361: FND_MSG_PUB.ADD;
9362: x_return_status := FND_API.G_RET_STS_ERROR;
9363: END IF;
9364: EXCEPTION
9365: WHEN NO_DATA_FOUND THEN
9373: );
9374: WHEN OTHERS THEN
9375: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9376: fnd_message.set_token ('P_TEXT','cs_servicerequest_util.validate_org_id'||'-'||SQLERRM);
9377: fnd_msg_pub.ADD;
9378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9379: END validate_org_id;
9380: -- -----------------------------------------------------------------------------
9381: -- Procedure Name : validate_maint_organization_id
9437: FND_MESSAGE.set_name ('CS' , 'CS_SR_INV_ORG_NOT_MAINT_BY');
9438: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9439: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9440: FND_MESSAGE.set_token ('INV_ORG_ID' , TO_CHAR(p_inventory_org_id));
9441: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9442: END IF;
9443: ELSE -- inv org is a master org or inv org is not passed
9444: get_org_details
9445: ( p_org_id => p_maint_organization_id
9462: x_return_status := FND_API.G_RET_STS_ERROR;
9463: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_ORG_NON_EAM');
9464: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9465: FND_MESSAGE.set_token ('MAINT_ORG_ID', TO_CHAR(p_maint_organization_id));
9466: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9467: ELSIF p_inventory_org_id IS NOT NULL AND
9468: p_inventory_org_id <> FND_API.G_MISS_NUM AND
9469: p_inventory_org_id <> l_master_org_id
9470: THEN
9471: x_return_status := FND_API.G_RET_STS_ERROR;
9472: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_INV_ORG_MISMATCH');
9473: FND_MESSAGE.set_token ('API_NAME' , l_api_name_full);
9474: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9475: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9476: END IF;
9477: END IF;
9478:
9479: END validate_maint_organization_id;
9577: THEN
9578: FND_MESSAGE.set_name('CS','CS_SR_CP_INACTIVE');
9579: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9580: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9581: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9582: RAISE FND_API.G_EXC_ERROR;
9583: END IF;
9584: --
9585: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9588: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9589: FND_MESSAGE.set_token('LOC',l_loc_type);
9590: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9591: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9592: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9593: RAISE FND_API.G_EXC_ERROR;
9594: END IF;
9595: --
9596: IF NVL(l_source_table,'#') <> 'HZ_PARTIES'
9597: THEN
9598: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_SOURCE_INVALID'); -- product is not for TCA parties
9599: FND_MESSAGE.set_token('PARTY_SOURCE',l_source_table);
9600: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9601: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9602: RAISE FND_API.G_EXC_ERROR;
9603: END IF;
9604: --
9605: IF p_customer_id <> NVL(l_party_id,-1)
9610: THEN
9611: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_INVALID'); -- cust not related to product
9612: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9613: FND_MESSAGE.set_token('CUST_ID',TO_CHAR(p_customer_id));
9614: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9615: CLOSE c_prod_rel;
9616: RAISE FND_API.G_EXC_ERROR;
9617: ELSE
9618: CLOSE c_prod_rel;
9639: THEN
9640: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_ID'); -- item associated with CP does not exists
9641: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9642: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9643: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9644: RAISE FND_API.G_EXC_ERROR;
9645: END IF;
9646: IF l_enabled_flag <> 'Y'
9647: THEN
9648: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_DISABLED'); -- item associated with CP is not enabled
9649: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9650: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9651: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9652: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9653: RAISE FND_API.G_EXC_ERROR;
9654: END IF;
9655: IF l_serv_req_enabled <> 'E'
9656: THEN
9657: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_NOT_SERV'); -- item associated with CP is not serviceable
9658: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9659: FND_MESSAGE.set_token('INV',TO_CHAR(l_inv_item_id));
9660: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9661: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9662: RAISE FND_API.G_EXC_ERROR;
9663: END IF;
9664: IF l_sys_dt < NVL(l_start_dt,l_sys_dt) OR
9665: l_sys_dt > NVL(l_end_dt ,l_sys_dt)
9666: THEN
9667: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_INACTIVE'); --Item associated with CP is inactive
9668: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9669: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9670: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9671: RAISE FND_API.G_EXC_ERROR;
9672: END IF;
9673: -- All validations succeeded, so assign item for CP to p_inventory_item_id
9674: p_inventory_item_id := l_inv_item_id;
9687: THEN
9688: FND_MESSAGE.set_name('CS','CS_SR_CP_LAST_VLD_ORG'); -- Last validation org does not exists
9689: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9690: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(l_last_vld_org_id));
9691: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9692: RAISE FND_API.G_EXC_ERROR;
9693: END IF;
9694: /* last vlg org may not be eam enabled but it might be maintained bu maint org
9695: so no need for this check
9696: IF l_eam_enabled_flag <> 'Y'
9697: THEN
9698: FND_MESSAGE.set_name('CS','CS_SR_CP_MAINT_EAM'); -- Maintenance Organization is NOT Eam Enabled
9699: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9700: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9701: RAISE FND_API.G_EXC_ERROR;
9702: END IF;
9703: */
9704: IF l_maint_org_id <> p_maint_organization_id
9706: FND_MESSAGE.set_name('CS','CS_SR_LVD_ORG_NOT_MAINT_BY'); -- CP is not maintained by Maintenance Organization
9707: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9708: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9709: FND_MESSAGE.set_token('VAL_ORG_ID',TO_CHAR(l_maint_org_id));
9710: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9711: RAISE FND_API.G_EXC_ERROR;
9712: END IF;
9713: IF p_inv_org_master_org_flag = 'Y' AND
9714: l_master_org_id <> p_inventory_org_id
9714: l_master_org_id <> p_inventory_org_id
9715: THEN
9716: FND_MESSAGE.set_name('CS','CS_SR_VLD_INV_ORG_MISMATCH');
9717: FND_MESSAGE.set_token('VAL_ORG',TO_CHAR(l_maint_org_id));
9718: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9719: RAISE FND_API.G_EXC_ERROR;
9720: END IF;
9721: END IF; -- p_maint_organization check
9722: --
9852: FND_MESSAGE.set_token
9853: ( 'P_TEXT'
9854: , 'CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM
9855: );
9856: FND_MSG_PUB.ADD;
9857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9858: END get_reacted_resolved_dates;
9859: -- -----------------------------------------------------------------------------
9860: -- Procedure Name : get_party_details
9903: fnd_message.set_token
9904: ( 'P_TEXT'
9905: , 'CS_SERVICEREQUEST_UTIL.get_party_detail:'||'-'||SQLERRM
9906: );
9907: fnd_msg_pub.ADD;
9908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9909:
9910: END get_party_details;
9911: -- -----------------------------------------------------------------------------
9985: FND_MESSAGE.set_token
9986: ( 'API_NAME'
9987: , 'CS_SERVICEREQUEST_UTIL.update_task_address'
9988: );
9989: FND_MSG_PUB.ADD_DETAIL
9990: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_location_id'
9991: );
9992: RAISE FND_API.G_EXC_ERROR;
9993: END IF;
10192:
10193: EXCEPTION
10194: WHEN loc_update_not_alwd_exp THEN
10195: FND_MESSAGE.SET_Name('CS','CS_SR_LOC_UPD_NOT_ALLWD');
10196: FND_MSG_PUB.ADD;
10197: x_return_status := FND_API.G_RET_STS_ERROR;
10198: WHEN FND_API.G_EXC_ERROR THEN
10199: x_return_status := FND_API.G_RET_STS_ERROR;
10200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10344:
10345: WHEN OTHERS THEN
10346: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10347: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10348: fnd_msg_pub.ADD;
10349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10350:
10351: END Validate_Platform_Version_Id;
10352: