DBA Data[Home] [Help]

APPS.EGO_ICC_STRUCTURE_PVT dependencies on FND_CONST

Line 1639: x_error_msg := substr(x_error_msg||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1635: fnd_message.set_name('EGO','EGO_INHERIT_COMP_OVERLAP');
1636: fnd_message.set_token('COMPONENT_ITEM_NAME', G_COMP_ITEM_NAME);
1637: fnd_message.set_token('ALTCODE', p_alt_desg);
1638: fnd_message.set_token('EFFECTIVE_FROM', G_EFF_FROM);
1639: x_error_msg := substr(x_error_msg||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1640: --return l_count;
1641: end if;
1642:
1643: end loop;

Line 1847: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1843: for component in get_all_icc_components(l_catalog_group_id,v_item_revisions_tbl(rev_count).start_date) loop
1844: If(component.component_item_id = p_inventory_item_id) then
1845: x_Return_Status := 1;
1846: fnd_message.set_name('EGO','EGO_ASSY_AS_INH_COMP');
1847: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1848: --Return;
1849: End If;
1850: l_stmt_no := 140;
1851: select concatenated_segments into G_COMP_ITEM_NAME

Line 1862: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1858: fnd_message.set_name('EGO','EGO_INHERIT_COMP_OVERLAP');
1859: fnd_message.set_token('COMPONENT_ITEM_NAME', G_COMP_ITEM_NAME);
1860: fnd_message.set_token('ALTCODE', p_alt_desg);
1861: fnd_message.set_token('EFFECTIVE_FROM', v_item_revisions_tbl(rev_count).revision);
1862: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1863: --Return;
1864: end if;
1865: l_stmt_no := 160;
1866: -- Added for Bom Item type validation for inherited components.

Line 1902: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1898: l_stmt_no := 170;
1899: fnd_message.set_name('EGO','EGO_INHERIT_COMP_ITEMTYPE');
1900: fnd_message.set_token('COMPONENT_ITEM_NAME', G_COMP_ITEM_NAME);
1901: fnd_message.set_token('ALTCODE', p_alt_desg);
1902: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1903: --Return;
1904: end if;
1905: l_stmt_no := 180;
1906: if (component.component_yield_factor <> 1 and l_assy_bom_item_type = 3) then

Line 1910: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1906: if (component.component_yield_factor <> 1 and l_assy_bom_item_type = 3) then
1907: fnd_message.set_name('BOM','BOM_COMP_YIELD_NOT_ONE');
1908: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
1909: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
1910: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1911: x_Return_Status := 1;
1912: end if;
1913: l_stmt_no := 190;
1914: if l_assy_pick_components_flag = 'Y' and component.basis_type = 2 then

Line 1916: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1912: end if;
1913: l_stmt_no := 190;
1914: if l_assy_pick_components_flag = 'Y' and component.basis_type = 2 then
1915: fnd_message.set_name('BOM','BOM_LOT_BASED_PTO');
1916: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1917: x_Return_Status := 1;
1918: end if;
1919: l_stmt_no := 200;
1920: IF component.PLANNING_FACTOR <> 100 THEN

Line 1925: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1921: IF l_assy_bom_item_type = 4 THEN
1922: fnd_message.set_name('BOM','BOM_NOT_A_PLANNING_PARENT');
1923: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
1924: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
1925: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1926: x_Return_Status := 1;
1927: ELSIF ( l_assy_bom_item_type IN (1,2) AND component.OPTIONAL <> 1 AND
1928: component.ato_forecast_control <> 2 ) THEN
1929: fnd_message.set_name('BOM','BOM_COMP_MODEL_OC_OPTIONAL');

Line 1931: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1927: ELSIF ( l_assy_bom_item_type IN (1,2) AND component.OPTIONAL <> 1 AND
1928: component.ato_forecast_control <> 2 ) THEN
1929: fnd_message.set_name('BOM','BOM_COMP_MODEL_OC_OPTIONAL');
1930: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
1931: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1932: x_Return_Status := 1;
1933: ELSIF ( l_assy_bom_item_type IN (1,2) AND ( component.OPTIONAL = 1 AND
1934: component.ato_forecast_control <> 2 )) THEN
1935: fnd_message.set_name('BOM','BOM_COMP_OPTIONAL_ATO_FORECAST');

Line 1937: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1933: ELSIF ( l_assy_bom_item_type IN (1,2) AND ( component.OPTIONAL = 1 AND
1934: component.ato_forecast_control <> 2 )) THEN
1935: fnd_message.set_name('BOM','BOM_COMP_OPTIONAL_ATO_FORECAST');
1936: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
1937: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1938: x_Return_Status := 1;
1939: END IF;
1940: END IF;
1941: l_stmt_no := 210;

Line 1947: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1943: component.replenish_to_order_flag = 'Y' AND component.bom_item_type = 4 AND
1944: NVL(component.base_item_id,0) = 0 AND component.OPTIONAL = 2 ) THEN
1945: fnd_message.set_name('BOM','BOM_COMP_OPTIONAL');
1946: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
1947: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1948: x_Return_Status := 1;
1949: ELSIF ( l_assy_bom_item_type IN (3,4) AND component.OPTIONAL = 1 ) THEN
1950: fnd_message.set_name('BOM','BOM_COMP_NOT_OPTIONAL');
1951: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

Line 1951: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1947: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1948: x_Return_Status := 1;
1949: ELSIF ( l_assy_bom_item_type IN (3,4) AND component.OPTIONAL = 1 ) THEN
1950: fnd_message.set_name('BOM','BOM_COMP_NOT_OPTIONAL');
1951: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1952: x_Return_Status := 1;
1953: END IF;
1954: l_stmt_no := 220;
1955: IF component.required_for_revenue = 1 AND component.required_to_ship = 2 AND l_assy_atp_comp_flag = 'Y' THEN

Line 1959: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1955: IF component.required_for_revenue = 1 AND component.required_to_ship = 2 AND l_assy_atp_comp_flag = 'Y' THEN
1956: fnd_message.set_name('BOM','BOM_COMP_REQ_FOR_REV_INVALID');
1957: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
1958: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
1959: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1960: x_Return_Status := 1;
1961: ELSIF component.required_to_ship = 1 AND component.required_for_revenue = 2 AND l_assy_atp_comp_flag = 'Y' THEN
1962: fnd_message.set_name('BOM','BOM_COMP_REQ_TO_SHIP_INVALID');
1963: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);

Line 1965: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1961: ELSIF component.required_to_ship = 1 AND component.required_for_revenue = 2 AND l_assy_atp_comp_flag = 'Y' THEN
1962: fnd_message.set_name('BOM','BOM_COMP_REQ_TO_SHIP_INVALID');
1963: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
1964: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
1965: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1966: x_Return_Status := 1;
1967: ELSIF component.required_to_ship = 1 AND component.required_for_revenue = 1 AND l_assy_atp_comp_flag = 'Y' THEN
1968: fnd_message.set_name('BOM','BOM_COMP_REQ_TO_SHIP_INVALID');
1969: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);

Line 1971: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1967: ELSIF component.required_to_ship = 1 AND component.required_for_revenue = 1 AND l_assy_atp_comp_flag = 'Y' THEN
1968: fnd_message.set_name('BOM','BOM_COMP_REQ_TO_SHIP_INVALID');
1969: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
1970: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
1971: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1972: fnd_message.set_name('BOM','BOM_COMP_REQ_FOR_REV_INVALID');
1973: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
1974: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
1975: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

Line 1975: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

1971: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1972: fnd_message.set_name('BOM','BOM_COMP_REQ_FOR_REV_INVALID');
1973: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
1974: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
1975: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
1976: x_Return_Status := 1;
1977: END IF;
1978: l_stmt_no := 230;
1979: v_icc_comp_tbl(component.component_item_id).bill_sequence_id := component.bill_sequence_id;

Line 2457: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2453: for component in get_all_icc_components(l_catalog_group_id,l_catalog_str_type_id,G_ALTCODE) loop
2454: If(component.component_item_id = p_inventory_item_id) then
2455: x_Return_Status := 1;
2456: fnd_message.set_name('EGO','EGO_ASSY_AS_INH_COMP');
2457: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2458: --Return;
2459: End If;
2460: l_stmt_no := 130;
2461: select concatenated_segments into G_COMP_ITEM_NAME

Line 2471: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2467: fnd_message.set_name('EGO','EGO_INHERIT_COMP_OVERLAP');
2468: fnd_message.set_token('COMPONENT_ITEM_NAME', G_COMP_ITEM_NAME);
2469: fnd_message.set_token('ALTCODE', G_ALTCODE);
2470: fnd_message.set_token('EFFECTIVE_FROM', v_item_revisions_tbl(v_rev_index(p_revision_id)).revision);
2471: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2472: end if;
2473: l_stmt_no := 150;
2474: -- Added for Bom Item type validation for inherited components.
2475: if (

Line 2509: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2505: x_Return_Status := 1;
2506: fnd_message.set_name('EGO','EGO_INHERIT_COMP_ITEMTYPE');
2507: fnd_message.set_token('COMPONENT_ITEM_NAME', G_COMP_ITEM_NAME);
2508: fnd_message.set_token('ALTCODE', G_ALTCODE);
2509: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2510: --Return;
2511: end if;
2512: l_stmt_no := 160;
2513: if (component.component_yield_factor <> 1 and l_assy_bom_item_type = 3) then

Line 2517: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2513: if (component.component_yield_factor <> 1 and l_assy_bom_item_type = 3) then
2514: fnd_message.set_name('BOM','BOM_COMP_YIELD_NOT_ONE');
2515: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
2516: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
2517: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2518: x_Return_Status := 1;
2519: end if;
2520: l_stmt_no := 170;
2521: if l_assy_pick_components_flag = 'Y' and component.basis_type = 2 then

Line 2523: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2519: end if;
2520: l_stmt_no := 170;
2521: if l_assy_pick_components_flag = 'Y' and component.basis_type = 2 then
2522: fnd_message.set_name('BOM','BOM_LOT_BASED_PTO');
2523: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2524: x_Return_Status := 1;
2525: end if;
2526: l_stmt_no := 180;
2527: IF component.PLANNING_FACTOR <> 100 THEN

Line 2532: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2528: IF l_assy_bom_item_type = 4 THEN
2529: fnd_message.set_name('BOM','BOM_NOT_A_PLANNING_PARENT');
2530: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
2531: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
2532: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2533: x_Return_Status := 1;
2534: ELSIF ( l_assy_bom_item_type IN (1,2) AND component.OPTIONAL <> 1 AND
2535: component.ato_forecast_control <> 2 ) THEN
2536: fnd_message.set_name('BOM','BOM_COMP_MODEL_OC_OPTIONAL');

Line 2538: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2534: ELSIF ( l_assy_bom_item_type IN (1,2) AND component.OPTIONAL <> 1 AND
2535: component.ato_forecast_control <> 2 ) THEN
2536: fnd_message.set_name('BOM','BOM_COMP_MODEL_OC_OPTIONAL');
2537: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
2538: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2539: x_Return_Status := 1;
2540: ELSIF ( l_assy_bom_item_type IN (1,2) AND ( component.OPTIONAL = 1 AND
2541: component.ato_forecast_control <> 2 )) THEN
2542: fnd_message.set_name('BOM','BOM_COMP_OPTIONAL_ATO_FORECAST');

Line 2544: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2540: ELSIF ( l_assy_bom_item_type IN (1,2) AND ( component.OPTIONAL = 1 AND
2541: component.ato_forecast_control <> 2 )) THEN
2542: fnd_message.set_name('BOM','BOM_COMP_OPTIONAL_ATO_FORECAST');
2543: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
2544: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2545: x_Return_Status := 1;
2546: END IF;
2547: END IF;
2548: l_stmt_no := 190;

Line 2554: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2550: component.replenish_to_order_flag = 'Y' AND component.bom_item_type = 4 AND
2551: NVL(component.base_item_id,0) = 0 AND component.OPTIONAL = 2 ) THEN
2552: fnd_message.set_name('BOM','BOM_COMP_OPTIONAL');
2553: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
2554: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2555: x_Return_Status := 1;
2556: ELSIF ( l_assy_bom_item_type IN (3,4) AND component.OPTIONAL = 1 ) THEN
2557: fnd_message.set_name('BOM','BOM_COMP_NOT_OPTIONAL');
2558: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

