eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_PUB dependencies on FND_API

Line 43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

39: -- NOTES
40: ---------------------------------------------------------------------
41: PROCEDURE Create_Claim(
42: p_api_version_number IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,

Line 44: p_commit IN VARCHAR2 := FND_API.G_FALSE,

40: ---------------------------------------------------------------------
41: PROCEDURE Create_Claim(
42: p_api_version_number IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,

Line 45: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

41: PROCEDURE Create_Claim(
42: p_api_version_number IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: p_claim_rec IN claim_rec_type,

Line 68: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

64: BEGIN
65: -- Standard Start of API savepoint
66: SAVEPOINT CREATE_Claim_PUB;
67: -- Standard call to check for call compatibility.
68: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
69: p_api_version_number,
70: l_api_name,
71: G_PKG_NAME)
72: THEN

Line 73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

69: p_api_version_number,
70: l_api_name,
71: G_PKG_NAME)
72: THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list )
77: THEN

Line 76: IF FND_API.to_Boolean( p_init_msg_list )

72: THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: END IF;
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF FND_API.to_Boolean( p_init_msg_list )
77: THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80: -- Debug Message

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: IF g_debug THEN
82: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');
83: END IF;
84: -- Initialize API return status to SUCCESS
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: --
87: -- API body
88: --
89: -- Construct the claim rec to pass to private api

Line 246: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

242: p_claim => l_pvt_claim_rec,
243: x_claim => l_x_pvt_claim_rec
244: );
245: -- Check return status from the above procedure call
246: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243: x_claim => l_x_pvt_claim_rec
244: );
245: -- Check return status from the above procedure call
246: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251: l_pvt_claim_rec := l_x_pvt_claim_rec;

Line 248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

244: );
245: -- Check return status from the above procedure call
246: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251: l_pvt_claim_rec := l_x_pvt_claim_rec;
252:

Line 249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

245: -- Check return status from the above procedure call
246: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251: l_pvt_claim_rec := l_x_pvt_claim_rec;
252:
253: -- OZF_UTILITY_PVT.debug_message('Call Private APICreate Claim Procdure 1');

Line 256: p_init_msg_list => FND_API.G_FALSE,

252:
253: -- OZF_UTILITY_PVT.debug_message('Call Private APICreate Claim Procdure 1');
254: OZF_claim_PVT.Create_Claim(
255: p_api_version => p_api_version_number,
256: p_init_msg_list => FND_API.G_FALSE,
257: p_commit => FND_API.G_FALSE,
258: P_Validation_Level => p_Validation_Level,
259: X_Return_Status => x_return_status,
260: X_Msg_Count => x_msg_count,

Line 257: p_commit => FND_API.G_FALSE,

253: -- OZF_UTILITY_PVT.debug_message('Call Private APICreate Claim Procdure 1');
254: OZF_claim_PVT.Create_Claim(
255: p_api_version => p_api_version_number,
256: p_init_msg_list => FND_API.G_FALSE,
257: p_commit => FND_API.G_FALSE,
258: P_Validation_Level => p_Validation_Level,
259: X_Return_Status => x_return_status,
260: X_Msg_Count => x_msg_count,
261: X_Msg_Data => x_msg_data,

Line 266: IF x_return_status = FND_API.G_RET_STS_ERROR then

262: P_claim => l_pvt_claim_rec,
263: X_CLAIM_ID => x_claim_id
264: );
265: -- Check return status from the above procedure call
266: IF x_return_status = FND_API.G_RET_STS_ERROR then
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;

Line 267: RAISE FND_API.G_EXC_ERROR;

263: X_CLAIM_ID => x_claim_id
264: );
265: -- Check return status from the above procedure call
266: IF x_return_status = FND_API.G_RET_STS_ERROR then
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271:

Line 268: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

264: );
265: -- Check return status from the above procedure call
266: IF x_return_status = FND_API.G_RET_STS_ERROR then
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271:
272: IF p_claim_line_tbl.count > 0 THEN

Line 269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

265: -- Check return status from the above procedure call
266: IF x_return_status = FND_API.G_RET_STS_ERROR then
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271:
272: IF p_claim_line_tbl.count > 0 THEN
273: l_claim_line_tbl := p_claim_line_tbl;

Line 281: ,p_init_msg_list => FND_API.G_FALSE

277: END IF;
278: -- Call create claim line procedure
279: Create_Claim_Line_Tbl(
280: p_api_version => p_api_version_number
281: ,p_init_msg_list => FND_API.G_FALSE
282: ,P_commit => FND_API.G_FALSE
283: ,p_validation_level => p_validation_level
284: ,x_return_status => x_return_status
285: ,x_msg_data => x_msg_data

Line 282: ,P_commit => FND_API.G_FALSE

278: -- Call create claim line procedure
279: Create_Claim_Line_Tbl(
280: p_api_version => p_api_version_number
281: ,p_init_msg_list => FND_API.G_FALSE
282: ,P_commit => FND_API.G_FALSE
283: ,p_validation_level => p_validation_level
284: ,x_return_status => x_return_status
285: ,x_msg_data => x_msg_data
286: ,x_msg_count => x_msg_count

Line 292: IF x_return_status = FND_API.G_RET_STS_ERROR then

288: ,x_error_index => l_error_index);
289: IF g_debug THEN
290: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
291: END IF;
292: IF x_return_status = FND_API.G_RET_STS_ERROR then
293: RAISE FND_API.G_EXC_ERROR;
294: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;

Line 293: RAISE FND_API.G_EXC_ERROR;

289: IF g_debug THEN
290: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
291: END IF;
292: IF x_return_status = FND_API.G_RET_STS_ERROR then
293: RAISE FND_API.G_EXC_ERROR;
294: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297: -- Debug Message

Line 294: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

290: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
291: END IF;
292: IF x_return_status = FND_API.G_RET_STS_ERROR then
293: RAISE FND_API.G_EXC_ERROR;
294: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297: -- Debug Message
298: IF g_debug THEN

Line 295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

291: END IF;
292: IF x_return_status = FND_API.G_RET_STS_ERROR then
293: RAISE FND_API.G_EXC_ERROR;
294: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297: -- Debug Message
298: IF g_debug THEN
299: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

Line 301: IF FND_API.to_Boolean( p_commit )

297: -- Debug Message
298: IF g_debug THEN
299: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
300: END IF;
301: IF FND_API.to_Boolean( p_commit )
302: THEN
303: COMMIT WORK;
304: END IF;
305: --OZF_UTILITY_PVT.DEBUG_MESSAGE('CLAIM_ID=>'||l_claim_line_rec.claim_id);

Line 308: p_encoded => FND_API.G_FALSE,

304: END IF;
305: --OZF_UTILITY_PVT.DEBUG_MESSAGE('CLAIM_ID=>'||l_claim_line_rec.claim_id);
306: -- Standard call to get message count and if count is 1, get message info.
307: FND_MSG_PUB.Count_And_Get (
308: p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count,
310: p_data => x_msg_data
311: );
312: EXCEPTION

Line 315: x_return_status := FND_API.G_RET_STS_ERROR;

311: );
312: EXCEPTION
313: WHEN OZF_Utility_PVT.resource_locked THEN
314: ROLLBACK TO CREATE_Claim_PUB;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
317: FND_MSG_PUB.Count_And_Get (
318: p_encoded => FND_API.G_FALSE,
319: p_count => x_msg_count,

Line 318: p_encoded => FND_API.G_FALSE,

314: ROLLBACK TO CREATE_Claim_PUB;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
317: FND_MSG_PUB.Count_And_Get (
318: p_encoded => FND_API.G_FALSE,
319: p_count => x_msg_count,
320: p_data => x_msg_data
321: );
322: WHEN FND_API.G_EXC_ERROR THEN

Line 322: WHEN FND_API.G_EXC_ERROR THEN

318: p_encoded => FND_API.G_FALSE,
319: p_count => x_msg_count,
320: p_data => x_msg_data
321: );
322: WHEN FND_API.G_EXC_ERROR THEN
323: ROLLBACK TO CREATE_Claim_PUB;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: -- Standard call to get message count and if count=1, get the message
326: FND_MSG_PUB.Count_And_Get (

Line 324: x_return_status := FND_API.G_RET_STS_ERROR;

320: p_data => x_msg_data
321: );
322: WHEN FND_API.G_EXC_ERROR THEN
323: ROLLBACK TO CREATE_Claim_PUB;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: -- Standard call to get message count and if count=1, get the message
326: FND_MSG_PUB.Count_And_Get (
327: p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,

Line 327: p_encoded => FND_API.G_FALSE,

323: ROLLBACK TO CREATE_Claim_PUB;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: -- Standard call to get message count and if count=1, get the message
326: FND_MSG_PUB.Count_And_Get (
327: p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data
330: );
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

327: p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data
330: );
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO CREATE_Claim_PUB;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: -- Standard call to get message count and if count=1, get the message
335: FND_MSG_PUB.Count_And_Get (

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

329: p_data => x_msg_data
330: );
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO CREATE_Claim_PUB;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: -- Standard call to get message count and if count=1, get the message
335: FND_MSG_PUB.Count_And_Get (
336: p_encoded => FND_API.G_FALSE,
337: p_count => x_msg_count,

Line 336: p_encoded => FND_API.G_FALSE,

332: ROLLBACK TO CREATE_Claim_PUB;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: -- Standard call to get message count and if count=1, get the message
335: FND_MSG_PUB.Count_And_Get (
336: p_encoded => FND_API.G_FALSE,
337: p_count => x_msg_count,
338: p_data => x_msg_data
339: );
340: WHEN OTHERS THEN

Line 342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

338: p_data => x_msg_data
339: );
340: WHEN OTHERS THEN
341: ROLLBACK TO CREATE_Claim_PUB;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
344: THEN
345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
346: END IF;

Line 349: p_encoded => FND_API.G_FALSE,

345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
346: END IF;
347: -- Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );
353: End Create_Claim;

Line 372: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

368: -- NOTES
369: ---------------------------------------------------------------------
370: PROCEDURE Create_Claim_Line_Tbl(
371: p_api_version IN NUMBER
372: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
373: ,p_commit IN VARCHAR2 := FND_API.g_false
374: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_data OUT NOCOPY VARCHAR2

Line 373: ,p_commit IN VARCHAR2 := FND_API.g_false

369: ---------------------------------------------------------------------
370: PROCEDURE Create_Claim_Line_Tbl(
371: p_api_version IN NUMBER
372: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
373: ,p_commit IN VARCHAR2 := FND_API.g_false
374: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_data OUT NOCOPY VARCHAR2
377: ,x_msg_count OUT NOCOPY NUMBER

Line 374: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

370: PROCEDURE Create_Claim_Line_Tbl(
371: p_api_version IN NUMBER
372: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
373: ,p_commit IN VARCHAR2 := FND_API.g_false
374: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_data OUT NOCOPY VARCHAR2
377: ,x_msg_count OUT NOCOPY NUMBER
378: ,p_claim_line_tbl IN claim_line_tbl_type

Line 393: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

389: l_claim_line_tbl OZF_CLAIM_PUB.claim_line_tbl_type := p_claim_line_tbl;
390: BEGIN
391: SAVEPOINT Create_Claim_Line_Tbl;
392: -- Standard call to check for call compatibility.
393: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
394: p_api_version,
395: l_api_name,
396: G_PKG_NAME)
397: THEN

Line 398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

394: p_api_version,
395: l_api_name,
396: G_PKG_NAME)
397: THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400: -- Initialize message list if p_init_msg_list is set to TRUE.
401: IF FND_API.to_Boolean( p_init_msg_list )
402: THEN

Line 401: IF FND_API.to_Boolean( p_init_msg_list )

397: THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400: -- Initialize message list if p_init_msg_list is set to TRUE.
401: IF FND_API.to_Boolean( p_init_msg_list )
402: THEN
403: FND_MSG_PUB.initialize;
404: END IF;
405: -- Debug Message

Line 410: x_return_status := FND_API.G_RET_STS_SUCCESS;

406: IF g_debug THEN
407: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');
408: END IF;
409: -- Initialize API return status to SUCCESS
410: x_return_status := FND_API.G_RET_STS_SUCCESS;
411: IF p_claim_line_tbl.count > 0 THEN
412: --
413: l_claim_line_tbl := p_claim_line_tbl;
414: FOR i IN p_claim_line_tbl.FIRST..p_claim_line_tbl.LAST LOOP

Line 509: ,p_init_msg_list => FND_API.G_FALSE

505:
506: -- call to create_claim_line_tbl
507: Ozf_Claim_Line_Pvt.Create_Claim_Line_Tbl(
508: p_api_version => p_api_version
509: ,p_init_msg_list => FND_API.G_FALSE
510: ,P_commit => FND_API.G_FALSE
511: ,p_validation_level => p_validation_level
512: ,x_return_status => x_return_status
513: ,x_msg_data => x_msg_data

Line 510: ,P_commit => FND_API.G_FALSE

506: -- call to create_claim_line_tbl
507: Ozf_Claim_Line_Pvt.Create_Claim_Line_Tbl(
508: p_api_version => p_api_version
509: ,p_init_msg_list => FND_API.G_FALSE
510: ,P_commit => FND_API.G_FALSE
511: ,p_validation_level => p_validation_level
512: ,x_return_status => x_return_status
513: ,x_msg_data => x_msg_data
514: ,x_msg_count => x_msg_count

Line 520: IF x_return_status = FND_API.G_RET_STS_ERROR then

516: ,x_error_index => l_error_index);
517: IF g_debug THEN
518: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
519: END IF;
520: IF x_return_status = FND_API.G_RET_STS_ERROR then
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;

Line 521: RAISE FND_API.G_EXC_ERROR;

517: IF g_debug THEN
518: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
519: END IF;
520: IF x_return_status = FND_API.G_RET_STS_ERROR then
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: -- Standard check for p_commit

Line 522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

518: ozf_utility_pvt.debug_message('return status for create_claim_line_tbl =>'||x_return_status);
519: END IF;
520: IF x_return_status = FND_API.G_RET_STS_ERROR then
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: -- Standard check for p_commit
526: IF FND_API.to_Boolean( p_commit )

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519: END IF;
520: IF x_return_status = FND_API.G_RET_STS_ERROR then
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: -- Standard check for p_commit
526: IF FND_API.to_Boolean( p_commit )
527: THEN

Line 526: IF FND_API.to_Boolean( p_commit )

522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: -- Standard check for p_commit
526: IF FND_API.to_Boolean( p_commit )
527: THEN
528: COMMIT WORK;
529: END IF;
530: -- Debug Message

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538: );
539: EXCEPTION
540: WHEN OZF_Utility_PVT.resource_locked THEN
541: ROLLBACK TO Create_Claim_Line_Tbl;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
544: FND_MSG_PUB.Count_And_Get (
545: p_encoded => FND_API.G_FALSE,
546: p_count => x_msg_count,

Line 545: p_encoded => FND_API.G_FALSE,

541: ROLLBACK TO Create_Claim_Line_Tbl;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
544: FND_MSG_PUB.Count_And_Get (
545: p_encoded => FND_API.G_FALSE,
546: p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549: WHEN FND_API.G_EXC_ERROR THEN

Line 549: WHEN FND_API.G_EXC_ERROR THEN

545: p_encoded => FND_API.G_FALSE,
546: p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO Create_Claim_Line_Tbl;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: -- Standard call to get message count and if count=1, get the message
553: FND_MSG_PUB.Count_And_Get (

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547: p_data => x_msg_data
548: );
549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO Create_Claim_Line_Tbl;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: -- Standard call to get message count and if count=1, get the message
553: FND_MSG_PUB.Count_And_Get (
554: p_encoded => FND_API.G_FALSE,
555: p_count => x_msg_count,

Line 554: p_encoded => FND_API.G_FALSE,

550: ROLLBACK TO Create_Claim_Line_Tbl;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: -- Standard call to get message count and if count=1, get the message
553: FND_MSG_PUB.Count_And_Get (
554: p_encoded => FND_API.G_FALSE,
555: p_count => x_msg_count,
556: p_data => x_msg_data
557: );
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

554: p_encoded => FND_API.G_FALSE,
555: p_count => x_msg_count,
556: p_data => x_msg_data
557: );
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK TO Create_Claim_Line_Tbl;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: -- Standard call to get message count and if count=1, get the message
562: FND_MSG_PUB.Count_And_Get (

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

556: p_data => x_msg_data
557: );
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK TO Create_Claim_Line_Tbl;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: -- Standard call to get message count and if count=1, get the message
562: FND_MSG_PUB.Count_And_Get (
563: p_encoded => FND_API.G_FALSE,
564: p_count => x_msg_count,

Line 563: p_encoded => FND_API.G_FALSE,

559: ROLLBACK TO Create_Claim_Line_Tbl;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: -- Standard call to get message count and if count=1, get the message
562: FND_MSG_PUB.Count_And_Get (
563: p_encoded => FND_API.G_FALSE,
564: p_count => x_msg_count,
565: p_data => x_msg_data
566: );
567: WHEN OTHERS THEN

Line 569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

565: p_data => x_msg_data
566: );
567: WHEN OTHERS THEN
568: ROLLBACK TO Create_Claim_Line_Tbl;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;

Line 576: p_encoded => FND_API.G_FALSE,

572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => x_msg_data
579: );
580: End Create_Claim_Line_Tbl;

Line 600: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

596: -- NOTES
597: ---------------------------------------------------------------------
598: PROCEDURE Update_Claim(
599: p_api_version_number IN NUMBER,
600: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
601: p_commit IN VARCHAR2 := FND_API.G_FALSE,
602: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
603: x_return_status OUT NOCOPY VARCHAR2,
604: x_msg_count OUT NOCOPY NUMBER,

Line 601: p_commit IN VARCHAR2 := FND_API.G_FALSE,

597: ---------------------------------------------------------------------
598: PROCEDURE Update_Claim(
599: p_api_version_number IN NUMBER,
600: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
601: p_commit IN VARCHAR2 := FND_API.G_FALSE,
602: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
603: x_return_status OUT NOCOPY VARCHAR2,
604: x_msg_count OUT NOCOPY NUMBER,
605: x_msg_data OUT NOCOPY VARCHAR2,

Line 602: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

598: PROCEDURE Update_Claim(
599: p_api_version_number IN NUMBER,
600: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
601: p_commit IN VARCHAR2 := FND_API.G_FALSE,
602: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
603: x_return_status OUT NOCOPY VARCHAR2,
604: x_msg_count OUT NOCOPY NUMBER,
605: x_msg_data OUT NOCOPY VARCHAR2,
606: p_claim_rec IN claim_rec_type,

Line 634: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

630: BEGIN
631: -- Standard Start of API savepoint
632: SAVEPOINT SAVE_UPDATE_CLAIM_PUB;
633: -- Standard call to check for call compatibility.
634: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
635: p_api_version_number,
636: l_api_name,
637: G_PKG_NAME)
638: THEN

Line 639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

635: p_api_version_number,
636: l_api_name,
637: G_PKG_NAME)
638: THEN
639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END IF;
641: -- Initialize message list if p_init_msg_list is set to TRUE.
642: IF FND_API.to_Boolean( p_init_msg_list )
643: THEN

Line 642: IF FND_API.to_Boolean( p_init_msg_list )

638: THEN
639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END IF;
641: -- Initialize message list if p_init_msg_list is set to TRUE.
642: IF FND_API.to_Boolean( p_init_msg_list )
643: THEN
644: FND_MSG_PUB.initialize;
645: END IF;
646:

Line 653: x_return_status := FND_API.G_RET_STS_SUCCESS;

649: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
650: END IF;
651:
652: -- Initialize API return status to SUCCESS
653: x_return_status := FND_API.G_RET_STS_SUCCESS;
654: --
655: -- API body
656: --
657: -- Pass Public API values to Private API

Line 800: p_init_msg_list => FND_API.G_FALSE,

796: --
797: --l_pvt_claim_line_rec.update_from_tbl_flag:= l_claim_line_rec.update_from_tbl_flag;
798: OZF_Claim_PVT.Update_Claim(
799: p_api_version => p_api_version_number,
800: p_init_msg_list => FND_API.G_FALSE,
801: p_commit => FND_API.G_FALSE,
802: P_Validation_Level => p_Validation_Level,
803: x_return_status => x_return_status,
804: x_msg_count => x_msg_count,

Line 801: p_commit => FND_API.G_FALSE,

797: --l_pvt_claim_line_rec.update_from_tbl_flag:= l_claim_line_rec.update_from_tbl_flag;
798: OZF_Claim_PVT.Update_Claim(
799: p_api_version => p_api_version_number,
800: p_init_msg_list => FND_API.G_FALSE,
801: p_commit => FND_API.G_FALSE,
802: P_Validation_Level => p_Validation_Level,
803: x_return_status => x_return_status,
804: x_msg_count => x_msg_count,
805: x_msg_data => x_msg_data,

Line 815: IF x_return_status = FND_API.G_RET_STS_ERROR then

811: OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION NUMBER =>'||NVL(x_object_version_number,-99));
812: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR UPDATE CLAIM =>'||X_RETURN_STATUS);
813: END IF;
814: -- Check return status from the above procedure call
815: IF x_return_status = FND_API.G_RET_STS_ERROR then
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;

Line 816: RAISE FND_API.G_EXC_ERROR;

812: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR UPDATE CLAIM =>'||X_RETURN_STATUS);
813: END IF;
814: -- Check return status from the above procedure call
815: IF x_return_status = FND_API.G_RET_STS_ERROR then
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820: --

Line 817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

813: END IF;
814: -- Check return status from the above procedure call
815: IF x_return_status = FND_API.G_RET_STS_ERROR then
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820: --
821: --

Line 818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

814: -- Check return status from the above procedure call
815: IF x_return_status = FND_API.G_RET_STS_ERROR then
816: RAISE FND_API.G_EXC_ERROR;
817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: END IF;
820: --
821: --
822: -- In case claim id is not popluated.

Line 846: ,p_init_msg_list => FND_API.G_FALSE

842: OR l_source_object_class <> 'PPINCVENDOR' OR ( l_source_object_class = 'PPINCVENDOR' AND l_claim_line_tbl.count >1))
843: THEN
844: Update_Claim_Line_Tbl(
845: p_api_version => p_api_version_number
846: ,p_init_msg_list => FND_API.G_FALSE
847: ,p_commit => FND_API.G_FALSE
848: ,P_Validation_Level => p_Validation_Level
849: ,x_return_status => x_return_status
850: ,x_msg_data => x_msg_data

Line 847: ,p_commit => FND_API.G_FALSE

843: THEN
844: Update_Claim_Line_Tbl(
845: p_api_version => p_api_version_number
846: ,p_init_msg_list => FND_API.G_FALSE
847: ,p_commit => FND_API.G_FALSE
848: ,P_Validation_Level => p_Validation_Level
849: ,x_return_status => x_return_status
850: ,x_msg_data => x_msg_data
851: ,x_msg_count => x_msg_count

Line 853: ,p_change_object_version => FND_API.g_false

849: ,x_return_status => x_return_status
850: ,x_msg_data => x_msg_data
851: ,x_msg_count => x_msg_count
852: ,p_claim_line_tbl => l_claim_line_tbl
853: ,p_change_object_version => FND_API.g_false
854: ,x_error_index => x_error_index);
855: END IF;
856: --OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION =>'||NVL(x_object_version,-99));
857: IF g_debug THEN

Line 860: IF x_return_status = FND_API.G_RET_STS_ERROR then

856: --OZF_UTILITY_PVT.DEBUG_MESSAGE('OBJ VERSION =>'||NVL(x_object_version,-99));
857: IF g_debug THEN
858: OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);
859: END IF;
860: IF x_return_status = FND_API.G_RET_STS_ERROR then
861: RAISE FND_API.G_EXC_ERROR;
862: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;

Line 861: RAISE FND_API.G_EXC_ERROR;

857: IF g_debug THEN
858: OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);
859: END IF;
860: IF x_return_status = FND_API.G_RET_STS_ERROR then
861: RAISE FND_API.G_EXC_ERROR;
862: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865:

Line 862: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

858: OZF_UTILITY_PVT.DEBUG_MESSAGE('Return Status for Update claim line =>'||x_return_status);
859: END IF;
860: IF x_return_status = FND_API.G_RET_STS_ERROR then
861: RAISE FND_API.G_EXC_ERROR;
862: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865:
866: -- Standard check for p_commit

Line 863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

859: END IF;
860: IF x_return_status = FND_API.G_RET_STS_ERROR then
861: RAISE FND_API.G_EXC_ERROR;
862: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865:
866: -- Standard check for p_commit
867: IF FND_API.to_Boolean( p_commit )

Line 867: IF FND_API.to_Boolean( p_commit )

863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865:
866: -- Standard check for p_commit
867: IF FND_API.to_Boolean( p_commit )
868: THEN
869: COMMIT WORK;
870: END IF;
871: -- Debug Message

Line 883: x_return_status := FND_API.g_ret_sts_error;

879: );
880: EXCEPTION
881: WHEN OZF_Utility_PVT.resource_locked THEN
882: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
883: x_return_status := FND_API.g_ret_sts_error;
884: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
885: FND_MSG_PUB.Count_And_Get (
886: p_encoded => FND_API.G_FALSE,
887: p_count => x_msg_count,

Line 886: p_encoded => FND_API.G_FALSE,

882: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
883: x_return_status := FND_API.g_ret_sts_error;
884: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
885: FND_MSG_PUB.Count_And_Get (
886: p_encoded => FND_API.G_FALSE,
887: p_count => x_msg_count,
888: p_data => x_msg_data
889: );
890: WHEN FND_API.G_EXC_ERROR THEN

Line 890: WHEN FND_API.G_EXC_ERROR THEN

886: p_encoded => FND_API.G_FALSE,
887: p_count => x_msg_count,
888: p_data => x_msg_data
889: );
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: -- Standard call to get message count and if count=1, get the message
894: FND_MSG_PUB.Count_And_Get (

Line 892: x_return_status := FND_API.G_RET_STS_ERROR;

888: p_data => x_msg_data
889: );
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: -- Standard call to get message count and if count=1, get the message
894: FND_MSG_PUB.Count_And_Get (
895: p_encoded => FND_API.G_FALSE,
896: p_count => x_msg_count,

Line 895: p_encoded => FND_API.G_FALSE,

891: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: -- Standard call to get message count and if count=1, get the message
894: FND_MSG_PUB.Count_And_Get (
895: p_encoded => FND_API.G_FALSE,
896: p_count => x_msg_count,
897: p_data => x_msg_data
898: );
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

895: p_encoded => FND_API.G_FALSE,
896: p_count => x_msg_count,
897: p_data => x_msg_data
898: );
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: -- Standard call to get message count and if count=1, get the message
903: FND_MSG_PUB.Count_And_Get (

Line 901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

897: p_data => x_msg_data
898: );
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: -- Standard call to get message count and if count=1, get the message
903: FND_MSG_PUB.Count_And_Get (
904: p_encoded => FND_API.G_FALSE,
905: p_count => x_msg_count,

Line 904: p_encoded => FND_API.G_FALSE,

900: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: -- Standard call to get message count and if count=1, get the message
903: FND_MSG_PUB.Count_And_Get (
904: p_encoded => FND_API.G_FALSE,
905: p_count => x_msg_count,
906: p_data => x_msg_data
907: );
908: WHEN OTHERS THEN

Line 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

906: p_data => x_msg_data
907: );
908: WHEN OTHERS THEN
909: ROLLBACK TO SAVE_UPDATE_CLAIM_PUB;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
912: THEN
913: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
914: END IF;

Line 917: p_encoded => FND_API.G_FALSE,

913: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
914: END IF;
915: -- Standard call to get message count and if count=1, get the message
916: FND_MSG_PUB.Count_And_Get (
917: p_encoded => FND_API.G_FALSE,
918: p_count => x_msg_count,
919: p_data => x_msg_data
920: );
921: End Update_Claim;

Line 932: -- p_change_object_version IN VARCHAR2 := FND_API.g_false

928: -- This procedure updates claim lines
929: --
930: -- PARAMETERS
931: -- p_claim_line_tbl
932: -- p_change_object_version IN VARCHAR2 := FND_API.g_false
933: -- x_error_index
934: --
935: --
936: -- NOTES

Line 940: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

936: -- NOTES
937: ---------------------------------------------------------------------
938: PROCEDURE Update_Claim_Line_Tbl(
939: p_api_version IN NUMBER
940: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
941: ,p_commit IN VARCHAR2 := FND_API.g_false
942: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
943: ,x_return_status OUT NOCOPY VARCHAR2
944: ,x_msg_data OUT NOCOPY VARCHAR2

Line 941: ,p_commit IN VARCHAR2 := FND_API.g_false

937: ---------------------------------------------------------------------
938: PROCEDURE Update_Claim_Line_Tbl(
939: p_api_version IN NUMBER
940: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
941: ,p_commit IN VARCHAR2 := FND_API.g_false
942: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
943: ,x_return_status OUT NOCOPY VARCHAR2
944: ,x_msg_data OUT NOCOPY VARCHAR2
945: ,x_msg_count OUT NOCOPY NUMBER

Line 942: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

938: PROCEDURE Update_Claim_Line_Tbl(
939: p_api_version IN NUMBER
940: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
941: ,p_commit IN VARCHAR2 := FND_API.g_false
942: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
943: ,x_return_status OUT NOCOPY VARCHAR2
944: ,x_msg_data OUT NOCOPY VARCHAR2
945: ,x_msg_count OUT NOCOPY NUMBER
946: ,p_claim_line_tbl IN claim_line_tbl_type

Line 947: ,p_change_object_version IN VARCHAR2 := FND_API.g_false

943: ,x_return_status OUT NOCOPY VARCHAR2
944: ,x_msg_data OUT NOCOPY VARCHAR2
945: ,x_msg_count OUT NOCOPY NUMBER
946: ,p_claim_line_tbl IN claim_line_tbl_type
947: ,p_change_object_version IN VARCHAR2 := FND_API.g_false
948: ,x_error_index OUT NOCOPY NUMBER
949: )
950: IS
951: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Claim_Line';

Line 961: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

957: l_temp_line_rec OZF_CLAIM_LINE_PVT.claim_line_rec_type;
958: BEGIN
959: SAVEPOINT Update_Claim_Line_Tbl;
960: -- Standard call to check for call compatibility.
961: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
962: p_api_version,
963: l_api_name,
964: G_PKG_NAME)
965: THEN

Line 966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

962: p_api_version,
963: l_api_name,
964: G_PKG_NAME)
965: THEN
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
967: END IF;
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF FND_API.to_Boolean( p_init_msg_list )
970: THEN

Line 969: IF FND_API.to_Boolean( p_init_msg_list )

965: THEN
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
967: END IF;
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF FND_API.to_Boolean( p_init_msg_list )
970: THEN
971: FND_MSG_PUB.initialize;
972: END IF;
973: -- Debug Message

Line 979: x_return_status := FND_API.G_RET_STS_SUCCESS;

975: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
976: END IF;
977:
978: -- Initialize API return status to SUCCESS
979: x_return_status := FND_API.G_RET_STS_SUCCESS;
980: l_claim_line_tbl := p_claim_line_tbl;
981:
982: IF p_claim_line_tbl.COUNT > 0 THEN
983: FOR i IN p_claim_line_tbl.FIRST..p_claim_line_tbl.LAST LOOP

Line 988: l_pvt_claim_line_tbl(i).object_version_number := FND_API.G_MISS_NUM;

984: --
985: l_pvt_claim_line_tbl(i).claim_line_id := l_claim_line_tbl(i).claim_line_id ;
986:
987: IF l_claim_line_tbl(i).object_version_number is null then
988: l_pvt_claim_line_tbl(i).object_version_number := FND_API.G_MISS_NUM;
989: ELSE
990: l_pvt_claim_line_tbl(i).object_version_number :=l_claim_line_tbl(i).object_version_number;
991: END IF;
992:

Line 994: l_pvt_claim_line_tbl(i).last_update_date := FND_API.G_MISS_DATE;

990: l_pvt_claim_line_tbl(i).object_version_number :=l_claim_line_tbl(i).object_version_number;
991: END IF;
992:
993: IF l_claim_line_tbl(i).last_update_date is null then
994: l_pvt_claim_line_tbl(i).last_update_date := FND_API.G_MISS_DATE;
995: ELSE
996: l_pvt_claim_line_tbl(i).last_update_date :=l_claim_line_tbl(i).last_update_date;
997: END IF;
998:

Line 1000: l_pvt_claim_line_tbl(i).last_updated_by := FND_API.G_MISS_NUM;

996: l_pvt_claim_line_tbl(i).last_update_date :=l_claim_line_tbl(i).last_update_date;
997: END IF;
998:
999: IF l_claim_line_tbl(i).last_updated_by is null then
1000: l_pvt_claim_line_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
1001: ELSE
1002: l_pvt_claim_line_tbl(i).last_updated_by :=l_claim_line_tbl(i).last_updated_by;
1003: END IF;
1004:

Line 1006: l_pvt_claim_line_tbl(i).creation_date := FND_API.G_MISS_DATE;

1002: l_pvt_claim_line_tbl(i).last_updated_by :=l_claim_line_tbl(i).last_updated_by;
1003: END IF;
1004:
1005: IF l_claim_line_tbl(i).creation_date is null then
1006: l_pvt_claim_line_tbl(i).creation_date := FND_API.G_MISS_DATE;
1007: ELSE
1008: l_pvt_claim_line_tbl(i).creation_date :=l_claim_line_tbl(i).creation_date;
1009: END IF;
1010:

Line 1012: l_pvt_claim_line_tbl(i).created_by := FND_API.G_MISS_NUM;

1008: l_pvt_claim_line_tbl(i).creation_date :=l_claim_line_tbl(i).creation_date;
1009: END IF;
1010:
1011: IF l_claim_line_tbl(i).created_by is null then
1012: l_pvt_claim_line_tbl(i).created_by := FND_API.G_MISS_NUM;
1013: ELSE
1014: l_pvt_claim_line_tbl(i).created_by :=l_claim_line_tbl(i).created_by;
1015: END IF;
1016:

Line 1018: l_pvt_claim_line_tbl(i).last_update_login := FND_API.G_MISS_NUM;

1014: l_pvt_claim_line_tbl(i).created_by :=l_claim_line_tbl(i).created_by;
1015: END IF;
1016:
1017: IF l_claim_line_tbl(i).last_update_login is null then
1018: l_pvt_claim_line_tbl(i).last_update_login := FND_API.G_MISS_NUM;
1019: ELSE
1020: l_pvt_claim_line_tbl(i).last_update_login :=l_claim_line_tbl(i).last_update_login;
1021: END IF;
1022:

Line 1024: l_pvt_claim_line_tbl(i).request_id := FND_API.G_MISS_NUM;

1020: l_pvt_claim_line_tbl(i).last_update_login :=l_claim_line_tbl(i).last_update_login;
1021: END IF;
1022:
1023: IF l_claim_line_tbl(i).request_id is null then
1024: l_pvt_claim_line_tbl(i).request_id := FND_API.G_MISS_NUM;
1025: ELSE
1026: l_pvt_claim_line_tbl(i).request_id :=l_claim_line_tbl(i).request_id;
1027: END IF;
1028:

Line 1030: l_pvt_claim_line_tbl(i).program_application_id := FND_API.G_MISS_NUM;

1026: l_pvt_claim_line_tbl(i).request_id :=l_claim_line_tbl(i).request_id;
1027: END IF;
1028:
1029: IF l_claim_line_tbl(i).program_application_id is null then
1030: l_pvt_claim_line_tbl(i).program_application_id := FND_API.G_MISS_NUM;
1031: ELSE
1032: l_pvt_claim_line_tbl(i).program_application_id :=l_claim_line_tbl(i).program_application_id;
1033: END IF;
1034:

Line 1036: l_pvt_claim_line_tbl(i).program_update_date := FND_API.G_MISS_DATE;

1032: l_pvt_claim_line_tbl(i).program_application_id :=l_claim_line_tbl(i).program_application_id;
1033: END IF;
1034:
1035: IF l_claim_line_tbl(i).program_update_date is null then
1036: l_pvt_claim_line_tbl(i).program_update_date := FND_API.G_MISS_DATE;
1037: ELSE
1038: l_pvt_claim_line_tbl(i).program_update_date :=l_claim_line_tbl(i).program_update_date;
1039: END IF;
1040:

Line 1042: l_pvt_claim_line_tbl(i).program_id := FND_API.G_MISS_NUM;

1038: l_pvt_claim_line_tbl(i).program_update_date :=l_claim_line_tbl(i).program_update_date;
1039: END IF;
1040:
1041: IF l_claim_line_tbl(i).program_id is null then
1042: l_pvt_claim_line_tbl(i).program_id := FND_API.G_MISS_NUM;
1043: ELSE
1044: l_pvt_claim_line_tbl(i).program_id :=l_claim_line_tbl(i).program_id;
1045: END IF;
1046:

Line 1048: l_pvt_claim_line_tbl(i).created_from := FND_API.G_MISS_CHAR;

1044: l_pvt_claim_line_tbl(i).program_id :=l_claim_line_tbl(i).program_id;
1045: END IF;
1046:
1047: IF l_claim_line_tbl(i).created_from is null then
1048: l_pvt_claim_line_tbl(i).created_from := FND_API.G_MISS_CHAR;
1049: ELSE
1050: l_pvt_claim_line_tbl(i).created_from :=l_claim_line_tbl(i).created_from;
1051: END IF;
1052:

Line 1054: l_pvt_claim_line_tbl(i).claim_id := FND_API.G_MISS_NUM;

1050: l_pvt_claim_line_tbl(i).created_from :=l_claim_line_tbl(i).created_from;
1051: END IF;
1052:
1053: IF l_claim_line_tbl(i).claim_id is null then
1054: l_pvt_claim_line_tbl(i).claim_id := FND_API.G_MISS_NUM;
1055: ELSE
1056: l_pvt_claim_line_tbl(i).claim_id :=l_claim_line_tbl(i).claim_id;
1057: END IF;
1058:

Line 1060: l_pvt_claim_line_tbl(i).line_number := FND_API.G_MISS_NUM;

1056: l_pvt_claim_line_tbl(i).claim_id :=l_claim_line_tbl(i).claim_id;
1057: END IF;
1058:
1059: IF l_claim_line_tbl(i).line_number is null then
1060: l_pvt_claim_line_tbl(i).line_number := FND_API.G_MISS_NUM;
1061: ELSE
1062: l_pvt_claim_line_tbl(i).line_number :=l_claim_line_tbl(i).line_number;
1063: END IF;
1064:

Line 1066: l_pvt_claim_line_tbl(i).split_from_claim_line_id := FND_API.G_MISS_NUM;

1062: l_pvt_claim_line_tbl(i).line_number :=l_claim_line_tbl(i).line_number;
1063: END IF;
1064:
1065: IF l_claim_line_tbl(i).split_from_claim_line_id is null then
1066: l_pvt_claim_line_tbl(i).split_from_claim_line_id := FND_API.G_MISS_NUM;
1067: ELSE
1068: l_pvt_claim_line_tbl(i).split_from_claim_line_id :=l_claim_line_tbl(i).split_from_claim_line_id;
1069: END IF;
1070:

Line 1072: l_pvt_claim_line_tbl(i).amount := FND_API.G_MISS_NUM;

1068: l_pvt_claim_line_tbl(i).split_from_claim_line_id :=l_claim_line_tbl(i).split_from_claim_line_id;
1069: END IF;
1070:
1071: IF l_claim_line_tbl(i).amount is null then
1072: l_pvt_claim_line_tbl(i).amount := FND_API.G_MISS_NUM;
1073: ELSE
1074: l_pvt_claim_line_tbl(i).amount :=l_claim_line_tbl(i).amount;
1075: END IF;
1076:

Line 1078: l_pvt_claim_line_tbl(i).claim_currency_amount := FND_API.G_MISS_NUM;

1074: l_pvt_claim_line_tbl(i).amount :=l_claim_line_tbl(i).amount;
1075: END IF;
1076:
1077: IF l_claim_line_tbl(i).claim_currency_amount is null then
1078: l_pvt_claim_line_tbl(i).claim_currency_amount := FND_API.G_MISS_NUM;
1079: ELSE
1080: l_pvt_claim_line_tbl(i).claim_currency_amount :=l_claim_line_tbl(i).claim_currency_amount;
1081: END IF;
1082:

Line 1084: l_pvt_claim_line_tbl(i).acctd_amount := FND_API.G_MISS_NUM;

1080: l_pvt_claim_line_tbl(i).claim_currency_amount :=l_claim_line_tbl(i).claim_currency_amount;
1081: END IF;
1082:
1083: IF l_claim_line_tbl(i).acctd_amount is null then
1084: l_pvt_claim_line_tbl(i).acctd_amount := FND_API.G_MISS_NUM;
1085: ELSE
1086: l_pvt_claim_line_tbl(i).acctd_amount :=l_claim_line_tbl(i).acctd_amount;
1087: END IF;
1088:

Line 1090: l_pvt_claim_line_tbl(i).currency_code := FND_API.G_MISS_CHAR;

1086: l_pvt_claim_line_tbl(i).acctd_amount :=l_claim_line_tbl(i).acctd_amount;
1087: END IF;
1088:
1089: IF l_claim_line_tbl(i).currency_code is null then
1090: l_pvt_claim_line_tbl(i).currency_code := FND_API.G_MISS_CHAR;
1091: ELSE
1092: l_pvt_claim_line_tbl(i).currency_code :=l_claim_line_tbl(i).currency_code;
1093: END IF;
1094:

Line 1096: l_pvt_claim_line_tbl(i).exchange_rate_type := FND_API.G_MISS_CHAR;

1092: l_pvt_claim_line_tbl(i).currency_code :=l_claim_line_tbl(i).currency_code;
1093: END IF;
1094:
1095: IF l_claim_line_tbl(i).exchange_rate_type is null then
1096: l_pvt_claim_line_tbl(i).exchange_rate_type := FND_API.G_MISS_CHAR;
1097: ELSE
1098: l_pvt_claim_line_tbl(i).exchange_rate_type :=l_claim_line_tbl(i).exchange_rate_type;
1099: END IF;
1100:

Line 1102: l_pvt_claim_line_tbl(i).exchange_rate_date := FND_API.G_MISS_DATE;

1098: l_pvt_claim_line_tbl(i).exchange_rate_type :=l_claim_line_tbl(i).exchange_rate_type;
1099: END IF;
1100:
1101: IF l_claim_line_tbl(i).exchange_rate_date is null then
1102: l_pvt_claim_line_tbl(i).exchange_rate_date := FND_API.G_MISS_DATE;
1103: ELSE
1104: l_pvt_claim_line_tbl(i).exchange_rate_date :=l_claim_line_tbl(i).exchange_rate_date;
1105: END IF;
1106:

Line 1108: l_pvt_claim_line_tbl(i).exchange_rate := FND_API.G_MISS_NUM;

1104: l_pvt_claim_line_tbl(i).exchange_rate_date :=l_claim_line_tbl(i).exchange_rate_date;
1105: END IF;
1106:
1107: IF l_claim_line_tbl(i).exchange_rate is null then
1108: l_pvt_claim_line_tbl(i).exchange_rate := FND_API.G_MISS_NUM;
1109: ELSE
1110: l_pvt_claim_line_tbl(i).exchange_rate :=l_claim_line_tbl(i).exchange_rate;
1111: END IF;
1112:

Line 1114: l_pvt_claim_line_tbl(i).set_of_books_id := FND_API.G_MISS_NUM;

1110: l_pvt_claim_line_tbl(i).exchange_rate :=l_claim_line_tbl(i).exchange_rate;
1111: END IF;
1112:
1113: IF l_claim_line_tbl(i).set_of_books_id is null then
1114: l_pvt_claim_line_tbl(i).set_of_books_id := FND_API.G_MISS_NUM;
1115: ELSE
1116: l_pvt_claim_line_tbl(i).set_of_books_id :=l_claim_line_tbl(i).set_of_books_id;
1117: END IF;
1118:

Line 1120: l_pvt_claim_line_tbl(i).valid_flag := FND_API.G_MISS_CHAR;

1116: l_pvt_claim_line_tbl(i).set_of_books_id :=l_claim_line_tbl(i).set_of_books_id;
1117: END IF;
1118:
1119: IF l_claim_line_tbl(i).valid_flag is null then
1120: l_pvt_claim_line_tbl(i).valid_flag := FND_API.G_MISS_CHAR;
1121: ELSE
1122: l_pvt_claim_line_tbl(i).valid_flag :=l_claim_line_tbl(i).valid_flag;
1123: END IF;
1124:

Line 1126: l_pvt_claim_line_tbl(i).source_object_id := FND_API.G_MISS_NUM;

1122: l_pvt_claim_line_tbl(i).valid_flag :=l_claim_line_tbl(i).valid_flag;
1123: END IF;
1124:
1125: IF l_claim_line_tbl(i).source_object_id is null then
1126: l_pvt_claim_line_tbl(i).source_object_id := FND_API.G_MISS_NUM;
1127: ELSE
1128: l_pvt_claim_line_tbl(i).source_object_id :=l_claim_line_tbl(i).source_object_id;
1129: END IF;
1130:

Line 1132: l_pvt_claim_line_tbl(i).source_object_class := FND_API.G_MISS_CHAR;

1128: l_pvt_claim_line_tbl(i).source_object_id :=l_claim_line_tbl(i).source_object_id;
1129: END IF;
1130:
1131: IF l_claim_line_tbl(i).source_object_class is null then
1132: l_pvt_claim_line_tbl(i).source_object_class := FND_API.G_MISS_CHAR;
1133: ELSE
1134: l_pvt_claim_line_tbl(i).source_object_class :=l_claim_line_tbl(i).source_object_class;
1135: END IF;
1136:

Line 1138: l_pvt_claim_line_tbl(i).source_object_type_id := FND_API.G_MISS_NUM;

1134: l_pvt_claim_line_tbl(i).source_object_class :=l_claim_line_tbl(i).source_object_class;
1135: END IF;
1136:
1137: IF l_claim_line_tbl(i).source_object_type_id is null then
1138: l_pvt_claim_line_tbl(i).source_object_type_id := FND_API.G_MISS_NUM;
1139: ELSE
1140: l_pvt_claim_line_tbl(i).source_object_type_id :=l_claim_line_tbl(i).source_object_type_id ;
1141: END IF;
1142:

Line 1144: l_pvt_claim_line_tbl(i).source_object_line_id := FND_API.G_MISS_NUM;

1140: l_pvt_claim_line_tbl(i).source_object_type_id :=l_claim_line_tbl(i).source_object_type_id ;
1141: END IF;
1142:
1143: IF l_claim_line_tbl(i).source_object_line_id is null then
1144: l_pvt_claim_line_tbl(i).source_object_line_id := FND_API.G_MISS_NUM;
1145: ELSE
1146: l_pvt_claim_line_tbl(i).source_object_line_id :=l_claim_line_tbl(i).source_object_line_id;
1147: END IF;
1148:

Line 1150: l_pvt_claim_line_tbl(i).plan_id := FND_API.G_MISS_NUM;

1146: l_pvt_claim_line_tbl(i).source_object_line_id :=l_claim_line_tbl(i).source_object_line_id;
1147: END IF;
1148:
1149: IF l_claim_line_tbl(i).plan_id is null then
1150: l_pvt_claim_line_tbl(i).plan_id := FND_API.G_MISS_NUM;
1151: ELSE
1152: l_pvt_claim_line_tbl(i).plan_id :=l_claim_line_tbl(i).plan_id;
1153: END IF;
1154:

Line 1156: l_pvt_claim_line_tbl(i).offer_id := FND_API.G_MISS_NUM;

1152: l_pvt_claim_line_tbl(i).plan_id :=l_claim_line_tbl(i).plan_id;
1153: END IF;
1154:
1155: IF l_claim_line_tbl(i).offer_id is null then
1156: l_pvt_claim_line_tbl(i).offer_id := FND_API.G_MISS_NUM;
1157: ELSE
1158: l_pvt_claim_line_tbl(i).offer_id :=l_claim_line_tbl(i).offer_id;
1159: END IF;
1160:

Line 1162: l_pvt_claim_line_tbl(i).utilization_id := FND_API.G_MISS_NUM;

1158: l_pvt_claim_line_tbl(i).offer_id :=l_claim_line_tbl(i).offer_id;
1159: END IF;
1160:
1161: IF l_claim_line_tbl(i).utilization_id is null then
1162: l_pvt_claim_line_tbl(i).utilization_id := FND_API.G_MISS_NUM;
1163: ELSE
1164: l_pvt_claim_line_tbl(i).utilization_id :=l_claim_line_tbl(i).utilization_id;
1165: END IF;
1166:

Line 1168: l_pvt_claim_line_tbl(i).payment_method := FND_API.G_MISS_CHAR;

1164: l_pvt_claim_line_tbl(i).utilization_id :=l_claim_line_tbl(i).utilization_id;
1165: END IF;
1166:
1167: IF l_claim_line_tbl(i).payment_method is null then
1168: l_pvt_claim_line_tbl(i).payment_method := FND_API.G_MISS_CHAR;
1169: ELSE
1170: l_pvt_claim_line_tbl(i).payment_method :=l_claim_line_tbl(i).payment_method;
1171: END IF;
1172:

Line 1174: l_pvt_claim_line_tbl(i).payment_reference_id := FND_API.G_MISS_NUM;

1170: l_pvt_claim_line_tbl(i).payment_method :=l_claim_line_tbl(i).payment_method;
1171: END IF;
1172:
1173: IF l_claim_line_tbl(i).payment_reference_id is null then
1174: l_pvt_claim_line_tbl(i).payment_reference_id := FND_API.G_MISS_NUM;
1175: ELSE
1176: l_pvt_claim_line_tbl(i).payment_reference_id :=l_claim_line_tbl(i).payment_reference_id;
1177: END IF;
1178:

Line 1180: l_pvt_claim_line_tbl(i).payment_reference_number := FND_API.G_MISS_CHAR;

1176: l_pvt_claim_line_tbl(i).payment_reference_id :=l_claim_line_tbl(i).payment_reference_id;
1177: END IF;
1178:
1179: IF l_claim_line_tbl(i).payment_reference_number is null then
1180: l_pvt_claim_line_tbl(i).payment_reference_number := FND_API.G_MISS_CHAR;
1181: ELSE
1182: l_pvt_claim_line_tbl(i).payment_reference_number :=l_claim_line_tbl(i).payment_reference_number;
1183: END IF;
1184:

Line 1186: l_pvt_claim_line_tbl(i).payment_reference_date := FND_API.G_MISS_DATE;

1182: l_pvt_claim_line_tbl(i).payment_reference_number :=l_claim_line_tbl(i).payment_reference_number;
1183: END IF;
1184:
1185: IF l_claim_line_tbl(i).payment_reference_date is null then
1186: l_pvt_claim_line_tbl(i).payment_reference_date := FND_API.G_MISS_DATE;
1187: ELSE
1188: l_pvt_claim_line_tbl(i).payment_reference_date :=l_claim_line_tbl(i).payment_reference_date;
1189: END IF;
1190:

Line 1192: l_pvt_claim_line_tbl(i).voucher_id := FND_API.G_MISS_NUM;

1188: l_pvt_claim_line_tbl(i).payment_reference_date :=l_claim_line_tbl(i).payment_reference_date;
1189: END IF;
1190:
1191: IF l_claim_line_tbl(i).voucher_id is null then
1192: l_pvt_claim_line_tbl(i).voucher_id := FND_API.G_MISS_NUM;
1193: ELSE
1194: l_pvt_claim_line_tbl(i).voucher_id :=l_claim_line_tbl(i).voucher_id;
1195: END IF;
1196:

Line 1198: l_pvt_claim_line_tbl(i).voucher_number := FND_API.G_MISS_CHAR;

1194: l_pvt_claim_line_tbl(i).voucher_id :=l_claim_line_tbl(i).voucher_id;
1195: END IF;
1196:
1197: IF l_claim_line_tbl(i).voucher_number is null then
1198: l_pvt_claim_line_tbl(i).voucher_number := FND_API.G_MISS_CHAR;
1199: ELSE
1200: l_pvt_claim_line_tbl(i).voucher_number :=l_claim_line_tbl(i).voucher_number;
1201: END IF;
1202:

Line 1204: l_pvt_claim_line_tbl(i).payment_status := FND_API.G_MISS_CHAR;

1200: l_pvt_claim_line_tbl(i).voucher_number :=l_claim_line_tbl(i).voucher_number;
1201: END IF;
1202:
1203: IF l_claim_line_tbl(i).payment_status is null then
1204: l_pvt_claim_line_tbl(i).payment_status := FND_API.G_MISS_CHAR;
1205: ELSE
1206: l_pvt_claim_line_tbl(i).payment_status :=l_claim_line_tbl(i).payment_status;
1207: END IF;
1208:

Line 1210: l_pvt_claim_line_tbl(i).approved_flag := FND_API.G_MISS_CHAR;

1206: l_pvt_claim_line_tbl(i).payment_status :=l_claim_line_tbl(i).payment_status;
1207: END IF;
1208:
1209: IF l_claim_line_tbl(i).approved_flag is null then
1210: l_pvt_claim_line_tbl(i).approved_flag := FND_API.G_MISS_CHAR;
1211: ELSE
1212: l_pvt_claim_line_tbl(i).approved_flag :=l_claim_line_tbl(i).approved_flag;
1213: END IF;
1214:

Line 1216: l_pvt_claim_line_tbl(i).approved_date := FND_API.G_MISS_DATE;

1212: l_pvt_claim_line_tbl(i).approved_flag :=l_claim_line_tbl(i).approved_flag;
1213: END IF;
1214:
1215: IF l_claim_line_tbl(i).approved_date is null then
1216: l_pvt_claim_line_tbl(i).approved_date := FND_API.G_MISS_DATE;
1217: ELSE
1218: l_pvt_claim_line_tbl(i).approved_date :=l_claim_line_tbl(i).approved_date;
1219: END IF;
1220:

Line 1222: l_pvt_claim_line_tbl(i).approved_by := FND_API.G_MISS_NUM;

1218: l_pvt_claim_line_tbl(i).approved_date :=l_claim_line_tbl(i).approved_date;
1219: END IF;
1220:
1221: IF l_claim_line_tbl(i).approved_by is null then
1222: l_pvt_claim_line_tbl(i).approved_by := FND_API.G_MISS_NUM;
1223: ELSE
1224: l_pvt_claim_line_tbl(i).approved_by :=l_claim_line_tbl(i).approved_by;
1225: END IF;
1226:

Line 1228: l_pvt_claim_line_tbl(i).settled_date := FND_API.G_MISS_DATE;

1224: l_pvt_claim_line_tbl(i).approved_by :=l_claim_line_tbl(i).approved_by;
1225: END IF;
1226:
1227: IF l_claim_line_tbl(i).settled_date is null then
1228: l_pvt_claim_line_tbl(i).settled_date := FND_API.G_MISS_DATE;
1229: ELSE
1230: l_pvt_claim_line_tbl(i).settled_date :=l_claim_line_tbl(i).settled_date;
1231: END IF;
1232:

Line 1234: l_pvt_claim_line_tbl(i).settled_by := FND_API.G_MISS_NUM;

1230: l_pvt_claim_line_tbl(i).settled_date :=l_claim_line_tbl(i).settled_date;
1231: END IF;
1232:
1233: IF l_claim_line_tbl(i).settled_by is null then
1234: l_pvt_claim_line_tbl(i).settled_by := FND_API.G_MISS_NUM;
1235: ELSE
1236: l_pvt_claim_line_tbl(i).settled_by :=l_claim_line_tbl(i).settled_by ;
1237: END IF;
1238:

Line 1240: l_pvt_claim_line_tbl(i).performance_complete_flag := FND_API.G_MISS_CHAR;

1236: l_pvt_claim_line_tbl(i).settled_by :=l_claim_line_tbl(i).settled_by ;
1237: END IF;
1238:
1239: IF l_claim_line_tbl(i).performance_complete_flag is null then
1240: l_pvt_claim_line_tbl(i).performance_complete_flag := FND_API.G_MISS_CHAR;
1241: ELSE
1242: l_pvt_claim_line_tbl(i).performance_complete_flag :=l_claim_line_tbl(i).performance_complete_flag;
1243: END IF;
1244:

Line 1246: l_pvt_claim_line_tbl(i).performance_attached_flag := FND_API.G_MISS_CHAR;

1242: l_pvt_claim_line_tbl(i).performance_complete_flag :=l_claim_line_tbl(i).performance_complete_flag;
1243: END IF;
1244:
1245: IF l_claim_line_tbl(i).performance_attached_flag is null then
1246: l_pvt_claim_line_tbl(i).performance_attached_flag := FND_API.G_MISS_CHAR;
1247: ELSE
1248: l_pvt_claim_line_tbl(i).performance_attached_flag :=l_claim_line_tbl(i).performance_attached_flag;
1249: END IF;
1250:

Line 1252: l_pvt_claim_line_tbl(i).item_id := FND_API.G_MISS_NUM;

1248: l_pvt_claim_line_tbl(i).performance_attached_flag :=l_claim_line_tbl(i).performance_attached_flag;
1249: END IF;
1250:
1251: IF l_claim_line_tbl(i).item_id is null then
1252: l_pvt_claim_line_tbl(i).item_id := FND_API.G_MISS_NUM;
1253: ELSE
1254: l_pvt_claim_line_tbl(i).item_id :=l_claim_line_tbl(i).item_id;
1255: END IF;
1256:

Line 1258: l_pvt_claim_line_tbl(i).item_description := FND_API.G_MISS_CHAR;

1254: l_pvt_claim_line_tbl(i).item_id :=l_claim_line_tbl(i).item_id;
1255: END IF;
1256:
1257: IF l_claim_line_tbl(i).item_description is null then
1258: l_pvt_claim_line_tbl(i).item_description := FND_API.G_MISS_CHAR;
1259: ELSE
1260: l_pvt_claim_line_tbl(i).item_description :=l_claim_line_tbl(i).item_description;
1261: END IF;
1262:

Line 1264: l_pvt_claim_line_tbl(i).quantity := FND_API.G_MISS_NUM;

1260: l_pvt_claim_line_tbl(i).item_description :=l_claim_line_tbl(i).item_description;
1261: END IF;
1262:
1263: IF l_claim_line_tbl(i).quantity is null then
1264: l_pvt_claim_line_tbl(i).quantity := FND_API.G_MISS_NUM;
1265: ELSE
1266: l_pvt_claim_line_tbl(i).quantity :=l_claim_line_tbl(i).quantity;
1267: END IF;
1268:

Line 1270: l_pvt_claim_line_tbl(i).quantity_uom := FND_API.G_MISS_CHAR;

1266: l_pvt_claim_line_tbl(i).quantity :=l_claim_line_tbl(i).quantity;
1267: END IF;
1268:
1269: IF l_claim_line_tbl(i).quantity_uom is null then
1270: l_pvt_claim_line_tbl(i).quantity_uom := FND_API.G_MISS_CHAR;
1271: ELSE
1272: l_pvt_claim_line_tbl(i).quantity_uom :=l_claim_line_tbl(i).quantity_uom;
1273: END IF;
1274:

Line 1276: l_pvt_claim_line_tbl(i).rate := FND_API.G_MISS_NUM;

1272: l_pvt_claim_line_tbl(i).quantity_uom :=l_claim_line_tbl(i).quantity_uom;
1273: END IF;
1274:
1275: IF l_claim_line_tbl(i).rate is null then
1276: l_pvt_claim_line_tbl(i).rate := FND_API.G_MISS_NUM;
1277: ELSE
1278: l_pvt_claim_line_tbl(i).rate :=l_claim_line_tbl(i).rate;
1279: END IF;
1280:

Line 1282: l_pvt_claim_line_tbl(i).activity_type := FND_API.G_MISS_CHAR;

1278: l_pvt_claim_line_tbl(i).rate :=l_claim_line_tbl(i).rate;
1279: END IF;
1280:
1281: IF l_claim_line_tbl(i).activity_type is null then
1282: l_pvt_claim_line_tbl(i).activity_type := FND_API.G_MISS_CHAR;
1283: ELSE
1284: l_pvt_claim_line_tbl(i).activity_type :=l_claim_line_tbl(i).activity_type;
1285: END IF;
1286:

Line 1288: l_pvt_claim_line_tbl(i).activity_id := FND_API.G_MISS_NUM;

1284: l_pvt_claim_line_tbl(i).activity_type :=l_claim_line_tbl(i).activity_type;
1285: END IF;
1286:
1287: IF l_claim_line_tbl(i).activity_id is null then
1288: l_pvt_claim_line_tbl(i).activity_id := FND_API.G_MISS_NUM;
1289: ELSE
1290: l_pvt_claim_line_tbl(i).activity_id :=l_claim_line_tbl(i).activity_id;
1291: END IF;
1292:

Line 1294: l_pvt_claim_line_tbl(i).related_cust_account_id := FND_API.G_MISS_NUM;

1290: l_pvt_claim_line_tbl(i).activity_id :=l_claim_line_tbl(i).activity_id;
1291: END IF;
1292:
1293: IF l_claim_line_tbl(i).related_cust_account_id is null then
1294: l_pvt_claim_line_tbl(i).related_cust_account_id := FND_API.G_MISS_NUM;
1295: ELSE
1296: l_pvt_claim_line_tbl(i).related_cust_account_id :=l_claim_line_tbl(i).related_cust_account_id;
1297: END IF;
1298:

Line 1300: l_pvt_claim_line_tbl(i).relationship_type := FND_API.G_MISS_CHAR;

1296: l_pvt_claim_line_tbl(i).related_cust_account_id :=l_claim_line_tbl(i).related_cust_account_id;
1297: END IF;
1298:
1299: IF l_claim_line_tbl(i).relationship_type is null then
1300: l_pvt_claim_line_tbl(i).relationship_type := FND_API.G_MISS_CHAR;
1301: ELSE
1302: l_pvt_claim_line_tbl(i).relationship_type :=l_claim_line_tbl(i).relationship_type;
1303: END IF;
1304:

Line 1306: l_pvt_claim_line_tbl(i).earnings_associated_flag := FND_API.G_MISS_CHAR;

1302: l_pvt_claim_line_tbl(i).relationship_type :=l_claim_line_tbl(i).relationship_type;
1303: END IF;
1304:
1305: IF l_claim_line_tbl(i).earnings_associated_flag is null then
1306: l_pvt_claim_line_tbl(i).earnings_associated_flag := FND_API.G_MISS_CHAR;
1307: ELSE
1308: l_pvt_claim_line_tbl(i).earnings_associated_flag :=l_claim_line_tbl(i).earnings_associated_flag;
1309: END IF;
1310:

Line 1312: l_pvt_claim_line_tbl(i).comments := FND_API.G_MISS_CHAR;

1308: l_pvt_claim_line_tbl(i).earnings_associated_flag :=l_claim_line_tbl(i).earnings_associated_flag;
1309: END IF;
1310:
1311: IF l_claim_line_tbl(i).comments is null then
1312: l_pvt_claim_line_tbl(i).comments := FND_API.G_MISS_CHAR;
1313: ELSE
1314: l_pvt_claim_line_tbl(i).comments :=l_claim_line_tbl(i).comments;
1315: END IF;
1316:

Line 1318: l_pvt_claim_line_tbl(i).tax_code := FND_API.G_MISS_CHAR;

1314: l_pvt_claim_line_tbl(i).comments :=l_claim_line_tbl(i).comments;
1315: END IF;
1316:
1317: IF l_claim_line_tbl(i).tax_code is null then
1318: l_pvt_claim_line_tbl(i).tax_code := FND_API.G_MISS_CHAR;
1319: ELSE
1320: l_pvt_claim_line_tbl(i).tax_code :=l_claim_line_tbl(i).tax_code;
1321: END IF;
1322:

Line 1324: l_pvt_claim_line_tbl(i).attribute_category := FND_API.G_MISS_CHAR;

1320: l_pvt_claim_line_tbl(i).tax_code :=l_claim_line_tbl(i).tax_code;
1321: END IF;
1322:
1323: IF l_claim_line_tbl(i).attribute_category is null then
1324: l_pvt_claim_line_tbl(i).attribute_category := FND_API.G_MISS_CHAR;
1325: ELSE
1326: l_pvt_claim_line_tbl(i).attribute_category :=l_claim_line_tbl(i).attribute_category;
1327: END IF;
1328:

Line 1330: l_pvt_claim_line_tbl(i).attribute1 := FND_API.G_MISS_CHAR;

1326: l_pvt_claim_line_tbl(i).attribute_category :=l_claim_line_tbl(i).attribute_category;
1327: END IF;
1328:
1329: IF l_claim_line_tbl(i).attribute1 is null then
1330: l_pvt_claim_line_tbl(i).attribute1 := FND_API.G_MISS_CHAR;
1331: ELSE
1332: l_pvt_claim_line_tbl(i).attribute1 :=l_claim_line_tbl(i).attribute1;
1333: END IF;
1334:

Line 1336: l_pvt_claim_line_tbl(i).attribute2 := FND_API.G_MISS_CHAR;

1332: l_pvt_claim_line_tbl(i).attribute1 :=l_claim_line_tbl(i).attribute1;
1333: END IF;
1334:
1335: IF l_claim_line_tbl(i).attribute2 is null then
1336: l_pvt_claim_line_tbl(i).attribute2 := FND_API.G_MISS_CHAR;
1337: ELSE
1338: l_pvt_claim_line_tbl(i).attribute2 :=l_claim_line_tbl(i).attribute2;
1339: END IF;
1340:

Line 1342: l_pvt_claim_line_tbl(i).attribute3 := FND_API.G_MISS_CHAR;

1338: l_pvt_claim_line_tbl(i).attribute2 :=l_claim_line_tbl(i).attribute2;
1339: END IF;
1340:
1341: IF l_claim_line_tbl(i).attribute3 is null then
1342: l_pvt_claim_line_tbl(i).attribute3 := FND_API.G_MISS_CHAR;
1343: ELSE
1344: l_pvt_claim_line_tbl(i).attribute3 :=l_claim_line_tbl(i).attribute3;
1345: END IF;
1346:

Line 1348: l_pvt_claim_line_tbl(i).attribute4 := FND_API.G_MISS_CHAR;

1344: l_pvt_claim_line_tbl(i).attribute3 :=l_claim_line_tbl(i).attribute3;
1345: END IF;
1346:
1347: IF l_claim_line_tbl(i).attribute4 is null then
1348: l_pvt_claim_line_tbl(i).attribute4 := FND_API.G_MISS_CHAR;
1349: ELSE
1350: l_pvt_claim_line_tbl(i).attribute4 :=l_claim_line_tbl(i).attribute4;
1351: END IF;
1352:

Line 1354: l_pvt_claim_line_tbl(i).attribute5 := FND_API.G_MISS_CHAR;

1350: l_pvt_claim_line_tbl(i).attribute4 :=l_claim_line_tbl(i).attribute4;
1351: END IF;
1352:
1353: IF l_claim_line_tbl(i).attribute5 is null then
1354: l_pvt_claim_line_tbl(i).attribute5 := FND_API.G_MISS_CHAR;
1355: ELSE
1356: l_pvt_claim_line_tbl(i).attribute5 :=l_claim_line_tbl(i).attribute5;
1357: END IF;
1358:

Line 1360: l_pvt_claim_line_tbl(i).attribute6 := FND_API.G_MISS_CHAR;

1356: l_pvt_claim_line_tbl(i).attribute5 :=l_claim_line_tbl(i).attribute5;
1357: END IF;
1358:
1359: IF l_claim_line_tbl(i).attribute6 is null then
1360: l_pvt_claim_line_tbl(i).attribute6 := FND_API.G_MISS_CHAR;
1361: ELSE
1362: l_pvt_claim_line_tbl(i).attribute6 :=l_claim_line_tbl(i).attribute6;
1363: END IF;
1364:

Line 1366: l_pvt_claim_line_tbl(i).attribute7 := FND_API.G_MISS_CHAR;

1362: l_pvt_claim_line_tbl(i).attribute6 :=l_claim_line_tbl(i).attribute6;
1363: END IF;
1364:
1365: IF l_claim_line_tbl(i).attribute7 is null then
1366: l_pvt_claim_line_tbl(i).attribute7 := FND_API.G_MISS_CHAR;
1367: ELSE
1368: l_pvt_claim_line_tbl(i).attribute7 :=l_claim_line_tbl(i).attribute7;
1369: END IF;
1370:

Line 1372: l_pvt_claim_line_tbl(i).attribute8 := FND_API.G_MISS_CHAR;

1368: l_pvt_claim_line_tbl(i).attribute7 :=l_claim_line_tbl(i).attribute7;
1369: END IF;
1370:
1371: IF l_claim_line_tbl(i).attribute8 is null then
1372: l_pvt_claim_line_tbl(i).attribute8 := FND_API.G_MISS_CHAR;
1373: ELSE
1374: l_pvt_claim_line_tbl(i).attribute8 :=l_claim_line_tbl(i).attribute8;
1375: END IF;
1376:

Line 1378: l_pvt_claim_line_tbl(i).attribute9 := FND_API.G_MISS_CHAR;

1374: l_pvt_claim_line_tbl(i).attribute8 :=l_claim_line_tbl(i).attribute8;
1375: END IF;
1376:
1377: IF l_claim_line_tbl(i).attribute9 is null then
1378: l_pvt_claim_line_tbl(i).attribute9 := FND_API.G_MISS_CHAR;
1379: ELSE
1380: l_pvt_claim_line_tbl(i).attribute9 :=l_claim_line_tbl(i).attribute9;
1381: END IF;
1382:

Line 1384: l_pvt_claim_line_tbl(i).attribute10 := FND_API.G_MISS_CHAR;

1380: l_pvt_claim_line_tbl(i).attribute9 :=l_claim_line_tbl(i).attribute9;
1381: END IF;
1382:
1383: IF l_claim_line_tbl(i).attribute10 is null then
1384: l_pvt_claim_line_tbl(i).attribute10 := FND_API.G_MISS_CHAR;
1385: ELSE
1386: l_pvt_claim_line_tbl(i).attribute10 :=l_claim_line_tbl(i).attribute10;
1387: END IF;
1388:

Line 1390: l_pvt_claim_line_tbl(i).attribute11 := FND_API.G_MISS_CHAR;

1386: l_pvt_claim_line_tbl(i).attribute10 :=l_claim_line_tbl(i).attribute10;
1387: END IF;
1388:
1389: IF l_claim_line_tbl(i).attribute11 is null then
1390: l_pvt_claim_line_tbl(i).attribute11 := FND_API.G_MISS_CHAR;
1391: ELSE
1392: l_pvt_claim_line_tbl(i).attribute11 :=l_claim_line_tbl(i).attribute11;
1393: END IF;
1394:

Line 1396: l_pvt_claim_line_tbl(i).attribute12 := FND_API.G_MISS_CHAR;

1392: l_pvt_claim_line_tbl(i).attribute11 :=l_claim_line_tbl(i).attribute11;
1393: END IF;
1394:
1395: IF l_claim_line_tbl(i).attribute12 is null then
1396: l_pvt_claim_line_tbl(i).attribute12 := FND_API.G_MISS_CHAR;
1397: ELSE
1398: l_pvt_claim_line_tbl(i).attribute12 :=l_claim_line_tbl(i).attribute12;
1399: END IF;
1400:

Line 1402: l_pvt_claim_line_tbl(i).attribute13 := FND_API.G_MISS_CHAR;

1398: l_pvt_claim_line_tbl(i).attribute12 :=l_claim_line_tbl(i).attribute12;
1399: END IF;
1400:
1401: IF l_claim_line_tbl(i).attribute13 is null then
1402: l_pvt_claim_line_tbl(i).attribute13 := FND_API.G_MISS_CHAR;
1403: ELSE
1404: l_pvt_claim_line_tbl(i).attribute13 :=l_claim_line_tbl(i).attribute13;
1405: END IF;
1406:

Line 1408: l_pvt_claim_line_tbl(i).attribute14 := FND_API.G_MISS_CHAR;

1404: l_pvt_claim_line_tbl(i).attribute13 :=l_claim_line_tbl(i).attribute13;
1405: END IF;
1406:
1407: IF l_claim_line_tbl(i).attribute14 is null then
1408: l_pvt_claim_line_tbl(i).attribute14 := FND_API.G_MISS_CHAR;
1409: ELSE
1410: l_pvt_claim_line_tbl(i).attribute14 :=l_claim_line_tbl(i).attribute14;
1411: END IF;
1412:

Line 1414: l_pvt_claim_line_tbl(i).attribute15 := FND_API.G_MISS_CHAR;

1410: l_pvt_claim_line_tbl(i).attribute14 :=l_claim_line_tbl(i).attribute14;
1411: END IF;
1412:
1413: IF l_claim_line_tbl(i).attribute15 is null then
1414: l_pvt_claim_line_tbl(i).attribute15 := FND_API.G_MISS_CHAR;
1415: ELSE
1416: l_pvt_claim_line_tbl(i).attribute15 :=l_claim_line_tbl(i).attribute15;
1417: END IF;
1418:

Line 1420: l_pvt_claim_line_tbl(i).org_id := FND_API.G_MISS_NUM;

1416: l_pvt_claim_line_tbl(i).attribute15 :=l_claim_line_tbl(i).attribute15;
1417: END IF;
1418:
1419: IF l_claim_line_tbl(i).org_id is null then
1420: l_pvt_claim_line_tbl(i).org_id := FND_API.G_MISS_NUM;
1421: ELSE
1422: l_pvt_claim_line_tbl(i).org_id :=l_claim_line_tbl(i).org_id;
1423: END IF;
1424:

Line 1426: l_pvt_claim_line_tbl(i).update_from_tbl_flag := FND_API.G_MISS_CHAR;

1422: l_pvt_claim_line_tbl(i).org_id :=l_claim_line_tbl(i).org_id;
1423: END IF;
1424:
1425: IF l_claim_line_tbl(i).update_from_tbl_flag is null then
1426: l_pvt_claim_line_tbl(i).update_from_tbl_flag := FND_API.G_MISS_CHAR;
1427: ELSE
1428: l_pvt_claim_line_tbl(i).update_from_tbl_flag :=l_claim_line_tbl(i).update_from_tbl_flag;
1429: END IF;
1430:

Line 1432: l_pvt_claim_line_tbl(i).tax_action := FND_API.G_MISS_CHAR;

1428: l_pvt_claim_line_tbl(i).update_from_tbl_flag :=l_claim_line_tbl(i).update_from_tbl_flag;
1429: END IF;
1430:
1431: IF l_claim_line_tbl(i).tax_action is null then
1432: l_pvt_claim_line_tbl(i).tax_action := FND_API.G_MISS_CHAR;
1433: ELSE
1434: l_pvt_claim_line_tbl(i).tax_action :=l_claim_line_tbl(i).tax_action;
1435: END IF;
1436:

Line 1438: l_pvt_claim_line_tbl(i).sale_date := FND_API.G_MISS_DATE;

1434: l_pvt_claim_line_tbl(i).tax_action :=l_claim_line_tbl(i).tax_action;
1435: END IF;
1436:
1437: IF l_claim_line_tbl(i).sale_date is null then
1438: l_pvt_claim_line_tbl(i).sale_date := FND_API.G_MISS_DATE;
1439: ELSE
1440: l_pvt_claim_line_tbl(i).sale_date :=l_claim_line_tbl(i).sale_date;
1441: END IF;
1442:

Line 1444: l_pvt_claim_line_tbl(i).item_type := FND_API.G_MISS_CHAR;

1440: l_pvt_claim_line_tbl(i).sale_date :=l_claim_line_tbl(i).sale_date;
1441: END IF;
1442:
1443: IF l_claim_line_tbl(i).item_type is null then
1444: l_pvt_claim_line_tbl(i).item_type := FND_API.G_MISS_CHAR;
1445: ELSE
1446: l_pvt_claim_line_tbl(i).item_type :=l_claim_line_tbl(i).item_type;
1447: END IF;
1448:

Line 1450: l_pvt_claim_line_tbl(i).tax_amount := FND_API.G_MISS_NUM;

1446: l_pvt_claim_line_tbl(i).item_type :=l_claim_line_tbl(i).item_type;
1447: END IF;
1448:
1449: IF l_claim_line_tbl(i).tax_amount is null then
1450: l_pvt_claim_line_tbl(i).tax_amount := FND_API.G_MISS_NUM;
1451: ELSE
1452: l_pvt_claim_line_tbl(i).tax_amount :=l_claim_line_tbl(i).tax_amount;
1453: END IF;
1454:

Line 1456: l_pvt_claim_line_tbl(i).claim_curr_tax_amount := FND_API.G_MISS_NUM;

1452: l_pvt_claim_line_tbl(i).tax_amount :=l_claim_line_tbl(i).tax_amount;
1453: END IF;
1454:
1455: IF l_claim_line_tbl(i).claim_curr_tax_amount is null then
1456: l_pvt_claim_line_tbl(i).claim_curr_tax_amount := FND_API.G_MISS_NUM;
1457: ELSE
1458: l_pvt_claim_line_tbl(i).claim_curr_tax_amount :=l_claim_line_tbl(i).claim_curr_tax_amount;
1459: END IF;
1460:

Line 1462: l_pvt_claim_line_tbl(i).activity_line_id := FND_API.G_MISS_NUM;

1458: l_pvt_claim_line_tbl(i).claim_curr_tax_amount :=l_claim_line_tbl(i).claim_curr_tax_amount;
1459: END IF;
1460:
1461: IF l_claim_line_tbl(i).activity_line_id is null then
1462: l_pvt_claim_line_tbl(i).activity_line_id := FND_API.G_MISS_NUM;
1463: ELSE
1464: l_pvt_claim_line_tbl(i).activity_line_id :=l_claim_line_tbl(i).activity_line_id;
1465: END IF;
1466:

Line 1468: l_pvt_claim_line_tbl(i).offer_type := FND_API.G_MISS_CHAR;

1464: l_pvt_claim_line_tbl(i).activity_line_id :=l_claim_line_tbl(i).activity_line_id;
1465: END IF;
1466:
1467: IF l_claim_line_tbl(i).offer_type is null then
1468: l_pvt_claim_line_tbl(i).offer_type := FND_API.G_MISS_CHAR;
1469: ELSE
1470: l_pvt_claim_line_tbl(i).offer_type :=l_claim_line_tbl(i).offer_type;
1471: END IF;
1472:

Line 1474: l_pvt_claim_line_tbl(i).prorate_earnings_flag := FND_API.G_MISS_CHAR;

1470: l_pvt_claim_line_tbl(i).offer_type :=l_claim_line_tbl(i).offer_type;
1471: END IF;
1472:
1473: IF l_claim_line_tbl(i).prorate_earnings_flag is null then
1474: l_pvt_claim_line_tbl(i).prorate_earnings_flag := FND_API.G_MISS_CHAR;
1475: ELSE
1476: l_pvt_claim_line_tbl(i).prorate_earnings_flag :=l_claim_line_tbl(i).prorate_earnings_flag;
1477: END IF;
1478:

Line 1480: l_pvt_claim_line_tbl(i).earnings_end_date := FND_API.G_MISS_DATE;

1476: l_pvt_claim_line_tbl(i).prorate_earnings_flag :=l_claim_line_tbl(i).prorate_earnings_flag;
1477: END IF;
1478:
1479: IF l_claim_line_tbl(i).earnings_end_date is null then
1480: l_pvt_claim_line_tbl(i).earnings_end_date := FND_API.G_MISS_DATE;
1481: ELSE
1482: l_pvt_claim_line_tbl(i).earnings_end_date :=l_claim_line_tbl(i).earnings_end_date;
1483: END IF;
1484: --12.1 Enhancement : Price Protection

Line 1486: l_pvt_claim_line_tbl(i).dpp_cust_account_id := FND_API.G_MISS_CHAR;

1482: l_pvt_claim_line_tbl(i).earnings_end_date :=l_claim_line_tbl(i).earnings_end_date;
1483: END IF;
1484: --12.1 Enhancement : Price Protection
1485: IF l_claim_line_tbl(i).dpp_cust_account_id is null then
1486: l_pvt_claim_line_tbl(i).dpp_cust_account_id := FND_API.G_MISS_CHAR;
1487: ELSE
1488: l_pvt_claim_line_tbl(i).dpp_cust_account_id :=l_claim_line_tbl(i).dpp_cust_account_id;
1489: END IF;
1490: END LOOP;

Line 1496: ,p_init_msg_list => FND_API.G_FALSE

1492:
1493: -- Call to Update claim line tbl.
1494: Ozf_Claim_Line_Pvt.Update_Claim_line_Tbl(
1495: p_api_version => p_api_version
1496: ,p_init_msg_list => FND_API.G_FALSE
1497: ,p_commit => FND_API.G_FALSE
1498: ,P_Validation_Level => p_Validation_Level
1499: ,x_return_status => x_return_status
1500: ,x_msg_data => x_msg_data

Line 1497: ,p_commit => FND_API.G_FALSE

1493: -- Call to Update claim line tbl.
1494: Ozf_Claim_Line_Pvt.Update_Claim_line_Tbl(
1495: p_api_version => p_api_version
1496: ,p_init_msg_list => FND_API.G_FALSE
1497: ,p_commit => FND_API.G_FALSE
1498: ,P_Validation_Level => p_Validation_Level
1499: ,x_return_status => x_return_status
1500: ,x_msg_data => x_msg_data
1501: ,x_msg_count => x_msg_count

Line 1503: ,p_change_object_version => FND_API.g_false

1499: ,x_return_status => x_return_status
1500: ,x_msg_data => x_msg_data
1501: ,x_msg_count => x_msg_count
1502: ,p_claim_line_tbl => l_pvt_claim_line_tbl
1503: ,p_change_object_version => FND_API.g_false
1504: ,x_error_index => l_error_index );
1505: IF g_debug THEN
1506: OZF_UTILITY_PVT.DEBUG_MESSAGE('sTATUS FOR Update claim line =>'||x_return_status);
1507: END IF;

Line 1508: IF x_return_status = FND_API.G_RET_STS_ERROR then

1504: ,x_error_index => l_error_index );
1505: IF g_debug THEN
1506: OZF_UTILITY_PVT.DEBUG_MESSAGE('sTATUS FOR Update claim line =>'||x_return_status);
1507: END IF;
1508: IF x_return_status = FND_API.G_RET_STS_ERROR then
1509: RAISE FND_API.G_EXC_ERROR;
1510: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: END IF;

Line 1509: RAISE FND_API.G_EXC_ERROR;

1505: IF g_debug THEN
1506: OZF_UTILITY_PVT.DEBUG_MESSAGE('sTATUS FOR Update claim line =>'||x_return_status);
1507: END IF;
1508: IF x_return_status = FND_API.G_RET_STS_ERROR then
1509: RAISE FND_API.G_EXC_ERROR;
1510: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: END IF;
1513: --Standard check for p_commit

Line 1510: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1506: OZF_UTILITY_PVT.DEBUG_MESSAGE('sTATUS FOR Update claim line =>'||x_return_status);
1507: END IF;
1508: IF x_return_status = FND_API.G_RET_STS_ERROR then
1509: RAISE FND_API.G_EXC_ERROR;
1510: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: END IF;
1513: --Standard check for p_commit
1514: IF FND_API.to_Boolean( p_commit )

Line 1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1507: END IF;
1508: IF x_return_status = FND_API.G_RET_STS_ERROR then
1509: RAISE FND_API.G_EXC_ERROR;
1510: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: END IF;
1513: --Standard check for p_commit
1514: IF FND_API.to_Boolean( p_commit )
1515: THEN

Line 1514: IF FND_API.to_Boolean( p_commit )

1510: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: END IF;
1513: --Standard check for p_commit
1514: IF FND_API.to_Boolean( p_commit )
1515: THEN
1516: COMMIT WORK;
1517: END IF;
1518: -- Debug Message

Line 1530: x_return_status := FND_API.g_ret_sts_error;

1526: );
1527: EXCEPTION
1528: WHEN OZF_Utility_PVT.resource_locked THEN
1529: ROLLBACK TO Update_Claim_Line_Tbl;
1530: x_return_status := FND_API.g_ret_sts_error;
1531: FND_MSG_PUB.Count_And_Get (
1532: p_encoded => FND_API.G_FALSE,
1533: p_count => x_msg_count,
1534: p_data => x_msg_data

Line 1532: p_encoded => FND_API.G_FALSE,

1528: WHEN OZF_Utility_PVT.resource_locked THEN
1529: ROLLBACK TO Update_Claim_Line_Tbl;
1530: x_return_status := FND_API.g_ret_sts_error;
1531: FND_MSG_PUB.Count_And_Get (
1532: p_encoded => FND_API.G_FALSE,
1533: p_count => x_msg_count,
1534: p_data => x_msg_data
1535: );
1536: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

Line 1537: WHEN FND_API.G_EXC_ERROR THEN

1533: p_count => x_msg_count,
1534: p_data => x_msg_data
1535: );
1536: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1537: WHEN FND_API.G_EXC_ERROR THEN
1538: ROLLBACK TO Update_Claim_Line_Tbl;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: -- Standard call to get message count and if count=1, get the message
1541: FND_MSG_PUB.Count_And_Get (

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

1535: );
1536: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1537: WHEN FND_API.G_EXC_ERROR THEN
1538: ROLLBACK TO Update_Claim_Line_Tbl;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: -- Standard call to get message count and if count=1, get the message
1541: FND_MSG_PUB.Count_And_Get (
1542: p_encoded => FND_API.G_FALSE,
1543: p_count => x_msg_count,

Line 1542: p_encoded => FND_API.G_FALSE,

1538: ROLLBACK TO Update_Claim_Line_Tbl;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: -- Standard call to get message count and if count=1, get the message
1541: FND_MSG_PUB.Count_And_Get (
1542: p_encoded => FND_API.G_FALSE,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data
1545: );
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1542: p_encoded => FND_API.G_FALSE,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data
1545: );
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1547: ROLLBACK TO Update_Claim_Line_Tbl;
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: -- Standard call to get message count and if count=1, get the message
1550: FND_MSG_PUB.Count_And_Get (

Line 1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1544: p_data => x_msg_data
1545: );
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1547: ROLLBACK TO Update_Claim_Line_Tbl;
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: -- Standard call to get message count and if count=1, get the message
1550: FND_MSG_PUB.Count_And_Get (
1551: p_encoded => FND_API.G_FALSE,
1552: p_count => x_msg_count,

Line 1551: p_encoded => FND_API.G_FALSE,

1547: ROLLBACK TO Update_Claim_Line_Tbl;
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: -- Standard call to get message count and if count=1, get the message
1550: FND_MSG_PUB.Count_And_Get (
1551: p_encoded => FND_API.G_FALSE,
1552: p_count => x_msg_count,
1553: p_data => x_msg_data
1554: );
1555: WHEN OTHERS THEN

Line 1557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1553: p_data => x_msg_data
1554: );
1555: WHEN OTHERS THEN
1556: ROLLBACK TO Update_Claim_Line_Tbl;
1557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1558: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1559: THEN
1560: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1561: END IF;

Line 1564: p_encoded => FND_API.G_FALSE,

1560: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1561: END IF;
1562: -- Standard call to get message count and if count=1, get the message
1563: FND_MSG_PUB.Count_And_Get (
1564: p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data
1567: );
1568: End Update_Claim_Line_tbl;

Line 1588: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1584: -- NOTES
1585: ---------------------------------------------------------------------
1586: PROCEDURE Delete_Claim(
1587: p_api_version_number IN NUMBER,
1588: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1589: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1590: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1591: x_return_status OUT NOCOPY VARCHAR2,
1592: x_msg_count OUT NOCOPY NUMBER,

Line 1589: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1585: ---------------------------------------------------------------------
1586: PROCEDURE Delete_Claim(
1587: p_api_version_number IN NUMBER,
1588: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1589: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1590: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1591: x_return_status OUT NOCOPY VARCHAR2,
1592: x_msg_count OUT NOCOPY NUMBER,
1593: x_msg_data OUT NOCOPY VARCHAR2,

Line 1590: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1586: PROCEDURE Delete_Claim(
1587: p_api_version_number IN NUMBER,
1588: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1589: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1590: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1591: x_return_status OUT NOCOPY VARCHAR2,
1592: x_msg_count OUT NOCOPY NUMBER,
1593: x_msg_data OUT NOCOPY VARCHAR2,
1594: p_claim_id IN NUMBER,

Line 1606: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1602: BEGIN
1603: -- Standard Start of API savepoint
1604: SAVEPOINT DELETE_Claim_PUB;
1605: -- Standard call to check for call compatibility.
1606: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1607: p_api_version_number,
1608: l_api_name,
1609: G_PKG_NAME)
1610: THEN

Line 1611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1607: p_api_version_number,
1608: l_api_name,
1609: G_PKG_NAME)
1610: THEN
1611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1612: END IF;
1613: -- Initialize message list if p_init_msg_list is set to TRUE.
1614: IF FND_API.to_Boolean( p_init_msg_list )
1615: THEN

Line 1614: IF FND_API.to_Boolean( p_init_msg_list )

1610: THEN
1611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1612: END IF;
1613: -- Initialize message list if p_init_msg_list is set to TRUE.
1614: IF FND_API.to_Boolean( p_init_msg_list )
1615: THEN
1616: FND_MSG_PUB.initialize;
1617: END IF;
1618: -- Debug Message

Line 1623: x_return_status := FND_API.G_RET_STS_SUCCESS;

1619: IF g_debug THEN
1620: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
1621: END IF;
1622: -- Initialize API return status to SUCCESS
1623: x_return_status := FND_API.G_RET_STS_SUCCESS;
1624: --
1625: -- Calling private API
1626: --
1627: OZF_Claim_PVT.Delete_Claim(

Line 1629: p_init_msg_list => FND_API.G_FALSE,

1625: -- Calling private API
1626: --
1627: OZF_Claim_PVT.Delete_Claim(
1628: p_api_version_number => p_api_version_number,
1629: p_init_msg_list => FND_API.G_FALSE,
1630: p_commit => FND_API.G_FALSE,
1631: p_object_id => l_claim_id,
1632: p_object_version_number => l_object_version_number,
1633: x_return_status => x_return_status,

Line 1630: p_commit => FND_API.G_FALSE,

1626: --
1627: OZF_Claim_PVT.Delete_Claim(
1628: p_api_version_number => p_api_version_number,
1629: p_init_msg_list => FND_API.G_FALSE,
1630: p_commit => FND_API.G_FALSE,
1631: p_object_id => l_claim_id,
1632: p_object_version_number => l_object_version_number,
1633: x_return_status => x_return_status,
1634: x_msg_count => x_msg_count,

Line 1644: IF FND_API.to_Boolean( p_commit )

1640: END IF;
1641: -- Check return status from the above procedure call
1642: --
1643: -- Standard check for p_commit
1644: IF FND_API.to_Boolean( p_commit )
1645: THEN
1646: COMMIT WORK;
1647: END IF;
1648: -- Debug Message

Line 1660: x_return_status := FND_API.g_ret_sts_error;

1656: );
1657: EXCEPTION
1658: WHEN OZF_Utility_PVT.resource_locked THEN
1659: ROLLBACK TO DELETE_Claim_PUB;
1660: x_return_status := FND_API.g_ret_sts_error;
1661: FND_MSG_PUB.Count_And_Get (
1662: p_encoded => FND_API.G_FALSE,
1663: p_count => x_msg_count,
1664: p_data => x_msg_data

Line 1662: p_encoded => FND_API.G_FALSE,

1658: WHEN OZF_Utility_PVT.resource_locked THEN
1659: ROLLBACK TO DELETE_Claim_PUB;
1660: x_return_status := FND_API.g_ret_sts_error;
1661: FND_MSG_PUB.Count_And_Get (
1662: p_encoded => FND_API.G_FALSE,
1663: p_count => x_msg_count,
1664: p_data => x_msg_data
1665: );
1666: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

Line 1667: WHEN FND_API.G_EXC_ERROR THEN

1663: p_count => x_msg_count,
1664: p_data => x_msg_data
1665: );
1666: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1667: WHEN FND_API.G_EXC_ERROR THEN
1668: ROLLBACK TO DELETE_Claim_PUB;
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670: -- Standard call to get message count and if count=1, get the message
1671: FND_MSG_PUB.Count_And_Get (

Line 1669: x_return_status := FND_API.G_RET_STS_ERROR;

1665: );
1666: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1667: WHEN FND_API.G_EXC_ERROR THEN
1668: ROLLBACK TO DELETE_Claim_PUB;
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670: -- Standard call to get message count and if count=1, get the message
1671: FND_MSG_PUB.Count_And_Get (
1672: p_encoded => FND_API.G_FALSE,
1673: p_count => x_msg_count,

Line 1672: p_encoded => FND_API.G_FALSE,

1668: ROLLBACK TO DELETE_Claim_PUB;
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670: -- Standard call to get message count and if count=1, get the message
1671: FND_MSG_PUB.Count_And_Get (
1672: p_encoded => FND_API.G_FALSE,
1673: p_count => x_msg_count,
1674: p_data => x_msg_data
1675: );
1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1672: p_encoded => FND_API.G_FALSE,
1673: p_count => x_msg_count,
1674: p_data => x_msg_data
1675: );
1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1677: ROLLBACK TO DELETE_Claim_PUB;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: -- Standard call to get message count and if count=1, get the message
1680: FND_MSG_PUB.Count_And_Get (

Line 1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1674: p_data => x_msg_data
1675: );
1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1677: ROLLBACK TO DELETE_Claim_PUB;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: -- Standard call to get message count and if count=1, get the message
1680: FND_MSG_PUB.Count_And_Get (
1681: p_encoded => FND_API.G_FALSE,
1682: p_count => x_msg_count,

Line 1681: p_encoded => FND_API.G_FALSE,

1677: ROLLBACK TO DELETE_Claim_PUB;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: -- Standard call to get message count and if count=1, get the message
1680: FND_MSG_PUB.Count_And_Get (
1681: p_encoded => FND_API.G_FALSE,
1682: p_count => x_msg_count,
1683: p_data => x_msg_data
1684: );
1685: WHEN OTHERS THEN

Line 1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1683: p_data => x_msg_data
1684: );
1685: WHEN OTHERS THEN
1686: ROLLBACK TO DELETE_Claim_PUB;
1687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1688: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1689: THEN
1690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1691: END IF;

Line 1694: p_encoded => FND_API.G_FALSE,

1690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1691: END IF;
1692: -- Standard call to get message count and if count=1, get the message
1693: FND_MSG_PUB.Count_And_Get (
1694: p_encoded => FND_API.G_FALSE,
1695: p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );
1698: End Delete_Claim;

Line 1718: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

1714: -- NOTES
1715: ---------------------------------------------------------------------
1716: PROCEDURE Delete_Claim_Line_Tbl(
1717: p_api_version IN NUMBER
1718: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1719: ,p_commit IN VARCHAR2 := FND_API.g_false
1720: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1721: ,x_return_status OUT NOCOPY VARCHAR2
1722: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1719: ,p_commit IN VARCHAR2 := FND_API.g_false

1715: ---------------------------------------------------------------------
1716: PROCEDURE Delete_Claim_Line_Tbl(
1717: p_api_version IN NUMBER
1718: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1719: ,p_commit IN VARCHAR2 := FND_API.g_false
1720: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1721: ,x_return_status OUT NOCOPY VARCHAR2
1722: ,x_msg_data OUT NOCOPY VARCHAR2
1723: ,x_msg_count OUT NOCOPY NUMBER

Line 1720: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

1716: PROCEDURE Delete_Claim_Line_Tbl(
1717: p_api_version IN NUMBER
1718: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1719: ,p_commit IN VARCHAR2 := FND_API.g_false
1720: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1721: ,x_return_status OUT NOCOPY VARCHAR2
1722: ,x_msg_data OUT NOCOPY VARCHAR2
1723: ,x_msg_count OUT NOCOPY NUMBER
1724: ,p_claim_line_tbl IN claim_line_tbl_type

Line 1725: ,p_change_object_version IN VARCHAR2 := FND_API.g_false

1721: ,x_return_status OUT NOCOPY VARCHAR2
1722: ,x_msg_data OUT NOCOPY VARCHAR2
1723: ,x_msg_count OUT NOCOPY NUMBER
1724: ,p_claim_line_tbl IN claim_line_tbl_type
1725: ,p_change_object_version IN VARCHAR2 := FND_API.g_false
1726: ,x_error_index OUT NOCOPY NUMBER)
1727: IS
1728: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Claim_Line';
1729: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 1737: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1733: BEGIN
1734: -- Standard Start of API savepoint
1735: SAVEPOINT DELETE_Claim_Line_PUB;
1736: -- Standard call to check for call compatibility.
1737: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1738: p_api_version,
1739: l_api_name,
1740: G_PKG_NAME)
1741: THEN

Line 1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1738: p_api_version,
1739: l_api_name,
1740: G_PKG_NAME)
1741: THEN
1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1743: END IF;
1744: -- Initialize message list if p_init_msg_list is set to TRUE.
1745: IF FND_API.to_Boolean( p_init_msg_list )
1746: THEN

Line 1745: IF FND_API.to_Boolean( p_init_msg_list )

1741: THEN
1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1743: END IF;
1744: -- Initialize message list if p_init_msg_list is set to TRUE.
1745: IF FND_API.to_Boolean( p_init_msg_list )
1746: THEN
1747: FND_MSG_PUB.initialize;
1748: END IF;
1749: -- Debug Message

Line 1754: x_return_status := FND_API.G_RET_STS_SUCCESS;

1750: IF g_debug THEN
1751: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
1752: END IF;
1753: -- Initialize API return status to SUCCESS
1754: x_return_status := FND_API.G_RET_STS_SUCCESS;
1755: --
1756: -- API body
1757: --
1758: l_claim_line_tbl := p_claim_line_tbl;

Line 1769: ,p_init_msg_list => FND_API.G_FALSE

1765: END LOOP;
1766: END IF;
1767: OZF_Claim_Line_PVT.Delete_Claim_Line_Tbl(
1768: p_api_version => p_api_version
1769: ,p_init_msg_list => FND_API.G_FALSE
1770: ,p_commit => FND_API.G_FALSE
1771: ,P_Validation_Level => p_Validation_Level
1772: ,x_return_status => x_return_status
1773: ,x_msg_data => x_msg_data

Line 1770: ,p_commit => FND_API.G_FALSE

1766: END IF;
1767: OZF_Claim_Line_PVT.Delete_Claim_Line_Tbl(
1768: p_api_version => p_api_version
1769: ,p_init_msg_list => FND_API.G_FALSE
1770: ,p_commit => FND_API.G_FALSE
1771: ,P_Validation_Level => p_Validation_Level
1772: ,x_return_status => x_return_status
1773: ,x_msg_data => x_msg_data
1774: ,x_msg_count => x_msg_count

Line 1776: ,p_change_object_version => FND_API.g_false

1772: ,x_return_status => x_return_status
1773: ,x_msg_data => x_msg_data
1774: ,x_msg_count => x_msg_count
1775: ,p_claim_line_tbl => l_pvt_claim_line_tbl
1776: ,p_change_object_version => FND_API.g_false
1777: ,x_error_index => l_error_index);
1778: IF g_debug THEN
1779: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM_Line_Tbl =>'||X_RETURN_STATUS);
1780: END IF;

Line 1782: IF x_return_status = FND_API.G_RET_STS_ERROR then

1778: IF g_debug THEN
1779: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM_Line_Tbl =>'||X_RETURN_STATUS);
1780: END IF;
1781: -- Check return status from the above procedure call
1782: IF x_return_status = FND_API.G_RET_STS_ERROR then
1783: RAISE FND_API.G_EXC_ERROR;
1784: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786: END IF;

Line 1783: RAISE FND_API.G_EXC_ERROR;

1779: OZF_UTILITY_PVT.DEBUG_MESSAGE('RETURN STATUS FOR DELETE_CLAIM_Line_Tbl =>'||X_RETURN_STATUS);
1780: END IF;
1781: -- Check return status from the above procedure call
1782: IF x_return_status = FND_API.G_RET_STS_ERROR then
1783: RAISE FND_API.G_EXC_ERROR;
1784: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786: END IF;
1787: --

Line 1784: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1780: END IF;
1781: -- Check return status from the above procedure call
1782: IF x_return_status = FND_API.G_RET_STS_ERROR then
1783: RAISE FND_API.G_EXC_ERROR;
1784: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786: END IF;
1787: --
1788: -- End of API body

Line 1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1781: -- Check return status from the above procedure call
1782: IF x_return_status = FND_API.G_RET_STS_ERROR then
1783: RAISE FND_API.G_EXC_ERROR;
1784: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786: END IF;
1787: --
1788: -- End of API body
1789: --

Line 1791: IF FND_API.to_Boolean( p_commit )

1787: --
1788: -- End of API body
1789: --
1790: -- Standard check for p_commit
1791: IF FND_API.to_Boolean( p_commit )
1792: THEN
1793: COMMIT WORK;
1794: END IF;
1795: -- Debug Message

Line 1807: x_return_status := FND_API.G_RET_STS_ERROR;

1803: );
1804: EXCEPTION
1805: WHEN OZF_Utility_PVT.resource_locked THEN
1806: ROLLBACK TO DELETE_Claim_Line_PUB;
1807: x_return_status := FND_API.G_RET_STS_ERROR;
1808: -- Standard call to get message count and if count=1, get the message
1809: FND_MSG_PUB.Count_And_Get (
1810: p_encoded => FND_API.G_FALSE,
1811: p_count => x_msg_count,

Line 1810: p_encoded => FND_API.G_FALSE,

1806: ROLLBACK TO DELETE_Claim_Line_PUB;
1807: x_return_status := FND_API.G_RET_STS_ERROR;
1808: -- Standard call to get message count and if count=1, get the message
1809: FND_MSG_PUB.Count_And_Get (
1810: p_encoded => FND_API.G_FALSE,
1811: p_count => x_msg_count,
1812: p_data => x_msg_data
1813: );
1814: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

Line 1815: WHEN FND_API.G_EXC_ERROR THEN

1811: p_count => x_msg_count,
1812: p_data => x_msg_data
1813: );
1814: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1815: WHEN FND_API.G_EXC_ERROR THEN
1816: ROLLBACK TO DELETE_Claim_Line_PUB;
1817: x_return_status := FND_API.G_RET_STS_ERROR;
1818: -- Standard call to get message count and if count=1, get the message
1819: FND_MSG_PUB.Count_And_Get (

Line 1817: x_return_status := FND_API.G_RET_STS_ERROR;

1813: );
1814: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1815: WHEN FND_API.G_EXC_ERROR THEN
1816: ROLLBACK TO DELETE_Claim_Line_PUB;
1817: x_return_status := FND_API.G_RET_STS_ERROR;
1818: -- Standard call to get message count and if count=1, get the message
1819: FND_MSG_PUB.Count_And_Get (
1820: p_encoded => FND_API.G_FALSE,
1821: p_count => x_msg_count,

Line 1820: p_encoded => FND_API.G_FALSE,

1816: ROLLBACK TO DELETE_Claim_Line_PUB;
1817: x_return_status := FND_API.G_RET_STS_ERROR;
1818: -- Standard call to get message count and if count=1, get the message
1819: FND_MSG_PUB.Count_And_Get (
1820: p_encoded => FND_API.G_FALSE,
1821: p_count => x_msg_count,
1822: p_data => x_msg_data
1823: );
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1820: p_encoded => FND_API.G_FALSE,
1821: p_count => x_msg_count,
1822: p_data => x_msg_data
1823: );
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825: ROLLBACK TO DELETE_Claim_Line_PUB;
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827: -- Standard call to get message count and if count=1, get the message
1828: FND_MSG_PUB.Count_And_Get (

Line 1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1822: p_data => x_msg_data
1823: );
1824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1825: ROLLBACK TO DELETE_Claim_Line_PUB;
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827: -- Standard call to get message count and if count=1, get the message
1828: FND_MSG_PUB.Count_And_Get (
1829: p_encoded => FND_API.G_FALSE,
1830: p_count => x_msg_count,

Line 1829: p_encoded => FND_API.G_FALSE,

1825: ROLLBACK TO DELETE_Claim_Line_PUB;
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827: -- Standard call to get message count and if count=1, get the message
1828: FND_MSG_PUB.Count_And_Get (
1829: p_encoded => FND_API.G_FALSE,
1830: p_count => x_msg_count,
1831: p_data => x_msg_data
1832: );
1833: WHEN OTHERS THEN

Line 1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1831: p_data => x_msg_data
1832: );
1833: WHEN OTHERS THEN
1834: ROLLBACK TO DELETE_Claim_PUB;
1835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1836: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1837: THEN
1838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1839: END IF;

Line 1842: p_encoded => FND_API.G_FALSE,

1838: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1839: END IF;
1840: -- Standard call to get message count and if count=1, get the message
1841: FND_MSG_PUB.Count_And_Get (
1842: p_encoded => FND_API.G_FALSE,
1843: p_count => x_msg_count,
1844: p_data => x_msg_data
1845: );
1846: End Delete_Claim_Line_Tbl;

Line 1871: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

1867: -- NOTES
1868: ---------------------------------------------------------------------
1869: PROCEDURE Asso_Accruals_To_Claim(
1870: p_api_version IN NUMBER
1871: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1872: ,p_commit IN VARCHAR2 := FND_API.g_false
1873: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1874: ,x_return_status OUT NOCOPY VARCHAR2
1875: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1872: ,p_commit IN VARCHAR2 := FND_API.g_false

1868: ---------------------------------------------------------------------
1869: PROCEDURE Asso_Accruals_To_Claim(
1870: p_api_version IN NUMBER
1871: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1872: ,p_commit IN VARCHAR2 := FND_API.g_false
1873: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1874: ,x_return_status OUT NOCOPY VARCHAR2
1875: ,x_msg_data OUT NOCOPY VARCHAR2
1876: ,x_msg_count OUT NOCOPY NUMBER

Line 1873: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

1869: PROCEDURE Asso_Accruals_To_Claim(
1870: p_api_version IN NUMBER
1871: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1872: ,p_commit IN VARCHAR2 := FND_API.g_false
1873: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1874: ,x_return_status OUT NOCOPY VARCHAR2
1875: ,x_msg_data OUT NOCOPY VARCHAR2
1876: ,x_msg_count OUT NOCOPY NUMBER
1877: ,p_claim_id IN NUMBER

Line 1897: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1893: OZF_Utility_PVT.debug_message(l_full_name||': start');
1894: END IF;
1895:
1896: -- Standard call to check for call compatibility.
1897: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1898: p_api_version,
1899: l_api_name,
1900: G_PKG_NAME ) THEN
1901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1897: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1898: p_api_version,
1899: l_api_name,
1900: G_PKG_NAME ) THEN
1901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1902: END IF;
1903:
1904: -- Initialize message list if p_init_msg_list is set to TRUE.
1905: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1905: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1902: END IF;
1903:
1904: -- Initialize message list if p_init_msg_list is set to TRUE.
1905: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1906: FND_MSG_PUB.initialize;
1907: END IF;
1908:
1909: -- Initialize API return status to SUCCESS

Line 1910: x_return_status := FND_API.G_RET_STS_SUCCESS;

1906: FND_MSG_PUB.initialize;
1907: END IF;
1908:
1909: -- Initialize API return status to SUCCESS
1910: x_return_status := FND_API.G_RET_STS_SUCCESS;
1911:
1912: ------------------------------------------
1913: -- 1. Default and derive column valude --
1914: ------------------------------------------

Line 1945: ,p_init_msg_list => FND_API.g_false

1941: -- 2. Call OZF_CLAIM_ACCRUAL_PVT
1942: ------------------------------------------
1943: OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim(
1944: p_api_version => l_api_version
1945: ,p_init_msg_list => FND_API.g_false
1946: ,p_commit => FND_API.g_false
1947: ,p_validation_level => FND_API.g_valid_level_full
1948:
1949: ,x_return_status => l_return_status

Line 1946: ,p_commit => FND_API.g_false

1942: ------------------------------------------
1943: OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim(
1944: p_api_version => l_api_version
1945: ,p_init_msg_list => FND_API.g_false
1946: ,p_commit => FND_API.g_false
1947: ,p_validation_level => FND_API.g_valid_level_full
1948:
1949: ,x_return_status => l_return_status
1950: ,x_msg_count => x_msg_count

Line 1947: ,p_validation_level => FND_API.g_valid_level_full

1943: OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim(
1944: p_api_version => l_api_version
1945: ,p_init_msg_list => FND_API.g_false
1946: ,p_commit => FND_API.g_false
1947: ,p_validation_level => FND_API.g_valid_level_full
1948:
1949: ,x_return_status => l_return_status
1950: ,x_msg_count => x_msg_count
1951: ,x_msg_data => x_msg_data

Line 1956: IF l_return_status = FND_API.g_ret_sts_error THEN

1952:
1953: ,p_claim_id => p_claim_id
1954: ,p_funds_util_flt => l_funds_util_flt
1955: );
1956: IF l_return_status = FND_API.g_ret_sts_error THEN
1957: RAISE FND_API.g_exc_error;
1958: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1959: RAISE FND_API.g_exc_unexpected_error;
1960: END IF;

Line 1957: RAISE FND_API.g_exc_error;

1953: ,p_claim_id => p_claim_id
1954: ,p_funds_util_flt => l_funds_util_flt
1955: );
1956: IF l_return_status = FND_API.g_ret_sts_error THEN
1957: RAISE FND_API.g_exc_error;
1958: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1959: RAISE FND_API.g_exc_unexpected_error;
1960: END IF;
1961:

Line 1958: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1954: ,p_funds_util_flt => l_funds_util_flt
1955: );
1956: IF l_return_status = FND_API.g_ret_sts_error THEN
1957: RAISE FND_API.g_exc_error;
1958: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1959: RAISE FND_API.g_exc_unexpected_error;
1960: END IF;
1961:
1962: -- Standard check for p_commit

Line 1959: RAISE FND_API.g_exc_unexpected_error;

1955: );
1956: IF l_return_status = FND_API.g_ret_sts_error THEN
1957: RAISE FND_API.g_exc_error;
1958: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1959: RAISE FND_API.g_exc_unexpected_error;
1960: END IF;
1961:
1962: -- Standard check for p_commit
1963: IF FND_API.to_Boolean(p_commit) THEN

Line 1963: IF FND_API.to_Boolean(p_commit) THEN

1959: RAISE FND_API.g_exc_unexpected_error;
1960: END IF;
1961:
1962: -- Standard check for p_commit
1963: IF FND_API.to_Boolean(p_commit) THEN
1964: COMMIT WORK;
1965: END IF;
1966:
1967: IF G_DEBUG THEN

Line 1978: WHEN FND_API.G_EXC_ERROR THEN

1974: p_data => x_msg_data
1975: );
1976:
1977: EXCEPTION
1978: WHEN FND_API.G_EXC_ERROR THEN
1979: ROLLBACK TO Asso_Accruals_To_Claim;
1980: x_return_status := FND_API.G_RET_STS_ERROR;
1981: FND_MSG_PUB.Count_And_Get (
1982: p_encoded => FND_API.G_FALSE,

Line 1980: x_return_status := FND_API.G_RET_STS_ERROR;

1976:
1977: EXCEPTION
1978: WHEN FND_API.G_EXC_ERROR THEN
1979: ROLLBACK TO Asso_Accruals_To_Claim;
1980: x_return_status := FND_API.G_RET_STS_ERROR;
1981: FND_MSG_PUB.Count_And_Get (
1982: p_encoded => FND_API.G_FALSE,
1983: p_count => x_msg_count,
1984: p_data => x_msg_data

Line 1982: p_encoded => FND_API.G_FALSE,

1978: WHEN FND_API.G_EXC_ERROR THEN
1979: ROLLBACK TO Asso_Accruals_To_Claim;
1980: x_return_status := FND_API.G_RET_STS_ERROR;
1981: FND_MSG_PUB.Count_And_Get (
1982: p_encoded => FND_API.G_FALSE,
1983: p_count => x_msg_count,
1984: p_data => x_msg_data
1985: );
1986:

Line 1987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1983: p_count => x_msg_count,
1984: p_data => x_msg_data
1985: );
1986:
1987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1988: ROLLBACK TO Asso_Accruals_To_Claim;
1989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1991: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');

Line 1989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1985: );
1986:
1987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1988: ROLLBACK TO Asso_Accruals_To_Claim;
1989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1991: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
1992: FND_MSG_PUB.add;
1993: END IF;

Line 1995: p_encoded => FND_API.G_FALSE,

1991: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
1992: FND_MSG_PUB.add;
1993: END IF;
1994: FND_MSG_PUB.Count_And_Get (
1995: p_encoded => FND_API.G_FALSE,
1996: p_count => x_msg_count,
1997: p_data => x_msg_data
1998: );
1999:

Line 2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1998: );
1999:
2000: WHEN OTHERS THEN
2001: ROLLBACK TO Asso_Accruals_To_Claim;
2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2003: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2004: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2005: FND_MSG_PUB.add;
2006: END IF;

Line 2008: p_encoded => FND_API.G_FALSE,

2004: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2005: FND_MSG_PUB.add;
2006: END IF;
2007: FND_MSG_PUB.Count_And_Get (
2008: p_encoded => FND_API.G_FALSE,
2009: p_count => x_msg_count,
2010: p_data => x_msg_data
2011: );
2012: END Asso_Accruals_To_Claim;

Line 2034: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

2030: -- NOTES
2031: ---------------------------------------------------------------------
2032: PROCEDURE Asso_Accruals_To_Claim_Line(
2033: p_api_version IN NUMBER
2034: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2035: ,p_commit IN VARCHAR2 := FND_API.g_false
2036: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
2037: ,x_return_status OUT NOCOPY VARCHAR2
2038: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2035: ,p_commit IN VARCHAR2 := FND_API.g_false

2031: ---------------------------------------------------------------------
2032: PROCEDURE Asso_Accruals_To_Claim_Line(
2033: p_api_version IN NUMBER
2034: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2035: ,p_commit IN VARCHAR2 := FND_API.g_false
2036: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
2037: ,x_return_status OUT NOCOPY VARCHAR2
2038: ,x_msg_data OUT NOCOPY VARCHAR2
2039: ,x_msg_count OUT NOCOPY NUMBER

Line 2036: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

2032: PROCEDURE Asso_Accruals_To_Claim_Line(
2033: p_api_version IN NUMBER
2034: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2035: ,p_commit IN VARCHAR2 := FND_API.g_false
2036: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
2037: ,x_return_status OUT NOCOPY VARCHAR2
2038: ,x_msg_data OUT NOCOPY VARCHAR2
2039: ,x_msg_count OUT NOCOPY NUMBER
2040: ,p_claim_line_id IN NUMBER

Line 2057: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2053: OZF_Utility_PVT.debug_message(l_full_name||': start');
2054: END IF;
2055:
2056: -- Standard call to check for call compatibility.
2057: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2058: p_api_version,
2059: l_api_name,
2060: G_PKG_NAME ) THEN
2061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2057: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2058: p_api_version,
2059: l_api_name,
2060: G_PKG_NAME ) THEN
2061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2062: END IF;
2063:
2064: -- Initialize message list if p_init_msg_list is set to TRUE.
2065: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2065: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2062: END IF;
2063:
2064: -- Initialize message list if p_init_msg_list is set to TRUE.
2065: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2066: FND_MSG_PUB.initialize;
2067: END IF;
2068:
2069: -- Initialize API return status to SUCCESS

Line 2070: x_return_status := FND_API.G_RET_STS_SUCCESS;

2066: FND_MSG_PUB.initialize;
2067: END IF;
2068:
2069: -- Initialize API return status to SUCCESS
2070: x_return_status := FND_API.G_RET_STS_SUCCESS;
2071:
2072: ------------------------------------------
2073: -- 1. Call OZF_CLAIM_ACCRUAL_PVT
2074: ------------------------------------------

Line 2077: ,p_init_msg_list => FND_API.g_false

2073: -- 1. Call OZF_CLAIM_ACCRUAL_PVT
2074: ------------------------------------------
2075: OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim_Line(
2076: p_api_version => l_api_version
2077: ,p_init_msg_list => FND_API.g_false
2078: ,p_commit => FND_API.g_false
2079: ,p_validation_level => FND_API.g_valid_level_full
2080:
2081: ,x_return_status => l_return_status

Line 2078: ,p_commit => FND_API.g_false

2074: ------------------------------------------
2075: OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim_Line(
2076: p_api_version => l_api_version
2077: ,p_init_msg_list => FND_API.g_false
2078: ,p_commit => FND_API.g_false
2079: ,p_validation_level => FND_API.g_valid_level_full
2080:
2081: ,x_return_status => l_return_status
2082: ,x_msg_count => x_msg_count

Line 2079: ,p_validation_level => FND_API.g_valid_level_full

2075: OZF_Claim_Accrual_PVT.Asso_Accruals_To_Claim_Line(
2076: p_api_version => l_api_version
2077: ,p_init_msg_list => FND_API.g_false
2078: ,p_commit => FND_API.g_false
2079: ,p_validation_level => FND_API.g_valid_level_full
2080:
2081: ,x_return_status => l_return_status
2082: ,x_msg_count => x_msg_count
2083: ,x_msg_data => x_msg_data

Line 2087: IF l_return_status = FND_API.g_ret_sts_error THEN

2083: ,x_msg_data => x_msg_data
2084:
2085: ,p_claim_line_id => p_claim_line_id
2086: );
2087: IF l_return_status = FND_API.g_ret_sts_error THEN
2088: RAISE FND_API.g_exc_error;
2089: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2090: RAISE FND_API.g_exc_unexpected_error;
2091: END IF;

Line 2088: RAISE FND_API.g_exc_error;

2084:
2085: ,p_claim_line_id => p_claim_line_id
2086: );
2087: IF l_return_status = FND_API.g_ret_sts_error THEN
2088: RAISE FND_API.g_exc_error;
2089: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2090: RAISE FND_API.g_exc_unexpected_error;
2091: END IF;
2092:

Line 2089: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2085: ,p_claim_line_id => p_claim_line_id
2086: );
2087: IF l_return_status = FND_API.g_ret_sts_error THEN
2088: RAISE FND_API.g_exc_error;
2089: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2090: RAISE FND_API.g_exc_unexpected_error;
2091: END IF;
2092:
2093: -- Standard check for p_commit

Line 2090: RAISE FND_API.g_exc_unexpected_error;

2086: );
2087: IF l_return_status = FND_API.g_ret_sts_error THEN
2088: RAISE FND_API.g_exc_error;
2089: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2090: RAISE FND_API.g_exc_unexpected_error;
2091: END IF;
2092:
2093: -- Standard check for p_commit
2094: IF FND_API.to_Boolean(p_commit) THEN

Line 2094: IF FND_API.to_Boolean(p_commit) THEN

2090: RAISE FND_API.g_exc_unexpected_error;
2091: END IF;
2092:
2093: -- Standard check for p_commit
2094: IF FND_API.to_Boolean(p_commit) THEN
2095: COMMIT WORK;
2096: END IF;
2097:
2098: IF G_DEBUG THEN

Line 2109: WHEN FND_API.G_EXC_ERROR THEN

2105: p_data => x_msg_data
2106: );
2107:
2108: EXCEPTION
2109: WHEN FND_API.G_EXC_ERROR THEN
2110: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2111: x_return_status := FND_API.G_RET_STS_ERROR;
2112: FND_MSG_PUB.Count_And_Get (
2113: p_encoded => FND_API.G_FALSE,

Line 2111: x_return_status := FND_API.G_RET_STS_ERROR;

2107:
2108: EXCEPTION
2109: WHEN FND_API.G_EXC_ERROR THEN
2110: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2111: x_return_status := FND_API.G_RET_STS_ERROR;
2112: FND_MSG_PUB.Count_And_Get (
2113: p_encoded => FND_API.G_FALSE,
2114: p_count => x_msg_count,
2115: p_data => x_msg_data

Line 2113: p_encoded => FND_API.G_FALSE,

2109: WHEN FND_API.G_EXC_ERROR THEN
2110: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2111: x_return_status := FND_API.G_RET_STS_ERROR;
2112: FND_MSG_PUB.Count_And_Get (
2113: p_encoded => FND_API.G_FALSE,
2114: p_count => x_msg_count,
2115: p_data => x_msg_data
2116: );
2117:

Line 2118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2114: p_count => x_msg_count,
2115: p_data => x_msg_data
2116: );
2117:
2118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2119: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2121: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2122: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');

Line 2120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2116: );
2117:
2118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2119: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2121: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2122: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2123: FND_MSG_PUB.add;
2124: END IF;

Line 2126: p_encoded => FND_API.G_FALSE,

2122: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2123: FND_MSG_PUB.add;
2124: END IF;
2125: FND_MSG_PUB.Count_And_Get (
2126: p_encoded => FND_API.G_FALSE,
2127: p_count => x_msg_count,
2128: p_data => x_msg_data
2129: );
2130:

Line 2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2129: );
2130:
2131: WHEN OTHERS THEN
2132: ROLLBACK TO Asso_Accruals_To_Claim_Line;
2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2135: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2136: FND_MSG_PUB.add;
2137: END IF;

Line 2139: p_encoded => FND_API.G_FALSE,

2135: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2136: FND_MSG_PUB.add;
2137: END IF;
2138: FND_MSG_PUB.Count_And_Get (
2139: p_encoded => FND_API.G_FALSE,
2140: p_count => x_msg_count,
2141: p_data => x_msg_data
2142: );
2143: END Asso_Accruals_To_Claim_Line;

Line 2167: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

2163: -- NOTES
2164: ---------------------------------------------------------------------
2165: PROCEDURE Create_Claim_For_Accruals(
2166: p_api_version IN NUMBER
2167: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2168: ,p_commit IN VARCHAR2 := FND_API.g_false
2169: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
2170: ,x_return_status OUT NOCOPY VARCHAR2
2171: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2168: ,p_commit IN VARCHAR2 := FND_API.g_false

2164: ---------------------------------------------------------------------
2165: PROCEDURE Create_Claim_For_Accruals(
2166: p_api_version IN NUMBER
2167: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2168: ,p_commit IN VARCHAR2 := FND_API.g_false
2169: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
2170: ,x_return_status OUT NOCOPY VARCHAR2
2171: ,x_msg_data OUT NOCOPY VARCHAR2
2172: ,x_msg_count OUT NOCOPY NUMBER

Line 2169: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

2165: PROCEDURE Create_Claim_For_Accruals(
2166: p_api_version IN NUMBER
2167: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2168: ,p_commit IN VARCHAR2 := FND_API.g_false
2169: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
2170: ,x_return_status OUT NOCOPY VARCHAR2
2171: ,x_msg_data OUT NOCOPY VARCHAR2
2172: ,x_msg_count OUT NOCOPY NUMBER
2173: ,p_claim_rec IN claim_rec_type

Line 2195: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2191: OZF_Utility_PVT.debug_message(l_full_name||': start');
2192: END IF;
2193:
2194: -- Standard call to check for call compatibility.
2195: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2196: p_api_version,
2197: l_api_name,
2198: G_PKG_NAME ) THEN
2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2195: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2196: p_api_version,
2197: l_api_name,
2198: G_PKG_NAME ) THEN
2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2200: END IF;
2201:
2202: -- Initialize message list if p_init_msg_list is set to TRUE.
2203: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2203: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2200: END IF;
2201:
2202: -- Initialize message list if p_init_msg_list is set to TRUE.
2203: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2204: FND_MSG_PUB.initialize;
2205: END IF;
2206:
2207: -- Initialize API return status to SUCCESS

Line 2208: x_return_status := FND_API.G_RET_STS_SUCCESS;

2204: FND_MSG_PUB.initialize;
2205: END IF;
2206:
2207: -- Initialize API return status to SUCCESS
2208: x_return_status := FND_API.G_RET_STS_SUCCESS;
2209:
2210: ------------------------------------------
2211: -- 1. Default and derive column valude --
2212: ------------------------------------------

Line 2305: ,p_init_msg_list => FND_API.g_false

2301: -- 2. Call OZF_CLAIM_ACCRUAL_PVT
2302: ------------------------------------------
2303: OZF_Claim_Accrual_PVT.Create_Claim_For_Accruals(
2304: p_api_version => l_api_version
2305: ,p_init_msg_list => FND_API.g_false
2306: ,p_commit => FND_API.g_false
2307: ,p_validation_level => FND_API.g_valid_level_full
2308:
2309: ,x_return_status => l_return_status

Line 2306: ,p_commit => FND_API.g_false

2302: ------------------------------------------
2303: OZF_Claim_Accrual_PVT.Create_Claim_For_Accruals(
2304: p_api_version => l_api_version
2305: ,p_init_msg_list => FND_API.g_false
2306: ,p_commit => FND_API.g_false
2307: ,p_validation_level => FND_API.g_valid_level_full
2308:
2309: ,x_return_status => l_return_status
2310: ,x_msg_count => x_msg_count

Line 2307: ,p_validation_level => FND_API.g_valid_level_full

2303: OZF_Claim_Accrual_PVT.Create_Claim_For_Accruals(
2304: p_api_version => l_api_version
2305: ,p_init_msg_list => FND_API.g_false
2306: ,p_commit => FND_API.g_false
2307: ,p_validation_level => FND_API.g_valid_level_full
2308:
2309: ,x_return_status => l_return_status
2310: ,x_msg_count => x_msg_count
2311: ,x_msg_data => x_msg_data

Line 2318: IF l_return_status = FND_API.g_ret_sts_error THEN

2314: ,p_funds_util_flt => l_funds_util_flt
2315:
2316: ,x_claim_id => x_claim_id
2317: );
2318: IF l_return_status = FND_API.g_ret_sts_error THEN
2319: RAISE FND_API.g_exc_error;
2320: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2321: RAISE FND_API.g_exc_unexpected_error;
2322: END IF;

Line 2319: RAISE FND_API.g_exc_error;

2315:
2316: ,x_claim_id => x_claim_id
2317: );
2318: IF l_return_status = FND_API.g_ret_sts_error THEN
2319: RAISE FND_API.g_exc_error;
2320: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2321: RAISE FND_API.g_exc_unexpected_error;
2322: END IF;
2323:

Line 2320: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2316: ,x_claim_id => x_claim_id
2317: );
2318: IF l_return_status = FND_API.g_ret_sts_error THEN
2319: RAISE FND_API.g_exc_error;
2320: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2321: RAISE FND_API.g_exc_unexpected_error;
2322: END IF;
2323:
2324: -- Standard check for p_commit

Line 2321: RAISE FND_API.g_exc_unexpected_error;

2317: );
2318: IF l_return_status = FND_API.g_ret_sts_error THEN
2319: RAISE FND_API.g_exc_error;
2320: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2321: RAISE FND_API.g_exc_unexpected_error;
2322: END IF;
2323:
2324: -- Standard check for p_commit
2325: IF FND_API.to_Boolean(p_commit) THEN

Line 2325: IF FND_API.to_Boolean(p_commit) THEN

2321: RAISE FND_API.g_exc_unexpected_error;
2322: END IF;
2323:
2324: -- Standard check for p_commit
2325: IF FND_API.to_Boolean(p_commit) THEN
2326: COMMIT WORK;
2327: END IF;
2328:
2329: IF G_DEBUG THEN

Line 2340: WHEN FND_API.G_EXC_ERROR THEN

2336: p_data => x_msg_data
2337: );
2338:
2339: EXCEPTION
2340: WHEN FND_API.G_EXC_ERROR THEN
2341: ROLLBACK TO Create_Claim_For_Accruals;
2342: x_return_status := FND_API.G_RET_STS_ERROR;
2343: FND_MSG_PUB.Count_And_Get (
2344: p_encoded => FND_API.G_FALSE,

Line 2342: x_return_status := FND_API.G_RET_STS_ERROR;

2338:
2339: EXCEPTION
2340: WHEN FND_API.G_EXC_ERROR THEN
2341: ROLLBACK TO Create_Claim_For_Accruals;
2342: x_return_status := FND_API.G_RET_STS_ERROR;
2343: FND_MSG_PUB.Count_And_Get (
2344: p_encoded => FND_API.G_FALSE,
2345: p_count => x_msg_count,
2346: p_data => x_msg_data

Line 2344: p_encoded => FND_API.G_FALSE,

2340: WHEN FND_API.G_EXC_ERROR THEN
2341: ROLLBACK TO Create_Claim_For_Accruals;
2342: x_return_status := FND_API.G_RET_STS_ERROR;
2343: FND_MSG_PUB.Count_And_Get (
2344: p_encoded => FND_API.G_FALSE,
2345: p_count => x_msg_count,
2346: p_data => x_msg_data
2347: );
2348:

Line 2349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2345: p_count => x_msg_count,
2346: p_data => x_msg_data
2347: );
2348:
2349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2350: ROLLBACK TO Create_Claim_For_Accruals;
2351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2352: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2353: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');

Line 2351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2347: );
2348:
2349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2350: ROLLBACK TO Create_Claim_For_Accruals;
2351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2352: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2353: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2354: FND_MSG_PUB.add;
2355: END IF;

Line 2357: p_encoded => FND_API.G_FALSE,

2353: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2354: FND_MSG_PUB.add;
2355: END IF;
2356: FND_MSG_PUB.Count_And_Get (
2357: p_encoded => FND_API.G_FALSE,
2358: p_count => x_msg_count,
2359: p_data => x_msg_data
2360: );
2361:

Line 2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2360: );
2361:
2362: WHEN OTHERS THEN
2363: ROLLBACK TO Create_Claim_For_Accruals;
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2366: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2367: FND_MSG_PUB.add;
2368: END IF;

Line 2370: p_encoded => FND_API.G_FALSE,

2366: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2367: FND_MSG_PUB.add;
2368: END IF;
2369: FND_MSG_PUB.Count_And_Get (
2370: p_encoded => FND_API.G_FALSE,
2371: p_count => x_msg_count,
2372: p_data => x_msg_data
2373: );
2374: END Create_Claim_For_Accruals;

Line 2398: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

2394: -- NOTES
2395: ---------------------------------------------------------------------
2396: PROCEDURE Pay_Claim_For_Accruals(
2397: p_api_version IN NUMBER
2398: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2399: ,p_commit IN VARCHAR2 := FND_API.g_false
2400: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
2401: ,x_return_status OUT NOCOPY VARCHAR2
2402: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2399: ,p_commit IN VARCHAR2 := FND_API.g_false

2395: ---------------------------------------------------------------------
2396: PROCEDURE Pay_Claim_For_Accruals(
2397: p_api_version IN NUMBER
2398: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2399: ,p_commit IN VARCHAR2 := FND_API.g_false
2400: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
2401: ,x_return_status OUT NOCOPY VARCHAR2
2402: ,x_msg_data OUT NOCOPY VARCHAR2
2403: ,x_msg_count OUT NOCOPY NUMBER

Line 2400: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

2396: PROCEDURE Pay_Claim_For_Accruals(
2397: p_api_version IN NUMBER
2398: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2399: ,p_commit IN VARCHAR2 := FND_API.g_false
2400: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
2401: ,x_return_status OUT NOCOPY VARCHAR2
2402: ,x_msg_data OUT NOCOPY VARCHAR2
2403: ,x_msg_count OUT NOCOPY NUMBER
2404: ,p_claim_rec IN claim_rec_type

Line 2426: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2422: OZF_Utility_PVT.debug_message(l_full_name||': start');
2423: END IF;
2424:
2425: -- Standard call to check for call compatibility.
2426: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2427: p_api_version,
2428: l_api_name,
2429: G_PKG_NAME ) THEN
2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2426: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2427: p_api_version,
2428: l_api_name,
2429: G_PKG_NAME ) THEN
2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2431: END IF;
2432:
2433: -- Initialize message list if p_init_msg_list is set to TRUE.
2434: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2434: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2431: END IF;
2432:
2433: -- Initialize message list if p_init_msg_list is set to TRUE.
2434: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2435: FND_MSG_PUB.initialize;
2436: END IF;
2437:
2438: -- Initialize API return status to SUCCESS

Line 2439: x_return_status := FND_API.G_RET_STS_SUCCESS;

2435: FND_MSG_PUB.initialize;
2436: END IF;
2437:
2438: -- Initialize API return status to SUCCESS
2439: x_return_status := FND_API.G_RET_STS_SUCCESS;
2440:
2441: ------------------------------------------
2442: -- 1. Default and derive column valude --
2443: ------------------------------------------

Line 2536: ,p_init_msg_list => FND_API.g_false

2532: -- 2. Call OZF_CLAIM_ACCRUAL_PVT
2533: ------------------------------------------
2534: OZF_Claim_Accrual_PVT.Pay_Claim_For_Accruals(
2535: p_api_version => l_api_version
2536: ,p_init_msg_list => FND_API.g_false
2537: ,p_commit => FND_API.g_false
2538: ,p_validation_level => FND_API.g_valid_level_full
2539:
2540: ,x_return_status => l_return_status

Line 2537: ,p_commit => FND_API.g_false

2533: ------------------------------------------
2534: OZF_Claim_Accrual_PVT.Pay_Claim_For_Accruals(
2535: p_api_version => l_api_version
2536: ,p_init_msg_list => FND_API.g_false
2537: ,p_commit => FND_API.g_false
2538: ,p_validation_level => FND_API.g_valid_level_full
2539:
2540: ,x_return_status => l_return_status
2541: ,x_msg_count => x_msg_count

Line 2538: ,p_validation_level => FND_API.g_valid_level_full

2534: OZF_Claim_Accrual_PVT.Pay_Claim_For_Accruals(
2535: p_api_version => l_api_version
2536: ,p_init_msg_list => FND_API.g_false
2537: ,p_commit => FND_API.g_false
2538: ,p_validation_level => FND_API.g_valid_level_full
2539:
2540: ,x_return_status => l_return_status
2541: ,x_msg_count => x_msg_count
2542: ,x_msg_data => x_msg_data

Line 2549: IF l_return_status = FND_API.g_ret_sts_error THEN

2545: ,p_funds_util_flt => l_funds_util_flt
2546:
2547: ,x_claim_id => x_claim_id
2548: );
2549: IF l_return_status = FND_API.g_ret_sts_error THEN
2550: RAISE FND_API.g_exc_error;
2551: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2552: RAISE FND_API.g_exc_unexpected_error;
2553: END IF;

Line 2550: RAISE FND_API.g_exc_error;

2546:
2547: ,x_claim_id => x_claim_id
2548: );
2549: IF l_return_status = FND_API.g_ret_sts_error THEN
2550: RAISE FND_API.g_exc_error;
2551: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2552: RAISE FND_API.g_exc_unexpected_error;
2553: END IF;
2554:

Line 2551: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2547: ,x_claim_id => x_claim_id
2548: );
2549: IF l_return_status = FND_API.g_ret_sts_error THEN
2550: RAISE FND_API.g_exc_error;
2551: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2552: RAISE FND_API.g_exc_unexpected_error;
2553: END IF;
2554:
2555: -- Standard check for p_commit

Line 2552: RAISE FND_API.g_exc_unexpected_error;

2548: );
2549: IF l_return_status = FND_API.g_ret_sts_error THEN
2550: RAISE FND_API.g_exc_error;
2551: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2552: RAISE FND_API.g_exc_unexpected_error;
2553: END IF;
2554:
2555: -- Standard check for p_commit
2556: IF FND_API.to_Boolean(p_commit) THEN

Line 2556: IF FND_API.to_Boolean(p_commit) THEN

2552: RAISE FND_API.g_exc_unexpected_error;
2553: END IF;
2554:
2555: -- Standard check for p_commit
2556: IF FND_API.to_Boolean(p_commit) THEN
2557: COMMIT WORK;
2558: END IF;
2559:
2560: IF G_DEBUG THEN

Line 2571: WHEN FND_API.G_EXC_ERROR THEN

2567: p_data => x_msg_data
2568: );
2569:
2570: EXCEPTION
2571: WHEN FND_API.G_EXC_ERROR THEN
2572: ROLLBACK TO Pay_Claim_For_Accruals;
2573: x_return_status := FND_API.G_RET_STS_ERROR;
2574: FND_MSG_PUB.Count_And_Get (
2575: p_encoded => FND_API.G_FALSE,

Line 2573: x_return_status := FND_API.G_RET_STS_ERROR;

2569:
2570: EXCEPTION
2571: WHEN FND_API.G_EXC_ERROR THEN
2572: ROLLBACK TO Pay_Claim_For_Accruals;
2573: x_return_status := FND_API.G_RET_STS_ERROR;
2574: FND_MSG_PUB.Count_And_Get (
2575: p_encoded => FND_API.G_FALSE,
2576: p_count => x_msg_count,
2577: p_data => x_msg_data

Line 2575: p_encoded => FND_API.G_FALSE,

2571: WHEN FND_API.G_EXC_ERROR THEN
2572: ROLLBACK TO Pay_Claim_For_Accruals;
2573: x_return_status := FND_API.G_RET_STS_ERROR;
2574: FND_MSG_PUB.Count_And_Get (
2575: p_encoded => FND_API.G_FALSE,
2576: p_count => x_msg_count,
2577: p_data => x_msg_data
2578: );
2579:

Line 2580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2576: p_count => x_msg_count,
2577: p_data => x_msg_data
2578: );
2579:
2580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2581: ROLLBACK TO Pay_Claim_For_Accruals;
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');

Line 2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2578: );
2579:
2580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2581: ROLLBACK TO Pay_Claim_For_Accruals;
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2585: FND_MSG_PUB.add;
2586: END IF;

Line 2588: p_encoded => FND_API.G_FALSE,

2584: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2585: FND_MSG_PUB.add;
2586: END IF;
2587: FND_MSG_PUB.Count_And_Get (
2588: p_encoded => FND_API.G_FALSE,
2589: p_count => x_msg_count,
2590: p_data => x_msg_data
2591: );
2592:

Line 2595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2591: );
2592:
2593: WHEN OTHERS THEN
2594: ROLLBACK TO Pay_Claim_For_Accruals;
2595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2597: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2598: FND_MSG_PUB.add;
2599: END IF;

Line 2601: p_encoded => FND_API.G_FALSE,

2597: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
2598: FND_MSG_PUB.add;
2599: END IF;
2600: FND_MSG_PUB.Count_And_Get (
2601: p_encoded => FND_API.G_FALSE,
2602: p_count => x_msg_count,
2603: p_data => x_msg_data
2604: );
2605: END Pay_Claim_For_Accruals;