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_FUNDTHRESHOLD_PVT dependencies on OZF_UTILITY_PVT

Line 75: OZF_UTILITY_PVT.debug_message('Check Date: start');

71:
72: BEGIN
73: x_return_status := fnd_api.g_ret_sts_success;
74: IF G_DEBUG THEN
75: OZF_UTILITY_PVT.debug_message('Check Date: start');
76: END IF;
77:
78: -- compare the start date and the end date
79: IF p_start_date > p_end_date THEN

Line 81: ozf_utility_pvt.error_message('OZF_STARTDATE_OUT_ENDDATE');

77:
78: -- compare the start date and the end date
79: IF p_start_date > p_end_date THEN
80: x_return_status := fnd_api.g_ret_sts_error;
81: ozf_utility_pvt.error_message('OZF_STARTDATE_OUT_ENDDATE');
82: RETURN;
83: END IF;
84:
85: -- compare start date and end date with threshold rule's start date and end date

Line 94: ozf_utility_pvt.error_message('OZF_TRSH_OUT_THRESHOLD_RULE');

90: --BEGIN
91: IF p_start_date > rule.start_date
92: OR p_end_date < rule.end_date THEN
93: x_return_status := fnd_api.g_ret_sts_error;
94: ozf_utility_pvt.error_message('OZF_TRSH_OUT_THRESHOLD_RULE');
95: RETURN;
96: END IF;
97: -- END;
98: END LOOP;

Line 108: ozf_utility_pvt.error_message('OZF_FUND_NO_CALENDAR');

104: AND p_end_period_name IS NULL THEN
105: RETURN;
106: ELSIF p_threshold_calendar IS NULL THEN
107: x_return_status := fnd_api.g_ret_sts_error;
108: ozf_utility_pvt.error_message('OZF_FUND_NO_CALENDAR');
109: RETURN;
110: END IF;
111:
112: -- check if p_threshold_calendar is valid

Line 119: ozf_utility_pvt.error_message('OZF_FUND_BAD_CALENDAR');

115: CLOSE c_threshold_calendar;
116:
117: IF l_local IS NULL THEN
118: x_return_status := fnd_api.g_ret_sts_error;
119: ozf_utility_pvt.error_message('OZF_FUND_BAD_CALENDAR');
120: RETURN;
121: END IF;
122:
123: -- check p_start_period_name

Line 131: ozf_utility_pvt.error_message('OZF_FUND_BAD_START_PERIOD');

127: CLOSE c_start_period;
128:
129: IF l_start_start IS NULL THEN
130: x_return_status := fnd_api.g_ret_sts_error;
131: ozf_utility_pvt.error_message('OZF_FUND_BAD_START_PERIOD');
132: RETURN;
133: ELSIF p_start_date < l_start_start
134: OR p_start_date > l_start_end THEN
135: x_return_status := fnd_api.g_ret_sts_error;

Line 136: ozf_utility_pvt.error_message('OZF_THRESHOLD_OUT_START_PERIOD');

132: RETURN;
133: ELSIF p_start_date < l_start_start
134: OR p_start_date > l_start_end THEN
135: x_return_status := fnd_api.g_ret_sts_error;
136: ozf_utility_pvt.error_message('OZF_THRESHOLD_OUT_START_PERIOD');
137: RETURN;
138: END IF;
139: END IF;
140:

Line 149: ozf_utility_pvt.error_message('OZF_FUND_BAD_END_PERIOD');

145: CLOSE c_end_period;
146:
147: IF l_end_end IS NULL THEN
148: x_return_status := fnd_api.g_ret_sts_error;
149: ozf_utility_pvt.error_message('OZF_FUND_BAD_END_PERIOD');
150: RETURN;
151: ELSIF p_end_date < l_end_start
152: OR p_end_date > l_end_end THEN
153: x_return_status := fnd_api.g_ret_sts_error;

Line 154: ozf_utility_pvt.error_message('OZF_THRESHOLD_OUT_END_PERIOD');

150: RETURN;
151: ELSIF p_end_date < l_end_start
152: OR p_end_date > l_end_end THEN
153: x_return_status := fnd_api.g_ret_sts_error;
154: ozf_utility_pvt.error_message('OZF_THRESHOLD_OUT_END_PERIOD');
155: RETURN;
156: END IF;
157: END IF;
158:

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

219: END IF;
220:
221: -- Debug Message
222: IF G_DEBUG THEN
223: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
224: END IF;
225:
226:
227: -- Initialize API return status to SUCCESS

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

278: -- =========================================================================
279:
280: IF FND_GLOBAL.User_Id IS NULL
281: THEN
282: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 290: OZF_UTILITY_PVT.debug_message('Private API: Validate_Threshold ');

286: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
287: THEN
288: -- Debug message
289: IF G_DEBUG THEN
290: OZF_UTILITY_PVT.debug_message('Private API: Validate_Threshold ');
291: END IF;
292:
293: -- Invoke validation procedures
294: Validate_threshold(

Line 311: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler ' || l_threshold_id );

307:
308:
309: -- Debug Message
310: IF G_DEBUG THEN
311: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler ' || l_threshold_id );
312: END IF;
313:
314: OZF_FUNDTHRESHOLDS_ALL_B_PKG.Insert_Row(
315: px_threshold_id => l_threshold_id,

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

371:
372: x_threshold_id := l_threshold_id;
373: -- Debug Message
374: IF G_DEBUG THEN
375: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end' || x_threshold_id);
376: END IF;
377:
378: -- Standard call to get message count and if count is 1, get message info.
379: FND_MSG_PUB.Count_And_Get

Line 385: WHEN OZF_Utility_PVT.resource_locked THEN

381: p_data => x_msg_data
382: );
383: EXCEPTION
384:
385: WHEN OZF_Utility_PVT.resource_locked THEN
386: x_return_status := FND_API.g_ret_sts_error;
387: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
388:
389: WHEN FND_API.G_EXC_ERROR THEN

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

383: EXCEPTION
384:
385: WHEN OZF_Utility_PVT.resource_locked THEN
386: x_return_status := FND_API.g_ret_sts_error;
387: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
388:
389: WHEN FND_API.G_EXC_ERROR THEN
390: ROLLBACK TO CREATE_Threshold_PVT;
391: x_return_status := FND_API.G_RET_STS_ERROR;

Line 479: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start' || p_threshold_rec.THRESHOLD_ID);

475: END IF;
476:
477: -- Debug Message
478: IF G_DEBUG THEN
479: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start' || p_threshold_rec.THRESHOLD_ID);
480: END IF;
481:
482:
483: -- Initialize API return status to SUCCESS

Line 488: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select '|| p_threshold_rec.THRESHOLD_ID);

484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486: -- Debug Message
487: IF G_DEBUG THEN
488: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select '|| p_threshold_rec.THRESHOLD_ID);
489: END IF;
490:
491:
492: OPEN c_get_Threshold( l_tar_threshold_rec.threshold_id);

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

493:
494: FETCH c_get_Threshold INTO l_ref_threshold_rec ;
495:
496: If ( c_get_Threshold%NOTFOUND) THEN
497: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
498: p_token_name => 'INFO',
499: p_token_value => 'Threshold') ;
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;

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

500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
502: -- Debug Message
503: IF G_DEBUG THEN
504: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
505: END IF;
506: CLOSE c_get_Threshold;
507:
508:

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

507:
508:
509: If (l_tar_threshold_rec.object_version_number is NULL or
510: l_tar_threshold_rec.object_version_number = FND_API.G_MISS_NUM ) Then
511: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
512: p_token_name => 'COLUMN',
513: p_token_value => 'Last_Update_Date') ;
514: raise FND_API.G_EXC_ERROR;
515: End if;

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

514: raise FND_API.G_EXC_ERROR;
515: End if;
516: -- Check Whether record has been changed by someone else
517: If (l_tar_threshold_rec.object_version_number <> l_ref_threshold_rec.object_version_number) Then
518: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
519: p_token_name => 'INFO',
520: p_token_value => 'Threshold') ;
521: raise FND_API.G_EXC_ERROR;
522: End if;

Line 578: OZF_UTILITY_PVT.debug_message('Private API: Calling update table handler');

574:
575:
576: -- Debug Message
577: IF G_DEBUG THEN
578: OZF_UTILITY_PVT.debug_message('Private API: Calling update table handler');
579: END IF;
580:
581: -- Invoke table handler(OZF_THRESHOLDS_ALL_B_PKG.Update_Row)
582: OZF_FUNDTHRESHOLDS_ALL_B_PKG.Update_Row(

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

634: x_object_version_number := l_object_version_number;
635:
636: -- Debug Message
637: IF G_DEBUG THEN
638: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
639: END IF;
640:
641: -- Standard call to get message count and if count is 1, get message info.
642: FND_MSG_PUB.Count_And_Get

Line 648: WHEN OZF_Utility_PVT.resource_locked THEN

644: p_data => x_msg_data
645: );
646: EXCEPTION
647:
648: WHEN OZF_Utility_PVT.resource_locked THEN
649: x_return_status := FND_API.g_ret_sts_error;
650: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
651:
652: WHEN FND_API.G_EXC_ERROR THEN

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

646: EXCEPTION
647:
648: WHEN OZF_Utility_PVT.resource_locked THEN
649: x_return_status := FND_API.g_ret_sts_error;
650: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
651:
652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO UPDATE_Threshold_PVT;
654: x_return_status := FND_API.G_RET_STS_ERROR;

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

722: END IF;
723:
724: -- Debug Message
725: IF G_DEBUG THEN
726: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
727: END IF;
728:
729:
730: -- Initialize API return status to SUCCESS

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

734: -- Api body
735: --
736: -- Debug Message
737: IF G_DEBUG THEN
738: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
739: END IF;
740:
741: -- Invoke table handler(OZF_THRESHOLDS_ALL_B_PKG.Delete_Row)
742: OZF_FUNDTHRESHOLDS_ALL_B_PKG.Delete_Row(

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

753:
754:
755: -- Debug Message
756: IF G_DEBUG THEN
757: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
758: END IF;
759:
760: -- Standard call to get message count and if count is 1, get message info.
761: FND_MSG_PUB.Count_And_Get

Line 767: WHEN OZF_Utility_PVT.resource_locked THEN

763: p_data => x_msg_data
764: );
765: EXCEPTION
766:
767: WHEN OZF_Utility_PVT.resource_locked THEN
768: x_return_status := FND_API.g_ret_sts_error;
769: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
770:
771: WHEN FND_API.G_EXC_ERROR THEN

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

765: EXCEPTION
766:
767: WHEN OZF_Utility_PVT.resource_locked THEN
768: x_return_status := FND_API.g_ret_sts_error;
769: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
770:
771: WHEN FND_API.G_EXC_ERROR THEN
772: ROLLBACK TO DELETE_Threshold_PVT;
773: x_return_status := FND_API.G_RET_STS_ERROR;

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

834: BEGIN
835:
836: -- Debug Message
837: IF G_DEBUG THEN
838: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
839: END IF;
840:
841: -- Initialize message list if p_init_msg_list is set to TRUE.
842: IF FND_API.to_Boolean( p_init_msg_list )

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

860:
861: ------------------------ lock -------------------------
862:
863: IF G_DEBUG THEN
864: OZF_Utility_PVT.debug_message(l_full_name||': start');
865: END IF;
866: OPEN c_Threshold;
867:
868: FETCH c_Threshold INTO l_THRESHOLD_ID;

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

883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data);
886: IF G_DEBUG THEN
887: OZF_Utility_PVT.debug_message(l_full_name ||': end');
888: END IF;
889: EXCEPTION
890:
891: WHEN OZF_Utility_PVT.resource_locked THEN

Line 891: WHEN OZF_Utility_PVT.resource_locked THEN

887: OZF_Utility_PVT.debug_message(l_full_name ||': end');
888: END IF;
889: EXCEPTION
890:
891: WHEN OZF_Utility_PVT.resource_locked THEN
892: x_return_status := FND_API.g_ret_sts_error;
893: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
894:
895: WHEN FND_API.G_EXC_ERROR THEN

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

889: EXCEPTION
890:
891: WHEN OZF_Utility_PVT.resource_locked THEN
892: x_return_status := FND_API.g_ret_sts_error;
893: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
894:
895: WHEN FND_API.G_EXC_ERROR THEN
896: ROLLBACK TO LOCK_Threshold_PVT;
897: x_return_status := FND_API.G_RET_STS_ERROR;

Line 941: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

937:
938: BEGIN
939: x_return_status := FND_API.g_ret_sts_success;
940: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
941: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
942: 'OZF_THRESHOLDS_ALL_B',
943: 'THRESHOLD_ID = ''' || p_threshold_rec.THRESHOLD_ID ||''''
944: );
945: ELSE

Line 946: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

942: 'OZF_THRESHOLDS_ALL_B',
943: 'THRESHOLD_ID = ''' || p_threshold_rec.THRESHOLD_ID ||''''
944: );
945: ELSE
946: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
947: 'OZF_THRESHOLDS_ALL_B',
948: 'THRESHOLD_ID = ''' || p_threshold_rec.THRESHOLD_ID ||
949: ''' AND THRESHOLD_ID <> ' || p_threshold_rec.THRESHOLD_ID
950: );

Line 954: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_THRESHOLD_ID_DUPLICATE');

950: );
951: END IF;
952:
953: IF l_valid_flag = FND_API.g_false THEN
954: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_THRESHOLD_ID_DUPLICATE');
955: x_return_status := FND_API.g_ret_sts_error;
956: RETURN;
957: END IF;
958:

Line 974: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_threshold_id');

970: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
971:
972:
973: IF p_threshold_rec.threshold_id = FND_API.g_miss_num OR p_threshold_rec.threshold_id IS NULL THEN
974: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_threshold_id');
975: x_return_status := FND_API.g_ret_sts_error;
976: RETURN;
977: END IF;
978:

Line 981: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_last_upd_date');

977: END IF;
978:
979:
980: IF p_threshold_rec.last_update_date = FND_API.g_miss_date OR p_threshold_rec.last_update_date IS NULL THEN
981: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_last_upd_date');
982: x_return_status := FND_API.g_ret_sts_error;
983: RETURN;
984: END IF;
985:

Line 988: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_last_upd_by');

984: END IF;
985:
986:
987: IF p_threshold_rec.last_updated_by = FND_API.g_miss_num OR p_threshold_rec.last_updated_by IS NULL THEN
988: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_last_upd_by');
989: x_return_status := FND_API.g_ret_sts_error;
990: RETURN;
991: END IF;
992:

Line 995: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_creation_date');

991: END IF;
992:
993:
994: IF p_threshold_rec.creation_date = FND_API.g_miss_date OR p_threshold_rec.creation_date IS NULL THEN
995: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_creation_date');
996: x_return_status := FND_API.g_ret_sts_error;
997: RETURN;
998: END IF;
999:

Line 1002: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_created_by');

998: END IF;
999:
1000:
1001: IF p_threshold_rec.created_by = FND_API.g_miss_num OR p_threshold_rec.created_by IS NULL THEN
1002: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_created_by');
1003: x_return_status := FND_API.g_ret_sts_error;
1004: RETURN;
1005: END IF;
1006:

Line 1009: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_owner');

1005: END IF;
1006:
1007:
1008: IF p_threshold_rec.owner = FND_API.g_miss_num OR p_threshold_rec.owner IS NULL THEN
1009: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_owner');
1010: x_return_status := FND_API.g_ret_sts_error;
1011: RETURN;
1012: END IF;
1013: ELSE

Line 1017: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_threshold_id');

1013: ELSE
1014:
1015:
1016: IF p_threshold_rec.threshold_id IS NULL THEN
1017: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_threshold_id');
1018: x_return_status := FND_API.g_ret_sts_error;
1019: RETURN;
1020: END IF;
1021:

Line 1024: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_last_upd_date');

1020: END IF;
1021:
1022:
1023: IF p_threshold_rec.last_update_date IS NULL THEN
1024: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_last_upd_date');
1025: x_return_status := FND_API.g_ret_sts_error;
1026: RETURN;
1027: END IF;
1028:

Line 1031: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_last_upd_by');

1027: END IF;
1028:
1029:
1030: IF p_threshold_rec.last_updated_by IS NULL THEN
1031: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_last_upd_by');
1032: x_return_status := FND_API.g_ret_sts_error;
1033: RETURN;
1034: END IF;
1035:

Line 1038: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_creation_date');

1034: END IF;
1035:
1036:
1037: IF p_threshold_rec.creation_date IS NULL THEN
1038: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_creation_date');
1039: x_return_status := FND_API.g_ret_sts_error;
1040: RETURN;
1041: END IF;
1042:

Line 1045: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_created_by');

1041: END IF;
1042:
1043:
1044: IF p_threshold_rec.created_by IS NULL THEN
1045: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_created_by');
1046: x_return_status := FND_API.g_ret_sts_error;
1047: RETURN;
1048: END IF;
1049:

Line 1052: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_owner');

1048: END IF;
1049:
1050:
1051: IF p_threshold_rec.owner IS NULL THEN
1052: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_NO_owner');
1053: x_return_status := FND_API.g_ret_sts_error;
1054: RETURN;
1055:
1056: END IF;

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

1522:
1523:
1524: -- Debug Message
1525: IF G_DEBUG THEN
1526: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1527: END IF;
1528:
1529:
1530: -- Initialize API return status to SUCCESS

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

1532:
1533:
1534: -- Debug Message
1535: IF G_DEBUG THEN
1536: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1537: END IF;
1538:
1539: -- Standard call to get message count and if count is 1, get message info.
1540: FND_MSG_PUB.Count_And_Get

Line 1546: WHEN OZF_Utility_PVT.resource_locked THEN

1542: p_data => x_msg_data
1543: );
1544: EXCEPTION
1545:
1546: WHEN OZF_Utility_PVT.resource_locked THEN
1547: x_return_status := FND_API.g_ret_sts_error;
1548: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1549:
1550: WHEN FND_API.G_EXC_ERROR THEN

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

1544: EXCEPTION
1545:
1546: WHEN OZF_Utility_PVT.resource_locked THEN
1547: x_return_status := FND_API.g_ret_sts_error;
1548: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1549:
1550: WHEN FND_API.G_EXC_ERROR THEN
1551: ROLLBACK TO VALIDATE_Threshold_;
1552: x_return_status := FND_API.G_RET_STS_ERROR;

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

1625:
1626:
1627: -- Debug Message
1628: IF G_DEBUG THEN
1629: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1630: END IF;
1631: -- Standard call to get message count and if count is 1, get message info.
1632: FND_MSG_PUB.Count_And_Get
1633: (p_count => x_msg_count,