eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SCH_WB dependencies on MSC_SCH_WB

Line 1: PACKAGE BODY msc_sch_wb AS

1: PACKAGE BODY msc_sch_wb AS
2: /* $Header: MSCOSCWB.pls 120.6.12010000.1 2008/11/18 00:35:16 cmsops ship $ */
3:
4:
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');

Line 424: msc_sch_wb.atp_debug ( 'get_alloc_rule_variables : TWO rules are being used');

420: begin
421: IF (MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF = 'Y' AND
422: MSC_ATP_PVT.G_PF_RULE_OUTSIDE_ATF = 'Y') THEN
423:
424: msc_sch_wb.atp_debug ( 'get_alloc_rule_variables : TWO rules are being used');
425:
426: msc_sch_wb.atp_debug(' MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF '
427: ||MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF );
428:

Line 426: msc_sch_wb.atp_debug(' MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF '

422: MSC_ATP_PVT.G_PF_RULE_OUTSIDE_ATF = 'Y') THEN
423:
424: msc_sch_wb.atp_debug ( 'get_alloc_rule_variables : TWO rules are being used');
425:
426: msc_sch_wb.atp_debug(' MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF '
427: ||MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF );
428:
429: msc_sch_wb.atp_debug('MSC_ATP_PVT.G_PF_RULE_OUTSIDE_ATF ' ||
430: MSC_ATP_PVT.G_PF_RULE_OUTSIDE_ATF);

Line 429: msc_sch_wb.atp_debug('MSC_ATP_PVT.G_PF_RULE_OUTSIDE_ATF ' ||

425:
426: msc_sch_wb.atp_debug(' MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF '
427: ||MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF );
428:
429: msc_sch_wb.atp_debug('MSC_ATP_PVT.G_PF_RULE_OUTSIDE_ATF ' ||
430: MSC_ATP_PVT.G_PF_RULE_OUTSIDE_ATF);
431: return 1; -- I will need to display two allocation rules in the library
432: ELSIF
433: (MSC_ATP_PVT.G_MEM_RULE_WITHIN_ATF <> 'Y' AND

Line 507: msc_sch_wb.atp_debug('****Begin Get_Supply_Sources_Local');

503: cto_exists NUMBER :=0;
504: BEGIN
505:
506: IF PG_DEBUG in ('Y', 'C') THEN
507: msc_sch_wb.atp_debug('****Begin Get_Supply_Sources_Local');
508: END IF;
509:
510: OPEN cto_related_case(x_session_id);
511: FETCH cto_related_case INTO cto_exists;

Line 522: msc_sch_wb.atp_debug('RAC Instance id is:' || l_node_id);

518: from gv$instance;
519: IF l_rac_count > 1 then
520: l_node_id := userenv('INSTANCE');
521: IF PG_DEBUG in ('Y', 'C') THEN
522: msc_sch_wb.atp_debug('RAC Instance id is:' || l_node_id);
523: END IF;
524: ELSE
525: l_node_id := null;
526: END IF;

Line 532: msc_sch_wb.atp_debug('node id is:' || l_node_id);

528: WHEN OTHERS THEN
529: l_node_id := null;
530: END;
531: IF PG_DEBUG in ('Y', 'C') THEN
532: msc_sch_wb.atp_debug('node id is:' || l_node_id);
533: END IF;
534: --bug3610706 end
535: IF PG_DEBUG in ('Y', 'C') THEN
536: msc_sch_wb.atp_debug(' get_supply_sources_local: cto_related_case : ' ||

Line 536: msc_sch_wb.atp_debug(' get_supply_sources_local: cto_related_case : ' ||

532: msc_sch_wb.atp_debug('node id is:' || l_node_id);
533: END IF;
534: --bug3610706 end
535: IF PG_DEBUG in ('Y', 'C') THEN
536: msc_sch_wb.atp_debug(' get_supply_sources_local: cto_related_case : ' ||
537: cto_exists);
538: END IF;
539:
540:

Line 543: msc_sch_wb.atp_debug(' get_supply_sources_local ' ||

539:
540:
541: IF cto_exists = 1 THEN
542: IF PG_DEBUG in ('Y', 'C') THEN
543: msc_sch_wb.atp_debug(' get_supply_sources_local ' ||
544: ' calling MSC_ATP_UTILS.Update_line_item_properties');
545: END IF;
546:
547: MSC_ATP_UTILS.Update_Line_Item_Properties(p_session_id => x_session_id);

Line 555: msc_sch_wb.atp_debug( 'get_supply_sources_local '||

551: p_instance_id => x_sr_instance_id,
552: x_return_status => l_return_status);
553: IF l_return_status <> 'S' THEN
554: IF PG_DEBUG in ('Y', 'C') THEN
555: msc_sch_wb.atp_debug( 'get_supply_sources_local '||
556: ' sth wrong was in MSC_ATP_CTO. Match_CTO_Lines '||
557: ' error is '||
558: l_return_status );
559: END IF;

Line 569: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_dynstring : ' || l_dynstring);

565: IF x_dblink IS NOT NULL AND x_calling_inst = 'APPS' THEN
566: l_dynstring := '@'||x_dblink;
567: END IF;
568: IF PG_DEBUG in ('Y', 'C') THEN
569: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_dynstring : ' || l_dynstring);
570: END IF;
571:
572: -- savirine, Sep 06, 2001: added the get_regions call to get the get_regions info which will be used for ATP request.
573:

Line 590: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_calling_module : ' || l_calling_module);

586: WHERE mast.session_id = x_session_id
587: AND status_flag = 4;
588:
589: IF PG_DEBUG in ('Y', 'C') THEN
590: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_calling_module : ' || l_calling_module);
591: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_customer_site_id : ' || l_customer_site_id);
592: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_assignment_set_id : ' || x_assignment_set_id);
593: END IF;
594:

Line 591: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_customer_site_id : ' || l_customer_site_id);

587: AND status_flag = 4;
588:
589: IF PG_DEBUG in ('Y', 'C') THEN
590: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_calling_module : ' || l_calling_module);
591: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_customer_site_id : ' || l_customer_site_id);
592: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_assignment_set_id : ' || x_assignment_set_id);
593: END IF;
594:
595: MSC_SATP_FUNC.Get_Regions (

Line 592: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_assignment_set_id : ' || x_assignment_set_id);

588:
589: IF PG_DEBUG in ('Y', 'C') THEN
590: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_calling_module : ' || l_calling_module);
591: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'l_customer_site_id : ' || l_customer_site_id);
592: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_assignment_set_id : ' || x_assignment_set_id);
593: END IF;
594:
595: MSC_SATP_FUNC.Get_Regions (
596: p_customer_site_id => l_customer_site_id,

Line 605: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'Get_Regions, return status : ' || l_return_status);

601: p_dblink => x_dblink,
602: x_return_status => l_return_status );
603:
604: IF PG_DEBUG in ('Y', 'C') THEN
605: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'Get_Regions, return status : ' || l_return_status);
606: END IF;
607:
608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
609: -- something wrong so we want to rollback;

Line 611: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'expected error in Call to Get_Regions');

607:
608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
609: -- something wrong so we want to rollback;
610: IF PG_DEBUG in ('Y', 'C') THEN
611: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'expected error in Call to Get_Regions');
612: END IF;
613: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
614: IF PG_DEBUG in ('Y', 'C') THEN
615: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'something wrong in Call to Get_Regions');

Line 615: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'something wrong in Call to Get_Regions');

611: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'expected error in Call to Get_Regions');
612: END IF;
613: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
614: IF PG_DEBUG in ('Y', 'C') THEN
615: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'something wrong in Call to Get_Regions');
616: END IF;
617: END IF;
618: --bug3610706 pass the node to the remote call in case of RAC
619: sql_stmt :=

Line 625: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'sql_stmt : ' || sql_stmt);

621: '(:session_id, :instance_id, :assgn_id, '||
622: ' :plan_id, :inst,:l_ret_status, :l_error_mesg,:node_id); end;';
623:
624: IF PG_DEBUG in ('Y', 'C') THEN
625: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'sql_stmt : ' || sql_stmt);
626: END IF;
627:
628: execute immediate sql_stmt using x_session_id, x_sr_instance_id,
629: x_assignment_set_id, x_plan_id, x_calling_inst,

Line 647: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'inside DBLINK_NOT_OPEN');

643: rows_processed := dbms_sql.execute(l_cursor);
644: EXCEPTION
645: WHEN DBLINK_NOT_OPEN THEN
646: IF PG_DEBUG in ('Y', 'C') THEN
647: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'inside DBLINK_NOT_OPEN');
648: END IF;
649: END;
650: end if;
651:

Line 653: msc_sch_wb.atp_debug('get_supply_sources_local: ' || ' After calling PATPB');

649: END;
650: end if;
651:
652: IF PG_DEBUG in ('Y', 'C') THEN
653: msc_sch_wb.atp_debug('get_supply_sources_local: ' || ' After calling PATPB');
654: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_error_mesg := ' || x_error_mesg);
655: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_ret_status := ' || x_ret_status);
656: END IF;
657: END get_supply_sources_local;

