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

Line 1: package body msc_exception_pkg as

1: package body msc_exception_pkg as
2: /* $Header: MSCHBEXB.pls 120.64.12020000.2 2012/10/11 13:57:34 wexia ship $ */
3:
4: procedure populate_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
5: p_plan_id number, p_plan_run_id number) IS

Line 14: msc_phub_util.log('msc_exception_pkg.populate_details:');

10: l_plan_type number;
11: l_sr_instance_id number;
12: l_start_time timestamp := systimestamp;
13: begin
14: msc_phub_util.log('msc_exception_pkg.populate_details:');
15: retcode := 0;
16: errbuf := null;
17:
18: select plan_type, sr_instance_id, plan_start_date, plan_cutoff_date

Line 599: msc_phub_util.log('msc_exception_pkg.populate_details.complete, duration='||(systimestamp-l_start_time));

595:
596: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_EXCEPTIONS_F', p_plan_run_id);
597:
598: summarize_exceptions_f(errbuf, retcode, p_plan_id, p_plan_run_id);
599: msc_phub_util.log('msc_exception_pkg.populate_details.complete, duration='||(systimestamp-l_start_time));
600:
601: exception
602: when others then
603: msc_phub_util.log('msc_exception_pkg.populate_details: '||sqlerrm);

Line 603: msc_phub_util.log('msc_exception_pkg.populate_details: '||sqlerrm);

599: msc_phub_util.log('msc_exception_pkg.populate_details.complete, duration='||(systimestamp-l_start_time));
600:
601: exception
602: when others then
603: msc_phub_util.log('msc_exception_pkg.populate_details: '||sqlerrm);
604: raise;
605:
606: end populate_details;
607:

Line 613: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f');

609: p_plan_id number, p_plan_run_id number)
610: is
611: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
612: begin
613: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f');
614: retcode := 0;
615: errbuf := '';
616:
617: delete from msc_exceptions_f

Line 619: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f, delete='||sql%rowcount);

615: errbuf := '';
616:
617: delete from msc_exceptions_f
618: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
619: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f, delete='||sql%rowcount);
620: commit;
621:
622: -- level 1
623: insert into msc_exceptions_f (

Line 695: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f, level1='||sql%rowcount);

691: f.order_type, f.analysis_date,
692: nvl(q.sr_category_id, -23453),
693: f.exception_type;
694:
695: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f, level1='||sql%rowcount);
696: commit;
697:
698: -- level 2
699: insert into msc_exceptions_f (

Line 771: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f, level2='||sql%rowcount);

767: f.category_set_id,
768: f.sr_category_id,
769: f.exception_type;
770:
771: msc_phub_util.log('msc_exception_pkg.summarize_exceptions_f, level2='||sql%rowcount);
772: commit;
773:
774: exception
775: when others then

Line 777: errbuf := 'msc_exception_pkg.summarize_exceptions_f: '||sqlerrm;

773:
774: exception
775: when others then
776: retcode := 2;
777: errbuf := 'msc_exception_pkg.summarize_exceptions_f: '||sqlerrm;
778: raise;
779:
780: end summarize_exceptions_f;
781:

Line 791: msc_phub_util.log('msc_exception_pkg.export_exceptions_f');

787: l_sql varchar2(5000);
788: l_suffix varchar2(32) := msc_phub_util.suffix(p_dblink);
789: l_apps_schema varchar2(30) := msc_phub_util.apps_schema;
790: begin
791: msc_phub_util.log('msc_exception_pkg.export_exceptions_f');
792: retcode := 0;
793: errbuf := null;
794:
795: delete from msc_st_exceptions_f where st_transaction_id=p_st_transaction_id;

Line 945: msc_phub_util.log('msc_exception_pkg.export_exceptions_f: complete, retcode='||retcode);

941: ' and proj.organization_id(+)=f.organization_id';
942:
943: execute immediate l_sql using p_st_transaction_id, p_plan_run_id;
944: commit;
945: msc_phub_util.log('msc_exception_pkg.export_exceptions_f: complete, retcode='||retcode);
946:
947: exception
948: when others then
949: retcode := 2;

Line 950: errbuf := 'msc_exception_pkg.export_exceptions_f: '||sqlerrm;

946:
947: exception
948: when others then
949: retcode := 2;
950: errbuf := 'msc_exception_pkg.export_exceptions_f: '||sqlerrm;
951: msc_phub_util.log(errbuf);
952: end export_exceptions_f;
953:
954: procedure import_exceptions_f (

Line 964: msc_phub_util.log('msc_exception_pkg.import_exceptions_f');

960: l_staging_table varchar2(30) := 'msc_st_exceptions_f';
961: l_fact_table varchar2(30) := 'msc_exceptions_f';
962: l_result number := 0;
963: begin
964: msc_phub_util.log('msc_exception_pkg.import_exceptions_f');
965: retcode := 0;
966: errbuf := null;
967:
968: l_result := l_result + msc_phub_util.prepare_staging_dates(

Line 1004: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: insert into msc_exceptions_f');

1000:
1001: l_result := l_result + msc_phub_util.decode_project_key(
1002: l_staging_table, p_st_transaction_id);
1003:
1004: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: insert into msc_exceptions_f');
1005: insert into msc_exceptions_f (
1006: plan_id,
1007: plan_run_id,
1008: sr_instance_id,

Line 1071: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: inserted='||sql%rowcount);

1067: fnd_global.user_id, sysdate, fnd_global.login_id
1068: from msc_st_exceptions_f
1069: where st_transaction_id=p_st_transaction_id and error_code=0;
1070:
1071: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: inserted='||sql%rowcount);
1072: commit;
1073:
1074: summarize_exceptions_f(errbuf, retcode, p_plan_id, p_plan_run_id);
1075:

Line 1080: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: complete, retcode='||retcode);

1076: if (l_result > 0) then
1077: retcode := -1;
1078: end if;
1079:
1080: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: complete, retcode='||retcode);
1081:
1082: exception
1083: when others then
1084: retcode := 2;

Line 1085: errbuf := 'msc_exception_pkg.import_exceptions_f: '||sqlerrm;

1081:
1082: exception
1083: when others then
1084: retcode := 2;
1085: errbuf := 'msc_exception_pkg.import_exceptions_f: '||sqlerrm;
1086: msc_phub_util.log(errbuf);
1087: end import_exceptions_f;
1088:
1089: end msc_exception_pkg;

Line 1089: end msc_exception_pkg;

1085: errbuf := 'msc_exception_pkg.import_exceptions_f: '||sqlerrm;
1086: msc_phub_util.log(errbuf);
1087: end import_exceptions_f;
1088:
1089: end msc_exception_pkg;