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.CSP_SCH_INT_PVT dependencies on FND_LOG

Line 81: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

77:
78: procedure log(p_procedure in varchar2,p_message in varchar2) as
79: begin
80: --dbms_output.put_line(p_procedure||' - '||p_message);
81: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
82: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
83: 'csp.plsql.csp_sch_int_pvt.'||p_procedure,
84: p_message);
85: end if;

Line 82: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

78: procedure log(p_procedure in varchar2,p_message in varchar2) as
79: begin
80: --dbms_output.put_line(p_procedure||' - '||p_message);
81: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
82: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
83: 'csp.plsql.csp_sch_int_pvt.'||p_procedure,
84: p_message);
85: end if;
86: end;

Line 285: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

281: l_order_number number;
282:
283: BEGIN
284:
285: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
286: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
287: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
288: 'Begin');
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 286: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

282:
283: BEGIN
284:
285: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
286: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
287: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
288: 'Begin');
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
290: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

285: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
286: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
287: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
288: 'Begin');
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
290: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
291: 'p_task_id=' || p_task_id);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
293: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

288: 'Begin');
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
290: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
291: 'p_task_id=' || p_task_id);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
293: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
294: 'p_resources.count=' || p_resources.count);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
296: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

291: 'p_task_id=' || p_task_id);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
293: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
294: 'p_resources.count=' || p_resources.count);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
296: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
297: 'p_interval.latest_time=' || to_char(p_interval.latest_time, 'DD-MON-RRRR HH24:MI:SS'));
298: end if;
299:

Line 320: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

316: g_interval := p_interval;
317:
318: -- bug # 12618325
319: -- need to clear old requirement
320: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
322: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
323: 'trying to clear old requirement if it has any...');
324: end if;

Line 321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

317:
318: -- bug # 12618325
319: -- need to clear old requirement
320: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
322: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
323: 'trying to clear old requirement if it has any...');
324: end if;
325:

Line 356: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

352: and d.source_type = 'IO'
353: AND d.source_id = oola.line_id
354: and csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'PARTIALLY RECEIVED';
355:
356: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
358: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
359: 'l_partial_line = ' || l_partial_line);
360: end if;

Line 357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

353: AND d.source_id = oola.line_id
354: and csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'PARTIALLY RECEIVED';
355:
356: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
358: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
359: 'l_partial_line = ' || l_partial_line);
360: end if;
361:

Line 398: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

394: AND oola.ordered_quantity = mr.reservation_quantity
395: AND dres.source_type = 'RES'
396: AND dres.source_id = mr.reservation_id;
397:
398: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
400: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
401: 'l_fl_rcvd_lines (R or S) = ' || l_fl_rcvd_lines);
402: end if;

Line 399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

395: AND dres.source_type = 'RES'
396: AND dres.source_id = mr.reservation_id;
397:
398: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
400: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
401: 'l_fl_rcvd_lines (R or S) = ' || l_fl_rcvd_lines);
402: end if;
403:

Line 456: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

452: AND oola.ordered_quantity = mr.reservation_quantity
453: AND dres.source_type = 'RES'
454: AND dres.source_id = mr.reservation_id;
455:
456: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
458: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
459: 'l_fl_rcvd_lines (T or C) = ' || l_fl_rcvd_lines);
460: end if;

Line 457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

453: AND dres.source_type = 'RES'
454: AND dres.source_id = mr.reservation_id;
455:
456: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
458: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
459: 'l_fl_rcvd_lines (T or C) = ' || l_fl_rcvd_lines);
460: end if;
461:

Line 492: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

488: AND l.requirement_line_id = dother.requirement_line_id
489: AND dother.source_id <> dio.source_id
490: AND dother.source_id <> dres.source_id;
491:
492: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
493: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
494: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
495: 'l_fl_rcvd_multi_source = ' || l_fl_rcvd_multi_source);
496: end if;

Line 493: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

489: AND dother.source_id <> dio.source_id
490: AND dother.source_id <> dres.source_id;
491:
492: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
493: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
494: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
495: 'l_fl_rcvd_multi_source = ' || l_fl_rcvd_multi_source);
496: end if;
497:

Line 545: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

541: AND dres.source_type = 'RES'
542: AND dres.source_id = mr.reservation_id
543: );
544:
545: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
547: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
548: 'l_oth_req_line = ' || l_oth_req_line);
549: end if;

Line 546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

542: AND dres.source_id = mr.reservation_id
543: );
544:
545: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
547: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
548: 'l_oth_req_line = ' || l_oth_req_line);
549: end if;
550:

Line 599: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

595: AND dres.source_type = 'RES'
596: AND dres.source_id = mr.reservation_id
597: );
598:
599: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
600: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
601: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
602: 'l_non_src_line = ' || l_non_src_line);
603: end if;

Line 600: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

596: AND dres.source_id = mr.reservation_id
597: );
598:
599: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
600: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
601: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
602: 'l_non_src_line = ' || l_non_src_line);
603: end if;
604:

Line 642: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

638: AND d.source_type = 'IO'
639: AND d.source_id = oola.line_id
640: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
641:
642: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
643: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
644: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
645: 'l_shpd_lines = ' || l_shpd_lines);
646: end if;

Line 643: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

639: AND d.source_id = oola.line_id
640: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
641:
642: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
643: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
644: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
645: 'l_shpd_lines = ' || l_shpd_lines);
646: end if;
647:

Line 657: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

653: WHERE h.task_id = p_task_id
654: AND h.task_assignment_id = r_asgn.task_assignment_id
655: AND h.address_type IN ('R', 'S');
656:
657: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
659: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
660: 'l_tech_spec_pr = ' || l_tech_spec_pr);
661: end if;

Line 658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

654: AND h.task_assignment_id = r_asgn.task_assignment_id
655: AND h.address_type IN ('R', 'S');
656:
657: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
659: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
660: 'l_tech_spec_pr = ' || l_tech_spec_pr);
661: end if;
662:

Line 710: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

706: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
707: AND dother.requirement_line_id = l.requirement_line_id
708: AND dother.source_id <> d.source_id;
709:
710: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
711: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
712: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
713: 'l_ship_multi_src = ' || l_ship_multi_src);
714: end if;

Line 711: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

707: AND dother.requirement_line_id = l.requirement_line_id
708: AND dother.source_id <> d.source_id;
709:
710: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
711: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
712: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
713: 'l_ship_multi_src = ' || l_ship_multi_src);
714: end if;
715:

Line 754: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

750: AND d.source_id = oola.line_id
751: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
752: );
753:
754: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
755: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
756: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
757: 'l_oth_req_line = ' || l_oth_req_line);
758: end if;

Line 755: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

751: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
752: );
753:
754: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
755: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
756: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
757: 'l_oth_req_line = ' || l_oth_req_line);
758: end if;
759:

Line 799: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

795: AND d.source_id = oola.line_id
796: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
797: );
798:
799: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
800: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
801: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
802: 'l_non_src_line = ' || l_non_src_line);
803: end if;

Line 800: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

796: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
797: );
798:
799: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
800: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
801: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
802: 'l_non_src_line = ' || l_non_src_line);
803: end if;
804:

Line 821: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

817: AND d.source_type = 'IO'
818: AND csp_pick_utils.get_order_status(oel.line_id,oel.flow_status_code) in ('SHIPPED', 'EXPECTED')
819: AND d.source_id = oel.line_id;
820:
821: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
822: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
823: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
824: 'l_old_arrival_date = ' || to_char(nvl(l_old_arrival_date, sysdate), 'dd-MON-YYYY HH24:MI'));
825: end if;

Line 822: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

818: AND csp_pick_utils.get_order_status(oel.line_id,oel.flow_status_code) in ('SHIPPED', 'EXPECTED')
819: AND d.source_id = oel.line_id;
820:
821: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
822: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
823: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
824: 'l_old_arrival_date = ' || to_char(nvl(l_old_arrival_date, sysdate), 'dd-MON-YYYY HH24:MI'));
825: end if;
826:

Line 860: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

856: end if;
857: end if;
858:
859:
860: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
862: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
863: 'before making call to CLEAN_REQUIREMENT...');
864: end if;

Line 861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

857: end if;
858:
859:
860: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
862: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
863: 'before making call to CLEAN_REQUIREMENT...');
864: end if;
865:

Line 874: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

870: x_msg_count => x_msg_count,
871: x_msg_data => x_msg_data
872: );
873:
874: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
875: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
876: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
877: 'after making call to CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
878: end if;

Line 875: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

871: x_msg_data => x_msg_data
872: );
873:
874: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
875: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
876: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
877: 'after making call to CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
878: end if;
879:

Line 886: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

882: -- handle a case where cancellation of an order is failed
883: -- due to OM processing constraints
884: if x_return_status = 'C' then
885:
886: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
887: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
888: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
889: 'handle a case where cancellation of an order is failed due to OM processing constraints');
890: end if;

Line 887: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

883: -- due to OM processing constraints
884: if x_return_status = 'C' then
885:
886: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
887: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
888: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
889: 'handle a case where cancellation of an order is failed due to OM processing constraints');
890: end if;
891:

Line 907: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

903: AND d.source_type = 'IO'
904: --AND csp_pick_utils.get_order_status(oel.line_id,oel.flow_status_code) in ('SHIPPED', 'EXPECTED')
905: AND d.source_id = oel.line_id;
906:
907: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
908: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
909: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
910: 'l_old_arrival_date = ' || to_char(nvl(l_old_arrival_date, sysdate), 'dd-MON-YYYY HH24:MI'));
911: end if;

Line 908: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

904: --AND csp_pick_utils.get_order_status(oel.line_id,oel.flow_status_code) in ('SHIPPED', 'EXPECTED')
905: AND d.source_id = oel.line_id;
906:
907: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
908: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
909: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
910: 'l_old_arrival_date = ' || to_char(nvl(l_old_arrival_date, sysdate), 'dd-MON-YYYY HH24:MI'));
911: end if;
912:

Line 962: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

958: x_msg_data => x_msg_data,
959: x_msg_count => x_msg_count);
960:
961:
962: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
963: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
964: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
965: 'rollback to GET_AVAILABILITY_OPTIONS_SP');
966: end if;

Line 963: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

959: x_msg_count => x_msg_count);
960:
961:
962: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
963: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
964: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
965: 'rollback to GET_AVAILABILITY_OPTIONS_SP');
966: end if;
967:

Line 975: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

971: end if;
972:
973: CSP_SCH_INT_PVT.GET_ORGANIZATION_SUBINV(p_resources, l_resource_org_subinv , x_return_status,x_msg_data,x_msg_count);
974:
975: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
976: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
977: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
978: 'After CSP_SCH_INT_PVT.GET_ORGANIZATION_SUBINV... x_return_status=' || x_return_status);
979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 976: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

972:
973: CSP_SCH_INT_PVT.GET_ORGANIZATION_SUBINV(p_resources, l_resource_org_subinv , x_return_status,x_msg_data,x_msg_count);
974:
975: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
976: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
977: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
978: 'After CSP_SCH_INT_PVT.GET_ORGANIZATION_SUBINV... x_return_status=' || x_return_status);
979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
980: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

975: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
976: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
977: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
978: 'After CSP_SCH_INT_PVT.GET_ORGANIZATION_SUBINV... x_return_status=' || x_return_status);
979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
980: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
981: 'l_resource_org_subinv.count=' || l_resource_org_subinv.count);
982: end if;
983:

Line 990: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

986: END IF;
987:
988: CSP_SCH_INT_PVT.GET_PARTS_LIST(p_task_id,p_likelihood,l_parts_list,x_return_status,x_msg_data,x_msg_count);
989:
990: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
992: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
993: 'After CSP_SCH_INT_PVT.GET_PARTS_LIST... x_return_status=' || x_return_status);
994: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

987:
988: CSP_SCH_INT_PVT.GET_PARTS_LIST(p_task_id,p_likelihood,l_parts_list,x_return_status,x_msg_data,x_msg_count);
989:
990: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
992: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
993: 'After CSP_SCH_INT_PVT.GET_PARTS_LIST... x_return_status=' || x_return_status);
994: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
995: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 994: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

990: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
992: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
993: 'After CSP_SCH_INT_PVT.GET_PARTS_LIST... x_return_status=' || x_return_status);
994: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
995: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
996: 'l_parts_list.count=' || l_parts_list.count);
997: end if;
998:

Line 1023: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1019:
1020: IF l_parts_list.count > 0 THEN
1021: CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY(l_resource_org_subinv,l_parts_list,p_trunk,l_unavailable_list,l_final_available_list,x_return_status,x_msg_data,x_msg_count);
1022:
1023: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1024: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1025: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1026: 'After CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY... x_return_status=' || x_return_status);
1027: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1024: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1020: IF l_parts_list.count > 0 THEN
1021: CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY(l_resource_org_subinv,l_parts_list,p_trunk,l_unavailable_list,l_final_available_list,x_return_status,x_msg_data,x_msg_count);
1022:
1023: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1024: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1025: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1026: 'After CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY... x_return_status=' || x_return_status);
1027: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1028: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 1027: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1023: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1024: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1025: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1026: 'After CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY... x_return_status=' || x_return_status);
1027: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1028: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1029: 'l_unavailable_list.count=' || l_unavailable_list.count);
1030: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1031: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 1030: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1026: 'After CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY... x_return_status=' || x_return_status);
1027: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1028: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1029: 'l_unavailable_list.count=' || l_unavailable_list.count);
1030: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1031: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1032: 'l_final_available_list.count=' || l_final_available_list.count);
1033: end if;
1034:

Line 1075: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1071:
1072: if nvl(l_search_method,'SPARES') <> 'ATP' and nvl(p_warehouse,FALSE)
1073: and l_unavailable_list.count >= 1 then
1074:
1075: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1077: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1078: 'Before calling CSP_SCH_INT_PVT.SPARES_CHECK...');
1079: end if;

Line 1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1072: if nvl(l_search_method,'SPARES') <> 'ATP' and nvl(p_warehouse,FALSE)
1073: and l_unavailable_list.count >= 1 then
1074:
1075: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1077: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1078: 'Before calling CSP_SCH_INT_PVT.SPARES_CHECK...');
1079: end if;
1080:

Line 1083: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1079: end if;
1080:
1081: CSP_SCH_INT_PVT.SPARES_CHECK(l_unavailable_list,p_interval,l_available_list,l_final_unavailable_list,x_return_status,x_msg_data,x_msg_count);
1082:
1083: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1085: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1086: 'After CSP_SCH_INT_PVT.SPARES_CHECK... x_return_status=' || x_return_status);
1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1080:
1081: CSP_SCH_INT_PVT.SPARES_CHECK(l_unavailable_list,p_interval,l_available_list,l_final_unavailable_list,x_return_status,x_msg_data,x_msg_count);
1082:
1083: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1085: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1086: 'After CSP_SCH_INT_PVT.SPARES_CHECK... x_return_status=' || x_return_status);
1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1088: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1083: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1084: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1085: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1086: 'After CSP_SCH_INT_PVT.SPARES_CHECK... x_return_status=' || x_return_status);
1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1088: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1089: 'l_unavailable_list.count=' || l_unavailable_list.count);
1090: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1091: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 1090: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1086: 'After CSP_SCH_INT_PVT.SPARES_CHECK... x_return_status=' || x_return_status);
1087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1088: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1089: 'l_unavailable_list.count=' || l_unavailable_list.count);
1090: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1091: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1092: 'l_available_list.count=' || l_available_list.count);
1093: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1094: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 1093: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1089: 'l_unavailable_list.count=' || l_unavailable_list.count);
1090: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1091: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1092: 'l_available_list.count=' || l_available_list.count);
1093: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1094: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1095: 'l_final_unavailable_list.count=' || l_final_unavailable_list.count);
1096: end if;
1097:

Line 1121: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1117: and l_available_list(J).line_id = gli.req_line_id THEN
1118: l_final_available_list.extend;
1119: l_final_available_list(l_final_available_list.count) := l_available_list(J);
1120:
1121: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1123: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1124: 'Got available data... l_final_available_list.count=' || l_final_available_list.count);
1125: end if;

Line 1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1118: l_final_available_list.extend;
1119: l_final_available_list(l_final_available_list.count) := l_available_list(J);
1120:
1121: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1123: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1124: 'Got available data... l_final_available_list.count=' || l_final_available_list.count);
1125: end if;
1126:

Line 1136: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1132: END IF;
1133:
1134: CSP_SCH_INT_PVT.ELIGIBLE_RESOURCES(p_resources,l_final_available_list,l_final_unavailable_list,l_eligible_resources_list,x_return_status,x_msg_data,x_msg_count);
1135:
1136: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1138: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1139: 'After CSP_SCH_INT_PVT.ELIGIBLE_RESOURCES... x_return_status=' || x_return_status);
1140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1133:
1134: CSP_SCH_INT_PVT.ELIGIBLE_RESOURCES(p_resources,l_final_available_list,l_final_unavailable_list,l_eligible_resources_list,x_return_status,x_msg_data,x_msg_count);
1135:
1136: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1138: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1139: 'After CSP_SCH_INT_PVT.ELIGIBLE_RESOURCES... x_return_status=' || x_return_status);
1140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1141: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 1140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1136: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1137: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1138: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1139: 'After CSP_SCH_INT_PVT.ELIGIBLE_RESOURCES... x_return_status=' || x_return_status);
1140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1141: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1142: 'l_eligible_resources_list.count=' || l_eligible_resources_list.count);
1143: end if;
1144:

Line 1153: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1149: IF l_eligible_resources_list.count > 0 THEN
1150:
1151: CSP_SCH_INT_PVT.GET_TIME_COST(l_eligible_resources_list,x_options,x_return_status,x_msg_data,x_msg_count);
1152:
1153: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1155: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1156: 'After CSP_SCH_INT_PVT.GET_TIME_COST... x_return_status=' || x_return_status);
1157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1150:
1151: CSP_SCH_INT_PVT.GET_TIME_COST(l_eligible_resources_list,x_options,x_return_status,x_msg_data,x_msg_count);
1152:
1153: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1155: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1156: 'After CSP_SCH_INT_PVT.GET_TIME_COST... x_return_status=' || x_return_status);
1157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1158: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 1157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1153: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1154: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1155: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1156: 'After CSP_SCH_INT_PVT.GET_TIME_COST... x_return_status=' || x_return_status);
1157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1158: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1159: 'l_eligible_resources_list.count=' || l_eligible_resources_list.count);
1160: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1161: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',

Line 1160: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1156: 'After CSP_SCH_INT_PVT.GET_TIME_COST... x_return_status=' || x_return_status);
1157: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1158: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1159: 'l_eligible_resources_list.count=' || l_eligible_resources_list.count);
1160: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1161: 'csp.plsql.CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS',
1162: 'x_options.count=' || x_options.count);
1163: end if;
1164:

Line 2394: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2390: ,x_msg_data OUT NOCOPY VARCHAR2
2391: ,x_msg_count OUT NOCOPY NUMBER) IS
2392: BEGIN
2393:
2394: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2395: fnd_log.string(fnd_log.level_statement,
2396: 'csp.plsql.csp_sch_int_pvt.clean_material_transaction',
2397: 'in Clean_Material_Transaction procedure.. calling CLEAN_REQUIREMENT....');
2398: fnd_log.string(fnd_log.level_statement,

Line 2395: fnd_log.string(fnd_log.level_statement,

2391: ,x_msg_count OUT NOCOPY NUMBER) IS
2392: BEGIN
2393:
2394: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2395: fnd_log.string(fnd_log.level_statement,
2396: 'csp.plsql.csp_sch_int_pvt.clean_material_transaction',
2397: 'in Clean_Material_Transaction procedure.. calling CLEAN_REQUIREMENT....');
2398: fnd_log.string(fnd_log.level_statement,
2399: 'csp.plsql.csp_sch_int_pvt.clean_material_transaction',

Line 2398: fnd_log.string(fnd_log.level_statement,

2394: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2395: fnd_log.string(fnd_log.level_statement,
2396: 'csp.plsql.csp_sch_int_pvt.clean_material_transaction',
2397: 'in Clean_Material_Transaction procedure.. calling CLEAN_REQUIREMENT....');
2398: fnd_log.string(fnd_log.level_statement,
2399: 'csp.plsql.csp_sch_int_pvt.clean_material_transaction',
2400: 'p_task_assignment_id = ' || p_task_assignment_id);
2401: end if;
2402: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2414: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2410: x_msg_data => x_msg_data
2411: );
2412: */
2413:
2414: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2415: fnd_log.string(fnd_log.level_statement,
2416: 'csp.plsql.csp_sch_int_pvt.clean_material_transaction',
2417: 'leaving... x_return_status = ' || x_return_status);
2418: end if;

Line 2415: fnd_log.string(fnd_log.level_statement,

2411: );
2412: */
2413:
2414: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2415: fnd_log.string(fnd_log.level_statement,
2416: 'csp.plsql.csp_sch_int_pvt.clean_material_transaction',
2417: 'leaving... x_return_status = ' || x_return_status);
2418: end if;
2419:

Line 2485: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2481: l_shpd_lines number;
2482: BEGIN
2483: l_module_name:= 'csp.plsql.csp_sch_int_pvt.clean_requirement';
2484:
2485: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2486: fnd_log.string(fnd_log.level_statement, l_module_name,
2487: 'begin...');
2488: end if;
2489:

Line 2486: fnd_log.string(fnd_log.level_statement, l_module_name,

2482: BEGIN
2483: l_module_name:= 'csp.plsql.csp_sch_int_pvt.clean_requirement';
2484:
2485: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2486: fnd_log.string(fnd_log.level_statement, l_module_name,
2487: 'begin...');
2488: end if;
2489:
2490: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2517: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2513: AND oola.ordered_quantity = mr.reservation_quantity
2514: AND dres.source_type = 'RES'
2515: AND dres.source_id = mr.reservation_id;
2516:
2517: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2518: fnd_log.string(fnd_log.level_statement, l_module_name,
2519: 'l_fl_rcvd_lines=' || l_fl_rcvd_lines);
2520: end if;
2521:

Line 2518: fnd_log.string(fnd_log.level_statement, l_module_name,

2514: AND dres.source_type = 'RES'
2515: AND dres.source_id = mr.reservation_id;
2516:
2517: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2518: fnd_log.string(fnd_log.level_statement, l_module_name,
2519: 'l_fl_rcvd_lines=' || l_fl_rcvd_lines);
2520: end if;
2521:
2522: if l_fl_rcvd_lines > 0 then

Line 2542: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2538: AND d.source_type = 'IO'
2539: AND d.source_id = oola.line_id
2540: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
2541:
2542: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2543: fnd_log.string(fnd_log.level_statement, l_module_name,
2544: 'l_shpd_lines=' || l_shpd_lines);
2545: end if;
2546:

Line 2543: fnd_log.string(fnd_log.level_statement, l_module_name,

2539: AND d.source_id = oola.line_id
2540: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
2541:
2542: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2543: fnd_log.string(fnd_log.level_statement, l_module_name,
2544: 'l_shpd_lines=' || l_shpd_lines);
2545: end if;
2546:
2547: if l_shpd_lines > 0 then

Line 2558: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2554: LOOP
2555: FETCH get_reservations INTO l_reserv_id,l_req_details_line_id;
2556: EXIT WHEN get_reservations%NOTFOUND;
2557:
2558: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2559: fnd_log.string(fnd_log.level_statement, l_module_name,
2560: 'l_reserv_id = ' || l_reserv_id);
2561: fnd_log.string(fnd_log.level_statement, l_module_name,
2562: 'l_req_details_line_id = ' || l_req_details_line_id);

Line 2559: fnd_log.string(fnd_log.level_statement, l_module_name,

2555: FETCH get_reservations INTO l_reserv_id,l_req_details_line_id;
2556: EXIT WHEN get_reservations%NOTFOUND;
2557:
2558: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2559: fnd_log.string(fnd_log.level_statement, l_module_name,
2560: 'l_reserv_id = ' || l_reserv_id);
2561: fnd_log.string(fnd_log.level_statement, l_module_name,
2562: 'l_req_details_line_id = ' || l_req_details_line_id);
2563: fnd_log.string(fnd_log.level_statement, l_module_name,

Line 2561: fnd_log.string(fnd_log.level_statement, l_module_name,

2557:
2558: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2559: fnd_log.string(fnd_log.level_statement, l_module_name,
2560: 'l_reserv_id = ' || l_reserv_id);
2561: fnd_log.string(fnd_log.level_statement, l_module_name,
2562: 'l_req_details_line_id = ' || l_req_details_line_id);
2563: fnd_log.string(fnd_log.level_statement, l_module_name,
2564: 'before cancelling reservation');
2565: end if;

Line 2563: fnd_log.string(fnd_log.level_statement, l_module_name,

2559: fnd_log.string(fnd_log.level_statement, l_module_name,
2560: 'l_reserv_id = ' || l_reserv_id);
2561: fnd_log.string(fnd_log.level_statement, l_module_name,
2562: 'l_req_details_line_id = ' || l_req_details_line_id);
2563: fnd_log.string(fnd_log.level_statement, l_module_name,
2564: 'before cancelling reservation');
2565: end if;
2566:
2567: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,x_return_status,x_msg_data,x_msg_count);

Line 2569: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2565: end if;
2566:
2567: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,x_return_status,x_msg_data,x_msg_count);
2568:
2569: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2570: fnd_log.string(fnd_log.level_statement, l_module_name,
2571: 'after cancelling reservation... x_return_status = ' || x_return_status);
2572: end if;
2573:

Line 2570: fnd_log.string(fnd_log.level_statement, l_module_name,

2566:
2567: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,x_return_status,x_msg_data,x_msg_count);
2568:
2569: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2570: fnd_log.string(fnd_log.level_statement, l_module_name,
2571: 'after cancelling reservation... x_return_status = ' || x_return_status);
2572: end if;
2573:
2574: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2584: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2580: END IF;
2581: END LOOP;
2582: close get_reservations;
2583:
2584: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2585: fnd_log.string(fnd_log.level_statement, l_module_name,
2586: 'after reservation loop... x_return_status = ' || x_return_status);
2587: end if;
2588:

Line 2585: fnd_log.string(fnd_log.level_statement, l_module_name,

2581: END LOOP;
2582: close get_reservations;
2583:
2584: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2585: fnd_log.string(fnd_log.level_statement, l_module_name,
2586: 'after reservation loop... x_return_status = ' || x_return_status);
2587: end if;
2588:
2589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2599: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2595: LOOP
2596: FETCH get_orders INTO l_order_id ,l_req_details_line_id, l_address_type ;
2597: EXIT WHEN get_orders% NOTFOUND;
2598:
2599: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2600: fnd_log.string(fnd_log.level_statement, l_module_name,
2601: 'l_order_id = ' || l_order_id);
2602: fnd_log.string(fnd_log.level_statement, l_module_name,
2603: 'l_req_details_line_id = ' || l_req_details_line_id);

Line 2600: fnd_log.string(fnd_log.level_statement, l_module_name,

2596: FETCH get_orders INTO l_order_id ,l_req_details_line_id, l_address_type ;
2597: EXIT WHEN get_orders% NOTFOUND;
2598:
2599: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2600: fnd_log.string(fnd_log.level_statement, l_module_name,
2601: 'l_order_id = ' || l_order_id);
2602: fnd_log.string(fnd_log.level_statement, l_module_name,
2603: 'l_req_details_line_id = ' || l_req_details_line_id);
2604: end if;

Line 2602: fnd_log.string(fnd_log.level_statement, l_module_name,

2598:
2599: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2600: fnd_log.string(fnd_log.level_statement, l_module_name,
2601: 'l_order_id = ' || l_order_id);
2602: fnd_log.string(fnd_log.level_statement, l_module_name,
2603: 'l_req_details_line_id = ' || l_req_details_line_id);
2604: end if;
2605:
2606: OPEN get_order_status(l_order_id);

Line 2610: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2606: OPEN get_order_status(l_order_id);
2607: FETCH get_order_status INTO l_status;
2608: CLOSE get_order_status;
2609:
2610: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2611: fnd_log.string(fnd_log.level_statement, l_module_name,
2612: 'l_status = ' || l_status);
2613: end if;
2614:

Line 2611: fnd_log.string(fnd_log.level_statement, l_module_name,

2607: FETCH get_order_status INTO l_status;
2608: CLOSE get_order_status;
2609:
2610: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2611: fnd_log.string(fnd_log.level_statement, l_module_name,
2612: 'l_status = ' || l_status);
2613: end if;
2614:
2615: SELECT COUNT(1)

Line 2623: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2619: AND cancelled_flag = 'N'
2620: AND open_flag = 'Y'
2621: AND flow_status_code <> 'SHIPPED';
2622:
2623: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2624: fnd_log.string(fnd_log.level_statement, l_module_name,
2625: 'l_line_to_cancel = ' || l_line_to_cancel);
2626: end if;
2627:

Line 2624: fnd_log.string(fnd_log.level_statement, l_module_name,

2620: AND open_flag = 'Y'
2621: AND flow_status_code <> 'SHIPPED';
2622:
2623: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2624: fnd_log.string(fnd_log.level_statement, l_module_name,
2625: 'l_line_to_cancel = ' || l_line_to_cancel);
2626: end if;
2627:
2628: IF l_status <> 'CANCELLED'

Line 2632: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2628: IF l_status <> 'CANCELLED'
2629: and l_status <> 'CLOSED'
2630: and l_line_to_cancel > 0 THEN
2631:
2632: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2633: fnd_log.string(fnd_log.level_statement, l_module_name,
2634: 'before CANCEL_ORDER...');
2635: end if;
2636:

Line 2633: fnd_log.string(fnd_log.level_statement, l_module_name,

2629: and l_status <> 'CLOSED'
2630: and l_line_to_cancel > 0 THEN
2631:
2632: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2633: fnd_log.string(fnd_log.level_statement, l_module_name,
2634: 'before CANCEL_ORDER...');
2635: end if;
2636:
2637: CSP_SCH_INT_PVT.CANCEL_ORDER(l_order_id,x_return_status,x_msg_data,x_msg_count);

Line 2639: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2635: end if;
2636:
2637: CSP_SCH_INT_PVT.CANCEL_ORDER(l_order_id,x_return_status,x_msg_data,x_msg_count);
2638:
2639: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2640: fnd_log.string(fnd_log.level_statement, l_module_name,
2641: 'after CANCEL_ORDER... x_return_status = ' || x_return_status);
2642: end if;
2643:

Line 2640: fnd_log.string(fnd_log.level_statement, l_module_name,

2636:
2637: CSP_SCH_INT_PVT.CANCEL_ORDER(l_order_id,x_return_status,x_msg_data,x_msg_count);
2638:
2639: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2640: fnd_log.string(fnd_log.level_statement, l_module_name,
2641: 'after CANCEL_ORDER... x_return_status = ' || x_return_status);
2642: end if;
2643:
2644: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2664: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2660: LOOP
2661: FETCH get_line_details INTO l_req_details_line_id;
2662: EXIT WHEN get_line_details% NOTFOUND;
2663:
2664: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2665: fnd_log.string(fnd_log.level_statement, l_module_name,
2666: 'deleting req_line_details for l_req_details_line_id = ' || l_req_details_line_id);
2667: end if;
2668:

Line 2665: fnd_log.string(fnd_log.level_statement, l_module_name,

2661: FETCH get_line_details INTO l_req_details_line_id;
2662: EXIT WHEN get_line_details% NOTFOUND;
2663:
2664: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2665: fnd_log.string(fnd_log.level_statement, l_module_name,
2666: 'deleting req_line_details for l_req_details_line_id = ' || l_req_details_line_id);
2667: end if;
2668:
2669: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_details_line_id);

Line 2685: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2681: OPEN get_requirement_header_id;
2682: FETCH get_requirement_header_id INTO l_requirement_header_id, l_address_type;
2683: CLOSE get_requirement_header_id;
2684:
2685: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2686: fnd_log.string(fnd_log.level_statement, l_module_name,
2687: 'l_requirement_header_id = ' || l_requirement_header_id);
2688: fnd_log.string(fnd_log.level_statement, l_module_name,
2689: 'l_address_type = ' || l_address_type);

Line 2686: fnd_log.string(fnd_log.level_statement, l_module_name,

2682: FETCH get_requirement_header_id INTO l_requirement_header_id, l_address_type;
2683: CLOSE get_requirement_header_id;
2684:
2685: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2686: fnd_log.string(fnd_log.level_statement, l_module_name,
2687: 'l_requirement_header_id = ' || l_requirement_header_id);
2688: fnd_log.string(fnd_log.level_statement, l_module_name,
2689: 'l_address_type = ' || l_address_type);
2690: end if;

Line 2688: fnd_log.string(fnd_log.level_statement, l_module_name,

2684:
2685: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2686: fnd_log.string(fnd_log.level_statement, l_module_name,
2687: 'l_requirement_header_id = ' || l_requirement_header_id);
2688: fnd_log.string(fnd_log.level_statement, l_module_name,
2689: 'l_address_type = ' || l_address_type);
2690: end if;
2691:
2692: if l_requirement_header_id is not null THEN

Line 2705: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2701: l_requirement_header.resource_id := null;
2702: l_requirement_header.destination_organization_id := null;
2703: l_requirement_header.destination_subinventory := null;
2704:
2705: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2706: fnd_log.string(fnd_log.level_statement, l_module_name,
2707: 'before updating req header... ');
2708: end if;
2709:

Line 2706: fnd_log.string(fnd_log.level_statement, l_module_name,

2702: l_requirement_header.destination_organization_id := null;
2703: l_requirement_header.destination_subinventory := null;
2704:
2705: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2706: fnd_log.string(fnd_log.level_statement, l_module_name,
2707: 'before updating req header... ');
2708: end if;
2709:
2710: CSP_Requirement_Headers_PVT.Update_requirement_headers(

Line 2721: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2717: X_Msg_Count => x_msg_count,
2718: X_Msg_Data => x_msg_data
2719: );
2720:
2721: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2722: fnd_log.string(fnd_log.level_statement, l_module_name,
2723: 'after updating req header... x_return_status = ' || x_return_status);
2724: end if;
2725:

Line 2722: fnd_log.string(fnd_log.level_statement, l_module_name,

2718: X_Msg_Data => x_msg_data
2719: );
2720:
2721: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2722: fnd_log.string(fnd_log.level_statement, l_module_name,
2723: 'after updating req header... x_return_status = ' || x_return_status);
2724: end if;
2725:
2726: END IF;

Line 3681: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3677: p_required_parts.delete();
3678: p_required_parts(1).inventory_item_id := p_unavailable_list(i).item_id;
3679: p_required_parts(1).quantity := p_unavailable_list(i).quantity;
3680:
3681: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3682: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3683: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3684: 'Before calling csp_part_search_pvt.search...');
3685: end if;

Line 3682: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3678: p_required_parts(1).inventory_item_id := p_unavailable_list(i).item_id;
3679: p_required_parts(1).quantity := p_unavailable_list(i).quantity;
3680:
3681: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3682: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3683: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3684: 'Before calling csp_part_search_pvt.search...');
3685: end if;
3686:

Line 3703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

3699: l_shipping_date,
3700: l_supplied_quantity;
3701: close c_available;
3702:
3703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3705: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3706: 'After calling csp_part_search_pvt.search...');
3707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3700: l_supplied_quantity;
3701: close c_available;
3702:
3703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3705: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3706: 'After calling csp_part_search_pvt.search...');
3707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3708: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',

Line 3707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3705: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3706: 'After calling csp_part_search_pvt.search...');
3707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3708: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3709: 'l_organization_id=' || l_organization_id);
3710: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3711: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',

Line 3710: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3706: 'After calling csp_part_search_pvt.search...');
3707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3708: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3709: 'l_organization_id=' || l_organization_id);
3710: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3711: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3712: 'l_subinventory_code=' || l_subinventory_code);
3713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3714: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',

Line 3713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3709: 'l_organization_id=' || l_organization_id);
3710: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3711: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3712: 'l_subinventory_code=' || l_subinventory_code);
3713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3714: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3715: 'l_shipping_date=' || to_char(l_shipping_date, 'DD-MON-RRRR HH24:MI:SS'));
3716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3717: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',

Line 3716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3712: 'l_subinventory_code=' || l_subinventory_code);
3713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3714: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3715: 'l_shipping_date=' || to_char(l_shipping_date, 'DD-MON-RRRR HH24:MI:SS'));
3716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3717: 'csp.plsql.CSP_SCH_INT_PVT.SPARES_CHECK',
3718: 'l_supplied_quantity=' || l_supplied_quantity);
3719: end if;
3720:

Line 4545: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4541: l_res_ship_parameters CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE ;
4542: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.GET_TIME_COST' ;
4543: BEGIN
4544:
4545: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4547: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4548: 'begin...');
4549: end if;

Line 4546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4542: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.GET_TIME_COST' ;
4543: BEGIN
4544:
4545: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4547: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4548: 'begin...');
4549: end if;
4550: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4560: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4556: l_ship_count := CSP_SCH_INT_PVT.CSP_SHIP_METHOD_COUNT_TBL_TYP();
4557: l_res_ship_parameters := CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE();
4558: loop_count :=1 ;
4559:
4560: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4561: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4562: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4563: 'Starting while loop with p_eligible_resources_list.count=' || p_eligible_resources_list.count);
4564: end if;

Line 4561: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4557: l_res_ship_parameters := CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE();
4558: loop_count :=1 ;
4559:
4560: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4561: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4562: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4563: 'Starting while loop with p_eligible_resources_list.count=' || p_eligible_resources_list.count);
4564: end if;
4565:

Line 4628: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4624: l_temp_resources_list.trim(l_temp_resources_list.count);
4625: END IF;
4626: ELSE
4627:
4628: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4630: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4631: 'In else part of loop_count > 1');
4632: end if;

Line 4629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4625: END IF;
4626: ELSE
4627:
4628: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4630: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4631: 'In else part of loop_count > 1');
4632: end if;
4633:

Line 4645: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4641: l_temp_resources_list(l_temp_resources_list.count).available_date := p_eligible_resources_list(loop_count).available_date;
4642:
4643: IF p_eligible_resources_list.count =1 THEN
4644:
4645: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4647: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4648: 'Before calling CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS...');
4649: end if;

Line 4646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4642:
4643: IF p_eligible_resources_list.count =1 THEN
4644:
4645: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4647: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4648: 'Before calling CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS...');
4649: end if;
4650:

Line 4653: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4649: end if;
4650:
4651: CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS(l_temp_resources_list,l_temp_options,l_ship_count,l_res_ship_parameters,x_return_status,x_msg_data,x_msg_count);
4652:
4653: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4655: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4656: 'After calling CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS... x_return_status=' || x_return_status);
4657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4650:
4651: CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS(l_temp_resources_list,l_temp_options,l_ship_count,l_res_ship_parameters,x_return_status,x_msg_data,x_msg_count);
4652:
4653: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4655: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4656: 'After calling CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS... x_return_status=' || x_return_status);
4657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4658: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',

Line 4657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4653: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4655: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4656: 'After calling CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS... x_return_status=' || x_return_status);
4657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4658: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4659: 'After calling CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS... l_temp_options.count=' || l_temp_options.count);
4660: end if;
4661:

Line 4666: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4662: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4663: RETURN;
4664: END IF;
4665:
4666: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4667: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4668: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4669: 'Before calling BUILD_FINAL_LIST...');
4670: end if;

Line 4667: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4663: RETURN;
4664: END IF;
4665:
4666: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4667: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4668: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4669: 'Before calling BUILD_FINAL_LIST...');
4670: end if;
4671:

Line 4674: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4670: end if;
4671:
4672: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
4673:
4674: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4676: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4677: 'After calling BUILD_FINAL_LIST... x_return_status=' || x_return_status);
4678: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4671:
4672: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
4673:
4674: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4676: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4677: 'After calling BUILD_FINAL_LIST... x_return_status=' || x_return_status);
4678: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4679: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',

Line 4678: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4674: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4675: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4676: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4677: 'After calling BUILD_FINAL_LIST... x_return_status=' || x_return_status);
4678: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4679: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4680: 'After calling BUILD_FINAL_LIST... x_options.count=' || x_options.count);
4681: end if;
4682:

Line 4695: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4691: END IF;
4692: loop_count := loop_count + 1 ;
4693: END LOOP;
4694:
4695: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4697: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4698: 'Coming out of the loop...');
4699: end if;

Line 4696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4692: loop_count := loop_count + 1 ;
4693: END LOOP;
4694:
4695: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4697: 'csp.plsql.CSP_SCH_INT_PVT.GET_TIME_COST',
4698: 'Coming out of the loop...');
4699: end if;
4700:

Line 4810: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4806: l_final_resource := CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE() ;
4807: l_temp_final_resource := CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE() ;
4808: x_ship_parameters := CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE();
4809:
4810: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4811: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4812: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4813: 'Begin...');
4814: end if;

Line 4811: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4807: l_temp_final_resource := CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE() ;
4808: x_ship_parameters := CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE();
4809:
4810: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4811: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4812: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4813: 'Begin...');
4814: end if;
4815:

Line 4822: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4818: OPEN location_shipping_method_count(p_eligible_resources(I).source_org, p_eligible_resources(I).destination_location_id);
4819: FETCH location_shipping_method_count INTO l_loc_ship_method_count;
4820: CLOSE location_shipping_method_count;
4821:
4822: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4823: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4824: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4825: 'inside first for loop l_loc_ship_method_count for row I =' || l_loc_ship_method_count || '(' || I || ')');
4826: end if;

Line 4823: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4819: FETCH location_shipping_method_count INTO l_loc_ship_method_count;
4820: CLOSE location_shipping_method_count;
4821:
4822: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4823: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4824: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4825: 'inside first for loop l_loc_ship_method_count for row I =' || l_loc_ship_method_count || '(' || I || ')');
4826: end if;
4827:

Line 4840: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4836:
4837:
4838: IF do_optimize THEN
4839:
4840: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4842: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4843: 'doing do_optimize...');
4844: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4837:
4838: IF do_optimize THEN
4839:
4840: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4842: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4843: 'doing do_optimize...');
4844: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4845: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',

Line 4844: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4840: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4842: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4843: 'doing do_optimize...');
4844: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4845: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4846: 'before calling CONSOLIDATE_QUANTITIES...');
4847: end if;
4848:

Line 4851: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4847: end if;
4848:
4849: CSP_SCH_INT_PVT.CONSOLIDATE_QUANTITIES(p_eligible_resources, l_ship_quantity,x_return_status,x_msg_data,x_msg_count);
4850:
4851: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4853: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4854: 'After calling CONSOLIDATE_QUANTITIES...x_return_status=' || x_return_status);
4855: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4848:
4849: CSP_SCH_INT_PVT.CONSOLIDATE_QUANTITIES(p_eligible_resources, l_ship_quantity,x_return_status,x_msg_data,x_msg_count);
4850:
4851: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4853: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4854: 'After calling CONSOLIDATE_QUANTITIES...x_return_status=' || x_return_status);
4855: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4856: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',

Line 4855: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4851: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4853: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4854: 'After calling CONSOLIDATE_QUANTITIES...x_return_status=' || x_return_status);
4855: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4856: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4857: 'After calling CONSOLIDATE_QUANTITIES...l_ship_quantity.count=' || l_ship_quantity.count);
4858: end if;
4859:

Line 4864: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4861: return;
4862: END IF;
4863:
4864: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4865: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4866: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4867: 'before calling GET_SHIPPING_PARAMETERS...');
4868: end if;

Line 4865: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4861: return;
4862: END IF;
4863:
4864: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4865: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4866: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4867: 'before calling GET_SHIPPING_PARAMETERS...');
4868: end if;
4869:

Line 4872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4868: end if;
4869:
4870: CSP_SCH_INT_PVT.GET_SHIPPING_PARAMETERS(l_ship_quantity,l_resource_shipping_parameters,x_ship_count,x_return_status,x_msg_data,x_msg_count);
4871:
4872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4874: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4875: 'After calling GET_SHIPPING_PARAMETERS...x_return_status=' || x_return_status);
4876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4869:
4870: CSP_SCH_INT_PVT.GET_SHIPPING_PARAMETERS(l_ship_quantity,l_resource_shipping_parameters,x_ship_count,x_return_status,x_msg_data,x_msg_count);
4871:
4872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4874: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4875: 'After calling GET_SHIPPING_PARAMETERS...x_return_status=' || x_return_status);
4876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4877: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',

Line 4876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4874: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4875: 'After calling GET_SHIPPING_PARAMETERS...x_return_status=' || x_return_status);
4876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4877: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4878: 'After calling GET_SHIPPING_PARAMETERS...l_resource_shipping_parameters.count=' || l_resource_shipping_parameters.count);
4879: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4880: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',

Line 4879: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4875: 'After calling GET_SHIPPING_PARAMETERS...x_return_status=' || x_return_status);
4876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4877: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4878: 'After calling GET_SHIPPING_PARAMETERS...l_resource_shipping_parameters.count=' || l_resource_shipping_parameters.count);
4879: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4880: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4881: 'After calling GET_SHIPPING_PARAMETERS...x_ship_count.count=' || x_ship_count.count);
4882: end if;
4883:

Line 4901: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4897: FROM DUAL;
4898: END IF;
4899: END LOOP;
4900:
4901: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4903: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4904: 'greatest_available_date=' || to_char(greatest_available_date, 'DD-MON-RRRR HH24:MI:SS'));
4905: end if;

Line 4902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4898: END IF;
4899: END LOOP;
4900:
4901: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4903: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4904: 'greatest_available_date=' || to_char(greatest_available_date, 'DD-MON-RRRR HH24:MI:SS'));
4905: end if;
4906:

Line 4914: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4910: SELECT GREATEST(min_leadtime,loop_min) INTO min_leadtime FROM DUAL;
4911: SELECT GREATEST(max_leadtime,loop_max) INTO max_leadtime FROM DUAL;
4912: END LOOP;
4913:
4914: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4915: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4916: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4917: 'min_leadtime=' || min_leadtime || ', max_leadtime=' || max_leadtime);
4918: end if;

Line 4915: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4911: SELECT GREATEST(max_leadtime,loop_max) INTO max_leadtime FROM DUAL;
4912: END LOOP;
4913:
4914: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4915: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4916: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4917: 'min_leadtime=' || min_leadtime || ', max_leadtime=' || max_leadtime);
4918: end if;
4919:

Line 4931: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4927: exit;
4928: END IF;
4929: END LOOP;
4930:
4931: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4933: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4934: 'after for loop first_count=' || first_count);
4935: end if;

Line 4932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4928: END IF;
4929: END LOOP;
4930:
4931: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4933: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
4934: 'after for loop first_count=' || first_count);
4935: end if;
4936:

Line 5048: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5044: END IF;
5045: resource_count := resource_count + first_count ;
5046: END LOOP;
5047:
5048: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5050: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
5051: 'Out of while loop ...');
5052: end if;

Line 5049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5045: resource_count := resource_count + first_count ;
5046: END LOOP;
5047:
5048: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5049: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5050: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
5051: 'Out of while loop ...');
5052: end if;
5053:

Line 5068: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5064: itration := 1;
5065: loop_start := 0;
5066: I :=1;
5067:
5068: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5069: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5070: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
5071: 'another while loop ... l_temp_rec.count=' || l_temp_rec.count);
5072: end if;

Line 5069: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5065: loop_start := 0;
5066: I :=1;
5067:
5068: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5069: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5070: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
5071: 'another while loop ... l_temp_rec.count=' || l_temp_rec.count);
5072: end if;
5073:

Line 5077: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

5073:
5074: WHILE I <= l_temp_rec.count LOOP
5075: first_count := 0;
5076:
5077: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5079: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
5080: 'another while loop ... first_count=' || first_count);
5081: end if;

Line 5078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

5074: WHILE I <= l_temp_rec.count LOOP
5075: first_count := 0;
5076:
5077: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5079: 'csp.plsql.CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS',
5080: 'another while loop ... first_count=' || first_count);
5081: end if;
5082: