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

APPS.OKL_CURE_VNDR_RFND_PUB dependencies on OKC_API

Line 19: x_return_status := OKC_API.START_ACTIVITY(

15: l_api_version CONSTANT NUMBER := 1.0;
16:
17: BEGIN
18:
19: x_return_status := OKC_API.START_ACTIVITY(
20: p_api_name => l_api_name,
21: p_pkg_name => g_pkg_name,
22: p_init_msg_list => p_init_msg_list,
23: l_api_version => l_api_version,

Line 29: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

25: p_api_type => g_api_type,
26: x_return_status => x_return_status);
27:
28: -- check if activity started successfully
29: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
30: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
31: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
32: raise OKC_API.G_EXCEPTION_ERROR;
33: End If;

Line 30: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

26: x_return_status => x_return_status);
27:
28: -- check if activity started successfully
29: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
30: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
31: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
32: raise OKC_API.G_EXCEPTION_ERROR;
33: End If;
34:

Line 31: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

27:
28: -- check if activity started successfully
29: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
30: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
31: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
32: raise OKC_API.G_EXCEPTION_ERROR;
33: End If;
34:
35: OKL_CURE_VNDR_RFND_PVT.create_cure_refund(

Line 32: raise OKC_API.G_EXCEPTION_ERROR;

28: -- check if activity started successfully
29: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
30: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
31: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
32: raise OKC_API.G_EXCEPTION_ERROR;
33: End If;
34:
35: OKL_CURE_VNDR_RFND_PVT.create_cure_refund(
36: p_api_version => p_api_version,

Line 45: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

41: p_cure_rfnd_tbl => p_cure_rfnd_tbl,
42: x_cure_rfnd_tbl => x_cure_rfnd_tbl
43: );
44:
45: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
46: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
47: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
48: raise OKC_API.G_EXCEPTION_ERROR;
49: End If;

Line 46: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

42: x_cure_rfnd_tbl => x_cure_rfnd_tbl
43: );
44:
45: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
46: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
47: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
48: raise OKC_API.G_EXCEPTION_ERROR;
49: End If;
50:

Line 47: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

43: );
44:
45: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
46: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
47: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
48: raise OKC_API.G_EXCEPTION_ERROR;
49: End If;
50:
51: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 48: raise OKC_API.G_EXCEPTION_ERROR;

44:
45: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
46: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
47: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
48: raise OKC_API.G_EXCEPTION_ERROR;
49: End If;
50:
51: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
52:

Line 51: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

47: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
48: raise OKC_API.G_EXCEPTION_ERROR;
49: End If;
50:
51: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
52:
53: EXCEPTION
54: when OKC_API.G_EXCEPTION_ERROR then
55: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 54: when OKC_API.G_EXCEPTION_ERROR then

50:
51: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
52:
53: EXCEPTION
54: when OKC_API.G_EXCEPTION_ERROR then
55: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
56: p_api_name => l_api_name,
57: p_pkg_name => g_pkg_name,
58: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 55: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

51: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
52:
53: EXCEPTION
54: when OKC_API.G_EXCEPTION_ERROR then
55: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
56: p_api_name => l_api_name,
57: p_pkg_name => g_pkg_name,
58: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
59: x_msg_count => x_msg_count,

Line 58: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

54: when OKC_API.G_EXCEPTION_ERROR then
55: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
56: p_api_name => l_api_name,
57: p_pkg_name => g_pkg_name,
58: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
59: x_msg_count => x_msg_count,
60: x_msg_data => x_msg_data,
61: p_api_type => g_api_type);
62:

Line 63: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

59: x_msg_count => x_msg_count,
60: x_msg_data => x_msg_data,
61: p_api_type => g_api_type);
62:
63: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
64: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
65: p_api_name => l_api_name,
66: p_pkg_name => g_pkg_name,
67: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 64: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

60: x_msg_data => x_msg_data,
61: p_api_type => g_api_type);
62:
63: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
64: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
65: p_api_name => l_api_name,
66: p_pkg_name => g_pkg_name,
67: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
68: x_msg_count => x_msg_count,

Line 67: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

63: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
64: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
65: p_api_name => l_api_name,
66: p_pkg_name => g_pkg_name,
67: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
68: x_msg_count => x_msg_count,
69: x_msg_data => x_msg_data,
70: p_api_type => g_api_type);
71:

Line 73: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

69: x_msg_data => x_msg_data,
70: p_api_type => g_api_type);
71:
72: when OTHERS then
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
74: p_api_name => l_api_name,
75: p_pkg_name => g_pkg_name,
76: p_exc_name => 'OTHERS',
77: x_msg_count => x_msg_count,

Line 100: x_return_status := OKC_API.START_ACTIVITY(

96:
97:
98: BEGIN
99:
100: x_return_status := OKC_API.START_ACTIVITY(
101: p_api_name => l_api_name,
102: p_pkg_name => g_pkg_name,
103: p_init_msg_list => p_init_msg_list,
104: l_api_version => l_api_version,

Line 110: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

106: p_api_type => g_api_type,
107: x_return_status => x_return_status);
108:
109: -- check if activity started successfully
110: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
111: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: Elsif (x_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: x_return_status => x_return_status);
108:
109: -- check if activity started successfully
110: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
111: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
113: raise OKC_API.G_EXCEPTION_ERROR;
114: End If;
115:

Line 112: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

108:
109: -- check if activity started successfully
110: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
111: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
113: raise OKC_API.G_EXCEPTION_ERROR;
114: End If;
115:
116: OKL_CURE_VNDR_RFND_PVT.update_cure_refund(

Line 113: raise OKC_API.G_EXCEPTION_ERROR;

109: -- check if activity started successfully
110: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
111: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
113: raise OKC_API.G_EXCEPTION_ERROR;
114: End If;
115:
116: OKL_CURE_VNDR_RFND_PVT.update_cure_refund(
117: p_api_version => p_api_version,

Line 126: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

122: p_cure_rfnd_tbl => p_cure_rfnd_tbl,
123: x_cure_rfnd_tbl => x_cure_rfnd_tbl
124: );
125:
126: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
127: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
129: raise OKC_API.G_EXCEPTION_ERROR;
130: End If;

Line 127: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

123: x_cure_rfnd_tbl => x_cure_rfnd_tbl
124: );
125:
126: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
127: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
129: raise OKC_API.G_EXCEPTION_ERROR;
130: End If;
131:

Line 128: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

124: );
125:
126: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
127: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
129: raise OKC_API.G_EXCEPTION_ERROR;
130: End If;
131:
132: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 129: raise OKC_API.G_EXCEPTION_ERROR;

125:
126: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
127: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
129: raise OKC_API.G_EXCEPTION_ERROR;
130: End If;
131:
132: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
133:

Line 132: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

128: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
129: raise OKC_API.G_EXCEPTION_ERROR;
130: End If;
131:
132: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
133:
134: EXCEPTION
135: when OKC_API.G_EXCEPTION_ERROR then
136: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 135: when OKC_API.G_EXCEPTION_ERROR then

131:
132: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
133:
134: EXCEPTION
135: when OKC_API.G_EXCEPTION_ERROR then
136: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
137: p_api_name => l_api_name,
138: p_pkg_name => g_pkg_name,
139: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 136: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

132: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
133:
134: EXCEPTION
135: when OKC_API.G_EXCEPTION_ERROR then
136: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
137: p_api_name => l_api_name,
138: p_pkg_name => g_pkg_name,
139: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
140: x_msg_count => x_msg_count,

Line 139: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

135: when OKC_API.G_EXCEPTION_ERROR then
136: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
137: p_api_name => l_api_name,
138: p_pkg_name => g_pkg_name,
139: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
140: x_msg_count => x_msg_count,
141: x_msg_data => x_msg_data,
142: p_api_type => g_api_type);
143:

Line 144: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

140: x_msg_count => x_msg_count,
141: x_msg_data => x_msg_data,
142: p_api_type => g_api_type);
143:
144: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
145: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
146: p_api_name => l_api_name,
147: p_pkg_name => g_pkg_name,
148: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 145: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

141: x_msg_data => x_msg_data,
142: p_api_type => g_api_type);
143:
144: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
145: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
146: p_api_name => l_api_name,
147: p_pkg_name => g_pkg_name,
148: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
149: x_msg_count => x_msg_count,

Line 148: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

144: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
145: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
146: p_api_name => l_api_name,
147: p_pkg_name => g_pkg_name,
148: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
149: x_msg_count => x_msg_count,
150: x_msg_data => x_msg_data,
151: p_api_type => g_api_type);
152:

Line 154: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

150: x_msg_data => x_msg_data,
151: p_api_type => g_api_type);
152:
153: when OTHERS then
154: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
155: p_api_name => l_api_name,
156: p_pkg_name => g_pkg_name,
157: p_exc_name => 'OTHERS',
158: x_msg_count => x_msg_count,

Line 178: x_return_status := OKC_API.START_ACTIVITY(

174: l_api_version CONSTANT NUMBER := 1.0;
175:
176: BEGIN
177:
178: x_return_status := OKC_API.START_ACTIVITY(
179: p_api_name => l_api_name,
180: p_pkg_name => g_pkg_name,
181: p_init_msg_list => p_init_msg_list,
182: l_api_version => l_api_version,

Line 188: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

184: p_api_type => g_api_type,
185: x_return_status => x_return_status);
186:
187: -- check if activity started successfully
188: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
191: raise OKC_API.G_EXCEPTION_ERROR;
192: End If;

Line 189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

185: x_return_status => x_return_status);
186:
187: -- check if activity started successfully
188: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
191: raise OKC_API.G_EXCEPTION_ERROR;
192: End If;
193:

Line 190: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

186:
187: -- check if activity started successfully
188: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
191: raise OKC_API.G_EXCEPTION_ERROR;
192: End If;
193:
194: OKL_CURE_VNDR_RFND_PVT.delete_cure_refund(

Line 191: raise OKC_API.G_EXCEPTION_ERROR;

187: -- check if activity started successfully
188: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
190: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
191: raise OKC_API.G_EXCEPTION_ERROR;
192: End If;
193:
194: OKL_CURE_VNDR_RFND_PVT.delete_cure_refund(
195: p_api_version => p_api_version,

Line 203: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

199: x_msg_data => x_msg_data,
200: p_cure_rfnd_tbl => p_cure_rfnd_tbl
201: );
202:
203: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
205: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
206: raise OKC_API.G_EXCEPTION_ERROR;
207: End If;

Line 204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

200: p_cure_rfnd_tbl => p_cure_rfnd_tbl
201: );
202:
203: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
205: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
206: raise OKC_API.G_EXCEPTION_ERROR;
207: End If;
208:

Line 205: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

201: );
202:
203: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
205: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
206: raise OKC_API.G_EXCEPTION_ERROR;
207: End If;
208:
209: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 206: raise OKC_API.G_EXCEPTION_ERROR;

202:
203: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
204: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
205: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
206: raise OKC_API.G_EXCEPTION_ERROR;
207: End If;
208:
209: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
210:

Line 209: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

205: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
206: raise OKC_API.G_EXCEPTION_ERROR;
207: End If;
208:
209: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
210:
211: EXCEPTION
212: when OKC_API.G_EXCEPTION_ERROR then
213: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 212: when OKC_API.G_EXCEPTION_ERROR then

208:
209: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
210:
211: EXCEPTION
212: when OKC_API.G_EXCEPTION_ERROR then
213: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
214: p_api_name => l_api_name,
215: p_pkg_name => g_pkg_name,
216: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 213: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

209: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
210:
211: EXCEPTION
212: when OKC_API.G_EXCEPTION_ERROR then
213: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
214: p_api_name => l_api_name,
215: p_pkg_name => g_pkg_name,
216: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
217: x_msg_count => x_msg_count,

Line 216: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

212: when OKC_API.G_EXCEPTION_ERROR then
213: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
214: p_api_name => l_api_name,
215: p_pkg_name => g_pkg_name,
216: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
217: x_msg_count => x_msg_count,
218: x_msg_data => x_msg_data,
219: p_api_type => g_api_type);
220:

Line 221: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

217: x_msg_count => x_msg_count,
218: x_msg_data => x_msg_data,
219: p_api_type => g_api_type);
220:
221: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
222: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
223: p_api_name => l_api_name,
224: p_pkg_name => g_pkg_name,
225: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 222: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

218: x_msg_data => x_msg_data,
219: p_api_type => g_api_type);
220:
221: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
222: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
223: p_api_name => l_api_name,
224: p_pkg_name => g_pkg_name,
225: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
226: x_msg_count => x_msg_count,

Line 225: p_exc_name => '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: p_api_name => l_api_name,
224: p_pkg_name => g_pkg_name,
225: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
226: x_msg_count => x_msg_count,
227: x_msg_data => x_msg_data,
228: p_api_type => g_api_type);
229:

Line 231: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

227: x_msg_data => x_msg_data,
228: p_api_type => g_api_type);
229:
230: when OTHERS then
231: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
232: p_api_name => l_api_name,
233: p_pkg_name => g_pkg_name,
234: p_exc_name => 'OTHERS',
235: x_msg_count => x_msg_count,