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_CHK_BOOKSTS_PKG dependencies on FA_CACHE_PKG

Line 182: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;

178: bc.mass_request_id is not null);
179:
180: BEGIN
181:
182: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
183: h_last_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter;
184: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
185:
186: if not fa_cache_pkg.fazcsob

Line 183: h_last_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter;

179:
180: BEGIN
181:
182: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
183: h_last_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter;
184: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
185:
186: if not fa_cache_pkg.fazcsob
187: (X_set_of_books_id => h_set_of_books_id,

Line 184: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;

180: BEGIN
181:
182: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
183: h_last_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter;
184: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
185:
186: if not fa_cache_pkg.fazcsob
187: (X_set_of_books_id => h_set_of_books_id,
188: X_mrc_sob_type_code => h_mrc_sob_type_code,

Line 186: if not fa_cache_pkg.fazcsob

182: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
183: h_last_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter;
184: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
185:
186: if not fa_cache_pkg.fazcsob
187: (X_set_of_books_id => h_set_of_books_id,
188: X_mrc_sob_type_code => h_mrc_sob_type_code,
189: p_log_level_rec => p_log_level_rec) then
190: fa_srvr_msg.add_sql_error

Line 363: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then

359: --
360: -- It gets set to FALSE if non-complete process is running on the book,
361: -- fail to obtain lock for the book, or unknown error occurs, etc
362:
363: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
364: raise ERROR_FOUND;
365: end if;
366:
367: h_class_str := fa_cache_pkg.fazcbc_record.book_class;

Line 367: h_class_str := fa_cache_pkg.fazcbc_record.book_class;

363: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
364: raise ERROR_FOUND;
365: end if;
366:
367: h_class_str := fa_cache_pkg.fazcbc_record.book_class;
368: h_allow_cip_assets_flag := fa_cache_pkg.fazcbc_record.allow_cip_assets_flag;
369:
370: -- set savepoint, so that we can rollback when error occurs
371:

Line 368: h_allow_cip_assets_flag := fa_cache_pkg.fazcbc_record.allow_cip_assets_flag;

364: raise ERROR_FOUND;
365: end if;
366:
367: h_class_str := fa_cache_pkg.fazcbc_record.book_class;
368: h_allow_cip_assets_flag := fa_cache_pkg.fazcbc_record.allow_cip_assets_flag;
369:
370: -- set savepoint, so that we can rollback when error occurs
371:
372: if (NOT faxsav(X_action => 'S',

Line 480: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book,

476: end if;
477: end if;
478:
479: -- put the main book back on cache
480: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book,
481: p_log_level_rec => p_log_level_rec)) then
482: raise ERROR_FOUND;
483: end if;
484:

Line 560: if not fa_cache_pkg.fazcdp

556: -- also adding the new deprn period cache to this as well
557: --
558: -- -- bridgway 08/01/01
559:
560: if not fa_cache_pkg.fazcdp
561: (x_book_type_code => x_book,
562: p_log_level_rec => p_log_level_rec) then
563: return false;
564: end if;

Line 597: nvl(FA_CACHE_PKG.fazcbc_record.last_period_counter, -99) OR

593: from fa_book_controls
594: where book_type_code = X_book;
595:
596: if (nvl(h_last_period_ctr, -99) <>
597: nvl(FA_CACHE_PKG.fazcbc_record.last_period_counter, -99) OR
598: nvl(h_deprn_stat, 'X') <>
599: nvl(FA_CACHE_PKG.fazcbc_record.deprn_status, 'X') OR
600: nvl(h_deprn_req_id, -99) <>
601: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR

Line 599: nvl(FA_CACHE_PKG.fazcbc_record.deprn_status, 'X') OR

595:
596: if (nvl(h_last_period_ctr, -99) <>
597: nvl(FA_CACHE_PKG.fazcbc_record.last_period_counter, -99) OR
598: nvl(h_deprn_stat, 'X') <>
599: nvl(FA_CACHE_PKG.fazcbc_record.deprn_status, 'X') OR
600: nvl(h_deprn_req_id, -99) <>
601: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR
602: nvl(h_mass_req_id, -99) <>
603: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR

Line 601: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR

597: nvl(FA_CACHE_PKG.fazcbc_record.last_period_counter, -99) OR
598: nvl(h_deprn_stat, 'X') <>
599: nvl(FA_CACHE_PKG.fazcbc_record.deprn_status, 'X') OR
600: nvl(h_deprn_req_id, -99) <>
601: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR
602: nvl(h_mass_req_id, -99) <>
603: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR
604: nvl(h_sob_id, -99) <>
605: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR

Line 603: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR

599: nvl(FA_CACHE_PKG.fazcbc_record.deprn_status, 'X') OR
600: nvl(h_deprn_req_id, -99) <>
601: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR
602: nvl(h_mass_req_id, -99) <>
603: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR
604: nvl(h_sob_id, -99) <>
605: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR
606: nvl(h_mc_source_flag, 'X') <>
607: nvl(FA_CACHE_PKG.fazcbc_record.mc_source_flag, 'X') OR

Line 605: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR

601: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR
602: nvl(h_mass_req_id, -99) <>
603: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR
604: nvl(h_sob_id, -99) <>
605: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR
606: nvl(h_mc_source_flag, 'X') <>
607: nvl(FA_CACHE_PKG.fazcbc_record.mc_source_flag, 'X') OR
608: nvl(h_allow_cip_assets, 'X') <>
609: nvl(FA_CACHE_PKG.fazcbc_record.allow_cip_assets_flag, 'X')) then

Line 607: nvl(FA_CACHE_PKG.fazcbc_record.mc_source_flag, 'X') OR

603: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR
604: nvl(h_sob_id, -99) <>
605: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR
606: nvl(h_mc_source_flag, 'X') <>
607: nvl(FA_CACHE_PKG.fazcbc_record.mc_source_flag, 'X') OR
608: nvl(h_allow_cip_assets, 'X') <>
609: nvl(FA_CACHE_PKG.fazcbc_record.allow_cip_assets_flag, 'X')) then
610:
611: -- clear the book from the cache (member and array)

Line 609: nvl(FA_CACHE_PKG.fazcbc_record.allow_cip_assets_flag, 'X')) then

605: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR
606: nvl(h_mc_source_flag, 'X') <>
607: nvl(FA_CACHE_PKG.fazcbc_record.mc_source_flag, 'X') OR
608: nvl(h_allow_cip_assets, 'X') <>
609: nvl(FA_CACHE_PKG.fazcbc_record.allow_cip_assets_flag, 'X')) then
610:
611: -- clear the book from the cache (member and array)
612: if (NOT FA_CACHE_PKG.fazcbc_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
613: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);

Line 612: if (NOT FA_CACHE_PKG.fazcbc_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then

608: nvl(h_allow_cip_assets, 'X') <>
609: nvl(FA_CACHE_PKG.fazcbc_record.allow_cip_assets_flag, 'X')) then
610:
611: -- clear the book from the cache (member and array)
612: if (NOT FA_CACHE_PKG.fazcbc_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
613: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);
614: return(FALSE);
615: end if;
616:

Line 618: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then

614: return(FALSE);
615: end if;
616:
617: -- now recall it
618: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
619: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);
620: return(FALSE);
621: end if;
622: end if;

Line 624: if (FA_CACHE_PKG.fazcbc_record.last_period_counter + 1 <>

620: return(FALSE);
621: end if;
622: end if;
623:
624: if (FA_CACHE_PKG.fazcbc_record.last_period_counter + 1 <>
625: FA_CACHE_PKG.fazcdp_record.period_counter) then
626:
627: -- clear the book from the cache (member and array)
628: if (NOT FA_CACHE_PKG.fazcdp_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then

Line 625: FA_CACHE_PKG.fazcdp_record.period_counter) then

621: end if;
622: end if;
623:
624: if (FA_CACHE_PKG.fazcbc_record.last_period_counter + 1 <>
625: FA_CACHE_PKG.fazcdp_record.period_counter) then
626:
627: -- clear the book from the cache (member and array)
628: if (NOT FA_CACHE_PKG.fazcdp_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
629: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);

Line 628: if (NOT FA_CACHE_PKG.fazcdp_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then

624: if (FA_CACHE_PKG.fazcbc_record.last_period_counter + 1 <>
625: FA_CACHE_PKG.fazcdp_record.period_counter) then
626:
627: -- clear the book from the cache (member and array)
628: if (NOT FA_CACHE_PKG.fazcdp_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
629: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);
630: return(FALSE);
631: end if;
632:

Line 634: if (NOT FA_CACHE_PKG.fazcdp(X_book_type_code => X_book, p_log_level_rec => p_log_level_rec)) then

630: return(FALSE);
631: end if;
632:
633: -- now recall it
634: if (NOT FA_CACHE_PKG.fazcdp(X_book_type_code => X_book, p_log_level_rec => p_log_level_rec)) then
635: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);
636: return(FALSE);
637: end if;
638: end if;

Line 810: h_deprn_stat := FA_CACHE_PKG.fazcbc_record.deprn_status;

806: h_message varchar2(240);
807:
808: BEGIN
809:
810: h_deprn_stat := FA_CACHE_PKG.fazcbc_record.deprn_status;
811: h_deprn_req_id := FA_CACHE_PKG.fazcbc_record.deprn_request_id;
812: h_last_period_ctr := FA_CACHE_PKG.fazcbc_record.last_period_counter;
813:
814: if (h_deprn_stat = 'C') then -- status is completed, txn approved

Line 811: h_deprn_req_id := FA_CACHE_PKG.fazcbc_record.deprn_request_id;

807:
808: BEGIN
809:
810: h_deprn_stat := FA_CACHE_PKG.fazcbc_record.deprn_status;
811: h_deprn_req_id := FA_CACHE_PKG.fazcbc_record.deprn_request_id;
812: h_last_period_ctr := FA_CACHE_PKG.fazcbc_record.last_period_counter;
813:
814: if (h_deprn_stat = 'C') then -- status is completed, txn approved
815:

Line 812: h_last_period_ctr := FA_CACHE_PKG.fazcbc_record.last_period_counter;

808: BEGIN
809:
810: h_deprn_stat := FA_CACHE_PKG.fazcbc_record.deprn_status;
811: h_deprn_req_id := FA_CACHE_PKG.fazcbc_record.deprn_request_id;
812: h_last_period_ctr := FA_CACHE_PKG.fazcbc_record.last_period_counter;
813:
814: if (h_deprn_stat = 'C') then -- status is completed, txn approved
815:
816: -- BUG# 1924172

Line 978: h_mass_req_id := fa_cache_pkg.fazcbc_record.mass_request_id;

974:
975: BEGIN
976:
977: X_request_id := 0;
978: h_mass_req_id := fa_cache_pkg.fazcbc_record.mass_request_id;
979: h_conc_req_id := fnd_global.conc_request_id;
980:
981: if (h_mass_req_id IS NOT NULL) then
982:

Line 1084: h_ca_req_id := fa_cache_pkg.fazcbc_record.create_accounting_request_id;

1080:
1081: BEGIN
1082:
1083: X_request_id := 0;
1084: h_ca_req_id := fa_cache_pkg.fazcbc_record.create_accounting_request_id;
1085:
1086: if (h_ca_req_id IS NOT NULL) then
1087:
1088: -- check for status of this mass request id

Line 1175: if (NOT FA_CACHE_PKG.fazcbc(X_book => h_tax_book,

1171: fetch tax_cursor into h_tax_book;
1172: exit when tax_cursor%NOTFOUND;
1173:
1174: --call the cache to put the current tax book info in the record
1175: if (NOT FA_CACHE_PKG.fazcbc(X_book => h_tax_book,
1176: p_log_level_rec => p_log_level_rec)) then
1177: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxptb', p_log_level_rec => p_log_level_rec);
1178: return(FALSE);
1179: end if;

Line 1241: h_corp_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;

1237: h_tmp BOOLEAN;
1238:
1239: BEGIN
1240:
1241: h_corp_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
1242:
1243: -- call the cache to put the corp book info in the record
1244: if (NOT FA_CACHE_PKG.fazcbc(X_book => h_corp_book, p_log_level_rec => p_log_level_rec)) then
1245: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxgcb', p_log_level_rec => p_log_level_rec);

Line 1244: if (NOT FA_CACHE_PKG.fazcbc(X_book => h_corp_book, p_log_level_rec => p_log_level_rec)) then

1240:
1241: h_corp_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
1242:
1243: -- call the cache to put the corp book info in the record
1244: if (NOT FA_CACHE_PKG.fazcbc(X_book => h_corp_book, p_log_level_rec => p_log_level_rec)) then
1245: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxgcb', p_log_level_rec => p_log_level_rec);
1246: return(FALSE);
1247: end if;
1248:

Line 1570: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then

1566:
1567: -- need to call cache here because of the mass forms call
1568: -- faxcdr directly.
1569:
1570: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
1571: fa_srvr_msg.add_sql_error
1572: (calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);
1573: return (FALSE);
1574: end if;

Line 1576: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;

1572: (calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);
1573: return (FALSE);
1574: end if;
1575:
1576: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
1577: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
1578:
1579: if not fa_cache_pkg.fazcsob
1580: (X_set_of_books_id => h_set_of_books_id,

Line 1577: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;

1573: return (FALSE);
1574: end if;
1575:
1576: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
1577: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
1578:
1579: if not fa_cache_pkg.fazcsob
1580: (X_set_of_books_id => h_set_of_books_id,
1581: X_mrc_sob_type_code => h_mrc_sob_type_code,

Line 1579: if not fa_cache_pkg.fazcsob

1575:
1576: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
1577: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
1578:
1579: if not fa_cache_pkg.fazcsob
1580: (X_set_of_books_id => h_set_of_books_id,
1581: X_mrc_sob_type_code => h_mrc_sob_type_code,
1582: p_log_level_rec => p_log_level_rec) then
1583: fa_srvr_msg.add_sql_error