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 1165: -- v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_creation_date)

1161: FETCH for_terms_id_2 INTO for_terms_id_rec;
1162: CLOSE for_terms_id_2;
1163: END IF;
1164: --commented by anujsax for bug 6126142
1165: -- v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_creation_date)
1166: -- ,pn_org_id /* Added by Ramananda for bug#4559828 */
1167: -- );
1168: -- added by anujsax for bug 6126142
1169: v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_settlement_date)

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

1165: -- v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_creation_date)
1166: -- ,pn_org_id /* Added by Ramananda for bug#4559828 */
1167: -- );
1168: -- added by anujsax for bug 6126142
1169: v_open_period := ap_utilities_pkg.get_current_gl_date(TRUNC(pd_settlement_date)
1170: ,pn_org_id /* Added by Ramananda for bug#4559828 */
1171: );
1172: --ended by anujsax for bug 6126142
1173: if v_open_period is null then

Line 1175: ap_utilities_pkg.get_open_gl_date (

1171: );
1172: --ended by anujsax for bug 6126142
1173: if v_open_period is null then
1174:
1175: ap_utilities_pkg.get_open_gl_date (
1176: -- TRUNC(pd_creation_date),/*commented by anujsax for bug#6126142*/
1177: TRUNC(pd_settlement_date),/* addded by anujsax for bug#6126142*/
1178: v_open_period,
1179: v_open_gl_date