[Home] [Help]
67: -- x_return_status OUT VARCHAR2
68: -- x_msg_count OUT NUMBER
69: -- x_msg_data OUT VARCHAR2
70: -- Version : Current version 1.0
71: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
72: -- and basic operation, developer must manually add parameters and business logic as necessary.
73: --
74: -- History
75: --
110: WHERE na_deduction_rule_id = l_id;
111:
112: l_na_ddn_rule_rec na_ddn_rule_rec_type;
113: BEGIN
114: -- Standard Start of API savepoint
115: SAVEPOINT create_na_ddn_rule_pvt;
116:
117: -- Standard call to check for call compatibility.
118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
113: BEGIN
114: -- Standard Start of API savepoint
115: SAVEPOINT create_na_ddn_rule_pvt;
116:
117: -- Standard call to check for call compatibility.
118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
119: p_api_version_number,
120: l_api_name,
121: G_PKG_NAME)
220: --
221: -- End of API body
222: --
223:
224: -- Standard check for p_commit
225: IF FND_API.to_Boolean( p_commit )
226: THEN
227: COMMIT WORK;
228: END IF;
231: -- Debug Message
232: debug_message('Private API: ' || l_api_name || 'end');
233:
234:
235: -- Standard call to get message count and if count is 1, get message info.
236: FND_MSG_PUB.Count_And_Get
237: (p_count => x_msg_count,
238: p_data => x_msg_data
239: );
245:
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: -- Standard call to get message count and if count=1, get the message
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: ROLLBACK TO CREATE_Na_Ddn_Rule_PVT;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data
269: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
270: THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
272: END IF;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data
301: -- x_return_status OUT VARCHAR2
302: -- x_msg_count OUT NUMBER
303: -- x_msg_data OUT VARCHAR2
304: -- Version : Current version 1.0
305: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
306: -- and basic operation, developer must manually add parameters and business logic as necessary.
307: --
308: -- History
309: --
344: l_tar_na_ddn_rule_rec na_ddn_rule_rec_type := P_na_ddn_rule_rec;
345: l_rowid ROWID;
346:
347: BEGIN
348: -- Standard Start of API savepoint
349: SAVEPOINT update_na_ddn_rule_pvt;
350:
351: -- Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
347: BEGIN
348: -- Standard Start of API savepoint
349: SAVEPOINT update_na_ddn_rule_pvt;
350:
351: -- Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
353: p_api_version_number,
354: l_api_name,
355: G_PKG_NAME)
450: --
451: -- End of API body.
452: --
453:
454: -- Standard check for p_commit
455: IF FND_API.to_Boolean( p_commit )
456: THEN
457: COMMIT WORK;
458: END IF;
461: -- Debug Message
462: debug_message('Private API: ' || l_api_name || 'end');
463:
464:
465: -- Standard call to get message count and if count is 1, get message info.
466: FND_MSG_PUB.Count_And_Get
467: (p_count => x_msg_count,
468: p_data => x_msg_data
469: );
475:
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,
483: p_data => x_msg_data
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: ROLLBACK TO UPDATE_Na_Ddn_Rule_PVT;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data
499: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data
532: -- x_return_status OUT VARCHAR2
533: -- x_msg_count OUT NUMBER
534: -- x_msg_data OUT VARCHAR2
535: -- Version : Current version 1.0
536: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
537: -- and basic operation, developer must manually add parameters and business logic as necessary.
538: --
539: -- History
540: --
560: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
561: l_object_version_number NUMBER;
562:
563: BEGIN
564: -- Standard Start of API savepoint
565: SAVEPOINT delete_na_ddn_rule_pvt;
566:
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
563: BEGIN
564: -- Standard Start of API savepoint
565: SAVEPOINT delete_na_ddn_rule_pvt;
566:
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
603: --
604: -- End of API body
605: --
606:
607: -- Standard check for p_commit
608: IF FND_API.to_Boolean( p_commit )
609: THEN
610: COMMIT WORK;
611: END IF;
614: -- Debug Message
615: debug_message('Private API: ' || l_api_name || 'end');
616:
617:
618: -- Standard call to get message count and if count is 1, get message info.
619: FND_MSG_PUB.Count_And_Get
620: (p_count => x_msg_count,
621: p_data => x_msg_data
622: );
628:
629: WHEN FND_API.G_EXC_ERROR THEN
630: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: -- Standard call to get message count and if count=1, get the message
633: FND_MSG_PUB.Count_And_Get (
634: p_encoded => FND_API.G_FALSE,
635: p_count => x_msg_count,
636: p_data => x_msg_data
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO DELETE_Na_Ddn_Rule_PVT;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,
646: p_data => x_msg_data
652: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
653: THEN
654: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
655: END IF;
656: -- Standard call to get message count and if count=1, get the message
657: FND_MSG_PUB.Count_And_Get (
658: p_encoded => FND_API.G_FALSE,
659: p_count => x_msg_count,
660: p_data => x_msg_data
686: -- x_return_status OUT VARCHAR2
687: -- x_msg_count OUT NUMBER
688: -- x_msg_data OUT VARCHAR2
689: -- Version : Current version 1.0
690: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
691: -- and basic operation, developer must manually add parameters and business logic as necessary.
692: --
693: -- History
694: --
728: END IF;
729:
730:
731:
732: -- Standard call to check for call compatibility.
733: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
734: p_api_version_number,
735: l_api_name,
736: G_PKG_NAME)
762:
763: WHEN FND_API.G_EXC_ERROR THEN
764: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
765: x_return_status := FND_API.G_RET_STS_ERROR;
766: -- Standard call to get message count and if count=1, get the message
767: FND_MSG_PUB.Count_And_Get (
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,
770: p_data => x_msg_data
772:
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: ROLLBACK TO LOCK_Na_Ddn_Rule_PVT;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: -- Standard call to get message count and if count=1, get the message
777: FND_MSG_PUB.Count_And_Get (
778: p_encoded => FND_API.G_FALSE,
779: p_count => x_msg_count,
780: p_data => x_msg_data
786: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
787: THEN
788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
789: END IF;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (
792: p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data
1118: l_object_version_number NUMBER;
1119: l_na_ddn_rule_rec na_ddn_rule_rec_type;
1120:
1121: BEGIN
1122: -- Standard Start of API savepoint
1123: SAVEPOINT validate_na_ddn_rule_;
1124:
1125: -- Standard call to check for call compatibility.
1126: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1121: BEGIN
1122: -- Standard Start of API savepoint
1123: SAVEPOINT validate_na_ddn_rule_;
1124:
1125: -- Standard call to check for call compatibility.
1126: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1127: p_api_version_number,
1128: l_api_name,
1129: G_PKG_NAME)
1195: -- Debug Message
1196: debug_message('Private API: ' || l_api_name || 'end');
1197:
1198:
1199: -- Standard call to get message count and if count is 1, get message info.
1200: FND_MSG_PUB.Count_And_Get
1201: (p_count => x_msg_count,
1202: p_data => x_msg_data
1203: );
1209:
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;
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
1219:
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221: ROLLBACK TO VALIDATE_Na_Ddn_Rule_;
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1223: -- Standard call to get message count and if count=1, get the message
1224: FND_MSG_PUB.Count_And_Get (
1225: p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1233: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1234: THEN
1235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1236: END IF;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data
1270: -- x_return_status := FND_API.G_RET_STS_ERROR;
1271:
1272: -- Debug Message
1273: debug_message('Private API: Validate_dm_model_rec');
1274: -- Standard call to get message count and if count is 1, get message info.
1275: FND_MSG_PUB.Count_And_Get
1276: (p_count => x_msg_count,
1277: p_data => x_msg_data
1278: );