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 295: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR

291: BEGIN
292: g_debug_count := g_debug_count + 1;
293:
294: IF g_debug_count = 1 THEN
295: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
296: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
297: THEN
298: hz_utility_v2pub.enable_debug;
299: g_debug := TRUE;

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

292: g_debug_count := g_debug_count + 1;
293:
294: IF g_debug_count = 1 THEN
295: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
296: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
297: THEN
298: hz_utility_v2pub.enable_debug;
299: g_debug := TRUE;
300: END IF;

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

462: --
463:
464: -- use new routines
465:
466: IF nvl(fnd_profile.value(g_profile_fmt_bkwd_compatible),'Y') = 'N' THEN
467:
468: --
469: -- Invoke the person name formatting API
470: --

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

1490: END IF;
1491: CLOSE c_person;
1492:
1493:
1494: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN
1495: -- Always End date the existing profile and create a new profile
1496: l_create_update_flag := 'C';
1497:
1498: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN

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

1494: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN
1495: -- Always End date the existing profile and create a new profile
1496: l_create_update_flag := 'C';
1497:
1498: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN
1499: -- Always update the existing profile
1500: l_create_update_flag := 'U';
1501:
1502: ELSE

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

2051: RAISE fnd_api.g_exc_error;
2052: END IF;
2053: CLOSE c_org;
2054:
2055: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN
2056: -- Always End date the existing profile and create a new profile
2057: l_create_update_flag := 'C';
2058:
2059: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN

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

2055: IF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NEW_VERSION' THEN
2056: -- Always End date the existing profile and create a new profile
2057: l_create_update_flag := 'C';
2058:
2059: ELSIF fnd_profile.value ('HZ_PROFILE_VERSION') = 'NO_VERSION' THEN
2060: -- Always update the existing profile
2061: l_create_update_flag := 'U';
2062:
2063: ELSE

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

2805:
2806: -- if GENERATE_PARTY_NUMBER is 'N', then if party_number is
2807: -- not passed or is a duplicate raise error.
2808:
2809: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2810:
2811: IF l_party_rec.party_number = FND_API.G_MISS_CHAR OR
2812: l_party_rec.party_number IS NULL
2813: THEN

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

2885: -- the new dynamic name formatting routines.
2886:
2887: -- use new routines
2888:
2889: IF nvl(fnd_profile.value(g_profile_fmt_bkwd_compatible),'Y') = 'N' THEN
2890:
2891: -- use the new name formatting routine
2892:
2893: l_party_name := substrb( do_create_person_name(p_person_rec), 1, 360 );

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

2947: -- the new dynamic name formatting routines.
2948:
2949: -- use new routines
2950:
2951: IF nvl(fnd_profile.value(g_profile_fmt_bkwd_compatible),'Y') = 'N' THEN
2952:
2953: -- use the new name formatting routine
2954: l_party_name := substrb( do_create_person_name(l_person_rec), 1, 360 );
2955:

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

3688: --information like gender,marital status,date of birth and place of birth will not
3689: --be propagated into HZ_PERSON_PROFILES.
3690: IF (p_person_rec.party_rec.orig_system_reference LIKE 'PER%')
3691: AND
3692: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
3693: AND
3694: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')
3695: THEN
3696: p_person_rec.gender := NULL;

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

3690: IF (p_person_rec.party_rec.orig_system_reference LIKE 'PER%')
3691: AND
3692: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
3693: AND
3694: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')
3695: THEN
3696: p_person_rec.gender := NULL;
3697: p_person_rec.marital_status := NULL;
3698: p_person_rec.date_of_birth := NULL;

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

4220: -- set party usage code
4221:
4222: IF l_party_create_update_flag = 'C' THEN
4223: l_party_usg_assignment_rec.party_usage_code :=
4224: NVL(p_party_usage_code, fnd_profile.value('HZ_PARTY_USAGE_DEFAULT'));
4225: ELSE
4226: l_party_usg_assignment_rec.party_usage_code := p_party_usage_code;
4227: END IF;
4228:

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

4422: --be updated into HZ_PERSON_PROFILES and the old values will be retained for these
4423: --columns.
4424: IF (NVL(p_person_rec.party_rec.orig_system_reference,p_old_person_rec.party_rec.orig_system_reference) LIKE 'PER%')
4425: AND
4426: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
4427: AND
4428: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')
4429: THEN
4430: p_person_rec.gender := NULL;

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

4424: IF (NVL(p_person_rec.party_rec.orig_system_reference,p_old_person_rec.party_rec.orig_system_reference) LIKE 'PER%')
4425: AND
4426: (FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE')LIKE '%HR API%')
4427: AND
4428: (fnd_profile.value('HZ_PROTECT_HR_PERSON_INFO')='Y')
4429: THEN
4430: p_person_rec.gender := NULL;
4431: p_person_rec.marital_status := NULL;
4432: p_person_rec.date_of_birth := NULL;

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

4929:
4930: -- Bug 2486394 Check if the DSS security is granted to the user
4931: -- Bug 3818648: check dss profile before call test_instance.
4932: --
4933: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
4934: l_test_security :=
4935: hz_dss_util_pub.test_instance(
4936: p_operation_code => 'INSERT',
4937: p_db_object_name => 'HZ_PARTIES',

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

5323:
5324: -- Bug 2486394 Check if the DSS security is granted to the user
5325: -- Bug 3818648: check dss profile before call test_instance.
5326: --
5327: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
5328: l_test_security :=
5329: hz_dss_util_pub.test_instance(
5330: p_operation_code => 'UPDATE',
5331: p_db_object_name => 'HZ_PARTIES',

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

5611:
5612: -- Bug 2486394 Check if the DSS security is granted to the user
5613: -- Bug 3818648: check dss profile before call test_instance.
5614: --
5615: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
5616: l_test_security :=
5617: hz_dss_util_pub.test_instance(
5618: p_operation_code => 'INSERT',
5619: p_db_object_name => 'HZ_PARTIES',

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

5935:
5936: -- Bug 2486394 Check if the DSS security is granted to the user
5937: -- Bug 3818648: check dss profile before call test_instance.
5938: --
5939: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
5940: l_test_security :=
5941: hz_dss_util_pub.test_instance(
5942: p_operation_code => 'UPDATE',
5943: p_db_object_name => 'HZ_PARTIES',

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

6281:
6282: -- Bug 2486394 -Check if the DSS security is granted to the user
6283: -- Bug 3818648: check dss profile before call test_instance.
6284: --
6285: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
6286: l_test_security :=
6287: hz_dss_util_pub.test_instance(
6288: p_operation_code => 'INSERT',
6289: p_db_object_name => 'HZ_PARTIES',

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

6690:
6691: --- Bug 2486394 Check if the DSS security is granted to the user
6692: -- Bug 3818648: check dss profile before call test_instance.
6693: --
6694: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
6695: l_test_security :=
6696: hz_dss_util_pub.test_instance(
6697: p_operation_code => 'UPDATE',
6698: p_db_object_name => 'HZ_PARTIES',