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.

[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on FND_API

Line 3800: x_return_status := FND_API.g_ret_sts_success;

3796: SAVEPOINT CREATE_BASE_COPY;
3797:
3798: v_progress := '001';
3799: x_to_req_header_id := NULL;
3800: x_return_status := FND_API.g_ret_sts_success;
3801: x_return_msg := NULL;
3802:
3803: v_progress := '002';
3804: /* Call the procedure to copy the header*/

Line 3871: x_return_status := FND_API.g_ret_sts_success;

3867: l_log_msg VARCHAR2(2000);
3868: BEGIN
3869:
3870: v_progress := '000';
3871: x_return_status := FND_API.g_ret_sts_success;
3872: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3873: l_log_msg := v_progress||': Inside procedure '||l_procedure_name;
3874: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3875: l_log_msg := 'p_from_req_header_id: ' ||p_from_req_header_id;

Line 4116: x_return_status := FND_API.g_ret_sts_error;

4112: EXCEPTION
4113: WHEN OTHERS THEN
4114:
4115: x_return_msg := SQLERRM;
4116: x_return_status := FND_API.g_ret_sts_error;
4117:
4118: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4119: l_log_msg := v_progress||' : Exception at copy_header: '|| SQLERRM;
4120: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 4153: x_return_status := fnd_api.G_RET_STS_SUCCESS;

4149: BEGIN
4150:
4151: v_progress := '000';
4152:
4153: x_return_status := fnd_api.G_RET_STS_SUCCESS;
4154:
4155: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4156: l_log_msg := v_progress||': Inside procedure '||l_procedure_name;
4157: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 4724: x_return_status := FND_API.g_ret_sts_error;

4720: EXCEPTION
4721: WHEN OTHERS THEN
4722:
4723: x_return_msg := SQLERRM;
4724: x_return_status := FND_API.g_ret_sts_error;
4725:
4726: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4727: l_log_msg := v_progress||' : Exception at copy_lines: '|| SQLERRM;
4728: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 4749: x_return_status := fnd_api.G_RET_STS_SUCCESS;

4745:
4746: BEGIN
4747:
4748: v_progress := '000';
4749: x_return_status := fnd_api.G_RET_STS_SUCCESS;
4750: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4751: l_log_msg := v_progress||': Inside procedure '||l_procedure_name;
4752: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
4753: l_log_msg := 'p_from_req_line_id: ' ||p_from_req_line_id || ' p_to_req_line_id: '||p_to_req_line_id;

Line 4939: x_return_status := FND_API.g_ret_sts_error;

4935: EXCEPTION
4936: WHEN OTHERS THEN
4937:
4938: x_return_msg := SQLERRM;
4939: x_return_status := FND_API.g_ret_sts_error;
4940:
4941: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4942: l_log_msg := v_progress||' : Exception at copy_distributions: '|| SQLERRM;
4943: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

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

5062: x_to_req_header_id => l_to_req_header_id,
5063: x_return_status => l_return_status,
5064: x_return_msg => l_return_msg);
5065:
5066: if(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
5067: x_progress := 'POR_AMENDMENT_PKG.CREATE_BASE_VERSION: 03 - Exception : l_return_msg';
5068: raise copy_doc_exception;
5069: end if;
5070:

Line 5632: l_return_status varchar2(1) := FND_API.g_ret_sts_success;

5628: v_progress VARCHAR2(10);
5629: l_procedure_name VARCHAR2(100) := 'create_cancel_amendment';
5630: l_log_msg VARCHAR2(2000);
5631: l_to_req_header_id number := NULL;
5632: l_return_status varchar2(1) := FND_API.g_ret_sts_success;
5633: l_return_msg varchar2(2000) := null;
5634: l_revision_num number :=0;
5635:
5636: BEGIN

Line 5638: x_return_status := FND_API.g_ret_sts_success;

5634: l_revision_num number :=0;
5635:
5636: BEGIN
5637:
5638: x_return_status := FND_API.g_ret_sts_success;
5639:
5640: v_progress := '000';
5641: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
5642: l_log_msg := v_progress||': Inside procedure '||l_procedure_name;

Line 5691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5687: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
5688: l_log_msg := v_progress||' : Exception at CREATE_CANCEL_AMENDMENT: '|| SQLERRM;
5689: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
5690: END IF;
5691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5692:
5693: END create_cancel_amendment;
5694:
5695:

Line 7651: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

7647:
7648: IF (g_po_wf_debug = 'Y') THEN
7649: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'MergeReserveAutonomous - Return Status: '|| l_return_status );
7650: END IF;
7651: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
7652: OR l_return_status IS NULL) THEN
7653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7654: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
7655: IF (l_req_encumbrance_on)

Line 7653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7649: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'MergeReserveAutonomous - Return Status: '|| l_return_status );
7650: END IF;
7651: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
7652: OR l_return_status IS NULL) THEN
7653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7654: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
7655: IF (l_req_encumbrance_on)
7656: AND
7657: (

Line 7654: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

7650: END IF;
7651: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
7652: OR l_return_status IS NULL) THEN
7653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7654: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
7655: IF (l_req_encumbrance_on)
7656: AND
7657: (
7658: l_po_return_code NOT IN ( po_document_funds_pvt.g_return_success,

Line 7679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7675: resultout := 'COMPLETE:'|| 'Y';
7676: RETURN;
7677:
7678: EXCEPTION
7679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7680: wf_core.Context('POR_AMENDMENT_PKG','CLM_REQ_MERGE_RESERVE', x_progress);
7681: RAISE;
7682: WHEN OTHERS THEN
7683: x_progress := 'POR_AMENDMENT_PKG.CLM_REQ_MERGE_RESERVE: Do Reserve. Return Status.'||l_return_status;

Line 7768: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7764:
7765: IF (g_po_wf_debug = 'Y') THEN
7766: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Do Reserve Completed with Return Status: '||l_return_status);
7767: END IF;
7768: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7770: END IF;
7771:
7772: END IF;

Line 7769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7765: IF (g_po_wf_debug = 'Y') THEN
7766: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Do Reserve Completed with Return Status: '||l_return_status);
7767: END IF;
7768: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7770: END IF;
7771:
7772: END IF;
7773: IF p_amendment_approval = 'Y' THEN

Line 7778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7774:
7775: l_result := po_supply.Create_req(p_conformed_header_id,'REQ HDR');
7776: IF NOT l_result THEN
7777: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Create Req Supply failed for Confirmed Header Id : '||p_conformed_header_id);
7778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7779: END IF;
7780: END IF;
7781: x_return_status := FND_API.G_RET_STS_SUCCESS;
7782: COMMIT;

Line 7781: x_return_status := FND_API.G_RET_STS_SUCCESS;

7777: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,'Create Req Supply failed for Confirmed Header Id : '||p_conformed_header_id);
7778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7779: END IF;
7780: END IF;
7781: x_return_status := FND_API.G_RET_STS_SUCCESS;
7782: COMMIT;
7783: EXCEPTION
7784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7785: ROLLBACK TO Clm_MergeReserve_Autonomous_SP;

Line 7784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7780: END IF;
7781: x_return_status := FND_API.G_RET_STS_SUCCESS;
7782: COMMIT;
7783: EXCEPTION
7784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7785: ROLLBACK TO Clm_MergeReserve_Autonomous_SP;
7786: wf_core.context('PO_REQAPPROVAL_ACTION','ReserveAutonomous', x_progress);
7787: RAISE;
7788: WHEN OTHERS THEN

Line 8186: , p_commit => FND_API.G_TRUE

8182: COMMIT;
8183:
8184: PO_DOCUMENT_FUNDS_GRP.do_cancel(
8185: p_api_version => 1.0
8186: , p_commit => FND_API.G_TRUE
8187: , p_init_msg_list => FND_API.G_FALSE
8188: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8189: , x_return_status => l_return_status
8190: , p_doc_type => PO_DOCUMENT_FUNDS_GRP.g_doc_type_REQUISITION

Line 8187: , p_init_msg_list => FND_API.G_FALSE

8183:
8184: PO_DOCUMENT_FUNDS_GRP.do_cancel(
8185: p_api_version => 1.0
8186: , p_commit => FND_API.G_TRUE
8187: , p_init_msg_list => FND_API.G_FALSE
8188: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8189: , x_return_status => l_return_status
8190: , p_doc_type => PO_DOCUMENT_FUNDS_GRP.g_doc_type_REQUISITION
8191: , p_doc_subtype => NULL

Line 8188: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

8184: PO_DOCUMENT_FUNDS_GRP.do_cancel(
8185: p_api_version => 1.0
8186: , p_commit => FND_API.G_TRUE
8187: , p_init_msg_list => FND_API.G_FALSE
8188: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
8189: , x_return_status => l_return_status
8190: , p_doc_type => PO_DOCUMENT_FUNDS_GRP.g_doc_type_REQUISITION
8191: , p_doc_subtype => NULL
8192: , p_doc_level => 'LINE'

Line 8202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status IS NULL THEN

8198: , x_po_return_code => l_po_return_code
8199: , x_detailed_results => l_detailed_results
8200: );
8201:
8202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status IS NULL THEN
8203:
8204: UPDATE po_requisition_lines_all set amendment_response_reason = 'Cancel Funds failed. Contact Purchasing Administrator if necessary.',
8205: amendment_status = 'R',
8206: amendment_type = 'CANCELLED'