[Home] [Help]
73: -- x_return_status OUT VARCHAR2
74: -- x_msg_count OUT NUMBER
75: -- x_msg_data OUT VARCHAR2
76: -- Version : Current version 1.0
77: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
78: -- and basic operation, developer must manually add parameters and business logic as necessary.
79: --
80: -- History
81: --
116: SELECT 1
117: FROM OZF_NA_RULE_HEADERS_B
118: WHERE na_rule_header_id = l_id;
119: BEGIN
120: -- Standard Start of API savepoint
121: SAVEPOINT create_na_rule_header_pvt;
122:
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
119: BEGIN
120: -- Standard Start of API savepoint
121: SAVEPOINT create_na_rule_header_pvt;
122:
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
125: p_api_version_number,
126: l_api_name,
127: G_PKG_NAME)
228: --
229: -- End of API body
230: --
231:
232: -- Standard check for p_commit
233: IF FND_API.to_Boolean( p_commit )
234: THEN
235: COMMIT WORK;
236: END IF;
239: -- Debug Message
240: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
241:
242:
243: -- Standard call to get message count and if count is 1, get message info.
244: FND_MSG_PUB.Count_And_Get
245: (p_count => x_msg_count,
246: p_data => x_msg_data
247: );
253:
254: WHEN FND_API.G_EXC_ERROR THEN
255: ROLLBACK TO CREATE_Na_Rule_Header_PVT;
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: -- Standard call to get message count and if count=1, get the message
258: FND_MSG_PUB.Count_And_Get (
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: ROLLBACK TO CREATE_Na_Rule_Header_PVT;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: -- Standard call to get message count and if count=1, get the message
268: FND_MSG_PUB.Count_And_Get (
269: p_encoded => FND_API.G_FALSE,
270: p_count => x_msg_count,
271: p_data => x_msg_data
277: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
280: END IF;
281: -- Standard call to get message count and if count=1, get the message
282: FND_MSG_PUB.Count_And_Get (
283: p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data
309: -- x_return_status OUT VARCHAR2
310: -- x_msg_count OUT NUMBER
311: -- x_msg_data OUT VARCHAR2
312: -- Version : Current version 1.0
313: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
314: -- and basic operation, developer must manually add parameters and business logic as necessary.
315: --
316: -- History
317: --
352: l_tar_na_rule_header_rec na_rule_header_rec_type := P_na_rule_header_rec;
353: l_rowid ROWID;
354:
355: BEGIN
356: -- Standard Start of API savepoint
357: SAVEPOINT update_na_rule_header_pvt;
358:
359: -- Standard call to check for call compatibility.
360: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
355: BEGIN
356: -- Standard Start of API savepoint
357: SAVEPOINT update_na_rule_header_pvt;
358:
359: -- Standard call to check for call compatibility.
360: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
361: p_api_version_number,
362: l_api_name,
363: G_PKG_NAME)
458: --
459: -- End of API body.
460: --
461:
462: -- Standard check for p_commit
463: IF FND_API.to_Boolean( p_commit )
464: THEN
465: COMMIT WORK;
466: END IF;
469: -- Debug Message
470: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
471:
472:
473: -- Standard call to get message count and if count is 1, get message info.
474: FND_MSG_PUB.Count_And_Get
475: (p_count => x_msg_count,
476: p_data => x_msg_data
477: );
483:
484: WHEN FND_API.G_EXC_ERROR THEN
485: ROLLBACK TO UPDATE_Na_Rule_Header_PVT;
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: -- Standard call to get message count and if count=1, get the message
488: FND_MSG_PUB.Count_And_Get (
489: p_encoded => FND_API.G_FALSE,
490: p_count => x_msg_count,
491: p_data => x_msg_data
493:
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: ROLLBACK TO UPDATE_Na_Rule_Header_PVT;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: -- Standard call to get message count and if count=1, get the message
498: FND_MSG_PUB.Count_And_Get (
499: p_encoded => FND_API.G_FALSE,
500: p_count => x_msg_count,
501: p_data => x_msg_data
507: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
510: END IF;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,
515: p_data => x_msg_data
540: -- x_return_status OUT VARCHAR2
541: -- x_msg_count OUT NUMBER
542: -- x_msg_data OUT VARCHAR2
543: -- Version : Current version 1.0
544: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
545: -- and basic operation, developer must manually add parameters and business logic as necessary.
546: --
547: -- History
548: --
568: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
569: l_object_version_number NUMBER;
570:
571: BEGIN
572: -- Standard Start of API savepoint
573: SAVEPOINT delete_na_rule_header_pvt;
574:
575: -- Standard call to check for call compatibility.
576: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
571: BEGIN
572: -- Standard Start of API savepoint
573: SAVEPOINT delete_na_rule_header_pvt;
574:
575: -- Standard call to check for call compatibility.
576: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
577: p_api_version_number,
578: l_api_name,
579: G_PKG_NAME)
611: --
612: -- End of API body
613: --
614:
615: -- Standard check for p_commit
616: IF FND_API.to_Boolean( p_commit )
617: THEN
618: COMMIT WORK;
619: END IF;
622: -- Debug Message
623: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
624:
625:
626: -- Standard call to get message count and if count is 1, get message info.
627: FND_MSG_PUB.Count_And_Get
628: (p_count => x_msg_count,
629: p_data => x_msg_data
630: );
636:
637: WHEN FND_API.G_EXC_ERROR THEN
638: ROLLBACK TO DELETE_Na_Rule_Header_PVT;
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: -- Standard call to get message count and if count=1, get the message
641: FND_MSG_PUB.Count_And_Get (
642: p_encoded => FND_API.G_FALSE,
643: p_count => x_msg_count,
644: p_data => x_msg_data
646:
647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
648: ROLLBACK TO DELETE_Na_Rule_Header_PVT;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: -- Standard call to get message count and if count=1, get the message
651: FND_MSG_PUB.Count_And_Get (
652: p_encoded => FND_API.G_FALSE,
653: p_count => x_msg_count,
654: p_data => x_msg_data
660: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
661: THEN
662: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
663: END IF;
664: -- Standard call to get message count and if count=1, get the message
665: FND_MSG_PUB.Count_And_Get (
666: p_encoded => FND_API.G_FALSE,
667: p_count => x_msg_count,
668: p_data => x_msg_data
694: -- x_return_status OUT VARCHAR2
695: -- x_msg_count OUT NUMBER
696: -- x_msg_data OUT VARCHAR2
697: -- Version : Current version 1.0
698: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
699: -- and basic operation, developer must manually add parameters and business logic as necessary.
700: --
701: -- History
702: --
736: END IF;
737:
738:
739:
740: -- Standard call to check for call compatibility.
741: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
742: p_api_version_number,
743: l_api_name,
744: G_PKG_NAME)
770:
771: WHEN FND_API.G_EXC_ERROR THEN
772: ROLLBACK TO LOCK_Na_Rule_Header_PVT;
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: -- Standard call to get message count and if count=1, get the message
775: FND_MSG_PUB.Count_And_Get (
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data
780:
781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
782: ROLLBACK TO LOCK_Na_Rule_Header_PVT;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: -- Standard call to get message count and if count=1, get the message
785: FND_MSG_PUB.Count_And_Get (
786: p_encoded => FND_API.G_FALSE,
787: p_count => x_msg_count,
788: p_data => x_msg_data
794: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
795: THEN
796: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
797: END IF;
798: -- Standard call to get message count and if count=1, get the message
799: FND_MSG_PUB.Count_And_Get (
800: p_encoded => FND_API.G_FALSE,
801: p_count => x_msg_count,
802: p_data => x_msg_data
1095: l_object_version_number NUMBER;
1096: l_na_rule_header_rec na_rule_header_rec_type;
1097:
1098: BEGIN
1099: -- Standard Start of API savepoint
1100: SAVEPOINT validate_na_rule_header_;
1101:
1102: -- Standard call to check for call compatibility.
1103: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1098: BEGIN
1099: -- Standard Start of API savepoint
1100: SAVEPOINT validate_na_rule_header_;
1101:
1102: -- Standard call to check for call compatibility.
1103: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1104: p_api_version_number,
1105: l_api_name,
1106: G_PKG_NAME)
1171: -- Debug Message
1172: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1173:
1174:
1175: -- Standard call to get message count and if count is 1, get message info.
1176: FND_MSG_PUB.Count_And_Get
1177: (p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );
1185:
1186: WHEN FND_API.G_EXC_ERROR THEN
1187: ROLLBACK TO VALIDATE_Na_Rule_Header_;
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189: -- Standard call to get message count and if count=1, get the message
1190: FND_MSG_PUB.Count_And_Get (
1191: p_encoded => FND_API.G_FALSE,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data
1195:
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: ROLLBACK TO VALIDATE_Na_Rule_Header_;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199: -- Standard call to get message count and if count=1, get the message
1200: FND_MSG_PUB.Count_And_Get (
1201: p_encoded => FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data
1209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1210: THEN
1211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1212: END IF;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1246: -- x_return_status := FND_API.G_RET_STS_ERROR;
1247:
1248: -- Debug Message
1249: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1250: -- Standard call to get message count and if count is 1, get message info.
1251: FND_MSG_PUB.Count_And_Get
1252: (p_count => x_msg_count,
1253: p_data => x_msg_data
1254: );