DBA Data[Home] [Help]

APPS.OZF_CLAIM_TYPE_PVT dependencies on FND_MESSAGE

Line 320: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_NO_DEL');

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;
324: RAISE FND_API.g_exc_error;

Line 321: FND_MESSAGE.set_name('OZF', 'OZF_ADJ_TYPE_NO_DEL');

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;
324: RAISE FND_API.g_exc_error;
325: END IF;

Line 336: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

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;
340: RAISE FND_API.g_exc_error;

Line 349: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_USED');

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;
353: RAISE FND_API.g_exc_error;

Line 362: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_ADJ_USED');

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;
366: RAISE FND_API.g_exc_error;

Line 375: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_APPROVAL_USED');

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;
379: RAISE FND_API.g_exc_error;

Line 532: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

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;
536: RAISE FND_API.g_exc_error;

Line 543: --FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_NO_UPDATE');

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;
547: RAISE FND_API.g_exc_error;

Line 544: FND_MESSAGE.set_name('OZF', 'OZF_ADJ_TYPE_NO_UPDATE');

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;
547: RAISE FND_API.g_exc_error;
548: END IF;

Line 848: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');

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;
851: END IF;
852:

Line 849: FND_MESSAGE.Set_Token('COLUMN', '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;
851: END IF;
852:
853: x_return_status := FND_API.g_ret_sts_error;

Line 861: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_ADJTYPE');

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;
864: END IF;
865:

Line 862: FND_MESSAGE.Set_Token('COLUMN', 'ADJUSTMENT_TYPE');

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;
864: END IF;
865:
866: x_return_status := FND_API.g_ret_sts_error;

Line 873: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');

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');
875: FND_MSG_PUB.add;
876: */
877: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_NO_BOOKS');

Line 874: FND_MESSAGE.Set_Token('COLUMN', 'SET_OF_BOOKS_ID');

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');
875: FND_MSG_PUB.add;
876: */
877: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_NO_BOOKS');
878: FND_MSG_PUB.add;

Line 877: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TYPE_NO_BOOKS');

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;
880:
881: x_return_status := FND_API.g_ret_sts_error;

Line 887: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');

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;
890: END IF;
891:

Line 888: FND_MESSAGE.Set_Token('COLUMN', 'POST_TO_GL_GLAG');

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;
890: END IF;
891:
892: x_return_status := FND_API.g_ret_sts_error;

Line 898: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');

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;
901: END IF;
902:

Line 899: FND_MESSAGE.Set_Token('COLUMN', '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;
901: END IF;
902:
903: x_return_status := FND_API.g_ret_sts_error;

Line 909: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');

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;
912: END IF;
913:

Line 910: FND_MESSAGE.Set_Token('COLUMN', '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;
912: END IF;
913:
914: x_return_status := FND_API.g_ret_sts_error;

Line 952: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUPLICATE_VALUE');

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;
955: END IF;
956: x_return_status := FND_API.g_ret_sts_error;

Line 953: FND_MESSAGE.set_token('COLLUMN', 'CLAIM_TYPE_ID');

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;
955: END IF;
956: x_return_status := FND_API.g_ret_sts_error;
957: RETURN;

Line 996: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_OM_TRX_TYPE');

992: OPEN c_order_trx_type(p_claim_rec.order_type_id);
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;

Line 1033: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_CLASS');

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

Line 1052: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_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;
1055:
1056: x_return_status := FND_API.g_ret_sts_error;

Line 1092: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');

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;
1095: END IF;
1096:

Line 1093: FND_MESSAGE.Set_Token('FLAG','POST_TO_GL_FLAG');

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;
1095: END IF;
1096:
1097: x_return_status := FND_API.g_ret_sts_error;

Line 1194: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_TYPE_SD_GT_ED');

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

Line 1250: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

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