[Home] [Help]
1868: -- what kind of errors they are.
1869: ELSIF v_return_status = g_return_error THEN
1870:
1871: -- if they're validation errors, the errors
1872: -- have been put into pon_interface_errors already
1873: IF v_return_code = 'VALIDATION_ERROR' THEN
1874: errbuf := 'PUBLISH_CP exited with validation errors';
1875: retcode := '2';
1876:
1874: errbuf := 'PUBLISH_CP exited with validation errors';
1875: retcode := '2';
1876:
1877: -- if the error thrown is non-validation, we need to push
1878: -- that error into pon_interface_errors. This error is most
1879: -- likely something updateAuctionInfo-related
1880: ELSE
1881: errbuf := 'PUBLISH_CP exited with publish errors';
1882: retcode := '2';
1880: ELSE
1881: errbuf := 'PUBLISH_CP exited with publish errors';
1882: retcode := '2';
1883:
1884: -- insert the publish error into pon_interface_errors table
1885: get_message_name(v_return_code, p_auction_header_id, v_error_msg_name);
1886:
1887: INSERT INTO pon_interface_errors
1888: (bid_number, auction_header_id, interface_type, request_id,
1883:
1884: -- insert the publish error into pon_interface_errors table
1885: get_message_name(v_return_code, p_auction_header_id, v_error_msg_name);
1886:
1887: INSERT INTO pon_interface_errors
1888: (bid_number, auction_header_id, interface_type, request_id,
1889: error_message_name, expiration_date)
1890: VALUES
1891: (p_bid_number, p_auction_header_id, 'PUBLISHBID', v_request_id,
1940: -- insert an error indicating that a fatal error in the
1941: -- publish CP has occurred.
1942: get_message_name('FATAL_PUBLISH_ERROR', p_auction_header_id, v_error_msg_name);
1943:
1944: INSERT INTO pon_interface_errors
1945: (bid_number, auction_header_id, interface_type, request_id,
1946: error_message_name, expiration_date)
1947: VALUES
1948: (p_bid_number, p_auction_header_id, 'PUBLISHBID', v_request_id,
2083: -- insert an error indicating that a fatal error in the
2084: -- publish CP has occurred.
2085: get_message_name('FATAL_VALIDATE_ERROR', p_auction_header_id, v_error_msg_name);
2086:
2087: INSERT INTO pon_interface_errors
2088: (bid_number, auction_header_id, interface_type, request_id,
2089: error_message_name, expiration_date)
2090: VALUES
2091: (p_bid_number, p_auction_header_id, 'VALIDATEBID', v_request_id,
2109: -- -------------------------------------------------------------------------
2110: -- get_message_name
2111: --
2112: -- called by publish_cp, this will return the message name to be inserted
2113: -- into pon_interface_errors table
2114: -- -------------------------------------------------------------------------
2115:
2116: PROCEDURE get_message_name(p_msg_code IN VARCHAR2,
2117: p_auction_header_id IN NUMBER,