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.JL_BR_AR_LOG_VALIDATION dependencies on FND_FILE

Line 134: fnd_file.put_line(FND_FILE.LOG,'Parameters passed to JL_BR_AR_LOG_VALIDATION.logical_validation');

130: AND trunc(SYSDATE) between trunc(nvl(bsv.effective_from, SYSDATE))
131: and trunc(nvl(bsv.effective_to,SYSDATE)); --bug 9239401
132:
133: BEGIN
134: fnd_file.put_line(FND_FILE.LOG,'Parameters passed to JL_BR_AR_LOG_VALIDATION.logical_validation');
135: fnd_file.put_line(FND_FILE.LOG,'File Control : ' || p_file_control );
136: fnd_file.put_line(FND_FILE.LOG,'Sequence Number : ' || p_ent_seq_num );
137: fnd_file.put_line(FND_FILE.LOG,'Called From : ' || p_called_from);
138:

Line 135: fnd_file.put_line(FND_FILE.LOG,'File Control : ' || p_file_control );

131: and trunc(nvl(bsv.effective_to,SYSDATE)); --bug 9239401
132:
133: BEGIN
134: fnd_file.put_line(FND_FILE.LOG,'Parameters passed to JL_BR_AR_LOG_VALIDATION.logical_validation');
135: fnd_file.put_line(FND_FILE.LOG,'File Control : ' || p_file_control );
136: fnd_file.put_line(FND_FILE.LOG,'Sequence Number : ' || p_ent_seq_num );
137: fnd_file.put_line(FND_FILE.LOG,'Called From : ' || p_called_from);
138:
139:

Line 136: fnd_file.put_line(FND_FILE.LOG,'Sequence Number : ' || p_ent_seq_num );

132:
133: BEGIN
134: fnd_file.put_line(FND_FILE.LOG,'Parameters passed to JL_BR_AR_LOG_VALIDATION.logical_validation');
135: fnd_file.put_line(FND_FILE.LOG,'File Control : ' || p_file_control );
136: fnd_file.put_line(FND_FILE.LOG,'Sequence Number : ' || p_ent_seq_num );
137: fnd_file.put_line(FND_FILE.LOG,'Called From : ' || p_called_from);
138:
139:
140:

Line 137: fnd_file.put_line(FND_FILE.LOG,'Called From : ' || p_called_from);

133: BEGIN
134: fnd_file.put_line(FND_FILE.LOG,'Parameters passed to JL_BR_AR_LOG_VALIDATION.logical_validation');
135: fnd_file.put_line(FND_FILE.LOG,'File Control : ' || p_file_control );
136: fnd_file.put_line(FND_FILE.LOG,'Sequence Number : ' || p_ent_seq_num );
137: fnd_file.put_line(FND_FILE.LOG,'Called From : ' || p_called_from);
138:
139:
140:
141: X_bank_number := p_bank_number;

Line 154: fnd_file.put_line(FND_FILE.LOG,'Bank Number : ' || X_bank_number);

150: X_interest_amount_received := p_interest_amount_received;
151: X_discount_amount := p_discount_amount;
152: X_abatement_amount := p_abatement_amount;
153:
154: fnd_file.put_line(FND_FILE.LOG,'Bank Number : ' || X_bank_number);
155: fnd_file.put_line(FND_FILE.LOG,'Company Code : ' || X_company_code);
156: fnd_file.put_line(FND_FILE.LOG,'Inscription Number :' || X_inscription_number );
157:
158: /* Bug 8527766 */

Line 155: fnd_file.put_line(FND_FILE.LOG,'Company Code : ' || X_company_code);

151: X_discount_amount := p_discount_amount;
152: X_abatement_amount := p_abatement_amount;
153:
154: fnd_file.put_line(FND_FILE.LOG,'Bank Number : ' || X_bank_number);
155: fnd_file.put_line(FND_FILE.LOG,'Company Code : ' || X_company_code);
156: fnd_file.put_line(FND_FILE.LOG,'Inscription Number :' || X_inscription_number );
157:
158: /* Bug 8527766 */
159: /* Becoming 1st validation as BANK_PARTY_ID is NOT NULL in INTERFACE_EXT table */

Line 156: fnd_file.put_line(FND_FILE.LOG,'Inscription Number :' || X_inscription_number );

152: X_abatement_amount := p_abatement_amount;
153:
154: fnd_file.put_line(FND_FILE.LOG,'Bank Number : ' || X_bank_number);
155: fnd_file.put_line(FND_FILE.LOG,'Company Code : ' || X_company_code);
156: fnd_file.put_line(FND_FILE.LOG,'Inscription Number :' || X_inscription_number );
157:
158: /* Bug 8527766 */
159: /* Becoming 1st validation as BANK_PARTY_ID is NOT NULL in INTERFACE_EXT table */
160:

Line 165: fnd_file.put_line(FND_FILE.LOG,'Validating Bank Number...');

161: /****************************/
162: /* Validate Bank Number */
163: /****************************/
164:
165: fnd_file.put_line(FND_FILE.LOG,'Validating Bank Number...');
166:
167: BEGIN
168: /* CE uptake - Bug#2932986
169: SELECT distinct bank_number

Line 187: fnd_file.put_line(FND_FILE.LOG,'x_jlbr_bank_number: ' || X_jlbr_bank_number);

183: AND occ.bank_party_id = prof.party_id
184: AND prof.home_country ='BR'
185: AND rownum = 1;
186:
187: fnd_file.put_line(FND_FILE.LOG,'x_jlbr_bank_number: ' || X_jlbr_bank_number);
188: fnd_file.put_line(FND_FILE.LOG,'p_bank_party_id : ' || p_bank_party_id);
189:
190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN

Line 188: fnd_file.put_line(FND_FILE.LOG,'p_bank_party_id : ' || p_bank_party_id);

184: AND prof.home_country ='BR'
185: AND rownum = 1;
186:
187: fnd_file.put_line(FND_FILE.LOG,'x_jlbr_bank_number: ' || X_jlbr_bank_number);
188: fnd_file.put_line(FND_FILE.LOG,'p_bank_party_id : ' || p_bank_party_id);
189:
190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN
192: p_error_code := 'INVALID_BANK_NUMBER';

Line 201: fnd_file.put_line(FND_FILE.LOG,'Validating Occurrence Code...');

197: /*******************************/
198: /* Validate Occurrence Code */
199: /*******************************/
200:
201: fnd_file.put_line(FND_FILE.LOG,'Validating Occurrence Code...');
202:
203: BEGIN
204: -- CE uptake - Bug#2932986
205: SELECT occ.std_occurrence_code

Line 217: fnd_file.put_line(FND_FILE.LOG,'x_bank_occurrence_code_std : ' || x_bank_occurrence_code_std);

213: AND occ.bank_occurrence_type = 'RETURN_OCCURRENCE'
214: AND SYSDATE between TRUNC(prof.effective_start_date)
215: AND NVL(TRUNC(prof.effective_end_date), SYSDATE+1);
216:
217: fnd_file.put_line(FND_FILE.LOG,'x_bank_occurrence_code_std : ' || x_bank_occurrence_code_std);
218:
219: EXCEPTION
220: WHEN NO_DATA_FOUND THEN
221: p_error_code := 'INVALID_BANK_OCCURRENCE_CODE';

Line 229: fnd_file.put_line(FND_FILE.LOG,'Validating Occurrence Date...');

225: /****************************/
226: /* Validate Occurrence Date */
227: /****************************/
228:
229: fnd_file.put_line(FND_FILE.LOG,'Validating Occurrence Date...');
230:
231: BEGIN
232: valid_date := ARP_UTIL.IS_GL_DATE_VALID(p_occurrence_date);
233: IF NOT valid_date THEN

Line 244: fnd_file.put_line(FND_FILE.LOG,'Validating Company Code...');

240: /****************************/
241: /* Validate Company Code */
242: /****************************/
243:
244: fnd_file.put_line(FND_FILE.LOG,'Validating Company Code...');
245:
246: BEGIN
247: /*
248: SELECT distinct aba.global_attribute7

Line 275: fnd_file.put_line(FND_FILE.LOG,'x_dual_num : ' || x_dual_num);

271: -- bug 1892303
272: -- AND arps.trx_number||'-'||to_char(arps.terms_sequence_number) = trim(X_your_number)
273: AND to_number(acct.secondary_account_reference) = X_company_code;
274:
275: fnd_file.put_line(FND_FILE.LOG,'x_dual_num : ' || x_dual_num);
276:
277: EXCEPTION
278: WHEN NO_DATA_FOUND THEN
279: p_error_code := 'INVALID_COMPANY_CODE_FOR_BANK';

Line 289: fnd_file.put_line(FND_FILE.LOG,'Validating Document...');

285: /********************/
286: /* Validate Document*/
287: /********************/
288:
289: fnd_file.put_line(FND_FILE.LOG,'Validating Document...');
290:
291: IF X_company_use IS NOT null THEN
292: BEGIN
293:

Line 326: fnd_file.put_line(FND_FILE.LOG,'x_payment_schedule_id : ' || x_payment_schedule_id);

322: --And HzPartyBank.Country = 'BR'
323: And doc.document_id = X_company_use;
324: --End of CE uptake
325:
326: fnd_file.put_line(FND_FILE.LOG,'x_payment_schedule_id : ' || x_payment_schedule_id);
327: fnd_file.put_line(FND_FILE.LOG,'x_document_status : ' || x_document_status);
328: fnd_file.put_line(FND_FILE.LOG,'x_remittance_bank_id : ' || x_remittance_bank_id);
329:
330:

Line 327: fnd_file.put_line(FND_FILE.LOG,'x_document_status : ' || x_document_status);

323: And doc.document_id = X_company_use;
324: --End of CE uptake
325:
326: fnd_file.put_line(FND_FILE.LOG,'x_payment_schedule_id : ' || x_payment_schedule_id);
327: fnd_file.put_line(FND_FILE.LOG,'x_document_status : ' || x_document_status);
328: fnd_file.put_line(FND_FILE.LOG,'x_remittance_bank_id : ' || x_remittance_bank_id);
329:
330:
331: EXCEPTION

Line 328: fnd_file.put_line(FND_FILE.LOG,'x_remittance_bank_id : ' || x_remittance_bank_id);

324: --End of CE uptake
325:
326: fnd_file.put_line(FND_FILE.LOG,'x_payment_schedule_id : ' || x_payment_schedule_id);
327: fnd_file.put_line(FND_FILE.LOG,'x_document_status : ' || x_document_status);
328: fnd_file.put_line(FND_FILE.LOG,'x_remittance_bank_id : ' || x_remittance_bank_id);
329:
330:
331: EXCEPTION
332: WHEN NO_DATA_FOUND THEN

Line 339: fnd_file.put_line(FND_FILE.LOG,'Validating Trade Note...');

335: WHEN others THEN
336: null;
337: END;
338:
339: fnd_file.put_line(FND_FILE.LOG,'Validating Trade Note...');
340:
341: BEGIN
342: SELECT payment_schedule_id
343: INTO X_payment_schedule_id

Line 402: fnd_file.put_line(FND_FILE.LOG,'X_remittance_bank_id <> p_bank_party_id');

398:
399: -- CE uptake - Bug#2932986
400: IF X_remittance_bank_id <> p_bank_party_id THEN
401: p_error_code := 'INVALID_BANK_NUMBER';
402: fnd_file.put_line(FND_FILE.LOG,'X_remittance_bank_id <> p_bank_party_id');
403: RAISE error_validation;
404: END IF;
405:
406: /****************/

Line 410: fnd_file.put_line(FND_FILE.LOG,'Validating Inscription Number...');

406: /****************/
407: /* Validate CGC */
408: /****************/
409:
410: fnd_file.put_line(FND_FILE.LOG,'Validating Inscription Number...');
411:
412: BEGIN
413:
414: ----------------------------------------------------------------------

Line 431: fnd_file.put_line(FND_FILE.LOG,'Legder Id : ' || l_ledger_id);

427: INTO l_ledger_id,
428: l_acct_balancing_segment
429: FROM ar_system_parameters;
430:
431: fnd_file.put_line(FND_FILE.LOG,'Legder Id : ' || l_ledger_id);
432: fnd_file.put_line(FND_FILE.LOG,'Balancing Segment : ' || l_acct_balancing_segment);
433:
434: ------------------------------------------------------------
435: -- Proceed to retrieve the Ledger Information which contains

Line 432: fnd_file.put_line(FND_FILE.LOG,'Balancing Segment : ' || l_acct_balancing_segment);

428: l_acct_balancing_segment
429: FROM ar_system_parameters;
430:
431: fnd_file.put_line(FND_FILE.LOG,'Legder Id : ' || l_ledger_id);
432: fnd_file.put_line(FND_FILE.LOG,'Balancing Segment : ' || l_acct_balancing_segment);
433:
434: ------------------------------------------------------------
435: -- Proceed to retrieve the Ledger Information which contains
436: -- the Legal Entity Id as well

Line 483: fnd_file.put_line(FND_FILE.LOG,'Called From JLBRRVFD');

479: And bsv.entity_name = l_acct_balancing_segment
480: And gl.ledger_id = l_ledger_id; */
481:
482: IF p_called_from = 'JLBRRVFD' then
483: fnd_file.put_line(FND_FILE.LOG,'Called From JLBRRVFD');
484:
485: -- Called from program Brazilian Receivables Import of Bank Return Program(JLBRRVFD.sql)
486:
487: For Comp_JLBRRVFD_Rec in Comp_JLBRRVFD ( l_ledger_id

Line 492: fnd_file.put_line(FND_FILE.LOG,'in the Comp_JLBRRVFD Cursor');

488: ,l_acct_balancing_segment
489: ,p_file_control
490: ,p_ent_seq_num )
491: Loop
492: fnd_file.put_line(FND_FILE.LOG,'in the Comp_JLBRRVFD Cursor');
493: fnd_file.put_line(FND_FILE.LOG,'Registration Number Fetched : ' || Comp_JLBRRVFD_Rec.registration_number);
494: x_cgc := Comp_JLBRRVFD_Rec.registration_number;
495: End Loop;
496:

Line 493: fnd_file.put_line(FND_FILE.LOG,'Registration Number Fetched : ' || Comp_JLBRRVFD_Rec.registration_number);

489: ,p_file_control
490: ,p_ent_seq_num )
491: Loop
492: fnd_file.put_line(FND_FILE.LOG,'in the Comp_JLBRRVFD Cursor');
493: fnd_file.put_line(FND_FILE.LOG,'Registration Number Fetched : ' || Comp_JLBRRVFD_Rec.registration_number);
494: x_cgc := Comp_JLBRRVFD_Rec.registration_number;
495: End Loop;
496:
497: ELSE

Line 506: fnd_file.put_line(FND_FILE.LOG,'in the Comp_JLBRRCDB Cursor');

502: ,l_acct_balancing_segment
503: ,p_file_control
504: ,p_ent_seq_num )
505: Loop
506: fnd_file.put_line(FND_FILE.LOG,'in the Comp_JLBRRCDB Cursor');
507: fnd_file.put_line(FND_FILE.LOG,'Registration Number is : ' || Comp_JLBRRCDB_Rec.registration_number);
508: x_cgc := Comp_JLBRRCDB_Rec.registration_number;
509: End Loop;
510:

Line 507: fnd_file.put_line(FND_FILE.LOG,'Registration Number is : ' || Comp_JLBRRCDB_Rec.registration_number);

503: ,p_file_control
504: ,p_ent_seq_num )
505: Loop
506: fnd_file.put_line(FND_FILE.LOG,'in the Comp_JLBRRCDB Cursor');
507: fnd_file.put_line(FND_FILE.LOG,'Registration Number is : ' || Comp_JLBRRCDB_Rec.registration_number);
508: x_cgc := Comp_JLBRRCDB_Rec.registration_number;
509: End Loop;
510:
511: END IF;

Line 530: fnd_file.put_line(FND_FILE.LOG,'Comapring value of X_cgc variable ' || X_cgc);

526: AND trx.customer_trx_id = pay.customer_trx_id
527: AND adr.cust_acct_site_id = trx.remit_to_address_id
528: AND inf.accounting_balancing_segment = adr.global_attribute1
529: AND inf.set_of_books_id = trx.set_of_books_id; */
530: fnd_file.put_line(FND_FILE.LOG,'Comapring value of X_cgc variable ' || X_cgc);
531: fnd_file.put_line(FND_FILE.LOG,'Comparing value of X_inscription_number ' || X_inscription_number);
532: IF nvl(X_cgc,0) <> X_inscription_number THEN
533: p_error_code := 'INVALID_COMPANY_INSCRIPT_NUM';
534: fnd_file.put_line(FND_FILE.LOG,'Raising exception since the values are not matching');

Line 531: fnd_file.put_line(FND_FILE.LOG,'Comparing value of X_inscription_number ' || X_inscription_number);

527: AND adr.cust_acct_site_id = trx.remit_to_address_id
528: AND inf.accounting_balancing_segment = adr.global_attribute1
529: AND inf.set_of_books_id = trx.set_of_books_id; */
530: fnd_file.put_line(FND_FILE.LOG,'Comapring value of X_cgc variable ' || X_cgc);
531: fnd_file.put_line(FND_FILE.LOG,'Comparing value of X_inscription_number ' || X_inscription_number);
532: IF nvl(X_cgc,0) <> X_inscription_number THEN
533: p_error_code := 'INVALID_COMPANY_INSCRIPT_NUM';
534: fnd_file.put_line(FND_FILE.LOG,'Raising exception since the values are not matching');
535: RAISE error_validation;

Line 534: fnd_file.put_line(FND_FILE.LOG,'Raising exception since the values are not matching');

530: fnd_file.put_line(FND_FILE.LOG,'Comapring value of X_cgc variable ' || X_cgc);
531: fnd_file.put_line(FND_FILE.LOG,'Comparing value of X_inscription_number ' || X_inscription_number);
532: IF nvl(X_cgc,0) <> X_inscription_number THEN
533: p_error_code := 'INVALID_COMPANY_INSCRIPT_NUM';
534: fnd_file.put_line(FND_FILE.LOG,'Raising exception since the values are not matching');
535: RAISE error_validation;
536: END IF;
537:
538: EXCEPTION