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 1982: WHEN FND_API.G_EXC_ERROR THEN

1978: END IF;
1979:
1980: EXCEPTION
1981:
1982: WHEN FND_API.G_EXC_ERROR THEN
1983: ROLLBACK TO process_update_cpts_pvt;
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: FND_MSG_PUB.Count_And_Get(
1986: p_encoded => FND_API.G_FALSE,

Line 1984: x_return_status := FND_API.G_RET_STS_ERROR;

1980: EXCEPTION
1981:
1982: WHEN FND_API.G_EXC_ERROR THEN
1983: ROLLBACK TO process_update_cpts_pvt;
1984: x_return_status := FND_API.G_RET_STS_ERROR;
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);

Line 1986: p_encoded => FND_API.G_FALSE,

1982: WHEN FND_API.G_EXC_ERROR THEN
1983: ROLLBACK TO process_update_cpts_pvt;
1984: x_return_status := FND_API.G_RET_STS_ERROR;
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1986: p_encoded => FND_API.G_FALSE,
1987: p_count => x_msg_count,
1988: p_data => x_msg_data);
1989:
1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1991: ROLLBACK TO process_update_cpts_pvt;
1992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1993: FND_MSG_PUB.Count_And_Get(
1994: p_encoded => FND_API.G_FALSE,

Line 1992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1988: p_data => x_msg_data);
1989:
1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1991: ROLLBACK TO process_update_cpts_pvt;
1992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1993: FND_MSG_PUB.Count_And_Get(
1994: p_encoded => FND_API.G_FALSE,
1995: p_count => x_msg_count,
1996: p_data => x_msg_data);

Line 1994: p_encoded => FND_API.G_FALSE,

1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1991: ROLLBACK TO process_update_cpts_pvt;
1992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1993: FND_MSG_PUB.Count_And_Get(
1994: p_encoded => FND_API.G_FALSE,
1995: p_count => x_msg_count,
1996: p_data => x_msg_data);
1997:
1998: WHEN OTHERS THEN

Line 2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1998: WHEN OTHERS THEN
1999: ROLLBACK TO process_update_cpts_pvt;
2000: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while updating contactpoints');
2001: FND_FILE.put_line(fnd_file.log, l_errm);
2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2003: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2004: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2005: FND_MSG_PUB.ADD;
2006: FND_MSG_PUB.Count_And_Get(

Line 2007: p_encoded => FND_API.G_FALSE,

2003: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2004: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2005: FND_MSG_PUB.ADD;
2006: FND_MSG_PUB.Count_And_Get(
2007: p_encoded => FND_API.G_FALSE,
2008: p_count => x_msg_count,
2009: p_data => x_msg_data);
2010:
2011:

Line 2051: x_return_status := FND_API.G_RET_STS_SUCCESS;

2047: /**** ?? Remove later. Disable policy function ***/
2048: --hz_common_pub.disable_cont_source_security; Bug No:3387220
2049:
2050: --Initialize API return status to success.
2051: x_return_status := FND_API.G_RET_STS_SUCCESS;
2052:
2053: process_insert_contactpoints
2054: (
2055: P_DML_RECORD =>P_DML_RECORD

Line 2080: WHEN FND_API.G_EXC_ERROR THEN

2076: --disable_debug;
2077:
2078: EXCEPTION
2079:
2080: WHEN FND_API.G_EXC_ERROR THEN
2081: ROLLBACK TO load_contactpoints_pvt;
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: FND_MSG_PUB.Count_And_Get(
2084: p_encoded => FND_API.G_FALSE,

Line 2082: x_return_status := FND_API.G_RET_STS_ERROR;

2078: EXCEPTION
2079:
2080: WHEN FND_API.G_EXC_ERROR THEN
2081: ROLLBACK TO load_contactpoints_pvt;
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: FND_MSG_PUB.Count_And_Get(
2084: p_encoded => FND_API.G_FALSE,
2085: p_count => x_msg_count,
2086: p_data => x_msg_data);

Line 2084: p_encoded => FND_API.G_FALSE,

2080: WHEN FND_API.G_EXC_ERROR THEN
2081: ROLLBACK TO load_contactpoints_pvt;
2082: x_return_status := FND_API.G_RET_STS_ERROR;
2083: FND_MSG_PUB.Count_And_Get(
2084: p_encoded => FND_API.G_FALSE,
2085: p_count => x_msg_count,
2086: p_data => x_msg_data);
2087: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2088: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 2100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2096: p_msg_level=>fnd_log.level_procedure);
2097: END IF;
2098:
2099:
2100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2101:
2102: ROLLBACK TO load_contactpoints_pvt;
2103: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactpoints');
2104: FND_FILE.put_line(fnd_file.log, l_errm);

Line 2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2110: p_encoded => FND_API.G_FALSE,

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

Line 2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2125: WHEN OTHERS THEN
2126: ROLLBACK TO load_contactpoints_pvt;
2127: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactpoints');
2128: FND_FILE.put_line(fnd_file.log, l_errm);
2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2132: FND_MSG_PUB.ADD;
2133: FND_MSG_PUB.Count_And_Get(

Line 2134: p_encoded => FND_API.G_FALSE,

2130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2132: FND_MSG_PUB.ADD;
2133: FND_MSG_PUB.Count_And_Get(
2134: p_encoded => FND_API.G_FALSE,
2135: p_count => x_msg_count,
2136: p_data => x_msg_data);
2137: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,