[Home] [Help]
88: -- x_return_status OUT VARCHAR2
89: -- x_msg_count OUT NUMBER
90: -- x_msg_data OUT VARCHAR2
91: -- Version : Current version 1.0
92: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
93: -- and basic operation, developer must manually add parameters and business logic as necessary.
94: --
95: -- History
96: --
131: WHERE na_rule_line_id = l_id;
132:
133: l_na_rule_line_rec na_rule_line_rec_type ;
134: BEGIN
135: -- Standard Start of API savepoint
136: SAVEPOINT create_na_rule_line_pvt;
137:
138: -- Standard call to check for call compatibility.
139: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
134: BEGIN
135: -- Standard Start of API savepoint
136: SAVEPOINT create_na_rule_line_pvt;
137:
138: -- Standard call to check for call compatibility.
139: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
140: p_api_version_number,
141: l_api_name,
142: G_PKG_NAME)
241: --
242: -- End of API body
243: --
244:
245: -- Standard check for p_commit
246: IF FND_API.to_Boolean( p_commit )
247: THEN
248: COMMIT WORK;
249: END IF;
252: -- Debug Message
253: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
254:
255:
256: -- Standard call to get message count and if count is 1, get message info.
257: FND_MSG_PUB.Count_And_Get
258: (p_count => x_msg_count,
259: p_data => x_msg_data
260: );
266:
267: WHEN FND_API.G_EXC_ERROR THEN
268: ROLLBACK TO CREATE_Na_Rule_Line_PVT;
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
276:
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: ROLLBACK TO CREATE_Na_Rule_Line_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: -- Standard call to get message count and if count=1, get the message
281: FND_MSG_PUB.Count_And_Get (
282: p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data
290: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
291: THEN
292: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
293: END IF;
294: -- Standard call to get message count and if count=1, get the message
295: FND_MSG_PUB.Count_And_Get (
296: p_encoded => FND_API.G_FALSE,
297: p_count => x_msg_count,
298: p_data => x_msg_data
322: -- x_return_status OUT VARCHAR2
323: -- x_msg_count OUT NUMBER
324: -- x_msg_data OUT VARCHAR2
325: -- Version : Current version 1.0
326: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
327: -- and basic operation, developer must manually add parameters and business logic as necessary.
328: --
329: -- History
330: --
365: l_tar_na_rule_line_rec na_rule_line_rec_type := P_na_rule_line_rec;
366: l_rowid ROWID;
367:
368: BEGIN
369: -- Standard Start of API savepoint
370: SAVEPOINT update_na_rule_line_pvt;
371:
372: -- Standard call to check for call compatibility.
373: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
368: BEGIN
369: -- Standard Start of API savepoint
370: SAVEPOINT update_na_rule_line_pvt;
371:
372: -- Standard call to check for call compatibility.
373: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
374: p_api_version_number,
375: l_api_name,
376: G_PKG_NAME)
468: --
469: -- End of API body.
470: --
471:
472: -- Standard check for p_commit
473: IF FND_API.to_Boolean( p_commit )
474: THEN
475: COMMIT WORK;
476: END IF;
479: -- Debug Message
480: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
481:
482:
483: -- Standard call to get message count and if count is 1, get message info.
484: FND_MSG_PUB.Count_And_Get
485: (p_count => x_msg_count,
486: p_data => x_msg_data
487: );
493:
494: WHEN FND_API.G_EXC_ERROR THEN
495: ROLLBACK TO UPDATE_Na_Rule_Line_PVT;
496: x_return_status := FND_API.G_RET_STS_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
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505: ROLLBACK TO UPDATE_Na_Rule_Line_PVT;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: -- Standard call to get message count and if count=1, get the message
508: FND_MSG_PUB.Count_And_Get (
509: p_encoded => FND_API.G_FALSE,
510: p_count => x_msg_count,
511: p_data => x_msg_data
517: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
520: END IF;
521: -- Standard call to get message count and if count=1, get the message
522: FND_MSG_PUB.Count_And_Get (
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data
550: -- x_return_status OUT VARCHAR2
551: -- x_msg_count OUT NUMBER
552: -- x_msg_data OUT VARCHAR2
553: -- Version : Current version 1.0
554: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
555: -- and basic operation, developer must manually add parameters and business logic as necessary.
556: --
557: -- History
558: --
578: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
579: l_object_version_number NUMBER;
580:
581: BEGIN
582: -- Standard Start of API savepoint
583: SAVEPOINT delete_na_rule_line_pvt;
584:
585: -- Standard call to check for call compatibility.
586: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
581: BEGIN
582: -- Standard Start of API savepoint
583: SAVEPOINT delete_na_rule_line_pvt;
584:
585: -- Standard call to check for call compatibility.
586: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
587: p_api_version_number,
588: l_api_name,
589: G_PKG_NAME)
621: --
622: -- End of API body
623: --
624:
625: -- Standard check for p_commit
626: IF FND_API.to_Boolean( p_commit )
627: THEN
628: COMMIT WORK;
629: END IF;
632: -- Debug Message
633: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
634:
635:
636: -- Standard call to get message count and if count is 1, get message info.
637: FND_MSG_PUB.Count_And_Get
638: (p_count => x_msg_count,
639: p_data => x_msg_data
640: );
646:
647: WHEN FND_API.G_EXC_ERROR THEN
648: ROLLBACK TO DELETE_Na_Rule_Line_PVT;
649: x_return_status := FND_API.G_RET_STS_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
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: ROLLBACK TO DELETE_Na_Rule_Line_PVT;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: -- Standard call to get message count and if count=1, get the message
661: FND_MSG_PUB.Count_And_Get (
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data
670: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
673: END IF;
674: -- Standard call to get message count and if count=1, get the message
675: FND_MSG_PUB.Count_And_Get (
676: p_encoded => FND_API.G_FALSE,
677: p_count => x_msg_count,
678: p_data => x_msg_data
704: -- x_return_status OUT VARCHAR2
705: -- x_msg_count OUT NUMBER
706: -- x_msg_data OUT VARCHAR2
707: -- Version : Current version 1.0
708: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
709: -- and basic operation, developer must manually add parameters and business logic as necessary.
710: --
711: -- History
712: --
746: END IF;
747:
748:
749:
750: -- Standard call to check for call compatibility.
751: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
752: p_api_version_number,
753: l_api_name,
754: G_PKG_NAME)
780:
781: WHEN FND_API.G_EXC_ERROR THEN
782: ROLLBACK TO LOCK_Na_Rule_Line_PVT;
783: x_return_status := FND_API.G_RET_STS_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
790:
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: ROLLBACK TO LOCK_Na_Rule_Line_PVT;
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: -- Standard call to get message count and if count=1, get the message
795: FND_MSG_PUB.Count_And_Get (
796: p_encoded => FND_API.G_FALSE,
797: p_count => x_msg_count,
798: p_data => x_msg_data
804: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
805: THEN
806: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
807: END IF;
808: -- Standard call to get message count and if count=1, get the message
809: FND_MSG_PUB.Count_And_Get (
810: p_encoded => FND_API.G_FALSE,
811: p_count => x_msg_count,
812: p_data => x_msg_data
1128: l_object_version_number NUMBER;
1129: l_na_rule_line_rec na_rule_line_rec_type;
1130:
1131: BEGIN
1132: -- Standard Start of API savepoint
1133: SAVEPOINT validate_na_rule_line_;
1134:
1135: -- Standard call to check for call compatibility.
1136: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1131: BEGIN
1132: -- Standard Start of API savepoint
1133: SAVEPOINT validate_na_rule_line_;
1134:
1135: -- Standard call to check for call compatibility.
1136: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1137: p_api_version_number,
1138: l_api_name,
1139: G_PKG_NAME)
1204: -- Debug Message
1205: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1206:
1207:
1208: -- Standard call to get message count and if count is 1, get message info.
1209: FND_MSG_PUB.Count_And_Get
1210: (p_count => x_msg_count,
1211: p_data => x_msg_data
1212: );
1218:
1219: WHEN FND_API.G_EXC_ERROR THEN
1220: ROLLBACK TO VALIDATE_Na_Rule_Line_;
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: -- Standard call to get message count and if count=1, get the message
1223: FND_MSG_PUB.Count_And_Get (
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data
1228:
1229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1230: ROLLBACK TO VALIDATE_Na_Rule_Line_;
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1232: -- Standard call to get message count and if count=1, get the message
1233: FND_MSG_PUB.Count_And_Get (
1234: p_encoded => FND_API.G_FALSE,
1235: p_count => x_msg_count,
1236: p_data => x_msg_data
1242: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1243: THEN
1244: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1245: END IF;
1246: -- Standard call to get message count and if count=1, get the message
1247: FND_MSG_PUB.Count_And_Get (
1248: p_encoded => FND_API.G_FALSE,
1249: p_count => x_msg_count,
1250: p_data => x_msg_data
1279: -- x_return_status := FND_API.G_RET_STS_ERROR;
1280:
1281: -- Debug Message
1282: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1283: -- Standard call to get message count and if count is 1, get message info.
1284: FND_MSG_PUB.Count_And_Get
1285: (p_count => x_msg_count,
1286: p_data => x_msg_data
1287: );