DBA Data[Home] [Help]

APPS.FA_TRX_APPROVAL_PKG dependencies on FA_DEBUG_PKG

Line 20: FA_DEBUG_PKG.Initialize;

16:
17: IF (X_init_message_flag = 'YES') THEN
18: -- initialize Message and Debug stacks
19: FA_SRVR_MSG.Init_Server_Message;
20: FA_DEBUG_PKG.Initialize;
21: END if;
22:
23:
24: h_result := TRUE;

Line 38: FA_DEBUG_PKG.ADD ('FA:faxcat. After returning from faxcti','h_result=',h_result, p_log_level_rec => p_log_level_rec);

34: RETURN (h_result); /*FALSE */
35: END IF;
36:
37: IF (p_log_level_rec.statement_level) THEN
38: FA_DEBUG_PKG.ADD ('FA:faxcat. After returning from faxcti','h_result=',h_result, p_log_level_rec => p_log_level_rec);
39: END IF;
40:
41:
42: IF (NOT FA_CHK_BOOKSTS_PKG.faxcbs(X_book=>X_book,

Line 95: FA_DEBUG_PKG.ADD ('FA:faxcti','X_result in faxcti in the beginning = ',X_result, p_log_level_rec => p_log_level_rec);

91:
92: BEGIN
93: --X_result would be always TRUE at this stage.
94: IF (p_log_level_rec.statement_level)THEN
95: FA_DEBUG_PKG.ADD ('FA:faxcti','X_result in faxcti in the beginning = ',X_result, p_log_level_rec => p_log_level_rec);
96: END IF;
97:
98: -- added for BUG# 1338191 for approving UNDO RETIREMENT trx's
99: -- added enabled_clause for reporting books due to BUG# 1486157

Line 115: FA_DEBUG_PKG.ADD ('FA:faxcti','h_count in faxcti = ',h_count, p_log_level_rec => p_log_level_rec);

111: AND faret.book_type_code = X_book
112: AND UPPER(faret.status) in ('PENDING', 'REINSTATE');
113:
114: IF (p_log_level_rec.statement_level)THEN
115: FA_DEBUG_PKG.ADD ('FA:faxcti','h_count in faxcti = ',h_count, p_log_level_rec => p_log_level_rec);
116: END IF;
117:
118: SELECT COUNT(*) INTO h_count_mrc
119: FROM fa_retirements ret,

Line 131: FA_DEBUG_PKG.ADD ('FA:faxcti','h_count_mrc in faxcti = ',h_count_mrc, p_log_level_rec => p_log_level_rec);

127: AND UPPER(mc_ret.status) in ('PENDING', 'REINSTATE')
128: AND mc_ret.set_of_books_id = mc_bks.set_of_books_id;
129:
130: IF (p_log_level_rec.statement_level)THEN
131: FA_DEBUG_PKG.ADD ('FA:faxcti','h_count_mrc in faxcti = ',h_count_mrc, p_log_level_rec => p_log_level_rec);
132: END IF;
133:
134: /* changed the following for BUG# 1338191
135: UNDO RETIRE can not check for PENDING retirements or else

Line 185: FA_DEBUG_PKG.ADD ('FA:faxcti','h_count in faxcti = ',h_count

181: AND faret.book_type_code = l_corp_book
182: AND UPPER(faret.status) in ('PENDING');
183:
184: IF (p_log_level_rec.statement_level)THEN
185: FA_DEBUG_PKG.ADD ('FA:faxcti','h_count in faxcti = ',h_count
186: ,p_log_level_rec => p_log_level_rec);
187: END IF;
188:
189: SELECT COUNT(*) INTO h_count_mrc

Line 202: FA_DEBUG_PKG.ADD ('FA:faxcti','h_count_mrc in faxcti = ',h_count_mrc

198: AND UPPER(mc_ret.status) in ('PENDING')
199: AND mc_ret.set_of_books_id = mc_bks.set_of_books_id;
200:
201: IF (p_log_level_rec.statement_level)THEN
202: FA_DEBUG_PKG.ADD ('FA:faxcti','h_count_mrc in faxcti = ',h_count_mrc
203: ,p_log_level_rec => p_log_level_rec);
204: END IF;
205:
206: IF ((X_trx_type = 'UNDO RETIRE') or

Line 247: FA_DEBUG_PKG.ADD ('FA:faxcat','h_ah_units in faxcti',h_ah_units, p_log_level_rec => p_log_level_rec);

243: WHERE asset_id = X_asset_id
244: AND date_ineffective IS NULL;
245:
246: IF (p_log_level_rec.statement_level)THEN
247: FA_DEBUG_PKG.ADD ('FA:faxcat','h_ah_units in faxcti',h_ah_units, p_log_level_rec => p_log_level_rec);
248: END IF;
249:
250: SELECT SUM(units_assigned)
251: INTO h_dh_units

Line 257: FA_DEBUG_PKG.ADD ('FA:faxcat','h_dh_units in facti',h_dh_units, p_log_level_rec => p_log_level_rec);

253: WHERE asset_id = X_asset_id
254: AND date_ineffective IS NULL;
255:
256: IF (p_log_level_rec.statement_level)THEN
257: FA_DEBUG_PKG.ADD ('FA:faxcat','h_dh_units in facti',h_dh_units, p_log_level_rec => p_log_level_rec);
258: END IF;
259:
260: IF (h_ah_units <> h_dh_units) THEN
261: FA_SRVR_MSG.add_message