Line 2558: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2554: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2555: x_Return_Status := 1;
2556: ELSIF ( l_assy_bom_item_type IN (3,4) AND component.OPTIONAL = 1 ) THEN
2557: fnd_message.set_name('BOM','BOM_COMP_NOT_OPTIONAL');
2558: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2559: x_Return_Status := 1;
2560: END IF;
2561: l_stmt_no := 200;
2562: IF component.required_for_revenue = 1 AND component.required_to_ship = 2 AND l_assy_atp_comp_flag = 'Y' THEN

Line 2566: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2562: IF component.required_for_revenue = 1 AND component.required_to_ship = 2 AND l_assy_atp_comp_flag = 'Y' THEN
2563: fnd_message.set_name('BOM','BOM_COMP_REQ_FOR_REV_INVALID');
2564: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
2565: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
2566: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2567: x_Return_Status := 1;
2568: ELSIF component.required_to_ship = 1 AND component.required_for_revenue = 2 AND l_assy_atp_comp_flag = 'Y' THEN
2569: fnd_message.set_name('BOM','BOM_COMP_REQ_TO_SHIP_INVALID');
2570: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);

Line 2572: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2568: ELSIF component.required_to_ship = 1 AND component.required_for_revenue = 2 AND l_assy_atp_comp_flag = 'Y' THEN
2569: fnd_message.set_name('BOM','BOM_COMP_REQ_TO_SHIP_INVALID');
2570: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
2571: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
2572: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2573: x_Return_Status := 1;
2574: ELSIF component.required_to_ship = 1 AND component.required_for_revenue = 1 AND l_assy_atp_comp_flag = 'Y' THEN
2575: fnd_message.set_name('BOM','BOM_COMP_REQ_TO_SHIP_INVALID');
2576: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);

Line 2578: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2574: ELSIF component.required_to_ship = 1 AND component.required_for_revenue = 1 AND l_assy_atp_comp_flag = 'Y' THEN
2575: fnd_message.set_name('BOM','BOM_COMP_REQ_TO_SHIP_INVALID');
2576: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
2577: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
2578: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2579: fnd_message.set_name('BOM','BOM_COMP_REQ_FOR_REV_INVALID');
2580: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
2581: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
2582: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

Line 2582: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;

2578: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2579: fnd_message.set_name('BOM','BOM_COMP_REQ_FOR_REV_INVALID');
2580: fnd_message.set_token('REVISED_COMPONENT_NAME', G_COMP_ITEM_NAME);
2581: fnd_message.set_token('REVISED_ITEM_NAME', G_ASSY_ITEM_NAME);
2582: x_Error_Message := substr(x_Error_Message||FND_CONST.NEWLINE||fnd_message.get,1,2000) ;
2583: x_Return_Status := 1;
2584: END IF;
2585: l_stmt_no := 210;
2586: v_icc_comp_tbl(component.component_item_id).bill_sequence_id := component.bill_sequence_id;