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:
869: p_token_p => p_parameter_name,
870: p_table_name => G_TABLE_NAME ,
871: p_column_name => 'RMA_NUMBER' );
872: WHEN OTHERS THEN
873: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
874: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
875: fnd_msg_pub.ADD;
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: END Convert_RMA_Number_To_ID;
870: p_table_name => G_TABLE_NAME ,
871: p_column_name => 'RMA_NUMBER' );
872: WHEN OTHERS THEN
873: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
874: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
875: fnd_msg_pub.ADD;
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: END Convert_RMA_Number_To_ID;
878: */
919: p_token_p => p_parameter_name_usr,
920: p_table_name => G_TABLE_NAME,
921: p_column_name => 'CREATED_BY');
922: WHEN OTHERS THEN
923: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
924: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
925: fnd_msg_pub.ADD;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
927:
920: p_table_name => G_TABLE_NAME,
921: p_column_name => 'CREATED_BY');
922: WHEN OTHERS THEN
923: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
924: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
925: fnd_msg_pub.ADD;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
927:
928: RETURN;
944: p_table_name => G_TABLE_NAME,
945: p_column_name => 'LAST_UPDATE_LOGIN' );
946:
947: WHEN OTHERS THEN
948: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
949: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
950: fnd_msg_pub.ADD;
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
952: END;
945: p_column_name => 'LAST_UPDATE_LOGIN' );
946:
947: WHEN OTHERS THEN
948: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
949: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
950: fnd_msg_pub.ADD;
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
952: END;
953: END IF;
1014: FETCH val_type_map INTO l_dummy;
1015: IF (val_type_map%NOTFOUND) THEN
1016: CLOSE val_type_map;
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: fnd_message.set_name ('CS', 'CS_SR_TYPE_BY_RESP');
1019: fnd_message.set_token ('OPERATION',p_operation);
1020: fnd_msg_pub.ADD;
1021: ELSE
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015: IF (val_type_map%NOTFOUND) THEN
1016: CLOSE val_type_map;
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: fnd_message.set_name ('CS', 'CS_SR_TYPE_BY_RESP');
1019: fnd_message.set_token ('OPERATION',p_operation);
1020: fnd_msg_pub.ADD;
1021: ELSE
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023: --Fixed bug 2809312, moved this close cursor here from
1049: p_table_name => G_TABLE_NAME,
1050: p_column_name => 'INCIDENT_TYPE_ID' );
1051:
1052: WHEN OTHERS THEN
1053: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1054: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1055: fnd_msg_pub.ADD;
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1057: END Validate_Type;
1050: p_column_name => 'INCIDENT_TYPE_ID' );
1051:
1052: WHEN OTHERS THEN
1053: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1054: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1055: fnd_msg_pub.ADD;
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1057: END Validate_Type;
1058:
1128: else
1129: -- new message for 11.5.10
1130: -- You do not have access to the service request type that is
1131: -- being created. Please contact your system administrator.
1132: fnd_message.set_name ('CS', 'CS_SR_WEB_NO_PRIV');
1133: fnd_msg_pub.ADD;
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: end if;
1136: else
1145: if ( val_type_unsecure%notfound ) then
1146: -- new message for 11.5.10
1147: -- Invalid type. Given type is either end dated or does not exist
1148: -- as a valid type.
1149: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1150: fnd_message.set_token('API_NAME', l_api_name_full);
1151: fnd_msg_pub.ADD;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1146: -- new message for 11.5.10
1147: -- Invalid type. Given type is either end dated or does not exist
1148: -- as a valid type.
1149: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1150: fnd_message.set_token('API_NAME', l_api_name_full);
1151: fnd_msg_pub.ADD;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1154: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1154: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1155: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1156: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1157: fnd_message.set_token('API_NAME', l_api_name_full);
1158: fnd_msg_pub.ADD;
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: else
1153:
1154: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1155: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1156: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1157: fnd_message.set_token('API_NAME', l_api_name_full);
1158: fnd_msg_pub.ADD;
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: else
1161: l_flags_set := 'Y';
1170: if ( val_type_unsecure%notfound ) then
1171: -- new message for 11.5.10
1172: -- Invalid type. Given type is either end dated or does not exist
1173: -- as a valid type.
1174: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1175: fnd_message.set_token('API_NAME', l_api_name_full);
1176: fnd_msg_pub.ADD;
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: else
1171: -- new message for 11.5.10
1172: -- Invalid type. Given type is either end dated or does not exist
1173: -- as a valid type.
1174: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1175: fnd_message.set_token('API_NAME', l_api_name_full);
1176: fnd_msg_pub.ADD;
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: else
1179: l_flags_set := 'Y';
1196: if ( val_type_secure%notfound ) then
1197: -- new message for 11.5.10
1198: -- Current responsibility does not have sufficient priviledges to access
1199: -- service requests of this type. Please contact your system administrator.
1200: fnd_message.set_name ('CS', 'CS_SR_AGENT_NO_PRIV');
1201: fnd_message.set_token('API_NAME', l_api_name_full);
1202: fnd_msg_pub.ADD;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1197: -- new message for 11.5.10
1198: -- Current responsibility does not have sufficient priviledges to access
1199: -- service requests of this type. Please contact your system administrator.
1200: fnd_message.set_name ('CS', 'CS_SR_AGENT_NO_PRIV');
1201: fnd_message.set_token('API_NAME', l_api_name_full);
1202: fnd_msg_pub.ADD;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1205: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1202: fnd_msg_pub.ADD;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1205: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1206: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1207: fnd_message.set_token('API_NAME', l_api_name_full);
1208: fnd_msg_pub.ADD;
1209: x_return_status := FND_API.G_RET_STS_ERROR;
1210: else
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: elsif (not( trunc(sysdate) >= trunc(nvl(l_start_date, sysdate))
1205: and trunc(sysdate) <= trunc(nvl(l_end_date, sysdate)) )) then
1206: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1207: fnd_message.set_token('API_NAME', l_api_name_full);
1208: fnd_msg_pub.ADD;
1209: x_return_status := FND_API.G_RET_STS_ERROR;
1210: else
1211: l_flags_set := 'Y';
1220: -- new message for 11.5.10
1221: -- Invalid type. Given type is either end dated or does not exist
1222: -- as a valid type.
1223: -- For bug 3902711
1224: --fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1225: fnd_message.set_name ('CS', 'CS_SR_AGENT_NO_PRIV');
1226: fnd_message.set_token('API_NAME', l_api_name_full);
1227: fnd_msg_pub.ADD;
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1221: -- Invalid type. Given type is either end dated or does not exist
1222: -- as a valid type.
1223: -- For bug 3902711
1224: --fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1225: fnd_message.set_name ('CS', 'CS_SR_AGENT_NO_PRIV');
1226: fnd_message.set_token('API_NAME', l_api_name_full);
1227: fnd_msg_pub.ADD;
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: else
1222: -- as a valid type.
1223: -- For bug 3902711
1224: --fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
1225: fnd_message.set_name ('CS', 'CS_SR_AGENT_NO_PRIV');
1226: fnd_message.set_token('API_NAME', l_api_name_full);
1227: fnd_msg_pub.ADD;
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: else
1230: l_flags_set := 'Y';
1252: p_table_name => G_TABLE_NAME,
1253: p_column_name => 'INCIDENT_TYPE_ID' );
1254:
1255: WHEN OTHERS THEN
1256: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1257: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1258: fnd_msg_pub.ADD;
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: END Validate_Type;
1253: p_column_name => 'INCIDENT_TYPE_ID' );
1254:
1255: WHEN OTHERS THEN
1256: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1257: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1258: fnd_msg_pub.ADD;
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: END Validate_Type;
1261: /*
1398: p_token_p => p_parameter_name,
1399: p_table_name => G_TABLE_NAME,
1400: p_column_name => 'INCIDENT_STATUS_ID' );
1401: WHEN OTHERS THEN
1402: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1403: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1404: fnd_msg_pub.ADD;
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: END Validate_Status;
1399: p_table_name => G_TABLE_NAME,
1400: p_column_name => 'INCIDENT_STATUS_ID' );
1401: WHEN OTHERS THEN
1402: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1403: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1404: fnd_msg_pub.ADD;
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: END Validate_Status;
1407:
1629: p_token_p => p_parameter_name,
1630: p_table_name => G_TABLE_NAME,
1631: p_column_name => 'INCIDENT_STATUS_ID' );
1632: WHEN OTHERS THEN
1633: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1634: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1635: fnd_msg_pub.ADD;
1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1637: END Validate_Updated_Status;
1630: p_table_name => G_TABLE_NAME,
1631: p_column_name => 'INCIDENT_STATUS_ID' );
1632: WHEN OTHERS THEN
1633: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1634: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1635: fnd_msg_pub.ADD;
1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1637: END Validate_Updated_Status;
1638:
1671: p_token_p => p_parameter_name,
1672: p_table_name => G_TABLE_NAME,
1673: p_column_name => 'SEVERITY_ID' );
1674: WHEN OTHERS THEN
1675: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1676: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1677: fnd_msg_pub.ADD;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679:
1672: p_table_name => G_TABLE_NAME,
1673: p_column_name => 'SEVERITY_ID' );
1674: WHEN OTHERS THEN
1675: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1676: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1677: fnd_msg_pub.ADD;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679:
1680: END;
1714: p_token_p => p_parameter_name,
1715: p_table_name => G_TABLE_NAME,
1716: p_column_name => 'URGENCY_ID' );
1717: WHEN OTHERS THEN
1718: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1719: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1720: fnd_msg_pub.ADD;
1721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1722:
1715: p_table_name => G_TABLE_NAME,
1716: p_column_name => 'URGENCY_ID' );
1717: WHEN OTHERS THEN
1718: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1719: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1720: fnd_msg_pub.ADD;
1721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1722:
1723: END;
1756: END IF;
1757:
1758: EXCEPTION
1759: WHEN OTHERS THEN
1760: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1761: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1762: fnd_msg_pub.ADD;
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764:
1757:
1758: EXCEPTION
1759: WHEN OTHERS THEN
1760: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1761: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1762: fnd_msg_pub.ADD;
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764:
1765: END Validate_Closed_Date;
1783: IF p_request_date >= p_inc_occurred_date THEN
1784: x_return_status := FND_API.G_RET_STS_SUCCESS;
1785: ELSE
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1788: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1789: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1790: FND_MSG_PUB.ADD;
1791: END IF;
1784: x_return_status := FND_API.G_RET_STS_SUCCESS;
1785: ELSE
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1788: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1789: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1790: FND_MSG_PUB.ADD;
1791: END IF;
1792: EXCEPTION
1785: ELSE
1786: x_return_status := FND_API.G_RET_STS_ERROR;
1787: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1788: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1789: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1790: FND_MSG_PUB.ADD;
1791: END IF;
1792: EXCEPTION
1793: WHEN OTHERS THEN
1790: FND_MSG_PUB.ADD;
1791: END IF;
1792: EXCEPTION
1793: WHEN OTHERS THEN
1794: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1795: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1796: fnd_msg_pub.ADD;
1797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1798:
1791: END IF;
1792: EXCEPTION
1793: WHEN OTHERS THEN
1794: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1795: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1796: fnd_msg_pub.ADD;
1797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1798:
1799: END Validate_Inc_Reported_Date;
1813: IF p_inc_occurred_date <= p_request_date THEN
1814: x_return_status := FND_API.G_RET_STS_SUCCESS;
1815: ELSE
1816: x_return_status := FND_API.G_RET_STS_ERROR;
1817: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1818: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1819: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1820: FND_MSG_PUB.ADD;
1821: END IF;
1814: x_return_status := FND_API.G_RET_STS_SUCCESS;
1815: ELSE
1816: x_return_status := FND_API.G_RET_STS_ERROR;
1817: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1818: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1819: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1820: FND_MSG_PUB.ADD;
1821: END IF;
1822: EXCEPTION
1815: ELSE
1816: x_return_status := FND_API.G_RET_STS_ERROR;
1817: fnd_message.set_name ('CS','CS_INC_DATES_MISMATCH');
1818: fnd_message.set_token ('INCIDENT_DATE',TO_CHAR(p_request_date));
1819: fnd_message.set_token ('INCIDENT_OCC_DATE',TO_CHAR(p_inc_occurred_date));
1820: FND_MSG_PUB.ADD;
1821: END IF;
1822: EXCEPTION
1823: WHEN OTHERS THEN
1820: FND_MSG_PUB.ADD;
1821: END IF;
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1825: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1826: fnd_msg_pub.ADD;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828:
1821: END IF;
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1825: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1826: fnd_msg_pub.ADD;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828:
1829: END Validate_Inc_Occurred_Date;
1851: p_column_name => 'INCIDENT_RESOLVED_DATE' );
1852: END IF;
1853: EXCEPTION
1854: WHEN OTHERS THEN
1855: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1856: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1857: fnd_msg_pub.ADD;
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859:
1852: END IF;
1853: EXCEPTION
1854: WHEN OTHERS THEN
1855: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1856: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1857: fnd_msg_pub.ADD;
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859:
1860: END Validate_Inc_Resolved_Date;
1882: p_column_name => 'INC_RESPONDED_BY_DATE' );
1883: END IF;
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1887: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1888: fnd_msg_pub.ADD;
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1890:
1883: END IF;
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1887: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1888: fnd_msg_pub.ADD;
1889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1890:
1891: END Validate_Inc_Responded_Date;
1958: p_token_p => 'p_incident_location_type',
1959: p_table_name => G_TABLE_NAME ,
1960: p_column_name => 'INCIDENT_LOCATION_TYPE' );
1961: WHEN OTHERS THEN
1962: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1963: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1964: fnd_msg_pub.ADD;
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966:
1959: p_table_name => G_TABLE_NAME ,
1960: p_column_name => 'INCIDENT_LOCATION_TYPE' );
1961: WHEN OTHERS THEN
1962: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1963: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1964: fnd_msg_pub.ADD;
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966:
1967: END;
1996: p_token_p => p_parameter_name,
1997: p_table_name => G_TABLE_NAME,
1998: p_column_name => 'INCIDENT_COUNTRY' );
1999: WHEN OTHERS THEN
2000: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2001: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2002: fnd_msg_pub.ADD;
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004:
1997: p_table_name => G_TABLE_NAME,
1998: p_column_name => 'INCIDENT_COUNTRY' );
1999: WHEN OTHERS THEN
2000: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2001: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2002: fnd_msg_pub.ADD;
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004:
2005: END;
2063: p_table_name => G_TABLE_NAME,
2064: p_column_name => 'EMPLOYEE_ID' );
2065:
2066: WHEN OTHERS THEN
2067: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2068: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2069: fnd_msg_pub.ADD;
2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2071: END Validate_Employee;
2064: p_column_name => 'EMPLOYEE_ID' );
2065:
2066: WHEN OTHERS THEN
2067: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2068: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2069: fnd_msg_pub.ADD;
2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2071: END Validate_Employee;
2072:
2111: WHEN NO_DATA_FOUND THEN
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113:
2114: -- For bug 2885111 - adding a new error message
2115: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_CUSTOMER');
2116: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2117: FND_MESSAGE.Set_Token('VALUE',l_token_v);
2118: FND_MESSAGE.Set_Token('P_NAME', p_parameter_name);
2119: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113:
2114: -- For bug 2885111 - adding a new error message
2115: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_CUSTOMER');
2116: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2117: FND_MESSAGE.Set_Token('VALUE',l_token_v);
2118: FND_MESSAGE.Set_Token('P_NAME', p_parameter_name);
2119: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
2120:
2113:
2114: -- For bug 2885111 - adding a new error message
2115: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_CUSTOMER');
2116: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2117: FND_MESSAGE.Set_Token('VALUE',l_token_v);
2118: FND_MESSAGE.Set_Token('P_NAME', p_parameter_name);
2119: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
2120:
2121:
2114: -- For bug 2885111 - adding a new error message
2115: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_CUSTOMER');
2116: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
2117: FND_MESSAGE.Set_Token('VALUE',l_token_v);
2118: FND_MESSAGE.Set_Token('P_NAME', p_parameter_name);
2119: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
2120:
2121:
2122: /* Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
2124: p_token_p => p_parameter_name,
2125: p_table_name => G_TABLE_NAME,
2126: p_column_name => 'CUSTOMER_ID' ); */
2127: WHEN OTHERS THEN
2128: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2129: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2130: fnd_msg_pub.ADD;
2131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2132:
2125: p_table_name => G_TABLE_NAME,
2126: p_column_name => 'CUSTOMER_ID' ); */
2127: WHEN OTHERS THEN
2128: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2129: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2130: fnd_msg_pub.ADD;
2131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2132:
2133: END;
2133: END;
2134: --Addition for 3666089 starts
2135: IF (l_party_type <> p_caller_type) THEN
2136: x_return_status := FND_API.G_RET_STS_ERROR;
2137: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_CUST_TYPE');
2138: FND_MSG_PUB.ADD; --3666089 (Jun 15)
2139: END IF;
2140: --Addition for 3666089 Ends
2141:
2224: p_table_name => G_TABLE_NAME,
2225: p_column_name => 'BILL_TO_CONTACT_ID' );
2226:
2227: WHEN OTHERS THEN
2228: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2229: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2230: fnd_msg_pub.ADD;
2231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2232:
2225: p_column_name => 'BILL_TO_CONTACT_ID' );
2226:
2227: WHEN OTHERS THEN
2228: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2229: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2230: fnd_msg_pub.ADD;
2231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2232:
2233: END Validate_Bill_To_Ship_To_Ct;
2306: p_table_name => G_TABLE_NAME,
2307: p_column_name => 'CUSTOMER_CONTACT_ID' );
2308:
2309: WHEN OTHERS THEN
2310: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2311: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2312: fnd_msg_pub.ADD;
2313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2314:
2307: p_column_name => 'CUSTOMER_CONTACT_ID' );
2308:
2309: WHEN OTHERS THEN
2310: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2311: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2312: fnd_msg_pub.ADD;
2313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2314:
2315: END Validate_Customer_Contact;
2374: p_token_p => p_parameter_name,
2375: p_table_name => G_TABLE_NAME,
2376: p_column_name => 'CUSTOMER_CONTACT_ID' );
2377: WHEN OTHERS THEN
2378: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2379: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2380: fnd_msg_pub.ADD;
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382:
2375: p_table_name => G_TABLE_NAME,
2376: p_column_name => 'CUSTOMER_CONTACT_ID' );
2377: WHEN OTHERS THEN
2378: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2379: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2380: fnd_msg_pub.ADD;
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382:
2383: END Validate_Org_Relationship;
2441: p_token_p => p_parameter_name,
2442: p_table_name => G_TABLE_NAME,
2443: p_column_name => 'CUSTOMER_CONTACT_ID' );
2444: WHEN OTHERS THEN
2445: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2446: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2447: fnd_msg_pub.ADD;
2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2449:
2442: p_table_name => G_TABLE_NAME,
2443: p_column_name => 'CUSTOMER_CONTACT_ID' );
2444: WHEN OTHERS THEN
2445: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2446: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2447: fnd_msg_pub.ADD;
2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2449:
2450: END Validate_Person_Relationship;
2543: p_table_name => G_TABLE_NAME,
2544: p_column_name => 'CUSTOMER_PRODUCT_ID' );
2545:
2546: WHEN OTHERS THEN
2547: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2548: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2549: fnd_msg_pub.ADD;
2550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2551:
2544: p_column_name => 'CUSTOMER_PRODUCT_ID' );
2545:
2546: WHEN OTHERS THEN
2547: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2548: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2549: fnd_msg_pub.ADD;
2550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2551:
2552: END Validate_Customer_Product;
2646: p_table_name => G_TABLE_NAME,
2647: p_column_name => 'CURRENT_SERIAL_NUMBER');
2648:
2649: WHEN OTHERS THEN
2650: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2651: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2652: fnd_msg_pub.ADD;
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2654:
2647: p_column_name => 'CURRENT_SERIAL_NUMBER');
2648:
2649: WHEN OTHERS THEN
2650: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2651: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2652: fnd_msg_pub.ADD;
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2654:
2655: END Validate_Current_Serial;
2717: p_table_name => G_TABLE_NAME,
2718: p_column_name => 'INVENTORY_ORG_ID');
2719:
2720: WHEN OTHERS THEN
2721: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2722: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2723: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2724: fnd_msg_pub.ADD;
2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2718: p_column_name => 'INVENTORY_ORG_ID');
2719:
2720: WHEN OTHERS THEN
2721: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2722: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2723: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2724: fnd_msg_pub.ADD;
2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2726:
2719:
2720: WHEN OTHERS THEN
2721: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2722: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2723: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2724: fnd_msg_pub.ADD;
2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2726:
2727: END Validate_Inventory_Org;
2767: p_table_name => G_TABLE_NAME,
2768: p_column_name => 'OWNING_DEPARTMENT_ID');
2769:
2770: WHEN OTHERS THEN
2771: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2772: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2773: fnd_msg_pub.ADD;
2774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2775:
2768: p_column_name => 'OWNING_DEPARTMENT_ID');
2769:
2770: WHEN OTHERS THEN
2771: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2772: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2773: fnd_msg_pub.ADD;
2774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2775:
2776: END Validate_Owning_Department;
2883: , p_table_name => G_TABLE_NAME
2884: , p_column_name => 'INVENTORY_ITEM_ID'
2885: );
2886: WHEN OTHERS THEN
2887: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2888: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2889: fnd_msg_pub.ADD;
2890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2891: END Validate_Product;
2884: , p_column_name => 'INVENTORY_ITEM_ID'
2885: );
2886: WHEN OTHERS THEN
2887: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2888: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2889: fnd_msg_pub.ADD;
2890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2891: END Validate_Product;
2892:
2950: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2951: -- new message for 11.5.10
2952: -- Problem code is not valid. Please check the values for the following:\
2953: -- Service request type, inventory item and product category.
2954: fnd_message.set_name ('CS', 'CS_SR_PROB_CODE_INVALID');
2955: fnd_message.set_token('API_NAME', l_api_name_full );
2956: fnd_msg_pub.add;
2957: end if;
2958:
2951: -- new message for 11.5.10
2952: -- Problem code is not valid. Please check the values for the following:\
2953: -- Service request type, inventory item and product category.
2954: fnd_message.set_name ('CS', 'CS_SR_PROB_CODE_INVALID');
2955: fnd_message.set_token('API_NAME', l_api_name_full );
2956: fnd_msg_pub.add;
2957: end if;
2958:
2959:
2958:
2959:
2960: EXCEPTION
2961: WHEN OTHERS THEN
2962: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2963: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2964: fnd_msg_pub.ADD;
2965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2966:
2959:
2960: EXCEPTION
2961: WHEN OTHERS THEN
2962: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
2963: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
2964: fnd_msg_pub.ADD;
2965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2966:
2967: END Validate_Problem_Code;
3000: p_token_p => p_parameter_name,
3001: p_table_name => G_TABLE_NAME,
3002: p_column_name => 'CUST_PERF_LANG_CODE');
3003: WHEN OTHERS THEN
3004: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3005: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3006: fnd_msg_pub.ADD;
3007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3008:
3001: p_table_name => G_TABLE_NAME,
3002: p_column_name => 'CUST_PERF_LANG_CODE');
3003: WHEN OTHERS THEN
3004: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3005: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3006: fnd_msg_pub.ADD;
3007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3008:
3009: END;
3040: p_token_p => p_parameter_name,
3041: p_table_name => G_TABLE_NAME,
3042: p_column_name => 'COMM_PREF_CODE' );
3043: WHEN OTHERS THEN
3044: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3045: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3046: fnd_msg_pub.ADD;
3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3048: END;
3041: p_table_name => G_TABLE_NAME,
3042: p_column_name => 'COMM_PREF_CODE' );
3043: WHEN OTHERS THEN
3044: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3045: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3046: fnd_msg_pub.ADD;
3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3048: END;
3049: END Validate_Comm_Pref_Code;
3101:
3102: EXCEPTION
3103: WHEN NO_DATA_FOUND THEN
3104: x_return_status := FND_API.G_RET_STS_ERROR;
3105: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3106: fnd_message.set_token ('CAT_SET',nvl(l_profile,'NULL'));
3107: fnd_message.set_token ('CAT_ID',p_category_id);
3108: fnd_msg_pub.ADD;
3109: WHEN OTHERS THEN
3102: EXCEPTION
3103: WHEN NO_DATA_FOUND THEN
3104: x_return_status := FND_API.G_RET_STS_ERROR;
3105: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3106: fnd_message.set_token ('CAT_SET',nvl(l_profile,'NULL'));
3107: fnd_message.set_token ('CAT_ID',p_category_id);
3108: fnd_msg_pub.ADD;
3109: WHEN OTHERS THEN
3110: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3103: WHEN NO_DATA_FOUND THEN
3104: x_return_status := FND_API.G_RET_STS_ERROR;
3105: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3106: fnd_message.set_token ('CAT_SET',nvl(l_profile,'NULL'));
3107: fnd_message.set_token ('CAT_ID',p_category_id);
3108: fnd_msg_pub.ADD;
3109: WHEN OTHERS THEN
3110: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3111: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3106: fnd_message.set_token ('CAT_SET',nvl(l_profile,'NULL'));
3107: fnd_message.set_token ('CAT_ID',p_category_id);
3108: fnd_msg_pub.ADD;
3109: WHEN OTHERS THEN
3110: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3111: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3112: fnd_msg_pub.ADD;
3113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3114:
3107: fnd_message.set_token ('CAT_ID',p_category_id);
3108: fnd_msg_pub.ADD;
3109: WHEN OTHERS THEN
3110: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3111: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3112: fnd_msg_pub.ADD;
3113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3114:
3115: END;
3167: EXCEPTION
3168: WHEN NO_DATA_FOUND THEN
3169: x_return_status := FND_API.G_RET_STS_ERROR;
3170: IF (l_validation = 'I') THEN
3171: fnd_message.set_name ('CS', 'CS_SR_CAT_ITEM_COMB_INVALID');
3172: fnd_message.set_token ('CAT_SET',p_category_set_id);
3173: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3174: fnd_message.set_token ('ITEM_ID',nvl(to_char(p_inventory_item_id),'NULL'));
3175: fnd_msg_pub.ADD;
3168: WHEN NO_DATA_FOUND THEN
3169: x_return_status := FND_API.G_RET_STS_ERROR;
3170: IF (l_validation = 'I') THEN
3171: fnd_message.set_name ('CS', 'CS_SR_CAT_ITEM_COMB_INVALID');
3172: fnd_message.set_token ('CAT_SET',p_category_set_id);
3173: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3174: fnd_message.set_token ('ITEM_ID',nvl(to_char(p_inventory_item_id),'NULL'));
3175: fnd_msg_pub.ADD;
3176: ELSE
3169: x_return_status := FND_API.G_RET_STS_ERROR;
3170: IF (l_validation = 'I') THEN
3171: fnd_message.set_name ('CS', 'CS_SR_CAT_ITEM_COMB_INVALID');
3172: fnd_message.set_token ('CAT_SET',p_category_set_id);
3173: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3174: fnd_message.set_token ('ITEM_ID',nvl(to_char(p_inventory_item_id),'NULL'));
3175: fnd_msg_pub.ADD;
3176: ELSE
3177: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3170: IF (l_validation = 'I') THEN
3171: fnd_message.set_name ('CS', 'CS_SR_CAT_ITEM_COMB_INVALID');
3172: fnd_message.set_token ('CAT_SET',p_category_set_id);
3173: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3174: fnd_message.set_token ('ITEM_ID',nvl(to_char(p_inventory_item_id),'NULL'));
3175: fnd_msg_pub.ADD;
3176: ELSE
3177: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3178: fnd_message.set_token ('CAT_SET',p_category_set_id);
3173: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3174: fnd_message.set_token ('ITEM_ID',nvl(to_char(p_inventory_item_id),'NULL'));
3175: fnd_msg_pub.ADD;
3176: ELSE
3177: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3178: fnd_message.set_token ('CAT_SET',p_category_set_id);
3179: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3180: fnd_msg_pub.ADD;
3181: END IF;
3174: fnd_message.set_token ('ITEM_ID',nvl(to_char(p_inventory_item_id),'NULL'));
3175: fnd_msg_pub.ADD;
3176: ELSE
3177: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3178: fnd_message.set_token ('CAT_SET',p_category_set_id);
3179: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3180: fnd_msg_pub.ADD;
3181: END IF;
3182: WHEN OTHERS THEN
3175: fnd_msg_pub.ADD;
3176: ELSE
3177: fnd_message.set_name ('CS', 'CS_SR_CAT_CATSET_COMB_INVALID');
3178: fnd_message.set_token ('CAT_SET',p_category_set_id);
3179: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3180: fnd_msg_pub.ADD;
3181: END IF;
3182: WHEN OTHERS THEN
3183: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3179: fnd_message.set_token ('CAT_ID',nvl(to_char(p_category_id),'NULL'));
3180: fnd_msg_pub.ADD;
3181: END IF;
3182: WHEN OTHERS THEN
3183: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3184: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3185: fnd_msg_pub.ADD;
3186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3187:
3180: fnd_msg_pub.ADD;
3181: END IF;
3182: WHEN OTHERS THEN
3183: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3184: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3185: fnd_msg_pub.ADD;
3186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3187:
3188: END Validate_Category_Set_Id;
3322: p_token_p => p_parameter_name ,
3323: p_table_name => G_TABLE_NAME,
3324: p_column_name => 'EXTERNAL_REFERENCE');
3325: WHEN OTHERS THEN
3326: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3327: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3328: fnd_msg_pub.ADD;
3329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3330:
3323: p_table_name => G_TABLE_NAME,
3324: p_column_name => 'EXTERNAL_REFERENCE');
3325: WHEN OTHERS THEN
3326: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3327: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3328: fnd_msg_pub.ADD;
3329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3330:
3331: END Validate_External_Reference;
3361: p_token_p => p_parameter_name,
3362: p_table_name => G_TABLE_NAME,
3363: p_column_name => 'SYSTEM_ID' );
3364: WHEN OTHERS THEN
3365: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3366: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3367: fnd_msg_pub.ADD;
3368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3369:
3362: p_table_name => G_TABLE_NAME,
3363: p_column_name => 'SYSTEM_ID' );
3364: WHEN OTHERS THEN
3365: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3366: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3367: fnd_msg_pub.ADD;
3368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3369:
3370: END Validate_System_Id;
3402: END IF;
3403:
3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3407: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3408: fnd_msg_pub.ADD;
3409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3410:
3403:
3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3407: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3408: fnd_msg_pub.ADD;
3409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3410:
3411: END Validate_Exp_Resolution_Date;
3481: p_token_p => p_parameter_name,
3482: p_table_name => G_TABLE_NAME,
3483: p_column_name => 'BILL_TO_CUSTOMER_ID');
3484: WHEN OTHERS THEN
3485: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3486: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3487: fnd_msg_pub.ADD;
3488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3489: END Validate_Bill_To_Ship_To_Party;
3482: p_table_name => G_TABLE_NAME,
3483: p_column_name => 'BILL_TO_CUSTOMER_ID');
3484: WHEN OTHERS THEN
3485: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3486: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3487: fnd_msg_pub.ADD;
3488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3489: END Validate_Bill_To_Ship_To_Party;
3490:
3545: p_token_p => p_parameter_name,
3546: p_table_name => G_TABLE_NAME ,
3547: p_column_name => 'BILL_TO_SITE_ID' );
3548: WHEN OTHERS THEN
3549: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3550: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3551: fnd_msg_pub.ADD;
3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3553: END Validate_Bill_To_Ship_To_Site ;
3546: p_table_name => G_TABLE_NAME ,
3547: p_column_name => 'BILL_TO_SITE_ID' );
3548: WHEN OTHERS THEN
3549: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3550: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3551: fnd_msg_pub.ADD;
3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3553: END Validate_Bill_To_Ship_To_Site ;
3554:
3615: p_table_name => G_TABLE_NAME,
3616: p_column_name => 'INSTALL_SITE_ID' );
3617:
3618: WHEN OTHERS THEN
3619: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3620: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3621: fnd_msg_pub.ADD;
3622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3623:
3616: p_column_name => 'INSTALL_SITE_ID' );
3617:
3618: WHEN OTHERS THEN
3619: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3620: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3621: fnd_msg_pub.ADD;
3622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3623:
3624: END;
3655: p_token_p => p_parameter_name,
3656: p_table_name => G_TABLE_NAME,
3657: p_column_name => 'RESOLUTION_CODE' );
3658: WHEN OTHERS THEN
3659: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3660: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3661: fnd_msg_pub.ADD;
3662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3663:
3656: p_table_name => G_TABLE_NAME,
3657: p_column_name => 'RESOLUTION_CODE' );
3658: WHEN OTHERS THEN
3659: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3660: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3661: fnd_msg_pub.ADD;
3662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3663:
3664: END Validate_Resolution_Code;
3692: p_column_name => 'ACTUAL_RESOLUTION_DATE' );
3693: END IF;
3694: EXCEPTION
3695: WHEN OTHERS THEN
3696: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3697: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3698: fnd_msg_pub.ADD;
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700:
3693: END IF;
3694: EXCEPTION
3695: WHEN OTHERS THEN
3696: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3697: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3698: fnd_msg_pub.ADD;
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700:
3701: END Validate_Act_Resolution_Date;
3760: p_table_name => G_TABLE_NAME,
3761: p_column_name => 'CONTRACT_SERVICE_ID');
3762:
3763: WHEN OTHERS THEN
3764: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3765: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3766: fnd_msg_pub.ADD;
3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3768: END Validate_Contract_Service_Id;
3761: p_column_name => 'CONTRACT_SERVICE_ID');
3762:
3763: WHEN OTHERS THEN
3764: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3765: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3766: fnd_msg_pub.ADD;
3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3768: END Validate_Contract_Service_Id;
3769: ---------------------------------------------------------------------------
3798: p_table_name => G_TABLE_NAME,
3799: p_column_name => 'CONTRACT_ID' );
3800:
3801: WHEN OTHERS THEN
3802: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3803: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3804: fnd_msg_pub.ADD;
3805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3806:
3799: p_column_name => 'CONTRACT_ID' );
3800:
3801: WHEN OTHERS THEN
3802: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3803: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3804: fnd_msg_pub.ADD;
3805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3806:
3807:
3858: p_table_name => null,
3859: p_column_name => 'P_SUPPORT_SITE_ID' );
3860:
3861: WHEN OTHERS THEN
3862: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3863: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3864: fnd_msg_pub.ADD;
3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3866: END Validate_Support_Site_Id;
3859: p_column_name => 'P_SUPPORT_SITE_ID' );
3860:
3861: WHEN OTHERS THEN
3862: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3863: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3864: fnd_msg_pub.ADD;
3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3866: END Validate_Support_Site_Id;
3867: ---------------------------------------------------------
3905: p_table_name => G_TABLE_NAME ,
3906: p_column_name => 'GROUP_TYPE' );
3907:
3908: WHEN OTHERS THEN
3909: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3910: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3911: fnd_msg_pub.ADD;
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3913:
3906: p_column_name => 'GROUP_TYPE' );
3907:
3908: WHEN OTHERS THEN
3909: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3910: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3911: fnd_msg_pub.ADD;
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3913:
3914:
3964: p_table_name => G_TABLE_NAME,
3965: p_column_name => 'OWNER_GROUP_ID');
3966:
3967: WHEN OTHERS THEN
3968: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3969: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3970: fnd_msg_pub.ADD;
3971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3972: END Validate_Group_Id;
3965: p_column_name => 'OWNER_GROUP_ID');
3966:
3967: WHEN OTHERS THEN
3968: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
3969: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
3970: fnd_msg_pub.ADD;
3971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3972: END Validate_Group_Id;
3973:
4079: , p_column_name => 'incident_owner_id'
4080: );
4081: END IF;
4082: WHEN OTHERS THEN
4083: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4084: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4085: fnd_msg_pub.ADD;
4086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4087: END Validate_Owner;
4080: );
4081: END IF;
4082: WHEN OTHERS THEN
4083: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4084: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4085: fnd_msg_pub.ADD;
4086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4087: END Validate_Owner;
4088:
4119: p_table_name => G_TABLE_NAME,
4120: p_column_name => 'RESOURCE_TYPE');
4121:
4122: WHEN OTHERS THEN
4123: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4124: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4125: fnd_msg_pub.ADD;
4126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4127: END Validate_Resource_Type;
4120: p_column_name => 'RESOURCE_TYPE');
4121:
4122: WHEN OTHERS THEN
4123: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4124: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4125: fnd_msg_pub.ADD;
4126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4127: END Validate_Resource_Type;
4128:
4178: p_table_name => G_TABLE_NAME ,
4179: p_column_name => 'PLATFORM_ID' );
4180:
4181: WHEN OTHERS THEN
4182: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4183: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4184: fnd_msg_pub.ADD;
4185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4186:
4179: p_column_name => 'PLATFORM_ID' );
4180:
4181: WHEN OTHERS THEN
4182: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4183: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4184: fnd_msg_pub.ADD;
4185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4186:
4187: END Validate_Platform_Id;
4220: p_table_name => G_TABLE_NAME ,
4221: p_column_name => 'CP_COMPONENT_ID');
4222:
4223: WHEN OTHERS THEN
4224: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4225: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4226: fnd_msg_pub.ADD;
4227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4228:
4221: p_column_name => 'CP_COMPONENT_ID');
4222:
4223: WHEN OTHERS THEN
4224: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4225: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4226: fnd_msg_pub.ADD;
4227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4228:
4229: END Validate_CP_Comp_Id;
4272: p_table_name => null,
4273: p_column_name => null);
4274:
4275: WHEN OTHERS THEN
4276: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4277: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4278: fnd_msg_pub.ADD;
4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4280: END;
4273: p_column_name => null);
4274:
4275: WHEN OTHERS THEN
4276: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4277: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4278: fnd_msg_pub.ADD;
4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4280: END;
4281: END IF;
4371: p_token_p => p_parameter_name,
4372: p_table_name => G_TABLE_NAME ,
4373: p_column_name => 'COMPONENT_VERSION' );
4374: WHEN OTHERS THEN
4375: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4376: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4377: fnd_msg_pub.ADD;
4378: x_return_status := fnd_api.g_ret_sts_unexp_error;
4379: END Validate_product_Version;
4372: p_table_name => G_TABLE_NAME ,
4373: p_column_name => 'COMPONENT_VERSION' );
4374: WHEN OTHERS THEN
4375: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4376: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4377: fnd_msg_pub.ADD;
4378: x_return_status := fnd_api.g_ret_sts_unexp_error;
4379: END Validate_product_Version;
4380: --
4443: p_table_name => null,
4444: p_column_name => null);
4445:
4446: WHEN OTHERS THEN
4447: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4448: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4449: fnd_msg_pub.ADD;
4450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4451: END;
4444: p_column_name => null);
4445:
4446: WHEN OTHERS THEN
4447: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4448: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4449: fnd_msg_pub.ADD;
4450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4451: END;
4452: END IF;
4462: p_token_p => p_parameter_name,
4463: p_table_name => G_TABLE_NAME ,
4464: p_column_name => 'COMPONENT_VERSION' );
4465: WHEN OTHERS THEN
4466: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4467: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4468: fnd_msg_pub.ADD;
4469: x_return_status := fnd_api.g_ret_sts_unexp_error;
4470: END;
4463: p_table_name => G_TABLE_NAME ,
4464: p_column_name => 'COMPONENT_VERSION' );
4465: WHEN OTHERS THEN
4466: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4467: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4468: fnd_msg_pub.ADD;
4469: x_return_status := fnd_api.g_ret_sts_unexp_error;
4470: END;
4471: END Validate_Component_Version;
4534: p_table_name => null,
4535: p_column_name => null);
4536:
4537: WHEN OTHERS THEN
4538: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4539: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4540: fnd_msg_pub.ADD;
4541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4542: END;
4535: p_column_name => null);
4536:
4537: WHEN OTHERS THEN
4538: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4539: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4540: fnd_msg_pub.ADD;
4541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4542: END;
4543: END IF;
4552: p_token_p => p_parameter_name ,
4553: p_table_name => G_TABLE_NAME,
4554: p_column_name => 'SUBCOMPONENT_VERSION');
4555: WHEN OTHERS THEN
4556: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4557: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4558: fnd_msg_pub.ADD;
4559: x_return_status := fnd_api.g_ret_sts_unexp_error;
4560: END;
4553: p_table_name => G_TABLE_NAME,
4554: p_column_name => 'SUBCOMPONENT_VERSION');
4555: WHEN OTHERS THEN
4556: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4557: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4558: fnd_msg_pub.ADD;
4559: x_return_status := fnd_api.g_ret_sts_unexp_error;
4560: END;
4561: END Validate_Subcomponent_Version;
4604: p_table_name => G_TABLE_NAME ,
4605: p_column_name => 'CP_SUBCOMPONENT_ID');
4606:
4607: WHEN OTHERS THEN
4608: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4609: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4610: fnd_msg_pub.ADD;
4611: x_return_status := fnd_api.g_ret_sts_unexp_error;
4612:
4605: p_column_name => 'CP_SUBCOMPONENT_ID');
4606:
4607: WHEN OTHERS THEN
4608: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4609: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4610: fnd_msg_pub.ADD;
4611: x_return_status := fnd_api.g_ret_sts_unexp_error;
4612:
4613: END Validate_CP_SubComp_Id;
4657: p_token_p => p_parameter_name,
4658: p_table_name => G_TABLE_NAME ,
4659: p_column_name => 'INV_ITEM_REVISION' );
4660: WHEN OTHERS THEN
4661: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4662: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4663: fnd_msg_pub.ADD;
4664: x_return_status := fnd_api.g_ret_sts_unexp_error;
4665:
4658: p_table_name => G_TABLE_NAME ,
4659: p_column_name => 'INV_ITEM_REVISION' );
4660: WHEN OTHERS THEN
4661: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4662: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4663: fnd_msg_pub.ADD;
4664: x_return_status := fnd_api.g_ret_sts_unexp_error;
4665:
4666: END;
4675: p_table_name => G_TABLE_NAME ,
4676: p_column_name => 'INVENTORY_ITEM_ID' );
4677:
4678: WHEN OTHERS THEN
4679: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4680: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4681: fnd_msg_pub.ADD;
4682: x_return_status := fnd_api.g_ret_sts_unexp_error;
4683:
4676: p_column_name => 'INVENTORY_ITEM_ID' );
4677:
4678: WHEN OTHERS THEN
4679: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4680: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4681: fnd_msg_pub.ADD;
4682: x_return_status := fnd_api.g_ret_sts_unexp_error;
4683:
4684: END;
4740: p_token_p => p_parameter_name,
4741: p_table_name => G_TABLE_NAME ,
4742: p_column_name => 'INV_COMPONENT_ID' );
4743: WHEN OTHERS THEN
4744: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4745: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4746: fnd_msg_pub.ADD;
4747: x_return_status := fnd_api.g_ret_sts_unexp_error;
4748:
4741: p_table_name => G_TABLE_NAME ,
4742: p_column_name => 'INV_COMPONENT_ID' );
4743: WHEN OTHERS THEN
4744: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4745: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4746: fnd_msg_pub.ADD;
4747: x_return_status := fnd_api.g_ret_sts_unexp_error;
4748:
4749: END Validate_Inv_Comp_Id;
4863: p_table_name => G_TABLE_NAME ,
4864: p_column_name => 'INV_SUBCOMPONENT_ID' );
4865:
4866: WHEN OTHERS THEN
4867: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4868: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4869: fnd_msg_pub.ADD;
4870: x_return_status := fnd_api.g_ret_sts_unexp_error;
4871:
4864: p_column_name => 'INV_SUBCOMPONENT_ID' );
4865:
4866: WHEN OTHERS THEN
4867: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4868: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4869: fnd_msg_pub.ADD;
4870: x_return_status := fnd_api.g_ret_sts_unexp_error;
4871:
4872: END Validate_Inv_SubComp_Id;
4914: p_token_p => p_parameter_name,
4915: p_table_name => G_TABLE_NAME ,
4916: p_column_name => 'INV_SUBCOMPONENT_VERSION' );
4917: WHEN OTHERS THEN
4918: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4919: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4920: fnd_msg_pub.ADD;
4921: x_return_status := fnd_api.g_ret_sts_unexp_error;
4922:
4915: p_table_name => G_TABLE_NAME ,
4916: p_column_name => 'INV_SUBCOMPONENT_VERSION' );
4917: WHEN OTHERS THEN
4918: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4919: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4920: fnd_msg_pub.ADD;
4921: x_return_status := fnd_api.g_ret_sts_unexp_error;
4922:
4923: END Validate_Inv_SubComp_Ver;
4953: p_token_p => p_parameter_name,
4954: p_table_name => G_TABLE_NAME ,
4955: p_column_name => 'SR_CREATION_CHANNEL' );
4956: WHEN OTHERS THEN
4957: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4958: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4959: fnd_msg_pub.ADD;
4960: x_return_status := fnd_api.g_ret_sts_unexp_error;
4961:
4954: p_table_name => G_TABLE_NAME ,
4955: p_column_name => 'SR_CREATION_CHANNEL' );
4956: WHEN OTHERS THEN
4957: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4958: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4959: fnd_msg_pub.ADD;
4960: x_return_status := fnd_api.g_ret_sts_unexp_error;
4961:
4962: END Validate_SR_Channel;
4992: p_token_p => p_parameter_name,
4993: p_table_name => G_TABLE_NAME,
4994: p_column_name => 'LANGUAGE_ID');
4995: WHEN OTHERS THEN
4996: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4997: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4998: fnd_msg_pub.ADD;
4999: x_return_status := fnd_api.g_ret_sts_unexp_error;
5000:
4993: p_table_name => G_TABLE_NAME,
4994: p_column_name => 'LANGUAGE_ID');
4995: WHEN OTHERS THEN
4996: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
4997: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
4998: fnd_msg_pub.ADD;
4999: x_return_status := fnd_api.g_ret_sts_unexp_error;
5000:
5001: END Validate_CP_Language_Id;
5031: p_token_p => p_parameter_name,
5032: p_table_name => G_TABLE_NAME,
5033: p_column_name => 'TERRITORY_ID');
5034: WHEN OTHERS THEN
5035: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5036: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5037: fnd_msg_pub.ADD;
5038: x_return_status := fnd_api.g_ret_sts_unexp_error;
5039:
5032: p_table_name => G_TABLE_NAME,
5033: p_column_name => 'TERRITORY_ID');
5034: WHEN OTHERS THEN
5035: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5036: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5037: fnd_msg_pub.ADD;
5038: x_return_status := fnd_api.g_ret_sts_unexp_error;
5039:
5040: END Validate_Territory_Id;
5074: -- new message for 11.5.10
5075: -- Contact point is not valid. Please check the values for the following:
5076: -- party ,contact point and contact point type.
5077:
5078: fnd_message.set_name ('CS', 'CS_SR_CONT_POINT_INVALID');
5079: fnd_message.set_token('API_NAME', l_api_name_full );
5080: fnd_msg_pub.add;
5081:
5082: WHEN OTHERS THEN
5075: -- Contact point is not valid. Please check the values for the following:
5076: -- party ,contact point and contact point type.
5077:
5078: fnd_message.set_name ('CS', 'CS_SR_CONT_POINT_INVALID');
5079: fnd_message.set_token('API_NAME', l_api_name_full );
5080: fnd_msg_pub.add;
5081:
5082: WHEN OTHERS THEN
5083: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5079: fnd_message.set_token('API_NAME', l_api_name_full );
5080: fnd_msg_pub.add;
5081:
5082: WHEN OTHERS THEN
5083: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5084: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5085: fnd_msg_pub.ADD;
5086: x_return_status := fnd_api.g_ret_sts_unexp_error;
5087:
5080: fnd_msg_pub.add;
5081:
5082: WHEN OTHERS THEN
5083: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5084: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5085: fnd_msg_pub.ADD;
5086: x_return_status := fnd_api.g_ret_sts_unexp_error;
5087:
5088: END Validate_Per_Contact_Point_Id;
5120: p_token_p => p_parameter_name,
5121: p_table_name => 'CS_HZ_SR_CONTACT_POINTS' ,
5122: p_column_name => 'CONTACT_POINT_ID');
5123: WHEN OTHERS THEN
5124: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5125: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5126: fnd_msg_pub.ADD;
5127: x_return_status := fnd_api.g_ret_sts_unexp_error;
5128:
5121: p_table_name => 'CS_HZ_SR_CONTACT_POINTS' ,
5122: p_column_name => 'CONTACT_POINT_ID');
5123: WHEN OTHERS THEN
5124: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5125: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5126: fnd_msg_pub.ADD;
5127: x_return_status := fnd_api.g_ret_sts_unexp_error;
5128:
5129: END Validate_Emp_Contact_Point_Id;
5161: p_token_p => p_parameter_name,
5162: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
5163: p_column_name => 'CONTACT_POINT_TYPE');
5164: WHEN OTHERS THEN
5165: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5166: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5167: fnd_msg_pub.ADD;
5168: x_return_status := fnd_api.g_ret_sts_unexp_error;
5169: END Validate_Contact_Point_Type;
5162: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
5163: p_column_name => 'CONTACT_POINT_TYPE');
5164: WHEN OTHERS THEN
5165: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5166: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5167: fnd_msg_pub.ADD;
5168: x_return_status := fnd_api.g_ret_sts_unexp_error;
5169: END Validate_Contact_Point_Type;
5170:
5200: p_token_p => p_parameter_name,
5201: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
5202: p_column_name => 'CONTACT_TYPE');
5203: WHEN OTHERS THEN
5204: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5205: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5206: fnd_msg_pub.ADD;
5207: x_return_status := fnd_api.g_ret_sts_unexp_error;
5208: END Validate_Contact_Type;
5201: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
5202: p_column_name => 'CONTACT_TYPE');
5203: WHEN OTHERS THEN
5204: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5205: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5206: fnd_msg_pub.ADD;
5207: x_return_status := fnd_api.g_ret_sts_unexp_error;
5208: END Validate_Contact_Type;
5209: ---------------------------------------
5241: p_token_p => p_parameter_name,
5242: p_table_name => G_TABLE_NAME ,
5243: p_column_name => 'ACCOUNT_ID');
5244: WHEN OTHERS THEN
5245: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5246: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5247: fnd_msg_pub.ADD;
5248: x_return_status := fnd_api.g_ret_sts_unexp_error;
5249:
5242: p_table_name => G_TABLE_NAME ,
5243: p_column_name => 'ACCOUNT_ID');
5244: WHEN OTHERS THEN
5245: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5246: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5247: fnd_msg_pub.ADD;
5248: x_return_status := fnd_api.g_ret_sts_unexp_error;
5249:
5250: END Validate_Account_Id;
5304: )
5305: IS
5306: BEGIN
5307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5308: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5309: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5310: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5311: FND_MSG_PUB.ADD;
5312: END IF;
5305: IS
5306: BEGIN
5307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5308: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5309: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5310: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5311: FND_MSG_PUB.ADD;
5312: END IF;
5313: END Add_Desc_Flex_Msg;
5306: BEGIN
5307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5308: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5309: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5310: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5311: FND_MSG_PUB.ADD;
5312: END IF;
5313: END Add_Desc_Flex_Msg;
5314:
5337: -- end for bug 2833245
5338:
5339:
5340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5341: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5342: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5343: --bug 2833245 pass the local variable for setting the token
5344: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5345: -- end for bug 2833245
5338:
5339:
5340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5341: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5342: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5343: --bug 2833245 pass the local variable for setting the token
5344: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5345: -- end for bug 2833245
5346: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5341: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5342: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5343: --bug 2833245 pass the local variable for setting the token
5344: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5345: -- end for bug 2833245
5346: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5347: FND_MSG_PUB.ADD;
5348: END IF;
5342: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5343: --bug 2833245 pass the local variable for setting the token
5344: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5345: -- end for bug 2833245
5346: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5347: FND_MSG_PUB.ADD;
5348: END IF;
5349: END Add_Invalid_Argument_Msg;
5350:
5365: )
5366: IS
5367: BEGIN
5368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5369: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5370: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5371: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5372: FND_MSG_PUB.ADD;
5373: END IF;
5366: IS
5367: BEGIN
5368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5369: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5370: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5371: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5372: FND_MSG_PUB.ADD;
5373: END IF;
5374: END Add_Key_Flex_Msg;
5367: BEGIN
5368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5369: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5370: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5371: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5372: FND_MSG_PUB.ADD;
5373: END IF;
5374: END Add_Key_Flex_Msg;
5375:
5384: )
5385: IS
5386: BEGIN
5387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5388: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5389: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5390: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5391: FND_MSG_PUB.ADD;
5392: END IF;
5385: IS
5386: BEGIN
5387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5388: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5389: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5390: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5391: FND_MSG_PUB.ADD;
5392: END IF;
5393: END Add_Null_Parameter_Msg;
5386: BEGIN
5387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5388: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5389: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5390: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5391: FND_MSG_PUB.ADD;
5392: END IF;
5393: END Add_Null_Parameter_Msg;
5394:
5403: )
5404: IS
5405: BEGIN
5406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5407: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
5408: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5409: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
5410: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5411: END IF;
5404: IS
5405: BEGIN
5406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5407: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
5408: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5409: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
5410: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5411: END IF;
5412: END Add_Param_Ignored_Msg;
5405: BEGIN
5406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5407: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
5408: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5409: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
5410: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5411: END IF;
5412: END Add_Param_Ignored_Msg;
5413:
5424: )
5425: IS
5426: BEGIN
5427: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5428: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CP_FLAG_IGNORED');
5429: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5430: FND_MESSAGE.Set_Token('VALUE', p_token_ip);
5431: FND_MESSAGE.Set_Token('DEFAULT_VALUE', p_token_pv);
5432: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5425: IS
5426: BEGIN
5427: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5428: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CP_FLAG_IGNORED');
5429: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5430: FND_MESSAGE.Set_Token('VALUE', p_token_ip);
5431: FND_MESSAGE.Set_Token('DEFAULT_VALUE', p_token_pv);
5432: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5433: END IF;
5426: BEGIN
5427: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5428: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CP_FLAG_IGNORED');
5429: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5430: FND_MESSAGE.Set_Token('VALUE', p_token_ip);
5431: FND_MESSAGE.Set_Token('DEFAULT_VALUE', p_token_pv);
5432: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5433: END IF;
5434: END Add_Cp_Flag_Ignored_Msg;
5427: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5428: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CP_FLAG_IGNORED');
5429: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5430: FND_MESSAGE.Set_Token('VALUE', p_token_ip);
5431: FND_MESSAGE.Set_Token('DEFAULT_VALUE', p_token_pv);
5432: FND_MSG_PUB.ADD_DETAIL( p_message_type => FND_MSG_PUB.G_WARNING_MSG);
5433: END IF;
5434: END Add_Cp_Flag_Ignored_Msg;
5435:
5442: p_token_p IN VARCHAR2 ) IS
5443:
5444: BEGIN
5445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5446: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
5447: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5448: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
5449: FND_MSG_PUB.ADD;
5450: END IF;
5443:
5444: BEGIN
5445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5446: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
5447: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5448: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
5449: FND_MSG_PUB.ADD;
5450: END IF;
5451: END Add_Duplicate_Value_Msg;
5444: BEGIN
5445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5446: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
5447: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5448: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
5449: FND_MSG_PUB.ADD;
5450: END IF;
5451: END Add_Duplicate_Value_Msg;
5452:
5454: PROCEDURE Add_Same_Val_Update_Msg( p_token_an IN VARCHAR2,
5455: p_token_p IN VARCHAR2 ) IS
5456: BEGIN
5457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5458: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
5459: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5460: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
5461: FND_MSG_PUB.ADD;
5462: END IF;
5455: p_token_p IN VARCHAR2 ) IS
5456: BEGIN
5457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5458: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
5459: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5460: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
5461: FND_MSG_PUB.ADD;
5462: END IF;
5463: END Add_Same_Val_Update_Msg;
5456: BEGIN
5457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5458: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
5459: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5460: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
5461: FND_MSG_PUB.ADD;
5462: END IF;
5463: END Add_Same_Val_Update_Msg;
5464:
5466: PROCEDURE Add_Missing_Param_Msg( p_token_an IN VARCHAR2,
5467: p_token_mp IN VARCHAR2 ) IS
5468: BEGIN
5469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5470: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5471: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5472: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5473: FND_MSG_PUB.ADD;
5474: END IF;
5467: p_token_mp IN VARCHAR2 ) IS
5468: BEGIN
5469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5470: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5471: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5472: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5473: FND_MSG_PUB.ADD;
5474: END IF;
5475: END Add_Missing_Param_Msg;
5468: BEGIN
5469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5470: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5471: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5472: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5473: FND_MSG_PUB.ADD;
5474: END IF;
5475: END Add_Missing_Param_Msg;
5476:
5512: WHEN fnd_api.g_exc_unexpected_error THEN
5513: x_return_status := fnd_api.g_ret_sts_unexp_error;
5514:
5515: WHEN OTHERS THEN
5516: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5517: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5518: fnd_msg_pub.ADD;
5519: x_return_status := fnd_api.g_ret_sts_unexp_error;
5520:
5513: x_return_status := fnd_api.g_ret_sts_unexp_error;
5514:
5515: WHEN OTHERS THEN
5516: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5517: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5518: fnd_msg_pub.ADD;
5519: x_return_status := fnd_api.g_ret_sts_unexp_error;
5520:
5521: END call_internal_hook ;
5564: p_table_name => G_TABLE_NAME,
5565: p_column_name => 'ACCOUNT_ID' );
5566:
5567: WHEN OTHERS THEN
5568: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5569: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5570: fnd_msg_pub.ADD;
5571: x_return_status := fnd_api.g_ret_sts_unexp_error;
5572: END Validate_Bill_To_Ship_To_Acct ;
5565: p_column_name => 'ACCOUNT_ID' );
5566:
5567: WHEN OTHERS THEN
5568: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5569: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5570: fnd_msg_pub.ADD;
5571: x_return_status := fnd_api.g_ret_sts_unexp_error;
5572: END Validate_Bill_To_Ship_To_Acct ;
5573:
5629: p_table_name => G_TABLE_NAME,
5630: p_column_name => 'CREATION_PROGRAM_CODE' );
5631:
5632: WHEN OTHERS THEN
5633: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5634: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5635: fnd_msg_pub.ADD;
5636: x_return_status := fnd_api.g_ret_sts_unexp_error;
5637: END Validate_source_program_Code;
5630: p_column_name => 'CREATION_PROGRAM_CODE' );
5631:
5632: WHEN OTHERS THEN
5633: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5634: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5635: fnd_msg_pub.ADD;
5636: x_return_status := fnd_api.g_ret_sts_unexp_error;
5637: END Validate_source_program_Code;
5638: -- -----------------------------------------------------------------------
5691: p_table_name => G_TABLE_NAME,
5692: p_column_name => 'INCIDENT_DISTANCE_QUAL_UOM');
5693:
5694: WHEN OTHERS THEN
5695: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5696: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5697: fnd_msg_pub.ADD;
5698: x_return_status := fnd_api.g_ret_sts_unexp_error;
5699:
5692: p_column_name => 'INCIDENT_DISTANCE_QUAL_UOM');
5693:
5694: WHEN OTHERS THEN
5695: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5696: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5697: fnd_msg_pub.ADD;
5698: x_return_status := fnd_api.g_ret_sts_unexp_error;
5699:
5700:
5758: p_table_name => G_TABLE_NAME,
5759: p_column_name => 'INCIDENT_DIRECTION_QUALIFIER' );
5760:
5761: WHEN OTHERS THEN
5762: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5763: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5764: fnd_msg_pub.ADD;
5765: x_return_status := fnd_api.g_ret_sts_unexp_error;
5766:
5759: p_column_name => 'INCIDENT_DIRECTION_QUALIFIER' );
5760:
5761: WHEN OTHERS THEN
5762: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5763: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
5764: fnd_msg_pub.ADD;
5765: x_return_status := fnd_api.g_ret_sts_unexp_error;
5766:
5767:
5800: ELSE
5801: l_associated_col1 := p_token_dfm ;
5802: END IF ;
5803:
5804: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5805: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5806: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5807: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5808:
5801: l_associated_col1 := p_token_dfm ;
5802: END IF ;
5803:
5804: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5805: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5806: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5807: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5808:
5809: END IF;
5802: END IF ;
5803:
5804: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_DESC_FLEX_ERROR');
5805: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5806: FND_MESSAGE.Set_Token('DESC_FLEX_MSG', p_token_dfm);
5807: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5808:
5809: END IF;
5810: END Add_Desc_Flex_Msg;
5858: l_token_v := NULL;
5859: end if;
5860: -- end for bug 2833245
5861:
5862: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5863: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5864: --bug 2833245 pass the local variable for setting the token
5865: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5866: -- end for bug 2833245
5859: end if;
5860: -- end for bug 2833245
5861:
5862: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5863: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5864: --bug 2833245 pass the local variable for setting the token
5865: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5866: -- end for bug 2833245
5867: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5861:
5862: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
5863: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5864: --bug 2833245 pass the local variable for setting the token
5865: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5866: -- end for bug 2833245
5867: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5868: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5869:
5863: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5864: --bug 2833245 pass the local variable for setting the token
5865: FND_MESSAGE.Set_Token('VALUE',l_token_v);
5866: -- end for bug 2833245
5867: FND_MESSAGE.Set_Token('PARAMETER', p_token_p);
5868: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5869:
5870: --For bug 2885111 - to remove the blank message
5871: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5906: l_associated_col1 := p_column_name;
5907: ELSE
5908: l_associated_col1 := p_token_kfm ;
5909: END IF ;
5910: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5911: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5912: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5913: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5914: END IF;
5907: ELSE
5908: l_associated_col1 := p_token_kfm ;
5909: END IF ;
5910: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5911: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5912: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5913: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5914: END IF;
5915: END Add_Key_Flex_Msg;
5908: l_associated_col1 := p_token_kfm ;
5909: END IF ;
5910: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_KEY_FLEX_ERROR');
5911: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5912: FND_MESSAGE.Set_Token('KEY_FLEX_MSG', p_token_kfm);
5913: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5914: END IF;
5915: END Add_Key_Flex_Msg;
5916:
5948: l_associated_col1 := p_column_name;
5949: ELSE
5950: l_associated_col1 := p_token_mp ;
5951: END IF ;
5952: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5953: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5954: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5955: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5956: END IF;
5949: ELSE
5950: l_associated_col1 := p_token_mp ;
5951: END IF ;
5952: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5953: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5954: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5955: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5956: END IF;
5957: END Add_Missing_Param_Msg;
5950: l_associated_col1 := p_token_mp ;
5951: END IF ;
5952: FND_MESSAGE.SET_NAME('CS', 'CS_API_ALL_MISSING_PARAM');
5953: FND_MESSAGE.SET_TOKEN('API_NAME', p_token_an);
5954: FND_MESSAGE.SET_TOKEN('MISSING_PARAM', p_token_mp);
5955: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
5956: END IF;
5957: END Add_Missing_Param_Msg;
5958:
5992: l_associated_col1 := p_column_name;
5993: ELSE
5994: l_associated_col1 := p_token_np ;
5995: END IF ;
5996: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5997: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5998: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5999: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6000: END IF;
5993: ELSE
5994: l_associated_col1 := p_token_np ;
5995: END IF ;
5996: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5997: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5998: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5999: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6000: END IF;
6001: END Add_Null_Parameter_Msg;
5994: l_associated_col1 := p_token_np ;
5995: END IF ;
5996: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_NULL_PARAMETER');
5997: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
5998: FND_MESSAGE.Set_Token('NULL_PARAM', p_token_np);
5999: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6000: END IF;
6001: END Add_Null_Parameter_Msg;
6002:
6036: l_associated_col1 := p_column_name;
6037: ELSE
6038: l_associated_col1 := p_token_ip ;
6039: END IF ;
6040: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
6041: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6042: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
6043: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6044: END IF;
6037: ELSE
6038: l_associated_col1 := p_token_ip ;
6039: END IF ;
6040: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
6041: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6042: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
6043: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6044: END IF;
6045: END Add_Param_Ignored_Msg;
6038: l_associated_col1 := p_token_ip ;
6039: END IF ;
6040: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_PARAM_IGNORED');
6041: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6042: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ip);
6043: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6044: END IF;
6045: END Add_Param_Ignored_Msg;
6046:
6079: l_associated_col1 := p_column_name;
6080: ELSE
6081: l_associated_col1 := p_token_p ;
6082: END IF ;
6083: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
6084: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6085: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
6086: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6087: END IF;
6080: ELSE
6081: l_associated_col1 := p_token_p ;
6082: END IF ;
6083: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
6084: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6085: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
6086: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6087: END IF;
6088: END Add_Duplicate_Value_Msg;
6081: l_associated_col1 := p_token_p ;
6082: END IF ;
6083: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_DUPLICATE_VALUE');
6084: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6085: FND_MESSAGE.Set_Token('DUPLICATE_VAL_PARAM', p_token_p);
6086: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
6087: END IF;
6088: END Add_Duplicate_Value_Msg;
6089:
6121: l_associated_col1 := p_column_name;
6122: ELSE
6123: l_associated_col1 := p_token_p ;
6124: END IF ;
6125: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
6126: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6127: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
6128: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1,
6129: p_message_type => FND_MSG_PUB.G_WARNING_MSG);
6122: ELSE
6123: l_associated_col1 := p_token_p ;
6124: END IF ;
6125: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
6126: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6127: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
6128: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1,
6129: p_message_type => FND_MSG_PUB.G_WARNING_MSG);
6130: END IF;
6123: l_associated_col1 := p_token_p ;
6124: END IF ;
6125: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_SAME_VAL_UPDATE');
6126: FND_MESSAGE.Set_Token('API_NAME', p_token_an);
6127: FND_MESSAGE.Set_Token('SAME_VAL_PARAM', p_token_p);
6128: FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1,
6129: p_message_type => FND_MSG_PUB.G_WARNING_MSG);
6130: END IF;
6131: END Add_Same_Val_Update_Msg;
6195: p_token_v => 'site_id:='||to_char(p_site_id)||' or site_use_id:='||to_char(p_site_use_id),
6196: p_token_p => p_parameter_name );
6197:
6198: WHEN OTHERS THEN
6199: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6200: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6201: fnd_msg_pub.add;
6202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6203: END Validate_Site_Site_Use ;
6196: p_token_p => p_parameter_name );
6197:
6198: WHEN OTHERS THEN
6199: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6200: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6201: fnd_msg_pub.add;
6202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6203: END Validate_Site_Site_Use ;
6204:
6259: p_token_v => to_char(p_site_use_id),
6260: p_token_p => p_parameter_name );
6261:
6262: WHEN OTHERS THEN
6263: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6264: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6265: fnd_msg_pub.add;
6266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6267: END Validate_Bill_Ship_Site_Use;
6260: p_token_p => p_parameter_name );
6261:
6262: WHEN OTHERS THEN
6263: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6264: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6265: fnd_msg_pub.add;
6266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6267: END Validate_Bill_Ship_Site_Use;
6268:
6311: -- There are open tasks associated to the service request. Changing the
6312: -- service request type may invalidate some of the task assignments.
6313: -- Please verify that the task owners are valid for the new service
6314: -- request type.
6315: fnd_message.set_name ('CS', 'CS_SR_TASK_OWNER_INVALID');
6316: fnd_msg_pub.ADD;
6317: end if;
6318: end if;
6319:
6319:
6320: EXCEPTION
6321: WHEN OTHERS THEN
6322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6323: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6324: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6325: fnd_msg_pub.add;
6326:
6327: END TASK_OWNER_CROSS_VAL;
6320: EXCEPTION
6321: WHEN OTHERS THEN
6322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6323: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6324: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6325: fnd_msg_pub.add;
6326:
6327: END TASK_OWNER_CROSS_VAL;
6328:
6352:
6353: EXCEPTION
6354: WHEN NO_DATA_FOUND THEN
6355: x_return_status := FND_API.G_RET_STS_ERROR;
6356: fnd_message.set_name ('CS', 'CS_INVALID_INC_LOCATION');
6357: fnd_message.set_token('INCIDENT_LOCATION_ID', p_incident_location_id);
6358: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6359: fnd_msg_pub.add;
6360:
6353: EXCEPTION
6354: WHEN NO_DATA_FOUND THEN
6355: x_return_status := FND_API.G_RET_STS_ERROR;
6356: fnd_message.set_name ('CS', 'CS_INVALID_INC_LOCATION');
6357: fnd_message.set_token('INCIDENT_LOCATION_ID', p_incident_location_id);
6358: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6359: fnd_msg_pub.add;
6360:
6361: WHEN OTHERS THEN
6354: WHEN NO_DATA_FOUND THEN
6355: x_return_status := FND_API.G_RET_STS_ERROR;
6356: fnd_message.set_name ('CS', 'CS_INVALID_INC_LOCATION');
6357: fnd_message.set_token('INCIDENT_LOCATION_ID', p_incident_location_id);
6358: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6359: fnd_msg_pub.add;
6360:
6361: WHEN OTHERS THEN
6362: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6358: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6359: fnd_msg_pub.add;
6360:
6361: WHEN OTHERS THEN
6362: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6363: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6364: fnd_msg_pub.add;
6365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6366:
6359: fnd_msg_pub.add;
6360:
6361: WHEN OTHERS THEN
6362: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6363: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6364: fnd_msg_pub.add;
6365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6366:
6367: END CP_INCIDENT_SITE_CROSS_VAL;
6397: -- then validate that
6398: IF l_install_site_type='HZ_PARTY_SITES' THEN
6399: IF l_install_site_id <> p_install_site_id THEN
6400: x_return_status := FND_API.G_RET_STS_ERROR;
6401: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6402: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
6403: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6404: fnd_msg_pub.add;
6405: END IF;
6398: IF l_install_site_type='HZ_PARTY_SITES' THEN
6399: IF l_install_site_id <> p_install_site_id THEN
6400: x_return_status := FND_API.G_RET_STS_ERROR;
6401: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6402: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
6403: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6404: fnd_msg_pub.add;
6405: END IF;
6406: END IF;
6399: IF l_install_site_id <> p_install_site_id THEN
6400: x_return_status := FND_API.G_RET_STS_ERROR;
6401: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6402: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
6403: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6404: fnd_msg_pub.add;
6405: END IF;
6406: END IF;
6407:
6407:
6408: EXCEPTION
6409: WHEN NO_DATA_FOUND THEN
6410: x_return_status := FND_API.G_RET_STS_ERROR;
6411: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6412: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
6413: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6414: fnd_msg_pub.add;
6415:
6408: EXCEPTION
6409: WHEN NO_DATA_FOUND THEN
6410: x_return_status := FND_API.G_RET_STS_ERROR;
6411: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6412: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
6413: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6414: fnd_msg_pub.add;
6415:
6416: WHEN OTHERS THEN
6409: WHEN NO_DATA_FOUND THEN
6410: x_return_status := FND_API.G_RET_STS_ERROR;
6411: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6412: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
6413: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6414: fnd_msg_pub.add;
6415:
6416: WHEN OTHERS THEN
6417: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6413: fnd_message.set_token('CUSTOMER_PRODUCT_ID', p_customer_product_id);
6414: fnd_msg_pub.add;
6415:
6416: WHEN OTHERS THEN
6417: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6418: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6419: fnd_msg_pub.add;
6420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6421:
6414: fnd_msg_pub.add;
6415:
6416: WHEN OTHERS THEN
6417: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6418: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6419: fnd_msg_pub.add;
6420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6421:
6422: END CP_INSTALL_SITE_CROSS_VAL;
6471: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) then
6472: -- new message for 11.5.10
6473: -- Resolution code is not valid. Please check the values for the following:
6474: -- Service request type, inventory item, product category and problem code.
6475: fnd_message.set_name ('CS', 'CS_SR_RES_CODE_INVALID');
6476: fnd_message.set_token('API_NAME', l_api_name_full );
6477: fnd_msg_pub.add;
6478: end if;
6479:
6472: -- new message for 11.5.10
6473: -- Resolution code is not valid. Please check the values for the following:
6474: -- Service request type, inventory item, product category and problem code.
6475: fnd_message.set_name ('CS', 'CS_SR_RES_CODE_INVALID');
6476: fnd_message.set_token('API_NAME', l_api_name_full );
6477: fnd_msg_pub.add;
6478: end if;
6479:
6480: EXCEPTION
6478: end if;
6479:
6480: EXCEPTION
6481: WHEN OTHERS THEN
6482: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6483: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6484: fnd_msg_pub.add;
6485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6486:
6479:
6480: EXCEPTION
6481: WHEN OTHERS THEN
6482: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6483: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6484: fnd_msg_pub.add;
6485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6486:
6487: END Resolution_Code_Cross_Val;
6524: if ( l_dummy > 0 ) then
6525: x_return_status := FND_API.G_RET_STS_ERROR;
6526: -- This service request has open dependent tasks. Please close these
6527: -- tasks before closing the service request.
6528: fnd_message.set_name ('CS', 'CS_SR_CANNOT_CLOSE_SR');
6529: fnd_msg_pub.add;
6530: end if;
6531:
6532: END IF;
6532: END IF;
6533:
6534: EXCEPTION
6535: WHEN OTHERS THEN
6536: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6537: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6538: fnd_msg_pub.add;
6539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6540:
6533:
6534: EXCEPTION
6535: WHEN OTHERS THEN
6536: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6537: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6538: fnd_msg_pub.add;
6539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6540:
6541: END TASK_RESTRICT_CLOSE_CROSS_VAL;
6697: -- new message for 11.5.10
6698: -- Contract is not valid. Please check the values for the following:
6699: -- Service request type, inventory item, instance, account and
6700: -- install site.
6701: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6702: --fnd_message.set_token('API_NAME', l_api_name_full );
6703: --fnd_msg_pub.add;
6704: END IF;
6705: ELSE -- For BUG 3665768
6698: -- Contract is not valid. Please check the values for the following:
6699: -- Service request type, inventory item, instance, account and
6700: -- install site.
6701: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6702: --fnd_message.set_token('API_NAME', l_api_name_full );
6703: --fnd_msg_pub.add;
6704: END IF;
6705: ELSE -- For BUG 3665768
6706: x_return_status := FND_API.G_RET_STS_ERROR;
6703: --fnd_msg_pub.add;
6704: END IF;
6705: ELSE -- For BUG 3665768
6706: x_return_status := FND_API.G_RET_STS_ERROR;
6707: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6708: --fnd_message.set_token('API_NAME', l_api_name_full );
6709: --fnd_msg_pub.add;
6710: END IF; -- IF ( lx_return_status = FND_API.G_RET_STS_SUCCESS ) then
6711: *************** when bug 4109990 is fixed, uncomment this part *********/
6704: END IF;
6705: ELSE -- For BUG 3665768
6706: x_return_status := FND_API.G_RET_STS_ERROR;
6707: --fnd_message.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
6708: --fnd_message.set_token('API_NAME', l_api_name_full );
6709: --fnd_msg_pub.add;
6710: END IF; -- IF ( lx_return_status = FND_API.G_RET_STS_SUCCESS ) then
6711: *************** when bug 4109990 is fixed, uncomment this part *********/
6712:
6711: *************** when bug 4109990 is fixed, uncomment this part *********/
6712:
6713: EXCEPTION
6714: WHEN OTHERS THEN
6715: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6716: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6717: fnd_msg_pub.add;
6718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6719:
6712:
6713: EXCEPTION
6714: WHEN OTHERS THEN
6715: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6716: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6717: fnd_msg_pub.add;
6718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6719:
6720: END CONTRACTS_CROSS_VAL;
6753: p_token_v => to_char(p_inv_component_id),
6754: p_token_p => p_parameter_name );
6755:
6756: WHEN OTHERS THEN
6757: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6758: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6759: fnd_msg_pub.add;
6760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6761:
6754: p_token_p => p_parameter_name );
6755:
6756: WHEN OTHERS THEN
6757: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6758: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6759: fnd_msg_pub.add;
6760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6761:
6762: END INV_COMPONENT_CROSS_VAL;
6794: p_token_v => to_char(p_cp_subcomponent_id),
6795: p_token_p => p_parameter_name );
6796:
6797: WHEN OTHERS THEN
6798: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6799: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6800: fnd_msg_pub.add;
6801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6802:
6795: p_token_p => p_parameter_name );
6796:
6797: WHEN OTHERS THEN
6798: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6799: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6800: fnd_msg_pub.add;
6801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6802:
6803: END INV_SUBCOMPONENT_CROSS_VAL;
6898: if ( p_old_eam_type_flag = 'Y' ) then
6899: -- new message for 11.5.10
6900: -- The system could not update the Type. The Type cannot be changed from a
6901: -- Maintenance Type to a non-Maintenance Type.
6902: fnd_message.set_name ('CS', 'CS_SR_DISALLOW_TYPE_UPD_1');
6903: fnd_message.set_token('API_NAME', l_api_name_full );
6904: fnd_msg_pub.add;
6905: else
6906: -- new message for 11.5.10
6899: -- new message for 11.5.10
6900: -- The system could not update the Type. The Type cannot be changed from a
6901: -- Maintenance Type to a non-Maintenance Type.
6902: fnd_message.set_name ('CS', 'CS_SR_DISALLOW_TYPE_UPD_1');
6903: fnd_message.set_token('API_NAME', l_api_name_full );
6904: fnd_msg_pub.add;
6905: else
6906: -- new message for 11.5.10
6907: -- The system could not update the Type. The Type cannot be changed from a
6905: else
6906: -- new message for 11.5.10
6907: -- The system could not update the Type. The Type cannot be changed from a
6908: -- non-Maintenance Type to a Maintenance Type.
6909: fnd_message.set_name ('CS', 'CS_SR_DISALLOW_TYPE_UPD_2');
6910: fnd_message.set_token('API_NAME', l_api_name_full );
6911: fnd_msg_pub.add;
6912: end if;
6913: else
6906: -- new message for 11.5.10
6907: -- The system could not update the Type. The Type cannot be changed from a
6908: -- non-Maintenance Type to a Maintenance Type.
6909: fnd_message.set_name ('CS', 'CS_SR_DISALLOW_TYPE_UPD_2');
6910: fnd_message.set_token('API_NAME', l_api_name_full );
6911: fnd_msg_pub.add;
6912: end if;
6913: else
6914: x_return_status := FND_API.G_RET_STS_SUCCESS;
6917: EXCEPTION
6918: WHEN OTHERS THEN
6919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6920:
6921: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6922: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6923: FND_MSG_PUB.ADD;
6924:
6925: END VALIDATE_TYPE_CHANGE;
6918: WHEN OTHERS THEN
6919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6920:
6921: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6922: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
6923: FND_MSG_PUB.ADD;
6924:
6925: END VALIDATE_TYPE_CHANGE;
6926:
7474: when no_data_found then
7475: raise fnd_api.g_exc_unexpected_error;
7476: -- Invalid type. Given type is either end dated or does not exist
7477: -- as a valid type.
7478: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
7479: fnd_message.set_token('API_NAME', l_api_name_full);
7480: fnd_msg_pub.ADD;
7481: lx_return_status := FND_API.G_RET_STS_ERROR;
7482: end;
7475: raise fnd_api.g_exc_unexpected_error;
7476: -- Invalid type. Given type is either end dated or does not exist
7477: -- as a valid type.
7478: fnd_message.set_name ('CS', 'CS_SR_INVALID_TYPE');
7479: fnd_message.set_token('API_NAME', l_api_name_full);
7480: fnd_msg_pub.ADD;
7481: lx_return_status := FND_API.G_RET_STS_ERROR;
7482: end;
7483:
7748:
7749: IF ((l_bto_site_id <> FND_API.G_MISS_NUM AND l_bto_site_id IS NOT NULL))
7750: THEN
7751: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
7752: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7753: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
7754: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7755: fnd_msg_pub.ADD;
7756: x_return_status := FND_API.G_RET_STS_ERROR;
7749: IF ((l_bto_site_id <> FND_API.G_MISS_NUM AND l_bto_site_id IS NOT NULL))
7750: THEN
7751: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
7752: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7753: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
7754: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7755: fnd_msg_pub.ADD;
7756: x_return_status := FND_API.G_RET_STS_ERROR;
7757: RETURN;
7750: THEN
7751: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
7752: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7753: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
7754: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7755: fnd_msg_pub.ADD;
7756: x_return_status := FND_API.G_RET_STS_ERROR;
7757: RETURN;
7758: END IF;
7787:
7788: IF ((l_sto_site_id <> FND_API.G_MISS_NUM AND l_sto_site_id IS NOT NULL))
7789: THEN
7790: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
7791: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7792: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
7793: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7794: fnd_msg_pub.ADD;
7795: x_return_status := FND_API.G_RET_STS_ERROR;
7788: IF ((l_sto_site_id <> FND_API.G_MISS_NUM AND l_sto_site_id IS NOT NULL))
7789: THEN
7790: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
7791: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7792: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
7793: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7794: fnd_msg_pub.ADD;
7795: x_return_status := FND_API.G_RET_STS_ERROR;
7796: RETURN;
7789: THEN
7790: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
7791: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7792: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
7793: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7794: fnd_msg_pub.ADD;
7795: x_return_status := FND_API.G_RET_STS_ERROR;
7796: RETURN;
7797: END IF;
7826: ---- Validate Bill to contact id
7827: IF ((l_bto_cont_id <> FND_API.G_MISS_NUM AND l_bto_cont_id IS NOT NULL)) THEN
7828: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
7829:
7830: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7831: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
7832: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7833: fnd_msg_pub.ADD;
7834:
7827: IF ((l_bto_cont_id <> FND_API.G_MISS_NUM AND l_bto_cont_id IS NOT NULL)) THEN
7828: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
7829:
7830: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7831: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
7832: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7833: fnd_msg_pub.ADD;
7834:
7835: x_return_status := FND_API.G_RET_STS_ERROR;
7828: IF (l_bto_party_id = FND_API.G_MISS_NUM OR l_bto_party_id IS NULL) THEN
7829:
7830: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7831: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
7832: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
7833: fnd_msg_pub.ADD;
7834:
7835: x_return_status := FND_API.G_RET_STS_ERROR;
7836: RETURN;
7864: ---- Validate ship to contact id
7865: IF ((l_sto_cont_id <> FND_API.G_MISS_NUM AND l_sto_cont_id IS NOT NULL)) THEN
7866: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
7867:
7868: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7869: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
7870: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7871: fnd_msg_pub.ADD;
7872:
7865: IF ((l_sto_cont_id <> FND_API.G_MISS_NUM AND l_sto_cont_id IS NOT NULL)) THEN
7866: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
7867:
7868: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7869: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
7870: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7871: fnd_msg_pub.ADD;
7872:
7873: x_return_status := FND_API.G_RET_STS_ERROR;
7866: IF (l_sto_party_id = FND_API.G_MISS_NUM OR l_sto_party_id IS NULL) THEN
7867:
7868: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
7869: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
7870: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
7871: fnd_msg_pub.ADD;
7872:
7873: x_return_status := FND_API.G_RET_STS_ERROR;
7874: RETURN;
8460: l_sto_site_use IS NOT NULL))
8461: THEN
8462: IF (l_sto_party_id = FND_API.G_MISS_NUM OR
8463: l_sto_party_id IS NULL) THEN
8464: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8465: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
8466: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
8467: fnd_msg_pub.ADD;
8468: x_return_status := FND_API.G_RET_STS_ERROR;
8461: THEN
8462: IF (l_sto_party_id = FND_API.G_MISS_NUM OR
8463: l_sto_party_id IS NULL) THEN
8464: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8465: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
8466: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
8467: fnd_msg_pub.ADD;
8468: x_return_status := FND_API.G_RET_STS_ERROR;
8469: RETURN;
8462: IF (l_sto_party_id = FND_API.G_MISS_NUM OR
8463: l_sto_party_id IS NULL) THEN
8464: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8465: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
8466: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
8467: fnd_msg_pub.ADD;
8468: x_return_status := FND_API.G_RET_STS_ERROR;
8469: RETURN;
8470: END IF;
8627: l_bto_site_use IS NOT NULL))
8628: THEN
8629: IF (l_bto_party_id = FND_API.G_MISS_NUM OR
8630: l_bto_party_id IS NULL) THEN
8631: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8632: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
8633: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
8634: fnd_msg_pub.ADD;
8635: x_return_status := FND_API.G_RET_STS_ERROR;
8628: THEN
8629: IF (l_bto_party_id = FND_API.G_MISS_NUM OR
8630: l_bto_party_id IS NULL) THEN
8631: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8632: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
8633: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
8634: fnd_msg_pub.ADD;
8635: x_return_status := FND_API.G_RET_STS_ERROR;
8636: RETURN;
8629: IF (l_bto_party_id = FND_API.G_MISS_NUM OR
8630: l_bto_party_id IS NULL) THEN
8631: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
8632: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
8633: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
8634: fnd_msg_pub.ADD;
8635: x_return_status := FND_API.G_RET_STS_ERROR;
8636: RETURN;
8637: END IF;
8726: EXCEPTION
8727: WHEN OTHERS THEN
8728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8729:
8730: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
8731: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
8732: FND_MSG_PUB.ADD;
8733:
8734: END SERVICEREQUEST_CROSS_VAL;
8727: WHEN OTHERS THEN
8728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8729:
8730: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
8731: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
8732: FND_MSG_PUB.ADD;
8733:
8734: END SERVICEREQUEST_CROSS_VAL;
8735:
9338:
9339: IF c_party_role % NOTFOUND
9340: THEN
9341: x_return_status := FND_API.G_RET_STS_ERROR;
9342: FND_MESSAGE.set_name('CS','CS_SR_PARTY_ROLE_NE');
9343: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9344: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9345: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9346: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
9339: IF c_party_role % NOTFOUND
9340: THEN
9341: x_return_status := FND_API.G_RET_STS_ERROR;
9342: FND_MESSAGE.set_name('CS','CS_SR_PARTY_ROLE_NE');
9343: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9344: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9345: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9346: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
9347: ELSIF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9340: THEN
9341: x_return_status := FND_API.G_RET_STS_ERROR;
9342: FND_MESSAGE.set_name('CS','CS_SR_PARTY_ROLE_NE');
9343: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9344: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9345: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9346: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
9347: ELSIF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9348: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9347: ELSIF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9348: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9349: THEN
9350: x_return_status := FND_API.G_RET_STS_ERROR;
9351: FND_MESSAGE.set_name('CS','CS_SR_PARTYROLE_INACTIVE');
9352: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9353: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9354: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9355: END IF;
9348: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9349: THEN
9350: x_return_status := FND_API.G_RET_STS_ERROR;
9351: FND_MESSAGE.set_name('CS','CS_SR_PARTYROLE_INACTIVE');
9352: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9353: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9354: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9355: END IF;
9356: CLOSE c_party_role;
9349: THEN
9350: x_return_status := FND_API.G_RET_STS_ERROR;
9351: FND_MESSAGE.set_name('CS','CS_SR_PARTYROLE_INACTIVE');
9352: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9353: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9354: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9355: END IF;
9356: CLOSE c_party_role;
9357: END IF;
9361: IF c_party_role%ISOPEN
9362: THEN
9363: CLOSE c_party_role;
9364: END IF;
9365: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9366: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.validate_party_role_code'||'-'||SQLERRM);
9367: FND_MSG_PUB.ADD;
9368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9369: END validate_party_role_code;
9362: THEN
9363: CLOSE c_party_role;
9364: END IF;
9365: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9366: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.validate_party_role_code'||'-'||SQLERRM);
9367: FND_MSG_PUB.ADD;
9368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9369: END validate_party_role_code;
9370: -- -----------------------------------------------------------------------------
9406: WHERE organization_id = p_org_id;
9407: IF l_sys_dt < NVL(l_dt_from, l_sys_dt) OR
9408: l_sys_dt > NVL(l_dt_to , l_sys_dt)
9409: THEN
9410: FND_MESSAGE.set_name ('CS', 'CS_SR_ORG_ID_INACTIVE');
9411: FND_MESSAGE.set_token ('API_NAME', 'CS_SERVICEREQUEST_UTIL.validate_org_id');
9412: FND_MESSAGE.set_token ('ORG_ID', p_org_id);
9413: FND_MSG_PUB.ADD;
9414: x_return_status := FND_API.G_RET_STS_ERROR;
9407: IF l_sys_dt < NVL(l_dt_from, l_sys_dt) OR
9408: l_sys_dt > NVL(l_dt_to , l_sys_dt)
9409: THEN
9410: FND_MESSAGE.set_name ('CS', 'CS_SR_ORG_ID_INACTIVE');
9411: FND_MESSAGE.set_token ('API_NAME', 'CS_SERVICEREQUEST_UTIL.validate_org_id');
9412: FND_MESSAGE.set_token ('ORG_ID', p_org_id);
9413: FND_MSG_PUB.ADD;
9414: x_return_status := FND_API.G_RET_STS_ERROR;
9415: END IF;
9408: l_sys_dt > NVL(l_dt_to , l_sys_dt)
9409: THEN
9410: FND_MESSAGE.set_name ('CS', 'CS_SR_ORG_ID_INACTIVE');
9411: FND_MESSAGE.set_token ('API_NAME', 'CS_SERVICEREQUEST_UTIL.validate_org_id');
9412: FND_MESSAGE.set_token ('ORG_ID', p_org_id);
9413: FND_MSG_PUB.ADD;
9414: x_return_status := FND_API.G_RET_STS_ERROR;
9415: END IF;
9416: EXCEPTION
9423: , p_table_name => G_TABLE_NAME
9424: , p_column_name => 'ORG_ID'
9425: );
9426: WHEN OTHERS THEN
9427: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9428: fnd_message.set_token ('P_TEXT','cs_servicerequest_util.validate_org_id'||'-'||SQLERRM);
9429: fnd_msg_pub.ADD;
9430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9431: END validate_org_id;
9424: , p_column_name => 'ORG_ID'
9425: );
9426: WHEN OTHERS THEN
9427: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9428: fnd_message.set_token ('P_TEXT','cs_servicerequest_util.validate_org_id'||'-'||SQLERRM);
9429: fnd_msg_pub.ADD;
9430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9431: END validate_org_id;
9432: -- -----------------------------------------------------------------------------
9485: );
9486: ELSIF NVL(l_maint_org_id,-99) <> p_maint_organization_id
9487: THEN
9488: x_return_status := FND_API.G_RET_STS_ERROR;
9489: FND_MESSAGE.set_name ('CS' , 'CS_SR_INV_ORG_NOT_MAINT_BY');
9490: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9491: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9492: FND_MESSAGE.set_token ('INV_ORG_ID' , TO_CHAR(p_inventory_org_id));
9493: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9486: ELSIF NVL(l_maint_org_id,-99) <> p_maint_organization_id
9487: THEN
9488: x_return_status := FND_API.G_RET_STS_ERROR;
9489: FND_MESSAGE.set_name ('CS' , 'CS_SR_INV_ORG_NOT_MAINT_BY');
9490: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9491: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9492: FND_MESSAGE.set_token ('INV_ORG_ID' , TO_CHAR(p_inventory_org_id));
9493: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9494: END IF;
9487: THEN
9488: x_return_status := FND_API.G_RET_STS_ERROR;
9489: FND_MESSAGE.set_name ('CS' , 'CS_SR_INV_ORG_NOT_MAINT_BY');
9490: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9491: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9492: FND_MESSAGE.set_token ('INV_ORG_ID' , TO_CHAR(p_inventory_org_id));
9493: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9494: END IF;
9495: ELSE -- inv org is a master org or inv org is not passed
9488: x_return_status := FND_API.G_RET_STS_ERROR;
9489: FND_MESSAGE.set_name ('CS' , 'CS_SR_INV_ORG_NOT_MAINT_BY');
9490: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9491: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9492: FND_MESSAGE.set_token ('INV_ORG_ID' , TO_CHAR(p_inventory_org_id));
9493: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9494: END IF;
9495: ELSE -- inv org is a master org or inv org is not passed
9496: get_org_details
9511: );
9512: ELSIF l_eam_enabled <> 'Y'
9513: THEN
9514: x_return_status := FND_API.G_RET_STS_ERROR;
9515: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_ORG_NON_EAM');
9516: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9517: FND_MESSAGE.set_token ('MAINT_ORG_ID', TO_CHAR(p_maint_organization_id));
9518: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9519: ELSIF p_inventory_org_id IS NOT NULL AND
9512: ELSIF l_eam_enabled <> 'Y'
9513: THEN
9514: x_return_status := FND_API.G_RET_STS_ERROR;
9515: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_ORG_NON_EAM');
9516: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9517: FND_MESSAGE.set_token ('MAINT_ORG_ID', TO_CHAR(p_maint_organization_id));
9518: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9519: ELSIF p_inventory_org_id IS NOT NULL AND
9520: p_inventory_org_id <> FND_API.G_MISS_NUM AND
9513: THEN
9514: x_return_status := FND_API.G_RET_STS_ERROR;
9515: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_ORG_NON_EAM');
9516: FND_MESSAGE.set_token ('API_NAME', l_api_name_full);
9517: FND_MESSAGE.set_token ('MAINT_ORG_ID', TO_CHAR(p_maint_organization_id));
9518: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9519: ELSIF p_inventory_org_id IS NOT NULL AND
9520: p_inventory_org_id <> FND_API.G_MISS_NUM AND
9521: p_inventory_org_id <> l_master_org_id
9520: p_inventory_org_id <> FND_API.G_MISS_NUM AND
9521: p_inventory_org_id <> l_master_org_id
9522: THEN
9523: x_return_status := FND_API.G_RET_STS_ERROR;
9524: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_INV_ORG_MISMATCH');
9525: FND_MESSAGE.set_token ('API_NAME' , l_api_name_full);
9526: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9527: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9528: END IF;
9521: p_inventory_org_id <> l_master_org_id
9522: THEN
9523: x_return_status := FND_API.G_RET_STS_ERROR;
9524: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_INV_ORG_MISMATCH');
9525: FND_MESSAGE.set_token ('API_NAME' , l_api_name_full);
9526: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9527: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9528: END IF;
9529: END IF;
9522: THEN
9523: x_return_status := FND_API.G_RET_STS_ERROR;
9524: FND_MESSAGE.set_name ('CS' , 'CS_SR_MAINT_INV_ORG_MISMATCH');
9525: FND_MESSAGE.set_token ('API_NAME' , l_api_name_full);
9526: FND_MESSAGE.set_token ('MAINT_ORG_ID' , TO_CHAR(p_maint_organization_id));
9527: FND_MSG_PUB.add_detail(p_associated_column1 => l_col);
9528: END IF;
9529: END IF;
9530:
9626: --
9627: IF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9628: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9629: THEN
9630: FND_MESSAGE.set_name('CS','CS_SR_CP_INACTIVE');
9631: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9632: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9633: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9634: RAISE FND_API.G_EXC_ERROR;
9627: IF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR
9628: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9629: THEN
9630: FND_MESSAGE.set_name('CS','CS_SR_CP_INACTIVE');
9631: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9632: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9633: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9634: RAISE FND_API.G_EXC_ERROR;
9635: END IF;
9628: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9629: THEN
9630: FND_MESSAGE.set_name('CS','CS_SR_CP_INACTIVE');
9631: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9632: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9633: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9634: RAISE FND_API.G_EXC_ERROR;
9635: END IF;
9636: --
9636: --
9637: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9638: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9639: THEN
9640: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9641: FND_MESSAGE.set_token('LOC',l_loc_type);
9642: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9643: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9644: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9637: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9638: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9639: THEN
9640: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9641: FND_MESSAGE.set_token('LOC',l_loc_type);
9642: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9643: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9644: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9645: RAISE FND_API.G_EXC_ERROR;
9638: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9639: THEN
9640: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9641: FND_MESSAGE.set_token('LOC',l_loc_type);
9642: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9643: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9644: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9645: RAISE FND_API.G_EXC_ERROR;
9646: END IF;
9639: THEN
9640: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9641: FND_MESSAGE.set_token('LOC',l_loc_type);
9642: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9643: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9644: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9645: RAISE FND_API.G_EXC_ERROR;
9646: END IF;
9647: --
9646: END IF;
9647: --
9648: IF NVL(l_source_table,'#') <> 'HZ_PARTIES'
9649: THEN
9650: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_SOURCE_INVALID'); -- product is not for TCA parties
9651: FND_MESSAGE.set_token('PARTY_SOURCE',l_source_table);
9652: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9653: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9654: RAISE FND_API.G_EXC_ERROR;
9647: --
9648: IF NVL(l_source_table,'#') <> 'HZ_PARTIES'
9649: THEN
9650: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_SOURCE_INVALID'); -- product is not for TCA parties
9651: FND_MESSAGE.set_token('PARTY_SOURCE',l_source_table);
9652: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9653: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9654: RAISE FND_API.G_EXC_ERROR;
9655: END IF;
9648: IF NVL(l_source_table,'#') <> 'HZ_PARTIES'
9649: THEN
9650: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_SOURCE_INVALID'); -- product is not for TCA parties
9651: FND_MESSAGE.set_token('PARTY_SOURCE',l_source_table);
9652: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9653: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9654: RAISE FND_API.G_EXC_ERROR;
9655: END IF;
9656: --
9659: OPEN c_prod_rel;
9660: FETCH c_prod_rel into l_dummy;
9661: IF c_prod_rel % NOTFOUND
9662: THEN
9663: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_INVALID'); -- cust not related to product
9664: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9665: FND_MESSAGE.set_token('CUST_ID',TO_CHAR(p_customer_id));
9666: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9667: CLOSE c_prod_rel;
9660: FETCH c_prod_rel into l_dummy;
9661: IF c_prod_rel % NOTFOUND
9662: THEN
9663: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_INVALID'); -- cust not related to product
9664: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9665: FND_MESSAGE.set_token('CUST_ID',TO_CHAR(p_customer_id));
9666: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9667: CLOSE c_prod_rel;
9668: RAISE FND_API.G_EXC_ERROR;
9661: IF c_prod_rel % NOTFOUND
9662: THEN
9663: FND_MESSAGE.set_name('CS','CS_SR_CP_CUST_INVALID'); -- cust not related to product
9664: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9665: FND_MESSAGE.set_token('CUST_ID',TO_CHAR(p_customer_id));
9666: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9667: CLOSE c_prod_rel;
9668: RAISE FND_API.G_EXC_ERROR;
9669: ELSE
9688: , x_return_status => x_return_status
9689: );
9690: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
9691: THEN
9692: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_ID'); -- item associated with CP does not exists
9693: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9694: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9695: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9696: RAISE FND_API.G_EXC_ERROR;
9689: );
9690: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
9691: THEN
9692: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_ID'); -- item associated with CP does not exists
9693: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9694: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9695: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9696: RAISE FND_API.G_EXC_ERROR;
9697: END IF;
9690: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
9691: THEN
9692: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_ID'); -- item associated with CP does not exists
9693: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9694: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9695: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9696: RAISE FND_API.G_EXC_ERROR;
9697: END IF;
9698: IF l_enabled_flag <> 'Y'
9696: RAISE FND_API.G_EXC_ERROR;
9697: END IF;
9698: IF l_enabled_flag <> 'Y'
9699: THEN
9700: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_DISABLED'); -- item associated with CP is not enabled
9701: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9702: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9703: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9704: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9697: END IF;
9698: IF l_enabled_flag <> 'Y'
9699: THEN
9700: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_DISABLED'); -- item associated with CP is not enabled
9701: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9702: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9703: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9704: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9705: RAISE FND_API.G_EXC_ERROR;
9698: IF l_enabled_flag <> 'Y'
9699: THEN
9700: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_DISABLED'); -- item associated with CP is not enabled
9701: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9702: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9703: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9704: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9705: RAISE FND_API.G_EXC_ERROR;
9706: END IF;
9699: THEN
9700: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_DISABLED'); -- item associated with CP is not enabled
9701: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9702: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9703: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9704: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9705: RAISE FND_API.G_EXC_ERROR;
9706: END IF;
9707: IF l_serv_req_enabled <> 'E'
9705: RAISE FND_API.G_EXC_ERROR;
9706: END IF;
9707: IF l_serv_req_enabled <> 'E'
9708: THEN
9709: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_NOT_SERV'); -- item associated with CP is not serviceable
9710: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9711: FND_MESSAGE.set_token('INV',TO_CHAR(l_inv_item_id));
9712: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9713: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9706: END IF;
9707: IF l_serv_req_enabled <> 'E'
9708: THEN
9709: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_NOT_SERV'); -- item associated with CP is not serviceable
9710: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9711: FND_MESSAGE.set_token('INV',TO_CHAR(l_inv_item_id));
9712: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9713: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9714: RAISE FND_API.G_EXC_ERROR;
9707: IF l_serv_req_enabled <> 'E'
9708: THEN
9709: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_NOT_SERV'); -- item associated with CP is not serviceable
9710: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9711: FND_MESSAGE.set_token('INV',TO_CHAR(l_inv_item_id));
9712: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9713: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9714: RAISE FND_API.G_EXC_ERROR;
9715: END IF;
9708: THEN
9709: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_NOT_SERV'); -- item associated with CP is not serviceable
9710: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9711: FND_MESSAGE.set_token('INV',TO_CHAR(l_inv_item_id));
9712: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9713: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9714: RAISE FND_API.G_EXC_ERROR;
9715: END IF;
9716: IF l_sys_dt < NVL(l_start_dt,l_sys_dt) OR
9715: END IF;
9716: IF l_sys_dt < NVL(l_start_dt,l_sys_dt) OR
9717: l_sys_dt > NVL(l_end_dt ,l_sys_dt)
9718: THEN
9719: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_INACTIVE'); --Item associated with CP is inactive
9720: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9721: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9722: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9723: RAISE FND_API.G_EXC_ERROR;
9716: IF l_sys_dt < NVL(l_start_dt,l_sys_dt) OR
9717: l_sys_dt > NVL(l_end_dt ,l_sys_dt)
9718: THEN
9719: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_INACTIVE'); --Item associated with CP is inactive
9720: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9721: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9722: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9723: RAISE FND_API.G_EXC_ERROR;
9724: END IF;
9717: l_sys_dt > NVL(l_end_dt ,l_sys_dt)
9718: THEN
9719: FND_MESSAGE.set_name('CS','CS_SR_CP_ITEM_INACTIVE'); --Item associated with CP is inactive
9720: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9721: FND_MESSAGE.set_token('INV_ITEM_ID',TO_CHAR(l_inv_item_id));
9722: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9723: RAISE FND_API.G_EXC_ERROR;
9724: END IF;
9725: -- All validations succeeded, so assign item for CP to p_inventory_item_id
9736: , x_return_Status => x_return_status
9737: );
9738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
9739: THEN
9740: FND_MESSAGE.set_name('CS','CS_SR_CP_LAST_VLD_ORG'); -- Last validation org does not exists
9741: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9742: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(l_last_vld_org_id));
9743: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9744: RAISE FND_API.G_EXC_ERROR;
9737: );
9738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
9739: THEN
9740: FND_MESSAGE.set_name('CS','CS_SR_CP_LAST_VLD_ORG'); -- Last validation org does not exists
9741: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9742: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(l_last_vld_org_id));
9743: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9744: RAISE FND_API.G_EXC_ERROR;
9745: END IF;
9738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
9739: THEN
9740: FND_MESSAGE.set_name('CS','CS_SR_CP_LAST_VLD_ORG'); -- Last validation org does not exists
9741: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));
9742: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(l_last_vld_org_id));
9743: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9744: RAISE FND_API.G_EXC_ERROR;
9745: END IF;
9746: /* last vlg org may not be eam enabled but it might be maintained bu maint org
9746: /* last vlg org may not be eam enabled but it might be maintained bu maint org
9747: so no need for this check
9748: IF l_eam_enabled_flag <> 'Y'
9749: THEN
9750: FND_MESSAGE.set_name('CS','CS_SR_CP_MAINT_EAM'); -- Maintenance Organization is NOT Eam Enabled
9751: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9752: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9753: RAISE FND_API.G_EXC_ERROR;
9754: END IF;
9747: so no need for this check
9748: IF l_eam_enabled_flag <> 'Y'
9749: THEN
9750: FND_MESSAGE.set_name('CS','CS_SR_CP_MAINT_EAM'); -- Maintenance Organization is NOT Eam Enabled
9751: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9752: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9753: RAISE FND_API.G_EXC_ERROR;
9754: END IF;
9755: */
9754: END IF;
9755: */
9756: IF l_maint_org_id <> p_maint_organization_id
9757: THEN
9758: FND_MESSAGE.set_name('CS','CS_SR_LVD_ORG_NOT_MAINT_BY'); -- CP is not maintained by Maintenance Organization
9759: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9760: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9761: FND_MESSAGE.set_token('VAL_ORG_ID',TO_CHAR(l_maint_org_id));
9762: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9755: */
9756: IF l_maint_org_id <> p_maint_organization_id
9757: THEN
9758: FND_MESSAGE.set_name('CS','CS_SR_LVD_ORG_NOT_MAINT_BY'); -- CP is not maintained by Maintenance Organization
9759: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9760: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9761: FND_MESSAGE.set_token('VAL_ORG_ID',TO_CHAR(l_maint_org_id));
9762: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9763: RAISE FND_API.G_EXC_ERROR;
9756: IF l_maint_org_id <> p_maint_organization_id
9757: THEN
9758: FND_MESSAGE.set_name('CS','CS_SR_LVD_ORG_NOT_MAINT_BY'); -- CP is not maintained by Maintenance Organization
9759: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9760: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9761: FND_MESSAGE.set_token('VAL_ORG_ID',TO_CHAR(l_maint_org_id));
9762: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9763: RAISE FND_API.G_EXC_ERROR;
9764: END IF;
9757: THEN
9758: FND_MESSAGE.set_name('CS','CS_SR_LVD_ORG_NOT_MAINT_BY'); -- CP is not maintained by Maintenance Organization
9759: FND_MESSAGE.set_token('API_NAME' , l_proc_name);
9760: FND_MESSAGE.set_token('MAINT_ORG_ID',TO_CHAR(p_maint_organization_id));
9761: FND_MESSAGE.set_token('VAL_ORG_ID',TO_CHAR(l_maint_org_id));
9762: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9763: RAISE FND_API.G_EXC_ERROR;
9764: END IF;
9765: IF p_inv_org_master_org_flag = 'Y' AND
9764: END IF;
9765: IF p_inv_org_master_org_flag = 'Y' AND
9766: l_master_org_id <> p_inventory_org_id
9767: THEN
9768: FND_MESSAGE.set_name('CS','CS_SR_VLD_INV_ORG_MISMATCH');
9769: FND_MESSAGE.set_token('VAL_ORG',TO_CHAR(l_maint_org_id));
9770: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9771: RAISE FND_API.G_EXC_ERROR;
9772: END IF;
9765: IF p_inv_org_master_org_flag = 'Y' AND
9766: l_master_org_id <> p_inventory_org_id
9767: THEN
9768: FND_MESSAGE.set_name('CS','CS_SR_VLD_INV_ORG_MISMATCH');
9769: FND_MESSAGE.set_token('VAL_ORG',TO_CHAR(l_maint_org_id));
9770: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9771: RAISE FND_API.G_EXC_ERROR;
9772: END IF;
9773: END IF; -- p_maint_organization check
9910: --END IF;
9911: -- commented for bug 8507917
9912: EXCEPTION
9913: WHEN OTHERS THEN
9914: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9915: FND_MESSAGE.set_token
9916: ( 'P_TEXT'
9917: , 'CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM
9918: );
9911: -- commented for bug 8507917
9912: EXCEPTION
9913: WHEN OTHERS THEN
9914: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9915: FND_MESSAGE.set_token
9916: ( 'P_TEXT'
9917: , 'CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM
9918: );
9919: FND_MSG_PUB.ADD;
9961: WHEN NO_DATA_FOUND THEN
9962: x_return_status := FND_API.G_RET_STS_ERROR;
9963:
9964: WHEN OTHERS THEN
9965: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9966: fnd_message.set_token
9967: ( 'P_TEXT'
9968: , 'CS_SERVICEREQUEST_UTIL.get_party_detail:'||'-'||SQLERRM
9969: );
9962: x_return_status := FND_API.G_RET_STS_ERROR;
9963:
9964: WHEN OTHERS THEN
9965: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9966: fnd_message.set_token
9967: ( 'P_TEXT'
9968: , 'CS_SERVICEREQUEST_UTIL.get_party_detail:'||'-'||SQLERRM
9969: );
9970: fnd_msg_pub.ADD;
10058: IF task_rec.fs_task = 'Y'
10059: THEN
10060: IF p_location_id IS NULL
10061: THEN
10062: FND_MESSAGE.set_name ('CS', 'CS_SR_OPEN_FS_TASKS');
10063: FND_MESSAGE.set_token
10064: ( 'API_NAME'
10065: , 'CS_SERVICEREQUEST_UTIL.update_task_address'
10066: );
10059: THEN
10060: IF p_location_id IS NULL
10061: THEN
10062: FND_MESSAGE.set_name ('CS', 'CS_SR_OPEN_FS_TASKS');
10063: FND_MESSAGE.set_token
10064: ( 'API_NAME'
10065: , 'CS_SERVICEREQUEST_UTIL.update_task_address'
10066: );
10067: FND_MSG_PUB.ADD_DETAIL
10271: END IF;
10272:
10273: EXCEPTION
10274: WHEN loc_update_not_alwd_exp THEN
10275: FND_MESSAGE.SET_Name('CS','CS_SR_LOC_UPD_NOT_ALLWD');
10276: FND_MSG_PUB.ADD;
10277: x_return_status := FND_API.G_RET_STS_ERROR;
10278: WHEN FND_API.G_EXC_ERROR THEN
10279: x_return_status := FND_API.G_RET_STS_ERROR;
10422: p_table_name => G_TABLE_NAME,
10423: p_column_name => 'PLATFORM_VERSION_ID' );
10424:
10425: WHEN OTHERS THEN
10426: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10427: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10428: fnd_msg_pub.ADD;
10429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10430:
10423: p_column_name => 'PLATFORM_VERSION_ID' );
10424:
10425: WHEN OTHERS THEN
10426: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10427: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10428: fnd_msg_pub.ADD;
10429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10430:
10431: END Validate_Platform_Version_Id;
10492: p_column_name => 'INSTRUMENT_PAYEMENT_USE_ID' );
10493: x_return_status := FND_API.G_RET_STS_ERROR;
10494: WHEN OTHERS THEN
10495: if p_called_from ='I' THEN
10496: FND_MESSAGE.Set_Name('CS', 'CS_Create_CREDIT_CARD_ERROR');
10497: else
10498: FND_MESSAGE.Set_Name('CS', 'CS_Create_UPDATE_CARD_ERROR');
10499: End if;
10500: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10494: WHEN OTHERS THEN
10495: if p_called_from ='I' THEN
10496: FND_MESSAGE.Set_Name('CS', 'CS_Create_CREDIT_CARD_ERROR');
10497: else
10498: FND_MESSAGE.Set_Name('CS', 'CS_Create_UPDATE_CARD_ERROR');
10499: End if;
10500: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10501: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10502: fnd_msg_pub.ADD;
10496: FND_MESSAGE.Set_Name('CS', 'CS_Create_CREDIT_CARD_ERROR');
10497: else
10498: FND_MESSAGE.Set_Name('CS', 'CS_Create_UPDATE_CARD_ERROR');
10499: End if;
10500: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10501: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10502: fnd_msg_pub.ADD;
10503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10504: END VALIDATE_CREDIT_CARD;
10497: else
10498: FND_MESSAGE.Set_Name('CS', 'CS_Create_UPDATE_CARD_ERROR');
10499: End if;
10500: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10501: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10502: fnd_msg_pub.ADD;
10503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10504: END VALIDATE_CREDIT_CARD;
10505:
10528: --validate if the project_id or project_task_id passed is a valid one
10529: --if project_task_id is passed without project_id then fail the validation
10530: IF (p_project_id IS NULL AND p_project_task_id IS NOT NULL) THEN
10531: x_return_status := FND_API.G_RET_STS_ERROR;
10532: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_PROJ_NUM');
10533: fnd_message.set_token ('P_TEXT',l_api_name_full||'- Project_id null');
10534: fnd_msg_pub.ADD;
10535: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NULL) THEN
10536: x_return_status := FND_API.G_RET_STS_ERROR;
10529: --if project_task_id is passed without project_id then fail the validation
10530: IF (p_project_id IS NULL AND p_project_task_id IS NOT NULL) THEN
10531: x_return_status := FND_API.G_RET_STS_ERROR;
10532: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_PROJ_NUM');
10533: fnd_message.set_token ('P_TEXT',l_api_name_full||'- Project_id null');
10534: fnd_msg_pub.ADD;
10535: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NULL) THEN
10536: x_return_status := FND_API.G_RET_STS_ERROR;
10537: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_TASK_NUM');
10533: fnd_message.set_token ('P_TEXT',l_api_name_full||'- Project_id null');
10534: fnd_msg_pub.ADD;
10535: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NULL) THEN
10536: x_return_status := FND_API.G_RET_STS_ERROR;
10537: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_TASK_NUM');
10538: fnd_message.set_token ('P_TEXT',l_api_name_full||'-task_id null');
10539: fnd_msg_pub.ADD;
10540: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NOT NULL AND p_exp_org_id IS NULL) THEN
10541: x_return_status := FND_API.G_RET_STS_ERROR;
10534: fnd_msg_pub.ADD;
10535: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NULL) THEN
10536: x_return_status := FND_API.G_RET_STS_ERROR;
10537: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_TASK_NUM');
10538: fnd_message.set_token ('P_TEXT',l_api_name_full||'-task_id null');
10539: fnd_msg_pub.ADD;
10540: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NOT NULL AND p_exp_org_id IS NULL) THEN
10541: x_return_status := FND_API.G_RET_STS_ERROR;
10542: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_EXPENDITURE_ORG');
10538: fnd_message.set_token ('P_TEXT',l_api_name_full||'-task_id null');
10539: fnd_msg_pub.ADD;
10540: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NOT NULL AND p_exp_org_id IS NULL) THEN
10541: x_return_status := FND_API.G_RET_STS_ERROR;
10542: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_EXPENDITURE_ORG');
10543: fnd_message.set_token ('P_TEXT',l_api_name_full||'-exp_org_id null');
10544: fnd_msg_pub.ADD;
10545: ELSE
10546: BEGIN
10539: fnd_msg_pub.ADD;
10540: ELSIF (p_project_id IS NOT NULL AND p_project_task_id IS NOT NULL AND p_exp_org_id IS NULL) THEN
10541: x_return_status := FND_API.G_RET_STS_ERROR;
10542: FND_MESSAGE.Set_Name('CS', 'CS_SR_NO_EXPENDITURE_ORG');
10543: fnd_message.set_token ('P_TEXT',l_api_name_full||'-exp_org_id null');
10544: fnd_msg_pub.ADD;
10545: ELSE
10546: BEGIN
10547: --deriving project_number based on project_id
10563: --(which means they are not valid for the OU context) then a error message
10564: -- CS_INC_CLEAR_PROJECT_INFO -- The project details are not valid for the
10565: -- selected Operating Unit.Please enter valid combination
10566: if (l_project_id IS NULL OR l_project_task_id IS NULL OR l_exp_org_id IS NULL) THEN
10567: FND_MESSAGE.Set_Name('CS', 'CS_INC_CLEAR_PROJECT_INFO');
10568: fnd_message.set_token ('P_TEXT',l_api_name_full);
10569: fnd_msg_pub.ADD;
10570: x_return_status := FND_API.G_RET_STS_ERROR;
10571: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10564: -- CS_INC_CLEAR_PROJECT_INFO -- The project details are not valid for the
10565: -- selected Operating Unit.Please enter valid combination
10566: if (l_project_id IS NULL OR l_project_task_id IS NULL OR l_exp_org_id IS NULL) THEN
10567: FND_MESSAGE.Set_Name('CS', 'CS_INC_CLEAR_PROJECT_INFO');
10568: fnd_message.set_token ('P_TEXT',l_api_name_full);
10569: fnd_msg_pub.ADD;
10570: x_return_status := FND_API.G_RET_STS_ERROR;
10571: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10572: ELSE
10574: END IF;
10575:
10576: EXCEPTION
10577: WHEN TOO_MANY_ROWS THEN
10578: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
10579: --throwing SQLERRM CZ this means there is data issue
10580: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10581: fnd_msg_pub.ADD;
10582: x_return_status := FND_API.G_RET_STS_ERROR;
10576: EXCEPTION
10577: WHEN TOO_MANY_ROWS THEN
10578: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
10579: --throwing SQLERRM CZ this means there is data issue
10580: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10581: fnd_msg_pub.ADD;
10582: x_return_status := FND_API.G_RET_STS_ERROR;
10583: --x_return_status := FND_API.G_RET_STS_SUCCESS;
10584: WHEN NO_DATA_FOUND THEN
10595:
10596: EXCEPTION WHEN OTHERS THEN
10597: x_return_status := FND_API.G_RET_STS_ERROR;
10598: -- x_error_msg:= 'The project number and/or project task number are not valid.Please select valid values.';
10599: --fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||x_error_msg);
10600: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
10601: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10602: fnd_msg_pub.ADD;
10603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10596: EXCEPTION WHEN OTHERS THEN
10597: x_return_status := FND_API.G_RET_STS_ERROR;
10598: -- x_error_msg:= 'The project number and/or project task number are not valid.Please select valid values.';
10599: --fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||x_error_msg);
10600: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
10601: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10602: fnd_msg_pub.ADD;
10603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10604: END VALIDATE_PROJECT_INFO;
10597: x_return_status := FND_API.G_RET_STS_ERROR;
10598: -- x_error_msg:= 'The project number and/or project task number are not valid.Please select valid values.';
10599: --fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||x_error_msg);
10600: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
10601: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10602: fnd_msg_pub.ADD;
10603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10604: END VALIDATE_PROJECT_INFO;
10605:
10644: p_table_name => G_TABLE_NAME,
10645: p_column_name => 'PRICE_LIST_HEADER_ID' );
10646: x_return_status := FND_API.G_RET_STS_ERROR;
10647: WHEN OTHERS THEN
10648: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10649: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10650: fnd_msg_pub.ADD;
10651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10652: END VALIDATE_PRICE_LIST_HEADER;
10645: p_column_name => 'PRICE_LIST_HEADER_ID' );
10646: x_return_status := FND_API.G_RET_STS_ERROR;
10647: WHEN OTHERS THEN
10648: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
10649: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);
10650: fnd_msg_pub.ADD;
10651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10652: END VALIDATE_PRICE_LIST_HEADER;
10653: