DBA Data[Home] [Help]

APPS.FARX_RP dependencies on FARX_RP

Line 1: PACKAGE BODY FARX_RP AS

1: PACKAGE BODY FARX_RP AS
2: /* $Header: FARXRPB.pls 120.10.12020000.2 2012/07/23 10:06:11 rmandali ship $ */
3:
4: -- Mass reclass record from fa_mass_reclass table.
5: mr_rec FA_MASS_REC_UTILS_PKG.mass_reclass_rec;

Line 284: fa_debug_pkg.add('FARX_RP.Preview_Reclass',

280: h_debug_flag := 'YES';
281: END IF;
282:
283: if (g_print_debug) then
284: fa_debug_pkg.add('FARX_RP.Preview_Reclass',
285: 'Starting Preview',
286: '');
287: end if;
288: /* Fix for BUG# 1302611 where rbs_name was being intepreted as a literal

Line 346: CALLING_FN => 'FARX_RP.Preview_Reclass',

342:
343: IF (h_preview_status_d <> h_current_status_d) THEN
344: -- Re-using message for mass reclass program.
345: FA_SRVR_MSG.Add_Message(
346: CALLING_FN => 'FARX_RP.Preview_Reclass',
347: NAME => 'FA_MASSRCL_WRONG_STATUS',
348: TOKEN1 => 'CURRENT',
349: VALUE1 => h_current_status_d,
350: TOKEN2 => 'RUNNING',

Line 427: fa_debug_pkg.add('FARX_RP.Preview_Reclass',

423: X_Asset_Id => a_tbl(a_index).asset_id,
424: X_Fully_Rsvd_Flag => mr_rec.fully_rsvd_flag) THEN
425:
426: if (g_print_debug) then
427: fa_debug_pkg.add('FARX_RP.Preview_Reclass',
428: 'Preview - after check_criteria',
429: a_tbl(a_index).asset_id );
430: end if;
431: IF (a_tbl(a_index).category_id = mr_rec.to_category_id) THEN

Line 460: fa_debug_pkg.add('FARX_RP.Preview_Reclass',

456: -- Increment the number of assets stored in a_tbl.
457: g_asset_count := g_asset_count + 1;
458: ELSE
459: if (g_print_debug) then
460: fa_debug_pkg.add('FARX_RP.Preview_Reclass',
461: 'Preview - validate_reclass_basic skipped asset',
462: a_tbl(a_index).asset_id );
463: end if;
464: -- Basic reclass validation failed. Reclass fails.

Line 470: fa_debug_pkg.add('FARX_RP.Preview_Reclass',

466: END IF; /* IF FA_REC_PVT_PKG1.Validate_Reclass_Basic */
467: END IF; /* IF (a_tbl(a_index).category_id = */
468: ELSE
469: if (g_print_debug) then
470: fa_debug_pkg.add('FARX_RP.Preview_Reclass',
471: 'Preview - check_criteria skipped asset ',
472: a_tbl(a_index).asset_id );
473: end if;
474: -- Invalid asset record.

Line 492: fa_debug_pkg.add('FARX_RP.Preview_Reclass',

488: -- and a_index to 0. Commit changes at every 200 assets as well.
489: IF (g_asset_count = h_commit_level) THEN
490: FOR i IN 1 .. a_index LOOP
491: if (g_print_debug) then
492: fa_debug_pkg.add('FARX_RP.Preview_Reclass',
493: 'Preview - inserting asset into itf-table',
494: a_tbl(a_index).asset_id );
495: end if;
496: FA_MASS_REC_UTILS_PKG.Insert_Itf(

Line 612: CALLING_FN => 'FARX_RP.Preview_Reclass');

608: WHEN OTHERS THEN
609: retcode := 2; -- Completed with error.
610: IF SQLCODE <> 0 THEN
611: FA_SRVR_MSG.Add_SQL_Error(
612: CALLING_FN => 'FARX_RP.Preview_Reclass');
613: END IF;
614:
615: -- Reset global variable values.
616: FA_LOAD_TBL_PKG.g_deprn_count := 0;

Line 802: CALLING_FN => 'FARX_RP.Store_Results',

798: x_pos => pos,
799: p_log_level_rec => g_log_level_rec);
800: IF pos IS NULL THEN
801: FA_SRVR_MSG.Add_Message(
802: CALLING_FN => 'FARX_RP.Store_Results',
803: NAME => 'FA_REC_NO_CAT_DEFAULTS');
804: raise store_failure;
805: END IF;
806:

Line 1007: CALLING_FN => 'FARX_RP.Store_Results');

1003:
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: FA_SRVR_MSG.Add_SQL_Error(
1007: CALLING_FN => 'FARX_RP.Store_Results');
1008: raise;
1009: END Store_Results;
1010:
1011:

Line 1089: CALLING_FN => 'FARX_RP.Check_Trans_Date_Book');

1085: p_trans_date => h_trans_date,
1086: p_log_level_rec => g_log_level_rec)
1087: THEN
1088: FA_SRVR_MSG.Add_Message(
1089: CALLING_FN => 'FARX_RP.Check_Trans_Date_Book');
1090: RETURN (FALSE);
1091: END IF;
1092:
1093: RETURN (TRUE);

Line 1098: CALLING_FN => 'FARX_RP.Check_Trans_Date_Book');

1094:
1095: EXCEPTION
1096: WHEN OTHERS THEN
1097: FA_SRVR_MSG.Add_SQL_Error(
1098: CALLING_FN => 'FARX_RP.Check_Trans_Date_Book');
1099: RETURN (FALSE);
1100: END Check_Trans_Date_Book;
1101:
1102:

Line 1103: END FARX_RP;

1099: RETURN (FALSE);
1100: END Check_Trans_Date_Book;
1101:
1102:
1103: END FARX_RP;