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_SUPPLIER_PKG dependencies on MSC_SUPPLIER_PKG

Line 1: package body msc_supplier_pkg as

1: package body msc_supplier_pkg as
2: /* $Header: MSCHBSPB.pls 120.58.12020000.3 2012/11/09 14:07:26 wexia ship $ */
3: SYS_YES CONSTANT INTEGER := 1;
4: SYS_NO CONSTANT INTEGER := 2;
5:

Line 20: msc_phub_util.log('msc_supplier_pkg.populate_details');

16: l_rowcount number;
17: l_start_time timestamp := systimestamp;
18: l_enable_num number := nvl(fnd_profile.value('MSC_APCC_ENABLE_CUM'), 1);
19: begin
20: msc_phub_util.log('msc_supplier_pkg.populate_details');
21: retcode := 0;
22: errbuf := null;
23:
24: select plan_type, sr_instance_id, plan_start_date, plan_cutoff_date, temp_transfer_id

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

542: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_SUPPLIERS_F', p_plan_run_id);
543:
544:
545: summarize_suppliers_f(errbuf, retcode, p_plan_id, p_plan_run_id);
546: msc_phub_util.log('msc_supplier_pkg.populate_details.complete, duration='||(systimestamp-l_start_time));
547:
548: exception
549: when others then
550: msc_phub_util.log('msc_supplier_pkg.populate_details: '||sqlerrm);

Line 550: msc_phub_util.log('msc_supplier_pkg.populate_details: '||sqlerrm);

546: msc_phub_util.log('msc_supplier_pkg.populate_details.complete, duration='||(systimestamp-l_start_time));
547:
548: exception
549: when others then
550: msc_phub_util.log('msc_supplier_pkg.populate_details: '||sqlerrm);
551: raise;
552:
553: end populate_details;
554:

Line 560: msc_phub_util.log('msc_supplier_pkg.summarize_suppliers_f');

556: p_plan_id number, p_plan_run_id number)
557: is
558: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
559: begin
560: msc_phub_util.log('msc_supplier_pkg.summarize_suppliers_f');
561: retcode := 0;
562: errbuf := '';
563:
564: delete from msc_suppliers_f

Line 566: msc_phub_util.log('msc_supplier_pkg.summarize_suppliers_f, delete='||sql%rowcount);

562: errbuf := '';
563:
564: delete from msc_suppliers_f
565: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
566: msc_phub_util.log('msc_supplier_pkg.summarize_suppliers_f, delete='||sql%rowcount);
567: commit;
568:
569: -- level 1
570: insert into msc_suppliers_f (

Line 620: msc_phub_util.log('msc_supplier_pkg.summarize_suppliers_f, level1='||sql%rowcount);

616: f.supplier_id, f.supplier_site_id,
617: f.analysis_date,
618: nvl(q.sr_category_id, -23453);
619:
620: msc_phub_util.log('msc_supplier_pkg.summarize_suppliers_f, level1='||sql%rowcount);
621: commit;
622:
623: exception
624: when others then

Line 626: errbuf := 'msc_supplier_pkg.summarize_suppliers_f: '||sqlerrm;

622:
623: exception
624: when others then
625: retcode := 2;
626: errbuf := 'msc_supplier_pkg.summarize_suppliers_f: '||sqlerrm;
627: raise;
628:
629: end summarize_suppliers_f;
630:

Line 640: msc_phub_util.log('msc_supplier_pkg.export_suppliers_f');

636: l_sql varchar2(5000);
637: l_suffix varchar2(32) := msc_phub_util.suffix(p_dblink);
638: l_apps_schema varchar2(30) := msc_phub_util.apps_schema;
639: begin
640: msc_phub_util.log('msc_supplier_pkg.export_suppliers_f');
641: retcode := 0;
642: errbuf := null;
643:
644: delete from msc_st_suppliers_f where st_transaction_id=p_st_transaction_id;

Line 713: msc_phub_util.log('msc_supplier_pkg.export_suppliers_f: complete, retcode='||retcode);

709: ' and smv.supplier_site_id(+)=f.supplier_site_id';
710:
711: execute immediate l_sql using p_st_transaction_id, p_plan_run_id;
712: commit;
713: msc_phub_util.log('msc_supplier_pkg.export_suppliers_f: complete, retcode='||retcode);
714:
715: exception
716: when others then
717: retcode := 2;

Line 718: errbuf := 'msc_supplier_pkg.export_suppliers_f: '||sqlerrm;

714:
715: exception
716: when others then
717: retcode := 2;
718: errbuf := 'msc_supplier_pkg.export_suppliers_f: '||sqlerrm;
719: msc_phub_util.log(errbuf);
720: end export_suppliers_f;
721:
722: procedure import_suppliers_f (

Line 732: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f');

728: l_staging_table varchar2(30) := 'msc_st_suppliers_f';
729: l_fact_table varchar2(30) := 'msc_suppliers_f';
730: l_result number := 0;
731: begin
732: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f');
733: retcode := 0;
734: errbuf := null;
735:
736: l_result := l_result + msc_phub_util.prepare_staging_dates(

Line 761: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: insert into msc_suppliers_f');

757: l_staging_table, p_st_transaction_id,
758: 'supplier_id', 'supplier_site_id',
759: 'supplier_name', 'supplier_site_code');
760:
761: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: insert into msc_suppliers_f');
762: insert into msc_suppliers_f (
763: plan_id,
764: plan_run_id,
765: sr_instance_id,

Line 802: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: inserted='||sql%rowcount);

798: fnd_global.user_id, sysdate, fnd_global.login_id
799: from msc_st_suppliers_f
800: where st_transaction_id=p_st_transaction_id and error_code=0;
801:
802: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: inserted='||sql%rowcount);
803: commit;
804:
805: summarize_suppliers_f(errbuf, retcode, p_plan_id, p_plan_run_id);
806:

Line 811: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: complete, retcode='||retcode);

807: if (l_result > 0) then
808: retcode := -1;
809: end if;
810:
811: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: complete, retcode='||retcode);
812:
813: exception
814: when others then
815: retcode := 2;

Line 816: errbuf := 'msc_supplier_pkg.import_suppliers_f: '||sqlerrm;

812:
813: exception
814: when others then
815: retcode := 2;
816: errbuf := 'msc_supplier_pkg.import_suppliers_f: '||sqlerrm;
817: msc_phub_util.log(errbuf);
818: end import_suppliers_f;
819:
820: end msc_supplier_pkg;

Line 820: end msc_supplier_pkg;

816: errbuf := 'msc_supplier_pkg.import_suppliers_f: '||sqlerrm;
817: msc_phub_util.log(errbuf);
818: end import_suppliers_f;
819:
820: end msc_supplier_pkg;