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.ENG_ECO_UTIL dependencies on ENG_CHANGE_ACTIONS_UTIL

Line 117: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

113: END IF ;
114:
115: -- For Test/Debug
116: IF FND_API.to_Boolean( p_debug ) THEN
117: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
118: ( p_file_name => p_debug_filename
119: , p_output_dir => p_output_dir
120: );
121: END IF ;

Line 125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');

121: END IF ;
122:
123: -- Write debug message if debug mode is on
124: --IF FND_API.to_Boolean( p_debug ) THEN
125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
128: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);

Line 126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

122:
123: -- Write debug message if debug mode is on
124: --IF FND_API.to_Boolean( p_debug ) THEN
125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
128: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);

Line 127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);

123: -- Write debug message if debug mode is on
124: --IF FND_API.to_Boolean( p_debug ) THEN
125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
128: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);

Line 128: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );

124: --IF FND_API.to_Boolean( p_debug ) THEN
125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
128: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );

Line 129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);

125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
128: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
133: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );

Line 130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);

126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
128: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
133: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
134: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );

Line 131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);

127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
128: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
133: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
134: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
135: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );

Line 132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );

128: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
133: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
134: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
135: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
136: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );

Line 133: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );

129: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
133: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
134: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
135: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
136: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
137: IF (p_rev_item_seq_id IS NOT NULL) THEN

Line 134: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );

130: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
133: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
134: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
135: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
136: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
137: IF (p_rev_item_seq_id IS NOT NULL) THEN
138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );

Line 135: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );

131: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
133: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
134: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
135: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
136: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
137: IF (p_rev_item_seq_id IS NOT NULL) THEN
138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
139: ELSE

Line 136: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );

132: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
133: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
134: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
135: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
136: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
137: IF (p_rev_item_seq_id IS NOT NULL) THEN
138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
139: ELSE
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );

Line 138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );

134: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
135: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
136: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
137: IF (p_rev_item_seq_id IS NOT NULL) THEN
138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
139: ELSE
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
141: END IF;
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

Line 140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );

136: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
137: IF (p_rev_item_seq_id IS NOT NULL) THEN
138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
139: ELSE
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
141: END IF;
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
144: --END IF ;

Line 142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
139: ELSE
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
141: END IF;
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
144: --END IF ;
145:
146: -- Initialize API return status to success

Line 143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

139: ELSE
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
141: END IF;
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
144: --END IF ;
145:
146: -- Initialize API return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 267: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );

263: argument99 => null,
264: argument100 => null
265: );
266:
267: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
268: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
269:
270: IF (x_request_id = 0) THEN
271: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');

Line 268: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );

264: argument100 => null
265: );
266:
267: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
268: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
269:
270: IF (x_request_id = 0) THEN
271: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');
272: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EN'||'G.ENCACNC(Implement ECO)');

Line 277: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('setting x_request_id' );

273: -- concatenating to work around GSCC validation error without changing esisting behaviour
274: FND_MSG_PUB.Add;
275: RAISE FND_API.G_EXC_ERROR;
276: ELSE
277: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('setting x_request_id' );
278: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
279: IF (p_rev_item_seq_id IS NOT NULL ) THEN
280: UPDATE eng_revised_items
281: SET implementation_req_id = x_request_id

Line 278: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );

274: FND_MSG_PUB.Add;
275: RAISE FND_API.G_EXC_ERROR;
276: ELSE
277: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('setting x_request_id' );
278: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
279: IF (p_rev_item_seq_id IS NOT NULL ) THEN
280: UPDATE eng_revised_items
281: SET implementation_req_id = x_request_id
282: WHERE revised_item_sequence_id = p_rev_item_seq_id;

Line 293: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );

289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290: END IF;
291:
292:
293: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );
294:
295:
296: ELSE
297: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );

Line 297: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );

293: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );
294:
295:
296: ELSE
297: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
298: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
299:
300: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
301: FND_MSG_PUB.Add;

Line 298: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );

294:
295:
296: ELSE
297: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
298: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
299:
300: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
301: FND_MSG_PUB.Add;
302: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 303: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );

299:
300: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
301: FND_MSG_PUB.Add;
302: x_return_status := FND_API.G_RET_STS_ERROR ;
303: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );
304:
305: END IF ;
306:
307:

Line 318: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;

314: FND_MSG_PUB.Count_And_Get
315: ( p_count => x_msg_count,
316: p_data => x_msg_data );
317:
318: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
319: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
320:
321:
322: EXCEPTION

Line 319: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

315: ( p_count => x_msg_count,
316: p_data => x_msg_data );
317:
318: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
319: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
320:
321:
322: EXCEPTION
323: WHEN FND_API.G_EXC_ERROR THEN

Line 329: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;

325: x_return_status := FND_API.G_RET_STS_ERROR;
326: FND_MSG_PUB.Count_And_Get
327: ( p_count => x_msg_count
328: ,p_data => x_msg_data );
329: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
330: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO Implement_ECO_PUB;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 330: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

326: FND_MSG_PUB.Count_And_Get
327: ( p_count => x_msg_count
328: ,p_data => x_msg_data );
329: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
330: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO Implement_ECO_PUB;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: FND_MSG_PUB.Count_And_Get

Line 337: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: FND_MSG_PUB.Count_And_Get
335: ( p_count => x_msg_count
336: ,p_data => x_msg_data );
337: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
338: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
339: WHEN OTHERS THEN
340: ROLLBACK TO Implement_ECO_PUB;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 338: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

334: FND_MSG_PUB.Count_And_Get
335: ( p_count => x_msg_count
336: ,p_data => x_msg_data );
337: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
338: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
339: WHEN OTHERS THEN
340: ROLLBACK TO Implement_ECO_PUB;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

Line 349: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;

345: END IF;
346: FND_MSG_PUB.Count_And_Get
347: ( p_count => x_msg_count
348: ,p_data => x_msg_data );
349: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
350: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
351:
352: END Execute_ProcCP;
353:

Line 350: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

346: FND_MSG_PUB.Count_And_Get
347: ( p_count => x_msg_count
348: ,p_data => x_msg_data );
349: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
350: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
351:
352: END Execute_ProcCP;
353:
354: /**

Line 421: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

417: END IF ;
418:
419: -- For Test/Debug
420: IF FND_API.to_Boolean( p_debug ) THEN
421: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
422: ( p_file_name => p_debug_filename
423: , p_output_dir => p_output_dir
424: );
425: END IF ;

Line 429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');

425: END IF ;
426:
427: -- Write debug message if debug mode is on
428: IF FND_API.to_Boolean( p_debug ) THEN
429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );

Line 430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

426:
427: -- Write debug message if debug mode is on
428: IF FND_API.to_Boolean( p_debug ) THEN
429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
434: IF (p_rev_item_seq_id IS NOT NULL) THEN

Line 431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );

427: -- Write debug message if debug mode is on
428: IF FND_API.to_Boolean( p_debug ) THEN
429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
434: IF (p_rev_item_seq_id IS NOT NULL) THEN
435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );

Line 432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );

428: IF FND_API.to_Boolean( p_debug ) THEN
429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
434: IF (p_rev_item_seq_id IS NOT NULL) THEN
435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
436: ELSE

Line 433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );

429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
434: IF (p_rev_item_seq_id IS NOT NULL) THEN
435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
436: ELSE
437: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );

Line 435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );

431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
434: IF (p_rev_item_seq_id IS NOT NULL) THEN
435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
436: ELSE
437: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
438: END IF;
439: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

Line 437: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );

433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
434: IF (p_rev_item_seq_id IS NOT NULL) THEN
435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
436: ELSE
437: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
438: END IF;
439: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
441: END IF ;

Line 439: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
436: ELSE
437: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
438: END IF;
439: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
441: END IF ;
442:
443: -- Initialize API return status to success

Line 440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

436: ELSE
437: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
438: END IF;
439: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
441: END IF ;
442:
443: -- Initialize API return status to success
444: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 584: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );

580: argument100 => null
581: );
582:
583: IF FND_API.to_Boolean( p_debug ) THEN
584: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
585: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
586: END IF ;
587:
588: IF (x_request_id = 0) THEN

Line 585: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );

581: );
582:
583: IF FND_API.to_Boolean( p_debug ) THEN
584: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
585: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
586: END IF ;
587:
588: IF (x_request_id = 0) THEN
589: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');

Line 599: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );

595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596: END IF;
597:
598: IF FND_API.to_Boolean( p_debug ) THEN
599: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );
600: END IF ;
601:
602: ELSE
603: IF FND_API.to_Boolean( p_debug ) THEN

Line 604: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );

600: END IF ;
601:
602: ELSE
603: IF FND_API.to_Boolean( p_debug ) THEN
604: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
605: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
606: END IF ;
607:
608: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');

Line 605: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );

601:
602: ELSE
603: IF FND_API.to_Boolean( p_debug ) THEN
604: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
605: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
606: END IF ;
607:
608: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
609: FND_MSG_PUB.Add;

Line 613: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );

609: FND_MSG_PUB.Add;
610: x_return_status := FND_API.G_RET_STS_ERROR ;
611:
612: IF FND_API.to_Boolean( p_debug ) THEN
613: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );
614: END IF ;
615:
616: END IF ;
617:

Line 629: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;

625: ( p_count => x_msg_count,
626: p_data => x_msg_data );
627:
628: IF FND_API.to_Boolean( p_debug ) THEN
629: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
630: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
631: END IF ;
632:
633:

Line 630: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

626: p_data => x_msg_data );
627:
628: IF FND_API.to_Boolean( p_debug ) THEN
629: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
630: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
631: END IF ;
632:
633:
634: EXCEPTION

Line 642: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;

638: FND_MSG_PUB.Count_And_Get
639: ( p_count => x_msg_count
640: ,p_data => x_msg_data );
641: IF FND_API.to_Boolean( p_debug ) THEN
642: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
643: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
644: END IF ;
645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
646: ROLLBACK TO Implement_ECO_PUB;

Line 643: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

639: ( p_count => x_msg_count
640: ,p_data => x_msg_data );
641: IF FND_API.to_Boolean( p_debug ) THEN
642: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
643: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
644: END IF ;
645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
646: ROLLBACK TO Implement_ECO_PUB;
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 652: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

648: FND_MSG_PUB.Count_And_Get
649: ( p_count => x_msg_count
650: ,p_data => x_msg_data );
651: IF FND_API.to_Boolean( p_debug ) THEN
652: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
653: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
654: END IF ;
655: WHEN OTHERS THEN
656: ROLLBACK TO Implement_ECO_PUB;

Line 653: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

649: ( p_count => x_msg_count
650: ,p_data => x_msg_data );
651: IF FND_API.to_Boolean( p_debug ) THEN
652: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
653: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
654: END IF ;
655: WHEN OTHERS THEN
656: ROLLBACK TO Implement_ECO_PUB;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 666: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;

662: FND_MSG_PUB.Count_And_Get
663: ( p_count => x_msg_count
664: ,p_data => x_msg_data );
665: IF FND_API.to_Boolean( p_debug ) THEN
666: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
667: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
668: END IF ;
669:
670: END Implement_ECO;

Line 667: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

663: ( p_count => x_msg_count
664: ,p_data => x_msg_data );
665: IF FND_API.to_Boolean( p_debug ) THEN
666: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
667: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
668: END IF ;
669:
670: END Implement_ECO;
671:

Line 724: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

720: END IF ;
721:
722: -- For Test/Debug
723: IF FND_API.to_Boolean( p_debug ) THEN
724: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
725: ( p_file_name => p_debug_filename
726: , p_output_dir => p_output_dir
727: );
728: END IF ;

Line 732: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');

728: END IF ;
729:
730: -- Write debug message if debug mode is on
731: IF FND_API.to_Boolean( p_debug ) THEN
732: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
734: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
735: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );

Line 733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

729:
730: -- Write debug message if debug mode is on
731: IF FND_API.to_Boolean( p_debug ) THEN
732: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
734: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
735: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
737: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );

Line 734: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );

730: -- Write debug message if debug mode is on
731: IF FND_API.to_Boolean( p_debug ) THEN
732: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
734: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
735: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
737: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );

Line 735: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );

731: IF FND_API.to_Boolean( p_debug ) THEN
732: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
734: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
735: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
737: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
739: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

Line 736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );

732: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
734: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
735: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
737: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
739: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
740: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

Line 737: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );

733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
734: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
735: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
737: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
739: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
740: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
741: END IF ;

Line 738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );

734: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
735: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
737: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
739: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
740: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
741: END IF ;
742:

Line 739: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

735: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
737: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
739: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
740: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
741: END IF ;
742:
743: -- Initialize API return status to success

Line 740: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

736: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
737: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
739: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
740: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
741: END IF ;
742:
743: -- Initialize API return status to success
744: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 856: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );

852: argument99 => null,
853: argument100 => null);
854:
855: IF FND_API.to_Boolean( p_debug ) THEN
856: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
857: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
858: END IF ;
859:
860: IF (x_request_id = 0) THEN

Line 857: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );

853: argument100 => null);
854:
855: IF FND_API.to_Boolean( p_debug ) THEN
856: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
857: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
858: END IF ;
859:
860: IF (x_request_id = 0) THEN
861: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');

Line 871: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );

867: x_return_status := FND_API.G_RET_STS_SUCCESS;
868: END IF;
869:
870: IF FND_API.to_Boolean( p_debug ) THEN
871: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );
872: END IF ;
873:
874: ENGECOBO.PreProcess_Propagate_Request (
875: p_api_version => 1.0

Line 898: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;

894: ( p_count => x_msg_count,
895: p_data => x_msg_data );
896:
897: IF FND_API.to_Boolean( p_debug ) THEN
898: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
899: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
900: END IF ;
901:
902:

Line 899: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

895: p_data => x_msg_data );
896:
897: IF FND_API.to_Boolean( p_debug ) THEN
898: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
899: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
900: END IF ;
901:
902:
903: EXCEPTION

Line 911: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

907: FND_MSG_PUB.Count_And_Get
908: ( p_count => x_msg_count
909: ,p_data => x_msg_data );
910: IF FND_API.to_Boolean( p_debug ) THEN
911: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
912: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
913: END IF ;
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: ROLLBACK TO Propagate_ECO_PUB;

Line 912: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

908: ( p_count => x_msg_count
909: ,p_data => x_msg_data );
910: IF FND_API.to_Boolean( p_debug ) THEN
911: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
912: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
913: END IF ;
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: ROLLBACK TO Propagate_ECO_PUB;
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 921: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

917: FND_MSG_PUB.Count_And_Get
918: ( p_count => x_msg_count
919: ,p_data => x_msg_data );
920: IF FND_API.to_Boolean( p_debug ) THEN
921: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
922: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
923: END IF ;
924: WHEN OTHERS THEN
925: ROLLBACK TO Propagate_ECO_PUB;

Line 922: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

918: ( p_count => x_msg_count
919: ,p_data => x_msg_data );
920: IF FND_API.to_Boolean( p_debug ) THEN
921: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
922: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
923: END IF ;
924: WHEN OTHERS THEN
925: ROLLBACK TO Propagate_ECO_PUB;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 935: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

931: FND_MSG_PUB.Count_And_Get
932: ( p_count => x_msg_count
933: ,p_data => x_msg_data );
934: IF FND_API.to_Boolean( p_debug ) THEN
935: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
936: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
937: END IF ;
938:
939: END Propagate_ECO;

Line 936: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

932: ( p_count => x_msg_count
933: ,p_data => x_msg_data );
934: IF FND_API.to_Boolean( p_debug ) THEN
935: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
936: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
937: END IF ;
938:
939: END Propagate_ECO;
940:

Line 1034: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

1030: END IF ;
1031:
1032: -- For Test/Debug
1033: IF FND_API.to_Boolean( p_debug ) THEN
1034: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
1035: ( p_file_name => p_debug_filename
1036: , p_output_dir => p_output_dir
1037: );
1038: END IF ;

Line 1042: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');

1038: END IF ;
1039:
1040: -- Write debug message if debug mode is on
1041: IF FND_API.to_Boolean( p_debug ) THEN
1042: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1043: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1044: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1045: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1046: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );

Line 1043: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

1039:
1040: -- Write debug message if debug mode is on
1041: IF FND_API.to_Boolean( p_debug ) THEN
1042: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1043: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1044: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1045: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1046: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1047: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );

Line 1044: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );

1040: -- Write debug message if debug mode is on
1041: IF FND_API.to_Boolean( p_debug ) THEN
1042: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1043: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1044: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1045: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1046: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1047: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1048: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

Line 1045: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );

1041: IF FND_API.to_Boolean( p_debug ) THEN
1042: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1043: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1044: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1045: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1046: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1047: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1048: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1049: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

Line 1046: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );

1042: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1043: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1044: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1045: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1046: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1047: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1048: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1049: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1050: END IF ;

Line 1047: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );

1043: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1044: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1045: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1046: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1047: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1048: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1049: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1050: END IF ;
1051:

Line 1048: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

1044: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1045: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1046: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1047: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1048: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1049: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1050: END IF ;
1051:
1052: -- Initialize API return status to success

Line 1049: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

1045: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1046: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1047: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1048: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1049: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1050: END IF ;
1051:
1052: -- Initialize API return status to success
1053: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1095: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );

1091: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1092: );
1093:
1094: IF FND_API.to_Boolean( p_debug ) THEN
1095: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1096: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1097: END IF ;
1098:
1099: IF SQL%FOUND THEN

Line 1096: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1092: );
1093:
1094: IF FND_API.to_Boolean( p_debug ) THEN
1095: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1096: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1097: END IF ;
1098:
1099: IF SQL%FOUND THEN
1100: IF FND_API.to_Boolean( p_debug ) THEN

Line 1101: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );

1097: END IF ;
1098:
1099: IF SQL%FOUND THEN
1100: IF FND_API.to_Boolean( p_debug ) THEN
1101: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );
1102: END IF ;
1103:
1104: -- Insert records in the history table
1105: Insert into Eng_Current_Scheduled_Dates(

Line 1148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Current_Scheduled_Dates inserted ... ' );

1144: And msi.bom_item_type in
1145: (X_Model, X_OptionClass, X_Planning, X_Standard);
1146:
1147: IF FND_API.to_Boolean( p_debug ) THEN
1148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Current_Scheduled_Dates inserted ... ' );
1149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1150: END IF ;
1151:
1152: -- update revised components EFFECTIVITY_DATE

Line 1149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1145: (X_Model, X_OptionClass, X_Planning, X_Standard);
1146:
1147: IF FND_API.to_Boolean( p_debug ) THEN
1148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Current_Scheduled_Dates inserted ... ' );
1149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1150: END IF ;
1151:
1152: -- update revised components EFFECTIVITY_DATE
1153: UPDATE BOM_INVENTORY_COMPONENTS bic

Line 1167: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );

1163: and organization_id = x_organization_id )
1164: AND bic.IMPLEMENTATION_DATE IS NULL;
1165:
1166: IF FND_API.to_Boolean( p_debug ) THEN
1167: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1168: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1169: END IF ;
1170:
1171: -- update revised components DISABLE_DATE

Line 1168: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1164: AND bic.IMPLEMENTATION_DATE IS NULL;
1165:
1166: IF FND_API.to_Boolean( p_debug ) THEN
1167: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1168: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1169: END IF ;
1170:
1171: -- update revised components DISABLE_DATE
1172: UPDATE BOM_INVENTORY_COMPONENTS bic1

Line 1194: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );

1190: END LOOP;
1191: -- End changes for R12
1192:
1193: IF FND_API.to_Boolean( p_debug ) THEN
1194: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1195: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1196: END IF ;
1197:
1198: -- update operation sequences EFFECTIVITY_DATE

Line 1195: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1191: -- End changes for R12
1192:
1193: IF FND_API.to_Boolean( p_debug ) THEN
1194: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1195: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1196: END IF ;
1197:
1198: -- update operation sequences EFFECTIVITY_DATE
1199: UPDATE BOM_OPERATION_SEQUENCES bos

Line 1209: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );

1205: and organization_id = x_organization_id )
1206: AND bos.IMPLEMENTATION_DATE IS NULL;
1207:
1208: IF FND_API.to_Boolean( p_debug ) THEN
1209: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1210: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1211: END IF ;
1212:
1213: -- update operation sequences DISABLE_DATE

Line 1210: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1206: AND bos.IMPLEMENTATION_DATE IS NULL;
1207:
1208: IF FND_API.to_Boolean( p_debug ) THEN
1209: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1210: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1211: END IF ;
1212:
1213: -- update operation sequences DISABLE_DATE
1214: UPDATE BOM_OPERATION_SEQUENCES bos1

Line 1225: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );

1221: and organization_id = x_organization_id )
1222: AND bos1.IMPLEMENTATION_DATE IS NULL;
1223:
1224: IF FND_API.to_Boolean( p_debug ) THEN
1225: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
1226: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1227: END IF ;
1228:
1229: -- Modified query for performance bug 4251776

Line 1226: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1222: AND bos1.IMPLEMENTATION_DATE IS NULL;
1223:
1224: IF FND_API.to_Boolean( p_debug ) THEN
1225: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
1226: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1227: END IF ;
1228:
1229: -- Modified query for performance bug 4251776
1230: -- update rev item's new revision in MTL_ITEM_REVISIONS_B

Line 1261: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );

1257:
1258:
1259:
1260: IF FND_API.to_Boolean( p_debug ) THEN
1261: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
1262: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1263: END IF ;
1264:
1265: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS

Line 1262: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1258:
1259:
1260: IF FND_API.to_Boolean( p_debug ) THEN
1261: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
1262: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1263: END IF ;
1264:
1265: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
1266: UPDATE MTL_RTG_ITEM_REVISIONS

Line 1290: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );

1286: AND msi.bom_item_type in (X_Model, X_OptionClass,
1287: X_Planning, X_Standard)));
1288:
1289: IF FND_API.to_Boolean( p_debug ) THEN
1290: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1291: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1292: END IF ;
1293:
1294:

Line 1291: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1287: X_Planning, X_Standard)));
1288:
1289: IF FND_API.to_Boolean( p_debug ) THEN
1290: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1291: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1292: END IF ;
1293:
1294:
1295:

Line 1298: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );

1294:
1295:
1296: ELSE
1297: IF FND_API.to_Boolean( p_debug ) THEN
1298: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );
1299: END IF ;
1300:
1301: END IF;
1302:

Line 1314: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;

1310: ( p_count => x_msg_count,
1311: p_data => x_msg_data );
1312:
1313: IF FND_API.to_Boolean( p_debug ) THEN
1314: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1315: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1316: END IF ;
1317:
1318:

Line 1315: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1311: p_data => x_msg_data );
1312:
1313: IF FND_API.to_Boolean( p_debug ) THEN
1314: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1315: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1316: END IF ;
1317:
1318:
1319: EXCEPTION

Line 1327: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

1323: FND_MSG_PUB.Count_And_Get
1324: ( p_count => x_msg_count
1325: ,p_data => x_msg_data );
1326: IF FND_API.to_Boolean( p_debug ) THEN
1327: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1328: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1329: END IF ;
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331: ROLLBACK TO Reschedule_ECO_PUB;

Line 1328: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1324: ( p_count => x_msg_count
1325: ,p_data => x_msg_data );
1326: IF FND_API.to_Boolean( p_debug ) THEN
1327: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1328: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1329: END IF ;
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331: ROLLBACK TO Reschedule_ECO_PUB;
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1337: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

1333: FND_MSG_PUB.Count_And_Get
1334: ( p_count => x_msg_count
1335: ,p_data => x_msg_data );
1336: IF FND_API.to_Boolean( p_debug ) THEN
1337: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1338: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1339: END IF ;
1340: WHEN OTHERS THEN
1341: ROLLBACK TO Reschedule_ECO_PUB;

Line 1338: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1334: ( p_count => x_msg_count
1335: ,p_data => x_msg_data );
1336: IF FND_API.to_Boolean( p_debug ) THEN
1337: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1338: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1339: END IF ;
1340: WHEN OTHERS THEN
1341: ROLLBACK TO Reschedule_ECO_PUB;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1351: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

1347: FND_MSG_PUB.Count_And_Get
1348: ( p_count => x_msg_count
1349: ,p_data => x_msg_data );
1350: IF FND_API.to_Boolean( p_debug ) THEN
1351: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1352: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1353: END IF ;
1354:
1355: END Reschedule_ECO;

Line 1352: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1348: ( p_count => x_msg_count
1349: ,p_data => x_msg_data );
1350: IF FND_API.to_Boolean( p_debug ) THEN
1351: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1352: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1353: END IF ;
1354:
1355: END Reschedule_ECO;
1356:

Line 1432: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

1428: END IF ;
1429:
1430: -- For Test/Debug
1431: IF FND_API.to_Boolean( p_debug ) THEN
1432: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
1433: ( p_file_name => p_debug_filename
1434: , p_output_dir => p_output_dir
1435: );
1436: END IF ;

Line 1440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');

1436: END IF ;
1437:
1438: -- Write debug message if debug mode is on
1439: IF FND_API.to_Boolean( p_debug ) THEN
1440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1441: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1442: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1443: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1444: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );

Line 1441: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

1437:
1438: -- Write debug message if debug mode is on
1439: IF FND_API.to_Boolean( p_debug ) THEN
1440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1441: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1442: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1443: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1444: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1445: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

Line 1442: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );

1438: -- Write debug message if debug mode is on
1439: IF FND_API.to_Boolean( p_debug ) THEN
1440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1441: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1442: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1443: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1444: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1445: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1446: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

Line 1443: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );

1439: IF FND_API.to_Boolean( p_debug ) THEN
1440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1441: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1442: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1443: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1444: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1445: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1446: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1447: END IF ;

Line 1444: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );

1440: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1441: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1442: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1443: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1444: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1445: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1446: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1447: END IF ;
1448:

Line 1445: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

1441: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1442: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1443: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1444: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1445: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1446: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1447: END IF ;
1448:
1449: -- Initialize API return status to success

Line 1446: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

1442: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1443: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1444: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1445: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1446: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1447: END IF ;
1448:
1449: -- Initialize API return status to success
1450: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );

1488: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1489: );
1490:
1491: IF FND_API.to_Boolean( p_debug ) THEN
1492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1494: END IF ;
1495:
1496: IF SQL%FOUND THEN

Line 1493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1489: );
1490:
1491: IF FND_API.to_Boolean( p_debug ) THEN
1492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1494: END IF ;
1495:
1496: IF SQL%FOUND THEN
1497: IF FND_API.to_Boolean( p_debug ) THEN

Line 1498: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );

1494: END IF ;
1495:
1496: IF SQL%FOUND THEN
1497: IF FND_API.to_Boolean( p_debug ) THEN
1498: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );
1499: END IF ;
1500:
1501:
1502: -- update revised components EFFECTIVITY_DATE

Line 1517: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );

1513: and organization_id = x_organization_id )
1514: AND bic.IMPLEMENTATION_DATE IS NULL;
1515:
1516: IF FND_API.to_Boolean( p_debug ) THEN
1517: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1518: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1519: END IF ;
1520:
1521: -- update revised components DISABLE_DATE

Line 1518: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1514: AND bic.IMPLEMENTATION_DATE IS NULL;
1515:
1516: IF FND_API.to_Boolean( p_debug ) THEN
1517: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1518: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1519: END IF ;
1520:
1521: -- update revised components DISABLE_DATE
1522: UPDATE BOM_INVENTORY_COMPONENTS bic1

Line 1544: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );

1540: END LOOP;
1541: -- End changes for R12
1542:
1543: IF FND_API.to_Boolean( p_debug ) THEN
1544: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1545: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1546: END IF ;
1547:
1548: -- update operation sequences EFFECTIVITY_DATE

Line 1545: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1541: -- End changes for R12
1542:
1543: IF FND_API.to_Boolean( p_debug ) THEN
1544: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1545: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1546: END IF ;
1547:
1548: -- update operation sequences EFFECTIVITY_DATE
1549: UPDATE BOM_OPERATION_SEQUENCES bos

Line 1559: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );

1555: and organization_id = x_organization_id )
1556: AND bos.IMPLEMENTATION_DATE IS NULL;
1557:
1558: IF FND_API.to_Boolean( p_debug ) THEN
1559: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1560: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1561: END IF ;
1562:
1563: -- update operation sequences DISABLE_DATE

Line 1560: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1556: AND bos.IMPLEMENTATION_DATE IS NULL;
1557:
1558: IF FND_API.to_Boolean( p_debug ) THEN
1559: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1560: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1561: END IF ;
1562:
1563: -- update operation sequences DISABLE_DATE
1564: UPDATE BOM_OPERATION_SEQUENCES bos1

Line 1575: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );

1571: and organization_id = x_organization_id )
1572: AND bos1.IMPLEMENTATION_DATE IS NULL;
1573:
1574: IF FND_API.to_Boolean( p_debug ) THEN
1575: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
1576: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1577: END IF ;
1578:
1579: -- Modified query for performance bug 4251776

Line 1576: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1572: AND bos1.IMPLEMENTATION_DATE IS NULL;
1573:
1574: IF FND_API.to_Boolean( p_debug ) THEN
1575: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
1576: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1577: END IF ;
1578:
1579: -- Modified query for performance bug 4251776
1580: -- update rev item's new revision in MTL_ITEM_REVISIONS _B

Line 1607: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );

1603: --no updation of mtl_item_revisions_tl
1604:
1605:
1606: IF FND_API.to_Boolean( p_debug ) THEN
1607: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
1608: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1609: END IF ;
1610:
1611: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS

Line 1608: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1604:
1605:
1606: IF FND_API.to_Boolean( p_debug ) THEN
1607: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
1608: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1609: END IF ;
1610:
1611: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
1612: UPDATE MTL_RTG_ITEM_REVISIONS

Line 1636: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );

1632: AND msi.bom_item_type in (X_Model, X_OptionClass,
1633: X_Planning, X_Standard)));
1634:
1635: IF FND_API.to_Boolean( p_debug ) THEN
1636: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1637: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1638: END IF ;
1639:
1640:

Line 1637: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));

1633: X_Planning, X_Standard)));
1634:
1635: IF FND_API.to_Boolean( p_debug ) THEN
1636: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1637: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1638: END IF ;
1639:
1640:
1641:

Line 1644: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );

1640:
1641:
1642: ELSE
1643: IF FND_API.to_Boolean( p_debug ) THEN
1644: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );
1645: END IF ;
1646:
1647: END IF;
1648:

Line 1660: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;

1656: ( p_count => x_msg_count,
1657: p_data => x_msg_data );
1658:
1659: IF FND_API.to_Boolean( p_debug ) THEN
1660: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1661: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1662: END IF ;
1663:
1664:

Line 1661: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1657: p_data => x_msg_data );
1658:
1659: IF FND_API.to_Boolean( p_debug ) THEN
1660: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1661: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1662: END IF ;
1663:
1664:
1665: EXCEPTION

Line 1673: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

1669: FND_MSG_PUB.Count_And_Get
1670: ( p_count => x_msg_count
1671: ,p_data => x_msg_data );
1672: IF FND_API.to_Boolean( p_debug ) THEN
1673: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1674: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1675: END IF ;
1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1677: ROLLBACK TO Change_Effectivity_Date_PUB;

Line 1674: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1670: ( p_count => x_msg_count
1671: ,p_data => x_msg_data );
1672: IF FND_API.to_Boolean( p_debug ) THEN
1673: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1674: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1675: END IF ;
1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1677: ROLLBACK TO Change_Effectivity_Date_PUB;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1683: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

1679: FND_MSG_PUB.Count_And_Get
1680: ( p_count => x_msg_count
1681: ,p_data => x_msg_data );
1682: IF FND_API.to_Boolean( p_debug ) THEN
1683: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1684: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1685: END IF ;
1686: WHEN OTHERS THEN
1687: ROLLBACK TO Change_Effectivity_Date_PUB;

Line 1684: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1680: ( p_count => x_msg_count
1681: ,p_data => x_msg_data );
1682: IF FND_API.to_Boolean( p_debug ) THEN
1683: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1684: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1685: END IF ;
1686: WHEN OTHERS THEN
1687: ROLLBACK TO Change_Effectivity_Date_PUB;
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1697: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;

1693: FND_MSG_PUB.Count_And_Get
1694: ( p_count => x_msg_count
1695: ,p_data => x_msg_data );
1696: IF FND_API.to_Boolean( p_debug ) THEN
1697: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1698: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1699: END IF ;
1700:
1701: END Change_Effectivity_Date;

Line 1698: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1694: ( p_count => x_msg_count
1695: ,p_data => x_msg_data );
1696: IF FND_API.to_Boolean( p_debug ) THEN
1697: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1698: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1699: END IF ;
1700:
1701: END Change_Effectivity_Date;
1702: