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 345: FND_FILE.PUT_LINE

341: NULL ,
342: 'Y' --APPLICABLE_BY_DEFAULT_FLAG
343: );
344:
345: FND_FILE.PUT_LINE
346: (
347: FND_FILE.LOG,
348: 'Record Inserted: '||TO_CHAR(SQL%ROWCOUNT)
349: );

Line 347: FND_FILE.LOG,

343: );
344:
345: FND_FILE.PUT_LINE
346: (
347: FND_FILE.LOG,
348: 'Record Inserted: '||TO_CHAR(SQL%ROWCOUNT)
349: );
350:
351: FND_FILE.PUT_LINE

Line 351: FND_FILE.PUT_LINE

347: FND_FILE.LOG,
348: 'Record Inserted: '||TO_CHAR(SQL%ROWCOUNT)
349: );
350:
351: FND_FILE.PUT_LINE
352: (
353: FND_FILE.LOG,
354: 'Creating TL Record for Tax '||l_tax||'.'
355: );

Line 353: FND_FILE.LOG,

349: );
350:
351: FND_FILE.PUT_LINE
352: (
353: FND_FILE.LOG,
354: 'Creating TL Record for Tax '||l_tax||'.'
355: );
356:
357: INSERT INTO ZX_TAXES_TL

Line 386: FND_FILE.PUT_LINE

382: AND ztb.TAX_REGIME_CODE = p_tax_regime_code
383: AND ztb.CONTENT_OWNER_ID = -99
384: AND ztb.TAX = l_tax;
385:
386: FND_FILE.PUT_LINE
387: (
388: FND_FILE.LOG,
389: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
390: );

Line 388: FND_FILE.LOG,

384: AND ztb.TAX = l_tax;
385:
386: FND_FILE.PUT_LINE
387: (
388: FND_FILE.LOG,
389: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
390: );
391:
392: END IF;

Line 403: FND_FILE.PUT_LINE

399:
400: IF (NVL(l_exists_flag,'N') = 'N')
401: THEN
402:
403: FND_FILE.PUT_LINE
404: (
405: FND_FILE.LOG,
406: 'Creating STANDARD Tax Status for Tax: '||l_tax||'.'
407: );

Line 405: FND_FILE.LOG,

401: THEN
402:
403: FND_FILE.PUT_LINE
404: (
405: FND_FILE.LOG,
406: 'Creating STANDARD Tax Status for Tax: '||l_tax||'.'
407: );
408:
409: INSERT INTO ZX_STATUS_B_TMP

Line 494: FND_FILE.PUT_LINE

490: fnd_global.conc_request_id ,-- Request Id
491: 1
492: );
493:
494: FND_FILE.PUT_LINE
495: (
496: FND_FILE.LOG,
497: 'Record Inserted: '||TO_CHAR(SQL%ROWCOUNT)
498: );

Line 496: FND_FILE.LOG,

492: );
493:
494: FND_FILE.PUT_LINE
495: (
496: FND_FILE.LOG,
497: 'Record Inserted: '||TO_CHAR(SQL%ROWCOUNT)
498: );
499:
500: FND_FILE.PUT_LINE

Line 500: FND_FILE.PUT_LINE

496: FND_FILE.LOG,
497: 'Record Inserted: '||TO_CHAR(SQL%ROWCOUNT)
498: );
499:
500: FND_FILE.PUT_LINE
501: (
502: FND_FILE.LOG,
503: 'Creating TL Record for the Tax Status.'
504: );

Line 502: FND_FILE.LOG,

498: );
499:
500: FND_FILE.PUT_LINE
501: (
502: FND_FILE.LOG,
503: 'Creating TL Record for the Tax Status.'
504: );
505:
506: INSERT INTO ZX_STATUS_TL

Line 536: FND_FILE.PUT_LINE

532: AND zsb.CONTENT_OWNER_ID = -99
533: AND zsb.TAX = l_tax
534: AND zsb.TAX_STATUS_CODE = 'STANDARD';
535:
536: FND_FILE.PUT_LINE
537: (
538: FND_FILE.LOG,
539: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
540: );

Line 538: FND_FILE.LOG,

534: AND zsb.TAX_STATUS_CODE = 'STANDARD';
535:
536: FND_FILE.PUT_LINE
537: (
538: FND_FILE.LOG,
539: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
540: );
541:
542: END IF;

Line 555: FND_FILE.PUT_LINE

551:
552: IF (NVL(l_exists_flag,'N') = 'N')
553: THEN
554:
555: FND_FILE.PUT_LINE
556: (
557: FND_FILE.LOG,
558: 'Creating Tax Zone Type: '||p_tax_zone_type||'.'
559: );

Line 557: FND_FILE.LOG,

553: THEN
554:
555: FND_FILE.PUT_LINE
556: (
557: FND_FILE.LOG,
558: 'Creating Tax Zone Type: '||p_tax_zone_type||'.'
559: );
560:
561: l_incl_geo_type(1) := 'COUNTY';

Line 580: FND_FILE.PUT_LINE

576: l_msg_count,
577: l_msg_data
578: );
579:
580: FND_FILE.PUT_LINE
581: (
582: FND_FILE.LOG,
583: 'Status returned by HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type: '||l_return_status||', and message: '||l_msg_data
584: );

Line 582: FND_FILE.LOG,

578: );
579:
580: FND_FILE.PUT_LINE
581: (
582: FND_FILE.LOG,
583: 'Status returned by HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type: '||l_return_status||', and message: '||l_msg_data
584: );
585:
586: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 681: FND_FILE.PUT_LINE

677:
678: l_rows_processed := SQL%ROWCOUNT;
679: l_end := DBMS_UTILITY.GET_TIME;
680: l_log := 'After State Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
681: FND_FILE.PUT_LINE
682: (
683: FND_FILE.LOG,
684: l_log
685: );

Line 683: FND_FILE.LOG,

679: l_end := DBMS_UTILITY.GET_TIME;
680: l_log := 'After State Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
681: FND_FILE.PUT_LINE
682: (
683: FND_FILE.LOG,
684: l_log
685: );
686:
687: l_start := DBMS_UTILITY.GET_TIME;

Line 704: FND_FILE.PUT_LINE

700:
701: l_rows_processed := SQL%ROWCOUNT;
702: l_end := DBMS_UTILITY.GET_TIME;
703: l_log := 'After State Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
704: FND_FILE.PUT_LINE
705: (
706: FND_FILE.LOG,
707: l_log
708: );

Line 706: FND_FILE.LOG,

702: l_end := DBMS_UTILITY.GET_TIME;
703: l_log := 'After State Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
704: FND_FILE.PUT_LINE
705: (
706: FND_FILE.LOG,
707: l_log
708: );
709:
710: l_start := DBMS_UTILITY.GET_TIME;

Line 735: FND_FILE.PUT_LINE

731:
732: l_rows_processed := SQL%ROWCOUNT;
733: l_end := DBMS_UTILITY.GET_TIME;
734: l_log := 'After County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
735: FND_FILE.PUT_LINE
736: (
737: FND_FILE.LOG,
738: l_log
739: );

Line 737: FND_FILE.LOG,

733: l_end := DBMS_UTILITY.GET_TIME;
734: l_log := 'After County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
735: FND_FILE.PUT_LINE
736: (
737: FND_FILE.LOG,
738: l_log
739: );
740:
741: l_start := DBMS_UTILITY.GET_TIME;

Line 760: FND_FILE.PUT_LINE

756:
757: l_rows_processed := SQL%ROWCOUNT;
758: l_end := DBMS_UTILITY.GET_TIME;
759: l_log := 'After County Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
760: FND_FILE.PUT_LINE
761: (
762: FND_FILE.LOG,
763: l_log
764: );

Line 762: FND_FILE.LOG,

758: l_end := DBMS_UTILITY.GET_TIME;
759: l_log := 'After County Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
760: FND_FILE.PUT_LINE
761: (
762: FND_FILE.LOG,
763: l_log
764: );
765:
766: l_start := DBMS_UTILITY.GET_TIME;

Line 814: FND_FILE.PUT_LINE

810: WHERE rowid = l_rowids(i);
811:
812: l_end := DBMS_UTILITY.GET_TIME;
813: l_log := 'After City 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 City 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 842: -- FND_FILE.PUT_LINE

838: --
839: -- l_rows_processed := SQL%ROWCOUNT;
840: -- l_end := DBMS_UTILITY.GET_TIME;
841: -- l_log := 'After City Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
842: -- FND_FILE.PUT_LINE
843: -- (
844: -- FND_FILE.LOG,
845: -- l_log
846: -- );

Line 844: -- FND_FILE.LOG,

840: -- l_end := DBMS_UTILITY.GET_TIME;
841: -- l_log := 'After City Name Change Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
842: -- FND_FILE.PUT_LINE
843: -- (
844: -- FND_FILE.LOG,
845: -- l_log
846: -- );
847:
848: l_start := DBMS_UTILITY.GET_TIME;

Line 861: FND_FILE.PUT_LINE

857:
858: l_rows_processed := SQL%ROWCOUNT;
859: l_end := DBMS_UTILITY.GET_TIME;
860: l_log := 'After new State and County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
861: FND_FILE.PUT_LINE
862: (
863: FND_FILE.LOG,
864: l_log
865: );

Line 863: FND_FILE.LOG,

859: l_end := DBMS_UTILITY.GET_TIME;
860: l_log := 'After new State and County Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
861: FND_FILE.PUT_LINE
862: (
863: FND_FILE.LOG,
864: l_log
865: );
866:
867: l_start := DBMS_UTILITY.GET_TIME;

Line 905: FND_FILE.PUT_LINE

901:
902: l_rows_processed := SQL%ROWCOUNT;
903: l_end := DBMS_UTILITY.GET_TIME;
904: l_log := 'After new City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
905: FND_FILE.PUT_LINE
906: (
907: FND_FILE.LOG,
908: l_log
909: );

Line 907: FND_FILE.LOG,

903: l_end := DBMS_UTILITY.GET_TIME;
904: l_log := 'After new City Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
905: FND_FILE.PUT_LINE
906: (
907: FND_FILE.LOG,
908: l_log
909: );
910:
911: l_start := DBMS_UTILITY.GET_TIME;

Line 930: FND_FILE.PUT_LINE

926:
927: l_rows_processed := SQL%ROWCOUNT;
928: l_end := DBMS_UTILITY.GET_TIME;
929: l_log := 'After new City 2nd Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
930: FND_FILE.PUT_LINE
931: (
932: FND_FILE.LOG,
933: l_log
934: );

Line 932: FND_FILE.LOG,

928: l_end := DBMS_UTILITY.GET_TIME;
929: l_log := 'After new City 2nd Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
930: FND_FILE.PUT_LINE
931: (
932: FND_FILE.LOG,
933: l_log
934: );
935:
936: l_start := DBMS_UTILITY.GET_TIME;

Line 949: FND_FILE.PUT_LINE

945:
946: l_rows_processed := SQL%ROWCOUNT;
947: l_end := DBMS_UTILITY.GET_TIME;
948: l_log := 'After new City 3rd Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
949: FND_FILE.PUT_LINE
950: (
951: FND_FILE.LOG,
952: l_log
953: );

Line 951: FND_FILE.LOG,

947: l_end := DBMS_UTILITY.GET_TIME;
948: l_log := 'After new City 3rd Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
949: FND_FILE.PUT_LINE
950: (
951: FND_FILE.LOG,
952: l_log
953: );
954:
955: l_start := DBMS_UTILITY.GET_TIME;

Line 975: FND_FILE.PUT_LINE

971:
972: l_rows_processed := SQL%ROWCOUNT;
973: l_end := DBMS_UTILITY.GET_TIME;
974: l_log := 'After Zip Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
975: FND_FILE.PUT_LINE
976: (
977: FND_FILE.LOG,
978: l_log
979: );

Line 977: FND_FILE.LOG,

973: l_end := DBMS_UTILITY.GET_TIME;
974: l_log := 'After Zip Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
975: FND_FILE.PUT_LINE
976: (
977: FND_FILE.LOG,
978: l_log
979: );
980:
981: -- The zone type used is different for migrated records and uploaded ones

Line 1012: FND_FILE.PUT_LINE

1008:
1009: l_rows_processed := SQL%ROWCOUNT;
1010: l_end := DBMS_UTILITY.GET_TIME;
1011: l_log := 'After State Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1012: FND_FILE.PUT_LINE
1013: (
1014: FND_FILE.LOG,
1015: l_log
1016: );

Line 1014: FND_FILE.LOG,

1010: l_end := DBMS_UTILITY.GET_TIME;
1011: l_log := 'After State Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1012: FND_FILE.PUT_LINE
1013: (
1014: FND_FILE.LOG,
1015: l_log
1016: );
1017:
1018: l_start := DBMS_UTILITY.GET_TIME;

Line 1044: FND_FILE.PUT_LINE

1040:
1041: l_rows_processed := SQL%ROWCOUNT;
1042: l_end := DBMS_UTILITY.GET_TIME;
1043: l_log := 'After County Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1044: FND_FILE.PUT_LINE
1045: (
1046: FND_FILE.LOG,
1047: l_log
1048: );

Line 1046: FND_FILE.LOG,

1042: l_end := DBMS_UTILITY.GET_TIME;
1043: l_log := 'After County Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1044: FND_FILE.PUT_LINE
1045: (
1046: FND_FILE.LOG,
1047: l_log
1048: );
1049:
1050: l_start := DBMS_UTILITY.GET_TIME;

Line 1076: FND_FILE.PUT_LINE

1072:
1073: l_rows_processed := SQL%ROWCOUNT;
1074: l_end := DBMS_UTILITY.GET_TIME;
1075: l_log := 'After City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1076: FND_FILE.PUT_LINE
1077: (
1078: FND_FILE.LOG,
1079: l_log
1080: );

Line 1078: FND_FILE.LOG,

1074: l_end := DBMS_UTILITY.GET_TIME;
1075: l_log := 'After City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1076: FND_FILE.PUT_LINE
1077: (
1078: FND_FILE.LOG,
1079: l_log
1080: );
1081:
1082: l_start := DBMS_UTILITY.GET_TIME;

Line 1103: FND_FILE.PUT_LINE

1099:
1100: l_rows_processed := SQL%ROWCOUNT;
1101: l_end := DBMS_UTILITY.GET_TIME;
1102: l_log := 'After City Zone UPDATE 2, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1103: FND_FILE.PUT_LINE
1104: (
1105: FND_FILE.LOG,
1106: l_log
1107: );

Line 1105: FND_FILE.LOG,

1101: l_end := DBMS_UTILITY.GET_TIME;
1102: l_log := 'After City Zone UPDATE 2, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1103: FND_FILE.PUT_LINE
1104: (
1105: FND_FILE.LOG,
1106: l_log
1107: );
1108:
1109: l_start := DBMS_UTILITY.GET_TIME;

Line 1127: FND_FILE.PUT_LINE

1123:
1124: l_rows_processed := SQL%ROWCOUNT;
1125: l_end := DBMS_UTILITY.GET_TIME;
1126: l_log := 'After new State/County Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1127: FND_FILE.PUT_LINE
1128: (
1129: FND_FILE.LOG,
1130: l_log
1131: );

Line 1129: FND_FILE.LOG,

1125: l_end := DBMS_UTILITY.GET_TIME;
1126: l_log := 'After new State/County Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1127: FND_FILE.PUT_LINE
1128: (
1129: FND_FILE.LOG,
1130: l_log
1131: );
1132:
1133: l_start := DBMS_UTILITY.GET_TIME;

Line 1146: FND_FILE.PUT_LINE

1142:
1143: l_rows_processed := SQL%ROWCOUNT;
1144: l_end := DBMS_UTILITY.GET_TIME;
1145: l_log := 'After new Primary City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1146: FND_FILE.PUT_LINE
1147: (
1148: FND_FILE.LOG,
1149: l_log
1150: );

Line 1148: FND_FILE.LOG,

1144: l_end := DBMS_UTILITY.GET_TIME;
1145: l_log := 'After new Primary City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1146: FND_FILE.PUT_LINE
1147: (
1148: FND_FILE.LOG,
1149: l_log
1150: );
1151:
1152: l_start := DBMS_UTILITY.GET_TIME;

Line 1175: FND_FILE.PUT_LINE

1171:
1172: l_rows_processed := SQL%ROWCOUNT;
1173: l_end := DBMS_UTILITY.GET_TIME;
1174: l_log := 'After new Non Primary City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1175: FND_FILE.PUT_LINE
1176: (
1177: FND_FILE.LOG,
1178: l_log
1179: );

Line 1177: FND_FILE.LOG,

1173: l_end := DBMS_UTILITY.GET_TIME;
1174: l_log := 'After new Non Primary City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1175: FND_FILE.PUT_LINE
1176: (
1177: FND_FILE.LOG,
1178: l_log
1179: );
1180:
1181: l_start := DBMS_UTILITY.GET_TIME;

Line 1235: FND_FILE.PUT_LINE

1231:
1232: l_rows_processed := SQL%ROWCOUNT;
1233: l_end := DBMS_UTILITY.GET_TIME;
1234: l_log := 'After City Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1235: FND_FILE.PUT_LINE
1236: (
1237: FND_FILE.LOG,
1238: l_log
1239: );

Line 1237: FND_FILE.LOG,

1233: l_end := DBMS_UTILITY.GET_TIME;
1234: l_log := 'After City Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1235: FND_FILE.PUT_LINE
1236: (
1237: FND_FILE.LOG,
1238: l_log
1239: );
1240:
1241: l_start := DBMS_UTILITY.GET_TIME;

Line 1287: FND_FILE.PUT_LINE

1283:
1284: l_rows_processed := SQL%ROWCOUNT;
1285: l_end := DBMS_UTILITY.GET_TIME;
1286: l_log := 'After new City Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1287: FND_FILE.PUT_LINE
1288: (
1289: FND_FILE.LOG,
1290: l_log
1291: );

Line 1289: FND_FILE.LOG,

1285: l_end := DBMS_UTILITY.GET_TIME;
1286: l_log := 'After new City Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1287: FND_FILE.PUT_LINE
1288: (
1289: FND_FILE.LOG,
1290: l_log
1291: );
1292:
1293: l_start := DBMS_UTILITY.GET_TIME;

Line 1341: FND_FILE.PUT_LINE

1337:
1338: l_rows_processed := SQL%ROWCOUNT;
1339: l_end := DBMS_UTILITY.GET_TIME;
1340: l_log := 'After County Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1341: FND_FILE.PUT_LINE
1342: (
1343: FND_FILE.LOG,
1344: l_log
1345: );

Line 1343: FND_FILE.LOG,

1339: l_end := DBMS_UTILITY.GET_TIME;
1340: l_log := 'After County Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1341: FND_FILE.PUT_LINE
1342: (
1343: FND_FILE.LOG,
1344: l_log
1345: );
1346:
1347: l_start := DBMS_UTILITY.GET_TIME;

Line 1387: FND_FILE.PUT_LINE

1383:
1384: l_rows_processed := SQL%ROWCOUNT;
1385: l_end := DBMS_UTILITY.GET_TIME;
1386: l_log := 'After new County Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1387: FND_FILE.PUT_LINE
1388: (
1389: FND_FILE.LOG,
1390: l_log
1391: );

Line 1389: FND_FILE.LOG,

1385: l_end := DBMS_UTILITY.GET_TIME;
1386: l_log := 'After new County Override Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1387: FND_FILE.PUT_LINE
1388: (
1389: FND_FILE.LOG,
1390: l_log
1391: );
1392:
1393: ELSE

Line 1421: FND_FILE.PUT_LINE

1417:
1418: l_rows_processed := SQL%ROWCOUNT;
1419: l_end := DBMS_UTILITY.GET_TIME;
1420: l_log := 'After City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1421: FND_FILE.PUT_LINE
1422: (
1423: FND_FILE.LOG,
1424: l_log
1425: );

Line 1423: FND_FILE.LOG,

1419: l_end := DBMS_UTILITY.GET_TIME;
1420: l_log := 'After City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1421: FND_FILE.PUT_LINE
1422: (
1423: FND_FILE.LOG,
1424: l_log
1425: );
1426:
1427: l_start := DBMS_UTILITY.GET_TIME;

Line 1446: FND_FILE.PUT_LINE

1442:
1443: l_rows_processed := SQL%ROWCOUNT;
1444: l_end := DBMS_UTILITY.GET_TIME;
1445: l_log := 'After City Zone UPDATE 2, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1446: FND_FILE.PUT_LINE
1447: (
1448: FND_FILE.LOG,
1449: l_log
1450: );

Line 1448: FND_FILE.LOG,

1444: l_end := DBMS_UTILITY.GET_TIME;
1445: l_log := 'After City Zone UPDATE 2, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1446: FND_FILE.PUT_LINE
1447: (
1448: FND_FILE.LOG,
1449: l_log
1450: );
1451:
1452: l_start := DBMS_UTILITY.GET_TIME;

Line 1471: FND_FILE.PUT_LINE

1467:
1468: l_rows_processed := SQL%ROWCOUNT;
1469: l_end := DBMS_UTILITY.GET_TIME;
1470: l_log := 'After new Primary City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1471: FND_FILE.PUT_LINE
1472: (
1473: FND_FILE.LOG,
1474: l_log
1475: );

Line 1473: FND_FILE.LOG,

1469: l_end := DBMS_UTILITY.GET_TIME;
1470: l_log := 'After new Primary City Zone UPDATE, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1471: FND_FILE.PUT_LINE
1472: (
1473: FND_FILE.LOG,
1474: l_log
1475: );
1476:
1477: UPDATE ZX_DATA_UPLOAD_INTERFACE x

Line 1496: FND_FILE.PUT_LINE

1492:
1493: l_rows_processed := SQL%ROWCOUNT;
1494: l_end := DBMS_UTILITY.GET_TIME;
1495: l_log := 'After new City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1496: FND_FILE.PUT_LINE
1497: (
1498: FND_FILE.LOG,
1499: l_log
1500: );

Line 1498: FND_FILE.LOG,

1494: l_end := DBMS_UTILITY.GET_TIME;
1495: l_log := 'After new City Zone Update, rows processed:'||l_rows_processed||', in time (ms):'||to_char((l_end-l_start)*10);
1496: FND_FILE.PUT_LINE
1497: (
1498: FND_FILE.LOG,
1499: l_log
1500: );
1501:
1502: END IF;

Line 1840: FND_FILE.PUT_LINE

1836: -- End : Added for Bug#7298430
1837:
1838: BEGIN
1839:
1840: FND_FILE.PUT_LINE
1841: (
1842: FND_FILE.OUTPUT,
1843: 'Starting validation.'
1844: );

Line 1842: FND_FILE.OUTPUT,

1838: BEGIN
1839:
1840: FND_FILE.PUT_LINE
1841: (
1842: FND_FILE.OUTPUT,
1843: 'Starting validation.'
1844: );
1845: -- Initializing count variables
1846: l_count := 0;

Line 1872: FND_FILE.PUT_LINE

1868: UPDATE zx_data_upload_interface
1869: SET STATUS = 'ERROR',
1870: ERROR_MESSAGE = l_msg
1871: WHERE ROWID = ref_zip.row_id;
1872: FND_FILE.PUT_LINE
1873: (
1874: FND_FILE.OUTPUT,
1875: l_msg
1876: );*/

Line 1874: FND_FILE.OUTPUT,

1870: ERROR_MESSAGE = l_msg
1871: WHERE ROWID = ref_zip.row_id;
1872: FND_FILE.PUT_LINE
1873: (
1874: FND_FILE.OUTPUT,
1875: l_msg
1876: );*/
1877: l_upload_rec.log_msg(l_upload_count) := l_msg;
1878: l_upload_rec.row_id(l_upload_count) := ref_zip.row_id;

Line 1924: FND_FILE.PUT_LINE

1920: UPDATE zx_data_upload_interface
1921: SET STATUS = 'ERROR',
1922: ERROR_MESSAGE = l_msg
1923: WHERE ROWID = ref_rates.row_id;
1924: FND_FILE.PUT_LINE
1925: (
1926: FND_FILE.OUTPUT,
1927: l_msg
1928: );

Line 1926: FND_FILE.OUTPUT,

1922: ERROR_MESSAGE = l_msg
1923: WHERE ROWID = ref_rates.row_id;
1924: FND_FILE.PUT_LINE
1925: (
1926: FND_FILE.OUTPUT,
1927: l_msg
1928: );
1929: END IF; */
1930:

Line 2047: FND_FILE.PUT_LINE

2043: UPDATE zx_data_upload_interface
2044: SET STATUS = 'ERROR',
2045: ERROR_MESSAGE = l_msg
2046: WHERE ROWID = ref_rates.row_id;
2047: FND_FILE.PUT_LINE
2048: (
2049: FND_FILE.OUTPUT,
2050: l_msg
2051: );*/

Line 2049: FND_FILE.OUTPUT,

2045: ERROR_MESSAGE = l_msg
2046: WHERE ROWID = ref_rates.row_id;
2047: FND_FILE.PUT_LINE
2048: (
2049: FND_FILE.OUTPUT,
2050: l_msg
2051: );*/
2052: l_upload_rec.log_msg(l_upload_count) := l_msg;
2053: l_upload_rec.row_id(l_upload_count) := ref_rates.row_id;

Line 2093: FND_FILE.PUT_LINE

2089: UPDATE zx_data_upload_interface
2090: SET STATUS = 'ERROR',
2091: ERROR_MESSAGE = l_msg
2092: WHERE ROWID = ref_rates.row_id;
2093: FND_FILE.PUT_LINE
2094: (
2095: FND_FILE.OUTPUT,
2096: l_msg
2097: );*/

Line 2095: FND_FILE.OUTPUT,

2091: ERROR_MESSAGE = l_msg
2092: WHERE ROWID = ref_rates.row_id;
2093: FND_FILE.PUT_LINE
2094: (
2095: FND_FILE.OUTPUT,
2096: l_msg
2097: );*/
2098: l_upload_rec.log_msg(l_upload_count) := l_msg;
2099: l_upload_rec.row_id(l_upload_count) := ref_rates.row_id;

Line 2205: FND_FILE.PUT_LINE

2201: WHERE ROWID = l_upload_rec.row_id(i);
2202:
2203: FOR i IN NVL(l_upload_rec.log_msg.FIRST,0)..NVL(l_upload_rec.log_msg.LAST,-99)
2204: LOOP
2205: FND_FILE.PUT_LINE
2206: (
2207: FND_FILE.OUTPUT,
2208: l_upload_rec.log_msg(i)
2209: );

Line 2207: FND_FILE.OUTPUT,

2203: FOR i IN NVL(l_upload_rec.log_msg.FIRST,0)..NVL(l_upload_rec.log_msg.LAST,-99)
2204: LOOP
2205: FND_FILE.PUT_LINE
2206: (
2207: FND_FILE.OUTPUT,
2208: l_upload_rec.log_msg(i)
2209: );
2210: END LOOP;
2211: -- End : Added for Bug#7298430

Line 2213: FND_FILE.PUT_LINE

2209: );
2210: END LOOP;
2211: -- End : Added for Bug#7298430
2212:
2213: FND_FILE.PUT_LINE
2214: (
2215: FND_FILE.OUTPUT,
2216: 'Validation Complete.'
2217: );

Line 2215: FND_FILE.OUTPUT,

2211: -- End : Added for Bug#7298430
2212:
2213: FND_FILE.PUT_LINE
2214: (
2215: FND_FILE.OUTPUT,
2216: 'Validation Complete.'
2217: );
2218:
2219: -- Added for Bug#7527399

Line 2282: FND_FILE.PUT_LINE

2278:
2279: WHILE (l_any_rows_to_process)
2280: LOOP*/
2281:
2282: FND_FILE.PUT_LINE
2283: (
2284: FND_FILE.LOG,
2285: 'Creating Geographies.'
2286: );

Line 2284: FND_FILE.LOG,

2280: LOOP*/
2281:
2282: FND_FILE.PUT_LINE
2283: (
2284: FND_FILE.LOG,
2285: 'Creating Geographies.'
2286: );
2287:
2288: INSERT ALL

Line 3077: FND_FILE.PUT_LINE

3073: AND state.country_code = county.country_code
3074: AND state.effective_to IS NULL
3075: ) v;
3076:
3077: FND_FILE.PUT_LINE
3078: (
3079: FND_FILE.LOG,
3080: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
3081: );

Line 3079: FND_FILE.LOG,

3075: ) v;
3076:
3077: FND_FILE.PUT_LINE
3078: (
3079: FND_FILE.LOG,
3080: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
3081: );
3082:
3083: /*

Line 3112: FND_FILE.PUT_LINE

3108:
3109: WHEN NO_DATA_FOUND THEN
3110: retcode := '1';
3111: errbuf := 'No data found';
3112: FND_FILE.PUT_LINE
3113: (
3114: FND_FILE.LOG,
3115: 'Error in '||l_api_name||': '||errbuf
3116: );

Line 3114: FND_FILE.LOG,

3110: retcode := '1';
3111: errbuf := 'No data found';
3112: FND_FILE.PUT_LINE
3113: (
3114: FND_FILE.LOG,
3115: 'Error in '||l_api_name||': '||errbuf
3116: );
3117:
3118: WHEN OTHERS THEN

Line 3122: FND_FILE.PUT_LINE

3118: WHEN OTHERS THEN
3119: ROLLBACK;
3120: retcode := '2';
3121: errbuf := SQLERRM;
3122: FND_FILE.PUT_LINE
3123: (
3124: FND_FILE.LOG,
3125: 'Unexpected Error in '||l_api_name||': '||errbuf
3126: );

Line 3124: FND_FILE.LOG,

3120: retcode := '2';
3121: errbuf := SQLERRM;
3122: FND_FILE.PUT_LINE
3123: (
3124: FND_FILE.LOG,
3125: 'Unexpected Error in '||l_api_name||': '||errbuf
3126: );
3127:
3128: END CREATE_GEOGRAPHY;

Line 3186: FND_FILE.PUT_LINE

3182:
3183: WHILE (l_any_rows_to_process)
3184: LOOP**/
3185:
3186: FND_FILE.PUT_LINE
3187: (
3188: FND_FILE.LOG,
3189: 'Creating Tax Zones.'
3190: );

Line 3188: FND_FILE.LOG,

3184: LOOP**/
3185:
3186: FND_FILE.PUT_LINE
3187: (
3188: FND_FILE.LOG,
3189: 'Creating Tax Zones.'
3190: );
3191:
3192: INSERT ALL

Line 3789: FND_FILE.PUT_LINE

3785: ) v;
3786:
3787: l_rows_processed := SQL%ROWCOUNT;
3788:
3789: FND_FILE.PUT_LINE
3790: (
3791: FND_FILE.LOG,
3792: 'Records Inserted: '||TO_CHAR(l_rows_processed)
3793: );

Line 3791: FND_FILE.LOG,

3787: l_rows_processed := SQL%ROWCOUNT;
3788:
3789: FND_FILE.PUT_LINE
3790: (
3791: FND_FILE.LOG,
3792: 'Records Inserted: '||TO_CHAR(l_rows_processed)
3793: );
3794:
3795: -- Copy accounts from taxes

Line 3799: FND_FILE.PUT_LINE

3795: -- Copy accounts from taxes
3796: -- Do this only for newly created jurisdicition
3797: -- Use TL table and regime/tax/record type combination to find new ones
3798:
3799: FND_FILE.PUT_LINE
3800: (
3801: FND_FILE.LOG,
3802: 'Creating Tax Accounts for Tax Jurisdictions.'
3803: );

Line 3801: FND_FILE.LOG,

3797: -- Use TL table and regime/tax/record type combination to find new ones
3798:
3799: FND_FILE.PUT_LINE
3800: (
3801: FND_FILE.LOG,
3802: 'Creating Tax Accounts for Tax Jurisdictions.'
3803: );
3804:
3805: INSERT INTO ZX_ACCOUNTS

Line 3877: FND_FILE.PUT_LINE

3873: AND TAX_ACCOUNT_ENTITY_CODE = 'JURISDICTION'
3874: AND LEDGER_ID = za.LEDGER_ID
3875: AND INTERNAL_ORGANIZATION_ID = za.INTERNAL_ORGANIZATION_ID);
3876:
3877: FND_FILE.PUT_LINE
3878: (
3879: FND_FILE.LOG,
3880: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
3881: );

Line 3879: FND_FILE.LOG,

3875: AND INTERNAL_ORGANIZATION_ID = za.INTERNAL_ORGANIZATION_ID);
3876:
3877: FND_FILE.PUT_LINE
3878: (
3879: FND_FILE.LOG,
3880: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
3881: );
3882:
3883: FND_FILE.PUT_LINE

Line 3883: FND_FILE.PUT_LINE

3879: FND_FILE.LOG,
3880: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
3881: );
3882:
3883: FND_FILE.PUT_LINE
3884: (
3885: FND_FILE.LOG,
3886: 'Creating TL for Tax Jurisdictions.'
3887: );

Line 3885: FND_FILE.LOG,

3881: );
3882:
3883: FND_FILE.PUT_LINE
3884: (
3885: FND_FILE.LOG,
3886: 'Creating TL for Tax Jurisdictions.'
3887: );
3888:
3889: INSERT INTO ZX_JURISDICTIONS_TL

Line 3953: FND_FILE.PUT_LINE

3949: AND zjt.LANGUAGE = fl.LANGUAGE_CODE);
3950:
3951: l_rows_processed := SQL%ROWCOUNT;
3952:
3953: FND_FILE.PUT_LINE
3954: (
3955: FND_FILE.LOG,
3956: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
3957: );

Line 3955: FND_FILE.LOG,

3951: l_rows_processed := SQL%ROWCOUNT;
3952:
3953: FND_FILE.PUT_LINE
3954: (
3955: FND_FILE.LOG,
3956: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
3957: );
3958:
3959: -- Changed the For Loop (present till version 26 of 12.0.X)

Line 4138: FND_FILE.PUT_LINE

4134:
4135: WHEN NO_DATA_FOUND THEN
4136: retcode := '1';
4137: errbuf := 'No data found';
4138: FND_FILE.PUT_LINE
4139: (
4140: FND_FILE.LOG,
4141: 'Error in '||l_api_name||': '||errbuf
4142: );

Line 4140: FND_FILE.LOG,

4136: retcode := '1';
4137: errbuf := 'No data found';
4138: FND_FILE.PUT_LINE
4139: (
4140: FND_FILE.LOG,
4141: 'Error in '||l_api_name||': '||errbuf
4142: );
4143:
4144: WHEN OTHERS THEN

Line 4148: FND_FILE.PUT_LINE

4144: WHEN OTHERS THEN
4145: ROLLBACK;
4146: retcode := '2';
4147: errbuf := SQLERRM;
4148: FND_FILE.PUT_LINE
4149: (
4150: FND_FILE.LOG,
4151: 'Unexpected Error '||l_api_name||': '||errbuf
4152: );

Line 4150: FND_FILE.LOG,

4146: retcode := '2';
4147: errbuf := SQLERRM;
4148: FND_FILE.PUT_LINE
4149: (
4150: FND_FILE.LOG,
4151: 'Unexpected Error '||l_api_name||': '||errbuf
4152: );
4153:
4154: END CREATE_TAX_ZONES;

Line 4209: FND_FILE.PUT_LINE

4205:
4206: WHILE (l_any_rows_to_process)
4207: LOOP**/
4208:
4209: FND_FILE.PUT_LINE
4210: (
4211: FND_FILE.LOG,
4212: 'Creating Zip Ranges.'
4213: );

Line 4211: FND_FILE.LOG,

4207: LOOP**/
4208:
4209: FND_FILE.PUT_LINE
4210: (
4211: FND_FILE.LOG,
4212: 'Creating Zip Ranges.'
4213: );
4214:
4215: INSERT ALL

Line 4806: FND_FILE.PUT_LINE

4802: g.geography_element4_id,
4803: g.geography_element4_code,
4804: g.country_code;
4805:
4806: FND_FILE.PUT_LINE
4807: (
4808: FND_FILE.LOG,
4809: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
4810: );

Line 4808: FND_FILE.LOG,

4804: g.country_code;
4805:
4806: FND_FILE.PUT_LINE
4807: (
4808: FND_FILE.LOG,
4809: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
4810: );
4811:
4812: l_rows_processed := SQL%ROWCOUNT;

Line 4838: FND_FILE.PUT_LINE

4834:
4835: WHEN NO_DATA_FOUND THEN
4836: retcode := '1';
4837: errbuf := 'No data found';
4838: FND_FILE.PUT_LINE
4839: (
4840: FND_FILE.LOG,
4841: 'Error in '||l_api_name||': '||errbuf
4842: );

Line 4840: FND_FILE.LOG,

4836: retcode := '1';
4837: errbuf := 'No data found';
4838: FND_FILE.PUT_LINE
4839: (
4840: FND_FILE.LOG,
4841: 'Error in '||l_api_name||': '||errbuf
4842: );
4843:
4844: WHEN OTHERS THEN

Line 4848: FND_FILE.PUT_LINE

4844: WHEN OTHERS THEN
4845: ROLLBACK;
4846: retcode := '2';
4847: errbuf := SQLERRM;
4848: FND_FILE.PUT_LINE
4849: (
4850: FND_FILE.LOG,
4851: 'Unexpected Error in '||l_api_name||': '||errbuf
4852: );

Line 4850: FND_FILE.LOG,

4846: retcode := '2';
4847: errbuf := SQLERRM;
4848: FND_FILE.PUT_LINE
4849: (
4850: FND_FILE.LOG,
4851: 'Unexpected Error in '||l_api_name||': '||errbuf
4852: );
4853:
4854: END CREATE_ZIP;

Line 4909: FND_FILE.PUT_LINE

4905:
4906: WHILE (l_any_rows_to_process)
4907: LOOP**/
4908:
4909: FND_FILE.PUT_LINE
4910: (
4911: FND_FILE.LOG,
4912: 'Creating Alternate Cities.'
4913: );

Line 4911: FND_FILE.LOG,

4907: LOOP**/
4908:
4909: FND_FILE.PUT_LINE
4910: (
4911: FND_FILE.LOG,
4912: 'Creating Alternate Cities.'
4913: );
4914:
4915: INSERT ALL

Line 4969: FND_FILE.PUT_LINE

4965: AND hgi.IDENTIFIER_SUBTYPE = 'STANDARD_NAME'
4966: AND UPPER(hgi.IDENTIFIER_VALUE) = UPPER(inter.geography_name)
4967: AND hgi.LANGUAGE_CODE = 'US');
4968:
4969: FND_FILE.PUT_LINE
4970: (
4971: FND_FILE.LOG,
4972: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
4973: );

Line 4971: FND_FILE.LOG,

4967: AND hgi.LANGUAGE_CODE = 'US');
4968:
4969: FND_FILE.PUT_LINE
4970: (
4971: FND_FILE.LOG,
4972: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
4973: );
4974:
4975: l_rows_processed := SQL%ROWCOUNT;

Line 5001: FND_FILE.PUT_LINE

4997:
4998: WHEN NO_DATA_FOUND THEN
4999: retcode := '1';
5000: errbuf := 'No data found';
5001: FND_FILE.PUT_LINE
5002: (
5003: FND_FILE.LOG,
5004: 'Error in '||l_api_name||': '||errbuf
5005: );

Line 5003: FND_FILE.LOG,

4999: retcode := '1';
5000: errbuf := 'No data found';
5001: FND_FILE.PUT_LINE
5002: (
5003: FND_FILE.LOG,
5004: 'Error in '||l_api_name||': '||errbuf
5005: );
5006:
5007: WHEN OTHERS THEN

Line 5011: FND_FILE.PUT_LINE

5007: WHEN OTHERS THEN
5008: ROLLBACK;
5009: retcode := '2';
5010: errbuf := SQLERRM;
5011: FND_FILE.PUT_LINE
5012: (
5013: FND_FILE.LOG,
5014: 'Unexpected Error in '||l_api_name||': '||errbuf
5015: );

Line 5013: FND_FILE.LOG,

5009: retcode := '2';
5010: errbuf := SQLERRM;
5011: FND_FILE.PUT_LINE
5012: (
5013: FND_FILE.LOG,
5014: 'Unexpected Error in '||l_api_name||': '||errbuf
5015: );
5016:
5017: END CREATE_ALTERNATE_CITIES;

Line 5084: FND_FILE.PUT_LINE

5080:
5081: WHILE (l_any_rows_to_process)
5082: LOOP**/
5083:
5084: FND_FILE.PUT_LINE
5085: (
5086: FND_FILE.LOG,
5087: 'Creating/Updating Tax Rates - 1.'
5088: );

Line 5086: FND_FILE.LOG,

5082: LOOP**/
5083:
5084: FND_FILE.PUT_LINE
5085: (
5086: FND_FILE.LOG,
5087: 'Creating/Updating Tax Rates - 1.'
5088: );
5089:
5090: MERGE INTO ZX_RATES_B_TMP zrbt

Line 5284: FND_FILE.PUT_LINE

5280: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
5281: zrbt.LAST_UPDATE_DATE = sysdate,
5282: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5283:
5284: FND_FILE.PUT_LINE
5285: (
5286: FND_FILE.LOG,
5287: 'Records Processed: '||TO_CHAR(SQL%ROWCOUNT)
5288: );

Line 5286: FND_FILE.LOG,

5282: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5283:
5284: FND_FILE.PUT_LINE
5285: (
5286: FND_FILE.LOG,
5287: 'Records Processed: '||TO_CHAR(SQL%ROWCOUNT)
5288: );
5289:
5290: l_rows_processed := SQL%ROWCOUNT;

Line 5296: FND_FILE.PUT_LINE

5292: -- added this to ensure that when we have two rate records with same effectivity, then
5293: -- active_flag is not updated as it needs to be included in the ON clause
5294: -- also need to update percentage_rate for this case.
5295:
5296: FND_FILE.PUT_LINE
5297: (
5298: FND_FILE.LOG,
5299: 'Creating/Updating Tax Rates - 2.'
5300: );

Line 5298: FND_FILE.LOG,

5294: -- also need to update percentage_rate for this case.
5295:
5296: FND_FILE.PUT_LINE
5297: (
5298: FND_FILE.LOG,
5299: 'Creating/Updating Tax Rates - 2.'
5300: );
5301:
5302: MERGE INTO ZX_RATES_B_TMP zrbt

Line 5497: FND_FILE.PUT_LINE

5493: zrbt.LAST_UPDATED_BY = fnd_global.user_id,
5494: zrbt.LAST_UPDATE_DATE = sysdate,
5495: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5496:
5497: FND_FILE.PUT_LINE
5498: (
5499: FND_FILE.LOG,
5500: 'Records Processed: '||TO_CHAR(SQL%ROWCOUNT)
5501: );

Line 5499: FND_FILE.LOG,

5495: zrbt.LAST_UPDATE_LOGIN = fnd_global.conc_login_id;
5496:
5497: FND_FILE.PUT_LINE
5498: (
5499: FND_FILE.LOG,
5500: 'Records Processed: '||TO_CHAR(SQL%ROWCOUNT)
5501: );
5502:
5503: l_rows_processed := SQL%ROWCOUNT;

Line 5508: FND_FILE.PUT_LINE

5504:
5505: -- Create rates with NULL Jurisdiction codes
5506: -- Used for Partner tax calculation.
5507:
5508: FND_FILE.PUT_LINE
5509: (
5510: FND_FILE.LOG,
5511: 'Creating Tax Rates with NULL Tax Jurisdiction.'
5512: );

Line 5510: FND_FILE.LOG,

5506: -- Used for Partner tax calculation.
5507:
5508: FND_FILE.PUT_LINE
5509: (
5510: FND_FILE.LOG,
5511: 'Creating Tax Rates with NULL Tax Jurisdiction.'
5512: );
5513:
5514: INSERT ALL INTO ZX_RATES_B_TMP

Line 5582: FND_FILE.PUT_LINE

5578: AND rate.TAX_JURISDICTION_CODE IS NULL
5579: AND rate.EFFECTIVE_FROM = tax.EFFECTIVE_FROM
5580: AND rate.ACTIVE_FLAG = 'Y');
5581:
5582: FND_FILE.PUT_LINE
5583: (
5584: FND_FILE.LOG,
5585: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
5586: );

Line 5584: FND_FILE.LOG,

5580: AND rate.ACTIVE_FLAG = 'Y');
5581:
5582: FND_FILE.PUT_LINE
5583: (
5584: FND_FILE.LOG,
5585: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
5586: );
5587:
5588: -- Copy accounts from jurisdiction

Line 5591: FND_FILE.PUT_LINE

5587:
5588: -- Copy accounts from jurisdiction
5589: -- Do this only for newly created rates
5590: -- Use TL table and regime/tax/record type combination to find new ones
5591: FND_FILE.PUT_LINE
5592: (
5593: FND_FILE.LOG,
5594: 'Creating Tax Accounts for Tax Rates.'
5595: );

Line 5593: FND_FILE.LOG,

5589: -- Do this only for newly created rates
5590: -- Use TL table and regime/tax/record type combination to find new ones
5591: FND_FILE.PUT_LINE
5592: (
5593: FND_FILE.LOG,
5594: 'Creating Tax Accounts for Tax Rates.'
5595: );
5596:
5597: INSERT INTO ZX_ACCOUNTS

Line 5663: FND_FILE.PUT_LINE

5659: AND zjb.TAX_JURISDICTION_CODE = zrb.TAX_JURISDICTION_CODE
5660: AND za.TAX_ACCOUNT_ENTITY_CODE = 'JURISDICTION'
5661: AND za.TAX_ACCOUNT_ENTITY_ID = zjb.TAX_JURISDICTION_ID;
5662:
5663: FND_FILE.PUT_LINE
5664: (
5665: FND_FILE.LOG,
5666: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
5667: );

Line 5665: FND_FILE.LOG,

5661: AND za.TAX_ACCOUNT_ENTITY_ID = zjb.TAX_JURISDICTION_ID;
5662:
5663: FND_FILE.PUT_LINE
5664: (
5665: FND_FILE.LOG,
5666: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
5667: );
5668:
5669: FND_FILE.PUT_LINE

Line 5669: FND_FILE.PUT_LINE

5665: FND_FILE.LOG,
5666: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
5667: );
5668:
5669: FND_FILE.PUT_LINE
5670: (
5671: FND_FILE.LOG,
5672: 'Creating TL for Tax Rates.'
5673: );

Line 5671: FND_FILE.LOG,

5667: );
5668:
5669: FND_FILE.PUT_LINE
5670: (
5671: FND_FILE.LOG,
5672: 'Creating TL for Tax Rates.'
5673: );
5674:
5675: INSERT INTO ZX_RATES_TL

Line 5707: FND_FILE.PUT_LINE

5703: FROM ZX_RATES_TL zrt
5704: WHERE zrt.TAX_RATE_ID = zrb.TAX_RATE_ID
5705: AND zrt.LANGUAGE = fl.LANGUAGE_CODE);
5706:
5707: FND_FILE.PUT_LINE
5708: (
5709: FND_FILE.LOG,
5710: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
5711: );

Line 5709: FND_FILE.LOG,

5705: AND zrt.LANGUAGE = fl.LANGUAGE_CODE);
5706:
5707: FND_FILE.PUT_LINE
5708: (
5709: FND_FILE.LOG,
5710: 'Records Inserted: '||TO_CHAR(SQL%ROWCOUNT)
5711: );
5712:
5713: l_rows_processed := SQL%ROWCOUNT;

Line 5752: FND_FILE.PUT_LINE

5748:
5749: WHEN NO_DATA_FOUND THEN
5750: retcode := '1';
5751: errbuf := 'No data found';
5752: FND_FILE.PUT_LINE
5753: (
5754: FND_FILE.LOG,
5755: 'Error in '||l_api_name||': '||errbuf
5756: );

Line 5754: FND_FILE.LOG,

5750: retcode := '1';
5751: errbuf := 'No data found';
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 CREATE_RATES;

Line 5940: FND_FILE.PUT_LINE

5936: l_submit_phase := 1;
5937:
5938: ELSE
5939:
5940: FND_FILE.PUT_LINE
5941: (
5942: FND_FILE.LOG,
5943: 'Starting status check of sub-request, ids obtained from global: '||l_req_data
5944: );

Line 5942: FND_FILE.LOG,

5938: ELSE
5939:
5940: FND_FILE.PUT_LINE
5941: (
5942: FND_FILE.LOG,
5943: 'Starting status check of sub-request, ids obtained from global: '||l_req_data
5944: );
5945: -- Check status of sub-requests
5946: l_current_pos := INSTR(l_req_data,'-',1);

Line 5978: FND_FILE.PUT_LINE

5974: dev_phase => l_dev_phase,
5975: dev_status => l_dev_status,
5976: message => l_message
5977: );
5978: FND_FILE.PUT_LINE
5979: (
5980: FND_FILE.LOG,
5981: 'Checking status of sub-request, id: '||l_request_id||', return dev status value:'||l_dev_status||', return status value:'||l_status
5982: );

Line 5980: FND_FILE.LOG,

5976: message => l_message
5977: );
5978: FND_FILE.PUT_LINE
5979: (
5980: FND_FILE.LOG,
5981: 'Checking status of sub-request, id: '||l_request_id||', return dev status value:'||l_dev_status||', return status value:'||l_status
5982: );
5983: IF (l_check_status AND (l_dev_status = 'ERROR'))
5984: THEN

Line 6124: FND_FILE.PUT_LINE

6120:
6121: WHEN l_error THEN
6122: ROLLBACK;
6123: retcode := '2';
6124: FND_FILE.PUT_LINE
6125: (
6126: FND_FILE.LOG,
6127: 'Error in '||l_api_name||': '||errbuf
6128: );

Line 6126: FND_FILE.LOG,

6122: ROLLBACK;
6123: retcode := '2';
6124: FND_FILE.PUT_LINE
6125: (
6126: FND_FILE.LOG,
6127: 'Error in '||l_api_name||': '||errbuf
6128: );
6129:
6130: WHEN OTHERS THEN

Line 6134: FND_FILE.PUT_LINE

6130: WHEN OTHERS THEN
6131: ROLLBACK;
6132: retcode := '2';
6133: errbuf := SQLERRM;
6134: FND_FILE.PUT_LINE
6135: (
6136: FND_FILE.LOG,
6137: 'Unexpected Error in '||l_api_name||': '||errbuf
6138: );

Line 6136: FND_FILE.LOG,

6132: retcode := '2';
6133: errbuf := SQLERRM;
6134: FND_FILE.PUT_LINE
6135: (
6136: FND_FILE.LOG,
6137: 'Unexpected Error in '||l_api_name||': '||errbuf
6138: );
6139:
6140: END PROCESS_DATA;

Line 6278: FND_FILE.PUT_LINE

6274:
6275: WHEN l_error THEN
6276: ROLLBACK;
6277: retcode := '2';
6278: FND_FILE.PUT_LINE
6279: (
6280: FND_FILE.LOG,
6281: 'Error in '||l_api_name||': '||errbuf
6282: );

Line 6280: FND_FILE.LOG,

6276: ROLLBACK;
6277: retcode := '2';
6278: FND_FILE.PUT_LINE
6279: (
6280: FND_FILE.LOG,
6281: 'Error in '||l_api_name||': '||errbuf
6282: );
6283:
6284: WHEN OTHERS THEN

Line 6288: FND_FILE.PUT_LINE

6284: WHEN OTHERS THEN
6285: ROLLBACK;
6286: retcode := '2';
6287: errbuf := SQLERRM;
6288: FND_FILE.PUT_LINE
6289: (
6290: FND_FILE.LOG,
6291: 'Unexpected Error in '||l_api_name||': '||errbuf
6292: );

Line 6290: FND_FILE.LOG,

6286: retcode := '2';
6287: errbuf := SQLERRM;
6288: FND_FILE.PUT_LINE
6289: (
6290: FND_FILE.LOG,
6291: 'Unexpected Error in '||l_api_name||': '||errbuf
6292: );
6293:
6294: END POST_PROCESS_DATA;

Line 6329: FND_FILE.PUT_LINE

6325: IF (l_req_data IS NULL)
6326: THEN
6327:
6328: l_req_data := 'LOAD-FILE';
6329: FND_FILE.PUT_LINE
6330: (
6331: FND_FILE.LOG,
6332: 'Validating input parameters.'
6333: );

Line 6331: FND_FILE.LOG,

6327:
6328: l_req_data := 'LOAD-FILE';
6329: FND_FILE.PUT_LINE
6330: (
6331: FND_FILE.LOG,
6332: 'Validating input parameters.'
6333: );
6334:
6335: IF (p_file_location_name IS NULL)

Line 6353: FND_FILE.PUT_LINE

6349: errbuf := 'Please select a valid Tax Regime to load the data into.';
6350: RAISE l_error;
6351: END IF;
6352:
6353: FND_FILE.PUT_LINE
6354: (
6355: FND_FILE.LOG,
6356: 'Calling Sql*Loader to load data.'
6357: );

Line 6355: FND_FILE.LOG,

6351: END IF;
6352:
6353: FND_FILE.PUT_LINE
6354: (
6355: FND_FILE.LOG,
6356: 'Calling Sql*Loader to load data.'
6357: );
6358: l_request_id := fnd_request.submit_request
6359: (

Line 6392: FND_FILE.PUT_LINE

6388: errbuf := 'No data uploaded, check data file location and name.';
6389: RAISE l_error;
6390: END IF;
6391:
6392: FND_FILE.PUT_LINE
6393: (
6394: FND_FILE.LOG,
6395: 'Data uploaded into interface table. No. of records: '||l_data_count
6396: );

Line 6394: FND_FILE.LOG,

6390: END IF;
6391:
6392: FND_FILE.PUT_LINE
6393: (
6394: FND_FILE.LOG,
6395: 'Data uploaded into interface table. No. of records: '||l_data_count
6396: );
6397:
6398: END IF;

Line 6404: FND_FILE.PUT_LINE

6400: EXCEPTION
6401:
6402: WHEN l_error THEN
6403: retcode := '2';
6404: FND_FILE.PUT_LINE
6405: (
6406: FND_FILE.LOG,
6407: 'Error in '||l_api_name||': '||errbuf
6408: );

Line 6406: FND_FILE.LOG,

6402: WHEN l_error THEN
6403: retcode := '2';
6404: FND_FILE.PUT_LINE
6405: (
6406: FND_FILE.LOG,
6407: 'Error in '||l_api_name||': '||errbuf
6408: );
6409:
6410: WHEN OTHERS THEN

Line 6413: FND_FILE.PUT_LINE

6409:
6410: WHEN OTHERS THEN
6411: retcode := '2';
6412: errbuf := SQLERRM;
6413: FND_FILE.PUT_LINE
6414: (
6415: FND_FILE.LOG,
6416: 'Unexpected Error in '||l_api_name||': '||errbuf
6417: );

Line 6415: FND_FILE.LOG,

6411: retcode := '2';
6412: errbuf := SQLERRM;
6413: FND_FILE.PUT_LINE
6414: (
6415: FND_FILE.LOG,
6416: 'Unexpected Error in '||l_api_name||': '||errbuf
6417: );
6418:
6419: END LOAD_FILE;