Line 654: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_error_mesg := ' || x_error_mesg);

650: end if;
651:
652: IF PG_DEBUG in ('Y', 'C') THEN
653: msc_sch_wb.atp_debug('get_supply_sources_local: ' || ' After calling PATPB');
654: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_error_mesg := ' || x_error_mesg);
655: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_ret_status := ' || x_ret_status);
656: END IF;
657: END get_supply_sources_local;
658:

Line 655: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_ret_status := ' || x_ret_status);

651:
652: IF PG_DEBUG in ('Y', 'C') THEN
653: msc_sch_wb.atp_debug('get_supply_sources_local: ' || ' After calling PATPB');
654: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_error_mesg := ' || x_error_mesg);
655: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'x_ret_status := ' || x_ret_status);
656: END IF;
657: END get_supply_sources_local;
658:
659:

Line 713: msc_sch_wb.atp_debug('get_atp_rule_name: ' || 'inside DBLINK_NOT_OPEN');

709: rows_processed := dbms_sql.execute(l_cursor);
710: EXCEPTION
711: WHEN DBLINK_NOT_OPEN THEN
712: IF PG_DEBUG in ('Y', 'C') THEN
713: msc_sch_wb.atp_debug('get_atp_rule_name: ' || 'inside DBLINK_NOT_OPEN');
714: END IF;
715: END;
716: end if;
717:

Line 798: msc_sch_wb.atp_debug(' get_msc_assign_set dblink '||l_dblink);

794:
795: IF x_dblink IS NOT NULL THEN
796: l_dblink := '@'||x_dblink;
797: IF PG_DEBUG in ('Y', 'C') THEN
798: msc_sch_wb.atp_debug(' get_msc_assign_set dblink '||l_dblink);
799: END IF;
800: END IF;
801:
802: sqlstring :=

Line 872: msc_sch_wb.atp_debug(' get_assignment_set dblink '||l_dblink);

868:
869: IF x_dblink IS NOT NULL THEN
870: l_dblink := '@'||x_dblink;
871: IF PG_DEBUG in ('Y', 'C') THEN
872: msc_sch_wb.atp_debug(' get_assignment_set dblink '||l_dblink);
873: END IF;
874: END IF;
875:
876:

Line 909: msc_sch_wb.atp_debug('get_assignment_set: ' || 'inside DBLINK_NOT_OPEN');

905: rows_processed := dbms_sql.execute(l_cursor);
906: EXCEPTION
907: WHEN DBLINK_NOT_OPEN THEN
908: IF PG_DEBUG in ('Y', 'C') THEN
909: msc_sch_wb.atp_debug('get_assignment_set: ' || 'inside DBLINK_NOT_OPEN');
910: END IF;
911: END;
912: end if;
913:

Line 1192: msc_sch_wb.atp_debug('get_period_atp_strings: ' || ' count '||x_atp_period_string.total_supply_quantity.COUNT);

1188: OR pegging_id = p_pegging_id)
1189: order by period_start_date;
1190:
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: msc_sch_wb.atp_debug('get_period_atp_strings: ' || ' count '||x_atp_period_string.total_supply_quantity.COUNT);
1193: END IF;
1194:
1195:
1196: ELSE -- if allocated

Line 1252: msc_sch_wb.atp_debug('get_period_atp_strings: ' || ' count '||x_atp_period_string.total_supply_quantity.COUNT);

1248: end if;
1249:
1250:
1251: IF PG_DEBUG in ('Y', 'C') THEN
1252: msc_sch_wb.atp_debug('get_period_atp_strings: ' || ' count '||x_atp_period_string.total_supply_quantity.COUNT);
1253: END IF;
1254:
1255: END IF; -- if not allocated
1256:

Line 1275: msc_sch_wb.atp_debug('get_period_atp_strings: ' || '$$$ '||v_week_start_date||' '||v_week_end_date||' '||v_period_start_date||' '||v_period_end_date);

1271: v_week_end_date := x_atp_period_string.period_end_date(x_atp_period_string.period_end_date.count);
1272: v_period_end_date := v_week_end_date;
1273: IF order_sch_wb.mr_debug = 'Y' THEN
1274: IF PG_DEBUG in ('Y', 'C') THEN
1275: msc_sch_wb.atp_debug('get_period_atp_strings: ' || '$$$ '||v_week_start_date||' '||v_week_end_date||' '||v_period_start_date||' '||v_period_end_date);
1276: END IF;
1277: END IF;
1278:
1279:

Line 1381: msc_sch_wb.atp_debug('get_period_atp_strings: ' || ' excp in get_period_strings '||substr(Sqlerrm, 1, 100));

1377: END IF;
1378: EXCEPTION
1379: WHEN OTHERS THEN
1380: IF PG_DEBUG in ('Y', 'C') THEN
1381: msc_sch_wb.atp_debug('get_period_atp_strings: ' || ' excp in get_period_strings '||substr(Sqlerrm, 1, 100));
1382: END IF;
1383:
1384: IF wk_cur%isopen THEN
1385: CLOSE wk_cur;

Line 1424: msc_sch_wb.atp_debug(' Inside calc_exceptions '||p_session_id);

1420: BEGIN
1421: x_return_status := 'S';
1422:
1423: IF PG_DEBUG in ('Y', 'C') THEN
1424: msc_sch_wb.atp_debug(' Inside calc_exceptions '||p_session_id);
1425: END IF;
1426:
1427: UPDATE mrp_atp_schedule_temp mast
1428: set

Line 1466: msc_sch_wb.atp_debug(' After update in calc_exceptions ');

1462: AND scenario_id = 1
1463: AND status_flag = 2;
1464:
1465: IF PG_DEBUG in ('Y', 'C') THEN
1466: msc_sch_wb.atp_debug(' After update in calc_exceptions ');
1467: END IF;
1468:
1469: COMMIT;
1470:

Line 1613: --msc_sch_wb.atp_debug(' b4 sending mesg '||p_message);

1609: dbms_pipe.unpack_message(p_message);
1610: dbms_pipe.purge('OMERROR-'||p_session_id);
1611:
1612: ELSIF p_command = 'SEND' THEN
1613: --msc_sch_wb.atp_debug(' b4 sending mesg '||p_message);
1614: p_message := Nvl(p_message,fnd_date.date_to_canonical(Sysdate));
1615:
1616: dbms_pipe.pack_message(p_message);
1617: ret := dbms_pipe.send_message('session-'||p_session_id, 0); -- 0 implies no block

Line 1621: -- msc_sch_wb.atp_debug('pipe_utility: ' || ' ERROR/Warning : ret code when sending message '||ret);

1617: ret := dbms_pipe.send_message('session-'||p_session_id, 0); -- 0 implies no block
1618: IF ret <> 0 THEN
1619: IF PG_DEBUG in ('Y', 'C') THEN
1620: null;
1621: -- msc_sch_wb.atp_debug('pipe_utility: ' || ' ERROR/Warning : ret code when sending message '||ret);
1622: END IF;
1623: END IF;
1624: IF PG_DEBUG in ('Y', 'C') THEN
1625: msc_sch_wb.atp_debug('pipe_utility: ' || ' sent mesg '||p_message);

Line 1625: msc_sch_wb.atp_debug('pipe_utility: ' || ' sent mesg '||p_message);

1621: -- msc_sch_wb.atp_debug('pipe_utility: ' || ' ERROR/Warning : ret code when sending message '||ret);
1622: END IF;
1623: END IF;
1624: IF PG_DEBUG in ('Y', 'C') THEN
1625: msc_sch_wb.atp_debug('pipe_utility: ' || ' sent mesg '||p_message);
1626: END IF;
1627: ELSIF p_command = 'RECEIVE' THEN
1628: p_message := NULL;
1629: ret := dbms_pipe.receive_message('session-'||p_session_id, 0);

Line 1633: -- msc_sch_wb.atp_debug('pipe_utility: ' || ' ERROR/Warning : ret code when recv message '||ret);

1629: ret := dbms_pipe.receive_message('session-'||p_session_id, 0);
1630: IF ret <> 0 THEN
1631: IF PG_DEBUG in ('Y', 'C') THEN
1632: null;
1633: -- msc_sch_wb.atp_debug('pipe_utility: ' || ' ERROR/Warning : ret code when recv message '||ret);
1634: END IF;
1635: END IF;
1636:
1637: -- When 'END' is sent then it means that ATP is done

Line 1736: msc_sch_wb.atp_debug(' get_profile '||l_atp_link);

1732:
1733: -- l_atp_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');
1734: MSC_SATP_FUNC.get_dblink_profile(l_atp_link, l_instance_id, l_return_status);
1735: IF PG_DEBUG in ('Y', 'C') THEN
1736: msc_sch_wb.atp_debug(' get_profile '||l_atp_link);
1737: END IF;
1738: IF l_atp_link IS NOT NULL THEN
1739: sqlstmt := sqlstmt||'@'||l_atp_link;
1740: END IF;

Line 1744: msc_sch_wb.atp_debug(' get_profile '||sqlstmt);

1740: END IF;
1741: sqlstmt := sqlstmt||'('''||profile_name||'''); END; ';
1742:
1743: IF PG_DEBUG in ('Y', 'C') THEN
1744: msc_sch_wb.atp_debug(' get_profile '||sqlstmt);
1745: END IF;
1746: execute immediate sqlstmt using OUT profile_value;
1747:
1748: IF l_atp_link IS NOT NULL then

Line 1763: msc_sch_wb.atp_debug('get_profile: ' || 'inside DBLINK_NOT_OPEN');

1759: rows_processed := dbms_sql.execute(l_cursor);
1760: EXCEPTION
1761: WHEN DBLINK_NOT_OPEN THEN
1762: IF PG_DEBUG in ('Y', 'C') THEN
1763: msc_sch_wb.atp_debug('get_profile: ' || 'inside DBLINK_NOT_OPEN');
1764: END IF;
1765: END;
1766: end if;
1767:

Line 1769: msc_sch_wb.atp_debug(' get_profile '||profile_value);

1765: END;
1766: end if;
1767:
1768: IF PG_DEBUG in ('Y', 'C') THEN
1769: msc_sch_wb.atp_debug(' get_profile '||profile_value);
1770: END IF;
1771: END get_profile;
1772:
1773: PROCEDURE get_session_id(p_db_link in varchar2 default NULL,p_session_id out NoCopy varchar2 ) IS

Line 1789: sql_stmt := 'begin msc_sch_wb.get_session_id'||l_db_link||'(:l_null_db_link,:p_session_id); end;';

1785: from dual;
1786: else
1787: l_db_link := '@'||p_db_link;
1788: --sql_stmt := ' select mrp_atp_schedule_temp_s.nextval from dual@'||p_db_link;
1789: sql_stmt := 'begin msc_sch_wb.get_session_id'||l_db_link||'(:l_null_db_link,:p_session_id); end;';
1790: EXECUTE IMMEDIATE sql_stmt using l_null_db_link, out p_session_id;
1791:
1792: l_cursor := dbms_sql.open_cursor;
1793: commit;

Line 1800: msc_sch_wb.atp_debug('get_session_id: ' || 'inside DBLINK_NOT_OPEN');

1796: rows_processed := dbms_sql.execute(l_cursor);
1797: EXCEPTION
1798: WHEN DBLINK_NOT_OPEN THEN
1799: IF PG_DEBUG in ('Y', 'C') THEN
1800: msc_sch_wb.atp_debug('get_session_id: ' || 'inside DBLINK_NOT_OPEN');
1801: END IF;
1802: END;
1803:
1804: end if;

Line 1809: x_atp_err_code := MSC_SCH_WB.G_ATP_ERROR_CODE ;

1805: END get_session_id;
1806:
1807: PROCEDURE get_g_atp_error_code (x_atp_err_code OUT NoCopy NUMBER) IS
1808: BEGIN
1809: x_atp_err_code := MSC_SCH_WB.G_ATP_ERROR_CODE ;
1810: END get_g_atp_error_code;
1811:
1812: PROCEDURE update_constraint_path(p_session_id IN NUMBER,
1813: p_return_error IN OUT NoCopy VARCHAR2) IS

Line 1840: msc_sch_wb.atp_debug('l_end_peg_id_list in update_constr ' ||

1836: END LOOP;
1837: CLOSE get_constr_peg_id;
1838:
1839: IF PG_DEBUG in ('Y', 'C') THEN
1840: msc_sch_wb.atp_debug('l_end_peg_id_list in update_constr ' ||
1841: l_end_peg_id_list);
1842: END IF;
1843:
1844: IF l_end_peg_id <> '-1' THEN

Line 1869: msc_sch_wb.atp_debug('Excp in update_constraint_path '||

1865: END IF;
1866: EXCEPTION
1867: WHEN OTHERS THEN
1868: IF PG_DEBUG in ('Y', 'C') THEN
1869: msc_sch_wb.atp_debug('Excp in update_constraint_path '||
1870: Substr(Sqlerrm, 1,100));
1871: p_return_error := 'E';
1872: END IF;
1873:

Line 1929: msc_sch_wb.atp_debug('Excp in msc_sch_wb.get_ato_comp_details '||

1925:
1926: EXCEPTION
1927: WHEN OTHERS THEN
1928: IF PG_DEBUG in ('Y', 'C') THEN
1929: msc_sch_wb.atp_debug('Excp in msc_sch_wb.get_ato_comp_details '||
1930: Substr(Sqlerrm, 1,100));
1931: END IF;
1932:
1933:

Line 1937: END msc_sch_wb;

1933:
1934: END get_ato_comp_details;
1935:
1936:
1937: END msc_sch_wb;