DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on FND_MESSAGE

Line 406: fnd_message.set_name ('CN' , 'CN_COPY_EXP_REUSE');

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:

Line 407: fnd_message.set_token('EXPRESSION_NAME',v_name_node_value_new);

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

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

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

Line 485: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_MISS');

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;

Line 486: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

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;

Line 487: fnd_message.set_token('FORMULA_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;
491: ELSE

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

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

Line 525: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXP_MISS');

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;

Line 526: fnd_message.set_token('EXPRESSION_NAME_1',v_expression_rec.name);

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;

Line 527: fnd_message.set_token('EXPRESSION_NAME_2',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;
531: ELSE

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

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

Line 564: --fnd_message.set_name ('CN' , 'CN_COPY_EXP_PE_MTRC_MISS');

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;

Line 565: --fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.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;
569: l_pe_exist := FALSE;

Line 566: --fnd_message.set_token('PLAN_ELEMENT_NAME', g_miss_pe_exp_tbl(i).name);

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;

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

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

Line 600: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXT_MAP_MISS');

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;

Line 601: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

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;

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

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

Line 643: fnd_message.set_name ('CN' , 'CN_COPY_EXP_CREATE');

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

Line 644: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

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;

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

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

Line 650: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL_EXPECTED');

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;

Line 651: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

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

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

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

Line 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;

Line 657: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

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;

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

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

Line 664: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');

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

Line 665: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

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;

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

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

Line 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;

Line 671: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

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;

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

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

Line 711: fnd_message.set_name ('CN' , 'CN_COPY_RD_REUSE');

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:

Line 712: fnd_message.set_token('RATE_DIMENSION_NAME',v_name_node_value_new);

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

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

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

Line 816: fnd_message.set_name ('CN' , 'CN_COPY_RD_CREATE');

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

Line 817: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);

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');

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

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

Line 821: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');

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');

Line 822: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_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');
826: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);

Line 823: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.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);

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

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

Line 825: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');

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;

Line 826: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);

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;

Line 827: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.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;
831: COMMIT;

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

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

Line 835: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL_EXPECTED');

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;

Line 836: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);

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

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

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

Line 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;

Line 842: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);

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;

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

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

Line 849: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');

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

Line 850: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);

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;

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

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

Line 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

Line 856: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);

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;

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

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

Line 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;

Line 862: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);

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;

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

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

Line 902: fnd_message.set_name ('CN' , 'CN_COPY_RT_REUSE');

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:

Line 903: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);

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

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

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

Line 984: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');

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;

Line 985: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);

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: --*********************************************************************

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

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

Line 1021: fnd_message.set_name ('CN' , 'CN_COPY_RT_CREATE');

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

Line 1022: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);

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');

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

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

Line 1026: fnd_message.set_name ('CN' , 'CN_COPY_RD_RT_ASSIGN');

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;

Line 1027: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_sch_dims_tbl(i).rate_dim_name);

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;

Line 1028: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);

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;

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

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

Line 1036: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL_EXPECTED');

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;

Line 1037: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);

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

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

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

Line 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;

Line 1043: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);

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;

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

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

Line 1050: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');

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

Line 1051: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);

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;

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

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

Line 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

Line 1057: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);

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;

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

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

Line 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;

Line 1063: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);

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;

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

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

Line 1103: fnd_message.set_name ('CN' , 'CN_COPY_FM_REUSE');

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:

Line 1104: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);

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

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

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

Line 1337: --fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');

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;

Line 1338: --fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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:

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

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

Line 1378: fnd_message.set_name ('CN' , 'CN_COPY_FM_CREATE');

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);

Line 1379: fnd_message.set_token('FORMULA_NAME',v_formula_rec.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);

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

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

Line 1381: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');

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

Line 1382: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);

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');

Line 1383: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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);

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

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

Line 1386: 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);
1389: fnd_file.put_line(fnd_file.log, fnd_message.get);
1390: END IF;

Line 1387: fnd_message.set_token('EXPRESSION_NAME',l_f_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;
1391: IF l_perf_measure_name IS NOT NULL THEN

Line 1388: 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
1392: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');

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

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

Line 1392: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');

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;

Line 1393: fnd_message.set_token('EXPRESSION_NAME',l_perf_measure_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;
1397: IF (v_input_exp_tbl.COUNT > 0) THEN

Line 1394: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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

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

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

Line 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

Line 1400: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).calc_exp_name);

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');

Line 1401: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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);

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

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

Line 1404: 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);
1407: fnd_file.put_line(fnd_file.log, fnd_message.get);
1408: END IF;

Line 1405: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).f_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;
1409: END LOOP;

Line 1406: 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;
1410: END IF;

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

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

Line 1413: fnd_message.set_name ('CN' , 'CN_COPY_RT_FM_ASSIGN');

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

Line 1414: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);

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);

Line 1415: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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

Line 1416: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);

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');

Line 1418: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);

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);

Line 1420: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');

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;

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

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

Line 1429: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL_EXPECTED');

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;

Line 1430: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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

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

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

Line 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;

Line 1436: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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;

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

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

Line 1443: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');

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

Line 1444: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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;

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

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

Line 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

Line 1450: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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;

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

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

Line 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

Line 1456: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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;

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

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

Line 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

Line 1462: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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;

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

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

Line 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;

Line 1468: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);

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;

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

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

Line 1506: fnd_message.set_name ('CN' , 'CN_COPY_PE_REUSE');

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:

Line 1507: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);

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.

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

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

Line 1596: fnd_message.set_name ('CN' , 'CN_COPY_PE_EXT_FM_MISS');

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;

Line 1597: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);

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:

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

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

Line 1625: fnd_message.set_name ('CN' , 'CN_COPY_PE_INT_TYPE_MISS');

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;

Line 1626: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);

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;

Line 1627: fnd_message.set_token('INTERVAL_TYPE_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;
1631:

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

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

Line 1638: fnd_message.set_name ('CN' , 'CN_COPY_PE_CRD_TYPE_MISS');

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;

Line 1639: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);

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;

Line 1640: fnd_message.set_token('CREDIT_TYPE_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;
1644:

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

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

Line 1655: fnd_message.set_name ('CN' , 'CN_COPY_PE_PMT_GRP_DFLT');

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';

Line 1656: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);

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;

Line 1657: fnd_message.set_token('PAYMENT_GROUP_CODE_NAME',v_plan_element_rec.payment_group_code);

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:

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

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

Line 1757: fnd_message.set_name ('CN' , 'CN_COPY_PE_REV_CLS_MISS');

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;

Line 1758: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);

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;

Line 1759: fnd_message.set_token('PRODUCT_NAME',l_rev_class_name);

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:

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

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

Line 1859: fnd_message.set_name ('CN' , 'CN_COPY_PE_FCTRS_OUT_RANGE');

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;

Line 1860: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);

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;

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

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

Line 2131: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');

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);

Line 2132: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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

Line 2133: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);

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');

Line 2135: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);

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);

Line 2137: fnd_message.set_token('PLAN_ELEMENT_END_DATE', 'NULL');

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');

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

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

Line 2141: fnd_message.set_name ('CN' , 'CN_COPY_FM_PE_ASSIGN');

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

Line 2142: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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

Line 2143: fnd_message.set_token('FORMULA_NAME',v_plan_element_rec.calc_formula_name);

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

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

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

Line 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

Line 2149: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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);

Line 2150: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);

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

Line 2151: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);

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');

Line 2153: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);

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);

Line 2155: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');

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;

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

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

Line 2179: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL_EXPECTED');

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;

Line 2180: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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

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

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

Line 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;

Line 2186: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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;

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

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

Line 2193: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

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

Line 2194: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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;

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

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

Line 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

Line 2200: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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;

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

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

Line 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

Line 2206: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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;

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

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

Line 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

Line 2212: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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;

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

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

Line 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

Line 2218: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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;

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

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

Line 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;

Line 2224: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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;

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

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

Line 2262: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE');

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;

Line 2263: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);

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:

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

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

Line 2374: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');

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

Line 2375: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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;

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

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

Line 2420: fnd_message.set_name ('CN' , 'CN_COPY_PE_ASSIGN');

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;

Line 2421: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);

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

Line 2422: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);

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;

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

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

Line 2434: fnd_message.set_name ('CN' , 'CN_COPY_PE_OUT_RANGE');

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;

Line 2435: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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;

Line 2436: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);

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

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

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

Line 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);

Line 2442: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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

Line 2443: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);

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');

Line 2445: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);

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);

Line 2447: fnd_message.set_token('PLAN_END_DATE', 'NULL');

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;

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

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

Line 2456: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');

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;

Line 2457: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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

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

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

Line 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;

Line 2463: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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

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

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

Line 2477: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');

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

Line 2478: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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;

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

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

Line 2491: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');

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

Line 2492: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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;

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

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

Line 2504: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');

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

Line 2505: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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;

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

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

Line 2518: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');

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;

Line 2519: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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

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

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

Line 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;

Line 2525: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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

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

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

Line 2552: fnd_message.set_name ('CN' , 'CN_COPY_CP_REQ_COUNT');

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');

Line 2553: fnd_message.set_token('COUNT',p_object_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);

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

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

Line 2556: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');

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');

Line 2557: fnd_message.set_token('COUNT',p_success_obj_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);

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

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

Line 2560: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');

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');

Line 2561: fnd_message.set_token('COUNT',p_reuse_obj_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);

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

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

Line 2564: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');

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 ************************');

Line 2565: fnd_message.set_token('LIST',l_failed_plan_name);

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, '**************************************************************');

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

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