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

Line 8: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

4:
5: /*Procedure used internally*/
6: PROCEDURE SET_COUNTER_STATUS (
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,

Line 9: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

5: /*Procedure used internally*/
6: PROCEDURE SET_COUNTER_STATUS (
7: p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_object_version_number IN OUT NOCOPY NUMBER,

Line 35: x_return_status := fnd_api.g_ret_sts_success;

31: l_task C_Task%Rowtype;
32:
33: BEGIN
34: SAVEPOINT SET_COUNTER_STATUS;
35: x_return_status := fnd_api.g_ret_sts_success;
36:
37: IF fnd_api.to_boolean (p_init_msg_list)
38: THEN
39: fnd_msg_pub.initialize;

Line 37: IF fnd_api.to_boolean (p_init_msg_list)

33: BEGIN
34: SAVEPOINT SET_COUNTER_STATUS;
35: x_return_status := fnd_api.g_ret_sts_success;
36:
37: IF fnd_api.to_boolean (p_init_msg_list)
38: THEN
39: fnd_msg_pub.initialize;
40: END IF;
41:

Line 42: IF NOT fnd_api.compatible_api_call (

38: THEN
39: fnd_msg_pub.initialize;
40: END IF;
41:
42: IF NOT fnd_api.compatible_api_call (
43: l_api_version,
44: p_api_version,
45: l_api_name,
46: g_pkg_name

Line 49: RAISE fnd_api.g_exc_unexpected_error;

45: l_api_name,
46: g_pkg_name
47: )
48: THEN
49: RAISE fnd_api.g_exc_unexpected_error;
50: END IF;
51:
52: Open C_Task;
53: Fetch C_Task Into l_task;

Line 58: p_init_msg_list => fnd_api.g_false,

54: Close C_Task;
55:
56: jtf_tasks_pvt.update_task (
57: p_api_version => 1.0,
58: p_init_msg_list => fnd_api.g_false,
59: p_commit => fnd_api.g_false,
60: p_object_version_number => p_object_version_number,
61: p_task_id => p_task_id,
62: p_enable_workflow => jtf_task_utl.g_miss_char,

Line 59: p_commit => fnd_api.g_false,

55:
56: jtf_tasks_pvt.update_task (
57: p_api_version => 1.0,
58: p_init_msg_list => fnd_api.g_false,
59: p_commit => fnd_api.g_false,
60: p_object_version_number => p_object_version_number,
61: p_task_id => p_task_id,
62: p_enable_workflow => jtf_task_utl.g_miss_char,
63: p_abort_workflow => jtf_task_utl.g_miss_char,

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

73: x_msg_data => x_msg_data,
74: p_location_id => l_task.location_id
75: );
76:
77: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
78: THEN
79: RAISE fnd_api.g_exc_unexpected_error;
80: END IF;
81:

Line 79: RAISE fnd_api.g_exc_unexpected_error;

75: );
76:
77: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
78: THEN
79: RAISE fnd_api.g_exc_unexpected_error;
80: END IF;
81:
82: IF fnd_api.to_boolean (p_commit)
83: THEN

Line 82: IF fnd_api.to_boolean (p_commit)

78: THEN
79: RAISE fnd_api.g_exc_unexpected_error;
80: END IF;
81:
82: IF fnd_api.to_boolean (p_commit)
83: THEN
84: COMMIT WORK;
85: END IF;
86:

Line 89: WHEN fnd_api.g_exc_unexpected_error

85: END IF;
86:
87: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
88: EXCEPTION
89: WHEN fnd_api.g_exc_unexpected_error
90: THEN
91: ROLLBACK TO SET_COUNTER_STATUS;
92: x_return_status := fnd_api.g_ret_sts_unexp_error;
93: fnd_msg_pub.count_and_get (

Line 92: x_return_status := fnd_api.g_ret_sts_unexp_error;

88: EXCEPTION
89: WHEN fnd_api.g_exc_unexpected_error
90: THEN
91: ROLLBACK TO SET_COUNTER_STATUS;
92: x_return_status := fnd_api.g_ret_sts_unexp_error;
93: fnd_msg_pub.count_and_get (
94: p_count => x_msg_count,
95: p_data => x_msg_data
96: );

Line 97: WHEN fnd_api.g_exc_error

93: fnd_msg_pub.count_and_get (
94: p_count => x_msg_count,
95: p_data => x_msg_data
96: );
97: WHEN fnd_api.g_exc_error
98: THEN
99: ROLLBACK TO SET_COUNTER_STATUS;
100: x_return_status := fnd_api.G_RET_STS_ERROR;
101: fnd_msg_pub.count_and_get (

Line 100: x_return_status := fnd_api.G_RET_STS_ERROR;

96: );
97: WHEN fnd_api.g_exc_error
98: THEN
99: ROLLBACK TO SET_COUNTER_STATUS;
100: x_return_status := fnd_api.G_RET_STS_ERROR;
101: fnd_msg_pub.count_and_get (
102: p_count => x_msg_count,
103: p_data => x_msg_data
104: );

Line 111: x_return_status := fnd_api.g_ret_sts_unexp_error;

107: ROLLBACK TO SET_COUNTER_STATUS;
108: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
109: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
110: fnd_msg_pub.add;
111: x_return_status := fnd_api.g_ret_sts_unexp_error;
112: fnd_msg_pub.count_and_get (
113: p_count => x_msg_count,
114: p_data => x_msg_data
115: );

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

117: END SET_COUNTER_STATUS;
118:
119: PROCEDURE RESET_COUNTER (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
122: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,

Line 122: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

118:
119: PROCEDURE RESET_COUNTER (
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
122: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_object_version_number IN OUT NOCOPY NUMBER,

Line 136: x_return_status := fnd_api.g_ret_sts_success;

132: l_api_name CONSTANT VARCHAR2(30)
133: := 'RESET_COUNTER';
134: BEGIN
135: SAVEPOINT RESET_COUNTER;
136: x_return_status := fnd_api.g_ret_sts_success;
137:
138: IF fnd_api.to_boolean (p_init_msg_list)
139: THEN
140: fnd_msg_pub.initialize;

Line 138: IF fnd_api.to_boolean (p_init_msg_list)

134: BEGIN
135: SAVEPOINT RESET_COUNTER;
136: x_return_status := fnd_api.g_ret_sts_success;
137:
138: IF fnd_api.to_boolean (p_init_msg_list)
139: THEN
140: fnd_msg_pub.initialize;
141: END IF;
142:

Line 143: IF NOT fnd_api.compatible_api_call (

139: THEN
140: fnd_msg_pub.initialize;
141: END IF;
142:
143: IF NOT fnd_api.compatible_api_call (
144: l_api_version,
145: p_api_version,
146: l_api_name,
147: g_pkg_name

Line 150: RAISE fnd_api.g_exc_unexpected_error;

146: l_api_name,
147: g_pkg_name
148: )
149: THEN
150: RAISE fnd_api.g_exc_unexpected_error;
151: END IF;
152:
153: SET_COUNTER_STATUS
154: (

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

163: p_task_confirmation_status => jtf_task_utl.g_miss_char,
164: p_task_confirmation_counter => 0
165: );
166:
167: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
168: THEN
169: RAISE fnd_api.g_exc_unexpected_error;
170: END IF;
171:

Line 169: RAISE fnd_api.g_exc_unexpected_error;

165: );
166:
167: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
168: THEN
169: RAISE fnd_api.g_exc_unexpected_error;
170: END IF;
171:
172: IF fnd_api.to_boolean (p_commit)
173: THEN

Line 172: IF fnd_api.to_boolean (p_commit)

168: THEN
169: RAISE fnd_api.g_exc_unexpected_error;
170: END IF;
171:
172: IF fnd_api.to_boolean (p_commit)
173: THEN
174: COMMIT WORK;
175: END IF;
176:

Line 179: WHEN fnd_api.g_exc_unexpected_error

175: END IF;
176:
177: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
178: EXCEPTION
179: WHEN fnd_api.g_exc_unexpected_error
180: THEN
181: ROLLBACK TO RESET_COUNTER;
182: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
183: fnd_msg_pub.count_and_get (

Line 182: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

178: EXCEPTION
179: WHEN fnd_api.g_exc_unexpected_error
180: THEN
181: ROLLBACK TO RESET_COUNTER;
182: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
183: fnd_msg_pub.count_and_get (
184: p_count => x_msg_count,
185: p_data => x_msg_data
186: );

Line 187: WHEN fnd_api.g_exc_error

183: fnd_msg_pub.count_and_get (
184: p_count => x_msg_count,
185: p_data => x_msg_data
186: );
187: WHEN fnd_api.g_exc_error
188: THEN
189: ROLLBACK TO RESET_COUNTER;
190: x_return_status := fnd_api.G_RET_STS_ERROR;
191: fnd_msg_pub.count_and_get (

Line 190: x_return_status := fnd_api.G_RET_STS_ERROR;

186: );
187: WHEN fnd_api.g_exc_error
188: THEN
189: ROLLBACK TO RESET_COUNTER;
190: x_return_status := fnd_api.G_RET_STS_ERROR;
191: fnd_msg_pub.count_and_get (
192: p_count => x_msg_count,
193: p_data => x_msg_data
194: );

Line 201: x_return_status := fnd_api.g_ret_sts_unexp_error;

197: ROLLBACK TO RESET_COUNTER;
198: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
199: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
200: fnd_msg_pub.add;
201: x_return_status := fnd_api.g_ret_sts_unexp_error;
202: fnd_msg_pub.count_and_get (
203: p_count => x_msg_count,
204: p_data => x_msg_data
205: );

Line 228: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

224: END;
225:
226: PROCEDURE INCREASE_COUNTER (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
229: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,

Line 229: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

225:
226: PROCEDURE INCREASE_COUNTER (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
229: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_object_version_number IN OUT NOCOPY NUMBER,

Line 246: x_return_status := fnd_api.g_ret_sts_success;

242: l_ovn NUMBER := p_object_version_number;
243:
244: BEGIN
245: SAVEPOINT INCREASE_COUNTER;
246: x_return_status := fnd_api.g_ret_sts_success;
247:
248: IF fnd_api.to_boolean (p_init_msg_list)
249: THEN
250: fnd_msg_pub.initialize;

Line 248: IF fnd_api.to_boolean (p_init_msg_list)

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

Line 253: IF NOT fnd_api.compatible_api_call (

249: THEN
250: fnd_msg_pub.initialize;
251: END IF;
252:
253: IF NOT fnd_api.compatible_api_call (
254: l_api_version,
255: p_api_version,
256: l_api_name,
257: g_pkg_name

Line 260: RAISE fnd_api.g_exc_unexpected_error;

256: l_api_name,
257: g_pkg_name
258: )
259: THEN
260: RAISE fnd_api.g_exc_unexpected_error;
261: END IF;
262:
263: l_conf_counter := get_conf_counter (p_task_id);
264:

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

275: p_task_confirmation_status => jtf_task_utl.g_miss_char,
276: p_task_confirmation_counter => nvl(l_conf_counter,0) + 1
277: );
278:
279: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
280: THEN
281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
283:

Line 281: RAISE fnd_api.g_exc_unexpected_error;

277: );
278:
279: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
280: THEN
281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
283:
284: IF fnd_api.to_boolean (p_commit)
285: THEN

Line 284: IF fnd_api.to_boolean (p_commit)

280: THEN
281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
283:
284: IF fnd_api.to_boolean (p_commit)
285: THEN
286: COMMIT WORK;
287: END IF;
288:

Line 291: WHEN fnd_api.g_exc_unexpected_error

287: END IF;
288:
289: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
290: EXCEPTION
291: WHEN fnd_api.g_exc_unexpected_error
292: THEN
293: ROLLBACK TO INCREASE_COUNTER;
294: x_return_status := fnd_api.g_ret_sts_unexp_error;
295: fnd_msg_pub.count_and_get (

Line 294: x_return_status := fnd_api.g_ret_sts_unexp_error;

290: EXCEPTION
291: WHEN fnd_api.g_exc_unexpected_error
292: THEN
293: ROLLBACK TO INCREASE_COUNTER;
294: x_return_status := fnd_api.g_ret_sts_unexp_error;
295: fnd_msg_pub.count_and_get (
296: p_count => x_msg_count,
297: p_data => x_msg_data
298: );

Line 299: WHEN fnd_api.g_exc_error

295: fnd_msg_pub.count_and_get (
296: p_count => x_msg_count,
297: p_data => x_msg_data
298: );
299: WHEN fnd_api.g_exc_error
300: THEN
301: ROLLBACK TO INCREASE_COUNTER;
302: x_return_status := fnd_api.G_RET_STS_ERROR;
303: fnd_msg_pub.count_and_get (

Line 302: x_return_status := fnd_api.G_RET_STS_ERROR;

298: );
299: WHEN fnd_api.g_exc_error
300: THEN
301: ROLLBACK TO INCREASE_COUNTER;
302: x_return_status := fnd_api.G_RET_STS_ERROR;
303: fnd_msg_pub.count_and_get (
304: p_count => x_msg_count,
305: p_data => x_msg_data
306: );

Line 313: x_return_status := fnd_api.g_ret_sts_unexp_error;

309: ROLLBACK TO INCREASE_COUNTER;
310: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
311: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
312: fnd_msg_pub.add;
313: x_return_status := fnd_api.g_ret_sts_unexp_error;
314: fnd_msg_pub.count_and_get (
315: p_count => x_msg_count,
316: p_data => x_msg_data
317: );

Line 323: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

319: END INCREASE_COUNTER;
320:
321: PROCEDURE DECREASE_COUNTER (
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
324: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,

Line 324: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

320:
321: PROCEDURE DECREASE_COUNTER (
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
324: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_object_version_number IN OUT NOCOPY NUMBER,

Line 341: x_return_status := fnd_api.g_ret_sts_success;

337: l_conf_counter NUMBER;
338:
339: BEGIN
340: SAVEPOINT DECREASE_COUNTER;
341: x_return_status := fnd_api.g_ret_sts_success;
342:
343: IF fnd_api.to_boolean (p_init_msg_list)
344: THEN
345: fnd_msg_pub.initialize;

Line 343: IF fnd_api.to_boolean (p_init_msg_list)

339: BEGIN
340: SAVEPOINT DECREASE_COUNTER;
341: x_return_status := fnd_api.g_ret_sts_success;
342:
343: IF fnd_api.to_boolean (p_init_msg_list)
344: THEN
345: fnd_msg_pub.initialize;
346: END IF;
347:

Line 348: IF NOT fnd_api.compatible_api_call (

344: THEN
345: fnd_msg_pub.initialize;
346: END IF;
347:
348: IF NOT fnd_api.compatible_api_call (
349: l_api_version,
350: p_api_version,
351: l_api_name,
352: g_pkg_name

Line 355: RAISE fnd_api.g_exc_unexpected_error;

351: l_api_name,
352: g_pkg_name
353: )
354: THEN
355: RAISE fnd_api.g_exc_unexpected_error;
356: END IF;
357:
358: l_conf_counter := get_conf_counter (p_task_id);
359:

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

370: p_task_confirmation_status => jtf_task_utl.g_miss_char,
371: p_task_confirmation_counter => nvl(l_conf_counter,0) - 1
372: );
373:
374: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
375: THEN
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378:

Line 376: RAISE fnd_api.g_exc_unexpected_error;

372: );
373:
374: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
375: THEN
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378:
379: IF fnd_api.to_boolean (p_commit)
380: THEN

Line 379: IF fnd_api.to_boolean (p_commit)

375: THEN
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378:
379: IF fnd_api.to_boolean (p_commit)
380: THEN
381: COMMIT WORK;
382: END IF;
383:

Line 386: WHEN fnd_api.g_exc_unexpected_error

382: END IF;
383:
384: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
385: EXCEPTION
386: WHEN fnd_api.g_exc_unexpected_error
387: THEN
388: ROLLBACK TO DECREASE_COUNTER;
389: x_return_status := fnd_api.g_ret_sts_unexp_error;
390: fnd_msg_pub.count_and_get (

Line 389: x_return_status := fnd_api.g_ret_sts_unexp_error;

385: EXCEPTION
386: WHEN fnd_api.g_exc_unexpected_error
387: THEN
388: ROLLBACK TO DECREASE_COUNTER;
389: x_return_status := fnd_api.g_ret_sts_unexp_error;
390: fnd_msg_pub.count_and_get (
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );

Line 394: WHEN fnd_api.g_exc_error

390: fnd_msg_pub.count_and_get (
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );
394: WHEN fnd_api.g_exc_error
395: THEN
396: ROLLBACK TO DECREASE_COUNTER;
397: x_return_status := fnd_api.G_RET_STS_ERROR;
398: fnd_msg_pub.count_and_get (

Line 397: x_return_status := fnd_api.G_RET_STS_ERROR;

393: );
394: WHEN fnd_api.g_exc_error
395: THEN
396: ROLLBACK TO DECREASE_COUNTER;
397: x_return_status := fnd_api.G_RET_STS_ERROR;
398: fnd_msg_pub.count_and_get (
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );

Line 408: x_return_status := fnd_api.g_ret_sts_unexp_error;

404: ROLLBACK TO DECREASE_COUNTER;
405: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
406: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
407: fnd_msg_pub.add;
408: x_return_status := fnd_api.g_ret_sts_unexp_error;
409: fnd_msg_pub.count_and_get (
410: p_count => x_msg_count,
411: p_data => x_msg_data
412: );

Line 418: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

414: END DECREASE_COUNTER;
415:
416: PROCEDURE CHANGE_COUNTER_SIGN (
417: p_api_version IN NUMBER,
418: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
419: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
420: x_return_status OUT NOCOPY VARCHAR2,
421: x_msg_count OUT NOCOPY NUMBER,
422: x_msg_data OUT NOCOPY VARCHAR2,

Line 419: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

415:
416: PROCEDURE CHANGE_COUNTER_SIGN (
417: p_api_version IN NUMBER,
418: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
419: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
420: x_return_status OUT NOCOPY VARCHAR2,
421: x_msg_count OUT NOCOPY NUMBER,
422: x_msg_data OUT NOCOPY VARCHAR2,
423: p_object_version_number IN OUT NOCOPY NUMBER,

Line 436: x_return_status := fnd_api.g_ret_sts_success;

432: l_conf_counter NUMBER;
433:
434: BEGIN
435: SAVEPOINT CHANGE_COUNTER_SIGN;
436: x_return_status := fnd_api.g_ret_sts_success;
437:
438: IF fnd_api.to_boolean (p_init_msg_list)
439: THEN
440: fnd_msg_pub.initialize;

Line 438: IF fnd_api.to_boolean (p_init_msg_list)

434: BEGIN
435: SAVEPOINT CHANGE_COUNTER_SIGN;
436: x_return_status := fnd_api.g_ret_sts_success;
437:
438: IF fnd_api.to_boolean (p_init_msg_list)
439: THEN
440: fnd_msg_pub.initialize;
441: END IF;
442:

Line 443: IF NOT fnd_api.compatible_api_call (

439: THEN
440: fnd_msg_pub.initialize;
441: END IF;
442:
443: IF NOT fnd_api.compatible_api_call (
444: l_api_version,
445: p_api_version,
446: l_api_name,
447: g_pkg_name

Line 450: RAISE fnd_api.g_exc_unexpected_error;

446: l_api_name,
447: g_pkg_name
448: )
449: THEN
450: RAISE fnd_api.g_exc_unexpected_error;
451: END IF;
452:
453: l_conf_counter := get_conf_counter (p_task_id);
454:

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

465: p_task_confirmation_status => jtf_task_utl.g_miss_char,
466: p_task_confirmation_counter => nvl(l_conf_counter,0)*(-1)
467: );
468:
469: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
470: THEN
471: RAISE fnd_api.g_exc_unexpected_error;
472: END IF;
473:

Line 471: RAISE fnd_api.g_exc_unexpected_error;

467: );
468:
469: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
470: THEN
471: RAISE fnd_api.g_exc_unexpected_error;
472: END IF;
473:
474: IF fnd_api.to_boolean (p_commit)
475: THEN

Line 474: IF fnd_api.to_boolean (p_commit)

470: THEN
471: RAISE fnd_api.g_exc_unexpected_error;
472: END IF;
473:
474: IF fnd_api.to_boolean (p_commit)
475: THEN
476: COMMIT WORK;
477: END IF;
478:

Line 481: WHEN fnd_api.g_exc_unexpected_error

477: END IF;
478:
479: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
480: EXCEPTION
481: WHEN fnd_api.g_exc_unexpected_error
482: THEN
483: ROLLBACK TO CHANGE_COUNTER_SIGN;
484: x_return_status := fnd_api.g_ret_sts_unexp_error;
485: fnd_msg_pub.count_and_get (

Line 484: x_return_status := fnd_api.g_ret_sts_unexp_error;

480: EXCEPTION
481: WHEN fnd_api.g_exc_unexpected_error
482: THEN
483: ROLLBACK TO CHANGE_COUNTER_SIGN;
484: x_return_status := fnd_api.g_ret_sts_unexp_error;
485: fnd_msg_pub.count_and_get (
486: p_count => x_msg_count,
487: p_data => x_msg_data
488: );

Line 489: WHEN fnd_api.g_exc_error

485: fnd_msg_pub.count_and_get (
486: p_count => x_msg_count,
487: p_data => x_msg_data
488: );
489: WHEN fnd_api.g_exc_error
490: THEN
491: ROLLBACK TO CHANGE_COUNTER_SIGN;
492: x_return_status := fnd_api.G_RET_STS_ERROR;
493: fnd_msg_pub.count_and_get (

Line 492: x_return_status := fnd_api.G_RET_STS_ERROR;

488: );
489: WHEN fnd_api.g_exc_error
490: THEN
491: ROLLBACK TO CHANGE_COUNTER_SIGN;
492: x_return_status := fnd_api.G_RET_STS_ERROR;
493: fnd_msg_pub.count_and_get (
494: p_count => x_msg_count,
495: p_data => x_msg_data
496: );

Line 503: x_return_status := fnd_api.g_ret_sts_unexp_error;

499: ROLLBACK TO CHANGE_COUNTER_SIGN;
500: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
501: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
502: fnd_msg_pub.add;
503: x_return_status := fnd_api.g_ret_sts_unexp_error;
504: fnd_msg_pub.count_and_get (
505: p_count => x_msg_count,
506: p_data => x_msg_data
507: );

Line 513: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

509: END CHANGE_COUNTER_SIGN;
510:
511: PROCEDURE RESET_CONFIRMATION_STATUS (
512: p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
514: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
515: x_return_status OUT NOCOPY VARCHAR2,
516: x_msg_count OUT NOCOPY NUMBER,
517: x_msg_data OUT NOCOPY VARCHAR2,

Line 514: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

510:
511: PROCEDURE RESET_CONFIRMATION_STATUS (
512: p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
514: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
515: x_return_status OUT NOCOPY VARCHAR2,
516: x_msg_count OUT NOCOPY NUMBER,
517: x_msg_data OUT NOCOPY VARCHAR2,
518: p_object_version_number IN OUT NOCOPY NUMBER,

Line 533: x_return_status := fnd_api.g_ret_sts_success;

529:
530:
531: BEGIN
532: SAVEPOINT RESET_CONFIRMATION_STATUS;
533: x_return_status := fnd_api.g_ret_sts_success;
534:
535: IF fnd_api.to_boolean (p_init_msg_list)
536: THEN
537: fnd_msg_pub.initialize;

Line 535: IF fnd_api.to_boolean (p_init_msg_list)

531: BEGIN
532: SAVEPOINT RESET_CONFIRMATION_STATUS;
533: x_return_status := fnd_api.g_ret_sts_success;
534:
535: IF fnd_api.to_boolean (p_init_msg_list)
536: THEN
537: fnd_msg_pub.initialize;
538: END IF;
539:

Line 540: IF NOT fnd_api.compatible_api_call (

536: THEN
537: fnd_msg_pub.initialize;
538: END IF;
539:
540: IF NOT fnd_api.compatible_api_call (
541: l_api_version,
542: p_api_version,
543: l_api_name,
544: g_pkg_name

Line 547: RAISE fnd_api.g_exc_unexpected_error;

543: l_api_name,
544: g_pkg_name
545: )
546: THEN
547: RAISE fnd_api.g_exc_unexpected_error;
548: END IF;
549:
550: SET_COUNTER_STATUS
551: (

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

560: p_task_confirmation_status => 'N',
561: p_task_confirmation_counter => 0
562: );
563:
564: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
565: THEN
566: RAISE fnd_api.g_exc_unexpected_error;
567: END IF;
568:

Line 566: RAISE fnd_api.g_exc_unexpected_error;

562: );
563:
564: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
565: THEN
566: RAISE fnd_api.g_exc_unexpected_error;
567: END IF;
568:
569: IF fnd_api.to_boolean (p_commit)
570: THEN

Line 569: IF fnd_api.to_boolean (p_commit)

565: THEN
566: RAISE fnd_api.g_exc_unexpected_error;
567: END IF;
568:
569: IF fnd_api.to_boolean (p_commit)
570: THEN
571: COMMIT WORK;
572: END IF;
573:

Line 576: WHEN fnd_api.g_exc_unexpected_error

572: END IF;
573:
574: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
575: EXCEPTION
576: WHEN fnd_api.g_exc_unexpected_error
577: THEN
578: ROLLBACK TO RESET_CONFIRMATION_STATUS;
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: fnd_msg_pub.count_and_get (

Line 579: x_return_status := fnd_api.g_ret_sts_unexp_error;

575: EXCEPTION
576: WHEN fnd_api.g_exc_unexpected_error
577: THEN
578: ROLLBACK TO RESET_CONFIRMATION_STATUS;
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: fnd_msg_pub.count_and_get (
581: p_count => x_msg_count,
582: p_data => x_msg_data
583: );

Line 584: WHEN fnd_api.g_exc_error

580: fnd_msg_pub.count_and_get (
581: p_count => x_msg_count,
582: p_data => x_msg_data
583: );
584: WHEN fnd_api.g_exc_error
585: THEN
586: ROLLBACK TO RESET_CONFIRMATION_STATUS;
587: x_return_status := fnd_api.G_RET_STS_ERROR;
588: fnd_msg_pub.count_and_get (

Line 587: x_return_status := fnd_api.G_RET_STS_ERROR;

583: );
584: WHEN fnd_api.g_exc_error
585: THEN
586: ROLLBACK TO RESET_CONFIRMATION_STATUS;
587: x_return_status := fnd_api.G_RET_STS_ERROR;
588: fnd_msg_pub.count_and_get (
589: p_count => x_msg_count,
590: p_data => x_msg_data
591: );

Line 598: x_return_status := fnd_api.g_ret_sts_unexp_error;

594: ROLLBACK TO RESET_CONFIRMATION_STATUS;
595: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
596: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
597: fnd_msg_pub.add;
598: x_return_status := fnd_api.g_ret_sts_unexp_error;
599: fnd_msg_pub.count_and_get (
600: p_count => x_msg_count,
601: p_data => x_msg_data
602: );

Line 608: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

604: END RESET_CONFIRMATION_STATUS;
605:
606: PROCEDURE SET_CONFIRMATION_REQUIRED (
607: p_api_version IN NUMBER,
608: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
609: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,

Line 609: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

605:
606: PROCEDURE SET_CONFIRMATION_REQUIRED (
607: p_api_version IN NUMBER,
608: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
609: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,
613: p_object_version_number IN OUT NOCOPY NUMBER,

Line 628: x_return_status := fnd_api.g_ret_sts_success;

624:
625:
626: BEGIN
627: SAVEPOINT SET_CONFIRMATION_REQUIRED;
628: x_return_status := fnd_api.g_ret_sts_success;
629:
630: IF fnd_api.to_boolean (p_init_msg_list)
631: THEN
632: fnd_msg_pub.initialize;

Line 630: IF fnd_api.to_boolean (p_init_msg_list)

626: BEGIN
627: SAVEPOINT SET_CONFIRMATION_REQUIRED;
628: x_return_status := fnd_api.g_ret_sts_success;
629:
630: IF fnd_api.to_boolean (p_init_msg_list)
631: THEN
632: fnd_msg_pub.initialize;
633: END IF;
634:

Line 635: IF NOT fnd_api.compatible_api_call (

631: THEN
632: fnd_msg_pub.initialize;
633: END IF;
634:
635: IF NOT fnd_api.compatible_api_call (
636: l_api_version,
637: p_api_version,
638: l_api_name,
639: g_pkg_name

Line 642: RAISE fnd_api.g_exc_unexpected_error;

638: l_api_name,
639: g_pkg_name
640: )
641: THEN
642: RAISE fnd_api.g_exc_unexpected_error;
643: END IF;
644:
645: SET_COUNTER_STATUS
646: (

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

656: p_task_confirmation_counter => jtf_task_utl.g_miss_number
657: );
658:
659:
660: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
661: THEN
662: RAISE fnd_api.g_exc_unexpected_error;
663: END IF;
664:

Line 662: RAISE fnd_api.g_exc_unexpected_error;

658:
659:
660: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
661: THEN
662: RAISE fnd_api.g_exc_unexpected_error;
663: END IF;
664:
665: IF fnd_api.to_boolean (p_commit)
666: THEN

Line 665: IF fnd_api.to_boolean (p_commit)

661: THEN
662: RAISE fnd_api.g_exc_unexpected_error;
663: END IF;
664:
665: IF fnd_api.to_boolean (p_commit)
666: THEN
667: COMMIT WORK;
668: END IF;
669:

Line 672: WHEN fnd_api.g_exc_unexpected_error

668: END IF;
669:
670: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
671: EXCEPTION
672: WHEN fnd_api.g_exc_unexpected_error
673: THEN
674: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
675: x_return_status := fnd_api.g_ret_sts_unexp_error;
676: fnd_msg_pub.count_and_get (

Line 675: x_return_status := fnd_api.g_ret_sts_unexp_error;

671: EXCEPTION
672: WHEN fnd_api.g_exc_unexpected_error
673: THEN
674: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
675: x_return_status := fnd_api.g_ret_sts_unexp_error;
676: fnd_msg_pub.count_and_get (
677: p_count => x_msg_count,
678: p_data => x_msg_data
679: );

Line 680: WHEN fnd_api.g_exc_error

676: fnd_msg_pub.count_and_get (
677: p_count => x_msg_count,
678: p_data => x_msg_data
679: );
680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
683: x_return_status := fnd_api.G_RET_STS_ERROR;
684: fnd_msg_pub.count_and_get (

Line 683: x_return_status := fnd_api.G_RET_STS_ERROR;

679: );
680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
683: x_return_status := fnd_api.G_RET_STS_ERROR;
684: fnd_msg_pub.count_and_get (
685: p_count => x_msg_count,
686: p_data => x_msg_data
687: );

Line 694: x_return_status := fnd_api.g_ret_sts_unexp_error;

690: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
691: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
692: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
693: fnd_msg_pub.add;
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: fnd_msg_pub.count_and_get (
696: p_count => x_msg_count,
697: p_data => x_msg_data
698: );

Line 704: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

700: END SET_CONFIRMATION_REQUIRED;
701:
702: PROCEDURE SET_CONFIRMATION_CONFIRMED (
703: p_api_version IN NUMBER,
704: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
705: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
706: x_return_status OUT NOCOPY VARCHAR2,
707: x_msg_count OUT NOCOPY NUMBER,
708: x_msg_data OUT NOCOPY VARCHAR2,

Line 705: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

701:
702: PROCEDURE SET_CONFIRMATION_CONFIRMED (
703: p_api_version IN NUMBER,
704: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
705: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
706: x_return_status OUT NOCOPY VARCHAR2,
707: x_msg_count OUT NOCOPY NUMBER,
708: x_msg_data OUT NOCOPY VARCHAR2,
709: p_object_version_number IN OUT NOCOPY NUMBER,

Line 723: x_return_status := fnd_api.g_ret_sts_success;

719:
720:
721: BEGIN
722: SAVEPOINT SET_CONFIRMATION_CONFIRMED;
723: x_return_status := fnd_api.g_ret_sts_success;
724:
725: IF fnd_api.to_boolean (p_init_msg_list)
726: THEN
727: fnd_msg_pub.initialize;

Line 725: IF fnd_api.to_boolean (p_init_msg_list)

721: BEGIN
722: SAVEPOINT SET_CONFIRMATION_CONFIRMED;
723: x_return_status := fnd_api.g_ret_sts_success;
724:
725: IF fnd_api.to_boolean (p_init_msg_list)
726: THEN
727: fnd_msg_pub.initialize;
728: END IF;
729:

Line 730: IF NOT fnd_api.compatible_api_call (

726: THEN
727: fnd_msg_pub.initialize;
728: END IF;
729:
730: IF NOT fnd_api.compatible_api_call (
731: l_api_version,
732: p_api_version,
733: l_api_name,
734: g_pkg_name

Line 737: RAISE fnd_api.g_exc_unexpected_error;

733: l_api_name,
734: g_pkg_name
735: )
736: THEN
737: RAISE fnd_api.g_exc_unexpected_error;
738: END IF;
739:
740: l_conf_counter := get_conf_counter (p_task_id);
741:

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

752: p_task_confirmation_status => 'C',
753: p_task_confirmation_counter => nvl(l_conf_counter,0)
754: );
755:
756: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
757: THEN
758: RAISE fnd_api.g_exc_unexpected_error;
759: END IF;
760:

Line 758: RAISE fnd_api.g_exc_unexpected_error;

754: );
755:
756: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
757: THEN
758: RAISE fnd_api.g_exc_unexpected_error;
759: END IF;
760:
761: IF fnd_api.to_boolean (p_commit)
762: THEN

Line 761: IF fnd_api.to_boolean (p_commit)

757: THEN
758: RAISE fnd_api.g_exc_unexpected_error;
759: END IF;
760:
761: IF fnd_api.to_boolean (p_commit)
762: THEN
763: COMMIT WORK;
764: END IF;
765:

Line 768: WHEN fnd_api.g_exc_unexpected_error

764: END IF;
765:
766: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
767: EXCEPTION
768: WHEN fnd_api.g_exc_unexpected_error
769: THEN
770: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772: fnd_msg_pub.count_and_get (

Line 771: x_return_status := fnd_api.g_ret_sts_unexp_error;

767: EXCEPTION
768: WHEN fnd_api.g_exc_unexpected_error
769: THEN
770: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772: fnd_msg_pub.count_and_get (
773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );

Line 776: WHEN fnd_api.g_exc_error

772: fnd_msg_pub.count_and_get (
773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );
776: WHEN fnd_api.g_exc_error
777: THEN
778: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
779: x_return_status := fnd_api.G_RET_STS_ERROR;
780: fnd_msg_pub.count_and_get (

Line 779: x_return_status := fnd_api.G_RET_STS_ERROR;

775: );
776: WHEN fnd_api.g_exc_error
777: THEN
778: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
779: x_return_status := fnd_api.G_RET_STS_ERROR;
780: fnd_msg_pub.count_and_get (
781: p_count => x_msg_count,
782: p_data => x_msg_data
783: );

Line 790: x_return_status := fnd_api.g_ret_sts_unexp_error;

786: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
787: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
788: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
789: fnd_msg_pub.add;
790: x_return_status := fnd_api.g_ret_sts_unexp_error;
791: fnd_msg_pub.count_and_get (
792: p_count => x_msg_count,
793: p_data => x_msg_data
794: );