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 130: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');

126: l_stmt_num := 10;
127:
128: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
129:
130: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
131: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
132: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
133: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
134: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );

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

127:
128: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
129:
130: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
131: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
132: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
133: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
134: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
135: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );

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

128: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
129:
130: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
131: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
132: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
133: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
134: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
135: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
136: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );

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

129:
130: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
131: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
132: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
133: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
134: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
135: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
136: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
137: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );

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

130: fnd_file.put_line(fnd_file.log, 'Parameters to Refresh_JobCopies are :');
131: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
132: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
133: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
134: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
135: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
136: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
137: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
138: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );

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

131: fnd_file.put_line(fnd_file.log, ' refresh_all_open_jobs ='||p_refresh_all_open_jobs);
132: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
133: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
134: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
135: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
136: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
137: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
138: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
139: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );

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

132: fnd_file.put_line(fnd_file.log, ', from_job_name ='||p_from_job_name );
133: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
134: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
135: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
136: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
137: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
138: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
139: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
140: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);

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

133: fnd_file.put_line(fnd_file.log, ', to_job_name ='||p_to_job_name );
134: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
135: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
136: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
137: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
138: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
139: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
140: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
141: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );

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

134: fnd_file.put_line(fnd_file.log, ', job_type ='||p_job_type );
135: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
136: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
137: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
138: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
139: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
140: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
141: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
142: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );

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

135: fnd_file.put_line(fnd_file.log, ', job_assembly_id ='||p_job_assembly_id );
136: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
137: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
138: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
139: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
140: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
141: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
142: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
143: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );

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

136: fnd_file.put_line(fnd_file.log, ', bill_item_id ='||p_bill_item_id );
137: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
138: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
139: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
140: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
141: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
142: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
143: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
144: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );

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

137: fnd_file.put_line(fnd_file.log, ', alt_bom_designator ='||p_alt_bom_designator );
138: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
139: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
140: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
141: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
142: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
143: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
144: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );

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

138: fnd_file.put_line(fnd_file.log, ', rtg_item_id ='||p_rtg_item_id );
139: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
140: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
141: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
142: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
143: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
144: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );

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

139: fnd_file.put_line(fnd_file.log, ', alt_rtg_designator ='||p_alt_rtg_designator );
140: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
141: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
142: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
143: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
144: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );

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

140: fnd_file.put_line(fnd_file.log, ', select_jobs_by_status ='||p_select_jobs_by_status);
141: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
142: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
143: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
144: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
148: 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 145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );

141: fnd_file.put_line(fnd_file.log, ', rel_jobs ='||p_rel_jobs );
142: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
143: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
144: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
148: 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
149: 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 146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );

142: fnd_file.put_line(fnd_file.log, ', unrel_jobs ='||p_unrel_jobs );
143: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
144: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
148: 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
149: 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
150: 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 147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );

143: fnd_file.put_line(fnd_file.log, ', onhold_jobs ='||p_onhold_jobs );
144: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
148: 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
149: 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
150: 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
151: 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 148: 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

144: fnd_file.put_line(fnd_file.log, ', complete_jobs ='||p_complete_jobs );
145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
148: 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
149: 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
150: 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
151: 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
152:

Line 149: 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

145: fnd_file.put_line(fnd_file.log, ', closed_jobs ='||p_closed_jobs );
146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
148: 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
149: 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
150: 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
151: 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
152:
153:

Line 150: 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

146: fnd_file.put_line(fnd_file.log, ', cancelled_jobs ='||p_cancelled_jobs );
147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
148: 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
149: 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
150: 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
151: 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
152:
153:
154:

Line 151: 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

147: fnd_file.put_line(fnd_file.log, ', org_id ='||p_org_id );
148: 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
149: 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
150: 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
151: 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
152:
153:
154:
155:

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

156:
157: IF (WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(p_org_id) = 2) THEN
158: --"Profile 'WSM: Create Lot Based Jobs Copy Routing' is set to NO. Cannot refresh Job Copies. "
159: fnd_message.set_name('WSM', 'WSM_USE_COPY_NOT_SET_ERR');
160: fnd_file.put_line(fnd_file.log, fnd_message.get);
161:
162: return;
163: ELSE
164: fnd_file.put_line(fnd_file.log, 'Refreshing the jobs...'); -- VJ remove

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

160: fnd_file.put_line(fnd_file.log, fnd_message.get);
161:
162: return;
163: ELSE
164: fnd_file.put_line(fnd_file.log, 'Refreshing the jobs...'); -- VJ remove
165: END IF;
166:
167: l_stmt_num := 20;
168:

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

183: -- Added to fix bug #3483253 --
184: THEN
185: --"Based on the concurrent request parameters, Job Copies for no jobs were refreshed. "
186: fnd_message.set_name('WSM', 'WSM_NO_JOBS_TO_REFR');
187: fnd_file.put_line(fnd_file.log, fnd_message.get);
188:
189: return;
190: END IF;
191:

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

214: IF (p_refresh_all_open_jobs = 1) -- Yes
215: THEN
216: --"Based on the concurrent request parameter 'Refresh All Open Jobs', all other parameters are ignored."
217: fnd_message.set_name('WSM', 'WSM_REFR_PARAMS_IGNORED');
218: fnd_file.put_line(fnd_file.log, fnd_message.get);
219:
220: -- Set parameters to their default values
221: l_from_job_name := NULL;
222: l_to_job_name := NULL;

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

253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
256: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
257: fnd_file.put_line(fnd_file.log, fnd_message.get);
258: return;
259:
260: WHEN OTHERS THEN
261: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

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

259:
260: WHEN OTHERS THEN
261: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
262: fnd_message.set_token('FLD_NAME', 'Alternate Bill Designator');
263: fnd_file.put_line(fnd_file.log, fnd_message.get);
264: return;
265: END;
266: END IF;
267:

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

280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
283: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
284: fnd_file.put_line(fnd_file.log, fnd_message.get);
285: return;
286:
287: WHEN OTHERS THEN
288: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');

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

286:
287: WHEN OTHERS THEN
288: fnd_message.set_name('WSM', 'WSM_INVALID_FIELD');
289: fnd_message.set_token('FLD_NAME', 'Alternate Routing Designator');
290: fnd_file.put_line(fnd_file.log, fnd_message.get);
291: return;
292: END;
293: END IF;
294:

Line 309: fnd_file.put_line(fnd_file.log, 'Timezone Convension is enabled and calling adjust_datetime API ');

305:
306: /* Added for 12.1 Refresh Bom/Routing Revision Date Project to change the new revision date for BOM or Routing to Server Time Zone */
307: IF(l_rout_rev_basis IN (2,3)) THEN
308: IF (l_timezone_enabled) THEN
309: fnd_file.put_line(fnd_file.log, 'Timezone Convension is enabled and calling adjust_datetime API ');
310: l_new_rev_date_rou := fnd_timezone_pub.adjust_datetime( date_time => fnd_conc_date.string_to_date(p_new_rev_date_rou),
311: from_tz => fnd_timezones.get_client_timezone_code,
312: to_tz => fnd_timezones.get_server_timezone_code);
313: ELSE

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

310: l_new_rev_date_rou := fnd_timezone_pub.adjust_datetime( date_time => fnd_conc_date.string_to_date(p_new_rev_date_rou),
311: from_tz => fnd_timezones.get_client_timezone_code,
312: to_tz => fnd_timezones.get_server_timezone_code);
313: ELSE
314: fnd_file.put_line(fnd_file.log, 'Timezone Conversion is not enabled');
315: l_new_rev_date_rou := fnd_conc_date.string_to_date(p_new_rev_date_rou);
316: END IF;
317: END IF;
318: IF(l_bom_rev_basis IN (2,3)) THEN

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

364: 1, decode(l_cancelled_jobs, 1, 7, 0),
365: wdj.status_type)
366:
367: );
368: fnd_file.put_line(fnd_file.log, l_count||' jobs will be refreshed');
369: END IF;
370:
371: l_stmt_num := 60;
372:

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

370:
371: l_stmt_num := 60;
372:
373: IF (g_debug = 'Y') THEN
374: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
375: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
376: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
377: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
378: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);

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

371: l_stmt_num := 60;
372:
373: IF (g_debug = 'Y') THEN
374: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
375: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
376: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
377: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
378: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
379: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);

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

372:
373: IF (g_debug = 'Y') THEN
374: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
375: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
376: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
377: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
378: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
379: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
380: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);

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

373: IF (g_debug = 'Y') THEN
374: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
375: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
376: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
377: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
378: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
379: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
380: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
381: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);

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

374: fnd_file.put_line(fnd_file.log, 'Variables used in refresh_jobs cursor are :');
375: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
376: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
377: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
378: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
379: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
380: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
381: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
382: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);

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

375: fnd_file.put_line(fnd_file.log, ' l_from_job_name ='||l_from_job_name);
376: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
377: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
378: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
379: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
380: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
381: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
382: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
383: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);

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

376: fnd_file.put_line(fnd_file.log, ', l_to_job_name ='||l_to_job_name);
377: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
378: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
379: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
380: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
381: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
382: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
383: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);

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

377: fnd_file.put_line(fnd_file.log, ', l_job_type ='||l_job_type);
378: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
379: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
380: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
381: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
382: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
383: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);

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

378: fnd_file.put_line(fnd_file.log, ', l_job_assembly_id ='||l_job_assembly_id);
379: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
380: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
381: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
382: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
383: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);

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

379: fnd_file.put_line(fnd_file.log, ', l_cmn_bill_seq_id ='||l_cmn_bill_seq_id);
380: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
381: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
382: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
383: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
387: 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 384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);

380: fnd_file.put_line(fnd_file.log, ', l_cmn_rtg_seq_id ='||l_cmn_rtg_seq_id);
381: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
382: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
383: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
387: 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
388: 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 385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);

381: fnd_file.put_line(fnd_file.log, ', l_unrel_jobs ='||l_unrel_jobs);
382: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
383: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
387: 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
388: 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
389: 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 386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);

382: fnd_file.put_line(fnd_file.log, ', l_rel_jobs ='||l_rel_jobs);
383: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
387: 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
388: 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
389: 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
390: 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 387: 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

383: fnd_file.put_line(fnd_file.log, ', l_complete_jobs ='||l_complete_jobs);
384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
387: 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
388: 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
389: 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
390: 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
391:

Line 388: 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

384: fnd_file.put_line(fnd_file.log, ', l_onhold_jobs ='||l_onhold_jobs);
385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
387: 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
388: 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
389: 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
390: 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
391:
392: END IF;

Line 389: 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

385: fnd_file.put_line(fnd_file.log, ', l_closed_jobs ='||l_closed_jobs);
386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
387: 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
388: 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
389: 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
390: 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
391:
392: END IF;
393:

Line 390: 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

386: fnd_file.put_line(fnd_file.log, ', l_cancelled_jobs ='||l_cancelled_jobs);
387: 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
388: 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
389: 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
390: 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
391:
392: END IF;
393:
394: FOR cur_refresh_jobs IN refresh_jobs

Line 584: fnd_file.put_line(fnd_file.log, ' In Exception after Create_JobCopies Call for job : '|| cur_refresh_jobs.wip_entity_name ||' Error '||x_err_buf );

580: Exception
581: when others then
582: x_err_buf := sqlerrm(sqlcode);
583: x_err_code := -100;
584: fnd_file.put_line(fnd_file.log, ' In Exception after Create_JobCopies Call for job : '|| cur_refresh_jobs.wip_entity_name ||' Error '||x_err_buf );
585: end;
586: l_stmt_num := 84;
587: -- MES:Populate CURRENT_RTG_OP_SEQ_NUM
588: IF (x_err_code = 0) OR (x_err_code IS NULL) OR (x_err_code = -1) THEN

Line 614: 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' );

610: );
611:
612: EXCEPTION
613: WHEN OTHERS THEN
614: 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' );
615: x_err_code := -2;
616:
617: END;
618: END IF;

Line 631: 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' );

627: );
628:
629: EXCEPTION
630: WHEN OTHERS THEN
631: 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' );
632: x_err_code := -2;
633:
634: END;
635: END IF;

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

656:
657: --"Job Copies STATUS Refreshed."
658: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
659: fnd_message.set_token('STATUS', NULL);
660: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get
661: );
662:
663: commit; -- Added to fix bug #3465125
664:

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

673:
674: --"Job Copies STATUS Refreshed."
675: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
676: fnd_message.set_token('STATUS', NULL);
677: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
678: );
679:
680: commit; -- Added to fix bug #3465125
681:

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

690:
691: --"Job Copies STATUS Refreshed."
692: fnd_message.set_name('WSM', 'WSM_REFR_STATUS');
693: fnd_message.set_token('STATUS', 'Not');
694: fnd_file.put_line(fnd_file.log, l_msg||' '||fnd_message.get||' '||x_err_buf
695: );
696: -- Modified for 11064947.
697: l_err_count := l_err_count+1;
698: rollback; -- Added to fix bug #3465125

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

770: EXCEPTION
771: WHEN others THEN
772: x_err_code := SQLCODE;
773: x_err_buf := 'Refresh_JobCopies('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
774: fnd_file.put_line(fnd_file.log, x_err_buf);
775:
776: END Refresh_JobCopies;
777:
778: