DBA Data[Home] [Help]

APPS.PO_LINES_DRAFT_PKG dependencies on FND_API

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 160: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN

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;

Line 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;

Line 166: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;

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:

Line 593: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE

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

Line 594: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;

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);

Line 607: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;

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

Line 628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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