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