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_FIN_ADJ1_PKG dependencies on FA_BOOKS

Line 108: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or

104:
105: if (no_itc_yes_ceiling%notfound) then
106: close no_itc_yes_ceiling;
107: -- syoung: conditional messaging.
108: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
109: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
110: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
111: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
112: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or

Line 109: bks_calling_fn = 'FA_BOOKS_VAL.COST' or

105: if (no_itc_yes_ceiling%notfound) then
106: close no_itc_yes_ceiling;
107: -- syoung: conditional messaging.
108: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
109: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
110: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
111: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
112: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
113: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then

Line 110: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or

106: close no_itc_yes_ceiling;
107: -- syoung: conditional messaging.
108: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
109: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
110: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
111: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
112: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
113: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
114: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');

Line 111: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or

107: -- syoung: conditional messaging.
108: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
109: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
110: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
111: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
112: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
113: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
114: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');
115: app_exception.raise_exception;

Line 112: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or

108: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
109: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
110: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
111: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
112: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
113: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
114: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');
115: app_exception.raise_exception;
116: else

Line 113: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then

109: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
110: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
111: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
112: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
113: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
114: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');
115: app_exception.raise_exception;
116: else
117: raise calc_error;

Line 134: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or

130:
131: if (yes_itc_yes_ceiling%notfound) then
132: close yes_itc_yes_ceiling;
133: -- syoung: conditional messaging.
134: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
135: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
136: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
137: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
138: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or

Line 135: bks_calling_fn = 'FA_BOOKS_VAL.COST' or

131: if (yes_itc_yes_ceiling%notfound) then
132: close yes_itc_yes_ceiling;
133: -- syoung: conditional messaging.
134: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
135: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
136: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
137: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
138: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
139: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then

Line 136: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or

132: close yes_itc_yes_ceiling;
133: -- syoung: conditional messaging.
134: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
135: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
136: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
137: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
138: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
139: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
140: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');

Line 137: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or

133: -- syoung: conditional messaging.
134: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
135: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
136: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
137: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
138: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
139: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
140: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');
141: app_exception.raise_exception;

Line 138: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or

134: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
135: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
136: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
137: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
138: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
139: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
140: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');
141: app_exception.raise_exception;
142: else

Line 139: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then

135: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
136: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
137: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
138: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
139: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
140: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');
141: app_exception.raise_exception;
142: else
143: raise calc_error;

Line 156: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or

152:
153: if (yes_itc_no_ceiling%notfound) then
154: close yes_itc_no_ceiling;
155: -- syoung: conditional messaging.
156: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
157: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
158: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
159: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
160: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or

Line 157: bks_calling_fn = 'FA_BOOKS_VAL.COST' or

153: if (yes_itc_no_ceiling%notfound) then
154: close yes_itc_no_ceiling;
155: -- syoung: conditional messaging.
156: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
157: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
158: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
159: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
160: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
161: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then

Line 158: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or

154: close yes_itc_no_ceiling;
155: -- syoung: conditional messaging.
156: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
157: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
158: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
159: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
160: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
161: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
162: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');

Line 159: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or

155: -- syoung: conditional messaging.
156: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
157: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
158: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
159: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
160: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
161: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
162: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');
163: app_exception.raise_exception;

Line 160: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or

156: if (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
157: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
158: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
159: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
160: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
161: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
162: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');
163: app_exception.raise_exception;
164: else

Line 161: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then

157: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
158: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
159: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
160: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
161: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
162: fnd_message.set_name('OFA', 'FA_SHARED_REC_COST');
163: app_exception.raise_exception;
164: else
165: raise calc_error;

Line 189: if not (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or

185: NAME => 'FA_SHARED_REC_COST',
186: p_log_level_rec => p_log_level_rec);
187: x_return_status := false;
188: when others then
189: if not (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
190: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
191: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
192: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
193: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or

Line 190: bks_calling_fn = 'FA_BOOKS_VAL.COST' or

186: p_log_level_rec => p_log_level_rec);
187: x_return_status := false;
188: when others then
189: if not (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
190: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
191: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
192: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
193: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
194: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then

Line 191: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or

187: x_return_status := false;
188: when others then
189: if not (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
190: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
191: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
192: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
193: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
194: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
195: FA_SRVR_MSG.Add_SQL_Error(

Line 192: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or

188: when others then
189: if not (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
190: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
191: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
192: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
193: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
194: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
195: FA_SRVR_MSG.Add_SQL_Error(
196: CALLING_FN => 'FA_FIN_ADJ1_PKG.Cal_Rec_Cost'

Line 193: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or

189: if not (bks_calling_fn = 'FA_BOOKS_ADD.Default_Assets' or
190: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
191: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
192: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
193: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
194: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
195: FA_SRVR_MSG.Add_SQL_Error(
196: CALLING_FN => 'FA_FIN_ADJ1_PKG.Cal_Rec_Cost'
197: ,p_log_level_rec => p_log_level_rec);

Line 194: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then

190: bks_calling_fn = 'FA_BOOKS_VAL.COST' or
191: bks_calling_fn = 'FA_BOOKS_VAL.SAL_VALUE_VAL' or
192: bks_calling_fn = 'FA_BOOKS_VAL.DPIS_VAL' or
193: bks_calling_fn = 'FA_BOOKS_VAL3.CONV_CODE_VAL' or
194: bks_calling_fn = 'FA_BOOKS_VAL4.CEILING_NAME') then
195: FA_SRVR_MSG.Add_SQL_Error(
196: CALLING_FN => 'FA_FIN_ADJ1_PKG.Cal_Rec_Cost'
197: ,p_log_level_rec => p_log_level_rec);
198: x_return_status := false;

Line 653: from fa_books bk

649: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
650: is
651: cursor exist_to_book_cur is
652: select 'Y'
653: from fa_books bk
654: where bk.rowid = bks_row_id;
655:
656: cursor pro_conv_cur is
657: select 'Y'

Line 658: from fa_books bk

654: where bk.rowid = bks_row_id;
655:
656: cursor pro_conv_cur is
657: select 'Y'
658: from fa_books bk
659: where bk.prorate_convention_code = bks_prorate_convention_code
660: and bk.rowid = bks_row_id;
661:
662: cursor no_changes_made is

Line 664: from fa_books bk

660: and bk.rowid = bks_row_id;
661:
662: cursor no_changes_made is
663: select 'Y'
664: from fa_books bk
665: where bk.rowid = bks_row_id
666: and bk.cost = bks_cost
667: and bk.recoverable_cost = bks_recoverable_cost
668: and bk.date_placed_in_service = bks_date_placed_in_service

Line 718: from fa_books bk

714: and nvl(bk.global_attribute20,'NULL') = nvl(bks_global_attribute20,'NULL');
715:
716: cursor no_changes_to_dep_flag_uom is
717: select 'Y'
718: from fa_books bk
719: where bk.rowid = bks_row_id
720: and nvl(bk.unit_of_measure, 99999) = nvl(bks_unit_of_measure, 99999);
721:
722: cursor no_changes_to_dep_flag is

Line 724: from fa_books bk

720: and nvl(bk.unit_of_measure, 99999) = nvl(bks_unit_of_measure, 99999);
721:
722: cursor no_changes_to_dep_flag is
723: select 'Y'
724: from fa_books bk
725: where bk.rowid = bks_row_id
726: and bk.depreciate_flag = bks_depreciate_flag;
727:
728: cursor adjustment_reqd_flag is

Line 730: from fa_books bk,

726: and bk.depreciate_flag = bks_depreciate_flag;
727:
728: cursor adjustment_reqd_flag is
729: select 'Y'
730: from fa_books bk,
731: fa_transaction_headers th,
732: fa_deprn_summary ds
733: where bk.rowid = bks_row_id
734: and bks_depreciate_flag = 'YES'