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

Line 86: fnd_file.put_line(fnd_file.output,v);

82: v := TRIM(v);
83: IF v IS NOT NULL THEN
84: -- Fix perf bug 3669930, 4220460, cache profile option value into global variable
85: IF g_cp_detail = 'Y' THEN
86: fnd_file.put_line(fnd_file.output,v);
87: END IF;
88: fnd_file.put_line(fnd_file.log,v);
89: END IF;
90: END trace_handler;

Line 88: fnd_file.put_line(fnd_file.log,v);

84: -- Fix perf bug 3669930, 4220460, cache profile option value into global variable
85: IF g_cp_detail = 'Y' THEN
86: fnd_file.put_line(fnd_file.output,v);
87: END IF;
88: fnd_file.put_line(fnd_file.log,v);
89: END IF;
90: END trace_handler;
91:
92: --------------------------------------

Line 105: fnd_file.put_line(fnd_file.log,

101: --------------------------------------
102: /*PROCEDURE time_put_line (msg IN VARCHAR2) IS
103: BEGIN
104: IF g_file_debug THEN
105: fnd_file.put_line(fnd_file.log,
106: TO_CHAR(SYSDATE, 'HH:MI:SS') ||
107: ': ' || SUBSTRB(msg, 1, 240));
108: ELSE
109: hz_utility_v2pub.debug(TO_CHAR(SYSDATE, 'HH:MI:SS') ||

Line 116: fnd_file.put_line(fnd_file.log,

112: END time_put_line;
113: */
114: PROCEDURE time_put_line (msg IN VARCHAR2) IS
115: BEGIN
116: fnd_file.put_line(fnd_file.log,
117: TO_CHAR(SYSDATE, 'HH:MI:SS') ||
118: ': ' || SUBSTRB(msg, 1, 240));
119: END time_put_line;
120:

Line 561: fnd_file.put_line(fnd_file.log,

557: l_return_status := fnd_api.g_ret_sts_success;
558: fnd_msg_pub.initialize;
559:
560: retcode := '0';
561: fnd_file.put_line(fnd_file.log,
562: fnd_message.get_string('FND',
563: 'CONC-START PROGRAM EXECUTION'));
564: fnd_file.put_line(fnd_file.log, '');
565:

Line 564: fnd_file.put_line(fnd_file.log, '');

560: retcode := '0';
561: fnd_file.put_line(fnd_file.log,
562: fnd_message.get_string('FND',
563: 'CONC-START PROGRAM EXECUTION'));
564: fnd_file.put_line(fnd_file.log, '');
565:
566: fnd_file.put_line(fnd_file.output,
567: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
568: fnd_file.put_line(fnd_file.output,

Line 566: fnd_file.put_line(fnd_file.output,

562: fnd_message.get_string('FND',
563: 'CONC-START PROGRAM EXECUTION'));
564: fnd_file.put_line(fnd_file.log, '');
565:
566: fnd_file.put_line(fnd_file.output,
567: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
568: fnd_file.put_line(fnd_file.output,
569: fnd_message.get_string('FND',
570: 'CONC-START PROGRAM EXECUTION'));

Line 568: fnd_file.put_line(fnd_file.output,

564: fnd_file.put_line(fnd_file.log, '');
565:
566: fnd_file.put_line(fnd_file.output,
567: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
568: fnd_file.put_line(fnd_file.output,
569: fnd_message.get_string('FND',
570: 'CONC-START PROGRAM EXECUTION'));
571:
572: IF hz_geocode_pkg.is_nls_num_char_pt_com <> 'Y' THEN

Line 632: fnd_file.put_line(fnd_file.log,

628: l_port := fnd_profile.value(l_port_var);
629: END IF;
630:
631: -- log the profile options that are being used to run this program.
632: fnd_file.put_line(fnd_file.log,
633: fnd_message.get_string('FND', 'PROFILES-VALUES'));
634: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
635: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
636: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);

Line 634: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);

630:
631: -- log the profile options that are being used to run this program.
632: fnd_file.put_line(fnd_file.log,
633: fnd_message.get_string('FND', 'PROFILES-VALUES'));
634: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
635: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
636: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
637: fnd_file.put_line(fnd_file.log, '');
638:

Line 635: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);

631: -- log the profile options that are being used to run this program.
632: fnd_file.put_line(fnd_file.log,
633: fnd_message.get_string('FND', 'PROFILES-VALUES'));
634: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
635: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
636: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
637: fnd_file.put_line(fnd_file.log, '');
638:
639: -- repeat in the output file.

Line 636: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);

632: fnd_file.put_line(fnd_file.log,
633: fnd_message.get_string('FND', 'PROFILES-VALUES'));
634: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
635: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
636: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
637: fnd_file.put_line(fnd_file.log, '');
638:
639: -- repeat in the output file.
640: fnd_file.put_line(fnd_file.output,

Line 637: fnd_file.put_line(fnd_file.log, '');

633: fnd_message.get_string('FND', 'PROFILES-VALUES'));
634: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
635: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
636: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
637: fnd_file.put_line(fnd_file.log, '');
638:
639: -- repeat in the output file.
640: fnd_file.put_line(fnd_file.output,
641: fnd_message.get_string('FND', 'PROFILES-VALUES'));

Line 640: fnd_file.put_line(fnd_file.output,

636: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
637: fnd_file.put_line(fnd_file.log, '');
638:
639: -- repeat in the output file.
640: fnd_file.put_line(fnd_file.output,
641: fnd_message.get_string('FND', 'PROFILES-VALUES'));
642: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
643: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
644: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);

Line 642: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);

638:
639: -- repeat in the output file.
640: fnd_file.put_line(fnd_file.output,
641: fnd_message.get_string('FND', 'PROFILES-VALUES'));
642: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
643: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
644: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
645: fnd_file.put_line(fnd_file.output, '');
646:

Line 643: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);

639: -- repeat in the output file.
640: fnd_file.put_line(fnd_file.output,
641: fnd_message.get_string('FND', 'PROFILES-VALUES'));
642: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
643: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
644: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
645: fnd_file.put_line(fnd_file.output, '');
646:
647: -- repeat in debug output.

Line 644: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);

640: fnd_file.put_line(fnd_file.output,
641: fnd_message.get_string('FND', 'PROFILES-VALUES'));
642: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
643: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
644: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
645: fnd_file.put_line(fnd_file.output, '');
646:
647: -- repeat in debug output.
648: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 645: fnd_file.put_line(fnd_file.output, '');

641: fnd_message.get_string('FND', 'PROFILES-VALUES'));
642: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
643: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
644: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
645: fnd_file.put_line(fnd_file.output, '');
646:
647: -- repeat in debug output.
648: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
649: hz_utility_v2pub.debug(p_message=>'HZ_GEOCODE_WEBSITE: ' || l_http_ad,

Line 1309: fnd_file.put_line(fnd_file.log,

1305: l_array(cpt).country := l_countries(i);
1306: l_array(cpt).province := l_provinces(i);
1307: l_array(cpt).county := l_counties(i);
1308:
1309: fnd_file.put_line(fnd_file.log,
1310: 'Processing location '||l_array(cpt).location_id);
1311: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'Processing location ' || l_array(cpt).location_id,
1313: p_prefix =>l_debug_prefix,

Line 1454: fnd_file.put_line(fnd_file.log,'Process committed');

1450: COMMIT;
1451:
1452: -- Fix bug 3612034, close cursor and then reopen it again due to
1453: -- snapshot too old problem
1454: fnd_file.put_line(fnd_file.log,'Process committed');
1455:
1456: IF p_loc_type = 'P' THEN
1457: IF p_site_use_type IS NOT NULL AND p_incremental = 'N' THEN
1458: IF (p_country IS NULL) THEN

Line 1616: fnd_file.put_line(fnd_file.output, errbuf);

1612: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1613: retcode := '1';
1614: -- J. del Callar: instruct user to look at log if warnings are found.
1615: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1616: fnd_file.put_line(fnd_file.output, errbuf);
1617: END IF;
1618:
1619: -- J. del Callar: reflect successful program termination in output and
1620: -- log files.

Line 1621: fnd_file.put_line(fnd_file.output,

1617: END IF;
1618:
1619: -- J. del Callar: reflect successful program termination in output and
1620: -- log files.
1621: fnd_file.put_line(fnd_file.output,
1622: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
1623: fnd_file.put_line(fnd_file.output,
1624: fnd_message.get_string('FND',
1625: 'CONC-CP SUCCESSFUL TERMINATION'));

Line 1623: fnd_file.put_line(fnd_file.output,

1619: -- J. del Callar: reflect successful program termination in output and
1620: -- log files.
1621: fnd_file.put_line(fnd_file.output,
1622: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
1623: fnd_file.put_line(fnd_file.output,
1624: fnd_message.get_string('FND',
1625: 'CONC-CP SUCCESSFUL TERMINATION'));
1626: fnd_file.put_line(fnd_file.log,
1627: fnd_message.get_string('FND',

Line 1626: fnd_file.put_line(fnd_file.log,

1622: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
1623: fnd_file.put_line(fnd_file.output,
1624: fnd_message.get_string('FND',
1625: 'CONC-CP SUCCESSFUL TERMINATION'));
1626: fnd_file.put_line(fnd_file.log,
1627: fnd_message.get_string('FND',
1628: 'CONC-CP SUCCESSFUL TERMINATION'));
1629:
1630: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1748: fnd_file.put_line(fnd_file.log, SQLERRM);

1744: retcode := '2';
1745: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1746:
1747: WHEN OTHERS THEN
1748: fnd_file.put_line(fnd_file.log, SQLERRM);
1749: msg := SQLERRM;
1750: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1751: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- others)',
1752: p_prefix=>'SQL ERROR',

Line 1863: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------');

1859: WHERE LOOKUP_TYPE = 'HZ_LOC_STATUS'
1860: AND LOOKUP_CODE = p_party_site_status;
1861: END IF;
1862:
1863: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1864: fnd_file.put_line(fnd_file.log,'');
1865: fnd_file.put_line(fnd_file.log,'PARAMETERS ENTERED: ');
1866: fnd_file.put_line(fnd_file.log,'Location Type: '||l_loc_type);
1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);

Line 1864: fnd_file.put_line(fnd_file.log,'');

1860: AND LOOKUP_CODE = p_party_site_status;
1861: END IF;
1862:
1863: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1864: fnd_file.put_line(fnd_file.log,'');
1865: fnd_file.put_line(fnd_file.log,'PARAMETERS ENTERED: ');
1866: fnd_file.put_line(fnd_file.log,'Location Type: '||l_loc_type);
1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);
1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));

Line 1865: fnd_file.put_line(fnd_file.log,'PARAMETERS ENTERED: ');

1861: END IF;
1862:
1863: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1864: fnd_file.put_line(fnd_file.log,'');
1865: fnd_file.put_line(fnd_file.log,'PARAMETERS ENTERED: ');
1866: fnd_file.put_line(fnd_file.log,'Location Type: '||l_loc_type);
1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);
1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));
1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));

Line 1866: fnd_file.put_line(fnd_file.log,'Location Type: '||l_loc_type);

1862:
1863: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1864: fnd_file.put_line(fnd_file.log,'');
1865: fnd_file.put_line(fnd_file.log,'PARAMETERS ENTERED: ');
1866: fnd_file.put_line(fnd_file.log,'Location Type: '||l_loc_type);
1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);
1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));
1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));
1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));

Line 1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);

1863: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1864: fnd_file.put_line(fnd_file.log,'');
1865: fnd_file.put_line(fnd_file.log,'PARAMETERS ENTERED: ');
1866: fnd_file.put_line(fnd_file.log,'Location Type: '||l_loc_type);
1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);
1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));
1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));
1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));
1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);

Line 1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));

1864: fnd_file.put_line(fnd_file.log,'');
1865: fnd_file.put_line(fnd_file.log,'PARAMETERS ENTERED: ');
1866: fnd_file.put_line(fnd_file.log,'Location Type: '||l_loc_type);
1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);
1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));
1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));
1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));
1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);
1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));

Line 1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));

1865: fnd_file.put_line(fnd_file.log,'PARAMETERS ENTERED: ');
1866: fnd_file.put_line(fnd_file.log,'Location Type: '||l_loc_type);
1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);
1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));
1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));
1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));
1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);
1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));
1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));

Line 1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));

1866: fnd_file.put_line(fnd_file.log,'Location Type: '||l_loc_type);
1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);
1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));
1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));
1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));
1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);
1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));
1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));
1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));

Line 1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);

1867: fnd_file.put_line(fnd_file.log,'Site Use: '||l_site_use_type);
1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));
1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));
1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));
1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);
1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));
1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));
1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));
1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));

Line 1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));

1868: fnd_file.put_line(fnd_file.log,'Identifying Addresses Only: '||NVL(P_IDEN_ADDR_ONLY,'NULL'));
1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));
1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));
1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);
1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));
1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));
1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));
1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));
1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);

Line 1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));

1869: fnd_file.put_line(fnd_file.log,'Update Records for: '||NVL(p_all_partial,'NULL'));
1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));
1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);
1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));
1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));
1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));
1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));
1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);
1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);

Line 1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));

1870: fnd_file.put_line(fnd_file.log,'Only Unretrieved Locations: '||NVL(p_incremental,'NULL'));
1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);
1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));
1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));
1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));
1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));
1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);
1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);
1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);

Line 1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));

1871: fnd_file.put_line(fnd_file.log,'Country: '||l_country);
1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));
1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));
1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));
1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));
1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);
1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);
1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);
1879: fnd_file.put_line(fnd_file.log,'');

Line 1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);

1872: fnd_file.put_line(fnd_file.log,'Number of Records in Subset: '||NVL(p_nb_row_update,'NULL'));
1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));
1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));
1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));
1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);
1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);
1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);
1879: fnd_file.put_line(fnd_file.log,'');
1880: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');

Line 1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);

1873: fnd_file.put_line(fnd_file.log,'State: '||NVL(p_state,'NULL'));
1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));
1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));
1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);
1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);
1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);
1879: fnd_file.put_line(fnd_file.log,'');
1880: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);

Line 1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);

1874: fnd_file.put_line(fnd_file.log,'Province: '||NVL(p_province,'NULL'));
1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));
1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);
1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);
1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);
1879: fnd_file.put_line(fnd_file.log,'');
1880: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);
1882: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');

Line 1879: fnd_file.put_line(fnd_file.log,'');

1875: fnd_file.put_line(fnd_file.log,'City: '||NVL(p_city,'NULL'));
1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);
1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);
1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);
1879: fnd_file.put_line(fnd_file.log,'');
1880: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);
1882: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1883: fnd_file.put_line(fnd_file.log,'');

Line 1880: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------');

1876: fnd_file.put_line(fnd_file.log,'Accuracy Level: '||l_geometry_accuracy);
1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);
1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);
1879: fnd_file.put_line(fnd_file.log,'');
1880: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);
1882: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1883: fnd_file.put_line(fnd_file.log,'');
1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');

Line 1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);

1877: fnd_file.put_line(fnd_file.log,'Source: '||l_geometry_source);
1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);
1879: fnd_file.put_line(fnd_file.log,'');
1880: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);
1882: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1883: fnd_file.put_line(fnd_file.log,'');
1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');
1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);

Line 1882: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------');

1878: fnd_file.put_line(fnd_file.log,'Location Status: '||l_party_site_status);
1879: fnd_file.put_line(fnd_file.log,'');
1880: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);
1882: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1883: fnd_file.put_line(fnd_file.log,'');
1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');
1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);
1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);

Line 1883: fnd_file.put_line(fnd_file.log,'');

1879: fnd_file.put_line(fnd_file.log,'');
1880: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);
1882: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1883: fnd_file.put_line(fnd_file.log,'');
1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');
1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);
1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);
1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);

Line 1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');

1880: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);
1882: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1883: fnd_file.put_line(fnd_file.log,'');
1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');
1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);
1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);
1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);
1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);

Line 1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);

1881: fnd_file.put_line(fnd_file.log,'TOTAL RECORDS PROCESSED: '||l_total_rec_processed);
1882: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1883: fnd_file.put_line(fnd_file.log,'');
1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');
1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);
1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);
1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);
1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);
1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);

Line 1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);

1882: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1883: fnd_file.put_line(fnd_file.log,'');
1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');
1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);
1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);
1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);
1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);
1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);
1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);

Line 1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);

1883: fnd_file.put_line(fnd_file.log,'');
1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');
1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);
1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);
1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);
1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);
1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);
1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);
1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);

Line 1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);

1884: fnd_file.put_line(fnd_file.log,'Accuracy level Location Count');
1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);
1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);
1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);
1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);
1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);
1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);
1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);
1892: fnd_file.put_line(fnd_file.log,'');

Line 1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);

1885: fnd_file.put_line(fnd_file.log,' 1 '||P_MC_1);
1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);
1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);
1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);
1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);
1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);
1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);
1892: fnd_file.put_line(fnd_file.log,'');
1893: fnd_file.put_line(fnd_file.output,'');

Line 1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);

1886: fnd_file.put_line(fnd_file.log,' 2 '||P_MC_2);
1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);
1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);
1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);
1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);
1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);
1892: fnd_file.put_line(fnd_file.log,'');
1893: fnd_file.put_line(fnd_file.output,'');
1894: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');

Line 1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);

1887: fnd_file.put_line(fnd_file.log,' 3 '||P_MC_3);
1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);
1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);
1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);
1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);
1892: fnd_file.put_line(fnd_file.log,'');
1893: fnd_file.put_line(fnd_file.output,'');
1894: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1895: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');

Line 1892: fnd_file.put_line(fnd_file.log,'');

1888: fnd_file.put_line(fnd_file.log,' 4 '||P_MC_4);
1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);
1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);
1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);
1892: fnd_file.put_line(fnd_file.log,'');
1893: fnd_file.put_line(fnd_file.output,'');
1894: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1895: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1896: fnd_file.put_line(fnd_file.log,'');

Line 1893: fnd_file.put_line(fnd_file.output,'');

1889: fnd_file.put_line(fnd_file.log,' 10 '||P_MC_10);
1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);
1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);
1892: fnd_file.put_line(fnd_file.log,'');
1893: fnd_file.put_line(fnd_file.output,'');
1894: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1895: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1896: fnd_file.put_line(fnd_file.log,'');
1897: fnd_file.put_line(fnd_file.output,'');

Line 1894: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------');

1890: fnd_file.put_line(fnd_file.log,' 11 '||P_MC_11);
1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);
1892: fnd_file.put_line(fnd_file.log,'');
1893: fnd_file.put_line(fnd_file.output,'');
1894: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1895: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1896: fnd_file.put_line(fnd_file.log,'');
1897: fnd_file.put_line(fnd_file.output,'');
1898: open c_accuracy_mapping;

Line 1895: fnd_file.put_line(fnd_file.output,'---------------------------------------------------------------------------');

1891: fnd_file.put_line(fnd_file.log,' 0 '||P_MC_0);
1892: fnd_file.put_line(fnd_file.log,'');
1893: fnd_file.put_line(fnd_file.output,'');
1894: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1895: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1896: fnd_file.put_line(fnd_file.log,'');
1897: fnd_file.put_line(fnd_file.output,'');
1898: open c_accuracy_mapping;
1899: loop

Line 1896: fnd_file.put_line(fnd_file.log,'');

1892: fnd_file.put_line(fnd_file.log,'');
1893: fnd_file.put_line(fnd_file.output,'');
1894: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1895: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1896: fnd_file.put_line(fnd_file.log,'');
1897: fnd_file.put_line(fnd_file.output,'');
1898: open c_accuracy_mapping;
1899: loop
1900: fetch c_accuracy_mapping into r_accuracy_mapping;

Line 1897: fnd_file.put_line(fnd_file.output,'');

1893: fnd_file.put_line(fnd_file.output,'');
1894: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1895: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1896: fnd_file.put_line(fnd_file.log,'');
1897: fnd_file.put_line(fnd_file.output,'');
1898: open c_accuracy_mapping;
1899: loop
1900: fetch c_accuracy_mapping into r_accuracy_mapping;
1901: exit when c_accuracy_mapping%NOTFOUND;

Line 1902: fnd_file.put_line(fnd_file.log,'ACCURACY LEVEL '||rpad(r_accuracy_mapping.lookup_code,2)||' - '||r_accuracy_mapping.description);

1898: open c_accuracy_mapping;
1899: loop
1900: fetch c_accuracy_mapping into r_accuracy_mapping;
1901: exit when c_accuracy_mapping%NOTFOUND;
1902: fnd_file.put_line(fnd_file.log,'ACCURACY LEVEL '||rpad(r_accuracy_mapping.lookup_code,2)||' - '||r_accuracy_mapping.description);
1903: fnd_file.put_line(fnd_file.output,'ACCURACY LEVEL '||rpad(r_accuracy_mapping.lookup_code,2)||' - '||r_accuracy_mapping.description);
1904: end loop;
1905: close c_accuracy_mapping;
1906: fnd_file.put_line(fnd_file.log,'');

Line 1903: fnd_file.put_line(fnd_file.output,'ACCURACY LEVEL '||rpad(r_accuracy_mapping.lookup_code,2)||' - '||r_accuracy_mapping.description);

1899: loop
1900: fetch c_accuracy_mapping into r_accuracy_mapping;
1901: exit when c_accuracy_mapping%NOTFOUND;
1902: fnd_file.put_line(fnd_file.log,'ACCURACY LEVEL '||rpad(r_accuracy_mapping.lookup_code,2)||' - '||r_accuracy_mapping.description);
1903: fnd_file.put_line(fnd_file.output,'ACCURACY LEVEL '||rpad(r_accuracy_mapping.lookup_code,2)||' - '||r_accuracy_mapping.description);
1904: end loop;
1905: close c_accuracy_mapping;
1906: fnd_file.put_line(fnd_file.log,'');
1907: fnd_file.put_line(fnd_file.output,'');

Line 1906: fnd_file.put_line(fnd_file.log,'');

1902: fnd_file.put_line(fnd_file.log,'ACCURACY LEVEL '||rpad(r_accuracy_mapping.lookup_code,2)||' - '||r_accuracy_mapping.description);
1903: fnd_file.put_line(fnd_file.output,'ACCURACY LEVEL '||rpad(r_accuracy_mapping.lookup_code,2)||' - '||r_accuracy_mapping.description);
1904: end loop;
1905: close c_accuracy_mapping;
1906: fnd_file.put_line(fnd_file.log,'');
1907: fnd_file.put_line(fnd_file.output,'');
1908: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1909: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1910:

Line 1907: fnd_file.put_line(fnd_file.output,'');

1903: fnd_file.put_line(fnd_file.output,'ACCURACY LEVEL '||rpad(r_accuracy_mapping.lookup_code,2)||' - '||r_accuracy_mapping.description);
1904: end loop;
1905: close c_accuracy_mapping;
1906: fnd_file.put_line(fnd_file.log,'');
1907: fnd_file.put_line(fnd_file.output,'');
1908: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1909: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1910:
1911: END generate_log_file;

Line 1908: fnd_file.put_line(fnd_file.log,'---------------------------------------------------------------------------');

1904: end loop;
1905: close c_accuracy_mapping;
1906: fnd_file.put_line(fnd_file.log,'');
1907: fnd_file.put_line(fnd_file.output,'');
1908: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1909: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1910:
1911: END generate_log_file;
1912:

Line 1909: fnd_file.put_line(fnd_file.output,'---------------------------------------------------------------------------');

1905: close c_accuracy_mapping;
1906: fnd_file.put_line(fnd_file.log,'');
1907: fnd_file.put_line(fnd_file.output,'');
1908: fnd_file.put_line(fnd_file.log,'*---------------------------------------------------------------------------*');
1909: fnd_file.put_line(fnd_file.output,'*---------------------------------------------------------------------------*');
1910:
1911: END generate_log_file;
1912:
1913: --------------------------------------

Line 2038: fnd_file.put_line(fnd_file.log,

2034: l_return_status := fnd_api.g_ret_sts_success;
2035: fnd_msg_pub.initialize;
2036:
2037: retcode := '0';
2038: fnd_file.put_line(fnd_file.log,
2039: fnd_message.get_string('FND',
2040: 'CONC-START PROGRAM EXECUTION'));
2041: fnd_file.put_line(fnd_file.log, '');
2042:

Line 2041: fnd_file.put_line(fnd_file.log, '');

2037: retcode := '0';
2038: fnd_file.put_line(fnd_file.log,
2039: fnd_message.get_string('FND',
2040: 'CONC-START PROGRAM EXECUTION'));
2041: fnd_file.put_line(fnd_file.log, '');
2042:
2043: fnd_file.put_line(fnd_file.output,
2044: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
2045: fnd_file.put_line(fnd_file.output,

Line 2043: fnd_file.put_line(fnd_file.output,

2039: fnd_message.get_string('FND',
2040: 'CONC-START PROGRAM EXECUTION'));
2041: fnd_file.put_line(fnd_file.log, '');
2042:
2043: fnd_file.put_line(fnd_file.output,
2044: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
2045: fnd_file.put_line(fnd_file.output,
2046: fnd_message.get_string('FND',
2047: 'CONC-START PROGRAM EXECUTION'));

Line 2045: fnd_file.put_line(fnd_file.output,

2041: fnd_file.put_line(fnd_file.log, '');
2042:
2043: fnd_file.put_line(fnd_file.output,
2044: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
2045: fnd_file.put_line(fnd_file.output,
2046: fnd_message.get_string('FND',
2047: 'CONC-START PROGRAM EXECUTION'));
2048:
2049: IF hz_geocode_pkg.is_nls_num_char_pt_com <> 'Y' THEN

Line 2110: fnd_file.put_line(fnd_file.log,

2106: l_port := fnd_profile.value(l_port_var);
2107: END IF;
2108:
2109: -- log the profile options that are being used to run this program.
2110: fnd_file.put_line(fnd_file.log,
2111: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2112: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2113: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
2114: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);

Line 2112: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);

2108:
2109: -- log the profile options that are being used to run this program.
2110: fnd_file.put_line(fnd_file.log,
2111: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2112: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2113: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
2114: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
2115: fnd_file.put_line(fnd_file.log, '');
2116:

Line 2113: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);

2109: -- log the profile options that are being used to run this program.
2110: fnd_file.put_line(fnd_file.log,
2111: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2112: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2113: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
2114: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
2115: fnd_file.put_line(fnd_file.log, '');
2116:
2117: -- repeat in the output file.

Line 2114: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);

2110: fnd_file.put_line(fnd_file.log,
2111: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2112: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2113: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
2114: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
2115: fnd_file.put_line(fnd_file.log, '');
2116:
2117: -- repeat in the output file.
2118: fnd_file.put_line(fnd_file.output,

Line 2115: fnd_file.put_line(fnd_file.log, '');

2111: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2112: fnd_file.put_line(fnd_file.log, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2113: fnd_file.put_line(fnd_file.log, l_proxy_var || ': ' || l_proxy);
2114: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
2115: fnd_file.put_line(fnd_file.log, '');
2116:
2117: -- repeat in the output file.
2118: fnd_file.put_line(fnd_file.output,
2119: fnd_message.get_string('FND', 'PROFILES-VALUES'));

Line 2118: fnd_file.put_line(fnd_file.output,

2114: fnd_file.put_line(fnd_file.log, l_port_var || ': ' || l_port);
2115: fnd_file.put_line(fnd_file.log, '');
2116:
2117: -- repeat in the output file.
2118: fnd_file.put_line(fnd_file.output,
2119: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2120: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2121: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
2122: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);

Line 2120: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);

2116:
2117: -- repeat in the output file.
2118: fnd_file.put_line(fnd_file.output,
2119: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2120: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2121: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
2122: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
2123: fnd_file.put_line(fnd_file.output, '');
2124:

Line 2121: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);

2117: -- repeat in the output file.
2118: fnd_file.put_line(fnd_file.output,
2119: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2120: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2121: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
2122: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
2123: fnd_file.put_line(fnd_file.output, '');
2124:
2125: -- repeat in debug output.

Line 2122: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);

2118: fnd_file.put_line(fnd_file.output,
2119: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2120: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2121: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
2122: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
2123: fnd_file.put_line(fnd_file.output, '');
2124:
2125: -- repeat in debug output.
2126: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2123: fnd_file.put_line(fnd_file.output, '');

2119: fnd_message.get_string('FND', 'PROFILES-VALUES'));
2120: fnd_file.put_line(fnd_file.output, 'HZ_GEOCODE_WEBSITE: ' || l_http_ad);
2121: fnd_file.put_line(fnd_file.output, l_proxy_var || ': ' || l_proxy);
2122: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
2123: fnd_file.put_line(fnd_file.output, '');
2124:
2125: -- repeat in debug output.
2126: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2127: hz_utility_v2pub.debug(p_message=>'HZ_GEOCODE_WEBSITE: ' || l_http_ad||' '||l_proxy_var || ': ' || l_proxy||' '||

Line 2235: --fnd_file.put_line(fnd_file.output,'Query '||l_qry_str);

2231: hz_utility_v2pub.debug(p_message=>'Dynamic Query 1 :'||l_qry_str,
2232: p_prefix=>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_procedure);
2234: END IF;
2235: --fnd_file.put_line(fnd_file.output,'Query '||l_qry_str);
2236: --fnd_file.put_line(fnd_file.log,'Query '||l_qry_str);
2237:
2238: -- Open cursor
2239: OPEN l_Loc_geo_cursor FOR l_qry_str;

Line 2236: --fnd_file.put_line(fnd_file.log,'Query '||l_qry_str);

2232: p_prefix=>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_procedure);
2234: END IF;
2235: --fnd_file.put_line(fnd_file.output,'Query '||l_qry_str);
2236: --fnd_file.put_line(fnd_file.log,'Query '||l_qry_str);
2237:
2238: -- Open cursor
2239: OPEN l_Loc_geo_cursor FOR l_qry_str;
2240: LOOP

Line 2305: -- fnd_file.put_line(fnd_file.log,'Processing location '||l_array(cpt).location_id);

2301: l_array(cpt).country := l_countries(i);
2302: l_array(cpt).province := l_provinces(i);
2303: l_array(cpt).county := l_counties(i);
2304: --Commented as log file format is changed.
2305: -- fnd_file.put_line(fnd_file.log,'Processing location '||l_array(cpt).location_id);
2306: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2307: hz_utility_v2pub.debug(p_message=>'Processing location ' || l_array(cpt).location_id,
2308: p_prefix =>l_debug_prefix,
2309: p_msg_level=>fnd_log.level_statement);

Line 2428: fnd_file.put_line(fnd_file.output, 'Processed location Id: '||l_array(j).location_id

2424:
2425: --Bug12377426
2426: --'Geometry Accuracy' changed to 'Accuracy Level'
2427: IF l_processed_rec_cnt <= 1000 THEN
2428: fnd_file.put_line(fnd_file.output, 'Processed location Id: '||l_array(j).location_id
2429: ||l_longitude_str ||l_latitude_str
2430: ||' Accuracy Level: '||l_array(j).geometry_accuracy
2431: --||' Status: '||l_array(j).geometry_status_code
2432: );

Line 2435: fnd_file.put_line(fnd_file.output,'Output is generated for only first 1000 processed records.');

2431: --||' Status: '||l_array(j).geometry_status_code
2432: );
2433: l_processed_rec_cnt := l_processed_rec_cnt + 1;
2434: ELSIF l_processed_rec_cnt = 1001 THEN
2435: fnd_file.put_line(fnd_file.output,'Output is generated for only first 1000 processed records.');
2436: l_processed_rec_cnt := l_processed_rec_cnt + 1;
2437: END IF;
2438: END LOOP;
2439: status_handler(l_return_status, x_return_status);

Line 2482: --fnd_file.put_line(fnd_file.log,'Process committed');

2478:
2479: END LOOP;
2480:
2481: COMMIT;
2482: --fnd_file.put_line(fnd_file.log,'Process committed');
2483: -- Close cursor:
2484: IF l_Loc_geo_cursor%ISOPEN THEN
2485: CLOSE l_Loc_geo_cursor;
2486: END IF;

Line 2525: fnd_file.put_line(fnd_file.output, errbuf);

2521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2522: retcode := '1';
2523: -- Instruct user to look at log if warnings are found.
2524: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2525: fnd_file.put_line(fnd_file.output, errbuf);
2526: END IF;
2527:
2528: -- Reflect successful program termination in output and
2529: -- log files.

Line 2530: fnd_file.put_line(fnd_file.output,

2526: END IF;
2527:
2528: -- Reflect successful program termination in output and
2529: -- log files.
2530: fnd_file.put_line(fnd_file.output,
2531: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
2532: fnd_file.put_line(fnd_file.output,
2533: fnd_message.get_string('FND',
2534: 'CONC-CP SUCCESSFUL TERMINATION'));

Line 2532: fnd_file.put_line(fnd_file.output,

2528: -- Reflect successful program termination in output and
2529: -- log files.
2530: fnd_file.put_line(fnd_file.output,
2531: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
2532: fnd_file.put_line(fnd_file.output,
2533: fnd_message.get_string('FND',
2534: 'CONC-CP SUCCESSFUL TERMINATION'));
2535: fnd_file.put_line(fnd_file.log,
2536: fnd_message.get_string('FND',

Line 2535: fnd_file.put_line(fnd_file.log,

2531: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS: '));
2532: fnd_file.put_line(fnd_file.output,
2533: fnd_message.get_string('FND',
2534: 'CONC-CP SUCCESSFUL TERMINATION'));
2535: fnd_file.put_line(fnd_file.log,
2536: fnd_message.get_string('FND',
2537: 'CONC-CP SUCCESSFUL TERMINATION'));
2538:
2539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2661: fnd_file.put_line(fnd_file.log, SQLERRM);

2657: retcode := '2';
2658: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2659:
2660: WHEN OTHERS THEN
2661: fnd_file.put_line(fnd_file.log, SQLERRM);
2662: msg := SQLERRM;
2663: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2664: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry_all (- others)',
2665: p_prefix=>'SQL ERROR',

Line 2844: fnd_file.put_line(fnd_file.log,

2840: -- notify the user that the spatial index was successfully rebuilt, and of
2841: -- successful concurrent program termination only if we are running as a
2842: -- concurrent program.
2843: IF p_concurrent_mode = 'Y' THEN
2844: fnd_file.put_line(fnd_file.log,
2845: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2846: fnd_file.put_line(fnd_file.output,
2847: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2848: fnd_file.put_line(fnd_file.log,

Line 2846: fnd_file.put_line(fnd_file.output,

2842: -- concurrent program.
2843: IF p_concurrent_mode = 'Y' THEN
2844: fnd_file.put_line(fnd_file.log,
2845: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2846: fnd_file.put_line(fnd_file.output,
2847: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2848: fnd_file.put_line(fnd_file.log,
2849: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2850: fnd_file.put_line(fnd_file.output,

Line 2848: fnd_file.put_line(fnd_file.log,

2844: fnd_file.put_line(fnd_file.log,
2845: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2846: fnd_file.put_line(fnd_file.output,
2847: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2848: fnd_file.put_line(fnd_file.log,
2849: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2850: fnd_file.put_line(fnd_file.output,
2851: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2852: ELSE

Line 2850: fnd_file.put_line(fnd_file.output,

2846: fnd_file.put_line(fnd_file.output,
2847: fnd_message.get_string('AR', 'HZ_GEO_INDEX_REBUILT'));
2848: fnd_file.put_line(fnd_file.log,
2849: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2850: fnd_file.put_line(fnd_file.output,
2851: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2852: ELSE
2853: -- otherwise, just push the error onto the stack.
2854: fnd_message.set_name('AR', 'HZ_GEO_INDEX_REBUILT');

Line 2881: fnd_file.put_line(fnd_file.log, fnd_message.get);

2877:
2878: -- log the error only if we are running as a concurrent program.
2879: -- otherwise, push the error onto the stack.
2880: IF p_concurrent_mode = 'Y' THEN
2881: fnd_file.put_line(fnd_file.log, fnd_message.get);
2882: fnd_file.put_line(fnd_file.output,
2883: fnd_message.get_string('FND',
2884: 'CONC-CHECK LOG FOR DETAILS'));
2885: ELSE

Line 2882: fnd_file.put_line(fnd_file.output,

2878: -- log the error only if we are running as a concurrent program.
2879: -- otherwise, push the error onto the stack.
2880: IF p_concurrent_mode = 'Y' THEN
2881: fnd_file.put_line(fnd_file.log, fnd_message.get);
2882: fnd_file.put_line(fnd_file.output,
2883: fnd_message.get_string('FND',
2884: 'CONC-CHECK LOG FOR DETAILS'));
2885: ELSE
2886: fnd_msg_pub.add;