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 1775: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN

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

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

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

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

2066:
2067: --- Bug 2486394 Check if the DSS security is granted to the user
2068: -- Bug 3818648: check dss profile before call test_instance.
2069: --
2070: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
2071: l_test_security :=
2072: hz_dss_util_pub.test_instance(
2073: p_operation_code => 'UPDATE',
2074: p_db_object_name => 'HZ_PARTY_SITES',

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

2111: */
2112: -- END IF;
2113:
2114: -- report error on obsolete columns based on profile
2115: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN
2116: check_obsolete_columns (
2117: p_create_update_flag => 'U',
2118: p_party_site_rec => l_party_site_rec,
2119: p_old_party_site_rec => l_old_party_site_rec,