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.HZ_IMP_LOAD_PARTY_SITE_USE_PKG dependencies on FND_API

Line 353: x_return_status := FND_API.G_RET_STS_SUCCESS;

349:
350: FND_MSG_PUB.initialize;
351:
352: --Initialize API return status to success.
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354:
355: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
356: IF P_DML_RECORD.RERUN = 'N' THEN
357: l_final_sql := l_insert_sql || l_where_first_run_sql;

Line 414: x_return_status := FND_API.G_RET_STS_ERROR;

410: WHEN DUP_VAL_ON_INDEX THEN
411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert partysiteuses dup val exception: ' || SQLERRM);
412: ROLLBACK to process_insert_psu_pvt;
413: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
417: FND_MSG_PUB.ADD;
418: FND_MSG_PUB.Count_And_Get(

Line 419: p_encoded => FND_API.G_FALSE,

415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
417: FND_MSG_PUB.ADD;
418: FND_MSG_PUB.Count_And_Get(
419: p_encoded => FND_API.G_FALSE,
420: p_count => x_msg_count,
421: p_data => x_msg_data);
422:
423: WHEN OTHERS THEN

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423: WHEN OTHERS THEN
424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert partysiteuses other exception: ' || SQLERRM);
425: ROLLBACK TO process_insert_psu_pvt;
426: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(

Line 432: p_encoded => FND_API.G_FALSE,

428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
429: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
430: FND_MSG_PUB.ADD;
431: FND_MSG_PUB.Count_And_Get(
432: p_encoded => FND_API.G_FALSE,
433: p_count => x_msg_count,
434: p_data => x_msg_data);
435:
436: END process_insert_partysiteuses;

Line 467: x_return_status := FND_API.G_RET_STS_SUCCESS;

463:
464: FND_MSG_PUB.initialize;
465:
466: --Initialize API return status to success.
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468:
469: process_insert_partysiteuses
470: (
471: P_DML_RECORD => P_DML_RECORD

Line 487: WHEN FND_API.G_EXC_ERROR THEN

483: --disable_debug;
484:
485: EXCEPTION
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO load_partysiteuses_pvt;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MSG_PUB.Count_And_Get(
491: p_encoded => FND_API.G_FALSE,

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: EXCEPTION
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO load_partysiteuses_pvt;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MSG_PUB.Count_And_Get(
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data);

Line 491: p_encoded => FND_API.G_FALSE,

487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO load_partysiteuses_pvt;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MSG_PUB.Count_And_Get(
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data);
494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data);
494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: ROLLBACK TO load_partysiteuses_pvt;
497: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
498: FND_FILE.put_line(fnd_file.log, l_errm);
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: ROLLBACK TO load_partysiteuses_pvt;
497: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
498: FND_FILE.put_line(fnd_file.log, l_errm);
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
501: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
502: FND_MSG_PUB.ADD;
503: FND_MSG_PUB.Count_And_Get(

Line 504: p_encoded => FND_API.G_FALSE,

500: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
501: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
502: FND_MSG_PUB.ADD;
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data);
507:
508: WHEN OTHERS THEN

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517:
518: ROLLBACK TO load_partysiteuses_pvt;
519: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');
520: FND_FILE.put_line(fnd_file.log, l_errm);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
524: FND_MSG_PUB.ADD;
525: FND_MSG_PUB.Count_And_Get(

Line 526: p_encoded => FND_API.G_FALSE,

522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
524: FND_MSG_PUB.ADD;
525: FND_MSG_PUB.Count_And_Get(
526: p_encoded => FND_API.G_FALSE,
527: p_count => x_msg_count,
528: p_data => x_msg_data);
529:
530: END load_partysiteuses;