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

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

101:
102:
103: -- Code added for Bug 4079902.
104:
105: l_result := FND_PROFILE.SAVE('HZ_DNB_POLICY_EXIST','Y','SITE');
106:
107: IF NOT l_result THEN
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;

Line 3789: l_profile_version_prof := NVL(FND_PROFILE.value('HZ_PROFILE_VERSION'), 'ONE_DAY_VERSION');

3785: );
3786: END IF;
3787: END IF;
3788:
3789: l_profile_version_prof := NVL(FND_PROFILE.value('HZ_PROFILE_VERSION'), 'ONE_DAY_VERSION');
3790:
3791: /* If it's after stage 1 then
3792: if batch status = ACTION_REQUIRED, this run is for
3793: what-if analysis and is done, exit.

Line 3845: l_g_miss_num := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_NUM'), -9999);

3841: /* Save who column values in variables for performance */
3842: l_user_id := NVL(FND_GLOBAL.user_id,-1);
3843: l_resp_appl_id := hz_utility_v2pub.application_id;
3844: l_last_update_login := hz_utility_v2pub.last_update_login;
3845: l_g_miss_num := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_NUM'), -9999);
3846: l_g_miss_char := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_CHAR'), '!');
3847: l_g_miss_date := NVL(to_date(FND_PROFILE.value('HZ_IMP_G_MISS_DATE'), 'DD/MM/YYYY'),
3848: to_date('01/01/4000', 'DD/MM/YYYY'));
3849: l_flex_validation_prof := NVL(l_flex_validation_prof,NVL(FND_PROFILE.value('HZ_IMP_FLEX_VALIDATION'), 'N'));

Line 3846: l_g_miss_char := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_CHAR'), '!');

3842: l_user_id := NVL(FND_GLOBAL.user_id,-1);
3843: l_resp_appl_id := hz_utility_v2pub.application_id;
3844: l_last_update_login := hz_utility_v2pub.last_update_login;
3845: l_g_miss_num := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_NUM'), -9999);
3846: l_g_miss_char := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_CHAR'), '!');
3847: l_g_miss_date := NVL(to_date(FND_PROFILE.value('HZ_IMP_G_MISS_DATE'), 'DD/MM/YYYY'),
3848: to_date('01/01/4000', 'DD/MM/YYYY'));
3849: l_flex_validation_prof := NVL(l_flex_validation_prof,NVL(FND_PROFILE.value('HZ_IMP_FLEX_VALIDATION'), 'N'));
3850: l_dss_security_prof := NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N');

Line 3847: l_g_miss_date := NVL(to_date(FND_PROFILE.value('HZ_IMP_G_MISS_DATE'), 'DD/MM/YYYY'),

3843: l_resp_appl_id := hz_utility_v2pub.application_id;
3844: l_last_update_login := hz_utility_v2pub.last_update_login;
3845: l_g_miss_num := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_NUM'), -9999);
3846: l_g_miss_char := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_CHAR'), '!');
3847: l_g_miss_date := NVL(to_date(FND_PROFILE.value('HZ_IMP_G_MISS_DATE'), 'DD/MM/YYYY'),
3848: to_date('01/01/4000', 'DD/MM/YYYY'));
3849: l_flex_validation_prof := NVL(l_flex_validation_prof,NVL(FND_PROFILE.value('HZ_IMP_FLEX_VALIDATION'), 'N'));
3850: l_dss_security_prof := NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N');
3851: l_allow_disabled_lookup_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_DISABLED_LOOKUP'), 'Y');

Line 3849: l_flex_validation_prof := NVL(l_flex_validation_prof,NVL(FND_PROFILE.value('HZ_IMP_FLEX_VALIDATION'), 'N'));

3845: l_g_miss_num := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_NUM'), -9999);
3846: l_g_miss_char := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_CHAR'), '!');
3847: l_g_miss_date := NVL(to_date(FND_PROFILE.value('HZ_IMP_G_MISS_DATE'), 'DD/MM/YYYY'),
3848: to_date('01/01/4000', 'DD/MM/YYYY'));
3849: l_flex_validation_prof := NVL(l_flex_validation_prof,NVL(FND_PROFILE.value('HZ_IMP_FLEX_VALIDATION'), 'N'));
3850: l_dss_security_prof := NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N');
3851: l_allow_disabled_lookup_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_DISABLED_LOOKUP'), 'Y');
3852: l_update_str_addr_prof := NVL(FND_PROFILE.value('HZ_UPDATE_STD_ADDRESS'), 'N');
3853: l_maintain_loc_hist_prof := NVL(FND_PROFILE.value('HZ_MAINTAIN_LOC_HISTORY'), 'Y');

Line 3850: l_dss_security_prof := NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N');

3846: l_g_miss_char := NVL(FND_PROFILE.value('HZ_IMP_G_MISS_CHAR'), '!');
3847: l_g_miss_date := NVL(to_date(FND_PROFILE.value('HZ_IMP_G_MISS_DATE'), 'DD/MM/YYYY'),
3848: to_date('01/01/4000', 'DD/MM/YYYY'));
3849: l_flex_validation_prof := NVL(l_flex_validation_prof,NVL(FND_PROFILE.value('HZ_IMP_FLEX_VALIDATION'), 'N'));
3850: l_dss_security_prof := NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N');
3851: l_allow_disabled_lookup_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_DISABLED_LOOKUP'), 'Y');
3852: l_update_str_addr_prof := NVL(FND_PROFILE.value('HZ_UPDATE_STD_ADDRESS'), 'N');
3853: l_maintain_loc_hist_prof := NVL(FND_PROFILE.value('HZ_MAINTAIN_LOC_HISTORY'), 'Y');
3854: l_allow_addr_corr_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_ADDR_CORRECTION'), 'Y');

Line 3851: l_allow_disabled_lookup_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_DISABLED_LOOKUP'), 'Y');

3847: l_g_miss_date := NVL(to_date(FND_PROFILE.value('HZ_IMP_G_MISS_DATE'), 'DD/MM/YYYY'),
3848: to_date('01/01/4000', 'DD/MM/YYYY'));
3849: l_flex_validation_prof := NVL(l_flex_validation_prof,NVL(FND_PROFILE.value('HZ_IMP_FLEX_VALIDATION'), 'N'));
3850: l_dss_security_prof := NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N');
3851: l_allow_disabled_lookup_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_DISABLED_LOOKUP'), 'Y');
3852: l_update_str_addr_prof := NVL(FND_PROFILE.value('HZ_UPDATE_STD_ADDRESS'), 'N');
3853: l_maintain_loc_hist_prof := NVL(FND_PROFILE.value('HZ_MAINTAIN_LOC_HISTORY'), 'Y');
3854: l_allow_addr_corr_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_ADDR_CORRECTION'), 'Y');
3855:

Line 3852: l_update_str_addr_prof := NVL(FND_PROFILE.value('HZ_UPDATE_STD_ADDRESS'), 'N');

3848: to_date('01/01/4000', 'DD/MM/YYYY'));
3849: l_flex_validation_prof := NVL(l_flex_validation_prof,NVL(FND_PROFILE.value('HZ_IMP_FLEX_VALIDATION'), 'N'));
3850: l_dss_security_prof := NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N');
3851: l_allow_disabled_lookup_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_DISABLED_LOOKUP'), 'Y');
3852: l_update_str_addr_prof := NVL(FND_PROFILE.value('HZ_UPDATE_STD_ADDRESS'), 'N');
3853: l_maintain_loc_hist_prof := NVL(FND_PROFILE.value('HZ_MAINTAIN_LOC_HISTORY'), 'Y');
3854: l_allow_addr_corr_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_ADDR_CORRECTION'), 'Y');
3855:
3856: /* Hardcode date format mask as P_SYSDATE is passed from main

Line 3853: l_maintain_loc_hist_prof := NVL(FND_PROFILE.value('HZ_MAINTAIN_LOC_HISTORY'), 'Y');

3849: l_flex_validation_prof := NVL(l_flex_validation_prof,NVL(FND_PROFILE.value('HZ_IMP_FLEX_VALIDATION'), 'N'));
3850: l_dss_security_prof := NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N');
3851: l_allow_disabled_lookup_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_DISABLED_LOOKUP'), 'Y');
3852: l_update_str_addr_prof := NVL(FND_PROFILE.value('HZ_UPDATE_STD_ADDRESS'), 'N');
3853: l_maintain_loc_hist_prof := NVL(FND_PROFILE.value('HZ_MAINTAIN_LOC_HISTORY'), 'Y');
3854: l_allow_addr_corr_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_ADDR_CORRECTION'), 'Y');
3855:
3856: /* Hardcode date format mask as P_SYSDATE is passed from main
3857: wrapper and it hardcodes with this date format */

Line 3854: l_allow_addr_corr_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_ADDR_CORRECTION'), 'Y');

3850: l_dss_security_prof := NVL(FND_PROFILE.value('HZ_IMP_DSS_SECURITY'), 'N');
3851: l_allow_disabled_lookup_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_DISABLED_LOOKUP'), 'Y');
3852: l_update_str_addr_prof := NVL(FND_PROFILE.value('HZ_UPDATE_STD_ADDRESS'), 'N');
3853: l_maintain_loc_hist_prof := NVL(FND_PROFILE.value('HZ_MAINTAIN_LOC_HISTORY'), 'Y');
3854: l_allow_addr_corr_prof := NVL(FND_PROFILE.value('HZ_IMP_ALLOW_ADDR_CORRECTION'), 'Y');
3855:
3856: /* Hardcode date format mask as P_SYSDATE is passed from main
3857: wrapper and it hardcodes with this date format */
3858: D_SYSDATE := TO_DATE(P_SYSDATE,'DD-MM-YY HH24:MI:SS');

Line 3870: NVL(fnd_profile.value('HZ_DNB_POLICY_EXIST'), 'N') = 'N' THEN

3866:
3867: /* Add policy function if not exists */
3868:
3869: IF l_content_src_type <> 'USER_ENTERED' AND
3870: NVL(fnd_profile.value('HZ_DNB_POLICY_EXIST'), 'N') = 'N' THEN
3871:
3872: /* bug fix 3849232 - add policy functions unconditionally */
3873: add_policy();
3874: END IF;

Line 3878: IF NVL(FND_PROFILE.value('HZ_IMP_HR_SECURITY'), 'N') = 'Y' THEN

3874: END IF;
3875:
3876:
3877: /* Check HR security */
3878: IF NVL(FND_PROFILE.value('HZ_IMP_HR_SECURITY'), 'N') = 'Y' THEN
3879: -- ARH2RGVB.pls
3880: /*
3881: check in the Parties Interface Table if there are any records
3882: with OS='DEFAULT' and OSR = 'PER%' (because that's how HR data

Line 4076: NVL(P_ERROR_LIMIT, NVL(FND_PROFILE.value('HZ_IMP_ERROR_LIMIT'), 10000)) THEN

4072: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;
4073:
4074: -- if error is greater than error limit
4075: IF l_current_error_id - l_start_error_id >=
4076: NVL(P_ERROR_LIMIT, NVL(FND_PROFILE.value('HZ_IMP_ERROR_LIMIT'), 10000)) THEN
4077:
4078: -- update batch summary table and detail table
4079: -- set status as complete with reaching error limit
4080:

Line 4251: NVL(P_ERROR_LIMIT, NVL(FND_PROFILE.value('HZ_IMP_ERROR_LIMIT'), 10000)),

4247: TRUE,
4248: P_BATCH_ID,
4249: l_content_src_type,
4250: P_RERUN_FLAG,
4251: NVL(P_ERROR_LIMIT, NVL(FND_PROFILE.value('HZ_IMP_ERROR_LIMIT'), 10000)),
4252: P_BATCH_MODE_FLAG,
4253: l_user_id,
4254: --bug 3932987
4255: --D_SYSDATE,

Line 4285: NVL(P_ERROR_LIMIT, NVL(FND_PROFILE.value('HZ_IMP_ERROR_LIMIT'), 10000)),

4281: TRUE,
4282: P_BATCH_ID,
4283: l_content_src_type,
4284: P_RERUN_FLAG,
4285: NVL(P_ERROR_LIMIT, NVL(FND_PROFILE.value('HZ_IMP_ERROR_LIMIT'), 10000)),
4286: P_BATCH_MODE_FLAG,
4287: l_user_id,
4288: --bug 3932987
4289: --D_SYSDATE,

Line 4615: profile_unit_size := NVL(FND_PROFILE.value('HZ_IMP_WORK_UNIT_SIZE'),

4611:
4612: BEGIN
4613:
4614: -- retrieve profile option of work unit size
4615: profile_unit_size := NVL(FND_PROFILE.value('HZ_IMP_WORK_UNIT_SIZE'),
4616: to_char(WORK_UNIT_CAP_SIZE));
4617: unit_size := to_number(profile_unit_size);
4618: if(unit_size>WORK_UNIT_CAP_SIZE or
4619: unit_size<=0) then