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_REVISED_ITEM dependencies on ENG_GLOBALS

Line 2096: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

2092: p_revised_item_rec.updated_revised_item_revision =
2093: FND_API.G_MISS_CHAR
2094: AND
2095: p_revised_item_rec.alternate_bom_code IS NULL AND
2096: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
2097: THEN
2098: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2099: THEN
2100: Error_Handler.Add_Error_Token

Line 2461: l_plm_or_erp_change := Eng_Globals.Get_PLM_Or_ERP_Change(p_revised_item_rec.eco_name, p_rev_item_unexp_rec.organization_id);

2457: IF (p_control_rec.caller_type = 'SSWA')
2458: THEN
2459: l_plm_or_erp_change := 'PLM';
2460: ELSE
2461: l_plm_or_erp_change := Eng_Globals.Get_PLM_Or_ERP_Change(p_revised_item_rec.eco_name, p_rev_item_unexp_rec.organization_id);
2462: END IF;
2463: /*********************************************************************************
2464: ** Added by MK on 08/25/2000.
2465: ** Check Entity for New ECO Effectivities and ECO Routing.

Line 2474: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR

2470: -- Lot Number and Cum Qty must be null
2471: -- Added by MK 08/25/2000
2472: **********************************************************************/
2473: IF l_is_item_unit_controlled AND
2474: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
2475: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE)
2476: AND
2477: ( p_revised_item_rec.lot_number IS NOT NULL OR
2478: p_revised_item_rec.from_cumulative_quantity IS NOT NULL OR

Line 2475: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE)

2471: -- Added by MK 08/25/2000
2472: **********************************************************************/
2473: IF l_is_item_unit_controlled AND
2474: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
2475: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE)
2476: AND
2477: ( p_revised_item_rec.lot_number IS NOT NULL OR
2478: p_revised_item_rec.from_cumulative_quantity IS NOT NULL OR
2479: p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL OR

Line 2505: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2501: -- If MRP Active is not No and Update WIP is not Yes, From Work Order,
2502: -- To Work Order Lot Number and Cum Qty must be null
2503: -- Added by MK 08/25/2000
2504: **********************************************************************/
2505: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2506: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2507: AND ( p_revised_item_rec.mrp_active <> 2 OR
2508: p_revised_item_rec.update_wip <> 1 )
2509: AND

Line 2506: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2502: -- To Work Order Lot Number and Cum Qty must be null
2503: -- Added by MK 08/25/2000
2504: **********************************************************************/
2505: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2506: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2507: AND ( p_revised_item_rec.mrp_active <> 2 OR
2508: p_revised_item_rec.update_wip <> 1 )
2509: AND
2510: ( p_revised_item_rec.lot_number IS NOT NULL OR

Line 2543: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2539: /*****************************************************************
2540: -- If From Work Order is not Null then Lot Number must be Null
2541: -- Added by MK 08/25/2000
2542: ******************************************************************/
2543: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2544: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2545: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2546: AND p_revised_item_rec.lot_number IS NOT NULL
2547: THEN

Line 2544: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2540: -- If From Work Order is not Null then Lot Number must be Null
2541: -- Added by MK 08/25/2000
2542: ******************************************************************/
2543: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2544: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2545: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2546: AND p_revised_item_rec.lot_number IS NOT NULL
2547: THEN
2548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2570: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2566: -- If To Work Order is not Null then
2567: -- From Work Order must not be null
2568: -- Added by MK 08/25/2000
2569: ******************************************************************/
2570: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2571: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2572: AND p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL
2573: AND p_rev_item_unexp_rec.from_wip_entity_id IS NULL
2574: THEN

Line 2571: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2567: -- From Work Order must not be null
2568: -- Added by MK 08/25/2000
2569: ******************************************************************/
2570: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2571: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2572: AND p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL
2573: AND p_rev_item_unexp_rec.from_wip_entity_id IS NULL
2574: THEN
2575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2595: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2591: -- If To Work Order is not Null then
2592: -- To Work Order must be greater than From Work Order
2593: -- Added by MK 08/25/2000
2594: ******************************************************************/
2595: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2596: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2597: AND p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL
2598: AND ( p_revised_item_rec.from_work_order > p_revised_item_rec.to_work_order
2599: OR p_rev_item_unexp_rec.from_wip_entity_id IS NULL)

Line 2596: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2592: -- To Work Order must be greater than From Work Order
2593: -- Added by MK 08/25/2000
2594: ******************************************************************/
2595: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2596: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2597: AND p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL
2598: AND ( p_revised_item_rec.from_work_order > p_revised_item_rec.to_work_order
2599: OR p_rev_item_unexp_rec.from_wip_entity_id IS NULL)
2600: THEN

Line 2622: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2618: -- If From Work Order and To Work Order is not Null then
2619: -- Cumulative Quantity must be null.
2620: -- Added by MK 08/25/2000
2621: ******************************************************************/
2622: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2623: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2624: AND p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL
2625: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2626: AND p_revised_item_rec.from_cumulative_quantity IS NOT NULL

Line 2623: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2619: -- Cumulative Quantity must be null.
2620: -- Added by MK 08/25/2000
2621: ******************************************************************/
2622: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2623: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2624: AND p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL
2625: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2626: AND p_revised_item_rec.from_cumulative_quantity IS NOT NULL
2627: THEN

Line 2649: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2645: -- If Cumulative Quantity is not null then
2646: -- From Work Order must not be null and To Work Order must be null.
2647: -- Added by MK 08/25/2000
2648: ******************************************************************/
2649: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2650: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2651: AND ( p_rev_item_unexp_rec.from_wip_entity_id IS NULL
2652: OR p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL )
2653: AND p_revised_item_rec.from_cumulative_quantity IS NOT NULL

Line 2650: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2646: -- From Work Order must not be null and To Work Order must be null.
2647: -- Added by MK 08/25/2000
2648: ******************************************************************/
2649: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2650: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2651: AND ( p_rev_item_unexp_rec.from_wip_entity_id IS NULL
2652: OR p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL )
2653: AND p_revised_item_rec.from_cumulative_quantity IS NOT NULL
2654: THEN

Line 2677: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2673: -- If From Work Order is not null then
2674: -- To Work Order or Cumulative Quantity must not be null.
2675: -- Added by MK 08/25/2000
2676: ******************************************************************/
2677: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2678: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2679: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2680: AND p_rev_item_unexp_rec.to_wip_entity_id IS NULL
2681: AND p_revised_item_rec.from_cumulative_quantity IS NULL

Line 2678: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2674: -- To Work Order or Cumulative Quantity must not be null.
2675: -- Added by MK 08/25/2000
2676: ******************************************************************/
2677: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2678: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2679: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2680: AND p_rev_item_unexp_rec.to_wip_entity_id IS NULL
2681: AND p_revised_item_rec.from_cumulative_quantity IS NULL
2682: THEN

Line 2705: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2701: -- If Lot Number is not null then
2702: -- From Work Order, To Work Order and Cum Quantity must be null.
2703: -- Added by MK 08/25/2000
2704: ******************************************************************/
2705: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2706: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2707: AND p_revised_item_rec.lot_number IS NOT NULL
2708: THEN
2709:

Line 2706: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2702: -- From Work Order, To Work Order and Cum Quantity must be null.
2703: -- Added by MK 08/25/2000
2704: ******************************************************************/
2705: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2706: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2707: AND p_revised_item_rec.lot_number IS NOT NULL
2708: THEN
2709:
2710: IF ( p_revised_item_rec.from_cumulative_quantity IS NOT NULL OR

Line 2768: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2764: -- From Cum Qty must be smaller or equal than Wip Job's Start Qty
2765: -- Rev Item Effective Date msut be past than WIP Job's start date
2766: -- Added by MK 08/25/2000
2767: ******************************************************************/
2768: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2769: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2770: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2771: AND p_revised_item_rec.from_cumulative_quantity IS NOT NULL
2772: AND p_revised_item_rec.lot_number IS NULL

Line 2769: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2765: -- Rev Item Effective Date msut be past than WIP Job's start date
2766: -- Added by MK 08/25/2000
2767: ******************************************************************/
2768: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2769: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2770: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2771: AND p_revised_item_rec.from_cumulative_quantity IS NOT NULL
2772: AND p_revised_item_rec.lot_number IS NULL
2773: AND p_rev_item_unexp_rec.to_wip_entity_id IS NULL

Line 2846: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2842: -- must be unreleased order.
2843: -- Rev Item Effective Date msut be past than WIP Job's start date
2844: -- Added by MK 08/25/2000
2845: ******************************************************************/
2846: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2847: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2848: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2849: AND p_revised_item_rec.from_cumulative_quantity IS NULL
2850: AND p_revised_item_rec.lot_number IS NULL

Line 2847: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2843: -- Rev Item Effective Date msut be past than WIP Job's start date
2844: -- Added by MK 08/25/2000
2845: ******************************************************************/
2846: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2847: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2848: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2849: AND p_revised_item_rec.from_cumulative_quantity IS NULL
2850: AND p_revised_item_rec.lot_number IS NULL
2851: AND p_revised_item_rec.from_work_order <= p_revised_item_rec.to_work_order

Line 2902: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2898: -- Modified by MK 01/29/2001
2899: -- Eco for produciton must be Yes when Eco type is Eco by Prod
2900: -- also Eco for production must be No when Eco Type is not Eco by Prod.
2901: ******************************************************************/
2902: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2903: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2904: AND p_revised_item_rec.eco_for_production = 1 -- Yes
2905: AND
2906: ( p_revised_item_rec.lot_number IS NULL AND

Line 2903: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2899: -- Eco for produciton must be Yes when Eco type is Eco by Prod
2900: -- also Eco for production must be No when Eco Type is not Eco by Prod.
2901: ******************************************************************/
2902: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2903: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2904: AND p_revised_item_rec.eco_for_production = 1 -- Yes
2905: AND
2906: ( p_revised_item_rec.lot_number IS NULL AND
2907: p_rev_item_unexp_rec.from_wip_entity_id IS NULL

Line 2923: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2919: END IF;
2920: l_return_status := FND_API.G_RET_STS_ERROR;
2921:
2922: ELSIF
2923: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2924: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2925: AND p_revised_item_rec.eco_for_production = 2 -- No
2926: AND
2927: ( p_revised_item_rec.lot_number IS NOT NULL OR

Line 2924: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2920: l_return_status := FND_API.G_RET_STS_ERROR;
2921:
2922: ELSIF
2923: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2924: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2925: AND p_revised_item_rec.eco_for_production = 2 -- No
2926: AND
2927: ( p_revised_item_rec.lot_number IS NOT NULL OR
2928: p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL

Line 2949: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR

2945: -- Added by MK on 08/26/2000.
2946: -- If revised item is unit controlled, the user must not update
2947: -- modifiy current routing
2948: **********************************************************************/
2949: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2950: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2951: AND l_is_item_unit_controlled
2952: AND ( p_revised_item_rec.completion_subinventory IS NOT NULL OR
2953: p_revised_item_rec.new_routing_revision IS NOT NULL OR

Line 2950: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )

2946: -- If revised item is unit controlled, the user must not update
2947: -- modifiy current routing
2948: **********************************************************************/
2949: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE OR
2950: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2951: AND l_is_item_unit_controlled
2952: AND ( p_revised_item_rec.completion_subinventory IS NOT NULL OR
2953: p_revised_item_rec.new_routing_revision IS NOT NULL OR
2954: p_revised_item_rec.updated_routing_revision IS NOT NULL OR

Line 3005: p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE AND

3001: -- Cannot update alternate routing designator
3002: **********************************************************************/
3003: IF p_revised_item_rec.alternate_bom_code IS NOT NULL AND
3004: p_revised_item_rec.alternate_bom_code <> p_old_revised_item_rec.alternate_bom_code AND -- R12:LKASTURI:7/11/2005
3005: p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE AND
3006: ( NVL(p_rev_item_unexp_rec.routing_sequence_id, 0) <>
3007: NVL(p_old_rev_item_unexp_rec.routing_sequence_id, 0) OR
3008: NVL(p_rev_item_unexp_rec.bill_sequence_id, 0) <>
3009: NVL(p_old_rev_item_unexp_rec.bill_sequence_id, 0)

Line 3054: p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE

3050: END LOOP;
3051:
3052: IF l_alternate_rtg_designator IS NOT NULL AND
3053: p_revised_item_rec.alternate_bom_code <> l_alternate_rtg_designator AND
3054: p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE
3055: THEN
3056: l_token_tbl.DELETE;
3057: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3058: l_token_tbl(1).token_value :=

Line 3106: AND p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3102: OR p_revised_item_rec.completion_location_name IS NOT NULL
3103: OR p_revised_item_rec.priority IS NOT NULL
3104: OR p_revised_item_rec.routing_comment IS NOT NULL
3105: )
3106: AND p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3107: THEN
3108:
3109: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3110: THEN

Line 3133: p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_CREATE

3129: -- Cannot have routing revision, if routing is an alternate.
3130: **********************************************************************/
3131: IF p_revised_item_rec.new_routing_revision IS NOT NULL AND
3132: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
3133: p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_CREATE
3134: THEN
3135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3136: THEN
3137: Error_Handler.Add_Error_Token

Line 3146: ELSIF p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE AND

3142: );
3143:
3144: END IF;
3145: l_return_status := FND_API.G_RET_STS_ERROR;
3146: ELSIF p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE AND
3147: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
3148: p_revised_item_rec.updated_routing_revision IS NOT NULL
3149: THEN
3150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 3262: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

3258: **********************************************************************/
3259:
3260: IF ( p_revised_item_rec.updated_routing_revision <>
3261: p_old_revised_item_rec.new_routing_revision AND
3262: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3263: ) OR
3264: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3265: THEN
3266: --

Line 3264: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3260: IF ( p_revised_item_rec.updated_routing_revision <>
3261: p_old_revised_item_rec.new_routing_revision AND
3262: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3263: ) OR
3264: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3265: THEN
3266: --
3267: -- if the transaction type is create, the check new_routing_revision
3268: --

Line 3269: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3265: THEN
3266: --
3267: -- if the transaction type is create, the check new_routing_revision
3268: --
3269: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3270: THEN
3271: l_new_revision_status :=
3272: Validate_New_Rtg_Revision
3273: ( p_revised_item_id => p_rev_item_unexp_rec.revised_item_id

Line 3317: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3313: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3314: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3315:
3316: -- Added by MK on 11/05/00
3317: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3318: THEN
3319: l_token_tbl(2).token_name := 'NEW_RTG_REVISION';
3320: l_token_tbl(2).token_value := p_revised_item_rec.new_routing_revision;
3321: ELSE

Line 3370: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

3366: -- Added by MK 08/26/2000
3367: -- if the transaction type is create or update, the check ctp_flag
3368: **********************************************************************/
3369: IF ( p_revised_item_rec.ctp_flag <> p_old_revised_item_rec.ctp_flag AND
3370: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3371: ) OR
3372: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
3373: p_revised_item_rec.ctp_flag = 1
3374: THEN

Line 3372: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

3368: **********************************************************************/
3369: IF ( p_revised_item_rec.ctp_flag <> p_old_revised_item_rec.ctp_flag AND
3370: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3371: ) OR
3372: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
3373: p_revised_item_rec.ctp_flag = 1
3374: THEN
3375: IF NOT Check_CTP_Flag
3376: ( p_revised_item_id => p_rev_item_unexp_rec.revised_item_id

Line 3405: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

3401: -- Added by MK 08/26/2000
3402: -- if the transaction type is create or update, the check priority
3403: **********************************************************************/
3404: IF ( p_revised_item_rec.priority <> p_old_revised_item_rec.priority AND
3405: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3406: ) OR
3407: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
3408: p_revised_item_rec.priority IS NOT NULL
3409: THEN

Line 3407: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

3403: **********************************************************************/
3404: IF ( p_revised_item_rec.priority <> p_old_revised_item_rec.priority AND
3405: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3406: ) OR
3407: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
3408: p_revised_item_rec.priority IS NOT NULL
3409: THEN
3410: IF NOT Check_Priority
3411: ( p_revised_item_id => p_rev_item_unexp_rec.revised_item_id

Line 3445: IF (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

3441: || p_revised_item_rec.completion_subinventory ) ;
3442: Error_Handler.Write_Debug('Old Completion_subinv is:'||p_old_revised_item_rec.completion_subinventory );
3443: END IF;
3444:
3445: IF (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3446: AND
3447: NVL(p_revised_item_rec.completion_subinventory, '0') <>
3448: NVL(p_old_revised_item_rec.completion_subinventory, '0')
3449: )

Line 3450: OR p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3446: AND
3447: NVL(p_revised_item_rec.completion_subinventory, '0') <>
3448: NVL(p_old_revised_item_rec.completion_subinventory, '0')
3449: )
3450: OR p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3451: )
3452: AND ( p_revised_item_rec.completion_subinventory IS NULL
3453: OR p_revised_item_rec.completion_subinventory = FND_API.G_MISS_CHAR)
3454: THEN

Line 3481: (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

3477: END IF;
3478:
3479: -- Check if Subinventory exists
3480: ELSIF
3481: (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3482: AND NVL(p_revised_item_rec.completion_subinventory, '0') <>
3483: NVL(p_old_revised_item_rec.completion_subinventory, '0')
3484: )
3485: OR p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

Line 3485: OR p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3481: (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3482: AND NVL(p_revised_item_rec.completion_subinventory, '0') <>
3483: NVL(p_old_revised_item_rec.completion_subinventory, '0')
3484: )
3485: OR p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3486: )
3487: AND ( p_revised_item_rec.completion_subinventory IS NOT NULL
3488: OR p_revised_item_rec.completion_subinventory <> FND_API.G_MISS_CHAR)
3489: THEN

Line 3770: AND (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

3766: Null;
3767: Else
3768: IF p_control_rec.caller_type <> 'FORM'
3769: AND p_revised_item_rec.completion_subinventory is not null -- Bug 2871420 added this condition
3770: AND (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3771: AND NVL(p_rev_item_unexp_rec.completion_locator_id , 0) <>
3772: NVL(p_old_rev_item_unexp_rec.completion_locator_id , 0)
3773: )
3774: OR (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

Line 3774: OR (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3770: AND (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3771: AND NVL(p_rev_item_unexp_rec.completion_locator_id , 0) <>
3772: NVL(p_old_rev_item_unexp_rec.completion_locator_id , 0)
3773: )
3774: OR (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3775: AND p_revised_item_rec.completion_subinventory is not null
3776: AND p_revised_item_rec.completion_subinventory <> FND_API.G_MISS_CHAR)
3777: )
3778: AND NOT Check_Locators( p_organization_id => p_rev_item_unexp_rec.organization_id

Line 3893: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

3889: -- Added by MK 08/26/2000
3890: -- Check Mixed_Model_Map_Flag for future release
3891:
3892: IF ( p_revised_item_rec.mixed_model_map <> p_old_revised_item_rec.mixed_model_map AND
3893: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3894: ) OR
3895: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
3896: p_revised_item_rec.mixed_model_map = 1
3897: THEN

Line 3895: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

3891:
3892: IF ( p_revised_item_rec.mixed_model_map <> p_old_revised_item_rec.mixed_model_map AND
3893: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
3894: ) OR
3895: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
3896: p_revised_item_rec.mixed_model_map = 1
3897: THEN
3898: IF NOT Check_Mixed_Model_Map THEN
3899: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 3924: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

3920: -- Added by AS on 07/06.
3921: -- If revised item is unit controlled, the user must enter a
3922: -- From End Item Unit Number
3923: **********************************************************************/
3924: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
3925: l_plm_or_erp_change <> 'PLM' AND -- not required for plm
3926: l_is_item_unit_controlled AND
3927: p_revised_item_rec.from_end_item_unit_number IS NULL
3928: THEN

Line 3952: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3948: not chosen.
3949:
3950: IF p_revised_item_rec.use_up_plan_name IS NOT NULL AND
3951: p_revised_item_rec.use_up_item_name IS NULL AND
3952: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3953: THEN
3954: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3955: THEN
3956: Error_Handler.Add_Error_Token

Line 3967: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3963: l_return_status := FND_API.G_RET_STS_ERROR;
3964:
3965: ELSIF p_revised_item_rec.use_up_plan_name IS NULL AND
3966: p_revised_item_rec.use_up_item_name IS NOT NULL AND
3967: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3968: THEN
3969: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3970: THEN
3971: Error_Handler.Add_Error_Token

Line 4083: IF ENG_Globals.ECO_Cannot_Update

4079: -- (a process and Approval Status of 'Approval Requested')
4080: -- or is cancelled or implemented
4081: --
4082: *********************************************************************/
4083: IF ENG_Globals.ECO_Cannot_Update
4084: ( p_change_notice => p_revised_item_rec.Eco_Name
4085: , p_organization_id => p_rev_item_unexp_rec.organization_id
4086: )
4087: AND p_control_rec.caller_type <> 'SSWA' -- not required for plm

Line 4107: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE AND

4103: --
4104: -- Creating a record with status of Cancelled should get an error.
4105: --
4106: *********************************************************************/
4107: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE AND
4108: p_revised_item_rec.status_type = 5
4109: THEN
4110: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4111: THEN

Line 4134: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE AND

4130: FOR x_count IN c_CheckItemProductFamily LOOP
4131: l_product_family := TRUE;
4132: END LOOP;
4133:
4134: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE AND
4135: l_product_family
4136: THEN
4137: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4138: THEN

Line 4155: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

4151: -- entered
4152: **********************************************************************/
4153: -- removed for solving conflicting with unique check in ENGSVIDB.pls
4154: /* IF l_is_item_unit_controlled AND
4155: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
4156: p_revised_item_rec.start_effective_date IS NOT NULL)
4157: OR
4158: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
4159: p_revised_item_rec.new_effective_date IS NOT NULL))

Line 4158: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND

4154: /* IF l_is_item_unit_controlled AND
4155: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
4156: p_revised_item_rec.start_effective_date IS NOT NULL)
4157: OR
4158: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
4159: p_revised_item_rec.new_effective_date IS NOT NULL))
4160: THEN
4161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4162: THEN

Line 4180: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

4176: -- If revised item is not unit controlled, no unit number must be
4177: -- entered
4178: **********************************************************************/
4179: IF NOT l_is_item_unit_controlled AND
4180: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
4181: p_revised_item_rec.from_end_item_unit_number IS NOT NULL)
4182: OR
4183: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
4184: p_revised_item_rec.new_from_end_item_unit_number IS NOT NULL))

Line 4183: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND

4179: IF NOT l_is_item_unit_controlled AND
4180: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
4181: p_revised_item_rec.from_end_item_unit_number IS NOT NULL)
4182: OR
4183: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
4184: p_revised_item_rec.new_from_end_item_unit_number IS NOT NULL))
4185: THEN
4186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4187: THEN

Line 4265: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_UPDATE

4261: --
4262: **********************************************************************/
4263:
4264: IF p_revised_item_rec.new_effective_date = FND_API.G_MISS_DATE AND
4265: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_UPDATE
4266: THEN
4267: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4268: THEN
4269: Error_Handler.Add_Error_Token

Line 4354: ENG_Globals.Get_ECO_Assembly_Type

4350: THEN
4351: l_assembly_type := p_control_rec.eco_assembly_type ;
4352: ELSE
4353: l_assembly_type :=
4354: ENG_Globals.Get_ECO_Assembly_Type
4355: ( p_change_notice => p_revised_item_rec.eco_name
4356: , p_organization_id => p_rev_item_unexp_rec.organization_id
4357: );
4358: END IF ;

Line 4374: p_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE AND

4370: --
4371: *********************************************************************/
4372:
4373: IF p_control_rec.caller_type <> 'FORM' AND
4374: p_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE AND
4375: NOT Compatible_Item_Type
4376: ( p_assembly_type => l_assembly_type
4377: , p_revised_item_id => p_rev_item_unexp_rec.revised_item_id
4378: , p_organization_id => p_rev_item_unexp_rec.organization_id

Line 4408: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

4404: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Start effective Date: ' ||
4405: to_char(p_revised_item_rec.start_effective_date));
4406: END IF;
4407: IF NOT l_is_item_unit_controlled AND
4408: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
4409: trunc(p_revised_item_rec.earliest_effective_date) >
4410: trunc(p_revised_item_rec.start_effective_date))
4411: OR
4412: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND

Line 4412: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND

4408: ((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
4409: trunc(p_revised_item_rec.earliest_effective_date) >
4410: trunc(p_revised_item_rec.start_effective_date))
4411: OR
4412: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
4413: trunc(p_revised_item_rec.earliest_effective_date) >
4414: NVL(trunc(p_revised_item_rec.new_effective_date),
4415: p_revised_item_rec.start_effective_date)))
4416: THEN

Line 4448: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR

4444: IF p_revised_item_rec.use_up_plan_name IS NOT NULL AND
4445: p_rev_item_unexp_rec.use_up_item_id IS NOT NULL AND -- Added by MK on 10/31/00
4446: p_revised_item_rec.start_effective_date IS NOT NULL AND
4447: p_revised_item_rec.start_effective_date <> FND_API.G_MISS_DATE AND
4448: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
4449: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
4450: AND
4451: ( p_revised_item_rec.new_effective_date IS NOT NULL AND
4452: p_revised_item_rec.new_effective_date <> FND_API.G_MISS_DATE

Line 4449: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

4445: p_rev_item_unexp_rec.use_up_item_id IS NOT NULL AND -- Added by MK on 10/31/00
4446: p_revised_item_rec.start_effective_date IS NOT NULL AND
4447: p_revised_item_rec.start_effective_date <> FND_API.G_MISS_DATE AND
4448: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
4449: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
4450: AND
4451: ( p_revised_item_rec.new_effective_date IS NOT NULL AND
4452: p_revised_item_rec.new_effective_date <> FND_API.G_MISS_DATE
4453: )

Line 4458: IF p_revised_item_rec.transaction_type=ENG_GLOBALS.G_OPR_CREATE

4454: )
4455: )
4456: THEN
4457: l_IsDateValid := FALSE;
4458: IF p_revised_item_rec.transaction_type=ENG_GLOBALS.G_OPR_CREATE
4459: THEN
4460: l_IsDateValid :=
4461: Check_Date
4462: ( p_revised_item_id =>

Line 4527: p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE

4523: --
4524: ***********************************************************************/
4525:
4526: IF ( ( p_rev_item_unexp_rec.use_up_item_id IS NOT NULL AND
4527: p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE
4528: ) OR
4529: ( p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
4530: AND
4531: p_rev_item_unexp_rec.use_up_item_id <>

Line 4529: ( p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE

4525:
4526: IF ( ( p_rev_item_unexp_rec.use_up_item_id IS NOT NULL AND
4527: p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE
4528: ) OR
4529: ( p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
4530: AND
4531: p_rev_item_unexp_rec.use_up_item_id <>
4532: NVL(p_old_rev_item_unexp_rec.use_up_item_id, 0)
4533: )

Line 4599: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE AND

4595: error_handler.write_debug('Assem Type : ' || to_char(l_assembly_type) );
4596: END IF;
4597:
4598:
4599: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE AND
4600: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
4601: ( NOT Eng_Primary_Bill_Exists
4602: ( p_Revised_Item_Id => p_rev_item_unexp_rec.revised_item_id
4603: , p_Organization_Id => p_rev_item_unexp_rec.organization_id

Line 4640: IF p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_CREATE AND

4636: END IF;
4637:
4638: /*********************************************************************
4639: -- Added by MK on 08/26/2000
4640: IF p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_CREATE AND
4641: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
4642: NOT Eng_Primary_Routing_Exists
4643: ( p_revised_Item_Id => p_rev_item_unexp_rec.revised_item_id
4644: , p_organization_Id => p_rev_item_unexp_rec.organization_id

Line 4717: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE

4713: -- or if the ECO has an approval status of 'Approval Requested'
4714: --
4715: -- The below condition was modified by MK on 11/13/00
4716: **********************************************************************/
4717: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_UPDATE
4718: AND
4719: ( -- (p_control_rec.caller_type = 'FORM' AND
4720: -- p_control_rec.validation_controller = 'SCHEDULED_DATE')
4721: -- OR

Line 4781: IF p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE

4777: -- Revised item scheduled_date cannot be greater than the disable date
4778: -- of any of its revised operations with acd_type of Add or Change
4779: -- Modified below condition by MK on 11/13/00
4780: **********************************************************************/
4781: IF p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE
4782: AND
4783: ( -- (p_control_rec.caller_type = 'FORM' AND
4784: -- p_control_rec.validation_controller = 'SCHEDULED_DATE')
4785: -- OR

Line 4829: (( p_revised_item_rec.transaction_type=ENG_Globals.G_OPR_UPDATE AND

4825: --
4826: **********************************************************************/
4827:
4828: IF p_control_rec.caller_type <> 'FORM' AND
4829: (( p_revised_item_rec.transaction_type=ENG_Globals.G_OPR_UPDATE AND
4830: NVL( p_revised_item_rec.status_type, 0) <>
4831: p_old_revised_item_rec.status_type
4832: )
4833: )

Line 4876: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE

4872: -- cancel because in that case ECO is not updateable.
4873: --
4874: ********************************************************************/
4875: IF p_control_rec.caller_type <> 'FORM' AND
4876: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE
4877: AND l_plm_or_erp_change = 'ERP' -- Added for bug 3618676
4878: THEN
4879: BEGIN
4880: SELECT 1

Line 4921: IF p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE AND

4917: -- is set to 'Approval Requested'
4918: --
4919: **********************************************************************/
4920:
4921: IF p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE AND
4922: NVL(p_revised_item_rec.status_type, 0) <>
4923: p_old_revised_item_rec.status_type
4924: AND p_control_rec.caller_type <> 'SSWA'
4925: AND

Line 4971: p_revised_item_rec.transaction_type = Eng_globals.G_OPR_UPDATE

4967: IF l_alternate_bom_designator IS NOT NULL AND
4968: (p_revised_item_rec.alternate_bom_code <>
4969: l_alternate_bom_designator
4970: ) AND
4971: p_revised_item_rec.transaction_type = Eng_globals.G_OPR_UPDATE
4972: THEN
4973: l_token_tbl.DELETE;
4974: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4975: l_token_tbl(1).token_value :=

Line 4997: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE

4993:
4994:
4995: IF p_revised_item_rec.new_revised_item_revision IS NOT NULL AND
4996: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
4997: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE
4998: AND l_plm_or_erp_change <> 'PLM'
4999: THEN
5000: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5001: THEN

Line 5010: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_UPDATE AND

5006: , p_Token_Tbl => l_Token_Tbl
5007: );
5008: END IF;
5009: l_return_status := FND_API.G_RET_STS_ERROR;
5010: ELSIF p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_UPDATE AND
5011: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
5012: p_revised_item_rec.updated_revised_item_revision IS NOT NULL
5013: AND l_plm_or_erp_change <> 'PLM'
5014: THEN

Line 5039: p_Revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

5035: , p_organization_id => p_rev_item_unexp_rec.organization_id
5036: , p_revision_date => SYSDATE
5037: );
5038: IF l_current_item_revision IS NULL AND
5039: p_Revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
5040: THEN
5041: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5042: THEN
5043: Error_Handler.Add_Error_Token

Line 5068: (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

5064: -- profile ENG: Require Revised Item New Revision is set to Yes.
5065: **********************************************************************/
5066:
5067: IF l_new_rev_required = 1 AND
5068: (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
5069: p_revised_item_rec.new_revised_item_revision = l_current_item_revision)
5070: OR
5071: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
5072: p_revised_item_rec.updated_revised_item_revision = l_current_item_revision))

Line 5071: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND

5067: IF l_new_rev_required = 1 AND
5068: (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
5069: p_revised_item_rec.new_revised_item_revision = l_current_item_revision)
5070: OR
5071: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
5072: p_revised_item_rec.updated_revised_item_revision = l_current_item_revision))
5073: THEN
5074: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5075: THEN

Line 5098: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

5094: **********************************************************************/
5095:
5096: IF ( p_revised_item_rec.updated_revised_item_revision <>
5097: p_old_revised_item_rec.new_revised_item_revision AND
5098: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
5099: ) OR
5100: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
5101: p_revised_item_rec.new_revised_item_revision IS NOT NULL)
5102: THEN

Line 5100: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

5096: IF ( p_revised_item_rec.updated_revised_item_revision <>
5097: p_old_revised_item_rec.new_revised_item_revision AND
5098: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
5099: ) OR
5100: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
5101: p_revised_item_rec.new_revised_item_revision IS NOT NULL)
5102: THEN
5103:
5104: -- 11.5.10E

Line 5127: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

5123: -- if the operation is create, the check new_revised_item_rev
5124: -- else check updated_revised_item_revision
5125: --
5126:
5127: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
5128: THEN
5129: l_new_revision_status :=
5130: Validate_New_Item_Revision
5131: ( p_revised_item_id => p_rev_item_unexp_rec.revised_item_id

Line 5179: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

5175: THEN
5176: l_token_tbl.delete;
5177:
5178: -- Added by MK on 11/05/00
5179: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
5180: THEN
5181: l_token_tbl(1).token_name := 'NEW_UPD_ITEM_REVISION';
5182: l_token_tbl(1).token_value := p_revised_item_rec.new_revised_item_revision;
5183: ELSE

Line 5229: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

5225: THEN
5226: Error_Handler.Write_Debug('Validate if the revisions and effectivity dates in ascending order. . . . ');
5227: END IF;
5228:
5229: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
5230: AND p_revised_item_rec.new_revised_item_revision IS NOT NULL
5231: AND p_control_rec.caller_type <> 'FORM' AND p_control_rec.caller_type <> 'SSWA')
5232: THEN
5233: l_is_revision_invalid := High_Date_Low_Revision (

Line 5239: ELSIF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

5235: , p_organization_id => p_rev_item_unexp_rec.organization_id
5236: , p_new_item_revision => p_revised_item_rec.new_revised_item_revision
5237: , p_scheduled_date => p_revised_item_rec.Start_Effective_Date
5238: , p_rev_item_seq_id => p_rev_item_unexp_rec.revised_item_sequence_id);
5239: ELSIF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
5240: AND p_revised_item_rec.updated_revised_item_revision IS NOT NULL
5241: AND ((p_revised_item_rec.new_revised_item_revision IS NOT NULL
5242: AND p_revised_item_rec.updated_revised_item_revision <> p_revised_item_rec.new_revised_item_revision)
5243: OR (p_revised_item_rec.new_revised_item_revision IS NULL))

Line 5277: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

5273: -- End changes for bug 3618662
5274:
5275: -- 11.5.10E
5276: -- The scheduled date must be greater than the effectivity date of the from revision
5277: IF (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
5278: AND p_revised_item_rec.new_revised_item_revision IS NULL
5279: AND p_control_rec.caller_type <> 'FORM' AND p_control_rec.caller_type <> 'SSWA'
5280: AND p_revised_item_rec.from_item_revision IS NOT NULL
5281: AND p_revised_item_rec.from_item_revision <> FND_API.G_MISS_CHAR)

Line 5317: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND p_control_rec.caller_type <> 'SSWA'

5313: /* Bug 7678438 : The below code is getting executed only for ERP not for PLM
5314: and causing performance problem.
5315: However, as per the comments the below code is required only for PLM.
5316:
5317: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND p_control_rec.caller_type <> 'SSWA'
5318: THEN
5319: IF BOM_Globals.get_debug = 'Y' THEN
5320: error_handler.write_debug('Verifying the subject level security for PLM ' );
5321: END IF;

Line 5536: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND

5532:
5533:
5534: END IF;
5535:
5536: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
5537: (p_revised_item_rec.from_end_item_unit_number IS NOT NULL
5538: AND
5539: p_revised_item_rec.from_end_item_unit_number <> FND_API.G_MISS_CHAR)
5540: THEN

Line 5565: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND

5561: END IF;
5562: END IF;
5563: END IF;
5564:
5565: IF p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
5566: (p_revised_item_rec.new_from_end_item_unit_number IS NOT NULL
5567: AND
5568: p_revised_item_rec.new_from_end_item_unit_number <> FND_API.G_MISS_CHAR)
5569: THEN

Line 5806: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE

5802: END IF;
5803:
5804: -- Missing Eco For Production Added by MK on 10/06/2000
5805: IF p_revised_item_rec.eco_for_production = FND_API.G_MISS_NUM AND
5806: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
5807: THEN
5808: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5809: THEN
5810: Error_Handler.Add_Error_Token

Line 6255: IF l_return_status = Eng_Globals.G_RECORD_FOUND AND

6251: , x_revised_item_rec => x_old_revised_item_rec
6252: , x_rev_item_unexp_rec => x_old_rev_item_unexp_rec
6253: , x_Return_status => l_return_status
6254: );
6255: IF l_return_status = Eng_Globals.G_RECORD_FOUND AND
6256: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE
6257: THEN
6258: Error_Handler.Add_Error_Token
6259: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 6256: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE

6252: , x_rev_item_unexp_rec => x_old_rev_item_unexp_rec
6253: , x_Return_status => l_return_status
6254: );
6255: IF l_return_status = Eng_Globals.G_RECORD_FOUND AND
6256: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE
6257: THEN
6258: Error_Handler.Add_Error_Token
6259: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
6260: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 6265: ELSIF l_return_status = Eng_Globals.G_RECORD_NOT_FOUND AND

6261: , p_message_name => 'ENG_REV_ITEM_ALREADY_EXISTS'
6262: , p_token_tbl => l_token_tbl
6263: );
6264: l_return_status := FND_API.G_RET_STS_ERROR;
6265: ELSIF l_return_status = Eng_Globals.G_RECORD_NOT_FOUND AND
6266: p_revised_item_rec.transaction_type IN
6267: (Eng_Globals.G_OPR_UPDATE, Eng_Globals.G_OPR_DELETE)
6268: THEN
6269: Error_Handler.Add_Error_Token

Line 6267: (Eng_Globals.G_OPR_UPDATE, Eng_Globals.G_OPR_DELETE)

6263: );
6264: l_return_status := FND_API.G_RET_STS_ERROR;
6265: ELSIF l_return_status = Eng_Globals.G_RECORD_NOT_FOUND AND
6266: p_revised_item_rec.transaction_type IN
6267: (Eng_Globals.G_OPR_UPDATE, Eng_Globals.G_OPR_DELETE)
6268: THEN
6269: Error_Handler.Add_Error_Token
6270: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
6271: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 6600: IF ENG_Globals.Get_PLM_Or_ERP_Change(p_change_notice, p_organization_id) = 'PLM'

6596: (p_ritem_impl => FALSE);
6597: END IF;
6598: -- Bug 4276451
6599: -- Check if the revised item is updateable for PLM ECOs
6600: IF ENG_Globals.Get_PLM_Or_ERP_Change(p_change_notice, p_organization_id) = 'PLM'
6601: AND ENG_GLOBALS.G_ENG_LAUNCH_IMPORT <> 2 -- should not be checked for propagation
6602: THEN
6603: l_status_valid := TRUE;
6604: IF revised_item.status_type NOT in( 1, 4) THEN

Line 6601: AND ENG_GLOBALS.G_ENG_LAUNCH_IMPORT <> 2 -- should not be checked for propagation

6597: END IF;
6598: -- Bug 4276451
6599: -- Check if the revised item is updateable for PLM ECOs
6600: IF ENG_Globals.Get_PLM_Or_ERP_Change(p_change_notice, p_organization_id) = 'PLM'
6601: AND ENG_GLOBALS.G_ENG_LAUNCH_IMPORT <> 2 -- should not be checked for propagation
6602: THEN
6603: l_status_valid := TRUE;
6604: IF revised_item.status_type NOT in( 1, 4) THEN
6605: l_status_valid := FALSE;

Line 7144: ENG_GLOBALS.Init_System_Info_Rec(

7140: BOM_Globals.Set_Debug('N');
7141: END IF;
7142: END IF;
7143: -- Initialize System_Information
7144: ENG_GLOBALS.Init_System_Info_Rec(
7145: x_mesg_token_tbl => l_mesg_token_tbl
7146: , x_return_status => l_return_status
7147: );
7148: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 7156: ENG_Globals.Set_Unit_Effectivity (TRUE);

7152: -- Initialize Unit_Effectivity flag
7153: IF PJM_UNIT_EFF.Enabled = 'Y'
7154: THEN
7155: BOM_Globals.Set_Unit_Effectivity (TRUE);
7156: ENG_Globals.Set_Unit_Effectivity (TRUE);
7157: ELSE
7158: BOM_Globals.Set_Unit_Effectivity (FALSE);
7159: ENG_Globals.Set_Unit_Effectivity (FALSE);
7160: END IF;

Line 7159: ENG_Globals.Set_Unit_Effectivity (FALSE);

7155: BOM_Globals.Set_Unit_Effectivity (TRUE);
7156: ENG_Globals.Set_Unit_Effectivity (TRUE);
7157: ELSE
7158: BOM_Globals.Set_Unit_Effectivity (FALSE);
7159: ENG_Globals.Set_Unit_Effectivity (FALSE);
7160: END IF;
7161: --
7162: BOM_Globals.Set_Unit_Controlled_Item(
7163: p_inventory_item_id => p_revised_item_id

Line 7167: Eng_Globals.Set_Bo_Identifier( p_bo_identifier => p_bo_identifier);

7163: p_inventory_item_id => p_revised_item_id
7164: , p_organization_id => p_organization_id
7165: );
7166: BOM_Globals.Set_Require_Item_Rev(FND_PROFILE.VALUE('ENG:ECO_REVISED_ITEM_REVISION'));
7167: Eng_Globals.Set_Bo_Identifier( p_bo_identifier => p_bo_identifier);
7168: Eng_Globals.Set_Org_Id( p_org_id => p_organization_id);
7169:
7170: -- Bug 12310735. If alternate designator is Primary, set it to NULL.
7171: -- Bug 14639944 extends bug 12310735 to multiple languages,

Line 7168: Eng_Globals.Set_Org_Id( p_org_id => p_organization_id);

7164: , p_organization_id => p_organization_id
7165: );
7166: BOM_Globals.Set_Require_Item_Rev(FND_PROFILE.VALUE('ENG:ECO_REVISED_ITEM_REVISION'));
7167: Eng_Globals.Set_Bo_Identifier( p_bo_identifier => p_bo_identifier);
7168: Eng_Globals.Set_Org_Id( p_org_id => p_organization_id);
7169:
7170: -- Bug 12310735. If alternate designator is Primary, set it to NULL.
7171: -- Bug 14639944 extends bug 12310735 to multiple languages,
7172: l_alternate_bom_code := p_alternate_bom_code;