eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_BULK_UTIL dependencies on FND_API

Line 164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

160:
161: qp_bulk_loader_pub.write_log('Leaving Loading Ins Header');
162:
163: EXCEPTION
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: WHEN OTHERS THEN
168: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162:
163: EXCEPTION
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: WHEN OTHERS THEN
168: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170:

Line 169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

165: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: WHEN OTHERS THEN
168: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170:
171: END LOAD_INS_HEADER;
172:
173: PROCEDURE LOAD_UDT_HEADER

Line 339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

335:
336: qp_bulk_loader_pub.write_log('Leaving Loading Udt Header');
337:
338: EXCEPTION
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: WHEN OTHERS THEN
343: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);

Line 341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

337:
338: EXCEPTION
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: WHEN OTHERS THEN
343: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345:

Line 344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

340: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: WHEN OTHERS THEN
343: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345:
346:
347: END LOAD_UDT_HEADER;
348:

Line 541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

537:
538: COMMIT;
539:
540: EXCEPTION
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);
543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: WHEN OTHERS THEN
545: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);

Line 543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

539:
540: EXCEPTION
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);
543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: WHEN OTHERS THEN
545: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547:

Line 546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

542: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);
543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: WHEN OTHERS THEN
545: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547:
548:
549: END INSERT_HEADER;
550:

Line 761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

757: qp_bulk_loader_pub.write_log('Line Insert Count: '|| sql%rowcount);
758: qp_bulk_loader_pub.write_log('Leaving Insert Line');
759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: WHEN OTHERS THEN
765: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);

Line 763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: WHEN OTHERS THEN
765: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767:

Line 766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

762: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: WHEN OTHERS THEN
765: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767:
768:
769: END INSERT_LINE;
770:

Line 887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

883:
884: EXCEPTION
885: when no_data_found then
886: qp_bulk_loader_pub.write_log( 'NO data found QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
889: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
891: WHEN OTHERS THEN

Line 888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

884: EXCEPTION
885: when no_data_found then
886: qp_bulk_loader_pub.write_log( 'NO data found QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
889: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
891: WHEN OTHERS THEN
892: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD');

Line 890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

886: qp_bulk_loader_pub.write_log( 'NO data found QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
889: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
891: WHEN OTHERS THEN
892: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894:

Line 893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

889: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
891: WHEN OTHERS THEN
892: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894:
895:
896: END UPDATE_LINE_TO_OLD;
897: -- End New procedure 6028305

Line 1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1015: qp_bulk_loader_pub.write_log('Inserted Qualifier Count: '|| sql%rowcount);
1016: qp_bulk_loader_pub.write_log('Leaving Insert Qualifier');
1017:
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: WHEN OTHERS THEN
1023: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);

Line 1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1017:
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: WHEN OTHERS THEN
1023: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025:

Line 1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1020: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: WHEN OTHERS THEN
1023: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025:
1026: END INSERT_QUALIFIER;
1027:
1028: PROCEDURE INSERT_PRICING_ATTR

Line 1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1150: qp_bulk_loader_pub.write_log('Pricing Attr Insertcount: '|| sql%rowcount);
1151: qp_bulk_loader_pub.write_log('Leaving Insert Pricing Attribute');
1152:
1153: EXCEPTION
1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1155: qp_bulk_loader_pub.write_log(
1156: 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_PRICING_ATTR:'||sqlerrm);
1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1158: WHEN OTHERS THEN

Line 1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1153: EXCEPTION
1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1155: qp_bulk_loader_pub.write_log(
1156: 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_PRICING_ATTR:'||sqlerrm);
1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1158: WHEN OTHERS THEN
1159: qp_bulk_loader_pub.write_log(
1160: 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_PRICING_ATTR:'||sqlerrm);
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1158: WHEN OTHERS THEN
1159: qp_bulk_loader_pub.write_log(
1160: 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_PRICING_ATTR:'||sqlerrm);
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1162:
1163: END INSERT_PRICING_ATTR;
1164:
1165: PROCEDURE UPDATE_HEADER

Line 1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1260: qp_bulk_loader_pub.write_log('Header Records Updated: '|| sql%rowcount);
1261: qp_bulk_loader_pub.write_log('Leaving Update Header');
1262:
1263: EXCEPTION
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: WHEN OTHERS THEN
1268: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);

Line 1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1262:
1263: EXCEPTION
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: WHEN OTHERS THEN
1268: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270:

Line 1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1265: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: WHEN OTHERS THEN
1268: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270:
1271: END UPDATE_HEADER;
1272:
1273: PROCEDURE UPDATE_LINE

Line 1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1382: qp_bulk_loader_pub.write_log('Lines Records Updated: '|| sql%rowcount);
1383: qp_bulk_loader_pub.write_log('Leaving Update Line');
1384:
1385: EXCEPTION
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE');
1388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1389: WHEN OTHERS THEN
1390: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE');

Line 1388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1384:
1385: EXCEPTION
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE');
1388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1389: WHEN OTHERS THEN
1390: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE');
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392:

Line 1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1387: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE');
1388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1389: WHEN OTHERS THEN
1390: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE');
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392:
1393:
1394: END UPDATE_LINE;
1395:

Line 1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1459: qp_bulk_loader_pub.write_log('Qualifier Records Updated: '|| sql%rowcount);
1460: qp_bulk_loader_pub.write_log('Leaving Update Qualifier');
1461:
1462: EXCEPTION
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: WHEN OTHERS THEN
1467: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);

Line 1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1461:
1462: EXCEPTION
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: WHEN OTHERS THEN
1467: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469:

Line 1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1464: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: WHEN OTHERS THEN
1467: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469:
1470: END UPDATE_QUALIFIER;
1471:
1472: PROCEDURE UPDATE_PRICING_ATTR

Line 1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1541: qp_bulk_loader_pub.write_log('Pricing Attr Records Updated: '|| sql%rowcount);
1542: qp_bulk_loader_pub.write_log('Leaving Update Pricing Attribute');
1543:
1544: EXCEPTION
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1546: qp_bulk_loader_pub.write_log(
1547: 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_PRICING_ATTR:'||sqlerrm);
1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1549: WHEN OTHERS THEN

Line 1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1544: EXCEPTION
1545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1546: qp_bulk_loader_pub.write_log(
1547: 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_PRICING_ATTR:'||sqlerrm);
1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1549: WHEN OTHERS THEN
1550: qp_bulk_loader_pub.write_log(
1551: 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_PRICING_ATTR'||sqlerrm);
1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1549: WHEN OTHERS THEN
1550: qp_bulk_loader_pub.write_log(
1551: 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_PRICING_ATTR'||sqlerrm);
1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1553:
1554: END UPDATE_PRICING_ATTR;
1555:
1556: PROCEDURE DELETE_HEADER

Line 1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1587:
1588: qp_bulk_loader_pub.write_log('Leaving Delete Header');
1589:
1590: EXCEPTION
1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1592: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: WHEN OTHERS THEN
1595: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);

Line 1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1589:
1590: EXCEPTION
1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1592: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: WHEN OTHERS THEN
1595: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597:

Line 1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1592: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: WHEN OTHERS THEN
1595: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597:
1598: END DELETE_HEADER;
1599:
1600: PROCEDURE DELETE_QUALIFIER

Line 1662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1658:
1659: qp_bulk_loader_pub.write_log('Leaving Delete Qualifier');
1660:
1661: EXCEPTION
1662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1663: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: WHEN OTHERS THEN
1666: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);

Line 1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1660:
1661: EXCEPTION
1662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1663: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: WHEN OTHERS THEN
1666: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668:

Line 1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1663: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: WHEN OTHERS THEN
1666: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668:
1669: END DELETE_QUALIFIER;
1670:
1671: PROCEDURE DELETE_LINE

Line 1780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1776:
1777: qp_bulk_loader_pub.write_log('Leaving Delete Line');
1778:
1779: EXCEPTION
1780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1781: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: WHEN OTHERS THEN
1784: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);

Line 1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1778:
1779: EXCEPTION
1780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1781: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: WHEN OTHERS THEN
1784: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786:

Line 1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1781: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: WHEN OTHERS THEN
1784: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786:
1787: END DELETE_LINE;
1788:
1789: PROCEDURE DELETE_PRICING_ATTR

Line 1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1897: AND request_id = p_request_id
1898: AND interface_action_code = 'DELETE';
1899:
1900: EXCEPTION
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: qp_bulk_loader_pub.write_log(
1903: 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_PRICING_ATTR:'||sqlerrm);
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: WHEN OTHERS THEN

Line 1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1900: EXCEPTION
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: qp_bulk_loader_pub.write_log(
1903: 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_PRICING_ATTR:'||sqlerrm);
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: WHEN OTHERS THEN
1906: qp_bulk_loader_pub.write_log(
1907: 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_PRICING_ATTR:'||sqlerrm);
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: WHEN OTHERS THEN
1906: qp_bulk_loader_pub.write_log(
1907: 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_PRICING_ATTR:'||sqlerrm);
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909:
1910: qp_bulk_loader_pub.write_log('Leaving Delete Pricing Attribute');
1911:
1912: END DELETE_PRICING_ATTR;