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 2783: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2922: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2931: ROLLBACK to process_insert_parties_pvt;
2932:
2933: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
2934:
2935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2936:
2937: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2938: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2939: FND_MSG_PUB.ADD;

Line 4261: x_return_status := FND_API.G_RET_STS_SUCCESS;

4257:
4258: l_party_name_profile := NVL(FND_PROFILE.value('AR_CHANGE_CUST_NAME'), 'Y');
4259:
4260: --Initialize API return status to success.
4261: x_return_status := FND_API.G_RET_STS_SUCCESS;
4262:
4263: -- l_version_profile := P_DML_RECORD.PROFILE_VERSION;
4264: --NEW_VERSION, NO_VERSION, ONE_DAY_VERSION
4265:

Line 9411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9407:
9408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update parties other exception: ' || SQLERRM);
9409:
9410: ROLLBACK to process_update_parties_pvt;
9411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9412:
9413: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9415: FND_MSG_PUB.ADD;

Line 9530: x_return_status := FND_API.G_RET_STS_SUCCESS;

9526: p_msg_level=>fnd_log.level_procedure);
9527: END IF;
9528:
9529: --Initialize API return status to success.
9530: x_return_status := FND_API.G_RET_STS_SUCCESS;
9531:
9532: l_org_mixnmatch_enabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_ORGANIZATION_PROFILES',l_entity_attr_id);
9533: l_per_mixnmatch_enabled := HZ_MIXNM_UTILITY.isMixNMatchEnabled('HZ_PERSON_PROFILES',l_entity_attr_id);
9534:

Line 9548: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

9544: ,x_return_status => x_return_status
9545: ,x_msg_count => x_msg_count
9546: ,x_msg_data => x_msg_data
9547: );
9548: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
9549: process_update_parties(
9550: P_DML_RECORD => P_DML_RECORD
9551: ,x_return_status => x_return_status
9552: ,x_msg_count => x_msg_count

Line 9578: WHEN FND_API.G_EXC_ERROR THEN

9574: --disable_debug;
9575:
9576: EXCEPTION
9577:
9578: WHEN FND_API.G_EXC_ERROR THEN
9579: ROLLBACK TO load_parties_pvt;
9580: x_return_status := FND_API.G_RET_STS_ERROR;
9581: FND_MSG_PUB.Count_And_Get(
9582: p_encoded => FND_API.G_FALSE,

Line 9580: x_return_status := FND_API.G_RET_STS_ERROR;

9576: EXCEPTION
9577:
9578: WHEN FND_API.G_EXC_ERROR THEN
9579: ROLLBACK TO load_parties_pvt;
9580: x_return_status := FND_API.G_RET_STS_ERROR;
9581: FND_MSG_PUB.Count_And_Get(
9582: p_encoded => FND_API.G_FALSE,
9583: p_count => x_msg_count,
9584: p_data => x_msg_data);

Line 9582: p_encoded => FND_API.G_FALSE,

9578: WHEN FND_API.G_EXC_ERROR THEN
9579: ROLLBACK TO load_parties_pvt;
9580: x_return_status := FND_API.G_RET_STS_ERROR;
9581: FND_MSG_PUB.Count_And_Get(
9582: p_encoded => FND_API.G_FALSE,
9583: p_count => x_msg_count,
9584: p_data => x_msg_data);
9585:
9586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9582: p_encoded => FND_API.G_FALSE,
9583: p_count => x_msg_count,
9584: p_data => x_msg_data);
9585:
9586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9587: ROLLBACK TO load_parties_pvt;
9588: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9589: FND_FILE.put_line(fnd_file.log, l_errm);
9590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9587: ROLLBACK TO load_parties_pvt;
9588: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9589: FND_FILE.put_line(fnd_file.log, l_errm);
9590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9591: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9592: FND_MESSAGE.SET_TOKEN('ERROR', l_errm);
9593: FND_MSG_PUB.ADD;
9594: FND_MSG_PUB.Count_And_Get(

Line 9595: p_encoded => FND_API.G_FALSE,

9591: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9592: FND_MESSAGE.SET_TOKEN('ERROR', l_errm);
9593: FND_MSG_PUB.ADD;
9594: FND_MSG_PUB.Count_And_Get(
9595: p_encoded => FND_API.G_FALSE,
9596: p_count => x_msg_count,
9597: p_data => x_msg_data);
9598:
9599: WHEN OTHERS THEN

Line 9604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9600:
9601: ROLLBACK TO load_parties_pvt;
9602: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading parties');
9603: FND_FILE.put_line(fnd_file.log, l_errm);
9604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9607: FND_MSG_PUB.ADD;
9608: FND_MSG_PUB.Count_And_Get(

Line 9609: p_encoded => FND_API.G_FALSE,

9605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
9606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
9607: FND_MSG_PUB.ADD;
9608: FND_MSG_PUB.Count_And_Get(
9609: p_encoded => FND_API.G_FALSE,
9610: p_count => x_msg_count,
9611: p_data => x_msg_data);
9612:
9613: END load_parties;