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

Line 144: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

140: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
141: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
142: x_rtg_return_status OUT NOCOPY VARCHAR2,
143: x_rtg_msg_count OUT NOCOPY NUMBER,
144: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
145: )
146:
147: IS
148: l_current_date CONSTANT DATE := sysdate;

Line 173: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

169: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
170: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
171: l_x_rtg_return_status VARCHAR2(1);
172: l_x_rtg_msg_count NUMBER;
173: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
174:
175: CURSOR wip_operation_cur (
176: p_organization_id IN NUMBER
177: , p_wip_entity_id IN NUMBER

Line 406: Error_Handler.initialize;

402:
403: -- 2 e) Call the Routing Business Object API
404: -- Only Call Routing Business Object API if operation tabel is not empty
405: IF l_operation_tbl.FIRST IS NOT NULL THEN
406: Error_Handler.initialize;
407: -- log call to Process_Rtg API
408: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_RTG_PUB.Process_Rtg INPUT Parameters >>>>>>>>>>>>>>>');
409: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_rtg_header_rec,
410: l_operation_tbl,

Line 431: Error_Handler.Get_Message_List(l_x_rtg_msg_list);

427: , x_msg_count => l_x_rtg_msg_count
428: );
429: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
430:
431: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
432:
433: -- log errors
434: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
435: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);

Line 436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);

432:
433: -- log errors
434: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
435: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
440: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');

Line 475: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

471: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
472: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
473: x_bom_return_status OUT NOCOPY VARCHAR2,
474: x_bom_msg_count OUT NOCOPY NUMBER,
475: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
476: )
477: IS
478: l_current_date CONSTANT DATE := sysdate;
479: l_effectivity_date CONSTANT DATE := l_current_date;

Line 493: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

489: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
490: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
491: l_x_bom_return_status VARCHAR2(1);
492: l_x_bom_msg_count NUMBER;
493: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
494: l_stock_enabled_flag varchar2(1);
495: l_list_price_per_unit number;
496: CURSOR wip_requirement_cur (
497: p_organization_id IN NUMBER,

Line 598: Error_Handler.initialize;

594:
595: -- Only call BOM Business Object API if Component Table is not empty
596: IF l_bom_component_tbl.FIRST IS NOT NULL THEN
597:
598: Error_Handler.initialize;
599: -- log call to Process_BOM API
600: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
601: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
602: l_bom_component_tbl);

Line 618: Error_Handler.Get_Message_List(l_x_bom_msg_list);

614: x_msg_count => l_x_bom_msg_count
615: );
616: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
617:
618: Error_Handler.Get_Message_List(l_x_bom_msg_list);
619:
620: -- log errors
621: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
622: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);

Line 623: Error_Handler.Get_Message_List(l_x_bom_msg_list);

619:
620: -- log errors
621: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
622: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');

Line 896: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,

892: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
893: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
894: x_rtg_return_status OUT NOCOPY VARCHAR2,
895: x_rtg_msg_count OUT NOCOPY NUMBER,
896: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
897:
898: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
899: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
900: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,

Line 905: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,

901: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
902: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
903: x_bom_return_status OUT NOCOPY VARCHAR2,
904: x_bom_msg_count OUT NOCOPY NUMBER,
905: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
906:
907: x_assoc_return_status OUT NOCOPY VARCHAR2,
908: x_assoc_msg_count OUT NOCOPY NUMBER,
909: x_assoc_msg_data OUT NOCOPY VARCHAR2,

Line 939: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

935: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
936: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
937: l_x_bom_return_status VARCHAR2(1);
938: l_x_bom_msg_count NUMBER;
939: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
940:
941: -- local variables for call the Routing Business Object API
942: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
943: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

Line 950: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

946: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
947: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
948: l_x_rtg_return_status VARCHAR2(1);
949: l_x_rtg_msg_count NUMBER;
950: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
951:
952: -- local variables for call Association Creation package
953: l_x_assoc_return_status VARCHAR2(1);
954: l_x_assoc_msg_count NUMBER;

Line 1378: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

1374: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1375: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1376: l_x_bom_return_status VARCHAR2(1);
1377: l_x_bom_msg_count NUMBER;
1378: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
1379:
1380: -- local variables for call the Routing Business Object API
1381: l_source_rtg_sequence_id NUMBER;
1382: l_target_rtg_sequence_id NUMBER;

Line 1394: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

1390: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1391: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1392: l_x_rtg_return_status VARCHAR2(1);
1393: l_x_rtg_msg_count NUMBER;
1394: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
1395:
1396: -- local variables for call Association Creation package
1397: l_x_assoc_return_status VARCHAR2(1);
1398: l_x_assoc_msg_count NUMBER;

Line 1590: Error_Handler.initialize;

1586: l_rtg_header_rec.Transaction_Type := l_create_txn_type;
1587: l_rtg_header_rec.Assembly_Item_Name := l_x_curr_item_rec.Item_Number;
1588: l_rtg_header_rec.Organization_Code := l_x_curr_item_rec.Organization_Code;
1589:
1590: Error_Handler.initialize;
1591: -- log call to Process_Rtg API
1592: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
1593: BOM_RTG_PUB.Process_Rtg(
1594: p_rtg_header_rec => l_rtg_header_rec

Line 1609: Error_Handler.Get_Message_List(l_x_rtg_msg_list);

1605:
1606: -- log errors
1607: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1609: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1610: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1611: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1612: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1613:

Line 1683: Error_Handler.initialize;

1679: l_bom_head_rec.Organization_Code := l_x_curr_item_rec.Organization_Code;
1680: l_bom_head_rec.Assembly_Type := 1;
1681:
1682: -- Create empty BOM header through BOM Business Object API
1683: Error_Handler.initialize;
1684: -- log call to Process_BOM API
1685: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
1686: BOM_BO_PUB.Process_BOM(
1687: p_bom_header_rec => l_bom_head_rec,

Line 1701: Error_Handler.Get_Message_List(l_x_bom_msg_list);

1697:
1698: -- log errors
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1701: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1702: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1703: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1704: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1705:

Line 1935: -- Routing and BOM common Error Handler

1931: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1932: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1933: l_x_bom_return_status VARCHAR2(1);
1934: l_x_bom_msg_count NUMBER;
1935: -- Routing and BOM common Error Handler
1936: l_x_bom_error_list Error_Handler.Error_Tbl_Type;
1937: l_x_bom_error_count INTEGER;
1938: l_bom_error_count INTEGER;
1939: l_index BINARY_INTEGER;

Line 1936: l_x_bom_error_list Error_Handler.Error_Tbl_Type;

1932: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1933: l_x_bom_return_status VARCHAR2(1);
1934: l_x_bom_msg_count NUMBER;
1935: -- Routing and BOM common Error Handler
1936: l_x_bom_error_list Error_Handler.Error_Tbl_Type;
1937: l_x_bom_error_count INTEGER;
1938: l_bom_error_count INTEGER;
1939: l_index BINARY_INTEGER;
1940: l_x_rtg_error_list Error_Handler.Error_Tbl_Type;

Line 1940: l_x_rtg_error_list Error_Handler.Error_Tbl_Type;

1936: l_x_bom_error_list Error_Handler.Error_Tbl_Type;
1937: l_x_bom_error_count INTEGER;
1938: l_bom_error_count INTEGER;
1939: l_index BINARY_INTEGER;
1940: l_x_rtg_error_list Error_Handler.Error_Tbl_Type;
1941: l_x_rtg_error_count INTEGER;
1942: -- Activity Association
1943: l_x_assoc_return_status VARCHAR2(1);
1944: l_x_assoc_msg_count NUMBER;

Line 2361: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

2357: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2358: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2359: x_bom_return_status OUT NOCOPY VARCHAR2,
2360: x_bom_msg_count OUT NOCOPY NUMBER,
2361: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
2362:
2363: )
2364: IS
2365: --l_current_date CONSTANT DATE := sysdate;

Line 2379: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

2375: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2376: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2377: l_x_bom_return_status VARCHAR2(1);
2378: l_x_bom_msg_count NUMBER;
2379: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
2380:
2381: begin
2382: -- l_bom_head_rec := NULL;
2383: l_bom_head_rec.Assembly_Item_Name := p_target_item_rec.Item_Number;

Line 2434: Error_Handler.Get_Message_List(l_x_bom_msg_list);

2430: x_bom_ref_designator_tbl := l_x_bom_ref_designator_tbl;
2431: x_bom_sub_component_tbl := l_x_bom_sub_component_tbl;
2432: x_bom_return_status := l_x_bom_return_status;
2433: x_bom_msg_count := l_x_bom_msg_count;
2434: Error_Handler.Get_Message_List(l_x_bom_msg_list);
2435: x_bom_msg_list := l_x_bom_msg_list;
2436: end create_bom_header;
2437:
2438: procedure create_bom_header_form(

Line 2452: x_bom_msg_list Error_Handler.Error_Tbl_Type;

2448: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2449: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2450: x_bom_return_status VARCHAR2(1);
2451: x_bom_msg_count NUMBER;
2452: x_bom_msg_list Error_Handler.Error_Tbl_Type;
2453:
2454: begin
2455: l_target_item_rec.item_number := p_inventory_item_name;
2456: l_target_item_rec.organization_code := p_organization_code;

Line 2625: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

2621: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2622: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2623: x_rtg_return_status OUT NOCOPY VARCHAR2,
2624: x_rtg_msg_count OUT NOCOPY NUMBER,
2625: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
2626: )
2627:
2628: IS
2629: --l_current_date CONSTANT DATE := sysdate;

Line 2647: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

2643: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2644: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2645: l_x_rtg_return_status VARCHAR2(1);
2646: l_x_rtg_msg_count NUMBER;
2647: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2648:
2649:
2650:
2651: BEGIN

Line 2660: Error_Handler.initialize;

2656: l_rtg_header_rec.Assembly_Item_Name := p_target_item_rec.Item_Number;
2657: l_rtg_header_rec.Organization_Code := p_target_item_rec.Organization_Code;
2658: l_rtg_header_rec.Transaction_Type := l_create_txn_type;
2659:
2660: Error_Handler.initialize;
2661: -- log call to Process_Rtg API
2662: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
2663: BOM_RTG_PUB.Process_Rtg(
2664: p_rtg_header_rec => l_rtg_header_rec

Line 2688: Error_Handler.Get_Message_List(l_x_rtg_msg_list);

2684: x_sub_resource_tbl := l_x_sub_resource_tbl;
2685: x_op_network_tbl := l_x_op_network_tbl;
2686: x_rtg_return_status := l_x_rtg_return_status;
2687: x_rtg_msg_count := l_x_rtg_msg_count;
2688: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
2689: x_rtg_msg_list := l_x_rtg_msg_list;
2690:
2691:
2692: END Create_Routing_Header;

Line 2716: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

2712: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2713: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2714: l_x_rtg_return_status VARCHAR2(1);
2715: l_x_rtg_msg_count NUMBER;
2716: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2717:
2718: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2719:
2720: begin