111: NULL;
112:
113: WHEN OTHERS THEN
114: IF (SQLCODE <> -20001) THEN
115: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
116: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
117: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
118: END IF;
119: APP_EXCEPTION.RAISE_EXCEPTION;
112:
113: WHEN OTHERS THEN
114: IF (SQLCODE <> -20001) THEN
115: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
116: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
117: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
118: END IF;
119: APP_EXCEPTION.RAISE_EXCEPTION;
120:
113: WHEN OTHERS THEN
114: IF (SQLCODE <> -20001) THEN
115: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
116: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
117: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
118: END IF;
119: APP_EXCEPTION.RAISE_EXCEPTION;
120:
121: END insert_row;
190: NULL;
191:
192: WHEN OTHERS THEN
193: IF (SQLCODE <> -20001) THEN
194: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
195: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
196: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
197: END IF;
198: APP_EXCEPTION.RAISE_EXCEPTION;
191:
192: WHEN OTHERS THEN
193: IF (SQLCODE <> -20001) THEN
194: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
195: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
196: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
197: END IF;
198: APP_EXCEPTION.RAISE_EXCEPTION;
199:
192: WHEN OTHERS THEN
193: IF (SQLCODE <> -20001) THEN
194: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
195: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
196: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
197: END IF;
198: APP_EXCEPTION.RAISE_EXCEPTION;
199:
200: END update_row;
218: NULL;
219:
220: WHEN OTHERS THEN
221: IF (SQLCODE <> -20001) THEN
222: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
223: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
225: END IF;
226: APP_EXCEPTION.RAISE_EXCEPTION;
219:
220: WHEN OTHERS THEN
221: IF (SQLCODE <> -20001) THEN
222: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
223: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
225: END IF;
226: APP_EXCEPTION.RAISE_EXCEPTION;
227:
220: WHEN OTHERS THEN
221: IF (SQLCODE <> -20001) THEN
222: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
223: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
225: END IF;
226: APP_EXCEPTION.RAISE_EXCEPTION;
227:
228:
358: (recinfo.org_id IS NULL AND x_org_id IS NULL)))
359: THEN
360: NULL;
361: ELSE
362: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
363: APP_EXCEPTION.RAISE_EXCEPTION;
364: END IF;
365:
366: EXCEPTION
369:
370: WHEN OTHERS THEN
371: IF (SQLCODE <> -20001) THEN
372: IF (SQLCODE = -54) THEN
373: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
374: ELSE
375: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
376: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
377: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
371: IF (SQLCODE <> -20001) THEN
372: IF (SQLCODE = -54) THEN
373: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
374: ELSE
375: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
376: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
377: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
378: END IF;
379: END IF;
372: IF (SQLCODE = -54) THEN
373: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
374: ELSE
375: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
376: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
377: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
378: END IF;
379: END IF;
380: APP_EXCEPTION.RAISE_EXCEPTION;
373: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
374: ELSE
375: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
376: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
377: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
378: END IF;
379: END IF;
380: APP_EXCEPTION.RAISE_EXCEPTION;
381: