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_FINNUMBERS_PKG dependencies on FND_FILE

Line 106: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial numbers');

102: WHEN FND_API.G_EXC_ERROR THEN
103: ----dbms_output.put_line('G_EXC_ERROR');
104:
105: ROLLBACK TO load_finnumbers_pvt;
106: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial numbers');
107: FND_FILE.put_line(fnd_file.log, SQLERRM);
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: FND_MSG_PUB.Count_And_Get(
110: p_encoded => FND_API.G_FALSE,

Line 107: FND_FILE.put_line(fnd_file.log, SQLERRM);

103: ----dbms_output.put_line('G_EXC_ERROR');
104:
105: ROLLBACK TO load_finnumbers_pvt;
106: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial numbers');
107: FND_FILE.put_line(fnd_file.log, SQLERRM);
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: FND_MSG_PUB.Count_And_Get(
110: p_encoded => FND_API.G_FALSE,
111: p_count => x_msg_count,

Line 118: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial numbers');

114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
115: ----dbms_output.put_line('Unexpected error occurs while loading financial numbers');
116:
117: ROLLBACK TO load_finnumbers_pvt;
118: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial numbers');
119: FND_FILE.put_line(fnd_file.log, SQLERRM);
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
122: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

Line 119: FND_FILE.put_line(fnd_file.log, SQLERRM);

115: ----dbms_output.put_line('Unexpected error occurs while loading financial numbers');
116:
117: ROLLBACK TO load_finnumbers_pvt;
118: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial numbers');
119: FND_FILE.put_line(fnd_file.log, SQLERRM);
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
122: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
123: FND_MSG_PUB.ADD;

Line 141: FND_FILE.put_line(fnd_file.log,'Unexpected other errors occurs while loading financial numbers');

137: END IF;
138: ----dbms_output.put_line('load_finnumbers Exception: ');
139:
140: ROLLBACK TO load_finnumbers_pvt;
141: FND_FILE.put_line(fnd_file.log,'Unexpected other errors occurs while loading financial numbers');
142: FND_FILE.put_line(fnd_file.log, SQLERRM);
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 142: FND_FILE.put_line(fnd_file.log, SQLERRM);

138: ----dbms_output.put_line('load_finnumbers Exception: ');
139:
140: ROLLBACK TO load_finnumbers_pvt;
141: FND_FILE.put_line(fnd_file.log,'Unexpected other errors occurs while loading financial numbers');
142: FND_FILE.put_line(fnd_file.log, SQLERRM);
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
146: FND_MSG_PUB.ADD;

Line 432: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert finnumbers dup val exception: ' || SQLERRM);

428: END IF;
429:
430: EXCEPTION
431: WHEN DUP_VAL_ON_INDEX THEN
432: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert finnumbers dup val exception: ' || SQLERRM);
433: ROLLBACK to process_insert_finnumbers_pvt;
434:
435: populate_error_table(P_DML_RECORD, 'Y');
436: x_return_status := FND_API.G_RET_STS_ERROR;

Line 443: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert finnumbers other exception: ' || SQLERRM);

439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
440: FND_MSG_PUB.ADD;
441: WHEN OTHERS THEN
442:
443: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert finnumbers other exception: ' || SQLERRM);
444: ROLLBACK to process_insert_finnumbers_pvt;
445:
446: populate_error_table(P_DML_RECORD, 'N');
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 601: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update finnumbers other exception: ' || SQLERRM);

597:
598: EXCEPTION
599: WHEN OTHERS THEN
600: ----dbms_output.put_line('Update finnumbers other exception: ' || SQLERRM);
601: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update finnumbers other exception: ' || SQLERRM);
602:
603: ROLLBACK to process_update_finnumbers_pvt;
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605: