117: EXCEPTION
118:
119: WHEN OTHERS THEN
120: IF (SQLCODE <> -20001) THEN
121: fnd_message.set_name('JE','JE_DEBUG');
122: fnd_message.set_token('ERROR',SQLERRM);
123: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
124: fnd_message.set_token('PARAMETERS',
125: 'p_application_id = '||to_char(p_application_id)
118:
119: WHEN OTHERS THEN
120: IF (SQLCODE <> -20001) THEN
121: fnd_message.set_name('JE','JE_DEBUG');
122: fnd_message.set_token('ERROR',SQLERRM);
123: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
124: fnd_message.set_token('PARAMETERS',
125: 'p_application_id = '||to_char(p_application_id)
126: ||'p_rule_id = '||to_char(p_rule_id)
119: WHEN OTHERS THEN
120: IF (SQLCODE <> -20001) THEN
121: fnd_message.set_name('JE','JE_DEBUG');
122: fnd_message.set_token('ERROR',SQLERRM);
123: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
124: fnd_message.set_token('PARAMETERS',
125: 'p_application_id = '||to_char(p_application_id)
126: ||'p_rule_id = '||to_char(p_rule_id)
127: ||'p_rule_name = '||p_rule_name
120: IF (SQLCODE <> -20001) THEN
121: fnd_message.set_name('JE','JE_DEBUG');
122: fnd_message.set_token('ERROR',SQLERRM);
123: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
124: fnd_message.set_token('PARAMETERS',
125: 'p_application_id = '||to_char(p_application_id)
126: ||'p_rule_id = '||to_char(p_rule_id)
127: ||'p_rule_name = '||p_rule_name
128: ||'p_enabled_flag = '||p_enabled_flag
133: ||'p_last_updated_by = '||to_char(p_last_updated_by)
134: ||'p_last_update_login = '||to_char(p_last_update_login)
135: ||'p_legal_entity_id = ' || p_legal_entity_id );
136:
137: fnd_message.set_token('DEBUG_INFO',debug_info);
138:
139: END IF;
140: app_exception.raise_exception;
141:
182: OPEN c;
183: FETCH c INTO recinfo;
184: IF (c%NOTFOUND) THEN
185: CLOSE c;
186: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
187: app_exception.raise_exception;
188: END IF;
189: CLOSE c;
190:
192: (recinfo.enabled_flag = p_enabled_flag)) THEN
193: null;
194: ELSE
195:
196: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
197: app_exception.raise_exception;
198:
199: END IF;
200:
274: EXCEPTION
275:
276: WHEN OTHERS THEN
277: IF (SQLCODE <> -20001) THEN
278: fnd_message.set_name('JE','JE_DEBUG');
279: fnd_message.set_token('ERROR',SQLERRM);
280: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
281: fnd_message.set_token('PARAMETERS',
282: 'p_application_id = '||to_char(p_application_id)
275:
276: WHEN OTHERS THEN
277: IF (SQLCODE <> -20001) THEN
278: fnd_message.set_name('JE','JE_DEBUG');
279: fnd_message.set_token('ERROR',SQLERRM);
280: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
281: fnd_message.set_token('PARAMETERS',
282: 'p_application_id = '||to_char(p_application_id)
283: ||'p_rule_id = '||to_char(p_rule_id)
276: WHEN OTHERS THEN
277: IF (SQLCODE <> -20001) THEN
278: fnd_message.set_name('JE','JE_DEBUG');
279: fnd_message.set_token('ERROR',SQLERRM);
280: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
281: fnd_message.set_token('PARAMETERS',
282: 'p_application_id = '||to_char(p_application_id)
283: ||'p_rule_id = '||to_char(p_rule_id)
284: ||'p_rule_name = '||p_rule_name
277: IF (SQLCODE <> -20001) THEN
278: fnd_message.set_name('JE','JE_DEBUG');
279: fnd_message.set_token('ERROR',SQLERRM);
280: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
281: fnd_message.set_token('PARAMETERS',
282: 'p_application_id = '||to_char(p_application_id)
283: ||'p_rule_id = '||to_char(p_rule_id)
284: ||'p_rule_name = '||p_rule_name
285: ||'p_enabled_flag = '||p_enabled_flag
287: ||'p_last_update_date = '||to_char(p_last_update_date)
288: ||'p_last_updated_by = '||to_char(p_last_updated_by)
289: ||'p_last_update_login = '||to_char(p_last_update_login)
290: ||'p_legal_entity = '||p_legal_entity_id);
291: fnd_message.set_token('DEBUG_INFO',debug_info);
292: END IF;
293: app_exception.raise_exception;
294:
295: END UPDATE_ROW;
323: EXCEPTION
324:
325: WHEN OTHERS THEN
326: IF (SQLCODE <> -20001) THEN
327: fnd_message.set_name('JE','JE_DEBUG');
328: fnd_message.set_token('ERROR',SQLERRM);
329: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
330: fnd_message.set_token('PARAMETERS',
331: 'p_application_id = '||to_char(p_application_id)
324:
325: WHEN OTHERS THEN
326: IF (SQLCODE <> -20001) THEN
327: fnd_message.set_name('JE','JE_DEBUG');
328: fnd_message.set_token('ERROR',SQLERRM);
329: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
330: fnd_message.set_token('PARAMETERS',
331: 'p_application_id = '||to_char(p_application_id)
332: ||'p_rule_id = '||to_char(p_rule_id));
325: WHEN OTHERS THEN
326: IF (SQLCODE <> -20001) THEN
327: fnd_message.set_name('JE','JE_DEBUG');
328: fnd_message.set_token('ERROR',SQLERRM);
329: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
330: fnd_message.set_token('PARAMETERS',
331: 'p_application_id = '||to_char(p_application_id)
332: ||'p_rule_id = '||to_char(p_rule_id));
333: fnd_message.set_token('DEBUG_INFO',debug_info);
326: IF (SQLCODE <> -20001) THEN
327: fnd_message.set_name('JE','JE_DEBUG');
328: fnd_message.set_token('ERROR',SQLERRM);
329: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
330: fnd_message.set_token('PARAMETERS',
331: 'p_application_id = '||to_char(p_application_id)
332: ||'p_rule_id = '||to_char(p_rule_id));
333: fnd_message.set_token('DEBUG_INFO',debug_info);
334: END IF;
329: fnd_message.set_token('CALLING_SEQUENCE', current_calling_sequence);
330: fnd_message.set_token('PARAMETERS',
331: 'p_application_id = '||to_char(p_application_id)
332: ||'p_rule_id = '||to_char(p_rule_id));
333: fnd_message.set_token('DEBUG_INFO',debug_info);
334: END IF;
335: app_exception.raise_exception;
336:
337: END DELETE_ROW;