116: and bo.std_occurrence_code = 'REMITTANCE'
117: and oc.occurrence_status = 'CONFIRMED';
118: EXCEPTION
119: WHEN OTHERS THEN
120: fnd_file.put_line(fnd_file.log,'exception occured'||sqlerrm);
121: END;
122: ELSE
123: l_occurrence_id := p_occurrence_id ;
124: END IF ; -- bug 10349927
234: END IF;
235: return (l_event_id);
236: EXCEPTION
237: WHEN OTHERS THEN
238: fnd_file.put_line(fnd_file.log,'exception occured'||sqlerrm);
239:
240: END Create_SLA_Event;
241:
242: /*========================================================================
304: -- Bug#8610977 Accouting issue for Mutiple Return Occurrences with same OCCURRENCE_TYPE
305: AND OCCURRENCE_ID = p_occurrence_id;
306:
307: IF l_count > 0 then
308: fnd_file.put_line(fnd_file.log,'Record already exists');
309: return;
310: ELSE
311: insert into jl_br_ar_distributns
312: (ORG_ID,