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

Line 620: l_profile_values := fnd_profile.value_specific('IBE_ORDER_LEAD_INTERVAL', null, null, null);

616: l_import_mode VARCHAR2(15);
617: BEGIN
618: printDebug('Inside get_Date_Period ' || p_lead_type, 'Get_Date_Period');
619: if( p_lead_type = G_ORDER_LEAD ) then
620: l_profile_values := fnd_profile.value_specific('IBE_ORDER_LEAD_INTERVAL', null, null, null);
621: l_interval := to_number(NVL(trim(l_profile_values),'1'));
622: elsif ( p_lead_type = G_QUOTE_LEAD ) then
623: l_profile_values := fnd_profile.value_specific('IBE_QUOTE_LEAD_INTERVAL', null, null,null);
624: l_interval := to_number(NVL(trim(l_profile_values),'1'));

Line 623: l_profile_values := fnd_profile.value_specific('IBE_QUOTE_LEAD_INTERVAL', null, null,null);

619: if( p_lead_type = G_ORDER_LEAD ) then
620: l_profile_values := fnd_profile.value_specific('IBE_ORDER_LEAD_INTERVAL', null, null, null);
621: l_interval := to_number(NVL(trim(l_profile_values),'1'));
622: elsif ( p_lead_type = G_QUOTE_LEAD ) then
623: l_profile_values := fnd_profile.value_specific('IBE_QUOTE_LEAD_INTERVAL', null, null,null);
624: l_interval := to_number(NVL(trim(l_profile_values),'1'));
625: end if;
626:
627: printDebug('l_interval_profile = ' || nvl(l_profile_values, 'NULL') || ' l_interval = ' || l_interval,

Line 686: G_EMAIL_ADDRESS := fnd_profile.value_specific('IBE_LEAD_EMAIL_ADDRESS', null, null, 671);

682: function CheckProfiles(p_lead_type IN VARCHAR2) return number IS
683: l_null_profile_count NUMBER := 0;
684: BEGIN
685:
686: G_EMAIL_ADDRESS := fnd_profile.value_specific('IBE_LEAD_EMAIL_ADDRESS', null, null, 671);
687: if( G_EMAIL_ADDRESS is null ) then
688: l_null_profile_count := l_null_profile_count + 1;
689: end if;
690:

Line 695: printOutput('IBE_ORDER_LEAD_INTERVAL: ' || nvl(fnd_profile.value_specific('IBE_ORDER_LEAD_INTERVAL', null, null, 671), 1));

691:
692: FND_MESSAGE.SET_NAME('IBE', 'IBE_ECR_PROFILE_TITLE');
693: printOutput('*** '||FND_MESSAGE.GET || ' ****');
694: if( p_lead_type = G_ORDER_LEAD ) then
695: printOutput('IBE_ORDER_LEAD_INTERVAL: ' || nvl(fnd_profile.value_specific('IBE_ORDER_LEAD_INTERVAL', null, null, 671), 1));
696: else
697: printOutput('IBE_QUOTE_LEAD_INTERVAL: ' || nvl(fnd_profile.value_specific('IBE_QUOTE_LEAD_INTERVAL', null, null, 671), 1));
698: end if;
699: FND_MESSAGE.SET_NAME('IBE', 'IBE_ECR_PROFILE_VALUE');

Line 697: printOutput('IBE_QUOTE_LEAD_INTERVAL: ' || nvl(fnd_profile.value_specific('IBE_QUOTE_LEAD_INTERVAL', null, null, 671), 1));

693: printOutput('*** '||FND_MESSAGE.GET || ' ****');
694: if( p_lead_type = G_ORDER_LEAD ) then
695: printOutput('IBE_ORDER_LEAD_INTERVAL: ' || nvl(fnd_profile.value_specific('IBE_ORDER_LEAD_INTERVAL', null, null, 671), 1));
696: else
697: printOutput('IBE_QUOTE_LEAD_INTERVAL: ' || nvl(fnd_profile.value_specific('IBE_QUOTE_LEAD_INTERVAL', null, null, 671), 1));
698: end if;
699: FND_MESSAGE.SET_NAME('IBE', 'IBE_ECR_PROFILE_VALUE');
700: FND_MESSAGE.SET_NAME('NAME', 'IBE_LEAD_EMAIL_ADDRESS');
701: return l_null_profile_count;

Line 756: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then

752: l_retcode := 0;
753:
754: g_debug_flag := p_debug_flag;
755:
756: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
757: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
758: Else
759: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
760: End If;

Line 1047: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then

1043: -- if user supplied both begin_date and end_date, use those dates.
1044:
1045: g_debug_flag := p_debug_flag;
1046:
1047: If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
1048: IBE_UTIL.G_DEBUGON := FND_API.G_TRUE;
1049: Else
1050: IBE_UTIL.G_DEBUGON := FND_API.G_FALSE;
1051: End If;

Line 1348: nvl(fnd_profile.value_specific('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE', null, null, 671), 'EMAIL'),

1344: l_header_rec.PARTY_SITE_ID,
1345: l_header_rec.REL_PARTY_ID,
1346: l_header_rec.PHONE_ID,
1347: l_header_rec.NOTES,
1348: nvl(fnd_profile.value_specific('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE', null, null, 671), 'EMAIL'),
1349: 'STORE',
1350: nvl(l_header_rec.currency_code, fnd_profile.value('AS_CURRENCY_CODE')),
1351: l_header_rec.TOTAL_AMOUNT,
1352: ' STORE ' ||l_header_rec.quote_header_id,

Line 1350: nvl(l_header_rec.currency_code, fnd_profile.value('AS_CURRENCY_CODE')),

1346: l_header_rec.PHONE_ID,
1347: l_header_rec.NOTES,
1348: nvl(fnd_profile.value_specific('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE', null, null, 671), 'EMAIL'),
1349: 'STORE',
1350: nvl(l_header_rec.currency_code, fnd_profile.value('AS_CURRENCY_CODE')),
1351: l_header_rec.TOTAL_AMOUNT,
1352: ' STORE ' ||l_header_rec.quote_header_id,
1353: 'SINGLE',
1354: l_header_rec.lead_description,

Line 1505: -- l_promotion_code :=nvl(fnd_profile.value_specific('IBE_DEFAULT_LEAD_PROMO_CODE', null, null, 671),'10000');

1501: x_return_status := FND_API.G_RET_STS_SUCCESS;
1502: x_msg_count := 0;
1503: x_msg_data := '';
1504:
1505: -- l_promotion_code :=nvl(fnd_profile.value_specific('IBE_DEFAULT_LEAD_PROMO_CODE', null, null, 671),'10000');
1506: l_promotion_code := p_header_rec.PROMO_CODE;
1507:
1508: printDebug('Inside create_sales_lead','Create_sales_lead');
1509: OPEN c_get_promotion_id(l_promotion_code);

Line 1527: l_sales_lead_rec.STATUS_CODE := nvl(fnd_profile.value('AS_DEFAULT_LEAD_STATUS'),'NEW');

1523: close c_get_promotion_id;
1524:
1525: printDebug('l_temp_promotion_id is ' || l_temp_promotion_id, 'Create_Sales_Lead');
1526: l_sales_lead_rec.LEAD_NUMBER := -1;
1527: l_sales_lead_rec.STATUS_CODE := nvl(fnd_profile.value('AS_DEFAULT_LEAD_STATUS'),'NEW');
1528: l_sales_lead_rec.CUSTOMER_ID := p_header_rec.party_id;
1529: l_sales_lead_rec.ADDRESS_ID := p_header_rec.party_site_id;
1530: l_sales_lead_rec.ORIG_SYSTEM_REFERENCE := ' STORE ' || p_header_rec.quote_header_id;
1531: l_sales_lead_rec.currency_code := nvl(p_header_rec.currency_code, fnd_profile.value('AS_CURRENCY_CODE'));

Line 1531: l_sales_lead_rec.currency_code := nvl(p_header_rec.currency_code, fnd_profile.value('AS_CURRENCY_CODE'));

1527: l_sales_lead_rec.STATUS_CODE := nvl(fnd_profile.value('AS_DEFAULT_LEAD_STATUS'),'NEW');
1528: l_sales_lead_rec.CUSTOMER_ID := p_header_rec.party_id;
1529: l_sales_lead_rec.ADDRESS_ID := p_header_rec.party_site_id;
1530: l_sales_lead_rec.ORIG_SYSTEM_REFERENCE := ' STORE ' || p_header_rec.quote_header_id;
1531: l_sales_lead_rec.currency_code := nvl(p_header_rec.currency_code, fnd_profile.value('AS_CURRENCY_CODE'));
1532: l_sales_lead_rec.prm_assignment_type := 'SINGLE';
1533: l_sales_lead_rec.vehicle_response_code := nvl(fnd_profile.value_specific('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE', null, null, 671), 'EMAIL');
1534: l_sales_lead_rec.budget_amount := p_header_rec.total_amount;
1535: l_sales_lead_rec.description := p_header_rec.lead_description;

Line 1533: l_sales_lead_rec.vehicle_response_code := nvl(fnd_profile.value_specific('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE', null, null, 671), 'EMAIL');

1529: l_sales_lead_rec.ADDRESS_ID := p_header_rec.party_site_id;
1530: l_sales_lead_rec.ORIG_SYSTEM_REFERENCE := ' STORE ' || p_header_rec.quote_header_id;
1531: l_sales_lead_rec.currency_code := nvl(p_header_rec.currency_code, fnd_profile.value('AS_CURRENCY_CODE'));
1532: l_sales_lead_rec.prm_assignment_type := 'SINGLE';
1533: l_sales_lead_rec.vehicle_response_code := nvl(fnd_profile.value_specific('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE', null, null, 671), 'EMAIL');
1534: l_sales_lead_rec.budget_amount := p_header_rec.total_amount;
1535: l_sales_lead_rec.description := p_header_rec.lead_description;
1536:
1537: l_index := 0;

Line 1725: l_email_list := FND_PROFILE.Value_specific('IBE_LEAD_EMAIL_ADDRESS', null, null, 671);

1721: l_quote_log_id NUMBER := 0;
1722: BEGIN
1723: --null;
1724:
1725: l_email_list := FND_PROFILE.Value_specific('IBE_LEAD_EMAIL_ADDRESS', null, null, 671);
1726:
1727:
1728: if( l_email_list is null ) then
1729: printDebug('l_email_list is null ', 'sendEmail');