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.

[Home] [Help]

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 340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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