DBA Data[Home] [Help]

APPS.PO_PRICE_ADJ_DRAFT_PKG dependencies on FND_API

Line 63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

59: PO_MESSAGE_S.add_exc_msg
60: ( p_pkg_name => d_pkg_name,
61: p_procedure_name => d_api_name || '.' || d_position
62: );
63: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
64: END delete_rows;
65:
66: -----------------------------------------------------------------------
67: --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_adjustment_id_tbl.COUNT);
125:
126: FOR i IN 1..p_price_adjustment_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_adjustment_id_tbl(i))) THEN
130: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
131: ELSE

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

126: FOR i IN 1..p_price_adjustment_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_adjustment_id_tbl(i))) THEN
130: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
131: ELSE
132: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
133: l_distinct_id_list(p_price_adjustment_id_tbl(i)) := 1;
134: END IF;

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

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

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

344: , ADJ.adjusted_amount_per_pqty
345: , 1
346: FROM PO_PRICE_ADJUSTMENTS ADJ
347: WHERE ADJ.price_adjustment_id = p_price_adjustment_id_tbl(i)
348: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
349: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
350:
351: d_position := 20;
352: IF (PO_LOG.d_stmt) THEN

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

345: , 1
346: FROM PO_PRICE_ADJUSTMENTS ADJ
347: WHERE ADJ.price_adjustment_id = p_price_adjustment_id_tbl(i)
348: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
349: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
350:
351: d_position := 20;
352: IF (PO_LOG.d_stmt) THEN
353: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

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

359: WHERE (price_adjustment_id = p_price_adjustment_id_tbl(i)
360: OR parent_adjustment_id = p_price_adjustment_id_tbl(i))
361: AND draft_id = p_draft_id_tbl(i)
362: AND NVL(delete_flag, 'N') <> 'Y'
363: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
364:
365: d_position := 30;
366: IF (PO_LOG.d_stmt) THEN
367: PO_LOG.stmt(d_module, d_position, 'update draft records that are already' ||

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

411: , ATTR.price_adj_attrib_id
412: , 1
413: FROM PO_PRICE_ADJ_ATTRIBS ATTR
414: WHERE ATTR.price_adjustment_id = p_price_adjustment_id_tbl(i)
415: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
416: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
417:
418: d_position := 40;
419: IF (PO_LOG.d_stmt) THEN

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

412: , 1
413: FROM PO_PRICE_ADJ_ATTRIBS ATTR
414: WHERE ATTR.price_adjustment_id = p_price_adjustment_id_tbl(i)
415: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
416: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
417:
418: d_position := 40;
419: IF (PO_LOG.d_stmt) THEN
420: PO_LOG.stmt(d_module, d_position, 'Attribute records transfer count = ' || SQL%ROWCOUNT);

Line 434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

430: PO_MESSAGE_S.add_exc_msg
431: ( p_pkg_name => d_pkg_name,
432: p_procedure_name => d_api_name || '.' || d_position
433: );
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END sync_draft_from_txn;
436:
437: -----------------------------------------------------------------------
438: --Start of Comments

Line 504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

500: PO_MESSAGE_S.add_exc_msg
501: ( p_pkg_name => d_pkg_name,
502: p_procedure_name => d_api_name || '.' || d_position
503: );
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END sync_draft_from_txn;
506:
507:
508: -----------------------------------------------------------------------

Line 589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

585: PO_MESSAGE_S.add_exc_msg
586: ( p_pkg_name => d_pkg_name,
587: p_procedure_name => d_api_name || '.' || d_position
588: );
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END sync_draft_from_txn;
591:
592: -----------------------------------------------------------------------
593: --Start of Comments

Line 1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1122: PO_MESSAGE_S.add_exc_msg
1123: ( p_pkg_name => d_pkg_name,
1124: p_procedure_name => d_api_name || '.' || d_position
1125: );
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127: END merge_changes;
1128:
1129: -----------------------------------------------------------------------
1130: --Start of Comments