DBA Data[Home] [Help]

APPS.OKE_CONTRACT_PVT dependencies on DBMS_OUTPUT

Line 1433: dbms_output.put_line('before erase saved version'||l_return_status);

1429:
1430: delete from OKE_K_VERS_NUMBERS_H
1431: where k_header_id = p_header_id;
1432:
1433: dbms_output.put_line('before erase saved version'||l_return_status);
1434:
1435: OKC_VERSION_PVT.delete_version
1436: (p_chr_id => p_header_id,
1437: p_major_version => 0,

Line 1442: dbms_output.put_line('after erase saved version'||l_return_status);

1438: p_minor_version => 0,
1439: p_called_from => 'RESTORE_VERSION');
1440:
1441:
1442: dbms_output.put_line('after erase saved version'||l_return_status);
1443:
1444: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1445: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1446: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1450: dbms_output.put_line('erase saved version succcess');

1446: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1447: RAISE OKE_API.G_EXCEPTION_ERROR;
1448: END IF;
1449:
1450: dbms_output.put_line('erase saved version succcess');
1451:
1452:
1453: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1454:

Line 1459: dbms_output.put_line('exception in del ver');

1455:
1456: EXCEPTION
1457: when OTHERS then
1458:
1459: dbms_output.put_line('exception in del ver');
1460: -- store SQL error message on message stack
1461: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
1462: p_msg_name => g_unexpected_error,
1463: p_token1 => g_sqlcode_token,