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.

[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on FA_CHK_BOOKSTS_PKG

Line 1: PACKAGE BODY FA_CHK_BOOKSTS_PKG as

1: PACKAGE BODY FA_CHK_BOOKSTS_PKG as
2: /* $Header: FAXCKBKB.pls 120.20.12010000.1 2008/07/28 13:19:38 appldev ship $ */
3:
4: --
5: -- FUNCTION faxcbsx

Line 25: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcbsx',

21: fa_debug_pkg.initialize;
22: end if;
23:
24: if (X_book is NULL) then
25: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcbsx',
26: name => 'FA_SHARED_ARGUMENTS',
27: token1 => 'PROGRAM',
28: value1 => 'CHECK_BOOK_STATUS',
29: p_log_level_rec => p_log_level_rec);

Line 43: fa_srvr_msg.add_message(calling_fn =>'FA_CHK_BOOKSTS_PKG.faxcbsx',

39: X_txn_status => h_txn_status,
40: X_close_period => X_close_period,
41: p_log_level_rec => p_log_level_rec)) then
42:
43: fa_srvr_msg.add_message(calling_fn =>'FA_CHK_BOOKSTS_PKG.faxcbsx',
44: name => 'FA_SHARED_END_WITH_ERROR',
45: token1 => 'PROGRAM',value1=>'CHECK_BOOK_STATUS',
46: p_log_level_rec => p_log_level_rec);
47: h_txn_status := FALSE;

Line 55: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcbsx','txn status',h_txn_status, p_log_level_rec);

51: -- h_txn_status, at this point, have value of TRUE if txn is approved
52: -- and FALSE if txn is not approved
53:
54: if (p_log_level_rec.statement_level) then
55: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcbsx','txn status',h_txn_status, p_log_level_rec);
56: end if;
57:
58: return(h_txn_status);
59:

Line 63: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcbsx',

59:
60: EXCEPTION
61: when others then
62:
63: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcbsx',
64: p_log_level_rec => p_log_level_rec);
65: return (FALSE);
66:
67: END faxcbsx;

Line 191: (calling_fn => 'fa_chk_booksts_pkg.faxcrb', p_log_level_rec => p_log_level_rec);

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
191: (calling_fn => 'fa_chk_booksts_pkg.faxcrb', p_log_level_rec => p_log_level_rec);
192: return(FALSE);
193: end if;
194:
195: if (p_log_level_rec.statement_level) then

Line 196: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',

192: return(FALSE);
193: end if;
194:
195: if (p_log_level_rec.statement_level) then
196: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',
197: 'sob_id',h_set_of_books_id, p_log_level_rec);
198: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',
199: 'reporting_type',h_mrc_sob_type_code, p_log_level_rec);
200: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',

Line 198: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',

194:
195: if (p_log_level_rec.statement_level) then
196: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',
197: 'sob_id',h_set_of_books_id, p_log_level_rec);
198: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',
199: 'reporting_type',h_mrc_sob_type_code, p_log_level_rec);
200: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',
201: 'last period counter',h_last_period_counter, p_log_level_rec);
202: end if;

Line 200: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',

196: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',
197: 'sob_id',h_set_of_books_id, p_log_level_rec);
198: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',
199: 'reporting_type',h_mrc_sob_type_code, p_log_level_rec);
200: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb',
201: 'last period counter',h_last_period_counter, p_log_level_rec);
202: end if;
203:
204: -- check to see if the efc conversion is in process

Line 218: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb','checking for ','Primary', p_log_level_rec);

214:
215: if (h_mrc_sob_type_code = 'P' and h_mc_source_flag = 'Y') then
216:
217: if (p_log_level_rec.statement_level) then
218: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb','checking for ','Primary', p_log_level_rec);
219: end if;
220:
221: -- check to see if mrc upgrade is in process for a reporting
222: -- book associated to this primary book

Line 240: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',

236: fetch check_reporting_deprn_close into h_count;
237: if (h_count > 0) then
238: h_approve := FALSE;
239: FA_SRVR_MSG.add_message
240: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
241: NAME => 'FA_MRC_REP_BOOK_DEP_NOT_RUN',
242: p_log_level_rec => p_log_level_rec);
243: end if;
244: close check_reporting_deprn_close;

Line 251: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',

247: fetch check_reporting_deprn_open into h_count;
248: if (h_count > 0) then
249: h_approve := FALSE;
250: FA_SRVR_MSG.add_message
251: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
252: NAME => 'FA_MRC_REP_BOOK_DEP_NOT_RUN',
253: p_log_level_rec => p_log_level_rec);
254: end if;
255: close check_reporting_deprn_open;

Line 269: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',

265: open check_reporting_mass;
266: fetch check_reporting_mass into h_count;
267: if (h_count > 0) then
268: FA_SRVR_MSG.add_message
269: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
270: NAME => 'FA_MRC_PRI_REP_PERIOD_DIFF',
271: p_log_level_rec => p_log_level_rec);
272: h_approve := FALSE;
273: end if;

Line 280: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',

276: open check_reporting_single;
277: fetch check_reporting_single into h_count;
278: if (h_count > 0) then
279: FA_SRVR_MSG.add_message
280: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
281: NAME => 'FA_MRC_PRI_REP_PERIOD_DIFF',
282: p_log_level_rec => p_log_level_rec);
283: h_approve := FALSE;
284: end if;

Line 294: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb','checking','reporting', p_log_level_rec);

290: -- or if a mass request is locking the primary book
291:
292: elsif (h_mrc_sob_type_code = 'R' and X_trx_type <> 'RB_DEP') then
293: if (p_log_level_rec.statement_level) then
294: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcrb','checking','reporting', p_log_level_rec);
295: end if;
296:
297: open check_primary_sync;
298: fetch check_primary_sync into h_count;

Line 301: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',

297: open check_primary_sync;
298: fetch check_primary_sync into h_count;
299: if (h_count > 0) then
300: FA_SRVR_MSG.add_message
301: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
302: NAME => 'FA_MRC_RUN_DEP_CORP_FIRST',
303: p_log_level_rec => p_log_level_rec);
304: h_approve := FALSE;
305: end if;

Line 314: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',

310:
311: EXCEPTION
312: WHEN conversion_exception THEN
313: FA_SRVR_MSG.add_message
314: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
315: NAME => 'FA_MRC_CONV_PROCESS',
316: p_log_level_rec => p_log_level_rec);
317: return(FALSE);
318:

Line 321: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',

317: return(FALSE);
318:
319: WHEN efc_conversion_exception THEN
320: FA_SRVR_MSG.add_message
321: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
322: NAME => 'FA_EFC_CONV_PROCESS',
323: p_log_level_rec => p_log_level_rec);
324: return(FALSE);
325:

Line 327: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcrb', p_log_level_rec => p_log_level_rec);

323: p_log_level_rec => p_log_level_rec);
324: return(FALSE);
325:
326: WHEN OTHERS THEN
327: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcrb', p_log_level_rec => p_log_level_rec);
328: return(FALSE);
329:
330: END faxcrb;
331:

Line 389: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcbs','txn_status after faxlck',X_txn_status, p_log_level_rec);

385: raise ERROR_FOUND;
386: end if;
387:
388: if (p_log_level_rec.statement_level) then
389: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcbs','txn_status after faxlck',X_txn_status, p_log_level_rec);
390: end if;
391:
392: -- X_txn_status is TRUE if nothing failed so far and check any
393: -- processes on this book

Line 412: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcbs','txn status after faxcps',

408: -- faxcps above returns X_txn_status false when process is in running, inactive,
409: -- or pending status
410:
411: if (p_log_level_rec.statement_level) then
412: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcbs','txn status after faxcps',
413: X_txn_status, p_log_level_rec);
414: end if;
415: if (X_txn_status) then
416:

Line 613: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);

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:
617: -- now recall it

Line 619: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);

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;
623:

Line 629: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);

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:
633: -- now recall it

Line 635: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxcps', p_log_level_rec => p_log_level_rec);

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;
639:

Line 645: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',

641: X_trx_type => X_trx_type,
642: X_asset_id => X_asset_id,
643: X_close_period => X_close_period,
644: p_log_level_rec => p_log_level_rec)) then
645: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
646: p_log_level_rec => p_log_level_rec);
647: return(FALSE);
648: end if;
649: end if;

Line 658: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',

654: X_asset_id => X_asset_id,
655: X_trx_type => X_trx_type,
656: X_txn_status => X_txn_status,
657: p_log_level_rec => p_log_level_rec)) then
658: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
659: p_log_level_rec => p_log_level_rec);
660: return(FALSE);
661: end if;
662:

Line 672: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',

668: -- check the status of mass request id, if any, in book_control
669: if(NOT faxcms(X_book => X_book,
670: X_request_id => h_request_id,
671: p_log_level_rec => p_log_level_rec)) then
672: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
673: p_log_level_rec => p_log_level_rec);
674: return(FALSE);
675: end if;
676:

Line 684: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',

680:
681: if(NOT faxcca(X_book => X_book,
682: X_request_id => h_ca_request_id,
683: p_log_level_rec => p_log_level_rec)) then
684: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
685: p_log_level_rec => p_log_level_rec);
686: return(FALSE);
687: end if;
688: else

Line 693: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','book',X_book, p_log_level_rec);

689: h_ca_request_id := 0;
690: end if;
691:
692: if (p_log_level_rec.statement_level) then
693: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','book',X_book, p_log_level_rec);
694: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','mass_request_id',
695: h_request_id, p_log_level_rec);
696: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','create_accounting_request_id',
697: h_ca_request_id, p_log_level_rec);

Line 694: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','mass_request_id',

690: end if;
691:
692: if (p_log_level_rec.statement_level) then
693: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','book',X_book, p_log_level_rec);
694: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','mass_request_id',
695: h_request_id, p_log_level_rec);
696: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','create_accounting_request_id',
697: h_ca_request_id, p_log_level_rec);
698: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','conc_request_id',

Line 696: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','create_accounting_request_id',

692: if (p_log_level_rec.statement_level) then
693: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','book',X_book, p_log_level_rec);
694: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','mass_request_id',
695: h_request_id, p_log_level_rec);
696: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','create_accounting_request_id',
697: h_ca_request_id, p_log_level_rec);
698: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','conc_request_id',
699: h_conc_request_id, p_log_level_rec);
700: end if;

Line 698: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','conc_request_id',

694: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','mass_request_id',
695: h_request_id, p_log_level_rec);
696: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','create_accounting_request_id',
697: h_ca_request_id, p_log_level_rec);
698: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcps','conc_request_id',
699: h_conc_request_id, p_log_level_rec);
700: end if;
701:
702: if (h_request_id <> 0 ) then

Line 704: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',

700: end if;
701:
702: if (h_request_id <> 0 ) then
703: -- req_id is in status of running,inactive,or pending
704: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
705: name => 'FA_TRXAPP_WAIT_REQUEST',
706: token1 => 'REQUEST_ID',
707: value1 => h_request_id,
708: token2 => 'BOOK',

Line 717: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',

713: p_log_level_rec => p_log_level_rec);
714: --rollback the lock, if any
715: elsif (h_ca_request_id <> 0) then
716: -- req_id is in status of running,inactive,or pending
717: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
718: name => 'FA_TRXAPP_WAIT_REQUEST',
719: token1 => 'REQUEST_ID',
720: value1 => h_ca_request_id,
721: token2 => 'BOOK',

Line 733: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',

729:
730: if (X_start and (h_request_id <> 0 or h_ca_request_id <> 0)) then
731: -- for now faxwcr will always return TRUE
732: if (NOT faxwcr(X_request_id => h_request_id, p_log_level_rec => p_log_level_rec)) then
733: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
734: p_log_level_rec => p_log_level_rec);
735: return(FALSE);
736: end if;
737: end if;

Line 743: fa_srvr_msg.add_sql_error(calling_fn=>'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);

739: return(TRUE);
740:
741: EXCEPTION
742: WHEN OTHERS THEN
743: fa_srvr_msg.add_sql_error(calling_fn=>'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);
744: return(FALSE);
745:
746: END faxcps;
747:

Line 851: fa_srvr_msg.add_message(calling_fn =>'fa_chk_booksts_pkg.faxcds',

847: if (h_dev_phase = 'PENDING' OR
848: h_dev_phase = 'INACTIVE' OR
849: h_dev_phase = 'RUNNING') then
850:
851: fa_srvr_msg.add_message(calling_fn =>'fa_chk_booksts_pkg.faxcds',
852: name => 'FA_TRXAPP_DEPRN_IS_RUNNING',
853: token1 =>'BOOK',
854: value1 =>X_book,
855: p_log_level_rec => p_log_level_rec);

Line 890: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcds',

886: h_error := TRUE;
887: end if;
888:
889: else
890: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcds',
891: name => 'FA_CONCURRENT_GET_STATUS',
892: p_log_level_rec => p_log_level_rec);
893: return(FALSE);
894: end if;

Line 910: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcds',

906:
907: -- This is a request for a mass process, no approval
908: -- because the last depreciation run failed.
909:
910: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcds',
911: name => 'FA_TRXAPP_DEPRN_FAILED',
912: token1 => 'BOOK',
913: value1 => X_book,
914: p_log_level_rec => p_log_level_rec);

Line 933: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcds',

929: end if;
930: return(TRUE);
931:
932: else -- unknown status
933: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcds',
934: name => 'FA_TRXAPP_UNKNOWN_STATUS',
935: token1 => 'STATUS',
936: value1 => h_deprn_stat,
937: p_log_level_rec => p_log_level_rec);

Line 946: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcds', p_log_level_rec => p_log_level_rec);

942: end if;
943:
944: EXCEPTION
945: when others then
946: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcds', p_log_level_rec => p_log_level_rec);
947: return(FALSE);
948: END faxcds;
949:
950:

Line 1035: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcms',

1031: X_request_id := h_mass_req_id;
1032: end if;
1033: end if;
1034: else
1035: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcms',
1036: name => 'FA_CONCURRENT_GET_STATUS');
1037: return(FALSE);
1038: end if;
1039: else -- same request based on parent

Line 1050: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcms','mass_request_id',

1046: X_request_id := 0;
1047: end if;
1048:
1049: if (p_log_level_rec.statement_level) then
1050: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcms','mass_request_id',
1051: h_mass_req_id, p_log_level_rec);
1052: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcms','status',h_dev_phase, p_log_level_rec);
1053: end if;
1054:

Line 1052: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcms','status',h_dev_phase, p_log_level_rec);

1048:
1049: if (p_log_level_rec.statement_level) then
1050: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcms','mass_request_id',
1051: h_mass_req_id, p_log_level_rec);
1052: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcms','status',h_dev_phase, p_log_level_rec);
1053: end if;
1054:
1055: return(TRUE);
1056:

Line 1059: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcms', p_log_level_rec => p_log_level_rec);

1055: return(TRUE);
1056:
1057: EXCEPTION
1058: WHEN OTHERS THEN
1059: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcms', p_log_level_rec => p_log_level_rec);
1060: return(FALSE);
1061:
1062: END faxcms;
1063:

Line 1119: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcms',

1115: X_request_id := h_ca_req_id;
1116: end if;
1117: end if;
1118: else
1119: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcms',
1120: name => 'FA_CONCURRENT_GET_STATUS');
1121: return(FALSE);
1122: end if;
1123: else -- no request is locking book

Line 1128: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcca','create_accounting_request_id',

1124: X_request_id := 0;
1125: end if;
1126:
1127: if (p_log_level_rec.statement_level) then
1128: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcca','create_accounting_request_id',
1129: h_ca_req_id, p_log_level_rec);
1130: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcca','status',h_dev_phase, p_log_level_rec);
1131: end if;
1132:

Line 1130: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcca','status',h_dev_phase, p_log_level_rec);

1126:
1127: if (p_log_level_rec.statement_level) then
1128: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcca','create_accounting_request_id',
1129: h_ca_req_id, p_log_level_rec);
1130: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcca','status',h_dev_phase, p_log_level_rec);
1131: end if;
1132:
1133: return(TRUE);
1134:

Line 1137: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcca', p_log_level_rec => p_log_level_rec);

1133: return(TRUE);
1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcca', p_log_level_rec => p_log_level_rec);
1138: return(FALSE);
1139:
1140: END faxcca;
1141:

Line 1177: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxptb', p_log_level_rec => p_log_level_rec);

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;
1180:
1181: if (NOT faxlck(X_book => h_tax_book,

Line 1186: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.PKG.faxptb',

1182: X_txn_status => X_txn_status,
1183: X_asset_id => X_asset_id,
1184: X_trx_type => X_trx_type,
1185: p_log_level_rec => p_log_level_rec)) then -- lock the tax book
1186: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.PKG.faxptb',
1187: p_log_level_rec => p_log_level_rec);
1188: h_retval := FALSE;
1189: exit;
1190: end if;

Line 1201: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxptb',

1197: X_trx_type => X_trx_type,
1198: X_txn_status => X_txn_status,
1199: X_close_period => 0,
1200: p_log_level_rec => p_log_level_rec)) then
1201: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxptb',
1202: p_log_level_rec => p_log_level_rec);
1203: h_retval := FALSE;
1204: exit;
1205: end if;

Line 1208: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxptb','book',h_tax_book, p_log_level_rec);

1204: exit;
1205: end if;
1206:
1207: if (p_log_level_rec.statement_level) then
1208: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxptb','book',h_tax_book, p_log_level_rec);
1209: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxptb','txn_status',X_txn_status, p_log_level_rec);
1210: end if;
1211: end loop;
1212:

Line 1209: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxptb','txn_status',X_txn_status, p_log_level_rec);

1205: end if;
1206:
1207: if (p_log_level_rec.statement_level) then
1208: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxptb','book',h_tax_book, p_log_level_rec);
1209: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxptb','txn_status',X_txn_status, p_log_level_rec);
1210: end if;
1211: end loop;
1212:
1213: close tax_cursor;

Line 1218: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxptb', p_log_level_rec => p_log_level_rec);

1214: return(h_retval);
1215:
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxptb', p_log_level_rec => p_log_level_rec);
1219: close tax_cursor;
1220: return(FALSE);
1221:
1222: END faxptb;

Line 1245: fa_srvr_msg.add_sql_error(calling_fn=>'fa_chk_booksts_pkg.faxgcb', p_log_level_rec => p_log_level_rec);

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:
1249: if (NOT faxcms(X_book => h_corp_book,

Line 1252: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxgcb',

1248:
1249: if (NOT faxcms(X_book => h_corp_book,
1250: X_request_id => h_request_id,
1251: p_log_level_rec => p_log_level_rec)) then
1252: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxgcb',
1253: p_log_level_rec => p_log_level_rec);
1254: return(FALSE);
1255: end if;
1256:

Line 1280: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','book',h_corp_book, p_log_level_rec);

1276: where pr.concurrent_program_id = h_conc_program_id
1277: and pr.application_id = 140;
1278:
1279: if (p_log_level_rec.statement_level) then
1280: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','book',h_corp_book, p_log_level_rec);
1281: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','mass_request_id',
1282: h_request_id, p_log_level_rec);
1283: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','conflict',h_conflict, p_log_level_rec);
1284: end if;

Line 1281: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','mass_request_id',

1277: and pr.application_id = 140;
1278:
1279: if (p_log_level_rec.statement_level) then
1280: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','book',h_corp_book, p_log_level_rec);
1281: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','mass_request_id',
1282: h_request_id, p_log_level_rec);
1283: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','conflict',h_conflict, p_log_level_rec);
1284: end if;
1285:

Line 1283: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','conflict',h_conflict, p_log_level_rec);

1279: if (p_log_level_rec.statement_level) then
1280: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','book',h_corp_book, p_log_level_rec);
1281: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','mass_request_id',
1282: h_request_id, p_log_level_rec);
1283: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','conflict',h_conflict, p_log_level_rec);
1284: end if;
1285:
1286: if (h_conflict <> 0) then -- curr program either FAMTFR or FAMAPT
1287: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.PKG.faxgcb',

Line 1287: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.PKG.faxgcb',

1283: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','conflict',h_conflict, p_log_level_rec);
1284: end if;
1285:
1286: if (h_conflict <> 0) then -- curr program either FAMTFR or FAMAPT
1287: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.PKG.faxgcb',
1288: name => 'FA_TRXAPP_WAIT_REQUEST',
1289: token1 => 'REQUEST_ID',
1290: value1 => h_request_id,
1291: token2 => 'BOOK',

Line 1307: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxgcb',

1303: return (TRUE);
1304:
1305: EXCEPTION
1306: WHEN NO_DATA_FOUND then
1307: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxgcb',
1308: name => 'CONC_MISSING_REQUEST',
1309: token1 => 'ROUTINE',value1=>'FA_TRXAPP',
1310: token2 => 'REQUEST',value2=>h_request_id,
1311: p_log_level_rec => p_log_level_rec);

Line 1315: fa_srvr_msg.add_sql_error(calling_fn=>'FA_CHK_BOOKSTS_PKG.faxgcb', p_log_level_rec => p_log_level_rec);

1311: p_log_level_rec => p_log_level_rec);
1312: return(FALSE);
1313:
1314: WHEN OTHERS THEN
1315: fa_srvr_msg.add_sql_error(calling_fn=>'FA_CHK_BOOKSTS_PKG.faxgcb', p_log_level_rec => p_log_level_rec);
1316: return(FALSE);
1317: END faxgcb;
1318:
1319: --

Line 1369: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',

1365:
1366: if (NOT faxsav(X_action => 'R',
1367: X_txn_status => X_txn_status,
1368: p_log_level_rec => p_log_level_rec)) then
1369: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',
1370: p_log_level_rec => p_log_level_rec);
1371: return(FALSE);
1372: end if;
1373:

Line 1433: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck', p_log_level_rec => p_log_level_rec);

1429: return(TRUE);
1430:
1431: EXCEPTION
1432: WHEN LOCK_ERROR THEN
1433: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck', p_log_level_rec => p_log_level_rec);
1434: h_tmp := faxsav(X_action => 'R',
1435: X_txn_status => X_txn_status,
1436: p_log_level_rec => p_log_level_rec);
1437: if (X_asset_id <> 0) then

Line 1438: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',

1434: h_tmp := faxsav(X_action => 'R',
1435: X_txn_status => X_txn_status,
1436: p_log_level_rec => p_log_level_rec);
1437: if (X_asset_id <> 0) then
1438: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',
1439: name => 'FA_TRXAPP_ASSET_LOCK_FAILED',
1440: token1 => 'ASSET_ID',
1441: value1 => X_asset_id,
1442: token2 => 'BOOK',

Line 1446: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',

1442: token2 => 'BOOK',
1443: value2 => X_book,
1444: p_log_level_rec => p_log_level_rec);
1445: else
1446: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',
1447: name => 'FA_TRXAPP_LOCK_FAILED',
1448: token1 => 'BOOK',
1449: value1 => X_book,
1450: p_log_level_rec => p_log_level_rec);

Line 1457: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck', p_log_level_rec => p_log_level_rec);

1453: return(FALSE);
1454:
1455:
1456: WHEN OTHERS THEN
1457: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck', p_log_level_rec => p_log_level_rec);
1458: h_tmp := faxsav(X_action => 'R',
1459: X_txn_status => X_txn_status,
1460: p_log_level_rec => p_log_level_rec);
1461: if (X_asset_id <> 0) then

Line 1462: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',

1458: h_tmp := faxsav(X_action => 'R',
1459: X_txn_status => X_txn_status,
1460: p_log_level_rec => p_log_level_rec);
1461: if (X_asset_id <> 0) then
1462: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',
1463: name => 'FA_TRXAPP_ASSET_LOCK_FAILED',
1464: token1 => 'ASSET_ID',
1465: value1 => X_asset_id,
1466: token2 => 'BOOK',

Line 1470: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',

1466: token2 => 'BOOK',
1467: value2 => X_book,
1468: p_log_level_rec => p_log_level_rec);
1469: else
1470: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',
1471: name => 'FA_TRXAPP_LOCK_FAILED',
1472: token1 => 'BOOK',
1473: value1 => X_book,
1474: p_log_level_rec => p_log_level_rec);

Line 1521: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','action',X_action, p_log_level_rec);

1517:
1518: end if;
1519:
1520: if (p_log_level_rec.statement_level) then
1521: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','action',X_action, p_log_level_rec);
1522: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','savepoint',savepoint_set, p_log_level_rec);
1523: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','txn_status',X_txn_status, p_log_level_rec);
1524: end if;
1525: return (TRUE);

Line 1522: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','savepoint',savepoint_set, p_log_level_rec);

1518: end if;
1519:
1520: if (p_log_level_rec.statement_level) then
1521: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','action',X_action, p_log_level_rec);
1522: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','savepoint',savepoint_set, p_log_level_rec);
1523: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','txn_status',X_txn_status, p_log_level_rec);
1524: end if;
1525: return (TRUE);
1526:

Line 1523: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','txn_status',X_txn_status, p_log_level_rec);

1519:
1520: if (p_log_level_rec.statement_level) then
1521: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','action',X_action, p_log_level_rec);
1522: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','savepoint',savepoint_set, p_log_level_rec);
1523: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxsav','txn_status',X_txn_status, p_log_level_rec);
1524: end if;
1525: return (TRUE);
1526:
1527: EXCEPTION

Line 1572: (calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);

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;
1575:
1576: h_mc_source_flag := FA_CACHE_PKG.fazcbc_record.mc_source_flag;

Line 1584: (calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);

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
1584: (calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);
1585: return(FALSE);
1586: end if;
1587:
1588: if (X_asset_id = 0) then

Line 1602: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',

1598: CLOSE check_deprn_run;
1599:
1600: if (deprn_run = 'Y') then
1601: l_deprn_run := true;
1602: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1603: name => 'FA_DEPRN_ROLLBACK_BOOK',
1604: token1 => 'BOOK',
1605: value1 => X_book,
1606: p_log_level_rec => p_log_level_rec);

Line 1624: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',

1620: AND dp.deprn_run = 'Y';
1621:
1622: if (h_count <> 0) then
1623: l_deprn_run := true;
1624: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1625: name => 'FA_DEPRN_ROLLBACK_BOOK',
1626: token1 => 'BOOK',
1627: value1 => X_book,
1628: p_log_level_rec => p_log_level_rec);

Line 1678: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',

1674: l_deprn_run := true;
1675: end if;
1676:
1677: /*
1678: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1679: name => 'FA_DEPRN_ROLLBACK_ASSET',
1680: token1 => 'BOOK',
1681: value1 => X_book,
1682: p_log_level_rec => p_log_level_rec);

Line 1701: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',

1697:
1698: if (h_count <> 0) then
1699: l_deprn_run := true;
1700: /*
1701: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1702: name => 'FA_DEPRN_ROLLBACK_ASSET',
1703: token1 => 'BOOK',
1704: value1 => X_book,
1705: p_log_level_rec => p_log_level_rec);

Line 1725: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',

1721:
1722: if(NOT faxcca(X_book => X_book,
1723: X_request_id => h_ca_request_id,
1724: p_log_level_rec => p_log_level_rec)) then
1725: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
1726: p_log_level_rec => p_log_level_rec);
1727: return(FALSE);
1728: end if;
1729:

Line 1731: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcdr','book',X_book, p_log_level_rec);

1727: return(FALSE);
1728: end if;
1729:
1730: if (p_log_level_rec.statement_level) then
1731: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcdr','book',X_book, p_log_level_rec);
1732: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcdr','create_accounting_request_id',
1733: h_ca_request_id, p_log_level_rec);
1734: end if;
1735:

Line 1732: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcdr','create_accounting_request_id',

1728: end if;
1729:
1730: if (p_log_level_rec.statement_level) then
1731: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcdr','book',X_book, p_log_level_rec);
1732: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcdr','create_accounting_request_id',
1733: h_ca_request_id, p_log_level_rec);
1734: end if;
1735:
1736: if (h_ca_request_id <> 0) then

Line 1738: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',

1734: end if;
1735:
1736: if (h_ca_request_id <> 0) then
1737: -- req_id is in status of running,inactive,or pending
1738: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
1739: name => 'FA_TRXAPP_WAIT_REQUEST',
1740: token1 => 'REQUEST_ID',
1741: value1 => h_ca_request_id,
1742: token2 => 'BOOK',

Line 1764: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcdr',

1760: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1761: return false;
1762: else
1763: if (p_log_level_rec.statement_level) then
1764: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxcdr',
1765: 'successfully rolled back deprn','',p_log_level_rec);
1766: end if;
1767: end if;
1768: end if;

Line 1777: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);

1773: return(TRUE);
1774:
1775: EXCEPTION
1776: WHEN OTHERS THEN
1777: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);
1778: return(FALSE);
1779: END faxcdr;
1780:
1781:

Line 1782: END FA_CHK_BOOKSTS_PKG;

1778: return(FALSE);
1779: END faxcdr;
1780:
1781:
1782: END FA_CHK_BOOKSTS_PKG;