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.CN_ROLE_PLANS_PUB dependencies on CN_API

Line 253: IF (cn_api.chk_miss_null_char_para

249:
250: -- validate the following issues
251:
252: -- role_name can not be missing or null
253: IF (cn_api.chk_miss_null_char_para
254: (p_char_para => p_role_plan_rec.role_name,
255: p_obj_name => g_role_name,
256: p_loading_status => x_loading_status,
257: x_loading_status => x_loading_status

Line 265: IF (cn_api.chk_miss_null_char_para

261: RAISE fnd_api.g_exc_error;
262: END IF;
263:
264: -- comp_plan_name can not be missing or null
265: IF (cn_api.chk_miss_null_char_para
266: (p_char_para => p_role_plan_rec.comp_plan_name,
267: p_obj_name => g_cp_name,
268: p_loading_status => x_loading_status,
269: x_loading_status => x_loading_status

Line 279: IF ((cn_api.invalid_date_range

275:
276: -- start_date can not be null
277: -- start_date can not be missing
278: -- start_date < end_date if end_date is null
279: IF ((cn_api.invalid_date_range
280: (p_start_date => p_role_plan_rec.start_date,
281: p_end_date => p_role_plan_rec.end_date,
282: p_end_date_nullable => fnd_api.g_true,
283: p_loading_status => x_loading_status,

Line 306: x_role_id := cn_api.get_role_id (p_role_plan_rec.role_name);

302: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
303: RAISE fnd_api.g_exc_error;
304: ELSE
305: -- CHANTHON: ORG_ID need not be passed here
306: x_role_id := cn_api.get_role_id (p_role_plan_rec.role_name);
307: END IF;
308:
309: -- comp_plan_name must exist in cn_comp_plans
310: IF NOT valid_comp_plan_name (p_role_plan_rec.comp_plan_name,

Line 327: cn_api.get_cp_id (p_role_plan_rec.comp_plan_name,

323: x_loading_status := 'CN_RL_ASGN_CP_NOT_EXIST';
324: RAISE fnd_api.g_exc_error;
325: ELSE
326: x_comp_plan_id :=
327: cn_api.get_cp_id (p_role_plan_rec.comp_plan_name,
328: p_role_plan_rec.org_id
329: );
330: END IF;
331:

Line 356: IF NOT cn_api.date_range_within (p_role_plan_rec.start_date,

352: CLOSE l_cp_cur;
353:
354: RAISE fnd_api.g_exc_error;
355: ELSE
356: IF NOT cn_api.date_range_within (p_role_plan_rec.start_date,
357: p_role_plan_rec.end_date,
358: l_cp_rec.start_date,
359: l_cp_rec.end_date
360: )

Line 392: IF cn_api.date_range_overlap (l_rec.start_date,

388: -- If existing any same role_id in cn_role_plans THEN
389: -- check no overlap and no gap
390: FOR l_rec IN l_cur (x_role_id, p_role_plan_rec.org_id)
391: LOOP
392: IF cn_api.date_range_overlap (l_rec.start_date,
393: l_rec.end_date,
394: p_role_plan_rec.start_date,
395: p_role_plan_rec.end_date
396: )

Line 402: cn_api.get_cp_name (l_rec.comp_plan_id)

398: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
399: THEN
400: fnd_message.set_name ('CN', 'CN_RL_ROLE_PLAN_OVERLAP');
401: fnd_message.set_token ('COMP_PLAN_NAME',
402: cn_api.get_cp_name (l_rec.comp_plan_id)
403: );
404: fnd_message.set_token ('START_DATE', l_rec.start_date);
405: fnd_message.set_token ('END_DATE', l_rec.end_date);
406: fnd_msg_pub.ADD;

Line 518: cn_api.get_role_plan_id (p_role_plan_rec_old.role_name,

514: -- validate the following issues
515:
516: -- old role_plan_id must exist in cn_role_plans
517: x_role_plan_id_old :=
518: cn_api.get_role_plan_id (p_role_plan_rec_old.role_name,
519: p_role_plan_rec_old.comp_plan_name,
520: p_role_plan_rec_old.start_date,
521: p_role_plan_rec_old.end_date,
522: p_role_plan_rec_old.org_id

Line 539: IF (cn_api.chk_null_char_para

535: END IF;
536:
537: -- new role_name can not be null
538: -- note that new role_name can be missing
539: IF (cn_api.chk_null_char_para
540: (p_char_para => p_role_plan_rec_new.role_name,
541: p_obj_name => g_role_name,
542: p_loading_status => x_loading_status,
543: x_loading_status => x_loading_status

Line 552: IF (cn_api.chk_null_char_para

548: END IF;
549:
550: -- new comp_plan_name can not be null
551: -- note that new comp_plan_name can be missing
552: IF (cn_api.chk_null_char_para
553: (p_char_para => p_role_plan_rec_new.comp_plan_name,
554: p_obj_name => g_cp_name,
555: p_loading_status => x_loading_status,
556: x_loading_status => x_loading_status

Line 565: IF (cn_api.chk_null_date_para

561: END IF;
562:
563: -- new start_date can not be null
564: -- note that new start_date can be missing
565: IF (cn_api.chk_null_date_para
566: (p_date_para => p_role_plan_rec_new.start_date,
567: p_obj_name => g_start_date,
568: p_loading_status => x_loading_status,
569: x_loading_status => x_loading_status

Line 664: x_role_id := cn_api.get_role_id (p_role_plan_rec_new.role_name);

660:
661: -- if new role_name is not missing then new role_name must exist in cn_roles
662: IF (p_role_plan_rec_new.role_name <> fnd_api.g_miss_char)
663: THEN
664: x_role_id := cn_api.get_role_id (p_role_plan_rec_new.role_name);
665:
666: IF (x_role_id IS NULL)
667: THEN
668: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

Line 713: cn_api.get_cp_id (p_role_plan_rec_new.comp_plan_name,

709: -- new comp_plan_name must exist in cn_comp_plans
710: IF (p_role_plan_rec_new.comp_plan_name <> fnd_api.g_miss_char)
711: THEN
712: x_comp_plan_id :=
713: cn_api.get_cp_id (p_role_plan_rec_new.comp_plan_name,
714: p_role_plan_rec_new.org_id
715: );
716:
717: IF (x_comp_plan_id IS NULL)

Line 774: IF NOT cn_api.date_range_within (tmp_start_date,

770: CLOSE l_cp_cur;
771:
772: RAISE fnd_api.g_exc_error;
773: ELSE
774: IF NOT cn_api.date_range_within (tmp_start_date,
775: tmp_end_date,
776: l_cp_rec.start_date,
777: l_cp_rec.end_date
778: )

Line 788: cn_api.get_cp_name (x_comp_plan_id)

784: fnd_message.set_token ('END_DATE', tmp_end_date);
785: fnd_message.set_token ('CP_START_DATE', l_cp_rec.start_date);
786: fnd_message.set_token ('CP_END_DATE', l_cp_rec.end_date);
787: fnd_message.set_token ('COMP_PLAN_NAME',
788: cn_api.get_cp_name (x_comp_plan_id)
789: );
790: fnd_msg_pub.ADD;
791: END IF;
792:

Line 811: IF cn_api.date_range_overlap (l_rec.start_date,

807: x_role_plan_id_old,
808: p_role_plan_rec_new.org_id
809: )
810: LOOP
811: IF cn_api.date_range_overlap (l_rec.start_date,
812: l_rec.end_date,
813: tmp_start_date,
814: tmp_end_date
815: )

Line 821: cn_api.get_cp_name (l_rec.comp_plan_id)

817: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
818: THEN
819: fnd_message.set_name ('CN', 'CN_RL_ROLE_PLAN_OVERLAP');
820: fnd_message.set_token ('COMP_PLAN_NAME',
821: cn_api.get_cp_name (l_rec.comp_plan_id)
822: );
823: fnd_message.set_token ('START_DATE', l_rec.start_date);
824: fnd_message.set_token ('END_DATE', l_rec.end_date);
825: fnd_msg_pub.ADD;

Line 926: cn_api.get_role_plan_id (p_role_plan_rec.role_name,

922: -- Valide the following issues
923:
924: -- Checke if the p_role_plan_id does exist.
925: x_role_plan_id :=
926: cn_api.get_role_plan_id (p_role_plan_rec.role_name,
927: p_role_plan_rec.comp_plan_name,
928: p_role_plan_rec.start_date,
929: p_role_plan_rec.end_date,
930: p_role_plan_rec.org_id

Line 1316: cn_api.get_cp_name (p_role_plan_rec.comp_plan_id);

1312: -- CHANTHON: Added to get the comp plan name and role name when the ids are provided
1313: IF (l_rec.role_name IS NULL AND l_rec.comp_plan_name IS NULL)
1314: THEN
1315: l_rec.comp_plan_name :=
1316: cn_api.get_cp_name (p_role_plan_rec.comp_plan_id);
1317: l_rec.role_name := cn_api.get_role_name (p_role_plan_rec.role_id);
1318: END IF;
1319:
1320: -- User hooks

Line 1317: l_rec.role_name := cn_api.get_role_name (p_role_plan_rec.role_id);

1313: IF (l_rec.role_name IS NULL AND l_rec.comp_plan_name IS NULL)
1314: THEN
1315: l_rec.comp_plan_name :=
1316: cn_api.get_cp_name (p_role_plan_rec.comp_plan_id);
1317: l_rec.role_name := cn_api.get_role_name (p_role_plan_rec.role_id);
1318: END IF;
1319:
1320: -- User hooks
1321:

Line 1718: SELECT cn_api.g_miss_char role_name,

1714: -- The role plan id should be passed in as null if the original record
1715: -- before updating is available.
1716: IF (p_role_plan_id IS NOT NULL)
1717: THEN
1718: SELECT cn_api.g_miss_char role_name,
1719: role_id,
1720: cn_api.g_miss_char comp_plan_name,
1721: comp_plan_id,
1722: start_date,

Line 1720: cn_api.g_miss_char comp_plan_name,

1716: IF (p_role_plan_id IS NOT NULL)
1717: THEN
1718: SELECT cn_api.g_miss_char role_name,
1719: role_id,
1720: cn_api.g_miss_char comp_plan_name,
1721: comp_plan_id,
1722: start_date,
1723: end_date,
1724: attribute_category,

Line 1782: cn_api.get_cp_name (l_rec_old.comp_plan_id);

1778: -- CHANTHON: Added to get the comp plan and role names given the ids
1779: IF (l_rec_new.role_name IS NULL AND l_rec_new.comp_plan_name IS NULL)
1780: THEN
1781: l_rec_old.comp_plan_name :=
1782: cn_api.get_cp_name (l_rec_old.comp_plan_id);
1783: l_rec_old.role_name := cn_api.get_role_name (l_rec_old.role_id);
1784: l_rec_new.comp_plan_name :=
1785: cn_api.get_cp_name (p_role_plan_rec_new.comp_plan_id);
1786: l_rec_new.role_name :=

Line 1783: l_rec_old.role_name := cn_api.get_role_name (l_rec_old.role_id);

1779: IF (l_rec_new.role_name IS NULL AND l_rec_new.comp_plan_name IS NULL)
1780: THEN
1781: l_rec_old.comp_plan_name :=
1782: cn_api.get_cp_name (l_rec_old.comp_plan_id);
1783: l_rec_old.role_name := cn_api.get_role_name (l_rec_old.role_id);
1784: l_rec_new.comp_plan_name :=
1785: cn_api.get_cp_name (p_role_plan_rec_new.comp_plan_id);
1786: l_rec_new.role_name :=
1787: cn_api.get_role_name (p_role_plan_rec_new.role_id);

Line 1785: cn_api.get_cp_name (p_role_plan_rec_new.comp_plan_id);

1781: l_rec_old.comp_plan_name :=
1782: cn_api.get_cp_name (l_rec_old.comp_plan_id);
1783: l_rec_old.role_name := cn_api.get_role_name (l_rec_old.role_id);
1784: l_rec_new.comp_plan_name :=
1785: cn_api.get_cp_name (p_role_plan_rec_new.comp_plan_id);
1786: l_rec_new.role_name :=
1787: cn_api.get_role_name (p_role_plan_rec_new.role_id);
1788: END IF;
1789:

Line 1787: cn_api.get_role_name (p_role_plan_rec_new.role_id);

1783: l_rec_old.role_name := cn_api.get_role_name (l_rec_old.role_id);
1784: l_rec_new.comp_plan_name :=
1785: cn_api.get_cp_name (p_role_plan_rec_new.comp_plan_id);
1786: l_rec_new.role_name :=
1787: cn_api.get_role_name (p_role_plan_rec_new.role_id);
1788: END IF;
1789:
1790: -- User hooks
1791:

Line 2397: IF ((l_rec.role_name IS NULL or l_rec.role_name = cn_api.G_MISS_CHAR)

2393: -- and Business APIs
2394: l_rec := p_role_plan_rec;
2395:
2396: --CHANTHON: Added to get the comp plan name and role name
2397: IF ((l_rec.role_name IS NULL or l_rec.role_name = cn_api.G_MISS_CHAR)
2398: AND (l_rec.comp_plan_name IS NULL or l_rec.comp_plan_name = cn_api.G_MISS_CHAR))
2399: THEN
2400: l_rec.comp_plan_name :=
2401: cn_api.get_cp_name (p_role_plan_rec.comp_plan_id);

Line 2398: AND (l_rec.comp_plan_name IS NULL or l_rec.comp_plan_name = cn_api.G_MISS_CHAR))

2394: l_rec := p_role_plan_rec;
2395:
2396: --CHANTHON: Added to get the comp plan name and role name
2397: IF ((l_rec.role_name IS NULL or l_rec.role_name = cn_api.G_MISS_CHAR)
2398: AND (l_rec.comp_plan_name IS NULL or l_rec.comp_plan_name = cn_api.G_MISS_CHAR))
2399: THEN
2400: l_rec.comp_plan_name :=
2401: cn_api.get_cp_name (p_role_plan_rec.comp_plan_id);
2402: l_rec.role_name := cn_api.get_role_name (p_role_plan_rec.role_id);

Line 2401: cn_api.get_cp_name (p_role_plan_rec.comp_plan_id);

2397: IF ((l_rec.role_name IS NULL or l_rec.role_name = cn_api.G_MISS_CHAR)
2398: AND (l_rec.comp_plan_name IS NULL or l_rec.comp_plan_name = cn_api.G_MISS_CHAR))
2399: THEN
2400: l_rec.comp_plan_name :=
2401: cn_api.get_cp_name (p_role_plan_rec.comp_plan_id);
2402: l_rec.role_name := cn_api.get_role_name (p_role_plan_rec.role_id);
2403: END IF;
2404:
2405: -- User hooks

Line 2402: l_rec.role_name := cn_api.get_role_name (p_role_plan_rec.role_id);

2398: AND (l_rec.comp_plan_name IS NULL or l_rec.comp_plan_name = cn_api.G_MISS_CHAR))
2399: THEN
2400: l_rec.comp_plan_name :=
2401: cn_api.get_cp_name (p_role_plan_rec.comp_plan_id);
2402: l_rec.role_name := cn_api.get_role_name (p_role_plan_rec.role_id);
2403: END IF;
2404:
2405: -- User hooks
2406:

Line 2488: l_role_id := cn_api.get_role_id(l_rec.role_name);

2484: THEN
2485: RAISE fnd_api.g_exc_error;
2486: ELSE
2487: -- need to call srp assignment API to delete
2488: l_role_id := cn_api.get_role_id(l_rec.role_name);
2489: srp_plan_assignment_for_delete
2490: (p_role_id => l_role_id,
2491: p_role_plan_id => l_role_plan_id,
2492: x_return_status => x_return_status,