91: AND (X_Je_Batch_Name IS NULL)))
92: ) then
93: return;
94: else
95: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
96: APP_EXCEPTION.RAISE_EXCEPTION;
97: end if;
98: END Lock_Budget_Transfer_Row;
99:
115: CLOSE get_new_id;
116: return(new_id);
117: ELSE
118: CLOSE get_new_id;
119: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
120: fnd_message.set_token('SEQUENCE', 'GL_BC_PACKETS_S');
121: app_exception.raise_exception;
122: END IF;
123:
116: return(new_id);
117: ELSE
118: CLOSE get_new_id;
119: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
120: fnd_message.set_token('SEQUENCE', 'GL_BC_PACKETS_S');
121: app_exception.raise_exception;
122: END IF;
123:
124: EXCEPTION
124: EXCEPTION
125: WHEN app_exceptions.application_exception THEN
126: RAISE;
127: WHEN OTHERS THEN
128: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
129: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.get_unique_id');
130: RAISE;
131: END get_unique_id;
132:
125: WHEN app_exceptions.application_exception THEN
126: RAISE;
127: WHEN OTHERS THEN
128: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
129: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.get_unique_id');
130: RAISE;
131: END get_unique_id;
132:
133: FUNCTION insert_je_packet(batch_id NUMBER,
183: EXCEPTION
184: WHEN app_exceptions.application_exception THEN
185: RAISE;
186: WHEN OTHERS THEN
187: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
188: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.insert_je_packet');
189: RAISE;
190: END insert_je_packet;
191:
184: WHEN app_exceptions.application_exception THEN
185: RAISE;
186: WHEN OTHERS THEN
187: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
188: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.insert_je_packet');
189: RAISE;
190: END insert_je_packet;
191:
192: FUNCTION exists_packet(xpacket_id NUMBER) RETURN BOOLEAN IS
212: EXCEPTION
213: WHEN app_exceptions.application_exception THEN
214: RAISE;
215: WHEN OTHERS THEN
216: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
217: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.exists_packet');
218: RAISE;
219: END exists_packet;
220:
213: WHEN app_exceptions.application_exception THEN
214: RAISE;
215: WHEN OTHERS THEN
216: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
217: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.exists_packet');
218: RAISE;
219: END exists_packet;
220:
221: FUNCTION get_ledger_id(xpacket_id NUMBER) RETURN NUMBER IS
239: EXCEPTION
240: WHEN app_exceptions.application_exception THEN
241: RAISE;
242: WHEN OTHERS THEN
243: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
244: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.get_ledger_id');
245: RAISE;
246: END get_ledger_id;
247:
240: WHEN app_exceptions.application_exception THEN
241: RAISE;
242: WHEN OTHERS THEN
243: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
244: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.get_ledger_id');
245: RAISE;
246: END get_ledger_id;
247:
248: PROCEDURE Insert_Budget_Transfer_Row(
619: EXCEPTION
620: WHEN app_exceptions.application_exception THEN
621: RAISE;
622: WHEN OTHERS THEN
623: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
624: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.copy_packet');
625: RAISE;
626: END copy_packet;
627:
620: WHEN app_exceptions.application_exception THEN
621: RAISE;
622: WHEN OTHERS THEN
623: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
624: fnd_message.set_token('PROCEDURE', 'gl_bc_packets_pkg.copy_packet');
625: RAISE;
626: END copy_packet;
627:
628: FUNCTION view_bc_results_setup(packet_id NUMBER,