DBA Data[Home] [Help]

APPS.IEX_UTILITIES dependencies on FND_PROFILE

Line 1716: l_cust_prof_chk := fnd_profile.value('IEX_DUNNING_CUST_PROF_CHECK');

1712:
1713: Begin
1714: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - "Begining of Minimum Dunning Amount check" ');
1715: FND_FILE.PUT_LINE(FND_FILE.LOG,'"Begining of Minimum Dunning Amount check" ');
1716: l_cust_prof_chk := fnd_profile.value('IEX_DUNNING_CUST_PROF_CHECK');
1717: l_dunning_letters :='Y';
1718: l_cust_account_id :=p_cust_account_id;
1719: l_site_use_id :=p_site_use_id;
1720: l_delinquency_id :=p_delinquency_id;

Line 1811: l_func_curr_prf_chk := nvl(fnd_profile.value('IEX_CHK_DUNN_AT_FUNC_CURR'), 'Y');

1807: end if;
1808: end if;
1809: End if;
1810: -- If IEX: Check Dunning amount at functional currency profile is Yes
1811: l_func_curr_prf_chk := nvl(fnd_profile.value('IEX_CHK_DUNN_AT_FUNC_CURR'), 'Y');
1812: if l_func_curr_prf_chk = 'Y' then
1813: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile - IEX: Check Dunning amount at functional currency is YES');
1814: else
1815: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile - IEX: Check Dunning amount at functional currency is NO');

Line 2598: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');

2594: l_cm_ar_amount number:=0;
2595: l_cm_ar_currency_code varchar2(15);
2596: l_rate_type varchar2(100);
2597: Begin
2598: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');
2599: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX: Collections Rate Type = '||l_rate_type);
2600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Functional Currency code= '||p_min_currency_code);
2601: open c_amount_account(p_cust_account_id,p_org_id, p_correspondence_date, p_grace_days, p_dun_disputed_items);
2602: loop

Line 2714: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');

2710: l_cm_ar_amount number;
2711: l_cm_ar_currency_code varchar2(15);
2712: l_rate_type varchar2(100);
2713: Begin
2714: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');
2715: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX: Collections Rate Type = '||l_rate_type);
2716: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Functional Currency code= '||p_min_currency_code);
2717:
2718: open c_amount_billto(p_site_use_id, p_org_id, p_correspondence_date, p_grace_days, p_dun_disputed_items);

Line 3067: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');

3063: l_min_dunning_invoice_amount := 0;
3064: l_cm_ar_amount := 0;
3065:
3066:
3067: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');
3068:
3069: --Start bug 7026222 gnramasa 20th July 08
3070: l_check_dunn_profile := nvl(fnd_profile.value('IEX_CHK_DUNN_AT_FUNC_CURR'), 'Y');
3071: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_check_dunn_prf_val-->'||l_check_dunn_profile);

Line 3070: l_check_dunn_profile := nvl(fnd_profile.value('IEX_CHK_DUNN_AT_FUNC_CURR'), 'Y');

3066:
3067: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');
3068:
3069: --Start bug 7026222 gnramasa 20th July 08
3070: l_check_dunn_profile := nvl(fnd_profile.value('IEX_CHK_DUNN_AT_FUNC_CURR'), 'Y');
3071: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_check_dunn_prf_val-->'||l_check_dunn_profile);
3072: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_rate_type-->'||l_rate_type);
3073: --Begin Bug 10401991 14-Feb-2011 barathsr
3074: l_billto_tot_acctd_amt_rem:=0;

Line 4115: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');

4111: l_inc_inv_curr.delete;
4112:
4113: l_api_name := 'IEX_UTILITIES.StagedDunningMinAmountCheck';
4114:
4115: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');
4116: --Begin Bug 10401991 14-Feb-2011 barathsr
4117: l_billto_tot_acctd_amt_rem:=0;
4118: l_billto_cm_tot_acctd_amt_rem:=0;
4119: l_billto_tot_amt_rem_BR:=0; -- BillsReceivables

Line 5805: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

5801: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
5802: G_USER_ID := FND_GLOBAL.User_Id;
5803: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
5804:
5805: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
5806:
5807: END IEX_UTILITIES;