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.ZX_TAX_CONTENT_UPLOAD dependencies on FND_FILE

Line 80: FND_FILE.PUT_LINE

76: BEGIN
77:
78: retcode := '0';
79:
80: FND_FILE.PUT_LINE
81: (
82: FND_FILE.LOG,
83: 'Starting setup_data.'
84: );

Line 82: FND_FILE.LOG,

78: retcode := '0';
79:
80: FND_FILE.PUT_LINE
81: (
82: FND_FILE.LOG,
83: 'Starting setup_data.'
84: );
85:
86: FOR I IN 1..3

Line 110: FND_FILE.PUT_LINE

106:
107: IF (NVL(l_exists_flag,'N') = 'N')
108: THEN
109:
110: FND_FILE.PUT_LINE
111: (
112: FND_FILE.LOG,
113: 'Creating Tax: '||l_tax||'.'
114: );

Line 112: FND_FILE.LOG,

108: THEN
109:
110: FND_FILE.PUT_LINE
111: (
112: FND_FILE.LOG,
113: 'Creating Tax: '||l_tax||'.'
114: );
115:
116: INSERT INTO ZX_TAXES_B_TMP

Line 385: FND_FILE.PUT_LINE

381:
382: IF (NVL(l_exists_flag,'N') = 'N')
383: THEN
384:
385: FND_FILE.PUT_LINE
386: (
387: FND_FILE.LOG,
388: 'Creating STANDARD Status for Tax: '||l_tax||'.'
389: );

Line 387: FND_FILE.LOG,

383: THEN
384:
385: FND_FILE.PUT_LINE
386: (
387: FND_FILE.LOG,
388: 'Creating STANDARD Status for Tax: '||l_tax||'.'
389: );
390:
391:

Line 520: FND_FILE.PUT_LINE

516:
517: IF (NVL(l_exists_flag,'N') = 'N')
518: THEN
519:
520: FND_FILE.PUT_LINE
521: (
522: FND_FILE.LOG,
523: 'Creating Tax Zone Type: '||p_tax_zone_type||'.'
524: );

Line 522: FND_FILE.LOG,

518: THEN
519:
520: FND_FILE.PUT_LINE
521: (
522: FND_FILE.LOG,
523: 'Creating Tax Zone Type: '||p_tax_zone_type||'.'
524: );
525:
526: l_incl_geo_type(1) := 'COUNTY';

Line 545: FND_FILE.PUT_LINE

541: l_msg_count,
542: l_msg_data
543: );
544:
545: FND_FILE.PUT_LINE
546: (
547: FND_FILE.LOG,
548: 'Status returned by HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type: '||l_return_status||', and message: '||l_msg_data
549: );

Line 547: FND_FILE.LOG,

543: );
544:
545: FND_FILE.PUT_LINE
546: (
547: FND_FILE.LOG,
548: 'Status returned by HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type: '||l_return_status||', and message: '||l_msg_data
549: );
550:
551: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 642: FND_FILE.PUT_LINE

638:
639: l_rows_processed := SQL%ROWCOUNT;
640: l_end := DBMS_UTILITY.GET_TIME;
641: l_log := 'After State Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
642: FND_FILE.PUT_LINE
643: (
644: FND_FILE.LOG,
645: l_log
646: );

Line 644: FND_FILE.LOG,

640: l_end := DBMS_UTILITY.GET_TIME;
641: l_log := 'After State Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
642: FND_FILE.PUT_LINE
643: (
644: FND_FILE.LOG,
645: l_log
646: );
647:
648: l_start := DBMS_UTILITY.GET_TIME;

Line 665: FND_FILE.PUT_LINE

661:
662: l_rows_processed := SQL%ROWCOUNT;
663: l_end := DBMS_UTILITY.GET_TIME;
664: l_log := 'After State Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
665: FND_FILE.PUT_LINE
666: (
667: FND_FILE.LOG,
668: l_log
669: );

Line 667: FND_FILE.LOG,

663: l_end := DBMS_UTILITY.GET_TIME;
664: l_log := 'After State Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
665: FND_FILE.PUT_LINE
666: (
667: FND_FILE.LOG,
668: l_log
669: );
670:
671: l_start := DBMS_UTILITY.GET_TIME;

Line 694: FND_FILE.PUT_LINE

690:
691: l_rows_processed := SQL%ROWCOUNT;
692: l_end := DBMS_UTILITY.GET_TIME;
693: l_log := 'After County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
694: FND_FILE.PUT_LINE
695: (
696: FND_FILE.LOG,
697: l_log
698: );

