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.OPIMPXWI dependencies on EDW_LOG

Line 340: EDW_LOG.PUT_LINE (proc_name || ':' || sqlerrm);

336:
337: WHEN OTHERS
338: THEN
339: NULL;
340: EDW_LOG.PUT_LINE (proc_name || ':' || sqlerrm);
341: -- DBMS_OUTPUT.PUT_LINE (proc_name || ':' || sqlerrm);
342:
343: END avg_costing_org_item_cost;
344:

Line 483: EDW_LOG.PUT_LINE('At start EXTRACT IDS LOG');

479: ---------------------------------------------------------*/
480:
481: -- Make sure from and to date are not null
482:
483: EDW_LOG.PUT_LINE('At start EXTRACT IDS LOG');
484: select sysdate into l_print_date from dual;
485: EDW_LOG.PUT_LINE('Start time: ' ||
486: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
487:

Line 485: EDW_LOG.PUT_LINE('Start time: ' ||

481: -- Make sure from and to date are not null
482:
483: EDW_LOG.PUT_LINE('At start EXTRACT IDS LOG');
484: select sysdate into l_print_date from dual;
485: EDW_LOG.PUT_LINE('Start time: ' ||
486: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
487:
488: if p_from_date is null then -- check from date
489: l_statement := 10;

Line 514: EDW_LOG.PUT_LINE('l_from_date'||to_char(l_from_date,'DD-MON-YYYY hh24:mi:ss'));

510: l_to_date := p_to_date;
511: end if;
512:
513:
514: EDW_LOG.PUT_LINE('l_from_date'||to_char(l_from_date,'DD-MON-YYYY hh24:mi:ss'));
515: EDW_LOG.PUT_LINE('l_to_date'||to_char(l_to_date,'DD-MON-YYYY hh24:mi:ss'));
516:
517: select sum(1)
518: into select_cursor

Line 515: EDW_LOG.PUT_LINE('l_to_date'||to_char(l_to_date,'DD-MON-YYYY hh24:mi:ss'));

511: end if;
512:
513:
514: EDW_LOG.PUT_LINE('l_from_date'||to_char(l_from_date,'DD-MON-YYYY hh24:mi:ss'));
515: EDW_LOG.PUT_LINE('l_to_date'||to_char(l_to_date,'DD-MON-YYYY hh24:mi:ss'));
516:
517: select sum(1)
518: into select_cursor
519: from opi_ids_push_date_log

Line 531: EDW_LOG.PUT_LINE('Invalid organization code, please verify.');

527: and mp.process_enabled_flag <> 'Y';
528: l_exit := 0;
529: EXCEPTION
530: when NO_DATA_FOUND then
531: EDW_LOG.PUT_LINE('Invalid organization code, please verify.');
532: l_errnum := 0;
533: l_retcode := 'Invalid organization code.';
534: l_errbuf := 'Please provide a valid inventory organization code.';
535: return;

Line 537: EDW_LOG.PUT_LINE('Processing single org');

533: l_retcode := 'Invalid organization code.';
534: l_errbuf := 'Please provide a valid inventory organization code.';
535: return;
536: END;
537: EDW_LOG.PUT_LINE('Processing single org');
538: else
539: if (select_cursor > 1) then
540: OPEN c_inv_org;
541: EDW_LOG.PUT_LINE('Processing cursor c_inv_org');

Line 541: EDW_LOG.PUT_LINE('Processing cursor c_inv_org');

537: EDW_LOG.PUT_LINE('Processing single org');
538: else
539: if (select_cursor > 1) then
540: OPEN c_inv_org;
541: EDW_LOG.PUT_LINE('Processing cursor c_inv_org');
542: else
543: OPEN c_inv_org_first_push;
544: EDW_LOG.PUT_LINE('Processing cursor c_inv_org_first_push');
545: end if;

Line 544: EDW_LOG.PUT_LINE('Processing cursor c_inv_org_first_push');

540: OPEN c_inv_org;
541: EDW_LOG.PUT_LINE('Processing cursor c_inv_org');
542: else
543: OPEN c_inv_org_first_push;
544: EDW_LOG.PUT_LINE('Processing cursor c_inv_org_first_push');
545: end if;
546: end if;
547:
548: /*-------------------------

Line 578: EDW_LOG.PUT_LINE('*********************************************');

574: end if;
575: end if;
576:
577:
578: EDW_LOG.PUT_LINE('*********************************************');
579:
580: EDW_LOG.PUT_LINE('Start extraction process for organization: '
581: || to_char(org_id));
582:

Line 580: EDW_LOG.PUT_LINE('Start extraction process for organization: '

576:
577:
578: EDW_LOG.PUT_LINE('*********************************************');
579:
580: EDW_LOG.PUT_LINE('Start extraction process for organization: '
581: || to_char(org_id));
582:
583: SAVEPOINT sav_org;
584:

Line 612: EDW_LOG.PUT_LINE('Calling OPIMPDAT.get_push_dates ...');

608: -- -----------------------------------------------------------------
609:
610: l_statement := 30;
611:
612: EDW_LOG.PUT_LINE('Calling OPIMPDAT.get_push_dates ...');
613: select sysdate into l_print_date from dual;
614: EDW_LOG.PUT_LINE('Start time: ' ||
615: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
616:

Line 614: EDW_LOG.PUT_LINE('Start time: ' ||

610: l_statement := 30;
611:
612: EDW_LOG.PUT_LINE('Calling OPIMPDAT.get_push_dates ...');
613: select sysdate into l_print_date from dual;
614: EDW_LOG.PUT_LINE('Start time: ' ||
615: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
616:
617: OPIMPDAT.get_push_dates(
618: org_id,

Line 635: EDW_LOG.PUT_LINE('End time: ' ||

631: l_retcode,
632: l_errbuf,
633: l_txn_flag);
634: select sysdate into l_print_date from dual;
635: EDW_LOG.PUT_LINE('End time: ' ||
636: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
637:
638: if l_errnum <> 0 THEN
639: IF l_errnum <> 9999 THEN

Line 655: EDW_LOG.PUT_LINE('inv_from_date: ' || to_char(inv_from_date,'DD-MON-YYYY hh24:mi:ss'));

651: goto next_org;
652:
653: end if;
654:
655: EDW_LOG.PUT_LINE('inv_from_date: ' || to_char(inv_from_date,'DD-MON-YYYY hh24:mi:ss'));
656: EDW_LOG.PUT_LINE('wip_from_date: ' || to_char(wip_from_date,'DD-MON-YYYY hh24:mi:ss'));
657: EDW_LOG.PUT_LINE('to_date: ' || to_char(to_date,'DD-MON-YYYY hh24:mi:ss'));
658:
659:

Line 656: EDW_LOG.PUT_LINE('wip_from_date: ' || to_char(wip_from_date,'DD-MON-YYYY hh24:mi:ss'));

652:
653: end if;
654:
655: EDW_LOG.PUT_LINE('inv_from_date: ' || to_char(inv_from_date,'DD-MON-YYYY hh24:mi:ss'));
656: EDW_LOG.PUT_LINE('wip_from_date: ' || to_char(wip_from_date,'DD-MON-YYYY hh24:mi:ss'));
657: EDW_LOG.PUT_LINE('to_date: ' || to_char(to_date,'DD-MON-YYYY hh24:mi:ss'));
658:
659:
660: /*-------------------------------------------------------------------

Line 657: EDW_LOG.PUT_LINE('to_date: ' || to_char(to_date,'DD-MON-YYYY hh24:mi:ss'));

653: end if;
654:
655: EDW_LOG.PUT_LINE('inv_from_date: ' || to_char(inv_from_date,'DD-MON-YYYY hh24:mi:ss'));
656: EDW_LOG.PUT_LINE('wip_from_date: ' || to_char(wip_from_date,'DD-MON-YYYY hh24:mi:ss'));
657: EDW_LOG.PUT_LINE('to_date: ' || to_char(to_date,'DD-MON-YYYY hh24:mi:ss'));
658:
659:
660: /*-------------------------------------------------------------------
661: Purge old data in opi_ids_push_log table.

Line 668: EDW_LOG.PUT_LINE('Calling purge_opi_ids_push_log ...');

664: start date or a period end date. In addition, data in a closed period
665: which include the lastest pushed transaction date will not be purged.
666: --------------------------------------------------------------------*/
667: l_statement := 40;
668: EDW_LOG.PUT_LINE('Calling purge_opi_ids_push_log ...');
669: select sysdate into l_print_date from dual;
670: EDW_LOG.PUT_LINE('Start time: ' ||
671: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
672:

Line 670: EDW_LOG.PUT_LINE('Start time: ' ||

666: --------------------------------------------------------------------*/
667: l_statement := 40;
668: EDW_LOG.PUT_LINE('Calling purge_opi_ids_push_log ...');
669: select sysdate into l_print_date from dual;
670: EDW_LOG.PUT_LINE('Start time: ' ||
671: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
672:
673: -- if we are running across periods, then we must not only recompute
674: -- all the activity rows, but even the period start and end rows, so

Line 700: EDW_LOG.PUT_LINE('End time: ' ||

696: l_retcode,
697: l_errbuf);
698:
699: select sysdate into l_print_date from dual;
700: EDW_LOG.PUT_LINE('End time: ' ||
701: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
702:
703: if l_errnum <> 0 then
704: process_error(l_statement,

Line 745: EDW_LOG.PUT_LINE('No valid period during the date range specified for Org_id :' || org_id);

741: FETCH prd_start_date_min_csr INTO inv_from_date;
742:
743: IF inv_from_date IS NULL THEN
744: CLOSE prd_start_date_min_csr;
745: EDW_LOG.PUT_LINE('No valid period during the date range specified for Org_id :' || org_id);
746: GOTO next_org;
747: ELSE
748: CLOSE prd_start_date_min_csr;
749: END IF;

Line 755: EDW_LOG.PUT_LINE(' first ever push, inv_from_date is '

751:
752: CLOSE prd_start_date_csr;
753: END IF;
754:
755: EDW_LOG.PUT_LINE(' first ever push, inv_from_date is '
756: || To_char(inv_from_date,'DD-MON-YYYY hh24:mi:ss') );
757:
758: END ;
759:

Line 760: EDW_LOG.PUT_LINE('Calling calc_begin_inv ...');

756: || To_char(inv_from_date,'DD-MON-YYYY hh24:mi:ss') );
757:
758: END ;
759:
760: EDW_LOG.PUT_LINE('Calling calc_begin_inv ...');
761: select sysdate into l_print_date from dual;
762: EDW_LOG.PUT_LINE('Start time: ' ||
763: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
764:

Line 762: EDW_LOG.PUT_LINE('Start time: ' ||

758: END ;
759:
760: EDW_LOG.PUT_LINE('Calling calc_begin_inv ...');
761: select sysdate into l_print_date from dual;
762: EDW_LOG.PUT_LINE('Start time: ' ||
763: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
764:
765: calc_begin_inv(inv_from_date, org_id,status);
766: select sysdate into l_print_date from dual;

Line 767: EDW_LOG.PUT_LINE('End time: ' ||

763: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
764:
765: calc_begin_inv(inv_from_date, org_id,status);
766: select sysdate into l_print_date from dual;
767: EDW_LOG.PUT_LINE('End time: ' ||
768: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
769:
770: if status > 0 then
771: l_errbuf := 'Error calling calc_begin_inv. Org id: '

Line 798: EDW_LOG.PUT_LINE('Calling calc_inv_balance ...');

794: goto wip_calculation;
795: end if;
796:
797:
798: EDW_LOG.PUT_LINE('Calling calc_inv_balance ...');
799: select sysdate into l_print_date from dual;
800: EDW_LOG.PUT_LINE('Start time: ' ||
801: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
802: -- ------------------------------------------------------------------

Line 800: EDW_LOG.PUT_LINE('Start time: ' ||

796:
797:
798: EDW_LOG.PUT_LINE('Calling calc_inv_balance ...');
799: select sysdate into l_print_date from dual;
800: EDW_LOG.PUT_LINE('Start time: ' ||
801: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
802: -- ------------------------------------------------------------------
803: -- Calling calc_inv_balance to calculate the Inv daily balance
804: -- for each organization

Line 819: EDW_LOG.PUT_LINE('End time: ' ||

815: to_date,org_id,
816: status);
817: END IF;
818: select sysdate into l_print_date from dual;
819: EDW_LOG.PUT_LINE('End time: ' ||
820: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
821:
822: if status > 0 then
823: l_errbuf := 'Error calling calc_inv_balance. Org id: '

Line 838: EDW_LOG.PUT_LINE ('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');

834: -- must have set the EDW_ENABLE_INV_ACTIVITY_MEASURES to Y. If so,
835: -- calculate all the measures.
836: -- For backward compatibility, if a customer has not implemented
837: -- the profile, then these measures should get collected too.
838: EDW_LOG.PUT_LINE ('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');
839: EDW_LOG.PUT_LINE ('PROFILE ' || g_measures_profile ||' = ' ||
840: NVL (FND_PROFILE.VALUE (g_measures_profile),
841: 'NULL'));
842: EDW_LOG.PUT_LINE ('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');

Line 839: EDW_LOG.PUT_LINE ('PROFILE ' || g_measures_profile ||' = ' ||

835: -- calculate all the measures.
836: -- For backward compatibility, if a customer has not implemented
837: -- the profile, then these measures should get collected too.
838: EDW_LOG.PUT_LINE ('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');
839: EDW_LOG.PUT_LINE ('PROFILE ' || g_measures_profile ||' = ' ||
840: NVL (FND_PROFILE.VALUE (g_measures_profile),
841: 'NULL'));
842: EDW_LOG.PUT_LINE ('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');
843:

Line 842: EDW_LOG.PUT_LINE ('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');

838: EDW_LOG.PUT_LINE ('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');
839: EDW_LOG.PUT_LINE ('PROFILE ' || g_measures_profile ||' = ' ||
840: NVL (FND_PROFILE.VALUE (g_measures_profile),
841: 'NULL'));
842: EDW_LOG.PUT_LINE ('&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&');
843:
844: IF (NVL (FND_PROFILE.VALUE (g_measures_profile), 'Y') = 'Y') THEN
845:
846: -- --------------------------------------------------------------

Line 851: EDW_LOG.PUT_LINE ('Calling calc_wip_completion ....');

847: -- Calling procedures to calculate the Inv daily activities
848: -- for each organization
849: --
850: -- --------------------------------------------------------------
851: EDW_LOG.PUT_LINE ('Calling calc_wip_completion ....');
852: select sysdate into l_print_date from dual;
853: EDW_LOG.PUT_LINE('Start time: ' ||
854: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
855: OPIMPXIN.calc_wip_completion( l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 853: EDW_LOG.PUT_LINE('Start time: ' ||

849: --
850: -- --------------------------------------------------------------
851: EDW_LOG.PUT_LINE ('Calling calc_wip_completion ....');
852: select sysdate into l_print_date from dual;
853: EDW_LOG.PUT_LINE('Start time: ' ||
854: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
855: OPIMPXIN.calc_wip_completion( l_errbuf,l_retcode,inv_from_date,to_date,org_id);
856: select sysdate into l_print_date from dual;
857: EDW_LOG.PUT_LINE('End time: ' ||

Line 857: EDW_LOG.PUT_LINE('End time: ' ||

853: EDW_LOG.PUT_LINE('Start time: ' ||
854: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
855: OPIMPXIN.calc_wip_completion( l_errbuf,l_retcode,inv_from_date,to_date,org_id);
856: select sysdate into l_print_date from dual;
857: EDW_LOG.PUT_LINE('End time: ' ||
858: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
859:
860: if l_retcode = '2' then
861: l_errbuf := 'Error calling calc_wip_completion. Org id: '

Line 873: EDW_LOG.PUT_LINE ('Calling calc_wip_issue ....');

869: end if;
870:
871:
872:
873: EDW_LOG.PUT_LINE ('Calling calc_wip_issue ....');
874: select sysdate into l_print_date from dual;
875: EDW_LOG.PUT_LINE('Start time: ' ||
876: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
877: OPIMPXIN.calc_wip_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 875: EDW_LOG.PUT_LINE('Start time: ' ||

871:
872:
873: EDW_LOG.PUT_LINE ('Calling calc_wip_issue ....');
874: select sysdate into l_print_date from dual;
875: EDW_LOG.PUT_LINE('Start time: ' ||
876: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
877: OPIMPXIN.calc_wip_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
878: select sysdate into l_print_date from dual;
879: EDW_LOG.PUT_LINE('End time: ' ||

Line 879: EDW_LOG.PUT_LINE('End time: ' ||

875: EDW_LOG.PUT_LINE('Start time: ' ||
876: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
877: OPIMPXIN.calc_wip_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
878: select sysdate into l_print_date from dual;
879: EDW_LOG.PUT_LINE('End time: ' ||
880: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
881:
882: if l_retcode = '2' then
883: l_errbuf := 'Error calling calc_wip_issue. Org id: '

Line 893: EDW_LOG.PUT_LINE ('Calling calc_assembly_return ....');

889: l_errbuf);
890: goto next_org;
891: end if;
892:
893: EDW_LOG.PUT_LINE ('Calling calc_assembly_return ....');
894: select sysdate into l_print_date from dual;
895: EDW_LOG.PUT_LINE('Start time: ' ||
896: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
897: OPIMPXIN.calc_assembly_return(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 895: EDW_LOG.PUT_LINE('Start time: ' ||

891: end if;
892:
893: EDW_LOG.PUT_LINE ('Calling calc_assembly_return ....');
894: select sysdate into l_print_date from dual;
895: EDW_LOG.PUT_LINE('Start time: ' ||
896: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
897: OPIMPXIN.calc_assembly_return(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
898: select sysdate into l_print_date from dual;
899: EDW_LOG.PUT_LINE('End time: ' ||

Line 899: EDW_LOG.PUT_LINE('End time: ' ||

895: EDW_LOG.PUT_LINE('Start time: ' ||
896: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
897: OPIMPXIN.calc_assembly_return(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
898: select sysdate into l_print_date from dual;
899: EDW_LOG.PUT_LINE('End time: ' ||
900: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
901:
902: if l_retcode = '2' then
903: l_errbuf := 'Error calling calc_assembly_return. Org id: '

Line 913: EDW_LOG.PUT_LINE ('Calling calc_po_deliveries ....');

909: l_errbuf);
910: goto next_org;
911: end if;
912:
913: EDW_LOG.PUT_LINE ('Calling calc_po_deliveries ....');
914: select sysdate into l_print_date from dual;
915: EDW_LOG.PUT_LINE('Start time: ' ||
916: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
917: OPIMPXIN.calc_po_deliveries(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 915: EDW_LOG.PUT_LINE('Start time: ' ||

911: end if;
912:
913: EDW_LOG.PUT_LINE ('Calling calc_po_deliveries ....');
914: select sysdate into l_print_date from dual;
915: EDW_LOG.PUT_LINE('Start time: ' ||
916: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
917: OPIMPXIN.calc_po_deliveries(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
918: select sysdate into l_print_date from dual;
919: EDW_LOG.PUT_LINE('End time: ' ||

Line 919: EDW_LOG.PUT_LINE('End time: ' ||

915: EDW_LOG.PUT_LINE('Start time: ' ||
916: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
917: OPIMPXIN.calc_po_deliveries(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
918: select sysdate into l_print_date from dual;
919: EDW_LOG.PUT_LINE('End time: ' ||
920: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
921:
922: if l_retcode = '2' then
923: l_errbuf := 'Error calling calc_po_deliveries. Org id: '

Line 933: EDW_LOG.PUT_LINE ('Calling calc_value_to_orgs ....');

929: l_errbuf);
930: goto next_org;
931: end if;
932:
933: EDW_LOG.PUT_LINE ('Calling calc_value_to_orgs ....');
934: select sysdate into l_print_date from dual;
935: EDW_LOG.PUT_LINE('Start time: ' ||
936: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
937: OPIMPXIN.calc_value_to_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 935: EDW_LOG.PUT_LINE('Start time: ' ||

931: end if;
932:
933: EDW_LOG.PUT_LINE ('Calling calc_value_to_orgs ....');
934: select sysdate into l_print_date from dual;
935: EDW_LOG.PUT_LINE('Start time: ' ||
936: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
937: OPIMPXIN.calc_value_to_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
938: select sysdate into l_print_date from dual;
939: EDW_LOG.PUT_LINE('End time: ' ||

Line 939: EDW_LOG.PUT_LINE('End time: ' ||

935: EDW_LOG.PUT_LINE('Start time: ' ||
936: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
937: OPIMPXIN.calc_value_to_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
938: select sysdate into l_print_date from dual;
939: EDW_LOG.PUT_LINE('End time: ' ||
940: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
941:
942: if l_retcode = '2' then
943: l_errbuf := 'Error calling calc_value_to_orgs. Org id: '

Line 953: EDW_LOG.PUT_LINE ('Calling calc_value_from_orgs ....');

949: l_errbuf);
950: goto next_org;
951: end if;
952:
953: EDW_LOG.PUT_LINE ('Calling calc_value_from_orgs ....');
954: select sysdate into l_print_date from dual;
955: EDW_LOG.PUT_LINE('Start time: ' ||
956: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
957: OPIMPXIN.calc_value_from_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 955: EDW_LOG.PUT_LINE('Start time: ' ||

951: end if;
952:
953: EDW_LOG.PUT_LINE ('Calling calc_value_from_orgs ....');
954: select sysdate into l_print_date from dual;
955: EDW_LOG.PUT_LINE('Start time: ' ||
956: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
957: OPIMPXIN.calc_value_from_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
958: select sysdate into l_print_date from dual;
959: EDW_LOG.PUT_LINE('End time: ' ||

Line 959: EDW_LOG.PUT_LINE('End time: ' ||

955: EDW_LOG.PUT_LINE('Start time: ' ||
956: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
957: OPIMPXIN.calc_value_from_orgs(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
958: select sysdate into l_print_date from dual;
959: EDW_LOG.PUT_LINE('End time: ' ||
960: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
961:
962: if l_retcode = '2' then
963: l_errbuf := 'Error calling calc_value_from_orgs. Org id: '

Line 973: EDW_LOG.PUT_LINE ('Calling calc_customer_shipment ....');

969: l_errbuf);
970: goto next_org;
971: end if;
972:
973: EDW_LOG.PUT_LINE ('Calling calc_customer_shipment ....');
974: select sysdate into l_print_date from dual;
975: EDW_LOG.PUT_LINE('Start time: ' ||
976: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
977: OPIMPXIN.calc_customer_shipment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 975: EDW_LOG.PUT_LINE('Start time: ' ||

971: end if;
972:
973: EDW_LOG.PUT_LINE ('Calling calc_customer_shipment ....');
974: select sysdate into l_print_date from dual;
975: EDW_LOG.PUT_LINE('Start time: ' ||
976: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
977: OPIMPXIN.calc_customer_shipment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
978: select sysdate into l_print_date from dual;
979: EDW_LOG.PUT_LINE('End time: ' ||

Line 979: EDW_LOG.PUT_LINE('End time: ' ||

975: EDW_LOG.PUT_LINE('Start time: ' ||
976: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
977: OPIMPXIN.calc_customer_shipment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
978: select sysdate into l_print_date from dual;
979: EDW_LOG.PUT_LINE('End time: ' ||
980: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
981:
982: if l_retcode = '2' then
983: l_errbuf := 'Error calling calc_customer_shipment. Org id: '

Line 993: EDW_LOG.PUT_LINE ('Calling calc_inv_adjustment ....');

989: l_errbuf);
990: goto next_org;
991: end if;
992:
993: EDW_LOG.PUT_LINE ('Calling calc_inv_adjustment ....');
994: select sysdate into l_print_date from dual;
995: EDW_LOG.PUT_LINE('Start time: ' ||
996: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
997: OPIMPXIN.calc_inv_adjustment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 995: EDW_LOG.PUT_LINE('Start time: ' ||

991: end if;
992:
993: EDW_LOG.PUT_LINE ('Calling calc_inv_adjustment ....');
994: select sysdate into l_print_date from dual;
995: EDW_LOG.PUT_LINE('Start time: ' ||
996: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
997: OPIMPXIN.calc_inv_adjustment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
998: select sysdate into l_print_date from dual;
999: EDW_LOG.PUT_LINE('End time: ' ||

Line 999: EDW_LOG.PUT_LINE('End time: ' ||

995: EDW_LOG.PUT_LINE('Start time: ' ||
996: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
997: OPIMPXIN.calc_inv_adjustment(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
998: select sysdate into l_print_date from dual;
999: EDW_LOG.PUT_LINE('End time: ' ||
1000: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1001:
1002: if l_retcode = '2' then
1003: l_errbuf := 'Error calling calc_inv_adjustment. Org id: '

Line 1013: EDW_LOG.PUT_LINE ('Calling calc_total_issue ....');

1009: l_errbuf);
1010: goto next_org;
1011: end if;
1012:
1013: EDW_LOG.PUT_LINE ('Calling calc_total_issue ....');
1014: select sysdate into l_print_date from dual;
1015: EDW_LOG.PUT_LINE('Start time: ' ||
1016: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1017: OPIMPXIN.calc_total_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 1015: EDW_LOG.PUT_LINE('Start time: ' ||

1011: end if;
1012:
1013: EDW_LOG.PUT_LINE ('Calling calc_total_issue ....');
1014: select sysdate into l_print_date from dual;
1015: EDW_LOG.PUT_LINE('Start time: ' ||
1016: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1017: OPIMPXIN.calc_total_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
1018: select sysdate into l_print_date from dual;
1019: EDW_LOG.PUT_LINE('End time: ' ||

Line 1019: EDW_LOG.PUT_LINE('End time: ' ||

1015: EDW_LOG.PUT_LINE('Start time: ' ||
1016: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1017: OPIMPXIN.calc_total_issue(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
1018: select sysdate into l_print_date from dual;
1019: EDW_LOG.PUT_LINE('End time: ' ||
1020: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1021:
1022: if l_retcode = '2' then
1023: l_errbuf := 'Error calling calc_total_issue. Org id: '

Line 1033: EDW_LOG.PUT_LINE ('Calling calc_total_receipt ....');

1029: l_errbuf);
1030: goto next_org;
1031: end if;
1032:
1033: EDW_LOG.PUT_LINE ('Calling calc_total_receipt ....');
1034: select sysdate into l_print_date from dual;
1035: EDW_LOG.PUT_LINE('Start time: ' ||
1036: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1037: OPIMPXIN.calc_total_receipt(l_errbuf,l_retcode,inv_from_date,to_date,org_id);

Line 1035: EDW_LOG.PUT_LINE('Start time: ' ||

1031: end if;
1032:
1033: EDW_LOG.PUT_LINE ('Calling calc_total_receipt ....');
1034: select sysdate into l_print_date from dual;
1035: EDW_LOG.PUT_LINE('Start time: ' ||
1036: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1037: OPIMPXIN.calc_total_receipt(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
1038: select sysdate into l_print_date from dual;
1039: EDW_LOG.PUT_LINE('End time: ' ||

Line 1039: EDW_LOG.PUT_LINE('End time: ' ||

1035: EDW_LOG.PUT_LINE('Start time: ' ||
1036: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1037: OPIMPXIN.calc_total_receipt(l_errbuf,l_retcode,inv_from_date,to_date,org_id);
1038: select sysdate into l_print_date from dual;
1039: EDW_LOG.PUT_LINE('End time: ' ||
1040: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1041:
1042: if l_retcode = '2' then
1043: l_errbuf := 'Error calling calc_total_receipt. Org id: '

Line 1055: EDW_LOG.PUT_LINE ('Calling calc_intrst_balance ....');

1051: end if;
1052:
1053: END IF; -- end of calculating activity measures based on profile option
1054:
1055: EDW_LOG.PUT_LINE ('Calling calc_intrst_balance ....');
1056: select sysdate into l_print_date from dual;
1057: EDW_LOG.PUT_LINE('Start time: ' ||
1058: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1059: calc_intrst_balance(inv_from_date,to_date,org_id,status);

Line 1057: EDW_LOG.PUT_LINE('Start time: ' ||

1053: END IF; -- end of calculating activity measures based on profile option
1054:
1055: EDW_LOG.PUT_LINE ('Calling calc_intrst_balance ....');
1056: select sysdate into l_print_date from dual;
1057: EDW_LOG.PUT_LINE('Start time: ' ||
1058: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1059: calc_intrst_balance(inv_from_date,to_date,org_id,status);
1060: select sysdate into l_print_date from dual;
1061: EDW_LOG.PUT_LINE('End time: ' ||

Line 1061: EDW_LOG.PUT_LINE('End time: ' ||

1057: EDW_LOG.PUT_LINE('Start time: ' ||
1058: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1059: calc_intrst_balance(inv_from_date,to_date,org_id,status);
1060: select sysdate into l_print_date from dual;
1061: EDW_LOG.PUT_LINE('End time: ' ||
1062: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1063:
1064: if status > 0 then
1065: l_errbuf := 'Error calling calc_intrst_balance. Org id: '

Line 1084: EDW_LOG.PUT_LINE('Calling OPIMPXWP.calc_wip_balance ...');

1080:
1081: -- Call wip procedure regardless of l_txn_flag, because both MMT
1082: -- and WT must be accumulated for WIP balances.
1083:
1084: EDW_LOG.PUT_LINE('Calling OPIMPXWP.calc_wip_balance ...');
1085: select sysdate into l_print_date from dual;
1086: EDW_LOG.PUT_LINE('Start time: ' ||
1087: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1088: OPIMPXWP.calc_wip_balance(org_id,

Line 1086: EDW_LOG.PUT_LINE('Start time: ' ||

1082: -- and WT must be accumulated for WIP balances.
1083:
1084: EDW_LOG.PUT_LINE('Calling OPIMPXWP.calc_wip_balance ...');
1085: select sysdate into l_print_date from dual;
1086: EDW_LOG.PUT_LINE('Start time: ' ||
1087: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1088: OPIMPXWP.calc_wip_balance(org_id,
1089: inv_from_date,
1090: wip_from_date,

Line 1099: EDW_LOG.PUT_LINE('End time: ' ||

1095: l_errnum,
1096: l_retcode,
1097: l_errbuf);
1098: select sysdate into l_print_date from dual;
1099: EDW_LOG.PUT_LINE('End time: ' ||
1100: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1101:
1102: if l_errnum <> 0 then
1103: process_error(l_statement,

Line 1116: EDW_LOG.PUT_LINE ('Calling calc_prd_start_end ....');

1112: -- the last and first day of the period.
1113: --
1114: -- ------------------------------------------------------------------
1115:
1116: EDW_LOG.PUT_LINE ('Calling calc_prd_start_end ....');
1117: select sysdate into l_print_date from dual;
1118: EDW_LOG.PUT_LINE('Start time: ' ||
1119: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1120: opi_edw_ids_calc.calc_prd_start_end ( inv_from_date,

Line 1118: EDW_LOG.PUT_LINE('Start time: ' ||

1114: -- ------------------------------------------------------------------
1115:
1116: EDW_LOG.PUT_LINE ('Calling calc_prd_start_end ....');
1117: select sysdate into l_print_date from dual;
1118: EDW_LOG.PUT_LINE('Start time: ' ||
1119: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1120: opi_edw_ids_calc.calc_prd_start_end ( inv_from_date,
1121: to_date,
1122: org_id,

Line 1125: EDW_LOG.PUT_LINE('End time: ' ||

1121: to_date,
1122: org_id,
1123: status);
1124: select sysdate into l_print_date from dual;
1125: EDW_LOG.PUT_LINE('End time: ' ||
1126: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1127:
1128: if status > 0 then
1129: l_errbuf := 'Error calling calc_prd_start_end. Org id: '

Line 1162: EDW_LOG.PUT_LINE('Extraction completed for org '|| to_char(org_id));

1158: commit;
1159:
1160: <> -- label
1161:
1162: EDW_LOG.PUT_LINE('Extraction completed for org '|| to_char(org_id));
1163:
1164: end loop; -- end c_inv_org loop
1165:
1166: EDW_LOG.PUT_LINE ('Done with inv balance extraction in opi_extract_ids.'); -- Remove . for bug 3556719

Line 1166: EDW_LOG.PUT_LINE ('Done with inv balance extraction in opi_extract_ids.'); -- Remove . for bug 3556719

1162: EDW_LOG.PUT_LINE('Extraction completed for org '|| to_char(org_id));
1163:
1164: end loop; -- end c_inv_org loop
1165:
1166: EDW_LOG.PUT_LINE ('Done with inv balance extraction in opi_extract_ids.'); -- Remove . for bug 3556719
1167: select sysdate into l_print_date from dual;
1168: EDW_LOG.PUT_LINE('End time: ' ||
1169: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1170:

Line 1168: EDW_LOG.PUT_LINE('End time: ' ||

1164: end loop; -- end c_inv_org loop
1165:
1166: EDW_LOG.PUT_LINE ('Done with inv balance extraction in opi_extract_ids.'); -- Remove . for bug 3556719
1167: select sysdate into l_print_date from dual;
1168: EDW_LOG.PUT_LINE('End time: ' ||
1169: to_char (sysdate, 'DD-MON-YY HH24:MI:SS'));
1170:
1171: EXCEPTION
1172:

Line 1174: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Error at statement ('

1170:
1171: EXCEPTION
1172:
1173: WHEN no_from_date THEN
1174: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Error at statement ('
1175: || to_char(l_statement)
1176: || ')');
1177:
1178: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));

Line 1178: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));

1174: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Error at statement ('
1175: || to_char(l_statement)
1176: || ')');
1177:
1178: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));
1179: EDW_LOG.PUT_LINE('Error Code: ' || l_retcode);
1180: EDW_LOG.PUT_LINE('Error Message: ' || l_errbuf);
1181:
1182: WHEN others then

Line 1179: EDW_LOG.PUT_LINE('Error Code: ' || l_retcode);

1175: || to_char(l_statement)
1176: || ')');
1177:
1178: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));
1179: EDW_LOG.PUT_LINE('Error Code: ' || l_retcode);
1180: EDW_LOG.PUT_LINE('Error Message: ' || l_errbuf);
1181:
1182: WHEN others then
1183: rollback;

Line 1180: EDW_LOG.PUT_LINE('Error Message: ' || l_errbuf);

1176: || ')');
1177:
1178: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));
1179: EDW_LOG.PUT_LINE('Error Code: ' || l_retcode);
1180: EDW_LOG.PUT_LINE('Error Message: ' || l_errbuf);
1181:
1182: WHEN others then
1183: rollback;
1184: l_errnum := SQLCODE;

Line 1190: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Error at statement ('

1186: || to_char(l_statement)
1187: || '): '
1188: || substr(SQLERRM, 1,200);
1189:
1190: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Error at statement ('
1191: || to_char(l_statement)
1192: || ')');
1193:
1194: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));

Line 1194: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));

1190: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Error at statement ('
1191: || to_char(l_statement)
1192: || ')');
1193:
1194: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));
1195: EDW_LOG.PUT_LINE('Error Code: ' || l_retcode);
1196: EDW_LOG.PUT_LINE('Error Message: ' || l_errbuf);
1197:
1198: END opi_extract_ids;

Line 1195: EDW_LOG.PUT_LINE('Error Code: ' || l_retcode);

1191: || to_char(l_statement)
1192: || ')');
1193:
1194: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));
1195: EDW_LOG.PUT_LINE('Error Code: ' || l_retcode);
1196: EDW_LOG.PUT_LINE('Error Message: ' || l_errbuf);
1197:
1198: END opi_extract_ids;
1199:

Line 1196: EDW_LOG.PUT_LINE('Error Message: ' || l_errbuf);

1192: || ')');
1193:
1194: EDW_LOG.PUT_LINE('Error Number: ' || to_char(l_errnum));
1195: EDW_LOG.PUT_LINE('Error Code: ' || l_retcode);
1196: EDW_LOG.PUT_LINE('Error Message: ' || l_errbuf);
1197:
1198: END opi_extract_ids;
1199:
1200:

Line 1294: EDW_LOG.PUT_LINE(' p_from_date= '||to_char(p_from_date,'DD-MON-YYYY hh24:mi:ss')||

1290:
1291:
1292: BEGIN
1293:
1294: EDW_LOG.PUT_LINE(' p_from_date= '||to_char(p_from_date,'DD-MON-YYYY hh24:mi:ss')||
1295: ' p_to_Date= '||to_char(p_to_date,'DD-MON-YYYY hh24:mi:ss')||' org= '||Org_id);
1296:
1297:
1298: /*----------------------------------------------------------------------------------------

Line 1348: EDW_LOG.PUT_LINE('///////////////with no lot cursor, count is ' ||inv_balance_no_lot%rowcount );

1344: end if;
1345:
1346:
1347: /*
1348: EDW_LOG.PUT_LINE('///////////////with no lot cursor, count is ' ||inv_balance_no_lot%rowcount );
1349:
1350: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1351: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1352: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));

Line 1350: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);

1346:
1347: /*
1348: EDW_LOG.PUT_LINE('///////////////with no lot cursor, count is ' ||inv_balance_no_lot%rowcount );
1349:
1350: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1351: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1352: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1353: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1354: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);

Line 1351: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );

1347: /*
1348: EDW_LOG.PUT_LINE('///////////////with no lot cursor, count is ' ||inv_balance_no_lot%rowcount );
1349:
1350: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1351: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1352: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1353: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1354: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1355: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);

Line 1352: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));

1348: EDW_LOG.PUT_LINE('///////////////with no lot cursor, count is ' ||inv_balance_no_lot%rowcount );
1349:
1350: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1351: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1352: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1353: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1354: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1355: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1356: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));

Line 1353: EDW_LOG.PUT_LINE('l_revision='||l_revision);

1349:
1350: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1351: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1352: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1353: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1354: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1355: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1356: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));
1357: */

Line 1354: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);

1350: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1351: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1352: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1353: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1354: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1355: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1356: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));
1357: */
1358:

Line 1355: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);

1351: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1352: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1353: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1354: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1355: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1356: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));
1357: */
1358:
1359:

Line 1356: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));

1352: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1353: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1354: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1355: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1356: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));
1357: */
1358:
1359:
1360: SELECT INVENTORY_ITEM_STATUS_CODE,

Line 1428: EDW_LOG.PUT_LINE('/////within with_lot cursor count is ' ||inv_balance_with_lot%rowcount );

1424: end if;
1425:
1426:
1427: /*
1428: EDW_LOG.PUT_LINE('/////within with_lot cursor count is ' ||inv_balance_with_lot%rowcount );
1429:
1430: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1431: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1432:

Line 1430: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);

1426:
1427: /*
1428: EDW_LOG.PUT_LINE('/////within with_lot cursor count is ' ||inv_balance_with_lot%rowcount );
1429:
1430: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1431: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1432:
1433: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1434: EDW_LOG.PUT_LINE('l_revision='||l_revision);

Line 1431: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );

1427: /*
1428: EDW_LOG.PUT_LINE('/////within with_lot cursor count is ' ||inv_balance_with_lot%rowcount );
1429:
1430: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1431: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1432:
1433: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1434: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1435: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);

Line 1433: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));

1429:
1430: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1431: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1432:
1433: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1434: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1435: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1436: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1437:

Line 1434: EDW_LOG.PUT_LINE('l_revision='||l_revision);

1430: EDW_LOG.PUT_LINE('l_trx_date='||l_trx_date);
1431: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1432:
1433: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1434: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1435: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1436: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1437:
1438: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));

Line 1435: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);

1431: EDW_LOG.PUT_LINE('l_item_id = ' || l_item_id );
1432:
1433: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1434: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1435: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1436: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1437:
1438: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));
1439: */

Line 1436: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);

1432:
1433: EDW_LOG.PUT_LINE('l_cost_group_id='||to_char(l_cost_group_id));
1434: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1435: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1436: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1437:
1438: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));
1439: */
1440:

Line 1438: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));

1434: EDW_LOG.PUT_LINE('l_revision='||l_revision);
1435: EDW_LOG.PUT_LINE('l_lot_number='||l_lot_number);
1436: EDW_LOG.PUT_LINE('l_subinventory='||l_subinventory);
1437:
1438: EDW_LOG.PUT_LINE('total_qty='||to_char(total_qty));
1439: */
1440:
1441:
1442: SELECT INVENTORY_ITEM_STATUS_CODE,

Line 1481: edw_log.put_line('Error in CALC_INV_BALANCE at statement= '||l_statement);

1477: END LOOP;
1478:
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: edw_log.put_line('Error in CALC_INV_BALANCE at statement= '||l_statement);
1482: edw_log.put_line('Error Code: ' || SQLCODE );
1483: edw_log.put_line('Error Msg: ' || Sqlerrm );
1484: status := 2;
1485:

Line 1482: edw_log.put_line('Error Code: ' || SQLCODE );

1478:
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: edw_log.put_line('Error in CALC_INV_BALANCE at statement= '||l_statement);
1482: edw_log.put_line('Error Code: ' || SQLCODE );
1483: edw_log.put_line('Error Msg: ' || Sqlerrm );
1484: status := 2;
1485:
1486: END CALC_INV_BALANCE;

Line 1483: edw_log.put_line('Error Msg: ' || Sqlerrm );

1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: edw_log.put_line('Error in CALC_INV_BALANCE at statement= '||l_statement);
1482: edw_log.put_line('Error Code: ' || SQLCODE );
1483: edw_log.put_line('Error Msg: ' || Sqlerrm );
1484: status := 2;
1485:
1486: END CALC_INV_BALANCE;
1487:

Line 1544: EDW_LOG.PUT_LINE('total_qty='||to_char(p_total_qty));

1540: l_ids_key VARCHAR2(240);
1541: BEGIN
1542:
1543: /*
1544: EDW_LOG.PUT_LINE('total_qty='||to_char(p_total_qty));
1545: */
1546:
1547: SELECT primary_cost_method
1548: INTO cost_method

Line 1572: --EDW_LOG.PUT_LINE( ' ids_key ' || l_ids_key );

1568: ------------------------------------------------------------------------------------------*/
1569:
1570: l_ids_key := l_max_trx_date||'-'||p_item_id||'-'||p_organization_id||'-'||p_cost_group_id||'-'||p_revision||'-'||p_lot_number||'-'||p_subinventory||'-'||p_locator;
1571:
1572: --EDW_LOG.PUT_LINE( ' ids_key ' || l_ids_key );
1573:
1574: IF(l_max_trx_date is null) THEN
1575:
1576: -- Since there are no entries in the push log for this item-org prior

Line 1610: edw_log.put_line('ids key - ' || l_ids_key );

1606: FROM opi_ids_push_log
1607: WHERE IDS_KEY = l_ids_key;
1608: Exception
1609: when others then
1610: edw_log.put_line('ids key - ' || l_ids_key );
1611: Raise;
1612: end;
1613:
1614: END IF;

Line 1623: edw_log.put_line('ids key - ' || l_ids_key );

1619: FROM OPI_IDS_PUSH_LOG
1620: WHERE IDS_KEY = l_ids_key;
1621: Exception
1622: when others then
1623: edw_log.put_line('ids key - ' || l_ids_key );
1624: Raise;
1625: end;
1626: END IF;
1627:

Line 1631: -- EDW_LOG.PUT_LINE('l_max_trx_date is ' || l_max_trx_date || 'l_last_end_qty is ' || l_last_end_qty || 'l_last_end_val is ' || l_last_end_val );

1627:
1628: CLOSE last_trx;
1629:
1630:
1631: -- EDW_LOG.PUT_LINE('l_max_trx_date is ' || l_max_trx_date || 'l_last_end_qty is ' || l_last_end_qty || 'l_last_end_val is ' || l_last_end_val );
1632:
1633: l_statement := 2;
1634:
1635: /*--------------------------------------------------------------------------------------------------

Line 1721: /* EDW_LOG.PUT_LINE('l_start_qty = '|| l_start_qty || ' l_end_qty = ' || l_end_qty || ' l_start_val = '|| l_start_val || 'l_total_val = ' || l_total_val || 'l_end_val = ' || l_end_val ); */

1717: END IF;
1718:
1719: l_avg_val := (l_start_val+l_end_val)/2;
1720:
1721: /* EDW_LOG.PUT_LINE('l_start_qty = '|| l_start_qty || ' l_end_qty = ' || l_end_qty || ' l_start_val = '|| l_start_val || 'l_total_val = ' || l_total_val || 'l_end_val = ' || l_end_val ); */
1722:
1723:
1724: l_statement := 4;
1725:

Line 1756: edw_log.put_line('Error in Insert_update_push_log');

1752:
1753: l_statement := 5;
1754:
1755: if( l_status > 0 ) then
1756: edw_log.put_line('Error in Insert_update_push_log');
1757: status := 1;
1758: else
1759: status := 0;
1760: end if;

Line 1764: edw_log.put_line('Error in Calculate_Balance at statement= '||l_statement);

1760: end if;
1761:
1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: edw_log.put_line('Error in Calculate_Balance at statement= '||l_statement);
1765: edw_log.put_line('Error Code: ' || SQLCODE );
1766: edw_log.put_line('Error Msg: ' || Sqlerrm );
1767: status := 1;
1768:

Line 1765: edw_log.put_line('Error Code: ' || SQLCODE );

1761:
1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: edw_log.put_line('Error in Calculate_Balance at statement= '||l_statement);
1765: edw_log.put_line('Error Code: ' || SQLCODE );
1766: edw_log.put_line('Error Msg: ' || Sqlerrm );
1767: status := 1;
1768:
1769: END Calculate_Balance;

Line 1766: edw_log.put_line('Error Msg: ' || Sqlerrm );

1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: edw_log.put_line('Error in Calculate_Balance at statement= '||l_statement);
1765: edw_log.put_line('Error Code: ' || SQLCODE );
1766: edw_log.put_line('Error Msg: ' || Sqlerrm );
1767: status := 1;
1768:
1769: END Calculate_Balance;
1770:

Line 1872: EDW_LOG.PUT_LINE('org id: '||i_org_id ||' from date ' ||

1868: and l_purge_to_date
1869: and ipl.push_flag = 0
1870: and ipl.period_flag is null;
1871:
1872: EDW_LOG.PUT_LINE('org id: '||i_org_id ||' from date ' ||
1873: To_char(l_purge_from_date, 'DD-MON-YYYY HH24:MI:SS') ||
1874: ' to date ' || To_char(l_purge_to_date, 'DD-MON-YYYY HH24:MI:SS')
1875: || ' delete rowcount ' || SQL%rowcount );
1876: end if;

Line 1890: EDW_LOG.PUT_LINE('OPIMXWI.purge_opi_ids_push_log - no purge; ');

1886: EXCEPTION
1887: WHEN no_purge then
1888: o_errnum := l_errnum;
1889: o_errbuf := l_errbuf;
1890: EDW_LOG.PUT_LINE('OPIMXWI.purge_opi_ids_push_log - no purge; ');
1891: EDW_LOG.PUT_LINE('Data can only be purged thru '
1892: || to_char(l_purge_to_date));
1893: WHEN others then
1894: o_errnum := SQLCODE;

Line 1891: EDW_LOG.PUT_LINE('Data can only be purged thru '

1887: WHEN no_purge then
1888: o_errnum := l_errnum;
1889: o_errbuf := l_errbuf;
1890: EDW_LOG.PUT_LINE('OPIMXWI.purge_opi_ids_push_log - no purge; ');
1891: EDW_LOG.PUT_LINE('Data can only be purged thru '
1892: || to_char(l_purge_to_date));
1893: WHEN others then
1894: o_errnum := SQLCODE;
1895: o_errbuf := 'OPIMXWI.purge_opi_ids_push_log ('

Line 1913: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Error at statement ('

1909: BEGIN
1910:
1911: rollback to sav_org;
1912:
1913: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Error at statement ('
1914: || to_char(i_stmt_num)
1915: || ')');
1916:
1917: EDW_LOG.PUT_LINE('Error Number: ' || to_char(i_errnum));

Line 1917: EDW_LOG.PUT_LINE('Error Number: ' || to_char(i_errnum));

1913: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Error at statement ('
1914: || to_char(i_stmt_num)
1915: || ')');
1916:
1917: EDW_LOG.PUT_LINE('Error Number: ' || to_char(i_errnum));
1918: EDW_LOG.PUT_LINE('Error Code: ' || i_retcode);
1919: EDW_LOG.PUT_LINE('Error Message: ' || i_errbuf);
1920:
1921: g_org_error := true;

Line 1918: EDW_LOG.PUT_LINE('Error Code: ' || i_retcode);

1914: || to_char(i_stmt_num)
1915: || ')');
1916:
1917: EDW_LOG.PUT_LINE('Error Number: ' || to_char(i_errnum));
1918: EDW_LOG.PUT_LINE('Error Code: ' || i_retcode);
1919: EDW_LOG.PUT_LINE('Error Message: ' || i_errbuf);
1920:
1921: g_org_error := true;
1922: END process_error;

Line 1919: EDW_LOG.PUT_LINE('Error Message: ' || i_errbuf);

1915: || ')');
1916:
1917: EDW_LOG.PUT_LINE('Error Number: ' || to_char(i_errnum));
1918: EDW_LOG.PUT_LINE('Error Code: ' || i_retcode);
1919: EDW_LOG.PUT_LINE('Error Message: ' || i_errbuf);
1920:
1921: g_org_error := true;
1922: END process_error;
1923:

Line 1934: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Warning at statement ('

1930: BEGIN
1931:
1932: rollback to sav_org;
1933:
1934: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Warning at statement ('
1935: || to_char(i_stmt_num)
1936: || ')');
1937:
1938: EDW_LOG.PUT_LINE('Warning Number: ' || to_char(i_errnum));

Line 1938: EDW_LOG.PUT_LINE('Warning Number: ' || to_char(i_errnum));

1934: EDW_LOG.PUT_LINE('OPIMPXWI.opi_extract_ids - Warning at statement ('
1935: || to_char(i_stmt_num)
1936: || ')');
1937:
1938: EDW_LOG.PUT_LINE('Warning Number: ' || to_char(i_errnum));
1939: EDW_LOG.PUT_LINE('Warning Code: ' || i_retcode);
1940: EDW_LOG.PUT_LINE('Warning Message: ' || i_errbuf);
1941:
1942: g_org_error := true;

Line 1939: EDW_LOG.PUT_LINE('Warning Code: ' || i_retcode);

1935: || to_char(i_stmt_num)
1936: || ')');
1937:
1938: EDW_LOG.PUT_LINE('Warning Number: ' || to_char(i_errnum));
1939: EDW_LOG.PUT_LINE('Warning Code: ' || i_retcode);
1940: EDW_LOG.PUT_LINE('Warning Message: ' || i_errbuf);
1941:
1942: g_org_error := true;
1943: END process_warning;

Line 1940: EDW_LOG.PUT_LINE('Warning Message: ' || i_errbuf);

1936: || ')');
1937:
1938: EDW_LOG.PUT_LINE('Warning Number: ' || to_char(i_errnum));
1939: EDW_LOG.PUT_LINE('Warning Code: ' || i_retcode);
1940: EDW_LOG.PUT_LINE('Warning Message: ' || i_errbuf);
1941:
1942: g_org_error := true;
1943: END process_warning;
1944:

Line 2159: edw_log.put_line('item_id ' || l_item_id || 'c_onhand_qty is ' || current_onhand_qty ||

2155: end_onh_qty := beg_onh_qty + Nvl(from_date_transacted_quantity, 0);
2156: avg_onh_qty := (beg_onh_qty + end_onh_qty) /2;
2157:
2158: /*
2159: edw_log.put_line('item_id ' || l_item_id || 'c_onhand_qty is ' || current_onhand_qty ||
2160: ' net_qty is ' || net_transacted_quantity ||
2161: ' from_qty is ' || from_date_transacted_quantity || 'beg_onh_qty ' || beg_onh_qty );
2162: */
2163:

Line 2259: -- edw_log.put_line(' item_cost is ' || Nvl( item_cost,0) );

2255: END IF; -- } (asset_sub = 1 OR l_subinventory is NULL) AND
2256: -- (non_expense_item = 'Y')
2257:
2258:
2259: -- edw_log.put_line(' item_cost is ' || Nvl( item_cost,0) );
2260:
2261: beg_onh_val := beg_onh_qty * nvl(item_cost,0);
2262: end_onh_val := end_onh_qty * nvl(item_cost,0);
2263: avg_onh_val := (beg_onh_val + end_onh_val) /2;

Line 2303: EDW_LOG.PUT_LINE('Inserted '||to_char(p_from_date)||','||to_char(Org_id)||','||to_char(l_item_id)||','||to_char(l_cost_group_id)||','||l_revision||',');

2299: selector => 2,
2300: success => l_status);
2301:
2302: /*
2303: EDW_LOG.PUT_LINE('Inserted '||to_char(p_from_date)||','||to_char(Org_id)||','||to_char(l_item_id)||','||to_char(l_cost_group_id)||','||l_revision||',');
2304:
2305: EDW_LOG.PUT_LINE(l_lot_number||','||l_subinventory||','||to_char(l_locator)||','||to_char(beg_onh_qty)||','||to_char(beg_onh_val));
2306: */
2307:

Line 2305: EDW_LOG.PUT_LINE(l_lot_number||','||l_subinventory||','||to_char(l_locator)||','||to_char(beg_onh_qty)||','||to_char(beg_onh_val));

2301:
2302: /*
2303: EDW_LOG.PUT_LINE('Inserted '||to_char(p_from_date)||','||to_char(Org_id)||','||to_char(l_item_id)||','||to_char(l_cost_group_id)||','||l_revision||',');
2304:
2305: EDW_LOG.PUT_LINE(l_lot_number||','||l_subinventory||','||to_char(l_locator)||','||to_char(beg_onh_qty)||','||to_char(beg_onh_val));
2306: */
2307:
2308: if( l_status > 0 ) then
2309: edw_log.put_line('Error in Insert_update_push_log');

Line 2309: edw_log.put_line('Error in Insert_update_push_log');

2305: EDW_LOG.PUT_LINE(l_lot_number||','||l_subinventory||','||to_char(l_locator)||','||to_char(beg_onh_qty)||','||to_char(beg_onh_val));
2306: */
2307:
2308: if( l_status > 0 ) then
2309: edw_log.put_line('Error in Insert_update_push_log');
2310: status := 1;
2311: else
2312: status := 0;
2313: end if;

Line 2325: edw_log.put_line('Begin Balance Processed ');

2321: */
2322: end if; -- Forward port Bug 4561628.
2323: end loop;
2324:
2325: edw_log.put_line('Begin Balance Processed ');
2326: edw_log.put_line('ctr1 '||to_char(ctr1));
2327: edw_log.put_line('ctr2 '||to_char(ctr1));
2328: edw_log.put_line('ctr3 '||to_char(ctr1));
2329: EXCEPTION

Line 2326: edw_log.put_line('ctr1 '||to_char(ctr1));

2322: end if; -- Forward port Bug 4561628.
2323: end loop;
2324:
2325: edw_log.put_line('Begin Balance Processed ');
2326: edw_log.put_line('ctr1 '||to_char(ctr1));
2327: edw_log.put_line('ctr2 '||to_char(ctr1));
2328: edw_log.put_line('ctr3 '||to_char(ctr1));
2329: EXCEPTION
2330: WHEN OTHERS THEN

Line 2327: edw_log.put_line('ctr2 '||to_char(ctr1));

2323: end loop;
2324:
2325: edw_log.put_line('Begin Balance Processed ');
2326: edw_log.put_line('ctr1 '||to_char(ctr1));
2327: edw_log.put_line('ctr2 '||to_char(ctr1));
2328: edw_log.put_line('ctr3 '||to_char(ctr1));
2329: EXCEPTION
2330: WHEN OTHERS THEN
2331: edw_log.put_line('Error in calc_begin_inv : ');

Line 2328: edw_log.put_line('ctr3 '||to_char(ctr1));

2324:
2325: edw_log.put_line('Begin Balance Processed ');
2326: edw_log.put_line('ctr1 '||to_char(ctr1));
2327: edw_log.put_line('ctr2 '||to_char(ctr1));
2328: edw_log.put_line('ctr3 '||to_char(ctr1));
2329: EXCEPTION
2330: WHEN OTHERS THEN
2331: edw_log.put_line('Error in calc_begin_inv : ');
2332: edw_log.put_line('Error code: '|| to_char(SQLCODE));

Line 2331: edw_log.put_line('Error in calc_begin_inv : ');

2327: edw_log.put_line('ctr2 '||to_char(ctr1));
2328: edw_log.put_line('ctr3 '||to_char(ctr1));
2329: EXCEPTION
2330: WHEN OTHERS THEN
2331: edw_log.put_line('Error in calc_begin_inv : ');
2332: edw_log.put_line('Error code: '|| to_char(SQLCODE));
2333: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));
2334: status := 1;
2335: return;

Line 2332: edw_log.put_line('Error code: '|| to_char(SQLCODE));

2328: edw_log.put_line('ctr3 '||to_char(ctr1));
2329: EXCEPTION
2330: WHEN OTHERS THEN
2331: edw_log.put_line('Error in calc_begin_inv : ');
2332: edw_log.put_line('Error code: '|| to_char(SQLCODE));
2333: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));
2334: status := 1;
2335: return;
2336:

Line 2333: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));

2329: EXCEPTION
2330: WHEN OTHERS THEN
2331: edw_log.put_line('Error in calc_begin_inv : ');
2332: edw_log.put_line('Error code: '|| to_char(SQLCODE));
2333: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));
2334: status := 1;
2335: return;
2336:
2337: End calc_begin_inv;

Line 2460: EDW_LOG.PUT_LINE ('Error: Intransit from org ' || Org_id ||

2456: -- and report this in the log. Program will still terminate
2457: -- normally.
2458: IF (l_fob_pt IS NULL) THEN
2459:
2460: EDW_LOG.PUT_LINE ('Error: Intransit from org ' || Org_id ||
2461: ' to org ' || xfr_org_id ||
2462: ' has NULL FOB point.' ||
2463: ' Intransit transactions between these orgs on '|| l_trx_date || ' cannot be collected. Ignoring transaction.' );
2464:

Line 2498: EDW_LOG.PUT_LINE ('Error: Intransit from org ' ||

2494: -- and report this in the log. Program will still terminate
2495: -- sucessfully.
2496: IF (l_fob_pt IS NULL) THEN
2497:
2498: EDW_LOG.PUT_LINE ('Error: Intransit from org ' ||
2499: xfr_org_id || ' to org ' || Org_id ||
2500: ' has NULL FOB point.' ||
2501: ' Intransit transactions between these orgs on '|| l_trx_date || ' cannot be collected. Ignoring transaction.' );
2502: goto next_intrst_trx; -- skip this trx.

Line 2518: /* edw_log.put_line('IU_push_log: IDSKEY= '||l_pk); */

2514: end if;
2515:
2516: l_pk := l_trx_date||'-'||l_item_id||'-'||l_organization_id||'-'||l_cost_group_id||'-'||'-'||'-'||'-';
2517:
2518: /* edw_log.put_line('IU_push_log: IDSKEY= '||l_pk); */
2519:
2520: l_statement:=3;
2521: OPEN row_exists ;
2522:

Line 2621: edw_log.put_line('No intercompany Shipment network defined between Org'||to_char(Org_id)||' and '||to_char(xfr_org_id));

2617: status := 0;
2618:
2619: EXCEPTION
2620: WHEN NO_DATA_FOUND THEN
2621: edw_log.put_line('No intercompany Shipment network defined between Org'||to_char(Org_id)||' and '||to_char(xfr_org_id));
2622: edw_log.put_line('Error code: '|| to_char(SQLCODE));
2623: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));
2624: status := 1;
2625: return;

Line 2622: edw_log.put_line('Error code: '|| to_char(SQLCODE));

2618:
2619: EXCEPTION
2620: WHEN NO_DATA_FOUND THEN
2621: edw_log.put_line('No intercompany Shipment network defined between Org'||to_char(Org_id)||' and '||to_char(xfr_org_id));
2622: edw_log.put_line('Error code: '|| to_char(SQLCODE));
2623: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));
2624: status := 1;
2625: return;
2626:

Line 2623: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));

2619: EXCEPTION
2620: WHEN NO_DATA_FOUND THEN
2621: edw_log.put_line('No intercompany Shipment network defined between Org'||to_char(Org_id)||' and '||to_char(xfr_org_id));
2622: edw_log.put_line('Error code: '|| to_char(SQLCODE));
2623: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));
2624: status := 1;
2625: return;
2626:
2627: WHEN OTHERS THEN

Line 2628: edw_log.put_line('Error in calc_intrst_balance : ');

2624: status := 1;
2625: return;
2626:
2627: WHEN OTHERS THEN
2628: edw_log.put_line('Error in calc_intrst_balance : ');
2629: edw_log.put_line('Error code: '|| to_char(SQLCODE));
2630: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));
2631: status := 1;
2632: return;

Line 2629: edw_log.put_line('Error code: '|| to_char(SQLCODE));

2625: return;
2626:
2627: WHEN OTHERS THEN
2628: edw_log.put_line('Error in calc_intrst_balance : ');
2629: edw_log.put_line('Error code: '|| to_char(SQLCODE));
2630: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));
2631: status := 1;
2632: return;
2633:

Line 2630: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));

2626:
2627: WHEN OTHERS THEN
2628: edw_log.put_line('Error in calc_intrst_balance : ');
2629: edw_log.put_line('Error code: '|| to_char(SQLCODE));
2630: edw_log.put_line('Error message: '||substr(SQLERRM, 1,200));
2631: status := 1;
2632: return;
2633:
2634: END CALC_INTRST_BALANCE;