APPS.PO_NOTIFICATION_CTRL_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: -----------------------------------------------------------------------

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

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

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

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

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

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

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

222: attribute8,
223: attribute9
224: FROM po_notification_controls
225: WHERE notification_id = p_notification_id_tbl(i)
226: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
227: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
228:
229: d_position := 20;
230: IF (PO_LOG.d_stmt) THEN

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

223: attribute9
224: FROM po_notification_controls
225: WHERE notification_id = p_notification_id_tbl(i)
226: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
227: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
228:
229: d_position := 20;
230: IF (PO_LOG.d_stmt) THEN
231: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

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

236: SET delete_flag = p_delete_flag_tbl(i)
237: WHERE notification_id = p_notification_id_tbl(i)
238: AND draft_id = p_draft_id_tbl(i)
239: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
240: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
241:
242: d_position := 30;
243:
244: IF (PO_LOG.d_stmt) THEN

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: PO_MESSAGE_S.add_exc_msg
258: ( p_pkg_name => d_pkg_name,
259: p_procedure_name => d_api_name || '.' || d_position
260: );
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END sync_draft_from_txn;
263:
264: -----------------------------------------------------------------------
265: --Start of Comments

Line 332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

328: PO_MESSAGE_S.add_exc_msg
329: ( p_pkg_name => d_pkg_name,
330: p_procedure_name => d_api_name || '.' || d_position
331: );
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END sync_draft_from_txn;
334:
335:
336: -----------------------------------------------------------------------

Line 553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

549: PO_MESSAGE_S.add_exc_msg
550: ( p_pkg_name => d_pkg_name,
551: p_procedure_name => d_api_name || '.' || d_position
552: );
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END merge_changes;
555:
556: -----------------------------------------------------------------------
557: --Start of Comments