[Home] [Help]
36: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Claim_Lines_Int';
37: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
38: l_pvt_claim_lines_int_rec OZF_Claim_Lines_Int_PVT.claim_lines_int_rec_type;
39: BEGIN
40: -- Standard Start of API savepoint
41: SAVEPOINT CREATE_Claim_Lines_Int_PUB;
42:
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
39: BEGIN
40: -- Standard Start of API savepoint
41: SAVEPOINT CREATE_Claim_Lines_Int_PUB;
42:
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)
90: --
91: -- End of API body.
92: --
93:
94: -- Standard check for p_commit
95: IF FND_API.to_Boolean( p_commit )
96: THEN
97: COMMIT WORK;
98: END IF;
102: IF g_debug THEN
103: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
104: END IF;
105:
106: -- Standard call to get message count and if count is 1, get message info.
107: FND_MSG_PUB.Count_And_Get
108: (p_count => x_msg_count,
109: p_data => x_msg_data
110: );
116:
117: WHEN FND_API.G_EXC_ERROR THEN
118: ROLLBACK TO CREATE_Claim_Lines_Int_PUB;
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: -- Standard call to get message count and if count=1, get the message
121: FND_MSG_PUB.Count_And_Get (
122: p_encoded => FND_API.G_FALSE,
123: p_count => x_msg_count,
124: p_data => x_msg_data
126:
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: ROLLBACK TO CREATE_Claim_Lines_Int_PUB;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: -- Standard call to get message count and if count=1, get the message
131: FND_MSG_PUB.Count_And_Get (
132: p_encoded => FND_API.G_FALSE,
133: p_count => x_msg_count,
134: p_data => x_msg_data
140: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
141: THEN
142: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
143: END IF;
144: -- Standard call to get message count and if count=1, get the message
145: FND_MSG_PUB.Count_And_Get (
146: p_encoded => FND_API.G_FALSE,
147: p_count => x_msg_count,
148: p_data => x_msg_data
168: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
169: l_object_version_number NUMBER;
170: l_pvt_claim_lines_int_rec OZF_Claim_Lines_Int_PVT.claim_lines_int_rec_type;
171: BEGIN
172: -- Standard Start of API savepoint
173: SAVEPOINT UPDATE_Claim_Lines_Int_PUB;
174:
175: -- Standard call to check for call compatibility.
176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
171: BEGIN
172: -- Standard Start of API savepoint
173: SAVEPOINT UPDATE_Claim_Lines_Int_PUB;
174:
175: -- Standard call to check for call compatibility.
176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
177: p_api_version_number,
178: l_api_name,
179: 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;
232: IF g_debug THEN
233: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
234: END IF;
235:
236: -- Standard call to get message count and if count is 1, get message info.
237: FND_MSG_PUB.Count_And_Get
238: (p_count => x_msg_count,
239: p_data => x_msg_data
240: );
246:
247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO UPDATE_Claim_Lines_Int_PUB;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: -- Standard call to get message count and if count=1, get the message
251: FND_MSG_PUB.Count_And_Get (
252: p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data
256:
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO UPDATE_Claim_Lines_Int_PUB;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
271: THEN
272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
273: END IF;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data
297: l_INTERFACE_CLAIM_LINE_ID NUMBER := p_INTERFACE_CLAIM_LINE_ID;
298: l_object_version_number NUMBER := p_object_version_number;
299: l_pvt_claim_lines_int_rec OZF_Claim_Lines_Int_PVT.claim_lines_int_rec_type;
300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT DELETE_Claim_Lines_Int_PUB;
303:
304: -- Standard call to check for call compatibility.
305: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT DELETE_Claim_Lines_Int_PUB;
303:
304: -- Standard call to check for call compatibility.
305: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
306: p_api_version_number,
307: l_api_name,
308: G_PKG_NAME)
349: --
350: -- End of API body
351: --
352:
353: -- Standard check for p_commit
354: IF FND_API.to_Boolean( p_commit )
355: THEN
356: COMMIT WORK;
357: END IF;
361: IF g_debug THEN
362: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
363: END IF;
364:
365: -- Standard call to get message count and if count is 1, get message info.
366: FND_MSG_PUB.Count_And_Get
367: (p_count => x_msg_count,
368: p_data => x_msg_data
369: );
375:
376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO DELETE_Claim_Lines_Int_PUB;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: -- Standard call to get message count and if count=1, get the message
380: FND_MSG_PUB.Count_And_Get (
381: p_encoded => FND_API.G_FALSE,
382: p_count => x_msg_count,
383: p_data => x_msg_data
385:
386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
387: ROLLBACK TO DELETE_Claim_Lines_Int_PUB;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: -- Standard call to get message count and if count=1, get the message
390: FND_MSG_PUB.Count_And_Get (
391: p_encoded => FND_API.G_FALSE,
392: p_count => x_msg_count,
393: p_data => x_msg_data
399: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
402: END IF;
403: -- Standard call to get message count and if count=1, get the message
404: FND_MSG_PUB.Count_And_Get (
405: p_encoded => FND_API.G_FALSE,
406: p_count => x_msg_count,
407: p_data => x_msg_data
425: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
426: l_pvt_claim_lines_int_rec OZF_Claim_Lines_Int_PVT.claim_lines_int_rec_type;
427: BEGIN
428:
429: -- Standard call to check for call compatibility.
430: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
431: p_api_version_number,
432: l_api_name,
433: G_PKG_NAME)
488:
489: WHEN FND_API.G_EXC_ERROR THEN
490: ROLLBACK TO LOCK_Claim_Lines_Int_PUB;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: -- Standard call to get message count and if count=1, get the message
493: FND_MSG_PUB.Count_And_Get (
494: p_encoded => FND_API.G_FALSE,
495: p_count => x_msg_count,
496: p_data => x_msg_data
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO LOCK_Claim_Lines_Int_PUB;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data
512: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
513: THEN
514: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
515: END IF;
516: -- Standard call to get message count and if count=1, get the message
517: FND_MSG_PUB.Count_And_Get (
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data