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 FND_MSG_PUB

Line 2006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2002: p_revised_item_rec.new_revised_item_revision = FND_API.G_MISS_CHAR
2003: ) AND
2004: NVL(BOM_Globals.Is_Item_Rev_Required, 0) = 1
2005: THEN
2006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2007: THEN
2008: Error_Handler.Add_Error_Token
2009: ( p_Message_Name => 'ENG_NEW_REVISION_MISSING'
2010: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2026: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2022: AND
2023: p_revised_item_rec.alternate_bom_code IS NULL AND
2024: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
2025: THEN
2026: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2027: THEN
2028: Error_Handler.Add_Error_Token
2029: ( p_Message_Name =>'ENG_UPDATED_REVISION_MISSING'
2030: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2407: p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL OR
2408: p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL )
2409: )
2410: THEN
2411: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2412: THEN
2413: Error_Handler.Add_Error_Token
2414: ( p_Message_Name => 'ENG_RIT_ACCESS_WOECTV_DENIED'
2415: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2444: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2440: p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL OR
2441: p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2442: )
2443: THEN
2444: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2445: THEN
2446: Error_Handler.Add_Error_Token
2447: ( p_Message_Name => 'ENG_RIT_MAC_UWIP_INVALID'
2448: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2472: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2473: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2474: AND p_revised_item_rec.lot_number IS NOT NULL
2475: THEN
2476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2477: THEN
2478: Error_Handler.Add_Error_Token
2479: ( p_Message_Name => 'ENG_RIT_LOTNUM_MUSTBE_NULL'
2480: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2499: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE )
2500: AND p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL
2501: AND p_rev_item_unexp_rec.from_wip_entity_id IS NULL
2502: THEN
2503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2504: THEN
2505: Error_Handler.Add_Error_Token
2506: ( p_Message_Name => 'ENG_RIT_FROMWO_MUSTNOT_NULL'
2507: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2529: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2525: AND p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL
2526: AND ( p_revised_item_rec.from_work_order > p_revised_item_rec.to_work_order
2527: OR p_rev_item_unexp_rec.from_wip_entity_id IS NULL)
2528: THEN
2529: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2530: THEN
2531: Error_Handler.Add_Error_Token
2532: ( p_Message_Name => 'ENG_RIT_FROMWO_INVALID'
2533: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2552: AND p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL
2553: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2554: AND p_revised_item_rec.from_cumulative_quantity IS NOT NULL
2555: THEN
2556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2557: THEN
2558: Error_Handler.Add_Error_Token
2559: ( p_Message_Name => 'ENG_RIT_CUMQTY_INVALID'
2560: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2579: AND ( p_rev_item_unexp_rec.from_wip_entity_id IS NULL
2580: OR p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL )
2581: AND p_revised_item_rec.from_cumulative_quantity IS NOT NULL
2582: THEN
2583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2584: THEN
2585: Error_Handler.Add_Error_Token
2586: ( p_Message_Name => 'ENG_RIT_ECO_BY_CUMQTY_INVALID'
2587: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2607: AND p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2608: AND p_rev_item_unexp_rec.to_wip_entity_id IS NULL
2609: AND p_revised_item_rec.from_cumulative_quantity IS NULL
2610: THEN
2611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2612: THEN
2613: Error_Handler.Add_Error_Token
2614: ( p_Message_Name => 'ENG_RIT_FROMWO_ISNOT_NULL'
2615: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2643: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2639: p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL OR
2640: p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2641: )
2642: THEN
2643: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2644: THEN
2645: Error_Handler.Add_Error_Token
2646: ( p_Message_Name => 'ENG_RIT_ECO_BY_LOT_INVALID'
2647: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2666: , p_org_id => p_rev_item_unexp_rec.organization_id
2667: , p_rev_item_id => p_rev_item_unexp_rec.revised_item_id
2668: )
2669: LOOP
2670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2671: THEN
2672: Error_Handler.Add_Error_Token
2673: ( p_Message_Name => 'ENG_RIT_LOTNUM_WO_RELEASED'
2674: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2708: );
2709:
2710: FETCH l_wipjob_for_eco_cum_csr INTO l_wipjob_for_eco_cum_rec ;
2711: IF l_wipjob_for_eco_cum_csr%NOTFOUND THEN
2712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2713: THEN
2714:
2715: Error_Handler.Add_Error_Token
2716: ( p_Message_Name => 'ENG_RIT_CUMQTY_WO_RELEASED'

Line 2727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2723: ELSE
2724: IF p_revised_item_rec.from_cumulative_quantity > l_wipjob_for_eco_cum_rec.start_quantity
2725: OR p_revised_item_rec.from_cumulative_quantity < 0
2726: THEN
2727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2728: THEN
2729: l_Token_Tbl(2).Token_Name := 'WORK_ORDER';
2730: l_Token_Tbl(2).Token_Value := p_revised_item_rec.from_work_order ;
2731:

Line 2744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2740: END IF ;
2741:
2742: IF p_revised_item_rec.start_effective_date > l_wipjob_for_eco_cum_rec.scheduled_start_date
2743: THEN
2744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2745: THEN
2746: l_Token_Tbl(2).Token_Name := 'WORK_ORDER';
2747: l_Token_Tbl(2).Token_Value := p_revised_item_rec.from_work_order ;
2748:

Line 2792: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2788: , p_bill_sequence_id => p_rev_item_unexp_rec.bill_sequence_id
2789: , p_routing_sequence_id => p_rev_item_unexp_rec.routing_sequence_id
2790: )
2791: LOOP
2792: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2793: THEN
2794: Error_Handler.Add_Error_Token
2795: ( p_Message_Name => 'ENG_RIT_WORANGE_WO_RELEASED'
2796: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2835: p_rev_item_unexp_rec.from_wip_entity_id IS NULL
2836: )
2837: THEN
2838:
2839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2840: THEN
2841: Error_Handler.Add_Error_Token
2842: ( p_Message_Name => 'ENG_RIT_ECO_FOR_PROD_MUSTBE_NO'
2843: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2855: ( p_revised_item_rec.lot_number IS NOT NULL OR
2856: p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2857: )
2858: THEN
2859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2860: THEN
2861: Error_Handler.Add_Error_Token
2862: ( p_Message_Name => 'ENG_RIT_ECO_FOR_PROD_MUSTBE_Y'
2863: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2907: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2903: OR l_rtg_header_rec.priority <> p_revised_item_rec.priority
2904: )
2905: THEN
2906:
2907: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2908: THEN
2909: Error_Handler.Add_Error_Token
2910: ( p_Message_Name => 'ENG_RIT_CANNOT_CHANGE_RTG'
2911: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2948: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2944: l_token_tbl.DELETE;
2945: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
2946: l_token_tbl(1).token_value :=
2947: p_revised_item_rec.revised_item_name;
2948: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2949: THEN
2950: Error_Handler.Add_Error_Token
2951: ( p_Message_Name => 'ENG_ALT_DESG_NOT_UPDATEABLE'
2952: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2984: l_token_tbl.DELETE;
2985: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
2986: l_token_tbl(1).token_value :=
2987: p_revised_item_rec.revised_item_name;
2988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2989: THEN
2990: Error_Handler.Add_Error_Token
2991: ( p_Message_Name => 'ENG_ALT_DESG_NOT_UPDATEABLE'
2992: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3037: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3033: )
3034: AND p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3035: THEN
3036:
3037: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3038: THEN
3039: Error_Handler.Add_Error_Token
3040: ( p_Message_Name => 'ENG_RIT_CANNOT_BE_ON_RTG'
3041: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3063: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3059: IF p_revised_item_rec.new_routing_revision IS NOT NULL AND
3060: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
3061: p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_CREATE
3062: THEN
3063: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3064: THEN
3065: Error_Handler.Add_Error_Token
3066: ( p_Message_Name => 'ENG_CANNOT_HAVE_RTG_REVISION'
3067: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3074: ELSIF p_revised_item_rec.transaction_type = ENG_Globals.G_OPR_UPDATE AND
3075: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
3076: p_revised_item_rec.updated_routing_revision IS NOT NULL
3077: THEN
3078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3079: THEN
3080: Error_Handler.Add_Error_Token
3081: ( p_Message_Name => 'ENG_CANNOT_HAVE_RTG_REVISION'
3082: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3101: IF INSTR(NVL(p_revised_item_rec.updated_routing_revision,
3102: p_revised_item_rec.new_routing_revision )
3103: , '''') <> 0
3104: THEN
3105: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3106: THEN
3107: Error_Handler.Add_Error_Token
3108: ( p_Message_Name => 'ENG_RIT_RTGREV_QTE_NOT_ALLOWED'
3109: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3166: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3162: l_token_tbl(2).token_value := l_change_notice;
3163: l_token_tbl(3).token_name := 'REVISION';
3164: l_token_tbl(3).token_value := l_revision;
3165:
3166: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3167: THEN
3168: Error_Handler.Add_Error_Token
3169: ( p_Message_Name => 'ENG_RIT_HIGH_RTG_REV_PENDING'
3170: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3220: END IF;
3221:
3222: IF l_new_revision_status = 1
3223: THEN
3224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3225: THEN
3226:
3227: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3228: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;

Line 3257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3253:
3254: l_token_tbl(3).token_name := 'ECO_NAME';
3255: l_token_tbl(3).token_value := l_change_notice;
3256:
3257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3258: THEN
3259: Error_Handler.Add_Error_Token
3260: ( p_Message_Name => 'ENG_RIT_NEW_RTG_REV_EXISTS'
3261: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3267:
3268: l_return_status := FND_API.G_RET_STS_ERROR;
3269: ELSIF l_new_revision_status = 3
3270: THEN
3271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3272: THEN
3273:
3274: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3275: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;

Line 3311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3307: , p_routing_sequence_id =>
3308: p_rev_item_unexp_rec.routing_sequence_id
3309: )
3310: THEN
3311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3312: THEN
3313: Error_Handler.Add_Error_Token
3314: ( p_Message_Name => 'ENG_RIT_CTP_ALREADY_EXISTS'
3315: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3340: , p_organization_id => p_rev_item_unexp_rec.organization_id
3341: , p_cfm_routing_flag => p_rev_item_unexp_rec.cfm_routing_flag
3342: , p_priority => p_revised_item_rec.priority )
3343: THEN
3344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3345: THEN
3346: Error_Handler.Add_Error_Token
3347: ( p_Message_Name => 'ENG_RIT_PRIORITY_DUPLICATE'
3348: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3709: , p_subinventory => p_revised_item_rec.completion_subinventory )
3710: THEN
3711:
3712: IF l_locator_control = 4 THEN
3713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3714: THEN
3715: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3716: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3717: Error_Handler.Add_Error_Token

Line 3727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3723: END IF;
3724:
3725: ELSIF l_locator_control = 3 THEN
3726: -- Log the Dynamic locator control message.
3727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3728: THEN
3729: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3730: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3731:

Line 3745: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3741:
3742: -- if error occured when item_locator_control was
3743: -- restrcited
3744:
3745: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3746: THEN
3747: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3748: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3749:

Line 3758: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3754: , p_Token_Tbl => l_Token_Tbl
3755: );
3756: END IF;
3757: ELSE
3758: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3759: THEN
3760: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3761: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3762:

Line 3773: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3769: END IF;
3770: END IF;
3771: ELSIF l_locator_control = 1 THEN
3772:
3773: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3774: THEN
3775: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3776: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3777:

Line 3794: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3790: --
3791: -- ELSIF p_revised_item_rec.completion_location_name IS NOT NULL AND
3792: -- p_revised_item_rec.completion_subinventory IS NULL
3793: -- THEN
3794: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3795: -- THEN
3796: -- Error_Handler.Add_Error_Token
3797: -- ( p_message_name => 'BOM_RTG_LOCATOR_MUST_BE_NULL'
3798: -- , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3823: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE AND
3824: p_revised_item_rec.mixed_model_map = 1
3825: THEN
3826: IF NOT Check_Mixed_Model_Map THEN
3827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3828: THEN
3829: Error_Handler.Add_Error_Token
3830: ( p_Message_Name => 'ENG_MMMF_ALREADY_EXISTS'
3831: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3853: l_plm_or_erp_change <> 'PLM' AND -- not required for plm
3854: l_is_item_unit_controlled AND
3855: p_revised_item_rec.from_end_item_unit_number IS NULL
3856: THEN
3857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3858: THEN
3859: Error_Handler.Add_Error_Token
3860: ( p_Message_Name => 'ENG_FROM_UNIT_NUM_REQUIRED'
3861: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3878: IF p_revised_item_rec.use_up_plan_name IS NOT NULL AND
3879: p_revised_item_rec.use_up_item_name IS NULL AND
3880: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3881: THEN
3882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3883: THEN
3884: Error_Handler.Add_Error_Token
3885: ( p_Message_Name => 'ENG_USE_UP_ITEM_MISSING'
3886: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3897: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3893: ELSIF p_revised_item_rec.use_up_plan_name IS NULL AND
3894: p_revised_item_rec.use_up_item_name IS NOT NULL AND
3895: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3896: THEN
3897: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3898: THEN
3899: Error_Handler.Add_Error_Token
3900: ( p_Message_Name => 'ENG_USE_UP_PLAN_MISSING'
3901: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3920: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3916: , p_use_up_item_id => p_rev_item_unexp_rec.use_up_item_id
3917: , p_organization_id => p_rev_item_unexp_rec.organization_id
3918: )
3919: THEN
3920: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3921: THEN
3922: Error_Handler.Add_Error_Token
3923: ( p_Message_Name => 'ENG_USE_UP_PLANITEM_INVALID'
3924: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3939: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3935: IF p_control_rec.caller_type = 'FORM'
3936: THEN
3937: l_dup_exists := 0;
3938: FOR X_CheckDupUnit IN CheckDupUnit LOOP
3939: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3940: THEN
3941: Error_Handler.Add_Error_Token
3942: ( p_Message_Name => 'ENG_UNIT_NUM_DUPLICATE'
3943: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4017: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4013: , p_organization_id => p_rev_item_unexp_rec.organization_id
4014: )
4015: AND p_control_rec.caller_type <> 'SSWA' -- not required for plm
4016: THEN
4017: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4018: THEN
4019: Error_Handler.Add_Error_Token
4020: ( p_Message_Name => 'ENG_PROC_UPD_DISALLOWED'
4021: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4038: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4034: *********************************************************************/
4035: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE AND
4036: p_revised_item_rec.status_type = 5
4037: THEN
4038: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4039: THEN
4040: Error_Handler.Add_Error_Token
4041: ( p_Message_Name => 'ENG_STAT_MUST_NOT_BE_CANCL'
4042: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4065: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4061:
4062: IF p_revised_item_rec.Transaction_Type = ENG_Globals.G_OPR_CREATE AND
4063: l_product_family
4064: THEN
4065: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4066: THEN
4067: Error_Handler.Add_Error_Token
4068: ( p_Message_Name => 'ENG_CANNOT_ADD_PF_ITEM'
4069: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4089: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4085: OR
4086: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
4087: p_revised_item_rec.new_effective_date IS NOT NULL))
4088: THEN
4089: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4090: THEN
4091: Error_Handler.Add_Error_Token
4092: ( p_Message_Name => 'ENG_RIT_UNIT_EFFDATE_NULL'
4093: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4110: OR
4111: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
4112: p_revised_item_rec.new_from_end_item_unit_number IS NOT NULL))
4113: THEN
4114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4115: THEN
4116: Error_Handler.Add_Error_Token
4117: ( p_Message_Name => 'ENG_RIT_DATE_UNIT_NULL'
4118: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4130: -- Added by AS on 07/06.
4131: -- If revised item is unit controlled, Update_WIP must not be set
4132: -- to Yes.
4133: **********************************************************************/
4134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4135: THEN
4136: Error_Handler.Add_Error_Token
4137: ( p_Message_Name => 'ENG_ITEM_UNIT_UPDATE_WIP'
4138: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4161: IF p_revised_item_rec.status_type = 4 /* Scheduled */
4162: AND
4163: l_ECO_approved <> 1 /* if not approved */
4164: THEN
4165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4166: THEN
4167: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4168: l_token_tbl(1).token_value :=
4169: p_revised_item_rec.revised_item_name;

Line 4195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4191:
4192: IF p_revised_item_rec.new_effective_date = FND_API.G_MISS_DATE AND
4193: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_UPDATE
4194: THEN
4195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4196: THEN
4197: Error_Handler.Add_Error_Token
4198: ( p_Message_Name => 'ENG_SCHED_DATE_NOT_NULL'
4199: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4258: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4254: l_token_tbl(1).token_name := 'ENTITY1';
4255: l_token_tbl(1).token_value := l_revision;
4256: l_token_tbl(2).token_name := 'ENTITY2';
4257: l_token_tbl(2).token_value := l_change_notice;
4258: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4259: THEN
4260: Error_Handler.Add_Error_Token
4261: ( p_Message_Name => 'ENG_ECN_REVISION'
4262: -- , p_Message_Name => 'ENG_ITEM_HIGH_REV_PENDING'

Line 4304: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4300: , p_revised_item_id => p_rev_item_unexp_rec.revised_item_id
4301: , p_organization_id => p_rev_item_unexp_rec.organization_id
4302: )
4303: THEN
4304: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4305: THEN
4306: l_token_tbl.delete;
4307: l_token_tbl(1).token_name := 'ECO_NAME';
4308: l_token_tbl(1).token_value :=

Line 4340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4336: trunc(p_revised_item_rec.earliest_effective_date) >
4337: NVL(trunc(p_revised_item_rec.new_effective_date),
4338: p_revised_item_rec.start_effective_date)))
4339: THEN
4340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4341: THEN
4342: l_token_tbl.delete;
4343: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4344: l_token_tbl(1).token_value :=

Line 4415: IF FND_MSG_PUB.Check_Msg_Level

4411: END IF;
4412:
4413: IF l_IsDateValid = FALSE
4414: THEN
4415: IF FND_MSG_PUB.Check_Msg_Level
4416: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4417: THEN
4418: l_token_tbl.delete;
4419: l_token_tbl(1).token_name :=

Line 4416: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4412:
4413: IF l_IsDateValid = FALSE
4414: THEN
4415: IF FND_MSG_PUB.Check_Msg_Level
4416: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4417: THEN
4418: l_token_tbl.delete;
4419: l_token_tbl(1).token_name :=
4420: 'REVISED_ITEM_NAME';

Line 4485: IF FND_MSG_PUB.Check_Msg_Level

4481:
4482: END LOOP;
4483:
4484: IF l_IsUseUpValid = FALSE THEN
4485: IF FND_MSG_PUB.Check_Msg_Level
4486: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4487: THEN
4488: l_token_tbl.delete;
4489: Error_Handler.Add_Error_Token

Line 4486: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4482: END LOOP;
4483:
4484: IF l_IsUseUpValid = FALSE THEN
4485: IF FND_MSG_PUB.Check_Msg_Level
4486: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4487: THEN
4488: l_token_tbl.delete;
4489: Error_Handler.Add_Error_Token
4490: ( p_Message_Name =>'ENG_USE_UP_ITEM_INVALID'

Line 4536: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4532: , p_assembly_type => l_assembly_type)
4533: )
4534: AND l_plm_or_erp_change <> 'PLM'
4535: THEN
4536: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4537: THEN
4538: l_token_tbl.delete;
4539: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4540: l_token_tbl(1).token_value :=

Line 4570: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4566: ( p_revised_Item_Id => p_rev_item_unexp_rec.revised_item_id
4567: , p_organization_Id => p_rev_item_unexp_rec.organization_id
4568: , p_assembly_type => l_assembly_type)
4569: THEN
4570: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4571: THEN
4572: l_token_tbl.delete;
4573: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4574: l_token_tbl(1).token_value :=

Line 4656: IF FND_MSG_PUB.Check_Msg_Level

4652: ( p_revised_item_rec => p_revised_item_rec
4653: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
4654: );
4655: IF l_result = 1 THEN
4656: IF FND_MSG_PUB.Check_Msg_Level
4657: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4658: THEN
4659: l_token_tbl.delete;
4660: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';

Line 4657: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4653: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
4654: );
4655: IF l_result = 1 THEN
4656: IF FND_MSG_PUB.Check_Msg_Level
4657: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4658: THEN
4659: l_token_tbl.delete;
4660: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4661: l_token_tbl(1).token_value :=

Line 4675: IF FND_MSG_PUB.Check_Msg_Level

4671: );
4672: END IF;
4673: l_return_status := FND_API.G_RET_STS_ERROR;
4674: ELSIF l_result = 2 THEN
4675: IF FND_MSG_PUB.Check_Msg_Level
4676: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4677: THEN
4678: l_token_tbl.delete;
4679: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';

Line 4676: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4672: END IF;
4673: l_return_status := FND_API.G_RET_STS_ERROR;
4674: ELSIF l_result = 2 THEN
4675: IF FND_MSG_PUB.Check_Msg_Level
4676: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4677: THEN
4678: l_token_tbl.delete;
4679: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4680: l_token_tbl(1).token_value :=

Line 4720: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4716: ( p_revised_item_rec => p_revised_item_rec
4717: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
4718: )
4719: THEN
4720: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4721: THEN
4722: l_token_tbl.delete;
4723: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4724: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;

Line 4766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4762: AND
4763: p_revised_item_rec.status_type IN (1,2,4,7)
4764: AND p_control_rec.caller_type <> 'SSWA'
4765: THEN
4766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4767: THEN
4768: l_token_tbl.delete;
4769: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4770: l_token_tbl(1).token_value :=

Line 4818: IF FND_MSG_PUB.Check_Msg_Level

4814: -- type match. Other wise it is an error.
4815: --
4816: EXCEPTION
4817: WHEN NO_DATA_FOUND THEN
4818: IF FND_MSG_PUB.Check_Msg_Level
4819: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4820: THEN
4821: l_token_tbl.delete;
4822: Error_Handler.Add_Error_Token

Line 4819: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4815: --
4816: EXCEPTION
4817: WHEN NO_DATA_FOUND THEN
4818: IF FND_MSG_PUB.Check_Msg_Level
4819: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4820: THEN
4821: l_token_tbl.delete;
4822: Error_Handler.Add_Error_Token
4823: ( p_Message_Name =>

Line 4863: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4859: l_token_tbl(2).token_name := 'STATUS_TYPE';
4860: l_token_tbl(2).token_value :=
4861: p_revised_item_rec.status_type;
4862:
4863: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4864: THEN
4865: Error_Handler.Add_Error_Token
4866: ( p_Message_Name => 'ENG_RIT_STAT_ECO_APPREQ'
4867: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4900: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4896: l_token_tbl.DELETE;
4897: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4898: l_token_tbl(1).token_value :=
4899: p_revised_item_rec.revised_item_name;
4900: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4901: THEN
4902: Error_Handler.Add_Error_Token
4903: ( p_Message_Name => 'ENG_ALT_DESG_NOT_UPDATEABLE'
4904: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4923: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4919: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
4920: p_revised_item_rec.transaction_type = Eng_Globals.G_OPR_CREATE
4921: AND l_plm_or_erp_change <> 'PLM'
4922: THEN
4923: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4924: THEN
4925: Error_Handler.Add_Error_Token
4926: ( p_Message_Name => 'ENG_CANNOT_HAVE_REVISION'
4927: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4934: p_revised_item_rec.alternate_bom_code IS NOT NULL AND
4935: p_revised_item_rec.updated_revised_item_revision IS NOT NULL
4936: AND l_plm_or_erp_change <> 'PLM'
4937: THEN
4938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4939: THEN
4940: Error_Handler.Add_Error_Token
4941: ( p_Message_Name => 'ENG_CANNOT_HAVE_REVISION'
4942: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4960: );
4961: IF l_current_item_revision IS NULL AND
4962: p_Revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
4963: THEN
4964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4965: THEN
4966: Error_Handler.Add_Error_Token
4967: ( p_Message_Name => 'ENG_ITEM_NO_CURR_REV'
4968: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4997: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4993: OR
4994: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE AND
4995: p_revised_item_rec.updated_revised_item_revision = l_current_item_revision))
4996: THEN
4997: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4998: THEN
4999: Error_Handler.Add_Error_Token
5000: ( p_Message_Name => 'ENG_ITEM_REV_NOT_EQ_CURR_REV'
5001: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5086: IF FND_MSG_PUB.Check_Msg_Level

5082: END IF;
5083:
5084: IF l_new_revision_status = 1
5085: THEN
5086: IF FND_MSG_PUB.Check_Msg_Level
5087: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5088: THEN
5089: Error_Handler.Add_Error_Token
5090: ( --p_Message_Name => 'ENG_NEW_ITEM_REV_NOT_CURR'

Line 5087: (FND_MSG_PUB.G_MSG_LVL_ERROR)

5083:
5084: IF l_new_revision_status = 1
5085: THEN
5086: IF FND_MSG_PUB.Check_Msg_Level
5087: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5088: THEN
5089: Error_Handler.Add_Error_Token
5090: ( --p_Message_Name => 'ENG_NEW_ITEM_REV_NOT_CURR'
5091: p_Message_Name => l_message_name

Line 5117: IF FND_MSG_PUB.Check_Msg_Level

5113: l_token_tbl(2).token_value := p_revised_item_rec.revised_item_name;
5114:
5115: l_token_tbl(3).token_name := 'ECO_NAME';
5116: l_token_tbl(3).token_value := l_change_notice;
5117: IF FND_MSG_PUB.Check_Msg_Level
5118: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5119: THEN
5120: Error_Handler.Add_Error_Token
5121: ( p_Message_Name => 'ENG_NEW_ITEM_REV_EXISTS'

Line 5118: (FND_MSG_PUB.G_MSG_LVL_ERROR)

5114:
5115: l_token_tbl(3).token_name := 'ECO_NAME';
5116: l_token_tbl(3).token_value := l_change_notice;
5117: IF FND_MSG_PUB.Check_Msg_Level
5118: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5119: THEN
5120: Error_Handler.Add_Error_Token
5121: ( p_Message_Name => 'ENG_NEW_ITEM_REV_EXISTS'
5122: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5131: IF FND_MSG_PUB.Check_Msg_Level

5127:
5128: l_return_status := FND_API.G_RET_STS_ERROR;
5129: ELSIF l_new_revision_status = 3
5130: THEN
5131: IF FND_MSG_PUB.Check_Msg_Level
5132: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5133: THEN
5134: Error_Handler.Add_Error_Token
5135: ( p_Message_Name => 'ENG_NEW_ITEM_REV_IMPL'

Line 5132: (FND_MSG_PUB.G_MSG_LVL_ERROR)

5128: l_return_status := FND_API.G_RET_STS_ERROR;
5129: ELSIF l_new_revision_status = 3
5130: THEN
5131: IF FND_MSG_PUB.Check_Msg_Level
5132: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5133: THEN
5134: Error_Handler.Add_Error_Token
5135: ( p_Message_Name => 'ENG_NEW_ITEM_REV_IMPL'
5136: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5175: END IF;
5176:
5177: IF l_is_revision_invalid = 1
5178: THEN
5179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5180: THEN
5181: l_Token_Tbl.delete;
5182: Error_Handler.Add_Error_Token
5183: ( p_Message_Name => 'ENG_REVISION_ORDER'

Line 5215: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5211: , p_rev_item_seq_id => p_rev_item_unexp_rec.revised_item_sequence_id);
5212:
5213: IF l_is_scheduled_date_invalid = 1
5214: THEN
5215: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5216: THEN
5217: Error_Handler.Add_Error_Token
5218: ( p_Message_Name => 'ENG_INVALID_SCHED_DATE'
5219: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5284: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5280: WHEN OTHERS THEN
5281:
5282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5283:
5284: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5285: THEN
5286: l_err_text := G_PKG_NAME || ' : (Entity Validation) ' ||
5287: substrb(SQLERRM,1,200);
5288: Error_Handler.Add_Error_Token

Line 5384: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5380: p_old_revised_item_rec.status_type IS NULL )
5381: THEN
5382: IF NOT ENG_Validate.Status_Type(p_revised_item_rec.status_type ,
5383: l_err_text ) THEN
5384: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5385: THEN
5386: l_token_tbl(2).token_name := 'STATUS_TYPE';
5387: l_token_tbl(2).token_value := p_revised_item_rec.status_type;
5388: Error_Handler.Add_Error_Token

Line 5401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5397:
5398: -- Status Type cannot be missing.
5399: IF p_revised_item_rec.status_type = FND_API.G_MISS_NUM
5400: THEN
5401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5402: THEN
5403: Error_Handler.Add_Error_Token
5404: ( p_Message_Name => 'ENG_RIT_STAT_TYPE_MISSING'
5405: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5415:
5416: -- Creates or Updates of records marked Implemented is not allowed
5417: IF p_revised_item_rec.status_type = 6
5418: THEN
5419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5420: THEN
5421: Error_Handler.Add_Error_Token
5422: ( p_Message_Name => 'ENG_RIT_STAT_CANNOT_BE_IMPL'
5423: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5436: ( p_revised_item_rec.status_type <> 1 AND
5437: p_revised_item_rec.status_type <> 4
5438: )
5439: THEN
5440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5441: THEN
5442: Error_Handler.Add_Error_Token
5443: ( p_Message_Name => 'ENG_RIT_CREATE_STAT_INVALID'
5444: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5465: , x_err_text => l_err_text
5466: )
5467: THEN
5468: x_return_status := FND_API.G_RET_STS_ERROR;
5469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5470: THEN
5471: l_token_tbl(2).token_name := 'FROM_END_ITEM_UNIT_NUMBER';
5472: l_token_tbl(2).token_value :=
5473: p_revised_item_rec.from_end_item_unit_number;

Line 5498: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5494: , x_err_text => l_err_text
5495: )
5496: THEN
5497: x_return_status := FND_API.G_RET_STS_ERROR;
5498: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5499: THEN
5500: l_token_tbl(2).token_name := 'FROM_END_ITEM_UNIT_NUMBER';
5501: l_token_tbl(2).token_value :=
5502: p_revised_item_rec.new_from_end_item_unit_number;

Line 5521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5517: THEN
5518: IF NOT ENG_Validate.Mrp_Active(p_revised_item_rec.mrp_active ,
5519: l_err_text ) THEN
5520: x_return_status := FND_API.G_RET_STS_ERROR;
5521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5522: THEN
5523: l_token_tbl(2).token_name := 'MRP_ACTIVE';
5524: l_token_tbl(2).token_value :=
5525: p_revised_item_rec.mrp_active;

Line 5539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5535: END IF;
5536:
5537: IF p_revised_item_rec.mrp_active = FND_API.G_MISS_NUM
5538: THEN
5539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5540: THEN
5541: Error_Handler.Add_Error_Token
5542: ( p_Message_Name => 'ENG_MRP_ACTIVE_MISSING'
5543: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5559: THEN
5560: IF NOT ENG_Validate.Update_Wip(p_revised_item_rec.update_wip ,
5561: l_err_text ) THEN
5562: x_return_status := FND_API.G_RET_STS_ERROR;
5563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5564: THEN
5565: l_token_tbl(2).token_name := 'UPDATE_WIP';
5566: l_token_tbl(2).token_value :=
5567: p_revised_item_rec.update_wip;

Line 5580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5576: END IF;
5577:
5578: IF p_revised_item_rec.update_wip = FND_API.G_MISS_NUM
5579: THEN
5580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5581: THEN
5582: Error_Handler.Add_Error_Token
5583: ( p_Message_Name => 'ENG_UPDATE_WIP_MISSING'
5584: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5606: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5602: ( p_revised_item_rec.use_up_plan_name
5603: , p_rev_item_unexp_rec.organization_id
5604: , l_err_text )
5605: THEN
5606: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5607: THEN
5608: -- If the function returns with an error then
5609: -- l_err_text will carry the message_name to be
5610: -- displayed.

Line 5652: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5648: IF NOT ENG_Validate.Disposition_Type
5649: ( p_revised_item_rec.disposition_type
5650: , l_err_text )
5651: THEN
5652: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5653: THEN
5654: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
5655: l_token_tbl(1).token_value :=
5656: p_revised_item_rec.revised_item_name;

Line 5673: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5669: END IF;
5670:
5671: IF p_revised_item_rec.disposition_type = FND_API.G_MISS_NUM
5672: THEN
5673: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5674: THEN
5675: Error_Handler.Add_Error_Token
5676: ( p_Message_Name => 'ENG_DISPOSITION_TYPE_MISSING'
5677: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5723: -- Missing Eco For Production Added by MK on 10/06/2000
5724: IF p_revised_item_rec.eco_for_production = FND_API.G_MISS_NUM AND
5725: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE
5726: THEN
5727: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5728: THEN
5729: Error_Handler.Add_Error_Token
5730: ( p_Message_Name => 'ENG_RIT_ECO_FOR_PROD_MISSING'
5731: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5834: WHEN OTHERS THEN
5835:
5836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5837:
5838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5839: THEN
5840: l_err_text := G_PKG_NAME || ' : (Attribute Validation) ' ||
5841: substrb(SQLERRM,1,200);
5842: Error_Handler.Add_Error_Token

Line 5955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5951: --
5952: -- if loop executes, then component exist on that bill
5953: -- so it cannot be deleted.
5954: --
5955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5956: THEN
5957: Error_Handler.Add_Error_Token
5958: ( p_Message_Name => 'ENG_CANNOT_DEL_COMP_EXIST'
5959: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5979: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5975: --
5976: -- if loop executes, then revised operation exist on that
5977: -- routing so it cannot be deleted.
5978: --
5979: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5980: THEN
5981: Error_Handler.Add_Error_Token
5982: ( p_Message_Name => 'ENG_CANNOT_DEL_OP_EXIST'
5983: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 6006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

6002: );
6003:
6004: IF check_delete <> 0
6005: THEN
6006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6007: THEN
6008: Error_Handler.Add_Error_Token
6009: ( p_Message_Name => 'ENG_CANNOT_DEL_COMMON_EXIST'
6010: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 6030: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

6026: );
6027:
6028: IF check_delete <> 0
6029: THEN
6030: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6031: THEN
6032: Error_Handler.Add_Error_Token
6033: ( p_Message_Name => 'ENG_CANNOT_DEL_RTG_COMMON_EXIST'
6034: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 6049: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

6045: OPEN allow_delete_rev;
6046: FETCH allow_delete_rev into l_allow_rev;
6047: IF l_allow_rev = 1
6048: THEN
6049: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6050: THEN
6051: Error_Handler.Add_Error_Token
6052: ( p_Message_Name => 'ENG_CANNOT_DEL_REVISION_IN_USE'
6053: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 6084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6080: THEN
6081: CLOSE allow_delete_rev;
6082: END IF;
6083:
6084: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6085: THEN
6086: l_err_text := G_PKG_NAME || ' : (Entity Delete Validation) ' ||
6087: substrb(SQLERRM,1,200);
6088: Error_Handler.Add_Error_Token

Line 6708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

6704: )
6705:
6706: THEN
6707:
6708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6709: THEN
6710: l_token_tbl.delete;
6711: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
6712: l_token_tbl(1).token_value := p_revised_item_name ;

Line 6747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

6743: )
6744:
6745: THEN
6746:
6747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6748: THEN
6749: l_token_tbl.delete;
6750: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
6751: l_token_tbl(1).token_value := p_revised_item_name ;

Line 7033: FND_MSG_PUB.Initialize;

7029: END IF;
7030:
7031: -- Initialize message list if p_init_msg_list is set to TRUE.
7032: IF FND_API.to_Boolean(p_init_msg_list) THEN
7033: FND_MSG_PUB.Initialize;
7034: Error_Handler.Initialize;
7035: END IF;
7036:
7037: IF p_debug = 'Y'

Line 7305: Fnd_msg_pub.add;

7301: token => 'ENTITY'
7302: , value => ' '
7303: );
7304: /* END IF;*/
7305: Fnd_msg_pub.add;
7306: END LOOP;
7307: END IF;
7308:
7309: -- Start of Closure to procedure

Line 7312: FND_MSG_PUB.Count_And_Get(

7308:
7309: -- Start of Closure to procedure
7310: x_return_status := l_return_status;
7311:
7312: FND_MSG_PUB.Count_And_Get(
7313: p_count => x_msg_count
7314: , p_data => l_msg_data
7315: );
7316:

Line 7328: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7324:
7325: EXCEPTION
7326: WHEN OTHERS THEN
7327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7328: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7329: THEN
7330: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
7331: END IF;
7332: FND_MSG_PUB.Count_And_Get(

Line 7330: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);

7326: WHEN OTHERS THEN
7327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7328: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7329: THEN
7330: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
7331: END IF;
7332: FND_MSG_PUB.Count_And_Get(
7333: p_count => x_msg_count
7334: , p_data => x_msg_data

Line 7332: FND_MSG_PUB.Count_And_Get(

7328: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7329: THEN
7330: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
7331: END IF;
7332: FND_MSG_PUB.Count_And_Get(
7333: p_count => x_msg_count
7334: , p_data => x_msg_data
7335: );
7336: IF Bom_Globals.Get_Debug = 'Y'