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

Line 3678: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PARTY'));

3674:
3675: ----- Begin PARTY SEARCH -----
3676: -- Get rule_id from profile
3677: IF I.party_type = 'ORGANIZATION' THEN
3678: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PARTY'));
3679: ELSIF I.party_type = 'PERSON' THEN
3680: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PERSON'));
3681: ELSE
3682: --else bad party_type

Line 3680: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PERSON'));

3676: -- Get rule_id from profile
3677: IF I.party_type = 'ORGANIZATION' THEN
3678: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PARTY'));
3679: ELSIF I.party_type = 'PERSON' THEN
3680: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PERSON'));
3681: ELSE
3682: --else bad party_type
3683: AS_UTILITY_PVT.Set_Message(
3684: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 3726: l_activate_flag := NVL(FND_PROFILE.value('AS_ACTIVATE_PARTIES_FROM_IMPORT'), 'N');

3722: IF l_num_matches > 0 THEN
3723: -- A possible duplicate has been found.
3724: -- Get the party id the matched parties having highest score.
3725: -- SOLIN, Bug 3528579
3726: l_activate_flag := NVL(FND_PROFILE.value('AS_ACTIVATE_PARTIES_FROM_IMPORT'), 'N');
3727: IF l_activate_flag = 'N'
3728: THEN
3729: OPEN C_matched_party(I.party_type);
3730: FETCH C_matched_party INTO l_party_id, l_score, l_creation_date;

Line 3809: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PARTY_SITE'));

3805: write_log(3,'#2 :: Calling GET_MATCHING_PARTY_SITES with party_id: '||to_char(I.party_id));
3806:
3807: -- SOLIN, Bug 4942209
3808: -- create a new rule profile for DQM party site match
3809: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PARTY_SITE'));
3810: HZ_PARTY_SEARCH.get_matching_party_sites ('T',l_rule_id, I.party_id, party_site_cond,
3811: contact_point_cond, l_search_context_id, l_return_status, l_msg_count, l_msg_data);
3812:
3813: IF l_return_status <> FND_API.g_ret_sts_success THEN

Line 3859: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_CONTACT'));

3855: IF I.first_name IS NOT NULL AND I.last_name IS NOT NULL THEN --3
3856: IF I.party_id IS NOT NULL THEN --4
3857: write_log(3,'#3 :: Calling GET_MATCHING_CONTACTS with party_id: '||to_char(I.party_id));
3858:
3859: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_CONTACT'));
3860: HZ_PARTY_SEARCH.get_matching_contacts('T',l_rule_id, I.party_id, contact_cond, contact_point_cond,
3861: l_search_context_id, l_return_status, l_msg_count, l_msg_data);
3862:
3863: IF l_return_status <> FND_API.g_ret_sts_success THEN

Line 3893: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PERSON'));

3889: --Reset values for person search
3890: party_cond.party_type := 'PERSON';
3891: party_cond.party_name := I.first_name||' '||I.last_name;
3892:
3893: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_PERSON'));
3894: HZ_PARTY_SEARCH.find_parties ('T',l_rule_id, party_cond, party_site_cond, contact_cond , contact_point_cond, NULL,
3895: 'N',l_search_context_id, l_num_matches, l_return_status, l_msg_count, l_msg_data);
3896:
3897: IF l_num_matches > 0 THEN --match found

Line 3942: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_CONTACT'));

3938: (I.party_type <> 'ORGANIZATION' and I.party_id is not null) THEN
3939: IF l_contact_provided = 'N' AND I.first_name IS NOT NULL AND I.last_name IS NOT NULL THEN
3940: IF I.email_address IS NOT NULL or I.phone_number IS NOT NULL THEN
3941: write_log(3,'#4 :: Calling GET_MATCHING_CONTACT_POINTS with party_id: '||to_char(I.party_id));
3942: l_rule_id := to_number(FND_PROFILE.value('AS_USE_DQM_RULE_CODE_CONTACT'));
3943: HZ_PARTY_SEARCH.get_matching_contact_points('T',l_rule_id, I.party_id, contact_point_cond, l_search_context_id, l_return_status, l_msg_count, l_msg_data);
3944:
3945: IF l_return_status <> FND_API.g_ret_sts_success THEN
3946: RAISE FND_API.g_exc_error;

Line 4167: G_SL_SALESFORCE_ID := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');

4163: FETCH C_Get_SLAESFORCE INTO G_SL_SALESFORCE_ID;
4164: CLOSE C_Get_SLAESFORCE;
4165:
4166: If (G_SL_SALESFORCE_ID is null) then
4167: G_SL_SALESFORCE_ID := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
4168: end if;
4169:
4170: -- Find the sales group of the person being added
4171: -- bugfix # 2772260

Line 4192: l_hz_execute_api_callouts := fnd_profile.value('HZ_EXECUTE_API_CALLOUTS');

4188: WHERE lookup_type = 'SOURCE_SYSTEM'
4189: AND lookup_code = p_source_system;
4190:
4191: -- SOLIN, bug 4494009
4192: l_hz_execute_api_callouts := fnd_profile.value('HZ_EXECUTE_API_CALLOUTS');
4193: write_log(3, 'Profile HZ_EXECUTE_API_CALLOUTS: '|| l_hz_execute_api_callouts);
4194: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS', 'N');
4195: -- SOLIN, end
4196:

Line 4194: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS', 'N');

4190:
4191: -- SOLIN, bug 4494009
4192: l_hz_execute_api_callouts := fnd_profile.value('HZ_EXECUTE_API_CALLOUTS');
4193: write_log(3, 'Profile HZ_EXECUTE_API_CALLOUTS: '|| l_hz_execute_api_callouts);
4194: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS', 'N');
4195: -- SOLIN, end
4196:
4197: -- For each lead
4198: For I in c_main(p_parent_request_id, p_child_request_id)

Line 4245: -- l_currency_code := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');

4241: --OPEN C_currency_code(I.country);
4242: --FETCH C_currency_code INTO l_currency_code;
4243: --IF C_currency_code%NOTFOUND THEN
4244: -- Set default currency
4245: -- l_currency_code := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
4246: --END IF;
4247: --CLOSE C_currency_code;
4248: --I.currency_code := l_currency_code;
4249: END IF; --if currency_code is null

Line 4254: IF (fnd_profile.value ('AS_LEAD_IMP_EXEC_CUSTOM_CODE')='Y') Then

4250: write_log(3, 'Value of currency :'||I.currency_code);
4251: -- End enh: Support for Currency
4252:
4253: -- Check profile for executing custom hook
4254: IF (fnd_profile.value ('AS_LEAD_IMP_EXEC_CUSTOM_CODE')='Y') Then
4255:
4256: write_log(3, 'Before calling custom hook for party match');
4257: -- Call custom hook
4258: aml_find_party_match_pvt.main(I, --IN OUT param

Line 4679: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS', l_hz_execute_api_callouts);

4675: End Loop;
4676:
4677: -- SOLIN, bug 4494009
4678: -- Set profile back to its original value
4679: fnd_profile.put('HZ_EXECUTE_API_CALLOUTS', l_hz_execute_api_callouts);
4680: -- SOLIN, end
4681:
4682: write_log(2, 'Batch Size:'|| l_batch_size);
4683: write_log(1, 'Batch Size:'|| l_batch_size);

Line 4819: l_batch_size := nvl(to_number(FND_PROFILE.value('AS_MIN_REC_PARALLEL_FOR_IMPORT')),0);

4815: --Get conc_request_id
4816: l_request_id := nvl(FND_GLOBAL.conc_request_id, -1);
4817:
4818: --Get the batch size for each thread from profile
4819: l_batch_size := nvl(to_number(FND_PROFILE.value('AS_MIN_REC_PARALLEL_FOR_IMPORT')),0);
4820:
4821: --Get interaction threshold
4822: l_interaction_threshold := nvl(FND_PROFILE.value('AS_INTERACTION_SCORE_THRESHOLD'),0);
4823:

Line 4822: l_interaction_threshold := nvl(FND_PROFILE.value('AS_INTERACTION_SCORE_THRESHOLD'),0);

4818: --Get the batch size for each thread from profile
4819: l_batch_size := nvl(to_number(FND_PROFILE.value('AS_MIN_REC_PARALLEL_FOR_IMPORT')),0);
4820:
4821: --Get interaction threshold
4822: l_interaction_threshold := nvl(FND_PROFILE.value('AS_INTERACTION_SCORE_THRESHOLD'),0);
4823:
4824: --If profile is set to -ve value
4825: If l_batch_size < 0 then
4826: l_batch_size := 0;