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

Line 1130: l_prof_terr_qual:= nvl(FND_PROFILE.value('OKS_SRC_TERR_QUALFIERS'), 'V');

1126: END IF;
1127:
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;
1129:
1130: l_prof_terr_qual:= nvl(FND_PROFILE.value('OKS_SRC_TERR_QUALFIERS'), 'V');
1131: IF (l_prof_terr_qual = 'V') THEN
1132: --get the customer name and vendor country and state
1133: OPEN c_vendor_details(p_org_id, p_party_id);
1134: FETCH c_vendor_details INTO l_party_name, l_country_code, l_state_code;

Line 1416: l_prof_enable_sc := nvl(FND_PROFILE.value('OKS_ENABLE_SALES_CREDIT'), 'R');

1412: x_return_status := FND_API.G_RET_STS_SUCCESS;
1413:
1414: --can have four values, DRT:Derive for Revenue Type and Retain Other
1415: --YES:Derive, NO:Drop, R:Retain, defaults to R
1416: l_prof_enable_sc := nvl(FND_PROFILE.value('OKS_ENABLE_SALES_CREDIT'), 'R');
1417:
1418: --lookup for revenue type : Select name , id1 from OKX_SALES_CRED_TYPES_V order by NAME;
1419: --1:Quota Sales Credit, 2:Non-quota Sales Credit
1420: l_prof_rev_type := FND_PROFILE.VALUE('OKS_REVENUE_TYPE');

Line 1420: l_prof_rev_type := FND_PROFILE.VALUE('OKS_REVENUE_TYPE');

1416: l_prof_enable_sc := nvl(FND_PROFILE.value('OKS_ENABLE_SALES_CREDIT'), 'R');
1417:
1418: --lookup for revenue type : Select name , id1 from OKX_SALES_CRED_TYPES_V order by NAME;
1419: --1:Quota Sales Credit, 2:Non-quota Sales Credit
1420: l_prof_rev_type := FND_PROFILE.VALUE('OKS_REVENUE_TYPE');
1421:
1422: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1423: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.profile_options', 'OKS_ENABLE_SALES_CREDIT=' || l_prof_enable_sc||' ,OKS_REVENUE_TYPE='||l_prof_rev_type);
1424: END IF;

Line 1493: l_prof_use_jtf := FND_PROFILE.VALUE('OKS_USE_JTF');

1489: RAISE FND_API.g_exc_error;
1490: END IF;
1491:
1492: --get the winning salesrep either from JTF or profile option
1493: l_prof_use_jtf := FND_PROFILE.VALUE('OKS_USE_JTF');
1494:
1495: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1496: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_k_org_party', 'l_org_id='||l_org_id||' ,l_party_id='||l_party_id||' ,Profile OKS_USE_JTF='||l_prof_use_jtf);
1497: END IF;

Line 1536: l_salesrep_id := FND_PROFILE.value('OKS_SALESPERSON_ID');

1532: END IF;
1533:
1534: ELSE
1535: --get the salesrep from profile option
1536: l_salesrep_id := FND_PROFILE.value('OKS_SALESPERSON_ID');
1537:
1538: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1539: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_salesrep', 'salesrep from profile option OKS_SALESPERSON_ID='||l_salesrep_id);
1540: END IF;

Line 1566: --Note this can only happen for FND_PROFILE.VALUE('OKS_USE_JTF') = NO

1562:
1563: IF (nvl(l_dummy_org_id,-99) <> l_org_id) THEN
1564: --as per bug # 2968069, if salesrep does not belong to the same org as the contract
1565: --we proceed without creating sales credit or adding the salerep to the contract
1566: --Note this can only happen for FND_PROFILE.VALUE('OKS_USE_JTF') = NO
1567: OPEN c_get_org_name(l_org_id);
1568: FETCH c_get_org_name INTO l_org_name;
1569: CLOSE c_get_org_name;
1570:

Line 1695: l_prof_rev_type_dist := nvl(FND_PROFILE.VALUE('OKS_REVENUE_TYPE_DIST'), '0');

1691: l_login_id,
1692: l_sales_group_id);
1693:
1694: --create sales credit for this salesperson
1695: l_prof_rev_type_dist := nvl(FND_PROFILE.VALUE('OKS_REVENUE_TYPE_DIST'), '0');
1696: l_percent := to_number(l_prof_rev_type_dist);
1697:
1698: IF (l_percent < 0 OR l_percent > 100) THEN
1699: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');

Line 4674: l_disp_pref := fnd_profile.VALUE('OKS_ITEM_DISPLAY_PREFERENCE');

4670: l_inv_txt_tbl.delete;
4671: l_sl_id_tbl.delete;
4672:
4673: --now update the subline invoice text, this requires the top line item desc
4674: l_disp_pref := fnd_profile.VALUE('OKS_ITEM_DISPLAY_PREFERENCE');
4675: OPEN c_get_subline_txt(p_chr_id);
4676: LOOP
4677: FETCH c_get_subline_txt BULK COLLECT INTO l_line_tbl LIMIT G_BULK_FETCH_LIMIT;
4678:

Line 5059: fnd_profile.VALUE('OKC_CONTRACT_IDENTIFIER') || to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')

5055:
5056: Defaulting rules
5057: 1. If p_new_contract_number is not passed, uses the source contract_number
5058: 2. If p_new_contract_modifier is not passed, generated this as
5059: fnd_profile.VALUE('OKC_CONTRACT_IDENTIFIER') || to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
5060: 3. If p_new_start_date is not passed, defaults to source contract end_date +1
5061: 4. If p_new_end_date is not passed, derived from p_new_duration/p_new_uom_code
5062: and p_new_start_date. If p_new_duration/p_new_uom_code are also not passed
5063: used the source contract duration/period

Line 5304: l_renk_mod := nvl(p_new_contract_modifier, fnd_profile.VALUE('OKC_CONTRACT_IDENTIFIER') || to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

5300: fnd_file.put_line(FND_FILE.LOG,' ');
5301:
5302: --Step 3 default attributes
5303: l_renk_num := nvl(p_new_contract_number, l_k_num);
5304: l_renk_mod := nvl(p_new_contract_modifier, fnd_profile.VALUE('OKC_CONTRACT_IDENTIFIER') || to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
5305: l_renk_start_date := trunc(nvl(p_new_start_date, l_k_end_date + 1));
5306: l_renk_end_date := get_end_date(
5307: p_new_start_date => l_renk_start_date,
5308: p_new_end_date => p_new_end_date,