105: WHEN NO_DATA_FOUND THEN
106: p_rec_attribute_cat := NULL;
107: WHEN OTHERS THEN
108: p_error_code := c_FAILURE;
109: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
110: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
111: p_error_desc := fnd_message.get;
112: stack_error (l_procedure_name, 'LEDGER_TAB', p_error_desc);
113: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:LEDGER_TAB:'||p_error_desc);
106: p_rec_attribute_cat := NULL;
107: WHEN OTHERS THEN
108: p_error_code := c_FAILURE;
109: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
110: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
111: p_error_desc := fnd_message.get;
112: stack_error (l_procedure_name, 'LEDGER_TAB', p_error_desc);
113: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:LEDGER_TAB:'||p_error_desc);
114: END;
107: WHEN OTHERS THEN
108: p_error_code := c_FAILURE;
109: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
110: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
111: p_error_desc := fnd_message.get;
112: stack_error (l_procedure_name, 'LEDGER_TAB', p_error_desc);
113: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:LEDGER_TAB:'||p_error_desc);
114: END;
115: /*
123: trace(C_PROC_LEVEL, l_procedure_name, 'END');
124: EXCEPTION
125: WHEN OTHERS THEN
126: p_error_code := c_FAILURE;
127: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
128: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
129: p_error_desc := fnd_message.get;
130: fv_sla_utl_processing_pkg.stack_error (l_procedure_name, 'FINAL', p_error_desc);
131: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
124: EXCEPTION
125: WHEN OTHERS THEN
126: p_error_code := c_FAILURE;
127: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
128: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
129: p_error_desc := fnd_message.get;
130: fv_sla_utl_processing_pkg.stack_error (l_procedure_name, 'FINAL', p_error_desc);
131: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
132: END;
125: WHEN OTHERS THEN
126: p_error_code := c_FAILURE;
127: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
128: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
129: p_error_desc := fnd_message.get;
130: fv_sla_utl_processing_pkg.stack_error (l_procedure_name, 'FINAL', p_error_desc);
131: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
132: END;
133:
165: WHERE customer_trx_id = p_transcation_id;
166: EXCEPTION
167: WHEN OTHERS THEN
168: p_error_code := c_FAILURE;
169: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
170: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
171: p_error_desc := fnd_message.get;
172: stack_error (l_procedure_name, 'ra_customer_trx_all_tab', p_error_desc);
173: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ra_customer_trx_all_tab:'||p_error_desc);
166: EXCEPTION
167: WHEN OTHERS THEN
168: p_error_code := c_FAILURE;
169: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
170: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
171: p_error_desc := fnd_message.get;
172: stack_error (l_procedure_name, 'ra_customer_trx_all_tab', p_error_desc);
173: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ra_customer_trx_all_tab:'||p_error_desc);
174: END;
167: WHEN OTHERS THEN
168: p_error_code := c_FAILURE;
169: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
170: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
171: p_error_desc := fnd_message.get;
172: stack_error (l_procedure_name, 'ra_customer_trx_all_tab', p_error_desc);
173: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ra_customer_trx_all_tab:'||p_error_desc);
174: END;
175:
180: trace(C_PROC_LEVEL, l_procedure_name, 'END');
181: EXCEPTION
182: WHEN OTHERS THEN
183: p_error_code := c_FAILURE;
184: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
185: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
186: p_error_desc := fnd_message.get;
187: stack_error (l_procedure_name, 'FINAL', p_error_desc);
188: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
181: EXCEPTION
182: WHEN OTHERS THEN
183: p_error_code := c_FAILURE;
184: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
185: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
186: p_error_desc := fnd_message.get;
187: stack_error (l_procedure_name, 'FINAL', p_error_desc);
188: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
189: END;
182: WHEN OTHERS THEN
183: p_error_code := c_FAILURE;
184: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
185: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
186: p_error_desc := fnd_message.get;
187: stack_error (l_procedure_name, 'FINAL', p_error_desc);
188: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
189: END;
190:
238: END IF;
239: EXCEPTION
240: WHEN OTHERS THEN
241: p_error_code := c_FAILURE;
242: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
243: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
244: p_error_desc := fnd_message.get;
245: stack_error (l_procedure_name, 'ar_cash_receipts_all_tab', p_error_desc);
246: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_cash_receipts_all_tab:'||p_error_desc);
239: EXCEPTION
240: WHEN OTHERS THEN
241: p_error_code := c_FAILURE;
242: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
243: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
244: p_error_desc := fnd_message.get;
245: stack_error (l_procedure_name, 'ar_cash_receipts_all_tab', p_error_desc);
246: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_cash_receipts_all_tab:'||p_error_desc);
247:
240: WHEN OTHERS THEN
241: p_error_code := c_FAILURE;
242: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
243: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
244: p_error_desc := fnd_message.get;
245: stack_error (l_procedure_name, 'ar_cash_receipts_all_tab', p_error_desc);
246: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_cash_receipts_all_tab:'||p_error_desc);
247:
248: END;
256: trace(C_PROC_LEVEL, l_procedure_name, 'END');
257: EXCEPTION
258: WHEN OTHERS THEN
259: p_error_code := c_FAILURE;
260: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
261: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
262: p_error_desc := fnd_message.get;
263: stack_error (l_procedure_name, 'FINAL', p_error_desc);
264: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
257: EXCEPTION
258: WHEN OTHERS THEN
259: p_error_code := c_FAILURE;
260: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
261: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
262: p_error_desc := fnd_message.get;
263: stack_error (l_procedure_name, 'FINAL', p_error_desc);
264: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
265: END;
258: WHEN OTHERS THEN
259: p_error_code := c_FAILURE;
260: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
261: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
262: p_error_desc := fnd_message.get;
263: stack_error (l_procedure_name, 'FINAL', p_error_desc);
264: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
265: END;
266:
322:
323: EXCEPTION
324: WHEN OTHERS THEN
325: p_error_code := c_FAILURE;
326: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
327: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
328: p_error_desc := fnd_message.get;
329: stack_error (l_procedure_name, 'ar_adjustments_all_tab', p_error_desc);
330: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_adjustments_all_tab:'||p_error_desc);
323: EXCEPTION
324: WHEN OTHERS THEN
325: p_error_code := c_FAILURE;
326: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
327: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
328: p_error_desc := fnd_message.get;
329: stack_error (l_procedure_name, 'ar_adjustments_all_tab', p_error_desc);
330: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_adjustments_all_tab:'||p_error_desc);
331: END;
324: WHEN OTHERS THEN
325: p_error_code := c_FAILURE;
326: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
327: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
328: p_error_desc := fnd_message.get;
329: stack_error (l_procedure_name, 'ar_adjustments_all_tab', p_error_desc);
330: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_adjustments_all_tab:'||p_error_desc);
331: END;
332:
337: trace(C_PROC_LEVEL, l_procedure_name, 'END');
338: EXCEPTION
339: WHEN OTHERS THEN
340: p_error_code := c_FAILURE;
341: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
342: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
343: p_error_desc := fnd_message.get;
344: stack_error (l_procedure_name, 'FINAL', p_error_desc);
345: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
338: EXCEPTION
339: WHEN OTHERS THEN
340: p_error_code := c_FAILURE;
341: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
342: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
343: p_error_desc := fnd_message.get;
344: stack_error (l_procedure_name, 'FINAL', p_error_desc);
345: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
346: END;
339: WHEN OTHERS THEN
340: p_error_code := c_FAILURE;
341: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
342: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
343: p_error_desc := fnd_message.get;
344: stack_error (l_procedure_name, 'FINAL', p_error_desc);
345: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
346: END;
347:
383: trace(C_PROC_LEVEL, l_procedure_name, 'l_transcation_id='||l_transcation_id);
384: EXCEPTION
385: WHEN OTHERS THEN
386: p_error_code := c_FAILURE;
387: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
388: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
389: p_error_desc := fnd_message.get;
390: stack_error (l_procedure_name, 'xla_events_tab', p_error_desc);
391: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:xla_events_tab:'||p_error_desc);
384: EXCEPTION
385: WHEN OTHERS THEN
386: p_error_code := c_FAILURE;
387: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
388: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
389: p_error_desc := fnd_message.get;
390: stack_error (l_procedure_name, 'xla_events_tab', p_error_desc);
391: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:xla_events_tab:'||p_error_desc);
392: END;
385: WHEN OTHERS THEN
386: p_error_code := c_FAILURE;
387: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
388: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
389: p_error_desc := fnd_message.get;
390: stack_error (l_procedure_name, 'xla_events_tab', p_error_desc);
391: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:xla_events_tab:'||p_error_desc);
392: END;
393:
436: trace(C_PROC_LEVEL, l_procedure_name, 'END');
437: EXCEPTION
438: WHEN OTHERS THEN
439: p_error_code := c_FAILURE;
440: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
441: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
442: p_error_desc := fnd_message.get;
443: stack_error (l_procedure_name, 'FINAL', p_error_desc);
444: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
437: EXCEPTION
438: WHEN OTHERS THEN
439: p_error_code := c_FAILURE;
440: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
441: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
442: p_error_desc := fnd_message.get;
443: stack_error (l_procedure_name, 'FINAL', p_error_desc);
444: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
445: END;
438: WHEN OTHERS THEN
439: p_error_code := c_FAILURE;
440: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
441: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
442: p_error_desc := fnd_message.get;
443: stack_error (l_procedure_name, 'FINAL', p_error_desc);
444: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
445: END;
446:
485: trace(C_STATE_LEVEL, l_procedure_name, 'l_payment_set_id='||l_payment_set_id);
486: EXCEPTION
487: WHEN OTHERS THEN
488: p_error_code := c_FAILURE;
489: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
490: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
491: p_error_desc := fnd_message.get;
492: stack_error (l_procedure_name, 'ar_receivable_applications_all', p_error_desc);
493: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_receivable_applications_all:'||p_error_desc);
486: EXCEPTION
487: WHEN OTHERS THEN
488: p_error_code := c_FAILURE;
489: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
490: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
491: p_error_desc := fnd_message.get;
492: stack_error (l_procedure_name, 'ar_receivable_applications_all', p_error_desc);
493: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_receivable_applications_all:'||p_error_desc);
494: END;
487: WHEN OTHERS THEN
488: p_error_code := c_FAILURE;
489: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
490: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
491: p_error_desc := fnd_message.get;
492: stack_error (l_procedure_name, 'ar_receivable_applications_all', p_error_desc);
493: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:ar_receivable_applications_all:'||p_error_desc);
494: END;
495:
538: trace(C_PROC_LEVEL, l_procedure_name, 'END');
539: EXCEPTION
540: WHEN OTHERS THEN
541: p_error_code := c_FAILURE;
542: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
543: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
544: p_error_desc := fnd_message.get;
545: stack_error (l_procedure_name, 'FINAL', p_error_desc);
546: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
539: EXCEPTION
540: WHEN OTHERS THEN
541: p_error_code := c_FAILURE;
542: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
543: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
544: p_error_desc := fnd_message.get;
545: stack_error (l_procedure_name, 'FINAL', p_error_desc);
546: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
547: END;
540: WHEN OTHERS THEN
541: p_error_code := c_FAILURE;
542: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
543: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
544: p_error_desc := fnd_message.get;
545: stack_error (l_procedure_name, 'FINAL', p_error_desc);
546: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
547: END;
548:
1060:
1061: EXCEPTION
1062: WHEN OTHERS THEN
1063: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR encountered in Federal AR SLA Processing: ' || SQLERRM);
1064: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1065: FND_MESSAGE.SET_TOKEN('MESSAGE' , 'Procedure :fv_sla_processing_pkg.ar_extract'|| CRLF||
1066: 'Error :'||SQLERRM);
1067: FND_MSG_PUB.ADD;
1068: APP_EXCEPTION.RAISE_EXCEPTION;
1061: EXCEPTION
1062: WHEN OTHERS THEN
1063: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR encountered in Federal AR SLA Processing: ' || SQLERRM);
1064: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1065: FND_MESSAGE.SET_TOKEN('MESSAGE' , 'Procedure :fv_sla_processing_pkg.ar_extract'|| CRLF||
1066: 'Error :'||SQLERRM);
1067: FND_MSG_PUB.ADD;
1068: APP_EXCEPTION.RAISE_EXCEPTION;
1069: END ar_extract;
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: l_debug_info := 'Error in Federal SLA Processing ' || SQLERRM;
1105: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
1106: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1107: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1108: 'Procedure :fv_sla_processing_pkg.extract'|| CRLF||
1109: 'Error :'||SQLERRM);
1110: FND_MSG_PUB.ADD;
1103: WHEN OTHERS THEN
1104: l_debug_info := 'Error in Federal SLA Processing ' || SQLERRM;
1105: trace(C_STATE_LEVEL, l_procedure_name, l_debug_info);
1106: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1107: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1108: 'Procedure :fv_sla_processing_pkg.extract'|| CRLF||
1109: 'Error :'||SQLERRM);
1110: FND_MSG_PUB.ADD;
1111: APP_EXCEPTION.RAISE_EXCEPTION;