DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on FND_API

Line 654: IF (l_return_status = FND_API.g_ret_sts_success

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

Line 780: IF NOT FND_API.compatible_api_call (

776: -- Standard Start of API savepoint
777: SAVEPOINT create_documents_pvt;
778:
779: -- Standard call to check for call compatibility.
780: IF NOT FND_API.compatible_api_call (
781: p_current_version_number => l_api_version,
782: p_caller_version_number => p_api_version,
783: p_api_name => l_api_name,
784: p_pkg_name => g_pkg_name

Line 787: RAISE FND_API.g_exc_unexpected_error;

783: p_api_name => l_api_name,
784: p_pkg_name => g_pkg_name
785: )
786: THEN
787: RAISE FND_API.g_exc_unexpected_error;
788: END IF;
789:
790: l_progress := '010';
791: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 834: x_return_status := FND_API.G_RET_STS_SUCCESS;

830: PO_MOAC_UTILS_PVT.set_org_context(l_purch_operating_unit_id) ; --
831: END IF;
832:
833: -- Initialize API return status to success
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835:
836: -- Initialize the Operating Units
837: g_purchasing_ou_id := l_purch_operating_unit_id;
838: g_hdr_requesting_ou_id := l_req_operating_unit_id;

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

1018: if g_interface_source_code in ('SOURCING','CONSUMPTION_ADVICE') then -- CONSIGNED FPI
1019: if x_number_lines>0 and x_document_id is not null then
1020: begin
1021: x_errorcode :=1; --success.
1022: x_return_status := FND_API.G_RET_STS_SUCCESS ; --
1023:
1024: /* CONSIGNED FPI start : return the release number for the release */
1025: IF g_document_subtype = 'RELEASE' THEN
1026: l_progress:= '130';

Line 1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1048: p_progress => l_progress);
1049: END IF;
1050: wrapup(x_interface_header_id);
1051: --
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053:
1054: --set the org context back to original one
1055: IF (l_org_context_changed = 'Y') THEN
1056: PO_MOAC_UTILS_PVT.set_org_context(l_original_operating_unit_id) ; --

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

1067: else
1068: --when 0 lines are created, we assume that there is some erro happened
1069: --which is not related to manual PO numbering.
1070: x_errorcode:=3;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; --
1072: end if;
1073: end if; --Num_line_checked
1074: --
1075: else --Calls other than Sourcing and Consumption Advice

Line 1077: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1073: end if; --Num_line_checked
1074: --
1075: else --Calls other than Sourcing and Consumption Advice
1076: if x_number_lines>0 and x_document_id is not null then
1077: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1078: --
1079: -- Need to populate document number for autocreate success message
1080: IF g_document_subtype = 'STANDARD' THEN
1081: select segment1

Line 1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1084: where po_header_id = x_document_id;
1085: END IF;
1086: --
1087: else
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089: end if;
1090: end if; --check doc type
1091: --
1092:

Line 1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1161: END IF;
1162: wrapup(x_interface_header_id);
1163:
1164: --
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1166: --
1167: x_number_lines := g_number_records_processed;
1168: x_document_id := null;
1169: x_document_number := null;

Line 2420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

2416: p_token => l_progress,
2417: p_message => 'after call okc_terms_copy_grp.copy_doc.Return status:'||l_return_status);
2418: END IF;
2419:
2420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
2421: RAISE l_Contracts_call_exception;
2422: END IF; -- Return status from contracts
2423:
2424: END IF; -- if p_conterms_exist_flag and sourcing doc

Line 2532: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2528: PO_TAX_INTERFACE_PVT.calculate_tax( x_return_status => l_return_status,
2529: p_po_header_id => tax_document_id,
2530: p_po_release_id => NULL,
2531: p_calling_program => 'POXBWVRP_PO');
2532: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2533: l_progress := '414';
2534: IF g_interface_source_code = 'CONSUMPTION_ADVICE' THEN
2535: ROLLBACK TO TAX_CALCULATION_ERROR;
2536: x_document_id := NULL;

Line 2562: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2558: PO_TAX_INTERFACE_PVT.calculate_tax(x_return_status => l_return_status,
2559: p_po_header_id => NULL,
2560: p_po_release_id => tax_document_id,
2561: p_calling_program => 'POXBWVRP_PO');
2562: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2563: IF g_interface_source_code = 'CONSUMPTION_ADVICE' THEN
2564: ROLLBACK TO TAX_CALCULATION_ERROR;
2565: x_document_id := NULL;
2566: fnd_message.set_name('PO','PO_API_ERROR');

Line 8102: p_init_msg_list => FND_API.G_TRUE,

8098:
8099: -- Get the Transaction Flow Header ID from the Inventory API.
8100: -- Use the wrapper API written in PO.
8101: PO_SHARED_PROC_PVT.check_transaction_flow(
8102: p_init_msg_list => FND_API.G_TRUE,
8103: x_return_status => l_return_status, -- OUT NOCOPY VARCHAR2
8104: p_start_ou_id => g_purchasing_ou_id,
8105: p_end_ou_id => l_destination_ou_id,
8106: p_ship_to_org_id => l_destination_organization_id,

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

8117: ||l_return_status);
8118: END IF;
8119:
8120: l_progress := '060';
8121: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8122: APP_EXCEPTION.raise_exception(
8123: exception_type => 'PO_SHARED_PROC_PVT.check_transaction_flow',
8124: exception_code => 0,
8125: exception_text => 'return_status='||l_return_status);

Line 8139: IF l_return_status <> FND_API.g_ret_sts_success THEN

8135: (x_return_status => l_return_status,
8136: p_item_id => l_item_id,
8137: p_transaction_flow_header_id => l_transaction_flow_header_id,
8138: x_item_in_linv_pou => l_item_in_linv_pou);
8139: IF l_return_status <> FND_API.g_ret_sts_success THEN
8140: APP_EXCEPTION.raise_exception(
8141: exception_type => 'PO_SHARED_PROC_PVT.check_item_in_linv_pou',
8142: exception_code => 0,
8143: exception_text => 'return_status='||l_return_status);

Line 8144: ELSIF l_return_status = FND_API.g_ret_sts_success AND

8140: APP_EXCEPTION.raise_exception(
8141: exception_type => 'PO_SHARED_PROC_PVT.check_item_in_linv_pou',
8142: exception_code => 0,
8143: exception_text => 'return_status='||l_return_status);
8144: ELSIF l_return_status = FND_API.g_ret_sts_success AND
8145: (l_item_in_linv_pou <> 'Y') THEN
8146: IF g_debug_stmt THEN
8147: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
8148: p_token => l_progress,

Line 13785: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

13781: x_msg_data => l_msg_data,
13782: p_caller => 'AUTOCREATE',
13783: x_po_gms_interface_obj => l_gms_po_interface_obj);
13784:
13785: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13786: RAISE FND_API.G_EXC_ERROR;
13787: END IF;
13788:
13789: l_progress := '020';

Line 13786: RAISE FND_API.G_EXC_ERROR;

13782: p_caller => 'AUTOCREATE',
13783: x_po_gms_interface_obj => l_gms_po_interface_obj);
13784:
13785: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13786: RAISE FND_API.G_EXC_ERROR;
13787: END IF;
13788:
13789: l_progress := '020';
13790:

Line 13826: WHEN FND_API.G_EXC_ERROR THEN

13822: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
13823: END IF;
13824: EXCEPTION
13825:
13826: WHEN FND_API.G_EXC_ERROR THEN
13827: IF FND_MSG_PUB.check_msg_level(
13828: p_message_level => FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
13829: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
13830: p_procedure_name => l_api_name);

Line 13837: p_encoded => FND_API.G_FALSE),

13833: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
13834:
13835: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
13836: l_msg_buf := SUBSTRB(FND_MSG_PUB.get(p_msg_index => i,
13837: p_encoded => FND_API.G_FALSE),
13838: 1, 2000);
13839: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,
13840: p_token => l_progress,
13841: p_message => 'EXCEPTION: '|| l_msg_buf);

Line 13845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

13841: p_message => 'EXCEPTION: '|| l_msg_buf);
13842: END LOOP;
13843:
13844: END IF;
13845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13846:
13847: WHEN OTHERS THEN
13848: IF g_debug_unexp THEN --< Bug 3210331: use proper debugging >
13849: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name,

Line 14859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

14855: d_progress := 50;
14856: IF (PO_LOG.d_exc) THEN
14857: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
14858: END IF;
14859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14860: END IF;
14861:
14862: END IF; -- if params.po_encumbrance_flag = 'Y' AND ...
14863:

Line 15033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

15029: d_progress := 100;
15030: IF (PO_LOG.d_exc) THEN
15031: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
15032: END IF;
15033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15034: END IF;
15035:
15036: END IF; -- if params.po_encumbrance_flag = 'Y' AND ...
15037: