DBA Data[Home] [Help]

APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_CALC_SUBMISSION_PVT

Line 1: PACKAGE BODY CN_CALC_SUBMISSION_PVT AS

1: PACKAGE BODY CN_CALC_SUBMISSION_PVT AS
2: /*$Header: cnvsbcsb.pls 120.5 2006/05/25 01:40:33 ymao ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_SUBMISSION_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_SUBMISSION_PVT';

1: PACKAGE BODY CN_CALC_SUBMISSION_PVT AS
2: /*$Header: cnvsbcsb.pls 120.5 2006/05/25 01:40:33 ymao ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_SUBMISSION_PVT';
5:
6: TYPE sub_batch_rec_type IS RECORD
7: (name cn_calc_submission_batches.name%TYPE,
8: org_id cn_calc_submission_batches.org_id%TYPE,

Line 76: 'cn.plsql.cn_calc_submission_pvt.check_end_of_interval.exception',

72: EXCEPTION
73: WHEN OTHERS THEN
74: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
75: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
76: 'cn.plsql.cn_calc_submission_pvt.check_end_of_interval.exception',
77: sqlerrm);
78: end if;
79: raise ;
80: END check_end_of_interval;

Line 168: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

164: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
165: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
166: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
167: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
168: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
169: TRUE);
170: end if;
171:
172: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 187: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

183: FND_MESSAGE.SET_NAME ('CN' , 'CN_CALC_SUB_EXISTS');
184: fnd_message.set_token('BATCH_NAME', cn_api.get_lkup_meaning('NAME', 'CALC_SUBMISSION_OBJECT_TYPE'));
185: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
186: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
187: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
188: TRUE);
189: end if;
190:
191: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 205: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

201: IF (p_sub_batch_rec.start_date IS NULL) THEN
202: fnd_message.set_name('CN', 'CN_START_DATE_CANNOT_NULL');
203: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
204: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
205: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
206: TRUE);
207: end if;
208:
209: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 219: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

215: IF (p_sub_batch_rec.end_date IS NULL) THEN
216: fnd_message.set_name('CN', 'CN_END_DATE_CANNOT_NULL');
217: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
218: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
219: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
220: TRUE);
221: end if;
222:
223: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 233: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

229: IF (p_sub_batch_rec.start_date > p_sub_batch_rec.end_date) THEN
230: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
231: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
232: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
233: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
234: TRUE);
235: end if;
236:
237: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 252: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

248: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
249: fnd_message.set_token('DATE', p_sub_batch_rec.start_date);
250: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
251: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
252: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
253: TRUE);
254: end if;
255:
256: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 271: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

267: fnd_message.set_name('CN' , 'CN_CALC_SUB_OPEN_DATE');
268: fnd_message.set_token('DATE', p_sub_batch_rec.end_date);
269: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
270: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
271: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
272: TRUE);
273: end if;
274:
275: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 290: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

286: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
287: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
288: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
289: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
290: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
291: TRUE);
292: end if;
293:
294: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 306: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

302: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
303: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CALC_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
304: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
305: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
306: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
307: TRUE);
308: end if;
309:
310: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 324: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

320: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
321: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));
322: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
323: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
324: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
325: TRUE);
326: end if;
327:
328: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 342: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

338: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
339: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('SALESREP_OPTION', 'CALC_SUBMISSION_OBJECT_TYPE'));
340: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
341: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
342: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
343: TRUE);
344: end if;
345:
346: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 361: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

357: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
358: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
359: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
360: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
361: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
362: TRUE);
363: end if;
364:
365: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 379: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

375: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
376: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('HIERARCHY_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
377: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
378: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
379: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
380: TRUE);
381: end if;
382:
383: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 397: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

393: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
394: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
395: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
396: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
397: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
398: TRUE);
399: end if;
400:
401: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 413: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

409: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
410: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('CONCURRENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
411: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
412: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
413: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
414: TRUE);
415: end if;
416:
417: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 431: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

427: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
428: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
429: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
430: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
431: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
432: TRUE);
433: end if;
434:
435: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 450: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

446: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
447: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTELLIGENT_FLAG', 'CALC_SUBMISSION_OBJECT_TYPE'));
448: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
449: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
450: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
451: TRUE);
452: end if;
453:
454: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 469: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

465: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
466: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
467: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
468: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
469: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
470: TRUE);
471: end if;
472:
473: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 485: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

481: fnd_message.set_name('CN' , 'CN_INVALID_DATA');
482: fnd_message.set_token('OBJ_NAME', cn_api.get_lkup_meaning('INTERVAL_TYPE', 'CALC_SUBMISSION_OBJECT_TYPE'));
483: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
484: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
485: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
486: TRUE);
487: end if;
488:
489: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 504: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

500: IF (p_rep_entry_tbl.COUNT = 0) THEN
501: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');
502: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
503: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
504: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
505: TRUE);
506: end if;
507:
508: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 528: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

524: IF (l_dummy = 0) THEN
525: fnd_message.set_name('CN' , 'CN_CALC_NO_SALESREP');
526: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
527: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
528: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
529: TRUE);
530: end if;
531:
532: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 551: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

547: fnd_message.set_name('CN', 'CN_CALC_SALESREP_EXIST');
548: fnd_message.set_token('NAME', p_rep_entry_tbl(i).name);
549: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
550: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
551: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
552: TRUE);
553: end if;
554:
555: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 579: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',

575: fnd_message.set_name('CN', 'CN_CALC_PE_NO_MATCH');
576: fnd_message.set_token('QUOTA_NAME', l_quota_name);
577: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
578: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
579: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.error',
580: TRUE);
581: end if;
582:
583: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

Line 627: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.exception',

623: p_encoded => FND_API.G_FALSE );
624:
625: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
626: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
627: 'cn.plsql.cn_calc_submission_pvt.validate_submission_records.exception',
628: sqlerrm);
629: end if;
630: END validate_submission_records;
631:

Line 824: 'cn.plsql.cn_calc_submission_pvt.maintain_batch_status.exception',

820: EXCEPTION
821: WHEN OTHERS THEN
822: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
823: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
824: 'cn.plsql.cn_calc_submission_pvt.maintain_batch_status.exception',
825: sqlerrm);
826: end if;
827: END maintain_batch_status;
828:

Line 870: 'cn.plsql.cn_calc_submission_pvt.validate.begin',

866:
867: -- API body
868: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
870: 'cn.plsql.cn_calc_submission_pvt.validate.begin',
871: 'Beginning of validate...' );
872: end if;
873:
874: get_submission_batch

Line 901: 'cn.plsql.cn_calc_submission_pvt.validate.error',

897: fnd_message.set_name('CN', 'CNSBCS_INCOMPLETE_PLAN');
898: fnd_msg_pub.add;
899: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
900: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
901: 'cn.plsql.cn_calc_submission_pvt.validate.error',
902: FALSE);
903: end if;
904:
905: END IF;

Line 921: 'cn.plsql.cn_calc_submission_pvt.validate.end',

917: p_encoded => FND_API.G_FALSE );
918:
919: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
920: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
921: 'cn.plsql.cn_calc_submission_pvt.validate.end',
922: 'End of validate.' );
923: end if;
924:
925: EXCEPTION

Line 952: 'cn.plsql.cn_calc_submission_pvt.validate.exception',

948: p_encoded => FND_API.G_FALSE );
949:
950: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
951: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
952: 'cn.plsql.cn_calc_submission_pvt.validate.exception',
953: sqlerrm);
954: end if;
955:
956: END Validate;

Line 996: 'cn.plsql.cn_calc_submission_pvt.calculate.begin',

992:
993: -- API body
994: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
995: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
996: 'cn.plsql.cn_calc_submission_pvt.calculate.begin',
997: 'Beginning of calculate...' );
998: end if;
999:
1000: validate

Line 1044: 'cn.plsql.cn_calc_submission_pvt.calculate.end',

1040: fnd_msg_pub.ADD;
1041:
1042: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1043: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1044: 'cn.plsql.cn_calc_submission_pvt.calculate.end',
1045: 'End of calculate' );
1046: end if;
1047:
1048: -- Standard call to get message count and if count is 1, get message info.

Line 1142: 'cn.plsql.cn_calc_submission_pvt.copybatch.begin',

1138:
1139: -- Body Begins.
1140: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1142: 'cn.plsql.cn_calc_submission_pvt.copybatch.begin',
1143: 'Beginning of copybatch ...' );
1144: end if;
1145:
1146: select CN_CALC_SUBMISSION_BATCHES_S1.nextval into seq_batchid from dual;

Line 1274: 'cn.plsql.cn_calc_submission_pvt.copybatch.end',

1270: END IF;
1271:
1272: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1274: 'cn.plsql.cn_calc_submission_pvt.copybatch.end',
1275: 'End of copybatch' );
1276: end if;
1277: EXCEPTION
1278: WHEN FND_API.G_EXC_ERROR THEN

Line 1307: 'cn.plsql.cn_calc_submission_pvt.CopyBatch.exception',

1303: p_encoded => FND_API.G_FALSE );
1304:
1305: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1306: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1307: 'cn.plsql.cn_calc_submission_pvt.CopyBatch.exception',
1308: sqlerrm);
1309: end if;
1310:
1311: END CopyBatch;

Line 1313: END CN_CALC_SUBMISSION_PVT;

1309: end if;
1310:
1311: END CopyBatch;
1312:
1313: END CN_CALC_SUBMISSION_PVT;