402: AND org_id = p_org_id;
403:
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:
403:
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
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
481: FROM cn_calc_formulas
482: WHERE name = g_miss_calc_edges_tbl(i).child_name
483: AND org_id = p_org_id;
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;
482: WHERE name = g_miss_calc_edges_tbl(i).child_name
483: AND org_id = p_org_id;
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;
483: AND org_id = p_org_id;
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
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
521: FROM cn_calc_sql_exps
522: WHERE name = g_miss_calc_edges_tbl(i).child_name
523: AND org_id = p_org_id;
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;
522: WHERE name = g_miss_calc_edges_tbl(i).child_name
523: AND org_id = p_org_id;
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;
523: AND org_id = p_org_id;
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
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
560: v_expression_rec.piped_expression_disp := REPLACE(v_expression_rec.piped_expression_disp,g_miss_pe_exp_tbl(i).old_pe_name,g_miss_pe_exp_tbl(i).new_pe_name);
561: END LOOP;
562: l_pe_exist := FALSE;
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;
561: END LOOP;
562: l_pe_exist := FALSE;
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;
562: l_pe_exist := FALSE;
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;
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;
596: AND object_type = 'TBL'
597: AND name = l_ee_tab_name_new;
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;
597: AND name = l_ee_tab_name_new;
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;
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;
639: x_msg_count => x_msg_count,
640: x_msg_data => x_msg_data,
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
640: x_msg_data => x_msg_data,
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;
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
646: COMMIT;
647: ELSE
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;
647: ELSE
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
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');
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);
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;
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);
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;
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
660: END IF;
661: END IF;
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
661: END IF;
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;
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');
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');
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;
667: END IF;
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;
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:
707: AND org_id = p_org_id;
708:
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:
708:
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
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
812: x_return_status => x_return_status,
813: x_msg_count => x_msg_count,
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
813: x_msg_count => x_msg_count,
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');
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);
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);
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');
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);
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);
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);
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);
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);
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);
829: END LOOP;
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);
829: END LOOP;
830: END IF;
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);
829: END LOOP;
830: END IF;
831: COMMIT;
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
831: COMMIT;
832: ELSE
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;
832: ELSE
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
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');
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);
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;
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);
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;
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
845: END IF;
846: END IF;
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
846: END IF;
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;
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');
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');
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
852: END IF;
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;
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');
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');
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;
858: END IF;
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;
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:
898:
899: --If Rate Table exists then do not Insert otherwise insert a new Record.
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:
899: --If Rate Table exists then do not Insert otherwise insert a new Record.
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
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
980: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RateSequence'),0)));
981: END LOOP;
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;
981: END LOOP;
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: --*********************************************************************
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
1017: p_object_version_number => x_object_version_number,
1018: p_org_id => p_org_id);
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
1018: p_org_id => p_org_id);
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');
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);
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);
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;
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);
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;
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);
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;
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
1032: COMMIT;
1033: ELSE
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;
1033: ELSE
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
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');
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);
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;
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);
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;
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
1046: END IF;
1047: END IF;
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
1047: END IF;
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;
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');
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');
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
1053: END IF;
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;
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');
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');
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;
1059: END IF;
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;
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:
1099: AND org_id = p_org_id;
1100:
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:
1100:
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
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
1333: END LOOP;
1334: ELSE
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;
1334: ELSE
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:
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
1374: x_msg_count => x_msg_count,
1375: x_msg_data => x_msg_data);
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);
1375: x_msg_data => x_msg_data);
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);
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);
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);
1385: IF l_f_output_exp_name IS NOT NULL 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);
1385: IF l_f_output_exp_name IS NOT NULL THEN
1386: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
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);
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);
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);
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);
1389: fnd_file.put_line(fnd_file.log, fnd_message.get);
1390: END IF;
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);
1389: fnd_file.put_line(fnd_file.log, fnd_message.get);
1390: END IF;
1391: IF l_perf_measure_name IS NOT NULL THEN
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);
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');
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);
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);
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;
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);
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
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);
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
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');
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');
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
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');
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');
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');
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);
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);
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);
1407: fnd_file.put_line(fnd_file.log, fnd_message.get);
1408: END IF;
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);
1407: fnd_file.put_line(fnd_file.log, fnd_message.get);
1408: END IF;
1409: END LOOP;
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);
1407: fnd_file.put_line(fnd_file.log, fnd_message.get);
1408: END IF;
1409: END LOOP;
1410: END IF;
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
1409: END LOOP;
1410: END IF;
1411: IF (v_rt_assign_tbl.COUNT > 0) THEN
1412: FOR i IN v_rt_assign_tbl.FIRST..v_rt_assign_tbl.LAST LOOP
1413: fnd_message.set_name ('CN' , 'CN_COPY_RT_FM_ASSIGN');
1414: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1415: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1416: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1417: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
1410: END IF;
1411: IF (v_rt_assign_tbl.COUNT > 0) THEN
1412: FOR i IN v_rt_assign_tbl.FIRST..v_rt_assign_tbl.LAST LOOP
1413: fnd_message.set_name ('CN' , 'CN_COPY_RT_FM_ASSIGN');
1414: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1415: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1416: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1417: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
1418: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);
1411: IF (v_rt_assign_tbl.COUNT > 0) THEN
1412: FOR i IN v_rt_assign_tbl.FIRST..v_rt_assign_tbl.LAST LOOP
1413: fnd_message.set_name ('CN' , 'CN_COPY_RT_FM_ASSIGN');
1414: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1415: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1416: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1417: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
1418: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);
1419: ELSE
1412: FOR i IN v_rt_assign_tbl.FIRST..v_rt_assign_tbl.LAST LOOP
1413: fnd_message.set_name ('CN' , 'CN_COPY_RT_FM_ASSIGN');
1414: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1415: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1416: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1417: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
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');
1414: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1415: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1416: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1417: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
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);
1416: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1417: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
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;
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
1425: COMMIT;
1426: ELSE
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;
1426: ELSE
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
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');
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);
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;
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);
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;
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
1439: END IF;
1440: END IF;
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
1440: END IF;
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;
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');
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');
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
1446: END IF;
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;
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');
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');
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
1452: END IF;
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;
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');
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');
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
1458: END IF;
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;
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');
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');
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;
1464: END IF;
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;
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:
1502: AND org_id = p_org_id;
1503:
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:
1503:
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.
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
1592:
1593: -- Check for External Formula
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;
1593: -- Check for External Formula
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:
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.
1621: FROM cn_interval_types
1622: WHERE name = v_plan_element_rec.interval_name
1623: AND org_id = p_org_id;
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;
1622: WHERE name = v_plan_element_rec.interval_name
1623: AND org_id = p_org_id;
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;
1623: AND org_id = p_org_id;
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:
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
1634: FROM cn_credit_types
1635: WHERE name = v_plan_element_rec.credit_type
1636: AND org_id = p_org_id;
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;
1635: WHERE name = v_plan_element_rec.credit_type
1636: AND org_id = p_org_id;
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;
1636: AND org_id = p_org_id;
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:
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
1651: AND lookup_code = v_plan_element_rec.payment_group_code;
1652:
1653: -- If Payment Group does not exists, Set it to 'STANDARD'
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';
1652:
1653: -- If Payment Group does not exists, Set it to 'STANDARD'
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;
1653: -- If Payment Group does not exists, Set it to 'STANDARD'
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:
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.
1753:
1754: --Check for atleast one revenue class assign to Plan Element
1755: l_rev_class_least_count := 1;
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;
1754: --Check for atleast one revenue class assign to Plan Element
1755: l_rev_class_least_count := 1;
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;
1755: l_rev_class_least_count := 1;
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:
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
1855: := to_date(dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'EndDateOld'),0))),'YYYY-MM-DD');
1856: -- Other Attributes End
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;
1856: -- Other Attributes End
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;
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;
2127: p_is_duplicate => 'N');
2128:
2129: IF x_return_status = fnd_api.g_ret_sts_success THEN
2130: -- Log Message for Plan Element creation.
2131: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2132: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2133: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2134: IF v_plan_element_rec.end_date IS NOT NULL THEN
2135: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);
2128:
2129: IF x_return_status = fnd_api.g_ret_sts_success THEN
2130: -- Log Message for Plan Element creation.
2131: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2132: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2133: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2134: IF v_plan_element_rec.end_date IS NOT NULL THEN
2135: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);
2136: ELSE
2129: IF x_return_status = fnd_api.g_ret_sts_success THEN
2130: -- Log Message for Plan Element creation.
2131: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2132: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2133: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2134: IF v_plan_element_rec.end_date IS NOT NULL THEN
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');
2131: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2132: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2133: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2134: IF v_plan_element_rec.end_date IS NOT NULL THEN
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);
2133: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2134: IF v_plan_element_rec.end_date IS NOT NULL THEN
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');
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);
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);
2144: fnd_file.put_line(fnd_file.log, fnd_message.get);
2145: -- Log Message for Rate Table to Quota Assignment
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);
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
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);
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
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');
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');
2149: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2150: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2151: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2152: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
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');
2149: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2150: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2151: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2152: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
2153: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);
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');
2149: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2150: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2151: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2152: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
2153: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);
2154: ELSE
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');
2149: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2150: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2151: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2152: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
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');
2149: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2150: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2151: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2152: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
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);
2151: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2152: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
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;
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
2175: END IF;
2176: ELSE
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;
2176: ELSE
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
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');
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);
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;
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);
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;
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
2189: END IF;
2190: END IF;
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
2190: END IF;
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;
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');
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');
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
2196: END IF;
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;
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');
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');
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
2202: END IF;
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;
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');
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');
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
2208: END IF;
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;
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');
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');
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
2214: END IF;
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;
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');
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');
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;
2220: END IF;
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;
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:
2258: AND org_id = p_org_id;
2259:
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;
2259:
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:
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
2370: AND org_id = p_org_id;
2371: ELSE
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
2371: ELSE
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;
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
2416: x_return_status => x_return_status,
2417: x_msg_count => x_msg_count,
2418: x_msg_data => x_msg_data);
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;
2417: x_msg_count => x_msg_count,
2418: x_msg_data => x_msg_data);
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
2418: x_msg_data => x_msg_data);
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;
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;
2430: l_sql_fail_count := 1;
2431: EXIT;
2432: END IF;
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;
2431: EXIT;
2432: END IF;
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;
2432: END IF;
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
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');
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');
2442: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2443: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2444: IF v_comp_plan_rec.end_date IS NOT NULL THEN
2445: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);
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');
2442: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2443: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2444: IF v_comp_plan_rec.end_date IS NOT NULL THEN
2445: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);
2446: ELSE
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');
2442: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2443: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2444: IF v_comp_plan_rec.end_date IS NOT NULL THEN
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');
2441: fnd_message.set_name ('CN' , 'CN_COPY_CP_CREATE');
2442: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2443: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2444: IF v_comp_plan_rec.end_date IS NOT NULL THEN
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);
2443: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2444: IF v_comp_plan_rec.end_date IS NOT NULL THEN
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;
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;
2452: ELSE
2453: ROLLBACK TO Create_CompPlan;
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;
2453: ROLLBACK TO Create_CompPlan;
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
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');
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);
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;
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);
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
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
2473: END IF;
2474: ELSE
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
2474: ELSE
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;
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
2487: END IF;
2488: ELSE
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
2488: ELSE
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;
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
2500: END IF;
2501: ELSE
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
2501: ELSE
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;
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
2514: ELSE
2515: ROLLBACK TO Create_CompPlan;
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;
2515: ROLLBACK TO Create_CompPlan;
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
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');
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);
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;
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);
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
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
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);
2555: -- Number of Plans successfully created in target
2556: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
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);
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);
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);
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);
2559: -- Number of Plans reused in tagret
2560: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_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);
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);
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);
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);
2563: -- Number of Plans which were not imported due to error
2564: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_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);
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);
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);
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);
2567: fnd_file.put_line(fnd_file.log, '**************************************************************');
2568: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
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);
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, '**************************************************************');
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: