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

4608:
4609: END IF;
4610:
4611: EXCEPTION
4612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4613: retcode := 2;
4614: write_log('Unexpected error '||substr(sqlerrm,1200));
4615: write_log( ' ');
4616: oe_debug_pub.add(sqlerrm);

Line 4699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4695: write_log('Leaving Process Header');
4696: COMMIT;
4697:
4698: EXCEPTION
4699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4700: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER:'||sqlerrm);
4701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4702: WHEN OTHERS THEN
4703: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER'||sqlerrm);

Line 4701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4697:
4698: EXCEPTION
4699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4700: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER:'||sqlerrm);
4701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4702: WHEN OTHERS THEN
4703: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER'||sqlerrm);
4704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4705: END PROCESS_HEADER;

Line 4704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4700: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER:'||sqlerrm);
4701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4702: WHEN OTHERS THEN
4703: write_log( 'UNEXCPECTED ERROR IN PROCESS_HEADER'||sqlerrm);
4704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4705: END PROCESS_HEADER;
4706:
4707:
4708: PROCEDURE PROCESS_QUALIFIER

Line 5167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5163:
5164: write_log('Existing Process Qualifier');
5165:
5166: EXCEPTION
5167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5168: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5170: WHEN OTHERS THEN
5171: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);

Line 5169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5165:
5166: EXCEPTION
5167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5168: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5170: WHEN OTHERS THEN
5171: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5173:

Line 5172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5168: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5170: WHEN OTHERS THEN
5171: write_log( 'UNEXCPECTED ERROR IN PROCESS_QUALIFIER'||sqlerrm);
5172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5173:
5174: END PROCESS_QUALIFIER;
5175:
5176:

Line 6036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6032:
6033: write_log('Existing Process Line');
6034:
6035: EXCEPTION
6036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6037: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6039: WHEN OTHERS THEN
6040: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);

Line 6038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6034:
6035: EXCEPTION
6036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6037: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6039: WHEN OTHERS THEN
6040: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6042: --set Process_status_flag

Line 6041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6037: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6039: WHEN OTHERS THEN
6040: write_log( 'UNEXCPECTED ERROR IN PROCESS_LINE:'||sqlerrm);
6041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6042: --set Process_status_flag
6043:
6044: END PROCESS_LINE;
6045:

Line 6634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6630: QP_BULK_UTIL.Delete_Pricing_Attr(p_request_id);
6631:
6632: write_log('Leaving Process Pricing Attribute');
6633: EXCEPTION
6634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6635: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6637: WHEN OTHERS THEN
6638: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);

Line 6636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6632: write_log('Leaving Process Pricing Attribute');
6633: EXCEPTION
6634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6635: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6637: WHEN OTHERS THEN
6638: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6640:

Line 6639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6635: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6637: WHEN OTHERS THEN
6638: write_log( 'UNEXCPECTED ERROR IN PROCESS_PRICING_ATTR:'||sqlerrm);
6639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6640:
6641: END PROCESS_PRICING_ATTR;
6642:
6643: PROCEDURE POST_CLEANUP

Line 6690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6686:
6687: write_log('Leaving POST_CLEANUP');
6688:
6689: EXCEPTION
6690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6691: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6693: WHEN OTHERS THEN
6694: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);

Line 6692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6688:
6689: EXCEPTION
6690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6691: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6693: WHEN OTHERS THEN
6694: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6696:

Line 6695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6691: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6693: WHEN OTHERS THEN
6694: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP:'||sqlerrm);
6695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6696:
6697: END POST_CLEANUP;
6698:
6699: PROCEDURE POST_CLEANUP_LINE

Line 6759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6755:
6756: write_log('Leaving POST_CLEANUP_LINE');
6757:
6758: EXCEPTION
6759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6760: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);
6761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6762: WHEN OTHERS THEN
6763: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);

Line 6761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6757:
6758: EXCEPTION
6759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6760: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);
6761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6762: WHEN OTHERS THEN
6763: write_log( 'UNEXCPECTED ERROR IN PROCEDURE POST_CLEANUP_LINE:'||sqlerrm);
6764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6765:

Line 6764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 6891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6887: write_log('Leaving Validate_Lines');
6888:
6889: END IF;
6890: EXCEPTION
6891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6892: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
6893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6894: WHEN OTHERS THEN
6895: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);

Line 6893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6889: END IF;
6890: EXCEPTION
6891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6892: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
6893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6894: WHEN OTHERS THEN
6895: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
6896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6897:

Line 6896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6892: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
6893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6894: WHEN OTHERS THEN
6895: write_log( 'UNEXCPECTED ERROR IN PROCEDURE VALIDATE_LINES:'||sqlerrm);
6896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6897:
6898: END VALIDATE_LINES;
6899:
6900:

Line 7011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7007: END LOOP;
7008: write_log('Leaving Delete errored records parent');
7009:
7010: EXCEPTION
7011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7012: write_log(
7013: 'UNEXCPECTED ERROR IN PROCEDURE DELETE_ERRORED_RECORDS_PARENTS:'||sqlerrm);
7014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7015: WHEN OTHERS THEN

Line 7014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7010: EXCEPTION
7011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7012: write_log(
7013: 'UNEXCPECTED ERROR IN PROCEDURE DELETE_ERRORED_RECORDS_PARENTS:'||sqlerrm);
7014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7015: WHEN OTHERS THEN
7016: write_log(
7017: 'UNEXCPECTED ERROR IN PROCEDURE DELETE_ERRORED_RECORDS_PARENTS:'||sqlerrm);
7018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7015: WHEN OTHERS THEN
7016: write_log(
7017: 'UNEXCPECTED ERROR IN PROCEDURE DELETE_ERRORED_RECORDS_PARENTS:'||sqlerrm);
7018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7019: END Delete_errored_records_parents;
7020:
7021: PROCEDURE ERRORS_TO_OUTPUT
7022: (p_request_id NUMBER)

Line 7131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7127:
7128: write_log('Leaving Purging');
7129:
7130: EXCEPTION
7131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7132: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7134: WHEN OTHERS THEN
7135: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);

Line 7133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7129:
7130: EXCEPTION
7131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7132: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7134: WHEN OTHERS THEN
7135: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7137:

Line 7136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7132: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7134: WHEN OTHERS THEN
7135: write_log( 'UNEXCPECTED ERROR IN PROCEDURE PURGE:'||sqlerrm);
7136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7137:
7138: END PURGE;
7139:
7140: --Basic_Pricing_Condition