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_MAP_PARTY_PUB dependencies on FND_PROFILE

Line 1273: l_policy_exist := FND_PROFILE.VALUE_WNPS('HZ_DNB_POLICY_EXIST');

1269:
1270: --Bug 1772241: Add policies if this is the
1271: --first time user uses DNB
1272:
1273: l_policy_exist := FND_PROFILE.VALUE_WNPS('HZ_DNB_POLICY_EXIST');
1274: IF l_policy_exist IS NULL OR l_policy_exist <> 'Y' THEN
1275: do_add_policy_function;
1276:
1277: l_result := FND_PROFILE.SAVE('HZ_DNB_POLICY_EXIST', 'Y', 'SITE');

Line 1277: l_result := FND_PROFILE.SAVE('HZ_DNB_POLICY_EXIST', 'Y', 'SITE');

1273: l_policy_exist := FND_PROFILE.VALUE_WNPS('HZ_DNB_POLICY_EXIST');
1274: IF l_policy_exist IS NULL OR l_policy_exist <> 'Y' THEN
1275: do_add_policy_function;
1276:
1277: l_result := FND_PROFILE.SAVE('HZ_DNB_POLICY_EXIST', 'Y', 'SITE');
1278: IF NOT l_result THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:

Line 1283: l_policy_exist := FND_PROFILE.VALUE('HZ_DNB_POLICY_EXIST');

1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:
1282: --Cache profile in current session
1283: l_policy_exist := FND_PROFILE.VALUE('HZ_DNB_POLICY_EXIST');
1284:
1285: END IF;
1286:
1287: hz_common_pub.disable_cont_source_security;

Line 1288: -- l_update_third_party := NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N');

1284:
1285: END IF;
1286:
1287: hz_common_pub.disable_cont_source_security;
1288: -- l_update_third_party := NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N');
1289: -- set the profile to allow dnb data updatable
1290: -- FND_PROFILE.put('HZ_UPDATE_THIRD_PARTY_DATA', 'Y');
1291:
1292: -- disable user data creation rule

Line 1290: -- FND_PROFILE.put('HZ_UPDATE_THIRD_PARTY_DATA', 'Y');

1286:
1287: hz_common_pub.disable_cont_source_security;
1288: -- l_update_third_party := NVL(FND_PROFILE.value('HZ_UPDATE_THIRD_PARTY_DATA'), 'N');
1289: -- set the profile to allow dnb data updatable
1290: -- FND_PROFILE.put('HZ_UPDATE_THIRD_PARTY_DATA', 'Y');
1291:
1292: -- disable user data creation rule
1293: l_user_data_creation_rule_id := fnd_profile.value('HZ_USER_DATA_CREATION_RULE');
1294: if l_user_data_creation_rule_id is not null then

Line 1293: l_user_data_creation_rule_id := fnd_profile.value('HZ_USER_DATA_CREATION_RULE');

1289: -- set the profile to allow dnb data updatable
1290: -- FND_PROFILE.put('HZ_UPDATE_THIRD_PARTY_DATA', 'Y');
1291:
1292: -- disable user data creation rule
1293: l_user_data_creation_rule_id := fnd_profile.value('HZ_USER_DATA_CREATION_RULE');
1294: if l_user_data_creation_rule_id is not null then
1295: fnd_profile.put('HZ_USER_DATA_CREATION_RULE',null);
1296: end if;
1297:

Line 1295: fnd_profile.put('HZ_USER_DATA_CREATION_RULE',null);

1291:
1292: -- disable user data creation rule
1293: l_user_data_creation_rule_id := fnd_profile.value('HZ_USER_DATA_CREATION_RULE');
1294: if l_user_data_creation_rule_id is not null then
1295: fnd_profile.put('HZ_USER_DATA_CREATION_RULE',null);
1296: end if;
1297:
1298: -- isMixNMatchEnabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES', l_mixnmatch_global_id);
1299: -- arp_util.debug('isMixNMatchEnabled=' || isMixNMatchEnabled);

Line 1832: --FND_PROFILE.put('HZ_UPDATE_THIRD_PARTY_DATA', l_update_third_party);

1828: p_data => x_msg_data);
1829: arp_util.debug('HZ_MAP_PARTY_PUB.MAP (-)');
1830:
1831: hz_common_pub.enable_cont_source_security;
1832: --FND_PROFILE.put('HZ_UPDATE_THIRD_PARTY_DATA', l_update_third_party);
1833:
1834: if l_user_data_creation_rule_id is not null then
1835: fnd_profile.put('HZ_USER_DATA_CREATION_RULE',l_user_data_creation_rule_id);
1836: end if;

Line 1835: fnd_profile.put('HZ_USER_DATA_CREATION_RULE',l_user_data_creation_rule_id);

1831: hz_common_pub.enable_cont_source_security;
1832: --FND_PROFILE.put('HZ_UPDATE_THIRD_PARTY_DATA', l_update_third_party);
1833:
1834: if l_user_data_creation_rule_id is not null then
1835: fnd_profile.put('HZ_USER_DATA_CREATION_RULE',l_user_data_creation_rule_id);
1836: end if;
1837:
1838:
1839: END map;

Line 3301: l_profile_obsolete_col := fnd_profile.value('HZ_API_ERR_ON_OBSOLETE_COLUMN');

3297: l_exist := 'N';
3298: END;
3299: END IF;
3300:
3301: l_profile_obsolete_col := fnd_profile.value('HZ_API_ERR_ON_OBSOLETE_COLUMN');
3302: IF l_profile_obsolete_col = 'Y' THEN
3303: fnd_profile.put('HZ_API_ERR_ON_OBSOLETE_COLUMN', 'N');
3304: END IF;
3305:

Line 3303: fnd_profile.put('HZ_API_ERR_ON_OBSOLETE_COLUMN', 'N');

3299: END IF;
3300:
3301: l_profile_obsolete_col := fnd_profile.value('HZ_API_ERR_ON_OBSOLETE_COLUMN');
3302: IF l_profile_obsolete_col = 'Y' THEN
3303: fnd_profile.put('HZ_API_ERR_ON_OBSOLETE_COLUMN', 'N');
3304: END IF;
3305:
3306: IF l_exist = 'N' THEN
3307:

Line 3315: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN

3311:
3312: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_ORG: party exists, org profile does not exist ');
3313:
3314: --Bug 1721094: generate party number by sequence.
3315: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
3316: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
3317: l_profile := 'N';
3318: END IF;
3319:

Line 3316: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');

3312: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_ORG: party exists, org profile does not exist ');
3313:
3314: --Bug 1721094: generate party number by sequence.
3315: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
3316: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
3317: l_profile := 'N';
3318: END IF;
3319:
3320: p_organization_rec.application_id := 222;

Line 3350: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');

3346: END IF;
3347:
3348: --Bug 1721094: reset profile option.
3349: IF l_profile = 'N' THEN
3350: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');
3351: END IF;
3352:
3353: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_ORG: party does not exist: created party with party_id =' || to_char(p_organization_rec.party_rec.party_id));
3354:

Line 3406: fnd_profile.put('HZ_API_ERR_ON_OBSOLETE_COLUMN', 'Y');

3402:
3403: END IF;
3404:
3405: IF l_profile_obsolete_col = 'Y' THEN
3406: fnd_profile.put('HZ_API_ERR_ON_OBSOLETE_COLUMN', 'Y');
3407: END IF;
3408:
3409: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_ORG (-) ');
3410:

Line 4326: IF fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN

4322:
4323: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_PARTY_SITE (+) ');
4324:
4325: --Bug 1721094: generate party site number by sequence.
4326: IF fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
4327: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER', 'Y');
4328: l_profile := 'N';
4329: END IF;
4330:

Line 4327: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER', 'Y');

4323: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_PARTY_SITE (+) ');
4324:
4325: --Bug 1721094: generate party site number by sequence.
4326: IF fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
4327: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER', 'Y');
4328: l_profile := 'N';
4329: END IF;
4330:
4331: --MOSR changes

Line 4381: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER', 'N');

4377: END IF;
4378:
4379: --Bug 1721094: reset profile option.
4380: IF l_profile = 'N' THEN
4381: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER', 'N');
4382: END IF;
4383:
4384: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_PARTY_SITE: created party site with party_site_id '|| to_char(p_party_site_rec.party_site_id));
4385: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_PARTY_SITE (-) ');

Line 5937: nvl(fnd_profile.value('HZ_DNB_HIER_STOP_CONFORM'),'N') = 'N'

5933: -- IF THIS OPTION DOES NOT EXIST, THE MAPPING PROGRAM WILL ALWAYS CONFORM A PURCHASED PARTY
5934: -- IF THIS OPTION EXISTS, THEN CONFORMATION WILL BE AS PER THE FLAGS MENTIONED ABOVE.
5935:
5936: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
5937: nvl(fnd_profile.value('HZ_DNB_HIER_STOP_CONFORM'),'N') = 'N'
5938: THEN
5939: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
5940: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
5941: l_profile := 'N';

Line 5939: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN

5935:
5936: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
5937: nvl(fnd_profile.value('HZ_DNB_HIER_STOP_CONFORM'),'N') = 'N'
5938: THEN
5939: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
5940: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
5941: l_profile := 'N';
5942: END IF;
5943: HZ_DNB_HIERARCHY_PVT. conform_party_to_dnb_hierarchy ( 'T', conform_party_id, conform_parent_party_id,

Line 5940: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');

5936: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
5937: nvl(fnd_profile.value('HZ_DNB_HIER_STOP_CONFORM'),'N') = 'N'
5938: THEN
5939: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
5940: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
5941: l_profile := 'N';
5942: END IF;
5943: HZ_DNB_HIERARCHY_PVT. conform_party_to_dnb_hierarchy ( 'T', conform_party_id, conform_parent_party_id,
5944: conform_dup_party_id, conform_gup_party_id ,

Line 5948: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');

5944: conform_dup_party_id, conform_gup_party_id ,
5945: conform_parent_flag ,
5946: x_return_status, x_msg_count, x_msg_data );
5947: IF l_profile = 'N' THEN
5948: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');
5949: END IF;
5950: END IF;
5951:
5952:

Line 6199: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN

6195: l_organization_rec.party_rec.orig_system := 'DNB';
6196: l_organization_rec.party_rec.orig_system_reference := lpad(to_char(p_related_duns_rec.DUNS_NUMBER),9,'0');
6197:
6198: --Bug 1721094: generate party number by sequence.
6199: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
6200: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
6201: l_profile := 'N';
6202: END IF;
6203:

Line 6200: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');

6196: l_organization_rec.party_rec.orig_system_reference := lpad(to_char(p_related_duns_rec.DUNS_NUMBER),9,'0');
6197:
6198: --Bug 1721094: generate party number by sequence.
6199: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
6200: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
6201: l_profile := 'N';
6202: END IF;
6203:
6204: l_organization_rec.created_by_module := 'TCA_DNB_MAPPING';

Line 6224: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');

6220: END IF;
6221:
6222: --Bug 1721094: reset profile option.
6223: IF l_profile = 'N' THEN
6224: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');
6225: END IF;
6226:
6227: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6228: RETURN;

Line 6585: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN

6581: IF l_create_rel THEN
6582: p_party_rel_rec.start_date := SYSDATE;
6583:
6584: --Bug 1721094: generate party number by sequence.
6585: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
6586: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
6587: l_profile := 'N';
6588: END IF;
6589:

Line 6586: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');

6582: p_party_rel_rec.start_date := SYSDATE;
6583:
6584: --Bug 1721094: generate party number by sequence.
6585: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
6586: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
6587: l_profile := 'N';
6588: END IF;
6589:
6590: arp_util.debug('HZ_MAP_PARTY_PUB.store_party_rel p_party_rel_rec.subject_id = ' || p_party_rel_rec.subject_id );

Line 6606: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');

6602: l_msg_data);
6603:
6604: --Bug 1721094: reset profile option.
6605: IF l_profile = 'N' THEN
6606: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');
6607: END IF;
6608:
6609: END IF;
6610: