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

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

167: ,gd_period_end_date
168: ,gv_entity_identifier;
169: CLOSE c_get_le_and_period_dates;
170:
171: fnd_file.put_line(fnd_file.log,'*******Information*********');
172: fnd_file.put_line(fnd_file.log,' gn_legal_entity_id :'|| gn_legal_entity_id);
173: fnd_file.put_line(fnd_file.log,' gv_repent_trn :'|| gv_repent_trn);
174: fnd_file.put_line(fnd_file.log,' gd_period_start_date :'||gd_period_start_date);
175: fnd_file.put_line(fnd_file.log,' gd_period_end_date :'|| gd_period_end_date);

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

168: ,gv_entity_identifier;
169: CLOSE c_get_le_and_period_dates;
170:
171: fnd_file.put_line(fnd_file.log,'*******Information*********');
172: fnd_file.put_line(fnd_file.log,' gn_legal_entity_id :'|| gn_legal_entity_id);
173: fnd_file.put_line(fnd_file.log,' gv_repent_trn :'|| gv_repent_trn);
174: fnd_file.put_line(fnd_file.log,' gd_period_start_date :'||gd_period_start_date);
175: fnd_file.put_line(fnd_file.log,' gd_period_end_date :'|| gd_period_end_date);
176: fnd_file.put_line(fnd_file.log,' gv_entity_identifier :'|| gv_entity_identifier);

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

169: CLOSE c_get_le_and_period_dates;
170:
171: fnd_file.put_line(fnd_file.log,'*******Information*********');
172: fnd_file.put_line(fnd_file.log,' gn_legal_entity_id :'|| gn_legal_entity_id);
173: fnd_file.put_line(fnd_file.log,' gv_repent_trn :'|| gv_repent_trn);
174: fnd_file.put_line(fnd_file.log,' gd_period_start_date :'||gd_period_start_date);
175: fnd_file.put_line(fnd_file.log,' gd_period_end_date :'|| gd_period_end_date);
176: fnd_file.put_line(fnd_file.log,' gv_entity_identifier :'|| gv_entity_identifier);
177:

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

170:
171: fnd_file.put_line(fnd_file.log,'*******Information*********');
172: fnd_file.put_line(fnd_file.log,' gn_legal_entity_id :'|| gn_legal_entity_id);
173: fnd_file.put_line(fnd_file.log,' gv_repent_trn :'|| gv_repent_trn);
174: fnd_file.put_line(fnd_file.log,' gd_period_start_date :'||gd_period_start_date);
175: fnd_file.put_line(fnd_file.log,' gd_period_end_date :'|| gd_period_end_date);
176: fnd_file.put_line(fnd_file.log,' gv_entity_identifier :'|| gv_entity_identifier);
177:
178: OPEN c_get_rep_entity_info;

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

171: fnd_file.put_line(fnd_file.log,'*******Information*********');
172: fnd_file.put_line(fnd_file.log,' gn_legal_entity_id :'|| gn_legal_entity_id);
173: fnd_file.put_line(fnd_file.log,' gv_repent_trn :'|| gv_repent_trn);
174: fnd_file.put_line(fnd_file.log,' gd_period_start_date :'||gd_period_start_date);
175: fnd_file.put_line(fnd_file.log,' gd_period_end_date :'|| gd_period_end_date);
176: fnd_file.put_line(fnd_file.log,' gv_entity_identifier :'|| gv_entity_identifier);
177:
178: OPEN c_get_rep_entity_info;
179: FETCH c_get_rep_entity_info into gv_repent_id_number

Line 176: fnd_file.put_line(fnd_file.log,' gv_entity_identifier :'|| gv_entity_identifier);

172: fnd_file.put_line(fnd_file.log,' gn_legal_entity_id :'|| gn_legal_entity_id);
173: fnd_file.put_line(fnd_file.log,' gv_repent_trn :'|| gv_repent_trn);
174: fnd_file.put_line(fnd_file.log,' gd_period_start_date :'||gd_period_start_date);
175: fnd_file.put_line(fnd_file.log,' gd_period_end_date :'|| gd_period_end_date);
176: fnd_file.put_line(fnd_file.log,' gv_entity_identifier :'|| gv_entity_identifier);
177:
178: OPEN c_get_rep_entity_info;
179: FETCH c_get_rep_entity_info into gv_repent_id_number
180: ,gv_repent_name

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

189: ,gv_tax_office_number
190: ,gv_tax_office_code ;
191: CLOSE c_get_rep_entity_info;
192:
193: fnd_file.put_line(fnd_file.log,' gv_repent_id_number :'||gv_repent_id_number);
194: fnd_file.put_line(fnd_file.log,' gv_repent_name :'|| gv_repent_name);
195: fnd_file.put_line(fnd_file.log,' gv_repent_address_line_1 :'||gv_repent_address_line_1);
196: fnd_file.put_line(fnd_file.log,' gv_repent_address_line_2 :'||gv_repent_address_line_2);
197: fnd_file.put_line(fnd_file.log,' gv_repent_address_line_3 :'||gv_repent_address_line_3);

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

