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

Line 379: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading addresses');

375: EXCEPTION
376: WHEN FND_API.G_EXC_ERROR THEN
377: ----dbms_output.put_line('===============G_EXC_ERROR error');
378: ROLLBACK TO load_addresses_pvt;
379: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading addresses');
380: FND_FILE.put_line(fnd_file.log, SQLERRM);
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get(
383: p_encoded => FND_API.G_FALSE,

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

376: WHEN FND_API.G_EXC_ERROR THEN
377: ----dbms_output.put_line('===============G_EXC_ERROR error');
378: ROLLBACK TO load_addresses_pvt;
379: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading addresses');
380: FND_FILE.put_line(fnd_file.log, SQLERRM);
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get(
383: p_encoded => FND_API.G_FALSE,
384: p_count => x_msg_count,

Line 402: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');

398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: ----dbms_output.put_line('================unexpected error');
400:
401: ROLLBACK TO load_addresses_pvt;
402: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
403: FND_FILE.put_line(fnd_file.log, SQLERRM);
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

399: ----dbms_output.put_line('================unexpected error');
400:
401: ROLLBACK TO load_addresses_pvt;
402: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
403: FND_FILE.put_line(fnd_file.log, SQLERRM);
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
407: FND_MSG_PUB.ADD;

Line 436: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');

432: p_prefix=>'ERROR',
433: p_msg_level=>fnd_log.level_error);
434: END IF;
435: ROLLBACK TO load_addresses_pvt;
436: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
437: FND_FILE.put_line(fnd_file.log, SQLERRM);
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
440: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

433: p_msg_level=>fnd_log.level_error);
434: END IF;
435: ROLLBACK TO load_addresses_pvt;
436: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
437: FND_FILE.put_line(fnd_file.log, SQLERRM);
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
440: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
441: FND_MSG_PUB.ADD;

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

1184: exception
1185: when DUP_VAL_ON_INDEX then
1186: ----dbms_output.put_line('=================dup val exception');
1187: ----dbms_output.put_line(sqlerrm);
1188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert addresses dup val exception: ' || SQLERRM);
1189: ROLLBACK to process_insert_addresses_pvt;
1190:
1191: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
1192: x_return_status := FND_API.G_RET_STS_ERROR;

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

1197: when others then
1198: ----dbms_output.put_line('===================other exception');
1199: ----dbms_output.put_line(sqlerrm);
1200:
1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert addresses other exception: ' || SQLERRM);
1202: ROLLBACK to process_insert_addresses_pvt;
1203:
1204: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'validate_DSS_security for address.');

1915: dss_msg_data VARCHAR2(2000):= null;
1916: l_debug_prefix VARCHAR2(30) := '';
1917: BEGIN
1918:
1919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'validate_DSS_security for address.');
1920:
1921: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1922: hz_utility_v2pub.debug(p_message=>'PTY:validate_DSS_security()+',
1923: p_prefix=>l_debug_prefix,

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

3020: END IF;
3021:
3022: EXCEPTION
3023: WHEN OTHERS THEN
3024: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update addresses other exception: ' || SQLERRM);
3025:
3026: ROLLBACK to process_update_addresses_pvt;
3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3028: