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_MSG_PUB

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

116: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
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;

Line 123: FND_MSG_PUB.Add;

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';
127: RAISE FND_API.G_EXC_ERROR ;

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

153: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
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;

Line 160: FND_MSG_PUB.Add;

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';
164: RAISE FND_API.G_EXC_ERROR ;

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

176: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
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;

Line 183: FND_MSG_PUB.Add;

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';
187: RAISE FND_API.G_EXC_ERROR ;

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

204: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
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;

Line 211: FND_MSG_PUB.Add;

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

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

234: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
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;

Line 241: FND_MSG_PUB.Add;

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

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

264: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
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;

Line 271: FND_MSG_PUB.Add;

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

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

291: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
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;

Line 298: FND_MSG_PUB.Add;

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

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

323: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
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;

Line 330: FND_MSG_PUB.Add;

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

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

351: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.error',
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;

Line 358: FND_MSG_PUB.Add;

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

Line 368: FND_MSG_PUB.Count_And_Get

364:
365: -- End of API body.
366:
367: -- Standard call to get message count and if count is 1, get message info.
368: FND_MSG_PUB.Count_And_Get
369: (p_count => x_msg_count ,
370: p_data => x_msg_data ,
371: p_encoded => FND_API.G_FALSE
372: );

Line 383: FND_MSG_PUB.Count_And_Get

379:
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_ERROR ;
383: FND_MSG_PUB.Count_And_Get
384: (
385: p_count => x_msg_count ,
386: p_data => x_msg_data ,
387: p_encoded => FND_API.G_FALSE

Line 392: FND_MSG_PUB.Count_And_Get

388: );
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: x_loading_status := 'UNEXPECTED_ERR';
392: FND_MSG_PUB.Count_And_Get
393: (
394: p_count => x_msg_count ,
395: p_data => x_msg_data ,
396: p_encoded => FND_API.G_FALSE

Line 401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

397: );
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: x_loading_status := 'UNEXPECTED_ERR';
401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
404: END IF;
405: FND_MSG_PUB.Count_And_Get

Line 403: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: x_loading_status := 'UNEXPECTED_ERR';
401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
404: END IF;
405: FND_MSG_PUB.Count_And_Get
406: (
407: p_count => x_msg_count ,

Line 405: FND_MSG_PUB.Count_And_Get

401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
404: END IF;
405: FND_MSG_PUB.Count_And_Get
406: (
407: p_count => x_msg_count ,
408: p_data => x_msg_data ,
409: p_encoded => FND_API.G_FALSE

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

459: 'cn.plsql.cn_calc_submission_pub.validate_salesrep.error',
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;

Line 466: FND_MSG_PUB.Add;

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;
470:

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

495: 'cn.plsql.cn_calc_submission_pub.validate_salesrep.error',
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;

Line 503: FND_MSG_PUB.Add;

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';
507: RETURN FALSE;

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

542: 'cn.plsql.cn_calc_submission_pub.validate_bonus_pe.error',
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;

Line 549: FND_MSG_PUB.Add;

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';
553: RETURN FALSE;

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

598: 'cn.plsql.cn_calc_submission_pub.validate_salesrep_entries.error',
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';

Line 604: FND_MSG_PUB.Add;

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;
608: ELSE

Line 623: FND_MSG_PUB.Count_And_Get

619:
620: -- End of API body.
621:
622: -- Standard call to get message count and if count is 1, get message info.
623: FND_MSG_PUB.Count_And_Get
624: (p_count => x_msg_count ,
625: p_data => x_msg_data ,
626: p_encoded => FND_API.G_FALSE
627: );

Line 638: FND_MSG_PUB.Count_And_Get

634:
635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: x_return_status := FND_API.G_RET_STS_ERROR ;
638: FND_MSG_PUB.Count_And_Get
639: (
640: p_count => x_msg_count ,
641: p_data => x_msg_data ,
642: p_encoded => FND_API.G_FALSE

Line 647: FND_MSG_PUB.Count_And_Get

643: );
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
646: x_loading_status := 'UNEXPECTED_ERR';
647: FND_MSG_PUB.Count_And_Get
648: (
649: p_count => x_msg_count ,
650: p_data => x_msg_data ,
651: p_encoded => FND_API.G_FALSE

Line 656: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

652: );
653: WHEN OTHERS THEN
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: x_loading_status := 'UNEXPECTED_ERR';
656: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
657: THEN
658: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
659: END IF;
660: FND_MSG_PUB.Count_And_Get

Line 658: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: x_loading_status := 'UNEXPECTED_ERR';
656: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
657: THEN
658: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
659: END IF;
660: FND_MSG_PUB.Count_And_Get
661: (
662: p_count => x_msg_count ,

Line 660: FND_MSG_PUB.Count_And_Get

656: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
657: THEN
658: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
659: END IF;
660: FND_MSG_PUB.Count_And_Get
661: (
662: p_count => x_msg_count ,
663: p_data => x_msg_data ,
664: p_encoded => FND_API.G_FALSE

Line 722: FND_MSG_PUB.Count_And_Get

718:
719: -- End of API body.
720:
721: -- Standard call to get message count and if count is 1, get message info.
722: FND_MSG_PUB.Count_And_Get
723: (p_count => x_msg_count ,
724: p_data => x_msg_data ,
725: p_encoded => FND_API.G_FALSE
726: );

Line 737: FND_MSG_PUB.Count_And_Get

733:
734: EXCEPTION
735: WHEN FND_API.G_EXC_ERROR THEN
736: x_return_status := FND_API.G_RET_STS_ERROR ;
737: FND_MSG_PUB.Count_And_Get
738: (
739: p_count => x_msg_count ,
740: p_data => x_msg_data ,
741: p_encoded => FND_API.G_FALSE

Line 746: FND_MSG_PUB.Count_And_Get

742: );
743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: x_loading_status := 'UNEXPECTED_ERR';
746: FND_MSG_PUB.Count_And_Get
747: (
748: p_count => x_msg_count ,
749: p_data => x_msg_data ,
750: p_encoded => FND_API.G_FALSE

Line 755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

751: );
752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: x_loading_status := 'UNEXPECTED_ERR';
755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
756: THEN
757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
758: END IF;
759: FND_MSG_PUB.Count_And_Get

Line 757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: x_loading_status := 'UNEXPECTED_ERR';
755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
756: THEN
757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
758: END IF;
759: FND_MSG_PUB.Count_And_Get
760: (
761: p_count => x_msg_count ,

Line 759: FND_MSG_PUB.Count_And_Get

755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
756: THEN
757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
758: END IF;
759: FND_MSG_PUB.Count_And_Get
760: (
761: p_count => x_msg_count ,
762: p_data => x_msg_data ,
763: p_encoded => FND_API.G_FALSE

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

825: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.validation',
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;

Line 832: FND_MSG_PUB.Add;

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 ;
836: WHEN OTHERS THEN

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

868: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.validation',
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;

Line 875: FND_MSG_PUB.Add;

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 ;
879:

Line 893: FND_MSG_PUB.Count_And_Get

889:
890: -- End of API body.
891:
892: -- Standard call to get message count and if count is 1, get message info.
893: FND_MSG_PUB.Count_And_Get
894: (p_count => x_msg_count ,
895: p_data => x_msg_data ,
896: p_encoded => FND_API.G_FALSE
897: );

Line 908: FND_MSG_PUB.Count_And_Get

904:
905: EXCEPTION
906: WHEN FND_API.G_EXC_ERROR THEN
907: x_return_status := FND_API.G_RET_STS_ERROR ;
908: FND_MSG_PUB.Count_And_Get
909: (
910: p_count => x_msg_count ,
911: p_data => x_msg_data ,
912: p_encoded => FND_API.G_FALSE

Line 917: FND_MSG_PUB.Count_And_Get

913: );
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
916: x_loading_status := 'UNEXPECTED_ERR';
917: FND_MSG_PUB.Count_And_Get
918: (
919: p_count => x_msg_count ,
920: p_data => x_msg_data ,
921: p_encoded => FND_API.G_FALSE

Line 926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

922: );
923: WHEN OTHERS THEN
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: x_loading_status := 'UNEXPECTED_ERR';
926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
927: THEN
928: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
929: END IF;
930: FND_MSG_PUB.Count_And_Get

Line 928: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: x_loading_status := 'UNEXPECTED_ERR';
926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
927: THEN
928: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
929: END IF;
930: FND_MSG_PUB.Count_And_Get
931: (
932: p_count => x_msg_count ,

Line 930: FND_MSG_PUB.Count_And_Get

926: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
927: THEN
928: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
929: END IF;
930: FND_MSG_PUB.Count_And_Get
931: (
932: p_count => x_msg_count ,
933: p_data => x_msg_data ,
934: p_encoded => FND_API.G_FALSE

Line 1085: FND_MSG_PUB.initialize;

1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1082: END IF;
1083: -- Initialize message list if p_init_msg_list is set to TRUE.
1084: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1085: FND_MSG_PUB.initialize;
1086: END IF;
1087:
1088: -- Initialize API return status to success
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1364: END IF;
1365: END LOOP;
1366: END IF;
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) );

Line 1386: FND_MSG_PUB.Add;

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;
1387: END IF;
1388: END IF; -- p_commit;
1389:
1390: -- API return status to success

Line 1474: FND_MSG_PUB.Count_And_Get

1470: IF FND_API.To_Boolean( p_commit ) THEN
1471: COMMIT WORK;
1472: END IF;
1473: -- Standard call to get message count and if count is 1, get message info.
1474: FND_MSG_PUB.Count_And_Get
1475: (
1476: p_count => x_msg_count ,
1477: p_data => x_msg_data ,
1478: p_encoded => FND_API.G_FALSE

Line 1491: FND_MSG_PUB.Count_And_Get

1487: EXCEPTION
1488: WHEN FND_API.G_EXC_ERROR THEN
1489: ROLLBACK TO create_calc_submission;
1490: x_return_status := FND_API.G_RET_STS_ERROR ;
1491: FND_MSG_PUB.Count_And_Get
1492: (
1493: p_count => x_msg_count ,
1494: p_data => x_msg_data ,
1495: p_encoded => FND_API.G_FALSE

Line 1501: FND_MSG_PUB.Count_And_Get

1497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1498: ROLLBACK TO create_calc_submission;
1499: x_loading_status := 'UNEXPECTED_ERR';
1500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1501: FND_MSG_PUB.Count_And_Get
1502: (
1503: p_count => x_msg_count ,
1504: p_data => x_msg_data ,
1505: p_encoded => FND_API.G_FALSE

Line 1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1507: WHEN OTHERS THEN
1508: ROLLBACK TO create_calc_submission;
1509: x_loading_status := 'UNEXPECTED_ERR';
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1512: THEN
1513: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1514: END IF;
1515: FND_MSG_PUB.Count_And_Get

Line 1513: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1509: x_loading_status := 'UNEXPECTED_ERR';
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1512: THEN
1513: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1514: END IF;
1515: FND_MSG_PUB.Count_And_Get
1516: (
1517: p_count => x_msg_count ,

Line 1515: FND_MSG_PUB.Count_And_Get

1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1512: THEN
1513: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1514: END IF;
1515: FND_MSG_PUB.Count_And_Get
1516: (
1517: p_count => x_msg_count ,
1518: p_data => x_msg_data ,
1519: p_encoded => FND_API.G_FALSE

Line 1699: FND_MSG_PUB.initialize;

1695: END IF;
1696:
1697: -- Initialize message list if p_init_msg_list is set to TRUE.
1698: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1699: FND_MSG_PUB.initialize;
1700: END IF;
1701:
1702: -- Initialize API return status to success
1703: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1742: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
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:

Line 1748: FND_MSG_PUB.Add;

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 ;
1752: end if;

Line 1827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1823: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
1824: true);
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;

Line 1831: FND_MSG_PUB.Add;

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';
1835: RAISE FND_API.G_EXC_ERROR ;

Line 1849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1845: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
1846: true);
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;

Line 1853: FND_MSG_PUB.Add;

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';
1857: RAISE FND_API.G_EXC_ERROR ;

Line 2150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2146: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
2147: true);
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 );

Line 2155: FND_MSG_PUB.Add;

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;
2159: ELSIF p_salesrep_tbl_action = 'DELETE' THEN

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

2181: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
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';

Line 2187: FND_MSG_PUB.Add;

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;
2191: ELSE

Line 2228: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2224: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.error',
2225: true);
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;

Line 2232: FND_MSG_PUB.Add;

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;
2236: ELSIF p_bonus_pe_tbl_action = 'DELETE' THEN

Line 2276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2272: END IF;
2273: END LOOP;
2274: END IF;
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) );

Line 2300: FND_MSG_PUB.Add;

2296:
2297: x_loading_status := 'ALL_PROCESS_DONE_OK_LOG';
2298: END IF;
2299:
2300: FND_MSG_PUB.Add;
2301: END IF;
2302: END IF; -- p_commit;
2303:
2304: -- Initialize API return status to success

Line 2395: FND_MSG_PUB.Count_And_Get

2391:
2392: --+
2393: -- Standard call to get message count and if count is 1, get message info.
2394: --+
2395: FND_MSG_PUB.Count_And_Get
2396: (
2397: p_count => x_msg_count ,
2398: p_data => x_msg_data ,
2399: p_encoded => FND_API.G_FALSE

Line 2412: FND_MSG_PUB.Count_And_Get

2408: EXCEPTION
2409: WHEN FND_API.G_EXC_ERROR THEN
2410: ROLLBACK TO update_calc_submission;
2411: x_return_status := FND_API.G_RET_STS_ERROR ;
2412: FND_MSG_PUB.Count_And_Get
2413: (
2414: p_count => x_msg_count ,
2415: p_data => x_msg_data ,
2416: p_encoded => FND_API.G_FALSE

Line 2422: FND_MSG_PUB.Count_And_Get

2418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2419: ROLLBACK TO update_calc_submission;
2420: x_loading_status := 'UNEXPECTED_ERR';
2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2422: FND_MSG_PUB.Count_And_Get
2423: (
2424: p_count => x_msg_count ,
2425: p_data => x_msg_data ,
2426: p_encoded => FND_API.G_FALSE

Line 2432: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2428: WHEN OTHERS THEN
2429: ROLLBACK TO update_calc_submission;
2430: x_loading_status := 'UNEXPECTED_ERR';
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2432: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2435: END IF;
2436: FND_MSG_PUB.Count_And_Get

Line 2434: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

2430: x_loading_status := 'UNEXPECTED_ERR';
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2432: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2435: END IF;
2436: FND_MSG_PUB.Count_And_Get
2437: (
2438: p_count => x_msg_count ,

Line 2436: FND_MSG_PUB.Count_And_Get

2432: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
2435: END IF;
2436: FND_MSG_PUB.Count_And_Get
2437: (
2438: p_count => x_msg_count ,
2439: p_data => x_msg_data ,
2440: p_encoded => FND_API.G_FALSE