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_FILE

Line 1162: FND_FILE.put_line(fnd_file.log, 'CPT:Rows inserted in MTI = ' || SQL%ROWCOUNT);

1158: P_DML_RECORD.FROM_OSR,
1159: P_DML_RECORD.TO_OSR,
1160: P_DML_RECORD.BATCH_MODE_FLAG;
1161:
1162: FND_FILE.put_line(fnd_file.log, 'CPT:Rows inserted in MTI = ' || SQL%ROWCOUNT);
1163:
1164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_ID = ' || P_DML_RECORD.BATCH_ID);
1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OS = ' || P_DML_RECORD.OS);
1166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FROM_OSR = ' || P_DML_RECORD.FROM_OSR);

Line 1164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_ID = ' || P_DML_RECORD.BATCH_ID);

1160: P_DML_RECORD.BATCH_MODE_FLAG;
1161:
1162: FND_FILE.put_line(fnd_file.log, 'CPT:Rows inserted in MTI = ' || SQL%ROWCOUNT);
1163:
1164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_ID = ' || P_DML_RECORD.BATCH_ID);
1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OS = ' || P_DML_RECORD.OS);
1166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FROM_OSR = ' || P_DML_RECORD.FROM_OSR);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TO_OSR = ' || P_DML_RECORD.TO_OSR);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);

Line 1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OS = ' || P_DML_RECORD.OS);

1161:
1162: FND_FILE.put_line(fnd_file.log, 'CPT:Rows inserted in MTI = ' || SQL%ROWCOUNT);
1163:
1164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_ID = ' || P_DML_RECORD.BATCH_ID);
1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OS = ' || P_DML_RECORD.OS);
1166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FROM_OSR = ' || P_DML_RECORD.FROM_OSR);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TO_OSR = ' || P_DML_RECORD.TO_OSR);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RERUN = ' || P_DML_RECORD.RERUN);

Line 1166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FROM_OSR = ' || P_DML_RECORD.FROM_OSR);

1162: FND_FILE.put_line(fnd_file.log, 'CPT:Rows inserted in MTI = ' || SQL%ROWCOUNT);
1163:
1164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_ID = ' || P_DML_RECORD.BATCH_ID);
1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OS = ' || P_DML_RECORD.OS);
1166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FROM_OSR = ' || P_DML_RECORD.FROM_OSR);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TO_OSR = ' || P_DML_RECORD.TO_OSR);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RERUN = ' || P_DML_RECORD.RERUN);
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT);

Line 1167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TO_OSR = ' || P_DML_RECORD.TO_OSR);

1163:
1164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_ID = ' || P_DML_RECORD.BATCH_ID);
1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OS = ' || P_DML_RECORD.OS);
1166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FROM_OSR = ' || P_DML_RECORD.FROM_OSR);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TO_OSR = ' || P_DML_RECORD.TO_OSR);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RERUN = ' || P_DML_RECORD.RERUN);
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG);

Line 1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);

1164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_ID = ' || P_DML_RECORD.BATCH_ID);
1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OS = ' || P_DML_RECORD.OS);
1166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FROM_OSR = ' || P_DML_RECORD.FROM_OSR);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TO_OSR = ' || P_DML_RECORD.TO_OSR);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RERUN = ' || P_DML_RECORD.RERUN);
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG);
1172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'USER_ID = ' || P_DML_RECORD.USER_ID);

Line 1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RERUN = ' || P_DML_RECORD.RERUN);

1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OS = ' || P_DML_RECORD.OS);
1166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FROM_OSR = ' || P_DML_RECORD.FROM_OSR);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TO_OSR = ' || P_DML_RECORD.TO_OSR);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RERUN = ' || P_DML_RECORD.RERUN);
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG);
1172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'USER_ID = ' || P_DML_RECORD.USER_ID);
1173:

Line 1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT);

1166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FROM_OSR = ' || P_DML_RECORD.FROM_OSR);
1167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TO_OSR = ' || P_DML_RECORD.TO_OSR);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RERUN = ' || P_DML_RECORD.RERUN);
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG);
1172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'USER_ID = ' || P_DML_RECORD.USER_ID);
1173:
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

Line 1171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG);

1167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TO_OSR = ' || P_DML_RECORD.TO_OSR);
1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RERUN = ' || P_DML_RECORD.RERUN);
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG);
1172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'USER_ID = ' || P_DML_RECORD.USER_ID);
1173:
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID);

Line 1172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'USER_ID = ' || P_DML_RECORD.USER_ID);

1168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'RERUN = ' || P_DML_RECORD.RERUN);
1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG);
1172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'USER_ID = ' || P_DML_RECORD.USER_ID);
1173:
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR);

Line 1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

1170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG);
1172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'USER_ID = ' || P_DML_RECORD.USER_ID);
1173:
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR);
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM);
1178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION);

Line 1175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID);

1171: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG);
1172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'USER_ID = ' || P_DML_RECORD.USER_ID);
1173:
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR);
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM);
1178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION);
1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY);

Line 1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR);

1172: FND_FILE.PUT_LINE(FND_FILE.LOG, 'USER_ID = ' || P_DML_RECORD.USER_ID);
1173:
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR);
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM);
1178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION);
1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY);
1180:

Line 1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM);

1173:
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR);
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM);
1178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION);
1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY);
1180:
1181: /* DE-NORM */

Line 1178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION);

1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR);
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM);
1178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION);
1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY);
1180:
1181: /* DE-NORM */
1182: /* for all the failed record of primary_flag = 'Y', update the party with */

Line 1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY);

1175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID);
1176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR);
1177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM);
1178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION);
1179: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY);
1180:
1181: /* DE-NORM */
1182: /* for all the failed record of primary_flag = 'Y', update the party with */
1183: /* the next available contact point */

Line 1252: FND_FILE.put_line(fnd_file.log, 'CPT:Rows updated with primary flag = ' || l_error_party_id.count);

1248: update hz_contact_points
1249: set primary_flag = 'Y'
1250: where contact_point_id = l_error_cpt_id(i);
1251:
1252: FND_FILE.put_line(fnd_file.log, 'CPT:Rows updated with primary flag = ' || l_error_party_id.count);
1253:
1254: /* de-norm the primary contact point to parties */
1255: /* Note: for error case, the party with the id will just be not found */
1256: /* in update. Not necessary to filter out here. */

Line 1310: FND_FILE.put_line(fnd_file.log, 'CPT:Denormalised contact point counts = ' || l_update_party_id.count);

1306: and contact_point_type='WEB')
1307: where hz_pty.party_id = l_update_party_id(i)
1308: and l_update_cpt_type(i) = 'WEB' ;
1309: --End of bug 7383480
1310: FND_FILE.put_line(fnd_file.log, 'CPT:Denormalised contact point counts = ' || l_update_party_id.count);
1311:
1312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1313: hz_utility_v2pub.debug(p_message=>'CPT: process_insert_contactpoints-',
1314: p_prefix=>l_debug_prefix,

Line 1343: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactpoints in process_insert_contactpoints');

1339:
1340: WHEN OTHERS THEN
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);

Line 1344: FND_FILE.put_line(fnd_file.log, SQLERRM);

1340: WHEN OTHERS THEN
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;

Line 1840: FND_FILE.put_line(fnd_file.log, 'CPT:Rows updated = ' || SQL%ROWCOUNT);

1836: --and l_owner_table_error(j) is not null
1837: and l_third_party_update_error(j) is not null /* Bug 4079902 */
1838: and l_createdby_errors(j) is not null;
1839:
1840: FND_FILE.put_line(fnd_file.log, 'CPT:Rows updated = ' || SQL%ROWCOUNT);
1841:
1842:
1843: EXCEPTION
1844: WHEN OTHERS THEN

Line 2000: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while updating contactpoints');

1996: p_data => x_msg_data);
1997:
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);

Line 2001: FND_FILE.put_line(fnd_file.log, l_errm);

1997:
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;

Line 2045: FND_FILE.put_line(fnd_file.log,'load_contactpoints+');

2041: END IF;
2042:
2043: FND_MSG_PUB.initialize;
2044:
2045: FND_FILE.put_line(fnd_file.log,'load_contactpoints+');
2046:
2047: /**** ?? Remove later. Disable policy function ***/
2048: --hz_common_pub.disable_cont_source_security; Bug No:3387220
2049:

Line 2103: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactpoints');

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);
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);

Line 2104: FND_FILE.put_line(fnd_file.log, l_errm);

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);
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;

Line 2127: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading contactpoints');

2123: END IF;
2124:
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);

Line 2128: FND_FILE.put_line(fnd_file.log, l_errm);

2124:
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;