[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: /*
871: p_column_name => 'RMA_NUMBER' );
872: WHEN OTHERS THEN
873: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
874: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
875: fnd_msg_pub.ADD;
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: END Convert_RMA_Number_To_ID;
878: */
879:
921: p_column_name => 'CREATED_BY');
922: WHEN OTHERS THEN
923: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
924: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
925: fnd_msg_pub.ADD;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
927:
928: RETURN;
929: END;
946:
947: WHEN OTHERS THEN
948: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
949: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
950: fnd_msg_pub.ADD;
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
952: END;
953: END IF;
954: END Validate_Who_Info;
1016: CLOSE val_type_map;
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: fnd_message.set_name ('CS', 'CS_SR_TYPE_BY_RESP');
1019: fnd_message.set_token ('OPERATION',p_operation);
1020: fnd_msg_pub.ADD;
1021: ELSE
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023: --Fixed bug 2809312, moved this close cursor here from
1024: --after the if.
1051:
1052: WHEN OTHERS THEN
1053: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1054: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1055: fnd_msg_pub.ADD;
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1057: END Validate_Type;
1058:
1059: *******************************/
1129: -- new message for 11.5.10
1130: -- You do not have access to the service request type that is
1131: -- being created. Please contact your system administrator.
1132: fnd_message.set_name ('CS', 'CS_SR_WEB_NO_PRIV');
1133: fnd_msg_pub.ADD;
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: end if;
1136: else
1137: -- For bug 3474365 - included an if condition while called for validating old sr type
1147: -- Invalid type. Given type is either end dated or does not exist
1148: -- as a valid type.
1149: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1150: fnd_message.set_token('API_NAME', l_api_name_full);
1151: fnd_msg_pub.ADD;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1154: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1155: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1154: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1155: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1156: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1157: fnd_message.set_token('API_NAME', l_api_name_full);
1158: fnd_msg_pub.ADD;
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: else
1161: l_flags_set := 'Y';
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172: -- Invalid type. Given type is either end dated or does not exist
1173: -- as a valid type.
1174: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1175: fnd_message.set_token('API_NAME', l_api_name_full);
1176: fnd_msg_pub.ADD;
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: else
1179: l_flags_set := 'Y';
1180: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198: -- Current responsibility does not have sufficient priviledges to access
1199: -- service requests of this type. Please contact your system administrator.
1200: fnd_message.set_name ('CS', 'CS_SR_AGENT_NO_PRIV');
1201: fnd_message.set_token('API_NAME', l_api_name_full);
1202: fnd_msg_pub.ADD;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1205: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1206: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1204: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1205: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1206: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1207: fnd_message.set_token('API_NAME', l_api_name_full);
1208: fnd_msg_pub.ADD;
1209: x_return_status := FND_API.G_RET_STS_ERROR;
1210: else
1211: l_flags_set := 'Y';
1212: x_return_status := FND_API.G_RET_STS_SUCCESS;
1223: -- For bug 3902711
1224: --fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1225: fnd_message.set_name ('CS', 'CS_SR_AGENT_NO_PRIV');
1226: fnd_message.set_token('API_NAME', l_api_name_full);
1227: fnd_msg_pub.ADD;
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: else
1230: l_flags_set := 'Y';
1231: x_return_status := FND_API.G_RET_STS_SUCCESS;
1254:
1255: WHEN OTHERS THEN
1256: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1257: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1258: fnd_msg_pub.ADD;
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: END Validate_Type;
1261: /*
1262: ** Validate_Status
1400: p_column_name => 'INCIDENT_STATUS_ID' );
1401: WHEN OTHERS THEN
1402: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1403: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1404: fnd_msg_pub.ADD;
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: END Validate_Status;
1407:
1408: /*
1631: p_column_name => 'INCIDENT_STATUS_ID' );
1632: WHEN OTHERS THEN
1633: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1634: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1635: fnd_msg_pub.ADD;
1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1637: END Validate_Updated_Status;
1638:
1639:
1673: p_column_name => 'SEVERITY_ID' );
1674: WHEN OTHERS THEN
1675: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1676: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1677: fnd_msg_pub.ADD;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679:
1680: END;
1681: END Validate_Severity ;
1716: p_column_name => 'URGENCY_ID' );
1717: WHEN OTHERS THEN
1718: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1719: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1720: fnd_msg_pub.ADD;
1721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1722:
1723: END;
1724: END Validate_Urgency;
1758: EXCEPTION
1759: WHEN OTHERS THEN
1760: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1761: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1762: fnd_msg_pub.ADD;
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764:
1765: END Validate_Closed_Date;
1766:
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1788: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1789: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1790: FND_MSG_PUB.ADD;
1791: END IF;
1792: EXCEPTION
1793: WHEN OTHERS THEN
1794: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1792: EXCEPTION
1793: WHEN OTHERS THEN
1794: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1795: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1796: fnd_msg_pub.ADD;
1797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1798:
1799: END Validate_Inc_Reported_Date;
1800:
1816: x_return_status := FND_API.G_RET_STS_ERROR;
1817: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1818: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1819: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1820: FND_MSG_PUB.ADD;
1821: END IF;
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1825: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1826: fnd_msg_pub.ADD;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828:
1829: END Validate_Inc_Occurred_Date;
1830:
1853: EXCEPTION
1854: WHEN OTHERS THEN
1855: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1856: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1857: fnd_msg_pub.ADD;
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859:
1860: END Validate_Inc_Resolved_Date;
1861:
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1887: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1888: fnd_msg_pub.ADD;
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1890:
1891: END Validate_Inc_Responded_Date;
1892:
1960: p_column_name => 'INCIDENT_LOCATION_TYPE' );
1961: WHEN OTHERS THEN
1962: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1963: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1964: fnd_msg_pub.ADD;
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966:
1967: END;
1968: END Validate_Inc_Location_Id;
1998: p_column_name => 'INCIDENT_COUNTRY' );
1999: WHEN OTHERS THEN
2000: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2001: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2002: fnd_msg_pub.ADD;
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004:
2005: END;
2006: END Validate_Incident_Country;
2065:
2066: WHEN OTHERS THEN
2067: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2068: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2069: fnd_msg_pub.ADD;
2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2071: END Validate_Employee;
2072:
2073: -- --------------------------------------------------------------------------------
2115: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_CUSTOMER');
2116: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2117: FND_MESSAGE.Set_Token('VALUE',l_token_v);
2118: FND_MESSAGE.Set_Token('P_NAME', p_parameter_name);
2119: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
2120:
2121:
2122: /* Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
2123: p_token_v => TO_CHAR(p_customer_id),
2126: p_column_name => 'CUSTOMER_ID' ); */
2127: WHEN OTHERS THEN
2128: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2129: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2130: fnd_msg_pub.ADD;
2131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2132:
2133: END;
2134: --Addition for 3666089 starts
2134: --Addition for 3666089 starts
2135: IF (l_party_type <> p_caller_type) THEN
2136: x_return_status := FND_API.G_RET_STS_ERROR;
2137: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_CUST_TYPE');
2138: FND_MSG_PUB.ADD; --3666089 (Jun 15)
2139: END IF;
2140: --Addition for 3666089 Ends
2141:
2142: END Validate_Customer;
2226:
2227: WHEN OTHERS THEN
2228: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2229: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2230: fnd_msg_pub.ADD;
2231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2232:
2233: END Validate_Bill_To_Ship_To_Ct;
2234:
2308:
2309: WHEN OTHERS THEN
2310: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2311: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2312: fnd_msg_pub.ADD;
2313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2314:
2315: END Validate_Customer_Contact;
2316:
2376: p_column_name => 'CUSTOMER_CONTACT_ID' );
2377: WHEN OTHERS THEN
2378: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2379: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2380: fnd_msg_pub.ADD;
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382:
2383: END Validate_Org_Relationship;
2384:
2443: p_column_name => 'CUSTOMER_CONTACT_ID' );
2444: WHEN OTHERS THEN
2445: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2446: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2447: fnd_msg_pub.ADD;
2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2449:
2450: END Validate_Person_Relationship;
2451:
2545:
2546: WHEN OTHERS THEN
2547: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2548: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2549: fnd_msg_pub.ADD;
2550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2551:
2552: END Validate_Customer_Product;
2553:
2648:
2649: WHEN OTHERS THEN
2650: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2651: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2652: fnd_msg_pub.ADD;
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2654:
2655: END Validate_Current_Serial;
2656:
2720: WHEN OTHERS THEN
2721: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2722: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2723: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2724: fnd_msg_pub.ADD;
2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2726:
2727: END Validate_Inventory_Org;
2728:
2769:
2770: WHEN OTHERS THEN
2771: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2772: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2773: fnd_msg_pub.ADD;
2774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2775:
2776: END Validate_Owning_Department;
2777:
2885: );
2886: WHEN OTHERS THEN
2887: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2888: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2889: fnd_msg_pub.ADD;
2890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2891: END Validate_Product;
2892:
2893:
2952: -- Problem code is not valid. Please check the values for the following:\
2953: -- Service request type, inventory item and product category.
2954: fnd_message.set_name ('CS', 'CS_SR_PROB_CODE_INVALID');
2955: fnd_message.set_token('API_NAME', l_api_name_full );
2956: fnd_msg_pub.add;
2957: end if;
2958:
2959:
2960: EXCEPTION
2960: EXCEPTION
2961: WHEN OTHERS THEN
2962: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2963: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2964: fnd_msg_pub.ADD;
2965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2966:
2967: END Validate_Problem_Code;
2968:
3002: p_column_name => 'CUST_PERF_LANG_CODE');
3003: WHEN OTHERS THEN
3004: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3005: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3006: fnd_msg_pub.ADD;
3007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3008:
3009: END;
3010: END Validate_Cust_Pref_Lang_Code;
3042: p_column_name => 'COMM_PREF_CODE' );
3043: WHEN OTHERS THEN
3044: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3045: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3046: fnd_msg_pub.ADD;
3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3048: END;
3049: END Validate_Comm_Pref_Code;
3050:
3104: x_return_status := FND_API.G_RET_STS_ERROR;
3105: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3106: fnd_message.set_token ('CAT_SET',nvl(l_profile,'NULL'));
3107: fnd_message.set_token ('CAT_ID',p_category_id);
3108: fnd_msg_pub.ADD;
3109: WHEN OTHERS THEN
3110: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3111: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3112: fnd_msg_pub.ADD;
3108: fnd_msg_pub.ADD;
3109: WHEN OTHERS THEN
3110: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3111: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3112: fnd_msg_pub.ADD;
3113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3114:
3115: END;
3116: END Validate_Category_Id;
3171: fnd_message.set_name ('CS', 'CS_SR_CAT_ITEM_COMB_INVALID');
3172: fnd_message.set_token ('CAT_SET',p_category_set_id);
3173: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3174: fnd_message.set_token ('ITEM_ID',nvl(to_char(p_inventory_item_id),'NULL'));
3175: fnd_msg_pub.ADD;
3176: ELSE
3177: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3178: fnd_message.set_token ('CAT_SET',p_category_set_id);
3179: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3176: ELSE
3177: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3178: fnd_message.set_token ('CAT_SET',p_category_set_id);
3179: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3180: fnd_msg_pub.ADD;
3181: END IF;
3182: WHEN OTHERS THEN
3183: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3184: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3181: END IF;
3182: WHEN OTHERS THEN
3183: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3184: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3185: fnd_msg_pub.ADD;
3186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3187:
3188: END Validate_Category_Set_Id;
3189:
3324: p_column_name => 'EXTERNAL_REFERENCE');
3325: WHEN OTHERS THEN
3326: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3327: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3328: fnd_msg_pub.ADD;
3329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3330:
3331: END Validate_External_Reference;
3332:
3363: p_column_name => 'SYSTEM_ID' );
3364: WHEN OTHERS THEN
3365: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3366: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3367: fnd_msg_pub.ADD;
3368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3369:
3370: END Validate_System_Id;
3371:
3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3407: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3408: fnd_msg_pub.ADD;
3409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3410:
3411: END Validate_Exp_Resolution_Date;
3412:
3483: p_column_name => 'BILL_TO_CUSTOMER_ID');
3484: WHEN OTHERS THEN
3485: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3486: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3487: fnd_msg_pub.ADD;
3488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3489: END Validate_Bill_To_Ship_To_Party;
3490:
3491: -- --------------------------------------------------------------------------------
3547: p_column_name => 'BILL_TO_SITE_ID' );
3548: WHEN OTHERS THEN
3549: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3550: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3551: fnd_msg_pub.ADD;
3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3553: END Validate_Bill_To_Ship_To_Site ;
3554:
3555:
3617:
3618: WHEN OTHERS THEN
3619: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3620: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3621: fnd_msg_pub.ADD;
3622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3623:
3624: END;
3625:
3657: p_column_name => 'RESOLUTION_CODE' );
3658: WHEN OTHERS THEN
3659: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3660: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3661: fnd_msg_pub.ADD;
3662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3663:
3664: END Validate_Resolution_Code;
3665:
3694: EXCEPTION
3695: WHEN OTHERS THEN
3696: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3697: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3698: fnd_msg_pub.ADD;
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700:
3701: END Validate_Act_Resolution_Date;
3702:
3762:
3763: WHEN OTHERS THEN
3764: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3765: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3766: fnd_msg_pub.ADD;
3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3768: END Validate_Contract_Service_Id;
3769: ---------------------------------------------------------------------------
3770:
3800:
3801: WHEN OTHERS THEN
3802: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3803: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3804: fnd_msg_pub.ADD;
3805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3806:
3807:
3808: END Validate_Contract_Id;
3860:
3861: WHEN OTHERS THEN
3862: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3863: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3864: fnd_msg_pub.ADD;
3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3866: END Validate_Support_Site_Id;
3867: ---------------------------------------------------------
3868:
3907:
3908: WHEN OTHERS THEN
3909: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3910: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3911: fnd_msg_pub.ADD;
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3913:
3914:
3915: END Validate_Group_Type;
3966:
3967: WHEN OTHERS THEN
3968: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3969: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3970: fnd_msg_pub.ADD;
3971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3972: END Validate_Group_Id;
3973:
3974: ----------------------------------------
4081: END IF;
4082: WHEN OTHERS THEN
4083: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4084: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4085: fnd_msg_pub.ADD;
4086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4087: END Validate_Owner;
4088:
4089: ------------------------------------------------------
4121:
4122: WHEN OTHERS THEN
4123: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4124: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4125: fnd_msg_pub.ADD;
4126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4127: END Validate_Resource_Type;
4128:
4129: ----------------------------------------------------
4180:
4181: WHEN OTHERS THEN
4182: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4183: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4184: fnd_msg_pub.ADD;
4185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4186:
4187: END Validate_Platform_Id;
4188:
4222:
4223: WHEN OTHERS THEN
4224: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4225: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4226: fnd_msg_pub.ADD;
4227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4228:
4229: END Validate_CP_Comp_Id;
4230:
4274:
4275: WHEN OTHERS THEN
4276: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4277: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4278: fnd_msg_pub.ADD;
4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4280: END;
4281: END IF;
4282: EXCEPTION
4373: p_column_name => 'COMPONENT_VERSION' );
4374: WHEN OTHERS THEN
4375: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4376: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4377: fnd_msg_pub.ADD;
4378: x_return_status := fnd_api.g_ret_sts_unexp_error;
4379: END Validate_product_Version;
4380: --
4381: -- Validate Component Version
4445:
4446: WHEN OTHERS THEN
4447: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4448: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4449: fnd_msg_pub.ADD;
4450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4451: END;
4452: END IF;
4453:
4464: p_column_name => 'COMPONENT_VERSION' );
4465: WHEN OTHERS THEN
4466: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4467: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4468: fnd_msg_pub.ADD;
4469: x_return_status := fnd_api.g_ret_sts_unexp_error;
4470: END;
4471: END Validate_Component_Version;
4472:
4536:
4537: WHEN OTHERS THEN
4538: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4539: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4540: fnd_msg_pub.ADD;
4541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4542: END;
4543: END IF;
4544:
4554: p_column_name => 'SUBCOMPONENT_VERSION');
4555: WHEN OTHERS THEN
4556: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4557: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4558: fnd_msg_pub.ADD;
4559: x_return_status := fnd_api.g_ret_sts_unexp_error;
4560: END;
4561: END Validate_Subcomponent_Version;
4562: ----------------------------------------------------------------------------------
4606:
4607: WHEN OTHERS THEN
4608: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4609: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4610: fnd_msg_pub.ADD;
4611: x_return_status := fnd_api.g_ret_sts_unexp_error;
4612:
4613: END Validate_CP_SubComp_Id;
4614:
4659: p_column_name => 'INV_ITEM_REVISION' );
4660: WHEN OTHERS THEN
4661: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4662: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4663: fnd_msg_pub.ADD;
4664: x_return_status := fnd_api.g_ret_sts_unexp_error;
4665:
4666: END;
4667: END IF;
4677:
4678: WHEN OTHERS THEN
4679: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4680: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4681: fnd_msg_pub.ADD;
4682: x_return_status := fnd_api.g_ret_sts_unexp_error;
4683:
4684: END;
4685: END Validate_Inv_Item_Rev;
4742: p_column_name => 'INV_COMPONENT_ID' );
4743: WHEN OTHERS THEN
4744: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4745: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4746: fnd_msg_pub.ADD;
4747: x_return_status := fnd_api.g_ret_sts_unexp_error;
4748:
4749: END Validate_Inv_Comp_Id;
4750: -----------------------------------------
4865:
4866: WHEN OTHERS THEN
4867: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4868: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4869: fnd_msg_pub.ADD;
4870: x_return_status := fnd_api.g_ret_sts_unexp_error;
4871:
4872: END Validate_Inv_SubComp_Id;
4873: -------------------------------------
4916: p_column_name => 'INV_SUBCOMPONENT_VERSION' );
4917: WHEN OTHERS THEN
4918: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4919: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4920: fnd_msg_pub.ADD;
4921: x_return_status := fnd_api.g_ret_sts_unexp_error;
4922:
4923: END Validate_Inv_SubComp_Ver;
4924:
4955: p_column_name => 'SR_CREATION_CHANNEL' );
4956: WHEN OTHERS THEN
4957: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4958: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4959: fnd_msg_pub.ADD;
4960: x_return_status := fnd_api.g_ret_sts_unexp_error;
4961:
4962: END Validate_SR_Channel;
4963: ---------------------------------------------------------------------------------
4994: p_column_name => 'LANGUAGE_ID');
4995: WHEN OTHERS THEN
4996: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4997: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4998: fnd_msg_pub.ADD;
4999: x_return_status := fnd_api.g_ret_sts_unexp_error;
5000:
5001: END Validate_CP_Language_Id;
5002: ---------------------------------------------------------------------------------------------
5033: p_column_name => 'TERRITORY_ID');
5034: WHEN OTHERS THEN
5035: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5036: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5037: fnd_msg_pub.ADD;
5038: x_return_status := fnd_api.g_ret_sts_unexp_error;
5039:
5040: END Validate_Territory_Id;
5041:
5076: -- party ,contact point and contact point type.
5077:
5078: fnd_message.set_name ('CS', 'CS_SR_CONT_POINT_INVALID');
5079: fnd_message.set_token('API_NAME', l_api_name_full );
5080: fnd_msg_pub.add;
5081:
5082: WHEN OTHERS THEN
5083: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5084: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5081:
5082: WHEN OTHERS THEN
5083: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5084: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5085: fnd_msg_pub.ADD;
5086: x_return_status := fnd_api.g_ret_sts_unexp_error;
5087:
5088: END Validate_Per_Contact_Point_Id;
5089: ---------------------------------------
5122: p_column_name => 'CONTACT_POINT_ID');
5123: WHEN OTHERS THEN
5124: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5125: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5126: fnd_msg_pub.ADD;
5127: x_return_status := fnd_api.g_ret_sts_unexp_error;
5128:
5129: END Validate_Emp_Contact_Point_Id;
5130: -----------------------------------------------------------------
5163: p_column_name => 'CONTACT_POINT_TYPE');
5164: WHEN OTHERS THEN
5165: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5166: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5167: fnd_msg_pub.ADD;
5168: x_return_status := fnd_api.g_ret_sts_unexp_error;
5169: END Validate_Contact_Point_Type;
5170:
5171: -- Validate Contact Type
5202: p_column_name => 'CONTACT_TYPE');
5203: WHEN OTHERS THEN
5204: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5205: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5206: fnd_msg_pub.ADD;
5207: x_return_status := fnd_api.g_ret_sts_unexp_error;
5208: END Validate_Contact_Type;
5209: ---------------------------------------
5210:
5243: p_column_name => 'ACCOUNT_ID');
5244: WHEN OTHERS THEN
5245: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5246: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5247: fnd_msg_pub.ADD;
5248: x_return_status := fnd_api.g_ret_sts_unexp_error;
5249:
5250: END Validate_Account_Id;
5251:
5303: p_token_dfm VARCHAR2
5304: )
5305: IS
5306: BEGIN
5307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5308: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5309: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5310: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5311: FND_MSG_PUB.ADD;
5307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5308: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5309: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5310: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5311: FND_MSG_PUB.ADD;
5312: END IF;
5313: END Add_Desc_Flex_Msg;
5314:
5315:
5336: end if;
5337: -- end for bug 2833245
5338:
5339:
5340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5341: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5342: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5343: --bug 2833245 pass the local variable for setting the token
5344: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5343: --bug 2833245 pass the local variable for setting the token
5344: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5345: -- end for bug 2833245
5346: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5347: FND_MSG_PUB.ADD;
5348: END IF;
5349: END Add_Invalid_Argument_Msg;
5350:
5351:
5364: p_token_kfm VARCHAR2
5365: )
5366: IS
5367: BEGIN
5368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5369: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5370: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5371: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5372: FND_MSG_PUB.ADD;
5368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5369: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5370: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5371: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5372: FND_MSG_PUB.ADD;
5373: END IF;
5374: END Add_Key_Flex_Msg;
5375:
5376:
5383: p_token_np VARCHAR2
5384: )
5385: IS
5386: BEGIN
5387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5388: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5389: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5390: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5391: FND_MSG_PUB.ADD;
5387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5388: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5389: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5390: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5391: FND_MSG_PUB.ADD;
5392: END IF;
5393: END Add_Null_Parameter_Msg;
5394:
5395:
5402: p_token_ip VARCHAR2
5403: )
5404: IS
5405: BEGIN
5406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5407: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
5408: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5409: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
5410: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5407: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
5408: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5409: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
5410: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5411: END IF;
5412: END Add_Param_Ignored_Msg;
5413:
5414:
5423: p_token_pv VARCHAR2
5424: )
5425: IS
5426: BEGIN
5427: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5428: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CP_FLAG_IGNORED');
5429: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5430: FND_MESSAGE.Set_Token('VALUE', p_token_ip);
5431: FND_MESSAGE.Set_Token('DEFAULT_VALUE', p_token_pv);
5428: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CP_FLAG_IGNORED');
5429: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5430: FND_MESSAGE.Set_Token('VALUE', p_token_ip);
5431: FND_MESSAGE.Set_Token('DEFAULT_VALUE', p_token_pv);
5432: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5433: END IF;
5434: END Add_Cp_Flag_Ignored_Msg;
5435:
5436:
5441: PROCEDURE Add_Duplicate_Value_Msg( p_token_an IN VARCHAR2,
5442: p_token_p IN VARCHAR2 ) IS
5443:
5444: BEGIN
5445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5446: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
5447: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5448: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
5449: FND_MSG_PUB.ADD;
5445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5446: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
5447: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5448: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
5449: FND_MSG_PUB.ADD;
5450: END IF;
5451: END Add_Duplicate_Value_Msg;
5452:
5453:
5453:
5454: PROCEDURE Add_Same_Val_Update_Msg( p_token_an IN VARCHAR2,
5455: p_token_p IN VARCHAR2 ) IS
5456: BEGIN
5457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5458: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
5459: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5460: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
5461: FND_MSG_PUB.ADD;
5457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5458: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
5459: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5460: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
5461: FND_MSG_PUB.ADD;
5462: END IF;
5463: END Add_Same_Val_Update_Msg;
5464:
5465:
5465:
5466: PROCEDURE Add_Missing_Param_Msg( p_token_an IN VARCHAR2,
5467: p_token_mp IN VARCHAR2 ) IS
5468: BEGIN
5469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5470: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5471: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5472: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5473: FND_MSG_PUB.ADD;
5469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5470: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5471: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5472: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5473: FND_MSG_PUB.ADD;
5474: END IF;
5475: END Add_Missing_Param_Msg;
5476:
5477:
5514:
5515: WHEN OTHERS THEN
5516: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5517: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5518: fnd_msg_pub.ADD;
5519: x_return_status := fnd_api.g_ret_sts_unexp_error;
5520:
5521: END call_internal_hook ;
5522:
5566:
5567: WHEN OTHERS THEN
5568: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5569: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5570: fnd_msg_pub.ADD;
5571: x_return_status := fnd_api.g_ret_sts_unexp_error;
5572: END Validate_Bill_To_Ship_To_Acct ;
5573:
5574: -- -----------------------------------------------------------------------
5631:
5632: WHEN OTHERS THEN
5633: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5634: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5635: fnd_msg_pub.ADD;
5636: x_return_status := fnd_api.g_ret_sts_unexp_error;
5637: END Validate_source_program_Code;
5638: -- -----------------------------------------------------------------------
5639: -- Start of Comments
5693:
5694: WHEN OTHERS THEN
5695: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5696: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5697: fnd_msg_pub.ADD;
5698: x_return_status := fnd_api.g_ret_sts_unexp_error;
5699:
5700:
5701: END Validate_INC_DIST_QUAL_UOM;
5760:
5761: WHEN OTHERS THEN
5762: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5763: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5764: fnd_msg_pub.ADD;
5765: x_return_status := fnd_api.g_ret_sts_unexp_error;
5766:
5767:
5768: END Validate_INC_DIRECTION_QUAL;
5787: IS
5788: l_associated_col1 VARCHAR2(240);
5789:
5790: BEGIN
5791: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5792:
5793: IF p_table_name IS NOT NULL THEN
5794: l_associated_col1 := p_table_name ;
5795: IF p_column_name IS NOT NULL THEN
5803:
5804: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5805: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5806: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5807: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5808:
5809: END IF;
5810: END Add_Desc_Flex_Msg;
5811:
5838: --bug 2833245 created a new local variable for assigning the value as NULL
5839: l_token_v VARCHAR2(4000);
5840: --end for bug 2833245
5841: BEGIN
5842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5843:
5844: IF p_table_name IS NOT NULL THEN
5845: l_associated_col1 := p_table_name ;
5846: IF p_column_name IS NOT NULL THEN
5864: --bug 2833245 pass the local variable for setting the token
5865: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5866: -- end for bug 2833245
5867: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5868: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5869:
5870: --For bug 2885111 - to remove the blank message
5871: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5872: END IF;
5867: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5868: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5869:
5870: --For bug 2885111 - to remove the blank message
5871: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5872: END IF;
5873: END Add_Invalid_Argument_Msg;
5874:
5875:
5894: )
5895: IS
5896: l_associated_col1 VARCHAR2(240);
5897: BEGIN
5898: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5899:
5900: IF p_table_name IS NOT NULL THEN
5901: l_associated_col1 := p_table_name ;
5902: IF p_column_name IS NOT NULL THEN
5909: END IF ;
5910: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5911: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5912: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5913: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5914: END IF;
5915: END Add_Key_Flex_Msg;
5916:
5917: --------------------------------------------------------------------------
5936: p_table_name IN VARCHAR2 ,
5937: p_column_name IN VARCHAR2 ) IS
5938: l_associated_col1 VARCHAR2(240);
5939: BEGIN
5940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5941:
5942: IF p_table_name IS NOT NULL THEN
5943: l_associated_col1 := p_table_name ;
5944: IF p_column_name IS NOT NULL THEN
5951: END IF ;
5952: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5953: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5954: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5955: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5956: END IF;
5957: END Add_Missing_Param_Msg;
5958:
5959: --------------------------------------------------------------------------
5980: )
5981: IS
5982: l_associated_col1 VARCHAR2(240);
5983: BEGIN
5984: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5985:
5986: IF p_table_name IS NOT NULL THEN
5987: l_associated_col1 := p_table_name ;
5988: IF p_column_name IS NOT NULL THEN
5995: END IF ;
5996: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5997: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5998: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5999: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6000: END IF;
6001: END Add_Null_Parameter_Msg;
6002:
6003: --------------------------------------------------------------------------
6024: )
6025: IS
6026: l_associated_col1 VARCHAR2(240);
6027: BEGIN
6028: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6029:
6030: IF p_table_name IS NOT NULL THEN
6031: l_associated_col1 := p_table_name ;
6032: IF p_column_name IS NOT NULL THEN
6039: END IF ;
6040: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
6041: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6042: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
6043: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6044: END IF;
6045: END Add_Param_Ignored_Msg;
6046:
6047: --------------------------------------------------------------------------
6067: p_column_name IN VARCHAR2 ) IS
6068: l_associated_col1 VARCHAR2(240);
6069:
6070: BEGIN
6071: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6072:
6073: IF p_table_name IS NOT NULL THEN
6074: l_associated_col1 := p_table_name ;
6075: IF p_column_name IS NOT NULL THEN
6082: END IF ;
6083: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
6084: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6085: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
6086: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6087: END IF;
6088: END Add_Duplicate_Value_Msg;
6089:
6090: --------------------------------------------------------------------------
6109: p_table_name IN VARCHAR2 ,
6110: p_column_name IN VARCHAR2 ) IS
6111: l_associated_col1 VARCHAR2(240);
6112: BEGIN
6113: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6114:
6115: IF p_table_name IS NOT NULL THEN
6116: l_associated_col1 := p_table_name ;
6117: IF p_column_name IS NOT NULL THEN
6124: END IF ;
6125: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
6126: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6127: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
6128: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1,
6129: p_message_type => FND_MSG_PUB.G_WARNING_MSG);
6130: END IF;
6131: END Add_Same_Val_Update_Msg;
6132:
6125: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
6126: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6127: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
6128: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1,
6129: p_message_type => FND_MSG_PUB.G_WARNING_MSG);
6130: END IF;
6131: END Add_Same_Val_Update_Msg;
6132:
6133: -- -----------------------------------------------------------------------------
6197:
6198: WHEN OTHERS THEN
6199: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6200: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6201: fnd_msg_pub.add;
6202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6203: END Validate_Site_Site_Use ;
6204:
6205: -- -----------------------------------------------------------------------------
6261:
6262: WHEN OTHERS THEN
6263: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6264: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6265: fnd_msg_pub.add;
6266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6267: END Validate_Bill_Ship_Site_Use;
6268:
6269:
6312: -- service request type may invalidate some of the task assignments.
6313: -- Please verify that the task owners are valid for the new service
6314: -- request type.
6315: fnd_message.set_name ('CS', 'CS_SR_TASK_OWNER_INVALID');
6316: fnd_msg_pub.ADD;
6317: end if;
6318: end if;
6319:
6320: EXCEPTION
6321: WHEN OTHERS THEN
6322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6323: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6324: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6325: fnd_msg_pub.add;
6326:
6327: END TASK_OWNER_CROSS_VAL;
6328:
6329: -- KP API Cleanup; added new proc
6355: x_return_status := FND_API.G_RET_STS_ERROR;
6356: fnd_message.set_name ('CS', 'CS_INVALID_INC_LOCATION');
6357: fnd_message.set_token('INCIDENT_LOCATION_ID', p_incident_location_id);
6358: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6359: fnd_msg_pub.add;
6360:
6361: WHEN OTHERS THEN
6362: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6363: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6360:
6361: WHEN OTHERS THEN
6362: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6363: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6364: fnd_msg_pub.add;
6365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6366:
6367: END CP_INCIDENT_SITE_CROSS_VAL;
6368:
6400: x_return_status := FND_API.G_RET_STS_ERROR;
6401: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6402: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
6403: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6404: fnd_msg_pub.add;
6405: END IF;
6406: END IF;
6407:
6408: EXCEPTION
6410: x_return_status := FND_API.G_RET_STS_ERROR;
6411: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6412: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
6413: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6414: fnd_msg_pub.add;
6415:
6416: WHEN OTHERS THEN
6417: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6418: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6415:
6416: WHEN OTHERS THEN
6417: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6418: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6419: fnd_msg_pub.add;
6420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6421:
6422: END CP_INSTALL_SITE_CROSS_VAL;
6423:
6473: -- Resolution code is not valid. Please check the values for the following:
6474: -- Service request type, inventory item, product category and problem code.
6475: fnd_message.set_name ('CS', 'CS_SR_RES_CODE_INVALID');
6476: fnd_message.set_token('API_NAME', l_api_name_full );
6477: fnd_msg_pub.add;
6478: end if;
6479:
6480: EXCEPTION
6481: WHEN OTHERS THEN
6480: EXCEPTION
6481: WHEN OTHERS THEN
6482: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6483: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6484: fnd_msg_pub.add;
6485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6486:
6487: END Resolution_Code_Cross_Val;
6488:
6525: x_return_status := FND_API.G_RET_STS_ERROR;
6526: -- This service request has open dependent tasks. Please close these
6527: -- tasks before closing the service request.
6528: fnd_message.set_name ('CS', 'CS_SR_CANNOT_CLOSE_SR');
6529: fnd_msg_pub.add;
6530: end if;
6531:
6532: END IF;
6533:
6534: EXCEPTION
6535: WHEN OTHERS THEN
6536: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6537: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6538: fnd_msg_pub.add;
6539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6540:
6541: END TASK_RESTRICT_CLOSE_CROSS_VAL;
6542:
6699: -- Service request type, inventory item, instance, account and
6700: -- install site.
6701: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6702: --fnd_message.set_token('API_NAME', l_api_name_full );
6703: --fnd_msg_pub.add;
6704: END IF;
6705: ELSE -- For BUG 3665768
6706: x_return_status := FND_API.G_RET_STS_ERROR;
6707: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6705: ELSE -- For BUG 3665768
6706: x_return_status := FND_API.G_RET_STS_ERROR;
6707: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6708: --fnd_message.set_token('API_NAME', l_api_name_full );
6709: --fnd_msg_pub.add;
6710: END IF; -- IF ( lx_return_status = FND_API.G_RET_STS_SUCCESS ) then
6711: *************** when bug 4109990 is fixed, uncomment this part *********/
6712:
6713: EXCEPTION
6713: EXCEPTION
6714: WHEN OTHERS THEN
6715: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6716: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6717: fnd_msg_pub.add;
6718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6719:
6720: END CONTRACTS_CROSS_VAL;
6721:
6755:
6756: WHEN OTHERS THEN
6757: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6758: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6759: fnd_msg_pub.add;
6760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6761:
6762: END INV_COMPONENT_CROSS_VAL;
6763:
6796:
6797: WHEN OTHERS THEN
6798: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6799: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6800: fnd_msg_pub.add;
6801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6802:
6803: END INV_SUBCOMPONENT_CROSS_VAL;
6804:
6900: -- The system could not update the Type. The Type cannot be changed from a
6901: -- Maintenance Type to a non-Maintenance Type.
6902: fnd_message.set_name ('CS', 'CS_SR_DISALLOW_TYPE_UPD_1');
6903: fnd_message.set_token('API_NAME', l_api_name_full );
6904: fnd_msg_pub.add;
6905: else
6906: -- new message for 11.5.10
6907: -- The system could not update the Type. The Type cannot be changed from a
6908: -- non-Maintenance Type to a Maintenance Type.
6907: -- The system could not update the Type. The Type cannot be changed from a
6908: -- non-Maintenance Type to a Maintenance Type.
6909: fnd_message.set_name ('CS', 'CS_SR_DISALLOW_TYPE_UPD_2');
6910: fnd_message.set_token('API_NAME', l_api_name_full );
6911: fnd_msg_pub.add;
6912: end if;
6913: else
6914: x_return_status := FND_API.G_RET_STS_SUCCESS;
6915: end if;
6919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6920:
6921: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6922: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6923: FND_MSG_PUB.ADD;
6924:
6925: END VALIDATE_TYPE_CHANGE;
6926:
6927:
7476: -- Invalid type. Given type is either end dated or does not exist
7477: -- as a valid type.
7478: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
7479: fnd_message.set_token('API_NAME', l_api_name_full);
7480: fnd_msg_pub.ADD;
7481: lx_return_status := FND_API.G_RET_STS_ERROR;
7482: end;
7483:
7484: if ( lx_return_status = FND_API.G_RET_STS_SUCCESS ) then
7751: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
7752: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7753: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
7754: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7755: fnd_msg_pub.ADD;
7756: x_return_status := FND_API.G_RET_STS_ERROR;
7757: RETURN;
7758: END IF;
7759: END IF;
7790: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
7791: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7792: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
7793: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7794: fnd_msg_pub.ADD;
7795: x_return_status := FND_API.G_RET_STS_ERROR;
7796: RETURN;
7797: END IF;
7798: END IF;
7829:
7830: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7831: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
7832: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7833: fnd_msg_pub.ADD;
7834:
7835: x_return_status := FND_API.G_RET_STS_ERROR;
7836: RETURN;
7837: END IF;
7867:
7868: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7869: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
7870: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7871: fnd_msg_pub.ADD;
7872:
7873: x_return_status := FND_API.G_RET_STS_ERROR;
7874: RETURN;
7875: END IF;
8463: l_sto_party_id IS NULL) THEN
8464: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8465: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
8466: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
8467: fnd_msg_pub.ADD;
8468: x_return_status := FND_API.G_RET_STS_ERROR;
8469: RETURN;
8470: END IF;
8471: END IF;
8630: l_bto_party_id IS NULL) THEN
8631: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8632: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
8633: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
8634: fnd_msg_pub.ADD;
8635: x_return_status := FND_API.G_RET_STS_ERROR;
8636: RETURN;
8637: END IF;
8638: END IF;
8728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8729:
8730: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
8731: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
8732: FND_MSG_PUB.ADD;
8733:
8734: END SERVICEREQUEST_CROSS_VAL;
8735:
8736:
9341: x_return_status := FND_API.G_RET_STS_ERROR;
9342: FND_MESSAGE.set_name('CS','CS_SR_PARTY_ROLE_NE');
9343: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9344: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9345: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9346: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
9347: ELSIF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9348: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9349: THEN
9342: FND_MESSAGE.set_name('CS','CS_SR_PARTY_ROLE_NE');
9343: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9344: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9345: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9346: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
9347: ELSIF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9348: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9349: THEN
9350: x_return_status := FND_API.G_RET_STS_ERROR;
9350: x_return_status := FND_API.G_RET_STS_ERROR;
9351: FND_MESSAGE.set_name('CS','CS_SR_PARTYROLE_INACTIVE');
9352: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9353: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9354: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9355: END IF;
9356: CLOSE c_party_role;
9357: END IF;
9358: --
9363: CLOSE c_party_role;
9364: END IF;
9365: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9366: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.validate_party_role_code'||'-'||SQLERRM);
9367: FND_MSG_PUB.ADD;
9368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9369: END validate_party_role_code;
9370: -- -----------------------------------------------------------------------------
9371: -- Procedure Name : validate_org_id
9409: THEN
9410: FND_MESSAGE.set_name ('CS', 'CS_SR_ORG_ID_INACTIVE');
9411: FND_MESSAGE.set_token ('API_NAME', 'CS_SERVICEREQUEST_UTIL.validate_org_id');
9412: FND_MESSAGE.set_token ('ORG_ID', p_org_id);
9413: FND_MSG_PUB.ADD;
9414: x_return_status := FND_API.G_RET_STS_ERROR;
9415: END IF;
9416: EXCEPTION
9417: WHEN NO_DATA_FOUND THEN
9425: );
9426: WHEN OTHERS THEN
9427: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9428: fnd_message.set_token ('P_TEXT','cs_servicerequest_util.validate_org_id'||'-'||SQLERRM);
9429: fnd_msg_pub.ADD;
9430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9431: END validate_org_id;
9432: -- -----------------------------------------------------------------------------
9433: -- Procedure Name : validate_maint_organization_id
9489: FND_MESSAGE.set_name ('CS' , 'CS_SR_INV_ORG_NOT_MAINT_BY');
9490: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9491: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9492: FND_MESSAGE.set_token ('INV_ORG_ID' , TO_CHAR(p_inventory_org_id));
9493: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9494: END IF;
9495: ELSE -- inv org is a master org or inv org is not passed
9496: get_org_details
9497: ( p_org_id => p_maint_organization_id
9514: x_return_status := FND_API.G_RET_STS_ERROR;
9515: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_ORG_NON_EAM');
9516: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9517: FND_MESSAGE.set_token ('MAINT_ORG_ID', TO_CHAR(p_maint_organization_id));
9518: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9519: ELSIF p_inventory_org_id IS NOT NULL AND
9520: p_inventory_org_id <> FND_API.G_MISS_NUM AND
9521: p_inventory_org_id <> l_master_org_id
9522: THEN
9523: x_return_status := FND_API.G_RET_STS_ERROR;
9524: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_INV_ORG_MISMATCH');
9525: FND_MESSAGE.set_token ('API_NAME' , l_api_name_full);
9526: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9527: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9528: END IF;
9529: END IF;
9530:
9531: END validate_maint_organization_id;
9629: THEN
9630: FND_MESSAGE.set_name('CS','CS_SR_CP_INACTIVE');
9631: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9632: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9633: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9634: RAISE FND_API.G_EXC_ERROR;
9635: END IF;
9636: --
9637: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9640: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9641: FND_MESSAGE.set_token('LOC',l_loc_type);
9642: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9643: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9644: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9645: RAISE FND_API.G_EXC_ERROR;
9646: END IF;
9647: --
9648: IF NVL(l_source_table,'#') <> 'HZ_PARTIES'
9649: THEN
9650: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_SOURCE_INVALID'); -- product is not for TCA parties
9651: FND_MESSAGE.set_token('PARTY_SOURCE',l_source_table);
9652: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9653: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9654: RAISE FND_API.G_EXC_ERROR;
9655: END IF;
9656: --
9657: IF p_customer_id <> NVL(l_party_id,-1)
9662: THEN
9663: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_INVALID'); -- cust not related to product
9664: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9665: FND_MESSAGE.set_token('CUST_ID',TO_CHAR(p_customer_id));
9666: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9667: CLOSE c_prod_rel;
9668: RAISE FND_API.G_EXC_ERROR;
9669: ELSE
9670: CLOSE c_prod_rel;
9691: THEN
9692: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_ID'); -- item associated with CP does not exists
9693: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9694: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9695: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9696: RAISE FND_API.G_EXC_ERROR;
9697: END IF;
9698: IF l_enabled_flag <> 'Y'
9699: THEN
9700: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_DISABLED'); -- item associated with CP is not enabled
9701: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9702: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9703: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9704: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9705: RAISE FND_API.G_EXC_ERROR;
9706: END IF;
9707: IF l_serv_req_enabled <> 'E'
9708: THEN
9709: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_NOT_SERV'); -- item associated with CP is not serviceable
9710: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9711: FND_MESSAGE.set_token('INV',TO_CHAR(l_inv_item_id));
9712: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9713: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9714: RAISE FND_API.G_EXC_ERROR;
9715: END IF;
9716: IF l_sys_dt < NVL(l_start_dt,l_sys_dt) OR
9717: l_sys_dt > NVL(l_end_dt ,l_sys_dt)
9718: THEN
9719: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_INACTIVE'); --Item associated with CP is inactive
9720: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9721: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9722: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9723: RAISE FND_API.G_EXC_ERROR;
9724: END IF;
9725: -- All validations succeeded, so assign item for CP to p_inventory_item_id
9726: p_inventory_item_id := l_inv_item_id;
9739: THEN
9740: FND_MESSAGE.set_name('CS','CS_SR_CP_LAST_VLD_ORG'); -- Last validation org does not exists
9741: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9742: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(l_last_vld_org_id));
9743: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9744: RAISE FND_API.G_EXC_ERROR;
9745: END IF;
9746: /* last vlg org may not be eam enabled but it might be maintained bu maint org
9747: so no need for this check
9748: IF l_eam_enabled_flag <> 'Y'
9749: THEN
9750: FND_MESSAGE.set_name('CS','CS_SR_CP_MAINT_EAM'); -- Maintenance Organization is NOT Eam Enabled
9751: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9752: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9753: RAISE FND_API.G_EXC_ERROR;
9754: END IF;
9755: */
9756: IF l_maint_org_id <> p_maint_organization_id
9758: FND_MESSAGE.set_name('CS','CS_SR_LVD_ORG_NOT_MAINT_BY'); -- CP is not maintained by Maintenance Organization
9759: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9760: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9761: FND_MESSAGE.set_token('VAL_ORG_ID',TO_CHAR(l_maint_org_id));
9762: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9763: RAISE FND_API.G_EXC_ERROR;
9764: END IF;
9765: IF p_inv_org_master_org_flag = 'Y' AND
9766: l_master_org_id <> p_inventory_org_id
9766: l_master_org_id <> p_inventory_org_id
9767: THEN
9768: FND_MESSAGE.set_name('CS','CS_SR_VLD_INV_ORG_MISMATCH');
9769: FND_MESSAGE.set_token('VAL_ORG',TO_CHAR(l_maint_org_id));
9770: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9771: RAISE FND_API.G_EXC_ERROR;
9772: END IF;
9773: END IF; -- p_maint_organization check
9774: --
9915: FND_MESSAGE.set_token
9916: ( 'P_TEXT'
9917: , 'CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM
9918: );
9919: FND_MSG_PUB.ADD;
9920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9921: END get_reacted_resolved_dates;
9922: -- -----------------------------------------------------------------------------
9923: -- Procedure Name : get_party_details
9966: fnd_message.set_token
9967: ( 'P_TEXT'
9968: , 'CS_SERVICEREQUEST_UTIL.get_party_detail:'||'-'||SQLERRM
9969: );
9970: fnd_msg_pub.ADD;
9971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9972:
9973: END get_party_details;
9974: -- -----------------------------------------------------------------------------
10063: FND_MESSAGE.set_token
10064: ( 'API_NAME'
10065: , 'CS_SERVICEREQUEST_UTIL.update_task_address'
10066: );
10067: FND_MSG_PUB.ADD_DETAIL
10068: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_location_id'
10069: );
10070: RAISE FND_API.G_EXC_ERROR;
10071: END IF;
10272:
10273: EXCEPTION
10274: WHEN loc_update_not_alwd_exp THEN
10275: FND_MESSAGE.SET_Name('CS','CS_SR_LOC_UPD_NOT_ALLWD');
10276: FND_MSG_PUB.ADD;
10277: x_return_status := FND_API.G_RET_STS_ERROR;
10278: WHEN FND_API.G_EXC_ERROR THEN
10279: x_return_status := FND_API.G_RET_STS_ERROR;
10280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10424:
10425: WHEN OTHERS THEN
10426: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10427: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10428: fnd_msg_pub.ADD;
10429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10430:
10431: END Validate_Platform_Version_Id;
10432:
10498: FND_MESSAGE.Set_Name('CS', 'CS_Create_UPDATE_CARD_ERROR');
10499: End if;
10500: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10501: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10502: fnd_msg_pub.ADD;
10503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10504: END VALIDATE_CREDIT_CARD;
10505:
10506:
10530: IF (p_project_id IS NULL AND p_project_task_id IS NOT NULL) THEN
10531: x_return_status := FND_API.G_RET_STS_ERROR;
10532: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_PROJ_NUM');
10533: fnd_message.set_token ('P_TEXT',l_api_name_full||'- Project_id null');
10534: fnd_msg_pub.ADD;
10535: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NULL) THEN
10536: x_return_status := FND_API.G_RET_STS_ERROR;
10537: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_TASK_NUM');
10538: fnd_message.set_token ('P_TEXT',l_api_name_full||'-task_id null');
10535: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NULL) THEN
10536: x_return_status := FND_API.G_RET_STS_ERROR;
10537: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_TASK_NUM');
10538: fnd_message.set_token ('P_TEXT',l_api_name_full||'-task_id null');
10539: fnd_msg_pub.ADD;
10540: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NOT NULL AND p_exp_org_id IS NULL) THEN
10541: x_return_status := FND_API.G_RET_STS_ERROR;
10542: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_EXPENDITURE_ORG');
10543: fnd_message.set_token ('P_TEXT',l_api_name_full||'-exp_org_id null');
10540: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NOT NULL AND p_exp_org_id IS NULL) THEN
10541: x_return_status := FND_API.G_RET_STS_ERROR;
10542: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_EXPENDITURE_ORG');
10543: fnd_message.set_token ('P_TEXT',l_api_name_full||'-exp_org_id null');
10544: fnd_msg_pub.ADD;
10545: ELSE
10546: BEGIN
10547: --deriving project_number based on project_id
10548: --changed the table name from pa_projects_expend_v to
10565: -- selected Operating Unit.Please enter valid combination
10566: if (l_project_id IS NULL OR l_project_task_id IS NULL OR l_exp_org_id IS NULL) THEN
10567: FND_MESSAGE.Set_Name('CS', 'CS_INC_CLEAR_PROJECT_INFO');
10568: fnd_message.set_token ('P_TEXT',l_api_name_full);
10569: fnd_msg_pub.ADD;
10570: x_return_status := FND_API.G_RET_STS_ERROR;
10571: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10572: ELSE
10573: x_return_status := FND_API.G_RET_STS_SUCCESS;
10577: WHEN TOO_MANY_ROWS THEN
10578: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
10579: --throwing SQLERRM CZ this means there is data issue
10580: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10581: fnd_msg_pub.ADD;
10582: x_return_status := FND_API.G_RET_STS_ERROR;
10583: --x_return_status := FND_API.G_RET_STS_SUCCESS;
10584: WHEN NO_DATA_FOUND THEN
10585: Add_Invalid_Argument_Msg
10598: -- x_error_msg:= 'The project number and/or project task number are not valid.Please select valid values.';
10599: --fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||x_error_msg);
10600: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
10601: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10602: fnd_msg_pub.ADD;
10603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10604: END VALIDATE_PROJECT_INFO;
10605:
10606: --Validate Price List Id, Bug 15995804
10646: x_return_status := FND_API.G_RET_STS_ERROR;
10647: WHEN OTHERS THEN
10648: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10649: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10650: fnd_msg_pub.ADD;
10651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10652: END VALIDATE_PRICE_LIST_HEADER;
10653:
10654: