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_REBASE_PKG dependencies on IGI_IAC_DEBUG_PKG

Line 136: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,' Price index id' ||l_price_index_id);

132: fetch c_get_price_index into l_price_index_id;
133: close c_get_price_index;*/
134:
135: l_price_index_id:=price_index_id;
136: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,' Price index id' ||l_price_index_id);
137: /* Get the cal_price_index_link_id */
138: open c_get_link_id(price_index_id);
139: fetch c_get_link_id into l_link_id;
140: close c_get_link_id;

Line 142: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase',' link id' ||l_link_id);

138: open c_get_link_id(price_index_id);
139: fetch c_get_link_id into l_link_id;
140: close c_get_link_id;
141:
142: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase',' link id' ||l_link_id);
143: /* Check whether periods of the given calendar are linked to the price index in the igi_iac_cal_idx_values tables */
144: open c_get_curr_price_ind_val(l_link_id);
145: fetch c_get_curr_price_ind_val into l_current_price_idx_rec;
146: IF (c_get_curr_price_ind_val%NOTFOUND) THEN

Line 159: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');

155:
156:
157:
158: /* Log Messages */
159: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
160: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Calendar : ' || calendar);
161: -- fnd_file.put_line(fnd_file.log,'Price Index : ' || price_index_name);
162: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Rebase Period : ' || period_name);
163: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'New Price Index value : ' || new_price_index_value);

Line 160: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Calendar : ' || calendar);

156:
157:
158: /* Log Messages */
159: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
160: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Calendar : ' || calendar);
161: -- fnd_file.put_line(fnd_file.log,'Price Index : ' || price_index_name);
162: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Rebase Period : ' || period_name);
163: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'New Price Index value : ' || new_price_index_value);
164: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');

Line 162: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Rebase Period : ' || period_name);

158: /* Log Messages */
159: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
160: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Calendar : ' || calendar);
161: -- fnd_file.put_line(fnd_file.log,'Price Index : ' || price_index_name);
162: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Rebase Period : ' || period_name);
163: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'New Price Index value : ' || new_price_index_value);
164: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
165:
166:

Line 163: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'New Price Index value : ' || new_price_index_value);

159: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
160: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Calendar : ' || calendar);
161: -- fnd_file.put_line(fnd_file.log,'Price Index : ' || price_index_name);
162: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Rebase Period : ' || period_name);
163: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'New Price Index value : ' || new_price_index_value);
164: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
165:
166:
167:

Line 164: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');

160: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Calendar : ' || calendar);
161: -- fnd_file.put_line(fnd_file.log,'Price Index : ' || price_index_name);
162: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','Rebase Period : ' || period_name);
163: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'New Price Index value : ' || new_price_index_value);
164: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
165:
166:
167:
168: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'|Period |Old |Current|');

Line 168: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'|Period |Old |Current|');

164: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
165:
166:
167:
168: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'|Period |Old |Current|');
169: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Index |Index |');
170: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Value |Value |');
171: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
172: /* End of Log Messages */

Line 169: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Index |Index |');

165:
166:
167:
168: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'|Period |Old |Current|');
169: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Index |Index |');
170: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Value |Value |');
171: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
172: /* End of Log Messages */
173:

Line 170: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Value |Value |');

166:
167:
168: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'|Period |Old |Current|');
169: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Index |Index |');
170: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Value |Value |');
171: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
172: /* End of Log Messages */
173:
174:

Line 171: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');

167:
168: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase' ,'|Period |Old |Current|');
169: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Index |Index |');
170: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','| |Value |Value |');
171: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
172: /* End of Log Messages */
173:
174:
175: /* To get the precision of the functional currency */

Line 193: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','|'||rpad(l_period_name_rec.period_name,30,' ')||'|'||rpad(l_current_price_idx_rec.current_price_index_value,7,' ')

189:
190: l_new_curr_price_idx_val:=
191: new_price_index_value * (l_current_price_idx_rec.current_price_index_value/l_factor_price_index);
192: /* Display the price index value details in the log file */
193: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','|'||rpad(l_period_name_rec.period_name,30,' ')||'|'||rpad(l_current_price_idx_rec.current_price_index_value,7,' ')
194: ||'|'||rpad(l_new_curr_price_idx_val,7,' ')||'|');
195:
196: ELSIF (l_period_name_rec.period_name = period_name) THEN
197: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');

Line 197: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');

193: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','|'||rpad(l_period_name_rec.period_name,30,' ')||'|'||rpad(l_current_price_idx_rec.current_price_index_value,7,' ')
194: ||'|'||rpad(l_new_curr_price_idx_val,7,' ')||'|');
195:
196: ELSIF (l_period_name_rec.period_name = period_name) THEN
197: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
198: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase', period_name ||' is the rebasing period. So no calculation is done .');
199: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','New price index value = ' || new_price_index_value);
200: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
201: l_new_curr_price_idx_val:= new_price_index_value;

Line 198: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase', period_name ||' is the rebasing period. So no calculation is done .');

194: ||'|'||rpad(l_new_curr_price_idx_val,7,' ')||'|');
195:
196: ELSIF (l_period_name_rec.period_name = period_name) THEN
197: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
198: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase', period_name ||' is the rebasing period. So no calculation is done .');
199: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','New price index value = ' || new_price_index_value);
200: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
201: l_new_curr_price_idx_val:= new_price_index_value;
202:

Line 199: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','New price index value = ' || new_price_index_value);

195:
196: ELSIF (l_period_name_rec.period_name = period_name) THEN
197: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
198: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase', period_name ||' is the rebasing period. So no calculation is done .');
199: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','New price index value = ' || new_price_index_value);
200: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
201: l_new_curr_price_idx_val:= new_price_index_value;
202:
203: /* Bug No :2392641 sowsubra start */

Line 200: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');

196: ELSIF (l_period_name_rec.period_name = period_name) THEN
197: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
198: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase', period_name ||' is the rebasing period. So no calculation is done .');
199: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','New price index value = ' || new_price_index_value);
200: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
201: l_new_curr_price_idx_val:= new_price_index_value;
202:
203: /* Bug No :2392641 sowsubra start */
204: ELSIF (l_current_price_idx_rec.current_price_index_value = l_default_index_val) THEN

Line 205: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase', l_period_name_rec.period_name ||'has the default price index value : ' ||

201: l_new_curr_price_idx_val:= new_price_index_value;
202:
203: /* Bug No :2392641 sowsubra start */
204: ELSIF (l_current_price_idx_rec.current_price_index_value = l_default_index_val) THEN
205: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase', l_period_name_rec.period_name ||'has the default price index value : ' ||
206: l_default_index_val || '.So No rebase done for this period .');
207: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','New price index value = ' ||l_default_index_val);
208: l_new_curr_price_idx_val:=l_default_index_val ;
209: /* Bug No :2392641 sowsubra end */

Line 207: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','New price index value = ' ||l_default_index_val);

203: /* Bug No :2392641 sowsubra start */
204: ELSIF (l_current_price_idx_rec.current_price_index_value = l_default_index_val) THEN
205: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase', l_period_name_rec.period_name ||'has the default price index value : ' ||
206: l_default_index_val || '.So No rebase done for this period .');
207: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','New price index value = ' ||l_default_index_val);
208: l_new_curr_price_idx_val:=l_default_index_val ;
209: /* Bug No :2392641 sowsubra end */
210: END IF;
211:

Line 231: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');

227:
228:
229:
230: END LOOP;
231: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'do_rebase','------------------------------------------------');
232: open c_get_cal_price_indexes(l_link_id);
233: fetch c_get_cal_price_indexes into l_cal_price_indexes_rec;
234: close c_get_cal_price_indexes;
235:

Line 253: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'do_rebase',FALSE);

249:
250: EXCEPTION
251: WHEN IGI_IAC_NOT_ENABLED THEN
252: fnd_message.set_name('IGI','IGI_IAC_NOT_INSTALLED');
253: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'do_rebase',FALSE);
254: Errbuf:=fnd_message.get;
255: retcode :=2;
256: WHEN IGI_IAC_PRICE_INDEX_ZERO THEN
257: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');

Line 260: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'do_rebase',FALSE);

256: WHEN IGI_IAC_PRICE_INDEX_ZERO THEN
257: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
258: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_rebase_pkg');
259: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Error : Price index value 0 cannot be processed ');
260: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'do_rebase',FALSE);
261:
262: retcode :=2;
263: Errbuf := fnd_message.get;
264: WHEN ZERO_DIVIDE THEN

Line 268: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'do_rebase',FALSE);

264: WHEN ZERO_DIVIDE THEN
265: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
266: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_rebase_pkg');
267: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Division By Zero ');
268: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'do_rebase',FALSE);
269: retcode :=2;
270: errbuf:= fnd_message.get;
271: WHEN IGI_IAC_INDEX_PERIOD_NOT_FOUND THEN
272: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');

Line 275: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'do_rebase',FALSE);

271: WHEN IGI_IAC_INDEX_PERIOD_NOT_FOUND THEN
272: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
273: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_rebase_pkg');
274: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Price Index not linked to the calendar periods ');
275: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'do_rebase',FALSE);
276: retcode:=2;
277: errbuf:= fnd_message.get;
278: END do_rebase;
279: END igi_iac_rebase_pkg;