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 419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

415: END IF;
416:
417: -- role_name must exist in cn_roles
418: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
420: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
421: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
422: fnd_msg_pub.ADD;
423: END IF;

Line 422: fnd_msg_pub.ADD;

418: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
420: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
421: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
422: fnd_msg_pub.ADD;
423: END IF;
424: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
425: RAISE fnd_api.g_exc_error;
426: ELSE

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

427: x_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
428: END IF;
429: -- pay_group_name must exist in cn_pay_groups
430: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
431: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
432: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
433: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
434: fnd_msg_pub.ADD;
435: END IF;

Line 434: fnd_msg_pub.ADD;

430: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
431: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
432: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
433: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
434: fnd_msg_pub.ADD;
435: END IF;
436: x_loading_status := 'CN_RL_ASGN_PG_NOT_EXIST';
437: RAISE fnd_api.g_exc_error;
438: ELSE

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

452:
453: IF l_count <> 0
454: THEN
455: --Error condition
456: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
457: THEN
458: fnd_message.set_name('CN', 'CN_INVALID_ROLE_PGRP_ASGN_DT');
459: fnd_msg_pub.add;
460: END IF;

Line 459: fnd_msg_pub.add;

455: --Error condition
456: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
457: THEN
458: fnd_message.set_name('CN', 'CN_INVALID_ROLE_PGRP_ASGN_DT');
459: fnd_msg_pub.add;
460: END IF;
461:
462: x_loading_status := 'CN_INVALID_ROLE_PGRP_ASGN_DT';
463: RAISE FND_API.G_EXC_ERROR;

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

484:
485: /* IF l_count <> 0
486: THEN
487: --Error condition
488: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
489: THEN
490: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
491: fnd_msg_pub.add;
492: END IF; */

Line 491: fnd_msg_pub.add;

487: --Error condition
488: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
489: THEN
490: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
491: fnd_msg_pub.add;
492: END IF; */
493:
494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
495: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');

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

490: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
491: fnd_msg_pub.add;
492: END IF; */
493:
494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
495: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
496: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
497: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);

Line 503: fnd_msg_pub.ADD;

499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
500: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
501: fnd_message.set_token('START_DATE',l_rec.start_date);
502: fnd_message.set_token('END_DATE',l_rec.end_date);
503: fnd_msg_pub.ADD;
504: END IF;
505:
506: x_loading_status := 'CN_RL_ROLE_PAY_GROUP_OVERLAP';
507:

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

524:
525: IF l_count <> 0
526: THEN
527: --Error condition
528: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
529: THEN
530: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
531: fnd_msg_pub.add;
532: END IF;

Line 531: fnd_msg_pub.add;

527: --Error condition
528: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
529: THEN
530: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
531: fnd_msg_pub.add;
532: END IF;
533: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;

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

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

Line 551: fnd_msg_pub.add;

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

Line 560: FND_MSG_PUB.Count_And_Get

556: END IF; */
557:
558: --End of API body
559: -- Standard call to get message count and if count is 1, get message info.
560: FND_MSG_PUB.Count_And_Get
561: (
562: p_count => x_msg_count ,
563: p_data => x_msg_data ,
564: p_encoded => FND_API.G_FALSE

Line 570: FND_MSG_PUB.Count_And_Get

566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: FND_MSG_PUB.Count_And_Get
571: (
572: p_count => x_msg_count ,
573: p_data => x_msg_data ,
574: p_encoded => FND_API.G_FALSE

Line 579: FND_MSG_PUB.Count_And_Get

575: );
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
578: x_loading_status := 'UNEXPECTED_ERR';
579: FND_MSG_PUB.Count_And_Get
580: (
581: p_count => x_msg_count ,
582: p_data => x_msg_data ,
583: p_encoded => FND_API.G_FALSE

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

584: );
585: WHEN OTHERS THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587: x_loading_status := 'UNEXPECTED_ERR';
588: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
591: END IF;
592: FND_MSG_PUB.Count_And_Get

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

586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587: x_loading_status := 'UNEXPECTED_ERR';
588: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
591: END IF;
592: FND_MSG_PUB.Count_And_Get
593: (
594: p_count => x_msg_count ,

Line 592: FND_MSG_PUB.Count_And_Get

588: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
591: END IF;
592: FND_MSG_PUB.Count_And_Get
593: (
594: p_count => x_msg_count ,
595: p_data => x_msg_data ,
596: p_encoded => FND_API.G_FALSE

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

634: p_role_pay_groups_rec.start_date,
635: p_role_pay_groups_rec.end_date,
636: p_role_pay_groups_rec.org_id);
637: IF (x_role_pay_group_id IS NULL) THEN
638: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
639: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
640: FND_MSG_PUB.Add;
641: END IF;
642: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';

Line 640: FND_MSG_PUB.Add;

636: p_role_pay_groups_rec.org_id);
637: IF (x_role_pay_group_id IS NULL) THEN
638: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
639: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
640: FND_MSG_PUB.Add;
641: END IF;
642: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';
643: RAISE FND_API.G_EXC_ERROR ;
644: END IF;

Line 652: FND_MSG_PUB.Count_And_Get

648: -- End of API body.
649:
650: -- Standard call to get message count and if count is 1, get message info.
651:
652: FND_MSG_PUB.Count_And_Get
653: (
654: p_count => x_msg_count ,
655: p_data => x_msg_data ,
656: p_encoded => FND_API.G_FALSE

Line 662: FND_MSG_PUB.Count_And_Get

658:
659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN
661: x_return_status := FND_API.G_RET_STS_ERROR ;
662: FND_MSG_PUB.Count_And_Get
663: (
664: p_count => x_msg_count ,
665: p_data => x_msg_data ,
666: p_encoded => FND_API.G_FALSE

Line 671: FND_MSG_PUB.Count_And_Get

667: );
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: x_loading_status := 'UNEXPECTED_ERR';
671: FND_MSG_PUB.Count_And_Get
672: (
673: p_count => x_msg_count ,
674: p_data => x_msg_data ,
675: p_encoded => FND_API.G_FALSE

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

676: );
677: WHEN OTHERS THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: x_loading_status := 'UNEXPECTED_ERR';
680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
683: END IF;
684: FND_MSG_PUB.Count_And_Get

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

678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: x_loading_status := 'UNEXPECTED_ERR';
680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
683: END IF;
684: FND_MSG_PUB.Count_And_Get
685: (
686: p_count => x_msg_count ,

Line 684: FND_MSG_PUB.Count_And_Get

680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
683: END IF;
684: FND_MSG_PUB.Count_And_Get
685: (
686: p_count => x_msg_count ,
687: p_data => x_msg_data ,
688: p_encoded => FND_API.G_FALSE

Line 833: FND_MSG_PUB.initialize;

829: END IF;
830:
831: -- Initialize message list if p_init_msg_list is set to TRUE.
832: IF FND_API.to_Boolean( p_init_msg_list ) THEN
833: FND_MSG_PUB.initialize;
834: END IF;
835:
836: -- Initialize API return status to success
837: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1080: FND_MSG_PUB.Count_And_Get

1076:
1077:
1078: -- Standard call to get message count and if count is 1, get message info.
1079:
1080: FND_MSG_PUB.Count_And_Get
1081: (
1082: p_count => x_msg_count ,
1083: p_data => x_msg_data ,
1084: p_encoded => FND_API.G_FALSE

Line 1091: FND_MSG_PUB.Count_And_Get

1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: ROLLBACK TO Create_Role_Pay_Groups;
1090: x_return_status := FND_API.G_RET_STS_ERROR ;
1091: FND_MSG_PUB.Count_And_Get
1092: (
1093: p_count => x_msg_count ,
1094: p_data => x_msg_data ,
1095: p_encoded => FND_API.G_FALSE

Line 1101: FND_MSG_PUB.Count_And_Get

1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO Create_Role_Pay_Groups;
1099: x_loading_status := 'UNEXPECTED_ERR';
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: FND_MSG_PUB.Count_And_Get
1102: (
1103: p_count => x_msg_count ,
1104: p_data => x_msg_data ,
1105: p_encoded => FND_API.G_FALSE

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

1107: WHEN OTHERS THEN
1108: ROLLBACK TO Create_Role_Pay_Groups;
1109: x_loading_status := 'UNEXPECTED_ERR';
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1112: THEN
1113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1114: END IF;
1115: FND_MSG_PUB.Count_And_Get

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

1109: x_loading_status := 'UNEXPECTED_ERR';
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1112: THEN
1113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1114: END IF;
1115: FND_MSG_PUB.Count_And_Get
1116: (
1117: p_count => x_msg_count ,

Line 1115: FND_MSG_PUB.Count_And_Get

1111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1112: THEN
1113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1114: END IF;
1115: FND_MSG_PUB.Count_And_Get
1116: (
1117: p_count => x_msg_count ,
1118: p_data => x_msg_data ,
1119: p_encoded => FND_API.G_FALSE

Line 1213: FND_MSG_PUB.initialize;

1209: END IF;
1210:
1211: -- Initialize message list if p_init_msg_list is set to TRUE.
1212: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1213: FND_MSG_PUB.initialize;
1214: END IF;
1215:
1216: -- Initialize API return status to success
1217: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1412: FND_MSG_PUB.Count_And_Get

1408:
1409:
1410: -- Standard call to get message count and if count is 1, get message info.
1411:
1412: FND_MSG_PUB.Count_And_Get
1413: (
1414: p_count => x_msg_count ,
1415: p_data => x_msg_data ,
1416: p_encoded => FND_API.G_FALSE

Line 1423: FND_MSG_PUB.Count_And_Get

1419: EXCEPTION
1420: WHEN FND_API.G_EXC_ERROR THEN
1421: ROLLBACK TO Delete_Role_Pay_Groups;
1422: x_return_status := FND_API.G_RET_STS_ERROR ;
1423: FND_MSG_PUB.Count_And_Get
1424:
1425:
1426: (
1427: p_count => x_msg_count ,

Line 1435: FND_MSG_PUB.Count_And_Get

1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO Delete_Role_Pay_Groups;
1433: x_loading_status := 'UNEXPECTED_ERR';
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1435: FND_MSG_PUB.Count_And_Get
1436: (
1437: p_count => x_msg_count ,
1438: p_data => x_msg_data ,
1439: p_encoded => FND_API.G_FALSE

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

1441: WHEN OTHERS THEN
1442: ROLLBACK TO Delete_Role_Pay_Groups;
1443: x_loading_status := 'UNEXPECTED_ERR';
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1446: THEN
1447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1448: END IF;
1449: FND_MSG_PUB.Count_And_Get

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

1443: x_loading_status := 'UNEXPECTED_ERR';
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1446: THEN
1447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1448: END IF;
1449: FND_MSG_PUB.Count_And_Get
1450: (
1451: p_count => x_msg_count ,

Line 1449: FND_MSG_PUB.Count_And_Get

1445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1446: THEN
1447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1448: END IF;
1449: FND_MSG_PUB.Count_And_Get
1450: (
1451: p_count => x_msg_count ,
1452: p_data => x_msg_data ,
1453: p_encoded => FND_API.G_FALSE