DBA Data[Home] [Help]

APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on FND_PROFILE

Line 90: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

86:
87:
88: PROCEDURE init_package IS
89: BEGIN
90: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
91: g_debug_level := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);
92: END init_package;
93:
94: PROCEDURE debug(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER) IS

Line 91: g_debug_level := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);

87:
88: PROCEDURE init_package IS
89: BEGIN
90: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
91: g_debug_level := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);
92: END init_package;
93:
94: PROCEDURE debug(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER) IS
95: BEGIN

Line 292: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);

288: l_update_geo := FALSE;
289:
290: -- Location Finder Profiles. Check whether Resolve Address needs to be called.
291: IF l_debug THEN
292: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);
293: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
294: END IF;
295:
296: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y')

Line 293: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);

289:
290: -- Location Finder Profiles. Check whether Resolve Address needs to be called.
291: IF l_debug THEN
292: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);
293: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
294: END IF;
295:
296: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y')
297: AND (NVL(fnd_profile.VALUE('CREATELOCATION'),'N') = 'Y');

Line 296: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y')

292: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);
293: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
294: END IF;
295:
296: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y')
297: AND (NVL(fnd_profile.VALUE('CREATELOCATION'),'N') = 'Y');
298:
299: IF l_call_lf THEN
300: IF NVL(p_address4,'_') <> '_' AND is_address_line_valid(p_address4, p_country_code) THEN

Line 297: AND (NVL(fnd_profile.VALUE('CREATELOCATION'),'N') = 'Y');

293: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
294: END IF;
295:
296: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y')
297: AND (NVL(fnd_profile.VALUE('CREATELOCATION'),'N') = 'Y');
298:
299: IF l_call_lf THEN
300: IF NVL(p_address4,'_') <> '_' AND is_address_line_valid(p_address4, p_country_code) THEN
301: l_roadname := p_address4;

Line 796: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN

792:
793:
794: -- If the profile "Generate Party Number" is No, then
795: -- TCA expects the caller to pass the party number.
796: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
797: SELECT hz_party_number_s.NEXTVAL INTO l_person_rec.party_rec.party_number
798: FROM dual;
799: END IF;
800:

Line 845: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN

841: l_party_site_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'
842:
843: -- If the profile "Generate Party Number" is No, then
844: -- TCA expects the caller to pass the party number.
845: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
846: SELECT hz_party_site_number_s.NEXTVAL INTO l_party_site_rec.party_site_number
847: FROM dual;
848: END IF;
849: