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

230:
231: SAVEPOINT Purge_FieldServiceObjects;
232:
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
235: p_api_version,
236: l_api_name,
237: G_PKG_NAME)
238: THEN

Line 239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

235: p_api_version,
236: l_api_name,
237: G_PKG_NAME)
238: THEN
239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
240: END IF;
241:
242:
243: -- Initialize message list

Line 249: x_return_status := FND_API.G_RET_STS_SUCCESS;

245:
246: IF (nvl(P_OBJECT_TYPE, 'SR') = 'SR') then
247:
248: -- Initialize API return status to SUCCESS
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250:
251: /* Delete Logic
252: 1 Fetch the incident ids associated to the processing set id (i/p parameter) which are marked for purge
253: 1.1 If no incident ids (for the given processing set id) require purging, Return Success

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

673: END IF;
674:
675:
676: -- Standard check of p_commit
677: -- IF fnd_api.to_boolean(p_commit) THEN
678: -- COMMIT WORK;
679: -- END IF;
680:
681: END IF;

Line 685: WHEN fnd_api.g_exc_error THEN

681: END IF;
682:
683:
684: EXCEPTION
685: WHEN fnd_api.g_exc_error THEN
686: ROLLBACK TO Purge_FieldServiceObjects;
687: x_return_status := fnd_api.g_ret_sts_error;
688: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
689:

Line 687: x_return_status := fnd_api.g_ret_sts_error;

683:
684: EXCEPTION
685: WHEN fnd_api.g_exc_error THEN
686: ROLLBACK TO Purge_FieldServiceObjects;
687: x_return_status := fnd_api.g_ret_sts_error;
688: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
689:
690: WHEN fnd_api.g_exc_unexpected_error THEN
691: ROLLBACK TO Purge_FieldServiceObjects;

Line 690: WHEN fnd_api.g_exc_unexpected_error THEN

686: ROLLBACK TO Purge_FieldServiceObjects;
687: x_return_status := fnd_api.g_ret_sts_error;
688: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
689:
690: WHEN fnd_api.g_exc_unexpected_error THEN
691: ROLLBACK TO Purge_FieldServiceObjects;
692: x_return_status := fnd_api.g_ret_sts_unexp_error;
693: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
694:

Line 692: x_return_status := fnd_api.g_ret_sts_unexp_error;

688: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
689:
690: WHEN fnd_api.g_exc_unexpected_error THEN
691: ROLLBACK TO Purge_FieldServiceObjects;
692: x_return_status := fnd_api.g_ret_sts_unexp_error;
693: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
694:
695: WHEN OTHERS THEN
696: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 696: x_return_status := fnd_api.g_ret_sts_unexp_error;

692: x_return_status := fnd_api.g_ret_sts_unexp_error;
693: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
694:
695: WHEN OTHERS THEN
696: x_return_status := fnd_api.g_ret_sts_unexp_error;
697: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
698: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
699: END IF;
700: ROLLBACK TO Purge_FieldServiceObjects;