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.CSTPUMEC dependencies on FND_FILE

Line 814: fnd_file.put_line(fnd_file.log,'Request ID: '||to_char(l_request_id));

810: l_pgm_app_id := FND_GLOBAL.PROG_APPL_ID;
811: l_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
812:
813: -- Write descriptive info to log file
814: fnd_file.put_line(fnd_file.log,'Request ID: '||to_char(l_request_id));
815: fnd_file.put_line(fnd_file.log,'PARAMETERS');
816: fnd_file.put_line(fnd_file.log,'Organization ID: '||to_char(i_org_id));
817: fnd_file.put_line(fnd_file.log,'Cost Type: '||to_char(i_cost_type));
818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));

Line 815: fnd_file.put_line(fnd_file.log,'PARAMETERS');

811: l_pgm_id := FND_GLOBAL.CONC_PROGRAM_ID;
812:
813: -- Write descriptive info to log file
814: fnd_file.put_line(fnd_file.log,'Request ID: '||to_char(l_request_id));
815: fnd_file.put_line(fnd_file.log,'PARAMETERS');
816: fnd_file.put_line(fnd_file.log,'Organization ID: '||to_char(i_org_id));
817: fnd_file.put_line(fnd_file.log,'Cost Type: '||to_char(i_cost_type));
818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));
819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));

Line 816: fnd_file.put_line(fnd_file.log,'Organization ID: '||to_char(i_org_id));

812:
813: -- Write descriptive info to log file
814: fnd_file.put_line(fnd_file.log,'Request ID: '||to_char(l_request_id));
815: fnd_file.put_line(fnd_file.log,'PARAMETERS');
816: fnd_file.put_line(fnd_file.log,'Organization ID: '||to_char(i_org_id));
817: fnd_file.put_line(fnd_file.log,'Cost Type: '||to_char(i_cost_type));
818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));
819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));
820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);

Line 817: fnd_file.put_line(fnd_file.log,'Cost Type: '||to_char(i_cost_type));

813: -- Write descriptive info to log file
814: fnd_file.put_line(fnd_file.log,'Request ID: '||to_char(l_request_id));
815: fnd_file.put_line(fnd_file.log,'PARAMETERS');
816: fnd_file.put_line(fnd_file.log,'Organization ID: '||to_char(i_org_id));
817: fnd_file.put_line(fnd_file.log,'Cost Type: '||to_char(i_cost_type));
818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));
819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));
820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);
821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);

Line 818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));

814: fnd_file.put_line(fnd_file.log,'Request ID: '||to_char(l_request_id));
815: fnd_file.put_line(fnd_file.log,'PARAMETERS');
816: fnd_file.put_line(fnd_file.log,'Organization ID: '||to_char(i_org_id));
817: fnd_file.put_line(fnd_file.log,'Cost Type: '||to_char(i_cost_type));
818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));
819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));
820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);
821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);
822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));

Line 819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));

815: fnd_file.put_line(fnd_file.log,'PARAMETERS');
816: fnd_file.put_line(fnd_file.log,'Organization ID: '||to_char(i_org_id));
817: fnd_file.put_line(fnd_file.log,'Cost Type: '||to_char(i_cost_type));
818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));
819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));
820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);
821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);
822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));
823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));

Line 820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);

816: fnd_file.put_line(fnd_file.log,'Organization ID: '||to_char(i_org_id));
817: fnd_file.put_line(fnd_file.log,'Cost Type: '||to_char(i_cost_type));
818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));
819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));
820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);
821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);
822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));
823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));
824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);

Line 821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);

817: fnd_file.put_line(fnd_file.log,'Cost Type: '||to_char(i_cost_type));
818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));
819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));
820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);
821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);
822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));
823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));
824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);
825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);

Line 822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));

818: fnd_file.put_line(fnd_file.log,'Range: '||to_char(i_range));
819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));
820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);
821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);
822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));
823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));
824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);
825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);
826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));

Line 823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));

819: fnd_file.put_line(fnd_file.log,'Specific item: '||to_char(i_specific_item));
820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);
821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);
822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));
823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));
824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);
825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);
826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));
827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));

Line 824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);

820: fnd_file.put_line(fnd_file.log,'Item From: '||i_item_from);
821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);
822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));
823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));
824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);
825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);
826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));
827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));
828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));

Line 825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);

821: fnd_file.put_line(fnd_file.log,'Item To: '||i_item_to);
822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));
823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));
824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);
825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);
826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));
827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));
828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));
829: fnd_file.put_line(fnd_file.log,'Based On Rollup: '||to_char(i_bor_flag));

Line 826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));

822: fnd_file.put_line(fnd_file.log,'Category Set: '||to_char(i_category_set));
823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));
824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);
825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);
826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));
827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));
828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));
829: fnd_file.put_line(fnd_file.log,'Based On Rollup: '||to_char(i_bor_flag));
830: fnd_file.put_line(fnd_file.log,'Defaulted Flag: '||to_char(i_def_flag));

Line 827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));

823: fnd_file.put_line(fnd_file.log,'Category struct: '||to_char(i_cat_strct));
824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);
825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);
826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));
827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));
828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));
829: fnd_file.put_line(fnd_file.log,'Based On Rollup: '||to_char(i_bor_flag));
830: fnd_file.put_line(fnd_file.log,'Defaulted Flag: '||to_char(i_def_flag));
831: fnd_file.put_line(fnd_file.log,'Lot Size Selection: '||to_char(i_lotsz_lov));

Line 828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));

824: fnd_file.put_line(fnd_file.log,'Category From: '||i_category_from);
825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);
826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));
827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));
828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));
829: fnd_file.put_line(fnd_file.log,'Based On Rollup: '||to_char(i_bor_flag));
830: fnd_file.put_line(fnd_file.log,'Defaulted Flag: '||to_char(i_def_flag));
831: fnd_file.put_line(fnd_file.log,'Lot Size Selection: '||to_char(i_lotsz_lov));
832: fnd_file.put_line(fnd_file.log,'Lot Size: '||to_char(i_lot_size));

Line 829: fnd_file.put_line(fnd_file.log,'Based On Rollup: '||to_char(i_bor_flag));

825: fnd_file.put_line(fnd_file.log,'Category To: '||i_category_to);
826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));
827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));
828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));
829: fnd_file.put_line(fnd_file.log,'Based On Rollup: '||to_char(i_bor_flag));
830: fnd_file.put_line(fnd_file.log,'Defaulted Flag: '||to_char(i_def_flag));
831: fnd_file.put_line(fnd_file.log,'Lot Size Selection: '||to_char(i_lotsz_lov));
832: fnd_file.put_line(fnd_file.log,'Lot Size: '||to_char(i_lot_size));
833:

Line 830: fnd_file.put_line(fnd_file.log,'Defaulted Flag: '||to_char(i_def_flag));

826: fnd_file.put_line(fnd_file.log,'Copy Option: '||to_char(i_copy_option));
827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));
828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));
829: fnd_file.put_line(fnd_file.log,'Based On Rollup: '||to_char(i_bor_flag));
830: fnd_file.put_line(fnd_file.log,'Defaulted Flag: '||to_char(i_def_flag));
831: fnd_file.put_line(fnd_file.log,'Lot Size Selection: '||to_char(i_lotsz_lov));
832: fnd_file.put_line(fnd_file.log,'Lot Size: '||to_char(i_lot_size));
833:
834:

Line 831: fnd_file.put_line(fnd_file.log,'Lot Size Selection: '||to_char(i_lotsz_lov));

827: fnd_file.put_line(fnd_file.log,'CO Dummy: '||to_char(i_co_dummy));
828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));
829: fnd_file.put_line(fnd_file.log,'Based On Rollup: '||to_char(i_bor_flag));
830: fnd_file.put_line(fnd_file.log,'Defaulted Flag: '||to_char(i_def_flag));
831: fnd_file.put_line(fnd_file.log,'Lot Size Selection: '||to_char(i_lotsz_lov));
832: fnd_file.put_line(fnd_file.log,'Lot Size: '||to_char(i_lot_size));
833:
834:
835: if (i_bor_flag <> 3 AND i_def_flag <> 3 AND i_lotsz_lov <> 2) then

Line 832: fnd_file.put_line(fnd_file.log,'Lot Size: '||to_char(i_lot_size));

828: fnd_file.put_line(fnd_file.log,'Src Cost Type: '||to_char(i_src_cost_type));
829: fnd_file.put_line(fnd_file.log,'Based On Rollup: '||to_char(i_bor_flag));
830: fnd_file.put_line(fnd_file.log,'Defaulted Flag: '||to_char(i_def_flag));
831: fnd_file.put_line(fnd_file.log,'Lot Size Selection: '||to_char(i_lotsz_lov));
832: fnd_file.put_line(fnd_file.log,'Lot Size: '||to_char(i_lot_size));
833:
834:
835: if (i_bor_flag <> 3 AND i_def_flag <> 3 AND i_lotsz_lov <> 2) then
836: -- Update CIC in the case where none of the fields are copied - avoids superfluous subquery in SET stmt

Line 981: fnd_file.put_line(fnd_file.log,'');

977:
978: end if;
979:
980: l_num_CIC_rows := SQL%ROWCOUNT;
981: fnd_file.put_line(fnd_file.log,'');
982: fnd_file.put_line(fnd_file.log,'Updated '||to_char(l_num_CIC_rows)||' rows in cst_item_costs.');
983:
984: if (i_bor_flag = 1 OR i_bor_flag = 3) then
985: -- Based On Rollup may have been updated to YES, print a NOTE message

Line 982: fnd_file.put_line(fnd_file.log,'Updated '||to_char(l_num_CIC_rows)||' rows in cst_item_costs.');

978: end if;
979:
980: l_num_CIC_rows := SQL%ROWCOUNT;
981: fnd_file.put_line(fnd_file.log,'');
982: fnd_file.put_line(fnd_file.log,'Updated '||to_char(l_num_CIC_rows)||' rows in cst_item_costs.');
983:
984: if (i_bor_flag = 1 OR i_bor_flag = 3) then
985: -- Based On Rollup may have been updated to YES, print a NOTE message
986: fnd_file.put_line(fnd_file.log,'');

Line 986: fnd_file.put_line(fnd_file.log,'');

982: fnd_file.put_line(fnd_file.log,'Updated '||to_char(l_num_CIC_rows)||' rows in cst_item_costs.');
983:
984: if (i_bor_flag = 1 OR i_bor_flag = 3) then
985: -- Based On Rollup may have been updated to YES, print a NOTE message
986: fnd_file.put_line(fnd_file.log,'');
987: fnd_message.set_name('BOM', 'CST_SCC_SHRINKAGE_NOTE');
988: fnd_file.put_line(fnd_file.log, fnd_message.get);
989: end if;
990:

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

984: if (i_bor_flag = 1 OR i_bor_flag = 3) then
985: -- Based On Rollup may have been updated to YES, print a NOTE message
986: fnd_file.put_line(fnd_file.log,'');
987: fnd_message.set_name('BOM', 'CST_SCC_SHRINKAGE_NOTE');
988: fnd_file.put_line(fnd_file.log, fnd_message.get);
989: end if;
990:
991: if (i_lotsz_lov = 2 OR (i_lotsz_lov = 1 AND i_lot_size IS NOT NULL)) then
992: -- Update CICD usage rate and basis factor with new lot size information

Line 1044: fnd_file.put_line(fnd_file.log,'Updated '||to_char(l_num_CICD_rows)||' rows in cst_item_cost_details for lotsize.');

1040: AND cicd.basis_type = 2
1041: AND cicd.level_type = 1;
1042:
1043: l_num_CICD_rows := SQL%ROWCOUNT;
1044: fnd_file.put_line(fnd_file.log,'Updated '||to_char(l_num_CICD_rows)||' rows in cst_item_cost_details for lotsize.');
1045:
1046: end if; -- end of lot size change affecting CICD
1047:
1048: if (i_bor_flag = 2 OR i_bor_flag = 3) then

Line 1087: fnd_file.put_line(fnd_file.log,'');

1083: l_nonzero_shrinkage := l_items.COUNT;
1084:
1085: if (l_nonzero_shrinkage > 0) then
1086: -- print a warning message to the log file and set the request status to WARNING - yellow highlight
1087: fnd_file.put_line(fnd_file.log,'');
1088: fnd_message.set_name('BOM', 'CST_SCC_SHRINKAGE_TO_ZERO');
1089: fnd_message.set_token('NUMBER', to_char(l_nonzero_shrinkage));
1090:
1091: select organization_code

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

1098: into l_costtype
1099: from cst_cost_types
1100: where cost_type_id = i_cost_type;
1101: fnd_message.set_token('CT', l_costtype);
1102: fnd_file.put_line(fnd_file.log, fnd_message.get);
1103:
1104: FOR i in 1..l_nonzero_shrinkage LOOP
1105: select concatenated_segments
1106: into l_itemname

Line 1110: fnd_file.put_line(fnd_file.log, l_itemname);

1106: into l_itemname
1107: from mtl_system_items_kfv
1108: where organization_id = i_org_id
1109: and inventory_item_id = l_items(i);
1110: fnd_file.put_line(fnd_file.log, l_itemname);
1111: END LOOP;
1112: fnd_file.put_line(fnd_file.log,'');
1113:
1114: -- Now update the usage_rate_or_amount and the net_yield_or_shrinkage_factor in CICD

Line 1112: fnd_file.put_line(fnd_file.log,'');

1108: where organization_id = i_org_id
1109: and inventory_item_id = l_items(i);
1110: fnd_file.put_line(fnd_file.log, l_itemname);
1111: END LOOP;
1112: fnd_file.put_line(fnd_file.log,'');
1113:
1114: -- Now update the usage_rate_or_amount and the net_yield_or_shrinkage_factor in CICD
1115: l_stmt_num := 60;
1116: FORALL i in l_items.FIRST..l_items.LAST

Line 1131: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details related to the shrinkage rate.');

1127: WHERE cost_type_id = i_cost_type
1128: AND organization_id = i_org_id
1129: AND inventory_item_id = l_items(i);
1130:
1131: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details related to the shrinkage rate.');
1132:
1133: l_err_msg := 'Forcing shrinkage rate to 0';
1134: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_err_msg);
1135: end if;

Line 1187: fnd_file.put_line(fnd_file.log,'');

1183: RETURNING cic.inventory_item_id BULK COLLECT INTO l_items;
1184:
1185: -- print warning CANNOT UPDATE DEFAULT_FLAG!!!!
1186: if (l_items.COUNT > 0) then
1187: fnd_file.put_line(fnd_file.log,'');
1188: fnd_message.set_name('BOM', 'CST_SCC_CANT_UPDT_DEFAULT');
1189: fnd_message.set_token('NUMBER', to_char(l_items.COUNT));
1190:
1191: if (l_orgcode IS NULL) then

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

1202: from cst_cost_types
1203: where cost_type_id = i_cost_type;
1204: end if;
1205: fnd_message.set_token('CT', l_costtype);
1206: fnd_file.put_line(fnd_file.log, fnd_message.get);
1207:
1208: FOR i in 1..l_items.COUNT LOOP
1209: select concatenated_segments
1210: into l_itemname

Line 1214: fnd_file.put_line(fnd_file.log, l_itemname);

1210: into l_itemname
1211: from mtl_system_items_kfv
1212: where organization_id = i_org_id
1213: and inventory_item_id = l_items(i);
1214: fnd_file.put_line(fnd_file.log, l_itemname);
1215: END LOOP;
1216: fnd_file.put_line(fnd_file.log,'');
1217:
1218: l_err_msg := 'Cannot update defaulted_flag to YES';

Line 1216: fnd_file.put_line(fnd_file.log,'');

1212: where organization_id = i_org_id
1213: and inventory_item_id = l_items(i);
1214: fnd_file.put_line(fnd_file.log, l_itemname);
1215: END LOOP;
1216: fnd_file.put_line(fnd_file.log,'');
1217:
1218: l_err_msg := 'Cannot update defaulted_flag to YES';
1219: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_err_msg);
1220: end if;

Line 1300: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details making them user-defined.');

1296: /* Change this select for bug 4881571 */
1297:
1298: END IF;
1299:
1300: fnd_file.put_line(fnd_file.log,'Updated '||to_char(SQL%ROWCOUNT)||' rows in cst_item_cost_details making them user-defined.');
1301: end if;
1302:
1303:
1304: commit;

Line 1313: fnd_file.put_line(fnd_file.log,l_err_msg);

1309: EXCEPTION
1310:
1311: when others then
1312: l_err_msg := 'CSTPUMEC.set_cost_controls - error in statement '||to_char(l_stmt_num)||': '|| substrb(SQLERRM,1,150);
1313: fnd_file.put_line(fnd_file.log,l_err_msg);
1314: fnd_file.put_line(fnd_file.log,'All changes rolled back.');
1315: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1316: O_Err_Num := SQLCODE;
1317: O_Err_Msg := l_err_msg;

Line 1314: fnd_file.put_line(fnd_file.log,'All changes rolled back.');

1310:
1311: when others then
1312: l_err_msg := 'CSTPUMEC.set_cost_controls - error in statement '||to_char(l_stmt_num)||': '|| substrb(SQLERRM,1,150);
1313: fnd_file.put_line(fnd_file.log,l_err_msg);
1314: fnd_file.put_line(fnd_file.log,'All changes rolled back.');
1315: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1316: O_Err_Num := SQLCODE;
1317: O_Err_Msg := l_err_msg;
1318: ROLLBACK TO SAVEPOINT set_cost_controls_PUB;