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_PAY_GROUPS_PVT dependencies on FND_MSG_PUB

Line 116: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

112:
113: --IF the sales rep start date is outside the range for the pay group which has the role of this sales rep. Raise Error
114: IF(l_start_date is NULL)
115: THEN
116: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
117: SELECT role_name into l_role_name
118: FROM jtf_rs_roles_tl
119: WHERE role_id =
120: (SELECT role_id

Line 128: fnd_msg_pub.ADD;

124: AND language = USERENV('LANG');
125: fnd_message.set_name('CN', 'CN_SRP_OUTSIDE_PAYGRP_DATE');
126: FND_MESSAGE.SET_TOKEN('SALES_REP_NAME', l_salesrep_name);
127: FND_MESSAGE.SET_TOKEN('ROLE_NAME', l_role_name);
128: fnd_msg_pub.ADD;
129: END IF;
130: RAISE FND_API.G_EXC_ERROR ;
131: END IF;
132:

Line 442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

438: END IF;
439:
440: -- role_name must exist in cn_roles
441: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
443: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
444: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
445: fnd_msg_pub.ADD;
446: END IF;

Line 445: fnd_msg_pub.ADD;

441: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
443: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
444: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
445: fnd_msg_pub.ADD;
446: END IF;
447: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
448: RAISE fnd_api.g_exc_error;
449: ELSE

Line 454: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

450: x_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
451: END IF;
452: -- pay_group_name must exist in cn_pay_groups
453: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
454: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
455: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
456: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
457: fnd_msg_pub.ADD;
458: END IF;

Line 457: fnd_msg_pub.ADD;

453: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
454: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
455: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
456: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
457: fnd_msg_pub.ADD;
458: END IF;
459: x_loading_status := 'CN_RL_ASGN_PG_NOT_EXIST';
460: RAISE fnd_api.g_exc_error;
461: ELSE

Line 479: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

475:
476: IF l_count <> 0
477: THEN
478: --Error condition
479: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
480: THEN
481: fnd_message.set_name('CN', 'CN_INVALID_ROLE_PGRP_ASGN_DT');
482: fnd_msg_pub.add;
483: END IF;

Line 482: fnd_msg_pub.add;

478: --Error condition
479: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
480: THEN
481: fnd_message.set_name('CN', 'CN_INVALID_ROLE_PGRP_ASGN_DT');
482: fnd_msg_pub.add;
483: END IF;
484:
485: x_loading_status := 'CN_INVALID_ROLE_PGRP_ASGN_DT';
486: RAISE FND_API.G_EXC_ERROR;

Line 511: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

507:
508: /* IF l_count <> 0
509: THEN
510: --Error condition
511: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
512: THEN
513: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
514: fnd_msg_pub.add;
515: END IF; */

Line 514: fnd_msg_pub.add;

510: --Error condition
511: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
512: THEN
513: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
514: fnd_msg_pub.add;
515: END IF; */
516:
517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
518: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');

Line 517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

513: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
514: fnd_msg_pub.add;
515: END IF; */
516:
517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
518: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
519: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
520: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
521: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);

Line 526: fnd_msg_pub.ADD;

522: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
523: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
524: fnd_message.set_token('START_DATE',l_rec.start_date);
525: fnd_message.set_token('END_DATE',l_rec.end_date);
526: fnd_msg_pub.ADD;
527: END IF;
528:
529: x_loading_status := 'CN_RL_ROLE_PAY_GROUP_OVERLAP';
530:

Line 551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

547:
548: IF l_count <> 0
549: THEN
550: --Error condition
551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
552: THEN
553: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
554: fnd_msg_pub.add;
555: END IF;

Line 554: fnd_msg_pub.add;

550: --Error condition
551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
552: THEN
553: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
554: fnd_msg_pub.add;
555: END IF;
556: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;

Line 571: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

567:
568: IF l_count <> 0
569: THEN
570: --Error condition
571: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
572: THEN
573: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
574: fnd_msg_pub.add;
575: END IF;

Line 574: fnd_msg_pub.add;

570: --Error condition
571: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
572: THEN
573: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
574: fnd_msg_pub.add;
575: END IF;
576:
577: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
578: RAISE FND_API.G_EXC_ERROR;

Line 583: FND_MSG_PUB.Count_And_Get

579: END IF; */
580:
581: --End of API body
582: -- Standard call to get message count and if count is 1, get message info.
583: FND_MSG_PUB.Count_And_Get
584: (
585: p_count => x_msg_count ,
586: p_data => x_msg_data ,
587: p_encoded => FND_API.G_FALSE

Line 593: FND_MSG_PUB.Count_And_Get

589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: x_return_status := FND_API.G_RET_STS_ERROR ;
593: FND_MSG_PUB.Count_And_Get
594: (
595: p_count => x_msg_count ,
596: p_data => x_msg_data ,
597: p_encoded => FND_API.G_FALSE

Line 602: FND_MSG_PUB.Count_And_Get

598: );
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
601: x_loading_status := 'UNEXPECTED_ERR';
602: FND_MSG_PUB.Count_And_Get
603: (
604: p_count => x_msg_count ,
605: p_data => x_msg_data ,
606: p_encoded => FND_API.G_FALSE

Line 611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

607: );
608: WHEN OTHERS THEN
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: x_loading_status := 'UNEXPECTED_ERR';
611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
612: THEN
613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
614: END IF;
615: FND_MSG_PUB.Count_And_Get

Line 613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: x_loading_status := 'UNEXPECTED_ERR';
611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
612: THEN
613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
614: END IF;
615: FND_MSG_PUB.Count_And_Get
616: (
617: p_count => x_msg_count ,

Line 615: FND_MSG_PUB.Count_And_Get

611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
612: THEN
613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
614: END IF;
615: FND_MSG_PUB.Count_And_Get
616: (
617: p_count => x_msg_count ,
618: p_data => x_msg_data ,
619: p_encoded => FND_API.G_FALSE

Line 661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

657: p_role_pay_groups_rec.start_date,
658: p_role_pay_groups_rec.end_date,
659: p_role_pay_groups_rec.org_id);
660: IF (x_role_pay_group_id IS NULL) THEN
661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
662: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
663: FND_MSG_PUB.Add;
664: END IF;
665: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';

Line 663: FND_MSG_PUB.Add;

659: p_role_pay_groups_rec.org_id);
660: IF (x_role_pay_group_id IS NULL) THEN
661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
662: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
663: FND_MSG_PUB.Add;
664: END IF;
665: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';
666: RAISE FND_API.G_EXC_ERROR ;
667: END IF;

Line 675: FND_MSG_PUB.Count_And_Get

671: -- End of API body.
672:
673: -- Standard call to get message count and if count is 1, get message info.
674:
675: FND_MSG_PUB.Count_And_Get
676: (
677: p_count => x_msg_count ,
678: p_data => x_msg_data ,
679: p_encoded => FND_API.G_FALSE

Line 685: FND_MSG_PUB.Count_And_Get

681:
682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR THEN
684: x_return_status := FND_API.G_RET_STS_ERROR ;
685: FND_MSG_PUB.Count_And_Get
686: (
687: p_count => x_msg_count ,
688: p_data => x_msg_data ,
689: p_encoded => FND_API.G_FALSE

Line 694: FND_MSG_PUB.Count_And_Get

690: );
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693: x_loading_status := 'UNEXPECTED_ERR';
694: FND_MSG_PUB.Count_And_Get
695: (
696: p_count => x_msg_count ,
697: p_data => x_msg_data ,
698: p_encoded => FND_API.G_FALSE

Line 703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

699: );
700: WHEN OTHERS THEN
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
702: x_loading_status := 'UNEXPECTED_ERR';
703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
706: END IF;
707: FND_MSG_PUB.Count_And_Get

Line 705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
702: x_loading_status := 'UNEXPECTED_ERR';
703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
706: END IF;
707: FND_MSG_PUB.Count_And_Get
708: (
709: p_count => x_msg_count ,

Line 707: FND_MSG_PUB.Count_And_Get

703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
706: END IF;
707: FND_MSG_PUB.Count_And_Get
708: (
709: p_count => x_msg_count ,
710: p_data => x_msg_data ,
711: p_encoded => FND_API.G_FALSE

Line 883: FND_MSG_PUB.initialize;

879: END IF;
880:
881: -- Initialize message list if p_init_msg_list is set to TRUE.
882: IF FND_API.to_Boolean( p_init_msg_list ) THEN
883: FND_MSG_PUB.initialize;
884: END IF;
885:
886: -- Initialize API return status to success
887: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1130: FND_MSG_PUB.Count_And_Get

1126:
1127:
1128: -- Standard call to get message count and if count is 1, get message info.
1129:
1130: FND_MSG_PUB.Count_And_Get
1131: (
1132: p_count => x_msg_count ,
1133: p_data => x_msg_data ,
1134: p_encoded => FND_API.G_FALSE

Line 1141: FND_MSG_PUB.Count_And_Get

1137: EXCEPTION
1138: WHEN FND_API.G_EXC_ERROR THEN
1139: ROLLBACK TO Create_Role_Pay_Groups;
1140: x_return_status := FND_API.G_RET_STS_ERROR ;
1141: FND_MSG_PUB.Count_And_Get
1142: (
1143: p_count => x_msg_count ,
1144: p_data => x_msg_data ,
1145: p_encoded => FND_API.G_FALSE

Line 1151: FND_MSG_PUB.Count_And_Get

1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1148: ROLLBACK TO Create_Role_Pay_Groups;
1149: x_loading_status := 'UNEXPECTED_ERR';
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151: FND_MSG_PUB.Count_And_Get
1152: (
1153: p_count => x_msg_count ,
1154: p_data => x_msg_data ,
1155: p_encoded => FND_API.G_FALSE

Line 1161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1157: WHEN OTHERS THEN
1158: ROLLBACK TO Create_Role_Pay_Groups;
1159: x_loading_status := 'UNEXPECTED_ERR';
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1162: THEN
1163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1164: END IF;
1165: FND_MSG_PUB.Count_And_Get

Line 1163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1159: x_loading_status := 'UNEXPECTED_ERR';
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1162: THEN
1163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1164: END IF;
1165: FND_MSG_PUB.Count_And_Get
1166: (
1167: p_count => x_msg_count ,

Line 1165: FND_MSG_PUB.Count_And_Get

1161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1162: THEN
1163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1164: END IF;
1165: FND_MSG_PUB.Count_And_Get
1166: (
1167: p_count => x_msg_count ,
1168: p_data => x_msg_data ,
1169: p_encoded => FND_API.G_FALSE

Line 1263: FND_MSG_PUB.initialize;

1259: END IF;
1260:
1261: -- Initialize message list if p_init_msg_list is set to TRUE.
1262: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1263: FND_MSG_PUB.initialize;
1264: END IF;
1265:
1266: -- Initialize API return status to success
1267: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1462: FND_MSG_PUB.Count_And_Get

1458:
1459:
1460: -- Standard call to get message count and if count is 1, get message info.
1461:
1462: FND_MSG_PUB.Count_And_Get
1463: (
1464: p_count => x_msg_count ,
1465: p_data => x_msg_data ,
1466: p_encoded => FND_API.G_FALSE

Line 1473: FND_MSG_PUB.Count_And_Get

1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: ROLLBACK TO Delete_Role_Pay_Groups;
1472: x_return_status := FND_API.G_RET_STS_ERROR ;
1473: FND_MSG_PUB.Count_And_Get
1474:
1475:
1476: (
1477: p_count => x_msg_count ,

Line 1485: FND_MSG_PUB.Count_And_Get

1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1482: ROLLBACK TO Delete_Role_Pay_Groups;
1483: x_loading_status := 'UNEXPECTED_ERR';
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1485: FND_MSG_PUB.Count_And_Get
1486: (
1487: p_count => x_msg_count ,
1488: p_data => x_msg_data ,
1489: p_encoded => FND_API.G_FALSE

Line 1495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1491: WHEN OTHERS THEN
1492: ROLLBACK TO Delete_Role_Pay_Groups;
1493: x_loading_status := 'UNEXPECTED_ERR';
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1496: THEN
1497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1498: END IF;
1499: FND_MSG_PUB.Count_And_Get

Line 1497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1493: x_loading_status := 'UNEXPECTED_ERR';
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1496: THEN
1497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1498: END IF;
1499: FND_MSG_PUB.Count_And_Get
1500: (
1501: p_count => x_msg_count ,

Line 1499: FND_MSG_PUB.Count_And_Get

1495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1496: THEN
1497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1498: END IF;
1499: FND_MSG_PUB.Count_And_Get
1500: (
1501: p_count => x_msg_count ,
1502: p_data => x_msg_data ,
1503: p_encoded => FND_API.G_FALSE