APPS.PO_LINE_LOCATIONS_DRAFT_PKG dependencies on FND_API

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88: PO_MESSAGE_S.add_exc_msg
89: ( p_pkg_name => d_pkg_name,
90: p_procedure_name => d_api_name || '.' || d_position
91: );
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END delete_rows;
94:
95:
96: -----------------------------------------------------------------------

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

154: -- Created an associative array to store what id has appeared.
155: l_duplicate_flag_tbl.EXTEND(p_line_location_id_tbl.COUNT);
156:
157: FOR i IN 1..p_line_location_id_tbl.COUNT LOOP
158: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
159:
160: IF (l_distinct_id_list.EXISTS(p_line_location_id_tbl(i))) THEN
161:
162: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;

Line 162: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;

158: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
159:
160: IF (l_distinct_id_list.EXISTS(p_line_location_id_tbl(i))) THEN
161:
162: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
163: ELSE
164: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
165:
166: l_distinct_id_list(p_line_location_id_tbl(i)) := 1;

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

160: IF (l_distinct_id_list.EXISTS(p_line_location_id_tbl(i))) THEN
161:
162: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
163: ELSE
164: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
165:
166: l_distinct_id_list(p_line_location_id_tbl(i)) := 1;
167: END IF;
168:

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

546: clm_pop_duration_uom,
547: Nvl(revision_num, 0) --
548: FROM po_line_locations_all
549: WHERE line_location_id = p_line_location_id_tbl(i)
550: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
551: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
552:
553: d_position := 20;
554: IF (PO_LOG.d_stmt) THEN

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

547: Nvl(revision_num, 0) --
548: FROM po_line_locations_all
549: WHERE line_location_id = p_line_location_id_tbl(i)
550: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
551: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
552:
553: d_position := 20;
554: IF (PO_LOG.d_stmt) THEN
555: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

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

560: SET delete_flag = p_delete_flag_tbl(i)
561: WHERE line_location_id = p_line_location_id_tbl(i)
562: AND draft_id = p_draft_id_tbl(i)
563: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
564: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
565:
566: d_position := 30;
567:
568: IF (PO_LOG.d_stmt) THEN

Line 585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

581: PO_MESSAGE_S.add_exc_msg
582: ( p_pkg_name => d_pkg_name,
583: p_procedure_name => d_api_name || '.' || d_position
584: );
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: END sync_draft_from_txn;
587:
588:
589: -----------------------------------------------------------------------

Line 657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

653: PO_MESSAGE_S.add_exc_msg
654: ( p_pkg_name => d_pkg_name,
655: p_procedure_name => d_api_name || '.' || d_position
656: );
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END sync_draft_from_txn;
659:
660: -----------------------------------------------------------------------
661: --Start of Comments

Line 1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1476: PO_MESSAGE_S.add_exc_msg
1477: ( p_pkg_name => d_pkg_name,
1478: p_procedure_name => d_api_name || '.' || d_position
1479: );
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END merge_changes;
1482:
1483: -----------------------------------------------------------------------
1484: --Start of Comments