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.

[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on FND_PROFILE

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

185: RETURN (l_merge_yn);
186: END IF;
187: END;
188:
189: --G_Debug_option := Fnd_profile.value('OKS_DEBUG_LOG');
190: FUNCTION get_top_line_number (p_chr_id IN NUMBER)
191: RETURN NUMBER;
192:
193: FUNCTION get_sub_line_number (p_chr_id IN NUMBER, p_cle_id IN NUMBER)

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

799: INTO l_name, l_desc;
800:
801: CLOSE l_inv_csr;
802:
803: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_DESC'
804: THEN
805: l_desc := l_name; --l_desc;
806: ELSE
807: l_desc := l_desc; --l_name;

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

1246:
1247: OPEN target_csr (p_target_chr_id,
1248: l_source_rec.payment_term_id,
1249: l_source_rec.price_list_id,
1250: fnd_profile.VALUE ('OKS_TRANSFER_STATUS'),
1251: l_source_rec.source_ste_code,
1252: l_source_rec.authoring_org_id,
1253: l_source_rec.currency_code,
1254: l_source_rec.template_yn,

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

1434: -- status, line style id, payment type, billing schedule type.
1435: OPEN target_line (p_target_line_id,
1436: l_source_rec.acct_rule_id,
1437: l_source_rec.price_list_id,
1438: fnd_profile.VALUE ('OKS_TRANSFER_STATUS'),
1439: l_source_rec.lse_id,
1440: p_source_flag,
1441: l_source_rec.bill_to_site_use_id,
1442: l_source_rec.line_renewal_type_code,

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

1474: END IF;
1475:
1476: -------------------------- Check Coverage -----------------------------
1477: IF x_eligible_yn = 'Y'
1478: AND fnd_profile.VALUE ('OKS_CHECK_COV_MATCH') = 'Y'
1479: THEN
1480: oks_coverages_pub.check_coverage_match
1481: (p_api_version => l_api_version,
1482: p_init_msg_list => l_init_msg_list,

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

2040: l_notify VARCHAR2 (10) := 'Y';
2041: l_receiver VARCHAR2 (30);
2042: l_itemkey_seq INTEGER;
2043: BEGIN
2044: l_notify := NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_YN'), 'NO');
2045: l_receiver :=
2046: NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_TO'), 'SYSADMIN');
2047:
2048: IF UPPER (l_notify) = 'YES'

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

2042: l_itemkey_seq INTEGER;
2043: BEGIN
2044: l_notify := NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_YN'), 'NO');
2045: l_receiver :=
2046: NVL (fnd_profile.VALUE ('OKS_INTEGRATION_NOTIFY_TO'), 'SYSADMIN');
2047:
2048: IF UPPER (l_notify) = 'YES'
2049: THEN
2050: SELECT oks_wf_item_key_number_s1.NEXTVAL

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

3220: fnd_log.STRING (fnd_log.level_statement,
3221: g_module_current
3222: || '.Create_K_Hdr.before_vendor_contact',
3223: ' Vendor contact profile option value = '
3224: || fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE')
3225: || ' Territory profile option value = '
3226: || fnd_profile.VALUE ('OKS_TERR_SALES_REP')
3227: );
3228: END IF;

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

3222: || '.Create_K_Hdr.before_vendor_contact',
3223: ' Vendor contact profile option value = '
3224: || fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE')
3225: || ' Territory profile option value = '
3226: || fnd_profile.VALUE ('OKS_TERR_SALES_REP')
3227: );
3228: END IF;
3229:
3230: /************ Territory changes ****************************/

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

3227: );
3228: END IF;
3229:
3230: /************ Territory changes ****************************/
3231: IF ( NVL (fnd_profile.VALUE ('OKS_TERR_SALES_REP'), 'RET') = 'DER'
3232: AND p_k_header_rec.order_hdr_id IS NOT NULL) or (p_caller = 'ST')
3233: THEN
3234: get_jtf_resource (p_authorg_id => p_k_header_rec.authoring_org_id,
3235: p_party_id => p_k_header_rec.party_id,

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

3317: END IF;
3318:
3319: /************ Territory changes end****************************/
3320: IF l_salesrep_id IS NOT NULL
3321: AND fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE') IS NOT NULL
3322: THEN
3323:
3324: /*spingali BUGFIX FOR BUG12747411-START salesperson*/
3325: OPEN get_k_auth_org(l_chrid);

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

3343: l_ctcv_tbl_in (1).object1_id1 := l_salesrep_id;
3344: l_ctcv_tbl_in (1).cpl_id := l_partyid_v;
3345: l_ctcv_tbl_in (1).dnz_chr_id := l_chrid;
3346: l_ctcv_tbl_in (1).cro_code :=
3347: fnd_profile.VALUE ('OKS_VENDOR_CONTACT_ROLE');
3348: l_ctcv_tbl_in (1).object1_id2 := '#';
3349: l_ctcv_tbl_in (1).sales_group_id := l_salesgroup_id;
3350:
3351: OPEN object_code_csr (l_ctcv_tbl_in (1).cro_code);

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

3611:
3612: --Grouping Routine
3613: l_ctrgrp :=
3614: NVL (p_k_header_rec.chr_group,
3615: NVL (fnd_profile.VALUE ('OKS_WARR_CONTRACT_GROUP'), 2)
3616: );
3617: l_cgcv_tbl_in (1).cgp_parent_id := l_ctrgrp;
3618: l_cgcv_tbl_in (1).included_chr_id := l_chrid;
3619: l_cgcv_tbl_in (1).object_version_number := okc_api.g_miss_num;

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

6880: --bug end 3736860
6881: /* Added for Bug#14325727 */
6882: CURSOR l_serv_csr (p_serv_id NUMBER)
6883: IS
6884: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
6885: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
6886: WHERE b.inventory_item_id = t.inventory_item_id
6887: AND b.organization_id = t.organization_id
6888: AND t.LANGUAGE = USERENV ('LANG')

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

7752: --bug end 3736860
7753: /* Added for Bug#14325727 */
7754: CURSOR l_serv_csr (p_serv_id NUMBER)
7755: IS
7756: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
7757: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
7758: WHERE b.inventory_item_id = t.inventory_item_id
7759: AND b.organization_id = t.organization_id
7760: AND t.LANGUAGE = USERENV ('LANG')

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

8718: IS
8719: /* Added for Bug#14325727 */
8720: CURSOR l_serv_csr (p_serv_id NUMBER)
8721: IS
8722: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
8723: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
8724: WHERE b.inventory_item_id = t.inventory_item_id
8725: AND b.organization_id = t.organization_id
8726: AND t.LANGUAGE = USERENV ('LANG')

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

9555: WHERE instance_id = p_cp_id;
9556: /* Added for Bug#14325727 */
9557: CURSOR l_serv_csr (p_serv_id NUMBER)
9558: IS
9559: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
9560: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
9561: WHERE b.inventory_item_id = t.inventory_item_id
9562: AND b.organization_id = t.organization_id
9563: AND t.LANGUAGE = USERENV ('LANG')

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

9930: fnd_log.STRING (fnd_log.level_statement,
9931: g_module_current
9932: || '.CREATE_K_SYSTEM_TRF.create_contract_header',
9933: 'Transfer status Profile = '
9934: || fnd_profile.VALUE ('OKS_TRANSFER_STATUS')
9935: );
9936: END IF;
9937:
9938: IF (p_kdtl_rec.scs_code = 'WARRANTY' AND p_kdtl_rec.lse_id = 18)

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

9969: IF l_ste_code = 'ENTERED'
9970: THEN
9971: l_hdr_rec.sts_code := l_sts_code;
9972: ELSE
9973: l_status := fnd_profile.VALUE ('OKS_TRANSFER_STATUS');
9974:
9975: IF l_status = 'ACTIVE'
9976: THEN
9977: IF l_hdr_rec.start_date > SYSDATE

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

10296: WHERE instance_id = p_cp_id;
10297:
10298: CURSOR l_serv_csr (p_serv_id NUMBER)
10299: IS
10300: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )
10301: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
10302: WHERE b.inventory_item_id = t.inventory_item_id
10303: AND b.organization_id = t.organization_id
10304: AND t.LANGUAGE = USERENV ('LANG')

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

10446: IF l_ste_code = 'ENTERED'
10447: THEN
10448: l_line_rec.line_sts_code := l_sts_code;
10449: ELSE
10450: l_status := fnd_profile.VALUE ('OKS_TRANSFER_STATUS');
10451:
10452: IF l_status = 'ACTIVE'
10453: THEN
10454: IF l_line_rec.srv_sdt > SYSDATE

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

10563:
10564:
10565: CURSOR l_serv_csr (p_serv_id NUMBER)
10566: IS
10567: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments )
10568: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
10569: WHERE b.inventory_item_id = t.inventory_item_id
10570: AND b.organization_id = t.organization_id
10571: AND t.LANGUAGE = USERENV ('LANG')

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

10772: IF l_ste_code = 'ENTERED'
10773: THEN
10774: l_covd_rec.product_sts_code := l_sts_code;
10775: ELSE
10776: l_status := fnd_profile.VALUE ('OKS_TRANSFER_STATUS');
10777:
10778: IF l_status = 'ACTIVE'
10779: THEN
10780: IF l_covd_rec.product_start_date > SYSDATE

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

11214:
11215: IF l_trf_option = 'TERM_NO_REL'
11216: THEN
11217: l_relationship_type :=
11218: fnd_profile.VALUE ('OKS_TRF_PARTY_REL');
11219: get_party_id (p_kdtl_tbl (l_ctr).new_account_id,
11220: l_new_party_id,
11221: l_new_party_name
11222: );

Line 11288: || fnd_profile.VALUE

11284: fnd_log.STRING
11285: (fnd_log.level_statement,
11286: g_module_current || '.CREATE_K_SYSTEM_TRF',
11287: 'OKS Raise credit memo profile option value ='
11288: || fnd_profile.VALUE
11289: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
11290: );
11291: END IF;
11292:

Line 11293: /*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

11289: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
11290: );
11291: END IF;
11292:
11293: /*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
11294: l_suppress_credit := 'N';
11295: ELSE
11296: l_suppress_credit := 'Y';
11297: END IF;*/

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

11726: IF l_trf_option = 'TRANS_NO_REL'
11727: THEN
11728: l_relationship := NULL;
11729: l_relationship_type :=
11730: fnd_profile.VALUE ('OKS_TRF_PARTY_REL');
11731: get_party_id (p_kdtl_tbl (l_ctr).new_account_id,
11732: l_new_party_id,
11733: l_new_party_name
11734: );

Line 11796: || fnd_profile.VALUE

11792: fnd_log.STRING
11793: (fnd_log.level_statement,
11794: g_module_current || '.CREATE_K_SYSTEM_TRF',
11795: 'OKS Raise credit memo profile option value ='
11796: || fnd_profile.VALUE
11797: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
11798: );
11799: END IF;
11800:

Line 11801: /*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

11797: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
11798: );
11799: END IF;
11800:
11801: /*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
11802: l_suppress_credit := 'N';
11803: ELSE
11804: l_suppress_credit := 'Y';
11805: END IF;*/

Line 12238: || fnd_profile.VALUE

12234: || p_kdtl_tbl (l_ctr).system_id
12235: || ',lse_id = '
12236: || p_kdtl_tbl (l_ctr).lse_id
12237: || ',Merge Profile = '
12238: || fnd_profile.VALUE
12239: ('OKS_MERGE_SYSTRF')
12240: );
12241: END IF;
12242:

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

12245: THEN
12246: /*Sys trf*/
12247: IF p_kdtl_tbl (l_ctr).system_id IS NULL
12248: OR p_kdtl_tbl (l_ctr).lse_id = 18
12249: OR fnd_profile.VALUE ('OKS_MERGE_SYSTRF') = 'N'
12250: THEN
12251: l_contract_exist := 'F';
12252: l_contract_merge := 'F';
12253: /*Sys trf*/

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

14158: IS
14159: /* Added for Bug#14325727 */
14160: CURSOR l_serv_csr (p_serv_id NUMBER)
14161: IS
14162: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
14163: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
14164: WHERE b.inventory_item_id = t.inventory_item_id
14165: AND b.organization_id = t.organization_id
14166: AND t.LANGUAGE = USERENV ('LANG')

Line 14330: || fnd_profile.VALUE

14326: fnd_log.STRING
14327: (fnd_log.level_statement,
14328: g_module_current || '.CREATE_CONTRACT_IBTERMINATE',
14329: 'OKS Raise credit memo profile option value ='
14330: || fnd_profile.VALUE
14331: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
14332: );
14333: END IF;
14334:

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

14331: ('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT')
14332: );
14333: END IF;
14334:
14335: /*IF fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') = 'YES'
14336: OR fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') IS NULL THEN
14337: l_suppress_credit := 'N';
14338: ELSE
14339: l_suppress_credit := 'Y';

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

14332: );
14333: END IF;
14334:
14335: /*IF fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') = 'YES'
14336: OR fnd_profile.VALUE('OKS_RAISE_CREDIT_MEMO_FOR_IB_INT') IS NULL THEN
14337: l_suppress_credit := 'N';
14338: ELSE
14339: l_suppress_credit := 'Y';
14340: END IF;*/

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

15367: INTO line_name, line_desc;
15368:
15369: CLOSE l_serv_csr;
15370:
15371: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') =
15372: 'DISPLAY_NAME'
15373: THEN
15374: l_desc := line_name;
15375: ELSE

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

15794:
15795: /* Added for Bug#14325727 */
15796: CURSOR l_serv_csr (p_serv_id NUMBER)
15797: IS
15798: SELECT DECODE (fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE'), 'DISPLAY_DESC', t.description , b.concatenated_segments) description
15799: FROM mtl_system_items_b_kfv b, mtl_system_items_tl t
15800: WHERE b.inventory_item_id = t.inventory_item_id
15801: AND b.organization_id = t.organization_id
15802: AND t.LANGUAGE = USERENV ('LANG')

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

17122: l_msg_data VARCHAR2 (200);
17123: l_return_status VARCHAR2 (3);
17124: BEGIN
17125: -- Fix for bug 4142999
17126: IF NVL (fnd_profile.VALUE ('OKS_SRC_TERR_QUALFIERS'), 'V') = 'V'
17127: THEN
17128: OPEN get_vendor_details;
17129:
17130: FETCH get_vendor_details

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

17160: || l_state_code
17161: || ' Country Code'
17162: || l_country_code
17163: || ' Territory Qualifier profile '
17164: || fnd_profile.VALUE ('OKS_SRC_TERR_QUALFIERS')
17165: );
17166: END IF;
17167:
17168: l_gen_bulk_rec.trans_object_id (1) := 100;

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

17255: );
17256: END IF;
17257:
17258: l_subj := fnd_message.get_string ('OKS', 'OKS_TERR_SETUP_ERR_SUB');
17259: l_terr_admin_id := fnd_profile.VALUE ('OKS_TERR_ADMIN_ID');
17260:
17261: IF (l_terr_admin_id IS NULL)
17262: THEN
17263: l_contract_admin_id := fnd_profile.VALUE ('OKS_CONTRACT_ADMIN_ID');

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

17259: l_terr_admin_id := fnd_profile.VALUE ('OKS_TERR_ADMIN_ID');
17260:
17261: IF (l_terr_admin_id IS NULL)
17262: THEN
17263: l_contract_admin_id := fnd_profile.VALUE ('OKS_CONTRACT_ADMIN_ID');
17264: END IF;
17265:
17266: IF l_terr_admin_id IS NOT NULL
17267: THEN

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

17295: 'Contract Admin is not null - ' || l_user_name
17296: );
17297: END IF;
17298: ELSE
17299: l_user_name := fnd_profile.VALUE ('OKC_K_APPROVER');
17300:
17301: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
17302: THEN
17303: fnd_log.STRING (fnd_log.level_statement,