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_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

Line 95: l_org_id NUMBER := FND_API.G_MISS_NUM;

91: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Ge_Chklst';
92: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
93: l_return_status_full VARCHAR2(1);
94: l_object_version_number NUMBER := 1;
95: l_org_id NUMBER := FND_API.G_MISS_NUM;
96: l_checklist_item_id NUMBER;
97: l_dummy NUMBER;
98: l_ge_chklst_rec ge_chklst_rec_type := p_ge_chklst_rec;
99: l_sequence_num NUMBER :=0;

Line 113: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 123: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 139: x_return_status := FND_API.G_RET_STS_SUCCESS;

135:
136:
137:
138: -- Initialize API return status to SUCCESS
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140:
141:
142: -- Local variable initialization
143:

Line 144: IF p_ge_chklst_rec.checklist_item_id IS NULL OR p_ge_chklst_rec.checklist_item_id = FND_API.g_miss_num THEN

140:
141:
142: -- Local variable initialization
143:
144: IF p_ge_chklst_rec.checklist_item_id IS NULL OR p_ge_chklst_rec.checklist_item_id = FND_API.g_miss_num THEN
145: LOOP
146: l_dummy := NULL;
147: OPEN c_id;
148: --FETCH c_id INTO l_checklist_item_id; anubhav changed to

Line 170: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 194: p_init_msg_list => FND_API.G_FALSE,

190:
191: -- Invoke validation procedures
192: Validate_ge_chklst(
193: p_api_version_number => 1.0,
194: p_init_msg_list => FND_API.G_FALSE,
195: p_validation_level => p_validation_level,
196: p_validation_mode => JTF_PLSQL_API.g_create,
197: --p_ge_chklst_rec => p_ge_chklst_rec,
198: p_ge_chklst_rec => l_ge_chklst_rec,

Line 204: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

200: x_msg_count => x_msg_count,
201: x_msg_data => x_msg_data);
202: END IF;
203:
204: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207:
208: -- Local variable initialization

Line 205: RAISE FND_API.G_EXC_ERROR;

201: x_msg_data => x_msg_data);
202: END IF;
203:
204: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207:
208: -- Local variable initialization
209:

Line 244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

240: p_checklist_item_name => p_ge_chklst_rec.checklist_item_name
241: );
242:
243: x_checklist_item_id := l_checklist_item_id;
244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247: --
248: -- End of API body

Line 245: RAISE FND_API.G_EXC_ERROR;

241: );
242:
243: x_checklist_item_id := l_checklist_item_id;
244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247: --
248: -- End of API body
249: --

Line 252: IF FND_API.to_Boolean( p_commit )

248: -- End of API body
249: --
250:
251: -- Standard check for p_commit
252: IF FND_API.to_Boolean( p_commit )
253: THEN
254: COMMIT WORK;
255: END IF;
256:

Line 273: x_return_status := FND_API.g_ret_sts_error;

269: );
270: EXCEPTION
271:
272: WHEN PVX_UTILITY_PVT.resource_locked THEN
273: x_return_status := FND_API.g_ret_sts_error;
274: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277: ROLLBACK TO CREATE_Ge_Chklst_PVT;

Line 276: WHEN FND_API.G_EXC_ERROR THEN

272: WHEN PVX_UTILITY_PVT.resource_locked THEN
273: x_return_status := FND_API.g_ret_sts_error;
274: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277: ROLLBACK TO CREATE_Ge_Chklst_PVT;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277: ROLLBACK TO CREATE_Ge_Chklst_PVT;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (
281: p_encoded => FND_API.G_FALSE,
282: p_count => x_msg_count,

Line 281: p_encoded => FND_API.G_FALSE,

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

Line 286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: ROLLBACK TO CREATE_Ge_Chklst_PVT;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: -- Standard call to get message count and if count=1, get the message
290: FND_MSG_PUB.Count_And_Get (

Line 288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

284: );
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: ROLLBACK TO CREATE_Ge_Chklst_PVT;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: -- Standard call to get message count and if count=1, get the message
290: FND_MSG_PUB.Count_And_Get (
291: p_encoded => FND_API.G_FALSE,
292: p_count => x_msg_count,

Line 291: p_encoded => FND_API.G_FALSE,

287: ROLLBACK TO CREATE_Ge_Chklst_PVT;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: -- Standard call to get message count and if count=1, get the message
290: FND_MSG_PUB.Count_And_Get (
291: p_encoded => FND_API.G_FALSE,
292: p_count => x_msg_count,
293: p_data => x_msg_data
294: );
295:

Line 298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

294: );
295:
296: WHEN OTHERS THEN
297: ROLLBACK TO CREATE_Ge_Chklst_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
302: END IF;

Line 305: p_encoded => FND_API.G_FALSE,

301: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
302: END IF;
303: -- Standard call to get message count and if count=1, get the message
304: FND_MSG_PUB.Count_And_Get (
305: p_encoded => FND_API.G_FALSE,
306: p_count => x_msg_count,
307: p_data => x_msg_data
308: );
309: End Create_Ge_Chklst;

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

317: *********************/
318: PROCEDURE Copy_Row
319: (
320: p_api_version_number IN NUMBER
321: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
322: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
323: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
324: ,x_return_status OUT NOCOPY VARCHAR2
325: ,x_msg_count OUT NOCOPY NUMBER

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

318: PROCEDURE Copy_Row
319: (
320: p_api_version_number IN NUMBER
321: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
322: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
323: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
324: ,x_return_status OUT NOCOPY VARCHAR2
325: ,x_msg_count OUT NOCOPY NUMBER
326: ,x_msg_data OUT NOCOPY VARCHAR2

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

319: (
320: p_api_version_number IN NUMBER
321: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
322: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
323: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
324: ,x_return_status OUT NOCOPY VARCHAR2
325: ,x_msg_count OUT NOCOPY NUMBER
326: ,x_msg_data OUT NOCOPY VARCHAR2
327: ,p_src_object_id IN NUMBER

Line 383: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

379: -- Standard Start of API savepoint
380: SAVEPOINT Copy_Row;
381:
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
384: p_api_version_number,
385: l_api_name,
386: G_PKG_NAME)
387: THEN

Line 388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

384: p_api_version_number,
385: l_api_name,
386: G_PKG_NAME)
387: THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390:
391:
392: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 393: IF FND_API.to_Boolean( p_init_msg_list )

389: END IF;
390:
391:
392: -- Initialize message list if p_init_msg_list is set to TRUE.
393: IF FND_API.to_Boolean( p_init_msg_list )
394: THEN
395: FND_MSG_PUB.initialize;
396: END IF;
397:

Line 405: x_return_status := FND_API.G_RET_STS_SUCCESS;

401: END IF;
402:
403:
404: -- Initialize API return status to SUCCESS
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406:
407:
408: OPEN c_get_chklst_rec (p_src_object_id);
409: LOOP

Line 521: IF FND_API.to_boolean(p_commit) THEN

517: END LOOP;
518: close c_get_chklst_tl_rec;
519:
520: -- Check for commit
521: IF FND_API.to_boolean(p_commit) THEN
522: COMMIT;
523: END IF;
524:
525: FND_MSG_PUB.count_and_get(

Line 526: p_encoded => FND_API.g_false

522: COMMIT;
523: END IF;
524:
525: FND_MSG_PUB.count_and_get(
526: p_encoded => FND_API.g_false
527: ,p_count => x_msg_count
528: ,p_data => x_msg_data
529: );
530:

Line 534: x_return_status := FND_API.g_ret_sts_error;

530:
531: EXCEPTION
532:
533: WHEN PVX_Utility_PVT.resource_locked THEN
534: x_return_status := FND_API.g_ret_sts_error;
535: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
536:
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO Copy_Row;

Line 537: WHEN FND_API.G_EXC_ERROR THEN

533: WHEN PVX_Utility_PVT.resource_locked THEN
534: x_return_status := FND_API.g_ret_sts_error;
535: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
536:
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO Copy_Row;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: -- Standard call to get message count and if count=1, get the message
541: FND_MSG_PUB.Count_And_Get (

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
536:
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO Copy_Row;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: -- Standard call to get message count and if count=1, get the message
541: FND_MSG_PUB.Count_And_Get (
542: p_encoded => FND_API.G_FALSE,
543: p_count => x_msg_count,

Line 542: p_encoded => FND_API.G_FALSE,

538: ROLLBACK TO Copy_Row;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: -- Standard call to get message count and if count=1, get the message
541: FND_MSG_PUB.Count_And_Get (
542: p_encoded => FND_API.G_FALSE,
543: p_count => x_msg_count,
544: p_data => x_msg_data
545: );
546:

Line 547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

543: p_count => x_msg_count,
544: p_data => x_msg_data
545: );
546:
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO Copy_Row;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: -- Standard call to get message count and if count=1, get the message
551: FND_MSG_PUB.Count_And_Get (

Line 549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

545: );
546:
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO Copy_Row;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: -- Standard call to get message count and if count=1, get the message
551: FND_MSG_PUB.Count_And_Get (
552: p_encoded => FND_API.G_FALSE,
553: p_count => x_msg_count,

Line 552: p_encoded => FND_API.G_FALSE,

548: ROLLBACK TO Copy_Row;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: -- Standard call to get message count and if count=1, get the message
551: FND_MSG_PUB.Count_And_Get (
552: p_encoded => FND_API.G_FALSE,
553: p_count => x_msg_count,
554: p_data => x_msg_data
555: );
556:

Line 559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

555: );
556:
557: WHEN OTHERS THEN
558: ROLLBACK TO Copy_Row;
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
561: THEN
562: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
563: END IF;

Line 566: p_encoded => FND_API.G_FALSE,

562: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
563: END IF;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_msg_count,
568: p_data => x_msg_data
569: );
570:

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

582: -- Parameters
583: --
584: -- IN
585: -- p_api_version_number IN NUMBER Required
586: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
587: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
588: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
589: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
590: --

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

583: --
584: -- IN
585: -- p_api_version_number IN NUMBER Required
586: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
587: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
588: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
589: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
590: --
591: -- OUT

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

584: -- IN
585: -- p_api_version_number IN NUMBER Required
586: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
587: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
588: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
589: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
590: --
591: -- OUT
592: -- x_return_status OUT VARCHAR2

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

604: -- ==============================================================================
605:
606: PROCEDURE Update_Ge_Chklst(
607: p_api_version_number IN NUMBER,
608: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
610: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
611:
612: x_return_status OUT NOCOPY VARCHAR2,

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

605:
606: PROCEDURE Update_Ge_Chklst(
607: p_api_version_number IN NUMBER,
608: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
610: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
611:
612: x_return_status OUT NOCOPY VARCHAR2,
613: x_msg_count OUT NOCOPY NUMBER,

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

606: PROCEDURE Update_Ge_Chklst(
607: p_api_version_number IN NUMBER,
608: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
609: p_commit IN VARCHAR2 := FND_API.G_FALSE,
610: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
611:
612: x_return_status OUT NOCOPY VARCHAR2,
613: x_msg_count OUT NOCOPY NUMBER,
614: x_msg_data OUT NOCOPY VARCHAR2,

Line 643: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

639: -- Standard Start of API savepoint
640: SAVEPOINT update_ge_chklst_pvt;
641:
642: -- Standard call to check for call compatibility.
643: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
644: p_api_version_number,
645: l_api_name,
646: G_PKG_NAME)
647: THEN

Line 648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

644: p_api_version_number,
645: l_api_name,
646: G_PKG_NAME)
647: THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650:
651:
652: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 653: IF FND_API.to_Boolean( p_init_msg_list )

649: END IF;
650:
651:
652: -- Initialize message list if p_init_msg_list is set to TRUE.
653: IF FND_API.to_Boolean( p_init_msg_list )
654: THEN
655: FND_MSG_PUB.initialize;
656: END IF;
657:

Line 669: x_return_status := FND_API.G_RET_STS_SUCCESS;

665:
666:
667:
668: -- Initialize API return status to SUCCESS
669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: -- Debug Message
672: IF (PV_DEBUG_HIGH_ON) THEN
673:

Line 685: RAISE FND_API.G_EXC_ERROR;

681: If ( c_get_Ge_Chklst%NOTFOUND) THEN
682: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
683: p_token_name => 'INFO',
684: p_token_value => 'Ge_Chklst') ;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687: -- Debug Message
688: IF (PV_DEBUG_HIGH_ON) THEN
689:

Line 696: l_tar_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM ) Then

692: CLOSE c_get_Ge_Chklst;
693:
694:
695: If (l_tar_ge_chklst_rec.object_version_number is NULL or
696: l_tar_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM ) Then
697: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
698: p_token_name => 'COLUMN',
699: p_token_value => 'Last_Update_Date') ;
700: raise FND_API.G_EXC_ERROR;

Line 700: raise FND_API.G_EXC_ERROR;

696: l_tar_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM ) Then
697: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
698: p_token_name => 'COLUMN',
699: p_token_value => 'Last_Update_Date') ;
700: raise FND_API.G_EXC_ERROR;
701: End if;
702: -- Check Whether record has been changed by someone else
703: If (l_tar_ge_chklst_rec.object_version_number <> l_ref_ge_chklst_rec.object_version_number) Then
704: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 707: raise FND_API.G_EXC_ERROR;

703: If (l_tar_ge_chklst_rec.object_version_number <> l_ref_ge_chklst_rec.object_version_number) Then
704: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
705: p_token_name => 'INFO',
706: p_token_value => 'Ge_Chklst') ;
707: raise FND_API.G_EXC_ERROR;
708: End if;
709:
710:
711: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

707: raise FND_API.G_EXC_ERROR;
708: End if;
709:
710:
711: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
712: THEN
713: -- Debug message
714: IF (PV_DEBUG_HIGH_ON) THEN
715:

Line 722: p_init_msg_list => FND_API.G_FALSE,

718:
719: -- Invoke validation procedures
720: Validate_ge_chklst(
721: p_api_version_number => 1.0,
722: p_init_msg_list => FND_API.G_FALSE,
723: p_validation_level => p_validation_level,
724: p_validation_mode => JTF_PLSQL_API.g_update,
725: p_ge_chklst_rec => p_ge_chklst_rec,
726: x_return_status => x_return_status,

Line 731: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

727: x_msg_count => x_msg_count,
728: x_msg_data => x_msg_data);
729: END IF;
730:
731: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
732: RAISE FND_API.G_EXC_ERROR;
733: END IF;
734:
735:

Line 732: RAISE FND_API.G_EXC_ERROR;

728: x_msg_data => x_msg_data);
729: END IF;
730:
731: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
732: RAISE FND_API.G_EXC_ERROR;
733: END IF;
734:
735:
736: -- Debug Message

Line 758: IF FND_API.to_Boolean( p_commit )

754: -- End of API body.
755: --
756:
757: -- Standard check for p_commit
758: IF FND_API.to_Boolean( p_commit )
759: THEN
760: COMMIT WORK;
761: END IF;
762:

Line 779: x_return_status := FND_API.g_ret_sts_error;

775: );
776: EXCEPTION
777:
778: WHEN PVX_UTILITY_PVT.resource_locked THEN
779: x_return_status := FND_API.g_ret_sts_error;
780: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
781:
782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO UPDATE_Ge_Chklst_PVT;

Line 782: WHEN FND_API.G_EXC_ERROR THEN

778: WHEN PVX_UTILITY_PVT.resource_locked THEN
779: x_return_status := FND_API.g_ret_sts_error;
780: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
781:
782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
784: x_return_status := FND_API.G_RET_STS_ERROR;
785: -- Standard call to get message count and if count=1, get the message
786: FND_MSG_PUB.Count_And_Get (

Line 784: x_return_status := FND_API.G_RET_STS_ERROR;

780: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
781:
782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
784: x_return_status := FND_API.G_RET_STS_ERROR;
785: -- Standard call to get message count and if count=1, get the message
786: FND_MSG_PUB.Count_And_Get (
787: p_encoded => FND_API.G_FALSE,
788: p_count => x_msg_count,

Line 787: p_encoded => FND_API.G_FALSE,

783: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
784: x_return_status := FND_API.G_RET_STS_ERROR;
785: -- Standard call to get message count and if count=1, get the message
786: FND_MSG_PUB.Count_And_Get (
787: p_encoded => FND_API.G_FALSE,
788: p_count => x_msg_count,
789: p_data => x_msg_data
790: );
791:

Line 792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

788: p_count => x_msg_count,
789: p_data => x_msg_data
790: );
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: -- Standard call to get message count and if count=1, get the message
796: FND_MSG_PUB.Count_And_Get (

Line 794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

790: );
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: -- Standard call to get message count and if count=1, get the message
796: FND_MSG_PUB.Count_And_Get (
797: p_encoded => FND_API.G_FALSE,
798: p_count => x_msg_count,

Line 797: p_encoded => FND_API.G_FALSE,

793: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: -- Standard call to get message count and if count=1, get the message
796: FND_MSG_PUB.Count_And_Get (
797: p_encoded => FND_API.G_FALSE,
798: p_count => x_msg_count,
799: p_data => x_msg_data
800: );
801:

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

800: );
801:
802: WHEN OTHERS THEN
803: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
808: END IF;

Line 811: p_encoded => FND_API.G_FALSE,

807: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
808: END IF;
809: -- Standard call to get message count and if count=1, get the message
810: FND_MSG_PUB.Count_And_Get (
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data
814: );
815: End Update_Ge_Chklst;

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

827: -- Parameters
828: --
829: -- IN
830: -- p_api_version_number IN NUMBER Required
831: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
832: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
833: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
834: -- p_checklist_item_id IN NUMBER
835: -- p_object_version_number IN NUMBER Optional Default = NULL

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

828: --
829: -- IN
830: -- p_api_version_number IN NUMBER Required
831: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
832: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
833: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
834: -- p_checklist_item_id IN NUMBER
835: -- p_object_version_number IN NUMBER Optional Default = NULL
836: --

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

829: -- IN
830: -- p_api_version_number IN NUMBER Required
831: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
832: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
833: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
834: -- p_checklist_item_id IN NUMBER
835: -- p_object_version_number IN NUMBER Optional Default = NULL
836: --
837: -- OUT

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

850: -- ==============================================================================
851:
852: PROCEDURE Delete_Ge_Chklst(
853: p_api_version_number IN NUMBER,
854: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
855: p_commit IN VARCHAR2 := FND_API.G_FALSE,
856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_msg_count OUT NOCOPY NUMBER,

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

851:
852: PROCEDURE Delete_Ge_Chklst(
853: p_api_version_number IN NUMBER,
854: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
855: p_commit IN VARCHAR2 := FND_API.G_FALSE,
856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_msg_count OUT NOCOPY NUMBER,
859: x_msg_data OUT NOCOPY VARCHAR2,

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

852: PROCEDURE Delete_Ge_Chklst(
853: p_api_version_number IN NUMBER,
854: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
855: p_commit IN VARCHAR2 := FND_API.G_FALSE,
856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_msg_count OUT NOCOPY NUMBER,
859: x_msg_data OUT NOCOPY VARCHAR2,
860: p_checklist_item_id IN NUMBER,

Line 874: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

870: -- Standard Start of API savepoint
871: SAVEPOINT delete_ge_chklst_pvt;
872:
873: -- Standard call to check for call compatibility.
874: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
875: p_api_version_number,
876: l_api_name,
877: G_PKG_NAME)
878: THEN

Line 879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

875: p_api_version_number,
876: l_api_name,
877: G_PKG_NAME)
878: THEN
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
880: END IF;
881:
882:
883: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 884: IF FND_API.to_Boolean( p_init_msg_list )

880: END IF;
881:
882:
883: -- Initialize message list if p_init_msg_list is set to TRUE.
884: IF FND_API.to_Boolean( p_init_msg_list )
885: THEN
886: FND_MSG_PUB.initialize;
887: END IF;
888:

Line 900: x_return_status := FND_API.G_RET_STS_SUCCESS;

896:
897:
898:
899: -- Initialize API return status to SUCCESS
900: x_return_status := FND_API.G_RET_STS_SUCCESS;
901:
902: --
903: -- Api body
904: --

Line 920: IF FND_API.to_Boolean( p_commit )

916: -- End of API body
917: --
918:
919: -- Standard check for p_commit
920: IF FND_API.to_Boolean( p_commit )
921: THEN
922: COMMIT WORK;
923: END IF;
924:

Line 941: x_return_status := FND_API.g_ret_sts_error;

937: );
938: EXCEPTION
939:
940: WHEN PVX_UTILITY_PVT.resource_locked THEN
941: x_return_status := FND_API.g_ret_sts_error;
942: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
943:
944: WHEN FND_API.G_EXC_ERROR THEN
945: ROLLBACK TO DELETE_Ge_Chklst_PVT;

Line 944: WHEN FND_API.G_EXC_ERROR THEN

940: WHEN PVX_UTILITY_PVT.resource_locked THEN
941: x_return_status := FND_API.g_ret_sts_error;
942: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
943:
944: WHEN FND_API.G_EXC_ERROR THEN
945: ROLLBACK TO DELETE_Ge_Chklst_PVT;
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: -- Standard call to get message count and if count=1, get the message
948: FND_MSG_PUB.Count_And_Get (

Line 946: x_return_status := FND_API.G_RET_STS_ERROR;

942: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
943:
944: WHEN FND_API.G_EXC_ERROR THEN
945: ROLLBACK TO DELETE_Ge_Chklst_PVT;
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: -- Standard call to get message count and if count=1, get the message
948: FND_MSG_PUB.Count_And_Get (
949: p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,

Line 949: p_encoded => FND_API.G_FALSE,

945: ROLLBACK TO DELETE_Ge_Chklst_PVT;
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: -- Standard call to get message count and if count=1, get the message
948: FND_MSG_PUB.Count_And_Get (
949: p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,
951: p_data => x_msg_data
952: );
953:

Line 954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

950: p_count => x_msg_count,
951: p_data => x_msg_data
952: );
953:
954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
955: ROLLBACK TO DELETE_Ge_Chklst_PVT;
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: -- Standard call to get message count and if count=1, get the message
958: FND_MSG_PUB.Count_And_Get (

Line 956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

952: );
953:
954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
955: ROLLBACK TO DELETE_Ge_Chklst_PVT;
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: -- Standard call to get message count and if count=1, get the message
958: FND_MSG_PUB.Count_And_Get (
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,

Line 959: p_encoded => FND_API.G_FALSE,

955: ROLLBACK TO DELETE_Ge_Chklst_PVT;
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: -- Standard call to get message count and if count=1, get the message
958: FND_MSG_PUB.Count_And_Get (
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,
961: p_data => x_msg_data
962: );
963:

Line 966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

962: );
963:
964: WHEN OTHERS THEN
965: ROLLBACK TO DELETE_Ge_Chklst_PVT;
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
968: THEN
969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
970: END IF;

Line 973: p_encoded => FND_API.G_FALSE,

969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
970: END IF;
971: -- Standard call to get message count and if count=1, get the message
972: FND_MSG_PUB.Count_And_Get (
973: p_encoded => FND_API.G_FALSE,
974: p_count => x_msg_count,
975: p_data => x_msg_data
976: );
977: End Delete_Ge_Chklst;

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

991: -- Parameters
992: --
993: -- IN
994: -- p_api_version_number IN NUMBER Required
995: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
996: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
997: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
998: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
999: --

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

992: --
993: -- IN
994: -- p_api_version_number IN NUMBER Required
995: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
996: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
997: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
998: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
999: --
1000: -- OUT

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

993: -- IN
994: -- p_api_version_number IN NUMBER Required
995: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
996: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
997: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
998: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
999: --
1000: -- OUT
1001: -- x_return_status OUT VARCHAR2

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

1013: -- ==============================================================================
1014:
1015: PROCEDURE Lock_Ge_Chklst(
1016: p_api_version_number IN NUMBER,
1017: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1018:
1019: x_return_status OUT NOCOPY VARCHAR2,
1020: x_msg_count OUT NOCOPY NUMBER,
1021: x_msg_data OUT NOCOPY VARCHAR2,

Line 1043: IF FND_API.to_Boolean( p_init_msg_list )

1039: END IF;
1040:
1041:
1042: -- Initialize message list if p_init_msg_list is set to TRUE.
1043: IF FND_API.to_Boolean( p_init_msg_list )
1044: THEN
1045: FND_MSG_PUB.initialize;
1046: END IF;
1047:

Line 1051: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1047:
1048:
1049:
1050: -- Standard call to check for call compatibility.
1051: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1052: p_api_version_number,
1053: l_api_name,
1054: G_PKG_NAME)
1055: THEN

Line 1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1052: p_api_version_number,
1053: l_api_name,
1054: G_PKG_NAME)
1055: THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: END IF;
1058:
1059:
1060:

Line 1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

1058:
1059:
1060:
1061: -- Initialize API return status to SUCCESS
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063:
1064:
1065: ------------------------ lock -------------------------
1066: Pv_Ge_Chklst_Pkg.Lock_Row(l_checklist_item_id,p_object_version);

Line 1071: p_encoded => FND_API.g_false,

1067:
1068:
1069: -------------------- finish --------------------------
1070: FND_MSG_PUB.count_and_get(
1071: p_encoded => FND_API.g_false,
1072: p_count => x_msg_count,
1073: p_data => x_msg_data);
1074: IF (PV_DEBUG_HIGH_ON) THEN
1075:

Line 1081: x_return_status := FND_API.g_ret_sts_error;

1077: END IF;
1078: EXCEPTION
1079:
1080: WHEN PVX_UTILITY_PVT.resource_locked THEN
1081: x_return_status := FND_API.g_ret_sts_error;
1082: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO LOCK_Ge_Chklst_PVT;

Line 1084: WHEN FND_API.G_EXC_ERROR THEN

1080: WHEN PVX_UTILITY_PVT.resource_locked THEN
1081: x_return_status := FND_API.g_ret_sts_error;
1082: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: -- Standard call to get message count and if count=1, get the message
1088: FND_MSG_PUB.Count_And_Get (

Line 1086: x_return_status := FND_API.G_RET_STS_ERROR;

1082: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: -- Standard call to get message count and if count=1, get the message
1088: FND_MSG_PUB.Count_And_Get (
1089: p_encoded => FND_API.G_FALSE,
1090: p_count => x_msg_count,

Line 1089: p_encoded => FND_API.G_FALSE,

1085: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: -- Standard call to get message count and if count=1, get the message
1088: FND_MSG_PUB.Count_And_Get (
1089: p_encoded => FND_API.G_FALSE,
1090: p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1093:

Line 1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1090: p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1093:
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: -- Standard call to get message count and if count=1, get the message
1098: FND_MSG_PUB.Count_And_Get (

Line 1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1092: );
1093:
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: -- Standard call to get message count and if count=1, get the message
1098: FND_MSG_PUB.Count_And_Get (
1099: p_encoded => FND_API.G_FALSE,
1100: p_count => x_msg_count,

Line 1099: p_encoded => FND_API.G_FALSE,

1095: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: -- Standard call to get message count and if count=1, get the message
1098: FND_MSG_PUB.Count_And_Get (
1099: p_encoded => FND_API.G_FALSE,
1100: p_count => x_msg_count,
1101: p_data => x_msg_data
1102: );
1103:

Line 1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1102: );
1103:
1104: WHEN OTHERS THEN
1105: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1108: THEN
1109: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1110: END IF;

Line 1113: p_encoded => FND_API.G_FALSE,

1109: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1110: END IF;
1111: -- Standard call to get message count and if count=1, get the message
1112: FND_MSG_PUB.Count_And_Get (
1113: p_encoded => FND_API.G_FALSE,
1114: p_count => x_msg_count,
1115: p_data => x_msg_data
1116: );
1117: End Lock_Ge_Chklst;

Line 1130: x_return_status := FND_API.g_ret_sts_success;

1126: IS
1127: l_valid_flag VARCHAR2(1);
1128:
1129: BEGIN
1130: x_return_status := FND_API.g_ret_sts_success;
1131: IF p_validation_mode = JTF_PLSQL_API.g_create
1132: AND p_ge_chklst_rec.checklist_item_id IS NOT NULL
1133: THEN
1134: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

Line 1140: IF l_valid_flag = FND_API.g_false THEN

1136: 'checklist_item_id = ''' || p_ge_chklst_rec.checklist_item_id ||''''
1137: );
1138: END IF;
1139:
1140: IF l_valid_flag = FND_API.g_false THEN
1141: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_checklist_item_id_DUPLICATE');
1142: x_return_status := FND_API.g_ret_sts_error;
1143: END IF;
1144:

Line 1142: x_return_status := FND_API.g_ret_sts_error;

1138: END IF;
1139:
1140: IF l_valid_flag = FND_API.g_false THEN
1141: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_checklist_item_id_DUPLICATE');
1142: x_return_status := FND_API.g_ret_sts_error;
1143: END IF;
1144:
1145: END check_Ge_Chklst_Uk_Items;
1146:

Line 1156: x_return_status := FND_API.g_ret_sts_success;

1152: x_return_status OUT NOCOPY VARCHAR2
1153: )
1154: IS
1155: BEGIN
1156: x_return_status := FND_API.g_ret_sts_success;
1157:
1158: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1159:
1160:

Line 1161: IF p_ge_chklst_rec.checklist_item_id = FND_API.G_MISS_NUM OR p_ge_chklst_rec.checklist_item_id IS NULL THEN

1157:
1158: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1159:
1160:
1161: IF p_ge_chklst_rec.checklist_item_id = FND_API.G_MISS_NUM OR p_ge_chklst_rec.checklist_item_id IS NULL THEN
1162: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
1163: x_return_status := FND_API.g_ret_sts_error;
1164: END IF;
1165:

Line 1163: x_return_status := FND_API.g_ret_sts_error;

1159:
1160:
1161: IF p_ge_chklst_rec.checklist_item_id = FND_API.G_MISS_NUM OR p_ge_chklst_rec.checklist_item_id IS NULL THEN
1162: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
1163: x_return_status := FND_API.g_ret_sts_error;
1164: END IF;
1165:
1166:
1167: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_rec.object_version_number IS NULL THEN

Line 1167: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_rec.object_version_number IS NULL THEN

1163: x_return_status := FND_API.g_ret_sts_error;
1164: END IF;
1165:
1166:
1167: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_rec.object_version_number IS NULL THEN
1168: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
1169: x_return_status := FND_API.g_ret_sts_error;
1170: END IF;
1171:

Line 1169: x_return_status := FND_API.g_ret_sts_error;

1165:
1166:
1167: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_rec.object_version_number IS NULL THEN
1168: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
1169: x_return_status := FND_API.g_ret_sts_error;
1170: END IF;
1171:
1172:
1173: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char OR p_ge_chklst_rec.arc_used_by_entity_code IS NULL THEN

Line 1173: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char OR p_ge_chklst_rec.arc_used_by_entity_code IS NULL THEN

1169: x_return_status := FND_API.g_ret_sts_error;
1170: END IF;
1171:
1172:
1173: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char OR p_ge_chklst_rec.arc_used_by_entity_code IS NULL THEN
1174: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_USED_BY_ENTITY_CODE' );
1175: x_return_status := FND_API.g_ret_sts_error;
1176: END IF;
1177:

Line 1175: x_return_status := FND_API.g_ret_sts_error;

1171:
1172:
1173: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char OR p_ge_chklst_rec.arc_used_by_entity_code IS NULL THEN
1174: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_USED_BY_ENTITY_CODE' );
1175: x_return_status := FND_API.g_ret_sts_error;
1176: END IF;
1177:
1178:
1179: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_rec.used_by_entity_id IS NULL THEN

Line 1179: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_rec.used_by_entity_id IS NULL THEN

1175: x_return_status := FND_API.g_ret_sts_error;
1176: END IF;
1177:
1178:
1179: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_rec.used_by_entity_id IS NULL THEN
1180: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USED_BY_ENTITY_ID' );
1181: x_return_status := FND_API.g_ret_sts_error;
1182: END IF;
1183:

Line 1181: x_return_status := FND_API.g_ret_sts_error;

1177:
1178:
1179: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_rec.used_by_entity_id IS NULL THEN
1180: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USED_BY_ENTITY_ID' );
1181: x_return_status := FND_API.g_ret_sts_error;
1182: END IF;
1183:
1184:
1185: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM OR p_ge_chklst_rec.sequence_num IS NULL THEN

Line 1185: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM OR p_ge_chklst_rec.sequence_num IS NULL THEN

1181: x_return_status := FND_API.g_ret_sts_error;
1182: END IF;
1183:
1184:
1185: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM OR p_ge_chklst_rec.sequence_num IS NULL THEN
1186: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
1187: x_return_status := FND_API.g_ret_sts_error;
1188: END IF;
1189:

Line 1187: x_return_status := FND_API.g_ret_sts_error;

1183:
1184:
1185: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM OR p_ge_chklst_rec.sequence_num IS NULL THEN
1186: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
1187: x_return_status := FND_API.g_ret_sts_error;
1188: END IF;
1189:
1190:
1191: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char OR p_ge_chklst_rec.is_required_flag IS NULL THEN

Line 1191: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char OR p_ge_chklst_rec.is_required_flag IS NULL THEN

1187: x_return_status := FND_API.g_ret_sts_error;
1188: END IF;
1189:
1190:
1191: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char OR p_ge_chklst_rec.is_required_flag IS NULL THEN
1192: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'IS_REQUIRED_FLAG' );
1193: x_return_status := FND_API.g_ret_sts_error;
1194: END IF;
1195:

Line 1193: x_return_status := FND_API.g_ret_sts_error;

1189:
1190:
1191: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char OR p_ge_chklst_rec.is_required_flag IS NULL THEN
1192: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'IS_REQUIRED_FLAG' );
1193: x_return_status := FND_API.g_ret_sts_error;
1194: END IF;
1195:
1196:
1197: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char OR p_ge_chklst_rec.enabled_flag IS NULL THEN

Line 1197: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char OR p_ge_chklst_rec.enabled_flag IS NULL THEN

1193: x_return_status := FND_API.g_ret_sts_error;
1194: END IF;
1195:
1196:
1197: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char OR p_ge_chklst_rec.enabled_flag IS NULL THEN
1198: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENABLED_FLAG' );
1199: x_return_status := FND_API.g_ret_sts_error;
1200: END IF;
1201:

Line 1199: x_return_status := FND_API.g_ret_sts_error;

1195:
1196:
1197: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char OR p_ge_chklst_rec.enabled_flag IS NULL THEN
1198: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENABLED_FLAG' );
1199: x_return_status := FND_API.g_ret_sts_error;
1200: END IF;
1201:
1202:
1203: ELSE

Line 1206: IF p_ge_chklst_rec.checklist_item_id = FND_API.G_MISS_NUM THEN

1202:
1203: ELSE
1204:
1205:
1206: IF p_ge_chklst_rec.checklist_item_id = FND_API.G_MISS_NUM THEN
1207: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
1208: x_return_status := FND_API.g_ret_sts_error;
1209: END IF;
1210:

Line 1208: x_return_status := FND_API.g_ret_sts_error;

1204:
1205:
1206: IF p_ge_chklst_rec.checklist_item_id = FND_API.G_MISS_NUM THEN
1207: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
1208: x_return_status := FND_API.g_ret_sts_error;
1209: END IF;
1210:
1211:
1212: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 1212: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM THEN

1208: x_return_status := FND_API.g_ret_sts_error;
1209: END IF;
1210:
1211:
1212: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM THEN
1213: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
1214: x_return_status := FND_API.g_ret_sts_error;
1215: END IF;
1216:

Line 1214: x_return_status := FND_API.g_ret_sts_error;

1210:
1211:
1212: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM THEN
1213: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
1214: x_return_status := FND_API.g_ret_sts_error;
1215: END IF;
1216:
1217:
1218: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char THEN

Line 1218: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char THEN

1214: x_return_status := FND_API.g_ret_sts_error;
1215: END IF;
1216:
1217:
1218: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char THEN
1219: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_USED_BY_ENTITY_CODE' );
1220: x_return_status := FND_API.g_ret_sts_error;
1221: END IF;
1222:

Line 1220: x_return_status := FND_API.g_ret_sts_error;

1216:
1217:
1218: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char THEN
1219: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_USED_BY_ENTITY_CODE' );
1220: x_return_status := FND_API.g_ret_sts_error;
1221: END IF;
1222:
1223:
1224: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM THEN

Line 1224: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM THEN

1220: x_return_status := FND_API.g_ret_sts_error;
1221: END IF;
1222:
1223:
1224: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM THEN
1225: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USED_BY_ENTITY_ID' );
1226: x_return_status := FND_API.g_ret_sts_error;
1227: END IF;
1228:

Line 1226: x_return_status := FND_API.g_ret_sts_error;

1222:
1223:
1224: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM THEN
1225: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USED_BY_ENTITY_ID' );
1226: x_return_status := FND_API.g_ret_sts_error;
1227: END IF;
1228:
1229:
1230: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM THEN

Line 1230: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM THEN

1226: x_return_status := FND_API.g_ret_sts_error;
1227: END IF;
1228:
1229:
1230: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM THEN
1231: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
1232: x_return_status := FND_API.g_ret_sts_error;
1233: END IF;
1234:

Line 1232: x_return_status := FND_API.g_ret_sts_error;

1228:
1229:
1230: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM THEN
1231: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
1232: x_return_status := FND_API.g_ret_sts_error;
1233: END IF;
1234:
1235:
1236: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char THEN

Line 1236: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char THEN

1232: x_return_status := FND_API.g_ret_sts_error;
1233: END IF;
1234:
1235:
1236: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char THEN
1237: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'IS_REQUIRED_FLAG' );
1238: x_return_status := FND_API.g_ret_sts_error;
1239: END IF;
1240:

Line 1238: x_return_status := FND_API.g_ret_sts_error;

1234:
1235:
1236: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char THEN
1237: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'IS_REQUIRED_FLAG' );
1238: x_return_status := FND_API.g_ret_sts_error;
1239: END IF;
1240:
1241:
1242: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char THEN

Line 1242: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char THEN

1238: x_return_status := FND_API.g_ret_sts_error;
1239: END IF;
1240:
1241:
1242: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char THEN
1243: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENABLED_FLAG' );
1244: x_return_status := FND_API.g_ret_sts_error;
1245: END IF;
1246: END IF;

Line 1244: x_return_status := FND_API.g_ret_sts_error;

1240:
1241:
1242: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char THEN
1243: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENABLED_FLAG' );
1244: x_return_status := FND_API.g_ret_sts_error;
1245: END IF;
1246: END IF;
1247:
1248: END check_Ge_Chklst_Req_Items;

Line 1258: x_return_status := FND_API.g_ret_sts_success;

1254: x_return_status OUT NOCOPY VARCHAR2
1255: )
1256: IS
1257: BEGIN
1258: x_return_status := FND_API.g_ret_sts_success;
1259:
1260: -- Enter custom code here
1261:
1262: END check_Ge_Chklst_Fk_Items;

Line 1272: x_return_status := FND_API.g_ret_sts_success;

1268: x_return_status OUT NOCOPY VARCHAR2
1269: )
1270: IS
1271: BEGIN
1272: x_return_status := FND_API.g_ret_sts_success;
1273:
1274: -- Enter custom code here
1275:
1276: END check_Ge_Chklst_Lookup_Items;

Line 1289: l_return_status := FND_API.g_ret_sts_success;

1285: IS
1286: l_return_status VARCHAR2(1);
1287: BEGIN
1288:
1289: l_return_status := FND_API.g_ret_sts_success;
1290: -- Check Items Uniqueness API calls
1291:
1292: check_Ge_chklst_Uk_Items(
1293: p_ge_chklst_rec => p_ge_chklst_rec,

Line 1296: IF x_return_status <> FND_API.g_ret_sts_success THEN

1292: check_Ge_chklst_Uk_Items(
1293: p_ge_chklst_rec => p_ge_chklst_rec,
1294: p_validation_mode => p_validation_mode,
1295: x_return_status => x_return_status);
1296: IF x_return_status <> FND_API.g_ret_sts_success THEN
1297: l_return_status := FND_API.g_ret_sts_error;
1298: END IF;
1299:
1300: -- Check Items Required/NOT NULL API calls

Line 1297: l_return_status := FND_API.g_ret_sts_error;

1293: p_ge_chklst_rec => p_ge_chklst_rec,
1294: p_validation_mode => p_validation_mode,
1295: x_return_status => x_return_status);
1296: IF x_return_status <> FND_API.g_ret_sts_success THEN
1297: l_return_status := FND_API.g_ret_sts_error;
1298: END IF;
1299:
1300: -- Check Items Required/NOT NULL API calls
1301:

Line 1306: IF x_return_status <> FND_API.g_ret_sts_success THEN

1302: check_ge_chklst_req_items(
1303: p_ge_chklst_rec => p_ge_chklst_rec,
1304: p_validation_mode => p_validation_mode,
1305: x_return_status => x_return_status);
1306: IF x_return_status <> FND_API.g_ret_sts_success THEN
1307: l_return_status := FND_API.g_ret_sts_error;
1308: END IF;
1309: -- Check Items Foreign Keys API calls
1310:

Line 1307: l_return_status := FND_API.g_ret_sts_error;

1303: p_ge_chklst_rec => p_ge_chklst_rec,
1304: p_validation_mode => p_validation_mode,
1305: x_return_status => x_return_status);
1306: IF x_return_status <> FND_API.g_ret_sts_success THEN
1307: l_return_status := FND_API.g_ret_sts_error;
1308: END IF;
1309: -- Check Items Foreign Keys API calls
1310:
1311: check_ge_chklst_FK_items(

Line 1314: IF x_return_status <> FND_API.g_ret_sts_success THEN

1310:
1311: check_ge_chklst_FK_items(
1312: p_ge_chklst_rec => p_ge_chklst_rec,
1313: x_return_status => x_return_status);
1314: IF x_return_status <> FND_API.g_ret_sts_success THEN
1315: l_return_status := FND_API.g_ret_sts_error;
1316: END IF;
1317: -- Check Items Lookups
1318:

Line 1315: l_return_status := FND_API.g_ret_sts_error;

1311: check_ge_chklst_FK_items(
1312: p_ge_chklst_rec => p_ge_chklst_rec,
1313: x_return_status => x_return_status);
1314: IF x_return_status <> FND_API.g_ret_sts_success THEN
1315: l_return_status := FND_API.g_ret_sts_error;
1316: END IF;
1317: -- Check Items Lookups
1318:
1319: check_ge_chklst_Lookup_items(

Line 1322: IF x_return_status <> FND_API.g_ret_sts_success THEN

1318:
1319: check_ge_chklst_Lookup_items(
1320: p_ge_chklst_rec => p_ge_chklst_rec,
1321: x_return_status => x_return_status);
1322: IF x_return_status <> FND_API.g_ret_sts_success THEN
1323: l_return_status := FND_API.g_ret_sts_error;
1324: END IF;
1325:
1326: x_return_status := l_return_status;

Line 1323: l_return_status := FND_API.g_ret_sts_error;

1319: check_ge_chklst_Lookup_items(
1320: p_ge_chklst_rec => p_ge_chklst_rec,
1321: x_return_status => x_return_status);
1322: IF x_return_status <> FND_API.g_ret_sts_success THEN
1323: l_return_status := FND_API.g_ret_sts_error;
1324: END IF;
1325:
1326: x_return_status := l_return_status;
1327:

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

1422: l_ge_chklst_rec ge_chklst_rec_type := p_ge_chklst_rec;
1423: BEGIN
1424: -- Developers should put their code to default the record type
1425: -- e.g. IF p_campaign_rec.status_code IS NULL
1426: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1427: -- l_campaign_rec.status_code := 'NEW' ;
1428: -- END IF ;
1429: --
1430: NULL ;

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

1434:
1435:
1436: PROCEDURE Validate_Ge_Chklst(
1437: p_api_version_number IN NUMBER,
1438: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1439: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1440: p_ge_chklst_rec IN ge_chklst_rec_type,
1441: p_validation_mode IN VARCHAR2,
1442: x_return_status OUT NOCOPY VARCHAR2,

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

1435:
1436: PROCEDURE Validate_Ge_Chklst(
1437: p_api_version_number IN NUMBER,
1438: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1439: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1440: p_ge_chklst_rec IN ge_chklst_rec_type,
1441: p_validation_mode IN VARCHAR2,
1442: x_return_status OUT NOCOPY VARCHAR2,
1443: x_msg_count OUT NOCOPY NUMBER,

Line 1458: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1454: -- Standard Start of API savepoint
1455: SAVEPOINT validate_ge_chklst_;
1456:
1457: -- Standard call to check for call compatibility.
1458: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1459: p_api_version_number,
1460: l_api_name,
1461: G_PKG_NAME)
1462: THEN

Line 1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1459: p_api_version_number,
1460: l_api_name,
1461: G_PKG_NAME)
1462: THEN
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464: END IF;
1465:
1466:
1467: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1468: IF FND_API.to_Boolean( p_init_msg_list )

1464: END IF;
1465:
1466:
1467: -- Initialize message list if p_init_msg_list is set to TRUE.
1468: IF FND_API.to_Boolean( p_init_msg_list )
1469: THEN
1470: FND_MSG_PUB.initialize;
1471: END IF;
1472:

Line 1481: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1477: p_validation_mode => p_validation_mode,
1478: x_return_status => x_return_status
1479: );
1480:
1481: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: END IF;

Line 1482: RAISE FND_API.G_EXC_ERROR;

1478: x_return_status => x_return_status
1479: );
1480:
1481: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: END IF;
1486: END IF;

Line 1483: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1479: );
1480:
1481: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: END IF;
1486: END IF;
1487:

Line 1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1480:
1481: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: END IF;
1486: END IF;
1487:
1488: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1504: p_init_msg_list => FND_API.G_FALSE,

1500:
1501: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1502: Validate_ge_chklst_Rec(
1503: p_api_version_number => 1.0,
1504: p_init_msg_list => FND_API.G_FALSE,
1505: x_return_status => x_return_status,
1506: x_msg_count => x_msg_count,
1507: x_msg_data => x_msg_data,
1508: p_ge_chklst_rec => l_ge_chklst_rec);

Line 1510: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1506: x_msg_count => x_msg_count,
1507: x_msg_data => x_msg_data,
1508: p_ge_chklst_rec => l_ge_chklst_rec);
1509:
1510: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: END IF;

Line 1511: RAISE FND_API.G_EXC_ERROR;

1507: x_msg_data => x_msg_data,
1508: p_ge_chklst_rec => l_ge_chklst_rec);
1509:
1510: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: END IF;
1515: END IF;

Line 1512: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1508: p_ge_chklst_rec => l_ge_chklst_rec);
1509:
1510: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: END IF;
1515: END IF;
1516:

Line 1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1509:
1510: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: END IF;
1515: END IF;
1516:
1517:

Line 1527: x_return_status := FND_API.G_RET_STS_SUCCESS;

1523:
1524:
1525:
1526: -- Initialize API return status to SUCCESS
1527: x_return_status := FND_API.G_RET_STS_SUCCESS;
1528:
1529:
1530: -- Debug Message
1531: IF (PV_DEBUG_HIGH_ON) THEN

Line 1545: x_return_status := FND_API.g_ret_sts_error;

1541: );
1542: EXCEPTION
1543:
1544: WHEN PVX_UTILITY_PVT.resource_locked THEN
1545: x_return_status := FND_API.g_ret_sts_error;
1546: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1547:
1548: WHEN FND_API.G_EXC_ERROR THEN
1549: ROLLBACK TO VALIDATE_Ge_Chklst_;

Line 1548: WHEN FND_API.G_EXC_ERROR THEN

1544: WHEN PVX_UTILITY_PVT.resource_locked THEN
1545: x_return_status := FND_API.g_ret_sts_error;
1546: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1547:
1548: WHEN FND_API.G_EXC_ERROR THEN
1549: ROLLBACK TO VALIDATE_Ge_Chklst_;
1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: -- Standard call to get message count and if count=1, get the message
1552: FND_MSG_PUB.Count_And_Get (

Line 1550: x_return_status := FND_API.G_RET_STS_ERROR;

1546: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1547:
1548: WHEN FND_API.G_EXC_ERROR THEN
1549: ROLLBACK TO VALIDATE_Ge_Chklst_;
1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: -- Standard call to get message count and if count=1, get the message
1552: FND_MSG_PUB.Count_And_Get (
1553: p_encoded => FND_API.G_FALSE,
1554: p_count => x_msg_count,

Line 1553: p_encoded => FND_API.G_FALSE,

1549: ROLLBACK TO VALIDATE_Ge_Chklst_;
1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: -- Standard call to get message count and if count=1, get the message
1552: FND_MSG_PUB.Count_And_Get (
1553: p_encoded => FND_API.G_FALSE,
1554: p_count => x_msg_count,
1555: p_data => x_msg_data
1556: );
1557:

Line 1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1554: p_count => x_msg_count,
1555: p_data => x_msg_data
1556: );
1557:
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: ROLLBACK TO VALIDATE_Ge_Chklst_;
1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1561: -- Standard call to get message count and if count=1, get the message
1562: FND_MSG_PUB.Count_And_Get (

Line 1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1556: );
1557:
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: ROLLBACK TO VALIDATE_Ge_Chklst_;
1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1561: -- Standard call to get message count and if count=1, get the message
1562: FND_MSG_PUB.Count_And_Get (
1563: p_encoded => FND_API.G_FALSE,
1564: p_count => x_msg_count,

Line 1563: p_encoded => FND_API.G_FALSE,

1559: ROLLBACK TO VALIDATE_Ge_Chklst_;
1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1561: -- Standard call to get message count and if count=1, get the message
1562: FND_MSG_PUB.Count_And_Get (
1563: p_encoded => FND_API.G_FALSE,
1564: p_count => x_msg_count,
1565: p_data => x_msg_data
1566: );
1567:

Line 1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1566: );
1567:
1568: WHEN OTHERS THEN
1569: ROLLBACK TO VALIDATE_Ge_Chklst_;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1571: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1572: THEN
1573: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1574: END IF;

Line 1577: p_encoded => FND_API.G_FALSE,

1573: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1574: END IF;
1575: -- Standard call to get message count and if count=1, get the message
1576: FND_MSG_PUB.Count_And_Get (
1577: p_encoded => FND_API.G_FALSE,
1578: p_count => x_msg_count,
1579: p_data => x_msg_data
1580: );
1581: End Validate_Ge_Chklst;

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

1582:
1583:
1584: PROCEDURE Validate_Ge_Chklst_Rec (
1585: p_api_version_number IN NUMBER,
1586: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_count OUT NOCOPY NUMBER,
1589: x_msg_data OUT NOCOPY VARCHAR2,
1590: p_ge_chklst_rec IN ge_chklst_rec_type

Line 1595: IF FND_API.to_Boolean( p_init_msg_list )

1591: )
1592: IS
1593: BEGIN
1594: -- Initialize message list if p_init_msg_list is set to TRUE.
1595: IF FND_API.to_Boolean( p_init_msg_list )
1596: THEN
1597: FND_MSG_PUB.initialize;
1598: END IF;
1599:

Line 1603: x_return_status := FND_API.G_RET_STS_SUCCESS;

1599:
1600:
1601:
1602: -- Initialize API return status to SUCCESS
1603: x_return_status := FND_API.G_RET_STS_SUCCESS;
1604:
1605: -- Hint: Validate data
1606: -- If data not valid
1607: -- THEN

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

1604:
1605: -- Hint: Validate data
1606: -- If data not valid
1607: -- THEN
1608: -- x_return_status := FND_API.G_RET_STS_ERROR;
1609:
1610: -- Debug Message
1611: IF (PV_DEBUG_HIGH_ON) THEN
1612: