205: BEGIN
206: g_debug_count := g_debug_count + 1;
207:
208: IF g_debug_count = 1 THEN
209: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
210: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
211: THEN
212: hz_utility_v2pub.enable_debug;
213: g_debug := TRUE;
206: g_debug_count := g_debug_count + 1;
207:
208: IF g_debug_count = 1 THEN
209: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
210: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
211: THEN
212: hz_utility_v2pub.enable_debug;
213: g_debug := TRUE;
214: END IF;
689:
690:
691: -- Loading overwrite third party data rule
692:
693: l_rule_id := fnd_profile.value('HZ_USER_OVERWRITE_RULE');
694:
695: -- Debug info.
696: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
697: hz_utility_v2pub.debug(p_message=>'Loading overwrite third party data rule. '||
1227: IF p_load_rule THEN
1228:
1229: -- Loading creation user-entered data rule
1230:
1231: l_rule_id := fnd_profile.value('HZ_USER_DATA_CREATION_RULE');
1232:
1233: -- Debug info.
1234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1235: hz_utility_v2pub.debug(p_message=>'Loading creation user-entered data rule.' ||
3119:
3120: /* SSM SST Integration and Extension
3121: *
3122: IF p_actual_content_source <> G_MISS_CONTENT_SOURCE_TYPE AND
3123: NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N') = 'N'
3124: THEN
3125: */
3126: /* new message */
3127: /* FND_MESSAGE.SET_NAME('AR', 'HZ_NOTALLOW_UPDATE_THIRD_PARTY');
3344:
3345: -- obsolete content_source_type. Raise error in development site
3346: -- if user tries to populate value into this column.
3347:
3348: IF NVL(FND_PROFILE.value('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'N') = 'Y'
3349: THEN
3350: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (
3351: p_api_version => p_api_version,
3352: p_create_update_flag => p_create_update_flag,
3535:
3536: -- obsolete content_source_type. Raise error in development site
3537: -- if user tries to populate value into this column.
3538:
3539: IF NVL(FND_PROFILE.value('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'N') = 'Y'
3540: THEN
3541: HZ_UTILITY_V2PUB.Check_ObsoleteColumn (
3542: p_api_version => p_api_version,
3543: p_create_update_flag => 'C',
3697: RETURN G_MIXNM_ENABLED_FLAG(p_entity_attr_id);
3698: ELSE
3699:
3700: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
3701: l_return := NVL(fnd_profile.value('HZ_ORG_PROF_MIXNMATCH_ENABLED'), 'N');
3702: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN
3703: l_return := NVL(fnd_profile.value('HZ_PER_PROF_MIXNMATCH_ENABLED'), 'N');
3704: ELSE
3705: IF p_called_from_policy_function = 'Y' THEN
3699:
3700: IF p_entity_name = 'HZ_ORGANIZATION_PROFILES' THEN
3701: l_return := NVL(fnd_profile.value('HZ_ORG_PROF_MIXNMATCH_ENABLED'), 'N');
3702: ELSIF p_entity_name = 'HZ_PERSON_PROFILES' THEN
3703: l_return := NVL(fnd_profile.value('HZ_PER_PROF_MIXNMATCH_ENABLED'), 'N');
3704: ELSE
3705: IF p_called_from_policy_function = 'Y' THEN
3706: l_return := 'Y';
3707: ELSE
4710:
4711: IF x_process_org THEN
4712: Write_Log('process org profiles ...');
4713:
4714: IF NVL(fnd_profile.value('HZ_ORG_PROF_MIXNMATCH_ENABLED'), 'N') = 'N'
4715: THEN
4716: x_process_org_mode := 'C';
4717:
4718: l_result := fnd_profile.save('HZ_ORG_PROF_MIXNMATCH_ENABLED', 'Y', 'SITE');
4714: IF NVL(fnd_profile.value('HZ_ORG_PROF_MIXNMATCH_ENABLED'), 'N') = 'N'
4715: THEN
4716: x_process_org_mode := 'C';
4717:
4718: l_result := fnd_profile.save('HZ_ORG_PROF_MIXNMATCH_ENABLED', 'Y', 'SITE');
4719:
4720: IF NOT l_result THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: END IF;
4770:
4771: IF x_process_person THEN
4772: Write_Log('process person profiles ...');
4773:
4774: IF NVL(fnd_profile.value('HZ_PER_PROF_MIXNMATCH_ENABLED'), 'N') = 'N'
4775: THEN
4776: x_process_person_mode := 'C';
4777:
4778: l_result := fnd_profile.save('HZ_PER_PROF_MIXNMATCH_ENABLED', 'Y', 'SITE');
4774: IF NVL(fnd_profile.value('HZ_PER_PROF_MIXNMATCH_ENABLED'), 'N') = 'N'
4775: THEN
4776: x_process_person_mode := 'C';
4777:
4778: l_result := fnd_profile.save('HZ_PER_PROF_MIXNMATCH_ENABLED', 'Y', 'SITE');
4779:
4780: IF NOT l_result THEN
4781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4782: END IF;
4784: x_process_person_mode := 'U';
4785: END IF;
4786:
4787: Write_Log('x_process_person_mode = '||x_process_person_mode);
4788: Write_Log(fnd_profile.value('HZ_PER_PROF_MIXNMATCH_ENABLED'));
4789:
4790: j := 0; l_last_fetch := false;
4791: OPEN c_person_parties;
4792: LOOP
5277: END IF;
5278:
5279: -- add policy functions.
5280:
5281: IF NVL(fnd_profile.value('HZ_DNB_POLICY_EXISTS'), 'N') = 'N' THEN
5282: OPEN c_entities;
5283: FETCH c_entities BULK COLLECT INTO i_entities;
5284: CLOSE c_entities;
5285: