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

Line 7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

3: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_EC_REFERENCES_PVT';
4:
5: PROCEDURE create_references (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_escalation_id IN NUMBER DEFAULT NULL,
10: p_escalation_number IN VARCHAR2 DEFAULT NULL,
11: p_object_type_code IN VARCHAR2,

Line 8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

4:
5: PROCEDURE create_references (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_escalation_id IN NUMBER DEFAULT NULL,
10: p_escalation_number IN VARCHAR2 DEFAULT NULL,
11: p_object_type_code IN VARCHAR2,
12: p_object_name IN VARCHAR2,

Line 51: x_return_status := fnd_api.g_ret_sts_success;

47: l_esc_ref_rec jtf_ec_references_pvt.Esc_Ref_rec;
48:
49: BEGIN
50: SAVEPOINT create_references_pub;
51: x_return_status := fnd_api.g_ret_sts_success;
52:
53: IF NOT fnd_api.compatible_api_call (
54: l_api_version,
55: p_api_version,

Line 53: IF NOT fnd_api.compatible_api_call (

49: BEGIN
50: SAVEPOINT create_references_pub;
51: x_return_status := fnd_api.g_ret_sts_success;
52:
53: IF NOT fnd_api.compatible_api_call (
54: l_api_version,
55: p_api_version,
56: l_api_name,
57: g_pkg_name

Line 60: RAISE fnd_api.g_exc_unexpected_error;

56: l_api_name,
57: g_pkg_name
58: )
59: THEN
60: RAISE fnd_api.g_exc_unexpected_error;
61: END IF;
62:
63: IF fnd_api.to_boolean (p_init_msg_list)
64: THEN

Line 63: IF fnd_api.to_boolean (p_init_msg_list)

59: THEN
60: RAISE fnd_api.g_exc_unexpected_error;
61: END IF;
62:
63: IF fnd_api.to_boolean (p_init_msg_list)
64: THEN
65: fnd_msg_pub.initialize;
66: END IF;
67:

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

74: p_task_number => l_escalation_number,
75: x_task_id => l_escalation_id
76: );
77:
78: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
79: THEN
80: x_return_status := fnd_api.g_ret_sts_unexp_error;
81: RAISE fnd_api.g_exc_unexpected_error;
82: END IF;

Line 80: x_return_status := fnd_api.g_ret_sts_unexp_error;

76: );
77:
78: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
79: THEN
80: x_return_status := fnd_api.g_ret_sts_unexp_error;
81: RAISE fnd_api.g_exc_unexpected_error;
82: END IF;
83:
84: IF l_escalation_id IS NULL

Line 81: RAISE fnd_api.g_exc_unexpected_error;

77:
78: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
79: THEN
80: x_return_status := fnd_api.g_ret_sts_unexp_error;
81: RAISE fnd_api.g_exc_unexpected_error;
82: END IF;
83:
84: IF l_escalation_id IS NULL
85: THEN

Line 88: x_return_status := fnd_api.g_ret_sts_unexp_error;

84: IF l_escalation_id IS NULL
85: THEN
86: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
87: fnd_msg_pub.add;
88: x_return_status := fnd_api.g_ret_sts_unexp_error;
89: RAISE fnd_api.g_exc_unexpected_error;
90: END IF;
91:
92: ----

Line 89: RAISE fnd_api.g_exc_unexpected_error;

85: THEN
86: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
87: fnd_msg_pub.add;
88: x_return_status := fnd_api.g_ret_sts_unexp_error;
89: RAISE fnd_api.g_exc_unexpected_error;
90: END IF;
91:
92: ----
93: ----

Line 106: x_return_status := fnd_api.g_ret_sts_unexp_error;

102: )
103: THEN
104: NULL;
105: ELSE
106: x_return_status := fnd_api.g_ret_sts_unexp_error;
107: RAISE fnd_api.g_exc_unexpected_error;
108: END IF;
109: END IF;
110:

Line 107: RAISE fnd_api.g_exc_unexpected_error;

103: THEN
104: NULL;
105: ELSE
106: x_return_status := fnd_api.g_ret_sts_unexp_error;
107: RAISE fnd_api.g_exc_unexpected_error;
108: END IF;
109: END IF;
110:
111: jtf_task_references_pub.create_references (

Line 113: p_init_msg_list => fnd_api.g_false,

109: END IF;
110:
111: jtf_task_references_pub.create_references (
112: p_api_version => 1.0,
113: p_init_msg_list => fnd_api.g_false,
114: p_commit => fnd_api.g_false,
115: p_task_id => l_escalation_id,
116: p_object_type_code => p_object_type_code,
117: p_object_name => p_object_name,

Line 114: p_commit => fnd_api.g_false,

110:
111: jtf_task_references_pub.create_references (
112: p_api_version => 1.0,
113: p_init_msg_list => fnd_api.g_false,
114: p_commit => fnd_api.g_false,
115: p_task_id => l_escalation_id,
116: p_object_type_code => p_object_type_code,
117: p_object_name => p_object_name,
118: p_object_id => p_object_id,

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

140: p_attribute15 => p_attribute15,
141: p_attribute_category => p_attribute_category
142: );
143:
144: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
145: THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;

Line 146: x_return_status := fnd_api.g_ret_sts_unexp_error;

142: );
143:
144: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
145: THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;
149:
150: IF fnd_api.to_boolean (p_commit)

Line 147: RAISE fnd_api.g_exc_unexpected_error;

143:
144: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
145: THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;
149:
150: IF fnd_api.to_boolean (p_commit)
151: THEN

Line 150: IF fnd_api.to_boolean (p_commit)

146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;
149:
150: IF fnd_api.to_boolean (p_commit)
151: THEN
152: COMMIT WORK;
153: END IF;
154:

Line 176: WHEN fnd_api.g_exc_unexpected_error

172: END;
173: --End BES enh 2660883
174:
175: EXCEPTION
176: WHEN fnd_api.g_exc_unexpected_error
177: THEN
178: ROLLBACK TO create_references_pub;
179: x_return_status := fnd_api.g_ret_sts_unexp_error;
180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 179: x_return_status := fnd_api.g_ret_sts_unexp_error;

175: EXCEPTION
176: WHEN fnd_api.g_exc_unexpected_error
177: THEN
178: ROLLBACK TO create_references_pub;
179: x_return_status := fnd_api.g_ret_sts_unexp_error;
180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
181: WHEN NO_DATA_FOUND
182: THEN
183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');

Line 187: x_return_status := fnd_api.g_ret_sts_unexp_error;

183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
184: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
185: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
186: fnd_msg_pub.add;
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: WHEN OTHERS
189: THEN
190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

Line 192: x_return_status := fnd_api.g_ret_sts_unexp_error;

188: WHEN OTHERS
189: THEN
190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
194: END;
195:
196: /* PROCEDURE lock_references (

Line 198: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

194: END;
195:
196: /* PROCEDURE lock_references (
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
199: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
200: p_escalation_reference_id IN NUMBER,
201: p_object_version_number IN NUMBER,
202: x_return_status OUT VARCHAR2,

Line 199: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

195:
196: /* PROCEDURE lock_references (
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
199: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
200: p_escalation_reference_id IN NUMBER,
201: p_object_version_number IN NUMBER,
202: x_return_status OUT VARCHAR2,
203: x_msg_data OUT VARCHAR2,

Line 209: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

205: ) ;
206: */
207: PROCEDURE update_references (
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
211: p_object_version_number IN OUT NOCOPY NUMBER,
212: p_escalation_reference_id IN NUMBER,
213: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

206: */
207: PROCEDURE update_references (
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
211: p_object_version_number IN OUT NOCOPY NUMBER,
212: p_escalation_reference_id IN NUMBER,
213: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
214: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 213: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

209: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
211: p_object_version_number IN OUT NOCOPY NUMBER,
212: p_escalation_reference_id IN NUMBER,
213: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
214: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
216: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
217: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 214: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

210: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
211: p_object_version_number IN OUT NOCOPY NUMBER,
212: p_escalation_reference_id IN NUMBER,
213: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
214: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
216: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
217: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
218: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

Line 215: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,

211: p_object_version_number IN OUT NOCOPY NUMBER,
212: p_escalation_reference_id IN NUMBER,
213: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
214: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
216: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
217: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
218: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
219: x_return_status OUT NOCOPY VARCHAR2,

Line 216: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

212: p_escalation_reference_id IN NUMBER,
213: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
214: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
216: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
217: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
218: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_data OUT NOCOPY VARCHAR2,

Line 217: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

213: p_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
214: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
216: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
217: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
218: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,

Line 218: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

214: p_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
215: p_object_id IN NUMBER DEFAULT fnd_api.g_miss_num,
216: p_object_details IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
217: p_reference_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
218: p_usage IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: p_attribute1 IN VARCHAR2 DEFAULT null ,

Line 238: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num

234: p_attribute13 IN VARCHAR2 DEFAULT null ,
235: p_attribute14 IN VARCHAR2 DEFAULT null ,
236: p_attribute15 IN VARCHAR2 DEFAULT null ,
237: p_attribute_category IN VARCHAR2 DEFAULT null,
238: p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
239: )
240: IS
241: l_api_version CONSTANT NUMBER := 1.0;
242: l_api_name CONSTANT VARCHAR2(30)

Line 272: x_return_status := fnd_api.g_ret_sts_success;

268:
269:
270: SAVEPOINT update_references_pub;
271:
272: x_return_status := fnd_api.g_ret_sts_success;
273:
274: IF NOT fnd_api.compatible_api_call (
275: l_api_version,
276: p_api_version,

Line 274: IF NOT fnd_api.compatible_api_call (

270: SAVEPOINT update_references_pub;
271:
272: x_return_status := fnd_api.g_ret_sts_success;
273:
274: IF NOT fnd_api.compatible_api_call (
275: l_api_version,
276: p_api_version,
277: l_api_name,
278: g_pkg_name

Line 281: RAISE fnd_api.g_exc_unexpected_error;

277: l_api_name,
278: g_pkg_name
279: )
280: THEN
281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
283:
284: IF fnd_api.to_boolean (p_init_msg_list)
285: THEN

Line 284: IF fnd_api.to_boolean (p_init_msg_list)

280: THEN
281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
283:
284: IF fnd_api.to_boolean (p_init_msg_list)
285: THEN
286: fnd_msg_pub.initialize;
287: END IF;
288:

Line 293: x_return_status := fnd_api.g_ret_sts_unexp_error;

289: IF p_escalation_reference_id IS NULL
290: THEN
291: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_REFER');
292: fnd_msg_pub.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;
296:
297: OPEN c_escalation_reference;

Line 294: RAISE fnd_api.g_exc_unexpected_error;

290: THEN
291: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_REFER');
292: fnd_msg_pub.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;
296:
297: OPEN c_escalation_reference;
298: FETCH c_escalation_reference INTO escalation_reference;

Line 306: x_return_status := fnd_api.g_ret_sts_unexp_error;

302: THEN
303: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER');
304: fnd_message.set_token ('P_TASK_REFERENCE_ID', p_escalation_reference_id);
305: fnd_msg_pub.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: RAISE fnd_api.g_exc_unexpected_error;
308: END IF;
309:
310:

Line 307: RAISE fnd_api.g_exc_unexpected_error;

303: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER');
304: fnd_message.set_token ('P_TASK_REFERENCE_ID', p_escalation_reference_id);
305: fnd_msg_pub.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: RAISE fnd_api.g_exc_unexpected_error;
308: END IF;
309:
310:
311: -----

Line 330: x_return_status := fnd_api.g_ret_sts_unexp_error;

326: AND status.closed_flag = 'Y';
327:
328: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');
329: fnd_msg_pub.add;
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: RAISE fnd_api.g_exc_unexpected_error;
332: EXCEPTION
333: WHEN NO_DATA_FOUND
334: THEN

Line 331: RAISE fnd_api.g_exc_unexpected_error;

327:
328: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');
329: fnd_msg_pub.add;
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: RAISE fnd_api.g_exc_unexpected_error;
332: EXCEPTION
333: WHEN NO_DATA_FOUND
334: THEN
335: NULL;

Line 340: x_return_status := fnd_api.g_ret_sts_unexp_error;

336: WHEN TOO_MANY_ROWS
337: THEN
338: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');
339: fnd_msg_pub.add;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341: RAISE fnd_api.g_exc_unexpected_error;
342: END;
343:
344: --Created for BES enh 2660883

Line 341: RAISE fnd_api.g_exc_unexpected_error;

337: THEN
338: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');
339: fnd_msg_pub.add;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341: RAISE fnd_api.g_exc_unexpected_error;
342: END;
343:
344: --Created for BES enh 2660883
345: -- Code moved here to get the old values

Line 369: p_init_msg_list => fnd_api.g_false,

365: -- End of moved code
366:
367: jtf_task_references_pub.update_references (
368: p_api_version => 1.0,
369: p_init_msg_list => fnd_api.g_false,
370: p_commit => fnd_api.g_false,
371: p_object_version_number => p_object_version_number,
372: p_task_reference_id => p_escalation_reference_id,
373: p_object_type_code => p_object_type_code,

Line 370: p_commit => fnd_api.g_false,

366:
367: jtf_task_references_pub.update_references (
368: p_api_version => 1.0,
369: p_init_msg_list => fnd_api.g_false,
370: p_commit => fnd_api.g_false,
371: p_object_version_number => p_object_version_number,
372: p_task_reference_id => p_escalation_reference_id,
373: p_object_type_code => p_object_type_code,
374: p_object_name => p_object_name,

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

396: p_attribute15 => p_attribute15,
397: p_attribute_category => p_attribute_category
398: );
399:
400: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
401: THEN
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: RAISE fnd_api.g_exc_unexpected_error;
404: END IF;

Line 402: x_return_status := fnd_api.g_ret_sts_unexp_error;

398: );
399:
400: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
401: THEN
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: RAISE fnd_api.g_exc_unexpected_error;
404: END IF;
405:
406: IF fnd_api.to_boolean (p_commit)

Line 403: RAISE fnd_api.g_exc_unexpected_error;

399:
400: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
401: THEN
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: RAISE fnd_api.g_exc_unexpected_error;
404: END IF;
405:
406: IF fnd_api.to_boolean (p_commit)
407: THEN

Line 406: IF fnd_api.to_boolean (p_commit)

402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: RAISE fnd_api.g_exc_unexpected_error;
404: END IF;
405:
406: IF fnd_api.to_boolean (p_commit)
407: THEN
408: COMMIT WORK;
409: END IF;
410:

Line 424: WHEN fnd_api.g_exc_unexpected_error

420: END;
421: --End BES enh 2660883
422:
423: EXCEPTION
424: WHEN fnd_api.g_exc_unexpected_error
425: THEN
426: ROLLBACK TO update_references_pub;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 427: x_return_status := fnd_api.g_ret_sts_unexp_error;

423: EXCEPTION
424: WHEN fnd_api.g_exc_unexpected_error
425: THEN
426: ROLLBACK TO update_references_pub;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
429: WHEN NO_DATA_FOUND
430: THEN
431: ROLLBACK TO update_references_pub;

Line 436: x_return_status := fnd_api.g_ret_sts_unexp_error;

432: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
433: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
434: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
435: fnd_msg_pub.add;
436: x_return_status := fnd_api.g_ret_sts_unexp_error;
437: WHEN OTHERS
438: THEN
439: ROLLBACK TO update_references_pub;
440: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 443: x_return_status := fnd_api.g_ret_sts_unexp_error;

439: ROLLBACK TO update_references_pub;
440: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
441: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_unexp_error;
444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
445: END;
446:
447: ---------

Line 454: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

450: ---------
451: ---------
452: PROCEDURE delete_references (
453: p_api_version IN NUMBER,
454: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
455: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
456: p_object_version_number IN NUMBER,
457: p_escalation_reference_id IN NUMBER,
458: x_return_status OUT NOCOPY VARCHAR2,

Line 455: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

451: ---------
452: PROCEDURE delete_references (
453: p_api_version IN NUMBER,
454: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
455: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
456: p_object_version_number IN NUMBER,
457: p_escalation_reference_id IN NUMBER,
458: x_return_status OUT NOCOPY VARCHAR2,
459: x_msg_data OUT NOCOPY VARCHAR2,

Line 479: x_return_status := fnd_api.g_ret_sts_success;

475: rec_ref_orig c_ref_orig%ROWTYPE;
476:
477: BEGIN
478: SAVEPOINT delete_task_reference_pub;
479: x_return_status := fnd_api.g_ret_sts_success;
480:
481: IF NOT fnd_api.compatible_api_call (
482: l_api_version,
483: p_api_version,

Line 481: IF NOT fnd_api.compatible_api_call (

477: BEGIN
478: SAVEPOINT delete_task_reference_pub;
479: x_return_status := fnd_api.g_ret_sts_success;
480:
481: IF NOT fnd_api.compatible_api_call (
482: l_api_version,
483: p_api_version,
484: l_api_name,
485: g_pkg_name

Line 488: RAISE fnd_api.g_exc_unexpected_error;

484: l_api_name,
485: g_pkg_name
486: )
487: THEN
488: RAISE fnd_api.g_exc_unexpected_error;
489: END IF;
490:
491: IF fnd_api.to_boolean (p_init_msg_list)
492: THEN

Line 491: IF fnd_api.to_boolean (p_init_msg_list)

487: THEN
488: RAISE fnd_api.g_exc_unexpected_error;
489: END IF;
490:
491: IF fnd_api.to_boolean (p_init_msg_list)
492: THEN
493: fnd_msg_pub.initialize;
494: END IF;
495:

Line 504: p_init_msg_list => fnd_api.g_false,

500: --end
501:
502: jtf_task_references_pvt.delete_references (
503: p_api_version => 1.0,
504: p_init_msg_list => fnd_api.g_false,
505: p_commit => fnd_api.g_false,
506: p_object_version_number => p_object_version_number,
507: p_task_reference_id => p_escalation_reference_id,
508: x_return_status => x_return_status,

Line 505: p_commit => fnd_api.g_false,

501:
502: jtf_task_references_pvt.delete_references (
503: p_api_version => 1.0,
504: p_init_msg_list => fnd_api.g_false,
505: p_commit => fnd_api.g_false,
506: p_object_version_number => p_object_version_number,
507: p_task_reference_id => p_escalation_reference_id,
508: x_return_status => x_return_status,
509: x_msg_data => x_msg_data,

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

509: x_msg_data => x_msg_data,
510: x_msg_count => x_msg_count
511: );
512:
513: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
514: THEN
515: RAISE fnd_api.g_exc_unexpected_error;
516: END IF;
517:

Line 515: RAISE fnd_api.g_exc_unexpected_error;

511: );
512:
513: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
514: THEN
515: RAISE fnd_api.g_exc_unexpected_error;
516: END IF;
517:
518: IF fnd_api.to_boolean (p_commit)
519: THEN

Line 518: IF fnd_api.to_boolean (p_commit)

514: THEN
515: RAISE fnd_api.g_exc_unexpected_error;
516: END IF;
517:
518: IF fnd_api.to_boolean (p_commit)
519: THEN
520: COMMIT WORK;
521: END IF;
522:

Line 543: WHEN fnd_api.g_exc_unexpected_error

539: null;
540: END;
541: --End BES enh 2660883
542: EXCEPTION
543: WHEN fnd_api.g_exc_unexpected_error
544: THEN
545: ROLLBACK TO delete_task_reference_pub;
546: x_return_status := fnd_api.g_ret_sts_unexp_error;
547: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 546: x_return_status := fnd_api.g_ret_sts_unexp_error;

542: EXCEPTION
543: WHEN fnd_api.g_exc_unexpected_error
544: THEN
545: ROLLBACK TO delete_task_reference_pub;
546: x_return_status := fnd_api.g_ret_sts_unexp_error;
547: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
548: WHEN OTHERS
549: THEN
550: ROLLBACK TO delete_task_reference_pub;

Line 553: x_return_status := fnd_api.g_ret_sts_unexp_error;

549: THEN
550: ROLLBACK TO delete_task_reference_pub;
551: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
552: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
553: x_return_status := fnd_api.g_ret_sts_unexp_error;
554: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
555: END;
556:
557: END;