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_MSG_PUB

Line 6: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

2: /* $Header: ozfvclmb.pls 120.3 2005/12/22 23:29:13 sshivali ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):='OZF_Claim_Type_PVT';
5:
6: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7:
8: ---------------------------------------------------------------------
9: -- PROCEDURE
10: -- Create_Claim_Type

Line 63: FND_MSG_PUB.initialize;

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(
67: l_api_version,

Line 187: FND_MSG_PUB.count_and_get(

183: IF FND_API.to_boolean(p_commit) THEN
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: );

Line 202: FND_MSG_PUB.count_and_get (

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
206: );

Line 211: FND_MSG_PUB.count_and_get (

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
215: );

Line 221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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);
224: END IF;
225:

Line 223: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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);
224: END IF;
225:
226: FND_MSG_PUB.count_and_get(
227: p_encoded => FND_API.g_false

Line 226: FND_MSG_PUB.count_and_get(

222: THEN
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: );

Line 298: FND_MSG_PUB.initialize;

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(
302: l_api_version,

Line 319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

315: END IF;
316:
317: -- Adjustment types cannot be deleted if the claim_type_id is less than 0
318: IF p_claim_type_id < 0 THEN
319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 322: FND_MSG_PUB.add;

318: IF p_claim_type_id < 0 THEN
319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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:

Line 335: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

331:
332: OPEN c_claim_count(p_claim_type_id, p_object_version);
333: FETCH c_claim_count INTO l_claim_check;
334: IF (c_claim_count%ROWCOUNT = 0) THEN
335: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
336: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
337: FND_MSG_PUB.add;
338: END IF;
339: CLOSE c_claim_count;

Line 337: FND_MSG_PUB.add;

333: FETCH c_claim_count INTO l_claim_check;
334: IF (c_claim_count%ROWCOUNT = 0) THEN
335: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

344: -- Claim Type cannot be deleted if it is using by an existing claim.
345: OPEN c_claim_using(p_claim_type_id);
346: FETCH c_claim_using INTO l_claim_using_check;
347: IF (c_claim_using%ROWCOUNT > 0) THEN
348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
349: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_USED');
350: FND_MSG_PUB.add;
351: END IF;
352: CLOSE c_claim_using;

Line 350: FND_MSG_PUB.add;

346: FETCH c_claim_using INTO l_claim_using_check;
347: IF (c_claim_using%ROWCOUNT > 0) THEN
348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

357: -- Adjustment Type cannot be deleted if it is using by an funds utilized rec.
358: OPEN c_adjustment_using(p_claim_type_id);
359: FETCH c_adjustment_using INTO l_claim_using_check;
360: IF (c_adjustment_using%ROWCOUNT > 0) THEN
361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
362: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_ADJ_USED');
363: FND_MSG_PUB.add;
364: END IF;
365: CLOSE c_adjustment_using;

Line 363: FND_MSG_PUB.add;

359: FETCH c_adjustment_using INTO l_claim_using_check;
360: IF (c_adjustment_using%ROWCOUNT > 0) THEN
361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

370: -- Claim Types can not be deleted when used in approval rules.
371: OPEN c_approval_using(p_claim_type_id);
372: FETCH c_approval_using INTO l_claim_using_check;
373: IF (c_approval_using%ROWCOUNT > 0) THEN
374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
375: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_APPROVAL_USED');
376: FND_MSG_PUB.add;
377: END IF;
378: CLOSE c_approval_using;

Line 376: FND_MSG_PUB.add;

372: FETCH c_approval_using INTO l_claim_using_check;
373: IF (c_approval_using%ROWCOUNT > 0) THEN
374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 410: FND_MSG_PUB.count_and_get(

406: IF FND_API.to_boolean(p_commit) THEN
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: );

Line 425: FND_MSG_PUB.count_and_get(

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
429: );

Line 434: FND_MSG_PUB.count_and_get(

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
438: );

Line 444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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);
447: END IF;
448:

Line 446: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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);
447: END IF;
448:
449: FND_MSG_PUB.count_and_get(
450: p_encoded => FND_API.g_false,

Line 449: FND_MSG_PUB.count_and_get(

445: THEN
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: );

Line 507: FND_MSG_PUB.initialize;

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(
511: l_api_version,

Line 531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

527:
528: OPEN c_claim_count(p_claim_rec.claim_type_id, p_claim_rec.object_version_number);
529: FETCH c_claim_count INTO l_claim_check;
530: IF (c_claim_count%ROWCOUNT = 0) THEN
531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
532: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
533: FND_MSG_PUB.add;
534: END IF;
535: CLOSE c_claim_count;

Line 533: FND_MSG_PUB.add;

529: FETCH c_claim_count INTO l_claim_check;
530: IF (c_claim_count%ROWCOUNT = 0) THEN
531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 542: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

538: CLOSE c_claim_count;
539:
540: -- Adjustment types cannot be updated if the claim_type_id is less than 0
541: IF p_claim_rec.claim_type_id < 0 THEN
542: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 545: FND_MSG_PUB.add;

541: IF p_claim_rec.claim_type_id < 0 THEN
542: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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:

Line 651: FND_MSG_PUB.count_and_get(

647: IF FND_API.to_boolean(p_commit) THEN
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: );

Line 666: FND_MSG_PUB.count_and_get(

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
670: );

Line 675: FND_MSG_PUB.count_and_get(

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
679: );

Line 685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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);
688: END IF;
689:

Line 687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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);
688: END IF;
689:
690: FND_MSG_PUB.count_and_get(
691: p_encoded => FND_API.g_false,

Line 690: FND_MSG_PUB.count_and_get(

686: THEN
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: );

Line 732: FND_MSG_PUB.initialize;

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(
736: l_api_version,

Line 784: FND_MSG_PUB.count_and_get(

780: END IF;
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: );

Line 798: FND_MSG_PUB.count_and_get(

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
802: );

Line 806: FND_MSG_PUB.count_and_get(

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
810: );

Line 814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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;
818:

Line 816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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;
818:
819: FND_MSG_PUB.count_and_get(
820: p_encoded => FND_API.g_false,

Line 819: FND_MSG_PUB.count_and_get(

815: THEN
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: );

Line 846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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)
847: THEN
848: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
849: FND_MESSAGE.Set_Token('COLUMN', 'CLAIM_CLASS');
850: FND_MSG_PUB.add;

Line 850: FND_MSG_PUB.add;

846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
847: THEN
848: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
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;

Line 859: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

855: ------------------------ Adjustment type--------------------------
856: ELSIF p_claim_rec.claim_class = 'ADJ' AND
857: p_claim_rec.adjustment_type IS NULL
858: THEN
859: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
860: THEN
861: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_ADJTYPE');
862: FND_MESSAGE.Set_Token('COLUMN', 'ADJUSTMENT_TYPE');
863: FND_MSG_PUB.add;

Line 863: FND_MSG_PUB.add;

859: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
860: THEN
861: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_ADJTYPE');
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;

Line 870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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)
871: THEN
872: /*
873: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
874: FND_MESSAGE.Set_Token('COLUMN', 'SET_OF_BOOKS_ID');

Line 875: FND_MSG_PUB.add;

871: THEN
872: /*
873: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
874: FND_MESSAGE.Set_Token('COLUMN', 'SET_OF_BOOKS_ID');
875: FND_MSG_PUB.add;
876: */
877: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_NO_BOOKS');
878: FND_MSG_PUB.add;
879: END IF;

Line 878: FND_MSG_PUB.add;

874: FND_MESSAGE.Set_Token('COLUMN', 'SET_OF_BOOKS_ID');
875: FND_MSG_PUB.add;
876: */
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;

Line 885: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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)
886: THEN
887: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
888: FND_MESSAGE.Set_Token('COLUMN', 'POST_TO_GL_GLAG');
889: FND_MSG_PUB.add;

Line 889: FND_MSG_PUB.add;

885: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
886: THEN
887: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
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;

Line 896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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)
897: THEN
898: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
899: FND_MESSAGE.Set_Token('COLUMN', 'START_DATE');
900: FND_MSG_PUB.add;

Line 900: FND_MSG_PUB.add;

896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
897: THEN
898: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
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;

Line 907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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)
908: THEN
909: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
910: FND_MESSAGE.Set_Token('COLUMN', 'NAME');
911: FND_MSG_PUB.add;

Line 911: FND_MSG_PUB.add;

907: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
908: THEN
909: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
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;

Line 950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
953: FND_MESSAGE.set_token('COLLUMN', 'CLAIM_TYPE_ID');
954: FND_MSG_PUB.add;

Line 954: FND_MSG_PUB.add;

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');
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;

Line 997: FND_MSG_PUB.add;

993: FETCH c_order_trx_type INTO l_dummy;
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;

Line 1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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;
1036:

Line 1034: FND_MSG_PUB.add;

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;
1036:
1037: x_return_status := FND_API.g_ret_sts_error;
1038: RETURN;

Line 1050: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
1053: FND_MSG_PUB.add;
1054: END IF;

Line 1053: FND_MSG_PUB.add;

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');
1053: FND_MSG_PUB.add;
1054: END IF;
1055:
1056: x_return_status := FND_API.g_ret_sts_error;
1057: RETURN;

Line 1090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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');
1093: FND_MESSAGE.Set_Token('FLAG','POST_TO_GL_FLAG');
1094: FND_MSG_PUB.add;

Line 1094: FND_MSG_PUB.add;

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');
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;

Line 1195: FND_MSG_PUB.ADD;

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;
1197: END IF;
1198: END IF;
1199:

Line 1249: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1245: OPEN c_claim;
1246: FETCH c_claim INTO l_claim_rec;
1247: IF c_claim%NOTFOUND THEN
1248: CLOSE c_claim;
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;

Line 1251: FND_MSG_PUB.add;

1247: IF c_claim%NOTFOUND THEN
1248: CLOSE c_claim;
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;