eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on FND_FILE

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

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

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

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

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

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

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

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:

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

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

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

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

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

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;

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

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

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

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

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

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');
722: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

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

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:

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

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

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

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

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

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

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

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');
771: fnd_message.set_token('EXPRESSION_NAME',v_expression_rec.name);

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

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:

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

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:
777: END IF; --end of l_reuse_count

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

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

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

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
966: ROLLBACK TO Create_RateDimension;

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

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

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

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

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

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:

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

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

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

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

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

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

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

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

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

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

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

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');
1166: fnd_message.set_token('RATE_TABLE_NAME',v_rate_table_rec.name);

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

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

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

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
1172: ROLLBACK TO Create_RateSchedule;

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

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

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

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

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

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:

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

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

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

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;

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

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

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

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

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

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

Line 1551: 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');
1555: fnd_message.set_token('EXPRESSION_NAME',l_perf_measure_name);

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

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

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

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

Line 1569: 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;
1573: IF (v_rt_assign_tbl.COUNT > 0) THEN

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

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

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

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

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

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

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

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

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

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
1604: ROLLBACK TO Create_Formula;

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

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

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

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

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

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

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

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

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

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:

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

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

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

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

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

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.

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

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

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

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

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

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.

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

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

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

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;

Line 2127: fnd_file.put_line(fnd_file.Log, 'Plan element and Multipliers dates are miss matching');

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;
2131:

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

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;

Line 2184: fnd_file.put_line(fnd_file.Log,'2$$$$$');

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;
2188: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

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

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.

Line 2191: fnd_file.put_line(fnd_file.Log,'3$$$$$');

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.
2195: -- Clearing the Temporary Table

Line 2353: fnd_file.put_line(fnd_file.log, 'Period Does not exist or a closed period. Check for the date: ' || p_start_date);

2349:
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;

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

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:

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

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

Line 2513: 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
2517: fnd_message.set_name ('CN' , 'CN_COPY_RT_PE_ASSIGN');

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

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

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

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

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

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
2556: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

Line 2553: fnd_file.put_line(fnd_file.Log,'4$$$$$');

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
2556: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');
2557: fnd_message.set_token('PLAN_ELEMENT_NAME',v_plan_element_rec.name);

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

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;

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

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;
2563: ELSE

Line 2560: fnd_file.put_line(fnd_file.Log,'5$$$$$');

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;
2563: ELSE
2564: ROLLBACK TO Create_PlanElement;

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

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;

Line 2568: fnd_file.put_line(fnd_file.Log,'6$$$$$');

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;
2572: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

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

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;

Line 2575: fnd_file.put_line(fnd_file.Log,'7$$$$$');

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;
2579: fnd_message.set_name ('CN' , 'CN_COPY_PE_FAIL');

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

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;

Line 2582: fnd_file.put_line(fnd_file.Log,'8$$$$$');

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;
2586:

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

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:

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

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;

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

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

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

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;

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

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

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

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;

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

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

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

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');
2845: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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

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

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

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
2851: l_failed_plan_name := v_comp_plan_rec.name;

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

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

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

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

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

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

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

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

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

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');
2907: fnd_message.set_token('PLAN_NAME',v_comp_plan_rec.name);

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

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

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

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
2913: l_failed_plan_name := v_comp_plan_rec.name;

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

2919: END IF;
2920:
2921: /* ****************************** Main Loop End ************************** */
2922: END LOOP;
2923: fnd_file.put_line(fnd_file.log, '**************************************************************');
2924: fnd_file.put_line(fnd_file.log, '******************** END - PLAN COPY IMPORT ******************');
2925: fnd_file.put_line(fnd_file.log, '**************************************************************');
2926:
2927: -- ****************************************************************

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

2920:
2921: /* ****************************** Main Loop End ************************** */
2922: END LOOP;
2923: fnd_file.put_line(fnd_file.log, '**************************************************************');
2924: fnd_file.put_line(fnd_file.log, '******************** END - PLAN COPY IMPORT ******************');
2925: fnd_file.put_line(fnd_file.log, '**************************************************************');
2926:
2927: -- ****************************************************************
2928: -- *********** Summary of Import Process Log Messages ***********

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

2921: /* ****************************** Main Loop End ************************** */
2922: END LOOP;
2923: fnd_file.put_line(fnd_file.log, '**************************************************************');
2924: fnd_file.put_line(fnd_file.log, '******************** END - PLAN COPY IMPORT ******************');
2925: fnd_file.put_line(fnd_file.log, '**************************************************************');
2926:
2927: -- ****************************************************************
2928: -- *********** Summary of Import Process Log Messages ***********
2929: -- ****************************************************************

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

2926:
2927: -- ****************************************************************
2928: -- *********** Summary of Import Process Log Messages ***********
2929: -- ****************************************************************
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');

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

2927: -- ****************************************************************
2928: -- *********** Summary of Import Process Log Messages ***********
2929: -- ****************************************************************
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);

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

2928: -- *********** Summary of Import Process Log Messages ***********
2929: -- ****************************************************************
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);

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

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

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

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

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

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

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

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:

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

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:
2953: -- Set the Import Status to 'COMPLETE' OR 'FAILED'

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

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:
2953: -- Set the Import Status to 'COMPLETE' OR 'FAILED'
2954: IF p_object_count = p_success_obj_count + p_reuse_obj_count THEN

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

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:
2953: -- Set the Import Status to 'COMPLETE' OR 'FAILED'
2954: IF p_object_count = p_success_obj_count + p_reuse_obj_count THEN
2955: x_import_status := 'COMPLETED';