121: EXCEPTION
122: WHEN no_data_found THEN
123: P_RESULT := error;
124: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
125: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
126: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
127: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
128: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
129: fnd_message.retrieve(P_ERROR_MESSAGE);
122: WHEN no_data_found THEN
123: P_RESULT := error;
124: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
125: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
126: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
127: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
128: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
129: fnd_message.retrieve(P_ERROR_MESSAGE);
130: RETURN;
123: P_RESULT := error;
124: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
125: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
126: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
127: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
128: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
129: fnd_message.retrieve(P_ERROR_MESSAGE);
130: RETURN;
131: END;
124: P_ERROR_CODE := 'CREATE_DRAFT:MULTI_ORG_QUERY';
125: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
126: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
127: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
128: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
129: fnd_message.retrieve(P_ERROR_MESSAGE);
130: RETURN;
131: END;
132:
125: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
126: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
127: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
128: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
129: fnd_message.retrieve(P_ERROR_MESSAGE);
130: RETURN;
131: END;
132:
133: IF (P_ORG_ID IS NULL AND v_multi_org = 'Y') THEN
406: P_ERROR_CODE := NULL;
407: P_ERROR_MESSAGE := NULL;
408: EXCEPTION
409: WHEN OTHERS THEN
410: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
411: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
412: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
413: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
414: APP_EXCEPTION.RAISE_EXCEPTION;
407: P_ERROR_MESSAGE := NULL;
408: EXCEPTION
409: WHEN OTHERS THEN
410: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
411: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
412: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
413: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
414: APP_EXCEPTION.RAISE_EXCEPTION;
415: END;
408: EXCEPTION
409: WHEN OTHERS THEN
410: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
411: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
412: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
413: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
414: APP_EXCEPTION.RAISE_EXCEPTION;
415: END;
416:
409: WHEN OTHERS THEN
410: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
411: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
412: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');
413: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
414: APP_EXCEPTION.RAISE_EXCEPTION;
415: END;
416:
417: /*======================================================================
611: EXCEPTION
612: WHEN no_data_found THEN
613: P_RESULT := error;
614: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';
615: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
616: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
617: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
618: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
619: fnd_message.retrieve(P_ERROR_MESSAGE);
612: WHEN no_data_found THEN
613: P_RESULT := error;
614: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';
615: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
616: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
617: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
618: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
619: fnd_message.retrieve(P_ERROR_MESSAGE);
620: RETURN;
613: P_RESULT := error;
614: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';
615: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
616: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
617: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
618: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
619: fnd_message.retrieve(P_ERROR_MESSAGE);
620: RETURN;
621: END;
614: P_ERROR_CODE := 'ADD_NEG_LINE:MULTI_ORG_QUERY';
615: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
616: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
617: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
618: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
619: fnd_message.retrieve(P_ERROR_MESSAGE);
620: RETURN;
621: END;
622:
615: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
616: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
617: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
618: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');
619: fnd_message.retrieve(P_ERROR_MESSAGE);
620: RETURN;
621: END;
622:
623: IF (P_ORG_ID IS NULL AND v_multi_org = 'Y') THEN
1106: P_ERROR_CODE := NULL;
1107: P_ERROR_MESSAGE := NULL;
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1111: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1112: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1113: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1114: APP_EXCEPTION.RAISE_EXCEPTION;
1107: P_ERROR_MESSAGE := NULL;
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1111: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1112: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1113: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1114: APP_EXCEPTION.RAISE_EXCEPTION;
1115: END;
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1111: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1112: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1113: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1114: APP_EXCEPTION.RAISE_EXCEPTION;
1115: END;
1116:
1109: WHEN OTHERS THEN
1110: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1111: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1112: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');
1113: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1114: APP_EXCEPTION.RAISE_EXCEPTION;
1115: END;
1116:
1117: /*============ADDED FOR UNIFIED CATALOG PROJECT=====================
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
1386: X_MSG_COUNT := 1;
1387: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1388: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1389: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
1390: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1391: fnd_message.retrieve(X_MSG_DATA);
1384: WHEN OTHERS THEN
1385: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
1386: X_MSG_COUNT := 1;
1387: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1388: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1389: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
1390: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1391: fnd_message.retrieve(X_MSG_DATA);
1392: RETURN;
1385: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
1386: X_MSG_COUNT := 1;
1387: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1388: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1389: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
1390: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1391: fnd_message.retrieve(X_MSG_DATA);
1392: RETURN;
1393: END Add_Catalog_Descriptors;
1386: X_MSG_COUNT := 1;
1387: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1388: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1389: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
1390: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1391: fnd_message.retrieve(X_MSG_DATA);
1392: RETURN;
1393: END Add_Catalog_Descriptors;
1394:
1387: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1388: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1389: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');
1390: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1391: fnd_message.retrieve(X_MSG_DATA);
1392: RETURN;
1393: END Add_Catalog_Descriptors;
1394:
1395: /*============ADDED FOR SERVICES PROCUREMENT PROJECT=====================
1492: );
1493:
1494: EXCEPTION
1495: WHEN OTHERS THEN
1496: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1497: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1498: fnd_message.set_token('PROCEDURE','Add_Price_Differential');
1499: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1500: APP_EXCEPTION.RAISE_EXCEPTION;
1493:
1494: EXCEPTION
1495: WHEN OTHERS THEN
1496: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1497: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1498: fnd_message.set_token('PROCEDURE','Add_Price_Differential');
1499: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1500: APP_EXCEPTION.RAISE_EXCEPTION;
1501: END;
1494: EXCEPTION
1495: WHEN OTHERS THEN
1496: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1497: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1498: fnd_message.set_token('PROCEDURE','Add_Price_Differential');
1499: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1500: APP_EXCEPTION.RAISE_EXCEPTION;
1501: END;
1502:
1495: WHEN OTHERS THEN
1496: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1497: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1498: fnd_message.set_token('PROCEDURE','Add_Price_Differential');
1499: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');
1500: APP_EXCEPTION.RAISE_EXCEPTION;
1501: END;
1502:
1503:
1544: EXCEPTION
1545: WHEN OTHERS THEN
1546: P_RESULT := error;
1547: P_ERROR_CODE := 'GET_NEG_OWNER';
1548: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1549: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1550: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
1551: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
1552: fnd_message.retrieve(P_ERROR_MESSAGE);
1545: WHEN OTHERS THEN
1546: P_RESULT := error;
1547: P_ERROR_CODE := 'GET_NEG_OWNER';
1548: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1549: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1550: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
1551: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
1552: fnd_message.retrieve(P_ERROR_MESSAGE);
1553: END;
1546: P_RESULT := error;
1547: P_ERROR_CODE := 'GET_NEG_OWNER';
1548: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1549: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1550: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
1551: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
1552: fnd_message.retrieve(P_ERROR_MESSAGE);
1553: END;
1554:
1547: P_ERROR_CODE := 'GET_NEG_OWNER';
1548: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1549: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1550: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
1551: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
1552: fnd_message.retrieve(P_ERROR_MESSAGE);
1553: END;
1554:
1555: /*========================================================================
1548: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1549: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1550: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');
1551: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');
1552: fnd_message.retrieve(P_ERROR_MESSAGE);
1553: END;
1554:
1555: /*========================================================================
1556: PROCEDURE : Get_PO_Negotiation_Link PUBLIC
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: P_RESULT := error;
1613: P_ERROR_CODE := 'GET_NEG_OWNER';
1614: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1615: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1616: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
1617: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
1618: fnd_message.retrieve(P_ERROR_MESSAGE);
1611: WHEN OTHERS THEN
1612: P_RESULT := error;
1613: P_ERROR_CODE := 'GET_NEG_OWNER';
1614: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1615: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1616: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
1617: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
1618: fnd_message.retrieve(P_ERROR_MESSAGE);
1619: END;
1612: P_RESULT := error;
1613: P_ERROR_CODE := 'GET_NEG_OWNER';
1614: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1615: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1616: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
1617: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
1618: fnd_message.retrieve(P_ERROR_MESSAGE);
1619: END;
1620: --
1613: P_ERROR_CODE := 'GET_NEG_OWNER';
1614: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1615: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1616: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
1617: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
1618: fnd_message.retrieve(P_ERROR_MESSAGE);
1619: END;
1620: --
1621: /*===================================================================
1614: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1615: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1616: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');
1617: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');
1618: fnd_message.retrieve(P_ERROR_MESSAGE);
1619: END;
1620: --
1621: /*===================================================================
1622: PROCEDURE: add_negotiation_invitees PUBLIC
1742: RETURN;
1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1745: x_msg_count := 1;
1746: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1747: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1748: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1749: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1750: fnd_message.retrieve(x_msg_data);
1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1745: x_msg_count := 1;
1746: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1747: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1748: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1749: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1750: fnd_message.retrieve(x_msg_data);
1751: RETURN;
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1745: x_msg_count := 1;
1746: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1747: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1748: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1749: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1750: fnd_message.retrieve(x_msg_data);
1751: RETURN;
1752: WHEN OTHERS THEN
1745: x_msg_count := 1;
1746: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1747: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1748: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1749: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1750: fnd_message.retrieve(x_msg_data);
1751: RETURN;
1752: WHEN OTHERS THEN
1753: x_return_status := FND_API.G_RET_STS_ERROR ;
1746: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1747: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1748: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1749: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1750: fnd_message.retrieve(x_msg_data);
1751: RETURN;
1752: WHEN OTHERS THEN
1753: x_return_status := FND_API.G_RET_STS_ERROR ;
1754: x_msg_count := 1;
1751: RETURN;
1752: WHEN OTHERS THEN
1753: x_return_status := FND_API.G_RET_STS_ERROR ;
1754: x_msg_count := 1;
1755: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1756: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1757: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1758: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1759: --APP_EXCEPTION.RAISE_EXCEPTION;
1752: WHEN OTHERS THEN
1753: x_return_status := FND_API.G_RET_STS_ERROR ;
1754: x_msg_count := 1;
1755: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1756: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1757: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1758: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1759: --APP_EXCEPTION.RAISE_EXCEPTION;
1760: fnd_message.retrieve(x_msg_data);
1753: x_return_status := FND_API.G_RET_STS_ERROR ;
1754: x_msg_count := 1;
1755: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1756: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1757: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1758: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1759: --APP_EXCEPTION.RAISE_EXCEPTION;
1760: fnd_message.retrieve(x_msg_data);
1761: RETURN;
1754: x_msg_count := 1;
1755: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1756: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1757: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1758: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1759: --APP_EXCEPTION.RAISE_EXCEPTION;
1760: fnd_message.retrieve(x_msg_data);
1761: RETURN;
1762: END;
1756: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1757: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');
1758: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1759: --APP_EXCEPTION.RAISE_EXCEPTION;
1760: fnd_message.retrieve(x_msg_data);
1761: RETURN;
1762: END;
1763:
1764: -- API used by html autocreation for default negotiation style