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_X_USER_EXCEP_GEN dependencies on MSC_X_EXCEPTION_DETAILS

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 911: v_InsertStmt := ' Insert into MSC_X_EXCEPTION_DETAILS( '|| DetColumnNameList(i);

907: */
908: if DetColumnNameList(i) is not null then
909:
910: if v_InsertStmt is null then
911: v_InsertStmt := ' Insert into MSC_X_EXCEPTION_DETAILS( '|| DetColumnNameList(i);
912: v_ValueStmt := ' VALUES (:A'||to_char(num1) ;
913: else
914: v_InsertStmt := v_InsertStmt ||','||DetColumnNameList(i);
915: v_ValueStmt := v_ValueStmt ||','||':A'||to_char(num1);

Line 940: v_InsertStmt := ' Insert into MSC_X_EXCEPTION_DETAILS( '||

936: end if;
937:
938:
939: if v_InsertStmt is null then
940: v_InsertStmt := ' Insert into MSC_X_EXCEPTION_DETAILS( '||
941: l_colStr;
942: v_ValueStmt := ' VALUES (:A'||to_char(num1) ;
943: else
944: v_InsertStmt := v_InsertStmt || ','||l_colStr;

Line 1546: from msc_x_exception_details

1542: Procedure DeletePreviousData( l_exception_id in number) is
1543:
1544: cursor detailIds is
1545: select to_char(exception_Detail_id)
1546: from msc_x_exception_details
1547: where EXCEPTION_TYPE = l_exception_id
1548: and EXCEPTION_GROUP = -99;
1549:
1550: lExceptionDetailsId Varchar2(30);

Line 1569: delete from msc_x_exception_details

1565: end loop;
1566: close detailIds;
1567: end if;
1568:
1569: delete from msc_x_exception_details
1570: where EXCEPTION_TYPE = l_exception_id
1571: and EXCEPTION_GROUP = -99;
1572: if v_debug then
1573: log_message('Number of records deleted from MSC_X_EXCEPTION_DETAILS ='||SQL%ROWCOUNT);

Line 1573: log_message('Number of records deleted from MSC_X_EXCEPTION_DETAILS ='||SQL%ROWCOUNT);

1569: delete from msc_x_exception_details
1570: where EXCEPTION_TYPE = l_exception_id
1571: and EXCEPTION_GROUP = -99;
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

Line 1754: select msc_x_exception_details_s.nextval into v_EXCEPTION_DETAIL_ID(i) from dual;

1750: v_CREATED_BY(i) := v_user_id ;
1751: v_CREATION_DATE(i) := vLastUpdateDate;
1752: v_LAST_UPDATED_BY(i) := v_user_id;
1753: v_LAST_UPDATE_DATE(i) := vLastUpdateDate;
1754: select msc_x_exception_details_s.nextval into v_EXCEPTION_DETAIL_ID(i) from dual;
1755: vExceptionTypeArray(i) := v_exception_id;
1756: vExceptionTypeNameArray(i) := v_exception_name;
1757: vExceptionGroupArray(i) := -99;
1758: vExceptionGroupNameArray(i) := vExceptionGroupName;

Line 1780: log_message('deleting record form msc_x_exception_details');

1776: -- returned by present run but already exist in exception details
1777: begin
1778: if vFullDataFlag <> 'Y' and
1779: vGroupByFlag <> 'Y' then
1780: log_message('deleting record form msc_x_exception_details');
1781: if vCompanyIdIncluded then
1782: for i in 0..v_NumRows loop
1783: delete from msc_x_exception_details
1784: where EXCEPTION_TYPE = v_exception_id

Line 1783: delete from msc_x_exception_details

1779: vGroupByFlag <> 'Y' then
1780: log_message('deleting record form msc_x_exception_details');
1781: if vCompanyIdIncluded then
1782: for i in 0..v_NumRows loop
1783: delete from msc_x_exception_details
1784: where EXCEPTION_TYPE = v_exception_id
1785: and EXCEPTION_GROUP = -99
1786: and TRANSACTION_ID1 = vTransactionId1(i);
1787: end loop;

Line 1790: delete from msc_x_exception_details

1786: and TRANSACTION_ID1 = vTransactionId1(i);
1787: end loop;
1788: elsif vSupplierIdIncluded Then
1789: for i in 0..v_NumRows loop
1790: delete from msc_x_exception_details
1791: where EXCEPTION_TYPE = v_exception_id
1792: and EXCEPTION_GROUP = -99
1793: and TRANSACTION_ID2 = vTransactionId2(i);
1794: end loop;

Line 1797: delete from msc_x_exception_details

1793: and TRANSACTION_ID2 = vTransactionId2(i);
1794: end loop;
1795: elsif vCustomerIdIncluded Then
1796: for i in 0..v_NumRows loop
1797: delete from msc_x_exception_details
1798: where EXCEPTION_TYPE = v_exception_id
1799: and EXCEPTION_GROUP = -99
1800: and TRANSACTION_ID3 = vTransactionId3(i);
1801: end loop;

Line 1873: lDeletSqlStr := 'delete from msc_x_exception_details edtl where edtl.exception_type = :lExceptionType '||

1869: lTransactionIdDetName1 := 'transaction_id2';
1870: lFromView := ' from msc_sup_dem_ent_custom_ex_v CUSTOMER';
1871: end if;
1872:
1873: lDeletSqlStr := 'delete from msc_x_exception_details edtl where edtl.exception_type = :lExceptionType '||
1874: ' and edtl.exception_group = -99 and edtl.last_update_date <> :vLastUpdateDate '||
1875: ' and edtl.'||lTransactionIdDetName1||' in '||
1876: ' ( select '||lviewName||'.'||'transaction_id '|| lFromView ||' where '||v_addedWhereClause ||
1877: ')';

Line 1897: from msc_x_exception_details

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 )
1900: where EXCEPTION_TYPE = v_exception_id
1901: and EXCEPTION_GROUP = -99;

Line 3957: from msc_x_exception_details

3953: status OUT NOCOPY NUMBER,
3954: returnMessage OUT NOCOPY VARCHAR2) IS
3955: cursor detailIds is
3956: select to_char(exception_Detail_id)
3957: from msc_x_exception_details
3958: where EXCEPTION_TYPE = exceptionId
3959: and EXCEPTION_GROUP = -99;
3960:
3961: lItemType VARCHAR2(8);

Line 3994: delete from msc_x_exception_details

3990: close detailIds;
3991: end if;
3992:
3993:
3994: delete from msc_x_exception_details
3995: where exception_type = exceptionId
3996: and exception_group = -99;
3997:
3998: /*delete from MSC_EXCEPTION_PREFERENCES