606: l_rowid VARCHAR2(30);
607:
608: BEGIN
609:
610: -- Standard Start of API savepoint
611: SAVEPOINT create_msite_resp_pvt;
612:
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call(l_api_version,
609:
610: -- Standard Start of API savepoint
611: SAVEPOINT create_msite_resp_pvt;
612:
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call(l_api_version,
615: p_api_version,
616: l_api_name,
617: G_PKG_NAME)
700:
701: --
702: -- End of main API body.
703:
704: -- Standard check of p_commit.
705: IF (FND_API.To_Boolean(p_commit)) THEN
706: COMMIT WORK;
707: END IF;
708:
705: IF (FND_API.To_Boolean(p_commit)) THEN
706: COMMIT WORK;
707: END IF;
708:
709: -- Standard call to get message count and if count is 1, get message info.
710: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
711: p_data => x_msg_data,
712: p_encoded => 'F');
713: EXCEPTION
775: AND application_id = l_c_application_id;
776:
777: BEGIN
778:
779: -- Standard Start of API savepoint
780: SAVEPOINT update_msite_resp_pvt;
781:
782: -- Standard call to check for call compatibility.
783: IF NOT FND_API.Compatible_API_Call(l_api_version,
778:
779: -- Standard Start of API savepoint
780: SAVEPOINT update_msite_resp_pvt;
781:
782: -- Standard call to check for call compatibility.
783: IF NOT FND_API.Compatible_API_Call(l_api_version,
784: p_api_version,
785: l_api_name,
786: G_PKG_NAME)
895:
896: --
897: -- end of main api body.
898:
899: -- standard check of p_commit.
900: IF (FND_API.to_boolean(p_commit)) THEN
901: COMMIT WORK;
902: END IF;
903:
900: IF (FND_API.to_boolean(p_commit)) THEN
901: COMMIT WORK;
902: END IF;
903:
904: -- standard call to get message count and if count is 1, get message info.
905: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
906: p_data => x_msg_data,
907: p_encoded => 'F');
908:
965: AND application_id = l_c_application_id;
966:
967: BEGIN
968:
969: -- Standard Start of API savepoint
970: SAVEPOINT delete_msite_resp_pvt;
971:
972: -- Standard call to check for call compatibility.
973: IF NOT FND_API.Compatible_API_Call(l_api_version,
968:
969: -- Standard Start of API savepoint
970: SAVEPOINT delete_msite_resp_pvt;
971:
972: -- Standard call to check for call compatibility.
973: IF NOT FND_API.Compatible_API_Call(l_api_version,
974: p_api_version,
975: l_api_name,
976: G_PKG_NAME)
1107: WHERE msite_resp_id = l_msite_resp_id;
1108:
1109: BEGIN
1110:
1111: -- Standard Start of API savepoint
1112: SAVEPOINT delete_msite_resp_pvt;
1113:
1114: -- Standard call to check for call compatibility.
1115: IF NOT FND_API.Compatible_API_Call(l_api_version,
1110:
1111: -- Standard Start of API savepoint
1112: SAVEPOINT delete_msite_resp_pvt;
1113:
1114: -- Standard call to check for call compatibility.
1115: IF NOT FND_API.Compatible_API_Call(l_api_version,
1116: p_api_version,
1117: l_api_name,
1118: G_PKG_NAME)