APPS.MRP_CL_FUNCTION dependencies on MSC_UTIL

Line 68: IF MRP_CL_FUNCTION.validateUser(lv_user_id,MSC_UTIL.TASK_COLL,lv_log_msg) THEN

64: WHEN NO_DATA_FOUND THEN
65: raise_application_error (-20001, 'User not defined on Source instance');
66: END;
67:
68: IF MRP_CL_FUNCTION.validateUser(lv_user_id,MSC_UTIL.TASK_COLL,lv_log_msg) THEN
69: MRP_CL_FUNCTION.MSC_Initialize(MSC_UTIL.TASK_COLL,
70: lv_user_id,
71: -1, --l_resp_id,
72: -1 --l_application_id

Line 69: MRP_CL_FUNCTION.MSC_Initialize(MSC_UTIL.TASK_COLL,

65: raise_application_error (-20001, 'User not defined on Source instance');
66: END;
67:
68: IF MRP_CL_FUNCTION.validateUser(lv_user_id,MSC_UTIL.TASK_COLL,lv_log_msg) THEN
69: MRP_CL_FUNCTION.MSC_Initialize(MSC_UTIL.TASK_COLL,
70: lv_user_id,
71: -1, --l_resp_id,
72: -1 --l_application_id
73: );

Line 75: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_log_msg);

71: -1, --l_resp_id,
72: -1 --l_application_id
73: );
74: ELSE
75: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_log_msg);
76: raise_application_error (-20001, lv_log_msg);
77: END IF;
78:
79: END IF;

Line 1863: IF MRP_CL_FUNCTION.validateUser(l_user_id,MSC_UTIL.TASK_RELEASE,lv_log_msg) THEN

1859: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('Error in launching the concurrent request : NO_USER_DEFINED');
1860: raise_application_error (-20001, 'NO_USER_DEFINED');
1861: END;
1862:
1863: IF MRP_CL_FUNCTION.validateUser(l_user_id,MSC_UTIL.TASK_RELEASE,lv_log_msg) THEN
1864: MRP_CL_FUNCTION.MSC_Initialize(MSC_UTIL.TASK_RELEASE,
1865: l_user_id,
1866: -1, --l_resp_id,
1867: -1 --l_application_id

Line 1864: MRP_CL_FUNCTION.MSC_Initialize(MSC_UTIL.TASK_RELEASE,

1860: raise_application_error (-20001, 'NO_USER_DEFINED');
1861: END;
1862:
1863: IF MRP_CL_FUNCTION.validateUser(l_user_id,MSC_UTIL.TASK_RELEASE,lv_log_msg) THEN
1864: MRP_CL_FUNCTION.MSC_Initialize(MSC_UTIL.TASK_RELEASE,
1865: l_user_id,
1866: -1, --l_resp_id,
1867: -1 --l_application_id
1868: );

Line 1870: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_log_msg);

1866: -1, --l_resp_id,
1867: -1 --l_application_id
1868: );
1869: ELSE
1870: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_log_msg);
1871: raise_application_error (-20001, lv_log_msg);
1872: END IF;
1873:
1874:

Line 1914: IF pTASK = MSC_UTIL.TASK_COLL THEN

1910: pMESSAGE IN OUT NOCOPY varchar2)
1911: return BOOLEAN IS
1912: lv_result NUMBER := 0;
1913: BEGIN
1914: IF pTASK = MSC_UTIL.TASK_COLL THEN
1915:
1916: select 1
1917: into lv_result
1918: from fnd_responsibility resp

Line 1926: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN

1922: and resp.responsibility_key = 'APS_COLLECTIONS'
1923: and user_resp.user_id = pUSERID
1924: and rownum =1 ;
1925:
1926: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
1927:
1928: select 1
1929: into lv_result
1930: from fnd_responsibility resp,

Line 1948: IF pTASK = MSC_UTIL.TASK_COLL THEN

1944: END IF;
1945:
1946: EXCEPTION
1947: WHEN NO_DATA_FOUND THEN
1948: IF pTASK = MSC_UTIL.TASK_COLL THEN
1949: pMESSAGE := 'User not defnied or not assigned to the responsibility - ''APS COLLECTIONS''';
1950: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
1951: pMESSAGE := 'User not defnied or not assigned to the responsibility - ''APS RELEASE''';
1952: END IF;

Line 1950: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN

1946: EXCEPTION
1947: WHEN NO_DATA_FOUND THEN
1948: IF pTASK = MSC_UTIL.TASK_COLL THEN
1949: pMESSAGE := 'User not defnied or not assigned to the responsibility - ''APS COLLECTIONS''';
1950: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
1951: pMESSAGE := 'User not defnied or not assigned to the responsibility - ''APS RELEASE''';
1952: END IF;
1953: Return FALSE;
1954: WHEN OTHERS THEN

Line 1969: IF pTASK = MSC_UTIL.TASK_COLL THEN

1965: lv_resp_id NUMBER;
1966: lv_application_id NUMBER;
1967: PRAGMA AUTONOMOUS_TRANSACTION;
1968: BEGIN
1969: IF pTASK = MSC_UTIL.TASK_COLL THEN
1970:
1971: select resp.responsibility_id, resp.application_id
1972: into lv_resp_id, lv_application_id
1973: from fnd_responsibility resp,

Line 1981: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN

1977: and resp.responsibility_key = 'APS_COLLECTIONS'
1978: and user_resp.user_id = pUSERID
1979: and rownum =1 ;
1980:
1981: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
1982:
1983: select resp.responsibility_id, resp.application_id
1984: into lv_resp_id, lv_application_id
1985: from fnd_responsibility resp,

Line 1993: ELSIF pTASK = MSC_UTIL.TASK_USER_DEFINED THEN

1989: and resp.responsibility_key = 'APS_RELEASE'
1990: and user_resp.user_id = pUSERID
1991: and rownum =1 ;
1992:
1993: ELSIF pTASK = MSC_UTIL.TASK_USER_DEFINED THEN
1994:
1995: lv_resp_id := pRESPID;
1996: lv_application_id := pAPPLID;
1997:

Line 2006: IF pTASK = MSC_UTIL.TASK_COLL THEN

2002: lv_application_id);
2003: commit;
2004: EXCEPTION
2005: WHEN NO_DATA_FOUND THEN
2006: IF pTASK = MSC_UTIL.TASK_COLL THEN
2007: raise_application_error (-20001, 'User not defnied or not assigned to the responsibility - ''APS COLLECTIONS''');
2008: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
2009: raise_application_error (-20001, 'User not defnied or not assigned to the responsibility - ''APS RELEASE''');
2010: ELSE

Line 2008: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN

2004: EXCEPTION
2005: WHEN NO_DATA_FOUND THEN
2006: IF pTASK = MSC_UTIL.TASK_COLL THEN
2007: raise_application_error (-20001, 'User not defnied or not assigned to the responsibility - ''APS COLLECTIONS''');
2008: ELSIF pTASK = MSC_UTIL.TASK_RELEASE THEN
2009: raise_application_error (-20001, 'User not defnied or not assigned to the responsibility - ''APS RELEASE''');
2010: ELSE
2011: raise_application_error (-20001, 'User not defnied or not assigned to the required responsibility');
2012: END IF;

Line 2014: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unable to initialize user because of unexpected error');

2010: ELSE
2011: raise_application_error (-20001, 'User not defnied or not assigned to the required responsibility');
2012: END IF;
2013: WHEN OTHERS THEN
2014: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unable to initialize user because of unexpected error');
2015: RAISE;
2016: END;
2017:
2018: END MRP_CL_FUNCTION;