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

Line 83: EDW_LOG.PUT_LINE('from date: ' || to_char(i_from_date));

79: /*-------------------------------
80: ** Determine start process date
81: --------------------------------*/
82:
83: EDW_LOG.PUT_LINE('from date: ' || to_char(i_from_date));
84: EDW_LOG.PUT_LINE('to date: '|| to_char(i_to_date));
85: EDW_LOG.PUT_LINE('org id: ' || to_char(i_org_id));
86:
87: -- Get last push date and last push transaction id for organization

Line 84: EDW_LOG.PUT_LINE('to date: '|| to_char(i_to_date));

80: ** Determine start process date
81: --------------------------------*/
82:
83: EDW_LOG.PUT_LINE('from date: ' || to_char(i_from_date));
84: EDW_LOG.PUT_LINE('to date: '|| to_char(i_to_date));
85: EDW_LOG.PUT_LINE('org id: ' || to_char(i_org_id));
86:
87: -- Get last push date and last push transaction id for organization
88:

Line 85: EDW_LOG.PUT_LINE('org id: ' || to_char(i_org_id));

81: --------------------------------*/
82:
83: EDW_LOG.PUT_LINE('from date: ' || to_char(i_from_date));
84: EDW_LOG.PUT_LINE('to date: '|| to_char(i_to_date));
85: EDW_LOG.PUT_LINE('org id: ' || to_char(i_org_id));
86:
87: -- Get last push date and last push transaction id for organization
88:
89: l_stmt_num := 10;

Line 172: EDW_LOG.PUT_LINE('lp_i_txn_date: ' || to_char(l_prev_push_inv_txn_date));

168: raise process_error;
169: end if;
170:
171:
172: EDW_LOG.PUT_LINE('lp_i_txn_date: ' || to_char(l_prev_push_inv_txn_date));
173: EDW_LOG.PUT_LINE('(60) lp_i_txn_id: ' || to_char(l_prev_push_inv_txn_id));
174: EDW_LOG.PUT_LINE('(60) lp_w_txn_date: ' || to_char(l_prev_push_wip_txn_date));
175: EDW_LOG.PUT_LINE('(60) lp_w_txn_id: ' || to_char(l_prev_push_wip_txn_id));
176:

Line 173: EDW_LOG.PUT_LINE('(60) lp_i_txn_id: ' || to_char(l_prev_push_inv_txn_id));

169: end if;
170:
171:
172: EDW_LOG.PUT_LINE('lp_i_txn_date: ' || to_char(l_prev_push_inv_txn_date));
173: EDW_LOG.PUT_LINE('(60) lp_i_txn_id: ' || to_char(l_prev_push_inv_txn_id));
174: EDW_LOG.PUT_LINE('(60) lp_w_txn_date: ' || to_char(l_prev_push_wip_txn_date));
175: EDW_LOG.PUT_LINE('(60) lp_w_txn_id: ' || to_char(l_prev_push_wip_txn_id));
176:
177: -- Usually this l_from_date is the last collected date, since there

Line 174: EDW_LOG.PUT_LINE('(60) lp_w_txn_date: ' || to_char(l_prev_push_wip_txn_date));

170:
171:
172: EDW_LOG.PUT_LINE('lp_i_txn_date: ' || to_char(l_prev_push_inv_txn_date));
173: EDW_LOG.PUT_LINE('(60) lp_i_txn_id: ' || to_char(l_prev_push_inv_txn_id));
174: EDW_LOG.PUT_LINE('(60) lp_w_txn_date: ' || to_char(l_prev_push_wip_txn_date));
175: EDW_LOG.PUT_LINE('(60) lp_w_txn_id: ' || to_char(l_prev_push_wip_txn_id));
176:
177: -- Usually this l_from_date is the last collected date, since there
178: -- could have been data entered on that last collected day after the

Line 175: EDW_LOG.PUT_LINE('(60) lp_w_txn_id: ' || to_char(l_prev_push_wip_txn_id));

171:
172: EDW_LOG.PUT_LINE('lp_i_txn_date: ' || to_char(l_prev_push_inv_txn_date));
173: EDW_LOG.PUT_LINE('(60) lp_i_txn_id: ' || to_char(l_prev_push_inv_txn_id));
174: EDW_LOG.PUT_LINE('(60) lp_w_txn_date: ' || to_char(l_prev_push_wip_txn_date));
175: EDW_LOG.PUT_LINE('(60) lp_w_txn_id: ' || to_char(l_prev_push_wip_txn_id));
176:
177: -- Usually this l_from_date is the last collected date, since there
178: -- could have been data entered on that last collected day after the
179: -- ETL was run.

Line 357: EDW_LOG.PUT_LINE ('Looking for txns from: ' || l_look_for_txn_id);

353: l_look_for_txn_id := l_push_inv_start_date;
354:
355: END;
356:
357: EDW_LOG.PUT_LINE ('Looking for txns from: ' || l_look_for_txn_id);
358:
359: select nvl(min(transaction_id),0),
360: nvl(max(transaction_id),0)
361: into l_push_inv_start_txn_id,

Line 376: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - '

372:
373: if (l_push_inv_start_txn_id = 0 or
374: l_push_inv_start_txn_id is null) then
375: l_txn_flag := 2; -- set flag to process WT only
376: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - '
377: || 'No INV transactions for date range');
378: if l_first_push = 1 then
379: l_first_push := 2;
380: else

Line 404: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no INV transactions to process ');

400: if (o_push_start_inv_txn_date > trunc (i_to_date)) -- Dinkar 10/11/02
401: or (o_push_start_inv_txn_date is null) then
402: o_push_start_inv_txn_date := trunc (l_from_date);
403:
404: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no INV transactions to process ');
405: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
406: EDW_LOG.PUT_LINE('Start INV Push Date :'
407: || to_char(o_push_start_inv_txn_date,
408: 'DD-MON-YYYY HH24:MI:SS'));

Line 405: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));

401: or (o_push_start_inv_txn_date is null) then
402: o_push_start_inv_txn_date := trunc (l_from_date);
403:
404: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no INV transactions to process ');
405: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
406: EDW_LOG.PUT_LINE('Start INV Push Date :'
407: || to_char(o_push_start_inv_txn_date,
408: 'DD-MON-YYYY HH24:MI:SS'));
409: EDW_LOG.PUT_LINE('End INV Push Date :'

Line 406: EDW_LOG.PUT_LINE('Start INV Push Date :'

402: o_push_start_inv_txn_date := trunc (l_from_date);
403:
404: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no INV transactions to process ');
405: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
406: EDW_LOG.PUT_LINE('Start INV Push Date :'
407: || to_char(o_push_start_inv_txn_date,
408: 'DD-MON-YYYY HH24:MI:SS'));
409: EDW_LOG.PUT_LINE('End INV Push Date :'
410: || to_char(o_push_end_txn_date,

Line 409: EDW_LOG.PUT_LINE('End INV Push Date :'

405: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
406: EDW_LOG.PUT_LINE('Start INV Push Date :'
407: || to_char(o_push_start_inv_txn_date,
408: 'DD-MON-YYYY HH24:MI:SS'));
409: EDW_LOG.PUT_LINE('End INV Push Date :'
410: || to_char(o_push_end_txn_date,
411: 'DD-MON-YYYY HH24:MI:SS'));
412: end if;
413:

Line 586: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - '

582:
583: if (l_push_wip_start_txn_id = 0 or
584: l_push_wip_start_txn_id is null) then
585: o_push_last_wip_txn_id := l_prev_push_wip_txn_id;
586: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - '
587: || 'No WIP transactions for date range');
588: if o_txn_flag = 0 then -- reset flag to process MMT only
589: o_txn_flag := 1;
590: end if;

Line 601: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no WIP transactions to process');

597: if (o_push_start_wip_txn_date > trunc (i_to_date)) -- Dinkar 10/11/02
598: or (o_push_start_wip_txn_date is null) then
599: o_push_start_wip_txn_date := trunc (l_from_date); -- Dinkar 10/11/02
600:
601: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no WIP transactions to process');
602: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
603: EDW_LOG.PUT_LINE('Start WIP Push Date :'
604: || to_char(o_push_start_wip_txn_date,
605: 'DD-MON-YYYY HH24:MI:SS'));

Line 602: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));

598: or (o_push_start_wip_txn_date is null) then
599: o_push_start_wip_txn_date := trunc (l_from_date); -- Dinkar 10/11/02
600:
601: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no WIP transactions to process');
602: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
603: EDW_LOG.PUT_LINE('Start WIP Push Date :'
604: || to_char(o_push_start_wip_txn_date,
605: 'DD-MON-YYYY HH24:MI:SS'));
606: EDW_LOG.PUT_LINE('End WIP Push Date :'

Line 603: EDW_LOG.PUT_LINE('Start WIP Push Date :'

599: o_push_start_wip_txn_date := trunc (l_from_date); -- Dinkar 10/11/02
600:
601: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no WIP transactions to process');
602: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
603: EDW_LOG.PUT_LINE('Start WIP Push Date :'
604: || to_char(o_push_start_wip_txn_date,
605: 'DD-MON-YYYY HH24:MI:SS'));
606: EDW_LOG.PUT_LINE('End WIP Push Date :'
607: || to_char(o_push_end_txn_date,

Line 606: EDW_LOG.PUT_LINE('End WIP Push Date :'

602: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
603: EDW_LOG.PUT_LINE('Start WIP Push Date :'
604: || to_char(o_push_start_wip_txn_date,
605: 'DD-MON-YYYY HH24:MI:SS'));
606: EDW_LOG.PUT_LINE('End WIP Push Date :'
607: || to_char(o_push_end_txn_date,
608: 'DD-MON-YYYY HH24:MI:SS'));
609: end if;
610:

Line 611: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates-');

607: || to_char(o_push_end_txn_date,
608: 'DD-MON-YYYY HH24:MI:SS'));
609: end if;
610:
611: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates-');
612: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
613: EDW_LOG.PUT_LINE('Start Push Date for INV:'
614: || to_char(o_push_start_inv_txn_date,
615: 'DD-MON-YYYY HH24:MI:SS'));

Line 612: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));

608: 'DD-MON-YYYY HH24:MI:SS'));
609: end if;
610:
611: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates-');
612: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
613: EDW_LOG.PUT_LINE('Start Push Date for INV:'
614: || to_char(o_push_start_inv_txn_date,
615: 'DD-MON-YYYY HH24:MI:SS'));
616: EDW_LOG.PUT_LINE('Start Push Date for WIP:'

Line 613: EDW_LOG.PUT_LINE('Start Push Date for INV:'

609: end if;
610:
611: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates-');
612: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
613: EDW_LOG.PUT_LINE('Start Push Date for INV:'
614: || to_char(o_push_start_inv_txn_date,
615: 'DD-MON-YYYY HH24:MI:SS'));
616: EDW_LOG.PUT_LINE('Start Push Date for WIP:'
617: || to_char(o_push_start_wip_txn_date,

Line 616: EDW_LOG.PUT_LINE('Start Push Date for WIP:'

612: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
613: EDW_LOG.PUT_LINE('Start Push Date for INV:'
614: || to_char(o_push_start_inv_txn_date,
615: 'DD-MON-YYYY HH24:MI:SS'));
616: EDW_LOG.PUT_LINE('Start Push Date for WIP:'
617: || to_char(o_push_start_wip_txn_date,
618: 'DD-MON-YYYY HH24:MI:SS'));
619: EDW_LOG.PUT_LINE('End Push Date: '
620: || to_char(o_push_end_txn_date,

Line 619: EDW_LOG.PUT_LINE('End Push Date: '

615: 'DD-MON-YYYY HH24:MI:SS'));
616: EDW_LOG.PUT_LINE('Start Push Date for WIP:'
617: || to_char(o_push_start_wip_txn_date,
618: 'DD-MON-YYYY HH24:MI:SS'));
619: EDW_LOG.PUT_LINE('End Push Date: '
620: || to_char(o_push_end_txn_date,
621: 'DD-MON-YYYY HH24:MI:SS'));
622:
623: EXCEPTION

Line 634: EDW_LOG.PUT_LINE('No user-entered from date for initial push');

630: o_err_num := 9999;
631: o_err_msg := 'OPIMPDAT.get_push_dates ('
632: || to_char(l_stmt_num)
633: || ')';
634: EDW_LOG.PUT_LINE('No user-entered from date for initial push');
635: EDW_LOG.PUT_LINE('Org id: ' ||to_char(i_org_id));
636:
637: WHEN no_date_range THEN
638: o_err_num := 9999;

Line 635: EDW_LOG.PUT_LINE('Org id: ' ||to_char(i_org_id));

631: o_err_msg := 'OPIMPDAT.get_push_dates ('
632: || to_char(l_stmt_num)
633: || ')';
634: EDW_LOG.PUT_LINE('No user-entered from date for initial push');
635: EDW_LOG.PUT_LINE('Org id: ' ||to_char(i_org_id));
636:
637: WHEN no_date_range THEN
638: o_err_num := 9999;
639: o_err_msg := 'OPIMPDAT.get_push_dates ('

Line 642: EDW_LOG.PUT_LINE('Not a valid date range since push from date is later than push to date');

638: o_err_num := 9999;
639: o_err_msg := 'OPIMPDAT.get_push_dates ('
640: || to_char(l_stmt_num)
641: || ')';
642: EDW_LOG.PUT_LINE('Not a valid date range since push from date is later than push to date');
643: EDW_LOG.PUT_LINE('INV push start date ' || l_push_inv_start_date );
644: EDW_LOG.PUT_LINE('INV push end date ' || l_push_inv_end_date );
645: EDW_LOG.PUT_LINE('Org id: ' ||to_char(i_org_id));
646:

Line 643: EDW_LOG.PUT_LINE('INV push start date ' || l_push_inv_start_date );

639: o_err_msg := 'OPIMPDAT.get_push_dates ('
640: || to_char(l_stmt_num)
641: || ')';
642: EDW_LOG.PUT_LINE('Not a valid date range since push from date is later than push to date');
643: EDW_LOG.PUT_LINE('INV push start date ' || l_push_inv_start_date );
644: EDW_LOG.PUT_LINE('INV push end date ' || l_push_inv_end_date );
645: EDW_LOG.PUT_LINE('Org id: ' ||to_char(i_org_id));
646:
647: when others then

Line 644: EDW_LOG.PUT_LINE('INV push end date ' || l_push_inv_end_date );

640: || to_char(l_stmt_num)
641: || ')';
642: EDW_LOG.PUT_LINE('Not a valid date range since push from date is later than push to date');
643: EDW_LOG.PUT_LINE('INV push start date ' || l_push_inv_start_date );
644: EDW_LOG.PUT_LINE('INV push end date ' || l_push_inv_end_date );
645: EDW_LOG.PUT_LINE('Org id: ' ||to_char(i_org_id));
646:
647: when others then
648: o_err_num := SQLCODE;

Line 645: EDW_LOG.PUT_LINE('Org id: ' ||to_char(i_org_id));

641: || ')';
642: EDW_LOG.PUT_LINE('Not a valid date range since push from date is later than push to date');
643: EDW_LOG.PUT_LINE('INV push start date ' || l_push_inv_start_date );
644: EDW_LOG.PUT_LINE('INV push end date ' || l_push_inv_end_date );
645: EDW_LOG.PUT_LINE('Org id: ' ||to_char(i_org_id));
646:
647: when others then
648: o_err_num := SQLCODE;
649: o_err_msg := 'OPIMPDAT.get_push_dates - ('