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

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

20: p_pdpv_tbl IN pdpv_tbl_type,
21: x_pdfv_rec OUT NOCOPY pdfv_rec_type,
22: x_pdpv_tbl OUT NOCOPY pdpv_tbl_type) IS
23:
24: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
25: l_pdfv_rec pdfv_rec_type;
26: l_pdpv_tbl pdpv_tbl_type := p_pdpv_tbl;
27: i NUMBER;
28: begin

Line 38: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

34: x_msg_count,
35: x_msg_data,
36: p_pdfv_rec,
37: x_pdfv_rec);
38: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
39: raise G_EXCEPTION_HALT_VALIDATION;
40: ELSE
41: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
42: l_return_status := x_return_status;

Line 41: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

37: x_pdfv_rec);
38: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
39: raise G_EXCEPTION_HALT_VALIDATION;
40: ELSE
41: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
42: l_return_status := x_return_status;
43: END IF;
44: END IF;
45:

Line 65: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

61: x_msg_count,
62: x_msg_data,
63: l_pdpv_tbl,
64: x_pdpv_tbl);
65: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
66: raise G_EXCEPTION_HALT_VALIDATION;
67: ELSE
68: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
69: l_return_status := x_return_status;

Line 68: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

64: x_pdpv_tbl);
65: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
66: raise G_EXCEPTION_HALT_VALIDATION;
67: ELSE
68: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
69: l_return_status := x_return_status;
70: END IF;
71: END IF;
72:

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

74: WHEN G_EXCEPTION_HALT_VALIDATION THEN
75: Null;
76:
77: WHEN OTHERS THEN
78: OKC_API.set_message(p_app_name => g_app_name,
79: p_msg_name => g_unexpected_error,
80: p_token1 => g_sqlcode_token,
81: p_token1_value => sqlcode,
82: p_token2 => g_sqlerrm_token,

Line 84: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

80: p_token1 => g_sqlcode_token,
81: p_token1_value => sqlcode,
82: p_token2 => g_sqlerrm_token,
83: p_token2_value => sqlerrm);
84: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
85: End create_process_def;
86:
87: --Object type procedure for update
88: PROCEDURE update_process_def(

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

94: p_pdfv_rec IN pdfv_rec_type,
95: p_pdpv_tbl IN pdpv_tbl_type,
96: x_pdfv_rec OUT NOCOPY pdfv_rec_type,
97: x_pdpv_tbl OUT NOCOPY pdpv_tbl_type) IS
98: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
99: begin
100: --Update the Master
101: update_proc_def(
102: p_api_version,

Line 109: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

105: x_msg_count,
106: x_msg_data,
107: p_pdfv_rec,
108: x_pdfv_rec);
109: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
110: raise G_EXCEPTION_HALT_VALIDATION;
111: ELSE
112: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
113: l_return_status := x_return_status;

Line 112: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

108: x_pdfv_rec);
109: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
110: raise G_EXCEPTION_HALT_VALIDATION;
111: ELSE
112: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
113: l_return_status := x_return_status;
114: END IF;
115: END IF;
116:

Line 126: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

122: x_msg_count,
123: x_msg_data,
124: p_pdpv_tbl,
125: x_pdpv_tbl);
126: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: raise G_EXCEPTION_HALT_VALIDATION;
128: ELSE
129: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
130: l_return_status := x_return_status;

Line 129: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

125: x_pdpv_tbl);
126: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: raise G_EXCEPTION_HALT_VALIDATION;
128: ELSE
129: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
130: l_return_status := x_return_status;
131: END IF;
132: END IF;
133:

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

135: WHEN G_EXCEPTION_HALT_VALIDATION THEN
136: Null;
137:
138: WHEN OTHERS THEN
139: OKC_API.set_message(p_app_name => g_app_name,
140: p_msg_name => g_unexpected_error,
141: p_token1 => g_sqlcode_token,
142: p_token1_value => sqlcode,
143: p_token2 => g_sqlerrm_token,

Line 145: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

141: p_token1 => g_sqlcode_token,
142: p_token1_value => sqlcode,
143: p_token2 => g_sqlerrm_token,
144: p_token2_value => sqlerrm);
145: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
146: end update_process_def;
147:
148: --Object type procedure for validate
149: PROCEDURE validate_process_def(

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

153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_pdfv_rec IN pdfv_rec_type,
156: p_pdpv_tbl IN pdpv_tbl_type) IS
157: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
158: begin
159: --Validate the Master
160: validate_proc_def(
161: p_api_version,

Line 167: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

163: x_return_status,
164: x_msg_count,
165: x_msg_data,
166: p_pdfv_rec);
167: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
168: raise G_EXCEPTION_HALT_VALIDATION;
169: ELSE
170: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
171: l_return_status := x_return_status;

Line 170: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

166: p_pdfv_rec);
167: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
168: raise G_EXCEPTION_HALT_VALIDATION;
169: ELSE
170: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
171: l_return_status := x_return_status;
172: END IF;
173: END IF;
174:

Line 183: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

179: x_return_status,
180: x_msg_count,
181: x_msg_data,
182: p_pdpv_tbl);
183: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
184: raise G_EXCEPTION_HALT_VALIDATION;
185: ELSE
186: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
187: l_return_status := x_return_status;

Line 186: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

182: p_pdpv_tbl);
183: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
184: raise G_EXCEPTION_HALT_VALIDATION;
185: ELSE
186: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
187: l_return_status := x_return_status;
188: END IF;
189: END IF;
190:

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

192: WHEN G_EXCEPTION_HALT_VALIDATION THEN
193: Null;
194:
195: WHEN OTHERS THEN
196: OKC_API.set_message(p_app_name => g_app_name,
197: p_msg_name => g_unexpected_error,
198: p_token1 => g_sqlcode_token,
199: p_token1_value => sqlcode,
200: p_token2 => g_sqlerrm_token,

Line 202: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

198: p_token1 => g_sqlcode_token,
199: p_token1_value => sqlcode,
200: p_token2 => g_sqlerrm_token,
201: p_token2_value => sqlerrm);
202: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
203: End validate_process_def;
204:
205: --Procedures for Process Definitions
206:

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

287: l_pdpv_tbl OKC_PROCESS_PUB.pdpv_tbl_type;
288: v_pdpv_tbl OKC_PROCESS_PUB.pdpv_tbl_type;
289: l_api_version NUMBER := 1;
290: l_init_msg_list VARCHAR2(1) := 'T';
291: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
292: l_msg_count NUMBER;
293: l_msg_data VARCHAR2(200);
294: l_app_id1 NUMBER;
295: l_cnt NUMBER := 0;

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

376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2,
378: p_pdfv_rec IN pdfv_rec_type) IS
379:
380: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
381: i NUMBER := 0;
382: c NUMBER := 0;
383: l_pdpv_tbl pdpv_tbl_type;
384: l_condition VARCHAR2(1) := '?';

Line 433: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

429: CLOSE check_k_process_csr;
430:
431: --Process definition cannot be deleted while being used in conditions
432: IF l_condition = '1' OR l_qa = '1' OR l_process = '1' THEN
433: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
434: p_msg_name => g_delete_proc_def);
435: x_return_status := OKC_API.G_RET_STS_ERROR;
436: raise G_EXCEPTION_HALT_VALIDATION;
437: ELSE

Line 435: x_return_status := OKC_API.G_RET_STS_ERROR;

431: --Process definition cannot be deleted while being used in conditions
432: IF l_condition = '1' OR l_qa = '1' OR l_process = '1' THEN
433: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
434: p_msg_name => g_delete_proc_def);
435: x_return_status := OKC_API.G_RET_STS_ERROR;
436: raise G_EXCEPTION_HALT_VALIDATION;
437: ELSE
438: --populate the Foreign key of the detail
439: For p_rec in p_cur loop

Line 453: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

449: x_return_status,
450: x_msg_count,
451: x_msg_data,
452: l_pdpv_tbl);
453: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
454: raise G_EXCEPTION_HALT_VALIDATION;
455: ELSE
456: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
457: l_return_status := x_return_status;

Line 456: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

452: l_pdpv_tbl);
453: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
454: raise G_EXCEPTION_HALT_VALIDATION;
455: ELSE
456: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
457: l_return_status := x_return_status;
458: END IF;
459: END IF;
460:

Line 469: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

465: x_return_status,
466: x_msg_count,
467: x_msg_data,
468: p_pdfv_rec);
469: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
470: raise G_EXCEPTION_HALT_VALIDATION;
471: ELSE
472: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
473: l_return_status := x_return_status;

Line 472: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

468: p_pdfv_rec);
469: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
470: raise G_EXCEPTION_HALT_VALIDATION;
471: ELSE
472: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
473: l_return_status := x_return_status;
474: END IF;
475: END IF;
476: END IF;

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

478: WHEN G_EXCEPTION_HALT_VALIDATION THEN
479: Null;
480:
481: WHEN OTHERS THEN
482: OKC_API.set_message(p_app_name => g_app_name,
483: p_msg_name => g_unexpected_error,
484: p_token1 => g_sqlcode_token,
485: p_token1_value => sqlcode,
486: p_token2 => g_sqlerrm_token,

Line 488: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

484: p_token1 => g_sqlcode_token,
485: p_token1_value => sqlcode,
486: p_token2 => g_sqlerrm_token,
487: p_token2_value => sqlerrm);
488: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
489: End delete_proc_def;
490:
491: PROCEDURE delete_proc_def(
492: p_api_version IN NUMBER,

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

495: x_msg_count OUT NOCOPY NUMBER,
496: x_msg_data OUT NOCOPY VARCHAR2,
497: p_pdfv_tbl IN pdfv_tbl_type) IS
498: i NUMBER :=0;
499: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
500: begin
501: --Initialize the return status
502: x_return_status := OKC_API.G_RET_STS_SUCCESS;
503:

Line 502: x_return_status := OKC_API.G_RET_STS_SUCCESS;

498: i NUMBER :=0;
499: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
500: begin
501: --Initialize the return status
502: x_return_status := OKC_API.G_RET_STS_SUCCESS;
503:
504: IF (p_pdfv_tbl.COUNT > 0) THEN
505: i := p_pdfv_tbl.FIRST;
506: LOOP

Line 518: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

514: EXIT WHEN (i = p_pdfv_tbl.LAST);
515: i := p_pdfv_tbl.NEXT(i);
516: END LOOP;
517: END IF;
518: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
519: raise G_EXCEPTION_HALT_VALIDATION;
520: ELSE
521: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
522: l_return_status := x_return_status;

Line 521: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

517: END IF;
518: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
519: raise G_EXCEPTION_HALT_VALIDATION;
520: ELSE
521: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
522: l_return_status := x_return_status;
523: END IF;
524: END IF;
525: EXCEPTION

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

526: WHEN G_EXCEPTION_HALT_VALIDATION THEN
527: Null;
528:
529: WHEN OTHERS THEN
530: OKC_API.set_message(p_app_name => g_app_name,
531: p_msg_name => g_unexpected_error,
532: p_token1 => g_sqlcode_token,
533: p_token1_value => sqlcode,
534: p_token2 => g_sqlerrm_token,

Line 536: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

532: p_token1 => g_sqlcode_token,
533: p_token1_value => sqlcode,
534: p_token2 => g_sqlerrm_token,
535: p_token2_value => sqlerrm);
536: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
537: End delete_proc_def;
538:
539: PROCEDURE validate_proc_def(
540: p_api_version IN NUMBER,

Line 805: x_return_status := OKC_API.G_RET_STS_SUCCESS;

801: BEGIN
802: --
803: -- Setup the successful message
804: --
805: x_return_status := OKC_API.G_RET_STS_SUCCESS;
806: FND_MESSAGE.SET_NAME(application => g_app_name,
807: name => g_validate_dbname_success);
808:
809: x_msg_count := 0;

Line 824: x_return_status := OKC_API.G_RET_STS_ERROR;

820: name => g_validate_dbname_notfound);
821: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',
822: value => g_validate_dbname_wf_pair,
823: translate => TRUE);
824: x_return_status := OKC_API.G_RET_STS_ERROR;
825: ELSE
826: CLOSE wf;
827: IF l_run_flag <> 'Y' THEN
828: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 828: x_return_status := OKC_API.G_RET_STS_ERROR;

824: x_return_status := OKC_API.G_RET_STS_ERROR;
825: ELSE
826: CLOSE wf;
827: IF l_run_flag <> 'Y' THEN
828: x_return_status := OKC_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME(application => g_app_name,
830: name => g_validate_dbname_notrun);
831: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',
832: value => g_validate_dbname_wf_pair,

Line 841: x_return_status := OKC_API.G_RET_STS_ERROR;

837: ELSIF (p_pdfv_rec.procedure_name IS NOT NULL) AND (p_pdfv_rec.package_name IS NOT NULL) THEN
838: OPEN pp(p_pdfv_rec.package_name, p_pdfv_rec.procedure_name);
839: FETCH pp INTO l_pack_count;
840: IF pp%NOTFOUND THEN
841: x_return_status := OKC_API.G_RET_STS_ERROR;
842: FND_MESSAGE.SET_NAME(application => g_app_name,
843: name => g_validate_dbname_notfound);
844: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',
845: value => g_validate_dbname_pp_pair,

Line 867: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

863: FND_MESSAGE.SET_TOKEN(token => g_sqlcode_token,
864: value => sqlcode);
865: FND_MESSAGE.SET_TOKEN(token => g_sqlerrm_token,
866: value => sqlerrm);
867: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
868:
869: END validate_dbnames;
870:
871: