248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: IF (SQLCODE <> -20001) THEN
252: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
253: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
254: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
255: END IF;
256: APP_EXCEPTION.RAISE_EXCEPTION;
249: EXCEPTION
250: WHEN OTHERS THEN
251: IF (SQLCODE <> -20001) THEN
252: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
253: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
254: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
255: END IF;
256: APP_EXCEPTION.RAISE_EXCEPTION;
257:
250: WHEN OTHERS THEN
251: IF (SQLCODE <> -20001) THEN
252: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
253: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
254: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
255: END IF;
256: APP_EXCEPTION.RAISE_EXCEPTION;
257:
258: END insert_row;
418:
419: EXCEPTION
420: WHEN OTHERS THEN
421: IF (SQLCODE <> -20001) THEN
422: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
424: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
425: END IF;
426: APP_EXCEPTION.RAISE_EXCEPTION;
419: EXCEPTION
420: WHEN OTHERS THEN
421: IF (SQLCODE <> -20001) THEN
422: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
424: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
425: END IF;
426: APP_EXCEPTION.RAISE_EXCEPTION;
427:
420: WHEN OTHERS THEN
421: IF (SQLCODE <> -20001) THEN
422: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
423: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
424: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
425: END IF;
426: APP_EXCEPTION.RAISE_EXCEPTION;
427:
428: END update_row;
689: AND ((recinfo.last_update_date = x_last_update_date) OR (recinfo.last_update_date IS NULL AND x_last_update_date IS NULL))
690: AND ((recinfo.last_update_login = x_last_update_login) OR (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)) ) THEN
691: NULL;
692: ELSE
693: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
694: APP_EXCEPTION.RAISE_EXCEPTION;
695: END IF;
696:
697: EXCEPTION
697: EXCEPTION
698: WHEN OTHERS THEN
699: IF (SQLCODE <> -20001) THEN
700: IF (SQLCODE = -54) THEN
701: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
702: ELSE
703: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
704: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
705: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
699: IF (SQLCODE <> -20001) THEN
700: IF (SQLCODE = -54) THEN
701: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
702: ELSE
703: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
704: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
705: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
706: END IF;
707: END IF;
700: IF (SQLCODE = -54) THEN
701: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
702: ELSE
703: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
704: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
705: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
706: END IF;
707: END IF;
708: APP_EXCEPTION.RAISE_EXCEPTION;
701: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
702: ELSE
703: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
704: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
705: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
706: END IF;
707: END IF;
708: APP_EXCEPTION.RAISE_EXCEPTION;
709: