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.JMF_GTA_REPORTS_PKG dependencies on JMF_GTA_TRX_UTIL

Line 210: IF Jmf_Gta_Trx_Util.Check_Taxcount_Of_Artrx(P_Org_Id, p_ar_trx_header_id)

206: , G_MODULE_PREFIX||l_procedure_name||'.begin'
207: , 'enter function'
208: );
209: END IF;
210: IF Jmf_Gta_Trx_Util.Check_Taxcount_Of_Artrx(P_Org_Id, p_ar_trx_header_id)
211: THEN
212:
213: SELECT Xmlforest(
214: ract.Trx_Number AS "ARInvoiceNo"

Line 225: ,jmf_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"

221: , P_Gt_Inv_Num_To
222: ) AS "Split"
223: ,bat.name AS "ARSource"
224: ,CTT.TYPE AS "ARClass"
225: ,jmf_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"
226: ,RAC_BILL_PARTY.PARTY_NAME AS "ARCustomer"
227: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Amount
228: ( P_Org_Id
229: , ract.Customer_Trx_Id

Line 227: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Amount

223: ,bat.name AS "ARSource"
224: ,CTT.TYPE AS "ARClass"
225: ,jmf_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"
226: ,RAC_BILL_PARTY.PARTY_NAME AS "ARCustomer"
227: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Amount
228: ( P_Org_Id
229: , ract.Customer_Trx_Id
230: ) AS "ARAmount"
231: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Tax_Amount

Line 231: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Tax_Amount

227: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Amount
228: ( P_Org_Id
229: , ract.Customer_Trx_Id
230: ) AS "ARAmount"
231: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Tax_Amount
232: ( P_Org_Id
233: , ract.Customer_Trx_Id
234: ) AS "ARTaxAmount"
235: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Amount

Line 235: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Amount

231: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Tax_Amount
232: ( P_Org_Id
233: , ract.Customer_Trx_Id
234: ) AS "ARTaxAmount"
235: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Amount
236: ( P_Org_Id
237: , ract.Customer_Trx_Id
238: )
239: +Jmf_Gta_Trx_Util.Get_Arinvoice_Tax_Amount

Line 239: +Jmf_Gta_Trx_Util.Get_Arinvoice_Tax_Amount

235: ,Jmf_Gta_Trx_Util.Get_Arinvoice_Amount
236: ( P_Org_Id
237: , ract.Customer_Trx_Id
238: )
239: +Jmf_Gta_Trx_Util.Get_Arinvoice_Tax_Amount
240: ( P_Org_Id
241: , ract.Customer_Trx_Id
242: ) AS "ARTotalAmount"
243: )

Line 272: ,jmf_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"

268: , P_Gt_Inv_Num_To
269: ) AS "Split"
270: ,bat.name AS "ARSource"
271: ,CTT.TYPE AS "ARClass"
272: ,jmf_gta_trx_util.To_Xsd_Date_String(ract.Trx_Date) AS "ARDate"
273: ,RAC_BILL_PARTY.PARTY_NAME AS "ARCustomer"
274: ,'' AS "ARAmount"
275: ,'' AS "ARTaxAmount"
276: ,'' AS "ARTotalAmount"

Line 393: , jmf_gta_trx_util.To_Xsd_Date_String(Gt_Invoice_Date) AS "Date"

389: SELECT Xmlelement("GTInvoices",
390: Xmlconcat(Xmlelement("Count",l_count)
391: , Xmlagg(Xmlelement("GTInvoice",Xmlforest
392: ( Gt_Invoice_Number AS "InvoiceNo"
393: , jmf_gta_trx_util.To_Xsd_Date_String(Gt_Invoice_Date) AS "Date"
394: , Bill_To_Customer_Name AS "Customer"
395: , Gt_Invoice_Net_Amount AS "Amount"
396: , Gt_Invoice_Tax_Amount AS "TaxAmount"
397: , Gt_Invoice_Net_Amount + Gt_Invoice_Tax_Amount AS "TotalAmount"

Line 647: ( jmf_gta_trx_util.Get_OperatingUnit(P_Org_Id) AS "OperationUnit"

643:
644: --Generate Parameter Section
645: SELECT
646: Xmlelement("Parameters",Xmlforest
647: ( jmf_gta_trx_util.Get_OperatingUnit(P_Org_Id) AS "OperationUnit"
648: , p_fp_tax_reg_num AS "TaxRegistrationNumber"
649: , jmf_gta_trx_util.Get_AR_Batch_Source_Name
650: ( P_Org_Id
651: , P_Trx_Source) AS "TransactionSource"

Line 649: , jmf_gta_trx_util.Get_AR_Batch_Source_Name

645: SELECT
646: Xmlelement("Parameters",Xmlforest
647: ( jmf_gta_trx_util.Get_OperatingUnit(P_Org_Id) AS "OperationUnit"
648: , p_fp_tax_reg_num AS "TaxRegistrationNumber"
649: , jmf_gta_trx_util.Get_AR_Batch_Source_Name
650: ( P_Org_Id
651: , P_Trx_Source) AS "TransactionSource"
652: , jmf_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"
653: , P_Gt_Inv_Num_From AS "GTInvoiceNumFrom"

Line 652: , jmf_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"

648: , p_fp_tax_reg_num AS "TaxRegistrationNumber"
649: , jmf_gta_trx_util.Get_AR_Batch_Source_Name
650: ( P_Org_Id
651: , P_Trx_Source) AS "TransactionSource"
652: , jmf_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"
653: , P_Gt_Inv_Num_From AS "GTInvoiceNumFrom"
654: , P_Gt_Inv_Num_To AS "GTInvoiceNumTo"
655: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"
656: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"

Line 655: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"

651: , P_Trx_Source) AS "TransactionSource"
652: , jmf_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"
653: , P_Gt_Inv_Num_From AS "GTInvoiceNumFrom"
654: , P_Gt_Inv_Num_To AS "GTInvoiceNumTo"
655: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"
656: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"
657: , P_Ar_Inv_Num_From AS "ARTrxNumberFrom"
658: , P_Ar_Inv_Num_To AS "ARTrxNumberTo"
659: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"

Line 656: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"

652: , jmf_gta_trx_util.Get_Customer_Name(P_Customer_Id) AS "ARCustomerName"
653: , P_Gt_Inv_Num_From AS "GTInvoiceNumFrom"
654: , P_Gt_Inv_Num_To AS "GTInvoiceNumTo"
655: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"
656: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"
657: , P_Ar_Inv_Num_From AS "ARTrxNumberFrom"
658: , P_Ar_Inv_Num_To AS "ARTrxNumberTo"
659: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"
660: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))

Line 659: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"

655: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_From) AS "GTDateFrom"
656: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"
657: , P_Ar_Inv_Num_From AS "ARTrxNumberFrom"
658: , P_Ar_Inv_Num_To AS "ARTrxNumberTo"
659: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"
660: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))
661: INTO
662: l_Parameter
663: FROM DUAL;

Line 660: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))

656: , jmf_gta_trx_util.To_Xsd_Date_String(P_Gt_Inv_Date_To) AS "GTDateTo"
657: , P_Ar_Inv_Num_From AS "ARTrxNumberFrom"
658: , P_Ar_Inv_Num_To AS "ARTrxNumberTo"
659: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_From) AS "ARTrxDateFrom"
660: , jmf_gta_trx_util.To_Xsd_Date_String(P_Ar_Inv_Date_TO) AS "ARTrxDateTo"))
661: INTO
662: l_Parameter
663: FROM DUAL;
664:

Line 699: , Xmlelement("RepDate",jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))

695: SELECT Xmlelement( "MappingReport", Xmlconcat
696: ( Xmlelement("ReportFailed",'N')
697: , Xmlelement("FailedWithParameters",'Y')
698: , Xmlelement("FailedMsgWithParameters",l_no_data_message)
699: , Xmlelement("RepDate",jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))
700: , L_Parameter
701: ))
702: INTO
703: L_Report

Line 711: , Xmlelement("RepDate",jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))

707:
708: SELECT Xmlelement( "MappingReport", Xmlconcat
709: ( Xmlelement("ReportFailed",'N')
710: , Xmlelement("FailedWithParameters",'N')
711: , Xmlelement("RepDate",jmf_gta_trx_util.To_Xsd_Date_String(SYSDATE))
712: , L_Parameter
713: , L_Summary
714: , L_gt_currency
715: , xmlelement("Invoices",l_ar_trxs)

Line 723: jmf_gta_trx_util.output_conc(L_Report.Getclobval());

719: FROM
720: DUAL;
721: END IF;
722:
723: jmf_gta_trx_util.output_conc(L_Report.Getclobval());
724:
725: --logging for debug
726: IF (l_proc_level>=l_dbg_level)
727: THEN

Line 867: /*JMF_GTA_TRX_UTIL.Get_Arinvoice_Amount(rct.customer_trx_id

863:
864: CURSOR c_ar_header IS
865: SELECT
866: --commented by Donghai due to ebtax functionality
867: /*JMF_GTA_TRX_UTIL.Get_Arinvoice_Amount(rct.customer_trx_id
868: ,rct.invoice_currency_code
869: ,rct.trx_date
870: ,l_org_id) amount
871: , JMF_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount(rct.customer_trx_id

Line 871: , JMF_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount(rct.customer_trx_id

867: /*JMF_GTA_TRX_UTIL.Get_Arinvoice_Amount(rct.customer_trx_id
868: ,rct.invoice_currency_code
869: ,rct.trx_date
870: ,l_org_id) amount
871: , JMF_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount(rct.customer_trx_id
872: ,rct.invoice_currency_code
873: ,rct.trx_date
874: ,l_org_id) tax_amount*/
875: rct.bill_to_customer_id

Line 920: /*JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)

916:
917: -- Commented by Allen to fix issue #2 in bug 6147067
918: CURSOR c_gta_headers IS
919: SELECT
920: /*JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
921: amount
922: , JMF_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
923: taxamount,
924: */

Line 922: , JMF_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)

918: CURSOR c_gta_headers IS
919: SELECT
920: /*JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
921: amount
922: , JMF_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
923: taxamount,
924: */
925: gta.bill_to_customer_name
926: customer_name

Line 948: JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gt.gta_trx_header_id)

944:
945:
946: CURSOR c_gt_headers IS
947: SELECT
948: JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gt.gta_trx_header_id)
949: amount
950: , JMF_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gt.gta_trx_header_id)
951: taxamount
952: , gt.bill_to_customer_name

Line 950: , JMF_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gt.gta_trx_header_id)

946: CURSOR c_gt_headers IS
947: SELECT
948: JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gt.gta_trx_header_id)
949: amount
950: , JMF_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gt.gta_trx_header_id)
951: taxamount
952: , gt.bill_to_customer_name
953: customer_name
954: , gt.tp_tax_registration_number

Line 975: JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)

971:
972: --This cursor is added by Allen to fix issue #2 in bug 6147067.
973: CURSOR c_gta_amounts IS
974: SELECT
975: JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
976: amount
977: , JMF_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
978: taxamount
979: , gta.gta_trx_number

Line 977: , JMF_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)

973: CURSOR c_gta_amounts IS
974: SELECT
975: JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount(gta.gta_trx_header_id)
976: amount
977: , JMF_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
978: taxamount
979: , gta.gta_trx_number
980: FROM
981: jmf_gta_trx_headers gta

Line 1148: IF JMF_GTA_TRX_UTIL.Check_Taxcount_Of_Artrx

1144: --lines per GT currency code and VAT tax type defined on GTA 'system
1145: --options form.If 'Yes', then will set NULL to the variables, if 'No',
1146: --then return exact taxable amount and tax amount
1147:
1148: IF JMF_GTA_TRX_UTIL.Check_Taxcount_Of_Artrx
1149: (p_org_id => l_org_id
1150: ,p_customer_trx_id => l_ar_header_id
1151: )
1152: THEN

Line 1153: l_ar_amount:=JMF_GTA_TRX_UTIL.Get_Arinvoice_Amount

1149: (p_org_id => l_org_id
1150: ,p_customer_trx_id => l_ar_header_id
1151: )
1152: THEN
1153: l_ar_amount:=JMF_GTA_TRX_UTIL.Get_Arinvoice_Amount
1154: (p_org_id => l_org_id
1155: ,p_customer_trx_id => l_ar_header_id
1156: );
1157:

Line 1158: l_ar_taxamount:=JMF_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount

1154: (p_org_id => l_org_id
1155: ,p_customer_trx_id => l_ar_header_id
1156: );
1157:
1158: l_ar_taxamount:=JMF_GTA_TRX_UTIL.Get_Arinvoice_Tax_Amount
1159: (p_org_id => l_org_id
1160: ,p_customer_trx_id => l_ar_header_id
1161: );
1162: ELSE

Line 1165: END IF; --JMF_GTA_TRX_UTIL.Check_Taxcount_Of_Artrx.....

1161: );
1162: ELSE
1163: l_ar_amount:='';
1164: l_ar_taxamount:='';
1165: END IF; --JMF_GTA_TRX_UTIL.Check_Taxcount_Of_Artrx.....
1166:
1167: --log for debug
1168: IF( l_proc_level >= l_dbg_level)
1169: THEN

Line 1187: JMF_GTA_TRX_UTIL.Get_Bank_Info

1183:
1184:
1185:
1186: --Get Bank account name and number of a specific AR transaction
1187: JMF_GTA_TRX_UTIL.Get_Bank_Info
1188: (p_customer_trx_id => l_ar_header_id
1189: ,p_org_id => l_org_id
1190: ,x_bank_name => l_ar_bank_name
1191: ,x_bank_branch_name => l_ar_branch_name

Line 1199: l_ar_customer_phone:=JMF_GTA_TRX_UTIL.Get_Primary_Phone_Number

1195: l_ar_customer_bank_account:=l_ar_bank_name||' '||
1196: l_ar_branch_name||' '||l_ar_bank_account_num;
1197:
1198:
1199: l_ar_customer_phone:=JMF_GTA_TRX_UTIL.Get_Primary_Phone_Number
1200: (p_customer_id => l_ar_customer_id
1201: );
1202:
1203:

Line 1843: l_amount_discrepancy:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1839: THEN
1840: l_amount_discrepancy:='-';
1841: ELSE
1842: --To compute discrepancy of amount (GT-AR)
1843: l_amount_discrepancy:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1844: ,p_amount => l_gt_amount_sum-l_ar_amount
1845: );
1846: END IF; --l_ar_amount IS NULL
1847:

Line 1849: l_ar_amount_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1845: );
1846: END IF; --l_ar_amount IS NULL
1847:
1848: --Format Amount
1849: l_ar_amount_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1850: ,p_amount => l_ar_amount
1851: );
1852:
1853: l_gta_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

Line 1853: l_gta_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1849: l_ar_amount_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1850: ,p_amount => l_ar_amount
1851: );
1852:
1853: l_gta_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1854: ,p_amount => l_gta_amount_sum
1855: );
1856:
1857: l_gt_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

Line 1857: l_gt_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1853: l_gta_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1854: ,p_amount => l_gta_amount_sum
1855: );
1856:
1857: l_gt_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1858: ,p_amount =>l_gt_amount_sum
1859: );
1860:
1861: --Insert this discrepancy record to temp table jmf_gta_difference_temp

Line 1894: l_taxamount_discrepancy:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1890: THEN
1891: l_taxamount_discrepancy:='-';
1892: ELSE
1893: --To compute discrepancy of tax amount (GT-AR)
1894: l_taxamount_discrepancy:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1895: ,p_amount => l_gt_taxamount_sum-l_ar_taxamount
1896: );
1897: END IF; -- l_ar_taxamount IS NULL
1898:

Line 1900: l_ar_taxamount_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1896: );
1897: END IF; -- l_ar_taxamount IS NULL
1898:
1899: --Format Amount
1900: l_ar_taxamount_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1901: ,p_amount => l_ar_taxamount
1902: );
1903:
1904: l_gta_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

Line 1904: l_gta_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1900: l_ar_taxamount_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1901: ,p_amount => l_ar_taxamount
1902: );
1903:
1904: l_gta_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1905: ,p_amount => l_gta_taxamount_sum
1906: );
1907:
1908: l_gt_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

Line 1908: l_gt_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

1904: l_gta_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1905: ,p_amount => l_gta_taxamount_sum
1906: );
1907:
1908: l_gt_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
1909: ,p_amount => l_gt_taxamount_sum
1910: );
1911:
1912:

Line 2424: IF JMF_GTA_TRX_UTIL.Check_Taxcount_Of_Arline

2420: --type and GT currency code defined on GTA 'system options' form,
2421: --if 'YES', then set NULL to tax registration number,taxable amount,
2422: --tax amount and tax rate, if 'No', then give exact values to tax
2423: --registration number, taxable amount,tax amount and tax rate.
2424: IF JMF_GTA_TRX_UTIL.Check_Taxcount_Of_Arline
2425: (p_org_id => l_org_id
2426: ,p_customer_trx_line_id => l_ar_line_id
2427: )
2428: THEN

Line 2430: l_ar_tax_reg_number:=JMF_GTA_TRX_UTIL.Get_Arline_Tp_Taxreg_Number

2426: ,p_customer_trx_line_id => l_ar_line_id
2427: )
2428: THEN
2429: --Third party tax registration number
2430: l_ar_tax_reg_number:=JMF_GTA_TRX_UTIL.Get_Arline_Tp_Taxreg_Number
2431: (p_org_id => l_org_id
2432: ,p_customer_trx_id => l_ar_header_id
2433: ,p_customer_trx_line_id => l_ar_line_id
2434: );

Line 2436: l_ar_line_amount:=JMF_GTA_TRX_UTIL.Get_Arline_Amount

2432: ,p_customer_trx_id => l_ar_header_id
2433: ,p_customer_trx_line_id => l_ar_line_id
2434: );
2435: --taxable amount of AR line
2436: l_ar_line_amount:=JMF_GTA_TRX_UTIL.Get_Arline_Amount
2437: (p_org_id => l_org_id
2438: ,p_customer_trx_line_id => l_ar_line_id
2439: );
2440: --tax amount of AR line

Line 2441: l_ar_vat_line_tax:=JMF_GTA_TRX_UTIL.Get_Arline_Vattax_Amount

2437: (p_org_id => l_org_id
2438: ,p_customer_trx_line_id => l_ar_line_id
2439: );
2440: --tax amount of AR line
2441: l_ar_vat_line_tax:=JMF_GTA_TRX_UTIL.Get_Arline_Vattax_Amount
2442: (p_org_id => l_org_id
2443: ,p_customer_trx_line_id => l_ar_line_id
2444: );
2445: --tax rate of AR line

Line 2446: l_ar_vat_tax_rate:=JMF_GTA_TRX_UTIL.Get_Arline_Vattax_Rate

2442: (p_org_id => l_org_id
2443: ,p_customer_trx_line_id => l_ar_line_id
2444: );
2445: --tax rate of AR line
2446: l_ar_vat_tax_rate:=JMF_GTA_TRX_UTIL.Get_Arline_Vattax_Rate
2447: (p_org_id => l_org_id
2448: ,p_customer_trx_line_id => l_ar_line_id
2449: );
2450:

Line 2456: END IF; --JMF_GTA_TRX_UTIL.Check_Taxcount_Of_Arline

2452: l_ar_tax_reg_number:='';
2453: l_ar_line_amount:='';
2454: l_ar_vat_line_tax:='';
2455: l_ar_vat_tax_rate:='';
2456: END IF; --JMF_GTA_TRX_UTIL.Check_Taxcount_Of_Arline
2457:
2458: --log for debug
2459: IF( l_proc_level >= l_dbg_level)
2460: THEN

Line 2843: l_gt_value:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

2839: IF (l_ar_unit_price<>l_gta_unit_price)
2840: THEN
2841: IF (l_matched_flag='Y')
2842: THEN
2843: l_gt_value:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2844: ,p_amount => l_gta_unit_price
2845: );
2846: ELSE
2847: l_gt_invoice_number:='-';

Line 2852: l_ar_unit_price_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

2848: l_gt_value:=l_unmatched_attr;
2849: END IF; --(l_matched_flag='Y')
2850:
2851: --Fomrat Amount
2852: l_ar_unit_price_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2853: ,p_amount => l_ar_unit_price
2854: );
2855: l_gta_unit_price_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2856: ,p_amount => l_gta_unit_price

Line 2855: l_gta_unit_price_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

2851: --Fomrat Amount
2852: l_ar_unit_price_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2853: ,p_amount => l_ar_unit_price
2854: );
2855: l_gta_unit_price_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
2856: ,p_amount => l_gta_unit_price
2857: );
2858:
2859: --insert discrepancy record into temp table jmf_gta_difference_temp

Line 3036: l_gt_value:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3032: THEN
3033: IF (l_matched_flag_total='Y')
3034: THEN
3035: l_gt_invoice_number:=l_gt_invoice_number_con;
3036: l_gt_value:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3037: ,p_amount => l_gta_line_amount_sum
3038: );
3039:
3040: ELSE

Line 3046: l_ar_line_amount_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3042: l_gt_value:=l_unmatched_attr;
3043: END IF; --(l_matched_flag_sum='Y')
3044:
3045: --Format Amount
3046: l_ar_line_amount_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3047: ,p_amount => l_ar_line_amount
3048: );
3049: l_gta_line_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3050: ,p_amount => l_gta_line_amount_sum

Line 3049: l_gta_line_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3045: --Format Amount
3046: l_ar_line_amount_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3047: ,p_amount => l_ar_line_amount
3048: );
3049: l_gta_line_amount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3050: ,p_amount => l_gta_line_amount_sum
3051: );
3052:
3053: --insert discrepancy record into temp table jmf_gta_difference_temp

Line 3102: l_gt_value:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3098: THEN
3099: IF (l_matched_flag_total='Y')
3100: THEN
3101: l_gt_invoice_number:=l_gt_invoice_number_con;
3102: l_gt_value:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3103: ,p_amount => l_gta_line_taxamount_sum
3104: );
3105:
3106: ELSE

Line 3112: l_ar_vat_line_tax_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3108: l_gt_value:=l_unmatched_attr;
3109: END IF; --(l_matched_flag_sum='Y')
3110:
3111: --Format Amount
3112: l_ar_vat_line_tax_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3113: ,p_amount => l_ar_vat_line_tax
3114: );
3115: l_gta_line_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3116: ,p_amount => l_gta_line_taxamount_sum

Line 3115: l_gta_line_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id

3111: --Format Amount
3112: l_ar_vat_line_tax_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3113: ,p_amount => l_ar_vat_line_tax
3114: );
3115: l_gta_line_taxamount_sum_disp:=JMF_GTA_TRX_UTIL.Format_Monetary_Amount(p_org_id => p_org_id
3116: ,p_amount => l_gta_line_taxamount_sum
3117: );
3118:
3119: --insert discrepancy record into temp table jmf_gta_difference_temp

Line 4036: l_gl_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);

4032: CLOSE c_primary_salesrep_name;
4033:
4034: --Bug 5521629
4035: --Format date to XSD Date format
4036: l_gl_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4037: l_gl_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4038: l_ar_trx_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4039: l_ar_trx_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4040: l_report_date:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);

Line 4037: l_gl_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);

4033:
4034: --Bug 5521629
4035: --Format date to XSD Date format
4036: l_gl_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4037: l_gl_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4038: l_ar_trx_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4039: l_ar_trx_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4040: l_report_date:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);
4041:

Line 4038: l_ar_trx_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);

4034: --Bug 5521629
4035: --Format date to XSD Date format
4036: l_gl_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4037: l_gl_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4038: l_ar_trx_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4039: l_ar_trx_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4040: l_report_date:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);
4041:
4042: --generate xml elements for Parameters

Line 4039: l_ar_trx_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);

4035: --Format date to XSD Date format
4036: l_gl_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4037: l_gl_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4038: l_ar_trx_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4039: l_ar_trx_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4040: l_report_date:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);
4041:
4042: --generate xml elements for Parameters
4043: SELECT

Line 4040: l_report_date:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);

4036: l_gl_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_from);
4037: l_gl_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_gl_date_to);
4038: l_ar_trx_date_from_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_from);
4039: l_ar_trx_date_to_f:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_ar_trx_date_to);
4040: l_report_date:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE);
4041:
4042: --generate xml elements for Parameters
4043: SELECT
4044: xmlforest( l_operating_unit AS "OperationUnit"

Line 4257: l_ar_trx_date:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(l_ar_difference.trx_date);

4253:
4254:
4255: --Bug 5521629
4256: --Format date to XSD Date formate
4257: l_ar_trx_date:=JMF_GTA_TRX_UTIL.To_Xsd_Date_String(l_ar_difference.trx_date);
4258: SELECT
4259: XMLELEMENT("Invoice"
4260: ,XMLFOREST
4261: (l_ar_difference.trx_number AS "ARInvoiceNo"

Line 4796: JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount

4792: END IF; -- l_gt_invoice_number_missing IS NULL
4793:
4794:
4795: l_gt_invoice_amount_missing :=l_gt_invoice_amount_missing +
4796: JMF_GTA_TRX_UTIL.Get_Gtainvoice_Amount
4797: (l_missing_artrx_rec.gta_trx_header_id
4798: );
4799:
4800: FETCH c_missing_artrx INTO l_missing_artrx_rec;

Line 4925: JMF_GTA_TRX_UTIL.Output_Conc(l_xml_output.Getclobval);

4921:
4922: --Output xml script
4923:
4924: FND_FILE.Put_Line(FND_FILE.Output,'');
4925: JMF_GTA_TRX_UTIL.Output_Conc(l_xml_output.Getclobval);
4926:
4927: --Logging for debug
4928:
4929: IF (l_proc_level>=l_dbg_level)