DBA Data[Home] [Help]

APPS.PO_PDOI_PREPROC_PVT dependencies on PO_PDOI_ERR_UTL

Line 689: PO_PDOI_ERR_UTL.add_fatal_error

685: l_message_name := 'PO_PDOI_INVALID_ACTION';
686: END IF;
687:
688: d_position := 20;
689: PO_PDOI_ERR_UTL.add_fatal_error
690: ( p_interface_header_id => l_reject_tbl(i),
691: p_error_message_name => l_message_name,
692: p_table_name => 'PO_HEADERS_INTERFACE',
693: p_column_name => 'ACTION',

Line 810: PO_PDOI_ERR_UTL.add_fatal_error

806: l_column_name := 'VENDOR_NUM';
807: l_token_value := l_vendor_num_tbl(i);
808: END IF;
809:
810: PO_PDOI_ERR_UTL.add_fatal_error
811: ( p_interface_header_id => l_intf_header_id_tbl(i),
812: p_error_message_name => 'PO_PDOI_DERV_ERROR',
813: p_table_name => 'PO_HEADERS_INTERFACE',
814: p_column_name => 'VENDOR_ID',

Line 927: PO_PDOI_ERR_UTL.add_fatal_error

923:
924: -- start date has to be provided for replace
925: IF l_start_date_tbl(i) IS NULL THEN
926: d_position := 30;
927: PO_PDOI_ERR_UTL.add_fatal_error
928: ( p_interface_header_id => l_interface_header_id_tbl(i),
929: p_error_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
930: p_table_name => 'PO_HEADERS_INTERFACE',
931: p_column_name => 'START_DATE',

Line 943: PO_PDOI_ERR_UTL.add_fatal_error

939:
940: d_position := 40;
941: -- start date has to be greater than end date
942: IF (TRUNC(l_start_date_tbl(i)) > TRUNC(NVL(l_end_date_tbl(i), l_start_date_tbl(i)))) THEN
943: PO_PDOI_ERR_UTL.add_fatal_error
944: ( p_interface_header_id => l_interface_header_id_tbl(i),
945: p_error_message_name => 'PO_PDOI_INVALID_START_DATE',
946: p_table_name => 'PO_HEADERS_INTERFACE',
947: p_column_name => 'START_DATE',

Line 1040: PO_PDOI_ERR_UTL.add_fatal_error

1036:
1037: d_position := 100;
1038:
1039: IF (l_error_message_name IS NOT NULL) THEN
1040: PO_PDOI_ERR_UTL.add_fatal_error
1041: ( p_interface_header_id => l_interface_header_id_tbl(i),
1042: p_error_message_name => l_error_message_name,
1043: p_table_name => 'PO_HEADERS_INTERFACE',
1044: p_column_name => 'VENDOR_DOC_NUM',

Line 1192: PO_PDOI_ERR_UTL.add_fatal_error

1188:
1189: d_position := 10;
1190:
1191: IF (l_rel_exists = 'Y') THEN
1192: PO_PDOI_ERR_UTL.add_fatal_error
1193: ( p_interface_header_id => p_interface_header_id,
1194: p_error_message_name => 'PO_PDOI_GA_ST_DATE_GT_PO_DATE',
1195: p_table_name => 'PO_HEADERS_INTERFACE',
1196: p_column_name => 'EFFECTIVE_DATE',

Line 1215: PO_PDOI_ERR_UTL.add_fatal_error

1211: WHERE POR.po_header_id = p_po_header_id
1212: AND POR.release_date >= l_exp_date);
1213:
1214: IF (l_rel_exists = 'Y') THEN
1215: PO_PDOI_ERR_UTL.add_fatal_error
1216: ( p_interface_header_id => p_interface_header_id,
1217: p_error_message_name => 'PO_PDOI_ST_DATE_GT_REL_DATE',
1218: p_table_name => 'PO_HEADERS_INTERFACE',
1219: p_column_name => 'EFFECTIVE_DATE',

Line 1427: PO_PDOI_ERR_UTL.add_fatal_error

1423: INTO l_doc_num_for_msg_dsp
1424: FROM po_headers_all
1425: WHERE po_header_id = l_po_header_id_tbl(i);
1426:
1427: PO_PDOI_ERR_UTL.add_fatal_error
1428: ( p_interface_header_id => l_interface_header_id_tbl(i),
1429: p_error_message_name => l_message_name,
1430: p_table_name => 'PO_HEADERS_INTERFACE',
1431: p_column_name => 'PO_HEADER_ID',

Line 1593: PO_PDOI_ERR_UTL.add_fatal_error

1589: END IF;
1590:
1591: d_position := 130;
1592:
1593: PO_PDOI_ERR_UTL.add_fatal_error
1594: ( p_interface_header_id => l_interface_header_id_tbl(i),
1595: p_error_message_name => l_message_name,
1596: p_table_name => 'PO_HEADERS_INTERFACE',
1597: p_column_name => l_col_name,

Line 1645: PO_PDOI_ERR_UTL.add_fatal_error

1641: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1642: END IF;
1643:
1644: d_position := 160;
1645: PO_PDOI_ERR_UTL.add_fatal_error
1646: ( p_interface_header_id => l_interface_header_id_tbl(i),
1647: p_error_message_name => l_message_name,
1648: p_table_name => 'PO_HEADERS_INTERFACE',
1649: p_column_name => l_col_name,

Line 1790: PO_PDOI_ERR_UTL.add_fatal_error

1786:
1787: d_position := 10;
1788:
1789: FOR i IN 1..l_reject_list.COUNT LOOP
1790: PO_PDOI_ERR_UTL.add_fatal_error
1791: ( p_interface_header_id => l_reject_list(i),
1792: p_error_message_name => 'PO_PDOI_CATG_ALREADY_EXISTS',
1793: p_table_name => 'PO_HEADERS_INTERFACE',
1794: p_column_name => 'VENDOR_DOC_NUM',