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

Line 139: fnd_file.put_line ( fnd_file.log, 'In main' );

135: lv_issuing_authority_id NUMBER(15);
136:
137: begin
138:
139: fnd_file.put_line ( fnd_file.log, 'In main' );
140:
141: IF p_debug_flag = 'Y' THEN
142: fnd_file.put_line(fnd_file.log,'Inside BeforeReport Trigger');
143: fnd_file.put_line(fnd_file.log,'p_reporting_entity_id : ' || P_REPORTING_ENTITY_ID);

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

138:
139: fnd_file.put_line ( fnd_file.log, 'In main' );
140:
141: IF p_debug_flag = 'Y' THEN
142: fnd_file.put_line(fnd_file.log,'Inside BeforeReport Trigger');
143: fnd_file.put_line(fnd_file.log,'p_reporting_entity_id : ' || P_REPORTING_ENTITY_ID);
144: fnd_file.put_line(fnd_file.log,'p_fiscal_year : ' || P_FISCAL_YEAR);
145: fnd_file.put_line(fnd_file.log,'p_dec_type : ' || P_DEC_TYPE);
146: fnd_file.put_line(fnd_file.log,'p_min_inv_amt : ' || P_MIN_INV_AMT);

Line 143: fnd_file.put_line(fnd_file.log,'p_reporting_entity_id : ' || P_REPORTING_ENTITY_ID);

139: fnd_file.put_line ( fnd_file.log, 'In main' );
140:
141: IF p_debug_flag = 'Y' THEN
142: fnd_file.put_line(fnd_file.log,'Inside BeforeReport Trigger');
143: fnd_file.put_line(fnd_file.log,'p_reporting_entity_id : ' || P_REPORTING_ENTITY_ID);
144: fnd_file.put_line(fnd_file.log,'p_fiscal_year : ' || P_FISCAL_YEAR);
145: fnd_file.put_line(fnd_file.log,'p_dec_type : ' || P_DEC_TYPE);
146: fnd_file.put_line(fnd_file.log,'p_min_inv_amt : ' || P_MIN_INV_AMT);
147: fnd_file.put_line(fnd_file.log,'p_called_from : ' || P_CALLED_FROM);

Line 144: fnd_file.put_line(fnd_file.log,'p_fiscal_year : ' || P_FISCAL_YEAR);

140:
141: IF p_debug_flag = 'Y' THEN
142: fnd_file.put_line(fnd_file.log,'Inside BeforeReport Trigger');
143: fnd_file.put_line(fnd_file.log,'p_reporting_entity_id : ' || P_REPORTING_ENTITY_ID);
144: fnd_file.put_line(fnd_file.log,'p_fiscal_year : ' || P_FISCAL_YEAR);
145: fnd_file.put_line(fnd_file.log,'p_dec_type : ' || P_DEC_TYPE);
146: fnd_file.put_line(fnd_file.log,'p_min_inv_amt : ' || P_MIN_INV_AMT);
147: fnd_file.put_line(fnd_file.log,'p_called_from : ' || P_CALLED_FROM);
148: fnd_file.put_line(fnd_file.log,'$Profile$.ORG_ID : ' || fnd_profile.value('ORG_ID'));

Line 145: fnd_file.put_line(fnd_file.log,'p_dec_type : ' || P_DEC_TYPE);

141: IF p_debug_flag = 'Y' THEN
142: fnd_file.put_line(fnd_file.log,'Inside BeforeReport Trigger');
143: fnd_file.put_line(fnd_file.log,'p_reporting_entity_id : ' || P_REPORTING_ENTITY_ID);
144: fnd_file.put_line(fnd_file.log,'p_fiscal_year : ' || P_FISCAL_YEAR);
145: fnd_file.put_line(fnd_file.log,'p_dec_type : ' || P_DEC_TYPE);
146: fnd_file.put_line(fnd_file.log,'p_min_inv_amt : ' || P_MIN_INV_AMT);
147: fnd_file.put_line(fnd_file.log,'p_called_from : ' || P_CALLED_FROM);
148: fnd_file.put_line(fnd_file.log,'$Profile$.ORG_ID : ' || fnd_profile.value('ORG_ID'));
149: END IF ;

Line 146: fnd_file.put_line(fnd_file.log,'p_min_inv_amt : ' || P_MIN_INV_AMT);

142: fnd_file.put_line(fnd_file.log,'Inside BeforeReport Trigger');
143: fnd_file.put_line(fnd_file.log,'p_reporting_entity_id : ' || P_REPORTING_ENTITY_ID);
144: fnd_file.put_line(fnd_file.log,'p_fiscal_year : ' || P_FISCAL_YEAR);
145: fnd_file.put_line(fnd_file.log,'p_dec_type : ' || P_DEC_TYPE);
146: fnd_file.put_line(fnd_file.log,'p_min_inv_amt : ' || P_MIN_INV_AMT);
147: fnd_file.put_line(fnd_file.log,'p_called_from : ' || P_CALLED_FROM);
148: fnd_file.put_line(fnd_file.log,'$Profile$.ORG_ID : ' || fnd_profile.value('ORG_ID'));
149: END IF ;
150:

Line 147: fnd_file.put_line(fnd_file.log,'p_called_from : ' || P_CALLED_FROM);

143: fnd_file.put_line(fnd_file.log,'p_reporting_entity_id : ' || P_REPORTING_ENTITY_ID);
144: fnd_file.put_line(fnd_file.log,'p_fiscal_year : ' || P_FISCAL_YEAR);
145: fnd_file.put_line(fnd_file.log,'p_dec_type : ' || P_DEC_TYPE);
146: fnd_file.put_line(fnd_file.log,'p_min_inv_amt : ' || P_MIN_INV_AMT);
147: fnd_file.put_line(fnd_file.log,'p_called_from : ' || P_CALLED_FROM);
148: fnd_file.put_line(fnd_file.log,'$Profile$.ORG_ID : ' || fnd_profile.value('ORG_ID'));
149: END IF ;
150:
151: OPEN c_get_le_and_period_dates ;

Line 148: fnd_file.put_line(fnd_file.log,'$Profile$.ORG_ID : ' || fnd_profile.value('ORG_ID'));

144: fnd_file.put_line(fnd_file.log,'p_fiscal_year : ' || P_FISCAL_YEAR);
145: fnd_file.put_line(fnd_file.log,'p_dec_type : ' || P_DEC_TYPE);
146: fnd_file.put_line(fnd_file.log,'p_min_inv_amt : ' || P_MIN_INV_AMT);
147: fnd_file.put_line(fnd_file.log,'p_called_from : ' || P_CALLED_FROM);
148: fnd_file.put_line(fnd_file.log,'$Profile$.ORG_ID : ' || fnd_profile.value('ORG_ID'));
149: END IF ;
150:
151: OPEN c_get_le_and_period_dates ;
152: FETCH c_get_le_and_period_dates INTO gn_legal_entity_id

Line 158: fnd_file.put_line ( fnd_file.log, gn_legal_entity_id || ' : ' || gv_repent_trn || ' : ' || gd_period_start_date || ' : ' || gd_period_end_date );

154: ,gd_period_start_date
155: ,gd_period_end_date ;
156: CLOSE c_get_le_and_period_dates ;
157:
158: fnd_file.put_line ( fnd_file.log, gn_legal_entity_id || ' : ' || gv_repent_trn || ' : ' || gd_period_start_date || ' : ' || gd_period_end_date );
159:
160: IF p_debug_flag = 'Y' THEN
161: fnd_file.put_line(fnd_file.log,'gn_legal_entity_id : ' ||gn_legal_entity_id);
162: fnd_file.put_line(fnd_file.log,'gv_repent_trn : ' ||gv_repent_trn);

Line 161: fnd_file.put_line(fnd_file.log,'gn_legal_entity_id : ' ||gn_legal_entity_id);

157:
158: fnd_file.put_line ( fnd_file.log, gn_legal_entity_id || ' : ' || gv_repent_trn || ' : ' || gd_period_start_date || ' : ' || gd_period_end_date );
159:
160: IF p_debug_flag = 'Y' THEN
161: fnd_file.put_line(fnd_file.log,'gn_legal_entity_id : ' ||gn_legal_entity_id);
162: fnd_file.put_line(fnd_file.log,'gv_repent_trn : ' ||gv_repent_trn);
163: fnd_file.put_line(fnd_file.log,'gd_period_start_date : ' ||gd_period_start_date);
164: fnd_file.put_line(fnd_file.log,'gd_period_end_date : ' ||gd_period_end_date);
165: END IF ;

Line 162: fnd_file.put_line(fnd_file.log,'gv_repent_trn : ' ||gv_repent_trn);

158: fnd_file.put_line ( fnd_file.log, gn_legal_entity_id || ' : ' || gv_repent_trn || ' : ' || gd_period_start_date || ' : ' || gd_period_end_date );
159:
160: IF p_debug_flag = 'Y' THEN
161: fnd_file.put_line(fnd_file.log,'gn_legal_entity_id : ' ||gn_legal_entity_id);
162: fnd_file.put_line(fnd_file.log,'gv_repent_trn : ' ||gv_repent_trn);
163: fnd_file.put_line(fnd_file.log,'gd_period_start_date : ' ||gd_period_start_date);
164: fnd_file.put_line(fnd_file.log,'gd_period_end_date : ' ||gd_period_end_date);
165: END IF ;
166:

Line 163: fnd_file.put_line(fnd_file.log,'gd_period_start_date : ' ||gd_period_start_date);

159:
160: IF p_debug_flag = 'Y' THEN
161: fnd_file.put_line(fnd_file.log,'gn_legal_entity_id : ' ||gn_legal_entity_id);
162: fnd_file.put_line(fnd_file.log,'gv_repent_trn : ' ||gv_repent_trn);
163: fnd_file.put_line(fnd_file.log,'gd_period_start_date : ' ||gd_period_start_date);
164: fnd_file.put_line(fnd_file.log,'gd_period_end_date : ' ||gd_period_end_date);
165: END IF ;
166:
167: OPEN c_get_rep_entity_info;

Line 164: fnd_file.put_line(fnd_file.log,'gd_period_end_date : ' ||gd_period_end_date);

160: IF p_debug_flag = 'Y' THEN
161: fnd_file.put_line(fnd_file.log,'gn_legal_entity_id : ' ||gn_legal_entity_id);
162: fnd_file.put_line(fnd_file.log,'gv_repent_trn : ' ||gv_repent_trn);
163: fnd_file.put_line(fnd_file.log,'gd_period_start_date : ' ||gd_period_start_date);
164: fnd_file.put_line(fnd_file.log,'gd_period_end_date : ' ||gd_period_end_date);
165: END IF ;
166:
167: OPEN c_get_rep_entity_info;
168: FETCH c_get_rep_entity_info INTO gv_repent_id_number

Line 194: fnd_file.put_line(fnd_file.log,'gv_repent_id_number : ' ||gv_repent_id_number ) ;

190: WHERE hzp.party_id = lv_party_id;
191: END IF;
192:
193: IF p_debug_flag = 'Y' THEN
194: fnd_file.put_line(fnd_file.log,'gv_repent_id_number : ' ||gv_repent_id_number ) ;
195: fnd_file.put_line(fnd_file.log,'gv_repent_name : ' ||gv_repent_name ) ;
196: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_1 : ' ||gv_repent_address_line_1 ) ;
197: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_2 : ' ||gv_repent_address_line_2 ) ;
198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;

Line 195: fnd_file.put_line(fnd_file.log,'gv_repent_name : ' ||gv_repent_name ) ;

191: END IF;
192:
193: IF p_debug_flag = 'Y' THEN
194: fnd_file.put_line(fnd_file.log,'gv_repent_id_number : ' ||gv_repent_id_number ) ;
195: fnd_file.put_line(fnd_file.log,'gv_repent_name : ' ||gv_repent_name ) ;
196: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_1 : ' ||gv_repent_address_line_1 ) ;
197: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_2 : ' ||gv_repent_address_line_2 ) ;
198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;
199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;

Line 196: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_1 : ' ||gv_repent_address_line_1 ) ;

192:
193: IF p_debug_flag = 'Y' THEN
194: fnd_file.put_line(fnd_file.log,'gv_repent_id_number : ' ||gv_repent_id_number ) ;
195: fnd_file.put_line(fnd_file.log,'gv_repent_name : ' ||gv_repent_name ) ;
196: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_1 : ' ||gv_repent_address_line_1 ) ;
197: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_2 : ' ||gv_repent_address_line_2 ) ;
198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;
199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;
200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;

Line 197: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_2 : ' ||gv_repent_address_line_2 ) ;

193: IF p_debug_flag = 'Y' THEN
194: fnd_file.put_line(fnd_file.log,'gv_repent_id_number : ' ||gv_repent_id_number ) ;
195: fnd_file.put_line(fnd_file.log,'gv_repent_name : ' ||gv_repent_name ) ;
196: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_1 : ' ||gv_repent_address_line_1 ) ;
197: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_2 : ' ||gv_repent_address_line_2 ) ;
198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;
199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;
200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;
201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;

Line 198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;

194: fnd_file.put_line(fnd_file.log,'gv_repent_id_number : ' ||gv_repent_id_number ) ;
195: fnd_file.put_line(fnd_file.log,'gv_repent_name : ' ||gv_repent_name ) ;
196: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_1 : ' ||gv_repent_address_line_1 ) ;
197: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_2 : ' ||gv_repent_address_line_2 ) ;
198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;
199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;
200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;
201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;
202: fnd_file.put_line(fnd_file.log,'gv_repent_phone_number : ' ||gv_repent_phone_number ) ;

Line 199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;

195: fnd_file.put_line(fnd_file.log,'gv_repent_name : ' ||gv_repent_name ) ;
196: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_1 : ' ||gv_repent_address_line_1 ) ;
197: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_2 : ' ||gv_repent_address_line_2 ) ;
198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;
199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;
200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;
201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;
202: fnd_file.put_line(fnd_file.log,'gv_repent_phone_number : ' ||gv_repent_phone_number ) ;
203: fnd_file.put_line(fnd_file.log,'gv_tax_office_location : ' ||gv_tax_office_location ) ;

Line 200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;

196: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_1 : ' ||gv_repent_address_line_1 ) ;
197: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_2 : ' ||gv_repent_address_line_2 ) ;
198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;
199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;
200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;
201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;
202: fnd_file.put_line(fnd_file.log,'gv_repent_phone_number : ' ||gv_repent_phone_number ) ;
203: fnd_file.put_line(fnd_file.log,'gv_tax_office_location : ' ||gv_tax_office_location ) ;
204: fnd_file.put_line(fnd_file.log,'gv_tax_office_number : ' ||gv_tax_office_number ) ;

Line 201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;

197: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_2 : ' ||gv_repent_address_line_2 ) ;
198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;
199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;
200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;
201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;
202: fnd_file.put_line(fnd_file.log,'gv_repent_phone_number : ' ||gv_repent_phone_number ) ;
203: fnd_file.put_line(fnd_file.log,'gv_tax_office_location : ' ||gv_tax_office_location ) ;
204: fnd_file.put_line(fnd_file.log,'gv_tax_office_number : ' ||gv_tax_office_number ) ;
205: fnd_file.put_line(fnd_file.log,'gv_tax_office_code : ' ||gv_tax_office_code ) ;

Line 202: fnd_file.put_line(fnd_file.log,'gv_repent_phone_number : ' ||gv_repent_phone_number ) ;

198: fnd_file.put_line(fnd_file.log,'gv_repent_address_line_3 : ' ||gv_repent_address_line_3 ) ;
199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;
200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;
201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;
202: fnd_file.put_line(fnd_file.log,'gv_repent_phone_number : ' ||gv_repent_phone_number ) ;
203: fnd_file.put_line(fnd_file.log,'gv_tax_office_location : ' ||gv_tax_office_location ) ;
204: fnd_file.put_line(fnd_file.log,'gv_tax_office_number : ' ||gv_tax_office_number ) ;
205: fnd_file.put_line(fnd_file.log,'gv_tax_office_code : ' ||gv_tax_office_code ) ;
206: END IF ;

Line 203: fnd_file.put_line(fnd_file.log,'gv_tax_office_location : ' ||gv_tax_office_location ) ;

199: fnd_file.put_line(fnd_file.log,'gv_repent_town_or_city : ' ||gv_repent_town_or_city ) ;
200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;
201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;
202: fnd_file.put_line(fnd_file.log,'gv_repent_phone_number : ' ||gv_repent_phone_number ) ;
203: fnd_file.put_line(fnd_file.log,'gv_tax_office_location : ' ||gv_tax_office_location ) ;
204: fnd_file.put_line(fnd_file.log,'gv_tax_office_number : ' ||gv_tax_office_number ) ;
205: fnd_file.put_line(fnd_file.log,'gv_tax_office_code : ' ||gv_tax_office_code ) ;
206: END IF ;
207:

Line 204: fnd_file.put_line(fnd_file.log,'gv_tax_office_number : ' ||gv_tax_office_number ) ;

200: fnd_file.put_line(fnd_file.log,'gv_repent_postal_code : ' ||gv_repent_postal_code ) ;
201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;
202: fnd_file.put_line(fnd_file.log,'gv_repent_phone_number : ' ||gv_repent_phone_number ) ;
203: fnd_file.put_line(fnd_file.log,'gv_tax_office_location : ' ||gv_tax_office_location ) ;
204: fnd_file.put_line(fnd_file.log,'gv_tax_office_number : ' ||gv_tax_office_number ) ;
205: fnd_file.put_line(fnd_file.log,'gv_tax_office_code : ' ||gv_tax_office_code ) ;
206: END IF ;
207:
208:

Line 205: fnd_file.put_line(fnd_file.log,'gv_tax_office_code : ' ||gv_tax_office_code ) ;

201: fnd_file.put_line(fnd_file.log,'gv_country : ' ||gv_country ) ;
202: fnd_file.put_line(fnd_file.log,'gv_repent_phone_number : ' ||gv_repent_phone_number ) ;
203: fnd_file.put_line(fnd_file.log,'gv_tax_office_location : ' ||gv_tax_office_location ) ;
204: fnd_file.put_line(fnd_file.log,'gv_tax_office_number : ' ||gv_tax_office_number ) ;
205: fnd_file.put_line(fnd_file.log,'gv_tax_office_code : ' ||gv_tax_office_code ) ;
206: END IF ;
207:
208:
209: OPEN c_currency_tax_reg_num;

Line 215: fnd_file.put_line(fnd_file.log,'gv_currency_code : '|| gv_currency_code ) ;

211: ,gv_tax_reg_num ;
212: CLOSE c_currency_tax_reg_num;
213:
214: IF p_debug_flag = 'Y' THEN
215: fnd_file.put_line(fnd_file.log,'gv_currency_code : '|| gv_currency_code ) ;
216: fnd_file.put_line(fnd_file.log,'gv_tax_reg_num : '|| gv_tax_reg_num ) ;
217: END IF ;
218:
219: OPEN entity_details;

Line 216: fnd_file.put_line(fnd_file.log,'gv_tax_reg_num : '|| gv_tax_reg_num ) ;

212: CLOSE c_currency_tax_reg_num;
213:
214: IF p_debug_flag = 'Y' THEN
215: fnd_file.put_line(fnd_file.log,'gv_currency_code : '|| gv_currency_code ) ;
216: fnd_file.put_line(fnd_file.log,'gv_tax_reg_num : '|| gv_tax_reg_num ) ;
217: END IF ;
218:
219: OPEN entity_details;
220: FETCH entity_details INTO gv_ledger_id,

Line 226: fnd_file.put_line(fnd_file.log,'gv_ledger_id : '|| gv_ledger_id ) ;

222: gv_chart_of_accounts_id;
223: CLOSE entity_details;
224:
225: IF p_debug_flag = 'Y' THEN
226: fnd_file.put_line(fnd_file.log,'gv_ledger_id : '|| gv_ledger_id ) ;
227: fnd_file.put_line(fnd_file.log,'gv_balancing_segment_value : '|| gv_balancing_segment_value ) ;
228: fnd_file.put_line(fnd_file.log,'gv_chart_of_accounts_id : '|| gv_chart_of_accounts_id ) ;
229: END IF ;
230:

Line 227: fnd_file.put_line(fnd_file.log,'gv_balancing_segment_value : '|| gv_balancing_segment_value ) ;

223: CLOSE entity_details;
224:
225: IF p_debug_flag = 'Y' THEN
226: fnd_file.put_line(fnd_file.log,'gv_ledger_id : '|| gv_ledger_id ) ;
227: fnd_file.put_line(fnd_file.log,'gv_balancing_segment_value : '|| gv_balancing_segment_value ) ;
228: fnd_file.put_line(fnd_file.log,'gv_chart_of_accounts_id : '|| gv_chart_of_accounts_id ) ;
229: END IF ;
230:
231: fnd_file.put_line(fnd_file.log,'Before Insert INTO JG_ZZ_VAT_TRX_GT table' ) ;

Line 228: fnd_file.put_line(fnd_file.log,'gv_chart_of_accounts_id : '|| gv_chart_of_accounts_id ) ;

224:
225: IF p_debug_flag = 'Y' THEN
226: fnd_file.put_line(fnd_file.log,'gv_ledger_id : '|| gv_ledger_id ) ;
227: fnd_file.put_line(fnd_file.log,'gv_balancing_segment_value : '|| gv_balancing_segment_value ) ;
228: fnd_file.put_line(fnd_file.log,'gv_chart_of_accounts_id : '|| gv_chart_of_accounts_id ) ;
229: END IF ;
230:
231: fnd_file.put_line(fnd_file.log,'Before Insert INTO JG_ZZ_VAT_TRX_GT table' ) ;
232:

Line 231: fnd_file.put_line(fnd_file.log,'Before Insert INTO JG_ZZ_VAT_TRX_GT table' ) ;

227: fnd_file.put_line(fnd_file.log,'gv_balancing_segment_value : '|| gv_balancing_segment_value ) ;
228: fnd_file.put_line(fnd_file.log,'gv_chart_of_accounts_id : '|| gv_chart_of_accounts_id ) ;
229: END IF ;
230:
231: fnd_file.put_line(fnd_file.log,'Before Insert INTO JG_ZZ_VAT_TRX_GT table' ) ;
232:
233: FOR r_inv_lines in c_generic_ar_inv_lines
234: LOOP
235:

Line 279: fnd_file.put_line(fnd_file.log,'Number of records inserted INTO JG_ZZ_VAT_TRX_GT table: ' || lv_count );

275: end loop;
276:
277: select count(*) INTO lv_count from jg_zz_vat_trx_gt;
278:
279: fnd_file.put_line(fnd_file.log,'Number of records inserted INTO JG_ZZ_VAT_TRX_GT table: ' || lv_count );
280: return (TRUE);
281: EXCEPTION
282: WHEN OTHERS THEN
283: fnd_file.put_line(fnd_file.log,'Unexpected error occurred in BeforeReport Trigger. Error : ' || SUBSTR(SQLERRM,1,200));

Line 283: fnd_file.put_line(fnd_file.log,'Unexpected error occurred in BeforeReport Trigger. Error : ' || SUBSTR(SQLERRM,1,200));

279: fnd_file.put_line(fnd_file.log,'Number of records inserted INTO JG_ZZ_VAT_TRX_GT table: ' || lv_count );
280: return (TRUE);
281: EXCEPTION
282: WHEN OTHERS THEN
283: fnd_file.put_line(fnd_file.log,'Unexpected error occurred in BeforeReport Trigger. Error : ' || SUBSTR(SQLERRM,1,200));
284: RETURN (NULL) ;
285:
286: END BeforeReport;
287:

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

320: RETURN (bal_segment_value);
321:
322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN
324: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));
325: RETURN NULL;
326: END get_bsv;
327:
328: /*