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.OKC_OUTCOME_INIT_PVT dependencies on OKC_API

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

28: l_outcome_name VARCHAR2(200);
29: l_api_name CONSTANT VARCHAR2(30) := 'launch_outcome';
30: l_api_version NUMBER := 1.0;
31: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
32: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
33: v_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
34: l_msg_count NUMBER;
35: l_msg_data VARCHAR2(240);
36: l_proc VARCHAR2(4000);

Line 33: v_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

29: l_api_name CONSTANT VARCHAR2(30) := 'launch_outcome';
30: l_api_version NUMBER := 1.0;
31: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
32: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
33: v_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
34: l_msg_count NUMBER;
35: l_msg_data VARCHAR2(240);
36: l_proc VARCHAR2(4000);
37: --NPALEPU

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

102: okc_debug.Set_Indentation(l_proc_n);
103: okc_debug.Log('10: Entering ',2);
104: END IF;
105:
106: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
107: G_PKG_NAME,
108: l_init_msg_list,
109: l_api_version,
110: p_api_version,

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

109: l_api_version,
110: p_api_version,
111: G_LEVEL,
112: x_return_status);
113: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
115: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
116: RAISE OKC_API.G_EXCEPTION_ERROR;
117: END IF;

Line 114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

111: G_LEVEL,
112: x_return_status);
113: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
115: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
116: RAISE OKC_API.G_EXCEPTION_ERROR;
117: END IF;
118:
119: -- populate profile option values for success and error message recipients

Line 116: RAISE OKC_API.G_EXCEPTION_ERROR;

112: x_return_status);
113: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
114: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
115: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
116: RAISE OKC_API.G_EXCEPTION_ERROR;
117: END IF;
118:
119: -- populate profile option values for success and error message recipients
120: OPEN profile_cur1;

Line 173: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

169: l_e_recipient := NVL(l_e_recipient,prof_e_recipient);
170:
171: --Check the correlation
172: IF p_corrid_rec.corrid NOT IN ('PPS', 'WPS') THEN
173: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
174: p_msg_name => G_INVALID_VALUE,
175: p_token1 => g_col_name_token,
176: p_token1_value => 'p_corrid_rec');
177: raise OKC_API.G_EXCEPTION_ERROR;

Line 177: raise OKC_API.G_EXCEPTION_ERROR;

173: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
174: p_msg_name => G_INVALID_VALUE,
175: p_token1 => g_col_name_token,
176: p_token1_value => 'p_corrid_rec');
177: raise OKC_API.G_EXCEPTION_ERROR;
178: ELSIF p_corrid_rec.corrid = 'PPS' THEN
179: --Create a plsql procedure
180: Launch_plsql(p_api_version => p_api_version,
181: p_init_msg_list => p_init_msg_list,

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

189: --END NPALEPU
190: x_msg_count => l_msg_count,
191: x_msg_data => l_msg_data,
192: x_return_status => l_return_status);
193: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
194: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
196: raise OKC_API.G_EXCEPTION_ERROR;
197: END IF;

Line 194: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

190: x_msg_count => l_msg_count,
191: x_msg_data => l_msg_data,
192: x_return_status => l_return_status);
193: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
194: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
196: raise OKC_API.G_EXCEPTION_ERROR;
197: END IF;
198:

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

191: x_msg_data => l_msg_data,
192: x_return_status => l_return_status);
193: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
194: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
196: raise OKC_API.G_EXCEPTION_ERROR;
197: END IF;
198:
199: ELSIF p_corrid_rec.corrid = 'WPS' THEN

Line 196: raise OKC_API.G_EXCEPTION_ERROR;

192: x_return_status => l_return_status);
193: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
194: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
195: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
196: raise OKC_API.G_EXCEPTION_ERROR;
197: END IF;
198:
199: ELSIF p_corrid_rec.corrid = 'WPS' THEN
200: --a workflow

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

210: --END NPALEPU
211: x_msg_count => l_msg_count,
212: x_msg_data => l_msg_data,
213: x_return_status => l_return_status);
214: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
215: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
217: raise OKC_API.G_EXCEPTION_ERROR;
218: END IF;

Line 215: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

211: x_msg_count => l_msg_count,
212: x_msg_data => l_msg_data,
213: x_return_status => l_return_status);
214: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
215: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
217: raise OKC_API.G_EXCEPTION_ERROR;
218: END IF;
219: END IF;

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

212: x_msg_data => l_msg_data,
213: x_return_status => l_return_status);
214: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
215: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
217: raise OKC_API.G_EXCEPTION_ERROR;
218: END IF;
219: END IF;
220:

Line 217: raise OKC_API.G_EXCEPTION_ERROR;

213: x_return_status => l_return_status);
214: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
215: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
217: raise OKC_API.G_EXCEPTION_ERROR;
218: END IF;
219: END IF;
220:
221: IF l_plsql_proc IS NOT NULL THEN

Line 261: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

257: ,p_contract_id => l_contract_id
258: ,p_loops => 2
259: ,p_subj_first_msg => 'F'
260: );
261: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
262:
263: IF (l_debug = 'Y') THEN
264: okc_debug.Log('1000: Leaving ',2);
265: okc_debug.Reset_Indentation;

Line 269: WHEN OKC_API.G_EXCEPTION_ERROR THEN

265: okc_debug.Reset_Indentation;
266: END IF;
267:
268: EXCEPTION
269: WHEN OKC_API.G_EXCEPTION_ERROR THEN
270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
271: (l_api_name,
272: G_PKG_NAME,
273: 'OKC_API.G_RET_STS_ERROR',

Line 270: x_return_status := OKC_API.HANDLE_EXCEPTIONS

266: END IF;
267:
268: EXCEPTION
269: WHEN OKC_API.G_EXCEPTION_ERROR THEN
270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
271: (l_api_name,
272: G_PKG_NAME,
273: 'OKC_API.G_RET_STS_ERROR',
274: l_msg_count,

Line 273: 'OKC_API.G_RET_STS_ERROR',

269: WHEN OKC_API.G_EXCEPTION_ERROR THEN
270: x_return_status := OKC_API.HANDLE_EXCEPTIONS
271: (l_api_name,
272: G_PKG_NAME,
273: 'OKC_API.G_RET_STS_ERROR',
274: l_msg_count,
275: l_msg_data,
276: G_LEVEL);
277: IF (l_debug = 'Y') THEN

Line 281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

277: IF (l_debug = 'Y') THEN
278: okc_debug.Log('2000: Leaving ',2);
279: okc_debug.Reset_Indentation;
280: END IF;
281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
282:
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (l_api_name,
285: G_PKG_NAME,

Line 283: x_return_status := OKC_API.HANDLE_EXCEPTIONS

279: okc_debug.Reset_Indentation;
280: END IF;
281: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
282:
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (l_api_name,
285: G_PKG_NAME,
286: 'OKC_API.G_RET_STS_UNEXP_ERROR',
287: l_msg_count,

Line 286: 'OKC_API.G_RET_STS_UNEXP_ERROR',

282:
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (l_api_name,
285: G_PKG_NAME,
286: 'OKC_API.G_RET_STS_UNEXP_ERROR',
287: l_msg_count,
288: l_msg_data,
289: G_LEVEL);
290: IF (l_debug = 'Y') THEN

Line 295: x_return_status := OKC_API.HANDLE_EXCEPTIONS

291: okc_debug.Log('3000: Leaving ',2);
292: okc_debug.Reset_Indentation;
293: END IF;
294: WHEN OTHERS THEN
295: x_return_status := OKC_API.HANDLE_EXCEPTIONS
296: (l_api_name,
297: G_PKG_NAME,
298: 'OTHERS',
299: l_msg_count,

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

325: x_return_status OUT NOCOPY VARCHAR2) IS
326:
327: l_api_name CONSTANT VARCHAR2(30) := 'launch_plsql';
328: l_api_version CONSTANT NUMBER := 1.0;
329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
330: v_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
331: v_msg_count NUMBER;
332: v_msg_data VARCHAR2(2000);
333: plsql_block VARCHAR2(4000);

Line 330: v_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

326:
327: l_api_name CONSTANT VARCHAR2(30) := 'launch_plsql';
328: l_api_version CONSTANT NUMBER := 1.0;
329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
330: v_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
331: v_msg_count NUMBER;
332: v_msg_data VARCHAR2(2000);
333: plsql_block VARCHAR2(4000);
334: l_error_exception EXCEPTION;

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

363: okc_debug.Set_Indentation(l_proc_n);
364: okc_debug.Log('10: Entering ',2);
365: END IF;
366:
367: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
368: G_PKG_NAME,
369: p_init_msg_list,
370: l_api_version,
371: p_api_version,

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

370: l_api_version,
371: p_api_version,
372: G_LEVEL,
373: x_return_status);
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: RAISE OKC_API.G_EXCEPTION_ERROR;
378: END IF;

Line 375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

371: p_api_version,
372: G_LEVEL,
373: x_return_status);
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: RAISE OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379:

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

372: G_LEVEL,
373: x_return_status);
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: RAISE OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379:
380: --NPALEPU

Line 377: RAISE OKC_API.G_EXCEPTION_ERROR;

373: x_return_status);
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: RAISE OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379:
380: --NPALEPU
381: --14-DEC-2005

Line 409: IF UPPER(p_outcome_tbl(i).value) NOT IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN

405: l_data_type := p_outcome_tbl(i).data_type;
406:
407: IF (l_data_type IN ('DATE', 'CHAR') AND p_outcome_tbl(i).name
408: NOT IN ('X_RETURN_STATUS', 'X_MSG_DATA', 'P_INIT_MSG_LIST')) THEN
409: IF UPPER(p_outcome_tbl(i).value) NOT IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN
410: l_pack_proc := p_outcome_name || '('||p_outcome_tbl(i).name||
411: ' => '||''''||p_outcome_tbl(i).value||'''';
412: ELSIF UPPER(p_outcome_tbl(i).value) IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN
413: l_pack_proc := p_outcome_name || '('||p_outcome_tbl(i).name||

Line 412: ELSIF UPPER(p_outcome_tbl(i).value) IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN

408: NOT IN ('X_RETURN_STATUS', 'X_MSG_DATA', 'P_INIT_MSG_LIST')) THEN
409: IF UPPER(p_outcome_tbl(i).value) NOT IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN
410: l_pack_proc := p_outcome_name || '('||p_outcome_tbl(i).name||
411: ' => '||''''||p_outcome_tbl(i).value||'''';
412: ELSIF UPPER(p_outcome_tbl(i).value) IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN
413: l_pack_proc := p_outcome_name || '('||p_outcome_tbl(i).name||
414: ' => '||p_outcome_tbl(i).value;
415: END IF;
416:

Line 427: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

423:
424: ELSIF (l_data_type = 'NUMBER') AND (p_outcome_tbl(i).name = 'X_MSG_COUNT') THEN
425: null;
426: ELSE
427: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
428: p_msg_name => G_INVALID_VALUE,
429: p_token1 => g_col_name_token,
430: p_token1_value => 'datatype');
431: raise OKC_API.G_EXCEPTION_ERROR;

Line 431: raise OKC_API.G_EXCEPTION_ERROR;

427: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
428: p_msg_name => G_INVALID_VALUE,
429: p_token1 => g_col_name_token,
430: p_token1_value => 'datatype');
431: raise OKC_API.G_EXCEPTION_ERROR;
432: END IF;
433:
434: IF p_outcome_tbl.COUNT > 1 THEN
435:

Line 442: IF UPPER(p_outcome_tbl(i).value) NOT IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN

438: LOOP
439: l_data_type := p_outcome_tbl(i).data_type;
440: IF (l_data_type IN ('DATE', 'CHAR') AND p_outcome_tbl(i).name
441: NOT IN ('X_RETURN_STATUS', 'X_MSG_DATA', 'P_INIT_MSG_LIST')) THEN
442: IF UPPER(p_outcome_tbl(i).value) NOT IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN
443: l_pack_proc := l_pack_proc||', '||p_outcome_tbl(i).name||
444: ' => '||''''||p_outcome_tbl(i).value||'''';
445: ELSIF UPPER(p_outcome_tbl(i).value) IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN
446: l_pack_proc := l_pack_proc||', '||p_outcome_tbl(i).name||

Line 445: ELSIF UPPER(p_outcome_tbl(i).value) IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN

441: NOT IN ('X_RETURN_STATUS', 'X_MSG_DATA', 'P_INIT_MSG_LIST')) THEN
442: IF UPPER(p_outcome_tbl(i).value) NOT IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN
443: l_pack_proc := l_pack_proc||', '||p_outcome_tbl(i).name||
444: ' => '||''''||p_outcome_tbl(i).value||'''';
445: ELSIF UPPER(p_outcome_tbl(i).value) IN ('OKC_API.G_MISS_CHAR','OKC_API.G_MISS_DATE','NULL') THEN
446: l_pack_proc := l_pack_proc||', '||p_outcome_tbl(i).name||
447: ' => '||p_outcome_tbl(i).value;
448: END IF;
449:

Line 461: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

457:
458: ELSIF (l_data_type = 'NUMBER') AND (p_outcome_tbl(i).name = 'X_MSG_COUNT') THEN
459: null;
460: ELSE
461: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
462: p_msg_name => G_INVALID_VALUE,
463: p_token1 => g_col_name_token,
464: p_token1_value => 'datatype');
465: raise OKC_API.G_EXCEPTION_ERROR;

Line 465: raise OKC_API.G_EXCEPTION_ERROR;

461: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
462: p_msg_name => G_INVALID_VALUE,
463: p_token1 => g_col_name_token,
464: p_token1_value => 'datatype');
465: raise OKC_API.G_EXCEPTION_ERROR;
466: END IF;
467: EXIT WHEN (i = p_outcome_tbl.LAST);
468: i := p_outcome_tbl.NEXT(i);
469: END LOOP;

Line 474: l_std_params := 'P_INIT_MSG_LIST => OKC_API.G_FALSE, X_RETURN_STATUS => :V_RETURN_STATUS,'||

470: END IF;
471: END IF;
472:
473: --Append all the standard parameters
474: l_std_params := 'P_INIT_MSG_LIST => OKC_API.G_FALSE, X_RETURN_STATUS => :V_RETURN_STATUS,'||
475: 'X_MSG_COUNT => V_MSG_COUNT, X_MSG_DATA => V_MSG_DATA)';
476: --Build the plsql string
477: l_pack_proc := l_pack_proc ||', '||l_std_params;
478:

Line 513: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME,

509: (okc_wf.build_wf_string( p_outcome_name,
510: l_outcome_tbl
511: )));
512: if l_pack_proc is null then
513: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME,
514: p_msg_name => G_INVALID_VALUE,
515: p_token1 => g_col_name_token,
516: p_token1_value => 'datatype');
517: raise OKC_API.G_EXCEPTION_ERROR;

Line 517: raise OKC_API.G_EXCEPTION_ERROR;

513: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME,
514: p_msg_name => G_INVALID_VALUE,
515: p_token1 => g_col_name_token,
516: p_token1_value => 'datatype');
517: raise OKC_API.G_EXCEPTION_ERROR;
518: end if;
519: x_proc:=l_pack_proc;
520: -- added by marat - end (bug#2477385)
521:

Line 522: OKC_API.END_ACTIVITY(v_msg_count, v_msg_data);

518: end if;
519: x_proc:=l_pack_proc;
520: -- added by marat - end (bug#2477385)
521:
522: OKC_API.END_ACTIVITY(v_msg_count, v_msg_data);
523:
524:
525: IF (l_debug = 'Y') THEN
526: okc_debug.Log('1000: Leaving ',2);

Line 531: WHEN OKC_API.G_EXCEPTION_ERROR THEN

527: okc_debug.Reset_Indentation;
528: END IF;
529:
530: Exception
531: WHEN OKC_API.G_EXCEPTION_ERROR THEN
532: x_return_status := OKC_API.HANDLE_EXCEPTIONS
533: (l_api_name,
534: G_PKG_NAME,
535: 'OKC_API.G_RET_STS_ERROR',

Line 532: x_return_status := OKC_API.HANDLE_EXCEPTIONS

528: END IF;
529:
530: Exception
531: WHEN OKC_API.G_EXCEPTION_ERROR THEN
532: x_return_status := OKC_API.HANDLE_EXCEPTIONS
533: (l_api_name,
534: G_PKG_NAME,
535: 'OKC_API.G_RET_STS_ERROR',
536: v_msg_count,

Line 535: 'OKC_API.G_RET_STS_ERROR',

531: WHEN OKC_API.G_EXCEPTION_ERROR THEN
532: x_return_status := OKC_API.HANDLE_EXCEPTIONS
533: (l_api_name,
534: G_PKG_NAME,
535: 'OKC_API.G_RET_STS_ERROR',
536: v_msg_count,
537: v_msg_data,
538: G_LEVEL);
539: IF (l_debug = 'Y') THEN

Line 543: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

539: IF (l_debug = 'Y') THEN
540: okc_debug.Log('2000: Leaving ',2);
541: okc_debug.Reset_Indentation;
542: END IF;
543: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
544: x_return_status := OKC_API.HANDLE_EXCEPTIONS
545: (l_api_name,
546: G_PKG_NAME,
547: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 544: x_return_status := OKC_API.HANDLE_EXCEPTIONS

540: okc_debug.Log('2000: Leaving ',2);
541: okc_debug.Reset_Indentation;
542: END IF;
543: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
544: x_return_status := OKC_API.HANDLE_EXCEPTIONS
545: (l_api_name,
546: G_PKG_NAME,
547: 'OKC_API.G_RET_STS_UNEXP_ERROR',
548: v_msg_count,

Line 547: 'OKC_API.G_RET_STS_UNEXP_ERROR',

543: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
544: x_return_status := OKC_API.HANDLE_EXCEPTIONS
545: (l_api_name,
546: G_PKG_NAME,
547: 'OKC_API.G_RET_STS_UNEXP_ERROR',
548: v_msg_count,
549: v_msg_data,
550: G_LEVEL);
551: IF (l_debug = 'Y') THEN

Line 556: x_return_status := OKC_API.HANDLE_EXCEPTIONS

552: okc_debug.Log('3000: Leaving ',2);
553: okc_debug.Reset_Indentation;
554: END IF;
555: WHEN OTHERS THEN
556: x_return_status := OKC_API.HANDLE_EXCEPTIONS
557: (l_api_name,
558: G_PKG_NAME,
559: 'OTHERS',
560: v_msg_count,

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

586: x_return_status OUT NOCOPY VARCHAR2) IS
587:
588: l_api_name CONSTANT VARCHAR2(30) := 'Launch_workflow';
589: l_api_version CONSTANT NUMBER := 1.0;
590: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
591: l_item_type VARCHAR2(100);
592: l_item_key VARCHAR2(100);
593: l_process VARCHAR2(100);
594: l_wf_proc VARCHAR2(4000);

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

618: okc_debug.Set_Indentation(l_proc_n);
619: okc_debug.Log('10: Entering ',2);
620: END IF;
621:
622: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
623: G_PKG_NAME,
624: p_init_msg_list,
625: l_api_version,
626: p_api_version,

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

625: l_api_version,
626: p_api_version,
627: G_LEVEL,
628: x_return_status);
629: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
632: RAISE OKC_API.G_EXCEPTION_ERROR;
633: END IF;

Line 630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

626: p_api_version,
627: G_LEVEL,
628: x_return_status);
629: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
632: RAISE OKC_API.G_EXCEPTION_ERROR;
633: END IF;
634:

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

627: G_LEVEL,
628: x_return_status);
629: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
632: RAISE OKC_API.G_EXCEPTION_ERROR;
633: END IF;
634:
635: --Workflow name

Line 632: RAISE OKC_API.G_EXCEPTION_ERROR;

628: x_return_status);
629: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
632: RAISE OKC_API.G_EXCEPTION_ERROR;
633: END IF;
634:
635: --Workflow name
636: l_item_type := substr(p_outcome_name, 1, instr(p_outcome_name, '.', 1) - 1);

Line 640: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

636: l_item_type := substr(p_outcome_name, 1, instr(p_outcome_name, '.', 1) - 1);
637: --Workflow Process name
638: l_process := substr(p_outcome_name, instr(p_outcome_name , '.') + 1);
639: IF l_item_type IS NULL OR l_process IS NULL THEN
640: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
641: p_msg_name => G_PROCESS_NOTFOUND,
642: p_token1 => g_wf_name_token,
643: p_token1_value => l_item_type,
644: p_token2 => G_WF_P_NAME_TOKEN,

Line 646: RAISE OKC_API.G_EXCEPTION_ERROR;

642: p_token1 => g_wf_name_token,
643: p_token1_value => l_item_type,
644: p_token2 => G_WF_P_NAME_TOKEN,
645: p_token2_value => l_process);
646: RAISE OKC_API.G_EXCEPTION_ERROR;
647: END IF;
648:
649: --NPALEPU
650: --14-DEC-2005

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

696: END IF;
697: commit;
698: l_wf_proc := 'begin WF_ENGINE.STARTPROCESS('||''''||l_item_type||''''||','||''''||l_item_key||''''||'); end;';
699: x_proc := l_wf_proc;
700: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
701:
702: IF (l_debug = 'Y') THEN
703: okc_debug.Log('1000: Leaving ',2);
704: okc_debug.Reset_Indentation;

