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

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

22: p_aaev_tbl IN aaev_tbl_type,
23: x_acnv_rec OUT NOCOPY acnv_rec_type,
24: x_aaev_tbl OUT NOCOPY aaev_tbl_type) IS
25:
26: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
27: l_acnv_rec acnv_rec_type;
28: l_aaev_tbl aaev_tbl_type := p_aaev_tbl;
29: i NUMBER;
30: BEGIN

Line 42: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

38: x_msg_data,
39: p_acnv_rec,
40: x_acnv_rec);
41:
42: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
43: RAISE G_EXCEPTION_HALT_VALIDATION;
44: ELSE
45: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
46: l_return_status := x_return_status;

Line 45: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

41:
42: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
43: RAISE G_EXCEPTION_HALT_VALIDATION;
44: ELSE
45: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
46: l_return_status := x_return_status;
47: END IF;
48: END IF;
49:

Line 70: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

66: x_msg_data,
67: p_aaev_tbl,
68: x_aaev_tbl);
69:
70: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
71: RAISE G_EXCEPTION_HALT_VALIDATION;
72: ELSE
73: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
74: l_return_status := x_return_status;

Line 73: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

69:
70: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
71: RAISE G_EXCEPTION_HALT_VALIDATION;
72: ELSE
73: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
74: l_return_status := x_return_status;
75: END IF;
76: END IF;
77:

Line 83: OKC_API.SET_MESSAGE(p_app_name => g_app_name

79: WHEN G_EXCEPTION_HALT_VALIDATION THEN
80: NULL;
81:
82: WHEN OTHERS THEN
83: OKC_API.SET_MESSAGE(p_app_name => g_app_name
84: ,p_msg_name => g_unexpected_error
85: ,p_token1 => g_sqlcode_token
86: ,p_token1_value => sqlcode
87: ,p_token2 => g_sqlerrm_token

Line 89: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

85: ,p_token1 => g_sqlcode_token
86: ,p_token1_value => sqlcode
87: ,p_token2 => g_sqlerrm_token
88: ,p_token2_value => sqlerrm);
89: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
90:
91: END CREATE_ACTIONS;
92:
93: PROCEDURE CREATE_ACTIONS(

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

100: p_aaev_tbl IN aaev_tbl_type,
101: x_acnv_tbl OUT NOCOPY acnv_tbl_type,
102: x_aaev_tbl OUT NOCOPY aaev_tbl_type) IS
103:
104: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
105: l_acnv_tbl acnv_tbl_type;
106: l_aaev_tbl aaev_tbl_type := p_aaev_tbl;
107: i NUMBER;
108: BEGIN

Line 120: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

116: x_msg_data,
117: p_acnv_tbl,
118: x_acnv_tbl);
119:
120: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE G_EXCEPTION_HALT_VALIDATION;
122: ELSE
123: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
124: l_return_status := x_return_status;

Line 123: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

119:
120: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE G_EXCEPTION_HALT_VALIDATION;
122: ELSE
123: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
124: l_return_status := x_return_status;
125: END IF;
126: END IF;
127:

Line 148: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

144: x_msg_data,
145: p_aaev_tbl,
146: x_aaev_tbl);
147:
148: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE G_EXCEPTION_HALT_VALIDATION;
150: ELSE
151: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
152: l_return_status := x_return_status;

Line 151: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

147:
148: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE G_EXCEPTION_HALT_VALIDATION;
150: ELSE
151: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
152: l_return_status := x_return_status;
153: END IF;
154: END IF;
155:

Line 161: OKC_API.SET_MESSAGE(p_app_name => g_app_name

157: WHEN G_EXCEPTION_HALT_VALIDATION THEN
158: NULL;
159:
160: WHEN OTHERS THEN
161: OKC_API.SET_MESSAGE(p_app_name => g_app_name
162: ,p_msg_name => g_unexpected_error
163: ,p_token1 => g_sqlcode_token
164: ,p_token1_value => sqlcode
165: ,p_token2 => g_sqlerrm_token

Line 167: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

163: ,p_token1 => g_sqlcode_token
164: ,p_token1_value => sqlcode
165: ,p_token2 => g_sqlerrm_token
166: ,p_token2_value => sqlerrm);
167: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
168:
169: END CREATE_ACTIONS;
170:
171: -- Object type procedure for update

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

181: x_aaev_tbl OUT NOCOPY aaev_tbl_type) IS
182:
183: --l_api_vsersion CONSTANT NUMBER := 1;
184: --l_api_name CONSTANT VARCHAR2(30) := 'V_update_pub_event';
185: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
186: BEGIN
187: -- Update the master
188: update_actions(
189: p_api_version,

Line 197: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

193: x_msg_data,
194: p_acnv_rec,
195: x_acnv_rec);
196:
197: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE G_EXCEPTION_HALT_VALIDATION;
199: ELSE
200: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
201: l_return_status := x_return_status;

