DBA Data[Home] [Help]

APPS.BOM_VALIDATE_SUB_OP_RES dependencies on BOM_VALIDATE_OP_RES

Line 1521: -- Call BOM_Validate_Op_Res.Get_Rev_Op_ACD(p_op_seq_id to get parent revised

1517: --
1518: -- ACD Type,
1519: -- If the Transaction Type is CREATE and the ACD_Type of parent revised
1520: -- operation is Add then,the ACD_Type must be Add.
1521: -- Call BOM_Validate_Op_Res.Get_Rev_Op_ACD(p_op_seq_id to get parent revised
1522: -- operation's ACD Type
1523: --
1524: IF l_rev_sub_resource_rec.Transaction_Type = BOM_Rtg_Globals.G_OPR_CREATE
1525: THEN

Line 1528: BOM_Validate_Op_Res.Get_Rev_Op_ACD(p_op_seq_id

1524: IF l_rev_sub_resource_rec.Transaction_Type = BOM_Rtg_Globals.G_OPR_CREATE
1525: THEN
1526: IF
1527: l_ACD_ADD =
1528: BOM_Validate_Op_Res.Get_Rev_Op_ACD(p_op_seq_id
1529: => l_rev_sub_res_unexp_rec.operation_sequence_id)
1530: AND NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD ) <> l_ACD_ADD
1531: THEN
1532: l_token_tbl(3).token_name := 'OP_SEQ_NUMBER';

Line 1683: -- Call BOM_Validate_Op_Res.Val_Resource_Id

1679:
1680: --
1681: -- Resource Id
1682: -- Check if valid resource id exists and belongs to depatment
1683: -- Call BOM_Validate_Op_Res.Val_Resource_Id
1684: --
1685:
1686: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
1687: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )

Line 1695: BOM_Validate_Op_Res.Val_Resource_Id

1691: THEN
1692:
1693:
1694: /* Call Val_Resource_Id */
1695: BOM_Validate_Op_Res.Val_Resource_Id
1696: ( p_resource_id => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
1697: l_rev_sub_res_unexp_rec.resource_id )
1698: , p_op_seq_id => l_rev_sub_res_unexp_rec.operation_sequence_id
1699: , x_return_status => l_temp_status

Line 1853: -- BOM_Validate_Op_Res.Val_Activity_Id

1849:
1850: --
1851: -- Activity Id
1852: -- Check if Activity is enabled
1853: -- BOM_Validate_Op_Res.Val_Activity_Id
1854: --
1855: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
1856: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
1857: OR NVL(l_rev_sub_res_unexp_rec.activity_id, FND_API.G_MISS_NUM)

Line 1870: BOM_Validate_Op_Res.Val_Activity_Id

1866: END IF ;
1867:
1868:
1869: /* Call Val_Activity_Id */
1870: BOM_Validate_Op_Res.Val_Activity_Id
1871: ( p_activity_id => l_rev_sub_res_unexp_rec.activity_id
1872: , p_op_seq_id => l_rev_sub_res_unexp_rec.operation_sequence_id
1873: , x_return_status => l_temp_status
1874: ) ;

Line 1903: -- BOM_Validate_Op_Res.Val_Activity_Id

1899:
1900: --
1901: -- Activity Id
1902: -- Check if Activity is enabled
1903: -- BOM_Validate_Op_Res.Val_Activity_Id
1904: --
1905: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
1906: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
1907: OR NVL(l_rev_sub_res_unexp_rec.setup_Id , FND_API.G_MISS_NUM)

Line 1920: BOM_Validate_Op_Res.Val_Setup_Id

1916: END IF ;
1917:
1918:
1919: /* Call Val_Activity_Id */
1920: BOM_Validate_Op_Res.Val_Setup_Id
1921: ( p_setup_id => l_rev_sub_res_unexp_rec.setup_id
1922: , p_resource_id => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
1923: l_rev_sub_res_unexp_rec.resource_id )
1924: , p_organization_id => l_rev_sub_res_unexp_rec.organization_id

Line 1967: -- Call BOM_Validate_Op_Res.Get_Resource_Uom

1963: -- same
1964: -- 2. Resource UOM class <> Hour UOM class
1965: -- 3. No conversion between resource UOM and Hour UOM
1966: --
1967: -- Call BOM_Validate_Op_Res.Get_Resource_Uom
1968: -- and BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule
1969: --
1970: IF p_rev_sub_resource_rec.schedule_flag <> l_NO_SCHEDULE -- 2: No
1971: THEN

Line 1968: -- and BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule

1964: -- 2. Resource UOM class <> Hour UOM class
1965: -- 3. No conversion between resource UOM and Hour UOM
1966: --
1967: -- Call BOM_Validate_Op_Res.Get_Resource_Uom
1968: -- and BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule
1969: --
1970: IF p_rev_sub_resource_rec.schedule_flag <> l_NO_SCHEDULE -- 2: No
1971: THEN
1972:

Line 1979: BOM_Validate_Op_Res.Get_Resource_Uom

1975: l_res_uom_code IS NULL OR
1976: l_res_uom_class IS NULL
1977: )
1978: THEN
1979: BOM_Validate_Op_Res.Get_Resource_Uom
1980: ( p_resource_id
1981: => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
1982: l_rev_sub_res_unexp_rec.resource_id)
1983: , x_hour_uom_code => l_hour_uom_code

Line 1990: BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule

1986: , x_res_uom_class => l_res_uom_class ) ;
1987: END IF ;
1988:
1989: /* Call Val_Scheduled_Resource */
1990: BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule
1991: ( p_hour_uom_class => l_hour_uom_class
1992: , p_res_uom_class => l_res_uom_class
1993: , p_hour_uom_code => l_hour_uom_code
1994: , p_res_uom_code => l_res_uom_code

Line 2108: -- Call BOM_Validate_Op_Res.Val_Dept_Has_Location

2104: --
2105: -- Autocharge Type
2106: -- Autocharge type cannot be PO Receipt if the
2107: -- department has no location.
2108: -- Call BOM_Validate_Op_Res.Val_Dept_Has_Location
2109: --
2110: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2111: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
2112: OR l_rev_sub_resource_rec.autocharge_type <> p_old_rev_sub_resource_rec.autocharge_type

Line 2118: BOM_Validate_Op_Res.Val_Dept_Has_Location

2114: AND l_rev_sub_resource_rec.autocharge_type = l_PO_RECEIPT
2115: THEN
2116:
2117: /* Call Val_Dept_Has_Location */
2118: BOM_Validate_Op_Res.Val_Dept_Has_Location
2119: ( p_op_seq_id => l_rev_sub_res_unexp_rec.operation_sequence_id
2120: , x_return_status => l_temp_status
2121: ) ;
2122:

Line 2150: -- Call BOM_Validate_Op_Res.Val_Autocharge_for_OSP_Res

2146: --
2147: -- Autocharge Type
2148: -- Autocharge Type cannot be PO Move or PO Receipt if the resource
2149: -- is non-OSP resource
2150: -- Call BOM_Validate_Op_Res.Val_Autocharge_for_OSP_Res
2151: --
2152: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2153: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
2154: OR l_rev_sub_resource_rec.autocharge_type <> p_old_rev_sub_resource_rec.autocharge_type

Line 2160: BOM_Validate_Op_Res.Val_Autocharge_for_OSP_Res

2156: AND l_rev_sub_resource_rec.autocharge_type IN (l_PO_RECEIPT, l_PO_MOVE )
2157: THEN
2158:
2159: /* Call Val_Autocharge_for_OSP_Res */
2160: BOM_Validate_Op_Res.Val_Autocharge_for_OSP_Res
2161: ( p_resource_id => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
2162: l_rev_sub_res_unexp_rec.resource_id)
2163: , p_organization_id => l_rev_sub_res_unexp_rec.organization_id
2164: , x_return_status => l_temp_status

Line 2240: -- Call BOM_Validate_Op_Res.Val_Usage_Rate_or_Amount

2236:
2237: --
2238: -- Usage Rate or Amount
2239: -- Check round values for Usage Rate or Amount and the Inverse.
2240: -- Call BOM_Validate_Op_Res.Val_Usage_Rate_or_Amount
2241: --
2242: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2243: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
2244: OR l_rev_sub_resource_rec.usage_rate_or_amount

Line 2252: BOM_Validate_Op_Res.Val_Usage_Rate_or_Amount

2248: )
2249: THEN
2250:
2251: /* Call Val_Usage_Rate_or_Amount */
2252: BOM_Validate_Op_Res.Val_Usage_Rate_or_Amount
2253: ( p_usage_rate_or_amount => l_rev_sub_resource_rec.usage_rate_or_amount
2254: , p_usage_rate_or_amount_inverse => l_rev_sub_resource_rec.usage_rate_or_amount_inverse
2255: , x_return_status => l_temp_status
2256: ) ;

Line 2308: BOM_Validate_Op_Res.Get_Resource_Uom

2304: l_res_uom_code IS NULL OR
2305: l_res_uom_class IS NULL
2306: )
2307: THEN
2308: BOM_Validate_Op_Res.Get_Resource_Uom
2309: ( p_resource_id => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
2310: l_rev_sub_res_unexp_rec.resource_id)
2311: , x_hour_uom_code => l_hour_uom_code
2312: , x_hour_uom_class => l_hour_uom_class

Line 2319: BOM_Validate_Op_Res.Val_Negative_Usage_Rate

2315: END IF ;
2316:
2317:
2318: /* Call Val_Negative_Usage_Rate */
2319: BOM_Validate_Op_Res.Val_Negative_Usage_Rate
2320: ( p_autocharge_type => l_rev_sub_resource_rec.autocharge_type
2321: , p_schedule_flag => l_rev_sub_resource_rec.schedule_flag
2322: , p_hour_uom_class => l_hour_uom_class
2323: , p_res_uom_class => l_res_uom_class