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_PMT_PLANS_PVT dependencies on CN_API

Line 151: IF (cn_api.chk_miss_null_char_para

147:
148: -- validate the following issues
149:
150: -- role_name can not be missing or null
151: IF (cn_api.chk_miss_null_char_para
152: (p_char_para => p_role_pmt_plan_rec.role_name,
153: p_obj_name => G_ROLE_NAME,
154: p_loading_status => x_loading_status,
155: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 160: IF (cn_api.chk_miss_null_char_para

156: RAISE FND_API.G_EXC_ERROR ;
157: END IF;
158:
159: -- pmt_plan_name can not be missing or null
160: IF (cn_api.chk_miss_null_char_para
161: (p_char_para => p_role_pmt_plan_rec.pmt_plan_name,
162: p_obj_name => G_PP_NAME,
163: p_loading_status => x_loading_status,
164: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 171: IF ( (cn_api.invalid_date_range

167:
168: -- start_date can not be null
169: -- start_date can not be missing
170: -- start_date < end_date if end_date is null
171: IF ( (cn_api.invalid_date_range
172: (p_start_date => p_role_pmt_plan_rec.start_date,
173: p_end_date => p_role_pmt_plan_rec.end_date,
174: p_end_date_nullable => FND_API.G_TRUE,
175: p_loading_status => x_loading_status,

Line 190: x_role_id := cn_api.get_role_id(p_role_pmt_plan_rec.role_name);

186: END IF;
187: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
188: RAISE fnd_api.g_exc_error;
189: ELSE
190: x_role_id := cn_api.get_role_id(p_role_pmt_plan_rec.role_name);
191: END IF;
192:
193: -- pmt_plan_id must exist in cn_pmt_plans
194: IF NOT valid_pmt_plan_id(p_role_pmt_plan_rec.pmt_plan_id, p_role_pmt_plan_rec.org_id) THEN

Line 203: --x_pmt_plan_id := cn_api.get_pp_id(p_role_pmt_plan_rec.pmt_plan_name,p_role_pmt_plan_rec.org_id);

199: END IF;
200: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';
201: RAISE fnd_api.g_exc_error;
202: ELSE
203: --x_pmt_plan_id := cn_api.get_pp_id(p_role_pmt_plan_rec.pmt_plan_name,p_role_pmt_plan_rec.org_id);
204: x_pmt_plan_id := p_role_pmt_plan_rec.pmt_plan_id;
205: END IF;
206:
207: -- (start_date, end_date) is within comp plan's (start_date, end_date)

Line 223: --IF NOT cn_api.date_range_within(p_role_pmt_plan_rec.start_date,

219: CLOSE l_pp_cur;
220: RAISE fnd_api.g_exc_error;
221: ELSE
222: --Commented out by Julia Huang for bug 3135619.
223: --IF NOT cn_api.date_range_within(p_role_pmt_plan_rec.start_date,
224: IF NOT date_range_within(p_role_pmt_plan_rec.start_date,
225: p_role_pmt_plan_rec.end_date,
226: l_pp_rec.start_date,
227: l_pp_rec.end_date) THEN

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

277: from cn_pmt_plans
278: where pmt_plan_id = p_role_pmt_plan_rec.pmt_plan_id
279: and org_id = p_role_pmt_plan_rec.org_id;
280:
281: IF ((cn_api.date_range_overlap(l_rec.start_date,
282: l_rec.end_date,
283: p_role_pmt_plan_rec.start_date,
284: p_role_pmt_plan_rec.end_date))
285: AND

Line 293: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));

289: THEN
290:
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
292: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
293: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
294: fnd_message.set_token('START_DATE',l_rec.start_date);
295: fnd_message.set_token('END_DATE',l_rec.end_date);
296: fnd_msg_pub.ADD;
297: END IF;

Line 404: cn_api.get_role_pmt_plan_id(p_role_pmt_plan_rec_old.role_name,

400: -- validate the following issues
401:
402: -- old role_plan_id must exist in cn_role_plans
403: x_role_pmt_plan_id_old :=
404: cn_api.get_role_pmt_plan_id(p_role_pmt_plan_rec_old.role_name,
405: p_role_pmt_plan_rec_old.pmt_plan_name,
406: p_role_pmt_plan_rec_old.start_date,
407: p_role_pmt_plan_rec_old.end_date,
408: p_role_pmt_plan_rec_old.org_id);

Line 421: IF (cn_api.chk_null_char_para

417: END IF;
418:
419: -- new role_name can not be null
420: -- note that new role_name can be missing
421: IF (cn_api.chk_null_char_para
422: (p_char_para => p_role_pmt_plan_rec_new.role_name,
423: p_obj_name => G_ROLE_NAME,
424: p_loading_status => x_loading_status,
425: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 431: IF (cn_api.chk_null_char_para

427: END IF;
428:
429: -- new pmt_plan_name can not be null
430: -- note that new pmt_plan_name can be missing
431: IF (cn_api.chk_null_char_para
432: (p_char_para => p_role_pmt_plan_rec_new.pmt_plan_name,
433: p_obj_name => G_PP_NAME,
434: p_loading_status => x_loading_status,
435: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 441: IF (cn_api.chk_null_date_para

437: END IF;
438:
439: -- new start_date can not be null
440: -- note that new start_date can be missing
441: IF (cn_api.chk_null_date_para
442: (p_date_para => p_role_pmt_plan_rec_new.start_date,
443: p_obj_name => G_START_DATE,
444: p_loading_status => x_loading_status,
445: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 503: x_role_id := cn_api.get_role_id(p_role_pmt_plan_rec_new.role_name);

499: END IF;
500:
501: -- if new role_name is not missing then new role_name must exist in cn_roles
502: IF (p_role_pmt_plan_rec_new.role_name <> fnd_api.g_miss_char) THEN
503: x_role_id := cn_api.get_role_id(p_role_pmt_plan_rec_new.role_name);
504: IF (x_role_id IS NULL) THEN
505: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
506: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
507: fnd_message.set_token('ROLE_NAME',p_role_pmt_plan_rec_new.role_name);

Line 535: x_pmt_plan_id := cn_api.get_pp_id(p_role_pmt_plan_rec_new.pmt_plan_name,p_role_pmt_plan_rec_new.org_id);

531:
532: -- if new pmt_plan_name is not missing then
533: -- new pmt_plan_name must exist in cn_pmt_plans
534: IF (p_role_pmt_plan_rec_new.pmt_plan_name <> fnd_api.g_miss_char) THEN
535: x_pmt_plan_id := cn_api.get_pp_id(p_role_pmt_plan_rec_new.pmt_plan_name,p_role_pmt_plan_rec_new.org_id);
536: IF (x_pmt_plan_id IS NULL) THEN
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
538: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
539: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec_new.pmt_plan_name);

Line 574: --IF NOT cn_api.date_range_within(tmp_start_date,

570: CLOSE l_pp_cur;
571: RAISE fnd_api.g_exc_error;
572: ELSE
573: --Commented out by Julia Huang for bug 3135619.
574: --IF NOT cn_api.date_range_within(tmp_start_date,
575: IF NOT date_range_within(tmp_start_date,
576: tmp_end_date,
577: l_pp_rec.start_date,
578: l_pp_rec.end_date) THEN

Line 585: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));

581: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
584: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
585: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
586: fnd_msg_pub.ADD;
587: END IF;
588: x_loading_status := 'CN_RL_PP_DATE_RANGE_NOT_WITHIN';
589: CLOSE l_pp_cur;

Line 603: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));

599: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
601: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
602: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
603: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
604: fnd_msg_pub.ADD;
605: END IF;
606:
607: x_loading_status := 'CN_RL_PP_SD_LESS_THAN_PP_SD';

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

617: -- If existing any same role_id in cn_role_pmt_plans THEN
618: -- check no overlap
619: FOR l_rec IN l_cur(x_role_id,x_role_pmt_plan_id_old)
620: LOOP
621: IF cn_api.date_range_overlap(l_rec.start_date,
622: l_rec.end_date,
623: tmp_start_date,
624: tmp_end_date) THEN
625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 627: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));

623: tmp_start_date,
624: tmp_end_date) THEN
625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
626: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
627: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
628: fnd_message.set_token('START_DATE',l_rec.start_date);
629: fnd_message.set_token('END_DATE',l_rec.end_date);
630: fnd_msg_pub.ADD;
631: END IF;

Line 732: /*x_role_pmt_plan_id := cn_api.get_role_pmt_plan_id(p_role_pmt_plan_rec.role_name,

728: -- Checke if the p_role_pmt_plan_id does exist.
729:
730: x_role_pmt_plan_id := p_role_pmt_plan_rec.role_pmt_plan_id;
731:
732: /*x_role_pmt_plan_id := cn_api.get_role_pmt_plan_id(p_role_pmt_plan_rec.role_name,
733: p_role_pmt_plan_rec.pmt_plan_name,
734: p_role_pmt_plan_rec.start_date,
735: p_role_pmt_plan_rec.end_date,
736: p_role_pmt_plan_rec.org_id);*/

Line 1497: l_role_id := cn_api.get_role_id(p_role_pmt_plan_rec.role_name);

1493: ELSE
1494:
1495: -- need to call srp assignment API to delete
1496:
1497: l_role_id := cn_api.get_role_id(p_role_pmt_plan_rec.role_name);
1498: srp_pmt_plan_asgn_for_delete(p_role_id => l_role_id,
1499: p_role_pmt_plan_id => l_role_pmt_plan_id,
1500: p_suppress_flag => 'Y',
1501: x_return_status => x_return_status,

Line 1612: x_date_range_tbl cn_api.date_range_tbl_type;

1608: a_end_date DATE,
1609: b_start_date DATE,
1610: b_end_date DATE
1611: ) RETURN NUMBER IS
1612: x_date_range_tbl cn_api.date_range_tbl_type;
1613: BEGIN
1614: cn_api.get_date_range_diff(a_start_date,
1615: a_end_date,
1616: b_start_date,

Line 1614: cn_api.get_date_range_diff(a_start_date,

1610: b_end_date DATE
1611: ) RETURN NUMBER IS
1612: x_date_range_tbl cn_api.date_range_tbl_type;
1613: BEGIN
1614: cn_api.get_date_range_diff(a_start_date,
1615: a_end_date,
1616: b_start_date,
1617: b_end_date,
1618: x_date_range_tbl);

Line 1641: if(cn_api.date_range_overlap(a_start_date,

1637: ) RETURN NUMBER IS
1638: x_start_date DATE;
1639: x_end_date DATE;
1640: BEGIN
1641: if(cn_api.date_range_overlap(a_start_date,
1642: a_end_date,
1643: b_start_date,
1644: b_end_date)) THEN
1645: cn_api.get_date_range_intersect(a_start_date,

Line 1645: cn_api.get_date_range_intersect(a_start_date,

1641: if(cn_api.date_range_overlap(a_start_date,
1642: a_end_date,
1643: b_start_date,
1644: b_end_date)) THEN
1645: cn_api.get_date_range_intersect(a_start_date,
1646: a_end_date,
1647: b_start_date,
1648: b_end_date,
1649: x_start_date,