APPS.PO_CREATE_REQUISITION_SV dependencies on FND_API

Line 597: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE

593: */
594:
595: PROCEDURE process_requisition(
596: p_api_version IN NUMBER := 1.0
597: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
599: ,px_header_rec IN OUT NOCOPY po_create_requisition_sv.header_rec_type
600: ,px_line_table IN OUT NOCOPY po_create_requisition_sv.Line_Tbl_type
601: ,x_return_status OUT NOCOPY VARCHAR2

Line 598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

594:
595: PROCEDURE process_requisition(
596: p_api_version IN NUMBER := 1.0
597: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
599: ,px_header_rec IN OUT NOCOPY po_create_requisition_sv.header_rec_type
600: ,px_line_table IN OUT NOCOPY po_create_requisition_sv.Line_Tbl_type
601: ,x_return_status OUT NOCOPY VARCHAR2
602: ,x_msg_count OUT NOCOPY NUMBER

Line 609: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

605: IS
606:
607: l_api_version_number CONSTANT NUMBER := 1.0;
608: l_api_name CONSTANT VARCHAR2(30) := 'process_requisition';
609: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
610: l_msg_count NUMBER;
611: l_msg_data VARCHAR2(2000);
612: l_commit VARCHAR2(1) := FND_API.G_FALSE;
613: l_user_id NUMBER;

Line 612: l_commit VARCHAR2(1) := FND_API.G_FALSE;

608: l_api_name CONSTANT VARCHAR2(30) := 'process_requisition';
609: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
610: l_msg_count NUMBER;
611: l_msg_data VARCHAR2(2000);
612: l_commit VARCHAR2(1) := FND_API.G_FALSE;
613: l_user_id NUMBER;
614: l_login_id NUMBER;
615: l_today DATE;
616:

Line 781: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

777: WHERE mum.uom_code = p_uom_code;
778:
779: BEGIN
780:
781: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
782: -- initialize message list
783: FND_MSG_PUB.initialize;
784: END IF;
785:

Line 788: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

784: END IF;
785:
786: -- Standard call to check for call compatibility.
787:
788: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
789: p_api_version,
790: l_api_name,
791: G_PKG_NAME)
792: THEN

Line 793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

789: p_api_version,
790: l_api_name,
791: G_PKG_NAME)
792: THEN
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795:
796: -- initialize return status
797: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 797: x_return_status := FND_API.G_RET_STS_SUCCESS;

793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795:
796: -- initialize return status
797: x_return_status := FND_API.G_RET_STS_SUCCESS;
798:
799: l_header_rec := px_header_rec;
800: l_line_tbl := px_line_table;
801:

Line 1552: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1548:
1549: l_create_req_supply := PO_SUPPLY.create_req(l_header_rec.requisition_header_id,
1550: 'REQ HDR');
1551:
1552: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556:

Line 1553: RAISE FND_API.G_EXC_ERROR;

1549: l_create_req_supply := PO_SUPPLY.create_req(l_header_rec.requisition_header_id,
1550: 'REQ HDR');
1551:
1552: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556:
1557: fnd_msg_pub.count_and_get

Line 1622: WHEN FND_API.G_EXC_ERROR THEN

1618: WHEN INVALID_UNIT_OF_MEASURE THEN
1619: po_message_s.app_error('PO_RI_M_INVALID_UOM');
1620: raise;
1621:
1622: WHEN FND_API.G_EXC_ERROR THEN
1623: NULL;
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: FND_MESSAGE.SET_NAME('PO', 'PO_UNEXPECTED_EXEC_ERRORS');

Line 1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1621:
1622: WHEN FND_API.G_EXC_ERROR THEN
1623: NULL;
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: FND_MESSAGE.SET_NAME('PO', 'PO_UNEXPECTED_EXEC_ERRORS');
1627: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
1628: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
1629: FND_MSG_PUB.ADD;

Line 1633: x_return_status := FND_API.G_RET_STS_ERROR;

1629: FND_MSG_PUB.ADD;
1630: fnd_msg_pub.count_and_get
1631: ( p_count => x_msg_count
1632: , p_data => x_msg_data);
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634:
1635: WHEN OTHERS THEN
1636: FND_MESSAGE.SET_NAME('PO', 'PO_UNEXPECTED_EXEC_ERRORS');
1637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

Line 1643: x_return_status := FND_API.G_RET_STS_ERROR;

1639: FND_MSG_PUB.ADD;
1640: fnd_msg_pub.count_and_get
1641: ( p_count => x_msg_count
1642: , p_data => x_msg_data);
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644:
1645: END;
1646:
1647: END PO_CREATE_REQUISITION_SV;