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 493: FND_MSG_PUB.initialize;

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

Line 519: FND_MSG_PUB.add;

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

Line 526: fnd_msg_pub.ADD;

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

Line 532: fnd_msg_pub.ADD;

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

Line 538: fnd_msg_pub.ADD;

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

Line 544: fnd_msg_pub.ADD;

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

Line 552: fnd_msg_pub.ADD;

548:
549: if(p_partner_rec.member_type = 'SUBSIDIARY') THEN
550: IF(p_partner_rec.global_prtnr_org_number IS NULL OR p_partner_rec.global_prtnr_org_number = FND_API.G_MISS_CHAR) THEN
551: fnd_message.SET_NAME ('PV', 'PV_MISSING_GLOBAL_ID');
552: fnd_msg_pub.ADD;
553: raise FND_API.G_EXC_ERROR;
554: ELSE
555: 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);
556: END IF;

Line 561: fnd_msg_pub.ADD;

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

Line 576: fnd_msg_pub.ADD;

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

Line 611: FND_MSG_PUB.Count_And_Get

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

Line 625: FND_MSG_PUB.Count_And_Get (

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

Line 636: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 648: FND_MSG_PUB.Count_And_Get (

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

Line 712: FND_MSG_PUB.initialize;

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

Line 740: FND_MSG_PUB.add;

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

Line 746: fnd_msg_pub.ADD;

742: END IF;
743:
744: IF (p_partner_user_rec.user_id IS NULL or p_partner_user_rec.user_id = FND_API.G_MISS_NUM) THEN
745: fnd_message.SET_NAME ('PV', 'PV_MISSING_USER_ID');
746: fnd_msg_pub.ADD;
747: raise FND_API.G_EXC_ERROR;
748: END IF;
749:
750: 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 752: fnd_msg_pub.ADD;

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

Line 767: fnd_msg_pub.ADD;

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

Line 812: FND_MSG_PUB.Count_And_Get

808: RAISE FND_API.G_EXC_ERROR;
809: END IF;
810:
811:
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 826: FND_MSG_PUB.Count_And_Get (

822: EXCEPTION
823: WHEN FND_API.G_EXC_ERROR THEN
824: ROLLBACK TO register_partner_user;
825: x_return_status := FND_API.G_RET_STS_ERROR;
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 837: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 849: FND_MSG_PUB.Count_And_Get (

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

Line 928: FND_MSG_PUB.initialize;

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

Line 956: FND_MSG_PUB.add;

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

Line 962: fnd_msg_pub.ADD;

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

Line 968: fnd_msg_pub.ADD;

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

Line 1051: FND_MSG_PUB.Count_And_Get

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

Line 1065: FND_MSG_PUB.Count_And_Get (

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

Line 1076: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1088: FND_MSG_PUB.Count_And_Get (

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

Line 1179: FND_MSG_PUB.initialize;

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

Line 1207: FND_MSG_PUB.add;

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

Line 1213: fnd_msg_pub.ADD;

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

Line 1329: FND_MSG_PUB.Count_And_Get

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

Line 1343: FND_MSG_PUB.Count_And_Get (

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

Line 1354: FND_MSG_PUB.Count_And_Get (

1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351: ROLLBACK TO delete_role;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353: -- Standard call to get message count and if count=1, get the message
1354: FND_MSG_PUB.Count_And_Get (
1355: p_encoded => FND_API.G_FALSE
1356: ,p_count => x_msg_count
1357: ,p_data => x_msg_data
1358: );

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

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

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

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

Line 1366: FND_MSG_PUB.Count_And_Get (

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

Line 1446: FND_MSG_PUB.initialize;

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

Line 1474: FND_MSG_PUB.add;

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

Line 1480: fnd_msg_pub.ADD;

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

Line 1486: fnd_msg_pub.ADD;

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

Line 1522: fnd_msg_pub.ADD;

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

Line 1572: FND_MSG_PUB.Count_And_Get

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

Line 1586: FND_MSG_PUB.Count_And_Get (

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

Line 1597: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1609: FND_MSG_PUB.Count_And_Get (

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

Line 1703: FND_MSG_PUB.initialize;

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

Line 1731: FND_MSG_PUB.add;

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

Line 1737: fnd_msg_pub.ADD;

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

Line 1930: FND_MSG_PUB.Count_And_Get

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

Line 1944: FND_MSG_PUB.Count_And_Get (

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

Line 1955: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1967: FND_MSG_PUB.Count_And_Get (

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

Line 2097: FND_MSG_PUB.initialize;

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

Line 2172: FND_MSG_PUB.Count_And_Get

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

Line 2193: fnd_msg_pub.get (

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

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

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

Line 2473: FND_MSG_PUB.Count_And_Get (

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

Line 2492: FND_MSG_PUB.Count_And_Get (

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

Line 2501: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 2514: FND_MSG_PUB.Count_And_Get (

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