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

Line 153: l_calc_cust_stats := nvl(fnd_profile.value('IEX_CALC_CUST_STATS'), 'A');

149: --OPEN c_summ_info;
150: --FETCH c_summ_info INTO x_customer_info_rec.number_of_invoices,
151: -- x_customer_info_rec.invoices_overdue;
152: --CLOSE c_summ_info;
153: l_calc_cust_stats := nvl(fnd_profile.value('IEX_CALC_CUST_STATS'), 'A');
154: if (l_calc_cust_stats = 'A') then
155: OPEN c_collectible_trx;
156: FETCH c_collectible_trx INTO x_customer_info_rec.number_of_invoices;
157: CLOSE c_collectible_trx;

Line 615: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then

611:
612: --Start bug 7612000 gnramasa 4th Dec 08
613: -- If value of "IEX: Exclude dispute amount from remaining amount " is Yes
614: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
615: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
616: select nvl(sum(cm.total_amount * -1),0)
617: into l_amount_in_dispute
618: from ra_cm_requests cm
619: where cm.customer_trx_id in (select distinct ps.customer_trx_id

Line 671: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then

667:
668: --Start bug 7612000 gnramasa 4th Dec 08
669: -- If value of "IEX: Exclude dispute amount from remaining amount " is Yes
670: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
671: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
672: select nvl(sum(cm.total_amount * -1),0)
673: into l_amount_in_dispute
674: from ra_cm_requests cm
675: where cm.customer_trx_id in (select distinct ps.customer_trx_id

Line 777: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then

773:
774: --Start bug 7612000 gnramasa 4th Dec 08
775: -- If value of "IEX: Exclude dispute amount from remaining amount " is Yes
776: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
777: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
778: select nvl(sum(cm.total_amount * -1),0)
779: into l_amount_in_dispute
780: from ra_cm_requests cm
781: where cm.customer_trx_id in

Line 870: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then

866:
867: --Start bug 7612000 gnramasa 4th Dec 08
868: -- If value of "IEX: Exclude dispute amount from remaining amount " is Yes
869: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
870: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
871: select nvl(sum(cm.total_amount * -1),0)
872: into l_amount_in_dispute
873: from ra_cm_requests cm
874: where cm.customer_trx_id in (select distinct ps.customer_trx_id

Line 1163: l_show_last_pmt_due := nvl(fnd_profile.value('IEX_SHOW_LAST_PMT_DUE'), 'Y');

1159:
1160: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: Getting the data');
1161:
1162: -- Begin fix bug #5407151-JYPARK-08/01/2006-Hide 'Last Payment Due On' depending on profile 'IEX_SHOW_LAST_PMT_DUE'
1163: l_show_last_pmt_due := nvl(fnd_profile.value('IEX_SHOW_LAST_PMT_DUE'), 'Y');
1164: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':IEX_SHOW_LAST_PMT_DUE=' || l_show_last_pmt_due);
1165:
1166: IF l_show_last_pmt_due = 'Y' THEN
1167: l_data_query := 'SELECT TRX_SUM.LAST_PAYMENT_DATE, CR.CASH_RECEIPT_ID, ';

Line 1991: l_calc_cust_stats := nvl(fnd_profile.value('IEX_CALC_CUST_STATS'), 'A');

1987: x_object_info_rec.amount_overdue,
1988: x_object_info_rec.dso;
1989: CLOSE c_summ_info;
1990: */
1991: l_calc_cust_stats := nvl(fnd_profile.value('IEX_CALC_CUST_STATS'), 'A');
1992:
1993: if (l_calc_cust_stats = 'A') then
1994: OPEN c_summ_info1;
1995: FETCH c_summ_info1 INTO x_customer_info_rec.number_of_invoices,

Line 2013: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then

2009:
2010: --Start bug 7612000 gnramasa 4th Dec 08
2011: -- If value of "IEX: Exclude dispute amount from remaining amount " is Yes
2012: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
2013: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
2014: select nvl(sum(cm.total_amount * -1),0)
2015: into l_amount_in_dispute
2016: from ra_cm_requests cm
2017: where cm.customer_trx_id in (select distinct customer_trx_id

Line 2680: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));

2676: END IF;
2677: --End-fix bug#4604755-JYPARK-09/12/2005-When create 'Collections'/'Dunning' default contact in Collections, set CREATED_BY_MODULE column value depending on lookup HZ_CREATED_BY_MODULES
2678: l_party_rel_create_rec.application_id := 625;
2679:
2680: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));
2681:
2682: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2683: SELECT hz_parties_s.nextval
2684: INTO l_party_rel_create_rec.party_rec.party_number

Line 2682: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN

2678: l_party_rel_create_rec.application_id := 625;
2679:
2680: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));
2681:
2682: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2683: SELECT hz_parties_s.nextval
2684: INTO l_party_rel_create_rec.party_rec.party_number
2685: FROM dual;
2686: ELSE

Line 2885: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));

2881: IF l_Call_Api then
2882: l_Party_Site_Create_rec.Party_Id := l_party_id;
2883: l_Party_Site_Create_rec.Location_Id := p_location_id;
2884:
2885: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
2886:
2887: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2888: SELECT hz_party_sites_s.nextval
2889: INTO l_Party_Site_Create_rec.Party_Site_Number

Line 2887: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN

2883: l_Party_Site_Create_rec.Location_Id := p_location_id;
2884:
2885: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
2886:
2887: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2888: SELECT hz_party_sites_s.nextval
2889: INTO l_Party_Site_Create_rec.Party_Site_Number
2890: FROM dual;
2891: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);

Line 2952: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));

2948: IF l_Call_Api then
2949: l_Party_Site_Create_rec.Party_Id := l_party_id;
2950: l_Party_Site_Create_rec.Location_Id := p_location_id;
2951:
2952: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
2953:
2954: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2955: SELECT hz_party_sites_s.nextval
2956: INTO l_Party_Site_Create_rec.Party_Site_Number

Line 2954: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN

2950: l_Party_Site_Create_rec.Location_Id := p_location_id;
2951:
2952: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
2953:
2954: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2955: SELECT hz_party_sites_s.nextval
2956: INTO l_Party_Site_Create_rec.Party_Site_Number
2957: FROM dual;
2958: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);

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

3026: END IF;
3027: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3028: END Create_Default_Contact;
3029: BEGIN
3030: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
3031: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
3032: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
3033: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
3034: G_USER_ID := FND_GLOBAL.User_Id;