418: AND org_id=p_org_id;
419:
420: IF v_expression_rec.status <>'VALID' THEN
421:
422: fnd_message.set_name ('CN' , 'Expression exist in the target, in INVALID status');
423: fnd_message.set_token('EXPRESSION_NAME',v_name_node_value_new);
424: fnd_file.put_line(fnd_file.log, fnd_message.get);
425: l_sql_fail_count:=1;
426: ROLLBACK TO Create_Expression;
419:
420: IF v_expression_rec.status <>'VALID' THEN
421:
422: fnd_message.set_name ('CN' , 'Expression exist in the target, in INVALID status');
423: fnd_message.set_token('EXPRESSION_NAME',v_name_node_value_new);
424: fnd_file.put_line(fnd_file.log, fnd_message.get);
425: l_sql_fail_count:=1;
426: ROLLBACK TO Create_Expression;
427: EXIT;
420: IF v_expression_rec.status <>'VALID' THEN
421:
422: fnd_message.set_name ('CN' , 'Expression exist in the target, in INVALID status');
423: fnd_message.set_token('EXPRESSION_NAME',v_name_node_value_new);
424: fnd_file.put_line(fnd_file.log, fnd_message.get);
425: l_sql_fail_count:=1;
426: ROLLBACK TO Create_Expression;
427: EXIT;
428:
505: FROM cn_calc_formulas
506: WHERE name = g_miss_calc_edges_tbl(i).child_name
507: AND org_id = p_org_id;
508: IF l_formula_name_count = 0 THEN
509: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_MISS');
510: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
511: fnd_message.set_token('FORMULA_NAME',g_miss_calc_edges_tbl(i).child_name);
512: fnd_file.put_line(fnd_file.log, fnd_message.get);
513: l_sql_fail_count := 1;
506: WHERE name = g_miss_calc_edges_tbl(i).child_name
507: AND org_id = p_org_id;
508: IF l_formula_name_count = 0 THEN
509: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_MISS');
510: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
511: fnd_message.set_token('FORMULA_NAME',g_miss_calc_edges_tbl(i).child_name);
512: fnd_file.put_line(fnd_file.log, fnd_message.get);
513: l_sql_fail_count := 1;
514: EXIT;
507: AND org_id = p_org_id;
508: IF l_formula_name_count = 0 THEN
509: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_MISS');
510: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
511: fnd_message.set_token('FORMULA_NAME',g_miss_calc_edges_tbl(i).child_name);
512: fnd_file.put_line(fnd_file.log, fnd_message.get);
513: l_sql_fail_count := 1;
514: EXIT;
515: ELSE
508: IF l_formula_name_count = 0 THEN
509: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_MISS');
510: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
511: fnd_message.set_token('FORMULA_NAME',g_miss_calc_edges_tbl(i).child_name);
512: fnd_file.put_line(fnd_file.log, fnd_message.get);
513: l_sql_fail_count := 1;
514: EXIT;
515: ELSE
516: SELECT calc_formula_id INTO g_miss_calc_edges_tbl(i).child_id
545: FROM cn_calc_sql_exps
546: WHERE name = g_miss_calc_edges_tbl(i).child_name
547: AND org_id = p_org_id;
548: IF l_exp_name_count = 0 THEN
549: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXP_MISS');
550: fnd_message.set_token('EXPRESSION_NAME_1',v_expression_rec.name);
551: fnd_message.set_token('EXPRESSION_NAME_2',g_miss_calc_edges_tbl(i).child_name);
552: fnd_file.put_line(fnd_file.log, fnd_message.get);
553: l_sql_fail_count := 1;
546: WHERE name = g_miss_calc_edges_tbl(i).child_name
547: AND org_id = p_org_id;
548: IF l_exp_name_count = 0 THEN
549: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXP_MISS');
550: fnd_message.set_token('EXPRESSION_NAME_1',v_expression_rec.name);
551: fnd_message.set_token('EXPRESSION_NAME_2',g_miss_calc_edges_tbl(i).child_name);
552: fnd_file.put_line(fnd_file.log, fnd_message.get);
553: l_sql_fail_count := 1;
554: EXIT;
547: AND org_id = p_org_id;
548: IF l_exp_name_count = 0 THEN
549: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXP_MISS');
550: fnd_message.set_token('EXPRESSION_NAME_1',v_expression_rec.name);
551: fnd_message.set_token('EXPRESSION_NAME_2',g_miss_calc_edges_tbl(i).child_name);
552: fnd_file.put_line(fnd_file.log, fnd_message.get);
553: l_sql_fail_count := 1;
554: EXIT;
555: ELSE
548: IF l_exp_name_count = 0 THEN
549: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXP_MISS');
550: fnd_message.set_token('EXPRESSION_NAME_1',v_expression_rec.name);
551: fnd_message.set_token('EXPRESSION_NAME_2',g_miss_calc_edges_tbl(i).child_name);
552: fnd_file.put_line(fnd_file.log, fnd_message.get);
553: l_sql_fail_count := 1;
554: EXIT;
555: ELSE
556: SELECT calc_sql_exp_id INTO g_miss_calc_edges_tbl(i).child_id
650: AND object_type = 'TBL'
651: AND name = l_ee_tab_name_new;
652: -- Error Message - If table does not exist in Target System
653: IF l_ee_exist_obj_check = 0 THEN
654: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXT_MAP_MISS');
655: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
656: fnd_file.put_line(fnd_file.log, fnd_message.get);
657: l_sql_fail_count := 1;
658: EXIT;
651: AND name = l_ee_tab_name_new;
652: -- Error Message - If table does not exist in Target System
653: IF l_ee_exist_obj_check = 0 THEN
654: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXT_MAP_MISS');
655: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
656: fnd_file.put_line(fnd_file.log, fnd_message.get);
657: l_sql_fail_count := 1;
658: EXIT;
659: END IF;
652: -- Error Message - If table does not exist in Target System
653: IF l_ee_exist_obj_check = 0 THEN
654: fnd_message.set_name ('CN' , 'CN_COPY_EXP_EXT_MAP_MISS');
655: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
656: fnd_file.put_line(fnd_file.log, fnd_message.get);
657: l_sql_fail_count := 1;
658: EXIT;
659: END IF;
660: END IF;
704: , x_msg_data => x_msg_data
705: );
706:
707: IF x_return_status = fnd_api.g_ret_sts_success THEN
708: fnd_message.set_name ('CN' , 'CN_COPY_EXP_REUSE');
709: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
710: fnd_file.put_line(fnd_file.log, fnd_message.get);
711: COMMIT;
712: ELSE
705: );
706:
707: IF x_return_status = fnd_api.g_ret_sts_success THEN
708: fnd_message.set_name ('CN' , 'CN_COPY_EXP_REUSE');
709: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
710: fnd_file.put_line(fnd_file.log, fnd_message.get);
711: COMMIT;
712: ELSE
713: ROLLBACK TO Create_Expression;
706:
707: IF x_return_status = fnd_api.g_ret_sts_success THEN
708: fnd_message.set_name ('CN' , 'CN_COPY_EXP_REUSE');
709: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
710: fnd_file.put_line(fnd_file.log, fnd_message.get);
711: COMMIT;
712: ELSE
713: ROLLBACK TO Create_Expression;
714: IF x_return_status = fnd_api.g_ret_sts_error THEN
711: COMMIT;
712: ELSE
713: ROLLBACK TO Create_Expression;
714: IF x_return_status = fnd_api.g_ret_sts_error THEN
715: fnd_message.set_name ('CN' , 'Update of existing expression Failed with return status error');
716: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
717: fnd_file.put_line(fnd_file.log, fnd_message.get);
718: fnd_file.put_line(fnd_file.log, '***ERROR STATUS: '||x_msg_data);
719: END IF;
712: ELSE
713: ROLLBACK TO Create_Expression;
714: IF x_return_status = fnd_api.g_ret_sts_error THEN
715: fnd_message.set_name ('CN' , 'Update of existing expression Failed with return status error');
716: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
717: fnd_file.put_line(fnd_file.log, fnd_message.get);
718: fnd_file.put_line(fnd_file.log, '***ERROR STATUS: '||x_msg_data);
719: END IF;
720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
713: ROLLBACK TO Create_Expression;
714: IF x_return_status = fnd_api.g_ret_sts_error THEN
715: fnd_message.set_name ('CN' , 'Update of existing expression Failed with return status error');
716: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
717: fnd_file.put_line(fnd_file.log, fnd_message.get);
718: fnd_file.put_line(fnd_file.log, '***ERROR STATUS: '||x_msg_data);
719: END IF;
720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
721: fnd_message.set_name ('CN' , 'Update of existing expression failed with unexpected error');
717: fnd_file.put_line(fnd_file.log, fnd_message.get);
718: fnd_file.put_line(fnd_file.log, '***ERROR STATUS: '||x_msg_data);
719: END IF;
720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
721: fnd_message.set_name ('CN' , 'Update of existing expression failed with unexpected error');
722: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
723: fnd_file.put_line(fnd_file.log, fnd_message.get);
724: fnd_file.put_line(fnd_file.log, '***UNEXPECTED ERROR: '||x_msg_data);
725: END IF;
718: fnd_file.put_line(fnd_file.log, '***ERROR STATUS: '||x_msg_data);
719: END IF;
720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
721: fnd_message.set_name ('CN' , 'Update of existing expression failed with unexpected error');
722: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
723: fnd_file.put_line(fnd_file.log, fnd_message.get);
724: fnd_file.put_line(fnd_file.log, '***UNEXPECTED ERROR: '||x_msg_data);
725: END IF;
726: END IF; --end of x_return_status
719: END IF;
720: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
721: fnd_message.set_name ('CN' , 'Update of existing expression failed with unexpected error');
722: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
723: fnd_file.put_line(fnd_file.log, fnd_message.get);
724: fnd_file.put_line(fnd_file.log, '***UNEXPECTED ERROR: '||x_msg_data);
725: END IF;
726: END IF; --end of x_return_status
727:
753: x_msg_count => x_msg_count,
754: x_msg_data => x_msg_data,
755: x_object_version_number => x_object_version_number);
756: IF x_return_status = fnd_api.g_ret_sts_success THEN
757: fnd_message.set_name ('CN' , 'CN_COPY_EXP_CREATE');
758: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
759: fnd_file.put_line(fnd_file.log, fnd_message.get);
760: COMMIT;
761: ELSE
754: x_msg_data => x_msg_data,
755: x_object_version_number => x_object_version_number);
756: IF x_return_status = fnd_api.g_ret_sts_success THEN
757: fnd_message.set_name ('CN' , 'CN_COPY_EXP_CREATE');
758: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
759: fnd_file.put_line(fnd_file.log, fnd_message.get);
760: COMMIT;
761: ELSE
762: ROLLBACK TO Create_Expression;
755: x_object_version_number => x_object_version_number);
756: IF x_return_status = fnd_api.g_ret_sts_success THEN
757: fnd_message.set_name ('CN' , 'CN_COPY_EXP_CREATE');
758: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
759: fnd_file.put_line(fnd_file.log, fnd_message.get);
760: COMMIT;
761: ELSE
762: ROLLBACK TO Create_Expression;
763: IF x_return_status = fnd_api.g_ret_sts_error THEN
760: COMMIT;
761: ELSE
762: ROLLBACK TO Create_Expression;
763: IF x_return_status = fnd_api.g_ret_sts_error THEN
764: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL_EXPECTED');
765: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
766: fnd_file.put_line(fnd_file.log, fnd_message.get);
767: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
768: END IF;
761: ELSE
762: ROLLBACK TO Create_Expression;
763: IF x_return_status = fnd_api.g_ret_sts_error THEN
764: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL_EXPECTED');
765: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
766: fnd_file.put_line(fnd_file.log, fnd_message.get);
767: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
768: END IF;
769: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
762: ROLLBACK TO Create_Expression;
763: IF x_return_status = fnd_api.g_ret_sts_error THEN
764: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL_EXPECTED');
765: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
766: fnd_file.put_line(fnd_file.log, fnd_message.get);
767: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
768: END IF;
769: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
770: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
766: fnd_file.put_line(fnd_file.log, fnd_message.get);
767: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
768: END IF;
769: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
770: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
771: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
772: fnd_file.put_line(fnd_file.log, fnd_message.get);
773: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
774: END IF;
767: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
768: END IF;
769: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
770: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
771: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
772: fnd_file.put_line(fnd_file.log, fnd_message.get);
773: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
774: END IF;
775: END IF; --end of x_return_status
768: END IF;
769: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
770: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
771: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
772: fnd_file.put_line(fnd_file.log, fnd_message.get);
773: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
774: END IF;
775: END IF; --end of x_return_status
776:
776:
777: END IF; --end of l_reuse_count
778: ELSE
779: ROLLBACK TO Create_Expression;
780: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
781: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
782: fnd_file.put_line(fnd_file.log, fnd_message.get);
783:
784:
777: END IF; --end of l_reuse_count
778: ELSE
779: ROLLBACK TO Create_Expression;
780: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
781: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
782: fnd_file.put_line(fnd_file.log, fnd_message.get);
783:
784:
785: END IF; --end of l_sql_fail_count
778: ELSE
779: ROLLBACK TO Create_Expression;
780: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
781: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
782: fnd_file.put_line(fnd_file.log, fnd_message.get);
783:
784:
785: END IF; --end of l_sql_fail_count
786: ELSE
784:
785: END IF; --end of l_sql_fail_count
786: ELSE
787: ROLLBACK TO Create_Expression;
788: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
789: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
790: fnd_file.put_line(fnd_file.log, fnd_message.get);
791: END IF;
792: END IF; --end of CnCalcSqlExpsVO
785: END IF; --end of l_sql_fail_count
786: ELSE
787: ROLLBACK TO Create_Expression;
788: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
789: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
790: fnd_file.put_line(fnd_file.log, fnd_message.get);
791: END IF;
792: END IF; --end of CnCalcSqlExpsVO
793: -- END IF;
786: ELSE
787: ROLLBACK TO Create_Expression;
788: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FAIL');
789: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);
790: fnd_file.put_line(fnd_file.log, fnd_message.get);
791: END IF;
792: END IF; --end of CnCalcSqlExpsVO
793: -- END IF;
794:
825: AND org_id = p_org_id;
826:
827: --If Rate Dimension exists then do not Insert, Else insert a new record.
828: IF l_reuse_count > 0 THEN
829: fnd_message.set_name ('CN' , 'CN_COPY_RD_REUSE');
830: fnd_message.set_token('RATE_DIMENSION_NAME',v_name_node_value_new);
831: fnd_file.put_line(fnd_file.log, fnd_message.get);
832: END IF;
833:
826:
827: --If Rate Dimension exists then do not Insert, Else insert a new record.
828: IF l_reuse_count > 0 THEN
829: fnd_message.set_name ('CN' , 'CN_COPY_RD_REUSE');
830: fnd_message.set_token('RATE_DIMENSION_NAME',v_name_node_value_new);
831: fnd_file.put_line(fnd_file.log, fnd_message.get);
832: END IF;
833:
834: IF l_reuse_count = 0 THEN
827: --If Rate Dimension exists then do not Insert, Else insert a new record.
828: IF l_reuse_count > 0 THEN
829: fnd_message.set_name ('CN' , 'CN_COPY_RD_REUSE');
830: fnd_message.set_token('RATE_DIMENSION_NAME',v_name_node_value_new);
831: fnd_file.put_line(fnd_file.log, fnd_message.get);
832: END IF;
833:
834: IF l_reuse_count = 0 THEN
835: -- Get the other Rate Dimension Values
930: x_return_status => x_return_status,
931: x_msg_count => x_msg_count,
932: x_msg_data => x_msg_data);
933: IF x_return_status = fnd_api.g_ret_sts_success THEN
934: fnd_message.set_name ('CN' , 'CN_COPY_RD_CREATE');
935: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
936: fnd_file.put_line(fnd_file.log, fnd_message.get);
937: IF (g_miss_rate_dim_exp_tbl.COUNT > 0 AND v_rate_dimension_rec.dim_unit_code = 'EXPRESSION') THEN
938: FOR i IN g_miss_rate_dim_exp_tbl.FIRST..g_miss_rate_dim_exp_tbl.LAST LOOP
931: x_msg_count => x_msg_count,
932: x_msg_data => x_msg_data);
933: IF x_return_status = fnd_api.g_ret_sts_success THEN
934: fnd_message.set_name ('CN' , 'CN_COPY_RD_CREATE');
935: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
936: fnd_file.put_line(fnd_file.log, fnd_message.get);
937: IF (g_miss_rate_dim_exp_tbl.COUNT > 0 AND v_rate_dimension_rec.dim_unit_code = 'EXPRESSION') THEN
938: FOR i IN g_miss_rate_dim_exp_tbl.FIRST..g_miss_rate_dim_exp_tbl.LAST LOOP
939: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
932: x_msg_data => x_msg_data);
933: IF x_return_status = fnd_api.g_ret_sts_success THEN
934: fnd_message.set_name ('CN' , 'CN_COPY_RD_CREATE');
935: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
936: fnd_file.put_line(fnd_file.log, fnd_message.get);
937: IF (g_miss_rate_dim_exp_tbl.COUNT > 0 AND v_rate_dimension_rec.dim_unit_code = 'EXPRESSION') THEN
938: FOR i IN g_miss_rate_dim_exp_tbl.FIRST..g_miss_rate_dim_exp_tbl.LAST LOOP
939: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
940: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_name);
935: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
936: fnd_file.put_line(fnd_file.log, fnd_message.get);
937: IF (g_miss_rate_dim_exp_tbl.COUNT > 0 AND v_rate_dimension_rec.dim_unit_code = 'EXPRESSION') THEN
938: FOR i IN g_miss_rate_dim_exp_tbl.FIRST..g_miss_rate_dim_exp_tbl.LAST LOOP
939: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
940: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_name);
941: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
942: fnd_file.put_line(fnd_file.log, fnd_message.get);
943: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
936: fnd_file.put_line(fnd_file.log, fnd_message.get);
937: IF (g_miss_rate_dim_exp_tbl.COUNT > 0 AND v_rate_dimension_rec.dim_unit_code = 'EXPRESSION') THEN
938: FOR i IN g_miss_rate_dim_exp_tbl.FIRST..g_miss_rate_dim_exp_tbl.LAST LOOP
939: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
940: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_name);
941: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
942: fnd_file.put_line(fnd_file.log, fnd_message.get);
943: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
944: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);
937: IF (g_miss_rate_dim_exp_tbl.COUNT > 0 AND v_rate_dimension_rec.dim_unit_code = 'EXPRESSION') THEN
938: FOR i IN g_miss_rate_dim_exp_tbl.FIRST..g_miss_rate_dim_exp_tbl.LAST LOOP
939: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
940: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_name);
941: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
942: fnd_file.put_line(fnd_file.log, fnd_message.get);
943: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
944: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);
945: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
938: FOR i IN g_miss_rate_dim_exp_tbl.FIRST..g_miss_rate_dim_exp_tbl.LAST LOOP
939: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
940: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_name);
941: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
942: fnd_file.put_line(fnd_file.log, fnd_message.get);
943: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
944: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);
945: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
946: fnd_file.put_line(fnd_file.log, fnd_message.get);
939: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
940: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_name);
941: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
942: fnd_file.put_line(fnd_file.log, fnd_message.get);
943: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
944: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);
945: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
946: fnd_file.put_line(fnd_file.log, fnd_message.get);
947: END LOOP;
940: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).min_exp_name);
941: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
942: fnd_file.put_line(fnd_file.log, fnd_message.get);
943: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
944: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);
945: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
946: fnd_file.put_line(fnd_file.log, fnd_message.get);
947: END LOOP;
948: END IF;
941: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
942: fnd_file.put_line(fnd_file.log, fnd_message.get);
943: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
944: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);
945: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
946: fnd_file.put_line(fnd_file.log, fnd_message.get);
947: END LOOP;
948: END IF;
949: COMMIT;
942: fnd_file.put_line(fnd_file.log, fnd_message.get);
943: fnd_message.set_name ('CN' , 'CN_COPY_EXP_RD_ASSIGN');
944: fnd_message.set_token('EXPRESION_NAME',g_miss_rate_dim_exp_tbl(i).max_exp_name);
945: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
946: fnd_file.put_line(fnd_file.log, fnd_message.get);
947: END LOOP;
948: END IF;
949: COMMIT;
950: ELSE
949: COMMIT;
950: ELSE
951: ROLLBACK TO Create_RateDimension;
952: IF x_return_status = fnd_api.g_ret_sts_error THEN
953: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL_EXPECTED');
954: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
955: fnd_file.put_line(fnd_file.log, fnd_message.get);
956: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
957: END IF;
950: ELSE
951: ROLLBACK TO Create_RateDimension;
952: IF x_return_status = fnd_api.g_ret_sts_error THEN
953: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL_EXPECTED');
954: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
955: fnd_file.put_line(fnd_file.log, fnd_message.get);
956: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
957: END IF;
958: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
951: ROLLBACK TO Create_RateDimension;
952: IF x_return_status = fnd_api.g_ret_sts_error THEN
953: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL_EXPECTED');
954: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
955: fnd_file.put_line(fnd_file.log, fnd_message.get);
956: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
957: END IF;
958: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
959: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
955: fnd_file.put_line(fnd_file.log, fnd_message.get);
956: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
957: END IF;
958: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
959: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
960: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
961: fnd_file.put_line(fnd_file.log, fnd_message.get);
962: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
963: END IF;
956: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
957: END IF;
958: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
959: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
960: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
961: fnd_file.put_line(fnd_file.log, fnd_message.get);
962: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
963: END IF;
964: END IF;
957: END IF;
958: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
959: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
960: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
961: fnd_file.put_line(fnd_file.log, fnd_message.get);
962: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
963: END IF;
964: END IF;
965: ELSE
963: END IF;
964: END IF;
965: ELSE
966: ROLLBACK TO Create_RateDimension;
967: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
968: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
969: fnd_file.put_line(fnd_file.log, fnd_message.get);
970: END IF;
971: ELSE
964: END IF;
965: ELSE
966: ROLLBACK TO Create_RateDimension;
967: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
968: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
969: fnd_file.put_line(fnd_file.log, fnd_message.get);
970: END IF;
971: ELSE
972: ROLLBACK TO Create_RateDimension;
965: ELSE
966: ROLLBACK TO Create_RateDimension;
967: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
968: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
969: fnd_file.put_line(fnd_file.log, fnd_message.get);
970: END IF;
971: ELSE
972: ROLLBACK TO Create_RateDimension;
973: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
969: fnd_file.put_line(fnd_file.log, fnd_message.get);
970: END IF;
971: ELSE
972: ROLLBACK TO Create_RateDimension;
973: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
974: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
975: fnd_file.put_line(fnd_file.log, fnd_message.get);
976: END IF;
977: ELSE
970: END IF;
971: ELSE
972: ROLLBACK TO Create_RateDimension;
973: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
974: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
975: fnd_file.put_line(fnd_file.log, fnd_message.get);
976: END IF;
977: ELSE
978: ROLLBACK TO Create_RateDimension;
971: ELSE
972: ROLLBACK TO Create_RateDimension;
973: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
974: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
975: fnd_file.put_line(fnd_file.log, fnd_message.get);
976: END IF;
977: ELSE
978: ROLLBACK TO Create_RateDimension;
979: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
975: fnd_file.put_line(fnd_file.log, fnd_message.get);
976: END IF;
977: ELSE
978: ROLLBACK TO Create_RateDimension;
979: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
980: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
981: fnd_file.put_line(fnd_file.log, fnd_message.get);
982: END IF;
983: END IF;
976: END IF;
977: ELSE
978: ROLLBACK TO Create_RateDimension;
979: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
980: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
981: fnd_file.put_line(fnd_file.log, fnd_message.get);
982: END IF;
983: END IF;
984: END IF;
977: ELSE
978: ROLLBACK TO Create_RateDimension;
979: fnd_message.set_name ('CN' , 'CN_COPY_RD_FAIL');
980: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_dimension_rec.name);
981: fnd_file.put_line(fnd_file.log, fnd_message.get);
982: END IF;
983: END IF;
984: END IF;
985:
1016:
1017: --If Rate Table exists then do not Insert otherwise insert a new Record.
1018: IF l_reuse_count > 0 THEN
1019: ROLLBACK TO Create_RateSchedule;
1020: fnd_message.set_name ('CN' , 'CN_COPY_RT_REUSE');
1021: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);
1022: fnd_file.put_line(fnd_file.log, fnd_message.get);
1023: END IF;
1024:
1017: --If Rate Table exists then do not Insert otherwise insert a new Record.
1018: IF l_reuse_count > 0 THEN
1019: ROLLBACK TO Create_RateSchedule;
1020: fnd_message.set_name ('CN' , 'CN_COPY_RT_REUSE');
1021: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);
1022: fnd_file.put_line(fnd_file.log, fnd_message.get);
1023: END IF;
1024:
1025: IF l_reuse_count = 0 THEN
1018: IF l_reuse_count > 0 THEN
1019: ROLLBACK TO Create_RateSchedule;
1020: fnd_message.set_name ('CN' , 'CN_COPY_RT_REUSE');
1021: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);
1022: fnd_file.put_line(fnd_file.log, fnd_message.get);
1023: END IF;
1024:
1025: IF l_reuse_count = 0 THEN
1026: -- Get the other Rate Table values
1103: := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_sibling_cast_Next,'RateSequence'),0)));
1104: END LOOP;
1105: ELSE
1106: ROLLBACK TO Create_RateSchedule;
1107: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1108: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1109: fnd_file.put_line(fnd_file.log, fnd_message.get);
1110: END IF;
1111: END IF;
1104: END LOOP;
1105: ELSE
1106: ROLLBACK TO Create_RateSchedule;
1107: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1108: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1109: fnd_file.put_line(fnd_file.log, fnd_message.get);
1110: END IF;
1111: END IF;
1112: --*********************************************************************
1105: ELSE
1106: ROLLBACK TO Create_RateSchedule;
1107: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1108: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1109: fnd_file.put_line(fnd_file.log, fnd_message.get);
1110: END IF;
1111: END IF;
1112: --*********************************************************************
1113: -- Import Rate Table - Rate Schedule
1140: p_object_version_number => x_object_version_number,
1141: p_org_id => p_org_id);
1142: END LOOP;
1143: END IF;
1144: fnd_message.set_name ('CN' , 'CN_COPY_RT_CREATE');
1145: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);
1146: fnd_file.put_line(fnd_file.log, fnd_message.get);
1147: IF (v_rate_sch_dims_tbl.COUNT > 0) THEN
1148: FOR i IN v_rate_sch_dims_tbl.FIRST..v_rate_sch_dims_tbl.LAST LOOP
1141: p_org_id => p_org_id);
1142: END LOOP;
1143: END IF;
1144: fnd_message.set_name ('CN' , 'CN_COPY_RT_CREATE');
1145: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);
1146: fnd_file.put_line(fnd_file.log, fnd_message.get);
1147: IF (v_rate_sch_dims_tbl.COUNT > 0) THEN
1148: FOR i IN v_rate_sch_dims_tbl.FIRST..v_rate_sch_dims_tbl.LAST LOOP
1149: fnd_message.set_name ('CN' , 'CN_COPY_RD_RT_ASSIGN');
1142: END LOOP;
1143: END IF;
1144: fnd_message.set_name ('CN' , 'CN_COPY_RT_CREATE');
1145: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);
1146: fnd_file.put_line(fnd_file.log, fnd_message.get);
1147: IF (v_rate_sch_dims_tbl.COUNT > 0) THEN
1148: FOR i IN v_rate_sch_dims_tbl.FIRST..v_rate_sch_dims_tbl.LAST LOOP
1149: fnd_message.set_name ('CN' , 'CN_COPY_RD_RT_ASSIGN');
1150: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_sch_dims_tbl(i).rate_dim_name);
1145: fnd_message.set_token('RATE_TABLE_NAME',v_name_node_value_new);
1146: fnd_file.put_line(fnd_file.log, fnd_message.get);
1147: IF (v_rate_sch_dims_tbl.COUNT > 0) THEN
1148: FOR i IN v_rate_sch_dims_tbl.FIRST..v_rate_sch_dims_tbl.LAST LOOP
1149: fnd_message.set_name ('CN' , 'CN_COPY_RD_RT_ASSIGN');
1150: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_sch_dims_tbl(i).rate_dim_name);
1151: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1152: fnd_file.put_line(fnd_file.log, fnd_message.get);
1153: END LOOP;
1146: fnd_file.put_line(fnd_file.log, fnd_message.get);
1147: IF (v_rate_sch_dims_tbl.COUNT > 0) THEN
1148: FOR i IN v_rate_sch_dims_tbl.FIRST..v_rate_sch_dims_tbl.LAST LOOP
1149: fnd_message.set_name ('CN' , 'CN_COPY_RD_RT_ASSIGN');
1150: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_sch_dims_tbl(i).rate_dim_name);
1151: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1152: fnd_file.put_line(fnd_file.log, fnd_message.get);
1153: END LOOP;
1154: END IF;
1147: IF (v_rate_sch_dims_tbl.COUNT > 0) THEN
1148: FOR i IN v_rate_sch_dims_tbl.FIRST..v_rate_sch_dims_tbl.LAST LOOP
1149: fnd_message.set_name ('CN' , 'CN_COPY_RD_RT_ASSIGN');
1150: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_sch_dims_tbl(i).rate_dim_name);
1151: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1152: fnd_file.put_line(fnd_file.log, fnd_message.get);
1153: END LOOP;
1154: END IF;
1155: COMMIT;
1148: FOR i IN v_rate_sch_dims_tbl.FIRST..v_rate_sch_dims_tbl.LAST LOOP
1149: fnd_message.set_name ('CN' , 'CN_COPY_RD_RT_ASSIGN');
1150: fnd_message.set_token('RATE_DIMENSION_NAME',v_rate_sch_dims_tbl(i).rate_dim_name);
1151: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1152: fnd_file.put_line(fnd_file.log, fnd_message.get);
1153: END LOOP;
1154: END IF;
1155: COMMIT;
1156: ELSE
1155: COMMIT;
1156: ELSE
1157: ROLLBACK TO Create_RateDimension;
1158: IF x_return_status = fnd_api.g_ret_sts_error THEN
1159: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL_EXPECTED');
1160: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1163: END IF;
1156: ELSE
1157: ROLLBACK TO Create_RateDimension;
1158: IF x_return_status = fnd_api.g_ret_sts_error THEN
1159: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL_EXPECTED');
1160: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1163: END IF;
1164: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1157: ROLLBACK TO Create_RateDimension;
1158: IF x_return_status = fnd_api.g_ret_sts_error THEN
1159: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL_EXPECTED');
1160: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1163: END IF;
1164: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1165: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1163: END IF;
1164: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1165: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1166: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1167: fnd_file.put_line(fnd_file.log, fnd_message.get);
1168: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1169: END IF;
1162: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1163: END IF;
1164: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1165: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1166: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1167: fnd_file.put_line(fnd_file.log, fnd_message.get);
1168: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1169: END IF;
1170: END IF;
1163: END IF;
1164: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1165: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1166: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1167: fnd_file.put_line(fnd_file.log, fnd_message.get);
1168: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1169: END IF;
1170: END IF;
1171: ELSE
1169: END IF;
1170: END IF;
1171: ELSE
1172: ROLLBACK TO Create_RateSchedule;
1173: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1174: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1175: fnd_file.put_line(fnd_file.log, fnd_message.get);
1176: END IF;
1177: ELSE
1170: END IF;
1171: ELSE
1172: ROLLBACK TO Create_RateSchedule;
1173: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1174: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1175: fnd_file.put_line(fnd_file.log, fnd_message.get);
1176: END IF;
1177: ELSE
1178: ROLLBACK TO Create_RateSchedule;
1171: ELSE
1172: ROLLBACK TO Create_RateSchedule;
1173: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1174: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1175: fnd_file.put_line(fnd_file.log, fnd_message.get);
1176: END IF;
1177: ELSE
1178: ROLLBACK TO Create_RateSchedule;
1179: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1175: fnd_file.put_line(fnd_file.log, fnd_message.get);
1176: END IF;
1177: ELSE
1178: ROLLBACK TO Create_RateSchedule;
1179: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1180: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1181: fnd_file.put_line(fnd_file.log, fnd_message.get);
1182: END IF;
1183: ELSE
1176: END IF;
1177: ELSE
1178: ROLLBACK TO Create_RateSchedule;
1179: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1180: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1181: fnd_file.put_line(fnd_file.log, fnd_message.get);
1182: END IF;
1183: ELSE
1184: ROLLBACK TO Create_RateSchedule;
1177: ELSE
1178: ROLLBACK TO Create_RateSchedule;
1179: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1180: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1181: fnd_file.put_line(fnd_file.log, fnd_message.get);
1182: END IF;
1183: ELSE
1184: ROLLBACK TO Create_RateSchedule;
1185: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1181: fnd_file.put_line(fnd_file.log, fnd_message.get);
1182: END IF;
1183: ELSE
1184: ROLLBACK TO Create_RateSchedule;
1185: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1186: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1187: fnd_file.put_line(fnd_file.log, fnd_message.get);
1188: END IF;
1189: END IF;
1182: END IF;
1183: ELSE
1184: ROLLBACK TO Create_RateSchedule;
1185: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1186: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1187: fnd_file.put_line(fnd_file.log, fnd_message.get);
1188: END IF;
1189: END IF;
1190: END IF;
1183: ELSE
1184: ROLLBACK TO Create_RateSchedule;
1185: fnd_message.set_name ('CN' , 'CN_COPY_RT_FAIL');
1186: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);
1187: fnd_file.put_line(fnd_file.log, fnd_message.get);
1188: END IF;
1189: END IF;
1190: END IF;
1191:
1229: WHERE name=v_name_node_value_new
1230: AND org_id = p_org_id;
1231:
1232: IF v_formula_rec.formula_status = 'COMPLETE' THEN
1233: fnd_message.set_name ('CN' , 'CN_COPY_FM_REUSE');
1234: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: ELSE
1237: fnd_message.set_name ('CN' , 'Formula Exist in the targe,in INCOMPLETE status');
1230: AND org_id = p_org_id;
1231:
1232: IF v_formula_rec.formula_status = 'COMPLETE' THEN
1233: fnd_message.set_name ('CN' , 'CN_COPY_FM_REUSE');
1234: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: ELSE
1237: fnd_message.set_name ('CN' , 'Formula Exist in the targe,in INCOMPLETE status');
1238: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1231:
1232: IF v_formula_rec.formula_status = 'COMPLETE' THEN
1233: fnd_message.set_name ('CN' , 'CN_COPY_FM_REUSE');
1234: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: ELSE
1237: fnd_message.set_name ('CN' , 'Formula Exist in the targe,in INCOMPLETE status');
1238: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1239: fnd_file.put_line(fnd_file.log, fnd_message.get);
1233: fnd_message.set_name ('CN' , 'CN_COPY_FM_REUSE');
1234: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: ELSE
1237: fnd_message.set_name ('CN' , 'Formula Exist in the targe,in INCOMPLETE status');
1238: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1239: fnd_file.put_line(fnd_file.log, fnd_message.get);
1240: ROLLBACK TO Create_Formula;
1241: EXIT;
1234: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: ELSE
1237: fnd_message.set_name ('CN' , 'Formula Exist in the targe,in INCOMPLETE status');
1238: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1239: fnd_file.put_line(fnd_file.log, fnd_message.get);
1240: ROLLBACK TO Create_Formula;
1241: EXIT;
1242:
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: ELSE
1237: fnd_message.set_name ('CN' , 'Formula Exist in the targe,in INCOMPLETE status');
1238: fnd_message.set_token('FORMULA_NAME',v_name_node_value_new);
1239: fnd_file.put_line(fnd_file.log, fnd_message.get);
1240: ROLLBACK TO Create_Formula;
1241: EXIT;
1242:
1243: END IF;
1495: END LOOP;
1496: ELSE
1497: l_sql_fail_count := 1;
1498: --ROLLBACK TO Create_Formula;
1499: --fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1500: --fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1501: --fnd_file.put_line(fnd_file.log, fnd_message.get);
1502: END IF;
1503: END IF;
1496: ELSE
1497: l_sql_fail_count := 1;
1498: --ROLLBACK TO Create_Formula;
1499: --fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1500: --fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1501: --fnd_file.put_line(fnd_file.log, fnd_message.get);
1502: END IF;
1503: END IF;
1504:
1497: l_sql_fail_count := 1;
1498: --ROLLBACK TO Create_Formula;
1499: --fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1500: --fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1501: --fnd_file.put_line(fnd_file.log, fnd_message.get);
1502: END IF;
1503: END IF;
1504:
1505: IF l_sql_fail_count = 0 THEN
1536: x_msg_count => x_msg_count,
1537: x_msg_data => x_msg_data);
1538:
1539: IF x_return_status = fnd_api.g_ret_sts_success THEN
1540: fnd_message.set_name ('CN' , 'CN_COPY_FM_CREATE');
1541: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1542: fnd_file.put_line(fnd_file.log, fnd_message.get);
1543: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1544: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1537: x_msg_data => x_msg_data);
1538:
1539: IF x_return_status = fnd_api.g_ret_sts_success THEN
1540: fnd_message.set_name ('CN' , 'CN_COPY_FM_CREATE');
1541: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1542: fnd_file.put_line(fnd_file.log, fnd_message.get);
1543: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1544: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1545: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1538:
1539: IF x_return_status = fnd_api.g_ret_sts_success THEN
1540: fnd_message.set_name ('CN' , 'CN_COPY_FM_CREATE');
1541: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1542: fnd_file.put_line(fnd_file.log, fnd_message.get);
1543: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1544: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1545: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1546: fnd_file.put_line(fnd_file.log, fnd_message.get);
1539: IF x_return_status = fnd_api.g_ret_sts_success THEN
1540: fnd_message.set_name ('CN' , 'CN_COPY_FM_CREATE');
1541: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1542: fnd_file.put_line(fnd_file.log, fnd_message.get);
1543: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1544: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1545: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1546: fnd_file.put_line(fnd_file.log, fnd_message.get);
1547: IF l_f_output_exp_name IS NOT NULL THEN
1540: fnd_message.set_name ('CN' , 'CN_COPY_FM_CREATE');
1541: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1542: fnd_file.put_line(fnd_file.log, fnd_message.get);
1543: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1544: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1545: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1546: fnd_file.put_line(fnd_file.log, fnd_message.get);
1547: IF l_f_output_exp_name IS NOT NULL THEN
1548: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1541: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1542: fnd_file.put_line(fnd_file.log, fnd_message.get);
1543: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1544: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1545: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1546: fnd_file.put_line(fnd_file.log, fnd_message.get);
1547: IF l_f_output_exp_name IS NOT NULL THEN
1548: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1549: fnd_message.set_token('EXPRESSION_NAME',l_f_output_exp_name);
1542: fnd_file.put_line(fnd_file.log, fnd_message.get);
1543: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1544: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1545: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1546: fnd_file.put_line(fnd_file.log, fnd_message.get);
1547: IF l_f_output_exp_name IS NOT NULL THEN
1548: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1549: fnd_message.set_token('EXPRESSION_NAME',l_f_output_exp_name);
1550: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1544: fnd_message.set_token('EXPRESSION_NAME',l_output_exp_name);
1545: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1546: fnd_file.put_line(fnd_file.log, fnd_message.get);
1547: IF l_f_output_exp_name IS NOT NULL THEN
1548: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1549: fnd_message.set_token('EXPRESSION_NAME',l_f_output_exp_name);
1550: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1551: fnd_file.put_line(fnd_file.log, fnd_message.get);
1552: END IF;
1545: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1546: fnd_file.put_line(fnd_file.log, fnd_message.get);
1547: IF l_f_output_exp_name IS NOT NULL THEN
1548: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1549: fnd_message.set_token('EXPRESSION_NAME',l_f_output_exp_name);
1550: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1551: fnd_file.put_line(fnd_file.log, fnd_message.get);
1552: END IF;
1553: IF l_perf_measure_name IS NOT NULL THEN
1546: fnd_file.put_line(fnd_file.log, fnd_message.get);
1547: IF l_f_output_exp_name IS NOT NULL THEN
1548: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1549: fnd_message.set_token('EXPRESSION_NAME',l_f_output_exp_name);
1550: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1551: fnd_file.put_line(fnd_file.log, fnd_message.get);
1552: END IF;
1553: IF l_perf_measure_name IS NOT NULL THEN
1554: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1547: IF l_f_output_exp_name IS NOT NULL THEN
1548: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1549: fnd_message.set_token('EXPRESSION_NAME',l_f_output_exp_name);
1550: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1551: fnd_file.put_line(fnd_file.log, fnd_message.get);
1552: END IF;
1553: IF l_perf_measure_name IS NOT NULL THEN
1554: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1555: fnd_message.set_token('EXPRESSION_NAME',l_perf_measure_name);
1550: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1551: fnd_file.put_line(fnd_file.log, fnd_message.get);
1552: END IF;
1553: IF l_perf_measure_name IS NOT NULL THEN
1554: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1555: fnd_message.set_token('EXPRESSION_NAME',l_perf_measure_name);
1556: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558: END IF;
1551: fnd_file.put_line(fnd_file.log, fnd_message.get);
1552: END IF;
1553: IF l_perf_measure_name IS NOT NULL THEN
1554: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1555: fnd_message.set_token('EXPRESSION_NAME',l_perf_measure_name);
1556: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558: END IF;
1559: IF (v_input_exp_tbl.COUNT > 0) THEN
1552: END IF;
1553: IF l_perf_measure_name IS NOT NULL THEN
1554: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1555: fnd_message.set_token('EXPRESSION_NAME',l_perf_measure_name);
1556: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558: END IF;
1559: IF (v_input_exp_tbl.COUNT > 0) THEN
1560: FOR i IN v_input_exp_tbl.FIRST..v_input_exp_tbl.LAST LOOP
1553: IF l_perf_measure_name IS NOT NULL THEN
1554: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1555: fnd_message.set_token('EXPRESSION_NAME',l_perf_measure_name);
1556: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558: END IF;
1559: IF (v_input_exp_tbl.COUNT > 0) THEN
1560: FOR i IN v_input_exp_tbl.FIRST..v_input_exp_tbl.LAST LOOP
1561: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558: END IF;
1559: IF (v_input_exp_tbl.COUNT > 0) THEN
1560: FOR i IN v_input_exp_tbl.FIRST..v_input_exp_tbl.LAST LOOP
1561: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1562: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).calc_exp_name);
1563: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1558: END IF;
1559: IF (v_input_exp_tbl.COUNT > 0) THEN
1560: FOR i IN v_input_exp_tbl.FIRST..v_input_exp_tbl.LAST LOOP
1561: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1562: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).calc_exp_name);
1563: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1566: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1559: IF (v_input_exp_tbl.COUNT > 0) THEN
1560: FOR i IN v_input_exp_tbl.FIRST..v_input_exp_tbl.LAST LOOP
1561: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1562: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).calc_exp_name);
1563: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1566: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1567: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).f_calc_exp_name);
1560: FOR i IN v_input_exp_tbl.FIRST..v_input_exp_tbl.LAST LOOP
1561: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1562: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).calc_exp_name);
1563: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1566: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1567: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).f_calc_exp_name);
1568: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1562: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).calc_exp_name);
1563: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1566: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1567: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).f_calc_exp_name);
1568: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1569: fnd_file.put_line(fnd_file.log, fnd_message.get);
1570: END IF;
1563: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1566: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1567: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).f_calc_exp_name);
1568: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1569: fnd_file.put_line(fnd_file.log, fnd_message.get);
1570: END IF;
1571: END LOOP;
1564: fnd_file.put_line(fnd_file.log, fnd_message.get);
1565: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1566: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1567: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).f_calc_exp_name);
1568: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1569: fnd_file.put_line(fnd_file.log, fnd_message.get);
1570: END IF;
1571: END LOOP;
1572: END IF;
1565: IF v_input_exp_tbl(i).f_calc_exp_name IS NOT NULL THEN
1566: fnd_message.set_name ('CN' , 'CN_COPY_EXP_FM_ASSIGN');
1567: fnd_message.set_token('EXPRESSION_NAME',v_input_exp_tbl(i).f_calc_exp_name);
1568: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1569: fnd_file.put_line(fnd_file.log, fnd_message.get);
1570: END IF;
1571: END LOOP;
1572: END IF;
1573: IF (v_rt_assign_tbl.COUNT > 0) THEN
1571: END LOOP;
1572: END IF;
1573: IF (v_rt_assign_tbl.COUNT > 0) THEN
1574: FOR i IN v_rt_assign_tbl.FIRST..v_rt_assign_tbl.LAST LOOP
1575: fnd_message.set_name ('CN' , 'CN_COPY_RT_FM_ASSIGN');
1576: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1577: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1578: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1579: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
1572: END IF;
1573: IF (v_rt_assign_tbl.COUNT > 0) THEN
1574: FOR i IN v_rt_assign_tbl.FIRST..v_rt_assign_tbl.LAST LOOP
1575: fnd_message.set_name ('CN' , 'CN_COPY_RT_FM_ASSIGN');
1576: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1577: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1578: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1579: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
1580: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);
1573: IF (v_rt_assign_tbl.COUNT > 0) THEN
1574: FOR i IN v_rt_assign_tbl.FIRST..v_rt_assign_tbl.LAST LOOP
1575: fnd_message.set_name ('CN' , 'CN_COPY_RT_FM_ASSIGN');
1576: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1577: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1578: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1579: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
1580: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);
1581: ELSE
1574: FOR i IN v_rt_assign_tbl.FIRST..v_rt_assign_tbl.LAST LOOP
1575: fnd_message.set_name ('CN' , 'CN_COPY_RT_FM_ASSIGN');
1576: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1577: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1578: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1579: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
1580: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);
1581: ELSE
1582: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
1576: fnd_message.set_token('RATE_TABLE_NAME',v_rt_assign_tbl(i).rate_schedule_name);
1577: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1578: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1579: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
1580: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);
1581: ELSE
1582: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
1583: END IF;
1584: fnd_file.put_line(fnd_file.log, fnd_message.get);
1578: fnd_message.set_token('ASSIGNMENT_START_DATE', v_rt_assign_tbl(i).start_date);
1579: IF v_rt_assign_tbl(i).end_date IS NOT NULL THEN
1580: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);
1581: ELSE
1582: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
1583: END IF;
1584: fnd_file.put_line(fnd_file.log, fnd_message.get);
1585: END LOOP;
1586: END IF;
1580: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_assign_tbl(i).end_date);
1581: ELSE
1582: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
1583: END IF;
1584: fnd_file.put_line(fnd_file.log, fnd_message.get);
1585: END LOOP;
1586: END IF;
1587: COMMIT;
1588: ELSE
1587: COMMIT;
1588: ELSE
1589: -- No ROLLBACK TO Create_Formula - Generate has a separate COMMIT cycle.
1590: IF x_return_status = fnd_api.g_ret_sts_error THEN
1591: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL_EXPECTED');
1592: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1593: fnd_file.put_line(fnd_file.log, fnd_message.get);
1594: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1595: END IF;
1588: ELSE
1589: -- No ROLLBACK TO Create_Formula - Generate has a separate COMMIT cycle.
1590: IF x_return_status = fnd_api.g_ret_sts_error THEN
1591: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL_EXPECTED');
1592: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1593: fnd_file.put_line(fnd_file.log, fnd_message.get);
1594: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1595: END IF;
1596: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1589: -- No ROLLBACK TO Create_Formula - Generate has a separate COMMIT cycle.
1590: IF x_return_status = fnd_api.g_ret_sts_error THEN
1591: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL_EXPECTED');
1592: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1593: fnd_file.put_line(fnd_file.log, fnd_message.get);
1594: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1595: END IF;
1596: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1597: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1593: fnd_file.put_line(fnd_file.log, fnd_message.get);
1594: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1595: END IF;
1596: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1597: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1598: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1599: fnd_file.put_line(fnd_file.log, fnd_message.get);
1600: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1601: END IF;
1594: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1595: END IF;
1596: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1597: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1598: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1599: fnd_file.put_line(fnd_file.log, fnd_message.get);
1600: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1601: END IF;
1602: END IF;
1595: END IF;
1596: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1597: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1598: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1599: fnd_file.put_line(fnd_file.log, fnd_message.get);
1600: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
1601: END IF;
1602: END IF;
1603: ELSE
1601: END IF;
1602: END IF;
1603: ELSE
1604: ROLLBACK TO Create_Formula;
1605: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1606: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1607: fnd_file.put_line(fnd_file.log, fnd_message.get);
1608: END IF;
1609: ELSE
1602: END IF;
1603: ELSE
1604: ROLLBACK TO Create_Formula;
1605: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1606: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1607: fnd_file.put_line(fnd_file.log, fnd_message.get);
1608: END IF;
1609: ELSE
1610: ROLLBACK TO Create_Formula;
1603: ELSE
1604: ROLLBACK TO Create_Formula;
1605: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1606: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1607: fnd_file.put_line(fnd_file.log, fnd_message.get);
1608: END IF;
1609: ELSE
1610: ROLLBACK TO Create_Formula;
1611: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1607: fnd_file.put_line(fnd_file.log, fnd_message.get);
1608: END IF;
1609: ELSE
1610: ROLLBACK TO Create_Formula;
1611: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1612: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1613: fnd_file.put_line(fnd_file.log, fnd_message.get);
1614: END IF;
1615: ELSE
1608: END IF;
1609: ELSE
1610: ROLLBACK TO Create_Formula;
1611: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1612: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1613: fnd_file.put_line(fnd_file.log, fnd_message.get);
1614: END IF;
1615: ELSE
1616: ROLLBACK TO Create_Formula;
1609: ELSE
1610: ROLLBACK TO Create_Formula;
1611: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1612: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1613: fnd_file.put_line(fnd_file.log, fnd_message.get);
1614: END IF;
1615: ELSE
1616: ROLLBACK TO Create_Formula;
1617: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1613: fnd_file.put_line(fnd_file.log, fnd_message.get);
1614: END IF;
1615: ELSE
1616: ROLLBACK TO Create_Formula;
1617: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1618: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1619: fnd_file.put_line(fnd_file.log, fnd_message.get);
1620: END IF;
1621: ELSE
1614: END IF;
1615: ELSE
1616: ROLLBACK TO Create_Formula;
1617: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1618: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1619: fnd_file.put_line(fnd_file.log, fnd_message.get);
1620: END IF;
1621: ELSE
1622: ROLLBACK TO Create_Formula;
1615: ELSE
1616: ROLLBACK TO Create_Formula;
1617: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1618: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1619: fnd_file.put_line(fnd_file.log, fnd_message.get);
1620: END IF;
1621: ELSE
1622: ROLLBACK TO Create_Formula;
1623: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1619: fnd_file.put_line(fnd_file.log, fnd_message.get);
1620: END IF;
1621: ELSE
1622: ROLLBACK TO Create_Formula;
1623: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1624: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1625: fnd_file.put_line(fnd_file.log, fnd_message.get);
1626: END IF;
1627: ELSE
1620: END IF;
1621: ELSE
1622: ROLLBACK TO Create_Formula;
1623: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1624: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1625: fnd_file.put_line(fnd_file.log, fnd_message.get);
1626: END IF;
1627: ELSE
1628: ROLLBACK TO Create_Formula;
1621: ELSE
1622: ROLLBACK TO Create_Formula;
1623: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1624: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1625: fnd_file.put_line(fnd_file.log, fnd_message.get);
1626: END IF;
1627: ELSE
1628: ROLLBACK TO Create_Formula;
1629: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1625: fnd_file.put_line(fnd_file.log, fnd_message.get);
1626: END IF;
1627: ELSE
1628: ROLLBACK TO Create_Formula;
1629: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1630: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1631: fnd_file.put_line(fnd_file.log, fnd_message.get);
1632: END IF;
1633: END IF;
1626: END IF;
1627: ELSE
1628: ROLLBACK TO Create_Formula;
1629: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1630: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1631: fnd_file.put_line(fnd_file.log, fnd_message.get);
1632: END IF;
1633: END IF;
1634: END IF;
1627: ELSE
1628: ROLLBACK TO Create_Formula;
1629: fnd_message.set_name ('CN' , 'CN_COPY_FM_FAIL');
1630: fnd_message.set_token('FORMULA_NAME',v_formula_rec.name);
1631: fnd_file.put_line(fnd_file.log, fnd_message.get);
1632: END IF;
1633: END IF;
1634: END IF;
1635:
1696:
1697:
1698: /*addition ends here by Naren*/
1699:
1700: fnd_message.set_name ('CN' , 'CN_COPY_PE_REUSE');
1701: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1702: fnd_file.put_line(fnd_file.log, fnd_message.get);
1703:
1704: ELSE
1697:
1698: /*addition ends here by Naren*/
1699:
1700: fnd_message.set_name ('CN' , 'CN_COPY_PE_REUSE');
1701: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1702: fnd_file.put_line(fnd_file.log, fnd_message.get);
1703:
1704: ELSE
1705:
1698: /*addition ends here by Naren*/
1699:
1700: fnd_message.set_name ('CN' , 'CN_COPY_PE_REUSE');
1701: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1702: fnd_file.put_line(fnd_file.log, fnd_message.get);
1703:
1704: ELSE
1705:
1706: fnd_message.set_name ('CN' , 'Plan element exist in the target, but in INCOMPLETE Status');
1702: fnd_file.put_line(fnd_file.log, fnd_message.get);
1703:
1704: ELSE
1705:
1706: fnd_message.set_name ('CN' , 'Plan element exist in the target, but in INCOMPLETE Status');
1707: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1708: fnd_file.put_line(fnd_file.log, fnd_message.get);
1709: ROLLBACK TO Create_PlanElement;
1710: EXIT;
1703:
1704: ELSE
1705:
1706: fnd_message.set_name ('CN' , 'Plan element exist in the target, but in INCOMPLETE Status');
1707: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1708: fnd_file.put_line(fnd_file.log, fnd_message.get);
1709: ROLLBACK TO Create_PlanElement;
1710: EXIT;
1711:
1704: ELSE
1705:
1706: fnd_message.set_name ('CN' , 'Plan element exist in the target, but in INCOMPLETE Status');
1707: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1708: fnd_file.put_line(fnd_file.log, fnd_message.get);
1709: ROLLBACK TO Create_PlanElement;
1710: EXIT;
1711:
1712: END IF; --end of v_plan_element_rec.status
1798:
1799: -- Check for External Formula
1800: IF v_plan_element_rec.element_type = 'EXTERNAL' AND
1801: v_plan_element_rec.package_name IS NULL THEN
1802: fnd_message.set_name ('CN' , 'CN_COPY_PE_EXT_FM_MISS');
1803: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1804: fnd_file.put_line(fnd_file.log, fnd_message.get);
1805: l_sql_fail_count := 1;
1806: END IF;
1799: -- Check for External Formula
1800: IF v_plan_element_rec.element_type = 'EXTERNAL' AND
1801: v_plan_element_rec.package_name IS NULL THEN
1802: fnd_message.set_name ('CN' , 'CN_COPY_PE_EXT_FM_MISS');
1803: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1804: fnd_file.put_line(fnd_file.log, fnd_message.get);
1805: l_sql_fail_count := 1;
1806: END IF;
1807:
1800: IF v_plan_element_rec.element_type = 'EXTERNAL' AND
1801: v_plan_element_rec.package_name IS NULL THEN
1802: fnd_message.set_name ('CN' , 'CN_COPY_PE_EXT_FM_MISS');
1803: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1804: fnd_file.put_line(fnd_file.log, fnd_message.get);
1805: l_sql_fail_count := 1;
1806: END IF;
1807:
1808: -- Check for Formula Name in Target System.
1827: FROM cn_interval_types
1828: WHERE name = v_plan_element_rec.interval_name
1829: AND org_id = p_org_id;
1830: IF l_int_type_count = 0 THEN
1831: fnd_message.set_name ('CN' , 'CN_COPY_PE_INT_TYPE_MISS');
1832: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1833: fnd_message.set_token('INTERVAL_TYPE_NAME',v_plan_element_rec.interval_name);
1834: fnd_file.put_line(fnd_file.log, fnd_message.get);
1835: l_sql_fail_count := 1;
1828: WHERE name = v_plan_element_rec.interval_name
1829: AND org_id = p_org_id;
1830: IF l_int_type_count = 0 THEN
1831: fnd_message.set_name ('CN' , 'CN_COPY_PE_INT_TYPE_MISS');
1832: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1833: fnd_message.set_token('INTERVAL_TYPE_NAME',v_plan_element_rec.interval_name);
1834: fnd_file.put_line(fnd_file.log, fnd_message.get);
1835: l_sql_fail_count := 1;
1836: END IF;
1829: AND org_id = p_org_id;
1830: IF l_int_type_count = 0 THEN
1831: fnd_message.set_name ('CN' , 'CN_COPY_PE_INT_TYPE_MISS');
1832: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1833: fnd_message.set_token('INTERVAL_TYPE_NAME',v_plan_element_rec.interval_name);
1834: fnd_file.put_line(fnd_file.log, fnd_message.get);
1835: l_sql_fail_count := 1;
1836: END IF;
1837:
1830: IF l_int_type_count = 0 THEN
1831: fnd_message.set_name ('CN' , 'CN_COPY_PE_INT_TYPE_MISS');
1832: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1833: fnd_message.set_token('INTERVAL_TYPE_NAME',v_plan_element_rec.interval_name);
1834: fnd_file.put_line(fnd_file.log, fnd_message.get);
1835: l_sql_fail_count := 1;
1836: END IF;
1837:
1838: -- Check Credit Type Name in Target System
1840: FROM cn_credit_types
1841: WHERE name = v_plan_element_rec.credit_type
1842: AND org_id = p_org_id;
1843: IF l_crd_type_count = 0 THEN
1844: fnd_message.set_name ('CN' , 'CN_COPY_PE_CRD_TYPE_MISS');
1845: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1846: fnd_message.set_token('CREDIT_TYPE_NAME',v_plan_element_rec.credit_type);
1847: fnd_file.put_line(fnd_file.log, fnd_message.get);
1848: l_sql_fail_count := 1;
1841: WHERE name = v_plan_element_rec.credit_type
1842: AND org_id = p_org_id;
1843: IF l_crd_type_count = 0 THEN
1844: fnd_message.set_name ('CN' , 'CN_COPY_PE_CRD_TYPE_MISS');
1845: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1846: fnd_message.set_token('CREDIT_TYPE_NAME',v_plan_element_rec.credit_type);
1847: fnd_file.put_line(fnd_file.log, fnd_message.get);
1848: l_sql_fail_count := 1;
1849: END IF;
1842: AND org_id = p_org_id;
1843: IF l_crd_type_count = 0 THEN
1844: fnd_message.set_name ('CN' , 'CN_COPY_PE_CRD_TYPE_MISS');
1845: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1846: fnd_message.set_token('CREDIT_TYPE_NAME',v_plan_element_rec.credit_type);
1847: fnd_file.put_line(fnd_file.log, fnd_message.get);
1848: l_sql_fail_count := 1;
1849: END IF;
1850:
1843: IF l_crd_type_count = 0 THEN
1844: fnd_message.set_name ('CN' , 'CN_COPY_PE_CRD_TYPE_MISS');
1845: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1846: fnd_message.set_token('CREDIT_TYPE_NAME',v_plan_element_rec.credit_type);
1847: fnd_file.put_line(fnd_file.log, fnd_message.get);
1848: l_sql_fail_count := 1;
1849: END IF;
1850:
1851: -- If all of the above are NOT NULL then proceed further
1857: AND lookup_code = v_plan_element_rec.payment_group_code;
1858:
1859: -- If Payment Group does not exists, Set it to 'STANDARD'
1860: IF l_pmt_group_code = 0 THEN
1861: fnd_message.set_name ('CN' , 'CN_COPY_PE_PMT_GRP_DFLT');
1862: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1863: fnd_message.set_token('PAYMENT_GROUP_CODE_NAME',v_plan_element_rec.payment_group_code);
1864: fnd_file.put_line(fnd_file.log, fnd_message.get);
1865: v_plan_element_rec.payment_group_code := 'STANDARD';
1858:
1859: -- If Payment Group does not exists, Set it to 'STANDARD'
1860: IF l_pmt_group_code = 0 THEN
1861: fnd_message.set_name ('CN' , 'CN_COPY_PE_PMT_GRP_DFLT');
1862: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1863: fnd_message.set_token('PAYMENT_GROUP_CODE_NAME',v_plan_element_rec.payment_group_code);
1864: fnd_file.put_line(fnd_file.log, fnd_message.get);
1865: v_plan_element_rec.payment_group_code := 'STANDARD';
1866: END IF;
1859: -- If Payment Group does not exists, Set it to 'STANDARD'
1860: IF l_pmt_group_code = 0 THEN
1861: fnd_message.set_name ('CN' , 'CN_COPY_PE_PMT_GRP_DFLT');
1862: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1863: fnd_message.set_token('PAYMENT_GROUP_CODE_NAME',v_plan_element_rec.payment_group_code);
1864: fnd_file.put_line(fnd_file.log, fnd_message.get);
1865: v_plan_element_rec.payment_group_code := 'STANDARD';
1866: END IF;
1867:
1860: IF l_pmt_group_code = 0 THEN
1861: fnd_message.set_name ('CN' , 'CN_COPY_PE_PMT_GRP_DFLT');
1862: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1863: fnd_message.set_token('PAYMENT_GROUP_CODE_NAME',v_plan_element_rec.payment_group_code);
1864: fnd_file.put_line(fnd_file.log, fnd_message.get);
1865: v_plan_element_rec.payment_group_code := 'STANDARD';
1866: END IF;
1867:
1868: -- Check if Start Date and End Date values are passed for change.
1961:
1962: --Check for atleast one revenue class assign to Plan Element
1963: l_rev_class_least_count := 1;
1964: ELSE
1965: fnd_message.set_name ('CN' , 'CN_COPY_PE_REV_CLS_MISS');
1966: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1967: fnd_message.set_token('PRODUCT_NAME',l_rev_class_name);
1968: fnd_file.put_line(fnd_file.log, fnd_message.get);
1969: END IF;
1962: --Check for atleast one revenue class assign to Plan Element
1963: l_rev_class_least_count := 1;
1964: ELSE
1965: fnd_message.set_name ('CN' , 'CN_COPY_PE_REV_CLS_MISS');
1966: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1967: fnd_message.set_token('PRODUCT_NAME',l_rev_class_name);
1968: fnd_file.put_line(fnd_file.log, fnd_message.get);
1969: END IF;
1970: END LOOP;
1963: l_rev_class_least_count := 1;
1964: ELSE
1965: fnd_message.set_name ('CN' , 'CN_COPY_PE_REV_CLS_MISS');
1966: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1967: fnd_message.set_token('PRODUCT_NAME',l_rev_class_name);
1968: fnd_file.put_line(fnd_file.log, fnd_message.get);
1969: END IF;
1970: END LOOP;
1971:
1964: ELSE
1965: fnd_message.set_name ('CN' , 'CN_COPY_PE_REV_CLS_MISS');
1966: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
1967: fnd_message.set_token('PRODUCT_NAME',l_rev_class_name);
1968: fnd_file.put_line(fnd_file.log, fnd_message.get);
1969: END IF;
1970: END LOOP;
1971:
1972: -- If atleast one revenue class exists then proceed further
2120:
2121: -- Other Attributes End
2122: END IF;
2123: ELSE
2124: fnd_message.set_name ('CN' , 'CN_COPY_PE_FCTRS_OUT_RANGE');
2125: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
2126: fnd_file.put_line(fnd_file.log, fnd_message.get);
2127: fnd_file.put_line(fnd_file.Log, 'Plan element and Multipliers dates are miss matching');
2128: END IF;
2121: -- Other Attributes End
2122: END IF;
2123: ELSE
2124: fnd_message.set_name ('CN' , 'CN_COPY_PE_FCTRS_OUT_RANGE');
2125: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
2126: fnd_file.put_line(fnd_file.log, fnd_message.get);
2127: fnd_file.put_line(fnd_file.Log, 'Plan element and Multipliers dates are miss matching');
2128: END IF;
2129: END LOOP;
2122: END IF;
2123: ELSE
2124: fnd_message.set_name ('CN' , 'CN_COPY_PE_FCTRS_OUT_RANGE');
2125: fnd_message.set_token('PLAN_ELEMENT_NAME',v_name_node_value_new);
2126: fnd_file.put_line(fnd_file.log, fnd_message.get);
2127: fnd_file.put_line(fnd_file.Log, 'Plan element and Multipliers dates are miss matching');
2128: END IF;
2129: END LOOP;
2130: END IF;
2177: v_node_sibling_Next := dbms_xmldom.getNextSibling(v_node_sibling_Previous);
2178: v_node_sibling_name_Next := dbms_xmldom.getNodeNAME(v_node_sibling_Next);
2179: ELSE
2180: ROLLBACK TO Create_PlanElement;
2181: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2182: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2183: fnd_file.put_line(fnd_file.log, fnd_message.get);
2184: fnd_file.put_line(fnd_file.Log,'2$$$$$');
2185: END IF;
2178: v_node_sibling_name_Next := dbms_xmldom.getNodeNAME(v_node_sibling_Next);
2179: ELSE
2180: ROLLBACK TO Create_PlanElement;
2181: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2182: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2183: fnd_file.put_line(fnd_file.log, fnd_message.get);
2184: fnd_file.put_line(fnd_file.Log,'2$$$$$');
2185: END IF;
2186: ELSE
2179: ELSE
2180: ROLLBACK TO Create_PlanElement;
2181: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2182: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2183: fnd_file.put_line(fnd_file.log, fnd_message.get);
2184: fnd_file.put_line(fnd_file.Log,'2$$$$$');
2185: END IF;
2186: ELSE
2187: ROLLBACK TO Create_PlanElement;
2184: fnd_file.put_line(fnd_file.Log,'2$$$$$');
2185: END IF;
2186: ELSE
2187: ROLLBACK TO Create_PlanElement;
2188: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2189: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2190: fnd_file.put_line(fnd_file.log, fnd_message.get);
2191: fnd_file.put_line(fnd_file.Log,'3$$$$$');
2192: END IF;
2185: END IF;
2186: ELSE
2187: ROLLBACK TO Create_PlanElement;
2188: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2189: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2190: fnd_file.put_line(fnd_file.log, fnd_message.get);
2191: fnd_file.put_line(fnd_file.Log,'3$$$$$');
2192: END IF;
2193: ELSE
2186: ELSE
2187: ROLLBACK TO Create_PlanElement;
2188: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2189: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2190: fnd_file.put_line(fnd_file.log, fnd_message.get);
2191: fnd_file.put_line(fnd_file.Log,'3$$$$$');
2192: END IF;
2193: ELSE
2194: --Bug 8558744: The Product is not Mandatory in Plan Element.
2350: IF l_period_exist_count=0 THEN
2351:
2352: ROLLBACK TO Create_PlanElement;
2353: fnd_file.put_line(fnd_file.log, 'Period Does not exist or a closed period. Check for the date: ' || p_start_date);
2354: fnd_message.set_name ('CN', 'CN_PERIOD_NOT_EXIST');
2355: fnd_message.set_token ('PERIOD_NAME', p_start_date);
2356: fnd_file.put_line(fnd_file.log, fnd_message.get);
2357: RAISE FND_API.G_EXC_ERROR;
2358:
2351:
2352: ROLLBACK TO Create_PlanElement;
2353: fnd_file.put_line(fnd_file.log, 'Period Does not exist or a closed period. Check for the date: ' || p_start_date);
2354: fnd_message.set_name ('CN', 'CN_PERIOD_NOT_EXIST');
2355: fnd_message.set_token ('PERIOD_NAME', p_start_date);
2356: fnd_file.put_line(fnd_file.log, fnd_message.get);
2357: RAISE FND_API.G_EXC_ERROR;
2358:
2359: END IF; --end of l_period_exist_count
2352: ROLLBACK TO Create_PlanElement;
2353: fnd_file.put_line(fnd_file.log, 'Period Does not exist or a closed period. Check for the date: ' || p_start_date);
2354: fnd_message.set_name ('CN', 'CN_PERIOD_NOT_EXIST');
2355: fnd_message.set_token ('PERIOD_NAME', p_start_date);
2356: fnd_file.put_line(fnd_file.log, fnd_message.get);
2357: RAISE FND_API.G_EXC_ERROR;
2358:
2359: END IF; --end of l_period_exist_count
2360:
2496:
2497:
2498: IF x_return_status = fnd_api.g_ret_sts_success THEN
2499: -- Log Message for Plan Element creation.
2500: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2501: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2502: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2503: IF v_plan_element_rec.end_date IS NOT NULL THEN
2504: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);
2497:
2498: IF x_return_status = fnd_api.g_ret_sts_success THEN
2499: -- Log Message for Plan Element creation.
2500: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2501: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2502: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2503: IF v_plan_element_rec.end_date IS NOT NULL THEN
2504: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);
2505: ELSE
2498: IF x_return_status = fnd_api.g_ret_sts_success THEN
2499: -- Log Message for Plan Element creation.
2500: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2501: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2502: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2503: IF v_plan_element_rec.end_date IS NOT NULL THEN
2504: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);
2505: ELSE
2506: fnd_message.set_token('PLAN_ELEMENT_END_DATE', 'NULL');
2500: fnd_message.set_name ('CN' , 'CN_COPY_PE_CREATE');
2501: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2502: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2503: IF v_plan_element_rec.end_date IS NOT NULL THEN
2504: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);
2505: ELSE
2506: fnd_message.set_token('PLAN_ELEMENT_END_DATE', 'NULL');
2507: END IF;
2508: fnd_file.put_line(fnd_file.log, fnd_message.get);
2502: fnd_message.set_token('PLAN_ELEMENT_START_DATE',v_plan_element_rec.start_date);
2503: IF v_plan_element_rec.end_date IS NOT NULL THEN
2504: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);
2505: ELSE
2506: fnd_message.set_token('PLAN_ELEMENT_END_DATE', 'NULL');
2507: END IF;
2508: fnd_file.put_line(fnd_file.log, fnd_message.get);
2509: -- Log Message for Formula to Quota Assignment
2510: fnd_message.set_name ('CN' , 'CN_COPY_FM_PE_ASSIGN');
2504: fnd_message.set_token('PLAN_ELEMENT_END_DATE', v_plan_element_rec.end_date);
2505: ELSE
2506: fnd_message.set_token('PLAN_ELEMENT_END_DATE', 'NULL');
2507: END IF;
2508: fnd_file.put_line(fnd_file.log, fnd_message.get);
2509: -- Log Message for Formula to Quota Assignment
2510: fnd_message.set_name ('CN' , 'CN_COPY_FM_PE_ASSIGN');
2511: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2512: fnd_message.set_token('FORMULA_NAME',v_plan_element_rec.calc_formula_name);
2506: fnd_message.set_token('PLAN_ELEMENT_END_DATE', 'NULL');
2507: END IF;
2508: fnd_file.put_line(fnd_file.log, fnd_message.get);
2509: -- Log Message for Formula to Quota Assignment
2510: fnd_message.set_name ('CN' , 'CN_COPY_FM_PE_ASSIGN');
2511: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2512: fnd_message.set_token('FORMULA_NAME',v_plan_element_rec.calc_formula_name);
2513: fnd_file.put_line(fnd_file.log, fnd_message.get);
2514: -- Log Message for Rate Table to Quota Assignment
2507: END IF;
2508: fnd_file.put_line(fnd_file.log, fnd_message.get);
2509: -- Log Message for Formula to Quota Assignment
2510: fnd_message.set_name ('CN' , 'CN_COPY_FM_PE_ASSIGN');
2511: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2512: fnd_message.set_token('FORMULA_NAME',v_plan_element_rec.calc_formula_name);
2513: fnd_file.put_line(fnd_file.log, fnd_message.get);
2514: -- Log Message for Rate Table to Quota Assignment
2515: IF (v_rt_quota_asgns_tbl.COUNT > 0) THEN
2508: fnd_file.put_line(fnd_file.log, fnd_message.get);
2509: -- Log Message for Formula to Quota Assignment
2510: fnd_message.set_name ('CN' , 'CN_COPY_FM_PE_ASSIGN');
2511: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2512: fnd_message.set_token('FORMULA_NAME',v_plan_element_rec.calc_formula_name);
2513: fnd_file.put_line(fnd_file.log, fnd_message.get);
2514: -- Log Message for Rate Table to Quota Assignment
2515: IF (v_rt_quota_asgns_tbl.COUNT > 0) THEN
2516: FOR i IN v_rt_quota_asgns_tbl.FIRST..v_rt_quota_asgns_tbl.LAST LOOP
2509: -- Log Message for Formula to Quota Assignment
2510: fnd_message.set_name ('CN' , 'CN_COPY_FM_PE_ASSIGN');
2511: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2512: fnd_message.set_token('FORMULA_NAME',v_plan_element_rec.calc_formula_name);
2513: fnd_file.put_line(fnd_file.log, fnd_message.get);
2514: -- Log Message for Rate Table to Quota Assignment
2515: IF (v_rt_quota_asgns_tbl.COUNT > 0) THEN
2516: FOR i IN v_rt_quota_asgns_tbl.FIRST..v_rt_quota_asgns_tbl.LAST LOOP
2517: fnd_message.set_name ('CN' , 'CN_COPY_RT_PE_ASSIGN');
2513: fnd_file.put_line(fnd_file.log, fnd_message.get);
2514: -- Log Message for Rate Table to Quota Assignment
2515: IF (v_rt_quota_asgns_tbl.COUNT > 0) THEN
2516: FOR i IN v_rt_quota_asgns_tbl.FIRST..v_rt_quota_asgns_tbl.LAST LOOP
2517: fnd_message.set_name ('CN' , 'CN_COPY_RT_PE_ASSIGN');
2518: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2519: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2520: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2521: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
2514: -- Log Message for Rate Table to Quota Assignment
2515: IF (v_rt_quota_asgns_tbl.COUNT > 0) THEN
2516: FOR i IN v_rt_quota_asgns_tbl.FIRST..v_rt_quota_asgns_tbl.LAST LOOP
2517: fnd_message.set_name ('CN' , 'CN_COPY_RT_PE_ASSIGN');
2518: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2519: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2520: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2521: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
2522: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);
2515: IF (v_rt_quota_asgns_tbl.COUNT > 0) THEN
2516: FOR i IN v_rt_quota_asgns_tbl.FIRST..v_rt_quota_asgns_tbl.LAST LOOP
2517: fnd_message.set_name ('CN' , 'CN_COPY_RT_PE_ASSIGN');
2518: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2519: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2520: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2521: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
2522: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);
2523: ELSE
2516: FOR i IN v_rt_quota_asgns_tbl.FIRST..v_rt_quota_asgns_tbl.LAST LOOP
2517: fnd_message.set_name ('CN' , 'CN_COPY_RT_PE_ASSIGN');
2518: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2519: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2520: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2521: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
2522: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);
2523: ELSE
2524: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
2518: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2519: fnd_message.set_token('RATE_TABLE_NAME',v_rt_quota_asgns_tbl(i).rate_schedule_name);
2520: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2521: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
2522: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);
2523: ELSE
2524: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
2525: END IF;
2526: fnd_file.put_line(fnd_file.log, fnd_message.get);
2520: fnd_message.set_token('ASSIGNMENT_START_DATE',v_rt_quota_asgns_tbl(i).start_date);
2521: IF v_rt_quota_asgns_tbl(i).end_date IS NOT NULL THEN
2522: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);
2523: ELSE
2524: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
2525: END IF;
2526: fnd_file.put_line(fnd_file.log, fnd_message.get);
2527: END LOOP;
2528: END IF;
2522: fnd_message.set_token('ASSIGNMENT_END_DATE', v_rt_quota_asgns_tbl(i).end_date);
2523: ELSE
2524: fnd_message.set_token('ASSIGNMENT_END_DATE', 'NULL');
2525: END IF;
2526: fnd_file.put_line(fnd_file.log, fnd_message.get);
2527: END LOOP;
2528: END IF;
2529: COMMIT;
2530: -- New value of plan element for Interdependent cases
2545: END IF;
2546: ELSE
2547: ROLLBACK TO Create_PlanElement;
2548: IF x_return_status = fnd_api.g_ret_sts_error THEN
2549: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL_EXPECTED');
2550: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2551: fnd_file.put_line(fnd_file.log, fnd_message.get);
2552: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2553: fnd_file.put_line(fnd_file.Log,'4$$$$$');
2546: ELSE
2547: ROLLBACK TO Create_PlanElement;
2548: IF x_return_status = fnd_api.g_ret_sts_error THEN
2549: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL_EXPECTED');
2550: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2551: fnd_file.put_line(fnd_file.log, fnd_message.get);
2552: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2553: fnd_file.put_line(fnd_file.Log,'4$$$$$');
2554: END IF;
2547: ROLLBACK TO Create_PlanElement;
2548: IF x_return_status = fnd_api.g_ret_sts_error THEN
2549: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL_EXPECTED');
2550: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2551: fnd_file.put_line(fnd_file.log, fnd_message.get);
2552: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2553: fnd_file.put_line(fnd_file.Log,'4$$$$$');
2554: END IF;
2555: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2552: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2553: fnd_file.put_line(fnd_file.Log,'4$$$$$');
2554: END IF;
2555: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2556: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2557: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2558: fnd_file.put_line(fnd_file.log, fnd_message.get);
2559: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2560: fnd_file.put_line(fnd_file.Log,'5$$$$$');
2553: fnd_file.put_line(fnd_file.Log,'4$$$$$');
2554: END IF;
2555: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2556: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2557: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2558: fnd_file.put_line(fnd_file.log, fnd_message.get);
2559: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2560: fnd_file.put_line(fnd_file.Log,'5$$$$$');
2561: END IF;
2554: END IF;
2555: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2556: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2557: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2558: fnd_file.put_line(fnd_file.log, fnd_message.get);
2559: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2560: fnd_file.put_line(fnd_file.Log,'5$$$$$');
2561: END IF;
2562: END IF;
2561: END IF;
2562: END IF;
2563: ELSE
2564: ROLLBACK TO Create_PlanElement;
2565: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2566: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2567: fnd_file.put_line(fnd_file.log, fnd_message.get);
2568: fnd_file.put_line(fnd_file.Log,'6$$$$$');
2569: END IF;
2562: END IF;
2563: ELSE
2564: ROLLBACK TO Create_PlanElement;
2565: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2566: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2567: fnd_file.put_line(fnd_file.log, fnd_message.get);
2568: fnd_file.put_line(fnd_file.Log,'6$$$$$');
2569: END IF;
2570: ELSE
2563: ELSE
2564: ROLLBACK TO Create_PlanElement;
2565: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2566: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2567: fnd_file.put_line(fnd_file.log, fnd_message.get);
2568: fnd_file.put_line(fnd_file.Log,'6$$$$$');
2569: END IF;
2570: ELSE
2571: ROLLBACK TO Create_PlanElement;
2568: fnd_file.put_line(fnd_file.Log,'6$$$$$');
2569: END IF;
2570: ELSE
2571: ROLLBACK TO Create_PlanElement;
2572: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2573: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2574: fnd_file.put_line(fnd_file.log, fnd_message.get);
2575: fnd_file.put_line(fnd_file.Log,'7$$$$$');
2576: END IF;
2569: END IF;
2570: ELSE
2571: ROLLBACK TO Create_PlanElement;
2572: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2573: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2574: fnd_file.put_line(fnd_file.log, fnd_message.get);
2575: fnd_file.put_line(fnd_file.Log,'7$$$$$');
2576: END IF;
2577: ELSE
2570: ELSE
2571: ROLLBACK TO Create_PlanElement;
2572: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2573: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2574: fnd_file.put_line(fnd_file.log, fnd_message.get);
2575: fnd_file.put_line(fnd_file.Log,'7$$$$$');
2576: END IF;
2577: ELSE
2578: ROLLBACK TO Create_PlanElement;
2575: fnd_file.put_line(fnd_file.Log,'7$$$$$');
2576: END IF;
2577: ELSE
2578: ROLLBACK TO Create_PlanElement;
2579: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2580: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2581: fnd_file.put_line(fnd_file.log, fnd_message.get);
2582: fnd_file.put_line(fnd_file.Log,'8$$$$$');
2583: END IF;
2576: END IF;
2577: ELSE
2578: ROLLBACK TO Create_PlanElement;
2579: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2580: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2581: fnd_file.put_line(fnd_file.log, fnd_message.get);
2582: fnd_file.put_line(fnd_file.Log,'8$$$$$');
2583: END IF;
2584: END IF;
2577: ELSE
2578: ROLLBACK TO Create_PlanElement;
2579: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2580: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);
2581: fnd_file.put_line(fnd_file.log, fnd_message.get);
2582: fnd_file.put_line(fnd_file.Log,'8$$$$$');
2583: END IF;
2584: END IF;
2585: END IF;
2623: AND org_id = p_org_id;
2624:
2625: IF v_comp_plan_rec.status_code = 'COMPLETE' THEN
2626:
2627: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE');
2628: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2629: fnd_file.put_line(fnd_file.log, fnd_message.get);
2630: p_reuse_obj_count := p_reuse_obj_count + 1;
2631:
2624:
2625: IF v_comp_plan_rec.status_code = 'COMPLETE' THEN
2626:
2627: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE');
2628: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2629: fnd_file.put_line(fnd_file.log, fnd_message.get);
2630: p_reuse_obj_count := p_reuse_obj_count + 1;
2631:
2632: ELSE
2625: IF v_comp_plan_rec.status_code = 'COMPLETE' THEN
2626:
2627: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE');
2628: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2629: fnd_file.put_line(fnd_file.log, fnd_message.get);
2630: p_reuse_obj_count := p_reuse_obj_count + 1;
2631:
2632: ELSE
2633:
2630: p_reuse_obj_count := p_reuse_obj_count + 1;
2631:
2632: ELSE
2633:
2634: fnd_message.set_name ('CN' , 'Compensation Plan exist in the target, but in INCOMPLETE Status');
2635: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2636: fnd_file.put_line(fnd_file.log, fnd_message.get);
2637: ROLLBACK TO Create_CompPlan;
2638: EXIT;
2631:
2632: ELSE
2633:
2634: fnd_message.set_name ('CN' , 'Compensation Plan exist in the target, but in INCOMPLETE Status');
2635: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2636: fnd_file.put_line(fnd_file.log, fnd_message.get);
2637: ROLLBACK TO Create_CompPlan;
2638: EXIT;
2639:
2632: ELSE
2633:
2634: fnd_message.set_name ('CN' , 'Compensation Plan exist in the target, but in INCOMPLETE Status');
2635: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2636: fnd_file.put_line(fnd_file.log, fnd_message.get);
2637: ROLLBACK TO Create_CompPlan;
2638: EXIT;
2639:
2640: END IF;
2749: AND org_id = p_org_id;
2750: ELSE
2751: ROLLBACK TO Create_CompPlan;
2752: -- Comp Plan Fail Message
2753: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2754: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2755: fnd_file.put_line(fnd_file.log, fnd_message.get);
2756: -- Failed Plan Name collection for Summary Section
2757: IF l_failed_plan_name IS NULL THEN
2750: ELSE
2751: ROLLBACK TO Create_CompPlan;
2752: -- Comp Plan Fail Message
2753: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2754: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2755: fnd_file.put_line(fnd_file.log, fnd_message.get);
2756: -- Failed Plan Name collection for Summary Section
2757: IF l_failed_plan_name IS NULL THEN
2758: l_failed_plan_name := v_comp_plan_rec.name;
2751: ROLLBACK TO Create_CompPlan;
2752: -- Comp Plan Fail Message
2753: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2754: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2755: fnd_file.put_line(fnd_file.log, fnd_message.get);
2756: -- Failed Plan Name collection for Summary Section
2757: IF l_failed_plan_name IS NULL THEN
2758: l_failed_plan_name := v_comp_plan_rec.name;
2759: ELSE
2798: x_msg_data => x_msg_data);
2799:
2800:
2801: IF x_return_status = fnd_api.g_ret_sts_success THEN
2802: fnd_message.set_name ('CN' , 'CN_COPY_PE_ASSIGN');
2803: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2804: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2805: fnd_file.put_line(fnd_file.log, fnd_message.get);
2806: l_quota_asgn_count := 1;
2799:
2800:
2801: IF x_return_status = fnd_api.g_ret_sts_success THEN
2802: fnd_message.set_name ('CN' , 'CN_COPY_PE_ASSIGN');
2803: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2804: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2805: fnd_file.put_line(fnd_file.log, fnd_message.get);
2806: l_quota_asgn_count := 1;
2807: ELSE
2800:
2801: IF x_return_status = fnd_api.g_ret_sts_success THEN
2802: fnd_message.set_name ('CN' , 'CN_COPY_PE_ASSIGN');
2803: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2804: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2805: fnd_file.put_line(fnd_file.log, fnd_message.get);
2806: l_quota_asgn_count := 1;
2807: ELSE
2808: l_sql_fail_count := 1;
2801: IF x_return_status = fnd_api.g_ret_sts_success THEN
2802: fnd_message.set_name ('CN' , 'CN_COPY_PE_ASSIGN');
2803: fnd_message.set_token('PLAN_NAME',v_name_node_value_new);
2804: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2805: fnd_file.put_line(fnd_file.log, fnd_message.get);
2806: l_quota_asgn_count := 1;
2807: ELSE
2808: l_sql_fail_count := 1;
2809: EXIT;
2812: l_sql_fail_count := 1;
2813: EXIT;
2814: END IF;
2815: ELSE
2816: fnd_message.set_name ('CN' , 'CN_COPY_PE_OUT_RANGE');
2817: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2818: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2819: fnd_file.put_line(fnd_file.log, fnd_message.get);
2820: END IF;
2813: EXIT;
2814: END IF;
2815: ELSE
2816: fnd_message.set_name ('CN' , 'CN_COPY_PE_OUT_RANGE');
2817: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2818: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2819: fnd_file.put_line(fnd_file.log, fnd_message.get);
2820: END IF;
2821: END LOOP;
2814: END IF;
2815: ELSE
2816: fnd_message.set_name ('CN' , 'CN_COPY_PE_OUT_RANGE');
2817: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2818: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2819: fnd_file.put_line(fnd_file.log, fnd_message.get);
2820: END IF;
2821: END LOOP;
2822: IF l_sql_fail_count = 0 AND l_quota_asgn_count = 1 THEN
2815: ELSE
2816: fnd_message.set_name ('CN' , 'CN_COPY_PE_OUT_RANGE');
2817: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2818: fnd_message.set_token('PLAN_ELEMENT_NAME',v_quota_assign_tbl(i).name);
2819: fnd_file.put_line(fnd_file.log, fnd_message.get);
2820: END IF;
2821: END LOOP;
2822: IF l_sql_fail_count = 0 AND l_quota_asgn_count = 1 THEN
2823: fnd_message.set_name ('CN' , 'CN_COPY_CP_CREATE');
2819: fnd_file.put_line(fnd_file.log, fnd_message.get);
2820: END IF;
2821: END LOOP;
2822: IF l_sql_fail_count = 0 AND l_quota_asgn_count = 1 THEN
2823: fnd_message.set_name ('CN' , 'CN_COPY_CP_CREATE');
2824: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2825: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2826: IF v_comp_plan_rec.end_date IS NOT NULL THEN
2827: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);
2820: END IF;
2821: END LOOP;
2822: IF l_sql_fail_count = 0 AND l_quota_asgn_count = 1 THEN
2823: fnd_message.set_name ('CN' , 'CN_COPY_CP_CREATE');
2824: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2825: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2826: IF v_comp_plan_rec.end_date IS NOT NULL THEN
2827: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);
2828: ELSE
2821: END LOOP;
2822: IF l_sql_fail_count = 0 AND l_quota_asgn_count = 1 THEN
2823: fnd_message.set_name ('CN' , 'CN_COPY_CP_CREATE');
2824: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2825: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2826: IF v_comp_plan_rec.end_date IS NOT NULL THEN
2827: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);
2828: ELSE
2829: fnd_message.set_token('PLAN_END_DATE', 'NULL');
2823: fnd_message.set_name ('CN' , 'CN_COPY_CP_CREATE');
2824: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2825: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2826: IF v_comp_plan_rec.end_date IS NOT NULL THEN
2827: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);
2828: ELSE
2829: fnd_message.set_token('PLAN_END_DATE', 'NULL');
2830: END IF;
2831: fnd_file.put_line(fnd_file.log, fnd_message.get);
2825: fnd_message.set_token('PLAN_START_DATE',v_comp_plan_rec.start_date);
2826: IF v_comp_plan_rec.end_date IS NOT NULL THEN
2827: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);
2828: ELSE
2829: fnd_message.set_token('PLAN_END_DATE', 'NULL');
2830: END IF;
2831: fnd_file.put_line(fnd_file.log, fnd_message.get);
2832: p_success_obj_count := p_success_obj_count + 1;
2833: COMMIT;
2827: fnd_message.set_token('PLAN_END_DATE', v_comp_plan_rec.end_date);
2828: ELSE
2829: fnd_message.set_token('PLAN_END_DATE', 'NULL');
2830: END IF;
2831: fnd_file.put_line(fnd_file.log, fnd_message.get);
2832: p_success_obj_count := p_success_obj_count + 1;
2833: COMMIT;
2834: ELSE
2835: ROLLBACK TO Create_CompPlan;
2834: ELSE
2835: ROLLBACK TO Create_CompPlan;
2836: -- Comp Plan Fail Message
2837: IF x_return_status = fnd_api.g_ret_sts_error THEN
2838: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2839: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2840: fnd_file.put_line(fnd_file.log, fnd_message.get);
2841: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2842: END IF;
2835: ROLLBACK TO Create_CompPlan;
2836: -- Comp Plan Fail Message
2837: IF x_return_status = fnd_api.g_ret_sts_error THEN
2838: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2839: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2840: fnd_file.put_line(fnd_file.log, fnd_message.get);
2841: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2842: END IF;
2843: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2836: -- Comp Plan Fail Message
2837: IF x_return_status = fnd_api.g_ret_sts_error THEN
2838: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2839: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2840: fnd_file.put_line(fnd_file.log, fnd_message.get);
2841: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2842: END IF;
2843: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2844: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2840: fnd_file.put_line(fnd_file.log, fnd_message.get);
2841: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2842: END IF;
2843: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2844: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2845: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2846: fnd_file.put_line(fnd_file.log, fnd_message.get);
2847: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2848: END IF;
2841: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2842: END IF;
2843: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2844: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2845: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2846: fnd_file.put_line(fnd_file.log, fnd_message.get);
2847: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2848: END IF;
2849: -- Failed Plan Name collection for Summary Section
2842: END IF;
2843: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2844: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2845: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2846: fnd_file.put_line(fnd_file.log, fnd_message.get);
2847: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2848: END IF;
2849: -- Failed Plan Name collection for Summary Section
2850: IF l_failed_plan_name IS NULL THEN
2855: END IF;
2856: ELSE
2857: ROLLBACK TO Create_CompPlan;
2858: -- Comp Plan Fail Message
2859: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2860: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2861: fnd_file.put_line(fnd_file.log, fnd_message.get);
2862: -- Failed Plan Name collection for Summary Section
2863: IF l_failed_plan_name IS NULL THEN
2856: ELSE
2857: ROLLBACK TO Create_CompPlan;
2858: -- Comp Plan Fail Message
2859: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2860: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2861: fnd_file.put_line(fnd_file.log, fnd_message.get);
2862: -- Failed Plan Name collection for Summary Section
2863: IF l_failed_plan_name IS NULL THEN
2864: l_failed_plan_name := v_comp_plan_rec.name;
2857: ROLLBACK TO Create_CompPlan;
2858: -- Comp Plan Fail Message
2859: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2860: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2861: fnd_file.put_line(fnd_file.log, fnd_message.get);
2862: -- Failed Plan Name collection for Summary Section
2863: IF l_failed_plan_name IS NULL THEN
2864: l_failed_plan_name := v_comp_plan_rec.name;
2865: ELSE
2869: END IF;
2870: ELSE
2871: ROLLBACK TO Create_CompPlan;
2872: -- Comp Plan Fail Message
2873: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2874: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2875: fnd_file.put_line(fnd_file.log, fnd_message.get);
2876: -- Failed Plan Name collection for Summary Section
2877: IF l_failed_plan_name IS NULL THEN
2870: ELSE
2871: ROLLBACK TO Create_CompPlan;
2872: -- Comp Plan Fail Message
2873: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2874: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2875: fnd_file.put_line(fnd_file.log, fnd_message.get);
2876: -- Failed Plan Name collection for Summary Section
2877: IF l_failed_plan_name IS NULL THEN
2878: l_failed_plan_name := v_comp_plan_rec.name;
2871: ROLLBACK TO Create_CompPlan;
2872: -- Comp Plan Fail Message
2873: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2874: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2875: fnd_file.put_line(fnd_file.log, fnd_message.get);
2876: -- Failed Plan Name collection for Summary Section
2877: IF l_failed_plan_name IS NULL THEN
2878: l_failed_plan_name := v_comp_plan_rec.name;
2879: ELSE
2882: END IF;
2883: ELSE
2884: ROLLBACK TO Create_CompPlan;
2885: -- Comp Plan Fail Message
2886: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2887: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2888: fnd_file.put_line(fnd_file.log, fnd_message.get);
2889: -- Failed Plan Name collection for Summary Section
2890: IF l_failed_plan_name IS NULL THEN
2883: ELSE
2884: ROLLBACK TO Create_CompPlan;
2885: -- Comp Plan Fail Message
2886: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2887: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2888: fnd_file.put_line(fnd_file.log, fnd_message.get);
2889: -- Failed Plan Name collection for Summary Section
2890: IF l_failed_plan_name IS NULL THEN
2891: l_failed_plan_name := v_comp_plan_rec.name;
2884: ROLLBACK TO Create_CompPlan;
2885: -- Comp Plan Fail Message
2886: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2887: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2888: fnd_file.put_line(fnd_file.log, fnd_message.get);
2889: -- Failed Plan Name collection for Summary Section
2890: IF l_failed_plan_name IS NULL THEN
2891: l_failed_plan_name := v_comp_plan_rec.name;
2892: ELSE
2896: ELSE
2897: ROLLBACK TO Create_CompPlan;
2898: -- Comp Plan Fail Message
2899: IF x_return_status = fnd_api.g_ret_sts_error THEN
2900: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2901: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2902: fnd_file.put_line(fnd_file.log, fnd_message.get);
2903: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2904: END IF;
2897: ROLLBACK TO Create_CompPlan;
2898: -- Comp Plan Fail Message
2899: IF x_return_status = fnd_api.g_ret_sts_error THEN
2900: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2901: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2902: fnd_file.put_line(fnd_file.log, fnd_message.get);
2903: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2904: END IF;
2905: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2898: -- Comp Plan Fail Message
2899: IF x_return_status = fnd_api.g_ret_sts_error THEN
2900: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL_EXPECTED');
2901: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2902: fnd_file.put_line(fnd_file.log, fnd_message.get);
2903: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2904: END IF;
2905: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2906: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2902: fnd_file.put_line(fnd_file.log, fnd_message.get);
2903: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2904: END IF;
2905: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2906: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2907: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2908: fnd_file.put_line(fnd_file.log, fnd_message.get);
2909: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2910: END IF;
2903: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2904: END IF;
2905: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2906: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2907: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2908: fnd_file.put_line(fnd_file.log, fnd_message.get);
2909: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2910: END IF;
2911: -- Failed Plan Name collection for Summary Section
2904: END IF;
2905: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2906: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAIL');
2907: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);
2908: fnd_file.put_line(fnd_file.log, fnd_message.get);
2909: fnd_file.put_line(fnd_file.log, '***ERROR: '||x_msg_data);
2910: END IF;
2911: -- Failed Plan Name collection for Summary Section
2912: IF l_failed_plan_name IS NULL THEN
2930: fnd_file.put_line(fnd_file.log, '**************************************************************');
2931: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2932: fnd_file.put_line(fnd_file.log, '**************************************************************');
2933: -- Number of plans to Import
2934: fnd_message.set_name ('CN' , 'CN_COPY_CP_REQ_COUNT');
2935: fnd_message.set_token('COUNT',p_object_count);
2936: fnd_file.put_line(fnd_file.log, fnd_message.get);
2937: -- Number of Plans successfully created in target
2938: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
2931: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2932: fnd_file.put_line(fnd_file.log, '**************************************************************');
2933: -- Number of plans to Import
2934: fnd_message.set_name ('CN' , 'CN_COPY_CP_REQ_COUNT');
2935: fnd_message.set_token('COUNT',p_object_count);
2936: fnd_file.put_line(fnd_file.log, fnd_message.get);
2937: -- Number of Plans successfully created in target
2938: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
2939: fnd_message.set_token('COUNT',p_success_obj_count);
2932: fnd_file.put_line(fnd_file.log, '**************************************************************');
2933: -- Number of plans to Import
2934: fnd_message.set_name ('CN' , 'CN_COPY_CP_REQ_COUNT');
2935: fnd_message.set_token('COUNT',p_object_count);
2936: fnd_file.put_line(fnd_file.log, fnd_message.get);
2937: -- Number of Plans successfully created in target
2938: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
2939: fnd_message.set_token('COUNT',p_success_obj_count);
2940: fnd_file.put_line(fnd_file.log, fnd_message.get);
2934: fnd_message.set_name ('CN' , 'CN_COPY_CP_REQ_COUNT');
2935: fnd_message.set_token('COUNT',p_object_count);
2936: fnd_file.put_line(fnd_file.log, fnd_message.get);
2937: -- Number of Plans successfully created in target
2938: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
2939: fnd_message.set_token('COUNT',p_success_obj_count);
2940: fnd_file.put_line(fnd_file.log, fnd_message.get);
2941: -- Number of Plans reused in tagret
2942: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');
2935: fnd_message.set_token('COUNT',p_object_count);
2936: fnd_file.put_line(fnd_file.log, fnd_message.get);
2937: -- Number of Plans successfully created in target
2938: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
2939: fnd_message.set_token('COUNT',p_success_obj_count);
2940: fnd_file.put_line(fnd_file.log, fnd_message.get);
2941: -- Number of Plans reused in tagret
2942: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');
2943: fnd_message.set_token('COUNT',p_reuse_obj_count);
2936: fnd_file.put_line(fnd_file.log, fnd_message.get);
2937: -- Number of Plans successfully created in target
2938: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
2939: fnd_message.set_token('COUNT',p_success_obj_count);
2940: fnd_file.put_line(fnd_file.log, fnd_message.get);
2941: -- Number of Plans reused in tagret
2942: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');
2943: fnd_message.set_token('COUNT',p_reuse_obj_count);
2944: fnd_file.put_line(fnd_file.log, fnd_message.get);
2938: fnd_message.set_name ('CN' , 'CN_COPY_CP_SUCCESS_COUNT');
2939: fnd_message.set_token('COUNT',p_success_obj_count);
2940: fnd_file.put_line(fnd_file.log, fnd_message.get);
2941: -- Number of Plans reused in tagret
2942: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');
2943: fnd_message.set_token('COUNT',p_reuse_obj_count);
2944: fnd_file.put_line(fnd_file.log, fnd_message.get);
2945: -- Number of Plans which were not imported due to error
2946: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2939: fnd_message.set_token('COUNT',p_success_obj_count);
2940: fnd_file.put_line(fnd_file.log, fnd_message.get);
2941: -- Number of Plans reused in tagret
2942: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');
2943: fnd_message.set_token('COUNT',p_reuse_obj_count);
2944: fnd_file.put_line(fnd_file.log, fnd_message.get);
2945: -- Number of Plans which were not imported due to error
2946: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2947: fnd_message.set_token('LIST',l_failed_plan_name);
2940: fnd_file.put_line(fnd_file.log, fnd_message.get);
2941: -- Number of Plans reused in tagret
2942: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');
2943: fnd_message.set_token('COUNT',p_reuse_obj_count);
2944: fnd_file.put_line(fnd_file.log, fnd_message.get);
2945: -- Number of Plans which were not imported due to error
2946: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2947: fnd_message.set_token('LIST',l_failed_plan_name);
2948: fnd_file.put_line(fnd_file.log, fnd_message.get);
2942: fnd_message.set_name ('CN' , 'CN_COPY_CP_REUSE_COUNT');
2943: fnd_message.set_token('COUNT',p_reuse_obj_count);
2944: fnd_file.put_line(fnd_file.log, fnd_message.get);
2945: -- Number of Plans which were not imported due to error
2946: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2947: fnd_message.set_token('LIST',l_failed_plan_name);
2948: fnd_file.put_line(fnd_file.log, fnd_message.get);
2949: fnd_file.put_line(fnd_file.log, '**************************************************************');
2950: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2943: fnd_message.set_token('COUNT',p_reuse_obj_count);
2944: fnd_file.put_line(fnd_file.log, fnd_message.get);
2945: -- Number of Plans which were not imported due to error
2946: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2947: fnd_message.set_token('LIST',l_failed_plan_name);
2948: fnd_file.put_line(fnd_file.log, fnd_message.get);
2949: fnd_file.put_line(fnd_file.log, '**************************************************************');
2950: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2951: fnd_file.put_line(fnd_file.log, '**************************************************************');
2944: fnd_file.put_line(fnd_file.log, fnd_message.get);
2945: -- Number of Plans which were not imported due to error
2946: fnd_message.set_name ('CN' , 'CN_COPY_CP_FAILED_COUNT');
2947: fnd_message.set_token('LIST',l_failed_plan_name);
2948: fnd_file.put_line(fnd_file.log, fnd_message.get);
2949: fnd_file.put_line(fnd_file.log, '**************************************************************');
2950: fnd_file.put_line(fnd_file.log, '***************************** SUMMARY ************************');
2951: fnd_file.put_line(fnd_file.log, '**************************************************************');
2952: