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.CSF_RESOURCE_ADDRESS_PVT dependencies on FND_PROFILE

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

127:
128:
129: PROCEDURE init_package IS
130: BEGIN
131: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
132: g_debug_level := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);
133: END init_package;
134:
135: PROCEDURE debug(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER) IS

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

128:
129: PROCEDURE init_package IS
130: BEGIN
131: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
132: g_debug_level := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);
133: END init_package;
134:
135: PROCEDURE debug(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER) IS
136: BEGIN

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

364: l_update_addr := NVL(fnd_api.to_boolean(p_update_address), FALSE);
365:
366: -- Location Finder Profiles. Check whether Resolve Address needs to be called.
367: IF l_debug THEN
368: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);
369: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
370: END IF;
371:
372: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y');

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

365:
366: -- Location Finder Profiles. Check whether Resolve Address needs to be called.
367: IF l_debug THEN
368: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);
369: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
370: END IF;
371:
372: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y');
373: -- AND (NVL(fnd_profile.VALUE('CREATELOCATION'),'N') = 'Y'); -- Create Location profile is no more used.

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

368: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);
369: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
370: END IF;
371:
372: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y');
373: -- AND (NVL(fnd_profile.VALUE('CREATELOCATION'),'N') = 'Y'); -- Create Location profile is no more used.
374:
375: IF (l_call_lf AND (NOT csf_locus_pub.is_manual_geometry(l_geometry)))
376: /*

Line 373: -- AND (NVL(fnd_profile.VALUE('CREATELOCATION'),'N') = 'Y'); -- Create Location profile is no more used.

369: debug('CSR: Create Location = ' || fnd_profile.VALUE('CREATELOCATION'), l_api_name, fnd_log.level_statement);
370: END IF;
371:
372: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y');
373: -- AND (NVL(fnd_profile.VALUE('CREATELOCATION'),'N') = 'Y'); -- Create Location profile is no more used.
374:
375: IF (l_call_lf AND (NOT csf_locus_pub.is_manual_geometry(l_geometry)))
376: /*
377: IF NVL(p_address4,'_') <> '_' AND is_address_line_valid(p_address4, p_country_code) THEN

Line 388: l_roadname := CASE nvl(fnd_profile.value('CSF_STREET_LINE_FOR_LF'), 'ADDR1')

384: l_roadname := p_address1;
385: END IF; */
386: THEN
387: --Fix: 9981216.
388: l_roadname := CASE nvl(fnd_profile.value('CSF_STREET_LINE_FOR_LF'), 'ADDR1')
389: WHEN 'ADDR1' THEN p_address1
390: WHEN 'ADDR2' THEN p_address2
391: WHEN 'ADDR3' THEN p_address3
392: WHEN 'ADDR4' THEN p_address4

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

931:
932:
933: -- If the profile "Generate Party Number" is No, then
934: -- TCA expects the caller to pass the party number.
935: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
936: SELECT hz_party_number_s.NEXTVAL INTO l_person_rec.party_rec.party_number
937: FROM dual;
938: END IF;
939:

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

980: l_party_site_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'
981:
982: -- If the profile "Generate Party Number" is No, then
983: -- TCA expects the caller to pass the party number.
984: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
985: SELECT hz_party_site_number_s.NEXTVAL INTO l_party_site_rec.party_site_number
986: FROM dual;
987: END IF;
988:

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

1221: IF l_validate_address AND p_resource_type IN ('RS_EMPLOYEE', 'RS_PARTY') THEN
1222: IF l_debug THEN
1223: debug('Resolving the Address again', l_api_name, fnd_log.level_statement);
1224: END IF;
1225: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y');
1226: l_skip_eloc := (NVL(fnd_profile.VALUE('CSF_SPATIAL_SKIP_ELOCATION'),'N') = 'N');
1227: IF(l_call_lf OR l_skip_eloc) THEN
1228: resolve_address(
1229: p_api_version => l_api_version

Line 1226: l_skip_eloc := (NVL(fnd_profile.VALUE('CSF_SPATIAL_SKIP_ELOCATION'),'N') = 'N');

1222: IF l_debug THEN
1223: debug('Resolving the Address again', l_api_name, fnd_log.level_statement);
1224: END IF;
1225: l_call_lf := (NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'Y');
1226: l_skip_eloc := (NVL(fnd_profile.VALUE('CSF_SPATIAL_SKIP_ELOCATION'),'N') = 'N');
1227: IF(l_call_lf OR l_skip_eloc) THEN
1228: resolve_address(
1229: p_api_version => l_api_version
1230: , x_return_status => x_return_status

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

1446:
1447:
1448: -- If the profile "Generate Party Number" is No, then
1449: -- TCA expects the caller to pass the party number.
1450: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
1451: SELECT hz_party_number_s.NEXTVAL INTO l_person_rec.party_rec.party_number
1452: FROM dual;
1453: END IF;
1454:

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

1495: l_party_site_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'
1496:
1497: -- If the profile "Generate Party Number" is No, then
1498: -- TCA expects the caller to pass the party number.
1499: IF fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
1500: SELECT hz_party_site_number_s.NEXTVAL INTO l_party_site_rec.party_site_number
1501: FROM dual;
1502: END IF;
1503: