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: l_code varchar2(4); -- 13519051
175: l_st_op_id NUMBER; -- 13519051
176:
177: CURSOR wip_operation_cur (

Line 432: Error_Handler.initialize;

428:
429: -- 2 e) Call the Routing Business Object API
430: -- Only Call Routing Business Object API if operation tabel is not empty
431: IF l_operation_tbl.FIRST IS NOT NULL THEN
432: Error_Handler.initialize;
433: -- log call to Process_Rtg API
434: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_RTG_PUB.Process_Rtg INPUT Parameters >>>>>>>>>>>>>>>');
435: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_rtg_header_rec,
436: l_operation_tbl,

Line 457: Error_Handler.Get_Message_List(l_x_rtg_msg_list);

453: , x_msg_count => l_x_rtg_msg_count
454: );
455: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
456:
457: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
458:
459: -- log errors
460: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
461: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);

Line 462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);

458:
459: -- log errors
460: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
461: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');

Line 501: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

497: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
498: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
499: x_bom_return_status OUT NOCOPY VARCHAR2,
500: x_bom_msg_count OUT NOCOPY NUMBER,
501: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
502: )
503: IS
504: l_current_date CONSTANT DATE := sysdate;
505: l_effectivity_date CONSTANT DATE := l_current_date;

Line 519: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

515: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
516: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
517: l_x_bom_return_status VARCHAR2(1);
518: l_x_bom_msg_count NUMBER;
519: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
520: l_stock_enabled_flag varchar2(1);
521: l_list_price_per_unit number;
522: CURSOR wip_requirement_cur (
523: p_organization_id IN NUMBER,

Line 624: Error_Handler.initialize;

620:
621: -- Only call BOM Business Object API if Component Table is not empty
622: IF l_bom_component_tbl.FIRST IS NOT NULL THEN
623:
624: Error_Handler.initialize;
625: -- log call to Process_BOM API
626: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
627: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
628: l_bom_component_tbl);

Line 644: Error_Handler.Get_Message_List(l_x_bom_msg_list);

640: x_msg_count => l_x_bom_msg_count
641: );
642: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
643:
644: Error_Handler.Get_Message_List(l_x_bom_msg_list);
645:
646: -- log errors
647: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
648: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);

Line 649: Error_Handler.Get_Message_List(l_x_bom_msg_list);

645:
646: -- log errors
647: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
648: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
653: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');

Line 927: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,

923: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
924: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
925: x_rtg_return_status OUT NOCOPY VARCHAR2,
926: x_rtg_msg_count OUT NOCOPY NUMBER,
927: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
928:
929: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
930: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
931: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,

Line 936: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,

932: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
933: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
934: x_bom_return_status OUT NOCOPY VARCHAR2,
935: x_bom_msg_count OUT NOCOPY NUMBER,
936: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
937:
938: x_assoc_return_status OUT NOCOPY VARCHAR2,
939: x_assoc_msg_count OUT NOCOPY NUMBER,
940: x_assoc_msg_data OUT NOCOPY VARCHAR2,

Line 970: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

966: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
967: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
968: l_x_bom_return_status VARCHAR2(1);
969: l_x_bom_msg_count NUMBER;
970: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
971:
972: -- local variables for call the Routing Business Object API
973: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
974: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

Line 981: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

977: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
978: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
979: l_x_rtg_return_status VARCHAR2(1);
980: l_x_rtg_msg_count NUMBER;
981: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
982:
983: -- local variables for call Association Creation package
984: l_x_assoc_return_status VARCHAR2(1);
985: l_x_assoc_msg_count NUMBER;

Line 1409: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

1405: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1406: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1407: l_x_bom_return_status VARCHAR2(1);
1408: l_x_bom_msg_count NUMBER;
1409: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
1410:
1411: -- local variables for call the Routing Business Object API
1412: l_source_rtg_sequence_id NUMBER;
1413: l_target_rtg_sequence_id NUMBER;

Line 1425: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

1421: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1422: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1423: l_x_rtg_return_status VARCHAR2(1);
1424: l_x_rtg_msg_count NUMBER;
1425: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
1426:
1427: -- local variables for call Association Creation package
1428: l_x_assoc_return_status VARCHAR2(1);
1429: l_x_assoc_msg_count NUMBER;

Line 1621: Error_Handler.initialize;

1617: l_rtg_header_rec.Transaction_Type := l_create_txn_type;
1618: l_rtg_header_rec.Assembly_Item_Name := l_x_curr_item_rec.Item_Number;
1619: l_rtg_header_rec.Organization_Code := l_x_curr_item_rec.Organization_Code;
1620:
1621: Error_Handler.initialize;
1622: -- log call to Process_Rtg API
1623: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
1624: BOM_RTG_PUB.Process_Rtg(
1625: p_rtg_header_rec => l_rtg_header_rec

Line 1640: Error_Handler.Get_Message_List(l_x_rtg_msg_list);

1636:
1637: -- log errors
1638: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1640: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1641: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1642: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1643: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1644:

Line 1714: Error_Handler.initialize;

1710: l_bom_head_rec.Organization_Code := l_x_curr_item_rec.Organization_Code;
1711: l_bom_head_rec.Assembly_Type := 1;
1712:
1713: -- Create empty BOM header through BOM Business Object API
1714: Error_Handler.initialize;
1715: -- log call to Process_BOM API
1716: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
1717: BOM_BO_PUB.Process_BOM(
1718: p_bom_header_rec => l_bom_head_rec,

Line 1732: Error_Handler.Get_Message_List(l_x_bom_msg_list);

1728:
1729: -- log errors
1730: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1732: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1733: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1734: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1735: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1736:

Line 1966: -- Routing and BOM common Error Handler

1962: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1963: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1964: l_x_bom_return_status VARCHAR2(1);
1965: l_x_bom_msg_count NUMBER;
1966: -- Routing and BOM common Error Handler
1967: l_x_bom_error_list Error_Handler.Error_Tbl_Type;
1968: l_x_bom_error_count INTEGER;
1969: l_bom_error_count INTEGER;
1970: l_index BINARY_INTEGER;

Line 1967: l_x_bom_error_list Error_Handler.Error_Tbl_Type;

1963: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1964: l_x_bom_return_status VARCHAR2(1);
1965: l_x_bom_msg_count NUMBER;
1966: -- Routing and BOM common Error Handler
1967: l_x_bom_error_list Error_Handler.Error_Tbl_Type;
1968: l_x_bom_error_count INTEGER;
1969: l_bom_error_count INTEGER;
1970: l_index BINARY_INTEGER;
1971: l_x_rtg_error_list Error_Handler.Error_Tbl_Type;

Line 1971: l_x_rtg_error_list Error_Handler.Error_Tbl_Type;

1967: l_x_bom_error_list Error_Handler.Error_Tbl_Type;
1968: l_x_bom_error_count INTEGER;
1969: l_bom_error_count INTEGER;
1970: l_index BINARY_INTEGER;
1971: l_x_rtg_error_list Error_Handler.Error_Tbl_Type;
1972: l_x_rtg_error_count INTEGER;
1973: -- Activity Association
1974: l_x_assoc_return_status VARCHAR2(1);
1975: l_x_assoc_msg_count NUMBER;

Line 2392: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

2388: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2389: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2390: x_bom_return_status OUT NOCOPY VARCHAR2,
2391: x_bom_msg_count OUT NOCOPY NUMBER,
2392: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
2393:
2394: )
2395: IS
2396: --l_current_date CONSTANT DATE := sysdate;

Line 2410: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

2406: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2407: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2408: l_x_bom_return_status VARCHAR2(1);
2409: l_x_bom_msg_count NUMBER;
2410: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
2411:
2412: begin
2413: -- l_bom_head_rec := NULL;
2414: l_bom_head_rec.Assembly_Item_Name := p_target_item_rec.Item_Number;

Line 2465: Error_Handler.Get_Message_List(l_x_bom_msg_list);

2461: x_bom_ref_designator_tbl := l_x_bom_ref_designator_tbl;
2462: x_bom_sub_component_tbl := l_x_bom_sub_component_tbl;
2463: x_bom_return_status := l_x_bom_return_status;
2464: x_bom_msg_count := l_x_bom_msg_count;
2465: Error_Handler.Get_Message_List(l_x_bom_msg_list);
2466: x_bom_msg_list := l_x_bom_msg_list;
2467: end create_bom_header;
2468:
2469: procedure create_bom_header_form(

Line 2483: x_bom_msg_list Error_Handler.Error_Tbl_Type;

2479: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2480: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2481: x_bom_return_status VARCHAR2(1);
2482: x_bom_msg_count NUMBER;
2483: x_bom_msg_list Error_Handler.Error_Tbl_Type;
2484:
2485: begin
2486: l_target_item_rec.item_number := p_inventory_item_name;
2487: l_target_item_rec.organization_code := p_organization_code;

Line 2656: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

2652: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2653: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2654: x_rtg_return_status OUT NOCOPY VARCHAR2,
2655: x_rtg_msg_count OUT NOCOPY NUMBER,
2656: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
2657: )
2658:
2659: IS
2660: --l_current_date CONSTANT DATE := sysdate;

Line 2678: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

2674: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2675: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2676: l_x_rtg_return_status VARCHAR2(1);
2677: l_x_rtg_msg_count NUMBER;
2678: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2679:
2680:
2681:
2682: BEGIN

Line 2691: Error_Handler.initialize;

2687: l_rtg_header_rec.Assembly_Item_Name := p_target_item_rec.Item_Number;
2688: l_rtg_header_rec.Organization_Code := p_target_item_rec.Organization_Code;
2689: l_rtg_header_rec.Transaction_Type := l_create_txn_type;
2690:
2691: Error_Handler.initialize;
2692: -- log call to Process_Rtg API
2693: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
2694: BOM_RTG_PUB.Process_Rtg(
2695: p_rtg_header_rec => l_rtg_header_rec

Line 2719: Error_Handler.Get_Message_List(l_x_rtg_msg_list);

2715: x_sub_resource_tbl := l_x_sub_resource_tbl;
2716: x_op_network_tbl := l_x_op_network_tbl;
2717: x_rtg_return_status := l_x_rtg_return_status;
2718: x_rtg_msg_count := l_x_rtg_msg_count;
2719: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
2720: x_rtg_msg_list := l_x_rtg_msg_list;
2721:
2722:
2723: END Create_Routing_Header;

Line 2747: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

2743: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2744: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2745: l_x_rtg_return_status VARCHAR2(1);
2746: l_x_rtg_msg_count NUMBER;
2747: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2748:
2749: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2750:
2751: begin