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_SRVR_MSG

Line 21: fa_srvr_msg.init_server_message;

17:
18: BEGIN
19:
20: if (X_init_message_flag = 'YES') then
21: fa_srvr_msg.init_server_message;
22: fa_debug_pkg.initialize;
23: end if;
24:
25: if (X_book is NULL) then

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

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

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', p_log_level_rec => p_log_level_rec);
46: h_txn_status := FALSE;
47:

Line 62: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcbsx', p_log_level_rec => p_log_level_rec);

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

Line 185: fa_srvr_msg.add_sql_error

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);
187: return(FALSE);
188: end if;
189:

Line 234: FA_SRVR_MSG.add_message

230: open check_reporting_deprn_close;
231: fetch check_reporting_deprn_close into h_count;
232: if (h_count > 0) then
233: h_approve := FALSE;
234: FA_SRVR_MSG.add_message
235: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
236: NAME => 'FA_MRC_REP_BOOK_DEP_NOT_RUN', p_log_level_rec => p_log_level_rec);
237: end if;
238: close check_reporting_deprn_close;

Line 244: FA_SRVR_MSG.add_message

240: open check_reporting_deprn_open;
241: fetch check_reporting_deprn_open into h_count;
242: if (h_count > 0) then
243: h_approve := FALSE;
244: FA_SRVR_MSG.add_message
245: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
246: NAME => 'FA_MRC_REP_BOOK_DEP_NOT_RUN', p_log_level_rec => p_log_level_rec);
247: end if;
248: close check_reporting_deprn_open;

Line 262: FA_SRVR_MSG.add_message

258: elsif (X_asset_ID = 0) then -- for any mass transaction
259: open check_reporting_mass;
260: fetch check_reporting_mass into h_count;
261: if (h_count > 0) then
262: FA_SRVR_MSG.add_message
263: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
264: NAME => 'FA_MRC_PRI_REP_PERIOD_DIFF', p_log_level_rec => p_log_level_rec);
265: h_approve := FALSE;
266: end if;

Line 272: FA_SRVR_MSG.add_message

268: else -- for any asset transaction
269: open check_reporting_single;
270: fetch check_reporting_single into h_count;
271: if (h_count > 0) then
272: FA_SRVR_MSG.add_message
273: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
274: NAME => 'FA_MRC_PRI_REP_PERIOD_DIFF', p_log_level_rec => p_log_level_rec);
275: h_approve := FALSE;
276: end if;

Line 292: FA_SRVR_MSG.add_message

288:
289: open check_primary_sync;
290: fetch check_primary_sync into h_count;
291: if (h_count > 0) then
292: FA_SRVR_MSG.add_message
293: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
294: NAME => 'FA_MRC_RUN_DEP_CORP_FIRST', p_log_level_rec => p_log_level_rec);
295: h_approve := FALSE;
296: end if;

Line 304: FA_SRVR_MSG.add_message

300: RETURN(h_approve);
301:
302: EXCEPTION
303: WHEN conversion_exception THEN
304: FA_SRVR_MSG.add_message
305: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
306: NAME => 'FA_MRC_CONV_PROCESS', p_log_level_rec => p_log_level_rec);
307: return(FALSE);
308:

Line 310: FA_SRVR_MSG.add_message

306: NAME => 'FA_MRC_CONV_PROCESS', p_log_level_rec => p_log_level_rec);
307: return(FALSE);
308:
309: WHEN efc_conversion_exception THEN
310: FA_SRVR_MSG.add_message
311: (CALLING_FN => 'FA_CHK_BOOKSTS_PKG.faxcrb',
312: NAME => 'FA_EFC_CONV_PROCESS', p_log_level_rec => p_log_level_rec);
313: return(FALSE);
314:

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

312: NAME => 'FA_EFC_CONV_PROCESS', p_log_level_rec => p_log_level_rec);
313: return(FALSE);
314:
315: WHEN OTHERS THEN
316: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcrb', p_log_level_rec => p_log_level_rec);
317: return(FALSE);
318:
319: END faxcrb;
320:

Line 456: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.faxcbs',

452: end if;
453: end if;
454:
455: else
456: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.faxcbs',
457: name => 'FA_TRXAPP_WRONG_BOOK_CLASS',
458: token1 =>'CLASS',value1=>h_class_str, p_log_level_rec => p_log_level_rec);
459:
460: h_tmp := faxsav(X_action => 'R',

Line 484: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.faxcbs', p_log_level_rec => p_log_level_rec);

480: return(TRUE);
481:
482: EXCEPTION
483: WHEN ERROR_FOUND THEN
484: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.faxcbs', p_log_level_rec => p_log_level_rec);
485:
486: h_tmp := faxsav(X_action => 'R',
487: X_txn_status => X_txn_status,
488: p_log_level_rec => p_log_level_rec);

Line 493: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS.faxcbs', p_log_level_rec => p_log_level_rec);

489: -- rollback the lock, if any
490: return (FALSE);
491:
492: WHEN OTHERS THEN
493: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS.faxcbs', p_log_level_rec => p_log_level_rec);
494: h_tmp := faxsav(X_action => 'R',
495: X_txn_status => X_txn_status,
496: p_log_level_rec => p_log_level_rec);
497: -- rollback the lock, if any

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

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

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

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

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

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

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

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

Line 628: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);

624: X_trx_type => X_trx_type,
625: X_asset_id => X_asset_id,
626: X_close_period => X_close_period,
627: p_log_level_rec => p_log_level_rec)) then
628: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);
629: return(FALSE);
630: end if;
631: end if;
632:

Line 640: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);

636: X_asset_id => X_asset_id,
637: X_trx_type => X_trx_type,
638: X_txn_status => X_txn_status,
639: p_log_level_rec => p_log_level_rec)) then
640: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);
641: return(FALSE);
642: end if;
643:
644: -- if trx_approval failed due to deprn running, return

Line 653: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);

649: -- check the status of mass request id, if any, in book_control
650: if(NOT faxcms(X_book => X_book,
651: X_request_id => h_request_id,
652: p_log_level_rec => p_log_level_rec)) then
653: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);
654: return(FALSE);
655: end if;
656:
657: -- check if create accounting is running for cip reversals

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

660:
661: if(NOT faxcca(X_book => X_book,
662: X_request_id => h_ca_request_id,
663: p_log_level_rec => p_log_level_rec)) then
664: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
665: p_log_level_rec => p_log_level_rec);
666: return(FALSE);
667: end if;
668: else

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

679: end if;
680:
681: if (h_request_id <> 0) then
682: -- req_id is in status of running,inactive,or pending
683: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
684: name => 'FA_TRXAPP_WAIT_REQUEST',
685: token1 => 'REQUEST_ID',
686: value1 => h_request_id,
687: token2 => 'BOOK',

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

691: p_log_level_rec => p_log_level_rec);
692: --rollback the lock, if any
693: elsif (h_ca_request_id <> 0) then
694: -- req_id is in status of running,inactive,or pending
695: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
696: name => 'FA_TRXAPP_WAIT_REQUEST',
697: token1 => 'REQUEST_ID',
698: value1 => h_ca_request_id,
699: token2 => 'BOOK',

Line 712: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);

708: if (X_start and (h_request_id <> 0 or h_ca_request_id <> 0)) then
709: -- for now faxwcr will always return TRUE
710: if (NOT faxwcr(X_request_id => h_request_id,
711: p_log_level_rec => p_log_level_rec)) then
712: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);
713: return(FALSE);
714: end if;
715: end if;
716:

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

717: return(TRUE);
718:
719: EXCEPTION
720: WHEN OTHERS THEN
721: fa_srvr_msg.add_sql_error(calling_fn=>'FA_CHK_BOOKSTS_PKG.faxcps', p_log_level_rec => p_log_level_rec);
722: return(FALSE);
723:
724: END faxcps;
725:

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

823: if (h_dev_phase = 'PENDING' OR
824: h_dev_phase = 'INACTIVE' OR
825: h_dev_phase = 'RUNNING') then
826:
827: fa_srvr_msg.add_message(calling_fn =>'fa_chk_booksts_pkg.faxcds',
828: name => 'FA_TRXAPP_DEPRN_IS_RUNNING',
829: token1 =>'BOOK',
830: value1 =>X_book, p_log_level_rec => p_log_level_rec);
831:

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

861: h_error := TRUE;
862: end if;
863:
864: else
865: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcds',
866: name => 'FA_CONCURRENT_GET_STATUS', p_log_level_rec => p_log_level_rec);
867: h_error := true; -- BUG# 7669210: continue into error logic
868: end if;
869: end if;

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

882:
883: -- This is a request for a mass process, no approval
884: -- because the last depreciation run failed.
885:
886: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcds',
887: name => 'FA_TRXAPP_DEPRN_FAILED',
888: token1 => 'BOOK',
889: value1 => X_book, p_log_level_rec => p_log_level_rec);
890: h_tmp := faxsav(X_action => 'R',

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

904: end if;
905: return(TRUE);
906:
907: else -- unknown status
908: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcds',
909: name => 'FA_TRXAPP_UNKNOWN_STATUS',
910: token1 => 'STATUS',
911: value1 => h_deprn_stat, p_log_level_rec => p_log_level_rec);
912: h_tmp := faxsav(X_action => 'R',

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

916: end if;
917:
918: EXCEPTION
919: when others then
920: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcds', p_log_level_rec => p_log_level_rec);
921: return(FALSE);
922: END faxcds;
923:
924:

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

1003: X_request_id := h_mass_req_id;
1004: end if;
1005: end if;
1006: else
1007: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcms',
1008: name => 'FA_CONCURRENT_GET_STATUS', p_log_level_rec => p_log_level_rec);
1009: -- return(FALSE); -- BUG# 7669210: do not error now
1010: end if;
1011: else -- same request based on parent

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

1027: return(TRUE);
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcms', p_log_level_rec => p_log_level_rec);
1032: return(FALSE);
1033:
1034: END faxcms;
1035:

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

1083: X_request_id := h_ca_req_id;
1084: end if;
1085: end if;
1086: else
1087: fa_srvr_msg.add_message(calling_fn => 'fa_chk_booksts_pkg.faxcms',
1088: name => 'FA_CONCURRENT_GET_STATUS');
1089: -- BUG# 7669210: do not treat as error anylonger
1090: X_request_id := 0;
1091: return(TRUE);

Line 1106: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcca',

1102: return(TRUE);
1103:
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcca',
1107: p_log_level_rec => p_log_level_rec);
1108: return(FALSE);
1109:
1110: END faxcca;

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

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

Line 1153: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.PKG.faxptb', p_log_level_rec => p_log_level_rec);

1149: X_txn_status => X_txn_status,
1150: X_asset_id => X_asset_id,
1151: X_trx_type => X_trx_type,
1152: p_log_level_rec => p_log_level_rec)) then -- lock the tax book
1153: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.PKG.faxptb', p_log_level_rec => p_log_level_rec);
1154: h_retval := FALSE;
1155: exit;
1156: end if;
1157:

Line 1167: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxptb', p_log_level_rec => p_log_level_rec);

1163: X_trx_type => X_trx_type,
1164: X_txn_status => X_txn_status,
1165: X_close_period => 0,
1166: p_log_level_rec => p_log_level_rec)) then
1167: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxptb', p_log_level_rec => p_log_level_rec);
1168: h_retval := FALSE;
1169: exit;
1170: end if;
1171:

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

1179: return(h_retval);
1180:
1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxptb', p_log_level_rec => p_log_level_rec);
1184: close tax_cursor;
1185: return(FALSE);
1186:
1187: END faxptb;

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

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

Line 1216: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxgcb', p_log_level_rec => p_log_level_rec);

1212:
1213: if (NOT faxcms(X_book => h_corp_book,
1214: X_request_id => h_request_id,
1215: p_log_level_rec => p_log_level_rec)) then
1216: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxgcb', p_log_level_rec => p_log_level_rec);
1217: return(FALSE);
1218: end if;
1219:
1220: if (h_request_id <> 0) then

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

1246: fa_debug_pkg.add('FA_CHK_BOOKSTS_PKG.faxgcb','conflict',h_conflict, p_log_level_rec => p_log_level_rec);
1247: end if;
1248:
1249: if (h_conflict <> 0) then -- curr program either FAMTFR or FAMAPT
1250: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.PKG.faxgcb',
1251: name => 'FA_TRXAPP_WAIT_REQUEST',
1252: token1 => 'REQUEST_ID',
1253: value1 => h_request_id,
1254: token2 => 'BOOK',

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

1265: return (TRUE);
1266:
1267: EXCEPTION
1268: WHEN NO_DATA_FOUND then
1269: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxgcb',
1270: name => 'CONC_MISSING_REQUEST',
1271: token1 => 'ROUTINE',value1=>'FA_TRXAPP',
1272: token2 => 'REQUEST',value2=>h_request_id, p_log_level_rec => p_log_level_rec);
1273: return(FALSE);

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

1272: token2 => 'REQUEST',value2=>h_request_id, p_log_level_rec => p_log_level_rec);
1273: return(FALSE);
1274:
1275: WHEN OTHERS THEN
1276: fa_srvr_msg.add_sql_error(calling_fn=>'FA_CHK_BOOKSTS_PKG.faxgcb', p_log_level_rec => p_log_level_rec);
1277: return(FALSE);
1278: END faxgcb;
1279:
1280: --

Line 1329: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck', p_log_level_rec => p_log_level_rec);

1325:
1326: if (NOT faxsav(X_action => 'R',
1327: X_txn_status => X_txn_status,
1328: p_log_level_rec => p_log_level_rec)) then
1329: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck', p_log_level_rec => p_log_level_rec);
1330: return(FALSE);
1331: end if;
1332:
1333: -- ******************************************************************

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

1388: return(TRUE);
1389:
1390: EXCEPTION
1391: WHEN LOCK_ERROR THEN
1392: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck', p_log_level_rec => p_log_level_rec);
1393: h_tmp := faxsav(X_action => 'R',
1394: X_txn_status => X_txn_status,
1395: p_log_level_rec => p_log_level_rec);
1396: if (X_asset_id <> 0) then

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

1393: h_tmp := faxsav(X_action => 'R',
1394: X_txn_status => X_txn_status,
1395: p_log_level_rec => p_log_level_rec);
1396: if (X_asset_id <> 0) then
1397: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',
1398: name => 'FA_TRXAPP_ASSET_LOCK_FAILED',
1399: token1 => 'ASSET_ID',
1400: value1 => X_asset_id,
1401: token2 => 'BOOK',

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

1400: value1 => X_asset_id,
1401: token2 => 'BOOK',
1402: value2 => X_book, p_log_level_rec => p_log_level_rec);
1403: else
1404: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',
1405: name => 'FA_TRXAPP_LOCK_FAILED',
1406: token1 => 'BOOK',
1407: value1 => X_book, p_log_level_rec => p_log_level_rec);
1408: end if;

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

1410: return(FALSE);
1411:
1412:
1413: WHEN OTHERS THEN
1414: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck', p_log_level_rec => p_log_level_rec);
1415: h_tmp := faxsav(X_action => 'R',
1416: X_txn_status => X_txn_status,
1417: p_log_level_rec => p_log_level_rec);
1418: if (X_asset_id <> 0) then

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

1415: h_tmp := faxsav(X_action => 'R',
1416: X_txn_status => X_txn_status,
1417: p_log_level_rec => p_log_level_rec);
1418: if (X_asset_id <> 0) then
1419: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',
1420: name => 'FA_TRXAPP_ASSET_LOCK_FAILED',
1421: token1 => 'ASSET_ID',
1422: value1 => X_asset_id,
1423: token2 => 'BOOK',

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

1422: value1 => X_asset_id,
1423: token2 => 'BOOK',
1424: value2 => X_book, p_log_level_rec => p_log_level_rec);
1425: else
1426: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxlck',
1427: name => 'FA_TRXAPP_LOCK_FAILED',
1428: token1 => 'BOOK',
1429: value1 => X_book, p_log_level_rec => p_log_level_rec);
1430: end if;

Line 1524: fa_srvr_msg.add_sql_error

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

Line 1535: fa_srvr_msg.add_sql_error

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);
1537: return(FALSE);
1538: end if;
1539:

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

1551: FETCH check_deprn_run INTO deprn_run;
1552: CLOSE check_deprn_run;
1553:
1554: if (deprn_run = 'Y') then
1555: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1556: name => 'FA_DEPRN_ROLLBACK_BOOK',
1557: token1 => 'BOOK',
1558: value1 => X_book, p_log_level_rec => p_log_level_rec);
1559: return(FALSE);

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

1571: AND dp.period_close_date is null
1572: AND dp.deprn_run = 'Y';
1573:
1574: if (h_count <> 0) then
1575: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1576: name => 'FA_DEPRN_ROLLBACK_BOOK',
1577: token1 => 'BOOK',
1578: value1 => X_book, p_log_level_rec => p_log_level_rec);
1579: return(FALSE);

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

1591: AND ds.deprn_source_code in ('DEPRN','TRACK');
1592:
1593:
1594: if (h_count <> 0) then
1595: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1596: name => 'FA_DEPRN_ROLLBACK_ASSET',
1597: token1 => 'BOOK',
1598: value1 => X_book, p_log_level_rec => p_log_level_rec);
1599: return(FALSE);

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

1610: AND ds.asset_id = X_asset_id
1611: AND ds.deprn_source_code in ('DEPRN','TRACK');
1612:
1613: if (h_count <> 0) then
1614: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1615: name => 'FA_DEPRN_ROLLBACK_ASSET',
1616: token1 => 'BOOK',
1617: value1 => X_book, p_log_level_rec => p_log_level_rec);
1618: return(FALSE);

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

1639: AND ds.period_counter = bc.last_period_counter;
1640:
1641:
1642: if (h_count <> 0) then
1643: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1644: name => 'FA_DEPRN_ROLLBACK_ASSET',
1645: token1 => 'BOOK',
1646: value1 => X_book, p_log_level_rec => p_log_level_rec);
1647: return(FALSE);

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

1668: AND ds.deprn_source_code = 'BOOKS'
1669: AND ds.period_counter = bc.last_period_counter;
1670:
1671: if (h_count <> 0) then
1672: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcdr',
1673: name => 'FA_DEPRN_ROLLBACK_ASSET',
1674: token1 => 'BOOK',
1675: value1 => X_book, p_log_level_rec => p_log_level_rec);
1676: return(FALSE);

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

1755:
1756: if(NOT faxcca(X_book => X_book,
1757: X_request_id => h_ca_request_id,
1758: p_log_level_rec => p_log_level_rec)) then
1759: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
1760: p_log_level_rec => p_log_level_rec);
1761: return(FALSE);
1762: end if;
1763:

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

1768: end if;
1769:
1770: if (h_ca_request_id <> 0) then
1771: -- req_id is in status of running,inactive,or pending
1772: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcps',
1773: name => 'FA_TRXAPP_WAIT_REQUEST',
1774: token1 => 'REQUEST_ID',
1775: value1 => h_ca_request_id,
1776: token2 => 'BOOK',

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

1808: return(TRUE);
1809:
1810: EXCEPTION
1811: WHEN OTHERS THEN
1812: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcdr', p_log_level_rec => p_log_level_rec);
1813: return(FALSE);
1814: END faxcdr;
1815:
1816: -- Bug 9032587: Wrapper procedure to call function faxcdr.

Line 1856: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcdr_proc', p_log_level_rec => p_log_level_rec);

1852: WHEN ERROR_FOUND THEN
1853: raise;
1854:
1855: WHEN OTHERS THEN
1856: fa_srvr_msg.add_sql_error(calling_fn => 'fa_chk_booksts_pkg.faxcdr_proc', p_log_level_rec => p_log_level_rec);
1857: X_return_value := 0;
1858: return;
1859: END faxcdr_proc;
1860: -- End Bug 9032587