[Home] [Help]
1676: -- what kind of errors they are.
1677: ELSIF v_return_status = g_return_error THEN
1678:
1679: -- if they're validation errors, the errors
1680: -- have been put into pon_interface_errors already
1681: IF v_return_code = 'VALIDATION_ERROR' THEN
1682: errbuf := 'PUBLISH_CP exited with validation errors';
1683: retcode := '2';
1684:
1682: errbuf := 'PUBLISH_CP exited with validation errors';
1683: retcode := '2';
1684:
1685: -- if the error thrown is non-validation, we need to push
1686: -- that error into pon_interface_errors. This error is most
1687: -- likely something updateAuctionInfo-related
1688: ELSE
1689: errbuf := 'PUBLISH_CP exited with publish errors';
1690: retcode := '2';
1688: ELSE
1689: errbuf := 'PUBLISH_CP exited with publish errors';
1690: retcode := '2';
1691:
1692: -- insert the publish error into pon_interface_errors table
1693: get_message_name(v_return_code, p_auction_header_id, v_error_msg_name);
1694:
1695: INSERT INTO pon_interface_errors
1696: (bid_number, auction_header_id, interface_type, request_id,
1691:
1692: -- insert the publish error into pon_interface_errors table
1693: get_message_name(v_return_code, p_auction_header_id, v_error_msg_name);
1694:
1695: INSERT INTO pon_interface_errors
1696: (bid_number, auction_header_id, interface_type, request_id,
1697: error_message_name, expiration_date)
1698: VALUES
1699: (p_bid_number, p_auction_header_id, 'PUBLISHBID', v_request_id,
1748: -- insert an error indicating that a fatal error in the
1749: -- publish CP has occurred.
1750: get_message_name('FATAL_PUBLISH_ERROR', p_auction_header_id, v_error_msg_name);
1751:
1752: INSERT INTO pon_interface_errors
1753: (bid_number, auction_header_id, interface_type, request_id,
1754: error_message_name, expiration_date)
1755: VALUES
1756: (p_bid_number, p_auction_header_id, 'PUBLISHBID', v_request_id,
1891: -- insert an error indicating that a fatal error in the
1892: -- publish CP has occurred.
1893: get_message_name('FATAL_VALIDATE_ERROR', p_auction_header_id, v_error_msg_name);
1894:
1895: INSERT INTO pon_interface_errors
1896: (bid_number, auction_header_id, interface_type, request_id,
1897: error_message_name, expiration_date)
1898: VALUES
1899: (p_bid_number, p_auction_header_id, 'VALIDATEBID', v_request_id,
1917: -- -------------------------------------------------------------------------
1918: -- get_message_name
1919: --
1920: -- called by publish_cp, this will return the message name to be inserted
1921: -- into pon_interface_errors table
1922: -- -------------------------------------------------------------------------
1923:
1924: PROCEDURE get_message_name(p_msg_code IN VARCHAR2,
1925: p_auction_header_id IN NUMBER,