48:
49: COMMIT;
50: EXCEPTION
51: WHEN OTHERS THEN
52: fnd_message.set_name ('GME', 'GME_UNEXPECTED_ERROR');
53: fnd_message.set_token ('ERROR', SQLERRM);
54: x_return_code := 'F';
55: x_error_msg := fnd_message.get;
56: END insert_row;
49: COMMIT;
50: EXCEPTION
51: WHEN OTHERS THEN
52: fnd_message.set_name ('GME', 'GME_UNEXPECTED_ERROR');
53: fnd_message.set_token ('ERROR', SQLERRM);
54: x_return_code := 'F';
55: x_error_msg := fnd_message.get;
56: END insert_row;
57:
51: WHEN OTHERS THEN
52: fnd_message.set_name ('GME', 'GME_UNEXPECTED_ERROR');
53: fnd_message.set_token ('ERROR', SQLERRM);
54: x_return_code := 'F';
55: x_error_msg := fnd_message.get;
56: END insert_row;
57:
58: /**
59: * Update a row into the Document Filter table.
109:
110: COMMIT WORK;
111: EXCEPTION
112: WHEN OTHERS THEN
113: fnd_message.set_name ('GME', 'GME_UNEXPECTED_ERROR');
114: fnd_message.set_token ('ERROR', SQLERRM);
115: x_return_code := 'F';
116: x_error_msg := fnd_message.get;
117: END update_row;
110: COMMIT WORK;
111: EXCEPTION
112: WHEN OTHERS THEN
113: fnd_message.set_name ('GME', 'GME_UNEXPECTED_ERROR');
114: fnd_message.set_token ('ERROR', SQLERRM);
115: x_return_code := 'F';
116: x_error_msg := fnd_message.get;
117: END update_row;
118:
112: WHEN OTHERS THEN
113: fnd_message.set_name ('GME', 'GME_UNEXPECTED_ERROR');
114: fnd_message.set_token ('ERROR', SQLERRM);
115: x_return_code := 'F';
116: x_error_msg := fnd_message.get;
117: END update_row;
118:
119: /**
120: * Select a row from the Document Filter table.
143: EXCEPTION
144: WHEN NO_DATA_FOUND THEN
145: NULL;
146: WHEN OTHERS THEN
147: fnd_message.set_name ('GME', 'GME_UNEXPECTED_ERROR');
148: fnd_message.set_token ('ERROR', SQLERRM);
149: x_return_code := 'F';
150: x_error_msg := fnd_message.get;
151: END select_row;
144: WHEN NO_DATA_FOUND THEN
145: NULL;
146: WHEN OTHERS THEN
147: fnd_message.set_name ('GME', 'GME_UNEXPECTED_ERROR');
148: fnd_message.set_token ('ERROR', SQLERRM);
149: x_return_code := 'F';
150: x_error_msg := fnd_message.get;
151: END select_row;
152: END;
146: WHEN OTHERS THEN
147: fnd_message.set_name ('GME', 'GME_UNEXPECTED_ERROR');
148: fnd_message.set_token ('ERROR', SQLERRM);
149: x_return_code := 'F';
150: x_error_msg := fnd_message.get;
151: END select_row;
152: END;