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

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

199: END validate_desc_flexfield_f;
200:
201:
202: PROCEDURE validate_DSS_security IS
203: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
204: dss_msg_count NUMBER := 0;
205: dss_msg_data VARCHAR2(2000):= null;
206: l_debug_prefix VARCHAR2(30) := '';
207:

Line 340: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null), --HZ_DSS_SECURITY_FAIL,USER_NAME,FND_GLOBAL.user_name,OPER_NAME,UPDATE,OBJECT_NAME,HZ_RELATIONSHIPS

336: nvl2(l_object_id(j), 'Y', null), --HZ_IMP_REL_SUBJ_OBJ_ERROR,SUB_OR_OBJ,OBJECT
337: decode(l_subject_id(j), null, 'Y',
338: decode(l_object_id(j), null, 'Y', nvl2(l_relationship_type(j), 'Y', null))), --HZ_IMP_REL_TYPE_ERROR
339: decode(l_flex_val_errors(j), 1, null, 'Y'), --AR_RAPI_DESC_FLEX_INVALID,DFF_NAME,HZ_RELATIONSHIPS
340: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null), --HZ_DSS_SECURITY_FAIL,USER_NAME,FND_GLOBAL.user_name,OPER_NAME,UPDATE,OBJECT_NAME,HZ_RELATIONSHIPS
341: 'Y',
342: nvl2(l_action_mismatch_errors(j), 'Y', null), --HZ_IMP_ACTION_MISMATCH
343: l_exception_exists(j)
344: from dual

Line 1152: x_return_status := FND_API.G_RET_STS_SUCCESS;

1148:
1149: FND_MSG_PUB.initialize;
1150:
1151: --Initialize API return status to success.
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;
1153:
1154: IF l_actual_content_source <> 'USER_ENTERED' THEN
1155: l_insert_sql2 := l_insert_sql2 || l_dnb_rel_sql;
1156: END IF;

Line 1307: x_return_status := FND_API.G_RET_STS_ERROR;

1303: ROLLBACK to process_insert_rels_pvt;
1304:
1305: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
1306:
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308:
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1310: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1311: FND_MSG_PUB.ADD;

Line 1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1316: ROLLBACK to process_insert_rels_pvt;
1317:
1318: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1319:
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321:
1322: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1323: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1324: FND_MSG_PUB.ADD;

Line 1411: x_return_status := FND_API.G_RET_STS_SUCCESS;

1407:
1408: FND_MSG_PUB.initialize;
1409:
1410: --Initialize API return status to success.
1411: x_return_status := FND_API.G_RET_STS_SUCCESS;
1412:
1413: IF P_DML_RECORD.RERUN = 'N' /*** First Run ***/ THEN
1414:
1415: IF l_actual_content_source <> 'USER_ENTERED' THEN

Line 1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1670: ROLLBACK to process_update_rels_pvt;
1671:
1672: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1673:
1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1675:
1676: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1677: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1678: FND_MSG_PUB.ADD;

Line 1713: x_return_status := FND_API.G_RET_STS_SUCCESS;

1709: p_prefix=>l_debug_prefix,
1710: p_msg_level=>fnd_log.level_procedure);
1711: END IF;
1712: --Initialize API return status to success.
1713: x_return_status := FND_API.G_RET_STS_SUCCESS;
1714:
1715: l_actual_content_source := P_DML_RECORD.ACTUAL_CONTENT_SRC;
1716: l_no_end_date := TO_DATE('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS');
1717:

Line 1725: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1721: ,x_msg_count => x_msg_count
1722: ,x_msg_data => x_msg_data
1723: );
1724:
1725: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1726: process_update_rels(
1727: P_DML_RECORD => P_DML_RECORD
1728: ,x_return_status => x_return_status
1729: ,x_msg_count => x_msg_count

Line 1745: WHEN FND_API.G_EXC_ERROR THEN

1741: --disable_debug;
1742:
1743: EXCEPTION
1744:
1745: WHEN FND_API.G_EXC_ERROR THEN
1746: ROLLBACK TO load_rels_pvt;
1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748: FND_MSG_PUB.Count_And_Get(
1749: p_encoded => FND_API.G_FALSE,

Line 1747: x_return_status := FND_API.G_RET_STS_ERROR;

1743: EXCEPTION
1744:
1745: WHEN FND_API.G_EXC_ERROR THEN
1746: ROLLBACK TO load_rels_pvt;
1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748: FND_MSG_PUB.Count_And_Get(
1749: p_encoded => FND_API.G_FALSE,
1750: p_count => x_msg_count,
1751: p_data => x_msg_data);

Line 1749: p_encoded => FND_API.G_FALSE,

1745: WHEN FND_API.G_EXC_ERROR THEN
1746: ROLLBACK TO load_rels_pvt;
1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748: FND_MSG_PUB.Count_And_Get(
1749: p_encoded => FND_API.G_FALSE,
1750: p_count => x_msg_count,
1751: p_data => x_msg_data);
1752:
1753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1749: p_encoded => FND_API.G_FALSE,
1750: p_count => x_msg_count,
1751: p_data => x_msg_data);
1752:
1753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1754: ROLLBACK TO load_rels_pvt;
1755: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading relationships');
1756: FND_FILE.put_line(fnd_file.log, l_errm);
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1754: ROLLBACK TO load_rels_pvt;
1755: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading relationships');
1756: FND_FILE.put_line(fnd_file.log, l_errm);
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1759: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
1760: FND_MSG_PUB.ADD;
1761: FND_MSG_PUB.Count_And_Get(

Line 1762: p_encoded => FND_API.G_FALSE,

1758: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1759: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
1760: FND_MSG_PUB.ADD;
1761: FND_MSG_PUB.Count_And_Get(
1762: p_encoded => FND_API.G_FALSE,
1763: p_count => x_msg_count,
1764: p_data => x_msg_data);
1765:
1766: WHEN OTHERS THEN

Line 1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1766: WHEN OTHERS THEN
1767: ROLLBACK TO load_rels_pvt;
1768: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading relationships');
1769: FND_FILE.put_line(fnd_file.log, l_errm);
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1773: FND_MSG_PUB.ADD;
1774: FND_MSG_PUB.Count_And_Get(

Line 1775: p_encoded => FND_API.G_FALSE,

1771: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1773: FND_MSG_PUB.ADD;
1774: FND_MSG_PUB.Count_And_Get(
1775: p_encoded => FND_API.G_FALSE,
1776: p_count => x_msg_count,
1777: p_data => x_msg_data);
1778:
1779: END load_relationships;