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.

[Home] [Help]

APPS.JTF_TASK_TEMPLATES_UTL dependencies on FND_API

Line 28: RAISE fnd_api.g_exc_unexpected_error;

24: THEN
25: CLOSE c_task_template_group_id;
26: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP_GRP');
27: fnd_msg_pub.add;
28: RAISE fnd_api.g_exc_unexpected_error;
29: END IF;
30: CLOSE c_task_template_group_id;
31: ELSE
32: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP_GRP');

Line 34: RAISE fnd_api.g_exc_unexpected_error;

30: CLOSE c_task_template_group_id;
31: ELSE
32: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP_GRP');
33: fnd_msg_pub.add;
34: RAISE fnd_api.g_exc_unexpected_error;
35: END IF;
36:
37: END; -- Procedure End
38:

Line 59: FND_API.G_MISS_CHAR, NULL,

55: task_number,
56: DECODE (
57: task_template_record.task_name,
58: NULL, task_name,
59: FND_API.G_MISS_CHAR, NULL,
60: task_template_record.task_name
61: ) task_name,
62: DECODE (
63: task_template_record.description,

Line 65: FND_API.G_MISS_CHAR, NULL,

61: ) task_name,
62: DECODE (
63: task_template_record.description,
64: NULL, description,
65: FND_API.G_MISS_CHAR, NULL,
66: task_template_record.description
67: ) description,
68: DECODE (
69: task_template_record.task_type_id,

Line 71: FND_API.G_MISS_CHAR, NULL,

67: ) description,
68: DECODE (
69: task_template_record.task_type_id,
70: NULL, task_type_id,
71: FND_API.G_MISS_CHAR, NULL,
72: task_template_record.task_type_id
73: ) task_type_id,
74: DECODE (
75: task_template_record.task_status_id,

Line 77: FND_API.G_MISS_CHAR, NULL,

73: ) task_type_id,
74: DECODE (
75: task_template_record.task_status_id,
76: NULL, task_status_id,
77: FND_API.G_MISS_CHAR, NULL,
78: task_template_record.task_status_id
79: ) task_status_id,
80: DECODE (
81: task_template_record.task_priority_id,

Line 83: FND_API.G_MISS_CHAR, NULL,

79: ) task_status_id,
80: DECODE (
81: task_template_record.task_priority_id,
82: NULL, task_priority_id,
83: FND_API.G_MISS_CHAR, NULL,
84: task_template_record.task_priority_id
85: ) task_priority_id,
86: DECODE (
87: task_template_record.duration,

Line 89: FND_API.G_MISS_CHAR, NULL,

85: ) task_priority_id,
86: DECODE (
87: task_template_record.duration,
88: NULL, duration,
89: FND_API.G_MISS_CHAR, NULL,
90: task_template_record.duration
91: ) duration,
92: DECODE (
93: task_template_record.duration_uom,

Line 95: FND_API.G_MISS_CHAR, NULL,

91: ) duration,
92: DECODE (
93: task_template_record.duration_uom,
94: NULL, duration_uom,
95: FND_API.G_MISS_CHAR, NULL,
96: task_template_record.duration_uom
97: ) duration_uom,
98: DECODE (
99: task_template_record.planned_effort,

Line 101: FND_API.G_MISS_CHAR, NULL,

97: ) duration_uom,
98: DECODE (
99: task_template_record.planned_effort,
100: NULL, planned_effort,
101: FND_API.G_MISS_CHAR, NULL,
102: task_template_record.planned_effort
103: ) planned_effort,
104: DECODE (
105: task_template_record.planned_effort_uom,

Line 107: FND_API.G_MISS_CHAR, NULL,

103: ) planned_effort,
104: DECODE (
105: task_template_record.planned_effort_uom,
106: NULL, planned_effort_uom,
107: FND_API.G_MISS_CHAR, NULL,
108: task_template_record.planned_effort_uom
109: ) planned_effort_uom,
110: DECODE (
111: task_template_record.private_flag,

Line 113: FND_API.G_MISS_CHAR, NULL,

109: ) planned_effort_uom,
110: DECODE (
111: task_template_record.private_flag,
112: NULL, private_flag,
113: FND_API.G_MISS_CHAR, NULL,
114: task_template_record.private_flag
115: ) private_flag,
116: publish_flag,
117: DECODE (

Line 120: FND_API.G_MISS_CHAR, NULL,

116: publish_flag,
117: DECODE (
118: task_template_record.restrict_closure_flag,
119: NULL, restrict_closure_flag,
120: FND_API.G_MISS_CHAR, NULL,
121: task_template_record.restrict_closure_flag
122: ) restrict_closure_flag,
123: multi_booked_flag,
124: milestone_flag,

Line 147: FND_API.G_MISS_CHAR, NULL,

143: task_template_record.timezone_id timezone_id,
144: DECODE (
145: task_template_record.attribute1,
146: NULL, attribute1,
147: FND_API.G_MISS_CHAR, NULL,
148: task_template_record.attribute1
149: ) attribute1,
150: DECODE (
151: task_template_record.attribute2,

Line 153: FND_API.G_MISS_CHAR, NULL,

149: ) attribute1,
150: DECODE (
151: task_template_record.attribute2,
152: NULL, attribute2,
153: FND_API.G_MISS_CHAR, NULL,
154: task_template_record.attribute2
155: ) attribute2,
156: DECODE (
157: task_template_record.attribute3,

Line 159: FND_API.G_MISS_CHAR, NULL,

155: ) attribute2,
156: DECODE (
157: task_template_record.attribute3,
158: NULL, attribute3,
159: FND_API.G_MISS_CHAR, NULL,
160: task_template_record.attribute3
161: ) attribute3,
162: DECODE (
163: task_template_record.attribute4,

Line 165: FND_API.G_MISS_CHAR, NULL,

161: ) attribute3,
162: DECODE (
163: task_template_record.attribute4,
164: NULL, attribute4,
165: FND_API.G_MISS_CHAR, NULL,
166: task_template_record.attribute4
167: ) attribute4,
168: DECODE (
169: task_template_record.attribute5,

Line 171: FND_API.G_MISS_CHAR, NULL,

167: ) attribute4,
168: DECODE (
169: task_template_record.attribute5,
170: NULL, attribute5,
171: FND_API.G_MISS_CHAR, NULL,
172: task_template_record.attribute5
173: ) attribute5,
174: DECODE (
175: task_template_record.attribute6,

Line 182: FND_API.G_MISS_CHAR, NULL,

178: ) attribute6,
179: DECODE (
180: task_template_record.attribute7,
181: NULL, attribute7,
182: FND_API.G_MISS_CHAR, NULL,
183: task_template_record.attribute7
184: ) attribute7,
185: DECODE (
186: task_template_record.attribute8,

Line 188: FND_API.G_MISS_CHAR, NULL,

184: ) attribute7,
185: DECODE (
186: task_template_record.attribute8,
187: NULL, attribute8,
188: FND_API.G_MISS_CHAR, NULL,
189: task_template_record.attribute8
190: ) attribute8,
191: DECODE (
192: task_template_record.attribute9,

Line 194: FND_API.G_MISS_CHAR, NULL,

190: ) attribute8,
191: DECODE (
192: task_template_record.attribute9,
193: NULL, attribute9,
194: FND_API.G_MISS_CHAR, NULL,
195: task_template_record.attribute9
196: ) attribute9,
197: DECODE (
198: task_template_record.attribute10,

Line 200: FND_API.G_MISS_CHAR, NULL,

196: ) attribute9,
197: DECODE (
198: task_template_record.attribute10,
199: NULL, attribute10,
200: FND_API.G_MISS_CHAR, NULL,
201: task_template_record.attribute10
202: ) attribute10,
203: DECODE (
204: task_template_record.attribute11,

Line 206: FND_API.G_MISS_CHAR, NULL,

202: ) attribute10,
203: DECODE (
204: task_template_record.attribute11,
205: NULL, attribute11,
206: FND_API.G_MISS_CHAR, NULL,
207: task_template_record.attribute11
208: ) attribute11,
209: DECODE (
210: task_template_record.attribute12,

Line 212: FND_API.G_MISS_CHAR, NULL,

208: ) attribute11,
209: DECODE (
210: task_template_record.attribute12,
211: NULL, attribute12,
212: FND_API.G_MISS_CHAR, NULL,
213: task_template_record.attribute12
214: ) attribute12,
215: DECODE (
216: task_template_record.attribute13,

Line 218: FND_API.G_MISS_CHAR, NULL,

214: ) attribute12,
215: DECODE (
216: task_template_record.attribute13,
217: NULL, attribute13,
218: FND_API.G_MISS_CHAR, NULL,
219: task_template_record.attribute13
220: ) attribute13,
221: DECODE (
222: task_template_record.attribute14,

Line 224: FND_API.G_MISS_CHAR, NULL,

220: ) attribute13,
221: DECODE (
222: task_template_record.attribute14,
223: NULL, attribute14,
224: FND_API.G_MISS_CHAR, NULL,
225: task_template_record.attribute14
226: ) attribute14,
227: DECODE (
228: task_template_record.attribute15,

Line 230: FND_API.G_MISS_CHAR, NULL,

226: ) attribute14,
227: DECODE (
228: task_template_record.attribute15,
229: NULL, attribute15,
230: FND_API.G_MISS_CHAR, NULL,
231: task_template_record.attribute15
232: ) attribute15,
233: DECODE (
234: task_template_record.attribute_category,

Line 236: FND_API.G_MISS_CHAR, NULL,

232: ) attribute15,
233: DECODE (
234: task_template_record.attribute_category,
235: NULL, attribute_category,
236: FND_API.G_MISS_CHAR, NULL,
237: task_template_record.attribute_category
238: ) attribute_category,
239: DECODE (
240: task_template_record.task_confirmation_status,

Line 259: x_return_status := fnd_api.g_ret_sts_success;

255:
256: l_object_version_number NUMBER;
257:
258: BEGIN
259: x_return_status := fnd_api.g_ret_sts_success;
260: OPEN c_task_template (p_task_template_group_info.task_template_group_id, p_task_template_info);
261: FETCH c_task_template INTO l_task_template_rec;
262:
263: IF c_task_template%NOTFOUND

Line 269: RAISE fnd_api.g_exc_unexpected_error;

265: CLOSE c_task_template;
266: fnd_message.set_name ('JTF', 'JTF_TASK_NO_TEMP_FOUND');
267: fnd_message.set_token ('task_template_id', p_task_template_info.task_template_id);
268: fnd_msg_pub.add;
269: RAISE fnd_api.g_exc_unexpected_error;
270: END IF;
271:
272: jtf_tasks_pub.create_task (
273: p_api_version => 1.0,

Line 274: p_init_msg_list => fnd_api.g_false,

270: END IF;
271:
272: jtf_tasks_pub.create_task (
273: p_api_version => 1.0,
274: p_init_msg_list => fnd_api.g_false,
275: p_commit => fnd_api.g_false,
276: p_task_name => l_task_template_rec.task_name,
277: p_task_type_id => l_task_template_rec.task_type_id,
278: p_description => l_task_template_rec.description,

Line 275: p_commit => fnd_api.g_false,

271:
272: jtf_tasks_pub.create_task (
273: p_api_version => 1.0,
274: p_init_msg_list => fnd_api.g_false,
275: p_commit => fnd_api.g_false,
276: p_task_name => l_task_template_rec.task_name,
277: p_task_type_id => l_task_template_rec.task_type_id,
278: p_description => l_task_template_rec.description,
279: p_task_status_id => l_task_template_rec.task_status_id,

Line 375: p_init_msg_list => fnd_api.g_false,

371: -- set_counter_status to set the confirmation_status. Changes done due to bug# 4352360
372: /* jtf_task_confirmation_pub.reset_confirmation_status
373: (
374: p_api_version => 1.0,
375: p_init_msg_list => fnd_api.g_false,
376: p_commit => fnd_api.g_false,
377: p_object_version_number => l_object_version_number,
378: p_task_id => x_task_id,
379: x_return_status => x_return_status,

Line 376: p_commit => fnd_api.g_false,

372: /* jtf_task_confirmation_pub.reset_confirmation_status
373: (
374: p_api_version => 1.0,
375: p_init_msg_list => fnd_api.g_false,
376: p_commit => fnd_api.g_false,
377: p_object_version_number => l_object_version_number,
378: p_task_id => x_task_id,
379: x_return_status => x_return_status,
380: x_msg_count => x_msg_count,

Line 386: p_init_msg_list => fnd_api.g_false,

382: ); */
383:
384: jtf_task_confirmation_pub.set_counter_status(
385: p_api_version => 1.0,
386: p_init_msg_list => fnd_api.g_false,
387: p_commit => fnd_api.g_false,
388: x_return_status => x_return_status,
389: x_msg_count => x_msg_count,
390: x_msg_data => x_msg_data,

Line 387: p_commit => fnd_api.g_false,

383:
384: jtf_task_confirmation_pub.set_counter_status(
385: p_api_version => 1.0,
386: p_init_msg_list => fnd_api.g_false,
387: p_commit => fnd_api.g_false,
388: x_return_status => x_return_status,
389: x_msg_count => x_msg_count,
390: x_msg_data => x_msg_data,
391: p_object_version_number => l_object_version_number,

Line 474: FND_API.G_MISS_CHAR, NULL,

470: p_task_template_group_info.show_on_calendar,
471: DECODE (
472: p_task_template_group_info.attribute1,
473: NULL, attribute1,
474: FND_API.G_MISS_CHAR, NULL,
475: p_task_template_group_info.attribute1
476: ) attribute1,
477: DECODE (
478: p_task_template_group_info.attribute2,

Line 480: FND_API.G_MISS_CHAR, NULL,

476: ) attribute1,
477: DECODE (
478: p_task_template_group_info.attribute2,
479: NULL, attribute2,
480: FND_API.G_MISS_CHAR, NULL,
481: p_task_template_group_info.attribute2
482: ) attribute2,
483: DECODE (
484: p_task_template_group_info.attribute3,

Line 486: FND_API.G_MISS_CHAR, NULL,

482: ) attribute2,
483: DECODE (
484: p_task_template_group_info.attribute3,
485: NULL, attribute3,
486: FND_API.G_MISS_CHAR, NULL,
487: p_task_template_group_info.attribute3
488: ) attribute3,
489: DECODE (
490: p_task_template_group_info.attribute4,

Line 492: FND_API.G_MISS_CHAR, NULL,

488: ) attribute3,
489: DECODE (
490: p_task_template_group_info.attribute4,
491: NULL, attribute4,
492: FND_API.G_MISS_CHAR, NULL,
493: p_task_template_group_info.attribute4
494: ) attribute4,
495: DECODE (
496: p_task_template_group_info.attribute5,

Line 498: FND_API.G_MISS_CHAR, NULL,

494: ) attribute4,
495: DECODE (
496: p_task_template_group_info.attribute5,
497: NULL, attribute5,
498: FND_API.G_MISS_CHAR, NULL,
499: p_task_template_group_info.attribute5
500: ) attribute5,
501: DECODE (
502: p_task_template_group_info.attribute6,

Line 509: FND_API.G_MISS_CHAR, NULL,

505: ) attribute6,
506: DECODE (
507: p_task_template_group_info.attribute7,
508: NULL, attribute7,
509: FND_API.G_MISS_CHAR, NULL,
510: p_task_template_group_info.attribute7
511: ) attribute7,
512: DECODE (
513: p_task_template_group_info.attribute8,

Line 515: FND_API.G_MISS_CHAR, NULL,

511: ) attribute7,
512: DECODE (
513: p_task_template_group_info.attribute8,
514: NULL, attribute8,
515: FND_API.G_MISS_CHAR, NULL,
516: p_task_template_group_info.attribute8
517: ) attribute8,
518: DECODE (
519: p_task_template_group_info.attribute9,

Line 521: FND_API.G_MISS_CHAR, NULL,

517: ) attribute8,
518: DECODE (
519: p_task_template_group_info.attribute9,
520: NULL, attribute9,
521: FND_API.G_MISS_CHAR, NULL,
522: p_task_template_group_info.attribute9
523: ) attribute9,
524: DECODE (
525: p_task_template_group_info.attribute10,

Line 527: FND_API.G_MISS_CHAR, NULL,

523: ) attribute9,
524: DECODE (
525: p_task_template_group_info.attribute10,
526: NULL, attribute10,
527: FND_API.G_MISS_CHAR, NULL,
528: p_task_template_group_info.attribute10
529: ) attribute10,
530: DECODE (
531: p_task_template_group_info.attribute11,

Line 533: FND_API.G_MISS_CHAR, NULL,

529: ) attribute10,
530: DECODE (
531: p_task_template_group_info.attribute11,
532: NULL, attribute11,
533: FND_API.G_MISS_CHAR, NULL,
534: p_task_template_group_info.attribute11
535: ) attribute11,
536: DECODE (
537: p_task_template_group_info.attribute12,

Line 539: FND_API.G_MISS_CHAR, NULL,

535: ) attribute11,
536: DECODE (
537: p_task_template_group_info.attribute12,
538: NULL, attribute12,
539: FND_API.G_MISS_CHAR, NULL,
540: p_task_template_group_info.attribute12
541: ) attribute12,
542: DECODE (
543: p_task_template_group_info.attribute13,

Line 545: FND_API.G_MISS_CHAR, NULL,

541: ) attribute12,
542: DECODE (
543: p_task_template_group_info.attribute13,
544: NULL, attribute13,
545: FND_API.G_MISS_CHAR, NULL,
546: p_task_template_group_info.attribute13
547: ) attribute13,
548: DECODE (
549: p_task_template_group_info.attribute14,

Line 551: FND_API.G_MISS_CHAR, NULL,

547: ) attribute13,
548: DECODE (
549: p_task_template_group_info.attribute14,
550: NULL, attribute14,
551: FND_API.G_MISS_CHAR, NULL,
552: p_task_template_group_info.attribute14
553: ) attribute14,
554: DECODE (
555: p_task_template_group_info.attribute15,

Line 557: FND_API.G_MISS_CHAR, NULL,

553: ) attribute14,
554: DECODE (
555: p_task_template_group_info.attribute15,
556: NULL, attribute15,
557: FND_API.G_MISS_CHAR, NULL,
558: p_task_template_group_info.attribute15
559: ) attribute15,
560: DECODE (
561: p_task_template_group_info.attribute_category,

Line 563: FND_API.G_MISS_CHAR, NULL,

559: ) attribute15,
560: DECODE (
561: p_task_template_group_info.attribute_category,
562: NULL, attribute_category,
563: FND_API.G_MISS_CHAR, NULL,
564: p_task_template_group_info.attribute_category
565: ) attribute_category,
566: decode (
567: task_confirmation_status,

Line 587: x_return_status := fnd_api.g_ret_sts_success;

583:
584: l_object_version_number NUMBER;
585: i NUMBER := 1 ;
586: BEGIN
587: x_return_status := fnd_api.g_ret_sts_success;
588: FOR task_template_rec IN c_task_template
589: LOOP
590: jtf_tasks_pub.create_task (
591: p_api_version => 1.0,

Line 592: p_init_msg_list => fnd_api.g_false,

588: FOR task_template_rec IN c_task_template
589: LOOP
590: jtf_tasks_pub.create_task (
591: p_api_version => 1.0,
592: p_init_msg_list => fnd_api.g_false,
593: p_commit => fnd_api.g_false,
594: p_task_name => task_template_rec.task_name,
595: p_task_type_id => task_template_rec.task_type_id,
596: p_description => task_template_rec.description,

Line 593: p_commit => fnd_api.g_false,

589: LOOP
590: jtf_tasks_pub.create_task (
591: p_api_version => 1.0,
592: p_init_msg_list => fnd_api.g_false,
593: p_commit => fnd_api.g_false,
594: p_task_name => task_template_rec.task_name,
595: p_task_type_id => task_template_rec.task_type_id,
596: p_description => task_template_rec.description,
597: p_task_status_id => task_template_rec.task_status_id,

Line 692: p_init_msg_list => fnd_api.g_false,

688: /******* End of modification by SBARAT on 06/01/2005 for bug# 4898434 *******/
689:
690: jtf_task_confirmation_pub.set_counter_status(
691: p_api_version => 1.0,
692: p_init_msg_list => fnd_api.g_false,
693: p_commit => fnd_api.g_false,
694: x_return_status => x_return_status,
695: x_msg_count => x_msg_count,
696: x_msg_data => x_msg_data,

Line 693: p_commit => fnd_api.g_false,

689:
690: jtf_task_confirmation_pub.set_counter_status(
691: p_api_version => 1.0,
692: p_init_msg_list => fnd_api.g_false,
693: p_commit => fnd_api.g_false,
694: x_return_status => x_return_status,
695: x_msg_count => x_msg_count,
696: x_msg_data => x_msg_data,
697: p_object_version_number => l_object_version_number,

Line 748: x_return_status := fnd_api.g_ret_sts_success;

744: WHERE task_id = p_task_template_id;
745:
746: l_task_resource_rec c_task_resource%ROWTYPE;
747: BEGIN
748: x_return_status := fnd_api.g_ret_sts_success;
749:
750: -- Bug 3342422 : there might be more than one resource in
751: -- template task needs to be created.
752: -- Comment out the following lines, add a for

Line 767: p_init_msg_list => fnd_api.g_false,

763: FOR l_task_resource_rec in c_task_resource(p_task_template_id)
764: LOOP
765: jtf_task_resources_pvt.create_task_rsrc_req (
766: p_api_version => 1.0,
767: p_init_msg_list => fnd_api.g_false,
768: p_commit => fnd_api.g_false,
769: p_task_id => p_task_id,
770: p_task_number => NULL,
771: p_task_type_id => l_task_resource_rec.task_type_id,

Line 768: p_commit => fnd_api.g_false,

764: LOOP
765: jtf_task_resources_pvt.create_task_rsrc_req (
766: p_api_version => 1.0,
767: p_init_msg_list => fnd_api.g_false,
768: p_commit => fnd_api.g_false,
769: p_task_id => p_task_id,
770: p_task_number => NULL,
771: p_task_type_id => l_task_resource_rec.task_type_id,
772: p_task_template_id => l_task_resource_rec.task_id,

Line 833: x_return_status := fnd_api.g_ret_sts_success;

829: l_task_recur_rec c_task_recurs%ROWTYPE;
830: l_task_rec jtf_task_recurrences_pub.task_details_rec;
831: l_recurrence_rule_id NUMBER;
832: BEGIN
833: x_return_status := fnd_api.g_ret_sts_success;
834: IF p_recurrence_rule_id IS NOT NULL
835: THEN
836: OPEN c_task_recurs (p_recurrence_rule_id);
837: FETCH c_task_recurs INTO l_task_recur_rec;

Line 844: RAISE fnd_api.g_exc_unexpected_error;

840: THEN
841: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
842: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_recurrence_rule_id);
843: fnd_msg_pub.add;
844: RAISE fnd_api.g_exc_unexpected_error;
845: END IF;
846:
847: jtf_task_recurrences_pub.create_task_recurrence (
848: p_api_version => 1.0,

Line 849: p_init_msg_list => fnd_api.g_false,

845: END IF;
846:
847: jtf_task_recurrences_pub.create_task_recurrence (
848: p_api_version => 1.0,
849: p_init_msg_list => fnd_api.g_false,
850: p_commit => fnd_api.g_false,
851: p_task_id => p_task_id,
852: p_occurs_which => l_task_recur_rec.occurs_which,
853: p_template_flag => jtf_task_utl.g_no,

Line 850: p_commit => fnd_api.g_false,

846:
847: jtf_task_recurrences_pub.create_task_recurrence (
848: p_api_version => 1.0,
849: p_init_msg_list => fnd_api.g_false,
850: p_commit => fnd_api.g_false,
851: p_task_id => p_task_id,
852: p_occurs_which => l_task_recur_rec.occurs_which,
853: p_template_flag => jtf_task_utl.g_no,
854: p_day_of_week => l_task_recur_rec.day_of_week,

Line 874: RAISE fnd_api.g_exc_unexpected_error;

870: ELSE
871: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
872: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_recurrence_rule_id);
873: fnd_msg_pub.add;
874: RAISE fnd_api.g_exc_unexpected_error;
875: END IF;
876: END;
877:
878: PROCEDURE create_task_phones (

Line 889: x_return_status := fnd_api.g_ret_sts_success;

885: )
886: IS
887: l_task_phone_id NUMBER;
888: BEGIN
889: x_return_status := fnd_api.g_ret_sts_success;
890:
891: FOR i IN 1 .. p_task_contact_points_tbl.COUNT
892: LOOP
893: IF ( p_task_contact_points_tbl (i).task_template_id = p_task_template_id

Line 894: AND x_return_status = fnd_api.g_ret_sts_success)

890:
891: FOR i IN 1 .. p_task_contact_points_tbl.COUNT
892: LOOP
893: IF ( p_task_contact_points_tbl (i).task_template_id = p_task_template_id
894: AND x_return_status = fnd_api.g_ret_sts_success)
895: THEN
896: jtf_task_phones_pub.create_task_phones (
897: p_api_version => 1.0,
898: p_init_msg_list => fnd_api.g_false,

Line 898: p_init_msg_list => fnd_api.g_false,

894: AND x_return_status = fnd_api.g_ret_sts_success)
895: THEN
896: jtf_task_phones_pub.create_task_phones (
897: p_api_version => 1.0,
898: p_init_msg_list => fnd_api.g_false,
899: p_commit => fnd_api.g_false,
900: p_task_contact_id => p_task_contact_id,
901: p_phone_id => p_task_contact_points_tbl (i).phone_id,
902: p_primary_flag => p_task_contact_points_tbl (i).primary_key,

Line 899: p_commit => fnd_api.g_false,

895: THEN
896: jtf_task_phones_pub.create_task_phones (
897: p_api_version => 1.0,
898: p_init_msg_list => fnd_api.g_false,
899: p_commit => fnd_api.g_false,
900: p_task_contact_id => p_task_contact_id,
901: p_phone_id => p_task_contact_points_tbl (i).phone_id,
902: p_primary_flag => p_task_contact_points_tbl (i).primary_key,
903: p_owner_table_name => 'JTF_TASKS_B',