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.HZ_MOSR_VALIDATE_PKG dependencies on HZ_UTILITY_V2PUB

Line 166: HZ_UTILITY_V2PUB.validate_lookup (

162: -- SST SSM Integration and Extension
163: -- Validate p_orig_sys_entity_map_rec.orig_system against
164: -- table HZ_ORIG_SYSTEMS_B instead of lookup ORIG_SYSTEM
165: /*
166: HZ_UTILITY_V2PUB.validate_lookup (
167: p_column => 'orig_system',
168: p_lookup_type => 'ORIG_SYSTEM',
169: p_column_value => p_orig_sys_entity_map_rec.orig_system,
170: x_return_status => x_return_status );

Line 183: HZ_UTILITY_V2PUB.validate_lookup (

179: FND_MSG_PUB.ADD;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: end if;
182:
183: HZ_UTILITY_V2PUB.validate_lookup (
184: p_column => 'status',
185: p_lookup_type => 'MOSR_STATUS',
186: p_column_value => p_orig_sys_entity_map_rec.status,
187: x_return_status => x_return_status );

Line 189: HZ_UTILITY_V2PUB.validate_lookup (

185: p_lookup_type => 'MOSR_STATUS',
186: p_column_value => p_orig_sys_entity_map_rec.status,
187: x_return_status => x_return_status );
188:
189: HZ_UTILITY_V2PUB.validate_lookup (
190: p_column => 'owner_table_name',
191: p_lookup_type => 'TCA_OWNER_TABLE',
192: p_column_value => p_orig_sys_entity_map_rec.owner_table_name,
193: x_return_status => x_return_status );

Line 195: HZ_UTILITY_V2PUB.validate_lookup (

191: p_lookup_type => 'TCA_OWNER_TABLE',
192: p_column_value => p_orig_sys_entity_map_rec.owner_table_name,
193: x_return_status => x_return_status );
194:
195: HZ_UTILITY_V2PUB.validate_lookup (
196: p_column => 'multiple_flag',
197: p_lookup_type => 'YES/NO',
198: p_column_value => p_orig_sys_entity_map_rec.multiple_flag,
199: x_return_status => x_return_status );

Line 245: HZ_UTILITY_V2PUB.validate_nonupdateable (

241:
242: IF p_create_update_flag = 'U' AND
243: p_orig_sys_entity_map_rec.multiple_flag IS NOT NULL
244: THEN
245: HZ_UTILITY_V2PUB.validate_nonupdateable (
246: p_column => 'multiple_flag',
247: p_column_value => p_orig_sys_entity_map_rec.multiple_flag,
248: p_old_column_value => l_multiple_flag,
249: p_restricted => 'N',

Line 277: hz_utility_v2pub.validate_created_by_module(

273: --------------------------------------
274: -- validate created_by_module
275: --------------------------------------
276:
277: hz_utility_v2pub.validate_created_by_module(
278: p_create_update_flag => p_create_update_flag,
279: p_created_by_module => p_orig_sys_entity_map_rec.created_by_module,
280: p_old_created_by_module => l_created_by_module,
281: x_return_status => x_return_status);

Line 287: hz_utility_v2pub.validate_application_id(

283: --------------------------------------
284: -- validate application_id
285: --------------------------------------
286:
287: hz_utility_v2pub.validate_application_id(
288: p_create_update_flag => p_create_update_flag,
289: p_application_id => p_orig_sys_entity_map_rec.application_id,
290: p_old_application_id => l_application_id,
291: x_return_status => x_return_status);

Line 375: HZ_UTILITY_V2PUB.validate_mandatory (

371: and
372: (p_orig_sys_reference_rec.orig_system_reference is null or
373: p_orig_sys_reference_rec.orig_system_reference = fnd_api.g_miss_char)
374: THEN
375: HZ_UTILITY_V2PUB.validate_mandatory (
376: p_create_update_flag => p_create_update_flag,
377: p_column => 'orig_system_reference',
378: p_column_value => p_orig_sys_reference_rec.orig_system_reference,
379: x_return_status => x_return_status );

Line 421: HZ_UTILITY_V2PUB.validate_lookup (

417: END IF;
418: CLOSE c_active_orig_system_exists;
419:
420: -- validate owner_table_name.
421: HZ_UTILITY_V2PUB.validate_lookup (
422: p_column => 'owner_table_name',
423: p_column_value => p_orig_sys_reference_rec.owner_table_name,
424: p_lookup_type => 'TCA_OWNER_TABLE',
425: x_return_status => x_return_status

Line 437: HZ_UTILITY_V2PUB.validate_mandatory (

433: and
434: (p_orig_sys_reference_rec.owner_table_id is null or
435: p_orig_sys_reference_rec.owner_table_id = fnd_api.g_miss_num)
436: THEN
437: HZ_UTILITY_V2PUB.validate_mandatory (
438: p_create_update_flag => p_create_update_flag,
439: p_column => 'owner_table_id',
440: p_column_value => p_orig_sys_reference_rec.owner_table_id,
441: x_return_status => x_return_status );

Line 472: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

468: fnd_msg_pub.add;
469: x_return_status := fnd_api.g_ret_sts_error;
470: END;
471: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
473: p_message=>'owner_table_id is foreign key of hz_parties. ' ||
474: 'x_return_status = ' || x_return_status,
475: p_msg_level=>fnd_log.level_statement);
476: END IF;

Line 506: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

502: fnd_msg_pub.add;
503: x_return_status := fnd_api.g_ret_sts_error;
504: END;
505: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
506: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
507: p_message=>'owner_table_id is foreign key of HZ_PARTY_SITES. ' ||
508: 'x_return_status = ' || x_return_status,
509: p_msg_level=>fnd_log.level_statement);
510: END IF;

Line 541: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

537: fnd_msg_pub.add;
538: x_return_status := fnd_api.g_ret_sts_error;
539: END;
540: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
542: p_message=>'owner_table_id is foreign key of HZ_CONTACT_POINTS. ' ||
543: 'x_return_status = ' || x_return_status,
544: p_msg_level=>fnd_log.level_statement);
545: END IF;

Line 574: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

570: fnd_msg_pub.add;
571: x_return_status := fnd_api.g_ret_sts_error;
572: END;
573: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
574: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
575: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCOUNTS. ' ||
576: 'x_return_status = ' || x_return_status,
577: p_msg_level=>fnd_log.level_statement);
578: END IF;

Line 607: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

603: fnd_msg_pub.add;
604: x_return_status := fnd_api.g_ret_sts_error;
605: END;
606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
607: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
608: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCOUNT_ROLES. ' ||
609: 'x_return_status = ' || x_return_status,
610: p_msg_level=>fnd_log.level_statement);
611: END IF;

Line 641: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

637: fnd_msg_pub.add;
638: x_return_status := fnd_api.g_ret_sts_error;
639: END;
640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
641: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
642: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCT_SITES_ALL. ' ||
643: 'x_return_status = ' || x_return_status,
644: p_msg_level=>fnd_log.level_statement);
645: END IF;

Line 675: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

671: fnd_msg_pub.add;
672: x_return_status := fnd_api.g_ret_sts_error;
673: END;
674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
675: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
676: p_message=>'owner_table_id is foreign key of HZ_CUST_SITE_USES_ALL. ' ||
677: 'x_return_status = ' || x_return_status,
678: p_msg_level=>fnd_log.level_statement);
679: END IF;

Line 709: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

705: fnd_msg_pub.add;
706: x_return_status := fnd_api.g_ret_sts_error;
707: END;
708: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
710: p_message=>'owner_table_id is foreign key of HZ_LOCATIONS. ' ||
711: 'x_return_status = ' || x_return_status,
712: p_msg_level=>fnd_log.level_statement);
713: END IF;

Line 743: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

739: fnd_msg_pub.add;
740: x_return_status := fnd_api.g_ret_sts_error;
741: END;
742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
744: p_message=>'owner_table_id is foreign key of HZ_ORG_CONTACTS. ' ||
745: 'x_return_status = ' || x_return_status,
746: p_msg_level=>fnd_log.level_statement);
747: END IF;

Line 777: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

773: fnd_msg_pub.add;
774: x_return_status := fnd_api.g_ret_sts_error;
775: END;
776: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
777: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
778: p_message=>'owner_table_id is foreign key of HZ_ORG_CONTACT_ROLES. ' ||
779: 'x_return_status = ' || x_return_status,
780: p_msg_level=>fnd_log.level_statement);
781: END IF;

Line 866: HZ_UTILITY_V2PUB.validate_lookup (

862: x_return_status := FND_API.G_RET_STS_ERROR;
863: end if;
864:
865:
866: HZ_UTILITY_V2PUB.validate_lookup (
867: p_column => 'status',
868: p_lookup_type => 'MOSR_STATUS',
869: p_column_value => p_orig_sys_reference_rec.status,
870: x_return_status => x_return_status );

Line 872: HZ_UTILITY_V2PUB.validate_lookup (

868: p_lookup_type => 'MOSR_STATUS',
869: p_column_value => p_orig_sys_reference_rec.status,
870: x_return_status => x_return_status );
871:
872: HZ_UTILITY_V2PUB.validate_lookup (
873: p_column => 'reason_code',
874: p_lookup_type => 'MOSR_REASON',
875: p_column_value => p_orig_sys_reference_rec.reason_code,
876: x_return_status => x_return_status );

Line 902: HZ_UTILITY_V2PUB.validate_start_end_date (

898:
899: -- Bug 4964046 : Validate start date and end date for 'Create' as well as 'Update'
900: -- if p_create_update_flag = 'U'
901: -- then
902: HZ_UTILITY_V2PUB.validate_start_end_date (
903: p_create_update_flag => p_create_update_flag,
904: p_start_date_column_name => 'start_date_active',
905: p_start_date => trunc(p_orig_sys_reference_rec.start_date_active), /* Bug 3298896 */
906: p_old_start_date => trunc(l_start_date), /* Bug 3298896 */

Line 917: hz_utility_v2pub.validate_created_by_module(

913: --------------------------------------
914: -- validate created_by_module
915: --------------------------------------
916:
917: hz_utility_v2pub.validate_created_by_module(
918: p_create_update_flag => p_create_update_flag,
919: p_created_by_module => p_orig_sys_reference_rec.created_by_module,
920: p_old_created_by_module => l_created_by_module,
921: x_return_status => x_return_status);

Line 927: hz_utility_v2pub.validate_application_id(

923: --------------------------------------
924: -- validate application_id
925: --------------------------------------
926:
927: hz_utility_v2pub.validate_application_id(
928: p_create_update_flag => p_create_update_flag,
929: p_application_id => p_orig_sys_reference_rec.application_id,
930: p_old_application_id => l_application_id,
931: x_return_status => x_return_status);

Line 986: HZ_UTILITY_V2PUB.validate_mandatory (

982: FND_MSG_PUB.ADD;
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: end if;
985:
986: HZ_UTILITY_V2PUB.validate_mandatory (
987: p_create_update_flag => p_create_update_flag,
988: p_column => 'orig_system',
989: p_column_value => p_orig_sys_rec.orig_system,
990: x_return_status => x_return_status );

Line 992: HZ_UTILITY_V2PUB.validate_mandatory (

988: p_column => 'orig_system',
989: p_column_value => p_orig_sys_rec.orig_system,
990: x_return_status => x_return_status );
991:
992: HZ_UTILITY_V2PUB.validate_mandatory (
993: p_create_update_flag => p_create_update_flag,
994: p_column => 'sst_flag',
995: p_column_value => p_orig_sys_rec.sst_flag,
996: x_return_status => x_return_status );

Line 998: HZ_UTILITY_V2PUB.validate_mandatory (

994: p_column => 'sst_flag',
995: p_column_value => p_orig_sys_rec.sst_flag,
996: x_return_status => x_return_status );
997:
998: HZ_UTILITY_V2PUB.validate_mandatory (
999: p_create_update_flag => p_create_update_flag,
1000: p_column => 'orig_system_name',
1001: p_column_value => p_orig_sys_rec.orig_system_name,
1002: x_return_status => x_return_status );

Line 1005: HZ_UTILITY_V2PUB.validate_mandatory (

1001: p_column_value => p_orig_sys_rec.orig_system_name,
1002: x_return_status => x_return_status );
1003:
1004:
1005: HZ_UTILITY_V2PUB.validate_mandatory (
1006: p_create_update_flag => p_create_update_flag,
1007: p_column => 'orig_system_type',
1008: p_column_value => p_orig_sys_rec.orig_system_type,
1009: x_return_status => x_return_status );

Line 1011: HZ_UTILITY_V2PUB.validate_mandatory (

1007: p_column => 'orig_system_type',
1008: p_column_value => p_orig_sys_rec.orig_system_type,
1009: x_return_status => x_return_status );
1010:
1011: HZ_UTILITY_V2PUB.validate_mandatory (
1012: p_create_update_flag => p_create_update_flag,
1013: p_column => 'status',
1014: p_column_value => p_orig_sys_rec.status,
1015: x_return_status => x_return_status );

Line 1023: HZ_UTILITY_V2PUB.validate_mandatory (

1019: open source_system_exist;
1020: fetch source_system_exist
1021: into l_sst_flag, l_created_by_module, l_orig_system, l_orig_system_type;
1022:
1023: HZ_UTILITY_V2PUB.validate_mandatory (
1024: p_create_update_flag => p_create_update_flag,
1025: p_column => 'orig_system_id',
1026: p_column_value => p_orig_sys_rec.orig_system_id,
1027: x_return_status => x_return_status );

Line 1030: HZ_UTILITY_V2PUB.validate_nonupdateable (

1026: p_column_value => p_orig_sys_rec.orig_system_id,
1027: x_return_status => x_return_status );
1028:
1029: /* IF p_orig_sys_rec.created_by_module IS NOT NULL THEN
1030: HZ_UTILITY_V2PUB.validate_nonupdateable (
1031: p_column => 'sst_flag',
1032: p_column_value => p_orig_sys_rec.sst_flag,
1033: p_old_column_value => l_sst_flag,
1034: p_restricted => 'N',

Line 1044: HZ_UTILITY_V2PUB.validate_nonupdateable (

1040: x_return_status := FND_API.G_RET_STS_ERROR;
1041: END IF;
1042:
1043: IF p_orig_sys_rec.orig_system IS NOT NULL THEN
1044: HZ_UTILITY_V2PUB.validate_nonupdateable (
1045: p_column => 'orig_system',
1046: p_column_value => p_orig_sys_rec.orig_system,
1047: p_old_column_value => l_orig_system,
1048: p_restricted => 'N',

Line 1053: HZ_UTILITY_V2PUB.validate_nonupdateable (

1049: x_return_status => x_return_status );
1050: END IF;
1051:
1052: IF p_orig_sys_rec.orig_system_type IS NOT NULL THEN
1053: HZ_UTILITY_V2PUB.validate_nonupdateable (
1054: p_column => 'orig_system_type',
1055: p_column_value => p_orig_sys_rec.orig_system_type,
1056: p_old_column_value => l_orig_system_type,
1057: p_restricted => 'N',

Line 1062: HZ_UTILITY_V2PUB.validate_lookup (

1058: x_return_status => x_return_status );
1059: END IF;
1060: end if;
1061:
1062: HZ_UTILITY_V2PUB.validate_lookup (
1063: p_column => 'orig_system_type',
1064: p_lookup_type => 'HZ_ORIG_SYSTEM_TYPE',
1065: p_column_value => p_orig_sys_rec.orig_system_type,
1066: x_return_status => x_return_status );

Line 1068: HZ_UTILITY_V2PUB.validate_lookup (

1064: p_lookup_type => 'HZ_ORIG_SYSTEM_TYPE',
1065: p_column_value => p_orig_sys_rec.orig_system_type,
1066: x_return_status => x_return_status );
1067:
1068: HZ_UTILITY_V2PUB.validate_lookup (
1069: p_column => 'status',
1070: p_lookup_type => 'MOSR_STATUS',
1071: p_column_value => p_orig_sys_rec.status,
1072: x_return_status => x_return_status );

Line 1074: HZ_UTILITY_V2PUB.validate_lookup (

1070: p_lookup_type => 'MOSR_STATUS',
1071: p_column_value => p_orig_sys_rec.status,
1072: x_return_status => x_return_status );
1073:
1074: HZ_UTILITY_V2PUB.validate_lookup (
1075: p_column => 'sst_flag',
1076: p_lookup_type => 'YES/NO',
1077: p_column_value => p_orig_sys_rec.sst_flag,
1078: x_return_status => x_return_status );

Line 1084: hz_utility_v2pub.validate_created_by_module(

1080: --------------------------------------
1081: -- validate created_by_module
1082: --------------------------------------
1083:
1084: hz_utility_v2pub.validate_created_by_module(
1085: p_create_update_flag => p_create_update_flag,
1086: p_created_by_module => p_orig_sys_rec.created_by_module,
1087: p_old_created_by_module => l_created_by_module,
1088: x_return_status => x_return_status);