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

Line 143: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');

139: l_stmt_num := 10;
140:
141: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
142:
143: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
144: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
145: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
146: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );

Line 144: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);

140:
141: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
142:
143: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
144: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
145: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
146: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );

Line 145: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );

141: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
142:
143: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
144: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
145: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
146: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );

Line 146: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );

142:
143: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
144: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
145: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
146: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );

Line 147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );

143: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
144: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
145: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
146: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );

Line 148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );

144: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
145: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
146: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );

Line 149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );

145: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
146: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);

Line 150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );

146: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );

Line 151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );

147: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );

Line 152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );

148: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );

Line 153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);

149: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );

Line 154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );

150: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );

Line 155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );

151: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );

Line 156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );

152: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );

Line 157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );

153: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
161: fnd_file.put_line(fnd_file.log, ', refresh_routing_based_on ='||p_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project

Line 158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );

154: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
161: fnd_file.put_line(fnd_file.log, ', refresh_routing_based_on ='||p_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
162: fnd_file.put_line(fnd_file.log, ', New_revision_date_rou ='|| p_new_rev_date_rou ); --Added for 12.1 Refresh Bom/Routing Revision Date Project

Line 159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );

155: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
161: fnd_file.put_line(fnd_file.log, ', refresh_routing_based_on ='||p_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
162: fnd_file.put_line(fnd_file.log, ', New_revision_date_rou ='|| p_new_rev_date_rou ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
163: fnd_file.put_line(fnd_file.log, ', refresh_bom_based_on ='||p_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project

Line 160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );

156: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
161: fnd_file.put_line(fnd_file.log, ', refresh_routing_based_on ='||p_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
162: fnd_file.put_line(fnd_file.log, ', New_revision_date_rou ='|| p_new_rev_date_rou ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
163: fnd_file.put_line(fnd_file.log, ', refresh_bom_based_on ='||p_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
164: fnd_file.put_line(fnd_file.log, ', New_revision_date_bom ='|| p_new_rev_date_bom ); --Added for 12.1 Refresh Bom/Routing Revision Date Project

Line 161: fnd_file.put_line(fnd_file.log, ', refresh_routing_based_on ='||p_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project

157: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
161: fnd_file.put_line(fnd_file.log, ', refresh_routing_based_on ='||p_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
162: fnd_file.put_line(fnd_file.log, ', New_revision_date_rou ='|| p_new_rev_date_rou ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
163: fnd_file.put_line(fnd_file.log, ', refresh_bom_based_on ='||p_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
164: fnd_file.put_line(fnd_file.log, ', New_revision_date_bom ='|| p_new_rev_date_bom ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
165:

Line 162: fnd_file.put_line(fnd_file.log, ', New_revision_date_rou ='|| p_new_rev_date_rou ); --Added for 12.1 Refresh Bom/Routing Revision Date Project

158: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
161: fnd_file.put_line(fnd_file.log, ', refresh_routing_based_on ='||p_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
162: fnd_file.put_line(fnd_file.log, ', New_revision_date_rou ='|| p_new_rev_date_rou ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
163: fnd_file.put_line(fnd_file.log, ', refresh_bom_based_on ='||p_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
164: fnd_file.put_line(fnd_file.log, ', New_revision_date_bom ='|| p_new_rev_date_bom ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
165:
166:

Line 163: fnd_file.put_line(fnd_file.log, ', refresh_bom_based_on ='||p_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project

159: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
161: fnd_file.put_line(fnd_file.log, ', refresh_routing_based_on ='||p_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
162: fnd_file.put_line(fnd_file.log, ', New_revision_date_rou ='|| p_new_rev_date_rou ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
163: fnd_file.put_line(fnd_file.log, ', refresh_bom_based_on ='||p_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
164: fnd_file.put_line(fnd_file.log, ', New_revision_date_bom ='|| p_new_rev_date_bom ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
165:
166:
167:

Line 164: fnd_file.put_line(fnd_file.log, ', New_revision_date_bom ='|| p_new_rev_date_bom ); --Added for 12.1 Refresh Bom/Routing Revision Date Project

160: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
161: fnd_file.put_line(fnd_file.log, ', refresh_routing_based_on ='||p_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
162: fnd_file.put_line(fnd_file.log, ', New_revision_date_rou ='|| p_new_rev_date_rou ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
163: fnd_file.put_line(fnd_file.log, ', refresh_bom_based_on ='||p_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
164: fnd_file.put_line(fnd_file.log, ', New_revision_date_bom ='|| p_new_rev_date_bom ); --Added for 12.1 Refresh Bom/Routing Revision Date Project
165:
166:
167:
168:

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

169:
170: IF (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(p_org_id) = 2) THEN
171: --"Profile 'WSM: Create Lot Based Jobs Copy Routing' is set to NO. Cannot refresh Job Copies. "
172: fnd_message.set_name('WSM', 'WSM_USE_COPY_NOT_SET_ERR');
173: fnd_file.put_line(fnd_file.log, fnd_message.get);
174:
175: return;
176: ELSE
177: fnd_file.put_line(fnd_file.log, 'Refreshing the jobs...'); -- VJ remove

Line 177: fnd_file.put_line(fnd_file.log, 'Refreshing the jobs...'); -- VJ remove

173: fnd_file.put_line(fnd_file.log, fnd_message.get);
174:
175: return;
176: ELSE
177: fnd_file.put_line(fnd_file.log, 'Refreshing the jobs...'); -- VJ remove
178: END IF;
179:
180: l_stmt_num := 20;
181:

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

196: -- Added to fix bug #3483253 --
197: THEN
198: --"Based on the concurrent request parameters, Job Copies for no jobs were refreshed. "
199: fnd_message.set_name('WSM', 'WSM_NO_JOBS_TO_REFR');
200: fnd_file.put_line(fnd_file.log, fnd_message.get);
201:
202: return;
203: END IF;
204:

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

227: IF (p_refresh_all_open_jobs = 1) -- Yes
228: THEN
229: --"Based on the concurrent request parameter 'Refresh All Open Jobs', all other parameters are ignored."
230: fnd_message.set_name('WSM', 'WSM_REFR_PARAMS_IGNORED');
231: fnd_file.put_line(fnd_file.log, fnd_message.get);
232:
233: -- Set parameters to their default values
234: l_from_job_name := NULL;
235: l_to_job_name := NULL;

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

266: EXCEPTION
267: WHEN NO_DATA_FOUND THEN
268: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
269: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
270: fnd_file.put_line(fnd_file.log, fnd_message.get);
271: return;
272:
273: WHEN OTHERS THEN
274: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

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

272:
273: WHEN OTHERS THEN
274: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
275: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
276: fnd_file.put_line(fnd_file.log, fnd_message.get);
277: return;
278: END;
279: END IF;
280:

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

293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN
295: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
296: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
297: fnd_file.put_line(fnd_file.log, fnd_message.get);
298: return;
299:
300: WHEN OTHERS THEN
301: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

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

299:
300: WHEN OTHERS THEN
301: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
302: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
303: fnd_file.put_line(fnd_file.log, fnd_message.get);
304: return;
305: END;
306: END IF;
307:

Line 329: fnd_file.put_line(fnd_file.log, 'Timezone is enabled and calling HZ_TIME_ZONE_PUB API ');

325: /* Added for 12.1 Refresh Bom/Routing Revision Date Project to change the new revision date for BOM or Routing to
326: Server Time Zone */
327: IF (l_timezone_enabled) THEN
328:
329: fnd_file.put_line(fnd_file.log, 'Timezone is enabled and calling HZ_TIME_ZONE_PUB API ');
330:
331: l_new_rev_date_rou := fnd_timezone_pub.adjust_datetime(date_time => fnd_date.displayDT_to_date(p_new_rev_date_rou),
332: from_tz => fnd_timezones.get_client_timezone_code,
333: to_tz => fnd_timezones.get_server_timezone_code);

Line 336: fnd_file.put_line(fnd_file.log, 'Timezone is not enabled');

332: from_tz => fnd_timezones.get_client_timezone_code,
333: to_tz => fnd_timezones.get_server_timezone_code);
334:
335: ELSE
336: fnd_file.put_line(fnd_file.log, 'Timezone is not enabled');
337: l_new_rev_date_rou := fnd_date.displayDT_to_date(p_new_rev_date_rou);
338: END IF;
339: END IF;
340:

Line 400: fnd_file.put_line(fnd_file.log, l_count||' jobs will be refreshed');

396:
397: )
398:
399: ;
400: fnd_file.put_line(fnd_file.log, l_count||' jobs will be refreshed');
401: END IF;
402:
403: l_stmt_num := 60;
404:

Line 406: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');

402:
403: l_stmt_num := 60;
404:
405: IF (g_debug = 'Y') THEN
406: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
407: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
408: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
409: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);

Line 407: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);

403: l_stmt_num := 60;
404:
405: IF (g_debug = 'Y') THEN
406: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
407: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
408: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
409: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);

Line 408: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);

404:
405: IF (g_debug = 'Y') THEN
406: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
407: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
408: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
409: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);

Line 409: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);

405: IF (g_debug = 'Y') THEN
406: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
407: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
408: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
409: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);

Line 410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);

406: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
407: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
408: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
409: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);

Line 411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);

407: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
408: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
409: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);

Line 412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);

408: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
409: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);

Line 413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);

409: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);

Line 414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);

410: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);

Line 415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);

411: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
419: fnd_file.put_line(fnd_file.log, ', l_rout_rev_basis ='||l_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project

Line 416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);

412: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
419: fnd_file.put_line(fnd_file.log, ', l_rout_rev_basis ='||l_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
420: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_rou ='|| to_char(l_new_rev_date_rou,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project

Line 417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);

413: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
419: fnd_file.put_line(fnd_file.log, ', l_rout_rev_basis ='||l_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
420: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_rou ='|| to_char(l_new_rev_date_rou,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
421: fnd_file.put_line(fnd_file.log, ', l_bom_rev_basis ='||l_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project

Line 418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);

414: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
419: fnd_file.put_line(fnd_file.log, ', l_rout_rev_basis ='||l_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
420: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_rou ='|| to_char(l_new_rev_date_rou,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
421: fnd_file.put_line(fnd_file.log, ', l_bom_rev_basis ='||l_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
422: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_bom ='|| to_char(l_new_rev_date_bom,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project

Line 419: fnd_file.put_line(fnd_file.log, ', l_rout_rev_basis ='||l_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project

415: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
419: fnd_file.put_line(fnd_file.log, ', l_rout_rev_basis ='||l_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
420: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_rou ='|| to_char(l_new_rev_date_rou,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
421: fnd_file.put_line(fnd_file.log, ', l_bom_rev_basis ='||l_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
422: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_bom ='|| to_char(l_new_rev_date_bom,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
423:

Line 420: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_rou ='|| to_char(l_new_rev_date_rou,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project

416: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
419: fnd_file.put_line(fnd_file.log, ', l_rout_rev_basis ='||l_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
420: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_rou ='|| to_char(l_new_rev_date_rou,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
421: fnd_file.put_line(fnd_file.log, ', l_bom_rev_basis ='||l_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
422: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_bom ='|| to_char(l_new_rev_date_bom,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
423:
424: END IF;

Line 421: fnd_file.put_line(fnd_file.log, ', l_bom_rev_basis ='||l_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project

417: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
419: fnd_file.put_line(fnd_file.log, ', l_rout_rev_basis ='||l_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
420: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_rou ='|| to_char(l_new_rev_date_rou,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
421: fnd_file.put_line(fnd_file.log, ', l_bom_rev_basis ='||l_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
422: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_bom ='|| to_char(l_new_rev_date_bom,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
423:
424: END IF;
425:

Line 422: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_bom ='|| to_char(l_new_rev_date_bom,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project

418: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
419: fnd_file.put_line(fnd_file.log, ', l_rout_rev_basis ='||l_rout_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
420: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_rou ='|| to_char(l_new_rev_date_rou,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
421: fnd_file.put_line(fnd_file.log, ', l_bom_rev_basis ='||l_bom_rev_basis ); --Added for 12.1 Refresh Bom/Routing Revision Date project
422: fnd_file.put_line(fnd_file.log, ', l_new_rev_date_bom ='|| to_char(l_new_rev_date_bom,'DD-MON-YYYY HH24:MI:SS') ); --Added for 12.1 Refresh Bom/Routing Revision Date project
423:
424: END IF;
425:
426: FOR cur_refresh_jobs IN refresh_jobs

Line 563: fnd_file.put_line(fnd_file.log, 'cannot refresh job '|| cur_refresh_jobs.wip_entity_name ||' as there is no valid routing revision at new routing revision date' );

559: );
560:
561: EXCEPTION
562: WHEN OTHERS THEN
563: fnd_file.put_line(fnd_file.log, 'cannot refresh job '|| cur_refresh_jobs.wip_entity_name ||' as there is no valid routing revision at new routing revision date' );
564: x_err_code := -2;
565:
566: END;
567: END IF;

Line 580: fnd_file.put_line(fnd_file.log, 'cannot refresh job '|| cur_refresh_jobs.wip_entity_name ||' as there is no valid bom revision at new bom revision date' );

576: );
577:
578: EXCEPTION
579: WHEN OTHERS THEN
580: fnd_file.put_line(fnd_file.log, 'cannot refresh job '|| cur_refresh_jobs.wip_entity_name ||' as there is no valid bom revision at new bom revision date' );
581: x_err_code := -2;
582:
583: END;
584: END IF;

Line 609: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get

605:
606: --"Job Copies STATUS Refreshed."
607: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
608: fnd_message.set_token('STATUS', NULL);
609: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get
610: );
611:
612: commit; -- Added to fix bug #3465125
613:

Line 626: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf

622:
623: --"Job Copies STATUS Refreshed."
624: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
625: fnd_message.set_token('STATUS', NULL);
626: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
627: );
628:
629: commit; -- Added to fix bug #3465125
630:

Line 643: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf

639:
640: --"Job Copies STATUS Refreshed."
641: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
642: fnd_message.set_token('STATUS', 'Not');
643: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
644: );
645:
646: rollback; -- Added to fix bug #3465125
647:

Line 716: fnd_file.put_line(fnd_file.log, x_err_buf);

712: EXCEPTION
713: WHEN others THEN
714: x_err_code := SQLCODE;
715: x_err_buf := 'Refresh_JobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
716: fnd_file.put_line(fnd_file.log, x_err_buf);
717:
718: END Refresh_JobCopies;
719:
720: