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.24 2011/09/09 01:00:15 rnagaraj ship $ */
3:
4:
5:

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

242: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
243: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
244: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
245: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
246: 'cn.plsql.cn_api.chk_miss_char_para.error',
247: true);
248: end if;
249:
250: -- Error, check the msg level and add an error message to the

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

280: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
281: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
282: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
283: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
284: 'cn.plsql.cn_api.chk_miss_num_para.error',
285: true);
286: end if;
287:
288: -- Error, check the msg level and add an error message to the

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

318: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
319: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
320: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
321: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
322: 'cn.plsql.cn_api.chk_miss_date_para.error',
323: true);
324: end if;
325:
326: -- Error, check the msg level and add an error message to the

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

356: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
357: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
358: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
359: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
360: 'cn.plsql.cn_api.chk_null_num_para.error',
361: true);
362: end if;
363:
364: -- Error, check the msg level and add an error message to the

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

392: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
393: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
394: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
395: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
396: 'cn.plsql.cn_api.chk_null_char_para.error',
397: true);
398: end if;
399:
400: -- Error, check the msg level and add an error message to the

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

428: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
429: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
430: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
431: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
432: 'cn.plsql.cn_api.chk_null_date_para.error',
433: true);
434: end if;
435:
436: -- Error, check the msg level and add an error message to the

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

464: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
465: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
466: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
467: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
468: 'cn.plsql.cn_api.chk_miss_null_num_para.error',
469: true);
470: end if;
471:
472: -- Error, check the msg level and add an error message to the

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

500: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
501: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
502: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
503: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
504: 'cn.plsql.cn_api.chk_miss_null_char_para.error',
505: true);
506: end if;
507:
508: -- Error, check the msg level and add an error message to the

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

536: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
537: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
538: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
539: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
540: 'cn.plsql.cn_api.chk_miss_null_date_para.error',
541: true);
542: end if;
543:
544: -- Error, check the msg level and add an error message to the

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

582: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
583: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
584: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
585: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
586: 'cn.plsql.cn_api.pe_num_field_must_null.error',
587: true);
588: end if;
589:
590: -- Error, check the msg level and add an error message to the

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

634: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
635:
636: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
637: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
638: 'cn.plsql.cn_api.pe_char_field_must_null.error',
639: true);
640: end if;
641:
642: -- Error, check the msg level and add an error message to the

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

686: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
687:
688: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
689: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
690: 'cn.plsql.cn_api.pe_num_field_cannot_null.error',
691: true);
692: end if;
693:
694: -- Error, check the msg level and add an error message to the

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

738: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
739:
740: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
741: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
742: 'cn.plsql.cn_api.pe_char_field_cannot_null.error',
743: true);
744: end if;
745:
746: -- Error, check the msg level and add an error message to the

Line 1043: IF cn_api.date_range_overlap

1039: l_counter NUMBER :=0;
1040:
1041: BEGIN
1042:
1043: IF cn_api.date_range_overlap
1044: (start_date_new,
1045: end_date_new,
1046: start_date_old,
1047: end_date_old) THEN

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

1286: l_loading_status VARCHAR2(2000);
1287:
1288: BEGIN
1289:
1290: l_role_id := cn_api.get_role_id(p_role_name);
1291: chk_and_get_salesrep_id
1292: (p_emp_num ,
1293: p_type,
1294: p_org_id,

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

1339: l_comp_plan_id cn_role_plans.comp_plan_id%TYPE;
1340:
1341: BEGIN
1342:
1343: l_role_id := cn_api.get_role_id(p_role_name);
1344: l_comp_plan_id := cn_api.get_cp_id(p_comp_plan_name, p_org_id);
1345:
1346: OPEN l_cur(l_role_id, l_comp_plan_id, p_start_date, p_end_date);
1347: FETCH l_cur INTO l_rec;

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

1340:
1341: BEGIN
1342:
1343: l_role_id := cn_api.get_role_id(p_role_name);
1344: l_comp_plan_id := cn_api.get_cp_id(p_comp_plan_name, p_org_id);
1345:
1346: OPEN l_cur(l_role_id, l_comp_plan_id, p_start_date, p_end_date);
1347: FETCH l_cur INTO l_rec;
1348: IF (l_cur%notfound) THEN

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

1385: l_pmt_plan_id cn_role_pmt_plans.pmt_plan_id%TYPE;
1386:
1387: BEGIN
1388:
1389: l_role_id := cn_api.get_role_id(p_role_name);
1390: l_pmt_plan_id := cn_api.get_pp_id(p_pmt_plan_name, p_org_id);
1391:
1392: OPEN l_cur(l_role_id, l_pmt_plan_id, p_start_date, p_end_date);
1393: FETCH l_cur INTO l_rec;

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

1386:
1387: BEGIN
1388:
1389: l_role_id := cn_api.get_role_id(p_role_name);
1390: l_pmt_plan_id := cn_api.get_pp_id(p_pmt_plan_name, p_org_id);
1391:
1392: OPEN l_cur(l_role_id, l_pmt_plan_id, p_start_date, p_end_date);
1393: FETCH l_cur INTO l_rec;
1394: IF (l_cur%notfound) THEN

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

1617:
1618: l_counter NUMBER := 0;
1619: BEGIN
1620:
1621: IF cn_api.date_range_overlap( a_start_date, a_end_date,
1622: b_start_date, b_end_date )
1623: THEN -- there is overlap
1624: -- first, check the start dates
1625: IF a_start_date> b_start_date THEN

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

1736: WHERE period_status IN ('F', 'O')
1737: AND org_id = p_org_id;
1738:
1739: BEGIN
1740: IF cn_api.date_range_overlap( a_start_date, a_end_date,
1741: b_start_date, b_end_date )
1742: THEN -- there is overlap
1743: -- first, check the start dates
1744: IF a_start_date> b_start_date THEN

Line 3461: END CN_API;

3457:
3458: end;
3459:
3460:
3461: END CN_API;