[Home] [Help]
68: FROM OZF_RELATED_DEAL_LINES
69: WHERE RELATED_DEAL_LINES_ID = l_id;
70:
71: BEGIN
72: -- Standard Start of API savepoint
73: SAVEPOINT CREATE_Related_Lines_PVT;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
71: BEGIN
72: -- Standard Start of API savepoint
73: SAVEPOINT CREATE_Related_Lines_PVT;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
77: p_api_version_number,
78: l_api_name,
79: G_PKG_NAME)
169: --
170: -- End of API body
171: --
172:
173: -- Standard check for p_commit
174: IF FND_API.to_Boolean( p_commit )
175: THEN
176: COMMIT WORK;
177: END IF;
179:
180: -- Debug Message
181: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
182:
183: -- Standard call to get message count and if count is 1, get message info.
184: FND_MSG_PUB.Count_And_Get
185: (p_count => x_msg_count,
186: p_data => x_msg_data
187: );
193:
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CREATE_Related_Lines_PVT;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: -- Standard call to get message count and if count=1, get the message
198: FND_MSG_PUB.Count_And_Get (
199: p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data
203:
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ROLLBACK TO CREATE_Related_Lines_PVT;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: -- Standard call to get message count and if count=1, get the message
208: FND_MSG_PUB.Count_And_Get (
209: p_encoded => FND_API.G_FALSE,
210: p_count => x_msg_count,
211: p_data => x_msg_data
217: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
220: END IF;
221: -- Standard call to get message count and if count=1, get the message
222: FND_MSG_PUB.Count_And_Get (
223: p_encoded => FND_API.G_FALSE,
224: p_count => x_msg_count,
225: p_data => x_msg_data
263:
264: l_rowid ROWID;
265:
266: BEGIN
267: -- Standard Start of API savepoint
268: SAVEPOINT UPDATE_Related_Lines_PVT;
269:
270: -- Standard call to check for call compatibility.
271: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
266: BEGIN
267: -- Standard Start of API savepoint
268: SAVEPOINT UPDATE_Related_Lines_PVT;
269:
270: -- Standard call to check for call compatibility.
271: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
272: p_api_version_number,
273: l_api_name,
274: G_PKG_NAME)
370: --
371: -- End of API body.
372: --
373: OZF_UTILITY_PVT.debug_message('end update row');
374: -- Standard check for p_commit
375: IF FND_API.to_Boolean( p_commit )
376: THEN
377: COMMIT WORK;
378: END IF;
380:
381: -- Debug Message
382: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
383:
384: -- Standard call to get message count and if count is 1, get message info.
385: FND_MSG_PUB.Count_And_Get
386: (p_count => x_msg_count,
387: p_data => x_msg_data
388: );
394:
395: WHEN FND_API.G_EXC_ERROR THEN
396: ROLLBACK TO UPDATE_Related_Lines_PVT;
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: -- Standard call to get message count and if count=1, get the message
399: FND_MSG_PUB.Count_And_Get (
400: p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data
404:
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: ROLLBACK TO UPDATE_Related_Lines_PVT;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: -- Standard call to get message count and if count=1, get the message
409: FND_MSG_PUB.Count_And_Get (
410: p_encoded => FND_API.G_FALSE,
411: p_count => x_msg_count,
412: p_data => x_msg_data
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
421: END IF;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (
424: p_encoded => FND_API.G_FALSE,
425: p_count => x_msg_count,
426: p_data => x_msg_data
445: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
446: l_object_version_number NUMBER;
447:
448: BEGIN
449: -- Standard Start of API savepoint
450: SAVEPOINT DELETE_Related_Lines_PVT;
451:
452: -- Standard call to check for call compatibility.
453: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
448: BEGIN
449: -- Standard Start of API savepoint
450: SAVEPOINT DELETE_Related_Lines_PVT;
451:
452: -- Standard call to check for call compatibility.
453: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
454: p_api_version_number,
455: l_api_name,
456: G_PKG_NAME)
483: --
484: -- End of API body
485: --
486:
487: -- Standard check for p_commit
488: IF FND_API.to_Boolean( p_commit )
489: THEN
490: COMMIT WORK;
491: END IF;
493:
494: -- Debug Message
495: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: FND_MSG_PUB.Count_And_Get
499: (p_count => x_msg_count,
500: p_data => x_msg_data
501: );
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO DELETE_Related_Lines_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR;
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
517:
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO DELETE_Related_Lines_PVT;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
532: THEN
533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
534: END IF;
535: -- Standard call to get message count and if count=1, get the message
536: FND_MSG_PUB.Count_And_Get (
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data
578: THEN
579: FND_MSG_PUB.initialize;
580: END IF;
581:
582: -- Standard call to check for call compatibility.
583: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
584: p_api_version_number,
585: l_api_name,
586: G_PKG_NAME)
625:
626: WHEN FND_API.G_EXC_ERROR THEN
627: ROLLBACK TO LOCK_Related_Lines_PVT;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: -- Standard call to get message count and if count=1, get the message
630: FND_MSG_PUB.Count_And_Get (
631: p_encoded => FND_API.G_FALSE,
632: p_count => x_msg_count,
633: p_data => x_msg_data
635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
637: ROLLBACK TO LOCK_Related_Lines_PVT;
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: -- Standard call to get message count and if count=1, get the message
640: FND_MSG_PUB.Count_And_Get (
641: p_encoded => FND_API.G_FALSE,
642: p_count => x_msg_count,
643: p_data => x_msg_data
649: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
650: THEN
651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
652: END IF;
653: -- Standard call to get message count and if count=1, get the message
654: FND_MSG_PUB.Count_And_Get (
655: p_encoded => FND_API.G_FALSE,
656: p_count => x_msg_count,
657: p_data => x_msg_data
1101: l_object_version_number NUMBER;
1102: l_related_lines_rec OZF_Related_Lines_PVT.related_lines_rec_type;
1103:
1104: BEGIN
1105: -- Standard Start of API savepoint
1106: SAVEPOINT VALIDATE_Related_Lines_;
1107:
1108: -- Standard call to check for call compatibility.
1109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1104: BEGIN
1105: -- Standard Start of API savepoint
1106: SAVEPOINT VALIDATE_Related_Lines_;
1107:
1108: -- Standard call to check for call compatibility.
1109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1110: p_api_version_number,
1111: l_api_name,
1112: G_PKG_NAME)
1170:
1171: -- Debug Message
1172: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1173:
1174: -- Standard call to get message count and if count is 1, get message info.
1175: FND_MSG_PUB.Count_And_Get
1176: (p_count => x_msg_count,
1177: p_data => x_msg_data
1178: );
1185:
1186: WHEN FND_API.G_EXC_ERROR THEN
1187: ROLLBACK TO VALIDATE_Related_Lines_;
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_Related_Lines_;
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
1244: -- x_return_status := FND_API.G_RET_STS_ERROR;
1245:
1246: -- Debug Message
1247: OZF_UTILITY_PVT.debug_message('Private API: Validate_related_lines_rec');
1248: -- Standard call to get message count and if count is 1, get message info.
1249: FND_MSG_PUB.Count_And_Get
1250: (p_count => x_msg_count,
1251: p_data => x_msg_data
1252: );