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 1417: l_prof_enable_sc := nvl(FND_PROFILE.value('OKS_ENABLE_SALES_CREDIT'), 'R');

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

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

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

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

1490: RAISE FND_API.g_exc_error;
1491: END IF;
1492:
1493: --get the winning salesrep either from JTF or profile option
1494: l_prof_use_jtf := FND_PROFILE.VALUE('OKS_USE_JTF');
1495:
1496: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1497: 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);
1498: END IF;

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

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

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

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

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

1699: RAISE OKC_API.G_EXCEPTION_ERROR;
1700: END IF;
1701:
1702: --create sales credit for this salesperson
1703: l_prof_rev_type_dist := nvl(FND_PROFILE.VALUE('OKS_REVENUE_TYPE_DIST'), '0');
1704: l_percent := to_number(l_prof_rev_type_dist);
1705:
1706: IF (l_percent < 0 OR l_percent > 100) THEN
1707: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');

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

4705: l_inv_txt_tbl.delete;
4706: l_sl_id_tbl.delete;
4707:
4708: --now update the subline invoice text, this requires the top line item desc
4709: l_disp_pref := fnd_profile.VALUE('OKS_ITEM_DISPLAY_PREFERENCE');
4710: OPEN c_get_subline_txt(p_chr_id);
4711: LOOP
4712: FETCH c_get_subline_txt BULK COLLECT INTO l_line_tbl LIMIT G_BULK_FETCH_LIMIT;
4713:

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

5090:
5091: Defaulting rules
5092: 1. If p_new_contract_number is not passed, uses the source contract_number
5093: 2. If p_new_contract_modifier is not passed, generated this as
5094: fnd_profile.VALUE('OKC_CONTRACT_IDENTIFIER') || to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
5095: 3. If p_new_start_date is not passed, defaults to source contract end_date +1
5096: 4. If p_new_end_date is not passed, derived from p_new_duration/p_new_uom_code
5097: and p_new_start_date. If p_new_duration/p_new_uom_code are also not passed
5098: used the source contract duration/period

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

5335: fnd_file.put_line(FND_FILE.LOG,' ');
5336:
5337: --Step 3 default attributes
5338: l_renk_num := nvl(p_new_contract_number, l_k_num);
5339: l_renk_mod := nvl(p_new_contract_modifier, fnd_profile.VALUE('OKC_CONTRACT_IDENTIFIER') || to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
5340: l_renk_start_date := trunc(nvl(p_new_start_date, l_k_end_date + 1));
5341: l_renk_end_date := get_end_date(
5342: p_new_start_date => l_renk_start_date,
5343: p_new_end_date => p_new_end_date,