6378: x_msg_data := SQLERRM;
6379: END Process_Variant_Attrs;
6380:
6381: PROCEDURE Get_Interface_Errors( p_batch_id IN NUMBER,
6382: x_item_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
6383: x_rev_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
6384: x_uda_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE)
6385: IS
6386: TYPE transaction_table_type IS TABLE OF
6379: END Process_Variant_Attrs;
6380:
6381: PROCEDURE Get_Interface_Errors( p_batch_id IN NUMBER,
6382: x_item_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
6383: x_rev_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
6384: x_uda_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE)
6385: IS
6386: TYPE transaction_table_type IS TABLE OF
6387: mtl_system_items_interface.transaction_type%TYPE
6380:
6381: PROCEDURE Get_Interface_Errors( p_batch_id IN NUMBER,
6382: x_item_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
6383: x_rev_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE,
6384: x_uda_err_table OUT NOCOPY EGO_VARCHAR_TBL_TYPE)
6385: IS
6386: TYPE transaction_table_type IS TABLE OF
6387: mtl_system_items_interface.transaction_type%TYPE
6388: INDEX BY BINARY_INTEGER;
6387: mtl_system_items_interface.transaction_type%TYPE
6388: INDEX BY BINARY_INTEGER;
6389:
6390: transaction_table transaction_table_type;
6391: l_item_err_table EGO_VARCHAR_TBL_TYPE;
6392: l_rev_err_table EGO_VARCHAR_TBL_TYPE;
6393: l_uda_err_table EGO_VARCHAR_TBL_TYPE;
6394: BEGIN
6395:
6388: INDEX BY BINARY_INTEGER;
6389:
6390: transaction_table transaction_table_type;
6391: l_item_err_table EGO_VARCHAR_TBL_TYPE;
6392: l_rev_err_table EGO_VARCHAR_TBL_TYPE;
6393: l_uda_err_table EGO_VARCHAR_TBL_TYPE;
6394: BEGIN
6395:
6396: BEGIN
6389:
6390: transaction_table transaction_table_type;
6391: l_item_err_table EGO_VARCHAR_TBL_TYPE;
6392: l_rev_err_table EGO_VARCHAR_TBL_TYPE;
6393: l_uda_err_table EGO_VARCHAR_TBL_TYPE;
6394: BEGIN
6395:
6396: BEGIN
6397: SELECT error_message BULK COLLECT INTO l_item_err_table