11: ,x_msg_data out nocopy Varchar2
12: ,x_ent_contracts out nocopy OKS_ENTITLEMENTS_PUB.get_contop_tbl
13: ,x_pm_activities out nocopy OKS_PM_ENTITLEMENTS_PUB.get_activityop_tbl)
14: IS
15: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
16: l_api_name CONSTANT VARCHAR2(30) := 'get_pm_contracts';
17: BEGIN
18: l_return_status := OKC_API.START_ACTIVITY(l_api_name
19: ,p_init_msg_list
14: IS
15: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
16: l_api_name CONSTANT VARCHAR2(30) := 'get_pm_contracts';
17: BEGIN
18: l_return_status := OKC_API.START_ACTIVITY(l_api_name
19: ,p_init_msg_list
20: ,'_PUB'
21: ,x_return_status
22: );
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;
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:
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_PM_ENTITLEMENTS_PVT.get_pm_contracts
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_PM_ENTITLEMENTS_PVT.get_pm_contracts
30: (p_api_version => p_api_version
37: ,x_pm_activities => x_pm_activities);
38:
39:
40:
41: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
42: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
43: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
44: RAISE OKC_API.G_EXCEPTION_ERROR;
45: END IF;
38:
39:
40:
41: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
42: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
43: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
44: RAISE OKC_API.G_EXCEPTION_ERROR;
45: END IF;
46:
39:
40:
41: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
42: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
43: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
44: RAISE OKC_API.G_EXCEPTION_ERROR;
45: END IF;
46:
47: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
40:
41: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
42: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
43: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
44: RAISE OKC_API.G_EXCEPTION_ERROR;
45: END IF;
46:
47: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
48:
43: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
44: RAISE OKC_API.G_EXCEPTION_ERROR;
45: END IF;
46:
47: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
48:
49: EXCEPTION
50: WHEN OKC_API.G_EXCEPTION_ERROR THEN
51: x_return_status := OKC_API.HANDLE_EXCEPTIONS
46:
47: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
48:
49: EXCEPTION
50: WHEN OKC_API.G_EXCEPTION_ERROR THEN
51: x_return_status := OKC_API.HANDLE_EXCEPTIONS
52: (l_api_name,
53: G_PKG_NAME,
54: 'OKC_API.G_RET_STS_ERROR',
47: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
48:
49: EXCEPTION
50: WHEN OKC_API.G_EXCEPTION_ERROR THEN
51: x_return_status := OKC_API.HANDLE_EXCEPTIONS
52: (l_api_name,
53: G_PKG_NAME,
54: 'OKC_API.G_RET_STS_ERROR',
55: x_msg_count,
50: WHEN OKC_API.G_EXCEPTION_ERROR THEN
51: x_return_status := OKC_API.HANDLE_EXCEPTIONS
52: (l_api_name,
53: G_PKG_NAME,
54: 'OKC_API.G_RET_STS_ERROR',
55: x_msg_count,
56: x_msg_data,
57: '_PUB');
58: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
54: 'OKC_API.G_RET_STS_ERROR',
55: x_msg_count,
56: x_msg_data,
57: '_PUB');
58: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
59: x_return_status := OKC_API.HANDLE_EXCEPTIONS
60: (l_api_name,
61: G_PKG_NAME,
62: 'OKC_API.G_RET_STS_UNEXP_ERROR',
55: x_msg_count,
56: x_msg_data,
57: '_PUB');
58: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
59: x_return_status := OKC_API.HANDLE_EXCEPTIONS
60: (l_api_name,
61: G_PKG_NAME,
62: 'OKC_API.G_RET_STS_UNEXP_ERROR',
63: x_msg_count,
58: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
59: x_return_status := OKC_API.HANDLE_EXCEPTIONS
60: (l_api_name,
61: G_PKG_NAME,
62: 'OKC_API.G_RET_STS_UNEXP_ERROR',
63: x_msg_count,
64: x_msg_data,
65: '_PUB');
66: WHEN OTHERS THEN
63: x_msg_count,
64: x_msg_data,
65: '_PUB');
66: WHEN OTHERS THEN
67: x_return_status := OKC_API.HANDLE_EXCEPTIONS
68: (l_api_name,
69: G_PKG_NAME,
70: 'OTHERS',
71: x_msg_count,
81: ,x_msg_count out nocopy Number
82: ,x_msg_data out nocopy Varchar2
83: ,x_pm_schedule out nocopy pm_sch_tbl_type)
84: IS
85: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
86: l_api_name CONSTANT VARCHAR2(30) := 'Get_PM_Schedule';
87: BEGIN
88: l_return_status := OKC_API.START_ACTIVITY(l_api_name
89: ,p_init_msg_list
84: IS
85: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
86: l_api_name CONSTANT VARCHAR2(30) := 'Get_PM_Schedule';
87: BEGIN
88: l_return_status := OKC_API.START_ACTIVITY(l_api_name
89: ,p_init_msg_list
90: ,'_PUB'
91: ,x_return_status
92: );
89: ,p_init_msg_list
90: ,'_PUB'
91: ,x_return_status
92: );
93: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
94: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
95: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
96: RAISE OKC_API.G_EXCEPTION_ERROR;
97: END IF;
90: ,'_PUB'
91: ,x_return_status
92: );
93: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
94: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
95: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
96: RAISE OKC_API.G_EXCEPTION_ERROR;
97: END IF;
98:
91: ,x_return_status
92: );
93: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
94: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
95: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
96: RAISE OKC_API.G_EXCEPTION_ERROR;
97: END IF;
98:
99: /* OKS_PM_ENTITLEMENTS_PVT.Get_PM_Schedule
92: );
93: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
94: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
95: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
96: RAISE OKC_API.G_EXCEPTION_ERROR;
97: END IF;
98:
99: /* OKS_PM_ENTITLEMENTS_PVT.Get_PM_Schedule
100: (p_api_version => p_api_version
117:
118:
119:
120:
121: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
123: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
124: RAISE OKC_API.G_EXCEPTION_ERROR;
125: END IF;
118:
119:
120:
121: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
123: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
124: RAISE OKC_API.G_EXCEPTION_ERROR;
125: END IF;
126:
119:
120:
121: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
123: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
124: RAISE OKC_API.G_EXCEPTION_ERROR;
125: END IF;
126:
127: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
120:
121: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
123: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
124: RAISE OKC_API.G_EXCEPTION_ERROR;
125: END IF;
126:
127: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
128:
123: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
124: RAISE OKC_API.G_EXCEPTION_ERROR;
125: END IF;
126:
127: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
128:
129: EXCEPTION
130: WHEN OKC_API.G_EXCEPTION_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
126:
127: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
128:
129: EXCEPTION
130: WHEN OKC_API.G_EXCEPTION_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
132: (l_api_name,
133: G_PKG_NAME,
134: 'OKC_API.G_RET_STS_ERROR',
127: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
128:
129: EXCEPTION
130: WHEN OKC_API.G_EXCEPTION_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
132: (l_api_name,
133: G_PKG_NAME,
134: 'OKC_API.G_RET_STS_ERROR',
135: x_msg_count,
130: WHEN OKC_API.G_EXCEPTION_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
132: (l_api_name,
133: G_PKG_NAME,
134: 'OKC_API.G_RET_STS_ERROR',
135: x_msg_count,
136: x_msg_data,
137: '_PUB');
138: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
134: 'OKC_API.G_RET_STS_ERROR',
135: x_msg_count,
136: x_msg_data,
137: '_PUB');
138: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
139: x_return_status := OKC_API.HANDLE_EXCEPTIONS
140: (l_api_name,
141: G_PKG_NAME,
142: 'OKC_API.G_RET_STS_UNEXP_ERROR',
135: x_msg_count,
136: x_msg_data,
137: '_PUB');
138: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
139: x_return_status := OKC_API.HANDLE_EXCEPTIONS
140: (l_api_name,
141: G_PKG_NAME,
142: 'OKC_API.G_RET_STS_UNEXP_ERROR',
143: x_msg_count,
138: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
139: x_return_status := OKC_API.HANDLE_EXCEPTIONS
140: (l_api_name,
141: G_PKG_NAME,
142: 'OKC_API.G_RET_STS_UNEXP_ERROR',
143: x_msg_count,
144: x_msg_data,
145: '_PUB');
146: WHEN OTHERS THEN
143: x_msg_count,
144: x_msg_data,
145: '_PUB');
146: WHEN OTHERS THEN
147: x_return_status := OKC_API.HANDLE_EXCEPTIONS
148: (l_api_name,
149: G_PKG_NAME,
150: 'OTHERS',
151: x_msg_count,
163: ,x_msg_count out nocopy Number
164: ,x_msg_data out nocopy Varchar2
165: ,x_pm_conf_reqd out nocopy Varchar2)
166: IS
167: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
168: l_api_name CONSTANT VARCHAR2(30) := 'Get_PM_Confirmation';
169: BEGIN
170: l_return_status := OKC_API.START_ACTIVITY(l_api_name
171: ,p_init_msg_list
166: IS
167: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
168: l_api_name CONSTANT VARCHAR2(30) := 'Get_PM_Confirmation';
169: BEGIN
170: l_return_status := OKC_API.START_ACTIVITY(l_api_name
171: ,p_init_msg_list
172: ,'_PUB'
173: ,x_return_status
174: );
171: ,p_init_msg_list
172: ,'_PUB'
173: ,x_return_status
174: );
175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
172: ,'_PUB'
173: ,x_return_status
174: );
175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:
173: ,x_return_status
174: );
175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: OKS_PM_ENTITLEMENTS_PVT.Get_PM_Confirmation
174: );
175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: OKS_PM_ENTITLEMENTS_PVT.Get_PM_Confirmation
182: (p_api_version => p_api_version
189: ,x_msg_data => x_msg_data
190: ,x_pm_conf_reqd => x_pm_conf_reqd);
191:
192:
193: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
195: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
196: RAISE OKC_API.G_EXCEPTION_ERROR;
197: END IF;
190: ,x_pm_conf_reqd => x_pm_conf_reqd);
191:
192:
193: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
195: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
196: RAISE OKC_API.G_EXCEPTION_ERROR;
197: END IF;
198:
191:
192:
193: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
195: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
196: RAISE OKC_API.G_EXCEPTION_ERROR;
197: END IF;
198:
199: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
192:
193: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
195: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
196: RAISE OKC_API.G_EXCEPTION_ERROR;
197: END IF;
198:
199: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
200:
195: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
196: RAISE OKC_API.G_EXCEPTION_ERROR;
197: END IF;
198:
199: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
200:
201: EXCEPTION
202: WHEN OKC_API.G_EXCEPTION_ERROR THEN
203: x_return_status := OKC_API.HANDLE_EXCEPTIONS
198:
199: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
200:
201: EXCEPTION
202: WHEN OKC_API.G_EXCEPTION_ERROR THEN
203: x_return_status := OKC_API.HANDLE_EXCEPTIONS
204: (l_api_name,
205: G_PKG_NAME,
206: 'OKC_API.G_RET_STS_ERROR',
199: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
200:
201: EXCEPTION
202: WHEN OKC_API.G_EXCEPTION_ERROR THEN
203: x_return_status := OKC_API.HANDLE_EXCEPTIONS
204: (l_api_name,
205: G_PKG_NAME,
206: 'OKC_API.G_RET_STS_ERROR',
207: x_msg_count,
202: WHEN OKC_API.G_EXCEPTION_ERROR THEN
203: x_return_status := OKC_API.HANDLE_EXCEPTIONS
204: (l_api_name,
205: G_PKG_NAME,
206: 'OKC_API.G_RET_STS_ERROR',
207: x_msg_count,
208: x_msg_data,
209: '_PUB');
210: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
206: 'OKC_API.G_RET_STS_ERROR',
207: x_msg_count,
208: x_msg_data,
209: '_PUB');
210: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
211: x_return_status := OKC_API.HANDLE_EXCEPTIONS
212: (l_api_name,
213: G_PKG_NAME,
214: 'OKC_API.G_RET_STS_UNEXP_ERROR',
207: x_msg_count,
208: x_msg_data,
209: '_PUB');
210: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
211: x_return_status := OKC_API.HANDLE_EXCEPTIONS
212: (l_api_name,
213: G_PKG_NAME,
214: 'OKC_API.G_RET_STS_UNEXP_ERROR',
215: x_msg_count,
210: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
211: x_return_status := OKC_API.HANDLE_EXCEPTIONS
212: (l_api_name,
213: G_PKG_NAME,
214: 'OKC_API.G_RET_STS_UNEXP_ERROR',
215: x_msg_count,
216: x_msg_data,
217: '_PUB');
218: WHEN OTHERS THEN
215: x_msg_count,
216: x_msg_data,
217: '_PUB');
218: WHEN OTHERS THEN
219: x_return_status := OKC_API.HANDLE_EXCEPTIONS
220: (l_api_name,
221: G_PKG_NAME,
222: 'OTHERS',
223: x_msg_count,
234: ,x_msg_count out nocopy Number
235: ,x_msg_data out nocopy Varchar2
236: ,x_pm_reference_exists out nocopy Varchar2)
237: IS
238: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
239: l_api_name CONSTANT VARCHAR2(30) := 'Check_PM_Exists';
240: BEGIN
241: l_return_status := OKC_API.START_ACTIVITY(l_api_name
242: ,p_init_msg_list
237: IS
238: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
239: l_api_name CONSTANT VARCHAR2(30) := 'Check_PM_Exists';
240: BEGIN
241: l_return_status := OKC_API.START_ACTIVITY(l_api_name
242: ,p_init_msg_list
243: ,'_PUB'
244: ,x_return_status
245: );
242: ,p_init_msg_list
243: ,'_PUB'
244: ,x_return_status
245: );
246: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
247: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
248: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
249: RAISE OKC_API.G_EXCEPTION_ERROR;
250: END IF;
243: ,'_PUB'
244: ,x_return_status
245: );
246: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
247: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
248: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
249: RAISE OKC_API.G_EXCEPTION_ERROR;
250: END IF;
251: OKS_PM_ENTITLEMENTS_PVT.Check_PM_Exists
244: ,x_return_status
245: );
246: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
247: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
248: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
249: RAISE OKC_API.G_EXCEPTION_ERROR;
250: END IF;
251: OKS_PM_ENTITLEMENTS_PVT.Check_PM_Exists
252: (p_api_version => p_api_version
245: );
246: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
247: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
248: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
249: RAISE OKC_API.G_EXCEPTION_ERROR;
250: END IF;
251: OKS_PM_ENTITLEMENTS_PVT.Check_PM_Exists
252: (p_api_version => p_api_version
253: ,p_init_msg_list => p_init_msg_list
258: ,x_msg_data => x_msg_data
259: ,x_pm_reference_exists => x_pm_reference_exists);
260:
261:
262: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
259: ,x_pm_reference_exists => x_pm_reference_exists);
260:
261:
262: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
267:
260:
261:
262: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
267:
268: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
261:
262: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
264: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
267:
268: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
269:
264: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
265: RAISE OKC_API.G_EXCEPTION_ERROR;
266: END IF;
267:
268: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
269:
270: EXCEPTION
271: WHEN OKC_API.G_EXCEPTION_ERROR THEN
272: x_return_status := OKC_API.HANDLE_EXCEPTIONS
267:
268: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
269:
270: EXCEPTION
271: WHEN OKC_API.G_EXCEPTION_ERROR THEN
272: x_return_status := OKC_API.HANDLE_EXCEPTIONS
273: (l_api_name,
274: G_PKG_NAME,
275: 'OKC_API.G_RET_STS_ERROR',
268: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
269:
270: EXCEPTION
271: WHEN OKC_API.G_EXCEPTION_ERROR THEN
272: x_return_status := OKC_API.HANDLE_EXCEPTIONS
273: (l_api_name,
274: G_PKG_NAME,
275: 'OKC_API.G_RET_STS_ERROR',
276: x_msg_count,
271: WHEN OKC_API.G_EXCEPTION_ERROR THEN
272: x_return_status := OKC_API.HANDLE_EXCEPTIONS
273: (l_api_name,
274: G_PKG_NAME,
275: 'OKC_API.G_RET_STS_ERROR',
276: x_msg_count,
277: x_msg_data,
278: '_PUB');
279: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
275: 'OKC_API.G_RET_STS_ERROR',
276: x_msg_count,
277: x_msg_data,
278: '_PUB');
279: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
280: x_return_status := OKC_API.HANDLE_EXCEPTIONS
281: (l_api_name,
282: G_PKG_NAME,
283: 'OKC_API.G_RET_STS_UNEXP_ERROR',
276: x_msg_count,
277: x_msg_data,
278: '_PUB');
279: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
280: x_return_status := OKC_API.HANDLE_EXCEPTIONS
281: (l_api_name,
282: G_PKG_NAME,
283: 'OKC_API.G_RET_STS_UNEXP_ERROR',
284: x_msg_count,
279: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
280: x_return_status := OKC_API.HANDLE_EXCEPTIONS
281: (l_api_name,
282: G_PKG_NAME,
283: 'OKC_API.G_RET_STS_UNEXP_ERROR',
284: x_msg_count,
285: x_msg_data,
286: '_PUB');
287: WHEN OTHERS THEN
284: x_msg_count,
285: x_msg_data,
286: '_PUB');
287: WHEN OTHERS THEN
288: x_return_status := OKC_API.HANDLE_EXCEPTIONS
289: (l_api_name,
290: G_PKG_NAME,
291: 'OTHERS',
292: x_msg_count,