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 20: fa_srvr_msg.init_server_message;

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

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 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 190: fa_srvr_msg.add_sql_error

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

Line 239: FA_SRVR_MSG.add_message

235: open check_reporting_deprn_close;
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;

Line 250: FA_SRVR_MSG.add_message

246: open check_reporting_deprn_open;
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;

Line 268: FA_SRVR_MSG.add_message

264: elsif (X_asset_ID = 0) then -- for any mass transaction
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;

Line 279: FA_SRVR_MSG.add_message

275: else -- for any asset transaction
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;

Line 300: FA_SRVR_MSG.add_message

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

Line 313: FA_SRVR_MSG.add_message

309: RETURN(h_approve);
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);

Line 320: FA_SRVR_MSG.add_message

316: p_log_level_rec => p_log_level_rec);
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);

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 468: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.faxcbs',

464: end if;
465: end if;
466:
467: else
468: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.faxcbs',
469: name => 'FA_TRXAPP_WRONG_BOOK_CLASS',
470: token1 =>'CLASS',value1=>h_class_str,
471: p_log_level_rec => p_log_level_rec);
472:

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

494: return(TRUE);
495:
496: EXCEPTION
497: WHEN ERROR_FOUND THEN
498: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS.faxcbs',
499: p_log_level_rec => p_log_level_rec);
500:
501: h_tmp := faxsav(X_action => 'R',
502: X_txn_status => X_txn_status,

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

504: -- rollback the lock, if any
505: return (FALSE);
506:
507: WHEN OTHERS THEN
508: fa_srvr_msg.add_sql_error(calling_fn => 'FA_CHK_BOOKSTS.faxcbs', p_log_level_rec => p_log_level_rec);
509: h_tmp := faxsav(X_action => 'R',
510: X_txn_status => X_txn_status,
511: p_log_level_rec => p_log_level_rec);
512: -- rollback the lock, if any

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 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 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 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 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 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 1571: fa_srvr_msg.add_sql_error

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

Line 1583: fa_srvr_msg.add_sql_error

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

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