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.JG_ZZ_SUMMARY_ALL_PKG dependencies on JG_ZZ_SUMMARY_ALL_PKG

Line 1: PACKAGE BODY JG_ZZ_SUMMARY_ALL_PKG

1: PACKAGE BODY JG_ZZ_SUMMARY_ALL_PKG
2: -- $Header: jgzzsummaryallb.pls 120.70.12020000.5 2012/11/23 05:48:55 mkandula ship $
3: -- +======================================================================+
4: -- | Copyright (c) 1996 Oracle Corporation Redwood Shores, California, USA|
5: -- | All rights reserved. |

Line 7: -- NAME: JG_ZZ_SUMMARY_ALL_PKG

3: -- +======================================================================+
4: -- | Copyright (c) 1996 Oracle Corporation Redwood Shores, California, USA|
5: -- | All rights reserved. |
6: -- +======================================================================+
7: -- NAME: JG_ZZ_SUMMARY_ALL_PKG
8: --
9: -- DESCRIPTION: This Package is the default Package containing the Procedures
10: -- used by SUMMARY-ALL Extract
11: --

Line 847: fnd_file.put_line(fnd_file.log,'Executing jg_zz_summary_all_pkg.jgbeva06');

843: t_invoice_amt NUMBER := 0.00000000000001;
844:
845: BEGIN
846: IF p_debug_flag = 'Y' THEN
847: fnd_file.put_line(fnd_file.log,'Executing jg_zz_summary_all_pkg.jgbeva06');
848: fnd_file.put_line(fnd_file.log,'Open Cursor C_BELGIAN_VAT');
849: END IF;
850: OPEN c_belgian_vat;
851: FETCH c_belgian_vat BULK COLLECT INTO v_box_amount;

Line 1038: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');

1034:
1035: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1036: IF p_debug_flag = 'Y' THEN
1037: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1038: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
1039: END IF;
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));

Line 1042: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));

1038: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
1039: END IF;
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));
1043: RAISE;
1044: END jebeva06;
1045:
1046: --

Line 1254: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));

1250: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table :' || l_count );
1251: END IF ;
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));
1255: fnd_file.put_line(fnd_file.log,'Error at statement: ' || ln_stat_no);
1256: RAISE;
1257: END jeptavat;
1258:

Line 1426: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptpvat ' || SUBSTR(SQLERRM,1,200));

1422: END IF ;
1423:
1424: EXCEPTION
1425: WHEN OTHERS THEN
1426: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptpvat ' || SUBSTR(SQLERRM,1,200));
1427: RAISE;
1428: END jeptpvat;
1429:
1430: --

Line 1628: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeitpssr ' || SUBSTR(SQLERRM,1,200));

1624: END IF ;
1625:
1626: EXCEPTION
1627: WHEN OTHERS THEN
1628: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeitpssr ' || SUBSTR(SQLERRM,1,200));
1629: RAISE;
1630: END jeitpssr;
1631:
1632: -- ER 9155483

Line 1679: ,JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_STANDARD

1675: SELECT JZVRS.VAT_REPORTING_ENTITY_ID REPORTING_ENTITY
1676: ,1 COUNT_STD_INV, DECODE(JZVTD.REPORTING_CODE, 'VAT-C', 'C','VAT-P','P','VAT-H','H','T') CLASS
1677: ,JZVTD.TRX_ID INV_ID_STANDARD
1678: ,NVL(AP.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP
1679: ,JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_STANDARD
1680: ,TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') INV_DATE_STANDARD
1681: ,JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS
1682: ,JZVTD.BILLING_TP_NUMBER VEN_NUM_STANDARD
1683: ,NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM),1,9),9,'0'),'000000000') TAX_REG_NUM_STANDARD

Line 1725: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_IMPORT,

1721: CURSOR q_rshimon_imports IS
1722: SELECT JZVRS.VAT_REPORTING_ENTITY_ID REPORTING_ENTITY,
1723: 1 COUNT_IMPORT, JZVTD.TRX_ID INV_ID_IMPORT,
1724: NVL(APINV.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP,
1725: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_IMPORT,
1726: JZVTD.TRX_DATE INV_DATE_IMPORT,
1727: JZVTD.BILLING_TP_NUMBER VEN_NUMBER,
1728: NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM), 1, 9), 9, '0'), '000000000') TAX_REG_NUM_IMPORT,
1729: NVL(APINVL.GLOBAL_ATTRIBUTE14, APINV.INVOICE_NUM) IMP_DOC_NUM_IMPORT,

Line 1827: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) TRX_NUMBER,

1823: 1 COUNT_TRX,
1824: JZVTD.REPORTING_CODE REPORTING_CODE,
1825: JZVTD.TRX_ID TRX_ID,
1826: NVL(AR.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP,
1827: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) TRX_NUMBER,
1828: TO_CHAR(DECODE(JZVTD.REPORTING_CODE, 'VAT-Y',DECODE(LENGTH(NVL(ARL.GLOBAL_ATTRIBUTE2,'A')),
1829: 1,jzvtd.TRX_DATE,
1830: 19,TO_DATE(ARL.global_attribute2,'RRRR/MM/DD HH24:MI:SS'),
1831: TO_DATE(ARL.global_attribute2, 'DD-MM-RRRR')),jzvtd.trx_date),'RRRRMMDD') TRX_DATE,

Line 1876: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) TRX_NUMBER,

1872: 1 COUNT_REG_TRX,
1873: JZVTD.REPORTING_CODE REPORTING_CODE,
1874: JZVTD.TRX_ID TRX_ID,
1875: NVL(AR.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP,
1876: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) TRX_NUMBER,
1877: TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') TRX_DATE,
1878: JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS,
1879: JZVTD.BILLING_TP_TAXPAYER_ID TAXPAYER_ID,
1880: DECODE(JZVTD.REPORTING_CODE, 'VAT-S', SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)) , 0) VAT_AMOUNT,

Line 1919: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) TRX_NUMBER,

1915: 1 COUNT_UNKNOWN_TRX,
1916: JZVTD.REPORTING_CODE REPORTING_CODE,
1917: JZVTD.TRX_ID TRX_ID,
1918: NVL(AR.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP,
1919: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) TRX_NUMBER,
1920: TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') TRX_DATE,
1921: JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS,
1922: DECODE(JZVTD.REPORTING_CODE, 'VAT-L', SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)),
1923: 'VAT-S', SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)), 0) VAT_AMOUNT,

Line 1969: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) TRX_NUMBER,

1965: SUM(TAXABLE_AMOUNT) SUM_OF_TAXABLE_AMT
1966: FROM ( SELECT JZVRS.VAT_REPORTING_ENTITY_ID,
1967: JZVTD.TRX_ID TRX_ID,
1968: NVL(AR.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP,
1969: JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) TRX_NUMBER,
1970: JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS,
1971: SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR, JZVTD.TAX_AMT)) VAT_AMOUNT,
1972: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1973: FROM

Line 2529: fnd_file.put_line(fnd_file.log,'Error in Procedure JG_ZZ_SUMMARY_ALL_PKG.jeilr835 ' || SUBSTR(SQLERRM,1,200));

2525: fnd_file.put_line(fnd_file.log,'>>>>>'||l_ent_name);
2526: END LOOP;
2527: raise_application_error(-20010,LOG_MESSAGE_835);
2528: WHEN OTHERS THEN
2529: fnd_file.put_line(fnd_file.log,'Error in Procedure JG_ZZ_SUMMARY_ALL_PKG.jeilr835 ' || SUBSTR(SQLERRM,1,200));
2530: RAISE;
2531: END jeilr835;
2532:
2533: FUNCTION a_real_tax_amount(p_payment_amt IN NUMBER

Line 2566: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_tax_amount ' || SUBSTR(SQLERRM,1,200));

2562: END IF;
2563: RETURN(tax_amount);
2564: EXCEPTION
2565: WHEN OTHERS THEN
2566: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_tax_amount ' || SUBSTR(SQLERRM,1,200));
2567: RAISE;
2568: END a_real_tax_amount;
2569:
2570: FUNCTION a_real_invoice_amount(p_payment_amt IN NUMBER

Line 2591: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_invoice_amount ' || SUBSTR(SQLERRM,1,200));

2587: END IF;
2588: RETURN(invoice_amount);
2589: EXCEPTION
2590: WHEN OTHERS THEN
2591: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_invoice_amount ' || SUBSTR(SQLERRM,1,200));
2592: RAISE;
2593: END a_real_invoice_amount;
2594:
2595: FUNCTION a_total_invoices(p_cust_trx_id IN NUMBER)

Line 2619: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_total_invoices ' || SUBSTR(SQLERRM,1,200));

2615: END IF;
2616: RETURN(invoice_values);
2617: EXCEPTION
2618: WHEN OTHERS THEN
2619: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_total_invoices ' || SUBSTR(SQLERRM,1,200));
2620: RAISE;
2621: END a_total_invoices;
2622:
2623: FUNCTION get_report_format

Line 2855: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..FINAL_FLAG:'||FINAL_FLAG);

2851: OPEN c_get_period_start_date;
2852: FETCH c_get_period_start_date INTO l_period_start_date;
2853: CLOSE c_get_period_start_date;
2854:
2855: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..FINAL_FLAG:'||FINAL_FLAG);
2856: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..CARRY_OVER :'||TO_CHAR(CARRY_OVER));
2857: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..LAST_PROCESS_DATE :'||TO_CHAR(LAST_PROCESS_DATE));
2858:
2859: IF FINAL_FLAG = 'S' THEN

Line 2856: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..CARRY_OVER :'||TO_CHAR(CARRY_OVER));

2852: FETCH c_get_period_start_date INTO l_period_start_date;
2853: CLOSE c_get_period_start_date;
2854:
2855: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..FINAL_FLAG:'||FINAL_FLAG);
2856: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..CARRY_OVER :'||TO_CHAR(CARRY_OVER));
2857: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..LAST_PROCESS_DATE :'||TO_CHAR(LAST_PROCESS_DATE));
2858:
2859: IF FINAL_FLAG = 'S' THEN
2860: IF CARRY_OVER IS NULL THEN

Line 2857: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..LAST_PROCESS_DATE :'||TO_CHAR(LAST_PROCESS_DATE));

2853: CLOSE c_get_period_start_date;
2854:
2855: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..FINAL_FLAG:'||FINAL_FLAG);
2856: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..CARRY_OVER :'||TO_CHAR(CARRY_OVER));
2857: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..LAST_PROCESS_DATE :'||TO_CHAR(LAST_PROCESS_DATE));
2858:
2859: IF FINAL_FLAG = 'S' THEN
2860: IF CARRY_OVER IS NULL THEN
2861: IF LAST_PROCESS_DATE IS NULL THEN

Line 2907: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || to_char(AMOUNT_TO_PAY));

2903:
2904: END IF;
2905:
2906: END IF;for bug 7633948*/
2907: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || to_char(AMOUNT_TO_PAY));
2908: RETURN(AMOUNT_TO_PAY);
2909:
2910: EXCEPTION
2911: WHEN INVALID_CARRY_OVER THEN

Line 2915: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));

2911: WHEN INVALID_CARRY_OVER THEN
2912: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
2913: raise_application_error(-20010,LOG_MESSAGE);
2914: WHEN OTHERS THEN
2915: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
2916: raise_application_error(-20011,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
2917: END JEITPSSR_AMOUNT_TO_PAY;
2918:
2919: /****Added below function JEITPSSR_AMOUNT_TO_PAY_UPDATE for bug 7633948***/

Line 2916: raise_application_error(-20011,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));

2912: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
2913: raise_application_error(-20010,LOG_MESSAGE);
2914: WHEN OTHERS THEN
2915: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
2916: raise_application_error(-20011,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
2917: END JEITPSSR_AMOUNT_TO_PAY;
2918:
2919: /****Added below function JEITPSSR_AMOUNT_TO_PAY_UPDATE for bug 7633948***/
2920: FUNCTION JEITPSSR_AMOUNT_TO_PAY_UPDATE(AMOUNT_TO_PAY IN NUMBER)

Line 2967: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY_UPDATE ' || SUBSTR(SQLERRM,1,200));

2963: EXCEPTION
2964: -- WHEN INVALID_CARRY_OVER THEN
2965: -- fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
2966: WHEN OTHERS THEN
2967: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY_UPDATE ' || SUBSTR(SQLERRM,1,200));
2968: RETURN (FALSE);
2969: END JEITPSSR_AMOUNT_TO_PAY_UPDATE;
2970:
2971: /******Added the below function JEILR835 INV_NUM for Bug 7427956*********/

Line 2994: END JG_ZZ_SUMMARY_ALL_PKG;

2990: END IF;
2991: RETURN (l_str);
2992: END JEILR835_INV_NUM;
2993:
2994: END JG_ZZ_SUMMARY_ALL_PKG;