DBA Data[Home] [Help]

APPS.CN_SEAS_SCHEDULES_PVT dependencies on FND_MESSAGE

Line 94: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');

90: IF ( p_seas_schedules_rec_type.name is NULL ) OR
91: ( p_seas_schedules_rec_type.name = fnd_api.g_miss_char )
92: THEN
93: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
94: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
95: FND_MSG_PUB.Add;
96: END IF;
97: RAISE FND_API.G_EXC_ERROR ;
98: END IF;

Line 105: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');

101: IF ( p_seas_schedules_rec_type.DESCRIPTION is NULL ) OR
102: ( p_seas_schedules_rec_type.DESCRIPTION = fnd_api.g_miss_char )
103: THEN
104: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
105: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
106: FND_MSG_PUB.Add;
107: END IF;
108: RAISE FND_API.G_EXC_ERROR ;
109: END IF;

Line 116: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_NAME_EXISTS');

112: SELECT COUNT(*) INTO l_count FROM CN_SEAS_SCHEDULES WHERE UPPER(NAME) LIKE UPPER(p_seas_schedules_rec_type.name);
113: -- Insert
114: IF l_count > 0 THEN
115: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
116: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_NAME_EXISTS');
117: FND_MSG_PUB.Add;
118: END IF;
119: RAISE FND_API.G_EXC_ERROR ;
120: END IF;

Line 157: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_INTTYPE_NOTEXIST');

153: WHERE period_year = p_seas_schedules_rec_type.period_year and cp.period_id = ccpit.cal_period_id and interval_type_id = -1002;
154:
155: IF (l_cal_int_types = 0) THEN
156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
157: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_INTTYPE_NOTEXIST');
158: FND_MSG_PUB.Add;
159: END IF;
160: RAISE FND_API.G_EXC_ERROR ;
161: END IF;

Line 222: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');

218: IF l_error_code = -54 THEN
219: x_return_status := FND_API.G_RET_STS_ERROR ;
220: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
221: THEN
222: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
223: FND_MSG_PUB.Add;
224: END IF;
225: ELSE
226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 314: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEASONALITY_IN_USE');

310:
311:
312: IF (l_srp_count > 0) THEN
313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
314: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEASONALITY_IN_USE');
315: FND_MSG_PUB.Add;
316: END IF;
317: RAISE FND_API.G_EXC_ERROR ;
318: END IF;

Line 328: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');

324: IF ( p_seas_schedules_rec_type.name is NULL ) OR
325: ( p_seas_schedules_rec_type.name = fnd_api.g_miss_char )
326: THEN
327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
328: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
329: FND_MSG_PUB.Add;
330: END IF;
331: RAISE FND_API.G_EXC_ERROR ;
332: END IF;

Line 339: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');

335: IF ( p_seas_schedules_rec_type.DESCRIPTION is NULL ) OR
336: ( p_seas_schedules_rec_type.DESCRIPTION = fnd_api.g_miss_char )
337: THEN
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
339: FND_MESSAGE.SET_NAME ('CN' , 'CN_REQ_PAR_MISSING');
340: FND_MSG_PUB.Add;
341: END IF;
342: RAISE FND_API.G_EXC_ERROR ;
343: END IF;

Line 350: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_NAME_EXISTS');

346: SELECT COUNT(*) INTO l_count FROM CN_SEAS_SCHEDULES WHERE UPPER(NAME) LIKE UPPER(p_seas_schedules_rec_type.name) AND SEAS_SCHEDULE_ID <> p_seas_schedules_rec_type.seas_schedule_id;
347: -- Insert
348: IF l_count > 0 THEN
349: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
350: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_NAME_EXISTS');
351: FND_MSG_PUB.Add;
352: END IF;
353: RAISE FND_API.G_EXC_ERROR ;
354: END IF;

Line 432: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');

428: IF l_error_code = -54 THEN
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
431: THEN
432: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
433: FND_MSG_PUB.Add;
434: END IF;
435: ELSE
436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 524: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_DEL_FAILED');

520: SELECT COUNT(role_id) INTO l_role_quota_cate_count FROM CN_ROLE_QUOTA_CATES WHERE seas_schedule_id = P_SEAS_SCHEDULE_ID;
521:
522: IF (l_role_quota_cate_count > 0) THEN
523: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
524: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_DEL_FAILED');
525: FND_MSG_PUB.Add;
526: END IF;
527: RAISE FND_API.G_EXC_ERROR ;
528: END IF;

Line 580: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');

576: IF l_error_code = -54 THEN
577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
581: FND_MSG_PUB.Add;
582: END IF;
583: ELSE
584: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 710: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');

706: IF l_error_code = -54 THEN
707: x_return_status := FND_API.G_RET_STS_ERROR ;
708: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
709: THEN
710: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
711: FND_MSG_PUB.Add;
712: END IF;
713: ELSE
714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)