DBA Data[Home] [Help]

APPS.CN_SRP_PRD_QUOTA_PUB dependencies on FND_MESSAGE

Line 189: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');

185:
186: IF p_pe_name IS NULL
187: THEN
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
189: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
190: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PE_NAME', 'INPUT_TOKEN'));
191: FND_MSG_PUB.Add;
192: END IF;
193: RAISE FND_API.G_EXC_ERROR ;

Line 190: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PE_NAME', 'INPUT_TOKEN'));

186: IF p_pe_name IS NULL
187: THEN
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
189: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
190: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PE_NAME', 'INPUT_TOKEN'));
191: FND_MSG_PUB.Add;
192: END IF;
193: RAISE FND_API.G_EXC_ERROR ;
194: END IF;

Line 203: FND_MESSAGE.SET_NAME ('CN' , 'CN_PLN_NOT_EXIST');

199:
200: IF (l_quota_id_cr%NOTFOUND)
201: THEN
202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
203: FND_MESSAGE.SET_NAME ('CN' , 'CN_PLN_NOT_EXIST');
204: FND_MESSAGE.SET_TOKEN ('PE_NAME' , p_pe_name);
205: FND_MSG_PUB.Add;
206: END IF;
207: RAISE FND_API.G_EXC_ERROR ;

Line 204: FND_MESSAGE.SET_TOKEN ('PE_NAME' , p_pe_name);

200: IF (l_quota_id_cr%NOTFOUND)
201: THEN
202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
203: FND_MESSAGE.SET_NAME ('CN' , 'CN_PLN_NOT_EXIST');
204: FND_MESSAGE.SET_TOKEN ('PE_NAME' , p_pe_name);
205: FND_MSG_PUB.Add;
206: END IF;
207: RAISE FND_API.G_EXC_ERROR ;
208: END IF;

Line 220: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');

216: -- 2. get the salesrep_id using salesrep_name and employee_number
217: IF p_salesrep_name IS NULL
218: THEN
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
220: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
221: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SR_NAME', 'INPUT_TOKEN'));
222: FND_MSG_PUB.Add;
223: END IF;
224: RAISE FND_API.G_EXC_ERROR ;

Line 221: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SR_NAME', 'INPUT_TOKEN'));

217: IF p_salesrep_name IS NULL
218: THEN
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
220: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
221: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SR_NAME', 'INPUT_TOKEN'));
222: FND_MSG_PUB.Add;
223: END IF;
224: RAISE FND_API.G_EXC_ERROR ;
225: END IF;

Line 233: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_NOT_FOUND');

229:
230: IF (l_salesrep_id_cr%NOTFOUND)
231: THEN
232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
233: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_NOT_FOUND');
234: FND_MSG_PUB.Add;
235: END IF;
236: RAISE FND_API.G_EXC_ERROR ;
237: END IF;

Line 247: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');

243:
244: IF p_role_name IS NULL
245: THEN
246: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
247: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
248: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('ROLE_NAME', 'INPUT_TOKEN'));
249: FND_MSG_PUB.Add;
250: END IF;
251: RAISE FND_API.G_EXC_ERROR ;

Line 248: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('ROLE_NAME', 'INPUT_TOKEN'));

244: IF p_role_name IS NULL
245: THEN
246: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
247: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
248: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('ROLE_NAME', 'INPUT_TOKEN'));
249: FND_MSG_PUB.Add;
250: END IF;
251: RAISE FND_API.G_EXC_ERROR ;
252: END IF;

Line 260: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_INVALID_SRPROLE');

256:
257: IF (l_role_id_cr%NOTFOUND)
258: THEN
259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_INVALID_SRPROLE');
261: FND_MSG_PUB.Add;
262: END IF;
263: RAISE FND_API.G_EXC_ERROR ;
264: END IF;

Line 274: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');

270: -- 4. get Comp Plan ID
271: IF p_cp_name IS NULL
272: THEN
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
275: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('CP_NAME', 'INPUT_TOKEN'));
276: FND_MSG_PUB.Add;
277: END IF;
278: RAISE FND_API.G_EXC_ERROR ;

Line 275: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('CP_NAME', 'INPUT_TOKEN'));

271: IF p_cp_name IS NULL
272: THEN
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
275: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('CP_NAME', 'INPUT_TOKEN'));
276: FND_MSG_PUB.Add;
277: END IF;
278: RAISE FND_API.G_EXC_ERROR ;
279: END IF;

Line 287: FND_MESSAGE.SET_NAME ('CN' , 'CN_CP_NOT_EXIST');

283:
284: IF (l_comp_plan_id_cr%NOTFOUND)
285: THEN
286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
287: FND_MESSAGE.SET_NAME ('CN' , 'CN_CP_NOT_EXIST');
288: FND_MESSAGE.SET_TOKEN ('CP_NAME' , p_cp_name);
289: FND_MSG_PUB.Add;
290: END IF;
291: RAISE FND_API.G_EXC_ERROR ;

Line 288: FND_MESSAGE.SET_TOKEN ('CP_NAME' , p_cp_name);

284: IF (l_comp_plan_id_cr%NOTFOUND)
285: THEN
286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
287: FND_MESSAGE.SET_NAME ('CN' , 'CN_CP_NOT_EXIST');
288: FND_MESSAGE.SET_TOKEN ('CP_NAME' , p_cp_name);
289: FND_MSG_PUB.Add;
290: END IF;
291: RAISE FND_API.G_EXC_ERROR ;
292: END IF;

Line 303: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');

299:
300: IF p_srp_plan_start_date IS NULL
301: THEN
302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
303: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
304: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SD', 'INPUT_TOKEN'));
305: FND_MSG_PUB.Add;
306: END IF;
307: RAISE FND_API.G_EXC_ERROR ;

Line 304: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SD', 'INPUT_TOKEN'));

300: IF p_srp_plan_start_date IS NULL
301: THEN
302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
303: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
304: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SD', 'INPUT_TOKEN'));
305: FND_MSG_PUB.Add;
306: END IF;
307: RAISE FND_API.G_EXC_ERROR ;
308: END IF;

Line 316: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PLN_ASSIGN_NOT_EXIST');

312:
313: IF (l_srp_plan_assign_id_cr%NOTFOUND)
314: THEN
315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
316: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PLN_ASSIGN_NOT_EXIST');
317: FND_MSG_PUB.Add;
318: END IF;
319: RAISE FND_API.G_EXC_ERROR ;
320: END IF;

Line 332: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_ASSIGN_NOT_EXIST');

328:
329: IF (l_srp_quota_assign_id_cr%NOTFOUND)
330: THEN
331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
332: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_ASSIGN_NOT_EXIST');
333: FND_MSG_PUB.Add;
334: END IF;
335: RAISE FND_API.G_EXC_ERROR ;
336: END IF;

Line 344: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_NOT_CUSTOMIZABLE');

340:
341: If l_customized_flag <> 'Y'
342: THEN
343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
344: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_NOT_CUSTOMIZABLE');
345: FND_MSG_PUB.Add;
346: END IF;
347: RAISE FND_API.G_EXC_ERROR ;
348: END IF;

Line 469: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');

465:
466: IF p_srp_prd_quota_tbl(i).period_name IS NULL
467: THEN
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
469: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
470: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PERIOD_NAME', 'INPUT_TOKEN'));
471: FND_MSG_PUB.Add;
472: END IF;
473: RAISE FND_API.G_EXC_ERROR ;

Line 470: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PERIOD_NAME', 'INPUT_TOKEN'));

466: IF p_srp_prd_quota_tbl(i).period_name IS NULL
467: THEN
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
469: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
470: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PERIOD_NAME', 'INPUT_TOKEN'));
471: FND_MSG_PUB.Add;
472: END IF;
473: RAISE FND_API.G_EXC_ERROR ;
474: END IF;

Line 481: FND_MESSAGE.SET_NAME ('CN' , 'CN_PERIOD_NOT_FOUND');

477: FETCH l_period_id_cr into f_period_id_rec;
478: IF (l_period_id_cr%NOTFOUND)
479: THEN
480: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
481: FND_MESSAGE.SET_NAME ('CN' , 'CN_PERIOD_NOT_FOUND');
482: FND_MSG_PUB.Add;
483: END IF;
484: RAISE FND_API.G_EXC_ERROR ;
485: END IF;

Line 496: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PERIOD_QUOTA_NOT_EXIST');

492: FETCH tbl_period_quota_info_cr into f_period_quota_info_rec;
493: IF (tbl_period_quota_info_cr%NOTFOUND)
494: THEN
495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
496: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PERIOD_QUOTA_NOT_EXIST');
497: FND_MSG_PUB.Add;
498: END IF;
499: RAISE FND_API.G_EXC_ERROR ;
500: END IF;