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_COMP_PLAN_XMLCOPY_PVT dependencies on FND_FILE

Line 47: fnd_file.put_line(fnd_file.log, '**************************************************************');

43: x_msg_count NUMBER;
44: x_msg_data VARCHAR2(240);
45:
46: BEGIN
47: fnd_file.put_line(fnd_file.log, '**************************************************************');
48: fnd_file.put_line(fnd_file.log, '******************* START - PLAN COPY IMPORT *****************');
49: fnd_file.put_line(fnd_file.log, '**************************************************************');
50:
51: -- Standard Start of API savepoint

Line 48: fnd_file.put_line(fnd_file.log, '*** START - PLAN COPY IMPORT *');

44: x_msg_data VARCHAR2(240);
45:
46: BEGIN
47: fnd_file.put_line(fnd_file.log, '**************************************************************');
48: fnd_file.put_line(fnd_file.log, '******************* START - PLAN COPY IMPORT *****************');
49: fnd_file.put_line(fnd_file.log, '**************************************************************');
50:
51: -- Standard Start of API savepoint
52: SAVEPOINT Import_PlanCopy;

Line 49: fnd_file.put_line(fnd_file.log, '**************************************************************');

45:
46: BEGIN
47: fnd_file.put_line(fnd_file.log, '**************************************************************');
48: fnd_file.put_line(fnd_file.log, '******************* START - PLAN COPY IMPORT *****************');
49: fnd_file.put_line(fnd_file.log, '**************************************************************');
50:
51: -- Standard Start of API savepoint
52: SAVEPOINT Import_PlanCopy;
53: retcode := 0;

Line 408: fnd_file.put_line(fnd_file.log, fnd_message.get);

404: --If Expression exists then do not Insert otherwise insert a new Record.
405: IF l_reuse_count > 0 THEN
406: fnd_message.set_name ('CN' , 'CN_COPY_EXP_REUSE');
407: fnd_message.set_token('EXPRESSION_NAME',v_name_node_value_new);
408: fnd_file.put_line(fnd_file.log, fnd_message.get);
409: END IF;
410:
411: IF l_reuse_count = 0 THEN
412: -- Get the other Expression values

Line 488: fnd_file.put_line(fnd_file.log, fnd_message.get);

484: IF l_formula_name_count = 0 THEN
485: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_MISS');
486: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
487: fnd_message.set_token('FORMULA_NAME',g_miss_calc_edges_tbl(i).child_name);
488: fnd_file.put_line(fnd_file.log, fnd_message.get);
489: l_sql_fail_count := 1;
490: EXIT;
491: ELSE
492: SELECT calc_formula_id INTO g_miss_calc_edges_tbl(i).child_id

Line 528: fnd_file.put_line(fnd_file.log, fnd_message.get);

524: IF l_exp_name_count = 0 THEN
525: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXP_MISS');
526: fnd_message.set_token('EXPRESSION_NAME_1',v_expression_rec.name);
527: fnd_message.set_token('EXPRESSION_NAME_2',g_miss_calc_edges_tbl(i).child_name);
528: fnd_file.put_line(fnd_file.log, fnd_message.get);
529: l_sql_fail_count := 1;
530: EXIT;
531: ELSE
532: SELECT calc_sql_exp_id INTO g_miss_calc_edges_tbl(i).child_id

Line 567: --fnd_file.put_line(fnd_file.log, fnd_message.get);

563: ELSE
564: --fnd_message.set_name ('CN' , 'CN_COPY_EXP_PE_MTRC_MISS');
565: --fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
566: --fnd_message.set_token('PLAN_ELEMENT_NAME', g_miss_pe_exp_tbl(i).name);
567: --fnd_file.put_line(fnd_file.log, fnd_message.get);
568: l_sql_fail_count := 1;
569: l_pe_exist := FALSE;
570: EXIT;
571: END IF;

Line 602: fnd_file.put_line(fnd_file.log, fnd_message.get);

598: -- Error Message - If table does not exist in Target System
599: IF l_ee_exist_obj_check = 0 THEN
600: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXT_MAP_MISS');
601: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
602: fnd_file.put_line(fnd_file.log, fnd_message.get);
603: l_sql_fail_count := 1;
604: EXIT;
605: END IF;
606: END IF;

Line 645: fnd_file.put_line(fnd_file.log, fnd_message.get);

641: x_object_version_number => x_object_version_number);
642: IF x_return_status = fnd_api.g_ret_sts_success THEN
643: fnd_message.set_name ('CN' , 'CN_COPY_EXP_CREATE');
644: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
645: fnd_file.put_line(fnd_file.log, fnd_message.get);
646: COMMIT;
647: ELSE
648: ROLLBACK TO Create_Expression;
649: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 652: fnd_file.put_line(fnd_file.log, fnd_message.get);

648: ROLLBACK TO Create_Expression;
649: IF x_return_status = fnd_api.g_ret_sts_error THEN
650: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL_EXPECTED');
651: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
652: fnd_file.put_line(fnd_file.log, fnd_message.get);
653: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
654: END IF;
655: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
656: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');

Line 653: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

649: IF x_return_status = fnd_api.g_ret_sts_error THEN
650: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL_EXPECTED');
651: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
652: fnd_file.put_line(fnd_file.log, fnd_message.get);
653: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
654: END IF;
655: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
656: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
657: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

Line 658: fnd_file.put_line(fnd_file.log, fnd_message.get);

654: END IF;
655: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
656: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
657: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
658: fnd_file.put_line(fnd_file.log, fnd_message.get);
659: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
660: END IF;
661: END IF;
662: ELSE

Line 659: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

655: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
656: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
657: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
658: fnd_file.put_line(fnd_file.log, fnd_message.get);
659: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
660: END IF;
661: END IF;
662: ELSE
663: ROLLBACK TO Create_Expression;

Line 666: fnd_file.put_line(fnd_file.log, fnd_message.get);

662: ELSE
663: ROLLBACK TO Create_Expression;
664: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
665: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
666: fnd_file.put_line(fnd_file.log, fnd_message.get);
667: END IF;
668: ELSE
669: ROLLBACK TO Create_Expression;
670: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');

Line 672: fnd_file.put_line(fnd_file.log, fnd_message.get);

668: ELSE
669: ROLLBACK TO Create_Expression;
670: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
671: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
672: fnd_file.put_line(fnd_file.log, fnd_message.get);
673: END IF;
674: END IF;
675: END IF;
676:

Line 713: fnd_file.put_line(fnd_file.log, fnd_message.get);

709: --If Rate Dimension exists then do not Insert, Else insert a new record.
710: IF l_reuse_count > 0 THEN
711: fnd_message.set_name ('CN' , 'CN_COPY_RD_REUSE');
712: fnd_message.set_token('RATE_DIMENSION_NAME',v_name_node_value_new);
713: fnd_file.put_line(fnd_file.log, fnd_message.get);
714: END IF;
715:
716: IF l_reuse_count = 0 THEN
717: -- Get the other Rate Dimension Values

Line 818: fnd_file.put_line(fnd_file.log, fnd_message.get);

814: x_msg_data => x_msg_data);
815: IF x_return_status = fnd_api.g_ret_sts_success THEN
816: fnd_message.set_name ('CN' , 'CN_COPY_RD_CREATE');
817: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819: IF (g_miss_rate_dim_exp_tbl.COUNT > 0 AND v_rate_dimension_rec.dim_unit_code = 'EXPRESSION') THEN
820: FOR i IN g_miss_rate_dim_exp_tbl.FIRST..g_miss_rate_dim_exp_tbl.LAST LOOP
821: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
822: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_name);

Line 824: fnd_file.put_line(fnd_file.log, fnd_message.get);

820: FOR i IN g_miss_rate_dim_exp_tbl.FIRST..g_miss_rate_dim_exp_tbl.LAST LOOP
821: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
822: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_name);
823: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
824: fnd_file.put_line(fnd_file.log, fnd_message.get);
825: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
826: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);
827: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
828: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 828: fnd_file.put_line(fnd_file.log, fnd_message.get);

824: fnd_file.put_line(fnd_file.log, fnd_message.get);
825: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
826: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);
827: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
828: fnd_file.put_line(fnd_file.log, fnd_message.get);
829: END LOOP;
830: END IF;
831: COMMIT;
832: ELSE

Line 837: fnd_file.put_line(fnd_file.log, fnd_message.get);

833: ROLLBACK TO Create_RateDimension;
834: IF x_return_status = fnd_api.g_ret_sts_error THEN
835: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL_EXPECTED');
836: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
837: fnd_file.put_line(fnd_file.log, fnd_message.get);
838: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
839: END IF;
840: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
841: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');

Line 838: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

834: IF x_return_status = fnd_api.g_ret_sts_error THEN
835: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL_EXPECTED');
836: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
837: fnd_file.put_line(fnd_file.log, fnd_message.get);
838: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
839: END IF;
840: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
841: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
842: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);

Line 843: fnd_file.put_line(fnd_file.log, fnd_message.get);

839: END IF;
840: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
841: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
842: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
843: fnd_file.put_line(fnd_file.log, fnd_message.get);
844: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
845: END IF;
846: END IF;
847: ELSE

Line 844: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

840: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
841: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
842: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
843: fnd_file.put_line(fnd_file.log, fnd_message.get);
844: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
845: END IF;
846: END IF;
847: ELSE
848: ROLLBACK TO Create_RateDimension;

Line 851: fnd_file.put_line(fnd_file.log, fnd_message.get);

847: ELSE
848: ROLLBACK TO Create_RateDimension;
849: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
850: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
851: fnd_file.put_line(fnd_file.log, fnd_message.get);
852: END IF;
853: ELSE
854: ROLLBACK TO Create_RateDimension;
855: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');

Line 857: fnd_file.put_line(fnd_file.log, fnd_message.get);

853: ELSE
854: ROLLBACK TO Create_RateDimension;
855: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
856: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
857: fnd_file.put_line(fnd_file.log, fnd_message.get);
858: END IF;
859: ELSE
860: ROLLBACK TO Create_RateDimension;
861: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');

Line 863: fnd_file.put_line(fnd_file.log, fnd_message.get);

859: ELSE
860: ROLLBACK TO Create_RateDimension;
861: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
862: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
863: fnd_file.put_line(fnd_file.log, fnd_message.get);
864: END IF;
865: END IF;
866: END IF;
867:

Line 904: fnd_file.put_line(fnd_file.log, fnd_message.get);

900: IF l_reuse_count > 0 THEN
901: ROLLBACK TO Create_RateSchedule;
902: fnd_message.set_name ('CN' , 'CN_COPY_RT_REUSE');
903: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);
904: fnd_file.put_line(fnd_file.log, fnd_message.get);
905: END IF;
906:
907: IF l_reuse_count = 0 THEN
908: -- Get the other Rate Table values

Line 986: fnd_file.put_line(fnd_file.log, fnd_message.get);

982: ELSE
983: ROLLBACK TO Create_RateSchedule;
984: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
985: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
986: fnd_file.put_line(fnd_file.log, fnd_message.get);
987: END IF;
988: END IF;
989: --*********************************************************************
990: -- Import Rate Table - Rate Schedule

Line 1023: fnd_file.put_line(fnd_file.log, fnd_message.get);

1019: END LOOP;
1020: END IF;
1021: fnd_message.set_name ('CN' , 'CN_COPY_RT_CREATE');
1022: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);
1023: fnd_file.put_line(fnd_file.log, fnd_message.get);
1024: IF (v_rate_sch_dims_tbl.COUNT > 0) THEN
1025: FOR i IN v_rate_sch_dims_tbl.FIRST..v_rate_sch_dims_tbl.LAST LOOP
1026: fnd_message.set_name ('CN' , 'CN_COPY_RD_RT_ASSIGN');
1027: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_sch_dims_tbl(i).rate_dim_name);

Line 1029: fnd_file.put_line(fnd_file.log, fnd_message.get);

1025: FOR i IN v_rate_sch_dims_tbl.FIRST..v_rate_sch_dims_tbl.LAST LOOP
1026: fnd_message.set_name ('CN' , 'CN_COPY_RD_RT_ASSIGN');
1027: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_sch_dims_tbl(i).rate_dim_name);
1028: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1029: fnd_file.put_line(fnd_file.log, fnd_message.get);
1030: END LOOP;
1031: END IF;
1032: COMMIT;
1033: ELSE

Line 1038: fnd_file.put_line(fnd_file.log, fnd_message.get);

1034: ROLLBACK TO Create_RateDimension;
1035: IF x_return_status = fnd_api.g_ret_sts_error THEN
1036: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL_EXPECTED');
1037: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1038: fnd_file.put_line(fnd_file.log, fnd_message.get);
1039: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1040: END IF;
1041: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1042: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');

Line 1039: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

1035: IF x_return_status = fnd_api.g_ret_sts_error THEN
1036: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL_EXPECTED');
1037: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1038: fnd_file.put_line(fnd_file.log, fnd_message.get);
1039: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1040: END IF;
1041: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1042: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1043: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);

Line 1044: fnd_file.put_line(fnd_file.log, fnd_message.get);

1040: END IF;
1041: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1042: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1043: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1044: fnd_file.put_line(fnd_file.log, fnd_message.get);
1045: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1046: END IF;
1047: END IF;
1048: ELSE

Line 1045: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

1041: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1042: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1043: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1044: fnd_file.put_line(fnd_file.log, fnd_message.get);
1045: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1046: END IF;
1047: END IF;
1048: ELSE
1049: ROLLBACK TO Create_RateSchedule;

Line 1052: fnd_file.put_line(fnd_file.log, fnd_message.get);

1048: ELSE
1049: ROLLBACK TO Create_RateSchedule;
1050: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1051: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1052: fnd_file.put_line(fnd_file.log, fnd_message.get);
1053: END IF;
1054: ELSE
1055: ROLLBACK TO Create_RateSchedule;
1056: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');

Line 1058: fnd_file.put_line(fnd_file.log, fnd_message.get);

1054: ELSE
1055: ROLLBACK TO Create_RateSchedule;
1056: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1057: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1058: fnd_file.put_line(fnd_file.log, fnd_message.get);
1059: END IF;
1060: ELSE
1061: ROLLBACK TO Create_RateSchedule;
1062: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');

Line 1064: fnd_file.put_line(fnd_file.log, fnd_message.get);

1060: ELSE
1061: ROLLBACK TO Create_RateSchedule;
1062: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1063: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1064: fnd_file.put_line(fnd_file.log, fnd_message.get);
1065: END IF;
1066: END IF;
1067: END IF;
1068:

Line 1105: fnd_file.put_line(fnd_file.log, fnd_message.get);

1101: --If Formula exists then do not Insert otherwise insert a new Record.
1102: IF l_reuse_count > 0 THEN
1103: fnd_message.set_name ('CN' , 'CN_COPY_FM_REUSE');
1104: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1105: fnd_file.put_line(fnd_file.log, fnd_message.get);
1106: END IF;
1107:
1108: IF l_reuse_count = 0 THEN
1109: -- Get the other Formula values

Line 1339: --fnd_file.put_line(fnd_file.log, fnd_message.get);

1335: l_sql_fail_count := 1;
1336: --ROLLBACK TO Create_Formula;
1337: --fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1338: --fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1339: --fnd_file.put_line(fnd_file.log, fnd_message.get);
1340: END IF;
1341: END IF;
1342:
1343: IF l_sql_fail_count = 0 THEN

Line 1380: fnd_file.put_line(fnd_file.log, fnd_message.get);

1376:
1377: IF x_return_status = fnd_api.g_ret_sts_success THEN
1378: fnd_message.set_name ('CN' , 'CN_COPY_FM_CREATE');
1379: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1380: fnd_file.put_line(fnd_file.log, fnd_message.get);
1381: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1382: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1383: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1384: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1384: fnd_file.put_line(fnd_file.log, fnd_message.get);

1380: fnd_file.put_line(fnd_file.log, fnd_message.get);
1381: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1382: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1383: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1384: fnd_file.put_line(fnd_file.log, fnd_message.get);
1385: IF l_f_output_exp_name IS NOT NULL THEN
1386: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1387: fnd_message.set_token('EXPRESSION_NAME',l_f_output_exp_name);
1388: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

Line 1389: fnd_file.put_line(fnd_file.log, fnd_message.get);

1385: IF l_f_output_exp_name IS NOT NULL THEN
1386: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1387: fnd_message.set_token('EXPRESSION_NAME',l_f_output_exp_name);
1388: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1389: fnd_file.put_line(fnd_file.log, fnd_message.get);
1390: END IF;
1391: IF l_perf_measure_name IS NOT NULL THEN
1392: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1393: fnd_message.set_token('EXPRESSION_NAME',l_perf_measure_name);

Line 1395: fnd_file.put_line(fnd_file.log, fnd_message.get);

1391: IF l_perf_measure_name IS NOT NULL THEN
1392: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1393: fnd_message.set_token('EXPRESSION_NAME',l_perf_measure_name);
1394: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1395: fnd_file.put_line(fnd_file.log, fnd_message.get);
1396: END IF;
1397: IF (v_input_exp_tbl.COUNT > 0) THEN
1398: FOR i IN v_input_exp_tbl.FIRST..v_input_exp_tbl.LAST LOOP
1399: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');

Line 1402: fnd_file.put_line(fnd_file.log, fnd_message.get);

1398: FOR i IN v_input_exp_tbl.FIRST..v_input_exp_tbl.LAST LOOP
1399: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1400: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).calc_exp_name);
1401: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1402: fnd_file.put_line(fnd_file.log, fnd_message.get);
1403: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1404: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1405: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).f_calc_exp_name);
1406: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

Line 1407: fnd_file.put_line(fnd_file.log, fnd_message.get);

1403: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1404: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1405: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).f_calc_exp_name);
1406: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1407: fnd_file.put_line(fnd_file.log, fnd_message.get);
1408: END IF;
1409: END LOOP;
1410: END IF;
1411: IF (v_rt_assign_tbl.COUNT > 0) THEN

Line 1422: fnd_file.put_line(fnd_file.log, fnd_message.get);

1418: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);
1419: ELSE
1420: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
1421: END IF;
1422: fnd_file.put_line(fnd_file.log, fnd_message.get);
1423: END LOOP;
1424: END IF;
1425: COMMIT;
1426: ELSE

Line 1431: fnd_file.put_line(fnd_file.log, fnd_message.get);

1427: -- No ROLLBACK TO Create_Formula - Generate has a separate COMMIT cycle.
1428: IF x_return_status = fnd_api.g_ret_sts_error THEN
1429: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL_EXPECTED');
1430: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1431: fnd_file.put_line(fnd_file.log, fnd_message.get);
1432: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1433: END IF;
1434: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1435: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');

Line 1432: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

1428: IF x_return_status = fnd_api.g_ret_sts_error THEN
1429: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL_EXPECTED');
1430: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1431: fnd_file.put_line(fnd_file.log, fnd_message.get);
1432: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1433: END IF;
1434: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1435: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1436: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

Line 1437: fnd_file.put_line(fnd_file.log, fnd_message.get);

1433: END IF;
1434: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1435: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1436: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1437: fnd_file.put_line(fnd_file.log, fnd_message.get);
1438: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1439: END IF;
1440: END IF;
1441: ELSE

Line 1438: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

1434: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1435: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1436: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1437: fnd_file.put_line(fnd_file.log, fnd_message.get);
1438: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1439: END IF;
1440: END IF;
1441: ELSE
1442: ROLLBACK TO Create_Formula;

Line 1445: fnd_file.put_line(fnd_file.log, fnd_message.get);

1441: ELSE
1442: ROLLBACK TO Create_Formula;
1443: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1444: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1445: fnd_file.put_line(fnd_file.log, fnd_message.get);
1446: END IF;
1447: ELSE
1448: ROLLBACK TO Create_Formula;
1449: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');

Line 1451: fnd_file.put_line(fnd_file.log, fnd_message.get);

1447: ELSE
1448: ROLLBACK TO Create_Formula;
1449: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1450: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1451: fnd_file.put_line(fnd_file.log, fnd_message.get);
1452: END IF;
1453: ELSE
1454: ROLLBACK TO Create_Formula;
1455: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');

Line 1457: fnd_file.put_line(fnd_file.log, fnd_message.get);

1453: ELSE
1454: ROLLBACK TO Create_Formula;
1455: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1456: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1457: fnd_file.put_line(fnd_file.log, fnd_message.get);
1458: END IF;
1459: ELSE
1460: ROLLBACK TO Create_Formula;
1461: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');

Line 1463: fnd_file.put_line(fnd_file.log, fnd_message.get);

1459: ELSE
1460: ROLLBACK TO Create_Formula;
1461: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1462: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1463: fnd_file.put_line(fnd_file.log, fnd_message.get);
1464: END IF;
1465: ELSE
1466: ROLLBACK TO Create_Formula;
1467: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');

Line 1469: fnd_file.put_line(fnd_file.log, fnd_message.get);

1465: ELSE
1466: ROLLBACK TO Create_Formula;
1467: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1468: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1469: fnd_file.put_line(fnd_file.log, fnd_message.get);
1470: END IF;
1471: END IF;
1472: END IF;
1473:

Line 1508: fnd_file.put_line(fnd_file.log, fnd_message.get);

1504: --If Plan Element exists then do not Insert otherwise insert a new Record.
1505: IF l_reuse_count > 0 THEN
1506: fnd_message.set_name ('CN' , 'CN_COPY_PE_REUSE');
1507: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1508: fnd_file.put_line(fnd_file.log, fnd_message.get);
1509: END IF;
1510:
1511: -- If Plan Element does not exist then proceed further.
1512: IF l_reuse_count = 0 THEN

Line 1598: fnd_file.put_line(fnd_file.log, fnd_message.get);

1594: IF v_plan_element_rec.element_type = 'EXTERNAL' AND
1595: v_plan_element_rec.package_name IS NULL THEN
1596: fnd_message.set_name ('CN' , 'CN_COPY_PE_EXT_FM_MISS');
1597: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1598: fnd_file.put_line(fnd_file.log, fnd_message.get);
1599: l_sql_fail_count := 1;
1600: END IF;
1601:
1602: -- Check for Formula Name in Target System.

Line 1628: fnd_file.put_line(fnd_file.log, fnd_message.get);

1624: IF l_int_type_count = 0 THEN
1625: fnd_message.set_name ('CN' , 'CN_COPY_PE_INT_TYPE_MISS');
1626: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1627: fnd_message.set_token('INTERVAL_TYPE_NAME',v_plan_element_rec.interval_name);
1628: fnd_file.put_line(fnd_file.log, fnd_message.get);
1629: l_sql_fail_count := 1;
1630: END IF;
1631:
1632: -- Check Credit Type Name in Target System

Line 1641: fnd_file.put_line(fnd_file.log, fnd_message.get);

1637: IF l_crd_type_count = 0 THEN
1638: fnd_message.set_name ('CN' , 'CN_COPY_PE_CRD_TYPE_MISS');
1639: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1640: fnd_message.set_token('CREDIT_TYPE_NAME',v_plan_element_rec.credit_type);
1641: fnd_file.put_line(fnd_file.log, fnd_message.get);
1642: l_sql_fail_count := 1;
1643: END IF;
1644:
1645: -- If all of the above are NOT NULL then proceed further

Line 1658: fnd_file.put_line(fnd_file.log, fnd_message.get);

1654: IF l_pmt_group_code = 0 THEN
1655: fnd_message.set_name ('CN' , 'CN_COPY_PE_PMT_GRP_DFLT');
1656: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1657: fnd_message.set_token('PAYMENT_GROUP_CODE_NAME',v_plan_element_rec.payment_group_code);
1658: fnd_file.put_line(fnd_file.log, fnd_message.get);
1659: v_plan_element_rec.payment_group_code := 'STANDARD';
1660: END IF;
1661:
1662: -- Check if Start Date and End Date values are passed for change.

Line 1760: fnd_file.put_line(fnd_file.log, fnd_message.get);

1756: ELSE
1757: fnd_message.set_name ('CN' , 'CN_COPY_PE_REV_CLS_MISS');
1758: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1759: fnd_message.set_token('PRODUCT_NAME',l_rev_class_name);
1760: fnd_file.put_line(fnd_file.log, fnd_message.get);
1761: END IF;
1762: END LOOP;
1763:
1764: -- If atleast one revenue class exists then proceed further

Line 1861: fnd_file.put_line(fnd_file.log, fnd_message.get);

1857: END IF;
1858: ELSE
1859: fnd_message.set_name ('CN' , 'CN_COPY_PE_FCTRS_OUT_RANGE');
1860: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1861: fnd_file.put_line(fnd_file.log, fnd_message.get);
1862: END IF;
1863: END LOOP;
1864: END IF;
1865: END IF;

Line 2139: fnd_file.put_line(fnd_file.log, fnd_message.get);

2135: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);
2136: ELSE
2137: fnd_message.set_token('PLAN_ELEMENT_END_DATE', 'NULL');
2138: END IF;
2139: fnd_file.put_line(fnd_file.log, fnd_message.get);
2140: -- Log Message for Formula to Quota Assignment
2141: fnd_message.set_name ('CN' , 'CN_COPY_FM_PE_ASSIGN');
2142: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2143: fnd_message.set_token('FORMULA_NAME',v_plan_element_rec.calc_formula_name);

Line 2144: fnd_file.put_line(fnd_file.log, fnd_message.get);

2140: -- Log Message for Formula to Quota Assignment
2141: fnd_message.set_name ('CN' , 'CN_COPY_FM_PE_ASSIGN');
2142: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2143: fnd_message.set_token('FORMULA_NAME',v_plan_element_rec.calc_formula_name);
2144: fnd_file.put_line(fnd_file.log, fnd_message.get);
2145: -- Log Message for Rate Table to Quota Assignment
2146: IF (v_rt_quota_asgns_tbl.COUNT > 0) THEN
2147: FOR i IN v_rt_quota_asgns_tbl.FIRST..v_rt_quota_asgns_tbl.LAST LOOP
2148: fnd_message.set_name ('CN' , 'CN_COPY_RT_PE_ASSIGN');

Line 2157: fnd_file.put_line(fnd_file.log, fnd_message.get);

2153: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);
2154: ELSE
2155: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
2156: END IF;
2157: fnd_file.put_line(fnd_file.log, fnd_message.get);
2158: END LOOP;
2159: END IF;
2160: COMMIT;
2161: -- New value of plan element for Interdependent cases

Line 2181: fnd_file.put_line(fnd_file.log, fnd_message.get);

2177: ROLLBACK TO Create_PlanElement;
2178: IF x_return_status = fnd_api.g_ret_sts_error THEN
2179: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL_EXPECTED');
2180: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2181: fnd_file.put_line(fnd_file.log, fnd_message.get);
2182: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2183: END IF;
2184: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2185: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

Line 2182: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

2178: IF x_return_status = fnd_api.g_ret_sts_error THEN
2179: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL_EXPECTED');
2180: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2181: fnd_file.put_line(fnd_file.log, fnd_message.get);
2182: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2183: END IF;
2184: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2185: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2186: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

Line 2187: fnd_file.put_line(fnd_file.log, fnd_message.get);

2183: END IF;
2184: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2185: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2186: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2187: fnd_file.put_line(fnd_file.log, fnd_message.get);
2188: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2189: END IF;
2190: END IF;
2191: ELSE

Line 2188: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

2184: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2185: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2186: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2187: fnd_file.put_line(fnd_file.log, fnd_message.get);
2188: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2189: END IF;
2190: END IF;
2191: ELSE
2192: ROLLBACK TO Create_PlanElement;

Line 2195: fnd_file.put_line(fnd_file.log, fnd_message.get);

2191: ELSE
2192: ROLLBACK TO Create_PlanElement;
2193: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2194: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2195: fnd_file.put_line(fnd_file.log, fnd_message.get);
2196: END IF;
2197: ELSE
2198: ROLLBACK TO Create_PlanElement;
2199: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

Line 2201: fnd_file.put_line(fnd_file.log, fnd_message.get);

2197: ELSE
2198: ROLLBACK TO Create_PlanElement;
2199: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2200: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2201: fnd_file.put_line(fnd_file.log, fnd_message.get);
2202: END IF;
2203: ELSE
2204: ROLLBACK TO Create_PlanElement;
2205: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

Line 2207: fnd_file.put_line(fnd_file.log, fnd_message.get);

2203: ELSE
2204: ROLLBACK TO Create_PlanElement;
2205: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2206: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2207: fnd_file.put_line(fnd_file.log, fnd_message.get);
2208: END IF;
2209: ELSE
2210: ROLLBACK TO Create_PlanElement;
2211: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

Line 2213: fnd_file.put_line(fnd_file.log, fnd_message.get);

2209: ELSE
2210: ROLLBACK TO Create_PlanElement;
2211: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2212: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2213: fnd_file.put_line(fnd_file.log, fnd_message.get);
2214: END IF;
2215: ELSE
2216: ROLLBACK TO Create_PlanElement;
2217: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

Line 2219: fnd_file.put_line(fnd_file.log, fnd_message.get);

2215: ELSE
2216: ROLLBACK TO Create_PlanElement;
2217: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2218: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2219: fnd_file.put_line(fnd_file.log, fnd_message.get);
2220: END IF;
2221: ELSE
2222: ROLLBACK TO Create_PlanElement;
2223: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

Line 2225: fnd_file.put_line(fnd_file.log, fnd_message.get);

2221: ELSE
2222: ROLLBACK TO Create_PlanElement;
2223: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2224: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2225: fnd_file.put_line(fnd_file.log, fnd_message.get);
2226: END IF;
2227: END IF;
2228: END IF;
2229:

Line 2264: fnd_file.put_line(fnd_file.log, fnd_message.get);

2260: --If Compensation Plan exits then do not Insert otherwise insert a new Record.
2261: IF l_reuse_count > 0 THEN
2262: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE');
2263: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2264: fnd_file.put_line(fnd_file.log, fnd_message.get);
2265: p_reuse_obj_count := p_reuse_obj_count + 1;
2266: END IF;
2267:
2268: IF l_reuse_count = 0 THEN

Line 2376: fnd_file.put_line(fnd_file.log, fnd_message.get);

2372: ROLLBACK TO Create_CompPlan;
2373: -- Comp Plan Fail Message
2374: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2375: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2376: fnd_file.put_line(fnd_file.log, fnd_message.get);
2377: -- Failed Plan Name collection for Summary Section
2378: IF l_failed_plan_name IS NULL THEN
2379: l_failed_plan_name := v_comp_plan_rec.name;
2380: ELSE

Line 2423: fnd_file.put_line(fnd_file.log, fnd_message.get);

2419: IF x_return_status = fnd_api.g_ret_sts_success THEN
2420: fnd_message.set_name ('CN' , 'CN_COPY_PE_ASSIGN');
2421: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2422: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2423: fnd_file.put_line(fnd_file.log, fnd_message.get);
2424: l_quota_asgn_count := 1;
2425: ELSE
2426: l_sql_fail_count := 1;
2427: EXIT;

Line 2437: fnd_file.put_line(fnd_file.log, fnd_message.get);

2433: ELSE
2434: fnd_message.set_name ('CN' , 'CN_COPY_PE_OUT_RANGE');
2435: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2436: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2437: fnd_file.put_line(fnd_file.log, fnd_message.get);
2438: END IF;
2439: END LOOP;
2440: IF l_sql_fail_count = 0 AND l_quota_asgn_count = 1 THEN
2441: fnd_message.set_name ('CN' , 'CN_COPY_CP_CREATE');

Line 2449: fnd_file.put_line(fnd_file.log, fnd_message.get);

2445: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);
2446: ELSE
2447: fnd_message.set_token('PLAN_END_DATE', 'NULL');
2448: END IF;
2449: fnd_file.put_line(fnd_file.log, fnd_message.get);
2450: p_success_obj_count := p_success_obj_count + 1;
2451: COMMIT;
2452: ELSE
2453: ROLLBACK TO Create_CompPlan;

Line 2458: fnd_file.put_line(fnd_file.log, fnd_message.get);

2454: -- Comp Plan Fail Message
2455: IF x_return_status = fnd_api.g_ret_sts_error THEN
2456: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2457: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2458: fnd_file.put_line(fnd_file.log, fnd_message.get);
2459: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2460: END IF;
2461: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2462: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');

Line 2459: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

2455: IF x_return_status = fnd_api.g_ret_sts_error THEN
2456: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2457: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2458: fnd_file.put_line(fnd_file.log, fnd_message.get);
2459: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2460: END IF;
2461: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2462: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2463: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

Line 2464: fnd_file.put_line(fnd_file.log, fnd_message.get);

2460: END IF;
2461: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2462: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2463: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2464: fnd_file.put_line(fnd_file.log, fnd_message.get);
2465: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2466: END IF;
2467: -- Failed Plan Name collection for Summary Section
2468: IF l_failed_plan_name IS NULL THEN

Line 2465: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

2461: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2462: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2463: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2464: fnd_file.put_line(fnd_file.log, fnd_message.get);
2465: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2466: END IF;
2467: -- Failed Plan Name collection for Summary Section
2468: IF l_failed_plan_name IS NULL THEN
2469: l_failed_plan_name := v_comp_plan_rec.name;

Line 2479: fnd_file.put_line(fnd_file.log, fnd_message.get);

2475: ROLLBACK TO Create_CompPlan;
2476: -- Comp Plan Fail Message
2477: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2478: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2479: fnd_file.put_line(fnd_file.log, fnd_message.get);
2480: -- Failed Plan Name collection for Summary Section
2481: IF l_failed_plan_name IS NULL THEN
2482: l_failed_plan_name := v_comp_plan_rec.name;
2483: ELSE

Line 2493: fnd_file.put_line(fnd_file.log, fnd_message.get);

2489: ROLLBACK TO Create_CompPlan;
2490: -- Comp Plan Fail Message
2491: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2492: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2493: fnd_file.put_line(fnd_file.log, fnd_message.get);
2494: -- Failed Plan Name collection for Summary Section
2495: IF l_failed_plan_name IS NULL THEN
2496: l_failed_plan_name := v_comp_plan_rec.name;
2497: ELSE

Line 2506: fnd_file.put_line(fnd_file.log, fnd_message.get);

2502: ROLLBACK TO Create_CompPlan;
2503: -- Comp Plan Fail Message
2504: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2505: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2506: fnd_file.put_line(fnd_file.log, fnd_message.get);
2507: -- Failed Plan Name collection for Summary Section
2508: IF l_failed_plan_name IS NULL THEN
2509: l_failed_plan_name := v_comp_plan_rec.name;
2510: ELSE

Line 2520: fnd_file.put_line(fnd_file.log, fnd_message.get);

2516: -- Comp Plan Fail Message
2517: IF x_return_status = fnd_api.g_ret_sts_error THEN
2518: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2519: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2520: fnd_file.put_line(fnd_file.log, fnd_message.get);
2521: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2522: END IF;
2523: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2524: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');

Line 2521: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

2517: IF x_return_status = fnd_api.g_ret_sts_error THEN
2518: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2519: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2520: fnd_file.put_line(fnd_file.log, fnd_message.get);
2521: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2522: END IF;
2523: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2524: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2525: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

Line 2526: fnd_file.put_line(fnd_file.log, fnd_message.get);

2522: END IF;
2523: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2524: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2525: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2526: fnd_file.put_line(fnd_file.log, fnd_message.get);
2527: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2528: END IF;
2529: -- Failed Plan Name collection for Summary Section
2530: IF l_failed_plan_name IS NULL THEN

Line 2527: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);

2523: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2524: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2525: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2526: fnd_file.put_line(fnd_file.log, fnd_message.get);
2527: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2528: END IF;
2529: -- Failed Plan Name collection for Summary Section
2530: IF l_failed_plan_name IS NULL THEN
2531: l_failed_plan_name := v_comp_plan_rec.name;

Line 2541: fnd_file.put_line(fnd_file.log, '**************************************************************');

2537: END IF;
2538:
2539: /* ****************************** Main Loop End ************************** */
2540: END LOOP;
2541: fnd_file.put_line(fnd_file.log, '**************************************************************');
2542: fnd_file.put_line(fnd_file.log, '******************** END - PLAN COPY IMPORT ******************');
2543: fnd_file.put_line(fnd_file.log, '**************************************************************');
2544:
2545: -- ****************************************************************

Line 2542: fnd_file.put_line(fnd_file.log, '** END - PLAN COPY IMPORT ');

2538:
2539: /* ****************************** Main Loop End ************************** */
2540: END LOOP;
2541: fnd_file.put_line(fnd_file.log, '**************************************************************');
2542: fnd_file.put_line(fnd_file.log, '******************** END - PLAN COPY IMPORT ******************');
2543: fnd_file.put_line(fnd_file.log, '**************************************************************');
2544:
2545: -- ****************************************************************
2546: -- *********** Summary of Import Process Log Messages ***********

Line 2543: fnd_file.put_line(fnd_file.log, '**************************************************************');

2539: /* ****************************** Main Loop End ************************** */
2540: END LOOP;
2541: fnd_file.put_line(fnd_file.log, '**************************************************************');
2542: fnd_file.put_line(fnd_file.log, '******************** END - PLAN COPY IMPORT ******************');
2543: fnd_file.put_line(fnd_file.log, '**************************************************************');
2544:
2545: -- ****************************************************************
2546: -- *********** Summary of Import Process Log Messages ***********
2547: -- ****************************************************************

Line 2548: fnd_file.put_line(fnd_file.log, '**************************************************************');

2544:
2545: -- ****************************************************************
2546: -- *********** Summary of Import Process Log Messages ***********
2547: -- ****************************************************************
2548: fnd_file.put_line(fnd_file.log, '**************************************************************');
2549: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2550: fnd_file.put_line(fnd_file.log, '**************************************************************');
2551: -- Number of plans to Import
2552: fnd_message.set_name ('CN' , 'CN_COPY_CP_REQ_COUNT');

Line 2549: fnd_file.put_line(fnd_file.log, '***** SUMMARY ');

2545: -- ****************************************************************
2546: -- *********** Summary of Import Process Log Messages ***********
2547: -- ****************************************************************
2548: fnd_file.put_line(fnd_file.log, '**************************************************************');
2549: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2550: fnd_file.put_line(fnd_file.log, '**************************************************************');
2551: -- Number of plans to Import
2552: fnd_message.set_name ('CN' , 'CN_COPY_CP_REQ_COUNT');
2553: fnd_message.set_token('COUNT',p_object_count);

Line 2550: fnd_file.put_line(fnd_file.log, '**************************************************************');

2546: -- *********** Summary of Import Process Log Messages ***********
2547: -- ****************************************************************
2548: fnd_file.put_line(fnd_file.log, '**************************************************************');
2549: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2550: fnd_file.put_line(fnd_file.log, '**************************************************************');
2551: -- Number of plans to Import
2552: fnd_message.set_name ('CN' , 'CN_COPY_CP_REQ_COUNT');
2553: fnd_message.set_token('COUNT',p_object_count);
2554: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2554: fnd_file.put_line(fnd_file.log, fnd_message.get);

2550: fnd_file.put_line(fnd_file.log, '**************************************************************');
2551: -- Number of plans to Import
2552: fnd_message.set_name ('CN' , 'CN_COPY_CP_REQ_COUNT');
2553: fnd_message.set_token('COUNT',p_object_count);
2554: fnd_file.put_line(fnd_file.log, fnd_message.get);
2555: -- Number of Plans successfully created in target
2556: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
2557: fnd_message.set_token('COUNT',p_success_obj_count);
2558: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2558: fnd_file.put_line(fnd_file.log, fnd_message.get);

2554: fnd_file.put_line(fnd_file.log, fnd_message.get);
2555: -- Number of Plans successfully created in target
2556: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
2557: fnd_message.set_token('COUNT',p_success_obj_count);
2558: fnd_file.put_line(fnd_file.log, fnd_message.get);
2559: -- Number of Plans reused in tagret
2560: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');
2561: fnd_message.set_token('COUNT',p_reuse_obj_count);
2562: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2562: fnd_file.put_line(fnd_file.log, fnd_message.get);

2558: fnd_file.put_line(fnd_file.log, fnd_message.get);
2559: -- Number of Plans reused in tagret
2560: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');
2561: fnd_message.set_token('COUNT',p_reuse_obj_count);
2562: fnd_file.put_line(fnd_file.log, fnd_message.get);
2563: -- Number of Plans which were not imported due to error
2564: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2565: fnd_message.set_token('LIST',l_failed_plan_name);
2566: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2566: fnd_file.put_line(fnd_file.log, fnd_message.get);

2562: fnd_file.put_line(fnd_file.log, fnd_message.get);
2563: -- Number of Plans which were not imported due to error
2564: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2565: fnd_message.set_token('LIST',l_failed_plan_name);
2566: fnd_file.put_line(fnd_file.log, fnd_message.get);
2567: fnd_file.put_line(fnd_file.log, '**************************************************************');
2568: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2569: fnd_file.put_line(fnd_file.log, '**************************************************************');
2570:

Line 2567: fnd_file.put_line(fnd_file.log, '**************************************************************');

2563: -- Number of Plans which were not imported due to error
2564: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2565: fnd_message.set_token('LIST',l_failed_plan_name);
2566: fnd_file.put_line(fnd_file.log, fnd_message.get);
2567: fnd_file.put_line(fnd_file.log, '**************************************************************');
2568: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2569: fnd_file.put_line(fnd_file.log, '**************************************************************');
2570:
2571: -- Set the Import Status to 'COMPLETE' OR 'FAILED'

Line 2568: fnd_file.put_line(fnd_file.log, '***** SUMMARY ');

2564: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2565: fnd_message.set_token('LIST',l_failed_plan_name);
2566: fnd_file.put_line(fnd_file.log, fnd_message.get);
2567: fnd_file.put_line(fnd_file.log, '**************************************************************');
2568: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2569: fnd_file.put_line(fnd_file.log, '**************************************************************');
2570:
2571: -- Set the Import Status to 'COMPLETE' OR 'FAILED'
2572: IF p_object_count = p_success_obj_count + p_reuse_obj_count THEN

Line 2569: fnd_file.put_line(fnd_file.log, '**************************************************************');

2565: fnd_message.set_token('LIST',l_failed_plan_name);
2566: fnd_file.put_line(fnd_file.log, fnd_message.get);
2567: fnd_file.put_line(fnd_file.log, '**************************************************************');
2568: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2569: fnd_file.put_line(fnd_file.log, '**************************************************************');
2570:
2571: -- Set the Import Status to 'COMPLETE' OR 'FAILED'
2572: IF p_object_count = p_success_obj_count + p_reuse_obj_count THEN
2573: x_import_status := 'COMPLETED';