eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_SUBSCRIPTION_SCH_PVT dependencies on OKC_API

Line 105: x_return_status := OKC_API.G_RET_STS_SUCCESS;

101: l_ind number;
102:
103: BEGIN
104:
105: x_return_status := OKC_API.G_RET_STS_SUCCESS;
106:
107: If p_start_dt > p_end_dt THEN
108: RETURN;
109: END IF;

Line 151: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

147: p_type => 'YR',
148: x_var_num_tbl => l_yr_tbl,
149: x_return_status => x_return_status);
150:
151: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
152: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'YEAR PATTERN NOT BUILD.');
153: RAISE G_EXCEPTION_HALT_VALIDATION;
154: END IF;
155: -----errorout_ad('l_yr_tbl count = ' || l_yr_tbl.count);

Line 152: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'YEAR PATTERN NOT BUILD.');

148: x_var_num_tbl => l_yr_tbl,
149: x_return_status => x_return_status);
150:
151: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
152: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'YEAR PATTERN NOT BUILD.');
153: RAISE G_EXCEPTION_HALT_VALIDATION;
154: END IF;
155: -----errorout_ad('l_yr_tbl count = ' || l_yr_tbl.count);
156:

Line 168: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

164: p_yr_pattern_tbl => l_yr_tbl,
165: x_rec_tbl => l_rec_tbl,
166: x_return_status => x_return_status);
167:
168: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
169: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'YEARLY SCHEDULE NOT BUILD.');
170: RAISE G_EXCEPTION_HALT_VALIDATION;
171: END IF;
172:

Line 169: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'YEARLY SCHEDULE NOT BUILD.');

165: x_rec_tbl => l_rec_tbl,
166: x_return_status => x_return_status);
167:
168: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
169: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'YEARLY SCHEDULE NOT BUILD.');
170: RAISE G_EXCEPTION_HALT_VALIDATION;
171: END IF;
172:
173: ELSE ---p_freq <> 'Y'

Line 182: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

178: x_var_num_tbl => l_mth_tbl,
179: x_return_status => x_return_status);
180:
181:
182: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
183: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'MONTH PATTERN NOT BUILD.');
184: RAISE G_EXCEPTION_HALT_VALIDATION;
185: END IF;
186: -----errorout_ad('l_mth_tbl count = ' || l_mth_tbl.count);

Line 183: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'MONTH PATTERN NOT BUILD.');

179: x_return_status => x_return_status);
180:
181:
182: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
183: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'MONTH PATTERN NOT BUILD.');
184: RAISE G_EXCEPTION_HALT_VALIDATION;
185: END IF;
186: -----errorout_ad('l_mth_tbl count = ' || l_mth_tbl.count);
187:

Line 200: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

196: p_yr_pattern_tbl => l_yr_tbl,
197: x_rec_tbl => l_rec_tbl,
198: x_return_status => x_return_status);
199:
200: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
201: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'MONTHLY SCHEDULE NOT BUILD.');
202: RAISE G_EXCEPTION_HALT_VALIDATION;
203: END IF;
204:

Line 201: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'MONTHLY SCHEDULE NOT BUILD.');

197: x_rec_tbl => l_rec_tbl,
198: x_return_status => x_return_status);
199:
200: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
201: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'MONTHLY SCHEDULE NOT BUILD.');
202: RAISE G_EXCEPTION_HALT_VALIDATION;
203: END IF;
204:
205: ELSIF p_freq = 'W' THEN

Line 213: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

209: p_type => 'WK',
210: x_var_num_tbl => l_wk_tbl,
211: x_return_status => x_return_status);
212:
213: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
214: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEKLY PATTERN NOT BUILD.');
215: RAISE G_EXCEPTION_HALT_VALIDATION;
216: END IF;
217:

Line 214: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEKLY PATTERN NOT BUILD.');

210: x_var_num_tbl => l_wk_tbl,
211: x_return_status => x_return_status);
212:
213: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
214: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEKLY PATTERN NOT BUILD.');
215: RAISE G_EXCEPTION_HALT_VALIDATION;
216: END IF;
217:
218: Create_Weekly_tbl(

Line 229: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

225: p_wk_pattern_tbl => l_wk_tbl,
226: x_rec_tbl => l_rec_tbl,
227: x_return_status => x_return_status);
228:
229: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
230: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEKLY SCHEDULE NOT BUILD.');
231: RAISE G_EXCEPTION_HALT_VALIDATION;
232: END IF;
233:

Line 230: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEKLY SCHEDULE NOT BUILD.');

226: x_rec_tbl => l_rec_tbl,
227: x_return_status => x_return_status);
228:
229: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
230: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEKLY SCHEDULE NOT BUILD.');
231: RAISE G_EXCEPTION_HALT_VALIDATION;
232: END IF;
233:
234: ELSIF p_freq = 'D' THEN

Line 243: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

239: p_type => 'DY',
240: x_var_num_tbl => l_dy_tbl,
241: x_return_status => x_return_status);
242:
243: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
244: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DAILY PATTERN NOT BUILD.');
245: RAISE G_EXCEPTION_HALT_VALIDATION;
246: END IF;
247:

Line 244: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DAILY PATTERN NOT BUILD.');

240: x_var_num_tbl => l_dy_tbl,
241: x_return_status => x_return_status);
242:
243: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
244: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DAILY PATTERN NOT BUILD.');
245: RAISE G_EXCEPTION_HALT_VALIDATION;
246: END IF;
247:
248: Create_day_tbl(

Line 259: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

255: p_day_pattern_tbl => l_dy_tbl,
256: x_rec_tbl => l_rec_tbl,
257: x_return_status => x_return_status);
258:
259: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
260: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DAILY SCHEDULE NOT BUILD.');
261: RAISE G_EXCEPTION_HALT_VALIDATION;
262: END IF;
263:

Line 260: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DAILY SCHEDULE NOT BUILD.');

256: x_rec_tbl => l_rec_tbl,
257: x_return_status => x_return_status);
258:
259: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
260: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'DAILY SCHEDULE NOT BUILD.');
261: RAISE G_EXCEPTION_HALT_VALIDATION;
262: END IF;
263:
264: ELSE ---day pattern is null

Line 271: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

267: p_type => 'WK',
268: x_var_num_tbl => l_wk_tbl,
269: x_return_status => x_return_status);
270:
271: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
272: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEKLY PATTERN NOT BUILD.');
273: RAISE G_EXCEPTION_HALT_VALIDATION;
274: END IF;
275:

Line 272: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEKLY PATTERN NOT BUILD.');

268: x_var_num_tbl => l_wk_tbl,
269: x_return_status => x_return_status);
270:
271: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
272: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEKLY PATTERN NOT BUILD.');
273: RAISE G_EXCEPTION_HALT_VALIDATION;
274: END IF;
275:
276:

Line 283: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

279: p_type => 'WDY',
280: x_var_num_tbl => l_wdy_tbl,
281: x_return_status => x_return_status);
282:
283: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
284: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEK DAY PATTERN NOT BUILD.');
285: RAISE G_EXCEPTION_HALT_VALIDATION;
286: END IF;
287:

Line 284: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEK DAY PATTERN NOT BUILD.');

280: x_var_num_tbl => l_wdy_tbl,
281: x_return_status => x_return_status);
282:
283: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
284: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEK DAY PATTERN NOT BUILD.');
285: RAISE G_EXCEPTION_HALT_VALIDATION;
286: END IF;
287:
288:

Line 301: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

297: p_wd_pattern_tbl => l_wdy_tbl,
298: x_rec_tbl => l_rec_tbl,
299: x_return_status => x_return_status);
300:
301: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
302: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEK DAY SCHEDULE NOT BUILD.');
303: RAISE G_EXCEPTION_HALT_VALIDATION;
304: END IF;
305:

Line 302: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEK DAY SCHEDULE NOT BUILD.');

298: x_rec_tbl => l_rec_tbl,
299: x_return_status => x_return_status);
300:
301: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
302: OKC_API.set_message(G_PKG_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'WEEK DAY SCHEDULE NOT BUILD.');
303: RAISE G_EXCEPTION_HALT_VALIDATION;
304: END IF;
305:
306: END IF; --end of day_pattern IS NOT NULL

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

341:
342:
343: EXCEPTION
344: WHEN G_EXCEPTION_HALT_VALIDATION THEN
345: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
348: RAISE OKC_API.G_EXCEPTION_ERROR;
349: END IF;

Line 346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

342:
343: EXCEPTION
344: WHEN G_EXCEPTION_HALT_VALIDATION THEN
345: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
348: RAISE OKC_API.G_EXCEPTION_ERROR;
349: END IF;
350: WHEN OTHERS THEN

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

343: EXCEPTION
344: WHEN G_EXCEPTION_HALT_VALIDATION THEN
345: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
348: RAISE OKC_API.G_EXCEPTION_ERROR;
349: END IF;
350: WHEN OTHERS THEN
351: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 348: RAISE OKC_API.G_EXCEPTION_ERROR;

344: WHEN G_EXCEPTION_HALT_VALIDATION THEN
345: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
348: RAISE OKC_API.G_EXCEPTION_ERROR;
349: END IF;
350: WHEN OTHERS THEN
351: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
352: p_msg_name => G_UNEXPECTED_ERROR,

Line 351: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

347: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
348: RAISE OKC_API.G_EXCEPTION_ERROR;
349: END IF;
350: WHEN OTHERS THEN
351: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
352: p_msg_name => G_UNEXPECTED_ERROR,
353: p_token1 => G_SQLCODE_TOKEN,
354: p_token1_value => sqlcode,
355: p_token2 => G_SQLERRM_TOKEN,

Line 382: x_return_status := OKC_API.G_RET_STS_SUCCESS;

378: l_high_val number;
379:
380: BEGIN
381:
382: x_return_status := OKC_API.G_RET_STS_SUCCESS;
383:
384: i := 1;
385:
386: IF p_def IS NULL THEN

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

510: end loop;
511:
512: EXCEPTION
513: WHEN G_EXCEPTION_HALT_VALIDATION THEN
514: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
517: RAISE OKC_API.G_EXCEPTION_ERROR;
518: END IF;

Line 515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

511:
512: EXCEPTION
513: WHEN G_EXCEPTION_HALT_VALIDATION THEN
514: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
517: RAISE OKC_API.G_EXCEPTION_ERROR;
518: END IF;
519: WHEN OTHERS THEN

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

512: EXCEPTION
513: WHEN G_EXCEPTION_HALT_VALIDATION THEN
514: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
517: RAISE OKC_API.G_EXCEPTION_ERROR;
518: END IF;
519: WHEN OTHERS THEN
520: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 517: RAISE OKC_API.G_EXCEPTION_ERROR;

513: WHEN G_EXCEPTION_HALT_VALIDATION THEN
514: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
515: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
517: RAISE OKC_API.G_EXCEPTION_ERROR;
518: END IF;
519: WHEN OTHERS THEN
520: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
521: p_msg_name => G_UNEXPECTED_ERROR,

Line 520: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

516: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
517: RAISE OKC_API.G_EXCEPTION_ERROR;
518: END IF;
519: WHEN OTHERS THEN
520: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
521: p_msg_name => G_UNEXPECTED_ERROR,
522: p_token1 => G_SQLCODE_TOKEN,
523: p_token1_value => sqlcode,
524: p_token2 => G_SQLERRM_TOKEN,

Line 550: x_return_status := OKC_API.G_RET_STS_SUCCESS;

546:
547:
548: BEGIN
549:
550: x_return_status := OKC_API.G_RET_STS_SUCCESS;
551:
552: IF (p_yr_pattern_tbl.COUNT = 0) THEN
553: RETURN;
554: END IF;

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

589: END LOOP; ---YR LOOP
590:
591: EXCEPTION
592: WHEN G_EXCEPTION_HALT_VALIDATION THEN
593: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
595: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
596: RAISE OKC_API.G_EXCEPTION_ERROR;
597: END IF;

Line 594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

590:
591: EXCEPTION
592: WHEN G_EXCEPTION_HALT_VALIDATION THEN
593: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
595: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
596: RAISE OKC_API.G_EXCEPTION_ERROR;
597: END IF;
598: WHEN OTHERS THEN

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

591: EXCEPTION
592: WHEN G_EXCEPTION_HALT_VALIDATION THEN
593: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
595: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
596: RAISE OKC_API.G_EXCEPTION_ERROR;
597: END IF;
598: WHEN OTHERS THEN
599: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 596: RAISE OKC_API.G_EXCEPTION_ERROR;

592: WHEN G_EXCEPTION_HALT_VALIDATION THEN
593: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
594: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
595: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
596: RAISE OKC_API.G_EXCEPTION_ERROR;
597: END IF;
598: WHEN OTHERS THEN
599: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
600: p_msg_name => G_UNEXPECTED_ERROR,

Line 599: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

595: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
596: RAISE OKC_API.G_EXCEPTION_ERROR;
597: END IF;
598: WHEN OTHERS THEN
599: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
600: p_msg_name => G_UNEXPECTED_ERROR,
601: p_token1 => G_SQLCODE_TOKEN,
602: p_token1_value => sqlcode,
603: p_token2 => G_SQLERRM_TOKEN,

Line 635: x_return_status := OKC_API.G_RET_STS_SUCCESS;

631:
632:
633: BEGIN
634:
635: x_return_status := OKC_API.G_RET_STS_SUCCESS;
636:
637: IF (p_yr_pattern_tbl.COUNT = 0) OR (p_mth_pattern_tbl.COUNT = 0 ) THEN
638: RETURN;
639: END IF;

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

679: END LOOP; ---YR LOOP
680:
681: EXCEPTION
682: WHEN G_EXCEPTION_HALT_VALIDATION THEN
683: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
686: RAISE OKC_API.G_EXCEPTION_ERROR;
687: END IF;

Line 684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

680:
681: EXCEPTION
682: WHEN G_EXCEPTION_HALT_VALIDATION THEN
683: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
686: RAISE OKC_API.G_EXCEPTION_ERROR;
687: END IF;
688: WHEN OTHERS THEN

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

681: EXCEPTION
682: WHEN G_EXCEPTION_HALT_VALIDATION THEN
683: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
686: RAISE OKC_API.G_EXCEPTION_ERROR;
687: END IF;
688: WHEN OTHERS THEN
689: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 686: RAISE OKC_API.G_EXCEPTION_ERROR;

682: WHEN G_EXCEPTION_HALT_VALIDATION THEN
683: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
686: RAISE OKC_API.G_EXCEPTION_ERROR;
687: END IF;
688: WHEN OTHERS THEN
689: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
690: p_msg_name => G_UNEXPECTED_ERROR,

Line 689: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
686: RAISE OKC_API.G_EXCEPTION_ERROR;
687: END IF;
688: WHEN OTHERS THEN
689: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
690: p_msg_name => G_UNEXPECTED_ERROR,
691: p_token1 => G_SQLCODE_TOKEN,
692: p_token1_value => sqlcode,
693: p_token2 => G_SQLERRM_TOKEN,

Line 723: x_return_status := OKC_API.G_RET_STS_SUCCESS;

719:
720:
721: BEGIN
722:
723: x_return_status := OKC_API.G_RET_STS_SUCCESS;
724:
725: IF (p_yr_pattern_tbl.COUNT = 0) OR (p_mth_pattern_tbl.COUNT = 0 ) OR (p_wk_pattern_tbl.COUNT = 0) THEN
726: RETURN;
727: END IF;

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

773: END LOOP; ---YR LOOP
774:
775: EXCEPTION
776: WHEN G_EXCEPTION_HALT_VALIDATION THEN
777: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;

Line 778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

774:
775: EXCEPTION
776: WHEN G_EXCEPTION_HALT_VALIDATION THEN
777: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;
782: WHEN OTHERS THEN

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

775: EXCEPTION
776: WHEN G_EXCEPTION_HALT_VALIDATION THEN
777: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;
782: WHEN OTHERS THEN
783: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 780: RAISE OKC_API.G_EXCEPTION_ERROR;

776: WHEN G_EXCEPTION_HALT_VALIDATION THEN
777: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;
782: WHEN OTHERS THEN
783: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
784: p_msg_name => G_UNEXPECTED_ERROR,

Line 783: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

779: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
780: RAISE OKC_API.G_EXCEPTION_ERROR;
781: END IF;
782: WHEN OTHERS THEN
783: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
784: p_msg_name => G_UNEXPECTED_ERROR,
785: p_token1 => G_SQLCODE_TOKEN,
786: p_token1_value => sqlcode,
787: p_token2 => G_SQLERRM_TOKEN,

Line 818: x_return_status := OKC_API.G_RET_STS_SUCCESS;

814:
815:
816: BEGIN
817:
818: x_return_status := OKC_API.G_RET_STS_SUCCESS;
819:
820: IF (p_yr_pattern_tbl.COUNT = 0) OR (p_mth_pattern_tbl.COUNT = 0 ) OR (p_day_pattern_tbl.COUNT = 0) THEN
821: RETURN;
822: END IF;

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

871: END LOOP; ---YR LOOP
872:
873: EXCEPTION
874: WHEN G_EXCEPTION_HALT_VALIDATION THEN
875: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;

Line 876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

872:
873: EXCEPTION
874: WHEN G_EXCEPTION_HALT_VALIDATION THEN
875: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;
880: WHEN OTHERS THEN

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

873: EXCEPTION
874: WHEN G_EXCEPTION_HALT_VALIDATION THEN
875: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;
880: WHEN OTHERS THEN
881: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 878: RAISE OKC_API.G_EXCEPTION_ERROR;

874: WHEN G_EXCEPTION_HALT_VALIDATION THEN
875: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;
880: WHEN OTHERS THEN
881: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
882: p_msg_name => G_UNEXPECTED_ERROR,

Line 881: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

877: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_ERROR;
879: END IF;
880: WHEN OTHERS THEN
881: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
882: p_msg_name => G_UNEXPECTED_ERROR,
883: p_token1 => G_SQLCODE_TOKEN,
884: p_token1_value => sqlcode,
885: p_token2 => G_SQLERRM_TOKEN,

Line 915: x_return_status := OKC_API.G_RET_STS_SUCCESS;

911:
912:
913: BEGIN
914:
915: x_return_status := OKC_API.G_RET_STS_SUCCESS;
916:
917: IF (p_yr_pattern_tbl.COUNT = 0) OR (p_mth_pattern_tbl.COUNT = 0 ) OR (p_wk_pattern_tbl.COUNT = 0) or
918: (p_wd_pattern_tbl.count = 0)THEN
919:

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

973: END LOOP; ---YR LOOP
974:
975: EXCEPTION
976: WHEN G_EXCEPTION_HALT_VALIDATION THEN
977: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;

Line 978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

974:
975: EXCEPTION
976: WHEN G_EXCEPTION_HALT_VALIDATION THEN
977: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;
982: WHEN OTHERS THEN

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

975: EXCEPTION
976: WHEN G_EXCEPTION_HALT_VALIDATION THEN
977: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;
982: WHEN OTHERS THEN
983: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

Line 980: RAISE OKC_API.G_EXCEPTION_ERROR;

976: WHEN G_EXCEPTION_HALT_VALIDATION THEN
977: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;
982: WHEN OTHERS THEN
983: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
984: p_msg_name => G_UNEXPECTED_ERROR,

Line 983: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,

979: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
980: RAISE OKC_API.G_EXCEPTION_ERROR;
981: END IF;
982: WHEN OTHERS THEN
983: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME_OKC,
984: p_msg_name => G_UNEXPECTED_ERROR,
985: p_token1 => G_SQLCODE_TOKEN,
986: p_token1_value => sqlcode,
987: p_token2 => G_SQLERRM_TOKEN,