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

Line 360: edw_log.put_line('now in calc_prd_start_end for org ' || p_organization_id

356: nvl(l_wip_txn_date, to_date('01-12-3000','DD-MM-YYYY') ) )
357: into l_from_date
358: from dual;
359:
360: edw_log.put_line('now in calc_prd_start_end for org ' || p_organization_id
361: || ' start date ' || To_char(p_from_date,'DD-MON-YYYY hh24:mi:ss')
362: || ' to end date ' ||To_char(p_to_date ,'DD-MON-YYYY hh24:mi:ss')
363: || ' l_from_date ' ||To_char(l_from_date ,
364: 'DD-MON-YYYY hh24:mi:ss'));

Line 427: edw_log.put_line(' l_prd_start_ids_key is '

423: || '-' || l_key.subinventory_code ||'-'
424: || l_key.project_locator_id ;
425:
426: /*
427: edw_log.put_line(' l_prd_start_ids_key is '
428: || l_prd_start_ids_key );
429: edw_log.put_line(' l_prd_end_ids_key is ' || l_prd_end_ids_key );
430:
431: edw_log.put_line('---period ' || l_extraction_periods_csr%rowcount

Line 429: edw_log.put_line(' l_prd_end_ids_key is ' || l_prd_end_ids_key );

425:
426: /*
427: edw_log.put_line(' l_prd_start_ids_key is '
428: || l_prd_start_ids_key );
429: edw_log.put_line(' l_prd_end_ids_key is ' || l_prd_end_ids_key );
430:
431: edw_log.put_line('---period ' || l_extraction_periods_csr%rowcount
432: || ' start date is '|| l_period.start_date || ' '
433: || l_period.end_date || 'l_last_period_end_flag is'

Line 431: edw_log.put_line('---period ' || l_extraction_periods_csr%rowcount

427: edw_log.put_line(' l_prd_start_ids_key is '
428: || l_prd_start_ids_key );
429: edw_log.put_line(' l_prd_end_ids_key is ' || l_prd_end_ids_key );
430:
431: edw_log.put_line('---period ' || l_extraction_periods_csr%rowcount
432: || ' start date is '|| l_period.start_date || ' '
433: || l_period.end_date || 'l_last_period_end_flag is'
434: || l_last_period_end_flag || ' --- '
435: || l_last_period_end_entry.end_int_val_b|| ' --- '

Line 477: --edw_log.put_line(' l_Ids_key ' || l_ids_key );

473: l_last_period_end_flag := 1;
474: END IF;
475: CLOSE l_period_end_entry_csr;
476:
477: --edw_log.put_line(' l_Ids_key ' || l_ids_key );
478: --edw_log.put_line(' l_last_period_end_flag is ' || l_last_period_end_flag );
479: END IF;
480:
481: -- check existing of period_start entry

Line 478: --edw_log.put_line(' l_last_period_end_flag is ' || l_last_period_end_flag );

474: END IF;
475: CLOSE l_period_end_entry_csr;
476:
477: --edw_log.put_line(' l_Ids_key ' || l_ids_key );
478: --edw_log.put_line(' l_last_period_end_flag is ' || l_last_period_end_flag );
479: END IF;
480:
481: -- check existing of period_start entry
482: OPEN l_period_flag_activity_csr (l_prd_start_ids_key );

Line 507: --edw_log.put_line(' l_period_start_flag is '

503: -- l_period_end_bal_flag := 0;
504: END IF;
505: CLOSE l_period_flag_activity_csr;
506:
507: --edw_log.put_line(' l_period_start_flag is '
508: -- || l_period_start_flag || ' activity is '
509: -- || l_start_activity_flag );
510: --edw_log.put_line(' l_period_end_flag is '
511: -- || l_period_end_flag || 'activity is '

Line 510: --edw_log.put_line(' l_period_end_flag is '

506:
507: --edw_log.put_line(' l_period_start_flag is '
508: -- || l_period_start_flag || ' activity is '
509: -- || l_start_activity_flag );
510: --edw_log.put_line(' l_period_end_flag is '
511: -- || l_period_end_flag || 'activity is '
512: -- || l_end_activity_flag);
513:
514: -- 2). check if there is activity within the period

Line 527: --edw_log.put_line('l_activity_flag is false ' );

523: l_period.end_date);
524: FETCH l_latest_activity_csr INTO l_latest_activity_entry;
525: IF l_latest_activity_csr%notfound THEN
526: l_activity_flag := FALSE;
527: --edw_log.put_line('l_activity_flag is false ' );
528:
529: ELSE
530: l_activity_flag := TRUE;
531: --edw_log.put_line(' l_activity_flag is true '

Line 531: --edw_log.put_line(' l_activity_flag is true '

527: --edw_log.put_line('l_activity_flag is false ' );
528:
529: ELSE
530: l_activity_flag := TRUE;
531: --edw_log.put_line(' l_activity_flag is true '
532: -- || 'trx_date is '
533: -- || l_latest_activity_entry.trx_date );
534:
535: END IF;

Line 574: --edw_log.put_line('1 start no/no insert');

570: l_latest_activity_entry.item_status,
571: l_latest_activity_entry.item_type,
572: l_latest_activity_entry.nettable_flag);
573:
574: --edw_log.put_line('1 start no/no insert');
575:
576: ELSE
577: -- if l_start_activity_flag = 1,
578: -- we have activity on start date-> update

Line 586: --edw_log.put_line('1 start update');

582: SET period_flag = 0,
583: push_flag =1
584: WHERE ids_key = l_prd_start_ids_key;
585:
586: --edw_log.put_line('1 start update');
587: END IF;
588:
589: l_period_start_flag := 1;
590: ELSE -- l_period_start_flag = 1

Line 622: --edw_log.put_line('1 start update 2');

618: l_latest_activity_entry.nettable_flag,
619: push_flag = 1
620: WHERE ids_key = l_prd_start_ids_key;
621: END IF;
622: --edw_log.put_line('1 start update 2');
623: -- ELSE do nothing;
624: END IF;
625: END IF;
626: ELSE -- the key combo does exist in previous period

Line 639: --edw_log.put_line('1 start insert 2');

635: 0, -- p_period_flag
636: l_key,
637: l_last_period_end_entry );
638:
639: --edw_log.put_line('1 start insert 2');
640:
641: ELSIF l_period_start_flag = 999 THEN
642: UPDATE opi_ids_push_log
643: SET period_flag = 0,

Line 656: --edw_log.put_line('1 start update 3');

652: SET period_flag = 0,
653: push_flag =1
654: WHERE ids_key = l_prd_start_ids_key;
655:
656: --edw_log.put_line('1 start update 3');
657: END IF;
658: l_period_start_flag := 1;
659: ELSE -- period_start entry already existed
660: IF l_start_activity_flag <> 1 THEN

Line 667: --edw_log.put_line('1 start update 4');

663: -- from last period_end entry
664: update_ids_push_log(l_prd_start_ids_key,
665: l_last_period_end_entry);
666:
667: --edw_log.put_line('1 start update 4');
668: --ELSE do nothing
669: END IF;
670: END IF;
671: END IF; /* end of period_start entry */

Line 685: --edw_log.put_line('1 end update');

681:
682: update_ids_push_log(l_prd_end_ids_key,
683: l_latest_activity_entry);
684:
685: --edw_log.put_line('1 end update');
686:
687: --ELSE -- do nothing
688: END IF;
689: ELSE -- period_entry doesn't exist yet

Line 699: --edw_log.put_line('1 end insert');

695: l_period.end_date,
696: 1, -- p_period_flag
697: l_key,
698: l_latest_activity_entry);
699: --edw_log.put_line('1 end insert');
700: ELSE
701: -- there is acitivity on period_end date
702: -- turn on the flag
703: -- l_end_activity_flag = 0 or 1,

Line 709: --edw_log.put_line('1 end update 2');

705: UPDATE opi_ids_push_log
706: SET period_flag = 1, push_flag = 1
707: WHERE ids_key = l_prd_end_ids_key;
708:
709: --edw_log.put_line('1 end update 2');
710: END IF;
711:
712: -- now we have a period_end entry for this period
713: l_period_end_flag := 1;

Line 733: --edw_log.put_line('2 start del 0');

729: IF l_period.start_date <> l_first_push_date THEN
730: DELETE opi_ids_push_log
731: WHERE ids_key = l_prd_start_ids_key;
732:
733: --edw_log.put_line('2 start del 0');
734:
735: l_period_start_flag := 0;
736: END IF;-- l_period.start_date <> l_first_push_date
737: ELSIF l_period_start_flag = 999 THEN

Line 767: --edw_log.put_line('2 start del 1');

763: WHERE ids_key = l_prd_start_ids_key;
764:
765: l_period_start_flag := 0;
766:
767: --edw_log.put_line('2 start del 1');
768: ELSE -- a).
769:
770: UPDATE opi_ids_push_log
771: SET period_flag = 0, push_flag = 1

Line 776: --edw_log.put_line('2 start update');

772: WHERE ids_key = l_prd_start_ids_key;
773:
774: l_beg_inv_bal_flag := 1;
775: l_period_start_flag := 1;
776: --edw_log.put_line('2 start update');
777: END IF;
778: END IF;
779: ELSE -- last _period_end_entry exists
780: -- check begin/end on last_period_end_entry

Line 800: --edw_log.put_line('2 start del 2');

796: DELETE opi_ids_push_log
797: WHERE ids_key = l_prd_start_ids_key;
798: l_period_start_flag := 0;
799:
800: --edw_log.put_line('2 start del 2');
801: END IF;
802: ELSE
803: IF l_period_start_flag = 1 THEN
804: -- update the existing period_start entry with the

Line 810: --edw_log.put_line('2 start update 2');

806:
807: update_ids_push_log(l_prd_start_ids_key,
808: l_last_period_end_entry);
809:
810: --edw_log.put_line('2 start update 2');
811: ELSIF l_period_start_flag = 0 THEN
812: insert_ids_push_log(l_prd_start_ids_key,
813: l_period.start_date,
814: 0,

Line 820: --edw_log.put_line('2 start insert 2');

816: l_last_period_end_entry);
817:
818: l_period_start_flag := 1;
819:
820: --edw_log.put_line('2 start insert 2');
821: ELSIF l_period_start_flag = 999 THEN
822: UPDATE opi_ids_push_log
823: SET period_flag = 0, push_flag = 1
824: WHERE ids_key = l_prd_start_ids_key;

Line 826: --edw_log.put_line('2 start update 2.5');

822: UPDATE opi_ids_push_log
823: SET period_flag = 0, push_flag = 1
824: WHERE ids_key = l_prd_start_ids_key;
825:
826: --edw_log.put_line('2 start update 2.5');
827: l_period_start_flag := 1;
828: END IF;
829: END IF;
830: END IF; /* end of period_start entry */

Line 852: --edw_log.put_line('2 end update ');

848:
849: -- Dinkar 11/20/02 -- added this line
850: l_last_period_end_entry :=
851: l_beg_inv_bal_prd_start_entry;
852: --edw_log.put_line('2 end update ');
853:
854: ELSIF l_beg_inv_bal_flag = 1 THEN
855: update_ids_push_log(l_prd_end_ids_key,
856: l_beg_inv_bal_prd_start_entry);

Line 863: --edw_log.put_line('2 end update 2 ');

859: l_period_end_flag := 1;
860: l_last_period_end_entry :=
861: l_beg_inv_bal_prd_start_entry;
862:
863: --edw_log.put_line('2 end update 2 ');
864: END IF;
865:
866: ELSE
867: IF l_period_end_flag = 0 THEN

Line 888: --edw_log.put_line('2 end insert ');

884: -- Dinkar 11/20/02 -- added this line
885: l_last_period_end_entry :=
886: l_beg_inv_bal_prd_start_entry;
887:
888: --edw_log.put_line('2 end insert ');
889: ELSIF l_beg_inv_bal_flag = 1 THEN
890: insert_ids_push_log(l_prd_end_ids_key,
891: l_period.end_date,
892: 1,

Line 901: --edw_log.put_line('2 end insert 2');

897: l_period_end_flag := 1;
898: l_last_period_end_entry :=
899: l_beg_inv_bal_prd_start_entry;
900:
901: --edw_log.put_line('2 end insert 2');
902: END IF;
903: ELSIF l_period_end_flag = 999 THEN
904: UPDATE opi_ids_push_log
905: SET period_flag = 1, push_flag = 1

Line 907: --edw_log.put_line('2 end update 2.5');

903: ELSIF l_period_end_flag = 999 THEN
904: UPDATE opi_ids_push_log
905: SET period_flag = 1, push_flag = 1
906: WHERE ids_key = l_prd_end_ids_key;
907: --edw_log.put_line('2 end update 2.5');
908: END IF;
909:
910: l_period_end_flag := 1;
911: END IF;

Line 918: --edw_log.put_line('2 end del 2 ');

914: WHERE ids_key = l_prd_end_ids_key;
915:
916: l_period_end_flag := 0;
917:
918: --edw_log.put_line('2 end del 2 ');
919: END IF;
920: /* end of period_end_entry */
921:
922: l_last_period_end_flag := l_period_end_flag;

Line 936: edw_log.put_line('Error Code: ' || sqlcode);

932:
933: EXCEPTION
934: WHEN OTHERS THEN
935: --dbms_output.put_line('sqlerrm ' ||Sqlerrm);
936: edw_log.put_line('Error Code: ' || sqlcode);
937: edw_log.put_line('Error Message: ' || sqlerrm);
938: x_status := 1;
939: --commit;
940: END calc_prd_start_end;

Line 937: edw_log.put_line('Error Message: ' || sqlerrm);

933: EXCEPTION
934: WHEN OTHERS THEN
935: --dbms_output.put_line('sqlerrm ' ||Sqlerrm);
936: edw_log.put_line('Error Code: ' || sqlcode);
937: edw_log.put_line('Error Message: ' || sqlerrm);
938: x_status := 1;
939: --commit;
940: END calc_prd_start_end;
941:

Line 1352: EDW_LOG.PUT_LINE ('Exception raised in cost_update_inventory');

1348: WHEN OTHERS
1349: THEN
1350: --DBMS_OUTPUT.PUT_LINE ('Exception Message: ' || SQLERRM);
1351: --DBMS_OUTPUT.PUT_LINE ('Exception Code: ' || SQLCODE);
1352: EDW_LOG.PUT_LINE ('Exception raised in cost_update_inventory');
1353: EDW_LOG.PUT_LINE ('Exception Message: ' || SQLERRM);
1354: EDW_LOG.PUT_LINE ('Exception Code: ' || SQLCODE);
1355: p_status := 1;
1356:

Line 1353: EDW_LOG.PUT_LINE ('Exception Message: ' || SQLERRM);

1349: THEN
1350: --DBMS_OUTPUT.PUT_LINE ('Exception Message: ' || SQLERRM);
1351: --DBMS_OUTPUT.PUT_LINE ('Exception Code: ' || SQLCODE);
1352: EDW_LOG.PUT_LINE ('Exception raised in cost_update_inventory');
1353: EDW_LOG.PUT_LINE ('Exception Message: ' || SQLERRM);
1354: EDW_LOG.PUT_LINE ('Exception Code: ' || SQLCODE);
1355: p_status := 1;
1356:
1357: END cost_update_inventory;

Line 1354: EDW_LOG.PUT_LINE ('Exception Code: ' || SQLCODE);

1350: --DBMS_OUTPUT.PUT_LINE ('Exception Message: ' || SQLERRM);
1351: --DBMS_OUTPUT.PUT_LINE ('Exception Code: ' || SQLCODE);
1352: EDW_LOG.PUT_LINE ('Exception raised in cost_update_inventory');
1353: EDW_LOG.PUT_LINE ('Exception Message: ' || SQLERRM);
1354: EDW_LOG.PUT_LINE ('Exception Code: ' || SQLCODE);
1355: p_status := 1;
1356:
1357: END cost_update_inventory;
1358: