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

Line 90: fnd_file.put_line(fnd_file.log,' Inside BeforeReport ');

86: l_start_seq NUMBER(15);
87:
88:
89: BEGIN
90: fnd_file.put_line(fnd_file.log,' ** Inside BeforeReport ** ');
91: p_debug_flag := 'Y' ;
92: g_precision :=0;
93:
94: IF P_REPORT_NAME IN ('JEITAPSR', 'JEITAPPV') THEN

Line 96: fnd_file.put_line(fnd_file.log,'Fetching Register name...');

92: g_precision :=0;
93:
94: IF P_REPORT_NAME IN ('JEITAPSR', 'JEITAPPV') THEN
95: BEGIN
96: fnd_file.put_line(fnd_file.log,'Fetching Register name...');
97: SELECT register_name
98: INTO l_vat_register_name
99: FROM jg_zz_vat_registers_vl
100: WHERE vat_register_id = p_vat_register_id ;

Line 103: fnd_file.put_line(fnd_file.log,'Cannot derive VAT Register Name for Register ID:'||p_vat_register_id) ;

99: FROM jg_zz_vat_registers_vl
100: WHERE vat_register_id = p_vat_register_id ;
101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN
103: fnd_file.put_line(fnd_file.log,'Cannot derive VAT Register Name for Register ID:'||p_vat_register_id) ;
104: l_rec_count := 0;
105: RAISE ;
106: END ;
107: END IF ;

Line 109: fnd_file.put_line(fnd_file.log,'**********************************************************');

105: RAISE ;
106: END ;
107: END IF ;
108: IF p_debug_flag = 'Y' THEN
109: fnd_file.put_line(fnd_file.log,'**********************************************************');
110: IF P_REPORT_NAME = 'JEITAPSR' THEN
111: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');
112: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
113: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');

Line 111: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');

107: END IF ;
108: IF p_debug_flag = 'Y' THEN
109: fnd_file.put_line(fnd_file.log,'**********************************************************');
110: IF P_REPORT_NAME = 'JEITAPSR' THEN
111: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');
112: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
113: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');
114: ELSIF P_REPORT_NAME = 'JEBEDV08' THEN
115: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');

Line 113: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');

109: fnd_file.put_line(fnd_file.log,'**********************************************************');
110: IF P_REPORT_NAME = 'JEITAPSR' THEN
111: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');
112: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
113: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');
114: ELSIF P_REPORT_NAME = 'JEBEDV08' THEN
115: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');
116: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
117: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');

Line 115: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');

111: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');
112: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
113: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');
114: ELSIF P_REPORT_NAME = 'JEBEDV08' THEN
115: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');
116: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
117: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');
118: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
119: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');

Line 117: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');

113: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');
114: ELSIF P_REPORT_NAME = 'JEBEDV08' THEN
115: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');
116: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
117: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');
118: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
119: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
120: END IF;
121: fnd_file.put_line(fnd_file.log,'**********************************************************');

Line 119: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');

115: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');
116: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
117: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');
118: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
119: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
120: END IF;
121: fnd_file.put_line(fnd_file.log,'**********************************************************');
122: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
123: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );

Line 121: fnd_file.put_line(fnd_file.log,'**********************************************************');

117: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');
118: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
119: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
120: END IF;
121: fnd_file.put_line(fnd_file.log,'**********************************************************');
122: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
123: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
124: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272

Line 122: fnd_file.put_line(fnd_file.log,' Report Paramters ');

118: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
119: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
120: END IF;
121: fnd_file.put_line(fnd_file.log,'**********************************************************');
122: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
123: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
124: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272
126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);

Line 123: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );

119: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
120: END IF;
121: fnd_file.put_line(fnd_file.log,'**********************************************************');
122: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
123: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
124: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272
126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );

Line 124: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );

120: END IF;
121: fnd_file.put_line(fnd_file.log,'**********************************************************');
122: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
123: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
124: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272
126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );

Line 125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272

121: fnd_file.put_line(fnd_file.log,'**********************************************************');
122: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
123: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
124: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272
126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );

Line 126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);

122: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
123: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
124: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272
126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );

Line 127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );

123: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
124: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272
126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );

Line 128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );

124: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272
126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );

Line 129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );

125: fnd_file.put_line(fnd_file.log,'P_PERIOD_TO :'|| P_PERIOD_TO ); -- Bug8267272
126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );

Line 130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );

126: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
134: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );

Line 131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );

127: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
134: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
135: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );

Line 132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );

128: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
134: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
135: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
136: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );

Line 133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );

129: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
134: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
135: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
136: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
137: fnd_file.put_line(fnd_file.log,' ');

Line 134: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );

130: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
134: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
135: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
136: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
137: fnd_file.put_line(fnd_file.log,' ');
138: END IF ;

Line 135: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );

131: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
134: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
135: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
136: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
137: fnd_file.put_line(fnd_file.log,' ');
138: END IF ;
139:

Line 136: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );

132: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
134: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
135: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
136: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
137: fnd_file.put_line(fnd_file.log,' ');
138: END IF ;
139:
140: fnd_file.put_line(fnd_file.log,'Before Report Trigger');

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

133: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
134: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
135: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
136: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
137: fnd_file.put_line(fnd_file.log,' ');
138: END IF ;
139:
140: fnd_file.put_line(fnd_file.log,'Before Report Trigger');
141: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr

Line 140: fnd_file.put_line(fnd_file.log,'Before Report Trigger');

136: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
137: fnd_file.put_line(fnd_file.log,' ');
138: END IF ;
139:
140: fnd_file.put_line(fnd_file.log,'Before Report Trigger');
141: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
142: ,x_rep_entity_name => l_legal_entity_name
143: ,x_legal_entity_id => l_legal_entity_id
144: ,x_taxpayer_id => l_tax_payer_id

Line 148: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );

144: ,x_taxpayer_id => l_tax_payer_id
145: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
146: ,pv_period_name => p_period);
147: IF p_debug_flag = 'Y' THEN
148: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
149: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
150: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
151: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
152: fnd_file.put_line(fnd_file.log,' ');

Line 149: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );

145: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
146: ,pv_period_name => p_period);
147: IF p_debug_flag = 'Y' THEN
148: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
149: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
150: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
151: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
152: fnd_file.put_line(fnd_file.log,' ');
153: END IF ;

Line 150: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );

146: ,pv_period_name => p_period);
147: IF p_debug_flag = 'Y' THEN
148: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
149: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
150: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
151: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
152: fnd_file.put_line(fnd_file.log,' ');
153: END IF ;
154:

Line 151: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );

147: IF p_debug_flag = 'Y' THEN
148: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
149: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
150: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
151: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
152: fnd_file.put_line(fnd_file.log,' ');
153: END IF ;
154:
155: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');

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

148: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
149: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
150: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
151: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
152: fnd_file.put_line(fnd_file.log,' ');
153: END IF ;
154:
155: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
156: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num

Line 155: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');

151: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
152: fnd_file.put_line(fnd_file.log,' ');
153: END IF ;
154:
155: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
156: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
157: ,x_period_start_date => l_period_start_date
158: ,x_period_end_date => l_period_end_date
159: ,x_status => l_reporting_status

Line 167: fnd_file.put_line(fnd_file.log,'Getting TO_PERIOD_INFO');

163:
164: -- Bug8267272 Start Below code added to get end_date of TO_PERIOD
165: IF nvl(P_REPORT_NAME,'ZZ') in('JEESRVAR','JEESRPVP') THEN
166:
167: fnd_file.put_line(fnd_file.log,'Getting TO_PERIOD_INFO');
168:
169: jg_zz_common_pkg.tax_registration(x_tax_registration => l_to_tax_registration_num
170: ,x_period_start_date => l_to_period_start_date
171: ,x_period_end_date => l_to_period_end_date

Line 176: fnd_file.put_line(fnd_file.log,'To Period Start Date :'||l_to_period_start_date);

172: ,x_status => l_to_reporting_status
173: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
174: ,pv_period_name => p_period_to
175: ,pv_source => 'ALL');
176: fnd_file.put_line(fnd_file.log,'To Period Start Date :'||l_to_period_start_date);
177: fnd_file.put_line(fnd_file.log,'To Period End Date :'||l_to_period_end_date);
178: END IF;
179: -- Bug8267272 End
180:

Line 177: fnd_file.put_line(fnd_file.log,'To Period End Date :'||l_to_period_end_date);

173: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
174: ,pv_period_name => p_period_to
175: ,pv_source => 'ALL');
176: fnd_file.put_line(fnd_file.log,'To Period Start Date :'||l_to_period_start_date);
177: fnd_file.put_line(fnd_file.log,'To Period End Date :'||l_to_period_end_date);
178: END IF;
179: -- Bug8267272 End
180:
181: fnd_file.put_line(fnd_file.log,'JG_ZZ_VAT_REP_UTILITY.get_period_status');

Line 181: fnd_file.put_line(fnd_file.log,'JG_ZZ_VAT_REP_UTILITY.get_period_status');

177: fnd_file.put_line(fnd_file.log,'To Period End Date :'||l_to_period_end_date);
178: END IF;
179: -- Bug8267272 End
180:
181: fnd_file.put_line(fnd_file.log,'JG_ZZ_VAT_REP_UTILITY.get_period_status');
182: IF P_REPORT_NAME = 'JEITAPSR' OR P_REPORT_NAME = 'JEITAPPV' THEN
183: -- Get the Start Sequence Number for the Previous Finally Reported period for same report and vat register.
184: l_start_seq := get_start_sequence;
185:

Line 220: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );

216: ,pv_report_name => p_report_name);
217: END IF;
218:
219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
221: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
222: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
223: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
224: fnd_file.put_line(fnd_file.log,' ');

Line 221: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );

217: END IF;
218:
219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
221: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
222: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
223: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
224: fnd_file.put_line(fnd_file.log,' ');
225: END IF ;

Line 222: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );

218:
219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
221: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
222: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
223: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
224: fnd_file.put_line(fnd_file.log,' ');
225: END IF ;
226: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');

Line 223: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );

219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
221: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
222: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
223: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
224: fnd_file.put_line(fnd_file.log,' ');
225: END IF ;
226: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
227: jg_zz_common_pkg.company_detail(x_company_name => l_company_name

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

220: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
221: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
222: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
223: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
224: fnd_file.put_line(fnd_file.log,' ');
225: END IF ;
226: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
227: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
228: ,x_registration_number => l_registration_num

Line 226: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');

222: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
223: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
224: fnd_file.put_line(fnd_file.log,' ');
225: END IF ;
226: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
227: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
228: ,x_registration_number => l_registration_num
229: ,x_country => l_country
230: ,x_address1 => l_address_line_1

Line 245: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );

241: ,pn_legal_entity_id => l_legal_entity_id
242: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
243:
244: IF p_debug_flag = 'Y' THEN
245: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
246: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
247: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
248: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );

Line 246: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );

242: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
243:
244: IF p_debug_flag = 'Y' THEN
245: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
246: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
247: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
248: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );

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

243:
244: IF p_debug_flag = 'Y' THEN
245: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
246: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
247: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
248: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );

Line 248: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );

244: IF p_debug_flag = 'Y' THEN
245: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
246: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
247: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
248: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );

Line 249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );

245: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
246: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
247: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
248: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
253: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );

Line 250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );

246: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
247: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
248: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
253: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
254: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );

Line 251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );

247: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
248: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
253: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
254: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
255: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );

Line 252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );

248: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
253: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
254: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
255: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
256: fnd_file.put_line(fnd_file.log,' ');

Line 253: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );

249: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
253: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
254: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
255: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
256: fnd_file.put_line(fnd_file.log,' ');
257: END IF ;

Line 254: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );

250: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
253: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
254: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
255: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
256: fnd_file.put_line(fnd_file.log,' ');
257: END IF ;
258:

Line 255: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );

251: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
253: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
254: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
255: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
256: fnd_file.put_line(fnd_file.log,' ');
257: END IF ;
258:
259: /* Get Currency Precision */ --Bug:8201935

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

252: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
253: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
254: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
255: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
256: fnd_file.put_line(fnd_file.log,' ');
257: END IF ;
258:
259: /* Get Currency Precision */ --Bug:8201935
260:

Line 262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||l_func_curr);

258:
259: /* Get Currency Precision */ --Bug:8201935
260:
261: BEGIN
262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||l_func_curr);
263:
264: SELECT precision
265: INTO g_precision
266: FROM fnd_currencies

Line 269: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||g_precision);

265: INTO g_precision
266: FROM fnd_currencies
267: WHERE currency_code = l_func_curr;
268:
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||g_precision);
270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in getting currency precision');

Line 273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in getting currency precision');

269: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||g_precision);
270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in getting currency precision');
274: END;
275:
276: IF P_REPORT_NAME = 'JEBEDV08' THEN
277: fnd_file.put_line(fnd_file.log,'Calling JEBEDV08');

Line 277: fnd_file.put_line(fnd_file.log,'Calling JEBEDV08');

273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in getting currency precision');
274: END;
275:
276: IF P_REPORT_NAME = 'JEBEDV08' THEN
277: fnd_file.put_line(fnd_file.log,'Calling JEBEDV08');
278: jebedv08(p_vat_rep_entity_id => p_vat_rep_entity_id
279: ,p_period => p_period
280: ,p_document_sequence_name_from => p_document_sequence_name_from
281: ,p_document_sequence_name_to => p_document_sequence_name_to

Line 286: fnd_file.put_line(fnd_file.log,'After Calling JEBEDV08');

282: ,p_vendor_name_from => p_vendor_name_from
283: ,p_vendor_name_to => p_vendor_name_to
284: ,p_detail_summary => p_detail_summary
285: ,x_err_msg => l_err_msg);
286: fnd_file.put_line(fnd_file.log,'After Calling JEBEDV08');
287: ELSIF P_REPORT_NAME = 'JEITAPSR' THEN
288: fnd_file.put_line(fnd_file.log,'Calling JEITAPSR');
289: jeitapsr(p_vat_rep_entity_id => p_vat_rep_entity_id
290: ,p_period => p_period

Line 288: fnd_file.put_line(fnd_file.log,'Calling JEITAPSR');

284: ,p_detail_summary => p_detail_summary
285: ,x_err_msg => l_err_msg);
286: fnd_file.put_line(fnd_file.log,'After Calling JEBEDV08');
287: ELSIF P_REPORT_NAME = 'JEITAPSR' THEN
288: fnd_file.put_line(fnd_file.log,'Calling JEITAPSR');
289: jeitapsr(p_vat_rep_entity_id => p_vat_rep_entity_id
290: ,p_period => p_period
291: ,p_vat_register_id => p_vat_register_id
292: ,x_err_msg => l_err_msg);

Line 293: fnd_file.put_line(fnd_file.log,'After Calling JEITAPSR');

289: jeitapsr(p_vat_rep_entity_id => p_vat_rep_entity_id
290: ,p_period => p_period
291: ,p_vat_register_id => p_vat_register_id
292: ,x_err_msg => l_err_msg);
293: fnd_file.put_line(fnd_file.log,'After Calling JEITAPSR');
294: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
295: fnd_file.put_line(fnd_file.log,'Calling JEITAPPV');
296: jeitappv(p_vat_rep_entity_id => p_vat_rep_entity_id
297: ,p_period => p_period

Line 295: fnd_file.put_line(fnd_file.log,'Calling JEITAPPV');

291: ,p_vat_register_id => p_vat_register_id
292: ,x_err_msg => l_err_msg);
293: fnd_file.put_line(fnd_file.log,'After Calling JEITAPSR');
294: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
295: fnd_file.put_line(fnd_file.log,'Calling JEITAPPV');
296: jeitappv(p_vat_rep_entity_id => p_vat_rep_entity_id
297: ,p_period => p_period
298: ,p_vat_register_id => p_vat_register_id
299: ,x_err_msg => l_err_msg);

Line 300: fnd_file.put_line(fnd_file.log,'After Calling JEITAPPV');

296: jeitappv(p_vat_rep_entity_id => p_vat_rep_entity_id
297: ,p_period => p_period
298: ,p_vat_register_id => p_vat_register_id
299: ,x_err_msg => l_err_msg);
300: fnd_file.put_line(fnd_file.log,'After Calling JEITAPPV');
301: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
302: fnd_file.put_line(fnd_file.log,'Calling JEESRVAR');
303: jeesrvar(p_vat_rep_entity_id => p_vat_rep_entity_id
304: ,p_period => p_period

Line 302: fnd_file.put_line(fnd_file.log,'Calling JEESRVAR');

298: ,p_vat_register_id => p_vat_register_id
299: ,x_err_msg => l_err_msg);
300: fnd_file.put_line(fnd_file.log,'After Calling JEITAPPV');
301: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
302: fnd_file.put_line(fnd_file.log,'Calling JEESRVAR');
303: jeesrvar(p_vat_rep_entity_id => p_vat_rep_entity_id
304: ,p_period => p_period
305: ,p_period_to => p_period_to -- Bug8267272
306: ,p_tax_type => p_tax_type

Line 310: fnd_file.put_line(fnd_file.log,'After Calling JEESRVAR');

306: ,p_tax_type => p_tax_type
307: ,p_balancing_segment => p_balancing_segment
308: ,p_start_inv_sequence => p_start_inv_sequence
309: ,x_err_msg => l_err_msg);
310: fnd_file.put_line(fnd_file.log,'After Calling JEESRVAR');
311: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
312: fnd_file.put_line(fnd_file.log,'Calling Procedure JEESRPVP');
313: jeesrpvp(p_vat_rep_entity_id => p_vat_rep_entity_id
314: ,p_period => p_period

Line 312: fnd_file.put_line(fnd_file.log,'Calling Procedure JEESRPVP');

308: ,p_start_inv_sequence => p_start_inv_sequence
309: ,x_err_msg => l_err_msg);
310: fnd_file.put_line(fnd_file.log,'After Calling JEESRVAR');
311: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
312: fnd_file.put_line(fnd_file.log,'Calling Procedure JEESRPVP');
313: jeesrpvp(p_vat_rep_entity_id => p_vat_rep_entity_id
314: ,p_period => p_period
315: ,p_period_to => p_period_to -- Bug8267272
316: ,p_tax_type => p_tax_type

Line 321: fnd_file.put_line(fnd_file.log,'After Calling JEESRPVP');

317: ,p_register_type => p_register_type
318: ,p_balancing_segment => p_balancing_segment
319: ,p_start_inv_sequence => p_start_inv_sequence
320: ,x_err_msg => l_err_msg);
321: fnd_file.put_line(fnd_file.log,'After Calling JEESRPVP');
322: ELSIF P_REPORT_NAME is null THEN
323: fnd_file.put_line(fnd_file.log,'Calling JOURNAL_AP');
324: journal_ap(p_vat_rep_entity_id => p_vat_rep_entity_id
325: ,p_period => p_period

Line 323: fnd_file.put_line(fnd_file.log,'Calling JOURNAL_AP');

319: ,p_start_inv_sequence => p_start_inv_sequence
320: ,x_err_msg => l_err_msg);
321: fnd_file.put_line(fnd_file.log,'After Calling JEESRPVP');
322: ELSIF P_REPORT_NAME is null THEN
323: fnd_file.put_line(fnd_file.log,'Calling JOURNAL_AP');
324: journal_ap(p_vat_rep_entity_id => p_vat_rep_entity_id
325: ,p_period => p_period
326: ,x_err_msg => l_err_msg);
327: fnd_file.put_line(fnd_file.log,'After Calling JOURNAL_AP');

Line 327: fnd_file.put_line(fnd_file.log,'After Calling JOURNAL_AP');

323: fnd_file.put_line(fnd_file.log,'Calling JOURNAL_AP');
324: journal_ap(p_vat_rep_entity_id => p_vat_rep_entity_id
325: ,p_period => p_period
326: ,x_err_msg => l_err_msg);
327: fnd_file.put_line(fnd_file.log,'After Calling JOURNAL_AP');
328: END IF;
329:
330: INSERT INTO jg_zz_vat_trx_gt
331: ( jg_info_n1

Line 387: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);

383: ,l_comm_num
384: ,l_vat_reg_num
385: );
386:
387: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);
388: fnd_file.put_line(fnd_file.log,'l_to_period_end_date :'||l_to_period_end_date);
389:
390:
391: RETURN (TRUE);

Line 388: fnd_file.put_line(fnd_file.log,'l_to_period_end_date :'||l_to_period_end_date);

384: ,l_vat_reg_num
385: );
386:
387: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);
388: fnd_file.put_line(fnd_file.log,'l_to_period_end_date :'||l_to_period_end_date);
389:
390:
391: RETURN (TRUE);
392: EXCEPTION

Line 394: fnd_file.put_line(fnd_file.log,'Error occurred in beforeReport.' || SQLERRM || SQLCODE);

390:
391: RETURN (TRUE);
392: EXCEPTION
393: WHEN OTHERS THEN
394: fnd_file.put_line(fnd_file.log,'Error occurred in beforeReport.' || SQLERRM || SQLCODE);
395: RETURN (FALSE);
396: END beforeReport;
397:
398: --

Line 651: fnd_file.put_line(fnd_file.log,'Updating jg_zz_vat_trx_gt using lag logic' );

647:
648: --update used in case of multiple adjusted invoices
649: --update the 2nd record having the same amount for same combination used in partition logic
650: --
651: fnd_file.put_line(fnd_file.log,'Updating jg_zz_vat_trx_gt using lag logic' );
652: update jg_zz_vat_trx_gt
653: set
654: jg_info_n29 = 1
655: where

Line 667: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

663: FROM jg_zz_vat_trx_gt
664: WHERE jg_info_v30='JEBEDV08';
665:
666: IF p_debug_flag = 'Y' THEN
667: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
668: END IF ;
669:
670: EXCEPTION
671: WHEN OTHERS THEN

Line 672: fnd_file.put_line(fnd_file.log,'Error occurred in jebedv08 procedure.' || SQLERRM || SQLCODE);

668: END IF ;
669:
670: EXCEPTION
671: WHEN OTHERS THEN
672: fnd_file.put_line(fnd_file.log,'Error occurred in jebedv08 procedure.' || SQLERRM || SQLCODE);
673: END jebedv08;
674:
675: --
676: -- +======================================================================+

Line 839: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

835: FROM jg_zz_vat_trx_gt
836: WHERE jg_info_v30='JEITAPSR';
837:
838: IF p_debug_flag = 'Y' THEN
839: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
840: END IF ;
841:
842: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
843: IF lv_reporting_status = 'FINAL' THEN

Line 883: fnd_file.put_line(fnd_file.log,'Error in procedure jeitapsr.' || SQLERRM || SQLCODE);

879: END IF;
880:
881: EXCEPTION
882: WHEN OTHERS THEN
883: fnd_file.put_line(fnd_file.log,'Error in procedure jeitapsr.' || SQLERRM || SQLCODE);
884: END jeitapsr;
885:
886: --
887: -- +======================================================================+

Line 1089: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1085: FROM jg_zz_vat_trx_gt
1086: WHERE jg_info_v30='JEITAPPV';
1087:
1088: IF p_debug_flag = 'Y' THEN
1089: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1090: END IF ;
1091:
1092: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
1093: IF lv_reporting_status = 'FINAL' THEN

Line 1137: fnd_file.put_line(fnd_file.log,'Error occurred in procedure jeitappv.' || SQLERRM || SQLCODE);

1133: END IF;
1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: fnd_file.put_line(fnd_file.log,'Error occurred in procedure jeitappv.' || SQLERRM || SQLCODE);
1138: END jeitappv;
1139:
1140: --
1141: -- +======================================================================+

Line 1259: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1255: FROM jg_zz_vat_trx_gt
1256: WHERE jg_info_v30='JEESRVAR';
1257:
1258: IF p_debug_flag = 'Y' THEN
1259: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1260: END IF ;
1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN

Line 1264: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1260: END IF ;
1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1265: END jeesrvar;
1266:
1267: --
1268: -- +======================================================================+

Line 1444: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1440: FROM jg_zz_vat_trx_gt
1441: WHERE jg_info_v30='JEESRPVP';
1442:
1443: IF p_debug_flag = 'Y' THEN
1444: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1445: END IF ;
1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN

Line 1449: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1445: END IF ;
1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1450: END jeesrpvp;
1451:
1452: --
1453: -- +======================================================================+

Line 1654: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1650: FROM jg_zz_vat_trx_gt
1651: WHERE jg_info_v30='JOURNAL_AP';
1652:
1653: IF p_debug_flag = 'Y' THEN
1654: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1655: END IF ;
1656: EXCEPTION
1657: WHEN OTHERS THEN
1658: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

Line 1658: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1654: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1655: END IF ;
1656: EXCEPTION
1657: WHEN OTHERS THEN
1658: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1659: END journal_ap;
1660:
1661: FUNCTION lcu_trans_line_tax_amt (P_TRX_ID IN NUMBER) RETURN NUMBER IS
1662: ln_tax_amt_funcl_curr NUMBER;

Line 1676: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1672: RETURN ln_tax_amt_funcl_curr;
1673:
1674: EXCEPTION
1675: WHEN OTHERS THEN
1676: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1677: RETURN 0;
1678: END lcu_trans_line_tax_amt;
1679:
1680:

Line 1696: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1692: RETURN ln_taxable_amt_funcl_curr;
1693:
1694: EXCEPTION
1695: WHEN OTHERS THEN
1696: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1697: RETURN 0;
1698: END lcu_trans_line_taxable_amt;
1699:
1700: FUNCTION lcu_trans_line_tax_taxable_amt (p_trx_id IN NUMBER) RETURN NUMBER IS

Line 1716: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1712: RETURN ln_taxable_amt_funcl_curr;
1713:
1714: EXCEPTION
1715: WHEN OTHERS THEN
1716: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1717: RETURN 0;
1718: END lcu_trans_line_tax_taxable_amt;
1719:
1720:

Line 1724: fnd_file.put_line(fnd_file.log,'Calling Current Date Conversions');

1720:
1721: FUNCTION get_current_date RETURN VARCHAR2
1722: IS
1723: BEGIN
1724: fnd_file.put_line(fnd_file.log,'Calling Current Date Conversions');
1725: RETURN fnd_date.date_to_charDT(sysdate);
1726: END get_current_date;
1727:
1728: