92: p_enc_accounted_amount := 0;
93: p_enc_entered_amount := 0;
94: WHEN OTHERS THEN
95: p_error_code := c_FAILURE;
96: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
97: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
98: p_error_desc := fnd_message.get;
99: stack_error (l_procedure_name, 'SELECT_RCV_RECEIVING_SUB_LEDGER', p_error_desc);
100: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_RCV_RECEIVING_SUB_LEDGER:'||p_error_desc);
93: p_enc_entered_amount := 0;
94: WHEN OTHERS THEN
95: p_error_code := c_FAILURE;
96: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
97: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
98: p_error_desc := fnd_message.get;
99: stack_error (l_procedure_name, 'SELECT_RCV_RECEIVING_SUB_LEDGER', p_error_desc);
100: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_RCV_RECEIVING_SUB_LEDGER:'||p_error_desc);
101: END;
94: WHEN OTHERS THEN
95: p_error_code := c_FAILURE;
96: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
97: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
98: p_error_desc := fnd_message.get;
99: stack_error (l_procedure_name, 'SELECT_RCV_RECEIVING_SUB_LEDGER', p_error_desc);
100: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_RCV_RECEIVING_SUB_LEDGER:'||p_error_desc);
101: END;
102: ELSIF (p_event_type_code IN ('PO_DEL_INV', 'RET_RI_INV')) THEN
113: p_enc_accounted_amount := 0;
114: p_enc_entered_amount := 0;
115: WHEN OTHERS THEN
116: p_error_code := c_FAILURE;
117: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
118: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
119: p_error_desc := fnd_message.get;
120: stack_error (l_procedure_name, 'SELECT_MTL_TRANSACTION_ACCOUNTS', p_error_desc);
121: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_MTL_TRANSACTION_ACCOUNTS:'||p_error_desc);
114: p_enc_entered_amount := 0;
115: WHEN OTHERS THEN
116: p_error_code := c_FAILURE;
117: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
118: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
119: p_error_desc := fnd_message.get;
120: stack_error (l_procedure_name, 'SELECT_MTL_TRANSACTION_ACCOUNTS', p_error_desc);
121: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_MTL_TRANSACTION_ACCOUNTS:'||p_error_desc);
122: END;
115: WHEN OTHERS THEN
116: p_error_code := c_FAILURE;
117: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
118: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
119: p_error_desc := fnd_message.get;
120: stack_error (l_procedure_name, 'SELECT_MTL_TRANSACTION_ACCOUNTS', p_error_desc);
121: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_MTL_TRANSACTION_ACCOUNTS:'||p_error_desc);
122: END;
123: ELSE
129: trace(C_STATE_LEVEL, l_procedure_name, 'END');
130: EXCEPTION
131: WHEN OTHERS THEN
132: p_error_code := c_FAILURE;
133: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
134: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
135: p_error_desc := fnd_message.get;
136: stack_error (l_procedure_name, 'FINAL', p_error_desc);
137: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
130: EXCEPTION
131: WHEN OTHERS THEN
132: p_error_code := c_FAILURE;
133: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
134: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
135: p_error_desc := fnd_message.get;
136: stack_error (l_procedure_name, 'FINAL', p_error_desc);
137: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
138: END;
131: WHEN OTHERS THEN
132: p_error_code := c_FAILURE;
133: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
134: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
135: p_error_desc := fnd_message.get;
136: stack_error (l_procedure_name, 'FINAL', p_error_desc);
137: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
138: END;
139:
486: trace(C_PROC_LEVEL, l_procedure_name, 'End of procedure'||l_procedure_name);
487: EXCEPTION
488: WHEN OTHERS THEN
489: trace(C_STATE_LEVEL, l_procedure_name, 'Error in Federal CST SLA processing '||SQLERRM);
490: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
491: FND_MESSAGE.SET_TOKEN('MESSAGE' , 'Procedure :fv_sla_processing_pkg.cst_extract'|| CRLF|| 'Error :'||SQLERRM);
492: FND_MSG_PUB.ADD;
493: APP_EXCEPTION.RAISE_EXCEPTION;
494: END cst_extract;
487: EXCEPTION
488: WHEN OTHERS THEN
489: trace(C_STATE_LEVEL, l_procedure_name, 'Error in Federal CST SLA processing '||SQLERRM);
490: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
491: FND_MESSAGE.SET_TOKEN('MESSAGE' , 'Procedure :fv_sla_processing_pkg.cst_extract'|| CRLF|| 'Error :'||SQLERRM);
492: FND_MSG_PUB.ADD;
493: APP_EXCEPTION.RAISE_EXCEPTION;
494: END cst_extract;
495:
527: EXCEPTION
528: WHEN OTHERS THEN
529: l_debug_info := 'Error in Federal SLA Processing ' || SQLERRM;
530: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
531: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
532: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
533: 'Procedure :fv_sla_processing_pkg.extract'|| CRLF||
534: 'Error :'||SQLERRM);
535: FND_MSG_PUB.ADD;
528: WHEN OTHERS THEN
529: l_debug_info := 'Error in Federal SLA Processing ' || SQLERRM;
530: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
531: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
532: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
533: 'Procedure :fv_sla_processing_pkg.extract'|| CRLF||
534: 'Error :'||SQLERRM);
535: FND_MSG_PUB.ADD;
536: APP_EXCEPTION.RAISE_EXCEPTION;