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_PRGM_BENEFITS_PVT dependencies on FND_MSG_PUB

Line 27: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_PRGM_BENEFITS_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvpbsb.pls';
25:
26:
27: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE Create_Prgm_Benefits(

Line 28: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvpbsb.pls';
25:
26:
27: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE Create_Prgm_Benefits(
32: p_api_version_number IN NUMBER

Line 29: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

25:
26:
27: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
28: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
29: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
30:
31: PROCEDURE Create_Prgm_Benefits(
32: p_api_version_number IN NUMBER
33: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 76: FND_MSG_PUB.initialize;

72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list )
75: THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Standard call to check for call compatibility.
80: IF NOT FND_API.Compatible_API_Call (

Line 112: FND_MSG_PUB.add;

108: END IF;
109:
110: IF FND_GLOBAL.User_Id IS NULL THEN
111: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
112: FND_MSG_PUB.add;
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116:

Line 215: FND_MSG_PUB.count_and_get(

211: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
212: RAISE FND_API.g_exc_unexpected_error;
213: END IF;
214:
215: FND_MSG_PUB.count_and_get(
216: p_encoded => FND_API.g_false
217: ,p_count => x_msg_count
218: ,p_data => x_msg_data
219: );

Line 238: FND_MSG_PUB.Count_And_Get (

234: WHEN FND_API.G_EXC_ERROR THEN
235: ROLLBACK TO CREATE_PRGM_BENEFITS_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: -- Standard call to get message count and if count=1, get the message
238: FND_MSG_PUB.Count_And_Get (
239: p_encoded => FND_API.G_FALSE
240: ,p_count => x_msg_count
241: ,p_data => x_msg_data
242: );

Line 248: FND_MSG_PUB.Count_And_Get (

244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK TO CREATE_PRGM_BENEFITS_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE
250: ,p_count => x_msg_count
251: ,p_data => x_msg_data
252: );

Line 257: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

253:
254: WHEN OTHERS THEN
255: ROLLBACK TO CREATE_Prgm_Benefits_PVT;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
260: END IF;
261:

Line 259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

255: ROLLBACK TO CREATE_Prgm_Benefits_PVT;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
260: END IF;
261:
262: -- Standard call to get message count and if count=1, get the message
263: FND_MSG_PUB.Count_And_Get (

Line 263: FND_MSG_PUB.Count_And_Get (

259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
260: END IF;
261:
262: -- Standard call to get message count and if count=1, get the message
263: FND_MSG_PUB.Count_And_Get (
264: p_encoded => FND_API.G_FALSE
265: ,p_count => x_msg_count
266: ,p_data => x_msg_data
267: );

Line 320: FND_MSG_PUB.initialize;

316:
317: -- Initialize message list if p_init_msg_list is set to TRUE.
318: IF FND_API.to_Boolean( p_init_msg_list )
319: THEN
320: FND_MSG_PUB.initialize;
321: END IF;
322:
323: -- Initialize API return status to SUCCESS
324: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 334: FND_MSG_PUB.ADD;

330: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
331: FND_MESSAGE.set_token('MODE','Update');
332: FND_MESSAGE.set_token('ENTITY','Program_Benefits');
333: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_benefits_rec.program_benefits_id));
334: FND_MSG_PUB.ADD;
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337:
338: -- Debug Message

Line 350: FND_MSG_PUB.add;

346: l_tar_prgm_benefits_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
347:
348: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
349: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
350: FND_MSG_PUB.add;
351: RAISE FND_API.G_EXC_ERROR;
352: END IF;
353:
354: -- Check Whether record has been changed by someone else

Line 358: FND_MSG_PUB.ADD;

354: -- Check Whether record has been changed by someone else
355: IF (l_tar_prgm_benefits_rec.object_version_number <> l_ref_prgm_benefits_rec.object_version_number) THEN
356: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
357: FND_MESSAGE.set_token('VALUE','PROGRAM_BENEFITS');
358: FND_MSG_PUB.ADD;
359: RAISE FND_API.G_EXC_ERROR;
360: END IF;
361:
362: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 419: FND_MSG_PUB.count_and_get(

415: IF FND_API.to_boolean(p_commit) THEN
416: COMMIT;
417: END IF;
418:
419: FND_MSG_PUB.count_and_get(
420: p_encoded => FND_API.g_false
421: ,p_count => x_msg_count
422: ,p_data => x_msg_data
423: );

Line 436: FND_MSG_PUB.Count_And_Get (

432: WHEN FND_API.G_EXC_ERROR THEN
433: ROLLBACK TO UPDATE_Prgm_Benefits_PVT;
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get (
437: p_encoded => FND_API.G_FALSE
438: ,p_count => x_msg_count
439: ,p_data => x_msg_data
440: );

Line 446: FND_MSG_PUB.Count_And_Get (

442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: ROLLBACK TO UPDATE_Prgm_Benefits_PVT;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: -- Standard call to get message count and if count=1, get the message
446: FND_MSG_PUB.Count_And_Get (
447: p_encoded => FND_API.G_FALSE,
448: p_count => x_msg_count,
449: p_data => x_msg_data
450: );

Line 455: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

451:
452: WHEN OTHERS THEN
453: ROLLBACK TO UPDATE_Prgm_Benefits_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
456: THEN
457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
458: END IF;
459: -- Standard call to get message count and if count=1, get the message

Line 457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

453: ROLLBACK TO UPDATE_Prgm_Benefits_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
456: THEN
457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
458: END IF;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE

Line 460: FND_MSG_PUB.Count_And_Get (

456: THEN
457: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
458: END IF;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE
462: ,p_count => x_msg_count
463: ,p_data => x_msg_data
464: );

Line 515: FND_MSG_PUB.initialize;

511:
512: -- Initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean( p_init_msg_list )
514: THEN
515: FND_MSG_PUB.initialize;
516: END IF;
517:
518: -- Initialize API return status to SUCCESS
519: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 538: FND_MSG_PUB.count_and_get(

534: IF FND_API.to_boolean(p_commit) THEN
535: COMMIT;
536: END IF;
537:
538: FND_MSG_PUB.count_and_get(
539: p_encoded => FND_API.g_false
540: ,p_count => x_msg_count
541: ,p_data => x_msg_data
542: );

Line 555: FND_MSG_PUB.Count_And_Get (

551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO DELETE_Prgm_Benefits_PVT;
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: -- Standard call to get message count and if count=1, get the message
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE
557: ,p_count => x_msg_count
558: ,p_data => x_msg_data
559: );

Line 565: FND_MSG_PUB.Count_And_Get (

561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: ROLLBACK TO DELETE_Prgm_Benefits_PVT;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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: );

Line 574: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

570:
571: WHEN OTHERS THEN
572: ROLLBACK TO DELETE_Prgm_Benefits_PVT;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
575: THEN
576: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
577: END IF;
578: -- Standard call to get message count and if count=1, get the message

Line 576: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

572: ROLLBACK TO DELETE_Prgm_Benefits_PVT;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
575: THEN
576: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
577: END IF;
578: -- Standard call to get message count and if count=1, get the message
579: FND_MSG_PUB.Count_And_Get (
580: p_encoded => FND_API.G_FALSE

Line 579: FND_MSG_PUB.Count_And_Get (

575: THEN
576: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
577: END IF;
578: -- Standard call to get message count and if count=1, get the message
579: FND_MSG_PUB.Count_And_Get (
580: p_encoded => FND_API.G_FALSE
581: ,p_count => x_msg_count
582: ,p_data => x_msg_data
583: );

Line 626: FND_MSG_PUB.initialize;

622:
623: -- Initialize message list if p_init_msg_list is set to TRUE.
624: IF FND_API.to_Boolean( p_init_msg_list )
625: THEN
626: FND_MSG_PUB.initialize;
627: END IF;
628:
629: -- Standard call to check for call compatibility.
630: IF NOT FND_API.Compatible_API_Call (

Line 660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

656: FETCH c_Prgm_Benefits INTO l_program_benefits_id;
657:
658: IF (c_Prgm_Benefits%NOTFOUND) THEN
659: CLOSE c_Prgm_Benefits;
660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
661: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
662: FND_MSG_PUB.add;
663: END IF;
664: RAISE FND_API.g_exc_error;

Line 662: FND_MSG_PUB.add;

658: IF (c_Prgm_Benefits%NOTFOUND) THEN
659: CLOSE c_Prgm_Benefits;
660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
661: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
662: FND_MSG_PUB.add;
663: END IF;
664: RAISE FND_API.g_exc_error;
665: END IF;
666:

Line 670: FND_MSG_PUB.count_and_get(

666:
667: CLOSE c_Prgm_Benefits;
668:
669: -------------------- finish --------------------------
670: FND_MSG_PUB.count_and_get(
671: p_encoded => FND_API.g_false
672: ,p_count => x_msg_count
673: ,p_data => x_msg_data
674: );

Line 692: FND_MSG_PUB.Count_And_Get (

688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO LOCK_Prgm_Benefits_PVT;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: -- Standard call to get message count and if count=1, get the message
692: FND_MSG_PUB.Count_And_Get (
693: p_encoded => FND_API.G_FALSE
694: ,p_count => x_msg_count
695: ,p_data => x_msg_data
696: );

Line 702: FND_MSG_PUB.Count_And_Get (

698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
699: ROLLBACK TO LOCK_Prgm_Benefits_PVT;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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: );

Line 711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

707:
708: WHEN OTHERS THEN
709: ROLLBACK TO LOCK_Prgm_Benefits_PVT;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
712: THEN
713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
714: END IF;
715: -- Standard call to get message count and if count=1, get the message

Line 713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

709: ROLLBACK TO LOCK_Prgm_Benefits_PVT;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
712: THEN
713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
714: END IF;
715: -- Standard call to get message count and if count=1, get the message
716: FND_MSG_PUB.Count_And_Get (
717: p_encoded => FND_API.G_FALSE

Line 716: FND_MSG_PUB.Count_And_Get (

712: THEN
713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
714: END IF;
715: -- Standard call to get message count and if count=1, get the message
716: FND_MSG_PUB.Count_And_Get (
717: p_encoded => FND_API.G_FALSE
718: ,p_count => x_msg_count
719: ,p_data => x_msg_data
720: );

Line 749: FND_MSG_PUB.add;

745: IF l_valid_flag = FND_API.g_false THEN
746: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
747: FND_MESSAGE.set_token('ID',to_char(p_prgm_benefits_rec.program_benefits_id) );
748: FND_MESSAGE.set_token('ENTITY','PARTNER_BENEFITS');
749: FND_MSG_PUB.add;
750: x_return_status := FND_API.g_ret_sts_error;
751: RETURN;
752: END IF;
753: -- Debug message

Line 782: FND_MSG_PUB.add;

778: IF p_prgm_benefits_rec.program_benefits_id = FND_API.g_miss_num
779: OR p_prgm_benefits_rec.program_benefits_id IS NULL THEN
780: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
781: FND_MESSAGE.set_token('COLUMN','PROGRAM_BENEFITS_ID');
782: FND_MSG_PUB.add;
783: x_return_status := FND_API.g_ret_sts_error;
784: RETURN;
785: END IF;
786:

Line 792: FND_MSG_PUB.add;

788: IF p_prgm_benefits_rec.program_id = FND_API.g_miss_num
789: OR p_prgm_benefits_rec.program_id IS NULL THEN
790: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
791: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');
792: FND_MSG_PUB.add;
793: x_return_status := FND_API.g_ret_sts_error;
794: RETURN;
795: END IF;
796:

Line 802: FND_MSG_PUB.add;

798: IF p_prgm_benefits_rec.benefit_code = FND_API.g_miss_char
799: OR p_prgm_benefits_rec.benefit_code IS NULL THEN
800: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
801: FND_MESSAGE.set_token('COLUMN','BENEFIT_CODE');
802: FND_MSG_PUB.add;
803: x_return_status := FND_API.g_ret_sts_error;
804: RETURN;
805: END IF;
806: */

Line 812: FND_MSG_PUB.add;

808: IF p_prgm_benefits_rec.benefit_id = FND_API.g_miss_num
809: OR p_prgm_benefits_rec.benefit_id IS NULL THEN
810: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
811: FND_MESSAGE.set_token('COLUMN','BENEFIT_ID');
812: FND_MSG_PUB.add;
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
815: END IF;
816:

Line 822: FND_MSG_PUB.add;

818: IF p_prgm_benefits_rec.benefit_type_code = FND_API.g_miss_char
819: OR p_prgm_benefits_rec.benefit_type_code IS NULL THEN
820: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
821: FND_MESSAGE.set_token('COLUMN','BENEFIT_TYPE_CODE');
822: FND_MSG_PUB.add;
823: x_return_status := FND_API.g_ret_sts_error;
824: RETURN;
825: END IF;
826:

Line 832: FND_MSG_PUB.add;

828: IF p_prgm_benefits_rec.delete_flag = FND_API.g_miss_char
829: OR p_prgm_benefits_rec.delete_flag IS NULL THEN
830: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
831: FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');
832: FND_MSG_PUB.add;
833: x_return_status := FND_API.g_ret_sts_error;
834: RETURN;
835: END IF;
836:

Line 842: FND_MSG_PUB.add;

838: IF p_prgm_benefits_rec.last_update_login = FND_API.g_miss_num
839: OR p_prgm_benefits_rec.last_update_login IS NULL THEN
840: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
841: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
842: FND_MSG_PUB.add;
843: x_return_status := FND_API.g_ret_sts_error;
844: RETURN;
845: END IF;
846:

Line 852: FND_MSG_PUB.add;

848: IF p_prgm_benefits_rec.object_version_number = FND_API.g_miss_num
849: OR p_prgm_benefits_rec.object_version_number IS NULL THEN
850: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
851: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
852: FND_MSG_PUB.add;
853: x_return_status := FND_API.g_ret_sts_error;
854: RETURN;
855: END IF;
856:

Line 862: FND_MSG_PUB.add;

858: IF p_prgm_benefits_rec.last_update_date = FND_API.g_miss_date
859: OR p_prgm_benefits_rec.last_update_date IS NULL THEN
860: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
861: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
862: FND_MSG_PUB.add;
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
866:

Line 872: FND_MSG_PUB.add;

868: IF p_prgm_benefits_rec.last_updated_by = FND_API.g_miss_num
869: OR p_prgm_benefits_rec.last_updated_by IS NULL THEN
870: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
871: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
872: FND_MSG_PUB.add;
873: x_return_status := FND_API.g_ret_sts_error;
874: RETURN;
875: END IF;
876:

Line 887: FND_MSG_PUB.add;

883: IF p_prgm_benefits_rec.created_by = FND_API.g_miss_num
884: OR p_prgm_benefits_rec.created_by IS NULL THEN
885: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
886: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
887: FND_MSG_PUB.add;
888: x_return_status := FND_API.g_ret_sts_error;
889: RETURN;
890: END IF;
891:

Line 897: FND_MSG_PUB.add;

893: IF p_prgm_benefits_rec.creation_date = FND_API.g_miss_date
894: OR p_prgm_benefits_rec.creation_date IS NULL THEN
895: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
896: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
897: FND_MSG_PUB.add;
898: x_return_status := FND_API.g_ret_sts_error;
899: RETURN;
900: END IF;
901: ELSE

Line 906: FND_MSG_PUB.add;

902:
903: IF p_prgm_benefits_rec.program_benefits_id IS NULL THEN
904: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
905: FND_MESSAGE.set_token('COLUMN','PROGRAM_BENEFITS_ID');
906: FND_MSG_PUB.add;
907: x_return_status := FND_API.g_ret_sts_error;
908: RETURN;
909: END IF;
910:

Line 915: FND_MSG_PUB.add;

911: IF p_prgm_benefits_rec.benefit_id = FND_API.g_miss_num
912: OR p_prgm_benefits_rec.benefit_id IS NULL THEN
913: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
914: FND_MESSAGE.set_token('COLUMN','BENEFIT_ID');
915: FND_MSG_PUB.add;
916: x_return_status := FND_API.g_ret_sts_error;
917: RETURN;
918: END IF;
919:

Line 925: FND_MSG_PUB.add;

921: IF p_prgm_benefits_rec.benefit_type_code = FND_API.g_miss_char
922: OR p_prgm_benefits_rec.benefit_type_code IS NULL THEN
923: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
924: FND_MESSAGE.set_token('COLUMN','BENEFIT_TYPE_CODE');
925: FND_MSG_PUB.add;
926: x_return_status := FND_API.g_ret_sts_error;
927: RETURN;
928: END IF;
929:

Line 935: FND_MSG_PUB.add;

931: IF p_prgm_benefits_rec.delete_flag = FND_API.g_miss_char
932: OR p_prgm_benefits_rec.delete_flag IS NULL THEN
933: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
934: FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');
935: FND_MSG_PUB.add;
936: x_return_status := FND_API.g_ret_sts_error;
937: RETURN;
938: END IF;
939:

Line 944: FND_MSG_PUB.add;

940:
941: IF p_prgm_benefits_rec.object_version_number IS NULL THEN
942: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
943: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
944: FND_MSG_PUB.add;
945: x_return_status := FND_API.g_ret_sts_error;
946: RETURN;
947: END IF;
948: END IF;

Line 982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

978: PVX_utility_PVT.g_number, -- datatype of fk
979: NULL
980: ) = FND_API.g_false
981: THEN
982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
983: THEN
984: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PARTNER_PROGRAM');
985: FND_MSG_PUB.add;
986: END IF;

Line 985: FND_MSG_PUB.add;

981: THEN
982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
983: THEN
984: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PARTNER_PROGRAM');
985: FND_MSG_PUB.add;
986: END IF;
987:
988: x_return_status := FND_API.g_ret_sts_error;
989: RETURN;

Line 1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1020: 'PV_PROGRAM_BENEFITS', -- Lookup Type
1021: p_prgm_benefits_rec.Benefit_Code -- Lookup Code
1022: ) = FND_API.g_false
1023: THEN
1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1025: THEN
1026: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROGRAM_BENEFIT');
1027: FND_MSG_PUB.add;
1028: END IF;

Line 1027: FND_MSG_PUB.add;

1023: THEN
1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1025: THEN
1026: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROGRAM_BENEFIT');
1027: FND_MSG_PUB.add;
1028: END IF;
1029: x_return_status := FND_API.g_ret_sts_error;
1030: RETURN;
1031:

Line 1296: FND_MSG_PUB.initialize;

1292: END IF;
1293:
1294: -- Initialize message list if p_init_msg_list is set to TRUE.
1295: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1296: FND_MSG_PUB.initialize;
1297: END IF;
1298:
1299: -- Debug Message
1300: IF (PV_DEBUG_HIGH_ON) THEN

Line 1356: FND_MSG_PUB.Count_And_Get

1352: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
1353: END IF;
1354:
1355: -- Standard call to get message count and if count is 1, get message info.
1356: FND_MSG_PUB.Count_And_Get
1357: ( p_encoded => FND_API.G_FALSE,
1358: p_count => x_msg_count,
1359: p_data => x_msg_data
1360: );

Line 1367: FND_MSG_PUB.Count_And_Get (

1363: WHEN FND_API.G_EXC_ERROR THEN
1364: ROLLBACK TO Validate_Prgm_Benefits_;
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: -- Standard call to get message count and if count=1, get the message
1367: FND_MSG_PUB.Count_And_Get (
1368: p_encoded => FND_API.G_FALSE
1369: ,p_count => x_msg_count
1370: ,p_data => x_msg_data
1371: );

Line 1377: FND_MSG_PUB.Count_And_Get (

1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: ROLLBACK TO Validate_Prgm_Benefits_;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: -- Standard call to get message count and if count=1, get the message
1377: FND_MSG_PUB.Count_And_Get (
1378: p_encoded => FND_API.G_FALSE
1379: ,p_count => x_msg_count
1380: ,p_data => x_msg_data
1381: );

Line 1386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1382:
1383: WHEN OTHERS THEN
1384: ROLLBACK TO Validate_Prgm_Benefits_;
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1387: THEN
1388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1389: END IF;
1390: -- Standard call to get message count and if count=1, get the message

Line 1388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1384: ROLLBACK TO Validate_Prgm_Benefits_;
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1387: THEN
1388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1389: END IF;
1390: -- Standard call to get message count and if count=1, get the message
1391: FND_MSG_PUB.Count_And_Get (
1392: p_encoded => FND_API.G_FALSE

Line 1391: FND_MSG_PUB.Count_And_Get (

1387: THEN
1388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1389: END IF;
1390: -- Standard call to get message count and if count=1, get the message
1391: FND_MSG_PUB.Count_And_Get (
1392: p_encoded => FND_API.G_FALSE
1393: ,p_count => x_msg_count
1394: ,p_data => x_msg_data
1395: );

Line 1417: FND_MSG_PUB.initialize;

1413: BEGIN
1414: -- Initialize message list if p_init_msg_list is set to TRUE.
1415: IF FND_API.to_Boolean( p_init_msg_list )
1416: THEN
1417: FND_MSG_PUB.initialize;
1418: END IF;
1419:
1420: -- Initialize API return status to SUCCESS
1421: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1429: FND_MSG_PUB.Count_And_Get

1425: -- THEN
1426: -- x_return_status := FND_API.G_RET_STS_ERROR;
1427:
1428: -- Standard call to get message count and if count is 1, get message info.
1429: FND_MSG_PUB.Count_And_Get
1430: (p_count => x_msg_count,
1431: p_data => x_msg_data
1432: );
1433: