DBA Data[Home] [Help]

APPS.BOM_OPEN_INTERFACE_API dependencies on ERROR_HANDLER

Line 329: ERROR_HANDLER.INITIALIZE ;

325: BOM_GLOBALS.G_BATCH_ID := p_batch_id; -- Bug 4306013
326:
327: stmt_num :=2;
328: -- Initialize the error handling table
329: ERROR_HANDLER.INITIALIZE ;
330:
331: stmt_num :=3;
332:
333: -- Set the Global Variable to BOM Open Interface type.

Line 334: Error_Handler.set_bom_oi;

330:
331: stmt_num :=3;
332:
333: -- Set the Global Variable to BOM Open Interface type.
334: Error_Handler.set_bom_oi;
335:
336: stmt_num :=4;
337: -- Convert the Derived columns to User friendly columns
338:

Line 811: Error_handler.Write_To_ConcurrentLog;

807: end if;
808:
809: stmt_num:=11;
810: -- Error_handling for the openInterface
811: Error_handler.Write_To_ConcurrentLog;
812: Error_handler.Write_To_InterfaceTable;
813: -- Error handling for the openInterface
814:
815: stmt_num :=12;

Line 812: Error_handler.Write_To_InterfaceTable;

808:
809: stmt_num:=11;
810: -- Error_handling for the openInterface
811: Error_handler.Write_To_ConcurrentLog;
812: Error_handler.Write_To_InterfaceTable;
813: -- Error handling for the openInterface
814:
815: stmt_num :=12;
816: l_return_status := Update_Interface_tables (err_text);

Line 828: Error_Handler.unset_bom_oi;

824: COMMIT;
825: END IF; --ASSEMBLY_ITEM_NUMBER AND ORGANIZATION_CODE NOT NULL.
826: END LOOP;
827:
828: Error_Handler.unset_bom_oi;
829: stmt_num :=13;
830: if(del_rec_flag = 1) then
831: l_return_status := Delete_Bom_OI(err_text,p_batch_id);
832: IF (l_return_status <> 0) THEN

Line 848: Error_Handler.unset_bom_oi;

844: return (l_func_ret_status);
845: EXCEPTION
846: WHEN others THEN
847: err_text := 'Bom_Open_Interface_Api :'||stmt_num||substrb(SQLERRM,1,500);
848: Error_Handler.unset_bom_oi;
849: RETURN(SQLCODE);
850: End;
851:
852: