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

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

44: FROM cn_role_plans
45: WHERE role_plan_id = p_role_plan_id;
46: EXCEPTION
47: WHEN NO_DATA_FOUND THEN
48: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
49: FND_MESSAGE.SET_NAME ('CN' , 'CN_ROLE_PLAN_ID_NOT_EXIST');
50: FND_MSG_PUB.Add;
51: END IF;
52: x_loading_status := 'CN_ROLE_PLAN_ID_NOT_EXIST';

Line 50: FND_MSG_PUB.Add;

46: EXCEPTION
47: WHEN NO_DATA_FOUND THEN
48: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
49: FND_MESSAGE.SET_NAME ('CN' , 'CN_ROLE_PLAN_ID_NOT_EXIST');
50: FND_MSG_PUB.Add;
51: END IF;
52: x_loading_status := 'CN_ROLE_PLAN_ID_NOT_EXIST';
53: RAISE FND_API.G_EXC_ERROR ;
54: END;

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

65: WHERE srp_role_id = p_srp_role_id
66: AND org_id = l_role_plans_row.org_id; --MOAC
67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN
69: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
70: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_ROLE_ID_NOT_EXIST');
71: FND_MSG_PUB.Add;
72: END IF;
73: x_loading_status := 'CN_SRP_ROLE_ID_NOT_EXIST';

Line 71: FND_MSG_PUB.Add;

67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN
69: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
70: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_ROLE_ID_NOT_EXIST');
71: FND_MSG_PUB.Add;
72: END IF;
73: x_loading_status := 'CN_SRP_ROLE_ID_NOT_EXIST';
74: RAISE FND_API.G_EXC_ERROR ;
75: END;

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

79:
80:
81: -- Check if pased in role_plan_id and srp_role_id are use the same role
82: IF l_role_plans_row.role_id <> l_srp_roles_row.role_id THEN
83: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
84: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPA_ROLE_ID_NOT_SAME');
85: FND_MSG_PUB.Add;
86: END IF;
87: x_loading_status := 'CN_SPA_ROLE_ID_NOT_SAME';

Line 85: FND_MSG_PUB.Add;

81: -- Check if pased in role_plan_id and srp_role_id are use the same role
82: IF l_role_plans_row.role_id <> l_srp_roles_row.role_id THEN
83: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
84: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPA_ROLE_ID_NOT_SAME');
85: FND_MSG_PUB.Add;
86: END IF;
87: x_loading_status := 'CN_SPA_ROLE_ID_NOT_SAME';
88: RAISE FND_API.G_EXC_ERROR ;
89: END IF;

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

125: AND spg.org_id = x_srp_plan_assigns_row.org_id -- MOAC
126: AND spg.start_date = l_spg_max_sd;
127: EXCEPTION
128: WHEN no_data_found THEN
129: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
130: FND_MESSAGE.Set_Name('CN', 'CN_PAY_GROUP_NOT_FOUND');
131: FND_MESSAGE.SET_TOKEN('PAY_GROUP_ID', l_pay_group_id);
132: FND_MSG_PUB.Add;
133: END IF;

Line 132: FND_MSG_PUB.Add;

128: WHEN no_data_found THEN
129: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
130: FND_MESSAGE.Set_Name('CN', 'CN_PAY_GROUP_NOT_FOUND');
131: FND_MESSAGE.SET_TOKEN('PAY_GROUP_ID', l_pay_group_id);
132: FND_MSG_PUB.Add;
133: END IF;
134: x_loading_status := 'CN_PAY_GROUP_NOT_FOUND';
135: RAISE FND_API.G_EXC_ERROR ;
136: END;

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

189: AND srp_role_id = p_srp_role_id);
190: END IF ;
191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN
193: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
194: FND_MESSAGE.Set_Name('CN', 'SRP_PLAN_ASSIGNED');
195: FND_MSG_PUB.Add;
196: END IF;
197: x_loading_status := 'SRP_PLAN_ASSIGNED';

Line 195: FND_MSG_PUB.Add;

191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN
193: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
194: FND_MESSAGE.Set_Name('CN', 'SRP_PLAN_ASSIGNED');
195: FND_MSG_PUB.Add;
196: END IF;
197: x_loading_status := 'SRP_PLAN_ASSIGNED';
198: RAISE FND_API.G_EXC_ERROR ;
199: END;

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

208: x_loading_status := 'UNEXPECTED_ERR';
209: WHEN OTHERS THEN
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211: x_loading_status := 'UNEXPECTED_ERR';
212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
213: THEN
214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
215: END IF;
216: END valid_srp_plan_assign;

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

210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211: x_loading_status := 'UNEXPECTED_ERR';
212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
213: THEN
214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
215: END IF;
216: END valid_srp_plan_assign;
217:
218: PROCEDURE business_event

Line 308: FND_MSG_PUB.initialize;

304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306: -- Initialize message list if p_init_msg_list is set to TRUE.
307: IF FND_API.to_Boolean( p_init_msg_list ) THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310: -- Initialize API return status to success
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312: x_loading_status := 'CN_INSERTED';

Line 433: FND_MSG_PUB.Count_And_Get

429: IF FND_API.To_Boolean( p_commit ) THEN
430: COMMIT WORK;
431: END IF;
432: -- Standard call to get message count and if count is 1, get message info.
433: FND_MSG_PUB.Count_And_Get
434: (
435: p_count => x_msg_count ,
436: p_data => x_msg_data ,
437: p_encoded => FND_API.G_FALSE

Line 444: FND_MSG_PUB.Count_And_Get

440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO Create_Srp_Plan_Assigns;
443: x_return_status := FND_API.G_RET_STS_ERROR ;
444: FND_MSG_PUB.Count_And_Get
445: (
446: p_count => x_msg_count ,
447: p_data => x_msg_data ,
448: p_encoded => FND_API.G_FALSE

Line 454: FND_MSG_PUB.Count_And_Get

450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: ROLLBACK TO Create_Srp_Plan_Assigns;
452: x_loading_status := 'UNEXPECTED_ERR';
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
454: FND_MSG_PUB.Count_And_Get
455: (
456: p_count => x_msg_count ,
457: p_data => x_msg_data ,
458: p_encoded => FND_API.G_FALSE

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

460: WHEN OTHERS THEN
461: ROLLBACK TO Create_Srp_Plan_Assigns;
462: x_loading_status := 'UNEXPECTED_ERR';
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
464: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
467: END IF;
468: FND_MSG_PUB.Count_And_Get

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

462: x_loading_status := 'UNEXPECTED_ERR';
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
464: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
467: END IF;
468: FND_MSG_PUB.Count_And_Get
469: (
470: p_count => x_msg_count ,

Line 468: FND_MSG_PUB.Count_And_Get

464: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
467: END IF;
468: FND_MSG_PUB.Count_And_Get
469: (
470: p_count => x_msg_count ,
471: p_data => x_msg_data ,
472: p_encoded => FND_API.G_FALSE

Line 527: FND_MSG_PUB.initialize;

523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: -- Initialize message list if p_init_msg_list is set to TRUE.
526: IF FND_API.to_Boolean( p_init_msg_list ) THEN
527: FND_MSG_PUB.initialize;
528: END IF;
529: -- Initialize API return status to success
530: x_return_status := FND_API.G_RET_STS_SUCCESS;
531: x_loading_status := 'CN_UPDATED';

Line 675: FND_MSG_PUB.Count_And_Get

671: IF FND_API.To_Boolean( p_commit ) THEN
672: COMMIT WORK;
673: END IF;
674: -- Standard call to get message count and if count is 1, get message info.
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 686: FND_MSG_PUB.Count_And_Get

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

Line 696: FND_MSG_PUB.Count_And_Get

692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
693: ROLLBACK TO Update_Srp_Plan_Assigns;
694: x_loading_status := 'UNEXPECTED_ERR';
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
696: FND_MSG_PUB.Count_And_Get
697: (
698: p_count => x_msg_count ,
699: p_data => x_msg_data ,
700: p_encoded => FND_API.G_FALSE

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

702: WHEN OTHERS THEN
703: ROLLBACK TO Update_Srp_Plan_Assigns;
704: x_loading_status := 'UNEXPECTED_ERR';
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
706: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
707: THEN
708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
709: END IF;
710: FND_MSG_PUB.Count_And_Get

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

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

Line 710: FND_MSG_PUB.Count_And_Get

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

Line 752: FND_MSG_PUB.initialize;

748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: END IF;
750: -- Initialize message list if p_init_msg_list is set to TRUE.
751: IF FND_API.to_Boolean( p_init_msg_list ) THEN
752: FND_MSG_PUB.initialize;
753: END IF;
754: -- Initialize API return status to success
755: x_return_status := FND_API.G_RET_STS_SUCCESS;
756: x_loading_status := 'CN_DELETED';

Line 766: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

762: WHERE srp_role_id = p_srp_role_id
763: AND role_plan_id = p_role_plan_id;
764: EXCEPTION
765: WHEN NO_DATA_FOUND THEN
766: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
767: -- FND_MESSAGE.Set_Name('CN', 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST');
768: -- FND_MSG_PUB.Add;
769: -- END IF;
770: -- x_loading_status := 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST';

Line 768: -- FND_MSG_PUB.Add;

764: EXCEPTION
765: WHEN NO_DATA_FOUND THEN
766: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
767: -- FND_MESSAGE.Set_Name('CN', 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST');
768: -- FND_MSG_PUB.Add;
769: -- END IF;
770: -- x_loading_status := 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST';
771: -- RAISE FND_API.G_EXC_ERROR ;
772:

Line 792: FND_MSG_PUB.Count_And_Get

788: IF FND_API.To_Boolean( p_commit ) THEN
789: COMMIT WORK;
790: END IF;
791: -- Standard call to get message count and if count is 1, get message info.
792: FND_MSG_PUB.Count_And_Get
793: (
794: p_count => x_msg_count ,
795: p_data => x_msg_data ,
796: p_encoded => FND_API.G_FALSE

Line 803: FND_MSG_PUB.Count_And_Get

799: EXCEPTION
800: WHEN FND_API.G_EXC_ERROR THEN
801: ROLLBACK TO Delete_Srp_Plan_Assigns;
802: x_return_status := FND_API.G_RET_STS_ERROR ;
803: FND_MSG_PUB.Count_And_Get
804: (
805: p_count => x_msg_count ,
806: p_data => x_msg_data ,
807: p_encoded => FND_API.G_FALSE

Line 813: FND_MSG_PUB.Count_And_Get

809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
810: ROLLBACK TO Delete_Srp_Plan_Assigns;
811: x_loading_status := 'UNEXPECTED_ERR';
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
813: FND_MSG_PUB.Count_And_Get
814: (
815: p_count => x_msg_count ,
816: p_data => x_msg_data ,
817: p_encoded => FND_API.G_FALSE

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

819: WHEN OTHERS THEN
820: ROLLBACK TO Delete_Srp_Plan_Assigns;
821: x_loading_status := 'UNEXPECTED_ERR';
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
823: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
824: THEN
825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
826: END IF;
827: FND_MSG_PUB.Count_And_Get

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

821: x_loading_status := 'UNEXPECTED_ERR';
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
823: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
824: THEN
825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
826: END IF;
827: FND_MSG_PUB.Count_And_Get
828: (
829: p_count => x_msg_count ,

Line 827: FND_MSG_PUB.Count_And_Get

823: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
824: THEN
825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
826: END IF;
827: FND_MSG_PUB.Count_And_Get
828: (
829: p_count => x_msg_count ,
830: p_data => x_msg_data ,
831: p_encoded => FND_API.G_FALSE