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.OKL_FUNDING_CHECKLIST_PVT dependencies on OKL_API

Line 37: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

33: FUNCTION validate_function_id(
34: p_rulv_rec rulv_rec_type
35: ) RETURN VARCHAR2
36: IS
37: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
38: l_dummy number;
39:
40: l_row_not_found boolean := false;
41: l_function_id varchar2(100);

Line 56: l_function_id <> OKL_API.G_MISS_CHAR)

52: l_function_id := p_rulv_rec.RULE_INFORMATION9;
53: -- FK check
54: -- check only if object exists
55: IF (l_function_id IS NOT NULL AND
56: l_function_id <> OKL_API.G_MISS_CHAR)
57: THEN
58:
59: OPEN c_fun(l_function_id);
60: FETCH c_fun INTO l_dummy;

Line 65: OKL_API.Set_Message(p_app_name => G_APP_NAME,

61: l_row_not_found := c_fun%NOTFOUND;
62: CLOSE c_fun;
63:
64: IF (l_row_not_found) THEN
65: OKL_API.Set_Message(p_app_name => G_APP_NAME,
66: p_msg_name => G_INVALID_VALUE,
67: p_token1 => G_COL_NAME_TOKEN,
68: p_token1_value => 'FUNCTION_ID');
69:

Line 78: l_return_status := OKL_API.G_RET_STS_ERROR;

74: RETURN l_return_status;
75:
76: EXCEPTION
77: WHEN G_EXCEPTION_HALT_VALIDATION THEN
78: l_return_status := OKL_API.G_RET_STS_ERROR;
79: RETURN l_return_status;
80: WHEN OTHERS THEN
81: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
82: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 81: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

77: WHEN G_EXCEPTION_HALT_VALIDATION THEN
78: l_return_status := OKL_API.G_RET_STS_ERROR;
79: RETURN l_return_status;
80: WHEN OTHERS THEN
81: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
82: OKL_API.Set_Message(p_app_name => G_APP_NAME,
83: p_msg_name => G_UNEXPECTED_ERROR,
84: p_token1 => G_SQLCODE_TOKEN,
85: p_token1_value => SQLCODE,

Line 82: OKL_API.Set_Message(p_app_name => G_APP_NAME,

78: l_return_status := OKL_API.G_RET_STS_ERROR;
79: RETURN l_return_status;
80: WHEN OTHERS THEN
81: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
82: OKL_API.Set_Message(p_app_name => G_APP_NAME,
83: p_msg_name => G_UNEXPECTED_ERROR,
84: p_token1 => G_SQLCODE_TOKEN,
85: p_token1_value => SQLCODE,
86: p_token2 => G_SQLERRM_TOKEN,

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

94: p_rulv_rec rulv_rec_type,
95: p_mode varchar2
96: ) RETURN VARCHAR2
97: IS
98: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
99: l_dummy number;
100:
101: l_row_not_found boolean := false;
102: l_checklist_type varchar2(30);

Line 121: (l_checklist_type = OKL_API.G_MISS_CHAR)

117: IF (p_mode = G_INSERT_MODE) THEN
118:
119: -- column is required:
120: IF (l_checklist_type IS NULL) OR
121: (l_checklist_type = OKL_API.G_MISS_CHAR)
122: THEN
123: OKL_API.Set_Message(p_app_name => G_APP_NAME,
124: p_msg_name => G_REQUIRED_VALUE,
125: p_token1 => G_COL_NAME_TOKEN,

Line 123: OKL_API.Set_Message(p_app_name => G_APP_NAME,

119: -- column is required:
120: IF (l_checklist_type IS NULL) OR
121: (l_checklist_type = OKL_API.G_MISS_CHAR)
122: THEN
123: OKL_API.Set_Message(p_app_name => G_APP_NAME,
124: p_msg_name => G_REQUIRED_VALUE,
125: p_token1 => G_COL_NAME_TOKEN,
126: p_token1_value => 'CHECKLIST_TYPE');
127: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 135: l_checklist_type <> OKL_API.G_MISS_CHAR)

131:
132: -- FK check
133: -- check only if object exists
134: IF (l_checklist_type IS NOT NULL AND
135: l_checklist_type <> OKL_API.G_MISS_CHAR)
136: THEN
137:
138: OPEN c_lok(l_checklist_type);
139: FETCH c_lok INTO l_dummy;

Line 144: OKL_API.Set_Message(p_app_name => G_APP_NAME,

140: l_row_not_found := c_lok%NOTFOUND;
141: CLOSE c_lok;
142:
143: IF (l_row_not_found) THEN
144: OKL_API.Set_Message(p_app_name => G_APP_NAME,
145: p_msg_name => G_INVALID_VALUE,
146: p_token1 => G_COL_NAME_TOKEN,
147: p_token1_value => 'CHECKLIST_TYPE');
148:

Line 157: l_return_status := OKL_API.G_RET_STS_ERROR;

153: RETURN l_return_status;
154:
155: EXCEPTION
156: WHEN G_EXCEPTION_HALT_VALIDATION THEN
157: l_return_status := OKL_API.G_RET_STS_ERROR;
158: RETURN l_return_status;
159: WHEN OTHERS THEN
160: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
161: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 160: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

156: WHEN G_EXCEPTION_HALT_VALIDATION THEN
157: l_return_status := OKL_API.G_RET_STS_ERROR;
158: RETURN l_return_status;
159: WHEN OTHERS THEN
160: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
161: OKL_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,

Line 161: OKL_API.Set_Message(p_app_name => G_APP_NAME,

157: l_return_status := OKL_API.G_RET_STS_ERROR;
158: RETURN l_return_status;
159: WHEN OTHERS THEN
160: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
161: OKL_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 177: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

173: p_rulv_rec rulv_rec_type,
174: p_mode varchar2
175: ) RETURN VARCHAR2
176: IS
177: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
178: l_dummy number;
179:
180: l_row_not_found boolean := false;
181: l_todo_item varchar2(30);

Line 198: (p_rulv_rec.RULE_INFORMATION1 = OKL_API.G_MISS_CHAR)

194: IF (p_mode = G_INSERT_MODE) THEN
195:
196: -- column is required:
197: IF (p_rulv_rec.RULE_INFORMATION1 IS NULL) OR
198: (p_rulv_rec.RULE_INFORMATION1 = OKL_API.G_MISS_CHAR)
199: THEN
200: OKL_API.Set_Message(p_app_name => G_APP_NAME,
201: p_msg_name => G_REQUIRED_VALUE,
202: p_token1 => G_COL_NAME_TOKEN,

Line 200: OKL_API.Set_Message(p_app_name => G_APP_NAME,

196: -- column is required:
197: IF (p_rulv_rec.RULE_INFORMATION1 IS NULL) OR
198: (p_rulv_rec.RULE_INFORMATION1 = OKL_API.G_MISS_CHAR)
199: THEN
200: OKL_API.Set_Message(p_app_name => G_APP_NAME,
201: p_msg_name => G_REQUIRED_VALUE,
202: p_token1 => G_COL_NAME_TOKEN,
203: p_token1_value => 'TODO_ITEM');
204: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 212: p_rulv_rec.RULE_INFORMATION1 <> OKL_API.G_MISS_CHAR)

208:
209: -- FK check
210: -- check only if object exists
211: IF (p_rulv_rec.RULE_INFORMATION1 IS NOT NULL AND
212: p_rulv_rec.RULE_INFORMATION1 <> OKL_API.G_MISS_CHAR)
213: THEN
214:
215: OPEN c_lok(p_rulv_rec.RULE_INFORMATION1);
216: FETCH c_lok INTO l_dummy;

Line 221: OKL_API.Set_Message(p_app_name => G_APP_NAME,

217: l_row_not_found := c_lok%NOTFOUND;
218: CLOSE c_lok;
219:
220: IF (l_row_not_found) THEN
221: OKL_API.Set_Message(p_app_name => G_APP_NAME,
222: p_msg_name => G_INVALID_VALUE,
223: p_token1 => G_COL_NAME_TOKEN,
224: p_token1_value => 'TODO_ITEM');
225:

Line 234: l_return_status := OKL_API.G_RET_STS_ERROR;

230: RETURN l_return_status;
231:
232: EXCEPTION
233: WHEN G_EXCEPTION_HALT_VALIDATION THEN
234: l_return_status := OKL_API.G_RET_STS_ERROR;
235: RETURN l_return_status;
236: WHEN OTHERS THEN
237: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
238: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 237: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

233: WHEN G_EXCEPTION_HALT_VALIDATION THEN
234: l_return_status := OKL_API.G_RET_STS_ERROR;
235: RETURN l_return_status;
236: WHEN OTHERS THEN
237: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
238: OKL_API.Set_Message(p_app_name => G_APP_NAME,
239: p_msg_name => G_UNEXPECTED_ERROR,
240: p_token1 => G_SQLCODE_TOKEN,
241: p_token1_value => SQLCODE,

Line 238: OKL_API.Set_Message(p_app_name => G_APP_NAME,

234: l_return_status := OKL_API.G_RET_STS_ERROR;
235: RETURN l_return_status;
236: WHEN OTHERS THEN
237: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
238: OKL_API.Set_Message(p_app_name => G_APP_NAME,
239: p_msg_name => G_UNEXPECTED_ERROR,
240: p_token1 => G_SQLCODE_TOKEN,
241: p_token1_value => SQLCODE,
242: p_token2 => G_SQLERRM_TOKEN,

Line 253: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

249: FUNCTION validate_dup_item(
250: p_rulv_rec rulv_rec_type
251: ) RETURN VARCHAR2
252: IS
253: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
254: l_count number := 0;
255: l_row_found boolean := false;
256: l_dummy number;
257: l_item varchar2(30);

Line 274: IF p_rulv_rec.object1_id1 is not null AND p_rulv_rec.object1_id1 <> OKL_API.G_MISS_CHAR THEN

270:
271: BEGIN
272:
273: -- Fix bug when invoked by okl_funding_pvt.update_checklist_function
274: IF p_rulv_rec.object1_id1 is not null AND p_rulv_rec.object1_id1 <> OKL_API.G_MISS_CHAR THEN
275: p_freq_id := p_rulv_rec.object1_id1;
276:
277: OPEN c_unq_fun(p_freq_id);
278: FETCH c_unq_fun INTO l_dummy;

Line 283: OKL_API.Set_Message(p_app_name => G_APP_NAME,

279: l_row_found := c_unq_fun%FOUND;
280: CLOSE c_unq_fun;
281:
282: IF (l_row_found) THEN
283: OKL_API.Set_Message(p_app_name => G_APP_NAME,
284: p_msg_name => G_NOT_UNIQUE,
285: p_token1 => G_COL_NAME_TOKEN,
286: p_token1_value => 'The combinations of the Checklist Item and the Function');
287:

Line 296: l_return_status := OKL_API.G_RET_STS_ERROR;

292: RETURN l_return_status;
293:
294: EXCEPTION
295: WHEN G_EXCEPTION_HALT_VALIDATION THEN
296: l_return_status := OKL_API.G_RET_STS_ERROR;
297: RETURN l_return_status;
298: WHEN OTHERS THEN
299: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
300: OKL_API.Set_Message(p_app_name => G_APP_NAME,

Line 299: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

295: WHEN G_EXCEPTION_HALT_VALIDATION THEN
296: l_return_status := OKL_API.G_RET_STS_ERROR;
297: RETURN l_return_status;
298: WHEN OTHERS THEN
299: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
300: OKL_API.Set_Message(p_app_name => G_APP_NAME,
301: p_msg_name => G_UNEXPECTED_ERROR,
302: p_token1 => G_SQLCODE_TOKEN,
303: p_token1_value => SQLCODE,

Line 300: OKL_API.Set_Message(p_app_name => G_APP_NAME,

296: l_return_status := OKL_API.G_RET_STS_ERROR;
297: RETURN l_return_status;
298: WHEN OTHERS THEN
299: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
300: OKL_API.Set_Message(p_app_name => G_APP_NAME,
301: p_msg_name => G_UNEXPECTED_ERROR,
302: p_token1 => G_SQLCODE_TOKEN,
303: p_token1_value => SQLCODE,
304: p_token2 => G_SQLERRM_TOKEN,

Line 315: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

311: p_rulv_rec rulv_rec_type,
312: p_mode varchar2
313: ) RETURN VARCHAR2
314: IS
315: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
316: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
317:
318: BEGIN
319:

Line 316: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

312: p_mode varchar2
313: ) RETURN VARCHAR2
314: IS
315: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
316: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
317:
318: BEGIN
319:
320: -- Do formal attribute validation:

Line 323: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

319:
320: -- Do formal attribute validation:
321: l_return_status := validate_function_id(p_rulv_rec => p_rulv_rec);
322: --- Store the highest degree of error
323: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
324: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
325: x_return_status := l_return_status;
326: END IF;
327: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 324: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

320: -- Do formal attribute validation:
321: l_return_status := validate_function_id(p_rulv_rec => p_rulv_rec);
322: --- Store the highest degree of error
323: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
324: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
325: x_return_status := l_return_status;
326: END IF;
327: RAISE G_EXCEPTION_HALT_VALIDATION;
328: END IF;

Line 333: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

329:
330: l_return_status := validate_checklist_type(p_rulv_rec => p_rulv_rec,
331: p_mode => p_mode);
332: --- Store the highest degree of error
333: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
334: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: x_return_status := l_return_status;
336: END IF;
337: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 334: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

330: l_return_status := validate_checklist_type(p_rulv_rec => p_rulv_rec,
331: p_mode => p_mode);
332: --- Store the highest degree of error
333: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
334: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: x_return_status := l_return_status;
336: END IF;
337: RAISE G_EXCEPTION_HALT_VALIDATION;
338: END IF;

Line 343: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

339:
340: l_return_status := validate_todo_item(p_rulv_rec => p_rulv_rec,
341: p_mode => p_mode);
342: --- Store the highest degree of error
343: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
344: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
345: x_return_status := l_return_status;
346: END IF;
347: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 344: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

340: l_return_status := validate_todo_item(p_rulv_rec => p_rulv_rec,
341: p_mode => p_mode);
342: --- Store the highest degree of error
343: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
344: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
345: x_return_status := l_return_status;
346: END IF;
347: RAISE G_EXCEPTION_HALT_VALIDATION;
348: END IF;

Line 355: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

351: EXCEPTION
352: WHEN G_EXCEPTION_HALT_VALIDATION THEN
353: RETURN x_return_status;
354: WHEN OTHERS THEN
355: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
356: OKL_API.Set_Message(p_app_name => G_APP_NAME,
357: p_msg_name => G_UNEXPECTED_ERROR,
358: p_token1 => G_SQLCODE_TOKEN,
359: p_token1_value => SQLCODE,

Line 356: OKL_API.Set_Message(p_app_name => G_APP_NAME,

352: WHEN G_EXCEPTION_HALT_VALIDATION THEN
353: RETURN x_return_status;
354: WHEN OTHERS THEN
355: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
356: OKL_API.Set_Message(p_app_name => G_APP_NAME,
357: p_msg_name => G_UNEXPECTED_ERROR,
358: p_token1 => G_SQLCODE_TOKEN,
359: p_token1_value => SQLCODE,
360: p_token2 => G_SQLERRM_TOKEN,

Line 371: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

367: FUNCTION validate_hdr_attr_aftimg(
368: p_rulv_rec rulv_rec_type
369: ) RETURN VARCHAR2
370: IS
371: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
372: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
373:
374: BEGIN
375:

Line 372: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

368: p_rulv_rec rulv_rec_type
369: ) RETURN VARCHAR2
370: IS
371: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
372: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
373:
374: BEGIN
375:
376: l_return_status := validate_dup_item(p_rulv_rec => p_rulv_rec);

Line 378: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

374: BEGIN
375:
376: l_return_status := validate_dup_item(p_rulv_rec => p_rulv_rec);
377: --- Store the highest degree of error
378: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
379: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
380: x_return_status := l_return_status;
381: END IF;
382: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 379: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

375:
376: l_return_status := validate_dup_item(p_rulv_rec => p_rulv_rec);
377: --- Store the highest degree of error
378: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
379: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
380: x_return_status := l_return_status;
381: END IF;
382: RAISE G_EXCEPTION_HALT_VALIDATION;
383: END IF;

Line 390: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

386: EXCEPTION
387: WHEN G_EXCEPTION_HALT_VALIDATION THEN
388: RETURN x_return_status;
389: WHEN OTHERS THEN
390: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
391: OKL_API.Set_Message(p_app_name => G_APP_NAME,
392: p_msg_name => G_UNEXPECTED_ERROR,
393: p_token1 => G_SQLCODE_TOKEN,
394: p_token1_value => SQLCODE,

Line 391: OKL_API.Set_Message(p_app_name => G_APP_NAME,

387: WHEN G_EXCEPTION_HALT_VALIDATION THEN
388: RETURN x_return_status;
389: WHEN OTHERS THEN
390: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
391: OKL_API.Set_Message(p_app_name => G_APP_NAME,
392: p_msg_name => G_UNEXPECTED_ERROR,
393: p_token1 => G_SQLCODE_TOKEN,
394: p_token1_value => SQLCODE,
395: p_token2 => G_SQLERRM_TOKEN,

Line 424: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

420: is
421: l_api_name CONSTANT VARCHAR2(30) := 'copy_rulv_rec';
422: l_api_version CONSTANT NUMBER := 1.0;
423: i NUMBER;
424: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
425: l_rgp_id number;
426: l_object1_id1 varchar2(100);
427:
428: cursor c_rgp_id (chr_id number)

Line 445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

441: p_api_version,
442: l_api_name,
443: G_PKG_NAME ))
444: THEN
445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
446: END IF;
447:
448: -- Initialize message list if requested
449: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 454: x_return_status := OKL_API.G_RET_STS_SUCCESS;

450: FND_MSG_PUB.initialize;
451: END IF;
452:
453: -- Initialize API status to success
454: x_return_status := OKL_API.G_RET_STS_SUCCESS;
455:
456:
457: /*** Begin API body ****************************************************/
458:

Line 466: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

462:
463: l_return_status := validate_header_attributes(p_rulv_rec => p_rulv_rec,
464: p_mode => p_mode);
465: --- Store the highest degree of error
466: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
467: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
468: x_return_status := l_return_status;
469: END IF;
470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 467: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

463: l_return_status := validate_header_attributes(p_rulv_rec => p_rulv_rec,
464: p_mode => p_mode);
465: --- Store the highest degree of error
466: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
467: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
468: x_return_status := l_return_status;
469: END IF;
470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: END IF;

Line 470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

466: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
467: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
468: x_return_status := l_return_status;
469: END IF;
470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: END IF;
472:
473: p_rulv_migr_rec.id := p_rulv_rec.id;
474:

Line 515: WHEN OKL_API.G_EXCEPTION_ERROR THEN

511: (p_count => x_msg_count,
512: p_data => x_msg_data);
513:
514: EXCEPTION
515: WHEN OKL_API.G_EXCEPTION_ERROR THEN
516: ROLLBACK TO copy_rulv_rec;
517: x_return_status := OKL_API.G_RET_STS_ERROR;
518: FND_MSG_PUB.Count_And_Get
519: (p_count => x_msg_count,

Line 517: x_return_status := OKL_API.G_RET_STS_ERROR;

513:
514: EXCEPTION
515: WHEN OKL_API.G_EXCEPTION_ERROR THEN
516: ROLLBACK TO copy_rulv_rec;
517: x_return_status := OKL_API.G_RET_STS_ERROR;
518: FND_MSG_PUB.Count_And_Get
519: (p_count => x_msg_count,
520: p_data => x_msg_data);
521:

Line 522: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

518: FND_MSG_PUB.Count_And_Get
519: (p_count => x_msg_count,
520: p_data => x_msg_data);
521:
522: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
523: ROLLBACK TO copy_rulv_rec;
524: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
525: FND_MSG_PUB.Count_And_Get
526: (p_count => x_msg_count,

Line 524: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

520: p_data => x_msg_data);
521:
522: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
523: ROLLBACK TO copy_rulv_rec;
524: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
525: FND_MSG_PUB.Count_And_Get
526: (p_count => x_msg_count,
527: p_data => x_msg_data);
528:

Line 531: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

527: p_data => x_msg_data);
528:
529: WHEN OTHERS THEN
530: ROLLBACK TO copy_rulv_rec;
531: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
532: OKL_API.Set_Message(p_app_name => G_APP_NAME,
533: p_msg_name => G_UNEXPECTED_ERROR,
534: p_token1 => G_SQLCODE_TOKEN,
535: p_token1_value => SQLCODE,

Line 532: OKL_API.Set_Message(p_app_name => G_APP_NAME,

528:
529: WHEN OTHERS THEN
530: ROLLBACK TO copy_rulv_rec;
531: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
532: OKL_API.Set_Message(p_app_name => G_APP_NAME,
533: p_msg_name => G_UNEXPECTED_ERROR,
534: p_token1 => G_SQLCODE_TOKEN,
535: p_token1_value => SQLCODE,
536: p_token2 => G_SQLERRM_TOKEN,

Line 565: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

561: is
562: l_api_name CONSTANT VARCHAR2(30) := 'copy_rulv_tbl';
563: l_api_version CONSTANT NUMBER := 1.0;
564: i NUMBER;
565: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
566:
567: begin
568: -- Set API savepoint
569: SAVEPOINT copy_rulv_tbl;

Line 577: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

573: p_api_version,
574: l_api_name,
575: G_PKG_NAME ))
576: THEN
577: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
578: END IF;
579:
580: -- Initialize message list if requested
581: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 586: x_return_status := OKL_API.G_RET_STS_SUCCESS;

582: FND_MSG_PUB.initialize;
583: END IF;
584:
585: -- Initialize API status to success
586: x_return_status := OKL_API.G_RET_STS_SUCCESS;
587:
588: /*** Begin API body ****************************************************/
589:
590: IF (p_rulv_tbl.COUNT > 0) THEN

Line 624: WHEN OKL_API.G_EXCEPTION_ERROR THEN

620: (p_count => x_msg_count,
621: p_data => x_msg_data);
622:
623: EXCEPTION
624: WHEN OKL_API.G_EXCEPTION_ERROR THEN
625: ROLLBACK TO copy_rulv_tbl;
626: x_return_status := OKL_API.G_RET_STS_ERROR;
627: FND_MSG_PUB.Count_And_Get
628: (p_count => x_msg_count,

Line 626: x_return_status := OKL_API.G_RET_STS_ERROR;

622:
623: EXCEPTION
624: WHEN OKL_API.G_EXCEPTION_ERROR THEN
625: ROLLBACK TO copy_rulv_tbl;
626: x_return_status := OKL_API.G_RET_STS_ERROR;
627: FND_MSG_PUB.Count_And_Get
628: (p_count => x_msg_count,
629: p_data => x_msg_data);
630:

Line 631: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

627: FND_MSG_PUB.Count_And_Get
628: (p_count => x_msg_count,
629: p_data => x_msg_data);
630:
631: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
632: ROLLBACK TO copy_rulv_tbl;
633: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
634: FND_MSG_PUB.Count_And_Get
635: (p_count => x_msg_count,

Line 633: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

629: p_data => x_msg_data);
630:
631: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
632: ROLLBACK TO copy_rulv_tbl;
633: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
634: FND_MSG_PUB.Count_And_Get
635: (p_count => x_msg_count,
636: p_data => x_msg_data);
637:

Line 640: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

636: p_data => x_msg_data);
637:
638: WHEN OTHERS THEN
639: ROLLBACK TO copy_rulv_tbl;
640: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
641: OKL_API.Set_Message(p_app_name => G_APP_NAME,
642: p_msg_name => G_UNEXPECTED_ERROR,
643: p_token1 => G_SQLCODE_TOKEN,
644: p_token1_value => SQLCODE,

Line 641: OKL_API.Set_Message(p_app_name => G_APP_NAME,

637:
638: WHEN OTHERS THEN
639: ROLLBACK TO copy_rulv_tbl;
640: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
641: OKL_API.Set_Message(p_app_name => G_APP_NAME,
642: p_msg_name => G_UNEXPECTED_ERROR,
643: p_token1 => G_SQLCODE_TOKEN,
644: p_token1_value => SQLCODE,
645: p_token2 => G_SQLERRM_TOKEN,

Line 742: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

738: -- End of comments
739: ----------------------------------------------------------------------------------
740: PROCEDURE create_funding_chklst(
741: p_api_version IN NUMBER
742: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
743: ,x_return_status OUT NOCOPY VARCHAR2
744: ,x_msg_count OUT NOCOPY NUMBER
745: ,x_msg_data OUT NOCOPY VARCHAR2
746: ,p_rulv_tbl IN rulv_tbl_type

Line 753: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

749: is
750: l_api_name CONSTANT VARCHAR2(30) := 'create_funding_chklst';
751: l_api_version CONSTANT NUMBER := 1.0;
752: i NUMBER;
753: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
754: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
755: -- xp_rulv_tbl rulv_tbl_type := x_rulv_tbl;
756: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
757: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

Line 793: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

789: p_api_version,
790: l_api_name,
791: G_PKG_NAME ))
792: THEN
793: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
794: END IF;
795:
796: -- Initialize message list if requested
797: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 802: x_return_status := OKL_API.G_RET_STS_SUCCESS;

798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: -- Initialize API status to success
802: x_return_status := OKL_API.G_RET_STS_SUCCESS;
803:
804:
805: /*** Begin API body ****************************************************/
806: --DBMS_OUTPUT.PUT_LINE('before copy_rulv_tbl');

Line 913: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

909: End If;
910:
911: l_return_status := validate_hdr_attr_aftimg(p_rulv_rec => p_rulv_tbl(p_rulv_tbl.FIRST));
912: --- Store the highest degree of error
913: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
914: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
915: x_return_status := l_return_status;
916: END IF;
917: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 914: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

910:
911: l_return_status := validate_hdr_attr_aftimg(p_rulv_rec => p_rulv_tbl(p_rulv_tbl.FIRST));
912: --- Store the highest degree of error
913: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
914: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
915: x_return_status := l_return_status;
916: END IF;
917: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
918: END IF;

Line 917: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

913: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
914: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
915: x_return_status := l_return_status;
916: END IF;
917: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
918: END IF;
919:
920: /*** End API body ******************************************************/
921:

Line 928: WHEN OKL_API.G_EXCEPTION_ERROR THEN

924: (p_count => x_msg_count,
925: p_data => x_msg_data);
926:
927: EXCEPTION
928: WHEN OKL_API.G_EXCEPTION_ERROR THEN
929: ROLLBACK TO create_funding_chklst;
930: x_return_status := OKL_API.G_RET_STS_ERROR;
931: FND_MSG_PUB.Count_And_Get
932: (p_count => x_msg_count,

Line 930: x_return_status := OKL_API.G_RET_STS_ERROR;

926:
927: EXCEPTION
928: WHEN OKL_API.G_EXCEPTION_ERROR THEN
929: ROLLBACK TO create_funding_chklst;
930: x_return_status := OKL_API.G_RET_STS_ERROR;
931: FND_MSG_PUB.Count_And_Get
932: (p_count => x_msg_count,
933: p_data => x_msg_data);
934:

Line 935: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

931: FND_MSG_PUB.Count_And_Get
932: (p_count => x_msg_count,
933: p_data => x_msg_data);
934:
935: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
936: ROLLBACK TO create_funding_chklst;
937: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
938: FND_MSG_PUB.Count_And_Get
939: (p_count => x_msg_count,

Line 937: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

933: p_data => x_msg_data);
934:
935: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
936: ROLLBACK TO create_funding_chklst;
937: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
938: FND_MSG_PUB.Count_And_Get
939: (p_count => x_msg_count,
940: p_data => x_msg_data);
941:

Line 944: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

940: p_data => x_msg_data);
941:
942: WHEN OTHERS THEN
943: ROLLBACK TO create_funding_chklst;
944: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
945: OKL_API.Set_Message(p_app_name => G_APP_NAME,
946: p_msg_name => G_UNEXPECTED_ERROR,
947: p_token1 => G_SQLCODE_TOKEN,
948: p_token1_value => SQLCODE,

Line 945: OKL_API.Set_Message(p_app_name => G_APP_NAME,

941:
942: WHEN OTHERS THEN
943: ROLLBACK TO create_funding_chklst;
944: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
945: OKL_API.Set_Message(p_app_name => G_APP_NAME,
946: p_msg_name => G_UNEXPECTED_ERROR,
947: p_token1 => G_SQLCODE_TOKEN,
948: p_token1_value => SQLCODE,
949: p_token2 => G_SQLERRM_TOKEN,

Line 981: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

977: is
978: l_api_name CONSTANT VARCHAR2(30) := 'update_funding_chklst';
979: l_api_version CONSTANT NUMBER := 1.0;
980: i NUMBER;
981: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
982: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
983: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
984: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
985: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

Line 997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

993: p_api_version,
994: l_api_name,
995: G_PKG_NAME ))
996: THEN
997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
998: END IF;
999:
1000: -- Initialize message list if requested
1001: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 1006: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1002: FND_MSG_PUB.initialize;
1003: END IF;
1004:
1005: -- Initialize API status to success
1006: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1007:
1008:
1009: /*** Begin API body ****************************************************/
1010: --DBMS_OUTPUT.PUT_LINE('before copy_rulv_tbl');

Line 1049: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

1045: End If;
1046:
1047: l_return_status := validate_hdr_attr_aftimg(p_rulv_rec => p_rulv_tbl(p_rulv_tbl.FIRST));
1048: --- Store the highest degree of error
1049: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1050: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: x_return_status := l_return_status;
1052: END IF;
1053: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1050: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1046:
1047: l_return_status := validate_hdr_attr_aftimg(p_rulv_rec => p_rulv_tbl(p_rulv_tbl.FIRST));
1048: --- Store the highest degree of error
1049: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1050: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: x_return_status := l_return_status;
1052: END IF;
1053: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1054: END IF;

Line 1053: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1049: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1050: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: x_return_status := l_return_status;
1052: END IF;
1053: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1054: END IF;
1055:
1056: /*** End API body ******************************************************/
1057:

Line 1064: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1060: (p_count => x_msg_count,
1061: p_data => x_msg_data);
1062:
1063: EXCEPTION
1064: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1065: ROLLBACK TO update_funding_chklst;
1066: x_return_status := OKL_API.G_RET_STS_ERROR;
1067: FND_MSG_PUB.Count_And_Get
1068: (p_count => x_msg_count,

Line 1066: x_return_status := OKL_API.G_RET_STS_ERROR;

1062:
1063: EXCEPTION
1064: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1065: ROLLBACK TO update_funding_chklst;
1066: x_return_status := OKL_API.G_RET_STS_ERROR;
1067: FND_MSG_PUB.Count_And_Get
1068: (p_count => x_msg_count,
1069: p_data => x_msg_data);
1070:

Line 1071: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1067: FND_MSG_PUB.Count_And_Get
1068: (p_count => x_msg_count,
1069: p_data => x_msg_data);
1070:
1071: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1072: ROLLBACK TO update_funding_chklst;
1073: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1074: FND_MSG_PUB.Count_And_Get
1075: (p_count => x_msg_count,

Line 1073: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1069: p_data => x_msg_data);
1070:
1071: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1072: ROLLBACK TO update_funding_chklst;
1073: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1074: FND_MSG_PUB.Count_And_Get
1075: (p_count => x_msg_count,
1076: p_data => x_msg_data);
1077:

Line 1080: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1076: p_data => x_msg_data);
1077:
1078: WHEN OTHERS THEN
1079: ROLLBACK TO update_funding_chklst;
1080: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1081: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1082: p_msg_name => G_UNEXPECTED_ERROR,
1083: p_token1 => G_SQLCODE_TOKEN,
1084: p_token1_value => SQLCODE,

Line 1081: OKL_API.Set_Message(p_app_name => G_APP_NAME,

1077:
1078: WHEN OTHERS THEN
1079: ROLLBACK TO update_funding_chklst;
1080: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1081: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1082: p_msg_name => G_UNEXPECTED_ERROR,
1083: p_token1 => G_SQLCODE_TOKEN,
1084: p_token1_value => SQLCODE,
1085: p_token2 => G_SQLERRM_TOKEN,

Line 1116: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1112: is
1113: l_api_name CONSTANT VARCHAR2(30) := 'delete_funding_chklst';
1114: l_api_version CONSTANT NUMBER := 1.0;
1115: i NUMBER;
1116: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1117: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1118: -- xp_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1119: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1120: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

Line 1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1128: p_api_version,
1129: l_api_name,
1130: G_PKG_NAME ))
1131: THEN
1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: END IF;
1134:
1135: -- Initialize message list if requested
1136: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 1141: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1137: FND_MSG_PUB.initialize;
1138: END IF;
1139:
1140: -- Initialize API status to success
1141: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1142:
1143:
1144: /*** Begin API body ****************************************************/
1145: --DBMS_OUTPUT.PUT_LINE('before copy_rulv_tbl');

Line 1188: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1184: (p_count => x_msg_count,
1185: p_data => x_msg_data);
1186:
1187: EXCEPTION
1188: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1189: ROLLBACK TO delete_funding_chklst;
1190: x_return_status := OKL_API.G_RET_STS_ERROR;
1191: FND_MSG_PUB.Count_And_Get
1192: (p_count => x_msg_count,

Line 1190: x_return_status := OKL_API.G_RET_STS_ERROR;

1186:
1187: EXCEPTION
1188: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1189: ROLLBACK TO delete_funding_chklst;
1190: x_return_status := OKL_API.G_RET_STS_ERROR;
1191: FND_MSG_PUB.Count_And_Get
1192: (p_count => x_msg_count,
1193: p_data => x_msg_data);
1194:

Line 1195: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1191: FND_MSG_PUB.Count_And_Get
1192: (p_count => x_msg_count,
1193: p_data => x_msg_data);
1194:
1195: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1196: ROLLBACK TO delete_funding_chklst;
1197: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1198: FND_MSG_PUB.Count_And_Get
1199: (p_count => x_msg_count,

Line 1197: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1193: p_data => x_msg_data);
1194:
1195: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1196: ROLLBACK TO delete_funding_chklst;
1197: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1198: FND_MSG_PUB.Count_And_Get
1199: (p_count => x_msg_count,
1200: p_data => x_msg_data);
1201:

Line 1204: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1200: p_data => x_msg_data);
1201:
1202: WHEN OTHERS THEN
1203: ROLLBACK TO delete_funding_chklst;
1204: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1205: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1206: p_msg_name => G_UNEXPECTED_ERROR,
1207: p_token1 => G_SQLCODE_TOKEN,
1208: p_token1_value => SQLCODE,

Line 1205: OKL_API.Set_Message(p_app_name => G_APP_NAME,

1201:
1202: WHEN OTHERS THEN
1203: ROLLBACK TO delete_funding_chklst;
1204: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1205: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1206: p_msg_name => G_UNEXPECTED_ERROR,
1207: p_token1 => G_SQLCODE_TOKEN,
1208: p_token1_value => SQLCODE,
1209: p_token2 => G_SQLERRM_TOKEN,

Line 1229: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1225: -- End of comments
1226: ----------------------------------------------------------------------------------
1227: PROCEDURE approve_funding_request(
1228: p_api_version IN NUMBER
1229: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1230: ,x_return_status OUT NOCOPY VARCHAR2
1231: ,x_msg_count OUT NOCOPY NUMBER
1232: ,x_msg_data OUT NOCOPY VARCHAR2
1233: ,p_fund_req_id IN okl_trx_ap_invoices_b.id%TYPE

Line 1239: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1235: is
1236: l_api_name CONSTANT VARCHAR2(30) := 'approve_funding_request';
1237: l_api_version CONSTANT NUMBER := 1.0;
1238: i NUMBER;
1239: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1240: lp_tapv_rec tapv_rec_type;
1241: lx_tapv_rec tapv_rec_type;
1242:
1243: begin

Line 1253: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1249: p_api_version,
1250: l_api_name,
1251: G_PKG_NAME ))
1252: THEN
1253: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1254: END IF;
1255:
1256: -- Initialize message list if requested
1257: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 1262: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1258: FND_MSG_PUB.initialize;
1259: END IF;
1260:
1261: -- Initialize API status to success
1262: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1263:
1264:
1265: /*** Begin API body ****************************************************/
1266:

Line 1281: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1277: x_msg_data => x_msg_data,
1278: p_tapv_rec => lp_tapv_rec,
1279: x_tapv_rec => lx_tapv_rec);
1280:
1281: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1284: RAISE OKL_API.G_EXCEPTION_ERROR;
1285: END IF;

Line 1282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1278: p_tapv_rec => lp_tapv_rec,
1279: x_tapv_rec => lx_tapv_rec);
1280:
1281: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1284: RAISE OKL_API.G_EXCEPTION_ERROR;
1285: END IF;
1286:

Line 1283: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1279: x_tapv_rec => lx_tapv_rec);
1280:
1281: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1284: RAISE OKL_API.G_EXCEPTION_ERROR;
1285: END IF;
1286:
1287: /*** End API body ******************************************************/

Line 1284: RAISE OKL_API.G_EXCEPTION_ERROR;

1280:
1281: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1284: RAISE OKL_API.G_EXCEPTION_ERROR;
1285: END IF;
1286:
1287: /*** End API body ******************************************************/
1288:

Line 1295: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1291: (p_count => x_msg_count,
1292: p_data => x_msg_data);
1293:
1294: EXCEPTION
1295: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1296: ROLLBACK TO approve_funding_request;
1297: x_return_status := OKL_API.G_RET_STS_ERROR;
1298: FND_MSG_PUB.Count_And_Get
1299: (p_count => x_msg_count,

Line 1297: x_return_status := OKL_API.G_RET_STS_ERROR;

1293:
1294: EXCEPTION
1295: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1296: ROLLBACK TO approve_funding_request;
1297: x_return_status := OKL_API.G_RET_STS_ERROR;
1298: FND_MSG_PUB.Count_And_Get
1299: (p_count => x_msg_count,
1300: p_data => x_msg_data);
1301:

Line 1302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1298: FND_MSG_PUB.Count_And_Get
1299: (p_count => x_msg_count,
1300: p_data => x_msg_data);
1301:
1302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1303: ROLLBACK TO approve_funding_request;
1304: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1305: FND_MSG_PUB.Count_And_Get
1306: (p_count => x_msg_count,

Line 1304: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1300: p_data => x_msg_data);
1301:
1302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1303: ROLLBACK TO approve_funding_request;
1304: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1305: FND_MSG_PUB.Count_And_Get
1306: (p_count => x_msg_count,
1307: p_data => x_msg_data);
1308:

Line 1311: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1307: p_data => x_msg_data);
1308:
1309: WHEN OTHERS THEN
1310: ROLLBACK TO approve_funding_request;
1311: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1312: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1313: p_msg_name => G_UNEXPECTED_ERROR,
1314: p_token1 => G_SQLCODE_TOKEN,
1315: p_token1_value => SQLCODE,

Line 1312: OKL_API.Set_Message(p_app_name => G_APP_NAME,

1308:
1309: WHEN OTHERS THEN
1310: ROLLBACK TO approve_funding_request;
1311: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1312: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1313: p_msg_name => G_UNEXPECTED_ERROR,
1314: p_token1 => G_SQLCODE_TOKEN,
1315: p_token1_value => SQLCODE,
1316: p_token2 => G_SQLERRM_TOKEN,

Line 1336: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1332: -- End of comments
1333: ----------------------------------------------------------------------------------
1334: PROCEDURE approve_funding_chklst(
1335: p_api_version IN NUMBER
1336: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1337: ,x_return_status OUT NOCOPY VARCHAR2
1338: ,x_msg_count OUT NOCOPY NUMBER
1339: ,x_msg_data OUT NOCOPY VARCHAR2
1340: ,p_rulv_rec IN rulv_rec_type

Line 1346: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1342: is
1343: l_api_name CONSTANT VARCHAR2(30) := 'approve_funding_chklst';
1344: l_api_version CONSTANT NUMBER := 1.0;
1345: i NUMBER;
1346: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1347:
1348: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1349: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1350: l_id number;

Line 1375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1371: p_api_version,
1372: l_api_name,
1373: G_PKG_NAME ))
1374: THEN
1375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1376: END IF;
1377:
1378: -- Initialize message list if requested
1379: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 1384: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1380: FND_MSG_PUB.initialize;
1381: END IF;
1382:
1383: -- Initialize API status to success
1384: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1385:
1386:
1387: /*** Begin API body ****************************************************/
1388:

Line 1427: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1423: (p_count => x_msg_count,
1424: p_data => x_msg_data);
1425:
1426: EXCEPTION
1427: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1428: ROLLBACK TO approve_funding_chklst;
1429: x_return_status := OKL_API.G_RET_STS_ERROR;
1430: FND_MSG_PUB.Count_And_Get
1431: (p_count => x_msg_count,

Line 1429: x_return_status := OKL_API.G_RET_STS_ERROR;

1425:
1426: EXCEPTION
1427: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1428: ROLLBACK TO approve_funding_chklst;
1429: x_return_status := OKL_API.G_RET_STS_ERROR;
1430: FND_MSG_PUB.Count_And_Get
1431: (p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:

Line 1434: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1430: FND_MSG_PUB.Count_And_Get
1431: (p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:
1434: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1435: ROLLBACK TO approve_funding_chklst;
1436: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1437: FND_MSG_PUB.Count_And_Get
1438: (p_count => x_msg_count,

Line 1436: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1432: p_data => x_msg_data);
1433:
1434: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1435: ROLLBACK TO approve_funding_chklst;
1436: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1437: FND_MSG_PUB.Count_And_Get
1438: (p_count => x_msg_count,
1439: p_data => x_msg_data);
1440:

Line 1443: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

1439: p_data => x_msg_data);
1440:
1441: WHEN OTHERS THEN
1442: ROLLBACK TO approve_funding_chklst;
1443: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1444: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1445: p_msg_name => G_UNEXPECTED_ERROR,
1446: p_token1 => G_SQLCODE_TOKEN,
1447: p_token1_value => SQLCODE,

Line 1444: OKL_API.Set_Message(p_app_name => G_APP_NAME,

1440:
1441: WHEN OTHERS THEN
1442: ROLLBACK TO approve_funding_chklst;
1443: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
1444: OKL_API.Set_Message(p_app_name => G_APP_NAME,
1445: p_msg_name => G_UNEXPECTED_ERROR,
1446: p_token1 => G_SQLCODE_TOKEN,
1447: p_token1_value => SQLCODE,
1448: p_token2 => G_SQLERRM_TOKEN,