DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on FND_PROFILE

Line 551: IF nvl(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'), 'Y') = 'Y'

547: Else
548:
549: -- Vigandhi : 08-Dec-2005
550: --- Fix for Bug 4295015
551: IF nvl(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'), 'Y') = 'Y'
552: THEN
553: Update Okc_k_headers_all_b
554: Set last_updated_by = last_updated_by
555: Where id = -1;

Line 626: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'IB' OR Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then

622: 'Org id ='||l_org_rec.org_id ||
623: ',Sold from org id = '|| l_org_rec.sold_from_org_id ||
624: ',Ship from org id = '||l_org_rec.ship_from_org_id );
625: END IF;
626: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'IB' OR Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
627: Okc_context.set_okc_org_context (p_instance_rec.org_id, p_instance_rec.organization_id);
628:
629: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then
630: Okc_context.set_okc_org_context (l_org_rec.org_id, NULL );

Line 629: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then

625: END IF;
626: If Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'IB' OR Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') Is NULL Then
627: Okc_context.set_okc_org_context (p_instance_rec.org_id, p_instance_rec.organization_id);
628:
629: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then
630: Okc_context.set_okc_org_context (l_org_rec.org_id, NULL );
631:
632: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
633:

Line 632: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then

628:
629: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'MO' Then
630: Okc_context.set_okc_org_context (l_org_rec.org_id, NULL );
631:
632: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SO' Then
633:
634: l_organization_id := Null;
635: If l_org_rec.sold_from_org_id Is Not Null Then
636: Open l_organization_csr(l_org_rec.sold_from_org_id);

Line 645: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then

641: End If;
642:
643: Okc_context.set_okc_org_context (l_org_rec.org_id, l_organization_id);
644:
645: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
646: Okc_context.set_okc_org_context (l_org_rec.org_id, l_org_rec.ship_from_org_id);
647:
648: End If;
649:

Line 763: If fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_NAME' Then

759: ',Primary UOM code = '||l_itm_rec.Primary_UOM_Code ||',Service starting delay = '||l_itm_rec.Service_starting_delay);
760: END IF;
761:
762:
763: If fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_NAME' Then
764: l_extwar_rec.srv_desc := l_itm_rec.description;
765: l_extwar_rec.srv_name := l_itm_rec.name;
766: Else
767: l_extwar_rec.srv_desc := l_itm_rec.name;

Line 778: ' Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));

774: -- profile option created for warranty consolidation --23-apr-2003
775:
776: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
777: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
778: ' Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
779: END IF;
780:
781: If l_chr_id IS NOT NULL AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' Then
782: l_extwar_rec.Merge_Type := 'LTC';

Line 781: If l_chr_id IS NOT NULL AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' Then

777: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
778: ' Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
779: END IF;
780:
781: If l_chr_id IS NOT NULL AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' Then
782: l_extwar_rec.Merge_Type := 'LTC';
783: l_extwar_rec.merge_Object_Id := l_chr_id;
784: Else
785: l_extwar_rec.Merge_Type := 'WARR';

Line 1003: 'Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));

999: close get_chr_id_csr;
1000:
1001: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1002: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
1003: 'Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
1004: END IF;
1005:
1006: If l_chr_id Is not null AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' then
1007: l_extwar_rec.Merge_Type := 'LTC';

Line 1006: If l_chr_id Is not null AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' then

1002: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
1003: 'Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
1004: END IF;
1005:
1006: If l_chr_id Is not null AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' then
1007: l_extwar_rec.Merge_Type := 'LTC';
1008: l_extwar_rec.merge_Object_Id := l_chr_id;
1009: Else
1010: l_extwar_rec.Merge_Type := 'WARR';

Line 2076: fnd_profile.put('AFLOG_ENABLED', 'Y');

2072: l_process_status Varchar2(1);
2073: Begin
2074: /*
2075: FND_GLOBAL.APPS_INITIALIZE(1005214, 21708, 515);
2076: fnd_profile.put('AFLOG_ENABLED', 'Y');
2077: fnd_profile.put('AFLOG_MODULE', '%');
2078: fnd_profile.put('AFLOG_LEVEL', '1');
2079: fnd_profile.put('AFLOG_FILENAME', '');
2080: fnd_log_repository.init;

Line 2077: fnd_profile.put('AFLOG_MODULE', '%');

2073: Begin
2074: /*
2075: FND_GLOBAL.APPS_INITIALIZE(1005214, 21708, 515);
2076: fnd_profile.put('AFLOG_ENABLED', 'Y');
2077: fnd_profile.put('AFLOG_MODULE', '%');
2078: fnd_profile.put('AFLOG_LEVEL', '1');
2079: fnd_profile.put('AFLOG_FILENAME', '');
2080: fnd_log_repository.init;
2081:

Line 2078: fnd_profile.put('AFLOG_LEVEL', '1');

2074: /*
2075: FND_GLOBAL.APPS_INITIALIZE(1005214, 21708, 515);
2076: fnd_profile.put('AFLOG_ENABLED', 'Y');
2077: fnd_profile.put('AFLOG_MODULE', '%');
2078: fnd_profile.put('AFLOG_LEVEL', '1');
2079: fnd_profile.put('AFLOG_FILENAME', '');
2080: fnd_log_repository.init;
2081:
2082: */

