DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on FND_PROFILE

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

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

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

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

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

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

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

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

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

645: End If;
646:
647: Okc_context.set_okc_org_context (l_org_rec.org_id, l_organization_id);
648:
649: Elsif Fnd_Profile.Value('OKS_CONTRACTS_VALIDATION_SOURCE') = 'SH' Then
650: Okc_context.set_okc_org_context (l_org_rec.org_id, l_org_rec.ship_from_org_id);
651:
652: End If;
653:

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

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

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

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

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

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

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

984: close get_chr_id_csr;
985:
986: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
987: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
988: 'Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
989: END IF;
990:
991: If l_chr_id Is not null AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' then
992: l_extwar_rec.Merge_Type := 'LTC';

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

987: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW',
988: 'Warranty consolidation profile option '|| fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'));
989: END IF;
990:
991: If l_chr_id Is not null AND NVL(fnd_profile.value('OKS_WARRANTY_CONSOLIDATION'),'Y') = 'Y' then
992: l_extwar_rec.Merge_Type := 'LTC';
993: l_extwar_rec.merge_Object_Id := l_chr_id;
994: Else
995: l_extwar_rec.Merge_Type := 'WARR';

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

2052: l_process_status Varchar2(1);
2053: Begin
2054: /*
2055: FND_GLOBAL.APPS_INITIALIZE(1005214, 21708, 515);
2056: fnd_profile.put('AFLOG_ENABLED', 'Y');
2057: fnd_profile.put('AFLOG_MODULE', '%');
2058: fnd_profile.put('AFLOG_LEVEL', '1');
2059: fnd_profile.put('AFLOG_FILENAME', '');
2060: fnd_log_repository.init;

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

2053: Begin
2054: /*
2055: FND_GLOBAL.APPS_INITIALIZE(1005214, 21708, 515);
2056: fnd_profile.put('AFLOG_ENABLED', 'Y');
2057: fnd_profile.put('AFLOG_MODULE', '%');
2058: fnd_profile.put('AFLOG_LEVEL', '1');
2059: fnd_profile.put('AFLOG_FILENAME', '');
2060: fnd_log_repository.init;
2061:

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

2054: /*
2055: FND_GLOBAL.APPS_INITIALIZE(1005214, 21708, 515);
2056: fnd_profile.put('AFLOG_ENABLED', 'Y');
2057: fnd_profile.put('AFLOG_MODULE', '%');
2058: fnd_profile.put('AFLOG_LEVEL', '1');
2059: fnd_profile.put('AFLOG_FILENAME', '');
2060: fnd_log_repository.init;
2061:
2062: */

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

2055: FND_GLOBAL.APPS_INITIALIZE(1005214, 21708, 515);
2056: fnd_profile.put('AFLOG_ENABLED', 'Y');
2057: fnd_profile.put('AFLOG_MODULE', '%');
2058: fnd_profile.put('AFLOG_LEVEL', '1');
2059: fnd_profile.put('AFLOG_FILENAME', '');
2060: fnd_log_repository.init;
2061:
2062: */
2063: x_return_status := l_return_status;

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

2354: End If;
2355: -- Update transaction
2356: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2357: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2358: 'Instance quantity Update Profile=' ||fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'));
2359: End If;
2360:
2361: If NVL(fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'),'N') = 'Y' Then
2362: Open get_k_for_upd_csr;

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

2357: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_INTERFACE',
2358: 'Instance quantity Update Profile=' ||fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'));
2359: End If;
2360:
2361: If NVL(fnd_profile.value('OKS_INSTANCE_QUANTITY_UPDATE'),'N') = 'Y' Then
2362: Open get_k_for_upd_csr;
2363: Fetch get_k_for_upd_csr Bulk Collect into k_upd_tbl;
2364: Close get_k_for_upd_csr;
2365:

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

2738: l_batch_rule.termination_reason_code := l_reason_type ;
2739: l_batch_rule.billing_profile_id := NULL ;
2740: l_batch_rule.retain_contract_number_flag := 'N' ;
2741: l_batch_rule.contract_modifier := NULL ;
2742: l_batch_rule.contract_status := NVL(fnd_profile.value('OKS_TRANSFER_STATUS'),'ENTERED') ;
2743: l_batch_rule.transfer_notes_flag := 'N';
2744: l_batch_rule.transfer_attachments_flag := 'N';
2745: l_batch_rule.bill_lines_flag := 'Y' ;
2746: l_batch_rule.transfer_option_code := 'COVERAGE' ;