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 605: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then

601: l_cust_account_id := null;
602: l_payment_schedule_id := null;
603:
604: --Start bug 8359894 gnramasa 18th june 09
605: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then
606: OPEN c_summ_info FOR
607: SELECT
608: SUM(NVL(ps.acctd_amount_due_remaining,0)) net_balance,
609: SUM(DECODE(del.status, 'DELINQUENT', NVL(acctd_amount_due_remaining,0),

Line 685: end if; --if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then

681: and sp.org_id=ps.org_id;
682:
683: FETCH c_summ_info INTO x_object_info_rec.current_balance,
684: x_object_info_rec.amount_overdue;
685: end if; --if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then
686:
687: CLOSE c_summ_info;
688: --End bug 8359894 gnramasa 18th june 09
689:

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

689:
690: --Start bug 7612000 gnramasa 4th Dec 08
691: -- If value of "IEX: Exclude dispute amount from remaining amount " is Yes
692: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
693: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
694: select nvl(sum(cm.total_amount * -1),0)
695: into l_amount_in_dispute
696: from ra_cm_requests cm
697: where cm.customer_trx_id in (select distinct ps.customer_trx_id

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

747:
748: --Start bug 7612000 gnramasa 4th Dec 08
749: -- If value of "IEX: Exclude dispute amount from remaining amount " is Yes
750: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
751: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
752: select nvl(sum(cm.total_amount * -1),0)
753: into l_amount_in_dispute
754: from ra_cm_requests cm
755: where cm.customer_trx_id in (select distinct ps.customer_trx_id

Line 785: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then

781:
782: end if; --end if for check on count of currency codes
783:
784: --Start bug 8359894 gnramasa 18th june 09
785: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then
786: /* OPEN c_dso FOR
787: SELECT
788: ROUND(
789: ( (SUM( DECODE(PS.CLASS,

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

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

Line 892: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then

888:
889: end if; --end if for check on count of currency codes(moac change).
890:
891: --Start bug 8359894 gnramasa 18th june 09
892: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then
893: OPEN c_dso FOR
894: SELECT
895: ROUND(
896: ( (SUM( DECODE(PS.CLASS,

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

964:
965: --Start bug 7612000 gnramasa 4th Dec 08
966: -- If value of "IEX: Exclude dispute amount from remaining amount " is Yes
967: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
968: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
969: select nvl(sum(cm.total_amount * -1),0)
970: into l_amount_in_dispute
971: from ra_cm_requests cm
972: where cm.customer_trx_id in (select distinct ps.customer_trx_id

Line 1009: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then

1005:
1006: end if; --end if for check on count of currency codes(moac change).
1007:
1008: --Start bug 8359894 gnramasa 18th june 09
1009: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then
1010: /* OPEN c_dso FOR
1011: SELECT
1012: ROUND(
1013: ( (SUM( DECODE(PS.CLASS,

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

1269:
1270: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':Query: Getting the data');
1271:
1272: -- Begin fix bug #5407151-JYPARK-08/01/2006-Hide 'Last Payment Due On' depending on profile 'IEX_SHOW_LAST_PMT_DUE'
1273: l_show_last_pmt_due := nvl(fnd_profile.value('IEX_SHOW_LAST_PMT_DUE'), 'Y');
1274: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':IEX_SHOW_LAST_PMT_DUE=' || l_show_last_pmt_due);
1275:
1276: IF l_show_last_pmt_due = 'Y' THEN
1277: l_data_query := 'SELECT TRX_SUM.LAST_PAYMENT_DATE, CR.CASH_RECEIPT_ID, ';

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

2119: x_object_info_rec.amount_overdue,
2120: x_object_info_rec.dso;
2121: CLOSE c_summ_info;
2122: */
2123: l_calc_cust_stats := nvl(fnd_profile.value('IEX_CALC_CUST_STATS'), 'A');
2124:
2125: if (l_calc_cust_stats = 'A') then
2126: OPEN c_summ_info1;
2127: FETCH c_summ_info1 INTO x_customer_info_rec.number_of_invoices,

Line 2137: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then

2133: CLOSE c_delinquencies;
2134: end if;
2135:
2136: --Start bug 8359894 gnramasa 18th june 09
2137: if (NVL(FND_PROFILE.VALUE('IEX_SHOW_DSO_IN_HEADER'), 'Y') = 'Y') then
2138: OPEN c_summ_info2;
2139: FETCH c_summ_info2 INTO x_object_info_rec.current_balance,
2140: x_object_info_rec.amount_overdue,
2141: x_object_info_rec.dso;

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

2150:
2151: --Start bug 7612000 gnramasa 4th Dec 08
2152: -- If value of "IEX: Exclude dispute amount from remaining amount " is Yes
2153: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
2154: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
2155: select nvl(sum(cm.total_amount * -1),0)
2156: into l_amount_in_dispute
2157: from ra_cm_requests cm
2158: where cm.customer_trx_id in (select distinct customer_trx_id

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

2906: --set CREATED_BY_MODULE column value depending on lookup HZ_CREATED_BY_MODULES
2907:
2908: l_party_rel_create_rec.application_id := 625;
2909:
2910: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));
2911:
2912: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2913: SELECT hz_parties_s.nextval
2914: INTO l_party_rel_create_rec.party_rec.party_number

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

2908: l_party_rel_create_rec.application_id := 625;
2909:
2910: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));
2911:
2912: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2913: SELECT hz_parties_s.nextval
2914: INTO l_party_rel_create_rec.party_rec.party_number
2915: FROM dual;
2916: ELSE

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

3200: IF l_Call_Api then
3201: l_Party_Site_Create_rec.Party_Id := l_party_id;
3202: l_Party_Site_Create_rec.Location_Id := l_location_id;
3203:
3204: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
3205:
3206: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
3207: SELECT hz_party_sites_s.nextval
3208: INTO l_Party_Site_Create_rec.Party_Site_Number

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

3202: l_Party_Site_Create_rec.Location_Id := l_location_id;
3203:
3204: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
3205:
3206: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
3207: SELECT hz_party_sites_s.nextval
3208: INTO l_Party_Site_Create_rec.Party_Site_Number
3209: FROM dual;
3210: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);

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

3309: END IF;
3310: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3311: END Create_Default_Contact;
3312: BEGIN
3313: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
3314: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
3315: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
3316: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
3317: G_USER_ID := FND_GLOBAL.User_Id;