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

Line 7: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3:
4: PROCEDURE insert_btn_pr
5: (
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_btn_pr_rec IN btn_pr_rec_type,

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

15: Is
16:
17: l_api_name CONSTANT VARCHAR2(30) := 'insert_btn_pr';
18: l_api_version CONSTANT NUMBER := 1.0;
19: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: l_btn_pr_rec btn_pr_rec_type;
21:
22: Begin
23:

Line 24: l_return_status := OKC_API.START_ACTIVITY

20: l_btn_pr_rec btn_pr_rec_type;
21:
22: Begin
23:
24: l_return_status := OKC_API.START_ACTIVITY
25: (
26: l_api_name
27: ,p_init_msg_list
28: ,'_PUB'

Line 32: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

28: ,'_PUB'
29: ,x_return_status
30: );
31:
32: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
33: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
34: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
35: Raise OKC_API.G_EXCEPTION_ERROR;
36: End If;

Line 33: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

29: ,x_return_status
30: );
31:
32: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
33: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
34: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
35: Raise OKC_API.G_EXCEPTION_ERROR;
36: End If;
37:

Line 34: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then

30: );
31:
32: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
33: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
34: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
35: Raise OKC_API.G_EXCEPTION_ERROR;
36: End If;
37:
38: g_btn_pr_rec:= p_btn_pr_rec;

Line 35: Raise OKC_API.G_EXCEPTION_ERROR;

31:
32: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
33: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
34: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
35: Raise OKC_API.G_EXCEPTION_ERROR;
36: End If;
37:
38: g_btn_pr_rec:= p_btn_pr_rec;
39:

Line 48: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then

44: p_procedure_name => l_api_name,
45: p_before_after => 'B'
46: );
47:
48: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
51: raise OKC_API.G_EXCEPTION_ERROR;
52: End If;

Line 49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

45: p_before_after => 'B'
46: );
47:
48: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
51: raise OKC_API.G_EXCEPTION_ERROR;
52: End If;
53:

Line 50: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then

46: );
47:
48: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
51: raise OKC_API.G_EXCEPTION_ERROR;
52: End If;
53:
54: --Restore ID/OBJECT VERSION NUMBER

Line 51: raise OKC_API.G_EXCEPTION_ERROR;

47:
48: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
51: raise OKC_API.G_EXCEPTION_ERROR;
52: End If;
53:
54: --Restore ID/OBJECT VERSION NUMBER
55:

Line 71: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

67: l_btn_pr_rec ,
68: x_btn_pr_rec
69: );
70:
71: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
74: raise OKC_API.G_EXCEPTION_ERROR;
75: End If;

Line 72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

68: x_btn_pr_rec
69: );
70:
71: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
74: raise OKC_API.G_EXCEPTION_ERROR;
75: End If;
76:

Line 73: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

69: );
70:
71: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
74: raise OKC_API.G_EXCEPTION_ERROR;
75: End If;
76:
77: g_btn_pr_rec := x_btn_pr_rec;

Line 74: raise OKC_API.G_EXCEPTION_ERROR;

70:
71: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
74: raise OKC_API.G_EXCEPTION_ERROR;
75: End If;
76:
77: g_btn_pr_rec := x_btn_pr_rec;
78:

Line 87: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

83: p_procedure_name => l_api_name,
84: p_before_after => 'A'
85: );
86:
87: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
88: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
89: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
90: raise OKC_API.G_EXCEPTION_ERROR;
91: End If;

Line 88: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

84: p_before_after => 'A'
85: );
86:
87: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
88: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
89: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
90: raise OKC_API.G_EXCEPTION_ERROR;
91: End If;
92:

Line 89: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

85: );
86:
87: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
88: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
89: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
90: raise OKC_API.G_EXCEPTION_ERROR;
91: End If;
92:
93: OKC_API.END_ACTIVITY

Line 90: raise OKC_API.G_EXCEPTION_ERROR;

86:
87: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
88: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
89: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
90: raise OKC_API.G_EXCEPTION_ERROR;
91: End If;
92:
93: OKC_API.END_ACTIVITY
94: (

Line 93: OKC_API.END_ACTIVITY

89: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
90: raise OKC_API.G_EXCEPTION_ERROR;
91: End If;
92:
93: OKC_API.END_ACTIVITY
94: (
95: x_msg_count => x_msg_count,
96: x_msg_data => x_msg_data
97: );

Line 100: When OKC_API.G_EXCEPTION_ERROR THEN

96: x_msg_data => x_msg_data
97: );
98:
99: Exception
100: When OKC_API.G_EXCEPTION_ERROR THEN
101: x_return_status := OKC_API.HANDLE_EXCEPTIONS
102: (
103: l_api_name,
104: G_PKG_NAME,

Line 101: x_return_status := OKC_API.HANDLE_EXCEPTIONS

97: );
98:
99: Exception
100: When OKC_API.G_EXCEPTION_ERROR THEN
101: x_return_status := OKC_API.HANDLE_EXCEPTIONS
102: (
103: l_api_name,
104: G_PKG_NAME,
105: 'OKC_API.G_RET_STS_ERROR',

Line 105: 'OKC_API.G_RET_STS_ERROR',

101: x_return_status := OKC_API.HANDLE_EXCEPTIONS
102: (
103: l_api_name,
104: G_PKG_NAME,
105: 'OKC_API.G_RET_STS_ERROR',
106: x_msg_count,
107: x_msg_data,
108: '_PUB'
109: );

Line 111: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

107: x_msg_data,
108: '_PUB'
109: );
110:
111: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
112: x_return_status := OKC_API.HANDLE_EXCEPTIONS
113: (
114: l_api_name,
115: G_PKG_NAME,

Line 112: x_return_status := OKC_API.HANDLE_EXCEPTIONS

108: '_PUB'
109: );
110:
111: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
112: x_return_status := OKC_API.HANDLE_EXCEPTIONS
113: (
114: l_api_name,
115: G_PKG_NAME,
116: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 116: 'OKC_API.G_RET_STS_UNEXP_ERROR',

112: x_return_status := OKC_API.HANDLE_EXCEPTIONS
113: (
114: l_api_name,
115: G_PKG_NAME,
116: 'OKC_API.G_RET_STS_UNEXP_ERROR',
117: x_msg_count,
118: x_msg_data,
119: '_PUB'
120: );

Line 123: x_return_status := OKC_API.HANDLE_EXCEPTIONS

119: '_PUB'
120: );
121:
122: When OTHERS THEN
123: x_return_status := OKC_API.HANDLE_EXCEPTIONS
124: (
125: l_api_name,
126: G_PKG_NAME,
127: 'OTHERS',

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

134:
135:
136: PROCEDURE insert_btn_pr(
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_btn_pr_tbl IN btn_pr_tbl_type,

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

142: p_btn_pr_tbl IN btn_pr_tbl_type,
143: x_btn_pr_tbl OUT NOCOPY btn_pr_tbl_type)
144: Is
145: l_api_name CONSTANT VARCHAR2(30) := 'insert_btn_pr';
146: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
147: l_ptr BINARY_INTEGER;
148:
149: Begin
150:

Line 151: x_return_status := OKC_API.G_RET_STS_SUCCESS;

147: l_ptr BINARY_INTEGER;
148:
149: Begin
150:
151: x_return_status := OKC_API.G_RET_STS_SUCCESS;
152:
153: If p_btn_pr_tbl.COUNT > 0 Then
154:
155: l_ptr := p_btn_pr_tbl.FIRST;

Line 169: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then

165: ,p_btn_pr_tbl(l_ptr)
166: ,x_btn_pr_tbl(l_ptr)
167: );
168:
169: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
170: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
171: x_return_status := l_return_status;
172: Raise G_EXCEPTION_HALT_VALIDATION;
173: Else

Line 170: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

166: ,x_btn_pr_tbl(l_ptr)
167: );
168:
169: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
170: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
171: x_return_status := l_return_status;
172: Raise G_EXCEPTION_HALT_VALIDATION;
173: Else
174: x_return_status := l_return_status;

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

185: Exception
186: When G_EXCEPTION_HALT_VALIDATION Then
187: Null;
188: When OTHERS Then
189: OKC_API.set_message(p_app_name => g_app_name,
190: p_msg_name => g_unexpected_error,
191: p_token1 => g_sqlcode_token,
192: p_token1_value => sqlcode,
193: p_token2 => g_sqlerrm_token,

Line 196: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

192: p_token1_value => sqlcode,
193: p_token2 => g_sqlerrm_token,
194: p_token2_value => sqlerrm
195: );
196: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
197: End;
198:
199:
200: /*

Line 203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

199:
200: /*
201: PROCEDURE lock_btn_pr(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_btn_pr_rec IN btn_pr_rec_type)

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

208: Is
209:
210: l_api_name CONSTANT VARCHAR2(30) := 'insert_btn_pr';
211: l_api_version CONSTANT NUMBER := 1.0;
212: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
213: l_btn_pr_rec btn_pr_rec_type;
214:
215: Begin
216:

Line 217: l_return_status := OKC_API.START_ACTIVITY

213: l_btn_pr_rec btn_pr_rec_type;
214:
215: Begin
216:
217: l_return_status := OKC_API.START_ACTIVITY
218: (
219: l_api_name
220: ,p_init_msg_list
221: ,'_PUB'

Line 225: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

221: ,'_PUB'
222: ,x_return_status
223: );
224:
225: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
226: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
227: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
228: Raise OKC_API.G_EXCEPTION_ERROR;
229: End If;

Line 226: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

222: ,x_return_status
223: );
224:
225: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
226: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
227: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
228: Raise OKC_API.G_EXCEPTION_ERROR;
229: End If;
230:

Line 227: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then

223: );
224:
225: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
226: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
227: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
228: Raise OKC_API.G_EXCEPTION_ERROR;
229: End If;
230:
231: OKS_BTN_PRINT_PREVIEW_PVT.lock_row

Line 228: Raise OKC_API.G_EXCEPTION_ERROR;

224:
225: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
226: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
227: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
228: Raise OKC_API.G_EXCEPTION_ERROR;
229: End If;
230:
231: OKS_BTN_PRINT_PREVIEW_PVT.lock_row
232: (

Line 241: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

237: x_msg_data ,
238: p_btn_pr_rec
239: );
240:
241: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
242: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
244: raise OKC_API.G_EXCEPTION_ERROR;
245: End If;

Line 242: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

238: p_btn_pr_rec
239: );
240:
241: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
242: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
244: raise OKC_API.G_EXCEPTION_ERROR;
245: End If;
246:

Line 243: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

239: );
240:
241: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
242: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
244: raise OKC_API.G_EXCEPTION_ERROR;
245: End If;
246:
247: OKC_API.END_ACTIVITY

Line 244: raise OKC_API.G_EXCEPTION_ERROR;

240:
241: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
242: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
243: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
244: raise OKC_API.G_EXCEPTION_ERROR;
245: End If;
246:
247: OKC_API.END_ACTIVITY
248: (

Line 247: OKC_API.END_ACTIVITY

243: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
244: raise OKC_API.G_EXCEPTION_ERROR;
245: End If;
246:
247: OKC_API.END_ACTIVITY
248: (
249: x_msg_count => x_msg_count,
250: x_msg_data => x_msg_data
251: );

Line 254: When OKC_API.G_EXCEPTION_ERROR THEN

250: x_msg_data => x_msg_data
251: );
252:
253: Exception
254: When OKC_API.G_EXCEPTION_ERROR THEN
255: x_return_status := OKC_API.HANDLE_EXCEPTIONS
256: (
257: l_api_name,
258: G_PKG_NAME,

Line 255: x_return_status := OKC_API.HANDLE_EXCEPTIONS

251: );
252:
253: Exception
254: When OKC_API.G_EXCEPTION_ERROR THEN
255: x_return_status := OKC_API.HANDLE_EXCEPTIONS
256: (
257: l_api_name,
258: G_PKG_NAME,
259: 'OKC_API.G_RET_STS_ERROR',

Line 259: 'OKC_API.G_RET_STS_ERROR',

255: x_return_status := OKC_API.HANDLE_EXCEPTIONS
256: (
257: l_api_name,
258: G_PKG_NAME,
259: 'OKC_API.G_RET_STS_ERROR',
260: x_msg_count,
261: x_msg_data,
262: '_PVT'
263: );

Line 265: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

261: x_msg_data,
262: '_PVT'
263: );
264:
265: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
266: x_return_status := OKC_API.HANDLE_EXCEPTIONS
267: (
268: l_api_name,
269: G_PKG_NAME,

Line 266: x_return_status := OKC_API.HANDLE_EXCEPTIONS

262: '_PVT'
263: );
264:
265: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
266: x_return_status := OKC_API.HANDLE_EXCEPTIONS
267: (
268: l_api_name,
269: G_PKG_NAME,
270: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 270: 'OKC_API.G_RET_STS_UNEXP_ERROR',

266: x_return_status := OKC_API.HANDLE_EXCEPTIONS
267: (
268: l_api_name,
269: G_PKG_NAME,
270: 'OKC_API.G_RET_STS_UNEXP_ERROR',
271: x_msg_count,
272: x_msg_data,
273: '_PVT'
274: );

Line 277: x_return_status := OKC_API.HANDLE_EXCEPTIONS

273: '_PVT'
274: );
275:
276: When OTHERS THEN
277: x_return_status := OKC_API.HANDLE_EXCEPTIONS
278: (
279: l_api_name,
280: G_PKG_NAME,
281: 'OTHERS',

Line 292: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

288:
289:
290: PROCEDURE lock_btn_pr(
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
296: p_btn_pr_tbl IN btn_pr_tbl_type)

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

296: p_btn_pr_tbl IN btn_pr_tbl_type)
297:
298: Is
299: l_api_name CONSTANT VARCHAR2(30) := 'insert_btn_pr';
300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
301: l_ptr BINARY_INTEGER;
302:
303: Begin
304:

Line 305: x_return_status := OKC_API.G_RET_STS_SUCCESS;

301: l_ptr BINARY_INTEGER;
302:
303: Begin
304:
305: x_return_status := OKC_API.G_RET_STS_SUCCESS;
306:
307: If p_btn_pr_tbl.COUNT > 0 Then
308:
309: l_ptr := p_btn_pr_tbl.FIRST;

Line 323: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then

319: ,x_msg_data
320: ,p_btn_pr_tbl(l_ptr)
321: );
322:
323: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
324: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
325: x_return_status := l_return_status;
326: Raise G_EXCEPTION_HALT_VALIDATION;
327: Else

Line 324: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

320: ,p_btn_pr_tbl(l_ptr)
321: );
322:
323: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
324: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
325: x_return_status := l_return_status;
326: Raise G_EXCEPTION_HALT_VALIDATION;
327: Else
328: x_return_status := l_return_status;

Line 340: When OKC_API.G_EXCEPTION_ERROR THEN

336:
337: End If;
338:
339: Exception
340: When OKC_API.G_EXCEPTION_ERROR THEN
341: x_return_status := OKC_API.HANDLE_EXCEPTIONS
342: (
343: l_api_name,
344: G_PKG_NAME,

Line 341: x_return_status := OKC_API.HANDLE_EXCEPTIONS

337: End If;
338:
339: Exception
340: When OKC_API.G_EXCEPTION_ERROR THEN
341: x_return_status := OKC_API.HANDLE_EXCEPTIONS
342: (
343: l_api_name,
344: G_PKG_NAME,
345: 'OKC_API.G_RET_STS_ERROR',

Line 345: 'OKC_API.G_RET_STS_ERROR',

341: x_return_status := OKC_API.HANDLE_EXCEPTIONS
342: (
343: l_api_name,
344: G_PKG_NAME,
345: 'OKC_API.G_RET_STS_ERROR',
346: x_msg_count,
347: x_msg_data,
348: '_PVT'
349: );

Line 351: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

347: x_msg_data,
348: '_PVT'
349: );
350:
351: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
352: x_return_status := OKC_API.HANDLE_EXCEPTIONS
353: (
354: l_api_name,
355: G_PKG_NAME,

Line 352: x_return_status := OKC_API.HANDLE_EXCEPTIONS

348: '_PVT'
349: );
350:
351: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
352: x_return_status := OKC_API.HANDLE_EXCEPTIONS
353: (
354: l_api_name,
355: G_PKG_NAME,
356: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 356: 'OKC_API.G_RET_STS_UNEXP_ERROR',

352: x_return_status := OKC_API.HANDLE_EXCEPTIONS
353: (
354: l_api_name,
355: G_PKG_NAME,
356: 'OKC_API.G_RET_STS_UNEXP_ERROR',
357: x_msg_count,
358: x_msg_data,
359: '_PVT'
360: );

Line 363: x_return_status := OKC_API.HANDLE_EXCEPTIONS

359: '_PVT'
360: );
361:
362: When OTHERS THEN
363: x_return_status := OKC_API.HANDLE_EXCEPTIONS
364: (
365: l_api_name,
366: G_PKG_NAME,
367: 'OTHERS',

Line 379: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

375:
376: */
377: PROCEDURE update_btn_pr(
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
380: x_return_status OUT NOCOPY VARCHAR2,
381: x_msg_count OUT NOCOPY NUMBER,
382: x_msg_data OUT NOCOPY VARCHAR2,
383: p_btn_pr_rec IN btn_pr_rec_type,

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

385: Is
386:
387: l_api_name CONSTANT VARCHAR2(30) := 'update_btn_pr';
388: l_api_version CONSTANT NUMBER := 1.0;
389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
390: l_btn_pr_rec btn_pr_rec_type;
391:
392: Begin
393:

Line 394: l_return_status := OKC_API.START_ACTIVITY

390: l_btn_pr_rec btn_pr_rec_type;
391:
392: Begin
393:
394: l_return_status := OKC_API.START_ACTIVITY
395: (
396: l_api_name
397: ,p_init_msg_list
398: ,'_PUB'

Line 402: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

398: ,'_PUB'
399: ,x_return_status
400: );
401:
402: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
403: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
405: Raise OKC_API.G_EXCEPTION_ERROR;
406: End If;

Line 403: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

399: ,x_return_status
400: );
401:
402: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
403: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
405: Raise OKC_API.G_EXCEPTION_ERROR;
406: End If;
407:

Line 404: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then

400: );
401:
402: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
403: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
405: Raise OKC_API.G_EXCEPTION_ERROR;
406: End If;
407:
408: g_btn_pr_rec := p_btn_pr_rec;

Line 405: Raise OKC_API.G_EXCEPTION_ERROR;

401:
402: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
403: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
404: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
405: Raise OKC_API.G_EXCEPTION_ERROR;
406: End If;
407:
408: g_btn_pr_rec := p_btn_pr_rec;
409:

Line 418: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then

414: p_procedure_name => l_api_name,
415: p_before_after => 'B'
416: );
417:
418: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
419: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
421: raise OKC_API.G_EXCEPTION_ERROR;
422: End If;

Line 419: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

415: p_before_after => 'B'
416: );
417:
418: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
419: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
421: raise OKC_API.G_EXCEPTION_ERROR;
422: End If;
423:

Line 420: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then

416: );
417:
418: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
419: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
421: raise OKC_API.G_EXCEPTION_ERROR;
422: End If;
423:
424: --Restore ID/OBJECT VERSION NUMBER

Line 421: raise OKC_API.G_EXCEPTION_ERROR;

417:
418: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
419: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
420: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
421: raise OKC_API.G_EXCEPTION_ERROR;
422: End If;
423:
424: --Restore ID/OBJECT VERSION NUMBER
425:

Line 441: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

437: l_btn_pr_rec ,
438: x_btn_pr_rec
439: );
440:
441: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
442: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
444: raise OKC_API.G_EXCEPTION_ERROR;
445: End If;

Line 442: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

438: x_btn_pr_rec
439: );
440:
441: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
442: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
444: raise OKC_API.G_EXCEPTION_ERROR;
445: End If;
446:

Line 443: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

439: );
440:
441: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
442: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
444: raise OKC_API.G_EXCEPTION_ERROR;
445: End If;
446:
447: g_btn_pr_rec := x_btn_pr_rec;

Line 444: raise OKC_API.G_EXCEPTION_ERROR;

440:
441: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
442: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
444: raise OKC_API.G_EXCEPTION_ERROR;
445: End If;
446:
447: g_btn_pr_rec := x_btn_pr_rec;
448:

Line 457: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

453: p_procedure_name => l_api_name,
454: p_before_after => 'A'
455: );
456:
457: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
458: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
459: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
460: raise OKC_API.G_EXCEPTION_ERROR;
461: End If;

Line 458: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

454: p_before_after => 'A'
455: );
456:
457: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
458: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
459: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
460: raise OKC_API.G_EXCEPTION_ERROR;
461: End If;
462:

Line 459: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

455: );
456:
457: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
458: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
459: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
460: raise OKC_API.G_EXCEPTION_ERROR;
461: End If;
462:
463: OKC_API.END_ACTIVITY

Line 460: raise OKC_API.G_EXCEPTION_ERROR;

456:
457: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
458: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
459: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
460: raise OKC_API.G_EXCEPTION_ERROR;
461: End If;
462:
463: OKC_API.END_ACTIVITY
464: (

Line 463: OKC_API.END_ACTIVITY

459: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
460: raise OKC_API.G_EXCEPTION_ERROR;
461: End If;
462:
463: OKC_API.END_ACTIVITY
464: (
465: x_msg_count => x_msg_count,
466: x_msg_data => x_msg_data
467: );

Line 470: When OKC_API.G_EXCEPTION_ERROR THEN

466: x_msg_data => x_msg_data
467: );
468:
469: Exception
470: When OKC_API.G_EXCEPTION_ERROR THEN
471: x_return_status := OKC_API.HANDLE_EXCEPTIONS
472: (
473: l_api_name,
474: G_PKG_NAME,

Line 471: x_return_status := OKC_API.HANDLE_EXCEPTIONS

467: );
468:
469: Exception
470: When OKC_API.G_EXCEPTION_ERROR THEN
471: x_return_status := OKC_API.HANDLE_EXCEPTIONS
472: (
473: l_api_name,
474: G_PKG_NAME,
475: 'OKC_API.G_RET_STS_ERROR',

Line 475: 'OKC_API.G_RET_STS_ERROR',

471: x_return_status := OKC_API.HANDLE_EXCEPTIONS
472: (
473: l_api_name,
474: G_PKG_NAME,
475: 'OKC_API.G_RET_STS_ERROR',
476: x_msg_count,
477: x_msg_data,
478: '_PVT'
479: );

Line 481: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

477: x_msg_data,
478: '_PVT'
479: );
480:
481: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
482: x_return_status := OKC_API.HANDLE_EXCEPTIONS
483: (
484: l_api_name,
485: G_PKG_NAME,

Line 482: x_return_status := OKC_API.HANDLE_EXCEPTIONS

478: '_PVT'
479: );
480:
481: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
482: x_return_status := OKC_API.HANDLE_EXCEPTIONS
483: (
484: l_api_name,
485: G_PKG_NAME,
486: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 486: 'OKC_API.G_RET_STS_UNEXP_ERROR',

482: x_return_status := OKC_API.HANDLE_EXCEPTIONS
483: (
484: l_api_name,
485: G_PKG_NAME,
486: 'OKC_API.G_RET_STS_UNEXP_ERROR',
487: x_msg_count,
488: x_msg_data,
489: '_PVT'
490: );

Line 493: x_return_status := OKC_API.HANDLE_EXCEPTIONS

489: '_PVT'
490: );
491:
492: When OTHERS THEN
493: x_return_status := OKC_API.HANDLE_EXCEPTIONS
494: (
495: l_api_name,
496: G_PKG_NAME,
497: 'OTHERS',

Line 508: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

504:
505:
506: PROCEDURE update_btn_pr(
507: p_api_version IN NUMBER,
508: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
509: x_return_status OUT NOCOPY VARCHAR2,
510: x_msg_count OUT NOCOPY NUMBER,
511: x_msg_data OUT NOCOPY VARCHAR2,
512: p_btn_pr_tbl IN btn_pr_tbl_type,

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

512: p_btn_pr_tbl IN btn_pr_tbl_type,
513: x_btn_pr_tbl OUT NOCOPY btn_pr_tbl_type)
514: Is
515: l_api_name CONSTANT VARCHAR2(30) := 'update_btn_pr';
516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
517: l_ptr BINARY_INTEGER;
518:
519: Begin
520:

Line 521: x_return_status := OKC_API.G_RET_STS_SUCCESS;

517: l_ptr BINARY_INTEGER;
518:
519: Begin
520:
521: x_return_status := OKC_API.G_RET_STS_SUCCESS;
522:
523: If p_btn_pr_tbl.COUNT > 0 Then
524:
525: l_ptr := p_btn_pr_tbl.FIRST;

Line 539: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then

535: ,p_btn_pr_tbl(l_ptr)
536: ,x_btn_pr_tbl(l_ptr)
537: );
538:
539: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
540: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
541: x_return_status := l_return_status;
542: Raise G_EXCEPTION_HALT_VALIDATION;
543: Else

Line 540: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

536: ,x_btn_pr_tbl(l_ptr)
537: );
538:
539: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
540: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
541: x_return_status := l_return_status;
542: Raise G_EXCEPTION_HALT_VALIDATION;
543: Else
544: x_return_status := l_return_status;

Line 556: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

552:
553: End If;
554:
555: Exception
556: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS
558: (
559: l_api_name,
560: G_PKG_NAME,

Line 557: x_return_status := OKC_API.HANDLE_EXCEPTIONS

553: End If;
554:
555: Exception
556: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS
558: (
559: l_api_name,
560: G_PKG_NAME,
561: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 561: 'OKC_API.G_RET_STS_UNEXP_ERROR',

557: x_return_status := OKC_API.HANDLE_EXCEPTIONS
558: (
559: l_api_name,
560: G_PKG_NAME,
561: 'OKC_API.G_RET_STS_UNEXP_ERROR',
562: x_msg_count,
563: x_msg_data,
564: '_PVT'
565: );

Line 568: x_return_status := OKC_API.HANDLE_EXCEPTIONS

564: '_PVT'
565: );
566:
567: When OTHERS THEN
568: x_return_status := OKC_API.HANDLE_EXCEPTIONS
569: (
570: l_api_name,
571: G_PKG_NAME,
572: 'OTHERS',

Line 583: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

579:
580:
581: PROCEDURE delete_btn_pr(
582: p_api_version IN NUMBER,
583: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,
587: p_btn_pr_rec IN btn_pr_rec_type)

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

588: Is
589:
590: l_api_name CONSTANT VARCHAR2(30) := 'update_btn_pr';
591: l_api_version CONSTANT NUMBER := 1.0;
592: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
593: l_btn_pr_rec btn_pr_rec_type;
594:
595: Begin
596:

Line 597: l_return_status := OKC_API.START_ACTIVITY

593: l_btn_pr_rec btn_pr_rec_type;
594:
595: Begin
596:
597: l_return_status := OKC_API.START_ACTIVITY
598: (
599: l_api_name
600: ,p_init_msg_list
601: ,'_PUB'

Line 605: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

601: ,'_PUB'
602: ,x_return_status
603: );
604:
605: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
606: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
607: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
608: Raise OKC_API.G_EXCEPTION_ERROR;
609: End If;

Line 606: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

602: ,x_return_status
603: );
604:
605: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
606: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
607: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
608: Raise OKC_API.G_EXCEPTION_ERROR;
609: End If;
610:

Line 607: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then

603: );
604:
605: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
606: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
607: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
608: Raise OKC_API.G_EXCEPTION_ERROR;
609: End If;
610:
611: g_btn_pr_rec := p_btn_pr_rec;

Line 608: Raise OKC_API.G_EXCEPTION_ERROR;

604:
605: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
606: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
607: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
608: Raise OKC_API.G_EXCEPTION_ERROR;
609: End If;
610:
611: g_btn_pr_rec := p_btn_pr_rec;
612:

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

617: p_procedure_name => l_api_name,
618: p_before_after => 'B'
619: );
620:
621: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
622: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
624: raise OKC_API.G_EXCEPTION_ERROR;
625: End If;

Line 622: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

618: p_before_after => 'B'
619: );
620:
621: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
622: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
624: raise OKC_API.G_EXCEPTION_ERROR;
625: End If;
626:

Line 623: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then

619: );
620:
621: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
622: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
624: raise OKC_API.G_EXCEPTION_ERROR;
625: End If;
626:
627: --Restore ID/OBJECT VERSION NUMBER

Line 624: raise OKC_API.G_EXCEPTION_ERROR;

620:
621: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
622: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
623: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
624: raise OKC_API.G_EXCEPTION_ERROR;
625: End If;
626:
627: --Restore ID/OBJECT VERSION NUMBER
628:

Line 643: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

639: x_msg_data ,
640: l_btn_pr_rec
641: );
642:
643: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
644: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
645: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
646: raise OKC_API.G_EXCEPTION_ERROR;
647: End If;

Line 644: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

640: l_btn_pr_rec
641: );
642:
643: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
644: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
645: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
646: raise OKC_API.G_EXCEPTION_ERROR;
647: End If;
648:

Line 645: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

641: );
642:
643: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
644: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
645: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
646: raise OKC_API.G_EXCEPTION_ERROR;
647: End If;
648:
649: OKC_UTIL.call_user_hook

Line 646: raise OKC_API.G_EXCEPTION_ERROR;

642:
643: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
644: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
645: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
646: raise OKC_API.G_EXCEPTION_ERROR;
647: End If;
648:
649: OKC_UTIL.call_user_hook
650: (

Line 657: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

653: p_procedure_name => l_api_name,
654: p_before_after => 'A'
655: );
656:
657: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
658: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
659: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
660: raise OKC_API.G_EXCEPTION_ERROR;
661: End If;

Line 658: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

654: p_before_after => 'A'
655: );
656:
657: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
658: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
659: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
660: raise OKC_API.G_EXCEPTION_ERROR;
661: End If;
662:

Line 659: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

655: );
656:
657: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
658: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
659: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
660: raise OKC_API.G_EXCEPTION_ERROR;
661: End If;
662:
663: OKC_API.END_ACTIVITY

Line 660: raise OKC_API.G_EXCEPTION_ERROR;

656:
657: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
658: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
659: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
660: raise OKC_API.G_EXCEPTION_ERROR;
661: End If;
662:
663: OKC_API.END_ACTIVITY
664: (

Line 663: OKC_API.END_ACTIVITY

659: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
660: raise OKC_API.G_EXCEPTION_ERROR;
661: End If;
662:
663: OKC_API.END_ACTIVITY
664: (
665: x_msg_count => x_msg_count,
666: x_msg_data => x_msg_data
667: );

Line 670: When OKC_API.G_EXCEPTION_ERROR THEN

666: x_msg_data => x_msg_data
667: );
668:
669: Exception
670: When OKC_API.G_EXCEPTION_ERROR THEN
671: x_return_status := OKC_API.HANDLE_EXCEPTIONS
672: (
673: l_api_name,
674: G_PKG_NAME,

Line 671: x_return_status := OKC_API.HANDLE_EXCEPTIONS

667: );
668:
669: Exception
670: When OKC_API.G_EXCEPTION_ERROR THEN
671: x_return_status := OKC_API.HANDLE_EXCEPTIONS
672: (
673: l_api_name,
674: G_PKG_NAME,
675: 'OKC_API.G_RET_STS_ERROR',

Line 675: 'OKC_API.G_RET_STS_ERROR',

671: x_return_status := OKC_API.HANDLE_EXCEPTIONS
672: (
673: l_api_name,
674: G_PKG_NAME,
675: 'OKC_API.G_RET_STS_ERROR',
676: x_msg_count,
677: x_msg_data,
678: '_PVT'
679: );

Line 681: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

677: x_msg_data,
678: '_PVT'
679: );
680:
681: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
682: x_return_status := OKC_API.HANDLE_EXCEPTIONS
683: (
684: l_api_name,
685: G_PKG_NAME,

Line 682: x_return_status := OKC_API.HANDLE_EXCEPTIONS

678: '_PVT'
679: );
680:
681: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
682: x_return_status := OKC_API.HANDLE_EXCEPTIONS
683: (
684: l_api_name,
685: G_PKG_NAME,
686: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 686: 'OKC_API.G_RET_STS_UNEXP_ERROR',

682: x_return_status := OKC_API.HANDLE_EXCEPTIONS
683: (
684: l_api_name,
685: G_PKG_NAME,
686: 'OKC_API.G_RET_STS_UNEXP_ERROR',
687: x_msg_count,
688: x_msg_data,
689: '_PVT'
690: );

Line 693: x_return_status := OKC_API.HANDLE_EXCEPTIONS

689: '_PVT'
690: );
691:
692: When OTHERS THEN
693: x_return_status := OKC_API.HANDLE_EXCEPTIONS
694: (
695: l_api_name,
696: G_PKG_NAME,
697: 'OTHERS',

Line 708: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

704:
705:
706: PROCEDURE delete_btn_pr(
707: p_api_version IN NUMBER,
708: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
709: x_return_status OUT NOCOPY VARCHAR2,
710: x_msg_count OUT NOCOPY NUMBER,
711: x_msg_data OUT NOCOPY VARCHAR2,
712: p_btn_pr_tbl IN btn_pr_tbl_type)

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

711: x_msg_data OUT NOCOPY VARCHAR2,
712: p_btn_pr_tbl IN btn_pr_tbl_type)
713: Is
714: l_api_name CONSTANT VARCHAR2(30) := 'update_btn_pr';
715: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
716: l_ptr BINARY_INTEGER;
717:
718: Begin
719:

Line 720: x_return_status := OKC_API.G_RET_STS_SUCCESS;

716: l_ptr BINARY_INTEGER;
717:
718: Begin
719:
720: x_return_status := OKC_API.G_RET_STS_SUCCESS;
721:
722: If p_btn_pr_tbl.COUNT > 0 Then
723:
724: l_ptr := p_btn_pr_tbl.FIRST;

Line 736: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then

732: ,x_msg_data
733: ,p_btn_pr_tbl(l_ptr)
734: );
735:
736: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
737: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
738: x_return_status := l_return_status;
739: Raise G_EXCEPTION_HALT_VALIDATION;
740: Else

Line 737: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

733: ,p_btn_pr_tbl(l_ptr)
734: );
735:
736: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
737: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
738: x_return_status := l_return_status;
739: Raise G_EXCEPTION_HALT_VALIDATION;
740: Else
741: x_return_status := l_return_status;

Line 753: When OKC_API.G_EXCEPTION_ERROR THEN

749:
750: End If;
751:
752: Exception
753: When OKC_API.G_EXCEPTION_ERROR THEN
754: x_return_status := OKC_API.HANDLE_EXCEPTIONS
755: (
756: l_api_name,
757: G_PKG_NAME,

Line 754: x_return_status := OKC_API.HANDLE_EXCEPTIONS

750: End If;
751:
752: Exception
753: When OKC_API.G_EXCEPTION_ERROR THEN
754: x_return_status := OKC_API.HANDLE_EXCEPTIONS
755: (
756: l_api_name,
757: G_PKG_NAME,
758: 'OKC_API.G_RET_STS_ERROR',

Line 758: 'OKC_API.G_RET_STS_ERROR',

754: x_return_status := OKC_API.HANDLE_EXCEPTIONS
755: (
756: l_api_name,
757: G_PKG_NAME,
758: 'OKC_API.G_RET_STS_ERROR',
759: x_msg_count,
760: x_msg_data,
761: '_PVT'
762: );

Line 764: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

760: x_msg_data,
761: '_PVT'
762: );
763:
764: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
765: x_return_status := OKC_API.HANDLE_EXCEPTIONS
766: (
767: l_api_name,
768: G_PKG_NAME,

Line 765: x_return_status := OKC_API.HANDLE_EXCEPTIONS

761: '_PVT'
762: );
763:
764: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
765: x_return_status := OKC_API.HANDLE_EXCEPTIONS
766: (
767: l_api_name,
768: G_PKG_NAME,
769: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 769: 'OKC_API.G_RET_STS_UNEXP_ERROR',

765: x_return_status := OKC_API.HANDLE_EXCEPTIONS
766: (
767: l_api_name,
768: G_PKG_NAME,
769: 'OKC_API.G_RET_STS_UNEXP_ERROR',
770: x_msg_count,
771: x_msg_data,
772: '_PVT'
773: );

Line 776: x_return_status := OKC_API.HANDLE_EXCEPTIONS

772: '_PVT'
773: );
774:
775: When OTHERS THEN
776: x_return_status := OKC_API.HANDLE_EXCEPTIONS
777: (
778: l_api_name,
779: G_PKG_NAME,
780: 'OTHERS',

Line 791: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

787:
788:
789: PROCEDURE validate_btn_pr(
790: p_api_version IN NUMBER,
791: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
792: x_return_status OUT NOCOPY VARCHAR2,
793: x_msg_count OUT NOCOPY NUMBER,
794: x_msg_data OUT NOCOPY VARCHAR2,
795: p_btn_pr_rec IN btn_pr_rec_type)

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

796: Is
797:
798: l_api_name CONSTANT VARCHAR2(30) := 'update_btn_pr';
799: l_api_version CONSTANT NUMBER := 1.0;
800: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
801: l_btn_pr_rec btn_pr_rec_type;
802:
803: Begin
804:

Line 805: l_return_status := OKC_API.START_ACTIVITY

801: l_btn_pr_rec btn_pr_rec_type;
802:
803: Begin
804:
805: l_return_status := OKC_API.START_ACTIVITY
806: (
807: l_api_name
808: ,p_init_msg_list
809: ,'_PUB'

Line 813: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

809: ,'_PUB'
810: ,x_return_status
811: );
812:
813: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
814: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
816: Raise OKC_API.G_EXCEPTION_ERROR;
817: End If;

Line 814: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

810: ,x_return_status
811: );
812:
813: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
814: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
816: Raise OKC_API.G_EXCEPTION_ERROR;
817: End If;
818:

Line 815: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then

811: );
812:
813: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
814: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
816: Raise OKC_API.G_EXCEPTION_ERROR;
817: End If;
818:
819: g_btn_pr_rec := p_btn_pr_rec;

Line 816: Raise OKC_API.G_EXCEPTION_ERROR;

812:
813: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
814: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: ElsIf l_return_status = OKC_API.G_RET_STS_ERROR Then
816: Raise OKC_API.G_EXCEPTION_ERROR;
817: End If;
818:
819: g_btn_pr_rec := p_btn_pr_rec;
820:

Line 829: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then

825: p_procedure_name => l_api_name,
826: p_before_after => 'B'
827: );
828:
829: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
830: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
832: raise OKC_API.G_EXCEPTION_ERROR;
833: End If;

Line 830: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

826: p_before_after => 'B'
827: );
828:
829: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
830: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
832: raise OKC_API.G_EXCEPTION_ERROR;
833: End If;
834:

Line 831: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then

827: );
828:
829: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
830: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
832: raise OKC_API.G_EXCEPTION_ERROR;
833: End If;
834:
835: --Restore ID/OBJECT VERSION NUMBER

Line 832: raise OKC_API.G_EXCEPTION_ERROR;

828:
829: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) Then
830: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ElsIf (x_return_status = OKC_API.G_RET_STS_ERROR) Then
832: raise OKC_API.G_EXCEPTION_ERROR;
833: End If;
834:
835: --Restore ID/OBJECT VERSION NUMBER
836:

Line 851: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

847: x_msg_data ,
848: l_btn_pr_rec
849: );
850:
851: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
854: raise OKC_API.G_EXCEPTION_ERROR;
855: End If;

Line 852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

848: l_btn_pr_rec
849: );
850:
851: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
854: raise OKC_API.G_EXCEPTION_ERROR;
855: End If;
856:

Line 853: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

849: );
850:
851: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
854: raise OKC_API.G_EXCEPTION_ERROR;
855: End If;
856:
857: OKC_UTIL.call_user_hook

Line 854: raise OKC_API.G_EXCEPTION_ERROR;

850:
851: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
854: raise OKC_API.G_EXCEPTION_ERROR;
855: End If;
856:
857: OKC_UTIL.call_user_hook
858: (

Line 865: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

861: p_procedure_name => l_api_name,
862: p_before_after => 'A'
863: );
864:
865: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
866: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
867: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
868: raise OKC_API.G_EXCEPTION_ERROR;
869: End If;

Line 866: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

862: p_before_after => 'A'
863: );
864:
865: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
866: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
867: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
868: raise OKC_API.G_EXCEPTION_ERROR;
869: End If;
870:

Line 867: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then

863: );
864:
865: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
866: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
867: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
868: raise OKC_API.G_EXCEPTION_ERROR;
869: End If;
870:
871: OKC_API.END_ACTIVITY

Line 868: raise OKC_API.G_EXCEPTION_ERROR;

864:
865: If x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
866: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
867: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
868: raise OKC_API.G_EXCEPTION_ERROR;
869: End If;
870:
871: OKC_API.END_ACTIVITY
872: (

Line 871: OKC_API.END_ACTIVITY

867: Elsif x_return_status = OKC_API.G_RET_STS_ERROR Then
868: raise OKC_API.G_EXCEPTION_ERROR;
869: End If;
870:
871: OKC_API.END_ACTIVITY
872: (
873: x_msg_count => x_msg_count,
874: x_msg_data => x_msg_data
875: );

Line 879: When OKC_API.G_EXCEPTION_ERROR THEN

875: );
876:
877:
878: Exception
879: When OKC_API.G_EXCEPTION_ERROR THEN
880: x_return_status := OKC_API.HANDLE_EXCEPTIONS
881: (
882: l_api_name,
883: G_PKG_NAME,

Line 880: x_return_status := OKC_API.HANDLE_EXCEPTIONS

876:
877:
878: Exception
879: When OKC_API.G_EXCEPTION_ERROR THEN
880: x_return_status := OKC_API.HANDLE_EXCEPTIONS
881: (
882: l_api_name,
883: G_PKG_NAME,
884: 'OKC_API.G_RET_STS_ERROR',

Line 884: 'OKC_API.G_RET_STS_ERROR',

880: x_return_status := OKC_API.HANDLE_EXCEPTIONS
881: (
882: l_api_name,
883: G_PKG_NAME,
884: 'OKC_API.G_RET_STS_ERROR',
885: x_msg_count,
886: x_msg_data,
887: '_PVT'
888: );

Line 890: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

886: x_msg_data,
887: '_PVT'
888: );
889:
890: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
891: x_return_status := OKC_API.HANDLE_EXCEPTIONS
892: (
893: l_api_name,
894: G_PKG_NAME,

Line 891: x_return_status := OKC_API.HANDLE_EXCEPTIONS

887: '_PVT'
888: );
889:
890: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
891: x_return_status := OKC_API.HANDLE_EXCEPTIONS
892: (
893: l_api_name,
894: G_PKG_NAME,
895: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 895: 'OKC_API.G_RET_STS_UNEXP_ERROR',

891: x_return_status := OKC_API.HANDLE_EXCEPTIONS
892: (
893: l_api_name,
894: G_PKG_NAME,
895: 'OKC_API.G_RET_STS_UNEXP_ERROR',
896: x_msg_count,
897: x_msg_data,
898: '_PVT'
899: );

Line 902: x_return_status := OKC_API.HANDLE_EXCEPTIONS

898: '_PVT'
899: );
900:
901: When OTHERS THEN
902: x_return_status := OKC_API.HANDLE_EXCEPTIONS
903: (
904: l_api_name,
905: G_PKG_NAME,
906: 'OTHERS',

Line 917: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

913:
914:
915: PROCEDURE validate_btn_pr(
916: p_api_version IN NUMBER,
917: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
918: x_return_status OUT NOCOPY VARCHAR2,
919: x_msg_count OUT NOCOPY NUMBER,
920: x_msg_data OUT NOCOPY VARCHAR2,
921: p_btn_pr_tbl IN btn_pr_tbl_type)

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

921: p_btn_pr_tbl IN btn_pr_tbl_type)
922:
923: Is
924: l_api_name CONSTANT VARCHAR2(30) := 'update_btn_pr';
925: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
926: l_ptr BINARY_INTEGER;
927:
928: Begin
929:

Line 930: x_return_status := OKC_API.G_RET_STS_SUCCESS;

926: l_ptr BINARY_INTEGER;
927:
928: Begin
929:
930: x_return_status := OKC_API.G_RET_STS_SUCCESS;
931:
932: If p_btn_pr_tbl.COUNT > 0 Then
933:
934: l_ptr := p_btn_pr_tbl.FIRST;

Line 946: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then

942: ,x_msg_data
943: ,p_btn_pr_tbl(l_ptr)
944: );
945:
946: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
947: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
948: x_return_status := l_return_status;
949: Raise G_EXCEPTION_HALT_VALIDATION;
950: Else

Line 947: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then

943: ,p_btn_pr_tbl(l_ptr)
944: );
945:
946: If l_return_status <>OKC_API.G_RET_STS_SUCCESS Then
947: If l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR Then
948: x_return_status := l_return_status;
949: Raise G_EXCEPTION_HALT_VALIDATION;
950: Else
951: x_return_status := l_return_status;

Line 963: When OKC_API.G_EXCEPTION_ERROR THEN

959:
960: End If;
961:
962: Exception
963: When OKC_API.G_EXCEPTION_ERROR THEN
964: x_return_status := OKC_API.HANDLE_EXCEPTIONS
965: (
966: l_api_name,
967: G_PKG_NAME,

Line 964: x_return_status := OKC_API.HANDLE_EXCEPTIONS

960: End If;
961:
962: Exception
963: When OKC_API.G_EXCEPTION_ERROR THEN
964: x_return_status := OKC_API.HANDLE_EXCEPTIONS
965: (
966: l_api_name,
967: G_PKG_NAME,
968: 'OKC_API.G_RET_STS_ERROR',

Line 968: 'OKC_API.G_RET_STS_ERROR',

964: x_return_status := OKC_API.HANDLE_EXCEPTIONS
965: (
966: l_api_name,
967: G_PKG_NAME,
968: 'OKC_API.G_RET_STS_ERROR',
969: x_msg_count,
970: x_msg_data,
971: '_PVT'
972: );

Line 974: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

970: x_msg_data,
971: '_PVT'
972: );
973:
974: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
975: x_return_status := OKC_API.HANDLE_EXCEPTIONS
976: (
977: l_api_name,
978: G_PKG_NAME,

Line 975: x_return_status := OKC_API.HANDLE_EXCEPTIONS

971: '_PVT'
972: );
973:
974: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
975: x_return_status := OKC_API.HANDLE_EXCEPTIONS
976: (
977: l_api_name,
978: G_PKG_NAME,
979: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 979: 'OKC_API.G_RET_STS_UNEXP_ERROR',

975: x_return_status := OKC_API.HANDLE_EXCEPTIONS
976: (
977: l_api_name,
978: G_PKG_NAME,
979: 'OKC_API.G_RET_STS_UNEXP_ERROR',
980: x_msg_count,
981: x_msg_data,
982: '_PVT'
983: );

Line 986: x_return_status := OKC_API.HANDLE_EXCEPTIONS

982: '_PVT'
983: );
984:
985: When OTHERS THEN
986: x_return_status := OKC_API.HANDLE_EXCEPTIONS
987: (
988: l_api_name,
989: G_PKG_NAME,
990: 'OTHERS',