APPS.CSM_TASK_PURGE_PKG dependencies on FND_LOG

Line 20: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);

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.
24: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 61: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);

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
65: ROLLBACK TO VALIDATE_MFS_TASKS;

Line 69: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_EXCEPTION);

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;
73: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 75: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_EXCEPTION);

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
79: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 83: 'CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS',FND_LOG.LEVEL_EXCEPTION);

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:
87: -- Procedure to delete MFS Tasks. No-op right now

Line 105: 'CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);

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,
109: l_api_name,G_PKG_NAME) THEN

Line 117: 'CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS',FND_LOG.LEVEL_PROCEDURE);

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);
121: l_sqlerrmsg := substr(SQLERRM, 1,256);

Line 123: l_sqlerrno || ':' || l_sqlerrmsg, FND_LOG.LEVEL_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;