DBA Data[Home] [Help]

APPS.PO_RFQ_VENDOR_SV dependencies on DBMS_OUTPUT

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

13:
14: X_sequence_num NUMBER := '';
15:
16: BEGIN
17: dbms_output.put_line('before call');
18:
19: po_rfq_vendor_sv.get_sequence_num(X_po_header_id,
20: X_sequence_num);
21:

Line 22: dbms_output.put_line('The next sequence number is = '||X_sequence_num);

18:
19: po_rfq_vendor_sv.get_sequence_num(X_po_header_id,
20: X_sequence_num);
21:
22: dbms_output.put_line('The next sequence number is = '||X_sequence_num);
23:
24: END test_get_sequence_num;
25:
26:

Line 46: dbms_output.put_line('Before_open_cursor');

42: WHERE po_header_id = X_po_header_id;
43:
44: BEGIN
45:
46: dbms_output.put_line('Before_open_cursor');
47:
48: IF (X_po_header_id is not null) THEN
49: x_progress := '010';
50: OPEN C;

Line 68: dbms_output.put_line('Next sequence number is: '||X_sequence_num);

64: IF (X_sequence_num is NULL) THEN
65: X_sequence_num := 1;
66: END IF;
67:
68: dbms_output.put_line('Next sequence number is: '||X_sequence_num);
69:
70: ELSE
71: x_progress := '030';
72: po_message_s.sql_error('no po_header_id', x_progress, sqlcode);

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

90: X_seq_num_is_unique VARCHAR2(1) := '';
91:
92: BEGIN
93:
94: dbms_output.put_line('before call');
95:
96: po_rfq_vendor_sv.val_seq_num_unique(X_po_header_id, X_sequence_num,
97: X_seq_num_is_unique);
98:

Line 99: dbms_output.put_line('after call');

95:
96: po_rfq_vendor_sv.val_seq_num_unique(X_po_header_id, X_sequence_num,
97: X_seq_num_is_unique);
98:
99: dbms_output.put_line('after call');
100: dbms_output.put_line('Sequence unique = '||X_seq_num_is_unique);
101:
102: END test_val_seq_num_unique;
103:

Line 100: dbms_output.put_line('Sequence unique = '||X_seq_num_is_unique);

96: po_rfq_vendor_sv.val_seq_num_unique(X_po_header_id, X_sequence_num,
97: X_seq_num_is_unique);
98:
99: dbms_output.put_line('after call');
100: dbms_output.put_line('Sequence unique = '||X_seq_num_is_unique);
101:
102: END test_val_seq_num_unique;
103:
104:

Line 137: dbms_output.put_line('Sequence is unique = '||X_seq_num_is_unique);

133: IF (X_seq_num_is_unique is NULL) THEN
134: X_seq_num_is_unique := 'Y';
135: END IF;
136:
137: dbms_output.put_line('Sequence is unique = '||X_seq_num_is_unique);
138:
139: EXCEPTION
140: WHEN OTHERS THEN
141: po_message_s.sql_error('val_seq_num_unique', x_progress, sqlcode);