DBA Data[Home] [Help]

APPS.PO_HEADERS_DRAFT_PKG dependencies on FND_API

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: PO_MESSAGE_S.add_exc_msg
80: ( p_pkg_name => d_pkg_name,
81: p_procedure_name => d_api_name || '.' || d_position
82: );
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END delete_rows;
85:
86:
87: -----------------------------------------------------------------------

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

145: -- Created an associative array to store what id has appeared.
146: l_duplicate_flag_tbl.EXTEND(p_po_header_id_tbl.COUNT);
147:
148: FOR i IN 1..p_po_header_id_tbl.COUNT LOOP
149: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
150:
151: IF (l_distinct_id_list.EXISTS(p_po_header_id_tbl(i))) THEN
152:
153: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;

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

149: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
150:
151: IF (l_distinct_id_list.EXISTS(p_po_header_id_tbl(i))) THEN
152:
153: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
154: ELSE
155: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
156:
157: l_distinct_id_list(p_po_header_id_tbl(i)) := 1;

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

151: IF (l_distinct_id_list.EXISTS(p_po_header_id_tbl(i))) THEN
152:
153: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
154: ELSE
155: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
156:
157: l_distinct_id_list(p_po_header_id_tbl(i)) := 1;
158: END IF;
159:

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

566: clm_special_contract_type,
567: clm_payment_instr_code -- CLM Phase 4
568: FROM po_headers_all
569: WHERE po_header_id = p_po_header_id_tbl(i)
570: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
571: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
572:
573: d_position := 20;
574: IF (PO_LOG.d_stmt) THEN

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

567: clm_payment_instr_code -- CLM Phase 4
568: FROM po_headers_all
569: WHERE po_header_id = p_po_header_id_tbl(i)
570: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
571: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
572:
573: d_position := 20;
574: IF (PO_LOG.d_stmt) THEN
575: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

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

580: SET delete_flag = p_delete_flag_tbl(i)
581: WHERE po_header_id = p_po_header_id_tbl(i)
582: AND draft_id = p_draft_id_tbl(i)
583: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
584: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
585:
586: d_position := 30;
587:
588: IF (PO_LOG.d_stmt) THEN

Line 605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

601: PO_MESSAGE_S.add_exc_msg
602: ( p_pkg_name => d_pkg_name,
603: p_procedure_name => d_api_name || '.' || d_position
604: );
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END sync_draft_from_txn;
607:
608: -----------------------------------------------------------------------
609: --Start of Comments

Line 676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

672: PO_MESSAGE_S.add_exc_msg
673: ( p_pkg_name => d_pkg_name,
674: p_procedure_name => d_api_name || '.' || d_position
675: );
676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
677: END sync_draft_from_txn;
678:
679: -----------------------------------------------------------------------
680: --Start of Comments

Line 1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1556: PO_MESSAGE_S.add_exc_msg
1557: ( p_pkg_name => d_pkg_name,
1558: p_procedure_name => d_api_name || '.' || d_position
1559: );
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: END merge_changes;
1562:
1563: -----------------------------------------------------------------------
1564: --Start of Comments