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.BIV_RT_TASK_BLOG_PKG dependencies on BIV_RT_TASK_BLOG_PKG

Line 1: package body biv_rt_task_blog_pkg as

1: package body biv_rt_task_blog_pkg as
2: /* $Header: bivrtskb.pls 115.18 2004/01/23 04:56:21 vganeshk ship $ */
3: procedure sr_backlog(p_param_str varchar2) as
4: x_status1 cs_incidents_all_b.incident_status_id % type;
5: x_status2 cs_incidents_all_b.incident_status_id % type;

Line 560: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

556: and session_id = l_session_id;
557: exception
558: when others then
559: if (l_debug = 'Y') then
560: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
561: l_pos || ':' ||
562: substr(sqlerrm,1,500);
563: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
564: end if;

Line 576: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

572: and session_id = l_session_id;
573: exception
574: when others then
575: if (l_debug = 'Y') then
576: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
577: l_pos || ':' ||
578: substr(sqlerrm,1,500);
579: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
580: end if;

Line 592: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

588: and session_id = l_session_id;
589: exception
590: when others then
591: if (l_debug = 'Y') then
592: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
593: l_pos || ':' ||
594: substr(sqlerrm,1,500);
595: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
596: commit;

Line 611: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

607: where report_code = 'BIV_SERVICE_REQUEST'
608: and session_id = l_session_id;
609: exception
610: when others then
611: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
612: l_pos || ':' ||
613: substr(sqlerrm,1,500);
614: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
615: commit;

Line 629: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

625: and session_id = l_session_id;
626: exception
627: when others then
628: if (l_debug = 'Y') then
629: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
630: l_pos || ':' ||
631: substr(sqlerrm,1,500);
632: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
633: commit;

Line 648: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

644: and session_id = l_session_id;
645: exception
646: when others then
647: if (l_debug = 'Y') then
648: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
649: l_pos || ':' ||
650: substr(sqlerrm,1,500);
651: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
652: commit;

Line 667: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

663: and session_id = l_session_id;
664: exception
665: when others then
666: if (l_debug = 'Y') then
667: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
668: l_pos || ':' ||
669: substr(sqlerrm,1,500);
670: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
671: commit;

Line 685: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

681: and session_id = l_session_id;
682: exception
683: when others then
684: if (l_debug = 'Y') then
685: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
686: l_pos || ':' ||
687: substr(sqlerrm,1,500);
688: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
689: commit;

Line 702: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

698: and session_id = l_session_id;
699: exception
700: when others then
701: if (l_debug = 'Y') then
702: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
703: l_pos || ':' ||
704: substr(sqlerrm,1,500);
705: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
706: commit;

Line 725: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

721: and session_id = l_session_id;
722: exception
723: when others then
724: if (l_debug = 'Y') then
725: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
726: l_pos || ':' ||
727: substr(sqlerrm,1,500);
728: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
729: commit;

Line 750: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

746: and session_id = l_session_id;
747: exception
748: when others then
749: if (l_debug = 'Y') then
750: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
751: l_pos || ':' ||
752: substr(sqlerrm,1,500);
753: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
754: commit;

Line 765: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||

761:
762: exception
763: when others then
764: if (l_debug = 'Y') then
765: l_err := 'Err in biv_rt_task_blog_pkg.service_request at:' ||
766: l_pos || ':' ||
767: substr(sqlerrm,1,500);
768: biv_core_pkg.biv_debug(l_err,'BIV_SERVICE_REQUEST');
769: end if;