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

Line 15: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

11:
12:
13: PROCEDURE create_group_membership
14: (P_API_VERSION IN NUMBER,
15: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
16: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_RESOURCE_ID IN NUMBER,
18: P_GROUP_ID IN NUMBER,
19: P_ROLE_ID IN NUMBER,

Line 16: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

12:
13: PROCEDURE create_group_membership
14: (P_API_VERSION IN NUMBER,
15: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
16: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_RESOURCE_ID IN NUMBER,
18: P_GROUP_ID IN NUMBER,
19: P_ROLE_ID IN NUMBER,
20: P_START_DATE IN DATE,

Line 29: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;

25: ) IS
26:
27: l_api_version constant number := 1.0;
28: l_api_name constant varchar2(30) := 'CREATE_GROUP_MEMBERSHIP';
29: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;
30: l_msg_count number;
31: l_msg_data varchar2(2000);
32:
33: /* Out Parameters for Create Role Relation*/

Line 101: x_return_status := fnd_api.g_ret_sts_success;

97: l_new_role_start_date date;
98: l_new_role_end_date date;
99:
100: BEGIN
101: x_return_status := fnd_api.g_ret_sts_success;
102:
103: savepoint cr_grp_memship;
104:
105: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE

Line 106: if fnd_api.tO_BOOLEAN(p_init_msg_list)

102:
103: savepoint cr_grp_memship;
104:
105: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
106: if fnd_api.tO_BOOLEAN(p_init_msg_list)
107: then
108: fnd_msg_pub.Initialize;
109: end if;
110:

Line 165: ,p_init_msg_list => fnd_api.g_false

161: end if;
162:
163: jtf_rs_role_relate_pub.create_resource_role_relate
164: (p_api_version => 1.0
165: ,p_init_msg_list => fnd_api.g_false
166: ,p_commit => fnd_api.g_false
167: ,p_role_resource_type => 'RS_INDIVIDUAL'
168: ,p_role_resource_id => p_resource_id
169: ,p_role_id => p_role_id

Line 166: ,p_commit => fnd_api.g_false

162:
163: jtf_rs_role_relate_pub.create_resource_role_relate
164: (p_api_version => 1.0
165: ,p_init_msg_list => fnd_api.g_false
166: ,p_commit => fnd_api.g_false
167: ,p_role_resource_type => 'RS_INDIVIDUAL'
168: ,p_role_resource_id => p_resource_id
169: ,p_role_id => p_role_id
170: ,p_role_code => null

Line 178: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

174: ,x_msg_count => l_msg_count
175: ,x_msg_data => l_msg_data
176: ,x_role_relate_id => l_role_relate_id
177: );
178: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
179: raise fnd_api.g_exc_unexpected_error;
180: end if;
181:
182: else

Line 179: raise fnd_api.g_exc_unexpected_error;

175: ,x_msg_data => l_msg_data
176: ,x_role_relate_id => l_role_relate_id
177: );
178: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
179: raise fnd_api.g_exc_unexpected_error;
180: end if;
181:
182: else
183:

Line 209: P_INIT_MSG_LIST => fnd_api.g_false,

205: end if;
206:
207: jtf_rs_role_relate_pvt.update_resource_role_relate
208: (P_API_VERSION => 1.0,
209: P_INIT_MSG_LIST => fnd_api.g_false,
210: P_COMMIT => fnd_api.g_false,
211: P_ROLE_RELATE_ID => l_role_relate_id,
212: P_START_DATE_ACTIVE => l_new_role_start_date,
213: P_END_DATE_ACTIVE => l_new_role_end_date,

Line 210: P_COMMIT => fnd_api.g_false,

206:
207: jtf_rs_role_relate_pvt.update_resource_role_relate
208: (P_API_VERSION => 1.0,
209: P_INIT_MSG_LIST => fnd_api.g_false,
210: P_COMMIT => fnd_api.g_false,
211: P_ROLE_RELATE_ID => l_role_relate_id,
212: P_START_DATE_ACTIVE => l_new_role_start_date,
213: P_END_DATE_ACTIVE => l_new_role_end_date,
214: P_OBJECT_VERSION_NUM => l_object_version_number,

Line 218: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

214: P_OBJECT_VERSION_NUM => l_object_version_number,
215: X_RETURN_STATUS => l_return_status,
216: X_MSG_COUNT => l_msg_count,
217: X_MSG_DATA => l_msg_data);
218: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
219: raise fnd_api.g_exc_unexpected_error;
220: end if;
221: else
222: -- dbms_output.put_line('no need to update the role');

Line 219: raise fnd_api.g_exc_unexpected_error;

215: X_RETURN_STATUS => l_return_status,
216: X_MSG_COUNT => l_msg_count,
217: X_MSG_DATA => l_msg_data);
218: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
219: raise fnd_api.g_exc_unexpected_error;
220: end if;
221: else
222: -- dbms_output.put_line('no need to update the role');
223: null;

Line 248: P_INIT_MSG_LIST => fnd_api.g_false,

244: end if;
245:
246: jtf_rs_role_relate_pvt.update_resource_role_relate
247: (P_API_VERSION => 1.0,
248: P_INIT_MSG_LIST => fnd_api.g_false,
249: P_COMMIT => fnd_api.g_false,
250: P_ROLE_RELATE_ID => l_role_relate_id,
251: P_START_DATE_ACTIVE => l_new_role_start_date,
252: P_END_DATE_ACTIVE => l_new_role_end_date,

Line 249: P_COMMIT => fnd_api.g_false,

245:
246: jtf_rs_role_relate_pvt.update_resource_role_relate
247: (P_API_VERSION => 1.0,
248: P_INIT_MSG_LIST => fnd_api.g_false,
249: P_COMMIT => fnd_api.g_false,
250: P_ROLE_RELATE_ID => l_role_relate_id,
251: P_START_DATE_ACTIVE => l_new_role_start_date,
252: P_END_DATE_ACTIVE => l_new_role_end_date,
253: P_OBJECT_VERSION_NUM => l_object_version_number,

Line 257: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

253: P_OBJECT_VERSION_NUM => l_object_version_number,
254: X_RETURN_STATUS => l_return_status,
255: X_MSG_COUNT => l_msg_count,
256: X_MSG_DATA => l_msg_data);
257: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
258: raise fnd_api.g_exc_unexpected_error;
259: end if;
260: elsif (p_start_date < l_start_date_active)
261: then

Line 258: raise fnd_api.g_exc_unexpected_error;

254: X_RETURN_STATUS => l_return_status,
255: X_MSG_COUNT => l_msg_count,
256: X_MSG_DATA => l_msg_data);
257: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
258: raise fnd_api.g_exc_unexpected_error;
259: end if;
260: elsif (p_start_date < l_start_date_active)
261: then
262: fetch chk_role_relate into l_role_relate_id_old,l_start_date_active,l_end_date_active,l_object_version_number_old;

Line 298: P_INIT_MSG_LIST => fnd_api.g_false,

294: end if;
295:
296: jtf_rs_role_relate_pvt.update_resource_role_relate
297: (P_API_VERSION => 1.0,
298: P_INIT_MSG_LIST => fnd_api.g_false,
299: P_COMMIT => fnd_api.g_false,
300: P_ROLE_RELATE_ID => l_role_relate_id,
301: P_START_DATE_ACTIVE => l_new_role_start_date,
302: P_END_DATE_ACTIVE => l_new_role_end_date,

Line 299: P_COMMIT => fnd_api.g_false,

295:
296: jtf_rs_role_relate_pvt.update_resource_role_relate
297: (P_API_VERSION => 1.0,
298: P_INIT_MSG_LIST => fnd_api.g_false,
299: P_COMMIT => fnd_api.g_false,
300: P_ROLE_RELATE_ID => l_role_relate_id,
301: P_START_DATE_ACTIVE => l_new_role_start_date,
302: P_END_DATE_ACTIVE => l_new_role_end_date,
303: P_OBJECT_VERSION_NUM => l_object_version_number,

Line 307: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

303: P_OBJECT_VERSION_NUM => l_object_version_number,
304: X_RETURN_STATUS => l_return_status,
305: X_MSG_COUNT => l_msg_count,
306: X_MSG_DATA => l_msg_data);
307: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
308: raise fnd_api.g_exc_unexpected_error;
309: end if;
310:
311: end if;

Line 308: raise fnd_api.g_exc_unexpected_error;

304: X_RETURN_STATUS => l_return_status,
305: X_MSG_COUNT => l_msg_count,
306: X_MSG_DATA => l_msg_data);
307: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
308: raise fnd_api.g_exc_unexpected_error;
309: end if;
310:
311: end if;
312:

Line 327: ,p_init_msg_list => fnd_api.g_false

323: then
324:
325: jtf_rs_group_members_pub.create_resource_group_members
326: (p_api_version => 1.0
327: ,p_init_msg_list => fnd_api.g_false
328: ,p_commit => fnd_api.g_false
329: ,p_group_id => p_group_id
330: ,p_group_number => null
331: ,p_resource_id => p_resource_id

Line 328: ,p_commit => fnd_api.g_false

324:
325: jtf_rs_group_members_pub.create_resource_group_members
326: (p_api_version => 1.0
327: ,p_init_msg_list => fnd_api.g_false
328: ,p_commit => fnd_api.g_false
329: ,p_group_id => p_group_id
330: ,p_group_number => null
331: ,p_resource_id => p_resource_id
332: ,p_resource_number => null

Line 339: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

335: ,x_msg_data => l_msg_data
336: ,x_group_member_id => l_group_member_id
337: );
338:
339: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
340: raise fnd_api.g_exc_unexpected_error;
341: end if;
342: else
343: if (p_role_id is null) then

Line 340: raise fnd_api.g_exc_unexpected_error;

336: ,x_group_member_id => l_group_member_id
337: );
338:
339: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
340: raise fnd_api.g_exc_unexpected_error;
341: end if;
342: else
343: if (p_role_id is null) then
344: open get_group_name(p_group_id);

Line 355: RAISE fnd_api.g_exc_unexpected_error;

351: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS_GROUP');
352: fnd_message.set_token('P_RESOURCE',l_resource_name);
353: fnd_message.set_token('P_GROUP',l_group_name);
354: fnd_msg_pub.add;
355: RAISE fnd_api.g_exc_unexpected_error;
356:
357: end if;
358: end if;
359: --dbms_output.put_line('group_member_id id = ' || to_char(l_group_member_id));

Line 365: ,p_init_msg_list => fnd_api.g_false

361: /* Calling the role relate api's to create resource role relation */
362: if (p_role_id is not null) then
363: jtf_rs_role_relate_pub.create_resource_role_relate
364: (p_api_version => 1.0
365: ,p_init_msg_list => fnd_api.g_false
366: ,p_commit => fnd_api.g_false
367: ,p_role_resource_type => 'RS_GROUP_MEMBER'
368: ,p_role_resource_id => l_group_member_id
369: ,p_role_id => p_role_id

Line 366: ,p_commit => fnd_api.g_false

362: if (p_role_id is not null) then
363: jtf_rs_role_relate_pub.create_resource_role_relate
364: (p_api_version => 1.0
365: ,p_init_msg_list => fnd_api.g_false
366: ,p_commit => fnd_api.g_false
367: ,p_role_resource_type => 'RS_GROUP_MEMBER'
368: ,p_role_resource_id => l_group_member_id
369: ,p_role_id => p_role_id
370: ,p_role_code => null

Line 379: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

375: ,x_msg_data => l_msg_data
376: ,x_role_relate_id => l_role_relate_id
377: );
378:
379: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
380: raise fnd_api.g_exc_unexpected_error;
381: end if;
382: end if;
383:

Line 380: raise fnd_api.g_exc_unexpected_error;

376: ,x_role_relate_id => l_role_relate_id
377: );
378:
379: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
380: raise fnd_api.g_exc_unexpected_error;
381: end if;
382: end if;
383:
384: --dbms_output.put_line(' group role_relate id = ' || to_char(l_role_relate_id));

Line 386: if fnd_api.to_boolean(p_commit)

382: end if;
383:
384: --dbms_output.put_line(' group role_relate id = ' || to_char(l_role_relate_id));
385:
386: if fnd_api.to_boolean(p_commit)
387: then
388: commit work;
389: end if;
390:

Line 394: when fnd_api.g_exc_unexpected_error

390:
391: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
392:
393: exception
394: when fnd_api.g_exc_unexpected_error
395: then
396: rollback to cr_grp_memship;
397: x_return_status := fnd_api.g_ret_sts_error;
398: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 397: x_return_status := fnd_api.g_ret_sts_error;

393: exception
394: when fnd_api.g_exc_unexpected_error
395: then
396: rollback to cr_grp_memship;
397: x_return_status := fnd_api.g_ret_sts_error;
398: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
399: WHEN fnd_api.g_exc_error
400: THEN
401: ROLLBACK TO cr_grp_memship;

Line 399: WHEN fnd_api.g_exc_error

395: then
396: rollback to cr_grp_memship;
397: x_return_status := fnd_api.g_ret_sts_error;
398: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
399: WHEN fnd_api.g_exc_error
400: THEN
401: ROLLBACK TO cr_grp_memship;
402: x_return_status := fnd_api.g_ret_sts_error;
403: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 402: x_return_status := fnd_api.g_ret_sts_error;

398: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
399: WHEN fnd_api.g_exc_error
400: THEN
401: ROLLBACK TO cr_grp_memship;
402: x_return_status := fnd_api.g_ret_sts_error;
403: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
404: when others
405: then
406: rollback to cr_grp_memship;

Line 412: x_return_status := fnd_api.g_ret_sts_unexp_error;

408: fnd_message.set_token('P_SQLCODE',SQLCODE);
409: fnd_message.set_token('P_SQLERRM',SQLERRM);
410: fnd_message.set_token('P_API_NAME',l_api_name);
411: FND_MSG_PUB.add;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
414:
415: END create_group_membership;
416:

Line 419: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

415: END create_group_membership;
416:
417: PROCEDURE update_group_membership
418: (P_API_VERSION IN NUMBER,
419: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
420: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
421: P_RESOURCE_ID IN NUMBER,
422: P_ROLE_ID IN NUMBER,
423: P_ROLE_RELATE_ID IN NUMBER,

Line 420: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

416:
417: PROCEDURE update_group_membership
418: (P_API_VERSION IN NUMBER,
419: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
420: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
421: P_RESOURCE_ID IN NUMBER,
422: P_ROLE_ID IN NUMBER,
423: P_ROLE_RELATE_ID IN NUMBER,
424: P_START_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 424: P_START_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

420: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
421: P_RESOURCE_ID IN NUMBER,
422: P_ROLE_ID IN NUMBER,
423: P_ROLE_RELATE_ID IN NUMBER,
424: P_START_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
425: P_END_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
426: P_OBJECT_VERSION_NUM IN NUMBER,
427: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
428: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 425: P_END_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

421: P_RESOURCE_ID IN NUMBER,
422: P_ROLE_ID IN NUMBER,
423: P_ROLE_RELATE_ID IN NUMBER,
424: P_START_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
425: P_END_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
426: P_OBJECT_VERSION_NUM IN NUMBER,
427: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
428: X_MSG_COUNT OUT NOCOPY NUMBER,
429: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 434: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;

430: ) IS
431:
432: l_api_version constant number := 1.0;
433: l_api_name constant varchar2(30) := 'UPDATE_GROUP_MEMBERSHIP';
434: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;
435: l_msg_count number;
436: l_msg_data varchar2(2000);
437: l_object_version_num number := p_object_version_num;
438:

Line 484: x_return_status := fnd_api.g_ret_sts_success;

480: l_new_role_start_date date;
481: l_new_role_end_date date;
482:
483: BEGIN
484: x_return_status := fnd_api.g_ret_sts_success;
485:
486: savepoint upd_grp_memship;
487:
488: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE

Line 489: if fnd_api.tO_BOOLEAN(p_init_msg_list)

485:
486: savepoint upd_grp_memship;
487:
488: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
489: if fnd_api.tO_BOOLEAN(p_init_msg_list)
490: then
491: fnd_msg_pub.Initialize;
492: end if;
493:

Line 538: P_INIT_MSG_LIST => fnd_api.g_false,

534: end if;
535:
536: jtf_rs_role_relate_pub.update_resource_role_relate
537: (P_API_VERSION => 1.0,
538: P_INIT_MSG_LIST => fnd_api.g_false,
539: P_COMMIT => fnd_api.g_false,
540: P_ROLE_RELATE_ID => l_role_relate_id,
541: P_START_DATE_ACTIVE => l_new_role_start_date,
542: P_END_DATE_ACTIVE => l_new_role_end_date,

Line 539: P_COMMIT => fnd_api.g_false,

535:
536: jtf_rs_role_relate_pub.update_resource_role_relate
537: (P_API_VERSION => 1.0,
538: P_INIT_MSG_LIST => fnd_api.g_false,
539: P_COMMIT => fnd_api.g_false,
540: P_ROLE_RELATE_ID => l_role_relate_id,
541: P_START_DATE_ACTIVE => l_new_role_start_date,
542: P_END_DATE_ACTIVE => l_new_role_end_date,
543: P_OBJECT_VERSION_NUM => l_object_version_number,

Line 547: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

543: P_OBJECT_VERSION_NUM => l_object_version_number,
544: X_RETURN_STATUS => l_return_status,
545: X_MSG_COUNT => l_msg_count,
546: X_MSG_DATA => l_msg_data);
547: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
548: raise fnd_api.g_exc_unexpected_error;
549: end if;
550: else
551: -- dbms_output.put_line('no need to update the role');

Line 548: raise fnd_api.g_exc_unexpected_error;

544: X_RETURN_STATUS => l_return_status,
545: X_MSG_COUNT => l_msg_count,
546: X_MSG_DATA => l_msg_data);
547: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
548: raise fnd_api.g_exc_unexpected_error;
549: end if;
550: else
551: -- dbms_output.put_line('no need to update the role');
552: null;

Line 577: P_INIT_MSG_LIST => fnd_api.g_false,

573: end if;
574:
575: jtf_rs_role_relate_pub.update_resource_role_relate
576: (P_API_VERSION => 1.0,
577: P_INIT_MSG_LIST => fnd_api.g_false,
578: P_COMMIT => fnd_api.g_false,
579: P_ROLE_RELATE_ID => l_role_relate_id,
580: P_START_DATE_ACTIVE => l_new_role_start_date,
581: P_END_DATE_ACTIVE => l_new_role_end_date,

Line 578: P_COMMIT => fnd_api.g_false,

574:
575: jtf_rs_role_relate_pub.update_resource_role_relate
576: (P_API_VERSION => 1.0,
577: P_INIT_MSG_LIST => fnd_api.g_false,
578: P_COMMIT => fnd_api.g_false,
579: P_ROLE_RELATE_ID => l_role_relate_id,
580: P_START_DATE_ACTIVE => l_new_role_start_date,
581: P_END_DATE_ACTIVE => l_new_role_end_date,
582: P_OBJECT_VERSION_NUM => l_object_version_number,

Line 586: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

582: P_OBJECT_VERSION_NUM => l_object_version_number,
583: X_RETURN_STATUS => l_return_status,
584: X_MSG_COUNT => l_msg_count,
585: X_MSG_DATA => l_msg_data);
586: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
587: raise fnd_api.g_exc_unexpected_error;
588: end if;
589: elsif (p_start_date < l_start_date_active)
590: then

Line 587: raise fnd_api.g_exc_unexpected_error;

583: X_RETURN_STATUS => l_return_status,
584: X_MSG_COUNT => l_msg_count,
585: X_MSG_DATA => l_msg_data);
586: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
587: raise fnd_api.g_exc_unexpected_error;
588: end if;
589: elsif (p_start_date < l_start_date_active)
590: then
591: fetch chk_role_relate into l_role_relate_id_old,l_start_date_active,l_end_date_active,l_object_version_number_old;

Line 627: P_INIT_MSG_LIST => fnd_api.g_false,

623: end if;
624:
625: jtf_rs_role_relate_pub.update_resource_role_relate
626: (P_API_VERSION => 1.0,
627: P_INIT_MSG_LIST => fnd_api.g_false,
628: P_COMMIT => fnd_api.g_false,
629: P_ROLE_RELATE_ID => l_role_relate_id,
630: P_START_DATE_ACTIVE => l_new_role_start_date,
631: P_END_DATE_ACTIVE => l_new_role_end_date,

Line 628: P_COMMIT => fnd_api.g_false,

624:
625: jtf_rs_role_relate_pub.update_resource_role_relate
626: (P_API_VERSION => 1.0,
627: P_INIT_MSG_LIST => fnd_api.g_false,
628: P_COMMIT => fnd_api.g_false,
629: P_ROLE_RELATE_ID => l_role_relate_id,
630: P_START_DATE_ACTIVE => l_new_role_start_date,
631: P_END_DATE_ACTIVE => l_new_role_end_date,
632: P_OBJECT_VERSION_NUM => l_object_version_number,

Line 636: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

632: P_OBJECT_VERSION_NUM => l_object_version_number,
633: X_RETURN_STATUS => l_return_status,
634: X_MSG_COUNT => l_msg_count,
635: X_MSG_DATA => l_msg_data);
636: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
637: raise fnd_api.g_exc_unexpected_error;
638: end if;
639:
640: end if;

Line 637: raise fnd_api.g_exc_unexpected_error;

633: X_RETURN_STATUS => l_return_status,
634: X_MSG_COUNT => l_msg_count,
635: X_MSG_DATA => l_msg_data);
636: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
637: raise fnd_api.g_exc_unexpected_error;
638: end if;
639:
640: end if;
641:

Line 650: ,p_init_msg_list => fnd_api.g_false

646: /* Calling the role relate api's to create resource role relation */
647:
648: jtf_rs_role_relate_pub.update_resource_role_relate
649: (p_api_version => 1.0
650: ,p_init_msg_list => fnd_api.g_false
651: ,p_commit => fnd_api.g_false
652: ,p_role_relate_id => p_role_relate_id
653: ,p_start_date_active => p_start_date
654: ,p_end_date_active => p_end_date

Line 651: ,p_commit => fnd_api.g_false

647:
648: jtf_rs_role_relate_pub.update_resource_role_relate
649: (p_api_version => 1.0
650: ,p_init_msg_list => fnd_api.g_false
651: ,p_commit => fnd_api.g_false
652: ,p_role_relate_id => p_role_relate_id
653: ,p_start_date_active => p_start_date
654: ,p_end_date_active => p_end_date
655: ,p_object_version_num => l_object_version_num

Line 661: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

657: ,x_msg_count => l_msg_count
658: ,x_msg_data => l_msg_data
659: );
660:
661: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
662: raise fnd_api.g_exc_unexpected_error;
663: end if;
664:
665: --dbms_output.put_line(' group role_relate id = ' || to_char(l_role_relate_id));

Line 662: raise fnd_api.g_exc_unexpected_error;

658: ,x_msg_data => l_msg_data
659: );
660:
661: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
662: raise fnd_api.g_exc_unexpected_error;
663: end if;
664:
665: --dbms_output.put_line(' group role_relate id = ' || to_char(l_role_relate_id));
666:

Line 667: if fnd_api.to_boolean(p_commit)

663: end if;
664:
665: --dbms_output.put_line(' group role_relate id = ' || to_char(l_role_relate_id));
666:
667: if fnd_api.to_boolean(p_commit)
668: then
669: commit work;
670: end if;
671:

Line 675: when fnd_api.g_exc_unexpected_error

671:
672: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
673:
674: exception
675: when fnd_api.g_exc_unexpected_error
676: then
677: rollback to upd_grp_memship;
678: x_return_status := fnd_api.g_ret_sts_error;
679: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 678: x_return_status := fnd_api.g_ret_sts_error;

674: exception
675: when fnd_api.g_exc_unexpected_error
676: then
677: rollback to upd_grp_memship;
678: x_return_status := fnd_api.g_ret_sts_error;
679: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO upd_grp_memship;

Line 680: WHEN fnd_api.g_exc_error

676: then
677: rollback to upd_grp_memship;
678: x_return_status := fnd_api.g_ret_sts_error;
679: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO upd_grp_memship;
683: x_return_status := fnd_api.g_ret_sts_error;
684: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 683: x_return_status := fnd_api.g_ret_sts_error;

679: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO upd_grp_memship;
683: x_return_status := fnd_api.g_ret_sts_error;
684: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
685: when others
686: then
687: rollback to upd_grp_memship;

Line 693: x_return_status := fnd_api.g_ret_sts_unexp_error;

689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695:
696: END update_group_membership;
697:

Line 700: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

696: END update_group_membership;
697:
698: PROCEDURE delete_group_membership
699: (P_API_VERSION IN NUMBER,
700: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
701: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
702: P_GROUP_ID IN NUMBER,
703: P_RESOURCE_ID IN NUMBER,
704: P_GROUP_MEMBER_ID IN NUMBER,

Line 701: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

697:
698: PROCEDURE delete_group_membership
699: (P_API_VERSION IN NUMBER,
700: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
701: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
702: P_GROUP_ID IN NUMBER,
703: P_RESOURCE_ID IN NUMBER,
704: P_GROUP_MEMBER_ID IN NUMBER,
705: P_ROLE_RELATE_ID IN NUMBER,

Line 714: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;

710: ) IS
711:
712: l_api_version constant number := 1.0;
713: l_api_name constant varchar2(30) := 'DELETE_GROUP_MEMBERSHIP';
714: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;
715: l_msg_count number;
716: l_msg_data varchar2(2000);
717:
718: /* Cursor Variables to check group member has to be deleted or not */

Line 742: x_return_status := fnd_api.g_ret_sts_success;

738: l_object_version_num jtf_rs_role_relations.object_version_number%type;
739:
740: BEGIN
741:
742: x_return_status := fnd_api.g_ret_sts_success;
743:
744: savepoint del_grp_memship;
745:
746: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE

Line 748: if fnd_api.tO_BOOLEAN(p_init_msg_list)

744: savepoint del_grp_memship;
745:
746: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
747:
748: if fnd_api.tO_BOOLEAN(p_init_msg_list)
749: then
750: fnd_msg_pub.Initialize;
751: end if;
752:

Line 756: P_INIT_MSG_LIST => fnd_api.g_false,

752:
753: if (p_role_relate_id is not null) then
754: jtf_rs_role_relate_pub.delete_resource_role_relate
755: (P_API_VERSION => 1.0,
756: P_INIT_MSG_LIST => fnd_api.g_false,
757: P_COMMIT => fnd_api.g_false,
758: P_ROLE_RELATE_ID => p_role_relate_id,
759: P_OBJECT_VERSION_NUM => p_object_version_num,
760: X_RETURN_STATUS => l_return_status,

Line 757: P_COMMIT => fnd_api.g_false,

753: if (p_role_relate_id is not null) then
754: jtf_rs_role_relate_pub.delete_resource_role_relate
755: (P_API_VERSION => 1.0,
756: P_INIT_MSG_LIST => fnd_api.g_false,
757: P_COMMIT => fnd_api.g_false,
758: P_ROLE_RELATE_ID => p_role_relate_id,
759: P_OBJECT_VERSION_NUM => p_object_version_num,
760: X_RETURN_STATUS => l_return_status,
761: X_MSG_COUNT => l_msg_count,

Line 763: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

759: P_OBJECT_VERSION_NUM => p_object_version_num,
760: X_RETURN_STATUS => l_return_status,
761: X_MSG_COUNT => l_msg_count,
762: X_MSG_DATA => l_msg_data);
763: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
764: raise fnd_api.g_exc_unexpected_error;
765: end if;
766: else
767: -- open group_member_exists(p_group_member_id);

Line 764: raise fnd_api.g_exc_unexpected_error;

760: X_RETURN_STATUS => l_return_status,
761: X_MSG_COUNT => l_msg_count,
762: X_MSG_DATA => l_msg_data);
763: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
764: raise fnd_api.g_exc_unexpected_error;
765: end if;
766: else
767: -- open group_member_exists(p_group_member_id);
768: -- fetch group_member_exists

Line 780: P_INIT_MSG_LIST => fnd_api.g_false,

776: close get_obj_ver_num;
777:
778: jtf_rs_group_members_pub.delete_resource_group_members
779: (P_API_VERSION => 1.0,
780: P_INIT_MSG_LIST => fnd_api.g_false,
781: P_COMMIT => fnd_api.g_false,
782: P_GROUP_ID => p_group_id,
783: P_GROUP_NUMBER => null,
784: P_RESOURCE_ID => p_resource_id,

Line 781: P_COMMIT => fnd_api.g_false,

777:
778: jtf_rs_group_members_pub.delete_resource_group_members
779: (P_API_VERSION => 1.0,
780: P_INIT_MSG_LIST => fnd_api.g_false,
781: P_COMMIT => fnd_api.g_false,
782: P_GROUP_ID => p_group_id,
783: P_GROUP_NUMBER => null,
784: P_RESOURCE_ID => p_resource_id,
785: P_RESOURCE_NUMBER => null,

Line 791: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

787: X_RETURN_STATUS => l_return_status,
788: X_MSG_COUNT => l_msg_count,
789: X_MSG_DATA => l_msg_data);
790:
791: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
792: raise fnd_api.g_exc_unexpected_error;
793: end if;
794: -- end if;
795: -- close group_member_exists;

Line 792: raise fnd_api.g_exc_unexpected_error;

788: X_MSG_COUNT => l_msg_count,
789: X_MSG_DATA => l_msg_data);
790:
791: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
792: raise fnd_api.g_exc_unexpected_error;
793: end if;
794: -- end if;
795: -- close group_member_exists;
796: end if;

Line 798: if fnd_api.to_boolean(p_commit)

794: -- end if;
795: -- close group_member_exists;
796: end if;
797:
798: if fnd_api.to_boolean(p_commit)
799: then
800: commit work;
801: end if;
802:

Line 806: when fnd_api.g_exc_unexpected_error

802:
803: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
804:
805: exception
806: when fnd_api.g_exc_unexpected_error
807: then
808: rollback to del_grp_memship;
809: x_return_status := fnd_api.g_ret_sts_error;
810: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 809: x_return_status := fnd_api.g_ret_sts_error;

805: exception
806: when fnd_api.g_exc_unexpected_error
807: then
808: rollback to del_grp_memship;
809: x_return_status := fnd_api.g_ret_sts_error;
810: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
811: WHEN fnd_api.g_exc_error
812: THEN
813: ROLLBACK TO del_grp_memship;

Line 811: WHEN fnd_api.g_exc_error

807: then
808: rollback to del_grp_memship;
809: x_return_status := fnd_api.g_ret_sts_error;
810: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
811: WHEN fnd_api.g_exc_error
812: THEN
813: ROLLBACK TO del_grp_memship;
814: x_return_status := fnd_api.g_ret_sts_error;
815: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 814: x_return_status := fnd_api.g_ret_sts_error;

810: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
811: WHEN fnd_api.g_exc_error
812: THEN
813: ROLLBACK TO del_grp_memship;
814: x_return_status := fnd_api.g_ret_sts_error;
815: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
816: when others
817: then
818: rollback to del_grp_memship;

Line 824: x_return_status := fnd_api.g_ret_sts_unexp_error;

820: fnd_message.set_token('P_SQLCODE',SQLCODE);
821: fnd_message.set_token('P_SQLERRM',SQLERRM);
822: fnd_message.set_token('P_API_NAME',l_api_name);
823: FND_MSG_PUB.add;
824: x_return_status := fnd_api.g_ret_sts_unexp_error;
825: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
826:
827: END delete_group_membership;
828: