eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on FND_API

Line 604: p_init_msg_list => FND_API.G_FALSE,

600: -- req change.
601: if(l_doc_status = 'APPROVED') then
602: PO_CHG_REQUEST_PVT.validate_change_request (
603: p_api_version => 1.0,
604: p_init_msg_list => FND_API.G_FALSE,
605: x_return_status => l_return_status,
606: x_msg_data => l_msg_data,
607: p_po_header_id => p_po_header_id,
608: p_po_release_id => p_po_release_id,

Line 653: p_Init_Msg_List =>FND_API.G_FALSE,

649: x_progress :='PO_ReqChangeRequestWF_PVT.ValidateAndSaveRequest:005';
650:
651: PO_CHG_REQUEST_PVT.save_request(
652: p_api_version =>1.0,
653: p_Init_Msg_List =>FND_API.G_FALSE,
654: x_return_status =>l_return_status,
655: p_po_header_id =>p_po_header_id,
656: p_po_release_id =>p_po_release_id,
657: p_revision_num =>p_revision_num,

Line 688: p_Init_Msg_List =>FND_API.G_FALSE,

684: -- it will be done when the PO is back to approved status
685: x_progress :='PO_ReqChangeRequestWF_PVT.ValidateAndSaveRequest:009';
686: PO_CHG_REQUEST_PVT.save_request(
687: p_api_version =>1.0,
688: p_Init_Msg_List =>FND_API.G_FALSE,
689: x_return_status =>l_return_status,
690: p_po_header_id =>p_po_header_id,
691: p_po_release_id =>p_po_release_id,
692: p_revision_num =>p_revision_num,

Line 754: if(l_return_status<>FND_API.G_RET_STS_SUCCESS) then

750: p_rec_tax =>l_recoverable_tax,
751: p_nonrec_tax =>l_nonrecoverable_tax);
752:
753: x_progress :='0'||l_return_status;
754: if(l_return_status<>FND_API.G_RET_STS_SUCCESS) then
755: raise g_update_data_exp;
756: end if;
757: update po_req_distributions_all
758: set req_line_quantity=p_new_quantity,

Line 825: if(l_return_status<>FND_API.G_RET_STS_SUCCESS) then

821: p_quantity =>null,
822: p_dist_amount => null,
823: p_rec_tax =>l_recoverable_tax,
824: p_nonrec_tax =>l_nonrecoverable_tax);
825: if(l_return_status<>FND_API.G_RET_STS_SUCCESS) then
826: raise g_update_data_exp;
827: end if;
828:
829: x_progress :='002-'||to_char(l_distributions_id);

Line 1531: p_init_msg_list => FND_API.G_FALSE,

1527:
1528: x_progress :='010';
1529: PO_CHG_REQUEST_PVT.validate_change_request (
1530: p_api_version => 1.0,
1531: p_init_msg_list => FND_API.G_FALSE,
1532: x_return_status => l_return_status,
1533: x_msg_data => l_msg_data,
1534: p_po_header_id => ll_document_header_id,
1535: p_po_release_id => ll_po_release_id,

Line 2011: p_init_msg_list => FND_API.G_FALSE,

2007: commit;
2008:
2009: PO_Document_Control_GRP.control_document
2010: (p_api_version => 1.0,
2011: p_init_msg_list => FND_API.G_FALSE,
2012: p_commit => FND_API.G_TRUE,
2013: x_return_status => l_return_status,
2014: p_doc_type => l_document_type,
2015: p_doc_subtype => l_document_subtype ,

Line 2012: p_commit => FND_API.G_TRUE,

2008:
2009: PO_Document_Control_GRP.control_document
2010: (p_api_version => 1.0,
2011: p_init_msg_list => FND_API.G_FALSE,
2012: p_commit => FND_API.G_TRUE,
2013: x_return_status => l_return_status,
2014: p_doc_type => l_document_type,
2015: p_doc_subtype => l_document_subtype ,
2016: p_doc_id => l_document_id,

Line 2046: IF(l_return_status = FND_API.g_ret_sts_success) THEN

2042: close cancel_request;
2043: x_progress:='CANCELLATION:004';
2044:
2045: --Update change request status for success case
2046: IF(l_return_status = FND_API.g_ret_sts_success) THEN
2047: -- accept the po cancel request and req cancel request
2048: -- fix bug 2733303.
2049: -- when buyer response to the po change, the response_date
2050: -- response_reason and resonded_by is not carried back to

Line 2136: IF (l_return_status = FND_API.g_ret_sts_error) THEN

2132:
2133: -- Raise the exceptions here, to handle the error case to
2134: -- continue workflow. In case of unexpected exception, raise back the
2135: -- error and make the error process to handle them.
2136: IF (l_return_status = FND_API.g_ret_sts_error) THEN
2137: RAISE FND_API.g_exc_error;
2138: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
2139: RAISE FND_API.g_exc_unexpected_error;
2140: END IF;

Line 2137: RAISE FND_API.g_exc_error;

2133: -- Raise the exceptions here, to handle the error case to
2134: -- continue workflow. In case of unexpected exception, raise back the
2135: -- error and make the error process to handle them.
2136: IF (l_return_status = FND_API.g_ret_sts_error) THEN
2137: RAISE FND_API.g_exc_error;
2138: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
2139: RAISE FND_API.g_exc_unexpected_error;
2140: END IF;
2141:

Line 2138: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

2134: -- continue workflow. In case of unexpected exception, raise back the
2135: -- error and make the error process to handle them.
2136: IF (l_return_status = FND_API.g_ret_sts_error) THEN
2137: RAISE FND_API.g_exc_error;
2138: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
2139: RAISE FND_API.g_exc_unexpected_error;
2140: END IF;
2141:
2142: exception

Line 2139: RAISE FND_API.g_exc_unexpected_error;

2135: -- error and make the error process to handle them.
2136: IF (l_return_status = FND_API.g_ret_sts_error) THEN
2137: RAISE FND_API.g_exc_error;
2138: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
2139: RAISE FND_API.g_exc_unexpected_error;
2140: END IF;
2141:
2142: exception
2143: -- In case of error, set the change request status to Rejected and

Line 2145: when FND_API.g_exc_error then

2141:
2142: exception
2143: -- In case of error, set the change request status to Rejected and
2144: -- continue the workflow.
2145: when FND_API.g_exc_error then
2146: -- automacally reject the cancel request.
2147: -- additionally updating the validation_error field with the message stack populated
2148: -- by cancel api(if no. of message is 1).
2149:

Line 2416: RAISE FND_API.g_exc_error;

2412: raise l_po_cancel_api;
2413: end if;
2414: */
2415: IF (l_return_code = 1) THEN
2416: RAISE FND_API.g_exc_error;
2417: ELSIF (l_return_code= 2) THEN
2418: RAISE FND_API.g_exc_unexpected_error;
2419: END IF;
2420:

Line 2418: RAISE FND_API.g_exc_unexpected_error;

2414: */
2415: IF (l_return_code = 1) THEN
2416: RAISE FND_API.g_exc_error;
2417: ELSIF (l_return_code= 2) THEN
2418: RAISE FND_API.g_exc_unexpected_error;
2419: END IF;
2420:
2421: -- fix bug 2733303.
2422: -- when buyer response to the po change, the response_date

Line 2521: when FND_API.g_exc_error then

2517: --bug 13917584 ends
2518: close update_allocation_csr ;
2519: exception
2520: --In case of error, continue workflow
2521: when FND_API.g_exc_error then
2522: rollback to PO_REQCHANGEREQUESTWF_PVT_SP;
2523:
2524: update PO_CHANGE_REQUESTS
2525: set request_status='REJECTED',

Line 2816: RAISE FND_API.g_exc_error;

2812: -- Api returns 0,1 or 2. In case of 1, rollback the changes
2813: -- and reject the change request.
2814:
2815: IF (l_return_code = 1) THEN
2816: RAISE FND_API.g_exc_error;
2817: ELSIF (l_return_code= 2) THEN
2818:
2819: RAISE FND_API.g_exc_unexpected_error;
2820: END IF;

Line 2819: RAISE FND_API.g_exc_unexpected_error;

2815: IF (l_return_code = 1) THEN
2816: RAISE FND_API.g_exc_error;
2817: ELSIF (l_return_code= 2) THEN
2818:
2819: RAISE FND_API.g_exc_unexpected_error;
2820: END IF;
2821:
2822: -- fix bug 2733303.
2823: -- when buyer response to the po change, the response_date

Line 2896: when FND_API.g_exc_error then

2892:
2893: exception
2894: --In case of error, rollback
2895:
2896: when FND_API.g_exc_error then
2897: rollback to PO_REQCHANGEREQUESTWF_PVT_SP;
2898:
2899: update PO_CHANGE_REQUESTS
2900: set request_status='REJECTED',

Line 7575: if(p_return_status=FND_API.G_RET_STS_SUCCESS) then

7571: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
7572: */
7573: po_sup_chg_request_wf_grp.KickOffPOApproval(1, p_return_status,
7574: p_po_header_id, p_po_release_id, p_return_msg);
7575: if(p_return_status=FND_API.G_RET_STS_SUCCESS) then
7576: commit;
7577: end if;
7578: exception
7579: when others then

Line 7671: l_return_status := FND_API.G_RET_STS_SUCCESS;

7667: --rejected, there will be no change reqeust in BUY_APP. So,
7668: --the document_id cursor will not fetch records. So, call
7669: --KickOffPOApproval only if either l_header_id or l_release_id
7670: --is not null
7671: l_return_status := FND_API.G_RET_STS_SUCCESS;
7672:
7673: IF ( (l_header_id is not null) OR (l_release_id is not null)) THEN
7674: KickOffPOApproval(l_header_id,l_release_id, l_return_status, l_return_msg);
7675: END IF;

Line 7679: if(l_return_status<>FND_API.G_RET_STS_SUCCESS) then

7675: END IF;
7676: --po_sup_chg_request_wf_grp.KickOffPOApproval(1, l_return_status, l_header_id, l_release_id, l_return_msg);
7677: --PO_ChangeOrderWF_GRP.KickOffPOApproval(1, l_return_status, l_header_id, l_release_id, l_return_msg);
7678:
7679: if(l_return_status<>FND_API.G_RET_STS_SUCCESS) then
7680: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF:-'||l_return_status||'-'||to_char(l_header_id)||'-'||to_char(l_release_id)||'-'||l_return_msg;
7681: raise l_exception;
7682: else
7683: x_progress := 'PO_ReqChangeRequestWF_PVT.Start_Poapprv_WF: 03';

Line 9043: p_init_msg_list in varchar2:=FND_API.G_FALSE,

9039: * Returns:
9040: ************************************************************************/
9041: Procedure Process_Cancelled_Req_Lines(
9042: p_api_version in number,
9043: p_init_msg_list in varchar2:=FND_API.G_FALSE,
9044: p_commit in varchar2 :=FND_API.G_FALSE,
9045: x_return_status out NOCOPY varchar2,
9046: x_msg_count out NOCOPY number,
9047: x_msg_data out NOCOPY varchar2,

Line 9044: p_commit in varchar2 :=FND_API.G_FALSE,

9040: ************************************************************************/
9041: Procedure Process_Cancelled_Req_Lines(
9042: p_api_version in number,
9043: p_init_msg_list in varchar2:=FND_API.G_FALSE,
9044: p_commit in varchar2 :=FND_API.G_FALSE,
9045: x_return_status out NOCOPY varchar2,
9046: x_msg_count out NOCOPY number,
9047: x_msg_data out NOCOPY varchar2,
9048: p_CanceledReqLineIDs_tbl in ReqLineID_tbl_type) is

Line 9088: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

9084: (select pcr2.change_request_id
9085: from po_change_requests pcr2
9086: where pcr2.parent_change_request_id=pcr1.change_request_id);
9087: begin
9088: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9089: l_api_name, g_pkg_name) THEN
9090: RAISE FND_API.g_exc_unexpected_error;
9091: END IF;
9092:

Line 9090: RAISE FND_API.g_exc_unexpected_error;

9086: where pcr2.parent_change_request_id=pcr1.change_request_id);
9087: begin
9088: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9089: l_api_name, g_pkg_name) THEN
9090: RAISE FND_API.g_exc_unexpected_error;
9091: END IF;
9092:
9093: IF FND_API.to_boolean(p_init_msg_list) THEN
9094: FND_MSG_PUB.initialize;

Line 9093: IF FND_API.to_boolean(p_init_msg_list) THEN

9089: l_api_name, g_pkg_name) THEN
9090: RAISE FND_API.g_exc_unexpected_error;
9091: END IF;
9092:
9093: IF FND_API.to_boolean(p_init_msg_list) THEN
9094: FND_MSG_PUB.initialize;
9095: END IF;
9096:
9097: l_index:=p_CanceledReqLineIDs_tbl.FIRST;

Line 9194: IF FND_API.to_boolean(p_commit) THEN

9190: l_index:=p_CanceledReqLineIDs_tbl.next(l_index);
9191: end loop;
9192:
9193: -- Standard API check of p_commit
9194: IF FND_API.to_boolean(p_commit) THEN
9195: COMMIT WORK;
9196: END IF;
9197:
9198: x_return_status:=FND_API.g_ret_sts_success;

Line 9198: x_return_status:=FND_API.g_ret_sts_success;

9194: IF FND_API.to_boolean(p_commit) THEN
9195: COMMIT WORK;
9196: END IF;
9197:
9198: x_return_status:=FND_API.g_ret_sts_success;
9199: EXCEPTION
9200: WHEN FND_API.g_exc_unexpected_error THEN
9201: x_return_status := FND_API.g_ret_sts_unexp_error;
9202: when others then

Line 9200: WHEN FND_API.g_exc_unexpected_error THEN

9196: END IF;
9197:
9198: x_return_status:=FND_API.g_ret_sts_success;
9199: EXCEPTION
9200: WHEN FND_API.g_exc_unexpected_error THEN
9201: x_return_status := FND_API.g_ret_sts_unexp_error;
9202: when others then
9203: x_return_status := FND_API.g_ret_sts_unexp_error;
9204: null;

Line 9201: x_return_status := FND_API.g_ret_sts_unexp_error;

9197:
9198: x_return_status:=FND_API.g_ret_sts_success;
9199: EXCEPTION
9200: WHEN FND_API.g_exc_unexpected_error THEN
9201: x_return_status := FND_API.g_ret_sts_unexp_error;
9202: when others then
9203: x_return_status := FND_API.g_ret_sts_unexp_error;
9204: null;
9205: end Process_Cancelled_Req_Lines;

Line 9203: x_return_status := FND_API.g_ret_sts_unexp_error;

9199: EXCEPTION
9200: WHEN FND_API.g_exc_unexpected_error THEN
9201: x_return_status := FND_API.g_ret_sts_unexp_error;
9202: when others then
9203: x_return_status := FND_API.g_ret_sts_unexp_error;
9204: null;
9205: end Process_Cancelled_Req_Lines;
9206:
9207:

Line 9251: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

9247: l_api_name CONSTANT VARCHAR2(30) := 'Submit_Req_Change';
9248: l_api_version CONSTANT NUMBER := 1.0;
9249:
9250: BEGIN
9251: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9252: l_api_name, g_pkg_name) THEN
9253: RAISE FND_API.g_exc_unexpected_error;
9254: END IF;
9255: x_return_status := FND_API.g_ret_sts_success;

Line 9253: RAISE FND_API.g_exc_unexpected_error;

9249:
9250: BEGIN
9251: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9252: l_api_name, g_pkg_name) THEN
9253: RAISE FND_API.g_exc_unexpected_error;
9254: END IF;
9255: x_return_status := FND_API.g_ret_sts_success;
9256: -- End standard API initialization
9257:

Line 9255: x_return_status := FND_API.g_ret_sts_success;

9251: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9252: l_api_name, g_pkg_name) THEN
9253: RAISE FND_API.g_exc_unexpected_error;
9254: END IF;
9255: x_return_status := FND_API.g_ret_sts_success;
9256: -- End standard API initialization
9257:
9258: open change_request_group_id;
9259: fetch change_request_group_id into l_change_request_group_id;

Line 9290: IF FND_API.to_boolean(p_commit) THEN

9286: DefaultApprovalPathID => NULL,
9287: note => p_note_to_approver,
9288: p_Initiator => p_initiator);
9289:
9290: IF FND_API.to_boolean(p_commit) THEN
9291: COMMIT WORK;
9292: END IF;
9293: EXCEPTION
9294: WHEN FND_API.g_exc_unexpected_error THEN

Line 9294: WHEN FND_API.g_exc_unexpected_error THEN

9290: IF FND_API.to_boolean(p_commit) THEN
9291: COMMIT WORK;
9292: END IF;
9293: EXCEPTION
9294: WHEN FND_API.g_exc_unexpected_error THEN
9295: x_return_status := FND_API.g_ret_sts_unexp_error;
9296: WHEN OTHERS THEN
9297: x_return_status := FND_API.g_ret_sts_unexp_error;
9298: RAISE;

Line 9295: x_return_status := FND_API.g_ret_sts_unexp_error;

9291: COMMIT WORK;
9292: END IF;
9293: EXCEPTION
9294: WHEN FND_API.g_exc_unexpected_error THEN
9295: x_return_status := FND_API.g_ret_sts_unexp_error;
9296: WHEN OTHERS THEN
9297: x_return_status := FND_API.g_ret_sts_unexp_error;
9298: RAISE;
9299: END;

Line 9297: x_return_status := FND_API.g_ret_sts_unexp_error;

9293: EXCEPTION
9294: WHEN FND_API.g_exc_unexpected_error THEN
9295: x_return_status := FND_API.g_ret_sts_unexp_error;
9296: WHEN OTHERS THEN
9297: x_return_status := FND_API.g_ret_sts_unexp_error;
9298: RAISE;
9299: END;
9300:
9301: /*************************************************************************

Line 9392: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

9388: and was.item_key=l_item_key
9389: and was.activity_name=activity
9390: and was.notification_id=wfn.notification_id;
9391: begin
9392: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9393: l_api_name, g_pkg_name) THEN
9394: RAISE FND_API.g_exc_unexpected_error;
9395: END IF;
9396:

Line 9394: RAISE FND_API.g_exc_unexpected_error;

9390: and was.notification_id=wfn.notification_id;
9391: begin
9392: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9393: l_api_name, g_pkg_name) THEN
9394: RAISE FND_API.g_exc_unexpected_error;
9395: END IF;
9396:
9397: x_return_status := FND_API.g_ret_sts_success;
9398:

Line 9397: x_return_status := FND_API.g_ret_sts_success;

9393: l_api_name, g_pkg_name) THEN
9394: RAISE FND_API.g_exc_unexpected_error;
9395: END IF;
9396:
9397: x_return_status := FND_API.g_ret_sts_success;
9398:
9399: update po_change_requests
9400: set request_status=p_acceptance_flag,
9401: change_active_flag=decode(p_acceptance_flag, 'REJECTED', 'N', 'Y'),

Line 9442: IF FND_API.to_boolean(p_commit) THEN

9438: end if;
9439: exception
9440: when others then null;
9441: end;
9442: IF FND_API.to_boolean(p_commit) THEN
9443: COMMIT WORK;
9444: END IF;
9445:
9446: EXCEPTION

Line 9448: x_return_status := FND_API.g_ret_sts_unexp_error;

9444: END IF;
9445:
9446: EXCEPTION
9447: when others then
9448: x_return_status := FND_API.g_ret_sts_unexp_error;
9449: end Record_Buyer_Response;
9450:
9451: Procedure Process_Buyer_Response(
9452: p_api_version in number,

Line 9495: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

9491: END IF;
9492:
9493: END IF;
9494:
9495: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9496: l_api_name, g_pkg_name) THEN
9497: IF (g_fnd_debug = 'Y') THEN
9498: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9499: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,

Line 9505: RAISE FND_API.g_exc_unexpected_error;

9501: message => 'api is not compatible');
9502: END IF;
9503: END IF;
9504:
9505: RAISE FND_API.g_exc_unexpected_error;
9506: END IF;
9507:
9508: x_progress:='001';
9509: x_return_status := FND_API.g_ret_sts_success;

Line 9509: x_return_status := FND_API.g_ret_sts_success;

9505: RAISE FND_API.g_exc_unexpected_error;
9506: END IF;
9507:
9508: x_progress:='001';
9509: x_return_status := FND_API.g_ret_sts_success;
9510: select PO_REQUESTER_CHANGE_WF_S.nextval into l_count from dual;
9511: item_key:='RESPONSE_'||to_char(p_change_request_group_id)||'_'||to_char(l_count);
9512:
9513: x_progress:='002';

Line 9602: x_return_status := FND_API.g_ret_sts_unexp_error;

9598: END IF;
9599:
9600: EXCEPTION
9601: when others then
9602: x_return_status := FND_API.g_ret_sts_unexp_error;
9603: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9604: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
9605: module => G_MODULE_NAME||'.'||l_procedure_name,
9606: message => 'x_progress:'||x_progress||'-sqlerrm:'||sqlerrm);

Line 10295: p_init_msg_list => FND_API.G_TRUE,

10291: BEGIN
10292:
10293: PO_CO_Tolerances_Grp.get_tolerances(
10294: p_api_version => 1.0,
10295: p_init_msg_list => FND_API.G_TRUE,
10296: p_organization_id => p_organization_id,
10297: p_change_order_type => po_co_tolerances_grp.g_rco_buy_app,
10298: x_tolerances_tbl => l_tolerances_tbl,
10299: x_return_status => l_return_status,

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

10299: x_return_status => l_return_status,
10300: x_msg_count => l_msg_count,
10301: x_msg_data => l_msg_data);
10302:
10303: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10304: IF (g_po_wf_debug = 'Y') THEN
10305: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,'PO_CO_Tolerances_Grp.get_tolerances API failed:' || l_return_status || ' ' || l_msg_data);
10306: END IF;
10307: END IF;

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

10645:
10646: -- kick off PO approval
10647: KickOffPOApproval(l_po_header_id, l_po_release_id, l_return_status, l_return_msg);
10648:
10649: IF (l_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
10650: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 11-'||l_return_status||'-'||to_char(l_po_header_id)||'-'||to_char(l_po_release_id)||'-'||l_return_msg;
10651: raise l_exception;
10652: else
10653: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 11';

Line 11840: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

11836: WHERE change_request_group_id = grp_id;
11837:
11838:
11839: BEGIN
11840: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
11841: l_api_name, g_pkg_name) THEN
11842:
11843: RAISE fnd_api.g_exc_unexpected_error;
11844: END IF;

Line 11843: RAISE fnd_api.g_exc_unexpected_error;

11839: BEGIN
11840: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
11841: l_api_name, g_pkg_name) THEN
11842:
11843: RAISE fnd_api.g_exc_unexpected_error;
11844: END IF;
11845: x_return_status := fnd_api.g_ret_sts_success;
11846: -- End standard API initialization
11847: l_progress := '001';

Line 11845: x_return_status := fnd_api.g_ret_sts_success;

11841: l_api_name, g_pkg_name) THEN
11842:
11843: RAISE fnd_api.g_exc_unexpected_error;
11844: END IF;
11845: x_return_status := fnd_api.g_ret_sts_success;
11846: -- End standard API initialization
11847: l_progress := '001';
11848:
11849: IF g_debug_stmt THEN

Line 11944: IF fnd_api.to_boolean(p_commit) THEN

11940: p_initiator => p_initiator,
11941: p_source_type_code => p_source_type_code);
11942:
11943:
11944: IF fnd_api.to_boolean(p_commit) THEN
11945: COMMIT WORK;
11946: END IF;
11947:
11948: l_progress := '004';

Line 11953: WHEN fnd_api.g_exc_unexpected_error THEN

11949: IF g_debug_stmt THEN
11950: po_debug.debug_stmt(l_log_head, l_progress,'ending submit_internal_req_change');
11951: END IF;
11952: EXCEPTION
11953: WHEN fnd_api.g_exc_unexpected_error THEN
11954: x_return_status := fnd_api.g_ret_sts_unexp_error;
11955: WHEN OTHERS THEN
11956: x_return_status := fnd_api.g_ret_sts_unexp_error;
11957:

Line 11954: x_return_status := fnd_api.g_ret_sts_unexp_error;

11950: po_debug.debug_stmt(l_log_head, l_progress,'ending submit_internal_req_change');
11951: END IF;
11952: EXCEPTION
11953: WHEN fnd_api.g_exc_unexpected_error THEN
11954: x_return_status := fnd_api.g_ret_sts_unexp_error;
11955: WHEN OTHERS THEN
11956: x_return_status := fnd_api.g_ret_sts_unexp_error;
11957:
11958: RAISE;

Line 11956: x_return_status := fnd_api.g_ret_sts_unexp_error;

11952: EXCEPTION
11953: WHEN fnd_api.g_exc_unexpected_error THEN
11954: x_return_status := fnd_api.g_ret_sts_unexp_error;
11955: WHEN OTHERS THEN
11956: x_return_status := fnd_api.g_ret_sts_unexp_error;
11957:
11958: RAISE;
11959: END submit_internal_req_change;
11960:

Line 12169: x_return_status :=fnd_api.g_ret_sts_success;

12165: l_msg_count number;
12166: l_msg_data varchar2(200);
12167: BEGIN
12168: l_return_status := 'Y';
12169: x_return_status :=fnd_api.g_ret_sts_success;
12170: l_progress := '000';
12171: /*
12172: Algorithm: this procedure gets called for every req int line
12173: place on SO .The changes are approved when this is called

Line 12338: IF (l_return_status = fnd_api.g_ret_sts_success) THEN --return status from OM API

12334: END IF;
12335:
12336:
12337:
12338: IF (l_return_status = fnd_api.g_ret_sts_success) THEN --return status from OM API
12339: -- for successful lines update the change request as accepted
12340: l_progress := '008';
12341: IF g_debug_stmt THEN
12342: po_debug.debug_stmt(l_log_head, l_progress,'for successful lines updating the change request as accepted');

Line 12439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

12435:
12436: EXCEPTION
12437: WHEN OTHERS THEN
12438: l_orgid := get_requisition_org( p_req_line_id => p_document_line_id);
12439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12440:
12441: IF l_orgid is NOT NULL THEN
12442: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
12443: END IF;

Line 12574: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

12570:
12571: l_progress := '005';
12572:
12573: -- error handling after calling populate_encumbrance_gt
12574: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
12575: IF g_debug_stmt THEN
12576: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
12577: END IF;
12578: RAISE fnd_api.g_exc_unexpected_error;

Line 12578: RAISE fnd_api.g_exc_unexpected_error;

12574: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
12575: IF g_debug_stmt THEN
12576: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
12577: END IF;
12578: RAISE fnd_api.g_exc_unexpected_error;
12579: END IF;
12580:
12581: -- re-initialize distributions list table
12582: l_distribution_id_tbl.delete;

Line 12668: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN

12664: IF g_debug_stmt THEN
12665: po_debug.debug_stmt(l_log_head, l_progress, 'FUNDS ADJUST:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
12666: END IF;
12667:
12668: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN
12669: IF g_debug_stmt THEN
12670: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
12671: END IF;
12672: RAISE fnd_api.g_exc_unexpected_error;

Line 12672: RAISE fnd_api.g_exc_unexpected_error;

12668: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN
12669: IF g_debug_stmt THEN
12670: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
12671: END IF;
12672: RAISE fnd_api.g_exc_unexpected_error;
12673: RETURN;
12674:
12675: ELSE
12676:

Line 12682: x_return_status := fnd_api.g_ret_sts_success;

12678: po_debug.debug_STmt(l_log_head, l_progress, 'after DO adjust of funds');
12679: END IF;
12680:
12681: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
12682: x_return_status := fnd_api.g_ret_sts_success;
12683: ELSE
12684: x_return_status := fnd_api.g_ret_sts_error;
12685: RAISE fnd_api.g_exc_unexpected_error;
12686: RETURN;

Line 12684: x_return_status := fnd_api.g_ret_sts_error;

12680:
12681: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
12682: x_return_status := fnd_api.g_ret_sts_success;
12683: ELSE
12684: x_return_status := fnd_api.g_ret_sts_error;
12685: RAISE fnd_api.g_exc_unexpected_error;
12686: RETURN;
12687: END IF;
12688:

Line 12685: RAISE fnd_api.g_exc_unexpected_error;

12681: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
12682: x_return_status := fnd_api.g_ret_sts_success;
12683: ELSE
12684: x_return_status := fnd_api.g_ret_sts_error;
12685: RAISE fnd_api.g_exc_unexpected_error;
12686: RETURN;
12687: END IF;
12688:
12689: END IF;

Line 12734: RAISE fnd_api.g_exc_unexpected_error;

12730: -- the above api takes care of primary uom conversion
12731: l_progress := '015';
12732:
12733: IF NOT l_bool_ret_sts THEN
12734: RAISE fnd_api.g_exc_unexpected_error;
12735: END IF;
12736: IF g_debug_stmt THEN
12737: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');
12738: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');

Line 12796: RAISE fnd_api.g_exc_unexpected_error;

12792: , p_receipt_date => p_need_by_date
12793: );
12794:
12795: IF NOT l_bool_ret_sts THEN
12796: RAISE fnd_api.g_exc_unexpected_error;
12797: END IF;
12798:
12799:
12800: x_progress := '003';

Line 12938: , p_commit => fnd_api.g_true

12934: -- cancel the encumbered funds
12935:
12936: PO_DOCUMENT_FUNDS_GRP.do_cancel(
12937: p_api_version => 1.0
12938: , p_commit => fnd_api.g_true
12939: , p_init_msg_list => fnd_api.g_false
12940: , p_validation_level=> FND_API.G_VALID_LEVEL_FULL
12941: , x_return_status =>l_return_status
12942: , p_doc_type =>PO_CORE_S.g_doc_type_REQUISITION

Line 12939: , p_init_msg_list => fnd_api.g_false

12935:
12936: PO_DOCUMENT_FUNDS_GRP.do_cancel(
12937: p_api_version => 1.0
12938: , p_commit => fnd_api.g_true
12939: , p_init_msg_list => fnd_api.g_false
12940: , p_validation_level=> FND_API.G_VALID_LEVEL_FULL
12941: , x_return_status =>l_return_status
12942: , p_doc_type =>PO_CORE_S.g_doc_type_REQUISITION
12943: , p_doc_subtype =>null

Line 12940: , p_validation_level=> FND_API.G_VALID_LEVEL_FULL

12936: PO_DOCUMENT_FUNDS_GRP.do_cancel(
12937: p_api_version => 1.0
12938: , p_commit => fnd_api.g_true
12939: , p_init_msg_list => fnd_api.g_false
12940: , p_validation_level=> FND_API.G_VALID_LEVEL_FULL
12941: , x_return_status =>l_return_status
12942: , p_doc_type =>PO_CORE_S.g_doc_type_REQUISITION
12943: , p_doc_subtype =>null
12944: , p_doc_level =>'LINE'

Line 12962: IF (l_return_status =FND_API.G_RET_STS_SUCCESS) then

12958: po_debug.debug_var(l_log_head,x_progress,'x_po_return_code ', l_po_return_code );
12959: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds after call');
12960: END IF;
12961:
12962: IF (l_return_status =FND_API.G_RET_STS_SUCCESS) then
12963:
12964: --update po req lines as cancel flag I
12965: --12831835 Added updation of quantity_cancelled
12966: -- bug 14407998 changes added LAST_UPDATED_BY, LAST_UPDATE_DATE colums in update stmt

Line 12984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

12980: -- quantity_cancelled = p_old_quantity,
12981: cancel_date =null
12982: WHERE requisition_line_id = p_req_line_id ;
12983:
12984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12985:
12986: END IF;
12987:
12988: ELSE -- IF (l_is_req_encumbrance ) THEN

Line 13045: RAISE fnd_api.g_exc_unexpected_error;

13041: , p_receipt_date => NULL
13042: );
13043:
13044: IF NOT l_bool_ret_sts THEN
13045: RAISE fnd_api.g_exc_unexpected_error;
13046: END IF;
13047: IF g_debug_stmt THEN
13048: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds');
13049: END IF;

Line 13443: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

13439:
13440: l_progress := '005';
13441:
13442: -- error handling after calling populate_encumbrance_gt
13443: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
13444: IF g_debug_stmt THEN
13445: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
13446: END IF;
13447: RAISE fnd_api.g_exc_unexpected_error;

Line 13447: RAISE fnd_api.g_exc_unexpected_error;

13443: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
13444: IF g_debug_stmt THEN
13445: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
13446: END IF;
13447: RAISE fnd_api.g_exc_unexpected_error;
13448: END IF;
13449:
13450: -- re-initialize distributions list table
13451: l_distribution_id_tbl.delete;

Line 13534: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN

13530: IF g_debug_stmt THEN
13531: po_debug.debug_stmt(l_log_head, l_progress, 'FUNDS ADJUST:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
13532: END IF;
13533:
13534: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN
13535: IF g_debug_stmt THEN
13536: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
13537: END IF;
13538: RAISE fnd_api.g_exc_unexpected_error;

Line 13538: RAISE fnd_api.g_exc_unexpected_error;

13534: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN
13535: IF g_debug_stmt THEN
13536: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
13537: END IF;
13538: RAISE fnd_api.g_exc_unexpected_error;
13539: RETURN;
13540:
13541: ELSE
13542:

Line 13548: x_return_status := fnd_api.g_ret_sts_success;

13544: po_debug.debug_STmt(l_log_head, l_progress, 'after DO adjust of funds');
13545: END IF;
13546:
13547: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
13548: x_return_status := fnd_api.g_ret_sts_success;
13549: ELSE
13550: x_return_status := fnd_api.g_ret_sts_error;
13551: RAISE fnd_api.g_exc_unexpected_error;
13552: RETURN;

Line 13550: x_return_status := fnd_api.g_ret_sts_error;

13546:
13547: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
13548: x_return_status := fnd_api.g_ret_sts_success;
13549: ELSE
13550: x_return_status := fnd_api.g_ret_sts_error;
13551: RAISE fnd_api.g_exc_unexpected_error;
13552: RETURN;
13553: END IF;
13554:

Line 13551: RAISE fnd_api.g_exc_unexpected_error;

13547: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
13548: x_return_status := fnd_api.g_ret_sts_success;
13549: ELSE
13550: x_return_status := fnd_api.g_ret_sts_error;
13551: RAISE fnd_api.g_exc_unexpected_error;
13552: RETURN;
13553: END IF;
13554:
13555: END IF;

Line 13649: RAISE fnd_api.g_exc_unexpected_error;

13645: END IF;
13646:
13647: l_progress := '020';
13648: IF NOT l_bool_ret_sts THEN
13649: RAISE fnd_api.g_exc_unexpected_error;
13650: END IF;
13651: IF g_debug_stmt THEN
13652: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');
13653: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');