45: -- EXCEPTIONS --
46: -- CSD_RSC_ASSOCIATION_EXISTS EXCEPTION;
47:
48: BEGIN
49: -- Standard Start of API savepoint
50: SAVEPOINT Create_RO_Service_Code;
51:
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call (lc_api_version,
48: BEGIN
49: -- Standard Start of API savepoint
50: SAVEPOINT Create_RO_Service_Code;
51:
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call (lc_api_version,
54: p_api_version,
55: lc_api_name ,
56: G_PKG_NAME )
226: end if;
227:
228: -- Api body ends here
229:
230: -- Standard check of p_commit.
231: IF FND_API.To_Boolean( p_commit ) THEN
232: COMMIT WORK;
233: END IF;
234:
231: IF FND_API.To_Boolean( p_commit ) THEN
232: COMMIT WORK;
233: END IF;
234:
235: -- Standard call to get message count and IF count is get message info.
236: FND_MSG_PUB.Count_And_Get
237: (p_count => x_msg_count,
238: p_data => x_msg_data );
239:
394: CSD_RSC_GET_OVN_ERROR EXCEPTION;
395: CSD_RSC_OVN_MISMATCH EXCEPTION;
396:
397: BEGIN
398: -- Standard Start of API savepoint
399: SAVEPOINT Update_RO_Service_Code;
400:
401: -- Standard call to check for call compatibility.
402: IF NOT FND_API.Compatible_API_Call (lc_api_version,
397: BEGIN
398: -- Standard Start of API savepoint
399: SAVEPOINT Update_RO_Service_Code;
400:
401: -- Standard call to check for call compatibility.
402: IF NOT FND_API.Compatible_API_Call (lc_api_version,
403: p_api_version,
404: lc_api_name ,
405: G_PKG_NAME )
620: end if;
621:
622: -- Api body ends here
623:
624: -- Standard check of p_commit.
625: IF FND_API.To_Boolean( p_commit ) THEN
626: COMMIT WORK;
627: END IF;
628:
625: IF FND_API.To_Boolean( p_commit ) THEN
626: COMMIT WORK;
627: END IF;
628:
629: -- Standard call to get message count and IF count is get message info.
630: FND_MSG_PUB.Count_And_Get
631: (p_count => x_msg_count,
632: p_data => x_msg_data );
633:
975: l_msg_data VARCHAR2(100);
976: l_msg_index NUMBER;
977:
978: BEGIN
979: -- Standard Start of API savepoint
980: SAVEPOINT Delete_RO_Service_Code;
981:
982: -- Standard call to check for call compatibility.
983: IF NOT FND_API.Compatible_API_Call (lc_api_version,
978: BEGIN
979: -- Standard Start of API savepoint
980: SAVEPOINT Delete_RO_Service_Code;
981:
982: -- Standard call to check for call compatibility.
983: IF NOT FND_API.Compatible_API_Call (lc_api_version,
984: p_api_version,
985: lc_api_name ,
986: G_PKG_NAME )
1044: end if;
1045:
1046: -- Api body ends here
1047:
1048: -- Standard check of p_commit.
1049: IF FND_API.To_Boolean( p_commit ) THEN
1050: COMMIT WORK;
1051: END IF;
1052:
1049: IF FND_API.To_Boolean( p_commit ) THEN
1050: COMMIT WORK;
1051: END IF;
1052:
1053: -- Standard call to get message count and IF count is get message info.
1054: FND_MSG_PUB.Count_And_Get
1055: (p_count => x_msg_count,
1056: p_data => x_msg_data );
1057:
1169: l_msg_data VARCHAR2(100);
1170: l_msg_index NUMBER;
1171:
1172: BEGIN
1173: -- Standard Start of API savepoint
1174: SAVEPOINT Lock_RO_Service_Code;
1175:
1176: -- Standard call to check for call compatibility.
1177: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1172: BEGIN
1173: -- Standard Start of API savepoint
1174: SAVEPOINT Lock_RO_Service_Code;
1175:
1176: -- Standard call to check for call compatibility.
1177: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1178: p_api_version,
1179: lc_api_name ,
1180: G_PKG_NAME )
1279: end if;
1280:
1281: -- Api body ends here
1282:
1283: -- Standard check of p_commit.
1284: IF FND_API.To_Boolean( p_commit ) THEN
1285: COMMIT WORK;
1286: END IF;
1287:
1284: IF FND_API.To_Boolean( p_commit ) THEN
1285: COMMIT WORK;
1286: END IF;
1287:
1288: -- Standard call to get message count and IF count is get message info.
1289: FND_MSG_PUB.Count_And_Get
1290: (p_count => x_msg_count,
1291: p_data => x_msg_data );
1292: