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

Line 65: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

61: *=======================================================================*/
62:
63: PROCEDURE response_invitation(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
66: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
67: p_object_version_number IN OUT NOCOPY NUMBER,
68: p_response_invitation_rec IN response_invitation_rec,
69: x_return_status OUT NOCOPY VARCHAR2,

Line 66: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

62:
63: PROCEDURE response_invitation(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
66: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
67: p_object_version_number IN OUT NOCOPY NUMBER,
68: p_response_invitation_rec IN response_invitation_rec,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,

Line 92: x_return_status := fnd_api.g_ret_sts_success;

88: l_object_version_number NUMBER := p_object_version_number;
89: BEGIN
90: SAVEPOINT response_invitation_pvt;
91:
92: x_return_status := fnd_api.g_ret_sts_success;
93:
94: IF fnd_api.to_boolean (p_init_msg_list)
95: THEN
96: fnd_msg_pub.initialize;

Line 94: IF fnd_api.to_boolean (p_init_msg_list)

90: SAVEPOINT response_invitation_pvt;
91:
92: x_return_status := fnd_api.g_ret_sts_success;
93:
94: IF fnd_api.to_boolean (p_init_msg_list)
95: THEN
96: fnd_msg_pub.initialize;
97: END IF;
98:

Line 110: p_init_msg_list => fnd_api.g_true,

106:
107: jtf_task_assignments_pvt.update_task_assignment (
108: p_api_version => p_api_version,
109: p_object_version_number => l_object_version_number,
110: p_init_msg_list => fnd_api.g_true,
111: p_commit => fnd_api.g_false,
112: p_task_assignment_id => rec_assignments.task_assignment_id,
113: p_assignment_status_id => p_response_invitation_rec.assignment_status_id,
114: x_return_status => x_return_status,

Line 111: p_commit => fnd_api.g_false,

107: jtf_task_assignments_pvt.update_task_assignment (
108: p_api_version => p_api_version,
109: p_object_version_number => l_object_version_number,
110: p_init_msg_list => fnd_api.g_true,
111: p_commit => fnd_api.g_false,
112: p_task_assignment_id => rec_assignments.task_assignment_id,
113: p_assignment_status_id => p_response_invitation_rec.assignment_status_id,
114: x_return_status => x_return_status,
115: x_msg_count => x_msg_count,

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

117: p_enable_workflow => 'N',
118: p_abort_workflow => 'N'
119: );
120:
121: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
122: THEN
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124: RAISE fnd_api.g_exc_unexpected_error;
125: END IF;

Line 123: x_return_status := fnd_api.g_ret_sts_unexp_error;

119: );
120:
121: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
122: THEN
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124: RAISE fnd_api.g_exc_unexpected_error;
125: END IF;
126:
127: IF p_response_invitation_rec.task_id = rec_assignments.task_id

Line 124: RAISE fnd_api.g_exc_unexpected_error;

120:
121: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
122: THEN
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124: RAISE fnd_api.g_exc_unexpected_error;
125: END IF;
126:
127: IF p_response_invitation_rec.task_id = rec_assignments.task_id
128: THEN

Line 134: IF fnd_api.to_boolean (p_commit)

130: END IF;
131: END LOOP;
132: ----------------------------------------------------
133:
134: IF fnd_api.to_boolean (p_commit)
135: THEN
136: COMMIT WORK;
137: END IF;
138:

Line 141: WHEN fnd_api.g_exc_unexpected_error

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 response_invitation_pvt;
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 144: x_return_status := fnd_api.g_ret_sts_unexp_error;

140: EXCEPTION
141: WHEN fnd_api.g_exc_unexpected_error
142: THEN
143: ROLLBACK TO response_invitation_pvt;
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
146: WHEN OTHERS
147: THEN
148: ROLLBACK TO response_invitation_pvt;

Line 152: x_return_status := fnd_api.g_ret_sts_unexp_error;

148: ROLLBACK TO response_invitation_pvt;
149: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
150: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
151: fnd_msg_pub.add;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
154: END response_invitation;
155:
156: PROCEDURE add_assignee(

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

154: END response_invitation;
155:
156: PROCEDURE add_assignee(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
159: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
160: p_add_assignee_rec IN add_assignee_rec,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,

Line 159: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

155:
156: PROCEDURE add_assignee(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
159: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
160: p_add_assignee_rec IN add_assignee_rec,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,

Line 204: x_return_status := fnd_api.g_ret_sts_success;

200: l_date VARCHAR2(200);
201: BEGIN
202: SAVEPOINT add_assignee_pvt;
203:
204: x_return_status := fnd_api.g_ret_sts_success;
205:
206: IF fnd_api.to_boolean (p_init_msg_list)
207: THEN
208: fnd_msg_pub.initialize;

Line 206: IF fnd_api.to_boolean (p_init_msg_list)

202: SAVEPOINT add_assignee_pvt;
203:
204: x_return_status := fnd_api.g_ret_sts_success;
205:
206: IF fnd_api.to_boolean (p_init_msg_list)
207: THEN
208: fnd_msg_pub.initialize;
209: END IF;
210:

Line 255: x_return_status := fnd_api.g_ret_sts_unexp_error;

251: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
252: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_add_assignee_rec.recurrence_rule_id);
253: fnd_msg_pub.add;
254:
255: x_return_status := fnd_api.g_ret_sts_unexp_error;
256: RAISE fnd_api.g_exc_unexpected_error;
257: END IF;
258: CLOSE c_recur;
259:

Line 256: RAISE fnd_api.g_exc_unexpected_error;

252: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_add_assignee_rec.recurrence_rule_id);
253: fnd_msg_pub.add;
254:
255: x_return_status := fnd_api.g_ret_sts_unexp_error;
256: RAISE fnd_api.g_exc_unexpected_error;
257: END IF;
258: CLOSE c_recur;
259:
260: SELECT jtf_task_recur_rules_s.NEXTVAL

Line 388: p_init_msg_list => fnd_api.g_false,

384:
385: IF( l_availability ='T') THEN
386: jtf_task_assignments_pvt.create_task_assignment (
387: p_api_version => 1.0,
388: p_init_msg_list => fnd_api.g_false,
389: p_commit => fnd_api.g_false,
390: p_task_id => rec_tasks.task_id,
391: p_resource_type_code => p_add_assignee_rec.resource_type_code,
392: p_resource_id => p_add_assignee_rec.resource_id,

Line 389: p_commit => fnd_api.g_false,

385: IF( l_availability ='T') THEN
386: jtf_task_assignments_pvt.create_task_assignment (
387: p_api_version => 1.0,
388: p_init_msg_list => fnd_api.g_false,
389: p_commit => fnd_api.g_false,
390: p_task_id => rec_tasks.task_id,
391: p_resource_type_code => p_add_assignee_rec.resource_type_code,
392: p_resource_id => p_add_assignee_rec.resource_id,
393: p_free_busy_type => p_add_assignee_rec.free_busy_type,

Line 406: IF x_return_status <> fnd_api.g_ret_sts_success THEN

402: );
403:
404: l_availability := 'F';
405:
406: IF x_return_status <> fnd_api.g_ret_sts_success THEN
407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: RAISE fnd_api.g_exc_unexpected_error;
409: END IF;
410: else

Line 407: x_return_status := fnd_api.g_ret_sts_unexp_error;

403:
404: l_availability := 'F';
405:
406: IF x_return_status <> fnd_api.g_ret_sts_success THEN
407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: RAISE fnd_api.g_exc_unexpected_error;
409: END IF;
410: else
411: l_name := null;

Line 408: RAISE fnd_api.g_exc_unexpected_error;

404: l_availability := 'F';
405:
406: IF x_return_status <> fnd_api.g_ret_sts_success THEN
407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: RAISE fnd_api.g_exc_unexpected_error;
409: END IF;
410: else
411: l_name := null;
412: l_name := JTF_TASK_UTL.get_owner(p_add_assignee_rec.resource_type_code, p_add_assignee_rec.resource_id);

Line 427: x_return_status := fnd_api.g_ret_sts_unexp_error;

423: fnd_message.set_token ('RES', l_name );
424: fnd_message.set_token ('DATE', l_date);
425:
426: fnd_msg_pub.add;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: RAISE fnd_api.g_exc_unexpected_error;
430:
431:

Line 429: RAISE fnd_api.g_exc_unexpected_error;

425:
426: fnd_msg_pub.add;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: RAISE fnd_api.g_exc_unexpected_error;
430:
431:
432:
433: END IF;

Line 438: IF fnd_api.to_boolean (p_commit)

434:
435: END LOOP;
436: ----------------------------------------------------
437:
438: IF fnd_api.to_boolean (p_commit)
439: THEN
440: COMMIT WORK;
441: END IF;
442:

Line 445: WHEN fnd_api.g_exc_unexpected_error

441: END IF;
442:
443: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
444: EXCEPTION
445: WHEN fnd_api.g_exc_unexpected_error
446: THEN
447: ROLLBACK TO add_assignee_pvt;
448: x_return_status := fnd_api.g_ret_sts_unexp_error;
449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 448: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 456: x_return_status := fnd_api.g_ret_sts_unexp_error;

452: ROLLBACK TO add_assignee_pvt;
453: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
454: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
455: fnd_msg_pub.add;
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
458: END add_assignee;
459:
460: PROCEDURE delete_assignee(

Line 462: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

458: END add_assignee;
459:
460: PROCEDURE delete_assignee(
461: p_api_version IN NUMBER,
462: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
463: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
464: p_delete_assignee_rec IN delete_assignee_rec,
465: x_return_status OUT NOCOPY VARCHAR2,
466: x_msg_count OUT NOCOPY NUMBER,

Line 463: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

459:
460: PROCEDURE delete_assignee(
461: p_api_version IN NUMBER,
462: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
463: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
464: p_delete_assignee_rec IN delete_assignee_rec,
465: x_return_status OUT NOCOPY VARCHAR2,
466: x_msg_count OUT NOCOPY NUMBER,
467: x_msg_data OUT NOCOPY VARCHAR2

Line 508: x_return_status := fnd_api.g_ret_sts_success;

504: l_delete_option VARCHAR2(1) := p_delete_assignee_rec.delete_option;
505: BEGIN
506: SAVEPOINT delete_assignee_pvt;
507:
508: x_return_status := fnd_api.g_ret_sts_success;
509:
510: IF fnd_api.to_boolean (p_init_msg_list)
511: THEN
512: fnd_msg_pub.initialize;

Line 510: IF fnd_api.to_boolean (p_init_msg_list)

506: SAVEPOINT delete_assignee_pvt;
507:
508: x_return_status := fnd_api.g_ret_sts_success;
509:
510: IF fnd_api.to_boolean (p_init_msg_list)
511: THEN
512: fnd_msg_pub.initialize;
513: END IF;
514:

Line 562: x_return_status := fnd_api.g_ret_sts_unexp_error;

558: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
559: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_delete_assignee_rec.recurrence_rule_id);
560: fnd_msg_pub.add;
561:
562: x_return_status := fnd_api.g_ret_sts_unexp_error;
563: RAISE fnd_api.g_exc_unexpected_error;
564: END IF;
565: CLOSE c_recur;
566:

Line 563: RAISE fnd_api.g_exc_unexpected_error;

559: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_delete_assignee_rec.recurrence_rule_id);
560: fnd_msg_pub.add;
561:
562: x_return_status := fnd_api.g_ret_sts_unexp_error;
563: RAISE fnd_api.g_exc_unexpected_error;
564: END IF;
565: CLOSE c_recur;
566:
567: SELECT jtf_task_recur_rules_s.NEXTVAL

Line 673: p_init_msg_list => fnd_api.g_false,

669: -- Delete this invitee
670: ----------------------
671: jtf_task_assignments_pvt.delete_task_assignment (
672: p_api_version => 1.0,
673: p_init_msg_list => fnd_api.g_false,
674: p_commit => fnd_api.g_false,
675: p_task_assignment_id => rec_assignments.task_assignment_id,
676: p_object_version_number => rec_assignments.object_version_number,
677: p_delete_option => NULL,

Line 674: p_commit => fnd_api.g_false,

670: ----------------------
671: jtf_task_assignments_pvt.delete_task_assignment (
672: p_api_version => 1.0,
673: p_init_msg_list => fnd_api.g_false,
674: p_commit => fnd_api.g_false,
675: p_task_assignment_id => rec_assignments.task_assignment_id,
676: p_object_version_number => rec_assignments.object_version_number,
677: p_delete_option => NULL,
678: p_enable_workflow => 'N',

Line 684: IF x_return_status <> fnd_api.g_ret_sts_success THEN

680: x_return_status => x_return_status,
681: x_msg_count => x_msg_count,
682: x_msg_data => x_msg_data
683: );
684: IF x_return_status <> fnd_api.g_ret_sts_success THEN
685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688: END LOOP;

Line 685: x_return_status := fnd_api.g_ret_sts_unexp_error;

681: x_msg_count => x_msg_count,
682: x_msg_data => x_msg_data
683: );
684: IF x_return_status <> fnd_api.g_ret_sts_success THEN
685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688: END LOOP;
689: ----------------------------------------------------

Line 686: RAISE fnd_api.g_exc_unexpected_error;

682: x_msg_data => x_msg_data
683: );
684: IF x_return_status <> fnd_api.g_ret_sts_success THEN
685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688: END LOOP;
689: ----------------------------------------------------
690:

Line 691: IF fnd_api.to_boolean (p_commit)

687: END IF;
688: END LOOP;
689: ----------------------------------------------------
690:
691: IF fnd_api.to_boolean (p_commit)
692: THEN
693: COMMIT WORK;
694: END IF;
695:

Line 698: WHEN fnd_api.g_exc_unexpected_error

694: END IF;
695:
696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
697: EXCEPTION
698: WHEN fnd_api.g_exc_unexpected_error
699: THEN
700: ROLLBACK TO delete_assignee_pvt;
701: x_return_status := fnd_api.g_ret_sts_unexp_error;
702: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 701: x_return_status := fnd_api.g_ret_sts_unexp_error;

697: EXCEPTION
698: WHEN fnd_api.g_exc_unexpected_error
699: THEN
700: ROLLBACK TO delete_assignee_pvt;
701: x_return_status := fnd_api.g_ret_sts_unexp_error;
702: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
703: WHEN OTHERS
704: THEN
705: ROLLBACK TO delete_assignee_pvt;

Line 709: x_return_status := fnd_api.g_ret_sts_unexp_error;

705: ROLLBACK TO delete_assignee_pvt;
706: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
707: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
708: fnd_msg_pub.add;
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
711: END delete_assignee;
712:
713: END jtf_task_repeat_assignment_pvt;