DBA Data[Home] [Help]

APPS.PO_HEADERS_SV9 dependencies on PO_INTERFACE_ERRORS_SV1

Line 35: po_interface_errors_sv1.handle_interface_errors(

31: BEGIN
32: X_progress := '010';
33: /* make sure that start_date is specified */
34: IF (X_start_date is null) THEN
35: po_interface_errors_sv1.handle_interface_errors(
36: 'PO_DOCS_OPEN_INTERFACE',
37: 'FATAL',
38: null,
39: X_interface_header_id,

Line 53: po_interface_errors_sv1.handle_interface_errors(

49: END IF;
50: /* make sure that the start_date < end_date */
51: -- Bug 2449186. Truncate dates when comparing them.
52: IF (TRUNC(X_start_date) > TRUNC(nvl(X_end_date, X_start_date))) THEN
53: po_interface_errors_sv1.handle_interface_errors(
54: 'PO_DOCS_OPEN_INTERFACE',
55: 'FATAL',
56: null,
57: X_interface_header_id,

Line 146: po_interface_errors_sv1.handle_interface_errors(

142: /* can not find the original catalog */
143: /* call the error handling routine with the error code =
144: 'PDOI_INVALID_ORIGINAL_CATALOG' */
145: X_progress := '030';
146: po_interface_errors_sv1.handle_interface_errors(
147: 'PO_DOCS_OPEN_INTERFACE',
148: 'FATAL',
149: null,
150: X_interface_header_id,

Line 163: po_interface_errors_sv1.handle_interface_errors(

159: X_header_processable_flag);
160: ELSIF x_temp > 1 THEN
161: /* if returns more than 1 row, it is an error */
162: X_progress := '040';
163: po_interface_errors_sv1.handle_interface_errors(
164: 'PO_DOCS_OPEN_INTERFACE',
165: 'FATAL',
166: null,
167: X_interface_header_id,

Line 216: po_interface_errors_sv1.handle_interface_errors(

212: END;
213:
214: IF l_rel_exists = 'Y' THEN
215:
216: po_interface_errors_sv1.handle_interface_errors(
217: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
218: x_error_type => 'FATAL',
219: x_batch_id => null,
220: x_interface_header_id => X_interface_header_id,

Line 250: po_interface_errors_sv1.handle_interface_errors(

246: AND ph.po_header_id = pl.po_header_id
247: AND ph.creation_date >= X_start_date;
248:
249: IF l_po_exists_num > 0 THEN
250: po_interface_errors_sv1.handle_interface_errors(
251: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
252: x_error_type => 'FATAL',
253: x_batch_id => null,
254: x_interface_header_id => X_interface_header_id,

Line 319: po_interface_errors_sv1.handle_interface_errors(

315: END;
316:
317: IF l_rel_exists = 'Y' THEN
318:
319: po_interface_errors_sv1.handle_interface_errors(
320: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
321: x_error_type => 'FATAL',
322: x_batch_id => null,
323: x_interface_header_id => X_interface_header_id,

Line 353: po_interface_errors_sv1.handle_interface_errors(

349: ph.po_header_id = pl.po_header_id AND
350: ph.creation_date >= X_start_date;
351:
352: IF l_po_exists_num > 0 THEN
353: po_interface_errors_sv1.handle_interface_errors(
354: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
355: x_error_type => 'FATAL',
356: x_batch_id => null,
357: x_interface_header_id => X_interface_header_id,

Line 592: po_interface_errors_sv1.handle_interface_errors(

588: --
589: -- Added the following 'if/else' statement for standard purchase orders.
590:
591: IF (x_document_type_code <> 'STANDARD') THEN
592: po_interface_errors_sv1.handle_interface_errors(
593: 'PO_DOCS_OPEN_INTERFACE',
594: 'FATAL',
595: null,
596: X_interface_header_id,

Line 610: po_interface_errors_sv1.handle_interface_errors(

606: else
607: --
608: -- Added the below procedure to populate the error message incase
609: -- of standard PO.
610: po_interface_errors_sv1.handle_interface_errors(
611: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
612: x_error_type => 'FATAL',
613: x_batch_id => null,
614: x_interface_header_id => X_interface_header_id,

Line 645: po_interface_errors_sv1.handle_interface_errors(

641: --
642: -- Added the following 'if/else' for standard purchase orders.
643:
644: IF (x_document_type_code <> 'STANDARD') THEN
645: po_interface_errors_sv1.handle_interface_errors(
646: 'PO_DOCS_OPEN_INTERFACE',
647: 'FATAL',
648: null,
649: X_interface_header_id,

Line 663: po_interface_errors_sv1.handle_interface_errors(

659: ELSE
660: --
661: -- Added the below procedure to populate error message is case of standard
662: -- purchase orders.
663: po_interface_errors_sv1.handle_interface_errors(
664: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
665: x_error_type => 'FATAL',
666: x_batch_id => null,
667: x_interface_header_id => X_interface_header_id,

Line 769: po_interface_errors_sv1.handle_interface_errors(

765: PO_DEBUG.put_line ('x_consigned_consumption_flag is
766: '|| x_consigned_consumption_flag);
767: end if;
768:
769: po_interface_errors_sv1.handle_interface_errors(
770: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
771: x_error_type => 'FATAL',
772: x_batch_id => null,
773: x_interface_header_id => X_interface_header_id,

Line 887: po_interface_errors_sv1.handle_interface_errors(

883:
884: ELSE
885: /* if returns 1 or more than one row, it is an error */
886: X_progress := '020';
887: po_interface_errors_sv1.handle_interface_errors(
888: 'PO_DOCS_OPEN_INTERFACE',
889: 'FATAL',
890: null,
891: X_interface_header_id,