137: NULL;
138:
139: WHEN OTHERS THEN
140: IF (SQLCODE <> -20001) THEN
141: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
142: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
144: END IF;
145: APP_EXCEPTION.RAISE_EXCEPTION;
138:
139: WHEN OTHERS THEN
140: IF (SQLCODE <> -20001) THEN
141: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
142: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
144: END IF;
145: APP_EXCEPTION.RAISE_EXCEPTION;
146:
139: WHEN OTHERS THEN
140: IF (SQLCODE <> -20001) THEN
141: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
142: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
144: END IF;
145: APP_EXCEPTION.RAISE_EXCEPTION;
146:
147: END insert_row;
234: NULL;
235:
236: WHEN OTHERS THEN
237: IF (SQLCODE <> -20001) THEN
238: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
239: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
241: END IF;
242: APP_EXCEPTION.RAISE_EXCEPTION;
235:
236: WHEN OTHERS THEN
237: IF (SQLCODE <> -20001) THEN
238: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
239: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
241: END IF;
242: APP_EXCEPTION.RAISE_EXCEPTION;
243:
236: WHEN OTHERS THEN
237: IF (SQLCODE <> -20001) THEN
238: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
239: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
240: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
241: END IF;
242: APP_EXCEPTION.RAISE_EXCEPTION;
243:
244: END update_row;
263: NULL;
264:
265: WHEN OTHERS THEN
266: IF (SQLCODE <> -20001) THEN
267: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
268: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
270: END IF;
271: APP_EXCEPTION.RAISE_EXCEPTION;
264:
265: WHEN OTHERS THEN
266: IF (SQLCODE <> -20001) THEN
267: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
268: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
270: END IF;
271: APP_EXCEPTION.RAISE_EXCEPTION;
272:
265: WHEN OTHERS THEN
266: IF (SQLCODE <> -20001) THEN
267: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
268: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
270: END IF;
271: APP_EXCEPTION.RAISE_EXCEPTION;
272:
273:
442: (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)))
443: THEN
444: NULL;
445: ELSE
446: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
447: APP_EXCEPTION.RAISE_EXCEPTION;
448: END IF;
449:
450: EXCEPTION
453:
454: WHEN OTHERS THEN
455: IF (SQLCODE <> -20001) THEN
456: IF (SQLCODE = -54) THEN
457: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
458: ELSE
459: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
460: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
461: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
455: IF (SQLCODE <> -20001) THEN
456: IF (SQLCODE = -54) THEN
457: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
458: ELSE
459: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
460: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
461: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
462: END IF;
463: END IF;
456: IF (SQLCODE = -54) THEN
457: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
458: ELSE
459: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
460: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
461: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
462: END IF;
463: END IF;
464: APP_EXCEPTION.RAISE_EXCEPTION;
457: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
458: ELSE
459: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
460: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
461: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
462: END IF;
463: END IF;
464: APP_EXCEPTION.RAISE_EXCEPTION;
465: