APPS.OKC_AQERRMSG_PUB dependencies on OKC_API

Line 61: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

57: l_aqev_rec aqev_rec_type;
58: l_aqmv_tbl aqmv_tbl_type := p_aqmv_tbl;
59: i NUMBER;
60: BEGIN
61: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
62: p_init_msg_list,
63: '_PUB',
64: x_return_status);
65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

61: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
62: p_init_msg_list,
63: '_PUB',
64: x_return_status);
65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
66: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
68: raise OKC_API.G_EXCEPTION_ERROR;
69: END IF;

Line 66: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

62: p_init_msg_list,
63: '_PUB',
64: x_return_status);
65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
66: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
68: raise OKC_API.G_EXCEPTION_ERROR;
69: END IF;
70:

Line 67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

63: '_PUB',
64: x_return_status);
65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
66: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
68: raise OKC_API.G_EXCEPTION_ERROR;
69: END IF;
70:
71: --Call to simple API

Line 68: raise OKC_API.G_EXCEPTION_ERROR;

64: x_return_status);
65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
66: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
68: raise OKC_API.G_EXCEPTION_ERROR;
69: END IF;
70:
71: --Call to simple API
72: okc_aqe_pvt.insert_row(

Line 80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

76: x_msg_count,
77: x_msg_data,
78: p_aqev_rec,
79: x_aqev_rec);
80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
81: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
83: RAISE OKC_API.G_EXCEPTION_ERROR;
84: END IF;

Line 81: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

77: x_msg_data,
78: p_aqev_rec,
79: x_aqev_rec);
80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
81: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
83: RAISE OKC_API.G_EXCEPTION_ERROR;
84: END IF;
85:

Line 82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

78: p_aqev_rec,
79: x_aqev_rec);
80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
81: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
83: RAISE OKC_API.G_EXCEPTION_ERROR;
84: END IF;
85:
86: -- Populate the foreign key for the detail

Line 83: RAISE OKC_API.G_EXCEPTION_ERROR;

79: x_aqev_rec);
80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
81: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
83: RAISE OKC_API.G_EXCEPTION_ERROR;
84: END IF;
85:
86: -- Populate the foreign key for the detail
87: IF (l_aqmv_tbl.COUNT > 0) THEN

Line 105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

101: x_msg_count,
102: x_msg_data,
103: l_aqmv_tbl,
104: x_aqmv_tbl);
105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
108: RAISE OKC_API.G_EXCEPTION_ERROR;
109: END IF;

Line 106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

102: x_msg_data,
103: l_aqmv_tbl,
104: x_aqmv_tbl);
105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
108: RAISE OKC_API.G_EXCEPTION_ERROR;
109: END IF;
110:

Line 107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

103: l_aqmv_tbl,
104: x_aqmv_tbl);
105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
108: RAISE OKC_API.G_EXCEPTION_ERROR;
109: END IF;
110:
111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 108: RAISE OKC_API.G_EXCEPTION_ERROR;

104: x_aqmv_tbl);
105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
108: RAISE OKC_API.G_EXCEPTION_ERROR;
109: END IF;
110:
111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
112: EXCEPTION

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

107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
108: RAISE OKC_API.G_EXCEPTION_ERROR;
109: END IF;
110:
111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
112: EXCEPTION
113: WHEN OKC_API.G_EXCEPTION_ERROR THEN
114: x_return_status := OKC_API.HANDLE_EXCEPTIONS
115: (l_api_name,

Line 113: WHEN OKC_API.G_EXCEPTION_ERROR THEN

109: END IF;
110:
111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
112: EXCEPTION
113: WHEN OKC_API.G_EXCEPTION_ERROR THEN
114: x_return_status := OKC_API.HANDLE_EXCEPTIONS
115: (l_api_name,
116: G_PKG_NAME,
117: 'OKC_API.G_RET_STS_ERROR',

Line 114: x_return_status := OKC_API.HANDLE_EXCEPTIONS

110:
111: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
112: EXCEPTION
113: WHEN OKC_API.G_EXCEPTION_ERROR THEN
114: x_return_status := OKC_API.HANDLE_EXCEPTIONS
115: (l_api_name,
116: G_PKG_NAME,
117: 'OKC_API.G_RET_STS_ERROR',
118: x_msg_count,

Line 117: 'OKC_API.G_RET_STS_ERROR',

113: WHEN OKC_API.G_EXCEPTION_ERROR THEN
114: x_return_status := OKC_API.HANDLE_EXCEPTIONS
115: (l_api_name,
116: G_PKG_NAME,
117: 'OKC_API.G_RET_STS_ERROR',
118: x_msg_count,
119: x_msg_data,
120: '_PUB');
121: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 121: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

117: 'OKC_API.G_RET_STS_ERROR',
118: x_msg_count,
119: x_msg_data,
120: '_PUB');
121: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
122: x_return_status := OKC_API.HANDLE_EXCEPTIONS
123: (l_api_name,
124: G_PKG_NAME,
125: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 122: x_return_status := OKC_API.HANDLE_EXCEPTIONS

118: x_msg_count,
119: x_msg_data,
120: '_PUB');
121: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
122: x_return_status := OKC_API.HANDLE_EXCEPTIONS
123: (l_api_name,
124: G_PKG_NAME,
125: 'OKC_API.G_RET_STS_UNEXP_ERROR',
126: x_msg_count,

Line 125: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 130: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 153: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

149: x_aqmv_tbl OUT NOCOPY aqmv_tbl_type) IS
150:
151: l_api_version CONSTANT NUMBER := 1;
152: l_api_name CONSTANT VARCHAR2(30) := 'update_err_msg';
153: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
154:
155: BEGIN
156: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
157: p_init_msg_list,

Line 156: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

152: l_api_name CONSTANT VARCHAR2(30) := 'update_err_msg';
153: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
154:
155: BEGIN
156: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
157: p_init_msg_list,
158: '_PUB',
159: x_return_status);
160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

156: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
157: p_init_msg_list,
158: '_PUB',
159: x_return_status);
160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
163: raise OKC_API.G_EXCEPTION_ERROR;
164: END IF;

Line 161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

157: p_init_msg_list,
158: '_PUB',
159: x_return_status);
160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
163: raise OKC_API.G_EXCEPTION_ERROR;
164: END IF;
165:

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

158: '_PUB',
159: x_return_status);
160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
163: raise OKC_API.G_EXCEPTION_ERROR;
164: END IF;
165:
166: --Update the Master

Line 163: raise OKC_API.G_EXCEPTION_ERROR;

159: x_return_status);
160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
163: raise OKC_API.G_EXCEPTION_ERROR;
164: END IF;
165:
166: --Update the Master
167: okc_aqe_pvt.update_row(

Line 175: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

171: x_msg_count,
172: x_msg_data,
173: p_aqev_rec,
174: x_aqev_rec);
175: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF (x_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: x_msg_data,
173: p_aqev_rec,
174: x_aqev_rec);
175: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:

Line 177: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

173: p_aqev_rec,
174: x_aqev_rec);
175: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: --Update the detail

Line 178: RAISE OKC_API.G_EXCEPTION_ERROR;

174: x_aqev_rec);
175: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
176: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
178: RAISE OKC_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: --Update the detail
182: okc_aqm_pvt.update_row(

Line 190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

Line 191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

187: x_msg_data,
188: p_aqmv_tbl,
189: x_aqmv_tbl);
190: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
193: RAISE OKC_API.G_EXCEPTION_ERROR;
194: END IF;
195:

Line 192: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

Line 193: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

Line 198: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

Line 199: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 202: 'OKC_API.G_RET_STS_ERROR',

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

Line 206: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 207: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 210: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 215: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

232: p_aqmv_tbl IN aqmv_tbl_type) IS
233:
234: l_api_version CONSTANT NUMBER := 1;
235: l_api_name CONSTANT VARCHAR2(30) := 'validate_err_msg';
236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
237:
238: BEGIN
239: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
240: p_init_msg_list,

Line 239: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

235: l_api_name CONSTANT VARCHAR2(30) := 'validate_err_msg';
236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
237:
238: BEGIN
239: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
240: p_init_msg_list,
241: '_PUB',
242: x_return_status);
243: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 243: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

239: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
240: p_init_msg_list,
241: '_PUB',
242: x_return_status);
243: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
244: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
245: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
246: raise OKC_API.G_EXCEPTION_ERROR;
247: END IF;

Line 244: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

240: p_init_msg_list,
241: '_PUB',
242: x_return_status);
243: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
244: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
245: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
246: raise OKC_API.G_EXCEPTION_ERROR;
247: END IF;
248:

Line 245: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

241: '_PUB',
242: x_return_status);
243: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
244: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
245: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
246: raise OKC_API.G_EXCEPTION_ERROR;
247: END IF;
248:
249: --Validate the Master

Line 246: raise OKC_API.G_EXCEPTION_ERROR;

242: x_return_status);
243: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
244: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
245: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
246: raise OKC_API.G_EXCEPTION_ERROR;
247: END IF;
248:
249: --Validate the Master
250: okc_aqe_pvt.validate_row(

Line 257: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

253: x_return_status,
254: x_msg_count,
255: x_msg_data,
256: p_aqev_rec);
257: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
258: raise G_EXCEPTION_HALT_VALIDATION;
259: ELSE
260: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
261: l_return_status := x_return_status;

Line 260: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

256: p_aqev_rec);
257: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
258: raise G_EXCEPTION_HALT_VALIDATION;
259: ELSE
260: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
261: l_return_status := x_return_status;
262: END IF;
263: END IF;
264:

Line 273: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

269: x_return_status,
270: x_msg_count,
271: x_msg_data,
272: p_aqmv_tbl);
273: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
274: raise G_EXCEPTION_HALT_VALIDATION;
275: ELSE
276: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
277: l_return_status := x_return_status;

Line 276: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

272: p_aqmv_tbl);
273: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
274: raise G_EXCEPTION_HALT_VALIDATION;
275: ELSE
276: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
277: l_return_status := x_return_status;
278: END IF;
279: END IF;
280:

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

277: l_return_status := x_return_status;
278: END IF;
279: END IF;
280:
281: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
282: EXCEPTION
283: WHEN OKC_API.G_EXCEPTION_ERROR THEN
284: x_return_status := OKC_API.HANDLE_EXCEPTIONS
285: (l_api_name,

Line 283: WHEN OKC_API.G_EXCEPTION_ERROR THEN

279: END IF;
280:
281: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
282: EXCEPTION
283: WHEN OKC_API.G_EXCEPTION_ERROR THEN
284: x_return_status := OKC_API.HANDLE_EXCEPTIONS
285: (l_api_name,
286: G_PKG_NAME,
287: 'OKC_API.G_RET_STS_ERROR',

Line 284: x_return_status := OKC_API.HANDLE_EXCEPTIONS

280:
281: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
282: EXCEPTION
283: WHEN OKC_API.G_EXCEPTION_ERROR THEN
284: x_return_status := OKC_API.HANDLE_EXCEPTIONS
285: (l_api_name,
286: G_PKG_NAME,
287: 'OKC_API.G_RET_STS_ERROR',
288: x_msg_count,

Line 287: 'OKC_API.G_RET_STS_ERROR',

283: WHEN OKC_API.G_EXCEPTION_ERROR THEN
284: x_return_status := OKC_API.HANDLE_EXCEPTIONS
285: (l_api_name,
286: G_PKG_NAME,
287: 'OKC_API.G_RET_STS_ERROR',
288: x_msg_count,
289: x_msg_data,
290: '_PUB');
291: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 291: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

287: 'OKC_API.G_RET_STS_ERROR',
288: x_msg_count,
289: x_msg_data,
290: '_PUB');
291: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
293: (l_api_name,
294: G_PKG_NAME,
295: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 292: x_return_status := OKC_API.HANDLE_EXCEPTIONS

288: x_msg_count,
289: x_msg_data,
290: '_PUB');
291: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
293: (l_api_name,
294: G_PKG_NAME,
295: 'OKC_API.G_RET_STS_UNEXP_ERROR',
296: x_msg_count,

Line 295: 'OKC_API.G_RET_STS_UNEXP_ERROR',

291: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
293: (l_api_name,
294: G_PKG_NAME,
295: 'OKC_API.G_RET_STS_UNEXP_ERROR',
296: x_msg_count,
297: x_msg_data,
298: '_PUB');
299: WHEN OTHERS THEN

Line 300: x_return_status := OKC_API.HANDLE_EXCEPTIONS

296: x_msg_count,
297: x_msg_data,
298: '_PUB');
299: WHEN OTHERS THEN
300: x_return_status := OKC_API.HANDLE_EXCEPTIONS
301: (l_api_name,
302: G_PKG_NAME,
303: 'OTHERS',
304: x_msg_count,

Line 320: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

316: x_aqev_rec OUT NOCOPY aqev_rec_type) IS
317:
318: l_api_name CONSTANT VARCHAR2(30) := 'create_err';
319: l_api_version CONSTANT NUMBER := 1.0;
320: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
321: l_aqev_rec aqev_rec_type := p_aqev_rec;
322: BEGIN
323: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
324: g_pkg_name,

Line 323: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

319: l_api_version CONSTANT NUMBER := 1.0;
320: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
321: l_aqev_rec aqev_rec_type := p_aqev_rec;
322: BEGIN
323: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
324: g_pkg_name,
325: p_init_msg_list,
326: l_api_version,
327: p_api_version,

Line 331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

327: p_api_version,
328: '_PUB',
329: x_return_status);
330:
331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
334: RAISE OKC_API.G_EXCEPTION_ERROR;
335: END IF;

Line 332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

328: '_PUB',
329: x_return_status);
330:
331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
334: RAISE OKC_API.G_EXCEPTION_ERROR;
335: END IF;
336:

Line 333: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

329: x_return_status);
330:
331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
334: RAISE OKC_API.G_EXCEPTION_ERROR;
335: END IF;
336:
337: -- USER HOOK CALL FOR BEFORE, STARTS

Line 334: RAISE OKC_API.G_EXCEPTION_ERROR;

330:
331: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
333: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
334: RAISE OKC_API.G_EXCEPTION_ERROR;
335: END IF;
336:
337: -- USER HOOK CALL FOR BEFORE, STARTS
338: g_aqev_rec := l_aqev_rec;

Line 344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

340: okc_util.call_user_hook(x_return_status => x_return_status,
341: p_package_name => g_pkg_name,
342: p_procedure_name => l_api_name,
343: p_before_after => 'B');
344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
347: RAISE OKC_API.G_EXCEPTION_ERROR;
348: END IF;

Line 345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

341: p_package_name => g_pkg_name,
342: p_procedure_name => l_api_name,
343: p_before_after => 'B');
344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
347: RAISE OKC_API.G_EXCEPTION_ERROR;
348: END IF;
349:

Line 346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

342: p_procedure_name => l_api_name,
343: p_before_after => 'B');
344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
347: RAISE OKC_API.G_EXCEPTION_ERROR;
348: END IF;
349:
350: --get values back from hook call

Line 347: RAISE OKC_API.G_EXCEPTION_ERROR;

343: p_before_after => 'B');
344: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
345: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
346: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
347: RAISE OKC_API.G_EXCEPTION_ERROR;
348: END IF;
349:
350: --get values back from hook call
351: l_aqev_rec := migrate_aqev(l_aqev_rec, g_aqev_rec);

Line 361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

357: x_msg_count => x_msg_count,
358: x_msg_data => x_msg_data,
359: p_aqev_rec => l_aqev_rec,
360: x_aqev_rec => x_aqev_rec);
361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
362: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
364: raise OKC_API.G_EXCEPTION_ERROR;
365: END IF;

Line 362: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

358: x_msg_data => x_msg_data,
359: p_aqev_rec => l_aqev_rec,
360: x_aqev_rec => x_aqev_rec);
361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
362: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
364: raise OKC_API.G_EXCEPTION_ERROR;
365: END IF;
366:

Line 363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

359: p_aqev_rec => l_aqev_rec,
360: x_aqev_rec => x_aqev_rec);
361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
362: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
364: raise OKC_API.G_EXCEPTION_ERROR;
365: END IF;
366:
367: --USER HOOK CALL FOR AFTER, STARTS

Line 364: raise OKC_API.G_EXCEPTION_ERROR;

360: x_aqev_rec => x_aqev_rec);
361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
362: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
364: raise OKC_API.G_EXCEPTION_ERROR;
365: END IF;
366:
367: --USER HOOK CALL FOR AFTER, STARTS
368: g_aqev_rec := x_aqev_rec;

Line 375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

371: p_package_name => g_pkg_name,
372: p_procedure_name => l_api_name,
373: p_before_after => 'A');
374:
375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
378: RAISE OKC_API.G_EXCEPTION_ERROR;
379: END IF;

Line 376: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

372: p_procedure_name => l_api_name,
373: p_before_after => 'A');
374:
375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
378: RAISE OKC_API.G_EXCEPTION_ERROR;
379: END IF;
380: --USER HOOK CALL FOR AFTER, ENDS

Line 377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

373: p_before_after => 'A');
374:
375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
378: RAISE OKC_API.G_EXCEPTION_ERROR;
379: END IF;
380: --USER HOOK CALL FOR AFTER, ENDS
381:

Line 378: RAISE OKC_API.G_EXCEPTION_ERROR;

374:
375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
376: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
378: RAISE OKC_API.G_EXCEPTION_ERROR;
379: END IF;
380: --USER HOOK CALL FOR AFTER, ENDS
381:
382: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

378: RAISE OKC_API.G_EXCEPTION_ERROR;
379: END IF;
380: --USER HOOK CALL FOR AFTER, ENDS
381:
382: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
383:
384: EXCEPTION
385: WHEN OKC_API.G_EXCEPTION_ERROR THEN
386: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 385: WHEN OKC_API.G_EXCEPTION_ERROR THEN

381:
382: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
383:
384: EXCEPTION
385: WHEN OKC_API.G_EXCEPTION_ERROR THEN
386: x_return_status := OKC_API.HANDLE_EXCEPTIONS
387: (
388: l_api_name,
389: G_PKG_NAME,

Line 386: x_return_status := OKC_API.HANDLE_EXCEPTIONS

382: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
383:
384: EXCEPTION
385: WHEN OKC_API.G_EXCEPTION_ERROR THEN
386: x_return_status := OKC_API.HANDLE_EXCEPTIONS
387: (
388: l_api_name,
389: G_PKG_NAME,
390: 'OKC_API.G_RET_STS_ERROR',

Line 390: 'OKC_API.G_RET_STS_ERROR',

386: x_return_status := OKC_API.HANDLE_EXCEPTIONS
387: (
388: l_api_name,
389: G_PKG_NAME,
390: 'OKC_API.G_RET_STS_ERROR',
391: x_msg_count,
392: x_msg_data,
393: '_PUB'
394: );

Line 396: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

392: x_msg_data,
393: '_PUB'
394: );
395:
396: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
397: x_return_status := OKC_API.HANDLE_EXCEPTIONS
398: (
399: l_api_name,
400: G_PKG_NAME,

Line 397: x_return_status := OKC_API.HANDLE_EXCEPTIONS

393: '_PUB'
394: );
395:
396: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
397: x_return_status := OKC_API.HANDLE_EXCEPTIONS
398: (
399: l_api_name,
400: G_PKG_NAME,
401: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 401: 'OKC_API.G_RET_STS_UNEXP_ERROR',

397: x_return_status := OKC_API.HANDLE_EXCEPTIONS
398: (
399: l_api_name,
400: G_PKG_NAME,
401: 'OKC_API.G_RET_STS_UNEXP_ERROR',
402: x_msg_count,
403: x_msg_data,
404: '_PUB'
405: );

Line 408: x_return_status := OKC_API.HANDLE_EXCEPTIONS

404: '_PUB'
405: );
406:
407: WHEN OTHERS THEN
408: x_return_status := OKC_API.HANDLE_EXCEPTIONS
409: (
410: l_api_name,
411: G_PKG_NAME,
412: 'OTHERS',

Line 427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

423: x_msg_data OUT NOCOPY VARCHAR2,
424: p_aqev_tbl IN aqev_tbl_type,
425: x_aqev_tbl OUT NOCOPY aqev_tbl_type) IS
426:
427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
428: i NUMBER := 0;
429: BEGIN
430: --Initialize the return status
431: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 431: x_return_status := OKC_API.G_RET_STS_SUCCESS;

427: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
428: i NUMBER := 0;
429: BEGIN
430: --Initialize the return status
431: x_return_status := OKC_API.G_RET_STS_SUCCESS;
432:
433: IF p_aqev_tbl.COUNT > 0 THEN
434: i := p_aqev_tbl.FIRST;
435: LOOP

Line 444: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

440: x_msg_count,
441: x_msg_data,
442: p_aqev_tbl(i),
443: x_aqev_tbl(i));
444: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
445: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
446: x_return_status := l_return_status;
447: raise G_EXCEPTION_HALT_VALIDATION;
448: ELSE

Line 445: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

441: x_msg_data,
442: p_aqev_tbl(i),
443: x_aqev_tbl(i));
444: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
445: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
446: x_return_status := l_return_status;
447: raise G_EXCEPTION_HALT_VALIDATION;
448: ELSE
449: x_return_status := l_return_status;

Line 461: OKC_API.set_message(p_app_name => g_app_name,

457: WHEN G_EXCEPTION_HALT_VALIDATION THEN
458: NULL;
459:
460: WHEN OTHERS THEN
461: OKC_API.set_message(p_app_name => g_app_name,
462: p_msg_name => g_unexpected_error,
463: p_token1 => g_sqlcode_token,
464: p_token1_value => sqlcode,
465: p_token2 => g_sqlerrm_token,

Line 467: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

463: p_token1 => g_sqlcode_token,
464: p_token1_value => sqlcode,
465: p_token2 => g_sqlerrm_token,
466: p_token2_value => sqlerrm);
467: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
468: END create_err;
469:
470: PROCEDURE lock_err(p_api_version IN NUMBER,
471: p_init_msg_list IN VARCHAR2 ,

Line 478: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

474: x_msg_data OUT NOCOPY VARCHAR2,
475: p_aqev_rec IN aqev_rec_type) IS
476: l_api_name CONSTANT VARCHAR2(30) := 'lock_err';
477: l_api_version CONSTANT NUMBER := 1.0;
478: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
479: BEGIN
480: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
481: g_pkg_name,
482: p_init_msg_list,

Line 480: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

476: l_api_name CONSTANT VARCHAR2(30) := 'lock_err';
477: l_api_version CONSTANT NUMBER := 1.0;
478: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
479: BEGIN
480: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
481: g_pkg_name,
482: p_init_msg_list,
483: l_api_version,
484: p_api_version,

Line 487: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

483: l_api_version,
484: p_api_version,
485: '_PUB',
486: x_return_status);
487: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
490: RAISE OKC_API.G_EXCEPTION_ERROR;
491: END IF;

Line 488: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

484: p_api_version,
485: '_PUB',
486: x_return_status);
487: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
490: RAISE OKC_API.G_EXCEPTION_ERROR;
491: END IF;
492:

Line 489: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

485: '_PUB',
486: x_return_status);
487: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
490: RAISE OKC_API.G_EXCEPTION_ERROR;
491: END IF;
492:
493: -- Call to procedure of Simple API

Line 490: RAISE OKC_API.G_EXCEPTION_ERROR;

486: x_return_status);
487: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
490: RAISE OKC_API.G_EXCEPTION_ERROR;
491: END IF;
492:
493: -- Call to procedure of Simple API
494: okc_aqe_pvt.lock_row(p_api_version => p_api_version,

Line 500: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

496: x_return_status => x_return_status,
497: x_msg_count => x_msg_count,
498: x_msg_data => x_msg_data,
499: p_aqev_rec => p_aqev_rec);
500: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
501: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
502: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
503: RAISE OKC_API.G_EXCEPTION_ERROR;
504: END IF;

Line 501: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

497: x_msg_count => x_msg_count,
498: x_msg_data => x_msg_data,
499: p_aqev_rec => p_aqev_rec);
500: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
501: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
502: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
503: RAISE OKC_API.G_EXCEPTION_ERROR;
504: END IF;
505:

Line 502: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

498: x_msg_data => x_msg_data,
499: p_aqev_rec => p_aqev_rec);
500: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
501: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
502: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
503: RAISE OKC_API.G_EXCEPTION_ERROR;
504: END IF;
505:
506: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 503: RAISE OKC_API.G_EXCEPTION_ERROR;

499: p_aqev_rec => p_aqev_rec);
500: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
501: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
502: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
503: RAISE OKC_API.G_EXCEPTION_ERROR;
504: END IF;
505:
506: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
507:

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

502: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
503: RAISE OKC_API.G_EXCEPTION_ERROR;
504: END IF;
505:
506: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
507:
508: EXCEPTION
509: WHEN OKC_API.G_EXCEPTION_ERROR THEN
510: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 509: WHEN OKC_API.G_EXCEPTION_ERROR THEN

505:
506: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
507:
508: EXCEPTION
509: WHEN OKC_API.G_EXCEPTION_ERROR THEN
510: x_return_status := OKC_API.HANDLE_EXCEPTIONS
511: (
512: l_api_name,
513: G_PKG_NAME,

Line 510: x_return_status := OKC_API.HANDLE_EXCEPTIONS

506: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
507:
508: EXCEPTION
509: WHEN OKC_API.G_EXCEPTION_ERROR THEN
510: x_return_status := OKC_API.HANDLE_EXCEPTIONS
511: (
512: l_api_name,
513: G_PKG_NAME,
514: 'OKC_API.G_RET_STS_ERROR',

Line 514: 'OKC_API.G_RET_STS_ERROR',

510: x_return_status := OKC_API.HANDLE_EXCEPTIONS
511: (
512: l_api_name,
513: G_PKG_NAME,
514: 'OKC_API.G_RET_STS_ERROR',
515: x_msg_count,
516: x_msg_data,
517: '_PUB'
518: );

Line 520: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

516: x_msg_data,
517: '_PUB'
518: );
519:
520: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
522: (
523: l_api_name,
524: G_PKG_NAME,

Line 521: x_return_status := OKC_API.HANDLE_EXCEPTIONS

517: '_PUB'
518: );
519:
520: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
522: (
523: l_api_name,
524: G_PKG_NAME,
525: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 525: 'OKC_API.G_RET_STS_UNEXP_ERROR',

521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
522: (
523: l_api_name,
524: G_PKG_NAME,
525: 'OKC_API.G_RET_STS_UNEXP_ERROR',
526: x_msg_count,
527: x_msg_data,
528: '_PUB'
529: );

Line 532: x_return_status := OKC_API.HANDLE_EXCEPTIONS

528: '_PUB'
529: );
530:
531: WHEN OTHERS THEN
532: x_return_status := OKC_API.HANDLE_EXCEPTIONS
533: (
534: l_api_name,
535: G_PKG_NAME,
536: 'OTHERS',

Line 550: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

546: x_msg_count OUT NOCOPY NUMBER,
547: x_msg_data OUT NOCOPY VARCHAR2,
548: p_aqev_tbl IN aqev_tbl_type) IS
549:
550: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
551: i NUMBER := 0;
552: BEGIN
553: x_return_status := OKC_API.G_RET_STS_SUCCESS;
554: IF p_aqev_tbl.COUNT > 0 THEN

Line 553: x_return_status := OKC_API.G_RET_STS_SUCCESS;

549:
550: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
551: i NUMBER := 0;
552: BEGIN
553: x_return_status := OKC_API.G_RET_STS_SUCCESS;
554: IF p_aqev_tbl.COUNT > 0 THEN
555: i := p_aqev_tbl.FIRST;
556: LOOP
557: lock_err(

Line 564: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

560: l_return_status,
561: x_msg_count,
562: x_msg_data,
563: p_aqev_tbl(i));
564: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
565: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
566: x_return_status := l_return_status;
567: raise G_EXCEPTION_HALT_VALIDATION;
568: ELSE

Line 565: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

561: x_msg_count,
562: x_msg_data,
563: p_aqev_tbl(i));
564: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
565: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
566: x_return_status := l_return_status;
567: raise G_EXCEPTION_HALT_VALIDATION;
568: ELSE
569: x_return_status := l_return_status;

Line 581: OKC_API.set_message(p_app_name => g_app_name,

577: WHEN G_EXCEPTION_HALT_VALIDATION THEN
578: NULL;
579:
580: WHEN OTHERS THEN
581: OKC_API.set_message(p_app_name => g_app_name,
582: p_msg_name => g_unexpected_error,
583: p_token1 => g_sqlcode_token,
584: p_token1_value => sqlcode,
585: p_token2 => g_sqlerrm_token,

Line 587: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

583: p_token1 => g_sqlcode_token,
584: p_token1_value => sqlcode,
585: p_token2 => g_sqlerrm_token,
586: p_token2_value => sqlerrm);
587: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
588: END lock_err;
589:
590: PROCEDURE update_err(p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 ,

Line 600: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

596: x_aqev_rec OUT NOCOPY aqev_rec_type) IS
597:
598: l_api_name CONSTANT VARCHAR2(30) := 'update_err';
599: l_api_version CONSTANT NUMBER := 1.0;
600: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
601: l_aqev_rec aqev_rec_type := p_aqev_rec;
602: BEGIN
603: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
604: g_pkg_name,

Line 603: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

599: l_api_version CONSTANT NUMBER := 1.0;
600: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
601: l_aqev_rec aqev_rec_type := p_aqev_rec;
602: BEGIN
603: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
604: g_pkg_name,
605: p_init_msg_list,
606: l_api_version,
607: p_api_version,

Line 611: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

607: p_api_version,
608: '_PUB',
609: x_return_status);
610:
611: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_ERROR;
615: END IF;

Line 612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

608: '_PUB',
609: x_return_status);
610:
611: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_ERROR;
615: END IF;
616:

Line 613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

609: x_return_status);
610:
611: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_ERROR;
615: END IF;
616:
617: -- USER HOOK CALL FOR BEFORE, STARTS

Line 614: RAISE OKC_API.G_EXCEPTION_ERROR;

610:
611: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
614: RAISE OKC_API.G_EXCEPTION_ERROR;
615: END IF;
616:
617: -- USER HOOK CALL FOR BEFORE, STARTS
618: g_aqev_rec := l_aqev_rec;

Line 625: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

621: p_package_name => g_pkg_name,
622: p_procedure_name => l_api_name,
623: p_before_after => 'B');
624:
625: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
627: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
628: RAISE OKC_API.G_EXCEPTION_ERROR;
629: END IF;

Line 626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

622: p_procedure_name => l_api_name,
623: p_before_after => 'B');
624:
625: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
627: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
628: RAISE OKC_API.G_EXCEPTION_ERROR;
629: END IF;
630:

Line 627: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

623: p_before_after => 'B');
624:
625: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
627: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
628: RAISE OKC_API.G_EXCEPTION_ERROR;
629: END IF;
630:
631: --get values back from hook call

Line 628: RAISE OKC_API.G_EXCEPTION_ERROR;

624:
625: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
626: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
627: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
628: RAISE OKC_API.G_EXCEPTION_ERROR;
629: END IF;
630:
631: --get values back from hook call
632: l_aqev_rec := migrate_aqev(l_aqev_rec, g_aqev_rec);

Line 642: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

638: x_msg_count => x_msg_count,
639: x_msg_data => x_msg_data,
640: p_aqev_rec => l_aqev_rec,
641: x_aqev_rec => x_aqev_rec);
642: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
643: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
644: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
645: RAISE OKC_API.G_EXCEPTION_ERROR;
646: END IF;

Line 643: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

639: x_msg_data => x_msg_data,
640: p_aqev_rec => l_aqev_rec,
641: x_aqev_rec => x_aqev_rec);
642: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
643: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
644: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
645: RAISE OKC_API.G_EXCEPTION_ERROR;
646: END IF;
647:

Line 644: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

640: p_aqev_rec => l_aqev_rec,
641: x_aqev_rec => x_aqev_rec);
642: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
643: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
644: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
645: RAISE OKC_API.G_EXCEPTION_ERROR;
646: END IF;
647:
648: --USER HOOK CALL FOR AFTER, STARTS

Line 645: RAISE OKC_API.G_EXCEPTION_ERROR;

641: x_aqev_rec => x_aqev_rec);
642: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
643: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
644: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
645: RAISE OKC_API.G_EXCEPTION_ERROR;
646: END IF;
647:
648: --USER HOOK CALL FOR AFTER, STARTS
649: g_aqev_rec := x_aqev_rec;

Line 656: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

652: p_package_name => g_pkg_name,
653: p_procedure_name => l_api_name,
654: p_before_after => 'A');
655:
656: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
659: RAISE OKC_API.G_EXCEPTION_ERROR;
660: END IF;

Line 657: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

653: p_procedure_name => l_api_name,
654: p_before_after => 'A');
655:
656: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
659: RAISE OKC_API.G_EXCEPTION_ERROR;
660: END IF;
661: --USER HOOK CALL FOR AFTER, ENDS

Line 658: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

654: p_before_after => 'A');
655:
656: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
659: RAISE OKC_API.G_EXCEPTION_ERROR;
660: END IF;
661: --USER HOOK CALL FOR AFTER, ENDS
662:

Line 659: RAISE OKC_API.G_EXCEPTION_ERROR;

655:
656: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
659: RAISE OKC_API.G_EXCEPTION_ERROR;
660: END IF;
661: --USER HOOK CALL FOR AFTER, ENDS
662:
663: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

659: RAISE OKC_API.G_EXCEPTION_ERROR;
660: END IF;
661: --USER HOOK CALL FOR AFTER, ENDS
662:
663: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
664:
665: EXCEPTION
666: WHEN OKC_API.G_EXCEPTION_ERROR THEN
667: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 666: WHEN OKC_API.G_EXCEPTION_ERROR THEN

662:
663: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
664:
665: EXCEPTION
666: WHEN OKC_API.G_EXCEPTION_ERROR THEN
667: x_return_status := OKC_API.HANDLE_EXCEPTIONS
668: (
669: l_api_name,
670: G_PKG_NAME,

Line 667: x_return_status := OKC_API.HANDLE_EXCEPTIONS

663: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
664:
665: EXCEPTION
666: WHEN OKC_API.G_EXCEPTION_ERROR THEN
667: x_return_status := OKC_API.HANDLE_EXCEPTIONS
668: (
669: l_api_name,
670: G_PKG_NAME,
671: 'OKC_API.G_RET_STS_ERROR',

Line 671: 'OKC_API.G_RET_STS_ERROR',

667: x_return_status := OKC_API.HANDLE_EXCEPTIONS
668: (
669: l_api_name,
670: G_PKG_NAME,
671: 'OKC_API.G_RET_STS_ERROR',
672: x_msg_count,
673: x_msg_data,
674: '_PUB'
675: );

Line 677: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

673: x_msg_data,
674: '_PUB'
675: );
676:
677: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
678: x_return_status := OKC_API.HANDLE_EXCEPTIONS
679: (
680: l_api_name,
681: G_PKG_NAME,

Line 678: x_return_status := OKC_API.HANDLE_EXCEPTIONS

674: '_PUB'
675: );
676:
677: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
678: x_return_status := OKC_API.HANDLE_EXCEPTIONS
679: (
680: l_api_name,
681: G_PKG_NAME,
682: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 682: 'OKC_API.G_RET_STS_UNEXP_ERROR',

678: x_return_status := OKC_API.HANDLE_EXCEPTIONS
679: (
680: l_api_name,
681: G_PKG_NAME,
682: 'OKC_API.G_RET_STS_UNEXP_ERROR',
683: x_msg_count,
684: x_msg_data,
685: '_PUB'
686: );

Line 689: x_return_status := OKC_API.HANDLE_EXCEPTIONS

685: '_PUB'
686: );
687:
688: WHEN OTHERS THEN
689: x_return_status := OKC_API.HANDLE_EXCEPTIONS
690: (
691: l_api_name,
692: G_PKG_NAME,
693: 'OTHERS',

Line 708: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

704: x_msg_data OUT NOCOPY VARCHAR2,
705: p_aqev_tbl IN aqev_tbl_type,
706: x_aqev_tbl OUT NOCOPY aqev_tbl_type) IS
707:
708: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
709: i NUMBER := 0;
710: BEGIN
711: x_return_status := OKC_API.G_RET_STS_SUCCESS;
712: IF p_aqev_tbl.COUNT > 0 THEN

Line 711: x_return_status := OKC_API.G_RET_STS_SUCCESS;

707:
708: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
709: i NUMBER := 0;
710: BEGIN
711: x_return_status := OKC_API.G_RET_STS_SUCCESS;
712: IF p_aqev_tbl.COUNT > 0 THEN
713: i := p_aqev_tbl.FIRST;
714: LOOP
715: update_err(

Line 723: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

719: x_msg_count,
720: x_msg_data,
721: p_aqev_tbl(i),
722: x_aqev_tbl(i));
723: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
725: x_return_status := l_return_status;
726: raise G_EXCEPTION_HALT_VALIDATION;
727: ELSE

Line 724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

720: x_msg_data,
721: p_aqev_tbl(i),
722: x_aqev_tbl(i));
723: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
725: x_return_status := l_return_status;
726: raise G_EXCEPTION_HALT_VALIDATION;
727: ELSE
728: x_return_status := l_return_status;

Line 740: OKC_API.set_message(p_app_name => g_app_name,

736: WHEN G_EXCEPTION_HALT_VALIDATION THEN
737: NULL;
738:
739: WHEN OTHERS THEN
740: OKC_API.set_message(p_app_name => g_app_name,
741: p_msg_name => g_unexpected_error,
742: p_token1 => g_sqlcode_token,
743: p_token1_value => sqlcode,
744: p_token2 => g_sqlerrm_token,

Line 746: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

742: p_token1 => g_sqlcode_token,
743: p_token1_value => sqlcode,
744: p_token2 => g_sqlerrm_token,
745: p_token2_value => sqlerrm);
746: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
747: END update_err;
748:
749: PROCEDURE delete_err(p_api_version IN NUMBER,
750: p_init_msg_list IN VARCHAR2 ,

Line 758: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

754: p_aqev_rec IN aqev_rec_type) IS
755:
756: l_api_name CONSTANT VARCHAR2(30) := 'delete_err';
757: l_api_version CONSTANT NUMBER := 1.0;
758: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
759: l_aqev_rec aqev_rec_type := p_aqev_rec;
760: BEGIN
761: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
762: g_pkg_name,

Line 761: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

757: l_api_version CONSTANT NUMBER := 1.0;
758: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
759: l_aqev_rec aqev_rec_type := p_aqev_rec;
760: BEGIN
761: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
762: g_pkg_name,
763: p_init_msg_list,
764: l_api_version,
765: p_api_version,

Line 769: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

765: p_api_version,
766: '_PUB',
767: x_return_status);
768:
769: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
771: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
772: RAISE OKC_API.G_EXCEPTION_ERROR;
773: END IF;

Line 770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

766: '_PUB',
767: x_return_status);
768:
769: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
771: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
772: RAISE OKC_API.G_EXCEPTION_ERROR;
773: END IF;
774:

Line 771: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

767: x_return_status);
768:
769: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
771: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
772: RAISE OKC_API.G_EXCEPTION_ERROR;
773: END IF;
774:
775: -- USER HOOK CALL FOR BEFORE, STARTS

Line 772: RAISE OKC_API.G_EXCEPTION_ERROR;

768:
769: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
771: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
772: RAISE OKC_API.G_EXCEPTION_ERROR;
773: END IF;
774:
775: -- USER HOOK CALL FOR BEFORE, STARTS
776: g_aqev_rec := l_aqev_rec;

Line 782: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

778: okc_util.call_user_hook(x_return_status => x_return_status,
779: p_package_name => g_pkg_name,
780: p_procedure_name => l_api_name,
781: p_before_after => 'B');
782: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
783: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
785: RAISE OKC_API.G_EXCEPTION_ERROR;
786: END IF;

Line 783: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

779: p_package_name => g_pkg_name,
780: p_procedure_name => l_api_name,
781: p_before_after => 'B');
782: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
783: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
785: RAISE OKC_API.G_EXCEPTION_ERROR;
786: END IF;
787:

Line 784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

780: p_procedure_name => l_api_name,
781: p_before_after => 'B');
782: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
783: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
785: RAISE OKC_API.G_EXCEPTION_ERROR;
786: END IF;
787:
788: --get values back from hook call

Line 785: RAISE OKC_API.G_EXCEPTION_ERROR;

781: p_before_after => 'B');
782: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
783: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
785: RAISE OKC_API.G_EXCEPTION_ERROR;
786: END IF;
787:
788: --get values back from hook call
789: l_aqev_rec := migrate_aqev(l_aqev_rec, g_aqev_rec);

Line 798: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

794: x_return_status => x_return_status,
795: x_msg_count => x_msg_count,
796: x_msg_data => x_msg_data,
797: p_aqev_rec => l_aqev_rec);
798: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_ERROR;
802: END IF;

Line 799: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

795: x_msg_count => x_msg_count,
796: x_msg_data => x_msg_data,
797: p_aqev_rec => l_aqev_rec);
798: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_ERROR;
802: END IF;
803:

Line 800: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

796: x_msg_data => x_msg_data,
797: p_aqev_rec => l_aqev_rec);
798: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_ERROR;
802: END IF;
803:
804: --USER HOOK CALL FOR AFTER, STARTS

Line 801: RAISE OKC_API.G_EXCEPTION_ERROR;

797: p_aqev_rec => l_aqev_rec);
798: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
799: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_ERROR;
802: END IF;
803:
804: --USER HOOK CALL FOR AFTER, STARTS
805: okc_util.call_user_hook(x_return_status => x_return_status,

Line 810: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

806: p_package_name => g_pkg_name,
807: p_procedure_name => l_api_name,
808: p_before_after => 'A');
809:
810: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
813: RAISE OKC_API.G_EXCEPTION_ERROR;
814: END IF;

Line 811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

807: p_procedure_name => l_api_name,
808: p_before_after => 'A');
809:
810: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
813: RAISE OKC_API.G_EXCEPTION_ERROR;
814: END IF;
815: --USER HOOK CALL FOR AFTER, ENDS

Line 812: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

808: p_before_after => 'A');
809:
810: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
813: RAISE OKC_API.G_EXCEPTION_ERROR;
814: END IF;
815: --USER HOOK CALL FOR AFTER, ENDS
816:

Line 813: RAISE OKC_API.G_EXCEPTION_ERROR;

809:
810: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
813: RAISE OKC_API.G_EXCEPTION_ERROR;
814: END IF;
815: --USER HOOK CALL FOR AFTER, ENDS
816:
817: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

813: RAISE OKC_API.G_EXCEPTION_ERROR;
814: END IF;
815: --USER HOOK CALL FOR AFTER, ENDS
816:
817: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
818:
819: EXCEPTION
820: WHEN OKC_API.G_EXCEPTION_ERROR THEN
821: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 820: WHEN OKC_API.G_EXCEPTION_ERROR THEN

816:
817: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
818:
819: EXCEPTION
820: WHEN OKC_API.G_EXCEPTION_ERROR THEN
821: x_return_status := OKC_API.HANDLE_EXCEPTIONS
822: (
823: l_api_name,
824: G_PKG_NAME,

Line 821: x_return_status := OKC_API.HANDLE_EXCEPTIONS

817: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
818:
819: EXCEPTION
820: WHEN OKC_API.G_EXCEPTION_ERROR THEN
821: x_return_status := OKC_API.HANDLE_EXCEPTIONS
822: (
823: l_api_name,
824: G_PKG_NAME,
825: 'OKC_API.G_RET_STS_ERROR',

Line 825: 'OKC_API.G_RET_STS_ERROR',

821: x_return_status := OKC_API.HANDLE_EXCEPTIONS
822: (
823: l_api_name,
824: G_PKG_NAME,
825: 'OKC_API.G_RET_STS_ERROR',
826: x_msg_count,
827: x_msg_data,
828: '_PUB'
829: );

Line 831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

827: x_msg_data,
828: '_PUB'
829: );
830:
831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
832: x_return_status := OKC_API.HANDLE_EXCEPTIONS
833: (
834: l_api_name,
835: G_PKG_NAME,

Line 832: x_return_status := OKC_API.HANDLE_EXCEPTIONS

828: '_PUB'
829: );
830:
831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
832: x_return_status := OKC_API.HANDLE_EXCEPTIONS
833: (
834: l_api_name,
835: G_PKG_NAME,
836: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 836: 'OKC_API.G_RET_STS_UNEXP_ERROR',

832: x_return_status := OKC_API.HANDLE_EXCEPTIONS
833: (
834: l_api_name,
835: G_PKG_NAME,
836: 'OKC_API.G_RET_STS_UNEXP_ERROR',
837: x_msg_count,
838: x_msg_data,
839: '_PUB'
840: );

Line 843: x_return_status := OKC_API.HANDLE_EXCEPTIONS

839: '_PUB'
840: );
841:
842: WHEN OTHERS THEN
843: x_return_status := OKC_API.HANDLE_EXCEPTIONS
844: (
845: l_api_name,
846: G_PKG_NAME,
847: 'OTHERS',

Line 861: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

857: x_msg_count OUT NOCOPY NUMBER,
858: x_msg_data OUT NOCOPY VARCHAR2,
859: p_aqev_tbl IN aqev_tbl_type) IS
860:
861: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
862: i NUMBER := 0;
863: BEGIN
864: x_return_status := OKC_API.G_RET_STS_SUCCESS;
865: IF p_aqev_tbl.COUNT > 0 THEN

Line 864: x_return_status := OKC_API.G_RET_STS_SUCCESS;

860:
861: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
862: i NUMBER := 0;
863: BEGIN
864: x_return_status := OKC_API.G_RET_STS_SUCCESS;
865: IF p_aqev_tbl.COUNT > 0 THEN
866: i := p_aqev_tbl.FIRST;
867: LOOP
868: delete_err(

Line 875: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

871: l_return_status,
872: x_msg_count,
873: x_msg_data,
874: p_aqev_tbl(i));
875: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
877: x_return_status := l_return_status;
878: raise G_EXCEPTION_HALT_VALIDATION;
879: ELSE

Line 876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

872: x_msg_count,
873: x_msg_data,
874: p_aqev_tbl(i));
875: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
877: x_return_status := l_return_status;
878: raise G_EXCEPTION_HALT_VALIDATION;
879: ELSE
880: x_return_status := l_return_status;

Line 892: OKC_API.set_message(p_app_name => g_app_name,

888: WHEN G_EXCEPTION_HALT_VALIDATION THEN
889: NULL;
890:
891: WHEN OTHERS THEN
892: OKC_API.set_message(p_app_name => g_app_name,
893: p_msg_name => g_unexpected_error,
894: p_token1 => g_sqlcode_token,
895: p_token1_value => sqlcode,
896: p_token2 => g_sqlerrm_token,

Line 898: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

894: p_token1 => g_sqlcode_token,
895: p_token1_value => sqlcode,
896: p_token2 => g_sqlerrm_token,
897: p_token2_value => sqlerrm);
898: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
899: END delete_err;
900:
901: PROCEDURE validate_err(p_api_version IN NUMBER,
902: p_init_msg_list IN VARCHAR2 ,

Line 910: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

906: p_aqev_rec IN aqev_rec_type) IS
907:
908: l_api_name CONSTANT VARCHAR2(30) := 'validate_err';
909: l_api_version CONSTANT NUMBER := 1.0;
910: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
911: l_aqev_rec aqev_rec_type := p_aqev_rec;
912: BEGIN
913: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
914: g_pkg_name,

Line 913: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

909: l_api_version CONSTANT NUMBER := 1.0;
910: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
911: l_aqev_rec aqev_rec_type := p_aqev_rec;
912: BEGIN
913: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
914: g_pkg_name,
915: p_init_msg_list,
916: l_api_version,
917: p_api_version,

Line 921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

917: p_api_version,
918: '_PUB',
919: x_return_status);
920:
921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
923: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
924: RAISE OKC_API.G_EXCEPTION_ERROR;
925: END IF;

Line 922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

918: '_PUB',
919: x_return_status);
920:
921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
923: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
924: RAISE OKC_API.G_EXCEPTION_ERROR;
925: END IF;
926:

Line 923: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

919: x_return_status);
920:
921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
923: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
924: RAISE OKC_API.G_EXCEPTION_ERROR;
925: END IF;
926:
927: -- USER HOOK CALL FOR BEFORE, STARTS

Line 924: RAISE OKC_API.G_EXCEPTION_ERROR;

920:
921: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
922: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
923: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
924: RAISE OKC_API.G_EXCEPTION_ERROR;
925: END IF;
926:
927: -- USER HOOK CALL FOR BEFORE, STARTS
928: g_aqev_rec := l_aqev_rec;

Line 935: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

931: p_package_name => g_pkg_name,
932: p_procedure_name => l_api_name,
933: p_before_after => 'B');
934:
935: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
936: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
937: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
938: RAISE OKC_API.G_EXCEPTION_ERROR;
939: END IF;

Line 936: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

932: p_procedure_name => l_api_name,
933: p_before_after => 'B');
934:
935: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
936: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
937: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
938: RAISE OKC_API.G_EXCEPTION_ERROR;
939: END IF;
940:

Line 937: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

933: p_before_after => 'B');
934:
935: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
936: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
937: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
938: RAISE OKC_API.G_EXCEPTION_ERROR;
939: END IF;
940:
941: --get values back from hook call

Line 938: RAISE OKC_API.G_EXCEPTION_ERROR;

934:
935: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
936: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
937: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
938: RAISE OKC_API.G_EXCEPTION_ERROR;
939: END IF;
940:
941: --get values back from hook call
942: l_aqev_rec := migrate_aqev(l_aqev_rec, g_aqev_rec);

Line 951: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

947: x_return_status => x_return_status,
948: x_msg_count => x_msg_count,
949: x_msg_data => x_msg_data,
950: p_aqev_rec => l_aqev_rec);
951: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
952: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
954: RAISE OKC_API.G_EXCEPTION_ERROR;
955: END IF;

Line 952: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

948: x_msg_count => x_msg_count,
949: x_msg_data => x_msg_data,
950: p_aqev_rec => l_aqev_rec);
951: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
952: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
954: RAISE OKC_API.G_EXCEPTION_ERROR;
955: END IF;
956:

Line 953: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

949: x_msg_data => x_msg_data,
950: p_aqev_rec => l_aqev_rec);
951: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
952: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
954: RAISE OKC_API.G_EXCEPTION_ERROR;
955: END IF;
956:
957: --USER HOOK CALL FOR AFTER, STARTS

Line 954: RAISE OKC_API.G_EXCEPTION_ERROR;

950: p_aqev_rec => l_aqev_rec);
951: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
952: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
954: RAISE OKC_API.G_EXCEPTION_ERROR;
955: END IF;
956:
957: --USER HOOK CALL FOR AFTER, STARTS
958:

Line 964: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

960: p_package_name => g_pkg_name,
961: p_procedure_name => l_api_name,
962: p_before_after => 'A');
963:
964: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
965: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
966: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
967: RAISE OKC_API.G_EXCEPTION_ERROR;
968: END IF;

Line 965: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

961: p_procedure_name => l_api_name,
962: p_before_after => 'A');
963:
964: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
965: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
966: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
967: RAISE OKC_API.G_EXCEPTION_ERROR;
968: END IF;
969: --USER HOOK CALL FOR AFTER, ENDS

Line 966: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

962: p_before_after => 'A');
963:
964: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
965: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
966: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
967: RAISE OKC_API.G_EXCEPTION_ERROR;
968: END IF;
969: --USER HOOK CALL FOR AFTER, ENDS
970:

Line 967: RAISE OKC_API.G_EXCEPTION_ERROR;

963:
964: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
965: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
966: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
967: RAISE OKC_API.G_EXCEPTION_ERROR;
968: END IF;
969: --USER HOOK CALL FOR AFTER, ENDS
970:
971: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

967: RAISE OKC_API.G_EXCEPTION_ERROR;
968: END IF;
969: --USER HOOK CALL FOR AFTER, ENDS
970:
971: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
972: EXCEPTION
973: WHEN OKC_API.G_EXCEPTION_ERROR THEN
974: x_return_status := OKC_API.HANDLE_EXCEPTIONS
975: (

Line 973: WHEN OKC_API.G_EXCEPTION_ERROR THEN

969: --USER HOOK CALL FOR AFTER, ENDS
970:
971: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
972: EXCEPTION
973: WHEN OKC_API.G_EXCEPTION_ERROR THEN
974: x_return_status := OKC_API.HANDLE_EXCEPTIONS
975: (
976: l_api_name,
977: G_PKG_NAME,

Line 974: x_return_status := OKC_API.HANDLE_EXCEPTIONS

970:
971: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
972: EXCEPTION
973: WHEN OKC_API.G_EXCEPTION_ERROR THEN
974: x_return_status := OKC_API.HANDLE_EXCEPTIONS
975: (
976: l_api_name,
977: G_PKG_NAME,
978: 'OKC_API.G_RET_STS_ERROR',

Line 978: 'OKC_API.G_RET_STS_ERROR',

974: x_return_status := OKC_API.HANDLE_EXCEPTIONS
975: (
976: l_api_name,
977: G_PKG_NAME,
978: 'OKC_API.G_RET_STS_ERROR',
979: x_msg_count,
980: x_msg_data,
981: '_PUB'
982: );

Line 984: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

980: x_msg_data,
981: '_PUB'
982: );
983:
984: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
985: x_return_status := OKC_API.HANDLE_EXCEPTIONS
986: (
987: l_api_name,
988: G_PKG_NAME,

Line 985: x_return_status := OKC_API.HANDLE_EXCEPTIONS

981: '_PUB'
982: );
983:
984: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
985: x_return_status := OKC_API.HANDLE_EXCEPTIONS
986: (
987: l_api_name,
988: G_PKG_NAME,
989: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 989: 'OKC_API.G_RET_STS_UNEXP_ERROR',

985: x_return_status := OKC_API.HANDLE_EXCEPTIONS
986: (
987: l_api_name,
988: G_PKG_NAME,
989: 'OKC_API.G_RET_STS_UNEXP_ERROR',
990: x_msg_count,
991: x_msg_data,
992: '_PUB'
993: );

Line 996: x_return_status := OKC_API.HANDLE_EXCEPTIONS

992: '_PUB'
993: );
994:
995: WHEN OTHERS THEN
996: x_return_status := OKC_API.HANDLE_EXCEPTIONS
997: (
998: l_api_name,
999: G_PKG_NAME,
1000: 'OTHERS',

Line 1013: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1009: x_return_status OUT NOCOPY VARCHAR2,
1010: x_msg_count OUT NOCOPY NUMBER,
1011: x_msg_data OUT NOCOPY VARCHAR2,
1012: p_aqev_tbl IN aqev_tbl_type) IS
1013: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1014: i NUMBER := 0;
1015: BEGIN
1016: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1017: IF p_aqev_tbl.COUNT > 0 THEN

Line 1016: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1012: p_aqev_tbl IN aqev_tbl_type) IS
1013: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1014: i NUMBER := 0;
1015: BEGIN
1016: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1017: IF p_aqev_tbl.COUNT > 0 THEN
1018: i := p_aqev_tbl.FIRST;
1019: LOOP
1020: validate_err(

Line 1027: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1023: l_return_status,
1024: x_msg_count,
1025: x_msg_data,
1026: p_aqev_tbl(i));
1027: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1028: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1029: x_return_status := l_return_status;
1030: raise G_EXCEPTION_HALT_VALIDATION;
1031: ELSE

Line 1028: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1024: x_msg_count,
1025: x_msg_data,
1026: p_aqev_tbl(i));
1027: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1028: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1029: x_return_status := l_return_status;
1030: raise G_EXCEPTION_HALT_VALIDATION;
1031: ELSE
1032: x_return_status := l_return_status;

Line 1044: OKC_API.set_message(p_app_name => g_app_name,

1040: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1041: NULL;
1042:
1043: WHEN OTHERS THEN
1044: OKC_API.set_message(p_app_name => g_app_name,
1045: p_msg_name => g_unexpected_error,
1046: p_token1 => g_sqlcode_token,
1047: p_token1_value => sqlcode,
1048: p_token2 => g_sqlerrm_token,

Line 1050: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1046: p_token1 => g_sqlcode_token,
1047: p_token1_value => sqlcode,
1048: p_token2 => g_sqlerrm_token,
1049: p_token2_value => sqlerrm);
1050: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1051: END validate_err;
1052:
1053: --Procedures for Messages
1054: PROCEDURE create_msg(p_api_version IN NUMBER,

Line 1064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1060: x_aqmv_rec OUT NOCOPY aqmv_rec_type) IS
1061:
1062: l_api_name CONSTANT VARCHAR2(30) := 'create_msg';
1063: l_api_version CONSTANT NUMBER := 1.0;
1064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1065: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1066: BEGIN
1067: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1068: g_pkg_name,

Line 1067: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1063: l_api_version CONSTANT NUMBER := 1.0;
1064: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1065: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1066: BEGIN
1067: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1068: g_pkg_name,
1069: p_init_msg_list,
1070: l_api_version,
1071: p_api_version,

Line 1075: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1071: p_api_version,
1072: '_PUB',
1073: x_return_status);
1074:
1075: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1078: RAISE OKC_API.G_EXCEPTION_ERROR;
1079: END IF;

Line 1076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1072: '_PUB',
1073: x_return_status);
1074:
1075: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1078: RAISE OKC_API.G_EXCEPTION_ERROR;
1079: END IF;
1080:

Line 1077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1073: x_return_status);
1074:
1075: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1078: RAISE OKC_API.G_EXCEPTION_ERROR;
1079: END IF;
1080:
1081: -- USER HOOK CALL FOR BEFORE, STARTS

Line 1078: RAISE OKC_API.G_EXCEPTION_ERROR;

1074:
1075: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1078: RAISE OKC_API.G_EXCEPTION_ERROR;
1079: END IF;
1080:
1081: -- USER HOOK CALL FOR BEFORE, STARTS
1082: g_aqmv_rec := l_aqmv_rec;

Line 1089: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1085: p_package_name => g_pkg_name,
1086: p_procedure_name => l_api_name,
1087: p_before_after => 'B');
1088:
1089: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;

Line 1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1086: p_procedure_name => l_api_name,
1087: p_before_after => 'B');
1088:
1089: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094:

Line 1091: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1087: p_before_after => 'B');
1088:
1089: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094:
1095: --get values back from hook call

Line 1092: RAISE OKC_API.G_EXCEPTION_ERROR;

1088:
1089: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1091: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1092: RAISE OKC_API.G_EXCEPTION_ERROR;
1093: END IF;
1094:
1095: --get values back from hook call
1096: l_aqmv_rec := migrate_aqmv(l_aqmv_rec, g_aqmv_rec);

Line 1106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1102: x_msg_count => x_msg_count,
1103: x_msg_data => x_msg_data,
1104: p_aqmv_rec => l_aqmv_rec,
1105: x_aqmv_rec => x_aqmv_rec);
1106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;

Line 1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1103: x_msg_data => x_msg_data,
1104: p_aqmv_rec => l_aqmv_rec,
1105: x_aqmv_rec => x_aqmv_rec);
1106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111:

Line 1108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1104: p_aqmv_rec => l_aqmv_rec,
1105: x_aqmv_rec => x_aqmv_rec);
1106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111:
1112: --USER HOOK CALL FOR AFTER, STARTS

Line 1109: RAISE OKC_API.G_EXCEPTION_ERROR;

1105: x_aqmv_rec => x_aqmv_rec);
1106: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1108: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1109: RAISE OKC_API.G_EXCEPTION_ERROR;
1110: END IF;
1111:
1112: --USER HOOK CALL FOR AFTER, STARTS
1113: g_aqmv_rec := x_aqmv_rec;

Line 1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1116: p_package_name => g_pkg_name,
1117: p_procedure_name => l_api_name,
1118: p_before_after => 'A');
1119:
1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;

Line 1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1117: p_procedure_name => l_api_name,
1118: p_before_after => 'A');
1119:
1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125: --USER HOOK CALL FOR AFTER, ENDS

Line 1122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1118: p_before_after => 'A');
1119:
1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125: --USER HOOK CALL FOR AFTER, ENDS
1126:

Line 1123: RAISE OKC_API.G_EXCEPTION_ERROR;

1119:
1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125: --USER HOOK CALL FOR AFTER, ENDS
1126:
1127: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125: --USER HOOK CALL FOR AFTER, ENDS
1126:
1127: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1128:
1129: EXCEPTION
1130: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1131: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1130: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1126:
1127: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1128:
1129: EXCEPTION
1130: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1132: (
1133: l_api_name,
1134: G_PKG_NAME,

Line 1131: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1127: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1128:
1129: EXCEPTION
1130: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1132: (
1133: l_api_name,
1134: G_PKG_NAME,
1135: 'OKC_API.G_RET_STS_ERROR',

Line 1135: 'OKC_API.G_RET_STS_ERROR',

1131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1132: (
1133: l_api_name,
1134: G_PKG_NAME,
1135: 'OKC_API.G_RET_STS_ERROR',
1136: x_msg_count,
1137: x_msg_data,
1138: '_PUB'
1139: );

Line 1141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1137: x_msg_data,
1138: '_PUB'
1139: );
1140:
1141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1143: (
1144: l_api_name,
1145: G_PKG_NAME,

Line 1142: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1138: '_PUB'
1139: );
1140:
1141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1143: (
1144: l_api_name,
1145: G_PKG_NAME,
1146: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1146: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1143: (
1144: l_api_name,
1145: G_PKG_NAME,
1146: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1147: x_msg_count,
1148: x_msg_data,
1149: '_PUB'
1150: );

Line 1153: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1149: '_PUB'
1150: );
1151:
1152: WHEN OTHERS THEN
1153: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1154: (
1155: l_api_name,
1156: G_PKG_NAME,
1157: 'OTHERS',

Line 1171: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1167: x_msg_count OUT NOCOPY NUMBER,
1168: x_msg_data OUT NOCOPY VARCHAR2,
1169: p_aqmv_tbl IN aqmv_tbl_type,
1170: x_aqmv_tbl OUT NOCOPY aqmv_tbl_type) IS
1171: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1172: i NUMBER := 0;
1173: BEGIN
1174: --Initialize the return status
1175: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1175: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1171: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1172: i NUMBER := 0;
1173: BEGIN
1174: --Initialize the return status
1175: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1176:
1177: IF p_aqmv_tbl.COUNT > 0 THEN
1178: i := p_aqmv_tbl.FIRST;
1179: LOOP

Line 1188: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1184: x_msg_count,
1185: x_msg_data,
1186: p_aqmv_tbl(i),
1187: x_aqmv_tbl(i));
1188: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1189: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1190: x_return_status := l_return_status;
1191: raise G_EXCEPTION_HALT_VALIDATION;
1192: ELSE

Line 1189: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1185: x_msg_data,
1186: p_aqmv_tbl(i),
1187: x_aqmv_tbl(i));
1188: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1189: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1190: x_return_status := l_return_status;
1191: raise G_EXCEPTION_HALT_VALIDATION;
1192: ELSE
1193: x_return_status := l_return_status;

Line 1205: OKC_API.set_message(p_app_name => g_app_name,

1201: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1202: NULL;
1203:
1204: WHEN OTHERS THEN
1205: OKC_API.set_message(p_app_name => g_app_name,
1206: p_msg_name => g_unexpected_error,
1207: p_token1 => g_sqlcode_token,
1208: p_token1_value => sqlcode,
1209: p_token2 => g_sqlerrm_token,

Line 1211: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1207: p_token1 => g_sqlcode_token,
1208: p_token1_value => sqlcode,
1209: p_token2 => g_sqlerrm_token,
1210: p_token2_value => sqlerrm);
1211: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1212: END create_msg;
1213:
1214: PROCEDURE lock_msg(p_api_version IN NUMBER,
1215: p_init_msg_list IN VARCHAR2 ,

Line 1222: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1218: x_msg_data OUT NOCOPY VARCHAR2,
1219: p_aqmv_rec IN aqmv_rec_type) IS
1220: l_api_name CONSTANT VARCHAR2(30) := 'lock_msg';
1221: l_api_version CONSTANT NUMBER := 1.0;
1222: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1223: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1224: BEGIN
1225: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1226: g_pkg_name,

Line 1225: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1221: l_api_version CONSTANT NUMBER := 1.0;
1222: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1223: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1224: BEGIN
1225: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1226: g_pkg_name,
1227: p_init_msg_list,
1228: l_api_version,
1229: p_api_version,

Line 1233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1229: p_api_version,
1230: '_PUB',
1231: x_return_status);
1232:
1233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1236: RAISE OKC_API.G_EXCEPTION_ERROR;
1237: END IF;

Line 1234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1230: '_PUB',
1231: x_return_status);
1232:
1233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1236: RAISE OKC_API.G_EXCEPTION_ERROR;
1237: END IF;
1238:

Line 1235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1231: x_return_status);
1232:
1233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1236: RAISE OKC_API.G_EXCEPTION_ERROR;
1237: END IF;
1238:
1239: -- Call to procedure of Simple API

Line 1236: RAISE OKC_API.G_EXCEPTION_ERROR;

1232:
1233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1236: RAISE OKC_API.G_EXCEPTION_ERROR;
1237: END IF;
1238:
1239: -- Call to procedure of Simple API
1240: okc_aqm_pvt.lock_row(p_api_version => p_api_version,

Line 1247: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1243: x_msg_count => x_msg_count,
1244: x_msg_data => x_msg_data,
1245: p_aqmv_rec => l_aqmv_rec);
1246:
1247: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1250: RAISE OKC_API.G_EXCEPTION_ERROR;
1251: END IF;

Line 1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1244: x_msg_data => x_msg_data,
1245: p_aqmv_rec => l_aqmv_rec);
1246:
1247: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1250: RAISE OKC_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:

Line 1249: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1245: p_aqmv_rec => l_aqmv_rec);
1246:
1247: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1250: RAISE OKC_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:
1253: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1250: RAISE OKC_API.G_EXCEPTION_ERROR;

1246:
1247: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1248: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1249: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1250: RAISE OKC_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:
1253: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1254:

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

1249: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1250: RAISE OKC_API.G_EXCEPTION_ERROR;
1251: END IF;
1252:
1253: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1254:
1255: EXCEPTION
1256: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1257: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1256: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1252:
1253: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1254:
1255: EXCEPTION
1256: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1257: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1258: (
1259: l_api_name,
1260: G_PKG_NAME,

Line 1257: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1253: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1254:
1255: EXCEPTION
1256: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1257: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1258: (
1259: l_api_name,
1260: G_PKG_NAME,
1261: 'OKC_API.G_RET_STS_ERROR',

Line 1261: 'OKC_API.G_RET_STS_ERROR',

1257: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1258: (
1259: l_api_name,
1260: G_PKG_NAME,
1261: 'OKC_API.G_RET_STS_ERROR',
1262: x_msg_count,
1263: x_msg_data,
1264: '_PUB'
1265: );

Line 1267: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1263: x_msg_data,
1264: '_PUB'
1265: );
1266:
1267: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1268: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1269: (
1270: l_api_name,
1271: G_PKG_NAME,

Line 1268: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1264: '_PUB'
1265: );
1266:
1267: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1268: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1269: (
1270: l_api_name,
1271: G_PKG_NAME,
1272: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1272: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1268: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1269: (
1270: l_api_name,
1271: G_PKG_NAME,
1272: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1273: x_msg_count,
1274: x_msg_data,
1275: '_PUB'
1276: );

Line 1279: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1275: '_PUB'
1276: );
1277:
1278: WHEN OTHERS THEN
1279: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1280: (
1281: l_api_name,
1282: G_PKG_NAME,
1283: 'OTHERS',

Line 1296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1292: x_return_status OUT NOCOPY VARCHAR2,
1293: x_msg_count OUT NOCOPY NUMBER,
1294: x_msg_data OUT NOCOPY VARCHAR2,
1295: p_aqmv_tbl IN aqmv_tbl_type) IS
1296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1297: i NUMBER := 0;
1298: BEGIN
1299: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1300: IF p_aqmv_tbl.COUNT > 0 THEN

Line 1299: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1295: p_aqmv_tbl IN aqmv_tbl_type) IS
1296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1297: i NUMBER := 0;
1298: BEGIN
1299: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1300: IF p_aqmv_tbl.COUNT > 0 THEN
1301: i := p_aqmv_tbl.FIRST;
1302: LOOP
1303: lock_msg(

Line 1310: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1306: l_return_status,
1307: x_msg_count,
1308: x_msg_data,
1309: p_aqmv_tbl(i));
1310: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1312: x_return_status := l_return_status;
1313: raise G_EXCEPTION_HALT_VALIDATION;
1314: ELSE

Line 1311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1307: x_msg_count,
1308: x_msg_data,
1309: p_aqmv_tbl(i));
1310: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1311: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1312: x_return_status := l_return_status;
1313: raise G_EXCEPTION_HALT_VALIDATION;
1314: ELSE
1315: x_return_status := l_return_status;

Line 1327: OKC_API.set_message(p_app_name => g_app_name,

1323: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1324: NULL;
1325:
1326: WHEN OTHERS THEN
1327: OKC_API.set_message(p_app_name => g_app_name,
1328: p_msg_name => g_unexpected_error,
1329: p_token1 => g_sqlcode_token,
1330: p_token1_value => sqlcode,
1331: p_token2 => g_sqlerrm_token,

Line 1333: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1329: p_token1 => g_sqlcode_token,
1330: p_token1_value => sqlcode,
1331: p_token2 => g_sqlerrm_token,
1332: p_token2_value => sqlerrm);
1333: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1334: End lock_msg;
1335:
1336: PROCEDURE update_msg(p_api_version IN NUMBER,
1337: p_init_msg_list IN VARCHAR2 ,

Line 1346: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1342: x_aqmv_rec OUT NOCOPY aqmv_rec_type) IS
1343:
1344: l_api_name CONSTANT VARCHAR2(30) := 'update_msg';
1345: l_api_version CONSTANT NUMBER := 1.0;
1346: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1347: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1348: BEGIN
1349: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1350: g_pkg_name,

Line 1349: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1345: l_api_version CONSTANT NUMBER := 1.0;
1346: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1347: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1348: BEGIN
1349: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1350: g_pkg_name,
1351: p_init_msg_list,
1352: l_api_version,
1353: p_api_version,

Line 1356: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1352: l_api_version,
1353: p_api_version,
1354: '_PUB',
1355: x_return_status);
1356: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1358: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_ERROR;
1360: END IF;

Line 1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1353: p_api_version,
1354: '_PUB',
1355: x_return_status);
1356: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1358: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_ERROR;
1360: END IF;
1361:

Line 1358: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1354: '_PUB',
1355: x_return_status);
1356: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1358: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_ERROR;
1360: END IF;
1361:
1362: -- USER HOOK CALL FOR BEFORE, STARTS

Line 1359: RAISE OKC_API.G_EXCEPTION_ERROR;

1355: x_return_status);
1356: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1358: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_ERROR;
1360: END IF;
1361:
1362: -- USER HOOK CALL FOR BEFORE, STARTS
1363: g_aqmv_rec := l_aqmv_rec;

Line 1369: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1365: okc_util.call_user_hook(x_return_status => x_return_status,
1366: p_package_name => g_pkg_name,
1367: p_procedure_name => l_api_name,
1368: p_before_after => 'B');
1369: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;

Line 1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1366: p_package_name => g_pkg_name,
1367: p_procedure_name => l_api_name,
1368: p_before_after => 'B');
1369: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:

Line 1371: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1367: p_procedure_name => l_api_name,
1368: p_before_after => 'B');
1369: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:
1375: --get values back from hook call

Line 1372: RAISE OKC_API.G_EXCEPTION_ERROR;

1368: p_before_after => 'B');
1369: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:
1375: --get values back from hook call
1376: l_aqmv_rec := migrate_aqmv(l_aqmv_rec, g_aqmv_rec);

Line 1387: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1383: x_msg_data => x_msg_data,
1384: p_aqmv_rec => l_aqmv_rec,
1385: x_aqmv_rec => x_aqmv_rec);
1386:
1387: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1389: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1390: RAISE OKC_API.G_EXCEPTION_ERROR;
1391: END IF;

Line 1388: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1384: p_aqmv_rec => l_aqmv_rec,
1385: x_aqmv_rec => x_aqmv_rec);
1386:
1387: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1389: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1390: RAISE OKC_API.G_EXCEPTION_ERROR;
1391: END IF;
1392:

Line 1389: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1385: x_aqmv_rec => x_aqmv_rec);
1386:
1387: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1389: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1390: RAISE OKC_API.G_EXCEPTION_ERROR;
1391: END IF;
1392:
1393: --USER HOOK CALL FOR AFTER, STARTS

Line 1390: RAISE OKC_API.G_EXCEPTION_ERROR;

1386:
1387: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1389: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1390: RAISE OKC_API.G_EXCEPTION_ERROR;
1391: END IF;
1392:
1393: --USER HOOK CALL FOR AFTER, STARTS
1394: g_aqmv_rec := x_aqmv_rec;

Line 1400: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1396: okc_util.call_user_hook(x_return_status => x_return_status,
1397: p_package_name => g_pkg_name,
1398: p_procedure_name => l_api_name,
1399: p_before_after => 'A');
1400: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1402: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: END IF;

Line 1401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1397: p_package_name => g_pkg_name,
1398: p_procedure_name => l_api_name,
1399: p_before_after => 'A');
1400: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1402: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: END IF;
1405: --USER HOOK CALL FOR AFTER, ENDS

Line 1402: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1398: p_procedure_name => l_api_name,
1399: p_before_after => 'A');
1400: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1402: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: END IF;
1405: --USER HOOK CALL FOR AFTER, ENDS
1406:

Line 1403: RAISE OKC_API.G_EXCEPTION_ERROR;

1399: p_before_after => 'A');
1400: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1402: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: END IF;
1405: --USER HOOK CALL FOR AFTER, ENDS
1406:
1407: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: END IF;
1405: --USER HOOK CALL FOR AFTER, ENDS
1406:
1407: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1408:
1409: EXCEPTION
1410: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1410: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1406:
1407: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1408:
1409: EXCEPTION
1410: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1412: (
1413: l_api_name,
1414: G_PKG_NAME,

Line 1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1407: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1408:
1409: EXCEPTION
1410: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1412: (
1413: l_api_name,
1414: G_PKG_NAME,
1415: 'OKC_API.G_RET_STS_ERROR',

Line 1415: 'OKC_API.G_RET_STS_ERROR',

1411: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1412: (
1413: l_api_name,
1414: G_PKG_NAME,
1415: 'OKC_API.G_RET_STS_ERROR',
1416: x_msg_count,
1417: x_msg_data,
1418: '_PUB'
1419: );

Line 1421: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1417: x_msg_data,
1418: '_PUB'
1419: );
1420:
1421: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1422: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1423: (
1424: l_api_name,
1425: G_PKG_NAME,

Line 1422: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1418: '_PUB'
1419: );
1420:
1421: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1422: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1423: (
1424: l_api_name,
1425: G_PKG_NAME,
1426: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1426: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1422: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1423: (
1424: l_api_name,
1425: G_PKG_NAME,
1426: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1427: x_msg_count,
1428: x_msg_data,
1429: '_PUB'
1430: );

Line 1433: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1429: '_PUB'
1430: );
1431:
1432: WHEN OTHERS THEN
1433: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1434: (
1435: l_api_name,
1436: G_PKG_NAME,
1437: 'OTHERS',

Line 1452: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1448: x_msg_data OUT NOCOPY VARCHAR2,
1449: p_aqmv_tbl IN aqmv_tbl_type,
1450: x_aqmv_tbl OUT NOCOPY aqmv_tbl_type) IS
1451:
1452: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1453: i NUMBER := 0;
1454: BEGIN
1455: --Initialize the return status
1456: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1456: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1452: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1453: i NUMBER := 0;
1454: BEGIN
1455: --Initialize the return status
1456: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1457:
1458: IF p_aqmv_tbl.COUNT > 0 THEN
1459: i := p_aqmv_tbl.FIRST;
1460: LOOP

Line 1469: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1465: x_msg_count,
1466: x_msg_data,
1467: p_aqmv_tbl(i),
1468: x_aqmv_tbl(i));
1469: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1470: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1471: x_return_status := l_return_status;
1472: raise G_EXCEPTION_HALT_VALIDATION;
1473: ELSE

Line 1470: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1466: x_msg_data,
1467: p_aqmv_tbl(i),
1468: x_aqmv_tbl(i));
1469: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1470: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1471: x_return_status := l_return_status;
1472: raise G_EXCEPTION_HALT_VALIDATION;
1473: ELSE
1474: x_return_status := l_return_status;

Line 1486: OKC_API.set_message(p_app_name => g_app_name,

1482: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1483: NULL;
1484:
1485: WHEN OTHERS THEN
1486: OKC_API.set_message(p_app_name => g_app_name,
1487: p_msg_name => g_unexpected_error,
1488: p_token1 => g_sqlcode_token,
1489: p_token1_value => sqlcode,
1490: p_token2 => g_sqlerrm_token,

Line 1492: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1488: p_token1 => g_sqlcode_token,
1489: p_token1_value => sqlcode,
1490: p_token2 => g_sqlerrm_token,
1491: p_token2_value => sqlerrm);
1492: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1493: END update_msg;
1494:
1495: PROCEDURE delete_msg(p_api_version IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 ,

Line 1504: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1500: p_aqmv_rec IN aqmv_rec_type) IS
1501:
1502: l_api_name CONSTANT VARCHAR2(30) := 'delete_msg';
1503: l_api_version CONSTANT NUMBER := 1.0;
1504: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1505: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1506: BEGIN
1507: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1508: g_pkg_name,

Line 1507: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1503: l_api_version CONSTANT NUMBER := 1.0;
1504: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1505: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1506: BEGIN
1507: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1508: g_pkg_name,
1509: p_init_msg_list,
1510: l_api_version,
1511: p_api_version,

Line 1515: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1511: p_api_version,
1512: '_PUB',
1513: x_return_status);
1514:
1515: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1516: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1517: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_ERROR;
1519: END IF;

Line 1516: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1512: '_PUB',
1513: x_return_status);
1514:
1515: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1516: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1517: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_ERROR;
1519: END IF;
1520:

Line 1517: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1513: x_return_status);
1514:
1515: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1516: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1517: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_ERROR;
1519: END IF;
1520:
1521: -- USER HOOK CALL FOR BEFORE, STARTS

Line 1518: RAISE OKC_API.G_EXCEPTION_ERROR;

1514:
1515: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1516: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1517: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1518: RAISE OKC_API.G_EXCEPTION_ERROR;
1519: END IF;
1520:
1521: -- USER HOOK CALL FOR BEFORE, STARTS
1522: g_aqmv_rec := l_aqmv_rec;

Line 1528: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1524: okc_util.call_user_hook(x_return_status => x_return_status,
1525: p_package_name => g_pkg_name,
1526: p_procedure_name => l_api_name,
1527: p_before_after => 'B');
1528: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1529: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1530: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1531: RAISE OKC_API.G_EXCEPTION_ERROR;
1532: END IF;

Line 1529: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1525: p_package_name => g_pkg_name,
1526: p_procedure_name => l_api_name,
1527: p_before_after => 'B');
1528: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1529: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1530: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1531: RAISE OKC_API.G_EXCEPTION_ERROR;
1532: END IF;
1533:

Line 1530: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1526: p_procedure_name => l_api_name,
1527: p_before_after => 'B');
1528: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1529: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1530: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1531: RAISE OKC_API.G_EXCEPTION_ERROR;
1532: END IF;
1533:
1534: --get values back from hook call

Line 1531: RAISE OKC_API.G_EXCEPTION_ERROR;

1527: p_before_after => 'B');
1528: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1529: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1530: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1531: RAISE OKC_API.G_EXCEPTION_ERROR;
1532: END IF;
1533:
1534: --get values back from hook call
1535: l_aqmv_rec := migrate_aqmv(l_aqmv_rec, g_aqmv_rec);

Line 1544: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1540: x_return_status => x_return_status,
1541: x_msg_count => x_msg_count,
1542: x_msg_data => x_msg_data,
1543: p_aqmv_rec => l_aqmv_rec);
1544: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1546: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1547: RAISE OKC_API.G_EXCEPTION_ERROR;
1548: END IF;

Line 1545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1541: x_msg_count => x_msg_count,
1542: x_msg_data => x_msg_data,
1543: p_aqmv_rec => l_aqmv_rec);
1544: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1546: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1547: RAISE OKC_API.G_EXCEPTION_ERROR;
1548: END IF;
1549:

Line 1546: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1542: x_msg_data => x_msg_data,
1543: p_aqmv_rec => l_aqmv_rec);
1544: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1546: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1547: RAISE OKC_API.G_EXCEPTION_ERROR;
1548: END IF;
1549:
1550: --USER HOOK CALL FOR AFTER, STARTS

Line 1547: RAISE OKC_API.G_EXCEPTION_ERROR;

1543: p_aqmv_rec => l_aqmv_rec);
1544: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1545: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1546: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1547: RAISE OKC_API.G_EXCEPTION_ERROR;
1548: END IF;
1549:
1550: --USER HOOK CALL FOR AFTER, STARTS
1551: okc_util.call_user_hook(x_return_status => x_return_status,

Line 1556: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1552: p_package_name => g_pkg_name,
1553: p_procedure_name => l_api_name,
1554: p_before_after => 'A');
1555:
1556: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1557: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1558: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1559: RAISE OKC_API.G_EXCEPTION_ERROR;
1560: END IF;

Line 1557: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1553: p_procedure_name => l_api_name,
1554: p_before_after => 'A');
1555:
1556: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1557: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1558: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1559: RAISE OKC_API.G_EXCEPTION_ERROR;
1560: END IF;
1561: --USER HOOK CALL FOR AFTER, ENDS

Line 1558: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1554: p_before_after => 'A');
1555:
1556: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1557: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1558: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1559: RAISE OKC_API.G_EXCEPTION_ERROR;
1560: END IF;
1561: --USER HOOK CALL FOR AFTER, ENDS
1562:

Line 1559: RAISE OKC_API.G_EXCEPTION_ERROR;

1555:
1556: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1557: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1558: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1559: RAISE OKC_API.G_EXCEPTION_ERROR;
1560: END IF;
1561: --USER HOOK CALL FOR AFTER, ENDS
1562:
1563: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1559: RAISE OKC_API.G_EXCEPTION_ERROR;
1560: END IF;
1561: --USER HOOK CALL FOR AFTER, ENDS
1562:
1563: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1564: EXCEPTION
1565: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1566: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1567: (

Line 1565: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1561: --USER HOOK CALL FOR AFTER, ENDS
1562:
1563: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1564: EXCEPTION
1565: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1566: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1567: (
1568: l_api_name,
1569: G_PKG_NAME,

Line 1566: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1562:
1563: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1564: EXCEPTION
1565: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1566: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1567: (
1568: l_api_name,
1569: G_PKG_NAME,
1570: 'OKC_API.G_RET_STS_ERROR',

Line 1570: 'OKC_API.G_RET_STS_ERROR',

1566: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1567: (
1568: l_api_name,
1569: G_PKG_NAME,
1570: 'OKC_API.G_RET_STS_ERROR',
1571: x_msg_count,
1572: x_msg_data,
1573: '_PUB'
1574: );

Line 1576: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1572: x_msg_data,
1573: '_PUB'
1574: );
1575:
1576: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1577: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,

Line 1577: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1573: '_PUB'
1574: );
1575:
1576: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1577: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,
1581: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1581: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1577: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,
1581: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1582: x_msg_count,
1583: x_msg_data,
1584: '_PUB'
1585: );

Line 1588: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1584: '_PUB'
1585: );
1586:
1587: WHEN OTHERS THEN
1588: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1589: (
1590: l_api_name,
1591: G_PKG_NAME,
1592: 'OTHERS',

Line 1606: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1602: x_msg_count OUT NOCOPY NUMBER,
1603: x_msg_data OUT NOCOPY VARCHAR2,
1604: p_aqmv_tbl IN aqmv_tbl_type) IS
1605:
1606: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1607: i NUMBER := 0;
1608: BEGIN
1609: --Initialize the return status
1610: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1610: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1606: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1607: i NUMBER := 0;
1608: BEGIN
1609: --Initialize the return status
1610: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1611:
1612: IF p_aqmv_tbl.COUNT > 0 THEN
1613: i := p_aqmv_tbl.FIRST;
1614: LOOP

Line 1622: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1618: x_return_status,
1619: x_msg_count,
1620: x_msg_data,
1621: p_aqmv_tbl(i));
1622: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1623: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
1624: l_return_status := x_return_status;
1625: RAISE G_EXCEPTION_HALT_VALIDATION;
1626: ELSE

Line 1623: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

1619: x_msg_count,
1620: x_msg_data,
1621: p_aqmv_tbl(i));
1622: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1623: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
1624: l_return_status := x_return_status;
1625: RAISE G_EXCEPTION_HALT_VALIDATION;
1626: ELSE
1627: l_return_status := x_return_status; -- record that there was an error

Line 1639: OKC_API.set_message(p_app_name => g_app_name,

1635: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1636: NULL;
1637:
1638: WHEN OTHERS THEN
1639: OKC_API.set_message(p_app_name => g_app_name,
1640: p_msg_name => g_unexpected_error,
1641: p_token1 => g_sqlcode_token,
1642: p_token1_value => sqlcode,
1643: p_token2 => g_sqlerrm_token,

Line 1645: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1641: p_token1 => g_sqlcode_token,
1642: p_token1_value => sqlcode,
1643: p_token2 => g_sqlerrm_token,
1644: p_token2_value => sqlerrm);
1645: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1646: END delete_msg;
1647:
1648: PROCEDURE validate_msg(p_api_version IN NUMBER,
1649: p_init_msg_list IN VARCHAR2 ,

Line 1657: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1653: p_aqmv_rec IN aqmv_rec_type) IS
1654:
1655: l_api_name CONSTANT VARCHAR2(30) := 'validate_msg';
1656: l_api_version CONSTANT NUMBER := 1.0;
1657: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1658: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1659: BEGIN
1660: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1661: g_pkg_name,

Line 1660: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1656: l_api_version CONSTANT NUMBER := 1.0;
1657: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1658: l_aqmv_rec aqmv_rec_type := p_aqmv_rec;
1659: BEGIN
1660: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1661: g_pkg_name,
1662: p_init_msg_list,
1663: l_api_version,
1664: p_api_version,

Line 1668: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1664: p_api_version,
1665: '_PUB',
1666: x_return_status);
1667:
1668: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1670: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1671: RAISE OKC_API.G_EXCEPTION_ERROR;
1672: END IF;

Line 1669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1665: '_PUB',
1666: x_return_status);
1667:
1668: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1670: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1671: RAISE OKC_API.G_EXCEPTION_ERROR;
1672: END IF;
1673:

Line 1670: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1666: x_return_status);
1667:
1668: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1670: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1671: RAISE OKC_API.G_EXCEPTION_ERROR;
1672: END IF;
1673:
1674: -- USER HOOK CALL FOR BEFORE, STARTS

Line 1671: RAISE OKC_API.G_EXCEPTION_ERROR;

1667:
1668: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1670: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1671: RAISE OKC_API.G_EXCEPTION_ERROR;
1672: END IF;
1673:
1674: -- USER HOOK CALL FOR BEFORE, STARTS
1675: g_aqmv_rec := l_aqmv_rec;

Line 1681: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1677: okc_util.call_user_hook(x_return_status => x_return_status,
1678: p_package_name => g_pkg_name,
1679: p_procedure_name => l_api_name,
1680: p_before_after => 'B');
1681: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1682: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1683: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1684: RAISE OKC_API.G_EXCEPTION_ERROR;
1685: END IF;

Line 1682: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1678: p_package_name => g_pkg_name,
1679: p_procedure_name => l_api_name,
1680: p_before_after => 'B');
1681: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1682: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1683: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1684: RAISE OKC_API.G_EXCEPTION_ERROR;
1685: END IF;
1686:

Line 1683: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1679: p_procedure_name => l_api_name,
1680: p_before_after => 'B');
1681: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1682: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1683: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1684: RAISE OKC_API.G_EXCEPTION_ERROR;
1685: END IF;
1686:
1687: --get values back from hook call

Line 1684: RAISE OKC_API.G_EXCEPTION_ERROR;

1680: p_before_after => 'B');
1681: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1682: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1683: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1684: RAISE OKC_API.G_EXCEPTION_ERROR;
1685: END IF;
1686:
1687: --get values back from hook call
1688: l_aqmv_rec := migrate_aqmv(l_aqmv_rec, g_aqmv_rec);

Line 1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1694: x_msg_count => x_msg_count,
1695: x_msg_data => x_msg_data,
1696: p_aqmv_rec => l_aqmv_rec);
1697:
1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1701: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: END IF;

Line 1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1695: x_msg_data => x_msg_data,
1696: p_aqmv_rec => l_aqmv_rec);
1697:
1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1701: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: END IF;
1703:

Line 1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1696: p_aqmv_rec => l_aqmv_rec);
1697:
1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1701: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: END IF;
1703:
1704: --USER HOOK CALL FOR AFTER, STARTS

Line 1701: RAISE OKC_API.G_EXCEPTION_ERROR;

1697:
1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1701: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: END IF;
1703:
1704: --USER HOOK CALL FOR AFTER, STARTS
1705: okc_util.call_user_hook(x_return_status => x_return_status,

Line 1709: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1705: okc_util.call_user_hook(x_return_status => x_return_status,
1706: p_package_name => g_pkg_name,
1707: p_procedure_name => l_api_name,
1708: p_before_after => 'A');
1709: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1710: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1711: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1712: RAISE OKC_API.G_EXCEPTION_ERROR;
1713: END IF;

Line 1710: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1706: p_package_name => g_pkg_name,
1707: p_procedure_name => l_api_name,
1708: p_before_after => 'A');
1709: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1710: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1711: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1712: RAISE OKC_API.G_EXCEPTION_ERROR;
1713: END IF;
1714: --USER HOOK CALL FOR AFTER, ENDS

Line 1711: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1707: p_procedure_name => l_api_name,
1708: p_before_after => 'A');
1709: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1710: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1711: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1712: RAISE OKC_API.G_EXCEPTION_ERROR;
1713: END IF;
1714: --USER HOOK CALL FOR AFTER, ENDS
1715:

Line 1712: RAISE OKC_API.G_EXCEPTION_ERROR;

1708: p_before_after => 'A');
1709: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1710: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1711: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1712: RAISE OKC_API.G_EXCEPTION_ERROR;
1713: END IF;
1714: --USER HOOK CALL FOR AFTER, ENDS
1715:
1716: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1712: RAISE OKC_API.G_EXCEPTION_ERROR;
1713: END IF;
1714: --USER HOOK CALL FOR AFTER, ENDS
1715:
1716: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1717:
1718: EXCEPTION
1719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1720: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1719: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1715:
1716: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1717:
1718: EXCEPTION
1719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1721: (
1722: l_api_name,
1723: G_PKG_NAME,

Line 1720: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1716: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1717:
1718: EXCEPTION
1719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1721: (
1722: l_api_name,
1723: G_PKG_NAME,
1724: 'OKC_API.G_RET_STS_ERROR',

Line 1724: 'OKC_API.G_RET_STS_ERROR',

1720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1721: (
1722: l_api_name,
1723: G_PKG_NAME,
1724: 'OKC_API.G_RET_STS_ERROR',
1725: x_msg_count,
1726: x_msg_data,
1727: '_PUB'
1728: );

Line 1730: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1726: x_msg_data,
1727: '_PUB'
1728: );
1729:
1730: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1731: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1732: (
1733: l_api_name,
1734: G_PKG_NAME,

Line 1731: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1727: '_PUB'
1728: );
1729:
1730: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1731: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1732: (
1733: l_api_name,
1734: G_PKG_NAME,
1735: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1735: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1731: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1732: (
1733: l_api_name,
1734: G_PKG_NAME,
1735: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1736: x_msg_count,
1737: x_msg_data,
1738: '_PUB'
1739: );

Line 1742: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1738: '_PUB'
1739: );
1740:
1741: WHEN OTHERS THEN
1742: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1743: (
1744: l_api_name,
1745: G_PKG_NAME,
1746: 'OTHERS',

Line 1760: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1756: x_msg_count OUT NOCOPY NUMBER,
1757: x_msg_data OUT NOCOPY VARCHAR2,
1758: p_aqmv_tbl IN aqmv_tbl_type) IS
1759:
1760: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1761: i NUMBER := 0;
1762: BEGIN
1763: --Initialize the return status
1764: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1764: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1760: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1761: i NUMBER := 0;
1762: BEGIN
1763: --Initialize the return status
1764: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1765:
1766: IF p_aqmv_tbl.COUNT > 0 THEN
1767: i := p_aqmv_tbl.FIRST;
1768: LOOP

Line 1776: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1772: l_return_status,
1773: x_msg_count,
1774: x_msg_data,
1775: p_aqmv_tbl(i));
1776: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1777: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1778: x_return_status := l_return_status;
1779: raise G_EXCEPTION_HALT_VALIDATION;
1780: ELSE

Line 1777: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1773: x_msg_count,
1774: x_msg_data,
1775: p_aqmv_tbl(i));
1776: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1777: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1778: x_return_status := l_return_status;
1779: raise G_EXCEPTION_HALT_VALIDATION;
1780: ELSE
1781: x_return_status := l_return_status;

Line 1793: OKC_API.set_message(p_app_name => g_app_name,

1789: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1790: NULL;
1791:
1792: WHEN OTHERS THEN
1793: OKC_API.set_message(p_app_name => g_app_name,
1794: p_msg_name => g_unexpected_error,
1795: p_token1 => g_sqlcode_token,
1796: p_token1_value => sqlcode,
1797: p_token2 => g_sqlerrm_token,

Line 1799: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1795: p_token1 => g_sqlcode_token,
1796: p_token1_value => sqlcode,
1797: p_token2 => g_sqlerrm_token,
1798: p_token2_value => sqlerrm);
1799: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1800: END validate_msg;
1801:
1802: END okc_aqerrmsg_pub;