58:
59: CLOSE chk_duplicates;
60:
61: EXCEPTION
62: WHEN app_exceptions.application_exception THEN
63: RAISE;
64: WHEN OTHERS THEN
65: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
66: fnd_message.set_token('PROCEDURE',
91: return(FALSE);
92: END IF;
93:
94: EXCEPTION
95: WHEN app_exceptions.application_exception THEN
96: RAISE;
97: WHEN OTHERS THEN
98: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
99: fnd_message.set_token('PROCEDURE',
119: return(FALSE);
120: END IF;
121:
122: EXCEPTION
123: WHEN app_exceptions.application_exception THEN
124: RAISE;
125: WHEN OTHERS THEN
126: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
127: fnd_message.set_token('PROCEDURE',
148: app_exception.raise_exception;
149: END IF;
150:
151: EXCEPTION
152: WHEN app_exceptions.application_exception THEN
153: RAISE;
154: WHEN OTHERS THEN
155: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
156: fnd_message.set_token('PROCEDURE',
177: END IF;
178:
179: CLOSE lock_org;
180: EXCEPTION
181: WHEN app_exceptions.application_exception THEN
182: RAISE;
183: WHEN OTHERS THEN
184: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
185: fnd_message.set_token('PROCEDURE',
221: x_budget_version_id,
222: x_budget_name,
223: x_bj_required);
224: EXCEPTION
225: WHEN app_exceptions.application_exception THEN
226: RAISE;
227: WHEN OTHERS THEN
228: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
229: fnd_message.set_token('PROCEDURE',
459: end if;
460: CLOSE C;
461:
462: EXCEPTION
463: WHEN app_exceptions.application_exception THEN
464: RAISE;
465: WHEN OTHERS THEN
466: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
467: fnd_message.set_token('PROCEDURE',
601: if (SQL%NOTFOUND) then
602: Raise NO_DATA_FOUND;
603: end if;
604: EXCEPTION
605: WHEN app_exceptions.application_exception THEN
606: RAISE;
607: WHEN OTHERS THEN
608: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
609: fnd_message.set_token('PROCEDURE',
1071: L_All_Org,
1072: L_Coa_Id,
1073: 'N');
1074: EXCEPTION
1075: WHEN app_exceptions.application_exception THEN
1076: RAISE;
1077: WHEN OTHERS THEN
1078: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1079: fnd_message.set_token('PROCEDURE',
1147: L_User_Id,
1148: L_Login_Id);
1149:
1150: EXCEPTION
1151: WHEN app_exceptions.application_exception THEN
1152: RAISE;
1153: WHEN OTHERS THEN
1154: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1155: fnd_message.set_token('PROCEDURE',