APPS.MSC_X_USER_EXCEP_GEN dependencies on MSC_ITEM_EXCEPTIONS

Line 576: --from msc_item_exceptions and msc_x_exception_details table

572: end if;
573: executeSQL;
574:
575: --delete previous exception summary and exception detail data
576: --from msc_item_exceptions and msc_x_exception_details table
577: --delete if exception definition changed or if it is for full data load
578: if vFullDataFlag = 'Y' then
579: if v_debug then
580: log_message('before DeletePreviousData' );

Line 1576: update msc_item_exceptions

1572: if v_debug then
1573: log_message('Number of records deleted from MSC_X_EXCEPTION_DETAILS ='||SQL%ROWCOUNT);
1574: end if;
1575:
1576: update msc_item_exceptions
1577: set exception_count = 0
1578: where EXCEPTION_TYPE = l_exception_id
1579: and EXCEPTION_GROUP = -99;
1580:

Line 1582: log_message('Number of records updated from MSC_ITEM_EXCEPTIONS = '||SQL%ROWCOUNT);

1578: where EXCEPTION_TYPE = l_exception_id
1579: and EXCEPTION_GROUP = -99;
1580:
1581: if v_debug then
1582: log_message('Number of records updated from MSC_ITEM_EXCEPTIONS = '||SQL%ROWCOUNT);
1583: end if;
1584:
1585: end if;
1586: End DeletePreviousData;

Line 1593: from msc_item_exceptions

1589:
1590: Procedure insertExceptionSummary(l_exception_id in number) is
1591: Cursor summaryRow is
1592: select count(*)
1593: from msc_item_exceptions
1594: where EXCEPTION_TYPE = l_exception_id
1595: and EXCEPTION_GROUP = -99;
1596: lcount NUMBER := 0;
1597: begin

Line 1603: log_message('Inserting into msc_item_exceptions. Exception_type='||l_exception_id);

1599: fetch summaryRow into lcount;
1600: close summaryRow;
1601:
1602: if lcount = 0 then
1603: log_message('Inserting into msc_item_exceptions. Exception_type='||l_exception_id);
1604: insert into msc_item_exceptions(
1605: PLAN_ID,
1606: ORGANIZATION_ID,
1607: SR_INSTANCE_ID,

Line 1604: insert into msc_item_exceptions(

1600: close summaryRow;
1601:
1602: if lcount = 0 then
1603: log_message('Inserting into msc_item_exceptions. Exception_type='||l_exception_id);
1604: insert into msc_item_exceptions(
1605: PLAN_ID,
1606: ORGANIZATION_ID,
1607: SR_INSTANCE_ID,
1608: INVENTORY_ITEM_ID,

Line 1635: log_message('Data Error. More then 1 record exist in msc_item_exceptions');

1631: v_request_id,
1632: v_company_id
1633: );
1634: elsif lcount > 1 then
1635: log_message('Data Error. More then 1 record exist in msc_item_exceptions');
1636: --rasie exception
1637: elsif lcount = 1 then
1638: if v_debug then
1639: log_message('1 record already exist already');

Line 1895: update msc_item_exceptions

1891: End deleteResolvedExceptions ;
1892:
1893: Procedure updateExceptionSummary is
1894: begin
1895: update msc_item_exceptions
1896: set EXCEPTION_COUNT = (select count(*)
1897: from msc_x_exception_details
1898: where EXCEPTION_TYPE = v_exception_id
1899: and EXCEPTION_GROUP = -99 )

Line 4001: delete from msc_item_exceptions

3997:
3998: /*delete from MSC_EXCEPTION_PREFERENCES
3999: where EXCEPTION_TYPE_LOOKUP_CODE = exceptionId; */
4000:
4001: delete from msc_item_exceptions
4002: where exception_type = exceptionId
4003: and exception_group = -99;
4004:
4005: /* delete from MSC_USER_EXCEPTION_NTFS