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 142: fnd_file.put_line ( fnd_file.log, 'In main' );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

325: RETURN (bal_segment_value);
326:
327: EXCEPTION
328: WHEN NO_DATA_FOUND THEN
329: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));
330: RETURN NULL;
331: END get_bsv;
332:
333: /*