52: CSD_SCW_INVALID_ROUTE_SEQUENCE EXCEPTION;
53: CSD_SCW_INVALID_TASK_TEMP_GRP EXCEPTION;
54:
55: BEGIN
56: -- Standard Start of API savepoint
57: SAVEPOINT Create_SC_Work_Entity;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call (lc_api_version,
55: BEGIN
56: -- Standard Start of API savepoint
57: SAVEPOINT Create_SC_Work_Entity;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call (lc_api_version,
61: p_api_version,
62: lc_api_name ,
63: G_PKG_NAME )
345: end if;
346:
347: -- Api body ends here
348:
349: -- Standard check of p_commit.
350: IF FND_API.To_Boolean( p_commit ) THEN
351: COMMIT WORK;
352: END IF;
353:
350: IF FND_API.To_Boolean( p_commit ) THEN
351: COMMIT WORK;
352: END IF;
353:
354: -- Standard call to get message count and IF count is get message info.
355: FND_MSG_PUB.Count_And_Get
356: (p_count => x_msg_count,
357: p_data => x_msg_data );
358:
612: CSD_SCW_INVALID_TASK_TEMP_GRP EXCEPTION;
613:
614: BEGIN
615:
616: -- Standard Start of API savepoint
617: SAVEPOINT Update_SC_Work_Entity;
618:
619: -- Standard call to check for call compatibility.
620: -- Standard call to check for call compatibility.
615:
616: -- Standard Start of API savepoint
617: SAVEPOINT Update_SC_Work_Entity;
618:
619: -- Standard call to check for call compatibility.
620: -- Standard call to check for call compatibility.
621: IF NOT FND_API.Compatible_API_Call (lc_api_version,
622: p_api_version,
623: lc_api_name ,
616: -- Standard Start of API savepoint
617: SAVEPOINT Update_SC_Work_Entity;
618:
619: -- Standard call to check for call compatibility.
620: -- Standard call to check for call compatibility.
621: IF NOT FND_API.Compatible_API_Call (lc_api_version,
622: p_api_version,
623: lc_api_name ,
624: G_PKG_NAME )
998: end if;
999:
1000: -- Api body ends here
1001:
1002: -- Standard check of p_commit.
1003: IF FND_API.To_Boolean( p_commit ) THEN
1004: COMMIT WORK;
1005: END IF;
1006:
1003: IF FND_API.To_Boolean( p_commit ) THEN
1004: COMMIT WORK;
1005: END IF;
1006:
1007: -- Standard call to get message count and IF count is get message info.
1008: FND_MSG_PUB.Count_And_Get
1009: (p_count => x_msg_count,
1010: p_data => x_msg_data );
1011:
1375: l_msg_data VARCHAR2(100);
1376: l_msg_index NUMBER;
1377:
1378: BEGIN
1379: -- Standard Start of API savepoint
1380: SAVEPOINT Delete_SC_Work_Entity;
1381:
1382: -- Standard call to check for call compatibility.
1383: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1378: BEGIN
1379: -- Standard Start of API savepoint
1380: SAVEPOINT Delete_SC_Work_Entity;
1381:
1382: -- Standard call to check for call compatibility.
1383: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1384: p_api_version,
1385: lc_api_name ,
1386: G_PKG_NAME )
1445: end if;
1446:
1447: -- Api body ends here
1448:
1449: -- Standard check of p_commit.
1450: IF FND_API.To_Boolean( p_commit ) THEN
1451: COMMIT WORK;
1452: END IF;
1453:
1450: IF FND_API.To_Boolean( p_commit ) THEN
1451: COMMIT WORK;
1452: END IF;
1453:
1454: -- Standard call to get message count and IF count is get message info.
1455: FND_MSG_PUB.Count_And_Get
1456: (p_count => x_msg_count,
1457: p_data => x_msg_data );
1458:
1571: l_msg_data VARCHAR2(100);
1572: l_msg_index NUMBER;
1573:
1574: BEGIN
1575: -- Standard Start of API savepoint
1576: SAVEPOINT Lock_SC_Work_Entity;
1577:
1578: -- Standard call to check for call compatibility.
1579: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1574: BEGIN
1575: -- Standard Start of API savepoint
1576: SAVEPOINT Lock_SC_Work_Entity;
1577:
1578: -- Standard call to check for call compatibility.
1579: IF NOT FND_API.Compatible_API_Call (lc_api_version,
1580: p_api_version,
1581: lc_api_name ,
1582: G_PKG_NAME )
1680: end if;
1681:
1682: -- Api body ends here
1683:
1684: -- Standard check of p_commit.
1685: IF FND_API.To_Boolean( p_commit ) THEN
1686: COMMIT WORK;
1687: END IF;
1688:
1685: IF FND_API.To_Boolean( p_commit ) THEN
1686: COMMIT WORK;
1687: END IF;
1688:
1689: -- Standard call to get message count and IF count is get message info.
1690: FND_MSG_PUB.Count_And_Get
1691: (p_count => x_msg_count,
1692: p_data => x_msg_data );
1693: