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_CALC_SUBMISSION_PVT dependencies on CN_API

Line 165: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));

161:
162: -- 1. name can not be null and should be unique(there is a unique index on name)
163: IF (p_sub_batch_rec.name IS NULL) THEN
164: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
165: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
166: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
167: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
168: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
169: TRUE);

Line 174: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
177: x_return_status := fnd_api.g_ret_sts_error;
178: END IF;

Line 184: fnd_message.set_token('BATCH_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));

180: OPEN name_check(p_sub_batch_rec.name);
181: FETCH name_check INTO l_dummy;
182: IF (name_check%found) THEN
183: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');
184: fnd_message.set_token('BATCH_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
185: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
186: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
187: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
188: TRUE);

Line 193: fnd_message.set_token('BATCH_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
196: x_return_status := fnd_api.g_ret_sts_error;
197: END IF;

Line 287: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));

283:
284: -- 4. calc_type can not be null, must be 'COMMISSION' or 'BONUS'
285: IF (p_sub_batch_rec.calc_type IS NULL) THEN
286: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
287: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
288: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
289: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
290: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
291: TRUE);

Line 296: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
299: x_return_status := fnd_api.g_ret_sts_error;
300: END IF;

Line 303: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));

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
302: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
303: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
304: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
305: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
306: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
307: TRUE);

Line 312: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
315: x_return_status := fnd_api.g_ret_sts_error;
316: END IF;

Line 321: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));

317:
318: -- 5. salesrep_option can not be null and must be a valid value
319: IF (p_sub_batch_rec.salesrep_option IS NULL) THEN
320: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
321: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));
322: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
323: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
324: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
325: TRUE);

Line 330: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
333: x_return_status := fnd_api.g_ret_sts_error;
334: END IF;

Line 339: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));

335: IF (p_sub_batch_rec.salesrep_option NOT IN ('ALL_REPS', 'USER_SPECIFY', 'REPS_IN_NOTIFY_LOG') OR
336: (p_sub_batch_rec.calc_type = 'BONUS' AND p_sub_batch_rec.salesrep_option = 'REPS_IN_NOTIFY_LOG'))
337: THEN
338: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
339: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));
340: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
341: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
342: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
343: TRUE);

Line 348: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
351: x_return_status := fnd_api.g_ret_sts_error;
352: END IF;

Line 358: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

354: -- 6. hierarchy_flag can not be null, must be a valid value
355: -- TO DO: remove this check if hierarchy flag is only supported at rep level in R12
356: IF (p_sub_batch_rec.hierarchy_flag IS NULL) THEN
357: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
358: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
359: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
360: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
361: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
362: TRUE);

Line 367: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
370: x_return_status := fnd_api.g_ret_sts_error;
371: END IF;

Line 376: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

372: IF (p_sub_batch_rec.hierarchy_flag NOT IN ('Y', 'N') OR
373: (p_sub_batch_rec.salesrep_option IN ('ALL_REPS', 'REPS_IN_NOTIFY_LOG') AND p_sub_batch_rec.hierarchy_flag = 'Y'))
374: THEN
375: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
376: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
377: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
378: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
379: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
380: TRUE);

Line 385: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
388: x_return_status := fnd_api.g_ret_sts_error;
389: END IF;

Line 394: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

390:
391: -- 7. concurrent_flag can not be null, must be a valid value
392: IF (p_sub_batch_rec.concurrent_flag IS NULL) THEN
393: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
394: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
395: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
396: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
397: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
398: TRUE);

Line 403: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
406: x_return_status := fnd_api.g_ret_sts_error;
407: END IF;

Line 410: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

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
409: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
410: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
411: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
412: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
413: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
414: TRUE);

Line 419: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
422: x_return_status := fnd_api.g_ret_sts_error;
423: END IF;

Line 428: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

424:
425: -- 8. intelligent_flag can not be null, must be a valid value
426: IF (p_sub_batch_rec.intelligent_flag IS NULL) THEN
427: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
428: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
429: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
430: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
431: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
432: TRUE);

Line 437: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
440: x_return_status := fnd_api.g_ret_sts_error;
441: END IF;

Line 447: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

443: (p_sub_batch_rec.calc_type = 'BONUS' AND p_sub_batch_rec.intelligent_flag = 'Y') OR
444: (p_sub_batch_rec.salesrep_option = 'REPS_IN_NOTIFY_LOG' AND p_sub_batch_rec.intelligent_flag = 'N'))
445: THEN
446: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
447: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
448: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
449: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
450: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
451: TRUE);

Line 456: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
459: x_return_status := fnd_api.g_ret_sts_error;
460: END IF;

Line 466: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));

462: -- 9. interval_type can not be null, must be a valid value if calc_type = 'BONUS'
463: IF (p_sub_batch_rec.calc_type = 'BONUS') THEN
464: IF (p_sub_batch_rec.interval_type_id IS NULL) THEN
465: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
466: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
467: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
468: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
469: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
470: TRUE);

Line 475: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
478: x_return_status := fnd_api.g_ret_sts_error;
479: END IF;

Line 482: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));

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
481: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
482: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
483: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
484: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
485: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
486: TRUE);

Line 491: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));

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;
494: x_return_status := fnd_api.g_ret_sts_error;
495: END IF;