DBA Data[Home] [Help]

APPS.PO_CHANGE_RESPONSE_PVT dependencies on FND_API

Line 172: l_all_ack := PO_ACKNOWLEDGE_PO_PVT.All_Shipments_Responded(1.0, FND_API.G_FALSE,

168: --bug 4107241
169: --buyer should not be able to ack PO's which are partially acknowledged
170: --this code block replaces commented code
171:
172: l_all_ack := PO_ACKNOWLEDGE_PO_PVT.All_Shipments_Responded(1.0, FND_API.G_FALSE,
173: p_po_header_id,p_po_release_id,l_revision_num );
174:
175: if(l_all_ack = FND_API.G_TRUE) then
176: x_partial_ack := 'N';

Line 175: if(l_all_ack = FND_API.G_TRUE) then

171:
172: l_all_ack := PO_ACKNOWLEDGE_PO_PVT.All_Shipments_Responded(1.0, FND_API.G_FALSE,
173: p_po_header_id,p_po_release_id,l_revision_num );
174:
175: if(l_all_ack = FND_API.G_TRUE) then
176: x_partial_ack := 'N';
177: else
178: x_partial_ack := 'Y';
179: end if;

Line 471: x_return_status := FND_API.G_RET_STS_SUCCESS;

467:
468: l_progress := '001';
469:
470: x_return_code := 0; /* 0 implies no error */
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: x_err_msg := '';
473: x_doc_check_rec_type := null;
474:
475: /*

Line 477: l_launch_approvals_flag := FND_API.G_FALSE;

473: x_doc_check_rec_type := null;
474:
475: /*
476: if (p_launch_approvals_flag = 'N') then
477: l_launch_approvals_flag := FND_API.G_FALSE;
478:
479: else
480: l_launch_approvals_flag := FND_API.G_TRUE;
481:

Line 480: l_launch_approvals_flag := FND_API.G_TRUE;

476: if (p_launch_approvals_flag = 'N') then
477: l_launch_approvals_flag := FND_API.G_FALSE;
478:
479: else
480: l_launch_approvals_flag := FND_API.G_TRUE;
481:
482: end if;
483: */
484:

Line 635: p_init_msg_list => FND_API.G_TRUE,

631:
632: -- Call the PO Change API to apply these changes to the document
633: PO_DOCUMENT_UPDATE_GRP.update_document (
634: p_api_version => 1.0,
635: p_init_msg_list => FND_API.G_TRUE,
636: x_return_status => l_return_status,
637: p_changes => l_changes,
638: p_run_submission_checks => FND_API.G_TRUE,
639: p_launch_approvals_flag => FND_API.G_FALSE,

Line 638: p_run_submission_checks => FND_API.G_TRUE,

634: p_api_version => 1.0,
635: p_init_msg_list => FND_API.G_TRUE,
636: x_return_status => l_return_status,
637: p_changes => l_changes,
638: p_run_submission_checks => FND_API.G_TRUE,
639: p_launch_approvals_flag => FND_API.G_FALSE,
640: p_buyer_id => NULL,
641: p_update_source => NULL, -- default
642: p_override_date => NULL,

Line 639: p_launch_approvals_flag => FND_API.G_FALSE,

635: p_init_msg_list => FND_API.G_TRUE,
636: x_return_status => l_return_status,
637: p_changes => l_changes,
638: p_run_submission_checks => FND_API.G_TRUE,
639: p_launch_approvals_flag => FND_API.G_FALSE,
640: p_buyer_id => NULL,
641: p_update_source => NULL, -- default
642: p_override_date => NULL,
643: x_api_errors => l_api_errors,

Line 650: IF ((l_return_status = FND_API.G_RET_STS_ERROR) OR (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN

646:
647: l_progress := '012';
648:
649: -- Construct a POS_ERR_TYPE object from the errors returned by the PO Change API.
650: IF ((l_return_status = FND_API.G_RET_STS_ERROR) OR (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
651: l_err_msg_name_tbl := po_tbl_varchar30();
652: l_err_msg_text_tbl := po_tbl_varchar2000();
653: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl, l_err_msg_text_tbl);
654:

Line 677: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

673: END IF;
674:
675: l_progress := '013';
676:
677: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
678: x_return_code := 1;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
681: return;

Line 679: x_return_status := FND_API.G_RET_STS_ERROR;

675: l_progress := '013';
676:
677: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
678: x_return_code := 1;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
681: return;
682: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
683: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 682: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

678: x_return_code := 1;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
681: return;
682: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
683: raise FND_API.G_EXC_UNEXPECTED_ERROR;
684: END IF; -- l_return_status
685:
686: l_progress := '014';

Line 683: raise FND_API.G_EXC_UNEXPECTED_ERROR;

679: x_return_status := FND_API.G_RET_STS_ERROR;
680: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
681: return;
682: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
683: raise FND_API.G_EXC_UNEXPECTED_ERROR;
684: END IF; -- l_return_status
685:
686: l_progress := '014';
687:

Line 713: p_init_msg_list => FND_API.G_TRUE,

709: if (p_launch_approvals_flag = 'Y') then
710:
711: PO_DOCUMENT_UPDATE_GRP.launch_po_approval_wf (
712: p_api_version => 1.0,
713: p_init_msg_list => FND_API.G_TRUE,
714: x_return_status => l_return_status,
715: p_document_id => NVL(p_po_release_id, p_po_header_id),
716: p_document_type => l_document_type,
717: p_document_subtype => l_document_subtype,

Line 725: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

721:
722: end if;
723:
724:
725: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
726: x_return_code := 1;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
729: return;

Line 727: x_return_status := FND_API.G_RET_STS_ERROR;

723:
724:
725: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
726: x_return_code := 1;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
729: return;
730: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
731: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 730: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

726: x_return_code := 1;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
729: return;
730: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF; -- l_return_status
733:
734: l_progress := '016';

Line 731: raise FND_API.G_EXC_UNEXPECTED_ERROR;

727: x_return_status := FND_API.G_RET_STS_ERROR;
728: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
729: return;
730: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF; -- l_return_status
733:
734: l_progress := '016';
735:

Line 738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

734: l_progress := '016';
735:
736: EXCEPTION
737:
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739:
740: x_return_code := 2;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');

Line 741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

737:
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739:
740: x_return_code := 2;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: x_err_msg := l_progress||':'||FND_MSG_PUB.get(FND_MSG_PUB.G_LAST,'F');
743:
744: WHEN OTHERS THEN
745:

Line 747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

743:
744: WHEN OTHERS THEN
745:
746: x_return_code := 2;
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: x_err_msg := l_progress||':' || ':' || sqlcode ||':'||sqlerrm(sqlcode);
749:
750: END MoveChangeToPO;
751: