1423: ,x_tehl_tbl => l_tehl_tbl_out
1424: );
1425: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1426: 'After execution of OKL_TRX_EXTENSION_PVT.create_trx_extension API. l_return_status ' || l_return_status);
1427: IF l_return_status = FND_API.G_RET_STS_ERROR
1428: THEN
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1431: THEN
1425: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1426: 'After execution of OKL_TRX_EXTENSION_PVT.create_trx_extension API. l_return_status ' || l_return_status);
1427: IF l_return_status = FND_API.G_RET_STS_ERROR
1428: THEN
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1431: THEN
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: END IF;
1426: 'After execution of OKL_TRX_EXTENSION_PVT.create_trx_extension API. l_return_status ' || l_return_status);
1427: IF l_return_status = FND_API.G_RET_STS_ERROR
1428: THEN
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1431: THEN
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: END IF;
1434: -- Returning back the record structure
1428: THEN
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1431: THEN
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: END IF;
1434: -- Returning back the record structure
1435: px_trans_hdr_rec.header_extension_id := l_teh_rec_out.header_extension_id;
1436: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
1985: ,x_tell_tbl => l_tell_tbl_out
1986: );
1987: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1988: 'After okl_trx_extension_pvt.create_txl_extension. l_return_status ' || l_return_status );
1989: IF l_return_status = FND_API.G_RET_STS_ERROR
1990: THEN
1991: RAISE FND_API.G_EXC_ERROR;
1992: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1993: THEN
1987: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
1988: 'After okl_trx_extension_pvt.create_txl_extension. l_return_status ' || l_return_status );
1989: IF l_return_status = FND_API.G_RET_STS_ERROR
1990: THEN
1991: RAISE FND_API.G_EXC_ERROR;
1992: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1993: THEN
1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1995: END IF;
1988: 'After okl_trx_extension_pvt.create_txl_extension. l_return_status ' || l_return_status );
1989: IF l_return_status = FND_API.G_RET_STS_ERROR
1990: THEN
1991: RAISE FND_API.G_EXC_ERROR;
1992: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1993: THEN
1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1995: END IF;
1996: -- Return the values
1990: THEN
1991: RAISE FND_API.G_EXC_ERROR;
1992: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1993: THEN
1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1995: END IF;
1996: -- Return the values
1997: px_trans_line_rec.line_extension_id := l_tel_rec_out.line_extension_id;
1998: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
2701: ,x_tel_tbl_tbl => l_tel_tbl_tbl_out
2702: );
2703: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
2704: 'After okl_trx_extension_pvt.create_txl_extension-tbl. l_return_status ' || l_return_status );
2705: IF l_return_status = FND_API.G_RET_STS_ERROR
2706: THEN
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2709: THEN
2703: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
2704: 'After okl_trx_extension_pvt.create_txl_extension-tbl. l_return_status ' || l_return_status );
2705: IF l_return_status = FND_API.G_RET_STS_ERROR
2706: THEN
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2709: THEN
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711: END IF;
2704: 'After okl_trx_extension_pvt.create_txl_extension-tbl. l_return_status ' || l_return_status );
2705: IF l_return_status = FND_API.G_RET_STS_ERROR
2706: THEN
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2709: THEN
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711: END IF;
2712:
2706: THEN
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2709: THEN
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711: END IF;
2712:
2713: -- Return the values
2714: x_trans_line_tbl := p_trans_line_tbl; --Added PRASJAIN Bug#6134235