APPS.PO_ATTR_VALUES_DRAFT_PKG dependencies on FND_API

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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_attribute_values_id_tbl.COUNT);
122:
123: FOR i IN 1..p_attribute_values_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_attribute_values_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_attribute_values_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_attribute_values_id_tbl(i)) := 1;

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

126: IF (l_distinct_id_list.EXISTS(p_attribute_values_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_attribute_values_id_tbl(i)) := 1;
133: END IF;
134:

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

806: program_id,
807: program_update_date
808: FROM po_attribute_values
809: WHERE attribute_values_id = p_attribute_values_id_tbl(i)
810: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
811: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
812:
813: d_position := 20;
814: IF (PO_LOG.d_stmt) THEN

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

807: program_update_date
808: FROM po_attribute_values
809: WHERE attribute_values_id = p_attribute_values_id_tbl(i)
810: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
811: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
812:
813: d_position := 20;
814: IF (PO_LOG.d_stmt) THEN
815: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

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

820: SET delete_flag = p_delete_flag_tbl(i)
821: WHERE attribute_values_id = p_attribute_values_id_tbl(i)
822: AND draft_id = p_draft_id_tbl(i)
823: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
824: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
825:
826: d_position := 30;
827:
828: IF (PO_LOG.d_stmt) THEN

Line 845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

841: PO_MESSAGE_S.add_exc_msg
842: ( p_pkg_name => d_pkg_name,
843: p_procedure_name => d_api_name || '.' || d_position
844: );
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END sync_draft_from_txn;
847:
848: -----------------------------------------------------------------------
849: --Start of Comments

Line 916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

912: PO_MESSAGE_S.add_exc_msg
913: ( p_pkg_name => d_pkg_name,
914: p_procedure_name => d_api_name || '.' || d_position
915: );
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END sync_draft_from_txn;
918:
919: -----------------------------------------------------------------------
920: --Start of Comments

Line 2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2304: PO_MESSAGE_S.add_exc_msg
2305: ( p_pkg_name => d_pkg_name,
2306: p_procedure_name => d_api_name || '.' || d_position
2307: );
2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2309: END merge_changes;
2310:
2311: -----------------------------------------------------------------------
2312: --Start of Comments