[Home] [Help]
50: CLOSE c_org_info;
51: --
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;
51: --
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: -- -----------------------------------------------------------------------------
127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
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;
128: WHEN NO_DATA_FOUND THEN
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: -- -----------------------------------------------------------------------------
386: p_token_p => p_parameter_name,
387: p_table_name => G_TABLE_NAME,
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;
387: p_table_name => G_TABLE_NAME,
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;
438: p_token_p => p_parameter_name,
439: p_table_name => 'CS_INCIDENT_TYPES_VL',
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;
439: p_table_name => 'CS_INCIDENT_TYPES_VL',
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
465: p_token_p => p_parameter_name,
466: p_table_name => 'CS_INCIDENT_TYPES_VL',
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;
466: p_table_name => 'CS_INCIDENT_TYPES_VL',
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;
490: p_token_p => p_parameter_name,
491: p_table_name => 'CS_INCIDENT_TYPES_VL',
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;
491: p_table_name => 'CS_INCIDENT_TYPES_VL',
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;
536: p_token_p => p_parameter_name,
537: p_table_name => 'CS_INCIDENT_STATUSES_VL',
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;
537: p_table_name => 'CS_INCIDENT_STATUSES_VL',
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;
580: p_token_p => p_parameter_name,
581: p_table_name => 'CS_INCIDENT_SEVERITIES_VL',
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;
581: p_table_name => 'CS_INCIDENT_SEVERITIES_VL',
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;
624: p_token_p => p_parameter_name,
625: p_table_name => 'CS_INCIDENT_URGENCIES_VL',
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;
625: p_table_name => 'CS_INCIDENT_URGENCIES_VL',
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:
678: p_token_p => p_parameter_name_nb,
679: p_table_name => G_TABLE_NAME,
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;
679: p_table_name => G_TABLE_NAME,
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
717: p_token_p => p_parameter_name_n,
718: p_table_name => G_TABLE_NAME,
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;
718: p_table_name => G_TABLE_NAME,
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: **************************************************************************/
767: p_token_p => p_parameter_name_nb,
768: p_table_name => null,
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:
768: p_table_name => null,
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;
816: p_token_p => p_parameter_name,
817: p_table_name => null,
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;
817: p_table_name => null,
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:
868: p_token_p => p_parameter_name,
869: p_table_name => G_TABLE_NAME ,
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;
869: p_table_name => G_TABLE_NAME ,
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:
917: p_token_p => p_parameter_name_usr,
918: p_table_name => G_TABLE_NAME,
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:
918: p_table_name => G_TABLE_NAME,
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;
942: p_table_name => G_TABLE_NAME,
943: p_column_name => 'LAST_UPDATE_LOGIN' );
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;
943: p_column_name => 'LAST_UPDATE_LOGIN' );
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;
1012: FETCH val_type_map INTO l_dummy;
1013: IF (val_type_map%NOTFOUND) THEN
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;
1013: IF (val_type_map%NOTFOUND) THEN
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
1047: p_table_name => G_TABLE_NAME,
1048: p_column_name => 'INCIDENT_TYPE_ID' );
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;
1048: p_column_name => 'INCIDENT_TYPE_ID' );
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:
1126: else
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
1143: if ( val_type_unsecure%notfound ) then
1144: -- new message for 11.5.10
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:
1144: -- new message for 11.5.10
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))
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
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
1151:
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';
1168: if ( val_type_unsecure%notfound ) then
1169: -- new message for 11.5.10
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
1169: -- new message for 11.5.10
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';
1194: if ( val_type_secure%notfound ) then
1195: -- new message for 11.5.10
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))
1195: -- new message for 11.5.10
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
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');
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
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');
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';
1218: -- new message for 11.5.10
1219: -- Invalid type. Given type is either end dated or does not exist
1220: -- as a valid type.
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;
1219: -- Invalid type. Given type is either end dated or does not exist
1220: -- as a valid type.
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
1220: -- as a valid type.
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';
1250: p_table_name => G_TABLE_NAME,
1251: p_column_name => 'INCIDENT_TYPE_ID' );
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;
1251: p_column_name => 'INCIDENT_TYPE_ID' );
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: /*
1396: p_token_p => p_parameter_name,
1397: p_table_name => G_TABLE_NAME,
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;
1397: p_table_name => G_TABLE_NAME,
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:
1627: p_token_p => p_parameter_name,
1628: p_table_name => G_TABLE_NAME,
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;
1628: p_table_name => G_TABLE_NAME,
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:
1669: p_token_p => p_parameter_name,
1670: p_table_name => G_TABLE_NAME,
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:
1670: p_table_name => G_TABLE_NAME,
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;
1712: p_token_p => p_parameter_name,
1713: p_table_name => G_TABLE_NAME,
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:
1713: p_table_name => G_TABLE_NAME,
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;
1754: END IF;
1755:
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:
1755:
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;
1781: IF p_request_date >= p_inc_occurred_date THEN
1782: x_return_status := FND_API.G_RET_STS_SUCCESS;
1783: ELSE
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;
1782: x_return_status := FND_API.G_RET_STS_SUCCESS;
1783: ELSE
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
1783: ELSE
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
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');
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:
1789: END IF;
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;
1811: IF p_inc_occurred_date <= p_request_date THEN
1812: x_return_status := FND_API.G_RET_STS_SUCCESS;
1813: ELSE
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;
1812: x_return_status := FND_API.G_RET_STS_SUCCESS;
1813: ELSE
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
1813: ELSE
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
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');
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:
1819: END IF;
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;
1849: p_column_name => 'INCIDENT_RESOLVED_DATE' );
1850: END IF;
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:
1850: END IF;
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;
1880: p_column_name => 'INC_RESPONDED_BY_DATE' );
1881: END IF;
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:
1881: END IF;
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;
1956: p_token_p => 'p_incident_location_type',
1957: p_table_name => G_TABLE_NAME ,
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:
1957: p_table_name => G_TABLE_NAME ,
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;
1994: p_token_p => p_parameter_name,
1995: p_table_name => G_TABLE_NAME,
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:
1995: p_table_name => G_TABLE_NAME,
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;
2061: p_table_name => G_TABLE_NAME,
2062: p_column_name => 'EMPLOYEE_ID' );
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;
2062: p_column_name => 'EMPLOYEE_ID' );
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:
2109: WHEN NO_DATA_FOUND THEN
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111:
2112: -- For bug 2885111 - adding a new error message
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);
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111:
2112: -- For bug 2885111 - adding a new error message
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:
2111:
2112: -- For bug 2885111 - adding a new error message
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:
2112: -- For bug 2885111 - adding a new error message
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,
2122: p_token_p => p_parameter_name,
2123: p_table_name => G_TABLE_NAME,
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:
2123: p_table_name => G_TABLE_NAME,
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;
2131: END;
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:
2222: p_table_name => G_TABLE_NAME,
2223: p_column_name => 'BILL_TO_CONTACT_ID' );
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:
2223: p_column_name => 'BILL_TO_CONTACT_ID' );
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;
2304: p_table_name => G_TABLE_NAME,
2305: p_column_name => 'CUSTOMER_CONTACT_ID' );
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:
2305: p_column_name => 'CUSTOMER_CONTACT_ID' );
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;
2372: p_token_p => p_parameter_name,
2373: p_table_name => G_TABLE_NAME,
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:
2373: p_table_name => G_TABLE_NAME,
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;
2439: p_token_p => p_parameter_name,
2440: p_table_name => G_TABLE_NAME,
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:
2440: p_table_name => G_TABLE_NAME,
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;
2541: p_table_name => G_TABLE_NAME,
2542: p_column_name => 'CUSTOMER_PRODUCT_ID' );
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:
2542: p_column_name => 'CUSTOMER_PRODUCT_ID' );
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;
2644: p_table_name => G_TABLE_NAME,
2645: p_column_name => 'CURRENT_SERIAL_NUMBER');
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:
2645: p_column_name => 'CURRENT_SERIAL_NUMBER');
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;
2715: p_table_name => G_TABLE_NAME,
2716: p_column_name => 'INVENTORY_ORG_ID');
2717:
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;
2716: p_column_name => 'INVENTORY_ORG_ID');
2717:
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:
2717:
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;
2765: p_table_name => G_TABLE_NAME,
2766: p_column_name => 'OWNING_DEPARTMENT_ID');
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:
2766: p_column_name => 'OWNING_DEPARTMENT_ID');
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;
2881: , p_table_name => G_TABLE_NAME
2882: , p_column_name => 'INVENTORY_ITEM_ID'
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;
2882: , p_column_name => 'INVENTORY_ITEM_ID'
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:
2948: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2949: -- new message for 11.5.10
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:
2949: -- new message for 11.5.10
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:
2956:
2957:
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:
2957:
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;
2998: p_token_p => p_parameter_name,
2999: p_table_name => G_TABLE_NAME,
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:
2999: p_table_name => G_TABLE_NAME,
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;
3038: p_token_p => p_parameter_name,
3039: p_table_name => G_TABLE_NAME,
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;
3039: p_table_name => G_TABLE_NAME,
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;
3099:
3100: EXCEPTION
3101: WHEN NO_DATA_FOUND THEN
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
3100: EXCEPTION
3101: WHEN NO_DATA_FOUND THEN
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');
3101: WHEN NO_DATA_FOUND THEN
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);
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;
3111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3112:
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;
3111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3112:
3113: END;
3165: EXCEPTION
3166: WHEN NO_DATA_FOUND THEN
3167: x_return_status := FND_API.G_RET_STS_ERROR;
3168: IF (l_validation = 'I') THEN
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;
3166: WHEN NO_DATA_FOUND THEN
3167: x_return_status := FND_API.G_RET_STS_ERROR;
3168: IF (l_validation = 'I') THEN
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
3167: x_return_status := FND_API.G_RET_STS_ERROR;
3168: IF (l_validation = 'I') THEN
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');
3168: IF (l_validation = 'I') THEN
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);
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'));
3178: fnd_msg_pub.ADD;
3179: END IF;
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'));
3178: fnd_msg_pub.ADD;
3179: END IF;
3180: WHEN OTHERS THEN
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'));
3178: fnd_msg_pub.ADD;
3179: END IF;
3180: WHEN OTHERS THEN
3181: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
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);
3183: fnd_msg_pub.ADD;
3184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3185:
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);
3183: fnd_msg_pub.ADD;
3184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3185:
3186: END Validate_Category_Set_Id;
3320: p_token_p => p_parameter_name ,
3321: p_table_name => G_TABLE_NAME,
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:
3321: p_table_name => G_TABLE_NAME,
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;
3359: p_token_p => p_parameter_name,
3360: p_table_name => G_TABLE_NAME,
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:
3360: p_table_name => G_TABLE_NAME,
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;
3400: END IF;
3401:
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:
3401:
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;
3479: p_token_p => p_parameter_name,
3480: p_table_name => G_TABLE_NAME,
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;
3480: p_table_name => G_TABLE_NAME,
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:
3543: p_token_p => p_parameter_name,
3544: p_table_name => G_TABLE_NAME ,
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 ;
3544: p_table_name => G_TABLE_NAME ,
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:
3613: p_table_name => G_TABLE_NAME,
3614: p_column_name => 'INSTALL_SITE_ID' );
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:
3614: p_column_name => 'INSTALL_SITE_ID' );
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;
3653: p_token_p => p_parameter_name,
3654: p_table_name => G_TABLE_NAME,
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:
3654: p_table_name => G_TABLE_NAME,
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;
3690: p_column_name => 'ACTUAL_RESOLUTION_DATE' );
3691: END IF;
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:
3691: END IF;
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;
3758: p_table_name => G_TABLE_NAME,
3759: p_column_name => 'CONTRACT_SERVICE_ID');
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;
3759: p_column_name => 'CONTRACT_SERVICE_ID');
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: ---------------------------------------------------------------------------
3796: p_table_name => G_TABLE_NAME,
3797: p_column_name => 'CONTRACT_ID' );
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:
3797: p_column_name => 'CONTRACT_ID' );
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:
3856: p_table_name => null,
3857: p_column_name => 'P_SUPPORT_SITE_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;
3857: p_column_name => 'P_SUPPORT_SITE_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: ---------------------------------------------------------
3903: p_table_name => G_TABLE_NAME ,
3904: p_column_name => 'GROUP_TYPE' );
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:
3904: p_column_name => 'GROUP_TYPE' );
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:
3962: p_table_name => G_TABLE_NAME,
3963: p_column_name => 'OWNER_GROUP_ID');
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;
3963: p_column_name => 'OWNER_GROUP_ID');
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:
4077: , p_column_name => 'incident_owner_id'
4078: );
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;
4078: );
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:
4117: p_table_name => G_TABLE_NAME,
4118: p_column_name => 'RESOURCE_TYPE');
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;
4118: p_column_name => 'RESOURCE_TYPE');
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:
4176: p_table_name => G_TABLE_NAME ,
4177: p_column_name => 'PLATFORM_ID' );
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:
4177: p_column_name => 'PLATFORM_ID' );
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;
4218: p_table_name => G_TABLE_NAME ,
4219: p_column_name => 'CP_COMPONENT_ID');
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:
4219: p_column_name => 'CP_COMPONENT_ID');
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;
4270: p_table_name => null,
4271: p_column_name => null);
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;
4271: p_column_name => null);
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;
4369: p_token_p => p_parameter_name,
4370: p_table_name => G_TABLE_NAME ,
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;
4370: p_table_name => G_TABLE_NAME ,
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: --
4441: p_table_name => null,
4442: p_column_name => null);
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;
4442: p_column_name => null);
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;
4460: p_token_p => p_parameter_name,
4461: p_table_name => G_TABLE_NAME ,
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;
4461: p_table_name => G_TABLE_NAME ,
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;
4532: p_table_name => null,
4533: p_column_name => null);
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;
4533: p_column_name => null);
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;
4550: p_token_p => p_parameter_name ,
4551: p_table_name => G_TABLE_NAME,
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;
4551: p_table_name => G_TABLE_NAME,
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;
4602: p_table_name => G_TABLE_NAME ,
4603: p_column_name => 'CP_SUBCOMPONENT_ID');
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:
4603: p_column_name => 'CP_SUBCOMPONENT_ID');
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;
4655: p_token_p => p_parameter_name,
4656: p_table_name => G_TABLE_NAME ,
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:
4656: p_table_name => G_TABLE_NAME ,
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;
4673: p_table_name => G_TABLE_NAME ,
4674: p_column_name => 'INVENTORY_ITEM_ID' );
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:
4674: p_column_name => 'INVENTORY_ITEM_ID' );
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;
4738: p_token_p => p_parameter_name,
4739: p_table_name => G_TABLE_NAME ,
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:
4739: p_table_name => G_TABLE_NAME ,
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;
4861: p_table_name => G_TABLE_NAME ,
4862: p_column_name => 'INV_SUBCOMPONENT_ID' );
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:
4862: p_column_name => 'INV_SUBCOMPONENT_ID' );
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;
4912: p_token_p => p_parameter_name,
4913: p_table_name => G_TABLE_NAME ,
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:
4913: p_table_name => G_TABLE_NAME ,
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;
4951: p_token_p => p_parameter_name,
4952: p_table_name => G_TABLE_NAME ,
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:
4952: p_table_name => G_TABLE_NAME ,
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;
4990: p_token_p => p_parameter_name,
4991: p_table_name => G_TABLE_NAME,
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:
4991: p_table_name => G_TABLE_NAME,
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;
5029: p_token_p => p_parameter_name,
5030: p_table_name => G_TABLE_NAME,
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:
5030: p_table_name => G_TABLE_NAME,
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;
5072: -- new message for 11.5.10
5073: -- Contact point is not valid. Please check the values for the following:
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
5073: -- Contact point is not valid. Please check the values for the following:
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');
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);
5083: fnd_msg_pub.ADD;
5084: x_return_status := fnd_api.g_ret_sts_unexp_error;
5085:
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);
5083: fnd_msg_pub.ADD;
5084: x_return_status := fnd_api.g_ret_sts_unexp_error;
5085:
5086: END Validate_Per_Contact_Point_Id;
5118: p_token_p => p_parameter_name,
5119: p_table_name => 'CS_HZ_SR_CONTACT_POINTS' ,
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:
5119: p_table_name => 'CS_HZ_SR_CONTACT_POINTS' ,
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;
5159: p_token_p => p_parameter_name,
5160: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
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;
5160: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
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:
5198: p_token_p => p_parameter_name,
5199: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
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;
5199: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
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: ---------------------------------------
5239: p_token_p => p_parameter_name,
5240: p_table_name => G_TABLE_NAME ,
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:
5240: p_table_name => G_TABLE_NAME ,
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;
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;
5310: END IF;
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;
5310: END IF;
5311: END Add_Desc_Flex_Msg;
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;
5310: END IF;
5311: END Add_Desc_Flex_Msg;
5312:
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);
5343: -- 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);
5343: -- end for bug 2833245
5344: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
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);
5343: -- end for bug 2833245
5344: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5345: FND_MSG_PUB.ADD;
5346: END IF;
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);
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:
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;
5371: END IF;
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;
5371: END IF;
5372: END Add_Key_Flex_Msg;
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;
5371: END IF;
5372: END Add_Key_Flex_Msg;
5373:
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;
5390: END IF;
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;
5390: END IF;
5391: END Add_Null_Parameter_Msg;
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;
5390: END IF;
5391: END Add_Null_Parameter_Msg;
5392:
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);
5409: END IF;
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);
5409: END IF;
5410: END Add_Param_Ignored_Msg;
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);
5409: END IF;
5410: END Add_Param_Ignored_Msg;
5411:
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);
5430: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
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);
5430: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5431: END IF;
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);
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;
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);
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:
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;
5448: END IF;
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;
5448: END IF;
5449: END Add_Duplicate_Value_Msg;
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;
5448: END IF;
5449: END Add_Duplicate_Value_Msg;
5450:
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;
5460: END IF;
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;
5460: END IF;
5461: END Add_Same_Val_Update_Msg;
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;
5460: END IF;
5461: END Add_Same_Val_Update_Msg;
5462:
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;
5472: END IF;
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;
5472: END IF;
5473: END Add_Missing_Param_Msg;
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;
5472: END IF;
5473: END Add_Missing_Param_Msg;
5474:
5510: WHEN fnd_api.g_exc_unexpected_error THEN
5511: x_return_status := fnd_api.g_ret_sts_unexp_error;
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:
5511: x_return_status := fnd_api.g_ret_sts_unexp_error;
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 ;
5562: p_table_name => G_TABLE_NAME,
5563: p_column_name => 'ACCOUNT_ID' );
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 ;
5563: p_column_name => 'ACCOUNT_ID' );
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:
5627: p_table_name => G_TABLE_NAME,
5628: p_column_name => 'CREATION_PROGRAM_CODE' );
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;
5628: p_column_name => 'CREATION_PROGRAM_CODE' );
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: -- -----------------------------------------------------------------------
5689: p_table_name => G_TABLE_NAME,
5690: p_column_name => 'INCIDENT_DISTANCE_QUAL_UOM');
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:
5690: p_column_name => 'INCIDENT_DISTANCE_QUAL_UOM');
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:
5756: p_table_name => G_TABLE_NAME,
5757: p_column_name => 'INCIDENT_DIRECTION_QUALIFIER' );
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:
5757: p_column_name => 'INCIDENT_DIRECTION_QUALIFIER' );
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:
5798: ELSE
5799: l_associated_col1 := p_token_dfm ;
5800: END IF ;
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:
5799: l_associated_col1 := p_token_dfm ;
5800: END IF ;
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;
5800: END IF ;
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;
5856: l_token_v := NULL;
5857: end if;
5858: -- end for bug 2833245
5859:
5860: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5861: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
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
5857: end if;
5858: -- end for bug 2833245
5859:
5860: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5861: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
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);
5859:
5860: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5861: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
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:
5861: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
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);
5904: l_associated_col1 := p_column_name;
5905: ELSE
5906: l_associated_col1 := p_token_kfm ;
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;
5905: ELSE
5906: l_associated_col1 := p_token_kfm ;
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;
5906: l_associated_col1 := p_token_kfm ;
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:
5946: l_associated_col1 := p_column_name;
5947: ELSE
5948: l_associated_col1 := p_token_mp ;
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;
5947: ELSE
5948: l_associated_col1 := p_token_mp ;
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;
5948: l_associated_col1 := p_token_mp ;
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:
5990: l_associated_col1 := p_column_name;
5991: ELSE
5992: l_associated_col1 := p_token_np ;
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;
5991: ELSE
5992: l_associated_col1 := p_token_np ;
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;
5992: l_associated_col1 := p_token_np ;
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:
6034: l_associated_col1 := p_column_name;
6035: ELSE
6036: l_associated_col1 := p_token_ip ;
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;
6035: ELSE
6036: l_associated_col1 := p_token_ip ;
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;
6036: l_associated_col1 := p_token_ip ;
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:
6077: l_associated_col1 := p_column_name;
6078: ELSE
6079: l_associated_col1 := p_token_p ;
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;
6078: ELSE
6079: l_associated_col1 := p_token_p ;
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;
6079: l_associated_col1 := p_token_p ;
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:
6119: l_associated_col1 := p_column_name;
6120: ELSE
6121: l_associated_col1 := p_token_p ;
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);
6120: ELSE
6121: l_associated_col1 := p_token_p ;
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;
6121: l_associated_col1 := p_token_p ;
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;
6193: p_token_v => 'site_id:='||to_char(p_site_id)||' or site_use_id:='||to_char(p_site_use_id),
6194: p_token_p => p_parameter_name );
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 ;
6194: p_token_p => p_parameter_name );
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:
6257: p_token_v => to_char(p_site_use_id),
6258: p_token_p => p_parameter_name );
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;
6258: p_token_p => p_parameter_name );
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:
6309: -- There are open tasks associated to the service request. Changing the
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:
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;
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:
6350:
6351: EXCEPTION
6352: WHEN NO_DATA_FOUND THEN
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:
6351: EXCEPTION
6352: WHEN NO_DATA_FOUND THEN
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
6352: WHEN NO_DATA_FOUND THEN
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');
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);
6362: fnd_msg_pub.add;
6363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6364:
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);
6362: fnd_msg_pub.add;
6363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6364:
6365: END CP_INCIDENT_SITE_CROSS_VAL;
6391:
6392: EXCEPTION
6393: WHEN NO_DATA_FOUND THEN
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:
6392: EXCEPTION
6393: WHEN NO_DATA_FOUND THEN
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
6393: WHEN NO_DATA_FOUND THEN
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');
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);
6403: fnd_msg_pub.add;
6404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6405:
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);
6403: fnd_msg_pub.add;
6404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6405:
6406: END CP_INSTALL_SITE_CROSS_VAL;
6455: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
6456: -- new message for 11.5.10
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:
6456: -- new message for 11.5.10
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
6462: end if;
6463:
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:
6463:
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;
6508: if ( l_dummy > 0 ) then
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;
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:
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;
6681: -- new message for 11.5.10
6682: -- Contract is not valid. Please check the values for the following:
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
6682: -- Contract is not valid. Please check the values for the following:
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;
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');
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 *********/
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');
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:
6695: *************** when bug 4109990 is fixed, uncomment this part *********/
6696:
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:
6696:
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;
6737: p_token_v => to_char(p_inv_component_id),
6738: p_token_p => p_parameter_name );
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:
6738: p_token_p => p_parameter_name );
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;
6778: p_token_v => to_char(p_cp_subcomponent_id),
6779: p_token_p => p_parameter_name );
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:
6779: p_token_p => p_parameter_name );
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;
6882: if ( p_old_eam_type_flag = 'Y' ) then
6883: -- new message for 11.5.10
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
6883: -- new message for 11.5.10
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
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.
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
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.
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;
6901: EXCEPTION
6902: WHEN OTHERS THEN
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;
6902: WHEN OTHERS THEN
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:
7458: when no_data_found then
7459: raise fnd_api.g_exc_unexpected_error;
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;
7459: raise fnd_api.g_exc_unexpected_error;
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:
7732:
7733: IF ((l_bto_site_id <> FND_API.G_MISS_NUM AND l_bto_site_id IS NOT NULL))
7734: 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;
7733: IF ((l_bto_site_id <> FND_API.G_MISS_NUM AND l_bto_site_id IS NOT NULL))
7734: 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;
7734: 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;
7771:
7772: IF ((l_sto_site_id <> FND_API.G_MISS_NUM AND l_sto_site_id IS NOT NULL))
7773: THEN
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;
7772: IF ((l_sto_site_id <> FND_API.G_MISS_NUM AND l_sto_site_id IS NOT NULL))
7773: THEN
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;
7773: THEN
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;
7810: ---- Validate Bill to contact id
7811: IF ((l_bto_cont_id <> FND_API.G_MISS_NUM AND l_bto_cont_id IS NOT NULL)) THEN
7812: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
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:
7811: IF ((l_bto_cont_id <> FND_API.G_MISS_NUM AND l_bto_cont_id IS NOT NULL)) THEN
7812: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
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;
7812: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
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;
7848: ---- Validate ship to contact id
7849: IF ((l_sto_cont_id <> FND_API.G_MISS_NUM AND l_sto_cont_id IS NOT NULL)) THEN
7850: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
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:
7849: IF ((l_sto_cont_id <> FND_API.G_MISS_NUM AND l_sto_cont_id IS NOT NULL)) THEN
7850: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
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;
7850: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
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;
8444: l_sto_site_use IS NOT NULL))
8445: THEN
8446: IF (l_sto_party_id = FND_API.G_MISS_NUM OR
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;
8445: THEN
8446: IF (l_sto_party_id = FND_API.G_MISS_NUM OR
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;
8446: IF (l_sto_party_id = FND_API.G_MISS_NUM OR
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;
8611: l_bto_site_use IS NOT NULL))
8612: THEN
8613: IF (l_bto_party_id = FND_API.G_MISS_NUM OR
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;
8612: THEN
8613: IF (l_bto_party_id = FND_API.G_MISS_NUM OR
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;
8613: IF (l_bto_party_id = FND_API.G_MISS_NUM OR
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;
8710: EXCEPTION
8711: WHEN OTHERS THEN
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;
8711: WHEN OTHERS THEN
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:
9286:
9287: IF c_party_role % NOTFOUND
9288: THEN
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);
9287: IF c_party_role % NOTFOUND
9288: THEN
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
9288: THEN
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)
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;
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;
9296: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9297: THEN
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;
9297: THEN
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;
9309: IF c_party_role%ISOPEN
9310: THEN
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;
9310: THEN
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: -- -----------------------------------------------------------------------------
9354: WHERE organization_id = p_org_id;
9355: IF l_sys_dt < NVL(l_dt_from, l_sys_dt) OR
9356: l_sys_dt > NVL(l_dt_to , l_sys_dt)
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;
9355: IF l_sys_dt < NVL(l_dt_from, l_sys_dt) OR
9356: l_sys_dt > NVL(l_dt_to , l_sys_dt)
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;
9356: l_sys_dt > NVL(l_dt_to , l_sys_dt)
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
9371: , p_table_name => G_TABLE_NAME
9372: , p_column_name => 'ORG_ID'
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;
9372: , p_column_name => 'ORG_ID'
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: -- -----------------------------------------------------------------------------
9433: );
9434: ELSIF NVL(l_maint_org_id,-99) <> p_maint_organization_id
9435: THEN
9436: x_return_status := FND_API.G_RET_STS_ERROR;
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);
9434: ELSIF NVL(l_maint_org_id,-99) <> p_maint_organization_id
9435: THEN
9436: x_return_status := FND_API.G_RET_STS_ERROR;
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;
9435: THEN
9436: x_return_status := FND_API.G_RET_STS_ERROR;
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
9436: x_return_status := FND_API.G_RET_STS_ERROR;
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
9459: );
9460: ELSIF l_eam_enabled <> 'Y'
9461: THEN
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
9460: ELSIF l_eam_enabled <> 'Y'
9461: THEN
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
9461: THEN
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
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;
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;
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:
9574: --
9575: IF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9576: l_sys_dt > NVL(l_end_dt , l_sys_dt)
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;
9575: IF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9576: l_sys_dt > NVL(l_end_dt , l_sys_dt)
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;
9576: l_sys_dt > NVL(l_end_dt , l_sys_dt)
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: --
9584: --
9585: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9586: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9587: THEN
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');
9585: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9586: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9587: THEN
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;
9586: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9587: THEN
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;
9587: THEN
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: --
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;
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;
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: --
9607: OPEN c_prod_rel;
9608: FETCH c_prod_rel into l_dummy;
9609: IF c_prod_rel % NOTFOUND
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;
9608: FETCH c_prod_rel into l_dummy;
9609: IF c_prod_rel % NOTFOUND
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;
9609: IF c_prod_rel % NOTFOUND
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
9636: , x_return_status => x_return_status
9637: );
9638: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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;
9637: );
9638: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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;
9638: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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'
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');
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;
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;
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'
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');
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;
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;
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
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;
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;
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
9684: , x_return_Status => x_return_status
9685: );
9686: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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;
9685: );
9686: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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;
9686: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
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
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;
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: */
9702: END IF;
9703: */
9704: IF l_maint_org_id <> p_maint_organization_id
9705: THEN
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');
9703: */
9704: IF l_maint_org_id <> p_maint_organization_id
9705: THEN
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;
9704: IF l_maint_org_id <> p_maint_organization_id
9705: THEN
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;
9705: THEN
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
9712: END IF;
9713: IF p_inv_org_master_org_flag = 'Y' AND
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;
9713: IF p_inv_org_master_org_flag = 'Y' AND
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
9847: END IF ;
9848: END IF;
9849: EXCEPTION
9850: WHEN OTHERS THEN
9851: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9852: FND_MESSAGE.set_token
9853: ( 'P_TEXT'
9854: , 'CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM
9855: );
9848: END IF;
9849: EXCEPTION
9850: WHEN OTHERS THEN
9851: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9852: FND_MESSAGE.set_token
9853: ( 'P_TEXT'
9854: , 'CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM
9855: );
9856: FND_MSG_PUB.ADD;
9898: WHEN NO_DATA_FOUND THEN
9899: x_return_status := FND_API.G_RET_STS_ERROR;
9900:
9901: WHEN OTHERS THEN
9902: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9903: fnd_message.set_token
9904: ( 'P_TEXT'
9905: , 'CS_SERVICEREQUEST_UTIL.get_party_detail:'||'-'||SQLERRM
9906: );
9899: x_return_status := FND_API.G_RET_STS_ERROR;
9900:
9901: WHEN OTHERS THEN
9902: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9903: fnd_message.set_token
9904: ( 'P_TEXT'
9905: , 'CS_SERVICEREQUEST_UTIL.get_party_detail:'||'-'||SQLERRM
9906: );
9907: fnd_msg_pub.ADD;
9980: IF task_rec.fs_task = 'Y'
9981: THEN
9982: IF p_location_id IS NULL
9983: THEN
9984: FND_MESSAGE.set_name ('CS', 'CS_SR_OPEN_FS_TASKS');
9985: FND_MESSAGE.set_token
9986: ( 'API_NAME'
9987: , 'CS_SERVICEREQUEST_UTIL.update_task_address'
9988: );
9981: THEN
9982: IF p_location_id IS NULL
9983: THEN
9984: FND_MESSAGE.set_name ('CS', 'CS_SR_OPEN_FS_TASKS');
9985: FND_MESSAGE.set_token
9986: ( 'API_NAME'
9987: , 'CS_SERVICEREQUEST_UTIL.update_task_address'
9988: );
9989: FND_MSG_PUB.ADD_DETAIL
10191: 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;
10342: p_table_name => G_TABLE_NAME,
10343: p_column_name => 'PLATFORM_VERSION_ID' );
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:
10343: p_column_name => 'PLATFORM_VERSION_ID' );
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;