63:
64: IF check_dups%FOUND THEN
65: CLOSE check_dups;
66: fnd_message.set_name('SQLGL', 'GL_DUP_USER_CONVERSION_TYPE');
67: app_exception.raise_exception;
68: END IF;
69:
70: CLOSE check_dups;
71: EXCEPTION
68: END IF;
69:
70: CLOSE check_dups;
71: EXCEPTION
72: WHEN app_exception.application_exception THEN RAISE;
73: WHEN OTHERS THEN
74: fnd_message.set_name('SQLGL','Unhandled Exception');
75: fnd_message.set_token('PROCEDURE', 'Check_Unique_User_Type');
76: RAISE;
96: IF chk_dups%FOUND THEN
97: CLOSE chk_dups;
98: fnd_message.set_name('SQLGL', 'GL_DUP_UNIQUE_ID');
99: fnd_message.set_token('TAB_S', 'GL_DAILY_CONVERSION_TYPES_S');
100: app_exception.raise_exception;
101: END IF;
102:
103: CLOSE chk_dups;
104: EXCEPTION
101: END IF;
102:
103: CLOSE chk_dups;
104: EXCEPTION
105: WHEN app_exception.application_exception THEN RAISE;
106: WHEN OTHERS THEN
107: fnd_message.set_name('SQLGL','Unhandled Exception');
108: fnd_message.set_token('PROCEDURE', 'Check_Unique_Type');
109: RAISE;
118:
119: IF (next_val is NULL) THEN
120: fnd_message.set_name('SQLGL', 'GL_SEQUENCE_NOT_FOUND');
121: fnd_message.set_token('TAB_S', 'GL_DAILY_CONVERSION_TYPES_S');
122: app_exception.raise_exception;
123: END IF;
124: EXCEPTION
125: WHEN app_exception.application_exception THEN RAISE;
126: WHEN OTHERS THEN
121: fnd_message.set_token('TAB_S', 'GL_DAILY_CONVERSION_TYPES_S');
122: app_exception.raise_exception;
123: END IF;
124: EXCEPTION
125: WHEN app_exception.application_exception THEN RAISE;
126: WHEN OTHERS THEN
127: fnd_message.set_name('SQLGL','Unhandled Exception');
128: fnd_message.set_token('PROCEDURE', 'Get_New_Id');
129: RAISE;
225: end if;
226: CLOSE C;
227:
228: EXCEPTION
229: WHEN app_exceptions.application_exception THEN
230: RAISE;
231: WHEN OTHERS THEN
232: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
233: fnd_message.set_token('PROCEDURE',
289: FETCH C INTO recinfo;
290: IF (C%NOTFOUND) THEN
291: CLOSE C;
292: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
293: app_exception.raise_exception;
294: END IF;
295: CLOSE C;
296:
297: IF (
369: ) THEN
370: return;
371: ELSE
372: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
373: app_exception.raise_exception;
374: END IF;
375:
376: END lock_row;
377:
430: RAISE NO_DATA_FOUND;
431: end if;
432:
433: EXCEPTION
434: WHEN app_exceptions.application_exception THEN
435: RAISE;
436: WHEN OTHERS THEN
437: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
438: fnd_message.set_token('PROCEDURE',
476: -- validate input parameter
477: IF ((V_User_Conversion_Type is NULL) OR
478: (V_Conversion_Type is NULL)) THEN
479: FND_MESSAGE.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');
480: APP_EXCEPTION.raise_exception;
481: END IF;
482:
483: IF (V_Owner = 'SEED') THEN
484: user_id := 1;