170: --dbms_output.put_line('No data found');
171: X_unapprove_doc := FALSE;
172: return(X_unapprove_doc);
173: when others then
174: po_message_s.sql_error('val_approval_status', x_progress, sqlcode);
175: raise;
176:
177: END val_approval_status;
178:
191:
192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: po_message_s.sql_error('update_children', x_progress, sqlcode);
196: RAISE;
197:
198: END update_children; */
199:
249: return(X_success);
250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: po_message_s.sql_error('val_release_date', X_progress, sqlcode);
254: RAISE;
255:
256: END val_release_date;
257:
292:
293: X_progress := '040';
294:
295: X_valid_date := FALSE;
296: /* po_message_s.app_error('PO_PO_START_DATE_LT_REL_DATE'); bug # 6363130 */
297: return(X_valid_date);
298:
299: EXCEPTION
300:
298:
299: EXCEPTION
300:
301: when others then
302: po_message_s.sql_error('val_start_date',X_progress,sqlcode);
303: raise;
304:
305: END val_start_date;
306:
348:
349: X_progress := '040';
350:
351: X_valid_date := FALSE;
352: po_message_s.app_error('PO_PO_END_DATE_GT_RELEASE_DATE');
353: return(X_valid_date);
354:
355: EXCEPTION
356: when others then
353: return(X_valid_date);
354:
355: EXCEPTION
356: when others then
357: po_message_s.sql_error('val_end_date', x_progress, sqlcode);
358: raise;
359:
360: END val_end_date;
361:
397: null;
398:
399:
400: when others then
401: po_message_s.sql_error('update_req_link', X_progress, sqlcode);
402: raise;
403:
404: END update_req_link;
405:
456: --dbms_output.put_line('Ship_to_location'||X_ship_to_location_id);
457:
458: else
459: X_progress := '030';
460: po_message_s.sql_error('no header id', X_progress, sqlcode);
461:
462: end if;
463:
464:
463:
464:
465: EXCEPTION
466: when others then
467: po_message_s.sql_error('get_po_details', x_progress, sqlcode);
468: raise;
469:
470: END get_po_details;
471:
483:
484:
485: EXCEPTION
486: WHEN OTHERS THEN
487: po_message_s.sql_error('get_segment1_details', x_progress, sqlcode);
488: RAISE;
489:
490: END get_segment1_details; */
491:
554: END IF;
555:
556: exception
557: when others then
558: po_message_s.sql_error('get_document_status', X_progress, sqlcode);
559: raise;
560:
561: end get_document_status;
562: