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 130: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

126: END IF ;
127:
128: -- For Test/Debug
129: IF FND_API.to_Boolean( p_debug ) THEN
130: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
131: ( p_file_name => p_debug_filename
132: , p_output_dir => p_output_dir
133: );
134: END IF ;

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

134: END IF ;
135:
136: -- Write debug message if debug mode is on
137: --IF FND_API.to_Boolean( p_debug ) THEN
138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
139: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
141: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);

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

135:
136: -- Write debug message if debug mode is on
137: --IF FND_API.to_Boolean( p_debug ) THEN
138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
139: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
141: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);

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

136: -- Write debug message if debug mode is on
137: --IF FND_API.to_Boolean( p_debug ) THEN
138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
139: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
141: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
144: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);

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

137: --IF FND_API.to_Boolean( p_debug ) THEN
138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
139: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
141: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
144: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
145: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );

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

138: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
139: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
141: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
144: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
145: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
146: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );

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

139: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
141: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
144: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
145: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
146: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
147: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );

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

140: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_api_version ' || p_api_version);
141: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
144: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
145: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
146: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
147: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );

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

141: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_init_msg_list '|| p_init_msg_list );
142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
144: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
145: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
146: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
147: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );

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

142: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_commit '|| p_commit);
143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
144: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
145: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
146: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
147: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
150: IF (p_rev_item_seq_id IS NOT NULL) THEN

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

143: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_validation_level '|| p_validation_level);
144: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
145: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
146: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
147: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
150: IF (p_rev_item_seq_id IS NOT NULL) THEN
151: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );

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

144: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' p_debug '|| p_debug);
145: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
146: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
147: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
150: IF (p_rev_item_seq_id IS NOT NULL) THEN
151: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
152: ELSE

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

145: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
146: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
147: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
150: IF (p_rev_item_seq_id IS NOT NULL) THEN
151: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
152: ELSE
153: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );

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

147: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
148: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_all_org_flag : ' || p_all_org_flag );
149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
150: IF (p_rev_item_seq_id IS NOT NULL) THEN
151: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
152: ELSE
153: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
154: END IF;
155: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

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

149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
150: IF (p_rev_item_seq_id IS NOT NULL) THEN
151: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
152: ELSE
153: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
154: END IF;
155: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
156: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
157: --END IF ;

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

151: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
152: ELSE
153: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
154: END IF;
155: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
156: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
157: --END IF ;
158:
159: -- Initialize API return status to success

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

152: ELSE
153: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
154: END IF;
155: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
156: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
157: --END IF ;
158:
159: -- Initialize API return status to success
160: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

320: -- Code added for bug 9243978 Ends here
321: END IF;
322:
323:
324: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
325: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
326:
327: IF (x_request_id = 0) THEN
328: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');

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

321: END IF;
322:
323:
324: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
325: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
326:
327: IF (x_request_id = 0) THEN
328: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');
329: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EN'||'G.ENCACNC(Implement ECO)');

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

330: -- concatenating to work around GSCC validation error without changing esisting behaviour
331: FND_MSG_PUB.Add;
332: RAISE FND_API.G_EXC_ERROR;
333: ELSE
334: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('setting x_request_id' );
335: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
336: IF (p_rev_item_seq_id IS NOT NULL ) THEN
337: UPDATE eng_revised_items
338: SET implementation_req_id = x_request_id

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

331: FND_MSG_PUB.Add;
332: RAISE FND_API.G_EXC_ERROR;
333: ELSE
334: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('setting x_request_id' );
335: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
336: IF (p_rev_item_seq_id IS NOT NULL ) THEN
337: UPDATE eng_revised_items
338: SET implementation_req_id = x_request_id
339: WHERE revised_item_sequence_id = p_rev_item_seq_id;

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

346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347: END IF;
348:
349:
350: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );
351:
352:
353: ELSE
354: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );

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

350: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );
351:
352:
353: ELSE
354: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
355: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
356:
357: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
358: FND_MSG_PUB.Add;

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

351:
352:
353: ELSE
354: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
355: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
356:
357: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
358: FND_MSG_PUB.Add;
359: x_return_status := FND_API.G_RET_STS_ERROR ;

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

356:
357: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
358: FND_MSG_PUB.Add;
359: x_return_status := FND_API.G_RET_STS_ERROR ;
360: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );
361:
362: END IF ;
363:
364:

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

371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,
373: p_data => x_msg_data );
374:
375: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
376: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
377:
378:
379: EXCEPTION

Line 376: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

372: ( p_count => x_msg_count,
373: p_data => x_msg_data );
374:
375: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
376: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
377:
378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN

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

382: x_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count
385: ,p_data => x_msg_data );
386: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
387: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: ROLLBACK TO Implement_ECO_PUB;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 387: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count
385: ,p_data => x_msg_data );
386: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
387: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: ROLLBACK TO Implement_ECO_PUB;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.Count_And_Get

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

390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.Count_And_Get
392: ( p_count => x_msg_count
393: ,p_data => x_msg_data );
394: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
395: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
396: WHEN OTHERS THEN
397: ROLLBACK TO Implement_ECO_PUB;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 395: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

391: FND_MSG_PUB.Count_And_Get
392: ( p_count => x_msg_count
393: ,p_data => x_msg_data );
394: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
395: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
396: WHEN OTHERS THEN
397: ROLLBACK TO Implement_ECO_PUB;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

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

402: END IF;
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count
405: ,p_data => x_msg_data );
406: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
407: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
408:
409: END Execute_ProcCP;
410:

Line 407: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count
405: ,p_data => x_msg_data );
406: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
407: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
408:
409: END Execute_ProcCP;
410:
411: /**

Line 481: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

477: END IF ;
478:
479: -- For Test/Debug
480: IF FND_API.to_Boolean( p_debug ) THEN
481: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
482: ( p_file_name => p_debug_filename
483: , p_output_dir => p_output_dir
484: );
485: END IF ;

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

485: END IF ;
486:
487: -- Write debug message if debug mode is on
488: IF FND_API.to_Boolean( p_debug ) THEN
489: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
490: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
491: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );

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

486:
487: -- Write debug message if debug mode is on
488: IF FND_API.to_Boolean( p_debug ) THEN
489: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
490: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
491: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
494: IF (p_rev_item_seq_id IS NOT NULL) THEN

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

487: -- Write debug message if debug mode is on
488: IF FND_API.to_Boolean( p_debug ) THEN
489: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
490: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
491: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
494: IF (p_rev_item_seq_id IS NOT NULL) THEN
495: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );

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

488: IF FND_API.to_Boolean( p_debug ) THEN
489: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
490: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
491: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
494: IF (p_rev_item_seq_id IS NOT NULL) THEN
495: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
496: ELSE

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

489: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Implement_ECO log');
490: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
491: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
494: IF (p_rev_item_seq_id IS NOT NULL) THEN
495: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
496: ELSE
497: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );

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

491: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
492: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
494: IF (p_rev_item_seq_id IS NOT NULL) THEN
495: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
496: ELSE
497: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
498: END IF;
499: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

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

493: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
494: IF (p_rev_item_seq_id IS NOT NULL) THEN
495: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
496: ELSE
497: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
498: END IF;
499: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
500: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
501: END IF ;

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

495: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
496: ELSE
497: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
498: END IF;
499: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
500: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
501: END IF ;
502:
503: -- Initialize API return status to success

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

496: ELSE
497: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
498: END IF;
499: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
500: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
501: END IF ;
502:
503: -- Initialize API return status to success
504: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

647: argument100 => null
648: );
649:
650: IF FND_API.to_Boolean( p_debug ) THEN
651: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
652: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
653: END IF ;
654:
655: IF (x_request_id = 0) THEN

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

648: );
649:
650: IF FND_API.to_Boolean( p_debug ) THEN
651: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
652: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
653: END IF ;
654:
655: IF (x_request_id = 0) THEN
656: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');

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

662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663: END IF;
664:
665: IF FND_API.to_Boolean( p_debug ) THEN
666: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );
667: END IF ;
668:
669: ELSE
670: IF FND_API.to_Boolean( p_debug ) THEN

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

667: END IF ;
668:
669: ELSE
670: IF FND_API.to_Boolean( p_debug ) THEN
671: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
672: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
673: END IF ;
674:
675: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');

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

668:
669: ELSE
670: IF FND_API.to_Boolean( p_debug ) THEN
671: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
672: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
673: END IF ;
674:
675: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
676: FND_MSG_PUB.Add;

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

676: FND_MSG_PUB.Add;
677: x_return_status := FND_API.G_RET_STS_ERROR ;
678:
679: IF FND_API.to_Boolean( p_debug ) THEN
680: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );
681: END IF ;
682:
683: END IF ;
684:

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

692: ( p_count => x_msg_count,
693: p_data => x_msg_data );
694:
695: IF FND_API.to_Boolean( p_debug ) THEN
696: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
697: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
698: END IF ;
699:
700:

Line 697: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

693: p_data => x_msg_data );
694:
695: IF FND_API.to_Boolean( p_debug ) THEN
696: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
697: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
698: END IF ;
699:
700:
701: EXCEPTION

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

705: FND_MSG_PUB.Count_And_Get
706: ( p_count => x_msg_count
707: ,p_data => x_msg_data );
708: IF FND_API.to_Boolean( p_debug ) THEN
709: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
710: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
711: END IF ;
712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: ROLLBACK TO Implement_ECO_PUB;

Line 710: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

706: ( p_count => x_msg_count
707: ,p_data => x_msg_data );
708: IF FND_API.to_Boolean( p_debug ) THEN
709: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
710: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
711: END IF ;
712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: ROLLBACK TO Implement_ECO_PUB;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

715: FND_MSG_PUB.Count_And_Get
716: ( p_count => x_msg_count
717: ,p_data => x_msg_data );
718: IF FND_API.to_Boolean( p_debug ) THEN
719: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
720: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
721: END IF ;
722: WHEN OTHERS THEN
723: ROLLBACK TO Implement_ECO_PUB;

Line 720: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

716: ( p_count => x_msg_count
717: ,p_data => x_msg_data );
718: IF FND_API.to_Boolean( p_debug ) THEN
719: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
720: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
721: END IF ;
722: WHEN OTHERS THEN
723: ROLLBACK TO Implement_ECO_PUB;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

729: FND_MSG_PUB.Count_And_Get
730: ( p_count => x_msg_count
731: ,p_data => x_msg_data );
732: IF FND_API.to_Boolean( p_debug ) THEN
733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
734: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
735: END IF ;
736:
737: END Implement_ECO;

Line 734: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

730: ( p_count => x_msg_count
731: ,p_data => x_msg_data );
732: IF FND_API.to_Boolean( p_debug ) THEN
733: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
734: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
735: END IF ;
736:
737: END Implement_ECO;
738:

Line 797: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

793: END IF ;
794:
795: -- For Test/Debug
796: IF FND_API.to_Boolean( p_debug ) THEN
797: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
798: ( p_file_name => p_debug_filename
799: , p_output_dir => p_output_dir
800: );
801: END IF ;

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

801: END IF ;
802:
803: -- Write debug message if debug mode is on
804: IF FND_API.to_Boolean( p_debug ) THEN
805: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
806: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
807: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
808: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
809: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );

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

802:
803: -- Write debug message if debug mode is on
804: IF FND_API.to_Boolean( p_debug ) THEN
805: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
806: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
807: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
808: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
809: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
810: IF (p_rev_item_seq_id IS NOT NULL) THEN

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

803: -- Write debug message if debug mode is on
804: IF FND_API.to_Boolean( p_debug ) THEN
805: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
806: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
807: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
808: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
809: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
810: IF (p_rev_item_seq_id IS NOT NULL) THEN
811: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );

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

804: IF FND_API.to_Boolean( p_debug ) THEN
805: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
806: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
807: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
808: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
809: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
810: IF (p_rev_item_seq_id IS NOT NULL) THEN
811: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
812: ELSE

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

805: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Execute_ProcCP log');
806: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
807: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
808: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
809: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
810: IF (p_rev_item_seq_id IS NOT NULL) THEN
811: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
812: ELSE
813: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );

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

807: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
808: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
809: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
810: IF (p_rev_item_seq_id IS NOT NULL) THEN
811: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
812: ELSE
813: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
814: END IF;
815: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

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

809: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_id : ' || to_char(p_org_id) );
810: IF (p_rev_item_seq_id IS NOT NULL) THEN
811: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
812: ELSE
813: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
814: END IF;
815: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
816: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
817: END IF ;

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

811: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : ' || to_char(p_rev_item_seq_id) );
812: ELSE
813: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
814: END IF;
815: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
816: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
817: END IF ;
818:
819: -- Initialize API return status to success

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

812: ELSE
813: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_rev_item_seq_id : NULL' );
814: END IF;
815: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
816: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
817: END IF ;
818:
819: -- Initialize API return status to success
820: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

958: );
959:
960:
961: IF FND_API.to_Boolean( p_debug ) THEN
962: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
963: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
964: END IF ;
965:
966:

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

959:
960:
961: IF FND_API.to_Boolean( p_debug ) THEN
962: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
963: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
964: END IF ;
965:
966:
967:

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

977: x_return_status := FND_API.G_RET_STS_SUCCESS;
978: END IF;
979:
980: IF FND_API.to_Boolean( p_debug ) THEN
981: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );
982: END IF ;
983:
984: ELSE
985:

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

983:
984: ELSE
985:
986: IF FND_API.to_Boolean( p_debug ) THEN
987: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
988: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
989: END IF ;
990:
991: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');

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

984: ELSE
985:
986: IF FND_API.to_Boolean( p_debug ) THEN
987: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('No implementable revised item found ... ' );
988: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Fnd_Request.Submit_Request not called ... ' );
989: END IF ;
990:
991: FND_MESSAGE.Set_Name('ENG', 'ENG_CANT_IMPL_WO_REV_ITEMS');
992: FND_MSG_PUB.Add;

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

992: FND_MSG_PUB.Add;
993: x_return_status := FND_API.G_RET_STS_ERROR ;
994:
995: IF FND_API.to_Boolean( p_debug ) THEN
996: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Done - adding error message ... ' );
997: END IF ;
998:
999: END IF ;
1000:

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

1010: ( p_count => x_msg_count,
1011: p_data => x_msg_data );
1012:
1013: IF FND_API.to_Boolean( p_debug ) THEN
1014: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1015: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1016: END IF ;
1017:
1018:

Line 1015: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1011: p_data => x_msg_data );
1012:
1013: IF FND_API.to_Boolean( p_debug ) THEN
1014: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1015: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1016: END IF ;
1017:
1018:
1019: EXCEPTION

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

1024: FND_MSG_PUB.Count_And_Get
1025: ( p_count => x_msg_count
1026: ,p_data => x_msg_data );
1027: IF FND_API.to_Boolean( p_debug ) THEN
1028: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
1029: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1030: END IF ;
1031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1032:

Line 1029: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1025: ( p_count => x_msg_count
1026: ,p_data => x_msg_data );
1027: IF FND_API.to_Boolean( p_debug ) THEN
1028: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with expected error.') ;
1029: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1030: END IF ;
1031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1032:
1033: ROLLBACK TO Implement_ECO_PUB;

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

1035: FND_MSG_PUB.Count_And_Get
1036: ( p_count => x_msg_count
1037: ,p_data => x_msg_data );
1038: IF FND_API.to_Boolean( p_debug ) THEN
1039: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1040: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1041: END IF ;
1042: WHEN OTHERS THEN
1043:

Line 1040: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1036: ( p_count => x_msg_count
1037: ,p_data => x_msg_data );
1038: IF FND_API.to_Boolean( p_debug ) THEN
1039: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1040: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1041: END IF ;
1042: WHEN OTHERS THEN
1043:
1044: ROLLBACK TO Implement_ECO_PUB;

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

1050: FND_MSG_PUB.Count_And_Get
1051: ( p_count => x_msg_count
1052: ,p_data => x_msg_data );
1053: IF FND_API.to_Boolean( p_debug ) THEN
1054: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
1055: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1056: END IF ;
1057:
1058: END Execute_ProcCP;

Line 1055: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1051: ( p_count => x_msg_count
1052: ,p_data => x_msg_data );
1053: IF FND_API.to_Boolean( p_debug ) THEN
1054: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with other errors.') ;
1055: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1056: END IF ;
1057:
1058: END Execute_ProcCP;
1059: -- Code changes for enhancement 6084027 end

Line 1111: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

1107: END IF ;
1108:
1109: -- For Test/Debug
1110: IF FND_API.to_Boolean( p_debug ) THEN
1111: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
1112: ( p_file_name => p_debug_filename
1113: , p_output_dir => p_output_dir
1114: );
1115: END IF ;

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

1115: END IF ;
1116:
1117: -- Write debug message if debug mode is on
1118: IF FND_API.to_Boolean( p_debug ) THEN
1119: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
1120: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1121: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1122: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
1123: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );

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

1116:
1117: -- Write debug message if debug mode is on
1118: IF FND_API.to_Boolean( p_debug ) THEN
1119: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
1120: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1121: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1122: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
1123: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
1124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );

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

1117: -- Write debug message if debug mode is on
1118: IF FND_API.to_Boolean( p_debug ) THEN
1119: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
1120: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1121: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1122: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
1123: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
1124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
1125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );

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

1118: IF FND_API.to_Boolean( p_debug ) THEN
1119: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
1120: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1121: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1122: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
1123: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
1124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
1125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
1126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

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

1119: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Propagate_ECO log');
1120: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1121: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1122: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
1123: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
1124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
1125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
1126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

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

1120: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1121: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1122: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
1123: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
1124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
1125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
1126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1128: END IF ;

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

1121: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1122: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
1123: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
1124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
1125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
1126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1128: END IF ;
1129:

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

1122: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_notice : ' || p_change_notice );
1123: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
1124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
1125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
1126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1128: END IF ;
1129:
1130: -- Initialize API return status to success

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

1123: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_hierarchy_name : ' || p_hierarchy_name );
1124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_org_name : ' || p_org_name );
1125: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_local_organization_id : ' || p_local_organization_id );
1126: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1127: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1128: END IF ;
1129:
1130: -- Initialize API return status to success
1131: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1239: argument99 => null,
1240: argument100 => null);
1241:
1242: IF FND_API.to_Boolean( p_debug ) THEN
1243: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
1244: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
1245: END IF ;
1246:
1247: IF (x_request_id = 0) THEN

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

1240: argument100 => null);
1241:
1242: IF FND_API.to_Boolean( p_debug ) THEN
1243: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('After: calling Fnd_Request.Submit_Request' );
1244: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' x_request_id = ' || to_char(x_request_id) );
1245: END IF ;
1246:
1247: IF (x_request_id = 0) THEN
1248: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CONCURRENT_PRGM');

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

1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: END IF;
1256:
1257: IF FND_API.to_Boolean( p_debug ) THEN
1258: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Successful: calling Fnd_Request.Submit_Request' );
1259: END IF ;
1260:
1261: ENGECOBO.PreProcess_Propagate_Request (
1262: p_api_version => 1.0

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

1281: ( p_count => x_msg_count,
1282: p_data => x_msg_data );
1283:
1284: IF FND_API.to_Boolean( p_debug ) THEN
1285: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1286: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1287: END IF ;
1288:
1289:

Line 1286: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1282: p_data => x_msg_data );
1283:
1284: IF FND_API.to_Boolean( p_debug ) THEN
1285: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1286: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1287: END IF ;
1288:
1289:
1290: EXCEPTION

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

1294: FND_MSG_PUB.Count_And_Get
1295: ( p_count => x_msg_count
1296: ,p_data => x_msg_data );
1297: IF FND_API.to_Boolean( p_debug ) THEN
1298: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1299: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1300: END IF ;
1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1302: ROLLBACK TO Propagate_ECO_PUB;

Line 1299: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1295: ( p_count => x_msg_count
1296: ,p_data => x_msg_data );
1297: IF FND_API.to_Boolean( p_debug ) THEN
1298: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1299: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1300: END IF ;
1301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1302: ROLLBACK TO Propagate_ECO_PUB;
1303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1304: FND_MSG_PUB.Count_And_Get
1305: ( p_count => x_msg_count
1306: ,p_data => x_msg_data );
1307: IF FND_API.to_Boolean( p_debug ) THEN
1308: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1309: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1310: END IF ;
1311: WHEN OTHERS THEN
1312: ROLLBACK TO Propagate_ECO_PUB;

Line 1309: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1305: ( p_count => x_msg_count
1306: ,p_data => x_msg_data );
1307: IF FND_API.to_Boolean( p_debug ) THEN
1308: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1309: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1310: END IF ;
1311: WHEN OTHERS THEN
1312: ROLLBACK TO Propagate_ECO_PUB;
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1318: FND_MSG_PUB.Count_And_Get
1319: ( p_count => x_msg_count
1320: ,p_data => x_msg_data );
1321: IF FND_API.to_Boolean( p_debug ) THEN
1322: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1323: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1324: END IF ;
1325:
1326: END Propagate_ECO;

Line 1323: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1319: ( p_count => x_msg_count
1320: ,p_data => x_msg_data );
1321: IF FND_API.to_Boolean( p_debug ) THEN
1322: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1323: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1324: END IF ;
1325:
1326: END Propagate_ECO;
1327:

Line 1421: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

1417: END IF ;
1418:
1419: -- For Test/Debug
1420: IF FND_API.to_Boolean( p_debug ) THEN
1421: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
1422: ( p_file_name => p_debug_filename
1423: , p_output_dir => p_output_dir
1424: );
1425: END IF ;

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

1425: END IF ;
1426:
1427: -- Write debug message if debug mode is on
1428: IF FND_API.to_Boolean( p_debug ) THEN
1429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );

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

1426:
1427: -- Write debug message if debug mode is on
1428: IF FND_API.to_Boolean( p_debug ) THEN
1429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1434: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );

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

1427: -- Write debug message if debug mode is on
1428: IF FND_API.to_Boolean( p_debug ) THEN
1429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1434: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

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

1428: IF FND_API.to_Boolean( p_debug ) THEN
1429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1434: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1436: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

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

1429: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Reschedule_ECO log');
1430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1434: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1436: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1437: END IF ;

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

1430: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1434: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1436: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1437: END IF ;
1438:

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

1431: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1434: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1436: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1437: END IF ;
1438:
1439: -- Initialize API return status to success

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

1432: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1433: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_requestor_id : ' || to_char(p_requestor_id) );
1434: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1435: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1436: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1437: END IF ;
1438:
1439: -- Initialize API return status to success
1440: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1478: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1479: );
1480:
1481: IF FND_API.to_Boolean( p_debug ) THEN
1482: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1483: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1484: END IF ;
1485:
1486: IF SQL%FOUND THEN

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

1479: );
1480:
1481: IF FND_API.to_Boolean( p_debug ) THEN
1482: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1483: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1484: END IF ;
1485:
1486: IF SQL%FOUND THEN
1487: IF FND_API.to_Boolean( p_debug ) THEN

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

1484: END IF ;
1485:
1486: IF SQL%FOUND THEN
1487: IF FND_API.to_Boolean( p_debug ) THEN
1488: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );
1489: END IF ;
1490:
1491: -- Insert records in the history table
1492: Insert into Eng_Current_Scheduled_Dates(

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

1531: And msi.bom_item_type in
1532: (X_Model, X_OptionClass, X_Planning, X_Standard);
1533:
1534: IF FND_API.to_Boolean( p_debug ) THEN
1535: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Current_Scheduled_Dates inserted ... ' );
1536: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1537: END IF ;
1538:
1539: -- update revised components EFFECTIVITY_DATE

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

1532: (X_Model, X_OptionClass, X_Planning, X_Standard);
1533:
1534: IF FND_API.to_Boolean( p_debug ) THEN
1535: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Current_Scheduled_Dates inserted ... ' );
1536: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1537: END IF ;
1538:
1539: -- update revised components EFFECTIVITY_DATE
1540: UPDATE BOM_INVENTORY_COMPONENTS bic

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

1550: and organization_id = x_organization_id )
1551: AND bic.IMPLEMENTATION_DATE IS NULL;
1552:
1553: IF FND_API.to_Boolean( p_debug ) THEN
1554: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1555: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1556: END IF ;
1557:
1558: -- update revised components DISABLE_DATE

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

1551: AND bic.IMPLEMENTATION_DATE IS NULL;
1552:
1553: IF FND_API.to_Boolean( p_debug ) THEN
1554: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1555: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1556: END IF ;
1557:
1558: -- update revised components DISABLE_DATE
1559: UPDATE BOM_INVENTORY_COMPONENTS bic1

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

1577: END LOOP;
1578: -- End changes for R12
1579:
1580: IF FND_API.to_Boolean( p_debug ) THEN
1581: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1582: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1583: END IF ;
1584:
1585: -- update operation sequences EFFECTIVITY_DATE

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

1578: -- End changes for R12
1579:
1580: IF FND_API.to_Boolean( p_debug ) THEN
1581: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1582: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1583: END IF ;
1584:
1585: -- update operation sequences EFFECTIVITY_DATE
1586: UPDATE BOM_OPERATION_SEQUENCES bos

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

1592: and organization_id = x_organization_id )
1593: AND bos.IMPLEMENTATION_DATE IS NULL;
1594:
1595: IF FND_API.to_Boolean( p_debug ) THEN
1596: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1597: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1598: END IF ;
1599:
1600: -- update operation sequences DISABLE_DATE

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

1593: AND bos.IMPLEMENTATION_DATE IS NULL;
1594:
1595: IF FND_API.to_Boolean( p_debug ) THEN
1596: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1597: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1598: END IF ;
1599:
1600: -- update operation sequences DISABLE_DATE
1601: UPDATE BOM_OPERATION_SEQUENCES bos1

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

1608: and organization_id = x_organization_id )
1609: AND bos1.IMPLEMENTATION_DATE IS NULL;
1610:
1611: IF FND_API.to_Boolean( p_debug ) THEN
1612: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
1613: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1614: END IF ;
1615:
1616: -- Modified query for performance bug 4251776

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

1609: AND bos1.IMPLEMENTATION_DATE IS NULL;
1610:
1611: IF FND_API.to_Boolean( p_debug ) THEN
1612: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
1613: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1614: END IF ;
1615:
1616: -- Modified query for performance bug 4251776
1617: -- update rev item's new revision in MTL_ITEM_REVISIONS_B

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

1644:
1645:
1646:
1647: IF FND_API.to_Boolean( p_debug ) THEN
1648: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
1649: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1650: END IF ;
1651:
1652: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS

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

1645:
1646:
1647: IF FND_API.to_Boolean( p_debug ) THEN
1648: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
1649: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1650: END IF ;
1651:
1652: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
1653: UPDATE MTL_RTG_ITEM_REVISIONS

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

1673: AND msi.bom_item_type in (X_Model, X_OptionClass,
1674: X_Planning, X_Standard)));
1675:
1676: IF FND_API.to_Boolean( p_debug ) THEN
1677: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1678: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1679: END IF ;
1680:
1681:

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

1674: X_Planning, X_Standard)));
1675:
1676: IF FND_API.to_Boolean( p_debug ) THEN
1677: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
1678: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1679: END IF ;
1680:
1681:
1682:

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

1681:
1682:
1683: ELSE
1684: IF FND_API.to_Boolean( p_debug ) THEN
1685: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );
1686: END IF ;
1687:
1688: END IF;
1689:

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

1697: ( p_count => x_msg_count,
1698: p_data => x_msg_data );
1699:
1700: IF FND_API.to_Boolean( p_debug ) THEN
1701: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1702: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1703: END IF ;
1704:
1705:

Line 1702: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1698: p_data => x_msg_data );
1699:
1700: IF FND_API.to_Boolean( p_debug ) THEN
1701: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
1702: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1703: END IF ;
1704:
1705:
1706: EXCEPTION

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

1710: FND_MSG_PUB.Count_And_Get
1711: ( p_count => x_msg_count
1712: ,p_data => x_msg_data );
1713: IF FND_API.to_Boolean( p_debug ) THEN
1714: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1715: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1716: END IF ;
1717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1718: ROLLBACK TO Reschedule_ECO_PUB;

Line 1715: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1711: ( p_count => x_msg_count
1712: ,p_data => x_msg_data );
1713: IF FND_API.to_Boolean( p_debug ) THEN
1714: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1715: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1716: END IF ;
1717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1718: ROLLBACK TO Reschedule_ECO_PUB;
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1720: FND_MSG_PUB.Count_And_Get
1721: ( p_count => x_msg_count
1722: ,p_data => x_msg_data );
1723: IF FND_API.to_Boolean( p_debug ) THEN
1724: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1725: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1726: END IF ;
1727: WHEN OTHERS THEN
1728: ROLLBACK TO Reschedule_ECO_PUB;

Line 1725: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1721: ( p_count => x_msg_count
1722: ,p_data => x_msg_data );
1723: IF FND_API.to_Boolean( p_debug ) THEN
1724: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1725: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1726: END IF ;
1727: WHEN OTHERS THEN
1728: ROLLBACK TO Reschedule_ECO_PUB;
1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1734: FND_MSG_PUB.Count_And_Get
1735: ( p_count => x_msg_count
1736: ,p_data => x_msg_data );
1737: IF FND_API.to_Boolean( p_debug ) THEN
1738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1739: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1740: END IF ;
1741:
1742: END Reschedule_ECO;

Line 1739: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

1735: ( p_count => x_msg_count
1736: ,p_data => x_msg_data );
1737: IF FND_API.to_Boolean( p_debug ) THEN
1738: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
1739: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
1740: END IF ;
1741:
1742: END Reschedule_ECO;
1743:

Line 1834: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session

1830: END IF ;
1831:
1832: -- For Test/Debug
1833: IF FND_API.to_Boolean( p_debug ) THEN
1834: ENG_CHANGE_ACTIONS_UTIL.Open_Debug_Session
1835: ( p_file_name => p_debug_filename
1836: , p_output_dir => p_output_dir
1837: );
1838: END IF ;

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

1838: END IF ;
1839:
1840: -- Write debug message if debug mode is on
1841: IF FND_API.to_Boolean( p_debug ) THEN
1842: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1843: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1844: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1845: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1846: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );

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

1839:
1840: -- Write debug message if debug mode is on
1841: IF FND_API.to_Boolean( p_debug ) THEN
1842: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1843: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1844: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1845: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1846: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1847: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');

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

1840: -- Write debug message if debug mode is on
1841: IF FND_API.to_Boolean( p_debug ) THEN
1842: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1843: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1844: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1845: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1846: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1847: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1848: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );

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

1841: IF FND_API.to_Boolean( p_debug ) THEN
1842: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1843: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1844: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1845: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1846: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1847: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1848: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1849: END IF ;

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

1842: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_Eco_Util.Change_Effectivity_Date log');
1843: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1844: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1845: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1846: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1847: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1848: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1849: END IF ;
1850:

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

1843: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1844: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1845: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1846: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1847: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1848: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1849: END IF ;
1850:
1851: -- Initialize API return status to success

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

1844: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_change_id : ' || to_char(p_change_id) );
1845: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_effectivity_date : ' || to_char(p_effectivity_date) );
1846: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('p_comment : ' || substr(p_comment, 1, 240) );
1847: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('-----------------------------------------------------');
1848: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Initializing return status... ' );
1849: END IF ;
1850:
1851: -- Initialize API return status to success
1852: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1915: And msi.bom_item_type in (X_Model, X_OptionClass, X_Planning, X_Standard)
1916: );
1917:
1918: IF FND_API.to_Boolean( p_debug ) THEN
1919: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1920: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1921: END IF ;
1922:
1923: IF SQL%FOUND THEN

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

1916: );
1917:
1918: IF FND_API.to_Boolean( p_debug ) THEN
1919: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Eng_Revised_Items updated ... ' );
1920: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1921: END IF ;
1922:
1923: IF SQL%FOUND THEN
1924: IF FND_API.to_Boolean( p_debug ) THEN

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

1921: END IF ;
1922:
1923: IF SQL%FOUND THEN
1924: IF FND_API.to_Boolean( p_debug ) THEN
1925: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows found, updating: ' );
1926: END IF ;
1927:
1928:
1929: -- update revised components EFFECTIVITY_DATE

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

1940: and organization_id = x_organization_id )
1941: AND bic.IMPLEMENTATION_DATE IS NULL;
1942:
1943: IF FND_API.to_Boolean( p_debug ) THEN
1944: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1945: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1946: END IF ;
1947:
1948: -- update revised components DISABLE_DATE

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

1941: AND bic.IMPLEMENTATION_DATE IS NULL;
1942:
1943: IF FND_API.to_Boolean( p_debug ) THEN
1944: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1945: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1946: END IF ;
1947:
1948: -- update revised components DISABLE_DATE
1949: UPDATE BOM_INVENTORY_COMPONENTS bic1

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

1967: END LOOP;
1968: -- End changes for R12
1969:
1970: IF FND_API.to_Boolean( p_debug ) THEN
1971: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1972: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1973: END IF ;
1974:
1975: -- update operation sequences EFFECTIVITY_DATE

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

1968: -- End changes for R12
1969:
1970: IF FND_API.to_Boolean( p_debug ) THEN
1971: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1972: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1973: END IF ;
1974:
1975: -- update operation sequences EFFECTIVITY_DATE
1976: UPDATE BOM_OPERATION_SEQUENCES bos

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

1982: and organization_id = x_organization_id )
1983: AND bos.IMPLEMENTATION_DATE IS NULL;
1984:
1985: IF FND_API.to_Boolean( p_debug ) THEN
1986: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1987: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1988: END IF ;
1989:
1990: -- update operation sequences DISABLE_DATE

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

1983: AND bos.IMPLEMENTATION_DATE IS NULL;
1984:
1985: IF FND_API.to_Boolean( p_debug ) THEN
1986: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1987: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1988: END IF ;
1989:
1990: -- update operation sequences DISABLE_DATE
1991: UPDATE BOM_OPERATION_SEQUENCES bos1

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

1998: and organization_id = x_organization_id )
1999: AND bos1.IMPLEMENTATION_DATE IS NULL;
2000:
2001: IF FND_API.to_Boolean( p_debug ) THEN
2002: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
2003: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2004: END IF ;
2005:
2006: -- Modified query for performance bug 4251776

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

1999: AND bos1.IMPLEMENTATION_DATE IS NULL;
2000:
2001: IF FND_API.to_Boolean( p_debug ) THEN
2002: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
2003: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2004: END IF ;
2005:
2006: -- Modified query for performance bug 4251776
2007: -- update rev item's new revision in MTL_ITEM_REVISIONS _B

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

2030: --no updation of mtl_item_revisions_tl
2031:
2032:
2033: IF FND_API.to_Boolean( p_debug ) THEN
2034: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
2035: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2036: END IF ;
2037:
2038: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS

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

2031:
2032:
2033: IF FND_API.to_Boolean( p_debug ) THEN
2034: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_ITEM_REVISIONS updated ... ' );
2035: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2036: END IF ;
2037:
2038: -- update rev item's new revision in MTL_RTG_ITEM_REVISIONS
2039: UPDATE MTL_RTG_ITEM_REVISIONS

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

2059: AND msi.bom_item_type in (X_Model, X_OptionClass,
2060: X_Planning, X_Standard)));
2061:
2062: IF FND_API.to_Boolean( p_debug ) THEN
2063: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
2064: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2065: END IF ;
2066:
2067:

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

2060: X_Planning, X_Standard)));
2061:
2062: IF FND_API.to_Boolean( p_debug ) THEN
2063: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('MTL_RTG_ITEM_REVISIONS updated ... ' );
2064: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2065: END IF ;
2066:
2067:
2068:

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

2067:
2068:
2069: ELSE
2070: IF FND_API.to_Boolean( p_debug ) THEN
2071: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('ENG_REVISED_ITEMS rows NOT found. NO updates. ' );
2072: END IF ;
2073:
2074: END IF;
2075:

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

2083: ( p_count => x_msg_count,
2084: p_data => x_msg_data );
2085:
2086: IF FND_API.to_Boolean( p_debug ) THEN
2087: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
2088: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
2089: END IF ;
2090:
2091:

Line 2088: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

2084: p_data => x_msg_data );
2085:
2086: IF FND_API.to_Boolean( p_debug ) THEN
2087: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Finish. Eng Of Proc') ;
2088: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
2089: END IF ;
2090:
2091:
2092: EXCEPTION

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

2096: FND_MSG_PUB.Count_And_Get
2097: ( p_count => x_msg_count
2098: ,p_data => x_msg_data );
2099: IF FND_API.to_Boolean( p_debug ) THEN
2100: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
2101: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
2102: END IF ;
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: ROLLBACK TO Change_Effectivity_Date_PUB;

Line 2101: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

2097: ( p_count => x_msg_count
2098: ,p_data => x_msg_data );
2099: IF FND_API.to_Boolean( p_debug ) THEN
2100: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
2101: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
2102: END IF ;
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: ROLLBACK TO Change_Effectivity_Date_PUB;
2105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2106: FND_MSG_PUB.Count_And_Get
2107: ( p_count => x_msg_count
2108: ,p_data => x_msg_data );
2109: IF FND_API.to_Boolean( p_debug ) THEN
2110: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
2111: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
2112: END IF ;
2113: WHEN OTHERS THEN
2114: ROLLBACK TO Change_Effectivity_Date_PUB;

Line 2111: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

2107: ( p_count => x_msg_count
2108: ,p_data => x_msg_data );
2109: IF FND_API.to_Boolean( p_debug ) THEN
2110: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
2111: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
2112: END IF ;
2113: WHEN OTHERS THEN
2114: ROLLBACK TO Change_Effectivity_Date_PUB;
2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2120: FND_MSG_PUB.Count_And_Get
2121: ( p_count => x_msg_count
2122: ,p_data => x_msg_data );
2123: IF FND_API.to_Boolean( p_debug ) THEN
2124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
2125: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
2126: END IF ;
2127:
2128: END Change_Effectivity_Date;

Line 2125: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;

2121: ( p_count => x_msg_count
2122: ,p_data => x_msg_data );
2123: IF FND_API.to_Boolean( p_debug ) THEN
2124: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('Rollback and Finish with unexpected error.') ;
2125: ENG_CHANGE_ACTIONS_UTIL.Close_Debug_Session ;
2126: END IF ;
2127:
2128: END Change_Effectivity_Date;
2129: