[Home] [Help]
2241: ** Proc : save_failed_line_message
2242: ** Desc : Parse the error_message of Interface table, the format
2243: ** is '.KEY1:MESSAGE1.KEY2:MESSAGE2.KEY3:MESSAGE3......',
2244: ** insert these pairs of error messages into table
2245: ** icx_por_failed_line_messages.
2246: **/
2247: PROCEDURE save_failed_line_message (p_request_id NUMBER,
2248: p_line_number NUMBER, p_error_message VARCHAR2) IS
2249: xErrLoc INTEGER := 0;
2284: xKey := substr(xString, 1, xIndex-1);
2285: xMessage := substr(xString, xIndex+1);
2286: xErrLoc := 350;
2287:
2288: insert into icx_por_failed_line_messages
2289: (job_number, line_number, descriptor_key, message_name)
2290: values
2291: (p_request_id, p_line_number, xKey, xMessage);
2292:
3264: END IF;
3265:
3266: vDescName := SUBSTR(p_desc_names, vStartPos, vBreakPos - vStartPos);
3267:
3268: INSERT INTO icx_por_failed_line_messages
3269: (job_number, line_number, descriptor_key, message_name)
3270: VALUES
3271: (p_request_id, p_line_number, vDescName, 'ICX_POR_CAT_FIELD_REQUIRED');
3272:
4679: END save_failed_price_list;
4680:
4681: --
4682: -- Move the error message from ICX_POR_CONTRACT_REFERENCE table
4683: -- into ICX_POR_FAILED_LINES and ICX_POR_FAILED_LINE_MESSAGES table
4684: --
4685: -- bug#1968033
4686: PROCEDURE save_failed_admin_data (p_request_id in number)
4687: IS
4954: --VALUES (p_request_id, 1, 'SYNC', p_line_type, p_descriptor_key, p_descriptor_key);
4955: VALUES (p_request_id, 1, 'SYNC', p_line_type, p_descriptor_key, p_descriptor_val);
4956:
4957: -- Delete all the Messages for the request_id#
4958: delete from icx_por_failed_line_messages
4959: where job_number = p_request_id;
4960:
4961: -- Save the Failed Line message now
4962: ICX_POR_ITEM_UPLOAD.save_failed_line_message(p_request_id,