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_LOADER_PUB dependencies on FND_API

Line 4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4727:
4728: END IF;
4729:
4730: EXCEPTION
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732: retcode := 2;
4733: write_log('Unexpected error '||substr(sqlerrm,1200));
4734: write_log( ' ');
4735: oe_debug_pub.add(sqlerrm);

Line 4818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4814: write_log('Leaving Process Header');
4815: COMMIT;
4816:
4817: EXCEPTION
4818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4819: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER:'||sqlerrm);
4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: WHEN OTHERS THEN
4822: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER'||sqlerrm);

Line 4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4816:
4817: EXCEPTION
4818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4819: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER:'||sqlerrm);
4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: WHEN OTHERS THEN
4822: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER'||sqlerrm);
4823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4824: END PROCESS_HEADER;

Line 4823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4819: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER:'||sqlerrm);
4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: WHEN OTHERS THEN
4822: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER'||sqlerrm);
4823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4824: END PROCESS_HEADER;
4825:
4826:
4827: PROCEDURE PROCESS_QUALIFIER

Line 5286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5282:
5283: write_log('Existing Process Qualifier');
5284:
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5287: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5289: WHEN OTHERS THEN
5290: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);

Line 5288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5284:
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5287: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5289: WHEN OTHERS THEN
5290: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5292:

Line 5291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5287: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5289: WHEN OTHERS THEN
5290: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5292:
5293: END PROCESS_QUALIFIER;
5294:
5295:

Line 6159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6155:
6156: write_log('Existing Process Line');
6157:
6158: EXCEPTION
6159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6160: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6162: WHEN OTHERS THEN
6163: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);

Line 6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6157:
6158: EXCEPTION
6159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6160: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6162: WHEN OTHERS THEN
6163: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6165: --set Process_status_flag

Line 6164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6160: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6162: WHEN OTHERS THEN
6163: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6165: --set Process_status_flag
6166:
6167: END PROCESS_LINE;
6168:

Line 6758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6754: QP_BULK_UTIL.Delete_Pricing_Attr(p_request_id);
6755:
6756: write_log('Leaving Process Pricing Attribute');
6757: EXCEPTION
6758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6759: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6761: WHEN OTHERS THEN
6762: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);

Line 6760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6756: write_log('Leaving Process Pricing Attribute');
6757: EXCEPTION
6758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6759: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6761: WHEN OTHERS THEN
6762: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6764:

Line 6763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6759: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6761: WHEN OTHERS THEN
6762: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6764:
6765: END PROCESS_PRICING_ATTR;
6766:
6767: PROCEDURE POST_CLEANUP

Line 6814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6810:
6811: write_log('Leaving POST_CLEANUP');
6812:
6813: EXCEPTION
6814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6815: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6817: WHEN OTHERS THEN
6818: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);

Line 6816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6812:
6813: EXCEPTION
6814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6815: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6817: WHEN OTHERS THEN
6818: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6820:

Line 6819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6815: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6817: WHEN OTHERS THEN
6818: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6820:
6821: END POST_CLEANUP;
6822:
6823: PROCEDURE POST_CLEANUP_LINE

Line 6883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6879:
6880: write_log('Leaving POST_CLEANUP_LINE');
6881:
6882: EXCEPTION
6883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6884: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);
6885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6886: WHEN OTHERS THEN
6887: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);

Line 6885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6881:
6882: EXCEPTION
6883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6884: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);
6885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6886: WHEN OTHERS THEN
6887: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);
6888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6889:

Line 6888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6884: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);
6885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6886: WHEN OTHERS THEN
6887: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);
6888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6889:
6890: END POST_CLEANUP_LINE;
6891:
6892: PROCEDURE VALIDATE_LINES

Line 7015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7011: write_log('Leaving Validate_Lines');
7012:
7013: END IF;
7014: EXCEPTION
7015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7016: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
7017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7018: WHEN OTHERS THEN
7019: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);

Line 7017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7013: END IF;
7014: EXCEPTION
7015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7016: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
7017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7018: WHEN OTHERS THEN
7019: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
7020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7021:

Line 7020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7016: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
7017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7018: WHEN OTHERS THEN
7019: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
7020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7021:
7022: END VALIDATE_LINES;
7023:
7024:

Line 7135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7131: END LOOP;
7132: write_log('Leaving Delete errored records parent');
7133:
7134: EXCEPTION
7135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7136: write_log(
7137: 'UNEXCPECTED ERROR IN PROCEDURE DELETE_ERRORED_RECORDS_PARENTS:'||sqlerrm);
7138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7139: WHEN OTHERS THEN

Line 7138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7134: EXCEPTION
7135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7136: write_log(
7137: 'UNEXCPECTED ERROR IN PROCEDURE DELETE_ERRORED_RECORDS_PARENTS:'||sqlerrm);
7138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7139: WHEN OTHERS THEN
7140: write_log(
7141: 'UNEXCPECTED ERROR IN PROCEDURE DELETE_ERRORED_RECORDS_PARENTS:'||sqlerrm);
7142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7139: WHEN OTHERS THEN
7140: write_log(
7141: 'UNEXCPECTED ERROR IN PROCEDURE DELETE_ERRORED_RECORDS_PARENTS:'||sqlerrm);
7142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7143: END Delete_errored_records_parents;
7144:
7145: PROCEDURE ERRORS_TO_OUTPUT
7146: (p_request_id NUMBER)

Line 7255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7251:
7252: write_log('Leaving Purging');
7253:
7254: EXCEPTION
7255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7256: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7258: WHEN OTHERS THEN
7259: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);

Line 7257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7253:
7254: EXCEPTION
7255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7256: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7258: WHEN OTHERS THEN
7259: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7261:

Line 7260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7256: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7258: WHEN OTHERS THEN
7259: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7261:
7262: END PURGE;
7263:
7264: --Basic_Pricing_Condition