336: ,MTL.Primary_UOM_Code
337: ,MTL.Service_starting_delay
338: From OKX_SYSTEM_ITEMS_V MTL
339: Where MTL.id1 = p_Inventory_id
340: And MTL.Organization_id = okc_context.get_okc_organization_id;
341:
342: Cursor l_org_csr (p_line_id Number) Is
343: select org_id
344: ,sold_from_org_id
545: Raise G_EXCEPTION_HALT_VALIDATION;
546: End If;
547:
548: -- Setting the org context
549: Okc_context.set_okc_org_context (p_instance_rec.org_id, p_instance_rec.organization_id);
550:
551: Else
552:
553: -- Vigandhi : 08-Dec-2005
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 );
635:
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:
638: l_organization_id := Null;
643: Else
644: l_organization_id := Null;
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:
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:
654:
655: End If;
656:
657: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
658: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.after org setup',
659: 'Org id = '||okc_context.get_okc_org_id ||
660: ',Organization id = '|| okc_context.get_okc_organization_id );
661: END IF;
662:
663: OKS_EXTWAR_UTIL_PVT.Get_Warranty_Info
656:
657: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
658: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.IB_NEW.after org setup',
659: 'Org id = '||okc_context.get_okc_org_id ||
660: ',Organization id = '|| okc_context.get_okc_organization_id );
661: END IF;
662:
663: OKS_EXTWAR_UTIL_PVT.Get_Warranty_Info
664: (