APPS.CN_SRP_PLAN_ASSIGNS_PVT dependencies on FND_MESSAGE

Line 49: FND_MESSAGE.SET_NAME ('CN' , 'CN_ROLE_PLAN_ID_NOT_EXIST');

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';
53: RAISE FND_API.G_EXC_ERROR ;

Line 70: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_ROLE_ID_NOT_EXIST');

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';
74: RAISE FND_API.G_EXC_ERROR ;

Line 84: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPA_ROLE_ID_NOT_SAME');

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';
88: RAISE FND_API.G_EXC_ERROR ;

Line 130: FND_MESSAGE.Set_Name('CN', 'CN_PAY_GROUP_NOT_FOUND');

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;
134: x_loading_status := 'CN_PAY_GROUP_NOT_FOUND';

Line 131: FND_MESSAGE.SET_TOKEN('PAY_GROUP_ID', l_pay_group_id);

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;
134: x_loading_status := 'CN_PAY_GROUP_NOT_FOUND';
135: RAISE FND_API.G_EXC_ERROR ;

Line 194: FND_MESSAGE.Set_Name('CN', 'SRP_PLAN_ASSIGNED');

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';
198: RAISE FND_API.G_EXC_ERROR ;

Line 767: -- FND_MESSAGE.Set_Name('CN', 'CN_SRP_PLAN_ASSIGNS_NOT_EXIST');

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';
771: -- RAISE FND_API.G_EXC_ERROR ;