190: ,gv_tax_office_code ;
191: CLOSE c_get_rep_entity_info;
192:
193: fnd_file.put_line(fnd_file.log,' gv_repent_id_number :'||gv_repent_id_number);
194: fnd_file.put_line(fnd_file.log,' gv_repent_name :'|| gv_repent_name);
195: fnd_file.put_line(fnd_file.log,' gv_repent_address_line_1 :'||gv_repent_address_line_1);
196: fnd_file.put_line(fnd_file.log,' gv_repent_address_line_2 :'||gv_repent_address_line_2);
197: fnd_file.put_line(fnd_file.log,' gv_repent_address_line_3 :'||gv_repent_address_line_3);
198: fnd_file.put_line(fnd_file.log,' gv_repent_town_or_city :'||gv_repent_town_or_city);

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

191: CLOSE c_get_rep_entity_info;
192:
193: fnd_file.put_line(fnd_file.log,' gv_repent_id_number :'||gv_repent_id_number);
194: fnd_file.put_line(fnd_file.log,' gv_repent_name :'|| gv_repent_name);
195: fnd_file.put_line(fnd_file.log,' gv_repent_address_line_1 :'||gv_repent_address_line_1);
196: fnd_file.put_line(fnd_file.log,' gv_repent_address_line_2 :'||gv_repent_address_line_2);
197: fnd_file.put_line(fnd_file.log,' gv_repent_address_line_3 :'||gv_repent_address_line_3);
198: fnd_file.put_line(fnd_file.log,' gv_repent_town_or_city :'||gv_repent_town_or_city);
199: fnd_file.put_line(fnd_file.log,' gv_repent_postal_code :'||gv_repent_postal_code);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

211: , gv_vat_reg_num
212: , gv_vat_country_code ;
213: CLOSE c_currency_vat_reg_num;
214:
215: fnd_file.put_line(fnd_file.log,' gv_currency_code :'||gv_currency_code);
216: fnd_file.put_line(fnd_file.log,' gv_name :'||gv_name);
217: fnd_file.put_line(fnd_file.log,' gv_vat_reg_num :'||gv_vat_reg_num);
218: fnd_file.put_line(fnd_file.log,' gv_vat_country_code :'||gv_vat_country_code );
219:

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

212: , gv_vat_country_code ;
213: CLOSE c_currency_vat_reg_num;
214:
215: fnd_file.put_line(fnd_file.log,' gv_currency_code :'||gv_currency_code);
216: fnd_file.put_line(fnd_file.log,' gv_name :'||gv_name);
217: fnd_file.put_line(fnd_file.log,' gv_vat_reg_num :'||gv_vat_reg_num);
218: fnd_file.put_line(fnd_file.log,' gv_vat_country_code :'||gv_vat_country_code );
219:
220: IF(gv_currency_code = 'PTE') THEN

Line 217: fnd_file.put_line(fnd_file.log,' gv_vat_reg_num :'||gv_vat_reg_num);

213: CLOSE c_currency_vat_reg_num;
214:
215: fnd_file.put_line(fnd_file.log,' gv_currency_code :'||gv_currency_code);
216: fnd_file.put_line(fnd_file.log,' gv_name :'||gv_name);
217: fnd_file.put_line(fnd_file.log,' gv_vat_reg_num :'||gv_vat_reg_num);
218: fnd_file.put_line(fnd_file.log,' gv_vat_country_code :'||gv_vat_country_code );
219:
220: IF(gv_currency_code = 'PTE') THEN
221: gn_thousands:= 1000;

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

214:
215: fnd_file.put_line(fnd_file.log,' gv_currency_code :'||gv_currency_code);
216: fnd_file.put_line(fnd_file.log,' gv_name :'||gv_name);
217: fnd_file.put_line(fnd_file.log,' gv_vat_reg_num :'||gv_vat_reg_num);
218: fnd_file.put_line(fnd_file.log,' gv_vat_country_code :'||gv_vat_country_code );
219:
220: IF(gv_currency_code = 'PTE') THEN
221: gn_thousands:= 1000;
222: ELSE

Line 287: fnd_file.put_line(fnd_file.log,' After inserting the data into Global Temp Table');

283: );
284:
285: END LOOP;
286:
287: fnd_file.put_line(fnd_file.log,' After inserting the data into Global Temp Table');
288:
289: RETURN (TRUE);
290: END;
291:

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

329: RETURN (bal_segment_value);
330:
331: EXCEPTION
332: WHEN NO_DATA_FOUND THEN
333: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));
334: RETURN NULL;
335:
336: END get_bsv;
337: