APPS.PO_ATTR_VALUES_TLP_DRAFT_PKG dependencies on FND_API

Line 60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

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

502: program_id,
503: program_update_date
504: FROM po_attribute_values_tlp
505: WHERE attribute_values_tlp_id = p_attribute_values_tlp_id_tbl(i)
506: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
507: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
508:
509: d_position := 20;
510: IF (PO_LOG.d_stmt) THEN

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

503: program_update_date
504: FROM po_attribute_values_tlp
505: WHERE attribute_values_tlp_id = p_attribute_values_tlp_id_tbl(i)
506: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
507: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
508:
509: d_position := 20;
510: IF (PO_LOG.d_stmt) THEN
511: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

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

516: SET delete_flag = p_delete_flag_tbl(i)
517: WHERE attribute_values_tlp_id = p_attribute_values_tlp_id_tbl(i)
518: AND draft_id = p_draft_id_tbl(i)
519: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
520: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
521:
522: d_position := 30;
523:
524: IF (PO_LOG.d_stmt) THEN

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

537: PO_MESSAGE_S.add_exc_msg
538: ( p_pkg_name => d_pkg_name,
539: p_procedure_name => d_api_name || '.' || d_position
540: );
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END sync_draft_from_txn;
543:
544:
545: -----------------------------------------------------------------------

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610: PO_MESSAGE_S.add_exc_msg
611: ( p_pkg_name => d_pkg_name,
612: p_procedure_name => d_api_name || '.' || d_position
613: );
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END sync_draft_from_txn;
616:
617:
618: -----------------------------------------------------------------------

Line 1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1392: PO_MESSAGE_S.add_exc_msg
1393: ( p_pkg_name => d_pkg_name,
1394: p_procedure_name => d_api_name || '.' || d_position
1395: );
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: END merge_changes;
1398:
1399: -----------------------------------------------------------------------
1400: --Start of Comments