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

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

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_USER_MGMT_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvummb.pls';
6:
7: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11:

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

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_USER_MGMT_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvummb.pls';
6:
7: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11:
12: PROCEDURE create_user_resource

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

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvummb.pls';
6:
7: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11:
12: PROCEDURE create_user_resource
13: (

Line 122: FND_MSG_PUB.initialize;

118:
119: -- Initialize message list if p_init_msg_list is set to TRUE.
120: IF FND_API.to_Boolean( p_init_msg_list )
121: THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124:
125: -- Standard call to check for call compatibility.
126: IF NOT FND_API.Compatible_API_Call (

Line 149: fnd_msg_pub.ADD;

145:
146:
147: IF (p_partner_user_rec.person_rel_party_id IS NULL or p_partner_user_rec.person_rel_party_id = FND_API.G_MISS_NUM) THEN
148: fnd_message.SET_NAME ('PV', 'PV_MISSING_PERSON_REL_ID');
149: fnd_msg_pub.ADD;
150: raise FND_API.G_EXC_ERROR;
151: END IF;
152:
153: open c_get_user_details(p_partner_user_rec.person_rel_party_id);

Line 157: fnd_msg_pub.ADD;

153: open c_get_user_details(p_partner_user_rec.person_rel_party_id);
154: fetch c_get_user_details into l_partner_id, l_partner_group_id, l_person_first_name, l_person_last_name,l_org_contact_id, l_org_party_name;
155: if (c_get_user_details%NOTFOUND) THEN
156: fnd_message.SET_NAME ('PV', 'PV_INVALID_PARTNER');
157: fnd_msg_pub.ADD;
158: raise FND_API.G_EXC_ERROR;
159: END IF;
160: close c_get_user_details;
161:

Line 378: fnd_msg_pub.ADD;

374: X_LEVEL_VALUE => p_partner_user_rec.user_ID);
375:
376: If (not l_profile_saved) THEN
377: fnd_message.SET_NAME ('PV', 'PV_PROFILE_NOT_EXISTS');
378: fnd_msg_pub.ADD;
379: raise FND_API.G_EXC_ERROR;
380: END IF;
381:
382:

Line 384: FND_MSG_PUB.Count_And_Get

380: END IF;
381:
382:
383:
384: FND_MSG_PUB.Count_And_Get
385: ( p_encoded => FND_API.G_FALSE,
386: p_count => x_msg_count,
387: p_data => x_msg_data
388: );

Line 398: FND_MSG_PUB.Count_And_Get (

394: EXCEPTION
395: WHEN FND_API.G_EXC_ERROR THEN
396: ROLLBACK TO create_user_resource;
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: FND_MSG_PUB.Count_And_Get (
399: p_encoded => FND_API.G_FALSE
400: ,p_count => x_msg_count
401: ,p_data => x_msg_data
402: );

Line 409: FND_MSG_PUB.Count_And_Get (

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

Line 418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

414:
415: WHEN OTHERS THEN
416: ROLLBACK TO create_user_resource;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
420: END IF;
421: FND_MSG_PUB.Count_And_Get (
422: p_encoded => FND_API.G_FALSE

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

415: WHEN OTHERS THEN
416: ROLLBACK TO create_user_resource;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
420: END IF;
421: FND_MSG_PUB.Count_And_Get (
422: p_encoded => FND_API.G_FALSE
423: ,p_count => x_msg_count

Line 421: FND_MSG_PUB.Count_And_Get (

417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
420: END IF;
421: FND_MSG_PUB.Count_And_Get (
422: p_encoded => FND_API.G_FALSE
423: ,p_count => x_msg_count
424: ,p_data => x_msg_data
425: );

Line 494: FND_MSG_PUB.initialize;

490:
491: -- Initialize message list if p_init_msg_list is set to TRUE.
492: IF FND_API.to_Boolean( p_init_msg_list )
493: THEN
494: FND_MSG_PUB.initialize;
495: END IF;
496:
497: -- Standard call to check for call compatibility.
498: IF NOT FND_API.Compatible_API_Call (

Line 520: FND_MSG_PUB.add;

516: -------------End Of Initialize -------------------------------
517:
518: IF FND_GLOBAL.User_Id IS NULL THEN
519: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
520: FND_MSG_PUB.add;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524:

Line 527: fnd_msg_pub.ADD;

523:
524:
525: IF P_partner_type IS NULL THEN
526: fnd_message.SET_NAME ('PV', 'PV_MISSING_PRTNR_TYPE');
527: fnd_msg_pub.ADD;
528: raise FND_API.G_EXC_ERROR;
529: END IF;
530:
531: IF (p_partner_rec.partner_party_id IS NULL or p_partner_rec.partner_party_id = FND_API.G_MISS_NUM) THEN

Line 533: fnd_msg_pub.ADD;

529: END IF;
530:
531: IF (p_partner_rec.partner_party_id IS NULL or p_partner_rec.partner_party_id = FND_API.G_MISS_NUM) THEN
532: fnd_message.SET_NAME ('PV', 'PV_MISSING_ORGZN_ID');
533: fnd_msg_pub.ADD;
534: raise FND_API.G_EXC_ERROR;
535: END IF;
536:
537: IF (p_partner_rec.member_type IS NULL or p_partner_rec.member_type = FND_API.G_MISS_CHAR) THEN

Line 539: fnd_msg_pub.ADD;

535: END IF;
536:
537: IF (p_partner_rec.member_type IS NULL or p_partner_rec.member_type = FND_API.G_MISS_CHAR) THEN
538: fnd_message.SET_NAME ('PV', 'PV_MISSING_MEMBER_TYPE');
539: fnd_msg_pub.ADD;
540: raise FND_API.G_EXC_ERROR;
541: END IF;
542:
543: IF (p_partner_user_rec.user_id IS NULL or p_partner_user_rec.user_id = FND_API.G_MISS_NUM) THEN

Line 545: fnd_msg_pub.ADD;

541: END IF;
542:
543: IF (p_partner_user_rec.user_id IS NULL or p_partner_user_rec.user_id = FND_API.G_MISS_NUM) THEN
544: fnd_message.SET_NAME ('PV', 'PV_MISSING_USER_ID');
545: fnd_msg_pub.ADD;
546: raise FND_API.G_EXC_ERROR;
547: END IF;
548:
549:

Line 553: fnd_msg_pub.ADD;

549:
550: if(p_partner_rec.member_type = 'SUBSIDIARY') THEN
551: IF(p_partner_rec.global_prtnr_org_number IS NULL OR p_partner_rec.global_prtnr_org_number = FND_API.G_MISS_CHAR) THEN
552: fnd_message.SET_NAME ('PV', 'PV_MISSING_GLOBAL_ID');
553: fnd_msg_pub.ADD;
554: raise FND_API.G_EXC_ERROR;
555: ELSE
556: l_global_partner_id := Pv_ptr_member_type_pvt.get_global_partner_id(p_global_prtnr_org_number => p_partner_rec.global_prtnr_org_number);
557: END IF;

Line 562: fnd_msg_pub.ADD;

558: END IF;
559:
560: IF (p_partner_user_rec.user_type_id IS NULL or p_partner_user_rec.user_type_id = FND_API.G_MISS_NUM) THEN
561: fnd_message.SET_NAME ('PV', 'PV_MISSING_USERTYPE_ID');
562: fnd_msg_pub.ADD;
563: raise FND_API.G_EXC_ERROR;
564: END IF;
565:
566:

Line 577: fnd_msg_pub.ADD;

573: END LOOP;
574:
575: IF((not is_partner_user) or (not is_primary_user)) THEN
576: fnd_message.SET_NAME ('PV', 'PV_NOT_PRTNR_PRIMARY_USER');
577: fnd_msg_pub.ADD;
578: raise FND_API.G_EXC_ERROR;
579: END IF;
580:
581: l_partner_types_tbl(1).attr_value := P_partner_type;

Line 612: FND_MSG_PUB.Count_And_Get

608: END IF;
609:
610:
611:
612: FND_MSG_PUB.Count_And_Get
613: ( p_encoded => FND_API.G_FALSE,
614: p_count => x_msg_count,
615: p_data => x_msg_data
616: );

Line 626: FND_MSG_PUB.Count_And_Get (

622: EXCEPTION
623: WHEN FND_API.G_EXC_ERROR THEN
624: ROLLBACK TO Register_Partner_And_User;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: FND_MSG_PUB.Count_And_Get (
627: p_encoded => FND_API.G_FALSE
628: ,p_count => x_msg_count
629: ,p_data => x_msg_data
630: );

Line 637: FND_MSG_PUB.Count_And_Get (

633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: ROLLBACK TO Register_Partner_And_User;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: -- Standard call to get message count and if count=1, get the message
637: FND_MSG_PUB.Count_And_Get (
638: p_encoded => FND_API.G_FALSE
639: ,p_count => x_msg_count
640: ,p_data => x_msg_data
641: );

Line 646: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

642:
643: WHEN OTHERS THEN
644: ROLLBACK TO Register_Partner_And_User;
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
646: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
647: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
648: END IF;
649: FND_MSG_PUB.Count_And_Get (
650: p_encoded => FND_API.G_FALSE

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

643: WHEN OTHERS THEN
644: ROLLBACK TO Register_Partner_And_User;
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
646: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
647: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
648: END IF;
649: FND_MSG_PUB.Count_And_Get (
650: p_encoded => FND_API.G_FALSE
651: ,p_count => x_msg_count

Line 649: FND_MSG_PUB.Count_And_Get (

645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
646: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
647: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
648: END IF;
649: FND_MSG_PUB.Count_And_Get (
650: p_encoded => FND_API.G_FALSE
651: ,p_count => x_msg_count
652: ,p_data => x_msg_data
653: );

Line 714: FND_MSG_PUB.initialize;

710:
711: -- Initialize message list if p_init_msg_list is set to TRUE.
712: IF FND_API.to_Boolean( p_init_msg_list )
713: THEN
714: FND_MSG_PUB.initialize;
715: END IF;
716:
717: -- Standard call to check for call compatibility.
718: IF NOT FND_API.Compatible_API_Call (

Line 742: FND_MSG_PUB.add;

738:
739:
740: IF FND_GLOBAL.User_Id IS NULL THEN
741: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
742: FND_MSG_PUB.add;
743: RAISE FND_API.G_EXC_ERROR;
744: END IF;
745:
746: IF (p_partner_user_rec.user_id IS NULL or p_partner_user_rec.user_id = FND_API.G_MISS_NUM) THEN

Line 748: fnd_msg_pub.ADD;

744: END IF;
745:
746: IF (p_partner_user_rec.user_id IS NULL or p_partner_user_rec.user_id = FND_API.G_MISS_NUM) THEN
747: fnd_message.SET_NAME ('PV', 'PV_MISSING_USER_ID');
748: fnd_msg_pub.ADD;
749: raise FND_API.G_EXC_ERROR;
750: END IF;
751:
752: IF (p_partner_user_rec.user_type_id IS NULL or p_partner_user_rec.user_type_id = FND_API.G_MISS_NUM) THEN

Line 754: fnd_msg_pub.ADD;

750: END IF;
751:
752: IF (p_partner_user_rec.user_type_id IS NULL or p_partner_user_rec.user_type_id = FND_API.G_MISS_NUM) THEN
753: fnd_message.SET_NAME ('PV', 'PV_MISSING_USERTYPE_ID');
754: fnd_msg_pub.ADD;
755: raise FND_API.G_EXC_ERROR;
756: END IF;
757:
758:

Line 769: fnd_msg_pub.ADD;

765: END LOOP;
766:
767: IF(not is_partner_user) THEN
768: fnd_message.SET_NAME ('PV', 'PV_NOT_PRTNR_USER');
769: fnd_msg_pub.ADD;
770: raise FND_API.G_EXC_ERROR;
771: END IF;
772:
773: create_user_resource(

Line 814: FND_MSG_PUB.Count_And_Get

810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:
813:
814: FND_MSG_PUB.Count_And_Get
815: ( p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data
818: );

Line 828: FND_MSG_PUB.Count_And_Get (

824: EXCEPTION
825: WHEN FND_API.G_EXC_ERROR THEN
826: ROLLBACK TO register_partner_user;
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: FND_MSG_PUB.Count_And_Get (
829: p_encoded => FND_API.G_FALSE
830: ,p_count => x_msg_count
831: ,p_data => x_msg_data
832: );

Line 839: FND_MSG_PUB.Count_And_Get (

835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: ROLLBACK TO register_partner_user;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: -- Standard call to get message count and if count=1, get the message
839: FND_MSG_PUB.Count_And_Get (
840: p_encoded => FND_API.G_FALSE
841: ,p_count => x_msg_count
842: ,p_data => x_msg_data
843: );

Line 848: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

844:
845: WHEN OTHERS THEN
846: ROLLBACK TO register_partner_user;
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
850: END IF;
851: FND_MSG_PUB.Count_And_Get (
852: p_encoded => FND_API.G_FALSE

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

845: WHEN OTHERS THEN
846: ROLLBACK TO register_partner_user;
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
850: END IF;
851: FND_MSG_PUB.Count_And_Get (
852: p_encoded => FND_API.G_FALSE
853: ,p_count => x_msg_count

Line 851: FND_MSG_PUB.Count_And_Get (

847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
850: END IF;
851: FND_MSG_PUB.Count_And_Get (
852: p_encoded => FND_API.G_FALSE
853: ,p_count => x_msg_count
854: ,p_data => x_msg_data
855: );

Line 930: FND_MSG_PUB.initialize;

926:
927: -- Initialize message list if p_init_msg_list is set to TRUE.
928: IF FND_API.to_Boolean( p_init_msg_list )
929: THEN
930: FND_MSG_PUB.initialize;
931: END IF;
932:
933: -- Standard call to check for call compatibility.
934: IF NOT FND_API.Compatible_API_Call (

Line 958: FND_MSG_PUB.add;

954:
955:
956: IF FND_GLOBAL.User_Id IS NULL THEN
957: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
958: FND_MSG_PUB.add;
959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961:
962: IF (p_role_name.count < 1) THEN

Line 964: fnd_msg_pub.ADD;

960: END IF;
961:
962: IF (p_role_name.count < 1) THEN
963: fnd_message.SET_NAME ('PV', 'PV_MISSING_ROLE_NAME');
964: fnd_msg_pub.ADD;
965: raise FND_API.G_EXC_ERROR;
966: END IF;
967:
968: IF (p_user_name IS NULL or p_user_name = FND_API.G_MISS_CHAR) THEN

Line 970: fnd_msg_pub.ADD;

966: END IF;
967:
968: IF (p_user_name IS NULL or p_user_name = FND_API.G_MISS_CHAR) THEN
969: fnd_message.SET_NAME ('PV', 'PV_MISSING_USER_NAME');
970: fnd_msg_pub.ADD;
971: raise FND_API.G_EXC_ERROR;
972: END IF;
973:
974: /** Check if partner or primary permissions are part of the current role. IF NOT, we do not need to do any thing **/

Line 1053: FND_MSG_PUB.Count_And_Get

1049:
1050: END IF;
1051: end if;
1052:
1053: FND_MSG_PUB.Count_And_Get
1054: ( p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );

Line 1067: FND_MSG_PUB.Count_And_Get (

1063: EXCEPTION
1064: WHEN FND_API.G_EXC_ERROR THEN
1065: ROLLBACK TO revoke_role;
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: FND_MSG_PUB.Count_And_Get (
1068: p_encoded => FND_API.G_FALSE
1069: ,p_count => x_msg_count
1070: ,p_data => x_msg_data
1071: );

Line 1078: FND_MSG_PUB.Count_And_Get (

1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075: ROLLBACK TO revoke_role;
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: -- Standard call to get message count and if count=1, get the message
1078: FND_MSG_PUB.Count_And_Get (
1079: p_encoded => FND_API.G_FALSE
1080: ,p_count => x_msg_count
1081: ,p_data => x_msg_data
1082: );

Line 1087: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1083:
1084: WHEN OTHERS THEN
1085: ROLLBACK TO revoke_role;
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1088: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1089: END IF;
1090: FND_MSG_PUB.Count_And_Get (
1091: p_encoded => FND_API.G_FALSE

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

1084: WHEN OTHERS THEN
1085: ROLLBACK TO revoke_role;
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1088: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1089: END IF;
1090: FND_MSG_PUB.Count_And_Get (
1091: p_encoded => FND_API.G_FALSE
1092: ,p_count => x_msg_count

Line 1090: FND_MSG_PUB.Count_And_Get (

1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1088: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1089: END IF;
1090: FND_MSG_PUB.Count_And_Get (
1091: p_encoded => FND_API.G_FALSE
1092: ,p_count => x_msg_count
1093: ,p_data => x_msg_data
1094: );

Line 1181: FND_MSG_PUB.initialize;

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

Line 1209: FND_MSG_PUB.add;

1205:
1206:
1207: IF FND_GLOBAL.User_Id IS NULL THEN
1208: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
1209: FND_MSG_PUB.add;
1210: RAISE FND_API.G_EXC_ERROR;
1211: END IF;
1212:
1213: IF (p_role_name.count < 1) THEN

Line 1215: fnd_msg_pub.ADD;

1211: END IF;
1212:
1213: IF (p_role_name.count < 1) THEN
1214: fnd_message.SET_NAME ('PV', 'PV_MISSING_ROLE_NAME');
1215: fnd_msg_pub.ADD;
1216: raise FND_API.G_EXC_ERROR;
1217: END IF;
1218:
1219: /** Check if partner or primary permissions are part of the current role. IF NOT, we do not need to do any thing **/

Line 1331: FND_MSG_PUB.Count_And_Get

1327:
1328: END IF;
1329: END IF;
1330:
1331: FND_MSG_PUB.Count_And_Get
1332: ( p_encoded => FND_API.G_FALSE,
1333: p_count => x_msg_count,
1334: p_data => x_msg_data
1335: );

Line 1345: FND_MSG_PUB.Count_And_Get (

1341: EXCEPTION
1342: WHEN FND_API.G_EXC_ERROR THEN
1343: ROLLBACK TO delete_role;
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: FND_MSG_PUB.Count_And_Get (
1346: p_encoded => FND_API.G_FALSE
1347: ,p_count => x_msg_count
1348: ,p_data => x_msg_data
1349: );

Line 1356: FND_MSG_PUB.Count_And_Get (

1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1353: ROLLBACK TO delete_role;
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: -- Standard call to get message count and if count=1, get the message
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 1365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1361:
1362: WHEN OTHERS THEN
1363: ROLLBACK TO delete_role;
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1366: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1367: END IF;
1368: FND_MSG_PUB.Count_And_Get (
1369: p_encoded => FND_API.G_FALSE

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

1362: WHEN OTHERS THEN
1363: ROLLBACK TO delete_role;
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1366: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1367: END IF;
1368: FND_MSG_PUB.Count_And_Get (
1369: p_encoded => FND_API.G_FALSE
1370: ,p_count => x_msg_count

Line 1368: FND_MSG_PUB.Count_And_Get (

1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1366: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1367: END IF;
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 1448: FND_MSG_PUB.initialize;

1444:
1445: -- Initialize message list if p_init_msg_list is set to TRUE.
1446: IF FND_API.to_Boolean( p_init_msg_list )
1447: THEN
1448: FND_MSG_PUB.initialize;
1449: END IF;
1450:
1451: -- Standard call to check for call compatibility.
1452: IF NOT FND_API.Compatible_API_Call (

Line 1476: FND_MSG_PUB.add;

1472:
1473:
1474: IF FND_GLOBAL.User_Id IS NULL THEN
1475: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
1476: FND_MSG_PUB.add;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480: IF (p_role_name.count < 1) THEN

Line 1482: fnd_msg_pub.ADD;

1478: END IF;
1479:
1480: IF (p_role_name.count < 1) THEN
1481: fnd_message.SET_NAME ('PV', 'PV_MISSING_ROLE_NAME');
1482: fnd_msg_pub.ADD;
1483: raise FND_API.G_EXC_ERROR;
1484: END IF;
1485:
1486: IF (p_user_name IS NULL or p_user_name = FND_API.G_MISS_CHAR) THEN

Line 1488: fnd_msg_pub.ADD;

1484: END IF;
1485:
1486: IF (p_user_name IS NULL or p_user_name = FND_API.G_MISS_CHAR) THEN
1487: fnd_message.SET_NAME ('PV', 'PV_MISSING_USER_NAME');
1488: fnd_msg_pub.ADD;
1489: raise FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: /** check if current roles that are being assigned has G_PARTNER_PERMISSION OR G_PRIMARY_PERMISSION permissions **/

Line 1524: fnd_msg_pub.ADD;

1520: END LOOP;
1521:
1522: IF (NOT isValidPrtnrUser) THEN
1523: fnd_message.SET_NAME ('PV', 'PV_INVALID_PTNR_USER');
1524: fnd_msg_pub.ADD;
1525: raise FND_API.G_EXC_ERROR;
1526: END IF;
1527:
1528: IF(is_primary_perm_assigned OR is_primary_user) THEN

Line 1574: FND_MSG_PUB.Count_And_Get

1570:
1571: END IF;
1572: END IF;
1573:
1574: FND_MSG_PUB.Count_And_Get
1575: ( p_encoded => FND_API.G_FALSE,
1576: p_count => x_msg_count,
1577: p_data => x_msg_data
1578: );

Line 1588: FND_MSG_PUB.Count_And_Get (

1584: EXCEPTION
1585: WHEN FND_API.G_EXC_ERROR THEN
1586: ROLLBACK TO assign_role;
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: FND_MSG_PUB.Count_And_Get (
1589: p_encoded => FND_API.G_FALSE
1590: ,p_count => x_msg_count
1591: ,p_data => x_msg_data
1592: );

Line 1599: FND_MSG_PUB.Count_And_Get (

1595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1596: ROLLBACK TO assign_role;
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1598: -- Standard call to get message count and if count=1, get the message
1599: FND_MSG_PUB.Count_And_Get (
1600: p_encoded => FND_API.G_FALSE
1601: ,p_count => x_msg_count
1602: ,p_data => x_msg_data
1603: );

Line 1608: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1604:
1605: WHEN OTHERS THEN
1606: ROLLBACK TO assign_role;
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1608: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1609: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1610: END IF;
1611: FND_MSG_PUB.Count_And_Get (
1612: p_encoded => FND_API.G_FALSE

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

1605: WHEN OTHERS THEN
1606: ROLLBACK TO assign_role;
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1608: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1609: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1610: END IF;
1611: FND_MSG_PUB.Count_And_Get (
1612: p_encoded => FND_API.G_FALSE
1613: ,p_count => x_msg_count

Line 1611: FND_MSG_PUB.Count_And_Get (

1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1608: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1609: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1610: END IF;
1611: FND_MSG_PUB.Count_And_Get (
1612: p_encoded => FND_API.G_FALSE
1613: ,p_count => x_msg_count
1614: ,p_data => x_msg_data
1615: );

Line 1705: FND_MSG_PUB.initialize;

1701:
1702: -- Initialize message list if p_init_msg_list is set to TRUE.
1703: IF FND_API.to_Boolean( p_init_msg_list )
1704: THEN
1705: FND_MSG_PUB.initialize;
1706: END IF;
1707:
1708: -- Standard call to check for call compatibility.
1709: IF NOT FND_API.Compatible_API_Call (

Line 1733: FND_MSG_PUB.add;

1729:
1730:
1731: IF FND_GLOBAL.User_Id IS NULL THEN
1732: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
1733: FND_MSG_PUB.add;
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;
1736:
1737: IF (p_role_name IS NULL or p_role_name = FND_API.G_MISS_CHAR) THEN

Line 1739: fnd_msg_pub.ADD;

1735: END IF;
1736:
1737: IF (p_role_name IS NULL or p_role_name = FND_API.G_MISS_CHAR) THEN
1738: fnd_message.SET_NAME ('PV', 'PV_MISSING_ROLE_NAME');
1739: fnd_msg_pub.ADD;
1740: raise FND_API.G_EXC_ERROR;
1741: END IF;
1742:
1743: IF (p_assigned_perms IS NOT NULL and p_assigned_perms.count > 0) THEN

Line 1932: FND_MSG_PUB.Count_And_Get

1928:
1929:
1930:
1931:
1932: FND_MSG_PUB.Count_And_Get
1933: ( p_encoded => FND_API.G_FALSE,
1934: p_count => x_msg_count,
1935: p_data => x_msg_data
1936: );

Line 1946: FND_MSG_PUB.Count_And_Get (

1942: EXCEPTION
1943: WHEN FND_API.G_EXC_ERROR THEN
1944: ROLLBACK TO update_role;
1945: x_return_status := FND_API.G_RET_STS_ERROR;
1946: FND_MSG_PUB.Count_And_Get (
1947: p_encoded => FND_API.G_FALSE
1948: ,p_count => x_msg_count
1949: ,p_data => x_msg_data
1950: );

Line 1957: FND_MSG_PUB.Count_And_Get (

1953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1954: ROLLBACK TO update_role;
1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1956: -- Standard call to get message count and if count=1, get the message
1957: FND_MSG_PUB.Count_And_Get (
1958: p_encoded => FND_API.G_FALSE
1959: ,p_count => x_msg_count
1960: ,p_data => x_msg_data
1961: );

Line 1966: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1962:
1963: WHEN OTHERS THEN
1964: ROLLBACK TO update_role;
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1967: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1968: END IF;
1969: FND_MSG_PUB.Count_And_Get (
1970: p_encoded => FND_API.G_FALSE

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

1963: WHEN OTHERS THEN
1964: ROLLBACK TO update_role;
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1967: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1968: END IF;
1969: FND_MSG_PUB.Count_And_Get (
1970: p_encoded => FND_API.G_FALSE
1971: ,p_count => x_msg_count

Line 1969: FND_MSG_PUB.Count_And_Get (

1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1967: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1968: END IF;
1969: FND_MSG_PUB.Count_And_Get (
1970: p_encoded => FND_API.G_FALSE
1971: ,p_count => x_msg_count
1972: ,p_data => x_msg_data
1973: );

Line 2100: FND_MSG_PUB.initialize;

2096: );
2097:
2098: BEGIN
2099:
2100: FND_MSG_PUB.initialize;
2101:
2102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
2104: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name

Line 2175: FND_MSG_PUB.Count_And_Get

2171: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2172: ,'after call pv_user_mgmt_pvt.register_partner_user: x_return_status='|| x_return_status || ',x_msg_count=' || to_char(x_msg_count));
2173: END IF;
2174:
2175: FND_MSG_PUB.Count_And_Get
2176: ( p_encoded => FND_API.G_FALSE,
2177: p_count => x_msg_count,
2178: p_data => x_msg_data
2179: );

Line 2196: fnd_msg_pub.get (

2192: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
2193: ,'x_return_status is not returning S');
2194: END IF;
2195: FOR k IN 1 .. x_msg_count LOOP
2196: fnd_msg_pub.get (
2197: p_msg_index => k
2198: ,p_encoded => FND_API.G_FALSE
2199: ,p_data => x_msg_data
2200: ,p_msg_index_out => x_msg_index);

Line 2470: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2466: END IF;
2467: END IF;
2468: END LOOP;
2469:
2470: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2471: IF (PV_DEBUG_HIGH_ON) THEN
2472: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
2473: END IF;
2474: END IF;

Line 2476: FND_MSG_PUB.Count_And_Get (

2472: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
2473: END IF;
2474: END IF;
2475:
2476: FND_MSG_PUB.Count_And_Get (
2477: p_encoded => FND_API.G_FALSE,
2478: p_count => x_msg_count,
2479: p_data => x_msg_data
2480: );

Line 2495: FND_MSG_PUB.Count_And_Get (

2491:
2492: WHEN FND_API.G_EXC_ERROR THEN
2493: x_return_status := FND_API.G_RET_STS_ERROR;
2494: -- Standard call to get message count and if count=1, get the message
2495: FND_MSG_PUB.Count_And_Get (
2496: p_encoded => FND_API.G_FALSE,
2497: p_count => x_msg_count,
2498: p_data => x_msg_data
2499: );

Line 2504: FND_MSG_PUB.Count_And_Get (

2500:
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2503: -- Standard call to get message count and if count=1, get the message
2504: FND_MSG_PUB.Count_And_Get (
2505: p_encoded => FND_API.G_FALSE,
2506: p_count => x_msg_count,
2507: p_data => x_msg_data
2508: );

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

2508: );
2509:
2510: WHEN OTHERS THEN
2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2512: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2513: THEN
2514: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2515: END IF;
2516: -- Standard call to get message count and if count=1, get the message

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

2510: WHEN OTHERS THEN
2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2512: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2513: THEN
2514: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2515: END IF;
2516: -- Standard call to get message count and if count=1, get the message
2517: FND_MSG_PUB.Count_And_Get (
2518: p_encoded => FND_API.G_FALSE,

Line 2517: FND_MSG_PUB.Count_And_Get (

2513: THEN
2514: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2515: END IF;
2516: -- Standard call to get message count and if count=1, get the message
2517: FND_MSG_PUB.Count_And_Get (
2518: p_encoded => FND_API.G_FALSE,
2519: p_count => x_msg_count,
2520: p_data => x_msg_data
2521: );