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

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

276:
277: END validate_desc_flexfield_f;
278:
279: PROCEDURE validate_DSS_security IS
280: dss_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
281: dss_msg_count NUMBER := 0;
282: dss_msg_data VARCHAR2(2000):= null;
283: BEGIN
284: /* Check if the DSS security is granted to the user.

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

408: hz_utility_v2pub.debug(p_message=>'CPT:exception is:'||l_errm,
409: p_prefix=>'ERROR',
410: p_msg_level=>fnd_log.level_error);
411: END IF;
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF; -- error code 1 check ends
414:
415: -- increment the total errors count and go to next exception
416: n := n+1;

Line 512: decode(l_dss_security_errors(j),FND_API.G_FALSE,

508: 'Y',
509: 'Y',
510: 'Y',
511: l_cpt_type_updatable_error(j),
512: decode(l_dss_security_errors(j),FND_API.G_FALSE,
513: nvl2(l_party_orig_system_reference(j),'P',nvl2(l_site_orig_system_reference(j),'S','P')),'Y'),
514: l_cp_purpose_web_err(j),
515: l_third_party_update_error(j),
516: l_createdby_errors(j)

Line 1122: x_return_status := FND_API.G_RET_STS_SUCCESS;

1118:
1119: FND_MSG_PUB.initialize;
1120:
1121: --Initialize API return status to success.
1122: x_return_status := FND_API.G_RET_STS_SUCCESS;
1123:
1124:
1125: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
1126: IF P_DML_RECORD.RERUN = 'N' THEN

Line 1320: WHEN FND_API.G_EXC_ERROR THEN

1316: END IF;
1317:
1318: EXCEPTION
1319:
1320: WHEN FND_API.G_EXC_ERROR THEN
1321:
1322: ROLLBACK TO process_insert_cpt_pvt;
1323: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
1324: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1324: x_return_status := FND_API.G_RET_STS_ERROR;

1320: WHEN FND_API.G_EXC_ERROR THEN
1321:
1322: ROLLBACK TO process_insert_cpt_pvt;
1323: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
1324: x_return_status := FND_API.G_RET_STS_ERROR;
1325: FND_MSG_PUB.Count_And_Get(
1326: p_encoded => FND_API.G_FALSE,
1327: p_count => x_msg_count,
1328: p_data => x_msg_data);

Line 1326: p_encoded => FND_API.G_FALSE,

1322: ROLLBACK TO process_insert_cpt_pvt;
1323: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
1324: x_return_status := FND_API.G_RET_STS_ERROR;
1325: FND_MSG_PUB.Count_And_Get(
1326: p_encoded => FND_API.G_FALSE,
1327: p_count => x_msg_count,
1328: p_data => x_msg_data);
1329:
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1326: p_encoded => FND_API.G_FALSE,
1327: p_count => x_msg_count,
1328: p_data => x_msg_data);
1329:
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331:
1332: ROLLBACK TO process_insert_cpt_pvt;
1333: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331:
1332: ROLLBACK TO process_insert_cpt_pvt;
1333: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: FND_MSG_PUB.Count_And_Get(
1336: p_encoded => FND_API.G_FALSE,
1337: p_count => x_msg_count,
1338: p_data => x_msg_data);

Line 1336: p_encoded => FND_API.G_FALSE,

1332: ROLLBACK TO process_insert_cpt_pvt;
1333: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: FND_MSG_PUB.Count_And_Get(
1336: p_encoded => FND_API.G_FALSE,
1337: p_count => x_msg_count,
1338: p_data => x_msg_data);
1339:
1340: WHEN OTHERS THEN

Line 1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1341:
1342: ROLLBACK TO process_insert_cpt_pvt;
1343: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactpoints in process_insert_contactpoints');
1344: FND_FILE.put_line(fnd_file.log, SQLERRM);
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1347: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1348: FND_MSG_PUB.ADD;
1349: FND_MSG_PUB.Count_And_Get(

Line 1350: p_encoded => FND_API.G_FALSE,

1346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1347: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1348: FND_MSG_PUB.ADD;
1349: FND_MSG_PUB.Count_And_Get(
1350: p_encoded => FND_API.G_FALSE,
1351: p_count => x_msg_count,
1352: p_data => x_msg_data);
1353:
1354: END process_insert_contactpoints;

Line 1595: x_return_status := FND_API.G_RET_STS_SUCCESS;

1591:
1592: FND_MSG_PUB.initialize;
1593:
1594: --Initialize API return status to success.
1595: x_return_status := FND_API.G_RET_STS_SUCCESS;
1596:
1597: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
1598: IF P_DML_RECORD.RERUN = 'N' THEN
1599: -- First run with disabled lookup

Line 1961: WHEN FND_API.G_EXC_ERROR THEN

1957: END IF;
1958:
1959: EXCEPTION
1960:
1961: WHEN FND_API.G_EXC_ERROR THEN
1962: ROLLBACK TO process_update_cpts_pvt;
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: FND_MSG_PUB.Count_And_Get(
1965: p_encoded => FND_API.G_FALSE,

Line 1963: x_return_status := FND_API.G_RET_STS_ERROR;

1959: EXCEPTION
1960:
1961: WHEN FND_API.G_EXC_ERROR THEN
1962: ROLLBACK TO process_update_cpts_pvt;
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: FND_MSG_PUB.Count_And_Get(
1965: p_encoded => FND_API.G_FALSE,
1966: p_count => x_msg_count,
1967: p_data => x_msg_data);

Line 1965: p_encoded => FND_API.G_FALSE,

1961: WHEN FND_API.G_EXC_ERROR THEN
1962: ROLLBACK TO process_update_cpts_pvt;
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: FND_MSG_PUB.Count_And_Get(
1965: p_encoded => FND_API.G_FALSE,
1966: p_count => x_msg_count,
1967: p_data => x_msg_data);
1968:
1969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1965: p_encoded => FND_API.G_FALSE,
1966: p_count => x_msg_count,
1967: p_data => x_msg_data);
1968:
1969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1970: ROLLBACK TO process_update_cpts_pvt;
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: FND_MSG_PUB.Count_And_Get(
1973: p_encoded => FND_API.G_FALSE,

Line 1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1967: p_data => x_msg_data);
1968:
1969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1970: ROLLBACK TO process_update_cpts_pvt;
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: FND_MSG_PUB.Count_And_Get(
1973: p_encoded => FND_API.G_FALSE,
1974: p_count => x_msg_count,
1975: p_data => x_msg_data);

Line 1973: p_encoded => FND_API.G_FALSE,

1969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1970: ROLLBACK TO process_update_cpts_pvt;
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: FND_MSG_PUB.Count_And_Get(
1973: p_encoded => FND_API.G_FALSE,
1974: p_count => x_msg_count,
1975: p_data => x_msg_data);
1976:
1977: WHEN OTHERS THEN

Line 1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1977: WHEN OTHERS THEN
1978: ROLLBACK TO process_update_cpts_pvt;
1979: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while updating contactpoints');
1980: FND_FILE.put_line(fnd_file.log, l_errm);
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1983: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1984: FND_MSG_PUB.ADD;
1985: FND_MSG_PUB.Count_And_Get(

Line 1986: p_encoded => FND_API.G_FALSE,

1982: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1983: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1984: FND_MSG_PUB.ADD;
1985: FND_MSG_PUB.Count_And_Get(
1986: p_encoded => FND_API.G_FALSE,
1987: p_count => x_msg_count,
1988: p_data => x_msg_data);
1989:
1990:

Line 2030: x_return_status := FND_API.G_RET_STS_SUCCESS;

2026: /**** ?? Remove later. Disable policy function ***/
2027: --hz_common_pub.disable_cont_source_security; Bug No:3387220
2028:
2029: --Initialize API return status to success.
2030: x_return_status := FND_API.G_RET_STS_SUCCESS;
2031:
2032: process_insert_contactpoints
2033: (
2034: P_DML_RECORD =>P_DML_RECORD

Line 2059: WHEN FND_API.G_EXC_ERROR THEN

2055: --disable_debug;
2056:
2057: EXCEPTION
2058:
2059: WHEN FND_API.G_EXC_ERROR THEN
2060: ROLLBACK TO load_contactpoints_pvt;
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: FND_MSG_PUB.Count_And_Get(
2063: p_encoded => FND_API.G_FALSE,

Line 2061: x_return_status := FND_API.G_RET_STS_ERROR;

2057: EXCEPTION
2058:
2059: WHEN FND_API.G_EXC_ERROR THEN
2060: ROLLBACK TO load_contactpoints_pvt;
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: FND_MSG_PUB.Count_And_Get(
2063: p_encoded => FND_API.G_FALSE,
2064: p_count => x_msg_count,
2065: p_data => x_msg_data);

Line 2063: p_encoded => FND_API.G_FALSE,

2059: WHEN FND_API.G_EXC_ERROR THEN
2060: ROLLBACK TO load_contactpoints_pvt;
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: FND_MSG_PUB.Count_And_Get(
2063: p_encoded => FND_API.G_FALSE,
2064: p_count => x_msg_count,
2065: p_data => x_msg_data);
2066: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2067: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 2079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2075: p_msg_level=>fnd_log.level_procedure);
2076: END IF;
2077:
2078:
2079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2080:
2081: ROLLBACK TO load_contactpoints_pvt;
2082: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactpoints');
2083: FND_FILE.put_line(fnd_file.log, l_errm);

Line 2084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2080:
2081: ROLLBACK TO load_contactpoints_pvt;
2082: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactpoints');
2083: FND_FILE.put_line(fnd_file.log, l_errm);
2084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2085: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2086: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
2087: FND_MSG_PUB.ADD;
2088: FND_MSG_PUB.Count_And_Get(

Line 2089: p_encoded => FND_API.G_FALSE,

2085: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2086: FND_MESSAGE.SET_TOKEN('ERROR' ,l_errm);
2087: FND_MSG_PUB.ADD;
2088: FND_MSG_PUB.Count_And_Get(
2089: p_encoded => FND_API.G_FALSE,
2090: p_count => x_msg_count,
2091: p_data => x_msg_data);
2092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2093: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2104: WHEN OTHERS THEN
2105: ROLLBACK TO load_contactpoints_pvt;
2106: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactpoints');
2107: FND_FILE.put_line(fnd_file.log, l_errm);
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2109: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2111: FND_MSG_PUB.ADD;
2112: FND_MSG_PUB.Count_And_Get(

Line 2113: p_encoded => FND_API.G_FALSE,

2109: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2111: FND_MSG_PUB.ADD;
2112: FND_MSG_PUB.Count_And_Get(
2113: p_encoded => FND_API.G_FALSE,
2114: p_count => x_msg_count,
2115: p_data => x_msg_data);
2116: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2117: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,