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_TASK_DEPENDENCY_PUB dependencies on FND_API

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

48: -- Standard start of API savepoint
49: SAVEPOINT csf_create_task_dependency_pub;
50:
51: -- Standard call to check for call compatibility
52: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
53: THEN
54: RAISE fnd_api.g_exc_unexpected_error;
55: END IF;
56:

Line 54: RAISE fnd_api.g_exc_unexpected_error;

50:
51: -- Standard call to check for call compatibility
52: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
53: THEN
54: RAISE fnd_api.g_exc_unexpected_error;
55: END IF;
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE
58: IF fnd_api.to_boolean (p_init_msg_list)

Line 58: IF fnd_api.to_boolean (p_init_msg_list)

54: RAISE fnd_api.g_exc_unexpected_error;
55: END IF;
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE
58: IF fnd_api.to_boolean (p_init_msg_list)
59: THEN
60: fnd_msg_pub.initialize;
61: END IF;
62:

Line 64: x_return_status := fnd_api.g_ret_sts_success;

60: fnd_msg_pub.initialize;
61: END IF;
62:
63: -- Initialize API return status to success
64: x_return_status := fnd_api.g_ret_sts_success;
65:
66: -- Calling jtf api to create dependency and validate flag will be set 'N' always
67: jtf_task_dependency_pub.create_task_dependency (
68: p_api_version => p_api_version

Line 102: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

98: , p_attribute_category => p_attribute_category
99: );
100:
101: -- check return status
102: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
103: THEN
104: RAISE fnd_api.g_exc_unexpected_error;
105: END IF;
106:

Line 104: RAISE fnd_api.g_exc_unexpected_error;

100:
101: -- check return status
102: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
103: THEN
104: RAISE fnd_api.g_exc_unexpected_error;
105: END IF;
106:
107: -- Standard check of p_commit
108: IF fnd_api.to_boolean (p_commit)

Line 108: IF fnd_api.to_boolean (p_commit)

104: RAISE fnd_api.g_exc_unexpected_error;
105: END IF;
106:
107: -- Standard check of p_commit
108: IF fnd_api.to_boolean (p_commit)
109: THEN
110:
111: COMMIT WORK;
112: END IF;

Line 117: WHEN fnd_api.g_exc_unexpected_error

113:
114: -- Standard call to get message count and if count is 1, get message info
115: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
116: EXCEPTION
117: WHEN fnd_api.g_exc_unexpected_error
118: THEN
119: ROLLBACK TO csf_create_task_dependency_pub;
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);

Line 120: x_return_status := fnd_api.g_ret_sts_unexp_error;

116: EXCEPTION
117: WHEN fnd_api.g_exc_unexpected_error
118: THEN
119: ROLLBACK TO csf_create_task_dependency_pub;
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: WHEN OTHERS
123: THEN
124: ROLLBACK TO csf_create_task_dependency_pub;

Line 127: x_return_status := fnd_api.g_ret_sts_unexp_error;

123: THEN
124: ROLLBACK TO csf_create_task_dependency_pub;
125: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
126: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
127: x_return_status := fnd_api.g_ret_sts_unexp_error;
128: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
129: END CREATE_TASK_DEPENDENCY_NV;
130:
131: PROCEDURE LOCK_TASK_DEPENDENCY (

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

145: -- Standard start of API savepoint
146: SAVEPOINT csf_lock_task_depends_pub;
147:
148: -- Standard call to check for call compatibility
149: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
150: THEN
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:

Line 151: RAISE fnd_api.g_exc_unexpected_error;

147:
148: -- Standard call to check for call compatibility
149: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
150: THEN
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:
154: -- Initialize message list if p_init_msg_list is set to TRUE
155: IF fnd_api.to_boolean (p_init_msg_list)

Line 155: IF fnd_api.to_boolean (p_init_msg_list)

151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:
154: -- Initialize message list if p_init_msg_list is set to TRUE
155: IF fnd_api.to_boolean (p_init_msg_list)
156: THEN
157: fnd_msg_pub.initialize;
158: END IF;
159:

Line 161: x_return_status := fnd_api.g_ret_sts_success;

157: fnd_msg_pub.initialize;
158: END IF;
159:
160: -- Initialize API return status to success
161: x_return_status := fnd_api.g_ret_sts_success;
162:
163: -- Calling jtf api to lock the row
164: jtf_task_dependency_pub.lock_task_dependency(
165: p_api_version => p_api_version

Line 176: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

172: , x_msg_count => x_msg_count
173: );
174:
175: -- check return status
176: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
177: THEN
178: RAISE fnd_api.g_exc_unexpected_error;
179: END IF;
180:

Line 178: RAISE fnd_api.g_exc_unexpected_error;

174:
175: -- check return status
176: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
177: THEN
178: RAISE fnd_api.g_exc_unexpected_error;
179: END IF;
180:
181: -- Standard call to get message count and if count is 1, get message info
182: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 184: WHEN fnd_api.g_exc_unexpected_error

180:
181: -- Standard call to get message count and if count is 1, get message info
182: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
183: EXCEPTION
184: WHEN fnd_api.g_exc_unexpected_error
185: THEN
186: ROLLBACK TO csf_lock_task_depends_pub;
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 187: x_return_status := fnd_api.g_ret_sts_unexp_error;

183: EXCEPTION
184: WHEN fnd_api.g_exc_unexpected_error
185: THEN
186: ROLLBACK TO csf_lock_task_depends_pub;
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
189: WHEN OTHERS
190: THEN
191: ROLLBACK TO csf_lock_task_depends_pub;

Line 194: x_return_status := fnd_api.g_ret_sts_unexp_error;

190: THEN
191: ROLLBACK TO csf_lock_task_depends_pub;
192: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
193: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
196: END LOCK_TASK_DEPENDENCY;
197:
198: PROCEDURE UPDATE_TASK_DEPENDENCY (

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

231: -- Standard start of API savepoint
232: SAVEPOINT csf_update_task_dependency_pub;
233:
234: -- Standard call to check for call compatibility
235: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
236: THEN
237: RAISE fnd_api.g_exc_unexpected_error;
238: END IF;
239:

Line 237: RAISE fnd_api.g_exc_unexpected_error;

233:
234: -- Standard call to check for call compatibility
235: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
236: THEN
237: RAISE fnd_api.g_exc_unexpected_error;
238: END IF;
239:
240: -- Initialize message list if p_init_msg_list is set to TRUE
241: IF fnd_api.to_boolean (p_init_msg_list)

Line 241: IF fnd_api.to_boolean (p_init_msg_list)

237: RAISE fnd_api.g_exc_unexpected_error;
238: END IF;
239:
240: -- Initialize message list if p_init_msg_list is set to TRUE
241: IF fnd_api.to_boolean (p_init_msg_list)
242: THEN
243: fnd_msg_pub.initialize;
244: END IF;
245:

Line 247: x_return_status := fnd_api.g_ret_sts_success;

243: fnd_msg_pub.initialize;
244: END IF;
245:
246: -- Initialize API return status to success
247: x_return_status := fnd_api.g_ret_sts_success;
248:
249: -- Calling jtf api to update dependency and validate flag will be set 'N' always
250: jtf_task_dependency_pub.update_task_dependency (
251: p_api_version => p_api_version

Line 284: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

280: , p_attribute_category => p_attribute_category
281: );
282:
283: -- check return status
284: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
285: THEN
286: RAISE fnd_api.g_exc_unexpected_error;
287: END IF;
288:

Line 286: RAISE fnd_api.g_exc_unexpected_error;

282:
283: -- check return status
284: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
285: THEN
286: RAISE fnd_api.g_exc_unexpected_error;
287: END IF;
288:
289: -- Standard check of p_commit
290: IF fnd_api.to_boolean (p_commit)

Line 290: IF fnd_api.to_boolean (p_commit)

286: RAISE fnd_api.g_exc_unexpected_error;
287: END IF;
288:
289: -- Standard check of p_commit
290: IF fnd_api.to_boolean (p_commit)
291: THEN
292: COMMIT WORK;
293: END IF;
294:

Line 298: WHEN fnd_api.g_exc_unexpected_error

294:
295: -- Standard call to get message count and if count is 1, get message info
296: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
297: EXCEPTION
298: WHEN fnd_api.g_exc_unexpected_error
299: THEN
300: ROLLBACK TO csf_update_task_dependency_pub;
301: x_return_status := fnd_api.g_ret_sts_unexp_error;
302: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 301: x_return_status := fnd_api.g_ret_sts_unexp_error;

297: EXCEPTION
298: WHEN fnd_api.g_exc_unexpected_error
299: THEN
300: ROLLBACK TO csf_update_task_dependency_pub;
301: x_return_status := fnd_api.g_ret_sts_unexp_error;
302: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
303: WHEN OTHERS
304: THEN
305: ROLLBACK TO csf_update_task_dependency_pub;

Line 308: x_return_status := fnd_api.g_ret_sts_unexp_error;

304: THEN
305: ROLLBACK TO csf_update_task_dependency_pub;
306: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
307: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
308: x_return_status := fnd_api.g_ret_sts_unexp_error;
309: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
310: END UPDATE_TASK_DEPENDENCY;
311:
312: PROCEDURE DELETE_TASK_DEPENDENCY (

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

326: -- Standard start of API savepoint
327: SAVEPOINT csf_delete_task_dependency_pub;
328:
329: -- Standard call to check for call compatibility
330: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
331: THEN
332: RAISE fnd_api.g_exc_unexpected_error;
333: END IF;
334:

Line 332: RAISE fnd_api.g_exc_unexpected_error;

328:
329: -- Standard call to check for call compatibility
330: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
331: THEN
332: RAISE fnd_api.g_exc_unexpected_error;
333: END IF;
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE
336: IF fnd_api.to_boolean (p_init_msg_list)

Line 336: IF fnd_api.to_boolean (p_init_msg_list)

332: RAISE fnd_api.g_exc_unexpected_error;
333: END IF;
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE
336: IF fnd_api.to_boolean (p_init_msg_list)
337: THEN
338: fnd_msg_pub.initialize;
339: END IF;
340:

Line 342: x_return_status := fnd_api.g_ret_sts_success;

338: fnd_msg_pub.initialize;
339: END IF;
340:
341: -- Initialize API return status to success
342: x_return_status := fnd_api.g_ret_sts_success;
343:
344: -- Calling jtf api to delete dependency
345: jtf_task_dependency_pub.delete_task_dependency (
346: p_api_version => p_api_version

Line 357: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

353: , x_msg_data => x_msg_data
354: );
355:
356: -- check return status
357: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
358: THEN
359: RAISE fnd_api.g_exc_unexpected_error;
360: END IF;
361:

Line 359: RAISE fnd_api.g_exc_unexpected_error;

355:
356: -- check return status
357: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
358: THEN
359: RAISE fnd_api.g_exc_unexpected_error;
360: END IF;
361:
362: -- Standard check of p_commit
363: IF fnd_api.to_boolean (p_commit)

Line 363: IF fnd_api.to_boolean (p_commit)

359: RAISE fnd_api.g_exc_unexpected_error;
360: END IF;
361:
362: -- Standard check of p_commit
363: IF fnd_api.to_boolean (p_commit)
364: THEN
365: COMMIT WORK;
366: END IF;
367:

Line 371: WHEN fnd_api.g_exc_unexpected_error

367:
368: -- Standard call to get message count and if count is 1, get message info
369: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
370: EXCEPTION
371: WHEN fnd_api.g_exc_unexpected_error
372: THEN
373: ROLLBACK TO csf_delete_task_dependency_pub;
374: x_return_status := fnd_api.g_ret_sts_unexp_error;
375: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 374: x_return_status := fnd_api.g_ret_sts_unexp_error;

370: EXCEPTION
371: WHEN fnd_api.g_exc_unexpected_error
372: THEN
373: ROLLBACK TO csf_delete_task_dependency_pub;
374: x_return_status := fnd_api.g_ret_sts_unexp_error;
375: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
376: WHEN OTHERS
377: THEN
378: ROLLBACK TO csf_delete_task_dependency_pub;

Line 381: x_return_status := fnd_api.g_ret_sts_unexp_error;

377: THEN
378: ROLLBACK TO csf_delete_task_dependency_pub;
379: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
380: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
381: x_return_status := fnd_api.g_ret_sts_unexp_error;
382: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
383: END DELETE_TASK_DEPENDENCY;
384:
385: PROCEDURE CLEAR_TASK_DEPENDENCIES (

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

414: -- Standard start of API savepoint
415: SAVEPOINT csf_clear_task_dependency_pub;
416:
417: -- Standard call to check for call compatibility
418: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
419: THEN
420: RAISE fnd_api.g_exc_unexpected_error;
421: END IF;
422:

Line 420: RAISE fnd_api.g_exc_unexpected_error;

416:
417: -- Standard call to check for call compatibility
418: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
419: THEN
420: RAISE fnd_api.g_exc_unexpected_error;
421: END IF;
422:
423: -- Initialize message list if p_init_msg_list is set to TRUE
424: IF fnd_api.to_boolean (p_init_msg_list)

Line 424: IF fnd_api.to_boolean (p_init_msg_list)

420: RAISE fnd_api.g_exc_unexpected_error;
421: END IF;
422:
423: -- Initialize message list if p_init_msg_list is set to TRUE
424: IF fnd_api.to_boolean (p_init_msg_list)
425: THEN
426: fnd_msg_pub.initialize;
427: END IF;
428:

Line 430: x_return_status := fnd_api.g_ret_sts_success;

426: fnd_msg_pub.initialize;
427: END IF;
428:
429: -- Initialize API return status to success
430: x_return_status := fnd_api.g_ret_sts_success;
431:
432: OPEN c_all_depends (p_task_id);
433: LOOP
434: FETCH c_all_depends INTO l_dependency_id, l_object_version_number;

Line 452: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

448: END LOOP;
449: CLOSE c_all_depends;
450:
451: -- check return status
452: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
453: THEN
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;
456:

Line 454: RAISE fnd_api.g_exc_unexpected_error;

450:
451: -- check return status
452: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
453: THEN
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;
456:
457: -- Standard check of p_commit
458: IF fnd_api.to_boolean (p_commit)

Line 458: IF fnd_api.to_boolean (p_commit)

454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;
456:
457: -- Standard check of p_commit
458: IF fnd_api.to_boolean (p_commit)
459: THEN
460: COMMIT WORK;
461: END IF;
462:

Line 466: WHEN fnd_api.g_exc_unexpected_error

462:
463: -- Standard call to get message count and if count is 1, get message info
464: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
465: EXCEPTION
466: WHEN fnd_api.g_exc_unexpected_error
467: THEN
468: ROLLBACK TO csf_clear_task_dependency_pub;
469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 469: x_return_status := fnd_api.g_ret_sts_unexp_error;

465: EXCEPTION
466: WHEN fnd_api.g_exc_unexpected_error
467: THEN
468: ROLLBACK TO csf_clear_task_dependency_pub;
469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS
472: THEN
473: ROLLBACK TO csf_clear_task_dependency_pub;

Line 476: x_return_status := fnd_api.g_ret_sts_unexp_error;

472: THEN
473: ROLLBACK TO csf_clear_task_dependency_pub;
474: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
475: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
478: END CLEAR_TASK_DEPENDENCIES;
479:
480: END CSF_TASK_DEPENDENCY_PUB;