156:
157: EXCEPTION
158: WHEN OTHERS THEN
159: IF (SQLCODE <> -20001) THEN
160: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
161: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
162: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
163: END IF;
164: APP_EXCEPTION.RAISE_EXCEPTION;
157: EXCEPTION
158: WHEN OTHERS THEN
159: IF (SQLCODE <> -20001) THEN
160: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
161: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
162: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
163: END IF;
164: APP_EXCEPTION.RAISE_EXCEPTION;
165:
158: WHEN OTHERS THEN
159: IF (SQLCODE <> -20001) THEN
160: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
161: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
162: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
163: END IF;
164: APP_EXCEPTION.RAISE_EXCEPTION;
165:
166: END insert_row;
265:
266: EXCEPTION
267: WHEN OTHERS THEN
268: IF (SQLCODE <> -20001) THEN
269: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
270: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
271: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
272: END IF;
273: APP_EXCEPTION.RAISE_EXCEPTION;
266: EXCEPTION
267: WHEN OTHERS THEN
268: IF (SQLCODE <> -20001) THEN
269: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
270: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
271: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
272: END IF;
273: APP_EXCEPTION.RAISE_EXCEPTION;
274:
267: WHEN OTHERS THEN
268: IF (SQLCODE <> -20001) THEN
269: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
270: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
271: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
272: END IF;
273: APP_EXCEPTION.RAISE_EXCEPTION;
274:
275: END update_row;
446:
447: AND ((recinfo.last_update_login = x_last_update_login) OR (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)) ) THEN
448: NULL;
449: ELSE
450: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
451: APP_EXCEPTION.RAISE_EXCEPTION;
452: END IF;
453:
454: EXCEPTION
454: EXCEPTION
455: WHEN OTHERS THEN
456: IF (SQLCODE <> -20001) THEN
457: IF (SQLCODE = -54) THEN
458: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
459: ELSE
460: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
461: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
462: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
456: IF (SQLCODE <> -20001) THEN
457: IF (SQLCODE = -54) THEN
458: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
459: ELSE
460: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
461: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
462: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
463: END IF;
464: END IF;
457: IF (SQLCODE = -54) THEN
458: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
459: ELSE
460: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
461: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
462: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
463: END IF;
464: END IF;
465: APP_EXCEPTION.RAISE_EXCEPTION;
458: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
459: ELSE
460: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
461: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
462: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
463: END IF;
464: END IF;
465: APP_EXCEPTION.RAISE_EXCEPTION;
466: