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.FA_INTERCO_PVT dependencies on FA_DEBUG_PKG

Line 24: fa_debug_pkg.add(l_calling_fn, 'p_claling_fn', p_calling_fn

20: BEGIN
21:
22: -- set up the global
23: if (p_log_level_rec.statement_level) then
24: fa_debug_pkg.add(l_calling_fn, 'p_claling_fn', p_calling_fn
25: ,p_log_level_rec => p_log_level_rec);
26: end if;
27: --exit from the function if intercompany posting not allowed fapost enhancement strat
28: if (nvl(fa_cache_pkg.fazcbc_record.intercompany_posting_flag,'Y') = 'N')then

Line 30: fa_debug_pkg.add(l_calling_fn, 'Intercompany posting not allowed exiting', p_calling_fn

26: end if;
27: --exit from the function if intercompany posting not allowed fapost enhancement strat
28: if (nvl(fa_cache_pkg.fazcbc_record.intercompany_posting_flag,'Y') = 'N')then
29: if (p_log_level_rec.statement_level) then
30: fa_debug_pkg.add(l_calling_fn, 'Intercompany posting not allowed exiting', p_calling_fn
31: ,p_log_level_rec => p_log_level_rec);
32: end if;
33: return TRUE;
34: end if;

Line 39: fa_debug_pkg.add(l_calling_fn, 'group reclass mode', 'TRUE'

35: --fapost enhancement end
36: if (p_calling_fn = 'fa_group_reclass_pvt.do_grp_reclass' or
37: p_calling_fn = 'fa_group_process_groups_pkg.do_rcl') then
38: if (p_log_level_rec.statement_level) then
39: fa_debug_pkg.add(l_calling_fn, 'group reclass mode', 'TRUE'
40: ,p_log_level_rec => p_log_level_rec);
41: end if;
42: g_group_reclass := TRUE;
43: else

Line 45: fa_debug_pkg.add(l_calling_fn, 'group reclass mode', 'FALSE'

41: end if;
42: g_group_reclass := TRUE;
43: else
44: if (p_log_level_rec.statement_level) then
45: fa_debug_pkg.add(l_calling_fn, 'group reclass mode', 'FALSE'
46: ,p_log_level_rec => p_log_level_rec);
47: end if;
48: g_group_reclass := FALSE;
49: end if;

Line 201: fa_debug_pkg.add(l_calling_fn, 'Intercompany posting not allowed exiting', p_calling_fn

197: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;
198: --exit from the function if intercompany posting not allowed fapost enhancement strat
199: if (nvl(fa_cache_pkg.fazcbc_record.intercompany_posting_flag,'Y') <> 'Y')then
200: if (p_log_level_rec.statement_level) then
201: fa_debug_pkg.add(l_calling_fn, 'Intercompany posting not allowed exiting', p_calling_fn
202: ,p_log_level_rec => p_log_level_rec);
203: end if;
204: return TRUE;
205: end if;

Line 242: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Segment Number', l_bal_segnum

238: AND sat.segment_attribute_type = 'GL_BALANCING';
239:
240:
241: if (p_log_level_rec.statement_level) then
242: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Segment Number', l_bal_segnum
243: ,p_log_level_rec => p_log_level_rec);
244: end if;
245:
246:

Line 262: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Column Name', l_column_name

258: raise interco_err;
259: end if;
260:
261: if (p_log_level_rec.statement_level) then
262: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Column Name', l_column_name
263: ,p_log_level_rec => p_log_level_rec);
264: fa_debug_pkg.add(l_calling_fn, 'processing', 'source'
265: ,p_log_level_rec => p_log_level_rec);
266: end if;

Line 264: fa_debug_pkg.add(l_calling_fn, 'processing', 'source'

260:
261: if (p_log_level_rec.statement_level) then
262: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Column Name', l_column_name
263: ,p_log_level_rec => p_log_level_rec);
264: fa_debug_pkg.add(l_calling_fn, 'processing', 'source'
265: ,p_log_level_rec => p_log_level_rec);
266: end if;
267:
268:

Line 382: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first source tbl: ', l_balancing_seg

378: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);
379: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_sum_amount);
380:
381: if (p_log_level_rec.statement_level) then
382: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first source tbl: ', l_balancing_seg
383: ,p_log_level_rec => p_log_level_rec);
384: fa_debug_pkg.add(l_calling_fn, 'sum_amount for first source tbl: ', l_sum_amount
385: ,p_log_level_rec => p_log_level_rec);
386: end if;

Line 384: fa_debug_pkg.add(l_calling_fn, 'sum_amount for first source tbl: ', l_sum_amount

380:
381: if (p_log_level_rec.statement_level) then
382: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first source tbl: ', l_balancing_seg
383: ,p_log_level_rec => p_log_level_rec);
384: fa_debug_pkg.add(l_calling_fn, 'sum_amount for first source tbl: ', l_sum_amount
385: ,p_log_level_rec => p_log_level_rec);
386: end if;
387:
388:

Line 399: fa_debug_pkg.add(l_calling_fn, 'source table count', l_src_tbl.count

395: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
396:
397:
398: if (p_log_level_rec.statement_level) then
399: fa_debug_pkg.add(l_calling_fn, 'source table count', l_src_tbl.count
400: ,p_log_level_rec => p_log_level_rec);
401: end if;
402:
403:

Line 409: fa_debug_pkg.add(l_calling_fn, 'processing', 'destination'

405: -- and now for each destination
406: if (p_dest_trans_rec.transaction_header_id is not null) then
407:
408: if (p_log_level_rec.statement_level) then
409: fa_debug_pkg.add(l_calling_fn, 'processing', 'destination'
410: ,p_log_level_rec => p_log_level_rec);
411: end if;
412:
413: l_dest_asset_hdr_rec := p_dest_asset_hdr_rec;

Line 527: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first dest tbl: ', l_balancing_seg

523: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_balancing_seg);
524: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 2, l_sum_amount);
525:
526: if (p_log_level_rec.statement_level) then
527: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first dest tbl: ', l_balancing_seg
528: ,p_log_level_rec => p_log_level_rec);
529: fa_debug_pkg.add(l_calling_fn, 'sum_amount for first dest tbl: ', l_sum_amount
530: ,p_log_level_rec => p_log_level_rec);
531: end if;

Line 529: fa_debug_pkg.add(l_calling_fn, 'sum_amount for first dest tbl: ', l_sum_amount

525:
526: if (p_log_level_rec.statement_level) then
527: fa_debug_pkg.add(l_calling_fn, 'balancing_seg for first dest tbl: ', l_balancing_seg
528: ,p_log_level_rec => p_log_level_rec);
529: fa_debug_pkg.add(l_calling_fn, 'sum_amount for first dest tbl: ', l_sum_amount
530: ,p_log_level_rec => p_log_level_rec);
531: end if;
532:
533: -- add these values to the table

Line 542: fa_debug_pkg.add(l_calling_fn, 'dest table count', l_dest_tbl.count

538:
539: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
540:
541: if (p_log_level_rec.statement_level) then
542: fa_debug_pkg.add(l_calling_fn, 'dest table count', l_dest_tbl.count
543: ,p_log_level_rec => p_log_level_rec);
544: end if;
545:
546:

Line 553: fa_debug_pkg.add(l_calling_fn, 'not processing', 'destination'

549: l_dest_asset_hdr_rec := p_src_asset_hdr_rec;
550: l_dest_trans_rec := p_src_trans_rec;
551:
552: if (p_log_level_rec.statement_level) then
553: fa_debug_pkg.add(l_calling_fn, 'not processing', 'destination'
554: ,p_log_level_rec => p_log_level_rec);
555: end if;
556:
557: end if;

Line 565: fa_debug_pkg.add(l_calling_fn, 'summing', 'source amounts'

561: -- sum all accounts into a single amount per balancing segment
562: -- first create a new table indexed by balancing segment
563:
564: if (p_log_level_rec.statement_level) then
565: fa_debug_pkg.add(l_calling_fn, 'summing', 'source amounts'
566: ,p_log_level_rec => p_log_level_rec);
567: end if;
568:
569: for l_src_count in 1..l_src_tbl.count loop

Line 595: fa_debug_pkg.add(l_calling_fn, 'source summary table count', l_src_summary_tbl.count

591:
592: end loop;
593:
594: if (p_log_level_rec.statement_level) then
595: fa_debug_pkg.add(l_calling_fn, 'source summary table count', l_src_summary_tbl.count
596: ,p_log_level_rec => p_log_level_rec);
597: end if;
598:
599:

Line 604: fa_debug_pkg.add(l_calling_fn, 'summing', 'dest amounts'

600:
601: -- now do the same for the destination
602:
603: if (p_log_level_rec.statement_level) then
604: fa_debug_pkg.add(l_calling_fn, 'summing', 'dest amounts'
605: ,p_log_level_rec => p_log_level_rec);
606: end if;
607:
608: for l_dest_count in 1 ..l_dest_tbl.count loop

Line 635: fa_debug_pkg.add(l_calling_fn, 'dest summary table count', l_dest_summary_tbl.count

631:
632: end loop;
633:
634: if (p_log_level_rec.statement_level) then
635: fa_debug_pkg.add(l_calling_fn, 'dest summary table count', l_dest_summary_tbl.count
636: ,p_log_level_rec => p_log_level_rec);
637: end if;
638:
639:

Line 642: fa_debug_pkg.add(l_calling_fn, 'removing', 'source 0 amounts'

638:
639:
640: -- remove all the 0 amount rows
641: if (p_log_level_rec.statement_level) then
642: fa_debug_pkg.add(l_calling_fn, 'removing', 'source 0 amounts'
643: ,p_log_level_rec => p_log_level_rec);
644: end if;
645:
646: -- BUG# 3537535

Line 691: fa_debug_pkg.add(l_calling_fn, 'source summary table count', l_src_summary_tbl.count

687: end loop;
688: end loop;
689:
690: if (p_log_level_rec.statement_level) then
691: fa_debug_pkg.add(l_calling_fn, 'source summary table count', l_src_summary_tbl.count
692: ,p_log_level_rec => p_log_level_rec);
693: end if;
694:
695:

Line 700: fa_debug_pkg.add(l_calling_fn, 'removing', 'dest 0 amounts'

696:
697: -- same for dest
698:
699: if (p_log_level_rec.statement_level) then
700: fa_debug_pkg.add(l_calling_fn, 'removing', 'dest 0 amounts'
701: ,p_log_level_rec => p_log_level_rec);
702: end if;
703:
704: l_loop := TRUE;

Line 742: fa_debug_pkg.add(l_calling_fn, 'after', 'removing 0 cost dest rows'

738:
739: end loop;
740:
741: if (p_log_level_rec.statement_level) then
742: fa_debug_pkg.add(l_calling_fn, 'after', 'removing 0 cost dest rows'
743: ,p_log_level_rec => p_log_level_rec);
744: fa_debug_pkg.add(l_calling_fn, 'dest summary table count', l_dest_summary_tbl.count
745: ,p_log_level_rec => p_log_level_rec);
746: end if;

Line 744: fa_debug_pkg.add(l_calling_fn, 'dest summary table count', l_dest_summary_tbl.count

740:
741: if (p_log_level_rec.statement_level) then
742: fa_debug_pkg.add(l_calling_fn, 'after', 'removing 0 cost dest rows'
743: ,p_log_level_rec => p_log_level_rec);
744: fa_debug_pkg.add(l_calling_fn, 'dest summary table count', l_dest_summary_tbl.count
745: ,p_log_level_rec => p_log_level_rec);
746: end if;
747:
748:

Line 752: fa_debug_pkg.add(l_calling_fn, 'finding', 'balancing segment matches'

748:
749:
750: -- now find the matches
751: if (p_log_level_rec.statement_level) then
752: fa_debug_pkg.add(l_calling_fn, 'finding', 'balancing segment matches'
753: ,p_log_level_rec => p_log_level_rec);
754: end if;
755:
756: if (l_src_summary_tbl.count = 0 and

Line 761: fa_debug_pkg.add(l_calling_fn, 'no intercompany impacts found' ,''

757: l_dest_summary_tbl.count = 0) then
758:
759: -- no interco effects at all
760: if (p_log_level_rec.statement_level) then
761: fa_debug_pkg.add(l_calling_fn, 'no intercompany impacts found' ,''
762: ,p_log_level_rec => p_log_level_rec);
763: end if;
764:
765: raise done_exception;

Line 771: fa_debug_pkg.add(l_calling_fn, 'found: ', 'source intercompany impacts only'

767: elsif (l_dest_summary_tbl.count = 0) then
768:
769: -- one sided
770: if (p_log_level_rec.statement_level) then
771: fa_debug_pkg.add(l_calling_fn, 'found: ', 'source intercompany impacts only'
772: ,p_log_level_rec => p_log_level_rec);
773: end if;
774:
775: l_summary_tbl := l_src_summary_tbl;

Line 799: fa_debug_pkg.add(l_calling_fn, 'found: ', 'dest intercompany impacts only'

795: elsif (l_src_summary_tbl.count = 0) then -- THIS SHOULDN'T HAPPEN!!!!!!!!!!
796:
797: -- one sided
798: if (p_log_level_rec.statement_level) then
799: fa_debug_pkg.add(l_calling_fn, 'found: ', 'dest intercompany impacts only'
800: ,p_log_level_rec => p_log_level_rec);
801: end if;
802:
803: l_summary_tbl := l_dest_summary_tbl;

Line 812: fa_debug_pkg.add(l_calling_fn, 'found: ', 'source and destination intercompany impacts'

808: -- cross asset intercompany effects
809: -- need to determine overall impacts
810:
811: if (p_log_level_rec.statement_level) then
812: fa_debug_pkg.add(l_calling_fn, 'found: ', 'source and destination intercompany impacts'
813: ,p_log_level_rec => p_log_level_rec);
814: end if;
815:
816: l_summary_tbl := l_src_summary_tbl;

Line 834: fa_debug_pkg.add(l_calling_fn, 'combining: ', 'source and destination impacts'

830: --
831: -- but this premise wouldn't work for intra-asset effects (like add/adj)
832:
833: if (p_log_level_rec.statement_level) then
834: fa_debug_pkg.add(l_calling_fn, 'combining: ', 'source and destination impacts'
835: ,p_log_level_rec => p_log_level_rec);
836: end if;
837:
838:

Line 893: fa_debug_pkg.add(l_calling_fn, 'summary table count', l_summary_tbl.count

889:
890: end loop;
891:
892: if (p_log_level_rec.statement_level) then
893: fa_debug_pkg.add(l_calling_fn, 'summary table count', l_summary_tbl.count
894: ,p_log_level_rec => p_log_level_rec);
895: end if;
896:
897:

Line 901: fa_debug_pkg.add(l_calling_fn, 'removing: ', '0 amount summary intercompany lines'

897:
898:
899: -- remove all the 0 amount rows
900: if (p_log_level_rec.statement_level) then
901: fa_debug_pkg.add(l_calling_fn, 'removing: ', '0 amount summary intercompany lines'
902: ,p_log_level_rec => p_log_level_rec);
903: end if;
904:
905:

Line 944: fa_debug_pkg.add(l_calling_fn, 'summary table count', l_summary_tbl.count

940:
941: end loop;
942:
943: if (p_log_level_rec.statement_level) then
944: fa_debug_pkg.add(l_calling_fn, 'summary table count', l_summary_tbl.count
945: ,p_log_level_rec => p_log_level_rec);
946: end if;
947:
948: end if;

Line 952: fa_debug_pkg.add(l_calling_fn, 'setting up for: ', 'faxinaj calls'

948: end if;
949:
950: -- load the constant values for each asset
951: if (p_log_level_rec.statement_level) then
952: fa_debug_pkg.add(l_calling_fn, 'setting up for: ', 'faxinaj calls'
953: ,p_log_level_rec => p_log_level_rec);
954: end if;
955:
956:

Line 996: fa_debug_pkg.add(l_calling_fn, 'src source_type_code', l_src_source_type_code

992: l_dest_source_type_code := 'ADJUSTMENT';
993: end if;
994:
995: if (p_log_level_rec.statement_level) then
996: fa_debug_pkg.add(l_calling_fn, 'src source_type_code', l_src_source_type_code
997: ,p_log_level_rec => p_log_level_rec);
998: fa_debug_pkg.add(l_calling_fn, 'dest source_type_code', l_dest_source_type_code
999: ,p_log_level_rec => p_log_level_rec);
1000: end if;

Line 998: fa_debug_pkg.add(l_calling_fn, 'dest source_type_code', l_dest_source_type_code

994:
995: if (p_log_level_rec.statement_level) then
996: fa_debug_pkg.add(l_calling_fn, 'src source_type_code', l_src_source_type_code
997: ,p_log_level_rec => p_log_level_rec);
998: fa_debug_pkg.add(l_calling_fn, 'dest source_type_code', l_dest_source_type_code
999: ,p_log_level_rec => p_log_level_rec);
1000: end if;
1001:
1002: l_adj.period_counter_created := fa_cache_pkg.fazcbc_record.last_period_counter + 1;

Line 1027: fa_debug_pkg.add(l_calling_fn, 'looping: ', 'through summary interco records'

1023: -- and destination. If the src and destination share even a portion
1024: -- between the same segment, the interco values will cascade to all of them
1025:
1026: if (p_log_level_rec.statement_level) then
1027: fa_debug_pkg.add(l_calling_fn, 'looping: ', 'through summary interco records'
1028: ,p_log_level_rec => p_log_level_rec);
1029: fa_debug_pkg.add(l_calling_fn, 'summary_tbl.count: ', l_summary_tbl.count
1030: ,p_log_level_rec => p_log_level_rec);
1031: end if;

Line 1029: fa_debug_pkg.add(l_calling_fn, 'summary_tbl.count: ', l_summary_tbl.count

1025:
1026: if (p_log_level_rec.statement_level) then
1027: fa_debug_pkg.add(l_calling_fn, 'looping: ', 'through summary interco records'
1028: ,p_log_level_rec => p_log_level_rec);
1029: fa_debug_pkg.add(l_calling_fn, 'summary_tbl.count: ', l_summary_tbl.count
1030: ,p_log_level_rec => p_log_level_rec);
1031: end if;
1032:
1033: for l_summary_count in 1..l_summary_tbl.count loop

Line 1036: fa_debug_pkg.add(l_calling_fn, 'looping through summary records, count: ', l_summary_count

1032:
1033: for l_summary_count in 1..l_summary_tbl.count loop
1034:
1035: if (p_log_level_rec.statement_level) then
1036: fa_debug_pkg.add(l_calling_fn, 'looping through summary records, count: ', l_summary_count
1037: ,p_log_level_rec => p_log_level_rec);
1038: fa_debug_pkg.add(l_calling_fn, 'summary amount', l_summary_tbl(l_summary_count).amount);
1039: end if;
1040:

Line 1038: fa_debug_pkg.add(l_calling_fn, 'summary amount', l_summary_tbl(l_summary_count).amount);

1034:
1035: if (p_log_level_rec.statement_level) then
1036: fa_debug_pkg.add(l_calling_fn, 'looping through summary records, count: ', l_summary_count
1037: ,p_log_level_rec => p_log_level_rec);
1038: fa_debug_pkg.add(l_calling_fn, 'summary amount', l_summary_tbl(l_summary_count).amount);
1039: end if;
1040:
1041: l_dist_tbl.delete;
1042: l_dist_tbl_count := 0;

Line 1096: fa_debug_pkg.add(l_calling_fn, 'dist cursor: ', 'no more rows fetched'

1092: if DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 then
1093:
1094:
1095: if (p_log_level_rec.statement_level) then
1096: fa_debug_pkg.add(l_calling_fn, 'dist cursor: ', 'no more rows fetched'
1097: ,p_log_level_rec => p_log_level_rec);
1098: end if;
1099:
1100: -- get total units

Line 1107: fa_debug_pkg.add(l_calling_fn, 'dist cursor: ', 'looping through dists'

1103: l_total_units := l_total_units + l_dist_tbl(l_dist_count).units;
1104: end loop;
1105:
1106: if (p_log_level_rec.statement_level) then
1107: fa_debug_pkg.add(l_calling_fn, 'dist cursor: ', 'looping through dists'
1108: ,p_log_level_rec => p_log_level_rec);
1109: end if;
1110:
1111: for l_dist_count in 1..l_dist_tbl.count loop

Line 1116: fa_debug_pkg.add(l_calling_fn, 'inside ', 'dist loop'

1112: -- process the rows into fa_adj for that balancing segment
1113: -- call faxinaj to insert the amounts (flush them too)
1114:
1115: if (p_log_level_rec.statement_level) then
1116: fa_debug_pkg.add(l_calling_fn, 'inside ', 'dist loop'
1117: ,p_log_level_rec => p_log_level_rec);
1118: end if;
1119:
1120: l_adj.code_combination_id := l_dist_tbl(l_dist_count).code_combination_id;

Line 1124: fa_debug_pkg.add(l_calling_fn, 'l_summary_tbl(l_summary_count).amount', l_summary_tbl(l_summary_count).amount);

1120: l_adj.code_combination_id := l_dist_tbl(l_dist_count).code_combination_id;
1121: l_adj.distribution_id := l_dist_tbl(l_dist_count).distribution_id;
1122:
1123: if (p_log_level_rec.statement_level) then
1124: fa_debug_pkg.add(l_calling_fn, 'l_summary_tbl(l_summary_count).amount', l_summary_tbl(l_summary_count).amount);
1125: fa_debug_pkg.add(l_calling_fn, 'l_total_prorated_amount',l_total_prorated_amount
1126: ,p_log_level_rec => p_log_level_rec);
1127: fa_debug_pkg.add(l_calling_fn, 'l_total_units', l_total_units
1128: ,p_log_level_rec => p_log_level_rec);

Line 1125: fa_debug_pkg.add(l_calling_fn, 'l_total_prorated_amount',l_total_prorated_amount

1121: l_adj.distribution_id := l_dist_tbl(l_dist_count).distribution_id;
1122:
1123: if (p_log_level_rec.statement_level) then
1124: fa_debug_pkg.add(l_calling_fn, 'l_summary_tbl(l_summary_count).amount', l_summary_tbl(l_summary_count).amount);
1125: fa_debug_pkg.add(l_calling_fn, 'l_total_prorated_amount',l_total_prorated_amount
1126: ,p_log_level_rec => p_log_level_rec);
1127: fa_debug_pkg.add(l_calling_fn, 'l_total_units', l_total_units
1128: ,p_log_level_rec => p_log_level_rec);
1129: fa_debug_pkg.add(l_calling_fn, 'l_dist_tbl(l_dist_count).units', l_dist_tbl(l_dist_count).units);

Line 1127: fa_debug_pkg.add(l_calling_fn, 'l_total_units', l_total_units

1123: if (p_log_level_rec.statement_level) then
1124: fa_debug_pkg.add(l_calling_fn, 'l_summary_tbl(l_summary_count).amount', l_summary_tbl(l_summary_count).amount);
1125: fa_debug_pkg.add(l_calling_fn, 'l_total_prorated_amount',l_total_prorated_amount
1126: ,p_log_level_rec => p_log_level_rec);
1127: fa_debug_pkg.add(l_calling_fn, 'l_total_units', l_total_units
1128: ,p_log_level_rec => p_log_level_rec);
1129: fa_debug_pkg.add(l_calling_fn, 'l_dist_tbl(l_dist_count).units', l_dist_tbl(l_dist_count).units);
1130: end if;
1131:

Line 1129: fa_debug_pkg.add(l_calling_fn, 'l_dist_tbl(l_dist_count).units', l_dist_tbl(l_dist_count).units);

1125: fa_debug_pkg.add(l_calling_fn, 'l_total_prorated_amount',l_total_prorated_amount
1126: ,p_log_level_rec => p_log_level_rec);
1127: fa_debug_pkg.add(l_calling_fn, 'l_total_units', l_total_units
1128: ,p_log_level_rec => p_log_level_rec);
1129: fa_debug_pkg.add(l_calling_fn, 'l_dist_tbl(l_dist_count).units', l_dist_tbl(l_dist_count).units);
1130: end if;
1131:
1132: if (l_dist_count = l_dist_tbl.count) then
1133:

Line 1150: fa_debug_pkg.add(l_calling_fn, 'l_adj.adj_amount', l_adj.adjustment_amount

1146:
1147: end if;
1148:
1149: if (p_log_level_rec.statement_level) then
1150: fa_debug_pkg.add(l_calling_fn, 'l_adj.adj_amount', l_adj.adjustment_amount
1151: ,p_log_level_rec => p_log_level_rec);
1152: fa_debug_pkg.add(l_calling_fn, 'setting up ', 'local variables'
1153: ,p_log_level_rec => p_log_level_rec);
1154: end if;

Line 1152: fa_debug_pkg.add(l_calling_fn, 'setting up ', 'local variables'

1148:
1149: if (p_log_level_rec.statement_level) then
1150: fa_debug_pkg.add(l_calling_fn, 'l_adj.adj_amount', l_adj.adjustment_amount
1151: ,p_log_level_rec => p_log_level_rec);
1152: fa_debug_pkg.add(l_calling_fn, 'setting up ', 'local variables'
1153: ,p_log_level_rec => p_log_level_rec);
1154: end if;
1155:
1156: if (l_summary_tbl(l_summary_count).type = 'SRC') then

Line 1158: fa_debug_pkg.add(l_calling_fn, 'processing', 'src'

1154: end if;
1155:
1156: if (l_summary_tbl(l_summary_count).type = 'SRC') then
1157: if (p_log_level_rec.statement_level) then
1158: fa_debug_pkg.add(l_calling_fn, 'processing', 'src'
1159: ,p_log_level_rec => p_log_level_rec);
1160: end if;
1161:
1162: l_adj.transaction_header_id := p_src_trans_rec.transaction_header_id;

Line 1170: fa_debug_pkg.add(l_calling_fn, 'source_type_code', l_src_source_type_code

1166: l_adj.adjustment_type := 'INTERCO AR';
1167: l_adj.account_type := 'AR_INTERCOMPANY_ACCT';
1168: l_adj.account := l_interco_ar_acct;
1169: if (p_log_level_rec.statement_level) then
1170: fa_debug_pkg.add(l_calling_fn, 'source_type_code', l_src_source_type_code
1171: ,p_log_level_rec => p_log_level_rec);
1172: end if;
1173:
1174: l_adj.source_type_code := l_src_source_type_code;

Line 1178: fa_debug_pkg.add(l_calling_fn, 'processing', 'dest'

1174: l_adj.source_type_code := l_src_source_type_code;
1175:
1176: else
1177: if (p_log_level_rec.statement_level) then
1178: fa_debug_pkg.add(l_calling_fn, 'processing', 'dest'
1179: ,p_log_level_rec => p_log_level_rec);
1180: end if;
1181:
1182: -- need to use locals for intra-assets

Line 1195: fa_debug_pkg.add(l_calling_fn, 'calling: ', 'faxinaj'

1191: l_adj.source_type_code := l_dest_source_type_code;
1192: end if;
1193:
1194: if (p_log_level_rec.statement_level) then
1195: fa_debug_pkg.add(l_calling_fn, 'calling: ', 'faxinaj'
1196: ,p_log_level_rec => p_log_level_rec);
1197: end if;
1198:
1199: if not FA_INS_ADJUST_PKG.faxinaj

Line 1215: fa_debug_pkg.add(l_calling_fn, 'populating: ', 'values from dist cursor'

1211:
1212: end if;
1213:
1214: if (p_log_level_rec.statement_level) then
1215: fa_debug_pkg.add(l_calling_fn, 'populating: ', 'values from dist cursor'
1216: ,p_log_level_rec => p_log_level_rec);
1217: end if;
1218:
1219: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_distribution_id);

Line 1305: fa_debug_pkg.add(l_calling_fn, 'inside', 'validate interco code'

1301:
1302: begin
1303:
1304: if (p_log_level_rec.statement_level) then
1305: fa_debug_pkg.add(l_calling_fn, 'inside', 'validate interco code'
1306: ,p_log_level_rec => p_log_level_rec);
1307: end if;
1308:
1309: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;

Line 1343: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Segment Number', l_bal_segnum

1339: AND sat.segment_attribute_type = 'GL_BALANCING';
1340:
1341:
1342: if (p_log_level_rec.statement_level) then
1343: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Segment Number', l_bal_segnum
1344: ,p_log_level_rec => p_log_level_rec);
1345: fa_debug_pkg.add(l_calling_fn, 'transaction type code', p_trans_rec.transaction_type_code
1346: ,p_log_level_rec => p_log_level_rec);
1347: end if;

Line 1345: fa_debug_pkg.add(l_calling_fn, 'transaction type code', p_trans_rec.transaction_type_code

1341:
1342: if (p_log_level_rec.statement_level) then
1343: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Segment Number', l_bal_segnum
1344: ,p_log_level_rec => p_log_level_rec);
1345: fa_debug_pkg.add(l_calling_fn, 'transaction type code', p_trans_rec.transaction_type_code
1346: ,p_log_level_rec => p_log_level_rec);
1347: end if;
1348:
1349:

Line 1370: fa_debug_pkg.add(l_calling_fn, 'loading', 'dist table'

1366: if (p_asset_dist_tbl.count = 0) then
1367:
1368:
1369: if (p_log_level_rec.statement_level) then
1370: fa_debug_pkg.add(l_calling_fn, 'loading', 'dist table'
1371: ,p_log_level_rec => p_log_level_rec);
1372: end if;
1373:
1374: open c_asset_distributions;

Line 1393: fa_debug_pkg.add(l_calling_fn, 'using', 'provided dist table'

1389: close c_asset_distributions;
1390:
1391: else
1392: if (p_log_level_rec.statement_level) then
1393: fa_debug_pkg.add(l_calling_fn, 'using', 'provided dist table'
1394: ,p_log_level_rec => p_log_level_rec);
1395: end if;
1396:
1397: l_asset_dist_tbl := p_asset_dist_tbl;

Line 1429: fa_debug_pkg.add(l_calling_fn, 'executing', 'first dynamic sql'

1425: ' from gl_code_combinations glcc ' ||
1426: ' where code_combination_id in (' || l_ccid_string || ')';
1427:
1428: if (p_log_level_rec.statement_level) then
1429: fa_debug_pkg.add(l_calling_fn, 'executing', 'first dynamic sql'
1430: ,p_log_level_rec => p_log_level_rec);
1431: end if;
1432:
1433:

Line 1476: fa_debug_pkg.add(l_calling_fn, 'setting', 'second dynamic sql'

1472: -- from transfers/unit adjustments, not additions
1473:
1474:
1475: if (p_log_level_rec.statement_level) then
1476: fa_debug_pkg.add(l_calling_fn, 'setting', 'second dynamic sql'
1477: ,p_log_level_rec => p_log_level_rec);
1478: end if;
1479:
1480:

Line 1549: fa_debug_pkg.add(l_calling_fn, 'executing', 'second dynamic sql'

1545:
1546: end if;
1547:
1548: if (p_log_level_rec.statement_level) then
1549: fa_debug_pkg.add(l_calling_fn, 'executing', 'second dynamic sql'
1550: ,p_log_level_rec => p_log_level_rec);
1551: end if;
1552:
1553:

Line 1583: fa_debug_pkg.add(l_calling_fn, 'looking', 'for mismatches'

1579: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1580:
1581:
1582: if (p_log_level_rec.statement_level) then
1583: fa_debug_pkg.add(l_calling_fn, 'looking', 'for mismatches'
1584: ,p_log_level_rec => p_log_level_rec);
1585: end if;
1586:
1587:

Line 1671: fa_debug_pkg.add(l_calling_fn, 'inside', 'validate interco code'

1667:
1668: x_interco_impact := FALSE;
1669:
1670: if (p_log_level_rec.statement_level) then
1671: fa_debug_pkg.add(l_calling_fn, 'inside', 'validate interco code'
1672: ,p_log_level_rec => p_log_level_rec);
1673: end if;
1674:
1675: l_account_flex := fa_cache_pkg.fazcbc_record.ACCOUNTING_FLEX_STRUCTURE;

Line 1709: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Segment Number', l_bal_segnum

1705: AND sat.segment_attribute_type = 'GL_BALANCING';
1706:
1707:
1708: if (p_log_level_rec.statement_level) then
1709: fa_debug_pkg.add(l_calling_fn, 'GL Balancing Segment Number', l_bal_segnum
1710: ,p_log_level_rec => p_log_level_rec);
1711: end if;
1712:
1713:

Line 1734: fa_debug_pkg.add(l_calling_fn, 'loading', 'dist table'

1730: -- using the distirbution table parameter and flex api
1731: for i in 1..2 loop
1732:
1733: if (p_log_level_rec.statement_level) then
1734: fa_debug_pkg.add(l_calling_fn, 'loading', 'dist table'
1735: ,p_log_level_rec => p_log_level_rec);
1736: end if;
1737:
1738: if i = 1 then

Line 1762: fa_debug_pkg.add(l_calling_fn, 'building', 'ccid string'

1758:
1759: close c_asset_distributions;
1760:
1761: if (p_log_level_rec.statement_level) then
1762: fa_debug_pkg.add(l_calling_fn, 'building', 'ccid string'
1763: ,p_log_level_rec => p_log_level_rec);
1764: end if;
1765:
1766: for l_ccid_tbl_count in 1..l_ccid_tbl.count loop

Line 1784: fa_debug_pkg.add(l_calling_fn, 'executing', 'first dynamic sql'

1780: ' from gl_code_combinations glcc ' ||
1781: ' where code_combination_id in (' || l_ccid_string || ')';
1782:
1783: if (p_log_level_rec.statement_level) then
1784: fa_debug_pkg.add(l_calling_fn, 'executing', 'first dynamic sql'
1785: ,p_log_level_rec => p_log_level_rec);
1786: end if;
1787:
1788: -- execute the statment

Line 1822: fa_debug_pkg.add(l_calling_fn, 'looking', 'for mismatches'

1818: end loop; -- this ends the fixed two time loop (src and dest)
1819:
1820:
1821: if (p_log_level_rec.statement_level) then
1822: fa_debug_pkg.add(l_calling_fn, 'looking', 'for mismatches'
1823: ,p_log_level_rec => p_log_level_rec);
1824: end if;
1825:
1826: -- look for any mismatches