124:
125: EXCEPTION
126:
127: WHEN OTHERS THEN
128: po_message_s.sql_error('val_open_period', x_progress, sqlcode);
129: RAISE;
130:
131: END val_open_period;
132:
157: RETURN(x_app_id);
158:
159: EXCEPTION
160: WHEN OTHERS THEN
161: po_message_s.sql_error('get_app_id', x_progress, sqlcode);
162: RAISE;
163:
164: END get_app_id;
165: /*===========================================================================
197: RETURN(x_closing_status);
198:
199: EXCEPTION
200: WHEN NO_DATA_FOUND then
201: po_message_s.app_error('PO_PO_ENTER_OPEN_GL_DATE');
202: RAISE;
203: WHEN TOO_MANY_ROWS then
204: po_message_s.app_error(''); --bad data in gl_period_statuses
205: RAISE;
200: WHEN NO_DATA_FOUND then
201: po_message_s.app_error('PO_PO_ENTER_OPEN_GL_DATE');
202: RAISE;
203: WHEN TOO_MANY_ROWS then
204: po_message_s.app_error(''); --bad data in gl_period_statuses
205: RAISE;
206: WHEN OTHERS THEN
207: po_message_s.sql_error('get_closing_status', x_progress, sqlcode);
208: RAISE;
203: WHEN TOO_MANY_ROWS then
204: po_message_s.app_error(''); --bad data in gl_period_statuses
205: RAISE;
206: WHEN OTHERS THEN
207: po_message_s.sql_error('get_closing_status', x_progress, sqlcode);
208: RAISE;
209:
210: END get_closing_status;
211:
267: RETURN(x_closing_status);
268:
269: EXCEPTION
270: WHEN NO_DATA_FOUND then
271: po_message_s.app_error('PO_INV_NO_OPEN_PERIOD');
272: RAISE;
273: WHEN TOO_MANY_ROWS then
274: po_message_s.app_error('PO_INV_MUL_PERIODS');
275: RAISE;
270: WHEN NO_DATA_FOUND then
271: po_message_s.app_error('PO_INV_NO_OPEN_PERIOD');
272: RAISE;
273: WHEN TOO_MANY_ROWS then
274: po_message_s.app_error('PO_INV_MUL_PERIODS');
275: RAISE;
276: WHEN OTHERS THEN
277: po_message_s.sql_error('get_acct_period_status', x_progress, sqlcode);
278: RAISE;
273: WHEN TOO_MANY_ROWS then
274: po_message_s.app_error('PO_INV_MUL_PERIODS');
275: RAISE;
276: WHEN OTHERS THEN
277: po_message_s.sql_error('get_acct_period_status', x_progress, sqlcode);
278: RAISE;
279:
280: END get_acct_period_status;
281: