65: OPEN l_ValidateAddressFlag_csr;
66: FETCH l_ValidateAddressFlag_csr INTO l_Validate_Address_Flag;
67: IF (l_ValidateAddressFlag_csr%NOTFOUND) THEN
68: l_Validate_Address_Flag := 'N';
69: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
70: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
71: FND_MSG_PUB.Add;
72: END IF;
73: CLOSE l_ValidateAddressFlag_csr;
66: FETCH l_ValidateAddressFlag_csr INTO l_Validate_Address_Flag;
67: IF (l_ValidateAddressFlag_csr%NOTFOUND) THEN
68: l_Validate_Address_Flag := 'N';
69: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
70: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
71: FND_MSG_PUB.Add;
72: END IF;
73: CLOSE l_ValidateAddressFlag_csr;
74:
89: x_msg_count := l_msg_count;
90: x_msg_data := l_msg_data;
91:
92: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
93: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
94: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
95: FND_MSG_PUB.Add;
96: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSE
90: x_msg_data := l_msg_data;
91:
92: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
93: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
94: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
95: FND_MSG_PUB.Add;
96: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSE
98: l_incident_address_index := l_incident_address_rec.FIRST;
114: x_msg_count := l_msg_count;
115: x_msg_data := l_msg_data;
116:
117: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
118: FND_MESSAGE.Set_Name('CUG', 'CUG_TYPE_VALIDATION_FAILED');
119: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
120: FND_MSG_PUB.Add;
121: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
115: x_msg_data := l_msg_data;
116:
117: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
118: FND_MESSAGE.Set_Name('CUG', 'CUG_TYPE_VALIDATION_FAILED');
119: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
120: FND_MSG_PUB.Add;
121: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123: END IF; -- Jurisdiction check (only of address validation api did not do jurisdiction check)
130: x_msg_data := l_msg_data;
131:
132: EXCEPTION
133: WHEN FND_API.G_EXC_ERROR THEN
134: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
135: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
136: FND_MSG_PUB.Add;
137: x_return_status := 'E';
138: FND_MSG_PUB.Count_And_Get
131:
132: EXCEPTION
133: WHEN FND_API.G_EXC_ERROR THEN
134: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
135: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
136: FND_MSG_PUB.Add;
137: x_return_status := 'E';
138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,
141: );
142: -- raise FND_API.G_EXC_ERROR;
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
146: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
147: FND_MSG_PUB.Add;
148: x_return_status := 'E';
149: FND_MSG_PUB.Count_And_Get
142: -- raise FND_API.G_EXC_ERROR;
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
146: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
147: FND_MSG_PUB.Add;
148: x_return_status := 'E';
149: FND_MSG_PUB.Count_And_Get
150: ( p_count => x_msg_count,
151: p_data => x_msg_data
152: );
153: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
154: WHEN OTHERS THEN
155: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
156: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
157: FND_MSG_PUB.Add;
158: x_return_status := 'U';
159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
152: );
153: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
154: WHEN OTHERS THEN
155: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
156: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
157: FND_MSG_PUB.Add;
158: x_return_status := 'U';
159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
160: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);