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

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

29:
30:
31: -- Following procedure gives the description for the Payment Method Code passed
32:
33: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
34: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
35: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
36:
37: PROCEDURE Get_Pmnt_Mode_Desc(

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

30:
31: -- Following procedure gives the description for the Payment Method Code passed
32:
33: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
34: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
35: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
36:
37: PROCEDURE Get_Pmnt_Mode_Desc(
38: p_program_payment_mode IN VARCHAR2

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

31: -- Following procedure gives the description for the Payment Method Code passed
32:
33: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
34: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
35: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
36:
37: PROCEDURE Get_Pmnt_Mode_Desc(
38: p_program_payment_mode IN VARCHAR2
39: ,p_program_id IN NUMBER

Line 85: FND_MSG_PUB.add;

81: FND_MESSAGE.set_token('ENTITY','Payment Method Meaning');
82: FND_MESSAGE.set_token('ID','Payment Method: '||p_program_payment_mode
83: ||' Program Id: '||p_program_id
84: ||' Geo Hierarchy Id: '|| p_geo_hierarchy_id);
85: FND_MSG_PUB.add;
86: IF (PV_DEBUG_HIGH_ON) THEN
87: PVX_UTILITY_PVT.debug_message('No Data found for the payment method description in Get_Pmnt_Mode_Desc');
88: END IF;
89: RAISE FND_API.G_EXC_ERROR;

Line 139: FND_MSG_PUB.add;

135: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
136: FND_MESSAGE.set_token('MODE','');
137: FND_MESSAGE.set_token('ENTITY','GET_pmnt_method_PVT');
138: FND_MESSAGE.set_token('ID','No Data found in c_get_geo_hierarchy');
139: FND_MSG_PUB.add;
140: IF (PV_DEBUG_HIGH_ON) THEN
141:
142: PVX_UTILITY_PVT.debug_message('No Data found for the payment method description');
143: END IF;

Line 214: FND_MSG_PUB.initialize;

210:
211: -- Initialize message list if p_init_msg_list is set to TRUE.
212: IF FND_API.to_Boolean( p_init_msg_list )
213: THEN
214: FND_MSG_PUB.initialize;
215: END IF;
216:
217: -- Standard call to check for call compatibility.
218: IF NOT FND_API.Compatible_API_Call (

Line 250: FND_MSG_PUB.add;

246: END IF;
247:
248: IF FND_GLOBAL.User_Id IS NULL THEN
249: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
250: FND_MSG_PUB.add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253:
254: l_create := true;

Line 381: FND_MSG_PUB.count_and_get(

377: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
378: RAISE FND_API.g_exc_unexpected_error;
379: END IF;
380:
381: FND_MSG_PUB.count_and_get(
382: p_encoded => FND_API.g_false
383: ,p_count => x_msg_count
384: ,p_data => x_msg_data
385: );

Line 403: FND_MSG_PUB.Count_And_Get (

399: WHEN FND_API.G_EXC_ERROR THEN
400: ROLLBACK TO Create_Prgm_Pmt_Mode_PVT;
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: -- Standard call to get message count and if count=1, get the message
403: FND_MSG_PUB.Count_And_Get (
404: p_encoded => FND_API.G_FALSE
405: ,p_count => x_msg_count
406: ,p_data => x_msg_data
407: );

Line 413: FND_MSG_PUB.Count_And_Get (

409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK TO Create_Prgm_Pmt_Mode_PVT;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: -- Standard call to get message count and if count=1, get the message
413: FND_MSG_PUB.Count_And_Get (
414: p_encoded => FND_API.G_FALSE
415: ,p_count => x_msg_count
416: ,p_data => x_msg_data
417: );

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

418:
419: WHEN OTHERS THEN
420: ROLLBACK TO Create_Prgm_Pmt_Mode_PVT;
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
423: THEN
424: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
425: END IF;
426: -- Standard call to get message count and if count=1, get the message

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

420: ROLLBACK TO Create_Prgm_Pmt_Mode_PVT;
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
423: THEN
424: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
425: END IF;
426: -- Standard call to get message count and if count=1, get the message
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE

Line 427: FND_MSG_PUB.Count_And_Get (

423: THEN
424: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
425: END IF;
426: -- Standard call to get message count and if count=1, get the message
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE
429: ,p_count => x_msg_count
430: ,p_data => x_msg_data
431: );

Line 501: FND_MSG_PUB.initialize;

497:
498: -- Initialize message list if p_init_msg_list is set to TRUE.
499: IF FND_API.to_Boolean( p_init_msg_list )
500: THEN
501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: -- Initialize API return status to SUCCESS
505: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 515: FND_MSG_PUB.add;

511: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
512: FND_MESSAGE.set_token('MODE','Update');
513: FND_MESSAGE.set_token('ENTITY','prgm_pmt_mode');
514: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_pmt_mode_rec.program_payment_mode_id));
515: FND_MSG_PUB.add;
516: RAISE FND_API.G_EXC_ERROR;
517: END IF;
518:
519: -- Debug Message

Line 531: FND_MSG_PUB.add;

527: l_tar_prgm_pmt_mode_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
528:
529: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
530: FND_MESSAGE.set_token('COLUMN','object_version_number');
531: FND_MSG_PUB.add;
532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
534:
535:

Line 541: FND_MSG_PUB.add;

537: -- Check Whether record has been changed by someone else
538: IF (l_tar_prgm_pmt_mode_rec.object_version_number <> l_ref_prgm_pmt_mode_rec.object_version_number) THEN
539: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
540: FND_MESSAGE.set_token('VALUE','prgm_pmt_mode');
541: FND_MSG_PUB.add;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544:
545:

Line 645: FND_MSG_PUB.count_and_get(

641: IF FND_API.to_boolean(p_commit) THEN
642: COMMIT;
643: END IF;
644:
645: FND_MSG_PUB.count_and_get(
646: p_encoded => FND_API.g_false
647: ,p_count => x_msg_count
648: ,p_data => x_msg_data
649: );

Line 662: FND_MSG_PUB.Count_And_Get (

658: WHEN FND_API.G_EXC_ERROR THEN
659: ROLLBACK TO Update_Prgm_Pmt_Mode_PVT;
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: -- Standard call to get message count and if count=1, get the message
662: FND_MSG_PUB.Count_And_Get (
663: p_encoded => FND_API.G_FALSE
664: ,p_count => x_msg_count
665: ,p_data => x_msg_data
666: );

Line 672: FND_MSG_PUB.Count_And_Get (

668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669: ROLLBACK TO Update_Prgm_Pmt_Mode_PVT;
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671: -- Standard call to get message count and if count=1, get the message
672: FND_MSG_PUB.Count_And_Get (
673: p_encoded => FND_API.G_FALSE
674: ,p_count => x_msg_count
675: ,p_data => x_msg_data
676: );

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

677:
678: WHEN OTHERS THEN
679: ROLLBACK TO Update_Prgm_Pmt_Mode_PVT;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
682: THEN
683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
684: END IF;
685: -- Standard call to get message count and if count=1, get the message

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

679: ROLLBACK TO Update_Prgm_Pmt_Mode_PVT;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
682: THEN
683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
684: END IF;
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

Line 686: FND_MSG_PUB.Count_And_Get (

682: THEN
683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
684: END IF;
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 739: FND_MSG_PUB.initialize;

735:
736: -- Initialize message list if p_init_msg_list is set to TRUE.
737: IF FND_API.to_Boolean( p_init_msg_list )
738: THEN
739: FND_MSG_PUB.initialize;
740: END IF;
741:
742: -- Initialize API return status to SUCCESS
743: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 762: FND_MSG_PUB.count_and_get(

758: IF FND_API.to_boolean(p_commit) THEN
759: COMMIT;
760: END IF;
761:
762: FND_MSG_PUB.count_and_get(
763: p_encoded => FND_API.g_false
764: ,p_count => x_msg_count
765: ,p_data => x_msg_data
766: );

Line 779: FND_MSG_PUB.Count_And_Get (

775: WHEN FND_API.G_EXC_ERROR THEN
776: ROLLBACK TO Delete_Prgm_Pmt_Mode_PVT;
777: x_return_status := FND_API.G_RET_STS_ERROR;
778: -- Standard call to get message count and if count=1, get the message
779: FND_MSG_PUB.Count_And_Get (
780: p_encoded => FND_API.G_FALSE
781: ,p_count => x_msg_count
782: ,p_data => x_msg_data
783: );

Line 789: FND_MSG_PUB.Count_And_Get (

785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
786: ROLLBACK TO Delete_Prgm_Pmt_Mode_PVT;
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788: -- Standard call to get message count and if count=1, get the message
789: FND_MSG_PUB.Count_And_Get (
790: p_encoded => FND_API.G_FALSE
791: ,p_count => x_msg_count
792: ,p_data => x_msg_data
793: );

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

794:
795: WHEN OTHERS THEN
796: ROLLBACK TO Delete_Prgm_Pmt_Mode_PVT;
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
799: THEN
800: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
801: END IF;
802: -- Standard call to get message count and if count=1, get the message

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

796: ROLLBACK TO Delete_Prgm_Pmt_Mode_PVT;
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
799: THEN
800: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
801: END IF;
802: -- Standard call to get message count and if count=1, get the message
803: FND_MSG_PUB.Count_And_Get (
804: p_encoded => FND_API.G_FALSE

Line 803: FND_MSG_PUB.Count_And_Get (

799: THEN
800: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
801: END IF;
802: -- Standard call to get message count and if count=1, get the message
803: FND_MSG_PUB.Count_And_Get (
804: p_encoded => FND_API.G_FALSE
805: ,p_count => x_msg_count
806: ,p_data => x_msg_data
807: );

Line 849: FND_MSG_PUB.initialize;

845:
846: -- Initialize message list if p_init_msg_list is set to TRUE.
847: IF FND_API.to_Boolean( p_init_msg_list )
848: THEN
849: FND_MSG_PUB.initialize;
850: END IF;
851:
852: -- Standard call to check for call compatibility.
853: IF NOT FND_API.Compatible_API_Call (

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

879: FETCH c_prgm_pmt_mode INTO l_program_payment_mode_id;
880:
881: IF (c_prgm_pmt_mode%NOTFOUND) THEN
882: CLOSE c_prgm_pmt_mode;
883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
884: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
885: FND_MSG_PUB.add;
886: END IF;
887: RAISE FND_API.g_exc_error;

Line 885: FND_MSG_PUB.add;

881: IF (c_prgm_pmt_mode%NOTFOUND) THEN
882: CLOSE c_prgm_pmt_mode;
883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
884: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
885: FND_MSG_PUB.add;
886: END IF;
887: RAISE FND_API.g_exc_error;
888: END IF;
889:

Line 893: FND_MSG_PUB.count_and_get(

889:
890: CLOSE c_prgm_pmt_mode;
891:
892: -------------------- finish --------------------------
893: FND_MSG_PUB.count_and_get(
894: p_encoded => FND_API.g_false
895: ,p_count => x_msg_count
896: ,p_data => x_msg_data
897: );

Line 915: FND_MSG_PUB.Count_And_Get (

911: WHEN FND_API.G_EXC_ERROR THEN
912: ROLLBACK TO Lock_Prgm_Pmt_Mode_PVT;
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: -- Standard call to get message count and if count=1, get the message
915: FND_MSG_PUB.Count_And_Get (
916: p_encoded => FND_API.G_FALSE
917: ,p_count => x_msg_count
918: ,p_data => x_msg_data
919: );

Line 925: FND_MSG_PUB.Count_And_Get (

921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
922: ROLLBACK TO Lock_Prgm_Pmt_Mode_PVT;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE
927: ,p_count => x_msg_count
928: ,p_data => x_msg_data
929: );

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

931:
932: WHEN OTHERS THEN
933: ROLLBACK TO Lock_Prgm_Pmt_Mode_PVT;
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
936: THEN
937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
938: END IF;
939: -- Standard call to get message count and if count=1, get the message

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

933: ROLLBACK TO Lock_Prgm_Pmt_Mode_PVT;
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
936: THEN
937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
938: END IF;
939: -- Standard call to get message count and if count=1, get the message
940: FND_MSG_PUB.Count_And_Get (
941: p_encoded => FND_API.G_FALSE

Line 940: FND_MSG_PUB.Count_And_Get (

936: THEN
937: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
938: END IF;
939: -- Standard call to get message count and if count=1, get the message
940: FND_MSG_PUB.Count_And_Get (
941: p_encoded => FND_API.G_FALSE
942: ,p_count => x_msg_count
943: ,p_data => x_msg_data
944: );

Line 994: FND_MSG_PUB.add;

990: IF l_valid_flag = FND_API.g_false THEN
991: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
992: FND_MESSAGE.set_token('ID',to_char(p_prgm_pmt_mode_rec.program_payment_mode_id) );
993: FND_MESSAGE.set_token('ENTITY','PRGM_PMT_MODE');
994: FND_MSG_PUB.add;
995: x_return_status := FND_API.g_ret_sts_error;
996: RETURN;
997: END IF;
998:

Line 1031: FND_MSG_PUB.ADD;

1027: FND_MESSAGE.set_token('ENTITY2', l_location_type_name);
1028: FND_MESSAGE.set_token('ENTITY3', l_geo_area_name);
1029: CLOSE c_geo_area_name;
1030:
1031: FND_MSG_PUB.ADD;
1032: x_return_status := Fnd_Api.g_ret_sts_error;
1033: RETURN;
1034:
1035: /*

Line 1055: FND_MSG_PUB.add;

1051: FND_MESSAGE.set_name('PV', 'PV_PMNT_MODE_DUPLICATE_ENTITY');
1052: FND_MESSAGE.set_token('ENTITY1',x_pmt_mode_desc);
1053: FND_MESSAGE.set_token('ENTITY2',x_location_type_name);
1054: FND_MESSAGE.set_token('ENTITY3',x_geo_area_name);
1055: FND_MSG_PUB.add;
1056:
1057: x_return_status := FND_API.g_ret_sts_error;
1058: RETURN;
1059: */

Line 1085: FND_MSG_PUB.add;

1081: IF p_prgm_pmt_mode_rec.program_payment_mode_id = FND_API.g_miss_num
1082: OR p_prgm_pmt_mode_rec.program_payment_mode_id IS NULL THEN
1083: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1084: FND_MESSAGE.set_token('COLUMN','PROGRAM_PAYMENT_MODE_ID');
1085: FND_MSG_PUB.add;
1086: x_return_status := FND_API.g_ret_sts_error;
1087: RETURN;
1088: END IF;
1089:

Line 1095: FND_MSG_PUB.add;

1091: IF p_prgm_pmt_mode_rec.program_id = FND_API.g_miss_num OR
1092: p_prgm_pmt_mode_rec.program_id IS NULL THEN
1093: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1094: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');
1095: FND_MSG_PUB.add;
1096: x_return_status := FND_API.g_ret_sts_error;
1097: RETURN;
1098: END IF;
1099:

Line 1105: FND_MSG_PUB.add;

1101: IF p_prgm_pmt_mode_rec.geo_hierarchy_id = FND_API.g_miss_num OR
1102: p_prgm_pmt_mode_rec.geo_hierarchy_id IS NULL THEN
1103: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1104: FND_MESSAGE.set_token('COLUMN','geo_hierarchy_id');
1105: FND_MSG_PUB.add;
1106: x_return_status := FND_API.g_ret_sts_error;
1107: RETURN;
1108: END IF;
1109:

Line 1115: FND_MSG_PUB.add;

1111: IF p_prgm_pmt_mode_rec.mode_of_payment = FND_API.g_miss_char OR
1112: p_prgm_pmt_mode_rec.mode_of_payment IS NULL THEN
1113: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1114: FND_MESSAGE.set_token('COLUMN','MODE_OF_PAYMENT');
1115: FND_MSG_PUB.add;
1116: x_return_status := FND_API.g_ret_sts_error;
1117: RETURN;
1118: END IF;
1119:

Line 1124: FND_MSG_PUB.add;

1120: IF p_prgm_pmt_mode_rec.mode_type = FND_API.g_miss_char OR
1121: p_prgm_pmt_mode_rec.mode_type IS NULL THEN
1122: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1123: FND_MESSAGE.set_token('COLUMN','mode_type');
1124: FND_MSG_PUB.add;
1125: x_return_status := FND_API.g_ret_sts_error;
1126: RETURN;
1127: END IF;
1128:

Line 1133: FND_MSG_PUB.add;

1129: IF p_prgm_pmt_mode_rec.last_update_date = FND_API.g_miss_date OR
1130: p_prgm_pmt_mode_rec.last_update_date IS NULL THEN
1131: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1132: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
1133: FND_MSG_PUB.add;
1134: x_return_status := FND_API.g_ret_sts_error;
1135: RETURN;
1136: END IF;
1137:

Line 1143: FND_MSG_PUB.add;

1139: IF p_prgm_pmt_mode_rec.last_updated_by = FND_API.g_miss_num OR
1140: p_prgm_pmt_mode_rec.last_updated_by IS NULL THEN
1141: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1142: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
1143: FND_MSG_PUB.add;
1144: x_return_status := FND_API.g_ret_sts_error;
1145: RETURN;
1146: END IF;
1147:

Line 1153: FND_MSG_PUB.add;

1149: IF p_prgm_pmt_mode_rec.creation_date = FND_API.g_miss_date OR
1150: p_prgm_pmt_mode_rec.creation_date IS NULL THEN
1151: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1152: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
1153: FND_MSG_PUB.add;
1154: x_return_status := FND_API.g_ret_sts_error;
1155: RETURN;
1156: END IF;
1157:

Line 1168: FND_MSG_PUB.add;

1164: IF p_prgm_pmt_mode_rec.created_by = FND_API.g_miss_num OR
1165: p_prgm_pmt_mode_rec.created_by IS NULL THEN
1166: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1167: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
1168: FND_MSG_PUB.add;
1169: x_return_status := FND_API.g_ret_sts_error;
1170: RETURN;
1171: END IF;
1172:

Line 1178: FND_MSG_PUB.add;

1174: IF p_prgm_pmt_mode_rec.last_update_login = FND_API.g_miss_num OR
1175: p_prgm_pmt_mode_rec.last_update_login IS NULL THEN
1176: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1177: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
1178: FND_MSG_PUB.add;
1179: x_return_status := FND_API.g_ret_sts_error;
1180: RETURN;
1181: END IF;
1182:

Line 1188: FND_MSG_PUB.add;

1184: IF p_prgm_pmt_mode_rec.object_version_number = FND_API.g_miss_num OR
1185: p_prgm_pmt_mode_rec.object_version_number IS NULL THEN
1186: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1187: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1188: FND_MSG_PUB.add;
1189: x_return_status := FND_API.g_ret_sts_error;
1190: RETURN;
1191: END IF;
1192: ELSE

Line 1197: FND_MSG_PUB.add;

1193:
1194: IF p_prgm_pmt_mode_rec.program_payment_mode_id IS NULL THEN
1195: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1196: FND_MESSAGE.set_token('COLUMN','PROGRAM_PAYMENT_MODE_ID');
1197: FND_MSG_PUB.add;
1198: x_return_status := FND_API.g_ret_sts_error;
1199: RETURN;
1200: END IF;
1201:

Line 1205: FND_MSG_PUB.add;

1201:
1202: IF p_prgm_pmt_mode_rec.object_version_number IS NULL THEN
1203: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1204: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1205: FND_MSG_PUB.add;
1206: x_return_status := FND_API.g_ret_sts_error;
1207: RETURN;
1208: END IF;
1209: END IF;

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

1240: PVX_utility_PVT.g_number, -- datatype of fk
1241: NULL
1242: ) = FND_API.g_false
1243: THEN
1244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1245: THEN
1246: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PARTNER_PROGRAM');
1247: FND_MSG_PUB.add;
1248: END IF;

Line 1247: FND_MSG_PUB.add;

1243: THEN
1244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1245: THEN
1246: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PARTNER_PROGRAM');
1247: FND_MSG_PUB.add;
1248: END IF;
1249:
1250: x_return_status := FND_API.g_ret_sts_error;
1251: RETURN;

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

1277: PVX_UTILITY_PVT.g_number, -- datatype of fk
1278: NULL
1279: ) = FND_API.g_false
1280: THEN
1281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1282: THEN
1283: FND_MESSAGE.set_name('PV', 'PV_NOT_A_GEO_HIERARCHY');
1284: FND_MSG_PUB.add;
1285: END IF;

Line 1284: FND_MSG_PUB.add;

1280: THEN
1281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1282: THEN
1283: FND_MESSAGE.set_name('PV', 'PV_NOT_A_GEO_HIERARCHY');
1284: FND_MSG_PUB.add;
1285: END IF;
1286:
1287: x_return_status := FND_API.g_ret_sts_error;
1288: RETURN;

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

1308: 'PV_MODE_TYPE', -- Lookup Type
1309: p_prgm_pmt_mode_rec.mode_type -- Lookup Code
1310: ) = FND_API.g_false
1311: THEN
1312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1313: THEN
1314: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_MODE_TYPE');
1315: FND_MSG_PUB.add;
1316: END IF;

Line 1315: FND_MSG_PUB.add;

1311: THEN
1312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1313: THEN
1314: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_MODE_TYPE');
1315: FND_MSG_PUB.add;
1316: END IF;
1317: x_return_status := FND_API.g_ret_sts_error;
1318: RETURN;
1319:

Line 1589: FND_MSG_PUB.initialize;

1585: END IF;
1586:
1587: -- Initialize message list if p_init_msg_list is set to TRUE.
1588: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1589: FND_MSG_PUB.initialize;
1590: END IF;
1591:
1592: -- Debug Message
1593: IF (PV_DEBUG_HIGH_ON) THEN

Line 1649: FND_MSG_PUB.Count_And_Get

1645: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
1646: END IF;
1647:
1648: -- Standard call to get message count and if count is 1, get message info.
1649: FND_MSG_PUB.Count_And_Get
1650: ( p_encoded => FND_API.G_FALSE,
1651: p_count => x_msg_count,
1652: p_data => x_msg_data
1653: );

Line 1660: FND_MSG_PUB.Count_And_Get (

1656: WHEN FND_API.G_EXC_ERROR THEN
1657: ROLLBACK TO Validate_Prgm_Pmt_Mode_;
1658: x_return_status := FND_API.G_RET_STS_ERROR;
1659: -- Standard call to get message count and if count=1, get the message
1660: FND_MSG_PUB.Count_And_Get (
1661: p_encoded => FND_API.G_FALSE
1662: ,p_count => x_msg_count
1663: ,p_data => x_msg_data
1664: );

Line 1670: FND_MSG_PUB.Count_And_Get (

1666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1667: ROLLBACK TO Validate_Prgm_Pmt_Mode_;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1669: -- Standard call to get message count and if count=1, get the message
1670: FND_MSG_PUB.Count_And_Get (
1671: p_encoded => FND_API.G_FALSE
1672: ,p_count => x_msg_count
1673: ,p_data => x_msg_data
1674: );

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

1675:
1676: WHEN OTHERS THEN
1677: ROLLBACK TO Validate_Prgm_Pmt_Mode_;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1680: THEN
1681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1682: END IF;
1683: -- Standard call to get message count and if count=1, get the message

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

1677: ROLLBACK TO Validate_Prgm_Pmt_Mode_;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1680: THEN
1681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1682: END IF;
1683: -- Standard call to get message count and if count=1, get the message
1684: FND_MSG_PUB.Count_And_Get (
1685: p_encoded => FND_API.G_FALSE

Line 1684: FND_MSG_PUB.Count_And_Get (

1680: THEN
1681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1682: END IF;
1683: -- Standard call to get message count and if count=1, get the message
1684: FND_MSG_PUB.Count_And_Get (
1685: p_encoded => FND_API.G_FALSE
1686: ,p_count => x_msg_count
1687: ,p_data => x_msg_data
1688: );

Line 1708: FND_MSG_PUB.initialize;

1704: BEGIN
1705: -- Initialize message list if p_init_msg_list is set to TRUE.
1706: IF FND_API.to_Boolean( p_init_msg_list )
1707: THEN
1708: FND_MSG_PUB.initialize;
1709: END IF;
1710:
1711: -- Initialize API return status to SUCCESS
1712: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1726: FND_MSG_PUB.Count_And_Get (

1722: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1723: END IF;
1724:
1725: -- Standard call to get message count and if count is 1, get message info.
1726: FND_MSG_PUB.Count_And_Get (
1727: p_count => x_msg_count
1728: ,p_data => x_msg_data
1729: );
1730: