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

Line 4: g_false CONSTANT VARCHAR2(30) := fnd_api.g_false;

1: PACKAGE BODY jtf_ec_pvt AS
2: /* $Header: jtfecmab.pls 115.24 2004/04/21 12:01:23 nselvam ship $ */
3: g_user CONSTANT VARCHAR2(30) := fnd_global.user_id;
4: g_false CONSTANT VARCHAR2(30) := fnd_api.g_false;
5: g_true CONSTANT VARCHAR2(30) := fnd_api.g_true;
6:
7: PROCEDURE create_escalation (
8: p_api_version IN NUMBER,

Line 5: g_true CONSTANT VARCHAR2(30) := fnd_api.g_true;

1: PACKAGE BODY jtf_ec_pvt AS
2: /* $Header: jtfecmab.pls 115.24 2004/04/21 12:01:23 nselvam ship $ */
3: g_user CONSTANT VARCHAR2(30) := fnd_global.user_id;
4: g_false CONSTANT VARCHAR2(30) := fnd_api.g_false;
5: g_true CONSTANT VARCHAR2(30) := fnd_api.g_true;
6:
7: PROCEDURE create_escalation (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 9: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

5: g_true CONSTANT VARCHAR2(30) := fnd_api.g_true;
6:
7: PROCEDURE create_escalation (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
10: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
11: p_esc_id IN NUMBER DEFAULT NULL,
12: p_escalation_name IN VARCHAR2,
13: p_description IN VARCHAR2 DEFAULT NULL,

Line 10: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

6:
7: PROCEDURE create_escalation (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
10: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
11: p_esc_id IN NUMBER DEFAULT NULL,
12: p_escalation_name IN VARCHAR2,
13: p_description IN VARCHAR2 DEFAULT NULL,
14: p_escalation_status_name IN VARCHAR2 DEFAULT NULL,

Line 69: x_return_status := fnd_api.g_ret_sts_success;

65: BEGIN
66:
67: SAVEPOINT create_escalation_pvt;
68:
69: x_return_status := fnd_api.g_ret_sts_success;
70:
71: IF NOT fnd_api.compatible_api_call (
72: l_api_version,
73: p_api_version,

Line 71: IF NOT fnd_api.compatible_api_call (

67: SAVEPOINT create_escalation_pvt;
68:
69: x_return_status := fnd_api.g_ret_sts_success;
70:
71: IF NOT fnd_api.compatible_api_call (
72: l_api_version,
73: p_api_version,
74: l_api_name,
75: g_pkg_name

Line 78: RAISE fnd_api.g_exc_unexpected_error;

74: l_api_name,
75: g_pkg_name
76: )
77: THEN
78: RAISE fnd_api.g_exc_unexpected_error;
79: END IF;
80:
81: IF fnd_api.to_boolean (p_init_msg_list)
82: THEN

Line 81: IF fnd_api.to_boolean (p_init_msg_list)

77: THEN
78: RAISE fnd_api.g_exc_unexpected_error;
79: END IF;
80:
81: IF fnd_api.to_boolean (p_init_msg_list)
82: THEN
83: fnd_msg_pub.initialize;
84: END IF;
85:

Line 90: x_return_status := fnd_api.g_ret_sts_unexp_error;

86: IF p_escalation_name IS NULL
87: THEN
88: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_NAME');
89: fnd_msg_pub.add;
90: x_return_status := fnd_api.g_ret_sts_unexp_error;
91: RAISE fnd_api.g_exc_unexpected_error;
92: END IF;
93:
94: jtf_tasks_pub.create_task (

Line 91: RAISE fnd_api.g_exc_unexpected_error;

87: THEN
88: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_NAME');
89: fnd_msg_pub.add;
90: x_return_status := fnd_api.g_ret_sts_unexp_error;
91: RAISE fnd_api.g_exc_unexpected_error;
92: END IF;
93:
94: jtf_tasks_pub.create_task (
95: p_api_version => 1.0,

Line 96: p_init_msg_list => fnd_api.g_false,

92: END IF;
93:
94: jtf_tasks_pub.create_task (
95: p_api_version => 1.0,
96: p_init_msg_list => fnd_api.g_false,
97: p_commit => fnd_api.g_false,
98: p_task_id => p_esc_id,
99: p_task_name => p_escalation_name,
100: p_task_type_id => jtf_ec_pub.g_escalation_type_id,

Line 97: p_commit => fnd_api.g_false,

93:
94: jtf_tasks_pub.create_task (
95: p_api_version => 1.0,
96: p_init_msg_list => fnd_api.g_false,
97: p_commit => fnd_api.g_false,
98: p_task_id => p_esc_id,
99: p_task_name => p_escalation_name,
100: p_task_type_id => jtf_ec_pub.g_escalation_type_id,
101: p_description => p_description,

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

183: p_attribute15 => p_attribute15,
184: p_attribute_category => p_attribute_category
185: );
186:
187: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
188: THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error;
190: RAISE fnd_api.g_exc_unexpected_error;
191: END IF;

Line 189: x_return_status := fnd_api.g_ret_sts_unexp_error;

185: );
186:
187: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
188: THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error;
190: RAISE fnd_api.g_exc_unexpected_error;
191: END IF;
192:
193: x_escalation_id := l_escalation_id;

Line 190: RAISE fnd_api.g_exc_unexpected_error;

186:
187: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
188: THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error;
190: RAISE fnd_api.g_exc_unexpected_error;
191: END IF;
192:
193: x_escalation_id := l_escalation_id;
194:

Line 203: x_return_status := fnd_api.g_ret_sts_unexp_error;

199: WHERE task_id = l_escalation_id;
200: EXCEPTION
201: WHEN NO_DATA_FOUND
202: THEN
203: x_return_status := fnd_api.g_ret_sts_unexp_error;
204: RAISE fnd_api.g_exc_unexpected_error;
205: END;
206:
207: UPDATE jtf_tasks_b

Line 204: RAISE fnd_api.g_exc_unexpected_error;

200: EXCEPTION
201: WHEN NO_DATA_FOUND
202: THEN
203: x_return_status := fnd_api.g_ret_sts_unexp_error;
204: RAISE fnd_api.g_exc_unexpected_error;
205: END;
206:
207: UPDATE jtf_tasks_b
208: SET source_object_type_code = jtf_ec_pub.g_escalation_code,

Line 216: IF fnd_api.to_boolean (p_commit)

212:
213: -------
214: -------
215: -------
216: IF fnd_api.to_boolean (p_commit)
217: THEN
218: COMMIT WORK;
219: END IF;
220:

Line 238: WHEN fnd_api.g_exc_unexpected_error

234: END;
235: --End BES enh 2660883
236:
237: EXCEPTION
238: WHEN fnd_api.g_exc_unexpected_error
239: THEN
240: ROLLBACK TO create_escalation_pvt;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 241: x_return_status := fnd_api.g_ret_sts_unexp_error;

237: EXCEPTION
238: WHEN fnd_api.g_exc_unexpected_error
239: THEN
240: ROLLBACK TO create_escalation_pvt;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
243: WHEN NO_DATA_FOUND
244: THEN
245: ROLLBACK TO create_escalation_pvt;

Line 246: x_return_status := fnd_api.g_ret_sts_unexp_error;

242: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
243: WHEN NO_DATA_FOUND
244: THEN
245: ROLLBACK TO create_escalation_pvt;
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
248: WHEN OTHERS
249: THEN
250: ROLLBACK TO create_escalation_pvt;

Line 251: x_return_status := fnd_api.g_ret_sts_unexp_error;

247: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
248: WHEN OTHERS
249: THEN
250: ROLLBACK TO create_escalation_pvt;
251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252:
253: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
254: THEN
255: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 263: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

259: END;
260:
261: PROCEDURE update_escalation (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
264: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
265: p_object_version_number IN OUT NOCOPY NUMBER,
266: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
267: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 264: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

260:
261: PROCEDURE update_escalation (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
264: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
265: p_object_version_number IN OUT NOCOPY NUMBER,
266: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
267: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
268: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 266: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,

262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
264: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
265: p_object_version_number IN OUT NOCOPY NUMBER,
266: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
267: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
268: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
269: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 267: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

263: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
264: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
265: p_object_version_number IN OUT NOCOPY NUMBER,
266: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
267: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
268: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
269: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 268: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

264: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
265: p_object_version_number IN OUT NOCOPY NUMBER,
266: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
267: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
268: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
269: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,

Line 269: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

265: p_object_version_number IN OUT NOCOPY NUMBER,
266: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
267: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
268: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
269: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,
273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,

Line 270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

266: p_escalation_id IN NUMBER DEFAULT fnd_api.g_miss_num,
267: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
268: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
269: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,
273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,
274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,

267: p_escalation_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
268: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
269: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,
273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,
274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,

268: p_escalation_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
269: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,
273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,
274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,

269: p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,
273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,
274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

270: p_escalation_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,
273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,
274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,

271: p_escalation_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,
273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,
274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,

272: p_open_date IN DATE DEFAULT fnd_api.g_miss_date,
273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,
274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

273: p_close_date IN DATE DEFAULT fnd_api.g_miss_date,
274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,

274: p_escalation_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

275: p_escalation_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,

276: p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num,
277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

277: p_escalation_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,

278: p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

279: p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,

Line 284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,

280: p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num,
281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,

281: p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/

Line 286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

282: p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num,
283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/
290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,

283: p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/
290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
291: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,

284: p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num,
285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/
290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
291: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/

285: p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num,
286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/
290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
291: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,

Line 290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

286: p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/
290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
291: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
294: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 291: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

287: p_target_date IN DATE DEFAULT fnd_api.g_miss_date,
288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/
290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
291: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
294: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: x_return_status OUT NOCOPY VARCHAR2,

Line 292: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

288: /* p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/
290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
291: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
294: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,

Line 293: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,

289: p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,*/
290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
291: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
294: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,

Line 294: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

290: p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
291: p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
292: p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
293: p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num,
294: p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
298: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 353: fnd_api.g_miss_num,

349: CURSOR c_escalation_update (l_escalation_id IN NUMBER)
350: IS
351: SELECT DECODE (
352: p_escalation_id,
353: fnd_api.g_miss_num,
354: task_id,
355: p_escalation_id
356: ) escalation_id,
357: DECODE (

Line 359: fnd_api.g_miss_char,

355: p_escalation_id
356: ) escalation_id,
357: DECODE (
358: p_escalation_number,
359: fnd_api.g_miss_char,
360: task_number,
361: p_escalation_number
362: ) escalation_number,
363: DECODE (

Line 365: fnd_api.g_miss_char,

361: p_escalation_number
362: ) escalation_number,
363: DECODE (
364: p_escalation_name,
365: fnd_api.g_miss_char,
366: task_name,
367: p_escalation_name
368: ) escalation_name,
369: DECODE (

Line 371: fnd_api.g_miss_char,

367: p_escalation_name
368: ) escalation_name,
369: DECODE (
370: p_description,
371: fnd_api.g_miss_char,
372: description,
373: p_description
374: ) description,
375: DECODE (

Line 377: fnd_api.g_miss_num,

373: p_description
374: ) description,
375: DECODE (
376: p_escalation_status_id,
377: fnd_api.g_miss_num,
378: task_status_id,
379: p_escalation_status_id
380: ) escalation_status_id,
381: DECODE (

Line 383: fnd_api.g_miss_num,

379: p_escalation_status_id
380: ) escalation_status_id,
381: DECODE (
382: p_escalation_priority_id,
383: fnd_api.g_miss_num,
384: task_priority_id,
385: p_escalation_priority_id
386: ) escalation_priority_id,
387: DECODE (

Line 389: fnd_api.g_miss_num,

385: p_escalation_priority_id
386: ) escalation_priority_id,
387: DECODE (
388: p_owner_id,
389: fnd_api.g_miss_num,
390: owner_id,
391: p_owner_id
392: ) owner_id,
393: DECODE (

Line 395: fnd_api.g_miss_num,

391: p_owner_id
392: ) owner_id,
393: DECODE (
394: p_owner_territory_id,
395: fnd_api.g_miss_num,
396: owner_territory_id,
397: p_owner_territory_id
398: ) owner_territory_id,
399: DECODE (

Line 401: fnd_api.g_miss_num,

397: p_owner_territory_id
398: ) owner_territory_id,
399: DECODE (
400: p_assigned_by_id,
401: fnd_api.g_miss_num,
402: assigned_by_id,
403: p_assigned_by_id
404: ) assigned_by_id,
405: DECODE (

Line 407: fnd_api.g_miss_num,

403: p_assigned_by_id
404: ) assigned_by_id,
405: DECODE (
406: p_customer_id,
407: fnd_api.g_miss_num,
408: customer_id,
409: p_customer_id
410: ) customer_id,
411: DECODE (

Line 413: fnd_api.g_miss_num,

409: p_customer_id
410: ) customer_id,
411: DECODE (
412: p_cust_account_id,
413: fnd_api.g_miss_num,
414: cust_account_id,
415: p_cust_account_id
416: ) cust_account_id,
417: DECODE (

Line 419: fnd_api.g_miss_num,

415: p_cust_account_id
416: ) cust_account_id,
417: DECODE (
418: p_address_id,
419: fnd_api.g_miss_num,
420: address_id,
421: p_address_id
422: ) address_id,
423: DECODE (

Line 425: fnd_api.g_miss_date,

421: p_address_id
422: ) address_id,
423: DECODE (
424: p_target_date,
425: fnd_api.g_miss_date,
426: planned_end_date,
427: p_target_date
428: ) target_date,
429: DECODE (

Line 431: fnd_api.g_miss_char,

427: p_target_date
428: ) target_date,
429: DECODE (
430: p_reason_code,
431: fnd_api.g_miss_char,
432: reason_code,
433: p_reason_code
434: ) reason_code,
435: DECODE (

Line 437: fnd_api.g_miss_char,

433: p_reason_code
434: ) reason_code,
435: DECODE (
436: p_private_flag,
437: fnd_api.g_miss_char,
438: private_flag,
439: p_private_flag
440: ) private_flag,
441: DECODE (

Line 443: fnd_api.g_miss_char,

439: p_private_flag
440: ) private_flag,
441: DECODE (
442: p_publish_flag,
443: fnd_api.g_miss_char,
444: publish_flag,
445: p_publish_flag
446: ) publish_flag,
447: DECODE (

Line 449: fnd_api.g_miss_num,

445: p_publish_flag
446: ) publish_flag,
447: DECODE (
448: p_workflow_process_id,
449: fnd_api.g_miss_num,
450: workflow_process_id,
451: p_workflow_process_id
452: ) workflow_process_id,
453: DECODE (

Line 455: fnd_api.g_miss_char,

451: p_workflow_process_id
452: ) workflow_process_id,
453: DECODE (
454: p_escalation_level,
455: fnd_api.g_miss_char,
456: escalation_level,
457: p_escalation_level
458: ) escalation_level,
459: DECODE (

Line 461: fnd_api.g_miss_date,

457: p_escalation_level
458: ) escalation_level,
459: DECODE (
460: p_open_date,
461: fnd_api.g_miss_date,
462: actual_start_date,
463: p_open_date
464: ) open_date,
465: DECODE (

Line 467: fnd_api.g_miss_date,

463: p_open_date
464: ) open_date,
465: DECODE (
466: p_close_date,
467: fnd_api.g_miss_date,
468: actual_end_date,
469: p_close_date
470: ) close_date
471: FROM jtf_tasks_vl

Line 489: x_return_status := fnd_api.g_ret_sts_success;

485: BEGIN
486:
487: SAVEPOINT update_escalation_pvt;
488:
489: x_return_status := fnd_api.g_ret_sts_success;
490:
491: IF NOT fnd_api.compatible_api_call (
492: l_api_version,
493: p_api_version,

Line 491: IF NOT fnd_api.compatible_api_call (

487: SAVEPOINT update_escalation_pvt;
488:
489: x_return_status := fnd_api.g_ret_sts_success;
490:
491: IF NOT fnd_api.compatible_api_call (
492: l_api_version,
493: p_api_version,
494: l_api_name,
495: g_pkg_name

Line 498: RAISE fnd_api.g_exc_unexpected_error;

494: l_api_name,
495: g_pkg_name
496: )
497: THEN
498: RAISE fnd_api.g_exc_unexpected_error;
499: END IF;
500:
501: IF fnd_api.to_boolean (p_init_msg_list)
502: THEN

Line 501: IF fnd_api.to_boolean (p_init_msg_list)

497: THEN
498: RAISE fnd_api.g_exc_unexpected_error;
499: END IF;
500:
501: IF fnd_api.to_boolean (p_init_msg_list)
502: THEN
503: fnd_msg_pub.initialize;
504: END IF;
505:

Line 510: IF ( l_escalation_id = fnd_api.g_miss_num

506:
507: -----
508: ----- Validate Escalation
509: -----
510: IF ( l_escalation_id = fnd_api.g_miss_num
511: AND l_escalation_number = fnd_api.g_miss_char)
512: THEN
513: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
514: fnd_msg_pub.add;

Line 511: AND l_escalation_number = fnd_api.g_miss_char)

507: -----
508: ----- Validate Escalation
509: -----
510: IF ( l_escalation_id = fnd_api.g_miss_num
511: AND l_escalation_number = fnd_api.g_miss_char)
512: THEN
513: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
514: fnd_msg_pub.add;
515: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 515: x_return_status := fnd_api.g_ret_sts_unexp_error;

511: AND l_escalation_number = fnd_api.g_miss_char)
512: THEN
513: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
514: fnd_msg_pub.add;
515: x_return_status := fnd_api.g_ret_sts_unexp_error;
516: RAISE fnd_api.g_exc_unexpected_error;
517: ELSE
518: SELECT DECODE (l_escalation_id, fnd_api.g_miss_num, NULL, l_escalation_id)
519: INTO

Line 516: RAISE fnd_api.g_exc_unexpected_error;

512: THEN
513: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
514: fnd_msg_pub.add;
515: x_return_status := fnd_api.g_ret_sts_unexp_error;
516: RAISE fnd_api.g_exc_unexpected_error;
517: ELSE
518: SELECT DECODE (l_escalation_id, fnd_api.g_miss_num, NULL, l_escalation_id)
519: INTO
520: l_escalation_id

Line 518: SELECT DECODE (l_escalation_id, fnd_api.g_miss_num, NULL, l_escalation_id)

514: fnd_msg_pub.add;
515: x_return_status := fnd_api.g_ret_sts_unexp_error;
516: RAISE fnd_api.g_exc_unexpected_error;
517: ELSE
518: SELECT DECODE (l_escalation_id, fnd_api.g_miss_num, NULL, l_escalation_id)
519: INTO
520: l_escalation_id
521: FROM dual;
522: SELECT DECODE (

Line 524: fnd_api.g_miss_char, NULL,

520: l_escalation_id
521: FROM dual;
522: SELECT DECODE (
523: l_escalation_number,
524: fnd_api.g_miss_char, NULL,
525: l_escalation_number
526: )
527: INTO
528: l_escalation_number

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

533: x_task_id => l_escalation_id,
534: x_return_status => x_return_status
535: );
536:
537: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
538: THEN
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: RAISE fnd_api.g_exc_unexpected_error;
541: END IF;

Line 539: x_return_status := fnd_api.g_ret_sts_unexp_error;

535: );
536:
537: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
538: THEN
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: RAISE fnd_api.g_exc_unexpected_error;
541: END IF;
542:
543: IF l_escalation_id IS NULL

Line 540: RAISE fnd_api.g_exc_unexpected_error;

536:
537: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
538: THEN
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: RAISE fnd_api.g_exc_unexpected_error;
541: END IF;
542:
543: IF l_escalation_id IS NULL
544: THEN

Line 548: x_return_status := fnd_api.g_ret_sts_unexp_error;

544: THEN
545: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
546: fnd_message.set_token('P_TASK_NUMBER',l_escalation_number);
547: fnd_msg_pub.add;
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551: END IF;
552:

Line 549: RAISE fnd_api.g_exc_unexpected_error;

545: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
546: fnd_message.set_token('P_TASK_NUMBER',l_escalation_number);
547: fnd_msg_pub.add;
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551: END IF;
552:
553:

Line 561: x_return_status := fnd_api.g_ret_sts_unexp_error;

557: IF l_escalation_name IS NULL
558: THEN
559: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_NAME');
560: fnd_msg_pub.add;
561: x_return_status := fnd_api.g_ret_sts_unexp_error;
562: RAISE fnd_api.g_exc_unexpected_error;
563: END IF;
564:
565:

Line 562: RAISE fnd_api.g_exc_unexpected_error;

558: THEN
559: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_NAME');
560: fnd_msg_pub.add;
561: x_return_status := fnd_api.g_ret_sts_unexp_error;
562: RAISE fnd_api.g_exc_unexpected_error;
563: END IF;
564:
565:
566: -----

Line 581: x_return_status := fnd_api.g_ret_sts_unexp_error;

577: THEN
578: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
579: fnd_message.set_token('P_TASK_ID', to_char(l_escalation_id));
580: fnd_msg_pub.add;
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
582: RAISE fnd_api.g_exc_unexpected_error;
583: END IF;
584: CLOSE c_escalation_update;
585: -----

Line 582: RAISE fnd_api.g_exc_unexpected_error;

578: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
579: fnd_message.set_token('P_TASK_ID', to_char(l_escalation_id));
580: fnd_msg_pub.add;
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
582: RAISE fnd_api.g_exc_unexpected_error;
583: END IF;
584: CLOSE c_escalation_update;
585: -----
586: ----- Task Description

Line 595: p_init_msg_list => fnd_api.g_false,

591:
592:
593: jtf_tasks_pub.update_task (
594: p_api_version => 1.0,
595: p_init_msg_list => fnd_api.g_false,
596: p_commit => fnd_api.g_false,
597: p_object_version_number => p_object_version_number,
598: p_task_id => l_escalation_id,
599: p_task_name => l_escalation_name,

Line 596: p_commit => fnd_api.g_false,

592:
593: jtf_tasks_pub.update_task (
594: p_api_version => 1.0,
595: p_init_msg_list => fnd_api.g_false,
596: p_commit => fnd_api.g_false,
597: p_object_version_number => p_object_version_number,
598: p_task_id => l_escalation_id,
599: p_task_name => l_escalation_name,
600: p_task_type_id => 22,

Line 710: WHEN fnd_api.g_exc_unexpected_error

706: END;
707: --End BES enh 2660883
708:
709: EXCEPTION
710: WHEN fnd_api.g_exc_unexpected_error
711: THEN
712: ROLLBACK TO update_escalation_pvt;
713: x_return_status := fnd_api.g_ret_sts_unexp_error;
714: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 713: x_return_status := fnd_api.g_ret_sts_unexp_error;

709: EXCEPTION
710: WHEN fnd_api.g_exc_unexpected_error
711: THEN
712: ROLLBACK TO update_escalation_pvt;
713: x_return_status := fnd_api.g_ret_sts_unexp_error;
714: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
715: WHEN NO_DATA_FOUND
716: THEN
717: ROLLBACK TO update_escalation_pvt;

Line 718: x_return_status := fnd_api.g_ret_sts_unexp_error;

714: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
715: WHEN NO_DATA_FOUND
716: THEN
717: ROLLBACK TO update_escalation_pvt;
718: x_return_status := fnd_api.g_ret_sts_unexp_error;
719: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
720: WHEN OTHERS
721: THEN
722: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 726: x_return_status := fnd_api.g_ret_sts_unexp_error;

722: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
723: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
724: fnd_msg_pub.add;
725: ROLLBACK TO update_escalation_pvt;
726: x_return_status := fnd_api.g_ret_sts_unexp_error;
727: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
728: END;
729: /* PROCEDURE lock_escalation (
730: p_api_version IN NUMBER,

Line 731: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

727: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
728: END;
729: /* PROCEDURE lock_escalation (
730: p_api_version IN NUMBER,
731: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
732: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
733: p_escalation_id IN NUMBER,
734: p_object_version_number IN NUMBER,
735: x_return_status OUT VARCHAR2,

Line 732: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

728: END;
729: /* PROCEDURE lock_escalation (
730: p_api_version IN NUMBER,
731: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
732: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
733: p_escalation_id IN NUMBER,
734: p_object_version_number IN NUMBER,
735: x_return_status OUT VARCHAR2,
736: x_msg_data OUT VARCHAR2,

Line 743: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

739: */
740:
741: PROCEDURE delete_escalation (
742: p_api_version IN NUMBER,
743: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
744: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
745: p_object_version_number IN NUMBER ,
746: p_escalation_id IN NUMBER DEFAULT NULL,
747: p_escalation_number IN VARCHAR2 DEFAULT NULL,

Line 744: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

740:
741: PROCEDURE delete_escalation (
742: p_api_version IN NUMBER,
743: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
744: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
745: p_object_version_number IN NUMBER ,
746: p_escalation_id IN NUMBER DEFAULT NULL,
747: p_escalation_number IN VARCHAR2 DEFAULT NULL,
748: x_return_status OUT NOCOPY VARCHAR2,

Line 789: x_return_status := fnd_api.g_ret_sts_success;

785:
786: begin
787: SAVEPOINT delete_escalation_pvt;
788:
789: x_return_status := fnd_api.g_ret_sts_success;
790:
791: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
792: THEN
793: RAISE fnd_api.g_exc_unexpected_error;

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

787: SAVEPOINT delete_escalation_pvt;
788:
789: x_return_status := fnd_api.g_ret_sts_success;
790:
791: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
792: THEN
793: RAISE fnd_api.g_exc_unexpected_error;
794: END IF;
795:

Line 793: RAISE fnd_api.g_exc_unexpected_error;

789: x_return_status := fnd_api.g_ret_sts_success;
790:
791: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
792: THEN
793: RAISE fnd_api.g_exc_unexpected_error;
794: END IF;
795:
796: IF fnd_api.to_boolean (p_init_msg_list)
797: THEN

Line 796: IF fnd_api.to_boolean (p_init_msg_list)

792: THEN
793: RAISE fnd_api.g_exc_unexpected_error;
794: END IF;
795:
796: IF fnd_api.to_boolean (p_init_msg_list)
797: THEN
798: fnd_msg_pub.initialize;
799: END IF;
800:

Line 806: x_return_status := fnd_api.g_ret_sts_unexp_error;

802: AND l_escalation_number IS NULL)
803: THEN
804: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
805: fnd_msg_pub.add;
806: x_return_status := fnd_api.g_ret_sts_unexp_error;
807: RAISE fnd_api.g_exc_unexpected_error;
808: ELSE
809: jtf_task_utl.validate_task (
810: p_task_id => l_escalation_id,

Line 807: RAISE fnd_api.g_exc_unexpected_error;

803: THEN
804: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
805: fnd_msg_pub.add;
806: x_return_status := fnd_api.g_ret_sts_unexp_error;
807: RAISE fnd_api.g_exc_unexpected_error;
808: ELSE
809: jtf_task_utl.validate_task (
810: p_task_id => l_escalation_id,
811: p_task_number => l_escalation_number,

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

812: x_task_id => l_escalation_id,
813: x_return_status => x_return_status
814: );
815:
816: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
817: THEN
818: x_return_status := fnd_api.g_ret_sts_unexp_error;
819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;

Line 818: x_return_status := fnd_api.g_ret_sts_unexp_error;

814: );
815:
816: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
817: THEN
818: x_return_status := fnd_api.g_ret_sts_unexp_error;
819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;
821: END IF;
822:

Line 819: RAISE fnd_api.g_exc_unexpected_error;

815:
816: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
817: THEN
818: x_return_status := fnd_api.g_ret_sts_unexp_error;
819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;
821: END IF;
822:
823: -- Added for Bug # 3568448

Line 842: p_init_msg_list => fnd_api.g_false,

838:
839:
840: jtf_tasks_pvt.delete_task (
841: p_api_version => 1.0,
842: p_init_msg_list => fnd_api.g_false,
843: p_commit => fnd_api.g_false,
844: p_object_version_number => p_object_version_number,
845: p_task_id => l_escalation_id,
846: p_delete_future_recurrences => fnd_api.g_false,

Line 843: p_commit => fnd_api.g_false,

839:
840: jtf_tasks_pvt.delete_task (
841: p_api_version => 1.0,
842: p_init_msg_list => fnd_api.g_false,
843: p_commit => fnd_api.g_false,
844: p_object_version_number => p_object_version_number,
845: p_task_id => l_escalation_id,
846: p_delete_future_recurrences => fnd_api.g_false,
847: x_return_status => x_return_status,

Line 846: p_delete_future_recurrences => fnd_api.g_false,

842: p_init_msg_list => fnd_api.g_false,
843: p_commit => fnd_api.g_false,
844: p_object_version_number => p_object_version_number,
845: p_task_id => l_escalation_id,
846: p_delete_future_recurrences => fnd_api.g_false,
847: x_return_status => x_return_status,
848: x_msg_count => x_msg_count,
849: x_msg_data => x_msg_data
850: );

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

849: x_msg_data => x_msg_data
850: );
851:
852: -- Code added to check x_return_status, since it was missing in the original code
853: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
854: THEN
855:
856: x_return_status := fnd_api.g_ret_sts_unexp_error;
857: RAISE fnd_api.g_exc_unexpected_error;

Line 856: x_return_status := fnd_api.g_ret_sts_unexp_error;

852: -- Code added to check x_return_status, since it was missing in the original code
853: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
854: THEN
855:
856: x_return_status := fnd_api.g_ret_sts_unexp_error;
857: RAISE fnd_api.g_exc_unexpected_error;
858: END IF;
859: -- End Add
860:

Line 857: RAISE fnd_api.g_exc_unexpected_error;

853: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
854: THEN
855:
856: x_return_status := fnd_api.g_ret_sts_unexp_error;
857: RAISE fnd_api.g_exc_unexpected_error;
858: END IF;
859: -- End Add
860:
861: -- Added for Bug # 3568448

Line 894: p_init_msg_list => fnd_api.g_false,

890: FOR b IN c_delete_references
891: LOOP
892: jtf_ec_references_pvt.delete_references (
893: p_api_version => 1.0,
894: p_init_msg_list => fnd_api.g_false,
895: p_commit => fnd_api.g_false,
896: p_object_version_number => b.object_version_number,
897: p_escalation_reference_id => b.task_reference_id,
898: x_return_status => x_return_status,

Line 895: p_commit => fnd_api.g_false,

891: LOOP
892: jtf_ec_references_pvt.delete_references (
893: p_api_version => 1.0,
894: p_init_msg_list => fnd_api.g_false,
895: p_commit => fnd_api.g_false,
896: p_object_version_number => b.object_version_number,
897: p_escalation_reference_id => b.task_reference_id,
898: x_return_status => x_return_status,
899: x_msg_count => x_msg_count,

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

899: x_msg_count => x_msg_count,
900: x_msg_data => x_msg_data
901: );
902:
903: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
904: THEN
905:
906: x_return_status := fnd_api.g_ret_sts_unexp_error;
907: RAISE fnd_api.g_exc_unexpected_error;

Line 906: x_return_status := fnd_api.g_ret_sts_unexp_error;

902:
903: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
904: THEN
905:
906: x_return_status := fnd_api.g_ret_sts_unexp_error;
907: RAISE fnd_api.g_exc_unexpected_error;
908: END IF;
909: END LOOP; */
910:

Line 907: RAISE fnd_api.g_exc_unexpected_error;

903: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
904: THEN
905:
906: x_return_status := fnd_api.g_ret_sts_unexp_error;
907: RAISE fnd_api.g_exc_unexpected_error;
908: END IF;
909: END LOOP; */
910:
911: IF fnd_api.to_boolean (p_commit)

Line 911: IF fnd_api.to_boolean (p_commit)

907: RAISE fnd_api.g_exc_unexpected_error;
908: END IF;
909: END LOOP; */
910:
911: IF fnd_api.to_boolean (p_commit)
912: THEN
913: COMMIT WORK;
914: END IF;
915:

Line 933: WHEN fnd_api.g_exc_unexpected_error

929: --End BES enh 2660883
930:
931:
932: EXCEPTION
933: WHEN fnd_api.g_exc_unexpected_error
934: THEN
935: ROLLBACK TO delete_escalation_pvt;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 936: x_return_status := fnd_api.g_ret_sts_unexp_error;

932: EXCEPTION
933: WHEN fnd_api.g_exc_unexpected_error
934: THEN
935: ROLLBACK TO delete_escalation_pvt;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
938: WHEN OTHERS
939: THEN
940: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 944: x_return_status := fnd_api.g_ret_sts_unexp_error;

940: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
941: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
942: fnd_msg_pub.add ;
943: ROLLBACK TO delete_escalation_pvt;
944: x_return_status := fnd_api.g_ret_sts_unexp_error;
945: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
946: END;
947:
948: END;