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.CSM_TASK_PURGE_PKG dependencies on CSM_TASK_PURGE_PKG

Line 1: PACKAGE BODY CSM_TASK_PURGE_PKG as

1: PACKAGE BODY CSM_TASK_PURGE_PKG as
2: /* $Header: csmtkprb.pls 120.1 2005/08/26 01:46:51 skotikal noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSM_TASK_PURGE_PKG';
4:
5: PROCEDURE VALIDATE_MFS_TASKS(

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSM_TASK_PURGE_PKG';

1: PACKAGE BODY CSM_TASK_PURGE_PKG as
2: /* $Header: csmtkprb.pls 120.1 2005/08/26 01:46:51 skotikal noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSM_TASK_PURGE_PKG';
4:
5: PROCEDURE VALIDATE_MFS_TASKS(
6: P_API_VERSION IN NUMBER,
7: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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;

Line 126: END CSM_TASK_PURGE_PKG;

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;