[Home] [Help]
58: -- x_return_status OUT VARCHAR2
59: -- x_msg_count OUT NUMBER
60: -- x_msg_data OUT VARCHAR2
61: -- Version : Current version 1.0
62: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
63: -- and basic operation, developer must manually add parameters and business logic as necessary.
64: --
65: -- History
66: --
105: SELECT 1
106: FROM PV_GE_CHKLST_ITEMS_B
107: WHERE checklist_item_id = l_id;
108: BEGIN
109: -- Standard Start of API savepoint
110: SAVEPOINT create_ge_chklst_pvt;
111:
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
108: BEGIN
109: -- Standard Start of API savepoint
110: SAVEPOINT create_ge_chklst_pvt;
111:
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
114: p_api_version_number,
115: l_api_name,
116: G_PKG_NAME)
247: --
248: -- End of API body
249: --
250:
251: -- Standard check for p_commit
252: IF FND_API.to_Boolean( p_commit )
253: THEN
254: COMMIT WORK;
255: END IF;
261: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
262: END IF;
263:
264:
265: -- Standard call to get message count and if count is 1, get message info.
266: FND_MSG_PUB.Count_And_Get
267: (p_count => x_msg_count,
268: p_data => x_msg_data
269: );
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277: ROLLBACK TO CREATE_Ge_Chklst_PVT;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (
281: p_encoded => FND_API.G_FALSE,
282: p_count => x_msg_count,
283: p_data => x_msg_data
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: ROLLBACK TO CREATE_Ge_Chklst_PVT;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: -- Standard call to get message count and if count=1, get the message
290: FND_MSG_PUB.Count_And_Get (
291: p_encoded => FND_API.G_FALSE,
292: p_count => x_msg_count,
293: p_data => x_msg_data
299: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
302: END IF;
303: -- Standard call to get message count and if count=1, get the message
304: FND_MSG_PUB.Count_And_Get (
305: p_encoded => FND_API.G_FALSE,
306: p_count => x_msg_count,
307: p_data => x_msg_data
375: source_lang_array varcharArray;
376: language_array varcharArray;
377:
378: BEGIN
379: -- Standard Start of API savepoint
380: SAVEPOINT Copy_Row;
381:
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
378: BEGIN
379: -- Standard Start of API savepoint
380: SAVEPOINT Copy_Row;
381:
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
384: p_api_version_number,
385: l_api_name,
386: G_PKG_NAME)
536:
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO Copy_Row;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: -- Standard call to get message count and if count=1, get the message
541: FND_MSG_PUB.Count_And_Get (
542: p_encoded => FND_API.G_FALSE,
543: p_count => x_msg_count,
544: p_data => x_msg_data
546:
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO Copy_Row;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: -- Standard call to get message count and if count=1, get the message
551: FND_MSG_PUB.Count_And_Get (
552: p_encoded => FND_API.G_FALSE,
553: p_count => x_msg_count,
554: p_data => x_msg_data
560: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
561: THEN
562: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
563: END IF;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_msg_count,
568: p_data => x_msg_data
592: -- x_return_status OUT VARCHAR2
593: -- x_msg_count OUT NUMBER
594: -- x_msg_data OUT VARCHAR2
595: -- Version : Current version 1.0
596: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
597: -- and basic operation, developer must manually add parameters and business logic as necessary.
598: --
599: -- History
600: --
635: l_tar_ge_chklst_rec ge_chklst_rec_type := P_ge_chklst_rec;
636: l_rowid ROWID;
637:
638: BEGIN
639: -- Standard Start of API savepoint
640: SAVEPOINT update_ge_chklst_pvt;
641:
642: -- Standard call to check for call compatibility.
643: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
638: BEGIN
639: -- Standard Start of API savepoint
640: SAVEPOINT update_ge_chklst_pvt;
641:
642: -- Standard call to check for call compatibility.
643: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
644: p_api_version_number,
645: l_api_name,
646: G_PKG_NAME)
753: --
754: -- End of API body.
755: --
756:
757: -- Standard check for p_commit
758: IF FND_API.to_Boolean( p_commit )
759: THEN
760: COMMIT WORK;
761: END IF;
767: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
768: END IF;
769:
770:
771: -- Standard call to get message count and if count is 1, get message info.
772: FND_MSG_PUB.Count_And_Get
773: (p_count => x_msg_count,
774: p_data => x_msg_data
775: );
781:
782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
784: x_return_status := FND_API.G_RET_STS_ERROR;
785: -- Standard call to get message count and if count=1, get the message
786: FND_MSG_PUB.Count_And_Get (
787: p_encoded => FND_API.G_FALSE,
788: p_count => x_msg_count,
789: p_data => x_msg_data
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: -- Standard call to get message count and if count=1, get the message
796: FND_MSG_PUB.Count_And_Get (
797: p_encoded => FND_API.G_FALSE,
798: p_count => x_msg_count,
799: p_data => x_msg_data
805: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
808: END IF;
809: -- Standard call to get message count and if count=1, get the message
810: FND_MSG_PUB.Count_And_Get (
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data
838: -- x_return_status OUT VARCHAR2
839: -- x_msg_count OUT NUMBER
840: -- x_msg_data OUT VARCHAR2
841: -- Version : Current version 1.0
842: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
843: -- and basic operation, developer must manually add parameters and business logic as necessary.
844: --
845: -- History
846: --
866: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
867: l_object_version_number NUMBER;
868:
869: BEGIN
870: -- Standard Start of API savepoint
871: SAVEPOINT delete_ge_chklst_pvt;
872:
873: -- Standard call to check for call compatibility.
874: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
869: BEGIN
870: -- Standard Start of API savepoint
871: SAVEPOINT delete_ge_chklst_pvt;
872:
873: -- Standard call to check for call compatibility.
874: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
875: p_api_version_number,
876: l_api_name,
877: G_PKG_NAME)
915: --
916: -- End of API body
917: --
918:
919: -- Standard check for p_commit
920: IF FND_API.to_Boolean( p_commit )
921: THEN
922: COMMIT WORK;
923: END IF;
929: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
930: END IF;
931:
932:
933: -- Standard call to get message count and if count is 1, get message info.
934: FND_MSG_PUB.Count_And_Get
935: (p_count => x_msg_count,
936: p_data => x_msg_data
937: );
943:
944: WHEN FND_API.G_EXC_ERROR THEN
945: ROLLBACK TO DELETE_Ge_Chklst_PVT;
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: -- Standard call to get message count and if count=1, get the message
948: FND_MSG_PUB.Count_And_Get (
949: p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,
951: p_data => x_msg_data
953:
954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
955: ROLLBACK TO DELETE_Ge_Chklst_PVT;
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: -- Standard call to get message count and if count=1, get the message
958: FND_MSG_PUB.Count_And_Get (
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,
961: p_data => x_msg_data
967: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
968: THEN
969: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
970: END IF;
971: -- Standard call to get message count and if count=1, get the message
972: FND_MSG_PUB.Count_And_Get (
973: p_encoded => FND_API.G_FALSE,
974: p_count => x_msg_count,
975: p_data => x_msg_data
1001: -- x_return_status OUT VARCHAR2
1002: -- x_msg_count OUT NUMBER
1003: -- x_msg_data OUT VARCHAR2
1004: -- Version : Current version 1.0
1005: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1006: -- and basic operation, developer must manually add parameters and business logic as necessary.
1007: --
1008: -- History
1009: --
1046: END IF;
1047:
1048:
1049:
1050: -- Standard call to check for call compatibility.
1051: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1052: p_api_version_number,
1053: l_api_name,
1054: G_PKG_NAME)
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: -- Standard call to get message count and if count=1, get the message
1088: FND_MSG_PUB.Count_And_Get (
1089: p_encoded => FND_API.G_FALSE,
1090: p_count => x_msg_count,
1091: p_data => x_msg_data
1093:
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: -- Standard call to get message count and if count=1, get the message
1098: FND_MSG_PUB.Count_And_Get (
1099: p_encoded => FND_API.G_FALSE,
1100: p_count => x_msg_count,
1101: p_data => x_msg_data
1107: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1108: THEN
1109: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1110: END IF;
1111: -- Standard call to get message count and if count=1, get the message
1112: FND_MSG_PUB.Count_And_Get (
1113: p_encoded => FND_API.G_FALSE,
1114: p_count => x_msg_count,
1115: p_data => x_msg_data
1450: l_ge_chklst_rec ge_chklst_rec_type;
1451: l_ge_chklst_rec_out ge_chklst_rec_type;
1452:
1453: BEGIN
1454: -- Standard Start of API savepoint
1455: SAVEPOINT validate_ge_chklst_;
1456:
1457: -- Standard call to check for call compatibility.
1458: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1453: BEGIN
1454: -- Standard Start of API savepoint
1455: SAVEPOINT validate_ge_chklst_;
1456:
1457: -- Standard call to check for call compatibility.
1458: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1459: p_api_version_number,
1460: l_api_name,
1461: G_PKG_NAME)
1533: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1534: END IF;
1535:
1536:
1537: -- Standard call to get message count and if count is 1, get message info.
1538: FND_MSG_PUB.Count_And_Get
1539: (p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );
1547:
1548: WHEN FND_API.G_EXC_ERROR THEN
1549: ROLLBACK TO VALIDATE_Ge_Chklst_;
1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: -- Standard call to get message count and if count=1, get the message
1552: FND_MSG_PUB.Count_And_Get (
1553: p_encoded => FND_API.G_FALSE,
1554: p_count => x_msg_count,
1555: p_data => x_msg_data
1557:
1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: ROLLBACK TO VALIDATE_Ge_Chklst_;
1560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1561: -- Standard call to get message count and if count=1, get the message
1562: FND_MSG_PUB.Count_And_Get (
1563: p_encoded => FND_API.G_FALSE,
1564: p_count => x_msg_count,
1565: p_data => x_msg_data
1571: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1572: THEN
1573: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1574: END IF;
1575: -- Standard call to get message count and if count=1, get the message
1576: FND_MSG_PUB.Count_And_Get (
1577: p_encoded => FND_API.G_FALSE,
1578: p_count => x_msg_count,
1579: p_data => x_msg_data
1611: IF (PV_DEBUG_HIGH_ON) THEN
1612:
1613: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1614: END IF;
1615: -- Standard call to get message count and if count is 1, get message info.
1616: FND_MSG_PUB.Count_And_Get
1617: (p_count => x_msg_count,
1618: p_data => x_msg_data
1619: );