eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_GE_CHKLST_RESP_PVT dependencies on FND_API

Line 53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

49: -- Parameters
50: --
51: -- IN
52: -- p_api_version_number IN NUMBER Required
53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
57: --

Line 54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

50: --
51: -- IN
52: -- p_api_version_number IN NUMBER Required
53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
57: --
58: -- OUT

Line 55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

51: -- IN
52: -- p_api_version_number IN NUMBER Required
53: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
57: --
58: -- OUT
59: -- x_return_status OUT VARCHAR2

Line 79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

75: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
76:
77: PROCEDURE Create_Ge_Chklst_Resp(
78: p_api_version_number IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82:
83: x_return_status OUT NOCOPY VARCHAR2,

Line 80: p_commit IN VARCHAR2 := FND_API.G_FALSE,

76:
77: PROCEDURE Create_Ge_Chklst_Resp(
78: p_api_version_number IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82:
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,

Line 81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

77: PROCEDURE Create_Ge_Chklst_Resp(
78: p_api_version_number IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82:
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,

Line 96: l_org_id NUMBER := FND_API.G_MISS_NUM;

92: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Ge_Chklst_Resp';
93: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
94: l_return_status_full VARCHAR2(1);
95: l_object_version_number NUMBER := 1;
96: l_org_id NUMBER := FND_API.G_MISS_NUM;
97: l_chklst_response_id NUMBER;
98: l_dummy NUMBER;
99: --added
100: l_ge_chklst_resp_rec ge_chklst_resp_rec_type := p_ge_chklst_resp_rec;

Line 116: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

112: -- Standard Start of API savepoint
113: SAVEPOINT create_ge_chklst_resp_pvt;
114:
115: -- Standard call to check for call compatibility.
116: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
117: p_api_version_number,
118: l_api_name,
119: G_PKG_NAME)
120: THEN

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117: p_api_version_number,
118: l_api_name,
119: G_PKG_NAME)
120: THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124:
125: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 126: IF FND_API.to_Boolean( p_init_msg_list )

122: END IF;
123:
124:
125: -- Initialize message list if p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )
127: THEN
128: FND_MSG_PUB.initialize;
129: END IF;
130:

Line 142: x_return_status := FND_API.G_RET_STS_SUCCESS;

138:
139:
140:
141: -- Initialize API return status to SUCCESS
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144:
145: -- Local variable initialization
146:

Line 147: IF p_ge_chklst_resp_rec.chklst_response_id IS NULL OR p_ge_chklst_resp_rec.chklst_response_id = FND_API.g_miss_num THEN

143:
144:
145: -- Local variable initialization
146:
147: IF p_ge_chklst_resp_rec.chklst_response_id IS NULL OR p_ge_chklst_resp_rec.chklst_response_id = FND_API.g_miss_num THEN
148: LOOP
149: l_dummy := NULL;
150: OPEN c_id;
151: --FETCH c_id INTO l_chklst_response_id;

Line 172: RAISE FND_API.G_EXC_ERROR;

168:
169: IF FND_GLOBAL.USER_ID IS NULL
170: THEN
171: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:
175:
176:

Line 177: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

173: END IF;
174:
175:
176:
177: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
178: THEN
179: -- Debug message
180: IF (PV_DEBUG_HIGH_ON) THEN
181:

Line 198: p_init_msg_list => FND_API.G_FALSE,

194:
195: -- Invoke validation procedures
196: Validate_ge_chklst_resp(
197: p_api_version_number => 1.0,
198: p_init_msg_list => FND_API.G_FALSE,
199: p_validation_level => p_validation_level,
200: p_validation_mode => JTF_PLSQL_API.g_create,
201: --p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
202: p_ge_chklst_resp_rec => l_ge_chklst_resp_rec,

Line 208: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data);
206: END IF;
207:
208: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:
212:

Line 209: RAISE FND_API.G_EXC_ERROR;

205: x_msg_data => x_msg_data);
206: END IF;
207:
208: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:
212:
213:

Line 237: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

233: p_last_update_login => FND_GLOBAL.conc_login_id
234: );
235:
236: x_chklst_response_id := l_chklst_response_id;
237: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: --
241: -- End of API body

Line 238: RAISE FND_API.G_EXC_ERROR;

234: );
235:
236: x_chklst_response_id := l_chklst_response_id;
237: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: --
241: -- End of API body
242: --

Line 245: IF FND_API.to_Boolean( p_commit )

241: -- End of API body
242: --
243:
244: -- Standard check for p_commit
245: IF FND_API.to_Boolean( p_commit )
246: THEN
247: COMMIT WORK;
248: END IF;
249:

Line 266: x_return_status := FND_API.g_ret_sts_error;

262: );
263: EXCEPTION
264:
265: WHEN PVX_UTILITY_PVT.resource_locked THEN
266: x_return_status := FND_API.g_ret_sts_error;
267: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;

Line 269: WHEN FND_API.G_EXC_ERROR THEN

265: WHEN PVX_UTILITY_PVT.resource_locked THEN
266: x_return_status := FND_API.g_ret_sts_error;
267: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,

Line 274: p_encoded => FND_API.G_FALSE,

270: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data
277: );
278:

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

275: p_count => x_msg_count,
276: p_data => x_msg_data
277: );
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: -- Standard call to get message count and if count=1, get the message
283: FND_MSG_PUB.Count_And_Get (

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

277: );
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: -- Standard call to get message count and if count=1, get the message
283: FND_MSG_PUB.Count_And_Get (
284: p_encoded => FND_API.G_FALSE,
285: p_count => x_msg_count,

Line 284: p_encoded => FND_API.G_FALSE,

280: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: -- Standard call to get message count and if count=1, get the message
283: FND_MSG_PUB.Count_And_Get (
284: p_encoded => FND_API.G_FALSE,
285: p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288:

Line 291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

287: );
288:
289: WHEN OTHERS THEN
290: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
293: THEN
294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
295: END IF;

Line 298: p_encoded => FND_API.G_FALSE,

294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
295: END IF;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get (
298: p_encoded => FND_API.G_FALSE,
299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302: End Create_Ge_Chklst_Resp;

Line 318: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

314: -- Parameters
315: --
316: -- IN
317: -- p_api_version_number IN NUMBER Required
318: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
319: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
320: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
321: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
322: --

Line 319: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

315: --
316: -- IN
317: -- p_api_version_number IN NUMBER Required
318: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
319: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
320: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
321: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
322: --
323: -- OUT

Line 320: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

316: -- IN
317: -- p_api_version_number IN NUMBER Required
318: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
319: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
320: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
321: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
322: --
323: -- OUT
324: -- x_return_status OUT VARCHAR2

Line 340: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

336: -- ==============================================================================
337:
338: PROCEDURE Update_Ge_Chklst_Resp(
339: p_api_version_number IN NUMBER,
340: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
341: p_commit IN VARCHAR2 := FND_API.G_FALSE,
342: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
343:
344: x_return_status OUT NOCOPY VARCHAR2,

Line 341: p_commit IN VARCHAR2 := FND_API.G_FALSE,

337:
338: PROCEDURE Update_Ge_Chklst_Resp(
339: p_api_version_number IN NUMBER,
340: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
341: p_commit IN VARCHAR2 := FND_API.G_FALSE,
342: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
343:
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,

Line 342: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

338: PROCEDURE Update_Ge_Chklst_Resp(
339: p_api_version_number IN NUMBER,
340: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
341: p_commit IN VARCHAR2 := FND_API.G_FALSE,
342: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
343:
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,

Line 375: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

371: -- Standard Start of API savepoint
372: SAVEPOINT update_ge_chklst_resp_pvt;
373:
374: -- Standard call to check for call compatibility.
375: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
376: p_api_version_number,
377: l_api_name,
378: G_PKG_NAME)
379: THEN

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: p_api_version_number,
377: l_api_name,
378: G_PKG_NAME)
379: THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382:
383:
384: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 385: IF FND_API.to_Boolean( p_init_msg_list )

381: END IF;
382:
383:
384: -- Initialize message list if p_init_msg_list is set to TRUE.
385: IF FND_API.to_Boolean( p_init_msg_list )
386: THEN
387: FND_MSG_PUB.initialize;
388: END IF;
389:

Line 401: x_return_status := FND_API.G_RET_STS_SUCCESS;

397:
398:
399:
400: -- Initialize API return status to SUCCESS
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402:
403: -- Debug Message
404: IF (PV_DEBUG_HIGH_ON) THEN
405:

Line 417: RAISE FND_API.G_EXC_ERROR;

413: If ( c_get_Ge_Chklst_Resp%NOTFOUND) THEN
414: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
415: p_token_name => 'INFO',
416: p_token_value => 'Ge_Chklst_Resp') ;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419: -- Debug Message
420: IF (PV_DEBUG_HIGH_ON) THEN
421:

Line 428: l_tar_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM ) Then

424: CLOSE c_get_Ge_Chklst_Resp;
425:
426:
427: If (l_tar_ge_chklst_resp_rec.object_version_number is NULL or
428: l_tar_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM ) Then
429: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
430: p_token_name => 'COLUMN',
431: p_token_value => 'Last_Update_Date') ;
432: raise FND_API.G_EXC_ERROR;

Line 432: raise FND_API.G_EXC_ERROR;

428: l_tar_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM ) Then
429: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
430: p_token_name => 'COLUMN',
431: p_token_value => 'Last_Update_Date') ;
432: raise FND_API.G_EXC_ERROR;
433: End if;
434: -- Check Whether record has been changed by someone else
435: If (l_tar_ge_chklst_resp_rec.object_version_number <> l_ref_ge_chklst_resp_rec.object_version_number) Then
436: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 439: raise FND_API.G_EXC_ERROR;

435: If (l_tar_ge_chklst_resp_rec.object_version_number <> l_ref_ge_chklst_resp_rec.object_version_number) Then
436: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
437: p_token_name => 'INFO',
438: p_token_value => 'Ge_Chklst_Resp') ;
439: raise FND_API.G_EXC_ERROR;
440: End if;
441:
442:
443: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 443: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

439: raise FND_API.G_EXC_ERROR;
440: End if;
441:
442:
443: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
444: THEN
445: -- Debug message
446: IF (PV_DEBUG_HIGH_ON) THEN
447:

Line 454: p_init_msg_list => FND_API.G_FALSE,

450:
451: -- Invoke validation procedures
452: Validate_ge_chklst_resp(
453: p_api_version_number => 1.0,
454: p_init_msg_list => FND_API.G_FALSE,
455: p_validation_level => p_validation_level,
456: p_validation_mode => JTF_PLSQL_API.g_update,
457: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
458: x_return_status => x_return_status,

Line 463: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

459: x_msg_count => x_msg_count,
460: x_msg_data => x_msg_data);
461: END IF;
462:
463: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
464: RAISE FND_API.G_EXC_ERROR;
465: END IF;
466:
467:

Line 464: RAISE FND_API.G_EXC_ERROR;

460: x_msg_data => x_msg_data);
461: END IF;
462:
463: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
464: RAISE FND_API.G_EXC_ERROR;
465: END IF;
466:
467:
468: -- Debug Message

Line 488: IF FND_API.to_Boolean( p_commit )

484: -- End of API body.
485: --
486:
487: -- Standard check for p_commit
488: IF FND_API.to_Boolean( p_commit )
489: THEN
490: COMMIT WORK;
491: END IF;
492:

Line 509: x_return_status := FND_API.g_ret_sts_error;

505: );
506: EXCEPTION
507:
508: WHEN PVX_UTILITY_PVT.resource_locked THEN
509: x_return_status := FND_API.g_ret_sts_error;
510: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
511:
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;

Line 512: WHEN FND_API.G_EXC_ERROR THEN

508: WHEN PVX_UTILITY_PVT.resource_locked THEN
509: x_return_status := FND_API.g_ret_sts_error;
510: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
511:
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (

Line 514: x_return_status := FND_API.G_RET_STS_ERROR;

510: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
511:
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,

Line 517: p_encoded => FND_API.G_FALSE,

513: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );
521:

Line 522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (

Line 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

520: );
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,

Line 527: p_encoded => FND_API.G_FALSE,

523: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );
531:

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

530: );
531:
532: WHEN OTHERS THEN
533: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
536: THEN
537: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
538: END IF;

Line 541: p_encoded => FND_API.G_FALSE,

537: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
538: END IF;
539: -- Standard call to get message count and if count=1, get the message
540: FND_MSG_PUB.Count_And_Get (
541: p_encoded => FND_API.G_FALSE,
542: p_count => x_msg_count,
543: p_data => x_msg_data
544: );
545: End Update_Ge_Chklst_Resp;

Line 561: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

557: -- Parameters
558: --
559: -- IN
560: -- p_api_version_number IN NUMBER Required
561: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
562: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
563: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
564: -- p_chklst_response_id IN NUMBER
565: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 562: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

558: --
559: -- IN
560: -- p_api_version_number IN NUMBER Required
561: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
562: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
563: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
564: -- p_chklst_response_id IN NUMBER
565: -- p_object_version_number IN NUMBER Optional Default = NULL
566: --

Line 563: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

559: -- IN
560: -- p_api_version_number IN NUMBER Required
561: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
562: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
563: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
564: -- p_chklst_response_id IN NUMBER
565: -- p_object_version_number IN NUMBER Optional Default = NULL
566: --
567: -- OUT

Line 584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

580: -- ==============================================================================
581:
582: PROCEDURE Delete_Ge_Chklst_Resp(
583: p_api_version_number IN NUMBER,
584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
587: x_return_status OUT NOCOPY VARCHAR2,
588: x_msg_count OUT NOCOPY NUMBER,

Line 585: p_commit IN VARCHAR2 := FND_API.G_FALSE,

581:
582: PROCEDURE Delete_Ge_Chklst_Resp(
583: p_api_version_number IN NUMBER,
584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
587: x_return_status OUT NOCOPY VARCHAR2,
588: x_msg_count OUT NOCOPY NUMBER,
589: x_msg_data OUT NOCOPY VARCHAR2,

Line 586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

582: PROCEDURE Delete_Ge_Chklst_Resp(
583: p_api_version_number IN NUMBER,
584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
587: x_return_status OUT NOCOPY VARCHAR2,
588: x_msg_count OUT NOCOPY NUMBER,
589: x_msg_data OUT NOCOPY VARCHAR2,
590: p_chklst_response_id IN NUMBER,

Line 604: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

600: -- Standard Start of API savepoint
601: SAVEPOINT delete_ge_chklst_resp_pvt;
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
605: p_api_version_number,
606: l_api_name,
607: G_PKG_NAME)
608: THEN

Line 609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

605: p_api_version_number,
606: l_api_name,
607: G_PKG_NAME)
608: THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;
611:
612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 614: IF FND_API.to_Boolean( p_init_msg_list )

610: END IF;
611:
612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614: IF FND_API.to_Boolean( p_init_msg_list )
615: THEN
616: FND_MSG_PUB.initialize;
617: END IF;
618:

Line 630: x_return_status := FND_API.G_RET_STS_SUCCESS;

626:
627:
628:
629: -- Initialize API return status to SUCCESS
630: x_return_status := FND_API.G_RET_STS_SUCCESS;
631:
632: --
633: -- Api body
634: --

Line 650: IF FND_API.to_Boolean( p_commit )

646: -- End of API body
647: --
648:
649: -- Standard check for p_commit
650: IF FND_API.to_Boolean( p_commit )
651: THEN
652: COMMIT WORK;
653: END IF;
654:

Line 671: x_return_status := FND_API.g_ret_sts_error;

667: );
668: EXCEPTION
669:
670: WHEN PVX_UTILITY_PVT.resource_locked THEN
671: x_return_status := FND_API.g_ret_sts_error;
672: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;

Line 674: WHEN FND_API.G_EXC_ERROR THEN

670: WHEN PVX_UTILITY_PVT.resource_locked THEN
671: x_return_status := FND_API.g_ret_sts_error;
672: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: -- Standard call to get message count and if count=1, get the message
678: FND_MSG_PUB.Count_And_Get (

Line 676: x_return_status := FND_API.G_RET_STS_ERROR;

672: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: -- Standard call to get message count and if count=1, get the message
678: FND_MSG_PUB.Count_And_Get (
679: p_encoded => FND_API.G_FALSE,
680: p_count => x_msg_count,

Line 679: p_encoded => FND_API.G_FALSE,

675: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: -- Standard call to get message count and if count=1, get the message
678: FND_MSG_PUB.Count_And_Get (
679: p_encoded => FND_API.G_FALSE,
680: p_count => x_msg_count,
681: p_data => x_msg_data
682: );
683:

Line 684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

680: p_count => x_msg_count,
681: p_data => x_msg_data
682: );
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: -- Standard call to get message count and if count=1, get the message
688: FND_MSG_PUB.Count_And_Get (

Line 686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

682: );
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: -- Standard call to get message count and if count=1, get the message
688: FND_MSG_PUB.Count_And_Get (
689: p_encoded => FND_API.G_FALSE,
690: p_count => x_msg_count,

Line 689: p_encoded => FND_API.G_FALSE,

685: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: -- Standard call to get message count and if count=1, get the message
688: FND_MSG_PUB.Count_And_Get (
689: p_encoded => FND_API.G_FALSE,
690: p_count => x_msg_count,
691: p_data => x_msg_data
692: );
693:

Line 696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

692: );
693:
694: WHEN OTHERS THEN
695: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
698: THEN
699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
700: END IF;

Line 703: p_encoded => FND_API.G_FALSE,

699: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
700: END IF;
701: -- Standard call to get message count and if count=1, get the message
702: FND_MSG_PUB.Count_And_Get (
703: p_encoded => FND_API.G_FALSE,
704: p_count => x_msg_count,
705: p_data => x_msg_data
706: );
707: End Delete_Ge_Chklst_Resp;

Line 725: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

721: -- Parameters
722: --
723: -- IN
724: -- p_api_version_number IN NUMBER Required
725: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
726: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
727: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
728: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
729: --

Line 726: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

722: --
723: -- IN
724: -- p_api_version_number IN NUMBER Required
725: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
726: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
727: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
728: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
729: --
730: -- OUT

Line 727: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

723: -- IN
724: -- p_api_version_number IN NUMBER Required
725: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
726: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
727: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
728: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
729: --
730: -- OUT
731: -- x_return_status OUT VARCHAR2

Line 747: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

743: -- ==============================================================================
744:
745: PROCEDURE Lock_Ge_Chklst_Resp(
746: p_api_version_number IN NUMBER,
747: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
748:
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,

Line 773: IF FND_API.to_Boolean( p_init_msg_list )

769: END IF;
770:
771:
772: -- Initialize message list if p_init_msg_list is set to TRUE.
773: IF FND_API.to_Boolean( p_init_msg_list )
774: THEN
775: FND_MSG_PUB.initialize;
776: END IF;
777:

Line 781: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

777:
778:
779:
780: -- Standard call to check for call compatibility.
781: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
782: p_api_version_number,
783: l_api_name,
784: G_PKG_NAME)
785: THEN

Line 786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

782: p_api_version_number,
783: l_api_name,
784: G_PKG_NAME)
785: THEN
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: END IF;
788:
789:
790:

Line 792: x_return_status := FND_API.G_RET_STS_SUCCESS;

788:
789:
790:
791: -- Initialize API return status to SUCCESS
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794:
795: ------------------------ lock -------------------------
796: Pv_Ge_Chklst_Resp_Pkg.Lock_Row(l_chklst_response_id,p_object_version);

Line 801: p_encoded => FND_API.g_false,

797:
798:
799: -------------------- finish --------------------------
800: FND_MSG_PUB.count_and_get(
801: p_encoded => FND_API.g_false,
802: p_count => x_msg_count,
803: p_data => x_msg_data);
804: IF (PV_DEBUG_HIGH_ON) THEN
805:

Line 811: x_return_status := FND_API.g_ret_sts_error;

807: END IF;
808: EXCEPTION
809:
810: WHEN PVX_UTILITY_PVT.resource_locked THEN
811: x_return_status := FND_API.g_ret_sts_error;
812: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
813:
814: WHEN FND_API.G_EXC_ERROR THEN
815: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;

Line 814: WHEN FND_API.G_EXC_ERROR THEN

810: WHEN PVX_UTILITY_PVT.resource_locked THEN
811: x_return_status := FND_API.g_ret_sts_error;
812: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
813:
814: WHEN FND_API.G_EXC_ERROR THEN
815: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: -- Standard call to get message count and if count=1, get the message
818: FND_MSG_PUB.Count_And_Get (

Line 816: x_return_status := FND_API.G_RET_STS_ERROR;

812: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
813:
814: WHEN FND_API.G_EXC_ERROR THEN
815: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: -- Standard call to get message count and if count=1, get the message
818: FND_MSG_PUB.Count_And_Get (
819: p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,

Line 819: p_encoded => FND_API.G_FALSE,

815: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: -- Standard call to get message count and if count=1, get the message
818: FND_MSG_PUB.Count_And_Get (
819: p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data
822: );
823:

Line 824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

820: p_count => x_msg_count,
821: p_data => x_msg_data
822: );
823:
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: -- Standard call to get message count and if count=1, get the message
828: FND_MSG_PUB.Count_And_Get (

Line 826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

822: );
823:
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: -- Standard call to get message count and if count=1, get the message
828: FND_MSG_PUB.Count_And_Get (
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,

Line 829: p_encoded => FND_API.G_FALSE,

825: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: -- Standard call to get message count and if count=1, get the message
828: FND_MSG_PUB.Count_And_Get (
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data
832: );
833:

Line 836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

832: );
833:
834: WHEN OTHERS THEN
835: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
838: THEN
839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
840: END IF;

Line 843: p_encoded => FND_API.G_FALSE,

839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
840: END IF;
841: -- Standard call to get message count and if count=1, get the message
842: FND_MSG_PUB.Count_And_Get (
843: p_encoded => FND_API.G_FALSE,
844: p_count => x_msg_count,
845: p_data => x_msg_data
846: );
847: End Lock_Ge_Chklst_Resp;

Line 860: x_return_status := FND_API.g_ret_sts_success;

856: IS
857: l_valid_flag VARCHAR2(1);
858:
859: BEGIN
860: x_return_status := FND_API.g_ret_sts_success;
861: IF p_validation_mode = JTF_PLSQL_API.g_create
862: AND p_ge_chklst_resp_rec.chklst_response_id IS NOT NULL
863: THEN
864: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

Line 870: IF l_valid_flag = FND_API.g_false THEN

866: 'chklst_response_id = ''' || p_ge_chklst_resp_rec.chklst_response_id ||''''
867: );
868: END IF;
869:
870: IF l_valid_flag = FND_API.g_false THEN
871: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_chklst_response_id_DUPLICATE');
872: x_return_status := FND_API.g_ret_sts_error;
873: END IF;
874:

Line 872: x_return_status := FND_API.g_ret_sts_error;

868: END IF;
869:
870: IF l_valid_flag = FND_API.g_false THEN
871: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_chklst_response_id_DUPLICATE');
872: x_return_status := FND_API.g_ret_sts_error;
873: END IF;
874:
875: END check_Ge_Chklst_Resp_Uk_Items;
876:

Line 886: x_return_status := FND_API.g_ret_sts_success;

882: x_return_status OUT NOCOPY VARCHAR2
883: )
884: IS
885: BEGIN
886: x_return_status := FND_API.g_ret_sts_success;
887:
888: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
889:
890:

Line 891: IF p_ge_chklst_resp_rec.chklst_response_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.chklst_response_id IS NULL THEN

887:
888: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
889:
890:
891: IF p_ge_chklst_resp_rec.chklst_response_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.chklst_response_id IS NULL THEN
892: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHKLST_RESPONSE_ID' );
893: x_return_status := FND_API.g_ret_sts_error;
894: END IF;
895:

Line 893: x_return_status := FND_API.g_ret_sts_error;

889:
890:
891: IF p_ge_chklst_resp_rec.chklst_response_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.chklst_response_id IS NULL THEN
892: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHKLST_RESPONSE_ID' );
893: x_return_status := FND_API.g_ret_sts_error;
894: END IF;
895:
896:
897: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.checklist_item_id IS NULL THEN

Line 897: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.checklist_item_id IS NULL THEN

893: x_return_status := FND_API.g_ret_sts_error;
894: END IF;
895:
896:
897: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.checklist_item_id IS NULL THEN
898: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
899: x_return_status := FND_API.g_ret_sts_error;
900: END IF;
901:

Line 899: x_return_status := FND_API.g_ret_sts_error;

895:
896:
897: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.checklist_item_id IS NULL THEN
898: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
899: x_return_status := FND_API.g_ret_sts_error;
900: END IF;
901:
902:
903: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.object_version_number IS NULL THEN

Line 903: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.object_version_number IS NULL THEN

899: x_return_status := FND_API.g_ret_sts_error;
900: END IF;
901:
902:
903: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.object_version_number IS NULL THEN
904: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
905: x_return_status := FND_API.g_ret_sts_error;
906: END IF;
907:

Line 905: x_return_status := FND_API.g_ret_sts_error;

901:
902:
903: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.object_version_number IS NULL THEN
904: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
905: x_return_status := FND_API.g_ret_sts_error;
906: END IF;
907:
908:
909: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char OR p_ge_chklst_resp_rec.arc_response_for_entity_code IS NULL THEN

Line 909: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char OR p_ge_chklst_resp_rec.arc_response_for_entity_code IS NULL THEN

905: x_return_status := FND_API.g_ret_sts_error;
906: END IF;
907:
908:
909: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char OR p_ge_chklst_resp_rec.arc_response_for_entity_code IS NULL THEN
910: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_RESPONSE_FOR_ENTITY_CODE' );
911: x_return_status := FND_API.g_ret_sts_error;
912: END IF;
913:

Line 911: x_return_status := FND_API.g_ret_sts_error;

907:
908:
909: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char OR p_ge_chklst_resp_rec.arc_response_for_entity_code IS NULL THEN
910: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_RESPONSE_FOR_ENTITY_CODE' );
911: x_return_status := FND_API.g_ret_sts_error;
912: END IF;
913:
914:
915: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char OR p_ge_chklst_resp_rec.response_flag IS NULL THEN

Line 915: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char OR p_ge_chklst_resp_rec.response_flag IS NULL THEN

911: x_return_status := FND_API.g_ret_sts_error;
912: END IF;
913:
914:
915: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char OR p_ge_chklst_resp_rec.response_flag IS NULL THEN
916: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FLAG' );
917: x_return_status := FND_API.g_ret_sts_error;
918: END IF;
919:

Line 917: x_return_status := FND_API.g_ret_sts_error;

913:
914:
915: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char OR p_ge_chklst_resp_rec.response_flag IS NULL THEN
916: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FLAG' );
917: x_return_status := FND_API.g_ret_sts_error;
918: END IF;
919:
920:
921: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.response_for_entity_id IS NULL THEN

Line 921: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.response_for_entity_id IS NULL THEN

917: x_return_status := FND_API.g_ret_sts_error;
918: END IF;
919:
920:
921: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.response_for_entity_id IS NULL THEN
922: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FOR_ENTITY_ID' );
923: x_return_status := FND_API.g_ret_sts_error;
924: END IF;
925:

Line 923: x_return_status := FND_API.g_ret_sts_error;

919:
920:
921: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.response_for_entity_id IS NULL THEN
922: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FOR_ENTITY_ID' );
923: x_return_status := FND_API.g_ret_sts_error;
924: END IF;
925:
926:
927: ELSE

Line 930: IF p_ge_chklst_resp_rec.chklst_response_id = FND_API.G_MISS_NUM THEN

926:
927: ELSE
928:
929:
930: IF p_ge_chklst_resp_rec.chklst_response_id = FND_API.G_MISS_NUM THEN
931: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHKLST_RESPONSE_ID' );
932: x_return_status := FND_API.g_ret_sts_error;
933: END IF;
934:

Line 932: x_return_status := FND_API.g_ret_sts_error;

928:
929:
930: IF p_ge_chklst_resp_rec.chklst_response_id = FND_API.G_MISS_NUM THEN
931: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHKLST_RESPONSE_ID' );
932: x_return_status := FND_API.g_ret_sts_error;
933: END IF;
934:
935:
936: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM THEN

Line 936: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM THEN

932: x_return_status := FND_API.g_ret_sts_error;
933: END IF;
934:
935:
936: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM THEN
937: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
938: x_return_status := FND_API.g_ret_sts_error;
939: END IF;
940:

Line 938: x_return_status := FND_API.g_ret_sts_error;

934:
935:
936: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM THEN
937: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
938: x_return_status := FND_API.g_ret_sts_error;
939: END IF;
940:
941:
942: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 942: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM THEN

938: x_return_status := FND_API.g_ret_sts_error;
939: END IF;
940:
941:
942: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM THEN
943: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
944: x_return_status := FND_API.g_ret_sts_error;
945: END IF;
946:

Line 944: x_return_status := FND_API.g_ret_sts_error;

940:
941:
942: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM THEN
943: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
944: x_return_status := FND_API.g_ret_sts_error;
945: END IF;
946:
947:
948: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char THEN

Line 948: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char THEN

944: x_return_status := FND_API.g_ret_sts_error;
945: END IF;
946:
947:
948: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char THEN
949: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_RESPONSE_FOR_ENTITY_CODE' );
950: x_return_status := FND_API.g_ret_sts_error;
951: END IF;
952:

Line 950: x_return_status := FND_API.g_ret_sts_error;

946:
947:
948: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char THEN
949: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_RESPONSE_FOR_ENTITY_CODE' );
950: x_return_status := FND_API.g_ret_sts_error;
951: END IF;
952:
953:
954: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char THEN

Line 954: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char THEN

950: x_return_status := FND_API.g_ret_sts_error;
951: END IF;
952:
953:
954: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char THEN
955: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FLAG' );
956: x_return_status := FND_API.g_ret_sts_error;
957: END IF;
958:

Line 956: x_return_status := FND_API.g_ret_sts_error;

952:
953:
954: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char THEN
955: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FLAG' );
956: x_return_status := FND_API.g_ret_sts_error;
957: END IF;
958:
959:
960: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM THEN

Line 960: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM THEN

956: x_return_status := FND_API.g_ret_sts_error;
957: END IF;
958:
959:
960: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM THEN
961: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FOR_ENTITY_ID' );
962: x_return_status := FND_API.g_ret_sts_error;
963: END IF;
964: END IF;

Line 962: x_return_status := FND_API.g_ret_sts_error;

958:
959:
960: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM THEN
961: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FOR_ENTITY_ID' );
962: x_return_status := FND_API.g_ret_sts_error;
963: END IF;
964: END IF;
965:
966: END check_Ge_Chklst_Resp_Req_Items;

Line 976: x_return_status := FND_API.g_ret_sts_success;

972: x_return_status OUT NOCOPY VARCHAR2
973: )
974: IS
975: BEGIN
976: x_return_status := FND_API.g_ret_sts_success;
977:
978: -- Enter custom code here
979:
980: END check_Ge_Chklst_Resp_Fk_Items;

Line 990: x_return_status := FND_API.g_ret_sts_success;

986: x_return_status OUT NOCOPY VARCHAR2
987: )
988: IS
989: BEGIN
990: x_return_status := FND_API.g_ret_sts_success;
991:
992: -- Enter custom code here
993:
994: END check_Ge_Chklst_Resp_Lkup_Item;

Line 1007: l_return_status := FND_API.g_ret_sts_success;

1003: IS
1004: l_return_status VARCHAR2(1);
1005: BEGIN
1006:
1007: l_return_status := FND_API.g_ret_sts_success;
1008: -- Check Items Uniqueness API calls
1009:
1010: check_Ge_chklst_resp_Uk_Items(
1011: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,

Line 1014: IF x_return_status <> FND_API.g_ret_sts_success THEN

1010: check_Ge_chklst_resp_Uk_Items(
1011: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
1012: p_validation_mode => p_validation_mode,
1013: x_return_status => x_return_status);
1014: IF x_return_status <> FND_API.g_ret_sts_success THEN
1015: l_return_status := FND_API.g_ret_sts_error;
1016: END IF;
1017:
1018: -- Check Items Required/NOT NULL API calls

Line 1015: l_return_status := FND_API.g_ret_sts_error;

1011: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
1012: p_validation_mode => p_validation_mode,
1013: x_return_status => x_return_status);
1014: IF x_return_status <> FND_API.g_ret_sts_success THEN
1015: l_return_status := FND_API.g_ret_sts_error;
1016: END IF;
1017:
1018: -- Check Items Required/NOT NULL API calls
1019:

Line 1024: IF x_return_status <> FND_API.g_ret_sts_success THEN

1020: check_ge_chklst_resp_req_items(
1021: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
1022: p_validation_mode => p_validation_mode,
1023: x_return_status => x_return_status);
1024: IF x_return_status <> FND_API.g_ret_sts_success THEN
1025: l_return_status := FND_API.g_ret_sts_error;
1026: END IF;
1027: -- Check Items Foreign Keys API calls
1028:

Line 1025: l_return_status := FND_API.g_ret_sts_error;

1021: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
1022: p_validation_mode => p_validation_mode,
1023: x_return_status => x_return_status);
1024: IF x_return_status <> FND_API.g_ret_sts_success THEN
1025: l_return_status := FND_API.g_ret_sts_error;
1026: END IF;
1027: -- Check Items Foreign Keys API calls
1028:
1029: check_ge_chklst_resp_FK_items(

Line 1032: IF x_return_status <> FND_API.g_ret_sts_success THEN

1028:
1029: check_ge_chklst_resp_FK_items(
1030: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
1031: x_return_status => x_return_status);
1032: IF x_return_status <> FND_API.g_ret_sts_success THEN
1033: l_return_status := FND_API.g_ret_sts_error;
1034: END IF;
1035: -- Check Items Lookups
1036:

Line 1033: l_return_status := FND_API.g_ret_sts_error;

1029: check_ge_chklst_resp_FK_items(
1030: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
1031: x_return_status => x_return_status);
1032: IF x_return_status <> FND_API.g_ret_sts_success THEN
1033: l_return_status := FND_API.g_ret_sts_error;
1034: END IF;
1035: -- Check Items Lookups
1036:
1037: check_Ge_Chklst_Resp_Lkup_Item(

Line 1040: IF x_return_status <> FND_API.g_ret_sts_success THEN

1036:
1037: check_Ge_Chklst_Resp_Lkup_Item(
1038: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
1039: x_return_status => x_return_status);
1040: IF x_return_status <> FND_API.g_ret_sts_success THEN
1041: l_return_status := FND_API.g_ret_sts_error;
1042: END IF;
1043:
1044: x_return_status := l_return_status;

Line 1041: l_return_status := FND_API.g_ret_sts_error;

1037: check_Ge_Chklst_Resp_Lkup_Item(
1038: p_ge_chklst_resp_rec => p_ge_chklst_resp_rec,
1039: x_return_status => x_return_status);
1040: IF x_return_status <> FND_API.g_ret_sts_success THEN
1041: l_return_status := FND_API.g_ret_sts_error;
1042: END IF;
1043:
1044: x_return_status := l_return_status;
1045:

Line 1139: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN

1135: l_ge_chklst_resp_rec ge_chklst_resp_rec_type := p_ge_chklst_resp_rec;
1136: BEGIN
1137: -- Developers should put their code to default the record type
1138: -- e.g. IF p_campaign_rec.status_code IS NULL
1139: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1140: -- l_campaign_rec.status_code := 'NEW' ;
1141: -- END IF ;
1142: --
1143: NULL ;

Line 1151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1147:
1148:
1149: PROCEDURE Validate_Ge_Chklst_Resp(
1150: p_api_version_number IN NUMBER,
1151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1153: p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type,
1154: p_validation_mode IN VARCHAR2,
1155: x_return_status OUT NOCOPY VARCHAR2,

Line 1152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1148:
1149: PROCEDURE Validate_Ge_Chklst_Resp(
1150: p_api_version_number IN NUMBER,
1151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1153: p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type,
1154: p_validation_mode IN VARCHAR2,
1155: x_return_status OUT NOCOPY VARCHAR2,
1156: x_msg_count OUT NOCOPY NUMBER,

Line 1171: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1167: -- Standard Start of API savepoint
1168: SAVEPOINT validate_ge_chklst_resp_;
1169:
1170: -- Standard call to check for call compatibility.
1171: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1172: p_api_version_number,
1173: l_api_name,
1174: G_PKG_NAME)
1175: THEN

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172: p_api_version_number,
1173: l_api_name,
1174: G_PKG_NAME)
1175: THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179:
1180: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1181: IF FND_API.to_Boolean( p_init_msg_list )

1177: END IF;
1178:
1179:
1180: -- Initialize message list if p_init_msg_list is set to TRUE.
1181: IF FND_API.to_Boolean( p_init_msg_list )
1182: THEN
1183: FND_MSG_PUB.initialize;
1184: END IF;
1185:

Line 1194: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1190: p_validation_mode => p_validation_mode,
1191: x_return_status => x_return_status
1192: );
1193:
1194: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1195: RAISE FND_API.G_EXC_ERROR;
1196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1198: END IF;

Line 1195: RAISE FND_API.G_EXC_ERROR;

1191: x_return_status => x_return_status
1192: );
1193:
1194: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1195: RAISE FND_API.G_EXC_ERROR;
1196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1198: END IF;
1199: END IF;

Line 1196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1192: );
1193:
1194: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1195: RAISE FND_API.G_EXC_ERROR;
1196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1198: END IF;
1199: END IF;
1200:

Line 1197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1193:
1194: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1195: RAISE FND_API.G_EXC_ERROR;
1196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1198: END IF;
1199: END IF;
1200:
1201: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1217: p_init_msg_list => FND_API.G_FALSE,

1213:
1214: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1215: Validate_ge_chklst_resp_Rec(
1216: p_api_version_number => 1.0,
1217: p_init_msg_list => FND_API.G_FALSE,
1218: x_return_status => x_return_status,
1219: x_msg_count => x_msg_count,
1220: x_msg_data => x_msg_data,
1221: p_ge_chklst_resp_rec => l_ge_chklst_resp_rec);

Line 1223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1219: x_msg_count => x_msg_count,
1220: x_msg_data => x_msg_data,
1221: p_ge_chklst_resp_rec => l_ge_chklst_resp_rec);
1222:
1223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;

Line 1224: RAISE FND_API.G_EXC_ERROR;

1220: x_msg_data => x_msg_data,
1221: p_ge_chklst_resp_rec => l_ge_chklst_resp_rec);
1222:
1223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;
1228: END IF;

Line 1225: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1221: p_ge_chklst_resp_rec => l_ge_chklst_resp_rec);
1222:
1223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;
1228: END IF;
1229:

Line 1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1222:
1223: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;
1228: END IF;
1229:
1230:

Line 1240: x_return_status := FND_API.G_RET_STS_SUCCESS;

1236:
1237:
1238:
1239: -- Initialize API return status to SUCCESS
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;
1241:
1242:
1243: -- Debug Message
1244: IF (PV_DEBUG_HIGH_ON) THEN

Line 1258: x_return_status := FND_API.g_ret_sts_error;

1254: );
1255: EXCEPTION
1256:
1257: WHEN PVX_UTILITY_PVT.resource_locked THEN
1258: x_return_status := FND_API.g_ret_sts_error;
1259: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;

Line 1261: WHEN FND_API.G_EXC_ERROR THEN

1257: WHEN PVX_UTILITY_PVT.resource_locked THEN
1258: x_return_status := FND_API.g_ret_sts_error;
1259: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (

Line 1263: x_return_status := FND_API.G_RET_STS_ERROR;

1259: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_msg_count,

Line 1266: p_encoded => FND_API.G_FALSE,

1262: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264: -- Standard call to get message count and if count=1, get the message
1265: FND_MSG_PUB.Count_And_Get (
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_msg_count,
1268: p_data => x_msg_data
1269: );
1270:

Line 1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1267: p_count => x_msg_count,
1268: p_data => x_msg_data
1269: );
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1272: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: -- Standard call to get message count and if count=1, get the message
1275: FND_MSG_PUB.Count_And_Get (

Line 1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1269: );
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1272: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: -- Standard call to get message count and if count=1, get the message
1275: FND_MSG_PUB.Count_And_Get (
1276: p_encoded => FND_API.G_FALSE,
1277: p_count => x_msg_count,

Line 1276: p_encoded => FND_API.G_FALSE,

1272: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: -- Standard call to get message count and if count=1, get the message
1275: FND_MSG_PUB.Count_And_Get (
1276: p_encoded => FND_API.G_FALSE,
1277: p_count => x_msg_count,
1278: p_data => x_msg_data
1279: );
1280:

Line 1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1279: );
1280:
1281: WHEN OTHERS THEN
1282: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1285: THEN
1286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1287: END IF;

Line 1290: p_encoded => FND_API.G_FALSE,

1286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1287: END IF;
1288: -- Standard call to get message count and if count=1, get the message
1289: FND_MSG_PUB.Count_And_Get (
1290: p_encoded => FND_API.G_FALSE,
1291: p_count => x_msg_count,
1292: p_data => x_msg_data
1293: );
1294: End Validate_Ge_Chklst_Resp;

Line 1299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1295:
1296:
1297: PROCEDURE Validate_Ge_Chklst_Resp_Rec (
1298: p_api_version_number IN NUMBER,
1299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1300: x_return_status OUT NOCOPY VARCHAR2,
1301: x_msg_count OUT NOCOPY NUMBER,
1302: x_msg_data OUT NOCOPY VARCHAR2,
1303: p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type

Line 1308: IF FND_API.to_Boolean( p_init_msg_list )

1304: )
1305: IS
1306: BEGIN
1307: -- Initialize message list if p_init_msg_list is set to TRUE.
1308: IF FND_API.to_Boolean( p_init_msg_list )
1309: THEN
1310: FND_MSG_PUB.initialize;
1311: END IF;
1312:

Line 1316: x_return_status := FND_API.G_RET_STS_SUCCESS;

1312:
1313:
1314:
1315: -- Initialize API return status to SUCCESS
1316: x_return_status := FND_API.G_RET_STS_SUCCESS;
1317:
1318: -- Hint: Validate data
1319: -- If data not valid
1320: -- THEN

Line 1321: -- x_return_status := FND_API.G_RET_STS_ERROR;

1317:
1318: -- Hint: Validate data
1319: -- If data not valid
1320: -- THEN
1321: -- x_return_status := FND_API.G_RET_STS_ERROR;
1322:
1323: -- Debug Message
1324: IF (PV_DEBUG_HIGH_ON) THEN
1325:

Line 1340: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1336:
1337:
1338: PROCEDURE Create_Enrq_Responses (
1339: p_api_version_number IN NUMBER,
1340: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1341: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1342: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1343:
1344: x_return_status OUT NOCOPY VARCHAR2,

Line 1341: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1337:
1338: PROCEDURE Create_Enrq_Responses (
1339: p_api_version_number IN NUMBER,
1340: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1341: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1342: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1343:
1344: x_return_status OUT NOCOPY VARCHAR2,
1345: x_msg_count OUT NOCOPY NUMBER,

Line 1342: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1338: PROCEDURE Create_Enrq_Responses (
1339: p_api_version_number IN NUMBER,
1340: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1341: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1342: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1343:
1344: x_return_status OUT NOCOPY VARCHAR2,
1345: x_msg_count OUT NOCOPY NUMBER,
1346: x_msg_data OUT NOCOPY VARCHAR2,

Line 1361: IF FND_API.to_Boolean( p_init_msg_list )

1357: BEGIN
1358:
1359:
1360: -- Initialize message list if p_init_msg_list is set to TRUE.
1361: IF FND_API.to_Boolean( p_init_msg_list )
1362: THEN
1363: FND_MSG_PUB.initialize;
1364: END IF;
1365:

Line 1367: x_return_status := FND_API.G_RET_STS_SUCCESS;

1363: FND_MSG_PUB.initialize;
1364: END IF;
1365:
1366: -- Initialize API return status to SUCCESS
1367: x_return_status := FND_API.G_RET_STS_SUCCESS;
1368:
1369: l_ge_chklst_resp_rec.arc_response_for_entity_code := 'ENRQ';
1370: l_ge_chklst_resp_rec.response_for_entity_id := p_enrollmentId;
1371: l_ge_chklst_resp_rec.response_flag := 'N';