Line 708: WHEN OKC_API.G_EXCEPTION_ERROR THEN

704: okc_debug.Reset_Indentation;
705: END IF;
706:
707: Exception
708: WHEN OKC_API.G_EXCEPTION_ERROR THEN
709: x_return_status := OKC_API.HANDLE_EXCEPTIONS
710: (l_api_name,
711: G_PKG_NAME,
712: 'OKC_API.G_RET_STS_ERROR',

Line 709: x_return_status := OKC_API.HANDLE_EXCEPTIONS

705: END IF;
706:
707: Exception
708: WHEN OKC_API.G_EXCEPTION_ERROR THEN
709: x_return_status := OKC_API.HANDLE_EXCEPTIONS
710: (l_api_name,
711: G_PKG_NAME,
712: 'OKC_API.G_RET_STS_ERROR',
713: x_msg_count,

Line 712: 'OKC_API.G_RET_STS_ERROR',

708: WHEN OKC_API.G_EXCEPTION_ERROR THEN
709: x_return_status := OKC_API.HANDLE_EXCEPTIONS
710: (l_api_name,
711: G_PKG_NAME,
712: 'OKC_API.G_RET_STS_ERROR',
713: x_msg_count,
714: x_msg_data,
715: G_LEVEL);
716: IF (l_debug = 'Y') THEN

Line 720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

716: IF (l_debug = 'Y') THEN
717: okc_debug.Log('2000: Leaving ',2);
718: okc_debug.Reset_Indentation;
719: END IF;
720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := OKC_API.HANDLE_EXCEPTIONS
722: (l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 721: x_return_status := OKC_API.HANDLE_EXCEPTIONS

717: okc_debug.Log('2000: Leaving ',2);
718: okc_debug.Reset_Indentation;
719: END IF;
720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := OKC_API.HANDLE_EXCEPTIONS
722: (l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',
725: x_msg_count,

Line 724: 'OKC_API.G_RET_STS_UNEXP_ERROR',

720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := OKC_API.HANDLE_EXCEPTIONS
722: (l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',
725: x_msg_count,
726: x_msg_data,
727: G_LEVEL);
728: IF (l_debug = 'Y') THEN

Line 733: x_return_status := OKC_API.HANDLE_EXCEPTIONS

729: okc_debug.Log('3000: Leaving ',2);
730: okc_debug.Reset_Indentation;
731: END IF;
732: WHEN OTHERS THEN
733: x_return_status := OKC_API.HANDLE_EXCEPTIONS
734: (l_api_name,
735: G_PKG_NAME,
736: 'OTHERS',
737: x_msg_count,