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_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_TASK_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_task_id IN NUMBER DEFAULT NULL,
10: p_object_type_code IN VARCHAR2 DEFAULT NULL,
11: p_object_name IN VARCHAR2 DEFAULT NULL,

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_task_id IN NUMBER DEFAULT NULL,
10: p_object_type_code IN VARCHAR2 DEFAULT NULL,
11: p_object_name IN VARCHAR2 DEFAULT NULL,
12: p_object_id IN NUMBER DEFAULT NULL,

Line 58: x_return_status := fnd_api.g_ret_sts_success;

54: BEGIN
55:
56: savepoint create_references_pvt ;
57:
58: x_return_status := fnd_api.g_ret_sts_success;
59:
60: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
61: THEN
62: RAISE fnd_api.g_exc_unexpected_error;

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

56: savepoint create_references_pvt ;
57:
58: x_return_status := fnd_api.g_ret_sts_success;
59:
60: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
61: THEN
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:

Line 62: RAISE fnd_api.g_exc_unexpected_error;

58: x_return_status := fnd_api.g_ret_sts_success;
59:
60: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
61: THEN
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:
65: IF fnd_api.to_boolean (p_init_msg_list)
66: THEN

Line 65: IF fnd_api.to_boolean (p_init_msg_list)

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

Line 79: RAISE fnd_api.g_exc_unexpected_error;

75: fnd_message.set_name('JTF','JTF_TASK_DUPLICATE_REF');
76: fnd_message.set_token('P_OBJECT_NAME',p_object_name);
77: fnd_message.set_token('P_OBJECT_TYPE',p_object_type_code);
78: fnd_msg_pub.add;
79: RAISE fnd_api.g_exc_unexpected_error;
80: else
81: jtf_task_utl.g_show_error_for_dup_reference := True;
82: return;
83: end if;

Line 137: x_return_status := fnd_api.g_ret_sts_unexp_error;

133: IF c_jtf_task_references%NOTFOUND
134: THEN
135: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_CREATING_REFER');
136: fnd_msg_pub.add;
137: x_return_status := fnd_api.g_ret_sts_unexp_error;
138: RAISE fnd_api.g_exc_unexpected_error;
139: ELSE
140: x_task_reference_id := l_task_reference_id;
141: END IF;

Line 138: RAISE fnd_api.g_exc_unexpected_error;

134: THEN
135: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_CREATING_REFER');
136: fnd_msg_pub.add;
137: x_return_status := fnd_api.g_ret_sts_unexp_error;
138: RAISE fnd_api.g_exc_unexpected_error;
139: ELSE
140: x_task_reference_id := l_task_reference_id;
141: END IF;
142:

Line 144: IF fnd_api.to_boolean (p_commit)

140: x_task_reference_id := l_task_reference_id;
141: END IF;
142:
143:
144: IF fnd_api.to_boolean (p_commit)
145: THEN
146: COMMIT WORK;
147: END IF;
148:

Line 152: WHEN fnd_api.g_exc_unexpected_error

148:
149: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
150:
151: EXCEPTION
152: WHEN fnd_api.g_exc_unexpected_error
153: THEN
154: ROLLBACK TO create_references_pvt;
155: x_return_status := fnd_api.g_ret_sts_unexp_error;
156: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 155: x_return_status := fnd_api.g_ret_sts_unexp_error;

151: EXCEPTION
152: WHEN fnd_api.g_exc_unexpected_error
153: THEN
154: ROLLBACK TO create_references_pvt;
155: x_return_status := fnd_api.g_ret_sts_unexp_error;
156: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
157: WHEN OTHERS
158: THEN
159: ROLLBACK TO create_references_pvt;

Line 163: x_return_status := fnd_api.g_ret_sts_unexp_error;

159: ROLLBACK TO create_references_pvt;
160: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
161: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
162: fnd_msg_pub.add;
163: x_return_status := fnd_api.g_ret_sts_unexp_error;
164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
165: END;
166:
167: PROCEDURE update_references (

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

165: END;
166:
167: PROCEDURE update_references (
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
170: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
171: p_object_version_number in OUT NOCOPY number,
172: p_task_reference_id IN NUMBER,
173: p_object_type_code IN VARCHAR2 DEFAULT NULL,

Line 170: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

166:
167: PROCEDURE update_references (
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
170: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
171: p_object_version_number in OUT NOCOPY number,
172: p_task_reference_id IN NUMBER,
173: p_object_type_code IN VARCHAR2 DEFAULT NULL,
174: p_object_name IN VARCHAR2 DEFAULT NULL,

Line 214: DECODE (p_task_reference_id, fnd_api.g_miss_num, task_reference_id, p_task_reference_id) task_reference_id,

210:
211: CURSOR c_task_reference
212: IS
213: SELECT task_id,
214: DECODE (p_task_reference_id, fnd_api.g_miss_num, task_reference_id, p_task_reference_id) task_reference_id,
215: DECODE (p_object_type_code, fnd_api.g_miss_char, object_type_code, p_object_type_code) object_type_code,
216: DECODE (p_object_name, fnd_api.g_miss_char, object_name, p_object_name) object_name,
217: DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,
218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,

Line 215: DECODE (p_object_type_code, fnd_api.g_miss_char, object_type_code, p_object_type_code) object_type_code,

211: CURSOR c_task_reference
212: IS
213: SELECT task_id,
214: DECODE (p_task_reference_id, fnd_api.g_miss_num, task_reference_id, p_task_reference_id) task_reference_id,
215: DECODE (p_object_type_code, fnd_api.g_miss_char, object_type_code, p_object_type_code) object_type_code,
216: DECODE (p_object_name, fnd_api.g_miss_char, object_name, p_object_name) object_name,
217: DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,
218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,
219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,

Line 216: DECODE (p_object_name, fnd_api.g_miss_char, object_name, p_object_name) object_name,

212: IS
213: SELECT task_id,
214: DECODE (p_task_reference_id, fnd_api.g_miss_num, task_reference_id, p_task_reference_id) task_reference_id,
215: DECODE (p_object_type_code, fnd_api.g_miss_char, object_type_code, p_object_type_code) object_type_code,
216: DECODE (p_object_name, fnd_api.g_miss_char, object_name, p_object_name) object_name,
217: DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,
218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,
219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,
220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,

Line 217: DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,

213: SELECT task_id,
214: DECODE (p_task_reference_id, fnd_api.g_miss_num, task_reference_id, p_task_reference_id) task_reference_id,
215: DECODE (p_object_type_code, fnd_api.g_miss_char, object_type_code, p_object_type_code) object_type_code,
216: DECODE (p_object_name, fnd_api.g_miss_char, object_name, p_object_name) object_name,
217: DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,
218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,
219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,
220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,
221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,

Line 218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,

214: DECODE (p_task_reference_id, fnd_api.g_miss_num, task_reference_id, p_task_reference_id) task_reference_id,
215: DECODE (p_object_type_code, fnd_api.g_miss_char, object_type_code, p_object_type_code) object_type_code,
216: DECODE (p_object_name, fnd_api.g_miss_char, object_name, p_object_name) object_name,
217: DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,
218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,
219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,
220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,
221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,

Line 219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,

215: DECODE (p_object_type_code, fnd_api.g_miss_char, object_type_code, p_object_type_code) object_type_code,
216: DECODE (p_object_name, fnd_api.g_miss_char, object_name, p_object_name) object_name,
217: DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,
218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,
219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,
220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,
221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,

Line 220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,

216: DECODE (p_object_name, fnd_api.g_miss_char, object_name, p_object_name) object_name,
217: DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,
218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,
219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,
220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,
221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,

Line 221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,

217: DECODE (p_object_id, fnd_api.g_miss_num, object_id, p_object_id) object_id,
218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,
219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,
220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,
221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,

Line 222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,

218: DECODE (p_object_details, fnd_api.g_miss_char, object_details, p_object_details) object_details,
219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,
220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,
221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,

Line 223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,

219: DECODE (p_reference_code, fnd_api.g_miss_char, reference_code, p_reference_code) reference_code,
220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,
221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,

Line 224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,

220: DECODE (p_usage, fnd_api.g_miss_char, usage, p_usage) usage,
221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,

Line 225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,

221: decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 ) attribute1 ,
222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,

Line 226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,

222: decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 ) attribute2 ,
223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,

Line 227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,

223: decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 ) attribute3 ,
224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,

Line 228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,

224: decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 ) attribute4 ,
225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,

Line 229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,

225: decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 ) attribute5 ,
226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
233: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,

Line 230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,

226: decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 ) attribute6 ,
227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
233: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
234: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,

Line 231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,

227: decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 ) attribute7 ,
228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
233: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
234: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
235: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,

Line 232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,

228: decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 ) attribute8 ,
229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
233: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
234: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
235: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
236: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category

Line 233: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,

229: decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 ) attribute9 ,
230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
233: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
234: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
235: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
236: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
237: FROM jtf_task_references_vl

Line 234: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,

230: decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 ) attribute10 ,
231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
233: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
234: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
235: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
236: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
237: FROM jtf_task_references_vl
238: WHERE task_reference_id = l_task_reference_id;

Line 235: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,

231: decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 ) attribute11 ,
232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
233: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
234: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
235: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
236: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
237: FROM jtf_task_references_vl
238: WHERE task_reference_id = l_task_reference_id;
239:

Line 236: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category

232: decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 ) attribute12 ,
233: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
234: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
235: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
236: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
237: FROM jtf_task_references_vl
238: WHERE task_reference_id = l_task_reference_id;
239:
240: task_references c_task_reference%ROWTYPE;

Line 245: x_return_status := fnd_api.g_ret_sts_success;

241: BEGIN
242:
243: savepoint update_task_reference_pvt ;
244:
245: x_return_status := fnd_api.g_ret_sts_success;
246:
247:
248: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
249: THEN

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

244:
245: x_return_status := fnd_api.g_ret_sts_success;
246:
247:
248: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
249: THEN
250: RAISE fnd_api.g_exc_unexpected_error;
251: END IF;
252:

Line 250: RAISE fnd_api.g_exc_unexpected_error;

246:
247:
248: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
249: THEN
250: RAISE fnd_api.g_exc_unexpected_error;
251: END IF;
252:
253: IF fnd_api.to_boolean (p_init_msg_list)
254: THEN

Line 253: IF fnd_api.to_boolean (p_init_msg_list)

249: THEN
250: RAISE fnd_api.g_exc_unexpected_error;
251: END IF;
252:
253: IF fnd_api.to_boolean (p_init_msg_list)
254: THEN
255: fnd_msg_pub.initialize;
256: END IF;
257:

Line 265: x_return_status := fnd_api.g_ret_sts_unexp_error;

261: THEN
262: fnd_message.set_name ('JTF', 'JTF_TASK_MISS_REFER');
263:
264: fnd_msg_pub.add;
265: x_return_status := fnd_api.g_ret_sts_unexp_error;
266: RAISE fnd_api.g_exc_unexpected_error;
267: END IF;
268:
269: OPEN c_task_reference;

Line 266: RAISE fnd_api.g_exc_unexpected_error;

262: fnd_message.set_name ('JTF', 'JTF_TASK_MISS_REFER');
263:
264: fnd_msg_pub.add;
265: x_return_status := fnd_api.g_ret_sts_unexp_error;
266: RAISE fnd_api.g_exc_unexpected_error;
267: END IF;
268:
269: OPEN c_task_reference;
270: FETCH c_task_reference INTO task_references;

Line 277: x_return_status := fnd_api.g_ret_sts_unexp_error;

273: THEN
274: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER');
275: fnd_message.set_token('P_TASK_REFERENCE_ID',p_task_reference_id);
276: fnd_msg_pub.add;
277: x_return_status := fnd_api.g_ret_sts_unexp_error;
278: RAISE fnd_api.g_exc_unexpected_error;
279: END IF;
280:
281: l_task_id := task_references.task_id;

Line 278: RAISE fnd_api.g_exc_unexpected_error;

274: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER');
275: fnd_message.set_token('P_TASK_REFERENCE_ID',p_task_reference_id);
276: fnd_msg_pub.add;
277: x_return_status := fnd_api.g_ret_sts_unexp_error;
278: RAISE fnd_api.g_exc_unexpected_error;
279: END IF;
280:
281: l_task_id := task_references.task_id;
282: l_reference_code := task_references.reference_code;

Line 308: RAISE fnd_api.g_exc_unexpected_error;

304: fnd_message.set_name('JTF','JTF_TASK_DUPLICATE_REF');
305: fnd_message.set_token('P_OBJECT_NAME',l_object_name);
306: fnd_message.set_token('P_OBJECT_TYPE',l_object_type_code);
307: fnd_msg_pub.add;
308: RAISE fnd_api.g_exc_unexpected_error;
309: else
310: jtf_task_utl.g_show_error_for_dup_reference := True;
311: return;
312: end if;

Line 317: P_INIT_MSG_LIST => fnd_api.g_false ,

313: end if;
314:
315: jtf_task_references_pub.lock_references
316: ( P_API_VERSION => 1.0,
317: P_INIT_MSG_LIST => fnd_api.g_false ,
318: P_COMMIT => fnd_api.g_false ,
319: P_TASK_reference_ID => l_task_reference_id ,
320: P_OBJECT_VERSION_NUMBER => p_object_version_number,
321: X_RETURN_STATUS => x_return_status ,

Line 318: P_COMMIT => fnd_api.g_false ,

314:
315: jtf_task_references_pub.lock_references
316: ( P_API_VERSION => 1.0,
317: P_INIT_MSG_LIST => fnd_api.g_false ,
318: P_COMMIT => fnd_api.g_false ,
319: P_TASK_reference_ID => l_task_reference_id ,
320: P_OBJECT_VERSION_NUMBER => p_object_version_number,
321: X_RETURN_STATUS => x_return_status ,
322: X_MSG_DATA => x_msg_data ,

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

321: X_RETURN_STATUS => x_return_status ,
322: X_MSG_DATA => x_msg_data ,
323: X_MSG_COUNT => x_msg_count ) ;
324:
325: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
326: THEN
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328: RAISE fnd_api.g_exc_unexpected_error;
329: END IF;

Line 327: x_return_status := fnd_api.g_ret_sts_unexp_error;

323: X_MSG_COUNT => x_msg_count ) ;
324:
325: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
326: THEN
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328: RAISE fnd_api.g_exc_unexpected_error;
329: END IF;
330:
331: p_object_version_number := p_object_version_number + 1 ;

Line 328: RAISE fnd_api.g_exc_unexpected_error;

324:
325: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
326: THEN
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328: RAISE fnd_api.g_exc_unexpected_error;
329: END IF;
330:
331: p_object_version_number := p_object_version_number + 1 ;
332:

Line 365: WHEN fnd_api.g_exc_unexpected_error

361: x_object_version_number => p_object_version_number
362: );
363:
364: EXCEPTION
365: WHEN fnd_api.g_exc_unexpected_error
366: THEN
367: ROLLBACK TO update_task_reference_pvt;
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 368: x_return_status := fnd_api.g_ret_sts_unexp_error;

364: EXCEPTION
365: WHEN fnd_api.g_exc_unexpected_error
366: THEN
367: ROLLBACK TO update_task_reference_pvt;
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
370: WHEN OTHERS
371: THEN
372: ROLLBACK TO update_task_reference_pvt;

Line 376: x_return_status := fnd_api.g_ret_sts_unexp_error;

372: ROLLBACK TO update_task_reference_pvt;
373: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
374: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
375: fnd_msg_pub.add;
376: x_return_status := fnd_api.g_ret_sts_unexp_error;
377: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
378: END;
379:
380:

Line 383: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

379:
380:
381: PROCEDURE delete_references (
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
384: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
385: p_object_version_number in number,
386: p_task_reference_id IN NUMBER,
387: x_return_status OUT NOCOPY VARCHAR2,

Line 384: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

380:
381: PROCEDURE delete_references (
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
384: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
385: p_object_version_number in number,
386: p_task_reference_id IN NUMBER,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_data OUT NOCOPY VARCHAR2,

Line 410: x_return_status := fnd_api.g_ret_sts_success;

406: BEGIN
407:
408: SAVEPOINT delete_task_reference_pvt;
409:
410: x_return_status := fnd_api.g_ret_sts_success;
411:
412: IF fnd_api.to_boolean (p_init_msg_list)
413: THEN
414: fnd_msg_pub.initialize;

Line 412: IF fnd_api.to_boolean (p_init_msg_list)

408: SAVEPOINT delete_task_reference_pvt;
409:
410: x_return_status := fnd_api.g_ret_sts_success;
411:
412: IF fnd_api.to_boolean (p_init_msg_list)
413: THEN
414: fnd_msg_pub.initialize;
415: END IF;
416:

Line 426: RAISE fnd_api.g_exc_unexpected_error;

422:
423: IF (c_jtf_task_ref_delete%NOTFOUND) THEN
424: fnd_message.set_name ('JTF', 'JTF_TASK_REFERENCE_NOT_FOUND');
425: fnd_msg_pub.add;
426: RAISE fnd_api.g_exc_unexpected_error;
427: END IF;
428:
429:
430: CLOSE c_jtf_task_ref_delete ;

Line 449: x_return_status := fnd_api.g_ret_sts_error;

445: --task is created. Refer to bug 3875523.
446:
447: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_REF_DELETE');
448: fnd_msg_pub.add;
449: x_return_status := fnd_api.g_ret_sts_error;
450: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data =>x_msg_data);
451: return;
452:
453: end if;

Line 466: IF fnd_api.to_boolean (p_commit)

462: jtf_task_references_pkg.delete_row (
463: x_task_reference_id => p_task_reference_id);
464:
465:
466: IF fnd_api.to_boolean (p_commit)
467: THEN
468: COMMIT WORK;
469: END IF;
470:

Line 481: x_return_status := fnd_api.g_ret_sts_unexp_error;

477: THEN
478: ROLLBACK TO delete_task_reference_pvt;
479: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_DELETING_REFER');
480: fnd_msg_pub.add;
481: x_return_status := fnd_api.g_ret_sts_unexp_error;
482: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
483:
484: WHEN fnd_api.g_exc_unexpected_error
485: THEN

Line 484: WHEN fnd_api.g_exc_unexpected_error

480: fnd_msg_pub.add;
481: x_return_status := fnd_api.g_ret_sts_unexp_error;
482: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
483:
484: WHEN fnd_api.g_exc_unexpected_error
485: THEN
486: ROLLBACK TO delete_task_reference_pvt;
487: if (c_jtf_task_ref_delete%ISOPEN) THEN
488: CLOSE c_jtf_task_ref_delete;

Line 490: x_return_status := fnd_api.g_ret_sts_unexp_error;

486: ROLLBACK TO delete_task_reference_pvt;
487: if (c_jtf_task_ref_delete%ISOPEN) THEN
488: CLOSE c_jtf_task_ref_delete;
489: END IF;
490: x_return_status := fnd_api.g_ret_sts_unexp_error;
491: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
492:
493: WHEN OTHERS
494: THEN

Line 499: x_return_status := fnd_api.g_ret_sts_unexp_error;

495: ROLLBACK TO delete_task_reference_pvt;
496: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
497: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
498: fnd_msg_pub.add;
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
501: END;
502: END;