DBA Data[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on FA_DEBUG_PKG

Line 21: fa_debug_pkg.initialize;

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
25: fa_srvr_msg.add_message(calling_fn => 'FA_CHK_BOOKSTS_PKG.faxcbsx',

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