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_PUB dependencies on FND_MESSAGE

Line 112: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');

108: FETCH l_batch_name_csr INTO l_counter;
109: CLOSE l_batch_name_csr;
110:
111: IF l_counter <> 0 THEN
112: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');
113: fnd_message.set_token('BATCH_NAME', p_calc_submission_rec.batch_name);
114: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
115: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
116: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',

Line 113: fnd_message.set_token('BATCH_NAME', p_calc_submission_rec.batch_name);

109: CLOSE l_batch_name_csr;
110:
111: IF l_counter <> 0 THEN
112: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');
113: fnd_message.set_token('BATCH_NAME', p_calc_submission_rec.batch_name);
114: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
115: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
116: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
117: TRUE);

Line 121: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');

117: TRUE);
118: end if;
119:
120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
121: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');
122: fnd_message.set_token('BATCH_NAME', p_calc_submission_rec.batch_name);
123: FND_MSG_PUB.Add;
124: END IF;
125:

Line 122: fnd_message.set_token('BATCH_NAME', p_calc_submission_rec.batch_name);

118: end if;
119:
120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
121: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');
122: fnd_message.set_token('BATCH_NAME', p_calc_submission_rec.batch_name);
123: FND_MSG_PUB.Add;
124: END IF;
125:
126: x_loading_status := 'CN_CALC_SUB_EXISTS';

Line 149: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');

145: fetch l_ctr_csr into l_counter;
146: close l_ctr_csr;
147:
148: IF l_counter <> 1 then
149: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
150: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.start_date);
151: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
152: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
153: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',

Line 150: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.start_date);

146: close l_ctr_csr;
147:
148: IF l_counter <> 1 then
149: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
150: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.start_date);
151: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
152: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
153: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
154: TRUE);

Line 158: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');

154: TRUE);
155: end if;
156:
157: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
158: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
159: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.start_date);
160: FND_MSG_PUB.Add;
161: END IF;
162:

Line 159: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.start_date);

155: end if;
156:
157: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
158: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
159: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.start_date);
160: FND_MSG_PUB.Add;
161: END IF;
162:
163: x_loading_status := 'CN_CALC_SUB_OPEN_DATE';

Line 172: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');

168: fetch l_ctr_csr into l_counter;
169: close l_ctr_csr;
170:
171: IF l_counter <> 1 then
172: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
173: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.end_date );
174: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
175: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
176: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',

Line 173: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.end_date );

169: close l_ctr_csr;
170:
171: IF l_counter <> 1 then
172: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
173: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.end_date );
174: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
175: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
176: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
177: TRUE);

Line 181: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');

177: TRUE);
178: end if;
179:
180: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
181: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
182: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.end_date );
183: FND_MSG_PUB.Add;
184: END IF;
185:

Line 182: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.end_date );

178: end if;
179:
180: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
181: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_OPEN_DATE');
182: FND_MESSAGE.SET_TOKEN('DATE', p_calc_submission_rec.end_date );
183: FND_MSG_PUB.Add;
184: END IF;
185:
186: x_loading_status := 'CN_CALC_SUB_OPEN_DATE';

Line 200: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

196: RAISE FND_API.G_EXC_ERROR ;
197: END IF;
198:
199: IF ( p_calc_submission_rec.calculation_type NOT IN ('COMMISSION', 'BONUS')) THEN
200: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
201: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_calc_type);
202: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
203: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
204: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',

Line 201: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_calc_type);

197: END IF;
198:
199: IF ( p_calc_submission_rec.calculation_type NOT IN ('COMMISSION', 'BONUS')) THEN
200: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
201: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_calc_type);
202: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
203: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
204: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
205: TRUE);

Line 209: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

205: TRUE);
206: end if;
207:
208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
209: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
210: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_calc_type);
211: FND_MSG_PUB.Add;
212: END IF;
213: x_loading_status := 'CN_INVALID_DATA';

Line 210: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_calc_type);

206: end if;
207:
208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
209: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
210: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_calc_type);
211: FND_MSG_PUB.Add;
212: END IF;
213: x_loading_status := 'CN_INVALID_DATA';
214: RAISE FND_API.G_EXC_ERROR ;

Line 230: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

226: IF p_calc_submission_rec.salesrep_option NOT IN ('ALL_REPS', 'USER_SPECIFY', 'REPS_IN_NOTIFY_LOG')
227: OR ( p_calc_submission_rec.calculation_type = 'BONUS'
228: AND p_calc_submission_rec.salesrep_option = 'REPS_IN_NOTIFY_LOG' )
229: THEN
230: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
231: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_salesrep_option );
232: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
233: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
234: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',

Line 231: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_salesrep_option );

227: OR ( p_calc_submission_rec.calculation_type = 'BONUS'
228: AND p_calc_submission_rec.salesrep_option = 'REPS_IN_NOTIFY_LOG' )
229: THEN
230: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
231: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_salesrep_option );
232: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
233: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
234: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
235: TRUE);

Line 239: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

235: TRUE);
236: end if;
237:
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
239: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
240: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_salesrep_option );
241: FND_MSG_PUB.Add;
242: END IF;
243: x_loading_status := 'CN_INVALID_DATA';

Line 240: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_salesrep_option );

236: end if;
237:
238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
239: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
240: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_salesrep_option );
241: FND_MSG_PUB.Add;
242: END IF;
243: x_loading_status := 'CN_INVALID_DATA';
244: RAISE FND_API.G_EXC_ERROR ;

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

256: IF p_calc_submission_rec.entire_hierarchy NOT IN ('Y', 'N')
257: OR ( p_calc_submission_rec.salesrep_option IN ('ALL_REPS', 'REPS_IN_NOTIFY_LOG')
258: AND p_calc_submission_rec.entire_hierarchy = 'Y' )
259: THEN
260: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
261: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );
262: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
263: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
264: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',

Line 261: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );

257: OR ( p_calc_submission_rec.salesrep_option IN ('ALL_REPS', 'REPS_IN_NOTIFY_LOG')
258: AND p_calc_submission_rec.entire_hierarchy = 'Y' )
259: THEN
260: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
261: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );
262: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
263: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
264: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
265: TRUE);

Line 269: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

265: TRUE);
266: end if;
267:
268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
269: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
270: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );
271: FND_MSG_PUB.Add;
272: END IF;
273: x_loading_status := 'CN_INVALID_DATA';

Line 270: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );

266: end if;
267:
268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
269: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
270: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );
271: FND_MSG_PUB.Add;
272: END IF;
273: x_loading_status := 'CN_INVALID_DATA';
274: RAISE FND_API.G_EXC_ERROR ;

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

283: RAISE FND_API.G_EXC_ERROR ;
284: END IF;
285:
286: IF p_calc_submission_rec.concurrent_calculation NOT IN ('Y', 'N') THEN
287: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
288: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_concurrent_flag );
289: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
290: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
291: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',

Line 288: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_concurrent_flag );

284: END IF;
285:
286: IF p_calc_submission_rec.concurrent_calculation NOT IN ('Y', 'N') THEN
287: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
288: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_concurrent_flag );
289: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
290: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
291: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
292: TRUE);

Line 296: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

292: TRUE);
293: end if;
294:
295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
296: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
297: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_concurrent_flag );
298: FND_MSG_PUB.Add;
299: END IF;
300: x_loading_status := 'CN_INVALID_DATA';

Line 297: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_concurrent_flag );

293: end if;
294:
295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
296: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
297: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_concurrent_flag );
298: FND_MSG_PUB.Add;
299: END IF;
300: x_loading_status := 'CN_INVALID_DATA';
301: RAISE FND_API.G_EXC_ERROR ;

Line 319: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

315: AND p_calc_submission_rec.incremental_calculation = 'Y' )
316: OR ( p_calc_submission_rec.salesrep_option = 'REPS_IN_NOTIFY_LOG'
317: AND p_calc_submission_rec.incremental_calculation = 'N' )
318: THEN
319: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
320: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_intelligent_flag );
321: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
322: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
323: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',

Line 320: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_intelligent_flag );

316: OR ( p_calc_submission_rec.salesrep_option = 'REPS_IN_NOTIFY_LOG'
317: AND p_calc_submission_rec.incremental_calculation = 'N' )
318: THEN
319: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
320: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_intelligent_flag );
321: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
322: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
323: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
324: TRUE);

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

324: TRUE);
325: end if;
326:
327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
328: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
329: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_intelligent_flag );
330: FND_MSG_PUB.Add;
331: END IF;
332: x_loading_status := 'CN_INVALID_DATA';

Line 329: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_intelligent_flag );

325: end if;
326:
327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
328: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
329: FND_MESSAGE.SET_TOKEN('OBJ_NAME',g_calc_sub_intelligent_flag );
330: FND_MSG_PUB.Add;
331: END IF;
332: x_loading_status := 'CN_INVALID_DATA';
333: RAISE FND_API.G_EXC_ERROR ;

Line 347: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

343: RAISE FND_API.G_EXC_ERROR ;
344: END IF;
345:
346: IF p_calc_submission_rec.interval_type NOT IN ('ALL', 'PERIOD', 'QUARTER', 'YEAR' ) THEN
347: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
348: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_interval_type );
349: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
350: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
351: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',

Line 348: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_interval_type );

344: END IF;
345:
346: IF p_calc_submission_rec.interval_type NOT IN ('ALL', 'PERIOD', 'QUARTER', 'YEAR' ) THEN
347: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
348: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_interval_type );
349: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
350: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
351: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
352: TRUE);

Line 356: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

352: TRUE);
353: end if;
354:
355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
356: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
357: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_interval_type );
358: FND_MSG_PUB.Add;
359: END IF;
360: x_loading_status := 'CN_INVALID_DATA';

Line 357: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_interval_type );

353: end if;
354:
355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
356: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
357: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_interval_type );
358: FND_MSG_PUB.Add;
359: END IF;
360: x_loading_status := 'CN_INVALID_DATA';
361: RAISE FND_API.G_EXC_ERROR ;

Line 455: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

451: RETURN FALSE;
452: END IF;
453:
454: if (nvl(p_salesrep_rec.hierarchy_flag, 'N') not in ('N', 'Y')) then
455: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
456: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );
457: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
458: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
459: 'cn.plsql.cn_calc_submission_pub.validate_salesrep.error',

Line 456: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );

452: END IF;
453:
454: if (nvl(p_salesrep_rec.hierarchy_flag, 'N') not in ('N', 'Y')) then
455: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
456: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );
457: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
458: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
459: 'cn.plsql.cn_calc_submission_pub.validate_salesrep.error',
460: TRUE);

Line 464: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');

460: TRUE);
461: end if;
462:
463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
464: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
465: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );
466: FND_MSG_PUB.Add;
467: END IF;
468: return false;

Line 465: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );

461: end if;
462:
463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
464: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_DATA');
465: FND_MESSAGE.SET_TOKEN('OBJ_NAME', g_calc_sub_hierarchy_flag );
466: FND_MSG_PUB.Add;
467: END IF;
468: return false;
469: end if;

Line 490: FND_MESSAGE.SET_NAME ('CN', 'CN_CALC_PLAN_NOT_ASSIGNED');

486:
487: IF l_has_had_comp_plan_csr%notfound THEN
488: CLOSE l_has_had_comp_plan_csr;
489:
490: FND_MESSAGE.SET_NAME ('CN', 'CN_CALC_PLAN_NOT_ASSIGNED');
491: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_rec.employee_number );
492: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_rec.TYPE );
493: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
494: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 491: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_rec.employee_number );

487: IF l_has_had_comp_plan_csr%notfound THEN
488: CLOSE l_has_had_comp_plan_csr;
489:
490: FND_MESSAGE.SET_NAME ('CN', 'CN_CALC_PLAN_NOT_ASSIGNED');
491: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_rec.employee_number );
492: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_rec.TYPE );
493: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
494: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
495: 'cn.plsql.cn_calc_submission_pub.validate_salesrep.error',

Line 492: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_rec.TYPE );

488: CLOSE l_has_had_comp_plan_csr;
489:
490: FND_MESSAGE.SET_NAME ('CN', 'CN_CALC_PLAN_NOT_ASSIGNED');
491: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_rec.employee_number );
492: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_rec.TYPE );
493: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
494: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
495: 'cn.plsql.cn_calc_submission_pub.validate_salesrep.error',
496: TRUE);

Line 500: FND_MESSAGE.SET_NAME ('CN', 'CN_CALC_PLAN_NOT_ASSIGNED');

496: TRUE);
497: end if;
498:
499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
500: FND_MESSAGE.SET_NAME ('CN', 'CN_CALC_PLAN_NOT_ASSIGNED');
501: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_rec.employee_number );
502: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_rec.TYPE );
503: FND_MSG_PUB.Add;
504: END IF;

Line 501: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_rec.employee_number );

497: end if;
498:
499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
500: FND_MESSAGE.SET_NAME ('CN', 'CN_CALC_PLAN_NOT_ASSIGNED');
501: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_rec.employee_number );
502: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_rec.TYPE );
503: FND_MSG_PUB.Add;
504: END IF;
505:

Line 502: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_rec.TYPE );

498:
499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
500: FND_MESSAGE.SET_NAME ('CN', 'CN_CALC_PLAN_NOT_ASSIGNED');
501: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_rec.employee_number );
502: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_rec.TYPE );
503: FND_MSG_PUB.Add;
504: END IF;
505:
506: x_loading_status := 'CN_CALC_PLAN_NOT_ASSIGNED';

Line 538: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_PE_NO_MATCH');

534:
535: IF l_bonus_pe_csr%notfound THEN
536: CLOSE l_bonus_pe_csr;
537:
538: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_PE_NO_MATCH');
539: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);
540: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
541: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
542: 'cn.plsql.cn_calc_submission_pub.validate_bonus_pe.error',

Line 539: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);

535: IF l_bonus_pe_csr%notfound THEN
536: CLOSE l_bonus_pe_csr;
537:
538: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_PE_NO_MATCH');
539: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);
540: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
541: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
542: 'cn.plsql.cn_calc_submission_pub.validate_bonus_pe.error',
543: TRUE);

Line 547: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_PE_NO_MATCH');

543: TRUE);
544: end if;
545:
546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
547: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_PE_NO_MATCH');
548: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);
549: FND_MSG_PUB.Add;
550: END IF;
551:

Line 548: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);

544: end if;
545:
546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
547: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_PE_NO_MATCH');
548: FND_MESSAGE.SET_TOKEN('QUOTA_NAME',p_quota_name);
549: FND_MSG_PUB.Add;
550: END IF;
551:
552: x_loading_status := 'CN_CALC_PE_NO_MATCH';

Line 595: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_NO_SALESREP');

591:
592: -- Start of API body
593:
594: IF p_salesrep_tbl.COUNT = 0 THEN
595: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_NO_SALESREP');
596: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
597: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
598: 'cn.plsql.cn_calc_submission_pub.validate_salesrep_entries.error',
599: TRUE);

Line 603: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_NO_SALESREP');

599: TRUE);
600: end if;
601:
602: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
603: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_NO_SALESREP');
604: FND_MSG_PUB.Add;
605: END IF;
606: x_loading_status := 'CN_CALC_NO_SALESREP';
607: RAISE FND_API.g_exc_error;

Line 821: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_USER_NOT_EXIST');

817: WHERE user_name = p_app_user_resp_rec.user_name;
818:
819: EXCEPTION
820: WHEN no_data_found THEN
821: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_USER_NOT_EXIST');
822: fnd_message.set_token('USER_NAME', p_app_user_resp_rec.user_name );
823: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
824: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
825: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.validation',

Line 822: fnd_message.set_token('USER_NAME', p_app_user_resp_rec.user_name );

818:
819: EXCEPTION
820: WHEN no_data_found THEN
821: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_USER_NOT_EXIST');
822: fnd_message.set_token('USER_NAME', p_app_user_resp_rec.user_name );
823: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
824: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
825: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.validation',
826: TRUE);

Line 830: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_USER_NOT_EXIST');

826: TRUE);
827: end if;
828:
829: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
830: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_USER_NOT_EXIST');
831: fnd_message.set_token('USER_NAME', p_app_user_resp_rec.user_name );
832: FND_MSG_PUB.Add;
833: END IF;
834: x_loading_status := 'CN_CALC_USER_NOT_EXIST';

Line 831: fnd_message.set_token('USER_NAME', p_app_user_resp_rec.user_name );

827: end if;
828:
829: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
830: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_USER_NOT_EXIST');
831: fnd_message.set_token('USER_NAME', p_app_user_resp_rec.user_name );
832: FND_MSG_PUB.Add;
833: END IF;
834: x_loading_status := 'CN_CALC_USER_NOT_EXIST';
835: RAISE FND_API.G_EXC_ERROR ;

Line 864: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_RESP_NOT_EXIST');

860: WHERE responsibility_name = p_app_user_resp_rec.responsibility_name;
861:
862: EXCEPTION
863: WHEN no_data_found THEN
864: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_RESP_NOT_EXIST');
865: fnd_message.set_token('RESP_NAME', p_app_user_resp_rec.responsibility_name );
866: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
867: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
868: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.validation',

Line 865: fnd_message.set_token('RESP_NAME', p_app_user_resp_rec.responsibility_name );

861:
862: EXCEPTION
863: WHEN no_data_found THEN
864: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_RESP_NOT_EXIST');
865: fnd_message.set_token('RESP_NAME', p_app_user_resp_rec.responsibility_name );
866: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
867: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
868: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.validation',
869: TRUE);

Line 873: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_RESP_NOT_EXIST');

869: TRUE);
870: end if;
871:
872: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
873: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_RESP_NOT_EXIST');
874: fnd_message.set_token('RESP_NAME', p_app_user_resp_rec.responsibility_name );
875: FND_MSG_PUB.Add;
876: END IF;
877: x_loading_status := 'CN_CALC_RESP_NOT_EXIST';

Line 874: fnd_message.set_token('RESP_NAME', p_app_user_resp_rec.responsibility_name );

870: end if;
871:
872: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
873: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_RESP_NOT_EXIST');
874: fnd_message.set_token('RESP_NAME', p_app_user_resp_rec.responsibility_name );
875: FND_MSG_PUB.Add;
876: END IF;
877: x_loading_status := 'CN_CALC_RESP_NOT_EXIST';
878: RAISE FND_API.G_EXC_ERROR ;

Line 1371: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_FAIL_LOG');

1367:
1368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1369: THEN
1370: IF l_calc_sub_status = 'FAILED' THEN
1371: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_FAIL_LOG');
1372: fnd_message.set_token( 'AUDIT_ID', To_char(l_process_audit_id) );
1373: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1374: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1375: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.error',

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

1368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1369: THEN
1370: IF l_calc_sub_status = 'FAILED' THEN
1371: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_FAIL_LOG');
1372: fnd_message.set_token( 'AUDIT_ID', To_char(l_process_audit_id) );
1373: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1374: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1375: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.error',
1376: false);

Line 1381: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_OK_LOG');

1377: end if;
1378:
1379: x_loading_status := 'ALL_PROCESS_DONE_FAIL_LOG';
1380: ELSIF l_calc_sub_status = 'COMPLETE' THEN
1381: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_OK_LOG');
1382: fnd_message.set_token( 'AUDIT_ID', To_char(l_process_audit_id) );
1383: x_loading_status := 'ALL_PROCESS_DONE_OK_LOG';
1384: END IF;
1385:

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

1378:
1379: x_loading_status := 'ALL_PROCESS_DONE_FAIL_LOG';
1380: ELSIF l_calc_sub_status = 'COMPLETE' THEN
1381: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_OK_LOG');
1382: fnd_message.set_token( 'AUDIT_ID', To_char(l_process_audit_id) );
1383: x_loading_status := 'ALL_PROCESS_DONE_OK_LOG';
1384: END IF;
1385:
1386: FND_MSG_PUB.Add;

Line 1739: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

1735: 'Validated org_id = ' || g_org_id || ' status = '||l_status);
1736: end if;
1737:
1738: if (nvl(p_calc_submission_rec_new.org_id, g_org_id) <> nvl(p_calc_submission_rec_old.org_id, g_org_id)) then
1739: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1740: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1741: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1742: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
1743: true);

Line 1747: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

1743: true);
1744: end if;
1745:
1746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1747: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1748: FND_MSG_PUB.Add;
1749: END IF;
1750:
1751: RAISE FND_API.G_EXC_ERROR ;

Line 1819: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_EXIST');

1815: FETCH l_calc_sub_batch_csr INTO l_calc_sub_batch_rec;
1816:
1817: IF l_calc_sub_batch_csr%notfound THEN
1818: CLOSE l_calc_sub_batch_csr;
1819: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_EXIST');
1820: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );
1821: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1822: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1823: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',

Line 1820: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );

1816:
1817: IF l_calc_sub_batch_csr%notfound THEN
1818: CLOSE l_calc_sub_batch_csr;
1819: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_EXIST');
1820: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );
1821: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1822: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1823: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
1824: true);

Line 1829: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_EXIST');

1825: end if;
1826:
1827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1828: THEN
1829: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_EXIST');
1830: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );
1831: FND_MSG_PUB.Add;
1832: END IF;
1833:

Line 1830: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );

1826:
1827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1828: THEN
1829: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_EXIST');
1830: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );
1831: FND_MSG_PUB.Add;
1832: END IF;
1833:
1834: x_loading_status := 'CN_CALC_SUB_NOT_EXIST';

Line 1841: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_UPDATEABLE');

1837:
1838: CLOSE l_calc_sub_batch_csr;
1839:
1840: IF l_calc_sub_batch_rec.status = 'COMPLETE' OR l_calc_sub_batch_rec.status = 'PROCESSING' THEN
1841: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_UPDATEABLE');
1842: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );
1843: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1844: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1845: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',

Line 1842: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );

1838: CLOSE l_calc_sub_batch_csr;
1839:
1840: IF l_calc_sub_batch_rec.status = 'COMPLETE' OR l_calc_sub_batch_rec.status = 'PROCESSING' THEN
1841: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_UPDATEABLE');
1842: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );
1843: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1844: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1845: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
1846: true);

Line 1851: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_UPDATEABLE');

1847: end if;
1848:
1849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1850: THEN
1851: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_UPDATEABLE');
1852: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );
1853: FND_MSG_PUB.Add;
1854: END IF;
1855:

Line 1852: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );

1848:
1849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1850: THEN
1851: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_NOT_UPDATEABLE');
1852: fnd_message.set_token ('BATCH_NAME', p_calc_submission_rec_old.batch_name );
1853: FND_MSG_PUB.Add;
1854: END IF;
1855:
1856: x_loading_status := 'CN_CALC_SUB_NOT_UPDATEABLE';

Line 2141: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SALESREP_EXISTS');

2137: p_created_by => g_created_by,
2138: p_last_update_login => g_last_update_login
2139: );
2140: ELSE
2141: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SALESREP_EXISTS');
2142: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_tbl(ctr).employee_number );
2143: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_tbl(ctr).TYPE );
2144: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 2142: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_tbl(ctr).employee_number );

2138: p_last_update_login => g_last_update_login
2139: );
2140: ELSE
2141: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SALESREP_EXISTS');
2142: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_tbl(ctr).employee_number );
2143: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_tbl(ctr).TYPE );
2144: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
2146: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',

Line 2143: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_tbl(ctr).TYPE );

2139: );
2140: ELSE
2141: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SALESREP_EXISTS');
2142: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_tbl(ctr).employee_number );
2143: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_tbl(ctr).TYPE );
2144: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
2146: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
2147: true);

Line 2152: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SALESREP_EXISTS');

2148: end if;
2149:
2150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2151: THEN
2152: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SALESREP_EXISTS');
2153: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_tbl(ctr).employee_number );
2154: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_tbl(ctr).TYPE );
2155: FND_MSG_PUB.Add;
2156: END IF;

Line 2153: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_tbl(ctr).employee_number );

2149:
2150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2151: THEN
2152: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SALESREP_EXISTS');
2153: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_tbl(ctr).employee_number );
2154: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_tbl(ctr).TYPE );
2155: FND_MSG_PUB.Add;
2156: END IF;
2157: END IF;

Line 2154: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_tbl(ctr).TYPE );

2150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2151: THEN
2152: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SALESREP_EXISTS');
2153: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NUMBER', p_salesrep_tbl(ctr).employee_number );
2154: FND_MESSAGE.SET_TOKEN('EMPLOYEE_TYPE', p_salesrep_tbl(ctr).TYPE );
2155: FND_MSG_PUB.Add;
2156: END IF;
2157: END IF;
2158: END LOOP;

Line 2178: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_NO_SALESREP');

2174:
2175: IF l_salesrep_count_csr%notfound THEN
2176: CLOSE l_salesrep_count_csr;
2177:
2178: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_NO_SALESREP');
2179: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2180: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
2181: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
2182: true);

Line 2186: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_NO_SALESREP');

2182: true);
2183: end if;
2184:
2185: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2186: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_NO_SALESREP');
2187: FND_MSG_PUB.Add;
2188: END IF;
2189: x_loading_status := 'CN_CALC_NO_SALESREP';
2190: RAISE FND_API.g_exc_error;

Line 2220: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_QUOTA_EXISTS');

2216: p_created_by => g_created_by,
2217: p_last_update_login => g_last_update_login
2218: );
2219: ELSE
2220: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_QUOTA_EXISTS');
2221: fnd_message.set_token( 'QUOTA_NAME', p_bonus_pe_tbl(ctr) );
2222: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2223: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
2224: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',

Line 2221: fnd_message.set_token( 'QUOTA_NAME', p_bonus_pe_tbl(ctr) );

2217: p_last_update_login => g_last_update_login
2218: );
2219: ELSE
2220: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_QUOTA_EXISTS');
2221: fnd_message.set_token( 'QUOTA_NAME', p_bonus_pe_tbl(ctr) );
2222: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2223: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
2224: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
2225: true);

Line 2230: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_QUOTA_EXISTS');

2226: end if;
2227:
2228: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2229: THEN
2230: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_QUOTA_EXISTS');
2231: fnd_message.set_token( 'QUOTA_NAME', p_bonus_pe_tbl(ctr) );
2232: FND_MSG_PUB.Add;
2233: END IF;
2234: END IF;

Line 2231: fnd_message.set_token( 'QUOTA_NAME', p_bonus_pe_tbl(ctr) );

2227:
2228: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2229: THEN
2230: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_QUOTA_EXISTS');
2231: fnd_message.set_token( 'QUOTA_NAME', p_bonus_pe_tbl(ctr) );
2232: FND_MSG_PUB.Add;
2233: END IF;
2234: END IF;
2235: END LOOP;

Line 2279: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_FAIL_LOG');

2275:
2276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2277: THEN
2278: IF l_calc_sub_status = 'FAILED' THEN
2279: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_FAIL_LOG');
2280: fnd_message.set_token( 'AUDIT_ID', To_char(l_process_audit_id) );
2281: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2282: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
2283: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',

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

2276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2277: THEN
2278: IF l_calc_sub_status = 'FAILED' THEN
2279: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_FAIL_LOG');
2280: fnd_message.set_token( 'AUDIT_ID', To_char(l_process_audit_id) );
2281: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2282: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
2283: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
2284: false);

Line 2289: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_OK_LOG');

2285: end if;
2286:
2287: x_loading_status := 'ALL_PROCESS_DONE_FAIL_LOG';
2288: ELSIF l_calc_sub_status = 'COMPLETE' THEN
2289: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_OK_LOG');
2290: fnd_message.set_token( 'AUDIT_ID', To_char(l_process_audit_id) );
2291: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2292: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
2293: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',

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

2286:
2287: x_loading_status := 'ALL_PROCESS_DONE_FAIL_LOG';
2288: ELSIF l_calc_sub_status = 'COMPLETE' THEN
2289: FND_MESSAGE.SET_NAME ('CN' , 'ALL_PROCESS_DONE_OK_LOG');
2290: fnd_message.set_token( 'AUDIT_ID', To_char(l_process_audit_id) );
2291: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2292: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
2293: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
2294: false);