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_REVALUATION_PVT dependencies on FA_DEBUG_PKG

Line 174: fa_debug_pkg.ADD (l_calling_fn,

170: /* Bug 7488356 - End*/
171:
172: IF (p_log_level_rec.statement_level)
173: THEN
174: fa_debug_pkg.ADD (l_calling_fn,
175: 'after call to fareven run_mode',
176: p_reval_options_rec.run_mode
177: , p_log_level_rec => p_log_level_rec);
178: fa_debug_pkg.ADD (l_calling_fn,

Line 178: fa_debug_pkg.ADD (l_calling_fn,

174: fa_debug_pkg.ADD (l_calling_fn,
175: 'after call to fareven run_mode',
176: p_reval_options_rec.run_mode
177: , p_log_level_rec => p_log_level_rec);
178: fa_debug_pkg.ADD (l_calling_fn,
179: 'after call to fareven insert_txn_flag',
180: l_reval_out_rec.insert_txn_flag
181: , p_log_level_rec => p_log_level_rec);
182: END IF;

Line 195: fa_debug_pkg.ADD (l_calling_fn,

191: IF (p_mrc_sob_type_code <> 'R')
192: THEN
193: IF (p_log_level_rec.statement_level)
194: THEN
195: fa_debug_pkg.ADD (l_calling_fn,
196: 'trx_date before insert',
197: px_trans_rec.transaction_date_entered
198: , p_log_level_rec => p_log_level_rec);
199: END IF;

Line 299: fa_debug_pkg.add(l_calling_fn, 'Calling', 'query_balances_int', p_log_level_rec => p_log_level_rec);

295: l_dpr_row.set_of_books_id := px_asset_hdr_rec.set_of_books_id;
296: l_running_mode := 'STANDARD';
297:
298: if (p_log_level_rec.statement_level) then
299: fa_debug_pkg.add(l_calling_fn, 'Calling', 'query_balances_int', p_log_level_rec => p_log_level_rec);
300: end if;
301:
302: fa_query_balances_pkg.query_balances_int(
303: X_DPR_ROW => l_dpr_row,

Line 313: fa_debug_pkg.add(l_calling_fn, 'ERROR',

309:
310: if (NOT l_status) then
311:
312: if (p_log_level_rec.statement_level) then
313: fa_debug_pkg.add(l_calling_fn, 'ERROR',
314: 'Calling fa_query_balances_pkg.query_balances_int', p_log_level_rec => p_log_level_rec);
315: end if;
316:
317: raise reval_err;

Line 527: fa_debug_pkg.ADD (l_calling_fn,

523: , p_log_level_rec => p_log_level_rec);
524:
525: IF (p_log_level_rec.statement_level)
526: THEN
527: fa_debug_pkg.ADD (l_calling_fn,
528: 'after fa_books_pkg.deactivate_row',
529: 1
530: , p_log_level_rec => p_log_level_rec);
531: END IF;

Line 660: fa_debug_pkg.ADD (l_calling_fn, 'after books insert', 1, p_log_level_rec => p_log_level_rec);

656: END IF;
657:
658: IF (p_log_level_rec.statement_level)
659: THEN
660: fa_debug_pkg.ADD (l_calling_fn, 'after books insert', 1, p_log_level_rec => p_log_level_rec);
661: END IF;
662: --bug7719742
663: --Added the following code to populate the rat_in_use column during revaluation
664: if nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES' then

Line 709: fa_debug_pkg.ADD

705: END IF;
706:
707: IF p_log_level_rec.statement_level
708: THEN
709: fa_debug_pkg.ADD
710: (l_calling_fn,
711: 'calling concat_category with cat struct: ',
712: fa_cache_pkg.fazsys_record.category_flex_structure
713: , p_log_level_rec => p_log_level_rec);

Line 714: fa_debug_pkg.ADD (l_calling_fn,

710: (l_calling_fn,
711: 'calling concat_category with cat struct: ',
712: fa_cache_pkg.fazsys_record.category_flex_structure
713: , p_log_level_rec => p_log_level_rec);
714: fa_debug_pkg.ADD (l_calling_fn,
715: 'calling concat_category with cat id: ',
716: p_asset_cat_rec.category_id
717: , p_log_level_rec => p_log_level_rec);
718: END IF;

Line 758: fa_debug_pkg.ADD (l_calling_fn,

754: CLOSE yes_no_meaning;
755:
756: IF p_log_level_rec.statement_level
757: THEN
758: fa_debug_pkg.ADD (l_calling_fn,
759: 'inserting into: ',
760: 'fa_mass_reval_rep_itf'
761: , p_log_level_rec => p_log_level_rec);
762: END IF;

Line 767: fa_debug_pkg.ADD (l_calling_fn || ' SORP', 'OLD_NBV', g_old_nbv, p_log_level_rec => p_log_level_rec);

763:
764: -- Bug6666666 SORP Added columns OLD_NBV and NEW_NBV
765: IF p_log_level_rec.statement_level
766: THEN
767: fa_debug_pkg.ADD (l_calling_fn || ' SORP', 'OLD_NBV', g_old_nbv, p_log_level_rec => p_log_level_rec);
768: fa_debug_pkg.ADD (l_calling_fn || ' SORP', 'NEW_NBV', g_new_nbv, p_log_level_rec => p_log_level_rec);
769: END IF;
770:
771: INSERT INTO fa_mass_reval_rep_itf

Line 768: fa_debug_pkg.ADD (l_calling_fn || ' SORP', 'NEW_NBV', g_new_nbv, p_log_level_rec => p_log_level_rec);

764: -- Bug6666666 SORP Added columns OLD_NBV and NEW_NBV
765: IF p_log_level_rec.statement_level
766: THEN
767: fa_debug_pkg.ADD (l_calling_fn || ' SORP', 'OLD_NBV', g_old_nbv, p_log_level_rec => p_log_level_rec);
768: fa_debug_pkg.ADD (l_calling_fn || ' SORP', 'NEW_NBV', g_new_nbv, p_log_level_rec => p_log_level_rec);
769: END IF;
770:
771: INSERT INTO fa_mass_reval_rep_itf
772: (request_id,

Line 831: fa_debug_pkg.ADD (l_calling_fn,

827: );
828:
829: IF p_log_level_rec.statement_level
830: THEN
831: fa_debug_pkg.ADD (l_calling_fn,
832: 'after inserting into: ',
833: 'fa_mass_reval_rep_itf'
834: , p_log_level_rec => p_log_level_rec);
835: END IF;

Line 976: fa_debug_pkg.ADD ('fareven', 'begin', 1, p_log_level_rec => p_log_level_rec);

972:
973: BEGIN
974: IF (p_log_level_rec.statement_level)
975: THEN
976: fa_debug_pkg.ADD ('fareven', 'begin', 1, p_log_level_rec => p_log_level_rec);
977: END IF;
978:
979: -- validations come here
980: IF (p_asset_fin_rec_old.reval_ceiling IS NULL)

Line 1058: fa_debug_pkg.ADD ('fareven' || ' SORP',

1054:
1055: -- Bug#6666666 SORP Start
1056: IF (p_log_level_rec.statement_level) THEN
1057:
1058: fa_debug_pkg.ADD ('fareven' || ' SORP',
1059: 'p_asset_fin_rec_old.salvage_value',
1060: p_asset_fin_rec_old.salvage_value
1061: , p_log_level_rec => p_log_level_rec);
1062:

Line 1063: fa_debug_pkg.ADD ('fareven' || ' SORP',

1059: 'p_asset_fin_rec_old.salvage_value',
1060: p_asset_fin_rec_old.salvage_value
1061: , p_log_level_rec => p_log_level_rec);
1062:
1063: fa_debug_pkg.ADD ('fareven' || ' SORP',
1064: 'SORP_Enabled_flag',
1065: NVL (fa_cache_pkg.fazcbc_record.sorp_enabled_flag,
1066: 'N'
1067: )

Line 1075: fa_debug_pkg.ADD ('fareven' || ' SORP',

1071: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'Y'
1072: THEN
1073: IF (p_log_level_rec.statement_level)
1074: THEN
1075: fa_debug_pkg.ADD ('fareven' || ' SORP',
1076: 'Linked_flag',
1077: p_reval_options_rec.linked_flag
1078: , p_log_level_rec => p_log_level_rec);
1079: fa_debug_pkg.ADD ('fareven' || ' SORP',

Line 1079: fa_debug_pkg.ADD ('fareven' || ' SORP',

1075: fa_debug_pkg.ADD ('fareven' || ' SORP',
1076: 'Linked_flag',
1077: p_reval_options_rec.linked_flag
1078: , p_log_level_rec => p_log_level_rec);
1079: fa_debug_pkg.ADD ('fareven' || ' SORP',
1080: 'Value_type',
1081: p_reval_options_rec.value_type
1082: , p_log_level_rec => p_log_level_rec);
1083: fa_debug_pkg.ADD ('fareven' || ' SORP',

Line 1083: fa_debug_pkg.ADD ('fareven' || ' SORP',

1079: fa_debug_pkg.ADD ('fareven' || ' SORP',
1080: 'Value_type',
1081: p_reval_options_rec.value_type
1082: , p_log_level_rec => p_log_level_rec);
1083: fa_debug_pkg.ADD ('fareven' || ' SORP',
1084: 'Value',
1085: p_reval_options_rec.reval_percent
1086: , p_log_level_rec => p_log_level_rec);
1087: fa_debug_pkg.ADD ('fareven' || ' SORP',

Line 1087: fa_debug_pkg.ADD ('fareven' || ' SORP',

1083: fa_debug_pkg.ADD ('fareven' || ' SORP',
1084: 'Value',
1085: p_reval_options_rec.reval_percent
1086: , p_log_level_rec => p_log_level_rec);
1087: fa_debug_pkg.ADD ('fareven' || ' SORP',
1088: 'p_asset_fin_rec_old.recoverable_cost',
1089: p_asset_fin_rec_old.recoverable_cost
1090: , p_log_level_rec => p_log_level_rec);
1091: fa_debug_pkg.ADD ('fareven' || ' SORP',

Line 1091: fa_debug_pkg.ADD ('fareven' || ' SORP',

1087: fa_debug_pkg.ADD ('fareven' || ' SORP',
1088: 'p_asset_fin_rec_old.recoverable_cost',
1089: p_asset_fin_rec_old.recoverable_cost
1090: , p_log_level_rec => p_log_level_rec);
1091: fa_debug_pkg.ADD ('fareven' || ' SORP',
1092: 'p_asset_deprn_rec_old.deprn_reserve',
1093: p_asset_deprn_rec_old.deprn_reserve
1094: , p_log_level_rec => p_log_level_rec);
1095: fa_debug_pkg.ADD ('fareven' || ' SORP',

Line 1095: fa_debug_pkg.ADD ('fareven' || ' SORP',

1091: fa_debug_pkg.ADD ('fareven' || ' SORP',
1092: 'p_asset_deprn_rec_old.deprn_reserve',
1093: p_asset_deprn_rec_old.deprn_reserve
1094: , p_log_level_rec => p_log_level_rec);
1095: fa_debug_pkg.ADD ('fareven' || ' SORP',
1096: 'p_asset_deprn_rec_old.impairment_reserve',
1097: NVL (p_asset_deprn_rec_old.impairment_reserve,
1098: 0)
1099: );

Line 1100: fa_debug_pkg.ADD ('fareven' || ' SORP',

1096: 'p_asset_deprn_rec_old.impairment_reserve',
1097: NVL (p_asset_deprn_rec_old.impairment_reserve,
1098: 0)
1099: );
1100: fa_debug_pkg.ADD ('fareven' || ' SORP',
1101: 'RUN_MODE',
1102: p_reval_options_rec.run_mode
1103: , p_log_level_rec => p_log_level_rec);
1104: END IF;

Line 1139: fa_debug_pkg.ADD ('fareven' || ' SORP',

1135:
1136:
1137: IF (p_log_level_rec.statement_level)
1138: THEN
1139: fa_debug_pkg.ADD ('fareven' || ' SORP',
1140: 'PERIOD_COUNTER_FULLY_RESERVED',
1141: 'NULL'
1142: , p_log_level_rec => p_log_level_rec);
1143: END IF;

Line 1149: fa_debug_pkg.ADD ('fareven' || ' SORP',

1145: IF (l_reval_ceiling_flag)
1146: THEN
1147: IF (p_log_level_rec.statement_level)
1148: THEN
1149: fa_debug_pkg.ADD ('fareven' || ' SORP',
1150: 'l_reval_ceiling_flag',
1151: 'TRUE'
1152: , p_log_level_rec => p_log_level_rec);
1153: END IF;

Line 1196: fa_debug_pkg.ADD ('fareven' || ' SORP',

1192: END IF;
1193:
1194: IF (p_log_level_rec.statement_level)
1195: THEN
1196: fa_debug_pkg.ADD ('fareven' || ' SORP',
1197: 'x_reval_out.cost_adj',
1198: x_reval_out.cost_adj
1199: , p_log_level_rec => p_log_level_rec);
1200: fa_debug_pkg.ADD ('fareven' || ' SORP', 'g_old_nbv', g_old_nbv, p_log_level_rec => p_log_level_rec);

Line 1200: fa_debug_pkg.ADD ('fareven' || ' SORP', 'g_old_nbv', g_old_nbv, p_log_level_rec => p_log_level_rec);

1196: fa_debug_pkg.ADD ('fareven' || ' SORP',
1197: 'x_reval_out.cost_adj',
1198: x_reval_out.cost_adj
1199: , p_log_level_rec => p_log_level_rec);
1200: fa_debug_pkg.ADD ('fareven' || ' SORP', 'g_old_nbv', g_old_nbv, p_log_level_rec => p_log_level_rec);
1201: fa_debug_pkg.ADD ('fareven' || ' SORP', 'g_new_nbv', g_new_nbv, p_log_level_rec => p_log_level_rec);
1202: END IF;
1203:
1204: l_reval_loss_exp := 0;

Line 1201: fa_debug_pkg.ADD ('fareven' || ' SORP', 'g_new_nbv', g_new_nbv, p_log_level_rec => p_log_level_rec);

1197: 'x_reval_out.cost_adj',
1198: x_reval_out.cost_adj
1199: , p_log_level_rec => p_log_level_rec);
1200: fa_debug_pkg.ADD ('fareven' || ' SORP', 'g_old_nbv', g_old_nbv, p_log_level_rec => p_log_level_rec);
1201: fa_debug_pkg.ADD ('fareven' || ' SORP', 'g_new_nbv', g_new_nbv, p_log_level_rec => p_log_level_rec);
1202: END IF;
1203:
1204: l_reval_loss_exp := 0;
1205: l_reval_deprn_exp := 0;

Line 1226: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened before impairment linked', p_log_level_rec => p_log_level_rec);

1222: raise fareven_err;
1223: end if;
1224: IF (p_log_level_rec.statement_level)
1225: THEN
1226: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened before impairment linked', p_log_level_rec => p_log_level_rec);
1227: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);
1228: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);
1229: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);
1230: fa_debug_pkg.ADD ('fareven' || ' SORP','Calling FA_SORP_REVALUATION_PKG.fa_sorp_link_reval','START', p_log_level_rec => p_log_level_rec);

Line 1227: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);

1223: end if;
1224: IF (p_log_level_rec.statement_level)
1225: THEN
1226: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened before impairment linked', p_log_level_rec => p_log_level_rec);
1227: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);
1228: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);
1229: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);
1230: fa_debug_pkg.ADD ('fareven' || ' SORP','Calling FA_SORP_REVALUATION_PKG.fa_sorp_link_reval','START', p_log_level_rec => p_log_level_rec);
1231: END IF;

Line 1228: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);

1224: IF (p_log_level_rec.statement_level)
1225: THEN
1226: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened before impairment linked', p_log_level_rec => p_log_level_rec);
1227: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);
1228: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);
1229: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);
1230: fa_debug_pkg.ADD ('fareven' || ' SORP','Calling FA_SORP_REVALUATION_PKG.fa_sorp_link_reval','START', p_log_level_rec => p_log_level_rec);
1231: END IF;
1232:

Line 1229: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);

1225: THEN
1226: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened before impairment linked', p_log_level_rec => p_log_level_rec);
1227: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);
1228: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);
1229: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);
1230: fa_debug_pkg.ADD ('fareven' || ' SORP','Calling FA_SORP_REVALUATION_PKG.fa_sorp_link_reval','START', p_log_level_rec => p_log_level_rec);
1231: END IF;
1232:
1233: fa_sorp_revaluation_pkg.fa_sorp_link_reval

Line 1230: fa_debug_pkg.ADD ('fareven' || ' SORP','Calling FA_SORP_REVALUATION_PKG.fa_sorp_link_reval','START', p_log_level_rec => p_log_level_rec);

1226: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened before impairment linked', p_log_level_rec => p_log_level_rec);
1227: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);
1228: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);
1229: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);
1230: fa_debug_pkg.ADD ('fareven' || ' SORP','Calling FA_SORP_REVALUATION_PKG.fa_sorp_link_reval','START', p_log_level_rec => p_log_level_rec);
1231: END IF;
1232:
1233: fa_sorp_revaluation_pkg.fa_sorp_link_reval
1234: (--g_old_nbv,

Line 1254: fa_debug_pkg.ADD

1250: , p_log_level_rec => p_log_level_rec);
1251:
1252: IF (p_log_level_rec.statement_level)
1253: THEN
1254: fa_debug_pkg.ADD
1255: ('fareven' || ' SORP',
1256: 'Calling FA_SORP_REVALUATION_PKG.fa_sorp_link_reval',
1257: 'END'
1258: , p_log_level_rec => p_log_level_rec);

Line 1259: fa_debug_pkg.ADD

1255: ('fareven' || ' SORP',
1256: 'Calling FA_SORP_REVALUATION_PKG.fa_sorp_link_reval',
1257: 'END'
1258: , p_log_level_rec => p_log_level_rec);
1259: fa_debug_pkg.ADD
1260: ('fareven' || ' SORP',
1261: 'Calling FA_SORP_REVALUATION_PKG.fa_imp_itf_upd',
1262: 'START'
1263: , p_log_level_rec => p_log_level_rec);

Line 1265: fa_debug_pkg.ADD

1261: 'Calling FA_SORP_REVALUATION_PKG.fa_imp_itf_upd',
1262: 'START'
1263: , p_log_level_rec => p_log_level_rec);
1264:
1265: fa_debug_pkg.ADD
1266: ('fareven' || ' SORP',
1267: 'p_reval_gain',
1268: p_reval_gain
1269: , p_log_level_rec => p_log_level_rec);

Line 1286: fa_debug_pkg.ADD

1282: END IF;
1283:
1284: IF (p_log_level_rec.statement_level)
1285: THEN
1286: fa_debug_pkg.ADD
1287: ('fareven' || ' SORP',
1288: 'Calling FA_SORP_REVALUATION_PKG.fa_imp_itf_upd',
1289: 'END'
1290: , p_log_level_rec => p_log_level_rec);

Line 1305: fa_debug_pkg.ADD ('fareven', 'step', 2, p_log_level_rec => p_log_level_rec);

1301: -- Get Book Based Revaluation Rules from Book Controls Cache
1302: -- Get some more information from the Book Controls Cache
1303: IF (p_log_level_rec.statement_level)
1304: THEN
1305: fa_debug_pkg.ADD ('fareven', 'step', 2, p_log_level_rec => p_log_level_rec);
1306: END IF;
1307:
1308: -- Find the Depreciation Basis Rule and Rate Source Rule
1309: -- for this depreciation method

Line 1332: fa_debug_pkg.ADD ('fareven', '3', 3, p_log_level_rec => p_log_level_rec);

1328: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1329:
1330: IF (p_log_level_rec.statement_level)
1331: THEN
1332: fa_debug_pkg.ADD ('fareven', '3', 3, p_log_level_rec => p_log_level_rec);
1333: END IF;
1334:
1335: -- Bug#6666666 SORP Start
1336: IF nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y'

Line 1356: fa_debug_pkg.ADD ('fareven', 'l_reval_rate', l_reval_rate, p_log_level_rec => p_log_level_rec);

1352:
1353: -- Bug#6666666 SORP End
1354: IF (p_log_level_rec.statement_level)
1355: THEN
1356: fa_debug_pkg.ADD ('fareven', 'l_reval_rate', l_reval_rate, p_log_level_rec => p_log_level_rec);
1357: END IF;
1358:
1359: --Calculate adjustment to asset cost
1360: -- Bug#6666666 SORP Start

Line 1430: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened after impairment linked', p_log_level_rec => p_log_level_rec);

1426: end if;
1427: end if;
1428: IF (p_log_level_rec.statement_level)
1429: THEN
1430: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened after impairment linked', p_log_level_rec => p_log_level_rec);
1431: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);
1432: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);
1433: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);
1434: END IF;

Line 1431: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);

1427: end if;
1428: IF (p_log_level_rec.statement_level)
1429: THEN
1430: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened after impairment linked', p_log_level_rec => p_log_level_rec);
1431: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);
1432: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);
1433: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);
1434: END IF;
1435:

Line 1432: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);

1428: IF (p_log_level_rec.statement_level)
1429: THEN
1430: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened after impairment linked', p_log_level_rec => p_log_level_rec);
1431: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);
1432: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);
1433: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);
1434: END IF;
1435:
1436: l_recalc_life := p_asset_fin_rec_old.life_in_months;

Line 1433: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);

1429: THEN
1430: fa_debug_pkg.ADD ('fareven', 'After','Processing reval losses happened after impairment linked', p_log_level_rec => p_log_level_rec);
1431: fa_debug_pkg.ADD ('fareven', 'l_gain_amount', l_gain_amount, p_log_level_rec => p_log_level_rec);
1432: fa_debug_pkg.ADD ('fareven', 'l_reval_deprn_exp', l_reval_deprn_exp, p_log_level_rec => p_log_level_rec);
1433: fa_debug_pkg.ADD ('fareven', 'l_reval_loss_exp', l_reval_loss_exp, p_log_level_rec => p_log_level_rec);
1434: END IF;
1435:
1436: l_recalc_life := p_asset_fin_rec_old.life_in_months;
1437: l_sorp_reval_adj := x_reval_out.cost_adj;

Line 1441: fa_debug_pkg.ADD ('fareven', 'old cost', p_asset_fin_rec_old.COST, p_log_level_rec => p_log_level_rec);

1437: l_sorp_reval_adj := x_reval_out.cost_adj;
1438:
1439: IF (p_log_level_rec.statement_level)
1440: THEN
1441: fa_debug_pkg.ADD ('fareven', 'old cost', p_asset_fin_rec_old.COST, p_log_level_rec => p_log_level_rec);
1442: fa_debug_pkg.ADD ('fareven',
1443: 'x_reval_out.cost_adj',
1444: x_reval_out.cost_adj
1445: , p_log_level_rec => p_log_level_rec);

Line 1442: fa_debug_pkg.ADD ('fareven',

1438:
1439: IF (p_log_level_rec.statement_level)
1440: THEN
1441: fa_debug_pkg.ADD ('fareven', 'old cost', p_asset_fin_rec_old.COST, p_log_level_rec => p_log_level_rec);
1442: fa_debug_pkg.ADD ('fareven',
1443: 'x_reval_out.cost_adj',
1444: x_reval_out.cost_adj
1445: , p_log_level_rec => p_log_level_rec);
1446: fa_debug_pkg.ADD ('fareven', 'new cost', px_asset_fin_rec_new.COST, p_log_level_rec => p_log_level_rec);

Line 1446: fa_debug_pkg.ADD ('fareven', 'new cost', px_asset_fin_rec_new.COST, p_log_level_rec => p_log_level_rec);

1442: fa_debug_pkg.ADD ('fareven',
1443: 'x_reval_out.cost_adj',
1444: x_reval_out.cost_adj
1445: , p_log_level_rec => p_log_level_rec);
1446: fa_debug_pkg.ADD ('fareven', 'new cost', px_asset_fin_rec_new.COST, p_log_level_rec => p_log_level_rec);
1447: END IF;
1448:
1449: -- call fazccbd to initialize cat book defaults which is called in
1450: -- calc_salvage_value

Line 1473: fa_debug_pkg.ADD ('fareven', 'not fully reserved', 1, p_log_level_rec => p_log_level_rec);

1469: IF (NOT l_fully_rsvd_flag)
1470: THEN
1471: IF (p_log_level_rec.statement_level)
1472: THEN
1473: fa_debug_pkg.ADD ('fareven', 'not fully reserved', 1, p_log_level_rec => p_log_level_rec);
1474: END IF;
1475:
1476: -- Compute Adjustment to Depreciation Reserve
1477: -- if Depreciation Reserve is to be revalued

Line 1482: fa_debug_pkg.ADD ('fareven', 'reval_dep_rsv_flag is YES', 1, p_log_level_rec => p_log_level_rec);

1478: IF l_reval_dep_rsv_flag = 'YES'
1479: THEN
1480: IF (p_log_level_rec.statement_level)
1481: THEN
1482: fa_debug_pkg.ADD ('fareven', 'reval_dep_rsv_flag is YES', 1, p_log_level_rec => p_log_level_rec);
1483: END IF;
1484:
1485: x_reval_out.deprn_rsv_adj :=
1486: p_asset_deprn_rec_old.deprn_reserve * l_reval_rate;

Line 1512: fa_debug_pkg.ADD ('fareven', 'reval_dep_rsv_flag is NO', 1, p_log_level_rec => p_log_level_rec);

1508: END IF;
1509: ELSE --if Depreciation Reserve is not to be revalued
1510: IF (p_log_level_rec.statement_level)
1511: THEN
1512: fa_debug_pkg.ADD ('fareven', 'reval_dep_rsv_flag is NO', 1, p_log_level_rec => p_log_level_rec);
1513: END IF;
1514:
1515: x_reval_out.deprn_rsv_adj := -p_asset_deprn_rec_old.deprn_reserve;
1516: x_reval_out.bonus_deprn_rsv_adj :=

Line 1548: fa_debug_pkg.ADD ('fareven',

1544: END IF;
1545:
1546: IF (p_log_level_rec.statement_level)
1547: THEN
1548: fa_debug_pkg.ADD ('fareven',
1549: 'x_reval_out.deprn_rsv_adj',
1550: x_reval_out.deprn_rsv_adj
1551: , p_log_level_rec => p_log_level_rec);
1552: fa_debug_pkg.ADD ('fareven',

Line 1552: fa_debug_pkg.ADD ('fareven',

1548: fa_debug_pkg.ADD ('fareven',
1549: 'x_reval_out.deprn_rsv_adj',
1550: x_reval_out.deprn_rsv_adj
1551: , p_log_level_rec => p_log_level_rec);
1552: fa_debug_pkg.ADD ('fareven',
1553: 'x_reval_out.bonus_deprn_rsv_adj',
1554: x_reval_out.bonus_deprn_rsv_adj
1555: , p_log_level_rec => p_log_level_rec);
1556: END IF;

Line 1558: fa_debug_pkg.ADD ('fareven',

1554: x_reval_out.bonus_deprn_rsv_adj
1555: , p_log_level_rec => p_log_level_rec);
1556: END IF;
1557:
1558: fa_debug_pkg.ADD ('fareven',
1559: 'p_asset_deprn_rec_old.impairment_reserve',
1560: p_asset_deprn_rec_old.impairment_reserve
1561: , p_log_level_rec => p_log_level_rec);
1562:

Line 1632: fa_debug_pkg.ADD ('fareven', 'reval_ytd_deprn_flag is YES', 1, p_log_level_rec => p_log_level_rec);

1628: IF l_reval_ytd_deprn_flag = 'YES'
1629: THEN
1630: IF (p_log_level_rec.statement_level)
1631: THEN
1632: fa_debug_pkg.ADD ('fareven', 'reval_ytd_deprn_flag is YES', 1, p_log_level_rec => p_log_level_rec);
1633: END IF;
1634:
1635: x_reval_out.ytd_deprn_adj :=
1636: p_asset_deprn_rec_old.ytd_deprn * l_reval_rate;

Line 1672: fa_debug_pkg.ADD ('fareven', 'reval_ytd_deprn_flag is NO', 1, p_log_level_rec => p_log_level_rec);

1668: END IF;
1669: ELSE -- if YTD deprn. is not to be revalued
1670: IF (p_log_level_rec.statement_level)
1671: THEN
1672: fa_debug_pkg.ADD ('fareven', 'reval_ytd_deprn_flag is NO', 1, p_log_level_rec => p_log_level_rec);
1673: END IF;
1674:
1675: x_reval_out.ytd_deprn_adj := 0;
1676: x_reval_out.bonus_ytd_deprn_adj := 0;

Line 1700: fa_debug_pkg.ADD ('fareven',

1696: x_reval_out.reval_rsv_adj + x_reval_out.ytd_deprn_adj;
1697:
1698: IF (p_log_level_rec.statement_level)
1699: THEN
1700: fa_debug_pkg.ADD ('fareven',
1701: 'x_reval_out.reval_rsv_adj',
1702: x_reval_out.reval_rsv_adj
1703: , p_log_level_rec => p_log_level_rec);
1704: END IF;

Line 1759: fa_debug_pkg.ADD ('fareven',

1755: END IF;
1756:
1757: IF (p_log_level_rec.statement_level)
1758: THEN
1759: fa_debug_pkg.ADD ('fareven',
1760: 'after calc_salvage_value SV',
1761: px_asset_fin_rec_new.salvage_value
1762: , p_log_level_rec => p_log_level_rec);
1763: fa_debug_pkg.ADD ('fareven',

Line 1763: fa_debug_pkg.ADD ('fareven',

1759: fa_debug_pkg.ADD ('fareven',
1760: 'after calc_salvage_value SV',
1761: px_asset_fin_rec_new.salvage_value
1762: , p_log_level_rec => p_log_level_rec);
1763: fa_debug_pkg.ADD ('fareven',
1764: 'after calc_rec_cost rec cost',
1765: px_asset_fin_rec_new.recoverable_cost
1766: , p_log_level_rec => p_log_level_rec);
1767: fa_debug_pkg.ADD ('fareven',

Line 1767: fa_debug_pkg.ADD ('fareven',

1763: fa_debug_pkg.ADD ('fareven',
1764: 'after calc_rec_cost rec cost',
1765: px_asset_fin_rec_new.recoverable_cost
1766: , p_log_level_rec => p_log_level_rec);
1767: fa_debug_pkg.ADD ('fareven',
1768: 'after calc_adj_rec_cost adj_rec_cost',
1769: px_asset_fin_rec_new.adjusted_recoverable_cost
1770: , p_log_level_rec => p_log_level_rec);
1771: END IF;

Line 1801: fa_debug_pkg.ADD ('fareven',

1797: IF (l_fully_rsvd_flag)
1798: THEN
1799: IF (p_log_level_rec.statement_level)
1800: THEN
1801: fa_debug_pkg.ADD ('fareven',
1802: 'REVALUE FULLY RESERVED ASSET',
1803: p_reval_options_rec.reval_fully_rsvd_flag
1804: , p_log_level_rec => p_log_level_rec);
1805: END IF;

Line 1839: fa_debug_pkg.ADD ('fareven',

1835: -- If life extension factor is not specified as a part
1836: -- of revaluation rules it is an error condition
1837: IF (p_log_level_rec.statement_level)
1838: THEN
1839: fa_debug_pkg.ADD ('fareven',
1840: 'l_life_extension_factor',
1841: l_life_extension_factor
1842: , p_log_level_rec => p_log_level_rec);
1843: END IF;

Line 1901: fa_debug_pkg.ADD ('fareven',

1897: END IF;
1898:
1899: IF (p_log_level_rec.statement_level)
1900: THEN
1901: fa_debug_pkg.ADD ('fareven',
1902: 'after calc_salvage_value SV',
1903: px_asset_fin_rec_new.salvage_value
1904: , p_log_level_rec => p_log_level_rec);
1905: fa_debug_pkg.ADD ('fareven',

Line 1905: fa_debug_pkg.ADD ('fareven',

1901: fa_debug_pkg.ADD ('fareven',
1902: 'after calc_salvage_value SV',
1903: px_asset_fin_rec_new.salvage_value
1904: , p_log_level_rec => p_log_level_rec);
1905: fa_debug_pkg.ADD ('fareven',
1906: 'after calc_rec_cost rec cost',
1907: px_asset_fin_rec_new.recoverable_cost
1908: , p_log_level_rec => p_log_level_rec);
1909: fa_debug_pkg.ADD

Line 1909: fa_debug_pkg.ADD

1905: fa_debug_pkg.ADD ('fareven',
1906: 'after calc_rec_cost rec cost',
1907: px_asset_fin_rec_new.recoverable_cost
1908: , p_log_level_rec => p_log_level_rec);
1909: fa_debug_pkg.ADD
1910: ('fareven',
1911: 'after calc_adj_rec_cost adj_rec_cost',
1912: px_asset_fin_rec_new.adjusted_recoverable_cost
1913: , p_log_level_rec => p_log_level_rec);

Line 1925: fa_debug_pkg.ADD ('fareven', 'reval_dep_rsv_flag is YES',

1921: THEN
1922: -- If Depreciation Reserve is to be revalued
1923: IF (p_log_level_rec.statement_level)
1924: THEN
1925: fa_debug_pkg.ADD ('fareven', 'reval_dep_rsv_flag is YES',
1926: 1, p_log_level_rec => p_log_level_rec);
1927: END IF;
1928:
1929: -- Extend Life by the life extension factor limited by

Line 1939: fa_debug_pkg.ADD ('fareven', 'RECALC LIFE1', 1, p_log_level_rec => p_log_level_rec);

1935: );
1936:
1937: IF (p_log_level_rec.statement_level)
1938: THEN
1939: fa_debug_pkg.ADD ('fareven', 'RECALC LIFE1', 1, p_log_level_rec => p_log_level_rec);
1940: fa_debug_pkg.ADD ('fareven',
1941: 'l_recalc_life1.1',
1942: l_recalc_life
1943: , p_log_level_rec => p_log_level_rec);

Line 1940: fa_debug_pkg.ADD ('fareven',

1936:
1937: IF (p_log_level_rec.statement_level)
1938: THEN
1939: fa_debug_pkg.ADD ('fareven', 'RECALC LIFE1', 1, p_log_level_rec => p_log_level_rec);
1940: fa_debug_pkg.ADD ('fareven',
1941: 'l_recalc_life1.1',
1942: l_recalc_life
1943: , p_log_level_rec => p_log_level_rec);
1944: END IF;

Line 1961: fa_debug_pkg.ADD ('fareven',

1957: END IF;
1958:
1959: IF (p_log_level_rec.statement_level)
1960: THEN
1961: fa_debug_pkg.ADD ('fareven',
1962: 'l_recalc_life1.2',
1963: l_recalc_life
1964: , p_log_level_rec => p_log_level_rec);
1965: END IF;

Line 1983: fa_debug_pkg.ADD ('fareven',

1979: IF (l_rate_source_rule = fa_std_types.fad_rsr_calc)
1980: THEN
1981: IF (p_log_level_rec.statement_level)
1982: THEN
1983: fa_debug_pkg.ADD ('fareven',
1984: 'calling',
1985: 'validate_life'
1986: , p_log_level_rec => p_log_level_rec);
1987: fa_debug_pkg.ADD

Line 1987: fa_debug_pkg.ADD

1983: fa_debug_pkg.ADD ('fareven',
1984: 'calling',
1985: 'validate_life'
1986: , p_log_level_rec => p_log_level_rec);
1987: fa_debug_pkg.ADD
1988: ('fareven',
1989: 'p_deprn_method',
1990: px_asset_fin_rec_new.deprn_method_code
1991: , p_log_level_rec => p_log_level_rec);

Line 1992: fa_debug_pkg.ADD ('fareven',

1988: ('fareven',
1989: 'p_deprn_method',
1990: px_asset_fin_rec_new.deprn_method_code
1991: , p_log_level_rec => p_log_level_rec);
1992: fa_debug_pkg.ADD ('fareven',
1993: 'l_recalc_life',
1994: l_recalc_life
1995: , p_log_level_rec => p_log_level_rec);
1996: END IF;

Line 2154: fa_debug_pkg.ADD ('fareven',

2150:
2151: --l_dpr_in.asset_type := p_asset_type_rec.asset_type;
2152: IF (p_log_level_rec.statement_level)
2153: THEN
2154: fa_debug_pkg.ADD ('fareven',
2155: 'CALLING FAXCDE FROM FAREVEN',
2156: 1
2157: , p_log_level_rec => p_log_level_rec);
2158: END IF;

Line 2261: fa_debug_pkg.ADD ('SORP Debug',

2257: -- GBertot: Compute adjustment to revaluation reserve due
2258: -- to YTD deprn.
2259: x_reval_out.reval_rsv_adj :=
2260: x_reval_out.reval_rsv_adj + x_reval_out.ytd_deprn_adj;
2261: fa_debug_pkg.ADD ('SORP Debug',
2262: 'p_asset_deprn_rec_old.impairment_reserve',
2263: p_asset_deprn_rec_old.impairment_reserve
2264: , p_log_level_rec => p_log_level_rec);
2265: fa_debug_pkg.ADD ('SORP Debug',

Line 2265: fa_debug_pkg.ADD ('SORP Debug',

2261: fa_debug_pkg.ADD ('SORP Debug',
2262: 'p_asset_deprn_rec_old.impairment_reserve',
2263: p_asset_deprn_rec_old.impairment_reserve
2264: , p_log_level_rec => p_log_level_rec);
2265: fa_debug_pkg.ADD ('SORP Debug',
2266: 'x_reval_out.cost_adj',
2267: x_reval_out.cost_adj
2268: , p_log_level_rec => p_log_level_rec);
2269:

Line 2340: fa_debug_pkg.ADD ('fareven', 'RECALC LIFE2', 1, p_log_level_rec => p_log_level_rec);

2336: l_recalc_life := TRUNC (l_recalc_life);
2337:
2338: IF (p_log_level_rec.statement_level)
2339: THEN
2340: fa_debug_pkg.ADD ('fareven', 'RECALC LIFE2', 1, p_log_level_rec => p_log_level_rec);
2341: fa_debug_pkg.ADD ('fareven', 'l_recalc_life2.1',
2342: l_recalc_life, p_log_level_rec => p_log_level_rec);
2343: END IF;
2344:

Line 2341: fa_debug_pkg.ADD ('fareven', 'l_recalc_life2.1',

2337:
2338: IF (p_log_level_rec.statement_level)
2339: THEN
2340: fa_debug_pkg.ADD ('fareven', 'RECALC LIFE2', 1, p_log_level_rec => p_log_level_rec);
2341: fa_debug_pkg.ADD ('fareven', 'l_recalc_life2.1',
2342: l_recalc_life, p_log_level_rec => p_log_level_rec);
2343: END IF;
2344:
2345: -- Find if the Depreciation Method for this

Line 2359: fa_debug_pkg.ADD ('fareven', 'fazccmt false', 1, p_log_level_rec => p_log_level_rec);

2355: , p_log_level_rec => p_log_level_rec)
2356: THEN
2357: IF (p_log_level_rec.statement_level)
2358: THEN
2359: fa_debug_pkg.ADD ('fareven', 'fazccmt false', 1, p_log_level_rec => p_log_level_rec);
2360: END IF;
2361:
2362: IF (l_rate_source_rule = fa_std_types.fad_rsr_calc)
2363: THEN

Line 2366: fa_debug_pkg.ADD ('fareven',

2362: IF (l_rate_source_rule = fa_std_types.fad_rsr_calc)
2363: THEN
2364: IF (p_log_level_rec.statement_level)
2365: THEN
2366: fa_debug_pkg.ADD ('fareven',
2367: 'calling validate_life',
2368: 1
2369: , p_log_level_rec => p_log_level_rec);
2370: END IF;

Line 2495: fa_debug_pkg.ADD ('fareven' || ' SORP',

2491: px_asset_deprn_rec_new.reval_deprn_reserve;
2492:
2493: IF (p_log_level_rec.statement_level)
2494: THEN
2495: fa_debug_pkg.ADD ('fareven' || ' SORP',
2496: 'Impairment_reserve',
2497: NVL (p_asset_deprn_rec_old.impairment_reserve,
2498: 0)
2499: );

Line 2500: fa_debug_pkg.ADD ('fareven' || ' SORP',

2496: 'Impairment_reserve',
2497: NVL (p_asset_deprn_rec_old.impairment_reserve,
2498: 0)
2499: );
2500: fa_debug_pkg.ADD ('fareven' || ' SORP',
2501: 'reval_deprn_reserve',
2502: px_asset_deprn_rec_new.reval_deprn_reserve
2503: , p_log_level_rec => p_log_level_rec);
2504: fa_debug_pkg.ADD ('fareven' || ' SORP',

Line 2504: fa_debug_pkg.ADD ('fareven' || ' SORP',

2500: fa_debug_pkg.ADD ('fareven' || ' SORP',
2501: 'reval_deprn_reserve',
2502: px_asset_deprn_rec_new.reval_deprn_reserve
2503: , p_log_level_rec => p_log_level_rec);
2504: fa_debug_pkg.ADD ('fareven' || ' SORP',
2505: 'reval_amortization_basis',
2506: px_asset_fin_rec_new.reval_amortization_basis
2507: , p_log_level_rec => p_log_level_rec);
2508: END IF;

Line 2795: fa_debug_pkg.ADD ('SORP ACCOUNTING', 'START', 'START', p_log_level_rec => p_log_level_rec);

2791: END IF;
2792: END IF;
2793:
2794: -- Bug 6666666 Start Additional Accounting Entries For SORP START
2795: fa_debug_pkg.ADD ('SORP ACCOUNTING', 'START', 'START', p_log_level_rec => p_log_level_rec);
2796: fa_debug_pkg.ADD ('SORP_ACCOUNTING',
2797: 'px_trans_rec.mass_reference_id',
2798: px_trans_rec.mass_reference_id
2799: , p_log_level_rec => p_log_level_rec);

Line 2796: fa_debug_pkg.ADD ('SORP_ACCOUNTING',

2792: END IF;
2793:
2794: -- Bug 6666666 Start Additional Accounting Entries For SORP START
2795: fa_debug_pkg.ADD ('SORP ACCOUNTING', 'START', 'START', p_log_level_rec => p_log_level_rec);
2796: fa_debug_pkg.ADD ('SORP_ACCOUNTING',
2797: 'px_trans_rec.mass_reference_id',
2798: px_trans_rec.mass_reference_id
2799: , p_log_level_rec => p_log_level_rec);
2800:

Line 2814: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'Failure', 'Failure', p_log_level_rec => p_log_level_rec);

2810: px_trans_rec.who_info.last_updated_by,
2811: px_trans_rec.who_info.last_update_date
2812: , p_log_level_rec => p_log_level_rec)
2813: THEN
2814: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'Failure', 'Failure', p_log_level_rec => p_log_level_rec);
2815: RAISE fareven_err;
2816: RETURN FALSE;
2817: END IF;
2818:

Line 2842: fa_debug_pkg.ADD ('fareven', 'failed', 'faxinaj for l_reval_loss_exp', p_log_level_rec => p_log_level_rec);

2838: )
2839: THEN
2840: IF (p_log_level_rec.statement_level)
2841: THEN
2842: fa_debug_pkg.ADD ('fareven', 'failed', 'faxinaj for l_reval_loss_exp', p_log_level_rec => p_log_level_rec);
2843: END IF;
2844: raise fareven_err;
2845: END IF;
2846: /* neutralizing entries for revaluation loss expense */

Line 2878: fa_debug_pkg.ADD ('fareven', 'failed', 'faxinaj for l_reval_deprn_exp', p_log_level_rec => p_log_level_rec);

2874: )
2875: THEN
2876: IF (p_log_level_rec.statement_level)
2877: THEN
2878: fa_debug_pkg.ADD ('fareven', 'failed', 'faxinaj for l_reval_deprn_exp', p_log_level_rec => p_log_level_rec);
2879: END IF;
2880: raise fareven_err;
2881: END IF;
2882: /* neutralizing entries */

Line 2912: fa_debug_pkg.ADD ('fareven', 'failed', 'faxinaj for l_reval_deprn_exp', p_log_level_rec => p_log_level_rec);

2908: )
2909: THEN
2910: IF (p_log_level_rec.statement_level)
2911: THEN
2912: fa_debug_pkg.ADD ('fareven', 'failed', 'faxinaj for l_reval_deprn_exp', p_log_level_rec => p_log_level_rec);
2913: END IF;
2914: raise fareven_err;
2915: END IF;
2916: /* neutralizing entries for depreciation expense */

Line 3584: fa_debug_pkg.add(l_calling_fn,'Process Depreciation', 'BEGIN', p_log_level_rec => p_log_level_rec);

3580: dpr_err exception;
3581: l_calling_fn VARCHAR2 (40) := 'FA_REVALUATION_PVT.process_depreciation';
3582: BEGIN
3583: if (p_log_level_rec.statement_level) then
3584: fa_debug_pkg.add(l_calling_fn,'Process Depreciation', 'BEGIN', p_log_level_rec => p_log_level_rec);
3585: end if;
3586:
3587: if px_asset_fin_rec_old.depreciate_flag = 'NO' OR p_asset_type_rec.asset_type <> 'CAPITALIZED' then
3588: return TRUE;

Line 3667: fa_debug_pkg.add(l_calling_fn, 'Error calling','FA_CDE_PKG.faxcde', p_log_level_rec => p_log_level_rec);

3663: g_dpr_out,
3664: l_running_mode,
3665: p_log_level_rec => p_log_level_rec) then
3666: if (p_log_level_rec.statement_level) then
3667: fa_debug_pkg.add(l_calling_fn, 'Error calling','FA_CDE_PKG.faxcde', p_log_level_rec => p_log_level_rec);
3668: end if;
3669:
3670: raise dpr_err;
3671: end if;

Line 3750: fa_debug_pkg.add(l_calling_fn, 'Rollback PDR', '$$$START$$$',p_log_level_rec => p_log_level_rec);

3746: begin
3747:
3748:
3749: if (p_log_level_rec.statement_level) then
3750: fa_debug_pkg.add(l_calling_fn, 'Rollback PDR', '$$$START$$$',p_log_level_rec => p_log_level_rec);
3751: fa_debug_pkg.add(l_calling_fn, 'Book: ', p_asset_hdr_rec.book_type_code,p_log_level_rec => p_log_level_rec);
3752: fa_debug_pkg.add(l_calling_fn, 'TH_Id: ', p_thid,p_log_level_rec => p_log_level_rec);
3753: fa_debug_pkg.add(l_calling_fn, 'Asset_id: ', p_asset_hdr_rec.asset_id,p_log_level_rec => p_log_level_rec);
3754: end if;

Line 3751: fa_debug_pkg.add(l_calling_fn, 'Book: ', p_asset_hdr_rec.book_type_code,p_log_level_rec => p_log_level_rec);

3747:
3748:
3749: if (p_log_level_rec.statement_level) then
3750: fa_debug_pkg.add(l_calling_fn, 'Rollback PDR', '$$$START$$$',p_log_level_rec => p_log_level_rec);
3751: fa_debug_pkg.add(l_calling_fn, 'Book: ', p_asset_hdr_rec.book_type_code,p_log_level_rec => p_log_level_rec);
3752: fa_debug_pkg.add(l_calling_fn, 'TH_Id: ', p_thid,p_log_level_rec => p_log_level_rec);
3753: fa_debug_pkg.add(l_calling_fn, 'Asset_id: ', p_asset_hdr_rec.asset_id,p_log_level_rec => p_log_level_rec);
3754: end if;
3755:

Line 3752: fa_debug_pkg.add(l_calling_fn, 'TH_Id: ', p_thid,p_log_level_rec => p_log_level_rec);

3748:
3749: if (p_log_level_rec.statement_level) then
3750: fa_debug_pkg.add(l_calling_fn, 'Rollback PDR', '$$$START$$$',p_log_level_rec => p_log_level_rec);
3751: fa_debug_pkg.add(l_calling_fn, 'Book: ', p_asset_hdr_rec.book_type_code,p_log_level_rec => p_log_level_rec);
3752: fa_debug_pkg.add(l_calling_fn, 'TH_Id: ', p_thid,p_log_level_rec => p_log_level_rec);
3753: fa_debug_pkg.add(l_calling_fn, 'Asset_id: ', p_asset_hdr_rec.asset_id,p_log_level_rec => p_log_level_rec);
3754: end if;
3755:
3756: if (NOT FA_UTIL_PVT.get_period_rec (

Line 3753: fa_debug_pkg.add(l_calling_fn, 'Asset_id: ', p_asset_hdr_rec.asset_id,p_log_level_rec => p_log_level_rec);

3749: if (p_log_level_rec.statement_level) then
3750: fa_debug_pkg.add(l_calling_fn, 'Rollback PDR', '$$$START$$$',p_log_level_rec => p_log_level_rec);
3751: fa_debug_pkg.add(l_calling_fn, 'Book: ', p_asset_hdr_rec.book_type_code,p_log_level_rec => p_log_level_rec);
3752: fa_debug_pkg.add(l_calling_fn, 'TH_Id: ', p_thid,p_log_level_rec => p_log_level_rec);
3753: fa_debug_pkg.add(l_calling_fn, 'Asset_id: ', p_asset_hdr_rec.asset_id,p_log_level_rec => p_log_level_rec);
3754: end if;
3755:
3756: if (NOT FA_UTIL_PVT.get_period_rec (
3757: p_book => p_asset_hdr_rec.book_type_code,

Line 3800: fa_debug_pkg.add(l_calling_fn, 'event status ', l_event_status,p_log_level_rec => p_log_level_rec);

3796:
3797: end if;
3798:
3799: if (p_log_level_rec.statement_level) then
3800: fa_debug_pkg.add(l_calling_fn, 'event status ', l_event_status,p_log_level_rec => p_log_level_rec);
3801: end if;
3802:
3803: -- If event is not processed no need to create rollback event
3804: if l_event_status <> XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED then

Line 3810: fa_debug_pkg.add(l_calling_fn,'Deleting unprocessed Reval event: '

3806: -- Delete the event if primary
3807: if p_mrc_sob_type_code <> 'R' then
3808:
3809: if (p_log_level_rec.statement_level) then
3810: fa_debug_pkg.add(l_calling_fn,'Deleting unprocessed Reval event: '
3811: , p_event_id,p_log_level_rec => p_log_level_rec);
3812: end if;
3813:
3814: if not fa_xla_events_pvt.delete_transaction_event

Line 3821: fa_debug_pkg.add(l_calling_fn,'Failed ','delete_transaction_event',p_log_level_rec => p_log_level_rec);

3817: p_book_type_code => p_asset_hdr_rec.book_type_code,
3818: p_calling_fn => l_calling_fn
3819: ,p_log_level_rec => p_log_level_rec) then
3820: if (p_log_level_rec.statement_level) then
3821: fa_debug_pkg.add(l_calling_fn,'Failed ','delete_transaction_event',p_log_level_rec => p_log_level_rec);
3822: end if;
3823: raise reval_err;
3824: end if;
3825:

Line 3827: fa_debug_pkg.add(l_calling_fn,'Deleting accounting entries of reval thid: '

3823: raise reval_err;
3824: end if;
3825:
3826: if (p_log_level_rec.statement_level) then
3827: fa_debug_pkg.add(l_calling_fn,'Deleting accounting entries of reval thid: '
3828: , p_thid,p_log_level_rec => p_log_level_rec);
3829: end if;
3830:
3831: delete from fa_books

Line 3867: fa_debug_pkg.add(l_calling_fn,'ALC Deleting accounting entries of reval thid: '

3863: -- Transaction / event is already deleted in the primary loop
3864: -- Need to handle only fa_mc_bk / adj
3865:
3866: if (p_log_level_rec.statement_level) then
3867: fa_debug_pkg.add(l_calling_fn,'ALC Deleting accounting entries of reval thid: '
3868: , p_thid,p_log_level_rec => p_log_level_rec);
3869: end if;
3870:
3871: delete from fa_mc_books

Line 3927: fa_debug_pkg.add(l_calling_fn,'Creating rollback reval transaction event'

3923: raise reval_err;
3924: end if;
3925:
3926: if (p_log_level_rec.statement_level) then
3927: fa_debug_pkg.add(l_calling_fn,'Creating rollback reval transaction event'
3928: , p_thid,p_log_level_rec => p_log_level_rec);
3929: end if;
3930:
3931: if not FA_XLA_EVENTS_PVT.create_transaction_event(

Line 3939: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling create_transaction_event'

3935: p_event_status => NULL,
3936: p_calling_fn => l_calling_fn
3937: ,p_log_level_rec => p_log_level_rec) then
3938: if (p_log_level_rec.statement_level) then
3939: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling create_transaction_event'
3940: ,p_log_level_rec => p_log_level_rec);
3941: end if;
3942: raise reval_err;
3943: end if;

Line 3972: fa_debug_pkg.add(l_calling_fn,'Inserting new thid: '

3968: ==================================================================*/
3969:
3970:
3971: if (p_log_level_rec.statement_level) then
3972: fa_debug_pkg.add(l_calling_fn,'Inserting new thid: '
3973: , l_trans_rec.transaction_header_id, p_log_level_rec => p_log_level_rec);
3974: end if;
3975:
3976: INSERT INTO FA_TRANSACTION_HEADERS(

Line 4395: fa_debug_pkg.add(l_calling_fn,'Finished with new thid: '

4391: AND ASSET_ID = p_asset_hdr_rec.asset_id
4392: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
4393:
4394: if (p_log_level_rec.statement_level) then
4395: fa_debug_pkg.add(l_calling_fn,'Finished with new thid: '
4396: , l_trans_rec.transaction_header_id, p_log_level_rec => p_log_level_rec);
4397: end if;
4398:
4399: else -- reporting loop

Line 4402: fa_debug_pkg.add(l_calling_fn,'ALC loop: '

4398:
4399: else -- reporting loop
4400:
4401: if (p_log_level_rec.statement_level) then
4402: fa_debug_pkg.add(l_calling_fn,'ALC loop: '
4403: , p_asset_hdr_rec.set_of_books_id, p_log_level_rec => p_log_level_rec);
4404: end if;
4405:
4406: -- Get the rollback reval trx_hdr_id

Line 4414: fa_debug_pkg.add(l_calling_fn,'ALC: Creating accounting for new thid: '

4410: , l_trans_rec.who_info.last_updated_by;
4411: close c_get_new_thid;
4412:
4413: if (p_log_level_rec.statement_level) then
4414: fa_debug_pkg.add(l_calling_fn,'ALC: Creating accounting for new thid: '
4415: , l_trans_rec.transaction_header_id, p_log_level_rec => p_log_level_rec);
4416: end if;
4417:
4418: INSERT INTO FA_MC_ADJUSTMENTS(

Line 4762: fa_debug_pkg.add(l_calling_fn,'ALC: Finished with new thid: '

4758: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4759: AND SET_OF_BOOKS_ID = p_asset_hdr_rec.set_of_books_id ;
4760:
4761: if (p_log_level_rec.statement_level) then
4762: fa_debug_pkg.add(l_calling_fn,'ALC: Finished with new thid: '
4763: , l_trans_rec.transaction_header_id, p_log_level_rec => p_log_level_rec);
4764: end if;
4765: end if;
4766: end if;

Line 4769: fa_debug_pkg.add(l_calling_fn, 'Rollback PDR', '$$$END$$$',p_log_level_rec => p_log_level_rec);

4765: end if;
4766: end if;
4767:
4768: if (p_log_level_rec.statement_level) then
4769: fa_debug_pkg.add(l_calling_fn, 'Rollback PDR', '$$$END$$$',p_log_level_rec => p_log_level_rec);
4770: end if;
4771:
4772: return true;
4773: