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

Line 5: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1: PACKAGE BODY jtf_task_recurrences_pub AS
2: /* $Header: jtfptkub.pls 115.25 2002/12/06 02:00:23 sachoudh ship $ */
3: PROCEDURE create_task_recurrence (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_task_id IN NUMBER DEFAULT NULL,
8: p_task_number IN VARCHAR2 DEFAULT NULL,
9: p_occurs_which IN INTEGER DEFAULT NULL,

Line 6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2: /* $Header: jtfptkub.pls 115.25 2002/12/06 02:00:23 sachoudh ship $ */
3: PROCEDURE create_task_recurrence (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_task_id IN NUMBER DEFAULT NULL,
8: p_task_number IN VARCHAR2 DEFAULT NULL,
9: p_occurs_which IN INTEGER DEFAULT NULL,
10: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,

Line 69: x_return_status := fnd_api.g_ret_sts_success;

65: FROM jtf_task_recur_rules
66: WHERE ROWID = l_rowid;
67: BEGIN
68: SAVEPOINT create_task_recurrence_pub;
69: x_return_status := fnd_api.g_ret_sts_success;
70:
71: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
72: THEN
73: RAISE fnd_api.g_exc_unexpected_error;

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

67: BEGIN
68: SAVEPOINT create_task_recurrence_pub;
69: x_return_status := fnd_api.g_ret_sts_success;
70:
71: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
72: THEN
73: RAISE fnd_api.g_exc_unexpected_error;
74: END IF;
75:

Line 73: RAISE fnd_api.g_exc_unexpected_error;

69: x_return_status := fnd_api.g_ret_sts_success;
70:
71: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
72: THEN
73: RAISE fnd_api.g_exc_unexpected_error;
74: END IF;
75:
76: IF fnd_api.to_boolean (p_init_msg_list)
77: THEN

Line 76: IF fnd_api.to_boolean (p_init_msg_list)

72: THEN
73: RAISE fnd_api.g_exc_unexpected_error;
74: END IF;
75:
76: IF fnd_api.to_boolean (p_init_msg_list)
77: THEN
78: fnd_msg_pub.initialize;
79: END IF;
80:

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

88: p_task_number => p_task_number,
89: x_task_id => l_task_id
90: );
91:
92: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
93: THEN
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: RAISE fnd_api.g_exc_unexpected_error;
96: END IF;

Line 94: x_return_status := fnd_api.g_ret_sts_unexp_error;

90: );
91:
92: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
93: THEN
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: RAISE fnd_api.g_exc_unexpected_error;
96: END IF;
97:
98:

Line 95: RAISE fnd_api.g_exc_unexpected_error;

91:
92: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
93: THEN
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: RAISE fnd_api.g_exc_unexpected_error;
96: END IF;
97:
98:
99:

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

104: p_task_number => p_task_number,
105: x_task_id => l_task_id
106: );
107:
108: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
109: THEN
110: x_return_status := fnd_api.g_ret_sts_unexp_error;
111: RAISE fnd_api.g_exc_unexpected_error;
112: END IF;

Line 110: x_return_status := fnd_api.g_ret_sts_unexp_error;

106: );
107:
108: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
109: THEN
110: x_return_status := fnd_api.g_ret_sts_unexp_error;
111: RAISE fnd_api.g_exc_unexpected_error;
112: END IF;
113: END IF;
114:

Line 111: RAISE fnd_api.g_exc_unexpected_error;

107:
108: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
109: THEN
110: x_return_status := fnd_api.g_ret_sts_unexp_error;
111: RAISE fnd_api.g_exc_unexpected_error;
112: END IF;
113: END IF;
114:
115: IF l_task_id IS NULL

Line 117: x_return_status := fnd_api.g_ret_sts_unexp_error;

113: END IF;
114:
115: IF l_task_id IS NULL
116: THEN
117: x_return_status := fnd_api.g_ret_sts_unexp_error;
118: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
119: fnd_msg_pub.add;
120: RAISE fnd_api.g_exc_unexpected_error;
121: END IF;

Line 120: RAISE fnd_api.g_exc_unexpected_error;

116: THEN
117: x_return_status := fnd_api.g_ret_sts_unexp_error;
118: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
119: fnd_msg_pub.add;
120: RAISE fnd_api.g_exc_unexpected_error;
121: END IF;
122:
123:
124: jtf_task_recurrences_pvt.create_task_recurrence (

Line 170: IF (x_return_status = fnd_api.g_ret_sts_error)

166: p_friday => p_friday,
167: p_saturday => p_saturday
168: );
169:
170: IF (x_return_status = fnd_api.g_ret_sts_error)
171: THEN
172: RAISE fnd_api.g_exc_error;
173: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
174: THEN

Line 172: RAISE fnd_api.g_exc_error;

168: );
169:
170: IF (x_return_status = fnd_api.g_ret_sts_error)
171: THEN
172: RAISE fnd_api.g_exc_error;
173: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
174: THEN
175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;

Line 173: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

169:
170: IF (x_return_status = fnd_api.g_ret_sts_error)
171: THEN
172: RAISE fnd_api.g_exc_error;
173: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
174: THEN
175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;
177:

Line 175: RAISE fnd_api.g_exc_unexpected_error;

171: THEN
172: RAISE fnd_api.g_exc_error;
173: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
174: THEN
175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;
177:
178: IF fnd_api.to_boolean (p_commit)
179: THEN

Line 178: IF fnd_api.to_boolean (p_commit)

174: THEN
175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;
177:
178: IF fnd_api.to_boolean (p_commit)
179: THEN
180: COMMIT WORK;
181: END IF;
182:

Line 185: WHEN fnd_api.g_exc_unexpected_error

181: END IF;
182:
183: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
184: EXCEPTION
185: WHEN fnd_api.g_exc_unexpected_error
186: THEN
187: ROLLBACK TO create_task_recurrence_pub;
188: x_return_status := fnd_api.g_ret_sts_unexp_error;
189: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 188: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 195: x_return_status := fnd_api.g_ret_sts_unexp_error;

191: THEN
192:
193:
194: ROLLBACK TO create_task_recurrence_pub;
195: x_return_status := fnd_api.g_ret_sts_unexp_error;
196: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
197: END;
198:
199: PROCEDURE update_task_recurrence (

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

197: END;
198:
199: PROCEDURE update_task_recurrence (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
202: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
203: p_task_id IN NUMBER,
204: p_recurrence_rule_id IN NUMBER,
205: p_occurs_which IN INTEGER DEFAULT NULL,

Line 202: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

198:
199: PROCEDURE update_task_recurrence (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
202: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
203: p_task_id IN NUMBER,
204: p_recurrence_rule_id IN NUMBER,
205: p_occurs_which IN INTEGER DEFAULT NULL,
206: p_day_of_week IN INTEGER DEFAULT NULL,

Line 247: x_return_status := fnd_api.g_ret_sts_success;

243: IS
244: BEGIN
245: SAVEPOINT update_task_recurrence_pub;
246:
247: x_return_status := fnd_api.g_ret_sts_success;
248:
249: IF fnd_api.to_boolean (p_init_msg_list)
250: THEN
251: fnd_msg_pub.initialize;

Line 249: IF fnd_api.to_boolean (p_init_msg_list)

245: SAVEPOINT update_task_recurrence_pub;
246:
247: x_return_status := fnd_api.g_ret_sts_success;
248:
249: IF fnd_api.to_boolean (p_init_msg_list)
250: THEN
251: fnd_msg_pub.initialize;
252: END IF;
253:

Line 256: p_init_msg_list => fnd_api.g_false,

252: END IF;
253:
254: jtf_task_recurrences_pvt.update_task_recurrence (
255: p_api_version => 1.0,
256: p_init_msg_list => fnd_api.g_false,
257: p_commit => fnd_api.g_false,
258: p_task_id => p_task_id,
259: p_recurrence_rule_id => p_recurrence_rule_id,
260: p_occurs_which => p_occurs_which,

Line 257: p_commit => fnd_api.g_false,

253:
254: jtf_task_recurrences_pvt.update_task_recurrence (
255: p_api_version => 1.0,
256: p_init_msg_list => fnd_api.g_false,
257: p_commit => fnd_api.g_false,
258: p_task_id => p_task_id,
259: p_recurrence_rule_id => p_recurrence_rule_id,
260: p_occurs_which => p_occurs_which,
261: p_day_of_week => p_day_of_week,

Line 299: IF fnd_api.to_boolean (p_commit)

295: x_msg_count => x_msg_count,
296: x_msg_data => x_msg_data
297: );
298:
299: IF fnd_api.to_boolean (p_commit)
300: THEN
301: COMMIT WORK;
302: END IF;
303:

Line 306: WHEN fnd_api.g_exc_unexpected_error

302: END IF;
303:
304: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
305: EXCEPTION
306: WHEN fnd_api.g_exc_unexpected_error
307: THEN
308: ROLLBACK TO update_task_recurrence_pub;
309: x_return_status := fnd_api.g_ret_sts_unexp_error;
310: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 309: x_return_status := fnd_api.g_ret_sts_unexp_error;

305: EXCEPTION
306: WHEN fnd_api.g_exc_unexpected_error
307: THEN
308: ROLLBACK TO update_task_recurrence_pub;
309: x_return_status := fnd_api.g_ret_sts_unexp_error;
310: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
311: WHEN OTHERS
312: THEN
313: ROLLBACK TO update_task_recurrence_pub;

Line 314: x_return_status := fnd_api.g_ret_sts_unexp_error;

310: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
311: WHEN OTHERS
312: THEN
313: ROLLBACK TO update_task_recurrence_pub;
314: x_return_status := fnd_api.g_ret_sts_unexp_error;
315: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
316: END update_task_recurrence;
317:
318: END;