DBA Data[Home] [Help]

APPS.BOM_OPEN_INTERFACE_API dependencies on ERROR_HANDLER

Line 338: ERROR_HANDLER.INITIALIZE ;

334: BOM_GLOBALS.G_BATCH_ID := p_batch_id; -- Bug 4306013
335:
336: stmt_num :=2;
337: -- Initialize the error handling table
338: ERROR_HANDLER.INITIALIZE ;
339:
340: stmt_num :=3;
341:
342: -- Set the Global Variable to BOM Open Interface type.

Line 343: Error_Handler.set_bom_oi;

339:
340: stmt_num :=3;
341:
342: -- Set the Global Variable to BOM Open Interface type.
343: Error_Handler.set_bom_oi;
344:
345: stmt_num :=4;
346: -- Convert the Derived columns to User friendly columns
347:

Line 820: Error_handler.Write_To_ConcurrentLog;

816: end if;
817:
818: stmt_num:=11;
819: -- Error_handling for the openInterface
820: Error_handler.Write_To_ConcurrentLog;
821: Error_handler.Write_To_InterfaceTable;
822: -- Error handling for the openInterface
823:
824: stmt_num :=12;

Line 821: Error_handler.Write_To_InterfaceTable;

817:
818: stmt_num:=11;
819: -- Error_handling for the openInterface
820: Error_handler.Write_To_ConcurrentLog;
821: Error_handler.Write_To_InterfaceTable;
822: -- Error handling for the openInterface
823:
824: stmt_num :=12;
825: l_return_status := Update_Interface_tables (err_text);

Line 837: Error_Handler.unset_bom_oi;

833: COMMIT;
834: END IF; --ASSEMBLY_ITEM_NUMBER AND ORGANIZATION_CODE NOT NULL.
835: END LOOP;
836:
837: Error_Handler.unset_bom_oi;
838: stmt_num :=13;
839: if(del_rec_flag = 1) then
840: l_return_status := Delete_Bom_OI(err_text,p_batch_id);
841: IF (l_return_status <> 0) THEN

Line 857: Error_Handler.unset_bom_oi;

853: return (l_func_ret_status);
854: EXCEPTION
855: WHEN others THEN
856: err_text := 'Bom_Open_Interface_Api :'||stmt_num||substrb(SQLERRM,1,500);
857: Error_Handler.unset_bom_oi;
858: RETURN(SQLCODE);
859: End;
860:
861: