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_MSG_PUB

Line 29: fnd_msg_pub.initialize;

25: x_return_status := fnd_api.g_ret_sts_success;
26:
27: IF fnd_api.to_boolean (p_init_msg_list)
28: THEN
29: fnd_msg_pub.initialize;
30: END IF;
31:
32: IF NOT fnd_api.compatible_api_call (
33: l_api_version,

Line 65: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

61: IF fnd_api.to_boolean(p_commit) THEN
62: COMMIT WORK;
63: END IF;
64:
65: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
66: EXCEPTION
67: WHEN fnd_api.g_exc_unexpected_error THEN
68: ROLLBACK TO SET_COUNTER_STATUS_1;
69: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 70: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

66: EXCEPTION
67: WHEN fnd_api.g_exc_unexpected_error THEN
68: ROLLBACK TO SET_COUNTER_STATUS_1;
69: x_return_status := fnd_api.g_ret_sts_unexp_error;
70: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
71: WHEN OTHERS THEN
72: ROLLBACK TO SET_COUNTER_STATUS_1;
73: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
74: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);

Line 75: fnd_msg_pub.ADD;

71: WHEN OTHERS THEN
72: ROLLBACK TO SET_COUNTER_STATUS_1;
73: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
74: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
75: fnd_msg_pub.ADD;
76: x_return_status := fnd_api.g_ret_sts_unexp_error;
77: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
78:
79: END SET_COUNTER_STATUS;

Line 77: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

73: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
74: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
75: fnd_msg_pub.ADD;
76: x_return_status := fnd_api.g_ret_sts_unexp_error;
77: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
78:
79: END SET_COUNTER_STATUS;
80:
81: PROCEDURE RESET_COUNTER (

Line 102: fnd_msg_pub.initialize;

98: x_return_status := fnd_api.g_ret_sts_success;
99:
100: IF fnd_api.to_boolean (p_init_msg_list)
101: THEN
102: fnd_msg_pub.initialize;
103: END IF;
104:
105: IF NOT fnd_api.compatible_api_call (
106: l_api_version,

Line 139: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

135: THEN
136: COMMIT WORK;
137: END IF;
138:
139: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
140: EXCEPTION
141: WHEN fnd_api.g_exc_unexpected_error
142: THEN
143: ROLLBACK TO RESET_COUNTER;

Line 145: fnd_msg_pub.count_and_get (

141: WHEN fnd_api.g_exc_unexpected_error
142: THEN
143: ROLLBACK TO RESET_COUNTER;
144: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
145: fnd_msg_pub.count_and_get (
146: p_count => x_msg_count,
147: p_data => x_msg_data
148: );
149: WHEN fnd_api.g_exc_error

Line 153: fnd_msg_pub.count_and_get (

149: WHEN fnd_api.g_exc_error
150: THEN
151: ROLLBACK TO RESET_COUNTER;
152: x_return_status := fnd_api.G_RET_STS_ERROR;
153: fnd_msg_pub.count_and_get (
154: p_count => x_msg_count,
155: p_data => x_msg_data
156: );
157: WHEN OTHERS

Line 162: fnd_msg_pub.add;

158: THEN
159: ROLLBACK TO RESET_COUNTER;
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 (
165: p_count => x_msg_count,
166: p_data => x_msg_data

Line 164: fnd_msg_pub.count_and_get (

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 (
165: p_count => x_msg_count,
166: p_data => x_msg_data
167: );
168:

Line 212: fnd_msg_pub.initialize;

208: x_return_status := fnd_api.g_ret_sts_success;
209:
210: IF fnd_api.to_boolean (p_init_msg_list)
211: THEN
212: fnd_msg_pub.initialize;
213: END IF;
214:
215: IF NOT fnd_api.compatible_api_call (
216: l_api_version,

Line 251: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

247: THEN
248: COMMIT WORK;
249: END IF;
250:
251: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
252: EXCEPTION
253: WHEN fnd_api.g_exc_unexpected_error
254: THEN
255: ROLLBACK TO INCREASE_COUNTER;

Line 257: fnd_msg_pub.count_and_get (

253: WHEN fnd_api.g_exc_unexpected_error
254: THEN
255: ROLLBACK TO INCREASE_COUNTER;
256: x_return_status := fnd_api.g_ret_sts_unexp_error;
257: fnd_msg_pub.count_and_get (
258: p_count => x_msg_count,
259: p_data => x_msg_data
260: );
261: WHEN fnd_api.g_exc_error

Line 265: fnd_msg_pub.count_and_get (

261: WHEN fnd_api.g_exc_error
262: THEN
263: ROLLBACK TO INCREASE_COUNTER;
264: x_return_status := fnd_api.G_RET_STS_ERROR;
265: fnd_msg_pub.count_and_get (
266: p_count => x_msg_count,
267: p_data => x_msg_data
268: );
269: WHEN OTHERS

Line 274: fnd_msg_pub.add;

270: THEN
271: ROLLBACK TO INCREASE_COUNTER;
272: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
273: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
274: fnd_msg_pub.add;
275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276: fnd_msg_pub.count_and_get (
277: p_count => x_msg_count,
278: p_data => x_msg_data

Line 276: fnd_msg_pub.count_and_get (

272: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
273: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
274: fnd_msg_pub.add;
275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276: fnd_msg_pub.count_and_get (
277: p_count => x_msg_count,
278: p_data => x_msg_data
279: );
280:

Line 307: fnd_msg_pub.initialize;

303: x_return_status := fnd_api.g_ret_sts_success;
304:
305: IF fnd_api.to_boolean (p_init_msg_list)
306: THEN
307: fnd_msg_pub.initialize;
308: END IF;
309:
310: IF NOT fnd_api.compatible_api_call (
311: l_api_version,

Line 346: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

342: THEN
343: COMMIT WORK;
344: END IF;
345:
346: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
347: EXCEPTION
348: WHEN fnd_api.g_exc_unexpected_error
349: THEN
350: ROLLBACK TO DECREASE_COUNTER;

Line 352: fnd_msg_pub.count_and_get (

348: WHEN fnd_api.g_exc_unexpected_error
349: THEN
350: ROLLBACK TO DECREASE_COUNTER;
351: x_return_status := fnd_api.g_ret_sts_unexp_error;
352: fnd_msg_pub.count_and_get (
353: p_count => x_msg_count,
354: p_data => x_msg_data
355: );
356: WHEN fnd_api.g_exc_error

Line 360: fnd_msg_pub.count_and_get (

356: WHEN fnd_api.g_exc_error
357: THEN
358: ROLLBACK TO DECREASE_COUNTER;
359: x_return_status := fnd_api.G_RET_STS_ERROR;
360: fnd_msg_pub.count_and_get (
361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364: WHEN OTHERS

Line 369: fnd_msg_pub.add;

365: THEN
366: ROLLBACK TO DECREASE_COUNTER;
367: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
368: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
369: fnd_msg_pub.add;
370: x_return_status := fnd_api.g_ret_sts_unexp_error;
371: fnd_msg_pub.count_and_get (
372: p_count => x_msg_count,
373: p_data => x_msg_data

Line 371: fnd_msg_pub.count_and_get (

367: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
368: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
369: fnd_msg_pub.add;
370: x_return_status := fnd_api.g_ret_sts_unexp_error;
371: fnd_msg_pub.count_and_get (
372: p_count => x_msg_count,
373: p_data => x_msg_data
374: );
375:

Line 402: fnd_msg_pub.initialize;

398: x_return_status := fnd_api.g_ret_sts_success;
399:
400: IF fnd_api.to_boolean (p_init_msg_list)
401: THEN
402: fnd_msg_pub.initialize;
403: END IF;
404:
405: IF NOT fnd_api.compatible_api_call (
406: l_api_version,

Line 441: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

437: THEN
438: COMMIT WORK;
439: END IF;
440:
441: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
442: EXCEPTION
443: WHEN fnd_api.g_exc_unexpected_error
444: THEN
445: ROLLBACK TO CHANGE_COUNTER_SIGN;

Line 447: fnd_msg_pub.count_and_get (

443: WHEN fnd_api.g_exc_unexpected_error
444: THEN
445: ROLLBACK TO CHANGE_COUNTER_SIGN;
446: x_return_status := fnd_api.g_ret_sts_unexp_error;
447: fnd_msg_pub.count_and_get (
448: p_count => x_msg_count,
449: p_data => x_msg_data
450: );
451: WHEN fnd_api.g_exc_error

Line 455: fnd_msg_pub.count_and_get (

451: WHEN fnd_api.g_exc_error
452: THEN
453: ROLLBACK TO CHANGE_COUNTER_SIGN;
454: x_return_status := fnd_api.G_RET_STS_ERROR;
455: fnd_msg_pub.count_and_get (
456: p_count => x_msg_count,
457: p_data => x_msg_data
458: );
459: WHEN OTHERS

Line 464: fnd_msg_pub.add;

460: THEN
461: ROLLBACK TO CHANGE_COUNTER_SIGN;
462: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
463: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
464: fnd_msg_pub.add;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get (
467: p_count => x_msg_count,
468: p_data => x_msg_data

Line 466: fnd_msg_pub.count_and_get (

462: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
463: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
464: fnd_msg_pub.add;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get (
467: p_count => x_msg_count,
468: p_data => x_msg_data
469: );
470:

Line 494: fnd_msg_pub.initialize;

490: x_return_status := fnd_api.g_ret_sts_success;
491:
492: IF fnd_api.to_boolean (p_init_msg_list)
493: THEN
494: fnd_msg_pub.initialize;
495: END IF;
496:
497: IF NOT fnd_api.compatible_api_call (
498: l_api_version,

Line 529: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

525: THEN
526: COMMIT WORK;
527: END IF;
528:
529: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
530: EXCEPTION
531: WHEN fnd_api.g_exc_unexpected_error
532: THEN
533: ROLLBACK TO RESET_CONFIRMATION_STATUS_1;

Line 535: fnd_msg_pub.count_and_get (

531: WHEN fnd_api.g_exc_unexpected_error
532: THEN
533: ROLLBACK TO RESET_CONFIRMATION_STATUS_1;
534: x_return_status := fnd_api.g_ret_sts_unexp_error;
535: fnd_msg_pub.count_and_get (
536: p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539: WHEN fnd_api.g_exc_error

Line 543: fnd_msg_pub.count_and_get (

539: WHEN fnd_api.g_exc_error
540: THEN
541: ROLLBACK TO RESET_CONFIRMATION_STATUS_1;
542: x_return_status := fnd_api.G_RET_STS_ERROR;
543: fnd_msg_pub.count_and_get (
544: p_count => x_msg_count,
545: p_data => x_msg_data
546: );
547: WHEN OTHERS

Line 552: fnd_msg_pub.add;

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

Line 554: fnd_msg_pub.count_and_get (

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

Line 583: fnd_msg_pub.initialize;

579: x_return_status := fnd_api.g_ret_sts_success;
580:
581: IF fnd_api.to_boolean (p_init_msg_list)
582: THEN
583: fnd_msg_pub.initialize;
584: END IF;
585:
586: IF NOT fnd_api.compatible_api_call (
587: l_api_version,

Line 619: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

615: THEN
616: COMMIT WORK;
617: END IF;
618:
619: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
620: EXCEPTION
621: WHEN fnd_api.g_exc_unexpected_error
622: THEN
623: ROLLBACK TO SET_CONFIRMATION_REQUIRED_1;

Line 625: fnd_msg_pub.count_and_get (

621: WHEN fnd_api.g_exc_unexpected_error
622: THEN
623: ROLLBACK TO SET_CONFIRMATION_REQUIRED_1;
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625: fnd_msg_pub.count_and_get (
626: p_count => x_msg_count,
627: p_data => x_msg_data
628: );
629: WHEN fnd_api.g_exc_error

Line 633: fnd_msg_pub.count_and_get (

629: WHEN fnd_api.g_exc_error
630: THEN
631: ROLLBACK TO SET_CONFIRMATION_REQUIRED_1;
632: x_return_status := fnd_api.G_RET_STS_ERROR;
633: fnd_msg_pub.count_and_get (
634: p_count => x_msg_count,
635: p_data => x_msg_data
636: );
637: WHEN OTHERS

Line 642: fnd_msg_pub.add;

638: THEN
639: ROLLBACK TO SET_CONFIRMATION_REQUIRED_1;
640: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
641: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
642: fnd_msg_pub.add;
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: fnd_msg_pub.count_and_get (
645: p_count => x_msg_count,
646: p_data => x_msg_data

Line 644: fnd_msg_pub.count_and_get (

640: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
641: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
642: fnd_msg_pub.add;
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: fnd_msg_pub.count_and_get (
645: p_count => x_msg_count,
646: p_data => x_msg_data
647: );
648:

Line 675: fnd_msg_pub.initialize;

671: x_return_status := fnd_api.g_ret_sts_success;
672:
673: IF fnd_api.to_boolean (p_init_msg_list)
674: THEN
675: fnd_msg_pub.initialize;
676: END IF;
677:
678: IF NOT fnd_api.compatible_api_call (
679: l_api_version,

Line 710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

706: THEN
707: COMMIT WORK;
708: END IF;
709:
710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
711: EXCEPTION
712: WHEN fnd_api.g_exc_unexpected_error
713: THEN
714: ROLLBACK TO SET_CONFIRMATION_CONFIRMED_1;

Line 716: fnd_msg_pub.count_and_get (

712: WHEN fnd_api.g_exc_unexpected_error
713: THEN
714: ROLLBACK TO SET_CONFIRMATION_CONFIRMED_1;
715: x_return_status := fnd_api.g_ret_sts_unexp_error;
716: fnd_msg_pub.count_and_get (
717: p_count => x_msg_count,
718: p_data => x_msg_data
719: );
720: WHEN fnd_api.g_exc_error

Line 724: fnd_msg_pub.count_and_get (

720: WHEN fnd_api.g_exc_error
721: THEN
722: ROLLBACK TO SET_CONFIRMATION_CONFIRMED_1;
723: x_return_status := fnd_api.G_RET_STS_ERROR;
724: fnd_msg_pub.count_and_get (
725: p_count => x_msg_count,
726: p_data => x_msg_data
727: );
728: WHEN OTHERS

Line 733: fnd_msg_pub.add;

729: THEN
730: ROLLBACK TO SET_CONFIRMATION_CONFIRMED_1;
731: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
732: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
733: fnd_msg_pub.add;
734: x_return_status := fnd_api.g_ret_sts_unexp_error;
735: fnd_msg_pub.count_and_get (
736: p_count => x_msg_count,
737: p_data => x_msg_data

Line 735: fnd_msg_pub.count_and_get (

731: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
732: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
733: fnd_msg_pub.add;
734: x_return_status := fnd_api.g_ret_sts_unexp_error;
735: fnd_msg_pub.count_and_get (
736: p_count => x_msg_count,
737: p_data => x_msg_data
738: );
739:

Line 777: fnd_msg_pub.ADD;

773: IF c_task%NOTFOUND THEN
774: CLOSE c_task;
775: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
776: fnd_message.set_token('P_TASK_ID', p_task_id);
777: fnd_msg_pub.ADD;
778: RAISE fnd_api.g_exc_unexpected_error;
779: END IF;
780: CLOSE c_task;
781:

Line 785: fnd_msg_pub.ADD;

781:
782: IF NOT p_task_confirmation_status IN('N', 'C', 'R', fnd_api.g_miss_char) THEN
783: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
784: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task confirmation status');
785: fnd_msg_pub.ADD;
786: RAISE fnd_api.g_exc_unexpected_error;
787: END IF;
788:
789:

Line 834: fnd_msg_pub.initialize;

830: x_return_status := fnd_api.g_ret_sts_success;
831:
832: IF fnd_api.to_boolean (p_init_msg_list)
833: THEN
834: fnd_msg_pub.initialize;
835: END IF;
836:
837: IF NOT fnd_api.compatible_api_call (
838: l_api_version,

Line 895: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

891: THEN
892: COMMIT WORK;
893: END IF;
894:
895: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
896: EXCEPTION
897: WHEN fnd_api.g_exc_unexpected_error
898: THEN
899: ROLLBACK TO SET_COUNTER_STATUS;

Line 901: fnd_msg_pub.count_and_get (

897: WHEN fnd_api.g_exc_unexpected_error
898: THEN
899: ROLLBACK TO SET_COUNTER_STATUS;
900: x_return_status := fnd_api.g_ret_sts_unexp_error;
901: fnd_msg_pub.count_and_get (
902: p_count => x_msg_count,
903: p_data => x_msg_data
904: );
905: WHEN fnd_api.g_exc_error

Line 909: fnd_msg_pub.count_and_get (

905: WHEN fnd_api.g_exc_error
906: THEN
907: ROLLBACK TO SET_COUNTER_STATUS;
908: x_return_status := fnd_api.G_RET_STS_ERROR;
909: fnd_msg_pub.count_and_get (
910: p_count => x_msg_count,
911: p_data => x_msg_data
912: );
913: WHEN OTHERS

Line 918: fnd_msg_pub.add;

914: THEN
915: ROLLBACK TO SET_COUNTER_STATUS;
916: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
917: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
918: fnd_msg_pub.add;
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: fnd_msg_pub.count_and_get (
921: p_count => x_msg_count,
922: p_data => x_msg_data

Line 920: fnd_msg_pub.count_and_get (

916: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
917: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
918: fnd_msg_pub.add;
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: fnd_msg_pub.count_and_get (
921: p_count => x_msg_count,
922: p_data => x_msg_data
923: );
924:

Line 951: fnd_msg_pub.initialize;

947: x_return_status := fnd_api.g_ret_sts_success;
948:
949: IF fnd_api.to_boolean (p_init_msg_list)
950: THEN
951: fnd_msg_pub.initialize;
952: END IF;
953:
954: IF NOT fnd_api.compatible_api_call (
955: l_api_version,

Line 989: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

985: THEN
986: COMMIT WORK;
987: END IF;
988:
989: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
990: EXCEPTION
991: WHEN fnd_api.g_exc_unexpected_error
992: THEN
993: ROLLBACK TO RESET_CONFIRMATION_STATUS;

Line 995: fnd_msg_pub.count_and_get (

991: WHEN fnd_api.g_exc_unexpected_error
992: THEN
993: ROLLBACK TO RESET_CONFIRMATION_STATUS;
994: x_return_status := fnd_api.g_ret_sts_unexp_error;
995: fnd_msg_pub.count_and_get (
996: p_count => x_msg_count,
997: p_data => x_msg_data
998: );
999: WHEN fnd_api.g_exc_error

Line 1003: fnd_msg_pub.count_and_get (

999: WHEN fnd_api.g_exc_error
1000: THEN
1001: ROLLBACK TO RESET_CONFIRMATION_STATUS;
1002: x_return_status := fnd_api.G_RET_STS_ERROR;
1003: fnd_msg_pub.count_and_get (
1004: p_count => x_msg_count,
1005: p_data => x_msg_data
1006: );
1007: WHEN OTHERS

Line 1012: fnd_msg_pub.add;

1008: THEN
1009: ROLLBACK TO RESET_CONFIRMATION_STATUS;
1010: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1011: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1012: fnd_msg_pub.add;
1013: x_return_status := fnd_api.g_ret_sts_unexp_error;
1014: fnd_msg_pub.count_and_get (
1015: p_count => x_msg_count,
1016: p_data => x_msg_data

Line 1014: fnd_msg_pub.count_and_get (

1010: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1011: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1012: fnd_msg_pub.add;
1013: x_return_status := fnd_api.g_ret_sts_unexp_error;
1014: fnd_msg_pub.count_and_get (
1015: p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );
1018:

Line 1044: fnd_msg_pub.initialize;

1040: x_return_status := fnd_api.g_ret_sts_success;
1041:
1042: IF fnd_api.to_boolean (p_init_msg_list)
1043: THEN
1044: fnd_msg_pub.initialize;
1045: END IF;
1046:
1047: IF NOT fnd_api.compatible_api_call (
1048: l_api_version,

Line 1083: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1079: THEN
1080: COMMIT WORK;
1081: END IF;
1082:
1083: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1084: EXCEPTION
1085: WHEN fnd_api.g_exc_unexpected_error
1086: THEN
1087: ROLLBACK TO SET_CONFIRMATION_REQUIRED;

Line 1089: fnd_msg_pub.count_and_get (

1085: WHEN fnd_api.g_exc_unexpected_error
1086: THEN
1087: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
1088: x_return_status := fnd_api.g_ret_sts_unexp_error;
1089: fnd_msg_pub.count_and_get (
1090: p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1093: WHEN fnd_api.g_exc_error

Line 1097: fnd_msg_pub.count_and_get (

1093: WHEN fnd_api.g_exc_error
1094: THEN
1095: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
1096: x_return_status := fnd_api.G_RET_STS_ERROR;
1097: fnd_msg_pub.count_and_get (
1098: p_count => x_msg_count,
1099: p_data => x_msg_data
1100: );
1101: WHEN OTHERS

Line 1106: fnd_msg_pub.add;

1102: THEN
1103: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
1104: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1105: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1106: fnd_msg_pub.add;
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: fnd_msg_pub.count_and_get (
1109: p_count => x_msg_count,
1110: p_data => x_msg_data

Line 1108: fnd_msg_pub.count_and_get (

1104: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1105: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1106: fnd_msg_pub.add;
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: fnd_msg_pub.count_and_get (
1109: p_count => x_msg_count,
1110: p_data => x_msg_data
1111: );
1112:

Line 1141: fnd_msg_pub.initialize;

1137: x_return_status := fnd_api.g_ret_sts_success;
1138:
1139: IF fnd_api.to_boolean (p_init_msg_list)
1140: THEN
1141: fnd_msg_pub.initialize;
1142: END IF;
1143:
1144: IF NOT fnd_api.compatible_api_call (
1145: l_api_version,

Line 1181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1177: THEN
1178: COMMIT WORK;
1179: END IF;
1180:
1181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1182: EXCEPTION
1183: WHEN fnd_api.g_exc_unexpected_error
1184: THEN
1185: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;

Line 1187: fnd_msg_pub.count_and_get (

1183: WHEN fnd_api.g_exc_unexpected_error
1184: THEN
1185: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
1186: x_return_status := fnd_api.g_ret_sts_unexp_error;
1187: fnd_msg_pub.count_and_get (
1188: p_count => x_msg_count,
1189: p_data => x_msg_data
1190: );
1191: WHEN fnd_api.g_exc_error

Line 1195: fnd_msg_pub.count_and_get (

1191: WHEN fnd_api.g_exc_error
1192: THEN
1193: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
1194: x_return_status := fnd_api.G_RET_STS_ERROR;
1195: fnd_msg_pub.count_and_get (
1196: p_count => x_msg_count,
1197: p_data => x_msg_data
1198: );
1199: WHEN OTHERS

Line 1204: fnd_msg_pub.add;

1200: THEN
1201: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
1202: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1203: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1204: fnd_msg_pub.add;
1205: x_return_status := fnd_api.g_ret_sts_unexp_error;
1206: fnd_msg_pub.count_and_get (
1207: p_count => x_msg_count,
1208: p_data => x_msg_data

Line 1206: fnd_msg_pub.count_and_get (

1202: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1203: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1204: fnd_msg_pub.add;
1205: x_return_status := fnd_api.g_ret_sts_unexp_error;
1206: fnd_msg_pub.count_and_get (
1207: p_count => x_msg_count,
1208: p_data => x_msg_data
1209: );
1210: