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 4: g_release number := fa_cache_pkg.fazarel_release;

1: PACKAGE BODY FA_CHK_BOOKSTS_PKG as
2: /* $Header: FAXCKBKB.pls 120.27 2011/10/13 14:01:14 dvjoshi ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: --
7: -- FUNCTION faxcbsx
8: --

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

174: bc.mass_request_id is not null);
175:
176: BEGIN
177:
178: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
179: h_last_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter;
180: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
181:
182: if not fa_cache_pkg.fazcsob

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

175:
176: BEGIN
177:
178: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
179: h_last_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter;
180: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
181:
182: if not fa_cache_pkg.fazcsob
183: (X_set_of_books_id => h_set_of_books_id,

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

176: BEGIN
177:
178: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
179: h_last_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter;
180: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
181:
182: if not fa_cache_pkg.fazcsob
183: (X_set_of_books_id => h_set_of_books_id,
184: X_mrc_sob_type_code => h_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then

Line 182: if not fa_cache_pkg.fazcsob

178: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
179: h_last_period_counter := FA_CACHE_PKG.fazcbc_record.last_period_counter;
180: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
181:
182: if not fa_cache_pkg.fazcsob
183: (X_set_of_books_id => h_set_of_books_id,
184: X_mrc_sob_type_code => h_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
185: fa_srvr_msg.add_sql_error
186: (calling_fn => 'fa_chk_booksts_pkg.faxcrb', p_log_level_rec => p_log_level_rec);

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

347: --
348: -- It gets set to FALSE if non-complete process is running on the book,
349: -- fail to obtain lock for the book, or unknown error occurs, etc
350:
351: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
352: raise ERROR_FOUND;
353: end if;
354:
355: h_class_str := fa_cache_pkg.fazcbc_record.book_class;

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

351: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
352: raise ERROR_FOUND;
353: end if;
354:
355: h_class_str := fa_cache_pkg.fazcbc_record.book_class;
356: h_allow_cip_assets_flag := fa_cache_pkg.fazcbc_record.allow_cip_assets_flag;
357:
358: -- set savepoint, so that we can rollback when error occurs
359:

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

352: raise ERROR_FOUND;
353: end if;
354:
355: h_class_str := fa_cache_pkg.fazcbc_record.book_class;
356: h_allow_cip_assets_flag := fa_cache_pkg.fazcbc_record.allow_cip_assets_flag;
357:
358: -- set savepoint, so that we can rollback when error occurs
359:
360: if (NOT faxsav(X_action => 'S',

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

463: end if;
464: end if;
465:
466: -- put the main book back on cache
467: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
468: raise ERROR_FOUND;
469: end if;
470:
471: -- check book status is complete and clear savepoint indicator for next txns,

Line 544: if not fa_cache_pkg.fazcdp

540: -- also adding the new deprn period cache to this as well
541: --
542: -- -- bridgway 08/01/01
543:
544: if not fa_cache_pkg.fazcdp
545: (x_book_type_code => x_book, p_log_level_rec => p_log_level_rec) then
546: return false;
547: end if;
548:

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

576: from fa_book_controls
577: where book_type_code = X_book;
578:
579: if (nvl(h_last_period_ctr, -99) <>
580: nvl(FA_CACHE_PKG.fazcbc_record.last_period_counter, -99) OR
581: nvl(h_deprn_stat, 'X') <>
582: nvl(FA_CACHE_PKG.fazcbc_record.deprn_status, 'X') OR
583: nvl(h_deprn_req_id, -99) <>
584: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR

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

578:
579: if (nvl(h_last_period_ctr, -99) <>
580: nvl(FA_CACHE_PKG.fazcbc_record.last_period_counter, -99) OR
581: nvl(h_deprn_stat, 'X') <>
582: nvl(FA_CACHE_PKG.fazcbc_record.deprn_status, 'X') OR
583: nvl(h_deprn_req_id, -99) <>
584: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR
585: nvl(h_mass_req_id, -99) <>
586: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR

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

580: nvl(FA_CACHE_PKG.fazcbc_record.last_period_counter, -99) OR
581: nvl(h_deprn_stat, 'X') <>
582: nvl(FA_CACHE_PKG.fazcbc_record.deprn_status, 'X') OR
583: nvl(h_deprn_req_id, -99) <>
584: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR
585: nvl(h_mass_req_id, -99) <>
586: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR
587: nvl(h_sob_id, -99) <>
588: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR

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

582: nvl(FA_CACHE_PKG.fazcbc_record.deprn_status, 'X') OR
583: nvl(h_deprn_req_id, -99) <>
584: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR
585: nvl(h_mass_req_id, -99) <>
586: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR
587: nvl(h_sob_id, -99) <>
588: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR
589: nvl(h_mc_source_flag, 'X') <>
590: nvl(FA_CACHE_PKG.fazcbc_record.mc_source_flag, 'X') OR

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

584: nvl(FA_CACHE_PKG.fazcbc_record.deprn_request_id, -99) OR
585: nvl(h_mass_req_id, -99) <>
586: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR
587: nvl(h_sob_id, -99) <>
588: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR
589: nvl(h_mc_source_flag, 'X') <>
590: nvl(FA_CACHE_PKG.fazcbc_record.mc_source_flag, 'X') OR
591: nvl(h_allow_cip_assets, 'X') <>
592: nvl(FA_CACHE_PKG.fazcbc_record.allow_cip_assets_flag, 'X')) then

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

586: nvl(FA_CACHE_PKG.fazcbc_record.mass_request_id, -99) OR
587: nvl(h_sob_id, -99) <>
588: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR
589: nvl(h_mc_source_flag, 'X') <>
590: nvl(FA_CACHE_PKG.fazcbc_record.mc_source_flag, 'X') OR
591: nvl(h_allow_cip_assets, 'X') <>
592: nvl(FA_CACHE_PKG.fazcbc_record.allow_cip_assets_flag, 'X')) then
593:
594: -- clear the book from the cache (member and array)

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

588: nvl(FA_CACHE_PKG.fazcbc_record.set_of_books_id, -99) OR
589: nvl(h_mc_source_flag, 'X') <>
590: nvl(FA_CACHE_PKG.fazcbc_record.mc_source_flag, 'X') OR
591: nvl(h_allow_cip_assets, 'X') <>
592: nvl(FA_CACHE_PKG.fazcbc_record.allow_cip_assets_flag, 'X')) then
593:
594: -- clear the book from the cache (member and array)
595: if (NOT FA_CACHE_PKG.fazcbc_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
596: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);

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

591: nvl(h_allow_cip_assets, 'X') <>
592: nvl(FA_CACHE_PKG.fazcbc_record.allow_cip_assets_flag, 'X')) then
593:
594: -- clear the book from the cache (member and array)
595: if (NOT FA_CACHE_PKG.fazcbc_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
596: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);
597: return(FALSE);
598: end if;
599:

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

597: return(FALSE);
598: end if;
599:
600: -- now recall it
601: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
602: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);
603: return(FALSE);
604: end if;
605: end if;

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

603: return(FALSE);
604: end if;
605: end if;
606:
607: if (FA_CACHE_PKG.fazcbc_record.last_period_counter + 1 <>
608: FA_CACHE_PKG.fazcdp_record.period_counter ) then
609:
610: -- clear the book from the cache (member and array)
611: if (NOT FA_CACHE_PKG.fazcdp_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then

Line 608: FA_CACHE_PKG.fazcdp_record.period_counter ) then

604: end if;
605: end if;
606:
607: if (FA_CACHE_PKG.fazcbc_record.last_period_counter + 1 <>
608: FA_CACHE_PKG.fazcdp_record.period_counter ) then
609:
610: -- clear the book from the cache (member and array)
611: if (NOT FA_CACHE_PKG.fazcdp_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
612: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);

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

607: if (FA_CACHE_PKG.fazcbc_record.last_period_counter + 1 <>
608: FA_CACHE_PKG.fazcdp_record.period_counter ) then
609:
610: -- clear the book from the cache (member and array)
611: if (NOT FA_CACHE_PKG.fazcdp_clr(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
612: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);
613: return(FALSE);
614: end if;
615:

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

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

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

782: h_message varchar2(240);
783:
784: BEGIN
785:
786: h_deprn_stat := FA_CACHE_PKG.fazcbc_record.deprn_status;
787: h_deprn_req_id := FA_CACHE_PKG.fazcbc_record.deprn_request_id;
788: h_last_period_ctr := FA_CACHE_PKG.fazcbc_record.last_period_counter;
789:
790: if (h_deprn_stat = 'C') then -- status is completed, txn approved

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

783:
784: BEGIN
785:
786: h_deprn_stat := FA_CACHE_PKG.fazcbc_record.deprn_status;
787: h_deprn_req_id := FA_CACHE_PKG.fazcbc_record.deprn_request_id;
788: h_last_period_ctr := FA_CACHE_PKG.fazcbc_record.last_period_counter;
789:
790: if (h_deprn_stat = 'C') then -- status is completed, txn approved
791:

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

784: BEGIN
785:
786: h_deprn_stat := FA_CACHE_PKG.fazcbc_record.deprn_status;
787: h_deprn_req_id := FA_CACHE_PKG.fazcbc_record.deprn_request_id;
788: h_last_period_ctr := FA_CACHE_PKG.fazcbc_record.last_period_counter;
789:
790: if (h_deprn_stat = 'C') then -- status is completed, txn approved
791:
792: -- BUG# 1924172

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

946:
947: BEGIN
948:
949: X_request_id := 0;
950: h_mass_req_id := fa_cache_pkg.fazcbc_record.mass_request_id;
951: h_conc_req_id := fnd_global.conc_request_id;
952:
953: if (h_mass_req_id IS NOT NULL) then
954:

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

1048:
1049: BEGIN
1050:
1051: X_request_id := 0;
1052: h_ca_req_id := fa_cache_pkg.fazcbc_record.create_accounting_request_id;
1053:
1054: if (h_ca_req_id IS NOT NULL) then
1055:
1056: -- check for status of this mass request id

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

1139: fetch tax_cursor into h_tax_book;
1140: exit when tax_cursor%NOTFOUND;
1141:
1142: --call the cache to put the current tax book info in the record
1143: if (NOT FA_CACHE_PKG.fazcbc(X_book => h_tax_book, p_log_level_rec => p_log_level_rec)) then
1144: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxptb', p_log_level_rec => p_log_level_rec);
1145: return(FALSE);
1146: end if;
1147:

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

1201: h_tmp BOOLEAN;
1202:
1203: BEGIN
1204:
1205: h_corp_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
1206:
1207: -- call the cache to put the corp book info in the record
1208: if (NOT FA_CACHE_PKG.fazcbc(X_book => h_corp_book, p_log_level_rec => p_log_level_rec)) then
1209: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxgcb', p_log_level_rec => p_log_level_rec);

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

1204:
1205: h_corp_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
1206:
1207: -- call the cache to put the corp book info in the record
1208: if (NOT FA_CACHE_PKG.fazcbc(X_book => h_corp_book, p_log_level_rec => p_log_level_rec)) then
1209: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxgcb', p_log_level_rec => p_log_level_rec);
1210: return(FALSE);
1211: end if;
1212:

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

1519:
1520: -- need to call cache here because of the mass forms call
1521: -- faxcdr directly.
1522:
1523: if (NOT FA_CACHE_PKG.fazcbc(X_book => X_book, p_log_level_rec => p_log_level_rec)) then
1524: fa_srvr_msg.add_sql_error
1525: (calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);
1526: return (FALSE);
1527: end if;

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

1525: (calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);
1526: return (FALSE);
1527: end if;
1528:
1529: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
1530: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
1531:
1532: if not fa_cache_pkg.fazcsob
1533: (X_set_of_books_id => h_set_of_books_id,

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

1526: return (FALSE);
1527: end if;
1528:
1529: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
1530: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
1531:
1532: if not fa_cache_pkg.fazcsob
1533: (X_set_of_books_id => h_set_of_books_id,
1534: X_mrc_sob_type_code => h_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then

Line 1532: if not fa_cache_pkg.fazcsob

1528:
1529: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;
1530: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
1531:
1532: if not fa_cache_pkg.fazcsob
1533: (X_set_of_books_id => h_set_of_books_id,
1534: X_mrc_sob_type_code => h_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
1535: fa_srvr_msg.add_sql_error
1536: (calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);