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

Line 458: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

454: G_PKG_NAME||': '||l_api_name||'()+');
455: END IF;
456:
457: IF p_debug_flag = 'Y' THEN
458: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
459: END IF;
460:
461: -- Initialize the parameters:
462: initialize(

Line 531: fnd_file.put_line(fnd_file.log, 'l_last_rep_period_start_date :'||l_last_rep_period_start_date);

527: ,l_last_reported_period;
528: CLOSE last_reported_date_from_11i;
529:
530: IF p_debug_flag = 'Y' THEN
531: fnd_file.put_line(fnd_file.log, 'l_last_rep_period_start_date :'||l_last_rep_period_start_date);
532: fnd_file.put_line(fnd_file.log, 'l_last_rep_period_end_date :'||l_last_rep_period_end_date);
533: fnd_file.put_line(fnd_file.log, 'l_last_reported_period :'||l_last_reported_period);
534: END IF;
535:

Line 532: fnd_file.put_line(fnd_file.log, 'l_last_rep_period_end_date :'||l_last_rep_period_end_date);

528: CLOSE last_reported_date_from_11i;
529:
530: IF p_debug_flag = 'Y' THEN
531: fnd_file.put_line(fnd_file.log, 'l_last_rep_period_start_date :'||l_last_rep_period_start_date);
532: fnd_file.put_line(fnd_file.log, 'l_last_rep_period_end_date :'||l_last_rep_period_end_date);
533: fnd_file.put_line(fnd_file.log, 'l_last_reported_period :'||l_last_reported_period);
534: END IF;
535:
536: l_global_variables_rec.LAST_REPORTED_PERIOD_FROM_11i := l_last_reported_period;

Line 533: fnd_file.put_line(fnd_file.log, 'l_last_reported_period :'||l_last_reported_period);

529:
530: IF p_debug_flag = 'Y' THEN
531: fnd_file.put_line(fnd_file.log, 'l_last_rep_period_start_date :'||l_last_rep_period_start_date);
532: fnd_file.put_line(fnd_file.log, 'l_last_rep_period_end_date :'||l_last_rep_period_end_date);
533: fnd_file.put_line(fnd_file.log, 'l_last_reported_period :'||l_last_reported_period);
534: END IF;
535:
536: l_global_variables_rec.LAST_REPORTED_PERIOD_FROM_11i := l_last_reported_period;
537: l_global_variables_rec.LAST_REP_PERIOD_START_DATE := l_last_rep_period_start_date;

Line 710: fnd_file.put_line(fnd_file.log,

706: l_ledger := NULL;
707: END IF;
708:
709: IF g_debug_flag = 'Y' THEN
710: fnd_file.put_line(fnd_file.log,
711: 'Following parameters are passed to Tax_Date_Maintenance_Program...' );
712: fnd_file.put_line(fnd_file.log,
713: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
714: fnd_file.put_line(fnd_file.log,

Line 712: fnd_file.put_line(fnd_file.log,

708:
709: IF g_debug_flag = 'Y' THEN
710: fnd_file.put_line(fnd_file.log,
711: 'Following parameters are passed to Tax_Date_Maintenance_Program...' );
712: fnd_file.put_line(fnd_file.log,
713: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
714: fnd_file.put_line(fnd_file.log,
715: 'P_LEDGER = '|| l_ledger);
716: fnd_file.put_line(fnd_file.log,

Line 714: fnd_file.put_line(fnd_file.log,

710: fnd_file.put_line(fnd_file.log,
711: 'Following parameters are passed to Tax_Date_Maintenance_Program...' );
712: fnd_file.put_line(fnd_file.log,
713: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
714: fnd_file.put_line(fnd_file.log,
715: 'P_LEDGER = '|| l_ledger);
716: fnd_file.put_line(fnd_file.log,
717: ' P_END_DATE = '|| l_global_variables_rec.tax_invoice_date_high );
718: fnd_file.put_line(fnd_file.log,

Line 716: fnd_file.put_line(fnd_file.log,

712: fnd_file.put_line(fnd_file.log,
713: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
714: fnd_file.put_line(fnd_file.log,
715: 'P_LEDGER = '|| l_ledger);
716: fnd_file.put_line(fnd_file.log,
717: ' P_END_DATE = '|| l_global_variables_rec.tax_invoice_date_high );
718: fnd_file.put_line(fnd_file.log,
719: ' P_SOURCE = ' || l_global_variables_rec.source );
720: fnd_file.put_line(fnd_file.log,

Line 718: fnd_file.put_line(fnd_file.log,

714: fnd_file.put_line(fnd_file.log,
715: 'P_LEDGER = '|| l_ledger);
716: fnd_file.put_line(fnd_file.log,
717: ' P_END_DATE = '|| l_global_variables_rec.tax_invoice_date_high );
718: fnd_file.put_line(fnd_file.log,
719: ' P_SOURCE = ' || l_global_variables_rec.source );
720: fnd_file.put_line(fnd_file.log,
721: ' P_DEBUG_FLAG = '|| p_debug_flag );
722: END IF;

Line 720: fnd_file.put_line(fnd_file.log,

716: fnd_file.put_line(fnd_file.log,
717: ' P_END_DATE = '|| l_global_variables_rec.tax_invoice_date_high );
718: fnd_file.put_line(fnd_file.log,
719: ' P_SOURCE = ' || l_global_variables_rec.source );
720: fnd_file.put_line(fnd_file.log,
721: ' P_DEBUG_FLAG = '|| p_debug_flag );
722: END IF;
723:
724: tax_date_maintenance_program (

Line 837: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

833: G_PKG_NAME||': ' ||l_api_name||'()-');
834: END IF;
835:
836: IF p_debug_flag = 'Y' THEN
837: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
838: END IF;
839:
840: EXCEPTION
841: WHEN OTHERS THEN

Line 845: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

841: WHEN OTHERS THEN
842: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
843:
844: IF p_debug_flag = 'Y' THEN
845: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
846: END IF;
847:
848: FND_MSG_PUB.Add;
849: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 889: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

885: G_PKG_NAME||': '||l_api_name||'()+');
886: END IF;
887:
888: IF g_debug_flag = 'Y' THEN
889: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
890: END IF;
891:
892: /*Set the return status to Success */
893: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 909: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

905: G_PKG_NAME||': ' ||l_api_name||'()-');
906: END IF;
907:
908: IF g_debug_flag = 'Y' THEN
909: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
910: END IF;
911:
912: EXCEPTION
913: WHEN OTHERS THEN

Line 918: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
915: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
916:
917: IF g_debug_flag = 'Y' THEN
918: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
919: END IF;
920:
921: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
922: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 1031: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

1027: 'P_RETCODE = '||P_RETCODE);
1028: END IF;
1029:
1030: IF p_debug_flag = 'Y' THEN
1031: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1032: END IF;
1033:
1034: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'start ..');
1035: P_GLOBAL_VARIABLES_REC.REPORTING_ENTITY_LEVEL := P_REPORTING_LEVEL;

Line 1034: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'start ..');

1030: IF p_debug_flag = 'Y' THEN
1031: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1032: END IF;
1033:
1034: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'start ..');
1035: P_GLOBAL_VARIABLES_REC.REPORTING_ENTITY_LEVEL := P_REPORTING_LEVEL;
1036: P_GLOBAL_VARIABLES_REC.LEDGER := P_LEDGER;
1037: P_GLOBAL_VARIABLES_REC.BSV := P_BSV;
1038: P_GLOBAL_VARIABLES_REC.VAT_REPORTING_ENTITY_ID := P_VAT_REPORTING_ENTITY_ID;

Line 1068: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

1064: G_PKG_NAME||': ' ||l_api_name||'()-');
1065: END IF;
1066:
1067: IF p_debug_flag = 'Y' THEN
1068: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
1069: END IF;
1070:
1071: EXCEPTION
1072: WHEN OTHERS THEN

Line 1079: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

1075: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name, g_error_buffer);
1076: END IF;
1077:
1078: IF p_debug_flag = 'Y' THEN
1079: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1080: END IF;
1081: P_GLOBAL_VARIABLES_REC.RETCODE := 2;
1082:
1083: END initialize;

Line 1124: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

1120: /*Set the return status to Success */
1121: x_return_status := FND_API.G_RET_STS_SUCCESS;
1122:
1123: IF g_debug_flag = 'Y' THEN
1124: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1125: END IF;
1126:
1127:
1128: SELECT start_date,

Line 1153: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

1149: G_PKG_NAME||': ' ||l_api_name||'()-');
1150: END IF;
1151:
1152: IF g_debug_flag = 'Y' THEN
1153: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
1154: END IF;
1155:
1156: EXCEPTION
1157: WHEN OTHERS THEN

Line 1163: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

1159:
1160: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1161:
1162: IF g_debug_flag = 'Y' THEN
1163: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1164: END IF;
1165:
1166: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 1214: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

1210: /*Set the return status to Success */
1211: x_return_status := FND_API.G_RET_STS_SUCCESS;
1212:
1213: IF g_debug_flag = 'Y' THEN
1214: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1215: END IF;
1216:
1217: SELECT legal_entity_id,
1218: tax_regime_code,

Line 1253: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

1249: G_PKG_NAME||': ' ||l_api_name||'()-');
1250: END IF;
1251:
1252: IF g_debug_flag = 'Y' THEN
1253: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
1254: END IF;
1255:
1256: EXCEPTION
1257: WHEN OTHERS THEN

Line 1263: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

1259:
1260: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1261:
1262: IF g_debug_flag = 'Y' THEN
1263: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1264: END IF;
1265:
1266: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1267: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 1304: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

1300: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1301: END IF;
1302:
1303: IF g_debug_flag = 'Y' THEN
1304: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.last_rep_period_start_date :'||p_global_variables_rec.last_rep_period_start_date);
1306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.tax_invoice_date_low :'||p_global_variables_rec.tax_invoice_date_low);
1307: END IF;
1308:

Line 1305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.last_rep_period_start_date :'||p_global_variables_rec.last_rep_period_start_date);

1301: END IF;
1302:
1303: IF g_debug_flag = 'Y' THEN
1304: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.last_rep_period_start_date :'||p_global_variables_rec.last_rep_period_start_date);
1306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.tax_invoice_date_low :'||p_global_variables_rec.tax_invoice_date_low);
1307: END IF;
1308:
1309: -- BEGIN Code to check if the period is prior to the last reported period in 11i. --9381398

Line 1306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.tax_invoice_date_low :'||p_global_variables_rec.tax_invoice_date_low);

1302:
1303: IF g_debug_flag = 'Y' THEN
1304: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1305: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.last_rep_period_start_date :'||p_global_variables_rec.last_rep_period_start_date);
1306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.tax_invoice_date_low :'||p_global_variables_rec.tax_invoice_date_low);
1307: END IF;
1308:
1309: -- BEGIN Code to check if the period is prior to the last reported period in 11i. --9381398
1310:

Line 1362: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

1358: 'Last Processed Date : ' || to_char(l_last_processed_date));
1359: END IF;
1360:
1361: IF g_debug_flag = 'Y' THEN
1362: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
1363: END IF;
1364:
1365: EXCEPTION
1366: WHEN OTHERS THEN

Line 1370: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

1366: WHEN OTHERS THEN
1367: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1368:
1369: IF g_debug_flag = 'Y' THEN
1370: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1371: END IF;
1372:
1373: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1374: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 1412: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

1408:
1409: END IF;
1410:
1411: IF g_debug_flag = 'Y' THEN
1412: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1413: END IF;
1414:
1415: gt_vat_transaction_id.delete;
1416: gt_reporting_status_id.delete;

Line 1655: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

1651: G_PKG_NAME||': ' ||l_api_name||'()-');
1652: END IF;
1653:
1654: IF g_debug_flag = 'Y' THEN
1655: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
1656: END IF;
1657:
1658: EXCEPTION
1659: WHEN OTHERS THEN

Line 1666: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

1662: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1663: END IF;
1664:
1665: IF g_debug_flag = 'Y' THEN
1666: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1667: END IF;
1668: -- l_GLOBAL_VARIABLES_REC.RETCODE := 2;
1669:
1670: END init_gt_variables;

Line 1721: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

1717: G_PKG_NAME||': '||l_api_name||'()+');
1718: END IF;
1719:
1720: IF g_debug_flag = 'Y' THEN
1721: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1722: END IF;
1723:
1724: OPEN trl_tax_data_csr FOR 'SELECT
1725: CON.REP_ENTITY_ID ,

Line 2213: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

2209:
2210: END LOOP;
2211: CLOSE trl_tax_data_csr;
2212: IF g_debug_flag = 'Y' THEN
2213: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
2214: END IF;
2215:
2216: EXCEPTION
2217: WHEN OTHERS THEN

Line 2221: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

2217: WHEN OTHERS THEN
2218: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2219:
2220: IF g_debug_flag = 'Y' THEN
2221: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2222: END IF;
2223:
2224: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2225: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 2267: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

2263: G_PKG_NAME||': '||l_api_name||'(+)');
2264: END IF;
2265:
2266: IF g_debug_flag = 'Y' THEN
2267: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
2268: END IF;
2269:
2270: l_count := GT_TRX_ID.COUNT;
2271:

Line 2769: FND_FILE.PUT_LINE(FND_FILE.LOG,'Record successfully inserted = ' ||to_char(l_count));

2765: ' Record successfully inserted = ' ||to_char(l_count));
2766: END IF;
2767:
2768: IF g_debug_flag = 'Y' THEN
2769: FND_FILE.PUT_LINE(FND_FILE.LOG,'Record successfully inserted = ' ||to_char(l_count));
2770: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
2771: END IF;
2772:
2773: EXCEPTION

Line 2770: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

2766: END IF;
2767:
2768: IF g_debug_flag = 'Y' THEN
2769: FND_FILE.PUT_LINE(FND_FILE.LOG,'Record successfully inserted = ' ||to_char(l_count));
2770: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
2771: END IF;
2772:
2773: EXCEPTION
2774: WHEN OTHERS THEN

Line 2779: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

2775: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2776: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2777:
2778: IF g_debug_flag = 'Y' THEN
2779: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2780: END IF;
2781:
2782: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2783: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 2891: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

2887: G_PKG_NAME||': '||l_api_name||'()+');
2888: END IF;
2889:
2890: IF g_debug_flag = 'Y' THEN
2891: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
2892: END IF;
2893:
2894: -- Check the Reporting Entity Level.
2895: IF p_global_variables_rec.REPORTING_ENTITY_LEVEL = 'LEDGER' or

Line 2908: FND_FILE.put_line(FND_FILE.log,'Last_Reported_Start_Date '|| l_last_start_date);

2904: OPEN last_report_date(p_global_variables_rec.vat_reporting_entity_id);
2905: FETCH last_report_date INTO l_last_start_date,l_last_end_date;
2906: CLOSE last_report_date;
2907:
2908: FND_FILE.put_line(FND_FILE.log,'Last_Reported_Start_Date '|| l_last_start_date);
2909: IF p_global_variables_rec.TAX_INVOICE_DATE_HIGH <= l_last_end_date THEN
2910: l_reported_status := NULL;
2911: END IF;
2912: --Bug6835573

Line 3010: fnd_file.put_line(fnd_file.log,

3006: END IF;
3007:
3008: IF g_debug_flag = 'Y' THEN
3009:
3010: fnd_file.put_line(fnd_file.log,
3011: 'Following parameters are passed to TRL...' );
3012: fnd_file.put_line(fnd_file.log,
3013: 'P_REPORTING_LEVEL = ' || l_reporting_level );
3014: fnd_file.put_line(fnd_file.log,

Line 3012: fnd_file.put_line(fnd_file.log,

3008: IF g_debug_flag = 'Y' THEN
3009:
3010: fnd_file.put_line(fnd_file.log,
3011: 'Following parameters are passed to TRL...' );
3012: fnd_file.put_line(fnd_file.log,
3013: 'P_REPORTING_LEVEL = ' || l_reporting_level );
3014: fnd_file.put_line(fnd_file.log,
3015: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
3016: fnd_file.put_line(fnd_file.log,

Line 3014: fnd_file.put_line(fnd_file.log,

3010: fnd_file.put_line(fnd_file.log,
3011: 'Following parameters are passed to TRL...' );
3012: fnd_file.put_line(fnd_file.log,
3013: 'P_REPORTING_LEVEL = ' || l_reporting_level );
3014: fnd_file.put_line(fnd_file.log,
3015: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
3016: fnd_file.put_line(fnd_file.log,
3017: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
3018: fnd_file.put_line(fnd_file.log,

Line 3016: fnd_file.put_line(fnd_file.log,

3012: fnd_file.put_line(fnd_file.log,
3013: 'P_REPORTING_LEVEL = ' || l_reporting_level );
3014: fnd_file.put_line(fnd_file.log,
3015: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
3016: fnd_file.put_line(fnd_file.log,
3017: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
3018: fnd_file.put_line(fnd_file.log,
3019: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
3020: fnd_file.put_line(fnd_file.log,

Line 3018: fnd_file.put_line(fnd_file.log,

3014: fnd_file.put_line(fnd_file.log,
3015: 'P_REPORTING_CONTEXT = ' || l_reporting_context );
3016: fnd_file.put_line(fnd_file.log,
3017: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
3018: fnd_file.put_line(fnd_file.log,
3019: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
3020: fnd_file.put_line(fnd_file.log,
3021: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
3022: fnd_file.put_line(fnd_file.log,

Line 3020: fnd_file.put_line(fnd_file.log,

3016: fnd_file.put_line(fnd_file.log,
3017: 'P_LEGAL_ENTITY_ID = '|| l_legal_entity_id);
3018: fnd_file.put_line(fnd_file.log,
3019: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
3020: fnd_file.put_line(fnd_file.log,
3021: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
3022: fnd_file.put_line(fnd_file.log,
3023: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
3024: fnd_file.put_line(fnd_file.log,

Line 3022: fnd_file.put_line(fnd_file.log,

3018: fnd_file.put_line(fnd_file.log,
3019: ' P_PRODUCT = ' || p_global_variables_rec.SOURCE );
3020: fnd_file.put_line(fnd_file.log,
3021: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
3022: fnd_file.put_line(fnd_file.log,
3023: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
3024: fnd_file.put_line(fnd_file.log,
3025: ' P_TRX_DATE_HIGH = '|| l_trx_date_high);
3026: fnd_file.put_line(fnd_file.log,

Line 3024: fnd_file.put_line(fnd_file.log,

3020: fnd_file.put_line(fnd_file.log,
3021: ' P_FIRST_PARTY_TAX_REG_NUM = ' || l_trn );
3022: fnd_file.put_line(fnd_file.log,
3023: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
3024: fnd_file.put_line(fnd_file.log,
3025: ' P_TRX_DATE_HIGH = '|| l_trx_date_high);
3026: fnd_file.put_line(fnd_file.log,
3027: ' P_GL_DATE_LOW = '|| l_gl_date_low );
3028: fnd_file.put_line(fnd_file.log,

Line 3026: fnd_file.put_line(fnd_file.log,

3022: fnd_file.put_line(fnd_file.log,
3023: ' P_TRX_DATE_LOW = '|| l_trx_date_low );
3024: fnd_file.put_line(fnd_file.log,
3025: ' P_TRX_DATE_HIGH = '|| l_trx_date_high);
3026: fnd_file.put_line(fnd_file.log,
3027: ' P_GL_DATE_LOW = '|| l_gl_date_low );
3028: fnd_file.put_line(fnd_file.log,
3029: ' P_GL_DATE_HIGH = '|| l_gl_date_high);
3030: fnd_file.put_line(fnd_file.log,

Line 3028: fnd_file.put_line(fnd_file.log,

3024: fnd_file.put_line(fnd_file.log,
3025: ' P_TRX_DATE_HIGH = '|| l_trx_date_high);
3026: fnd_file.put_line(fnd_file.log,
3027: ' P_GL_DATE_LOW = '|| l_gl_date_low );
3028: fnd_file.put_line(fnd_file.log,
3029: ' P_GL_DATE_HIGH = '|| l_gl_date_high);
3030: fnd_file.put_line(fnd_file.log,
3031: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
3032: fnd_file.put_line(fnd_file.log,

Line 3030: fnd_file.put_line(fnd_file.log,

3026: fnd_file.put_line(fnd_file.log,
3027: ' P_GL_DATE_LOW = '|| l_gl_date_low );
3028: fnd_file.put_line(fnd_file.log,
3029: ' P_GL_DATE_HIGH = '|| l_gl_date_high);
3030: fnd_file.put_line(fnd_file.log,
3031: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
3032: fnd_file.put_line(fnd_file.log,
3033: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high);
3034: fnd_file.put_line(fnd_file.log,

Line 3032: fnd_file.put_line(fnd_file.log,

3028: fnd_file.put_line(fnd_file.log,
3029: ' P_GL_DATE_HIGH = '|| l_gl_date_high);
3030: fnd_file.put_line(fnd_file.log,
3031: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
3032: fnd_file.put_line(fnd_file.log,
3033: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high);
3034: fnd_file.put_line(fnd_file.log,
3035: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
3036: fnd_file.put_line(fnd_file.log,

Line 3034: fnd_file.put_line(fnd_file.log,

3030: fnd_file.put_line(fnd_file.log,
3031: ' P_TAX_INVOICE_DATE_LOW = '|| l_tax_invoice_date_low );
3032: fnd_file.put_line(fnd_file.log,
3033: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high);
3034: fnd_file.put_line(fnd_file.log,
3035: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
3036: fnd_file.put_line(fnd_file.log,
3037: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
3038: fnd_file.put_line(fnd_file.log,

Line 3036: fnd_file.put_line(fnd_file.log,

3032: fnd_file.put_line(fnd_file.log,
3033: ' P_TAX_INVOICE_DATE_HIGH = '|| l_tax_invoice_date_high);
3034: fnd_file.put_line(fnd_file.log,
3035: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
3036: fnd_file.put_line(fnd_file.log,
3037: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
3038: fnd_file.put_line(fnd_file.log,
3039: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
3040: fnd_file.put_line(fnd_file.log,

Line 3038: fnd_file.put_line(fnd_file.log,

3034: fnd_file.put_line(fnd_file.log,
3035: ' P_ACCOUNTING_STATUS = '|| l_accounting_status );
3036: fnd_file.put_line(fnd_file.log,
3037: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
3038: fnd_file.put_line(fnd_file.log,
3039: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
3040: fnd_file.put_line(fnd_file.log,
3041: 'P_GL_OR_TRX_DATE_FILTER = '||p_global_variables_rec.gl_or_trx_date_filter);
3042: fnd_file.put_line(fnd_file.log,

Line 3040: fnd_file.put_line(fnd_file.log,

3036: fnd_file.put_line(fnd_file.log,
3037: ' P_INCLUDE_ACCOUNTING_SEGMENTS = '|| l_include_acc_segments );
3038: fnd_file.put_line(fnd_file.log,
3039: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
3040: fnd_file.put_line(fnd_file.log,
3041: 'P_GL_OR_TRX_DATE_FILTER = '||p_global_variables_rec.gl_or_trx_date_filter);
3042: fnd_file.put_line(fnd_file.log,
3043: 'P_REPORTED_STATUS = '||l_reported_status);
3044:

Line 3042: fnd_file.put_line(fnd_file.log,

3038: fnd_file.put_line(fnd_file.log,
3039: ' P_TAX_REGIME_CODE = '|| p_global_variables_rec.TAX_REGIME_CODE);
3040: fnd_file.put_line(fnd_file.log,
3041: 'P_GL_OR_TRX_DATE_FILTER = '||p_global_variables_rec.gl_or_trx_date_filter);
3042: fnd_file.put_line(fnd_file.log,
3043: 'P_REPORTED_STATUS = '||l_reported_status);
3044:
3045: END IF;
3046:

Line 3136: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

3132: G_PKG_NAME||': ' ||l_api_name||'()-');
3133: END IF;
3134:
3135: IF g_debug_flag = 'Y' THEN
3136: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
3137: END IF;
3138:
3139: EXCEPTION
3140: WHEN OTHERS THEN

Line 3145: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

3141: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3142: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3143:
3144: IF g_debug_flag = 'Y' THEN
3145: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3146: END IF;
3147:
3148: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3149: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 3199: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

3195: G_PKG_NAME||': '||l_api_name||'()+');
3196: END IF;
3197:
3198: IF g_debug_flag = 'Y' THEN
3199: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
3200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.last_rep_period_start_date :'||p_global_variables_rec.last_rep_period_start_date);
3201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.tax_invoice_date_low :'||p_global_variables_rec.tax_invoice_date_low);
3202: END IF;
3203:

Line 3200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.last_rep_period_start_date :'||p_global_variables_rec.last_rep_period_start_date);

3196: END IF;
3197:
3198: IF g_debug_flag = 'Y' THEN
3199: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
3200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.last_rep_period_start_date :'||p_global_variables_rec.last_rep_period_start_date);
3201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.tax_invoice_date_low :'||p_global_variables_rec.tax_invoice_date_low);
3202: END IF;
3203:
3204: -- populate temp table with the intersecting data.

Line 3201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.tax_invoice_date_low :'||p_global_variables_rec.tax_invoice_date_low);

3197:
3198: IF g_debug_flag = 'Y' THEN
3199: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
3200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.last_rep_period_start_date :'||p_global_variables_rec.last_rep_period_start_date);
3201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_global_variables_rec.tax_invoice_date_low :'||p_global_variables_rec.tax_invoice_date_low);
3202: END IF;
3203:
3204: -- populate temp table with the intersecting data.
3205: IF p_global_variables_rec.tax_invoice_date_high > p_global_variables_rec.LAST_REP_PERIOD_END_DATE THEN

Line 3350: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

3346: ,G_PKG_NAME||': ' ||l_api_name||'()-');
3347: END IF;
3348:
3349: IF g_debug_flag = 'Y' THEN
3350: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
3351: END IF;
3352:
3353: EXCEPTION
3354: WHEN OTHERS THEN

Line 3359: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

3355: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3356: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3357:
3358: IF g_debug_flag = 'Y' THEN
3359: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3360: END IF;
3361:
3362: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3363: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 3488: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

3484: G_PKG_NAME||': '||l_api_name||'()+');
3485: END IF;
3486:
3487: IF g_debug_flag = 'Y' THEN
3488: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
3489: END IF;
3490:
3491: OPEN c_finalrep_exist ;
3492: FETCH c_finalrep_exist INTO l_count ;

Line 3551: FND_FILE.PUT_LINE(FND_FILE.LOG,xv_return_message);

3547: xv_return_message := FND_MESSAGE.GET;
3548: -- xv_return_status := fnd_api.g_ret_sts_error;
3549:
3550: IF g_debug_flag = 'Y' THEN
3551: FND_FILE.PUT_LINE(FND_FILE.LOG,xv_return_message);
3552: END IF;
3553:
3554: OPEN c_get_finalrep_trx_for_upd;
3555:

Line 3590: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error occurred in the

3586:
3587: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3588: xv_return_status := l_return_status;
3589: xv_return_message := l_return_message;
3590: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error occurred in the
3591: procedure zx_extract_pkg.zx_upd_legal_reporting_status :'||l_return_message);
3592: END IF;
3593:
3594: END IF; --IF l_count > 0 then

Line 3600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'None of the transactions in GTT are finally reported');

3596: /* None of the transactions in GTT are finally reported
3597: => Delete from box_allocs, box_errors, trx_details */
3598:
3599: IF g_debug_flag = 'Y' THEN
3600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'None of the transactions in GTT are finally reported');
3601: END IF;
3602:
3603:
3604: OPEN c_vat_transaction_id ;

Line 3638: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

3634: G_PKG_NAME||': ' || l_api_name||'()-');
3635: END IF;
3636:
3637: IF g_debug_flag = 'Y' THEN
3638: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
3639: END IF;
3640:
3641:
3642: EXCEPTION

Line 3654: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

3650: END IF;
3651: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3652:
3653: IF g_debug_flag = 'Y' THEN
3654: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3655: END IF;
3656:
3657: END purge_report_finalrep ;
3658:

Line 3711: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

3707: G_PKG_NAME||': ' || l_api_name||'()-');
3708: END IF;
3709:
3710: IF g_debug_flag = 'Y' THEN
3711: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
3712: END IF;
3713:
3714:
3715: EXCEPTION

Line 3723: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

3719: END IF;
3720: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3721:
3722: IF g_debug_flag = 'Y' THEN
3723: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3724: END IF;
3725: RETURN;
3726: END log_file ;
3727:

Line 3872: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');

3868: ' P_SOURCE = ' || p_source);
3869: END IF;
3870:
3871: IF g_debug_flag = 'Y' THEN
3872: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
3873: END IF;
3874:
3875: x_return_status := FND_API.G_RET_STS_SUCCESS;
3876: x_errbuf := NULL;

Line 4049: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');

4045: G_PKG_NAME||': ' ||l_api_name||'()-');
4046: END IF;
4047:
4048: IF g_debug_flag = 'Y' THEN
4049: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': ' ||l_api_name||'()-');
4050: END IF;
4051:
4052: EXCEPTION
4053: WHEN OTHERS THEN