Line 200: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

196:
197: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE G_EXCEPTION_HALT_VALIDATION;
199: ELSE
200: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
201: l_return_status := x_return_status;
202: END IF;
203: END IF;
204:

Line 215: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

211: x_msg_data,
212: p_aaev_tbl,
213: x_aaev_tbl);
214:
215: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
216: RAISE G_EXCEPTION_HALT_VALIDATION;
217: ELSE
218: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
219: l_return_status := x_return_status;

Line 218: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

214:
215: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
216: RAISE G_EXCEPTION_HALT_VALIDATION;
217: ELSE
218: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
219: l_return_status := x_return_status;
220: END IF;
221: END IF;
222:

Line 228: OKC_API.SET_MESSAGE(p_app_name => g_app_name

224: WHEN G_EXCEPTION_HALT_VALIDATION THEN
225: NULL;
226:
227: WHEN OTHERS THEN
228: OKC_API.SET_MESSAGE(p_app_name => g_app_name
229: ,p_msg_name => g_unexpected_error
230: ,p_token1 => g_sqlcode_token
231: ,p_token1_value => sqlcode
232: ,p_token2 => g_sqlerrm_token

Line 234: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

230: ,p_token1 => g_sqlcode_token
231: ,p_token1_value => sqlcode
232: ,p_token2 => g_sqlerrm_token
233: ,p_token2_value => sqlerrm);
234: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
235:
236: END UPDATE_ACTIONS;
237:
238: -- Object type procedure for validate

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

244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_acnv_rec IN acnv_rec_type,
246: p_aaev_tbl IN aaev_tbl_type) IS
247:
248: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
249: BEGIN
250: -- Validate the master
251: validate_actions(
252: p_api_version,

Line 259: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

255: x_msg_count,
256: x_msg_data,
257: p_acnv_rec);
258:
259: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
260: RAISE G_EXCEPTION_HALT_VALIDATION;
261: ELSE
262: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
263: l_return_status := x_return_status;

Line 262: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

258:
259: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
260: RAISE G_EXCEPTION_HALT_VALIDATION;
261: ELSE
262: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
263: l_return_status := x_return_status;
264: END IF;
265: END IF;
266:

Line 276: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

272: x_msg_count,
273: x_msg_data,
274: p_aaev_tbl);
275:
276: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE G_EXCEPTION_HALT_VALIDATION;
278: ELSE
279: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
280: l_return_status := x_return_status;

Line 279: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

275:
276: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE G_EXCEPTION_HALT_VALIDATION;
278: ELSE
279: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
280: l_return_status := x_return_status;
281: END IF;
282: END IF;
283:

Line 289: OKC_API.SET_MESSAGE(p_app_name => g_app_name

285: WHEN G_EXCEPTION_HALT_VALIDATION THEN
286: NULL;
287:
288: WHEN OTHERS THEN
289: OKC_API.SET_MESSAGE(p_app_name => g_app_name
290: ,p_msg_name => g_unexpected_error
291: ,p_token1 => g_sqlcode_token
292: ,p_token1_value => sqlcode
293: ,p_token2 => g_sqlerrm_token

Line 295: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

291: ,p_token1 => g_sqlcode_token
292: ,p_token1_value => sqlcode
293: ,p_token2 => g_sqlerrm_token
294: ,p_token2_value => sqlerrm);
295: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
296:
297: END VALIDATE_ACTIONS;
298:
299: -- Procedures for Actions

Line 393: l_return_status varchar2(1):= OKC_API.G_RET_STS_SUCCESS;

389: l_aaev_tbl OKC_ACTIONS_PUB.aaev_tbl_type;
390: v_aaev_tbl OKC_ACTIONS_PUB.aaev_tbl_type;
391: l_api_version NUMBER := 1;
392: l_init_msg_list VARCHAR2(1) := 'T';
393: l_return_status varchar2(1):= OKC_API.G_RET_STS_SUCCESS;
394: l_msg_count number;
395: l_msg_data varchar2(200);
396: l_app_id1 NUMBER;
397: l_cnt NUMBER := 0;

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

510: x_msg_count OUT NOCOPY NUMBER,
511: x_msg_data OUT NOCOPY VARCHAR2,
512: p_acnv_rec IN acnv_rec_type) IS
513:
514: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
515: i NUMBER := 0;
516: l_aaev_tbl aaev_tbl_type;
517:
518: CURSOR aae_csr IS

Line 541: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

537: x_msg_count,
538: x_msg_data,
539: l_aaev_tbl);
540:
541: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
542: RAISE G_EXCEPTION_HALT_VALIDATION;
543: ELSE
544: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
545: l_return_status := x_return_status;

Line 544: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

540:
541: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
542: RAISE G_EXCEPTION_HALT_VALIDATION;
543: ELSE
544: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
545: l_return_status := x_return_status;
546: END IF;
547: END IF;
548: END IF;

Line 558: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

554: x_msg_count,
555: x_msg_data,
556: p_acnv_rec);
557:
558: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
559: RAISE G_EXCEPTION_HALT_VALIDATION;
560: ELSE
561: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
562: l_return_status := x_return_status;

Line 561: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

557:
558: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
559: RAISE G_EXCEPTION_HALT_VALIDATION;
560: ELSE
561: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
562: l_return_status := x_return_status;
563: END IF;
564: END IF;
565:

Line 571: OKC_API.SET_MESSAGE(p_app_name => g_app_name

567: WHEN G_EXCEPTION_HALT_VALIDATION THEN
568: NULL;
569:
570: WHEN OTHERS THEN
571: OKC_API.SET_MESSAGE(p_app_name => g_app_name
572: ,p_msg_name => g_unexpected_error
573: ,p_token1 => g_sqlcode_token
574: ,p_token1_value => sqlcode
575: ,p_token2 => g_sqlerrm_token

Line 577: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

573: ,p_token1 => g_sqlcode_token
574: ,p_token1_value => sqlcode
575: ,p_token2 => g_sqlerrm_token
576: ,p_token2_value => sqlerrm);
577: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
578:
579: END DELETE_ACTIONS;
580:
581: PROCEDURE DELETE_ACTIONS(

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

585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,
587: p_acnv_tbl IN acnv_tbl_type) IS
588: i NUMBER := 0;
589: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
590:
591: BEGIN
592: -- Initialize the return status
593: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 593: x_return_status := OKC_API.G_RET_STS_SUCCESS;

589: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
590:
591: BEGIN
592: -- Initialize the return status
593: x_return_status := OKC_API.G_RET_STS_SUCCESS;
594:
595: IF (p_acnv_tbl.COUNT > 0) THEN
596: i := p_acnv_tbl.FIRST;
597: LOOP

Line 610: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

606: i := p_acnv_tbl.NEXT(i);
607: END LOOP;
608: END IF;
609:
610: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE G_EXCEPTION_HALT_VALIDATION;
612: ELSE
613: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
614: l_return_status := x_return_status;

Line 613: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

609:
610: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE G_EXCEPTION_HALT_VALIDATION;
612: ELSE
613: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
614: l_return_status := x_return_status;
615: END IF;
616: END IF;
617:

Line 623: OKC_API.SET_MESSAGE(p_app_name => g_app_name

619: WHEN G_EXCEPTION_HALT_VALIDATION THEN
620: NULL;
621:
622: WHEN OTHERS THEN
623: OKC_API.SET_MESSAGE(p_app_name => g_app_name
624: ,p_msg_name => g_unexpected_error
625: ,p_token1 => g_sqlcode_token
626: ,p_token1_value => sqlcode
627: ,p_token2 => g_sqlerrm_token

Line 629: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

625: ,p_token1 => g_sqlcode_token
626: ,p_token1_value => sqlcode
627: ,p_token2 => g_sqlerrm_token
628: ,p_token2_value => sqlerrm);
629: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
630:
631: END DELETE_ACTIONS;
632:
633: PROCEDURE VALIDATE_ACTIONS(