DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on FND_PROFILE

Line 146: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR

142:
143: g_debug_count := g_debug_count + 1;
144:
145: IF g_debug_count = 1 THEN
146: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
147: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
148: THEN
149: hz_utility_v2pub.enable_debug;
150: g_debug := TRUE;

Line 147: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'

143: g_debug_count := g_debug_count + 1;
144:
145: IF g_debug_count = 1 THEN
146: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
147: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
148: THEN
149: hz_utility_v2pub.enable_debug;
150: g_debug := TRUE;
151: END IF;

Line 2604: --NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N') = 'N'

2600: p_phone_rec.phone_extension||
2601: p_phone_rec.raw_phone_number IS NOT NULL) /* AND
2602: db_actual_content_source = 'DNB' AND*/
2603: -- SSM SST Integration and Extension
2604: --NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N') = 'N'
2605: -- HZ_UTILITY_V2PUB.is_purchased_content_source(db_actual_content_source) = 'Y'
2606: THEN
2607: l_return_status := FND_API.G_RET_STS_SUCCESS;
2608: validate_nonupdateable (

Line 3093: | IF NVL(fnd_profile.value('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API'

3089: ------------------------
3090: --Commented out the code below in the fix for 3099624.Added HR securrity validation in validate_hr_security procedure which is called from validate_person.
3091: --fix for Bug 2642597
3092: /*IF nvl(p_old_party_rec.orig_system_reference,'X') LIKE 'PER%' THEN
3093: | IF NVL(fnd_profile.value('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API'
3094: | AND p_create_update_flag = 'U'
3095: | THEN
3096: | fnd_message.set_name('AR', 'HZ_CREATED_BY_MISMATCH');
3097: | fnd_msg_pub.add;

Line 3111: |IF NVL(fnd_profile.value('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API'

3107: | l_temp_hr_party_exist := 0;
3108: |END IF;
3109: |CLOSE c_temp_hr_party_exist;
3110: |
3111: |IF NVL(fnd_profile.value('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API'
3112: | AND l_temp_hr_party_exist = 1
3113: | AND p_create_update_flag = 'U'
3114: |THEN
3115: | fnd_message.set_name('AR', 'HZ_CREATED_BY_MISMATCH');

Line 3257: l_change_cust_name_profile := fnd_profile.VALUE('AR_CHANGE_CUST_NAME');

3253: -- Check added for Bug 5174379 on 31-May-2006 (Nishant)
3254: -------------------------------------------------------------------------
3255: IF p_create_update_flag = 'U' THEN
3256:
3257: l_change_cust_name_profile := fnd_profile.VALUE('AR_CHANGE_CUST_NAME');
3258: IF (NVL(l_change_cust_name_profile,'Y') = 'N') THEN -- update to party name is not allowed
3259:
3260: IF ((p_person_rec.person_first_name <> p_old_person_rec.person_first_name) OR
3261: (p_person_rec.person_middle_name <> p_old_person_rec.person_middle_name) OR

Line 3841: IF (NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API')

3837:
3838:
3839: IF(NVL(p_old_person_rec.party_rec.orig_system_reference,'X') LIKE 'PER%')
3840: THEN
3841: IF (NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API')
3842: THEN
3843: IF(FND_PROFILE.VALUE('HZ_PROTECT_HR_PERSON_INFO')='Y')
3844: THEN
3845: IF(NVL(p_person_rec.person_first_name,p_old_person_rec.person_first_name)<>p_old_person_rec.person_first_name)

Line 3843: IF(FND_PROFILE.VALUE('HZ_PROTECT_HR_PERSON_INFO')='Y')

3839: IF(NVL(p_old_person_rec.party_rec.orig_system_reference,'X') LIKE 'PER%')
3840: THEN
3841: IF (NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API')
3842: THEN
3843: IF(FND_PROFILE.VALUE('HZ_PROTECT_HR_PERSON_INFO')='Y')
3844: THEN
3845: IF(NVL(p_person_rec.person_first_name,p_old_person_rec.person_first_name)<>p_old_person_rec.person_first_name)
3846: THEN
3847: cols_updated :=cols_updated||',PERSON_FIRST_NAME';

Line 3906: ELSIF(FND_PROFILE.VALUE('HZ_PROTECT_HR_PERSON_INFO')='N') --elsif corresonding to --IF(FND_PROFILE.VALUE('HZ_PROTECT_PERSON_INFO')='Y')--

3902: FND_MSG_PUB.ADD;
3903: x_return_status := FND_API.G_RET_STS_ERROR;
3904: END IF;
3905:
3906: ELSIF(FND_PROFILE.VALUE('HZ_PROTECT_HR_PERSON_INFO')='N') --elsif corresonding to --IF(FND_PROFILE.VALUE('HZ_PROTECT_PERSON_INFO')='Y')--
3907: THEN
3908: IF(NVL(p_person_rec.person_first_name,p_old_person_rec.person_first_name)<>p_old_person_rec.person_first_name)
3909: THEN
3910: cols_updated :=cols_updated||',PERSON_FIRST_NAME';

Line 3989: END IF;--end if corresponding to --IF(FND_PROFILE.VALUE('HZ_PROTECT_PERSON_INFO')='YES')--

3985: FND_MSG_PUB.ADD;
3986: x_return_status := FND_API.G_RET_STS_ERROR;
3987: END IF;
3988:
3989: END IF;--end if corresponding to --IF(FND_PROFILE.VALUE('HZ_PROTECT_PERSON_INFO')='YES')--
3990:
3991: END IF;--end if corresponding to --IF(NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API')--
3992:
3993: END IF;--end if corresponding to --IF(NVL(p_old_party_rec.orig_system_reference,'X') LIKE 'PER%')--

Line 3991: END IF;--end if corresponding to --IF(NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API')--

3987: END IF;
3988:
3989: END IF;--end if corresponding to --IF(FND_PROFILE.VALUE('HZ_PROTECT_PERSON_INFO')='YES')--
3990:
3991: END IF;--end if corresponding to --IF(NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API')--
3992:
3993: END IF;--end if corresponding to --IF(NVL(p_old_party_rec.orig_system_reference,'X') LIKE 'PER%')--
3994:
3995:

Line 4224: IF FND_PROFILE.VALUE( 'HZ_API_ERR_ON_OBSOLETE_COLUMN' ) = 'Y' THEN

4220:
4221:
4222: -- validate nonsupported column in organization profile when creating
4223:
4224: IF FND_PROFILE.VALUE( 'HZ_API_ERR_ON_OBSOLETE_COLUMN' ) = 'Y' THEN
4225: validate_org_nonsupport_column(
4226: p_create_update_flag,
4227: p_organization_rec,
4228: x_return_status );

Line 4243: l_change_org_name_profile := fnd_profile.VALUE('AR_CHANGE_CUST_NAME');

4239: -- Check added for Bug 5174379 on 31-May-2006 (Nishant)
4240: -------------------------------------------------------------------------
4241: IF p_create_update_flag = 'U' THEN
4242:
4243: l_change_org_name_profile := fnd_profile.VALUE('AR_CHANGE_CUST_NAME');
4244: IF (NVL(l_change_org_name_profile,'Y') = 'N') THEN -- update to party name is not allowed
4245:
4246: IF (p_organization_rec.organization_name <> p_old_organization_rec.organization_name) THEN
4247: fnd_message.set_name('AR', 'HZ_ORG_NAME_UPDT_NOT_ALLOWED');

Line 5633: NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N') = 'N'*/

5629: p_organization_rec.ceo_title IS NOT NULL OR
5630: p_organization_rec.principal_title IS NOT NULL OR
5631: p_organization_rec.principal_name IS NOT NULL ) AND
5632: /*p_organization_rec.actual_content_source = 'DNB' AND
5633: NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N') = 'N'*/
5634: /* HZ_UTILITY_V2PUB.is_purchased_content_source(p_organization_rec.actual_content_source) = 'Y' AND
5635: p_organization_rec.actual_content_source <> HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE
5636: THEN
5637: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11262: /*NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N') = 'N'*/

11258: db_actual_content_source <> 'USER_ENTERED' -- AND
11259: -- SSM SST Integration and Extension
11260: -- Check Updateability using mix-n-match procedure rather than checking the
11261: -- profile value.
11262: /*NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N') = 'N'*/
11263: --HZ_UTILITY_V2PUB.is_purchased_content_source(db_actual_content_source) = 'Y'
11264: THEN
11265: l_return_status := FND_API.G_RET_STS_SUCCESS;
11266: