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 FND_MESSAGE

Line 164: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

160: x_return_status := FND_API.G_RET_STS_SUCCESS;
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',

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 173: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

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

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 183: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');

179:
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',

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 192: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');

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

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 202: fnd_message.set_name('CN', 'CN_START_DATE_CANNOT_NULL');

198: CLOSE name_check;
199:
200: -- 2. start_date and end_date can not be null and end_date >= start_date
201: IF (p_sub_batch_rec.start_date IS NULL) THEN
202: fnd_message.set_name('CN', 'CN_START_DATE_CANNOT_NULL');
203: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
204: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
205: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
206: TRUE);

Line 210: fnd_message.set_name('CN', 'CN_START_DATE_CANNOT_NULL');

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;
214: END IF;

Line 216: fnd_message.set_name('CN', 'CN_END_DATE_CANNOT_NULL');

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
216: fnd_message.set_name('CN', 'CN_END_DATE_CANNOT_NULL');
217: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
218: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
219: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
220: TRUE);

Line 224: fnd_message.set_name('CN', 'CN_END_DATE_CANNOT_NULL');

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;
228: END IF;

Line 230: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');

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
230: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
231: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
232: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
233: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
234: TRUE);

Line 238: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');

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;
242: END IF;

Line 248: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');

244: -- 3. start_date and end_date must be within an open period
245: OPEN open_period_check(p_sub_batch_rec.start_date);
246: FETCH open_period_check INTO l_dummy;
247: IF (open_period_check%notfound) THEN
248: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
249: fnd_message.set_token('DATE', p_sub_batch_rec.start_date);
250: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
251: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
252: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

Line 249: fnd_message.set_token('DATE', p_sub_batch_rec.start_date);

245: OPEN open_period_check(p_sub_batch_rec.start_date);
246: FETCH open_period_check INTO l_dummy;
247: IF (open_period_check%notfound) THEN
248: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
249: fnd_message.set_token('DATE', p_sub_batch_rec.start_date);
250: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
251: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
252: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
253: TRUE);

Line 257: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');

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;
261: x_return_status := fnd_api.g_ret_sts_error;

Line 258: fnd_message.set_token('DATE', p_sub_batch_rec.start_date);

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

Line 267: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');

263: CLOSE open_period_check;
264: OPEN open_period_check(p_sub_batch_rec.end_date);
265: FETCH open_period_check INTO l_dummy;
266: IF (open_period_check%notfound) THEN
267: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
268: fnd_message.set_token('DATE', p_sub_batch_rec.end_date);
269: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
270: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
271: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

Line 268: fnd_message.set_token('DATE', p_sub_batch_rec.end_date);

264: OPEN open_period_check(p_sub_batch_rec.end_date);
265: FETCH open_period_check INTO l_dummy;
266: IF (open_period_check%notfound) THEN
267: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
268: fnd_message.set_token('DATE', p_sub_batch_rec.end_date);
269: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
270: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
271: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
272: TRUE);

Line 276: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');

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;
280: x_return_status := fnd_api.g_ret_sts_error;

Line 277: fnd_message.set_token('DATE', p_sub_batch_rec.end_date);

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

Line 286: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

282: CLOSE open_period_check;
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',

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 295: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

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

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 302: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

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
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',

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 311: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

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

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 320: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

316: END IF;
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',

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 329: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

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

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 338: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

334: END IF;
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',

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 347: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

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

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 357: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

353:
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',

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 366: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

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

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 375: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

371: END IF;
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',

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 384: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

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

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 393: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

389: END IF;
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',

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 402: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

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

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 409: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

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
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',

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 418: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

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

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 427: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

423: END IF;
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',

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 436: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

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

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 446: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

442: IF (p_sub_batch_rec.intelligent_flag NOT IN ('Y', 'N') OR
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',

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 455: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

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

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 465: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

461:
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',

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 474: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

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

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 481: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

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
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',

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 490: fnd_message.set_name('CN' , 'CN_INVALID_DATA');

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

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;

Line 501: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');

497:
498: -- 10. salesrep validation
499: IF (p_sub_batch_rec.salesrep_option = 'USER_SPECIFY') THEN
500: IF (p_rep_entry_tbl.COUNT = 0) THEN
501: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');
502: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
503: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
504: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
505: TRUE);

Line 509: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');

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;
513: END IF;

Line 525: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');

521: END IF;
522: END LOOP;
523:
524: IF (l_dummy = 0) THEN
525: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');
526: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
527: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
528: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
529: TRUE);

Line 533: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');

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;
537: END IF;

Line 547: fnd_message.set_name('CN', 'CN_CALC_SALESREP_EXIST');

543: IF (j <> i) THEN
544: IF (p_rep_entry_tbl(j).salesrep_id = p_rep_entry_tbl(i).salesrep_id) THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546:
547: fnd_message.set_name('CN', 'CN_CALC_SALESREP_EXIST');
548: fnd_message.set_token('NAME', p_rep_entry_tbl(i).name);
549: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
550: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
551: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

Line 548: fnd_message.set_token('NAME', p_rep_entry_tbl(i).name);

544: IF (p_rep_entry_tbl(j).salesrep_id = p_rep_entry_tbl(i).salesrep_id) THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546:
547: fnd_message.set_name('CN', 'CN_CALC_SALESREP_EXIST');
548: fnd_message.set_token('NAME', p_rep_entry_tbl(i).name);
549: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
550: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
551: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
552: TRUE);

Line 556: fnd_message.set_name('CN', 'CN_CALC_SALESREP_EXIST');

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;
560: EXIT;

Line 557: fnd_message.set_token('NAME', p_rep_entry_tbl(i).name);

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;
560: EXIT;
561: END IF;

Line 575: fnd_message.set_name('CN', 'CN_CALC_PE_NO_MATCH');

571: IF (p_quota_entry_tbl(i).quota_id IS NOT NULL) THEN
572: OPEN quota_check(p_quota_entry_tbl(i).quota_id);
573: FETCH quota_check INTO l_quota_name;
574: IF (quota_check%notfound) THEN
575: fnd_message.set_name('CN', 'CN_CALC_PE_NO_MATCH');
576: fnd_message.set_token('QUOTA_NAME', l_quota_name);
577: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
578: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
579: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

Line 576: fnd_message.set_token('QUOTA_NAME', l_quota_name);

572: OPEN quota_check(p_quota_entry_tbl(i).quota_id);
573: FETCH quota_check INTO l_quota_name;
574: IF (quota_check%notfound) THEN
575: fnd_message.set_name('CN', 'CN_CALC_PE_NO_MATCH');
576: fnd_message.set_token('QUOTA_NAME', l_quota_name);
577: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
578: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
579: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
580: TRUE);

Line 584: fnd_message.set_name('CN', 'CN_CALC_PE_NO_MATCH');

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;
588: x_return_status := fnd_api.g_ret_sts_error;

Line 585: fnd_message.set_token('QUOTA_NAME', l_quota_name);

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

Line 656: fnd_message.set_name(appl_short_name, temp_buf);

652: -- There are no tokens, just a message name
653: temp_buf := temp_message;
654: temp_message := NULL;
655:
656: fnd_message.set_name(appl_short_name, temp_buf);
657: temp_buf := fnd_message.get;
658:
659: return(temp_buf);
660:

Line 657: temp_buf := fnd_message.get;

653: temp_buf := temp_message;
654: temp_message := NULL;
655:
656: fnd_message.set_name(appl_short_name, temp_buf);
657: temp_buf := fnd_message.get;
658:
659: return(temp_buf);
660:
661: ELSE

Line 665: fnd_message.set_name(appl_short_name, temp_buf);

661: ELSE
662: -- there are tokens
663: temp_buf := substr(temp_message, 1, pos1 - 1);
664: temp_message := ltrim(substr(temp_message, pos1 + 1));
665: fnd_message.set_name(appl_short_name, temp_buf);
666:
667: END IF;
668:
669:

Line 699: fnd_message.set_token(temp_buf, token_value, translate);

695: ELSIF (translate_arg = 'FALSE') then
696: Translate := False;
697: end if;
698:
699: fnd_message.set_token(temp_buf, token_value, translate);
700:
701: EXIT WHEN (temp_message IS NULL);
702:
703: END LOOP;

Line 707: temp_message := fnd_message.get;

703: END LOOP;
704:
705: END IF;
706:
707: temp_message := fnd_message.get;
708: return(temp_message);
709:
710: END translate;
711:

Line 897: fnd_message.set_name('CN', 'CNSBCS_INCOMPLETE_PLAN');

893: IF FND_API.To_Boolean(p_commit) THEN
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',

Line 1028: fnd_message.set_name('CN','ALL_PROCESS_DONE_OK_LOG');

1024: where calc_sub_batch_id = p_calc_sub_batch_id;
1025:
1026: IF (l_concurrent_flag = 'N') THEN
1027: IF nvl(l_process_status_code,'FAIL') = 'SUCCESS' THEN
1028: fnd_message.set_name('CN','ALL_PROCESS_DONE_OK_LOG');
1029: ELSIF nvl(l_process_status_code,'FAIL') = 'FAIL' THEN
1030: fnd_message.set_name('CN','ALL_PROCESS_DONE_FAIL_LOG');
1031: END IF;
1032: ELSE

Line 1030: fnd_message.set_name('CN','ALL_PROCESS_DONE_FAIL_LOG');

1026: IF (l_concurrent_flag = 'N') THEN
1027: IF nvl(l_process_status_code,'FAIL') = 'SUCCESS' THEN
1028: fnd_message.set_name('CN','ALL_PROCESS_DONE_OK_LOG');
1029: ELSIF nvl(l_process_status_code,'FAIL') = 'FAIL' THEN
1030: fnd_message.set_name('CN','ALL_PROCESS_DONE_FAIL_LOG');
1031: END IF;
1032: ELSE
1033: IF nvl(l_process_status_code,'FAIL') = 'SUCCESS' THEN
1034: fnd_message.set_name('CN','ALL_PROCESS_SUBMIT_OK_LOG');

Line 1034: fnd_message.set_name('CN','ALL_PROCESS_SUBMIT_OK_LOG');

1030: fnd_message.set_name('CN','ALL_PROCESS_DONE_FAIL_LOG');
1031: END IF;
1032: ELSE
1033: IF nvl(l_process_status_code,'FAIL') = 'SUCCESS' THEN
1034: fnd_message.set_name('CN','ALL_PROCESS_SUBMIT_OK_LOG');
1035: ELSIF nvl(l_process_status_code,'FAIL') = 'FAIL' THEN
1036: fnd_message.set_name('CN','ALL_PROCESS_SUBMIT_FAIL_LOG');
1037: END IF;
1038: END IF;

Line 1036: fnd_message.set_name('CN','ALL_PROCESS_SUBMIT_FAIL_LOG');

1032: ELSE
1033: IF nvl(l_process_status_code,'FAIL') = 'SUCCESS' THEN
1034: fnd_message.set_name('CN','ALL_PROCESS_SUBMIT_OK_LOG');
1035: ELSIF nvl(l_process_status_code,'FAIL') = 'FAIL' THEN
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;

Line 1039: fnd_message.set_token('AUDIT_ID', l_process_audit_id);

1035: ELSIF nvl(l_process_status_code,'FAIL') = 'FAIL' THEN
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,