DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_MESSAGE

Line 125: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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);

Line 126: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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;

Line 127: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');

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;

Line 128: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');

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:

Line 129: fnd_message.retrieve(P_ERROR_MESSAGE);

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

Line 410: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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;

Line 411: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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;

Line 412: fnd_message.set_token('PROCEDURE','Create_Draft_Negotiation');

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:

Line 413: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');

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: /*======================================================================

Line 615: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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);

Line 616: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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;

Line 617: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');

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;

Line 618: fnd_message.set_token('ERROR','Multi-Org Query Failed [' || SQLERRM || ']');

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:

Line 619: fnd_message.retrieve(P_ERROR_MESSAGE);

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

Line 1110: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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;

Line 1111: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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;

Line 1112: fnd_message.set_token('PROCEDURE','Add_Negotiation_Line');

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:

Line 1113: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');

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=====================

Line 1387: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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);

Line 1388: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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;

Line 1389: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');

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;

Line 1390: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');

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:

Line 1391: fnd_message.retrieve(X_MSG_DATA);

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=====================

Line 1496: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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;

Line 1497: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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;

Line 1498: fnd_message.set_token('PROCEDURE','Add_Price_Differential');

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:

Line 1499: fnd_message.set_token('ERROR',v_debug_status || ' [' || SQLERRM || ']');

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:

Line 1548: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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);

Line 1549: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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;

Line 1550: fnd_message.set_token('PROCEDURE','Get_Negotiation_Owner');

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:

Line 1551: fnd_message.set_token('ERROR','Document ' || P_DOCUMENT_NUMBER || ' [' || SQLERRM || ']');

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: /*========================================================================

Line 1552: fnd_message.retrieve(P_ERROR_MESSAGE);

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

Line 1614: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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);

Line 1615: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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;

Line 1616: fnd_message.set_token('PROCEDURE','Get_PO_Negotiation_Link');

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: --

Line 1617: fnd_message.set_token('ERROR','PO Header ' || P_PO_HEADER_ID || ' [' || SQLERRM || ']');

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: /*===================================================================

Line 1618: fnd_message.retrieve(P_ERROR_MESSAGE);

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

Line 1746: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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);

Line 1747: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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;

Line 1748: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');

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

Line 1749: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');

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 ;

Line 1750: fnd_message.retrieve(x_msg_data);

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;

Line 1755: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');

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;

Line 1756: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

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);

Line 1757: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');

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;

Line 1758: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');

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;

Line 1760: fnd_message.retrieve(x_msg_data);

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