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_API

Line 322: x_return_status := FND_API.G_RET_STS_SUCCESS;

318: l_debug_prefix VARCHAR2(30) := '';
319: BEGIN
320: savepoint load_addresses_pvt;
321: FND_MSG_PUB.initialize;
322: x_return_status := FND_API.G_RET_STS_SUCCESS;
323:
324: --enable_debug;
325: -- Debug info.
326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 351: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

347:
348: process_insert_addresses(P_DML_RECORD,
349: x_return_status, x_msg_count, x_msg_data );
350:
351: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
352: process_update_addresses(P_DML_RECORD, x_return_status,
353: x_msg_count, x_msg_data );
354: END IF;
355:

Line 376: WHEN FND_API.G_EXC_ERROR THEN

372:
373:
374: ----dbms_output.put_line('end of loading address');
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);

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

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,
385: p_data => x_msg_data);

Line 383: p_encoded => FND_API.G_FALSE,

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,
385: p_data => x_msg_data);
386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

394: p_prefix=>l_debug_prefix,
395: p_msg_level=>fnd_log.level_procedure);
396: END IF;
397:
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');

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_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;
408: FND_MSG_PUB.Count_And_Get(

Line 409: p_encoded => FND_API.G_FALSE,

405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
407: FND_MSG_PUB.ADD;
408: FND_MSG_PUB.Count_And_Get(
409: p_encoded => FND_API.G_FALSE,
410: p_count => x_msg_count,
411: p_data => x_msg_data);
412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_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;
442: FND_MSG_PUB.Count_And_Get(

Line 443: p_encoded => FND_API.G_FALSE,

439: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
440: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
441: FND_MSG_PUB.ADD;
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count,
445: p_data => x_msg_data);
446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 1004: x_return_status := FND_API.G_RET_STS_SUCCESS;

1000: p_msg_level=>fnd_log.level_procedure);
1001: END IF;
1002:
1003: savepoint process_insert_addresses_pvt;
1004: x_return_status := FND_API.G_RET_STS_SUCCESS;
1005:
1006: -- add clause for first run/re-run
1007: if(P_DML_RECORD.RERUN='N') then
1008: l_final_qry := l_sql_query || l_first_run_clause;

Line 1192: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1193:
1194: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1196: FND_MSG_PUB.ADD;

Line 1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1206:
1207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1208: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1209: FND_MSG_PUB.ADD;

Line 1913: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1909: END validate_desc_flexfield;
1910:
1911:
1912: PROCEDURE validate_DSS_security IS
1913: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1914: dss_msg_count NUMBER := 0;
1915: dss_msg_data VARCHAR2(2000):= null;
1916: l_debug_prefix VARCHAR2(30) := '';
1917: BEGIN

Line 1971: x_return_status := FND_API.G_RET_STS_SUCCESS;

1967:
1968: savepoint process_update_addresses_pvt;
1969: FND_MSG_PUB.initialize;
1970: --Initialize API return status to success.
1971: x_return_status := FND_API.G_RET_STS_SUCCESS;
1972: open_update_cursor(c_update_cursor, P_DML_RECORD);
1973:
1974: if(l_allow_std_update= 'Y') then
1975: fetch c_update_cursor BULK COLLECT INTO

Line 3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
3029: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3030: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3031: FND_MSG_PUB.ADD;

Line 3159: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null) E8_FLAG, -- e8

3155: decode(l_allow_correction, 'N', null, 'Y'), 'Y'), 'Y') E7_FLAG,
3156: nvl2(l_error_flag(j), DECODE(l_error_flag(j),2,'Y', null), 'Y') E10_FLAG, -- e10
3157: l_exception_exists(j) OTHER_EXCEP_FLAG,
3158: nvl2(l_owner_table_id(j),'Y',null) MISSING_PARENT_FLAG,
3159: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null) E8_FLAG, -- e8
3160: l_third_party_update_error(j) E9_FLAG, --e9
3161: l_createdby_errors(j) E11_FLAG
3162: from dual
3163: where l_num_row_processed(j) = 0