[Home] [Help]
67: FROM OZF_RELATED_DEAL_LINES
68: WHERE RELATED_DEAL_LINES_ID = l_id;
69:
70: BEGIN
71: -- Standard Start of API savepoint
72: SAVEPOINT CREATE_Related_Lines_PVT;
73:
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
70: BEGIN
71: -- Standard Start of API savepoint
72: SAVEPOINT CREATE_Related_Lines_PVT;
73:
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
76: p_api_version_number,
77: l_api_name,
78: G_PKG_NAME)
168: --
169: -- End of API body
170: --
171:
172: -- Standard check for p_commit
173: IF FND_API.to_Boolean( p_commit )
174: THEN
175: COMMIT WORK;
176: END IF;
178:
179: -- Debug Message
180: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
181:
182: -- Standard call to get message count and if count is 1, get message info.
183: FND_MSG_PUB.Count_And_Get
184: (p_count => x_msg_count,
185: p_data => x_msg_data
186: );
192:
193: WHEN FND_API.G_EXC_ERROR THEN
194: ROLLBACK TO CREATE_Related_Lines_PVT;
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: -- Standard call to get message count and if count=1, get the message
197: FND_MSG_PUB.Count_And_Get (
198: p_encoded => FND_API.G_FALSE,
199: p_count => x_msg_count,
200: p_data => x_msg_data
202:
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: ROLLBACK TO CREATE_Related_Lines_PVT;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: -- Standard call to get message count and if count=1, get the message
207: FND_MSG_PUB.Count_And_Get (
208: p_encoded => FND_API.G_FALSE,
209: p_count => x_msg_count,
210: p_data => x_msg_data
216: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
217: THEN
218: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
219: END IF;
220: -- Standard call to get message count and if count=1, get the message
221: FND_MSG_PUB.Count_And_Get (
222: p_encoded => FND_API.G_FALSE,
223: p_count => x_msg_count,
224: p_data => x_msg_data
262:
263: l_rowid ROWID;
264:
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT UPDATE_Related_Lines_PVT;
268:
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT UPDATE_Related_Lines_PVT;
268:
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
271: p_api_version_number,
272: l_api_name,
273: G_PKG_NAME)
369: --
370: -- End of API body.
371: --
372: OZF_UTILITY_PVT.debug_message('end update row');
373: -- Standard check for p_commit
374: IF FND_API.to_Boolean( p_commit )
375: THEN
376: COMMIT WORK;
377: END IF;
379:
380: -- Debug Message
381: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
382:
383: -- Standard call to get message count and if count is 1, get message info.
384: FND_MSG_PUB.Count_And_Get
385: (p_count => x_msg_count,
386: p_data => x_msg_data
387: );
393:
394: WHEN FND_API.G_EXC_ERROR THEN
395: ROLLBACK TO UPDATE_Related_Lines_PVT;
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: -- Standard call to get message count and if count=1, get the message
398: FND_MSG_PUB.Count_And_Get (
399: p_encoded => FND_API.G_FALSE,
400: p_count => x_msg_count,
401: p_data => x_msg_data
403:
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: ROLLBACK TO UPDATE_Related_Lines_PVT;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: -- Standard call to get message count and if count=1, get the message
408: FND_MSG_PUB.Count_And_Get (
409: p_encoded => FND_API.G_FALSE,
410: p_count => x_msg_count,
411: p_data => x_msg_data
417: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
418: THEN
419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
420: END IF;
421: -- Standard call to get message count and if count=1, get the message
422: FND_MSG_PUB.Count_And_Get (
423: p_encoded => FND_API.G_FALSE,
424: p_count => x_msg_count,
425: p_data => x_msg_data
444: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
445: l_object_version_number NUMBER;
446:
447: BEGIN
448: -- Standard Start of API savepoint
449: SAVEPOINT DELETE_Related_Lines_PVT;
450:
451: -- Standard call to check for call compatibility.
452: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
447: BEGIN
448: -- Standard Start of API savepoint
449: SAVEPOINT DELETE_Related_Lines_PVT;
450:
451: -- Standard call to check for call compatibility.
452: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
453: p_api_version_number,
454: l_api_name,
455: G_PKG_NAME)
482: --
483: -- End of API body
484: --
485:
486: -- Standard check for p_commit
487: IF FND_API.to_Boolean( p_commit )
488: THEN
489: COMMIT WORK;
490: END IF;
492:
493: -- Debug Message
494: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
495:
496: -- Standard call to get message count and if count is 1, get message info.
497: FND_MSG_PUB.Count_And_Get
498: (p_count => x_msg_count,
499: p_data => x_msg_data
500: );
506:
507: WHEN FND_API.G_EXC_ERROR THEN
508: ROLLBACK TO DELETE_Related_Lines_PVT;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: -- Standard call to get message count and if count=1, get the message
511: FND_MSG_PUB.Count_And_Get (
512: p_encoded => FND_API.G_FALSE,
513: p_count => x_msg_count,
514: p_data => x_msg_data
516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO DELETE_Related_Lines_PVT;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: -- Standard call to get message count and if count=1, get the message
521: FND_MSG_PUB.Count_And_Get (
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data
530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: THEN
532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
533: END IF;
534: -- Standard call to get message count and if count=1, get the message
535: FND_MSG_PUB.Count_And_Get (
536: p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count,
538: p_data => x_msg_data
577: THEN
578: FND_MSG_PUB.initialize;
579: END IF;
580:
581: -- Standard call to check for call compatibility.
582: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
583: p_api_version_number,
584: l_api_name,
585: G_PKG_NAME)
624:
625: WHEN FND_API.G_EXC_ERROR THEN
626: ROLLBACK TO LOCK_Related_Lines_PVT;
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO LOCK_Related_Lines_PVT;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: -- Standard call to get message count and if count=1, get the message
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.G_FALSE,
641: p_count => x_msg_count,
642: p_data => x_msg_data
648: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
649: THEN
650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
651: END IF;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_msg_count,
656: p_data => x_msg_data
1100: l_object_version_number NUMBER;
1101: l_related_lines_rec OZF_Related_Lines_PVT.related_lines_rec_type;
1102:
1103: BEGIN
1104: -- Standard Start of API savepoint
1105: SAVEPOINT VALIDATE_Related_Lines_;
1106:
1107: -- Standard call to check for call compatibility.
1108: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1103: BEGIN
1104: -- Standard Start of API savepoint
1105: SAVEPOINT VALIDATE_Related_Lines_;
1106:
1107: -- Standard call to check for call compatibility.
1108: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1109: p_api_version_number,
1110: l_api_name,
1111: G_PKG_NAME)
1169:
1170: -- Debug Message
1171: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1172:
1173: -- Standard call to get message count and if count is 1, get message info.
1174: FND_MSG_PUB.Count_And_Get
1175: (p_count => x_msg_count,
1176: p_data => x_msg_data
1177: );
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: ROLLBACK TO VALIDATE_Related_Lines_;
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: -- Standard call to get message count and if count=1, get the message
1189: FND_MSG_PUB.Count_And_Get (
1190: p_encoded => FND_API.G_FALSE,
1191: p_count => x_msg_count,
1192: p_data => x_msg_data
1194:
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: ROLLBACK TO VALIDATE_Related_Lines_;
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: -- Standard call to get message count and if count=1, get the message
1199: FND_MSG_PUB.Count_And_Get (
1200: p_encoded => FND_API.G_FALSE,
1201: p_count => x_msg_count,
1202: p_data => x_msg_data
1208: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1209: THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1211: END IF;
1212: -- Standard call to get message count and if count=1, get the message
1213: FND_MSG_PUB.Count_And_Get (
1214: p_encoded => FND_API.G_FALSE,
1215: p_count => x_msg_count,
1216: p_data => x_msg_data
1243: -- x_return_status := FND_API.G_RET_STS_ERROR;
1244:
1245: -- Debug Message
1246: OZF_UTILITY_PVT.debug_message('Private API: Validate_related_lines_rec');
1247: -- Standard call to get message count and if count is 1, get message info.
1248: FND_MSG_PUB.Count_And_Get
1249: (p_count => x_msg_count,
1250: p_data => x_msg_data
1251: );