APPS.MSC_X_USER_EXCEP_GEN dependencies on MSC_USER_EXCEPTIONS

Line 670: MSC_USER_EXCEPTIONS ex

666: ex.LAST_UPDATE_DATE,
667: ex.REFRESH_NUMBER
668: --ex.item_planner_ntf_flag
669: from
670: MSC_USER_EXCEPTIONS ex
671: ,fnd_user fnd
672: where
673: ex.exception_id = v_exception_id
674: and ex.CREATED_BY = fnd.USER_ID;

Line 755: MSC_USER_EXCEPTIONS mse,

751: From
752: ak_attributes akattr,
753: ak_region_items AkRegItem,
754: ak_region_items_tl AkRegItemTl,
755: MSC_USER_EXCEPTIONS mse,
756: MSC_USER_EXCEPTION_COMPONENTS comp
757: where
758: mse.region_code = 'MSCUSEREXCEPTION'
759: AND mse.exception_id = v_exception_id

Line 1903: update MSC_USER_EXCEPTIONS

1899: and EXCEPTION_GROUP = -99 )
1900: where EXCEPTION_TYPE = v_exception_id
1901: and EXCEPTION_GROUP = -99;
1902:
1903: update MSC_USER_EXCEPTIONS
1904: set
1905: LAST_RUN_DATE = sysdate
1906: ,REFRESH_NUMBER = vNewExRefreshNumber
1907: ,REQUEST_ID = v_request_id

Line 3579: select MSC_USER_EXCEPTIONS_S.NEXTVAL

3575: lAttribute14 VARCHAR2(240);
3576: lAttribute15 VARCHAR2(240);
3577: lContext VARCHAR2(240);
3578: begin
3579: select MSC_USER_EXCEPTIONS_S.NEXTVAL
3580: into lexceptionId from dual;
3581:
3582: insert into MSC_USER_EXCEPTIONS(
3583: EXCEPTION_ID

Line 3582: insert into MSC_USER_EXCEPTIONS(

3578: begin
3579: select MSC_USER_EXCEPTIONS_S.NEXTVAL
3580: into lexceptionId from dual;
3581:
3582: insert into MSC_USER_EXCEPTIONS(
3583: EXCEPTION_ID
3584: ,NAME
3585: ,DESCRIPTION
3586: ,REGION_CODE

Line 3671: from MSC_USER_EXCEPTIONS

3667: ,ATTRIBUTE13
3668: ,ATTRIBUTE14
3669: ,ATTRIBUTE15
3670: ,CONTEXT
3671: from MSC_USER_EXCEPTIONS
3672: where exception_id = exceptionId;
3673:
3674:
3675: insert into MSC_USER_EXCEPTION_COMPONENTS(

Line 3966: from MSC_USER_EXCEPTIONS

3962: lExceptionDetailsId Varchar2(30);
3963:
3964: cursor wfItems is
3965: select WF_ITEM_TYPE
3966: from MSC_USER_EXCEPTIONS
3967: where EXCEPTION_ID = exceptionId;
3968:
3969:
3970: Begin

Line 4024: delete from MSC_USER_EXCEPTIONS

4020: /*
4021: delete from MSC_USER_EXCEPTION_COMPONENTS
4022: where EXCEPTION_ID = exceptionId;
4023:
4024: delete from MSC_USER_EXCEPTIONS
4025: where EXCEPTION_ID = exceptionId;
4026: */
4027:
4028: status := 1;

Line 4059: msc_user_exceptions ex

4055: -- this is called form netting engine
4056: Procedure RunCustomExcepWithNetting is
4057: cursor getExceptions is
4058: select exception_id,NAME from
4059: msc_user_exceptions ex
4060: where RECURRENCE_FLAG = '0';
4061: lExceptionId Number;
4062: lName VARCHAR2(80);
4063: lRequestId Number;

Line 4079: update msc_user_exceptions

4075: lExceptionId,
4076: NULL);
4077: if lRequestId > 0 then
4078: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launched custom exception '||lName);
4079: update msc_user_exceptions
4080: set request_id= lRequestId
4081: where exception_id = lExceptionId;
4082: else
4083: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in launching custom exceptions ');