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_TYPE_PVT dependencies on FND_API

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

13: -- 06/27/2000 Michelle Chang Create.
14: ---------------------------------------------------------------------
15: PROCEDURE Create_Claim_Type(
16: p_api_version IN NUMBER
17: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
18: ,p_commit IN VARCHAR2 := FND_API.g_false
19: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
20:
21: ,x_return_status OUT NOCOPY VARCHAR2

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

14: ---------------------------------------------------------------------
15: PROCEDURE Create_Claim_Type(
16: p_api_version IN NUMBER
17: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
18: ,p_commit IN VARCHAR2 := FND_API.g_false
19: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
20:
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_msg_count OUT NOCOPY NUMBER

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

15: PROCEDURE Create_Claim_Type(
16: p_api_version IN NUMBER
17: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
18: ,p_commit IN VARCHAR2 := FND_API.g_false
19: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
20:
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_msg_count OUT NOCOPY NUMBER
23: ,x_msg_data OUT NOCOPY VARCHAR2

Line 62: IF FND_API.to_boolean(p_init_msg_list) THEN

58: IF OZF_DEBUG_HIGH_ON THEN
59: OZF_Utility_PVT.debug_message(l_full_name||': start');
60: END IF;
61:
62: IF FND_API.to_boolean(p_init_msg_list) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: IF NOT FND_API.compatible_api_call(

Line 66: IF NOT FND_API.compatible_api_call(

62: IF FND_API.to_boolean(p_init_msg_list) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: IF NOT FND_API.compatible_api_call(
67: l_api_version,
68: p_api_version,
69: l_api_name,
70: g_pkg_name

Line 72: RAISE FND_API.g_exc_unexpected_error;

68: p_api_version,
69: l_api_name,
70: g_pkg_name
71: ) THEN
72: RAISE FND_API.g_exc_unexpected_error;
73: END IF;
74:
75: x_return_status := FND_API.g_ret_sts_success;
76:

Line 75: x_return_status := FND_API.g_ret_sts_success;

71: ) THEN
72: RAISE FND_API.g_exc_unexpected_error;
73: END IF;
74:
75: x_return_status := FND_API.g_ret_sts_success;
76:
77: ----------------------- validate -----------------------
78: IF OZF_DEBUG_HIGH_ON THEN
79: OZF_Utility_PVT.debug_message(l_full_name ||': validate');

Line 93: IF l_return_status = FND_API.g_ret_sts_error THEN

89: p_claim_rec => l_claim_rec
90: );
91:
92:
93: IF l_return_status = FND_API.g_ret_sts_error THEN
94: RAISE FND_API.g_exc_error;
95: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
96: RAISE FND_API.g_exc_unexpected_error;
97: END IF;

Line 94: RAISE FND_API.g_exc_error;

90: );
91:
92:
93: IF l_return_status = FND_API.g_ret_sts_error THEN
94: RAISE FND_API.g_exc_error;
95: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
96: RAISE FND_API.g_exc_unexpected_error;
97: END IF;
98:

Line 95: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

91:
92:
93: IF l_return_status = FND_API.g_ret_sts_error THEN
94: RAISE FND_API.g_exc_error;
95: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
96: RAISE FND_API.g_exc_unexpected_error;
97: END IF;
98:
99:

Line 96: RAISE FND_API.g_exc_unexpected_error;

92:
93: IF l_return_status = FND_API.g_ret_sts_error THEN
94: RAISE FND_API.g_exc_error;
95: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
96: RAISE FND_API.g_exc_unexpected_error;
97: END IF;
98:
99:
100: -------------------------- insert --------------------------

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: X_ORG_ID => l_claim_rec.org_id -- R12 Enhancement
172: );
173: EXCEPTION
174: WHEN OTHERS THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END;
177:
178:
179: ------------------------- finish -------------------------------

Line 183: IF FND_API.to_boolean(p_commit) THEN

179: ------------------------- finish -------------------------------
180: x_claim_type_id := l_claim_rec.claim_type_id;
181:
182: -- Check for commit
183: IF FND_API.to_boolean(p_commit) THEN
184: COMMIT;
185: END IF;
186:
187: FND_MSG_PUB.count_and_get(

Line 188: p_encoded => FND_API.g_false,

184: COMMIT;
185: END IF;
186:
187: FND_MSG_PUB.count_and_get(
188: p_encoded => FND_API.g_false,
189: p_count => x_msg_count,
190: p_data => x_msg_data
191: );
192:

Line 199: WHEN FND_API.g_exc_error THEN

195: END IF;
196:
197: EXCEPTION
198:
199: WHEN FND_API.g_exc_error THEN
200: ROLLBACK TO Create_Claim_Type;
201: x_return_status := FND_API.g_ret_sts_error;
202: FND_MSG_PUB.count_and_get (
203: p_encoded => FND_API.g_false

Line 201: x_return_status := FND_API.g_ret_sts_error;

197: EXCEPTION
198:
199: WHEN FND_API.g_exc_error THEN
200: ROLLBACK TO Create_Claim_Type;
201: x_return_status := FND_API.g_ret_sts_error;
202: FND_MSG_PUB.count_and_get (
203: p_encoded => FND_API.g_false
204: ,p_count => x_msg_count
205: ,p_data => x_msg_data

Line 203: p_encoded => FND_API.g_false

199: WHEN FND_API.g_exc_error THEN
200: ROLLBACK TO Create_Claim_Type;
201: x_return_status := FND_API.g_ret_sts_error;
202: FND_MSG_PUB.count_and_get (
203: p_encoded => FND_API.g_false
204: ,p_count => x_msg_count
205: ,p_data => x_msg_data
206: );
207:

Line 208: WHEN FND_API.g_exc_unexpected_error THEN

204: ,p_count => x_msg_count
205: ,p_data => x_msg_data
206: );
207:
208: WHEN FND_API.g_exc_unexpected_error THEN
209: ROLLBACK TO Create_Claim_Type;
210: x_return_status := FND_API.g_ret_sts_unexp_error ;
211: FND_MSG_PUB.count_and_get (
212: p_encoded => FND_API.g_false

Line 210: x_return_status := FND_API.g_ret_sts_unexp_error ;

206: );
207:
208: WHEN FND_API.g_exc_unexpected_error THEN
209: ROLLBACK TO Create_Claim_Type;
210: x_return_status := FND_API.g_ret_sts_unexp_error ;
211: FND_MSG_PUB.count_and_get (
212: p_encoded => FND_API.g_false
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data

Line 212: p_encoded => FND_API.g_false

208: WHEN FND_API.g_exc_unexpected_error THEN
209: ROLLBACK TO Create_Claim_Type;
210: x_return_status := FND_API.g_ret_sts_unexp_error ;
211: FND_MSG_PUB.count_and_get (
212: p_encoded => FND_API.g_false
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data
215: );
216:

Line 219: x_return_status := FND_API.g_ret_sts_unexp_error ;

215: );
216:
217: WHEN OTHERS THEN
218: ROLLBACK TO Create_Claim_Type;
219: x_return_status := FND_API.g_ret_sts_unexp_error ;
220:
221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
222: THEN
223: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 227: p_encoded => FND_API.g_false

223: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
224: END IF;
225:
226: FND_MSG_PUB.count_and_get(
227: p_encoded => FND_API.g_false
228: ,p_count => x_msg_count
229: ,p_data => x_msg_data
230: );
231:

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

242: -- is using by an existing claim.
243: ---------------------------------------------------------------
244: PROCEDURE Delete_Claim_Type(
245: p_api_version IN NUMBER
246: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
247: ,p_commit IN VARCHAR2 := FND_API.g_false
248:
249: ,x_return_status OUT NOCOPY VARCHAR2
250: ,x_msg_count OUT NOCOPY NUMBER

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

243: ---------------------------------------------------------------
244: PROCEDURE Delete_Claim_Type(
245: p_api_version IN NUMBER
246: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
247: ,p_commit IN VARCHAR2 := FND_API.g_false
248:
249: ,x_return_status OUT NOCOPY VARCHAR2
250: ,x_msg_count OUT NOCOPY NUMBER
251: ,x_msg_data OUT NOCOPY VARCHAR2

Line 297: IF FND_API.to_boolean(p_init_msg_list) THEN

293: IF OZF_DEBUG_HIGH_ON THEN
294: OZF_Utility_PVT.debug_message(l_full_name||': start');
295: END IF;
296:
297: IF FND_API.to_boolean(p_init_msg_list) THEN
298: FND_MSG_PUB.initialize;
299: END IF;
300:
301: IF NOT FND_API.compatible_api_call(

Line 301: IF NOT FND_API.compatible_api_call(

297: IF FND_API.to_boolean(p_init_msg_list) THEN
298: FND_MSG_PUB.initialize;
299: END IF;
300:
301: IF NOT FND_API.compatible_api_call(
302: l_api_version,
303: p_api_version,
304: l_api_name,
305: g_pkg_name

Line 307: RAISE FND_API.g_exc_unexpected_error;

303: p_api_version,
304: l_api_name,
305: g_pkg_name
306: ) THEN
307: RAISE FND_API.g_exc_unexpected_error;
308: END IF;
309:
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:

Line 310: x_return_status := FND_API.G_RET_STS_SUCCESS;

306: ) THEN
307: RAISE FND_API.g_exc_unexpected_error;
308: END IF;
309:
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: ------------------------ delete ------------------------
313: IF OZF_DEBUG_HIGH_ON THEN
314: OZF_Utility_PVT.debug_message(l_full_name ||': delete');

Line 324: RAISE FND_API.g_exc_error;

320: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_NO_DEL');
321: FND_MESSAGE.set_name('OZF', 'OZF_ADJ_TYPE_NO_DEL');
322: FND_MSG_PUB.add;
323: END IF;
324: RAISE FND_API.g_exc_error;
325: END IF;
326:
327: IF OZF_DEBUG_HIGH_ON THEN
328: OZF_Utility_PVT.debug_message(p_claim_type_id ||': p_claim_type_id');

Line 340: RAISE FND_API.g_exc_error;

336: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
337: FND_MSG_PUB.add;
338: END IF;
339: CLOSE c_claim_count;
340: RAISE FND_API.g_exc_error;
341: END IF;
342: CLOSE c_claim_count;
343:
344: -- Claim Type cannot be deleted if it is using by an existing claim.

Line 353: RAISE FND_API.g_exc_error;

349: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_USED');
350: FND_MSG_PUB.add;
351: END IF;
352: CLOSE c_claim_using;
353: RAISE FND_API.g_exc_error;
354: END IF;
355: CLOSE c_claim_using;
356:
357: -- Adjustment Type cannot be deleted if it is using by an funds utilized rec.

Line 366: RAISE FND_API.g_exc_error;

362: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_ADJ_USED');
363: FND_MSG_PUB.add;
364: END IF;
365: CLOSE c_adjustment_using;
366: RAISE FND_API.g_exc_error;
367: END IF;
368: CLOSE c_adjustment_using;
369:
370: -- Claim Types can not be deleted when used in approval rules.

Line 379: RAISE FND_API.g_exc_error;

375: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_APPROVAL_USED');
376: FND_MSG_PUB.add;
377: END IF;
378: CLOSE c_approval_using;
379: RAISE FND_API.g_exc_error;
380: END IF;
381: CLOSE c_approval_using;
382:
383:

Line 402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

398: END IF;
399:
400: EXCEPTION
401: WHEN OTHERS THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END;
404:
405: -------------------- finish --------------------------
406: IF FND_API.to_boolean(p_commit) THEN

Line 406: IF FND_API.to_boolean(p_commit) THEN

402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END;
404:
405: -------------------- finish --------------------------
406: IF FND_API.to_boolean(p_commit) THEN
407: COMMIT;
408: END IF;
409:
410: FND_MSG_PUB.count_and_get(

Line 411: p_encoded => FND_API.g_false,

407: COMMIT;
408: END IF;
409:
410: FND_MSG_PUB.count_and_get(
411: p_encoded => FND_API.g_false,
412: p_count => x_msg_count,
413: p_data => x_msg_data
414: );
415:

Line 422: WHEN FND_API.g_exc_error THEN

418: END IF;
419:
420: EXCEPTION
421:
422: WHEN FND_API.g_exc_error THEN
423: ROLLBACK TO Delete_Claim_Type;
424: x_return_status := FND_API.g_ret_sts_error;
425: FND_MSG_PUB.count_and_get(
426: p_encoded => FND_API.g_false,

Line 424: x_return_status := FND_API.g_ret_sts_error;

420: EXCEPTION
421:
422: WHEN FND_API.g_exc_error THEN
423: ROLLBACK TO Delete_Claim_Type;
424: x_return_status := FND_API.g_ret_sts_error;
425: FND_MSG_PUB.count_and_get(
426: p_encoded => FND_API.g_false,
427: p_count => x_msg_count,
428: p_data => x_msg_data

Line 426: p_encoded => FND_API.g_false,

422: WHEN FND_API.g_exc_error THEN
423: ROLLBACK TO Delete_Claim_Type;
424: x_return_status := FND_API.g_ret_sts_error;
425: FND_MSG_PUB.count_and_get(
426: p_encoded => FND_API.g_false,
427: p_count => x_msg_count,
428: p_data => x_msg_data
429: );
430:

Line 431: WHEN FND_API.g_exc_unexpected_error THEN

427: p_count => x_msg_count,
428: p_data => x_msg_data
429: );
430:
431: WHEN FND_API.g_exc_unexpected_error THEN
432: ROLLBACK TO Delete_Claim_Type;
433: x_return_status := FND_API.g_ret_sts_unexp_error ;
434: FND_MSG_PUB.count_and_get(
435: p_encoded => FND_API.g_false,

Line 433: x_return_status := FND_API.g_ret_sts_unexp_error ;

429: );
430:
431: WHEN FND_API.g_exc_unexpected_error THEN
432: ROLLBACK TO Delete_Claim_Type;
433: x_return_status := FND_API.g_ret_sts_unexp_error ;
434: FND_MSG_PUB.count_and_get(
435: p_encoded => FND_API.g_false,
436: p_count => x_msg_count,
437: p_data => x_msg_data

Line 435: p_encoded => FND_API.g_false,

431: WHEN FND_API.g_exc_unexpected_error THEN
432: ROLLBACK TO Delete_Claim_Type;
433: x_return_status := FND_API.g_ret_sts_unexp_error ;
434: FND_MSG_PUB.count_and_get(
435: p_encoded => FND_API.g_false,
436: p_count => x_msg_count,
437: p_data => x_msg_data
438: );
439:

Line 442: x_return_status := FND_API.g_ret_sts_unexp_error ;

438: );
439:
440: WHEN OTHERS THEN
441: ROLLBACK TO Delete_Claim_Type;
442: x_return_status := FND_API.g_ret_sts_unexp_error ;
443:
444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
445: THEN
446: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 450: p_encoded => FND_API.g_false,

446: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
447: END IF;
448:
449: FND_MSG_PUB.count_and_get(
450: p_encoded => FND_API.g_false,
451: p_count => x_msg_count,
452: p_data => x_msg_data
453: );
454:

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

463: -- 06/27/2000 Michelle Chang Create.
464: ----------------------------------------------------------------------
465: PROCEDURE Update_Claim_Type(
466: p_api_version IN NUMBER
467: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
468: ,p_commit IN VARCHAR2 := FND_API.g_false
469: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
470:
471: ,x_return_status OUT NOCOPY VARCHAR2

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

464: ----------------------------------------------------------------------
465: PROCEDURE Update_Claim_Type(
466: p_api_version IN NUMBER
467: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
468: ,p_commit IN VARCHAR2 := FND_API.g_false
469: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
470:
471: ,x_return_status OUT NOCOPY VARCHAR2
472: ,x_msg_count OUT NOCOPY NUMBER

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

465: PROCEDURE Update_Claim_Type(
466: p_api_version IN NUMBER
467: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
468: ,p_commit IN VARCHAR2 := FND_API.g_false
469: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
470:
471: ,x_return_status OUT NOCOPY VARCHAR2
472: ,x_msg_count OUT NOCOPY NUMBER
473: ,x_msg_data OUT NOCOPY VARCHAR2

Line 506: IF FND_API.to_boolean(p_init_msg_list) THEN

502: IF OZF_DEBUG_HIGH_ON THEN
503: OZF_Utility_PVT.debug_message(l_full_name||': start');
504: END IF;
505:
506: IF FND_API.to_boolean(p_init_msg_list) THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: IF NOT FND_API.compatible_api_call(

Line 510: IF NOT FND_API.compatible_api_call(

506: IF FND_API.to_boolean(p_init_msg_list) THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: IF NOT FND_API.compatible_api_call(
511: l_api_version,
512: p_api_version,
513: l_api_name,
514: g_pkg_name

Line 516: RAISE FND_API.g_exc_unexpected_error;

512: p_api_version,
513: l_api_name,
514: g_pkg_name
515: ) THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF;
518:
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:

Line 519: x_return_status := FND_API.G_RET_STS_SUCCESS;

515: ) THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF;
518:
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
521:
522:
523: ----------------------- validate ----------------------

Line 536: RAISE FND_API.g_exc_error;

532: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
533: FND_MSG_PUB.add;
534: END IF;
535: CLOSE c_claim_count;
536: RAISE FND_API.g_exc_error;
537: END IF;
538: CLOSE c_claim_count;
539:
540: -- Adjustment types cannot be updated if the claim_type_id is less than 0

Line 547: RAISE FND_API.g_exc_error;

543: --FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_NO_UPDATE');
544: FND_MESSAGE.set_name('OZF', 'OZF_ADJ_TYPE_NO_UPDATE');
545: FND_MSG_PUB.add;
546: END IF;
547: RAISE FND_API.g_exc_error;
548: END IF;
549:
550: -- replace g_miss_char/num/date with current column values
551: Complete_Claim_Type_Rec(p_claim_rec, l_claim_rec);

Line 560: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

556: p_validation_mode => JTF_PLSQL_API.g_update,
557: x_return_status => l_return_status
558: );
559:
560: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
561: RAISE FND_API.g_exc_unexpected_error;
562: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
563: RAISE FND_API.g_exc_error;
564: END IF;

Line 561: RAISE FND_API.g_exc_unexpected_error;

557: x_return_status => l_return_status
558: );
559:
560: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
561: RAISE FND_API.g_exc_unexpected_error;
562: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
563: RAISE FND_API.g_exc_error;
564: END IF;
565: END IF;

Line 562: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

558: );
559:
560: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
561: RAISE FND_API.g_exc_unexpected_error;
562: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
563: RAISE FND_API.g_exc_error;
564: END IF;
565: END IF;
566:

Line 563: RAISE FND_API.g_exc_error;

559:
560: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
561: RAISE FND_API.g_exc_unexpected_error;
562: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
563: RAISE FND_API.g_exc_error;
564: END IF;
565: END IF;
566:
567:

Line 575: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

571: p_complete_rec => l_claim_rec,
572: x_return_status => l_return_status
573: );
574:
575: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
576: RAISE FND_API.g_exc_unexpected_error;
577: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
578: RAISE FND_API.g_exc_error;
579: END IF;

Line 576: RAISE FND_API.g_exc_unexpected_error;

572: x_return_status => l_return_status
573: );
574:
575: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
576: RAISE FND_API.g_exc_unexpected_error;
577: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
578: RAISE FND_API.g_exc_error;
579: END IF;
580: END IF;

Line 577: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

573: );
574:
575: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
576: RAISE FND_API.g_exc_unexpected_error;
577: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
578: RAISE FND_API.g_exc_error;
579: END IF;
580: END IF;
581:

Line 578: RAISE FND_API.g_exc_error;

574:
575: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
576: RAISE FND_API.g_exc_unexpected_error;
577: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
578: RAISE FND_API.g_exc_error;
579: END IF;
580: END IF;
581:
582: l_object_version := l_claim_rec.object_version_number + 1;

Line 640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

636: X_ORG_ID => l_claim_rec.org_id
637: );
638: EXCEPTION
639: WHEN OTHERS THEN
640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
641: END;
642:
643: -------------------- finish --------------------------
644: x_object_version := l_object_version;

Line 647: IF FND_API.to_boolean(p_commit) THEN

643: -------------------- finish --------------------------
644: x_object_version := l_object_version;
645:
646: -- Check for commit
647: IF FND_API.to_boolean(p_commit) THEN
648: COMMIT;
649: END IF;
650:
651: FND_MSG_PUB.count_and_get(

Line 652: p_encoded => FND_API.g_false,

648: COMMIT;
649: END IF;
650:
651: FND_MSG_PUB.count_and_get(
652: p_encoded => FND_API.g_false,
653: p_count => x_msg_count,
654: p_data => x_msg_data
655: );
656:

Line 663: WHEN FND_API.g_exc_error THEN

659: END IF;
660:
661: EXCEPTION
662:
663: WHEN FND_API.g_exc_error THEN
664: ROLLBACK TO Update_Claim_Type;
665: x_return_status := FND_API.g_ret_sts_error;
666: FND_MSG_PUB.count_and_get(
667: p_encoded => FND_API.g_false,

Line 665: x_return_status := FND_API.g_ret_sts_error;

661: EXCEPTION
662:
663: WHEN FND_API.g_exc_error THEN
664: ROLLBACK TO Update_Claim_Type;
665: x_return_status := FND_API.g_ret_sts_error;
666: FND_MSG_PUB.count_and_get(
667: p_encoded => FND_API.g_false,
668: p_count => x_msg_count,
669: p_data => x_msg_data

Line 667: p_encoded => FND_API.g_false,

663: WHEN FND_API.g_exc_error THEN
664: ROLLBACK TO Update_Claim_Type;
665: x_return_status := FND_API.g_ret_sts_error;
666: FND_MSG_PUB.count_and_get(
667: p_encoded => FND_API.g_false,
668: p_count => x_msg_count,
669: p_data => x_msg_data
670: );
671:

Line 672: WHEN FND_API.g_exc_unexpected_error THEN

668: p_count => x_msg_count,
669: p_data => x_msg_data
670: );
671:
672: WHEN FND_API.g_exc_unexpected_error THEN
673: ROLLBACK TO Update_Claim_Type;
674: x_return_status := FND_API.g_ret_sts_unexp_error ;
675: FND_MSG_PUB.count_and_get(
676: p_encoded => FND_API.g_false,

Line 674: x_return_status := FND_API.g_ret_sts_unexp_error ;

670: );
671:
672: WHEN FND_API.g_exc_unexpected_error THEN
673: ROLLBACK TO Update_Claim_Type;
674: x_return_status := FND_API.g_ret_sts_unexp_error ;
675: FND_MSG_PUB.count_and_get(
676: p_encoded => FND_API.g_false,
677: p_count => x_msg_count,
678: p_data => x_msg_data

Line 676: p_encoded => FND_API.g_false,

672: WHEN FND_API.g_exc_unexpected_error THEN
673: ROLLBACK TO Update_Claim_Type;
674: x_return_status := FND_API.g_ret_sts_unexp_error ;
675: FND_MSG_PUB.count_and_get(
676: p_encoded => FND_API.g_false,
677: p_count => x_msg_count,
678: p_data => x_msg_data
679: );
680:

Line 683: x_return_status := FND_API.g_ret_sts_unexp_error ;

679: );
680:
681: WHEN OTHERS THEN
682: ROLLBACK TO Update_Claim_Type;
683: x_return_status := FND_API.g_ret_sts_unexp_error ;
684:
685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
686: THEN
687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 691: p_encoded => FND_API.g_false,

687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
688: END IF;
689:
690: FND_MSG_PUB.count_and_get(
691: p_encoded => FND_API.g_false,
692: p_count => x_msg_count,
693: p_data => x_msg_data
694: );
695:

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

704: -- 06/27/2000 Michelle Chang Create.
705: --------------------------------------------------------------------
706: PROCEDURE Validate_Claim_Type(
707: p_api_version IN NUMBER
708: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
709: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
710:
711: ,x_return_status OUT NOCOPY VARCHAR2
712: ,x_msg_count OUT NOCOPY NUMBER

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

705: --------------------------------------------------------------------
706: PROCEDURE Validate_Claim_Type(
707: p_api_version IN NUMBER
708: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
709: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
710:
711: ,x_return_status OUT NOCOPY VARCHAR2
712: ,x_msg_count OUT NOCOPY NUMBER
713: ,x_msg_data OUT NOCOPY VARCHAR2

Line 731: IF FND_API.to_boolean(p_init_msg_list) THEN

727: IF OZF_DEBUG_HIGH_ON THEN
728: OZF_Utility_PVT.debug_message(l_full_name||': start');
729: END IF;
730:
731: IF FND_API.to_boolean(p_init_msg_list) THEN
732: FND_MSG_PUB.initialize;
733: END IF;
734:
735: IF NOT FND_API.compatible_api_call(

Line 735: IF NOT FND_API.compatible_api_call(

731: IF FND_API.to_boolean(p_init_msg_list) THEN
732: FND_MSG_PUB.initialize;
733: END IF;
734:
735: IF NOT FND_API.compatible_api_call(
736: l_api_version,
737: p_api_version,
738: l_api_name,
739: g_pkg_name

Line 741: RAISE FND_API.g_exc_unexpected_error;

737: p_api_version,
738: l_api_name,
739: g_pkg_name
740: ) THEN
741: RAISE FND_API.g_exc_unexpected_error;
742: END IF;
743:
744: x_return_status := FND_API.g_ret_sts_success;
745:

Line 744: x_return_status := FND_API.g_ret_sts_success;

740: ) THEN
741: RAISE FND_API.g_exc_unexpected_error;
742: END IF;
743:
744: x_return_status := FND_API.g_ret_sts_success;
745:
746: ---------------------- validate ------------------------
747: IF OZF_DEBUG_HIGH_ON THEN
748: OZF_Utility_PVT.debug_message(l_full_name||': check items');

Line 758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

754: p_validation_mode => JTF_PLSQL_API.g_create,
755: x_return_status => l_return_status
756: );
757:
758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
759: RAISE FND_API.g_exc_unexpected_error;
760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
761: RAISE FND_API.g_exc_error;
762: END IF;

Line 759: RAISE FND_API.g_exc_unexpected_error;

755: x_return_status => l_return_status
756: );
757:
758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
759: RAISE FND_API.g_exc_unexpected_error;
760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
761: RAISE FND_API.g_exc_error;
762: END IF;
763: END IF;

Line 760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

756: );
757:
758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
759: RAISE FND_API.g_exc_unexpected_error;
760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
761: RAISE FND_API.g_exc_error;
762: END IF;
763: END IF;
764:

Line 761: RAISE FND_API.g_exc_error;

757:
758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
759: RAISE FND_API.g_exc_unexpected_error;
760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
761: RAISE FND_API.g_exc_error;
762: END IF;
763: END IF;
764:
765: IF OZF_DEBUG_HIGH_ON THEN

Line 776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

772: p_complete_rec => NULL,
773: x_return_status => l_return_status
774: );
775:
776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
777: RAISE FND_API.g_exc_unexpected_error;
778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
779: RAISE FND_API.g_exc_error;
780: END IF;

Line 777: RAISE FND_API.g_exc_unexpected_error;

773: x_return_status => l_return_status
774: );
775:
776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
777: RAISE FND_API.g_exc_unexpected_error;
778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
779: RAISE FND_API.g_exc_error;
780: END IF;
781: END IF;

Line 778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

774: );
775:
776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
777: RAISE FND_API.g_exc_unexpected_error;
778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
779: RAISE FND_API.g_exc_error;
780: END IF;
781: END IF;
782:

Line 779: RAISE FND_API.g_exc_error;

775:
776: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
777: RAISE FND_API.g_exc_unexpected_error;
778: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
779: RAISE FND_API.g_exc_error;
780: END IF;
781: END IF;
782:
783: -------------------- finish --------------------------

Line 785: p_encoded => FND_API.g_false,

781: END IF;
782:
783: -------------------- finish --------------------------
784: FND_MSG_PUB.count_and_get(
785: p_encoded => FND_API.g_false,
786: p_count => x_msg_count,
787: p_data => x_msg_data
788: );
789:

Line 796: WHEN FND_API.g_exc_error THEN

792: END IF;
793:
794: EXCEPTION
795:
796: WHEN FND_API.g_exc_error THEN
797: x_return_status := FND_API.g_ret_sts_error;
798: FND_MSG_PUB.count_and_get(
799: p_encoded => FND_API.g_false,
800: p_count => x_msg_count,

Line 797: x_return_status := FND_API.g_ret_sts_error;

793:
794: EXCEPTION
795:
796: WHEN FND_API.g_exc_error THEN
797: x_return_status := FND_API.g_ret_sts_error;
798: FND_MSG_PUB.count_and_get(
799: p_encoded => FND_API.g_false,
800: p_count => x_msg_count,
801: p_data => x_msg_data

Line 799: p_encoded => FND_API.g_false,

795:
796: WHEN FND_API.g_exc_error THEN
797: x_return_status := FND_API.g_ret_sts_error;
798: FND_MSG_PUB.count_and_get(
799: p_encoded => FND_API.g_false,
800: p_count => x_msg_count,
801: p_data => x_msg_data
802: );
803:

Line 804: WHEN FND_API.g_exc_unexpected_error THEN

800: p_count => x_msg_count,
801: p_data => x_msg_data
802: );
803:
804: WHEN FND_API.g_exc_unexpected_error THEN
805: x_return_status := FND_API.g_ret_sts_unexp_error ;
806: FND_MSG_PUB.count_and_get(
807: p_encoded => FND_API.g_false,
808: p_count => x_msg_count,

Line 805: x_return_status := FND_API.g_ret_sts_unexp_error ;

801: p_data => x_msg_data
802: );
803:
804: WHEN FND_API.g_exc_unexpected_error THEN
805: x_return_status := FND_API.g_ret_sts_unexp_error ;
806: FND_MSG_PUB.count_and_get(
807: p_encoded => FND_API.g_false,
808: p_count => x_msg_count,
809: p_data => x_msg_data

Line 807: p_encoded => FND_API.g_false,

803:
804: WHEN FND_API.g_exc_unexpected_error THEN
805: x_return_status := FND_API.g_ret_sts_unexp_error ;
806: FND_MSG_PUB.count_and_get(
807: p_encoded => FND_API.g_false,
808: p_count => x_msg_count,
809: p_data => x_msg_data
810: );
811:

Line 813: x_return_status := FND_API.g_ret_sts_unexp_error;

809: p_data => x_msg_data
810: );
811:
812: WHEN OTHERS THEN
813: x_return_status := FND_API.g_ret_sts_unexp_error;
814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
815: THEN
816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
817: END IF;

Line 820: p_encoded => FND_API.g_false,

816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
817: END IF;
818:
819: FND_MSG_PUB.count_and_get(
820: p_encoded => FND_API.g_false,
821: p_count => x_msg_count,
822: p_data => x_msg_data
823: );
824:

Line 842: x_return_status := FND_API.g_ret_sts_success;

838: )
839: IS
840: BEGIN
841:
842: x_return_status := FND_API.g_ret_sts_success;
843:
844: ------------------------ claim_class --------------------------
845: IF p_claim_rec.claim_class IS NULL THEN
846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 853: x_return_status := FND_API.g_ret_sts_error;

849: FND_MESSAGE.Set_Token('COLUMN', 'CLAIM_CLASS');
850: FND_MSG_PUB.add;
851: END IF;
852:
853: x_return_status := FND_API.g_ret_sts_error;
854: RETURN;
855: ------------------------ Adjustment type--------------------------
856: ELSIF p_claim_rec.claim_class = 'ADJ' AND
857: p_claim_rec.adjustment_type IS NULL

Line 866: x_return_status := FND_API.g_ret_sts_error;

862: FND_MESSAGE.Set_Token('COLUMN', 'ADJUSTMENT_TYPE');
863: FND_MSG_PUB.add;
864: END IF;
865:
866: x_return_status := FND_API.g_ret_sts_error;
867: RETURN;
868: ------------------------ set_of_books_id -------------------------------
869: ELSIF p_claim_rec.set_of_books_id IS NULL THEN
870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 881: x_return_status := FND_API.g_ret_sts_error;

877: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_NO_BOOKS');
878: FND_MSG_PUB.add;
879: END IF;
880:
881: x_return_status := FND_API.g_ret_sts_error;
882: RETURN;
883: ------------------------ post_to_gl_flag -------------------------------
884: ELSIF p_claim_rec.post_to_gl_flag IS NULL THEN
885: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 892: x_return_status := FND_API.g_ret_sts_error;

888: FND_MESSAGE.Set_Token('COLUMN', 'POST_TO_GL_GLAG');
889: FND_MSG_PUB.add;
890: END IF;
891:
892: x_return_status := FND_API.g_ret_sts_error;
893: RETURN;
894: ------------------------ start_date -------------------------------
895: ELSIF p_claim_rec.start_date IS NULL THEN
896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 903: x_return_status := FND_API.g_ret_sts_error;

899: FND_MESSAGE.Set_Token('COLUMN', 'START_DATE');
900: FND_MSG_PUB.add;
901: END IF;
902:
903: x_return_status := FND_API.g_ret_sts_error;
904: RETURN;
905: ------------------------ name -------------------------------
906: ELSIF p_claim_rec.name IS NULL THEN
907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 914: x_return_status := FND_API.g_ret_sts_error;

910: FND_MESSAGE.Set_Token('COLUMN', 'NAME');
911: FND_MSG_PUB.add;
912: END IF;
913:
914: x_return_status := FND_API.g_ret_sts_error;
915: RETURN;
916:
917: END IF;
918:

Line 938: x_return_status := FND_API.g_ret_sts_success;

934: IS
935: l_valid_flag VARCHAR2(1);
936: BEGIN
937:
938: x_return_status := FND_API.g_ret_sts_success;
939:
940: -- For Create_Claim_Type, when claim_type_id is passed in, we need to
941: -- check if this claim_type_id is unique.
942: IF p_validation_mode = JTF_PLSQL_API.g_create

Line 948: ) = FND_API.g_false

944: THEN
945: IF OZF_Utility_PVT.check_uniqueness(
946: 'ozf_claim_types_VL',
947: 'claim_type_id = ' || p_claim_rec.claim_type_id
948: ) = FND_API.g_false
949: THEN
950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
951: THEN
952: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUPLICATE_VALUE');

Line 956: x_return_status := FND_API.g_ret_sts_error;

952: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUPLICATE_VALUE');
953: FND_MESSAGE.set_token('COLLUMN', 'CLAIM_TYPE_ID');
954: FND_MSG_PUB.add;
955: END IF;
956: x_return_status := FND_API.g_ret_sts_error;
957: RETURN;
958: END IF;
959: END IF;
960:

Line 988: x_return_status := FND_API.g_ret_sts_success;

984: WHERE transaction_type_id = cv_id;
985:
986: BEGIN
987:
988: x_return_status := FND_API.g_ret_sts_success;
989:
990: --Check the validity of OM Transaction type
991: IF p_claim_rec.order_type_id IS NOT NULL THEN
992: OPEN c_order_trx_type(p_claim_rec.order_type_id);

Line 998: x_return_status := FND_API.G_RET_STS_ERROR;

994: CLOSE c_order_trx_type;
995: IF l_dummy <> 1 THEN
996: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_OM_TRX_TYPE');
997: FND_MSG_PUB.add;
998: x_return_status := FND_API.G_RET_STS_ERROR;
999: RETURN;
1000: END IF;
1001: END IF;
1002:

Line 1022: x_return_status := FND_API.g_ret_sts_success;

1018: )
1019: IS
1020: BEGIN
1021:
1022: x_return_status := FND_API.g_ret_sts_success;
1023:
1024: ----------------------- claim_class ------------------------
1025: IF p_claim_rec.claim_class <> FND_API.g_miss_char AND
1026: p_claim_rec.claim_class <> 'ADJ' THEN

Line 1025: IF p_claim_rec.claim_class <> FND_API.g_miss_char AND

1021:
1022: x_return_status := FND_API.g_ret_sts_success;
1023:
1024: ----------------------- claim_class ------------------------
1025: IF p_claim_rec.claim_class <> FND_API.g_miss_char AND
1026: p_claim_rec.claim_class <> 'ADJ' THEN
1027: IF OZF_Utility_PVT.check_lookup_exists(
1028: p_lookup_table_name => 'OZF_LOOKUPS',
1029: p_lookup_type => 'OZF_CLAIM_CLASS',

Line 1031: ) = FND_API.g_false THEN

1027: IF OZF_Utility_PVT.check_lookup_exists(
1028: p_lookup_table_name => 'OZF_LOOKUPS',
1029: p_lookup_type => 'OZF_CLAIM_CLASS',
1030: p_lookup_code => p_claim_rec.claim_class
1031: ) = FND_API.g_false THEN
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1033: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_CLASS');
1034: FND_MSG_PUB.add;
1035: END IF;

Line 1037: x_return_status := FND_API.g_ret_sts_error;

1033: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_CLASS');
1034: FND_MSG_PUB.add;
1035: END IF;
1036:
1037: x_return_status := FND_API.g_ret_sts_error;
1038: RETURN;
1039: END IF;
1040: END IF;
1041:

Line 1043: IF p_claim_rec.creation_sign <> FND_API.g_miss_char THEN

1039: END IF;
1040: END IF;
1041:
1042: ----------------------- creation_sign ------------------------
1043: IF p_claim_rec.creation_sign <> FND_API.g_miss_char THEN
1044: IF OZF_Utility_PVT.check_lookup_exists(
1045: p_lookup_table_name => 'OZF_LOOKUPS',
1046: p_lookup_type => 'OZF_CREATION_SIGN',
1047: p_lookup_code => p_claim_rec.creation_sign

Line 1048: ) = FND_API.g_false

1044: IF OZF_Utility_PVT.check_lookup_exists(
1045: p_lookup_table_name => 'OZF_LOOKUPS',
1046: p_lookup_type => 'OZF_CREATION_SIGN',
1047: p_lookup_code => p_claim_rec.creation_sign
1048: ) = FND_API.g_false
1049: THEN
1050: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1051: THEN
1052: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_CREATION_SIGN');

Line 1056: x_return_status := FND_API.g_ret_sts_error;

1052: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_CREATION_SIGN');
1053: FND_MSG_PUB.add;
1054: END IF;
1055:
1056: x_return_status := FND_API.g_ret_sts_error;
1057: RETURN;
1058: END IF;
1059: END IF;
1060:

Line 1080: x_return_status := FND_API.g_ret_sts_success;

1076: )
1077: IS
1078: BEGIN
1079:
1080: x_return_status := FND_API.g_ret_sts_success;
1081:
1082: ----------------------- post_to_gl_flag ------------------------
1083: /*
1084: IF p_claim_rec.post_to_gl_flag <> FND_API.g_miss_char

Line 1084: IF p_claim_rec.post_to_gl_flag <> FND_API.g_miss_char

1080: x_return_status := FND_API.g_ret_sts_success;
1081:
1082: ----------------------- post_to_gl_flag ------------------------
1083: /*
1084: IF p_claim_rec.post_to_gl_flag <> FND_API.g_miss_char
1085: AND p_claim_rec.post_to_gl_flag IS NOT NULL
1086: THEN
1087: IF p_claim_rec.post_to_gl_flag <> FND_API.g_true
1088: AND p_claim_rec.post_to_gl_flag <> FND_API.g_false

Line 1087: IF p_claim_rec.post_to_gl_flag <> FND_API.g_true

1083: /*
1084: IF p_claim_rec.post_to_gl_flag <> FND_API.g_miss_char
1085: AND p_claim_rec.post_to_gl_flag IS NOT NULL
1086: THEN
1087: IF p_claim_rec.post_to_gl_flag <> FND_API.g_true
1088: AND p_claim_rec.post_to_gl_flag <> FND_API.g_false
1089: THEN
1090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1091: THEN

Line 1088: AND p_claim_rec.post_to_gl_flag <> FND_API.g_false

1084: IF p_claim_rec.post_to_gl_flag <> FND_API.g_miss_char
1085: AND p_claim_rec.post_to_gl_flag IS NOT NULL
1086: THEN
1087: IF p_claim_rec.post_to_gl_flag <> FND_API.g_true
1088: AND p_claim_rec.post_to_gl_flag <> FND_API.g_false
1089: THEN
1090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1091: THEN
1092: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');

Line 1097: x_return_status := FND_API.g_ret_sts_error;

1093: FND_MESSAGE.Set_Token('FLAG','POST_TO_GL_FLAG');
1094: FND_MSG_PUB.add;
1095: END IF;
1096:
1097: x_return_status := FND_API.g_ret_sts_error;
1098: RETURN;
1099: END IF;
1100: END IF;
1101: */

Line 1127: IF x_return_status <> FND_API.g_ret_sts_success THEN

1123: p_claim_rec => p_claim_rec
1124: ,x_return_status => x_return_status
1125: );
1126:
1127: IF x_return_status <> FND_API.g_ret_sts_success THEN
1128: RETURN;
1129: END IF;
1130:
1131: Check_Claim_Type_Uk_Items(

Line 1137: IF x_return_status <> FND_API.g_ret_sts_success THEN

1133: ,p_validation_mode => p_validation_mode
1134: ,x_return_status => x_return_status
1135: );
1136:
1137: IF x_return_status <> FND_API.g_ret_sts_success THEN
1138: RETURN;
1139: END IF;
1140:
1141: Check_Claim_Type_Fk_Items(

Line 1146: IF x_return_status <> FND_API.g_ret_sts_success THEN

1142: p_claim_rec => p_claim_rec
1143: ,x_return_status => x_return_status
1144: );
1145:
1146: IF x_return_status <> FND_API.g_ret_sts_success THEN
1147: RETURN;
1148: END IF;
1149:
1150: Check_Claim_Type_Lookup_Items(

Line 1155: IF x_return_status <> FND_API.g_ret_sts_success THEN

1151: p_claim_rec => p_claim_rec
1152: ,x_return_status => x_return_status
1153: );
1154:
1155: IF x_return_status <> FND_API.g_ret_sts_success THEN
1156: RETURN;
1157: END IF;
1158:
1159: Check_Claim_Type_Flag_Items(

Line 1164: IF x_return_status <> FND_API.g_ret_sts_success THEN

1160: p_claim_rec => p_claim_rec
1161: ,x_return_status => x_return_status
1162: );
1163:
1164: IF x_return_status <> FND_API.g_ret_sts_success THEN
1165: RETURN;
1166: END IF;
1167:
1168: END Check_Claim_Type_Items;

Line 1187: x_return_status := FND_API.g_ret_sts_success;

1183: )
1184: IS
1185: BEGIN
1186:
1187: x_return_status := FND_API.g_ret_sts_success;
1188:
1189: -- do other record level checkings
1190: -- End date validation.
1191: IF (p_claim_rec.end_date IS NOT NULL)

Line 1192: AND (p_claim_rec.end_date <> FND_API.G_MISS_DATE) THEN

1188:
1189: -- do other record level checkings
1190: -- End date validation.
1191: IF (p_claim_rec.end_date IS NOT NULL)
1192: AND (p_claim_rec.end_date <> FND_API.G_MISS_DATE) THEN
1193: IF p_claim_rec.start_date > p_claim_rec.end_date THEN
1194: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_TYPE_SD_GT_ED');
1195: FND_MSG_PUB.ADD;
1196: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1196: x_return_status := FND_API.G_RET_STS_ERROR;

1192: AND (p_claim_rec.end_date <> FND_API.G_MISS_DATE) THEN
1193: IF p_claim_rec.start_date > p_claim_rec.end_date THEN
1194: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_TYPE_SD_GT_ED');
1195: FND_MSG_PUB.ADD;
1196: x_return_status := FND_API.G_RET_STS_ERROR;
1197: END IF;
1198: END IF;
1199:
1200: END Check_Claim_Type_Record;

Line 1253: RAISE FND_API.g_exc_error;

1249: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1250: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1251: FND_MSG_PUB.add;
1252: END IF;
1253: RAISE FND_API.g_exc_error;
1254: END IF;
1255: CLOSE c_claim;
1256:
1257:

Line 1258: IF p_claim_rec.object_version_number = FND_API.G_MISS_NUM THEN

1254: END IF;
1255: CLOSE c_claim;
1256:
1257:
1258: IF p_claim_rec.object_version_number = FND_API.G_MISS_NUM THEN
1259: x_complete_rec.object_version_number := NULL;
1260: END IF;
1261: IF p_claim_rec.object_version_number IS NULL THEN
1262: x_complete_rec.object_version_number := l_claim_rec.object_version_number;

Line 1265: IF p_claim_rec.claim_class = FND_API.G_MISS_CHAR THEN

1261: IF p_claim_rec.object_version_number IS NULL THEN
1262: x_complete_rec.object_version_number := l_claim_rec.object_version_number;
1263: END IF;
1264:
1265: IF p_claim_rec.claim_class = FND_API.G_MISS_CHAR THEN
1266: x_complete_rec.claim_class := NULL;
1267: END IF;
1268: IF p_claim_rec.claim_class IS NULL THEN
1269: x_complete_rec.claim_class := l_claim_rec.claim_class;

Line 1272: IF p_claim_rec.set_of_books_id = FND_API.G_MISS_NUM THEN

1268: IF p_claim_rec.claim_class IS NULL THEN
1269: x_complete_rec.claim_class := l_claim_rec.claim_class;
1270: END IF;
1271:
1272: IF p_claim_rec.set_of_books_id = FND_API.G_MISS_NUM THEN
1273: x_complete_rec.set_of_books_id := NULL;
1274: END IF;
1275: IF p_claim_rec.set_of_books_id IS NULL THEN
1276: x_complete_rec.set_of_books_id := l_claim_rec.set_of_books_id;

Line 1279: IF p_claim_rec.post_to_gl_flag = FND_API.G_MISS_CHAR THEN

1275: IF p_claim_rec.set_of_books_id IS NULL THEN
1276: x_complete_rec.set_of_books_id := l_claim_rec.set_of_books_id;
1277: END IF;
1278:
1279: IF p_claim_rec.post_to_gl_flag = FND_API.G_MISS_CHAR THEN
1280: x_complete_rec.post_to_gl_flag := NULL;
1281: END IF;
1282: IF p_claim_rec.post_to_gl_flag IS NULL THEN
1283: x_complete_rec.post_to_gl_flag := l_claim_rec.post_to_gl_flag;

Line 1286: IF p_claim_rec.start_date = FND_API.G_MISS_DATE THEN

1282: IF p_claim_rec.post_to_gl_flag IS NULL THEN
1283: x_complete_rec.post_to_gl_flag := l_claim_rec.post_to_gl_flag;
1284: END IF;
1285:
1286: IF p_claim_rec.start_date = FND_API.G_MISS_DATE THEN
1287: x_complete_rec.start_date := NULL;
1288: END IF;
1289: IF p_claim_rec.start_date IS NULL THEN
1290: x_complete_rec.start_date := l_claim_rec.start_date;

Line 1293: IF p_claim_rec.end_date = FND_API.G_MISS_DATE THEN

1289: IF p_claim_rec.start_date IS NULL THEN
1290: x_complete_rec.start_date := l_claim_rec.start_date;
1291: END IF;
1292:
1293: IF p_claim_rec.end_date = FND_API.G_MISS_DATE THEN
1294: x_complete_rec.end_date := NULL;
1295: END IF;
1296: IF p_claim_rec.end_date IS NULL THEN
1297: x_complete_rec.end_date := l_claim_rec.end_date;

Line 1300: IF p_claim_rec.creation_sign = FND_API.G_MISS_CHAR THEN

1296: IF p_claim_rec.end_date IS NULL THEN
1297: x_complete_rec.end_date := l_claim_rec.end_date;
1298: END IF;
1299:
1300: IF p_claim_rec.creation_sign = FND_API.G_MISS_CHAR THEN
1301: x_complete_rec.creation_sign := NULL;
1302: END IF;
1303: IF p_claim_rec.creation_sign IS NULL THEN
1304: x_complete_rec.creation_sign := l_claim_rec.creation_sign;

Line 1307: IF p_claim_rec.gl_id_ded_adj = FND_API.G_MISS_NUM THEN

1303: IF p_claim_rec.creation_sign IS NULL THEN
1304: x_complete_rec.creation_sign := l_claim_rec.creation_sign;
1305: END IF;
1306:
1307: IF p_claim_rec.gl_id_ded_adj = FND_API.G_MISS_NUM THEN
1308: x_complete_rec.gl_id_ded_adj := NULL;
1309: END IF;
1310: IF p_claim_rec.gl_id_ded_adj IS NULL THEN
1311: x_complete_rec.gl_id_ded_adj := l_claim_rec.gl_id_ded_adj;

Line 1314: IF p_claim_rec.gl_id_ded_adj_clearing = FND_API.G_MISS_NUM THEN

1310: IF p_claim_rec.gl_id_ded_adj IS NULL THEN
1311: x_complete_rec.gl_id_ded_adj := l_claim_rec.gl_id_ded_adj;
1312: END IF;
1313:
1314: IF p_claim_rec.gl_id_ded_adj_clearing = FND_API.G_MISS_NUM THEN
1315: x_complete_rec.gl_id_ded_adj_clearing := NULL;
1316: END IF;
1317: IF p_claim_rec.gl_id_ded_adj_clearing IS NULL THEN
1318: x_complete_rec.gl_id_ded_adj_clearing := l_claim_rec.gl_id_ded_adj_clearing;

Line 1321: IF p_claim_rec.gl_id_ded_clearing = FND_API.G_MISS_NUM THEN

1317: IF p_claim_rec.gl_id_ded_adj_clearing IS NULL THEN
1318: x_complete_rec.gl_id_ded_adj_clearing := l_claim_rec.gl_id_ded_adj_clearing;
1319: END IF;
1320:
1321: IF p_claim_rec.gl_id_ded_clearing = FND_API.G_MISS_NUM THEN
1322: x_complete_rec.gl_id_ded_clearing := NULL;
1323: END IF;
1324: IF p_claim_rec.gl_id_ded_clearing IS NULL THEN
1325: x_complete_rec.gl_id_ded_clearing := l_claim_rec.gl_id_ded_clearing;

Line 1328: IF p_claim_rec.gl_id_accr_promo_liab = FND_API.G_MISS_NUM THEN

1324: IF p_claim_rec.gl_id_ded_clearing IS NULL THEN
1325: x_complete_rec.gl_id_ded_clearing := l_claim_rec.gl_id_ded_clearing;
1326: END IF;
1327:
1328: IF p_claim_rec.gl_id_accr_promo_liab = FND_API.G_MISS_NUM THEN
1329: x_complete_rec.gl_id_accr_promo_liab := NULL;
1330: END IF;
1331: IF p_claim_rec.gl_id_accr_promo_liab IS NULL THEN
1332: x_complete_rec.gl_id_accr_promo_liab := l_claim_rec.gl_id_accr_promo_liab;

Line 1335: IF p_claim_rec.transaction_type = FND_API.G_MISS_NUM THEN

1331: IF p_claim_rec.gl_id_accr_promo_liab IS NULL THEN
1332: x_complete_rec.gl_id_accr_promo_liab := l_claim_rec.gl_id_accr_promo_liab;
1333: END IF;
1334:
1335: IF p_claim_rec.transaction_type = FND_API.G_MISS_NUM THEN
1336: x_complete_rec.transaction_type := NULL;
1337: END IF;
1338: IF p_claim_rec.transaction_type IS NULL THEN
1339: x_complete_rec.transaction_type := l_claim_rec.transaction_type;

Line 1342: IF p_claim_rec.cm_trx_type_id = FND_API.G_MISS_NUM THEN

1338: IF p_claim_rec.transaction_type IS NULL THEN
1339: x_complete_rec.transaction_type := l_claim_rec.transaction_type;
1340: END IF;
1341:
1342: IF p_claim_rec.cm_trx_type_id = FND_API.G_MISS_NUM THEN
1343: x_complete_rec.cm_trx_type_id := NULL;
1344: END IF;
1345: IF p_claim_rec.cm_trx_type_id IS NULL THEN
1346: x_complete_rec.cm_trx_type_id := l_claim_rec.cm_trx_type_id;

Line 1349: IF p_claim_rec.dm_trx_type_id = FND_API.G_MISS_NUM THEN

1345: IF p_claim_rec.cm_trx_type_id IS NULL THEN
1346: x_complete_rec.cm_trx_type_id := l_claim_rec.cm_trx_type_id;
1347: END IF;
1348:
1349: IF p_claim_rec.dm_trx_type_id = FND_API.G_MISS_NUM THEN
1350: x_complete_rec.dm_trx_type_id := NULL;
1351: END IF;
1352: IF p_claim_rec.dm_trx_type_id IS NULL THEN
1353: x_complete_rec.dm_trx_type_id := l_claim_rec.dm_trx_type_id;

Line 1356: IF p_claim_rec.cb_trx_type_id = FND_API.G_MISS_NUM THEN

1352: IF p_claim_rec.dm_trx_type_id IS NULL THEN
1353: x_complete_rec.dm_trx_type_id := l_claim_rec.dm_trx_type_id;
1354: END IF;
1355:
1356: IF p_claim_rec.cb_trx_type_id = FND_API.G_MISS_NUM THEN
1357: x_complete_rec.cb_trx_type_id := NULL;
1358: END IF;
1359: IF p_claim_rec.cb_trx_type_id IS NULL THEN
1360: x_complete_rec.cb_trx_type_id := l_claim_rec.cb_trx_type_id;

Line 1363: IF p_claim_rec.wo_rec_trx_id = FND_API.G_MISS_NUM THEN

1359: IF p_claim_rec.cb_trx_type_id IS NULL THEN
1360: x_complete_rec.cb_trx_type_id := l_claim_rec.cb_trx_type_id;
1361: END IF;
1362:
1363: IF p_claim_rec.wo_rec_trx_id = FND_API.G_MISS_NUM THEN
1364: x_complete_rec.wo_rec_trx_id := NULL;
1365: END IF;
1366: IF p_claim_rec.wo_rec_trx_id IS NULL THEN
1367: x_complete_rec.wo_rec_trx_id := l_claim_rec.wo_rec_trx_id;

Line 1370: IF p_claim_rec.adj_rec_trx_id = FND_API.G_MISS_NUM THEN

1366: IF p_claim_rec.wo_rec_trx_id IS NULL THEN
1367: x_complete_rec.wo_rec_trx_id := l_claim_rec.wo_rec_trx_id;
1368: END IF;
1369:
1370: IF p_claim_rec.adj_rec_trx_id = FND_API.G_MISS_NUM THEN
1371: x_complete_rec.adj_rec_trx_id := NULL;
1372: END IF;
1373: IF p_claim_rec.adj_rec_trx_id IS NULL THEN
1374: x_complete_rec.adj_rec_trx_id := l_claim_rec.adj_rec_trx_id;

Line 1377: IF p_claim_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1373: IF p_claim_rec.adj_rec_trx_id IS NULL THEN
1374: x_complete_rec.adj_rec_trx_id := l_claim_rec.adj_rec_trx_id;
1375: END IF;
1376:
1377: IF p_claim_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1378: x_complete_rec.attribute_category := NULL;
1379: END IF;
1380: IF p_claim_rec.attribute_category IS NULL THEN
1381: x_complete_rec.attribute_category := l_claim_rec.attribute_category;

Line 1384: IF p_claim_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1380: IF p_claim_rec.attribute_category IS NULL THEN
1381: x_complete_rec.attribute_category := l_claim_rec.attribute_category;
1382: END IF;
1383:
1384: IF p_claim_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1385: x_complete_rec.attribute1 := NULL;
1386: END IF;
1387: IF p_claim_rec.attribute1 IS NULL THEN
1388: x_complete_rec.attribute1 := l_claim_rec.attribute1;

Line 1391: IF p_claim_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1387: IF p_claim_rec.attribute1 IS NULL THEN
1388: x_complete_rec.attribute1 := l_claim_rec.attribute1;
1389: END IF;
1390:
1391: IF p_claim_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1392: x_complete_rec.attribute2 := NULL;
1393: END IF;
1394: IF p_claim_rec.attribute2 IS NULL THEN
1395: x_complete_rec.attribute2 := l_claim_rec.attribute2;

Line 1398: IF p_claim_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1394: IF p_claim_rec.attribute2 IS NULL THEN
1395: x_complete_rec.attribute2 := l_claim_rec.attribute2;
1396: END IF;
1397:
1398: IF p_claim_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1399: x_complete_rec.attribute3 := NULL;
1400: END IF;
1401: IF p_claim_rec.attribute3 IS NULL THEN
1402: x_complete_rec.attribute3 := l_claim_rec.attribute3;

Line 1405: IF p_claim_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1401: IF p_claim_rec.attribute3 IS NULL THEN
1402: x_complete_rec.attribute3 := l_claim_rec.attribute3;
1403: END IF;
1404:
1405: IF p_claim_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1406: x_complete_rec.attribute4 := NULL;
1407: END IF;
1408: IF p_claim_rec.attribute4 IS NULL THEN
1409: x_complete_rec.attribute4 := l_claim_rec.attribute4;

Line 1412: IF p_claim_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1408: IF p_claim_rec.attribute4 IS NULL THEN
1409: x_complete_rec.attribute4 := l_claim_rec.attribute4;
1410: END IF;
1411:
1412: IF p_claim_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1413: x_complete_rec.attribute5 := NULL;
1414: END IF;
1415: IF p_claim_rec.attribute5 IS NULL THEN
1416: x_complete_rec.attribute5 := l_claim_rec.attribute5;

Line 1419: IF p_claim_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1415: IF p_claim_rec.attribute5 IS NULL THEN
1416: x_complete_rec.attribute5 := l_claim_rec.attribute5;
1417: END IF;
1418:
1419: IF p_claim_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1420: x_complete_rec.attribute6 := NULL;
1421: END IF;
1422: IF p_claim_rec.attribute6 IS NULL THEN
1423: x_complete_rec.attribute6 := l_claim_rec.attribute6;

Line 1426: IF p_claim_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1422: IF p_claim_rec.attribute6 IS NULL THEN
1423: x_complete_rec.attribute6 := l_claim_rec.attribute6;
1424: END IF;
1425:
1426: IF p_claim_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1427: x_complete_rec.attribute7 := NULL;
1428: END IF;
1429: IF p_claim_rec.attribute7 IS NULL THEN
1430: x_complete_rec.attribute7 := l_claim_rec.attribute7;

Line 1433: IF p_claim_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1429: IF p_claim_rec.attribute7 IS NULL THEN
1430: x_complete_rec.attribute7 := l_claim_rec.attribute7;
1431: END IF;
1432:
1433: IF p_claim_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1434: x_complete_rec.attribute8 := NULL;
1435: END IF;
1436: IF p_claim_rec.attribute8 IS NULL THEN
1437: x_complete_rec.attribute8 := l_claim_rec.attribute8;

Line 1440: IF p_claim_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1436: IF p_claim_rec.attribute8 IS NULL THEN
1437: x_complete_rec.attribute8 := l_claim_rec.attribute8;
1438: END IF;
1439:
1440: IF p_claim_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1441: x_complete_rec.attribute9 := NULL;
1442: END IF;
1443: IF p_claim_rec.attribute9 IS NULL THEN
1444: x_complete_rec.attribute9 := l_claim_rec.attribute9;

Line 1447: IF p_claim_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1443: IF p_claim_rec.attribute9 IS NULL THEN
1444: x_complete_rec.attribute9 := l_claim_rec.attribute9;
1445: END IF;
1446:
1447: IF p_claim_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1448: x_complete_rec.attribute10 := NULL;
1449: END IF;
1450: IF p_claim_rec.attribute10 IS NULL THEN
1451: x_complete_rec.attribute10 := l_claim_rec.attribute10;

Line 1454: IF p_claim_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1450: IF p_claim_rec.attribute10 IS NULL THEN
1451: x_complete_rec.attribute10 := l_claim_rec.attribute10;
1452: END IF;
1453:
1454: IF p_claim_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1455: x_complete_rec.attribute11 := NULL;
1456: END IF;
1457: IF p_claim_rec.attribute11 IS NULL THEN
1458: x_complete_rec.attribute11 := l_claim_rec.attribute11;

Line 1461: IF p_claim_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1457: IF p_claim_rec.attribute11 IS NULL THEN
1458: x_complete_rec.attribute11 := l_claim_rec.attribute11;
1459: END IF;
1460:
1461: IF p_claim_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1462: x_complete_rec.attribute12 := NULL;
1463: END IF;
1464: IF p_claim_rec.attribute12 IS NULL THEN
1465: x_complete_rec.attribute12 := l_claim_rec.attribute12;

Line 1468: IF p_claim_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1464: IF p_claim_rec.attribute12 IS NULL THEN
1465: x_complete_rec.attribute12 := l_claim_rec.attribute12;
1466: END IF;
1467:
1468: IF p_claim_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1469: x_complete_rec.attribute13 := NULL;
1470: END IF;
1471: IF p_claim_rec.attribute13 IS NULL THEN
1472: x_complete_rec.attribute13 := l_claim_rec.attribute13;

Line 1475: IF p_claim_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1471: IF p_claim_rec.attribute13 IS NULL THEN
1472: x_complete_rec.attribute13 := l_claim_rec.attribute13;
1473: END IF;
1474:
1475: IF p_claim_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1476: x_complete_rec.attribute14 := NULL;
1477: END IF;
1478: IF p_claim_rec.attribute14 IS NULL THEN
1479: x_complete_rec.attribute14 := l_claim_rec.attribute14;

Line 1482: IF p_claim_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1478: IF p_claim_rec.attribute14 IS NULL THEN
1479: x_complete_rec.attribute14 := l_claim_rec.attribute14;
1480: END IF;
1481:
1482: IF p_claim_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1483: x_complete_rec.attribute15 := NULL;
1484: END IF;
1485: IF p_claim_rec.attribute15 IS NULL THEN
1486: x_complete_rec.attribute15 := l_claim_rec.attribute15;

Line 1489: IF p_claim_rec.name = FND_API.G_MISS_CHAR THEN

1485: IF p_claim_rec.attribute15 IS NULL THEN
1486: x_complete_rec.attribute15 := l_claim_rec.attribute15;
1487: END IF;
1488:
1489: IF p_claim_rec.name = FND_API.G_MISS_CHAR THEN
1490: x_complete_rec.name := NULL;
1491: END IF;
1492: IF p_claim_rec.name IS NULL THEN
1493: x_complete_rec.name := l_claim_rec.name;

Line 1496: IF p_claim_rec.description = FND_API.G_MISS_CHAR THEN

1492: IF p_claim_rec.name IS NULL THEN
1493: x_complete_rec.name := l_claim_rec.name;
1494: END IF;
1495:
1496: IF p_claim_rec.description = FND_API.G_MISS_CHAR THEN
1497: x_complete_rec.description := NULL;
1498: END IF;
1499: IF p_claim_rec.description IS NULL THEN
1500: x_complete_rec.description := l_claim_rec.description;

Line 1503: IF p_claim_rec.adjustment_type = FND_API.G_MISS_CHAR THEN

1499: IF p_claim_rec.description IS NULL THEN
1500: x_complete_rec.description := l_claim_rec.description;
1501: END IF;
1502:
1503: IF p_claim_rec.adjustment_type = FND_API.G_MISS_CHAR THEN
1504: x_complete_rec.adjustment_type := NULL;
1505: END IF;
1506: IF p_claim_rec.adjustment_type IS NULL THEN
1507: x_complete_rec.adjustment_type := l_claim_rec.adjustment_type;

Line 1510: IF p_claim_rec.order_type_id = FND_API.G_MISS_NUM THEN

1506: IF p_claim_rec.adjustment_type IS NULL THEN
1507: x_complete_rec.adjustment_type := l_claim_rec.adjustment_type;
1508: END IF;
1509:
1510: IF p_claim_rec.order_type_id = FND_API.G_MISS_NUM THEN
1511: x_complete_rec.order_type_id := NULL;
1512: END IF;
1513: IF p_claim_rec.order_type_id IS NULL THEN
1514: x_complete_rec.order_type_id := l_claim_rec.order_type_id;

Line 1517: IF p_claim_rec.neg_wo_rec_trx_id = FND_API.G_MISS_NUM THEN

1513: IF p_claim_rec.order_type_id IS NULL THEN
1514: x_complete_rec.order_type_id := l_claim_rec.order_type_id;
1515: END IF;
1516:
1517: IF p_claim_rec.neg_wo_rec_trx_id = FND_API.G_MISS_NUM THEN
1518: x_complete_rec.neg_wo_rec_trx_id := NULL;
1519: END IF;
1520: IF p_claim_rec.neg_wo_rec_trx_id IS NULL THEN
1521: x_complete_rec.neg_wo_rec_trx_id := l_claim_rec.neg_wo_rec_trx_id;

Line 1524: IF p_claim_rec.gl_balancing_flex_value = FND_API.G_MISS_CHAR THEN

1520: IF p_claim_rec.neg_wo_rec_trx_id IS NULL THEN
1521: x_complete_rec.neg_wo_rec_trx_id := l_claim_rec.neg_wo_rec_trx_id;
1522: END IF;
1523:
1524: IF p_claim_rec.gl_balancing_flex_value = FND_API.G_MISS_CHAR THEN
1525: x_complete_rec.gl_balancing_flex_value := NULL;
1526: END IF;
1527: IF p_claim_rec.gl_balancing_flex_value IS NULL THEN
1528: x_complete_rec.gl_balancing_flex_value := l_claim_rec.gl_balancing_flex_value;