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_ORG_CONTACT_PKG dependencies on FND_FILE

Line 335: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (+)');

331: exp_ind NUMBER := 1;
332:
333: BEGIN
334:
335: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (+)');
336: /**********************************/
337: /* Validation and Error reporting */
338: /**********************************/
339:

Line 355: -- FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || P_ACTION || ' Action, ' || ' total ' || num_exp || ' exceptions');

351: l_exception_exists := FLAG_ERROR();
352: l_exception_exists.extend(l_org_contact_id.count);
353: num_exp := SQL%BULK_EXCEPTIONS.COUNT;
354:
355: -- FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || P_ACTION || ' Action, ' || ' total ' || num_exp || ' exceptions');
356:
357: FOR k IN 1..l_org_contact_id.count LOOP
358:
359: /* If DML fails due to validation errors or exceptions */

Line 361: -- FND_FILE.PUT_LINE(FND_FILE.LOG, ' DML fails at record ' || k || '!');

357: FOR k IN 1..l_org_contact_id.count LOOP
358:
359: /* If DML fails due to validation errors or exceptions */
360: IF SQL%BULK_ROWCOUNT(k) = 0 THEN
361: -- FND_FILE.PUT_LINE(FND_FILE.LOG, ' DML fails at record ' || k || '!');
362:
363: l_num_row_processed(k) := 0;
364:
365: /* Check for any exceptions during DML */

Line 444: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (-)');

440: from dual
441: where l_num_row_processed(j) = 0
442: );
443:
444: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (-)');
445:
446: END report_errors;
447:
448:

Line 1269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_insert_org_contacts (+)');

1265: BEGIN
1266:
1267: savepoint process_insert_contacts_pvt;
1268:
1269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_insert_org_contacts (+)');
1270:
1271: FND_MSG_PUB.initialize;
1272:
1273: --Initialize API return status to success.

Line 1277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetch data from cursor start ' || dbms_utility.get_time);

1273: --Initialize API return status to success.
1274: x_return_status := FND_API.G_RET_STS_SUCCESS;
1275:
1276: /*
1277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetch data from cursor start ' || dbms_utility.get_time);
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_DML_RECORD.ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID = ' || P_BATCH_ID);
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_WU_OS = ' || P_WU_OS);

Line 1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date);

1274: x_return_status := FND_API.G_RET_STS_SUCCESS;
1275:
1276: /*
1277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetch data from cursor start ' || dbms_utility.get_time);
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_DML_RECORD.ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID = ' || P_BATCH_ID);
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_WU_OS = ' || P_WU_OS);
1282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);

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

1275:
1276: /*
1277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetch data from cursor start ' || dbms_utility.get_time);
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_DML_RECORD.ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID = ' || P_BATCH_ID);
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_WU_OS = ' || P_WU_OS);
1282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);

Line 1280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID = ' || P_BATCH_ID);

1276: /*
1277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetch data from cursor start ' || dbms_utility.get_time);
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_DML_RECORD.ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID = ' || P_BATCH_ID);
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_WU_OS = ' || P_WU_OS);
1282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1284: */

Line 1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_WU_OS = ' || P_WU_OS);

1277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetch data from cursor start ' || dbms_utility.get_time);
1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_DML_RECORD.ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID = ' || P_BATCH_ID);
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_WU_OS = ' || P_WU_OS);
1282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1284: */
1285:

Line 1282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);

1278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_no_end_date = ' || l_no_end_date);
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_DML_RECORD.ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID = ' || P_BATCH_ID);
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_WU_OS = ' || P_WU_OS);
1282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1284: */
1285:
1286: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN

Line 1283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);

1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_DML_RECORD.ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC);
1280: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BATCH_ID = ' || P_BATCH_ID);
1281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_WU_OS = ' || P_WU_OS);
1282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
1283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1284: */
1285:
1286: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
1287: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = Y');

Line 1287: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = Y');

1283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
1284: */
1285:
1286: IF P_DML_RECORD.ALLOW_DISABLED_LOOKUP = 'Y' THEN
1287: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = Y');
1288:
1289: IF P_DML_RECORD.RERUN = 'N' THEN
1290: -- First Run
1291: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');

Line 1291: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');

1287: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = Y');
1288:
1289: IF P_DML_RECORD.RERUN = 'N' THEN
1290: -- First Run
1291: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');
1292: EXECUTE IMMEDIATE l_insert_sql1 || l_insert_sql2 || l_insert_sql3 || l_where_first_run_sql || l_end_sql
1293: USING
1294: p_dml_record.user_id,
1295: p_dml_record.sysdate,

Line 1316: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');

1312: p_dml_record.to_osr;
1313:
1314: ELSE
1315: -- Rerun
1316: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');
1317: EXECUTE IMMEDIATE l_insert_sql1 || l_insert_sql2 || l_insert_sql3 || l_where_rerun_sql || l_end_sql
1318: USING
1319: p_dml_record.user_id,
1320: p_dml_record.sysdate,

Line 1343: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = N');

1339:
1340: END IF;
1341:
1342: ELSE -- l_allow_disabled_lookup
1343: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_allow_disabled_lookup = N');
1344:
1345: IF P_DML_RECORD.RERUN = 'N' THEN
1346:
1347: -- First Run

Line 1348: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');

1344:
1345: IF P_DML_RECORD.RERUN = 'N' THEN
1346:
1347: -- First Run
1348: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'First run');
1349: EXECUTE IMMEDIATE l_insert_sql1 || l_insert_sql2 || l_where_enabled_lookup_sql || l_insert_sql3 || l_where_first_run_sql || l_end_sql
1350: USING
1351: p_dml_record.user_id,
1352: p_dml_record.sysdate,

Line 1375: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');

1371:
1372:
1373: ELSE
1374: -- Rerun
1375: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Re-run');
1376: EXECUTE IMMEDIATE l_insert_sql1 || l_insert_sql2 || l_where_enabled_lookup_sql || l_insert_sql3 || l_where_rerun_sql || l_end_sql
1377: USING
1378: p_dml_record.user_id,
1379: p_dml_record.sysdate,

Line 1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_insert_org_contacts (-)');

1400:
1401:
1402: END IF;
1403:
1404: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_insert_org_contacts (-)');
1405:
1406: EXCEPTION
1407:
1408: WHEN DUP_VAL_ON_INDEX THEN

Line 1409: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert contacts dup val exception: ' || SQLERRM);

1405:
1406: EXCEPTION
1407:
1408: WHEN DUP_VAL_ON_INDEX THEN
1409: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert contacts dup val exception: ' || SQLERRM);
1410: ROLLBACK to process_insert_contacts_pvt;
1411:
1412: populate_error_table(P_DML_RECORD, 'Y', SQLERRM);
1413: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1420: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert org contacts other exception: ' || SQLERRM);

1416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1417: FND_MSG_PUB.ADD;
1418:
1419: WHEN OTHERS THEN
1420: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert org contacts other exception: ' || SQLERRM);
1421: ROLLBACK to process_insert_contacts_pvt;
1422:
1423: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1613: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_update_org_contacts (+)');

1609: BEGIN
1610:
1611: savepoint process_update_contacts_pvt;
1612:
1613: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_update_org_contacts (+)');
1614:
1615: FND_MSG_PUB.initialize;
1616:
1617: --Initialize API return status to success.

Line 1701: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_contact_id count = ' || l_org_contact_id.count);

1697: l_start_date_errors,
1698: l_start_end_date_errors,
1699: l_dup_rel_errors;
1700:
1701: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_contact_id count = ' || l_org_contact_id.count);
1702:
1703: /*** Do FND desc flex validation based on profile ***/
1704: IF P_DML_RECORD.FLEX_VALIDATION = 'Y' THEN
1705: validate_desc_flexfield(P_DML_RECORD.SYSDATE);

Line 1718: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_party_relationships ');

1714: /*************************************************/
1715: /* Update HZ_RELATIONSHIPS (Both directions) */
1716: /*************************************************/
1717:
1718: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_party_relationships ');
1719:
1720: BEGIN
1721: ForAll j in 1..l_relationship_id.count SAVE EXCEPTIONS
1722: update hz_relationships set

Line 1767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_relationships');

1763: and actual_content_source = P_DML_RECORD.ACTUAL_CONTENT_SRC;
1764: */
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_relationships');
1768: l_dml_exception := 'Y';
1769:
1770: FOR k IN 1..l_relationship_id.count LOOP
1771: FND_FILE.PUT_LINE(FND_FILE.LOG, 'dml_errors BULK_ROWCOUNT = ' || SQL%BULK_ROWCOUNT(k));

Line 1771: FND_FILE.PUT_LINE(FND_FILE.LOG, 'dml_errors BULK_ROWCOUNT = ' || SQL%BULK_ROWCOUNT(k));

1767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_relationships');
1768: l_dml_exception := 'Y';
1769:
1770: FOR k IN 1..l_relationship_id.count LOOP
1771: FND_FILE.PUT_LINE(FND_FILE.LOG, 'dml_errors BULK_ROWCOUNT = ' || SQL%BULK_ROWCOUNT(k));
1772: END LOOP;
1773: END;
1774:
1775: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '3 ' || dbms_utility.get_time);

Line 1775: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '3 ' || dbms_utility.get_time);

1771: FND_FILE.PUT_LINE(FND_FILE.LOG, 'dml_errors BULK_ROWCOUNT = ' || SQL%BULK_ROWCOUNT(k));
1772: END LOOP;
1773: END;
1774:
1775: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '3 ' || dbms_utility.get_time);
1776:
1777: report_errors(P_DML_RECORD, 'U', l_dml_exception);
1778:
1779:

Line 1784: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_org_contacts ');

1780: /*************************************************/
1781: /* Update HZ_ORG_CONTACTS */
1782: /*************************************************/
1783:
1784: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'update hz_org_contacts ');
1785:
1786: BEGIN
1787: ForAll j in 1..l_org_contact_id.count
1788: update hz_org_contacts set

Line 1966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_org_contacts');

1962: and l_num_row_processed(j) = 1;
1963:
1964: EXCEPTION
1965: WHEN OTHERS THEN
1966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions when updating hz_org_contacts');
1967: ROLLBACK to process_update_contacts_pvt;
1968:
1969: populate_error_table(P_DML_RECORD, 'N', SQLERRM);
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1980: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_update_org_contacts (-)');

1976: END;
1977:
1978: CLOSE c_handle_update;
1979:
1980: FND_FILE.PUT_LINE(FND_FILE.LOG, 'process_update_org_contacts (-)');
1981:
1982: END process_update_org_contacts;
1983:
1984: /********************************************************************************

Line 2024: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_org_contacts (+)');

2020: BEGIN
2021:
2022: savepoint load_org_contacts_pvt;
2023: FND_MSG_PUB.initialize;
2024: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_org_contacts (+)');
2025:
2026: --Initialize API return status to success.
2027: x_return_status := FND_API.G_RET_STS_SUCCESS;
2028:

Line 2050: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_org_contacts (-)');

2046: ,x_msg_data => x_msg_data
2047: );
2048:
2049:
2050: FND_FILE.PUT_LINE(FND_FILE.LOG, 'load_org_contacts (-)');
2051:
2052: END load_org_contacts;
2053: END HZ_IMP_LOAD_ORG_CONTACT_PKG;