499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: p_error_code := c_FAILURE;
503: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
504: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
505: p_error_desc := fnd_message.get;
506: stack_error (l_procedure_name, 'FINAL', p_error_desc);
507: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
500: EXCEPTION
501: WHEN OTHERS THEN
502: p_error_code := c_FAILURE;
503: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
504: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
505: p_error_desc := fnd_message.get;
506: stack_error (l_procedure_name, 'FINAL', p_error_desc);
507: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
508: END;
501: WHEN OTHERS THEN
502: p_error_code := c_FAILURE;
503: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
504: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
505: p_error_desc := fnd_message.get;
506: stack_error (l_procedure_name, 'FINAL', p_error_desc);
507: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
508: END;
509:
1012:
1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: p_error_code := c_FAILURE;
1016: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1017: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1018: p_error_desc := fnd_message.get;
1019: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1020: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: p_error_code := c_FAILURE;
1016: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1017: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1018: p_error_desc := fnd_message.get;
1019: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1020: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1021: END;
1014: WHEN OTHERS THEN
1015: p_error_code := c_FAILURE;
1016: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1017: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
1018: p_error_desc := fnd_message.get;
1019: stack_error (l_procedure_name, 'FINAL', p_error_desc);
1020: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
1021: END;
1022:
1101:
1102: WHEN OTHERS THEN
1103: l_debug_info := 'Error in Federal AP SLA processing ';
1104: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
1105: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1106: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Procedure :fv_sla_processing_pkg.ap_extract'|| CRLF||'Error :'||SQLERRM);
1107: FND_MSG_PUB.ADD;
1108: APP_EXCEPTION.RAISE_EXCEPTION;
1109: END ap_extract;
1102: WHEN OTHERS THEN
1103: l_debug_info := 'Error in Federal AP SLA processing ';
1104: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
1105: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1106: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Procedure :fv_sla_processing_pkg.ap_extract'|| CRLF||'Error :'||SQLERRM);
1107: FND_MSG_PUB.ADD;
1108: APP_EXCEPTION.RAISE_EXCEPTION;
1109: END ap_extract;
1110:
1142: EXCEPTION
1143: WHEN OTHERS THEN
1144: l_debug_info := 'Error in Federal SLA Processing ' || SQLERRM;
1145: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
1146: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1147: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1148: 'Procedure :fv_sla_processing_pkg.extract'|| CRLF||
1149: 'Error :'||SQLERRM);
1150: FND_MSG_PUB.ADD;
1143: WHEN OTHERS THEN
1144: l_debug_info := 'Error in Federal SLA Processing ' || SQLERRM;
1145: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
1146: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1147: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1148: 'Procedure :fv_sla_processing_pkg.extract'|| CRLF||
1149: 'Error :'||SQLERRM);
1150: FND_MSG_PUB.ADD;
1151: APP_EXCEPTION.RAISE_EXCEPTION;