Line 2079: fnd_profile.put('AFLOG_FILENAME', '');

2075: FND_GLOBAL.APPS_INITIALIZE(1005214, 21708, 515);
2076: fnd_profile.put('AFLOG_ENABLED', 'Y');
2077: fnd_profile.put('AFLOG_MODULE', '%');
2078: fnd_profile.put('AFLOG_LEVEL', '1');
2079: fnd_profile.put('AFLOG_FILENAME', '');
2080: fnd_log_repository.init;
2081:
2082: */
2083: x_return_status := l_return_status;

Line 2378: 'Instance quantity Update Profile=' ||fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'));

2374: End If;
2375: -- Update transaction
2376: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2378: 'Instance quantity Update Profile=' ||fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'));
2379: End If;
2380:
2381: If NVL(fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'),'N') = 'Y' Then
2382: Open get_k_for_upd_csr;

Line 2381: If NVL(fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'),'N') = 'Y' Then

2377: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2378: 'Instance quantity Update Profile=' ||fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'));
2379: End If;
2380:
2381: If NVL(fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'),'N') = 'Y' Then
2382: Open get_k_for_upd_csr;
2383: Fetch get_k_for_upd_csr Bulk Collect into k_upd_tbl;
2384: Close get_k_for_upd_csr;
2385:

Line 2762: l_batch_rule.contract_status := NVL(fnd_profile.value('OKS_TRANSFER_STATUS'),'ENTERED') ;

2758: l_batch_rule.termination_reason_code := l_reason_type ;
2759: l_batch_rule.billing_profile_id := NULL ;
2760: l_batch_rule.retain_contract_number_flag := 'N' ;
2761: l_batch_rule.contract_modifier := NULL ;
2762: l_batch_rule.contract_status := NVL(fnd_profile.value('OKS_TRANSFER_STATUS'),'ENTERED') ;
2763: l_batch_rule.transfer_notes_flag := 'N';
2764: l_batch_rule.transfer_attachments_flag := 'N';
2765: l_batch_rule.bill_lines_flag := 'Y' ;
2766: l_batch_rule.transfer_option_code := 'COVERAGE' ;

Line 2977: IF NVL(Fnd_Profile.Value('OKS_LINE_MIRR_NAME_OR_DESC'), 'DISPLAY_NAME')= 'DISPLAY_DESC' THEN

2973: k_id_tbl(j) := l_ent_contracts(i).contract_id;
2974: k_line_id_tbl(j) := l_ent_contracts(i).CovLvl_Line_Id;
2975: --304974183043424478303663115769271900942;
2976: /* -- 9791220 --start */
2977: IF NVL(Fnd_Profile.Value('OKS_LINE_MIRR_NAME_OR_DESC'), 'DISPLAY_NAME')= 'DISPLAY_DESC' THEN
2978: k_serv_name_tbl(j) := l_ent_contracts(i).service_description;
2979: ELSE
2980: k_serv_name_tbl(j) := l_ent_contracts(i).service_name;
2981: END IF;

Line 3681: If fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_NAME' Then

3677: OPEN svc_desc_csr(p_svc_line_id);
3678: FETCH svc_desc_csr INTO l_svc_name, l_svc_desc;
3679: CLOSE svc_desc_csr;
3680:
3681: If fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_NAME' Then
3682: l_svc_item_desc := l_svc_desc;
3683: l_svc_item_name := l_svc_name;
3684: ELSE
3685: l_svc_item_desc := l_svc_name;

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

3689: OPEN l_inv_csr (p_product_item);
3690: FETCH l_inv_csr INTO l_name, l_desc;
3691: CLOSE l_inv_csr;
3692:
3693: IF fnd_profile.VALUE ('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_DESC'
3694: THEN
3695: l_desc := l_name; --l_desc;
3696: ELSE
3697: l_desc := l_desc; --l_name;