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

Line 15: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

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

Line 18: l_return_status := OKC_API.START_ACTIVITY(l_api_name

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: );

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_PM_ENTITLEMENTS_PVT.get_pm_contracts

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_PM_ENTITLEMENTS_PVT.get_pm_contracts
30: (p_api_version => p_api_version

Line 41: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 42: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 43: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

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);

Line 44: RAISE OKC_API.G_EXCEPTION_ERROR;

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:

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

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

Line 50: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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',

Line 51: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 54: 'OKC_API.G_RET_STS_ERROR',

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

Line 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',

Line 59: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 62: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 67: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 85: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

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

Line 88: l_return_status := OKC_API.START_ACTIVITY(l_api_name

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: );

Line 93: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 94: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 95: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

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

Line 96: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 121: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 122: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 123: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

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);

Line 124: RAISE OKC_API.G_EXCEPTION_ERROR;

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:

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

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

Line 130: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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',

Line 131: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 134: 'OKC_API.G_RET_STS_ERROR',

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

Line 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',

Line 139: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 142: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 147: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 167: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

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

Line 170: l_return_status := OKC_API.START_ACTIVITY(l_api_name

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: );

Line 175: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 177: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

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

Line 178: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 193: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 194: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 195: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

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);

Line 196: RAISE OKC_API.G_EXCEPTION_ERROR;

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:

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

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

Line 202: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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',

Line 203: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 206: 'OKC_API.G_RET_STS_ERROR',

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

Line 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',

Line 211: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 214: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 219: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 238: l_return_status Varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

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

Line 241: l_return_status := OKC_API.START_ACTIVITY(l_api_name

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: );

Line 246: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 247: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 248: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

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

Line 249: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 262: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 264: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

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);

Line 265: RAISE OKC_API.G_EXCEPTION_ERROR;

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:

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

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

Line 271: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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',

Line 272: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 275: 'OKC_API.G_RET_STS_ERROR',

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

Line 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',

Line 280: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,

Line 283: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 288: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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,