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_ADJUST_PKG dependencies on FA_INS_ADJUST_PKG

Line 1: PACKAGE BODY FA_INS_ADJUST_PKG as

1: PACKAGE BODY FA_INS_ADJUST_PKG as
2: /* $Header: FAXIAJ2B.pls 120.27.12020000.4 2012/11/14 10:05:51 rmandali ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:

Line 36: (fname => 'FA_INS_ADJUST_PKG.fadoflx',

32: BEGIN <>
33:
34: if (p_log_level_rec.statement_level) then
35: FA_DEBUG_PKG.ADD
36: (fname => 'FA_INS_ADJUST_PKG.fadoflx',
37: element => 'Dist Ccid in fadoflx is',
38: value => X_dist_ccid,
39: p_log_level_rec => p_log_level_rec);
40: end if;

Line 69: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoflx', p_log_level_rec => p_log_level_rec);

65: (X_book => X_book_type_code,
66: X_cat_id => X_cat_id, p_log_level_rec => p_log_level_rec) then
67: FA_SRVR_MSG.ADD_MESSAGE
68: (NAME => 'FA_GET_CAT_ID',
69: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoflx', p_log_level_rec => p_log_level_rec);
70: return FALSE;
71: end if;
72:
73: if (X_account_type='ASSET_COST_ACCT') then

Line 110: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoflx', p_log_level_rec => p_log_level_rec);

106: X_rtn_ccid => h_calculated_ccid, p_log_level_rec => p_log_level_rec)) then
107: h_mesg_name := 'FA_GET_ACCOUNT_CCID';
108: FA_SRVR_MSG.ADD_MESSAGE
109: (NAME => 'FA_GET_ACCOUNT_CCID',
110: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoflx', p_log_level_rec => p_log_level_rec);
111: return FALSE;
112: end if;
113:
114: X_calculated_ccid := h_calculated_ccid;

Line 117: 'FA_INS_ADJUST_PKG.fadoflx',

113:
114: X_calculated_ccid := h_calculated_ccid;
115: if (p_log_level_rec.statement_level) then
116: FA_DEBUG_PKG.ADD (
117: 'FA_INS_ADJUST_PKG.fadoflx',
118: 'h_calc_ccid',
119: h_calculated_ccid, p_log_level_rec => p_log_level_rec);
120: end if;
121: elsif (X_gen_ccid_flag = TRUE and

Line 132: 'FA_INS_ADJUST_PKG.fadoflx',

128: -- gen ccid
129: X_calculated_ccid := X_spec_ccid;
130: if (p_log_level_rec.statement_level) then
131: FA_DEBUG_PKG.ADD (
132: 'FA_INS_ADJUST_PKG.fadoflx',
133: 'h_calc_ccid',
134: X_spec_ccid, p_log_level_rec => p_log_level_rec);
135: end if;
136: elsif (G_release = 11) then

Line 146: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoflx',

142:
143: EXCEPTION
144: WHEN OTHERS then
145: FA_SRVR_MSG.ADD_SQL_ERROR
146: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoflx',
147: p_log_level_rec => p_log_level_rec);
148: return FALSE;
149: END fadoflx;
150:

Line 202: 'FA_INS_ADJUST_PKG.factotp',

198:
199: total_amount := h_total_amount;
200: if (p_log_level_rec.statement_level) then
201: FA_DEBUG_PKG.ADD (
202: 'FA_INS_ADJUST_PKG.factotp',
203: 'total_amount',
204: h_total_amount,
205: p_log_level_rec => p_log_level_rec);
206: end if;

Line 253: (fname => 'FA_INS_ADJUST_PKG.facdamt',

249:
250: adj_dd_amount := h_adj_dd_amount;
251: if (p_log_level_rec.statement_level) then
252: FA_DEBUG_PKG.ADD
253: (fname => 'FA_INS_ADJUST_PKG.facdamt',
254: element => 'h_adj_dd_amount',
255: value => h_adj_dd_amount,
256: p_log_level_rec => p_log_level_rec);
257: end if;

Line 263: (CALLING_FN => 'FA_INS_ADJUST_PKG.facdamt',

259:
260: EXCEPTION
261: WHEN OTHERS then
262: FA_SRVR_MSG.ADD_SQL_ERROR
263: (CALLING_FN => 'FA_INS_ADJUST_PKG.facdamt',
264: p_log_level_rec => p_log_level_rec);
265: return FALSE;
266: END facdamt;
267:

Line 300: CALLING_FN => 'FA_INS_ADJUST_PKG.fagetcc',

296: EXCEPTION
297: WHEN NO_DATA_FOUND then
298: FA_SRVR_MSG.ADD_MESSAGE
299: (NAME => h_mesg_name,
300: CALLING_FN => 'FA_INS_ADJUST_PKG.fagetcc',
301: p_log_level_rec => p_log_level_rec);
302: return FALSE;
303: WHEN OTHERS then
304: FA_SRVR_MSG.ADD_SQL_ERROR

Line 305: (CALLING_FN => 'FA_INS_ADJUST_PKG.fagetcc',

301: p_log_level_rec => p_log_level_rec);
302: return FALSE;
303: WHEN OTHERS then
304: FA_SRVR_MSG.ADD_SQL_ERROR
305: (CALLING_FN => 'FA_INS_ADJUST_PKG.fagetcc',
306: p_log_level_rec => p_log_level_rec);
307: return FALSE;
308:
309: END fagetcc;

Line 475: (CALLING_FN => 'FA_INS_ADJUST_PKG.fainajc',

471: X_book => adj_ptr.book_type_code,
472: X_set_of_books_id => adj_ptr.set_of_books_id,
473: p_log_level_rec => p_log_level_rec)) THEN
474: FA_SRVR_MSG.add_message
475: (CALLING_FN => 'FA_INS_ADJUST_PKG.fainajc',
476: p_log_level_rec => p_log_level_rec);
477: return (FALSE);
478: END IF;
479:

Line 723: CALLING_FN => 'FA_INS_ADJUST_PKG.fainajc',

719: EXCEPTION
720: WHEN NO_DATA_FOUND then
721: FA_SRVR_MSG.ADD_MESSAGE
722: (NAME => h_mesg_name,
723: CALLING_FN => 'FA_INS_ADJUST_PKG.fainajc',
724: p_log_level_rec => p_log_level_rec);
725: return FALSE;
726: WHEN OTHERS then
727: FA_SRVR_MSG.ADD_SQL_ERROR

Line 728: (CALLING_FN => 'FA_INS_ADJUST_PKG.fainajc',

724: p_log_level_rec => p_log_level_rec);
725: return FALSE;
726: WHEN OTHERS then
727: FA_SRVR_MSG.ADD_SQL_ERROR
728: (CALLING_FN => 'FA_INS_ADJUST_PKG.fainajc',
729: p_log_level_rec => p_log_level_rec);
730: return FALSE;
731: END fainajc;
732:

Line 805: (fname => 'FA_INS_ADJUST_PKG.fadoact',

801: h_asset_id := adj_ptr.asset_id;
802:
803: if (p_log_level_rec.statement_level) then
804: FA_DEBUG_PKG.ADD
805: (fname => 'FA_INS_ADJUST_PKG.fadoact',
806: element => 'Before Flush',
807: value => 'TRUE',
808: p_log_level_rec => p_log_level_rec);
809: end if;

Line 819: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',

815: X_last_updated_by => X_last_updated_by,
816: X_last_update_login => X_last_update_login,
817: p_log_level_rec => p_log_level_rec)) then
818: FA_SRVR_MSG.ADD_MESSAGE
819: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',
820: p_log_level_rec => p_log_level_rec);
821: return FALSE;
822: end if;
823:

Line 838: 'FA_INS_ADJUST_PKG.fadoact',

834: (H_DPR_ROW,
835: 'STANDARD',
836: FALSE,
837: H_SUCCESS,
838: 'FA_INS_ADJUST_PKG.fadoact',
839: -1,
840: p_log_level_rec => p_log_level_rec);
841:
842: -- Assign H_DPR_ROW to dpr_ptr

Line 898: (fname => 'FA_INS_ADJUST_PKG.fadoact',

894: -- Calculate the total_amount to prorate based on the
895: -- adjustment_type.
896: if (p_log_level_rec.statement_level) then
897: FA_DEBUG_PKG.ADD
898: (fname => 'FA_INS_ADJUST_PKG.fadoact',
899: element => 'ALL BLANKS',
900: value => ' ',
901: p_log_level_rec => p_log_level_rec);
902: FA_DEBUG_PKG.ADD

Line 903: (fname => 'FA_INS_ADJUST_PKG.fadoact',

899: element => 'ALL BLANKS',
900: value => ' ',
901: p_log_level_rec => p_log_level_rec);
902: FA_DEBUG_PKG.ADD
903: (fname => 'FA_INS_ADJUST_PKG.fadoact',
904: element => 'adj_ptr.amount',
905: value => h_adjustment_amount,
906: p_log_level_rec => p_log_level_rec);
907: end if;

Line 918: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',

914: (total_amount => h_total_amount,
915: adjustment_amount => h_adjustment_amount,
916: p_log_level_rec => p_log_level_rec)) then
917: FA_SRVR_MSG.ADD_MESSAGE
918: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',
919: p_log_level_rec => p_log_level_rec);
920: return FALSE;
921: end if;
922:

Line 925: (fname => 'FA_INS_ADJUST_PKG.fadoact',

921: end if;
922:
923: if (p_log_level_rec.statement_level) then
924: FA_DEBUG_PKG.ADD
925: (fname => 'FA_INS_ADJUST_PKG.fadoact',
926: element => 'Total Amount',
927: value => h_total_amount,
928: p_log_level_rec => p_log_level_rec);
929: end if;

Line 1079: FA_SRVR_MSG.add_message(CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact');

1075: IF (NOT FA_UTILS_PKG.faxrnd(X_amount => h_new_dist_rsv,
1076: X_book => adj_ptr.book_type_code,
1077: X_set_of_books_id => adj_ptr.set_of_books_id,
1078: p_log_level_rec => p_log_level_rec)) THEN
1079: FA_SRVR_MSG.add_message(CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact');
1080: return (FALSE);
1081: END IF;
1082: if (p_log_level_rec.statement_level) then
1083: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);

Line 1083: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);

1079: FA_SRVR_MSG.add_message(CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact');
1080: return (FALSE);
1081: END IF;
1082: if (p_log_level_rec.statement_level) then
1083: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1084: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1085: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1086: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.cost ',value => h_dpr_row.cost,p_log_level_rec => p_log_level_rec);
1087: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_tot_cost ',value => h_tot_cost,p_log_level_rec => p_log_level_rec);

Line 1084: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);

1080: return (FALSE);
1081: END IF;
1082: if (p_log_level_rec.statement_level) then
1083: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1084: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1085: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1086: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.cost ',value => h_dpr_row.cost,p_log_level_rec => p_log_level_rec);
1087: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_tot_cost ',value => h_tot_cost,p_log_level_rec => p_log_level_rec);
1088: end if;

Line 1085: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);

1081: END IF;
1082: if (p_log_level_rec.statement_level) then
1083: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1084: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1085: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1086: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.cost ',value => h_dpr_row.cost,p_log_level_rec => p_log_level_rec);
1087: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_tot_cost ',value => h_tot_cost,p_log_level_rec => p_log_level_rec);
1088: end if;
1089: if adj_ptr.adjustment_type = 'IMPAIR RESERVE' then

Line 1086: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.cost ',value => h_dpr_row.cost,p_log_level_rec => p_log_level_rec);

1082: if (p_log_level_rec.statement_level) then
1083: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1084: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1085: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1086: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.cost ',value => h_dpr_row.cost,p_log_level_rec => p_log_level_rec);
1087: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_tot_cost ',value => h_tot_cost,p_log_level_rec => p_log_level_rec);
1088: end if;
1089: if adj_ptr.adjustment_type = 'IMPAIR RESERVE' then
1090: h_dist_rsv := H_DPR_ROW.impairment_rsv;

Line 1087: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_tot_cost ',value => h_tot_cost,p_log_level_rec => p_log_level_rec);

1083: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1084: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1085: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1086: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.cost ',value => h_dpr_row.cost,p_log_level_rec => p_log_level_rec);
1087: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_tot_cost ',value => h_tot_cost,p_log_level_rec => p_log_level_rec);
1088: end if;
1089: if adj_ptr.adjustment_type = 'IMPAIR RESERVE' then
1090: h_dist_rsv := H_DPR_ROW.impairment_rsv;
1091: else

Line 1102: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);

1098: else
1099: h_amount_to_insert := (h_total_amount * (h_units_assigned/adj_ptr.current_units) ) - h_adj_dd_amount;
1100: end if;
1101: if (p_log_level_rec.statement_level) then
1102: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1103: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1104: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1105: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);
1106: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);

Line 1103: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);

1099: h_amount_to_insert := (h_total_amount * (h_units_assigned/adj_ptr.current_units) ) - h_adj_dd_amount;
1100: end if;
1101: if (p_log_level_rec.statement_level) then
1102: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1103: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1104: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1105: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);
1106: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);
1107: END IF;

Line 1104: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);

1100: end if;
1101: if (p_log_level_rec.statement_level) then
1102: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1103: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1104: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1105: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);
1106: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);
1107: END IF;
1108: else

Line 1105: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);

1101: if (p_log_level_rec.statement_level) then
1102: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1103: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1104: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1105: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);
1106: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);
1107: END IF;
1108: else
1109: h_amount_to_insert := (h_total_amount * (h_units_assigned/adj_ptr.current_units) ) - h_adj_dd_amount;

Line 1106: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);

1102: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1103: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1104: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1105: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);
1106: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);
1107: END IF;
1108: else
1109: h_amount_to_insert := (h_total_amount * (h_units_assigned/adj_ptr.current_units) ) - h_adj_dd_amount;
1110: end if;

Line 1116: (fname => 'FA_INS_ADJUST_PKG.fadoact',

1112: else
1113: -- Last distribution gets extra
1114: if (p_log_level_rec.statement_level) then
1115: FA_DEBUG_PKG.ADD
1116: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1117: element => 'Total Amount',
1118: value => h_total_amount,
1119: p_log_level_rec => p_log_level_rec);
1120: end if;

Line 1134: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);

1130: and (nvl(h_pd_fully_rsv,-1) = -1 )
1131: then
1132: h_amount_to_insert := h_total_amount - h_amount_so_far ;
1133: if (p_log_level_rec.statement_level) then
1134: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);
1135: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1136: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1137: END IF;
1138: ELSE

Line 1135: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);

1131: then
1132: h_amount_to_insert := h_total_amount - h_amount_so_far ;
1133: if (p_log_level_rec.statement_level) then
1134: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);
1135: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1136: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1137: END IF;
1138: ELSE
1139: h_amount_to_insert := h_total_amount - h_amount_so_far;

Line 1136: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);

1132: h_amount_to_insert := h_total_amount - h_amount_so_far ;
1133: if (p_log_level_rec.statement_level) then
1134: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);
1135: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1136: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1137: END IF;
1138: ELSE
1139: h_amount_to_insert := h_total_amount - h_amount_so_far;
1140: end if;

Line 1155: FA_SRVR_MSG.add_message(CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact');

1151: IF (NOT FA_UTILS_PKG.faxrnd(X_amount => h_new_dist_rsv,
1152: X_book => adj_ptr.book_type_code,
1153: X_set_of_books_id => adj_ptr.set_of_books_id,
1154: p_log_level_rec => p_log_level_rec)) THEN
1155: FA_SRVR_MSG.add_message(CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact');
1156: return (FALSE);
1157: END IF;
1158: if (p_log_level_rec.statement_level) then
1159: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);

Line 1159: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);

1155: FA_SRVR_MSG.add_message(CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact');
1156: return (FALSE);
1157: END IF;
1158: if (p_log_level_rec.statement_level) then
1159: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1160: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1161: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1162: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);
1163: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);

Line 1160: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);

1156: return (FALSE);
1157: END IF;
1158: if (p_log_level_rec.statement_level) then
1159: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1160: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1161: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1162: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);
1163: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);
1164: END IF;

Line 1161: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);

1157: END IF;
1158: if (p_log_level_rec.statement_level) then
1159: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1160: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1161: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1162: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);
1163: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);
1164: END IF;
1165: if adj_ptr.adjustment_type = 'IMPAIR RESERVE' then

Line 1162: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);

1158: if (p_log_level_rec.statement_level) then
1159: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1160: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1161: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1162: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);
1163: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);
1164: END IF;
1165: if adj_ptr.adjustment_type = 'IMPAIR RESERVE' then
1166: h_dist_rsv := H_DPR_ROW.impairment_rsv;

Line 1163: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);

1159: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1160: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_asset_rsv ',value => h_asset_rsv,p_log_level_rec => p_log_level_rec);
1161: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_total_amount ',value => h_total_amount,p_log_level_rec => p_log_level_rec);
1162: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far ',value => h_amount_so_far,p_log_level_rec => p_log_level_rec);
1163: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);
1164: END IF;
1165: if adj_ptr.adjustment_type = 'IMPAIR RESERVE' then
1166: h_dist_rsv := H_DPR_ROW.impairment_rsv;
1167: else

Line 1178: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);

1174: else
1175: h_amount_to_insert := h_adjustment_amount - h_amount_so_far;
1176: end if;
1177: if (p_log_level_rec.statement_level) then
1178: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1179: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1180: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);
1181: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1182: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);

Line 1179: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);

1175: h_amount_to_insert := h_adjustment_amount - h_amount_so_far;
1176: end if;
1177: if (p_log_level_rec.statement_level) then
1178: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1179: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1180: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);
1181: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1182: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);
1183: END IF;

Line 1180: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);

1176: end if;
1177: if (p_log_level_rec.statement_level) then
1178: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1179: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1180: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);
1181: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1182: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);
1183: END IF;
1184: ELSE

Line 1181: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);

1177: if (p_log_level_rec.statement_level) then
1178: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1179: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1180: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);
1181: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1182: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);
1183: END IF;
1184: ELSE
1185: h_amount_to_insert := h_adjustment_amount - h_amount_so_far;

Line 1182: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);

1178: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_amount_to_insert ',value => h_amount_to_insert,p_log_level_rec => p_log_level_rec);
1179: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1180: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_adj_dd_amount ',value => h_adj_dd_amount,p_log_level_rec => p_log_level_rec);
1181: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dpr_row.deprn_rsv ',value => h_dpr_row.deprn_rsv,p_log_level_rec => p_log_level_rec);
1182: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact',element => '+++ h_dist_rsv ',value => h_dist_rsv,p_log_level_rec => p_log_level_rec);
1183: END IF;
1184: ELSE
1185: h_amount_to_insert := h_adjustment_amount - h_amount_so_far;
1186: END IF;

Line 1194: (fname => 'FA_INS_ADJUST_PKG.fadoact',

1190: end if;
1191:
1192: if (p_log_level_rec.statement_level) then
1193: FA_DEBUG_PKG.ADD
1194: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1195: element => 'ADJ_PTR.ADJUSTMENT_AMOUNT -LAST DIST',
1196: value => h_adjustment_amount,
1197: p_log_level_rec => p_log_level_rec);
1198: FA_DEBUG_PKG.ADD

Line 1199: (fname => 'FA_INS_ADJUST_PKG.fadoact',

1195: element => 'ADJ_PTR.ADJUSTMENT_AMOUNT -LAST DIST',
1196: value => h_adjustment_amount,
1197: p_log_level_rec => p_log_level_rec);
1198: FA_DEBUG_PKG.ADD
1199: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1200: element => 'AMOUNT SO FAR-LAST DIST',
1201: value => h_amount_so_far,
1202: p_log_level_rec => p_log_level_rec);
1203: FA_DEBUG_PKG.ADD

Line 1204: (fname => 'FA_INS_ADJUST_PKG.fadoact',

1200: element => 'AMOUNT SO FAR-LAST DIST',
1201: value => h_amount_so_far,
1202: p_log_level_rec => p_log_level_rec);
1203: FA_DEBUG_PKG.ADD
1204: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1205: element => 'h_amount_to_insert',
1206: value => h_amount_to_insert,
1207: p_log_level_rec => p_log_level_rec);
1208: end if;

Line 1216: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',

1212: X_book => adj_ptr.book_type_code,
1213: X_set_of_books_id => adj_ptr.set_of_books_id,
1214: p_log_level_rec => p_log_level_rec)) THEN
1215: FA_SRVR_MSG.add_message
1216: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',
1217: p_log_level_rec => p_log_level_rec);
1218: return (FALSE);
1219: END IF;
1220: if (p_log_level_rec.statement_level) then

Line 1221: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ##',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);

1217: p_log_level_rec => p_log_level_rec);
1218: return (FALSE);
1219: END IF;
1220: if (p_log_level_rec.statement_level) then
1221: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ##',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);
1222: END IF;
1223: h_amount_so_far:=h_amount_so_far+h_amount_to_insert;
1224: h_amount_so_far_dist :=h_amount_so_far_dist +h_new_dist_rsv;
1225:

Line 1227: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ## 2 ',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);

1223: h_amount_so_far:=h_amount_so_far+h_amount_to_insert;
1224: h_amount_so_far_dist :=h_amount_so_far_dist +h_new_dist_rsv;
1225:
1226: if (p_log_level_rec.statement_level) then
1227: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ## 2 ',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);
1228: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ## 2 ',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1229: FA_DEBUG_PKG.ADD
1230: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1231: element => 'dist ccid in fadoact',

Line 1228: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ## 2 ',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);

1224: h_amount_so_far_dist :=h_amount_so_far_dist +h_new_dist_rsv;
1225:
1226: if (p_log_level_rec.statement_level) then
1227: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ## 2 ',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);
1228: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ## 2 ',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1229: FA_DEBUG_PKG.ADD
1230: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1231: element => 'dist ccid in fadoact',
1232: value => h_dist_ccid,

Line 1230: (fname => 'FA_INS_ADJUST_PKG.fadoact',

1226: if (p_log_level_rec.statement_level) then
1227: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ## 2 ',element => '+++ h_amount_so_far_dist ',value => h_amount_so_far_dist,p_log_level_rec => p_log_level_rec);
1228: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadoact ## 2 ',element => '+++ h_new_dist_rsv ',value => h_new_dist_rsv,p_log_level_rec => p_log_level_rec);
1229: FA_DEBUG_PKG.ADD
1230: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1231: element => 'dist ccid in fadoact',
1232: value => h_dist_ccid,
1233: p_log_level_rec => p_log_level_rec);
1234: FA_DEBUG_PKG.ADD

Line 1235: (fname => 'FA_INS_ADJUST_PKG.fadoact',

1231: element => 'dist ccid in fadoact',
1232: value => h_dist_ccid,
1233: p_log_level_rec => p_log_level_rec);
1234: FA_DEBUG_PKG.ADD
1235: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1236: element => 'Amount so far-amount inserted ',
1237: value => h_amount_so_far,
1238: p_log_level_rec => p_log_level_rec);
1239: end if;

Line 1272: (fname => 'FA_INS_ADJUST_PKG.fadoact',

1268: end if;
1269:
1270: if (p_log_level_rec.statement_level) then
1271: FA_DEBUG_PKG.ADD
1272: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1273: element => 'Adj Amt in fadoact',
1274: value => h_amount_to_insert,
1275: p_log_level_rec => p_log_level_rec);
1276: end if;

Line 1290: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',

1286: X_last_updated_by => X_last_updated_by,
1287: X_last_update_login => X_last_update_login,
1288: p_log_level_rec => p_log_level_rec)) then
1289: FA_SRVR_MSG.ADD_MESSAGE
1290: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',
1291: p_log_level_rec => p_log_level_rec);
1292: return FALSE;
1293: end if;
1294: end loop;

Line 1302: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',

1298:
1299: exception
1300: when others then
1301: FA_SRVR_MSG.ADD_SQL_ERROR
1302: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoact',
1303: p_log_level_rec => p_log_level_rec);
1304: return FALSE;
1305:
1306: END fadoact;

Line 1372: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',

1368: X_last_update_login => X_last_update_login,
1369: p_log_level_rec => p_log_level_rec)) then
1370: FA_SRVR_MSG.ADD_MESSAGE
1371: (NAME => 'FA_GET_CAT_ID',
1372: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',
1373: p_log_level_rec => p_log_level_rec);
1374: return FALSE;
1375: end if;
1376:

Line 1381: (fname => 'FA_INS_ADJUST_PKG.fadoclr',

1377: -- no need to call book controls cache here - it should already be loaded
1378: h_dist_book := FA_CACHE_PKG.fazcbc_record.distribution_source_book;
1379: if (p_log_level_rec.statement_level) then
1380: FA_DEBUG_PKG.ADD
1381: (fname => 'FA_INS_ADJUST_PKG.fadoclr',
1382: element => 'Dist Ccid in fadoclr is',
1383: value => h_dist_ccid,
1384: p_log_level_rec => p_log_level_rec);
1385: end if;

Line 1412: 'FA_INS_ADJUST_PKG.fadoclr',

1408: (H_DPR_ROW,
1409: 'STANDARD',
1410: FALSE,
1411: H_SUCCESS,
1412: 'FA_INS_ADJUST_PKG.fadoclr',
1413: -1,
1414: p_log_level_rec => p_log_level_rec);
1415:
1416: -- Assign H_DPR_ROW to dpr_ptr. They are of same type

Line 1423: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',

1419: -- call facdamt to calculate the detail amount for leveling
1420: if (not facdamt(adj_dd_amount=>h_adj_dd_amount,
1421: p_log_level_rec => p_log_level_rec)) then
1422: FA_SRVR_MSG.ADD_MESSAGE
1423: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',
1424: NAME => h_mesg_name,
1425: p_log_level_rec => p_log_level_rec);
1426: end if;
1427:

Line 1432: (fname => 'FA_INS_ADJUST_PKG.fadoclr',

1428: h_amount_to_insert := h_adj_dd_amount;
1429:
1430: if (p_log_level_rec.statement_level) then
1431: FA_DEBUG_PKG.ADD
1432: (fname => 'FA_INS_ADJUST_PKG.fadoclr',
1433: element => 'JUST BLANK',
1434: value => '00000000000000000000000000',
1435: p_log_level_rec => p_log_level_rec);
1436: FA_DEBUG_PKG.ADD

Line 1437: (fname => 'FA_INS_ADJUST_PKG.fadoclr',

1433: element => 'JUST BLANK',
1434: value => '00000000000000000000000000',
1435: p_log_level_rec => p_log_level_rec);
1436: FA_DEBUG_PKG.ADD
1437: (fname => 'FA_INS_ADJUST_PKG.fadoclr',
1438: element => 'DD ADJ AMOUNT-after FACDAMT',
1439: value => h_adj_dd_amount,
1440: p_log_level_rec => p_log_level_rec);
1441: FA_DEBUG_PKG.ADD

Line 1442: (fname => 'FA_INS_ADJUST_PKG.fadoclr',

1438: element => 'DD ADJ AMOUNT-after FACDAMT',
1439: value => h_adj_dd_amount,
1440: p_log_level_rec => p_log_level_rec);
1441: FA_DEBUG_PKG.ADD
1442: (fname => 'FA_INS_ADJUST_PKG.fadoclr',
1443: element => 'amount to insert-after FACDAMT',
1444: value => h_amount_to_insert,
1445: p_log_level_rec => p_log_level_rec);
1446: end if;

Line 1455: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',

1451: X_book => adj_ptr.book_type_code,
1452: X_set_of_books_id => adj_ptr.set_of_books_id,
1453: p_log_level_rec => p_log_level_rec)) THEN
1454: FA_SRVR_MSG.add_message(
1455: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',
1456: p_log_level_rec => p_log_level_rec);
1457: return (FALSE);
1458: END IF;
1459:

Line 1465: (fname => 'FA_INS_ADJUST_PKG.fadoclr',

1461: h_amount_so_far := h_amount_so_far + h_amount_to_insert;
1462:
1463: if (p_log_level_rec.statement_level) then
1464: FA_DEBUG_PKG.ADD
1465: (fname => 'FA_INS_ADJUST_PKG.fadoclr',
1466: element => 'amount to insert-AFTER ROUNDING',
1467: value => h_amount_to_insert,
1468: p_log_level_rec => p_log_level_rec);
1469: FA_DEBUG_PKG.ADD

Line 1470: (fname => 'FA_INS_ADJUST_PKG.fadoclr',

1466: element => 'amount to insert-AFTER ROUNDING',
1467: value => h_amount_to_insert,
1468: p_log_level_rec => p_log_level_rec);
1469: FA_DEBUG_PKG.ADD
1470: (fname => 'FA_INS_ADJUST_PKG.fadoclr',
1471: element => 'amount so far-AFTER ROUNDING',
1472: value => h_amount_so_far,
1473: p_log_level_rec => p_log_level_rec);
1474: end if;

Line 1518: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',

1514: X_last_update_login => X_last_update_login,
1515: p_log_level_rec => p_log_level_rec)) then
1516: FA_SRVR_MSG.ADD_MESSAGE
1517: (NAME => 'FA_GET_CAT_ID',
1518: CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',
1519: p_log_level_rec => p_log_level_rec);
1520: return FALSE;
1521: end if;
1522: end if; -- thid<>adj_ptr.selection_thid

Line 1529: (fname => 'FA_INS_ADJUST_PKG.fadoclr',

1525: adj_ptr.amount_inserted := h_amount_so_far;
1526:
1527: if (p_log_level_rec.statement_level) then
1528: FA_DEBUG_PKG.ADD
1529: (fname => 'FA_INS_ADJUST_PKG.fadoclr',
1530: element => 'AMOUNT INSERTED ',
1531: value => adj_ptr.amount_inserted,
1532: p_log_level_rec => p_log_level_rec);
1533: FA_DEBUG_PKG.ADD

Line 1534: (fname => 'FA_INS_ADJUST_PKG.fadoclr',

1530: element => 'AMOUNT INSERTED ',
1531: value => adj_ptr.amount_inserted,
1532: p_log_level_rec => p_log_level_rec);
1533: FA_DEBUG_PKG.ADD
1534: (fname => 'FA_INS_ADJUST_PKG.fadoclr',
1535: element => 'AMOUNT SO FAR ',
1536: value => h_amount_so_far,
1537: p_log_level_rec => p_log_level_rec);
1538: end if;

Line 1544: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',

1540:
1541: exception
1542: when others then
1543: FA_SRVR_MSG.ADD_SQL_ERROR
1544: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoclr',
1545: p_log_level_rec => p_log_level_rec);
1546: return FALSE;
1547:
1548: END fadoclr;

Line 1571: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosglf',

1567: X_last_updated_by => X_last_updated_by,
1568: X_last_update_login => X_last_update_login,
1569: p_log_level_rec => p_log_level_rec)) then
1570: FA_SRVR_MSG.ADD_MESSAGE
1571: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosglf',
1572: p_log_level_rec => p_log_level_rec);
1573: return FALSE;
1574: end if;
1575:

Line 1604: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosglf',

1600: X_book => adj_ptr.book_type_code,
1601: X_set_of_books_id => adj_ptr.set_of_books_id,
1602: p_log_level_rec => p_log_level_rec))then
1603: FA_SRVR_MSG.add_message
1604: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosglf',
1605: p_log_level_rec => p_log_level_rec);
1606: return (FALSE);
1607: end if;
1608:

Line 1627: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosglf',

1623: X_last_updated_by => X_last_updated_by,
1624: X_last_update_login => X_last_update_login,
1625: p_log_level_rec => p_log_level_rec)) then
1626: FA_SRVR_MSG.ADD_MESSAGE
1627: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosglf',
1628: p_log_level_rec => p_log_level_rec);
1629: return FALSE;
1630: end if;
1631:

Line 1634: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadosglf',

1630: end if;
1631:
1632: adj_ptr.amount_inserted:=adj_ptr.adjustment_amount;
1633: if (p_log_level_rec.statement_level) then
1634: FA_DEBUG_PKG.ADD (fname => 'FA_INS_ADJUST_PKG.fadosglf',
1635: element => 'Amt Inserted-before return',
1636: value => adj_ptr.amount_inserted,
1637: p_log_level_rec => p_log_level_rec);
1638: end if;

Line 1644: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosglf',

1640:
1641: exception
1642: when others then
1643: FA_SRVR_MSG.ADD_SQL_ERROR
1644: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosglf',
1645: p_log_level_rec => p_log_level_rec);
1646: return FALSE;
1647:
1648: END fadosglf;

Line 1692: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosgl',

1688: X_book => adj_ptr.book_type_code,
1689: X_set_of_books_id => adj_ptr.set_of_books_id,
1690: p_log_level_rec => p_log_level_rec)) then
1691: FA_SRVR_MSG.add_message
1692: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosgl',
1693: p_log_level_rec => p_log_level_rec);
1694: return (FALSE);
1695: end if;
1696:

Line 1717: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosgl',

1713: X_last_updated_by => X_last_updated_by,
1714: X_last_update_login => X_last_update_login,
1715: p_log_level_rec => p_log_level_rec)) then
1716: FA_SRVR_MSG.ADD_MESSAGE
1717: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosgl',
1718: p_log_level_rec => p_log_level_rec);
1719: return FALSE;
1720: end if;
1721:

Line 1728: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosgl',

1724:
1725: exception
1726: when others then
1727: FA_SRVR_MSG.ADD_SQL_ERROR
1728: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadosgl',
1729: p_log_level_rec => p_log_level_rec);
1730: return FALSE;
1731: END fadosgl;
1732:

Line 1788: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',

1784: X_last_updated_by => X_last_updated_by,
1785: X_last_update_login => X_last_update_login,
1786: p_log_level_rec => p_log_level_rec)) then
1787: FA_SRVR_MSG.ADD_MESSAGE
1788: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',
1789: p_log_level_rec => p_log_level_rec);
1790: return FALSE;
1791: end if;
1792:

Line 1806: 'FA_INS_ADJUST_PKG.fadoret',

1802: FA_QUERY_BALANCES_PKG.QUERY_BALANCES_INT(H_DPR_ROW,
1803: 'STANDARD',
1804: FALSE,
1805: H_SUCCESS,
1806: 'FA_INS_ADJUST_PKG.fadoret',
1807: -1,
1808: p_log_level_rec => p_log_level_rec);
1809: -- Assign H_DPR_ROW to dpr_ptr. They are of same type
1810: dpr_ptr:=H_DPR_ROW;

Line 1816: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',

1812: if (not factotp(total_amount=>h_total_amount,
1813: adjustment_amount=>h_adjustment_amount,
1814: p_log_level_rec => p_log_level_rec)) then
1815: FA_SRVR_MSG.ADD_MESSAGE
1816: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',
1817: p_log_level_rec => p_log_level_rec);
1818: return FALSE;
1819: end if;
1820:

Line 1897: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',

1893: X_book => adj_ptr.book_type_code,
1894: X_set_of_books_id => adj_ptr.set_of_books_id,
1895: p_log_level_rec => p_log_level_rec)) THEN
1896: FA_SRVR_MSG.add_message
1897: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',
1898: p_log_level_rec => p_log_level_rec);
1899: return (FALSE);
1900: END IF;
1901:

Line 1905: (fname => 'FA_INS_ADJUST_PKG.fadoact',

1901:
1902: h_amount_so_far:=h_amount_so_far+h_amount_to_insert;
1903: if (p_log_level_rec.statement_level) then
1904: FA_DEBUG_PKG.ADD
1905: (fname => 'FA_INS_ADJUST_PKG.fadoact',
1906: element => 'dist ccid in fadoact',
1907: value => h_dist_ccid,
1908: p_log_level_rec => p_log_level_rec);
1909: end if;

Line 1950: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',

1946: X_last_updated_by => X_last_updated_by,
1947: X_last_update_login => X_last_update_login,
1948: p_log_level_rec => p_log_level_rec)) then
1949: FA_SRVR_MSG.ADD_MESSAGE
1950: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',
1951: p_log_level_rec => p_log_level_rec);
1952: return FALSE;
1953: end if;
1954:

Line 1962: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',

1958:
1959: exception
1960: when others then
1961: FA_SRVR_MSG.ADD_SQL_ERROR
1962: (CALLING_FN => 'FA_INS_ADJUST_PKG.fadoret',
1963: p_log_level_rec => p_log_level_rec);
1964: return FALSE;
1965:
1966: END fadoret;

Line 1994: (fname => 'FA_INS_ADJUST_PKG.faxinaj',

1990: h_set_of_books_id := adj_ptr_passed.set_of_books_id;
1991:
1992: IF (p_log_level_rec.statement_level) then
1993: FA_DEBUG_PKG.ADD
1994: (fname => 'FA_INS_ADJUST_PKG.faxinaj',
1995: element => 'adj amt - first',
1996: value => adj_ptr.adjustment_amount,
1997: p_log_level_rec => p_log_level_rec);
1998: FA_DEBUG_PKG.ADD

Line 1999: (fname => 'FA_INS_ADJUST_PKG.faxinaj',

1995: element => 'adj amt - first',
1996: value => adj_ptr.adjustment_amount,
1997: p_log_level_rec => p_log_level_rec);
1998: FA_DEBUG_PKG.ADD
1999: (fname => 'FA_INS_ADJUST_PKG.faxinaj',
2000: element => 'deprn_override_flag',
2001: value => adj_ptr.deprn_override_flag,
2002: p_log_level_rec => p_log_level_rec);
2003: end if;

Line 2018: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2014: adj_table.delete;
2015: h_cache_index := 0;
2016:
2017: FA_SRVR_MSG.ADD_MESSAGE
2018: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2019: p_log_level_rec => p_log_level_rec);
2020: return FALSE;
2021: end if;
2022: else

Line 2032: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2028: adj_table.delete;
2029: h_cache_index := 0;
2030:
2031: FA_SRVR_MSG.ADD_MESSAGE
2032: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2033: p_log_level_rec => p_log_level_rec);
2034: return FALSE;
2035: end if;
2036:

Line 2047: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2043: adj_table.delete;
2044: h_cache_index := 0;
2045:
2046: FA_SRVR_MSG.ADD_MESSAGE
2047: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2048: p_log_level_rec => p_log_level_rec);
2049: return FALSE;
2050: end if;
2051: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE_REVAL) then -- YYOON

Line 2061: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2057: adj_table.delete;
2058: h_cache_index := 0;
2059:
2060: FA_SRVR_MSG.ADD_MESSAGE
2061: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2062: p_log_level_rec => p_log_level_rec);
2063: return FALSE;
2064: end if;
2065: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE) then

Line 2075: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2071: adj_table.delete;
2072: h_cache_index := 0;
2073:
2074: FA_SRVR_MSG.ADD_MESSAGE
2075: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2076: p_log_level_rec => p_log_level_rec);
2077: return FALSE;
2078: end if;
2079: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_TRANSFER_SINGLE) then

Line 2089: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2085: adj_table.delete;
2086: h_cache_index := 0;
2087:
2088: FA_SRVR_MSG.ADD_MESSAGE
2089: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2090: p_log_level_rec => p_log_level_rec);
2091: return FALSE;
2092: end if;
2093: elsif (adj_ptr.selection_mode in (FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR, FA_ADJUST_TYPE_PKG.FA_AJ_CLEAR_PARTIAL)) then

Line 2103: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2099: adj_table.delete;
2100: h_cache_index := 0;
2101:
2102: FA_SRVR_MSG.ADD_MESSAGE
2103: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2104: p_log_level_rec => p_log_level_rec);
2105: return FALSE;
2106: end if;
2107: elsif (adj_ptr.selection_mode=FA_ADJUST_TYPE_PKG.FA_AJ_RETIRE) then

Line 2117: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2113: adj_table.delete;
2114: h_cache_index := 0;
2115:
2116: FA_SRVR_MSG.ADD_MESSAGE
2117: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2118: p_log_level_rec => p_log_level_rec);
2119: return FALSE;
2120: end if;
2121: else

Line 2127: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2123: adj_table.delete;
2124: h_cache_index := 0;
2125:
2126: FA_SRVR_MSG.ADD_MESSAGE
2127: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2128: NAME => 'FA_INS_ADJ_BAD_MODE',
2129: p_log_level_rec => p_log_level_rec);
2130: return FALSE;
2131: end if; -- of adj_ptr.selection_mode

Line 2148: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2144: adj_table.delete;
2145: h_cache_index := 0;
2146:
2147: FA_SRVR_MSG.ADD_MESSAGE
2148: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2149: p_log_level_rec => p_log_level_rec);
2150: return FALSE;
2151: end if;
2152: end if;

Line 2158: (fname => 'FA_INS_ADJUST_PKG.faxinaj',

2154: adj_ptr_passed.amount_inserted := adj_ptr.amount_inserted;
2155:
2156: IF (p_log_level_rec.statement_level) then
2157: FA_DEBUG_PKG.ADD
2158: (fname => 'FA_INS_ADJUST_PKG.faxinaj',
2159: element => 'adj inserted - BEFORE RETURN',
2160: value => adj_ptr_passed.amount_inserted,
2161: p_log_level_rec => p_log_level_rec);
2162: end if;

Line 2168: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',

2164:
2165: exception
2166: when others then
2167: FA_SRVR_MSG.ADD_SQL_ERROR
2168: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinaj',
2169: p_log_level_rec => p_log_level_rec);
2170: return FALSE;
2171: END faxinaj;
2172:

Line 2233: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',

2229: adj_ptr_local.account_type := X_account_type;
2230:
2231: if (X_current_units=0) then
2232: FA_SRVR_MSG.ADD_MESSAGE
2233: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',
2234: NAME => 'FA_INS_ADJ_ZERO_UNITS',
2235: p_log_level_rec => p_log_level_rec);
2236: return FALSE;
2237: end if;

Line 2246: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',

2242: elsif (X_selection_mode='SINGLE') then
2243: adj_ptr_local.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_SINGLE;
2244: else
2245: FA_SRVR_MSG.ADD_MESSAGE
2246: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',
2247: NAME => 'FA_INS_ADJ_BAD_SEL_MODE',
2248: p_log_level_rec => p_log_level_rec);
2249: return FALSE;
2250: end if;

Line 2258: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',

2254: elsif (X_flush_adj_flag='FALSE') then
2255: adj_ptr_local.flush_adj_flag:=FALSE;
2256: else
2257: FA_SRVR_MSG.ADD_MESSAGE
2258: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',
2259: NAME => 'FA_INS_ADJ_BAD_FLUSH_FLAG',
2260: p_log_level_rec => p_log_level_rec);
2261: return FALSE;
2262: end if;

Line 2270: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',

2266: elsif (X_gen_ccid_flag='FALSE') then
2267: adj_ptr_local.gen_ccid_flag:=FALSE;
2268: else
2269: FA_SRVR_MSG.ADD_MESSAGE
2270: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',
2271: NAME => 'FA_INS_ADJ_BAD_GEN_CCID_FLAG',
2272: p_log_level_rec => p_log_level_rec);
2273: return FALSE;
2274: end if;

Line 2292: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',

2288: X_last_updated_by,
2289: X_last_update_login,
2290: p_log_level_rec => p_log_level_rec)) then
2291: FA_SRVR_MSG.ADD_MESSAGE
2292: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',
2293: p_log_level_rec => p_log_level_rec);
2294: return FALSE;
2295: end if;
2296:

Line 2304: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',

2300:
2301: exception
2302: when others then
2303: FA_SRVR_MSG.ADD_SQL_ERROR
2304: (CALLING_FN => 'FA_INS_ADJUST_PKG.faxinadj',
2305: p_log_level_rec => p_log_level_rec);
2306: return FALSE;
2307:
2308: END faxinadj;

Line 2310: END FA_INS_ADJUST_PKG;

2306: return FALSE;
2307:
2308: END faxinadj;
2309:
2310: END FA_INS_ADJUST_PKG;