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 2078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2074: p_revised_item_rec.new_revised_item_revision = FND_API.G_MISS_CHAR
2075: ) AND
2076: NVL(BOM_Globals.Is_Item_Rev_Required, 0) = 1
2077: THEN
2078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2079: THEN
2080: Error_Handler.Add_Error_Token
2081: ( p_Message_Name => 'ENG_NEW_REVISION_MISSING'
2082: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
2101: ( p_Message_Name =>'ENG_UPDATED_REVISION_MISSING'
2102: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2479: p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL OR
2480: p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL )
2481: )
2482: THEN
2483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2484: THEN
2485: Error_Handler.Add_Error_Token
2486: ( p_Message_Name => 'ENG_RIT_ACCESS_WOECTV_DENIED'
2487: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2512: p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL OR
2513: p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2514: )
2515: THEN
2516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2517: THEN
2518: Error_Handler.Add_Error_Token
2519: ( p_Message_Name => 'ENG_RIT_MAC_UWIP_INVALID'
2520: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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)
2549: THEN
2550: Error_Handler.Add_Error_Token
2551: ( p_Message_Name => 'ENG_RIT_LOTNUM_MUSTBE_NULL'
2552: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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)
2576: THEN
2577: Error_Handler.Add_Error_Token
2578: ( p_Message_Name => 'ENG_RIT_FROMWO_MUSTNOT_NULL'
2579: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
2601: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2602: THEN
2603: Error_Handler.Add_Error_Token
2604: ( p_Message_Name => 'ENG_RIT_FROMWO_INVALID'
2605: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
2628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2629: THEN
2630: Error_Handler.Add_Error_Token
2631: ( p_Message_Name => 'ENG_RIT_CUMQTY_INVALID'
2632: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
2655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2656: THEN
2657: Error_Handler.Add_Error_Token
2658: ( p_Message_Name => 'ENG_RIT_ECO_BY_CUMQTY_INVALID'
2659: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
2683: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2684: THEN
2685: Error_Handler.Add_Error_Token
2686: ( p_Message_Name => 'ENG_RIT_FROMWO_ISNOT_NULL'
2687: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2711: p_rev_item_unexp_rec.to_wip_entity_id IS NOT NULL OR
2712: p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2713: )
2714: THEN
2715: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2716: THEN
2717: Error_Handler.Add_Error_Token
2718: ( p_Message_Name => 'ENG_RIT_ECO_BY_LOT_INVALID'
2719: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2738: , p_org_id => p_rev_item_unexp_rec.organization_id
2739: , p_rev_item_id => p_rev_item_unexp_rec.revised_item_id
2740: )
2741: LOOP
2742: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2743: THEN
2744: Error_Handler.Add_Error_Token
2745: ( p_Message_Name => 'ENG_RIT_LOTNUM_WO_RELEASED'
2746: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2780: );
2781:
2782: FETCH l_wipjob_for_eco_cum_csr INTO l_wipjob_for_eco_cum_rec ;
2783: IF l_wipjob_for_eco_cum_csr%NOTFOUND THEN
2784: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2785: THEN
2786:
2787: Error_Handler.Add_Error_Token
2788: ( p_Message_Name => 'ENG_RIT_CUMQTY_WO_RELEASED'

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

2795: ELSE
2796: IF p_revised_item_rec.from_cumulative_quantity > l_wipjob_for_eco_cum_rec.start_quantity
2797: OR p_revised_item_rec.from_cumulative_quantity < 0
2798: THEN
2799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2800: THEN
2801: l_Token_Tbl(2).Token_Name := 'WORK_ORDER';
2802: l_Token_Tbl(2).Token_Value := p_revised_item_rec.from_work_order ;
2803:

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

2812: END IF ;
2813:
2814: IF p_revised_item_rec.start_effective_date > l_wipjob_for_eco_cum_rec.scheduled_start_date
2815: THEN
2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2817: THEN
2818: l_Token_Tbl(2).Token_Name := 'WORK_ORDER';
2819: l_Token_Tbl(2).Token_Value := p_revised_item_rec.from_work_order ;
2820:

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

2860: , p_bill_sequence_id => p_rev_item_unexp_rec.bill_sequence_id
2861: , p_routing_sequence_id => p_rev_item_unexp_rec.routing_sequence_id
2862: )
2863: LOOP
2864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2865: THEN
2866: Error_Handler.Add_Error_Token
2867: ( p_Message_Name => 'ENG_RIT_WORANGE_WO_RELEASED'
2868: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2907: p_rev_item_unexp_rec.from_wip_entity_id IS NULL
2908: )
2909: THEN
2910:
2911: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2912: THEN
2913: Error_Handler.Add_Error_Token
2914: ( p_Message_Name => 'ENG_RIT_ECO_FOR_PROD_MUSTBE_NO'
2915: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2927: ( p_revised_item_rec.lot_number IS NOT NULL OR
2928: p_rev_item_unexp_rec.from_wip_entity_id IS NOT NULL
2929: )
2930: THEN
2931: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2932: THEN
2933: Error_Handler.Add_Error_Token
2934: ( p_Message_Name => 'ENG_RIT_ECO_FOR_PROD_MUSTBE_Y'
2935: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2975: OR l_rtg_header_rec.priority <> p_revised_item_rec.priority
2976: )
2977: THEN
2978:
2979: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2980: THEN
2981: Error_Handler.Add_Error_Token
2982: ( p_Message_Name => 'ENG_RIT_CANNOT_CHANGE_RTG'
2983: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3016: l_token_tbl.DELETE;
3017: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3018: l_token_tbl(1).token_value :=
3019: p_revised_item_rec.revised_item_name;
3020: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3021: THEN
3022: Error_Handler.Add_Error_Token
3023: ( p_Message_Name => 'ENG_ALT_DESG_NOT_UPDATEABLE'
3024: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3056: l_token_tbl.DELETE;
3057: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3058: l_token_tbl(1).token_value :=
3059: p_revised_item_rec.revised_item_name;
3060: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3061: THEN
3062: Error_Handler.Add_Error_Token
3063: ( p_Message_Name => 'ENG_ALT_DESG_NOT_UPDATEABLE'
3064: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
3111: Error_Handler.Add_Error_Token
3112: ( p_Message_Name => 'ENG_RIT_CANNOT_BE_ON_RTG'
3113: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
3138: ( p_Message_Name => 'ENG_CANNOT_HAVE_RTG_REVISION'
3139: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_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)
3151: THEN
3152: Error_Handler.Add_Error_Token
3153: ( p_Message_Name => 'ENG_CANNOT_HAVE_RTG_REVISION'
3154: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3173: IF INSTR(NVL(p_revised_item_rec.updated_routing_revision,
3174: p_revised_item_rec.new_routing_revision )
3175: , '''') <> 0
3176: THEN
3177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3178: THEN
3179: Error_Handler.Add_Error_Token
3180: ( p_Message_Name => 'ENG_RIT_RTGREV_QTE_NOT_ALLOWED'
3181: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3234: l_token_tbl(2).token_value := l_change_notice;
3235: l_token_tbl(3).token_name := 'REVISION';
3236: l_token_tbl(3).token_value := l_revision;
3237:
3238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3239: THEN
3240: Error_Handler.Add_Error_Token
3241: ( p_Message_Name => 'ENG_RIT_HIGH_RTG_REV_PENDING'
3242: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3292: END IF;
3293:
3294: IF l_new_revision_status = 1
3295: THEN
3296: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3297: THEN
3298:
3299: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3300: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;

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

3325:
3326: l_token_tbl(3).token_name := 'ECO_NAME';
3327: l_token_tbl(3).token_value := l_change_notice;
3328:
3329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3330: THEN
3331: Error_Handler.Add_Error_Token
3332: ( p_Message_Name => 'ENG_RIT_NEW_RTG_REV_EXISTS'
3333: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3339:
3340: l_return_status := FND_API.G_RET_STS_ERROR;
3341: ELSIF l_new_revision_status = 3
3342: THEN
3343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3344: THEN
3345:
3346: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
3347: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;

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

3379: , p_routing_sequence_id =>
3380: p_rev_item_unexp_rec.routing_sequence_id
3381: )
3382: THEN
3383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3384: THEN
3385: Error_Handler.Add_Error_Token
3386: ( p_Message_Name => 'ENG_RIT_CTP_ALREADY_EXISTS'
3387: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3412: , p_organization_id => p_rev_item_unexp_rec.organization_id
3413: , p_cfm_routing_flag => p_rev_item_unexp_rec.cfm_routing_flag
3414: , p_priority => p_revised_item_rec.priority )
3415: THEN
3416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3417: THEN
3418: Error_Handler.Add_Error_Token
3419: ( p_Message_Name => 'ENG_RIT_PRIORITY_DUPLICATE'
3420: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3781: , p_subinventory => p_revised_item_rec.completion_subinventory )
3782: THEN
3783:
3784: IF l_locator_control = 4 THEN
3785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3786: THEN
3787: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3788: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3789: Error_Handler.Add_Error_Token

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

3795: END IF;
3796:
3797: ELSIF l_locator_control = 3 THEN
3798: -- Log the Dynamic locator control message.
3799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3800: THEN
3801: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3802: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3803:

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

3813:
3814: -- if error occured when item_locator_control was
3815: -- restrcited
3816:
3817: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3818: THEN
3819: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3820: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3821:

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

3826: , p_Token_Tbl => l_Token_Tbl
3827: );
3828: END IF;
3829: ELSE
3830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3831: THEN
3832: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3833: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3834:

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

3841: END IF;
3842: END IF;
3843: ELSIF l_locator_control = 1 THEN
3844:
3845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3846: THEN
3847: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
3848: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;
3849:

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

3862: --
3863: -- ELSIF p_revised_item_rec.completion_location_name IS NOT NULL AND
3864: -- p_revised_item_rec.completion_subinventory IS NULL
3865: -- THEN
3866: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3867: -- THEN
3868: -- Error_Handler.Add_Error_Token
3869: -- ( p_message_name => 'BOM_RTG_LOCATOR_MUST_BE_NULL'
3870: -- , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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)
3900: THEN
3901: Error_Handler.Add_Error_Token
3902: ( p_Message_Name => 'ENG_MMMF_ALREADY_EXISTS'
3903: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
3929: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3930: THEN
3931: Error_Handler.Add_Error_Token
3932: ( p_Message_Name => 'ENG_FROM_UNIT_NUM_REQUIRED'
3933: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
3957: ( p_Message_Name => 'ENG_USE_UP_ITEM_MISSING'
3958: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
3972: ( p_Message_Name => 'ENG_USE_UP_PLAN_MISSING'
3973: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3988: , p_use_up_item_id => p_rev_item_unexp_rec.use_up_item_id
3989: , p_organization_id => p_rev_item_unexp_rec.organization_id
3990: )
3991: THEN
3992: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3993: THEN
3994: Error_Handler.Add_Error_Token
3995: ( p_Message_Name => 'ENG_USE_UP_PLANITEM_INVALID'
3996: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

4007: IF p_control_rec.caller_type = 'FORM'
4008: THEN
4009: l_dup_exists := 0;
4010: FOR X_CheckDupUnit IN CheckDupUnit LOOP
4011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4012: THEN
4013: Error_Handler.Add_Error_Token
4014: ( p_Message_Name => 'ENG_UNIT_NUM_DUPLICATE'
4015: , 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: , p_organization_id => p_rev_item_unexp_rec.organization_id
4086: )
4087: AND p_control_rec.caller_type <> 'SSWA' -- not required for plm
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_PROC_UPD_DISALLOWED'
4093: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
4112: Error_Handler.Add_Error_Token
4113: ( p_Message_Name => 'ENG_STAT_MUST_NOT_BE_CANCL'
4114: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
4139: Error_Handler.Add_Error_Token
4140: ( p_Message_Name => 'ENG_CANNOT_ADD_PF_ITEM'
4141: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
4163: Error_Handler.Add_Error_Token
4164: ( p_Message_Name => 'ENG_RIT_UNIT_EFFDATE_NULL'
4165: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
4188: Error_Handler.Add_Error_Token
4189: ( p_Message_Name => 'ENG_RIT_DATE_UNIT_NULL'
4190: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

4202: -- Added by AS on 07/06.
4203: -- If revised item is unit controlled, Update_WIP must not be set
4204: -- to Yes.
4205: **********************************************************************/
4206: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4207: THEN
4208: Error_Handler.Add_Error_Token
4209: ( p_Message_Name => 'ENG_ITEM_UNIT_UPDATE_WIP'
4210: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

4233: IF p_revised_item_rec.status_type = 4 /* Scheduled */
4234: AND
4235: l_ECO_approved <> 1 /* if not approved */
4236: THEN
4237: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4238: THEN
4239: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4240: l_token_tbl(1).token_value :=
4241: p_revised_item_rec.revised_item_name;

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

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
4270: ( p_Message_Name => 'ENG_SCHED_DATE_NOT_NULL'
4271: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

4331: --Below change is for bug 8872001. Added item name token to error message
4332: l_token_tbl(3).token_name := 'REVISED_ITEM_NAME_ENTITY';
4333: l_token_tbl(3).token_value := p_revised_item_rec.revised_item_name;
4334:
4335: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4336: THEN
4337: Error_Handler.Add_Error_Token
4338: ( p_Message_Name => 'ENG_ECN_REVISION'
4339: -- , p_Message_Name => 'ENG_ITEM_HIGH_REV_PENDING'

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

4377: , p_revised_item_id => p_rev_item_unexp_rec.revised_item_id
4378: , p_organization_id => p_rev_item_unexp_rec.organization_id
4379: )
4380: THEN
4381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4382: THEN
4383: l_token_tbl.delete;
4384: l_token_tbl(1).token_name := 'ECO_NAME';
4385: l_token_tbl(1).token_value :=

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

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
4417: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4418: THEN
4419: l_token_tbl.delete;
4420: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4421: l_token_tbl(1).token_value :=

Line 4492: IF FND_MSG_PUB.Check_Msg_Level

4488: END IF;
4489:
4490: IF l_IsDateValid = FALSE
4491: THEN
4492: IF FND_MSG_PUB.Check_Msg_Level
4493: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4494: THEN
4495: l_token_tbl.delete;
4496: l_token_tbl(1).token_name :=

Line 4493: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4489:
4490: IF l_IsDateValid = FALSE
4491: THEN
4492: IF FND_MSG_PUB.Check_Msg_Level
4493: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4494: THEN
4495: l_token_tbl.delete;
4496: l_token_tbl(1).token_name :=
4497: 'REVISED_ITEM_NAME';

Line 4562: IF FND_MSG_PUB.Check_Msg_Level

4558:
4559: END LOOP;
4560:
4561: IF l_IsUseUpValid = FALSE THEN
4562: IF FND_MSG_PUB.Check_Msg_Level
4563: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4564: THEN
4565: l_token_tbl.delete;
4566: Error_Handler.Add_Error_Token

Line 4563: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4559: END LOOP;
4560:
4561: IF l_IsUseUpValid = FALSE THEN
4562: IF FND_MSG_PUB.Check_Msg_Level
4563: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4564: THEN
4565: l_token_tbl.delete;
4566: Error_Handler.Add_Error_Token
4567: ( p_Message_Name =>'ENG_USE_UP_ITEM_INVALID'

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

4609: , p_assembly_type => l_assembly_type)
4610: )
4611: AND l_plm_or_erp_change <> 'PLM'
4612: THEN
4613: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4614: THEN
4615: l_token_tbl.delete;
4616: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4617: l_token_tbl(1).token_value :=

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

4643: ( p_revised_Item_Id => p_rev_item_unexp_rec.revised_item_id
4644: , p_organization_Id => p_rev_item_unexp_rec.organization_id
4645: , p_assembly_type => l_assembly_type)
4646: THEN
4647: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4648: THEN
4649: l_token_tbl.delete;
4650: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4651: l_token_tbl(1).token_value :=

Line 4733: IF FND_MSG_PUB.Check_Msg_Level

4729: ( p_revised_item_rec => p_revised_item_rec
4730: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
4731: );
4732: IF l_result = 1 THEN
4733: IF FND_MSG_PUB.Check_Msg_Level
4734: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4735: THEN
4736: l_token_tbl.delete;
4737: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';

Line 4734: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4730: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
4731: );
4732: IF l_result = 1 THEN
4733: IF FND_MSG_PUB.Check_Msg_Level
4734: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4735: THEN
4736: l_token_tbl.delete;
4737: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4738: l_token_tbl(1).token_value :=

Line 4752: IF FND_MSG_PUB.Check_Msg_Level

4748: );
4749: END IF;
4750: l_return_status := FND_API.G_RET_STS_ERROR;
4751: ELSIF l_result = 2 THEN
4752: IF FND_MSG_PUB.Check_Msg_Level
4753: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4754: THEN
4755: l_token_tbl.delete;
4756: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';

Line 4753: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4749: END IF;
4750: l_return_status := FND_API.G_RET_STS_ERROR;
4751: ELSIF l_result = 2 THEN
4752: IF FND_MSG_PUB.Check_Msg_Level
4753: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4754: THEN
4755: l_token_tbl.delete;
4756: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4757: l_token_tbl(1).token_value :=

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

4793: ( p_revised_item_rec => p_revised_item_rec
4794: , p_rev_item_unexp_rec => p_rev_item_unexp_rec
4795: )
4796: THEN
4797: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4798: THEN
4799: l_token_tbl.delete;
4800: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4801: l_token_tbl(1).token_value := p_revised_item_rec.revised_item_name;

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

4839: AND
4840: p_revised_item_rec.status_type IN (1,2,4,7)
4841: AND p_control_rec.caller_type <> 'SSWA'
4842: THEN
4843: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4844: THEN
4845: l_token_tbl.delete;
4846: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4847: l_token_tbl(1).token_value :=

Line 4895: IF FND_MSG_PUB.Check_Msg_Level

4891: -- type match. Other wise it is an error.
4892: --
4893: EXCEPTION
4894: WHEN NO_DATA_FOUND THEN
4895: IF FND_MSG_PUB.Check_Msg_Level
4896: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4897: THEN
4898: l_token_tbl.delete;
4899: Error_Handler.Add_Error_Token

Line 4896: (FND_MSG_PUB.G_MSG_LVL_ERROR)

4892: --
4893: EXCEPTION
4894: WHEN NO_DATA_FOUND THEN
4895: IF FND_MSG_PUB.Check_Msg_Level
4896: (FND_MSG_PUB.G_MSG_LVL_ERROR)
4897: THEN
4898: l_token_tbl.delete;
4899: Error_Handler.Add_Error_Token
4900: ( p_Message_Name =>

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

4936: l_token_tbl(2).token_name := 'STATUS_TYPE';
4937: l_token_tbl(2).token_value :=
4938: p_revised_item_rec.status_type;
4939:
4940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4941: THEN
4942: Error_Handler.Add_Error_Token
4943: ( p_Message_Name => 'ENG_RIT_STAT_ECO_APPREQ'
4944: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

4973: l_token_tbl.DELETE;
4974: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
4975: l_token_tbl(1).token_value :=
4976: p_revised_item_rec.revised_item_name;
4977: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4978: THEN
4979: Error_Handler.Add_Error_Token
4980: ( p_Message_Name => 'ENG_ALT_DESG_NOT_UPDATEABLE'
4981: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
5002: Error_Handler.Add_Error_Token
5003: ( p_Message_Name => 'ENG_CANNOT_HAVE_REVISION'
5004: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
5015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5016: THEN
5017: Error_Handler.Add_Error_Token
5018: ( p_Message_Name => 'ENG_CANNOT_HAVE_REVISION'
5019: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
5044: ( p_Message_Name => 'ENG_ITEM_NO_CURR_REV'
5045: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
5076: Error_Handler.Add_Error_Token
5077: ( p_Message_Name => 'ENG_ITEM_REV_NOT_EQ_CURR_REV'
5078: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5163: IF FND_MSG_PUB.Check_Msg_Level

5159: END IF;
5160:
5161: IF l_new_revision_status = 1
5162: THEN
5163: IF FND_MSG_PUB.Check_Msg_Level
5164: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5165: THEN
5166: Error_Handler.Add_Error_Token
5167: ( --p_Message_Name => 'ENG_NEW_ITEM_REV_NOT_CURR'

Line 5164: (FND_MSG_PUB.G_MSG_LVL_ERROR)

5160:
5161: IF l_new_revision_status = 1
5162: THEN
5163: IF FND_MSG_PUB.Check_Msg_Level
5164: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5165: THEN
5166: Error_Handler.Add_Error_Token
5167: ( --p_Message_Name => 'ENG_NEW_ITEM_REV_NOT_CURR'
5168: p_Message_Name => l_message_name

Line 5194: IF FND_MSG_PUB.Check_Msg_Level

5190: l_token_tbl(2).token_value := p_revised_item_rec.revised_item_name;
5191:
5192: l_token_tbl(3).token_name := 'ECO_NAME';
5193: l_token_tbl(3).token_value := l_change_notice;
5194: IF FND_MSG_PUB.Check_Msg_Level
5195: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5196: THEN
5197: Error_Handler.Add_Error_Token
5198: ( p_Message_Name => 'ENG_NEW_ITEM_REV_EXISTS'

Line 5195: (FND_MSG_PUB.G_MSG_LVL_ERROR)

5191:
5192: l_token_tbl(3).token_name := 'ECO_NAME';
5193: l_token_tbl(3).token_value := l_change_notice;
5194: IF FND_MSG_PUB.Check_Msg_Level
5195: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5196: THEN
5197: Error_Handler.Add_Error_Token
5198: ( p_Message_Name => 'ENG_NEW_ITEM_REV_EXISTS'
5199: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 5208: IF FND_MSG_PUB.Check_Msg_Level

5204:
5205: l_return_status := FND_API.G_RET_STS_ERROR;
5206: ELSIF l_new_revision_status = 3
5207: THEN
5208: IF FND_MSG_PUB.Check_Msg_Level
5209: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5210: THEN
5211: Error_Handler.Add_Error_Token
5212: ( p_Message_Name => 'ENG_NEW_ITEM_REV_IMPL'

Line 5209: (FND_MSG_PUB.G_MSG_LVL_ERROR)

5205: l_return_status := FND_API.G_RET_STS_ERROR;
5206: ELSIF l_new_revision_status = 3
5207: THEN
5208: IF FND_MSG_PUB.Check_Msg_Level
5209: (FND_MSG_PUB.G_MSG_LVL_ERROR)
5210: THEN
5211: Error_Handler.Add_Error_Token
5212: ( p_Message_Name => 'ENG_NEW_ITEM_REV_IMPL'
5213: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

5252: END IF;
5253:
5254: IF l_is_revision_invalid = 1
5255: THEN
5256: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5257: THEN
5258: l_Token_Tbl.delete;
5259: Error_Handler.Add_Error_Token
5260: ( p_Message_Name => 'ENG_REVISION_ORDER'

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

5288: , p_rev_item_seq_id => p_rev_item_unexp_rec.revised_item_sequence_id);
5289:
5290: IF l_is_scheduled_date_invalid = 1
5291: THEN
5292: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5293: THEN
5294: Error_Handler.Add_Error_Token
5295: ( p_Message_Name => 'ENG_INVALID_SCHED_DATE'
5296: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

5361: WHEN OTHERS THEN
5362:
5363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5364:
5365: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5366: THEN
5367: l_err_text := G_PKG_NAME || ' : (Entity Validation) ' ||
5368: substrb(SQLERRM,1,200);
5369: Error_Handler.Add_Error_Token

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

5461: p_old_revised_item_rec.status_type IS NULL )
5462: THEN
5463: IF NOT ENG_Validate.Status_Type(p_revised_item_rec.status_type ,
5464: l_err_text ) THEN
5465: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5466: THEN
5467: l_token_tbl(2).token_name := 'STATUS_TYPE';
5468: l_token_tbl(2).token_value := p_revised_item_rec.status_type;
5469: Error_Handler.Add_Error_Token

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

5478:
5479: -- Status Type cannot be missing.
5480: IF p_revised_item_rec.status_type = FND_API.G_MISS_NUM
5481: THEN
5482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5483: THEN
5484: Error_Handler.Add_Error_Token
5485: ( p_Message_Name => 'ENG_RIT_STAT_TYPE_MISSING'
5486: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

5496:
5497: -- Creates or Updates of records marked Implemented is not allowed
5498: IF p_revised_item_rec.status_type = 6
5499: THEN
5500: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5501: THEN
5502: Error_Handler.Add_Error_Token
5503: ( p_Message_Name => 'ENG_RIT_STAT_CANNOT_BE_IMPL'
5504: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

5517: ( p_revised_item_rec.status_type <> 1 AND
5518: p_revised_item_rec.status_type <> 4
5519: )
5520: THEN
5521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5522: THEN
5523: Error_Handler.Add_Error_Token
5524: ( p_Message_Name => 'ENG_RIT_CREATE_STAT_INVALID'
5525: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

5546: , x_err_text => l_err_text
5547: )
5548: THEN
5549: x_return_status := FND_API.G_RET_STS_ERROR;
5550: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5551: THEN
5552: l_token_tbl(2).token_name := 'FROM_END_ITEM_UNIT_NUMBER';
5553: l_token_tbl(2).token_value :=
5554: p_revised_item_rec.from_end_item_unit_number;

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

5575: , x_err_text => l_err_text
5576: )
5577: THEN
5578: x_return_status := FND_API.G_RET_STS_ERROR;
5579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5580: THEN
5581: l_token_tbl(2).token_name := 'FROM_END_ITEM_UNIT_NUMBER';
5582: l_token_tbl(2).token_value :=
5583: p_revised_item_rec.new_from_end_item_unit_number;

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

5598: THEN
5599: IF NOT ENG_Validate.Mrp_Active(p_revised_item_rec.mrp_active ,
5600: l_err_text ) THEN
5601: x_return_status := FND_API.G_RET_STS_ERROR;
5602: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5603: THEN
5604: l_token_tbl(2).token_name := 'MRP_ACTIVE';
5605: l_token_tbl(2).token_value :=
5606: p_revised_item_rec.mrp_active;

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

5616: END IF;
5617:
5618: IF p_revised_item_rec.mrp_active = FND_API.G_MISS_NUM
5619: THEN
5620: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5621: THEN
5622: Error_Handler.Add_Error_Token
5623: ( p_Message_Name => 'ENG_MRP_ACTIVE_MISSING'
5624: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

5640: THEN
5641: IF NOT ENG_Validate.Update_Wip(p_revised_item_rec.update_wip ,
5642: l_err_text ) THEN
5643: x_return_status := FND_API.G_RET_STS_ERROR;
5644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5645: THEN
5646: l_token_tbl(2).token_name := 'UPDATE_WIP';
5647: l_token_tbl(2).token_value :=
5648: p_revised_item_rec.update_wip;

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

5657: END IF;
5658:
5659: IF p_revised_item_rec.update_wip = FND_API.G_MISS_NUM
5660: THEN
5661: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5662: THEN
5663: Error_Handler.Add_Error_Token
5664: ( p_Message_Name => 'ENG_UPDATE_WIP_MISSING'
5665: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

5683: ( p_revised_item_rec.use_up_plan_name
5684: , p_rev_item_unexp_rec.organization_id
5685: , l_err_text )
5686: THEN
5687: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5688: THEN
5689: -- If the function returns with an error then
5690: -- l_err_text will carry the message_name to be
5691: -- displayed.

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

5729: IF NOT ENG_Validate.Disposition_Type
5730: ( p_revised_item_rec.disposition_type
5731: , l_err_text )
5732: THEN
5733: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5734: THEN
5735: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
5736: l_token_tbl(1).token_value :=
5737: p_revised_item_rec.revised_item_name;

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

5750: END IF;
5751:
5752: IF p_revised_item_rec.disposition_type = FND_API.G_MISS_NUM
5753: THEN
5754: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5755: THEN
5756: Error_Handler.Add_Error_Token
5757: ( p_Message_Name => 'ENG_DISPOSITION_TYPE_MISSING'
5758: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

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
5811: ( p_Message_Name => 'ENG_RIT_ECO_FOR_PROD_MISSING'
5812: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

5915: WHEN OTHERS THEN
5916:
5917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5918:
5919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5920: THEN
5921: l_err_text := G_PKG_NAME || ' : (Attribute Validation) ' ||
5922: substrb(SQLERRM,1,200);
5923: Error_Handler.Add_Error_Token

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

6037: --
6038: -- if loop executes, then component exist on that bill
6039: -- so it cannot be deleted.
6040: --
6041: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6042: THEN
6043: Error_Handler.Add_Error_Token
6044: ( p_Message_Name => 'ENG_CANNOT_DEL_COMP_EXIST'
6045: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

6061: --
6062: -- if loop executes, then revised operation exist on that
6063: -- routing so it cannot be deleted.
6064: --
6065: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6066: THEN
6067: Error_Handler.Add_Error_Token
6068: ( p_Message_Name => 'ENG_CANNOT_DEL_OP_EXIST'
6069: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

6088: );
6089:
6090: IF check_delete <> 0
6091: THEN
6092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6093: THEN
6094: Error_Handler.Add_Error_Token
6095: ( p_Message_Name => 'ENG_CANNOT_DEL_COMMON_EXIST'
6096: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

6112: );
6113:
6114: IF check_delete <> 0
6115: THEN
6116: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6117: THEN
6118: Error_Handler.Add_Error_Token
6119: ( p_Message_Name => 'ENG_CANNOT_DEL_RTG_COMMON_EXIST'
6120: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

6131: OPEN allow_delete_rev;
6132: FETCH allow_delete_rev into l_allow_rev;
6133: IF l_allow_rev = 1
6134: THEN
6135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6136: THEN
6137: Error_Handler.Add_Error_Token
6138: ( p_Message_Name => 'ENG_CANNOT_DEL_REVISION_IN_USE'
6139: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

6166: THEN
6167: CLOSE allow_delete_rev;
6168: END IF;
6169:
6170: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6171: THEN
6172: l_err_text := G_PKG_NAME || ' : (Entity Delete Validation) ' ||
6173: substrb(SQLERRM,1,200);
6174: Error_Handler.Add_Error_Token

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

6790: )
6791:
6792: THEN
6793:
6794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6795: THEN
6796: l_token_tbl.delete;
6797: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
6798: l_token_tbl(1).token_value := p_revised_item_name ;

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

6829: )
6830:
6831: THEN
6832:
6833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6834: THEN
6835: l_token_tbl.delete;
6836: l_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
6837: l_token_tbl(1).token_value := p_revised_item_name ;

Line 7125: FND_MSG_PUB.Initialize;

7121: END IF;
7122:
7123: -- Initialize message list if p_init_msg_list is set to TRUE.
7124: IF FND_API.to_Boolean(p_init_msg_list) THEN
7125: FND_MSG_PUB.Initialize;
7126: Error_Handler.Initialize;
7127: END IF;
7128:
7129: IF p_debug = 'Y'

Line 7407: Fnd_msg_pub.add;

7403: token => 'ENTITY'
7404: , value => ' '
7405: );
7406: /* END IF;*/
7407: Fnd_msg_pub.add;
7408: END LOOP;
7409: END IF;
7410:
7411: -- Start of Closure to procedure

Line 7414: FND_MSG_PUB.Count_And_Get(

7410:
7411: -- Start of Closure to procedure
7412: x_return_status := l_return_status;
7413:
7414: FND_MSG_PUB.Count_And_Get(
7415: p_count => x_msg_count
7416: , p_data => l_msg_data
7417: );
7418:

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

7426:
7427: EXCEPTION
7428: WHEN OTHERS THEN
7429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7430: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7431: THEN
7432: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
7433: END IF;
7434: FND_MSG_PUB.Count_And_Get(

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

7428: WHEN OTHERS THEN
7429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7430: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7431: THEN
7432: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
7433: END IF;
7434: FND_MSG_PUB.Count_And_Get(
7435: p_count => x_msg_count
7436: , p_data => x_msg_data

Line 7434: FND_MSG_PUB.Count_And_Get(

7430: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7431: THEN
7432: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
7433: END IF;
7434: FND_MSG_PUB.Count_And_Get(
7435: p_count => x_msg_count
7436: , p_data => x_msg_data
7437: );
7438: IF Bom_Globals.Get_Debug = 'Y'