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.BIM_POPDATES_PKG dependencies on AMS_UTILITY_PVT

Line 95: --ams_utility_pvt.write_conc_log('Inside pop dates: starting from '||l_min_date);

91: END IF;
92:
93: OPEN min_object_date(p_input_date) ;
94: FETCH min_object_date into l_min_date;
95: --ams_utility_pvt.write_conc_log('Inside pop dates: starting from '||l_min_date);
96:
97: IF l_min_date is null then
98: l_min_date :=p_input_date;
99: END IF;

Line 103: --ams_utility_pvt.write_conc_log('Before the loop');

99: END IF;
100: -- IF p_input_date 101: -- l_min_date :=p_input_date;
102: -- END IF;
103: --ams_utility_pvt.write_conc_log('Before the loop');
104: WHILE l_min_date < l_end_date+1 LOOP
105: BEGIN
106: INSERT
107: INTO BIM_INTL_DATES fdf (

Line 162: ams_utility_pvt.write_conc_log('Error inserting bim_intl_dates ' || sqlerrm(sqlcode));

158: FROM DUAL;
159: l_min_date := l_min_date +1;
160: EXCEPTION
161: WHEN OTHERS THEN
162: ams_utility_pvt.write_conc_log('Error inserting bim_intl_dates ' || sqlerrm(sqlcode));
163: RAISE FND_API.g_exc_error;
164: END;
165: END LOOP;
166: --ams_utility_pvt.write_conc_log('After the loop');

Line 166: --ams_utility_pvt.write_conc_log('After the loop');

162: ams_utility_pvt.write_conc_log('Error inserting bim_intl_dates ' || sqlerrm(sqlcode));
163: RAISE FND_API.g_exc_error;
164: END;
165: END LOOP;
166: --ams_utility_pvt.write_conc_log('After the loop');
167: --ams_utility_pvt.write_conc_log('Update the month flag');
168: BEGIN
169: update bim_intl_dates p set month_flag = 'Y'
170: where p.trdate in (SELECT min(trdate)

Line 167: --ams_utility_pvt.write_conc_log('Update the month flag');

163: RAISE FND_API.g_exc_error;
164: END;
165: END LOOP;
166: --ams_utility_pvt.write_conc_log('After the loop');
167: --ams_utility_pvt.write_conc_log('Update the month flag');
168: BEGIN
169: update bim_intl_dates p set month_flag = 'Y'
170: where p.trdate in (SELECT min(trdate)
171: FROM bim_intl_dates

Line 175: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));

171: FROM bim_intl_dates
172: GROUP BY fiscal_month);
173: EXCEPTION
174: WHEN OTHERS THEN
175: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));
176: RAISE FND_API.g_exc_error;
177: END;
178:
179: --ams_utility_pvt.write_conc_log('Update the quarter flag');

Line 179: --ams_utility_pvt.write_conc_log('Update the quarter flag');

175: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));
176: RAISE FND_API.g_exc_error;
177: END;
178:
179: --ams_utility_pvt.write_conc_log('Update the quarter flag');
180: BEGIN
181: update bim_intl_dates p set qtr_flag = 'Y'
182: where p.trdate in (SELECT min(trdate)
183: FROM bim_intl_dates

Line 187: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));

183: FROM bim_intl_dates
184: GROUP BY fiscal_qtr);
185: EXCEPTION
186: WHEN OTHERS THEN
187: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));
188: RAISE FND_API.g_exc_error;
189: END;
190: --ams_utility_pvt.write_conc_log('Update the year flag');
191: BEGIN

Line 190: --ams_utility_pvt.write_conc_log('Update the year flag');

186: WHEN OTHERS THEN
187: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));
188: RAISE FND_API.g_exc_error;
189: END;
190: --ams_utility_pvt.write_conc_log('Update the year flag');
191: BEGIN
192: update bim_intl_dates p set year_flag = 'Y'
193: where p.trdate in (SELECT min(trdate)
194: FROM bim_intl_dates

Line 198: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));

194: FROM bim_intl_dates
195: GROUP BY fiscal_year);
196: EXCEPTION
197: WHEN OTHERS THEN
198: ams_utility_pvt.write_conc_log('Error updating bim_intl_dates ' || sqlerrm(sqlcode));
199: RAISE FND_API.g_exc_error;
200: END;
201:
202: DELETE FROM bim_rep_history

Line 221: --ams_utility_pvt.write_conc_log('Successfully finished pop date');

217: 'DATES',
218: sysdate);
219:
220: commit;
221: --ams_utility_pvt.write_conc_log('Successfully finished pop date');
222: EXCEPTION
223: WHEN OTHERS THEN
224: ams_utility_pvt.write_conc_log('Error in procedure' || sqlerrm(sqlcode));
225: RAISE FND_API.g_exc_unexpected_error;

Line 224: ams_utility_pvt.write_conc_log('Error in procedure' || sqlerrm(sqlcode));

220: commit;
221: --ams_utility_pvt.write_conc_log('Successfully finished pop date');
222: EXCEPTION
223: WHEN OTHERS THEN
224: ams_utility_pvt.write_conc_log('Error in procedure' || sqlerrm(sqlcode));
225: RAISE FND_API.g_exc_unexpected_error;
226: END POP_INTL_DATES;
227: END BIM_POPDATES_PKG;