5594: x_msg_data := SQLERRM;
5595: END Process_Variant_Attrs;
5596:
5597: PROCEDURE Get_Interface_Errors( p_batch_id IN NUMBER,
5598: x_item_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
5599: x_rev_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
5600: x_uda_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE)
5601: IS
5602: TYPE transaction_table_type IS TABLE OF
5595: END Process_Variant_Attrs;
5596:
5597: PROCEDURE Get_Interface_Errors( p_batch_id IN NUMBER,
5598: x_item_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
5599: x_rev_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
5600: x_uda_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE)
5601: IS
5602: TYPE transaction_table_type IS TABLE OF
5603: mtl_system_items_interface.transaction_type%TYPE
5596:
5597: PROCEDURE Get_Interface_Errors( p_batch_id IN NUMBER,
5598: x_item_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
5599: x_rev_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
5600: x_uda_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE)
5601: IS
5602: TYPE transaction_table_type IS TABLE OF
5603: mtl_system_items_interface.transaction_type%TYPE
5604: INDEX BY BINARY_INTEGER;
5603: mtl_system_items_interface.transaction_type%TYPE
5604: INDEX BY BINARY_INTEGER;
5605:
5606: transaction_table transaction_table_type;
5607: l_item_err_table EGO_VARCHAR_TBL_TYPE;
5608: l_rev_err_table EGO_VARCHAR_TBL_TYPE;
5609: l_uda_err_table EGO_VARCHAR_TBL_TYPE;
5610: BEGIN
5611:
5604: INDEX BY BINARY_INTEGER;
5605:
5606: transaction_table transaction_table_type;
5607: l_item_err_table EGO_VARCHAR_TBL_TYPE;
5608: l_rev_err_table EGO_VARCHAR_TBL_TYPE;
5609: l_uda_err_table EGO_VARCHAR_TBL_TYPE;
5610: BEGIN
5611:
5612: BEGIN
5605:
5606: transaction_table transaction_table_type;
5607: l_item_err_table EGO_VARCHAR_TBL_TYPE;
5608: l_rev_err_table EGO_VARCHAR_TBL_TYPE;
5609: l_uda_err_table EGO_VARCHAR_TBL_TYPE;
5610: BEGIN
5611:
5612: BEGIN
5613: SELECT error_message BULK COLLECT INTO l_item_err_table