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_INS_DETAIL_PKG dependencies on FA_INS_DETAIL_PKG

Line 1: PACKAGE BODY FA_INS_DETAIL_PKG as

1: PACKAGE BODY FA_INS_DETAIL_PKG as
2: /* $Header: FAXINDDB.pls 120.23.12020000.4 2013/02/06 11:20:57 saalampa ship $ */
3:
4: --
5: -- FUNCTION faxindd

Line 65: CALLING_FN => 'FA_INS_DETAIL_PKG.faxindd',

61: END IF;
62:
63: IF (X_book_type_code IS NULL) OR (X_asset_id IS NULL) THEN
64: FA_SRVR_MSG.add_message(
65: CALLING_FN => 'FA_INS_DETAIL_PKG.faxindd',
66: NAME => 'FA_SHARED_ARGUMENTS', p_log_level_rec => p_log_level_rec);
67: return(FALSE);
68: END IF;
69:

Line 156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);

152: end if; -- end sob_id
153:
154: h_msg_name := NULL;
155: if (p_log_level_rec.statement_level) then
156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);

Line 157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);

153:
154: h_msg_name := NULL;
155: if (p_log_level_rec.statement_level) then
156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);

Line 158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);

154: h_msg_name := NULL;
155: if (p_log_level_rec.statement_level) then
156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
162: end if;

Line 159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);

155: if (p_log_level_rec.statement_level) then
156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
162: end if;
163:

Line 160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);

156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
162: end if;
163:
164: END IF;

Line 161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);

157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
162: end if;
163:
164: END IF;
165:

Line 276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);

272: h_dpr_dtl.capital_adjustment := X_capital_adjustment;
273: h_dpr_dtl.general_fund := X_general_fund;
274:
275: if (p_log_level_rec.statement_level) then
276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);

Line 277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);

273: h_dpr_dtl.general_fund := X_general_fund;
274:
275: if (p_log_level_rec.statement_level) then
276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);

Line 278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);

274:
275: if (p_log_level_rec.statement_level) then
276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);

Line 279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);

275: if (p_log_level_rec.statement_level) then
276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);
283: end if;

Line 280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);

276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);
283: end if;
284:

Line 281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);

277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);
283: end if;
284:
285: IF (NOT fadpdtl(X_dpr_dtl => h_dpr_dtl,

Line 282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);

278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);
283: end if;
284:
285: IF (NOT fadpdtl(X_dpr_dtl => h_dpr_dtl,
286: X_source_flag => X_b_row, -- TRUE, Modified for ias36

Line 291: CALLING_FN => 'FA_INS_DETAIL_PKG.faxindd', p_log_level_rec => p_log_level_rec);

287: X_mrc_sob_type_code => X_mrc_sob_type_code,
288: X_set_of_books_id => X_set_of_books_id,
289: p_log_level_rec => p_log_level_rec)) THEN
290: FA_SRVR_MSG.add_message (
291: CALLING_FN => 'FA_INS_DETAIL_PKG.faxindd', p_log_level_rec => p_log_level_rec);
292: return(FALSE);
293: END IF;
294:
295: return(TRUE);

Line 301: CALLING_FN => 'FA_INS_DETAIL_PKG.faxindd',

297: EXCEPTION
298:
299: WHEN NO_DATA_FOUND then
300: FA_SRVR_MSG.add_message(
301: CALLING_FN => 'FA_INS_DETAIL_PKG.faxindd',
302: NAME => h_msg_name, p_log_level_rec => p_log_level_rec);
303: return FALSE;
304:
305: WHEN OTHERS THEN

Line 307: CALLING_FN => 'FA_INS_DETAIL_PKG.faxindd', p_log_level_rec => p_log_level_rec);

303: return FALSE;
304:
305: WHEN OTHERS THEN
306: FA_SRVR_MSG.ADD_SQL_ERROR(
307: CALLING_FN => 'FA_INS_DETAIL_PKG.faxindd', p_log_level_rec => p_log_level_rec);
308: return(FALSE);
309: END faxindd;
310:
311:

Line 530: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Getting date added',SQLERRM, p_log_level_rec => p_log_level_rec);

526:
527: EXCEPTION
528: WHEN OTHERS THEN
529: if (p_log_level_rec.statement_level) then
530: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Getting date added',SQLERRM, p_log_level_rec => p_log_level_rec);
531: end if;
532:
533: RAISE ERROR_FOUND;
534: END;

Line 551: CALLING_FN => 'FA_INS_DETAIL_PKG.fadpdtl',

547: end if;
548:
549: IF (h_total_units = 0) THEN
550: FA_SRVR_MSG.add_message(
551: CALLING_FN => 'FA_INS_DETAIL_PKG.fadpdtl',
552: NAME => 'FA_SHARED_DATA_ERR_DH', p_log_level_rec => p_log_level_rec);
553: return (FALSE);
554: END IF;
555:

Line 591: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','At Start Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);

587: -- transfered out distributions
588: h_full_ytd := X_dpr_dtl.ytd;
589:
590: if (p_log_level_rec.statement_level) then
591: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','At Start Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
592: end if;
593: if (X_source_flag = FALSE ) then
594: open c2;
595: loop

Line 641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);

637:
638: h_full_ytd := h_full_ytd - h_part_ytd;
639:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);

Line 642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);

638: h_full_ytd := h_full_ytd - h_part_ytd;
639:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
646: end if;

Line 643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);

639:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
646: end if;
647:

Line 644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);

640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
646: end if;
647:
648: /*Bug#8421266 - Insert row in deprn table only when transferred out in current period.*/

Line 645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);

641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
646: end if;
647:
648: /*Bug#8421266 - Insert row in deprn table only when transferred out in current period.*/
649: if h_pc_counter = h_period_counter then

Line 778: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch','', p_log_level_rec => p_log_level_rec);

774: EXIT WHEN C1%NOTFOUND;
775: end if;
776:
777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch','', p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);
782: end if;

Line 779: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);

775: end if;
776:
777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch','', p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);
782: end if;
783:

Line 780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);

776:
777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch','', p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);
782: end if;
783:
784: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.

Line 781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);

777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch','', p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);
782: end if;
783:
784: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.
785: ADDITION_COST_TO_CLEAR should contain old value only, which is addition time value. */

Line 786: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Brahma2 before Loop','BRAHMA',p_log_level_rec => p_log_level_rec);

782: end if;
783:
784: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.
785: ADDITION_COST_TO_CLEAR should contain old value only, which is addition time value. */
786: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Brahma2 before Loop','BRAHMA',p_log_level_rec => p_log_level_rec);
787: IF h_count > 0 THEN
788: IF X_mrc_sob_type_code = 'R' THEN
789: OPEN C_MC_COST_TO_CLEAR;
790: FETCH C_MC_COST_TO_CLEAR INTO h_cost_to_clear;

Line 1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);

1047:
1048: END IF;
1049:
1050: if (p_log_level_rec.statement_level) then
1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);

Line 1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);

1048: END IF;
1049:
1050: if (p_log_level_rec.statement_level) then
1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);

Line 1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);

1049:
1050: if (p_log_level_rec.statement_level) then
1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);

Line 1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);

1050: if (p_log_level_rec.statement_level) then
1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);

Line 1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);

1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);

Line 1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);

1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);

Line 1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);

1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
1061: end if;

Line 1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);

1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
1061: end if;
1062:

Line 1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);

1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
1061: end if;
1062:
1063: if (G_release = 11) then

Line 1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);

1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
1061: end if;
1062:
1063: if (G_release = 11) then
1064: h_cost_to_clear := h_part_cost;

Line 1194: CALLING_FN => 'FA_INS_DETAIL_PKG.fadpdtl',

1190:
1191: EXCEPTION
1192: WHEN NO_DATA_FOUND THEN
1193: FA_SRVR_MSG.add_message(
1194: CALLING_FN => 'FA_INS_DETAIL_PKG.fadpdtl',
1195: NAME => h_msg_name, p_log_level_rec => p_log_level_rec);
1196: return (FALSE);
1197:
1198: WHEN ERROR_FOUND THEN

Line 1200: CALLING_FN => 'FA_INS_DETAIL_PKG.fadpdtl', p_log_level_rec => p_log_level_rec);

1196: return (FALSE);
1197:
1198: WHEN ERROR_FOUND THEN
1199: FA_SRVR_MSG.add_message(
1200: CALLING_FN => 'FA_INS_DETAIL_PKG.fadpdtl', p_log_level_rec => p_log_level_rec);
1201:
1202: if (G_release = 11 OR X_source_flag = FALSE) then -- Bug# 8731454
1203: close C1_11;
1204: else

Line 1223: END FA_INS_DETAIL_PKG;

1219:
1220: return(FALSE);
1221: END fadpdtl;
1222:
1223: END FA_INS_DETAIL_PKG;