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_CASE_UTIL_PVT dependencies on OKL_API

Line 19: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

15: IS
16:
17: l_api_version CONSTANT NUMBER := 1;
18: l_api_name CONSTANT VARCHAR2(30) := 'OKL_CASE_UTIL_PVT';
19: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
20: l_currency iex_case_definitions.column_value%TYPE;
21: l_customer iex_case_definitions.column_value%TYPE;
22: l_vendor_program iex_case_definitions.column_value%TYPE;
23: l_bill_to_address_id iex_case_definitions.column_value%TYPE;

Line 69: l_return_status := okl_api.START_ACTIVITY(l_api_name,

65:
66:
67: BEGIN
68:
69: l_return_status := okl_api.START_ACTIVITY(l_api_name,
70: G_PKG_NAME,
71: p_init_msg_list,
72: l_api_version,
73: p_api_version,

Line 81: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

77: /* Processing Starts */
78: -- get customer/party ID
79: l_return_status := OKL_CONTRACT_INFO.get_customer(p_contract_id, l_customer);
80:
81: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
83: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
84: RAISE okl_api.G_EXCEPTION_ERROR;
85: END IF;

Line 82: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

78: -- get customer/party ID
79: l_return_status := OKL_CONTRACT_INFO.get_customer(p_contract_id, l_customer);
80:
81: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
83: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
84: RAISE okl_api.G_EXCEPTION_ERROR;
85: END IF;
86:

Line 83: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

79: l_return_status := OKL_CONTRACT_INFO.get_customer(p_contract_id, l_customer);
80:
81: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
83: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
84: RAISE okl_api.G_EXCEPTION_ERROR;
85: END IF;
86:
87: -- get vendor program

Line 84: RAISE okl_api.G_EXCEPTION_ERROR;

80:
81: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
82: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
83: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
84: RAISE okl_api.G_EXCEPTION_ERROR;
85: END IF;
86:
87: -- get vendor program
88: l_return_status := OKL_CONTRACT_INFO.get_vendor_program(p_contract_id, l_vendor_program);

Line 90: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

86:
87: -- get vendor program
88: l_return_status := OKL_CONTRACT_INFO.get_vendor_program(p_contract_id, l_vendor_program);
89:
90: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
91: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
92: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
93: RAISE okl_api.G_EXCEPTION_ERROR;
94: END IF;

Line 91: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

87: -- get vendor program
88: l_return_status := OKL_CONTRACT_INFO.get_vendor_program(p_contract_id, l_vendor_program);
89:
90: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
91: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
92: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
93: RAISE okl_api.G_EXCEPTION_ERROR;
94: END IF;
95:

Line 92: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

88: l_return_status := OKL_CONTRACT_INFO.get_vendor_program(p_contract_id, l_vendor_program);
89:
90: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
91: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
92: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
93: RAISE okl_api.G_EXCEPTION_ERROR;
94: END IF;
95:
96: -- get bill to address

Line 93: RAISE okl_api.G_EXCEPTION_ERROR;

89:
90: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
91: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
92: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
93: RAISE okl_api.G_EXCEPTION_ERROR;
94: END IF;
95:
96: -- get bill to address
97: /*l_return_status := OKL_CONTRACT_INFO.get_bill_to_address(p_contract_id,l_bill_to_address_id);*/

Line 98: /*IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

94: END IF;
95:
96: -- get bill to address
97: /*l_return_status := OKL_CONTRACT_INFO.get_bill_to_address(p_contract_id,l_bill_to_address_id);*/
98: /*IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
101: RAISE okl_api.G_EXCEPTION_ERROR;
102: END IF;*/

Line 99: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

95:
96: -- get bill to address
97: /*l_return_status := OKL_CONTRACT_INFO.get_bill_to_address(p_contract_id,l_bill_to_address_id);*/
98: /*IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
101: RAISE okl_api.G_EXCEPTION_ERROR;
102: END IF;*/
103: -- New code for bill to address

Line 100: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

96: -- get bill to address
97: /*l_return_status := OKL_CONTRACT_INFO.get_bill_to_address(p_contract_id,l_bill_to_address_id);*/
98: /*IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
101: RAISE okl_api.G_EXCEPTION_ERROR;
102: END IF;*/
103: -- New code for bill to address
104: OPEN bill_to_csr (p_contract_id);

Line 101: RAISE okl_api.G_EXCEPTION_ERROR;

97: /*l_return_status := OKL_CONTRACT_INFO.get_bill_to_address(p_contract_id,l_bill_to_address_id);*/
98: /*IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
101: RAISE okl_api.G_EXCEPTION_ERROR;
102: END IF;*/
103: -- New code for bill to address
104: OPEN bill_to_csr (p_contract_id);
105: FETCH bill_to_csr INTO l_bill_to_address_id;

Line 109: RAISE okl_api.G_EXCEPTION_ERROR;

105: FETCH bill_to_csr INTO l_bill_to_address_id;
106: CLOSE bill_to_csr;
107:
108: IF trunc(l_bill_to_address_id) IS NULL THEN
109: RAISE okl_api.G_EXCEPTION_ERROR;
110: END IF;
111:
112: -- get private label
113: l_return_status := OKL_CONTRACT_INFO.get_private_label(p_contract_id, l_private_label);

Line 115: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

111:
112: -- get private label
113: l_return_status := OKL_CONTRACT_INFO.get_private_label(p_contract_id, l_private_label);
114:
115: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
118: RAISE okl_api.G_EXCEPTION_ERROR;
119: END IF;

Line 116: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

112: -- get private label
113: l_return_status := OKL_CONTRACT_INFO.get_private_label(p_contract_id, l_private_label);
114:
115: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
118: RAISE okl_api.G_EXCEPTION_ERROR;
119: END IF;
120:

Line 117: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

113: l_return_status := OKL_CONTRACT_INFO.get_private_label(p_contract_id, l_private_label);
114:
115: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
118: RAISE okl_api.G_EXCEPTION_ERROR;
119: END IF;
120:
121: -- get non notification flag

Line 118: RAISE okl_api.G_EXCEPTION_ERROR;

114:
115: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
116: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
118: RAISE okl_api.G_EXCEPTION_ERROR;
119: END IF;
120:
121: -- get non notification flag
122:

Line 125: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

121: -- get non notification flag
122:
123: l_return_status := OKL_CONTRACT_INFO.get_non_notify_flag(p_contract_id, l_non_notify_flag);
124:
125: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
127: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
128: RAISE okl_api.G_EXCEPTION_ERROR;
129: END IF;

Line 126: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

122:
123: l_return_status := OKL_CONTRACT_INFO.get_non_notify_flag(p_contract_id, l_non_notify_flag);
124:
125: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
127: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
128: RAISE okl_api.G_EXCEPTION_ERROR;
129: END IF;
130:

Line 127: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

123: l_return_status := OKL_CONTRACT_INFO.get_non_notify_flag(p_contract_id, l_non_notify_flag);
124:
125: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
127: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
128: RAISE okl_api.G_EXCEPTION_ERROR;
129: END IF;
130:
131: -- get syndication flag

Line 128: RAISE okl_api.G_EXCEPTION_ERROR;

124:
125: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
127: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
128: RAISE okl_api.G_EXCEPTION_ERROR;
129: END IF;
130:
131: -- get syndication flag
132: l_return_status := OKL_CONTRACT_INFO.get_syndicate_flag(p_contract_id, l_syndicate_flag);

Line 134: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

130:
131: -- get syndication flag
132: l_return_status := OKL_CONTRACT_INFO.get_syndicate_flag(p_contract_id, l_syndicate_flag);
133:
134: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
135: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
136: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
137: RAISE okl_api.G_EXCEPTION_ERROR;
138: END IF;

Line 135: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

131: -- get syndication flag
132: l_return_status := OKL_CONTRACT_INFO.get_syndicate_flag(p_contract_id, l_syndicate_flag);
133:
134: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
135: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
136: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
137: RAISE okl_api.G_EXCEPTION_ERROR;
138: END IF;
139:

Line 136: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

132: l_return_status := OKL_CONTRACT_INFO.get_syndicate_flag(p_contract_id, l_syndicate_flag);
133:
134: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
135: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
136: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
137: RAISE okl_api.G_EXCEPTION_ERROR;
138: END IF;
139:
140: -- get currency

Line 137: RAISE okl_api.G_EXCEPTION_ERROR;

133:
134: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
135: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
136: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
137: RAISE okl_api.G_EXCEPTION_ERROR;
138: END IF;
139:
140: -- get currency
141: l_return_status := OKL_CONTRACT_INFO.get_currency(p_contract_id, l_currency);

Line 143: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

139:
140: -- get currency
141: l_return_status := OKL_CONTRACT_INFO.get_currency(p_contract_id, l_currency);
142:
143: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
146: RAISE okl_api.G_EXCEPTION_ERROR;
147: END IF;

Line 144: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

140: -- get currency
141: l_return_status := OKL_CONTRACT_INFO.get_currency(p_contract_id, l_currency);
142:
143: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
146: RAISE okl_api.G_EXCEPTION_ERROR;
147: END IF;
148:

Line 145: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

141: l_return_status := OKL_CONTRACT_INFO.get_currency(p_contract_id, l_currency);
142:
143: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
146: RAISE okl_api.G_EXCEPTION_ERROR;
147: END IF;
148:
149: -- get customer account

Line 146: RAISE okl_api.G_EXCEPTION_ERROR;

142:
143: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
146: RAISE okl_api.G_EXCEPTION_ERROR;
147: END IF;
148:
149: -- get customer account
150: /*l_return_status := OKL_CONTRACT_INFO.get_rule_value(

Line 160: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

156: ,x_id2 => l_id2
157: ,x_value => l_value);
158:
159:
160: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
163: RAISE okl_api.G_EXCEPTION_ERROR;
164: END IF; */

Line 161: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

157: ,x_value => l_value);
158:
159:
160: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
163: RAISE okl_api.G_EXCEPTION_ERROR;
164: END IF; */
165:

Line 162: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

158:
159:
160: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
163: RAISE okl_api.G_EXCEPTION_ERROR;
164: END IF; */
165:
166: -- New code for customer account

Line 163: RAISE okl_api.G_EXCEPTION_ERROR;

159:
160: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
161: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
163: RAISE okl_api.G_EXCEPTION_ERROR;
164: END IF; */
165:
166: -- New code for customer account
167: OPEN cust_acct_csr (p_contract_id);

Line 172: RAISE okl_api.G_EXCEPTION_ERROR;

168: FETCH cust_acct_csr INTO l_customer_account;
169: CLOSE cust_acct_csr;
170:
171: IF trunc(l_customer_account) IS NULL THEN
172: RAISE okl_api.G_EXCEPTION_ERROR;
173: END IF;
174:
175: -- Populate the pl/sql table for case definition
176:

Line 265: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN

261: x_msg_count => x_msg_count,
262: x_msg_data => x_msg_data);
263: END IF;
264:
265: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
268: RAISE okl_api.G_EXCEPTION_ERROR;
269: END IF;

Line 266: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;

262: x_msg_data => x_msg_data);
263: END IF;
264:
265: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
268: RAISE okl_api.G_EXCEPTION_ERROR;
269: END IF;
270:

Line 267: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN

263: END IF;
264:
265: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
268: RAISE okl_api.G_EXCEPTION_ERROR;
269: END IF;
270:
271: x_return_status := l_return_status;

Line 268: RAISE okl_api.G_EXCEPTION_ERROR;

264:
265: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
268: RAISE okl_api.G_EXCEPTION_ERROR;
269: END IF;
270:
271: x_return_status := l_return_status;
272:

Line 275: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

271: x_return_status := l_return_status;
272:
273: /* Processing Ends */
274:
275: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
276:
277: EXCEPTION
278: WHEN okl_api.G_EXCEPTION_ERROR THEN
279: x_return_status := okl_api.HANDLE_EXCEPTIONS

Line 278: WHEN okl_api.G_EXCEPTION_ERROR THEN

274:
275: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
276:
277: EXCEPTION
278: WHEN okl_api.G_EXCEPTION_ERROR THEN
279: x_return_status := okl_api.HANDLE_EXCEPTIONS
280: (
281: l_api_name,
282: G_PKG_NAME,

Line 279: x_return_status := okl_api.HANDLE_EXCEPTIONS

275: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
276:
277: EXCEPTION
278: WHEN okl_api.G_EXCEPTION_ERROR THEN
279: x_return_status := okl_api.HANDLE_EXCEPTIONS
280: (
281: l_api_name,
282: G_PKG_NAME,
283: 'okl_api.G_RET_STS_ERROR',

Line 283: 'okl_api.G_RET_STS_ERROR',

279: x_return_status := okl_api.HANDLE_EXCEPTIONS
280: (
281: l_api_name,
282: G_PKG_NAME,
283: 'okl_api.G_RET_STS_ERROR',
284: x_msg_count,
285: x_msg_data,
286: '_CASE_UTIL'
287: );

Line 289: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN

285: x_msg_data,
286: '_CASE_UTIL'
287: );
288:
289: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
290: x_return_status :=okl_api.HANDLE_EXCEPTIONS
291: (
292: l_api_name,
293: G_PKG_NAME,

Line 290: x_return_status :=okl_api.HANDLE_EXCEPTIONS

286: '_CASE_UTIL'
287: );
288:
289: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
290: x_return_status :=okl_api.HANDLE_EXCEPTIONS
291: (
292: l_api_name,
293: G_PKG_NAME,
294: 'okl_api.G_RET_STS_UNEXP_ERROR',

Line 294: 'okl_api.G_RET_STS_UNEXP_ERROR',

290: x_return_status :=okl_api.HANDLE_EXCEPTIONS
291: (
292: l_api_name,
293: G_PKG_NAME,
294: 'okl_api.G_RET_STS_UNEXP_ERROR',
295: x_msg_count,
296: x_msg_data,
297: '_CASE_UTIL'
298: );

Line 301: x_return_status :=okl_api.HANDLE_EXCEPTIONS

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