294: trace(C_PROC_LEVEL, l_procedure_name, 'END');
295: EXCEPTION
296: WHEN OTHERS THEN
297: p_error_code := c_FAILURE;
298: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
299: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
300: p_error_desc := fnd_message.get;
301: stack_error (l_procedure_name, 'FINAL', p_error_desc);
302: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
295: EXCEPTION
296: WHEN OTHERS THEN
297: p_error_code := c_FAILURE;
298: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
299: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
300: p_error_desc := fnd_message.get;
301: stack_error (l_procedure_name, 'FINAL', p_error_desc);
302: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
303: END;
296: WHEN OTHERS THEN
297: p_error_code := c_FAILURE;
298: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
299: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
300: p_error_desc := fnd_message.get;
301: stack_error (l_procedure_name, 'FINAL', p_error_desc);
302: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
303: END;
304:
396: trace(C_PROC_LEVEL, l_procedure_name, 'END');
397: EXCEPTION
398: WHEN OTHERS THEN
399: p_error_code := c_FAILURE;
400: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
401: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
402: p_error_desc := fnd_message.get;
403: stack_error (l_procedure_name, 'FINAL', p_error_desc);
404: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
397: EXCEPTION
398: WHEN OTHERS THEN
399: p_error_code := c_FAILURE;
400: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
401: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
402: p_error_desc := fnd_message.get;
403: stack_error (l_procedure_name, 'FINAL', p_error_desc);
404: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
405: END;
398: WHEN OTHERS THEN
399: p_error_code := c_FAILURE;
400: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
401: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
402: p_error_desc := fnd_message.get;
403: stack_error (l_procedure_name, 'FINAL', p_error_desc);
404: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
405: END;
406:
716: trace(C_PROC_LEVEL, l_procedure_name, 'END');
717: EXCEPTION
718: WHEN OTHERS THEN
719: p_error_code := c_FAILURE;
720: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
721: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
722: p_error_desc := fnd_message.get;
723: stack_error (l_procedure_name, 'FINAL', p_error_desc);
724: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
717: EXCEPTION
718: WHEN OTHERS THEN
719: p_error_code := c_FAILURE;
720: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
721: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
722: p_error_desc := fnd_message.get;
723: stack_error (l_procedure_name, 'FINAL', p_error_desc);
724: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
725: END;
718: WHEN OTHERS THEN
719: p_error_code := c_FAILURE;
720: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
721: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
722: p_error_desc := fnd_message.get;
723: stack_error (l_procedure_name, 'FINAL', p_error_desc);
724: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
725: END;
726:
780:
781: EXCEPTION
782: WHEN OTHERS THEN
783: l_error_code := c_FAILURE;
784: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
785: fnd_message.set_token('MESSAGE' , 'System Error '||l_procedure_name||' :'||SQLERRM);
786: l_error_desc := fnd_message.get;
787: stack_error (l_procedure_name, 'FINAL', l_error_desc);
788: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||l_error_desc);
781: EXCEPTION
782: WHEN OTHERS THEN
783: l_error_code := c_FAILURE;
784: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
785: fnd_message.set_token('MESSAGE' , 'System Error '||l_procedure_name||' :'||SQLERRM);
786: l_error_desc := fnd_message.get;
787: stack_error (l_procedure_name, 'FINAL', l_error_desc);
788: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||l_error_desc);
789: APP_EXCEPTION.RAISE_EXCEPTION();
782: WHEN OTHERS THEN
783: l_error_code := c_FAILURE;
784: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
785: fnd_message.set_token('MESSAGE' , 'System Error '||l_procedure_name||' :'||SQLERRM);
786: l_error_desc := fnd_message.get;
787: stack_error (l_procedure_name, 'FINAL', l_error_desc);
788: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||l_error_desc);
789: APP_EXCEPTION.RAISE_EXCEPTION();
790: END po_extract;
821: EXCEPTION
822: WHEN OTHERS THEN
823: l_debug_info := 'Error in Federal SLA Processing ' || SQLERRM;
824: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
825: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
826: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
827: 'Procedure :fv_sla_processing_pkg.extract'|| CRLF||
828: 'Error :'||SQLERRM);
829: FND_MSG_PUB.ADD;
822: WHEN OTHERS THEN
823: l_debug_info := 'Error in Federal SLA Processing ' || SQLERRM;
824: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
825: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
826: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
827: 'Procedure :fv_sla_processing_pkg.extract'|| CRLF||
828: 'Error :'||SQLERRM);
829: FND_MSG_PUB.ADD;
830: APP_EXCEPTION.RAISE_EXCEPTION;