DBA Data[Home] [Help]

APPS.PO_PDOI_PREPROC_PVT dependencies on PO_PDOI_ERR_UTL

Line 737: PO_PDOI_ERR_UTL.add_fatal_error

733: l_message_name := 'PO_PDOI_INVALID_ACTION';
734: END IF;
735:
736: d_position := 20;
737: PO_PDOI_ERR_UTL.add_fatal_error
738: ( p_interface_header_id => l_reject_tbl(i),
739: p_error_message_name => l_message_name,
740: p_table_name => 'PO_HEADERS_INTERFACE',
741: p_column_name => 'ACTION',

Line 891: PO_PDOI_ERR_UTL.add_fatal_error

887: l_column_name := 'VENDOR_NUM';
888: l_token_value := l_vendor_num_tbl(i);
889: END IF;
890:
891: PO_PDOI_ERR_UTL.add_fatal_error
892: ( p_interface_header_id => l_intf_header_id_tbl(i),
893: p_error_message_name => 'PO_PDOI_DERV_ERROR',
894: p_table_name => 'PO_HEADERS_INTERFACE',
895: p_column_name => 'VENDOR_ID',

Line 1008: PO_PDOI_ERR_UTL.add_fatal_error

1004:
1005: -- start date has to be provided for replace
1006: IF l_start_date_tbl(i) IS NULL THEN
1007: d_position := 30;
1008: PO_PDOI_ERR_UTL.add_fatal_error
1009: ( p_interface_header_id => l_interface_header_id_tbl(i),
1010: p_error_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
1011: p_table_name => 'PO_HEADERS_INTERFACE',
1012: p_column_name => 'START_DATE',

Line 1024: PO_PDOI_ERR_UTL.add_fatal_error

1020:
1021: d_position := 40;
1022: -- start date has to be greater than end date
1023: IF (TRUNC(l_start_date_tbl(i)) > TRUNC(NVL(l_end_date_tbl(i), l_start_date_tbl(i)))) THEN
1024: PO_PDOI_ERR_UTL.add_fatal_error
1025: ( p_interface_header_id => l_interface_header_id_tbl(i),
1026: p_error_message_name => 'PO_PDOI_INVALID_START_DATE',
1027: p_table_name => 'PO_HEADERS_INTERFACE',
1028: p_column_name => 'START_DATE',

Line 1122: PO_PDOI_ERR_UTL.add_fatal_error

1118:
1119: d_position := 100;
1120:
1121: IF (l_error_message_name IS NOT NULL) THEN
1122: PO_PDOI_ERR_UTL.add_fatal_error
1123: ( p_interface_header_id => l_interface_header_id_tbl(i),
1124: p_error_message_name => l_error_message_name,
1125: p_table_name => 'PO_HEADERS_INTERFACE',
1126: p_column_name => 'VENDOR_DOC_NUM',

Line 1274: PO_PDOI_ERR_UTL.add_fatal_error

1270:
1271: d_position := 10;
1272:
1273: IF (l_rel_exists = 'Y') THEN
1274: PO_PDOI_ERR_UTL.add_fatal_error
1275: ( p_interface_header_id => p_interface_header_id,
1276: p_error_message_name => 'PO_PDOI_GA_ST_DATE_GT_PO_DATE',
1277: p_table_name => 'PO_HEADERS_INTERFACE',
1278: p_column_name => 'EFFECTIVE_DATE',

Line 1297: PO_PDOI_ERR_UTL.add_fatal_error

1293: WHERE POR.po_header_id = p_po_header_id
1294: AND POR.release_date >= l_exp_date);
1295:
1296: IF (l_rel_exists = 'Y') THEN
1297: PO_PDOI_ERR_UTL.add_fatal_error
1298: ( p_interface_header_id => p_interface_header_id,
1299: p_error_message_name => 'PO_PDOI_ST_DATE_GT_REL_DATE',
1300: p_table_name => 'PO_HEADERS_INTERFACE',
1301: p_column_name => 'EFFECTIVE_DATE',

Line 1509: PO_PDOI_ERR_UTL.add_fatal_error

1505: INTO l_doc_num_for_msg_dsp
1506: FROM po_headers_all
1507: WHERE po_header_id = l_po_header_id_tbl(i);
1508:
1509: PO_PDOI_ERR_UTL.add_fatal_error
1510: ( p_interface_header_id => l_interface_header_id_tbl(i),
1511: p_error_message_name => l_message_name,
1512: p_table_name => 'PO_HEADERS_INTERFACE',
1513: p_column_name => 'PO_HEADER_ID',

Line 1675: PO_PDOI_ERR_UTL.add_fatal_error

1671: END IF;
1672:
1673: d_position := 130;
1674:
1675: PO_PDOI_ERR_UTL.add_fatal_error
1676: ( p_interface_header_id => l_interface_header_id_tbl(i),
1677: p_error_message_name => l_message_name,
1678: p_table_name => 'PO_HEADERS_INTERFACE',
1679: p_column_name => l_col_name,

Line 1727: PO_PDOI_ERR_UTL.add_fatal_error

1723: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1724: END IF;
1725:
1726: d_position := 160;
1727: PO_PDOI_ERR_UTL.add_fatal_error
1728: ( p_interface_header_id => l_interface_header_id_tbl(i),
1729: p_error_message_name => l_message_name,
1730: p_table_name => 'PO_HEADERS_INTERFACE',
1731: p_column_name => l_col_name,

Line 1872: PO_PDOI_ERR_UTL.add_fatal_error

1868:
1869: d_position := 10;
1870:
1871: FOR i IN 1..l_reject_list.COUNT LOOP
1872: PO_PDOI_ERR_UTL.add_fatal_error
1873: ( p_interface_header_id => l_reject_list(i),
1874: p_error_message_name => 'PO_PDOI_CATG_ALREADY_EXISTS',
1875: p_table_name => 'PO_HEADERS_INTERFACE',
1876: p_column_name => 'VENDOR_DOC_NUM',

Line 3232: PO_PDOI_ERR_UTL.add_fatal_error

3228: FOR i IN 1..l_intf_line_id_tbl.Count
3229: LOOP
3230: IF Nvl(l_is_line_num_disp_valid(i),'Y') = 'N'
3231: THEN
3232: PO_PDOI_ERR_UTL.add_fatal_error
3233: ( p_interface_header_id => l_intf_header_id_tbl(i),
3234: p_error_message_name => 'PO_PDOI_DERV_ERROR',
3235: p_table_name => 'PO_LINES_INTERFACE',
3236: p_column_name => 'LINE_NUM_DISPLAY',