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 JG_UTILITY_PKG

Line 16: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');

12: | create_journal_allocations |
13: --------------------------------------------------------------------- */
14: PROCEDURE zero_fill_segments(p_key_segment IN OUT NOCOPY KEY_SEGMENTS_TABLE) IS
15: BEGIN
16: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');
17: FOR j IN 1..JG_JOURNAL_ALLOCATIONS_PKG.G_num_of_segments LOOP
18: JG_UTILITY_PKG.debug( 'segmt posn = '||to_char(j));
19: JG_UTILITY_PKG.debug( 'ZF: segmt col name = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name);
20: JG_UTILITY_PKG.debug( 'ZF: segmt zero string = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string);

Line 18: JG_UTILITY_PKG.debug( 'segmt posn = '||to_char(j));

14: PROCEDURE zero_fill_segments(p_key_segment IN OUT NOCOPY KEY_SEGMENTS_TABLE) IS
15: BEGIN
16: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');
17: FOR j IN 1..JG_JOURNAL_ALLOCATIONS_PKG.G_num_of_segments LOOP
18: JG_UTILITY_PKG.debug( 'segmt posn = '||to_char(j));
19: JG_UTILITY_PKG.debug( 'ZF: segmt col name = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name);
20: JG_UTILITY_PKG.debug( 'ZF: segmt zero string = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string);
21: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name IS NOT NULL) THEN
22: p_key_segment(TO_NUMBER(SUBSTR(JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name, 8)))

Line 19: JG_UTILITY_PKG.debug( 'ZF: segmt col name = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name);

15: BEGIN
16: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');
17: FOR j IN 1..JG_JOURNAL_ALLOCATIONS_PKG.G_num_of_segments LOOP
18: JG_UTILITY_PKG.debug( 'segmt posn = '||to_char(j));
19: JG_UTILITY_PKG.debug( 'ZF: segmt col name = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name);
20: JG_UTILITY_PKG.debug( 'ZF: segmt zero string = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string);
21: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name IS NOT NULL) THEN
22: p_key_segment(TO_NUMBER(SUBSTR(JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name, 8)))
23: := JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string;

Line 20: JG_UTILITY_PKG.debug( 'ZF: segmt zero string = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string);

16: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');
17: FOR j IN 1..JG_JOURNAL_ALLOCATIONS_PKG.G_num_of_segments LOOP
18: JG_UTILITY_PKG.debug( 'segmt posn = '||to_char(j));
19: JG_UTILITY_PKG.debug( 'ZF: segmt col name = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name);
20: JG_UTILITY_PKG.debug( 'ZF: segmt zero string = '||JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string);
21: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name IS NOT NULL) THEN
22: p_key_segment(TO_NUMBER(SUBSTR(JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name, 8)))
23: := JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string;
24: END IF;

Line 26: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');

22: p_key_segment(TO_NUMBER(SUBSTR(JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).segment_col_name, 8)))
23: := JG_JOURNAL_ALLOCATIONS_PKG.G_zero_fill_arr(j).zero_string;
24: END IF;
25: END LOOP;
26: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.Zero_Fill_Segments');
27: END zero_fill_segments;
28:
29: /* ---------------------------------------------------------------------
30: | PRIVATE FUNCTION |

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 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 472: JG_UTILITY_PKG.log(sqlerrm);

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:
476: /* ---------------------------------------------------------------------

Line 494: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');

490: l_net_dr_entered_offset_total NUMBER := 0;
491: l_net_cr_entered_offset_total NUMBER := 0;
492: l_range_offset_remark VARCHAR2(240) := NULL;
493: BEGIN
494: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');
495: --
496: -- Need to zero-fill segments for offset group insert other than the balancing segment and natural account
497: -- Use separate array to store zeros as Zero-Fill method may not have been chosen for journal allocation.
498: --

Line 596: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');

592: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt := 0;
593: JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt := 0;
594: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := 0;
595: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := 0;
596: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range');
597: END create_offset_for_acct_range;
598:
599: /* ---------------------------------------------------------------------
600: | PUBLIC PROCEDURE |

Line 612: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.write_error_to_output');

608: PROCEDURE write_error_to_output IS
609: l_acct_segments VARCHAR2(2000);
610: l_error_message VARCHAR2(2000) := NULL;
611: BEGIN
612: JG_UTILITY_PKG.log( '> JG_CREATE_JOURNALS_PKG.write_error_to_output');
613: --
614: -- Construct accounting flexfield segments string
615: --
616: l_acct_segments := fnd_flex_ext.get_segs(JG_JOURNAL_ALLOCATIONS_PKG.G_GL_appln_short_name,

Line 621: JG_UTILITY_PKG.debug('acct string = '||l_acct_segments);

617: JG_JOURNAL_ALLOCATIONS_PKG.G_GL_acct_flex_code,
618: JG_JOURNAL_ALLOCATIONS_PKG.G_chart_of_accounts_id,
619: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.code_combination_id);
620:
621: JG_UTILITY_PKG.debug('acct string = '||l_acct_segments);
622:
623: --
624: -- Get the latest message from the stack for error reporting
625: --

Line 629: JG_UTILITY_PKG.out(

625: --
626: IF JG_JOURNAL_ALLOCATIONS_PKG.G_unalloc_request_id IS NULL THEN -- Error Reporting
627: l_error_message := FND_MESSAGE.GET;
628: JG_JOURNAL_ALLOCATIONS_PKG.G_errbuf := l_error_message;
629: JG_UTILITY_PKG.out(
630: RPAD(SUBSTR(NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name, ' '), 1, 20), 20)||' '||
631: RPAD(SUBSTR(NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name, ' '), 1, 19), 19)||' '||
632: RPAD(SUBSTR(NVL(l_acct_segments, ' '), 1, 35), 35)||' '||
633: LPAD(SUBSTR(NVL(TO_CHAR(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num), ' '), 1, 3), 3)||' '||

Line 639: JG_UTILITY_PKG.out(

635: JG_ALLOCATE_JOURNALS_PKG.G_currency_format_mask), ' ') ,1,15), 15)||' '||
636: LPAD(SUBSTR(NVL(TO_CHAR(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr,
637: JG_ALLOCATE_JOURNALS_PKG.G_currency_format_mask), ' ') ,1,15),15)||' '||l_error_message);
638: ELSE -- Unallocation Reporting
639: JG_UTILITY_PKG.out(
640: RPAD(SUBSTR(NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name, ' '), 1, 20), 20)||' '||
641: RPAD(SUBSTR(NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name, ' '), 1, 19), 19)||' '||
642: RPAD(SUBSTR(NVL(l_acct_segments, ' '), 1, 35), 35)||' '||
643: LPAD(SUBSTR(NVL(TO_CHAR(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num), ' '), 1, 3), 3)||' '||

Line 649: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.write_error_to_output');

645: JG_ALLOCATE_JOURNALS_PKG.G_currency_format_mask), ' ') ,1,15), 15)||' '||
646: LPAD(SUBSTR(NVL(TO_CHAR(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.entered_cr,
647: JG_ALLOCATE_JOURNALS_PKG.G_currency_format_mask), ' ') ,1,15),15));
648: END IF;
649: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.write_error_to_output');
650: END write_error_to_output;
651:
652: /* ------------------------------------------------------------------------------
653: | PUBLIC PROCEDURE |

Line 708: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.create_journal');

704: l_rounded_accted_dr_sum NUMBER := 0;
705: l_rounded_entered_cr_sum NUMBER := 0;
706: l_rounded_entered_dr_sum NUMBER := 0;
707: BEGIN
708: JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.create_journal');
709: --
710: -- Only create offset row if latest fiscal journal line falls into a different account range than the last line.
711: -- We are inserting an offset line for all lines under the same account range up to the last journal record.
712: -- Separate offset range also created if the currency has changed, journal import implicitly creates a separate

Line 715: JG_UTILITY_PKG.debug( ' current acct range id = '||to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id));

711: -- We are inserting an offset line for all lines under the same account range up to the last journal record.
712: -- Separate offset range also created if the currency has changed, journal import implicitly creates a separate
713: -- journal header per currency if the entered amounts are in different currencies.
714: --
715: JG_UTILITY_PKG.debug( ' current acct range id = '||to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id));
716: JG_UTILITY_PKG.debug( ' last acct range id = '||to_char(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.account_range_id));
717: JG_UTILITY_PKG.debug( ' last offset account = '||JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account);
718: IF JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account IS NOT NULL AND
719: ((JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.account_range_id <>

Line 716: JG_UTILITY_PKG.debug( ' last acct range id = '||to_char(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.account_range_id));

712: -- Separate offset range also created if the currency has changed, journal import implicitly creates a separate
713: -- journal header per currency if the entered amounts are in different currencies.
714: --
715: JG_UTILITY_PKG.debug( ' current acct range id = '||to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id));
716: JG_UTILITY_PKG.debug( ' last acct range id = '||to_char(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.account_range_id));
717: JG_UTILITY_PKG.debug( ' last offset account = '||JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account);
718: IF JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account IS NOT NULL AND
719: ((JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.account_range_id <>
720: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id) OR

Line 717: JG_UTILITY_PKG.debug( ' last offset account = '||JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account);

713: -- journal header per currency if the entered amounts are in different currencies.
714: --
715: JG_UTILITY_PKG.debug( ' current acct range id = '||to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id));
716: JG_UTILITY_PKG.debug( ' last acct range id = '||to_char(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.account_range_id));
717: JG_UTILITY_PKG.debug( ' last offset account = '||JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account);
718: IF JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.offset_account IS NOT NULL AND
719: ((JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.account_range_id <>
720: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id) OR
721: ((JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code <>

Line 723: JG_UTILITY_PKG.debug( ' creating offset line for acct range ');

719: ((JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.account_range_id <>
720: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id) OR
721: ((JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code <>
722: JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code) AND JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type = 'E')) THEN
723: JG_UTILITY_PKG.debug( ' creating offset line for acct range ');
724: JG_CREATE_JOURNALS_PKG.create_offset_for_acct_range;
725: END IF;
726:
727:

Line 737: JG_UTILITY_PKG.debug('Journal Header = ' || JG_CREATE_JOURNALS_PKG.G_Journal_Name);

733: JG_CREATE_JOURNALS_PKG.G_Journal_Name := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description,
734: TO_CHAR(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_id));
735: JG_CREATE_JOURNALS_PKG.G_Journal_Description := NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.cc_range_description||' '||l_cc_range_code,
736: l_cc_range_code);
737: JG_UTILITY_PKG.debug('Journal Header = ' || JG_CREATE_JOURNALS_PKG.G_Journal_Name);
738: END IF;
739:
740:
741: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_validate_only = 'N') THEN

Line 790: JG_UTILITY_PKG.debug(TO_CHAR(SYSDATE, 'HH24:MI:SS'));

786: l_first_alloc_for_jrnal := JG_CREATE_JOURNALS_PKG.i + 1;
787: --
788: -- loop for each destination account number and allocation
789: --
790: JG_UTILITY_PKG.debug(TO_CHAR(SYSDATE, 'HH24:MI:SS'));
791: FOR c_rule_line_rec IN c_rule_line LOOP
792: JG_UTILITY_PKG.debug( 'inner loop: start');
793: --
794: -- Calculate allocated account amounts based on the parameter amount_type and the precision of the currency,

Line 792: JG_UTILITY_PKG.debug( 'inner loop: start');

788: -- loop for each destination account number and allocation
789: --
790: JG_UTILITY_PKG.debug(TO_CHAR(SYSDATE, 'HH24:MI:SS'));
791: FOR c_rule_line_rec IN c_rule_line LOOP
792: JG_UTILITY_PKG.debug( 'inner loop: start');
793: --
794: -- Calculate allocated account amounts based on the parameter amount_type and the precision of the currency,
795: -- any rounding errors are dealt with later down in the code once all rule lines for the journal have been fetched.
796: --

Line 860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));

856: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_cr := l_accted_credit_amount;
857: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_accted_dr := l_accted_debit_amount;
858: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_credit_amount;
859: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_debit_amount;
860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
861:
862: JG_UTILITY_PKG.debug( 'batch_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name);
863: JG_UTILITY_PKG.debug('header_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name);
864: JG_UTILITY_PKG.debug('accounted_cr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr));

Line 862: JG_UTILITY_PKG.debug( 'batch_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name);

858: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_cr := l_entered_credit_amount;
859: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_debit_amount;
860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
861:
862: JG_UTILITY_PKG.debug( 'batch_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name);
863: JG_UTILITY_PKG.debug('header_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name);
864: JG_UTILITY_PKG.debug('accounted_cr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr));
865: JG_UTILITY_PKG.debug('accounted_dr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr));
866: --

Line 863: JG_UTILITY_PKG.debug('header_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name);

859: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).destn_entered_dr := l_entered_debit_amount;
860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
861:
862: JG_UTILITY_PKG.debug( 'batch_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name);
863: JG_UTILITY_PKG.debug('header_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name);
864: JG_UTILITY_PKG.debug('accounted_cr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr));
865: JG_UTILITY_PKG.debug('accounted_dr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr));
866: --
867: -- inserting an offset line for just the current journal record if the account range level offset account is null.

Line 864: JG_UTILITY_PKG.debug('accounted_cr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr));

860: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
861:
862: JG_UTILITY_PKG.debug( 'batch_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name);
863: JG_UTILITY_PKG.debug('header_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name);
864: JG_UTILITY_PKG.debug('accounted_cr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr));
865: JG_UTILITY_PKG.debug('accounted_dr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr));
866: --
867: -- inserting an offset line for just the current journal record if the account range level offset account is null.
868: --

Line 865: JG_UTILITY_PKG.debug('accounted_dr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr));

861:
862: JG_UTILITY_PKG.debug( 'batch_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_batch_name);
863: JG_UTILITY_PKG.debug('header_name = '|| JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name);
864: JG_UTILITY_PKG.debug('accounted_cr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr));
865: JG_UTILITY_PKG.debug('accounted_dr = '|| to_char(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_dr));
866: --
867: -- inserting an offset line for just the current journal record if the account range level offset account is null.
868: --
869: IF JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.offset_account IS NULL THEN

Line 906: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));

902: l_max_prc_offst_line_for_jrnal := JG_CREATE_JOURNALS_PKG.i;
903: END IF;
904: END IF; -- Is the account range level offset null?
905: l_is_max_prc_alloc_line := FALSE;
906: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
907: END LOOP;
908: JG_UTILITY_PKG.debug(TO_CHAR(SYSDATE, 'HH24:MI:SS'));
909: --
910: -- Update entered and accounted amounts of max perc line with any rounding error total

Line 908: JG_UTILITY_PKG.debug(TO_CHAR(SYSDATE, 'HH24:MI:SS'));

904: END IF; -- Is the account range level offset null?
905: l_is_max_prc_alloc_line := FALSE;
906: JG_UTILITY_PKG.debug('Loop number = '||to_char(JG_CREATE_JOURNALS_PKG.i)||' '|| 'je_line_num = '||to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).je_line_num));
907: END LOOP;
908: JG_UTILITY_PKG.debug(TO_CHAR(SYSDATE, 'HH24:MI:SS'));
909: --
910: -- Update entered and accounted amounts of max perc line with any rounding error total
911: --
912: IF JG_CREATE_JOURNALS_PKG.i >= l_first_alloc_for_jrnal THEN

Line 917: JG_UTILITY_PKG.debug( 'Perform rounding errors calculations');

913: --
914: -- Adjust calculated amounts with any rounding error difference if the line
915: -- is the maximum percentage line chosen and it is a full allocation of 100 percent
916: --
917: JG_UTILITY_PKG.debug( 'Perform rounding errors calculations');
918: IF NVL(l_rounded_accted_cr_sum, 0) <>
919: NVL(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.accounted_cr, 0) THEN
920: IF l_max_prc_alloc_line_for_jrnal IS NOT NULL THEN
921: JG_CREATE_JOURNALS_PKG.alloc_lines_arr(l_max_prc_alloc_line_for_jrnal).destn_accted_cr :=

Line 997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));

993: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt
994: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
995: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));
998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));
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 ) :=

Line 998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));

994: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr, 0);
995: JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt
996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));
998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));
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;

Line 1000: JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));

996: := JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt + NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr, 0);
997: JG_UTILITY_PKG.debug('total_alloc_accted_cr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_cr_amt));
998: JG_UTILITY_PKG.debug('total_alloc_accted_dr_amt = '|| to_char(JG_CREATE_JOURNALS_PKG.G_total_alloc_accted_dr_amt));
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,

Line 1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));

1027: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_cr_amt +
1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +
1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);
1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));
1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));
1033: END IF;
1034: END LOOP;
1035: END IF; -- Have lines to allocate?

Line 1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));

1028: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr, 0);
1029: JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt := JG_CREATE_JOURNALS_PKG.G_total_offset_entered_dr_amt +
1030: NVL(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr, 0);
1031: JG_UTILITY_PKG.debug( 'cumulative offset accted dr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_dr_amt));
1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));
1033: END IF;
1034: END LOOP;
1035: END IF; -- Have lines to allocate?
1036: JG_UTILITY_PKG.debug('code_comb_id = '|| to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id));

Line 1036: JG_UTILITY_PKG.debug('code_comb_id = '|| to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id));

1032: JG_UTILITY_PKG.debug( 'cumulative offset accted cr amt = '||to_char(JG_CREATE_JOURNALS_PKG.G_total_offset_accted_cr_amt));
1033: END IF;
1034: END LOOP;
1035: END IF; -- Have lines to allocate?
1036: JG_UTILITY_PKG.debug('code_comb_id = '|| to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id));
1037: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_journal');
1038: END create_journal;
1039:
1040: END JG_CREATE_JOURNALS_PKG;

Line 1037: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_journal');

1033: END IF;
1034: END LOOP;
1035: END IF; -- Have lines to allocate?
1036: JG_UTILITY_PKG.debug('code_comb_id = '|| to_char(alloc_lines_arr(JG_CREATE_JOURNALS_PKG.i).code_combination_id));
1037: JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.create_journal');
1038: END create_journal;
1039:
1040: END JG_CREATE_JOURNALS_PKG;