90: X_allow_delete := TRUE;
91: dbms_output.put_line('Delete permitted');
92: ELSE
93: X_allow_delete := FALSE;
94: po_message_s.app_error('PO_DELETE_QT_ON_REQ');
95: /* DEBUG: this message needs to be added to the message dictionary */
96: END IF;
97:
98: ELSE
96: END IF;
97:
98: ELSE
99: X_allow_delete := FALSE;
100: po_message_s.app_error('PO_QT_DELETE_SOURCE');
101: END IF;
102:
103: ELSE
104: X_allow_delete := FALSE;
101: END IF;
102:
103: ELSE
104: X_allow_delete := FALSE;
105: po_message_s.app_error('PO_DELETE_QT_ON_PO_NA');
106: /* DEBUG: this message needs to be added to the message dictionary */
107: END IF;
108:
109: EXCEPTION
108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: dbms_output.put_line('In VAL exception');
112: po_message_s.sql_error('val_header_delete', x_progress, sqlcode);
113:
114: END val_header_delete;
115:
116: /*===========================================================================
225: X_allow_delete := 'Y';
226: dbms_output.put_line('Allow delete = '||X_allow_delete);
227: ELSE
228: X_allow_delete := 'N';
229: po_message_s.app_error('PO_DELETE_REQS');
230: dbms_output.put_line('Allow delete = '||X_allow_delete);
231: END IF;
232:
233: ELSE
231: END IF;
232:
233: ELSE
234: X_allow_delete := 'N';
235: po_message_s.app_error('PO_QT_LINE_DELETE_SOURCE');
236: dbms_output.put_line('Allow delete = '||X_allow_delete);
237: END IF;
238:
239: ELSE
237: END IF;
238:
239: ELSE
240: X_allow_delete := 'N';
241: po_message_s.app_error('PO_QT_LINE_DELETE_NA');
242: dbms_output.put_line('Allow delete = '||X_allow_delete);
243: END IF;
244:
245: /*
250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: dbms_output.put_line('In VAL exception');
254: po_message_s.sql_error('val_line_delete', x_progress, sqlcode);
255:
256: END val_line_delete;
257:
258: /*===========================================================================
317:
318: EXCEPTION
319: WHEN OTHERS THEN
320: dbms_output.put_line('In exception');
321: po_message_s.sql_error('val_reply', x_progress, sqlcode);
322:
323: END val_reply;
324:
325: /*===========================================================================
393:
394: EXCEPTION
395: WHEN OTHERS THEN
396: dbms_output.put_line('In exception');
397: po_message_s.sql_error('get_quote_status', x_progress, sqlcode);
398:
399: END get_quote_status;
400:
401: /*===========================================================================
458: WHERE poh.po_header_id = X_from_header_id;
459:
460: ELSE
461: x_progress := '030';
462: po_message_s.sql_error('from_header_id is null', x_progress, sqlcode);
463:
464: END IF;
465:
466: dbms_output.put_line('RFQ Close Date = '||X_rfq_close_date);
469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: dbms_output.put_line('In exception');
473: po_message_s.sql_error('get_from_rfq_defaults', x_progress, sqlcode);
474:
475: END get_from_rfq_defaults;
476:
477: /*===========================================================================
505:
506: EXCEPTION
507: WHEN OTHERS THEN
508: dbms_output.put_line('In exception');
509: po_message_s.sql_error('get_approval_status', x_progress, sqlcode);
510:
511: END get_approval_status;
512:
513: