90:
91: EXCEPTION
92: WHEN OTHERS THEN
93: IF (SQLCODE <> -20001) THEN
94: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
95: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
96: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
97: END IF;
98: APP_EXCEPTION.RAISE_EXCEPTION;
91: EXCEPTION
92: WHEN OTHERS THEN
93: IF (SQLCODE <> -20001) THEN
94: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
95: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
96: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
97: END IF;
98: APP_EXCEPTION.RAISE_EXCEPTION;
99:
92: WHEN OTHERS THEN
93: IF (SQLCODE <> -20001) THEN
94: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
95: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
96: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
97: END IF;
98: APP_EXCEPTION.RAISE_EXCEPTION;
99:
100: END insert_row;
154:
155: EXCEPTION
156: WHEN OTHERS THEN
157: IF (SQLCODE <> -20001) THEN
158: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
159: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
161: END IF;
162: APP_EXCEPTION.RAISE_EXCEPTION;
155: EXCEPTION
156: WHEN OTHERS THEN
157: IF (SQLCODE <> -20001) THEN
158: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
159: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
161: END IF;
162: APP_EXCEPTION.RAISE_EXCEPTION;
163:
156: WHEN OTHERS THEN
157: IF (SQLCODE <> -20001) THEN
158: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
159: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
161: END IF;
162: APP_EXCEPTION.RAISE_EXCEPTION;
163:
164: END update_row;
290: (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)))
291: THEN
292: NULL;
293: ELSE
294: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
295: APP_EXCEPTION.RAISE_EXCEPTION;
296: END IF;
297:
298: EXCEPTION
298: EXCEPTION
299: WHEN OTHERS THEN
300: IF (SQLCODE <> -20001) THEN
301: IF (SQLCODE = -54) THEN
302: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
303: ELSE
304: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
305: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
306: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
300: IF (SQLCODE <> -20001) THEN
301: IF (SQLCODE = -54) THEN
302: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
303: ELSE
304: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
305: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
306: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
307: END IF;
308: END IF;
301: IF (SQLCODE = -54) THEN
302: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
303: ELSE
304: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
305: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
306: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
307: END IF;
308: END IF;
309: APP_EXCEPTION.RAISE_EXCEPTION;
302: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
303: ELSE
304: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
305: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
306: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
307: END IF;
308: END IF;
309: APP_EXCEPTION.RAISE_EXCEPTION;
310: