74:
75: EXCEPTION
76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
80: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
81: END IF;
82: APP_EXCEPTION.RAISE_EXCEPTION;
75: EXCEPTION
76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
80: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
81: END IF;
82: APP_EXCEPTION.RAISE_EXCEPTION;
83:
76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
80: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
81: END IF;
82: APP_EXCEPTION.RAISE_EXCEPTION;
83:
84: END insert_row;
128:
129: EXCEPTION
130: WHEN OTHERS THEN
131: IF (SQLCODE <> -20001) THEN
132: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
133: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
135: END IF;
136: APP_EXCEPTION.RAISE_EXCEPTION;
129: EXCEPTION
130: WHEN OTHERS THEN
131: IF (SQLCODE <> -20001) THEN
132: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
133: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
135: END IF;
136: APP_EXCEPTION.RAISE_EXCEPTION;
137:
130: WHEN OTHERS THEN
131: IF (SQLCODE <> -20001) THEN
132: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
133: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
135: END IF;
136: APP_EXCEPTION.RAISE_EXCEPTION;
137:
138: END update_row;
225: AND ((recinfo.last_update_date = x_last_update_date) OR (recinfo.last_update_date IS NULL AND x_last_update_date IS NULL))
226: AND ((recinfo.last_update_login = x_last_update_login) OR (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)) ) THEN
227: NULL;
228: ELSE
229: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
230: APP_EXCEPTION.RAISE_EXCEPTION;
231: END IF;
232:
233: EXCEPTION
233: EXCEPTION
234: WHEN OTHERS THEN
235: IF (SQLCODE <> -20001) THEN
236: IF (SQLCODE = -54) THEN
237: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
238: ELSE
239: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
240: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
241: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
235: IF (SQLCODE <> -20001) THEN
236: IF (SQLCODE = -54) THEN
237: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
238: ELSE
239: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
240: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
241: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
242: END IF;
243: END IF;
236: IF (SQLCODE = -54) THEN
237: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
238: ELSE
239: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
240: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
241: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
242: END IF;
243: END IF;
244: APP_EXCEPTION.RAISE_EXCEPTION;
237: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
238: ELSE
239: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
240: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
241: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
242: END IF;
243: END IF;
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: