DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on FND_API

Line 652: IF (l_return_status = FND_API.g_ret_sts_success

648: ,p_orig_org_id => p_orig_org_id --
649: ,p_group_shipments => p_group_shipments --
650: );
651:
652: IF (l_return_status = FND_API.g_ret_sts_success
653: AND x_number_lines >0 AND x_document_id is NOT NULL) --
654: THEN
655: x_errorcode := 1;
656: ELSIF g_sourcing_errorcode = 2 THEN

Line 882: IF NOT FND_API.compatible_api_call (

878: -- Standard Start of API savepoint
879: SAVEPOINT create_documents_pvt;
880:
881: -- Standard call to check for call compatibility.
882: IF NOT FND_API.compatible_api_call (
883: p_current_version_number => l_api_version,
884: p_caller_version_number => p_api_version,
885: p_api_name => l_api_name,
886: p_pkg_name => g_pkg_name

Line 889: RAISE FND_API.g_exc_unexpected_error;

885: p_api_name => l_api_name,
886: p_pkg_name => g_pkg_name
887: )
888: THEN
889: RAISE FND_API.g_exc_unexpected_error;
890: END IF;
891:
892: l_progress := '010';
893: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 1026: x_return_status := FND_API.G_RET_STS_SUCCESS;

1022: PO_MOAC_UTILS_PVT.set_org_context(l_purch_operating_unit_id) ; --
1023: END IF;
1024:
1025: -- Initialize API return status to success
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;
1027:
1028: -- Initialize the Operating Units
1029: g_purchasing_ou_id := l_purch_operating_unit_id;
1030: g_hdr_requesting_ou_id := l_req_operating_unit_id;

Line 1216: x_return_status := FND_API.G_RET_STS_SUCCESS ; --

1212: if g_interface_source_code in ('SOURCING','CONSUMPTION_ADVICE') then -- CONSIGNED FPI
1213: if x_number_lines>0 and x_document_id is not null then
1214: begin
1215: x_errorcode :=1; --success.
1216: x_return_status := FND_API.G_RET_STS_SUCCESS ; --
1217:
1218: /* CONSIGNED FPI start : return the release number for the release */
1219: IF g_document_subtype = 'RELEASE' THEN
1220: l_progress:= '130';

Line 1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1242: p_progress => l_progress);
1243: END IF;
1244: wrapup(x_interface_header_id);
1245: --
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247:
1248: --set the org context back to original one
1249: IF (l_org_context_changed = 'Y') THEN
1250: PO_MOAC_UTILS_PVT.set_org_context(l_original_operating_unit_id) ; --

Line 1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; --

1261: else
1262: --when 0 lines are created, we assume that there is some erro happened
1263: --which is not related to manual PO numbering.
1264: x_errorcode:=3;
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; --
1266: end if;
1267: end if; --Num_line_checked
1268: --
1269: else --Calls other than Sourcing and Consumption Advice

Line 1271: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1267: end if; --Num_line_checked
1268: --
1269: else --Calls other than Sourcing and Consumption Advice
1270: if x_number_lines>0 and x_document_id is not null then
1271: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1272: --
1273: -- Need to populate document number for autocreate success message
1274: IF g_document_subtype = 'STANDARD' THEN
1275: select segment1

Line 1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1278: where po_header_id = x_document_id;
1279: END IF;
1280: --
1281: else
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1283: end if;
1284: end if; --check doc type
1285: --
1286:

Line 1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1355: END IF;
1356: wrapup(x_interface_header_id);
1357:
1358: --
1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1360: --
1361: x_number_lines := g_number_records_processed;
1362: x_document_id := null;
1363: x_document_number := null;

Line 1810: p_init_msg_list => FND_API.G_FALSE,

1806:
1807: -- Calls Contracts API to clear Amendment related columns
1808: OKC_TERMS_VERSION_GRP.clear_amendment(
1809: p_api_version => 1.0,
1810: p_init_msg_list => FND_API.G_FALSE,
1811: p_commit => FND_API.G_FALSE,
1812: x_return_status => l_return_status,
1813: x_msg_data => l_msg_data,
1814: x_msg_count => l_msg_count,

Line 1811: p_commit => FND_API.G_FALSE,

1807: -- Calls Contracts API to clear Amendment related columns
1808: OKC_TERMS_VERSION_GRP.clear_amendment(
1809: p_api_version => 1.0,
1810: p_init_msg_list => FND_API.G_FALSE,
1811: p_commit => FND_API.G_FALSE,
1812: x_return_status => l_return_status,
1813: x_msg_data => l_msg_data,
1814: x_msg_count => l_msg_count,
1815: p_doc_type => (l_doc_type ||'_'||g_document_subtype),

Line 2747: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

2743: p_token => l_progress,
2744: p_message => 'after call okc_terms_copy_grp.copy_doc.Return status:'||l_return_status);
2745: END IF;
2746:
2747: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
2748: RAISE l_Contracts_call_exception;
2749: END IF; -- Return status from contracts
2750:
2751: END IF; -- if p_conterms_exist_flag and sourcing doc

Line 2865: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2861: PO_TAX_INTERFACE_PVT.calculate_tax( x_return_status => l_return_status,
2862: p_po_header_id => tax_document_id,
2863: p_po_release_id => NULL,
2864: p_calling_program => 'POXBWVRP_PO');
2865: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2866: l_progress := '414';
2867: IF g_interface_source_code = 'CONSUMPTION_ADVICE' THEN
2868: ROLLBACK TO TAX_CALCULATION_ERROR;
2869: x_document_id := NULL;

Line 2895: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2891: PO_TAX_INTERFACE_PVT.calculate_tax(x_return_status => l_return_status,
2892: p_po_header_id => NULL,
2893: p_po_release_id => tax_document_id,
2894: p_calling_program => 'POXBWVRP_PO');
2895: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2896: IF g_interface_source_code = 'CONSUMPTION_ADVICE' THEN
2897: ROLLBACK TO TAX_CALCULATION_ERROR;
2898: x_document_id := NULL;
2899: fnd_message.set_name('PO','PO_API_ERROR');

Line 8709: p_init_msg_list => FND_API.G_TRUE,

8705:
8706: -- Get the Transaction Flow Header ID from the Inventory API.
8707: -- Use the wrapper API written in PO.
8708: PO_SHARED_PROC_PVT.check_transaction_flow(
8709: p_init_msg_list => FND_API.G_TRUE,
8710: x_return_status => l_return_status, -- OUT NOCOPY VARCHAR2
8711: p_start_ou_id => g_purchasing_ou_id,
8712: p_end_ou_id => l_destination_ou_id,
8713: p_ship_to_org_id => l_destination_organization_id,

Line 8728: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

8724: ||l_return_status);
8725: END IF;
8726:
8727: l_progress := '060';
8728: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8729: APP_EXCEPTION.raise_exception(
8730: exception_type => 'PO_SHARED_PROC_PVT.check_transaction_flow',
8731: exception_code => 0,
8732: exception_text => 'return_status='||l_return_status);

Line 8746: IF l_return_status <> FND_API.g_ret_sts_success THEN

8742: (x_return_status => l_return_status,
8743: p_item_id => l_item_id,
8744: p_transaction_flow_header_id => l_transaction_flow_header_id,
8745: x_item_in_linv_pou => l_item_in_linv_pou);
8746: IF l_return_status <> FND_API.g_ret_sts_success THEN
8747: APP_EXCEPTION.raise_exception(
8748: exception_type => 'PO_SHARED_PROC_PVT.check_item_in_linv_pou',
8749: exception_code => 0,
8750: exception_text => 'return_status='||l_return_status);

Line 8751: ELSIF l_return_status = FND_API.g_ret_sts_success AND

8747: APP_EXCEPTION.raise_exception(
8748: exception_type => 'PO_SHARED_PROC_PVT.check_item_in_linv_pou',
8749: exception_code => 0,
8750: exception_text => 'return_status='||l_return_status);
8751: ELSIF l_return_status = FND_API.g_ret_sts_success AND
8752: (l_item_in_linv_pou <> 'Y') THEN
8753: IF g_debug_stmt THEN
8754: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
8755: p_token => l_progress,

Line 14691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

14687: x_msg_data => l_msg_data,
14688: p_caller => 'AUTOCREATE',
14689: x_po_gms_interface_obj => l_gms_po_interface_obj);
14690:
14691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14692: RAISE FND_API.G_EXC_ERROR;
14693: END IF;
14694:
14695: l_progress := '020';

Line 14692: RAISE FND_API.G_EXC_ERROR;

14688: p_caller => 'AUTOCREATE',
14689: x_po_gms_interface_obj => l_gms_po_interface_obj);
14690:
14691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14692: RAISE FND_API.G_EXC_ERROR;
14693: END IF;
14694:
14695: l_progress := '020';
14696:

Line 14732: WHEN FND_API.G_EXC_ERROR THEN

14728: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
14729: END IF;
14730: EXCEPTION
14731:
14732: WHEN FND_API.G_EXC_ERROR THEN
14733: IF FND_MSG_PUB.check_msg_level(
14734: p_message_level => FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
14735: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
14736: p_procedure_name => l_api_name);

Line 14743: p_encoded => FND_API.G_FALSE),

14739: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
14740:
14741: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
14742: l_msg_buf := SUBSTRB(FND_MSG_PUB.get(p_msg_index => i,
14743: p_encoded => FND_API.G_FALSE),
14744: 1, 2000);
14745: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
14746: p_token => l_progress,
14747: p_message => 'EXCEPTION: '|| l_msg_buf);

Line 14751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

14747: p_message => 'EXCEPTION: '|| l_msg_buf);
14748: END LOOP;
14749:
14750: END IF;
14751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14752:
14753: WHEN OTHERS THEN
14754: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
14755: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,

Line 15768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

15764: d_progress := 50;
15765: IF (PO_LOG.d_exc) THEN
15766: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
15767: END IF;
15768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15769: END IF;
15770:
15771: END IF; -- if params.po_encumbrance_flag = 'Y' AND ...
15772:

Line 15942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

15938: d_progress := 100;
15939: IF (PO_LOG.d_exc) THEN
15940: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
15941: END IF;
15942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15943: END IF;
15944:
15945: END IF; -- if params.po_encumbrance_flag = 'Y' AND ...
15946: