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

Line 1: PACKAGE BODY CN_API as

1: PACKAGE BODY CN_API as
2: /* $Header: cnputilb.pls 120.11.12010000.5 2008/12/19 11:44:06 ramchint ship $ */
3:
4: --| ----------------------------------------------------------------------+
5: --| Procedure Name : get_fnd_message

Line 224: 'cn.plsql.cn_api.chk_miss_char_para.error',

220: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
221: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
222: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
223: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
224: 'cn.plsql.cn_api.chk_miss_char_para.error',
225: true);
226: end if;
227:
228: -- Error, check the msg level and add an error message to the

Line 262: 'cn.plsql.cn_api.chk_miss_num_para.error',

258: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
259: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
260: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
261: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
262: 'cn.plsql.cn_api.chk_miss_num_para.error',
263: true);
264: end if;
265:
266: -- Error, check the msg level and add an error message to the

Line 300: 'cn.plsql.cn_api.chk_miss_date_para.error',

296: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
297: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
298: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
299: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
300: 'cn.plsql.cn_api.chk_miss_date_para.error',
301: true);
302: end if;
303:
304: -- Error, check the msg level and add an error message to the

Line 338: 'cn.plsql.cn_api.chk_null_num_para.error',

334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
335: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
336: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
337: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
338: 'cn.plsql.cn_api.chk_null_num_para.error',
339: true);
340: end if;
341:
342: -- Error, check the msg level and add an error message to the

Line 374: 'cn.plsql.cn_api.chk_null_char_para.error',

370: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
371: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
372: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
373: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
374: 'cn.plsql.cn_api.chk_null_char_para.error',
375: true);
376: end if;
377:
378: -- Error, check the msg level and add an error message to the

Line 410: 'cn.plsql.cn_api.chk_null_date_para.error',

406: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
407: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
408: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
409: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
410: 'cn.plsql.cn_api.chk_null_date_para.error',
411: true);
412: end if;
413:
414: -- Error, check the msg level and add an error message to the

Line 446: 'cn.plsql.cn_api.chk_miss_null_num_para.error',

442: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
443: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
444: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
445: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
446: 'cn.plsql.cn_api.chk_miss_null_num_para.error',
447: true);
448: end if;
449:
450: -- Error, check the msg level and add an error message to the

Line 482: 'cn.plsql.cn_api.chk_miss_null_char_para.error',

478: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
479: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
480: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
481: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
482: 'cn.plsql.cn_api.chk_miss_null_char_para.error',
483: true);
484: end if;
485:
486: -- Error, check the msg level and add an error message to the

Line 518: 'cn.plsql.cn_api.chk_miss_null_date_para.error',

514: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
515: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
516: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
517: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
518: 'cn.plsql.cn_api.chk_miss_null_date_para.error',
519: true);
520: end if;
521:
522: -- Error, check the msg level and add an error message to the

Line 564: 'cn.plsql.cn_api.pe_num_field_must_null.error',

560: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
561: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
562: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
563: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
564: 'cn.plsql.cn_api.pe_num_field_must_null.error',
565: true);
566: end if;
567:
568: -- Error, check the msg level and add an error message to the

Line 616: 'cn.plsql.cn_api.pe_char_field_must_null.error',

612: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
613:
614: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
615: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
616: 'cn.plsql.cn_api.pe_char_field_must_null.error',
617: true);
618: end if;
619:
620: -- Error, check the msg level and add an error message to the

Line 668: 'cn.plsql.cn_api.pe_num_field_cannot_null.error',

664: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
665:
666: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
667: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
668: 'cn.plsql.cn_api.pe_num_field_cannot_null.error',
669: true);
670: end if;
671:
672: -- Error, check the msg level and add an error message to the

Line 720: 'cn.plsql.cn_api.pe_char_field_cannot_null.error',

716: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
717:
718: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
719: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
720: 'cn.plsql.cn_api.pe_char_field_cannot_null.error',
721: true);
722: end if;
723:
724: -- Error, check the msg level and add an error message to the

Line 1021: IF cn_api.date_range_overlap

1017: l_counter NUMBER :=0;
1018:
1019: BEGIN
1020:
1021: IF cn_api.date_range_overlap
1022: (start_date_new,
1023: end_date_new,
1024: start_date_old,
1025: end_date_old) THEN

Line 1268: l_role_id := cn_api.get_role_id(p_role_name);

1264: l_loading_status VARCHAR2(2000);
1265:
1266: BEGIN
1267:
1268: l_role_id := cn_api.get_role_id(p_role_name);
1269: chk_and_get_salesrep_id
1270: (p_emp_num ,
1271: p_type,
1272: p_org_id,

Line 1321: l_role_id := cn_api.get_role_id(p_role_name);

1317: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE;
1318:
1319: BEGIN
1320:
1321: l_role_id := cn_api.get_role_id(p_role_name);
1322: l_comp_plan_id := cn_api.get_cp_id(p_comp_plan_name, p_org_id);
1323:
1324: OPEN l_cur(l_role_id, l_comp_plan_id, p_start_date, p_end_date);
1325: FETCH l_cur INTO l_rec;

Line 1322: l_comp_plan_id := cn_api.get_cp_id(p_comp_plan_name, p_org_id);

1318:
1319: BEGIN
1320:
1321: l_role_id := cn_api.get_role_id(p_role_name);
1322: l_comp_plan_id := cn_api.get_cp_id(p_comp_plan_name, p_org_id);
1323:
1324: OPEN l_cur(l_role_id, l_comp_plan_id, p_start_date, p_end_date);
1325: FETCH l_cur INTO l_rec;
1326: IF (l_cur%notfound) THEN

Line 1367: l_role_id := cn_api.get_role_id(p_role_name);

1363: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE;
1364:
1365: BEGIN
1366:
1367: l_role_id := cn_api.get_role_id(p_role_name);
1368: l_pmt_plan_id := cn_api.get_pp_id(p_pmt_plan_name, p_org_id);
1369:
1370: OPEN l_cur(l_role_id, l_pmt_plan_id, p_start_date, p_end_date);
1371: FETCH l_cur INTO l_rec;

Line 1368: l_pmt_plan_id := cn_api.get_pp_id(p_pmt_plan_name, p_org_id);

1364:
1365: BEGIN
1366:
1367: l_role_id := cn_api.get_role_id(p_role_name);
1368: l_pmt_plan_id := cn_api.get_pp_id(p_pmt_plan_name, p_org_id);
1369:
1370: OPEN l_cur(l_role_id, l_pmt_plan_id, p_start_date, p_end_date);
1371: FETCH l_cur INTO l_rec;
1372: IF (l_cur%notfound) THEN

Line 1599: IF cn_api.date_range_overlap( a_start_date, a_end_date,

1595:
1596: l_counter NUMBER := 0;
1597: BEGIN
1598:
1599: IF cn_api.date_range_overlap( a_start_date, a_end_date,
1600: b_start_date, b_end_date )
1601: THEN -- there is overlap
1602: -- first, check the start dates
1603: IF a_start_date> b_start_date THEN

Line 1718: IF cn_api.date_range_overlap( a_start_date, a_end_date,

1714: WHERE period_status IN ('F', 'O')
1715: AND org_id = p_org_id;
1716:
1717: BEGIN
1718: IF cn_api.date_range_overlap( a_start_date, a_end_date,
1719: b_start_date, b_end_date )
1720: THEN -- there is overlap
1721: -- first, check the start dates
1722: IF a_start_date> b_start_date THEN

Line 3141: END CN_API;

3137: WHEN others THEN
3138: RETURN 'Error';
3139: END get_role_name_2;
3140:
3141: END CN_API;