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.CSF_MAINTAIN_GRP dependencies on FND_API

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

14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_MAINTAIN_GRP';
15:
16: PROCEDURE Validate_FieldServiceObjects(
17: P_API_VERSION IN NUMBER,
18: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
19: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
20: P_PROCESSING_SET_ID IN NUMBER,
21: P_OBJECT_TYPE IN VARCHAR2,
22: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,

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

15:
16: PROCEDURE Validate_FieldServiceObjects(
17: P_API_VERSION IN NUMBER,
18: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
19: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
20: P_PROCESSING_SET_ID IN NUMBER,
21: P_OBJECT_TYPE IN VARCHAR2,
22: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
23: X_MSG_COUNT IN OUT NOCOPY NUMBER,

Line 39: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

35:
36: SAVEPOINT Validate_FieldServiceObjects;
37:
38: -- Standard call to check for call compatibility.
39: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
40: p_api_version,
41: l_api_name,
42: G_PKG_NAME)
43: THEN

Line 44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

40: p_api_version,
41: l_api_name,
42: G_PKG_NAME)
43: THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END IF;
46:
47:
48: -- Initialize message list

Line 53: x_return_status := FND_API.G_RET_STS_SUCCESS;

49: FND_MSG_PUB.initialize;
50:
51:
52: -- Initialize API return status to SUCCESS
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55: /*
56: Validation logic
57: -----------------

Line 116: IF l_return_status = fnd_api.g_ret_sts_error THEN

112: X_RETURN_STATUS => l_return_status,
113: X_MSG_COUNT => l_msg_count,
114: X_MSG_DATA => l_msg_data);
115:
116: IF l_return_status = fnd_api.g_ret_sts_error THEN
117: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned error ');
119: END IF;
120: RAISE fnd_api.g_exc_error;

Line 120: RAISE fnd_api.g_exc_error;

116: IF l_return_status = fnd_api.g_ret_sts_error THEN
117: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned error ');
119: END IF;
120: RAISE fnd_api.g_exc_error;
121: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
122: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned unexpected error ');
124: END IF;

Line 121: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

117: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned error ');
119: END IF;
120: RAISE fnd_api.g_exc_error;
121: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
122: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned unexpected error ');
124: END IF;
125: RAISE fnd_api.g_exc_unexpected_error;

Line 125: RAISE fnd_api.g_exc_unexpected_error;

121: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
122: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'csm_sr_purge_pkg.Validate_MobileFSObjects returned unexpected error ');
124: END IF;
125: RAISE fnd_api.g_exc_unexpected_error;
126: END IF;
127:
128:
129:

Line 167: -- IF fnd_api.to_boolean(p_commit) THEN

163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after third validation ');
164: END IF;
165:
166: -- Standard check of p_commit
167: -- IF fnd_api.to_boolean(p_commit) THEN
168: -- COMMIT WORK;
169: -- END IF;
170:
171: END IF;

Line 175: WHEN fnd_api.g_exc_error THEN

171: END IF;
172:
173:
174: EXCEPTION
175: WHEN fnd_api.g_exc_error THEN
176: ROLLBACK TO Validate_FieldServiceObjects;
177: x_return_status := fnd_api.g_ret_sts_error;
178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
179:

Line 177: x_return_status := fnd_api.g_ret_sts_error;

173:
174: EXCEPTION
175: WHEN fnd_api.g_exc_error THEN
176: ROLLBACK TO Validate_FieldServiceObjects;
177: x_return_status := fnd_api.g_ret_sts_error;
178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
179:
180: WHEN fnd_api.g_exc_unexpected_error THEN
181: ROLLBACK TO Validate_FieldServiceObjects;

Line 180: WHEN fnd_api.g_exc_unexpected_error THEN

176: ROLLBACK TO Validate_FieldServiceObjects;
177: x_return_status := fnd_api.g_ret_sts_error;
178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
179:
180: WHEN fnd_api.g_exc_unexpected_error THEN
181: ROLLBACK TO Validate_FieldServiceObjects;
182: x_return_status := fnd_api.g_ret_sts_unexp_error;
183: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
184:

Line 182: x_return_status := fnd_api.g_ret_sts_unexp_error;

178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
179:
180: WHEN fnd_api.g_exc_unexpected_error THEN
181: ROLLBACK TO Validate_FieldServiceObjects;
182: x_return_status := fnd_api.g_ret_sts_unexp_error;
183: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
184:
185: WHEN OTHERS THEN
186: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 186: x_return_status := fnd_api.g_ret_sts_unexp_error;

182: x_return_status := fnd_api.g_ret_sts_unexp_error;
183: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
184:
185: WHEN OTHERS THEN
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
189: END IF;
190: ROLLBACK TO Validate_FieldServiceObjects;

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

194:
195:
196: PROCEDURE Purge_FieldServiceObjects(
197: P_API_VERSION IN NUMBER ,
198: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
199: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
200: P_PROCESSING_SET_ID IN NUMBER ,
201: P_OBJECT_TYPE IN VARCHAR2 ,
202: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,

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

195:
196: PROCEDURE Purge_FieldServiceObjects(
197: P_API_VERSION IN NUMBER ,
198: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
199: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
200: P_PROCESSING_SET_ID IN NUMBER ,
201: P_OBJECT_TYPE IN VARCHAR2 ,
202: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
203: X_MSG_COUNT IN OUT NOCOPY NUMBER,

Line 215: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

211:
212: SAVEPOINT Purge_FieldServiceObjects;
213:
214: -- Standard call to check for call compatibility.
215: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
216: p_api_version,
217: l_api_name,
218: G_PKG_NAME)
219: THEN

Line 220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

216: p_api_version,
217: l_api_name,
218: G_PKG_NAME)
219: THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:
223:
224: -- Initialize message list

Line 230: x_return_status := FND_API.G_RET_STS_SUCCESS;

226:
227: IF (nvl(P_OBJECT_TYPE, 'SR') = 'SR') then
228:
229: -- Initialize API return status to SUCCESS
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232: /* Delete Logic
233: 1 Fetch the incident ids associated to the processing set id (i/p parameter) which are marked for purge
234: 1.1 If no incident ids (for the given processing set id) require purging, Return Success

Line 778: -- IF fnd_api.to_boolean(p_commit) THEN

774: END IF;
775:
776:
777: -- Standard check of p_commit
778: -- IF fnd_api.to_boolean(p_commit) THEN
779: -- COMMIT WORK;
780: -- END IF;
781:
782: END IF;

Line 786: WHEN fnd_api.g_exc_error THEN

782: END IF;
783:
784:
785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN
787: ROLLBACK TO Purge_FieldServiceObjects;
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
790:

Line 788: x_return_status := fnd_api.g_ret_sts_error;

784:
785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN
787: ROLLBACK TO Purge_FieldServiceObjects;
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
790:
791: WHEN fnd_api.g_exc_unexpected_error THEN
792: ROLLBACK TO Purge_FieldServiceObjects;

Line 791: WHEN fnd_api.g_exc_unexpected_error THEN

787: ROLLBACK TO Purge_FieldServiceObjects;
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
790:
791: WHEN fnd_api.g_exc_unexpected_error THEN
792: ROLLBACK TO Purge_FieldServiceObjects;
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
795:

Line 793: x_return_status := fnd_api.g_ret_sts_unexp_error;

789: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
790:
791: WHEN fnd_api.g_exc_unexpected_error THEN
792: ROLLBACK TO Purge_FieldServiceObjects;
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
795:
796: WHEN OTHERS THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 797: x_return_status := fnd_api.g_ret_sts_unexp_error;

793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
795:
796: WHEN OTHERS THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error;
798: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
799: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
800: END IF;
801: ROLLBACK TO Purge_FieldServiceObjects;