77:
78: EXCEPTION
79: WHEN OTHERS THEN
80: IF (SQLCODE <> -20001) THEN
81: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
82: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
83: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
84: END IF;
85: APP_EXCEPTION.RAISE_EXCEPTION;
78: EXCEPTION
79: WHEN OTHERS THEN
80: IF (SQLCODE <> -20001) THEN
81: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
82: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
83: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
84: END IF;
85: APP_EXCEPTION.RAISE_EXCEPTION;
86:
79: WHEN OTHERS THEN
80: IF (SQLCODE <> -20001) THEN
81: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
82: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
83: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
84: END IF;
85: APP_EXCEPTION.RAISE_EXCEPTION;
86:
87: END insert_row;
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: IF (SQLCODE <> -20001) THEN
137: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
138: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
139: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
140: END IF;
141: APP_EXCEPTION.RAISE_EXCEPTION;
134: EXCEPTION
135: WHEN OTHERS THEN
136: IF (SQLCODE <> -20001) THEN
137: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
138: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
139: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
140: END IF;
141: APP_EXCEPTION.RAISE_EXCEPTION;
142:
135: WHEN OTHERS THEN
136: IF (SQLCODE <> -20001) THEN
137: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
138: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
139: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
140: END IF;
141: APP_EXCEPTION.RAISE_EXCEPTION;
142:
143: END update_row;
233: AND ((recinfo.last_update_date = x_last_update_date) OR (recinfo.last_update_date IS NULL AND x_last_update_date IS NULL))
234: AND ((recinfo.last_update_login = x_last_update_login) OR (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)) ) THEN
235: NULL;
236: ELSE
237: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
238: APP_EXCEPTION.RAISE_EXCEPTION;
239: END IF;
240:
241: EXCEPTION
241: EXCEPTION
242: WHEN OTHERS THEN
243: IF (SQLCODE <> -20001) THEN
244: IF (SQLCODE = -54) THEN
245: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
246: ELSE
247: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
248: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
243: IF (SQLCODE <> -20001) THEN
244: IF (SQLCODE = -54) THEN
245: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
246: ELSE
247: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
248: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
250: END IF;
251: END IF;
244: IF (SQLCODE = -54) THEN
245: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
246: ELSE
247: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
248: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
250: END IF;
251: END IF;
252: APP_EXCEPTION.RAISE_EXCEPTION;
245: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
246: ELSE
247: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
248: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
250: END IF;
251: END IF;
252: APP_EXCEPTION.RAISE_EXCEPTION;
253: