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

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

28: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_PARTNER_PGM_TYPE_PVT';
29: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvpptb.pls';
30:
31: /*** private routine declaration ***/
32: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
33: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
34: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36: FUNCTION Can_Be_Inactive (

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

29: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvpptb.pls';
30:
31: /*** private routine declaration ***/
32: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
33: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
34: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36: FUNCTION Can_Be_Inactive (
37: p_program_type_id NUMBER

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

30:
31: /*** private routine declaration ***/
32: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
33: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
34: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36: FUNCTION Can_Be_Inactive (
37: p_program_type_id NUMBER
38: )

Line 91: FND_MSG_PUB.initialize;

87:
88: -- Initialize message list if p_init_msg_list is set to TRUE.
89: IF FND_API.to_Boolean( p_init_msg_list )
90: THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93:
94: -- Standard call to check for call compatibility.
95: IF NOT FND_API.Compatible_API_Call (

Line 119: FND_MSG_PUB.add;

115: --------------- validate -------------------------
116:
117: IF FND_GLOBAL.User_Id IS NULL THEN
118: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
119: FND_MSG_PUB.add;
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:
123:

Line 228: FND_MSG_PUB.count_and_get(

224: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
225: RAISE FND_API.g_exc_unexpected_error;
226: END IF;
227:
228: FND_MSG_PUB.count_and_get(
229: p_encoded => FND_API.g_false
230: ,p_count => x_msg_count
231: ,p_data => x_msg_data
232: );

Line 260: FND_MSG_PUB.Count_And_Get (

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

Line 270: FND_MSG_PUB.Count_And_Get (

266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: ROLLBACK TO CREATE_Partner_Pgm_Type_PVT;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: -- Standard call to get message count and if count=1, get the message
270: FND_MSG_PUB.Count_And_Get (
271: p_encoded => FND_API.G_FALSE
272: ,p_count => x_msg_count
273: ,p_data => x_msg_data
274: );

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

275:
276: WHEN OTHERS THEN
277: ROLLBACK TO CREATE_Partner_Pgm_Type_PVT;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
282: END IF;
283:

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

277: ROLLBACK TO CREATE_Partner_Pgm_Type_PVT;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
282: END IF;
283:
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (

Line 285: FND_MSG_PUB.Count_And_Get (

281: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
282: END IF;
283:
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (
286: p_encoded => FND_API.G_FALSE
287: ,p_count => x_msg_count
288: ,p_data => x_msg_data
289: );

Line 347: FND_MSG_PUB.initialize;

343:
344: -- Initialize message list if p_init_msg_list is set to TRUE.
345: IF FND_API.to_Boolean( p_init_msg_list )
346: THEN
347: FND_MSG_PUB.initialize;
348: END IF;
349:
350: -- Initialize API return status to SUCCESS
351: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 361: FND_MSG_PUB.add;

357: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
358: FND_MESSAGE.set_token('MODE','Update');
359: FND_MESSAGE.set_token('ENTITY','Partner_Pgm_Type');
360: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
361: FND_MSG_PUB.add;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: CLOSE c_get_Partner_Pgm_Type;

Line 372: FND_MSG_PUB.add;

368: l_tar_ptr_prgm_type_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
369:
370: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ID');
371: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
372: FND_MSG_PUB.add;
373: RAISE FND_API.G_EXC_ERROR;
374: End if;
375:
376: -- Check Whether record has been changed by someone else

Line 380: FND_MSG_PUB.add;

376: -- Check Whether record has been changed by someone else
377: If (l_tar_ptr_prgm_type_rec.object_version_number <> l_ref_ptr_prgm_type_rec.object_version_number) THEN
378: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
379: FND_MESSAGE.set_token('VALUE','ptr_prgm_type');
380: FND_MSG_PUB.add;
381: RAISE FND_API.G_EXC_ERROR;
382: End if;
383:
384: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 424: FND_MSG_PUB.add;

420: l_tar_ptr_prgm_type_rec.active_flag = 'N' and
421: l_tar_ptr_prgm_type_rec.active_flag <> l_ref_ptr_prgm_type_rec.active_flag) THEN
422: IF NOT Can_Be_Inactive(l_tar_ptr_prgm_type_rec.program_type_id) THEN
423: FND_MESSAGE.set_name('PV', 'PV_PRGM_TYPE_CAN_NOT_INACTIVE');
424: FND_MSG_PUB.add;
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: END IF;
428:

Line 459: FND_MSG_PUB.count_and_get(

455: IF FND_API.to_boolean(p_commit) THEN
456: COMMIT;
457: END IF;
458:
459: FND_MSG_PUB.count_and_get(
460: p_encoded => FND_API.g_false
461: ,p_count => x_msg_count
462: ,p_data => x_msg_data
463: );

Line 476: FND_MSG_PUB.Count_And_Get (

472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO UPDATE_Partner_Pgm_Type_PVT;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: -- Standard call to get message count and if count=1, get the message
476: FND_MSG_PUB.Count_And_Get (
477: p_encoded => FND_API.G_FALSE
478: ,p_count => x_msg_count
479: ,p_data => x_msg_data
480: );

Line 486: FND_MSG_PUB.Count_And_Get (

482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO UPDATE_Partner_Pgm_Type_PVT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE
488: ,p_count => x_msg_count
489: ,p_data => x_msg_data
490: );

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

491:
492: WHEN OTHERS THEN
493: ROLLBACK TO UPDATE_Partner_Pgm_Type_PVT;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message

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

493: ROLLBACK TO UPDATE_Partner_Pgm_Type_PVT;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE

Line 500: FND_MSG_PUB.Count_And_Get (

496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE
502: ,p_count => x_msg_count
503: ,p_data => x_msg_data
504: );

Line 567: FND_MSG_PUB.initialize;

563:
564: -- Initialize message list if p_init_msg_list is set to TRUE.
565: IF FND_API.to_Boolean( p_init_msg_list )
566: THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569:
570: -- Initialize API return status to SUCCESS
571: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 583: FND_MSG_PUB.add;

579: p_object_version_number = FND_API.G_MISS_NUM ) THEN
580:
581: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
582: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
583: FND_MSG_PUB.add;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:
587: -- set values in record

Line 601: FND_MSG_PUB.add;

597: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
598: FND_MESSAGE.set_token('MODE','Update');
599: FND_MESSAGE.set_token('ENTITY','Partner_Program_Type');
600: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
601: FND_MSG_PUB.add;
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: -- Debug Message

Line 617: FND_MSG_PUB.add;

613: l_tar_ptr_prgm_type_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
614:
615: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
616: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
617: FND_MSG_PUB.add;
618: raise FND_API.G_EXC_ERROR;
619: End if;
620:
621: -- Check Whether record has been changed by someone else

Line 625: FND_MSG_PUB.add;

621: -- Check Whether record has been changed by someone else
622: If (l_tar_ptr_prgm_type_rec.object_version_number <> l_ref_ptr_prgm_type_rec.object_version_number) THEN
623: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
624: FND_MESSAGE.set_token('VALUE','Partner_Program_Type');
625: FND_MSG_PUB.add;
626: raise FND_API.G_EXC_ERROR;
627: End if;
628:
629: -- Check whether this program type can be deleted

Line 632: FND_MSG_PUB.add;

628:
629: -- Check whether this program type can be deleted
630: IF NOT Can_Be_Deleted(p_PROGRAM_TYPE_ID) THEN
631: FND_MESSAGE.set_name('PV', 'PV_PRGM_TYPE_CAN_NOT_DELETE');
632: FND_MSG_PUB.add;
633: RAISE FND_API.G_EXC_ERROR;
634: END IF;
635:
636: -- Debug Message

Line 659: FND_MSG_PUB.count_and_get(

655: IF FND_API.to_boolean(p_commit) THEN
656: COMMIT;
657: END IF;
658:
659: FND_MSG_PUB.count_and_get(
660: p_encoded => FND_API.g_false
661: ,p_count => x_msg_count
662: ,p_data => x_msg_data
663: );

Line 676: FND_MSG_PUB.Count_And_Get (

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

Line 686: FND_MSG_PUB.Count_And_Get (

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

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

691:
692: WHEN OTHERS THEN
693: ROLLBACK TO DELETE_Partner_Pgm_Type_PVT;
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
696: THEN
697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
698: END IF;
699: -- Standard call to get message count and if count=1, get the message

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

693: ROLLBACK TO DELETE_Partner_Pgm_Type_PVT;
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
696: THEN
697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
698: END IF;
699: -- Standard call to get message count and if count=1, get the message
700: FND_MSG_PUB.Count_And_Get (
701: p_encoded => FND_API.G_FALSE

Line 700: FND_MSG_PUB.Count_And_Get (

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

Line 746: FND_MSG_PUB.initialize;

742:
743: -- Initialize message list if p_init_msg_list is set to TRUE.
744: IF FND_API.to_Boolean( p_init_msg_list )
745: THEN
746: FND_MSG_PUB.initialize;
747: END IF;
748:
749: -- Standard call to check for call compatibility.
750: IF NOT FND_API.Compatible_API_Call ( l_api_version_number

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

766: FETCH c_Partner_Pgm_Type INTO l_PROGRAM_TYPE_ID;
767:
768: IF (c_Partner_Pgm_Type%NOTFOUND) THEN
769: CLOSE c_Partner_Pgm_Type;
770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
771: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
772: FND_MSG_PUB.add;
773: END IF;
774: RAISE FND_API.g_exc_error;

Line 772: FND_MSG_PUB.add;

768: IF (c_Partner_Pgm_Type%NOTFOUND) THEN
769: CLOSE c_Partner_Pgm_Type;
770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
771: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
772: FND_MSG_PUB.add;
773: END IF;
774: RAISE FND_API.g_exc_error;
775: END IF;
776:

Line 780: FND_MSG_PUB.count_and_get(

776:
777: CLOSE c_Partner_Pgm_Type;
778:
779: -------------------- finish --------------------------
780: FND_MSG_PUB.count_and_get(
781: p_encoded => FND_API.g_false
782: ,p_count => x_msg_count
783: ,p_data => x_msg_data
784: );

Line 802: FND_MSG_PUB.Count_And_Get (

798: WHEN FND_API.G_EXC_ERROR THEN
799: ROLLBACK TO LOCK_Partner_Pgm_Type_PVT;
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: -- Standard call to get message count and if count=1, get the message
802: FND_MSG_PUB.Count_And_Get (
803: p_encoded => FND_API.G_FALSE
804: ,p_count => x_msg_count
805: ,p_data => x_msg_data
806: );

Line 812: FND_MSG_PUB.Count_And_Get (

808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
809: ROLLBACK TO LOCK_Partner_Pgm_Type_PVT;
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
811: -- Standard call to get message count and if count=1, get the message
812: FND_MSG_PUB.Count_And_Get (
813: p_encoded => FND_API.G_FALSE
814: ,p_count => x_msg_count
815: ,p_data => x_msg_data
816: );

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

817:
818: WHEN OTHERS THEN
819: ROLLBACK TO LOCK_Partner_Pgm_Type_PVT;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
822: THEN
823: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
824: END IF;
825: -- Standard call to get message count and if count=1, get the message

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

819: ROLLBACK TO LOCK_Partner_Pgm_Type_PVT;
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
822: THEN
823: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
824: END IF;
825: -- Standard call to get message count and if count=1, get the message
826: FND_MSG_PUB.Count_And_Get (
827: p_encoded => FND_API.G_FALSE

Line 826: FND_MSG_PUB.Count_And_Get (

822: THEN
823: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
824: END IF;
825: -- Standard call to get message count and if count=1, get the message
826: FND_MSG_PUB.Count_And_Get (
827: p_encoded => FND_API.G_FALSE
828: ,p_count => x_msg_count
829: ,p_data => x_msg_data
830: );

Line 862: FND_MSG_PUB.add;

858: IF l_valid_flag = FND_API.g_false THEN
859: FND_MESSAGE.set_name('PVX', 'PV_API_DUPLICATE_ENTITY');
860: FND_MESSAGE.set_token('ID',to_char( p_ptr_prgm_type_rec.PROGRAM_TYPE_ID) );
861: FND_MESSAGE.set_token('ENTITY','ptr_prgm_type');
862: FND_MSG_PUB.add;
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
866: END IF;

Line 887: FND_MSG_PUB.add;

883: IF p_ptr_prgm_type_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num
884: OR p_ptr_prgm_type_rec.PROGRAM_TYPE_ID IS NULL THEN
885: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
886: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
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_ptr_prgm_type_rec.active_flag = FND_API.g_miss_char
894: OR p_ptr_prgm_type_rec.active_flag IS NULL THEN
895: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
896: FND_MESSAGE.set_token('COLUMN','ACTIVE_FLAG');
897: FND_MSG_PUB.add;
898: x_return_status := FND_API.g_ret_sts_error;
899: RETURN;
900: END IF;
901:

Line 907: FND_MSG_PUB.add;

903: IF p_ptr_prgm_type_rec.enabled_flag = FND_API.g_miss_char
904: OR p_ptr_prgm_type_rec.enabled_flag IS NULL THEN
905: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
906: FND_MESSAGE.set_token('COLUMN','ENABLED_FLAG');
907: FND_MSG_PUB.add;
908: x_return_status := FND_API.g_ret_sts_error;
909: RETURN;
910: END IF;
911:

Line 917: FND_MSG_PUB.add;

913: IF p_ptr_prgm_type_rec.program_type_name = FND_API.g_miss_char
914: OR p_ptr_prgm_type_rec.program_type_name IS NULL THEN
915: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
916: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_NAME');
917: FND_MSG_PUB.add;
918: x_return_status := FND_API.g_ret_sts_error;
919: RETURN;
920: END IF;
921:

Line 927: FND_MSG_PUB.add;

923: IF p_ptr_prgm_type_rec.object_version_number = FND_API.g_miss_num
924: OR p_ptr_prgm_type_rec.object_version_number IS NULL THEN
925: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
926: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
927: FND_MSG_PUB.add;
928: x_return_status := FND_API.g_ret_sts_error;
929: RETURN;
930: END IF;
931:

Line 937: FND_MSG_PUB.add;

933: IF p_ptr_prgm_type_rec.creation_date = FND_API.g_miss_date
934: OR p_ptr_prgm_type_rec.creation_date IS NULL THEN
935: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
936: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
937: FND_MSG_PUB.add;
938: x_return_status := FND_API.g_ret_sts_error;
939: RETURN;
940: END IF;
941:

Line 953: FND_MSG_PUB.add;

949: IF p_ptr_prgm_type_rec.created_by = FND_API.g_miss_num
950: OR p_ptr_prgm_type_rec.created_by IS NULL THEN
951: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
952: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
953: FND_MSG_PUB.add;
954: x_return_status := FND_API.g_ret_sts_error;
955: RETURN;
956: END IF;
957:

Line 963: FND_MSG_PUB.add;

959: IF p_ptr_prgm_type_rec.last_update_date = FND_API.g_miss_date
960: OR p_ptr_prgm_type_rec.last_update_date IS NULL THEN
961: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
962: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
963: FND_MSG_PUB.add;
964: x_return_status := FND_API.g_ret_sts_error;
965: RETURN;
966: END IF;
967:

Line 973: FND_MSG_PUB.add;

969: IF p_ptr_prgm_type_rec.last_updated_by = FND_API.g_miss_num
970: OR p_ptr_prgm_type_rec.last_updated_by IS NULL THEN
971: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
972: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
973: FND_MSG_PUB.add;
974: x_return_status := FND_API.g_ret_sts_error;
975: RETURN;
976: END IF;
977:

Line 983: FND_MSG_PUB.add;

979: IF p_ptr_prgm_type_rec.last_update_login = FND_API.g_miss_num
980: OR p_ptr_prgm_type_rec.last_update_login IS NULL THEN
981: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
982: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
983: FND_MSG_PUB.add;
984: x_return_status := FND_API.g_ret_sts_error;
985: RETURN;
986: END IF;
987: ELSE

Line 1286: FND_MSG_PUB.initialize;

1282: END IF;
1283:
1284: -- Initialize message list if p_init_msg_list is set to TRUE.
1285: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1286: FND_MSG_PUB.initialize;
1287: END IF;
1288:
1289: -- Debug Message
1290: IF (PV_DEBUG_HIGH_ON) THEN

Line 1346: FND_MSG_PUB.Count_And_Get

1342: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
1343: END IF;
1344:
1345: -- Standard call to get message count and if count is 1, get message info.
1346: FND_MSG_PUB.Count_And_Get
1347: ( p_encoded => FND_API.G_FALSE,
1348: p_count => x_msg_count,
1349: p_data => x_msg_data
1350: );

Line 1358: FND_MSG_PUB.Count_And_Get (

1354: WHEN FND_API.G_EXC_ERROR THEN
1355: ROLLBACK TO VALIDATE_Partner_Pgm_Type_;
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357: -- Standard call to get message count and if count=1, get the message
1358: FND_MSG_PUB.Count_And_Get (
1359: p_encoded => FND_API.G_FALSE
1360: ,p_count => x_msg_count
1361: ,p_data => x_msg_data
1362: );

Line 1368: FND_MSG_PUB.Count_And_Get (

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

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

1373:
1374: WHEN OTHERS THEN
1375: ROLLBACK TO VALIDATE_Partner_Pgm_Type_;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1378: THEN
1379: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1380: END IF;
1381: -- Standard call to get message count and if count=1, get the message

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

1375: ROLLBACK TO VALIDATE_Partner_Pgm_Type_;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1378: THEN
1379: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1380: END IF;
1381: -- Standard call to get message count and if count=1, get the message
1382: FND_MSG_PUB.Count_And_Get (
1383: p_encoded => FND_API.G_FALSE

Line 1382: FND_MSG_PUB.Count_And_Get (

1378: THEN
1379: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1380: END IF;
1381: -- Standard call to get message count and if count=1, get the message
1382: FND_MSG_PUB.Count_And_Get (
1383: p_encoded => FND_API.G_FALSE
1384: ,p_count => x_msg_count
1385: ,p_data => x_msg_data
1386: );

Line 1405: FND_MSG_PUB.initialize;

1401: BEGIN
1402: -- Initialize message list if p_init_msg_list is set to TRUE.
1403: IF FND_API.to_Boolean( p_init_msg_list )
1404: THEN
1405: FND_MSG_PUB.initialize;
1406: END IF;
1407:
1408: -- Initialize API return status to SUCCESS
1409: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1422: FND_MSG_PUB.Count_And_Get(

1418:
1419: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1420: END IF;
1421: -- Standard call to get message count and if count is 1, get message info.
1422: FND_MSG_PUB.Count_And_Get(
1423: p_count => x_msg_count
1424: ,p_data => x_msg_data
1425: );
1426: