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

Line 61: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));

57: RETURN (bal_segment_value);
58:
59: EXCEPTION
60: WHEN NO_DATA_FOUND THEN
61: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));
62: RETURN NULL;
63: WHEN OTHERS THEN
64: fnd_file.put_line(fnd_file.log,' Error in GET_BSV function : ' || SUBSTR(SQLERRM,1,200));
65: RETURN NULL;

Line 64: fnd_file.put_line(fnd_file.log,' Error in GET_BSV function : ' || SUBSTR(SQLERRM,1,200));

60: WHEN NO_DATA_FOUND THEN
61: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));
62: RETURN NULL;
63: WHEN OTHERS THEN
64: fnd_file.put_line(fnd_file.log,' Error in GET_BSV function : ' || SUBSTR(SQLERRM,1,200));
65: RETURN NULL;
66: END get_bsv;
67:
68: -----------------------------------------

Line 139: fnd_file.put_line(fnd_file.log,'p_reporting_level: '

135: l_update_query_ap VARCHAR2(5000);
136: l_update_query_ar VARCHAR2(5000);
137: BEGIN
138:
139: fnd_file.put_line(fnd_file.log,'p_reporting_level: '
140: ||p_reporting_level);
141: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id: '
142: ||p_vat_reporting_entity_id);
143: fnd_file.put_line(fnd_file.log,'p_bsv: '

Line 141: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id: '

137: BEGIN
138:
139: fnd_file.put_line(fnd_file.log,'p_reporting_level: '
140: ||p_reporting_level);
141: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id: '
142: ||p_vat_reporting_entity_id);
143: fnd_file.put_line(fnd_file.log,'p_bsv: '
144: ||p_bsv);
145: fnd_file.put_line(fnd_file.log,'p_period: '

Line 143: fnd_file.put_line(fnd_file.log,'p_bsv: '

139: fnd_file.put_line(fnd_file.log,'p_reporting_level: '
140: ||p_reporting_level);
141: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id: '
142: ||p_vat_reporting_entity_id);
143: fnd_file.put_line(fnd_file.log,'p_bsv: '
144: ||p_bsv);
145: fnd_file.put_line(fnd_file.log,'p_period: '
146: ||p_period);
147:

Line 145: fnd_file.put_line(fnd_file.log,'p_period: '

141: fnd_file.put_line(fnd_file.log,'p_vat_reporting_entity_id: '
142: ||p_vat_reporting_entity_id);
143: fnd_file.put_line(fnd_file.log,'p_bsv: '
144: ||p_bsv);
145: fnd_file.put_line(fnd_file.log,'p_period: '
146: ||p_period);
147:
148: SELECT LEGAL.driving_date_code
149: ,ACCT.mapping_vat_rep_entity_id

Line 226: fnd_file.put_line(fnd_file.log,'Ledger ID: '

222:
223: END IF;
224:
225:
226: fnd_file.put_line(fnd_file.log,'Ledger ID: '
227: ||l_ledger_id);
228: fnd_file.put_line(fnd_file.log,'BSV VAT Reporting Entity ID: '
229: ||l_bsv_vat_rep_entity_id);
230: fnd_file.put_line(fnd_file.log,'Driving Date Code: '

Line 228: fnd_file.put_line(fnd_file.log,'BSV VAT Reporting Entity ID: '

224:
225:
226: fnd_file.put_line(fnd_file.log,'Ledger ID: '
227: ||l_ledger_id);
228: fnd_file.put_line(fnd_file.log,'BSV VAT Reporting Entity ID: '
229: ||l_bsv_vat_rep_entity_id);
230: fnd_file.put_line(fnd_file.log,'Driving Date Code: '
231: ||l_driving_date_code);
232: fnd_file.put_line(fnd_file.log,'Lega VAT Reporting Entity ID: '

Line 230: fnd_file.put_line(fnd_file.log,'Driving Date Code: '

226: fnd_file.put_line(fnd_file.log,'Ledger ID: '
227: ||l_ledger_id);
228: fnd_file.put_line(fnd_file.log,'BSV VAT Reporting Entity ID: '
229: ||l_bsv_vat_rep_entity_id);
230: fnd_file.put_line(fnd_file.log,'Driving Date Code: '
231: ||l_driving_date_code);
232: fnd_file.put_line(fnd_file.log,'Lega VAT Reporting Entity ID: '
233: ||l_mapping_rep_entity_id);
234:

Line 232: fnd_file.put_line(fnd_file.log,'Lega VAT Reporting Entity ID: '

228: fnd_file.put_line(fnd_file.log,'BSV VAT Reporting Entity ID: '
229: ||l_bsv_vat_rep_entity_id);
230: fnd_file.put_line(fnd_file.log,'Driving Date Code: '
231: ||l_driving_date_code);
232: fnd_file.put_line(fnd_file.log,'Lega VAT Reporting Entity ID: '
233: ||l_mapping_rep_entity_id);
234:
235: SELECT start_date ,
236: end_date

Line 436: fnd_file.put_line(fnd_file.log,'l_update_query_ap :='||l_update_query_ap);

432: l_update_query_ar := REPLACE( l_update_query_ar,'$l_legal_entity_id$',l_legal_entity_id);
433: l_update_query_ar := REPLACE( l_update_query_ar,'$p_chart_of_account_id$',p_chart_of_account_id);
434: l_update_query_ar := REPLACE( l_update_query_ar,'$p_bsv$',p_bsv);
435:
436: fnd_file.put_line(fnd_file.log,'l_update_query_ap :='||l_update_query_ap);
437: fnd_file.put_line(fnd_file.log,'l_update_query_ar :='||l_update_query_ar);
438:
439: EXECUTE IMMEDIATE l_update_query_ap;
440:

Line 437: fnd_file.put_line(fnd_file.log,'l_update_query_ar :='||l_update_query_ar);

433: l_update_query_ar := REPLACE( l_update_query_ar,'$p_chart_of_account_id$',p_chart_of_account_id);
434: l_update_query_ar := REPLACE( l_update_query_ar,'$p_bsv$',p_bsv);
435:
436: fnd_file.put_line(fnd_file.log,'l_update_query_ap :='||l_update_query_ap);
437: fnd_file.put_line(fnd_file.log,'l_update_query_ar :='||l_update_query_ar);
438:
439: EXECUTE IMMEDIATE l_update_query_ap;
440:
441: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);

Line 441: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);

437: fnd_file.put_line(fnd_file.log,'l_update_query_ar :='||l_update_query_ar);
438:
439: EXECUTE IMMEDIATE l_update_query_ap;
440:
441: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);
442: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Rows updated: '||To_char(SQL%RowCount));
443:
444: EXECUTE IMMEDIATE l_update_query_ar;
445: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);

Line 442: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Rows updated: '||To_char(SQL%RowCount));

438:
439: EXECUTE IMMEDIATE l_update_query_ap;
440:
441: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);
442: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Rows updated: '||To_char(SQL%RowCount));
443:
444: EXECUTE IMMEDIATE l_update_query_ar;
445: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);
446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AR Rows updated: '||To_char(SQL%RowCount));

Line 445: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);

441: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);
442: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Rows updated: '||To_char(SQL%RowCount));
443:
444: EXECUTE IMMEDIATE l_update_query_ar;
445: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);
446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AR Rows updated: '||To_char(SQL%RowCount));
447:
448: IF l_driving_date_code_es = 'GL-TRX' THEN
449: l_driving_date_code := 'TRX';

Line 446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AR Rows updated: '||To_char(SQL%RowCount));

442: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AP Rows updated: '||To_char(SQL%RowCount));
443:
444: EXECUTE IMMEDIATE l_update_query_ar;
445: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Driving Date Code :'||l_driving_date_code);
446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AR Rows updated: '||To_char(SQL%RowCount));
447:
448: IF l_driving_date_code_es = 'GL-TRX' THEN
449: l_driving_date_code := 'TRX';
450: l_driving_date_code_es := NULL;

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

466:
467: EXCEPTION
468: WHEN OTHERS THEN
469: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
470: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
471: FND_MSG_PUB.Add;
472: IF (g_level_unexpected >= g_current_runtime_level ) THEN
473: FND_LOG.STRING(g_level_unexpected, G_MODULE_NAME, g_error_buffer);
474: END IF;