DBA Data[Home] [Help]

APPS.OKL_PROCESS_TMPT_SET_PUB dependencies on OKL_API

Line 1506: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1502: l_api_version NUMBER := 1.0;
1503: l_api_name VARCHAR2(30) := 'COPY_TMPL_SET';
1504: l_aes_id_from NUMBER := p_aes_id_from;
1505: l_aes_id_to NUMBER := p_aes_id_to;
1506: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1507: BEGIN
1508: SAVEPOINT COPY_TMPL_SET2;
1509: x_return_status := FND_API.G_RET_STS_SUCCESS;
1510: -- customer pre-processing

Line 1535: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1531: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.COPY_TMPL_SET ');
1532: END;
1533: END IF;
1534: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TMPL_SET
1535: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1538: RAISE FND_API.G_EXC_ERROR;
1539: END IF;

Line 1537: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

1533: END IF;
1534: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TMPL_SET
1535: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1538: RAISE FND_API.G_EXC_ERROR;
1539: END IF;
1540: EXCEPTION
1541: WHEN FND_API.G_EXC_ERROR THEN

Line 1544: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

1540: EXCEPTION
1541: WHEN FND_API.G_EXC_ERROR THEN
1542: ROLLBACK TO COPY_TMPL_SET2;
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1545: ,p_count => x_msg_count
1546: ,p_data => x_msg_data);
1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: ROLLBACK TO COPY_TMPL_SET2;

Line 1550: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

1546: ,p_data => x_msg_data);
1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: ROLLBACK TO COPY_TMPL_SET2;
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1551: ,p_count => x_msg_count
1552: ,p_data => x_msg_data);
1553: WHEN OTHERS THEN
1554: ROLLBACK TO COPY_TMPL_SET2;

Line 1556: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

1552: ,p_data => x_msg_data);
1553: WHEN OTHERS THEN
1554: ROLLBACK TO COPY_TMPL_SET2;
1555: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TMPL_SET');
1556: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1557: ,p_count => x_msg_count
1558: ,p_data => x_msg_data);
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: END COPY_TMPL_SET;

Line 1576: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1572: l_api_version NUMBER := 1.0;
1573: l_api_name VARCHAR2(30) := 'COPY_TEMPLATES';
1574: l_avlv_rec avlv_rec_type := p_avlv_rec;
1575: l_source_tmpl_id NUMBER := p_source_tmpl_id;
1576: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1577: BEGIN
1578: SAVEPOINT COPY_TEMPLATE2;
1579: x_return_status := FND_API.G_RET_STS_SUCCESS;
1580: -- customer pre-processing

Line 1606: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1602: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.COPY_TEMPLATE ');
1603: END;
1604: END IF;
1605: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TEMPLATE
1606: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;

Line 1608: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

1604: END IF;
1605: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TEMPLATE
1606: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN

Line 1615: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: ROLLBACK TO COPY_TEMPLATE2;
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1616: ,p_count => x_msg_count
1617: ,p_data => x_msg_data);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO COPY_TEMPLATE2;

Line 1621: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

1617: ,p_data => x_msg_data);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO COPY_TEMPLATE2;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1622: ,p_count => x_msg_count
1623: ,p_data => x_msg_data);
1624: WHEN OTHERS THEN
1625: ROLLBACK TO COPY_TEMPLATE2;

Line 1627: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE

1623: ,p_data => x_msg_data);
1624: WHEN OTHERS THEN
1625: ROLLBACK TO COPY_TEMPLATE2;
1626: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TEMPLATE');
1627: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1628: ,p_count => x_msg_count
1629: ,p_data => x_msg_data);
1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1631: END COPY_TEMPLATE;