DBA Data[Home] [Help]

APPS.CUG_VALIDATE_ADDRESS_PUB dependencies on FND_API

Line 21: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,

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

Line 22: p_commit IN VARCHAR2 default fnd_api.g_false,

18:
19: PROCEDURE Validate_Incident_Address (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
22: p_commit IN VARCHAR2 default fnd_api.g_false,
23: p_incident_type_id IN NUMBER,
24: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2,

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

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

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

70: x_return_status => l_return_status,
71: p_validation_level => p_validation_level);
72:
73:
74: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
75: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALADDR_PRE_CST_USR_HK');
76: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
77: FND_MSG_PUB.Add;
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

74: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
75: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALADDR_PRE_CST_USR_HK');
76: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
77: FND_MSG_PUB.Add;
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80: END IF;
81:
82:

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

96: x_msg_data => l_msg_data,
97: x_return_status => l_return_status,
98: p_validation_level => p_validation_level);
99:
100: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
101: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALADDR_PRE_VRT_USR_HK');
102: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

100: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
101: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALADDR_PRE_VRT_USR_HK');
102: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
103: FND_MSG_PUB.Add;
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105: END IF;
106: END IF;
107:
108:

Line 109: -- l_return_status := FND_API.G_RET_STS_SUCCESS;

105: END IF;
106: END IF;
107:
108:
109: -- l_return_status := FND_API.G_RET_STS_SUCCESS;
110: CUG_Validate_Address_Pvt.Validate_Incident_Address (
111: p_api_version => l_api_version,
112: p_init_msg_list => p_init_msg_list,
113: p_commit => p_commit,

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

121: -- Begin of changes by ANEEMUCH
122: -- Bug fix 2329158
123:
124: x_return_status := l_return_status;
125: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
126: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
127: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
128: FND_MSG_PUB.Add;
129: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 129: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

125: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
126: FND_MESSAGE.Set_Name('CUG', 'CUG_ADDRESS_VALIDATION_FAILED');
127: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
128: FND_MSG_PUB.Add;
129: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: END IF;
131: --
132: -- End of changes by ANEEMUCH
133:

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

147: x_msg_data => l_msg_data,
148: x_return_status => l_return_status,
149: p_validation_level => p_validation_level);
150:
151: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
152: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALADDR_PST_CST_USR_HK');
153: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
154: FND_MSG_PUB.Add;
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
152: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALADDR_PST_CST_USR_HK');
153: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
154: FND_MSG_PUB.Add;
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157: END IF;
158:
159: -- Post call to the Vertical Type User Hook

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

172: x_msg_data => l_msg_data,
173: x_return_status => l_return_status,
174: p_validation_level => p_validation_level);
175:
176: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
177: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALADDR_PST_VRT_USR_HK');
178: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
179: FND_MSG_PUB.Add;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
177: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALADDR_PST_VRT_USR_HK');
178: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
179: FND_MSG_PUB.Add;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182: END IF;
183:
184: END Validate_Incident_Address;

Line 190: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,

186:
187:
188: PROCEDURE Validate_Incident_Type (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
191: p_commit IN VARCHAR2 default fnd_api.g_false,
192: p_incident_type_id IN NUMBER,
193: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL,
194: x_msg_count OUT NOCOPY NUMBER,

Line 191: p_commit IN VARCHAR2 default fnd_api.g_false,

187:
188: PROCEDURE Validate_Incident_Type (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
191: p_commit IN VARCHAR2 default fnd_api.g_false,
192: p_incident_type_id IN NUMBER,
193: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,

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

193: p_incident_address_rec IN OUT NOCOPY CUG_VALIDATE_ADDRESS_PUB.INCIDENT_ADDRESS_TBL,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: x_return_status OUT NOCOPY VARCHAR2,
197: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL)
198: IS
199: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Incident_Type';
200: l_api_version CONSTANT NUMBER := 2.0;
201: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;

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

238: x_msg_data => l_msg_data,
239: x_return_status => l_return_status,
240: p_validation_level => p_validation_level);
241:
242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALTYPE_PRE_CST_USR_HK');
244: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
245: FND_MSG_PUB.Add;
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALTYPE_PRE_CST_USR_HK');
244: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
245: FND_MSG_PUB.Add;
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: END IF;
248: END IF;
249:
250:

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

264: x_msg_data => l_msg_data,
265: x_return_status => l_return_status,
266: p_validation_level => p_validation_level);
267:
268: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
269: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALTYPE_PRE_VRT_USR_HK');
270: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
269: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALTYPE_PRE_VRT_USR_HK');
270: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: END IF;
275:
276:

Line 277: -- l_return_status := FND_API.G_RET_STS_SUCCESS;

273: END IF;
274: END IF;
275:
276:
277: -- l_return_status := FND_API.G_RET_STS_SUCCESS;
278: CUG_Validate_Address_Pvt.Validate_Incident_Type (
279: p_api_version => l_api_version,
280: p_init_msg_list => p_init_msg_list,
281: p_commit => p_commit,

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

289: -- Begin of changes by ANEEMUCH
290: -- Bug fix 2329158
291:
292: x_return_status := l_return_status;
293: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
294: FND_MESSAGE.Set_Name('CUG', 'CUG_TYPE_VALIDATION_FAILED');
295: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
296: FND_MSG_PUB.Add;
297: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 297: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

293: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
294: FND_MESSAGE.Set_Name('CUG', 'CUG_TYPE_VALIDATION_FAILED');
295: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
296: FND_MSG_PUB.Add;
297: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: END IF;
299: --
300: -- End of changes by ANEEMUCH
301:

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

316: x_msg_data => l_msg_data,
317: x_return_status => l_return_status,
318: p_validation_level => p_validation_level);
319:
320: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
321: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALTYPE_PST_CST_USR_HK');
322: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
323: FND_MSG_PUB.Add;
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

320: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
321: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALTYPE_PST_CST_USR_HK');
322: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
323: FND_MSG_PUB.Add;
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326: END IF;
327:
328: -- Post call to the Vertical Type User Hook

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

341: x_msg_data => l_msg_data,
342: x_return_status => l_return_status,
343: p_validation_level => p_validation_level);
344:
345: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
346: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALTYPE_PST_VRT_USR_HK');
347: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
348: FND_MSG_PUB.Add;
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

345: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
346: FND_MESSAGE.Set_Name('CUG', 'CUG_API_VALTYPE_PST_VRT_USR_HK');
347: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
348: FND_MSG_PUB.Add;
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351: END IF;
352:
353: END Validate_Incident_Type;