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

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

19: p_oatv_tbl IN oatv_tbl_type,
20: x_ocev_rec OUT NOCOPY ocev_rec_type,
21: x_oatv_tbl OUT NOCOPY oatv_tbl_type) IS
22:
23: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
24: l_ocev_rec ocev_rec_type;
25: l_oatv_tbl oatv_tbl_type := p_oatv_tbl;
26: i NUMBER;
27: begin

Line 37: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 40: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

Line 64: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 67: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 83: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

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

93: p_ocev_rec IN ocev_rec_type,
94: p_oatv_tbl IN oatv_tbl_type,
95: x_ocev_rec OUT NOCOPY ocev_rec_type,
96: x_oatv_tbl OUT NOCOPY oatv_tbl_type) IS
97: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
98: begin
99: --Update the Master
100: update_outcome(
101: p_api_version,

Line 108: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 111: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

Line 125: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 128: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 144: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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

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

152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_ocev_rec IN ocev_rec_type,
155: p_oatv_tbl IN oatv_tbl_type) IS
156: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
157: begin
158: --Validate the Master
159: validate_outcome(
160: p_api_version,

Line 166: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 169: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

Line 182: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 185: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

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

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

Line 201: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

197: p_token1 => g_sqlcode_token,
198: p_token1_value => sqlcode,
199: p_token2 => g_sqlerrm_token,
200: p_token2_value => sqlerrm);
201: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
202: End validate_outcomes_args;
203:
204: --Procedure to update minor version number
205:

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

210: x_msg_count NUMBER;
211: x_msg_data VARCHAR2(2000);
212: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
213: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
214: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
215: Begin
216: -- assign/populate contract header id
217: l_cvmv_rec.chr_id := p_chr_id;
218:

Line 227: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

223: x_msg_count => x_msg_count,
224: x_msg_data => x_msg_data,
225: p_cvmv_rec => l_cvmv_rec,
226: x_cvmv_rec => x_out_rec);
227: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
228: raise G_EXCEPTION_HALT_VALIDATION;
229: ELSE
230: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
231: l_return_status := x_return_status;

Line 230: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

226: x_cvmv_rec => x_out_rec);
227: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
228: raise G_EXCEPTION_HALT_VALIDATION;
229: ELSE
230: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
231: l_return_status := x_return_status;
232: END IF;
233: END IF;
234:

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

236: WHEN G_EXCEPTION_HALT_VALIDATION THEN
237: Null;
238:
239: WHEN OTHERS THEN
240: OKC_API.set_message(p_app_name => g_app_name,
241: p_msg_name => g_unexpected_error,
242: p_token1 => g_sqlcode_token,
243: p_token1_value => sqlcode,
244: p_token2 => g_sqlerrm_token,

Line 246: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

242: p_token1 => g_sqlcode_token,
243: p_token1_value => sqlcode,
244: p_token2 => g_sqlerrm_token,
245: p_token2_value => sqlerrm);
246: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
247: End update_minor_version;
248:
249: --Procedures for Outcomes
250:

Line 270: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

266: p_ocev_rec,
267: x_ocev_rec);
268:
269: --Update minor version
270: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
271: update_minor_version(p_ocev_rec.dnz_chr_id);
272: End if;
273: End create_outcome;
274:

Line 346: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

342: x_msg_data,
343: p_ocev_rec,
344: x_ocev_rec);
345: --Update minor version
346: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
347: update_minor_version(p_ocev_rec.dnz_chr_id);
348: End if;
349: End update_outcome;
350:

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

375: x_msg_count OUT NOCOPY NUMBER,
376: x_msg_data OUT NOCOPY VARCHAR2,
377: p_ocev_rec IN ocev_rec_type) IS
378:
379: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
380: i NUMBER := 0;
381: l_oatv_tbl oatv_tbl_type;
382:
383: Cursor p_cur is

Line 403: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

399: x_return_status,
400: x_msg_count,
401: x_msg_data,
402: l_oatv_tbl);
403: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
404: raise G_EXCEPTION_HALT_VALIDATION;
405: ELSE
406: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
407: l_return_status := x_return_status;

Line 406: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

402: l_oatv_tbl);
403: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
404: raise G_EXCEPTION_HALT_VALIDATION;
405: ELSE
406: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
407: l_return_status := x_return_status;
408: END IF;
409: END IF;
410:

Line 419: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

415: x_return_status,
416: x_msg_count,
417: x_msg_data,
418: p_ocev_rec);
419: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
420: raise G_EXCEPTION_HALT_VALIDATION;
421: ELSE
422: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
423: l_return_status := x_return_status;

Line 422: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

418: p_ocev_rec);
419: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
420: raise G_EXCEPTION_HALT_VALIDATION;
421: ELSE
422: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
423: l_return_status := x_return_status;
424: --Update minor version
425: update_minor_version(p_ocev_rec.dnz_chr_id);
426: End if;

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

430: WHEN G_EXCEPTION_HALT_VALIDATION THEN
431: Null;
432:
433: WHEN OTHERS THEN
434: OKC_API.set_message(p_app_name => g_app_name,
435: p_msg_name => g_unexpected_error,
436: p_token1 => g_sqlcode_token,
437: p_token1_value => sqlcode,
438: p_token2 => g_sqlerrm_token,

Line 440: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

436: p_token1 => g_sqlcode_token,
437: p_token1_value => sqlcode,
438: p_token2 => g_sqlerrm_token,
439: p_token2_value => sqlerrm);
440: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
441: End delete_outcome;
442:
443: PROCEDURE delete_outcome(
444: p_api_version IN NUMBER,

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

447: x_msg_count OUT NOCOPY NUMBER,
448: x_msg_data OUT NOCOPY VARCHAR2,
449: p_ocev_tbl IN ocev_tbl_type) IS
450: i NUMBER :=0;
451: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
452: begin
453: --Initialize the return status
454: x_return_status := OKC_API.G_RET_STS_SUCCESS;
455:

Line 454: x_return_status := OKC_API.G_RET_STS_SUCCESS;

450: i NUMBER :=0;
451: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
452: begin
453: --Initialize the return status
454: x_return_status := OKC_API.G_RET_STS_SUCCESS;
455:
456: IF (p_ocev_tbl.COUNT > 0) THEN
457: i := p_ocev_tbl.FIRST;
458: LOOP

Line 470: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

466: EXIT WHEN (i = p_ocev_tbl.LAST);
467: i := p_ocev_tbl.NEXT(i);
468: END LOOP;
469: END IF;
470: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
471: raise G_EXCEPTION_HALT_VALIDATION;
472: ELSE
473: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
474: l_return_status := x_return_status;

Line 473: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

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

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_outcome;
490:
491: PROCEDURE validate_outcome(
492: p_api_version IN NUMBER,

Line 545: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

541: x_msg_data,
542: p_oatv_rec,
543: x_oatv_rec);
544: --Update minor version
545: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
546: update_minor_version(p_oatv_rec.dnz_chr_id);
547: End if;
548: End create_out_arg;
549:

Line 621: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

617: x_msg_data,
618: p_oatv_rec,
619: x_oatv_rec);
620: --Update minor version
621: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
622: update_minor_version(p_oatv_rec.dnz_chr_id);
623: End if;
624: End update_out_arg;
625:

Line 661: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

657: x_msg_count,
658: x_msg_data,
659: p_oatv_rec);
660: --Update minor version
661: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
662: update_minor_version(p_oatv_rec.dnz_chr_id);
663: End if;
664: End delete_out_arg;
665: