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_EXTWARPRGM_PVT dependencies on FND_PROFILE

Line 149: --G_Debug_option := Fnd_profile.value('OKS_DEBUG_LOG');

145: RETURN (l_merge_yn);
146: END IF;
147: END;
148:
149: --G_Debug_option := Fnd_profile.value('OKS_DEBUG_LOG');
150: FUNCTION get_top_line_number (p_chr_id IN NUMBER)
151: RETURN NUMBER;
152:
153: FUNCTION get_sub_line_number (p_chr_id IN NUMBER, p_cle_id IN NUMBER)

Line 763: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_DESC'

759: INTO l_name, l_desc;
760:
761: CLOSE l_inv_csr;
762:
763: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_DESC'
764: THEN
765: l_desc := l_name; --l_desc;
766: ELSE
767: l_desc := l_desc; --l_name;

Line 1210: fnd_profile.VALUE ('OKS_TRANSFER_STATUS'),

1206:
1207: OPEN target_csr (p_target_chr_id,
1208: l_source_rec.payment_term_id,
1209: l_source_rec.price_list_id,
1210: fnd_profile.VALUE ('OKS_TRANSFER_STATUS'),
1211: l_source_rec.source_ste_code,
1212: l_source_rec.authoring_org_id,
1213: l_source_rec.currency_code,
1214: l_source_rec.template_yn,

Line 1398: fnd_profile.VALUE ('OKS_TRANSFER_STATUS'),

1394: -- status, line style id, payment type, billing schedule type.
1395: OPEN target_line (p_target_line_id,
1396: l_source_rec.acct_rule_id,
1397: l_source_rec.price_list_id,
1398: fnd_profile.VALUE ('OKS_TRANSFER_STATUS'),
1399: l_source_rec.lse_id,
1400: p_source_flag,
1401: l_source_rec.bill_to_site_use_id,
1402: l_source_rec.line_renewal_type_code,

Line 1438: AND fnd_profile.VALUE ('OKS_CHECK_COV_MATCH') = 'Y'

1434: END IF;
1435:
1436: -------------------------- Check Coverage -----------------------------
1437: IF x_eligible_yn = 'Y'
1438: AND fnd_profile.VALUE ('OKS_CHECK_COV_MATCH') = 'Y'
1439: THEN
1440: oks_coverages_pub.check_coverage_match
1441: (p_api_version => l_api_version,
1442: p_init_msg_list => l_init_msg_list,

Line 2004: l_notify := NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_YN'), 'NO');

2000: l_notify VARCHAR2 (10) := 'Y';
2001: l_receiver VARCHAR2 (30);
2002: l_itemkey_seq INTEGER;
2003: BEGIN
2004: l_notify := NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_YN'), 'NO');
2005: l_receiver :=
2006: NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_TO'), 'SYSADMIN');
2007:
2008: IF UPPER (l_notify) = 'YES'

Line 2006: NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_TO'), 'SYSADMIN');

2002: l_itemkey_seq INTEGER;
2003: BEGIN
2004: l_notify := NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_YN'), 'NO');
2005: l_receiver :=
2006: NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_TO'), 'SYSADMIN');
2007:
2008: IF UPPER (l_notify) = 'YES'
2009: THEN
2010: SELECT oks_wf_item_key_number_s1.NEXTVAL

Line 3167: || fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE')

3163: fnd_log.STRING (fnd_log.level_statement,
3164: g_module_current
3165: || '.Create_K_Hdr.before_vendor_contact',
3166: ' Vendor contact profile option value = '
3167: || fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE')
3168: || ' Territory profile option value = '
3169: || fnd_profile.VALUE ('OKS_TERR_SALES_REP')
3170: );
3171: END IF;

Line 3169: || fnd_profile.VALUE ('OKS_TERR_SALES_REP')

3165: || '.Create_K_Hdr.before_vendor_contact',
3166: ' Vendor contact profile option value = '
3167: || fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE')
3168: || ' Territory profile option value = '
3169: || fnd_profile.VALUE ('OKS_TERR_SALES_REP')
3170: );
3171: END IF;
3172:
3173: /************ Territory changes ****************************/

Line 3174: IF ( NVL (fnd_profile.VALUE ('OKS_TERR_SALES_REP'), 'RET') = 'DER'

3170: );
3171: END IF;
3172:
3173: /************ Territory changes ****************************/
3174: IF ( NVL (fnd_profile.VALUE ('OKS_TERR_SALES_REP'), 'RET') = 'DER'
3175: AND p_k_header_rec.order_hdr_id IS NOT NULL) or (p_caller = 'ST')
3176: THEN
3177: get_jtf_resource (p_authorg_id => p_k_header_rec.authoring_org_id,
3178: p_party_id => p_k_header_rec.party_id,

Line 3264: AND fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE') IS NOT NULL

3260: END IF;
3261:
3262: /************ Territory changes end****************************/
3263: IF l_salesrep_id IS NOT NULL
3264: AND fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE') IS NOT NULL
3265: THEN
3266: l_salesgroup_id :=
3267: jtf_rs_integration_pub.get_default_sales_group
3268: (p_salesrep_id => l_salesrep_id,

Line 3276: fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE');

3272: l_ctcv_tbl_in (1).object1_id1 := l_salesrep_id;
3273: l_ctcv_tbl_in (1).cpl_id := l_partyid_v;
3274: l_ctcv_tbl_in (1).dnz_chr_id := l_chrid;
3275: l_ctcv_tbl_in (1).cro_code :=
3276: fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE');
3277: l_ctcv_tbl_in (1).object1_id2 := '#';
3278: l_ctcv_tbl_in (1).sales_group_id := l_salesgroup_id;
3279:
3280: OPEN object_code_csr (l_ctcv_tbl_in (1).cro_code);

Line 3544: NVL (fnd_profile.VALUE ('OKS_WARR_CONTRACT_GROUP'), 2)

3540:
3541: --Grouping Routine
3542: l_ctrgrp :=
3543: NVL (p_k_header_rec.chr_group,
3544: NVL (fnd_profile.VALUE ('OKS_WARR_CONTRACT_GROUP'), 2)
3545: );
3546: l_cgcv_tbl_in (1).cgp_parent_id := l_ctrgrp;
3547: l_cgcv_tbl_in (1).included_chr_id := l_chrid;
3548: l_cgcv_tbl_in (1).object_version_number := okc_api.g_miss_num;

Line 9690: || fnd_profile.VALUE ('OKS_TRANSFER_STATUS')

9686: fnd_log.STRING (fnd_log.level_statement,
9687: g_module_current
9688: || '.CREATE_K_SYSTEM_TRF.create_contract_header',
9689: 'Transfer status Profile = '
9690: || fnd_profile.VALUE ('OKS_TRANSFER_STATUS')
9691: );
9692: END IF;
9693:
9694: IF (p_kdtl_rec.scs_code = 'WARRANTY' AND p_kdtl_rec.lse_id = 18)

Line 9729: l_status := fnd_profile.VALUE ('OKS_TRANSFER_STATUS');

9725: IF l_ste_code = 'ENTERED'
9726: THEN
9727: l_hdr_rec.sts_code := l_sts_code;
9728: ELSE
9729: l_status := fnd_profile.VALUE ('OKS_TRANSFER_STATUS');
9730:
9731: IF l_status = 'ACTIVE'
9732: THEN
9733: IF l_hdr_rec.start_date > SYSDATE

Line 10052: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )

10048: WHERE instance_id = p_cp_id;
10049:
10050: CURSOR l_serv_csr (p_serv_id NUMBER)
10051: IS
10052: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )
10053: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
10054: WHERE b.inventory_item_id = t.inventory_item_id
10055: AND b.organization_id = t.organization_id
10056: AND t.LANGUAGE = USERENV ('LANG')

Line 10202: l_status := fnd_profile.VALUE ('OKS_TRANSFER_STATUS');

10198: IF l_ste_code = 'ENTERED'
10199: THEN
10200: l_line_rec.line_sts_code := l_sts_code;
10201: ELSE
10202: l_status := fnd_profile.VALUE ('OKS_TRANSFER_STATUS');
10203:
10204: IF l_status = 'ACTIVE'
10205: THEN
10206: IF l_line_rec.srv_sdt > SYSDATE

Line 10319: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )

10315:
10316:
10317: CURSOR l_serv_csr (p_serv_id NUMBER)
10318: IS
10319: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )
10320: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
10321: WHERE b.inventory_item_id = t.inventory_item_id
10322: AND b.organization_id = t.organization_id
10323: AND t.LANGUAGE = USERENV ('LANG')

Line 10528: l_status := fnd_profile.VALUE ('OKS_TRANSFER_STATUS');

10524: IF l_ste_code = 'ENTERED'
10525: THEN
10526: l_covd_rec.product_sts_code := l_sts_code;
10527: ELSE
10528: l_status := fnd_profile.VALUE ('OKS_TRANSFER_STATUS');
10529:
10530: IF l_status = 'ACTIVE'
10531: THEN
10532: IF l_covd_rec.product_start_date > SYSDATE

Line 10970: fnd_profile.VALUE ('OKS_TRF_PARTY_REL');

10966:
10967: IF l_trf_option = 'TERM_NO_REL'
10968: THEN
10969: l_relationship_type :=
10970: fnd_profile.VALUE ('OKS_TRF_PARTY_REL');
10971: get_party_id (p_kdtl_tbl (l_ctr).new_account_id,
10972: l_new_party_id,
10973: l_new_party_name
10974: );

Line 11040: || fnd_profile.VALUE

11036: fnd_log.STRING
11037: (fnd_log.level_statement,
11038: g_module_current || '.CREATE_K_SYSTEM_TRF',
11039: 'OKS Raise credit memo profile option value ='
11040: || fnd_profile.VALUE
11041: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
11042: );
11043: END IF;
11044:

Line 11045: /*IF fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') = 'YES' OR fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') IS NULL THEN

11041: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
11042: );
11043: END IF;
11044:
11045: /*IF fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') = 'YES' OR fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') IS NULL THEN
11046: l_suppress_credit := 'N';
11047: ELSE
11048: l_suppress_credit := 'Y';
11049: END IF;*/

Line 11482: fnd_profile.VALUE ('OKS_TRF_PARTY_REL');

11478: IF l_trf_option = 'TRANS_NO_REL'
11479: THEN
11480: l_relationship := NULL;
11481: l_relationship_type :=
11482: fnd_profile.VALUE ('OKS_TRF_PARTY_REL');
11483: get_party_id (p_kdtl_tbl (l_ctr).new_account_id,
11484: l_new_party_id,
11485: l_new_party_name
11486: );

Line 11548: || fnd_profile.VALUE

11544: fnd_log.STRING
11545: (fnd_log.level_statement,
11546: g_module_current || '.CREATE_K_SYSTEM_TRF',
11547: 'OKS Raise credit memo profile option value ='
11548: || fnd_profile.VALUE
11549: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
11550: );
11551: END IF;
11552:

Line 11553: /*IF fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') = 'YES' OR fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') IS NULL THEN

11549: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
11550: );
11551: END IF;
11552:
11553: /*IF fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') = 'YES' OR fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') IS NULL THEN
11554: l_suppress_credit := 'N';
11555: ELSE
11556: l_suppress_credit := 'Y';
11557: END IF;*/

Line 11990: || fnd_profile.VALUE

11986: || p_kdtl_tbl (l_ctr).system_id
11987: || ',lse_id = '
11988: || p_kdtl_tbl (l_ctr).lse_id
11989: || ',Merge Profile = '
11990: || fnd_profile.VALUE
11991: ('OKS_MERGE_SYSTRF')
11992: );
11993: END IF;
11994:

Line 12001: OR fnd_profile.VALUE ('OKS_MERGE_SYSTRF') = 'N'

11997: THEN
11998: /*Sys trf*/
11999: IF p_kdtl_tbl (l_ctr).system_id IS NULL
12000: OR p_kdtl_tbl (l_ctr).lse_id = 18
12001: OR fnd_profile.VALUE ('OKS_MERGE_SYSTRF') = 'N'
12002: THEN
12003: l_contract_exist := 'F';
12004: l_contract_merge := 'F';
12005: /*Sys trf*/

Line 14045: || fnd_profile.VALUE

14041: fnd_log.STRING
14042: (fnd_log.level_statement,
14043: g_module_current || '.CREATE_CONTRACT_IBTERMINATE',
14044: 'OKS Raise credit memo profile option value ='
14045: || fnd_profile.VALUE
14046: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
14047: );
14048: END IF;
14049:

Line 14050: /*IF fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') = 'YES'

14046: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
14047: );
14048: END IF;
14049:
14050: /*IF fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') = 'YES'
14051: OR fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') IS NULL THEN
14052: l_suppress_credit := 'N';
14053: ELSE
14054: l_suppress_credit := 'Y';

Line 14051: OR fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') IS NULL THEN

14047: );
14048: END IF;
14049:
14050: /*IF fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') = 'YES'
14051: OR fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') IS NULL THEN
14052: l_suppress_credit := 'N';
14053: ELSE
14054: l_suppress_credit := 'Y';
14055: END IF;*/

Line 15086: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') =

15082: INTO line_name, line_desc;
15083:
15084: CLOSE l_serv_csr;
15085:
15086: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') =
15087: 'DISPLAY_NAME'
15088: THEN
15089: l_desc := line_name;
15090: ELSE

Line 16828: IF NVL (fnd_profile.VALUE ('OKS_SRC_TERR_QUALFIERS'), 'V') = 'V'

16824: l_msg_data VARCHAR2 (200);
16825: l_return_status VARCHAR2 (3);
16826: BEGIN
16827: -- Fix for bug 4142999
16828: IF NVL (fnd_profile.VALUE ('OKS_SRC_TERR_QUALFIERS'), 'V') = 'V'
16829: THEN
16830: OPEN get_vendor_details;
16831:
16832: FETCH get_vendor_details

Line 16866: || fnd_profile.VALUE ('OKS_SRC_TERR_QUALFIERS')

16862: || l_state_code
16863: || ' Country Code'
16864: || l_country_code
16865: || ' Territory Qualifier profile '
16866: || fnd_profile.VALUE ('OKS_SRC_TERR_QUALFIERS')
16867: );
16868: END IF;
16869:
16870: l_gen_bulk_rec.trans_object_id (1) := 100;

Line 16961: l_terr_admin_id := fnd_profile.VALUE ('OKS_TERR_ADMIN_ID');

16957: );
16958: END IF;
16959:
16960: l_subj := fnd_message.get_string ('OKS', 'OKS_TERR_SETUP_ERR_SUB');
16961: l_terr_admin_id := fnd_profile.VALUE ('OKS_TERR_ADMIN_ID');
16962:
16963: IF (l_terr_admin_id IS NULL)
16964: THEN
16965: l_contract_admin_id := fnd_profile.VALUE ('OKS_CONTRACT_ADMIN_ID');

Line 16965: l_contract_admin_id := fnd_profile.VALUE ('OKS_CONTRACT_ADMIN_ID');

16961: l_terr_admin_id := fnd_profile.VALUE ('OKS_TERR_ADMIN_ID');
16962:
16963: IF (l_terr_admin_id IS NULL)
16964: THEN
16965: l_contract_admin_id := fnd_profile.VALUE ('OKS_CONTRACT_ADMIN_ID');
16966: END IF;
16967:
16968: IF l_terr_admin_id IS NOT NULL
16969: THEN

Line 17001: l_user_name := fnd_profile.VALUE ('OKC_K_APPROVER');

16997: 'Contract Admin is not null - ' || l_user_name
16998: );
16999: END IF;
17000: ELSE
17001: l_user_name := fnd_profile.VALUE ('OKC_K_APPROVER');
17002:
17003: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
17004: THEN
17005: fnd_log.STRING (fnd_log.level_statement,