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

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

349: END validate_desc_flexfield_f;
350:
351:
352: PROCEDURE validate_DSS_security IS
353: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
354: dss_msg_count NUMBER := 0;
355: dss_msg_data VARCHAR2(2000):= null;
356: l_debug_prefix VARCHAR2(30) := '';
357: BEGIN

Line 540: decode(l_dss_security_errors(j), FND_API.G_FALSE,decode(l_party_type(j),'PERSON','P',

536: nvl2(l_own_rent_errors(j),'Y', null), --HZ_API_INVALID_LOOKUP,COLUMN,RENT_OWN_IND,LOOKUP_TYPE,OWN_RENT_IND
537: decode(l_flex_val_errors(j),'1', null, 'Y'), --????? AR_RAPI_DESC_FLEX_INVALID,DFF_NAME,HZ_PARTIES
538: nvl2(l_tca_party_id(j), nvl2(l_party_name(j),'Y', null), 'Y'), --HZ_IMP_PARTY_NAME_ERROR
539: -- Bug 3871136
540: decode(l_dss_security_errors(j), FND_API.G_FALSE,decode(l_party_type(j),'PERSON','P',
541: 'ORGANIZATION','O',null),'Y'), --HZ_DSS_SECURITY_FAIL
542: nvl2(l_tca_party_id(j),'Y', null), --HZ_API_NO_RECORD
543: -- Bug 4310257
544: decode(l_party_type(j), 'PERSON', nvl2(l_gender_errors(j),'Y', null), 'Y'), --HZ_API_INVALID_LOOKUP,COLUMN,GENDER,LOOKUP_TYPE,HZ_GENDER

Line 2784: x_return_status := FND_API.G_RET_STS_SUCCESS;

2780:
2781: FND_MSG_PUB.initialize;
2782:
2783: --Initialize API return status to success.
2784: x_return_status := FND_API.G_RET_STS_SUCCESS;
2785:
2786: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
2787:
2788: IF P_DML_RECORD.RERUN = 'N' /*** First Run ***/ THEN

Line 2926: x_return_status := FND_API.G_RET_STS_ERROR;

2922: ROLLBACK to process_insert_parties_pvt;
2923:
2924: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
2925:
2926: x_return_status := FND_API.G_RET_STS_ERROR;
2927:
2928: -- HZ_PARTIES_PK, HZ_PARTIES_U2
2929: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2930: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2935: ROLLBACK to process_insert_parties_pvt;
2936:
2937: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
2938:
2939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2940:
2941: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2943: FND_MSG_PUB.ADD;

Line 4267: x_return_status := FND_API.G_RET_STS_SUCCESS;

4263:
4264: l_party_name_profile := NVL(FND_PROFILE.value('AR_CHANGE_CUST_NAME'), 'Y');
4265:
4266: --Initialize API return status to success.
4267: x_return_status := FND_API.G_RET_STS_SUCCESS;
4268:
4269: -- l_version_profile := P_DML_RECORD.PROFILE_VERSION;
4270: --NEW_VERSION, NO_VERSION, ONE_DAY_VERSION
4271:

Line 9429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9425:
9426: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update parties other exception: ' || SQLERRM);
9427:
9428: ROLLBACK to process_update_parties_pvt;
9429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9430:
9431: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9432: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9433: FND_MSG_PUB.ADD;

Line 9548: x_return_status := FND_API.G_RET_STS_SUCCESS;

9544: p_msg_level=>fnd_log.level_procedure);
9545: END IF;
9546:
9547: --Initialize API return status to success.
9548: x_return_status := FND_API.G_RET_STS_SUCCESS;
9549:
9550: l_org_mixnmatch_enabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES',l_entity_attr_id);
9551: l_entity_attr_id := NULL; --Bug 10365551
9552:

Line 9568: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

9564: ,x_return_status => x_return_status
9565: ,x_msg_count => x_msg_count
9566: ,x_msg_data => x_msg_data
9567: );
9568: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
9569: process_update_parties(
9570: P_DML_RECORD => P_DML_RECORD
9571: ,x_return_status => x_return_status
9572: ,x_msg_count => x_msg_count

Line 9598: WHEN FND_API.G_EXC_ERROR THEN

9594: --disable_debug;
9595:
9596: EXCEPTION
9597:
9598: WHEN FND_API.G_EXC_ERROR THEN
9599: ROLLBACK TO load_parties_pvt;
9600: x_return_status := FND_API.G_RET_STS_ERROR;
9601: FND_MSG_PUB.Count_And_Get(
9602: p_encoded => FND_API.G_FALSE,

Line 9600: x_return_status := FND_API.G_RET_STS_ERROR;

9596: EXCEPTION
9597:
9598: WHEN FND_API.G_EXC_ERROR THEN
9599: ROLLBACK TO load_parties_pvt;
9600: x_return_status := FND_API.G_RET_STS_ERROR;
9601: FND_MSG_PUB.Count_And_Get(
9602: p_encoded => FND_API.G_FALSE,
9603: p_count => x_msg_count,
9604: p_data => x_msg_data);

Line 9602: p_encoded => FND_API.G_FALSE,

9598: WHEN FND_API.G_EXC_ERROR THEN
9599: ROLLBACK TO load_parties_pvt;
9600: x_return_status := FND_API.G_RET_STS_ERROR;
9601: FND_MSG_PUB.Count_And_Get(
9602: p_encoded => FND_API.G_FALSE,
9603: p_count => x_msg_count,
9604: p_data => x_msg_data);
9605:
9606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9602: p_encoded => FND_API.G_FALSE,
9603: p_count => x_msg_count,
9604: p_data => x_msg_data);
9605:
9606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9607: ROLLBACK TO load_parties_pvt;
9608: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9609: FND_FILE.put_line(fnd_file.log, l_errm);
9610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9607: ROLLBACK TO load_parties_pvt;
9608: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9609: FND_FILE.put_line(fnd_file.log, l_errm);
9610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9611: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9612: FND_MESSAGE.SET_TOKEN('ERROR', l_errm);
9613: FND_MSG_PUB.ADD;
9614: FND_MSG_PUB.Count_And_Get(

Line 9615: p_encoded => FND_API.G_FALSE,

9611: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9612: FND_MESSAGE.SET_TOKEN('ERROR', l_errm);
9613: FND_MSG_PUB.ADD;
9614: FND_MSG_PUB.Count_And_Get(
9615: p_encoded => FND_API.G_FALSE,
9616: p_count => x_msg_count,
9617: p_data => x_msg_data);
9618:
9619: WHEN OTHERS THEN

Line 9624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9620:
9621: ROLLBACK TO load_parties_pvt;
9622: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9623: FND_FILE.put_line(fnd_file.log, l_errm);
9624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9625: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9626: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9627: FND_MSG_PUB.ADD;
9628: FND_MSG_PUB.Count_And_Get(

Line 9629: p_encoded => FND_API.G_FALSE,

9625: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9626: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9627: FND_MSG_PUB.ADD;
9628: FND_MSG_PUB.Count_And_Get(
9629: p_encoded => FND_API.G_FALSE,
9630: p_count => x_msg_count,
9631: p_data => x_msg_data);
9632:
9633: END load_parties;