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.OKS_ENTITLEMENTS_PUB dependencies on OKC_API

Line 21: l_return_status := OKC_API.G_RET_STS_SUCCESS;

17: l_return_status Varchar2(1);
18: l_api_name CONSTANT VARCHAR2(30) := 'check_coverage_times';
19: --l_api_version CONSTANT NUMBER := 1.0;
20: BEGIN
21: l_return_status := OKC_API.G_RET_STS_SUCCESS;
22:
23: l_return_status := OKC_API.START_ACTIVITY(l_api_name
24: ,p_init_msg_list
25: ,'_PUB'

Line 23: l_return_status := OKC_API.START_ACTIVITY(l_api_name

19: --l_api_version CONSTANT NUMBER := 1.0;
20: BEGIN
21: l_return_status := OKC_API.G_RET_STS_SUCCESS;
22:
23: l_return_status := OKC_API.START_ACTIVITY(l_api_name
24: ,p_init_msg_list
25: ,'_PUB'
26: ,x_return_status
27: );

Line 28: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

24: ,p_init_msg_list
25: ,'_PUB'
26: ,x_return_status
27: );
28: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
29: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_ERROR;
32: END IF;

Line 29: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

25: ,'_PUB'
26: ,x_return_status
27: );
28: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
29: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_ERROR;
32: END IF;
33:

Line 30: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

26: ,x_return_status
27: );
28: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
29: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_ERROR;
32: END IF;
33:
34: OKS_ENTITLEMENTS_PVT.check_coverage_times

Line 31: RAISE OKC_API.G_EXCEPTION_ERROR;

27: );
28: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
29: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_ERROR;
32: END IF;
33:
34: OKS_ENTITLEMENTS_PVT.check_coverage_times
35: (p_api_version

Line 47: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

43: ,x_msg_count
44: ,x_msg_data
45: ,x_covered_yn);
46:
47: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
48: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
49: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
50: RAISE OKC_API.G_EXCEPTION_ERROR;
51: END IF;

Line 48: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

44: ,x_msg_data
45: ,x_covered_yn);
46:
47: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
48: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
49: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
50: RAISE OKC_API.G_EXCEPTION_ERROR;
51: END IF;
52:

Line 49: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

45: ,x_covered_yn);
46:
47: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
48: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
49: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
50: RAISE OKC_API.G_EXCEPTION_ERROR;
51: END IF;
52:
53: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 50: RAISE OKC_API.G_EXCEPTION_ERROR;

46:
47: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
48: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
49: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
50: RAISE OKC_API.G_EXCEPTION_ERROR;
51: END IF;
52:
53: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
54:

Line 53: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

49: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
50: RAISE OKC_API.G_EXCEPTION_ERROR;
51: END IF;
52:
53: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
54:
55: EXCEPTION
56: WHEN OKC_API.G_EXCEPTION_ERROR THEN
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 56: WHEN OKC_API.G_EXCEPTION_ERROR THEN

52:
53: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
54:
55: EXCEPTION
56: WHEN OKC_API.G_EXCEPTION_ERROR THEN
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS
58: (l_api_name,
59: G_PKG_NAME,
60: 'OKC_API.G_RET_STS_ERROR',

Line 57: x_return_status := OKC_API.HANDLE_EXCEPTIONS

53: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
54:
55: EXCEPTION
56: WHEN OKC_API.G_EXCEPTION_ERROR THEN
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS
58: (l_api_name,
59: G_PKG_NAME,
60: 'OKC_API.G_RET_STS_ERROR',
61: x_msg_count,

Line 60: 'OKC_API.G_RET_STS_ERROR',

56: WHEN OKC_API.G_EXCEPTION_ERROR THEN
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS
58: (l_api_name,
59: G_PKG_NAME,
60: 'OKC_API.G_RET_STS_ERROR',
61: x_msg_count,
62: x_msg_data,
63: '_PUB');
64: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 64: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

60: 'OKC_API.G_RET_STS_ERROR',
61: x_msg_count,
62: x_msg_data,
63: '_PUB');
64: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
65: x_return_status := OKC_API.HANDLE_EXCEPTIONS
66: (l_api_name,
67: G_PKG_NAME,
68: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 65: x_return_status := OKC_API.HANDLE_EXCEPTIONS

61: x_msg_count,
62: x_msg_data,
63: '_PUB');
64: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
65: x_return_status := OKC_API.HANDLE_EXCEPTIONS
66: (l_api_name,
67: G_PKG_NAME,
68: 'OKC_API.G_RET_STS_UNEXP_ERROR',
69: x_msg_count,

Line 68: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 73: x_return_status := OKC_API.HANDLE_EXCEPTIONS

69: x_msg_count,
70: x_msg_data,
71: '_PUB');
72: WHEN OTHERS THEN
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS
74: (l_api_name,
75: G_PKG_NAME,
76: 'OTHERS',
77: x_msg_count,

Line 103: l_return_status := OKC_API.G_RET_STS_SUCCESS;

99: l_return_status Varchar2(1);
100: l_api_name CONSTANT VARCHAR2(30) := 'check_reaction_times';
101: --l_api_version CONSTANT NUMBER := 1.0;
102: BEGIN
103: l_return_status := OKC_API.G_RET_STS_SUCCESS;
104:
105: l_return_status := OKC_API.START_ACTIVITY(l_api_name
106: ,p_init_msg_list
107: ,'_PUB'

Line 105: l_return_status := OKC_API.START_ACTIVITY(l_api_name

101: --l_api_version CONSTANT NUMBER := 1.0;
102: BEGIN
103: l_return_status := OKC_API.G_RET_STS_SUCCESS;
104:
105: l_return_status := OKC_API.START_ACTIVITY(l_api_name
106: ,p_init_msg_list
107: ,'_PUB'
108: ,x_return_status
109: );

Line 110: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

106: ,p_init_msg_list
107: ,'_PUB'
108: ,x_return_status
109: );
110: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
111: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
113: RAISE OKC_API.G_EXCEPTION_ERROR;
114: END IF;

Line 111: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

107: ,'_PUB'
108: ,x_return_status
109: );
110: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
111: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
113: RAISE OKC_API.G_EXCEPTION_ERROR;
114: END IF;
115:

Line 112: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

108: ,x_return_status
109: );
110: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
111: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
113: RAISE OKC_API.G_EXCEPTION_ERROR;
114: END IF;
115:
116: OKS_ENTITLEMENTS_PVT.check_reaction_times

Line 113: RAISE OKC_API.G_EXCEPTION_ERROR;

109: );
110: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
111: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
113: RAISE OKC_API.G_EXCEPTION_ERROR;
114: END IF;
115:
116: OKS_ENTITLEMENTS_PVT.check_reaction_times
117: (p_api_version

Line 132: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

128: ,x_react_within
129: ,x_react_tuom
130: ,x_react_by_date);
131:
132: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
134: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
135: RAISE OKC_API.G_EXCEPTION_ERROR;
136: END IF;

Line 133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

129: ,x_react_tuom
130: ,x_react_by_date);
131:
132: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
134: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
135: RAISE OKC_API.G_EXCEPTION_ERROR;
136: END IF;
137:

Line 134: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

130: ,x_react_by_date);
131:
132: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
134: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
135: RAISE OKC_API.G_EXCEPTION_ERROR;
136: END IF;
137:
138: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 135: RAISE OKC_API.G_EXCEPTION_ERROR;

131:
132: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
133: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
134: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
135: RAISE OKC_API.G_EXCEPTION_ERROR;
136: END IF;
137:
138: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
139:

Line 138: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

134: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
135: RAISE OKC_API.G_EXCEPTION_ERROR;
136: END IF;
137:
138: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
139:
140: EXCEPTION
141: WHEN OKC_API.G_EXCEPTION_ERROR THEN
142: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 141: WHEN OKC_API.G_EXCEPTION_ERROR THEN

137:
138: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
139:
140: EXCEPTION
141: WHEN OKC_API.G_EXCEPTION_ERROR THEN
142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
143: (l_api_name,
144: G_PKG_NAME,
145: 'OKC_API.G_RET_STS_ERROR',

Line 142: x_return_status := OKC_API.HANDLE_EXCEPTIONS

138: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
139:
140: EXCEPTION
141: WHEN OKC_API.G_EXCEPTION_ERROR THEN
142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
143: (l_api_name,
144: G_PKG_NAME,
145: 'OKC_API.G_RET_STS_ERROR',
146: x_msg_count,

Line 145: 'OKC_API.G_RET_STS_ERROR',

141: WHEN OKC_API.G_EXCEPTION_ERROR THEN
142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
143: (l_api_name,
144: G_PKG_NAME,
145: 'OKC_API.G_RET_STS_ERROR',
146: x_msg_count,
147: x_msg_data,
148: '_PUB');
149: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 149: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

145: 'OKC_API.G_RET_STS_ERROR',
146: x_msg_count,
147: x_msg_data,
148: '_PUB');
149: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
150: x_return_status := OKC_API.HANDLE_EXCEPTIONS
151: (l_api_name,
152: G_PKG_NAME,
153: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 150: x_return_status := OKC_API.HANDLE_EXCEPTIONS

146: x_msg_count,
147: x_msg_data,
148: '_PUB');
149: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
150: x_return_status := OKC_API.HANDLE_EXCEPTIONS
151: (l_api_name,
152: G_PKG_NAME,
153: 'OKC_API.G_RET_STS_UNEXP_ERROR',
154: x_msg_count,

Line 153: 'OKC_API.G_RET_STS_UNEXP_ERROR',

149: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
150: x_return_status := OKC_API.HANDLE_EXCEPTIONS
151: (l_api_name,
152: G_PKG_NAME,
153: 'OKC_API.G_RET_STS_UNEXP_ERROR',
154: x_msg_count,
155: x_msg_data,
156: '_PUB');
157: WHEN OTHERS THEN

Line 158: x_return_status := OKC_API.HANDLE_EXCEPTIONS

154: x_msg_count,
155: x_msg_data,
156: '_PUB');
157: WHEN OTHERS THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (l_api_name,
160: G_PKG_NAME,
161: 'OTHERS',
162: x_msg_count,

Line 182: l_return_status := OKC_API.G_RET_STS_SUCCESS;

178: l_api_name CONSTANT VARCHAR2(30) := 'get_all_contracts';
179: --l_api_version CONSTANT NUMBER := 1.0;
180: BEGIN
181:
182: l_return_status := OKC_API.G_RET_STS_SUCCESS;
183:
184: l_return_status := OKC_API.START_ACTIVITY(l_api_name
185: ,p_init_msg_list
186: ,'_PUB'

Line 184: l_return_status := OKC_API.START_ACTIVITY(l_api_name

180: BEGIN
181:
182: l_return_status := OKC_API.G_RET_STS_SUCCESS;
183:
184: l_return_status := OKC_API.START_ACTIVITY(l_api_name
185: ,p_init_msg_list
186: ,'_PUB'
187: ,x_return_status
188: );

Line 189: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

185: ,p_init_msg_list
186: ,'_PUB'
187: ,x_return_status
188: );
189: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
191: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
192: RAISE OKC_API.G_EXCEPTION_ERROR;
193: END IF;

Line 190: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

186: ,'_PUB'
187: ,x_return_status
188: );
189: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
191: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
192: RAISE OKC_API.G_EXCEPTION_ERROR;
193: END IF;
194:

Line 191: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

187: ,x_return_status
188: );
189: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
191: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
192: RAISE OKC_API.G_EXCEPTION_ERROR;
193: END IF;
194:
195: OKS_ENTITLEMENTS_PVT.get_all_contracts

Line 192: RAISE OKC_API.G_EXCEPTION_ERROR;

188: );
189: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
191: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
192: RAISE OKC_API.G_EXCEPTION_ERROR;
193: END IF;
194:
195: OKS_ENTITLEMENTS_PVT.get_all_contracts
196: (p_api_version

Line 204: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

200: ,x_msg_count
201: ,x_msg_data
202: ,x_all_contracts);
203:
204: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;

Line 205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

201: ,x_msg_data
202: ,x_all_contracts);
203:
204: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209:

Line 206: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

202: ,x_all_contracts);
203:
204: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209:
210: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 207: RAISE OKC_API.G_EXCEPTION_ERROR;

203:
204: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209:
210: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
211:

Line 210: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

206: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209:
210: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
211:
212: EXCEPTION
213: WHEN OKC_API.G_EXCEPTION_ERROR THEN
214: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 213: WHEN OKC_API.G_EXCEPTION_ERROR THEN

209:
210: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
211:
212: EXCEPTION
213: WHEN OKC_API.G_EXCEPTION_ERROR THEN
214: x_return_status := OKC_API.HANDLE_EXCEPTIONS
215: (l_api_name,
216: G_PKG_NAME,
217: 'OKC_API.G_RET_STS_ERROR',

Line 214: x_return_status := OKC_API.HANDLE_EXCEPTIONS

210: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
211:
212: EXCEPTION
213: WHEN OKC_API.G_EXCEPTION_ERROR THEN
214: x_return_status := OKC_API.HANDLE_EXCEPTIONS
215: (l_api_name,
216: G_PKG_NAME,
217: 'OKC_API.G_RET_STS_ERROR',
218: x_msg_count,

Line 217: 'OKC_API.G_RET_STS_ERROR',

213: WHEN OKC_API.G_EXCEPTION_ERROR THEN
214: x_return_status := OKC_API.HANDLE_EXCEPTIONS
215: (l_api_name,
216: G_PKG_NAME,
217: 'OKC_API.G_RET_STS_ERROR',
218: x_msg_count,
219: x_msg_data,
220: '_PUB');
221: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 221: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

217: 'OKC_API.G_RET_STS_ERROR',
218: x_msg_count,
219: x_msg_data,
220: '_PUB');
221: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
222: x_return_status := OKC_API.HANDLE_EXCEPTIONS
223: (l_api_name,
224: G_PKG_NAME,
225: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 222: x_return_status := OKC_API.HANDLE_EXCEPTIONS

218: x_msg_count,
219: x_msg_data,
220: '_PUB');
221: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
222: x_return_status := OKC_API.HANDLE_EXCEPTIONS
223: (l_api_name,
224: G_PKG_NAME,
225: 'OKC_API.G_RET_STS_UNEXP_ERROR',
226: x_msg_count,

Line 225: 'OKC_API.G_RET_STS_UNEXP_ERROR',

221: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
222: x_return_status := OKC_API.HANDLE_EXCEPTIONS
223: (l_api_name,
224: G_PKG_NAME,
225: 'OKC_API.G_RET_STS_UNEXP_ERROR',
226: x_msg_count,
227: x_msg_data,
228: '_PUB');
229: WHEN OTHERS THEN

Line 230: x_return_status := OKC_API.HANDLE_EXCEPTIONS

226: x_msg_count,
227: x_msg_data,
228: '_PUB');
229: WHEN OTHERS THEN
230: x_return_status := OKC_API.HANDLE_EXCEPTIONS
231: (l_api_name,
232: G_PKG_NAME,
233: 'OTHERS',
234: x_msg_count,

Line 253: l_return_status := OKC_API.G_RET_STS_SUCCESS;

249: l_return_status Varchar2(1);
250: l_api_name CONSTANT VARCHAR2(30) := 'get_contract_details';
251: --l_api_version CONSTANT NUMBER := 1.0;
252: BEGIN
253: l_return_status := OKC_API.G_RET_STS_SUCCESS;
254:
255: l_return_status := OKC_API.START_ACTIVITY(l_api_name
256: ,p_init_msg_list
257: ,'_PUB'

Line 255: l_return_status := OKC_API.START_ACTIVITY(l_api_name

251: --l_api_version CONSTANT NUMBER := 1.0;
252: BEGIN
253: l_return_status := OKC_API.G_RET_STS_SUCCESS;
254:
255: l_return_status := OKC_API.START_ACTIVITY(l_api_name
256: ,p_init_msg_list
257: ,'_PUB'
258: ,x_return_status
259: );

Line 260: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

256: ,p_init_msg_list
257: ,'_PUB'
258: ,x_return_status
259: );
260: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
263: RAISE OKC_API.G_EXCEPTION_ERROR;
264: END IF;

Line 261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

257: ,'_PUB'
258: ,x_return_status
259: );
260: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
263: RAISE OKC_API.G_EXCEPTION_ERROR;
264: END IF;
265:

Line 262: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

258: ,x_return_status
259: );
260: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
263: RAISE OKC_API.G_EXCEPTION_ERROR;
264: END IF;
265:
266: OKS_ENTITLEMENTS_PVT.get_contract_details

Line 263: RAISE OKC_API.G_EXCEPTION_ERROR;

259: );
260: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
262: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
263: RAISE OKC_API.G_EXCEPTION_ERROR;
264: END IF;
265:
266: OKS_ENTITLEMENTS_PVT.get_contract_details
267: (p_api_version

Line 275: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

271: ,x_msg_count
272: ,x_msg_data
273: ,x_all_lines);
274:
275: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
277: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
278: RAISE OKC_API.G_EXCEPTION_ERROR;
279: END IF;

Line 276: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

272: ,x_msg_data
273: ,x_all_lines);
274:
275: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
277: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
278: RAISE OKC_API.G_EXCEPTION_ERROR;
279: END IF;
280:

Line 277: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

273: ,x_all_lines);
274:
275: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
277: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
278: RAISE OKC_API.G_EXCEPTION_ERROR;
279: END IF;
280:
281: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 278: RAISE OKC_API.G_EXCEPTION_ERROR;

274:
275: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
277: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
278: RAISE OKC_API.G_EXCEPTION_ERROR;
279: END IF;
280:
281: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
282:

Line 281: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

277: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
278: RAISE OKC_API.G_EXCEPTION_ERROR;
279: END IF;
280:
281: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
282:
283: EXCEPTION
284: WHEN OKC_API.G_EXCEPTION_ERROR THEN
285: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 284: WHEN OKC_API.G_EXCEPTION_ERROR THEN

280:
281: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
282:
283: EXCEPTION
284: WHEN OKC_API.G_EXCEPTION_ERROR THEN
285: x_return_status := OKC_API.HANDLE_EXCEPTIONS
286: (l_api_name,
287: G_PKG_NAME,
288: 'OKC_API.G_RET_STS_ERROR',

Line 285: x_return_status := OKC_API.HANDLE_EXCEPTIONS

281: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
282:
283: EXCEPTION
284: WHEN OKC_API.G_EXCEPTION_ERROR THEN
285: x_return_status := OKC_API.HANDLE_EXCEPTIONS
286: (l_api_name,
287: G_PKG_NAME,
288: 'OKC_API.G_RET_STS_ERROR',
289: x_msg_count,

Line 288: 'OKC_API.G_RET_STS_ERROR',

284: WHEN OKC_API.G_EXCEPTION_ERROR THEN
285: x_return_status := OKC_API.HANDLE_EXCEPTIONS
286: (l_api_name,
287: G_PKG_NAME,
288: 'OKC_API.G_RET_STS_ERROR',
289: x_msg_count,
290: x_msg_data,
291: '_PUB');
292: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 292: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

288: 'OKC_API.G_RET_STS_ERROR',
289: x_msg_count,
290: x_msg_data,
291: '_PUB');
292: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
293: x_return_status := OKC_API.HANDLE_EXCEPTIONS
294: (l_api_name,
295: G_PKG_NAME,
296: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 293: x_return_status := OKC_API.HANDLE_EXCEPTIONS

289: x_msg_count,
290: x_msg_data,
291: '_PUB');
292: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
293: x_return_status := OKC_API.HANDLE_EXCEPTIONS
294: (l_api_name,
295: G_PKG_NAME,
296: 'OKC_API.G_RET_STS_UNEXP_ERROR',
297: x_msg_count,

Line 296: 'OKC_API.G_RET_STS_UNEXP_ERROR',

292: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
293: x_return_status := OKC_API.HANDLE_EXCEPTIONS
294: (l_api_name,
295: G_PKG_NAME,
296: 'OKC_API.G_RET_STS_UNEXP_ERROR',
297: x_msg_count,
298: x_msg_data,
299: '_PUB');
300: WHEN OTHERS THEN

Line 301: x_return_status := OKC_API.HANDLE_EXCEPTIONS

297: x_msg_count,
298: x_msg_data,
299: '_PUB');
300: WHEN OTHERS THEN
301: x_return_status := OKC_API.HANDLE_EXCEPTIONS
302: (l_api_name,
303: G_PKG_NAME,
304: 'OTHERS',
305: x_msg_count,

Line 324: l_return_status := OKC_API.G_RET_STS_SUCCESS;

320: l_return_status Varchar2(1);
321: l_api_name CONSTANT VARCHAR2(30) := 'get_coverage_levels';
322: --l_api_version CONSTANT NUMBER := 1.0;
323: BEGIN
324: l_return_status := OKC_API.G_RET_STS_SUCCESS;
325:
326: l_return_status := OKC_API.START_ACTIVITY(l_api_name
327: ,p_init_msg_list
328: ,'_PUB'

Line 326: l_return_status := OKC_API.START_ACTIVITY(l_api_name

322: --l_api_version CONSTANT NUMBER := 1.0;
323: BEGIN
324: l_return_status := OKC_API.G_RET_STS_SUCCESS;
325:
326: l_return_status := OKC_API.START_ACTIVITY(l_api_name
327: ,p_init_msg_list
328: ,'_PUB'
329: ,x_return_status
330: );

Line 331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

327: ,p_init_msg_list
328: ,'_PUB'
329: ,x_return_status
330: );
331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
334: RAISE OKC_API.G_EXCEPTION_ERROR;
335: END IF;

Line 332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

328: ,'_PUB'
329: ,x_return_status
330: );
331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
334: RAISE OKC_API.G_EXCEPTION_ERROR;
335: END IF;
336:

Line 333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

329: ,x_return_status
330: );
331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
334: RAISE OKC_API.G_EXCEPTION_ERROR;
335: END IF;
336:
337: OKS_ENTITLEMENTS_PVT.get_coverage_levels

Line 334: RAISE OKC_API.G_EXCEPTION_ERROR;

330: );
331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
334: RAISE OKC_API.G_EXCEPTION_ERROR;
335: END IF;
336:
337: OKS_ENTITLEMENTS_PVT.get_coverage_levels
338: (p_api_version

Line 347: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

343: ,x_msg_data
344: ,x_covered_levels);
345:
346:
347: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
349: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
350: RAISE OKC_API.G_EXCEPTION_ERROR;
351: END IF;

Line 348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

344: ,x_covered_levels);
345:
346:
347: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
349: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
350: RAISE OKC_API.G_EXCEPTION_ERROR;
351: END IF;
352:

Line 349: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

345:
346:
347: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
349: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
350: RAISE OKC_API.G_EXCEPTION_ERROR;
351: END IF;
352:
353: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 350: RAISE OKC_API.G_EXCEPTION_ERROR;

346:
347: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
349: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
350: RAISE OKC_API.G_EXCEPTION_ERROR;
351: END IF;
352:
353: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
354:

Line 353: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

349: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
350: RAISE OKC_API.G_EXCEPTION_ERROR;
351: END IF;
352:
353: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
354:
355: EXCEPTION
356: WHEN OKC_API.G_EXCEPTION_ERROR THEN
357: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 356: WHEN OKC_API.G_EXCEPTION_ERROR THEN

352:
353: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
354:
355: EXCEPTION
356: WHEN OKC_API.G_EXCEPTION_ERROR THEN
357: x_return_status := OKC_API.HANDLE_EXCEPTIONS
358: (l_api_name,
359: G_PKG_NAME,
360: 'OKC_API.G_RET_STS_ERROR',

Line 357: x_return_status := OKC_API.HANDLE_EXCEPTIONS

353: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
354:
355: EXCEPTION
356: WHEN OKC_API.G_EXCEPTION_ERROR THEN
357: x_return_status := OKC_API.HANDLE_EXCEPTIONS
358: (l_api_name,
359: G_PKG_NAME,
360: 'OKC_API.G_RET_STS_ERROR',
361: x_msg_count,

Line 360: 'OKC_API.G_RET_STS_ERROR',

356: WHEN OKC_API.G_EXCEPTION_ERROR THEN
357: x_return_status := OKC_API.HANDLE_EXCEPTIONS
358: (l_api_name,
359: G_PKG_NAME,
360: 'OKC_API.G_RET_STS_ERROR',
361: x_msg_count,
362: x_msg_data,
363: '_PUB');
364: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 364: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

360: 'OKC_API.G_RET_STS_ERROR',
361: x_msg_count,
362: x_msg_data,
363: '_PUB');
364: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
366: (l_api_name,
367: G_PKG_NAME,
368: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 365: x_return_status := OKC_API.HANDLE_EXCEPTIONS

361: x_msg_count,
362: x_msg_data,
363: '_PUB');
364: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
366: (l_api_name,
367: G_PKG_NAME,
368: 'OKC_API.G_RET_STS_UNEXP_ERROR',
369: x_msg_count,

Line 368: 'OKC_API.G_RET_STS_UNEXP_ERROR',

364: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
366: (l_api_name,
367: G_PKG_NAME,
368: 'OKC_API.G_RET_STS_UNEXP_ERROR',
369: x_msg_count,
370: x_msg_data,
371: '_PUB');
372: WHEN OTHERS THEN

Line 373: x_return_status := OKC_API.HANDLE_EXCEPTIONS

369: x_msg_count,
370: x_msg_data,
371: '_PUB');
372: WHEN OTHERS THEN
373: x_return_status := OKC_API.HANDLE_EXCEPTIONS
374: (l_api_name,
375: G_PKG_NAME,
376: 'OTHERS',
377: x_msg_count,

Line 395: l_return_status := OKC_API.G_RET_STS_SUCCESS;

391: IS
392: l_return_status Varchar2(1);
393: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
394: BEGIN
395: l_return_status := OKC_API.G_RET_STS_SUCCESS;
396:
397: l_return_status := OKC_API.START_ACTIVITY(l_api_name
398: ,p_init_msg_list
399: ,'_PUB'

Line 397: l_return_status := OKC_API.START_ACTIVITY(l_api_name

393: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
394: BEGIN
395: l_return_status := OKC_API.G_RET_STS_SUCCESS;
396:
397: l_return_status := OKC_API.START_ACTIVITY(l_api_name
398: ,p_init_msg_list
399: ,'_PUB'
400: ,x_return_status
401: );

Line 402: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

398: ,p_init_msg_list
399: ,'_PUB'
400: ,x_return_status
401: );
402: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
405: RAISE OKC_API.G_EXCEPTION_ERROR;
406: END IF;

Line 403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

399: ,'_PUB'
400: ,x_return_status
401: );
402: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
405: RAISE OKC_API.G_EXCEPTION_ERROR;
406: END IF;
407:

Line 404: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

400: ,x_return_status
401: );
402: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
405: RAISE OKC_API.G_EXCEPTION_ERROR;
406: END IF;
407:
408: OKS_ENTITLEMENTS_PVT.get_contracts

Line 405: RAISE OKC_API.G_EXCEPTION_ERROR;

401: );
402: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
403: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
405: RAISE OKC_API.G_EXCEPTION_ERROR;
406: END IF;
407:
408: OKS_ENTITLEMENTS_PVT.get_contracts
409: (p_api_version

Line 418: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

414: ,x_msg_data
415: ,x_ent_contracts);
416:
417:
418: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
421: RAISE OKC_API.G_EXCEPTION_ERROR;
422: END IF;

Line 419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

415: ,x_ent_contracts);
416:
417:
418: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
421: RAISE OKC_API.G_EXCEPTION_ERROR;
422: END IF;
423:

Line 420: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

416:
417:
418: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
421: RAISE OKC_API.G_EXCEPTION_ERROR;
422: END IF;
423:
424: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 421: RAISE OKC_API.G_EXCEPTION_ERROR;

417:
418: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
419: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
421: RAISE OKC_API.G_EXCEPTION_ERROR;
422: END IF;
423:
424: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
425:

Line 424: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

420: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
421: RAISE OKC_API.G_EXCEPTION_ERROR;
422: END IF;
423:
424: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
425:
426: EXCEPTION
427: WHEN OKC_API.G_EXCEPTION_ERROR THEN
428: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 427: WHEN OKC_API.G_EXCEPTION_ERROR THEN

423:
424: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
425:
426: EXCEPTION
427: WHEN OKC_API.G_EXCEPTION_ERROR THEN
428: x_return_status := OKC_API.HANDLE_EXCEPTIONS
429: (l_api_name,
430: G_PKG_NAME,
431: 'OKC_API.G_RET_STS_ERROR',

Line 428: x_return_status := OKC_API.HANDLE_EXCEPTIONS

424: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
425:
426: EXCEPTION
427: WHEN OKC_API.G_EXCEPTION_ERROR THEN
428: x_return_status := OKC_API.HANDLE_EXCEPTIONS
429: (l_api_name,
430: G_PKG_NAME,
431: 'OKC_API.G_RET_STS_ERROR',
432: x_msg_count,

Line 431: 'OKC_API.G_RET_STS_ERROR',

427: WHEN OKC_API.G_EXCEPTION_ERROR THEN
428: x_return_status := OKC_API.HANDLE_EXCEPTIONS
429: (l_api_name,
430: G_PKG_NAME,
431: 'OKC_API.G_RET_STS_ERROR',
432: x_msg_count,
433: x_msg_data,
434: '_PUB');
435: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 435: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

431: 'OKC_API.G_RET_STS_ERROR',
432: x_msg_count,
433: x_msg_data,
434: '_PUB');
435: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
436: x_return_status := OKC_API.HANDLE_EXCEPTIONS
437: (l_api_name,
438: G_PKG_NAME,
439: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 436: x_return_status := OKC_API.HANDLE_EXCEPTIONS

432: x_msg_count,
433: x_msg_data,
434: '_PUB');
435: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
436: x_return_status := OKC_API.HANDLE_EXCEPTIONS
437: (l_api_name,
438: G_PKG_NAME,
439: 'OKC_API.G_RET_STS_UNEXP_ERROR',
440: x_msg_count,

Line 439: 'OKC_API.G_RET_STS_UNEXP_ERROR',

435: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
436: x_return_status := OKC_API.HANDLE_EXCEPTIONS
437: (l_api_name,
438: G_PKG_NAME,
439: 'OKC_API.G_RET_STS_UNEXP_ERROR',
440: x_msg_count,
441: x_msg_data,
442: '_PUB');
443: WHEN OTHERS THEN

Line 444: x_return_status := OKC_API.HANDLE_EXCEPTIONS

440: x_msg_count,
441: x_msg_data,
442: '_PUB');
443: WHEN OTHERS THEN
444: x_return_status := OKC_API.HANDLE_EXCEPTIONS
445: (l_api_name,
446: G_PKG_NAME,
447: 'OTHERS',
448: x_msg_count,

Line 466: l_return_status := OKC_API.G_RET_STS_SUCCESS;

462: IS
463: l_return_status Varchar2(1);
464: l_api_name CONSTANT VARCHAR2(30) := 'get_contacts';
465: BEGIN
466: l_return_status := OKC_API.G_RET_STS_SUCCESS;
467:
468: l_return_status := OKC_API.START_ACTIVITY(l_api_name
469: ,p_init_msg_list
470: ,'_PUB'

Line 468: l_return_status := OKC_API.START_ACTIVITY(l_api_name

464: l_api_name CONSTANT VARCHAR2(30) := 'get_contacts';
465: BEGIN
466: l_return_status := OKC_API.G_RET_STS_SUCCESS;
467:
468: l_return_status := OKC_API.START_ACTIVITY(l_api_name
469: ,p_init_msg_list
470: ,'_PUB'
471: ,x_return_status
472: );

Line 473: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

469: ,p_init_msg_list
470: ,'_PUB'
471: ,x_return_status
472: );
473: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
476: RAISE OKC_API.G_EXCEPTION_ERROR;
477: END IF;

Line 474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

470: ,'_PUB'
471: ,x_return_status
472: );
473: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
476: RAISE OKC_API.G_EXCEPTION_ERROR;
477: END IF;
478:

Line 475: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

471: ,x_return_status
472: );
473: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
476: RAISE OKC_API.G_EXCEPTION_ERROR;
477: END IF;
478:
479: OKS_ENTITLEMENTS_PVT.get_contacts

Line 476: RAISE OKC_API.G_EXCEPTION_ERROR;

472: );
473: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
476: RAISE OKC_API.G_EXCEPTION_ERROR;
477: END IF;
478:
479: OKS_ENTITLEMENTS_PVT.get_contacts
480: (p_api_version

Line 489: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

485: ,x_msg_count
486: ,x_msg_data
487: ,x_ent_contacts);
488:
489: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
492: RAISE OKC_API.G_EXCEPTION_ERROR;
493: END IF;

Line 490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

486: ,x_msg_data
487: ,x_ent_contacts);
488:
489: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
492: RAISE OKC_API.G_EXCEPTION_ERROR;
493: END IF;
494:

Line 491: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

487: ,x_ent_contacts);
488:
489: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
492: RAISE OKC_API.G_EXCEPTION_ERROR;
493: END IF;
494:
495: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 492: RAISE OKC_API.G_EXCEPTION_ERROR;

488:
489: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
492: RAISE OKC_API.G_EXCEPTION_ERROR;
493: END IF;
494:
495: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
496:

Line 495: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

491: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
492: RAISE OKC_API.G_EXCEPTION_ERROR;
493: END IF;
494:
495: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
496:
497: EXCEPTION
498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
499: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 498: WHEN OKC_API.G_EXCEPTION_ERROR THEN

494:
495: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
496:
497: EXCEPTION
498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
499: x_return_status := OKC_API.HANDLE_EXCEPTIONS
500: (l_api_name,
501: G_PKG_NAME,
502: 'OKC_API.G_RET_STS_ERROR',

Line 499: x_return_status := OKC_API.HANDLE_EXCEPTIONS

495: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
496:
497: EXCEPTION
498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
499: x_return_status := OKC_API.HANDLE_EXCEPTIONS
500: (l_api_name,
501: G_PKG_NAME,
502: 'OKC_API.G_RET_STS_ERROR',
503: x_msg_count,

Line 502: 'OKC_API.G_RET_STS_ERROR',

498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
499: x_return_status := OKC_API.HANDLE_EXCEPTIONS
500: (l_api_name,
501: G_PKG_NAME,
502: 'OKC_API.G_RET_STS_ERROR',
503: x_msg_count,
504: x_msg_data,
505: '_PUB');
506: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 506: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

502: 'OKC_API.G_RET_STS_ERROR',
503: x_msg_count,
504: x_msg_data,
505: '_PUB');
506: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
507: x_return_status := OKC_API.HANDLE_EXCEPTIONS
508: (l_api_name,
509: G_PKG_NAME,
510: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 507: x_return_status := OKC_API.HANDLE_EXCEPTIONS

503: x_msg_count,
504: x_msg_data,
505: '_PUB');
506: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
507: x_return_status := OKC_API.HANDLE_EXCEPTIONS
508: (l_api_name,
509: G_PKG_NAME,
510: 'OKC_API.G_RET_STS_UNEXP_ERROR',
511: x_msg_count,

Line 510: 'OKC_API.G_RET_STS_UNEXP_ERROR',

506: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
507: x_return_status := OKC_API.HANDLE_EXCEPTIONS
508: (l_api_name,
509: G_PKG_NAME,
510: 'OKC_API.G_RET_STS_UNEXP_ERROR',
511: x_msg_count,
512: x_msg_data,
513: '_PUB');
514: WHEN OTHERS THEN

Line 515: x_return_status := OKC_API.HANDLE_EXCEPTIONS

511: x_msg_count,
512: x_msg_data,
513: '_PUB');
514: WHEN OTHERS THEN
515: x_return_status := OKC_API.HANDLE_EXCEPTIONS
516: (l_api_name,
517: G_PKG_NAME,
518: 'OTHERS',
519: x_msg_count,

Line 538: l_return_status := OKC_API.G_RET_STS_SUCCESS;

534: IS
535: l_return_status Varchar2(1);
536: l_api_name CONSTANT VARCHAR2(30) := 'get_preffered_engineers';
537: BEGIN
538: l_return_status := OKC_API.G_RET_STS_SUCCESS;
539:
540: l_return_status := OKC_API.START_ACTIVITY(l_api_name
541: ,p_init_msg_list
542: ,'_PUB'

Line 540: l_return_status := OKC_API.START_ACTIVITY(l_api_name

536: l_api_name CONSTANT VARCHAR2(30) := 'get_preffered_engineers';
537: BEGIN
538: l_return_status := OKC_API.G_RET_STS_SUCCESS;
539:
540: l_return_status := OKC_API.START_ACTIVITY(l_api_name
541: ,p_init_msg_list
542: ,'_PUB'
543: ,x_return_status
544: );

Line 545: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

541: ,p_init_msg_list
542: ,'_PUB'
543: ,x_return_status
544: );
545: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
548: RAISE OKC_API.G_EXCEPTION_ERROR;
549: END IF;

Line 546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

542: ,'_PUB'
543: ,x_return_status
544: );
545: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
548: RAISE OKC_API.G_EXCEPTION_ERROR;
549: END IF;
550:

Line 547: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

543: ,x_return_status
544: );
545: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
548: RAISE OKC_API.G_EXCEPTION_ERROR;
549: END IF;
550:
551: OKS_ENTITLEMENTS_PVT.get_preferred_engineers

Line 548: RAISE OKC_API.G_EXCEPTION_ERROR;

544: );
545: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
546: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
548: RAISE OKC_API.G_EXCEPTION_ERROR;
549: END IF;
550:
551: OKS_ENTITLEMENTS_PVT.get_preferred_engineers
552: (p_api_version

Line 562: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

558: ,x_msg_count
559: ,x_msg_data
560: ,x_prf_engineers);
561:
562: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
565: RAISE OKC_API.G_EXCEPTION_ERROR;
566: END IF;

Line 563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

559: ,x_msg_data
560: ,x_prf_engineers);
561:
562: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
565: RAISE OKC_API.G_EXCEPTION_ERROR;
566: END IF;
567:

Line 564: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

560: ,x_prf_engineers);
561:
562: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
565: RAISE OKC_API.G_EXCEPTION_ERROR;
566: END IF;
567:
568: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 565: RAISE OKC_API.G_EXCEPTION_ERROR;

561:
562: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
565: RAISE OKC_API.G_EXCEPTION_ERROR;
566: END IF;
567:
568: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
569:

Line 568: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

564: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
565: RAISE OKC_API.G_EXCEPTION_ERROR;
566: END IF;
567:
568: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
569:
570: EXCEPTION
571: WHEN OKC_API.G_EXCEPTION_ERROR THEN
572: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 571: WHEN OKC_API.G_EXCEPTION_ERROR THEN

567:
568: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
569:
570: EXCEPTION
571: WHEN OKC_API.G_EXCEPTION_ERROR THEN
572: x_return_status := OKC_API.HANDLE_EXCEPTIONS
573: (l_api_name,
574: G_PKG_NAME,
575: 'OKC_API.G_RET_STS_ERROR',

Line 572: x_return_status := OKC_API.HANDLE_EXCEPTIONS

568: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
569:
570: EXCEPTION
571: WHEN OKC_API.G_EXCEPTION_ERROR THEN
572: x_return_status := OKC_API.HANDLE_EXCEPTIONS
573: (l_api_name,
574: G_PKG_NAME,
575: 'OKC_API.G_RET_STS_ERROR',
576: x_msg_count,

Line 575: 'OKC_API.G_RET_STS_ERROR',

571: WHEN OKC_API.G_EXCEPTION_ERROR THEN
572: x_return_status := OKC_API.HANDLE_EXCEPTIONS
573: (l_api_name,
574: G_PKG_NAME,
575: 'OKC_API.G_RET_STS_ERROR',
576: x_msg_count,
577: x_msg_data,
578: '_PUB');
579: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 579: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

575: 'OKC_API.G_RET_STS_ERROR',
576: x_msg_count,
577: x_msg_data,
578: '_PUB');
579: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
580: x_return_status := OKC_API.HANDLE_EXCEPTIONS
581: (l_api_name,
582: G_PKG_NAME,
583: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 580: x_return_status := OKC_API.HANDLE_EXCEPTIONS

576: x_msg_count,
577: x_msg_data,
578: '_PUB');
579: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
580: x_return_status := OKC_API.HANDLE_EXCEPTIONS
581: (l_api_name,
582: G_PKG_NAME,
583: 'OKC_API.G_RET_STS_UNEXP_ERROR',
584: x_msg_count,

Line 583: 'OKC_API.G_RET_STS_UNEXP_ERROR',

579: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
580: x_return_status := OKC_API.HANDLE_EXCEPTIONS
581: (l_api_name,
582: G_PKG_NAME,
583: 'OKC_API.G_RET_STS_UNEXP_ERROR',
584: x_msg_count,
585: x_msg_data,
586: '_PUB');
587: WHEN OTHERS THEN

Line 588: x_return_status := OKC_API.HANDLE_EXCEPTIONS

584: x_msg_count,
585: x_msg_data,
586: '_PUB');
587: WHEN OTHERS THEN
588: x_return_status := OKC_API.HANDLE_EXCEPTIONS
589: (l_api_name,
590: G_PKG_NAME,
591: 'OTHERS',
592: x_msg_count,

Line 609: l_return_status := OKC_API.G_RET_STS_SUCCESS;

605: IS
606: l_return_status Varchar2(1);
607: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
608: BEGIN
609: l_return_status := OKC_API.G_RET_STS_SUCCESS;
610:
611: l_return_status := OKC_API.START_ACTIVITY(l_api_name
612: ,p_init_msg_list
613: ,'_PUB'

Line 611: l_return_status := OKC_API.START_ACTIVITY(l_api_name

607: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
608: BEGIN
609: l_return_status := OKC_API.G_RET_STS_SUCCESS;
610:
611: l_return_status := OKC_API.START_ACTIVITY(l_api_name
612: ,p_init_msg_list
613: ,'_PUB'
614: ,x_return_status
615: );

Line 616: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

612: ,p_init_msg_list
613: ,'_PUB'
614: ,x_return_status
615: );
616: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
618: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
619: RAISE OKC_API.G_EXCEPTION_ERROR;
620: END IF;

Line 617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

613: ,'_PUB'
614: ,x_return_status
615: );
616: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
618: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
619: RAISE OKC_API.G_EXCEPTION_ERROR;
620: END IF;
621:

Line 618: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

614: ,x_return_status
615: );
616: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
618: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
619: RAISE OKC_API.G_EXCEPTION_ERROR;
620: END IF;
621:
622: OKS_ENTITLEMENTS_PVT.get_contracts

Line 619: RAISE OKC_API.G_EXCEPTION_ERROR;

615: );
616: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
618: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
619: RAISE OKC_API.G_EXCEPTION_ERROR;
620: END IF;
621:
622: OKS_ENTITLEMENTS_PVT.get_contracts
623: (p_api_version

Line 632: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

628: ,x_msg_data
629: ,x_ent_contracts);
630:
631:
632: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
635: RAISE OKC_API.G_EXCEPTION_ERROR;
636: END IF;

Line 633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

629: ,x_ent_contracts);
630:
631:
632: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
635: RAISE OKC_API.G_EXCEPTION_ERROR;
636: END IF;
637:

Line 634: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

630:
631:
632: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
635: RAISE OKC_API.G_EXCEPTION_ERROR;
636: END IF;
637:
638: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 635: RAISE OKC_API.G_EXCEPTION_ERROR;

631:
632: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
635: RAISE OKC_API.G_EXCEPTION_ERROR;
636: END IF;
637:
638: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
639:

Line 638: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

634: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
635: RAISE OKC_API.G_EXCEPTION_ERROR;
636: END IF;
637:
638: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
639:
640: EXCEPTION
641: WHEN OKC_API.G_EXCEPTION_ERROR THEN
642: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 641: WHEN OKC_API.G_EXCEPTION_ERROR THEN

637:
638: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
639:
640: EXCEPTION
641: WHEN OKC_API.G_EXCEPTION_ERROR THEN
642: x_return_status := OKC_API.HANDLE_EXCEPTIONS
643: (l_api_name,
644: G_PKG_NAME,
645: 'OKC_API.G_RET_STS_ERROR',

Line 642: x_return_status := OKC_API.HANDLE_EXCEPTIONS

638: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
639:
640: EXCEPTION
641: WHEN OKC_API.G_EXCEPTION_ERROR THEN
642: x_return_status := OKC_API.HANDLE_EXCEPTIONS
643: (l_api_name,
644: G_PKG_NAME,
645: 'OKC_API.G_RET_STS_ERROR',
646: x_msg_count,

Line 645: 'OKC_API.G_RET_STS_ERROR',

641: WHEN OKC_API.G_EXCEPTION_ERROR THEN
642: x_return_status := OKC_API.HANDLE_EXCEPTIONS
643: (l_api_name,
644: G_PKG_NAME,
645: 'OKC_API.G_RET_STS_ERROR',
646: x_msg_count,
647: x_msg_data,
648: '_PUB');
649: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 649: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

645: 'OKC_API.G_RET_STS_ERROR',
646: x_msg_count,
647: x_msg_data,
648: '_PUB');
649: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
650: x_return_status := OKC_API.HANDLE_EXCEPTIONS
651: (l_api_name,
652: G_PKG_NAME,
653: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 650: x_return_status := OKC_API.HANDLE_EXCEPTIONS

646: x_msg_count,
647: x_msg_data,
648: '_PUB');
649: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
650: x_return_status := OKC_API.HANDLE_EXCEPTIONS
651: (l_api_name,
652: G_PKG_NAME,
653: 'OKC_API.G_RET_STS_UNEXP_ERROR',
654: x_msg_count,

Line 653: 'OKC_API.G_RET_STS_UNEXP_ERROR',

649: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
650: x_return_status := OKC_API.HANDLE_EXCEPTIONS
651: (l_api_name,
652: G_PKG_NAME,
653: 'OKC_API.G_RET_STS_UNEXP_ERROR',
654: x_msg_count,
655: x_msg_data,
656: '_PUB');
657: WHEN OTHERS THEN

Line 658: x_return_status := OKC_API.HANDLE_EXCEPTIONS

654: x_msg_count,
655: x_msg_data,
656: '_PUB');
657: WHEN OTHERS THEN
658: x_return_status := OKC_API.HANDLE_EXCEPTIONS
659: (l_api_name,
660: G_PKG_NAME,
661: 'OTHERS',
662: x_msg_count,

Line 680: l_return_status := OKC_API.G_RET_STS_SUCCESS;

676: IS
677: l_return_status Varchar2(1);
678: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
679: BEGIN
680: l_return_status := OKC_API.G_RET_STS_SUCCESS;
681:
682: l_return_status := OKC_API.START_ACTIVITY(l_api_name
683: ,p_init_msg_list
684: ,'_PUB'

Line 682: l_return_status := OKC_API.START_ACTIVITY(l_api_name

678: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
679: BEGIN
680: l_return_status := OKC_API.G_RET_STS_SUCCESS;
681:
682: l_return_status := OKC_API.START_ACTIVITY(l_api_name
683: ,p_init_msg_list
684: ,'_PUB'
685: ,x_return_status
686: );

Line 687: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

683: ,p_init_msg_list
684: ,'_PUB'
685: ,x_return_status
686: );
687: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
688: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
689: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
690: RAISE OKC_API.G_EXCEPTION_ERROR;
691: END IF;

Line 688: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

684: ,'_PUB'
685: ,x_return_status
686: );
687: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
688: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
689: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
690: RAISE OKC_API.G_EXCEPTION_ERROR;
691: END IF;
692:

Line 689: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

685: ,x_return_status
686: );
687: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
688: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
689: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
690: RAISE OKC_API.G_EXCEPTION_ERROR;
691: END IF;
692:
693: OKS_ENTITLEMENTS_PVT.get_contracts

Line 690: RAISE OKC_API.G_EXCEPTION_ERROR;

686: );
687: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
688: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
689: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
690: RAISE OKC_API.G_EXCEPTION_ERROR;
691: END IF;
692:
693: OKS_ENTITLEMENTS_PVT.get_contracts
694: (p_api_version

Line 703: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

699: ,x_msg_data
700: ,x_ent_contracts);
701:
702:
703: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
704: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
705: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
706: RAISE OKC_API.G_EXCEPTION_ERROR;
707: END IF;

Line 704: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

700: ,x_ent_contracts);
701:
702:
703: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
704: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
705: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
706: RAISE OKC_API.G_EXCEPTION_ERROR;
707: END IF;
708:

Line 705: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

701:
702:
703: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
704: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
705: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
706: RAISE OKC_API.G_EXCEPTION_ERROR;
707: END IF;
708:
709: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 706: RAISE OKC_API.G_EXCEPTION_ERROR;

702:
703: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
704: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
705: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
706: RAISE OKC_API.G_EXCEPTION_ERROR;
707: END IF;
708:
709: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
710:

Line 709: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

705: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
706: RAISE OKC_API.G_EXCEPTION_ERROR;
707: END IF;
708:
709: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
710:
711: EXCEPTION
712: WHEN OKC_API.G_EXCEPTION_ERROR THEN
713: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 712: WHEN OKC_API.G_EXCEPTION_ERROR THEN

708:
709: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
710:
711: EXCEPTION
712: WHEN OKC_API.G_EXCEPTION_ERROR THEN
713: x_return_status := OKC_API.HANDLE_EXCEPTIONS
714: (l_api_name,
715: G_PKG_NAME,
716: 'OKC_API.G_RET_STS_ERROR',

Line 713: x_return_status := OKC_API.HANDLE_EXCEPTIONS

709: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
710:
711: EXCEPTION
712: WHEN OKC_API.G_EXCEPTION_ERROR THEN
713: x_return_status := OKC_API.HANDLE_EXCEPTIONS
714: (l_api_name,
715: G_PKG_NAME,
716: 'OKC_API.G_RET_STS_ERROR',
717: x_msg_count,

Line 716: 'OKC_API.G_RET_STS_ERROR',

712: WHEN OKC_API.G_EXCEPTION_ERROR THEN
713: x_return_status := OKC_API.HANDLE_EXCEPTIONS
714: (l_api_name,
715: G_PKG_NAME,
716: 'OKC_API.G_RET_STS_ERROR',
717: x_msg_count,
718: x_msg_data,
719: '_PUB');
720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

716: 'OKC_API.G_RET_STS_ERROR',
717: x_msg_count,
718: x_msg_data,
719: '_PUB');
720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := OKC_API.HANDLE_EXCEPTIONS
722: (l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 721: x_return_status := OKC_API.HANDLE_EXCEPTIONS

717: x_msg_count,
718: x_msg_data,
719: '_PUB');
720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := OKC_API.HANDLE_EXCEPTIONS
722: (l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',
725: x_msg_count,

Line 724: 'OKC_API.G_RET_STS_UNEXP_ERROR',

720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := OKC_API.HANDLE_EXCEPTIONS
722: (l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',
725: x_msg_count,
726: x_msg_data,
727: '_PUB');
728: WHEN OTHERS THEN

Line 729: x_return_status := OKC_API.HANDLE_EXCEPTIONS

725: x_msg_count,
726: x_msg_data,
727: '_PUB');
728: WHEN OTHERS THEN
729: x_return_status := OKC_API.HANDLE_EXCEPTIONS
730: (l_api_name,
731: G_PKG_NAME,
732: 'OTHERS',
733: x_msg_count,

Line 754: l_return_status := OKC_API.G_RET_STS_SUCCESS;

750: l_return_status Varchar2(1);
751: l_api_name CONSTANT VARCHAR2(30) := 'get_react_resolve_by_time';
752: --l_api_version CONSTANT NUMBER := 1.0;
753: BEGIN
754: l_return_status := OKC_API.G_RET_STS_SUCCESS;
755:
756: l_return_status := OKC_API.START_ACTIVITY(l_api_name
757: ,p_init_msg_list
758: ,'_PUB'

Line 756: l_return_status := OKC_API.START_ACTIVITY(l_api_name

752: --l_api_version CONSTANT NUMBER := 1.0;
753: BEGIN
754: l_return_status := OKC_API.G_RET_STS_SUCCESS;
755:
756: l_return_status := OKC_API.START_ACTIVITY(l_api_name
757: ,p_init_msg_list
758: ,'_PUB'
759: ,x_return_status
760: );

Line 761: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

757: ,p_init_msg_list
758: ,'_PUB'
759: ,x_return_status
760: );
761: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
764: RAISE OKC_API.G_EXCEPTION_ERROR;
765: END IF;

Line 762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

758: ,'_PUB'
759: ,x_return_status
760: );
761: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
764: RAISE OKC_API.G_EXCEPTION_ERROR;
765: END IF;
766:

Line 763: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

759: ,x_return_status
760: );
761: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
764: RAISE OKC_API.G_EXCEPTION_ERROR;
765: END IF;
766:
767: OKS_ENTITLEMENTS_PVT.get_react_resolve_by_time

Line 764: RAISE OKC_API.G_EXCEPTION_ERROR;

760: );
761: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
762: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
764: RAISE OKC_API.G_EXCEPTION_ERROR;
765: END IF;
766:
767: OKS_ENTITLEMENTS_PVT.get_react_resolve_by_time
768: (p_api_version => p_api_version

Line 777: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

773: ,x_msg_data => x_msg_data
774: ,x_react_rec => x_react_rec
775: ,x_resolve_rec => x_resolve_rec);
776:
777: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;

Line 778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

774: ,x_react_rec => x_react_rec
775: ,x_resolve_rec => x_resolve_rec);
776:
777: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;
782:

Line 779: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

775: ,x_resolve_rec => x_resolve_rec);
776:
777: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;
782:
783: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 780: RAISE OKC_API.G_EXCEPTION_ERROR;

776:
777: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;
782:
783: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
784:

Line 783: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

779: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;
782:
783: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
784:
785: EXCEPTION
786: WHEN OKC_API.G_EXCEPTION_ERROR THEN
787: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 786: WHEN OKC_API.G_EXCEPTION_ERROR THEN

782:
783: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
784:
785: EXCEPTION
786: WHEN OKC_API.G_EXCEPTION_ERROR THEN
787: x_return_status := OKC_API.HANDLE_EXCEPTIONS
788: (l_api_name,
789: G_PKG_NAME,
790: 'OKC_API.G_RET_STS_ERROR',

Line 787: x_return_status := OKC_API.HANDLE_EXCEPTIONS

783: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
784:
785: EXCEPTION
786: WHEN OKC_API.G_EXCEPTION_ERROR THEN
787: x_return_status := OKC_API.HANDLE_EXCEPTIONS
788: (l_api_name,
789: G_PKG_NAME,
790: 'OKC_API.G_RET_STS_ERROR',
791: x_msg_count,

Line 790: 'OKC_API.G_RET_STS_ERROR',

786: WHEN OKC_API.G_EXCEPTION_ERROR THEN
787: x_return_status := OKC_API.HANDLE_EXCEPTIONS
788: (l_api_name,
789: G_PKG_NAME,
790: 'OKC_API.G_RET_STS_ERROR',
791: x_msg_count,
792: x_msg_data,
793: '_PUB');
794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

790: 'OKC_API.G_RET_STS_ERROR',
791: x_msg_count,
792: x_msg_data,
793: '_PUB');
794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
795: x_return_status := OKC_API.HANDLE_EXCEPTIONS
796: (l_api_name,
797: G_PKG_NAME,
798: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 795: x_return_status := OKC_API.HANDLE_EXCEPTIONS

791: x_msg_count,
792: x_msg_data,
793: '_PUB');
794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
795: x_return_status := OKC_API.HANDLE_EXCEPTIONS
796: (l_api_name,
797: G_PKG_NAME,
798: 'OKC_API.G_RET_STS_UNEXP_ERROR',
799: x_msg_count,

Line 798: 'OKC_API.G_RET_STS_UNEXP_ERROR',

794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
795: x_return_status := OKC_API.HANDLE_EXCEPTIONS
796: (l_api_name,
797: G_PKG_NAME,
798: 'OKC_API.G_RET_STS_UNEXP_ERROR',
799: x_msg_count,
800: x_msg_data,
801: '_PUB');
802: WHEN OTHERS THEN

Line 803: x_return_status := OKC_API.HANDLE_EXCEPTIONS

799: x_msg_count,
800: x_msg_data,
801: '_PUB');
802: WHEN OTHERS THEN
803: x_return_status := OKC_API.HANDLE_EXCEPTIONS
804: (l_api_name,
805: G_PKG_NAME,
806: 'OTHERS',
807: x_msg_count,

Line 827: l_return_status := OKC_API.G_RET_STS_SUCCESS;

823: IS
824: l_return_status Varchar2(1);
825: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
826: BEGIN
827: l_return_status := OKC_API.G_RET_STS_SUCCESS;
828:
829: l_return_status := OKC_API.START_ACTIVITY(l_api_name
830: ,p_init_msg_list
831: ,'_PUB'

Line 829: l_return_status := OKC_API.START_ACTIVITY(l_api_name

825: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
826: BEGIN
827: l_return_status := OKC_API.G_RET_STS_SUCCESS;
828:
829: l_return_status := OKC_API.START_ACTIVITY(l_api_name
830: ,p_init_msg_list
831: ,'_PUB'
832: ,x_return_status
833: );

Line 834: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

830: ,p_init_msg_list
831: ,'_PUB'
832: ,x_return_status
833: );
834: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
836: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
837: RAISE OKC_API.G_EXCEPTION_ERROR;
838: END IF;

Line 835: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

831: ,'_PUB'
832: ,x_return_status
833: );
834: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
836: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
837: RAISE OKC_API.G_EXCEPTION_ERROR;
838: END IF;
839:

Line 836: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

832: ,x_return_status
833: );
834: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
836: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
837: RAISE OKC_API.G_EXCEPTION_ERROR;
838: END IF;
839:
840: OKS_ENTITLEMENTS_PVT.get_contracts

Line 837: RAISE OKC_API.G_EXCEPTION_ERROR;

833: );
834: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
836: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
837: RAISE OKC_API.G_EXCEPTION_ERROR;
838: END IF;
839:
840: OKS_ENTITLEMENTS_PVT.get_contracts
841: (P_API_Version => P_API_Version

Line 850: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

846: ,X_Msg_Data => X_Msg_Data
847: ,X_Ent_Contracts => X_Ent_Contracts);
848:
849:
850: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
851: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
852: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
853: RAISE OKC_API.G_EXCEPTION_ERROR;
854: END IF;

Line 851: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

847: ,X_Ent_Contracts => X_Ent_Contracts);
848:
849:
850: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
851: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
852: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
853: RAISE OKC_API.G_EXCEPTION_ERROR;
854: END IF;
855:

Line 852: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

848:
849:
850: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
851: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
852: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
853: RAISE OKC_API.G_EXCEPTION_ERROR;
854: END IF;
855:
856: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 853: RAISE OKC_API.G_EXCEPTION_ERROR;

849:
850: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
851: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
852: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
853: RAISE OKC_API.G_EXCEPTION_ERROR;
854: END IF;
855:
856: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
857:

Line 856: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

852: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
853: RAISE OKC_API.G_EXCEPTION_ERROR;
854: END IF;
855:
856: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
857:
858: EXCEPTION
859: WHEN OKC_API.G_EXCEPTION_ERROR THEN
860: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 859: WHEN OKC_API.G_EXCEPTION_ERROR THEN

855:
856: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
857:
858: EXCEPTION
859: WHEN OKC_API.G_EXCEPTION_ERROR THEN
860: x_return_status := OKC_API.HANDLE_EXCEPTIONS
861: (l_api_name,
862: G_PKG_NAME,
863: 'OKC_API.G_RET_STS_ERROR',

Line 860: x_return_status := OKC_API.HANDLE_EXCEPTIONS

856: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
857:
858: EXCEPTION
859: WHEN OKC_API.G_EXCEPTION_ERROR THEN
860: x_return_status := OKC_API.HANDLE_EXCEPTIONS
861: (l_api_name,
862: G_PKG_NAME,
863: 'OKC_API.G_RET_STS_ERROR',
864: x_msg_count,

Line 863: 'OKC_API.G_RET_STS_ERROR',

859: WHEN OKC_API.G_EXCEPTION_ERROR THEN
860: x_return_status := OKC_API.HANDLE_EXCEPTIONS
861: (l_api_name,
862: G_PKG_NAME,
863: 'OKC_API.G_RET_STS_ERROR',
864: x_msg_count,
865: x_msg_data,
866: '_PUB');
867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

863: 'OKC_API.G_RET_STS_ERROR',
864: x_msg_count,
865: x_msg_data,
866: '_PUB');
867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
868: x_return_status := OKC_API.HANDLE_EXCEPTIONS
869: (l_api_name,
870: G_PKG_NAME,
871: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 868: x_return_status := OKC_API.HANDLE_EXCEPTIONS

864: x_msg_count,
865: x_msg_data,
866: '_PUB');
867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
868: x_return_status := OKC_API.HANDLE_EXCEPTIONS
869: (l_api_name,
870: G_PKG_NAME,
871: 'OKC_API.G_RET_STS_UNEXP_ERROR',
872: x_msg_count,

Line 871: 'OKC_API.G_RET_STS_UNEXP_ERROR',

867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
868: x_return_status := OKC_API.HANDLE_EXCEPTIONS
869: (l_api_name,
870: G_PKG_NAME,
871: 'OKC_API.G_RET_STS_UNEXP_ERROR',
872: x_msg_count,
873: x_msg_data,
874: '_PUB');
875: WHEN OTHERS THEN

Line 876: x_return_status := OKC_API.HANDLE_EXCEPTIONS

872: x_msg_count,
873: x_msg_data,
874: '_PUB');
875: WHEN OTHERS THEN
876: x_return_status := OKC_API.HANDLE_EXCEPTIONS
877: (l_api_name,
878: G_PKG_NAME,
879: 'OTHERS',
880: x_msg_count,

Line 902: l_return_status := OKC_API.G_RET_STS_SUCCESS;

898: l_return_status Varchar2(1);
899: l_api_name CONSTANT VARCHAR2(30) := 'get_react_resolve_by_time';
900:
901: BEGIN
902: l_return_status := OKC_API.G_RET_STS_SUCCESS;
903:
904: l_return_status := OKC_API.START_ACTIVITY(l_api_name
905: ,p_init_msg_list
906: ,'_PUB'

Line 904: l_return_status := OKC_API.START_ACTIVITY(l_api_name

900:
901: BEGIN
902: l_return_status := OKC_API.G_RET_STS_SUCCESS;
903:
904: l_return_status := OKC_API.START_ACTIVITY(l_api_name
905: ,p_init_msg_list
906: ,'_PUB'
907: ,x_return_status);
908:

Line 909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

905: ,p_init_msg_list
906: ,'_PUB'
907: ,x_return_status);
908:
909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;

Line 910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

906: ,'_PUB'
907: ,x_return_status);
908:
909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;
914:

Line 911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

907: ,x_return_status);
908:
909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;
914:
915: OKS_ENTITLEMENTS_PVT.Get_Coverage_Type

Line 912: RAISE OKC_API.G_EXCEPTION_ERROR;

908:
909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;
914:
915: OKS_ENTITLEMENTS_PVT.Get_Coverage_Type
916: (P_API_Version => p_api_version

Line 924: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

920: ,X_Msg_Count => x_msg_count
921: ,X_Msg_Data => x_msg_data
922: ,X_Coverage_Type => X_Coverage_Type);
923:
924: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
925: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
927: RAISE OKC_API.G_EXCEPTION_ERROR;
928: END IF;

Line 925: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

921: ,X_Msg_Data => x_msg_data
922: ,X_Coverage_Type => X_Coverage_Type);
923:
924: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
925: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
927: RAISE OKC_API.G_EXCEPTION_ERROR;
928: END IF;
929:

