APPS.PO_LINE_LOCATIONS_DRAFT_PKG dependencies on FND_API

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: PO_MESSAGE_S.add_exc_msg
55: ( p_pkg_name => d_pkg_name,
56: p_procedure_name => d_api_name || '.' || d_position
57: );
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END delete_rows;
60:
61:
62: -----------------------------------------------------------------------

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

120: -- Created an associative array to store what id has appeared.
121: l_duplicate_flag_tbl.EXTEND(p_line_location_id_tbl.COUNT);
122:
123: FOR i IN 1..p_line_location_id_tbl.COUNT LOOP
124: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
125:
126: IF (l_distinct_id_list.EXISTS(p_line_location_id_tbl(i))) THEN
127:
128: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;

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

124: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
125:
126: IF (l_distinct_id_list.EXISTS(p_line_location_id_tbl(i))) THEN
127:
128: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
129: ELSE
130: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
131:
132: l_distinct_id_list(p_line_location_id_tbl(i)) := 1;

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

126: IF (l_distinct_id_list.EXISTS(p_line_location_id_tbl(i))) THEN
127:
128: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
129: ELSE
130: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
131:
132: l_distinct_id_list(p_line_location_id_tbl(i)) := 1;
133: END IF;
134:

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

486: outsourced_assembly,
487: tax_attribute_update_code --
488: FROM po_line_locations_all
489: WHERE line_location_id = p_line_location_id_tbl(i)
490: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
491: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
492:
493: d_position := 20;
494: IF (PO_LOG.d_stmt) THEN

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

487: tax_attribute_update_code --
488: FROM po_line_locations_all
489: WHERE line_location_id = p_line_location_id_tbl(i)
490: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
491: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
492:
493: d_position := 20;
494: IF (PO_LOG.d_stmt) THEN
495: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

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

500: SET delete_flag = p_delete_flag_tbl(i)
501: WHERE line_location_id = p_line_location_id_tbl(i)
502: AND draft_id = p_draft_id_tbl(i)
503: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
504: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
505:
506: d_position := 30;
507:
508: IF (PO_LOG.d_stmt) THEN

Line 525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

521: PO_MESSAGE_S.add_exc_msg
522: ( p_pkg_name => d_pkg_name,
523: p_procedure_name => d_api_name || '.' || d_position
524: );
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END sync_draft_from_txn;
527:
528:
529: -----------------------------------------------------------------------

Line 597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

593: PO_MESSAGE_S.add_exc_msg
594: ( p_pkg_name => d_pkg_name,
595: p_procedure_name => d_api_name || '.' || d_position
596: );
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END sync_draft_from_txn;
599:
600: -----------------------------------------------------------------------
601: --Start of Comments

Line 1351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1347: PO_MESSAGE_S.add_exc_msg
1348: ( p_pkg_name => d_pkg_name,
1349: p_procedure_name => d_api_name || '.' || d_position
1350: );
1351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1352: END merge_changes;
1353:
1354: -----------------------------------------------------------------------
1355: --Start of Comments