207: IF PG_DEBUG in ('Y','C') THEN
208: arp_standard.debug( 'converting the parameters');
209: END IF;
210:
211: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
212: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
213: l_receipt_class_id := to_number(p_receipt_class_id);
214: l_receipt_method_id := to_number(p_payment_method_id);
215: l_currency_code := p_batch_currency;
208: arp_standard.debug( 'converting the parameters');
209: END IF;
210:
211: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
212: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
213: l_receipt_class_id := to_number(p_receipt_class_id);
214: l_receipt_method_id := to_number(p_payment_method_id);
215: l_currency_code := p_batch_currency;
216: l_create_flag := p_create_flag;
296: arp_standard.debug( ' the error here is ' || SQLERRM );
297: END IF;
298:
299: select_valid_invoices
300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
301: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
302: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
303: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
304: p_trx_num_l =>p_trx_num_l,
297: END IF;
298:
299: select_valid_invoices
300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
301: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
302: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
303: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
304: p_trx_num_l =>p_trx_num_l,
305: p_trx_num_h => p_trx_num_h,
298:
299: select_valid_invoices
300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
301: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
302: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
303: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
304: p_trx_num_l =>p_trx_num_l,
305: p_trx_num_h => p_trx_num_h,
306: p_doc_num_l =>p_doc_num_l,
299: select_valid_invoices
300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
301: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
302: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
303: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
304: p_trx_num_l =>p_trx_num_l,
305: p_trx_num_h => p_trx_num_h,
306: p_doc_num_l =>p_doc_num_l,
307: p_doc_num_h => p_doc_num_h,
366: arp_standard.debug( ' the error here is ' || SQLERRM );
367: END IF;
368:
369: select_valid_invoices
370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
371: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
372: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
373: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
374: p_trx_num_l =>p_trx_num_l,
367: END IF;
368:
369: select_valid_invoices
370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
371: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
372: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
373: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
374: p_trx_num_l =>p_trx_num_l,
375: p_trx_num_h => p_trx_num_h,
368:
369: select_valid_invoices
370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
371: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
372: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
373: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
374: p_trx_num_l =>p_trx_num_l,
375: p_trx_num_h => p_trx_num_h,
376: p_doc_num_l =>p_doc_num_l,
369: select_valid_invoices
370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
371: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
372: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
373: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
374: p_trx_num_l =>p_trx_num_l,
375: p_trx_num_h => p_trx_num_h,
376: p_doc_num_l =>p_doc_num_l,
377: p_doc_num_h => p_doc_num_h,
422: arp_standard.debug( ' the error here is ' || SQLERRM );
423: END IF;
424:
425: select_valid_invoices
426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
427: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
428: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
429: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
430: p_trx_num_l =>p_trx_num_l,
423: END IF;
424:
425: select_valid_invoices
426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
427: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
428: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
429: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
430: p_trx_num_l =>p_trx_num_l,
431: p_trx_num_h => p_trx_num_h,
424:
425: select_valid_invoices
426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
427: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
428: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
429: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
430: p_trx_num_l =>p_trx_num_l,
431: p_trx_num_h => p_trx_num_h,
432: p_doc_num_l =>p_doc_num_l,
425: select_valid_invoices
426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
427: p_trx_date_h =>fnd_date.canonical_to_date(p_trx_date_h),
428: p_due_date_l =>fnd_date.canonical_to_date(p_due_date_l),
429: p_due_date_h =>fnd_date.canonical_to_date(p_due_date_h),
430: p_trx_num_l =>p_trx_num_l,
431: p_trx_num_h => p_trx_num_h,
432: p_doc_num_l =>p_doc_num_l,
433: p_doc_num_h => p_doc_num_h,