217:
218: IF l_role_name IS NOT NULL THEN
219: include_role(p_role_name => l_role_name);
220: ELSE
221: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
222: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
223: fnd_msg_pub.ADD;
224: END IF;
225: ELSIF p_resource_type_code IN('RS_GROUP', 'RS_TEAM') THEN
218: IF l_role_name IS NOT NULL THEN
219: include_role(p_role_name => l_role_name);
220: ELSE
221: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
222: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
223: fnd_msg_pub.ADD;
224: END IF;
225: ELSIF p_resource_type_code IN('RS_GROUP', 'RS_TEAM') THEN
226: -- group or team resource
234:
235: IF l_role_name IS NOT NULL THEN
236: include_role(p_role_name => l_role_name);
237: ELSE
238: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
239: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
240: fnd_msg_pub.ADD;
241: END IF;
242: ELSIF l_group_rec.resource_type_code IN('RS_SUPPLIER_CONTACT', 'RS_PARTNER', 'RS_PARTY', 'PARTY_PERSON') THEN
235: IF l_role_name IS NOT NULL THEN
236: include_role(p_role_name => l_role_name);
237: ELSE
238: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
239: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
240: fnd_msg_pub.ADD;
241: END IF;
242: ELSIF l_group_rec.resource_type_code IN('RS_SUPPLIER_CONTACT', 'RS_PARTNER', 'RS_PARTY', 'PARTY_PERSON') THEN
243: get_party_details(
248:
249: IF l_role_name IS NOT NULL THEN
250: include_role(p_role_name => l_role_name);
251: ELSE
252: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
253: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
254: fnd_msg_pub.ADD;
255: END IF;
256: ELSE
249: IF l_role_name IS NOT NULL THEN
250: include_role(p_role_name => l_role_name);
251: ELSE
252: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
253: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
254: fnd_msg_pub.ADD;
255: END IF;
256: ELSE
257: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
253: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
254: fnd_msg_pub.ADD;
255: END IF;
256: ELSE
257: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
258: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
259: fnd_msg_pub.ADD;
260: END IF;
261: END LOOP;
254: fnd_msg_pub.ADD;
255: END IF;
256: ELSE
257: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
258: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
259: fnd_msg_pub.ADD;
260: END IF;
261: END LOOP;
262: ELSIF p_resource_type_code = 'RS_TEAM' THEN
267:
268: IF l_role_name IS NOT NULL THEN
269: include_role(p_role_name => l_role_name);
270: ELSE
271: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
272: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
273: fnd_msg_pub.ADD;
274: END IF;
275: ELSIF l_team_rec.resource_type_code IN('RS_SUPPLIER_CONTACT', 'RS_PARTNER', 'RS_PARTY', 'PARTY_PERSON') THEN
268: IF l_role_name IS NOT NULL THEN
269: include_role(p_role_name => l_role_name);
270: ELSE
271: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
272: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
273: fnd_msg_pub.ADD;
274: END IF;
275: ELSIF l_team_rec.resource_type_code IN('RS_SUPPLIER_CONTACT', 'RS_PARTNER', 'RS_PARTY', 'PARTY_PERSON') THEN
276: get_party_details(
281:
282: IF l_role_name IS NOT NULL THEN
283: include_role(p_role_name => l_role_name);
284: ELSE
285: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
286: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
287: fnd_msg_pub.ADD;
288: END IF;
289: ELSE
282: IF l_role_name IS NOT NULL THEN
283: include_role(p_role_name => l_role_name);
284: ELSE
285: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
286: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
287: fnd_msg_pub.ADD;
288: END IF;
289: ELSE
290: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
286: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
287: fnd_msg_pub.ADD;
288: END IF;
289: ELSE
290: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
291: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
292: fnd_msg_pub.ADD;
293: END IF;
294: END LOOP;
287: fnd_msg_pub.ADD;
288: END IF;
289: ELSE
290: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
291: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
292: fnd_msg_pub.ADD;
293: END IF;
294: END LOOP;
295: ELSE
292: fnd_msg_pub.ADD;
293: END IF;
294: END LOOP;
295: ELSE
296: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
297: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
298: fnd_msg_pub.ADD;
299: END IF;
300: ELSE
293: END IF;
294: END LOOP;
295: ELSE
296: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
297: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
298: fnd_msg_pub.ADD;
299: END IF;
300: ELSE
301: IF p_resource_type_code = 'RS_GROUP' THEN
305:
306: IF l_role_name IS NOT NULL Then
307: include_role(p_role_name => l_role_name);
308: ELSE
309: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
310: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
311: fnd_msg_pub.add;
312: END IF;
313: ELSIF p_resource_type_code = 'RS_TEAM' THEN
306: IF l_role_name IS NOT NULL Then
307: include_role(p_role_name => l_role_name);
308: ELSE
309: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
310: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
311: fnd_msg_pub.add;
312: END IF;
313: ELSIF p_resource_type_code = 'RS_TEAM' THEN
314: OPEN c_group_team_role('JRES_TEAM', p_resource_id);
317:
318: IF l_role_name IS NOT NULL THEN
319: include_role(p_role_name => l_role_name);
320: ELSE
321: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
322: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id) );
323: fnd_msg_pub.add;
324: END IF;
325: END IF;
318: IF l_role_name IS NOT NULL THEN
319: include_role(p_role_name => l_role_name);
320: ELSE
321: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
322: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id) );
323: fnd_msg_pub.add;
324: END IF;
325: END IF;
326: END IF;
333:
334: IF l_role_name IS NOT NULL THEN
335: include_role(p_role_name => l_role_name);
336: ELSE
337: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
338: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
339: fnd_msg_pub.ADD;
340: END IF;
341: ELSE
334: IF l_role_name IS NOT NULL THEN
335: include_role(p_role_name => l_role_name);
336: ELSE
337: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
338: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
339: fnd_msg_pub.ADD;
340: END IF;
341: ELSE
342: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
338: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
339: fnd_msg_pub.ADD;
340: END IF;
341: ELSE
342: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
343: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
344: fnd_msg_pub.ADD;
345: END IF;
346: END find_role;
339: fnd_msg_pub.ADD;
340: END IF;
341: ELSE
342: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
343: fnd_message.set_token('P_RESOURCE_NAME', get_resource_name(p_resource_type_code, p_resource_id));
344: fnd_msg_pub.ADD;
345: END IF;
346: END find_role;
347:
636: jtf_task_wf_util.g_new_assignee_id := p_new_assignee_id;
637: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
638:
639: -- Get the Translated Text for 'Not Entered' from message dictionary
640: fnd_message.set_name('JTF', 'JTF_TASK_DATA_NOT_ENTERED');
641: l_not_entered := fnd_message.get;
642:
643: l_type_change_text := l_task_rec.task_type_name;
644: l_status_change_text := l_task_rec.task_status_name;
637: jtf_task_wf_util.g_new_assignee_code := p_new_assignee_code;
638:
639: -- Get the Translated Text for 'Not Entered' from message dictionary
640: fnd_message.set_name('JTF', 'JTF_TASK_DATA_NOT_ENTERED');
641: l_not_entered := fnd_message.get;
642:
643: l_type_change_text := l_task_rec.task_type_name;
644: l_status_change_text := l_task_rec.task_status_name;
645: