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.INV_TXN_PURGE_MAIN dependencies on INV_LOG_UTIL

Line 60: inv_log_util.TRACE('OrgId = ' || p_orgid || ', Purge Date= ' || p_purge_date, 'PURGE_MAIN', 9);

56:
57: period_rec_type min_max_dates;
58: BEGIN
59: IF (l_debug = 1) THEN
60: inv_log_util.TRACE('OrgId = ' || p_orgid || ', Purge Date= ' || p_purge_date, 'PURGE_MAIN', 9);
61: END IF;
62:
63: IF l_max_workers > 20 THEN
64: l_max_workers := 20;

Line 68: inv_log_util.TRACE('Max # of txn purge processes = ' || l_max_workers, 'PURGE_MAIN', 9);

64: l_max_workers := 20;
65: END IF;
66:
67: IF (l_debug = 1) THEN
68: inv_log_util.TRACE('Max # of txn purge processes = ' || l_max_workers, 'PURGE_MAIN', 9);
69: END IF;
70:
71: SELECT MIN(transaction_date)
72: INTO l_min_mmt_date

Line 78: inv_log_util.TRACE('MMT Min Date = ' || l_min_mmt_date, 'PURGE_MAIN', 9);

74: WHERE organization_id = p_orgid
75: AND transaction_date <= p_purge_date;
76:
77: IF (l_debug = 1) THEN
78: inv_log_util.TRACE('MMT Min Date = ' || l_min_mmt_date, 'PURGE_MAIN', 9);
79: END IF;
80:
81: IF l_min_mmt_date IS NOT NULL THEN
82: SELECT acct_period_id

Line 100: inv_log_util.TRACE('No Records in MMT to purge', 'PURGE_MAIN', 9);

96: AND open_flag = 'N';
97: ELSE
98: l_num_of_periods := 0;
99: IF (l_debug = 1) THEN
100: inv_log_util.TRACE('No Records in MMT to purge', 'PURGE_MAIN', 9);
101: END IF;
102: x_retcode := 0;
103: fnd_message.set_name('INV', 'INV_PURGE_TXN_ERR');
104: x_errbuf := fnd_message.get;

Line 109: inv_log_util.TRACE('No of Periods = ' || l_num_of_periods, 'PURGE_MAIN', 9);

105: RETURN;
106: END IF;
107:
108: IF (l_debug = 1) THEN
109: inv_log_util.TRACE('No of Periods = ' || l_num_of_periods, 'PURGE_MAIN', 9);
110: inv_log_util.TRACE('Min period id = ' || l_min_period_id, 'PURGE_MAIN', 9);
111: END IF;
112:
113: IF l_num_of_periods > 0 THEN

Line 110: inv_log_util.TRACE('Min period id = ' || l_min_period_id, 'PURGE_MAIN', 9);

106: END IF;
107:
108: IF (l_debug = 1) THEN
109: inv_log_util.TRACE('No of Periods = ' || l_num_of_periods, 'PURGE_MAIN', 9);
110: inv_log_util.TRACE('Min period id = ' || l_min_period_id, 'PURGE_MAIN', 9);
111: END IF;
112:
113: IF l_num_of_periods > 0 THEN
114: l_period_per_worker := CEIL(l_num_of_periods / l_max_workers);

Line 119: inv_log_util.TRACE('Period(s) per worker = ' || l_period_per_worker, 'PURGE_MAIN', 9);

115: l_num_of_workers := CEIL(l_num_of_periods / l_period_per_worker);
116: END IF;
117:
118: IF (l_debug = 1) THEN
119: inv_log_util.TRACE('Period(s) per worker = ' || l_period_per_worker, 'PURGE_MAIN', 9);
120: inv_log_util.TRACE('No. of workers = ' || l_num_of_workers, 'PURGE_MAIN', 9);
121: END IF;
122:
123: l_num_of_workers_launched := 0;

Line 120: inv_log_util.TRACE('No. of workers = ' || l_num_of_workers, 'PURGE_MAIN', 9);

116: END IF;
117:
118: IF (l_debug = 1) THEN
119: inv_log_util.TRACE('Period(s) per worker = ' || l_period_per_worker, 'PURGE_MAIN', 9);
120: inv_log_util.TRACE('No. of workers = ' || l_num_of_workers, 'PURGE_MAIN', 9);
121: END IF;
122:
123: l_num_of_workers_launched := 0;
124: l_num_of_periods_fetched := 0;

Line 145: inv_log_util.TRACE('Min period Date= ' || l_min_log_date || ' Max period Date= ' || (l_max_date), 'PURGE_MAIN', 9);

141: --Bug 5894075, removing + 1
142: l_max_date := TRUNC(period_rec_type.max_date);
143:
144: IF (l_debug = 1) THEN
145: inv_log_util.TRACE('Min period Date= ' || l_min_log_date || ' Max period Date= ' || (l_max_date), 'PURGE_MAIN', 9);
146: END IF;
147:
148: l_num_of_periods_fetched := l_num_of_periods_fetched + 1;
149:

Line 153: inv_log_util.TRACE('Launching last Purge worker with Min period Date= ' || l_min_date || ' and Max period Date= ' || p_purge_date, 'PURGE_MAIN', 9);

149:
150: -- For the last worker we purge by p_purge_date
151: IF (l_num_of_workers_launched = l_num_of_workers - 1) THEN
152: IF (l_debug = 1) THEN
153: inv_log_util.TRACE('Launching last Purge worker with Min period Date= ' || l_min_date || ' and Max period Date= ' || p_purge_date, 'PURGE_MAIN', 9);
154: END IF;
155:
156:
157: -- For bug 4055865. Converting the date into Varchar based on the date format on user preference tab.

Line 172: inv_log_util.TRACE('Error launching last Purge Worker', 'PURGE_MAIN', 9);

168:
169: IF (l_purge_req_id = 0) THEN
170: -- Handle submission error --
171: IF (l_debug = 1) THEN
172: inv_log_util.TRACE('Error launching last Purge Worker', 'PURGE_MAIN', 9);
173: END IF;
174:
175: RAISE submission_error_except;
176: ELSE

Line 181: inv_log_util.TRACE('Concurrent Request_id is ' || l_purge_req_id, 'PURGE_MAIN', 9);

177: COMMIT;
178: END IF;
179:
180: IF (l_debug = 1) THEN
181: inv_log_util.TRACE('Concurrent Request_id is ' || l_purge_req_id, 'PURGE_MAIN', 9);
182: END IF;
183:
184: l_num_of_workers_launched := l_num_of_workers_launched + 1;
185: l_reqstatus_tbl_type(l_num_of_workers_launched) := l_purge_req_id;

Line 191: inv_log_util.TRACE('Launching Purge worker with Min period Date= ' || l_min_date || ' and Max period Date= ' || (l_max_date-1), 'PURGE_MAIN', 9);

187: END IF;
188:
189: IF l_num_of_periods_fetched = l_period_per_worker THEN
190: IF (l_debug = 1) THEN
191: inv_log_util.TRACE('Launching Purge worker with Min period Date= ' || l_min_date || ' and Max period Date= ' || (l_max_date-1), 'PURGE_MAIN', 9);
192: END IF;
193:
194:
195: -- For bug 4055865. Converting the date into Varchar based on the date format on user preference tab.

Line 210: inv_log_util.TRACE('Error launching Purge Worker', 'PURGE_MAIN', 9);

206:
207: IF (l_purge_req_id = 0) THEN
208: -- Handle submission error --
209: IF (l_debug = 1) THEN
210: inv_log_util.TRACE('Error launching Purge Worker', 'PURGE_MAIN', 9);
211: END IF;
212:
213: RAISE submission_error_except;
214: ELSE

Line 219: inv_log_util.TRACE('Concurrent Request_id is ' || l_purge_req_id, 'PURGE_MAIN', 9);

215: COMMIT;
216: END IF;
217:
218: IF (l_debug = 1) THEN
219: inv_log_util.TRACE('Concurrent Request_id is ' || l_purge_req_id, 'PURGE_MAIN', 9);
220: END IF;
221:
222: l_num_of_workers_launched := l_num_of_workers_launched + 1;
223: l_num_of_periods_fetched := 0; --resetting l_num_of_periods_fetched

Line 274: inv_log_util.TRACE('Concurrent Request_id ' || l_reqstatus_tbl_type(idx) || ' has completed with ' ||l_status_code_tbl_type(idx), 'PURGE_MAIN', 9);

270: l_status_code_tbl_type(idx) := 'warning';
271: END IF;
272:
273: IF (l_debug = 1) THEN
274: inv_log_util.TRACE('Concurrent Request_id ' || l_reqstatus_tbl_type(idx) || ' has completed with ' ||l_status_code_tbl_type(idx), 'PURGE_MAIN', 9);
275: END IF;
276: END LOOP;
277:
278: --Bug 3687369, if any of the child requests errors out, then main program should complete with a warning.

Line 290: inv_log_util.TRACE('No periods to purge','PURGE_MAIN', 1);

286: x_retcode := 0;
287: x_errbuf := 'Success';
288: ELSE --l_period_per_worker = 0
289: IF (l_debug = 1) THEN
290: inv_log_util.TRACE('No periods to purge','PURGE_MAIN', 1);
291: END IF;
292: x_retcode := 0;
293: fnd_message.set_name('INV', 'INV_PURGE_TXN_ERR');
294: x_errbuf := fnd_message.get;

Line 299: inv_log_util.TRACE('submission_error_except :' || SQLCODE, 'PURGE_MAIN', 1);

295: END IF;
296: EXCEPTION
297: WHEN submission_error_except THEN
298: IF (l_debug = 1) THEN
299: inv_log_util.TRACE('submission_error_except :' || SQLCODE, 'PURGE_MAIN', 1);
300: inv_log_util.TRACE('submission_error_except :' || SUBSTR(SQLERRM, 1, 100), 'PURGE_MAIN', 1);
301: END IF;
302:
303: IF c_oap%ISOPEN THEN

Line 300: inv_log_util.TRACE('submission_error_except :' || SUBSTR(SQLERRM, 1, 100), 'PURGE_MAIN', 1);

296: EXCEPTION
297: WHEN submission_error_except THEN
298: IF (l_debug = 1) THEN
299: inv_log_util.TRACE('submission_error_except :' || SQLCODE, 'PURGE_MAIN', 1);
300: inv_log_util.TRACE('submission_error_except :' || SUBSTR(SQLERRM, 1, 100), 'PURGE_MAIN', 1);
301: END IF;
302:
303: IF c_oap%ISOPEN THEN
304: CLOSE c_oap;

Line 312: inv_log_util.TRACE('Error :' || SUBSTR(SQLERRM, 1, 100), 'PURGE_MAIN', 1);

308: fnd_message.set_name('INV', 'INV_PURGE_TXN_ERR');
309: x_errbuf := fnd_message.get;
310: WHEN OTHERS THEN
311: IF (l_debug = 1) THEN
312: inv_log_util.TRACE('Error :' || SUBSTR(SQLERRM, 1, 100), 'PURGE_MAIN', 1);
313: END IF;
314:
315: IF c_oap%ISOPEN THEN
316: CLOSE c_oap;