APPS.CN_CALC_SUBMISSION_PVT dependencies on FND_MSG_PUB

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

168: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
169: TRUE);
170: end if;
171:
172: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
173: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
174: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
175: fnd_msg_pub.ADD;
176: END IF;

Line 175: fnd_msg_pub.ADD;

171:
172: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
173: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
174: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
175: fnd_msg_pub.ADD;
176: END IF;
177: x_return_status := fnd_api.g_ret_sts_error;
178: END IF;
179:

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

187: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
188: TRUE);
189: end if;
190:
191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
192: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');
193: fnd_message.set_token('BATCH_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
194: FND_MSG_PUB.Add;
195: END IF;

Line 194: FND_MSG_PUB.Add;

190:
191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
192: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');
193: fnd_message.set_token('BATCH_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
194: FND_MSG_PUB.Add;
195: END IF;
196: x_return_status := fnd_api.g_ret_sts_error;
197: END IF;
198: CLOSE name_check;

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

205: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
206: TRUE);
207: end if;
208:
209: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
210: fnd_message.set_name('CN', 'CN_START_DATE_CANNOT_NULL');
211: fnd_msg_pub.ADD;
212: END IF;
213: x_return_status := fnd_api.g_ret_sts_error;

Line 211: fnd_msg_pub.ADD;

207: end if;
208:
209: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
210: fnd_message.set_name('CN', 'CN_START_DATE_CANNOT_NULL');
211: fnd_msg_pub.ADD;
212: END IF;
213: x_return_status := fnd_api.g_ret_sts_error;
214: END IF;
215: IF (p_sub_batch_rec.end_date IS NULL) THEN

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

219: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
220: TRUE);
221: end if;
222:
223: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
224: fnd_message.set_name('CN', 'CN_END_DATE_CANNOT_NULL');
225: fnd_msg_pub.ADD;
226: END IF;
227: x_return_status := fnd_api.g_ret_sts_error;

Line 225: fnd_msg_pub.ADD;

221: end if;
222:
223: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
224: fnd_message.set_name('CN', 'CN_END_DATE_CANNOT_NULL');
225: fnd_msg_pub.ADD;
226: END IF;
227: x_return_status := fnd_api.g_ret_sts_error;
228: END IF;
229: IF (p_sub_batch_rec.start_date > p_sub_batch_rec.end_date) THEN

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

233: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
234: TRUE);
235: end if;
236:
237: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
238: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
239: fnd_msg_pub.ADD;
240: END IF;
241: x_return_status := fnd_api.g_ret_sts_error;

Line 239: fnd_msg_pub.ADD;

235: end if;
236:
237: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
238: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
239: fnd_msg_pub.ADD;
240: END IF;
241: x_return_status := fnd_api.g_ret_sts_error;
242: END IF;
243:

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

252: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
253: TRUE);
254: end if;
255:
256: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
257: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
258: fnd_message.set_token('DATE', p_sub_batch_rec.start_date);
259: fnd_msg_pub.ADD;
260: END IF;

Line 259: fnd_msg_pub.ADD;

255:
256: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
257: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
258: fnd_message.set_token('DATE', p_sub_batch_rec.start_date);
259: fnd_msg_pub.ADD;
260: END IF;
261: x_return_status := fnd_api.g_ret_sts_error;
262: END IF;
263: CLOSE open_period_check;

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

271: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
272: TRUE);
273: end if;
274:
275: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
276: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
277: fnd_message.set_token('DATE', p_sub_batch_rec.end_date);
278: fnd_msg_pub.ADD;
279: END IF;

Line 278: fnd_msg_pub.ADD;

274:
275: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
276: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
277: fnd_message.set_token('DATE', p_sub_batch_rec.end_date);
278: fnd_msg_pub.ADD;
279: END IF;
280: x_return_status := fnd_api.g_ret_sts_error;
281: END IF;
282: CLOSE open_period_check;

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

290: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
291: TRUE);
292: end if;
293:
294: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
295: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
296: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
297: fnd_msg_pub.ADD;
298: END IF;

Line 297: fnd_msg_pub.ADD;

293:
294: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
295: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
296: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
297: fnd_msg_pub.ADD;
298: END IF;
299: x_return_status := fnd_api.g_ret_sts_error;
300: END IF;
301: IF (p_sub_batch_rec.calc_type NOT IN ('COMMISSION', 'BONUS')) THEN

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

306: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
307: TRUE);
308: end if;
309:
310: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
311: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
312: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
313: fnd_msg_pub.ADD;
314: END IF;

Line 313: fnd_msg_pub.ADD;

309:
310: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
311: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
312: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
313: fnd_msg_pub.ADD;
314: END IF;
315: x_return_status := fnd_api.g_ret_sts_error;
316: END IF;
317:

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

324: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
325: TRUE);
326: end if;
327:
328: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
329: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
330: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));
331: fnd_msg_pub.ADD;
332: END IF;

Line 331: fnd_msg_pub.ADD;

327:
328: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
329: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
330: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));
331: fnd_msg_pub.ADD;
332: END IF;
333: x_return_status := fnd_api.g_ret_sts_error;
334: END IF;
335: IF (p_sub_batch_rec.salesrep_option NOT IN ('ALL_REPS', 'USER_SPECIFY', 'REPS_IN_NOTIFY_LOG') OR

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

342: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
343: TRUE);
344: end if;
345:
346: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
347: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
348: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));
349: fnd_msg_pub.ADD;
350: END IF;

Line 349: fnd_msg_pub.ADD;

345:
346: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
347: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
348: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));
349: fnd_msg_pub.ADD;
350: END IF;
351: x_return_status := fnd_api.g_ret_sts_error;
352: END IF;
353:

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

361: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
362: TRUE);
363: end if;
364:
365: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
366: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
367: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
368: fnd_msg_pub.ADD;
369: END IF;

Line 368: fnd_msg_pub.ADD;

364:
365: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
366: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
367: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
368: fnd_msg_pub.ADD;
369: END IF;
370: x_return_status := fnd_api.g_ret_sts_error;
371: END IF;
372: IF (p_sub_batch_rec.hierarchy_flag NOT IN ('Y', 'N') OR

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

379: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
380: TRUE);
381: end if;
382:
383: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
384: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
385: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
386: fnd_msg_pub.ADD;
387: END IF;

Line 386: fnd_msg_pub.ADD;

382:
383: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
384: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
385: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
386: fnd_msg_pub.ADD;
387: END IF;
388: x_return_status := fnd_api.g_ret_sts_error;
389: END IF;
390:

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

397: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
398: TRUE);
399: end if;
400:
401: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
402: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
403: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
404: fnd_msg_pub.ADD;
405: END IF;

Line 404: fnd_msg_pub.ADD;

400:
401: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
402: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
403: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
404: fnd_msg_pub.ADD;
405: END IF;
406: x_return_status := fnd_api.g_ret_sts_error;
407: END IF;
408: IF (p_sub_batch_rec.concurrent_flag NOT IN ('Y', 'N')) THEN

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

413: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
414: TRUE);
415: end if;
416:
417: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
418: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
419: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
420: fnd_msg_pub.ADD;
421: END IF;

Line 420: fnd_msg_pub.ADD;

416:
417: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
418: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
419: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
420: fnd_msg_pub.ADD;
421: END IF;
422: x_return_status := fnd_api.g_ret_sts_error;
423: END IF;
424:

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

431: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
432: TRUE);
433: end if;
434:
435: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
436: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
437: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
438: fnd_msg_pub.ADD;
439: END IF;

Line 438: fnd_msg_pub.ADD;

434:
435: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
436: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
437: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
438: fnd_msg_pub.ADD;
439: END IF;
440: x_return_status := fnd_api.g_ret_sts_error;
441: END IF;
442: IF (p_sub_batch_rec.intelligent_flag NOT IN ('Y', 'N') OR

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

450: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
451: TRUE);
452: end if;
453:
454: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
455: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
456: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
457: fnd_msg_pub.ADD;
458: END IF;

Line 457: fnd_msg_pub.ADD;

453:
454: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
455: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
456: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
457: fnd_msg_pub.ADD;
458: END IF;
459: x_return_status := fnd_api.g_ret_sts_error;
460: END IF;
461:

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

469: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
470: TRUE);
471: end if;
472:
473: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
474: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
475: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
476: fnd_msg_pub.ADD;
477: END IF;

Line 476: fnd_msg_pub.ADD;

472:
473: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
474: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
475: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
476: fnd_msg_pub.ADD;
477: END IF;
478: x_return_status := fnd_api.g_ret_sts_error;
479: END IF;
480: IF (p_sub_batch_rec.interval_type_id NOT IN (-1000, -1001, -1002, -1003)) THEN

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

485: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
486: TRUE);
487: end if;
488:
489: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
490: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
491: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
492: fnd_msg_pub.ADD;
493: END IF;

Line 492: fnd_msg_pub.ADD;

488:
489: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
490: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
491: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
492: fnd_msg_pub.ADD;
493: END IF;
494: x_return_status := fnd_api.g_ret_sts_error;
495: END IF;
496: END IF;

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

504: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
505: TRUE);
506: end if;
507:
508: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
509: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');
510: fnd_msg_pub.ADD;
511: END IF;
512: x_return_status := fnd_api.g_ret_sts_error;

Line 510: fnd_msg_pub.ADD;

506: end if;
507:
508: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
509: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');
510: fnd_msg_pub.ADD;
511: END IF;
512: x_return_status := fnd_api.g_ret_sts_error;
513: END IF;
514:

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

528: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
529: TRUE);
530: end if;
531:
532: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
533: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');
534: fnd_msg_pub.ADD;
535: END IF;
536: x_return_status := fnd_api.g_ret_sts_error;

Line 534: fnd_msg_pub.ADD;

530: end if;
531:
532: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
533: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');
534: fnd_msg_pub.ADD;
535: END IF;
536: x_return_status := fnd_api.g_ret_sts_error;
537: END IF;
538: END IF;

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

551: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
552: TRUE);
553: end if;
554:
555: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
556: fnd_message.set_name('CN', 'CN_CALC_SALESREP_EXIST');
557: fnd_message.set_token('NAME', p_rep_entry_tbl(i).name);
558: fnd_msg_pub.ADD;
559: END IF;

Line 558: fnd_msg_pub.ADD;

554:
555: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
556: fnd_message.set_name('CN', 'CN_CALC_SALESREP_EXIST');
557: fnd_message.set_token('NAME', p_rep_entry_tbl(i).name);
558: fnd_msg_pub.ADD;
559: END IF;
560: EXIT;
561: END IF;
562: END IF;

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

579: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
580: TRUE);
581: end if;
582:
583: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
584: fnd_message.set_name('CN', 'CN_CALC_PE_NO_MATCH');
585: fnd_message.set_token('QUOTA_NAME', l_quota_name);
586: fnd_msg_pub.ADD;
587: END IF;

Line 586: fnd_msg_pub.ADD;

582:
583: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
584: fnd_message.set_name('CN', 'CN_CALC_PE_NO_MATCH');
585: fnd_message.set_token('QUOTA_NAME', l_quota_name);
586: fnd_msg_pub.ADD;
587: END IF;
588: x_return_status := fnd_api.g_ret_sts_error;
589: END IF;
590: CLOSE quota_check;

Line 596: FND_MSG_PUB.Count_And_Get

592: END LOOP;
593: END IF;
594:
595: -- Standard call to get message count and if count is 1, get message info.
596: FND_MSG_PUB.Count_And_Get
597: (p_count => x_msg_count ,
598: p_data => x_msg_data ,
599: p_encoded => FND_API.G_FALSE );
600: EXCEPTION

Line 603: FND_MSG_PUB.count_and_get

599: p_encoded => FND_API.G_FALSE );
600: EXCEPTION
601: WHEN FND_API.G_EXC_ERROR THEN
602: x_return_status := FND_API.G_RET_STS_ERROR ;
603: FND_MSG_PUB.count_and_get
604: (p_count => x_msg_count ,
605: p_data => x_msg_data ,
606: p_encoded => FND_API.G_FALSE );
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 609: FND_MSG_PUB.count_and_get

605: p_data => x_msg_data ,
606: p_encoded => FND_API.G_FALSE );
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: FND_MSG_PUB.count_and_get
610: (p_count => x_msg_count ,
611: p_data => x_msg_data ,
612: p_encoded => FND_API.G_FALSE );
613: WHEN OTHERS THEN

Line 615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

611: p_data => x_msg_data ,
612: p_encoded => FND_API.G_FALSE );
613: WHEN OTHERS THEN
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
616: FND_MSG_PUB.add_exc_msg
617: (G_PKG_NAME ,
618: 'validate_submission_records');
619: END IF;

Line 616: FND_MSG_PUB.add_exc_msg

612: p_encoded => FND_API.G_FALSE );
613: WHEN OTHERS THEN
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
616: FND_MSG_PUB.add_exc_msg
617: (G_PKG_NAME ,
618: 'validate_submission_records');
619: END IF;
620: FND_MSG_PUB.count_and_get

Line 620: FND_MSG_PUB.count_and_get

616: FND_MSG_PUB.add_exc_msg
617: (G_PKG_NAME ,
618: 'validate_submission_records');
619: END IF;
620: FND_MSG_PUB.count_and_get
621: (p_count => x_msg_count ,
622: p_data => x_msg_data ,
623: p_encoded => FND_API.G_FALSE );
624:

Line 861: FND_MSG_PUB.initialize;

857: END IF;
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean( p_init_msg_list) THEN
861: FND_MSG_PUB.initialize;
862: END IF;
863:
864: -- Initialize API return status to success
865: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

888: RAISE fnd_api.g_exc_error;
889: END IF;
890:
891: IF (cn_proc_batches_pkg.find_srp_incomplete_plan(p_calc_sub_batch_id)) THEN
892: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
893: IF FND_API.To_Boolean(p_commit) THEN
894: COMMIT WORK;
895: END IF;
896:

Line 898: fnd_msg_pub.add;

894: COMMIT WORK;
895: END IF;
896:
897: fnd_message.set_name('CN', 'CNSBCS_INCOMPLETE_PLAN');
898: fnd_msg_pub.add;
899: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
900: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
901: 'cn.plsql.cn_calc_submission_pvt.validate.error',
902: FALSE);

Line 914: FND_MSG_PUB.Count_And_Get

910: COMMIT WORK;
911: END IF;
912:
913: -- Standard call to get message count and if count is 1, get message info.
914: FND_MSG_PUB.Count_And_Get
915: (p_count => x_msg_count ,
916: p_data => x_msg_data ,
917: p_encoded => FND_API.G_FALSE );
918:

Line 928: FND_MSG_PUB.count_and_get

924:
925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: x_return_status := FND_API.G_RET_STS_ERROR ;
928: FND_MSG_PUB.count_and_get
929: (p_count => x_msg_count ,
930: p_data => x_msg_data ,
931: p_encoded => FND_API.G_FALSE );
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 934: FND_MSG_PUB.count_and_get

930: p_data => x_msg_data ,
931: p_encoded => FND_API.G_FALSE );
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934: FND_MSG_PUB.count_and_get
935: (p_count => x_msg_count ,
936: p_data => x_msg_data ,
937: p_encoded => FND_API.G_FALSE );
938: WHEN OTHERS THEN

Line 940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

936: p_data => x_msg_data ,
937: p_encoded => FND_API.G_FALSE );
938: WHEN OTHERS THEN
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
941: FND_MSG_PUB.add_exc_msg
942: (G_PKG_NAME ,
943: 'Validate');
944: END IF;

Line 941: FND_MSG_PUB.add_exc_msg

937: p_encoded => FND_API.G_FALSE );
938: WHEN OTHERS THEN
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
941: FND_MSG_PUB.add_exc_msg
942: (G_PKG_NAME ,
943: 'Validate');
944: END IF;
945: FND_MSG_PUB.count_and_get

Line 945: FND_MSG_PUB.count_and_get

941: FND_MSG_PUB.add_exc_msg
942: (G_PKG_NAME ,
943: 'Validate');
944: END IF;
945: FND_MSG_PUB.count_and_get
946: (p_count => x_msg_count ,
947: p_data => x_msg_data ,
948: p_encoded => FND_API.G_FALSE );
949:

Line 987: FND_MSG_PUB.initialize;

983: END IF;
984:
985: -- Initialize message list if p_init_msg_list is set to TRUE.
986: IF FND_API.to_Boolean( p_init_msg_list) THEN
987: FND_MSG_PUB.initialize;
988: END IF;
989:
990: -- Initialize API return status to success
991: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1040: fnd_msg_pub.ADD;

1036: fnd_message.set_name('CN','ALL_PROCESS_SUBMIT_FAIL_LOG');
1037: END IF;
1038: END IF;
1039: fnd_message.set_token('AUDIT_ID', l_process_audit_id);
1040: fnd_msg_pub.ADD;
1041:
1042: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1043: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1044: 'cn.plsql.cn_calc_submission_pvt.calculate.end',

Line 1049: FND_MSG_PUB.Count_And_Get

1045: 'End of calculate' );
1046: end if;
1047:
1048: -- Standard call to get message count and if count is 1, get message info.
1049: FND_MSG_PUB.Count_And_Get
1050: (p_count => x_msg_count ,
1051: p_data => x_msg_data ,
1052: p_encoded => FND_API.G_FALSE );
1053: EXCEPTION

Line 1056: FND_MSG_PUB.count_and_get

1052: p_encoded => FND_API.G_FALSE );
1053: EXCEPTION
1054: WHEN FND_API.G_EXC_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_ERROR ;
1056: FND_MSG_PUB.count_and_get
1057: (p_count => x_msg_count ,
1058: p_data => x_msg_data ,
1059: p_encoded => FND_API.G_FALSE );
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1062: FND_MSG_PUB.count_and_get

1058: p_data => x_msg_data ,
1059: p_encoded => FND_API.G_FALSE );
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1062: FND_MSG_PUB.count_and_get
1063: (p_count => x_msg_count ,
1064: p_data => x_msg_data ,
1065: p_encoded => FND_API.G_FALSE );
1066: WHEN OTHERS THEN

Line 1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1064: p_data => x_msg_data ,
1065: p_encoded => FND_API.G_FALSE );
1066: WHEN OTHERS THEN
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1069: FND_MSG_PUB.add_exc_msg
1070: (G_PKG_NAME ,
1071: 'Calculate');
1072: END IF;

Line 1069: FND_MSG_PUB.add_exc_msg

1065: p_encoded => FND_API.G_FALSE );
1066: WHEN OTHERS THEN
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1068: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1069: FND_MSG_PUB.add_exc_msg
1070: (G_PKG_NAME ,
1071: 'Calculate');
1072: END IF;
1073: FND_MSG_PUB.count_and_get

Line 1073: FND_MSG_PUB.count_and_get

1069: FND_MSG_PUB.add_exc_msg
1070: (G_PKG_NAME ,
1071: 'Calculate');
1072: END IF;
1073: FND_MSG_PUB.count_and_get
1074: (p_count => x_msg_count ,
1075: p_data => x_msg_data ,
1076: p_encoded => FND_API.G_FALSE );
1077: END Calculate;

Line 1132: FND_MSG_PUB.initialize;

1128: END IF;
1129:
1130: -- Initialize message list if p_init_msg_list is set to TRUE.
1131: IF FND_API.to_Boolean( p_init_msg_list) THEN
1132: FND_MSG_PUB.initialize;
1133: END IF;
1134:
1135: -- Initialize API return status to success
1136: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1281: FND_MSG_PUB.count_and_get

1277: EXCEPTION
1278: WHEN FND_API.G_EXC_ERROR THEN
1279: ROLLBACK TO copybatch_PVT;
1280: x_return_status := FND_API.G_RET_STS_ERROR ;
1281: FND_MSG_PUB.count_and_get
1282: (p_count => x_msg_count ,
1283: p_data => x_msg_data ,
1284: p_encoded => FND_API.G_FALSE );
1285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1288: FND_MSG_PUB.count_and_get

1284: p_encoded => FND_API.G_FALSE );
1285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1286: ROLLBACK TO copybatch_PVT;
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1288: FND_MSG_PUB.count_and_get
1289: (p_count => x_msg_count ,
1290: p_data => x_msg_data ,
1291: p_encoded => FND_API.G_FALSE );
1292: WHEN OTHERS THEN

Line 1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1291: p_encoded => FND_API.G_FALSE );
1292: WHEN OTHERS THEN
1293: ROLLBACK TO copybatch_PVT;
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1296: FND_MSG_PUB.add_exc_msg
1297: (G_PKG_NAME ,
1298: 'copybatch');
1299: END IF;

Line 1296: FND_MSG_PUB.add_exc_msg

1292: WHEN OTHERS THEN
1293: ROLLBACK TO copybatch_PVT;
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1296: FND_MSG_PUB.add_exc_msg
1297: (G_PKG_NAME ,
1298: 'copybatch');
1299: END IF;
1300: FND_MSG_PUB.count_and_get

Line 1300: FND_MSG_PUB.count_and_get

1296: FND_MSG_PUB.add_exc_msg
1297: (G_PKG_NAME ,
1298: 'copybatch');
1299: END IF;
1300: FND_MSG_PUB.count_and_get
1301: (p_count => x_msg_count ,
1302: p_data => x_msg_data ,
1303: p_encoded => FND_API.G_FALSE );
1304: