DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJ_TIER_PVT dependencies on OZF_UTILITY_PVT

Line 123: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

119:
120:
121:
122: -- Debug Message
123: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
124:
125:
126:
127: -- Initialize API return status to SUCCESS

Line 136: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

132: -- =========================================================================
133:
134: IF FND_GLOBAL.USER_ID IS NULL
135: THEN
136: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
139:
140:

Line 145: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Adj_Tier');

141:
142: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
143: THEN
144: -- Debug message
145: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Adj_Tier');
146:
147: -- Invoke validation procedures
148: Validate_offer_adj_tier(
149: p_api_version_number => 1.0,

Line 182: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

178: l_offer_adjst_tier_id := p_offadj_tier_rec.offer_adjst_tier_id;
179: END IF;
180:
181: -- Debug Message
182: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
183:
184: -- Invoke table handler(Ozf_Offer_Adj_Tier_Pkg.Insert_Row)
185: Ozf_Offer_Adj_Tier_Pkg.Insert_Row(
186: px_offer_adjst_tier_id => l_offer_adjst_tier_id,

Line 218: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

214: END IF;
215:
216:
217: -- Debug Message
218: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
219:
220:
221: -- Standard call to get message count and if count is 1, get message info.
222: FND_MSG_PUB.Count_And_Get

Line 228: WHEN OZF_Utility_PVT.resource_locked THEN

224: p_data => x_msg_data
225: );
226: EXCEPTION
227:
228: WHEN OZF_Utility_PVT.resource_locked THEN
229: x_return_status := FND_API.g_ret_sts_error;
230: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
231:
232: WHEN FND_API.G_EXC_ERROR THEN

Line 230: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

226: EXCEPTION
227:
228: WHEN OZF_Utility_PVT.resource_locked THEN
229: x_return_status := FND_API.g_ret_sts_error;
230: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
231:
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
234: x_return_status := FND_API.G_RET_STS_ERROR;

Line 357: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

353:
354:
355:
356: -- Debug Message
357: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
358:
359:
360:
361: -- Initialize API return status to SUCCESS

Line 365: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

361: -- Initialize API return status to SUCCESS
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: -- Debug Message
365: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
366:
367: OPEN c_get_Offer_Adj_Tier( l_tar_offadj_tier_rec.offer_adjst_tier_id);
368:
369: FETCH c_get_Offer_Adj_Tier INTO l_ref_offadj_tier_rec ;

Line 372: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

368:
369: FETCH c_get_Offer_Adj_Tier INTO l_ref_offadj_tier_rec ;
370:
371: If ( c_get_Offer_Adj_Tier%NOTFOUND) THEN
372: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
373: p_token_name => 'INFO',
374: p_token_value => 'Offer_Adj_Tier') ;
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;

Line 378: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');

374: p_token_value => 'Offer_Adj_Tier') ;
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377: -- Debug Message
378: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
379: CLOSE c_get_Offer_Adj_Tier;
380:
381:
382: If (l_tar_offadj_tier_rec.object_version_number is NULL or

Line 384: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

380:
381:
382: If (l_tar_offadj_tier_rec.object_version_number is NULL or
383: l_tar_offadj_tier_rec.object_version_number = FND_API.G_MISS_NUM ) Then
384: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
385: p_token_name => 'COLUMN',
386: p_token_value => 'Last_Update_Date') ;
387: raise FND_API.G_EXC_ERROR;
388: End if;

Line 391: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

387: raise FND_API.G_EXC_ERROR;
388: End if;
389: -- Check Whether record has been changed by someone else
390: If (l_tar_offadj_tier_rec.object_version_number <> l_ref_offadj_tier_rec.object_version_number) Then
391: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
392: p_token_name => 'INFO',
393: p_token_value => 'Offer_Adj_Tier') ;
394: raise FND_API.G_EXC_ERROR;
395: End if;

Line 401: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Adj_Tier');

397:
398: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
399: THEN
400: -- Debug message
401: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Adj_Tier');
402:
403: -- Invoke validation procedures
404: Validate_offer_adj_tier(
405: p_api_version_number => 1.0,

Line 421: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW || ' Private API: Calling update table handler');

417: END IF;
418:
419:
420: -- Debug Message
421: OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW || ' Private API: Calling update table handler');
422:
423: l_object_version_number := p_offadj_tier_rec.object_version_number;
424:
425: -- Invoke table handler(Ozf_Offer_Adj_Tier_Pkg.Update_Row)

Line 453: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

449: END IF;
450:
451:
452: -- Debug Message
453: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
454:
455:
456: -- Standard call to get message count and if count is 1, get message info.
457: FND_MSG_PUB.Count_And_Get

Line 463: WHEN OZF_Utility_PVT.resource_locked THEN

459: p_data => x_msg_data
460: );
461: EXCEPTION
462:
463: WHEN OZF_Utility_PVT.resource_locked THEN
464: x_return_status := FND_API.g_ret_sts_error;
465: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
466:
467: WHEN FND_API.G_EXC_ERROR THEN

Line 465: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

461: EXCEPTION
462:
463: WHEN OZF_Utility_PVT.resource_locked THEN
464: x_return_status := FND_API.g_ret_sts_error;
465: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
466:
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
469: x_return_status := FND_API.G_RET_STS_ERROR;

Line 577: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

573:
574:
575:
576: -- Debug Message
577: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
578:
579:
580:
581: -- Initialize API return status to SUCCESS

Line 588: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

584: --
585: -- Api body
586: --
587: -- Debug Message
588: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
589:
590: -- Invoke table handler(Ozf_Offer_Adj_Tier_Pkg.Delete_Row)
591: Ozf_Offer_Adj_Tier_Pkg.Delete_Row(
592: p_offer_adjst_tier_id => p_offer_adjst_tier_id,

Line 606: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

602: END IF;
603:
604:
605: -- Debug Message
606: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get

Line 616: WHEN OZF_Utility_PVT.resource_locked THEN

612: p_data => x_msg_data
613: );
614: EXCEPTION
615:
616: WHEN OZF_Utility_PVT.resource_locked THEN
617: x_return_status := FND_API.g_ret_sts_error;
618: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
619:
620: WHEN FND_API.G_EXC_ERROR THEN

Line 618: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

614: EXCEPTION
615:
616: WHEN OZF_Utility_PVT.resource_locked THEN
617: x_return_status := FND_API.g_ret_sts_error;
618: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
619:
620: WHEN FND_API.G_EXC_ERROR THEN
621: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
622: x_return_status := FND_API.G_RET_STS_ERROR;

Line 712: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

708:
709: BEGIN
710:
711: -- Debug Message
712: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
713:
714:
715: -- Initialize message list if p_init_msg_list is set to TRUE.
716: IF FND_API.to_Boolean( p_init_msg_list )

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

743: FND_MSG_PUB.count_and_get(
744: p_encoded => FND_API.g_false,
745: p_count => x_msg_count,
746: p_data => x_msg_data);
747: OZF_Utility_PVT.debug_message(l_full_name ||': end');
748: EXCEPTION
749:
750: WHEN OZF_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;

Line 750: WHEN OZF_Utility_PVT.resource_locked THEN

746: p_data => x_msg_data);
747: OZF_Utility_PVT.debug_message(l_full_name ||': end');
748: EXCEPTION
749:
750: WHEN OZF_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN

Line 752: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

748: EXCEPTION
749:
750: WHEN OZF_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;

Line 804: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

800: x_return_status := FND_API.g_ret_sts_success;
801: IF p_validation_mode = JTF_PLSQL_API.g_create
802: AND p_offadj_tier_rec.offer_adjst_tier_id IS NOT NULL
803: THEN
804: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
805: 'ozf_offer_adjustment_tiers',
806: 'offer_adjst_tier_id = ''' || p_offadj_tier_rec.offer_adjst_tier_id ||''''
807: );
808: END IF;

Line 811: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_TIER_ID_DUP');

807: );
808: END IF;
809:
810: IF l_valid_flag = FND_API.g_false THEN
811: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_TIER_ID_DUP');
812: x_return_status := FND_API.g_ret_sts_error;
813: END IF;
814:
815: END check_Offadj_Tier_Uk_Items;

Line 831: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );

827:
828: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
829:
830: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.offer_adjustment_id IS NULL THEN
831: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
832: x_return_status := FND_API.g_ret_sts_error;
833: return;
834: END IF;
835:

Line 837: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );

833: return;
834: END IF;
835:
836: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.qp_list_header_id IS NULL THEN
837: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );
838: x_return_status := FND_API.g_ret_sts_error;
839: return;
840: END IF;
841:

Line 843: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );

839: return;
840: END IF;
841:
842: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_tier_rec.modified_discount IS NULL THEN
843: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
844: x_return_status := FND_API.g_ret_sts_error;
845: return;
846: END IF;
847:

Line 848: ozf_utility_pvt.debug_message('OfferDiscountLineId is : '||p_offadj_tier_rec.offer_discount_line_id);

844: x_return_status := FND_API.g_ret_sts_error;
845: return;
846: END IF;
847:
848: ozf_utility_pvt.debug_message('OfferDiscountLineId is : '||p_offadj_tier_rec.offer_discount_line_id);
849: IF p_offadj_tier_rec.offer_discount_line_id IS NULL OR p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
850: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
851: x_return_status := FND_API.g_ret_sts_error;
852: return;

Line 850: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');

846: END IF;
847:
848: ozf_utility_pvt.debug_message('OfferDiscountLineId is : '||p_offadj_tier_rec.offer_discount_line_id);
849: IF p_offadj_tier_rec.offer_discount_line_id IS NULL OR p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
850: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
851: x_return_status := FND_API.g_ret_sts_error;
852: return;
853: END IF;
854:

Line 859: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJST_TIER_ID' );

855: ELSE
856:
857:
858: IF p_offadj_tier_rec.offer_adjst_tier_id = FND_API.G_MISS_NUM THEN
859: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJST_TIER_ID' );
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862:
863:

Line 865: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );

861: END IF;
862:
863:
864: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
865: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
866: x_return_status := FND_API.g_ret_sts_error;
867: END IF;
868:
869: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM THEN

Line 870: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );

866: x_return_status := FND_API.g_ret_sts_error;
867: END IF;
868:
869: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM THEN
870: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );
871: x_return_status := FND_API.g_ret_sts_error;
872: END IF;
873:
874: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM THEN

Line 875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );

871: x_return_status := FND_API.g_ret_sts_error;
872: END IF;
873:
874: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM THEN
875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: IF p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
879: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFFER_DISCOUNT_LINE_ID');

Line 879: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFFER_DISCOUNT_LINE_ID');

875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: IF p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
879: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFFER_DISCOUNT_LINE_ID');
880: x_return_status := FND_API.g_ret_sts_error;
881: return;
882: END IF;
883:

Line 899: IF OZF_UTILITY_PVT.CHECK_FK_EXISTS('ozf_offer_discount_lines', 'offer_discount_line_id' , to_char(p_offadj_tier_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN

895: BEGIN
896: x_return_status := FND_API.g_ret_sts_success;
897:
898: IF p_offadj_tier_rec.offer_discount_line_id IS NOT NULL AND p_offadj_tier_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
899: IF OZF_UTILITY_PVT.CHECK_FK_EXISTS('ozf_offer_discount_lines', 'offer_discount_line_id' , to_char(p_offadj_tier_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
900: OZF_Utility_PVT.Error_Message('OZF_OFF_ADJ_TIER_INV_DISC');
901: x_return_status := FND_API.g_ret_sts_error;
902: return;
903: END IF;

Line 900: OZF_Utility_PVT.Error_Message('OZF_OFF_ADJ_TIER_INV_DISC');

896: x_return_status := FND_API.g_ret_sts_success;
897:
898: IF p_offadj_tier_rec.offer_discount_line_id IS NOT NULL AND p_offadj_tier_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
899: IF OZF_UTILITY_PVT.CHECK_FK_EXISTS('ozf_offer_discount_lines', 'offer_discount_line_id' , to_char(p_offadj_tier_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
900: OZF_Utility_PVT.Error_Message('OZF_OFF_ADJ_TIER_INV_DISC');
901: x_return_status := FND_API.g_ret_sts_error;
902: return;
903: END IF;
904: END IF;

Line 948: OZF_Utility_PVT.Error_Message('OZF_OFFADJ_DISC_DIFF');

944: (p_offadj_tier_rec.modified_discount > 0 AND p_offadj_tier_rec.original_discount < 0)
945: OR
946: (p_offadj_tier_rec.modified_discount < 0 AND p_offadj_tier_rec.original_discount > 0)
947: THEN
948: OZF_Utility_PVT.Error_Message('OZF_OFFADJ_DISC_DIFF');
949: x_return_status := FND_API.g_ret_sts_error;
950: return;
951: END IF;
952: END check_offadj_inter_attr;

Line 1226: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1222: END IF;
1223:
1224:
1225: -- Debug Message
1226: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1227:
1228:
1229:
1230: -- Initialize API return status to SUCCESS

Line 1235: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1231: x_return_status := FND_API.G_RET_STS_SUCCESS;
1232:
1233:
1234: -- Debug Message
1235: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1236:
1237:
1238: -- Standard call to get message count and if count is 1, get message info.
1239: FND_MSG_PUB.Count_And_Get

Line 1245: WHEN OZF_Utility_PVT.resource_locked THEN

1241: p_data => x_msg_data
1242: );
1243: EXCEPTION
1244:
1245: WHEN OZF_Utility_PVT.resource_locked THEN
1246: x_return_status := FND_API.g_ret_sts_error;
1247: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1248:
1249: WHEN FND_API.G_EXC_ERROR THEN

Line 1247: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1243: EXCEPTION
1244:
1245: WHEN OZF_Utility_PVT.resource_locked THEN
1246: x_return_status := FND_API.g_ret_sts_error;
1247: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1248:
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1251: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1312: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1308: -- THEN
1309: -- x_return_status := FND_API.G_RET_STS_ERROR;
1310:
1311: -- Debug Message
1312: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1313: -- Standard call to get message count and if count is 1, get message info.
1314: FND_MSG_PUB.Count_And_Get
1315: (p_count => x_msg_count,
1316: p_data => x_msg_data