APPS.CSM_TASK_PURGE_PKG dependencies on CSM_UTIL_PKG

Line 19: CSM_UTIL_PKG.LOG('Entering CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS ',

15: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_MFS_TASKS';
16: l_api_version_number CONSTANT NUMBER := 1.0;
17: BEGIN
18:
19: CSM_UTIL_PKG.LOG('Entering CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS ',
20: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);
21:
22: SAVEPOINT VALIDATE_MFS_TASKS;
23: -- Standard call to check for call compatibility.

Line 60: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS ',

56: nvl(purge_status, 'S') <> 'E';
57:
58: END IF ;
59:
60: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS ',
61: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);
62:
63: EXCEPTION
64: WHEN fnd_api.g_exc_error THEN

Line 68: CSM_UTIL_PKG.LOG('Error in CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',

64: WHEN fnd_api.g_exc_error THEN
65: ROLLBACK TO VALIDATE_MFS_TASKS;
66: x_return_status := fnd_api.g_ret_sts_error;
67: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
68: CSM_UTIL_PKG.LOG('Error in CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',
69: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_EXCEPTION);
70: WHEN fnd_api.g_exc_unexpected_error THEN
71: ROLLBACK TO VALIDATE_MFS_TASKS;
72: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 74: CSM_UTIL_PKG.LOG('Error in CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',

70: WHEN fnd_api.g_exc_unexpected_error THEN
71: ROLLBACK TO VALIDATE_MFS_TASKS;
72: x_return_status := fnd_api.g_ret_sts_unexp_error;
73: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
74: CSM_UTIL_PKG.LOG('Error in CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',
75: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_EXCEPTION);
76: WHEN OTHERS THEN
77: x_return_status := fnd_api.g_ret_sts_unexp_error;
78: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 82: CSM_UTIL_PKG.LOG('Error in CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',

78: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
79: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
80: END IF;
81: ROLLBACK TO VALIDATE_MFS_TASKS;
82: CSM_UTIL_PKG.LOG('Error in CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',
83: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_EXCEPTION);
84: END VALIDATE_MFS_TASKS;
85:
86:

Line 104: CSM_UTIL_PKG.LOG('Entering CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',

100: l_api_version_number CONSTANT NUMBER := 1.0;
101: l_sqlerrno NUMBER;
102: l_sqlerrmsg VARCHAR2(256);
103: BEGIN
104: CSM_UTIL_PKG.LOG('Entering CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',
105: 'CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,p_api_version,

Line 116: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',

112:
113: -- Initialize API return status to SUCCESS
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',
117: 'CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);
118: EXCEPTION
119: WHEN others THEN
120: l_sqlerrno := to_char(SQLCODE);

Line 122: csm_util_pkg.log('CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS ERROR : ' ||

118: EXCEPTION
119: WHEN others THEN
120: l_sqlerrno := to_char(SQLCODE);
121: l_sqlerrmsg := substr(SQLERRM, 1,256);
122: csm_util_pkg.log('CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS ERROR : ' ||
123: l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_EXCEPTION);
124: END DELETE_MFS_TASKS;
125:
126: END CSM_TASK_PURGE_PKG;