122: EXCEPTION
123:
124: WHEN OTHERS THEN
125: IF (SQLCODE <> -20001) THEN
126: fnd_message.set_name('JE','JE_DEBUG');
127: fnd_message.set_token('ERROR',SQLERRM);
128: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
129: fnd_message.set_token('PARAMETERS',
130: 'p_rule_id = '||to_char(p_rule_id)
123:
124: WHEN OTHERS THEN
125: IF (SQLCODE <> -20001) THEN
126: fnd_message.set_name('JE','JE_DEBUG');
127: fnd_message.set_token('ERROR',SQLERRM);
128: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
129: fnd_message.set_token('PARAMETERS',
130: 'p_rule_id = '||to_char(p_rule_id)
131: ||'p_lookup_type = '||p_lookup_type
124: WHEN OTHERS THEN
125: IF (SQLCODE <> -20001) THEN
126: fnd_message.set_name('JE','JE_DEBUG');
127: fnd_message.set_token('ERROR',SQLERRM);
128: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
129: fnd_message.set_token('PARAMETERS',
130: 'p_rule_id = '||to_char(p_rule_id)
131: ||'p_lookup_type = '||p_lookup_type
132: ||'p_lookup_code = '||p_lookup_code
125: IF (SQLCODE <> -20001) THEN
126: fnd_message.set_name('JE','JE_DEBUG');
127: fnd_message.set_token('ERROR',SQLERRM);
128: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
129: fnd_message.set_token('PARAMETERS',
130: 'p_rule_id = '||to_char(p_rule_id)
131: ||'p_lookup_type = '||p_lookup_type
132: ||'p_lookup_code = '||p_lookup_code
133: ||'p_exclude_flag = '||p_exclude_flag
136: ||'p_last_update_date = '||to_char(p_last_update_date)
137: ||'p_last_updated_by = '||to_char(p_last_updated_by)
138: ||'p_last_update_login = '||to_char(p_last_update_login));
139:
140: fnd_message.set_token('DEBUG_INFO',debug_info);
141:
142: END IF;
143: app_exception.raise_exception;
144:
240: OR ((rlinfo.attribute15 is null) AND (p_attribute15 is null)))
241: ) then
242: null;
243: else
244: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
245: app_exception.raise_exception;
246: end if;
247: end loop;
248: return;
319: EXCEPTION
320:
321: WHEN OTHERS THEN
322: IF (SQLCODE <> -20001) THEN
323: fnd_message.set_name('JE','JE_DEBUG');
324: fnd_message.set_token('ERROR',SQLERRM);
325: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
326: fnd_message.set_token('PARAMETERS',
327: 'p_rule_id = '||to_char(p_rule_id)
320:
321: WHEN OTHERS THEN
322: IF (SQLCODE <> -20001) THEN
323: fnd_message.set_name('JE','JE_DEBUG');
324: fnd_message.set_token('ERROR',SQLERRM);
325: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
326: fnd_message.set_token('PARAMETERS',
327: 'p_rule_id = '||to_char(p_rule_id)
328: ||'p_rule_line_id = '||to_char(p_rule_line_id)
321: WHEN OTHERS THEN
322: IF (SQLCODE <> -20001) THEN
323: fnd_message.set_name('JE','JE_DEBUG');
324: fnd_message.set_token('ERROR',SQLERRM);
325: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
326: fnd_message.set_token('PARAMETERS',
327: 'p_rule_id = '||to_char(p_rule_id)
328: ||'p_rule_line_id = '||to_char(p_rule_line_id)
329: ||'p_last_update_date = '||to_char(p_last_update_date)
322: IF (SQLCODE <> -20001) THEN
323: fnd_message.set_name('JE','JE_DEBUG');
324: fnd_message.set_token('ERROR',SQLERRM);
325: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
326: fnd_message.set_token('PARAMETERS',
327: 'p_rule_id = '||to_char(p_rule_id)
328: ||'p_rule_line_id = '||to_char(p_rule_line_id)
329: ||'p_last_update_date = '||to_char(p_last_update_date)
330: ||'p_last_updated_by = '||to_char(p_last_updated_by)
328: ||'p_rule_line_id = '||to_char(p_rule_line_id)
329: ||'p_last_update_date = '||to_char(p_last_update_date)
330: ||'p_last_updated_by = '||to_char(p_last_updated_by)
331: ||'p_last_update_login = '||to_char(p_last_update_login));
332: fnd_message.set_token('DEBUG_INFO',debug_info);
333: END IF;
334: app_exception.raise_exception;
335:
336: END UPDATE_ROW;
359: EXCEPTION
360:
361: WHEN OTHERS THEN
362: IF (SQLCODE <> -20001) THEN
363: fnd_message.set_name('JE','JE_DEBUG');
364: fnd_message.set_token('ERROR',SQLERRM);
365: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
366: fnd_message.set_token('PARAMETERS',
367: 'p_rule_line_id = '||to_char(p_rule_line_id)
360:
361: WHEN OTHERS THEN
362: IF (SQLCODE <> -20001) THEN
363: fnd_message.set_name('JE','JE_DEBUG');
364: fnd_message.set_token('ERROR',SQLERRM);
365: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
366: fnd_message.set_token('PARAMETERS',
367: 'p_rule_line_id = '||to_char(p_rule_line_id)
368: ||'p_rule_id = '||to_char(p_rule_id));
361: WHEN OTHERS THEN
362: IF (SQLCODE <> -20001) THEN
363: fnd_message.set_name('JE','JE_DEBUG');
364: fnd_message.set_token('ERROR',SQLERRM);
365: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
366: fnd_message.set_token('PARAMETERS',
367: 'p_rule_line_id = '||to_char(p_rule_line_id)
368: ||'p_rule_id = '||to_char(p_rule_id));
369: fnd_message.set_token('DEBUG_INFO',debug_info);
362: IF (SQLCODE <> -20001) THEN
363: fnd_message.set_name('JE','JE_DEBUG');
364: fnd_message.set_token('ERROR',SQLERRM);
365: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
366: fnd_message.set_token('PARAMETERS',
367: 'p_rule_line_id = '||to_char(p_rule_line_id)
368: ||'p_rule_id = '||to_char(p_rule_id));
369: fnd_message.set_token('DEBUG_INFO',debug_info);
370: END IF;
365: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
366: fnd_message.set_token('PARAMETERS',
367: 'p_rule_line_id = '||to_char(p_rule_line_id)
368: ||'p_rule_id = '||to_char(p_rule_id));
369: fnd_message.set_token('DEBUG_INFO',debug_info);
370: END IF;
371: app_exception.raise_exception;
372:
373: END DELETE_ROW;