DBA Data[Home] [Help]

APPS.CSM_SR_PURGE_PKG dependencies on FND_API

Line 8: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSM_SR_PURGE_PKG';
5:
6: PROCEDURE Validate_MobileFSObjects(
7: P_API_VERSION IN NUMBER,
8: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
9: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
10: P_PROCESSING_SET_ID IN NUMBER,
11: P_OBJECT_TYPE IN VARCHAR2,
12: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,

Line 9: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

5:
6: PROCEDURE Validate_MobileFSObjects(
7: P_API_VERSION IN NUMBER,
8: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
9: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
10: P_PROCESSING_SET_ID IN NUMBER,
11: P_OBJECT_TYPE IN VARCHAR2,
12: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
13: X_MSG_COUNT IN OUT NOCOPY NUMBER,

Line 25: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

21: 'CSM_SR_PURGE_PKG.Validate_MobileFSObjects',FND_LOG.LEVEL_PROCEDURE);
22:
23: SAVEPOINT Validate_MFServiceObjects;
24: -- Standard call to check for call compatibility.
25: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
26: p_api_version,
27: l_api_name,
28: G_PKG_NAME) THEN
29: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 29: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

25: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
26: p_api_version,
27: l_api_name,
28: G_PKG_NAME) THEN
29: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
30: END IF;
31:
32: -- Initialize message list
33: FND_MSG_PUB.initialize;

Line 35: x_return_status := FND_API.G_RET_STS_SUCCESS;

31:
32: -- Initialize message list
33: FND_MSG_PUB.initialize;
34: -- Initialize API return status to SUCCESS
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37: /*VALIDATION logic
38: -----------------
39: 1) Check if the incident ids associated to the processing set id

Line 65: WHEN fnd_api.g_exc_error THEN

61: CSM_UTIL_PKG.LOG('Leaving CSM_SR_PURGE_PKG.Validate_MobileFSObjects ',
62: 'CSM_SR_PURGE_PKG.Validate_MobileFSObjects',FND_LOG.LEVEL_PROCEDURE);
63:
64: EXCEPTION
65: WHEN fnd_api.g_exc_error THEN
66: ROLLBACK TO Validate_MFServiceObjects;
67: x_return_status := fnd_api.g_ret_sts_error;
68: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
69: CSM_UTIL_PKG.LOG('Error in CSM_SR_PURGE_PKG.Validate_MobileFSObjects',

Line 67: x_return_status := fnd_api.g_ret_sts_error;

63:
64: EXCEPTION
65: WHEN fnd_api.g_exc_error THEN
66: ROLLBACK TO Validate_MFServiceObjects;
67: x_return_status := fnd_api.g_ret_sts_error;
68: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
69: CSM_UTIL_PKG.LOG('Error in CSM_SR_PURGE_PKG.Validate_MobileFSObjects',
70: 'CSM_SR_PURGE_PKG.Validate_MobileFSObjects',FND_LOG.LEVEL_EXCEPTION);
71: WHEN fnd_api.g_exc_unexpected_error THEN

Line 71: WHEN fnd_api.g_exc_unexpected_error THEN

67: x_return_status := fnd_api.g_ret_sts_error;
68: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
69: CSM_UTIL_PKG.LOG('Error in CSM_SR_PURGE_PKG.Validate_MobileFSObjects',
70: 'CSM_SR_PURGE_PKG.Validate_MobileFSObjects',FND_LOG.LEVEL_EXCEPTION);
71: WHEN fnd_api.g_exc_unexpected_error THEN
72: ROLLBACK TO Validate_MFServiceObjects;
73: x_return_status := fnd_api.g_ret_sts_unexp_error;
74: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
75: CSM_UTIL_PKG.LOG('Error in CSM_SR_PURGE_PKG.Validate_MobileFSObjects',

Line 73: x_return_status := fnd_api.g_ret_sts_unexp_error;

69: CSM_UTIL_PKG.LOG('Error in CSM_SR_PURGE_PKG.Validate_MobileFSObjects',
70: 'CSM_SR_PURGE_PKG.Validate_MobileFSObjects',FND_LOG.LEVEL_EXCEPTION);
71: WHEN fnd_api.g_exc_unexpected_error THEN
72: ROLLBACK TO Validate_MFServiceObjects;
73: x_return_status := fnd_api.g_ret_sts_unexp_error;
74: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
75: CSM_UTIL_PKG.LOG('Error in CSM_SR_PURGE_PKG.Validate_MobileFSObjects',
76: 'CSM_SR_PURGE_PKG.Validate_MobileFSObjects',FND_LOG.LEVEL_EXCEPTION);
77: WHEN OTHERS THEN

Line 78: x_return_status := fnd_api.g_ret_sts_unexp_error;

74: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
75: CSM_UTIL_PKG.LOG('Error in CSM_SR_PURGE_PKG.Validate_MobileFSObjects',
76: 'CSM_SR_PURGE_PKG.Validate_MobileFSObjects',FND_LOG.LEVEL_EXCEPTION);
77: WHEN OTHERS THEN
78: x_return_status := fnd_api.g_ret_sts_unexp_error;
79: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
80: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
81: END IF;
82: ROLLBACK TO Validate_MFServiceObjects;

Line 92: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

88: -- Procedure to delete MFS SRs. No-op right now as the SRs are purged
89: -- from csm_incidents_all_acc during JTM: Purge Program.
90: PROCEDURE Delete_MobileFSObjects(
91: P_API_VERSION IN NUMBER ,
92: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
93: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
94: P_PROCESSING_SET_ID IN NUMBER ,
95: P_OBJECT_TYPE IN VARCHAR2 ,
96: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,

Line 93: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

89: -- from csm_incidents_all_acc during JTM: Purge Program.
90: PROCEDURE Delete_MobileFSObjects(
91: P_API_VERSION IN NUMBER ,
92: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
93: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
94: P_PROCESSING_SET_ID IN NUMBER ,
95: P_OBJECT_TYPE IN VARCHAR2 ,
96: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
97: X_MSG_COUNT IN OUT NOCOPY NUMBER,

Line 109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,p_api_version,

105: CSM_UTIL_PKG.LOG('Entering CSM_SR_PURGE_PKG.Delete_MobileFSObjects',
106: 'CSM_SR_PURGE_PKG.Delete_MobileFSObjects',FND_LOG.LEVEL_PROCEDURE);
107:
108: -- Standard call to check for call compatibility.
109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,p_api_version,
110: l_api_name,G_PKG_NAME) THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113:

Line 111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

107:
108: -- Standard call to check for call compatibility.
109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,p_api_version,
110: l_api_name,G_PKG_NAME) THEN
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113:
114: -- Initialize API return status to SUCCESS
115: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 115: x_return_status := FND_API.G_RET_STS_SUCCESS;

111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113:
114: -- Initialize API return status to SUCCESS
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:
117: CSM_UTIL_PKG.LOG('Leaving CSM_SR_PURGE_PKG.Delete_MobileFSObjects',
118: 'CSM_SR_PURGE_PKG.Delete_MobileFSObjects',FND_LOG.LEVEL_PROCEDURE);
119: EXCEPTION