Line 926: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

922: ,X_Coverage_Type => X_Coverage_Type);
923:
924: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
925: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
927: RAISE OKC_API.G_EXCEPTION_ERROR;
928: END IF;
929:
930: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 927: RAISE OKC_API.G_EXCEPTION_ERROR;

923:
924: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
925: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
927: RAISE OKC_API.G_EXCEPTION_ERROR;
928: END IF;
929:
930: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
931:

Line 930: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

926: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
927: RAISE OKC_API.G_EXCEPTION_ERROR;
928: END IF;
929:
930: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
931:
932: EXCEPTION
933:
934: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 934: WHEN OKC_API.G_EXCEPTION_ERROR THEN

930: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
931:
932: EXCEPTION
933:
934: WHEN OKC_API.G_EXCEPTION_ERROR THEN
935:
936: x_return_status := OKC_API.HANDLE_EXCEPTIONS
937: (l_api_name,
938: G_PKG_NAME,

Line 936: x_return_status := OKC_API.HANDLE_EXCEPTIONS

932: EXCEPTION
933:
934: WHEN OKC_API.G_EXCEPTION_ERROR THEN
935:
936: x_return_status := OKC_API.HANDLE_EXCEPTIONS
937: (l_api_name,
938: G_PKG_NAME,
939: 'OKC_API.G_RET_STS_ERROR',
940: x_msg_count,

Line 939: 'OKC_API.G_RET_STS_ERROR',

935:
936: x_return_status := OKC_API.HANDLE_EXCEPTIONS
937: (l_api_name,
938: G_PKG_NAME,
939: 'OKC_API.G_RET_STS_ERROR',
940: x_msg_count,
941: x_msg_data,
942: '_PUB');
943:

Line 944: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

940: x_msg_count,
941: x_msg_data,
942: '_PUB');
943:
944: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
945:
946: x_return_status := OKC_API.HANDLE_EXCEPTIONS
947: (l_api_name,
948: G_PKG_NAME,

Line 946: x_return_status := OKC_API.HANDLE_EXCEPTIONS

942: '_PUB');
943:
944: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
945:
946: x_return_status := OKC_API.HANDLE_EXCEPTIONS
947: (l_api_name,
948: G_PKG_NAME,
949: 'OKC_API.G_RET_STS_UNEXP_ERROR',
950: x_msg_count,

Line 949: 'OKC_API.G_RET_STS_UNEXP_ERROR',

945:
946: x_return_status := OKC_API.HANDLE_EXCEPTIONS
947: (l_api_name,
948: G_PKG_NAME,
949: 'OKC_API.G_RET_STS_UNEXP_ERROR',
950: x_msg_count,
951: x_msg_data,
952: '_PUB');
953:

Line 956: x_return_status := OKC_API.HANDLE_EXCEPTIONS

952: '_PUB');
953:
954: WHEN OTHERS THEN
955:
956: x_return_status := OKC_API.HANDLE_EXCEPTIONS
957: (l_api_name,
958: G_PKG_NAME,
959: 'OTHERS',
960: x_msg_count,

Line 988: l_return_status := OKC_API.G_RET_STS_SUCCESS;

984: l_api_name CONSTANT VARCHAR2(30) := 'Get_HighImp_CP_Contract';
985:
986: BEGIN
987:
988: l_return_status := OKC_API.G_RET_STS_SUCCESS;
989:
990: l_return_status := OKC_API.START_ACTIVITY(l_api_name
991: ,p_init_msg_list
992: ,'_PUB'

Line 990: l_return_status := OKC_API.START_ACTIVITY(l_api_name

986: BEGIN
987:
988: l_return_status := OKC_API.G_RET_STS_SUCCESS;
989:
990: l_return_status := OKC_API.START_ACTIVITY(l_api_name
991: ,p_init_msg_list
992: ,'_PUB'
993: ,x_return_status);
994:

Line 995: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

991: ,p_init_msg_list
992: ,'_PUB'
993: ,x_return_status);
994:
995: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
998: RAISE OKC_API.G_EXCEPTION_ERROR;
999: END IF;

Line 996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

992: ,'_PUB'
993: ,x_return_status);
994:
995: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
998: RAISE OKC_API.G_EXCEPTION_ERROR;
999: END IF;
1000:

Line 997: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

993: ,x_return_status);
994:
995: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
998: RAISE OKC_API.G_EXCEPTION_ERROR;
999: END IF;
1000:
1001:

Line 998: RAISE OKC_API.G_EXCEPTION_ERROR;

994:
995: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
998: RAISE OKC_API.G_EXCEPTION_ERROR;
999: END IF;
1000:
1001:
1002:

Line 1012: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1008: ,X_Msg_Count => x_msg_count
1009: ,X_Msg_Data => x_msg_data
1010: ,X_Importance_Lvl => X_Importance_Lvl);
1011:
1012: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;

Line 1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1009: ,X_Msg_Data => x_msg_data
1010: ,X_Importance_Lvl => X_Importance_Lvl);
1011:
1012: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;
1017:

Line 1014: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1010: ,X_Importance_Lvl => X_Importance_Lvl);
1011:
1012: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;
1017:
1018: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1015: RAISE OKC_API.G_EXCEPTION_ERROR;

1011:
1012: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;
1017:
1018: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1019:

Line 1018: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

1014: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;
1017:
1018: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1019:
1020: EXCEPTION
1021:
1022: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1022: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1018: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1019:
1020: EXCEPTION
1021:
1022: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1023:
1024: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1025: (l_api_name,
1026: G_PKG_NAME,

Line 1024: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1020: EXCEPTION
1021:
1022: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1023:
1024: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1025: (l_api_name,
1026: G_PKG_NAME,
1027: 'OKC_API.G_RET_STS_ERROR',
1028: x_msg_count,

Line 1027: 'OKC_API.G_RET_STS_ERROR',

1023:
1024: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1025: (l_api_name,
1026: G_PKG_NAME,
1027: 'OKC_API.G_RET_STS_ERROR',
1028: x_msg_count,
1029: x_msg_data,
1030: '_PUB');
1031:

Line 1032: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1028: x_msg_count,
1029: x_msg_data,
1030: '_PUB');
1031:
1032: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1033:
1034: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1035: (l_api_name,
1036: G_PKG_NAME,

Line 1034: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1030: '_PUB');
1031:
1032: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1033:
1034: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1035: (l_api_name,
1036: G_PKG_NAME,
1037: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1038: x_msg_count,

Line 1037: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1033:
1034: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1035: (l_api_name,
1036: G_PKG_NAME,
1037: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1038: x_msg_count,
1039: x_msg_data,
1040: '_PUB');
1041:

Line 1044: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1040: '_PUB');
1041:
1042: WHEN OTHERS THEN
1043:
1044: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1045: (l_api_name,
1046: G_PKG_NAME,
1047: 'OTHERS',
1048: x_msg_count,

Line 1080: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1076: lx_csi VARCHAR2(1);
1077:
1078: BEGIN
1079:
1080: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1081: lx_csi := 'F';
1082:
1083:
1084: l_return_status := OKC_API.START_ACTIVITY(l_api_name

Line 1084: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1080: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1081: lx_csi := 'F';
1082:
1083:
1084: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1085: ,p_init_msg_list
1086: ,'_PUB'
1087: ,x_return_status);
1088:

Line 1089: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1085: ,p_init_msg_list
1086: ,'_PUB'
1087: ,x_return_status);
1088:
1089: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;

Line 1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1086: ,'_PUB'
1087: ,x_return_status);
1088:
1089: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094:

Line 1091: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1087: ,x_return_status);
1088:
1089: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094:
1095:

Line 1092: RAISE OKC_API.G_EXCEPTION_ERROR;

1088:
1089: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094:
1095:
1096: OKS_ENTITLEMENTS_PVT.OKS_VALIDATE_SYSTEM(P_API_Version => p_api_version

Line 1106: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1102: ,X_Msg_Count => x_msg_count
1103: ,X_Msg_Data => x_msg_data
1104: ,X_SYSTEM_VALID => X_SYSTEM_VALID);
1105:
1106: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1108: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;

Line 1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1103: ,X_Msg_Data => x_msg_data
1104: ,X_SYSTEM_VALID => X_SYSTEM_VALID);
1105:
1106: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1108: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111:

Line 1108: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1104: ,X_SYSTEM_VALID => X_SYSTEM_VALID);
1105:
1106: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1108: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111:
1112: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1109: RAISE OKC_API.G_EXCEPTION_ERROR;

1105:
1106: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1108: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111:
1112: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1113: --return lx_csi;

Line 1112: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

1108: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111:
1112: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1113: --return lx_csi;
1114:
1115: EXCEPTION
1116:

Line 1117: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1113: --return lx_csi;
1114:
1115: EXCEPTION
1116:
1117: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1118:
1119: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1120: (l_api_name,
1121: G_PKG_NAME,

Line 1119: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1115: EXCEPTION
1116:
1117: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1118:
1119: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1120: (l_api_name,
1121: G_PKG_NAME,
1122: 'OKC_API.G_RET_STS_ERROR',
1123: x_msg_count,

Line 1122: 'OKC_API.G_RET_STS_ERROR',

1118:
1119: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1120: (l_api_name,
1121: G_PKG_NAME,
1122: 'OKC_API.G_RET_STS_ERROR',
1123: x_msg_count,
1124: x_msg_data,
1125: '_PUB');
1126: -- return lx_csi;

Line 1127: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1123: x_msg_count,
1124: x_msg_data,
1125: '_PUB');
1126: -- return lx_csi;
1127: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1128:
1129: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1130: (l_api_name,
1131: G_PKG_NAME,

Line 1129: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1125: '_PUB');
1126: -- return lx_csi;
1127: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1128:
1129: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1130: (l_api_name,
1131: G_PKG_NAME,
1132: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1133: x_msg_count,

Line 1132: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1128:
1129: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1130: (l_api_name,
1131: G_PKG_NAME,
1132: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1133: x_msg_count,
1134: x_msg_data,
1135: '_PUB');
1136: -- return lx_csi;

Line 1139: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1135: '_PUB');
1136: -- return lx_csi;
1137: WHEN OTHERS THEN
1138:
1139: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1140: (l_api_name,
1141: G_PKG_NAME,
1142: 'OTHERS',
1143: x_msg_count,

Line 1167: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1163: IS
1164: l_return_status Varchar2(1);
1165: l_api_name CONSTANT VARCHAR2(30) := 'Default_Contline_System';
1166: BEGIN
1167: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1168:
1169: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1170: ,p_init_msg_list
1171: ,'_PUB'

Line 1169: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1165: l_api_name CONSTANT VARCHAR2(30) := 'Default_Contline_System';
1166: BEGIN
1167: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1168:
1169: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1170: ,p_init_msg_list
1171: ,'_PUB'
1172: ,x_return_status
1173: );

Line 1175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1171: ,'_PUB'
1172: ,x_return_status
1173: );
1174:
1175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1178: RAISE OKC_API.G_EXCEPTION_ERROR;
1179: END IF;

Line 1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1172: ,x_return_status
1173: );
1174:
1175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1178: RAISE OKC_API.G_EXCEPTION_ERROR;
1179: END IF;
1180:

Line 1177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1173: );
1174:
1175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1178: RAISE OKC_API.G_EXCEPTION_ERROR;
1179: END IF;
1180:
1181: OKS_ENTITLEMENTS_PVT.Default_Contline_System

Line 1178: RAISE OKC_API.G_EXCEPTION_ERROR;

1174:
1175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1178: RAISE OKC_API.G_EXCEPTION_ERROR;
1179: END IF;
1180:
1181: OKS_ENTITLEMENTS_PVT.Default_Contline_System
1182: (P_API_Version => p_api_version

Line 1192: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1188: ,X_Msg_Data => x_msg_data
1189: ,X_Ent_Contracts => X_Ent_Contracts);
1190:
1191:
1192: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1194: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1195: RAISE OKC_API.G_EXCEPTION_ERROR;
1196: END IF;

Line 1193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1189: ,X_Ent_Contracts => X_Ent_Contracts);
1190:
1191:
1192: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1194: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1195: RAISE OKC_API.G_EXCEPTION_ERROR;
1196: END IF;
1197:

Line 1194: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1190:
1191:
1192: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1194: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1195: RAISE OKC_API.G_EXCEPTION_ERROR;
1196: END IF;
1197:
1198: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1195: RAISE OKC_API.G_EXCEPTION_ERROR;

1191:
1192: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1194: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1195: RAISE OKC_API.G_EXCEPTION_ERROR;
1196: END IF;
1197:
1198: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1199:

Line 1198: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

1194: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1195: RAISE OKC_API.G_EXCEPTION_ERROR;
1196: END IF;
1197:
1198: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1199:
1200: EXCEPTION
1201: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1202: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1201: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1197:
1198: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1199:
1200: EXCEPTION
1201: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1202: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1203: (l_api_name,
1204: G_PKG_NAME,
1205: 'OKC_API.G_RET_STS_ERROR',

Line 1202: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1198: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1199:
1200: EXCEPTION
1201: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1202: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1203: (l_api_name,
1204: G_PKG_NAME,
1205: 'OKC_API.G_RET_STS_ERROR',
1206: x_msg_count,

Line 1205: 'OKC_API.G_RET_STS_ERROR',

1201: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1202: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1203: (l_api_name,
1204: G_PKG_NAME,
1205: 'OKC_API.G_RET_STS_ERROR',
1206: x_msg_count,
1207: x_msg_data,
1208: '_PUB');
1209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1205: 'OKC_API.G_RET_STS_ERROR',
1206: x_msg_count,
1207: x_msg_data,
1208: '_PUB');
1209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1210: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1211: (l_api_name,
1212: G_PKG_NAME,
1213: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1210: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1206: x_msg_count,
1207: x_msg_data,
1208: '_PUB');
1209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1210: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1211: (l_api_name,
1212: G_PKG_NAME,
1213: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1214: x_msg_count,

Line 1213: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1210: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1211: (l_api_name,
1212: G_PKG_NAME,
1213: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1214: x_msg_count,
1215: x_msg_data,
1216: '_PUB');
1217: WHEN OTHERS THEN

Line 1218: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1214: x_msg_count,
1215: x_msg_data,
1216: '_PUB');
1217: WHEN OTHERS THEN
1218: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1219: (l_api_name,
1220: G_PKG_NAME,
1221: 'OTHERS',
1222: x_msg_count,

Line 1239: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1235: IS
1236: l_return_status Varchar2(1);
1237: l_api_name CONSTANT VARCHAR2(30) := 'Get_cov_txn_groups';
1238: BEGIN
1239: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1240:
1241: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1242: ,p_init_msg_list
1243: ,'_PUB'

Line 1241: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1237: l_api_name CONSTANT VARCHAR2(30) := 'Get_cov_txn_groups';
1238: BEGIN
1239: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1240:
1241: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1242: ,p_init_msg_list
1243: ,'_PUB'
1244: ,x_return_status
1245: );

Line 1247: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1243: ,'_PUB'
1244: ,x_return_status
1245: );
1246:
1247: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1250: RAISE OKC_API.G_EXCEPTION_ERROR;
1251: END IF;

Line 1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1244: ,x_return_status
1245: );
1246:
1247: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1250: RAISE OKC_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:

Line 1249: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1245: );
1246:
1247: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1250: RAISE OKC_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:
1253:

Line 1250: RAISE OKC_API.G_EXCEPTION_ERROR;

1246:
1247: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1250: RAISE OKC_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:
1253:
1254: OKS_ENTITLEMENTS_PVT.Get_cov_txn_groups

Line 1264: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1260: ,x_msg_data => x_msg_data
1261: ,x_cov_txn_grp_lines => x_cov_txn_grp_lines);
1262:
1263:
1264: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1267: RAISE OKC_API.G_EXCEPTION_ERROR;
1268: END IF;

Line 1265: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1261: ,x_cov_txn_grp_lines => x_cov_txn_grp_lines);
1262:
1263:
1264: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1267: RAISE OKC_API.G_EXCEPTION_ERROR;
1268: END IF;
1269:

Line 1266: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1262:
1263:
1264: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1267: RAISE OKC_API.G_EXCEPTION_ERROR;
1268: END IF;
1269:
1270: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1267: RAISE OKC_API.G_EXCEPTION_ERROR;

1263:
1264: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1267: RAISE OKC_API.G_EXCEPTION_ERROR;
1268: END IF;
1269:
1270: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1271:

Line 1270: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

1266: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1267: RAISE OKC_API.G_EXCEPTION_ERROR;
1268: END IF;
1269:
1270: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1271:
1272: EXCEPTION
1273: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1274: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1273: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1269:
1270: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1271:
1272: EXCEPTION
1273: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1274: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1275: (l_api_name,
1276: G_PKG_NAME,
1277: 'OKC_API.G_RET_STS_ERROR',

Line 1274: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1270: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1271:
1272: EXCEPTION
1273: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1274: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1275: (l_api_name,
1276: G_PKG_NAME,
1277: 'OKC_API.G_RET_STS_ERROR',
1278: x_msg_count,

Line 1277: 'OKC_API.G_RET_STS_ERROR',

1273: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1274: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1275: (l_api_name,
1276: G_PKG_NAME,
1277: 'OKC_API.G_RET_STS_ERROR',
1278: x_msg_count,
1279: x_msg_data,
1280: '_PUB');
1281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1277: 'OKC_API.G_RET_STS_ERROR',
1278: x_msg_count,
1279: x_msg_data,
1280: '_PUB');
1281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1282: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1283: (l_api_name,
1284: G_PKG_NAME,
1285: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1282: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1278: x_msg_count,
1279: x_msg_data,
1280: '_PUB');
1281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1282: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1283: (l_api_name,
1284: G_PKG_NAME,
1285: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1286: x_msg_count,

Line 1285: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1282: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1283: (l_api_name,
1284: G_PKG_NAME,
1285: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1286: x_msg_count,
1287: x_msg_data,
1288: '_PUB');
1289: WHEN OTHERS THEN

Line 1290: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1286: x_msg_count,
1287: x_msg_data,
1288: '_PUB');
1289: WHEN OTHERS THEN
1290: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1291: (l_api_name,
1292: G_PKG_NAME,
1293: 'OTHERS',
1294: x_msg_count,

Line 1314: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1310: IS
1311: l_return_status Varchar2(1);
1312: l_api_name CONSTANT VARCHAR2(30) := 'Get_txn_billing_types';
1313: BEGIN
1314: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1315:
1316: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1317: ,p_init_msg_list
1318: ,'_PUB'

Line 1316: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1312: l_api_name CONSTANT VARCHAR2(30) := 'Get_txn_billing_types';
1313: BEGIN
1314: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1315:
1316: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1317: ,p_init_msg_list
1318: ,'_PUB'
1319: ,x_return_status
1320: );

Line 1322: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1318: ,'_PUB'
1319: ,x_return_status
1320: );
1321:
1322: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1324: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1325: RAISE OKC_API.G_EXCEPTION_ERROR;
1326: END IF;

Line 1323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1319: ,x_return_status
1320: );
1321:
1322: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1324: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1325: RAISE OKC_API.G_EXCEPTION_ERROR;
1326: END IF;
1327:

Line 1324: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1320: );
1321:
1322: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1324: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1325: RAISE OKC_API.G_EXCEPTION_ERROR;
1326: END IF;
1327:
1328:

Line 1325: RAISE OKC_API.G_EXCEPTION_ERROR;

1321:
1322: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1324: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1325: RAISE OKC_API.G_EXCEPTION_ERROR;
1326: END IF;
1327:
1328:
1329: OKS_ENTITLEMENTS_PVT.Get_txn_billing_types

Line 1341: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1337: ,x_txn_bill_types => x_txn_bill_types
1338: ,x_txn_bill_rates => x_txn_bill_rates);
1339:
1340:
1341: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1343: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1344: RAISE OKC_API.G_EXCEPTION_ERROR;
1345: END IF;

Line 1342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1338: ,x_txn_bill_rates => x_txn_bill_rates);
1339:
1340:
1341: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1343: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1344: RAISE OKC_API.G_EXCEPTION_ERROR;
1345: END IF;
1346:

Line 1343: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1339:
1340:
1341: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1343: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1344: RAISE OKC_API.G_EXCEPTION_ERROR;
1345: END IF;
1346:
1347: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1344: RAISE OKC_API.G_EXCEPTION_ERROR;

1340:
1341: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1343: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1344: RAISE OKC_API.G_EXCEPTION_ERROR;
1345: END IF;
1346:
1347: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1348:

Line 1347: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

1343: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1344: RAISE OKC_API.G_EXCEPTION_ERROR;
1345: END IF;
1346:
1347: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1348:
1349: EXCEPTION
1350: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1351: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1350: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1346:
1347: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1348:
1349: EXCEPTION
1350: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1351: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1352: (l_api_name,
1353: G_PKG_NAME,
1354: 'OKC_API.G_RET_STS_ERROR',

Line 1351: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1347: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1348:
1349: EXCEPTION
1350: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1351: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1352: (l_api_name,
1353: G_PKG_NAME,
1354: 'OKC_API.G_RET_STS_ERROR',
1355: x_msg_count,

Line 1354: 'OKC_API.G_RET_STS_ERROR',

1350: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1351: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1352: (l_api_name,
1353: G_PKG_NAME,
1354: 'OKC_API.G_RET_STS_ERROR',
1355: x_msg_count,
1356: x_msg_data,
1357: '_PUB');
1358: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1358: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1354: 'OKC_API.G_RET_STS_ERROR',
1355: x_msg_count,
1356: x_msg_data,
1357: '_PUB');
1358: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1359: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1360: (l_api_name,
1361: G_PKG_NAME,
1362: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1359: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1355: x_msg_count,
1356: x_msg_data,
1357: '_PUB');
1358: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1359: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1360: (l_api_name,
1361: G_PKG_NAME,
1362: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1363: x_msg_count,

Line 1362: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1358: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1359: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1360: (l_api_name,
1361: G_PKG_NAME,
1362: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1363: x_msg_count,
1364: x_msg_data,
1365: '_PUB');
1366: WHEN OTHERS THEN

Line 1367: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1363: x_msg_count,
1364: x_msg_data,
1365: '_PUB');
1366: WHEN OTHERS THEN
1367: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1368: (l_api_name,
1369: G_PKG_NAME,
1370: 'OTHERS',
1371: x_msg_count,

Line 1391: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1387: l_return_status Varchar2(1);
1388: l_api_name CONSTANT VARCHAR2(30) := 'search_contracts';
1389:
1390: BEGIN
1391: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1392:
1393: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1394: ,p_init_msg_list
1395: ,'_PUB'

Line 1393: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1389:
1390: BEGIN
1391: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1392:
1393: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1394: ,p_init_msg_list
1395: ,'_PUB'
1396: ,x_return_status
1397: );

Line 1398: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1394: ,p_init_msg_list
1395: ,'_PUB'
1396: ,x_return_status
1397: );
1398: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;

Line 1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1395: ,'_PUB'
1396: ,x_return_status
1397: );
1398: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;
1403:

Line 1400: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1396: ,x_return_status
1397: );
1398: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;
1403:
1404: OKS_ENTITLEMENTS_PVT.search_contracts

Line 1401: RAISE OKC_API.G_EXCEPTION_ERROR;

1397: );
1398: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;
1403:
1404: OKS_ENTITLEMENTS_PVT.search_contracts
1405: (p_api_version

Line 1414: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1410: ,x_msg_count
1411: ,x_msg_data
1412: ,x_contract_tbl);
1413:
1414: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1415: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1416: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1417: RAISE OKC_API.G_EXCEPTION_ERROR;
1418: END IF;

Line 1415: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1411: ,x_msg_data
1412: ,x_contract_tbl);
1413:
1414: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1415: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1416: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1417: RAISE OKC_API.G_EXCEPTION_ERROR;
1418: END IF;
1419:

Line 1416: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1412: ,x_contract_tbl);
1413:
1414: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1415: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1416: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1417: RAISE OKC_API.G_EXCEPTION_ERROR;
1418: END IF;
1419:
1420: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1417: RAISE OKC_API.G_EXCEPTION_ERROR;

1413:
1414: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1415: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1416: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1417: RAISE OKC_API.G_EXCEPTION_ERROR;
1418: END IF;
1419:
1420: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1421:

Line 1420: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

1416: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1417: RAISE OKC_API.G_EXCEPTION_ERROR;
1418: END IF;
1419:
1420: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1421:
1422: EXCEPTION
1423: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1424: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1423: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1419:
1420: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1421:
1422: EXCEPTION
1423: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1424: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1425: (l_api_name,
1426: G_PKG_NAME,
1427: 'OKC_API.G_RET_STS_ERROR',

Line 1424: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1420: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1421:
1422: EXCEPTION
1423: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1424: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1425: (l_api_name,
1426: G_PKG_NAME,
1427: 'OKC_API.G_RET_STS_ERROR',
1428: x_msg_count,

Line 1427: 'OKC_API.G_RET_STS_ERROR',

1423: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1424: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1425: (l_api_name,
1426: G_PKG_NAME,
1427: 'OKC_API.G_RET_STS_ERROR',
1428: x_msg_count,
1429: x_msg_data,
1430: '_PUB');
1431: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1431: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1427: 'OKC_API.G_RET_STS_ERROR',
1428: x_msg_count,
1429: x_msg_data,
1430: '_PUB');
1431: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1433: (l_api_name,
1434: G_PKG_NAME,
1435: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1432: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1428: x_msg_count,
1429: x_msg_data,
1430: '_PUB');
1431: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1433: (l_api_name,
1434: G_PKG_NAME,
1435: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1436: x_msg_count,

Line 1435: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1431: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1433: (l_api_name,
1434: G_PKG_NAME,
1435: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1436: x_msg_count,
1437: x_msg_data,
1438: '_PUB');
1439: WHEN OTHERS THEN

Line 1440: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1436: x_msg_count,
1437: x_msg_data,
1438: '_PUB');
1439: WHEN OTHERS THEN
1440: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1441: (l_api_name,
1442: G_PKG_NAME,
1443: 'OTHERS',
1444: x_msg_count,

Line 1465: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1461: l_return_status Varchar2(1);
1462: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contracts_Expiration';
1463:
1464: BEGIN
1465: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1466:
1467: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1468: ,p_init_msg_list
1469: ,'_PUB'

Line 1467: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1463:
1464: BEGIN
1465: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1466:
1467: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1468: ,p_init_msg_list
1469: ,'_PUB'
1470: ,x_return_status
1471: );

Line 1472: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1468: ,p_init_msg_list
1469: ,'_PUB'
1470: ,x_return_status
1471: );
1472: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;

Line 1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1469: ,'_PUB'
1470: ,x_return_status
1471: );
1472: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:

Line 1474: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1470: ,x_return_status
1471: );
1472: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:
1478: OKS_ENTITLEMENTS_PVT.Get_Contracts_Expiration

Line 1475: RAISE OKC_API.G_EXCEPTION_ERROR;

1471: );
1472: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:
1478: OKS_ENTITLEMENTS_PVT.Get_Contracts_Expiration
1479: (p_api_version

Line 1490: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1486: ,x_Contract_Grace_Period
1487: ,x_Contract_Grace_Duration);
1488:
1489:
1490: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1493: RAISE OKC_API.G_EXCEPTION_ERROR;
1494: END IF;

Line 1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1487: ,x_Contract_Grace_Duration);
1488:
1489:
1490: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1493: RAISE OKC_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:

Line 1492: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1488:
1489:
1490: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1493: RAISE OKC_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:
1496: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1493: RAISE OKC_API.G_EXCEPTION_ERROR;

1489:
1490: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1493: RAISE OKC_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:
1496: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1497:

Line 1496: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

1492: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1493: RAISE OKC_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:
1496: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1497:
1498: EXCEPTION
1499: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1500: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1499: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1495:
1496: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1497:
1498: EXCEPTION
1499: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1500: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1501: (l_api_name,
1502: G_PKG_NAME,
1503: 'OKC_API.G_RET_STS_ERROR',

Line 1500: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1496: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1497:
1498: EXCEPTION
1499: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1500: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1501: (l_api_name,
1502: G_PKG_NAME,
1503: 'OKC_API.G_RET_STS_ERROR',
1504: x_msg_count,

Line 1503: 'OKC_API.G_RET_STS_ERROR',

1499: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1500: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1501: (l_api_name,
1502: G_PKG_NAME,
1503: 'OKC_API.G_RET_STS_ERROR',
1504: x_msg_count,
1505: x_msg_data,
1506: '_PUB');
1507: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1507: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1503: 'OKC_API.G_RET_STS_ERROR',
1504: x_msg_count,
1505: x_msg_data,
1506: '_PUB');
1507: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1508: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1509: (l_api_name,
1510: G_PKG_NAME,
1511: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1508: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1504: x_msg_count,
1505: x_msg_data,
1506: '_PUB');
1507: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1508: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1509: (l_api_name,
1510: G_PKG_NAME,
1511: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1512: x_msg_count,

Line 1511: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1507: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1508: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1509: (l_api_name,
1510: G_PKG_NAME,
1511: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1512: x_msg_count,
1513: x_msg_data,
1514: '_PUB');
1515: WHEN OTHERS THEN

Line 1516: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1512: x_msg_count,
1513: x_msg_data,
1514: '_PUB');
1515: WHEN OTHERS THEN
1516: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1517: (l_api_name,
1518: G_PKG_NAME,
1519: 'OTHERS',
1520: x_msg_count,

Line 1546: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1542: l_return_status Varchar2(1);
1543: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_LINE';
1544:
1545: BEGIN
1546: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1547:
1548: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1549: ,p_init_msg_list
1550: ,'_PUB'

Line 1548: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1544:
1545: BEGIN
1546: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1547:
1548: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1549: ,p_init_msg_list
1550: ,'_PUB'
1551: ,x_return_status
1552: );

Line 1553: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1549: ,p_init_msg_list
1550: ,'_PUB'
1551: ,x_return_status
1552: );
1553: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;

Line 1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1550: ,'_PUB'
1551: ,x_return_status
1552: );
1553: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558:

Line 1555: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1551: ,x_return_status
1552: );
1553: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558:
1559: OKS_ENTITLEMENTS_PVT.VALIDATE_CONTRACT_LINE(p_api_version

Line 1556: RAISE OKC_API.G_EXCEPTION_ERROR;

1552: );
1553: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558:
1559: OKS_ENTITLEMENTS_PVT.VALIDATE_CONTRACT_LINE(p_api_version
1560: ,p_init_msg_list

Line 1573: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1569: ,x_covlevel_tbl_out
1570: ,x_combination_valid );
1571:
1572:
1573: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1574: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1576: RAISE OKC_API.G_EXCEPTION_ERROR;
1577: END IF;

Line 1574: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1570: ,x_combination_valid );
1571:
1572:
1573: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1574: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1576: RAISE OKC_API.G_EXCEPTION_ERROR;
1577: END IF;
1578:

Line 1575: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1571:
1572:
1573: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1574: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1576: RAISE OKC_API.G_EXCEPTION_ERROR;
1577: END IF;
1578:
1579: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1576: RAISE OKC_API.G_EXCEPTION_ERROR;

1572:
1573: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1574: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1576: RAISE OKC_API.G_EXCEPTION_ERROR;
1577: END IF;
1578:
1579: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1580:

Line 1579: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

1575: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1576: RAISE OKC_API.G_EXCEPTION_ERROR;
1577: END IF;
1578:
1579: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1580:
1581:
1582: EXCEPTION
1583: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1583: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1579: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1580:
1581:
1582: EXCEPTION
1583: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1584: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1585: (l_api_name,
1586: G_PKG_NAME,
1587: 'OKC_API.G_RET_STS_ERROR',

Line 1584: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1580:
1581:
1582: EXCEPTION
1583: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1584: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1585: (l_api_name,
1586: G_PKG_NAME,
1587: 'OKC_API.G_RET_STS_ERROR',
1588: x_msg_count,

Line 1587: 'OKC_API.G_RET_STS_ERROR',

1583: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1584: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1585: (l_api_name,
1586: G_PKG_NAME,
1587: 'OKC_API.G_RET_STS_ERROR',
1588: x_msg_count,
1589: x_msg_data,
1590: '_PUB');
1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1587: 'OKC_API.G_RET_STS_ERROR',
1588: x_msg_count,
1589: x_msg_data,
1590: '_PUB');
1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1593: (l_api_name,
1594: G_PKG_NAME,
1595: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1592: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1588: x_msg_count,
1589: x_msg_data,
1590: '_PUB');
1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1593: (l_api_name,
1594: G_PKG_NAME,
1595: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1596: x_msg_count,

Line 1595: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1593: (l_api_name,
1594: G_PKG_NAME,
1595: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1596: x_msg_count,
1597: x_msg_data,
1598: '_PUB');
1599: WHEN OTHERS THEN

Line 1600: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1596: x_msg_count,
1597: x_msg_data,
1598: '_PUB');
1599: WHEN OTHERS THEN
1600: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1601: (l_api_name,
1602: G_PKG_NAME,
1603: 'OTHERS',
1604: x_msg_count,

Line 1628: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1624: l_api_name CONSTANT VARCHAR2(30) := 'Search_Contract_Lines';
1625:
1626: BEGIN
1627:
1628: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1629:
1630: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1631: ,p_init_msg_list
1632: ,'_PUB'

Line 1630: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1626: BEGIN
1627:
1628: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1629:
1630: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1631: ,p_init_msg_list
1632: ,'_PUB'
1633: ,x_return_status
1634: );

Line 1635: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1631: ,p_init_msg_list
1632: ,'_PUB'
1633: ,x_return_status
1634: );
1635: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1637: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;

Line 1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1632: ,'_PUB'
1633: ,x_return_status
1634: );
1635: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1637: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;
1640:

Line 1637: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1633: ,x_return_status
1634: );
1635: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1637: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;
1640:
1641: OKS_ENTITLEMENTS_PVT.Search_Contract_lines

Line 1638: RAISE OKC_API.G_EXCEPTION_ERROR;

1634: );
1635: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1636: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1637: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1638: RAISE OKC_API.G_EXCEPTION_ERROR;
1639: END IF;
1640:
1641: OKS_ENTITLEMENTS_PVT.Search_Contract_lines
1642: ( p_api_version,

Line 1653: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1649: x_msg_data,
1650: x_contract_tbl);
1651:
1652:
1653: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1654: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1655: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1656: RAISE OKC_API.G_EXCEPTION_ERROR;
1657: END IF;

Line 1654: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1650: x_contract_tbl);
1651:
1652:
1653: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1654: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1655: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1656: RAISE OKC_API.G_EXCEPTION_ERROR;
1657: END IF;
1658:

Line 1655: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1651:
1652:
1653: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1654: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1655: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1656: RAISE OKC_API.G_EXCEPTION_ERROR;
1657: END IF;
1658:
1659: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1656: RAISE OKC_API.G_EXCEPTION_ERROR;

1652:
1653: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1654: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1655: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1656: RAISE OKC_API.G_EXCEPTION_ERROR;
1657: END IF;
1658:
1659: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1660:

Line 1659: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

1655: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1656: RAISE OKC_API.G_EXCEPTION_ERROR;
1657: END IF;
1658:
1659: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1660:
1661:
1662: EXCEPTION
1663: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1663: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1659: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1660:
1661:
1662: EXCEPTION
1663: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1664: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1665: (l_api_name,
1666: G_PKG_NAME,
1667: 'OKC_API.G_RET_STS_ERROR',

Line 1664: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1660:
1661:
1662: EXCEPTION
1663: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1664: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1665: (l_api_name,
1666: G_PKG_NAME,
1667: 'OKC_API.G_RET_STS_ERROR',
1668: x_msg_count,

Line 1667: 'OKC_API.G_RET_STS_ERROR',

1663: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1664: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1665: (l_api_name,
1666: G_PKG_NAME,
1667: 'OKC_API.G_RET_STS_ERROR',
1668: x_msg_count,
1669: x_msg_data,
1670: '_PUB');
1671: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1671: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1667: 'OKC_API.G_RET_STS_ERROR',
1668: x_msg_count,
1669: x_msg_data,
1670: '_PUB');
1671: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1672: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1673: (l_api_name,
1674: G_PKG_NAME,
1675: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1672: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1668: x_msg_count,
1669: x_msg_data,
1670: '_PUB');
1671: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1672: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1673: (l_api_name,
1674: G_PKG_NAME,
1675: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1676: x_msg_count,

Line 1675: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1671: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1672: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1673: (l_api_name,
1674: G_PKG_NAME,
1675: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1676: x_msg_count,
1677: x_msg_data,
1678: '_PUB');
1679: WHEN OTHERS THEN

Line 1680: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1676: x_msg_count,
1677: x_msg_data,
1678: '_PUB');
1679: WHEN OTHERS THEN
1680: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1681: (l_api_name,
1682: G_PKG_NAME,
1683: 'OTHERS',
1684: x_msg_count,