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.PA_ONESTEP_STREAMLINE_PKG dependencies on PA_DEBUG

Line 16: pa_debug.set_err_stack('update_request_table');

12: retval BOOLEAN;
13:
14: BEGIN
15:
16: pa_debug.set_err_stack('update_request_table');
17: pa_debug.g_err_stage := 'Entering update_request_table()';
18: pa_debug.write_file('LOG',pa_debug.g_err_stage);
19:
20: FOR i IN 1..tbl.count LOOP

Line 17: pa_debug.g_err_stage := 'Entering update_request_table()';

13:
14: BEGIN
15:
16: pa_debug.set_err_stack('update_request_table');
17: pa_debug.g_err_stage := 'Entering update_request_table()';
18: pa_debug.write_file('LOG',pa_debug.g_err_stage);
19:
20: FOR i IN 1..tbl.count LOOP
21:

Line 18: pa_debug.write_file('LOG',pa_debug.g_err_stage);

14: BEGIN
15:
16: pa_debug.set_err_stack('update_request_table');
17: pa_debug.g_err_stage := 'Entering update_request_table()';
18: pa_debug.write_file('LOG',pa_debug.g_err_stage);
19:
20: FOR i IN 1..tbl.count LOOP
21:
22: IF (tbl(i).request_id <> 0) THEN

Line 35: pa_debug.g_err_stage := 'fnd_concurrent.get_request_status return FALSE for Request ID ' ||to_char(tbl(i).request_id);

31: tbl(i).u_status := r_status;
32:
33: ELSE
34:
35: pa_debug.g_err_stage := 'fnd_concurrent.get_request_status return FALSE for Request ID ' ||to_char(tbl(i).request_id);
36: pa_debug.write_file('LOG',pa_debug.g_err_stage);
37:
38: END IF;
39:

Line 36: pa_debug.write_file('LOG',pa_debug.g_err_stage);

32:
33: ELSE
34:
35: pa_debug.g_err_stage := 'fnd_concurrent.get_request_status return FALSE for Request ID ' ||to_char(tbl(i).request_id);
36: pa_debug.write_file('LOG',pa_debug.g_err_stage);
37:
38: END IF;
39:
40: END IF;

Line 44: pa_debug.g_err_stage := 'Leaving update_request_table()';

40: END IF;
41:
42: END LOOP;
43:
44: pa_debug.g_err_stage := 'Leaving update_request_table()';
45: pa_debug.write_file('LOG',pa_debug.g_err_stage);
46: pa_debug.reset_err_stack;
47:
48: EXCEPTION

Line 45: pa_debug.write_file('LOG',pa_debug.g_err_stage);

41:
42: END LOOP;
43:
44: pa_debug.g_err_stage := 'Leaving update_request_table()';
45: pa_debug.write_file('LOG',pa_debug.g_err_stage);
46: pa_debug.reset_err_stack;
47:
48: EXCEPTION
49: WHEN OTHERS THEN

Line 46: pa_debug.reset_err_stack;

42: END LOOP;
43:
44: pa_debug.g_err_stage := 'Leaving update_request_table()';
45: pa_debug.write_file('LOG',pa_debug.g_err_stage);
46: pa_debug.reset_err_stack;
47:
48: EXCEPTION
49: WHEN OTHERS THEN
50: pa_debug.write_file('LOG','update_request_table() exception: Others');

Line 50: pa_debug.write_file('LOG','update_request_table() exception: Others');

46: pa_debug.reset_err_stack;
47:
48: EXCEPTION
49: WHEN OTHERS THEN
50: pa_debug.write_file('LOG','update_request_table() exception: Others');
51: pa_debug.write_file('LOG',pa_debug.g_err_stack);
52: pa_debug.write_file('LOG',pa_debug.g_err_stage);
53: RAISE;
54:

Line 51: pa_debug.write_file('LOG',pa_debug.g_err_stack);

47:
48: EXCEPTION
49: WHEN OTHERS THEN
50: pa_debug.write_file('LOG','update_request_table() exception: Others');
51: pa_debug.write_file('LOG',pa_debug.g_err_stack);
52: pa_debug.write_file('LOG',pa_debug.g_err_stage);
53: RAISE;
54:
55: END update_request_state;

Line 52: pa_debug.write_file('LOG',pa_debug.g_err_stage);

48: EXCEPTION
49: WHEN OTHERS THEN
50: pa_debug.write_file('LOG','update_request_table() exception: Others');
51: pa_debug.write_file('LOG',pa_debug.g_err_stack);
52: pa_debug.write_file('LOG',pa_debug.g_err_stage);
53: RAISE;
54:
55: END update_request_state;
56:

Line 83: pa_debug.set_err_stack('submit_strmln_request');

79: L_org_id NUMBER := PA_MOAC_UTILS.GET_CURRENT_ORG_ID ;
80:
81: BEGIN
82:
83: pa_debug.set_err_stack('submit_strmln_request');
84: pa_debug.g_err_stage := 'Entering submit_strmln_request()';
85: pa_debug.write_file('LOG',pa_debug.g_err_stage);
86:
87: FOR strmln_opt IN c_strmln_opt(strm_option) LOOP

Line 84: pa_debug.g_err_stage := 'Entering submit_strmln_request()';

80:
81: BEGIN
82:
83: pa_debug.set_err_stack('submit_strmln_request');
84: pa_debug.g_err_stage := 'Entering submit_strmln_request()';
85: pa_debug.write_file('LOG',pa_debug.g_err_stage);
86:
87: FOR strmln_opt IN c_strmln_opt(strm_option) LOOP
88:

Line 85: pa_debug.write_file('LOG',pa_debug.g_err_stage);

81: BEGIN
82:
83: pa_debug.set_err_stack('submit_strmln_request');
84: pa_debug.g_err_stage := 'Entering submit_strmln_request()';
85: pa_debug.write_file('LOG',pa_debug.g_err_stage);
86:
87: FOR strmln_opt IN c_strmln_opt(strm_option) LOOP
88:
89: /* Setting print options bug 2816916 */

Line 119: pa_debug.g_err_stage := 'Request ID='||to_char(tbl(v_cnt).request_id)||

115: INTO tbl(v_cnt).request_id,tbl(v_cnt).lookup_code,
116: tbl(v_cnt).phase,tbl(v_cnt).status
117: FROM dual;
118:
119: pa_debug.g_err_stage := 'Request ID='||to_char(tbl(v_cnt).request_id)||
120: ', Streamline Option='||tbl(v_cnt).lookup_code;
121: pa_debug.write_file('LOG',pa_debug.g_err_stage);
122: pa_debug.g_err_stage := ' SOB ID='||to_char(tbl(v_cnt).sob_id)||
123: ', Phase='||tbl(v_cnt).phase||', Status='||tbl(v_cnt).status;

Line 121: pa_debug.write_file('LOG',pa_debug.g_err_stage);

117: FROM dual;
118:
119: pa_debug.g_err_stage := 'Request ID='||to_char(tbl(v_cnt).request_id)||
120: ', Streamline Option='||tbl(v_cnt).lookup_code;
121: pa_debug.write_file('LOG',pa_debug.g_err_stage);
122: pa_debug.g_err_stage := ' SOB ID='||to_char(tbl(v_cnt).sob_id)||
123: ', Phase='||tbl(v_cnt).phase||', Status='||tbl(v_cnt).status;
124: pa_debug.write_file('LOG',pa_debug.g_err_stage);
125:

Line 122: pa_debug.g_err_stage := ' SOB ID='||to_char(tbl(v_cnt).sob_id)||

118:
119: pa_debug.g_err_stage := 'Request ID='||to_char(tbl(v_cnt).request_id)||
120: ', Streamline Option='||tbl(v_cnt).lookup_code;
121: pa_debug.write_file('LOG',pa_debug.g_err_stage);
122: pa_debug.g_err_stage := ' SOB ID='||to_char(tbl(v_cnt).sob_id)||
123: ', Phase='||tbl(v_cnt).phase||', Status='||tbl(v_cnt).status;
124: pa_debug.write_file('LOG',pa_debug.g_err_stage);
125:
126: END LOOP;

Line 124: pa_debug.write_file('LOG',pa_debug.g_err_stage);

120: ', Streamline Option='||tbl(v_cnt).lookup_code;
121: pa_debug.write_file('LOG',pa_debug.g_err_stage);
122: pa_debug.g_err_stage := ' SOB ID='||to_char(tbl(v_cnt).sob_id)||
123: ', Phase='||tbl(v_cnt).phase||', Status='||tbl(v_cnt).status;
124: pa_debug.write_file('LOG',pa_debug.g_err_stage);
125:
126: END LOOP;
127: pa_debug.g_err_stage := 'Leaving submit_strmln_request() with success';
128: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 127: pa_debug.g_err_stage := 'Leaving submit_strmln_request() with success';

123: ', Phase='||tbl(v_cnt).phase||', Status='||tbl(v_cnt).status;
124: pa_debug.write_file('LOG',pa_debug.g_err_stage);
125:
126: END LOOP;
127: pa_debug.g_err_stage := 'Leaving submit_strmln_request() with success';
128: pa_debug.write_file('LOG',pa_debug.g_err_stage);
129: pa_debug.reset_err_stack;
130:
131: EXCEPTION

Line 128: pa_debug.write_file('LOG',pa_debug.g_err_stage);

124: pa_debug.write_file('LOG',pa_debug.g_err_stage);
125:
126: END LOOP;
127: pa_debug.g_err_stage := 'Leaving submit_strmln_request() with success';
128: pa_debug.write_file('LOG',pa_debug.g_err_stage);
129: pa_debug.reset_err_stack;
130:
131: EXCEPTION
132: WHEN OTHERS THEN

Line 129: pa_debug.reset_err_stack;

125:
126: END LOOP;
127: pa_debug.g_err_stage := 'Leaving submit_strmln_request() with success';
128: pa_debug.write_file('LOG',pa_debug.g_err_stage);
129: pa_debug.reset_err_stack;
130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: pa_debug.write_file('LOG','submit_strmln_request() exception: Others');

Line 133: pa_debug.write_file('LOG','submit_strmln_request() exception: Others');

129: pa_debug.reset_err_stack;
130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: pa_debug.write_file('LOG','submit_strmln_request() exception: Others');
134: pa_debug.write_file('LOG',pa_debug.g_err_stack);
135: pa_debug.write_file('LOG',pa_debug.g_err_stage);
136: RAISE;
137:

Line 134: pa_debug.write_file('LOG',pa_debug.g_err_stack);

130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: pa_debug.write_file('LOG','submit_strmln_request() exception: Others');
134: pa_debug.write_file('LOG',pa_debug.g_err_stack);
135: pa_debug.write_file('LOG',pa_debug.g_err_stage);
136: RAISE;
137:
138: END submit_strmln_request;

Line 135: pa_debug.write_file('LOG',pa_debug.g_err_stage);

131: EXCEPTION
132: WHEN OTHERS THEN
133: pa_debug.write_file('LOG','submit_strmln_request() exception: Others');
134: pa_debug.write_file('LOG',pa_debug.g_err_stack);
135: pa_debug.write_file('LOG',pa_debug.g_err_stage);
136: RAISE;
137:
138: END submit_strmln_request;
139:

Line 160: pa_debug.set_err_stack('show_final_status');

156: v_length NUMBER;
157:
158: BEGIN
159:
160: pa_debug.set_err_stack('show_final_status');
161: pa_debug.g_err_stage := 'Entering show_final_status()';
162: pa_debug.write_file('LOG',pa_debug.g_err_stage);
163:
164: FOR strmln_opt IN c_strmln_opt(v_opt) LOOP

Line 161: pa_debug.g_err_stage := 'Entering show_final_status()';

157:
158: BEGIN
159:
160: pa_debug.set_err_stack('show_final_status');
161: pa_debug.g_err_stage := 'Entering show_final_status()';
162: pa_debug.write_file('LOG',pa_debug.g_err_stage);
163:
164: FOR strmln_opt IN c_strmln_opt(v_opt) LOOP
165: v_length := trunc((130-length(strmln_opt.meaning))/2+

Line 162: pa_debug.write_file('LOG',pa_debug.g_err_stage);

158: BEGIN
159:
160: pa_debug.set_err_stack('show_final_status');
161: pa_debug.g_err_stage := 'Entering show_final_status()';
162: pa_debug.write_file('LOG',pa_debug.g_err_stage);
163:
164: FOR strmln_opt IN c_strmln_opt(v_opt) LOOP
165: v_length := trunc((130-length(strmln_opt.meaning))/2+
166: length(strmln_opt.meaning));

Line 170: pa_debug.g_err_stage := 'Request='||tbl(i).request_id||

166: length(strmln_opt.meaning));
167:
168: FOR i IN 1..tbl.count LOOP
169: IF (strmln_opt.lookup_code = tbl(i).lookup_code) THEN
170: pa_debug.g_err_stage := 'Request='||tbl(i).request_id||
171: ', lookup-code='||tbl(i).lookup_code||', SOB ID='||
172: tbl(i).sob_id;
173: pa_debug.write_file('LOG',pa_debug.g_err_stage);
174:

Line 173: pa_debug.write_file('LOG',pa_debug.g_err_stage);

169: IF (strmln_opt.lookup_code = tbl(i).lookup_code) THEN
170: pa_debug.g_err_stage := 'Request='||tbl(i).request_id||
171: ', lookup-code='||tbl(i).lookup_code||', SOB ID='||
172: tbl(i).sob_id;
173: pa_debug.write_file('LOG',pa_debug.g_err_stage);
174:
175: pa_debug.g_err_stage := ' u_phase='||tbl(i).u_phase||
176: ', u_status='||tbl(i).u_status||', PHASE='||tbl(i).phase||
177: ', STATUS='||tbl(i).status;

Line 175: pa_debug.g_err_stage := ' u_phase='||tbl(i).u_phase||

171: ', lookup-code='||tbl(i).lookup_code||', SOB ID='||
172: tbl(i).sob_id;
173: pa_debug.write_file('LOG',pa_debug.g_err_stage);
174:
175: pa_debug.g_err_stage := ' u_phase='||tbl(i).u_phase||
176: ', u_status='||tbl(i).u_status||', PHASE='||tbl(i).phase||
177: ', STATUS='||tbl(i).status;
178: pa_debug.write_file('LOG',pa_debug.g_err_stage);
179:

Line 178: pa_debug.write_file('LOG',pa_debug.g_err_stage);

174:
175: pa_debug.g_err_stage := ' u_phase='||tbl(i).u_phase||
176: ', u_status='||tbl(i).u_status||', PHASE='||tbl(i).phase||
177: ', STATUS='||tbl(i).status;
178: pa_debug.write_file('LOG',pa_debug.g_err_stage);
179:
180: IF (tbl(i).status <> 'NORMAL') THEN
181: errbuf := errbuf||'request id '||to_char(tbl(i).request_id)||
182: ': '||tbl(i).phase||' '||tbl(i).status;

Line 189: pa_debug.g_err_stage := 'Leaving show_final_status() with success';

185: END IF;
186: END LOOP;
187: END LOOP;
188:
189: pa_debug.g_err_stage := 'Leaving show_final_status() with success';
190: pa_debug.write_file('LOG',pa_debug.g_err_stage);
191: pa_debug.reset_err_stack;
192:
193: EXCEPTION

Line 190: pa_debug.write_file('LOG',pa_debug.g_err_stage);

186: END LOOP;
187: END LOOP;
188:
189: pa_debug.g_err_stage := 'Leaving show_final_status() with success';
190: pa_debug.write_file('LOG',pa_debug.g_err_stage);
191: pa_debug.reset_err_stack;
192:
193: EXCEPTION
194: WHEN OTHERS THEN

Line 191: pa_debug.reset_err_stack;

187: END LOOP;
188:
189: pa_debug.g_err_stage := 'Leaving show_final_status() with success';
190: pa_debug.write_file('LOG',pa_debug.g_err_stage);
191: pa_debug.reset_err_stack;
192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: pa_debug.write_file('LOG','show_final_status() exception: Others');

Line 195: pa_debug.write_file('LOG','show_final_status() exception: Others');

191: pa_debug.reset_err_stack;
192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: pa_debug.write_file('LOG','show_final_status() exception: Others');
196: pa_debug.write_file('LOG',pa_debug.g_err_stack);
197: pa_debug.write_file('LOG',pa_debug.g_err_stage);
198: RAISE;
199:

Line 196: pa_debug.write_file('LOG',pa_debug.g_err_stack);

192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: pa_debug.write_file('LOG','show_final_status() exception: Others');
196: pa_debug.write_file('LOG',pa_debug.g_err_stack);
197: pa_debug.write_file('LOG',pa_debug.g_err_stage);
198: RAISE;
199:
200: END show_final_status;

Line 197: pa_debug.write_file('LOG',pa_debug.g_err_stage);

193: EXCEPTION
194: WHEN OTHERS THEN
195: pa_debug.write_file('LOG','show_final_status() exception: Others');
196: pa_debug.write_file('LOG',pa_debug.g_err_stack);
197: pa_debug.write_file('LOG',pa_debug.g_err_stage);
198: RAISE;
199:
200: END show_final_status;
201:

Line 229: pa_debug.init_err_stack('PAOSTRM');

225: BEGIN
226:
227: retcode := '0';
228: g_debug_mode := debug_mode;
229: pa_debug.init_err_stack('PAOSTRM');
230: pa_debug.set_process('PLSQL', 'LOG', debug_mode);
231: pa_debug.g_err_stage := 'Entering PAOSTRM()';
232: pa_debug.write_file('LOG',pa_debug.g_err_stage);
233: pa_debug.g_err_stage := ' Current system time is '||

Line 230: pa_debug.set_process('PLSQL', 'LOG', debug_mode);

226:
227: retcode := '0';
228: g_debug_mode := debug_mode;
229: pa_debug.init_err_stack('PAOSTRM');
230: pa_debug.set_process('PLSQL', 'LOG', debug_mode);
231: pa_debug.g_err_stage := 'Entering PAOSTRM()';
232: pa_debug.write_file('LOG',pa_debug.g_err_stage);
233: pa_debug.g_err_stage := ' Current system time is '||
234: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS');

Line 231: pa_debug.g_err_stage := 'Entering PAOSTRM()';

227: retcode := '0';
228: g_debug_mode := debug_mode;
229: pa_debug.init_err_stack('PAOSTRM');
230: pa_debug.set_process('PLSQL', 'LOG', debug_mode);
231: pa_debug.g_err_stage := 'Entering PAOSTRM()';
232: pa_debug.write_file('LOG',pa_debug.g_err_stage);
233: pa_debug.g_err_stage := ' Current system time is '||
234: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS');
235: pa_debug.write_file('LOG',pa_debug.g_err_stage);

Line 232: pa_debug.write_file('LOG',pa_debug.g_err_stage);

228: g_debug_mode := debug_mode;
229: pa_debug.init_err_stack('PAOSTRM');
230: pa_debug.set_process('PLSQL', 'LOG', debug_mode);
231: pa_debug.g_err_stage := 'Entering PAOSTRM()';
232: pa_debug.write_file('LOG',pa_debug.g_err_stage);
233: pa_debug.g_err_stage := ' Current system time is '||
234: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS');
235: pa_debug.write_file('LOG',pa_debug.g_err_stage);
236:

Line 233: pa_debug.g_err_stage := ' Current system time is '||

229: pa_debug.init_err_stack('PAOSTRM');
230: pa_debug.set_process('PLSQL', 'LOG', debug_mode);
231: pa_debug.g_err_stage := 'Entering PAOSTRM()';
232: pa_debug.write_file('LOG',pa_debug.g_err_stage);
233: pa_debug.g_err_stage := ' Current system time is '||
234: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS');
235: pa_debug.write_file('LOG',pa_debug.g_err_stage);
236:
237: pa_debug.g_err_stage := 'Current Acct Date is '||acct_date;

Line 235: pa_debug.write_file('LOG',pa_debug.g_err_stage);

231: pa_debug.g_err_stage := 'Entering PAOSTRM()';
232: pa_debug.write_file('LOG',pa_debug.g_err_stage);
233: pa_debug.g_err_stage := ' Current system time is '||
234: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS');
235: pa_debug.write_file('LOG',pa_debug.g_err_stage);
236:
237: pa_debug.g_err_stage := 'Current Acct Date is '||acct_date;
238: pa_debug.write_file('LOG',pa_debug.g_err_stage);
239: v_user_id := fnd_global.user_id;

Line 237: pa_debug.g_err_stage := 'Current Acct Date is '||acct_date;

233: pa_debug.g_err_stage := ' Current system time is '||
234: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS');
235: pa_debug.write_file('LOG',pa_debug.g_err_stage);
236:
237: pa_debug.g_err_stage := 'Current Acct Date is '||acct_date;
238: pa_debug.write_file('LOG',pa_debug.g_err_stage);
239: v_user_id := fnd_global.user_id;
240: v_application_id := fnd_global.resp_appl_id;
241:

Line 238: pa_debug.write_file('LOG',pa_debug.g_err_stage);

234: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS');
235: pa_debug.write_file('LOG',pa_debug.g_err_stage);
236:
237: pa_debug.g_err_stage := 'Current Acct Date is '||acct_date;
238: pa_debug.write_file('LOG',pa_debug.g_err_stage);
239: v_user_id := fnd_global.user_id;
240: v_application_id := fnd_global.resp_appl_id;
241:
242: /* added for bug 2816916 */

Line 265: pa_debug.g_err_stage := 'User ID: '||to_char(v_user_id)||', PSOB ID: '||

261: -- Get Sleep Interval
262: v_sleep_interval :=
263: nvl(3*to_number(fnd_profile.value('PA_STRMLN_SLEEP_INTERVAL')), 180);
264:
265: pa_debug.g_err_stage := 'User ID: '||to_char(v_user_id)||', PSOB ID: '||
266: to_char(v_psob_id)||', ORG ID: '||to_char(v_org_id);
267: pa_debug.write_file('LOG',pa_debug.g_err_stage);
268: pa_debug.g_err_stage := 'Strmln Opt: '||strm_opt||', Resp ID: '||
269: v_responsibility_id||', Sleep Interval: '||v_sleep_interval||' Date:'||v_acct_date;

Line 267: pa_debug.write_file('LOG',pa_debug.g_err_stage);

263: nvl(3*to_number(fnd_profile.value('PA_STRMLN_SLEEP_INTERVAL')), 180);
264:
265: pa_debug.g_err_stage := 'User ID: '||to_char(v_user_id)||', PSOB ID: '||
266: to_char(v_psob_id)||', ORG ID: '||to_char(v_org_id);
267: pa_debug.write_file('LOG',pa_debug.g_err_stage);
268: pa_debug.g_err_stage := 'Strmln Opt: '||strm_opt||', Resp ID: '||
269: v_responsibility_id||', Sleep Interval: '||v_sleep_interval||' Date:'||v_acct_date;
270: pa_debug.write_file('LOG',pa_debug.g_err_stage);
271: -- Start process for primary set of books

Line 268: pa_debug.g_err_stage := 'Strmln Opt: '||strm_opt||', Resp ID: '||

264:
265: pa_debug.g_err_stage := 'User ID: '||to_char(v_user_id)||', PSOB ID: '||
266: to_char(v_psob_id)||', ORG ID: '||to_char(v_org_id);
267: pa_debug.write_file('LOG',pa_debug.g_err_stage);
268: pa_debug.g_err_stage := 'Strmln Opt: '||strm_opt||', Resp ID: '||
269: v_responsibility_id||', Sleep Interval: '||v_sleep_interval||' Date:'||v_acct_date;
270: pa_debug.write_file('LOG',pa_debug.g_err_stage);
271: -- Start process for primary set of books
272: submit_strmln_request(strm_request_table, strm_opt,v_acct_date);

Line 270: pa_debug.write_file('LOG',pa_debug.g_err_stage);

266: to_char(v_psob_id)||', ORG ID: '||to_char(v_org_id);
267: pa_debug.write_file('LOG',pa_debug.g_err_stage);
268: pa_debug.g_err_stage := 'Strmln Opt: '||strm_opt||', Resp ID: '||
269: v_responsibility_id||', Sleep Interval: '||v_sleep_interval||' Date:'||v_acct_date;
270: pa_debug.write_file('LOG',pa_debug.g_err_stage);
271: -- Start process for primary set of books
272: submit_strmln_request(strm_request_table, strm_opt,v_acct_date);
273:
274:

Line 275: pa_debug.g_err_stage := 'All ' ||strm_request_table.count||

271: -- Start process for primary set of books
272: submit_strmln_request(strm_request_table, strm_opt,v_acct_date);
273:
274:
275: pa_debug.g_err_stage := 'All ' ||strm_request_table.count||
276: ' processes submitted; check completion status.';
277: pa_debug.write_file('LOG',pa_debug.g_err_stage);
278:
279:

Line 277: pa_debug.write_file('LOG',pa_debug.g_err_stage);

273:
274:
275: pa_debug.g_err_stage := 'All ' ||strm_request_table.count||
276: ' processes submitted; check completion status.';
277: pa_debug.write_file('LOG',pa_debug.g_err_stage);
278:
279:
280: LOOP -- check if all primary and reporting processes have completed
281: v_completed_r := true;

Line 291: pa_debug.g_err_stage := strm_request_table(i).status||' '||

287: ELSIF (strm_request_table(i).phase = 'COMPLETE') AND
288: (strm_request_table(i).status = 'WARNING') AND
289: (retcode <> '-1') THEN
290:
291: pa_debug.g_err_stage := strm_request_table(i).status||' '||
292: strm_request_table(i).phase;
293: pa_debug.write_file('LOG',pa_debug.g_err_stage);
294:
295: retcode := '1';

Line 293: pa_debug.write_file('LOG',pa_debug.g_err_stage);

289: (retcode <> '-1') THEN
290:
291: pa_debug.g_err_stage := strm_request_table(i).status||' '||
292: strm_request_table(i).phase;
293: pa_debug.write_file('LOG',pa_debug.g_err_stage);
294:
295: retcode := '1';
296: ELSIF (strm_request_table(i).phase = 'COMPLETE') AND
297: (strm_request_table(i).status = 'DELETED') AND

Line 300: pa_debug.g_err_stage := strm_request_table(i).status||' '||

296: ELSIF (strm_request_table(i).phase = 'COMPLETE') AND
297: (strm_request_table(i).status = 'DELETED') AND
298: (retcode <> '-1') THEN
299:
300: pa_debug.g_err_stage := strm_request_table(i).status||' '||
301: strm_request_table(i).phase;
302: pa_debug.write_file('LOG',pa_debug.g_err_stage);
303:
304: retcode := '1';

Line 302: pa_debug.write_file('LOG',pa_debug.g_err_stage);

298: (retcode <> '-1') THEN
299:
300: pa_debug.g_err_stage := strm_request_table(i).status||' '||
301: strm_request_table(i).phase;
302: pa_debug.write_file('LOG',pa_debug.g_err_stage);
303:
304: retcode := '1';
305: ELSIF (strm_request_table(i).phase = 'COMPLETE') AND
306: (strm_request_table(i).status <> 'NORMAL') THEN

Line 308: pa_debug.g_err_stage := strm_request_table(i).status||' '||

304: retcode := '1';
305: ELSIF (strm_request_table(i).phase = 'COMPLETE') AND
306: (strm_request_table(i).status <> 'NORMAL') THEN
307:
308: pa_debug.g_err_stage := strm_request_table(i).status||' '||
309: strm_request_table(i).phase;
310: pa_debug.write_file('LOG',pa_debug.g_err_stage);
311:
312: retcode := '-1';

Line 310: pa_debug.write_file('LOG',pa_debug.g_err_stage);

306: (strm_request_table(i).status <> 'NORMAL') THEN
307:
308: pa_debug.g_err_stage := strm_request_table(i).status||' '||
309: strm_request_table(i).phase;
310: pa_debug.write_file('LOG',pa_debug.g_err_stage);
311:
312: retcode := '-1';
313: END IF;
314: END LOOP;

Line 318: pa_debug.g_err_stage := 'Leaving PAOSTRM() with success';

314: END LOOP;
315: EXIT WHEN (v_completed_r);
316: END LOOP;
317: show_final_status(strm_request_table, strm_opt, errbuf);
318: pa_debug.g_err_stage := 'Leaving PAOSTRM() with success';
319: pa_debug.write_file('LOG',pa_debug.g_err_stage);
320: pa_debug.reset_err_stack;
321:
322: EXCEPTION

Line 319: pa_debug.write_file('LOG',pa_debug.g_err_stage);

315: EXIT WHEN (v_completed_r);
316: END LOOP;
317: show_final_status(strm_request_table, strm_opt, errbuf);
318: pa_debug.g_err_stage := 'Leaving PAOSTRM() with success';
319: pa_debug.write_file('LOG',pa_debug.g_err_stage);
320: pa_debug.reset_err_stack;
321:
322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN

Line 320: pa_debug.reset_err_stack;

316: END LOOP;
317: show_final_status(strm_request_table, strm_opt, errbuf);
318: pa_debug.g_err_stage := 'Leaving PAOSTRM() with success';
319: pa_debug.write_file('LOG',pa_debug.g_err_stage);
320: pa_debug.reset_err_stack;
321:
322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN
324: pa_debug.write_file('LOG','PAOSTRM() exception: No data found');

Line 324: pa_debug.write_file('LOG','PAOSTRM() exception: No data found');

320: pa_debug.reset_err_stack;
321:
322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN
324: pa_debug.write_file('LOG','PAOSTRM() exception: No data found');
325: pa_debug.write_file('LOG',pa_debug.g_err_stack);
326: pa_debug.write_file('LOG',pa_debug.g_err_stage);
327:
328: WHEN OTHERS THEN

Line 325: pa_debug.write_file('LOG',pa_debug.g_err_stack);

321:
322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN
324: pa_debug.write_file('LOG','PAOSTRM() exception: No data found');
325: pa_debug.write_file('LOG',pa_debug.g_err_stack);
326: pa_debug.write_file('LOG',pa_debug.g_err_stage);
327:
328: WHEN OTHERS THEN
329: show_final_status(strm_request_table, strm_opt, errbuf);

Line 326: pa_debug.write_file('LOG',pa_debug.g_err_stage);

322: EXCEPTION
323: WHEN NO_DATA_FOUND THEN
324: pa_debug.write_file('LOG','PAOSTRM() exception: No data found');
325: pa_debug.write_file('LOG',pa_debug.g_err_stack);
326: pa_debug.write_file('LOG',pa_debug.g_err_stage);
327:
328: WHEN OTHERS THEN
329: show_final_status(strm_request_table, strm_opt, errbuf);
330: errbuf := errbuf||'errbuf: '||sqlerrm;

Line 331: pa_debug.write_file('LOG','PAOSTRM() exception: Others');

327:
328: WHEN OTHERS THEN
329: show_final_status(strm_request_table, strm_opt, errbuf);
330: errbuf := errbuf||'errbuf: '||sqlerrm;
331: pa_debug.write_file('LOG','PAOSTRM() exception: Others');
332: pa_debug.write_file('LOG',pa_debug.g_err_stack);
333: pa_debug.write_file('LOG',pa_debug.g_err_stage);
334:
335: END PAOSTRM;

Line 332: pa_debug.write_file('LOG',pa_debug.g_err_stack);

328: WHEN OTHERS THEN
329: show_final_status(strm_request_table, strm_opt, errbuf);
330: errbuf := errbuf||'errbuf: '||sqlerrm;
331: pa_debug.write_file('LOG','PAOSTRM() exception: Others');
332: pa_debug.write_file('LOG',pa_debug.g_err_stack);
333: pa_debug.write_file('LOG',pa_debug.g_err_stage);
334:
335: END PAOSTRM;
336:

Line 333: pa_debug.write_file('LOG',pa_debug.g_err_stage);

329: show_final_status(strm_request_table, strm_opt, errbuf);
330: errbuf := errbuf||'errbuf: '||sqlerrm;
331: pa_debug.write_file('LOG','PAOSTRM() exception: Others');
332: pa_debug.write_file('LOG',pa_debug.g_err_stack);
333: pa_debug.write_file('LOG',pa_debug.g_err_stage);
334:
335: END PAOSTRM;
336:
337: END PA_ONESTEP_STREAMLINE_PKG;