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

Line 58: x_return_status := fnd_api.g_ret_sts_success;

54: BEGIN
55:
56: SAVEPOINT sp_create_group_org;
57:
58: x_return_status := fnd_api.g_ret_sts_success;
59:
60: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
61: RAISE fnd_api.g_exc_unexpected_error;
62: END IF;

Line 60: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

56: SAVEPOINT sp_create_group_org;
57:
58: x_return_status := fnd_api.g_ret_sts_success;
59:
60: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
61: RAISE fnd_api.g_exc_unexpected_error;
62: END IF;
63:
64: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 61: RAISE fnd_api.g_exc_unexpected_error;

57:
58: x_return_status := fnd_api.g_ret_sts_success;
59:
60: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
61: RAISE fnd_api.g_exc_unexpected_error;
62: END IF;
63:
64: IF fnd_api.to_boolean(p_init_msg_list) THEN
65: fnd_msg_pub.initialize;

Line 64: IF fnd_api.to_boolean(p_init_msg_list) THEN

60: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
61: RAISE fnd_api.g_exc_unexpected_error;
62: END IF;
63:
64: IF fnd_api.to_boolean(p_init_msg_list) THEN
65: fnd_msg_pub.initialize;
66: END IF;
67:
68: /* Call the private API to do validations and data processing */

Line 96: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

92: X_MSG_COUNT => X_MSG_COUNT,
93: X_MSG_DATA => X_MSG_DATA
94: );
95:
96: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
97: RAISE fnd_api.g_exc_unexpected_error;
98: END IF;
99:
100: IF fnd_api.to_boolean(p_commit) THEN

Line 97: RAISE fnd_api.g_exc_unexpected_error;

93: X_MSG_DATA => X_MSG_DATA
94: );
95:
96: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
97: RAISE fnd_api.g_exc_unexpected_error;
98: END IF;
99:
100: IF fnd_api.to_boolean(p_commit) THEN
101: COMMIT WORK;

Line 100: IF fnd_api.to_boolean(p_commit) THEN

96: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
97: RAISE fnd_api.g_exc_unexpected_error;
98: END IF;
99:
100: IF fnd_api.to_boolean(p_commit) THEN
101: COMMIT WORK;
102: END IF;
103:
104: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 108: WHEN fnd_api.g_exc_unexpected_error THEN

104: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
105:
106: EXCEPTION
107:
108: WHEN fnd_api.g_exc_unexpected_error THEN
109: ROLLBACK TO sp_create_group_org;
110: x_return_status := fnd_api.g_ret_sts_unexp_error;
111: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
112:

Line 110: x_return_status := fnd_api.g_ret_sts_unexp_error;

106: EXCEPTION
107:
108: WHEN fnd_api.g_exc_unexpected_error THEN
109: ROLLBACK TO sp_create_group_org;
110: x_return_status := fnd_api.g_ret_sts_unexp_error;
111: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
112:
113: WHEN OTHERS THEN
114: ROLLBACK TO sp_create_group_org;

Line 120: x_return_status := fnd_api.g_ret_sts_unexp_error;

116: fnd_message.set_token('P_SQLCODE',SQLCODE);
117: fnd_message.set_token('P_SQLERRM',SQLERRM);
118: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
119: FND_MSG_PUB.add;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
122:
123: END create_group_org;
124:

Line 163: x_return_status := fnd_api.g_ret_sts_success;

159: BEGIN
160:
161: SAVEPOINT sp_update_group_org;
162:
163: x_return_status := fnd_api.g_ret_sts_success;
164:
165: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
166: RAISE fnd_api.g_exc_unexpected_error;
167: END IF;

Line 165: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

161: SAVEPOINT sp_update_group_org;
162:
163: x_return_status := fnd_api.g_ret_sts_success;
164:
165: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
166: RAISE fnd_api.g_exc_unexpected_error;
167: END IF;
168:
169: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 166: RAISE fnd_api.g_exc_unexpected_error;

162:
163: x_return_status := fnd_api.g_ret_sts_success;
164:
165: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
166: RAISE fnd_api.g_exc_unexpected_error;
167: END IF;
168:
169: IF fnd_api.to_boolean(p_init_msg_list) THEN
170: fnd_msg_pub.initialize;

Line 169: IF fnd_api.to_boolean(p_init_msg_list) THEN

165: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
166: RAISE fnd_api.g_exc_unexpected_error;
167: END IF;
168:
169: IF fnd_api.to_boolean(p_init_msg_list) THEN
170: fnd_msg_pub.initialize;
171: END IF;
172:
173: /* Call the private API to do validations and data processing */

Line 202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

198: X_MSG_COUNT => X_MSG_COUNT,
199: X_MSG_DATA => X_MSG_DATA
200: );
201:
202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
203: RAISE fnd_api.g_exc_unexpected_error;
204: END IF;
205:
206: IF fnd_api.to_boolean(p_commit) THEN

Line 203: RAISE fnd_api.g_exc_unexpected_error;

199: X_MSG_DATA => X_MSG_DATA
200: );
201:
202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
203: RAISE fnd_api.g_exc_unexpected_error;
204: END IF;
205:
206: IF fnd_api.to_boolean(p_commit) THEN
207: COMMIT WORK;

Line 206: IF fnd_api.to_boolean(p_commit) THEN

202: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
203: RAISE fnd_api.g_exc_unexpected_error;
204: END IF;
205:
206: IF fnd_api.to_boolean(p_commit) THEN
207: COMMIT WORK;
208: END IF;
209:
210: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 214: WHEN fnd_api.g_exc_unexpected_error THEN

210: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
211:
212: EXCEPTION
213:
214: WHEN fnd_api.g_exc_unexpected_error THEN
215: ROLLBACK TO sp_update_group_org;
216: x_return_status := fnd_api.g_ret_sts_unexp_error;
217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
218:

Line 216: x_return_status := fnd_api.g_ret_sts_unexp_error;

212: EXCEPTION
213:
214: WHEN fnd_api.g_exc_unexpected_error THEN
215: ROLLBACK TO sp_update_group_org;
216: x_return_status := fnd_api.g_ret_sts_unexp_error;
217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
218:
219: WHEN OTHERS THEN
220: ROLLBACK TO sp_update_group_org;

Line 226: x_return_status := fnd_api.g_ret_sts_unexp_error;

222: fnd_message.set_token('P_SQLCODE',SQLCODE);
223: fnd_message.set_token('P_SQLERRM',SQLERRM);
224: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
225: FND_MSG_PUB.add;
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
228:
229: END update_group_org;
230:

Line 252: x_return_status := fnd_api.g_ret_sts_success;

248: BEGIN
249:
250: SAVEPOINT sp_delete_group_org;
251:
252: x_return_status := fnd_api.g_ret_sts_success;
253:
254: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;

Line 254: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

250: SAVEPOINT sp_delete_group_org;
251:
252: x_return_status := fnd_api.g_ret_sts_success;
253:
254: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;
257:
258: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 255: RAISE fnd_api.g_exc_unexpected_error;

251:
252: x_return_status := fnd_api.g_ret_sts_success;
253:
254: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;
257:
258: IF fnd_api.to_boolean(p_init_msg_list) THEN
259: fnd_msg_pub.initialize;

Line 258: IF fnd_api.to_boolean(p_init_msg_list) THEN

254: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;
257:
258: IF fnd_api.to_boolean(p_init_msg_list) THEN
259: fnd_msg_pub.initialize;
260: END IF;
261:
262: /* Call the private API to do validations and data processing */

Line 275: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

271: X_MSG_COUNT => X_MSG_COUNT,
272: X_MSG_DATA => X_MSG_DATA
273: );
274:
275: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
276: RAISE fnd_api.g_exc_unexpected_error;
277: END IF;
278:
279: IF fnd_api.to_boolean(p_commit) THEN

Line 276: RAISE fnd_api.g_exc_unexpected_error;

272: X_MSG_DATA => X_MSG_DATA
273: );
274:
275: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
276: RAISE fnd_api.g_exc_unexpected_error;
277: END IF;
278:
279: IF fnd_api.to_boolean(p_commit) THEN
280: COMMIT WORK;

Line 279: IF fnd_api.to_boolean(p_commit) THEN

275: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
276: RAISE fnd_api.g_exc_unexpected_error;
277: END IF;
278:
279: IF fnd_api.to_boolean(p_commit) THEN
280: COMMIT WORK;
281: END IF;
282:
283: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 287: WHEN fnd_api.g_exc_unexpected_error THEN

283: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
284:
285: EXCEPTION
286:
287: WHEN fnd_api.g_exc_unexpected_error THEN
288: ROLLBACK TO sp_delete_group_org;
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
291:

Line 289: x_return_status := fnd_api.g_ret_sts_unexp_error;

285: EXCEPTION
286:
287: WHEN fnd_api.g_exc_unexpected_error THEN
288: ROLLBACK TO sp_delete_group_org;
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
291:
292: WHEN OTHERS THEN
293: ROLLBACK TO sp_delete_group_org;

Line 299: x_return_status := fnd_api.g_ret_sts_unexp_error;

295: fnd_message.set_token('P_SQLCODE',SQLCODE);
296: fnd_message.set_token('P_SQLERRM',SQLERRM);
297: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
298: FND_MSG_PUB.add;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
301:
302: END delete_group_org;
303: