157: l_parameters.customer_num_to := p_customer_num_to;
158: l_parameters.customer_name_from := p_customer_name_from;
159: l_parameters.customer_name_to := p_customer_name_to;
160: l_parameters.gl_period := p_gl_period;
161: l_parameters.gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
162: l_parameters.gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
163: l_parameters.trx_batch_from := p_trx_batch_from;
164: l_parameters.trx_batch_to := p_trx_batch_to;
165: l_parameters.trx_number_from := p_trx_number_from;
158: l_parameters.customer_name_from := p_customer_name_from;
159: l_parameters.customer_name_to := p_customer_name_to;
160: l_parameters.gl_period := p_gl_period;
161: l_parameters.gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
162: l_parameters.gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
163: l_parameters.trx_batch_from := p_trx_batch_from;
164: l_parameters.trx_batch_to := p_trx_batch_to;
165: l_parameters.trx_number_from := p_trx_number_from;
166: l_parameters.trx_number_to := p_trx_number_to;
163: l_parameters.trx_batch_from := p_trx_batch_from;
164: l_parameters.trx_batch_to := p_trx_batch_to;
165: l_parameters.trx_number_from := p_trx_number_from;
166: l_parameters.trx_number_to := p_trx_number_to;
167: l_parameters.trx_date_from := fnd_date.canonical_to_date(p_trx_date_from);
168: l_parameters.trx_date_to := fnd_date.canonical_to_date(p_trx_date_to);
169: l_parameters.doc_num_from := p_doc_num_from;
170: l_parameters.doc_num_to := p_doc_num_to;
171:
164: l_parameters.trx_batch_to := p_trx_batch_to;
165: l_parameters.trx_number_from := p_trx_number_from;
166: l_parameters.trx_number_to := p_trx_number_to;
167: l_parameters.trx_date_from := fnd_date.canonical_to_date(p_trx_date_from);
168: l_parameters.trx_date_to := fnd_date.canonical_to_date(p_trx_date_to);
169: l_parameters.doc_num_from := p_doc_num_from;
170: l_parameters.doc_num_to := p_doc_num_to;
171:
172: -- call AR_GTA_ARTRX_PROC_JIM.transfer_AR_to_GTA
322: ,'enter procedure');
323: END IF; /*IF (l_proc_level>=l_dbg_level)*/
324:
325: -- Data conversion
326: l_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
327: l_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
328: l_gta_header_count := 0;
329: l_gt_header_count := 0;
330: l_gta_line_count := 0;
323: END IF; /*IF (l_proc_level>=l_dbg_level)*/
324:
325: -- Data conversion
326: l_gl_date_from := fnd_date.canonical_to_date(p_gl_date_from);
327: l_gl_date_to := fnd_date.canonical_to_date(p_gl_date_to);
328: l_gta_header_count := 0;
329: l_gt_header_count := 0;
330: l_gta_line_count := 0;
331: l_gt_line_count := 0;
533: ,g_module_prefix || l_procedure_name || '.begin'
534: ,'enter procedure');
535: END IF;
536:
537: l_gt_inv_date_from := fnd_date.canonical_to_date(p_gt_inv_date_from);
538: l_gt_inv_date_to := fnd_date.canonical_to_date(p_gt_inv_date_to);
539: l_ar_inv_date_from := fnd_date.canonical_to_date(p_ar_inv_date_from);
540: l_ar_inv_date_to := fnd_date.canonical_to_date(p_ar_inv_date_to);
541:
534: ,'enter procedure');
535: END IF;
536:
537: l_gt_inv_date_from := fnd_date.canonical_to_date(p_gt_inv_date_from);
538: l_gt_inv_date_to := fnd_date.canonical_to_date(p_gt_inv_date_to);
539: l_ar_inv_date_from := fnd_date.canonical_to_date(p_ar_inv_date_from);
540: l_ar_inv_date_to := fnd_date.canonical_to_date(p_ar_inv_date_to);
541:
542: fnd_profile.get('AR_GTA_ENABLED'
535: END IF;
536:
537: l_gt_inv_date_from := fnd_date.canonical_to_date(p_gt_inv_date_from);
538: l_gt_inv_date_to := fnd_date.canonical_to_date(p_gt_inv_date_to);
539: l_ar_inv_date_from := fnd_date.canonical_to_date(p_ar_inv_date_from);
540: l_ar_inv_date_to := fnd_date.canonical_to_date(p_ar_inv_date_to);
541:
542: fnd_profile.get('AR_GTA_ENABLED'
543: ,l_ar_gta_enabled);
536:
537: l_gt_inv_date_from := fnd_date.canonical_to_date(p_gt_inv_date_from);
538: l_gt_inv_date_to := fnd_date.canonical_to_date(p_gt_inv_date_to);
539: l_ar_inv_date_from := fnd_date.canonical_to_date(p_ar_inv_date_from);
540: l_ar_inv_date_to := fnd_date.canonical_to_date(p_ar_inv_date_to);
541:
542: fnd_profile.get('AR_GTA_ENABLED'
543: ,l_ar_gta_enabled);
544: IF nvl(l_ar_gta_enabled
834: ,message => l_ar_gta_gta_not_enabled);
835: RETURN;
836: END IF;
837:
838: l_ar_trx_date_from := fnd_date.canonical_to_date(p_ar_trx_date_from);
839: l_ar_trx_date_to := fnd_date.canonical_to_date(p_ar_trx_date_to);
840: l_ar_trx_gl_date_from := fnd_date.canonical_to_date(p_ar_trx_gl_date_from);
841: l_ar_trx_gl_date_to := fnd_date.canonical_to_date(p_ar_trx_gl_date_to);
842:
835: RETURN;
836: END IF;
837:
838: l_ar_trx_date_from := fnd_date.canonical_to_date(p_ar_trx_date_from);
839: l_ar_trx_date_to := fnd_date.canonical_to_date(p_ar_trx_date_to);
840: l_ar_trx_gl_date_from := fnd_date.canonical_to_date(p_ar_trx_gl_date_from);
841: l_ar_trx_gl_date_to := fnd_date.canonical_to_date(p_ar_trx_gl_date_to);
842:
843: l_org_id := mo_global.get_current_org_id;
836: END IF;
837:
838: l_ar_trx_date_from := fnd_date.canonical_to_date(p_ar_trx_date_from);
839: l_ar_trx_date_to := fnd_date.canonical_to_date(p_ar_trx_date_to);
840: l_ar_trx_gl_date_from := fnd_date.canonical_to_date(p_ar_trx_gl_date_from);
841: l_ar_trx_gl_date_to := fnd_date.canonical_to_date(p_ar_trx_gl_date_to);
842:
843: l_org_id := mo_global.get_current_org_id;
844:
837:
838: l_ar_trx_date_from := fnd_date.canonical_to_date(p_ar_trx_date_from);
839: l_ar_trx_date_to := fnd_date.canonical_to_date(p_ar_trx_date_to);
840: l_ar_trx_gl_date_from := fnd_date.canonical_to_date(p_ar_trx_gl_date_from);
841: l_ar_trx_gl_date_to := fnd_date.canonical_to_date(p_ar_trx_gl_date_to);
842:
843: l_org_id := mo_global.get_current_org_id;
844:
845: AR_GTA_TXT_OPERATOR_PROC.Export_Invoices_From_Conc(p_org_id => l_org_id
1461: ,p_customer_num_to => p_customer_num_to
1462: ,p_customer_name_from => p_customer_name_from
1463: ,p_customer_name_to => p_customer_name_to
1464: --,p_taxpayee_id => p_taxpayee_id
1465: ,p_creation_date_from => fnd_date.canonical_to_date(p_creation_date_from)
1466: ,p_creation_date_to => fnd_date.canonical_to_date(p_creation_date_to));
1467:
1468: ELSE
1469: /*FND_PROFILE.VALUE('GTA_ENABLED')='Y'*/
1462: ,p_customer_name_from => p_customer_name_from
1463: ,p_customer_name_to => p_customer_name_to
1464: --,p_taxpayee_id => p_taxpayee_id
1465: ,p_creation_date_from => fnd_date.canonical_to_date(p_creation_date_from)
1466: ,p_creation_date_to => fnd_date.canonical_to_date(p_creation_date_to));
1467:
1468: ELSE
1469: /*FND_PROFILE.VALUE('GTA_ENABLED')='Y'*/
1470: -- report AR_GTA_DISABLE_ERROR in xml format