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_CON_COVERAGE_PUB dependencies on OKC_API

Line 16: l_return_status := OKC_API.G_RET_STS_SUCCESS;

12: IS
13: l_return_status Varchar2(1);
14: l_api_name CONSTANT VARCHAR2(30) := 'apply_contract_coverage';
15: BEGIN
16: l_return_status := OKC_API.G_RET_STS_SUCCESS;
17:
18: l_return_status := OKC_API.START_ACTIVITY(l_api_name
19: ,p_init_msg_list
20: ,'_PUB'

Line 18: l_return_status := OKC_API.START_ACTIVITY(l_api_name

14: l_api_name CONSTANT VARCHAR2(30) := 'apply_contract_coverage';
15: BEGIN
16: l_return_status := OKC_API.G_RET_STS_SUCCESS;
17:
18: l_return_status := OKC_API.START_ACTIVITY(l_api_name
19: ,p_init_msg_list
20: ,'_PUB'
21: ,x_return_status
22: );

Line 23: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

19: ,p_init_msg_list
20: ,'_PUB'
21: ,x_return_status
22: );
23: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
24: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
26: RAISE OKC_API.G_EXCEPTION_ERROR;
27: END IF;

Line 24: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

20: ,'_PUB'
21: ,x_return_status
22: );
23: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
24: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
26: RAISE OKC_API.G_EXCEPTION_ERROR;
27: END IF;
28:

Line 25: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

21: ,x_return_status
22: );
23: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
24: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
26: RAISE OKC_API.G_EXCEPTION_ERROR;
27: END IF;
28:
29: OKS_CON_COVERAGE_PVT.apply_contract_coverage

Line 26: RAISE OKC_API.G_EXCEPTION_ERROR;

22: );
23: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
24: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
26: RAISE OKC_API.G_EXCEPTION_ERROR;
27: END IF;
28:
29: OKS_CON_COVERAGE_PVT.apply_contract_coverage
30: (p_api_version

Line 38: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

34: ,x_msg_count
35: ,x_msg_data
36: ,x_est_discounted_amt_tbl);
37:
38: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
39: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
41: RAISE OKC_API.G_EXCEPTION_ERROR;
42: END IF;

Line 39: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

35: ,x_msg_data
36: ,x_est_discounted_amt_tbl);
37:
38: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
39: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
41: RAISE OKC_API.G_EXCEPTION_ERROR;
42: END IF;
43:

Line 40: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

36: ,x_est_discounted_amt_tbl);
37:
38: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
39: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
41: RAISE OKC_API.G_EXCEPTION_ERROR;
42: END IF;
43:
44: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 41: RAISE OKC_API.G_EXCEPTION_ERROR;

37:
38: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
39: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
40: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
41: RAISE OKC_API.G_EXCEPTION_ERROR;
42: END IF;
43:
44: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
45:

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

40: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
41: RAISE OKC_API.G_EXCEPTION_ERROR;
42: END IF;
43:
44: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
45:
46: EXCEPTION
47: WHEN OKC_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 47: WHEN OKC_API.G_EXCEPTION_ERROR THEN

43:
44: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
45:
46: EXCEPTION
47: WHEN OKC_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKC_API.HANDLE_EXCEPTIONS
49: (l_api_name,
50: G_PKG_NAME,
51: 'OKC_API.G_RET_STS_ERROR',

Line 48: x_return_status := OKC_API.HANDLE_EXCEPTIONS

44: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
45:
46: EXCEPTION
47: WHEN OKC_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKC_API.HANDLE_EXCEPTIONS
49: (l_api_name,
50: G_PKG_NAME,
51: 'OKC_API.G_RET_STS_ERROR',
52: x_msg_count,

Line 51: 'OKC_API.G_RET_STS_ERROR',

47: WHEN OKC_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKC_API.HANDLE_EXCEPTIONS
49: (l_api_name,
50: G_PKG_NAME,
51: 'OKC_API.G_RET_STS_ERROR',
52: x_msg_count,
53: x_msg_data,
54: '_PUB');
55: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 55: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

51: 'OKC_API.G_RET_STS_ERROR',
52: x_msg_count,
53: x_msg_data,
54: '_PUB');
55: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
56: x_return_status := OKC_API.HANDLE_EXCEPTIONS
57: (l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 56: x_return_status := OKC_API.HANDLE_EXCEPTIONS

52: x_msg_count,
53: x_msg_data,
54: '_PUB');
55: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
56: x_return_status := OKC_API.HANDLE_EXCEPTIONS
57: (l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_UNEXP_ERROR',
60: x_msg_count,

Line 59: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 64: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 89: l_return_status := OKC_API.G_RET_STS_SUCCESS;

85: l_return_status Varchar2(1);
86: l_api_name CONSTANT VARCHAR2(30) := 'get_bp_pricelist';
87:
88: BEGIN
89: l_return_status := OKC_API.G_RET_STS_SUCCESS;
90:
91: l_return_status := OKC_API.START_ACTIVITY(l_api_name
92: ,p_init_msg_list
93: ,'_PUB'

Line 91: l_return_status := OKC_API.START_ACTIVITY(l_api_name

87:
88: BEGIN
89: l_return_status := OKC_API.G_RET_STS_SUCCESS;
90:
91: l_return_status := OKC_API.START_ACTIVITY(l_api_name
92: ,p_init_msg_list
93: ,'_PUB'
94: ,x_return_status
95: );

Line 96: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

92: ,p_init_msg_list
93: ,'_PUB'
94: ,x_return_status
95: );
96: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
99: RAISE OKC_API.G_EXCEPTION_ERROR;
100: END IF;

Line 97: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

93: ,'_PUB'
94: ,x_return_status
95: );
96: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
99: RAISE OKC_API.G_EXCEPTION_ERROR;
100: END IF;
101:

Line 98: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

94: ,x_return_status
95: );
96: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
99: RAISE OKC_API.G_EXCEPTION_ERROR;
100: END IF;
101:
102: OKS_CON_COVERAGE_PVT.get_bp_pricelist

Line 99: RAISE OKC_API.G_EXCEPTION_ERROR;

95: );
96: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
99: RAISE OKC_API.G_EXCEPTION_ERROR;
100: END IF;
101:
102: OKS_CON_COVERAGE_PVT.get_bp_pricelist
103: (p_api_version

Line 113: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

109: ,x_msg_count
110: ,x_msg_data
111: ,x_pricing_tbl);
112:
113: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
115: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
116: RAISE OKC_API.G_EXCEPTION_ERROR;
117: END IF;

Line 114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

110: ,x_msg_data
111: ,x_pricing_tbl);
112:
113: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
115: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
116: RAISE OKC_API.G_EXCEPTION_ERROR;
117: END IF;
118:

Line 115: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

111: ,x_pricing_tbl);
112:
113: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
115: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
116: RAISE OKC_API.G_EXCEPTION_ERROR;
117: END IF;
118:
119: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 116: RAISE OKC_API.G_EXCEPTION_ERROR;

112:
113: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
115: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
116: RAISE OKC_API.G_EXCEPTION_ERROR;
117: END IF;
118:
119: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
120:

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

115: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
116: RAISE OKC_API.G_EXCEPTION_ERROR;
117: END IF;
118:
119: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
120:
121: EXCEPTION
122: WHEN OKC_API.G_EXCEPTION_ERROR THEN
123: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 122: WHEN OKC_API.G_EXCEPTION_ERROR THEN

118:
119: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
120:
121: EXCEPTION
122: WHEN OKC_API.G_EXCEPTION_ERROR THEN
123: x_return_status := OKC_API.HANDLE_EXCEPTIONS
124: (l_api_name,
125: G_PKG_NAME,
126: 'OKC_API.G_RET_STS_ERROR',

Line 123: x_return_status := OKC_API.HANDLE_EXCEPTIONS

119: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
120:
121: EXCEPTION
122: WHEN OKC_API.G_EXCEPTION_ERROR THEN
123: x_return_status := OKC_API.HANDLE_EXCEPTIONS
124: (l_api_name,
125: G_PKG_NAME,
126: 'OKC_API.G_RET_STS_ERROR',
127: x_msg_count,

Line 126: 'OKC_API.G_RET_STS_ERROR',

122: WHEN OKC_API.G_EXCEPTION_ERROR THEN
123: x_return_status := OKC_API.HANDLE_EXCEPTIONS
124: (l_api_name,
125: G_PKG_NAME,
126: 'OKC_API.G_RET_STS_ERROR',
127: x_msg_count,
128: x_msg_data,
129: '_PUB');
130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

126: 'OKC_API.G_RET_STS_ERROR',
127: x_msg_count,
128: x_msg_data,
129: '_PUB');
130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
132: (l_api_name,
133: G_PKG_NAME,
134: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 131: x_return_status := OKC_API.HANDLE_EXCEPTIONS

127: x_msg_count,
128: x_msg_data,
129: '_PUB');
130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
132: (l_api_name,
133: G_PKG_NAME,
134: 'OKC_API.G_RET_STS_UNEXP_ERROR',
135: x_msg_count,

Line 134: 'OKC_API.G_RET_STS_UNEXP_ERROR',

130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
132: (l_api_name,
133: G_PKG_NAME,
134: 'OKC_API.G_RET_STS_UNEXP_ERROR',
135: x_msg_count,
136: x_msg_data,
137: '_PUB');
138: WHEN OTHERS THEN

Line 139: x_return_status := OKC_API.HANDLE_EXCEPTIONS

135: x_msg_count,
136: x_msg_data,
137: '_PUB');
138: WHEN OTHERS THEN
139: x_return_status := OKC_API.HANDLE_EXCEPTIONS
140: (l_api_name,
141: G_PKG_NAME,
142: 'OTHERS',
143: x_msg_count,

Line 163: l_return_status := OKC_API.G_RET_STS_SUCCESS;

159: l_return_status Varchar2(1);
160: l_api_name CONSTANT VARCHAR2(30) := 'get_bill_rates';
161:
162: BEGIN
163: l_return_status := OKC_API.G_RET_STS_SUCCESS;
164:
165: l_return_status := OKC_API.START_ACTIVITY(l_api_name
166: ,p_init_msg_list
167: ,'_PUB'

Line 165: l_return_status := OKC_API.START_ACTIVITY(l_api_name

161:
162: BEGIN
163: l_return_status := OKC_API.G_RET_STS_SUCCESS;
164:
165: l_return_status := OKC_API.START_ACTIVITY(l_api_name
166: ,p_init_msg_list
167: ,'_PUB'
168: ,x_return_status
169: );

Line 170: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

166: ,p_init_msg_list
167: ,'_PUB'
168: ,x_return_status
169: );
170: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
173: RAISE OKC_API.G_EXCEPTION_ERROR;
174: END IF;

Line 171: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

167: ,'_PUB'
168: ,x_return_status
169: );
170: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
173: RAISE OKC_API.G_EXCEPTION_ERROR;
174: END IF;
175:

Line 172: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

168: ,x_return_status
169: );
170: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
173: RAISE OKC_API.G_EXCEPTION_ERROR;
174: END IF;
175:
176: OKS_CON_COVERAGE_PVT.get_bill_rates

Line 173: RAISE OKC_API.G_EXCEPTION_ERROR;

169: );
170: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
173: RAISE OKC_API.G_EXCEPTION_ERROR;
174: END IF;
175:
176: OKS_CON_COVERAGE_PVT.get_bill_rates
177: (p_api_version

Line 186: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

182: ,x_msg_count
183: ,x_msg_data
184: ,X_bill_rate_tbl);
185:
186: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
189: RAISE OKC_API.G_EXCEPTION_ERROR;
190: END IF;

Line 187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

183: ,x_msg_data
184: ,X_bill_rate_tbl);
185:
186: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
189: RAISE OKC_API.G_EXCEPTION_ERROR;
190: END IF;
191:

Line 188: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

184: ,X_bill_rate_tbl);
185:
186: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
189: RAISE OKC_API.G_EXCEPTION_ERROR;
190: END IF;
191:
192: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 189: RAISE OKC_API.G_EXCEPTION_ERROR;

185:
186: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
189: RAISE OKC_API.G_EXCEPTION_ERROR;
190: END IF;
191:
192: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
193:

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

188: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
189: RAISE OKC_API.G_EXCEPTION_ERROR;
190: END IF;
191:
192: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
193:
194: EXCEPTION
195: WHEN OKC_API.G_EXCEPTION_ERROR THEN
196: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 195: WHEN OKC_API.G_EXCEPTION_ERROR THEN

191:
192: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
193:
194: EXCEPTION
195: WHEN OKC_API.G_EXCEPTION_ERROR THEN
196: x_return_status := OKC_API.HANDLE_EXCEPTIONS
197: (l_api_name,
198: G_PKG_NAME,
199: 'OKC_API.G_RET_STS_ERROR',

Line 196: x_return_status := OKC_API.HANDLE_EXCEPTIONS

192: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
193:
194: EXCEPTION
195: WHEN OKC_API.G_EXCEPTION_ERROR THEN
196: x_return_status := OKC_API.HANDLE_EXCEPTIONS
197: (l_api_name,
198: G_PKG_NAME,
199: 'OKC_API.G_RET_STS_ERROR',
200: x_msg_count,

Line 199: 'OKC_API.G_RET_STS_ERROR',

195: WHEN OKC_API.G_EXCEPTION_ERROR THEN
196: x_return_status := OKC_API.HANDLE_EXCEPTIONS
197: (l_api_name,
198: G_PKG_NAME,
199: 'OKC_API.G_RET_STS_ERROR',
200: x_msg_count,
201: x_msg_data,
202: '_PUB');
203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

199: 'OKC_API.G_RET_STS_ERROR',
200: x_msg_count,
201: x_msg_data,
202: '_PUB');
203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
204: x_return_status := OKC_API.HANDLE_EXCEPTIONS
205: (l_api_name,
206: G_PKG_NAME,
207: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 204: x_return_status := OKC_API.HANDLE_EXCEPTIONS

200: x_msg_count,
201: x_msg_data,
202: '_PUB');
203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
204: x_return_status := OKC_API.HANDLE_EXCEPTIONS
205: (l_api_name,
206: G_PKG_NAME,
207: 'OKC_API.G_RET_STS_UNEXP_ERROR',
208: x_msg_count,

Line 207: 'OKC_API.G_RET_STS_UNEXP_ERROR',

203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
204: x_return_status := OKC_API.HANDLE_EXCEPTIONS
205: (l_api_name,
206: G_PKG_NAME,
207: 'OKC_API.G_RET_STS_UNEXP_ERROR',
208: x_msg_count,
209: x_msg_data,
210: '_PUB');
211: WHEN OTHERS THEN

Line 212: x_return_status := OKC_API.HANDLE_EXCEPTIONS

208: x_msg_count,
209: x_msg_data,
210: '_PUB');
211: WHEN OTHERS THEN
212: x_return_status := OKC_API.HANDLE_EXCEPTIONS
213: (l_api_name,
214: G_PKG_NAME,
215: 'OTHERS',
216: x_msg_count,