[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: --
107: SELECT 1
108: FROM PV_GE_NOTIF_RULES_B
109: WHERE notif_rule_id = l_id;
110: BEGIN
111: -- Standard Start of API savepoint
112: SAVEPOINT create_ge_notif_rules_pvt;
113:
114: -- Standard call to check for call compatibility.
115: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
110: BEGIN
111: -- Standard Start of API savepoint
112: SAVEPOINT create_ge_notif_rules_pvt;
113:
114: -- Standard call to check for call compatibility.
115: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
116: p_api_version_number,
117: l_api_name,
118: G_PKG_NAME)
260: --
261: -- End of API body
262: --
263:
264: -- Standard check for p_commit
265: IF FND_API.to_Boolean( p_commit )
266: THEN
267: COMMIT WORK;
268: END IF;
274: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
275: END IF;
276:
277:
278: -- Standard call to get message count and if count is 1, get message info.
279: FND_MSG_PUB.Count_And_Get
280: (p_count => x_msg_count,
281: p_data => x_msg_data
282: );
288:
289: WHEN FND_API.G_EXC_ERROR THEN
290: ROLLBACK TO CREATE_Ge_Notif_Rules_PVT;
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: -- Standard call to get message count and if count=1, get the message
293: FND_MSG_PUB.Count_And_Get (
294: p_encoded => FND_API.G_FALSE,
295: p_count => x_msg_count,
296: p_data => x_msg_data
298:
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: ROLLBACK TO CREATE_Ge_Notif_Rules_PVT;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: -- Standard call to get message count and if count=1, get the message
303: FND_MSG_PUB.Count_And_Get (
304: p_encoded => FND_API.G_FALSE,
305: p_count => x_msg_count,
306: p_data => x_msg_data
312: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
315: END IF;
316: -- Standard call to get message count and if count=1, get the message
317: FND_MSG_PUB.Count_And_Get (
318: p_encoded => FND_API.G_FALSE,
319: p_count => x_msg_count,
320: p_data => x_msg_data
399: repeat_until_unit_array varcharArray;
400: repeat_until_value_array numArray;
401:
402: BEGIN
403: -- Standard Start of API savepoint
404: SAVEPOINT Copy_Row;
405:
406: -- Standard call to check for call compatibility.
407: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
402: BEGIN
403: -- Standard Start of API savepoint
404: SAVEPOINT Copy_Row;
405:
406: -- Standard call to check for call compatibility.
407: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
408: p_api_version_number,
409: l_api_name,
410: G_PKG_NAME)
529:
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO Copy_Row;
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data
539:
540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541: ROLLBACK TO Copy_Row;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: -- Standard call to get message count and if count=1, get the message
544: FND_MSG_PUB.Count_And_Get (
545: p_encoded => FND_API.G_FALSE,
546: p_count => x_msg_count,
547: p_data => x_msg_data
553: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
554: THEN
555: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
556: END IF;
557: -- Standard call to get message count and if count=1, get the message
558: FND_MSG_PUB.Count_And_Get (
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => x_msg_data
586: -- x_return_status OUT VARCHAR2
587: -- x_msg_count OUT NUMBER
588: -- x_msg_data OUT VARCHAR2
589: -- Version : Current version 1.0
590: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
591: -- and basic operation, developer must manually add parameters and business logic as necessary.
592: --
593: -- History
594: --
629: l_tar_ge_notif_rules_rec ge_notif_rules_rec_type := P_ge_notif_rules_rec;
630: l_rowid ROWID;
631:
632: BEGIN
633: -- Standard Start of API savepoint
634: SAVEPOINT update_ge_notif_rules_pvt;
635:
636: -- Standard call to check for call compatibility.
637: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
632: BEGIN
633: -- Standard Start of API savepoint
634: SAVEPOINT update_ge_notif_rules_pvt;
635:
636: -- Standard call to check for call compatibility.
637: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
638: p_api_version_number,
639: l_api_name,
640: G_PKG_NAME)
757: --
758: -- End of API body.
759: --
760:
761: -- Standard check for p_commit
762: IF FND_API.to_Boolean( p_commit )
763: THEN
764: COMMIT WORK;
765: END IF;
771: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
772: END IF;
773:
774:
775: -- Standard call to get message count and if count is 1, get message info.
776: FND_MSG_PUB.Count_And_Get
777: (p_count => x_msg_count,
778: p_data => x_msg_data
779: );
785:
786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK TO UPDATE_Ge_Notif_Rules_PVT;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: -- Standard call to get message count and if count=1, get the message
790: FND_MSG_PUB.Count_And_Get (
791: p_encoded => FND_API.G_FALSE,
792: p_count => x_msg_count,
793: p_data => x_msg_data
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: ROLLBACK TO UPDATE_Ge_Notif_Rules_PVT;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: -- Standard call to get message count and if count=1, get the message
800: FND_MSG_PUB.Count_And_Get (
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,
803: p_data => x_msg_data
809: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
810: THEN
811: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
812: END IF;
813: -- Standard call to get message count and if count=1, get the message
814: FND_MSG_PUB.Count_And_Get (
815: p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data
842: -- x_return_status OUT VARCHAR2
843: -- x_msg_count OUT NUMBER
844: -- x_msg_data OUT VARCHAR2
845: -- Version : Current version 1.0
846: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
847: -- and basic operation, developer must manually add parameters and business logic as necessary.
848: --
849: -- History
850: --
870: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
871: l_object_version_number NUMBER;
872:
873: BEGIN
874: -- Standard Start of API savepoint
875: SAVEPOINT delete_ge_notif_rules_pvt;
876:
877: -- Standard call to check for call compatibility.
878: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
873: BEGIN
874: -- Standard Start of API savepoint
875: SAVEPOINT delete_ge_notif_rules_pvt;
876:
877: -- Standard call to check for call compatibility.
878: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
879: p_api_version_number,
880: l_api_name,
881: G_PKG_NAME)
919: --
920: -- End of API body
921: --
922:
923: -- Standard check for p_commit
924: IF FND_API.to_Boolean( p_commit )
925: THEN
926: COMMIT WORK;
927: END IF;
933: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
934: END IF;
935:
936:
937: -- Standard call to get message count and if count is 1, get message info.
938: FND_MSG_PUB.Count_And_Get
939: (p_count => x_msg_count,
940: p_data => x_msg_data
941: );
947:
948: WHEN FND_API.G_EXC_ERROR THEN
949: ROLLBACK TO DELETE_Ge_Notif_Rules_PVT;
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: -- Standard call to get message count and if count=1, get the message
952: FND_MSG_PUB.Count_And_Get (
953: p_encoded => FND_API.G_FALSE,
954: p_count => x_msg_count,
955: p_data => x_msg_data
957:
958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
959: ROLLBACK TO DELETE_Ge_Notif_Rules_PVT;
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: -- Standard call to get message count and if count=1, get the message
962: FND_MSG_PUB.Count_And_Get (
963: p_encoded => FND_API.G_FALSE,
964: p_count => x_msg_count,
965: p_data => x_msg_data
971: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
974: END IF;
975: -- Standard call to get message count and if count=1, get the message
976: FND_MSG_PUB.Count_And_Get (
977: p_encoded => FND_API.G_FALSE,
978: p_count => x_msg_count,
979: p_data => x_msg_data
1005: -- x_return_status OUT VARCHAR2
1006: -- x_msg_count OUT NUMBER
1007: -- x_msg_data OUT VARCHAR2
1008: -- Version : Current version 1.0
1009: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1010: -- and basic operation, developer must manually add parameters and business logic as necessary.
1011: --
1012: -- History
1013: --
1050: END IF;
1051:
1052:
1053:
1054: -- Standard call to check for call compatibility.
1055: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1056: p_api_version_number,
1057: l_api_name,
1058: G_PKG_NAME)
1087:
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: ROLLBACK TO LOCK_Ge_Notif_Rules_PVT;
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: -- Standard call to get message count and if count=1, get the message
1092: FND_MSG_PUB.Count_And_Get (
1093: p_encoded => FND_API.G_FALSE,
1094: p_count => x_msg_count,
1095: p_data => x_msg_data
1097:
1098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1099: ROLLBACK TO LOCK_Ge_Notif_Rules_PVT;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: -- Standard call to get message count and if count=1, get the message
1102: FND_MSG_PUB.Count_And_Get (
1103: p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,
1105: p_data => x_msg_data
1111: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1112: THEN
1113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1114: END IF;
1115: -- Standard call to get message count and if count=1, get the message
1116: FND_MSG_PUB.Count_And_Get (
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => x_msg_count,
1119: p_data => x_msg_data
1482: l_ge_notif_rules_rec ge_notif_rules_rec_type;
1483: l_ge_notif_rules_rec_out ge_notif_rules_rec_type;
1484:
1485: BEGIN
1486: -- Standard Start of API savepoint
1487: SAVEPOINT validate_ge_notif_rules_;
1488:
1489: -- Standard call to check for call compatibility.
1490: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1485: BEGIN
1486: -- Standard Start of API savepoint
1487: SAVEPOINT validate_ge_notif_rules_;
1488:
1489: -- Standard call to check for call compatibility.
1490: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1491: p_api_version_number,
1492: l_api_name,
1493: G_PKG_NAME)
1565: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1566: END IF;
1567:
1568:
1569: -- Standard call to get message count and if count is 1, get message info.
1570: FND_MSG_PUB.Count_And_Get
1571: (p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );
1579:
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: ROLLBACK TO VALIDATE_Ge_Notif_Rules_;
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: -- Standard call to get message count and if count=1, get the message
1584: FND_MSG_PUB.Count_And_Get (
1585: p_encoded => FND_API.G_FALSE,
1586: p_count => x_msg_count,
1587: p_data => x_msg_data
1589:
1590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1591: ROLLBACK TO VALIDATE_Ge_Notif_Rules_;
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1593: -- Standard call to get message count and if count=1, get the message
1594: FND_MSG_PUB.Count_And_Get (
1595: p_encoded => FND_API.G_FALSE,
1596: p_count => x_msg_count,
1597: p_data => x_msg_data
1603: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1604: THEN
1605: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1606: END IF;
1607: -- Standard call to get message count and if count=1, get the message
1608: FND_MSG_PUB.Count_And_Get (
1609: p_encoded => FND_API.G_FALSE,
1610: p_count => x_msg_count,
1611: p_data => x_msg_data
1643: IF (PV_DEBUG_HIGH_ON) THEN
1644:
1645: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1646: END IF;
1647: -- Standard call to get message count and if count is 1, get message info.
1648: FND_MSG_PUB.Count_And_Get
1649: (p_count => x_msg_count,
1650: p_data => x_msg_data
1651: );