56: CSD_DCD_INVALID_CATSET_FLAG EXCEPTION;
57: CSD_DCD_INVALID_CATEGORY EXCEPTION;
58:
59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT Create_DC_Domain;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call (lc_api_version,
59: BEGIN
60: -- Standard Start of API savepoint
61: SAVEPOINT Create_DC_Domain;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call (lc_api_version,
65: p_api_version,
66: lc_api_name ,
67: G_PKG_NAME )
425: end if;
426:
427: -- Api body ends here
428:
429: -- Standard check of p_commit.
430: IF FND_API.To_Boolean( p_commit ) THEN
431: COMMIT WORK;
432: END IF;
433:
430: IF FND_API.To_Boolean( p_commit ) THEN
431: COMMIT WORK;
432: END IF;
433:
434: -- Standard call to get message count and IF count is get message info.
435: FND_MSG_PUB.Count_And_Get
436: (p_count => x_msg_count,
437: p_data => x_msg_data );
438:
780: CSD_DCD_GET_CATEGORY_ERROR EXCEPTION;
781: CSD_DCD_INVALID_CATEGORY EXCEPTION;
782:
783: BEGIN
784: -- Standard Start of API savepoint
785: SAVEPOINT Update_DC_Domain;
786:
787: -- Standard call to check for call compatibility.
788: IF NOT FND_API.Compatible_API_Call (lc_api_version,
783: BEGIN
784: -- Standard Start of API savepoint
785: SAVEPOINT Update_DC_Domain;
786:
787: -- Standard call to check for call compatibility.
788: IF NOT FND_API.Compatible_API_Call (lc_api_version,
789: p_api_version,
790: lc_api_name ,
791: G_PKG_NAME )
1337: end if;
1338:
1339: -- Api body ends here
1340:
1341: -- Standard check of p_commit.
1342: IF FND_API.To_Boolean( p_commit ) THEN
1343: COMMIT WORK;
1344: END IF;
1345:
1342: IF FND_API.To_Boolean( p_commit ) THEN
1343: COMMIT WORK;
1344: END IF;
1345:
1346: -- Standard call to get message count and IF count is get message info.
1347: FND_MSG_PUB.Count_And_Get
1348: (p_count => x_msg_count,
1349: p_data => x_msg_data );
1350:
1788: l_msg_data VARCHAR2(100);
1789: l_msg_index NUMBER;
1790:
1791: BEGIN
1792: -- Standard Start of API savepoint
1793: SAVEPOINT Delete_DC_Domain;
1794:
1795: -- Standard call to check for call compatibility.
1796: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1791: BEGIN
1792: -- Standard Start of API savepoint
1793: SAVEPOINT Delete_DC_Domain;
1794:
1795: -- Standard call to check for call compatibility.
1796: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1797: p_api_version,
1798: lc_api_name ,
1799: G_PKG_NAME )
1858: end if;
1859:
1860: -- Api body ends here
1861:
1862: -- Standard check of p_commit.
1863: IF FND_API.To_Boolean( p_commit ) THEN
1864: COMMIT WORK;
1865: END IF;
1866:
1863: IF FND_API.To_Boolean( p_commit ) THEN
1864: COMMIT WORK;
1865: END IF;
1866:
1867: -- Standard call to get message count and IF count is get message info.
1868: FND_MSG_PUB.Count_And_Get
1869: (p_count => x_msg_count,
1870: p_data => x_msg_data );
1871:
1984: l_msg_data VARCHAR2(100);
1985: l_msg_index NUMBER;
1986:
1987: BEGIN
1988: -- Standard Start of API savepoint
1989: SAVEPOINT Lock_DC_Domain;
1990:
1991: -- Standard call to check for call compatibility.
1992: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1987: BEGIN
1988: -- Standard Start of API savepoint
1989: SAVEPOINT Lock_DC_Domain;
1990:
1991: -- Standard call to check for call compatibility.
1992: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1993: p_api_version,
1994: lc_api_name ,
1995: G_PKG_NAME )
2093: end if;
2094:
2095: -- Api body ends here
2096:
2097: -- Standard check of p_commit.
2098: IF FND_API.To_Boolean( p_commit ) THEN
2099: COMMIT WORK;
2100: END IF;
2101:
2098: IF FND_API.To_Boolean( p_commit ) THEN
2099: COMMIT WORK;
2100: END IF;
2101:
2102: -- Standard call to get message count and IF count is get message info.
2103: FND_MSG_PUB.Count_And_Get
2104: (p_count => x_msg_count,
2105: p_data => x_msg_data );
2106: