DBA Data[Home] [Help]

APPS.OZF_CLAIM_TYPE_PVT dependencies on OZF_UTILITY_PVT

Line 59: OZF_Utility_PVT.debug_message(l_full_name||': start');

55: --------------------- initialize -----------------------
56: SAVEPOINT Create_Claim_Type;
57:
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;

Line 79: OZF_Utility_PVT.debug_message(l_full_name ||': validate');

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');
80: END IF;
81:
82: Validate_Claim_Type(
83: p_api_version => l_api_version,

Line 102: OZF_Utility_PVT.debug_message(l_full_name ||': insert');

98:
99:
100: -------------------------- insert --------------------------
101: IF OZF_DEBUG_HIGH_ON THEN
102: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
103: END IF;
104:
105: IF l_claim_rec.claim_type_id IS NULL THEN
106: LOOP

Line 194: OZF_Utility_PVT.debug_message(l_full_name ||': end');

190: p_data => x_msg_data
191: );
192:
193: IF OZF_DEBUG_HIGH_ON THEN
194: OZF_Utility_PVT.debug_message(l_full_name ||': end');
195: END IF;
196:
197: EXCEPTION
198:

Line 294: OZF_Utility_PVT.debug_message(l_full_name||': start');

290: --------------------- initialize -----------------------
291: SAVEPOINT Delete_Claim_Type;
292:
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;

Line 314: OZF_Utility_PVT.debug_message(l_full_name ||': delete');

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

Line 328: OZF_Utility_PVT.debug_message(p_claim_type_id ||': p_claim_type_id');

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');
329: OZF_Utility_PVT.debug_message(p_object_version ||': p_object_version');
330: END IF;
331:
332: OPEN c_claim_count(p_claim_type_id, p_object_version);

Line 329: OZF_Utility_PVT.debug_message(p_object_version ||': p_object_version');

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');
329: OZF_Utility_PVT.debug_message(p_object_version ||': p_object_version');
330: END IF;
331:
332: OPEN c_claim_count(p_claim_type_id, p_object_version);
333: FETCH c_claim_count INTO l_claim_check;

Line 385: OZF_Utility_PVT.debug_message(l_claim_using_check ||': not aaaa using by any claim');

381: CLOSE c_approval_using;
382:
383:
384: IF OZF_DEBUG_HIGH_ON THEN
385: OZF_Utility_PVT.debug_message(l_claim_using_check ||': not aaaa using by any claim');
386: END IF;
387:
388:
389: BEGIN

Line 397: OZF_Utility_PVT.debug_message(': After deleting');

393: );
394:
395:
396: IF OZF_DEBUG_HIGH_ON THEN
397: OZF_Utility_PVT.debug_message(': After deleting');
398: END IF;
399:
400: EXCEPTION
401: WHEN OTHERS THEN

Line 417: OZF_Utility_PVT.debug_message(l_full_name ||': end');

413: p_data => x_msg_data
414: );
415:
416: IF OZF_DEBUG_HIGH_ON THEN
417: OZF_Utility_PVT.debug_message(l_full_name ||': end');
418: END IF;
419:
420: EXCEPTION
421:

Line 503: OZF_Utility_PVT.debug_message(l_full_name||': start');

499: -------------------- initialize -------------------------
500: SAVEPOINT Update_Claim_Type;
501:
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;

Line 525: OZF_Utility_PVT.debug_message(l_full_name ||': validate');

521:
522:
523: ----------------------- validate ----------------------
524: IF OZF_DEBUG_HIGH_ON THEN
525: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
526: END IF;
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;

Line 585: OZF_Utility_PVT.debug_message(l_full_name ||': KISH update');

581:
582: l_object_version := l_claim_rec.object_version_number + 1;
583: -------------------------- update --------------------
584: IF OZF_DEBUG_HIGH_ON THEN
585: OZF_Utility_PVT.debug_message(l_full_name ||': KISH update');
586: END IF;
587:
588:
589: BEGIN

Line 658: OZF_Utility_PVT.debug_message(l_full_name ||': end');

654: p_data => x_msg_data
655: );
656:
657: IF OZF_DEBUG_HIGH_ON THEN
658: OZF_Utility_PVT.debug_message(l_full_name ||': end');
659: END IF;
660:
661: EXCEPTION
662:

Line 728: OZF_Utility_PVT.debug_message(l_full_name||': start');

724: BEGIN
725:
726: ----------------------- initialize --------------------
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;

Line 748: OZF_Utility_PVT.debug_message(l_full_name||': check items');

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');
749: END IF;
750:
751: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
752: Check_Claim_Type_Items(

Line 766: OZF_Utility_PVT.debug_message(l_full_name||': check record');

762: END IF;
763: END IF;
764:
765: IF OZF_DEBUG_HIGH_ON THEN
766: OZF_Utility_PVT.debug_message(l_full_name||': check record');
767: END IF;
768:
769: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
770: Check_Claim_Type_Record(

Line 791: OZF_Utility_PVT.debug_message(l_full_name ||': end');

787: p_data => x_msg_data
788: );
789:
790: IF OZF_DEBUG_HIGH_ON THEN
791: OZF_Utility_PVT.debug_message(l_full_name ||': end');
792: END IF;
793:
794: EXCEPTION
795:

Line 945: IF OZF_Utility_PVT.check_uniqueness(

941: -- check if this claim_type_id is unique.
942: IF p_validation_mode = JTF_PLSQL_API.g_create
943: AND p_claim_rec.claim_type_id IS NOT NULL
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

Line 1027: IF OZF_Utility_PVT.check_lookup_exists(

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',
1030: p_lookup_code => p_claim_rec.claim_class
1031: ) = FND_API.g_false THEN

Line 1044: IF OZF_Utility_PVT.check_lookup_exists(

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
1048: ) = FND_API.g_false