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

Line 107: x_return_status := FND_API.G_RET_STS_SUCCESS;

103: l_debug_prefix VARCHAR2(30) := '';
104: BEGIN
105: savepoint load_finreports_pvt;
106: FND_MSG_PUB.initialize;
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108:
109: --enable_debug;
110: -- Debug info.
111: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 120: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

116:
117: process_insert_reports(P_DML_RECORD,
118: x_return_status, x_msg_count, x_msg_data );
119:
120: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
121: process_update_reports(P_DML_RECORD,
122: x_return_status, x_msg_count, x_msg_data );
123: END IF;
124:

Line 135: WHEN FND_API.G_EXC_ERROR THEN

131: --disable_debug;
132:
133: EXCEPTION
134:
135: WHEN FND_API.G_EXC_ERROR THEN
136: --dbms_output.put_line('load finreport exception ' || SQLERRM);
137:
138: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial reports');
139: FND_FILE.put_line(fnd_file.log, SQLERRM);

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137:
138: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial reports');
139: FND_FILE.put_line(fnd_file.log, SQLERRM);
140: ROLLBACK TO load_finreports_pvt;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: FND_MSG_PUB.Count_And_Get(
143: p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data);

Line 143: p_encoded => FND_API.G_FALSE,

139: FND_FILE.put_line(fnd_file.log, SQLERRM);
140: ROLLBACK TO load_finreports_pvt;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: FND_MSG_PUB.Count_And_Get(
143: p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data);
146:
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

143: p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data);
146:
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: --dbms_output.put_line('load finreport exception ' || SQLERRM);
149:
150: ROLLBACK TO load_finreports_pvt;
151: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

149:
150: ROLLBACK TO load_finreports_pvt;
151: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');
152: FND_FILE.put_line(fnd_file.log, SQLERRM);
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
155: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
156: FND_MSG_PUB.ADD;
157: FND_MSG_PUB.Count_And_Get(

Line 158: p_encoded => FND_API.G_FALSE,

154: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
155: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
156: FND_MSG_PUB.ADD;
157: FND_MSG_PUB.Count_And_Get(
158: p_encoded => FND_API.G_FALSE,
159: p_count => x_msg_count,
160: p_data => x_msg_data);
161:
162: WHEN OTHERS THEN

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

173:
174: ROLLBACK TO load_finreports_pvt;
175: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial reports');
176: FND_FILE.put_line(fnd_file.log, SQLERRM);
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
179: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
180: FND_MSG_PUB.ADD;
181: FND_MSG_PUB.Count_And_Get(

Line 182: p_encoded => FND_API.G_FALSE,

178: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
179: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
180: FND_MSG_PUB.ADD;
181: FND_MSG_PUB.Count_And_Get(
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data);
185:
186: END load_finreports;

Line 491: x_return_status := FND_API.G_RET_STS_SUCCESS;

487: p_msg_level=>fnd_log.level_procedure);
488: END IF;
489:
490: savepoint process_insert_finreports_pvt;
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493: -- add clause for first-run/re-run
494: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
495: if(P_DML_RECORD.RERUN='N') then

Line 536: x_return_status := FND_API.G_RET_STS_ERROR;

532: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert fin reports dup val exception: ' || SQLERRM);
533: ROLLBACK to process_insert_finreports_pvt;
534:
535: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
536: x_return_status := FND_API.G_RET_STS_ERROR;
537:
538: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
539: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
540: FND_MSG_PUB.ADD;

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

544: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert fin reports other exception: ' || SQLERRM);
545: ROLLBACK to process_insert_finreports_pvt;
546:
547: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549:
550: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;

Line 662: x_return_status := FND_API.G_RET_STS_SUCCESS;

658: END IF;
659: savepoint process_update_reports_pvt;
660: FND_MSG_PUB.initialize;
661: --Initialize API return status to success.
662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663:
664: open_update_cursor(c_update_cursor, P_DML_RECORD);
665: fetch c_update_cursor bulk collect into
666: l_row_id,

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: WHEN OTHERS THEN
769: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update reports other exception: ' || SQLERRM);
770:
771: ROLLBACK to process_update_reports_pvt;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773:
774: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
776: FND_MSG_PUB.ADD;