APPS.PO_PRICE_DIFF_DRAFT_PKG dependencies on FND_API

Line 61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

129: IF (l_distinct_id_list.EXISTS(p_price_differential_id_tbl(i))) THEN
130:
131: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
132: ELSE
133: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
134:
135: l_distinct_id_list(p_price_differential_id_tbl(i)) := 1;
136: END IF;
137:

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

188: last_updated_by,
189: last_update_login
190: FROM po_price_differentials
191: WHERE price_differential_id = p_price_differential_id_tbl(i)
192: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
193: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
194:
195: d_position := 20;
196: IF (PO_LOG.d_stmt) THEN

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

189: last_update_login
190: FROM po_price_differentials
191: WHERE price_differential_id = p_price_differential_id_tbl(i)
192: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
193: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
194:
195: d_position := 20;
196: IF (PO_LOG.d_stmt) THEN
197: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

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

202: SET delete_flag = p_delete_flag_tbl(i)
203: WHERE price_differential_id = p_price_differential_id_tbl(i)
204: AND draft_id = p_draft_id_tbl(i)
205: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
206: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
207:
208: d_position := 30;
209:
210: IF (PO_LOG.d_stmt) THEN

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

223: PO_MESSAGE_S.add_exc_msg
224: ( p_pkg_name => d_pkg_name,
225: p_procedure_name => d_api_name || '.' || d_position
226: );
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END sync_draft_from_txn;
229:
230: -----------------------------------------------------------------------
231: --Start of Comments

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: PO_MESSAGE_S.add_exc_msg
296: ( p_pkg_name => d_pkg_name,
297: p_procedure_name => d_api_name || '.' || d_position
298: );
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END sync_draft_from_txn;
301:
302:
303: -----------------------------------------------------------------------

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

444: PO_MESSAGE_S.add_exc_msg
445: ( p_pkg_name => d_pkg_name,
446: p_procedure_name => d_api_name || '.' || d_position
447: );
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END merge_changes;
450:
451: -----------------------------------------------------------------------
452: --Start of Comments