eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_QUOTES_SV dependencies on DBMS_OUTPUT

Line 18: dbms_output.put_line('Before_call');

14: X_allow_delete BOOLEAN;
15:
16: BEGIN
17:
18: dbms_output.put_line('Before_call');
19:
20: po_quotes_sv.val_header_delete(X_po_header_id, X_allow_delete);
21:
22: dbms_output.put_line('After call');

Line 22: dbms_output.put_line('After call');

18: dbms_output.put_line('Before_call');
19:
20: po_quotes_sv.val_header_delete(X_po_header_id, X_allow_delete);
21:
22: dbms_output.put_line('After call');
23:
24: if (X_allow_delete) then
25: dbms_output.put_line('Allow Delete = TRUE');
26: else

Line 25: dbms_output.put_line('Allow Delete = TRUE');

21:
22: dbms_output.put_line('After call');
23:
24: if (X_allow_delete) then
25: dbms_output.put_line('Allow Delete = TRUE');
26: else
27: dbms_output.put_line('Allow Delete = FALSE');
28: end if;
29:

Line 27: dbms_output.put_line('Allow Delete = FALSE');

23:
24: if (X_allow_delete) then
25: dbms_output.put_line('Allow Delete = TRUE');
26: else
27: dbms_output.put_line('Allow Delete = FALSE');
28: end if;
29:
30: END test_val_header_delete;
31:

Line 91: dbms_output.put_line('Delete permitted');

87: WHERE prl.blanket_po_header_id = X_po_header_id;
88:
89: IF (nvl(X_delete_test,'Y') = 'Y') THEN
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 */

Line 111: dbms_output.put_line('In VAL exception');

107: END IF;
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:

Line 130: dbms_output.put_line('Before_call');

126: X_allow_delete VARCHAR2(1) := '';
127:
128: BEGIN
129:
130: dbms_output.put_line('Before_call');
131:
132: po_quotes_sv.val_line_delete(X_po_line_id, X_po_line_num, X_po_header_id,
133: X_allow_delete);
134:

Line 135: dbms_output.put_line('After call');

131:
132: po_quotes_sv.val_line_delete(X_po_line_id, X_po_line_num, X_po_header_id,
133: X_allow_delete);
134:
135: dbms_output.put_line('After call');
136: dbms_output.put_line('Allow Delete = '||X_allow_delete);
137:
138: END test_val_line_delete;
139:

Line 136: dbms_output.put_line('Allow Delete = '||X_allow_delete);

132: po_quotes_sv.val_line_delete(X_po_line_id, X_po_line_num, X_po_header_id,
133: X_allow_delete);
134:
135: dbms_output.put_line('After call');
136: dbms_output.put_line('Allow Delete = '||X_allow_delete);
137:
138: END test_val_line_delete;
139:
140: /*===========================================================================

Line 173: dbms_output.put_line('Before open cursors');

169:
170:
171: x_progress := '005';
172:
173: dbms_output.put_line('Before open cursors');
174:
175: /*
176: ** open all cursors
177: */

Line 226: dbms_output.put_line('Allow delete = '||X_allow_delete);

222: */
223:
224: IF C_ON_REQ%NOTFOUND THEN
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);

Line 230: dbms_output.put_line('Allow delete = '||X_allow_delete);

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
234: X_allow_delete := 'N';

Line 236: dbms_output.put_line('Allow delete = '||X_allow_delete);

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
240: X_allow_delete := 'N';

Line 242: dbms_output.put_line('Allow delete = '||X_allow_delete);

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: /*
246: ** close cursors

Line 253: dbms_output.put_line('In VAL exception');

249: CLOSE C_ON_REQ;
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:

Line 271: dbms_output.put_line('Before_call');

267: X_vendor_site_id IN NUMBER) IS
268:
269: BEGIN
270:
271: dbms_output.put_line('Before_call');
272:
273: IF po_quotes_sv.val_reply(X_from_header_id, X_vendor_id, X_vendor_site_id) THEN
274: dbms_output.put_line('Return TRUE');
275: ELSE

Line 274: dbms_output.put_line('Return TRUE');

270:
271: dbms_output.put_line('Before_call');
272:
273: IF po_quotes_sv.val_reply(X_from_header_id, X_vendor_id, X_vendor_site_id) THEN
274: dbms_output.put_line('Return TRUE');
275: ELSE
276: dbms_output.put_line('Return FALSE');
277: END IF;
278:

Line 276: dbms_output.put_line('Return FALSE');

272:
273: IF po_quotes_sv.val_reply(X_from_header_id, X_vendor_id, X_vendor_site_id) THEN
274: dbms_output.put_line('Return TRUE');
275: ELSE
276: dbms_output.put_line('Return FALSE');
277: END IF;
278:
279: END test_val_reply;
280:

Line 320: dbms_output.put_line('In exception');

316: END IF;
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:

Line 338: dbms_output.put_line('Before_call');

334: X_quote_referenced VARCHAR2(1) := '';
335:
336: BEGIN
337:
338: dbms_output.put_line('Before_call');
339:
340: po_quotes_sv.get_quote_status(X_po_header_id, X_quote_referenced);
341:
342: dbms_output.put_line('After call');

Line 342: dbms_output.put_line('After call');

338: dbms_output.put_line('Before_call');
339:
340: po_quotes_sv.get_quote_status(X_po_header_id, X_quote_referenced);
341:
342: dbms_output.put_line('After call');
343: dbms_output.put_line('Quote Referenced? => '||X_quote_referenced);
344:
345: END test_get_quote_status;
346:

Line 343: dbms_output.put_line('Quote Referenced? => '||X_quote_referenced);

339:
340: po_quotes_sv.get_quote_status(X_po_header_id, X_quote_referenced);
341:
342: dbms_output.put_line('After call');
343: dbms_output.put_line('Quote Referenced? => '||X_quote_referenced);
344:
345: END test_get_quote_status;
346:
347: /*===========================================================================

Line 391: dbms_output.put_line('Is Quote Referenced? => '||X_quote_referenced);

387: END IF;
388:
389: END IF;
390:
391: dbms_output.put_line('Is Quote Referenced? => '||X_quote_referenced);
392:
393:
394: EXCEPTION
395: WHEN OTHERS THEN

Line 396: dbms_output.put_line('In exception');

392:
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:

Line 416: dbms_output.put_line('before call');

412: X_approval_required_flag VARCHAR2(1) := '';
413:
414:
415: BEGIN
416: dbms_output.put_line('before call');
417:
418: po_quotes_sv.get_from_rfq_defaults
419: (X_from_header_id,
420: X_rfq_close_date,

Line 424: dbms_output.put_line('RFQ Close Date = '||X_rfq_close_date);

420: X_rfq_close_date,
421: X_from_type_lookup_code,
422: X_approval_required_flag);
423:
424: dbms_output.put_line('RFQ Close Date = '||X_rfq_close_date);
425: dbms_output.put_line('From Type Lookup Code = '||X_from_type_lookup_code);
426: dbms_output.put_line('Acceptance Required = '||X_approval_required_flag);
427:
428: END test_get_from_rfq_defaults;

Line 425: dbms_output.put_line('From Type Lookup Code = '||X_from_type_lookup_code);

421: X_from_type_lookup_code,
422: X_approval_required_flag);
423:
424: dbms_output.put_line('RFQ Close Date = '||X_rfq_close_date);
425: dbms_output.put_line('From Type Lookup Code = '||X_from_type_lookup_code);
426: dbms_output.put_line('Acceptance Required = '||X_approval_required_flag);
427:
428: END test_get_from_rfq_defaults;
429:

Line 426: dbms_output.put_line('Acceptance Required = '||X_approval_required_flag);

422: X_approval_required_flag);
423:
424: dbms_output.put_line('RFQ Close Date = '||X_rfq_close_date);
425: dbms_output.put_line('From Type Lookup Code = '||X_from_type_lookup_code);
426: dbms_output.put_line('Acceptance Required = '||X_approval_required_flag);
427:
428: END test_get_from_rfq_defaults;
429:
430: /*===========================================================================

Line 466: dbms_output.put_line('RFQ Close Date = '||X_rfq_close_date);

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);
467: dbms_output.put_line('From Type Lookup Code = '||X_from_type_lookup_code);
468: dbms_output.put_line('Acceptance Required = '||X_approval_required_flag);
469:
470: EXCEPTION

Line 467: dbms_output.put_line('From Type Lookup Code = '||X_from_type_lookup_code);

463:
464: END IF;
465:
466: dbms_output.put_line('RFQ Close Date = '||X_rfq_close_date);
467: dbms_output.put_line('From Type Lookup Code = '||X_from_type_lookup_code);
468: dbms_output.put_line('Acceptance Required = '||X_approval_required_flag);
469:
470: EXCEPTION
471: WHEN OTHERS THEN

Line 468: dbms_output.put_line('Acceptance Required = '||X_approval_required_flag);

464: END IF;
465:
466: dbms_output.put_line('RFQ Close Date = '||X_rfq_close_date);
467: dbms_output.put_line('From Type Lookup Code = '||X_from_type_lookup_code);
468: dbms_output.put_line('Acceptance Required = '||X_approval_required_flag);
469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: dbms_output.put_line('In exception');

Line 472: dbms_output.put_line('In exception');

468: dbms_output.put_line('Acceptance Required = '||X_approval_required_flag);
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:

Line 508: dbms_output.put_line('In exception');

504: x_progress := '020';
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: