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

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

92: x_return_status := fnd_api.g_ret_sts_success;
93: -- compare the start date and the end date
94: IF p_start_date > p_end_date THEN
95: x_return_status := fnd_api.g_ret_sts_error;
96: ozf_utility_pvt.error_message('OZF_STARTDATE_OUT_ENDDATE');
97: RETURN;
98: END IF;
99:
100: --compare the start date and the end date of both threshold and threshold_rule

Line 109: ozf_utility_pvt.error_message('OZF_TRSH_RULE_OUT_THRESHOLD');

105:
106: IF p_start_date < l_threshold_start_date
107: OR p_end_date > l_threshold_end_date THEN
108: x_return_status := fnd_api.g_ret_sts_error;
109: ozf_utility_pvt.error_message('OZF_TRSH_RULE_OUT_THRESHOLD');
110: RETURN;
111: END IF;
112:
113: END IF;

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

174: END IF;
175:
176: -- Debug Message
177: IF G_DEBUG THEN
178: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
179: END IF;
180:
181:
182: -- Initialize API return status to SUCCESS

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

232: -- =========================================================================
233:
234: IF FND_GLOBAL.User_Id IS NULL
235: THEN
236: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239:
240: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 244: OZF_UTILITY_PVT.debug_message('Private API: Validate_Threshold_Rule');

240: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
241: THEN
242: -- Debug message
243: IF G_DEBUG THEN
244: OZF_UTILITY_PVT.debug_message('Private API: Validate_Threshold_Rule');
245: END IF;
246:
247: -- Invoke validation procedures
248: Validate_threshold_rule(

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

277: END IF;
278:
279: -- Debug Message
280: IF G_DEBUG THEN
281: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
282: END IF;
283:
284: -- Invoke table handler(OZF_THRESHOLD_RULES_PKG.Insert_Row)
285: OZF_THRESHOLD_RULES_PKG.Insert_Row(

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

348: x_threshold_rule_id := l_threshold_rule_id;
349:
350: -- Debug Message
351: IF G_DEBUG THEN
352: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
353: END IF;
354:
355: -- Standard call to get message count and if count is 1, get message info.
356: FND_MSG_PUB.Count_And_Get

Line 362: WHEN OZF_Utility_PVT.resource_locked THEN

358: p_data => x_msg_data
359: );
360: EXCEPTION
361:
362: WHEN OZF_Utility_PVT.resource_locked THEN
363: x_return_status := FND_API.g_ret_sts_error;
364: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
365:
366: WHEN FND_API.G_EXC_ERROR THEN

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

360: EXCEPTION
361:
362: WHEN OZF_Utility_PVT.resource_locked THEN
363: x_return_status := FND_API.g_ret_sts_error;
364: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
365:
366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO CREATE_Threshold_Rule_PVT;
368: x_return_status := FND_API.G_RET_STS_ERROR;

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

454: END IF;
455:
456: -- Debug Message
457: IF G_DEBUG THEN
458: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
459: END IF;
460:
461:
462: -- Initialize API return status to SUCCESS

Line 467: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select ' || l_tar_threshold_rule_rec.threshold_rule_id);

463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: -- Debug Message
466: IF G_DEBUG THEN
467: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select ' || l_tar_threshold_rule_rec.threshold_rule_id);
468: END IF;
469:
470:
471: OPEN c_get_Threshold_Rule( l_tar_threshold_rule_rec.threshold_rule_id);

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

472:
473: FETCH c_get_Threshold_Rule INTO l_ref_threshold_rule_rec ;
474:
475: If ( c_get_Threshold_Rule%NOTFOUND) THEN
476: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
477: p_token_name => 'INFO',
478: p_token_value => 'Threshold_Rule') ;
479: RAISE FND_API.G_EXC_ERROR;
480: END IF;

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

479: RAISE FND_API.G_EXC_ERROR;
480: END IF;
481: -- Debug Message
482: IF G_DEBUG THEN
483: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
484: END IF;
485: CLOSE c_get_Threshold_Rule;
486:
487:

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

486:
487:
488: If (l_tar_threshold_rule_rec.object_version_number is NULL or
489: l_tar_threshold_rule_rec.object_version_number = FND_API.G_MISS_NUM ) Then
490: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
491: p_token_name => 'COLUMN',
492: p_token_value => 'Last_Update_Date') ;
493: raise FND_API.G_EXC_ERROR;
494: End if;

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

493: raise FND_API.G_EXC_ERROR;
494: End if;
495: -- Check Whether record has been changed by someone else
496: If (l_tar_threshold_rule_rec.object_version_number <> l_ref_threshold_rule_rec.object_version_number) Then
497: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
498: p_token_name => 'INFO',
499: p_token_value => 'Threshold_Rule') ;
500: raise FND_API.G_EXC_ERROR;
501: End if;

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

556: END IF;
557:
558: -- Debug Message
559: IF G_DEBUG THEN
560: OZF_UTILITY_PVT.debug_message('Private API: Calling update table handler');
561: END IF;
562:
563: -- Invoke table handler(OZF_THRESHOLD_RULES_PKG.Update_Row)
564: OZF_THRESHOLD_RULES_PKG.Update_Row(

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

622: x_object_version_number := l_object_version_number;
623:
624: -- Debug Message
625: IF G_DEBUG THEN
626: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
627: END IF;
628:
629: -- Standard call to get message count and if count is 1, get message info.
630: FND_MSG_PUB.Count_And_Get

Line 636: WHEN OZF_Utility_PVT.resource_locked THEN

632: p_data => x_msg_data
633: );
634: EXCEPTION
635:
636: WHEN OZF_Utility_PVT.resource_locked THEN
637: x_return_status := FND_API.g_ret_sts_error;
638: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
639:
640: WHEN FND_API.G_EXC_ERROR THEN

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

634: EXCEPTION
635:
636: WHEN OZF_Utility_PVT.resource_locked THEN
637: x_return_status := FND_API.g_ret_sts_error;
638: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
639:
640: WHEN FND_API.G_EXC_ERROR THEN
641: ROLLBACK TO UPDATE_Threshold_Rule_PVT;
642: x_return_status := FND_API.G_RET_STS_ERROR;

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

710: END IF;
711:
712: -- Debug Message
713: IF G_DEBUG THEN
714: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
715: END IF;
716:
717:
718: -- Initialize API return status to SUCCESS

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

722: -- Api body
723: --
724: -- Debug Message
725: IF G_DEBUG THEN
726: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
727: END IF;
728:
729: -- Invoke table handler(OZF_THRESHOLD_RULES_PKG.Delete_Row)
730: OZF_THRESHOLD_RULES_PKG.Delete_Row(

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

741:
742:
743: -- Debug Message
744: IF G_DEBUG THEN
745: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
746: END IF;
747:
748: -- Standard call to get message count and if count is 1, get message info.
749: FND_MSG_PUB.Count_And_Get

Line 755: WHEN OZF_Utility_PVT.resource_locked THEN

751: p_data => x_msg_data
752: );
753: EXCEPTION
754:
755: WHEN OZF_Utility_PVT.resource_locked THEN
756: x_return_status := FND_API.g_ret_sts_error;
757: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
758:
759: WHEN FND_API.G_EXC_ERROR THEN

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

753: EXCEPTION
754:
755: WHEN OZF_Utility_PVT.resource_locked THEN
756: x_return_status := FND_API.g_ret_sts_error;
757: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
758:
759: WHEN FND_API.G_EXC_ERROR THEN
760: ROLLBACK TO DELETE_Threshold_Rule_PVT;
761: x_return_status := FND_API.G_RET_STS_ERROR;

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

822: BEGIN
823:
824: -- Debug Message
825: IF G_DEBUG THEN
826: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
827: END IF;
828:
829: -- Initialize message list if p_init_msg_list is set to TRUE.
830: IF FND_API.to_Boolean( p_init_msg_list )

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

848:
849: ------------------------ lock -------------------------
850:
851: IF G_DEBUG THEN
852: OZF_Utility_PVT.debug_message(l_full_name||': start');
853: END IF;
854: OPEN c_Threshold_Rule;
855:
856: FETCH c_Threshold_Rule INTO l_THRESHOLD_RULE_ID;

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

871: p_encoded => FND_API.g_false,
872: p_count => x_msg_count,
873: p_data => x_msg_data);
874: IF G_DEBUG THEN
875: OZF_Utility_PVT.debug_message(l_full_name ||': end');
876: END IF;
877: EXCEPTION
878:
879: WHEN OZF_Utility_PVT.resource_locked THEN

Line 879: WHEN OZF_Utility_PVT.resource_locked THEN

875: OZF_Utility_PVT.debug_message(l_full_name ||': end');
876: END IF;
877: EXCEPTION
878:
879: WHEN OZF_Utility_PVT.resource_locked THEN
880: x_return_status := FND_API.g_ret_sts_error;
881: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
882:
883: WHEN FND_API.G_EXC_ERROR THEN

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

877: EXCEPTION
878:
879: WHEN OZF_Utility_PVT.resource_locked THEN
880: x_return_status := FND_API.g_ret_sts_error;
881: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
882:
883: WHEN FND_API.G_EXC_ERROR THEN
884: ROLLBACK TO LOCK_Threshold_Rule_PVT;
885: x_return_status := FND_API.G_RET_STS_ERROR;

Line 929: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

925:
926: BEGIN
927: x_return_status := FND_API.g_ret_sts_success;
928: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
929: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
930: 'OZF_THRESHOLD_RULES_ALL',
931: 'THRESHOLD_RULE_ID = ''' || p_threshold_rule_rec.THRESHOLD_RULE_ID ||''''
932: );
933: ELSE

Line 934: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

930: 'OZF_THRESHOLD_RULES_ALL',
931: 'THRESHOLD_RULE_ID = ''' || p_threshold_rule_rec.THRESHOLD_RULE_ID ||''''
932: );
933: ELSE
934: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
935: 'OZF_THRESHOLD_RULES_ALL',
936: 'THRESHOLD_RULE_ID = ''' || p_threshold_rule_rec.THRESHOLD_RULE_ID ||
937: ''' AND THRESHOLD_RULE_ID <> ' || p_threshold_rule_rec.THRESHOLD_RULE_ID
938: );

Line 942: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_THRESHD_RULE_ID_DUPLICATE');

938: );
939: END IF;
940:
941: IF l_valid_flag = FND_API.g_false THEN
942: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_THRESHD_RULE_ID_DUPLICATE');
943: x_return_status := FND_API.g_ret_sts_error;
944: RETURN;
945: END IF;
946:

Line 1114: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_threshold_rule_id');

1110: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1111:
1112:
1113: IF p_threshold_rule_rec.threshold_rule_id = FND_API.g_miss_num OR p_threshold_rule_rec.threshold_rule_id IS NULL THEN
1114: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_threshold_rule_id');
1115: x_return_status := FND_API.g_ret_sts_error;
1116: RETURN;
1117: END IF;
1118:

Line 1121: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_last_update_date');

1117: END IF;
1118:
1119:
1120: IF p_threshold_rule_rec.last_update_date = FND_API.g_miss_date OR p_threshold_rule_rec.last_update_date IS NULL THEN
1121: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_last_update_date');
1122: x_return_status := FND_API.g_ret_sts_error;
1123: RETURN;
1124: END IF;
1125:

Line 1128: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_last_updated_by');

1124: END IF;
1125:
1126:
1127: IF p_threshold_rule_rec.last_updated_by = FND_API.g_miss_num OR p_threshold_rule_rec.last_updated_by IS NULL THEN
1128: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_last_updated_by');
1129: x_return_status := FND_API.g_ret_sts_error;
1130: RETURN;
1131: END IF;
1132:

Line 1135: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_creation_date');

1131: END IF;
1132:
1133:
1134: IF p_threshold_rule_rec.creation_date = FND_API.g_miss_date OR p_threshold_rule_rec.creation_date IS NULL THEN
1135: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_creation_date');
1136: x_return_status := FND_API.g_ret_sts_error;
1137: RETURN;
1138: END IF;
1139:

Line 1142: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_created_by');

1138: END IF;
1139:
1140:
1141: IF p_threshold_rule_rec.created_by = FND_API.g_miss_num OR p_threshold_rule_rec.created_by IS NULL THEN
1142: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_created_by');
1143: x_return_status := FND_API.g_ret_sts_error;
1144: RETURN;
1145: END IF;
1146:

Line 1149: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_threshold_id');

1145: END IF;
1146:
1147:
1148: IF p_threshold_rule_rec.threshold_id = FND_API.g_miss_num OR p_threshold_rule_rec.threshold_id IS NULL THEN
1149: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_threshold_id');
1150: x_return_status := FND_API.g_ret_sts_error;
1151: RETURN;
1152: END IF;
1153: ELSE

Line 1157: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_threshold_rule_id');

1153: ELSE
1154:
1155:
1156: IF p_threshold_rule_rec.threshold_rule_id IS NULL THEN
1157: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_threshold_rule_id');
1158: x_return_status := FND_API.g_ret_sts_error;
1159: RETURN;
1160: END IF;
1161:

Line 1164: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_last_update_date');

1160: END IF;
1161:
1162:
1163: IF p_threshold_rule_rec.last_update_date IS NULL THEN
1164: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_last_update_date');
1165: x_return_status := FND_API.g_ret_sts_error;
1166: RETURN;
1167: END IF;
1168:

Line 1171: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_last_updated_by');

1167: END IF;
1168:
1169:
1170: IF p_threshold_rule_rec.last_updated_by IS NULL THEN
1171: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_last_updated_by');
1172: x_return_status := FND_API.g_ret_sts_error;
1173: RETURN;
1174: END IF;
1175:

Line 1178: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_creation_date');

1174: END IF;
1175:
1176:
1177: IF p_threshold_rule_rec.creation_date IS NULL THEN
1178: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_creation_date');
1179: x_return_status := FND_API.g_ret_sts_error;
1180: RETURN;
1181: END IF;
1182:

Line 1185: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_created_by');

1181: END IF;
1182:
1183:
1184: IF p_threshold_rule_rec.created_by IS NULL THEN
1185: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_created_by');
1186: x_return_status := FND_API.g_ret_sts_error;
1187: RETURN;
1188: END IF;
1189:

Line 1192: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_threshold_id');

1188: END IF;
1189:
1190:
1191: IF p_threshold_rule_rec.threshold_id IS NULL THEN
1192: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_threshold_rule_NO_threshold_id');
1193: x_return_status := FND_API.g_ret_sts_error;
1194: RETURN;
1195: END IF;
1196: END IF;

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

1743: END IF;
1744:
1745: -- Debug Message
1746: IF G_DEBUG THEN
1747: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1748: END IF;
1749:
1750: -- Standard call to get message count and if count is 1, get message info.
1751: FND_MSG_PUB.Count_And_Get

Line 1757: WHEN OZF_Utility_PVT.resource_locked THEN

1753: p_data => x_msg_data
1754: );
1755: EXCEPTION
1756:
1757: WHEN OZF_Utility_PVT.resource_locked THEN
1758: x_return_status := FND_API.g_ret_sts_error;
1759: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1760:
1761: WHEN FND_API.G_EXC_ERROR THEN

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

1755: EXCEPTION
1756:
1757: WHEN OZF_Utility_PVT.resource_locked THEN
1758: x_return_status := FND_API.g_ret_sts_error;
1759: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1760:
1761: WHEN FND_API.G_EXC_ERROR THEN
1762: ROLLBACK TO VALIDATE_Threshold_Rule_;
1763: x_return_status := FND_API.G_RET_STS_ERROR;

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

1837:
1838:
1839: -- Debug Message
1840: IF G_DEBUG THEN
1841: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1842: END IF;
1843: -- Standard call to get message count and if count is 1, get message info.
1844: FND_MSG_PUB.Count_And_Get
1845: (p_count => x_msg_count,