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.

OWAPUB.DEBUG_CARTX dependencies on HTP

Line 114: htp.htmlopen;

110:
111: PROCEDURE handleAborts(stopflag integer, SessID varchar2) is
112: begin
113:
114: htp.htmlopen;
115: htp.headopen;
116:
117: if (stopflag = DEBUG_CARTX_ERR_CRTPROC) then
118: htp.title('Cartridge Debug Error');

Line 115: htp.headopen;

111: PROCEDURE handleAborts(stopflag integer, SessID varchar2) is
112: begin
113:
114: htp.htmlopen;
115: htp.headopen;
116:
117: if (stopflag = DEBUG_CARTX_ERR_CRTPROC) then
118: htp.title('Cartridge Debug Error');
119: htp.headclose;

Line 118: htp.title('Cartridge Debug Error');

114: htp.htmlopen;
115: htp.headopen;
116:
117: if (stopflag = DEBUG_CARTX_ERR_CRTPROC) then
118: htp.title('Cartridge Debug Error');
119: htp.headclose;
120: htp.bodyopen;
121: htp.bold('Error in getting proper debug information.' || htf.paragraph);
122: htp.print('Please recompile the procedure and try again.');

Line 119: htp.headclose;

115: htp.headopen;
116:
117: if (stopflag = DEBUG_CARTX_ERR_CRTPROC) then
118: htp.title('Cartridge Debug Error');
119: htp.headclose;
120: htp.bodyopen;
121: htp.bold('Error in getting proper debug information.' || htf.paragraph);
122: htp.print('Please recompile the procedure and try again.');
123: elsif (stopflag = DEBUG_CARTX_ABORT) then

Line 120: htp.bodyopen;

116:
117: if (stopflag = DEBUG_CARTX_ERR_CRTPROC) then
118: htp.title('Cartridge Debug Error');
119: htp.headclose;
120: htp.bodyopen;
121: htp.bold('Error in getting proper debug information.' || htf.paragraph);
122: htp.print('Please recompile the procedure and try again.');
123: elsif (stopflag = DEBUG_CARTX_ABORT) then
124: htp.title('Debug process aborted by the user');

Line 121: htp.bold('Error in getting proper debug information.' || htf.paragraph);

117: if (stopflag = DEBUG_CARTX_ERR_CRTPROC) then
118: htp.title('Cartridge Debug Error');
119: htp.headclose;
120: htp.bodyopen;
121: htp.bold('Error in getting proper debug information.' || htf.paragraph);
122: htp.print('Please recompile the procedure and try again.');
123: elsif (stopflag = DEBUG_CARTX_ABORT) then
124: htp.title('Debug process aborted by the user');
125: htp.headclose;

Line 122: htp.print('Please recompile the procedure and try again.');

118: htp.title('Cartridge Debug Error');
119: htp.headclose;
120: htp.bodyopen;
121: htp.bold('Error in getting proper debug information.' || htf.paragraph);
122: htp.print('Please recompile the procedure and try again.');
123: elsif (stopflag = DEBUG_CARTX_ABORT) then
124: htp.title('Debug process aborted by the user');
125: htp.headclose;
126: htp.bodyopen;

Line 124: htp.title('Debug process aborted by the user');

120: htp.bodyopen;
121: htp.bold('Error in getting proper debug information.' || htf.paragraph);
122: htp.print('Please recompile the procedure and try again.');
123: elsif (stopflag = DEBUG_CARTX_ABORT) then
124: htp.title('Debug process aborted by the user');
125: htp.headclose;
126: htp.bodyopen;
127: htp.bold('Debug process was aborted by the user.' || htf.paragraph);
128: elsif (stopflag = DEBUG_CARTX_SUSPEND) then

Line 125: htp.headclose;

121: htp.bold('Error in getting proper debug information.' || htf.paragraph);
122: htp.print('Please recompile the procedure and try again.');
123: elsif (stopflag = DEBUG_CARTX_ABORT) then
124: htp.title('Debug process aborted by the user');
125: htp.headclose;
126: htp.bodyopen;
127: htp.bold('Debug process was aborted by the user.' || htf.paragraph);
128: elsif (stopflag = DEBUG_CARTX_SUSPEND) then
129: htp.title('Debug process suspeneded');

Line 126: htp.bodyopen;

122: htp.print('Please recompile the procedure and try again.');
123: elsif (stopflag = DEBUG_CARTX_ABORT) then
124: htp.title('Debug process aborted by the user');
125: htp.headclose;
126: htp.bodyopen;
127: htp.bold('Debug process was aborted by the user.' || htf.paragraph);
128: elsif (stopflag = DEBUG_CARTX_SUSPEND) then
129: htp.title('Debug process suspeneded');
130: htp.headclose;

Line 127: htp.bold('Debug process was aborted by the user.' || htf.paragraph);

123: elsif (stopflag = DEBUG_CARTX_ABORT) then
124: htp.title('Debug process aborted by the user');
125: htp.headclose;
126: htp.bodyopen;
127: htp.bold('Debug process was aborted by the user.' || htf.paragraph);
128: elsif (stopflag = DEBUG_CARTX_SUSPEND) then
129: htp.title('Debug process suspeneded');
130: htp.headclose;
131: htp.bodyopen;

Line 129: htp.title('Debug process suspeneded');

125: htp.headclose;
126: htp.bodyopen;
127: htp.bold('Debug process was aborted by the user.' || htf.paragraph);
128: elsif (stopflag = DEBUG_CARTX_SUSPEND) then
129: htp.title('Debug process suspeneded');
130: htp.headclose;
131: htp.bodyopen;
132: htp.bold('Debug process was suspended abruptly.' || htf.paragraph);
133: elsif (stopflag = DEBUG_CARTX_ERR_INIT) then

Line 130: htp.headclose;

126: htp.bodyopen;
127: htp.bold('Debug process was aborted by the user.' || htf.paragraph);
128: elsif (stopflag = DEBUG_CARTX_SUSPEND) then
129: htp.title('Debug process suspeneded');
130: htp.headclose;
131: htp.bodyopen;
132: htp.bold('Debug process was suspended abruptly.' || htf.paragraph);
133: elsif (stopflag = DEBUG_CARTX_ERR_INIT) then
134: htp.title('Cartridge Debug Error');

Line 131: htp.bodyopen;

127: htp.bold('Debug process was aborted by the user.' || htf.paragraph);
128: elsif (stopflag = DEBUG_CARTX_SUSPEND) then
129: htp.title('Debug process suspeneded');
130: htp.headclose;
131: htp.bodyopen;
132: htp.bold('Debug process was suspended abruptly.' || htf.paragraph);
133: elsif (stopflag = DEBUG_CARTX_ERR_INIT) then
134: htp.title('Cartridge Debug Error');
135: htp.headclose;

Line 132: htp.bold('Debug process was suspended abruptly.' || htf.paragraph);

128: elsif (stopflag = DEBUG_CARTX_SUSPEND) then
129: htp.title('Debug process suspeneded');
130: htp.headclose;
131: htp.bodyopen;
132: htp.bold('Debug process was suspended abruptly.' || htf.paragraph);
133: elsif (stopflag = DEBUG_CARTX_ERR_INIT) then
134: htp.title('Cartridge Debug Error');
135: htp.headclose;
136: htp.bodyopen;

Line 134: htp.title('Cartridge Debug Error');

130: htp.headclose;
131: htp.bodyopen;
132: htp.bold('Debug process was suspended abruptly.' || htf.paragraph);
133: elsif (stopflag = DEBUG_CARTX_ERR_INIT) then
134: htp.title('Cartridge Debug Error');
135: htp.headclose;
136: htp.bodyopen;
137: htp.bold('An error occurred while initilizing the CGI environment.'
138: || htf.paragraph);

Line 135: htp.headclose;

131: htp.bodyopen;
132: htp.bold('Debug process was suspended abruptly.' || htf.paragraph);
133: elsif (stopflag = DEBUG_CARTX_ERR_INIT) then
134: htp.title('Cartridge Debug Error');
135: htp.headclose;
136: htp.bodyopen;
137: htp.bold('An error occurred while initilizing the CGI environment.'
138: || htf.paragraph);
139: elsif (stopflag = DEBUG_CARTX_ERR_SNDRES) then

Line 136: htp.bodyopen;

132: htp.bold('Debug process was suspended abruptly.' || htf.paragraph);
133: elsif (stopflag = DEBUG_CARTX_ERR_INIT) then
134: htp.title('Cartridge Debug Error');
135: htp.headclose;
136: htp.bodyopen;
137: htp.bold('An error occurred while initilizing the CGI environment.'
138: || htf.paragraph);
139: elsif (stopflag = DEBUG_CARTX_ERR_SNDRES) then
140: htp.title('Cartridge Debug Error');

Line 137: htp.bold('An error occurred while initilizing the CGI environment.'

133: elsif (stopflag = DEBUG_CARTX_ERR_INIT) then
134: htp.title('Cartridge Debug Error');
135: htp.headclose;
136: htp.bodyopen;
137: htp.bold('An error occurred while initilizing the CGI environment.'
138: || htf.paragraph);
139: elsif (stopflag = DEBUG_CARTX_ERR_SNDRES) then
140: htp.title('Cartridge Debug Error');
141: htp.headclose;

Line 140: htp.title('Cartridge Debug Error');

136: htp.bodyopen;
137: htp.bold('An error occurred while initilizing the CGI environment.'
138: || htf.paragraph);
139: elsif (stopflag = DEBUG_CARTX_ERR_SNDRES) then
140: htp.title('Cartridge Debug Error');
141: htp.headclose;
142: htp.bodyopen;
143: htp.bold('An error occurred while accessing the result.'
144: || htf.paragraph);

Line 141: htp.headclose;

137: htp.bold('An error occurred while initilizing the CGI environment.'
138: || htf.paragraph);
139: elsif (stopflag = DEBUG_CARTX_ERR_SNDRES) then
140: htp.title('Cartridge Debug Error');
141: htp.headclose;
142: htp.bodyopen;
143: htp.bold('An error occurred while accessing the result.'
144: || htf.paragraph);
145: elsif (stopflag = DEBUG_CARTX_ERR_RDSRC) then

Line 142: htp.bodyopen;

138: || htf.paragraph);
139: elsif (stopflag = DEBUG_CARTX_ERR_SNDRES) then
140: htp.title('Cartridge Debug Error');
141: htp.headclose;
142: htp.bodyopen;
143: htp.bold('An error occurred while accessing the result.'
144: || htf.paragraph);
145: elsif (stopflag = DEBUG_CARTX_ERR_RDSRC) then
146: htp.title('Cartridge Debug Error');

Line 143: htp.bold('An error occurred while accessing the result.'

139: elsif (stopflag = DEBUG_CARTX_ERR_SNDRES) then
140: htp.title('Cartridge Debug Error');
141: htp.headclose;
142: htp.bodyopen;
143: htp.bold('An error occurred while accessing the result.'
144: || htf.paragraph);
145: elsif (stopflag = DEBUG_CARTX_ERR_RDSRC) then
146: htp.title('Cartridge Debug Error');
147: htp.headclose;

Line 146: htp.title('Cartridge Debug Error');

142: htp.bodyopen;
143: htp.bold('An error occurred while accessing the result.'
144: || htf.paragraph);
145: elsif (stopflag = DEBUG_CARTX_ERR_RDSRC) then
146: htp.title('Cartridge Debug Error');
147: htp.headclose;
148: htp.bodyopen;
149: htp.bold('An error occurred while getting the command information.'
150: || htf.paragraph);

Line 147: htp.headclose;

143: htp.bold('An error occurred while accessing the result.'
144: || htf.paragraph);
145: elsif (stopflag = DEBUG_CARTX_ERR_RDSRC) then
146: htp.title('Cartridge Debug Error');
147: htp.headclose;
148: htp.bodyopen;
149: htp.bold('An error occurred while getting the command information.'
150: || htf.paragraph);
151: elsif (stopflag = DEBUG_CARTX_ERR) then

Line 148: htp.bodyopen;

144: || htf.paragraph);
145: elsif (stopflag = DEBUG_CARTX_ERR_RDSRC) then
146: htp.title('Cartridge Debug Error');
147: htp.headclose;
148: htp.bodyopen;
149: htp.bold('An error occurred while getting the command information.'
150: || htf.paragraph);
151: elsif (stopflag = DEBUG_CARTX_ERR) then
152: htp.title('Cartridge Debug Error');

Line 149: htp.bold('An error occurred while getting the command information.'

145: elsif (stopflag = DEBUG_CARTX_ERR_RDSRC) then
146: htp.title('Cartridge Debug Error');
147: htp.headclose;
148: htp.bodyopen;
149: htp.bold('An error occurred while getting the command information.'
150: || htf.paragraph);
151: elsif (stopflag = DEBUG_CARTX_ERR) then
152: htp.title('Cartridge Debug Error');
153: htp.headclose;

Line 152: htp.title('Cartridge Debug Error');

148: htp.bodyopen;
149: htp.bold('An error occurred while getting the command information.'
150: || htf.paragraph);
151: elsif (stopflag = DEBUG_CARTX_ERR) then
152: htp.title('Cartridge Debug Error');
153: htp.headclose;
154: htp.bodyopen;
155: htp.bold('A generic error occurred.' || htf.paragraph);
156: htp.print('Please start the debug session afresh.');

Line 153: htp.headclose;

149: htp.bold('An error occurred while getting the command information.'
150: || htf.paragraph);
151: elsif (stopflag = DEBUG_CARTX_ERR) then
152: htp.title('Cartridge Debug Error');
153: htp.headclose;
154: htp.bodyopen;
155: htp.bold('A generic error occurred.' || htf.paragraph);
156: htp.print('Please start the debug session afresh.');
157: elsif (stopflag = DEBUG_CARTX_ERR_PROC_EXISTS) then

Line 154: htp.bodyopen;

150: || htf.paragraph);
151: elsif (stopflag = DEBUG_CARTX_ERR) then
152: htp.title('Cartridge Debug Error');
153: htp.headclose;
154: htp.bodyopen;
155: htp.bold('A generic error occurred.' || htf.paragraph);
156: htp.print('Please start the debug session afresh.');
157: elsif (stopflag = DEBUG_CARTX_ERR_PROC_EXISTS) then
158: htp.title('Cartridge Debug Error');

Line 155: htp.bold('A generic error occurred.' || htf.paragraph);

151: elsif (stopflag = DEBUG_CARTX_ERR) then
152: htp.title('Cartridge Debug Error');
153: htp.headclose;
154: htp.bodyopen;
155: htp.bold('A generic error occurred.' || htf.paragraph);
156: htp.print('Please start the debug session afresh.');
157: elsif (stopflag = DEBUG_CARTX_ERR_PROC_EXISTS) then
158: htp.title('Cartridge Debug Error');
159: htp.headclose;

Line 156: htp.print('Please start the debug session afresh.');

152: htp.title('Cartridge Debug Error');
153: htp.headclose;
154: htp.bodyopen;
155: htp.bold('A generic error occurred.' || htf.paragraph);
156: htp.print('Please start the debug session afresh.');
157: elsif (stopflag = DEBUG_CARTX_ERR_PROC_EXISTS) then
158: htp.title('Cartridge Debug Error');
159: htp.headclose;
160: htp.bodyopen;

Line 158: htp.title('Cartridge Debug Error');

154: htp.bodyopen;
155: htp.bold('A generic error occurred.' || htf.paragraph);
156: htp.print('Please start the debug session afresh.');
157: elsif (stopflag = DEBUG_CARTX_ERR_PROC_EXISTS) then
158: htp.title('Cartridge Debug Error');
159: htp.headclose;
160: htp.bodyopen;
161: htp.bold('Could not create a stub with name DE_' || SessID
162: || htf.paragraph);

Line 159: htp.headclose;

155: htp.bold('A generic error occurred.' || htf.paragraph);
156: htp.print('Please start the debug session afresh.');
157: elsif (stopflag = DEBUG_CARTX_ERR_PROC_EXISTS) then
158: htp.title('Cartridge Debug Error');
159: htp.headclose;
160: htp.bodyopen;
161: htp.bold('Could not create a stub with name DE_' || SessID
162: || htf.paragraph);
163: htp.print('Please rename the existing procedure or'

Line 160: htp.bodyopen;

156: htp.print('Please start the debug session afresh.');
157: elsif (stopflag = DEBUG_CARTX_ERR_PROC_EXISTS) then
158: htp.title('Cartridge Debug Error');
159: htp.headclose;
160: htp.bodyopen;
161: htp.bold('Could not create a stub with name DE_' || SessID
162: || htf.paragraph);
163: htp.print('Please rename the existing procedure or'
164: || ' start the debug session afresh.');

Line 161: htp.bold('Could not create a stub with name DE_' || SessID

157: elsif (stopflag = DEBUG_CARTX_ERR_PROC_EXISTS) then
158: htp.title('Cartridge Debug Error');
159: htp.headclose;
160: htp.bodyopen;
161: htp.bold('Could not create a stub with name DE_' || SessID
162: || htf.paragraph);
163: htp.print('Please rename the existing procedure or'
164: || ' start the debug session afresh.');
165: end if;

Line 163: htp.print('Please rename the existing procedure or'

159: htp.headclose;
160: htp.bodyopen;
161: htp.bold('Could not create a stub with name DE_' || SessID
162: || htf.paragraph);
163: htp.print('Please rename the existing procedure or'
164: || ' start the debug session afresh.');
165: end if;
166:
167: htp.print(htf.paragraph);

Line 167: htp.print(htf.paragraph);

163: htp.print('Please rename the existing procedure or'
164: || ' start the debug session afresh.');
165: end if;
166:
167: htp.print(htf.paragraph);
168: htp.bodyclose;
169: htp.htmlclose;
170: --raise "PDE_QUIT_DEBUG_CARTX";
171: end;

Line 168: htp.bodyclose;

164: || ' start the debug session afresh.');
165: end if;
166:
167: htp.print(htf.paragraph);
168: htp.bodyclose;
169: htp.htmlclose;
170: --raise "PDE_QUIT_DEBUG_CARTX";
171: end;
172:

Line 169: htp.htmlclose;

165: end if;
166:
167: htp.print(htf.paragraph);
168: htp.bodyclose;
169: htp.htmlclose;
170: --raise "PDE_QUIT_DEBUG_CARTX";
171: end;
172:
173:

Line 299: htp.htmlopen;

295: BEGIN
296: getInternalDebugSession(SessionId);
297: SessionId := substr (SessionId, 10);
298:
299: htp.htmlopen;
300: htp.headopen;
301: htp.title('Get Debug Session ID');
302: htp.headclose;
303: htp.bodyopen;

Line 300: htp.headopen;

296: getInternalDebugSession(SessionId);
297: SessionId := substr (SessionId, 10);
298:
299: htp.htmlopen;
300: htp.headopen;
301: htp.title('Get Debug Session ID');
302: htp.headclose;
303: htp.bodyopen;
304: htp.bold('Debug Session ID: ' || SessionId || htf.paragraph);

Line 301: htp.title('Get Debug Session ID');

297: SessionId := substr (SessionId, 10);
298:
299: htp.htmlopen;
300: htp.headopen;
301: htp.title('Get Debug Session ID');
302: htp.headclose;
303: htp.bodyopen;
304: htp.bold('Debug Session ID: ' || SessionId || htf.paragraph);
305: htp.bold ('User Name: ' || User || htf.paragraph);

Line 302: htp.headclose;

298:
299: htp.htmlopen;
300: htp.headopen;
301: htp.title('Get Debug Session ID');
302: htp.headclose;
303: htp.bodyopen;
304: htp.bold('Debug Session ID: ' || SessionId || htf.paragraph);
305: htp.bold ('User Name: ' || User || htf.paragraph);
306: htp.print('Please use the above session id in the Procedure Builder' ||

Line 303: htp.bodyopen;

299: htp.htmlopen;
300: htp.headopen;
301: htp.title('Get Debug Session ID');
302: htp.headclose;
303: htp.bodyopen;
304: htp.bold('Debug Session ID: ' || SessionId || htf.paragraph);
305: htp.bold ('User Name: ' || User || htf.paragraph);
306: htp.print('Please use the above session id in the Procedure Builder' ||
307: ' to debug cartridge calls.');

Line 304: htp.bold('Debug Session ID: ' || SessionId || htf.paragraph);

300: htp.headopen;
301: htp.title('Get Debug Session ID');
302: htp.headclose;
303: htp.bodyopen;
304: htp.bold('Debug Session ID: ' || SessionId || htf.paragraph);
305: htp.bold ('User Name: ' || User || htf.paragraph);
306: htp.print('Please use the above session id in the Procedure Builder' ||
307: ' to debug cartridge calls.');
308: htp.print(htf.paragraph);

Line 305: htp.bold ('User Name: ' || User || htf.paragraph);

301: htp.title('Get Debug Session ID');
302: htp.headclose;
303: htp.bodyopen;
304: htp.bold('Debug Session ID: ' || SessionId || htf.paragraph);
305: htp.bold ('User Name: ' || User || htf.paragraph);
306: htp.print('Please use the above session id in the Procedure Builder' ||
307: ' to debug cartridge calls.');
308: htp.print(htf.paragraph);
309:

Line 306: htp.print('Please use the above session id in the Procedure Builder' ||

302: htp.headclose;
303: htp.bodyopen;
304: htp.bold('Debug Session ID: ' || SessionId || htf.paragraph);
305: htp.bold ('User Name: ' || User || htf.paragraph);
306: htp.print('Please use the above session id in the Procedure Builder' ||
307: ' to debug cartridge calls.');
308: htp.print(htf.paragraph);
309:
310: htp.bodyclose;

Line 308: htp.print(htf.paragraph);

304: htp.bold('Debug Session ID: ' || SessionId || htf.paragraph);
305: htp.bold ('User Name: ' || User || htf.paragraph);
306: htp.print('Please use the above session id in the Procedure Builder' ||
307: ' to debug cartridge calls.');
308: htp.print(htf.paragraph);
309:
310: htp.bodyclose;
311: htp.htmlclose;
312:

Line 310: htp.bodyclose;

306: htp.print('Please use the above session id in the Procedure Builder' ||
307: ' to debug cartridge calls.');
308: htp.print(htf.paragraph);
309:
310: htp.bodyclose;
311: htp.htmlclose;
312:
313: end;
314:

Line 311: htp.htmlclose;

307: ' to debug cartridge calls.');
308: htp.print(htf.paragraph);
309:
310: htp.bodyclose;
311: htp.htmlclose;
312:
313: end;
314:
315: PROCEDURE cleanupDebugsession(SessionId varchar2) IS

Line 322: htp.htmlopen;

318: BEGIN
319: SessID := SessionId;
320: fmtSessionID(SessID);
321:
322: htp.htmlopen;
323: htp.headopen;
324: htp.title('Cleanup Debug Session');
325: htp.headclose;
326: htp.bodyopen;

Line 323: htp.headopen;

319: SessID := SessionId;
320: fmtSessionID(SessID);
321:
322: htp.htmlopen;
323: htp.headopen;
324: htp.title('Cleanup Debug Session');
325: htp.headclose;
326: htp.bodyopen;
327:

Line 324: htp.title('Cleanup Debug Session');

320: fmtSessionID(SessID);
321:
322: htp.htmlopen;
323: htp.headopen;
324: htp.title('Cleanup Debug Session');
325: htp.headclose;
326: htp.bodyopen;
327:
328: --Send a 'bye' message to all waiting processes

Line 325: htp.headclose;

321:
322: htp.htmlopen;
323: htp.headopen;
324: htp.title('Cleanup Debug Session');
325: htp.headclose;
326: htp.bodyopen;
327:
328: --Send a 'bye' message to all waiting processes
329: sendAck(SessId, DEBUG_CARTX_QUIT, status);

Line 326: htp.bodyopen;

322: htp.htmlopen;
323: htp.headopen;
324: htp.title('Cleanup Debug Session');
325: htp.headclose;
326: htp.bodyopen;
327:
328: --Send a 'bye' message to all waiting processes
329: sendAck(SessId, DEBUG_CARTX_QUIT, status);
330: sendAck(SessId || 'Res', DEBUG_CARTX_QUIT, status);

Line 339: htp.print('SessionID ' || SessionId || ' has been successfully reset.');

335: status := sys.dbms_pipe.remove_pipe(SessID);
336: status := sys.dbms_pipe.remove_pipe(SessID || 'Res');
337:
338: --Now that we have successfully removed the pipes send a message.
339: htp.print('SessionID ' || SessionId || ' has been successfully reset.');
340: htp.bodyclose;
341: htp.htmlclose;
342:
343: exception

Line 340: htp.bodyclose;

336: status := sys.dbms_pipe.remove_pipe(SessID || 'Res');
337:
338: --Now that we have successfully removed the pipes send a message.
339: htp.print('SessionID ' || SessionId || ' has been successfully reset.');
340: htp.bodyclose;
341: htp.htmlclose;
342:
343: exception
344: when others then

Line 341: htp.htmlclose;

337:
338: --Now that we have successfully removed the pipes send a message.
339: htp.print('SessionID ' || SessionId || ' has been successfully reset.');
340: htp.bodyclose;
341: htp.htmlclose;
342:
343: exception
344: when others then
345: --Just handle any exception

Line 346: htp.print('SessionID ' || SessionId || ' could not be reset.');

342:
343: exception
344: when others then
345: --Just handle any exception
346: htp.print('SessionID ' || SessionId || ' could not be reset.');
347: htp.print(htf.paragraph);
348: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
349: htp.bodyclose;
350: htp.htmlclose;

Line 347: htp.print(htf.paragraph);

343: exception
344: when others then
345: --Just handle any exception
346: htp.print('SessionID ' || SessionId || ' could not be reset.');
347: htp.print(htf.paragraph);
348: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
349: htp.bodyclose;
350: htp.htmlclose;
351: end;

Line 348: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);

344: when others then
345: --Just handle any exception
346: htp.print('SessionID ' || SessionId || ' could not be reset.');
347: htp.print(htf.paragraph);
348: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
349: htp.bodyclose;
350: htp.htmlclose;
351: end;
352:

Line 349: htp.bodyclose;

345: --Just handle any exception
346: htp.print('SessionID ' || SessionId || ' could not be reset.');
347: htp.print(htf.paragraph);
348: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
349: htp.bodyclose;
350: htp.htmlclose;
351: end;
352:
353: PROCEDURE resetDebugsession IS

Line 350: htp.htmlclose;

346: htp.print('SessionID ' || SessionId || ' could not be reset.');
347: htp.print(htf.paragraph);
348: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
349: htp.bodyclose;
350: htp.htmlclose;
351: end;
352:
353: PROCEDURE resetDebugsession IS
354: SessionId varchar2(50);

Line 357: htp.htmlopen;

353: PROCEDURE resetDebugsession IS
354: SessionId varchar2(50);
355: status integer;
356: BEGIN
357: htp.htmlopen;
358: htp.headopen;
359: htp.title('Reset Debug Session');
360: htp.headclose;
361: htp.bodyopen;

Line 358: htp.headopen;

354: SessionId varchar2(50);
355: status integer;
356: BEGIN
357: htp.htmlopen;
358: htp.headopen;
359: htp.title('Reset Debug Session');
360: htp.headclose;
361: htp.bodyopen;
362:

Line 359: htp.title('Reset Debug Session');

355: status integer;
356: BEGIN
357: htp.htmlopen;
358: htp.headopen;
359: htp.title('Reset Debug Session');
360: htp.headclose;
361: htp.bodyopen;
362:
363: getInternalDebugSession(SessionId);

Line 360: htp.headclose;

356: BEGIN
357: htp.htmlopen;
358: htp.headopen;
359: htp.title('Reset Debug Session');
360: htp.headclose;
361: htp.bodyopen;
362:
363: getInternalDebugSession(SessionId);
364: --Send a 'bye' message to all waiting processes

Line 361: htp.bodyopen;

357: htp.htmlopen;
358: htp.headopen;
359: htp.title('Reset Debug Session');
360: htp.headclose;
361: htp.bodyopen;
362:
363: getInternalDebugSession(SessionId);
364: --Send a 'bye' message to all waiting processes
365: sendAck(SessionId, DEBUG_CARTX_QUIT, status);

Line 374: htp.print('SessionID: ' || substr(SessionId, 10) ||

370: status := sys.dbms_pipe.remove_pipe(SessionID);
371: status := sys.dbms_pipe.remove_pipe(SessionID || 'Res');
372:
373: --Now that we have successfully removed the pipes send a message.
374: htp.print('SessionID: ' || substr(SessionId, 10) ||
375: ' is successfully reset.');
376: htp.print(htf.paragraph);
377: htp.bodyclose;
378: htp.htmlclose;

Line 376: htp.print(htf.paragraph);

372:
373: --Now that we have successfully removed the pipes send a message.
374: htp.print('SessionID: ' || substr(SessionId, 10) ||
375: ' is successfully reset.');
376: htp.print(htf.paragraph);
377: htp.bodyclose;
378: htp.htmlclose;
379:
380: exception

Line 377: htp.bodyclose;

373: --Now that we have successfully removed the pipes send a message.
374: htp.print('SessionID: ' || substr(SessionId, 10) ||
375: ' is successfully reset.');
376: htp.print(htf.paragraph);
377: htp.bodyclose;
378: htp.htmlclose;
379:
380: exception
381: when others then

Line 378: htp.htmlclose;

374: htp.print('SessionID: ' || substr(SessionId, 10) ||
375: ' is successfully reset.');
376: htp.print(htf.paragraph);
377: htp.bodyclose;
378: htp.htmlclose;
379:
380: exception
381: when others then
382: htp.print('SessionID: ' || substr(SessionId, 10) ||

Line 382: htp.print('SessionID: ' || substr(SessionId, 10) ||

378: htp.htmlclose;
379:
380: exception
381: when others then
382: htp.print('SessionID: ' || substr(SessionId, 10) ||
383: ' could not be reset.');
384: htp.print(htf.paragraph);
385: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
386: htp.bodyclose;

Line 384: htp.print(htf.paragraph);

380: exception
381: when others then
382: htp.print('SessionID: ' || substr(SessionId, 10) ||
383: ' could not be reset.');
384: htp.print(htf.paragraph);
385: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
386: htp.bodyclose;
387: htp.htmlclose;
388: end;

Line 385: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);

381: when others then
382: htp.print('SessionID: ' || substr(SessionId, 10) ||
383: ' could not be reset.');
384: htp.print(htf.paragraph);
385: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
386: htp.bodyclose;
387: htp.htmlclose;
388: end;
389:

Line 386: htp.bodyclose;

382: htp.print('SessionID: ' || substr(SessionId, 10) ||
383: ' could not be reset.');
384: htp.print(htf.paragraph);
385: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
386: htp.bodyclose;
387: htp.htmlclose;
388: end;
389:
390:

Line 387: htp.htmlclose;

383: ' could not be reset.');
384: htp.print(htf.paragraph);
385: htp.print(to_char(SQLCODE) || ': ' || SQLERRM);
386: htp.bodyclose;
387: htp.htmlclose;
388: end;
389:
390:
391: PROCEDURE tgt_init_cgi_env(num_params in number,

Line 434: htp.htmlopen;

430: cleanup_pipes(PipeName);
431: raise PDE_QUIT_DEBUG_CARTX;
432: end if;
433: else
434: htp.htmlopen;
435: htp.headopen;
436: htp.print('An error occurred. May be insufficient privileges.');
437: htp.print(htf.paragraph);
438: htp.bodyclose;

Line 435: htp.headopen;

431: raise PDE_QUIT_DEBUG_CARTX;
432: end if;
433: else
434: htp.htmlopen;
435: htp.headopen;
436: htp.print('An error occurred. May be insufficient privileges.');
437: htp.print(htf.paragraph);
438: htp.bodyclose;
439: htp.htmlclose;

Line 436: htp.print('An error occurred. May be insufficient privileges.');

432: end if;
433: else
434: htp.htmlopen;
435: htp.headopen;
436: htp.print('An error occurred. May be insufficient privileges.');
437: htp.print(htf.paragraph);
438: htp.bodyclose;
439: htp.htmlclose;
440: cleanup_pipes(PipeName);

Line 437: htp.print(htf.paragraph);

433: else
434: htp.htmlopen;
435: htp.headopen;
436: htp.print('An error occurred. May be insufficient privileges.');
437: htp.print(htf.paragraph);
438: htp.bodyclose;
439: htp.htmlclose;
440: cleanup_pipes(PipeName);
441: raise PDE_CTX_TGT;

Line 438: htp.bodyclose;

434: htp.htmlopen;
435: htp.headopen;
436: htp.print('An error occurred. May be insufficient privileges.');
437: htp.print(htf.paragraph);
438: htp.bodyclose;
439: htp.htmlclose;
440: cleanup_pipes(PipeName);
441: raise PDE_CTX_TGT;
442: end if;

Line 439: htp.htmlclose;

435: htp.headopen;
436: htp.print('An error occurred. May be insufficient privileges.');
437: htp.print(htf.paragraph);
438: htp.bodyclose;
439: htp.htmlclose;
440: cleanup_pipes(PipeName);
441: raise PDE_CTX_TGT;
442: end if;
443:

Line 538: htp.htmlopen;

534: end if;
535:
536: sendAck(pipename, DEBUG_CARTX_SUCCESS, status);
537: else
538: htp.htmlopen;
539: htp.headopen;
540: htp.print('An error occurred while recieving the results. '
541: || SQLERRM);
542: htp.print(htf.paragraph);

Line 539: htp.headopen;

535:
536: sendAck(pipename, DEBUG_CARTX_SUCCESS, status);
537: else
538: htp.htmlopen;
539: htp.headopen;
540: htp.print('An error occurred while recieving the results. '
541: || SQLERRM);
542: htp.print(htf.paragraph);
543: htp.bodyclose;

Line 540: htp.print('An error occurred while recieving the results. '

536: sendAck(pipename, DEBUG_CARTX_SUCCESS, status);
537: else
538: htp.htmlopen;
539: htp.headopen;
540: htp.print('An error occurred while recieving the results. '
541: || SQLERRM);
542: htp.print(htf.paragraph);
543: htp.bodyclose;
544: htp.htmlclose;

Line 542: htp.print(htf.paragraph);

538: htp.htmlopen;
539: htp.headopen;
540: htp.print('An error occurred while recieving the results. '
541: || SQLERRM);
542: htp.print(htf.paragraph);
543: htp.bodyclose;
544: htp.htmlclose;
545: cleanup_pipes(pipeName);
546: raise PDE_CTX_TGT;

Line 543: htp.bodyclose;

539: htp.headopen;
540: htp.print('An error occurred while recieving the results. '
541: || SQLERRM);
542: htp.print(htf.paragraph);
543: htp.bodyclose;
544: htp.htmlclose;
545: cleanup_pipes(pipeName);
546: raise PDE_CTX_TGT;
547: end if;

Line 544: htp.htmlclose;

540: htp.print('An error occurred while recieving the results. '
541: || SQLERRM);
542: htp.print(htf.paragraph);
543: htp.bodyclose;
544: htp.htmlclose;
545: cleanup_pipes(pipeName);
546: raise PDE_CTX_TGT;
547: end if;
548:

Line 560: --Now receive the htp page data.

556: raise PDE_QUIT_DEBUG_CARTX;
557: end if;
558:
559: msg := '';
560: --Now receive the htp page data.
561: loop
562: status := sys.dbms_pipe.Receive_Message(resPipename);
563: if (status = 0) then
564: msgType := sys.dbms_pipe.Next_Item_Type;

Line 586: htp.prn(msg);

582: FOR counter IN 1 .. numLines LOOP
583: msgType := sys.dbms_pipe.Next_Item_Type;
584: if (msgType = 9) then
585: sys.dbms_pipe.unpack_message(msg);
586: htp.prn(msg);
587: elsif(msgType = 6) then
588: sys.dbms_pipe.unpack_message(numMsg);
589: htp.prn(numMsg);
590: else

Line 589: htp.prn(numMsg);

585: sys.dbms_pipe.unpack_message(msg);
586: htp.prn(msg);
587: elsif(msgType = 6) then
588: sys.dbms_pipe.unpack_message(numMsg);
589: htp.prn(numMsg);
590: else
591: --We are into some weird msgType. Just get out.
592: exit;
593: end if;

Line 672: Lines htp.htbuf_arr;

668: PROCEDURE dbg_send_results(SessID varchar2, status IN OUT integer,
669: filename varchar2, mimetype number,
670: err_info IN varchar2) IS
671: resPipeName varchar2(30);
672: Lines htp.htbuf_arr;
673: numLines integer;
674: sDownloadFile varchar2(256);
675: nCompress number;
676: res varchar2(256);

Line 696: htp.htmlopen;

692: --and the rest will be taken care of.
693:
694: if (status != 0) then
695: -- insertmessage(err_info);
696: htp.htmlopen;
697: htp.headopen;
698: htp.title('Error: ' || to_char(status));
699: htp.headclose;
700: htp.bodyopen;

Line 697: htp.headopen;

693:
694: if (status != 0) then
695: -- insertmessage(err_info);
696: htp.htmlopen;
697: htp.headopen;
698: htp.title('Error: ' || to_char(status));
699: htp.headclose;
700: htp.bodyopen;
701: if (err_info IS NULL) then

Line 698: htp.title('Error: ' || to_char(status));

694: if (status != 0) then
695: -- insertmessage(err_info);
696: htp.htmlopen;
697: htp.headopen;
698: htp.title('Error: ' || to_char(status));
699: htp.headclose;
700: htp.bodyopen;
701: if (err_info IS NULL) then
702: htp.print('Error occurred');

Line 699: htp.headclose;

695: -- insertmessage(err_info);
696: htp.htmlopen;
697: htp.headopen;
698: htp.title('Error: ' || to_char(status));
699: htp.headclose;
700: htp.bodyopen;
701: if (err_info IS NULL) then
702: htp.print('Error occurred');
703: else

Line 700: htp.bodyopen;

696: htp.htmlopen;
697: htp.headopen;
698: htp.title('Error: ' || to_char(status));
699: htp.headclose;
700: htp.bodyopen;
701: if (err_info IS NULL) then
702: htp.print('Error occurred');
703: else
704: htp.print(err_info);

Line 702: htp.print('Error occurred');

698: htp.title('Error: ' || to_char(status));
699: htp.headclose;
700: htp.bodyopen;
701: if (err_info IS NULL) then
702: htp.print('Error occurred');
703: else
704: htp.print(err_info);
705: end if;
706: htp.print(htf.paragraph);

Line 704: htp.print(err_info);

700: htp.bodyopen;
701: if (err_info IS NULL) then
702: htp.print('Error occurred');
703: else
704: htp.print(err_info);
705: end if;
706: htp.print(htf.paragraph);
707: htp.bodyclose;
708: htp.htmlclose;

Line 706: htp.print(htf.paragraph);

702: htp.print('Error occurred');
703: else
704: htp.print(err_info);
705: end if;
706: htp.print(htf.paragraph);
707: htp.bodyclose;
708: htp.htmlclose;
709: end if;
710:

Line 707: htp.bodyclose;

703: else
704: htp.print(err_info);
705: end if;
706: htp.print(htf.paragraph);
707: htp.bodyclose;
708: htp.htmlclose;
709: end if;
710:
711: if (filename IS NULL) then

Line 708: htp.htmlclose;

704: htp.print(err_info);
705: end if;
706: htp.print(htf.paragraph);
707: htp.bodyclose;
708: htp.htmlclose;
709: end if;
710:
711: if (filename IS NULL) then
712: sDownloadFile := 'CARTX_NULL';

Line 733: --Now send the htp page.

729: cleanup_pipes(SessionID);
730: raise PDE_QUIT_DEBUG_CARTX;
731: end if;
732:
733: --Now send the htp page.
734: loop
735: numLines := 10;
736: owa.get_page(Lines, numLines);
737: