527: l_rowid VARCHAR2(30);
528:
529: BEGIN
530:
531: -- Standard Start of API savepoint
532: SAVEPOINT create_msite_prty_accss_pvt;
533:
534: -- Standard call to check for call compatibility.
535: IF NOT FND_API.Compatible_API_Call(l_api_version,
530:
531: -- Standard Start of API savepoint
532: SAVEPOINT create_msite_prty_accss_pvt;
533:
534: -- Standard call to check for call compatibility.
535: IF NOT FND_API.Compatible_API_Call(l_api_version,
536: p_api_version,
537: l_api_name,
538: G_PKG_NAME)
614:
615: --
616: -- End of main API body.
617:
618: -- Standard check of p_commit.
619: IF (FND_API.To_Boolean(p_commit)) THEN
620: COMMIT WORK;
621: END IF;
622:
619: IF (FND_API.To_Boolean(p_commit)) THEN
620: COMMIT WORK;
621: END IF;
622:
623: -- Standard call to get message count and if count is 1, get message info.
624: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
625: p_data => x_msg_data,
626: p_encoded => 'F');
627:
684: AND party_id = l_c_party_id;
685:
686: BEGIN
687:
688: -- Standard Start of API savepoint
689: SAVEPOINT update_msite_prty_accss_pvt;
690:
691: -- Standard call to check for call compatibility.
692: IF NOT FND_API.Compatible_API_Call(l_api_version,
687:
688: -- Standard Start of API savepoint
689: SAVEPOINT update_msite_prty_accss_pvt;
690:
691: -- Standard call to check for call compatibility.
692: IF NOT FND_API.Compatible_API_Call(l_api_version,
693: p_api_version,
694: l_api_name,
695: G_PKG_NAME)
796:
797: --
798: -- end of main api body.
799:
800: -- standard check of p_commit.
801: IF (FND_API.to_boolean(p_commit)) THEN
802: COMMIT WORK;
803: END IF;
804:
801: IF (FND_API.to_boolean(p_commit)) THEN
802: COMMIT WORK;
803: END IF;
804:
805: -- standard call to get message count and if count is 1, get message info.
806: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
807: p_data => x_msg_data,
808: p_encoded => 'F');
809:
863: AND party_id = l_c_party_id;
864:
865: BEGIN
866:
867: -- Standard Start of API savepoint
868: SAVEPOINT delete_msite_prty_accss_pvt;
869:
870: -- Standard call to check for call compatibility.
871: IF NOT FND_API.Compatible_API_Call(l_api_version,
866:
867: -- Standard Start of API savepoint
868: SAVEPOINT delete_msite_prty_accss_pvt;
869:
870: -- Standard call to check for call compatibility.
871: IF NOT FND_API.Compatible_API_Call(l_api_version,
872: p_api_version,
873: l_api_name,
874: G_PKG_NAME)