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

Line 368: x_return_status := FND_API.G_RET_STS_SUCCESS;

364:
365: FND_MSG_PUB.initialize;
366:
367: --Initialize API return status to success.
368: x_return_status := FND_API.G_RET_STS_SUCCESS;
369:
370: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
371: IF P_DML_RECORD.RERUN = 'N' THEN
372: l_final_sql := l_insert_sql || l_where_first_run_sql;

Line 429: x_return_status := FND_API.G_RET_STS_ERROR;

425: WHEN DUP_VAL_ON_INDEX THEN
426: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert contactroles dup val exception: ' || SQLERRM);
427: ROLLBACK to load_contactroles_pvt;
428: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
432: FND_MSG_PUB.ADD;
433: FND_MSG_PUB.Count_And_Get(

Line 434: p_encoded => FND_API.G_FALSE,

430: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
432: FND_MSG_PUB.ADD;
433: FND_MSG_PUB.Count_And_Get(
434: p_encoded => FND_API.G_FALSE,
435: p_count => x_msg_count,
436: p_data => x_msg_data);
437:
438: WHEN OTHERS THEN

Line 442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

438: WHEN OTHERS THEN
439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert contactroles other exception: ' || SQLERRM);
440: ROLLBACK TO load_contactroles_pvt;
441: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
445: FND_MSG_PUB.ADD;
446: FND_MSG_PUB.Count_And_Get(

Line 447: p_encoded => FND_API.G_FALSE,

443: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
445: FND_MSG_PUB.ADD;
446: FND_MSG_PUB.Count_And_Get(
447: p_encoded => FND_API.G_FALSE,
448: p_count => x_msg_count,
449: p_data => x_msg_data);
450:
451: END process_insert_contactroles;

Line 482: x_return_status := FND_API.G_RET_STS_SUCCESS;

478:
479: FND_MSG_PUB.initialize;
480:
481: --Initialize API return status to success.
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483:
484: process_insert_contactroles
485: (
486: P_DML_RECORD => P_DML_RECORD

Line 501: WHEN FND_API.G_EXC_ERROR THEN

497: -- if enabled, disable debug
498: --disable_debug;
499:
500: EXCEPTION
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO load_contactroles_pvt;
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: FND_MSG_PUB.Count_And_Get(
505: p_encoded => FND_API.G_FALSE,

Line 503: x_return_status := FND_API.G_RET_STS_ERROR;

499:
500: EXCEPTION
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO load_contactroles_pvt;
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: FND_MSG_PUB.Count_And_Get(
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data);

Line 505: p_encoded => FND_API.G_FALSE,

501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO load_contactroles_pvt;
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: FND_MSG_PUB.Count_And_Get(
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO load_contactroles_pvt;
511: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
512: FND_FILE.put_line(fnd_file.log, l_errm);
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO load_contactroles_pvt;
511: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
512: FND_FILE.put_line(fnd_file.log, l_errm);
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
516: FND_MSG_PUB.ADD;
517: FND_MSG_PUB.Count_And_Get(

Line 518: p_encoded => FND_API.G_FALSE,

514: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
516: FND_MSG_PUB.ADD;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data);
521:
522: WHEN OTHERS THEN

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: WHEN OTHERS THEN
523: ROLLBACK TO load_contactroles_pvt;
524: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactroles');
525: FND_FILE.put_line(fnd_file.log, l_errm);
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
529: FND_MSG_PUB.ADD;
530: FND_MSG_PUB.Count_And_Get(

Line 531: p_encoded => FND_API.G_FALSE,

527: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
528: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
529: FND_MSG_PUB.ADD;
530: FND_MSG_PUB.Count_And_Get(
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => x_msg_data);
534:
535: END load_contactroles;