90: PO_MESSAGE_S.add_exc_msg
91: ( p_pkg_name => d_pkg_name,
92: p_procedure_name => d_api_name || '.' || d_position
93: );
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END delete_rows;
96:
97: -----------------------------------------------------------------------
98: --Start of Comments
156: -- Created an associative array to store what id has appeared.
157: l_duplicate_flag_tbl.EXTEND(p_po_line_id_tbl.COUNT);
158:
159: FOR i IN 1..p_po_line_id_tbl.COUNT LOOP
160: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
161:
162: IF (l_distinct_id_list.EXISTS(p_po_line_id_tbl(i))) THEN
163:
164: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
160: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
161:
162: IF (l_distinct_id_list.EXISTS(p_po_line_id_tbl(i))) THEN
163:
164: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
165: ELSE
166: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
167:
168: l_distinct_id_list(p_po_line_id_tbl(i)) := 1;
162: IF (l_distinct_id_list.EXISTS(p_po_line_id_tbl(i))) THEN
163:
164: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
165: ELSE
166: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
167:
168: l_distinct_id_list(p_po_line_id_tbl(i)) := 1;
169: END IF;
170:
589: unit_meas_lookup_code, --- Old UOM
590: Nvl(revision_num, 0) --
591: FROM po_lines_all
592: WHERE po_line_id = p_po_line_id_tbl(i)
593: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
594: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
595:
596: d_position := 20;
597: IF (PO_LOG.d_stmt) THEN
590: Nvl(revision_num, 0) --
591: FROM po_lines_all
592: WHERE po_line_id = p_po_line_id_tbl(i)
593: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
594: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
595:
596: d_position := 20;
597: IF (PO_LOG.d_stmt) THEN
598: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
603: SET delete_flag = p_delete_flag_tbl(i)
604: WHERE po_line_id = p_po_line_id_tbl(i)
605: AND draft_id = p_draft_id_tbl(i)
606: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
607: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
608:
609: d_position := 30;
610:
611: IF (PO_LOG.d_stmt) THEN
624: PO_MESSAGE_S.add_exc_msg
625: ( p_pkg_name => d_pkg_name,
626: p_procedure_name => d_api_name || '.' || d_position
627: );
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END sync_draft_from_txn;
630:
631:
632:
697: PO_MESSAGE_S.add_exc_msg
698: ( p_pkg_name => d_pkg_name,
699: p_procedure_name => d_api_name || '.' || d_position
700: );
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END sync_draft_from_txn;
703:
704: -----------------------------------------------------------------------
705: --Start of Comments
1557: PO_MESSAGE_S.add_exc_msg
1558: ( p_pkg_name => d_pkg_name,
1559: p_procedure_name => d_api_name || '.' || d_position
1560: );
1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562: END merge_changes;
1563:
1564: -----------------------------------------------------------------------
1565: --Start of Comments