APPS.MTL_CROSS_REFERENCES_PVT dependencies on FND_PROFILE

Line 410: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type THEN /* bug 14138918 */

406:
407: IF (l_XRef_Rec.Uom_Code IS NOT NULL
408: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN
409:
410: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type THEN /* bug 14138918 */
411:
412: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
413: Error_Handler.Add_Error_Message
414: (

Line 463: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type

459: -- revision id can only have valus when Cross_Reference_Type is equal to profile option INV:GTIN_CROSS_REFERENCE_TYPE value
460: -- and org_independent flag should not be checked
461: -- and organization_id should be provided.
462:
463: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type
464: OR (l_XRef_Rec.Org_Independent_Flag <>'N' OR l_XRef_Rec.Org_Independent_Flag IS NULL OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR)
465: OR (l_XRef_Rec.Organization_Id IS NULL OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM)
466: THEN /* bug 14138918 */
467:

Line 851: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE THEN /* bug 14138918 */

847:
848: IF (l_XRef_Rec.Uom_Code IS NOT NULL
849: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN
850:
851: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE THEN /* bug 14138918 */
852: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
853: Error_Handler.Add_Error_Message
854: (
855: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'

Line 897: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE

893:
894: IF (l_XRef_Rec.Revision_Id IS NOT NULL
895: AND l_XRef_Rec.Revision_Id <> FND_API.G_MISS_NUM) THEN
896:
897: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE
898: OR ((l_XRef_Rec.Org_Independent_Flag <>'N') AND (l_XRef_Rec.Org_Independent_Flag <>FND_API.G_MISS_CHAR))
899: OR ((l_XRef_Rec.Org_Independent_Flag IS NULL ))
900: OR ((l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR) AND (l_mtl_XRef_rec.Org_Independent_Flag <>'N'))
901: OR ((l_XRef_Rec.Organization_Id IS NULL))

Line 2109: if (to_number(nvl(fnd_profile.value('CONC_REQUEST_ID'),0)) <> 0) then

2105: l_sysdate
2106: );
2107:
2108: -- Output error information into the log file
2109: if (to_number(nvl(fnd_profile.value('CONC_REQUEST_ID'),0)) <> 0) then
2110: FND_FILE.PUT_LINE(FND_FILE.LOG,'************************************') ;
2111: FND_FILE.PUT_LINE(FND_FILE.LOG,'TRANSACTION ID : ' || trans_id);
2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION ID : ' || org_id);
2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'TABLE NAME : ' || tbl_name);