Line 696: FND_FILE.LOG,

692: l_end := DBMS_UTILITY.GET_TIME;
693: l_log := 'After County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
694: FND_FILE.PUT_LINE
695: (
696: FND_FILE.LOG,
697: l_log
698: );
699:
700: l_start := DBMS_UTILITY.GET_TIME;

Line 719: FND_FILE.PUT_LINE

715:
716: l_rows_processed := SQL%ROWCOUNT;
717: l_end := DBMS_UTILITY.GET_TIME;
718: l_log := 'After County Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
719: FND_FILE.PUT_LINE
720: (
721: FND_FILE.LOG,
722: l_log
723: );

Line 721: FND_FILE.LOG,

717: l_end := DBMS_UTILITY.GET_TIME;
718: l_log := 'After County Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
719: FND_FILE.PUT_LINE
720: (
721: FND_FILE.LOG,
722: l_log
723: );
724:
725: l_start := DBMS_UTILITY.GET_TIME;

Line 768: FND_FILE.PUT_LINE

764: status = 'NOCHANGE'
765: where rowid = l_rowids(i);
766: l_end := DBMS_UTILITY.GET_TIME;
767: l_log := 'After City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
768: FND_FILE.PUT_LINE
769: (
770: FND_FILE.LOG,
771: l_log
772: );

Line 770: FND_FILE.LOG,

766: l_end := DBMS_UTILITY.GET_TIME;
767: l_log := 'After City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
768: FND_FILE.PUT_LINE
769: (
770: FND_FILE.LOG,
771: l_log
772: );
773:
774: l_start := DBMS_UTILITY.GET_TIME;

Line 795: FND_FILE.PUT_LINE

791:
792: l_rows_processed := SQL%ROWCOUNT;
793: l_end := DBMS_UTILITY.GET_TIME;
794: l_log := 'After City Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
795: FND_FILE.PUT_LINE
796: (
797: FND_FILE.LOG,
798: l_log
799: );

Line 797: FND_FILE.LOG,

793: l_end := DBMS_UTILITY.GET_TIME;
794: l_log := 'After City Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
795: FND_FILE.PUT_LINE
796: (
797: FND_FILE.LOG,
798: l_log
799: );
800:
801: l_start := DBMS_UTILITY.GET_TIME;

Line 814: FND_FILE.PUT_LINE

810:
811: l_rows_processed := SQL%ROWCOUNT;
812: l_end := DBMS_UTILITY.GET_TIME;
813: l_log := 'After new State and County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
814: FND_FILE.PUT_LINE
815: (
816: FND_FILE.LOG,
817: l_log
818: );

Line 816: FND_FILE.LOG,

812: l_end := DBMS_UTILITY.GET_TIME;
813: l_log := 'After new State and County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
814: FND_FILE.PUT_LINE
815: (
816: FND_FILE.LOG,
817: l_log
818: );
819:
820: l_start := DBMS_UTILITY.GET_TIME;

Line 853: FND_FILE.PUT_LINE

849:
850: l_rows_processed := SQL%ROWCOUNT;
851: l_end := DBMS_UTILITY.GET_TIME;
852: l_log := 'After new City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
853: FND_FILE.PUT_LINE
854: (
855: FND_FILE.LOG,
856: l_log
857: );

Line 855: FND_FILE.LOG,

851: l_end := DBMS_UTILITY.GET_TIME;
852: l_log := 'After new City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
853: FND_FILE.PUT_LINE
854: (
855: FND_FILE.LOG,
856: l_log
857: );
858:
859: l_start := DBMS_UTILITY.GET_TIME;

Line 879: FND_FILE.PUT_LINE

875:
876: l_rows_processed := SQL%ROWCOUNT;
877: l_end := DBMS_UTILITY.GET_TIME;
878: l_log := 'After new City 2nd Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
879: FND_FILE.PUT_LINE
880: (
881: FND_FILE.LOG,
882: l_log
883: );

Line 881: FND_FILE.LOG,

877: l_end := DBMS_UTILITY.GET_TIME;
878: l_log := 'After new City 2nd Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
879: FND_FILE.PUT_LINE
880: (
881: FND_FILE.LOG,
882: l_log
883: );
884:
885: l_start := DBMS_UTILITY.GET_TIME;

Line 901: FND_FILE.PUT_LINE

897:
898: l_rows_processed := SQL%ROWCOUNT;
899: l_end := DBMS_UTILITY.GET_TIME;
900: l_log := 'After Zip and Alternate City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
901: FND_FILE.PUT_LINE
902: (
903: FND_FILE.LOG,
904: l_log
905: );

Line 903: FND_FILE.LOG,

899: l_end := DBMS_UTILITY.GET_TIME;
900: l_log := 'After Zip and Alternate City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
901: FND_FILE.PUT_LINE
902: (
903: FND_FILE.LOG,
904: l_log
905: );
906:
907: -- The zone type used is different for migrated records and uploaded ones

Line 935: FND_FILE.PUT_LINE

931:
932: l_rows_processed := SQL%ROWCOUNT;
933: l_end := DBMS_UTILITY.GET_TIME;
934: l_log := 'After State Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
935: FND_FILE.PUT_LINE
936: (
937: FND_FILE.LOG,
938: l_log
939: );

Line 937: FND_FILE.LOG,

933: l_end := DBMS_UTILITY.GET_TIME;
934: l_log := 'After State Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
935: FND_FILE.PUT_LINE
936: (
937: FND_FILE.LOG,
938: l_log
939: );
940:
941: l_start := DBMS_UTILITY.GET_TIME;

Line 963: FND_FILE.PUT_LINE

959:
960: l_rows_processed := SQL%ROWCOUNT;
961: l_end := DBMS_UTILITY.GET_TIME;
962: l_log := 'After County Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
963: FND_FILE.PUT_LINE
964: (
965: FND_FILE.LOG,
966: l_log
967: );

Line 965: FND_FILE.LOG,

961: l_end := DBMS_UTILITY.GET_TIME;
962: l_log := 'After County Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
963: FND_FILE.PUT_LINE
964: (
965: FND_FILE.LOG,
966: l_log
967: );
968:
969: l_start := DBMS_UTILITY.GET_TIME;

Line 991: FND_FILE.PUT_LINE

987:
988: l_rows_processed := SQL%ROWCOUNT;
989: l_end := DBMS_UTILITY.GET_TIME;
990: l_log := 'After City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
991: FND_FILE.PUT_LINE
992: (
993: FND_FILE.LOG,
994: l_log
995: );

Line 993: FND_FILE.LOG,

989: l_end := DBMS_UTILITY.GET_TIME;
990: l_log := 'After City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
991: FND_FILE.PUT_LINE
992: (
993: FND_FILE.LOG,
994: l_log
995: );
996:
997: l_start := DBMS_UTILITY.GET_TIME;

Line 1016: FND_FILE.PUT_LINE

1012:
1013: l_rows_processed := SQL%ROWCOUNT;
1014: l_end := DBMS_UTILITY.GET_TIME;
1015: l_log := 'After new State/County/City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1016: FND_FILE.PUT_LINE
1017: (
1018: FND_FILE.LOG,
1019: l_log
1020: );

Line 1018: FND_FILE.LOG,

1014: l_end := DBMS_UTILITY.GET_TIME;
1015: l_log := 'After new State/County/City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1016: FND_FILE.PUT_LINE
1017: (
1018: FND_FILE.LOG,
1019: l_log
1020: );
1021:
1022: l_start := DBMS_UTILITY.GET_TIME;

Line 1069: FND_FILE.PUT_LINE

1065:
1066: l_rows_processed := SQL%ROWCOUNT;
1067: l_end := DBMS_UTILITY.GET_TIME;
1068: l_log := 'After City Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1069: FND_FILE.PUT_LINE
1070: (
1071: FND_FILE.LOG,
1072: l_log
1073: );

Line 1071: FND_FILE.LOG,

1067: l_end := DBMS_UTILITY.GET_TIME;
1068: l_log := 'After City Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1069: FND_FILE.PUT_LINE
1070: (
1071: FND_FILE.LOG,
1072: l_log
1073: );
1074:
1075: l_start := DBMS_UTILITY.GET_TIME;

Line 1118: FND_FILE.PUT_LINE

1114:
1115: l_rows_processed := SQL%ROWCOUNT;
1116: l_end := DBMS_UTILITY.GET_TIME;
1117: l_log := 'After new City Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1118: FND_FILE.PUT_LINE
1119: (
1120: FND_FILE.LOG,
1121: l_log
1122: );

Line 1120: FND_FILE.LOG,

1116: l_end := DBMS_UTILITY.GET_TIME;
1117: l_log := 'After new City Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1118: FND_FILE.PUT_LINE
1119: (
1120: FND_FILE.LOG,
1121: l_log
1122: );
1123:
1124: l_start := DBMS_UTILITY.GET_TIME;

Line 1166: FND_FILE.PUT_LINE

1162:
1163: l_rows_processed := SQL%ROWCOUNT;
1164: l_end := DBMS_UTILITY.GET_TIME;
1165: l_log := 'After County Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1166: FND_FILE.PUT_LINE
1167: (
1168: FND_FILE.LOG,
1169: l_log
1170: );

Line 1168: FND_FILE.LOG,

1164: l_end := DBMS_UTILITY.GET_TIME;
1165: l_log := 'After County Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1166: FND_FILE.PUT_LINE
1167: (
1168: FND_FILE.LOG,
1169: l_log
1170: );
1171:
1172: l_start := DBMS_UTILITY.GET_TIME;

Line 1210: FND_FILE.PUT_LINE

1206:
1207: l_rows_processed := SQL%ROWCOUNT;
1208: l_end := DBMS_UTILITY.GET_TIME;
1209: l_log := 'After new County Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1210: FND_FILE.PUT_LINE
1211: (
1212: FND_FILE.LOG,
1213: l_log
1214: );

Line 1212: FND_FILE.LOG,

1208: l_end := DBMS_UTILITY.GET_TIME;
1209: l_log := 'After new County Override Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1210: FND_FILE.PUT_LINE
1211: (
1212: FND_FILE.LOG,
1213: l_log
1214: );
1215:
1216: ELSE

Line 1241: FND_FILE.PUT_LINE

1237:
1238: l_rows_processed := SQL%ROWCOUNT;
1239: l_end := DBMS_UTILITY.GET_TIME;
1240: l_log := 'After City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1241: FND_FILE.PUT_LINE
1242: (
1243: FND_FILE.LOG,
1244: l_log
1245: );

Line 1243: FND_FILE.LOG,

1239: l_end := DBMS_UTILITY.GET_TIME;
1240: l_log := 'After City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1241: FND_FILE.PUT_LINE
1242: (
1243: FND_FILE.LOG,
1244: l_log
1245: );
1246:
1247: l_start := DBMS_UTILITY.GET_TIME;

Line 1266: FND_FILE.PUT_LINE

1262:
1263: l_rows_processed := SQL%ROWCOUNT;
1264: l_end := DBMS_UTILITY.GET_TIME;
1265: l_log := 'After new City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1266: FND_FILE.PUT_LINE
1267: (
1268: FND_FILE.LOG,
1269: l_log
1270: );

Line 1268: FND_FILE.LOG,

1264: l_end := DBMS_UTILITY.GET_TIME;
1265: l_log := 'After new City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1266: FND_FILE.PUT_LINE
1267: (
1268: FND_FILE.LOG,
1269: l_log
1270: );
1271:
1272: END IF;

Line 1560: FND_FILE.PUT_LINE

1556: -- End : Added for Bug#7298430
1557:
1558: BEGIN
1559:
1560: FND_FILE.PUT_LINE
1561: (
1562: FND_FILE.OUTPUT,
1563: 'Starting validation.'
1564: );

Line 1562: FND_FILE.OUTPUT,

1558: BEGIN
1559:
1560: FND_FILE.PUT_LINE
1561: (
1562: FND_FILE.OUTPUT,
1563: 'Starting validation.'
1564: );
1565: -- Initializing count variables
1566: l_count := 0;

Line 1592: FND_FILE.PUT_LINE

1588: UPDATE zx_data_upload_interface
1589: SET STATUS = 'ERROR',
1590: ERROR_MESSAGE = l_msg
1591: WHERE ROWID = ref_zip.row_id;
1592: FND_FILE.PUT_LINE
1593: (
1594: FND_FILE.OUTPUT,
1595: l_msg
1596: );*/

Line 1594: FND_FILE.OUTPUT,

1590: ERROR_MESSAGE = l_msg
1591: WHERE ROWID = ref_zip.row_id;
1592: FND_FILE.PUT_LINE
1593: (
1594: FND_FILE.OUTPUT,
1595: l_msg
1596: );*/
1597: l_upload_rec.log_msg(l_upload_count) := l_msg;
1598: l_upload_rec.row_id(l_upload_count) := ref_zip.row_id;

Line 1644: FND_FILE.PUT_LINE

1640: UPDATE zx_data_upload_interface
1641: SET STATUS = 'ERROR',
1642: ERROR_MESSAGE = l_msg
1643: WHERE ROWID = ref_rates.row_id;
1644: FND_FILE.PUT_LINE
1645: (
1646: FND_FILE.OUTPUT,
1647: l_msg
1648: );

Line 1646: FND_FILE.OUTPUT,

1642: ERROR_MESSAGE = l_msg
1643: WHERE ROWID = ref_rates.row_id;
1644: FND_FILE.PUT_LINE
1645: (
1646: FND_FILE.OUTPUT,
1647: l_msg
1648: );
1649: END IF; */
1650:

Line 1765: FND_FILE.PUT_LINE

1761: UPDATE zx_data_upload_interface
1762: SET STATUS = 'ERROR',
1763: ERROR_MESSAGE = l_msg
1764: WHERE ROWID = ref_rates.row_id;
1765: FND_FILE.PUT_LINE
1766: (
1767: FND_FILE.OUTPUT,
1768: l_msg
1769: );*/

Line 1767: FND_FILE.OUTPUT,

1763: ERROR_MESSAGE = l_msg
1764: WHERE ROWID = ref_rates.row_id;
1765: FND_FILE.PUT_LINE
1766: (
1767: FND_FILE.OUTPUT,
1768: l_msg
1769: );*/
1770: l_upload_rec.log_msg(l_upload_count) := l_msg;
1771: l_upload_rec.row_id(l_upload_count) := ref_rates.row_id;

Line 1811: FND_FILE.PUT_LINE

1807: UPDATE zx_data_upload_interface
1808: SET STATUS = 'ERROR',
1809: ERROR_MESSAGE = l_msg
1810: WHERE ROWID = ref_rates.row_id;
1811: FND_FILE.PUT_LINE
1812: (
1813: FND_FILE.OUTPUT,
1814: l_msg
1815: );*/

Line 1813: FND_FILE.OUTPUT,

1809: ERROR_MESSAGE = l_msg
1810: WHERE ROWID = ref_rates.row_id;
1811: FND_FILE.PUT_LINE
1812: (
1813: FND_FILE.OUTPUT,
1814: l_msg
1815: );*/
1816: l_upload_rec.log_msg(l_upload_count) := l_msg;
1817: l_upload_rec.row_id(l_upload_count) := ref_rates.row_id;

Line 1922: FND_FILE.PUT_LINE

1918: WHERE ROWID = l_upload_rec.row_id(i);
1919:
1920: FOR i IN NVL(l_upload_rec.log_msg.FIRST,0)..NVL(l_upload_rec.log_msg.LAST,-99)
1921: LOOP
1922: FND_FILE.PUT_LINE
1923: (
1924: FND_FILE.OUTPUT,
1925: l_upload_rec.log_msg(i)
1926: );

Line 1924: FND_FILE.OUTPUT,

1920: FOR i IN NVL(l_upload_rec.log_msg.FIRST,0)..NVL(l_upload_rec.log_msg.LAST,-99)
1921: LOOP
1922: FND_FILE.PUT_LINE
1923: (
1924: FND_FILE.OUTPUT,
1925: l_upload_rec.log_msg(i)
1926: );
1927: END LOOP;
1928: -- End : Added for Bug#7298430

Line 1930: FND_FILE.PUT_LINE

1926: );
1927: END LOOP;
1928: -- End : Added for Bug#7298430
1929:
1930: FND_FILE.PUT_LINE
1931: (
1932: FND_FILE.OUTPUT,
1933: 'Validation Complete.'
1934: );

Line 1932: FND_FILE.OUTPUT,

1928: -- End : Added for Bug#7298430
1929:
1930: FND_FILE.PUT_LINE
1931: (
1932: FND_FILE.OUTPUT,
1933: 'Validation Complete.'
1934: );
1935:
1936: -- Added for Bug#7527399

Line 2821: FND_FILE.PUT_LINE

2817:
2818: WHEN NO_DATA_FOUND THEN
2819: retcode := '1';
2820: errbuf := 'No data found';
2821: FND_FILE.PUT_LINE
2822: (
2823: FND_FILE.LOG,
2824: 'Error in '||l_api_name||': '||errbuf
2825: );

Line 2823: FND_FILE.LOG,

2819: retcode := '1';
2820: errbuf := 'No data found';
2821: FND_FILE.PUT_LINE
2822: (
2823: FND_FILE.LOG,
2824: 'Error in '||l_api_name||': '||errbuf
2825: );
2826:
2827: WHEN OTHERS THEN

Line 2831: FND_FILE.PUT_LINE

2827: WHEN OTHERS THEN
2828: ROLLBACK;
2829: retcode := '2';
2830: errbuf := SQLERRM;
2831: FND_FILE.PUT_LINE
2832: (
2833: FND_FILE.LOG,
2834: 'Unexpected Error in '||l_api_name||': '||errbuf
2835: );

Line 2833: FND_FILE.LOG,

2829: retcode := '2';
2830: errbuf := SQLERRM;
2831: FND_FILE.PUT_LINE
2832: (
2833: FND_FILE.LOG,
2834: 'Unexpected Error in '||l_api_name||': '||errbuf
2835: );
2836:
2837: END CREATE_GEOGRAPHY;

Line 3778: FND_FILE.PUT_LINE

3774:
3775: WHEN NO_DATA_FOUND THEN
3776: retcode := '1';
3777: errbuf := 'No data found';
3778: FND_FILE.PUT_LINE
3779: (
3780: FND_FILE.LOG,
3781: 'Error in '||l_api_name||': '||errbuf
3782: );

Line 3780: FND_FILE.LOG,

3776: retcode := '1';
3777: errbuf := 'No data found';
3778: FND_FILE.PUT_LINE
3779: (
3780: FND_FILE.LOG,
3781: 'Error in '||l_api_name||': '||errbuf
3782: );
3783:
3784: WHEN OTHERS THEN

Line 3788: FND_FILE.PUT_LINE

3784: WHEN OTHERS THEN
3785: ROLLBACK;
3786: retcode := '2';
3787: errbuf := SQLERRM;
3788: FND_FILE.PUT_LINE
3789: (
3790: FND_FILE.LOG,
3791: 'Unexpected Error '||l_api_name||': '||errbuf
3792: );

Line 3790: FND_FILE.LOG,

3786: retcode := '2';
3787: errbuf := SQLERRM;
3788: FND_FILE.PUT_LINE
3789: (
3790: FND_FILE.LOG,
3791: 'Unexpected Error '||l_api_name||': '||errbuf
3792: );
3793:
3794: END CREATE_TAX_ZONES;

Line 4466: FND_FILE.PUT_LINE

4462:
4463: WHEN NO_DATA_FOUND THEN
4464: retcode := '1';
4465: errbuf := 'No data found';
4466: FND_FILE.PUT_LINE
4467: (
4468: FND_FILE.LOG,
4469: 'Error in '||l_api_name||': '||errbuf
4470: );

Line 4468: FND_FILE.LOG,

4464: retcode := '1';
4465: errbuf := 'No data found';
4466: FND_FILE.PUT_LINE
4467: (
4468: FND_FILE.LOG,
4469: 'Error in '||l_api_name||': '||errbuf
4470: );
4471:
4472: WHEN OTHERS THEN

Line 4476: FND_FILE.PUT_LINE

4472: WHEN OTHERS THEN
4473: ROLLBACK;
4474: retcode := '2';
4475: errbuf := SQLERRM;
4476: FND_FILE.PUT_LINE
4477: (
4478: FND_FILE.LOG,
4479: 'Unexpected Error in '||l_api_name||': '||errbuf
4480: );

Line 4478: FND_FILE.LOG,

4474: retcode := '2';
4475: errbuf := SQLERRM;
4476: FND_FILE.PUT_LINE
4477: (
4478: FND_FILE.LOG,
4479: 'Unexpected Error in '||l_api_name||': '||errbuf
4480: );
4481:
4482: END CREATE_ZIP;

Line 4617: FND_FILE.PUT_LINE

4613:
4614: WHEN NO_DATA_FOUND THEN
4615: retcode := '1';
4616: errbuf := 'No data found';
4617: FND_FILE.PUT_LINE
4618: (
4619: FND_FILE.LOG,
4620: 'Error in '||l_api_name||': '||errbuf
4621: );

Line 4619: FND_FILE.LOG,

4615: retcode := '1';
4616: errbuf := 'No data found';
4617: FND_FILE.PUT_LINE
4618: (
4619: FND_FILE.LOG,
4620: 'Error in '||l_api_name||': '||errbuf
4621: );
4622:
4623: WHEN OTHERS THEN

Line 4627: FND_FILE.PUT_LINE

4623: WHEN OTHERS THEN
4624: ROLLBACK;
4625: retcode := '2';
4626: errbuf := SQLERRM;
4627: FND_FILE.PUT_LINE
4628: (
4629: FND_FILE.LOG,
4630: 'Unexpected Error in '||l_api_name||': '||errbuf
4631: );

Line 4629: FND_FILE.LOG,

4625: retcode := '2';
4626: errbuf := SQLERRM;
4627: FND_FILE.PUT_LINE
4628: (
4629: FND_FILE.LOG,
4630: 'Unexpected Error in '||l_api_name||': '||errbuf
4631: );
4632:
4633: END CREATE_ALTERNATE_CITIES;

Line 5253: FND_FILE.PUT_LINE

5249:
5250: WHEN NO_DATA_FOUND THEN
5251: retcode := '1';
5252: errbuf := 'No data found';
5253: FND_FILE.PUT_LINE
5254: (
5255: FND_FILE.LOG,
5256: 'Error in '||l_api_name||': '||errbuf
5257: );

Line 5255: FND_FILE.LOG,

5251: retcode := '1';
5252: errbuf := 'No data found';
5253: FND_FILE.PUT_LINE
5254: (
5255: FND_FILE.LOG,
5256: 'Error in '||l_api_name||': '||errbuf
5257: );
5258:
5259: WHEN OTHERS THEN

Line 5263: FND_FILE.PUT_LINE

5259: WHEN OTHERS THEN
5260: ROLLBACK;
5261: retcode := '2';
5262: errbuf := SQLERRM;
5263: FND_FILE.PUT_LINE
5264: (
5265: FND_FILE.LOG,
5266: 'Unexpected Error in '||l_api_name||': '||errbuf
5267: );

Line 5265: FND_FILE.LOG,

5261: retcode := '2';
5262: errbuf := SQLERRM;
5263: FND_FILE.PUT_LINE
5264: (
5265: FND_FILE.LOG,
5266: 'Unexpected Error in '||l_api_name||': '||errbuf
5267: );
5268:
5269: END CREATE_RATES;

Line 5414: FND_FILE.PUT_LINE

5410: l_submit_phase := 1;
5411:
5412: ELSE
5413:
5414: FND_FILE.PUT_LINE
5415: (
5416: FND_FILE.LOG,
5417: 'Starting status check of sub-request, ids obtained from global: '||l_req_data
5418: );

Line 5416: FND_FILE.LOG,

5412: ELSE
5413:
5414: FND_FILE.PUT_LINE
5415: (
5416: FND_FILE.LOG,
5417: 'Starting status check of sub-request, ids obtained from global: '||l_req_data
5418: );
5419: -- Check status of sub-requests
5420: l_current_pos := INSTR(l_req_data,'-',1);

Line 5452: FND_FILE.PUT_LINE

5448: dev_phase => l_dev_phase,
5449: dev_status => l_dev_status,
5450: message => l_message
5451: );
5452: FND_FILE.PUT_LINE
5453: (
5454: FND_FILE.LOG,
5455: 'Checking status of sub-request, id: '||l_request_id||', return dev status value:'||l_dev_status||', return status value:'||l_status
5456: );

Line 5454: FND_FILE.LOG,

5450: message => l_message
5451: );
5452: FND_FILE.PUT_LINE
5453: (
5454: FND_FILE.LOG,
5455: 'Checking status of sub-request, id: '||l_request_id||', return dev status value:'||l_dev_status||', return status value:'||l_status
5456: );
5457: IF (l_check_status AND (l_dev_status = 'ERROR'))
5458: THEN

Line 5598: FND_FILE.PUT_LINE

5594:
5595: WHEN l_error THEN
5596: ROLLBACK;
5597: retcode := '2';
5598: FND_FILE.PUT_LINE
5599: (
5600: FND_FILE.LOG,
5601: 'Error in '||l_api_name||': '||errbuf
5602: );

Line 5600: FND_FILE.LOG,

5596: ROLLBACK;
5597: retcode := '2';
5598: FND_FILE.PUT_LINE
5599: (
5600: FND_FILE.LOG,
5601: 'Error in '||l_api_name||': '||errbuf
5602: );
5603:
5604: WHEN OTHERS THEN

Line 5608: FND_FILE.PUT_LINE

5604: WHEN OTHERS THEN
5605: ROLLBACK;
5606: retcode := '2';
5607: errbuf := SQLERRM;
5608: FND_FILE.PUT_LINE
5609: (
5610: FND_FILE.LOG,
5611: 'Unexpected Error in '||l_api_name||': '||errbuf
5612: );

Line 5610: FND_FILE.LOG,

5606: retcode := '2';
5607: errbuf := SQLERRM;
5608: FND_FILE.PUT_LINE
5609: (
5610: FND_FILE.LOG,
5611: 'Unexpected Error in '||l_api_name||': '||errbuf
5612: );
5613:
5614: END PROCESS_DATA;

Line 5752: FND_FILE.PUT_LINE

5748:
5749: WHEN l_error THEN
5750: ROLLBACK;
5751: retcode := '2';
5752: FND_FILE.PUT_LINE
5753: (
5754: FND_FILE.LOG,
5755: 'Error in '||l_api_name||': '||errbuf
5756: );

Line 5754: FND_FILE.LOG,

5750: ROLLBACK;
5751: retcode := '2';
5752: FND_FILE.PUT_LINE
5753: (
5754: FND_FILE.LOG,
5755: 'Error in '||l_api_name||': '||errbuf
5756: );
5757:
5758: WHEN OTHERS THEN

Line 5762: FND_FILE.PUT_LINE

5758: WHEN OTHERS THEN
5759: ROLLBACK;
5760: retcode := '2';
5761: errbuf := SQLERRM;
5762: FND_FILE.PUT_LINE
5763: (
5764: FND_FILE.LOG,
5765: 'Unexpected Error in '||l_api_name||': '||errbuf
5766: );

Line 5764: FND_FILE.LOG,

5760: retcode := '2';
5761: errbuf := SQLERRM;
5762: FND_FILE.PUT_LINE
5763: (
5764: FND_FILE.LOG,
5765: 'Unexpected Error in '||l_api_name||': '||errbuf
5766: );
5767:
5768: END POST_PROCESS_DATA;

Line 5803: FND_FILE.PUT_LINE

5799: IF (l_req_data IS NULL)
5800: THEN
5801:
5802: l_req_data := 'LOAD-FILE';
5803: FND_FILE.PUT_LINE
5804: (
5805: FND_FILE.LOG,
5806: 'Validating input parameters.'
5807: );

Line 5805: FND_FILE.LOG,

5801:
5802: l_req_data := 'LOAD-FILE';
5803: FND_FILE.PUT_LINE
5804: (
5805: FND_FILE.LOG,
5806: 'Validating input parameters.'
5807: );
5808:
5809: IF (p_file_location_name IS NULL)

Line 5827: FND_FILE.PUT_LINE

5823: errbuf := 'Please select a valid Tax Regime to load the data into.';
5824: RAISE l_error;
5825: END IF;
5826:
5827: FND_FILE.PUT_LINE
5828: (
5829: FND_FILE.LOG,
5830: 'Calling Sql*Loader to load data.'
5831: );

Line 5829: FND_FILE.LOG,

5825: END IF;
5826:
5827: FND_FILE.PUT_LINE
5828: (
5829: FND_FILE.LOG,
5830: 'Calling Sql*Loader to load data.'
5831: );
5832: l_request_id := fnd_request.submit_request
5833: (

Line 5866: FND_FILE.PUT_LINE

5862: errbuf := 'No data uploaded, check data file location and name.';
5863: RAISE l_error;
5864: END IF;
5865:
5866: FND_FILE.PUT_LINE
5867: (
5868: FND_FILE.LOG,
5869: 'Data uploaded into interface table. No. of records: '||l_data_count
5870: );

Line 5868: FND_FILE.LOG,

5864: END IF;
5865:
5866: FND_FILE.PUT_LINE
5867: (
5868: FND_FILE.LOG,
5869: 'Data uploaded into interface table. No. of records: '||l_data_count
5870: );
5871:
5872: END IF;

Line 5878: FND_FILE.PUT_LINE

5874: EXCEPTION
5875:
5876: WHEN l_error THEN
5877: retcode := '2';
5878: FND_FILE.PUT_LINE
5879: (
5880: FND_FILE.LOG,
5881: 'Error in '||l_api_name||': '||errbuf
5882: );

Line 5880: FND_FILE.LOG,

5876: WHEN l_error THEN
5877: retcode := '2';
5878: FND_FILE.PUT_LINE
5879: (
5880: FND_FILE.LOG,
5881: 'Error in '||l_api_name||': '||errbuf
5882: );
5883:
5884: WHEN OTHERS THEN

Line 5887: FND_FILE.PUT_LINE

5883:
5884: WHEN OTHERS THEN
5885: retcode := '2';
5886: errbuf := SQLERRM;
5887: FND_FILE.PUT_LINE
5888: (
5889: FND_FILE.LOG,
5890: 'Unexpected Error in '||l_api_name||': '||errbuf
5891: );

Line 5889: FND_FILE.LOG,

5885: retcode := '2';
5886: errbuf := SQLERRM;
5887: FND_FILE.PUT_LINE
5888: (
5889: FND_FILE.LOG,
5890: 'Unexpected Error in '||l_api_name||': '||errbuf
5891: );
5892:
5893: END LOAD_FILE;