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.AR_GTA_CONC_PROG dependencies on AR_GTA_TRX_UTIL

Line 137: l_parameters ar_gta_trx_util.transferparas_rec_type;

133: ,p_doc_num_from IN NUMBER
134: ,p_doc_num_to IN NUMBER
135: ) IS
136: l_procedure_name VARCHAR2(50) := 'transfer_AR_to_GTA';
137: l_parameters ar_gta_trx_util.transferparas_rec_type;
138: l_ar_gta_gta_not_enabled VARCHAR2(4000);
139: l_conc_succ BOOLEAN;
140: l_errbuf VARCHAR2(4000);
141: l_retcode VARCHAR2(4000);

Line 334: ,xmlforest(ar_gta_trx_util.get_operatingunit(l_org_id) AS

330: l_gta_line_count := 0;
331: l_gt_line_count := 0;
332:
333: SELECT xmlelement("Parameters"
334: ,xmlforest(ar_gta_trx_util.get_operatingunit(l_org_id) AS
335: "OperationUnit"
336: ,p_customer_name AS
337: "ARCustomerName"
338: ,ar_gta_trx_util.To_Xsd_Date_String(l_gl_date_from) AS

Line 338: ,ar_gta_trx_util.To_Xsd_Date_String(l_gl_date_from) AS

334: ,xmlforest(ar_gta_trx_util.get_operatingunit(l_org_id) AS
335: "OperationUnit"
336: ,p_customer_name AS
337: "ARCustomerName"
338: ,ar_gta_trx_util.To_Xsd_Date_String(l_gl_date_from) AS
339: "ARTrxGLDateFrom"
340: ,ar_gta_trx_util.To_Xsd_Date_String(l_gl_date_to) AS
341: "ARTrxGLDateTo"))
342: INTO l_parameter

Line 340: ,ar_gta_trx_util.To_Xsd_Date_String(l_gl_date_to) AS

336: ,p_customer_name AS
337: "ARCustomerName"
338: ,ar_gta_trx_util.To_Xsd_Date_String(l_gl_date_from) AS
339: "ARTrxGLDateFrom"
340: ,ar_gta_trx_util.To_Xsd_Date_String(l_gl_date_to) AS
341: "ARTrxGLDateTo"))
342: INTO l_parameter
343: FROM dual;
344:

Line 362: ,ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))

358: ,'Y')
359: ,xmlelement("FailedWithParameters"
360: ,'N')
361: ,xmlelement("RepDate"
362: ,ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
363: ,xmlelement("ReportFailedMsg"
364: ,l_ar_gta_gta_not_enabled)
365: ,l_parameter))
366: INTO l_report

Line 369: ar_gta_trx_util.output_conc(l_report.getclobval());

365: ,l_parameter))
366: INTO l_report
367: FROM dual;
368:
369: ar_gta_trx_util.output_conc(l_report.getclobval());
370: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
371: ,message => l_ar_gta_gta_not_enabled);
372: RETURN;
373: END IF; /*IF NVL(l_ar_gta_enabled,'N')<>'Y'*/

Line 396: ar_gta_trx_util.delete_header_line_cascade(p_gta_trx_header_id => l_gta_trx_header_id);

392: WHERE gta_trx_header_id = l_gta_trx_header_id;
393:
394: -- delete GTA and gt invoices inclunding headers and lines
395: -- according to GTA_TRX_HEADER_ID
396: ar_gta_trx_util.delete_header_line_cascade(p_gta_trx_header_id => l_gta_trx_header_id);
397:
398: IF l_source = 'AR' --count deleted GTA transaction headers and lines
399: THEN
400: l_gta_header_count := l_gta_header_count + 1;

Line 433: ,ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))

429: ,'N')
430: ,xmlelement("FailedWithParameters"
431: ,'N')
432: ,xmlelement("RepDate"
433: ,ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
434: ,l_parameter
435: ,l_summary))
436: INTO l_report
437: FROM dual;

Line 439: ar_gta_trx_util.output_conc(l_report.getclobval());

435: ,l_summary))
436: INTO l_report
437: FROM dual;
438:
439: ar_gta_trx_util.output_conc(l_report.getclobval());
440:
441: --logging for debug
442: IF (l_proc_level >= l_dbg_level)
443: THEN

Line 548: ,xmlforest(ar_gta_trx_util.get_operatingunit(l_org_id)

544: IF nvl(l_ar_gta_enabled
545: ,'N') = 'N'
546: THEN
547: SELECT xmlelement("Parameters"
548: ,xmlforest(ar_gta_trx_util.get_operatingunit(l_org_id)
549: AS "OperationUnit"
550: ,p_fp_tax_reg_num
551: AS "TaxRegistrationNumber"
552: ,ar_gta_trx_util.Get_AR_Batch_Source_Name

Line 552: ,ar_gta_trx_util.Get_AR_Batch_Source_Name

548: ,xmlforest(ar_gta_trx_util.get_operatingunit(l_org_id)
549: AS "OperationUnit"
550: ,p_fp_tax_reg_num
551: AS "TaxRegistrationNumber"
552: ,ar_gta_trx_util.Get_AR_Batch_Source_Name
553: ( l_org_id
554: , p_trx_source)
555: AS "TransactionSource"
556: ,ar_gta_trx_util.get_customer_name(p_customer_id)

Line 556: ,ar_gta_trx_util.get_customer_name(p_customer_id)

552: ,ar_gta_trx_util.Get_AR_Batch_Source_Name
553: ( l_org_id
554: , p_trx_source)
555: AS "TransactionSource"
556: ,ar_gta_trx_util.get_customer_name(p_customer_id)
557: AS "ARCustomerName"
558: ,p_gt_inv_num_from
559: AS "GTInvoiceNumFrom"
560: ,p_gt_inv_num_to

Line 562: ,ar_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_from)

558: ,p_gt_inv_num_from
559: AS "GTInvoiceNumFrom"
560: ,p_gt_inv_num_to
561: AS "GTInvoiceNumTo"
562: ,ar_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_from)
563: AS "GTDateFrom"
564: ,ar_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_to)
565: AS "GTDateTo"
566: ,p_ar_inv_num_from

Line 564: ,ar_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_to)

560: ,p_gt_inv_num_to
561: AS "GTInvoiceNumTo"
562: ,ar_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_from)
563: AS "GTDateFrom"
564: ,ar_gta_trx_util.To_Xsd_Date_String(l_gt_inv_date_to)
565: AS "GTDateTo"
566: ,p_ar_inv_num_from
567: AS "ARTrxNumberFrom"
568: ,p_ar_inv_num_to

Line 570: ,ar_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_from)

566: ,p_ar_inv_num_from
567: AS "ARTrxNumberFrom"
568: ,p_ar_inv_num_to
569: AS "ARTrxNumberTo"
570: ,ar_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_from)
571: AS "ARTrxDateFrom"
572: ,ar_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_to)
573: AS "ARTrxDateTo"))
574: INTO l_parameter

Line 572: ,ar_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_to)

568: ,p_ar_inv_num_to
569: AS "ARTrxNumberTo"
570: ,ar_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_from)
571: AS "ARTrxDateFrom"
572: ,ar_gta_trx_util.To_Xsd_Date_String(l_ar_inv_date_to)
573: AS "ARTrxDateTo"))
574: INTO l_parameter
575: FROM dual;
576:

Line 588: ,ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))

584: ,'Y')
585: ,xmlelement("FailedWithParameters"
586: ,'N')
587: ,xmlelement("RepDate"
588: ,ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
589: ,xmlelement("ReportFailedMsg"
590: ,l_ar_gta_gta_not_enabled)
591: ,l_parameter))
592: INTO l_report

Line 595: ar_gta_trx_util.output_conc(l_report.getclobval());

591: ,l_parameter))
592: INTO l_report
593: FROM dual;
594:
595: ar_gta_trx_util.output_conc(l_report.getclobval());
596: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
597: ,message => l_ar_gta_gta_not_enabled);
598: ELSE
599: NULL;

Line 1536: l_consol_paras ar_gta_trx_util.consolparas_rec_type;

1532: IS
1533: l_procedure_name VARCHAR2(30):='Consolidate_Invoices';
1534: l_ar_gta_gta_not_enabled Varchar2(200);
1535: l_conc_succ BOOLEAN;
1536: l_consol_paras ar_gta_trx_util.consolparas_rec_type;
1537:
1538:
1539: BEGIN
1540: fnd_file.PUT_LINE(fnd_file.LOG,'Begin Procedure.'||l_procedure_name);

Line 1670: ,xmlforest(ar_gta_trx_util.get_operatingunit(l_org_id)

1666: IF NVL(l_ar_gta_enabled ,'N') = 'N'
1667: THEN
1668: /* commented by Allen Yang 02-Sep-2009 for bug 8848798
1669: SELECT xmlelement("Parameters"
1670: ,xmlforest(ar_gta_trx_util.get_operatingunit(l_org_id)
1671: AS "OperationUnit"
1672: , p_gl_period AS "GLPeriod"
1673: , p_customer_num_from AS "CustomerNumFrom"
1674: , p_customer_num_to AS "CustomerNumTo"

Line 1692: ,xmlelement("RepDate",ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))

1688: -- Output the context of l_ar_gta_gta_not_enabled
1689: SELECT xmlelement("MappingReport"
1690: ,xmlconcat(xmlelement("ReportFailed", 'Y')
1691: ,xmlelement("FailedWithParameters",'N')
1692: ,xmlelement("RepDate",ar_gta_trx_util.To_Xsd_Date_String(SYSDATE))
1693: ,xmlelement("ReportFailedMsg",l_ar_gta_gta_not_enabled)
1694: ,l_parameter))
1695: INTO l_report
1696: FROM dual;

Line 1698: ar_gta_trx_util.output_conc(l_report.getclobval());

1694: ,l_parameter))
1695: INTO l_report
1696: FROM dual;
1697:
1698: ar_gta_trx_util.output_conc(l_report.getclobval());
1699: */
1700: l_ar_gta_gta_not_enabled := '
1701: Y
1702: Y

Line 1807: ar_gta_trx_util.Populate_Invoice_Type(l_org_id);

1803:
1804: RETURN;
1805: END IF;
1806:
1807: ar_gta_trx_util.Populate_Invoice_Type(l_org_id);
1808:
1809: --procedure end
1810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1811: THEN

Line 1892: ar_gta_trx_util.Populate_Invoice_Type_Header(l_org_id);

1888:
1889: RETURN;
1890: END IF;
1891:
1892: ar_gta_trx_util.Populate_Invoice_Type_Header(l_org_id);
1893:
1894: --procedure end
1895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1896: THEN