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.31.12010000.11 2009/02/20 10:39:50 rahulkum 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 639: fnd_file.put_line(fnd_file.log,'Executing jg_zz_summary_all_pkg.jgbeva06');

635: l_index NUMBER;
636: l_count NUMBER := 0 ;
637: BEGIN
638: IF p_debug_flag = 'Y' THEN
639: fnd_file.put_line(fnd_file.log,'Executing jg_zz_summary_all_pkg.jgbeva06');
640: fnd_file.put_line(fnd_file.log,'Open Cursor C_BELGIAN_VAT');
641: END IF;
642: OPEN c_belgian_vat;
643: FETCH c_belgian_vat BULK COLLECT INTO v_box_amount;

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

767:
768: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
769: IF p_debug_flag = 'Y' THEN
770: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
771: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
772: END IF;
773: EXCEPTION
774: WHEN OTHERS THEN
775: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));

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

771: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
772: END IF;
773: EXCEPTION
774: WHEN OTHERS THEN
775: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));
776: RAISE;
777: END jebeva06;
778:
779: --

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

983: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table :' || l_count );
984: END IF ;
985: EXCEPTION
986: WHEN OTHERS THEN
987: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));
988: fnd_file.put_line(fnd_file.log,'Error at statement: ' || ln_stat_no);
989: RAISE;
990: END jeptavat;
991:

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

1155: END IF ;
1156:
1157: EXCEPTION
1158: WHEN OTHERS THEN
1159: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptpvat ' || SUBSTR(SQLERRM,1,200));
1160: RAISE;
1161: END jeptpvat;
1162:
1163: --

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

1297: END IF ;
1298:
1299: EXCEPTION
1300: WHEN OTHERS THEN
1301: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeitpssr ' || SUBSTR(SQLERRM,1,200));
1302: RAISE;
1303: END jeitpssr;
1304:
1305: FUNCTION a_real_tax_amount(p_payment_amt IN NUMBER

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

1334: END IF;
1335: RETURN(tax_amount);
1336: EXCEPTION
1337: WHEN OTHERS THEN
1338: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_tax_amount ' || SUBSTR(SQLERRM,1,200));
1339: RAISE;
1340: END a_real_tax_amount;
1341:
1342: FUNCTION a_real_invoice_amount(p_payment_amt IN NUMBER

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

1359: END IF;
1360: RETURN(invoice_amount);
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_invoice_amount ' || SUBSTR(SQLERRM,1,200));
1364: RAISE;
1365: END a_real_invoice_amount;
1366:
1367: FUNCTION a_total_invoices(p_cust_trx_id IN NUMBER)

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

1387: END IF;
1388: RETURN(invoice_values);
1389: EXCEPTION
1390: WHEN OTHERS THEN
1391: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_total_invoices ' || SUBSTR(SQLERRM,1,200));
1392: RAISE;
1393: END a_total_invoices;
1394:
1395: FUNCTION get_report_format

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

1664: WHEN INVALID_CARRY_OVER THEN
1665: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1666: raise_application_error(-20010,LOG_MESSAGE);
1667: WHEN OTHERS THEN
1668: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
1669: raise_application_error(-20011,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
1670: END JEITPSSR_AMOUNT_TO_PAY;
1671:
1672: /****Added below function JEITPSSR_AMOUNT_TO_PAY_UPDATE for bug 7633948***/

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

1665: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1666: raise_application_error(-20010,LOG_MESSAGE);
1667: WHEN OTHERS THEN
1668: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
1669: raise_application_error(-20011,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
1670: END JEITPSSR_AMOUNT_TO_PAY;
1671:
1672: /****Added below function JEITPSSR_AMOUNT_TO_PAY_UPDATE for bug 7633948***/
1673: FUNCTION JEITPSSR_AMOUNT_TO_PAY_UPDATE(AMOUNT_TO_PAY IN NUMBER)

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

1711: EXCEPTION
1712: -- WHEN INVALID_CARRY_OVER THEN
1713: -- fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1714: WHEN OTHERS THEN
1715: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY_UPDATE ' || SUBSTR(SQLERRM,1,200));
1716: RETURN (FALSE);
1717: END JEITPSSR_AMOUNT_TO_PAY_UPDATE;
1718:
1719: /******Added the below function JEILR835 INV_NUM for Bug 7427956*********/

Line 1742: END JG_ZZ_SUMMARY_ALL_PKG;

1738: END IF;
1739: RETURN (l_str);
1740: END JEILR835_INV_NUM;
1741:
1742: END JG_ZZ_SUMMARY_ALL_PKG;