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_PARTY_V2PUB dependencies on FND_PROFILE

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

298: BEGIN
299: g_debug_count := g_debug_count + 1;
300:
301: IF g_debug_count = 1 THEN
302: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
303: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
304: THEN
305: hz_utility_v2pub.enable_debug;
306: g_debug := TRUE;

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

299: g_debug_count := g_debug_count + 1;
300:
301: IF g_debug_count = 1 THEN
302: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
303: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
304: THEN
305: hz_utility_v2pub.enable_debug;
306: g_debug := TRUE;
307: END IF;

Line 473: IF nvl(fnd_profile.value(g_profile_fmt_bkwd_compatible),'Y') = 'N' THEN

469: --
470:
471: -- use new routines
472:
473: IF nvl(fnd_profile.value(g_profile_fmt_bkwd_compatible),'Y') = 'N' THEN
474:
475: --
476: -- Invoke the person name formatting API
477: --

Line 1501: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN

1497: END IF;
1498: CLOSE c_person;
1499:
1500:
1501: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN
1502: -- Always End date the existing profile and create a new profile
1503: l_create_update_flag := 'C';
1504:
1505: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN

Line 1505: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN

1501: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN
1502: -- Always End date the existing profile and create a new profile
1503: l_create_update_flag := 'C';
1504:
1505: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN
1506: -- Always update the existing profile
1507: l_create_update_flag := 'U';
1508:
1509: ELSE

Line 2096: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN

2092: RAISE fnd_api.g_exc_error;
2093: END IF;
2094: CLOSE c_org;
2095:
2096: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN
2097: -- Always End date the existing profile and create a new profile
2098: l_create_update_flag := 'C';
2099:
2100: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN

Line 2100: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN

2096: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN
2097: -- Always End date the existing profile and create a new profile
2098: l_create_update_flag := 'C';
2099:
2100: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN
2101: -- Always update the existing profile
2102: l_create_update_flag := 'U';
2103:
2104: ELSE

Line 2860: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN

2856:
2857: -- if GENERATE_PARTY_NUMBER is 'N', then if party_number is
2858: -- not passed or is a duplicate raise error.
2859:
2860: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2861:
2862: IF l_party_rec.party_number = FND_API.G_MISS_CHAR OR
2863: l_party_rec.party_number IS NULL
2864: THEN

Line 2940: IF nvl(fnd_profile.value(g_profile_fmt_bkwd_compatible),'Y') = 'N' THEN

2936: -- the new dynamic name formatting routines.
2937:
2938: -- use new routines
2939:
2940: IF nvl(fnd_profile.value(g_profile_fmt_bkwd_compatible),'Y') = 'N' THEN
2941:
2942: -- use the new name formatting routine
2943:
2944: l_party_name := substrb( do_create_person_name(p_person_rec), 1, 360 );

Line 3002: IF nvl(fnd_profile.value(g_profile_fmt_bkwd_compatible),'Y') = 'N' THEN

2998: -- the new dynamic name formatting routines.
2999:
3000: -- use new routines
3001:
3002: IF nvl(fnd_profile.value(g_profile_fmt_bkwd_compatible),'Y') = 'N' THEN
3003:
3004: -- use the new name formatting routine
3005: l_party_name := substrb( do_create_person_name(l_person_rec), 1, 360 );
3006:

Line 3746: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')

3742: --information like gender,marital status,date of birth and place of birth will not
3743: --be propagated into HZ_PERSON_PROFILES.
3744: IF (p_person_rec.party_rec.orig_system_reference LIKE 'PER%')
3745: AND
3746: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
3747: AND
3748: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')
3749: THEN
3750: p_person_rec.gender := NULL;

Line 3748: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')

3744: IF (p_person_rec.party_rec.orig_system_reference LIKE 'PER%')
3745: AND
3746: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
3747: AND
3748: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')
3749: THEN
3750: p_person_rec.gender := NULL;
3751: p_person_rec.marital_status := NULL;
3752: p_person_rec.date_of_birth := NULL;

Line 4283: NVL(p_party_usage_code, fnd_profile.value('HZ_PARTY_USAGE_DEFAULT'));

4279: -- set party usage code
4280:
4281: IF l_party_create_update_flag = 'C' THEN
4282: l_party_usg_assignment_rec.party_usage_code :=
4283: NVL(p_party_usage_code, fnd_profile.value('HZ_PARTY_USAGE_DEFAULT'));
4284: ELSE
4285: l_party_usg_assignment_rec.party_usage_code := p_party_usage_code;
4286: END IF;
4287:

Line 4485: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')

4481: --be updated into HZ_PERSON_PROFILES and the old values will be retained for these
4482: --columns.
4483: IF (NVL(p_person_rec.party_rec.orig_system_reference,p_old_person_rec.party_rec.orig_system_reference) LIKE 'PER%')
4484: AND
4485: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
4486: AND
4487: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')
4488: THEN
4489: p_person_rec.gender := NULL;

Line 4487: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')

4483: IF (NVL(p_person_rec.party_rec.orig_system_reference,p_old_person_rec.party_rec.orig_system_reference) LIKE 'PER%')
4484: AND
4485: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
4486: AND
4487: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')
4488: THEN
4489: p_person_rec.gender := NULL;
4490: p_person_rec.marital_status := NULL;
4491: p_person_rec.date_of_birth := NULL;

Line 4993: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN

4989:
4990: -- Bug 2486394 Check if the DSS security is granted to the user
4991: -- Bug 3818648: check dss profile before call test_instance.
4992: --
4993: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
4994: l_test_security :=
4995: hz_dss_util_pub.test_instance(
4996: p_operation_code => 'INSERT',
4997: p_db_object_name => 'HZ_PARTIES',

Line 5398: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN

5394:
5395: -- Bug 2486394 Check if the DSS security is granted to the user
5396: -- Bug 3818648: check dss profile before call test_instance.
5397: --
5398: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
5399: l_test_security :=
5400: hz_dss_util_pub.test_instance(
5401: p_operation_code => 'UPDATE',
5402: p_db_object_name => 'HZ_PARTIES',

Line 5686: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN

5682:
5683: -- Bug 2486394 Check if the DSS security is granted to the user
5684: -- Bug 3818648: check dss profile before call test_instance.
5685: --
5686: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
5687: l_test_security :=
5688: hz_dss_util_pub.test_instance(
5689: p_operation_code => 'INSERT',
5690: p_db_object_name => 'HZ_PARTIES',

Line 6010: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN

6006:
6007: -- Bug 2486394 Check if the DSS security is granted to the user
6008: -- Bug 3818648: check dss profile before call test_instance.
6009: --
6010: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
6011: l_test_security :=
6012: hz_dss_util_pub.test_instance(
6013: p_operation_code => 'UPDATE',
6014: p_db_object_name => 'HZ_PARTIES',

Line 6356: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN

6352:
6353: -- Bug 2486394 -Check if the DSS security is granted to the user
6354: -- Bug 3818648: check dss profile before call test_instance.
6355: --
6356: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
6357: l_test_security :=
6358: hz_dss_util_pub.test_instance(
6359: p_operation_code => 'INSERT',
6360: p_db_object_name => 'HZ_PARTIES',

Line 6775: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN

6771:
6772: --- Bug 2486394 Check if the DSS security is granted to the user
6773: -- Bug 3818648: check dss profile before call test_instance.
6774: --
6775: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
6776: l_test_security :=
6777: hz_dss_util_pub.test_instance(
6778: p_operation_code => 'UPDATE',
6779: p_db_object_name => 'HZ_PARTIES',