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_LOG

Line 84: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

80: FROM cn_calc_submission_batches_all
81: WHERE name = p_calc_submission_rec.batch_name
82: AND org_id = g_org_id;
83: BEGIN
84: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
85: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
86: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.begin',
87: 'Beginning of validate_calc_sub_batch ...');
88: end if;

Line 85: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

81: WHERE name = p_calc_submission_rec.batch_name
82: AND org_id = g_org_id;
83: BEGIN
84: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
85: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
86: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.begin',
87: 'Beginning of validate_calc_sub_batch ...');
88: end if;
89:

Line 114: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 115: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
118: end if;
119:

Line 151: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 152: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
155: end if;
156:

Line 174: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 175: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
178: end if;
179:

Line 202: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 203: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
206: end if;
207:

Line 232: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 233: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
236: end if;
237:

Line 262: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 263: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
266: end if;
267:

Line 289: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 290: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
293: end if;
294:

Line 321: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 322: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
325: end if;
326:

Line 349: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 350: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
353: end if;
354:

Line 374: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

370: p_data => x_msg_data ,
371: p_encoded => FND_API.G_FALSE
372: );
373:
374: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
375: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
376: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.end',
377: 'End of validate_calc_sub_batch.');
378: end if;

Line 375: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

371: p_encoded => FND_API.G_FALSE
372: );
373:
374: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
375: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
376: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.end',
377: 'End of validate_calc_sub_batch.');
378: end if;
379:

Line 412: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

408: p_data => x_msg_data ,
409: p_encoded => FND_API.G_FALSE
410: );
411:
412: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
413: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
414: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.exception',
415: sqlerrm);
416: end if;

Line 413: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

409: p_encoded => FND_API.G_FALSE
410: );
411:
412: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
413: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
414: 'cn.plsql.cn_calc_submission_pub.validate_calc_sub_batch.exception',
415: sqlerrm);
416: end if;
417:

Line 457: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 458: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
461: end if;
462:

Line 493: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 494: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
497: end if;
498:

Line 540: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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);
544: end if;

Line 541: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
544: end if;
545:

Line 582: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

578: l_loading_status VARCHAR2(100);
579:
580: l_salesrep_id NUMBER;
581: BEGIN
582: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
584: 'cn.plsql.cn_calc_submission_pub.validate_salesrep_entries.begin',
585: 'Beginning of validate_salesrep_entries ...');
586: end if;

Line 583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

579:
580: l_salesrep_id NUMBER;
581: BEGIN
582: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
584: 'cn.plsql.cn_calc_submission_pub.validate_salesrep_entries.begin',
585: 'Beginning of validate_salesrep_entries ...');
586: end if;
587:

Line 596: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 597: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
600: end if;
601:

Line 629: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

625: p_data => x_msg_data ,
626: p_encoded => FND_API.G_FALSE
627: );
628:
629: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
630: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
631: 'cn.plsql.cn_calc_submission_pub.validate_salesrep_entries.end',
632: 'End of validate_salesrep_entries.');
633: end if;

Line 630: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

626: p_encoded => FND_API.G_FALSE
627: );
628:
629: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
630: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
631: 'cn.plsql.cn_calc_submission_pub.validate_salesrep_entries.end',
632: 'End of validate_salesrep_entries.');
633: end if;
634:

Line 667: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

663: p_data => x_msg_data ,
664: p_encoded => FND_API.G_FALSE
665: );
666:
667: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
668: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
669: 'cn.plsql.cn_calc_submission_pub.validate_salesrep_entries.exception',
670: sqlerrm);
671: end if;

Line 668: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

664: p_encoded => FND_API.G_FALSE
665: );
666:
667: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
668: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
669: 'cn.plsql.cn_calc_submission_pub.validate_salesrep_entries.exception',
670: sqlerrm);
671: end if;
672:

Line 697: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

693: l_loading_status VARCHAR2(100);
694:
695: l_quota_id NUMBER;
696: BEGIN
697: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
699: 'cn.plsql.cn_calc_submission_pub.validate_bonus_pe_entries.begin',
700: 'Beginning of validate_bonus_pe_entries ...');
701: end if;

Line 698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

694:
695: l_quota_id NUMBER;
696: BEGIN
697: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
699: 'cn.plsql.cn_calc_submission_pub.validate_bonus_pe_entries.begin',
700: 'Beginning of validate_bonus_pe_entries ...');
701: end if;
702:

Line 728: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

724: p_data => x_msg_data ,
725: p_encoded => FND_API.G_FALSE
726: );
727:
728: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
729: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
730: 'cn.plsql.cn_calc_submission_pub.validate_bonus_pe_entries.end',
731: 'End of validate_bonus_pe_entries.');
732: end if;

Line 729: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

725: p_encoded => FND_API.G_FALSE
726: );
727:
728: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
729: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
730: 'cn.plsql.cn_calc_submission_pub.validate_bonus_pe_entries.end',
731: 'End of validate_bonus_pe_entries.');
732: end if;
733:

Line 766: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

762: p_data => x_msg_data ,
763: p_encoded => FND_API.G_FALSE
764: );
765:
766: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
767: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
768: 'cn.plsql.cn_calc_submission_pub.validate_bonus_pe_entries.exception',
769: sqlerrm);
770: end if;

Line 767: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

763: p_encoded => FND_API.G_FALSE
764: );
765:
766: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
767: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
768: 'cn.plsql.cn_calc_submission_pub.validate_bonus_pe_entries.exception',
769: sqlerrm);
770: end if;
771:

Line 793: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

789: l_api_name CONSTANT VARCHAR2(30) := 'validate_app_user_resp';
790: l_loading_status VARCHAR2(100);
791:
792: BEGIN
793: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
794: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
795: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.begin',
796: 'Beginning of validate_app_user_resp ...');
797: end if;

Line 794: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

790: l_loading_status VARCHAR2(100);
791:
792: BEGIN
793: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
794: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
795: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.begin',
796: 'Beginning of validate_app_user_resp ...');
797: end if;
798:

Line 823: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 824: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
827: end if;
828:

Line 837: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

833: END IF;
834: x_loading_status := 'CN_CALC_USER_NOT_EXIST';
835: RAISE FND_API.G_EXC_ERROR ;
836: WHEN OTHERS THEN
837: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
838: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
839: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.exception',
840: sqlerrm);
841: end if;

Line 838: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

834: x_loading_status := 'CN_CALC_USER_NOT_EXIST';
835: RAISE FND_API.G_EXC_ERROR ;
836: WHEN OTHERS THEN
837: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
838: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
839: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.exception',
840: sqlerrm);
841: end if;
842:

Line 866: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 867: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
870: end if;
871:

Line 881: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

877: x_loading_status := 'CN_CALC_RESP_NOT_EXIST';
878: RAISE FND_API.G_EXC_ERROR ;
879:
880: WHEN OTHERS THEN
881: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
882: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
883: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.exception',
884: sqlerrm);
885: end if;

Line 882: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

878: RAISE FND_API.G_EXC_ERROR ;
879:
880: WHEN OTHERS THEN
881: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
882: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
883: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.exception',
884: sqlerrm);
885: end if;
886:

Line 899: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

895: p_data => x_msg_data ,
896: p_encoded => FND_API.G_FALSE
897: );
898:
899: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
901: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.end',
902: 'End of validate_app_user_resp.');
903: end if;

Line 900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

896: p_encoded => FND_API.G_FALSE
897: );
898:
899: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
900: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
901: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.end',
902: 'End of validate_app_user_resp.');
903: end if;
904:

Line 937: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

933: p_data => x_msg_data ,
934: p_encoded => FND_API.G_FALSE
935: );
936:
937: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
938: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
939: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.exception',
940: sqlerrm);
941: end if;

Line 938: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

934: p_encoded => FND_API.G_FALSE
935: );
936:
937: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
938: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
939: 'cn.plsql.cn_calc_submission_pub.validate_app_user_resp.exception',
940: sqlerrm);
941: end if;
942:

Line 1069: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1065: l_bind_data_id NUMBER;
1066:
1067: l_status VARCHAR2(30);
1068: BEGIN
1069: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1070: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1071: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.begin',
1072: 'Beginning of create_calc_submission ...');
1073: end if;

Line 1070: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1066:
1067: l_status VARCHAR2(30);
1068: BEGIN
1069: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1070: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1071: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.begin',
1072: 'Beginning of create_calc_submission ...');
1073: end if;
1074:

Line 1128: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1124: g_org_id := p_calc_submission_rec.org_id;
1125: mo_global.validate_orgid_pub_api(org_id => g_org_id,
1126: status => l_status);
1127:
1128: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1129: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1130: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.org_validate',
1131: 'Validated org_id = ' || g_org_id || ' status = '||l_status);
1132: end if;

Line 1129: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1125: mo_global.validate_orgid_pub_api(org_id => g_org_id,
1126: status => l_status);
1127:
1128: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1129: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1130: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.org_validate',
1131: 'Validated org_id = ' || g_org_id || ' status = '||l_status);
1132: end if;
1133:

Line 1373: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 1374: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
1377: end if;
1378:

Line 1481: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1477: p_data => x_msg_data ,
1478: p_encoded => FND_API.G_FALSE
1479: );
1480:
1481: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1483: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.end',
1484: 'End of create_calc_submission.');
1485: end if;

Line 1482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1478: p_encoded => FND_API.G_FALSE
1479: );
1480:
1481: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1483: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.end',
1484: 'End of create_calc_submission.');
1485: end if;
1486:

Line 1522: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1518: p_data => x_msg_data ,
1519: p_encoded => FND_API.G_FALSE
1520: );
1521:
1522: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1523: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1524: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.exception',
1525: sqlerrm);
1526: end if;

Line 1523: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1519: p_encoded => FND_API.G_FALSE
1520: );
1521:
1522: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1523: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1524: 'cn.plsql.cn_calc_submission_pub.create_calc_submission.exception',
1525: sqlerrm);
1526: end if;
1527:

Line 1677: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1673:
1674: l_bind_data_id NUMBER;
1675:
1676: BEGIN
1677: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1678: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1679: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.begin',
1680: 'Beginning of update_calc_submission ...');
1681: end if;

Line 1678: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1674: l_bind_data_id NUMBER;
1675:
1676: BEGIN
1677: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1678: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1679: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.begin',
1680: 'Beginning of update_calc_submission ...');
1681: end if;
1682:

Line 1732: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1728: g_org_id := p_calc_submission_rec_old.org_id;
1729: mo_global.validate_orgid_pub_api(org_id => g_org_id,
1730: status => l_status);
1731:
1732: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1734: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.org_validate',
1735: 'Validated org_id = ' || g_org_id || ' status = '||l_status);
1736: end if;

Line 1733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1729: mo_global.validate_orgid_pub_api(org_id => g_org_id,
1730: status => l_status);
1731:
1732: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1734: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.org_validate',
1735: 'Validated org_id = ' || g_org_id || ' status = '||l_status);
1736: end if;
1737:

Line 1740: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 1741: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
1744: end if;
1745:

Line 1821: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 1822: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
1825: end if;
1826:

Line 1843: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 1844: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
1847: end if;
1848:

Line 2144: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 2145: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
2148: end if;
2149:

Line 2179: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 2180: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
2183: end if;
2184:

Line 2222: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 2223: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
2226: end if;
2227:

Line 2281: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 2282: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
2285: end if;
2286:

Line 2291: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 2292: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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);
2295: end if;
2296:

Line 2402: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2398: p_data => x_msg_data ,
2399: p_encoded => FND_API.G_FALSE
2400: );
2401:
2402: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2404: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.end',
2405: 'End of update_calc_submission.');
2406: end if;

Line 2403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2399: p_encoded => FND_API.G_FALSE
2400: );
2401:
2402: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2404: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.end',
2405: 'End of update_calc_submission.');
2406: end if;
2407:

Line 2443: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2439: p_data => x_msg_data ,
2440: p_encoded => FND_API.G_FALSE
2441: );
2442:
2443: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2444: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2445: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.exception',
2446: sqlerrm);
2447: end if;

Line 2444: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

2440: p_encoded => FND_API.G_FALSE
2441: );
2442:
2443: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2444: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2445: 'cn.plsql.cn_calc_submission_pub.update_calc_submission.exception',
2446: sqlerrm);
2447: end if;
2448: