APPS.PO_DISTRIBUTIONS_DRAFT_PKG dependencies on FND_API

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

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

375: --
376: tax_attribute_update_code --
377: FROM po_distributions_all
378: WHERE po_distribution_id = p_po_distribution_id_tbl(i)
379: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
380: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
381:
382: d_position := 20;
383: IF (PO_LOG.d_stmt) THEN

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

376: tax_attribute_update_code --
377: FROM po_distributions_all
378: WHERE po_distribution_id = p_po_distribution_id_tbl(i)
379: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
380: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
381:
382: d_position := 20;
383: IF (PO_LOG.d_stmt) THEN
384: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

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

389: SET delete_flag = p_delete_flag_tbl(i)
390: WHERE po_distribution_id = p_po_distribution_id_tbl(i)
391: AND draft_id = p_draft_id_tbl(i)
392: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
393: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
394:
395: d_position := 30;
396:
397: IF (PO_LOG.d_stmt) THEN

Line 414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

410: PO_MESSAGE_S.add_exc_msg
411: ( p_pkg_name => d_pkg_name,
412: p_procedure_name => d_api_name || '.' || d_position
413: );
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END sync_draft_from_txn;
416:
417: -----------------------------------------------------------------------
418: --Start of Comments

Line 485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

481: PO_MESSAGE_S.add_exc_msg
482: ( p_pkg_name => d_pkg_name,
483: p_procedure_name => d_api_name || '.' || d_position
484: );
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END sync_draft_from_txn;
487:
488: -----------------------------------------------------------------------
489: --Start of Comments

Line 1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1010: PO_MESSAGE_S.add_exc_msg
1011: ( p_pkg_name => d_pkg_name,
1012: p_procedure_name => d_api_name || '.' || d_position
1013: );
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END merge_changes;
1016:
1017: -----------------------------------------------------------------------
1018: --Start of Comments