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

Line 41: x_return_status := fnd_api.g_ret_sts_success;

37: := 'CREATE_TASK_TEMPLATE_GROUP';
38: v_rowid VARCHAR2(24);
39: v_task_template_group_id jtf_task_temp_groups_b.task_template_group_id%TYPE;
40: BEGIN
41: x_return_status := fnd_api.g_ret_sts_success;
42: SAVEPOINT create_template_group_pvt;
43: SELECT jtf_task_temp_groups_s.nextval
44: INTO v_task_template_group_id
45: FROM dual;

Line 80: IF (fnd_api.to_boolean (p_commit))

76: p_application_id
77: );
78:
79: -- standard check of p_commit
80: IF (fnd_api.to_boolean (p_commit))
81: THEN
82: COMMIT WORK;
83: END IF;
84:

Line 87: WHEN fnd_api.g_exc_error

83: END IF;
84:
85: x_task_template_group_id := v_task_template_group_id;
86: EXCEPTION
87: WHEN fnd_api.g_exc_error
88: THEN
89: ROLLBACK TO create_template_group_pvt;
90: x_return_status := fnd_api.g_ret_sts_error;
91: fnd_msg_pub.count_and_get (

Line 90: x_return_status := fnd_api.g_ret_sts_error;

86: EXCEPTION
87: WHEN fnd_api.g_exc_error
88: THEN
89: ROLLBACK TO create_template_group_pvt;
90: x_return_status := fnd_api.g_ret_sts_error;
91: fnd_msg_pub.count_and_get (
92: p_count => x_msg_count,
93: p_data => x_msg_data
94: );

Line 95: WHEN fnd_api.g_exc_unexpected_error

91: fnd_msg_pub.count_and_get (
92: p_count => x_msg_count,
93: p_data => x_msg_data
94: );
95: WHEN fnd_api.g_exc_unexpected_error
96: THEN
97: ROLLBACK TO create_template_group_pvt;
98: x_return_status := fnd_api.g_ret_sts_unexp_error;
99: fnd_msg_pub.count_and_get (

Line 98: x_return_status := fnd_api.g_ret_sts_unexp_error;

94: );
95: WHEN fnd_api.g_exc_unexpected_error
96: THEN
97: ROLLBACK TO create_template_group_pvt;
98: x_return_status := fnd_api.g_ret_sts_unexp_error;
99: fnd_msg_pub.count_and_get (
100: p_count => x_msg_count,
101: p_data => x_msg_data
102: );

Line 106: x_return_status := fnd_api.g_ret_sts_unexp_error;

102: );
103: WHEN OTHERS
104: THEN
105: ROLLBACK TO create_template_group_pvt;
106: x_return_status := fnd_api.g_ret_sts_unexp_error;
107:
108: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
109: THEN
110: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 152: x_return_status := fnd_api.g_ret_sts_success;

148: )
149: IS
150: l_api_name VARCHAR2(30) := 'UPDATE_TASK_TEMPLATE_GROUP';
151: BEGIN
152: x_return_status := fnd_api.g_ret_sts_success;
153: SAVEPOINT update_template_group_pvt;
154: -- call locking table handler
155: jtf_task_temp_groups_pkg.lock_row (
156: p_task_template_group_id,

Line 191: IF (fnd_api.to_boolean (p_commit))

187: p_application_id
188: );
189:
190: -- standard check of p_commit
191: IF (fnd_api.to_boolean (p_commit))
192: THEN
193: COMMIT WORK;
194: END IF;
195:

Line 199: WHEN fnd_api.g_exc_error

195:
196: x_object_version_number := x_object_version_number + 1;
197:
198: EXCEPTION
199: WHEN fnd_api.g_exc_error
200: THEN
201: ROLLBACK TO update_template_group_pvt;
202: x_return_status := fnd_api.g_ret_sts_error;
203: fnd_msg_pub.count_and_get (

Line 202: x_return_status := fnd_api.g_ret_sts_error;

198: EXCEPTION
199: WHEN fnd_api.g_exc_error
200: THEN
201: ROLLBACK TO update_template_group_pvt;
202: x_return_status := fnd_api.g_ret_sts_error;
203: fnd_msg_pub.count_and_get (
204: p_count => x_msg_count,
205: p_data => x_msg_data
206: );

Line 207: WHEN fnd_api.g_exc_unexpected_error

203: fnd_msg_pub.count_and_get (
204: p_count => x_msg_count,
205: p_data => x_msg_data
206: );
207: WHEN fnd_api.g_exc_unexpected_error
208: THEN
209: ROLLBACK TO update_template_group_pvt;
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211: fnd_msg_pub.count_and_get (

Line 210: x_return_status := fnd_api.g_ret_sts_unexp_error;

206: );
207: WHEN fnd_api.g_exc_unexpected_error
208: THEN
209: ROLLBACK TO update_template_group_pvt;
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211: fnd_msg_pub.count_and_get (
212: p_count => x_msg_count,
213: p_data => x_msg_data
214: );

Line 218: x_return_status := fnd_api.g_ret_sts_unexp_error;

214: );
215: WHEN OTHERS
216: THEN
217: ROLLBACK TO update_template_group_pvt;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219:
220: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
221: THEN
222: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 241: x_return_status := fnd_api.g_ret_sts_success;

237: )
238: IS
239: l_api_name VARCHAR2(30) := 'DELETE_TASK_TEMPLATE_GROUP';
240: BEGIN
241: x_return_status := fnd_api.g_ret_sts_success;
242: SAVEPOINT delete_template_group_pvt;
243: -- call table handler to insert into jtf_tasks_temp_groups
244: jtf_task_temp_groups_pkg.delete_row (p_task_template_group_id);
245:

Line 247: IF (fnd_api.to_boolean (p_commit))

243: -- call table handler to insert into jtf_tasks_temp_groups
244: jtf_task_temp_groups_pkg.delete_row (p_task_template_group_id);
245:
246: -- standard check of p_commit
247: IF (fnd_api.to_boolean (p_commit))
248: THEN
249: COMMIT WORK;
250: END IF;
251: EXCEPTION

Line 252: WHEN fnd_api.g_exc_error

248: THEN
249: COMMIT WORK;
250: END IF;
251: EXCEPTION
252: WHEN fnd_api.g_exc_error
253: THEN
254: ROLLBACK TO delete_template_group_pvt;
255: x_return_status := fnd_api.g_ret_sts_error;
256: fnd_msg_pub.count_and_get (

Line 255: x_return_status := fnd_api.g_ret_sts_error;

251: EXCEPTION
252: WHEN fnd_api.g_exc_error
253: THEN
254: ROLLBACK TO delete_template_group_pvt;
255: x_return_status := fnd_api.g_ret_sts_error;
256: fnd_msg_pub.count_and_get (
257: p_count => x_msg_count,
258: p_data => x_msg_data
259: );

Line 260: WHEN fnd_api.g_exc_unexpected_error

256: fnd_msg_pub.count_and_get (
257: p_count => x_msg_count,
258: p_data => x_msg_data
259: );
260: WHEN fnd_api.g_exc_unexpected_error
261: THEN
262: ROLLBACK TO delete_template_group_pvt;
263: x_return_status := fnd_api.g_ret_sts_unexp_error;
264: fnd_msg_pub.count_and_get (

Line 263: x_return_status := fnd_api.g_ret_sts_unexp_error;

259: );
260: WHEN fnd_api.g_exc_unexpected_error
261: THEN
262: ROLLBACK TO delete_template_group_pvt;
263: x_return_status := fnd_api.g_ret_sts_unexp_error;
264: fnd_msg_pub.count_and_get (
265: p_count => x_msg_count,
266: p_data => x_msg_data
267: );

Line 271: x_return_status := fnd_api.g_ret_sts_unexp_error;

267: );
268: WHEN OTHERS
269: THEN
270: ROLLBACK TO delete_template_group_pvt;
271: x_return_status := fnd_api.g_ret_sts_unexp_error;
272:
273: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
274: THEN
275: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 300: DEFAULT fnd_api.g_false,

296: END dump_long_line;
297:
298: PROCEDURE get_task_template_group (
299: p_commit IN VARCHAR2
300: DEFAULT fnd_api.g_false,
301: p_task_template_group_id IN NUMBER,
302: p_template_group_name IN VARCHAR2,
303: p_source_object_type_code IN VARCHAR2,
304: p_start_date_active IN DATE,

Line 450: x_return_status := fnd_api.g_ret_sts_success;

446: END LOOP;
447: END IF;
448: END create_sql_statement;
449: BEGIN
450: x_return_status := fnd_api.g_ret_sts_success;
451: x_task_template_group.DELETE;
452:
453: IF (p_query_or_next_code = 'Q')
454: THEN

Line 627: WHEN fnd_api.g_exc_error

623: END IF;
624:
625: x_total_returned := x_task_template_group.COUNT;
626: EXCEPTION
627: WHEN fnd_api.g_exc_error
628: THEN
629: x_return_status := fnd_api.g_ret_sts_error;
630: fnd_msg_pub.count_and_get (
631: p_count => x_msg_count,

Line 629: x_return_status := fnd_api.g_ret_sts_error;

625: x_total_returned := x_task_template_group.COUNT;
626: EXCEPTION
627: WHEN fnd_api.g_exc_error
628: THEN
629: x_return_status := fnd_api.g_ret_sts_error;
630: fnd_msg_pub.count_and_get (
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );

Line 634: WHEN fnd_api.g_exc_unexpected_error

630: fnd_msg_pub.count_and_get (
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634: WHEN fnd_api.g_exc_unexpected_error
635: THEN
636: x_return_status := fnd_api.g_ret_sts_unexp_error;
637: fnd_msg_pub.count_and_get (
638: p_count => x_msg_count,

Line 636: x_return_status := fnd_api.g_ret_sts_unexp_error;

632: p_data => x_msg_data
633: );
634: WHEN fnd_api.g_exc_unexpected_error
635: THEN
636: x_return_status := fnd_api.g_ret_sts_unexp_error;
637: fnd_msg_pub.count_and_get (
638: p_count => x_msg_count,
639: p_data => x_msg_data
640: );

Line 643: x_return_status := fnd_api.g_ret_sts_unexp_error;

639: p_data => x_msg_data
640: );
641: WHEN OTHERS
642: THEN
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644:
645: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
646: THEN
647: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);