DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REV_COMPONENT dependencies on FND_MSG_PUB

Line 1771: IF FND_MSG_PUB.Check_Msg_Level

1767: -- If the primary bill does not exist then the acd type
1768: -- of the component cannot be other that add.
1769: --
1770: ******************************************************/
1771: IF FND_MSG_PUB.Check_Msg_Level
1772: (FND_MSG_PUB.G_MSG_LVL_ERROR)
1773: THEN
1774: Error_Handler.Add_Error_Token
1775: ( p_message_name => 'ENG_CMP_ACD_TYPE_ADD'

Line 1772: (FND_MSG_PUB.G_MSG_LVL_ERROR)

1768: -- of the component cannot be other that add.
1769: --
1770: ******************************************************/
1771: IF FND_MSG_PUB.Check_Msg_Level
1772: (FND_MSG_PUB.G_MSG_LVL_ERROR)
1773: THEN
1774: Error_Handler.Add_Error_Token
1775: ( p_message_name => 'ENG_CMP_ACD_TYPE_ADD'
1776: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

1797: AND bom.common_bill_sequence_id <> bom.bill_sequence_id;
1798:
1799: -- If no exception is raised then Bill is referencing another
1800: -- bill
1801: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1802: THEN
1803: g_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
1804: g_token_tbl(2).token_value :=
1805: p_rev_component_rec.revised_item_name;

Line 1819: IF FND_MSG_PUB.Check_Msg_Level

1815: EXCEPTION
1816: WHEN NO_DATA_FOUND THEN
1817: NULL;
1818: WHEN OTHERS THEN
1819: IF FND_MSG_PUB.Check_Msg_Level
1820: (FND_MSG_PUB.G_MSG_LVL_ERROR)
1821: THEN
1822: Error_Handler.Add_Error_Token
1823: ( p_message_name => NULL

Line 1820: (FND_MSG_PUB.G_MSG_LVL_ERROR)

1816: WHEN NO_DATA_FOUND THEN
1817: NULL;
1818: WHEN OTHERS THEN
1819: IF FND_MSG_PUB.Check_Msg_Level
1820: (FND_MSG_PUB.G_MSG_LVL_ERROR)
1821: THEN
1822: Error_Handler.Add_Error_Token
1823: ( p_message_name => NULL
1824: , p_message_text => 'Common Bill Check ' ||

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

1840: ******************************************************************/
1841: IF p_rev_comp_unexp_rec.revised_item_id =
1842: p_rev_comp_unexp_rec.component_item_id
1843: THEN
1844: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1845: THEN
1846: g_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
1847: g_token_tbl(1).token_value :=
1848: g_rev_component_rec.revised_item_name;

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

1868: --
1869: **************************************************************/
1870: IF g_Comp_Bom_Enabled_Flag = 'N' THEN
1871: -- Bom_Enabled is N, so cannot add a component.
1872: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1873: THEN
1874: Error_Handler.Add_Error_Token
1875: ( x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1876: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

1922: *********************************************************************/
1923:
1924: IF g_Comp_Item_Type = 5
1925: THEN
1926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1927: THEN
1928: Error_Handler.Add_Error_Token
1929: ( p_message_name => 'ENG_ITEM_PRODUCT_FAMILY'
1930: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

1961: ELSIF l_result = 3 THEN
1962: l_err_text := 'ENG_COMP_NOT_ENG_IN_OTHER_ORGS';
1963: END IF;
1964:
1965: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1966: THEN
1967: Error_Handler.Add_Error_Token
1968: ( p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1969: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

1990: --
1991: IF p_Old_Rev_Component_Rec.Shipping_Allowed <>
1992: p_rev_component_rec.shipping_allowed
1993: THEN
1994: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1995: THEN
1996: Error_Handler.Add_Error_Token
1997: ( p_message_name => 'ENG_SHIP_ALLOWED_NOT_UPDATE'
1998: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2005:
2006: IF p_rev_component_rec.old_effectivity_date IS NOT NULL AND
2007: p_rev_component_rec.old_effectivity_date <> FND_API.G_MISS_DATE
2008: THEN
2009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2010: THEN
2011: Error_Handler.Add_Error_Token
2012: ( p_message_name => 'ENG_OLD_EFFECTIVITY_GIVEN'
2013: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2021:
2022: IF p_rev_component_rec.old_operation_sequence_number IS NOT NULL AND
2023: p_rev_component_rec.old_operation_sequence_number <> FND_API.G_MISS_NUM
2024: THEN
2025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2026: THEN
2027: Error_Handler.Add_Error_Token
2028: ( p_message_name => 'ENG_OLD_OP_SEQ_NUM_GIVEN'
2029: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2040: --
2041: IF p_rev_component_rec.acd_type <>
2042: p_old_rev_component_rec.acd_type
2043: THEN
2044: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2045: THEN
2046: Error_Handler.Add_Error_Token
2047: ( p_message_name => 'ENG_ACD_TYPE_NOT_UPDATEABLE'
2048: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2058: -- is Disabled on the ECO
2059: --
2060: IF p_old_rev_component_rec.acd_type = 3
2061: THEN
2062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2063: THEN
2064: Error_Handler.Add_Error_Token
2065: ( p_message_name => 'ENG_COMPONENT_DISABLED'
2066: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2077: IF p_rev_component_rec.acd_type = 3 AND
2078: p_rev_component_rec.to_end_item_unit_number <>
2079: p_old_rev_component_rec.to_end_item_unit_number
2080: THEN
2081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2082: THEN
2083: Error_Handler.Add_Error_Token
2084: ( p_message_name => 'ENG_DISABLE_TOUNIT_NONUPD'
2085: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2108: --
2109:
2110: IF p_rev_component_rec.disable_date <
2111: p_rev_component_rec.start_effective_date THEN
2112: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2113: THEN
2114: Error_Handler.Add_Error_Token
2115: ( p_message_name => 'ENG_COMP_DIS_DATE_INVALID'
2116: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2185: IF FND_MSG_PUB.Check_Msg_Level

2181: IF g_assy_item_type = 3 -- Planning parent
2182: OR
2183: g_comp_item_type = 2 -- Option Class component
2184: THEN
2185: IF FND_MSG_PUB.Check_Msg_Level
2186: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2187: THEN
2188: g_token_tbl(2).token_name :=
2189: 'REVISED_ITEM_NAME';

Line 2186: (FND_MSG_PUB.G_MSG_LVL_ERROR)

2182: OR
2183: g_comp_item_type = 2 -- Option Class component
2184: THEN
2185: IF FND_MSG_PUB.Check_Msg_Level
2186: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2187: THEN
2188: g_token_tbl(2).token_name :=
2189: 'REVISED_ITEM_NAME';
2190: g_token_tbl(2).token_value :=

Line 2228: IF FND_MSG_PUB.Check_Msg_Level

2224:
2225: EXCEPTION
2226: WHEN NO_DATA_FOUND THEN
2227: -- component is yet not implemented
2228: IF FND_MSG_PUB.Check_Msg_Level
2229: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2230: THEN
2231: Error_Handler.Add_Error_Token
2232: ( p_message_name => 'ENG_OLD_COMP_SEQ_ID_INVALID'

Line 2229: (FND_MSG_PUB.G_MSG_LVL_ERROR)

2225: EXCEPTION
2226: WHEN NO_DATA_FOUND THEN
2227: -- component is yet not implemented
2228: IF FND_MSG_PUB.Check_Msg_Level
2229: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2230: THEN
2231: Error_Handler.Add_Error_Token
2232: ( p_message_name => 'ENG_OLD_COMP_SEQ_ID_INVALID'
2233: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2288: IF FND_MSG_PUB.Check_Msg_Level

2284: l_result := Check_Op_Seq;
2285:
2286: IF l_result = 1
2287: THEN
2288: IF FND_MSG_PUB.Check_Msg_Level
2289: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2290: THEN
2291: g_Token_Tbl(1).Token_Name := 'REVISED_ITEM_NAME';
2292: g_Token_Tbl(1).Token_Value :=

Line 2289: (FND_MSG_PUB.G_MSG_LVL_ERROR)

2285:
2286: IF l_result = 1
2287: THEN
2288: IF FND_MSG_PUB.Check_Msg_Level
2289: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2290: THEN
2291: g_Token_Tbl(1).Token_Name := 'REVISED_ITEM_NAME';
2292: g_Token_Tbl(1).Token_Value :=
2293: g_Rev_Component_rec.revised_item_name;

Line 2309: IF FND_MSG_PUB.Check_Msg_Level

2305: g_Rev_Component_rec.component_item_name;
2306: END IF;
2307: l_return_status := FND_API.G_RET_STS_ERROR;
2308: ELSIF l_result = 2 THEN
2309: IF FND_MSG_PUB.Check_Msg_Level
2310: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2311: THEN
2312: g_Token_Tbl(2).Token_Name := 'OP_SEQ_NUM';
2313: g_Token_Tbl(2).Token_Value :=

Line 2310: (FND_MSG_PUB.G_MSG_LVL_ERROR)

2306: END IF;
2307: l_return_status := FND_API.G_RET_STS_ERROR;
2308: ELSIF l_result = 2 THEN
2309: IF FND_MSG_PUB.Check_Msg_Level
2310: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2311: THEN
2312: g_Token_Tbl(2).Token_Name := 'OP_SEQ_NUM';
2313: g_Token_Tbl(2).Token_Value :=
2314: to_char

Line 2345: IF FND_MSG_PUB.Check_Msg_Level

2341: WHEN OTHERS THEN
2342: l_result := 0;
2343: END;
2344:
2345: IF FND_MSG_PUB.Check_Msg_Level
2346: (FND_MSG_PUB.G_MSG_LVL_ERROR) AND
2347: l_result = 0
2348: THEN
2349: g_Token_Tbl(2).Token_Name := 'OLD_OP_SEQUENCE_NUM';

Line 2346: (FND_MSG_PUB.G_MSG_LVL_ERROR) AND

2342: l_result := 0;
2343: END;
2344:
2345: IF FND_MSG_PUB.Check_Msg_Level
2346: (FND_MSG_PUB.G_MSG_LVL_ERROR) AND
2347: l_result = 0
2348: THEN
2349: g_Token_Tbl(2).Token_Name := 'OLD_OP_SEQUENCE_NUM';
2350: g_Token_Tbl(2).Token_Value :=

Line 2379: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2375: X_Rowid => NULL)
2376: THEN
2377: --if function return true then component dates overlapp
2378:
2379: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2380: THEN
2381: Error_Handler.Add_Error_Token
2382: ( p_Message_Name => 'ENG_COMP_OPSEQ_DATE_OVERLAP'
2383: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2405: X_Rowid => NULL)
2406: THEN
2407: --if function return true then component dates overlapp
2408:
2409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2410: THEN
2411: Error_Handler.Add_Error_Token
2412: ( p_Message_Name => 'ENG_COMP_OPSEQ_UNIT_OVERLAP'
2413: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2441: )
2442: THEN
2443: l_Result := Check_PTO_ATO_for_Optional;
2444: IF l_Result = 1 THEN
2445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2446: THEN
2447: Error_Handler.Add_Error_Token
2448: ( p_message_name => 'ENG_COMP_OPTIONAL'
2449: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2453: END IF;
2454: l_return_status := FND_API.G_RET_STS_ERROR;
2455: ELSIF l_Result = 2
2456: THEN
2457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2458: THEN
2459: Error_Handler.Add_Error_Token
2460: ( p_message_name => 'ENG_COMP_NOT_OPTIONAL'
2461: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2491: )
2492: THEN
2493: l_Result := Check_Planning_Percent;
2494: IF l_Result = 1 THEN
2495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2496: THEN
2497: g_Token_Tbl(2).Token_Name := 'REVISED_ITEM_NAME';
2498: g_Token_Tbl(2).Token_Value :=
2499: g_rev_component_rec.revised_item_name;

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

2506: g_Token_Tbl.DELETE(2);
2507: END IF;
2508: l_return_status := FND_API.G_RET_STS_ERROR;
2509: ELSIF l_Result = 2 THEN
2510: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2511: THEN
2512: g_Token_Tbl(2).Token_Name := 'REVISED_ITEM_NAME';
2513: g_Token_Tbl(2).Token_Value :=
2514: g_rev_component_rec.revised_item_name;

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

2531: g_Token_Tbl.DELETE(3);
2532: l_return_status := FND_API.G_RET_STS_ERROR;
2533: END IF;
2534: ELSIF l_Result = 3 THEN
2535: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2536: THEN
2537: g_Token_Tbl(1).Token_Name := 'REVISED_ITEM_NAME';
2538: g_Token_Tbl(1).Token_Value :=
2539: g_rev_component_rec.revised_item_name;

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

2583: THEN
2584:
2585: l_Result := Chk_Req_For_Rev_Or_Shp;
2586: IF l_Result = 1 THEN
2587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2588: THEN
2589: g_Token_Tbl(2).Token_Name := 'REVISED_ITEM_NAME';
2590: g_Token_Tbl(2).Token_Value :=
2591: g_rev_component_rec.revised_item_name;

Line 2686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) AND

2682: /* We will not be using the result of the check_atp procedure
2683: to decide the translatable token since the message text
2684: is now changed. Please refer to text for ENG_ATP_CHECK_NOT_NO
2685: */
2686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) AND
2687: l_result <> 0
2688: THEN
2689: Error_Handler.Add_Error_Token
2690: ( p_message_name => 'ENG_ATP_CHECK_NOT_NO'

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

2719: ELSIF l_result = 2 THEN
2720: l_err_text := 'ENG_MUT_EXCL_NOT_MDL_OPTCLASS';
2721: END IF;
2722:
2723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2724: THEN
2725: Error_Handler.Add_Error_Token
2726: ( p_message_name => l_err_text
2727: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2772: ) AND
2773: p_rev_component_rec.minimum_allowed_quantity is not null
2774: AND
2775: NOT Check_Min_Quantity THEN
2776: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2777: THEN
2778: Error_Handler.Add_Error_Token
2779: ( p_message_name => 'ENG_MIN_QUANTITY_INVALID'
2780: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2792: ) AND
2793: p_rev_component_rec.maximum_allowed_quantity IS NOT NULL
2794: AND
2795: NOT Check_Max_Quantity THEN
2796: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2797: THEN
2798: Error_Handler.Add_Error_Token
2799: ( p_message_name => 'ENG_MAX_QUANTITY_INVALID'
2800: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2839: <> p_rev_component_rec.quantity_per_assembly)
2840: )
2841: )
2842: THEN
2843: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2844: THEN
2845: Error_Handler.Add_Error_Token
2846: ( p_message_name => 'ENG_COMP_QTY_FRACTIONAL'
2847: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2865:
2866: IF g_Comp_Atp_Check_Flag = 'Y' AND
2867: p_rev_component_rec.quantity_per_assembly < 0
2868: THEN
2869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2870: THEN
2871: Error_Handler.Add_Error_Token
2872: ( p_message_name => 'ENG_COMP_QTY_NEGATIVE'
2873: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2886: ********************************************************************/
2887: IF g_Comp_PTO_Flag = 'Y' AND
2888: p_rev_component_rec.quantity_per_assembly < 0
2889: THEN
2890: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2891: THEN
2892: Error_Handler.Add_Error_Token
2893: ( p_message_name => 'ENG_COMP_PTO_QTY_NEGATIVE'
2894: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2923: )
2924: AND
2925: NOT Check_Supply_SubInventory THEN
2926:
2927: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2928: THEN
2929: Error_Handler.Add_Error_Token
2930: ( p_message_name => 'ENG_SUBINV_INVALID'
2931: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2963: --dbms_output.put_line('Locators check returned with an error-' ||
2964: -- to_char(l_locator_control));
2965:
2966: IF l_locator_control = 4 THEN
2967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2968: THEN
2969: Error_Handler.Add_Error_Token
2970: ( p_message_name => 'ENG_LOCATOR_REQUIRED'
2971: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

2974: );
2975: END IF;
2976: ELSIF l_locator_control = 3 THEN
2977: -- Log the Dynamic locator control message.
2978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2979: THEN
2980: Error_Handler.Add_Error_Token
2981: ( p_message_name => 'ENG_LOCATOR_CANNOT_BE_DYNAMIC'
2982: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2993: IF FND_MSG_PUB.Check_Msg_Level

2989:
2990: -- if error occured when item_locator_control was
2991: -- restrcited
2992:
2993: IF FND_MSG_PUB.Check_Msg_Level
2994: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2995: THEN
2996: Error_Handler.Add_Error_Token
2997: ( p_message_name => 'ENG_ITEM_LOCATOR_RESTRICTED'

Line 2994: (FND_MSG_PUB.G_MSG_LVL_ERROR)

2990: -- if error occured when item_locator_control was
2991: -- restrcited
2992:
2993: IF FND_MSG_PUB.Check_Msg_Level
2994: (FND_MSG_PUB.G_MSG_LVL_ERROR)
2995: THEN
2996: Error_Handler.Add_Error_Token
2997: ( p_message_name => 'ENG_ITEM_LOCATOR_RESTRICTED'
2998: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3004: IF FND_MSG_PUB.Check_Msg_Level

3000: , p_Token_Tbl => g_Token_Tbl
3001: );
3002: END IF;
3003: ELSE
3004: IF FND_MSG_PUB.Check_Msg_Level
3005: (FND_MSG_PUB.G_MSG_LVL_ERROR)
3006: THEN
3007: g_Token_Tbl(1).token_name := 'REVISED_COMPONENT_NAME';
3008: g_Token_Tbl(1).token_value:= p_rev_component_rec.component_item_name;

Line 3005: (FND_MSG_PUB.G_MSG_LVL_ERROR)

3001: );
3002: END IF;
3003: ELSE
3004: IF FND_MSG_PUB.Check_Msg_Level
3005: (FND_MSG_PUB.G_MSG_LVL_ERROR)
3006: THEN
3007: g_Token_Tbl(1).token_name := 'REVISED_COMPONENT_NAME';
3008: g_Token_Tbl(1).token_value:= p_rev_component_rec.component_item_name;
3009:

Line 3019: IF FND_MSG_PUB.Check_Msg_Level

3015: );
3016: END IF;
3017: END IF;
3018: ELSIF l_locator_control = 1 THEN
3019: IF FND_MSG_PUB.Check_Msg_Level
3020: (FND_MSG_PUB.G_MSG_LVL_ERROR)
3021: THEN
3022: Error_Handler.Add_Error_Token
3023: ( p_message_name => 'ENG_ITEM_NO_LOCATOR_CONTROL'

Line 3020: (FND_MSG_PUB.G_MSG_LVL_ERROR)

3016: END IF;
3017: END IF;
3018: ELSIF l_locator_control = 1 THEN
3019: IF FND_MSG_PUB.Check_Msg_Level
3020: (FND_MSG_PUB.G_MSG_LVL_ERROR)
3021: THEN
3022: Error_Handler.Add_Error_Token
3023: ( p_message_name => 'ENG_ITEM_NO_LOCATOR_CONTROL'
3024: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3031: l_return_status := FND_API.G_RET_STS_ERROR;
3032: ELSIF p_rev_component_rec.location_name IS NOT NULL AND
3033: p_rev_component_rec.supply_subinventory IS NULL
3034: THEN
3035: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3036: THEN
3037: Error_Handler.Add_Error_Token
3038: ( p_message_name => 'ENG_LOCATOR_MUST_BE_NULL'
3039: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3225: , x_err_text => l_err_text
3226: )
3227: THEN
3228: x_return_status := FND_API.G_RET_STS_ERROR;
3229: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3230: THEN
3231: g_token_tbl(1).token_name := 'FROM_END_ITEM_UNIT_NUMBER';
3232: g_token_tbl(1).token_value :=
3233: p_rev_component_rec.from_end_item_unit_number;

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

3255: , x_err_text => l_err_text
3256: )
3257: THEN
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3260: THEN
3261: g_token_tbl(1).token_name := 'FROM_END_ITEM_UNIT_NUMBER';
3262: g_token_tbl(1).token_value :=
3263: p_rev_component_rec.to_end_item_unit_number;

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

3291:
3292: IF p_rev_component_rec.wip_supply_type IS NOT NULL AND
3293: p_rev_component_rec.wip_supply_type = 7
3294: THEN
3295: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3296: THEN
3297: g_token_tbl(2).token_name := 'WIP_SUPPLY_TYPE';
3298: g_token_tbl(2).token_value :=
3299: p_rev_component_rec.wip_supply_type;

Line 3317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3313: ( p_wip_supply_type => p_rev_component_rec.wip_supply_type
3314: , x_err_text => l_err_text
3315: )
3316: THEN
3317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3318: THEN
3319: g_token_tbl(1).token_name := 'WIP_SUPPLY_TYPE';
3320: g_token_tbl(1).token_value :=
3321: p_rev_component_rec.wip_supply_type;

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

3336:
3337: IF p_rev_component_rec.operation_sequence_number IS NOT NULL AND
3338: p_rev_component_rec.operation_sequence_number <= 0
3339: THEN
3340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3341: THEN
3342: Error_Handler.Add_Error_Token
3343: ( p_Message_Name => 'ENG_OPSEQ_LESS_THAN_ZERO'
3344: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3355: ( p_rev_component_rec.item_sequence_number < 0 OR
3356: p_rev_component_rec.item_sequence_number > 9999
3357: )
3358: THEN
3359: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3360: THEN
3361: Error_Handler.Add_Error_Token
3362: ( p_Message_Name => 'ENG_ITEM_NUM_INVALID'
3363: , p_Mesg_token_Tbl => l_Mesg_token_Tbl

Line 3375: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3371: IF p_rev_component_rec.projected_yield IS NOT NULL AND
3372: p_rev_component_rec.projected_yield < 0 OR
3373: p_rev_component_rec.projected_yield > 1
3374: THEN
3375: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3376: THEN
3377: g_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
3378: g_token_tbl(1).token_value := p_rev_component_rec.component_item_name;
3379: Error_Handler.Add_Error_Token

Line 3392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3388:
3389: IF p_rev_component_rec.include_in_cost_rollup IS NOT NULL AND
3390: p_rev_component_rec.include_in_cost_rollup NOT IN (1,2)
3391: THEN
3392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3393: THEN
3394: Error_Handler.Add_Error_Token
3395: ( p_Message_Name => 'ENG_INCL_IN_COST_ROLL_INVALID'
3396: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3403:
3404: IF p_rev_component_rec.SO_Basis IS NOT NULL AND
3405: p_rev_component_rec.SO_Basis NOT IN (1, 2)
3406: THEN
3407: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3408: THEN
3409: Error_Handler.Add_Error_Token
3410: ( p_Message_Name => 'ENG_SO_BASIS_INVALID'
3411: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3422: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3418:
3419: IF p_rev_component_rec.optional IS NOT NULL AND
3420: p_rev_component_rec.optional NOT IN (1, 2)
3421: THEN
3422: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3423: THEN
3424: Error_Handler.Add_Error_Token
3425: ( p_Message_Name => 'ENG_OPTIONAL_INVALID'
3426: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3437: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3433:
3434: IF p_rev_component_rec.mutually_exclusive IS NOT NULL AND
3435: p_rev_component_rec.mutually_exclusive NOT IN (1, 2)
3436: THEN
3437: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3438: THEN
3439: Error_Handler.Add_Error_Token
3440: ( p_Message_Name => 'ENG_MUTUALLY_EXCLUSIVE_INVALID'
3441: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3448:
3449: IF p_rev_component_rec.check_atp IS NOT NULL AND
3450: p_rev_component_rec.check_atp NOT IN (1, 2)
3451: THEN
3452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3453: THEN
3454: Error_Handler.Add_Error_Token
3455: ( p_Message_Name => 'ENG_CHECK_ATP_INVALID'
3456: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3463:
3464: IF p_rev_component_rec.shipping_allowed IS NOT NULL AND
3465: p_rev_component_rec.shipping_allowed NOT IN (1, 2)
3466: THEN
3467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3468: THEN
3469: Error_Handler.Add_Error_Token
3470: ( p_Message_Name => 'ENG_SHIPPING_ALLOWED_INVALID'
3471: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3478:
3479: IF p_rev_component_rec.required_to_ship IS NOT NULL AND
3480: p_rev_component_rec.required_to_ship NOT IN (1, 2)
3481: THEN
3482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3483: THEN
3484: Error_Handler.Add_Error_Token
3485: ( p_Message_Name => 'ENG_REQUIRED_TO_SHIP_INVALID'
3486: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3493:
3494: IF p_rev_component_rec.required_for_revenue IS NOT NULL AND
3495: p_rev_component_rec.required_for_revenue NOT IN (1, 2)
3496: THEN
3497: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3498: THEN
3499: Error_Handler.Add_Error_Token
3500: ( p_Message_Name => 'ENG_REQ_FOR_REVENUE_INVALID'
3501: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3508:
3509: IF p_rev_component_rec.include_on_ship_docs IS NOT NULL AND
3510: p_rev_component_rec.include_on_ship_docs NOT IN (1, 2)
3511: THEN
3512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3513: THEN
3514: Error_Handler.Add_Error_Token
3515: ( p_Message_Name => 'ENG_INCL_ON_SHIP_DOCS_INVALID'
3516: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3523:
3524: IF p_rev_component_rec.quantity_related IS NOT NULL AND
3525: p_rev_component_rec.quantity_related NOT IN (1, 2)
3526: THEN
3527: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3528: THEN
3529: Error_Handler.Add_Error_Token
3530: ( p_Message_Name => 'ENG_QTY_RELATED_INVALID'
3531: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

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

3546: WHEN OTHERS THEN
3547: --dbms_output.put_line('Some unknown error in Attribute Validation . . .' ||
3548: -- SQLERRM );
3549:
3550: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3551: THEN
3552: Error_Handler.Add_Error_Token
3553: ( p_Message_Name => NULL
3554: , p_Message_Text => 'Error in Rev Comp Attr. Validation '

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

3597:
3598: --
3599: -- if not exception is raised then record is deleted. so raise an error.
3600: --
3601: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3602: THEN
3603: Error_Handler.Add_Error_Token
3604: ( p_Message_Name => 'ENG_COMP_CANCELLED'
3605: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl