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_ASSET_SUMM_RPT_PKG dependencies on FND_FILE

Line 112: fnd_file.put_line(fnd_file.log,'Begin Original Amount::');

108: IS
109: ln_amount NUMBER;
110: BEGIN
111: BEGIN
112: fnd_file.put_line(fnd_file.log,'Begin Original Amount::');
113:
114: SELECT NVL(fdd.cost,0)
115: INTO ln_amount
116: FROM fa_deprn_detail fdd

Line 159: FND_FILE.PUT_LINE(FND_FILE.LOG,'In CURRENT_AMOUNT');

155: EXCEPTION
156: WHEN NO_DATA_FOUND THEN
157: ln_amount := 0;
158: WHEN OTHERS THEN
159: FND_FILE.PUT_LINE(FND_FILE.LOG,'In CURRENT_AMOUNT');
160: END;
161: RETURN ln_amount;
162: END CURRENT_AMOUNT;
163:

Line 214: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ADDITIONS_AMOUNT');

210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN
212: ln_amount := 0;
213: WHEN OTHERS THEN
214: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ADDITIONS_AMOUNT');
215: END;
216: IF ln_amount IS NULL THEN
217: ln_amount := 0;
218: END IF;

Line 267: FND_FILE.PUT_LINE(FND_FILE.LOG,'In RETIREMENT_AMOUNT');

263: EXCEPTION
264: WHEN NO_DATA_FOUND THEN
265: ln_amount := 0;
266: WHEN OTHERS THEN
267: FND_FILE.PUT_LINE(FND_FILE.LOG,'In RETIREMENT_AMOUNT');
268: END;
269: IF ln_amount IS NULL THEN
270: ln_amount := 0;
271: END IF;

Line 384: FND_FILE.PUT_LINE(FND_FILE.LOG,'In CHANGES_OF_ACCOUNTS');

380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN
382: ln_amount := 0;
383: WHEN OTHERS THEN
384: FND_FILE.PUT_LINE(FND_FILE.LOG,'In CHANGES_OF_ACCOUNTS');
385: END;
386: IF ln_amount IS NULL THEN
387: ln_amount := 0;
388: END IF;

Line 433: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ADJUSTMENT_AMOUNT');

429: EXCEPTION
430: WHEN NO_DATA_FOUND THEN
431: ln_amount := 0;
432: WHEN OTHERS THEN
433: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ADJUSTMENT_AMOUNT');
434: END;
435: IF ln_amount IS NULL THEN
436: ln_amount := 0;
437: END IF;

Line 486: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ADJUSTMENT_AMOUNT');

482: EXCEPTION
483: WHEN NO_DATA_FOUND THEN
484: ln_amount := 0;
485: WHEN OTHERS THEN
486: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ADJUSTMENT_AMOUNT');
487: END;
488: IF ln_amount IS NULL THEN
489: ln_amount := 0;
490: END IF;

Line 582: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ACCM_DEPRN_AMT (Inner)');

578: EXCEPTION
579: WHEN NO_DATA_FOUND THEN
580: ln_amount := 0;
581: WHEN OTHERS THEN
582: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ACCM_DEPRN_AMT (Inner)');
583: END;
584: WHEN TOO_MANY_ROWS THEN
585: SELECT MAX(fdd.deprn_reserve)
586: INTO ln_amount

Line 620: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ACCM_DEPRN_AMT');

616: AND fdh1.location_id = p_location_id_in
617: AND fds1.period_counter BETWEEN gn_lex_begin_period_counter AND gn_lex_end_period_counter
618: );
619: WHEN OTHERS THEN
620: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ACCM_DEPRN_AMT');
621: END;
622: IF ln_amount IS NULL THEN
623: ln_amount := 0;
624: END IF;

Line 661: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ACCM_DEPRN_AMT');

657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: ln_amount := 0;
660: WHEN OTHERS THEN
661: FND_FILE.PUT_LINE(FND_FILE.LOG,'In ACCM_DEPRN_AMT');
662: END;
663: IF ln_amount IS NULL THEN
664: ln_amount := 0;
665: END IF;

Line 706: FND_FILE.PUT_LINE(FND_FILE.LOG,'In NBV_VALUE');

702: EXCEPTION
703: WHEN NO_DATA_FOUND THEN
704: ln_amount := 0;
705: WHEN OTHERS THEN
706: FND_FILE.PUT_LINE(FND_FILE.LOG,'In NBV_VALUE');
707: END;
708: RETURN ln_amount;
709: END ACCM_DEPRN_AMT_PR_YEAR;
710:

Line 756: FND_FILE.PUT_LINE(FND_FILE.LOG,'In DEPRN_EXPENSE');

752: EXCEPTION
753: WHEN NO_DATA_FOUND THEN
754: ln_amount := 0;
755: WHEN OTHERS THEN
756: FND_FILE.PUT_LINE(FND_FILE.LOG,'In DEPRN_EXPENSE');
757: END;
758: IF ln_amount IS NULL THEN
759: ln_amount := 0;
760: END IF;

Line 809: FND_FILE.PUT_LINE(FND_FILE.LOG,'In RETIREMENT_AMOUNT');

805: EXCEPTION
806: WHEN NO_DATA_FOUND THEN
807: ln_amount := 0;
808: WHEN OTHERS THEN
809: FND_FILE.PUT_LINE(FND_FILE.LOG,'In RETIREMENT_AMOUNT');
810: END;
811: IF ln_amount IS NULL THEN
812: ln_amount := 0;
813: END IF;

Line 835: fnd_file.put_line(fnd_file.log,'gc_cat_flex_struc::'||gc_cat_flex_struc);

831: --*************************************************
832: SELECT FSC.category_flex_structure
833: INTO gc_cat_flex_struc
834: FROM fa_system_controls FSC;
835: fnd_file.put_line(fnd_file.log,'gc_cat_flex_struc::'||gc_cat_flex_struc);
836:
837: --*************************************************
838: --Used to obtain the Category Flexfield Columns
839: --dynamically

Line 873: fnd_file.put_line(fnd_file.log, 'gc_from_maj_seg::'||gc_from_maj_seg);

869: ELSE
870: gc_from_maj_seg := 'A';
871: gc_from_min_seg := 'A';
872: END IF;
873: fnd_file.put_line(fnd_file.log, 'gc_from_maj_seg::'||gc_from_maj_seg);
874: fnd_file.put_line(fnd_file.log, 'gc_from_min_seg::'||gc_from_min_seg);
875:
876: IF P_TO_CATEGORY IS NOT NULL AND TRIM(P_TO_CATEGORY) <> lc_separator THEN
877: gc_to_maj_seg := RTRIM(SUBSTR(P_TO_CATEGORY,1,INSTR(P_TO_CATEGORY,lc_separator)),lc_separator);

Line 874: fnd_file.put_line(fnd_file.log, 'gc_from_min_seg::'||gc_from_min_seg);

870: gc_from_maj_seg := 'A';
871: gc_from_min_seg := 'A';
872: END IF;
873: fnd_file.put_line(fnd_file.log, 'gc_from_maj_seg::'||gc_from_maj_seg);
874: fnd_file.put_line(fnd_file.log, 'gc_from_min_seg::'||gc_from_min_seg);
875:
876: IF P_TO_CATEGORY IS NOT NULL AND TRIM(P_TO_CATEGORY) <> lc_separator THEN
877: gc_to_maj_seg := RTRIM(SUBSTR(P_TO_CATEGORY,1,INSTR(P_TO_CATEGORY,lc_separator)),lc_separator);
878: gc_to_min_seg := LTRIM(SUBSTR(P_TO_CATEGORY,INSTR(P_TO_CATEGORY,lc_separator)),lc_separator);

Line 883: fnd_file.put_line(fnd_file.log, 'gc_to_maj_seg::'||gc_to_maj_seg);

879: ELSE
880: gc_to_maj_seg := 'Z';
881: gc_to_min_seg := 'Z';
882: END IF;
883: fnd_file.put_line(fnd_file.log, 'gc_to_maj_seg::'||gc_to_maj_seg);
884: fnd_file.put_line(fnd_file.log, 'gc_to_min_seg::'||gc_to_min_seg);
885:
886: IF P_ASSET_DETAILS IS NULL THEN
887: gc_asset_details := 'N';

Line 884: fnd_file.put_line(fnd_file.log, 'gc_to_min_seg::'||gc_to_min_seg);

880: gc_to_maj_seg := 'Z';
881: gc_to_min_seg := 'Z';
882: END IF;
883: fnd_file.put_line(fnd_file.log, 'gc_to_maj_seg::'||gc_to_maj_seg);
884: fnd_file.put_line(fnd_file.log, 'gc_to_min_seg::'||gc_to_min_seg);
885:
886: IF P_ASSET_DETAILS IS NULL THEN
887: gc_asset_details := 'N';
888: ELSE

Line 926: fnd_file.put_line(fnd_file.log,'gc_asset_details::'||gc_asset_details);

922: gc_category_where := ' ((fc.'||lc_maj_seg||' = '''||gc_from_maj_seg||''' AND fc.'||lc_min_seg||' BETWEEN '''||gc_from_min_seg||''' AND '''||gc_to_min_seg||'''))';
923: END IF;
924: END IF;
925:
926: fnd_file.put_line(fnd_file.log,'gc_asset_details::'||gc_asset_details);
927: fnd_file.put_line(fnd_file.log,'gc_category_where::'||gc_category_where);
928:
929: --*************************************************
930: --Used to obtain the Begin period data

Line 927: fnd_file.put_line(fnd_file.log,'gc_category_where::'||gc_category_where);

923: END IF;
924: END IF;
925:
926: fnd_file.put_line(fnd_file.log,'gc_asset_details::'||gc_asset_details);
927: fnd_file.put_line(fnd_file.log,'gc_category_where::'||gc_category_where);
928:
929: --*************************************************
930: --Used to obtain the Begin period data
931: --*************************************************

Line 942: fnd_file.put_line(fnd_file.log,'gn_lex_begin_period_counter::'||gn_lex_begin_period_counter);

938: FROM fa_deprn_periods FDP
939: WHERE FDP.book_type_code = P_BOOK_NAME
940: AND FDP.period_name = P_BEGIN_PERIOD;
941:
942: fnd_file.put_line(fnd_file.log,'gn_lex_begin_period_counter::'||gn_lex_begin_period_counter);
943: fnd_file.put_line(fnd_file.log,'gd_period_open_date::'||gd_period_open_date);
944: fnd_file.put_line(fnd_file.log,'P_BEGIN_PERIOD::'||P_BEGIN_PERIOD);
945:
946: --*************************************************

Line 943: fnd_file.put_line(fnd_file.log,'gd_period_open_date::'||gd_period_open_date);

939: WHERE FDP.book_type_code = P_BOOK_NAME
940: AND FDP.period_name = P_BEGIN_PERIOD;
941:
942: fnd_file.put_line(fnd_file.log,'gn_lex_begin_period_counter::'||gn_lex_begin_period_counter);
943: fnd_file.put_line(fnd_file.log,'gd_period_open_date::'||gd_period_open_date);
944: fnd_file.put_line(fnd_file.log,'P_BEGIN_PERIOD::'||P_BEGIN_PERIOD);
945:
946: --*************************************************
947: --Used to obtain the End period data

Line 944: fnd_file.put_line(fnd_file.log,'P_BEGIN_PERIOD::'||P_BEGIN_PERIOD);

940: AND FDP.period_name = P_BEGIN_PERIOD;
941:
942: fnd_file.put_line(fnd_file.log,'gn_lex_begin_period_counter::'||gn_lex_begin_period_counter);
943: fnd_file.put_line(fnd_file.log,'gd_period_open_date::'||gd_period_open_date);
944: fnd_file.put_line(fnd_file.log,'P_BEGIN_PERIOD::'||P_BEGIN_PERIOD);
945:
946: --*************************************************
947: --Used to obtain the End period data
948: --*************************************************

Line 959: fnd_file.put_line(fnd_file.log,'gn_lex_end_period_counter::'||gn_lex_end_period_counter);

955: FROM fa_deprn_periods FDP
956: WHERE FDP.book_type_code = P_BOOK_NAME
957: AND FDP.period_name = P_END_PERIOD;
958:
959: fnd_file.put_line(fnd_file.log,'gn_lex_end_period_counter::'||gn_lex_end_period_counter);
960: fnd_file.put_line(fnd_file.log,'gd_period_close_date::'||gd_period_close_date);
961: fnd_file.put_line(fnd_file.log,'gd_per_close_date::'||to_char(gd_per_close_date,'dd/mm/yyyy hh24:mi:ss'));
962: fnd_file.put_line(fnd_file.log,'P_END_PERIOD::'||P_END_PERIOD);
963:

Line 960: fnd_file.put_line(fnd_file.log,'gd_period_close_date::'||gd_period_close_date);

956: WHERE FDP.book_type_code = P_BOOK_NAME
957: AND FDP.period_name = P_END_PERIOD;
958:
959: fnd_file.put_line(fnd_file.log,'gn_lex_end_period_counter::'||gn_lex_end_period_counter);
960: fnd_file.put_line(fnd_file.log,'gd_period_close_date::'||gd_period_close_date);
961: fnd_file.put_line(fnd_file.log,'gd_per_close_date::'||to_char(gd_per_close_date,'dd/mm/yyyy hh24:mi:ss'));
962: fnd_file.put_line(fnd_file.log,'P_END_PERIOD::'||P_END_PERIOD);
963:
964: --*************************************************

Line 961: fnd_file.put_line(fnd_file.log,'gd_per_close_date::'||to_char(gd_per_close_date,'dd/mm/yyyy hh24:mi:ss'));

957: AND FDP.period_name = P_END_PERIOD;
958:
959: fnd_file.put_line(fnd_file.log,'gn_lex_end_period_counter::'||gn_lex_end_period_counter);
960: fnd_file.put_line(fnd_file.log,'gd_period_close_date::'||gd_period_close_date);
961: fnd_file.put_line(fnd_file.log,'gd_per_close_date::'||to_char(gd_per_close_date,'dd/mm/yyyy hh24:mi:ss'));
962: fnd_file.put_line(fnd_file.log,'P_END_PERIOD::'||P_END_PERIOD);
963:
964: --*************************************************
965: --Used to obtain the Book Controls data

Line 962: fnd_file.put_line(fnd_file.log,'P_END_PERIOD::'||P_END_PERIOD);

958:
959: fnd_file.put_line(fnd_file.log,'gn_lex_end_period_counter::'||gn_lex_end_period_counter);
960: fnd_file.put_line(fnd_file.log,'gd_period_close_date::'||gd_period_close_date);
961: fnd_file.put_line(fnd_file.log,'gd_per_close_date::'||to_char(gd_per_close_date,'dd/mm/yyyy hh24:mi:ss'));
962: fnd_file.put_line(fnd_file.log,'P_END_PERIOD::'||P_END_PERIOD);
963:
964: --*************************************************
965: --Used to obtain the Book Controls data
966: --*************************************************

Line 975: fnd_file.put_line(fnd_file.log,'gc_book_class::'||gc_book_class);

971: ,gc_acct_flex_struc
972: ,lc_ledger_id
973: FROM fa_book_controls FBC
974: WHERE FBC.book_type_code = P_BOOK_NAME;
975: fnd_file.put_line(fnd_file.log,'gc_book_class::'||gc_book_class);
976:
977: --*************************************************
978: --Used to obtain the Ledger Name AND Currency
979: --*************************************************

Line 986: fnd_file.put_line(fnd_file.log,'gc_ledger_name::'||gc_ledger_name);

982: INTO gc_ledger_name
983: ,gc_currency_code
984: FROM gl_ledgers GLED
985: WHERE GLED.ledger_id = lc_ledger_id;
986: fnd_file.put_line(fnd_file.log,'gc_ledger_name::'||gc_ledger_name);
987:
988: RETURN (TRUE);
989: END beforeReport;
990: