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_CHANGEORDERWF_PVT dependencies on FND_API

Line 91: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

87: * Effects: Carry over the shipment_level acknowledgement results from the
88: * previous revision, it is called before launching PO approval
89: * workflow after supplier's change has been accepted by buyer.
90: * Returns:
91: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
92: * FND_API.G_RET_STS_ERROR if an error occurs
93: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
94: *
95: * Bugs Fixed:

Line 92: * FND_API.G_RET_STS_ERROR if an error occurs

88: * previous revision, it is called before launching PO approval
89: * workflow after supplier's change has been accepted by buyer.
90: * Returns:
91: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
92: * FND_API.G_RET_STS_ERROR if an error occurs
93: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
94: *
95: * Bugs Fixed:
96: * 7205793 - Added internal procedure, which is an autonomous transaction

Line 93: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

89: * workflow after supplier's change has been accepted by buyer.
90: * Returns:
91: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
92: * FND_API.G_RET_STS_ERROR if an error occurs
93: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
94: *
95: * Bugs Fixed:
96: * 7205793 - Added internal procedure, which is an autonomous transaction
97: * to avoid deadlock during PO Approval Process.

Line 514: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended

510: * Effects: Carry over the shipment_level acknowledgement results from the
511: * previous revision, it is called before launching PO approval
512: * workflow after supplier's change has been accepted by buyer.
513: * Returns:
514: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
515: * FND_API.G_RET_STS_ERROR if an error occurs
516: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
517: *
518: * Bugs Fixed:

Line 515: * FND_API.G_RET_STS_ERROR if an error occurs

511: * previous revision, it is called before launching PO approval
512: * workflow after supplier's change has been accepted by buyer.
513: * Returns:
514: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
515: * FND_API.G_RET_STS_ERROR if an error occurs
516: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
517: *
518: * Bugs Fixed:
519: * 7205793 - Added internal procedure, which is an autonomous transaction

Line 516: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

512: * workflow after supplier's change has been accepted by buyer.
513: * Returns:
514: * x_return_status - FND_API.G_RET_STS_SUCCESS if all messages are appended
515: * FND_API.G_RET_STS_ERROR if an error occurs
516: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
517: *
518: * Bugs Fixed:
519: * 7205793 - Added internal procedure, which is an autonomous transaction
520: * to avoid deadlock during PO Approval Process.

Line 537: FND_API.G_FALSE,

533: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name || '.invoked','Autonomous Transaction');
534: END IF;
535:
536: PO_ACKNOWLEDGE_PO_GRP.carry_over_acknowledgement(1.0,
537: FND_API.G_FALSE,
538: x_return_status,
539: p_po_header_id,
540: p_po_release_id,
541: p_revision_num);

Line 542: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

538: x_return_status,
539: p_po_header_id,
540: p_po_release_id,
541: p_revision_num);
542: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
543: raise l_carryover_exception;
544: end if;
545: commit;
546: exception when others then

Line 597: p_init_msg_list => FND_API.G_TRUE,

593: end if;
594: commit;
595: PO_Document_Control_GRP.control_document
596: (p_api_version => 1.0,
597: p_init_msg_list => FND_API.G_TRUE,
598: p_commit => FND_API.G_TRUE,
599: x_return_status => x_return_status,
600: p_doc_type => p_can_doc_type,
601: p_doc_subtype => p_can_doc_subtype,

Line 598: p_commit => FND_API.G_TRUE,

594: commit;
595: PO_Document_Control_GRP.control_document
596: (p_api_version => 1.0,
597: p_init_msg_list => FND_API.G_TRUE,
598: p_commit => FND_API.G_TRUE,
599: x_return_status => x_return_status,
600: p_doc_type => p_can_doc_type,
601: p_doc_subtype => p_can_doc_subtype,
602: p_doc_id => p_can_hdr_id,

Line 651: x_return_status := FND_API.G_RET_STS_SUCCESS;

647: end if;
648: commit;
649:
650: if(l_cancel_flag = 'Y') then
651: x_return_status := FND_API.G_RET_STS_SUCCESS;
652: end if;
653:
654: exception when others then
655: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

655: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
656: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
657: l_api_name || '.others_exception', sqlerrm);
658: END IF;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: --Restoring PO's Authorization status back to "IN PROCESS".
661: if(p_can_rel_id is null) then
662: update po_headers_all
663: set authorization_status = 'IN PROCESS'

Line 737: x_return_status := FND_API.G_RET_STS_SUCCESS;

733: and request_level = 'HEADER'
734: and request_status = 'BUYER_APP';
735:
736: begin
737: x_return_status := FND_API.G_RET_STS_SUCCESS;
738: /* Code changes for bug 13114334 - Start */
739: select count(*) into l_cancel_count
740: from po_change_requests
741: where change_request_group_id=p_chg_req_grp_id

Line 818: x_return_status := FND_API.G_RET_STS_ERROR;

814: );
815:
816: --If PO Cancel API fails, we'll assume buyer has rejected the cancellation request
817: if(l_return_status <> 'S') then
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: update po_change_requests
820: set request_status = 'REJECTED',
821: response_reason = l_ship_can_err_msg,
822: validation_error = l_ship_can_err_msg

Line 887: x_return_status := FND_API.G_RET_STS_ERROR;

883: );
884:
885: --If PO Cancel API fails, we'll assume buyer has rejected the cancellation request
886: if(l_return_status <> 'S') then
887: x_return_status := FND_API.G_RET_STS_ERROR;
888: update po_change_requests
889: set request_status = 'REJECTED' ,
890: response_reason = l_hdr_can_err_msg,
891: validation_error = l_hdr_can_err_msg,

Line 899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

895: end loop;
896: close l_cancel_hdr_csr;
897:
898: exception when others then
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
901: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
902: l_api_name || '.others_exception', sqlerrm);
903: END IF;

Line 1470: x_return_status := FND_API.G_RET_STS_SUCCESS;

1466: EmailFlag => l_email_flag,
1467: EmailAddress => l_email_address,
1468: CommunicatePriceChange => l_CommunicatePriceChange);
1469: x_return_msg:='005';
1470: x_return_status := FND_API.G_RET_STS_SUCCESS;
1471: exception when others then
1472: x_return_msg:='KO_U'||x_return_msg||sqlerrm;
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1469: x_return_msg:='005';
1470: x_return_status := FND_API.G_RET_STS_SUCCESS;
1471: exception when others then
1472: x_return_msg:='KO_U'||x_return_msg||sqlerrm;
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1475: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1476: l_api_name || '.others_exception', x_return_msg);
1477: END IF;

Line 6037: FND_API.G_FALSE,

6033: acknowledgement record.
6034: */
6035: PO_ACKNOWLEDGE_PO_GRP.Set_Header_Acknowledgement (
6036: 1.0,
6037: FND_API.G_FALSE,
6038: l_check_result,
6039: l_header_id,
6040: l_release_id );
6041:

Line 6098: FND_API.G_FALSE,

6094: where po_header_id = l_document_id;
6095: end if;
6096: x_progress := '002';
6097: /*PO_ACKNOWLEDGE_PO_GRP.carry_over_acknowledgement(1.0,
6098: FND_API.G_FALSE,
6099: l_carryover_status,
6100: l_header_id ,
6101: l_release_id ,
6102: l_revision_num);*/

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

6670: p_header_id,
6671: x_return_status,
6672: x_complex_flag);
6673:
6674: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
6675: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6676: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6677: g_module_prefix,
6678: x_progress || 'x_return_status=' || x_return_status || 'x_complex_flag ' || x_complex_flag);

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

7123: p_header_id,
7124: x_return_status,
7125: x_complex_flag);
7126:
7127: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
7128: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7130: g_module_prefix,
7131: l_progress

Line 7347: x_return_status := FND_API.G_RET_STS_SUCCESS;

7343:
7344:
7345: BEGIN
7346:
7347: x_return_status := FND_API.G_RET_STS_SUCCESS;
7348:
7349:
7350: if p_release_id is not null then
7351: l_doc_id := p_release_id;

Line 7398: x_return_status := FND_API.G_RET_STS_ERROR;

7394: --This is just for double check.. This API should only be called when all changes are responded
7395: open l_pending_csr(p_chg_req_grp_id);
7396: fetch l_pending_csr into l_id;
7397: if (l_id is not null) then
7398: x_return_status := FND_API.G_RET_STS_ERROR;
7399: x_err_msg := 'PENDING RECORDS EXIST';
7400: close l_pending_csr;
7401: return;
7402: end if;

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

7560: p_release_id,
7561: l_kickoff_msg);
7562:
7563:
7564: if(l_kickoff_status <> FND_API.G_RET_STS_SUCCESS) then
7565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7566: x_err_msg := 'STARTPOWF_ERROR:'||l_kickoff_msg;
7567: end if;
7568: */

Line 7565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7561: l_kickoff_msg);
7562:
7563:
7564: if(l_kickoff_status <> FND_API.G_RET_STS_SUCCESS) then
7565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7566: x_err_msg := 'STARTPOWF_ERROR:'||l_kickoff_msg;
7567: end if;
7568: */
7569: end if;

Line 7576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7572: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7573: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
7574: l_api_name || '.others_exception', x_progress||':'||sqlerrm);
7575: END IF;
7576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7577: x_err_msg := x_progress||'*'||sqlerrm;
7578:
7579: END ProcessResponse;
7580:

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

7965: p_header_id,
7966: x_ret_status,
7967: x_complex_flag);
7968:
7969: IF x_return_status IS NOT NULL AND x_return_status = FND_API.g_ret_sts_success THEN
7970: IF( g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7971: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
7972: g_module_prefix,
7973: l_progress

Line 8035: x_return_status := FND_API.G_RET_STS_SUCCESS;

8031:
8032: wf_engine.StartProcess( ItemType => 'POSCHORD',
8033: ItemKey => l_item_key);
8034:
8035: x_return_status := FND_API.G_RET_STS_SUCCESS;
8036: exception when others then
8037: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8038: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
8039: l_api_name || '.others_exception', l_progress||':'||sqlerrm);

Line 8041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8037: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8038: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
8039: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
8040: END IF;
8041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8042: end StartSupplierChangeWF;
8043:
8044:
8045: PROCEDURE initialize(p_employee_id in NUMBER,p_org_id IN NUMBER) IS