eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CPY_PDT_RULS_PUB dependencies on OKL_API

Line 11: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

7: -- at header or line level as per the setup
8: -- Parameters : IN parameter - p_khr_id contract header id of the contract
9: --end of comments
10: Procedure Copy_Product_Rules(p_api_version IN NUMBER,
11: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: p_khr_id IN NUMBER,

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

14: x_msg_data OUT NOCOPY VARCHAR2,
15: p_khr_id IN NUMBER,
16: p_pov_id IN NUMBER) is
17:
18: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
19: l_api_name CONSTANT VARCHAR2(30) := 'COPY_PRODUCT_RULES';
20: l_api_version CONSTANT NUMBER := 1.0;
21:
22: BEGIN

Line 24: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

20: l_api_version CONSTANT NUMBER := 1.0;
21:
22: BEGIN
23: --call start activity to set savepoint
24: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
25: p_init_msg_list,
26: '_PVT',
27: x_return_status);
28: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 28: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

24: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
25: p_init_msg_list,
26: '_PVT',
27: x_return_status);
28: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
29: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
31: RAISE OKL_API.G_EXCEPTION_ERROR;
32: END IF;

Line 29: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

25: p_init_msg_list,
26: '_PVT',
27: x_return_status);
28: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
29: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
31: RAISE OKL_API.G_EXCEPTION_ERROR;
32: END IF;
33: --Customer pre-processing Section

Line 30: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

26: '_PVT',
27: x_return_status);
28: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
29: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
31: RAISE OKL_API.G_EXCEPTION_ERROR;
32: END IF;
33: --Customer pre-processing Section
34: --Vertical Industry pre-processing Section

Line 31: RAISE OKL_API.G_EXCEPTION_ERROR;

27: x_return_status);
28: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
29: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
31: RAISE OKL_API.G_EXCEPTION_ERROR;
32: END IF;
33: --Customer pre-processing Section
34: --Vertical Industry pre-processing Section
35: -- call pvt api to copy option rules

Line 45: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

41: x_msg_data => x_msg_data,
42: p_khr_id => p_khr_id,
43: p_pov_id => p_pov_id);
44:
45: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
46: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
47: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: END IF;

Line 46: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

42: p_khr_id => p_khr_id,
43: p_pov_id => p_pov_id);
44:
45: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
46: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
47: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: END IF;
50:

Line 47: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

43: p_pov_id => p_pov_id);
44:
45: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
46: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
47: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: END IF;
50:
51: --Vertical post-processing Section

Line 48: RAISE OKL_API.G_EXCEPTION_ERROR;

44:
45: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
46: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
47: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
48: RAISE OKL_API.G_EXCEPTION_ERROR;
49: END IF;
50:
51: --Vertical post-processing Section
52: --Customer post-processing Section

Line 54: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

50:
51: --Vertical post-processing Section
52: --Customer post-processing Section
53: --Call end Activity
54: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
55:
56: EXCEPTION
57: When OKL_API.G_EXCEPTION_ERROR Then
58: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

Line 57: When OKL_API.G_EXCEPTION_ERROR Then

53: --Call end Activity
54: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
55:
56: EXCEPTION
57: When OKL_API.G_EXCEPTION_ERROR Then
58: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
59: (
60: l_api_name,
61: G_PKG_NAME,

Line 58: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

54: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
55:
56: EXCEPTION
57: When OKL_API.G_EXCEPTION_ERROR Then
58: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
59: (
60: l_api_name,
61: G_PKG_NAME,
62: 'OKL_API.G_RET_STS_ERROR',

Line 62: 'OKL_API.G_RET_STS_ERROR',

58: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
59: (
60: l_api_name,
61: G_PKG_NAME,
62: 'OKL_API.G_RET_STS_ERROR',
63: x_msg_count,
64: x_msg_data,
65: '_PVT'
66: );

Line 67: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

63: x_msg_count,
64: x_msg_data,
65: '_PVT'
66: );
67: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
68: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
69: (
70: l_api_name,
71: G_PKG_NAME,

Line 68: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

64: x_msg_data,
65: '_PVT'
66: );
67: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
68: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
69: (
70: l_api_name,
71: G_PKG_NAME,
72: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 72: 'OKL_API.G_RET_STS_UNEXP_ERROR',

68: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
69: (
70: l_api_name,
71: G_PKG_NAME,
72: 'OKL_API.G_RET_STS_UNEXP_ERROR',
73: x_msg_count,
74: x_msg_data,
75: '_PVT'
76: );

Line 78: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

74: x_msg_data,
75: '_PVT'
76: );
77: WHEN OTHERS THEN
78: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
79: (
80: l_api_name,
81: G_PKG_NAME,
82: 'OTHERS',