DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on AP_UTILITIES_PKG

Line 38: Presently, org_id is not passed to ap_utilities_pkg.get_open_gl_date and

34: Org_id in the form is populated when authority site is selected from the
35: front end. When 'Process' Button is pressed, form makes a call to
36: jai_cmn_rgm_settlement_pkg.create_invoice passing org_id.
37:
38: Presently, org_id is not passed to ap_utilities_pkg.get_open_gl_date and
39: ap_utilities_pkg.get_current_gl_date. This is defaulted from mo_global.GET_CURRENT_ORG_ID.
40: However the value is not retrieved from the same, hence the above reported error
41:
42: Fix:

Line 39: ap_utilities_pkg.get_current_gl_date. This is defaulted from mo_global.GET_CURRENT_ORG_ID.

35: front end. When 'Process' Button is pressed, form makes a call to
36: jai_cmn_rgm_settlement_pkg.create_invoice passing org_id.
37:
38: Presently, org_id is not passed to ap_utilities_pkg.get_open_gl_date and
39: ap_utilities_pkg.get_current_gl_date. This is defaulted from mo_global.GET_CURRENT_ORG_ID.
40: However the value is not retrieved from the same, hence the above reported error
41:
42: Fix:
43: ----

Line 45: 1. ap_utilities_pkg.get_open_gl_date

41:
42: Fix:
43: ----
44: Added pn_org_id parameter while making a call to
45: 1. ap_utilities_pkg.get_open_gl_date
46: 2. ap_utilities_pkg.get_current_gl_date
47: in jai_cmn_rgm_settlement_pkg.create_invoice is modified to pass org_id, which is solving the problem.
48: i.e "APP-JA-460204: ORA 20001: No Open Period...after "
49:

Line 46: 2. ap_utilities_pkg.get_current_gl_date

42: Fix:
43: ----
44: Added pn_org_id parameter while making a call to
45: 1. ap_utilities_pkg.get_open_gl_date
46: 2. ap_utilities_pkg.get_current_gl_date
47: in jai_cmn_rgm_settlement_pkg.create_invoice is modified to pass org_id, which is solving the problem.
48: i.e "APP-JA-460204: ORA 20001: No Open Period...after "
49:
50: 02-Dec-2005 Bug 4774647. Added by Lakshmi Gopalsami Version 120.4

Line 1730: -- v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_creation_date)

1726: FETCH for_terms_id_2 INTO for_terms_id_rec;
1727: CLOSE for_terms_id_2;
1728: END IF;
1729: --commented by anujsax for bug 6126142
1730: -- v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_creation_date)
1731: -- ,pn_org_id /* Added by Ramananda for bug#4559828 */
1732: -- );
1733: -- added by anujsax for bug 6126142
1734: v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_settlement_date)

Line 1734: v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_settlement_date)

1730: -- v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_creation_date)
1731: -- ,pn_org_id /* Added by Ramananda for bug#4559828 */
1732: -- );
1733: -- added by anujsax for bug 6126142
1734: v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_settlement_date)
1735: ,pn_org_id /* Added by Ramananda for bug#4559828 */
1736: );
1737: --ended by anujsax for bug 6126142
1738: if v_open_period is null then

Line 1740: ap_utilities_pkg.get_open_gl_date (

1736: );
1737: --ended by anujsax for bug 6126142
1738: if v_open_period is null then
1739:
1740: ap_utilities_pkg.get_open_gl_date (
1741: -- TRUNC(pd_creation_date),/*commented by anujsax for bug#6126142*/
1742: TRUNC(pd_settlement_date),/* addded by anujsax for bug#6126142*/
1743: v_open_period,
1744: v_open_gl_date