APPS.HZ_PARTY_SITE_V2PUB dependencies on FND_PROFILE

Line 134: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR

130:
131: G_DEBUG_COUNT := G_DEBUG_COUNT + 1;
132:
133: IF G_DEBUG_COUNT = 1 THEN
134: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
135: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
136: THEN
137: HZ_UTILITY_V2PUB.enable_debug;
138: G_DEBUG := TRUE;

Line 135: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'

131: G_DEBUG_COUNT := G_DEBUG_COUNT + 1;
132:
133: IF G_DEBUG_COUNT = 1 THEN
134: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
135: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
136: THEN
137: HZ_UTILITY_V2PUB.enable_debug;
138: G_DEBUG := TRUE;
139: END IF;

Line 268: l_gen_party_site_number := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');

264: -- not passed or is a duplicate raise error.
265: -- if GENERATE_PARTY_SITE_NUMBER is NULL or 'Y', generate party_site_number
266: -- from sequence till a unique value is obtained.
267:
268: l_gen_party_site_number := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
269:
270: IF l_gen_party_site_number = 'N' THEN
271: IF l_party_site_number = FND_API.G_MISS_CHAR
272: OR

Line 1771: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN

1767: */
1768: -- END IF;
1769:
1770: -- report error on obsolete columns based on profile
1771: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN
1772: check_obsolete_columns (
1773: p_create_update_flag => 'C',
1774: p_party_site_rec => l_party_site_rec,
1775: x_return_status => x_return_status

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

1790:
1791: -- Bug 2486394 -Check if the DSS security is granted to the user
1792: -- Bug 3818648: check dss profile before call 3.
1793: --
1794: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
1795: l_test_security :=
1796: hz_dss_util_pub.test_instance(
1797: p_operation_code => 'INSERT',
1798: p_db_object_name => 'HZ_PARTY_SITES',

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

2059:
2060: --- Bug 2486394 Check if the DSS security is granted to the user
2061: -- Bug 3818648: check dss profile before call test_instance.
2062: --
2063: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
2064: l_test_security :=
2065: hz_dss_util_pub.test_instance(
2066: p_operation_code => 'UPDATE',
2067: p_db_object_name => 'HZ_PARTY_SITES',

Line 2108: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN

2104: */
2105: -- END IF;
2106:
2107: -- report error on obsolete columns based on profile
2108: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN
2109: check_obsolete_columns (
2110: p_create_update_flag => 'U',
2111: p_party_site_rec => l_party_site_rec,
2112: p_old_party_site_rec => l_old_party_site_rec,