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.IGI_IAC_YTD_PRE_PROCESS_PKG dependencies on IGI_IAC_DEBUG_PKG

Line 123: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'************************************');

119: l_path VARCHAR2(100) := g_path||'POPULATE_IAC_FA_DEPRN_DATA';
120:
121: BEGIN
122: SAVEPOINT iac_pre_process;
123: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'************************************');
124: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start of processing for book :'||p_book_type_code);
125: fnd_file.put_line(fnd_file.log, 'Start of processing for book :'||p_book_type_code);
126: IF NOT igi_gen.is_req_installed('IAC') THEN
127: fnd_message.set_name('IGI','IGI_GEN_PROD_NOT_INSTALLED');

Line 124: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start of processing for book :'||p_book_type_code);

120:
121: BEGIN
122: SAVEPOINT iac_pre_process;
123: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'************************************');
124: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start of processing for book :'||p_book_type_code);
125: fnd_file.put_line(fnd_file.log, 'Start of processing for book :'||p_book_type_code);
126: IF NOT igi_gen.is_req_installed('IAC') THEN
127: fnd_message.set_name('IGI','IGI_GEN_PROD_NOT_INSTALLED');
128: lv_mesg := fnd_message.get;

Line 129: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');

125: fnd_file.put_line(fnd_file.log, 'Start of processing for book :'||p_book_type_code);
126: IF NOT igi_gen.is_req_installed('IAC') THEN
127: fnd_message.set_name('IGI','IGI_GEN_PROD_NOT_INSTALLED');
128: lv_mesg := fnd_message.get;
129: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
130: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,lv_mesg);
131: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
132: retcode := 2;
133: fnd_file.put_line(FND_FILE.log, lv_mesg);

Line 130: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,lv_mesg);

126: IF NOT igi_gen.is_req_installed('IAC') THEN
127: fnd_message.set_name('IGI','IGI_GEN_PROD_NOT_INSTALLED');
128: lv_mesg := fnd_message.get;
129: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
130: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,lv_mesg);
131: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
132: retcode := 2;
133: fnd_file.put_line(FND_FILE.log, lv_mesg);
134: errbuf := lv_mesg;

Line 131: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');

127: fnd_message.set_name('IGI','IGI_GEN_PROD_NOT_INSTALLED');
128: lv_mesg := fnd_message.get;
129: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
130: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,lv_mesg);
131: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
132: retcode := 2;
133: fnd_file.put_line(FND_FILE.log, lv_mesg);
134: errbuf := lv_mesg;
135: RETURN;

Line 141: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');

137:
138: IF NOT igi_iac_common_utils.is_iac_book(p_book_type_code) THEN
139: fnd_message.set_name('IGI','IGI_IAC_NOT_IAC_BOOK');
140: lv_mesg := fnd_message.get;
141: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
142: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,lv_mesg);
143: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
144: retcode := 2;
145: errbuf := lv_mesg;

Line 142: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,lv_mesg);

138: IF NOT igi_iac_common_utils.is_iac_book(p_book_type_code) THEN
139: fnd_message.set_name('IGI','IGI_IAC_NOT_IAC_BOOK');
140: lv_mesg := fnd_message.get;
141: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
142: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,lv_mesg);
143: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
144: retcode := 2;
145: errbuf := lv_mesg;
146: RETURN;

Line 143: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');

139: fnd_message.set_name('IGI','IGI_IAC_NOT_IAC_BOOK');
140: lv_mesg := fnd_message.get;
141: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
142: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,lv_mesg);
143: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
144: retcode := 2;
145: errbuf := lv_mesg;
146: RETURN;
147: END IF;

Line 155: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');

151: OPEN c_get_iac_fa_deprn_rec;
152: FETCH c_get_iac_fa_deprn_rec INTO l_dummy_char;
153: IF c_get_iac_fa_deprn_rec%FOUND THEN
154: CLOSE c_get_iac_fa_deprn_rec;
155: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' This process is not required for this book as the required data is already present.');
157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
158: lv_mesg := ' This process is not required for this book as the required data is already present.';
159: retcode := 2;

Line 156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' This process is not required for this book as the required data is already present.');

152: FETCH c_get_iac_fa_deprn_rec INTO l_dummy_char;
153: IF c_get_iac_fa_deprn_rec%FOUND THEN
154: CLOSE c_get_iac_fa_deprn_rec;
155: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' This process is not required for this book as the required data is already present.');
157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
158: lv_mesg := ' This process is not required for this book as the required data is already present.';
159: retcode := 2;
160: errbuf := lv_mesg;

Line 157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');

153: IF c_get_iac_fa_deprn_rec%FOUND THEN
154: CLOSE c_get_iac_fa_deprn_rec;
155: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' This process is not required for this book as the required data is already present.');
157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ********** ');
158: lv_mesg := ' This process is not required for this book as the required data is already present.';
159: retcode := 2;
160: errbuf := lv_mesg;
161: RETURN;

Line 169: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing the assets');

165: END IF;
166:
167: fnd_file.put_line(fnd_file.log, 'Processing assets');
168:
169: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing the assets');
170: FOR l_asset IN c_get_all_iac_assets LOOP
171: fnd_file.put_line(fnd_file.log, 'Asset_id ' || l_asset.asset_id );
172:
173: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset_id :'||l_asset.asset_id);

Line 173: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset_id :'||l_asset.asset_id);

169: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Processing the assets');
170: FOR l_asset IN c_get_all_iac_assets LOOP
171: fnd_file.put_line(fnd_file.log, 'Asset_id ' || l_asset.asset_id );
172:
173: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Asset_id :'||l_asset.asset_id);
174: l_Transaction_Type_Code := NULL;
175: l_Transaction_Id := NULL;
176: l_Mass_Reference_ID := NULL;
177: l_Adjustment_Id := NULL;

Line 196: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Latest Adjustment :'||l_adjustment_id);

192: errbuf := 'Error in Fetching the Latest Transaction for the asset';
193: RETURN;
194: END IF;
195:
196: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Latest Adjustment :'||l_adjustment_id);
197: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous Adjustment :'||l_prev_adjustment_id);
198:
199: OPEN c_fully_reserved(l_asset.asset_id, p_book_type_code);
200: FETCH c_fully_reserved INTO l_fully_reserved_pc;

Line 197: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous Adjustment :'||l_prev_adjustment_id);

193: RETURN;
194: END IF;
195:
196: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Latest Adjustment :'||l_adjustment_id);
197: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Previous Adjustment :'||l_prev_adjustment_id);
198:
199: OPEN c_fully_reserved(l_asset.asset_id, p_book_type_code);
200: FETCH c_fully_reserved INTO l_fully_reserved_pc;
201: CLOSE c_fully_reserved;

Line 204: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Distribution Id :'||l_dist.distribution_id);

200: FETCH c_fully_reserved INTO l_fully_reserved_pc;
201: CLOSE c_fully_reserved;
202:
203: FOR l_dist IN c_get_dists(l_asset.asset_id,l_adjustment_id) LOOP
204: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Distribution Id :'||l_dist.distribution_id);
205: fnd_file.put_line(fnd_file.log, 'distribution_id: ' || l_dist.distribution_id );
206:
207: l_deprn_ytd := 0;
208: OPEN c_get_dist_ytd(p_book_type_code,l_asset.asset_id,l_dist.distribution_id);

Line 228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');

224: l_deprn_amount := 0;
225: END IF;
226:
227: IF p_calling_mode <> 'SRS' THEN
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);

Line 229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);

225: END IF;
226:
227: IF p_calling_mode <> 'SRS' THEN
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);

Line 230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);

226:
227: IF p_calling_mode <> 'SRS' THEN
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);

Line 231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);

227: IF p_calling_mode <> 'SRS' THEN
228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);

Line 232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);

228: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
236: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);

Line 233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);

229: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
236: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
237: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);

Line 234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);

230: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
236: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
237: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
238:

Line 235: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);

231: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
236: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
237: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
238:
239: l_rowid := NULL;

Line 236: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);

232: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
236: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
237: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
238:
239: l_rowid := NULL;
240: IGI_IAC_FA_DEPRN_PKG.insert_row (

Line 237: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);

233: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
234: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
235: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
236: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
237: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
238:
239: l_rowid := NULL;
240: IGI_IAC_FA_DEPRN_PKG.insert_row (
241: x_rowid => l_rowid,

Line 257: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');

253: OPEN c_check_igi_fa_deprn(l_asset.asset_id,l_dist.distribution_id,l_adjustment_id,l_dist.period_counter);
254: FETCH c_check_igi_fa_deprn INTO l_check_igi_fa_deprn;
255: IF c_check_igi_fa_deprn%NOTFOUND THEN
256:
257: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
258: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
259: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
260: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);

Line 258: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);

254: FETCH c_check_igi_fa_deprn INTO l_check_igi_fa_deprn;
255: IF c_check_igi_fa_deprn%NOTFOUND THEN
256:
257: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
258: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
259: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
260: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);

Line 259: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);

255: IF c_check_igi_fa_deprn%NOTFOUND THEN
256:
257: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
258: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
259: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
260: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);

Line 260: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);

256:
257: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
258: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
259: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
260: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);

Line 261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);

257: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for latest adjustment');
258: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
259: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
260: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);

Line 262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);

258: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
259: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
260: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);

Line 263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);

259: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
260: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
267:

Line 264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);

260: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
267:
268: l_rowid := NULL;

Line 265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);

261: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
267:
268: l_rowid := NULL;
269: IGI_IAC_FA_DEPRN_PKG.insert_row (

Line 266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);

262: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
263: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
264: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
266: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
267:
268: l_rowid := NULL;
269: IGI_IAC_FA_DEPRN_PKG.insert_row (
270: x_rowid => l_rowid,

Line 292: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');

288: FETCH c_get_dist_info INTO l_prev_adj_period;
289: CLOSE c_get_dist_info;
290:
291: IF p_calling_mode <> 'SRS' THEN
292: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
293: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
294: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);

Line 293: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);

289: CLOSE c_get_dist_info;
290:
291: IF p_calling_mode <> 'SRS' THEN
292: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
293: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
294: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);

Line 294: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);

290:
291: IF p_calling_mode <> 'SRS' THEN
292: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
293: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
294: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);

Line 295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);

291: IF p_calling_mode <> 'SRS' THEN
292: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
293: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
294: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
299: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);

Line 296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);

292: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
293: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
294: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
299: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
300: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);

Line 297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);

293: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
294: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
299: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
300: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);

Line 298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);

294: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
299: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
300: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
302:

Line 299: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);

295: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
299: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
300: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
302:
303: l_rowid := NULL;

Line 300: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);

296: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
299: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
300: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
302:
303: l_rowid := NULL;
304: IGI_IAC_FA_DEPRN_PKG.insert_row (

Line 301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);

297: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
299: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
300: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
302:
303: l_rowid := NULL;
304: IGI_IAC_FA_DEPRN_PKG.insert_row (
305: x_rowid => l_rowid,

Line 321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');

317: OPEN c_check_igi_fa_deprn(l_asset.asset_id,l_dist.distribution_id,l_prev_adjustment_id,l_prev_adj_period);
318: FETCH c_check_igi_fa_deprn INTO l_check_igi_fa_deprn;
319: IF c_check_igi_fa_deprn%NOTFOUND THEN
320:
321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
324: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);

Line 322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);

318: FETCH c_check_igi_fa_deprn INTO l_check_igi_fa_deprn;
319: IF c_check_igi_fa_deprn%NOTFOUND THEN
320:
321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
324: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);

Line 323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);

319: IF c_check_igi_fa_deprn%NOTFOUND THEN
320:
321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
324: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);

Line 324: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);

320:
321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
324: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);

Line 325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);

321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting record for previous adjustment');
322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
324: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);

Line 326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);

322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_adjustment_id =>'|| l_adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
324: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
330: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);

Line 327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);

323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_asset_id =>'|| l_asset.asset_id);
324: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
330: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
331:

Line 328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);

324: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_distribution_id =>'|| l_dist.distribution_id);
325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
330: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
331:
332: l_rowid := NULL;

Line 329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);

325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_book_type_code =>'|| p_book_type_code);
326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
330: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
331:
332: l_rowid := NULL;
333: IGI_IAC_FA_DEPRN_PKG.insert_row (

Line 330: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);

326: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_period_counter =>'|| l_dist.period_counter);
327: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_period =>'|| l_deprn_amount);
328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_ytd =>'|| l_deprn_ytd);
329: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_deprn_reserve =>'|| l_deprn_reserve);
330: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' x_active_flag =>'|| l_dist.active_flag);
331:
332: l_rowid := NULL;
333: IGI_IAC_FA_DEPRN_PKG.insert_row (
334: x_rowid => l_rowid,

Line 351: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End of Processing');

347: END IF;
348: END IF;
349: END LOOP;
350: END LOOP;
351: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End of Processing');
352: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*************************');
353: IF p_calling_mode = 'SRS' THEN
354: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Called in SRS mode');
355: IF l_debug_mode = 'Y' THEN

Line 352: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*************************');

348: END IF;
349: END LOOP;
350: END LOOP;
351: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End of Processing');
352: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*************************');
353: IF p_calling_mode = 'SRS' THEN
354: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Called in SRS mode');
355: IF l_debug_mode = 'Y' THEN
356: ROLLBACK TO iac_pre_process;

Line 354: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Called in SRS mode');

350: END LOOP;
351: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End of Processing');
352: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*************************');
353: IF p_calling_mode = 'SRS' THEN
354: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Called in SRS mode');
355: IF l_debug_mode = 'Y' THEN
356: ROLLBACK TO iac_pre_process;
357: ELSE
358: COMMIT;

Line 361: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Called in Non SRS mode');

357: ELSE
358: COMMIT;
359: END IF;
360: ELSE
361: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Called in Non SRS mode');
362: null;
363: END IF;
364: errbuf := null;
365: retcode := 0;

Line 371: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

367: EXCEPTION WHEN OTHERS THEN
368: IF p_calling_mode = 'SRS' THEN
369: ROLLBACK TO iac_pre_process;
370: END IF;
371: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
372: errbuf := SQLERRM;
373: retcode := 2;
374:
375: END POPULATE_IAC_FA_DEPRN_DATA;