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 168: fnd_file.put_line(fnd_file.log,'*Information***');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

208: , gv_vat_reg_num
209: , gv_vat_country_code ;
210: CLOSE c_currency_vat_reg_num;
211:
212: fnd_file.put_line(fnd_file.log,' gv_currency_code :'||gv_currency_code);
213: fnd_file.put_line(fnd_file.log,' gv_name :'||gv_name);
214: fnd_file.put_line(fnd_file.log,' gv_vat_reg_num :'||gv_vat_reg_num);
215: fnd_file.put_line(fnd_file.log,' gv_vat_country_code :'||gv_vat_country_code );
216:

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

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

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

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

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

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

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

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

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

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