eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_VALIDATE_REV_COMPONENT dependencies on BOM_GLOBALS

Line 1530: IF Bom_Globals.Get_Unit_Controlled_Item IS NULL

1526:
1527:
1528: --dbms_output.put_line('Performing Revised component Entity Validation . . .');
1529:
1530: IF Bom_Globals.Get_Unit_Controlled_Item IS NULL
1531: THEN
1532: FOR Unit_Cont_Item IN Unit_Controlled_Item
1533: LOOP
1534: IF Unit_Cont_Item.Effectivity_Control = 2

Line 1536: Bom_Globals.Set_Unit_Controlled_Item

1532: FOR Unit_Cont_Item IN Unit_Controlled_Item
1533: LOOP
1534: IF Unit_Cont_Item.Effectivity_Control = 2
1535: THEN
1536: Bom_Globals.Set_Unit_Controlled_Item
1537: ( p_unit_controlled_item => TRUE);
1538: ELSIF Unit_Cont_Item.Effectivity_Control = 1
1539: THEN
1540: Bom_Globals.Set_Unit_Controlled_Item

Line 1540: Bom_Globals.Set_Unit_Controlled_Item

1536: Bom_Globals.Set_Unit_Controlled_Item
1537: ( p_unit_controlled_item => TRUE);
1538: ELSIF Unit_Cont_Item.Effectivity_Control = 1
1539: THEN
1540: Bom_Globals.Set_Unit_Controlled_Item
1541: ( p_unit_controlled_item => FALSE);
1542: END IF;
1543: END LOOP;
1544: END IF;

Line 1546: l_is_comp_unit_controlled := Bom_GLOBALS.Get_Unit_Controlled_Component;

1542: END IF;
1543: END LOOP;
1544: END IF;
1545:
1546: l_is_comp_unit_controlled := Bom_GLOBALS.Get_Unit_Controlled_Component;
1547:
1548: -- First Query all the attributes for the Assembly item and
1549: -- component item.
1550: SELECT assy.bom_item_type,

Line 1607: Bom_GLOBALS.Check_Approved_For_Process

1603: -- scheduled revised items need to be update to Open
1604: -- and the ECO status need to be changed to Not Submitted for Approval
1605:
1606:
1607: Bom_GLOBALS.Check_Approved_For_Process
1608: (p_change_notice => p_rev_component_rec.eco_name,
1609: p_organization_id => p_rev_comp_unexp_rec.organization_id,
1610: x_processed => l_processed,
1611: x_err_text => l_err_text

Line 1617: Bom_GLOBALS.Set_Request_For_Approval

1613: IF l_processed = TRUE
1614: THEN
1615: -- If the above process returns true then set the ECO approval.
1616: BEGIN
1617: Bom_GLOBALS.Set_Request_For_Approval
1618: (p_change_notice =>
1619: p_rev_component_rec.eco_name,
1620: p_organization_id =>
1621: p_rev_comp_unexp_rec.organization_id,

Line 1655: IF p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE THEN

1651:
1652: --
1653: -- All validations that only apply to Operation Type CREATE
1654: --
1655: IF p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE THEN
1656:
1657: -- When disabling a component, to end item number must be the same
1658: -- as the value in the bill component being disabled.
1659:

Line 1694: NOT Bom_Globals.Get_Unit_Controlled_Item

1690: -- Added by AS on 07/08/99 as part of unit effectivity changes
1691:
1692: IF g_rev_component_rec.acd_type = 1 AND
1693: l_is_comp_unit_controlled AND
1694: NOT Bom_Globals.Get_Unit_Controlled_Item
1695: THEN
1696: g_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
1697: g_token_tbl(1).token_value :=
1698: g_rev_component_rec.component_item_name;

Line 1889: IF p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE

1885: --
1886: -- Item Num Check
1887: --
1888: ********************************************************************/
1889: IF p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE
1890: AND
1891: ( p_rev_component_rec.acd_type = 1 OR
1892: ( p_rev_component_rec.acd_type = 2 AND
1893: p_rev_component_rec.item_sequence_number <>

Line 1985: IF p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

1981: -- Operations specific to the Transaction Type of Update
1982: --
1983: **************************************************************************/
1984:
1985: IF p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
1986: THEN
1987:
1988: --
1989: -- Verify that the user is not trying to Update non-updateable columns

Line 2103: (Bom_GLOBALS.G_OPR_CREATE, Bom_GLOBALS.G_OPR_UPDATE)

2099: -- checks.
2100: --
2101: **************************************************************************/
2102: IF p_rev_component_rec.Transaction_Type IN
2103: (Bom_GLOBALS.G_OPR_CREATE, Bom_GLOBALS.G_OPR_UPDATE)
2104: THEN
2105: --
2106: -- Verify that the disable date is greater than effectivity date
2107: -- for both operations Create and Update

Line 2212: IF (p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE) AND

2208: -- already be implemented
2209: --
2210: *********************************************************************/
2211:
2212: IF (p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE) AND
2213: p_rev_component_rec.acd_type IN (2, 3)
2214: THEN
2215: --dbms_output.put_line('Old sequence: ' ||
2216: -- to_char(p_rev_comp_Unexp_rec.old_component_sequence_id));

Line 2267: Bom_Globals.G_OPR_CREATE

2263: ) OR
2264: ( NVL(p_rev_component_rec.new_operation_sequence_number,1) <> 1 AND
2265: ( ( p_rev_component_rec.ACD_Type = 2 AND
2266: p_rev_component_rec.transaction_type =
2267: Bom_Globals.G_OPR_CREATE
2268: ) OR
2269: p_rev_component_rec.transaction_type =
2270: Bom_Globals.G_OPR_UPDATE
2271: ) AND

Line 2270: Bom_Globals.G_OPR_UPDATE

2266: p_rev_component_rec.transaction_type =
2267: Bom_Globals.G_OPR_CREATE
2268: ) OR
2269: p_rev_component_rec.transaction_type =
2270: Bom_Globals.G_OPR_UPDATE
2271: ) AND
2272: NVL(p_old_rev_component_rec.operation_sequence_number, 1) <>
2273: NVL(p_rev_component_rec.new_operation_sequence_number, 1)
2274: )

Line 2429: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2425: -- Check whether the entered attributes match with the current
2426: -- component attributes
2427: --
2428: **********************************************************************/
2429: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2430: p_rev_component_rec.acd_type = 1
2431: ) OR
2432: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2433: p_rev_component_rec.acd_type = 2

Line 2432: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2428: **********************************************************************/
2429: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2430: p_rev_component_rec.acd_type = 1
2431: ) OR
2432: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2433: p_rev_component_rec.acd_type = 2
2434: ) OR
2435: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2436: )

Line 2435: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2431: ) OR
2432: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2433: p_rev_component_rec.acd_type = 2
2434: ) OR
2435: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2436: )
2437: AND
2438: NVL(p_Old_rev_component_rec.optional, 0) <>
2439: p_rev_component_rec.optional

Line 2478: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2474: -- Assembly and component_types.
2475: --
2476: **********************************************************************/
2477: --
2478: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2479: p_rev_component_rec.acd_type = 1 AND
2480: p_rev_component_rec.planning_percent <> 100
2481: ) OR
2482: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

Line 2482: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2478: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2479: p_rev_component_rec.acd_type = 1 AND
2480: p_rev_component_rec.planning_percent <> 100
2481: ) OR
2482: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2483: p_rev_component_rec.acd_type = 2
2484: ) OR
2485: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2486: )

Line 2485: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2481: ) OR
2482: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2483: p_rev_component_rec.acd_type = 2
2484: ) OR
2485: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2486: )
2487: AND
2488: NVL(p_Old_rev_component_rec.planning_percent, 0) <>
2489: p_rev_component_rec.planning_percent

Line 2564: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2560: --
2561: -- Check Required for Revenue / Required to Ship
2562: --
2563: **********************************************************************/
2564: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2565: p_rev_component_rec.acd_type = 1 AND
2566: ( p_rev_component_rec.required_for_revenue = 1 OR
2567: p_rev_component_rec.required_to_ship = 1
2568: )

Line 2570: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2566: ( p_rev_component_rec.required_for_revenue = 1 OR
2567: p_rev_component_rec.required_to_ship = 1
2568: )
2569: ) OR
2570: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2571: p_rev_component_rec.acd_type = 2
2572: ) OR
2573: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2574: )

Line 2573: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2569: ) OR
2570: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2571: p_rev_component_rec.acd_type = 2
2572: ) OR
2573: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2574: )
2575: AND
2576: ( NVL(p_Old_rev_component_rec.required_for_revenue, 0) <>
2577: p_rev_component_rec.required_for_revenue OR

Line 2665: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2661: -- Check Check_ATP Flag. Check_ATP can be True only if Assembly has
2662: -- Atp Components flag = Y and the Component has a Check_ATP.
2663: --
2664: ********************************************************************/
2665: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2666: p_rev_component_rec.acd_type = 1 AND
2667: p_rev_component_rec.check_atp = 1
2668: ) OR
2669: ( ( ( p_rev_component_rec.Transaction_Type =

Line 2670: Bom_GLOBALS.G_OPR_CREATE AND

2666: p_rev_component_rec.acd_type = 1 AND
2667: p_rev_component_rec.check_atp = 1
2668: ) OR
2669: ( ( ( p_rev_component_rec.Transaction_Type =
2670: Bom_GLOBALS.G_OPR_CREATE AND
2671: p_rev_component_rec.acd_type = 2
2672: ) OR
2673: p_rev_component_rec.Transaction_Type =
2674: Bom_GLOBALS.G_OPR_UPDATE

Line 2674: Bom_GLOBALS.G_OPR_UPDATE

2670: Bom_GLOBALS.G_OPR_CREATE AND
2671: p_rev_component_rec.acd_type = 2
2672: ) OR
2673: p_rev_component_rec.Transaction_Type =
2674: Bom_GLOBALS.G_OPR_UPDATE
2675: ) AND
2676: NVL(p_Old_rev_component_rec.check_atp, 0) <>
2677: p_rev_component_rec.check_atp
2678: )

Line 2709: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR

2705: -- Component is an Option Class and BOM is installed.
2706: --
2707: *********************************************************************/
2708:
2709: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR
2710: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2711: )
2712: AND
2713: p_rev_component_rec.mutually_exclusive = 1

Line 2710: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2706: --
2707: *********************************************************************/
2708:
2709: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR
2710: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2711: )
2712: AND
2713: p_rev_component_rec.mutually_exclusive = 1
2714: THEN

Line 2744: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2740: -- indecisive o/p to continue or not, the function will
2741: -- log the error or warning and return TRUE if warning
2742: -- so the process can continue or will return an FALSE if
2743: -- process needs to return
2744: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2745: p_rev_component_rec.acd_type = 1 AND
2746: p_rev_component_rec.wip_supply_type IS NOT NULL
2747: ) OR
2748: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

Line 2748: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2744: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2745: p_rev_component_rec.acd_type = 1 AND
2746: p_rev_component_rec.wip_supply_type IS NOT NULL
2747: ) OR
2748: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2749: p_rev_component_rec.acd_type = 2
2750: ) OR
2751: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2752: )

Line 2751: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2747: ) OR
2748: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2749: p_rev_component_rec.acd_type = 2
2750: ) OR
2751: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2752: )
2753: AND
2754: NVL(p_Old_rev_component_rec.wip_supply_type, 0) <>
2755: p_rev_component_rec.wip_supply_type

Line 2770: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR

2766: --dbms_output.put_line
2767: --('After verification of Supply Type . . .' || l_return_status);
2768:
2769: -- Check Minimum Quantity which must be <= Component Quantity
2770: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR
2771: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2772: ) AND
2773: p_rev_component_rec.minimum_allowed_quantity is not null
2774: AND

Line 2771: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2767: --('After verification of Supply Type . . .' || l_return_status);
2768:
2769: -- Check Minimum Quantity which must be <= Component Quantity
2770: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR
2771: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2772: ) AND
2773: p_rev_component_rec.minimum_allowed_quantity is not null
2774: AND
2775: NOT Check_Min_Quantity THEN

Line 2790: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR

2786: END IF;
2787:
2788: -- Check Maximun Quantity which must be >= Component Quantity or
2789: -- should be NULL if the minimum quantity is NULL.
2790: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR
2791: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2792: ) AND
2793: p_rev_component_rec.maximum_allowed_quantity IS NOT NULL
2794: AND

Line 2791: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2787:
2788: -- Check Maximun Quantity which must be >= Component Quantity or
2789: -- should be NULL if the minimum quantity is NULL.
2790: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR
2791: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2792: ) AND
2793: p_rev_component_rec.maximum_allowed_quantity IS NOT NULL
2794: AND
2795: NOT Check_Max_Quantity THEN

Line 2831: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR

2827: Is_Item_ATO := Is_Item_ATO_PTO.replenish_to_order_flag;
2828: Is_Item_PTO := Is_Item_ATO_PTO.pick_components_flag;
2829: END LOOP;
2830:
2831: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR
2832: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2833: ) AND
2834: (Is_OE_Installed = 'I'
2835: AND ( ( Is_Item_ATO = 'Y' OR

Line 2832: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2828: Is_Item_PTO := Is_Item_ATO_PTO.pick_components_flag;
2829: END LOOP;
2830:
2831: IF ( p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_CREATE OR
2832: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2833: ) AND
2834: (Is_OE_Installed = 'I'
2835: AND ( ( Is_Item_ATO = 'Y' OR
2836: Is_Item_PTO = 'Y'

Line 2910: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2906: --
2907: -- Check Supply Subinventory
2908: --
2909: ********************************************************************/
2910: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2911: p_rev_component_rec.acd_type = 1 AND
2912: p_rev_component_rec.Supply_SubInventory IS NOT NULL
2913: ) OR
2914: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

Line 2914: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2910: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2911: p_rev_component_rec.acd_type = 1 AND
2912: p_rev_component_rec.Supply_SubInventory IS NOT NULL
2913: ) OR
2914: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2915: p_rev_component_rec.acd_type = 2
2916: ) OR
2917: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2918: )

Line 2917: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2913: ) OR
2914: (((p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2915: p_rev_component_rec.acd_type = 2
2916: ) OR
2917: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2918: )
2919: AND
2920: NVL(p_Old_rev_component_rec.supply_subinventory, 'NONE') <>
2921: NVL(p_rev_component_rec.supply_subinventory, 'NONE')

Line 2945: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2941: --
2942: -- Check Locators
2943: --
2944: ********************************************************************/
2945: IF (( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2946: p_rev_component_rec.acd_type = 1 AND
2947: p_rev_component_rec.Supply_SubInventory IS NOT NULL AND
2948: p_rev_component_rec.Supply_SubInventory <> FND_API.G_MISS_CHAR
2949: ) OR

Line 2950: ((( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND

2946: p_rev_component_rec.acd_type = 1 AND
2947: p_rev_component_rec.Supply_SubInventory IS NOT NULL AND
2948: p_rev_component_rec.Supply_SubInventory <> FND_API.G_MISS_CHAR
2949: ) OR
2950: ((( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2951: p_rev_component_rec.acd_type = 2
2952: ) OR
2953: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2954: )

Line 2953: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE

2949: ) OR
2950: ((( p_rev_component_rec.Transaction_Type=Bom_GLOBALS.G_OPR_CREATE AND
2951: p_rev_component_rec.acd_type = 2
2952: ) OR
2953: p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_UPDATE
2954: )
2955: AND
2956: NVL(p_Old_rev_comp_unexp_rec.supply_locator_id, 0) <>
2957: NVL(p_rev_comp_unexp_rec.supply_locator_id, 0)

Line 3215: IF p_rev_component_rec.transaction_type = Bom_GLOBALS.G_OPR_CREATE AND

3211: -- Validate rev_component attributes
3212:
3213: /* -- Not necessary since the UUI to UI conversions take care of this
3214:
3215: IF p_rev_component_rec.transaction_type = Bom_GLOBALS.G_OPR_CREATE AND
3216: (p_rev_component_rec.from_end_item_unit_number IS NOT NULL
3217: OR
3218: p_rev_component_rec.from_end_item_unit_number <> FND_API.G_MISS_CHAR)
3219: THEN

Line 3245: IF p_rev_component_rec.transaction_type = Bom_GLOBALS.G_OPR_CREATE AND

3241: END IF;
3242: END IF;
3243: */
3244:
3245: IF p_rev_component_rec.transaction_type = Bom_GLOBALS.G_OPR_CREATE AND
3246: (p_rev_component_rec.to_end_item_unit_number IS NOT NULL
3247: OR
3248: p_rev_component_rec.to_end_item_unit_number <> FND_API.G_MISS_CHAR)
3249: THEN

Line 3280: IF p_rev_component_rec.transaction_type = Bom_GLOBALS.G_OPR_CREATE AND

3276: END IF;
3277: END IF;
3278: END IF;
3279:
3280: IF p_rev_component_rec.transaction_type = Bom_GLOBALS.G_OPR_CREATE AND
3281: p_rev_component_rec.to_end_item_unit_number = FND_API.G_MISS_CHAR
3282: THEN
3283: Error_Handler.Add_Error_Token
3284: ( p_Message_Name => 'ENG_CMP_TO_UNIT_NUM_NULL'

Line 3584: IF p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_DELETE THEN

3580:
3581: --
3582: -- Verify that the component is not already cancelled.
3583: --
3584: IF p_rev_component_rec.Transaction_Type = Bom_GLOBALS.G_OPR_DELETE THEN
3585: BEGIN
3586: SELECT 'Component cancelled'
3587: INTO l_dummy
3588: FROM sys.dual

Line 3685: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND

3681: , x_Rev_Comp_Unexp_Rec => x_old_rev_comp_unexp_rec
3682: , x_Return_Status => l_return_status
3683: );
3684:
3685: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND
3686: p_rev_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE
3687: THEN
3688: Error_Handler.Add_Error_Token
3689: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 3686: p_rev_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE

3682: , x_Return_Status => l_return_status
3683: );
3684:
3685: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND
3686: p_rev_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE
3687: THEN
3688: Error_Handler.Add_Error_Token
3689: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
3690: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3695: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND

3691: , p_message_name => 'ENG_REV_COMP_ALREADY_EXISTS'
3692: , p_token_tbl => l_token_tbl
3693: );
3694: l_return_status := FND_API.G_RET_STS_ERROR;
3695: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
3696: p_rev_component_rec.transaction_type IN
3697: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
3698: THEN
3699: Error_Handler.Add_Error_Token

Line 3697: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)

3693: );
3694: l_return_status := FND_API.G_RET_STS_ERROR;
3695: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
3696: p_rev_component_rec.transaction_type IN
3697: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
3698: THEN
3699: Error_Handler.Add_Error_Token
3700: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
3701: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3769: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE,

3765: -- error.
3766: *******************************************************************/
3767:
3768: IF p_rev_component_rec.transaction_type IN
3769: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE,
3770: Bom_Globals.G_OPR_CANCEL)
3771: THEN
3772: FOR Component IN c_GetComponent LOOP
3773: IF Component.revised_item_sequence_id <>

Line 3770: Bom_Globals.G_OPR_CANCEL)

3766: *******************************************************************/
3767:
3768: IF p_rev_component_rec.transaction_type IN
3769: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE,
3770: Bom_Globals.G_OPR_CANCEL)
3771: THEN
3772: FOR Component IN c_GetComponent LOOP
3773: IF Component.revised_item_sequence_id <>
3774: p_rev_comp_unexp_rec.revised_item_sequence_id

Line 3917: (NVL(Bom_Globals.Get_MDL_Item_Access,0),

3913: WHERE inventory_item_id = p_component_item_id
3914: AND organization_id = p_organization_id;
3915:
3916: IF l_rev_comp_item_type NOT IN
3917: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
3918: NVL(Bom_Globals.Get_OC_Item_Access,0),
3919: NVL(Bom_Globals.Get_PLN_Item_Access,0),
3920: NVL(Bom_Globals.Get_STD_Item_Access,0)
3921: )

Line 3918: NVL(Bom_Globals.Get_OC_Item_Access,0),

3914: AND organization_id = p_organization_id;
3915:
3916: IF l_rev_comp_item_type NOT IN
3917: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
3918: NVL(Bom_Globals.Get_OC_Item_Access,0),
3919: NVL(Bom_Globals.Get_PLN_Item_Access,0),
3920: NVL(Bom_Globals.Get_STD_Item_Access,0)
3921: )
3922: THEN

Line 3919: NVL(Bom_Globals.Get_PLN_Item_Access,0),

3915:
3916: IF l_rev_comp_item_type NOT IN
3917: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
3918: NVL(Bom_Globals.Get_OC_Item_Access,0),
3919: NVL(Bom_Globals.Get_PLN_Item_Access,0),
3920: NVL(Bom_Globals.Get_STD_Item_Access,0)
3921: )
3922: THEN
3923: l_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';

Line 3920: NVL(Bom_Globals.Get_STD_Item_Access,0)

3916: IF l_rev_comp_item_type NOT IN
3917: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
3918: NVL(Bom_Globals.Get_OC_Item_Access,0),
3919: NVL(Bom_Globals.Get_PLN_Item_Access,0),
3920: NVL(Bom_Globals.Get_STD_Item_Access,0)
3921: )
3922: THEN
3923: l_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
3924: l_token_tbl(1).token_value := p_component_name;

Line 3974: IF Bom_Globals.Is_RComp_Cancl IS NULL THEN

3970: -- parent record is not cancelled.
3971: --
3972: ********************************************************************/
3973:
3974: IF Bom_Globals.Is_RComp_Cancl IS NULL THEN
3975: FOR RevComp IN c_CheckCancelled
3976: LOOP
3977: l_token_tbl.DELETE;
3978: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';

Line 4000: Bom_Globals.Set_Unit_Controlled_Component

3996: FOR UnitEffective IN c_Check_Unit_Effective
3997: LOOP
3998: IF UnitEffective.Effectivity_Control = 2
3999: THEN
4000: Bom_Globals.Set_Unit_Controlled_Component
4001: ( p_unit_controlled_component => TRUE);
4002:
4003: l_is_comp_unit_controlled := TRUE;
4004:

Line 4007: Bom_Globals.Set_Unit_Controlled_Component

4003: l_is_comp_unit_controlled := TRUE;
4004:
4005: ELSIF UnitEffective.Effectivity_Control = 1
4006: THEN
4007: Bom_Globals.Set_Unit_Controlled_Component
4008: ( p_unit_controlled_component => FALSE);
4009:
4010: l_is_comp_unit_controlled := FALSE;
4011: END IF;

Line 4014: IF NOT Bom_Globals.Get_Unit_Effectivity AND

4010: l_is_comp_unit_controlled := FALSE;
4011: END IF;
4012: END LOOP;
4013:
4014: IF NOT Bom_Globals.Get_Unit_Effectivity AND
4015: l_is_comp_unit_controlled
4016: THEN
4017: l_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
4018: l_token_tbl(1).token_value :=