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_CREATE_JOURNALS_PKG dependencies on GL_INTERFACE

Line 31: | insert_gl_interface |

27: END zero_fill_segments;
28:
29: /* ---------------------------------------------------------------------
30: | PRIVATE FUNCTION |
31: | insert_gl_interface |
32: | DESCRIPTION |
33: | Insert analytical account journal lines into the GL_INTERFACE |
34: | table. |
35: | CALLED BY |

Line 33: | Insert analytical account journal lines into the GL_INTERFACE |

29: /* ---------------------------------------------------------------------
30: | PRIVATE FUNCTION |
31: | insert_gl_interface |
32: | DESCRIPTION |
33: | Insert analytical account journal lines into the GL_INTERFACE |
34: | table. |
35: | CALLED BY |
36: | Create_Journal_Allocations |
37: | RETURNS |

Line 40: FUNCTION insert_gl_interface( lp_entered_dr IN NUMBER,

36: | Create_Journal_Allocations |
37: | RETURNS |
38: | TRUE if row successfully created. |
39: --------------------------------------------------------------------- */
40: FUNCTION insert_gl_interface( lp_entered_dr IN NUMBER,
41: lp_entered_cr IN NUMBER,
42: lp_accounted_dr IN NUMBER,
43: lp_accounted_cr IN NUMBER,
44: lp_offset_group_bool IN BOOLEAN) RETURN BOOLEAN IS

Line 46: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.insert_gl_interface');

42: lp_accounted_dr IN NUMBER,
43: lp_accounted_cr IN NUMBER,
44: lp_offset_group_bool IN BOOLEAN) RETURN BOOLEAN IS
45: BEGIN
46: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.insert_gl_interface');
47:
48: IF NOT lp_offset_group_bool THEN
49:
50: INSERT INTO gl_interface ( STATUS,

Line 50: INSERT INTO gl_interface ( STATUS,

46: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.insert_gl_interface');
47:
48: IF NOT lp_offset_group_bool THEN
49:
50: INSERT INTO gl_interface ( STATUS,
51: LEDGER_ID, -- GC Ledger Architecture change
52: ACCOUNTING_DATE,
53: CURRENCY_CODE,
54: USER_CURRENCY_CONVERSION_TYPE,

Line 261: INSERT INTO gl_interface ( STATUS,

257:
258: ELSE -- Inserting line for an offset group total
259:
260:
261: INSERT INTO gl_interface ( STATUS,
262: LEDGER_ID, -- GC Ledger Architecture change
263: ACCOUNTING_DATE,
264: CURRENCY_CODE,
265: USER_CURRENCY_CONVERSION_TYPE,

Line 467: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');

463: JG_JOURNAL_ALLOCATIONS_PKG.G_destn_period_name, NULL));
464:
465: END IF;
466:
467: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');
468: RETURN TRUE;
469: EXCEPTION
470: WHEN OTHERS THEN
471: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');

Line 471: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');

467: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');
468: RETURN TRUE;
469: EXCEPTION
470: WHEN OTHERS THEN
471: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');
472: JG_UTILITY_PKG.log(sqlerrm);
473: RETURN FALSE;
474: END insert_gl_interface;
475:

Line 474: END insert_gl_interface;

470: WHEN OTHERS THEN
471: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');
472: JG_UTILITY_PKG.log(sqlerrm);
473: RETURN FALSE;
474: END insert_gl_interface;
475:
476: /* ---------------------------------------------------------------------
477: | PUBLIC PROCEDURE |
478: | Create_Offset_For_Acct_Range |

Line 480: | Creates an offset line in GL_Interface for the account range |

476: /* ---------------------------------------------------------------------
477: | PUBLIC PROCEDURE |
478: | Create_Offset_For_Acct_Range |
479: | DESCRIPTION |
480: | Creates an offset line in GL_Interface for the account range |
481: | total. |
482: | CALLED BY |
483: | Create_Journal_Allocations |
484: --------------------------------------------------------------------- */

Line 543: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface(l_net_dr_entered_offset_total,

539: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N') THEN
540: --
541: -- Insert for offset account (one line that is the net of the credits and debits)
542: --
543: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface(l_net_dr_entered_offset_total,
544: l_net_cr_entered_offset_total,
545: l_net_dr_accted_offset_total,
546: l_net_cr_accted_offset_total,
547: TRUE) THEN

Line 548: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');

544: l_net_cr_entered_offset_total,
545: l_net_dr_accted_offset_total,
546: l_net_cr_accted_offset_total,
547: TRUE) THEN
548: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');
549: JG_CREATE_JOURNALS_PKG.write_error_to_output;
550: RAISE APP_EXCEPTION.application_exception;
551: END IF;
552: END IF;

Line 675: | Insert source journal allocation lines into GL_INTERFACE from array |

671: | Compare original entered/accounted amounts with total of allocated |
672: | amounts and calculate any rounding errors. |
673: | Add rounding errors to amounts of allocation line and offset line |
674: | with the max percentage in the array |
675: | Insert source journal allocation lines into GL_INTERFACE from array |
676: | (create_journal ends here) |
677: | END journal line LOOP |
678: | CALLED BY |
679: | JG_ALLOCATE_JOURNALS_PKG.allocate |

Line 833: -- Populate allocated lines table for reporting and later gl_interface insertion

829: l_max_prc_alloc_for_jrnal := c_rule_line_rec.allocation_percent;
830: l_max_prc_alloc_line_for_jrnal := JG_CREATE_JOURNALS_PKG.i;
831: END IF;
832: --
833: -- Populate allocated lines table for reporting and later gl_interface insertion
834: --
835: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_batch_name
836: := JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name;
837: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_header_name

Line 986: -- Loop for all allocation lines to insert into GL Interface

982: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_offst_line_for_jrnal).destn_accted_dr;
983: END IF;
984: END IF; -- Amount_Type Check
985: --
986: -- Loop for all allocation lines to insert into GL Interface
987: -- Only if at least one allocation line has been found
988: --
989: FOR j IN l_first_alloc_for_jrnal .. JG_CREATE_JOURNALS_PKG.i LOOP
990: --

Line 1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface

999: IF JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N' THEN
1000: JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));
1001: JG_CREATE_JOURNALS_PKG.G_key_segment( JG_JOURNAL_ALLOCATIONS_PKG.G_acct_key_element ) :=
1002: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_account_number;
1003: IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
1004: (JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
1007: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,

Line 1009: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');

1005: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
1006: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
1007: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,
1008: FALSE) THEN
1009: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');
1010: JG_CREATE_JOURNALS_PKG.write_error_to_output;
1011: RAISE APP_EXCEPTION.application_exception;
1012: END IF;
1013: END IF; -- Validate_Only?