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.ZPB_EXCP_PVT dependencies on DBMS_OUTPUT

Line 121: --dbms_output.put_line('call sc.exception.chk(' || '''' || l_task_id || ''' ''' || l_user_id || ''')' );

117: l_count := l_count + 1;
118: end loop;
119:
120: --call AW exception program
121: --dbms_output.put_line('call sc.exception.chk(' || '''' || l_task_id || ''' ''' || l_user_id || ''')' );
122:
123: --Use for debug. Allows for use of show statements in OLAP DML. Be sure to comment out if statement
124: --below
125: --ZPB_AW.EXECUTE( 'call sc.exception.chk(' || '''' || l_task_id || ''' ''' || l_user_id || ''')' );

Line 128: --dbms_output.put_line('Exception count : ' || l_excp_ct);

124: --below
125: --ZPB_AW.EXECUTE( 'call sc.exception.chk(' || '''' || l_task_id || ''' ''' || l_user_id || ''')' );
126: l_excp_ct := ZPB_AW.INTERP( 'shw sc.exception.chk(' || '''' || l_task_id || ''' ''' || l_user_id || ''')' );
127:
128: --dbms_output.put_line('Exception count : ' || l_excp_ct);
129:
130: -- add in owner and approver names (need to update who columns)
131: if l_excp_ct<>'NA' and l_excp_ct<>' ' then
132:

Line 214: dbms_output.put_line('start run exception test');

210: msg_data varchar2(32766);
211:
212: begin
213:
214: dbms_output.put_line('start run exception test');
215: run_exception(1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data, 219, 1005156);
216: dbms_output.put_line(return_status);
217: dbms_output.put_line(msg_count);
218: --dbms_output.put_line(msg_data);

Line 216: dbms_output.put_line(return_status);

212: begin
213:
214: dbms_output.put_line('start run exception test');
215: run_exception(1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data, 219, 1005156);
216: dbms_output.put_line(return_status);
217: dbms_output.put_line(msg_count);
218: --dbms_output.put_line(msg_data);
219: dbms_output.put_line('run exception test complete');
220:

Line 217: dbms_output.put_line(msg_count);

213:
214: dbms_output.put_line('start run exception test');
215: run_exception(1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data, 219, 1005156);
216: dbms_output.put_line(return_status);
217: dbms_output.put_line(msg_count);
218: --dbms_output.put_line(msg_data);
219: dbms_output.put_line('run exception test complete');
220:
221: EXCEPTION

Line 218: --dbms_output.put_line(msg_data);

214: dbms_output.put_line('start run exception test');
215: run_exception(1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data, 219, 1005156);
216: dbms_output.put_line(return_status);
217: dbms_output.put_line(msg_count);
218: --dbms_output.put_line(msg_data);
219: dbms_output.put_line('run exception test complete');
220:
221: EXCEPTION
222: WHEN OTHERS THEN

Line 219: dbms_output.put_line('run exception test complete');

215: run_exception(1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data, 219, 1005156);
216: dbms_output.put_line(return_status);
217: dbms_output.put_line(msg_count);
218: --dbms_output.put_line(msg_data);
219: dbms_output.put_line('run exception test complete');
220:
221: EXCEPTION
222: WHEN OTHERS THEN
223: raise;

Line 401: --dbms_output.put_line(l_user_id);

397: l_resp_id := FND_GLOBAL.RESP_ID;
398:
399: --l_user_id := 1005262;
400: --l_resp_id := 57124;
401: --dbms_output.put_line(l_user_id);
402: --dbms_output.put_line(l_resp_id);
403:
404: select responsibility_key into l_resp_key
405: from fnd_responsibility

Line 402: --dbms_output.put_line(l_resp_id);

398:
399: --l_user_id := 1005262;
400: --l_resp_id := 57124;
401: --dbms_output.put_line(l_user_id);
402: --dbms_output.put_line(l_resp_id);
403:
404: select responsibility_key into l_resp_key
405: from fnd_responsibility
406: where responsibility_id = l_resp_id;

Line 409: --dbms_output.put_line(l_task_id);

405: from fnd_responsibility
406: where responsibility_id = l_resp_id;
407:
408: l_task_id := to_char(p_task_id);
409: --dbms_output.put_line(l_task_id);
410:
411: ZPB_LOG.WRITE_STATEMENT(G_PKG_NAME || '.' || l_api_name, 'Finding children for task_id ' || p_task_id || ' and notification_id ' || p_notification_id || '.');
412:
413: for each in task_dfn loop

Line 424: --dbms_output.put_line(l_query);

420: end loop;
421:
422: l_query := l_query_path || '/' || l_query_name;
423:
424: --dbms_output.put_line(l_query);
425:
426: --
427: --Removed the following call, as this should be called on the OLAP connection
428: --ZPB_AW.INITIALIZE_WORKSPACE(1.0, FND_API.G_FALSE, p_validation_level, x_return_status, x_msg_count, x_msg_data, l_user_id, l_resp_key);

Line 449: --dbms_output.put_line('query line count : ' || to_char(l_count));

445: end if;
446: l_count := l_count + 1;
447: end loop;
448:
449: --dbms_output.put_line('query line count : ' || to_char(l_count));
450:
451: --dbms_output.put_line('call sc.exception.exp(' || '''' || p_task_id || ''' ''' || p_notification_id || ''')' );
452: l_child_ct := ZPB_AW.INTERP( 'shw sc.exception.exp(' || '''' || to_char(p_task_id) || ''' ''' || to_char(p_notification_id) || ''')' );
453: --dbms_output.put_line('Child count : ' || l_child_ct);

Line 451: --dbms_output.put_line('call sc.exception.exp(' || '''' || p_task_id || ''' ''' || p_notification_id || ''')' );

447: end loop;
448:
449: --dbms_output.put_line('query line count : ' || to_char(l_count));
450:
451: --dbms_output.put_line('call sc.exception.exp(' || '''' || p_task_id || ''' ''' || p_notification_id || ''')' );
452: l_child_ct := ZPB_AW.INTERP( 'shw sc.exception.exp(' || '''' || to_char(p_task_id) || ''' ''' || to_char(p_notification_id) || ''')' );
453: --dbms_output.put_line('Child count : ' || l_child_ct);
454:
455: ZPB_AW.CLEAN_WORKSPACE(1.0, FND_API.G_FALSE, p_validation_level, x_return_status, x_msg_count, x_msg_data);

Line 453: --dbms_output.put_line('Child count : ' || l_child_ct);

449: --dbms_output.put_line('query line count : ' || to_char(l_count));
450:
451: --dbms_output.put_line('call sc.exception.exp(' || '''' || p_task_id || ''' ''' || p_notification_id || ''')' );
452: l_child_ct := ZPB_AW.INTERP( 'shw sc.exception.exp(' || '''' || to_char(p_task_id) || ''' ''' || to_char(p_notification_id) || ''')' );
453: --dbms_output.put_line('Child count : ' || l_child_ct);
454:
455: ZPB_AW.CLEAN_WORKSPACE(1.0, FND_API.G_FALSE, p_validation_level, x_return_status, x_msg_count, x_msg_data);
456:
457: -- add in owner names (need to update who columns)

Line 528: dbms_output.put_line('start request children test');

524: i number;
525:
526: begin
527:
528: dbms_output.put_line('start request children test');
529: request_children(1.0, FND_API.G_TRUE, FND_API.G_TRUE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data, 10000, 9087);
530: dbms_output.put_line(return_status);
531: dbms_output.put_line(msg_count);
532: --dbms_output.put_line(msg_data);

Line 530: dbms_output.put_line(return_status);

526: begin
527:
528: dbms_output.put_line('start request children test');
529: request_children(1.0, FND_API.G_TRUE, FND_API.G_TRUE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data, 10000, 9087);
530: dbms_output.put_line(return_status);
531: dbms_output.put_line(msg_count);
532: --dbms_output.put_line(msg_data);
533: --i := 1;
534: --select fnd_msg_pub.get(-1) into msg_out from dual;

Line 531: dbms_output.put_line(msg_count);

527:
528: dbms_output.put_line('start request children test');
529: request_children(1.0, FND_API.G_TRUE, FND_API.G_TRUE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data, 10000, 9087);
530: dbms_output.put_line(return_status);
531: dbms_output.put_line(msg_count);
532: --dbms_output.put_line(msg_data);
533: --i := 1;
534: --select fnd_msg_pub.get(-1) into msg_out from dual;
535: --dbms_output.put_line(msg_out);

Line 532: --dbms_output.put_line(msg_data);

528: dbms_output.put_line('start request children test');
529: request_children(1.0, FND_API.G_TRUE, FND_API.G_TRUE, FND_API.G_VALID_LEVEL_FULL, return_status, msg_count, msg_data, 10000, 9087);
530: dbms_output.put_line(return_status);
531: dbms_output.put_line(msg_count);
532: --dbms_output.put_line(msg_data);
533: --i := 1;
534: --select fnd_msg_pub.get(-1) into msg_out from dual;
535: --dbms_output.put_line(msg_out);
536: --while i < msg_count loop

Line 535: --dbms_output.put_line(msg_out);

531: dbms_output.put_line(msg_count);
532: --dbms_output.put_line(msg_data);
533: --i := 1;
534: --select fnd_msg_pub.get(-1) into msg_out from dual;
535: --dbms_output.put_line(msg_out);
536: --while i < msg_count loop
537: -- select fnd_msg_pub.get(-2) into msg_out from dual;
538: -- dbms_output.put_line(msg_out);
539: -- i := i + 1;

Line 538: -- dbms_output.put_line(msg_out);

534: --select fnd_msg_pub.get(-1) into msg_out from dual;
535: --dbms_output.put_line(msg_out);
536: --while i < msg_count loop
537: -- select fnd_msg_pub.get(-2) into msg_out from dual;
538: -- dbms_output.put_line(msg_out);
539: -- i := i + 1;
540: --end loop;
541: dbms_output.put_line('request children test complete');
542:

Line 541: dbms_output.put_line('request children test complete');

537: -- select fnd_msg_pub.get(-2) into msg_out from dual;
538: -- dbms_output.put_line(msg_out);
539: -- i := i + 1;
540: --end loop;
541: dbms_output.put_line('request children test complete');
542:
543: EXCEPTION
544: WHEN OTHERS THEN
545: raise;