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.BOM_BO_PUB dependencies on ERROR_HANDLER

Line 876: Error_Handler.write_debug('Substitute comps check for same BOM ' ||

872: BEGIN
873: record_count := p_bom_sub_component_tbl.COUNT;
874:
875: if Bom_Globals.Get_Debug = 'Y' THEN
876: Error_Handler.write_debug('Substitute comps check for same BOM ' ||
877: p_assembly_item_name ||
878: ' org ' ||
879: p_organization_code || ' processing records ' || p_bom_sub_component_tbl.COUNT);
880: end if;

Line 909: Error_Handler.write_debug('Component Operations check for same BOM ' ||

905: BEGIN
906: record_count := p_bom_comp_ops_tbl.COUNT;
907:
908: if Bom_Globals.Get_Debug = 'Y' THEN
909: Error_Handler.write_debug('Component Operations check for same BOM ' ||
910: p_assembly_item_name ||
911: ' org ' ||
912: p_organization_code || ' processing records ' || record_count);
913: end if;

Line 1313: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1309: IS
1310: G_EXC_SEV_QUIT_OBJECT EXCEPTION;
1311: G_EXC_UNEXP_SKIP_OBJECT EXCEPTION;
1312:
1313: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1314: l_other_message VARCHAR2(50);
1315: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1316: l_err_text VARCHAR2(2000);
1317: l_return_status VARCHAR2(1);

Line 1315: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1311: G_EXC_UNEXP_SKIP_OBJECT EXCEPTION;
1312:
1313: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1314: l_other_message VARCHAR2(50);
1315: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1316: l_err_text VARCHAR2(2000);
1317: l_return_status VARCHAR2(1);
1318:
1319: l_assembly_item_name VARCHAR2(240);

Line 1344: Error_Handler.Initialize;

1340: -- Init Message List parameter
1341: --
1342: IF p_init_msg_list
1343: THEN
1344: Error_Handler.Initialize;
1345: END IF;
1346:
1347:
1348: IF l_debug_flag = 'Y'

Line 1357: Error_Handler.Add_Error_Token

1353: THEN
1354: -- If debug is Y then out dir must be
1355: -- specified
1356:
1357: Error_Handler.Add_Error_Token
1358: ( p_Message_text =>
1359: 'Debug is set to Y so an output directory' ||
1360: ' must be specified. Debug will be turned' ||
1361: ' off since no directory is specified'

Line 1367: Error_Handler.Log_Error

1363: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1364: , p_Token_Tbl => l_token_tbl
1365: );
1366:
1367: Error_Handler.Log_Error
1368: ( p_bom_header_rec => p_bom_header_rec
1369: , p_bom_revision_tbl => p_bom_revision_tbl
1370: , p_bom_component_tbl => p_bom_component_tbl
1371: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl

Line 1375: , p_error_level => Error_Handler.G_BO_LEVEL

1371: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl
1372: , p_bom_sub_component_tbl => p_bom_sub_component_tbl
1373: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1374: , p_error_status => 'W'
1375: , p_error_level => Error_Handler.G_BO_LEVEL
1376: , x_bom_header_rec => l_bom_header_rec
1377: , x_bom_revision_tbl => l_bom_revision_tbl
1378: , x_bom_component_tbl => l_bom_component_tbl
1379: , x_bom_ref_designator_tbl => l_bom_ref_designator_tbl

Line 1390: Error_Handler.Add_Error_Token

1386: IF trim(p_debug_filename) IS NULL OR
1387: trim(p_debug_filename) = ''
1388: THEN
1389:
1390: Error_Handler.Add_Error_Token
1391: ( p_Message_text =>
1392: 'Debug is set to Y so an output filename' ||
1393: ' must be specified. Debug will be turned' ||
1394: ' off since no filename is specified'

Line 1400: Error_Handler.Log_Error

1396: , x_Mesg_Token_Tbl => l_mesg_token_tbl
1397: , p_Token_Tbl => l_token_tbl
1398: );
1399:
1400: Error_Handler.Log_Error
1401: ( p_bom_header_rec => p_bom_header_rec
1402: , p_bom_revision_tbl => p_bom_revision_tbl
1403: , p_bom_component_tbl => p_bom_component_tbl
1404: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl

Line 1408: , p_error_level => Error_Handler.G_BO_LEVEL

1404: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl
1405: , p_bom_sub_component_tbl => p_bom_sub_component_tbl
1406: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1407: , p_error_status => 'W'
1408: , p_error_level => Error_Handler.G_BO_LEVEL
1409: , x_bom_header_rec => l_bom_header_rec
1410: , x_bom_revision_tbl => l_bom_revision_tbl
1411: , x_bom_component_tbl => l_bom_component_tbl
1412: , x_bom_ref_designator_tbl => l_bom_ref_designator_tbl

Line 1423: Error_Handler.Open_Debug_Session

1419: BOM_Globals.Set_Debug(l_debug_flag);
1420:
1421: IF l_debug_flag = 'Y'
1422: THEN
1423: Error_Handler.Open_Debug_Session
1424: ( p_debug_filename => p_debug_filename
1425: , p_output_dir => p_output_dir
1426: , x_return_status => l_return_status
1427: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1439: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('The BO as passed '); end if;

1435: END IF;
1436: END IF;
1437:
1438:
1439: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('The BO as passed '); end if;
1440: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Header Rec: ' || p_bom_header_rec.assembly_item_name); end if;
1441: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Num of Components: ' || p_bom_component_tbl.COUNT); end if;
1442: IF (p_bom_component_tbl.COUNT > 0) THEN
1443: IF bom_globals.get_debug = 'Y' then

Line 1440: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Header Rec: ' || p_bom_header_rec.assembly_item_name); end if;

1436: END IF;
1437:
1438:
1439: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('The BO as passed '); end if;
1440: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Header Rec: ' || p_bom_header_rec.assembly_item_name); end if;
1441: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Num of Components: ' || p_bom_component_tbl.COUNT); end if;
1442: IF (p_bom_component_tbl.COUNT > 0) THEN
1443: IF bom_globals.get_debug = 'Y' then
1444: Error_Handler.Write_Debug('Assembly key in Component: ' || p_bom_component_tbl(1).assembly_item_name);

Line 1441: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Num of Components: ' || p_bom_component_tbl.COUNT); end if;

1437:
1438:
1439: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('The BO as passed '); end if;
1440: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Header Rec: ' || p_bom_header_rec.assembly_item_name); end if;
1441: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Num of Components: ' || p_bom_component_tbl.COUNT); end if;
1442: IF (p_bom_component_tbl.COUNT > 0) THEN
1443: IF bom_globals.get_debug = 'Y' then
1444: Error_Handler.Write_Debug('Assembly key in Component: ' || p_bom_component_tbl(1).assembly_item_name);
1445: END IF;

Line 1444: Error_Handler.Write_Debug('Assembly key in Component: ' || p_bom_component_tbl(1).assembly_item_name);

1440: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Header Rec: ' || p_bom_header_rec.assembly_item_name); end if;
1441: IF bom_globals.get_debug = 'Y' THEN error_handler.write_debug('Num of Components: ' || p_bom_component_tbl.COUNT); end if;
1442: IF (p_bom_component_tbl.COUNT > 0) THEN
1443: IF bom_globals.get_debug = 'Y' then
1444: Error_Handler.Write_Debug('Assembly key in Component: ' || p_bom_component_tbl(1).assembly_item_name);
1445: END IF;
1446: end if;
1447:
1448: IF bom_globals.get_debug = 'Y' then error_handler.write_debug('Num of Substitute: ' || p_bom_sub_component_tbl.COUNT); END IF;

Line 1448: IF bom_globals.get_debug = 'Y' then error_handler.write_debug('Num of Substitute: ' || p_bom_sub_component_tbl.COUNT); END IF;

1444: Error_Handler.Write_Debug('Assembly key in Component: ' || p_bom_component_tbl(1).assembly_item_name);
1445: END IF;
1446: end if;
1447:
1448: IF bom_globals.get_debug = 'Y' then error_handler.write_debug('Num of Substitute: ' || p_bom_sub_component_tbl.COUNT); END IF;
1449: IF bom_globals.get_debug = 'Y' then error_handler.write_debug('Num of Ref. Desgs: ' || p_bom_ref_designator_tbl.COUNT); END IF;
1450:
1451: --
1452: -- Verify if all the entity record(s) belong to the same

Line 1449: IF bom_globals.get_debug = 'Y' then error_handler.write_debug('Num of Ref. Desgs: ' || p_bom_ref_designator_tbl.COUNT); END IF;

1445: END IF;
1446: end if;
1447:
1448: IF bom_globals.get_debug = 'Y' then error_handler.write_debug('Num of Substitute: ' || p_bom_sub_component_tbl.COUNT); END IF;
1449: IF bom_globals.get_debug = 'Y' then error_handler.write_debug('Num of Ref. Desgs: ' || p_bom_ref_designator_tbl.COUNT); END IF;
1450:
1451: --
1452: -- Verify if all the entity record(s) belong to the same
1453: -- business object

Line 1462: error_handler.write_debug('Substitute Component: ' || p_bom_sub_component_tbl(xx).substitute_component_name || ' Assembly ' || p_bom_sub_component_tbl(xx).assembly_item_name

1458: if bom_globals.get_debug = 'Y'
1459: then
1460: for xx in 1..p_bom_sub_component_tbl.COUNT
1461: loop
1462: error_handler.write_debug('Substitute Component: ' || p_bom_sub_component_tbl(xx).substitute_component_name || ' Assembly ' || p_bom_sub_component_tbl(xx).assembly_item_name
1463: || ' Organization ' || p_bom_sub_component_tbl(xx).organization_code);
1464:
1465: end loop;
1466: end if;

Line 1594: -- Call Error Handler

1590: Bom_Globals.Set_Eco_Name( p_eco_name => NULL);
1591:
1592: IF l_return_status <> 'S'
1593: THEN
1594: -- Call Error Handler
1595:
1596: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
1597: l_token_tbl(1).token_value := l_assembly_item_name;
1598: l_token_tbl(2).token_name := 'ORGANIZATION_CODE';

Line 1601: Error_Handler.Log_Error

1597: l_token_tbl(1).token_value := l_assembly_item_name;
1598: l_token_tbl(2).token_name := 'ORGANIZATION_CODE';
1599: l_token_tbl(2).token_value := l_organization_code;
1600:
1601: Error_Handler.Log_Error
1602: ( p_error_status => l_return_status
1603: , p_error_scope => Error_Handler.G_SCOPE_ALL
1604: , p_error_level => Error_Handler.G_BO_LEVEL
1605: , p_other_message => 'BOM_ERROR_BUSINESS_OBJECT'

Line 1603: , p_error_scope => Error_Handler.G_SCOPE_ALL

1599: l_token_tbl(2).token_value := l_organization_code;
1600:
1601: Error_Handler.Log_Error
1602: ( p_error_status => l_return_status
1603: , p_error_scope => Error_Handler.G_SCOPE_ALL
1604: , p_error_level => Error_Handler.G_BO_LEVEL
1605: , p_other_message => 'BOM_ERROR_BUSINESS_OBJECT'
1606: , p_other_status => l_return_status
1607: , p_other_token_tbl => l_token_tbl

Line 1604: , p_error_level => Error_Handler.G_BO_LEVEL

1600:
1601: Error_Handler.Log_Error
1602: ( p_error_status => l_return_status
1603: , p_error_scope => Error_Handler.G_SCOPE_ALL
1604: , p_error_level => Error_Handler.G_BO_LEVEL
1605: , p_other_message => 'BOM_ERROR_BUSINESS_OBJECT'
1606: , p_other_status => l_return_status
1607: , p_other_token_tbl => l_token_tbl
1608: , x_bom_header_rec => l_bom_header_rec

Line 1617: x_msg_count := Error_Handler.Get_Message_Count;

1613: );
1614: END IF;
1615:
1616: x_return_status := l_return_status;
1617: x_msg_count := Error_Handler.Get_Message_Count;
1618:
1619: IF p_write_err_to_inttable = 'Y'
1620: THEN
1621: Error_Handler.Write_To_InterfaceTable;

Line 1621: Error_Handler.Write_To_InterfaceTable;

1617: x_msg_count := Error_Handler.Get_Message_Count;
1618:
1619: IF p_write_err_to_inttable = 'Y'
1620: THEN
1621: Error_Handler.Write_To_InterfaceTable;
1622: END IF;
1623:
1624: IF p_write_err_to_conclog = 'Y'
1625: THEN

Line 1626: Error_Handler.Write_To_ConcurrentLog;

1622: END IF;
1623:
1624: IF p_write_err_to_conclog = 'Y'
1625: THEN
1626: Error_Handler.Write_To_ConcurrentLog;
1627: END IF;
1628:
1629: IF Bom_Globals.Get_Debug = 'Y' AND p_write_err_to_debugfile = 'Y'
1630: THEN

Line 1631: Error_Handler.Write_To_DebugFile;

1627: END IF;
1628:
1629: IF Bom_Globals.Get_Debug = 'Y' AND p_write_err_to_debugfile = 'Y'
1630: THEN
1631: Error_Handler.Write_To_DebugFile;
1632: Error_Handler.Close_Debug_Session;
1633: END IF;
1634:
1635:

Line 1632: Error_Handler.Close_Debug_Session;

1628:
1629: IF Bom_Globals.Get_Debug = 'Y' AND p_write_err_to_debugfile = 'Y'
1630: THEN
1631: Error_Handler.Write_To_DebugFile;
1632: Error_Handler.Close_Debug_Session;
1633: END IF;
1634:
1635:
1636: EXCEPTION

Line 1639: -- Call Error Handler

1635:
1636: EXCEPTION
1637: WHEN G_EXC_SEV_QUIT_OBJECT THEN
1638:
1639: -- Call Error Handler
1640:
1641: Error_Handler.Log_Error
1642: ( p_bom_header_rec => p_bom_header_rec
1643: , p_bom_revision_tbl => p_bom_revision_tbl

Line 1641: Error_Handler.Log_Error

1637: WHEN G_EXC_SEV_QUIT_OBJECT THEN
1638:
1639: -- Call Error Handler
1640:
1641: Error_Handler.Log_Error
1642: ( p_bom_header_rec => p_bom_header_rec
1643: , p_bom_revision_tbl => p_bom_revision_tbl
1644: , p_bom_component_tbl => p_bom_component_tbl
1645: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl

Line 1647: , p_error_status => Error_Handler.G_STATUS_ERROR

1643: , p_bom_revision_tbl => p_bom_revision_tbl
1644: , p_bom_component_tbl => p_bom_component_tbl
1645: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl
1646: , p_bom_sub_component_tbl => p_bom_sub_component_tbl
1647: , p_error_status => Error_Handler.G_STATUS_ERROR
1648: , p_error_scope => Error_Handler.G_SCOPE_ALL
1649: , p_error_level => Error_Handler.G_BO_LEVEL
1650: , p_other_message => l_other_message
1651: , p_other_status => Error_Handler.G_STATUS_ERROR

Line 1648: , p_error_scope => Error_Handler.G_SCOPE_ALL

1644: , p_bom_component_tbl => p_bom_component_tbl
1645: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl
1646: , p_bom_sub_component_tbl => p_bom_sub_component_tbl
1647: , p_error_status => Error_Handler.G_STATUS_ERROR
1648: , p_error_scope => Error_Handler.G_SCOPE_ALL
1649: , p_error_level => Error_Handler.G_BO_LEVEL
1650: , p_other_message => l_other_message
1651: , p_other_status => Error_Handler.G_STATUS_ERROR
1652: , p_other_token_tbl => l_token_tbl

Line 1649: , p_error_level => Error_Handler.G_BO_LEVEL

1645: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl
1646: , p_bom_sub_component_tbl => p_bom_sub_component_tbl
1647: , p_error_status => Error_Handler.G_STATUS_ERROR
1648: , p_error_scope => Error_Handler.G_SCOPE_ALL
1649: , p_error_level => Error_Handler.G_BO_LEVEL
1650: , p_other_message => l_other_message
1651: , p_other_status => Error_Handler.G_STATUS_ERROR
1652: , p_other_token_tbl => l_token_tbl
1653: , x_bom_header_rec => l_bom_header_rec

Line 1651: , p_other_status => Error_Handler.G_STATUS_ERROR

1647: , p_error_status => Error_Handler.G_STATUS_ERROR
1648: , p_error_scope => Error_Handler.G_SCOPE_ALL
1649: , p_error_level => Error_Handler.G_BO_LEVEL
1650: , p_other_message => l_other_message
1651: , p_other_status => Error_Handler.G_STATUS_ERROR
1652: , p_other_token_tbl => l_token_tbl
1653: , x_bom_header_rec => l_bom_header_rec
1654: , x_bom_revision_tbl => l_bom_revision_tbl
1655: , x_bom_component_tbl => l_bom_component_tbl

Line 1660: x_return_status := Error_Handler.G_STATUS_ERROR;

1656: , x_bom_ref_designator_tbl => l_bom_ref_designator_tbl
1657: , x_bom_sub_component_tbl => l_bom_sub_component_tbl
1658: );
1659:
1660: x_return_status := Error_Handler.G_STATUS_ERROR;
1661: x_msg_count := Error_Handler.Get_Message_Count;
1662: IF Bom_Globals.Get_Debug = 'Y'
1663: THEN
1664: Error_Handler.Dump_Message_List;

Line 1661: x_msg_count := Error_Handler.Get_Message_Count;

1657: , x_bom_sub_component_tbl => l_bom_sub_component_tbl
1658: );
1659:
1660: x_return_status := Error_Handler.G_STATUS_ERROR;
1661: x_msg_count := Error_Handler.Get_Message_Count;
1662: IF Bom_Globals.Get_Debug = 'Y'
1663: THEN
1664: Error_Handler.Dump_Message_List;
1665: Error_Handler.Close_Debug_Session;

Line 1664: Error_Handler.Dump_Message_List;

1660: x_return_status := Error_Handler.G_STATUS_ERROR;
1661: x_msg_count := Error_Handler.Get_Message_Count;
1662: IF Bom_Globals.Get_Debug = 'Y'
1663: THEN
1664: Error_Handler.Dump_Message_List;
1665: Error_Handler.Close_Debug_Session;
1666: END IF;
1667:
1668: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN

Line 1665: Error_Handler.Close_Debug_Session;

1661: x_msg_count := Error_Handler.Get_Message_Count;
1662: IF Bom_Globals.Get_Debug = 'Y'
1663: THEN
1664: Error_Handler.Dump_Message_List;
1665: Error_Handler.Close_Debug_Session;
1666: END IF;
1667:
1668: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN
1669:

Line 1670: -- Call Error Handler

1666: END IF;
1667:
1668: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN
1669:
1670: -- Call Error Handler
1671:
1672: Error_Handler.Log_Error
1673: ( p_bom_header_rec => p_bom_header_rec
1674: , p_bom_revision_tbl => p_bom_revision_tbl

Line 1672: Error_Handler.Log_Error

1668: WHEN G_EXC_UNEXP_SKIP_OBJECT THEN
1669:
1670: -- Call Error Handler
1671:
1672: Error_Handler.Log_Error
1673: ( p_bom_header_rec => p_bom_header_rec
1674: , p_bom_revision_tbl => p_bom_revision_tbl
1675: , p_bom_component_tbl => p_bom_component_tbl
1676: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl

Line 1679: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED

1675: , p_bom_component_tbl => p_bom_component_tbl
1676: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl
1677: , p_bom_sub_component_tbl => p_bom_sub_component_tbl
1678: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1679: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1680: , p_error_level => Error_Handler.G_BO_LEVEL
1681: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1682: , p_other_message => l_other_message
1683: , p_other_token_tbl => l_token_tbl

Line 1680: , p_error_level => Error_Handler.G_BO_LEVEL

1676: , p_bom_ref_designator_tbl => p_bom_ref_designator_tbl
1677: , p_bom_sub_component_tbl => p_bom_sub_component_tbl
1678: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1679: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1680: , p_error_level => Error_Handler.G_BO_LEVEL
1681: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1682: , p_other_message => l_other_message
1683: , p_other_token_tbl => l_token_tbl
1684: , x_bom_header_rec => l_bom_header_rec

Line 1681: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED

1677: , p_bom_sub_component_tbl => p_bom_sub_component_tbl
1678: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1679: , p_error_status => Error_Handler.G_STATUS_UNEXPECTED
1680: , p_error_level => Error_Handler.G_BO_LEVEL
1681: , p_other_status => Error_Handler.G_STATUS_NOT_PICKED
1682: , p_other_message => l_other_message
1683: , p_other_token_tbl => l_token_tbl
1684: , x_bom_header_rec => l_bom_header_rec
1685: , x_bom_revision_tbl => l_bom_revision_tbl

Line 1691: x_return_status := Error_Handler.G_STATUS_UNEXPECTED;

1687: , x_bom_ref_designator_tbl => l_bom_ref_designator_tbl
1688: , x_bom_sub_component_tbl => l_bom_sub_component_tbl
1689: );
1690:
1691: x_return_status := Error_Handler.G_STATUS_UNEXPECTED;
1692: x_msg_count := Error_Handler.Get_Message_Count;
1693: IF Bom_Globals.Get_Debug = 'Y'
1694: THEN
1695: Error_Handler.Dump_Message_List;

Line 1692: x_msg_count := Error_Handler.Get_Message_Count;

1688: , x_bom_sub_component_tbl => l_bom_sub_component_tbl
1689: );
1690:
1691: x_return_status := Error_Handler.G_STATUS_UNEXPECTED;
1692: x_msg_count := Error_Handler.Get_Message_Count;
1693: IF Bom_Globals.Get_Debug = 'Y'
1694: THEN
1695: Error_Handler.Dump_Message_List;
1696: Error_Handler.Close_Debug_Session;

Line 1695: Error_Handler.Dump_Message_List;

1691: x_return_status := Error_Handler.G_STATUS_UNEXPECTED;
1692: x_msg_count := Error_Handler.Get_Message_Count;
1693: IF Bom_Globals.Get_Debug = 'Y'
1694: THEN
1695: Error_Handler.Dump_Message_List;
1696: Error_Handler.Close_Debug_Session;
1697: END IF;
1698:
1699: END Process_Bom;

Line 1696: Error_Handler.Close_Debug_Session;

1692: x_msg_count := Error_Handler.Get_Message_Count;
1693: IF Bom_Globals.Get_Debug = 'Y'
1694: THEN
1695: Error_Handler.Dump_Message_List;
1696: Error_Handler.Close_Debug_Session;
1697: END IF;
1698:
1699: END Process_Bom;
1700:

Line 3468: Error_Handler.Log_Error

3464: END LOOP;
3465: END IF;
3466: EXCEPTION
3467: WHEN no_header_record THEN
3468: Error_Handler.Log_Error
3469: (P_error_status => Error_Handler.G_STATUS_ERROR,
3470: P_error_scope => Error_Handler.G_SCOPE_ALL,
3471: P_error_level => Error_Handler.G_BO_LEVEL,
3472: P_other_message => l_other_message,

Line 3469: (P_error_status => Error_Handler.G_STATUS_ERROR,

3465: END IF;
3466: EXCEPTION
3467: WHEN no_header_record THEN
3468: Error_Handler.Log_Error
3469: (P_error_status => Error_Handler.G_STATUS_ERROR,
3470: P_error_scope => Error_Handler.G_SCOPE_ALL,
3471: P_error_level => Error_Handler.G_BO_LEVEL,
3472: P_other_message => l_other_message,
3473: P_other_status => Error_Handler.G_STATUS_ERROR,

Line 3470: P_error_scope => Error_Handler.G_SCOPE_ALL,

3466: EXCEPTION
3467: WHEN no_header_record THEN
3468: Error_Handler.Log_Error
3469: (P_error_status => Error_Handler.G_STATUS_ERROR,
3470: P_error_scope => Error_Handler.G_SCOPE_ALL,
3471: P_error_level => Error_Handler.G_BO_LEVEL,
3472: P_other_message => l_other_message,
3473: P_other_status => Error_Handler.G_STATUS_ERROR,
3474: X_bom_header_rec => l_bom_header_rec,

Line 3471: P_error_level => Error_Handler.G_BO_LEVEL,

3467: WHEN no_header_record THEN
3468: Error_Handler.Log_Error
3469: (P_error_status => Error_Handler.G_STATUS_ERROR,
3470: P_error_scope => Error_Handler.G_SCOPE_ALL,
3471: P_error_level => Error_Handler.G_BO_LEVEL,
3472: P_other_message => l_other_message,
3473: P_other_status => Error_Handler.G_STATUS_ERROR,
3474: X_bom_header_rec => l_bom_header_rec,
3475: X_bom_revision_tbl => l_bom_revision_tbl,

Line 3473: P_other_status => Error_Handler.G_STATUS_ERROR,

3469: (P_error_status => Error_Handler.G_STATUS_ERROR,
3470: P_error_scope => Error_Handler.G_SCOPE_ALL,
3471: P_error_level => Error_Handler.G_BO_LEVEL,
3472: P_other_message => l_other_message,
3473: P_other_status => Error_Handler.G_STATUS_ERROR,
3474: X_bom_header_rec => l_bom_header_rec,
3475: X_bom_revision_tbl => l_bom_revision_tbl,
3476: X_bom_component_tbl => l_bom_component_tbl,
3477: X_bom_ref_designator_tbl => l_bom_ref_designator_tbl,

Line 3479: X_return_status := Error_Handler.G_STATUS_ERROR;

3475: X_bom_revision_tbl => l_bom_revision_tbl,
3476: X_bom_component_tbl => l_bom_component_tbl,
3477: X_bom_ref_designator_tbl => l_bom_ref_designator_tbl,
3478: X_bom_sub_component_tbl => l_bom_sub_component_tbl);
3479: X_return_status := Error_Handler.G_STATUS_ERROR;
3480: X_msg_count := Error_Handler.Get_Message_Count;
3481: END;
3482:
3483:

Line 3480: X_msg_count := Error_Handler.Get_Message_Count;

3476: X_bom_component_tbl => l_bom_component_tbl,
3477: X_bom_ref_designator_tbl => l_bom_ref_designator_tbl,
3478: X_bom_sub_component_tbl => l_bom_sub_component_tbl);
3479: X_return_status := Error_Handler.G_STATUS_ERROR;
3480: X_msg_count := Error_Handler.Get_Message_Count;
3481: END;
3482:
3483:
3484: /*****************************************************************

Line 3575: error_handler.close_debug_session;

3571: , p_debug_filename => p_Debug_FileName
3572: );
3573: end if;
3574:
3575: error_handler.close_debug_session;
3576:
3577: if (p_Alternate_Bom_Code is NULL) then
3578: select decode(enable_unimplemented_boms,'Y',null, sysdate)
3579: into l_bom_header_rec.BOM_Implementation_Date

Line 3636: -- Call the Error handler

3632: , p_output_dir => p_Output_Dir
3633: , p_debug_filename => p_Alternate_Bom_Code || '-'||p_Debug_FileName
3634: );
3635:
3636: -- Call the Error handler
3637: if (l_msg_count > 0) then
3638: Error_Handler.Get_Message
3639: ( x_message_text => l_message_text
3640: , x_entity_index => l_entity_index

Line 3638: Error_Handler.Get_Message

3634: );
3635:
3636: -- Call the Error handler
3637: if (l_msg_count > 0) then
3638: Error_Handler.Get_Message
3639: ( x_message_text => l_message_text
3640: , x_entity_index => l_entity_index
3641: , x_entity_id => l_entity_id
3642: , x_message_type => l_message_type

Line 3697: l_Token_Tbl Error_Handler.Token_Tbl_Type;

3693: x_bom_comp_ops_tbl_out BOM_BO_PUB.Bom_Comp_ops_Tbl_Type;
3694:
3695: l_other_message VARCHAR2(50);
3696: l_compcount NUMBER;
3697: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3698: i NUMBER := 1;
3699:
3700: BEGIN
3701:

Line 3744: Error_Handler.Log_Error

3740: l_token_tbl(2).token_name := 'ORGANIZATION_CODE';
3741: l_token_tbl(2).token_value := l_bom_header_rec.organization_code ;
3742:
3743: x_return_status := 'E';
3744: Error_Handler.Log_Error
3745: ( p_error_status => x_return_status
3746: , p_error_scope => Error_Handler.G_SCOPE_ALL
3747: , p_error_level => Error_Handler.G_BO_LEVEL
3748: , p_other_message => 'BOM_ERROR_BUSINESS_OBJECT'

Line 3746: , p_error_scope => Error_Handler.G_SCOPE_ALL

3742:
3743: x_return_status := 'E';
3744: Error_Handler.Log_Error
3745: ( p_error_status => x_return_status
3746: , p_error_scope => Error_Handler.G_SCOPE_ALL
3747: , p_error_level => Error_Handler.G_BO_LEVEL
3748: , p_other_message => 'BOM_ERROR_BUSINESS_OBJECT'
3749: , p_other_status => x_return_status
3750: , p_other_token_tbl => l_token_tbl

Line 3747: , p_error_level => Error_Handler.G_BO_LEVEL

3743: x_return_status := 'E';
3744: Error_Handler.Log_Error
3745: ( p_error_status => x_return_status
3746: , p_error_scope => Error_Handler.G_SCOPE_ALL
3747: , p_error_level => Error_Handler.G_BO_LEVEL
3748: , p_other_message => 'BOM_ERROR_BUSINESS_OBJECT'
3749: , p_other_status => x_return_status
3750: , p_other_token_tbl => l_token_tbl
3751: , x_bom_header_rec => l_bom_header_rec

Line 3757: x_msg_count := Error_Handler.Get_Message_Count;

3753: , x_bom_component_tbl => l_bom_component_tbl
3754: , x_bom_ref_designator_tbl => x_bom_ref_designator_tbl_out
3755: , x_bom_sub_component_tbl => x_bom_sub_component_tbl_out
3756: );
3757: x_msg_count := Error_Handler.Get_Message_Count;
3758: IF bom_globals.get_debug = 'Y' then
3759: Error_Handler.Write_Debug('Cannot have transaction type of UPDATE for product family Bills');
3760: END IF;
3761: ELSE

Line 3759: Error_Handler.Write_Debug('Cannot have transaction type of UPDATE for product family Bills');

3755: , x_bom_sub_component_tbl => x_bom_sub_component_tbl_out
3756: );
3757: x_msg_count := Error_Handler.Get_Message_Count;
3758: IF bom_globals.get_debug = 'Y' then
3759: Error_Handler.Write_Debug('Cannot have transaction type of UPDATE for product family Bills');
3760: END IF;
3761: ELSE
3762: IF l_input_bomcomponents_tbl IS NOT NULL THEN
3763: l_compcount := l_input_bomcomponents_tbl.COUNT;