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');
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;
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);
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;
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;
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;
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;
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;
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;
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;
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;
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);
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;
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;
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;
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);
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);
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);
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);
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);
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);
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);
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:
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;
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 (
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,
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);
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);
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);
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);
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);
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);
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:
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;
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 (
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,
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);
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);
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);
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);
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);
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);
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:
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;
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 (
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,
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);
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);
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);
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);
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);
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);
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:
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;
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 (
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,
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
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;
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;
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;
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;