APPS.CUG_VALIDATE_ADDRESS_TYPE dependencies on FND_API

Line 19: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,

15: G_PKG_NAME CONSTANT VARCHAR2(25):= 'CUG_VALIDATE_ADDRESS_TYPE';
16:
17: PROCEDURE Validate_Incident_Address_Type (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
20: p_commit IN VARCHAR2 default fnd_api.g_false,
21: p_incident_type_id IN NUMBER,
22: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_TYPE.INCIDENT_ADDRESS_TBL,
23: x_msg_count OUT NOCOPY NUMBER,

Line 20: p_commit IN VARCHAR2 default fnd_api.g_false,

16:
17: PROCEDURE Validate_Incident_Address_Type (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
20: p_commit IN VARCHAR2 default fnd_api.g_false,
21: p_incident_type_id IN NUMBER,
22: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_TYPE.INCIDENT_ADDRESS_TBL,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,

Line 26: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL)

22: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_TYPE.INCIDENT_ADDRESS_TBL,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: x_return_status OUT NOCOPY VARCHAR2,
26: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL)
27: IS
28: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Incident_Address_Type';
29: l_api_version CONSTANT NUMBER := 2.0;
30: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;

Line 59: l_return_status := FND_API.G_RET_STS_SUCCESS;

55: l_incident_address_index := l_incident_address_rec.FIRST;
56:
57: l_incident_address_rec(l_incident_address_index).jurisdiction_status := 'S';
58: l_incident_address_rec(l_incident_address_index).validation_status := 'S';
59: l_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: -- Check if the validate_address flag is turned on for the given incident type
62: -- If yes, only then call CUG_VALIDATE_ADDRESS_PKG.Validate_Incident_Address
63: -- Else, do not call anything. Just return success status

Line 92: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

88: p_incident_address_rec := l_incident_address_rec;
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;

Line 96: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
99:
100: IF(l_incident_address_rec(l_incident_address_index).jurisdiction_status is NULL) THEN

Line 117: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

113: p_incident_address_rec := l_incident_address_rec;
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;

Line 121: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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)
124: END IF; -- If return status from Address Validation was succesful
125: END IF; -- If validate_address_flag = 'Y'

Line 133: WHEN FND_API.G_EXC_ERROR THEN

129: x_msg_count := l_msg_count;
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';

Line 142: -- raise FND_API.G_EXC_ERROR;

138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,
140: p_data => x_msg_data
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);

Line 144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

140: p_data => x_msg_data
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';

Line 153: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 166: -- raise FND_API.G_EXC_ERROR;

162: FND_MSG_PUB.Count_And_Get
163: ( p_count => x_msg_count,
164: p_data => x_msg_data
165: );
166: -- raise FND_API.G_EXC_ERROR;
167:
168: END Validate_Incident_Address_Type;
169: -- Enter further code below as specified in the Package spec.
170: END; -- Package Body CUG_VALIDATE_ADDRESS_TYPE