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

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

138:
139:
140:
141: -- Debug Message
142: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
143:
144:
145:
146: -- Initialize API return status to SUCCESS

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

151: -- =========================================================================
152:
153: IF FND_GLOBAL.USER_ID IS NULL
154: THEN
155: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;
158:
159:

Line 185: OZF_UTILITY_PVT.debug_message('Private API: Validate_Na_Rule_Header');

181:
182: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
183: THEN
184: -- Debug message
185: OZF_UTILITY_PVT.debug_message('Private API: Validate_Na_Rule_Header');
186:
187: -- Invoke validation procedures
188: Validate_na_rule_header(
189: p_api_version_number => 1.0,

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

201: END IF;
202:
203:
204: -- Debug Message
205: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
206:
207: -- Invoke table handler(Ozf_Na_Rule_Header_Pkg.Insert_Row)
208: Ozf_Na_Rule_Header_Pkg.Insert_Row(
209: px_na_rule_header_id => l_na_rule_header_id,

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

236: END IF;
237:
238:
239: -- Debug Message
240: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
241:
242:
243: -- Standard call to get message count and if count is 1, get message info.
244: FND_MSG_PUB.Count_And_Get

Line 250: WHEN OZF_Utility_PVT.resource_locked THEN

246: p_data => x_msg_data
247: );
248: EXCEPTION
249:
250: WHEN OZF_Utility_PVT.resource_locked THEN
251: x_return_status := FND_API.g_ret_sts_error;
252: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
253:
254: WHEN FND_API.G_EXC_ERROR THEN

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

248: EXCEPTION
249:
250: WHEN OZF_Utility_PVT.resource_locked THEN
251: x_return_status := FND_API.g_ret_sts_error;
252: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
253:
254: WHEN FND_API.G_EXC_ERROR THEN
255: ROLLBACK TO CREATE_Na_Rule_Header_PVT;
256: x_return_status := FND_API.G_RET_STS_ERROR;

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

374:
375:
376:
377: -- Debug Message
378: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
379:
380:
381:
382: -- Initialize API return status to SUCCESS

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

382: -- Initialize API return status to SUCCESS
383: x_return_status := FND_API.G_RET_STS_SUCCESS;
384:
385: -- Debug Message
386: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
387:
388: OPEN c_get_Na_Rule_Header( l_tar_na_rule_header_rec.na_rule_header_id);
389:
390: FETCH c_get_Na_Rule_Header INTO l_ref_na_rule_header_rec ;

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

389:
390: FETCH c_get_Na_Rule_Header INTO l_ref_na_rule_header_rec ;
391:
392: If ( c_get_Na_Rule_Header%NOTFOUND) THEN
393: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
394: p_token_name => 'INFO',
395: p_token_value => 'Na_Rule_Header') ;
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;

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

395: p_token_value => 'Na_Rule_Header') ;
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398: -- Debug Message
399: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
400: CLOSE c_get_Na_Rule_Header;
401:
402:
403: If (l_tar_na_rule_header_rec.object_version_number is NULL or

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

401:
402:
403: If (l_tar_na_rule_header_rec.object_version_number is NULL or
404: l_tar_na_rule_header_rec.object_version_number = FND_API.G_MISS_NUM ) Then
405: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
406: p_token_name => 'COLUMN',
407: p_token_value => 'Last_Update_Date') ;
408: raise FND_API.G_EXC_ERROR;
409: End if;

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

408: raise FND_API.G_EXC_ERROR;
409: End if;
410: -- Check Whether record has been changed by someone else
411: If (l_tar_na_rule_header_rec.object_version_number <> l_ref_na_rule_header_rec.object_version_number) Then
412: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
413: p_token_name => 'INFO',
414: p_token_value => 'Na_Rule_Header') ;
415: raise FND_API.G_EXC_ERROR;
416: End if;

Line 422: OZF_UTILITY_PVT.debug_message('Private API: Validate_Na_Rule_Header');

418:
419: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
420: THEN
421: -- Debug message
422: OZF_UTILITY_PVT.debug_message('Private API: Validate_Na_Rule_Header');
423:
424: -- Invoke validation procedures
425: Validate_na_rule_header(
426: p_api_version_number => 1.0,

Line 442: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

438: END IF;
439:
440:
441: -- Debug Message
442: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
443:
444: -- Invoke table handler(Ozf_Na_Rule_Header_Pkg.Update_Row)
445: Ozf_Na_Rule_Header_Pkg.Update_Row(
446: p_na_rule_header_id => p_na_rule_header_rec.na_rule_header_id,

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

466: END IF;
467:
468:
469: -- Debug Message
470: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
471:
472:
473: -- Standard call to get message count and if count is 1, get message info.
474: FND_MSG_PUB.Count_And_Get

Line 480: WHEN OZF_Utility_PVT.resource_locked THEN

476: p_data => x_msg_data
477: );
478: EXCEPTION
479:
480: WHEN OZF_Utility_PVT.resource_locked THEN
481: x_return_status := FND_API.g_ret_sts_error;
482: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
483:
484: WHEN FND_API.G_EXC_ERROR THEN

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

478: EXCEPTION
479:
480: WHEN OZF_Utility_PVT.resource_locked THEN
481: x_return_status := FND_API.g_ret_sts_error;
482: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
483:
484: WHEN FND_API.G_EXC_ERROR THEN
485: ROLLBACK TO UPDATE_Na_Rule_Header_PVT;
486: x_return_status := FND_API.G_RET_STS_ERROR;

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

590:
591:
592:
593: -- Debug Message
594: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
595:
596:
597:
598: -- Initialize API return status to SUCCESS

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

601: --
602: -- Api body
603: --
604: -- Debug Message
605: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
606:
607: -- Invoke table handler(Ozf_Na_Rule_Header_Pkg.Delete_Row)
608: Ozf_Na_Rule_Header_Pkg.Delete_Row(
609: p_na_rule_header_id => p_na_rule_header_id,

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

619: END IF;
620:
621:
622: -- Debug Message
623: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
624:
625:
626: -- Standard call to get message count and if count is 1, get message info.
627: FND_MSG_PUB.Count_And_Get

Line 633: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

631: EXCEPTION
632:
633: WHEN OZF_Utility_PVT.resource_locked THEN
634: x_return_status := FND_API.g_ret_sts_error;
635: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
636:
637: WHEN FND_API.G_EXC_ERROR THEN
638: ROLLBACK TO DELETE_Na_Rule_Header_PVT;
639: x_return_status := FND_API.G_RET_STS_ERROR;

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

725:
726: BEGIN
727:
728: -- Debug Message
729: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
730:
731:
732: -- Initialize message list if p_init_msg_list is set to TRUE.
733: IF FND_API.to_Boolean( p_init_msg_list )

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

760: FND_MSG_PUB.count_and_get(
761: p_encoded => FND_API.g_false,
762: p_count => x_msg_count,
763: p_data => x_msg_data);
764: OZF_Utility_PVT.debug_message(l_full_name ||': end');
765: EXCEPTION
766:
767: WHEN OZF_Utility_PVT.resource_locked THEN
768: x_return_status := FND_API.g_ret_sts_error;

Line 767: WHEN OZF_Utility_PVT.resource_locked THEN

763: p_data => x_msg_data);
764: OZF_Utility_PVT.debug_message(l_full_name ||': end');
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 LOCK_Na_Rule_Header_PVT;
773: x_return_status := FND_API.G_RET_STS_ERROR;

Line 821: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

817: x_return_status := FND_API.g_ret_sts_success;
818: IF p_validation_mode = JTF_PLSQL_API.g_create
819: AND p_na_rule_header_rec.na_rule_header_id IS NOT NULL
820: THEN
821: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
822: 'ozf_na_rule_headers_b',
823: 'na_rule_header_id = ''' || p_na_rule_header_rec.na_rule_header_id ||''''
824: );
825: END IF;

Line 828: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_na_rule_header_id_DUPLICATE');

824: );
825: END IF;
826:
827: IF l_valid_flag = FND_API.g_false THEN
828: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_na_rule_header_id_DUPLICATE');
829: x_return_status := FND_API.g_ret_sts_error;
830: END IF;
831:
832: END check_Na_Rule_Hdr_Uk_Items;

Line 849: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_RULE_HEADER_ID' );

845: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
846:
847:
848: IF p_na_rule_header_rec.na_rule_header_id = FND_API.G_MISS_NUM OR p_na_rule_header_rec.na_rule_header_id IS NULL THEN
849: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_RULE_HEADER_ID' );
850: x_return_status := FND_API.g_ret_sts_error;
851: END IF;
852:
853:

Line 855: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_STATUS_ID' );

851: END IF;
852:
853:
854: /* IF p_na_rule_header_rec.user_status_id = FND_API.G_MISS_NUM OR p_na_rule_header_rec.user_status_id IS NULL THEN
855: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_STATUS_ID' );
856: x_return_status := FND_API.g_ret_sts_error;
857: END IF;
858:
859:

Line 861: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );

857: END IF;
858:
859:
860: IF p_na_rule_header_rec.status_code = FND_API.g_miss_char OR p_na_rule_header_rec.status_code IS NULL THEN
861: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );
862: x_return_status := FND_API.g_ret_sts_error;
863: END IF;
864: */
865:

Line 867: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

863: END IF;
864: */
865:
866: /* IF p_na_rule_header_rec.object_version_number = FND_API.G_MISS_NUM OR p_na_rule_header_rec.object_version_number IS NULL THEN
867: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: */
871:

Line 876: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_RULE_HEADER_ID' );

872: ELSE
873:
874:
875: IF p_na_rule_header_rec.na_rule_header_id = FND_API.G_MISS_NUM THEN
876: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'NA_RULE_HEADER_ID' );
877: x_return_status := FND_API.g_ret_sts_error;
878: END IF;
879:
880: /*

Line 882: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_STATUS_ID' );

878: END IF;
879:
880: /*
881: IF p_na_rule_header_rec.user_status_id = FND_API.G_MISS_NUM THEN
882: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_STATUS_ID' );
883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885:
886:

Line 888: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );

884: END IF;
885:
886:
887: IF p_na_rule_header_rec.status_code = FND_API.g_miss_char THEN
888: OZF_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );
889: x_return_status := FND_API.g_ret_sts_error;
890: END IF;
891: */
892:

Line 894: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

890: END IF;
891: */
892:
893: IF p_na_rule_header_rec.object_version_number = FND_API.G_MISS_NUM THEN
894: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
895: x_return_status := FND_API.g_ret_sts_error;
896: END IF;
897: END IF;
898:

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

1159: END IF;
1160:
1161:
1162: -- Debug Message
1163: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1164:
1165:
1166:
1167: -- Initialize API return status to SUCCESS

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

1168: x_return_status := FND_API.G_RET_STS_SUCCESS;
1169:
1170:
1171: -- Debug Message
1172: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1173:
1174:
1175: -- Standard call to get message count and if count is 1, get message info.
1176: FND_MSG_PUB.Count_And_Get

Line 1182: WHEN OZF_Utility_PVT.resource_locked THEN

1178: p_data => x_msg_data
1179: );
1180: EXCEPTION
1181:
1182: WHEN OZF_Utility_PVT.resource_locked THEN
1183: x_return_status := FND_API.g_ret_sts_error;
1184: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1185:
1186: WHEN FND_API.G_EXC_ERROR THEN

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

1180: EXCEPTION
1181:
1182: WHEN OZF_Utility_PVT.resource_locked THEN
1183: x_return_status := FND_API.g_ret_sts_error;
1184: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1185:
1186: WHEN FND_API.G_EXC_ERROR THEN
1187: ROLLBACK TO VALIDATE_Na_Rule_Header_;
1188: x_return_status := FND_API.G_RET_STS_ERROR;

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

1245: -- THEN
1246: -- x_return_status := FND_API.G_RET_STS_ERROR;
1247:
1248: -- Debug Message
1249: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1250: -- Standard call to get message count and if count is 1, get message info.
1251: FND_MSG_PUB.Count_And_Get
1252: (p_count => x_msg_count,
1253: p_data => x_msg_data