153:
154: EXCEPTION
155: WHEN OTHERS THEN
156: IF (SQLCODE <> -20001) THEN
157: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
158: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
159: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
160: END IF;
161: APP_EXCEPTION.RAISE_EXCEPTION;
154: EXCEPTION
155: WHEN OTHERS THEN
156: IF (SQLCODE <> -20001) THEN
157: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
158: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
159: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
160: END IF;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162:
155: WHEN OTHERS THEN
156: IF (SQLCODE <> -20001) THEN
157: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
158: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
159: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
160: END IF;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162:
163: END insert_row;
259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: IF (SQLCODE <> -20001) THEN
263: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
264: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
265: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
266: END IF;
267: APP_EXCEPTION.RAISE_EXCEPTION;
260: EXCEPTION
261: WHEN OTHERS THEN
262: IF (SQLCODE <> -20001) THEN
263: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
264: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
265: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
266: END IF;
267: APP_EXCEPTION.RAISE_EXCEPTION;
268:
261: WHEN OTHERS THEN
262: IF (SQLCODE <> -20001) THEN
263: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
264: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
265: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
266: END IF;
267: APP_EXCEPTION.RAISE_EXCEPTION;
268:
269: END update_row;
497: (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)))
498: THEN
499: NULL;
500: ELSE
501: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
502: APP_EXCEPTION.RAISE_EXCEPTION;
503: END IF;
504:
505: EXCEPTION
505: EXCEPTION
506: WHEN OTHERS THEN
507: IF (SQLCODE <> -20001) THEN
508: IF (SQLCODE = -54) THEN
509: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
510: ELSE
511: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
512: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
507: IF (SQLCODE <> -20001) THEN
508: IF (SQLCODE = -54) THEN
509: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
510: ELSE
511: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
512: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
514: END IF;
515: END IF;
508: IF (SQLCODE = -54) THEN
509: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
510: ELSE
511: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
512: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
514: END IF;
515: END IF;
516: APP_EXCEPTION.RAISE_EXCEPTION;
509: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
510: ELSE
511: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
512: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
513: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
514: END IF;
515: END IF;
516: APP_EXCEPTION.RAISE_EXCEPTION;
517: