DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on FND_API

Line 529: p_init_msg_list => FND_API.G_TRUE,

525: end if;
526: commit;
527: PO_Document_Control_GRP.control_document
528: (p_api_version => 1.0,
529: p_init_msg_list => FND_API.G_TRUE,
530: p_commit => FND_API.G_TRUE,
531: x_return_status => x_return_status,
532: p_doc_type => p_can_doc_type,
533: p_doc_subtype => p_can_doc_subtype,

Line 530: p_commit => FND_API.G_TRUE,

526: commit;
527: PO_Document_Control_GRP.control_document
528: (p_api_version => 1.0,
529: p_init_msg_list => FND_API.G_TRUE,
530: p_commit => FND_API.G_TRUE,
531: x_return_status => x_return_status,
532: p_doc_type => p_can_doc_type,
533: p_doc_subtype => p_can_doc_subtype,
534: p_doc_id => p_can_hdr_id,

Line 581: x_return_status := FND_API.G_RET_STS_SUCCESS;

577: end if;
578: commit;
579:
580: if(l_cancel_flag = 'Y') then
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582: end if;
583:
584: exception when others then
585: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

585: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
586: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
587: l_api_name || '.others_exception', sqlerrm);
588: END IF;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: --Restoring PO's Authorization status back to "IN PROCESS".
591: if(p_can_rel_id is null) then
592: update po_headers_all
593: set authorization_status = 'IN PROCESS'

Line 662: x_return_status := FND_API.G_RET_STS_SUCCESS;

658: and request_level = 'HEADER'
659: and request_status = 'BUYER_APP';
660:
661: begin
662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663:
664: --Calling PO Cancel API to process Shipment level Cancellation approved by the buyer.
665: open l_cancel_ship_csr(p_chg_req_grp_id);
666: loop

Line 725: x_return_status := FND_API.G_RET_STS_ERROR;

721: l_cancel_backing_req);
722:
723: --If PO Cancel API fails, we'll assume buyer has rejected the cancellation request
724: if(l_return_status <> 'S') then
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: update po_change_requests
727: set request_status = 'REJECTED',
728: response_reason = l_ship_can_err_msg,
729: validation_error = l_ship_can_err_msg

Line 792: x_return_status := FND_API.G_RET_STS_ERROR;

788: 'N');
789:
790: --If PO Cancel API fails, we'll assume buyer has rejected the cancellation request
791: if(l_return_status <> 'S') then
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: update po_change_requests
794: set request_status = 'REJECTED' ,
795: response_reason = l_hdr_can_err_msg,
796: validation_error = l_hdr_can_err_msg,

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

800: end loop;
801: close l_cancel_hdr_csr;
802:
803: exception when others then
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
806: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
807: l_api_name || '.others_exception', sqlerrm);
808: END IF;

Line 1329: x_return_status := FND_API.G_RET_STS_SUCCESS;

1325: Note => '',
1326: printFlag => 'N',
1327: CommunicatePriceChange => l_CommunicatePriceChange);
1328: x_return_msg:='005';
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330: exception when others then
1331: x_return_msg:='KO_U'||x_return_msg||sqlerrm;
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1333: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1328: x_return_msg:='005';
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330: exception when others then
1331: x_return_msg:='KO_U'||x_return_msg||sqlerrm;
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1333: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1334: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1335: l_api_name || '.others_exception', x_return_msg);
1336: END IF;

Line 5883: FND_API.G_FALSE,

5879: acknowledgement record.
5880: */
5881: PO_ACKNOWLEDGE_PO_GRP.Set_Header_Acknowledgement (
5882: 1.0,
5883: FND_API.G_FALSE,
5884: l_check_result,
5885: l_header_id,
5886: l_release_id );
5887:

Line 5944: FND_API.G_FALSE,

5940: where po_header_id = l_document_id;
5941: end if;
5942: x_progress := '002';
5943: PO_ACKNOWLEDGE_PO_GRP.carry_over_acknowledgement(1.0,
5944: FND_API.G_FALSE,
5945: l_carryover_status,
5946: l_header_id ,
5947: l_release_id ,
5948: l_revision_num);

Line 5949: if(l_carryover_status <> FND_API.G_RET_STS_SUCCESS) then

5945: l_carryover_status,
5946: l_header_id ,
5947: l_release_id ,
5948: l_revision_num);
5949: if(l_carryover_status <> FND_API.G_RET_STS_SUCCESS) then
5950: x_progress := '003';
5951: raise l_carryover_exception;
5952: end if;
5953: exception when others then

Line 6516: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN

6512: p_header_id,
6513: x_return_status,
6514: x_complex_flag);
6515:
6516: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
6517: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6519: g_module_prefix,
6520: x_progress || 'x_return_status=' || x_return_status || 'x_complex_flag ' || x_complex_flag);

Line 6969: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN

6965: p_header_id,
6966: x_return_status,
6967: x_complex_flag);
6968:
6969: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
6970: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6971: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6972: g_module_prefix,
6973: l_progress

Line 7189: x_return_status := FND_API.G_RET_STS_SUCCESS;

7185:
7186:
7187: BEGIN
7188:
7189: x_return_status := FND_API.G_RET_STS_SUCCESS;
7190:
7191:
7192: if p_release_id is not null then
7193: l_doc_id := p_release_id;

Line 7240: x_return_status := FND_API.G_RET_STS_ERROR;

7236: --This is just for double check.. This API should only be called when all changes are responded
7237: open l_pending_csr(p_chg_req_grp_id);
7238: fetch l_pending_csr into l_id;
7239: if (l_id is not null) then
7240: x_return_status := FND_API.G_RET_STS_ERROR;
7241: x_err_msg := 'PENDING RECORDS EXIST';
7242: close l_pending_csr;
7243: return;
7244: end if;

Line 7406: if(l_kickoff_status <> FND_API.G_RET_STS_SUCCESS) then

7402: p_release_id,
7403: l_kickoff_msg);
7404:
7405:
7406: if(l_kickoff_status <> FND_API.G_RET_STS_SUCCESS) then
7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7408: x_err_msg := 'STARTPOWF_ERROR:'||l_kickoff_msg;
7409: end if;
7410: */

Line 7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7403: l_kickoff_msg);
7404:
7405:
7406: if(l_kickoff_status <> FND_API.G_RET_STS_SUCCESS) then
7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7408: x_err_msg := 'STARTPOWF_ERROR:'||l_kickoff_msg;
7409: end if;
7410: */
7411: end if;

Line 7418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7414: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7415: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7416: l_api_name || '.others_exception', x_progress||':'||sqlerrm);
7417: END IF;
7418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7419: x_err_msg := x_progress||'*'||sqlerrm;
7420:
7421: END ProcessResponse;
7422:

Line 7811: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN

7807: p_header_id,
7808: x_ret_status,
7809: x_complex_flag);
7810:
7811: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
7812: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7814: g_module_prefix,
7815: l_progress

Line 7877: x_return_status := FND_API.G_RET_STS_SUCCESS;

7873:
7874: wf_engine.StartProcess( ItemType => 'POSCHORD',
7875: ItemKey => l_item_key);
7876:
7877: x_return_status := FND_API.G_RET_STS_SUCCESS;
7878: exception when others then
7879: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7880: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7881: l_api_name || '.others_exception', l_progress||':'||sqlerrm);

Line 7883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7879: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7880: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7881: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
7882: END IF;
7883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7884: end StartSupplierChangeWF;
7885:
7886:
7887: PROCEDURE initialize(p_employee_id in NUMBER,p_org_id IN NUMBER) IS